Changeset 21713 for branches/version-2_12-dev/html
- Timestamp:
- 2012/04/06 17:25:14 (12 years ago)
- Location:
- branches/version-2_12-dev/html
- Files:
-
- 5 added
- 3 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)); -
branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql
r21701 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); -
branches/version-2_12-dev/html/install/sql/drop_table.sql
r21701 r21713 93 93 DROP TABLE mtb_auth_excludes; 94 94 DROP TABLE dtb_plugin_hookpoint; 95 DROP TABLE dtb_api_config; 96 DROP TABLE dtb_api_account;
Note: See TracChangeset
for help on using the changeset viewer.