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

Timestamp:

2008/02/27 19:26:23 (16 years ago)

Author:

Yammy

Message:

定休日テーブル用のMySQLのSQL修正

File:

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

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

@@ -26 +26 @@
 
 CREATE TABLE dtb_holiday (
-    holiday_id auto_increment primary key NOT NULL,
+    holiday_id int auto_increment primary key NOT NULL,
     title text NOT NULL,
     month smallint NOT NULL,
@@ -33 +33 @@
     creator_id int NOT NULL,
     create_date datetime NOT NULL,
-    update_date datetimep NOT NULL,
+    update_date datetime NOT NULL,
     del_flg  smallint NOT NULL DEFAULT 0
 ) TYPE=InnoDB ;