From c7980e3a02a156b1a83f9b2820d6b27aba9c5dad Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Tue, 26 Jan 2010 14:16:40 +0000 Subject: [PATCH] Added 'editable' field in stock_master --- sql/alter2.3.sql | 1 + sql/en_US-demo.sql | 11 ++++++----- sql/en_US-new.sql | 1 + 3 files changed, 8 insertions(+), 5 deletions(-) diff --git a/sql/alter2.3.sql b/sql/alter2.3.sql index 84bea831..ff1e9c99 100644 --- a/sql/alter2.3.sql +++ b/sql/alter2.3.sql @@ -112,3 +112,4 @@ 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'; diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index 1e9d9255..95eed1ae 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -1558,17 +1558,18 @@ CREATE TABLE `0_stock_master` ( `overhead_cost` double NOT NULL default '0', `inactive` tinyint(1) NOT NULL default '0', `no_sale` tinyint(1) NOT NULL default '0', + `editable` tinyint(1) NOT NULL default '0', PRIMARY KEY (`stock_id`) ) TYPE=InnoDB ; ### Data of table `0_stock_master` ### -INSERT INTO `0_stock_master` VALUES ('102', '1', '1', '17inch VGA Monitor', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '10', '0', '0', '0', '0'); -INSERT INTO `0_stock_master` VALUES ('103', '1', '1', '32MB VGA Card', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '11', '0', '0', '0', '0'); -INSERT INTO `0_stock_master` VALUES ('104', '1', '1', '52x CD Drive', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '12', '0', '0', '0', '0'); -INSERT INTO `0_stock_master` VALUES ('201', '4', '1', 'Assembly Labour', '', 'hrs', 'D', '4010', '5010', '5010', '5040', '1530', '0', '0', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `0_stock_master` VALUES ('3400', '3', '1', 'P4 Business System', '', 'ea.', 'M', '4010', '5010', '1540', '5040', '1530', '0', '0', '0', '0', '33', '3.9999999999999', '2', '0', '0'); +INSERT INTO `0_stock_master` VALUES ('102', '1', '1', '17inch VGA Monitor', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '10', '0', '0', '0', '0', '0'); +INSERT INTO `0_stock_master` VALUES ('103', '1', '1', '32MB VGA Card', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '11', '0', '0', '0', '0', '0'); +INSERT INTO `0_stock_master` VALUES ('104', '1', '1', '52x CD Drive', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '12', '0', '0', '0', '0', '0'); +INSERT INTO `0_stock_master` VALUES ('201', '4', '1', 'Assembly Labour', '', 'hrs', 'D', '4010', '5010', '5010', '5040', '1530', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); +INSERT INTO `0_stock_master` VALUES ('3400', '3', '1', 'P4 Business System', '', 'ea.', 'M', '4010', '5010', '1540', '5040', '1530', '0', '0', '0', '0', '33', '3.9999999999999', '2', '0', '0', '0'); ### Structure of table `0_stock_moves` ### diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 921ac774..1a2d43cc 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -1390,6 +1390,7 @@ CREATE TABLE `0_stock_master` ( `overhead_cost` double NOT NULL default '0', `inactive` tinyint(1) NOT NULL default '0', `no_sale` tinyint(1) NOT NULL default '0', + `editable` tinyint(1) NOT NULL default '0', PRIMARY KEY (`stock_id`) ) TYPE=InnoDB ; -- 2.30.2