jspm schema/db/mysql.sql

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

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

DROP DATABASE IF EXISTS jsp6Bdxv;

CREATE DATABASE jsp6Bdxv default character set utf8mb4 collate utf8mb4_general_ci;

USE jsp6Bdxv;

DROP TABLE IF EXISTS `yonghu`;

CREATE TABLE `yonghu` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`yonghuming` varchar(200)  UNIQUE   COMMENT '用户名',
	`mima` varchar(200)    COMMENT '密码',
	`xingming` varchar(200)    COMMENT '姓名',
	`xingbie` varchar(200)    COMMENT '性别',
	`nianling` int    COMMENT '年龄',
	`lianxidianhua` varchar(200)    COMMENT '联系电话',
	`dianziyouxiang` varchar(200)    COMMENT '电子邮箱',
	`shenfenzhenghao` varchar(200)    COMMENT '身份证号',
	`gerenzhaopian` varchar(200)    COMMENT '个人照片',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户';

INSERT INTO yonghu(yonghuming,mima,xingming,xingbie,nianling,lianxidianhua,dianziyouxiang,shenfenzhenghao,gerenzhaopian) VALUES('用户1','123456','姓名1','男',1,'020-89819991','773890001@qq.com','440300199101010001','yonghu_gerenzhaopian1');
INSERT INTO yonghu(yonghuming,mima,xingming,xingbie,nianling,lianxidianhua,dianziyouxiang,shenfenzhenghao,gerenzhaopian) VALUES('用户2','123456','姓名2','男',2,'020-89819992','773890002@qq.com','440300199202020002','yonghu_gerenzhaopian2');
INSERT INTO yonghu(yonghuming,mima,xingming,xingbie,nianling,lianxidianhua,dianziyouxiang,shenfenzhenghao,gerenzhaopian) VALUES('用户3','123456','姓名3','男',3,'020-89819993','773890003@qq.com','440300199303030003','yonghu_gerenzhaopian3');


DROP TABLE IF EXISTS `kechexinxi`;

CREATE TABLE `kechexinxi` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`kechemingcheng` varchar(200)    COMMENT '客车名称',
	`kecheleixing` varchar(200)    COMMENT '客车类型',
	`kechezhaopian` varchar(200)    COMMENT '客车照片',
	`kechezhuangtai` varchar(200)    COMMENT '客车状态',
	`siji` varchar(200)    COMMENT '司机',
	`lianxidianhua` varchar(200)    COMMENT '联系电话',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='客车信息';

INSERT INTO kechexinxi(kechemingcheng,kecheleixing,kechezhaopian,kechezhuangtai,siji,lianxidianhua) VALUES('客车名称1','长途客车','kechexinxi_kechezhaopian1','正常','司机1','020-89819991');
INSERT INTO kechexinxi(kechemingcheng,kecheleixing,kechezhaopian,kechezhuangtai,siji,lianxidianhua) VALUES('客车名称2','长途客车','kechexinxi_kechezhaopian2','正常','司机2','020-89819992');
INSERT INTO kechexinxi(kechemingcheng,kecheleixing,kechezhaopian,kechezhuangtai,siji,lianxidianhua) VALUES('客车名称3','长途客车','kechexinxi_kechezhaopian3','正常','司机3','020-89819993');


DROP TABLE IF EXISTS `chengshizhandian`;

CREATE TABLE `chengshizhandian` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`chengshimingcheng` varchar(200)    COMMENT '城市名称',
	`zhandianleixing` varchar(200)    COMMENT '站点类型',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='城市站点';

INSERT INTO chengshizhandian(chengshimingcheng,zhandianleixing) VALUES('城市名称1','大站');
INSERT INTO chengshizhandian(chengshimingcheng,zhandianleixing) VALUES('城市名称2','大站');
INSERT INTO chengshizhandian(chengshimingcheng,zhandianleixing) VALUES('城市名称3','大站');