Changeset 19736
- Timestamp:
- 2010/12/17 03:22:08 (11 years ago)
- Location:
- branches/version-2_5-dev/html/install/sql
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/html/install/sql/create_table_mysql.sql
r19733 r19736 315 315 product_id int NOT NULL, 316 316 class_combination_id int, 317 product_type_id smallint NOT NULL DEFAULT 0,317 product_type_id int NOT NULL DEFAULT 0, 318 318 product_code text, 319 319 stock numeric, … … 822 822 bloc_id int NOT NULL, 823 823 bloc_row int, 824 anywhere int DEFAULT 0 NOT NULL,824 anywhere smallint DEFAULT 0 NOT NULL, 825 825 PRIMARY KEY (device_type_id, page_id, target_id, bloc_id) 826 826 ) TYPE=InnoDB; 827 827 828 828 CREATE TABLE dtb_csv ( 829 no int 829 no int, 830 830 csv_id int NOT NULL, 831 831 col text, … … 840 840 841 841 CREATE TABLE dtb_csv_sql ( 842 sql_id int 842 sql_id int, 843 843 sql_name text NOT NULL, 844 844 csv_sql text, … … 848 848 ) TYPE=InnoDB; 849 849 850 CREATE TABLE dtb_templates 851 ( 850 CREATE TABLE dtb_templates ( 852 851 template_code varchar(50) NOT NULL, 853 852 template_name text, … … 857 856 ) TYPE=InnoDB; 858 857 859 CREATE TABLE dtb_table_comment 860 ( 861 id int , 858 CREATE TABLE dtb_table_comment ( 859 id int, 862 860 table_name text, 863 861 column_name text, … … 867 865 868 866 CREATE TABLE dtb_maker ( 869 maker_id int ,867 maker_id int NOT NULL, 870 868 name text NOT NULL, 871 869 rank int NOT NULL DEFAULT 0, … … 1159 1157 1160 1158 CREATE TABLE mtb_product_type ( 1161 id int2,1162 name text, 1163 rank int2NOT NULL,1159 id smallint, 1160 name text, 1161 rank smallint NOT NULL, 1164 1162 PRIMARY KEY (id) 1165 1163 ) TYPE=InnoDB; 1166 1164 1167 1165 CREATE TABLE mtb_device_type ( 1168 id int2,1169 name text, 1170 rank int2NOT NULL,1166 id smallint, 1167 name text, 1168 rank smallint NOT NULL, 1171 1169 PRIMARY KEY (id) 1172 1170 ) TYPE=InnoDB; … … 1197 1195 auto_update_flg smallint NOT NULL DEFAULT 0, 1198 1196 del_flg smallint NOT NULL DEFAULT 0, 1199 create_date datetime NOT NULL 1197 create_date datetime NOT NULL, 1200 1198 update_date datetime NOT NULL 1201 1199 ) TYPE=InnoDB; … … 1210 1208 1211 1209 CREATE TABLE dtb_site_control ( 1212 control_id int 1213 control_title varchar(255) 1214 control_text text 1215 control_flg int NOT NULL DEFAULT 2,1216 del_flg int NOT NULL DEFAULT 0,1217 memo text 1218 create_date datetime NOT NULL, 1219 update_date datetime NOT NULL, 1220 PRIMARY KEY 1210 control_id int NOT NULL, 1211 control_title varchar(255), 1212 control_text text, 1213 control_flg smallint NOT NULL DEFAULT 2, 1214 del_flg smallint NOT NULL DEFAULT 0, 1215 memo text, 1216 create_date datetime NOT NULL, 1217 update_date datetime NOT NULL, 1218 PRIMARY KEY (control_id) 1221 1219 ) TYPE=InnoDB; 1222 1220 … … 1224 1222 trackback_id int NOT NULL, 1225 1223 product_id int NOT NULL, 1226 blog_name varchar(255) NOT NULL DEFAULT '',1227 title varchar(255) NOT NULL DEFAULT '',1228 excerpt text NOT NULL 1229 url text NOT NULL 1230 status int NOT NULL DEFAULT 2,1231 del_flg int NOT NULL DEFAULT 0,1224 blog_name varchar(255) NOT NULL, 1225 title varchar(255) NOT NULL, 1226 excerpt text NOT NULL, 1227 url text NOT NULL, 1228 status smallint NOT NULL DEFAULT 2, 1229 del_flg smallint NOT NULL DEFAULT 0, 1232 1230 create_date datetime NOT NULL, 1233 1231 update_date datetime NOT NULL, … … 1244 1242 CREATE TABLE dtb_plugin ( 1245 1243 plugin_id int NOT NULL, 1246 plugin_name varchar(255) NOT NULL DEFAULT '',1247 enable int2NOT NULL DEFAULT 0,1248 del_flg int2NOT NULL DEFAULT 0,1249 class_name varchar(255) NOT NULL DEFAULT '',1244 plugin_name varchar(255) NOT NULL, 1245 enable smallint NOT NULL DEFAULT 0, 1246 del_flg smallint NOT NULL DEFAULT 0, 1247 class_name varchar(255) NOT NULL, 1250 1248 create_date datetime NOT NULL, 1251 1249 update_date datetime NOT NULL, … … 1268 1266 table_name varchar(30) NOT NULL DEFAULT '', 1269 1267 column_name varchar(30) NOT NULL DEFAULT '', 1270 recommend_flg int2NOT NULL DEFAULT 0,1268 recommend_flg smallint NOT NULL DEFAULT 0, 1271 1269 recommend_comment text, 1272 1270 PRIMARY KEY (table_name, column_name) -
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.