Changeset 21364 for branches/version-2_11-dev/html/install/sql/create_table_mysql.sql

Timestamp:

2011/12/08 11:34:26 (15 years ago)

Author:

habu

Message:

#1571(dtb_mailtemplateにプライマリキーが無い)

File:

• branches/version-2_11-dev/html/install/sql/create_table_mysql.sql (modified) (1 diff)

branches/version-2_11-dev/html/install/sql/create_table_mysql.sql

@@ -222 +222 @@
     del_flg smallint NOT NULL DEFAULT 0,
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-    update_date timestamp NOT NULL
+    update_date timestamp NOT NULL,
+    PRIMARY KEY (template_id)
 ) ENGINE=InnoDB;