vue.js+koa2项目实战（六）数据库建表

show databases

create database pet

use pet

create table users(
id bigint not null auto_increment primary key,
email varchar(60) not null,
pwd varchar(60) not null,
nicheng varchar(60) not null,
updtime timestamp not null,/*时间戳形式*/
role tinyint not null default 0,/*0表普通用户,1表商家,2表管理员*/
createtime timestamp not null,
msgnum int(4) default 0,
unique key emailuniq (email),
unique key nichenguniq (nicheng)
)ENGINE=innodb DEFAULT CHARSET=utf8;

show tables