Changeset 19241


Ignore:
Timestamp:
2010/11/07 00:17:55 (12 years ago)
Author:
nakanishi
Message:

テーブル追加用SQLの修正。

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/camp/camp-2_5-E/html/install/sql/create_table_pgsql.sql

    r19184 r19241  
    12621262CREATE INDEX dtb_mobile_kara_mail_receive_date_key ON dtb_mobile_kara_mail (receive_date); 
    12631263 
    1264 DROP TABLE IF EXISTS "dtb_plugin"; 
    12651264CREATE TABLE "dtb_plugin" ( 
    1266     "id" int4 NOT NULL DEFAULT NULL, 
    1267     "name" text NOT NULL DEFAULT NULL, 
     1265    "plugin_id" int4 primary key NOT NULL, 
     1266    "plugin_name" varchar(255) DEFAULT NULL, 
    12681267    "enable" int2 NOT NULL DEFAULT 0, 
    12691268    "del_flg" int2 NOT NULL DEFAULT 0, 
    1270     "class_name" text NOT NULL DEFAULT NULL, 
     1269    "class_name" varchar(255) DEFAULT NULL, 
    12711270    "create_date" timestamp(6) NOT NULL DEFAULT now(), 
    12721271    "update_date" timestamp(6) NOT NULL DEFAULT now() 
    1273 ) 
    1274 WITH (OIDS=FALSE); 
    1275 ALTER TABLE "dtb_plugin" ADD CONSTRAINT "dtb_plugin_pkey" PRIMARY KEY ("id"); 
     1272); 
Note: See TracChangeset for help on using the changeset viewer.