Editable sales terms in sales orders and invoices.

[fa-stable.git] / sql / alter2.3.sql

diff --git a/sql/alter2.3.sql b/sql/alter2.3.sql
index 84bea8314f067440789b20c63820328df9a6cba2..94ae34e64f77c7c41d1dceb618d9e0cac1f2d5b6 100644 (file)
--- a/sql/alter2.3.sql
+++ b/sql/alter2.3.sql
@@ -112,3 +112,6 @@ INSERT INTO `0_sys_prefs` SELECT 'default_workorder_required','glsetup.manuf', '
 #INSERT INTO `0_sys_prefs` SELECT 'payroll_act','glsetup.payroll', 'varchar','11', c.payroll_act FROM `0_company` c;
 INSERT INTO `0_sys_prefs` SELECT 'version_id', 'system', 'varchar', '11', c.version_id FROM `0_company` c;
 
+ALTER TABLE `0_stock_master` ADD COLUMN `editable` TINYINT(1) NOT NULL default '0';
+ALTER TABLE `0_debtor_trans` ADD COLUMN `payment_terms` int(11) default NULL;
+ALTER TABLE `0_sales_orders` ADD COLUMN `payment_terms` int(11) default NULL;