| 1234567891011121314151617181920212223242526272829303132333435 |
- create table promotion_grant_account
- (
- id varchar(64) not null
- primary key,
- name varchar(255) null,
- company varchar(64) not null,
- app_id varchar(64) null,
- account_type varchar(64) null,
- user_id varchar(64) null,
- open_id varchar(64) null,
- account_id varchar(64) null,
- scope varchar(255) null,
- access_token varchar(1000) null,
- expires_time datetime null,
- refresh_token varchar(1000) null,
- refresh_expires_time datetime null,
- auth_time datetime null,
- create_time datetime not null,
- update_time datetime not null,
- status int default 0 not null
- );
- create table promotion_grant_app
- (
- id varchar(64) not null
- primary key,
- name varchar(255) null,
- company varchar(64) not null,
- subject varchar(255) null,
- app_secret varchar(255) null,
- create_time datetime not null,
- update_time datetime not null,
- status int default 0 not null
- );
|
