• Java-微服务-谷粒商城-1-环境搭建&项目初始化

    基于Windows搭建环境

    尚硅谷谷-粒商城，所有资料在这里：https://share.weiyun.com/bO0OZMCv

    哔哩哔哩视频：https://www.bilibili.com/video/BV1np4y1C7Yf

    本章内容所需环境：

    • virtualbox
    • vagrant centos
    • git
    • IDEA
    • jdk1.8
    • docker mysql
    • docker redis

    详细搭建步骤请查阅：https://www.cnblogs.com/gsxl/p/16380391.html

    git请参考：https://www.cnblogs.com/gsxl/p/13580889.html

    一、项目初始化

    使用码云，只因为是国内访问比较方便。

    1、创建java谷粒商城仓库

    2、本地电脑克隆

    git clone https://gitee.com/qq772262624/gulimall -b develop

     3、IDEA打开项目，进行初始化

    New Module Sprint

    将所有的微服务都创建完成

    聚合服务的pom.xml：

    1. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    2.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    3.     <modelVersion>4.0.0</modelVersion>
    4.     <groupId>com.atguigu.gulimall</groupId>
    5.     <artifactId>gulimall</artifactId>
    6.     <version>0.0.1-SNAPSHOT</version>
    7.     <name>gulimall</name>
    8.     <description>谷粒商城-聚合服务</description>
    9.     <packaging>pom</packaging>
    10.     <modules>
    11.         <module>gulimall-coupon</module>
    12.         <module>gulimall-member</module>
    13.         <module>gulimall-order</module>
    14.         <module>gulimall-product</module>
    15.         <module>gulimall-ware</module>
    16.     </modules>
    17. </project>

     二、数据库初始化

    1、使用mysql连接工具，直接拽sql文件进来运行即可。

    sql文件：

    1. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    2. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    3. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    4. /*!40101 SET NAMES utf8 */;
    5. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    6. /*!40103 SET TIME_ZONE='+00:00' */;
    7. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    8. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    9. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    10. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    11. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    12. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    13. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    14.  
    15.  
    16. /*==============================================================*/
    17. # database：gulimall_oms
    18. /*==============================================================*/
    19. CREATE DATABASE `gulimall_oms` DEFAULT CHARACTER SET utf8mb4;
    20. USE `gulimall_oms`;
    21.  
    22. drop table if exists oms_order;
    23.  
    24. drop table if exists oms_order_item;
    25.  
    26. drop table if exists oms_order_operate_history;
    27.  
    28. drop table if exists oms_order_return_apply;
    29.  
    30. drop table if exists oms_order_return_reason;
    31.  
    32. drop table if exists oms_order_setting;
    33.  
    34. drop table if exists oms_payment_info;
    35.  
    36. drop table if exists oms_refund_info;
    37.  
    38. /*==============================================================*/
    39. /* Table: oms_order                                             */
    40. /*==============================================================*/
    41. create table oms_order
    42. (
    43.     id                      bigint not null auto_increment comment 'id',
    44.     member_id               bigint comment 'member_id',
    45.     order_sn                char(32) comment '订单号',
    46.     coupon_id               bigint comment '使用的优惠券',
    47.     create_time             datetime comment 'create_time',
    48.     member_username         varchar(200) comment '用户名',
    49.     total_amount            decimal(18, 4) comment '订单总额',
    50.     pay_amount              decimal(18, 4) comment '应付总额',
    51.     freight_amount          decimal(18, 4) comment '运费金额',
    52.     promotion_amount        decimal(18, 4) comment '促销优化金额(促销价、满减、阶梯价)',
    53.     integration_amount      decimal(18, 4) comment '积分抵扣金额',
    54.     coupon_amount           decimal(18, 4) comment '优惠券抵扣金额',
    55.     discount_amount         decimal(18, 4) comment '后台调整订单使用的折扣金额',
    56.     pay_type                tinyint comment '支付方式【1->支付宝；2->微信；3->银联； 4->货到付款；】',
    57.     source_type             tinyint comment '订单来源[0->PC订单；1->app订单]',
    58.     status                  tinyint comment '订单状态【0->待付款；1->待发货；2->已发货；3->已完成；4->已关闭；5->无效订单】',
    59.     delivery_company        varchar(64) comment '物流公司(配送方式)',
    60.     delivery_sn             varchar(64) comment '物流单号',
    61.     auto_confirm_day        int comment '自动确认时间(天)',
    62.     integration             int comment '可以获得的积分',
    63.     growth                  int comment '可以获得的成长值',
    64.     bill_type               tinyint comment '发票类型[0->不开发票；1->电子发票；2->纸质发票]',
    65.     bill_header             varchar(255) comment '发票抬头',
    66.     bill_content            varchar(255) comment '发票内容',
    67.     bill_receiver_phone     varchar(32) comment '收票人电话',
    68.     bill_receiver_email     varchar(64) comment '收票人邮箱',
    69.     receiver_name           varchar(100) comment '收货人姓名',
    70.     receiver_phone          varchar(32) comment '收货人电话',
    71.     receiver_post_code      varchar(32) comment '收货人邮编',
    72.     receiver_province       varchar(32) comment '省份/直辖市',
    73.     receiver_city           varchar(32) comment '城市',
    74.     receiver_region         varchar(32) comment '区',
    75.     receiver_detail_address varchar(200) comment '详细地址',
    76.     note                    varchar(500) comment '订单备注',
    77.     confirm_status          tinyint comment '确认收货状态[0->未确认；1->已确认]',
    78.     delete_status           tinyint comment '删除状态【0->未删除；1->已删除】',
    79.     use_integration         int comment '下单时使用的积分',
    80.     payment_time            datetime comment '支付时间',
    81.     delivery_time           datetime comment '发货时间',
    82.     receive_time            datetime comment '确认收货时间',
    83.     comment_time            datetime comment '评价时间',
    84.     modify_time             datetime comment '修改时间',
    85.     primary key (id)
    86. );
    87.  
    88. alter table oms_order
    89.     comment '订单';
    90.  
    91. /*==============================================================*/
    92. /* Table: oms_order_item                                        */
    93. /*==============================================================*/
    94. create table oms_order_item
    95. (
    96.     id                 bigint not null auto_increment comment 'id',
    97.     order_id           bigint comment 'order_id',
    98.     order_sn           char(32) comment 'order_sn',
    99.     spu_id             bigint comment 'spu_id',
    100.     spu_name           varchar(255) comment 'spu_name',
    101.     spu_pic            varchar(500) comment 'spu_pic',
    102.     spu_brand          varchar(200) comment '品牌',
    103.     category_id        bigint comment '商品分类id',
    104.     sku_id             bigint comment '商品sku编号',
    105.     sku_name           varchar(255) comment '商品sku名字',
    106.     sku_pic            varchar(500) comment '商品sku图片',
    107.     sku_price          decimal(18, 4) comment '商品sku价格',
    108.     sku_quantity       int comment '商品购买的数量',
    109.     sku_attrs_vals     varchar(500) comment '商品销售属性组合(JSON)',
    110.     promotion_amount   decimal(18, 4) comment '商品促销分解金额',
    111.     coupon_amount      decimal(18, 4) comment '优惠券优惠分解金额',
    112.     integration_amount decimal(18, 4) comment '积分优惠分解金额',
    113.     real_amount        decimal(18, 4) comment '该商品经过优惠后的分解金额',
    114.     gift_integration   int comment '赠送积分',
    115.     gift_growth        int comment '赠送成长值',
    116.     primary key (id)
    117. );
    118.  
    119. alter table oms_order_item
    120.     comment '订单项信息';
    121.  
    122. /*==============================================================*/
    123. /* Table: oms_order_operate_history                             */
    124. /*==============================================================*/
    125. create table oms_order_operate_history
    126. (
    127.     id           bigint not null auto_increment comment 'id',
    128.     order_id     bigint comment '订单id',
    129.     operate_man  varchar(100) comment '操作人[用户；系统；后台管理员]',
    130.     create_time  datetime comment '操作时间',
    131.     order_status tinyint comment '订单状态【0->待付款；1->待发货；2->已发货；3->已完成；4->已关闭；5->无效订单】',
    132.     note         varchar(500) comment '备注',
    133.     primary key (id)
    134. );
    135.  
    136. alter table oms_order_operate_history
    137.     comment '订单操作历史记录';
    138.  
    139. /*==============================================================*/
    140. /* Table: oms_order_return_apply                                */
    141. /*==============================================================*/
    142. create table oms_order_return_apply
    143. (
    144.     id              bigint not null auto_increment comment 'id',
    145.     order_id        bigint comment 'order_id',
    146.     sku_id          bigint comment '退货商品id',
    147.     order_sn        char(32) comment '订单编号',
    148.     create_time     datetime comment '申请时间',
    149.     member_username varchar(64) comment '会员用户名',
    150.     return_amount   decimal(18, 4) comment '退款金额',
    151.     return_name     varchar(100) comment '退货人姓名',
    152.     return_phone    varchar(20) comment '退货人电话',
    153.     status          tinyint(1) comment '申请状态[0->待处理；1->退货中；2->已完成；3->已拒绝]',
    154.     handle_time     datetime comment '处理时间',
    155.     sku_img         varchar(500) comment '商品图片',
    156.     sku_name        varchar(200) comment '商品名称',
    157.     sku_brand       varchar(200) comment '商品品牌',
    158.     sku_attrs_vals  varchar(500) comment '商品销售属性(JSON)',
    159.     sku_count       int comment '退货数量',
    160.     sku_price       decimal(18, 4) comment '商品单价',
    161.     sku_real_price  decimal(18, 4) comment '商品实际支付单价',
    162.     reason          varchar(200) comment '原因',
    163.     description述    varchar(500) comment '描述',
    164.     desc_pics       varchar(2000) comment '凭证图片，以逗号隔开',
    165.     handle_note     varchar(500) comment '处理备注',
    166.     handle_man      varchar(200) comment '处理人员',
    167.     receive_man     varchar(100) comment '收货人',
    168.     receive_time    datetime comment '收货时间',
    169.     receive_note    varchar(500) comment '收货备注',
    170.     receive_phone   varchar(20) comment '收货电话',
    171.     company_address varchar(500) comment '公司收货地址',
    172.     primary key (id)
    173. );
    174.  
    175. alter table oms_order_return_apply
    176.     comment '订单退货申请';
    177.  
    178. /*==============================================================*/
    179. /* Table: oms_order_return_reason                               */
    180. /*==============================================================*/
    181. create table oms_order_return_reason
    182. (
    183.     id          bigint not null auto_increment comment 'id',
    184.     name        varchar(200) comment '退货原因名',
    185.     sort        int comment '排序',
    186.     status      tinyint(1) comment '启用状态',
    187.     create_time datetime comment 'create_time',
    188.     primary key (id)
    189. );
    190.  
    191. alter table oms_order_return_reason
    192.     comment '退货原因';
    193.  
    194. /*==============================================================*/
    195. /* Table: oms_order_setting                                     */
    196. /*==============================================================*/
    197. create table oms_order_setting
    198. (
    199.     id                    bigint not null auto_increment comment 'id',
    200.     flash_order_overtime  int comment '秒杀订单超时关闭时间(分)',
    201.     normal_order_overtime int comment '正常订单超时时间(分)',
    202.     confirm_overtime      int comment '发货后自动确认收货时间(天)',
    203.     finish_overtime       int comment '自动完成交易时间，不能申请退货(天)',
    204.     comment_overtime      int comment '订单完成后自动好评时间(天)',
    205.     member_level          tinyint(2) comment '会员等级【0-不限会员等级，全部通用；其他-对应的其他会员等级】',
    206.     primary key (id)
    207. );
    208.  
    209. alter table oms_order_setting
    210.     comment '订单配置信息';
    211.  
    212. /*==============================================================*/
    213. /* Table: oms_payment_info                                      */
    214. /*==============================================================*/
    215. create table oms_payment_info
    216. (
    217.     id               bigint not null auto_increment comment 'id',
    218.     order_sn         char(32) comment '订单号(对外业务号)',
    219.     order_id         bigint comment '订单id',
    220.     alipay_trade_no  varchar(50) comment '支付宝交易流水号',
    221.     total_amount     decimal(18, 4) comment '支付总金额',
    222.     subject          varchar(200) comment '交易内容',
    223.     payment_status   varchar(20) comment '支付状态',
    224.     create_time      datetime comment '创建时间',
    225.     confirm_time     datetime comment '确认时间',
    226.     callback_content varchar(4000) comment '回调内容',
    227.     callback_time    datetime comment '回调时间',
    228.     primary key (id)
    229. );
    230.  
    231. alter table oms_payment_info
    232.     comment '支付信息表';
    233.  
    234. /*==============================================================*/
    235. /* Table: oms_refund_info                                       */
    236. /*==============================================================*/
    237. create table oms_refund_info
    238. (
    239.     id              bigint not null auto_increment comment 'id',
    240.     order_return_id bigint comment '退款的订单',
    241.     refund          decimal(18, 4) comment '退款金额',
    242.     refund_sn       varchar(64) comment '退款交易流水号',
    243.     refund_status   tinyint(1) comment '退款状态',
    244.     refund_channel  tinyint comment '退款渠道[1-支付宝，2-微信，3-银联，4-汇款]',
    245.     refund_content  varchar(5000),
    246.     primary key (id)
    247. );
    248.  
    249. alter table oms_refund_info
    250.     comment '退款信息';
    251.  
    252. /*==============================================================*/
    253. # database：gulimall_pms
    254. /*==============================================================*/
    255. CREATE DATABASE `gulimall_pms` DEFAULT CHARACTER SET utf8mb4;
    256. USE `gulimall_pms`;
    257.  
    258. drop table if exists pms_attr;
    259.  
    260. drop table if exists pms_attr_attrgroup_relation;
    261.  
    262. drop table if exists pms_attr_group;
    263.  
    264. drop table if exists pms_brand;
    265.  
    266. drop table if exists pms_category;
    267.  
    268. drop table if exists pms_category_brand_relation;
    269.  
    270. drop table if exists pms_comment_replay;
    271.  
    272. drop table if exists pms_product_attr_value;
    273.  
    274. drop table if exists pms_sku_images;
    275.  
    276. drop table if exists pms_sku_info;
    277.  
    278. drop table if exists pms_sku_sale_attr_value;
    279.  
    280. drop table if exists pms_spu_comment;
    281.  
    282. drop table if exists pms_spu_images;
    283.  
    284. drop table if exists pms_spu_info;
    285.  
    286. drop table if exists pms_spu_info_desc;
    287.  
    288. /*==============================================================*/
    289. /* Table: pms_attr                                              */
    290. /*==============================================================*/
    291. create table pms_attr
    292. (
    293.     attr_id              bigint not null auto_increment comment '属性id',
    294.     attr_name            char(30) comment '属性名',
    295.     search_type          tinyint comment '是否需要检索[0-不需要，1-需要]',
    296.     icon                 varchar(255) comment '属性图标',
    297.     value_select         char(255) comment '可选值列表[用逗号分隔]',
    298.     attr_type            tinyint comment '属性类型[0-销售属性，1-基本属性，2-既是销售属性又是基本属性]',
    299.     enable               bigint comment '启用状态[0 - 禁用，1 - 启用]',
    300.     catelog_id           bigint comment '所属分类',
    301.     show_desc            tinyint comment '快速展示【是否展示在介绍上；0-否 1-是】，在sku中仍然可以调整',
    302.     primary key (attr_id)
    303. );
    304.  
    305. alter table pms_attr comment '商品属性';
    306.  
    307. /*==============================================================*/
    308. /* Table: pms_attr_attrgroup_relation                           */
    309. /*==============================================================*/
    310. create table pms_attr_attrgroup_relation
    311. (
    312.     id                   bigint not null auto_increment comment 'id',
    313.     attr_id              bigint comment '属性id',
    314.     attr_group_id        bigint comment '属性分组id',
    315.     attr_sort            int comment '属性组内排序',
    316.     primary key (id)
    317. );
    318.  
    319. alter table pms_attr_attrgroup_relation comment '属性&属性分组关联';
    320.  
    321. /*==============================================================*/
    322. /* Table: pms_attr_group                                        */
    323. /*==============================================================*/
    324. create table pms_attr_group
    325. (
    326.     attr_group_id        bigint not null auto_increment comment '分组id',
    327.     attr_group_name      char(20) comment '组名',
    328.     sort                 int comment '排序',
    329.     descript             varchar(255) comment '描述',
    330.     icon                 varchar(255) comment '组图标',
    331.     catelog_id           bigint comment '所属分类id',
    332.     primary key (attr_group_id)
    333. );
    334.  
    335. alter table pms_attr_group comment '属性分组';
    336.  
    337. /*==============================================================*/
    338. /* Table: pms_brand                                             */
    339. /*==============================================================*/
    340. create table pms_brand
    341. (
    342.     brand_id             bigint not null auto_increment comment '品牌id',
    343.     name                 char(50) comment '品牌名',
    344.     logo                 varchar(2000) comment '品牌logo地址',
    345.     descript             longtext comment '介绍',
    346.     show_status          tinyint comment '显示状态[0-不显示；1-显示]',
    347.     first_letter         char(1) comment '检索首字母',
    348.     sort                 int comment '排序',
    349.     primary key (brand_id)
    350. );
    351.  
    352. alter table pms_brand comment '品牌';
    353.  
    354. /*==============================================================*/
    355. /* Table: pms_category                                          */
    356. /*==============================================================*/
    357. create table pms_category
    358. (
    359.     cat_id               bigint not null auto_increment comment '分类id',
    360.     name                 char(50) comment '分类名称',
    361.     parent_cid           bigint comment '父分类id',
    362.     cat_level            int comment '层级',
    363.     show_status          tinyint comment '是否显示[0-不显示，1显示]',
    364.     sort                 int comment '排序',
    365.     icon                 char(255) comment '图标地址',
    366.     product_unit         char(50) comment '计量单位',
    367.     product_count        int comment '商品数量',
    368.     primary key (cat_id)
    369. );
    370.  
    371. alter table pms_category comment '商品三级分类';
    372.  
    373. /*==============================================================*/
    374. /* Table: pms_category_brand_relation                           */
    375. /*==============================================================*/
    376. create table pms_category_brand_relation
    377. (
    378.     id                   bigint not null auto_increment,
    379.     brand_id             bigint comment '品牌id',
    380.     catelog_id           bigint comment '分类id',
    381.     brand_name           varchar(255),
    382.     catelog_name         varchar(255),
    383.     primary key (id)
    384. );
    385.  
    386. alter table pms_category_brand_relation comment '品牌分类关联';
    387.  
    388. /*==============================================================*/
    389. /* Table: pms_comment_replay                                    */
    390. /*==============================================================*/
    391. create table pms_comment_replay
    392. (
    393.     id                   bigint not null auto_increment comment 'id',
    394.     comment_id           bigint comment '评论id',
    395.     reply_id             bigint comment '回复id',
    396.     primary key (id)
    397. );
    398.  
    399. alter table pms_comment_replay comment '商品评价回复关系';
    400.  
    401. /*==============================================================*/
    402. /* Table: pms_product_attr_value                                */
    403. /*==============================================================*/
    404. create table pms_product_attr_value
    405. (
    406.     id                   bigint not null auto_increment comment 'id',
    407.     spu_id               bigint comment '商品id',
    408.     attr_id              bigint comment '属性id',
    409.     attr_name            varchar(200) comment '属性名',
    410.     attr_value           varchar(200) comment '属性值',
    411.     attr_sort            int comment '顺序',
    412.     quick_show           tinyint comment '快速展示【是否展示在介绍上；0-否 1-是】',
    413.     primary key (id)
    414. );
    415.  
    416. alter table pms_product_attr_value comment 'spu属性值';
    417.  
    418. /*==============================================================*/
    419. /* Table: pms_sku_images                                        */
    420. /*==============================================================*/
    421. create table pms_sku_images
    422. (
    423.     id                   bigint not null auto_increment comment 'id',
    424.     sku_id               bigint comment 'sku_id',
    425.     img_url              varchar(255) comment '图片地址',
    426.     img_sort             int comment '排序',
    427.     default_img          int comment '默认图[0 - 不是默认图，1 - 是默认图]',
    428.     primary key (id)
    429. );
    430.  
    431. alter table pms_sku_images comment 'sku图片';
    432.  
    433. /*==============================================================*/
    434. /* Table: pms_sku_info                                          */
    435. /*==============================================================*/
    436. create table pms_sku_info
    437. (
    438.     sku_id               bigint not null auto_increment comment 'skuId',
    439.     spu_id               bigint comment 'spuId',
    440.     sku_name             varchar(255) comment 'sku名称',
    441.     sku_desc             varchar(2000) comment 'sku介绍描述',
    442.     catalog_id           bigint comment '所属分类id',
    443.     brand_id             bigint comment '品牌id',
    444.     sku_default_img      varchar(255) comment '默认图片',
    445.     sku_title            varchar(255) comment '标题',
    446.     sku_subtitle         varchar(2000) comment '副标题',
    447.     price                decimal(18,4) comment '价格',
    448.     sale_count           bigint comment '销量',
    449.     primary key (sku_id)
    450. );
    451.  
    452. alter table pms_sku_info comment 'sku信息';
    453.  
    454. /*==============================================================*/
    455. /* Table: pms_sku_sale_attr_value                               */
    456. /*==============================================================*/
    457. create table pms_sku_sale_attr_value
    458. (
    459.     id                   bigint not null auto_increment comment 'id',
    460.     sku_id               bigint comment 'sku_id',
    461.     attr_id              bigint comment 'attr_id',
    462.     attr_name            varchar(200) comment '销售属性名',
    463.     attr_value           varchar(200) comment '销售属性值',
    464.     attr_sort            int comment '顺序',
    465.     primary key (id)
    466. );
    467.  
    468. alter table pms_sku_sale_attr_value comment 'sku销售属性&值';
    469.  
    470. /*==============================================================*/
    471. /* Table: pms_spu_comment                                       */
    472. /*==============================================================*/
    473. create table pms_spu_comment
    474. (
    475.     id                   bigint not null auto_increment comment 'id',
    476.     sku_id               bigint comment 'sku_id',
    477.     spu_id               bigint comment 'spu_id',
    478.     spu_name             varchar(255) comment '商品名字',
    479.     member_nick_name     varchar(255) comment '会员昵称',
    480.     star                 tinyint(1) comment '星级',
    481.     member_ip            varchar(64) comment '会员ip',
    482.     create_time          datetime comment '创建时间',
    483.     show_status          tinyint(1) comment '显示状态[0-不显示，1-显示]',
    484.     spu_attributes       varchar(255) comment '购买时属性组合',
    485.     likes_count          int comment '点赞数',
    486.     reply_count          int comment '回复数',
    487.     resources            varchar(1000) comment '评论图片/视频[json数据；[{type:文件类型,url:资源路径}]]',
    488.     content              text comment '内容',
    489.     member_icon          varchar(255) comment '用户头像',
    490.     comment_type         tinyint comment '评论类型[0 - 对商品的直接评论，1 - 对评论的回复]',
    491.     primary key (id)
    492. );
    493.  
    494. alter table pms_spu_comment comment '商品评价';
    495.  
    496. /*==============================================================*/
    497. /* Table: pms_spu_images                                        */
    498. /*==============================================================*/
    499. create table pms_spu_images
    500. (
    501.     id                   bigint not null auto_increment comment 'id',
    502.     spu_id               bigint comment 'spu_id',
    503.     img_name             varchar(200) comment '图片名',
    504.     img_url              varchar(255) comment '图片地址',
    505.     img_sort             int comment '顺序',
    506.     default_img          tinyint comment '是否默认图',
    507.     primary key (id)
    508. );
    509.  
    510. alter table pms_spu_images comment 'spu图片';
    511.  
    512. /*==============================================================*/
    513. /* Table: pms_spu_info                                          */
    514. /*==============================================================*/
    515. create table pms_spu_info
    516. (
    517.     id                   bigint not null auto_increment comment '商品id',
    518.     spu_name             varchar(200) comment '商品名称',
    519.     spu_description      varchar(1000) comment '商品描述',
    520.     catalog_id           bigint comment '所属分类id',
    521.     brand_id             bigint comment '品牌id',
    522.     weight               decimal(18,4),
    523.     publish_status       tinyint comment '上架状态[0 - 下架，1 - 上架]',
    524.     create_time          datetime,
    525.     update_time          datetime,
    526.     primary key (id)
    527. );
    528.  
    529. alter table pms_spu_info comment 'spu信息';
    530.  
    531. /*==============================================================*/
    532. /* Table: pms_spu_info_desc                                     */
    533. /*==============================================================*/
    534. create table pms_spu_info_desc
    535. (
    536.     spu_id               bigint not null comment '商品id',
    537.     decript              longtext comment '商品介绍',
    538.     primary key (spu_id)
    539. );
    540.  
    541. alter table pms_spu_info_desc comment 'spu信息介绍';
    542.  
    543. /*==============================================================*/
    544. # database：gulimall_sms
    545. /*==============================================================*/
    546. CREATE DATABASE `gulimall_sms` DEFAULT CHARACTER SET utf8mb4;
    547. USE `gulimall_sms`;
    548.  
    549. drop table if exists sms_coupon;
    550.  
    551. drop table if exists sms_coupon_history;
    552.  
    553. drop table if exists sms_coupon_spu_category_relation;
    554.  
    555. drop table if exists sms_coupon_spu_relation;
    556.  
    557. drop table if exists sms_home_adv;
    558.  
    559. drop table if exists sms_home_subject;
    560.  
    561. drop table if exists sms_home_subject_spu;
    562.  
    563. drop table if exists sms_member_price;
    564.  
    565. drop table if exists sms_seckill_promotion;
    566.  
    567. drop table if exists sms_seckill_session;
    568.  
    569. drop table if exists sms_seckill_sku_notice;
    570.  
    571. drop table if exists sms_seckill_sku_relation;
    572.  
    573. drop table if exists sms_sku_full_reduction;
    574.  
    575. drop table if exists sms_sku_ladder;
    576.  
    577. drop table if exists sms_spu_bounds;
    578.  
    579. /*==============================================================*/
    580. /* Table: sms_coupon                                            */
    581. /*==============================================================*/
    582. create table sms_coupon
    583. (
    584.     id                   bigint not null auto_increment comment 'id',
    585.     coupon_type          tinyint(1) comment '优惠卷类型[0->全场赠券；1->会员赠券；2->购物赠券；3->注册赠券]',
    586.     coupon_img           varchar(2000) comment '优惠券图片',
    587.     coupon_name          varchar(100) comment '优惠卷名字',
    588.     num                  int comment '数量',
    589.     amount               decimal(18,4) comment '金额',
    590.     per_limit            int comment '每人限领张数',
    591.     min_point            decimal(18,4) comment '使用门槛',
    592.     start_time           datetime comment '开始时间',
    593.     end_time             datetime comment '结束时间',
    594.     use_type             tinyint(1) comment '使用类型[0->全场通用；1->指定分类；2->指定商品]',
    595.     note                 varchar(200) comment '备注',
    596.     publish_count        int(11) comment '发行数量',
    597.     use_count            int(11) comment '已使用数量',
    598.     receive_count        int(11) comment '领取数量',
    599.     enable_start_time    datetime comment '可以领取的开始日期',
    600.     enable_end_time      datetime comment '可以领取的结束日期',
    601.     code                 varchar(64) comment '优惠码',
    602.     member_level         tinyint(1) comment '可以领取的会员等级[0->不限等级，其他-对应等级]',
    603.     publish              tinyint(1) comment '发布状态[0-未发布，1-已发布]',
    604.     primary key (id)
    605. );
    606.  
    607. alter table sms_coupon comment '优惠券信息';
    608.  
    609. /*==============================================================*/
    610. /* Table: sms_coupon_history                                    */
    611. /*==============================================================*/
    612. create table sms_coupon_history
    613. (
    614.     id                   bigint not null auto_increment comment 'id',
    615.     coupon_id            bigint comment '优惠券id',
    616.     member_id            bigint comment '会员id',
    617.     member_nick_name     varchar(64) comment '会员名字',
    618.     get_type             tinyint(1) comment '获取方式[0->后台赠送；1->主动领取]',
    619.     create_time          datetime comment '创建时间',
    620.     use_type             tinyint(1) comment '使用状态[0->未使用；1->已使用；2->已过期]',
    621.     use_time             datetime comment '使用时间',
    622.     order_id             bigint comment '订单id',
    623.     order_sn             bigint comment '订单号',
    624.     primary key (id)
    625. );
    626.  
    627. alter table sms_coupon_history comment '优惠券领取历史记录';
    628.  
    629. /*==============================================================*/
    630. /* Table: sms_coupon_spu_category_relation                      */
    631. /*==============================================================*/
    632. create table sms_coupon_spu_category_relation
    633. (
    634.     id                   bigint not null auto_increment comment 'id',
    635.     coupon_id            bigint comment '优惠券id',
    636.     category_id          bigint comment '产品分类id',
    637.     category_name        varchar(64) comment '产品分类名称',
    638.     primary key (id)
    639. );
    640.  
    641. alter table sms_coupon_spu_category_relation comment '优惠券分类关联';
    642.  
    643. /*==============================================================*/
    644. /* Table: sms_coupon_spu_relation                               */
    645. /*==============================================================*/
    646. create table sms_coupon_spu_relation
    647. (
    648.     id                   bigint not null auto_increment comment 'id',
    649.     coupon_id            bigint comment '优惠券id',
    650.     spu_id               bigint comment 'spu_id',
    651.     spu_name             varchar(255) comment 'spu_name',
    652.     primary key (id)
    653. );
    654.  
    655. alter table sms_coupon_spu_relation comment '优惠券与产品关联';
    656.  
    657. /*==============================================================*/
    658. /* Table: sms_home_adv                                          */
    659. /*==============================================================*/
    660. create table sms_home_adv
    661. (
    662.     id                   bigint not null auto_increment comment 'id',
    663.     name                 varchar(100) comment '名字',
    664.     pic                  varchar(500) comment '图片地址',
    665.     start_time           datetime comment '开始时间',
    666.     end_time             datetime comment '结束时间',
    667.     status               tinyint(1) comment '状态',
    668.     click_count          int comment '点击数',
    669.     url                  varchar(500) comment '广告详情连接地址',
    670.     note                 varchar(500) comment '备注',
    671.     sort                 int comment '排序',
    672.     publisher_id         bigint comment '发布者',
    673.     auth_id              bigint comment '审核者',
    674.     primary key (id)
    675. );
    676.  
    677. alter table sms_home_adv comment '首页轮播广告';
    678.  
    679. /*==============================================================*/
    680. /* Table: sms_home_subject                                      */
    681. /*==============================================================*/
    682. create table sms_home_subject
    683. (
    684.     id                   bigint not null auto_increment comment 'id',
    685.     name                 varchar(200) comment '专题名字',
    686.     title                varchar(255) comment '专题标题',
    687.     sub_title            varchar(255) comment '专题副标题',
    688.     status               tinyint(1) comment '显示状态',
    689.     url                  varchar(500) comment '详情连接',
    690.     sort                 int comment '排序',
    691.     img                  varchar(500) comment '专题图片地址',
    692.     primary key (id)
    693. );
    694.  
    695. alter table sms_home_subject comment '首页专题表【jd首页下面很多专题，每个专题链接新的页面，展示专题商品信息】';
    696.  
    697. /*==============================================================*/
    698. /* Table: sms_home_subject_spu                                  */
    699. /*==============================================================*/
    700. create table sms_home_subject_spu
    701. (
    702.     id                   bigint not null auto_increment comment 'id',
    703.     name                 varchar(200) comment '专题名字',
    704.     subject_id           bigint comment '专题id',
    705.     spu_id               bigint comment 'spu_id',
    706.     sort                 int comment '排序',
    707.     primary key (id)
    708. );
    709.  
    710. alter table sms_home_subject_spu comment '专题商品';
    711.  
    712. /*==============================================================*/
    713. /* Table: sms_member_price                                      */
    714. /*==============================================================*/
    715. create table sms_member_price
    716. (
    717.     id                   bigint not null auto_increment comment 'id',
    718.     sku_id               bigint comment 'sku_id',
    719.     member_level_id      bigint comment '会员等级id',
    720.     member_level_name    varchar(100) comment '会员等级名',
    721.     member_price         decimal(18,4) comment '会员对应价格',
    722.     add_other            tinyint(1) comment '可否叠加其他优惠[0-不可叠加优惠，1-可叠加]',
    723.     primary key (id)
    724. );
    725.  
    726. alter table sms_member_price comment '商品会员价格';
    727.  
    728. /*==============================================================*/
    729. /* Table: sms_seckill_promotion                                 */
    730. /*==============================================================*/
    731. create table sms_seckill_promotion
    732. (
    733.     id                   bigint not null auto_increment comment 'id',
    734.     title                varchar(255) comment '活动标题',
    735.     start_time           datetime comment '开始日期',
    736.     end_time             datetime comment '结束日期',
    737.     status               tinyint comment '上下线状态',
    738.     create_time          datetime comment '创建时间',
    739.     user_id              bigint comment '创建人',
    740.     primary key (id)
    741. );
    742.  
    743. alter table sms_seckill_promotion comment '秒杀活动';
    744.  
    745. /*==============================================================*/
    746. /* Table: sms_seckill_session                                   */
    747. /*==============================================================*/
    748. create table sms_seckill_session
    749. (
    750.     id                   bigint not null auto_increment comment 'id',
    751.     name                 varchar(200) comment '场次名称',
    752.     start_time           datetime comment '每日开始时间',
    753.     end_time             datetime comment '每日结束时间',
    754.     status               tinyint(1) comment '启用状态',
    755.     create_time          datetime comment '创建时间',
    756.     primary key (id)
    757. );
    758.  
    759. alter table sms_seckill_session comment '秒杀活动场次';
    760.  
    761. /*==============================================================*/
    762. /* Table: sms_seckill_sku_notice                                */
    763. /*==============================================================*/
    764. create table sms_seckill_sku_notice
    765. (
    766.     id                   bigint not null auto_increment comment 'id',
    767.     member_id            bigint comment 'member_id',
    768.     sku_id               bigint comment 'sku_id',
    769.     session_id           bigint comment '活动场次id',
    770.     subcribe_time        datetime comment '订阅时间',
    771.     send_time            datetime comment '发送时间',
    772.     notice_type          tinyint(1) comment '通知方式[0-短信，1-邮件]',
    773.     primary key (id)
    774. );
    775.  
    776. alter table sms_seckill_sku_notice comment '秒杀商品通知订阅';
    777.  
    778. /*==============================================================*/
    779. /* Table: sms_seckill_sku_relation                              */
    780. /*==============================================================*/
    781. create table sms_seckill_sku_relation
    782. (
    783.     id                   bigint not null auto_increment comment 'id',
    784.     promotion_id         bigint comment '活动id',
    785.     promotion_session_id bigint comment '活动场次id',
    786.     sku_id               bigint comment '商品id',
    787.     seckill_price        decimal comment '秒杀价格',
    788.     seckill_count        decimal comment '秒杀总量',
    789.     seckill_limit        decimal comment '每人限购数量',
    790.     seckill_sort         int comment '排序',
    791.     primary key (id)
    792. );
    793.  
    794. alter table sms_seckill_sku_relation comment '秒杀活动商品关联';
    795.  
    796. /*==============================================================*/
    797. /* Table: sms_sku_full_reduction                                */
    798. /*==============================================================*/
    799. create table sms_sku_full_reduction
    800. (
    801.     id                   bigint not null auto_increment comment 'id',
    802.     sku_id               bigint comment 'spu_id',
    803.     full_price           decimal(18,4) comment '满多少',
    804.     reduce_price         decimal(18,4) comment '减多少',
    805.     add_other            tinyint(1) comment '是否参与其他优惠',
    806.     primary key (id)
    807. );
    808.  
    809. alter table sms_sku_full_reduction comment '商品满减信息';
    810.  
    811. /*==============================================================*/
    812. /* Table: sms_sku_ladder                                        */
    813. /*==============================================================*/
    814. create table sms_sku_ladder
    815. (
    816.     id                   bigint not null auto_increment comment 'id',
    817.     sku_id               bigint comment 'spu_id',
    818.     full_count           int comment '满几件',
    819.     discount             decimal(4,2) comment '打几折',
    820.     price                decimal(18,4) comment '折后价',
    821.     add_other            tinyint(1) comment '是否叠加其他优惠[0-不可叠加，1-可叠加]',
    822.     primary key (id)
    823. );
    824.  
    825. alter table sms_sku_ladder comment '商品阶梯价格';
    826.  
    827. /*==============================================================*/
    828. /* Table: sms_spu_bounds                                        */
    829. /*==============================================================*/
    830. create table sms_spu_bounds
    831. (
    832.     id                   bigint not null auto_increment comment 'id',
    833.     spu_id               bigint,
    834.     grow_bounds          decimal(18,4) comment '成长积分',
    835.     buy_bounds           decimal(18,4) comment '购物积分',
    836.     work                 tinyint(1) comment '优惠生效情况[1111(四个状态位，从右到左);0 - 无优惠，成长积分是否赠送;1 - 无优惠，购物积分是否赠送;2 - 有优惠，成长积分是否赠送;3 - 有优惠，购物积分是否赠送【状态位0：不赠送，1：赠送】]',
    837.     primary key (id)
    838. );
    839.  
    840. alter table sms_spu_bounds comment '商品spu积分设置';
    841.  
    842. /*==============================================================*/
    843. # database：gulimall_ums
    844. /*==============================================================*/
    845. CREATE DATABASE `gulimall_ums` DEFAULT CHARACTER SET utf8mb4;
    846. USE `gulimall_ums`;
    847.  
    848. drop table if exists ums_growth_change_history;
    849.  
    850. drop table if exists ums_integration_change_history;
    851.  
    852. drop table if exists ums_member;
    853.  
    854. drop table if exists ums_member_collect_spu;
    855.  
    856. drop table if exists ums_member_collect_subject;
    857.  
    858. drop table if exists ums_member_level;
    859.  
    860. drop table if exists ums_member_login_log;
    861.  
    862. drop table if exists ums_member_receive_address;
    863.  
    864. drop table if exists ums_member_statistics_info;
    865.  
    866. /*==============================================================*/
    867. /* Table: ums_growth_change_history                             */
    868. /*==============================================================*/
    869. create table ums_growth_change_history
    870. (
    871.     id                   bigint not null auto_increment comment 'id',
    872.     member_id            bigint comment 'member_id',
    873.     create_time          datetime comment 'create_time',
    874.     change_count         int comment '改变的值(正负计数)',
    875.     note                 varchar(0) comment '备注',
    876.     source_type          tinyint comment '积分来源[0-购物，1-管理员修改]',
    877.     primary key (id)
    878. );
    879.  
    880. alter table ums_growth_change_history comment '成长值变化历史记录';
    881.  
    882. /*==============================================================*/
    883. /* Table: ums_integration_change_history                        */
    884. /*==============================================================*/
    885. create table ums_integration_change_history
    886. (
    887.     id                   bigint not null auto_increment comment 'id',
    888.     member_id            bigint comment 'member_id',
    889.     create_time          datetime comment 'create_time',
    890.     change_count         int comment '变化的值',
    891.     note                 varchar(255) comment '备注',
    892.     source_tyoe          tinyint comment '来源[0->购物；1->管理员修改;2->活动]',
    893.     primary key (id)
    894. );
    895.  
    896. alter table ums_integration_change_history comment '积分变化历史记录';
    897.  
    898. /*==============================================================*/
    899. /* Table: ums_member                                            */
    900. /*==============================================================*/
    901. create table ums_member
    902. (
    903.     id                   bigint not null auto_increment comment 'id',
    904.     level_id             bigint comment '会员等级id',
    905.     username             char(64) comment '用户名',
    906.     password             varchar(64) comment '密码',
    907.     nickname             varchar(64) comment '昵称',
    908.     mobile               varchar(20) comment '手机号码',
    909.     email                varchar(64) comment '邮箱',
    910.     header               varchar(500) comment '头像',
    911.     gender               tinyint comment '性别',
    912.     birth                date comment '生日',
    913.     city                 varchar(500) comment '所在城市',
    914.     job                  varchar(255) comment '职业',
    915.     sign                 varchar(255) comment '个性签名',
    916.     source_type          tinyint comment '用户来源',
    917.     integration          int comment '积分',
    918.     growth               int comment '成长值',
    919.     status               tinyint comment '启用状态',
    920.     create_time          datetime comment '注册时间',
    921.     primary key (id)
    922. );
    923.  
    924. alter table ums_member comment '会员';
    925.  
    926. /*==============================================================*/
    927. /* Table: ums_member_collect_spu                                */
    928. /*==============================================================*/
    929. create table ums_member_collect_spu
    930. (
    931.     id                   bigint not null comment 'id',
    932.     member_id            bigint comment '会员id',
    933.     spu_id               bigint comment 'spu_id',
    934.     spu_name             varchar(500) comment 'spu_name',
    935.     spu_img              varchar(500) comment 'spu_img',
    936.     create_time          datetime comment 'create_time',
    937.     primary key (id)
    938. );
    939.  
    940. alter table ums_member_collect_spu comment '会员收藏的商品';
    941.  
    942. /*==============================================================*/
    943. /* Table: ums_member_collect_subject                            */
    944. /*==============================================================*/
    945. create table ums_member_collect_subject
    946. (
    947.     id                   bigint not null auto_increment comment 'id',
    948.     subject_id           bigint comment 'subject_id',
    949.     subject_name         varchar(255) comment 'subject_name',
    950.     subject_img          varchar(500) comment 'subject_img',
    951.     subject_urll         varchar(500) comment '活动url',
    952.     primary key (id)
    953. );
    954.  
    955. alter table ums_member_collect_subject comment '会员收藏的专题活动';
    956.  
    957. /*==============================================================*/
    958. /* Table: ums_member_level                                      */
    959. /*==============================================================*/
    960. create table ums_member_level
    961. (
    962.     id                   bigint not null auto_increment comment 'id',
    963.     name                 varchar(100) comment '等级名称',
    964.     growth_point         int comment '等级需要的成长值',
    965.     default_status       tinyint comment '是否为默认等级[0->不是；1->是]',
    966.     free_freight_point   decimal(18,4) comment '免运费标准',
    967.     comment_growth_point int comment '每次评价获取的成长值',
    968.     priviledge_free_freight tinyint comment '是否有免邮特权',
    969.     priviledge_member_price tinyint comment '是否有会员价格特权',
    970.     priviledge_birthday  tinyint comment '是否有生日特权',
    971.     note                 varchar(255) comment '备注',
    972.     primary key (id)
    973. );
    974.  
    975. alter table ums_member_level comment '会员等级';
    976.  
    977. /*==============================================================*/
    978. /* Table: ums_member_login_log                                  */
    979. /*==============================================================*/
    980. create table ums_member_login_log
    981. (
    982.     id                   bigint not null auto_increment comment 'id',
    983.     member_id            bigint comment 'member_id',
    984.     create_time          datetime comment '创建时间',
    985.     ip                   varchar(64) comment 'ip',
    986.     city                 varchar(64) comment 'city',
    987.     login_type           tinyint(1) comment '登录类型[1-web，2-app]',
    988.     primary key (id)
    989. );
    990.  
    991. alter table ums_member_login_log comment '会员登录记录';
    992.  
    993. /*==============================================================*/
    994. /* Table: ums_member_receive_address                            */
    995. /*==============================================================*/
    996. create table ums_member_receive_address
    997. (
    998.     id                   bigint not null auto_increment comment 'id',
    999.     member_id            bigint comment 'member_id',
    1000.     name                 varchar(255) comment '收货人姓名',
    1001.     phone                varchar(64) comment '电话',
    1002.     post_code            varchar(64) comment '邮政编码',
    1003.     province             varchar(100) comment '省份/直辖市',
    1004.     city                 varchar(100) comment '城市',
    1005.     region               varchar(100) comment '区',
    1006.     detail_address       varchar(255) comment '详细地址(街道)',
    1007.     areacode             varchar(15) comment '省市区代码',
    1008.     default_status       tinyint(1) comment '是否默认',
    1009.     primary key (id)
    1010. );
    1011.  
    1012. alter table ums_member_receive_address comment '会员收货地址';
    1013.  
    1014. /*==============================================================*/
    1015. /* Table: ums_member_statistics_info                            */
    1016. /*==============================================================*/
    1017. create table ums_member_statistics_info
    1018. (
    1019.     id                   bigint not null auto_increment comment 'id',
    1020.     member_id            bigint comment '会员id',
    1021.     consume_amount       decimal(18,4) comment '累计消费金额',
    1022.     coupon_amount        decimal(18,4) comment '累计优惠金额',
    1023.     order_count          int comment '订单数量',
    1024.     coupon_count         int comment '优惠券数量',
    1025.     comment_count        int comment '评价数',
    1026.     return_order_count   int comment '退货数量',
    1027.     login_count          int comment '登录次数',
    1028.     attend_count         int comment '关注数量',
    1029.     fans_count           int comment '粉丝数量',
    1030.     collect_product_count int comment '收藏的商品数量',
    1031.     collect_subject_count int comment '收藏的专题活动数量',
    1032.     collect_comment_count int comment '收藏的评论数量',
    1033.     invite_friend_count  int comment '邀请的朋友数量',
    1034.     primary key (id)
    1035. );
    1036.  
    1037. alter table ums_member_statistics_info comment '会员统计信息';
    1038.  
    1039. /*==============================================================*/
    1040. # database：gulimall_wms
    1041. /*==============================================================*/
    1042. CREATE DATABASE `gulimall_wms` DEFAULT CHARACTER SET utf8mb4;
    1043. USE `gulimall_wms`;
    1044.  
    1045. /*Table structure for table `undo_log` */
    1046.  
    1047. DROP TABLE IF EXISTS `undo_log`;
    1048.  
    1049. CREATE TABLE `undo_log` (
    1050.                             `id` bigint(20) NOT NULL AUTO_INCREMENT,
    1051.                             `branch_id` bigint(20) NOT NULL,
    1052.                             `xid` varchar(100) NOT NULL,
    1053.                             `context` varchar(128) NOT NULL,
    1054.                             `rollback_info` longtext NOT NULL,
    1055.                             `log_status` int(11) NOT NULL,
    1056.                             `log_created` datetime NOT NULL,
    1057.                             `log_modified` datetime NOT NULL,
    1058.                             `ext` varchar(100) DEFAULT NULL,
    1059.                             PRIMARY KEY (`id`),
    1060.                             UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`) USING BTREE
    1061. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    1062.  
    1063. /*Data for the table `undo_log` */
    1064.  
    1065. /*Table structure for table `wms_purchase` */
    1066.  
    1067. DROP TABLE IF EXISTS `wms_purchase`;
    1068.  
    1069. CREATE TABLE `wms_purchase` (
    1070.                                 `id` bigint(20) NOT NULL AUTO_INCREMENT,
    1071.                                 `assignee_id` bigint(20) DEFAULT NULL,
    1072.                                 `assignee_name` varchar(255) DEFAULT NULL,
    1073.                                 `phone` char(13) DEFAULT NULL,
    1074.                                 `priority` int(4) DEFAULT NULL,
    1075.                                 `status` int(4) DEFAULT NULL,
    1076.                                 `ware_id` bigint(20) DEFAULT NULL,
    1077.                                 `amount` decimal(18,4) DEFAULT NULL,
    1078.                                 `create_time` datetime DEFAULT NULL,
    1079.                                 `update_time` datetime DEFAULT NULL,
    1080.                                 PRIMARY KEY (`id`)
    1081. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='采购信息';
    1082.  
    1083. /*Data for the table `wms_purchase` */
    1084.  
    1085. /*Table structure for table `wms_purchase_detail` */
    1086.  
    1087. DROP TABLE IF EXISTS `wms_purchase_detail`;
    1088.  
    1089. CREATE TABLE `wms_purchase_detail` (
    1090.                                        `id` bigint(20) NOT NULL AUTO_INCREMENT,
    1091.                                        `purchase_id` bigint(20) DEFAULT NULL COMMENT '采购单id',
    1092.                                        `sku_id` bigint(20) DEFAULT NULL COMMENT '采购商品id',
    1093.                                        `sku_num` int(11) DEFAULT NULL COMMENT '采购数量',
    1094.                                        `sku_price` decimal(18,4) DEFAULT NULL COMMENT '采购金额',
    1095.                                        `ware_id` bigint(20) DEFAULT NULL COMMENT '仓库id',
    1096.                                        `status` int(11) DEFAULT NULL COMMENT '状态[0新建，1已分配，2正在采购，3已完成，4采购失败]',
    1097.                                        PRIMARY KEY (`id`)
    1098. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    1099.  
    1100. /*Data for the table `wms_purchase_detail` */
    1101.  
    1102. /*Table structure for table `wms_ware_info` */
    1103.  
    1104. DROP TABLE IF EXISTS `wms_ware_info`;
    1105.  
    1106. CREATE TABLE `wms_ware_info` (
    1107.                                  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    1108.                                  `name` varchar(255) DEFAULT NULL COMMENT '仓库名',
    1109.                                  `address` varchar(255) DEFAULT NULL COMMENT '仓库地址',
    1110.                                  `areacode` varchar(20) DEFAULT NULL COMMENT '区域编码',
    1111.                                  PRIMARY KEY (`id`)
    1112. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='仓库信息';
    1113.  
    1114. /*Data for the table `wms_ware_info` */
    1115.  
    1116. /*Table structure for table `wms_ware_order_task` */
    1117.  
    1118. DROP TABLE IF EXISTS `wms_ware_order_task`;
    1119.  
    1120. CREATE TABLE `wms_ware_order_task` (
    1121.                                        `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    1122.                                        `order_id` bigint(20) DEFAULT NULL COMMENT 'order_id',
    1123.                                        `order_sn` varchar(255) DEFAULT NULL COMMENT 'order_sn',
    1124.                                        `consignee` varchar(100) DEFAULT NULL COMMENT '收货人',
    1125.                                        `consignee_tel` char(15) DEFAULT NULL COMMENT '收货人电话',
    1126.                                        `delivery_address` varchar(500) DEFAULT NULL COMMENT '配送地址',
    1127.                                        `order_comment` varchar(200) DEFAULT NULL COMMENT '订单备注',
    1128.                                        `payment_way` tinyint(1) DEFAULT NULL COMMENT '付款方式【 1:在线付款 2:货到付款】',
    1129.                                        `task_status` tinyint(2) DEFAULT NULL COMMENT '任务状态',
    1130.                                        `order_body` varchar(255) DEFAULT NULL COMMENT '订单描述',
    1131.                                        `tracking_no` char(30) DEFAULT NULL COMMENT '物流单号',
    1132.                                        `create_time` datetime DEFAULT NULL COMMENT 'create_time',
    1133.                                        `ware_id` bigint(20) DEFAULT NULL COMMENT '仓库id',
    1134.                                        `task_comment` varchar(500) DEFAULT NULL COMMENT '工作单备注',
    1135.                                        PRIMARY KEY (`id`)
    1136. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='库存工作单';
    1137.  
    1138. /*Data for the table `wms_ware_order_task` */
    1139.  
    1140. /*Table structure for table `wms_ware_order_task_detail` */
    1141.  
    1142. DROP TABLE IF EXISTS `wms_ware_order_task_detail`;
    1143.  
    1144. CREATE TABLE `wms_ware_order_task_detail` (
    1145.                                               `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    1146.                                               `sku_id` bigint(20) DEFAULT NULL COMMENT 'sku_id',
    1147.                                               `sku_name` varchar(255) DEFAULT NULL COMMENT 'sku_name',
    1148.                                               `sku_num` int(11) DEFAULT NULL COMMENT '购买个数',
    1149.                                               `task_id` bigint(20) DEFAULT NULL COMMENT '工作单id',
    1150.                                               `ware_id` bigint(20) DEFAULT NULL COMMENT '仓库id',
    1151.                                               `lock_status` int(1) DEFAULT NULL COMMENT '1-已锁定  2-已解锁  3-扣减',
    1152.                                               PRIMARY KEY (`id`)
    1153. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='库存工作单';
    1154.  
    1155. /*Data for the table `wms_ware_order_task_detail` */
    1156.  
    1157. /*Table structure for table `wms_ware_sku` */
    1158.  
    1159. DROP TABLE IF EXISTS `wms_ware_sku`;
    1160.  
    1161. CREATE TABLE `wms_ware_sku` (
    1162.                                 `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    1163.                                 `sku_id` bigint(20) DEFAULT NULL COMMENT 'sku_id',
    1164.                                 `ware_id` bigint(20) DEFAULT NULL COMMENT '仓库id',
    1165.                                 `stock` int(11) DEFAULT NULL COMMENT '库存数',
    1166.                                 `sku_name` varchar(200) DEFAULT NULL COMMENT 'sku_name',
    1167.                                 `stock_locked` int(11) DEFAULT '0' COMMENT '锁定库存',
    1168.                                 PRIMARY KEY (`id`),
    1169.                                 KEY `sku_id` (`sku_id`) USING BTREE,
    1170.                                 KEY `ware_id` (`ware_id`) USING BTREE
    1171. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商品库存';
    1172.  
    1173.  
    1174. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    1175. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    1176. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    1177. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    1178. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    1179. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    1180. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    View Code

    执行结果：

     三、快速开发-人人开源逆向工程之 admin 项目

    人人开源码云：https://gitee.com/renrenio

     1、克隆 renren-fast 及 renren-fast-vue

    1.  git clone https://gitee.com/renrenio/renren-fast.git
    2.  git clone https://gitee.com/renrenio/renren-fast-vue.git

    2、renren-fast 初始化

    1)数据库直接拖进mysql连接工具执行即可

    1. /*==============================================================*/
    2. # database：gulimall_admin
    3. /*==============================================================*/
    4. CREATE DATABASE `gulimall_admin` DEFAULT CHARACTER SET utf8mb4;
    5. USE `gulimall_admin`;
    6.  
    7. -- 菜单
    8. CREATE TABLE `sys_menu` (
    9.   `menu_id` bigint NOT NULL AUTO_INCREMENT,
    10.   `parent_id` bigint COMMENT '父菜单ID，一级菜单为0',
    11.   `name` varchar(50) COMMENT '菜单名称',
    12.   `url` varchar(200) COMMENT '菜单URL',
    13.   `perms` varchar(500) COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
    14.   `type` int COMMENT '类型   0：目录   1：菜单   2：按钮',
    15.   `icon` varchar(50) COMMENT '菜单图标',
    16.   `order_num` int COMMENT '排序',
    17.   PRIMARY KEY (`menu_id`)
    18. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='菜单管理';
    19.  
    20. -- 系统用户
    21. CREATE TABLE `sys_user` (
    22.   `user_id` bigint NOT NULL AUTO_INCREMENT,
    23.   `username` varchar(50) NOT NULL COMMENT '用户名',
    24.   `password` varchar(100) COMMENT '密码',
    25.   `salt` varchar(20) COMMENT '盐',
    26.   `email` varchar(100) COMMENT '邮箱',
    27.   `mobile` varchar(100) COMMENT '手机号',
    28.   `status` tinyint COMMENT '状态  0：禁用   1：正常',
    29.   `create_user_id` bigint(20) COMMENT '创建者ID',
    30.   `create_time` datetime COMMENT '创建时间',
    31.   PRIMARY KEY (`user_id`),
    32.   UNIQUE INDEX (`username`)
    33. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='系统用户';
    34.  
    35. -- 系统用户Token
    36. CREATE TABLE `sys_user_token` (
    37.   `user_id` bigint(20) NOT NULL,
    38.   `token` varchar(100) NOT NULL COMMENT 'token',
    39.   `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
    40.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    41.   PRIMARY KEY (`user_id`),
    42.   UNIQUE KEY `token` (`token`)
    43. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='系统用户Token';
    44.  
    45. -- 系统验证码
    46. CREATE TABLE `sys_captcha` (
    47.   `uuid` char(36) NOT NULL COMMENT 'uuid',
    48.   `code` varchar(6) NOT NULL COMMENT '验证码',
    49.   `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
    50.   PRIMARY KEY (`uuid`)
    51. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='系统验证码';
    52.  
    53. -- 角色
    54. CREATE TABLE `sys_role` (
    55.   `role_id` bigint NOT NULL AUTO_INCREMENT,
    56.   `role_name` varchar(100) COMMENT '角色名称',
    57.   `remark` varchar(100) COMMENT '备注',
    58.   `create_user_id` bigint(20) COMMENT '创建者ID',
    59.   `create_time` datetime COMMENT '创建时间',
    60.   PRIMARY KEY (`role_id`)
    61. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='角色';
    62.  
    63. -- 用户与角色对应关系
    64. CREATE TABLE `sys_user_role` (
    65.   `id` bigint NOT NULL AUTO_INCREMENT,
    66.   `user_id` bigint COMMENT '用户ID',
    67.   `role_id` bigint COMMENT '角色ID',
    68.   PRIMARY KEY (`id`)
    69. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='用户与角色对应关系';
    70.  
    71. -- 角色与菜单对应关系
    72. CREATE TABLE `sys_role_menu` (
    73.   `id` bigint NOT NULL AUTO_INCREMENT,
    74.   `role_id` bigint COMMENT '角色ID',
    75.   `menu_id` bigint COMMENT '菜单ID',
    76.   PRIMARY KEY (`id`)
    77. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='角色与菜单对应关系';
    78.  
    79. -- 系统配置信息
    80. CREATE TABLE `sys_config` (
    81.     `id` bigint NOT NULL AUTO_INCREMENT,
    82.     `param_key` varchar(50) COMMENT 'key',
    83.     `param_value` varchar(2000) COMMENT 'value',
    84.     `status` tinyint DEFAULT 1 COMMENT '状态   0：隐藏   1：显示',
    85.     `remark` varchar(500) COMMENT '备注',
    86.     PRIMARY KEY (`id`),
    87.     UNIQUE INDEX (`param_key`)
    88. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='系统配置信息表';
    89.  
    90.  
    91. -- 系统日志
    92. CREATE TABLE `sys_log` (
    93.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    94.   `username` varchar(50) COMMENT '用户名',
    95.   `operation` varchar(50) COMMENT '用户操作',
    96.   `method` varchar(200) COMMENT '请求方法',
    97.   `params` varchar(5000) COMMENT '请求参数',
    98.   `time` bigint NOT NULL COMMENT '执行时长(毫秒)',
    99.   `ip` varchar(64) COMMENT 'IP地址',
    100.   `create_date` datetime COMMENT '创建时间',
    101.   PRIMARY KEY (`id`)
    102. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='系统日志';
    103.  
    104.  
    105. -- 文件上传
    106. CREATE TABLE `sys_oss` (
    107.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    108.   `url` varchar(200) COMMENT 'URL地址',
    109.   `create_date` datetime COMMENT '创建时间',
    110.   PRIMARY KEY (`id`)
    111. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='文件上传';
    112.  
    113.  
    114. -- 定时任务
    115. CREATE TABLE `schedule_job` (
    116.   `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务id',
    117.   `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
    118.   `params` varchar(2000) DEFAULT NULL COMMENT '参数',
    119.   `cron_expression` varchar(100) DEFAULT NULL COMMENT 'cron表达式',
    120.   `status` tinyint(4) DEFAULT NULL COMMENT '任务状态  0：正常  1：暂停',
    121.   `remark` varchar(255) DEFAULT NULL COMMENT '备注',
    122.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    123.   PRIMARY KEY (`job_id`)
    124. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='定时任务';
    125.  
    126. -- 定时任务日志
    127. CREATE TABLE `schedule_job_log` (
    128.   `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
    129.   `job_id` bigint(20) NOT NULL COMMENT '任务id',
    130.   `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
    131.   `params` varchar(2000) DEFAULT NULL COMMENT '参数',
    132.   `status` tinyint(4) NOT NULL COMMENT '任务状态    0：成功    1：失败',
    133.   `error` varchar(2000) DEFAULT NULL COMMENT '失败信息',
    134.   `times` int(11) NOT NULL COMMENT '耗时(单位：毫秒)',
    135.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    136.   PRIMARY KEY (`log_id`),
    137.   KEY `job_id` (`job_id`)
    138. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='定时任务日志';
    139.  
    140.  
    141.  
    142. -- 用户表
    143. CREATE TABLE `tb_user` (
    144.   `user_id` bigint NOT NULL AUTO_INCREMENT,
    145.   `username` varchar(50) NOT NULL COMMENT '用户名',
    146.   `mobile` varchar(20) NOT NULL COMMENT '手机号',
    147.   `password` varchar(64) COMMENT '密码',
    148.   `create_time` datetime COMMENT '创建时间',
    149.   PRIMARY KEY (`user_id`),
    150.   UNIQUE INDEX (`username`)
    151. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='用户';
    152.  
    153.  
    154.  
    155.  
    156.  
    157.  
    158. -- 初始数据 
    159. INSERT INTO `sys_user` (`user_id`, `username`, `password`, `salt`, `email`, `mobile`, `status`, `create_user_id`, `create_time`) VALUES ('1', 'admin', '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d', 'YzcmCZNvbXocrsz9dm8e', 'root@renren.io', '13612345678', '1', '1', '2016-11-11 11:11:11');
    160.  
    161. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (1, 0, '系统管理', NULL, NULL, 0, 'system', 0);
    162. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (2, 1, '管理员列表', 'sys/user', NULL, 1, 'admin', 1);
    163. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (3, 1, '角色管理', 'sys/role', NULL, 1, 'role', 2);
    164. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (4, 1, '菜单管理', 'sys/menu', NULL, 1, 'menu', 3);
    165. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (5, 1, 'SQL监控', 'http://localhost:8080/renren-fast/druid/sql.html', NULL, 1, 'sql', 4);
    166. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (6, 1, '定时任务', 'job/schedule', NULL, 1, 'job', 5);
    167. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (7, 6, '查看', NULL, 'sys:schedule:list,sys:schedule:info', 2, NULL, 0);
    168. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (8, 6, '新增', NULL, 'sys:schedule:save', 2, NULL, 0);
    169. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (9, 6, '修改', NULL, 'sys:schedule:update', 2, NULL, 0);
    170. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (10, 6, '删除', NULL, 'sys:schedule:delete', 2, NULL, 0);
    171. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (11, 6, '暂停', NULL, 'sys:schedule:pause', 2, NULL, 0);
    172. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (12, 6, '恢复', NULL, 'sys:schedule:resume', 2, NULL, 0);
    173. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (13, 6, '立即执行', NULL, 'sys:schedule:run', 2, NULL, 0);
    174. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (14, 6, '日志列表', NULL, 'sys:schedule:log', 2, NULL, 0);
    175. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (15, 2, '查看', NULL, 'sys:user:list,sys:user:info', 2, NULL, 0);
    176. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (16, 2, '新增', NULL, 'sys:user:save,sys:role:select', 2, NULL, 0);
    177. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (17, 2, '修改', NULL, 'sys:user:update,sys:role:select', 2, NULL, 0);
    178. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (18, 2, '删除', NULL, 'sys:user:delete', 2, NULL, 0);
    179. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (19, 3, '查看', NULL, 'sys:role:list,sys:role:info', 2, NULL, 0);
    180. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (20, 3, '新增', NULL, 'sys:role:save,sys:menu:list', 2, NULL, 0);
    181. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (21, 3, '修改', NULL, 'sys:role:update,sys:menu:list', 2, NULL, 0);
    182. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (22, 3, '删除', NULL, 'sys:role:delete', 2, NULL, 0);
    183. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (23, 4, '查看', NULL, 'sys:menu:list,sys:menu:info', 2, NULL, 0);
    184. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (24, 4, '新增', NULL, 'sys:menu:save,sys:menu:select', 2, NULL, 0);
    185. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (25, 4, '修改', NULL, 'sys:menu:update,sys:menu:select', 2, NULL, 0);
    186. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (26, 4, '删除', NULL, 'sys:menu:delete', 2, NULL, 0);
    187. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (27, 1, '参数管理', 'sys/config', 'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', 1, 'config', 6);
    188. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (29, 1, '系统日志', 'sys/log', 'sys:log:list', 1, 'log', 7);
    189. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (30, 1, '文件上传', 'oss/oss', 'sys:oss:all', 1, 'oss', 6);
    190.  
    191. INSERT INTO `sys_config` (`param_key`, `param_value`, `status`, `remark`) VALUES ('CLOUD_STORAGE_CONFIG_KEY', '{\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"aliyunDomain\":\"\",\"aliyunEndPoint\":\"\",\"aliyunPrefix\":\"\",\"qcloudBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuBucketName\":\"ios-app\",\"qiniuDomain\":\"http://7xqbwh.dl1.z0.glb.clouddn.com\",\"qiniuPrefix\":\"upload\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"type\":1}', '0', '云存储配置信息');
    192. INSERT INTO `schedule_job` (`bean_name`, `params`, `cron_expression`, `status`, `remark`, `create_time`) VALUES ('testTask', 'renren', '0 0/30 * * * ?', '0', '参数测试', now());
    193.  
    194.  
    195. -- 账号：13612345678  密码：admin
    196. INSERT INTO `tb_user` (`username`, `mobile`, `password`, `create_time`) VALUES ('mark', '13612345678', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '2017-03-23 22:37:41');
    197.  
    198.  
    199.  
    200.  
    201.  
    202.  
    203.  
    204.  
    205. --  quartz自带表结构
    206. CREATE TABLE QRTZ_JOB_DETAILS(
    207. SCHED_NAME VARCHAR(120) NOT NULL,
    208. JOB_NAME VARCHAR(200) NOT NULL,
    209. JOB_GROUP VARCHAR(200) NOT NULL,
    210. DESCRIPTION VARCHAR(250) NULL,
    211. JOB_CLASS_NAME VARCHAR(250) NOT NULL,
    212. IS_DURABLE VARCHAR(1) NOT NULL,
    213. IS_NONCONCURRENT VARCHAR(1) NOT NULL,
    214. IS_UPDATE_DATA VARCHAR(1) NOT NULL,
    215. REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
    216. JOB_DATA BLOB NULL,
    217. PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP))
    218. ENGINE=InnoDB DEFAULT CHARSET=utf8;
    219.  
    220. CREATE TABLE QRTZ_TRIGGERS (
    221. SCHED_NAME VARCHAR(120) NOT NULL,
    222. TRIGGER_NAME VARCHAR(200) NOT NULL,
    223. TRIGGER_GROUP VARCHAR(200) NOT NULL,
    224. JOB_NAME VARCHAR(200) NOT NULL,
    225. JOB_GROUP VARCHAR(200) NOT NULL,
    226. DESCRIPTION VARCHAR(250) NULL,
    227. NEXT_FIRE_TIME BIGINT(13) NULL,
    228. PREV_FIRE_TIME BIGINT(13) NULL,
    229. PRIORITY INTEGER NULL,
    230. TRIGGER_STATE VARCHAR(16) NOT NULL,
    231. TRIGGER_TYPE VARCHAR(8) NOT NULL,
    232. START_TIME BIGINT(13) NOT NULL,
    233. END_TIME BIGINT(13) NULL,
    234. CALENDAR_NAME VARCHAR(200) NULL,
    235. MISFIRE_INSTR SMALLINT(2) NULL,
    236. JOB_DATA BLOB NULL,
    237. PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
    238. FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)
    239. REFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP))
    240. ENGINE=InnoDB DEFAULT CHARSET=utf8;
    241.  
    242. CREATE TABLE QRTZ_SIMPLE_TRIGGERS (
    243. SCHED_NAME VARCHAR(120) NOT NULL,
    244. TRIGGER_NAME VARCHAR(200) NOT NULL,
    245. TRIGGER_GROUP VARCHAR(200) NOT NULL,
    246. REPEAT_COUNT BIGINT(7) NOT NULL,
    247. REPEAT_INTERVAL BIGINT(12) NOT NULL,
    248. TIMES_TRIGGERED BIGINT(10) NOT NULL,
    249. PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
    250. FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
    251. REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))
    252. ENGINE=InnoDB DEFAULT CHARSET=utf8;
    253.  
    254. CREATE TABLE QRTZ_CRON_TRIGGERS (
    255. SCHED_NAME VARCHAR(120) NOT NULL,
    256. TRIGGER_NAME VARCHAR(200) NOT NULL,
    257. TRIGGER_GROUP VARCHAR(200) NOT NULL,
    258. CRON_EXPRESSION VARCHAR(120) NOT NULL,
    259. TIME_ZONE_ID VARCHAR(80),
    260. PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
    261. FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
    262. REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))
    263. ENGINE=InnoDB DEFAULT CHARSET=utf8;
    264.  
    265. CREATE TABLE QRTZ_SIMPROP_TRIGGERS
    266.   (          
    267.     SCHED_NAME VARCHAR(120) NOT NULL,
    268.     TRIGGER_NAME VARCHAR(200) NOT NULL,
    269.     TRIGGER_GROUP VARCHAR(200) NOT NULL,
    270.     STR_PROP_1 VARCHAR(512) NULL,
    271.     STR_PROP_2 VARCHAR(512) NULL,
    272.     STR_PROP_3 VARCHAR(512) NULL,
    273.     INT_PROP_1 INT NULL,
    274.     INT_PROP_2 INT NULL,
    275.     LONG_PROP_1 BIGINT NULL,
    276.     LONG_PROP_2 BIGINT NULL,
    277.     DEC_PROP_1 NUMERIC(13,4) NULL,
    278.     DEC_PROP_2 NUMERIC(13,4) NULL,
    279.     BOOL_PROP_1 VARCHAR(1) NULL,
    280.     BOOL_PROP_2 VARCHAR(1) NULL,
    281.     PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
    282.     FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) 
    283.     REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))
    284. ENGINE=InnoDB DEFAULT CHARSET=utf8;
    285.  
    286. CREATE TABLE QRTZ_BLOB_TRIGGERS (
    287. SCHED_NAME VARCHAR(120) NOT NULL,
    288. TRIGGER_NAME VARCHAR(200) NOT NULL,
    289. TRIGGER_GROUP VARCHAR(200) NOT NULL,
    290. BLOB_DATA BLOB NULL,
    291. PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
    292. INDEX (SCHED_NAME,TRIGGER_NAME, TRIGGER_GROUP),
    293. FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
    294. REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))
    295. ENGINE=InnoDB DEFAULT CHARSET=utf8;
    296.  
    297. CREATE TABLE QRTZ_CALENDARS (
    298. SCHED_NAME VARCHAR(120) NOT NULL,
    299. CALENDAR_NAME VARCHAR(200) NOT NULL,
    300. CALENDAR BLOB NOT NULL,
    301. PRIMARY KEY (SCHED_NAME,CALENDAR_NAME))
    302. ENGINE=InnoDB DEFAULT CHARSET=utf8;
    303.  
    304. CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS (
    305. SCHED_NAME VARCHAR(120) NOT NULL,
    306. TRIGGER_GROUP VARCHAR(200) NOT NULL,
    307. PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP))
    308. ENGINE=InnoDB DEFAULT CHARSET=utf8;
    309.  
    310. CREATE TABLE QRTZ_FIRED_TRIGGERS (
    311. SCHED_NAME VARCHAR(120) NOT NULL,
    312. ENTRY_ID VARCHAR(95) NOT NULL,
    313. TRIGGER_NAME VARCHAR(200) NOT NULL,
    314. TRIGGER_GROUP VARCHAR(200) NOT NULL,
    315. INSTANCE_NAME VARCHAR(200) NOT NULL,
    316. FIRED_TIME BIGINT(13) NOT NULL,
    317. SCHED_TIME BIGINT(13) NOT NULL,
    318. PRIORITY INTEGER NOT NULL,
    319. STATE VARCHAR(16) NOT NULL,
    320. JOB_NAME VARCHAR(200) NULL,
    321. JOB_GROUP VARCHAR(200) NULL,
    322. IS_NONCONCURRENT VARCHAR(1) NULL,
    323. REQUESTS_RECOVERY VARCHAR(1) NULL,
    324. PRIMARY KEY (SCHED_NAME,ENTRY_ID))
    325. ENGINE=InnoDB DEFAULT CHARSET=utf8;
    326.  
    327. CREATE TABLE QRTZ_SCHEDULER_STATE (
    328. SCHED_NAME VARCHAR(120) NOT NULL,
    329. INSTANCE_NAME VARCHAR(200) NOT NULL,
    330. LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
    331. CHECKIN_INTERVAL BIGINT(13) NOT NULL,
    332. PRIMARY KEY (SCHED_NAME,INSTANCE_NAME))
    333. ENGINE=InnoDB DEFAULT CHARSET=utf8;
    334.  
    335. CREATE TABLE QRTZ_LOCKS (
    336. SCHED_NAME VARCHAR(120) NOT NULL,
    337. LOCK_NAME VARCHAR(40) NOT NULL,
    338. PRIMARY KEY (SCHED_NAME,LOCK_NAME))
    339. ENGINE=InnoDB DEFAULT CHARSET=utf8;
    340.  
    341. CREATE INDEX IDX_QRTZ_J_REQ_RECOVERY ON QRTZ_JOB_DETAILS(SCHED_NAME,REQUESTS_RECOVERY);
    342. CREATE INDEX IDX_QRTZ_J_GRP ON QRTZ_JOB_DETAILS(SCHED_NAME,JOB_GROUP);
    343.  
    344. CREATE INDEX IDX_QRTZ_T_J ON QRTZ_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);
    345. CREATE INDEX IDX_QRTZ_T_JG ON QRTZ_TRIGGERS(SCHED_NAME,JOB_GROUP);
    346. CREATE INDEX IDX_QRTZ_T_C ON QRTZ_TRIGGERS(SCHED_NAME,CALENDAR_NAME);
    347. CREATE INDEX IDX_QRTZ_T_G ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);
    348. CREATE INDEX IDX_QRTZ_T_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE);
    349. CREATE INDEX IDX_QRTZ_T_N_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE);
    350. CREATE INDEX IDX_QRTZ_T_N_G_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE);
    351. CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGGERS(SCHED_NAME,NEXT_FIRE_TIME);
    352. CREATE INDEX IDX_QRTZ_T_NFT_ST ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME);
    353. CREATE INDEX IDX_QRTZ_T_NFT_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME);
    354. CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE);
    355. CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE_GRP ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE);
    356.  
    357. CREATE INDEX IDX_QRTZ_FT_TRIG_INST_NAME ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME);
    358. CREATE INDEX IDX_QRTZ_FT_INST_JOB_REQ_RCVRY ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY);
    359. CREATE INDEX IDX_QRTZ_FT_J_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);
    360. CREATE INDEX IDX_QRTZ_FT_JG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_GROUP);
    361. CREATE INDEX IDX_QRTZ_FT_T_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP);
    362. CREATE INDEX IDX_QRTZ_FT_TG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);
    View Code

    2)项目运行

    3、安装node.js 及 vue 运行

    1)安装http://nodejs.cn/download/

    直接点下一步下一步就行了

    2)cmd 运行，配置npm为淘宝镜像：

    npm config set registry http://registry.npm.taobao.org

    3)npm install 安装依赖包

    可能会遇到安装失败，作者遇到的是core-js版本过高，降版本就可以了：npm install npm@6.14.13  -g

     4)运行：npm run dev

     

     会自动弹出浏览器窗口，账号密码都是：admin

     四、快速开发-人人开源逆向工程之 generator 代码生成

    1、克隆项目

    git clone https://gitee.com/renrenio/renren-generator.git

    2、更改配置

    1)mysql地址及对应服务的库名

    2)更改为如下图二

     

     3)更改生成模板 Controller.java

    目录路径：src/main/resources/template/Controller.java.vm

    有该包或注解的都注释掉：RequiresPermissions

     

    3、运行generator项目生成代码

    1)打开 http://localhost/#generator.html

     2)选择所有表，点击 生成代码，进行下载，将所以服务依次进行生成。

    解决代码的依赖错误，所以新建 maven common模块作为公共模块，每个微服务模块引用即可： 

     

    3)application.yml 的 mysql 配置

    1. spring:
    2.   datasource:
    3.     #MySQL配置
    4.     driverClassName: com.mysql.cj.jdbc.Driver
    5.     url: jdbc:mysql://192.168.56.138:3306/gulimall_pms?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai
    6.     username: root
    7.     password: Aa123654
    8. server:
    9.   port: 10000
    10.   cloud:

    4)随便写个接口，运行项目测试一下

     

     

    End

  • 相关阅读:
    创建线程池执行java代码逻辑
    Discourse 的用户快速找到管理员账号
    基于MODIS数据的2000-2021年中国植被生物量数据集
    基于PHP+MySQL家庭医生签约预约诊疗管理信息系统
    经典JsonPath表达式
    蜂窝移动终端的Cat指的是什么？
    LVI-SAM：配置环境、安装测试、适配自己采集数据集
    机器学习基础
    面对外贸客户索赔，第一步要怎么处理？
    C++编译期反射实践——以AOP实现为例
  • 原文地址：https://blog.csdn.net/qq_42675140/article/details/125470958