- Timestamp:
- 2011/01/02 00:17:14 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/html/install/sql/create_table_mysql.sql
r19781 r19808 6 6 error text, 7 7 ok text, 8 create_date datetime NOT NULL,9 update_date datetimeNOT NULL,8 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 9 update_date timestamp NOT NULL, 10 10 PRIMARY KEY (log_id) 11 11 ) TYPE=InnoDB; … … 21 21 rank int NOT NULL DEFAULT 0, 22 22 creator_id int NOT NULL, 23 create_date datetime NOT NULL,24 update_date datetimeNOT NULL,23 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 24 update_date timestamp NOT NULL, 25 25 del_flg smallint NOT NULL DEFAULT 0, 26 26 PRIMARY KEY (kiyaku_id) … … 34 34 rank int NOT NULL DEFAULT 0, 35 35 creator_id int NOT NULL, 36 create_date datetime NOT NULL,37 update_date datetimeNOT NULL,36 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 37 update_date timestamp NOT NULL, 38 38 del_flg smallint NOT NULL DEFAULT 0, 39 39 PRIMARY KEY (holiday_id) … … 66 66 member smallint, 67 67 order_date datetime, 68 create_date datetime NOT NULL68 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 69 69 ) TYPE=InnoDB; 70 70 … … 81 81 other_files text, 82 82 del_flg smallint NOT NULL DEFAULT 0, 83 create_date datetime NOT NULL,84 update_date datetime,83 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 84 update_date timestamp NOT NULL, 85 85 release_date datetime NOT NULL, 86 86 PRIMARY KEY (module_id) … … 140 140 point_rate numeric NOT NULL DEFAULT 0, 141 141 welcome_point numeric NOT NULL DEFAULT 0, 142 update_date datetime,142 update_date timestamp NOT NULL, 143 143 top_tpl text, 144 144 product_tpl text, … … 164 164 del_flg smallint NOT NULL DEFAULT 0, 165 165 creator_id int NOT NULL, 166 create_date datetime NOT NULL,167 update_date datetime,166 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 167 update_date timestamp NOT NULL, 168 168 PRIMARY KEY (deliv_id) 169 169 ) TYPE=InnoDB; … … 195 195 del_flg smallint NOT NULL DEFAULT 0, 196 196 creator_id int NOT NULL, 197 create_date datetime NOT NULL,198 update_date datetime,197 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 198 update_date timestamp NOT NULL, 199 199 payment_image text, 200 200 upper_rule numeric, … … 231 231 creator_id int NOT NULL, 232 232 del_flg smallint NOT NULL DEFAULT 0, 233 create_date datetime NOT NULL,234 update_date datetimeNOT NULL233 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 234 update_date timestamp NOT NULL 235 235 ) TYPE=InnoDB; 236 236 … … 247 247 del_flg smallint NOT NULL DEFAULT 0, 248 248 creator_id int NOT NULL, 249 create_date datetime NOT NULL,250 update_date datetimeNOT NULL,249 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 250 update_date timestamp NOT NULL, 251 251 PRIMARY KEY (send_id) 252 252 ) TYPE=InnoDB; … … 304 304 del_flg smallint NOT NULL DEFAULT 0, 305 305 creator_id int NOT NULL, 306 create_date datetime NOT NULL,307 update_date datetime,306 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 307 update_date timestamp NOT NULL, 308 308 deliv_date_id int, 309 309 PRIMARY KEY (product_id) … … 324 324 point_rate numeric, 325 325 creator_id int NOT NULL, 326 create_date datetime NOT NULL,327 update_date datetime,326 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 327 update_date timestamp NOT NULL, 328 328 down_filename text, 329 329 down_realfilename text, … … 337 337 rank int, 338 338 creator_id int NOT NULL, 339 create_date datetime NOT NULL,340 update_date datetime,339 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 340 update_date timestamp NOT NULL, 341 341 del_flg smallint NOT NULL DEFAULT 0, 342 342 PRIMARY KEY (class_id) … … 349 349 rank int, 350 350 creator_id int NOT NULL, 351 create_date datetime NOT NULL,352 update_date datetime,351 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 352 update_date timestamp NOT NULL, 353 353 del_flg smallint NOT NULL DEFAULT 0, 354 354 PRIMARY KEY (classcategory_id) … … 370 370 rank int, 371 371 creator_id int NOT NULL, 372 create_date datetime NOT NULL,373 update_date datetime,372 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 373 update_date timestamp NOT NULL, 374 374 del_flg smallint NOT NULL DEFAULT 0, 375 375 PRIMARY KEY (category_id) … … 387 387 product_id int NOT NULL, 388 388 creator_id int NOT NULL, 389 create_date datetime NOT NULL,390 update_date datetime,389 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 390 update_date timestamp NOT NULL, 391 391 del_flg smallint NOT NULL DEFAULT 0, 392 392 PRIMARY KEY(product_status_id, product_id) … … 406 406 total_average numeric NOT NULL DEFAULT 0, 407 407 order_date datetime NOT NULL, 408 create_date datetime NOT NULL,408 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 409 409 year smallint NOT NULL, 410 410 month smallint NOT NULL, … … 431 431 hour smallint NOT NULL DEFAULT 0, 432 432 order_date datetime, 433 create_date datetime NOT NULL433 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 434 434 ) TYPE=InnoDB; 435 435 … … 441 441 status smallint NOT NULL DEFAULT 0, 442 442 creator_id int NOT NULL, 443 create_date datetime NOT NULL,444 update_date datetimeNOT NULL443 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 444 update_date timestamp NOT NULL 445 445 ) TYPE=InnoDB; 446 446 … … 457 457 status smallint DEFAULT 2, 458 458 creator_id int NOT NULL, 459 create_date datetime,460 update_date datetime,459 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 460 update_date timestamp NOT NULL, 461 461 del_flg smallint NOT NULL DEFAULT 0, 462 462 PRIMARY KEY (review_id) … … 466 466 customer_id int NOT NULL, 467 467 product_id int NOT NULL, 468 create_date datetime NOT NULL,469 update_date datetimeNOT NULL468 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 469 update_date timestamp NOT NULL 470 470 ) TYPE=InnoDB; 471 471 … … 473 473 category_id int NOT NULL, 474 474 product_count int NOT NULL, 475 create_date datetime NOT NULL475 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 476 476 ) TYPE=InnoDB; 477 477 … … 479 479 category_id int NOT NULL, 480 480 product_count int, 481 create_date datetime NOT NULL481 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 482 482 ) TYPE=InnoDB; 483 483 … … 492 492 link_method text, 493 493 creator_id int NOT NULL, 494 create_date datetime NOT NULL,495 update_date datetime,494 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 495 update_date timestamp NOT NULL, 496 496 del_flg smallint NOT NULL DEFAULT 0, 497 497 PRIMARY KEY (news_id) … … 506 506 comment text, 507 507 creator_id int NOT NULL, 508 create_date datetime NOT NULL,509 update_date datetime,508 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 509 update_date timestamp NOT NULL, 510 510 del_flg smallint NOT NULL DEFAULT 0, 511 511 PRIMARY KEY (best_id) … … 556 556 note text, 557 557 status smallint NOT NULL DEFAULT 1, 558 create_date datetime NOT NULL,559 update_date datetime,558 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 559 update_date timestamp NOT NULL, 560 560 del_flg smallint NOT NULL DEFAULT 0, 561 561 mobile_phone_id text, … … 621 621 note text, 622 622 status smallint, 623 create_date datetime NOT NULL,624 update_date datetime,623 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 624 update_date timestamp NOT NULL, 625 625 commit_date datetime, 626 626 payment_date datetime, … … 700 700 deliv_check smallint, 701 701 point_check smallint, 702 create_date datetime NOT NULL,703 update_date datetime,702 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 703 update_date timestamp NOT NULL, 704 704 device_type_id int, 705 705 del_flg smallint NOT NULL DEFAULT 0, … … 761 761 del_flg smallint NOT NULL DEFAULT 0, 762 762 creator_id int NOT NULL, 763 update_date datetime,764 create_date datetimeNOT NULL,763 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 764 update_date timestamp NOT NULL, 765 765 login_date datetime, 766 766 PRIMARY KEY (member_id) … … 771 771 relate_product_id int, 772 772 customer_id int, 773 create_date datetime773 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 774 774 ) TYPE=InnoDB; 775 775 … … 789 789 keyword text, 790 790 update_url text, 791 create_date datetime NOT NULL,792 update_date datetimeNOT NULL,791 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 792 update_date timestamp NOT NULL, 793 793 PRIMARY KEY (device_type_id, page_id) 794 794 ) TYPE=InnoDB; … … 800 800 tpl_path text, 801 801 filename varchar(50) NOT NULL, 802 create_date datetime NOT NULL,803 update_date datetimeNOT NULL,802 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 803 update_date timestamp NOT NULL, 804 804 php_path text, 805 805 deletable_flg smallint NOT NULL DEFAULT 1, … … 826 826 rw_flg smallint DEFAULT 1, 827 827 status smallint NOT NULL DEFAULT 1, 828 create_date datetime NOT NULL,829 update_date datetimeNOT NULL,828 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 829 update_date timestamp NOT NULL, 830 830 mb_convert_kana_option text, 831 831 size_const_type text, … … 838 838 sql_name text NOT NULL, 839 839 csv_sql text, 840 update_date datetime NOT NULL,841 create_date datetimeNOT NULL,840 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 841 update_date timestamp NOT NULL, 842 842 PRIMARY KEY (sql_id) 843 843 ) TYPE=InnoDB; … … 846 846 template_code varchar(50) NOT NULL, 847 847 template_name text, 848 create_date datetime NOT NULL,849 update_date datetimeNOT NULL,848 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 849 update_date timestamp NOT NULL, 850 850 PRIMARY KEY (template_code) 851 851 ) TYPE=InnoDB; … … 864 864 rank int NOT NULL DEFAULT 0, 865 865 creator_id int NOT NULL, 866 create_date datetime NOT NULL,867 update_date datetimeNOT NULL,866 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 867 update_date timestamp NOT NULL, 868 868 del_flg smallint NOT NULL DEFAULT 0, 869 869 PRIMARY KEY (maker_id) … … 873 873 maker_id int NOT NULL, 874 874 product_count int NOT NULL, 875 create_date datetime NOT NULL875 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 876 876 ) TYPE=InnoDB; 877 877 … … 1196 1196 auto_update_flg smallint NOT NULL DEFAULT 0, 1197 1197 del_flg smallint NOT NULL DEFAULT 0, 1198 create_date datetime NOT NULL,1199 update_date datetimeNOT NULL1198 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1199 update_date timestamp NOT NULL 1200 1200 ) TYPE=InnoDB; 1201 1201 … … 1203 1203 sess_id varchar(50) NOT NULL, 1204 1204 sess_data text, 1205 create_date datetime NOT NULL,1206 update_date datetimeNOT NULL,1205 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1206 update_date timestamp NOT NULL, 1207 1207 PRIMARY KEY (sess_id) 1208 1208 ) TYPE=InnoDB; … … 1215 1215 del_flg smallint NOT NULL DEFAULT 0, 1216 1216 memo text, 1217 create_date datetime NOT NULL,1218 update_date datetimeNOT NULL,1217 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1218 update_date timestamp NOT NULL, 1219 1219 PRIMARY KEY (control_id) 1220 1220 ) TYPE=InnoDB; … … 1229 1229 status smallint NOT NULL DEFAULT 2, 1230 1230 del_flg smallint NOT NULL DEFAULT 0, 1231 create_date datetime NOT NULL,1232 update_date datetimeNOT NULL,1231 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1232 update_date timestamp NOT NULL, 1233 1233 PRIMARY KEY (trackback_id) 1234 1234 ) TYPE=InnoDB; … … 1237 1237 bkup_name varchar(50), 1238 1238 bkup_memo text, 1239 create_date datetime,1239 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1240 1240 PRIMARY KEY (bkup_name) 1241 1241 ) TYPE=InnoDB; … … 1247 1247 del_flg smallint NOT NULL DEFAULT 0, 1248 1248 class_name varchar(255) NOT NULL, 1249 create_date datetime NOT NULL,1250 update_date datetimeNOT NULL,1249 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1250 update_date timestamp NOT NULL, 1251 1251 PRIMARY KEY (plugin_id) 1252 1252 ) TYPE=InnoDB;
Note: See TracChangeset
for help on using the changeset viewer.