DB_51Aspx/mysql.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

DROP DATABASE IF EXISTS ssm51710;

CREATE DATABASE ssm51710 default character set utf8mb4 collate utf8mb4_general_ci;

USE ssm51710;


DROP TABLE IF EXISTS `config`;

CREATE TABLE `config`(
	`id` bigint NOT NULL AUTO_INCREMENT,
	`name` varchar(100) NOT NULL COMMENT '配置参数名称',
	`value` varchar(100) COMMENT '配置参数值',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='配置文件';

DROP TABLE IF EXISTS `yezhu`;

CREATE TABLE `yezhu` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`yonghuming` varchar(200) NOT NULL UNIQUE   COMMENT '用户名',
	`mima` varchar(200) NOT NULL   COMMENT '密码',
	`xingming` varchar(200)    COMMENT '姓名',
	`xingbie` varchar(200)    COMMENT '性别',
	`touxiang` varchar(200)    COMMENT '头像',
	`danyuanhao` varchar(200)    COMMENT '单元号',
	`fanghao` varchar(200)    COMMENT '房号',
	`shenfenzheng` varchar(200)    COMMENT '身份证',
	`shouji` varchar(200)    COMMENT '手机',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='业主';

INSERT INTO yezhu(yonghuming,mima,xingming,xingbie,touxiang,danyuanhao,fanghao,shenfenzheng,shouji) VALUES('业主1','123456','姓名1','男','http://localhost:8080/ssm51710/upload/yezhu_touxiang1.jpg','单元号1','房号1','440300199101010001','13823888881');
INSERT INTO yezhu(yonghuming,mima,xingming,xingbie,touxiang,danyuanhao,fanghao,shenfenzheng,shouji) VALUES('业主2','123456','姓名2','男','http://localhost:8080/ssm51710/upload/yezhu_touxiang2.jpg','单元号2','房号2','440300199202020002','13823888882');
INSERT INTO yezhu(yonghuming,mima,xingming,xingbie,touxiang,danyuanhao,fanghao,shenfenzheng,shouji) VALUES('业主3','123456','姓名3','男','http://localhost:8080/ssm51710/upload/yezhu_touxiang3.jpg','单元号3','房号3','440300199303030003','13823888883');


DROP TABLE IF EXISTS `cheweixinxi`;

CREATE TABLE `cheweixinxi` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`mingcheng` varchar(200) NOT NULL   COMMENT '名称',
	`yuancheweihao` varchar(200)    COMMENT '原车位号',
	`chepai` varchar(200)    COMMENT '车牌',
	`yonghuming` varchar(200)    COMMENT '用户名',
	`xingming` varchar(200)    COMMENT '姓名',
	`huancheweihao` varchar(200)    COMMENT '换车位号',
	`sfsh` varchar(200)   default '否' COMMENT '是否审核',
	`shhf` longtext    COMMENT '审核回复',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='车位信息';

INSERT INTO cheweixinxi(mingcheng,yuancheweihao,chepai,yonghuming,xingming,huancheweihao,sfsh,shhf) VALUES('名称1','原车位号1','车牌1','用户名1','姓名1','换车位号1','否','');
INSERT INTO cheweixinxi(mingcheng,yuancheweihao,chepai,yonghuming,xingming,huancheweihao,sfsh,shhf) VALUES('名称2','原车位号2','车牌2','用户名2','姓名2','换车位号2','否','');
INSERT INTO cheweixinxi(mingcheng,yuancheweihao,chepai,yonghuming,xingming,huancheweihao,sfsh,shhf) VALUES('名称3','原车位号3','车牌3','用户名3','姓名3','换车位号3','否','');


DROP TABLE IF EXISTS `feiyongxinxi`;