DB_51Aspx/mysql.sql

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

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

DROP DATABASE IF EXISTS ssmHP49Z;

CREATE DATABASE ssmHP49Z default character set utf8mb4 collate utf8mb4_general_ci;

USE ssmHP49Z;

DROP TABLE IF EXISTS `yonghu`;

CREATE TABLE `yonghu` (
	`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 '头像',
	`shenfenzheng` varchar(200)    COMMENT '身份证',
	`shouji` varchar(200)    COMMENT '手机',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户';

INSERT INTO yonghu(yonghuming,mima,xingming,xingbie,touxiang,shenfenzheng,shouji) VALUES('用户1','123456','姓名1','男','yonghu_touxiang1','440300199101010001','020-89819991');
INSERT INTO yonghu(yonghuming,mima,xingming,xingbie,touxiang,shenfenzheng,shouji) VALUES('用户2','123456','姓名2','男','yonghu_touxiang2','440300199202020002','020-89819992');
INSERT INTO yonghu(yonghuming,mima,xingming,xingbie,touxiang,shenfenzheng,shouji) VALUES('用户3','123456','姓名3','男','yonghu_touxiang3','440300199303030003','020-89819993');


DROP TABLE IF EXISTS `qichexinxi`;

CREATE TABLE `qichexinxi` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`qichebianhao` varchar(200) NOT NULL UNIQUE   COMMENT '汽车编号',
	`qichemingcheng` varchar(200)    COMMENT '汽车名称',
	`qicheleixing` varchar(200)    COMMENT '汽车类型',
	`tupian` varchar(200)    COMMENT '图片',
	`qichezhuangkuang` longtext    COMMENT '汽车状况',
	`jiage` int    COMMENT '价格',
	`zhuangtai` varchar(200)    COMMENT '状态',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='汽车信息';

INSERT INTO qichexinxi(qichebianhao,qichemingcheng,qicheleixing,tupian,qichezhuangkuang,jiage,zhuangtai) VALUES('汽车编号1','汽车名称1','汽车类型1','qichexinxi_tupian1','汽车状况1',1,'待租赁');
INSERT INTO qichexinxi(qichebianhao,qichemingcheng,qicheleixing,tupian,qichezhuangkuang,jiage,zhuangtai) VALUES('汽车编号2','汽车名称2','汽车类型2','qichexinxi_tupian2','汽车状况2',2,'待租赁');
INSERT INTO qichexinxi(qichebianhao,qichemingcheng,qicheleixing,tupian,qichezhuangkuang,jiage,zhuangtai) VALUES('汽车编号3','汽车名称3','汽车类型3','qichexinxi_tupian3','汽车状况3',3,'待租赁');


DROP TABLE IF EXISTS `qicheleixing`;

CREATE TABLE `qicheleixing` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`qicheleixing` varchar(200) NOT NULL   COMMENT '汽车类型',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='汽车类型';

INSERT INTO qicheleixing(qicheleixing) VALUES('汽车类型1');
INSERT INTO qicheleixing(qicheleixing) VALUES('汽车类型2');
INSERT INTO qicheleixing(qicheleixing) VALUES('汽车类型3');