- Timestamp:
- 2011/01/30 23:48:56 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/html/install/sql/create_table_mysql.sql
r20053 r20054 65 65 end_age smallint, 66 66 member smallint, 67 order_date timestamp,67 order_date datetime, 68 68 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 69 69 ) ENGINE=InnoDB; … … 83 83 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 84 84 update_date timestamp NOT NULL, 85 release_date timestampNOT NULL,85 release_date datetime NOT NULL, 86 86 PRIMARY KEY (module_id) 87 87 ) ENGINE=InnoDB; … … 273 273 send_count int, 274 274 complete_count int NOT NULL DEFAULT 0, 275 start_date timestamp,276 end_date timestamp,275 start_date datetime, 276 end_date datetime, 277 277 search_data text, 278 278 del_flg smallint NOT NULL DEFAULT 0, … … 436 436 total numeric NOT NULL DEFAULT 0, 437 437 total_average numeric NOT NULL DEFAULT 0, 438 order_date timestampNOT NULL,438 order_date datetime NOT NULL, 439 439 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 440 440 year smallint NOT NULL, … … 461 461 total_average numeric NOT NULL DEFAULT 0, 462 462 hour smallint NOT NULL DEFAULT 0, 463 order_date timestamp,463 order_date datetime, 464 464 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 465 465 ) ENGINE=InnoDB; … … 516 516 CREATE TABLE dtb_news ( 517 517 news_id int NOT NULL, 518 news_date timestamp,518 news_date datetime, 519 519 rank int, 520 520 news_title text NOT NULL, … … 547 547 send_id int NOT NULL, 548 548 order_id int NOT NULL, 549 send_date timestamp,549 send_date datetime, 550 550 template_id int, 551 551 creator_id int NOT NULL, … … 576 576 sex smallint, 577 577 job smallint, 578 birth timestamp,578 birth datetime, 579 579 password text, 580 580 reminder smallint, … … 582 582 salt text, 583 583 secret_key varchar(50) NOT NULL UNIQUE, 584 first_buy_date timestamp,585 last_buy_date timestamp,584 first_buy_date datetime, 585 last_buy_date datetime, 586 586 buy_times numeric DEFAULT 0, 587 587 buy_total numeric DEFAULT 0, … … 619 619 order_addr02 text, 620 620 order_sex smallint, 621 order_birth timestamp,621 order_birth datetime, 622 622 order_job int, 623 623 subtotal numeric, … … 637 637 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 638 638 update_date timestamp NOT NULL, 639 commit_date timestamp,640 payment_date timestamp,639 commit_date datetime, 640 payment_date datetime, 641 641 device_type_id int, 642 642 del_flg smallint NOT NULL DEFAULT 0, … … 675 675 order_addr02 text, 676 676 order_sex smallint, 677 order_birth timestamp,677 order_birth datetime, 678 678 order_job int, 679 679 subtotal numeric, … … 734 734 shipping_time text, 735 735 shipping_num text, 736 shipping_date timestamp,737 shipping_commit_date timestamp,736 shipping_date datetime, 737 shipping_commit_date datetime, 738 738 rank int, 739 739 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, … … 801 801 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 802 802 update_date timestamp NOT NULL, 803 login_date timestamp,803 login_date datetime, 804 804 PRIMARY KEY (member_id) 805 805 ) ENGINE=InnoDB;
Note: See TracChangeset
for help on using the changeset viewer.