- Timestamp:
- 2008/04/16 20:13:17 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/comu-ver2/html/install/sql/create_table_mysql.sql
r17162 r17263 275 275 sale_unlimited smallint DEFAULT 0, 276 276 category_id int, 277 maker_id int, 277 278 rank int, 278 279 status smallint NOT NULL DEFAULT 2, … … 951 952 ) TYPE=InnoDB ; 952 953 954 CREATE TABLE dtb_maker ( 955 maker_id auto_increment primary keyl, 956 name text NOT NULL, 957 rank int NOT NULL DEFAULT 0, 958 creator_id int NOT NULL, 959 create_date datetime NOT NULL DEFAULT now(), 960 update_date datetime NOT NULL, 961 del_flg smallint NOT NULL DEFAULT 0 962 ) TYPE=InnoDB ; 963 964 CREATE TABLE dtb_maker_count ( 965 maker_id int NOT NULL, 966 product_count int NOT NULL, 967 create_date datetime NOT NULL DEFAULT Now() 968 ) TYPE=InnoDB ; 969 970 953 971 CREATE TABLE mtb_permission ( 954 972 id text,
Note: See TracChangeset
for help on using the changeset viewer.