Changeset 22693 for branches/camp/camp-2_13-tax
- Timestamp:
- 2013/03/10 09:31:04 (11 years ago)
- Location:
- branches/camp/camp-2_13-tax/html/install/sql
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/camp/camp-2_13-tax/html/install/sql/create_table_mysql.sql
r22671 r22693 1225 1225 tax_rate numeric NOT NULL DEFAULT 5, 1226 1226 tax_adjust numeric NOT NULL DEFAULT 0, 1227 apply_date timestamp ,1227 apply_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1228 1228 member_id int NOT NULL, 1229 1229 del_flg smallint NOT NULL DEFAULT 0, 1230 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,1230 create_date timestamp NOT NULL, 1231 1231 update_date timestamp NOT NULL, 1232 1232 PRIMARY KEY (tax_rule_id) 1233 1233 ); 1234 1235 1234 1236 1235 CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(255)); -
branches/camp/camp-2_13-tax/html/install/sql/create_table_pgsql.sql
r22671 r22693 1225 1225 tax_rate numeric NOT NULL DEFAULT 5, 1226 1226 tax_adjust numeric NOT NULL DEFAULT 0, 1227 apply_date timestamp ,1227 apply_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1228 1228 member_id int NOT NULL, 1229 1229 del_flg smallint NOT NULL DEFAULT 0, 1230 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,1230 create_date timestamp NOT NULL, 1231 1231 update_date timestamp NOT NULL, 1232 1232 PRIMARY KEY (tax_rule_id) 1233 1233 ); 1234 1235 1234 1236 1235 CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id);
Note: See TracChangeset
for help on using the changeset viewer.