[Svn-src-all:2669] [version-2_12-dev 21568] #1603 dtb_plugin_hookpointのPRIMARY KEY名を修正

h_yoshimoto admin @ mail.ec-cube.net
2012年 3月 1日 (木) 18:39:40 JST


Subversion committed to /home/svn/open 21568
http://svn.ec-cube.net/open_trac/changeset/21568
┌────────────────────────────┐
│更新者 :  h_yoshimoto                                  │
│更新日時:  2012-03-01 18:39:39 +0900 (木, 01  3月 2012)│
└────────────────────────────┘

Log:
--------------------------------------------------------
#1603 dtb_plugin_hookpointのPRIMARY KEY名を修正

Changed:                      [U:修正,A:追加,D:削除]
--------------------------------------------------------
U   branches/version-2_12-dev/html/install/sql/create_table_mysql.sql
U   branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql

変更: branches/version-2_12-dev/html/install/sql/create_table_mysql.sql
===================================================================
--- branches/version-2_12-dev/html/install/sql/create_table_mysql.sql	2012-03-01 08:02:13 UTC (rev 21567)
+++ branches/version-2_12-dev/html/install/sql/create_table_mysql.sql	2012-03-01 09:39:39 UTC (rev 21568)
@@ -1140,12 +1140,12 @@
 );
 
 CREATE TABLE dtb_plugin_hookpoint (
-    id int NOT NULL,
+    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,
-    PRIMARY KEY (id)
+    PRIMARY KEY (plugin_hookpoint_id)
 );
 
 CREATE TABLE dtb_index_list (

変更: branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql
===================================================================
--- branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql	2012-03-01 08:02:13 UTC (rev 21567)
+++ branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql	2012-03-01 09:39:39 UTC (rev 21568)
@@ -750,7 +750,7 @@
     update_date timestamp NOT NULL,
     php_path text,
     deletable_flg smallint NOT NULL DEFAULT 1,
-    plugin_id int NOT NULL,
+    plugin_id int,
     PRIMARY KEY (device_type_id, bloc_id),
     UNIQUE (device_type_id, filename)
 );
@@ -1140,12 +1140,12 @@
 );
 
 CREATE TABLE dtb_plugin_hookpoint (
-    id int NOT NULL,
+    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,
-    PRIMARY KEY (id)
+    PRIMARY KEY (plugin_hookpoint_id)
 );
 
 CREATE TABLE dtb_index_list (




Svn-src-all メーリングリストの案内