- Timestamp:
- 2010/12/17 03:22:08 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql
r19733 r19736 850 850 ); 851 851 852 create tabledtb_templates (852 CREATE TABLE dtb_templates ( 853 853 template_code text NOT NULL, 854 854 template_name text, … … 858 858 ); 859 859 860 create tabledtb_table_comment (860 CREATE TABLE dtb_table_comment ( 861 861 id int, 862 862 table_name text, … … 1158 1158 1159 1159 CREATE TABLE mtb_product_type ( 1160 id int2,1161 name text, 1162 rank int2NOT NULL,1160 id smallint, 1161 name text, 1162 rank smallint NOT NULL, 1163 1163 PRIMARY KEY (id) 1164 1164 ); 1165 1165 1166 1166 CREATE TABLE mtb_device_type ( 1167 id int2,1168 name text, 1169 rank int2NOT NULL,1167 id smallint, 1168 name text, 1169 rank smallint NOT NULL, 1170 1170 PRIMARY KEY (id) 1171 1171 ); … … 1189 1189 ); 1190 1190 1191 CREATE TABLE dtb_module ( 1192 module_id int NOT NULL UNIQUE, 1193 module_code text NOT NULL, 1194 module_name text NOT NULL, 1195 sub_data text, 1196 auto_update_flg smallint NOT NULL DEFAULT 0, 1197 del_flg smallint NOT NULL DEFAULT 0, 1198 create_date timestamp NOT NULL DEFAULT NOW(), 1199 update_date timestamp NOT NULL 1200 ); 1201 1191 1202 CREATE TABLE dtb_session ( 1192 1203 sess_id text NOT NULL, … … 1197 1208 ); 1198 1209 1199 CREATE TABLE dtb_module (1200 module_id int NOT NULL UNIQUE,1201 module_code text NOT NULL,1202 module_name text NOT NULL,1203 sub_data text,1204 auto_update_flg int2 NOT NULL DEFAULT 0,1205 del_flg int2 NOT NULL DEFAULT 0,1206 create_date timestamp NOT NULL DEFAULT NOW(),1207 update_date timestamp NOT NULL1208 );1209 1210 1210 CREATE TABLE dtb_site_control ( 1211 control_id int primary key NOT NULL, 1212 control_title text , 1213 control_text text , 1214 control_flg int2 NOT NULL DEFAULT 2, 1215 del_flg int2 NOT NULL DEFAULT 0, 1216 memo text , 1217 create_date timestamp NOT NULL DEFAULT now(), 1218 update_date timestamp NOT NULL DEFAULT now() 1211 control_id int NOT NULL, 1212 control_title text, 1213 control_text text, 1214 control_flg smallint NOT NULL DEFAULT 2, 1215 del_flg smallint NOT NULL DEFAULT 0, 1216 memo text, 1217 create_date timestamp NOT NULL DEFAULT now(), 1218 update_date timestamp NOT NULL DEFAULT now(), 1219 PRIMARY KEY (control_id) 1219 1220 ); 1220 1221 1221 1222 CREATE TABLE dtb_trackback ( 1222 trackback_id int primary keyNOT NULL,1223 trackback_id int NOT NULL, 1223 1224 product_id int NOT NULL, 1224 blog_name varchar(255) NOT NULL DEFAULT '',1225 title varchar(255) NOT NULL DEFAULT '',1226 excerpt text NOT NULL DEFAULT '',1227 url text NOT NULL DEFAULT '',1228 status int2NOT NULL DEFAULT 2,1229 del_flg int2NOT NULL DEFAULT 0,1225 blog_name text NOT NULL, 1226 title text NOT NULL, 1227 excerpt text NOT NULL, 1228 url text NOT NULL, 1229 status smallint NOT NULL DEFAULT 2, 1230 del_flg smallint NOT NULL DEFAULT 0, 1230 1231 create_date timestamp NOT NULL, 1231 update_date timestamp NOT NULL 1232 update_date timestamp NOT NULL, 1233 PRIMARY KEY (trackback_id) 1232 1234 ); 1233 1235 1234 1236 CREATE TABLE dtb_bkup ( 1235 bkup_name varchar(50),1237 bkup_name text, 1236 1238 bkup_memo text, 1237 1239 create_date timestamp, 1238 1240 PRIMARY KEY (bkup_name) 1241 ); 1242 1243 CREATE TABLE dtb_plugin ( 1244 plugin_id int NOT NULL, 1245 plugin_name text NOT NULL, 1246 enable smallint NOT NULL DEFAULT 0, 1247 del_flg smallint NOT NULL DEFAULT 0, 1248 class_name text NOT NULL, 1249 create_date timestamp NOT NULL DEFAULT now(), 1250 update_date timestamp NOT NULL DEFAULT now(), 1251 PRIMARY KEY (plugin_id) 1239 1252 ); 1240 1253 … … 1253 1266 CREATE INDEX dtb_mobile_kara_mail_receive_date_key ON dtb_mobile_kara_mail (receive_date); 1254 1267 1255 CREATE TABLE dtb_plugin (1256 plugin_id int NOT NULL,1257 plugin_name varchar(255) DEFAULT NULL,1258 enable int2 NOT NULL DEFAULT 0,1259 del_flg int2 NOT NULL DEFAULT 0,1260 class_name varchar(255) DEFAULT NULL,1261 create_date timestamp NOT NULL DEFAULT now(),1262 update_date timestamp NOT NULL DEFAULT now(),1263 PRIMARY KEY (plugin_id)1264 );1265 1266 1268 CREATE TABLE dtb_index_list ( 1267 table_name varchar(30)NOT NULL DEFAULT '',1268 column_name varchar(30)NOT NULL DEFAULT '',1269 recommend_flg int2NOT NULL DEFAULT 0,1269 table_name text NOT NULL DEFAULT '', 1270 column_name text NOT NULL DEFAULT '', 1271 recommend_flg smallint NOT NULL DEFAULT 0, 1270 1272 recommend_comment text, 1271 1273 PRIMARY KEY (table_name, column_name)
Note: See TracChangeset
for help on using the changeset viewer.