DB_51Aspx/mysql.sql

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

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

DROP DATABASE IF EXISTS ssm1wQ7Q;

CREATE DATABASE ssm1wQ7Q default character set utf8mb4 collate utf8mb4_general_ci;

USE ssm1wQ7Q;

DROP TABLE IF EXISTS `huiyuan`;

CREATE TABLE `huiyuan` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`zhanghao` varchar(200)  UNIQUE   COMMENT '账号',
	`mima` varchar(200)    COMMENT '密码',
	`xingming` varchar(200)    COMMENT '姓名',
	`xingbie` varchar(200)    COMMENT '性别',
	`lianxidianhua` varchar(200)    COMMENT '联系电话',
	`dianziyouxiang` varchar(200)    COMMENT '电子邮箱',
	`youzhengbianma` int    COMMENT '邮政编码',
	`jiatingdizhi` varchar(200)    COMMENT '家庭地址',
	`gerenzhaopian` varchar(200)    COMMENT '个人照片',
	`money` float   default '0' COMMENT '余额',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员';

INSERT INTO huiyuan(zhanghao,mima,xingming,xingbie,lianxidianhua,dianziyouxiang,youzhengbianma,jiatingdizhi,gerenzhaopian,money) VALUES('会员1','123456','姓名1','男','020-89819991','773890001@qq.com',1,'家庭地址1','huiyuan_gerenzhaopian1',1);
INSERT INTO huiyuan(zhanghao,mima,xingming,xingbie,lianxidianhua,dianziyouxiang,youzhengbianma,jiatingdizhi,gerenzhaopian,money) VALUES('会员2','123456','姓名2','男','020-89819992','773890002@qq.com',2,'家庭地址2','huiyuan_gerenzhaopian2',2);
INSERT INTO huiyuan(zhanghao,mima,xingming,xingbie,lianxidianhua,dianziyouxiang,youzhengbianma,jiatingdizhi,gerenzhaopian,money) VALUES('会员3','123456','姓名3','男','020-89819993','773890003@qq.com',3,'家庭地址3','huiyuan_gerenzhaopian3',3);


DROP TABLE IF EXISTS `shangpinfenlei`;

CREATE TABLE `shangpinfenlei` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`shangpinleibie` varchar(200)    COMMENT '商品类别',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品分类';

INSERT INTO shangpinfenlei(shangpinleibie) VALUES('商品类别1');
INSERT INTO shangpinfenlei(shangpinleibie) VALUES('商品类别2');
INSERT INTO shangpinfenlei(shangpinleibie) VALUES('商品类别3');


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 '商品名称',
	`shangpinleibie` varchar(200)    COMMENT '商品类别',
	`shangpintupian` varchar(200)    COMMENT '商品图片',
	`shangpinkucun` int    COMMENT '商品库存',
	`shangpinchandi` varchar(200)    COMMENT '商品产地',
	`shangpinjieshao` longtext    COMMENT '商品介绍',
	`shangpinxiangqing` longtext    COMMENT '商品详情',
	`thumbsupnum` int   default '0' COMMENT '赞',
	`crazilynum` int   default '0' COMMENT '踩',
	`price` float NOT NULL   COMMENT '价格',
	PRIMARY KEY (`id`)