Changeset 17087

Timestamp:

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

Author:

Yammy

Message:

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

Location:

branches/comu-ver2/html/install/sql

Files:

• create_table_mysql.sql (modified) (2 diffs)
• drop_table.sql (modified) (1 diff)

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 ;

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

@@ -92 +92 @@
 DROP TABLE mtb_ownersstore_err;
 DROP TABLE mtb_ownersstore_ips;
+DROP TABLE dtb_holiday;