Changeset 19208


Ignore:
Timestamp:
2010/11/07 00:06:23 (12 years ago)
Author:
miningbrownie
Message:
 
File:
1 edited

Legend:

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

    r18882 r19208  
    12491249) TYPE=InnoDB; 
    12501250 
     1251 
     1252CREATE TABLE "dtb_plugin" ( 
     1253  "id" int4 NOT NULL DEFAULT NULL, 
     1254  "name" text NOT NULL DEFAULT NULL, 
     1255  "enable" int2 NOT NULL DEFAULT 0, 
     1256  "del_flg" int2 NOT NULL DEFAULT 0, 
     1257  "class_name" text NOT NULL DEFAULT NULL, 
     1258  "create_date" timestamp(6) NOT NULL DEFAULT now(), 
     1259  "update_date" timestamp(6) NOT NULL DEFAULT now() 
     1260) 
     1261WITH (OIDS=FALSE); 
     1262ALTER TABLE "dtb_plugin" ADD CONSTRAINT "dtb_plugin_pkey" PRIMARY KEY ("id"); 
     1263 
     1264 
    12511265CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64)); 
    12521266CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class(product_id); 
Note: See TracChangeset for help on using the changeset viewer.