Changeset 21458 for branches/version-2_12-dev/html

Timestamp:

2012/02/08 19:48:01 (12 years ago)

Author:

h_yoshimoto

Message:

#1603 #1632 comu-ml:262にて頂いた箇所の修正、不要ディレクトリの削除

Location:

branches/version-2_12-dev/html

Files:

• install/sql/create_table_mysql.sql (modified) (1 diff)
• install/sql/create_table_pgsql.sql (modified) (1 diff)
• plugin (added)

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

@@ -1152 +1152 @@
 
 CREATE TABLE dtb_plugin_hookpoint (
+    id int NOT NULL,
     plugin_id int NOT NULL,
     hook_point varchar(255) NOT NULL,
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-    update_date timestamp NOT NULL
+    update_date timestamp NOT NULL,
+    PRIMARY KEY (id)
 ) ENGINE=InnoDB;
 

branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql

@@ -1152 +1152 @@
 
 CREATE TABLE dtb_plugin_hookpoint (
+    id int NOT NULL,
     plugin_id int NOT NULL,
     hook_point text NOT NULL,
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-    update_date timestamp NOT NULL
+    update_date timestamp NOT NULL,
+    PRIMARY KEY (plugin_id)
 );