projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Implemented Selectable Print Orientation (Portrait, Landscape) for all reports in...
[fa-stable.git]
/
sql
/
alter2.4.sql
diff --git
a/sql/alter2.4.sql
b/sql/alter2.4.sql
index f89f15c96e289a8955581f0c2600bdb796e7f067..ee77647ad9c810894324f46905152afe4e2552b6 100644
(file)
--- a/
sql/alter2.4.sql
+++ b/
sql/alter2.4.sql
@@
-19,7
+19,7
@@
CREATE TABLE `0_wo_costing` (
`trans_no` int(11) NOT NULL default '0',
`factor` double NOT NULL default '1',
PRIMARY KEY (`id`)
`trans_no` int(11) NOT NULL default '0',
`factor` double NOT NULL default '1',
PRIMARY KEY (`id`)
-)
TYP
E=InnoDB;
+)
ENGIN
E=InnoDB;
UPDATE `0_gl_trans` gl
LEFT JOIN `0_cust_branch` br ON br.receivables_account=gl.account AND br.debtor_no=gl.person_id AND gl.person_type_id=2
UPDATE `0_gl_trans` gl
LEFT JOIN `0_cust_branch` br ON br.receivables_account=gl.account AND br.debtor_no=gl.person_id AND gl.person_type_id=2
@@
-36,7
+36,7
@@
ALTER TABLE `0_tax_groups` DROP COLUMN `tax_shipping`;
ALTER TABLE `0_sales_order_details` ADD KEY `stkcode` (`stk_code`);
ALTER TABLE `0_purch_order_details` ADD KEY `itemcode` (`item_code`);
ALTER TABLE `0_sales_order_details` ADD KEY `stkcode` (`stk_code`);
ALTER TABLE `0_purch_order_details` ADD KEY `itemcode` (`item_code`);
-ALTER TABLE `0_sys_prefs` CHANGE `value` `value` TEXT NOT NULL
DEFAULT ''
;
+ALTER TABLE `0_sys_prefs` CHANGE `value` `value` TEXT NOT NULL;
ALTER TABLE `0_cust_branch` ADD COLUMN `bank_account` varchar(60) DEFAULT NULL AFTER `notes`;
ALTER TABLE `0_debtor_trans` ADD COLUMN `tax_included` tinyint(1) unsigned NOT NULL default '0' AFTER `payment_terms`;
ALTER TABLE `0_cust_branch` ADD COLUMN `bank_account` varchar(60) DEFAULT NULL AFTER `notes`;
ALTER TABLE `0_debtor_trans` ADD COLUMN `tax_included` tinyint(1) unsigned NOT NULL default '0' AFTER `payment_terms`;
@@
-76,3
+76,6
@@
UPDATE `0_security_roles` SET `sections`=CONCAT_WS(';', `sections`, '768'), `are
UPDATE `0_security_roles` SET `areas`=CONCAT_WS(';', `areas`, '775')
WHERE NOT `areas` REGEXP '[^0-9]?775[^0-9]?';
UPDATE `0_security_roles` SET `areas`=CONCAT_WS(';', `areas`, '775')
WHERE NOT `areas` REGEXP '[^0-9]?775[^0-9]?';
+
+ALTER TABLE `0_stock_master` ADD COLUMN `no_purchase` tinyint(1) NOT NULL default '0' AFTER `no_sale`;
+ALTER TABLE `0_stock_category` ADD COLUMN `dflt_no_purchase` tinyint(1) NOT NULL default '0' AFTER `dflt_no_sale`;