- Timestamp:
- 2012/04/06 17:25:14 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/html/install/sql/create_table_mysql.sql
r21702 r21713 1152 1152 ); 1153 1153 1154 CREATE TABLE dtb_api_config ( 1155 api_config_id int NOT NULL, 1156 operation_name text NOT NULL, 1157 operation_description text, 1158 auth_types text NOT NULL, 1159 enable smallint NOT NULL DEFAULT 0, 1160 is_log smallint NOT NULL DEFAULT 0, 1161 sub_data text, 1162 del_flg smallint NOT NULL DEFAULT 0, 1163 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1164 update_date timestamp NOT NULL, 1165 PRIMARY KEY (api_config_id) 1166 ); 1167 1168 CREATE TABLE dtb_api_account ( 1169 api_account_id int NOT NULL, 1170 api_access_key text NOT NULL, 1171 api_secret_key text NOT NULL, 1172 enable smallint NOT NULL DEFAULT 0, 1173 del_flg smallint NOT NULL DEFAULT 0, 1174 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1175 update_date timestamp NOT NULL, 1176 PRIMARY KEY (api_account_id) 1177 ); 1178 1154 1179 1155 1180 CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(255));
Note: See TracChangeset
for help on using the changeset viewer.