Changeset 21568


Ignore:
Timestamp:
2012/03/01 18:39:39 (12 years ago)
Author:
h_yoshimoto
Message:

#1603 dtb_plugin_hookpointのPRIMARY KEY名を修正

Location:
branches/version-2_12-dev/html/install/sql
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_12-dev/html/install/sql/create_table_mysql.sql

    r21565 r21568  
    11411141 
    11421142CREATE TABLE dtb_plugin_hookpoint ( 
    1143     id int NOT NULL, 
     1143    plugin_hookpoint_id int NOT NULL, 
    11441144    plugin_id int NOT NULL, 
    11451145    hook_point text NOT NULL, 
    11461146    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 
    11471147    update_date timestamp NOT NULL, 
    1148     PRIMARY KEY (id) 
     1148    PRIMARY KEY (plugin_hookpoint_id) 
    11491149); 
    11501150 
  • branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql

    r21565 r21568  
    751751    php_path text, 
    752752    deletable_flg smallint NOT NULL DEFAULT 1, 
    753     plugin_id int NOT NULL, 
     753    plugin_id int, 
    754754    PRIMARY KEY (device_type_id, bloc_id), 
    755755    UNIQUE (device_type_id, filename) 
     
    11411141 
    11421142CREATE TABLE dtb_plugin_hookpoint ( 
    1143     id int NOT NULL, 
     1143    plugin_hookpoint_id int NOT NULL, 
    11441144    plugin_id int NOT NULL, 
    11451145    hook_point text NOT NULL, 
    11461146    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 
    11471147    update_date timestamp NOT NULL, 
    1148     PRIMARY KEY (id) 
     1148    PRIMARY KEY (plugin_hookpoint_id) 
    11491149); 
    11501150 
Note: See TracChangeset for help on using the changeset viewer.