From 0c1b2ed127a851d0d6fe768488ca3e46227942ae Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Sat, 19 Sep 2009 10:22:35 +0000 Subject: [PATCH] Removed auto increment on order_no in sales_orders table --- sql/en_US-demo.sql | 2 +- sql/en_US-new.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index ea83c552..2066ceb8 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -1302,7 +1302,7 @@ INSERT INTO `0_sales_order_details` VALUES ('5', '5', '30', '102', '17inch VGA M DROP TABLE IF EXISTS `0_sales_orders`; CREATE TABLE `0_sales_orders` ( - `order_no` int(11) NOT NULL auto_increment, + `order_no` int(11) NOT NULL, `trans_type` smallint(6) NOT NULL default '30', `version` tinyint(1) unsigned NOT NULL default '0', `type` tinyint(1) NOT NULL default '0', diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 5deaf13b..1a230da7 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -1138,7 +1138,7 @@ CREATE TABLE `0_sales_order_details` ( DROP TABLE IF EXISTS `0_sales_orders`; CREATE TABLE `0_sales_orders` ( - `order_no` int(11) NOT NULL auto_increment, + `order_no` int(11) NOT NULL, `trans_type` smallint(6) NOT NULL default '30', `version` tinyint(1) unsigned NOT NULL default '0', `type` tinyint(1) NOT NULL default '0', -- 2.30.2