- Timestamp:
- 2008/04/18 09:45:52 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/comu-ver2/html/install/sql/create_table_mysql.sql
r17263 r17268 468 468 product_id int NOT NULL, 469 469 create_date datetime NOT NULL, 470 update_date datetime NOT NULL ,470 update_date datetime NOT NULL 471 471 ) TYPE=InnoDB ; 472 472 … … 953 953 954 954 CREATE TABLE dtb_maker ( 955 maker_id auto_increment primary keyl,955 maker_id INT auto_increment primary key, 956 956 name text NOT NULL, 957 957 rank int NOT NULL DEFAULT 0, 958 958 creator_id int NOT NULL, 959 create_date datetime NOT NULL DEFAULT now(),959 create_date datetime NOT NULL, 960 960 update_date datetime NOT NULL, 961 961 del_flg smallint NOT NULL DEFAULT 0 … … 965 965 maker_id int NOT NULL, 966 966 product_count int NOT NULL, 967 create_date datetime NOT NULL DEFAULT Now()967 create_date datetime NOT NULL 968 968 ) TYPE=InnoDB ; 969 969
Note: See TracChangeset
for help on using the changeset viewer.