From 51dc5ea086e4b46832780e618b58456b421d7daf Mon Sep 17 00:00:00 2001 From: Joe Date: Tue, 31 Dec 2013 00:58:02 +0100 Subject: [PATCH] Changed query_size in users table to unsigned tinyint(1) --- sql/alter2.4.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql index ee77647a..e9d79cbe 100644 --- a/sql/alter2.4.sql +++ b/sql/alter2.4.sql @@ -79,3 +79,4 @@ UPDATE `0_security_roles` SET `areas`=CONCAT_WS(';', `areas`, '775') 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`; +ALTER TABLE `0_users` CHANGE `query_size` `query_size` TINYINT(1) UNSIGNED NOT NULL DEFAULT 10; \ No newline at end of file -- 2.30.2