Changeset 19241

Timestamp:

2010/11/07 00:17:55 (12 years ago)

Author:

nakanishi

Message:

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

File:

• branches/camp/camp-2_5-E/html/install/sql/create_table_pgsql.sql (modified) (1 diff)

branches/camp/camp-2_5-E/html/install/sql/create_table_pgsql.sql

@@ -1262 +1262 @@
 CREATE INDEX dtb_mobile_kara_mail_receive_date_key ON dtb_mobile_kara_mail (receive_date);
 
-DROP TABLE IF EXISTS "dtb_plugin";
 CREATE TABLE "dtb_plugin" (
-    "id" int4 NOT NULL DEFAULT NULL,
-    "name" text NOT NULL DEFAULT NULL,
+    "plugin_id" int4 primary key NOT NULL,
+    "plugin_name" varchar(255) DEFAULT NULL,
     "enable" int2 NOT NULL DEFAULT 0,
     "del_flg" int2 NOT NULL DEFAULT 0,
-    "class_name" text NOT NULL DEFAULT NULL,
+    "class_name" varchar(255) DEFAULT NULL,
     "create_date" timestamp(6) NOT NULL DEFAULT now(),
     "update_date" timestamp(6) NOT NULL DEFAULT now()
-)
-WITH (OIDS=FALSE);
-ALTER TABLE "dtb_plugin" ADD CONSTRAINT "dtb_plugin_pkey" PRIMARY KEY ("id");
+);