基于Java的SSM的校园二手市场交易平台(源码+数据库)
SET FOREIGN_KEY_CHECKS=0;
– Table structure for admin
DROP TABLE IF EXISTS admin
;
CREATE TABLE admin
(id
int(11) NOT NULL AUTO_INCREMENT,username
varchar(25) DEFAULT NULL COMMENT ‘账号’,phone
bigint(25) NOT NULL,password
varchar(25) NOT NULL COMMENT ‘密码’,userRole
varchar(25) DEFAULT NULL COMMENT ‘角色’,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;