| 12345678910111213141516171819202122232425262728 |
- /* ---------------------------------------------------- */
- /* Generated by Enterprise Architect Version 12.0 */
- /* Created On : 18-Jan-2017 3:37:41 PM */
- /* DBMS : MySql */
- /* ---------------------------------------------------- */
- SET FOREIGN_KEY_CHECKS=0
- /* Drop Tables */
- DROP TABLE IF EXISTS `app_status` CASCADE
- ;
- /* Create Tables */
- CREATE TABLE `app_status`
- (
- `user_id` VARCHAR(50) NOT NULL COMMENT '用户ID',
- `platform` TINYINT COMMENT '平台，0为iOS,1为安卓',
- `token` VARCHAR(100) COMMENT '个推Token',
- `client_id` VARCHAR(100) COMMENT '客户端ID',
- `app_in_bg` TINYINT COMMENT 'App是否处于后台状态',
- `last_login_time` TIMESTAMP(0) COMMENT '最后登录时间',
- CONSTRAINT `PK_user_status` PRIMARY KEY (`user_id`)
- ) COMMENT='app端状态'
- ;
- SET FOREIGN_KEY_CHECKS=1
|
