- 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_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)
Note: See TracChangeset
for help on using the changeset viewer.