mysql创建表实例_mysql用sql创建表完整实例

create table user_login_latest

(

id int(11) unsigned NOT NULL AUTO_INCREMENT,

user_id int(11) not null COMMENT '用户id',

user_name VARCHAR(36) not null COMMENT '用户名',

mobile_phone VARCHAR(11) COMMENT '登陆账号',

ip VARCHAR(21) COMMENT '',

channel int(1) not null COMMENT '渠道0-andorid 1-IOS',

create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',

appid VARCHAR(50) COMMENT '',

usertype VARCHAR(2) COMMENT '',

ctid VARCHAR(20) COMMENT '',

password VARCHAR(50) COMMENT '',

ecid VARCHAR(20) COMMENT '',

ticket VARCHAR(50) COMMENT '',

resultcode VARCHAR(10) COMMENT '',

status VARCHAR(2) COMMENT '',

resultdesc VARCHAR(50) COMMENT '',

submittime VARCHAR(50) COMMENT '',

requesttime VARCHAR(50) COMMENT '',

responsetime VARCHAR(50) COMMENT '',

PRIMARY KEY (`id`)

)COMMENT='用户最后登陆表' ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;