Changeset 17268 for branches/comu-ver2/html/install/sql/create_table_mysql.sql

Timestamp:

2008/04/18 09:45:52 (16 years ago)

Author:

miningbrownie

Message:

MySQL用のメーカテーブルにて
MySQLでDEFAULT NOW()は使用できないのでDEFAULT句を削除
dtb_customer_favorite_productsのSQL文法エラー修正
dtb_maker,dtb_maker_count,dtb_customer_favorite_products
のDROPが無かったので追加

File:

• branches/comu-ver2/html/install/sql/create_table_mysql.sql (modified) (3 diffs)

branches/comu-ver2/html/install/sql/create_table_mysql.sql

@@ -468 +468 @@
     product_id int NOT NULL,
     create_date datetime NOT NULL,
-    update_date datetime NOT NULL,
+    update_date datetime NOT NULL
 ) TYPE=InnoDB ;
 
@@ -953 +953 @@
 
 CREATE TABLE dtb_maker (
-    maker_id auto_increment primary keyl,
+    maker_id INT auto_increment primary key,
     name text NOT NULL,
     rank int NOT NULL DEFAULT 0,
     creator_id int NOT NULL,
-    create_date datetime NOT NULL DEFAULT now(),
+    create_date datetime NOT NULL,
     update_date datetime NOT NULL,
     del_flg  smallint NOT NULL DEFAULT 0
@@ -965 +965 @@
     maker_id int NOT NULL,
     product_count int NOT NULL,
-    create_date datetime NOT NULL DEFAULT Now()
+    create_date datetime NOT NULL
 ) TYPE=InnoDB ;