登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
2 Star 11 Fork 4

mataijikarl/springboot vue电子书城

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
shop-book.sql 20.43 KB
一键复制 编辑 原始数据 按行查看 历史
mataijikarl 提交于 2022-04-23 16:28 . 数据库文件
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352
/*

 Navicat Premium Data Transfer



 Source Server         : 120.79.253.99

 Source Server Type    : MySQL

 Source Server Version : 50733

 Source Host           : 120.79.253.99:3306

 Source Schema         : shop-book



 Target Server Type    : MySQL

 Target Server Version : 50733

 File Encoding         : 65001



 Date: 08/05/2021 11:10:02

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for bookType

-- ----------------------------

DROP TABLE IF EXISTS `bookType`;

CREATE TABLE `bookType`  (

  `typeid` int(5) NOT NULL AUTO_INCREMENT,

  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类',

  `parent` int(5) NULL DEFAULT NULL COMMENT '父类',

  PRIMARY KEY (`typeid`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 11137 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of bookType

-- ----------------------------

INSERT INTO `bookType` VALUES (11111, '文学', 0);

INSERT INTO `bookType` VALUES (11112, '经济', 0);

INSERT INTO `bookType` VALUES (11113, '科学', 0);

INSERT INTO `bookType` VALUES (11114, '人文社科', 0);

INSERT INTO `bookType` VALUES (11115, '生活休闲', 0);

INSERT INTO `bookType` VALUES (11116, '学习教育', 0);

INSERT INTO `bookType` VALUES (11117, '文学小说', 11111);

INSERT INTO `bookType` VALUES (11118, '影视原著', 11111);

INSERT INTO `bookType` VALUES (11121, '中外名著', 11111);

INSERT INTO `bookType` VALUES (11122, '金融投资', 11112);

INSERT INTO `bookType` VALUES (11123, '市场营销', 11112);

INSERT INTO `bookType` VALUES (11124, '管理学', 11112);

INSERT INTO `bookType` VALUES (11125, '电子商务', 11113);

INSERT INTO `bookType` VALUES (11126, '程序设计', 11113);

INSERT INTO `bookType` VALUES (11127, '科普', 11113);

INSERT INTO `bookType` VALUES (11128, '历史考古', 11114);

INSERT INTO `bookType` VALUES (11129, '心理学', 11114);

INSERT INTO `bookType` VALUES (11130, '政治军事', 11114);

INSERT INTO `bookType` VALUES (11131, '两性情感', 11115);

INSERT INTO `bookType` VALUES (11132, '健康养生', 11115);

INSERT INTO `bookType` VALUES (11133, '运动健身', 11115);

INSERT INTO `bookType` VALUES (11134, '外语学习', 11116);

INSERT INTO `bookType` VALUES (11135, '教辅用书', 11116);

INSERT INTO `bookType` VALUES (11136, '职业技术', 11116);



-- ----------------------------

-- Table structure for bookimg

-- ----------------------------

DROP TABLE IF EXISTS `bookimg`;

CREATE TABLE `bookimg`  (

  `id` int(5) NOT NULL AUTO_INCREMENT,

  `bookid` int(5) NULL DEFAULT NULL COMMENT '书籍id',

  `bookimageaddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '书籍图片地址\r\n书籍图片地址\r\n',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 188 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



-- ----------------------------

-- Records of bookimg

-- ----------------------------

INSERT INTO `bookimg` VALUES (111, 111111, 'https://img.alicdn.com/imgextra/i3/2200776705531/O1CN01sH9kwz1qjF9xEy1z1_!!2200776705531-0-scmitem6000.jpg');

INSERT INTO `bookimg` VALUES (112, 111112, 'https://img.alicdn.com/imgextra/i3/2200776705531/O1CN01sH9kwz1qjF9xEy1z1_!!2200776705531-0-scmitem6000.jpg');

INSERT INTO `bookimg` VALUES (113, 111113, 'https://img.alicdn.com/imgextra/i3/2200776705531/O1CN01sH9kwz1qjF9xEy1z1_!!2200776705531-0-scmitem6000.jpg');

INSERT INTO `bookimg` VALUES (114, 111113, 'https://img.alicdn.com/imgextra/i3/2200776705531/O1CN01sH9kwz1qjF9xEy1z1_!!2200776705531-0-scmitem6000.jpg');

INSERT INTO `bookimg` VALUES (115, 111114, 'https://img.alicdn.com/imgextra/i3/2200776705531/O1CN01sH9kwz1qjF9xEy1z1_!!2200776705531-0-scmitem6000.jpg');

INSERT INTO `bookimg` VALUES (116, 111115, 'https://img.alicdn.com/imgextra/i3/2200776705531/O1CN01sH9kwz1qjF9xEy1z1_!!2200776705531-0-scmitem6000.jpg');

INSERT INTO `bookimg` VALUES (117, 111116, 'https://img.alicdn.com/imgextra/i3/2200776705531/O1CN01sH9kwz1qjF9xEy1z1_!!2200776705531-0-scmitem6000.jpg');

INSERT INTO `bookimg` VALUES (134, 111118, 'http://file.mataiji.top/2021-03-061617184969280.png');

INSERT INTO `bookimg` VALUES (135, 111118, 'http://file.mataiji.top/2021-03-061617184969280.png');

INSERT INTO `bookimg` VALUES (136, 111118, 'http://file.mataiji.top/2021-03-061617184969280.png');

INSERT INTO `bookimg` VALUES (137, 111118, 'http://file.mataiji.top/2021-03-061617184969280.png');

INSERT INTO `bookimg` VALUES (146, 111131, 'http://file.mataiji.top/2021-03-091617195855147.png');

INSERT INTO `bookimg` VALUES (147, 111128, 'http://file.mataiji.top/2021-03-091617195855147.png');

INSERT INTO `bookimg` VALUES (149, 111131, 'http://file.mataiji.top/2021-04-111617292402320.png');

INSERT INTO `bookimg` VALUES (150, 111146, 'http://file.mataiji.top/2021-04-111617292402336.png');

INSERT INTO `bookimg` VALUES (151, 111146, 'http://file.mataiji.top/2021-04-111617292402320.png');

INSERT INTO `bookimg` VALUES (152, 111131, 'http://file.mataiji.top/2021-04-111617292402336.png');

INSERT INTO `bookimg` VALUES (172, 111143, 'http://file.mataiji.top/2021-04-081617367532960.png');

INSERT INTO `bookimg` VALUES (173, 111143, 'http://file.mataiji.top/2021-04-081617367532955.png');

INSERT INTO `bookimg` VALUES (174, 111143, 'http://file.mataiji.top/2021-04-081617367532967.png');

INSERT INTO `bookimg` VALUES (175, 111143, 'http://file.mataiji.top/2021-04-081617367532960.png');

INSERT INTO `bookimg` VALUES (176, 111143, 'http://file.mataiji.top/2021-04-081617367532955.png');

INSERT INTO `bookimg` VALUES (177, 111143, 'http://file.mataiji.top/2021-04-081617367532967.png');

INSERT INTO `bookimg` VALUES (178, 111143, 'http://file.mataiji.top/2021-04-081617367532960.png');

INSERT INTO `bookimg` VALUES (179, 111143, 'http://file.mataiji.top/2021-04-081617367532955.png');

INSERT INTO `bookimg` VALUES (180, 111143, 'http://file.mataiji.top/2021-04-081617367532967.png');

INSERT INTO `bookimg` VALUES (181, 111147, 'http://file.mataiji.top/2021-04-031619077272391.png');

INSERT INTO `bookimg` VALUES (182, 111147, 'http://file.mataiji.top/2021-04-031619077272405.png');

INSERT INTO `bookimg` VALUES (183, 111148, 'http://file.mataiji.top/2021-04-051619171289337.png');

INSERT INTO `bookimg` VALUES (184, 111148, 'http://file.mataiji.top/2021-04-051619171289337.png');

INSERT INTO `bookimg` VALUES (185, 0, 'http://file.mataiji.top/2021-04-051619171289337.png');

INSERT INTO `bookimg` VALUES (186, 0, 'http://file.mataiji.top/2021-04-051619171289337.png');

INSERT INTO `bookimg` VALUES (187, 111152, 'http://file.mataiji.top/2021-04-051619171289337.png');



-- ----------------------------

-- Table structure for history_price

-- ----------------------------

DROP TABLE IF EXISTS `history_price`;

CREATE TABLE `history_price`  (

  `th_id` bigint(20) NOT NULL AUTO_INCREMENT,

  `book_id` int(11) NULL DEFAULT NULL COMMENT '书籍id',

  `book_price` bigint(255) NULL DEFAULT NULL COMMENT '书籍价格',

  `start_date` date NULL DEFAULT NULL COMMENT '开始时间',

  `end_date` date NULL DEFAULT NULL COMMENT '结束时间',

  PRIMARY KEY (`th_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



-- ----------------------------

-- Table structure for manager_money

-- ----------------------------

DROP TABLE IF EXISTS `manager_money`;

CREATE TABLE `manager_money`  (

  `id` int(5) NOT NULL AUTO_INCREMENT,

  `userId` int(5) NULL DEFAULT NULL COMMENT '管理员id',

  `money` bigint(255) NULL DEFAULT NULL COMMENT '余额',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Table structure for merchant

-- ----------------------------

DROP TABLE IF EXISTS `merchant`;

CREATE TABLE `merchant`  (

  `id` int(6) NOT NULL,

  `merchant_id` int(5) NOT NULL COMMENT '商家编号',

  `merchant_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商家名',

  `merchant_tel` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商家电话',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



-- ----------------------------

-- Table structure for on_sale

-- ----------------------------

DROP TABLE IF EXISTS `on_sale`;

CREATE TABLE `on_sale`  (

  `id` int(5) NOT NULL,

  `book_num` bigint(255) NULL DEFAULT NULL COMMENT '在售商品数量',

  `book_price` bigint(255) NULL DEFAULT NULL COMMENT '在售商品价格',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



-- ----------------------------

-- Table structure for order_details

-- ----------------------------

DROP TABLE IF EXISTS `order_details`;

CREATE TABLE `order_details`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT,

  `order_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单id',

  `book_id` bigint(20) NULL DEFAULT NULL COMMENT '商品id',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 55 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



-- ----------------------------

-- Records of order_details

-- ----------------------------

INSERT INTO `order_details` VALUES (18, '202103121256051111', 111111);

INSERT INTO `order_details` VALUES (19, '202103011304071111', 111111);

INSERT INTO `order_details` VALUES (20, '202103011304081111', 111111);

INSERT INTO `order_details` VALUES (21, '202103051719171111', 111111);

INSERT INTO `order_details` VALUES (22, '202103051722221111', 111115);

INSERT INTO `order_details` VALUES (23, '202103031511411111', 111111);

INSERT INTO `order_details` VALUES (24, '202103092108151111', 111128);

INSERT INTO `order_details` VALUES (46, '202104041625051111', 111143);

INSERT INTO `order_details` VALUES (47, '202104041625531111', 111143);

INSERT INTO `order_details` VALUES (48, '202104041644141111', 111113);

INSERT INTO `order_details` VALUES (49, '202104102217081111', 111128);

INSERT INTO `order_details` VALUES (50, '202104071929091111', 111147);

INSERT INTO `order_details` VALUES (51, '202104101011471111', 111128);

INSERT INTO `order_details` VALUES (52, '202104101011471111', 111147);

INSERT INTO `order_details` VALUES (53, '202104101018091111', 111147);

INSERT INTO `order_details` VALUES (54, '202104101018491111', 111147);



-- ----------------------------

-- Table structure for slideshow

-- ----------------------------

DROP TABLE IF EXISTS `slideshow`;

CREATE TABLE `slideshow`  (

  `id` int(5) NOT NULL AUTO_INCREMENT,

  `img_id` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '轮播图id',

  `img_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '轮播图图片地址',

  `date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1118 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



-- ----------------------------

-- Records of slideshow

-- ----------------------------

INSERT INTO `slideshow` VALUES (1115, '20210410224935', 'http://file.mataiji.top/2021-04-101617547762865.png', '2021-04-04 22:49:35');

INSERT INTO `slideshow` VALUES (1116, '20210410224935', 'http://file.mataiji.top/2021-04-101617547762921.png', '2021-04-04 22:49:35');

INSERT INTO `slideshow` VALUES (1117, '20210410224935', 'http://file.mataiji.top/2021-04-101617547762893.png', '2021-04-04 22:49:35');



-- ----------------------------

-- Table structure for sold_book

-- ----------------------------

DROP TABLE IF EXISTS `sold_book`;

CREATE TABLE `sold_book`  (

  `id` int(5) NOT NULL,

  `commodity_price` bigint(10) NULL DEFAULT NULL COMMENT '商品价格',

  `commodity_quantity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '已售商品数量',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



-- ----------------------------

-- Table structure for tb_book

-- ----------------------------

DROP TABLE IF EXISTS `tb_book`;

CREATE TABLE `tb_book`  (

  `bookId` int(5) NOT NULL AUTO_INCREMENT,

  `bookname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '书籍名',

  `ebookaddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电子文件地址\r\n',

  `isFree` int(1) NULL DEFAULT NULL COMMENT '是否免费',

  `isEntity` int(1) NULL DEFAULT NULL COMMENT '是否有实体书\r\n',

  `howIntegral` int(255) NULL DEFAULT NULL COMMENT '多少积分可以阅读\r\n',

  `bookprice` bigint(10) NULL DEFAULT NULL COMMENT '价格',

  `typeid` int(5) NULL DEFAULT NULL COMMENT '类型id',

  PRIMARY KEY (`bookId`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 111153 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



-- ----------------------------

-- Records of tb_book

-- ----------------------------

INSERT INTO `tb_book` VALUES (111143, '11111111', 'http://file.mataiji.top/2021-04-081617367542418.pdf', 0, NULL, NULL, 111, 11126);

INSERT INTO `tb_book` VALUES (111146, '11111111', 'http://file.mataiji.top/2021-04-081617367542418.pdf', 0, NULL, NULL, 111, 11126);

INSERT INTO `tb_book` VALUES (111147, '1111', 'http://file.mataiji.top/2021-04-031619077279706.png', 0, NULL, NULL, 1, 11126);

INSERT INTO `tb_book` VALUES (111148, '2111', 'http://file.mataiji.top/2021-04-051619171296942.png', 2, NULL, 111, 0, 11118);

INSERT INTO `tb_book` VALUES (111149, '2111', 'http://file.mataiji.top/2021-04-051619171296942.png', 2, NULL, 111, 0, 11118);

INSERT INTO `tb_book` VALUES (111150, '哈哈哈', 'http://file.mataiji.top/2021-04-051619171296942.png', 2, NULL, 111, 0, 11118);

INSERT INTO `tb_book` VALUES (111151, '哈哈1', 'http://file.mataiji.top/2021-04-051619171296942.png', 2, NULL, 111, 0, 11118);

INSERT INTO `tb_book` VALUES (111152, '哈哈111', 'http://file.mataiji.top/2021-04-051619171296942.png', 2, NULL, 111, 0, 11118);



-- ----------------------------

-- Table structure for tb_cart

-- ----------------------------

DROP TABLE IF EXISTS `tb_cart`;

CREATE TABLE `tb_cart`  (

  `te_id` int(5) NOT NULL AUTO_INCREMENT,

  `user_id` int(5) NOT NULL COMMENT '用户id',

  `book_id` int(5) NOT NULL COMMENT '书籍id',

  `book_num` bigint(20) NOT NULL COMMENT '书籍数量',

  `cart_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,

  PRIMARY KEY (`te_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



-- ----------------------------

-- Records of tb_cart

-- ----------------------------

INSERT INTO `tb_cart` VALUES (1, 111111, 111111, 2, '111111');

INSERT INTO `tb_cart` VALUES (2, 111111, 111111, 2, '100001');



-- ----------------------------

-- Table structure for tb_order

-- ----------------------------

DROP TABLE IF EXISTS `tb_order`;

CREATE TABLE `tb_order`  (

  `order_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单号',

  `order_money` bigint(255) NULL DEFAULT NULL COMMENT '订单金额',

  `order_status` bigint(255) NULL DEFAULT NULL COMMENT '订单状态',

  `order_contacts` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系人',

  `order_tel` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电话',

  `order_addr` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址',

  `establish_date` date NULL DEFAULT NULL COMMENT '创建时间',

  `update_date` date NULL DEFAULT NULL COMMENT '更新时间',

  `id` int(5) NOT NULL AUTO_INCREMENT,

  `userid` int(5) NULL DEFAULT NULL COMMENT '用户id',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



-- ----------------------------

-- Records of tb_order

-- ----------------------------

INSERT INTO `tb_order` VALUES ('202103031511411111', 1500, 0, NULL, NULL, NULL, '2021-03-28', '2021-03-28', 16, 1111);

INSERT INTO `tb_order` VALUES ('202103092108151111', 11, 0, NULL, NULL, NULL, '2021-03-31', '2021-03-31', 17, 1111);

INSERT INTO `tb_order` VALUES ('202104041625051111', 111, 0, NULL, NULL, NULL, '2021-04-03', '2021-04-03', 39, 1111);

INSERT INTO `tb_order` VALUES ('202104041625531111', 444, 0, NULL, NULL, NULL, '2021-04-03', '2021-04-03', 40, 1111);

INSERT INTO `tb_order` VALUES ('202104041644141111', 0, 0, NULL, NULL, NULL, '2021-04-03', '2021-04-03', 41, 1111);

INSERT INTO `tb_order` VALUES ('202104102217081111', 11, 0, NULL, NULL, NULL, '2021-04-17', '2021-04-17', 42, 1111);

INSERT INTO `tb_order` VALUES ('202104071929091111', 1, 0, NULL, NULL, NULL, '2021-04-23', '2021-04-23', 43, 1111);

INSERT INTO `tb_order` VALUES ('202104101011471111', 24, 0, NULL, NULL, NULL, '2021-04-29', '2021-04-29', 44, 1111);

INSERT INTO `tb_order` VALUES ('202104101018091111', 1, 0, NULL, NULL, NULL, '2021-04-29', '2021-04-29', 45, 1111);

INSERT INTO `tb_order` VALUES ('202104101018491111', 1, 0, NULL, NULL, NULL, '2021-04-29', '2021-04-29', 46, 1111);



-- ----------------------------

-- Table structure for tb_user

-- ----------------------------

DROP TABLE IF EXISTS `tb_user`;

CREATE TABLE `tb_user`  (

  `userid` int(5) NOT NULL AUTO_INCREMENT COMMENT '用户id',

  `loginname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录名',

  `password` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',

  `userclassify` int(1) NULL DEFAULT NULL COMMENT '0是普通用户，1是管理员',

  `realname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真实姓名',

  `idnumber` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证号',

  `integral` int(11) NULL DEFAULT NULL COMMENT '积分',

  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',

  `user_status` bigint(255) NULL DEFAULT NULL COMMENT '用户状态',

  PRIMARY KEY (`userid`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1115 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



-- ----------------------------

-- Records of tb_user

-- ----------------------------

INSERT INTO `tb_user` VALUES (1111, '123', '123456', 1, '李吉', '522128199806193731', 30000, '19117783875', 1);

INSERT INTO `tb_user` VALUES (1112, '124', '123456', 0, NULL, NULL, NULL, NULL, 1);

INSERT INTO `tb_user` VALUES (1113, '12345', '123456', NULL, '马太吉', NULL, NULL, '12345678901', NULL);

INSERT INTO `tb_user` VALUES (1114, '1234', '123456', NULL, '马太吉', '123456789011111111', NULL, '12345678901', NULL);



-- ----------------------------

-- Table structure for user_address

-- ----------------------------

DROP TABLE IF EXISTS `user_address`;

CREATE TABLE `user_address`  (

  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',

  `user_addr` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户地址',

  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1112 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



-- ----------------------------

-- Records of user_address

-- ----------------------------

INSERT INTO `user_address` VALUES (1111, '贵州省遵义市湄潭县复兴镇', 1111);



-- ----------------------------

-- Table structure for user_money

-- ----------------------------

DROP TABLE IF EXISTS `user_money`;

CREATE TABLE `user_money`  (

  `tuw` int(5) NOT NULL COMMENT '用户钱包号',

  `user_id` int(5) NULL DEFAULT NULL COMMENT '用户id',

  `user_balance` bigint(255) NULL DEFAULT NULL COMMENT '用户余额',

  `freezemoney` bigint(255) NULL DEFAULT NULL COMMENT '冻结金额',

  PRIMARY KEY (`tuw`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



-- ----------------------------

-- Records of user_money

-- ----------------------------

INSERT INTO `user_money` VALUES (1111, 1111, 1, 111);



SET FOREIGN_KEY_CHECKS = 1;
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/mataijikarl/e-book-city.git
[email protected]:mataijikarl/e-book-city.git
mataijikarl
e-book-city
springboot vue电子书城
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部