DB_51Aspx/mysql.sql

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

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

DROP DATABASE IF EXISTS ssm23uzf;

CREATE DATABASE ssm23uzf default character set utf8mb4 collate utf8mb4_general_ci;

USE ssm23uzf;

DROP TABLE IF EXISTS `yonghu`;

CREATE TABLE `yonghu` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`yonghuming` varchar(200) NOT NULL UNIQUE   COMMENT '用户名',
	`mima` varchar(200) NOT NULL   COMMENT '密码',
	`xingming` varchar(200) NOT NULL   COMMENT '姓名',
	`xingbie` varchar(200)    COMMENT '性别',
	`touxiang` varchar(200)    COMMENT '头像',
	`shouji` varchar(200)    COMMENT '手机',
	`youxiang` varchar(200)    COMMENT '邮箱',
	`shenfenzheng` varchar(200)    COMMENT '身份证',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户';

INSERT INTO yonghu(yonghuming,mima,xingming,xingbie,touxiang,shouji,youxiang,shenfenzheng) VALUES('用户1','123456','姓名1','男','http://localhost:8080/ssm23uzf/upload/yonghu_touxiang1.jpg','13823888881','773890001@qq.com','440300199101010001');
INSERT INTO yonghu(yonghuming,mima,xingming,xingbie,touxiang,shouji,youxiang,shenfenzheng) VALUES('用户2','123456','姓名2','男','http://localhost:8080/ssm23uzf/upload/yonghu_touxiang2.jpg','13823888882','773890002@qq.com','440300199202020002');
INSERT INTO yonghu(yonghuming,mima,xingming,xingbie,touxiang,shouji,youxiang,shenfenzheng) VALUES('用户3','123456','姓名3','男','http://localhost:8080/ssm23uzf/upload/yonghu_touxiang3.jpg','13823888883','773890003@qq.com','440300199303030003');

DROP TABLE IF EXISTS `shetuanfuzeren`;

CREATE TABLE `shetuanfuzeren` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`shetuanbianhao` varchar(200) NOT NULL UNIQUE   COMMENT '社团编号',
	`mima` varchar(200) NOT NULL   COMMENT '密码',
	`xingming` varchar(200) NOT NULL   COMMENT '姓名',
	`shetuanmingcheng` varchar(200)    COMMENT '社团名称',
	`xingbie` varchar(200)    COMMENT '性别',
	`touxiang` varchar(200)    COMMENT '头像',
	`lianxidianhua` varchar(200)    COMMENT '联系电话',
	`youxiang` varchar(200)    COMMENT '邮箱',
	`shenfenzheng` varchar(200)    COMMENT '身份证',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='社团负责人';

INSERT INTO shetuanfuzeren(shetuanbianhao,mima,xingming,shetuanmingcheng,xingbie,touxiang,lianxidianhua,youxiang,shenfenzheng) VALUES('社团负责人1','123456','姓名1','社团名称1','男','http://localhost:8080/ssm23uzf/upload/shetuanfuzeren_touxiang1.jpg','13823888881','773890001@qq.com','440300199101010001');
INSERT INTO shetuanfuzeren(shetuanbianhao,mima,xingming,shetuanmingcheng,xingbie,touxiang,lianxidianhua,youxiang,shenfenzheng) VALUES('社团负责人2','123456','姓名2','社团名称2','男','http://localhost:8080/ssm23uzf/upload/shetuanfuzeren_touxiang2.jpg','13823888882','773890002@qq.com','440300199202020002');
INSERT INTO shetuanfuzeren(shetuanbianhao,mima,xingming,shetuanmingcheng,xingbie,touxiang,lianxidianhua,youxiang,shenfenzheng) VALUES('社团负责人3','123456','姓名3','社团名称3','男','http://localhost:8080/ssm23uzf/upload/shetuanfuzeren_touxiang3.jpg','13823888883','773890003@qq.com','440300199303030003');

DROP TABLE IF EXISTS `shetuanxinxi`;

CREATE TABLE `shetuanxinxi` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`shetuanbianhao` varchar(200)    COMMENT '社团编号',
	`shetuanmingcheng` varchar(200) NOT NULL   COMMENT '社团名称',
	`fenlei` varchar(200)    COMMENT '分类',
	`tupian` varchar(200)    COMMENT '图片',
	`shetuanzongzhi` varchar(200)    COMMENT '社团宗旨',
	`chuangbanriqi` date    COMMENT '创办日期',
	`shetuandizhi` varchar(200)    COMMENT '社团地址',
	`lianxidianhua` varchar(200)    COMMENT '联系电话',