DB_51Aspx/mysql.sql

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

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

DROP DATABASE IF EXISTS thinkphp5CsT9k;

CREATE DATABASE thinkphp5CsT9k default character set utf8mb4 collate utf8mb4_general_ci;

USE thinkphp5CsT9k;

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 '性别',
	`lianxidianhua` varchar(200)    COMMENT '联系电话',
	`dianziyouxiang` varchar(200)    COMMENT '电子邮箱',
	`shenfenzhenghao` varchar(200)    COMMENT '身份证号',
	`youzhengbianhao` int    COMMENT '邮政编号',
	`shouhuodizhi` varchar(200)    COMMENT '收货地址',
	`gerenzhaopian` varchar(200)    COMMENT '个人照片',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户';

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


DROP TABLE IF EXISTS `shangpinxinxi`;

CREATE TABLE `shangpinxinxi` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`shangpinbianhao` varchar(200)  UNIQUE   COMMENT '商品编号',
	`shangpinmingcheng` varchar(200)    COMMENT '商品名称',
	`shangpinleixing` varchar(200)    COMMENT '商品类型',
	`shangpintupian` varchar(200)    COMMENT '商品图片',
	`shangpinjiage` int    COMMENT '商品价格',
	`shangpinyanse` varchar(200)    COMMENT '商品颜色',
	`shangpinguige` longtext    COMMENT '商品规格',
	`shangpinchicun` longtext    COMMENT '商品尺寸',
	`shangpinxiangqing` longtext    COMMENT '商品详情',
	`thumbsupnum` int   default '0' COMMENT '赞',
	`crazilynum` int   default '0' COMMENT '踩',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品信息';

INSERT INTO shangpinxinxi(shangpinbianhao,shangpinmingcheng,shangpinleixing,shangpintupian,shangpinjiage,shangpinyanse,shangpinguige,shangpinchicun,shangpinxiangqing,thumbsupnum,crazilynum) VALUES('商品编号1','商品名称1','商品类型1','shangpinxinxi_shangpintupian1',1,'商品颜色1','商品规格1','商品尺寸1','商品详情1',1,1);
INSERT INTO shangpinxinxi(shangpinbianhao,shangpinmingcheng,shangpinleixing,shangpintupian,shangpinjiage,shangpinyanse,shangpinguige,shangpinchicun,shangpinxiangqing,thumbsupnum,crazilynum) VALUES('商品编号2','商品名称2','商品类型2','shangpinxinxi_shangpintupian2',2,'商品颜色2','商品规格2','商品尺寸2','商品详情2',2,2);
INSERT INTO shangpinxinxi(shangpinbianhao,shangpinmingcheng,shangpinleixing,shangpintupian,shangpinjiage,shangpinyanse,shangpinguige,shangpinchicun,shangpinxiangqing,thumbsupnum,crazilynum) VALUES('商品编号3','商品名称3','商品类型3','shangpinxinxi_shangpintupian3',3,'商品颜色3','商品规格3','商品尺寸3','商品详情3',3,3);


DROP TABLE IF EXISTS `shangpinfenlei`;

CREATE TABLE `shangpinfenlei` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`shangpinleixing` varchar(200)    COMMENT '商品类型',
	PRIMARY KEY (`id`)