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

WZM/books

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
克隆/下载
book.sql 19.36 KB
一键复制 编辑 原始数据 按行查看 历史
WZM 提交于 2022-10-11 12:03 . first commit
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241
/*

 Navicat Premium Data Transfer



 Source Server         : APP

 Source Server Type    : MySQL

 Source Server Version : 50732

 Source Host           : localhost:3306

 Source Schema         : book



 Target Server Type    : MySQL

 Target Server Version : 50732

 File Encoding         : 65001



 Date: 11/10/2022 11:55:10

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



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

-- Table structure for sp_admin

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

DROP TABLE IF EXISTS `sp_admin`;

CREATE TABLE `sp_admin`  (

  `id` tinyint(4) NOT NULL,

  `admin_name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `admin_pwd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



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

-- Records of sp_admin

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

INSERT INTO `sp_admin` VALUES (1, 'admin', '123456', '管理员');

INSERT INTO `sp_admin` VALUES (2, 'wzm', '1940610519', 'admin');

INSERT INTO `sp_admin` VALUES (3, 'wangziming', '12345678', 'dsb');



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

-- Table structure for sp_book

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

DROP TABLE IF EXISTS `sp_book`;

CREATE TABLE `sp_book`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '书籍id',

  `book_id` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号',

  `book_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '书名',

  `author` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者',

  `price` double(5, 2) NULL DEFAULT NULL COMMENT '价格',

  `img` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '图片',

  `category_id` int(11) NULL DEFAULT NULL COMMENT '分类ID',

  `introduction` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '介绍',

  `publisher` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出版社',

  `inventory` int(20) NULL DEFAULT NULL COMMENT '数量',

  `state` int(2) NULL DEFAULT NULL COMMENT '图书状态',

  `time` date NULL DEFAULT NULL COMMENT '上架时间',

  `sales_volume` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销量',

  `page_view` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '浏览量',

  `collections` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收藏量',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



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

-- Records of sp_book

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

INSERT INTO `sp_book` VALUES (1, '0101001', 'Vue.js设计与实现', '霍春阳', 119.80, 'http://47.108.175.156:8888/down/fNuKOYdCYJkz', 10, '基于Vue3.js，深入解析Vue.js设计细节', '人民邮电出版社', 100, 1, '2021-05-05', '1000', '50000', NULL);

INSERT INTO `sp_book` VALUES (2, '0101002', 'JavaScript高级程序设计（第4版）', '【美】马特·弗里斯比', 129.00, 'http://47.108.175.156:8888/down/1KaLjPpe4EwV', 10, '红宝书', '人民邮电出版社', 50, 1, '2019-12-31', '10000', '99999', NULL);

INSERT INTO `sp_book` VALUES (4, '0101003', '深入浅出Vue.js', '刘博文', 79.00, 'http://47.108.175.156:8888/down/3IPOSdkWhhWK', 10, '从源码层面分析了Vue.js', '人民邮电出版社', 40, 1, '2022-05-17', '499', '9999', NULL);

INSERT INTO `sp_book` VALUES (5, '0112001', 'MySQL基础教程', '【日】西泽梦路', 129.00, 'http://47.108.175.156:8888/down/4cArbhvJBriv', 21, 'MySQL入门经典之作，原版3次修订，长销13年！', '人民邮电出版社', 50, 1, '2022-02-15', '6587', '6666', NULL);

INSERT INTO `sp_book` VALUES (6, '0118001', 'Unity 3D游戏开发（第2版）', '宣雨松', 89.00, 'http://47.108.175.156:8888/down/Eg615I4Zmlka', 27, 'Unity User Group意见领袖北京地区负责人雨松MOMO技术博客博主倾力打造', '人民邮电出版社', NULL, 1, '2022-05-19', NULL, NULL, NULL);

INSERT INTO `sp_book` VALUES (7, '0117001', '深度学习入门 基于Python的理论与实现', '【日】斋藤康毅', 69.80, 'http://47.108.175.156:8888/down/1tYgG8bG9GYq', 26, '深度学习入门经典 火遍日本IT圈的人气教程 累计印刷已达100000册！', '人民邮电出版社', NULL, 1, '2022-05-19', NULL, NULL, NULL);

INSERT INTO `sp_book` VALUES (14, '0122001', '全国计算机等级考试教程 二级Python语言程序设计', '策未来', 42.00, 'http://47.108.175.156:8888/down/IxEz7uhaD0ko', 33, '模拟考场 真考试题+真考环境，带您提前进“考场”', '人民邮电出版社', 0, 1, NULL, NULL, NULL, NULL);

INSERT INTO `sp_book` VALUES (15, '0104001', 'RISC-V CPU（上）处理器设计', '芯米科技生态组', 109.80, 'http://47.108.175.156:8888/down/JXGOmYATAhpR', 13, '深入浅出：介绍CPU设计和新兴开源RISC-V框架', '人民邮电出版社', 49, 1, NULL, NULL, NULL, NULL);

INSERT INTO `sp_book` VALUES (16, '0104002', 'RISC-V CPU（下）工程与实践', '芯米科技生态组', 89.00, 'http://47.108.175.156:8888/down/Z4XWAALNOXSo', 13, '深入浅出：系统介绍嵌入式开发的基础知识；\n注重实践，涵盖众多动手实践实例程序，以及实时操作系统的移植与应用', '人民邮电出版社', 60, 1, NULL, NULL, NULL, NULL);

INSERT INTO `sp_book` VALUES (17, '0204001', '动画视听语言', '殷俊 王平', 52.00, 'http://47.108.175.156:8888/down/HeUxE0t6B9PC', 37, '普通高等教育\n艺术类“十二五”规划教材', '人民邮电出版社', 19, 1, NULL, NULL, NULL, NULL);

INSERT INTO `sp_book` VALUES (18, '0119001', '嵌入式Linux应用程序开发 标准教程（第二版）', '华清远见嵌入式培训中心', 49.00, 'http://47.108.175.156:8888/down/fZjVgQnfenxi', 28, '提供36小时嵌入式专家讲座视频和教学课件', '人民邮电出版社', 5, 1, NULL, NULL, NULL, NULL);

INSERT INTO `sp_book` VALUES (19, '0121001', '基于区块链的供应链信息共享机制与管理模式研究', '付永贵', 98.00, 'http://47.108.175.156:8888/down/rKLPbojZH1bf', 32, '基于区块链的供应链信息共享机制与管理模式研究\n', '人民邮电出版社', 56, 0, NULL, NULL, NULL, NULL);

INSERT INTO `sp_book` VALUES (20, '0120001', 'MINECRAFT我的世界 高手进阶攻略', '【澳】Stephen O`Brien', 69.90, 'http://47.108.175.156:8888/down/7TF4yaBnNZPH', 29, 'MINECRAFT我的世界 高手进阶攻略\n', '人民邮电出版社', 79, 1, NULL, NULL, NULL, NULL);

INSERT INTO `sp_book` VALUES (21, '0114001', '仿生机器鱼人工侧线感知技术', '谢广明 郑兴文 瞿宇凡', 79.80, 'http://47.108.175.156:8888/down/vYMICkrCyLKW', 23, '仿生机器鱼人工侧线感知技术\n', '人民邮电出版社', 56, 1, NULL, NULL, NULL, NULL);

INSERT INTO `sp_book` VALUES (22, '0113001', '跨境电商亚马逊是如何运营的', '宁芳儒', 93.80, 'http://47.108.175.156:8888/down/GHjksN4xQiqR', 22, '从零做到年销千万实操手册', '人民邮电出版社', 89, 1, NULL, NULL, NULL, NULL);

INSERT INTO `sp_book` VALUES (23, '0204002', '超级漫画角色素描技法——百变古风角色', '三鼎动漫', 49.80, 'http://47.108.175.156:8888/down/TfpgvbMPgSdt', 37, '古风人物的头部与发型', '人民邮电出版社', 0, 0, NULL, NULL, NULL, NULL);



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

-- Table structure for sp_category

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

DROP TABLE IF EXISTS `sp_category`;

CREATE TABLE `sp_category`  (

  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '种类id',

  `category_level` int(5) NOT NULL DEFAULT 0 COMMENT '种类层级',

  `category_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '种类名称',

  `introduction` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '种类介绍',

  `cat_pid` int(5) NOT NULL COMMENT '种类父id',

  `cat_delete` int(2) NULL DEFAULT NULL COMMENT '种类是否有效',

  `category_icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '种类图片',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 73 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



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

-- Records of sp_category

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

INSERT INTO `sp_category` VALUES (1, 0, '计算机与互联网', NULL, 0, 0, '');

INSERT INTO `sp_category` VALUES (2, 0, '艺术', NULL, 0, 0, '');

INSERT INTO `sp_category` VALUES (3, 0, '管理', NULL, 0, 0, '');

INSERT INTO `sp_category` VALUES (4, 0, '考试', NULL, 0, 0, '');

INSERT INTO `sp_category` VALUES (5, 0, '电子与通信', NULL, 0, 0, '');

INSERT INTO `sp_category` VALUES (6, 0, '科普读物', NULL, 0, 0, '');

INSERT INTO `sp_category` VALUES (7, 0, '旅游/地图', NULL, 0, 0, '');

INSERT INTO `sp_category` VALUES (8, 0, '经济', NULL, 0, 0, '');

INSERT INTO `sp_category` VALUES (9, 0, '金融与投资', NULL, 0, 0, '');

INSERT INTO `sp_category` VALUES (10, 1, '编程语言和程序设计', NULL, 1, 0, 'http://47.108.175.156:8888/down/fNuKOYdCYJkz');

INSERT INTO `sp_category` VALUES (11, 1, '图形图像/视频', NULL, 1, 0, 'http://47.108.175.156:8888/down/MzY2mLWHWgaw');

INSERT INTO `sp_category` VALUES (12, 1, '操作系统', NULL, 1, 0, 'http://47.108.175.156:8888/down/vnoDa8AnIINR');

INSERT INTO `sp_category` VALUES (13, 1, '硬件与维护', NULL, 1, 0, 'http://47.108.175.156:8888/down/JXGOmYATAhpR');

INSERT INTO `sp_category` VALUES (14, 1, 'IT服务管理', NULL, 1, 0, 'http://47.108.175.156:8888/down/TkbFzp84RqPL');

INSERT INTO `sp_category` VALUES (15, 1, '网页制作', NULL, 1, 0, 'http://47.108.175.156:8888/down/OunGwlb1XbtQ');

INSERT INTO `sp_category` VALUES (16, 1, '网络与通信', NULL, 1, 0, 'http://47.108.175.156:8888/down/KwzxdcIfBrV6');

INSERT INTO `sp_category` VALUES (17, 1, '软件工程及软件方法学', NULL, 1, 0, 'http://47.108.175.156:8888/down/VLxSPnJG0XGT');

INSERT INTO `sp_category` VALUES (18, 1, '办公软件', NULL, 1, 0, 'http://47.108.175.156:8888/down/8TrOFeLva89X');

INSERT INTO `sp_category` VALUES (19, 1, '专用软件', NULL, 1, 0, 'http://47.108.175.156:8888/down/lpPSbXXUUitP');

INSERT INTO `sp_category` VALUES (20, 1, '辅助设计与工程计算', NULL, 1, 0, 'http://47.108.175.156:8888/down/6qfloW3PrLlz');

INSERT INTO `sp_category` VALUES (21, 1, '数据库', NULL, 1, 0, 'http://47.108.175.156:8888/down/4cArbhvJBriv');

INSERT INTO `sp_category` VALUES (22, 1, '电子商务', NULL, 1, 0, 'http://47.108.175.156:8888/down/GHjksN4xQiqR');

INSERT INTO `sp_category` VALUES (23, 1, '计算机控制与仿真', NULL, 1, 0, 'http://47.108.175.156:8888/down/vYMICkrCyLKW');

INSERT INTO `sp_category` VALUES (24, 1, '计算机理论、基础知识', NULL, 1, 0, 'http://47.108.175.156:8888/down/K3MhriSRozri');

INSERT INTO `sp_category` VALUES (25, 1, '单片机与嵌入式', NULL, 1, 0, 'http://47.108.175.156:8888/down/bjpkww3uE9vI');

INSERT INTO `sp_category` VALUES (26, 1, '人工智能', NULL, 1, 0, 'http://47.108.175.156:8888/down/1tYgG8bG9GYq');

INSERT INTO `sp_category` VALUES (27, 1, '游戏', NULL, 1, 0, 'http://47.108.175.156:8888/down/Eg615I4Zmlka');

INSERT INTO `sp_category` VALUES (28, 1, '计算机组织与体系结构', NULL, 1, 0, 'http://47.108.175.156:8888/down/fZjVgQnfenxi');

INSERT INTO `sp_category` VALUES (29, 1, '数码产品攻略', NULL, 1, 0, 'http://47.108.175.156:8888/down/7TF4yaBnNZPH');

INSERT INTO `sp_category` VALUES (30, 1, '计算机安全', NULL, 1, 0, 'http://47.108.175.156:8888/down/7eNeNHrKgcRE');

INSERT INTO `sp_category` VALUES (31, 1, '新手学电脑', NULL, 1, 0, 'http://47.108.175.156:8888/down/uxsxQxPpEkbx');

INSERT INTO `sp_category` VALUES (32, 1, '信息系统', NULL, 1, 0, 'http://47.108.175.156:8888/down/rKLPbojZH1bf');

INSERT INTO `sp_category` VALUES (33, 1, '考试认证', NULL, 1, 0, 'http://47.108.175.156:8888/down/IxEz7uhaD0ko');

INSERT INTO `sp_category` VALUES (34, 1, '摄影', NULL, 2, NULL, '');

INSERT INTO `sp_category` VALUES (35, 1, '绘画', NULL, 2, NULL, '');

INSERT INTO `sp_category` VALUES (36, 1, '鉴赏收藏', NULL, 2, NULL, '');

INSERT INTO `sp_category` VALUES (37, 1, '动画', NULL, 2, NULL, 'http://47.108.175.156:8888/down/TfpgvbMPgSdt');

INSERT INTO `sp_category` VALUES (38, 1, '音乐', NULL, 2, NULL, '');

INSERT INTO `sp_category` VALUES (39, 1, '设计', NULL, 2, NULL, '');

INSERT INTO `sp_category` VALUES (40, 1, '影视', NULL, 2, NULL, '');

INSERT INTO `sp_category` VALUES (41, 1, '文化', NULL, 5, NULL, '');

INSERT INTO `sp_category` VALUES (42, 1, '法律', NULL, 5, NULL, '');

INSERT INTO `sp_category` VALUES (43, 1, '管理', NULL, 6, NULL, '');

INSERT INTO `sp_category` VALUES (44, 1, '管理', NULL, 6, NULL, '');

INSERT INTO `sp_category` VALUES (45, 1, '励志成功', NULL, 6, NULL, '');

INSERT INTO `sp_category` VALUES (46, 1, '经济', NULL, 6, NULL, '');

INSERT INTO `sp_category` VALUES (47, 1, '金融投资', NULL, 6, NULL, '');

INSERT INTO `sp_category` VALUES (48, 1, '音乐', NULL, 7, NULL, '');

INSERT INTO `sp_category` VALUES (49, 1, '绘画', NULL, 7, NULL, '');

INSERT INTO `sp_category` VALUES (50, 1, '书法', NULL, 7, NULL, '');

INSERT INTO `sp_category` VALUES (51, 1, '艺术', NULL, 7, NULL, '');

INSERT INTO `sp_category` VALUES (52, 1, '摄影', NULL, 7, NULL, '');

INSERT INTO `sp_category` VALUES (53, 1, '家教', NULL, 8, NULL, '');

INSERT INTO `sp_category` VALUES (54, 1, '育儿', NULL, 8, NULL, '');

INSERT INTO `sp_category` VALUES (55, 1, '婚恋与两性', NULL, 8, NULL, '');

INSERT INTO `sp_category` VALUES (56, 1, '养生/保健', NULL, 8, NULL, '');

INSERT INTO `sp_category` VALUES (57, 1, '烹饪/美食', NULL, 8, NULL, '');

INSERT INTO `sp_category` VALUES (58, 1, '娱乐/休闲', NULL, 8, NULL, '');

INSERT INTO `sp_category` VALUES (59, 1, '旅游/地图', NULL, 8, NULL, '');

INSERT INTO `sp_category` VALUES (60, 1, '家居', NULL, 8, NULL, '');

INSERT INTO `sp_category` VALUES (61, 1, '运动/健身', NULL, 8, NULL, '');

INSERT INTO `sp_category` VALUES (62, 1, '时尚/美妆', NULL, 8, NULL, '');

INSERT INTO `sp_category` VALUES (63, 1, 'IP商品', NULL, 9, NULL, '');

INSERT INTO `sp_category` VALUES (64, 1, '音乐', NULL, 9, NULL, '');

INSERT INTO `sp_category` VALUES (65, 1, '影视', NULL, 9, NULL, '');

INSERT INTO `sp_category` VALUES (66, 1, '软件', NULL, 9, NULL, '');

INSERT INTO `sp_category` VALUES (67, 1, '教育音像', NULL, 9, NULL, '');

INSERT INTO `sp_category` VALUES (68, 1, '游戏', NULL, 9, NULL, '');

INSERT INTO `sp_category` VALUES (69, 0, '励志与成功', NULL, 0, NULL, '');

INSERT INTO `sp_category` VALUES (70, 0, '外语学习', NULL, 0, 0, '');

INSERT INTO `sp_category` VALUES (71, 0, '工业技术', NULL, 0, 0, '');

INSERT INTO `sp_category` VALUES (72, 0, '政治/军事', NULL, 0, 0, '');



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

-- Table structure for sp_catitems

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

DROP TABLE IF EXISTS `sp_catitems`;

CREATE TABLE `sp_catitems`  (

  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',

  `image_src` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '\n\n图片路径\n',

  `open_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '导航链接类型\n\n\n',

  `navigator_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '导航链接路径',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



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

-- Records of sp_catitems

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

INSERT INTO `sp_catitems` VALUES (1, '图书分类', 'http://47.108.175.156:8888/down/JvDjMXB53F3o', '', '');

INSERT INTO `sp_catitems` VALUES (2, '限时秒杀', 'http://47.108.175.156:8888/down/DSj2HEQ6mnh0', NULL, NULL);

INSERT INTO `sp_catitems` VALUES (3, '为你推荐', 'http://47.108.175.156:8888/down/K9Gk7TDTMfSg', NULL, NULL);

INSERT INTO `sp_catitems` VALUES (4, '联系我们', 'http://47.108.175.156:8888/down/1WIGvEE7lHtB', NULL, NULL);



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

-- Table structure for sp_swiper

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

DROP TABLE IF EXISTS `sp_swiper`;

CREATE TABLE `sp_swiper`  (

  `image_src` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片地址',

  `open_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '打开类型',

  `goods_id` int(5) NULL DEFAULT NULL COMMENT '商品类型',

  `navigator_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '导航地址',

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

  `introduction` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



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

-- Records of sp_swiper

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

INSERT INTO `sp_swiper` VALUES ('http://47.108.175.156:8888/down/6zrMGMi41FL8', '', NULL, '', 1, '《计算之魂》');

INSERT INTO `sp_swiper` VALUES ('http://47.108.175.156:8888/down/Na5MMto8BLJl', NULL, NULL, NULL, 2, '《如何拥抱一只刺猬》');

INSERT INTO `sp_swiper` VALUES ('http://47.108.175.156:8888/down/rQ3v1c5OD8Gw', NULL, NULL, NULL, 3, '《零基础入门学习web开发》');

INSERT INTO `sp_swiper` VALUES ('http://47.108.175.156:8888/down/kJFja3qteoFp', NULL, NULL, NULL, 4, '《ON JAVA 中文版》基础卷及进阶卷 ');



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

-- Table structure for sp_user

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

DROP TABLE IF EXISTS `sp_user`;

CREATE TABLE `sp_user`  (

  `id` bigint(4) NOT NULL AUTO_INCREMENT,

  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',

  `password` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',

  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',

  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',

  `telephone` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话号码',

  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',

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

  `cart_id` int(5) NULL DEFAULT NULL COMMENT '购物车ID',

  `photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `realName` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



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

-- Records of sp_user

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

INSERT INTO `sp_user` VALUES (1, 'wzm', '123456', '王子鸣', '2954510949qq.com', '15802860413', '四川省成都市郫都区郫筒街道百叶路一号电子科技大学成都学院', 100, 1, 'http://47.108.175.156:8888/down/DCUodFv1qliO', '王子鸣');

INSERT INTO `sp_user` VALUES (2, 'wangziming', '123456', '发申通直接拒签', 'W15802860413@163.com', '15802860413', '四川省成都市郫都区郫筒街道百叶路一号电子科技大学成都学院', 100, 2, 'http://47.108.175.156:8888/down/TQyoQ5Hb7y6K', '王子鸣');



SET FOREIGN_KEY_CHECKS = 1;
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/its-your-brother-zm/books.git
git@gitee.com:its-your-brother-zm/books.git
its-your-brother-zm
books
books
master
点此查找更多帮助

搜索帮助

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