Changeset 17263 for branches/comu-ver2/html
- Timestamp:
- 2008/04/16 20:13:17 (16 years ago)
- Location:
- branches/comu-ver2/html
- Files:
-
- 1 added
- 2 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, -
branches/comu-ver2/html/install/sql/create_table_pgsql.sql
r17162 r17263 275 275 sale_unlimited int2 DEFAULT 0, 276 276 category_id int4, 277 maker_id int4, 277 278 rank int4, 278 279 status int2 NOT NULL DEFAULT 2, … … 953 954 ); 954 955 956 CREATE TABLE dtb_maker ( 957 maker_id serial NOT NULL, 958 name text NOT NULL, 959 rank int4 NOT NULL DEFAULT 0, 960 creator_id int4 NOT NULL, 961 create_date timestamp NOT NULL DEFAULT now(), 962 update_date timestamp NOT NULL, 963 del_flg int2 NOT NULL DEFAULT 0 964 ); 965 966 CREATE TABLE dtb_maker_count ( 967 maker_id int4 NOT NULL, 968 product_count int4 NOT NULL, 969 create_date timestamp NOT NULL DEFAULT Now() 970 ); 971 955 972 CREATE TABLE mtb_permission ( 956 973 id text,
Note: See TracChangeset
for help on using the changeset viewer.