From 927ebef2443b6dda544056e33ec84b71d2bdb6c2 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Thu, 19 Feb 2015 22:40:57 +0100 Subject: [PATCH] Changes in db scheme: gl_trans.type_no optimized to int, changed lock_stock.reorder_level type to double. --- sql/alter2.4.sql | 3 +++ sql/en_US-demo.sql | 4 ++-- sql/en_US-new.sql | 4 ++-- 3 files changed, 7 insertions(+), 4 deletions(-) diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql index 1ab1effb..b250e04a 100644 --- a/sql/alter2.4.sql +++ b/sql/alter2.4.sql @@ -139,3 +139,6 @@ ALTER TABLE `0_tag_associations` ENGINE=InnoDB; ALTER TABLE `0_useronline` ENGINE=InnoDB; ALTER TABLE `0_users` ENGINE=InnoDB; ALTER TABLE `0_workcentres` ENGINE=InnoDB; + +ALTER TABLE `0_gl_trans` CHANGE `type_no` `type_no` int(11) NOT NULL default '0'; +ALTER TABLE `0_loc_stock` CHANGE `reorder_level` `reorder_level` double NOT NULL default '0'; diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index e5250f5a..7e23a8ed 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -833,7 +833,7 @@ DROP TABLE IF EXISTS `0_gl_trans`; CREATE TABLE IF NOT EXISTS `0_gl_trans` ( `counter` int(11) NOT NULL auto_increment, `type` smallint(6) NOT NULL default '0', - `type_no` bigint(16) NOT NULL default '1', + `type_no` `type_no` int(11) NOT NULL default '0', `tran_date` date NOT NULL default '0000-00-00', `account` varchar(15) NOT NULL default '', `memo_` tinytext NOT NULL, @@ -1144,7 +1144,7 @@ DROP TABLE IF EXISTS `0_loc_stock`; CREATE TABLE IF NOT EXISTS `0_loc_stock` ( `loc_code` char(5) NOT NULL default '', `stock_id` char(20) NOT NULL default '', - `reorder_level` bigint(20) NOT NULL default '0', + `reorder_level` double NOT NULL default '0', PRIMARY KEY (`loc_code`,`stock_id`), KEY `stock_id` (`stock_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 341cb1e4..3012d757 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -771,7 +771,7 @@ DROP TABLE IF EXISTS `0_gl_trans`; CREATE TABLE IF NOT EXISTS `0_gl_trans` ( `counter` int(11) NOT NULL auto_increment, `type` smallint(6) NOT NULL default '0', - `type_no` bigint(16) NOT NULL default '1', + `type_no` int(11) NOT NULL default '0', `tran_date` date NOT NULL default '0000-00-00', `account` varchar(15) NOT NULL default '', `memo_` tinytext NOT NULL, @@ -990,7 +990,7 @@ DROP TABLE IF EXISTS `0_loc_stock`; CREATE TABLE IF NOT EXISTS `0_loc_stock` ( `loc_code` char(5) NOT NULL default '', `stock_id` char(20) NOT NULL default '', - `reorder_level` bigint(20) NOT NULL default '0', + `reorder_level` double NOT NULL default '0', PRIMARY KEY (`loc_code`,`stock_id`), KEY `stock_id` (`stock_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.30.2