/* Navicat Premium Data Transfer Source Server : local Source Server Type : MySQL Source Server Version : 80032 Source Host : localhost:3306 Source Schema : kxs_codegen Target Server Type : MySQL Target Server Version : 80032 File Encoding : 65001 Date: 14/11/2023 22:34:04 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for gen_datasource_conf -- ---------------------------- DROP TABLE IF EXISTS `gen_datasource_conf`; CREATE TABLE `gen_datasource_conf` ( `id` bigint(0) NOT NULL COMMENT '主键', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '别名', `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'jdbcurl', `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名', `password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标记', `ds_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据库类型', `conf_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配置类型', `ds_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据库名称', `instance` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '实例', `port` int(0) NULL DEFAULT NULL COMMENT '端口', `host` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '主机', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '数据源表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of gen_datasource_conf -- ---------------------------- INSERT INTO `gen_datasource_conf` VALUES (1698964491791310849, 'sky_user', 'jdbc:mysql://sky-mysql:3306/sky?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&allowMultiQueries=true&allowPublicKeyRetrieval=true', 'root', 'J2VZaqwfUCFwNESkq11Mnw==', '2023-09-05 15:41:15', '2023-11-13 22:28:01', '1', 'mysql', '0', 'sky', '', 3306, 'sky-mysql'); INSERT INTO `gen_datasource_conf` VALUES (1701840936718921730, 'sky_shop', 'jdbc:mysql://sky-mysql:3306/sky_shop?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&allowMultiQueries=true&allowPublicKeyRetrieval=true', 'root', 'N+RQ4P3axbZJ6y/NuxYu8w==', '2023-09-13 14:11:13', '2023-11-13 22:04:27', '1', 'mysql', '0', 'sky_shop', '', 3306, 'sky-mysql'); -- ---------------------------- -- Table structure for gen_field_type -- ---------------------------- DROP TABLE IF EXISTS `gen_field_type`; CREATE TABLE `gen_field_type` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id', `column_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字段类型', `attr_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '属性类型', `package_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '属性包名', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `column_type`(`column_type`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字段类型管理' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of gen_field_type -- ---------------------------- INSERT INTO `gen_field_type` VALUES (1, 'datetime', 'LocalDateTime', 'java.time.LocalDateTime', '2023-02-06 08:45:10', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (2, 'date', 'LocalDate', 'java.time.LocalDate', '2023-02-06 08:45:10', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (3, 'tinyint', 'Integer', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (4, 'smallint', 'Integer', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (5, 'mediumint', 'Integer', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (6, 'int', 'Integer', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (7, 'integer', 'Integer', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (8, 'bigint', 'Long', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (9, 'float', 'Float', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (10, 'double', 'Double', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (11, 'decimal', 'BigDecimal', 'java.math.BigDecimal', '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (12, 'bit', 'Boolean', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (13, 'char', 'String', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (14, 'varchar', 'String', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (15, 'tinytext', 'String', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (16, 'text', 'String', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (17, 'mediumtext', 'String', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (18, 'longtext', 'String', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (19, 'timestamp', 'LocalDateTime', 'java.time.LocalDateTime', '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (20, 'NUMBER', 'Integer', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (21, 'BINARY_INTEGER', 'Integer', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (22, 'BINARY_FLOAT', 'Float', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (23, 'BINARY_DOUBLE', 'Double', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (24, 'VARCHAR2', 'String', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (25, 'NVARCHAR', 'String', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (26, 'NVARCHAR2', 'String', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (27, 'CLOB', 'String', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (28, 'int8', 'Long', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (29, 'int4', 'Integer', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (30, 'int2', 'Integer', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (31, 'numeric', 'BigDecimal', 'java.math.BigDecimal', '2023-02-06 08:45:12', NULL, NULL, NULL, '0'); INSERT INTO `gen_field_type` VALUES (32, 'json', 'String', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0'); -- ---------------------------- -- Table structure for gen_group -- ---------------------------- DROP TABLE IF EXISTS `gen_group`; CREATE TABLE `gen_group` ( `id` bigint(0) NOT NULL, `group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分组名称', `group_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分组描述', `create_by` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT ' ' COMMENT '创建人', `update_by` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT ' ' COMMENT '修改人', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改人', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '模板分组' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of gen_group -- ---------------------------- INSERT INTO `gen_group` VALUES (1, '增删改查', '单表增删改查', ' ', 'admin', NULL, '2023-11-13 22:05:51', '0'); -- ---------------------------- -- Table structure for gen_table -- ---------------------------- DROP TABLE IF EXISTS `gen_table`; CREATE TABLE `gen_table` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id', `table_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表名', `class_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类名', `db_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据库类型', `table_comment` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '说明', `author` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '作者', `email` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱', `package_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目包名', `version` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目版本号', `i18n` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '是否生成带有i18n 0 不带有 1带有', `style` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '代码风格', `child_table_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '子表名称', `main_field` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '主表关联键', `child_field` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '子表关联键', `generator_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '生成方式 0：zip压缩包 1：自定义目录', `backend_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '后端生成路径', `frontend_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '前端生成路径', `module_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块名', `function_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '功能名', `form_layout` tinyint(0) NULL DEFAULT NULL COMMENT '表单布局 1：一列 2：两列', `ds_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据源ID', `baseclass_id` bigint(0) NULL DEFAULT NULL COMMENT '基类ID', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `table_name`(`table_name`, `ds_name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1704059424189521922 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of gen_table -- ---------------------------- INSERT INTO `gen_table` VALUES (1701840570984001537, 'undefined', 'Undefined', NULL, NULL, 'sky', 'sky4cloud@qq.com', 'com.skycloud.sky', '1.0.0', '0', '0', NULL, NULL, NULL, '0', 'sky', 'sky-ui', 'sky', 'undefined', 2, 'undefined', NULL, '2023-09-13 14:09:45'); INSERT INTO `gen_table` VALUES (1701841069711912961, 'sky_goods_reply', 'SkyGoodsReply', 'mysql', '评论表', 'sky', 'sky4cloud@qq.com', 'com.skycloud.sky', '1.0.0', '0', '1', NULL, NULL, NULL, '0', 'sky', 'sky-ui', 'shop', 'skyGoodsReply', 2, 'sky_shop', NULL, '2023-09-13 14:11:44'); INSERT INTO `gen_table` VALUES (1701843217531105282, 'sky_cart', 'SkyCart', 'mysql', '购物车表', 'sky', 'sky4cloud@qq.com', 'com.skycloud.sky', '1.0.0', '0', '1', NULL, NULL, NULL, '0', 'sky', 'sky-ui', 'sky', 'skyCart', 1, 'sky_shop', NULL, '2023-09-13 14:20:16'); INSERT INTO `gen_table` VALUES (1701844944783241217, 'sky_goods_relation', 'SkyGoodsRelation', 'mysql', '商品点赞和收藏表', 'sky', 'sky4cloud@qq.com', 'com.skycloud.sky', '1.0.0', '0', '1', NULL, NULL, NULL, '0', 'sky', 'sky-ui', 'shop', 'skyGoodsRelation', 2, 'sky_shop', NULL, '2023-09-13 14:27:08'); INSERT INTO `gen_table` VALUES (1701851386458238978, 'sky_goods_rule', 'SkyGoodsRule', 'mysql', '商品规则值(规格)表', 'sky', 'sky4cloud@qq.com', 'com.skycloud.sky', '1.0.0', '0', '0', NULL, NULL, NULL, '0', 'sky', 'sky-ui', 'sky', 'skyGoodsRule', 2, 'sky_shop', NULL, '2023-09-13 14:52:44'); INSERT INTO `gen_table` VALUES (1701851490502144001, 'sky_category', 'SkyCategory', 'mysql', '分类表', 'sky', 'sky4cloud@qq.com', 'com.skycloud.sky', '1.0.0', '0', '0', NULL, NULL, NULL, '0', 'sky', 'sky-ui', 'sky', 'skyCategory', 2, 'sky_shop', NULL, '2023-09-13 14:53:09'); INSERT INTO `gen_table` VALUES (1702202111882780674, 'sky_user_address', 'SkyUserAddress', 'mysql', '用户地址表', 'sky', 'sky4cloud@qq.com', 'com.skycloud.sky', '1.0.0', '0', '1', NULL, NULL, NULL, '0', 'sky', 'sky-ui', 'shop', 'skyUserAddress', 1, 'sky_shop', NULL, '2023-09-14 14:06:24'); INSERT INTO `gen_table` VALUES (1702202836939530242, 'sky_freight_temp', 'SkyFreightTemp', 'mysql', '运费模板', 'sky', 'sky4cloud@qq.com', 'com.skycloud.sky', '1.0.0', '0', '1', NULL, NULL, NULL, '0', 'sky', 'sky-ui', 'shop', 'skyFreightTemp', 2, 'sky_shop', NULL, '2023-09-14 14:09:16'); INSERT INTO `gen_table` VALUES (1702203250296578049, 'sky_order', 'SkyOrder', 'mysql', '订单表', 'sky', 'sky4cloud@qq.com', 'com.skycloud.sky', '1.0.0', '0', '1', NULL, NULL, NULL, '0', 'sky', 'sky-ui', 'shop', 'skyOrder', 2, 'sky_shop', NULL, '2023-09-14 14:10:55'); INSERT INTO `gen_table` VALUES (1702205965185671169, 'sys_city', 'SysCity', 'mysql', '城市表', 'sky', 'sky4cloud@qq.com', 'com.skycloud.sky', '1.0.0', '0', '1', NULL, NULL, NULL, '0', 'sky', 'sky-ui', 'upms', 'sysCity', 1, 'sky_user', NULL, '2023-09-14 14:21:42'); INSERT INTO `gen_table` VALUES (1702245755100684290, 'sky_freight_temp_region', 'SkyFreightTempRegion', 'mysql', '运费模板指定区域费用', 'sky', 'sky4cloud@qq.com', 'com.skycloud.sky', '1.0.0', '0', '1', NULL, NULL, NULL, '0', 'sky', 'sky-ui', 'shop', 'skyFreightTempRegion', 1, 'sky_shop', NULL, '2023-09-14 16:59:49'); INSERT INTO `gen_table` VALUES (1704045771214102529, 'sky_order_info', 'SkyOrderInfo', 'mysql', '订单购物详情表', 'sky', 'sky4cloud@qq.com', 'com.skycloud.sky', '1.0.0', '0', '1', NULL, NULL, NULL, '0', 'sky', 'sky-ui', 'shop', 'skyOrderInfo', 1, 'sky_shop', NULL, '2023-09-19 16:12:26'); INSERT INTO `gen_table` VALUES (1704046404885356545, 'sky_order_log', 'SkyOrderLog', 'mysql', '订单操作记录表', 'sky', 'sky4cloud@qq.com', 'com.skycloud.sky', '1.0.0', '0', '1', NULL, NULL, NULL, '0', 'sky', 'sky-ui', 'shop', 'skyOrderLog', 1, 'sky_shop', NULL, '2023-09-19 16:14:57'); INSERT INTO `gen_table` VALUES (1704059424189521922, 'sky_pay_config', 'SkyPayConfig', 'mysql', '支付配置', 'sky', 'sky4cloud@qq.com', 'com.skycloud.sky', '1.0.0', '0', '1', NULL, NULL, NULL, '0', 'sky', 'sky-ui', 'user', 'skyPayConfig', 2, 'sky_user', NULL, '2023-09-19 17:06:41'); -- ---------------------------- -- Table structure for gen_table_column -- ---------------------------- DROP TABLE IF EXISTS `gen_table_column`; CREATE TABLE `gen_table_column` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id', `ds_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据源名称', `table_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表名称', `field_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字段名称', `field_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字段类型', `field_comment` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字段说明', `attr_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '属性名', `attr_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '属性类型', `package_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '属性包名', `sort` int(0) NULL DEFAULT NULL COMMENT '排序', `auto_fill` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '自动填充 DEFAULT、INSERT、UPDATE、INSERT_UPDATE', `primary_pk` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '主键 0：否 1：是', `base_field` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '基类字段 0：否 1：是', `form_item` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '表单项 0：否 1：是', `form_required` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '表单必填 0：否 1：是', `form_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表单类型', `form_validator` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表单效验', `grid_item` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '列表项 0：否 1：是', `grid_sort` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '列表排序 0：否 1：是', `query_item` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '查询项 0：否 1：是', `query_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '查询方式', `query_form_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '查询表单类型', `field_dict` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典类型', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1704059424856416258 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成表字段' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of gen_table_column -- ---------------------------- INSERT INTO `gen_table_column` VALUES (1701841070047457282, 'sky_shop', 'sky_goods_reply', 'id', 'int', '评论ID', 'id', 'Integer', NULL, 0, 'DEFAULT', '1', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701841070064234498, 'sky_shop', 'sky_goods_reply', 'uid', 'int', '用户ID', 'uid', 'Integer', NULL, 1, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '0', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701841070072623106, 'sky_shop', 'sky_goods_reply', 'oid', 'int', '订单ID', 'oid', 'Integer', NULL, 2, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '0', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701841070081011713, 'sky_shop', 'sky_goods_reply', 'unique', 'varchar', '商品唯一id', 'unique', 'String', NULL, 3, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701841070085206017, 'sky_shop', 'sky_goods_reply', 'product_id', 'int', '商品id', 'productId', 'Integer', NULL, 4, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701841070097788929, 'sky_shop', 'sky_goods_reply', 'reply_type', 'varchar', '某种商品类型(普通商品、秒杀商品）', 'replyType', 'String', NULL, 5, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701841070101983233, 'sky_shop', 'sky_goods_reply', 'product_score', 'tinyint', '商品分数', 'productScore', 'Integer', NULL, 6, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '0', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701841070114566146, 'sky_shop', 'sky_goods_reply', 'service_score', 'tinyint', '服务分数', 'serviceScore', 'Integer', NULL, 7, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '0', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701841070118760449, 'sky_shop', 'sky_goods_reply', 'comment', 'varchar', '评论内容', 'comment', 'String', NULL, 8, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701841070127149057, 'sky_shop', 'sky_goods_reply', 'pics', 'text', '评论图片', 'pics', 'String', NULL, 9, 'DEFAULT', '0', '0', '1', '0', 'textarea', NULL, '1', '0', '0', '=', 'textarea', NULL); INSERT INTO `gen_table_column` VALUES (1701841070131343362, 'sky_shop', 'sky_goods_reply', 'merchant_reply_content', 'varchar', '管理员回复内容', 'merchantReplyContent', 'String', NULL, 10, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701841070135537665, 'sky_shop', 'sky_goods_reply', 'merchant_reply_time', 'int', '管理员回复时间', 'merchantReplyTime', 'Integer', NULL, 11, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701841070148120577, 'sky_shop', 'sky_goods_reply', 'is_del', 'tinyint', '0未删除1已删除', 'isDel', 'Integer', NULL, 12, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '0', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701841070152314882, 'sky_shop', 'sky_goods_reply', 'is_reply', 'tinyint', '0未回复1已回复', 'isReply', 'Integer', NULL, 13, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '0', '0', '1', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701841070156509185, 'sky_shop', 'sky_goods_reply', 'nickname', 'varchar', '用户名称', 'nickname', 'String', NULL, 14, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '1', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701841070160703489, 'sky_shop', 'sky_goods_reply', 'avatar', 'varchar', '用户头像', 'avatar', 'String', NULL, 15, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701841070164897793, 'sky_shop', 'sky_goods_reply', 'create_time', 'timestamp', '创建时间', 'createTime', 'LocalDateTime', 'java.time.LocalDateTime', 17, 'INSERT', '0', '0', '0', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701841070177480705, 'sky_shop', 'sky_goods_reply', 'update_time', 'timestamp', '更新时间', 'updateTime', 'LocalDateTime', 'java.time.LocalDateTime', 18, 'INSERT_UPDATE', '0', '0', '0', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701841070185869314, 'sky_shop', 'sky_goods_reply', 'sku', 'varchar', '商品规格属性值,多个,号隔开', 'sku', 'String', NULL, 16, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701843217887621121, 'sky_shop', 'sky_cart', 'id', 'bigint', '购物车表ID', 'id', 'Long', NULL, 0, 'DEFAULT', '1', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701843217900204034, 'sky_shop', 'sky_cart', 'uid', 'int', '用户ID', 'uid', 'Integer', NULL, 1, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701843217904398337, 'sky_shop', 'sky_cart', 'type', 'varchar', '类型', 'type', 'String', NULL, 2, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701843217908592641, 'sky_shop', 'sky_cart', 'product_id', 'int', '商品ID', 'productId', 'Integer', NULL, 3, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701843217908592642, 'sky_shop', 'sky_cart', 'product_attr_unique', 'varchar', '商品属性', 'productAttrUnique', 'String', NULL, 4, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701843217916981250, 'sky_shop', 'sky_cart', 'cart_num', 'smallint', '商品数量', 'cartNum', 'Integer', NULL, 5, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701843217921175554, 'sky_shop', 'sky_cart', 'is_new', 'tinyint', '是否为立即购买', 'isNew', 'Integer', NULL, 6, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701843217925369858, 'sky_shop', 'sky_cart', 'combination_id', 'int', '拼团id', 'combinationId', 'Integer', NULL, 7, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701843217925369859, 'sky_shop', 'sky_cart', 'seckill_id', 'int', '秒杀商品ID', 'seckillId', 'Integer', NULL, 8, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701843217929564161, 'sky_shop', 'sky_cart', 'bargain_id', 'int', '砍价id', 'bargainId', 'Integer', NULL, 9, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701843217933758466, 'sky_shop', 'sky_cart', 'create_time', 'datetime', '添加时间', 'createTime', 'LocalDateTime', 'java.time.LocalDateTime', 11, 'INSERT', '0', '0', '0', '0', 'datetime', NULL, '0', '0', '0', '=', 'datetime', NULL); INSERT INTO `gen_table_column` VALUES (1701843217937952769, 'sky_shop', 'sky_cart', 'update_time', 'timestamp', 'g', 'updateTime', 'LocalDateTime', 'java.time.LocalDateTime', 12, 'INSERT_UPDATE', '0', '0', '0', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701843217942147073, 'sky_shop', 'sky_cart', 'status', 'tinyint', '购物车状态', 'status', 'Integer', NULL, 10, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701844945039093761, 'sky_shop', 'sky_goods_relation', 'id', 'int', 'id', 'id', 'Integer', NULL, 0, 'DEFAULT', '1', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701844945043288065, 'sky_shop', 'sky_goods_relation', 'uid', 'int', '用户ID', 'uid', 'Integer', NULL, 1, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701844945047482369, 'sky_shop', 'sky_goods_relation', 'product_id', 'int', '商品ID', 'productId', 'Integer', NULL, 2, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1701844945047482370, 'sky_shop', 'sky_goods_relation', 'type', 'varchar', '类型(收藏(collect）、点赞(like))', 'type', 'String', NULL, 3, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701844945051676674, 'sky_shop', 'sky_goods_relation', 'category', 'varchar', '某种类型的商品(普通商品、秒杀商品)', 'category', 'String', NULL, 4, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701844945055870977, 'sky_shop', 'sky_goods_relation', 'create_time', 'timestamp', '创建时间', 'createTime', 'LocalDateTime', 'java.time.LocalDateTime', 5, 'INSERT', '0', '0', '0', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701844945060065281, 'sky_shop', 'sky_goods_relation', 'update_time', 'timestamp', '更新时间', 'updateTime', 'LocalDateTime', 'java.time.LocalDateTime', 6, 'INSERT_UPDATE', '0', '0', '0', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701851386735063042, 'sky_shop', 'sky_goods_rule', 'id', 'int', '', 'id', 'Integer', NULL, 0, 'DEFAULT', '1', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701851386739257345, 'sky_shop', 'sky_goods_rule', 'rule_name', 'varchar', '规格名称', 'ruleName', 'String', NULL, 1, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701851386739257346, 'sky_shop', 'sky_goods_rule', 'rule_value', 'text', '规格值', 'ruleValue', 'String', NULL, 2, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701851490917380097, 'sky_shop', 'sky_category', 'id', 'int', '', 'id', 'Integer', NULL, 0, 'DEFAULT', '1', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701851490921574401, 'sky_shop', 'sky_category', 'pid', 'int', '父级ID', 'pid', 'Integer', NULL, 1, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701851490925768706, 'sky_shop', 'sky_category', 'path', 'varchar', '路径', 'path', 'String', NULL, 2, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701851490925768707, 'sky_shop', 'sky_category', 'name', 'varchar', '分类名称', 'name', 'String', NULL, 3, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701851490929963009, 'sky_shop', 'sky_category', 'type', 'smallint', '类型，1 产品分类，2 附件分类，3 文章分类， 4 设置分类， 5 菜单分类，6 配置分类， 7 秒杀配置', 'type', 'Integer', NULL, 4, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701851490929963010, 'sky_shop', 'sky_category', 'url', 'varchar', '地址', 'url', 'String', NULL, 5, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701851490934157313, 'sky_shop', 'sky_category', 'extra', 'text', '扩展字段 Jsos格式', 'extra', 'String', NULL, 6, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701851490938351617, 'sky_shop', 'sky_category', 'status', 'tinyint', '状态, 1正常，0失效', 'status', 'Integer', NULL, 7, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701851490942545922, 'sky_shop', 'sky_category', 'sort', 'int', '排序', 'sort', 'Integer', NULL, 8, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701851490950934530, 'sky_shop', 'sky_category', 'create_time', 'timestamp', '创建时间', 'createTime', 'LocalDateTime', 'java.time.LocalDateTime', 101, 'INSERT', '0', '0', '0', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1701851490955128833, 'sky_shop', 'sky_category', 'update_time', 'timestamp', '更新时间', 'updateTime', 'LocalDateTime', 'java.time.LocalDateTime', 103, 'INSERT_UPDATE', '0', '0', '0', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702202112616783873, 'sky_shop', 'sky_user_address', 'id', 'mediumint', '用户地址id', 'id', 'Integer', NULL, 0, 'DEFAULT', '1', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702202112629366786, 'sky_shop', 'sky_user_address', 'uid', 'int', '用户id', 'uid', 'Integer', NULL, 1, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702202112637755393, 'sky_shop', 'sky_user_address', 'real_name', 'varchar', '收货人姓名', 'realName', 'String', NULL, 2, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702202112641949698, 'sky_shop', 'sky_user_address', 'phone', 'varchar', '收货人电话', 'phone', 'String', NULL, 3, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702202112646144002, 'sky_shop', 'sky_user_address', 'province', 'varchar', '收货人所在省', 'province', 'String', NULL, 4, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702202112658726914, 'sky_shop', 'sky_user_address', 'city', 'varchar', '收货人所在市', 'city', 'String', NULL, 5, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702202112667115521, 'sky_shop', 'sky_user_address', 'city_id', 'int', '城市id', 'cityId', 'Integer', NULL, 6, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702202112675504130, 'sky_shop', 'sky_user_address', 'district', 'varchar', '收货人所在区', 'district', 'String', NULL, 7, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702202112679698434, 'sky_shop', 'sky_user_address', 'detail', 'varchar', '收货人详细地址', 'detail', 'String', NULL, 8, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702202112683892738, 'sky_shop', 'sky_user_address', 'post_code', 'int', '邮编', 'postCode', 'Integer', NULL, 9, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702202112688087042, 'sky_shop', 'sky_user_address', 'longitude', 'varchar', '经度', 'longitude', 'String', NULL, 10, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702202112692281346, 'sky_shop', 'sky_user_address', 'latitude', 'varchar', '纬度', 'latitude', 'String', NULL, 11, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702202112696475649, 'sky_shop', 'sky_user_address', 'is_default', 'tinyint', '是否默认', 'isDefault', 'Integer', NULL, 12, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702202112704864257, 'sky_shop', 'sky_user_address', 'is_del', 'tinyint', '是否删除', 'isDel', 'Integer', NULL, 13, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702202112709058562, 'sky_shop', 'sky_user_address', 'create_time', 'timestamp', '创建时间', 'createTime', 'LocalDateTime', 'java.time.LocalDateTime', 14, 'INSERT', '0', '0', '0', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702202112717447170, 'sky_shop', 'sky_user_address', 'update_time', 'timestamp', '更新时间', 'updateTime', 'LocalDateTime', 'java.time.LocalDateTime', 15, 'INSERT_UPDATE', '0', '0', '0', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702202837426069505, 'sky_shop', 'sky_freight_temp', 'id', 'int', '编号', 'id', 'Integer', NULL, 0, 'DEFAULT', '1', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702202837434458113, 'sky_shop', 'sky_freight_temp', 'name', 'varchar', '模板名称', 'name', 'String', NULL, 1, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702202837438652417, 'sky_shop', 'sky_freight_temp', 'type', 'tinyint', '计费方式', 'type', 'Integer', NULL, 2, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702202837438652418, 'sky_shop', 'sky_freight_temp', 'appoint', 'tinyint', '指定包邮', 'appoint', 'Integer', NULL, 3, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702202837442846721, 'sky_shop', 'sky_freight_temp', 'sort', 'int', '排序', 'sort', 'Integer', NULL, 4, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702202837447041025, 'sky_shop', 'sky_freight_temp', 'create_time', 'datetime', '创建时间', 'createTime', 'LocalDateTime', 'java.time.LocalDateTime', 5, 'INSERT', '0', '0', '0', '0', 'datetime', NULL, '0', '0', '0', '=', 'datetime', NULL); INSERT INTO `gen_table_column` VALUES (1702202837451235329, 'sky_shop', 'sky_freight_temp', 'update_time', 'datetime', '更新时间', 'updateTime', 'LocalDateTime', 'java.time.LocalDateTime', 6, 'INSERT_UPDATE', '0', '0', '0', '0', 'datetime', NULL, '0', '0', '0', '=', 'datetime', NULL); INSERT INTO `gen_table_column` VALUES (1702203250619539458, 'sky_shop', 'sky_order', 'id', 'int', '订单ID', 'id', 'Integer', NULL, 0, 'DEFAULT', '1', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250627928065, 'sky_shop', 'sky_order', 'order_sn', 'varchar', '订单号', 'orderSn', 'String', NULL, 1, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250632122370, 'sky_shop', 'sky_order', 'uid', 'int', '用户id', 'uid', 'Integer', NULL, 2, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250632122371, 'sky_shop', 'sky_order', 'real_name', 'varchar', '用户姓名', 'realName', 'String', NULL, 3, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250636316674, 'sky_shop', 'sky_order', 'user_phone', 'varchar', '用户电话', 'userPhone', 'String', NULL, 4, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250640510978, 'sky_shop', 'sky_order', 'user_address', 'varchar', '详细地址', 'userAddress', 'String', NULL, 5, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250644705281, 'sky_shop', 'sky_order', 'freight_price', 'decimal', '运费金额', 'freightPrice', 'BigDecimal', 'java.math.BigDecimal', 6, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250648899585, 'sky_shop', 'sky_order', 'total_num', 'int', '订单商品总数', 'totalNum', 'Integer', NULL, 7, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250653093890, 'sky_shop', 'sky_order', 'total_price', 'decimal', '订单总价', 'totalPrice', 'BigDecimal', 'java.math.BigDecimal', 8, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250657288194, 'sky_shop', 'sky_order', 'total_postage', 'decimal', '邮费', 'totalPostage', 'BigDecimal', 'java.math.BigDecimal', 9, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250661482497, 'sky_shop', 'sky_order', 'pay_price', 'decimal', '实际支付金额', 'payPrice', 'BigDecimal', 'java.math.BigDecimal', 10, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250665676802, 'sky_shop', 'sky_order', 'pay_postage', 'decimal', '支付邮费', 'payPostage', 'BigDecimal', 'java.math.BigDecimal', 11, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250669871106, 'sky_shop', 'sky_order', 'deduction_price', 'decimal', '抵扣金额', 'deductionPrice', 'BigDecimal', 'java.math.BigDecimal', 12, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250669871107, 'sky_shop', 'sky_order', 'coupon_id', 'int', '优惠券id', 'couponId', 'Integer', NULL, 13, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250678259714, 'sky_shop', 'sky_order', 'coupon_price', 'decimal', '优惠券金额', 'couponPrice', 'BigDecimal', 'java.math.BigDecimal', 14, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250682454018, 'sky_shop', 'sky_order', 'paid', 'tinyint', '支付状态', 'paid', 'Integer', NULL, 15, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250686648321, 'sky_shop', 'sky_order', 'pay_time', 'datetime', '支付时间', 'payTime', 'LocalDateTime', 'java.time.LocalDateTime', 16, 'DEFAULT', '0', '0', '1', '0', 'datetime', NULL, '1', '0', '0', '=', 'datetime', NULL); INSERT INTO `gen_table_column` VALUES (1702203250690842625, 'sky_shop', 'sky_order', 'pay_type', 'varchar', '支付方式', 'payType', 'String', NULL, 17, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250699231233, 'sky_shop', 'sky_order', 'create_time', 'datetime', '创建时间', 'createTime', 'LocalDateTime', 'java.time.LocalDateTime', 58, 'INSERT', '0', '0', '0', '0', 'datetime', NULL, '0', '0', '0', '=', 'datetime', NULL); INSERT INTO `gen_table_column` VALUES (1702203250707619842, 'sky_shop', 'sky_order', 'status', 'tinyint', '订单状态（0：待发货；1：待收货；2：已收货，待评价；3：已完成；）', 'status', 'Integer', NULL, 18, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250716008450, 'sky_shop', 'sky_order', 'refund_status', 'tinyint', '0 未退款 1 申请中 2 已退款 3 退款中', 'refundStatus', 'Integer', NULL, 19, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250720202754, 'sky_shop', 'sky_order', 'refund_reason_wap_img', 'varchar', '退款图片', 'refundReasonWapImg', 'String', NULL, 20, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250724397058, 'sky_shop', 'sky_order', 'refund_reason_wap_explain', 'varchar', '退款用户说明', 'refundReasonWapExplain', 'String', NULL, 21, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250732785665, 'sky_shop', 'sky_order', 'refund_reason_wap', 'varchar', '前台退款原因', 'refundReasonWap', 'String', NULL, 22, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250736979970, 'sky_shop', 'sky_order', 'refund_reason', 'varchar', '不退款的理由', 'refundReason', 'String', NULL, 23, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250741174273, 'sky_shop', 'sky_order', 'refund_reason_time', 'datetime', '退款时间', 'refundReasonTime', 'LocalDateTime', 'java.time.LocalDateTime', 24, 'DEFAULT', '0', '0', '1', '0', 'datetime', NULL, '1', '0', '0', '=', 'datetime', NULL); INSERT INTO `gen_table_column` VALUES (1702203250749562882, 'sky_shop', 'sky_order', 'refund_price', 'decimal', '退款金额', 'refundPrice', 'BigDecimal', 'java.math.BigDecimal', 25, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250749562883, 'sky_shop', 'sky_order', 'delivery_name', 'varchar', '快递名称/送货人姓名', 'deliveryName', 'String', NULL, 26, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250762145793, 'sky_shop', 'sky_order', 'delivery_type', 'varchar', '发货类型', 'deliveryType', 'String', NULL, 27, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250766340097, 'sky_shop', 'sky_order', 'delivery_id', 'varchar', '快递单号/手机号', 'deliveryId', 'String', NULL, 28, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250774728706, 'sky_shop', 'sky_order', 'gain_integral', 'decimal', '消费赚取积分', 'gainIntegral', 'BigDecimal', 'java.math.BigDecimal', 29, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250787311617, 'sky_shop', 'sky_order', 'use_integral', 'decimal', '使用积分', 'useIntegral', 'BigDecimal', 'java.math.BigDecimal', 30, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250791505922, 'sky_shop', 'sky_order', 'back_integral', 'decimal', '给用户退了多少积分', 'backIntegral', 'BigDecimal', 'java.math.BigDecimal', 31, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250791505923, 'sky_shop', 'sky_order', 'mark', 'varchar', '备注', 'mark', 'String', NULL, 32, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250799894529, 'sky_shop', 'sky_order', 'is_del', 'tinyint', '是否删除', 'isDel', 'Integer', NULL, 33, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250804088834, 'sky_shop', 'sky_order', 'remark', 'varchar', '管理员备注', 'remark', 'String', NULL, 34, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250808283138, 'sky_shop', 'sky_order', 'mer_id', 'int', '商户ID', 'merId', 'Integer', NULL, 35, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250812477441, 'sky_shop', 'sky_order', 'is_mer_check', 'tinyint', '', 'isMerCheck', 'Integer', NULL, 36, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250816671746, 'sky_shop', 'sky_order', 'combination_id', 'int', '拼团商品id0一般商品', 'combinationId', 'Integer', NULL, 37, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250820866050, 'sky_shop', 'sky_order', 'pink_id', 'int', '拼团id 0没有拼团', 'pinkId', 'Integer', NULL, 38, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250820866051, 'sky_shop', 'sky_order', 'cost', 'decimal', '成本价', 'cost', 'BigDecimal', 'java.math.BigDecimal', 39, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250829254657, 'sky_shop', 'sky_order', 'seckill_id', 'int', '秒杀商品ID', 'seckillId', 'Integer', NULL, 40, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250841837570, 'sky_shop', 'sky_order', 'bargain_id', 'int', '砍价id', 'bargainId', 'Integer', NULL, 41, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250850226178, 'sky_shop', 'sky_order', 'verify_code', 'varchar', '核销码', 'verifyCode', 'String', NULL, 42, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250854420481, 'sky_shop', 'sky_order', 'store_id', 'int', '门店id', 'storeId', 'Integer', NULL, 43, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250858614785, 'sky_shop', 'sky_order', 'shipping_type', 'tinyint', '配送方式 1=快递 ，2=门店自提', 'shippingType', 'Integer', NULL, 44, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250862809089, 'sky_shop', 'sky_order', 'clerk_id', 'int', '店员id/核销员id', 'clerkId', 'Integer', NULL, 45, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250867003394, 'sky_shop', 'sky_order', 'is_channel', 'tinyint', '支付渠道(0微信公众号1微信小程序2余额)', 'isChannel', 'Integer', NULL, 46, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250871197698, 'sky_shop', 'sky_order', 'is_remind', 'tinyint', '消息提醒', 'isRemind', 'Integer', NULL, 47, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250871197699, 'sky_shop', 'sky_order', 'is_system_del', 'tinyint', '后台是否删除', 'isSystemDel', 'Integer', NULL, 48, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250875392001, 'sky_shop', 'sky_order', 'update_time', 'datetime', '更新时间', 'updateTime', 'LocalDateTime', 'java.time.LocalDateTime', 59, 'INSERT_UPDATE', '0', '0', '0', '0', 'datetime', NULL, '0', '0', '0', '=', 'datetime', NULL); INSERT INTO `gen_table_column` VALUES (1702203250883780609, 'sky_shop', 'sky_order', 'delivery_code', 'varchar', '快递公司简称', 'deliveryCode', 'String', NULL, 49, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250887974914, 'sky_shop', 'sky_order', 'bargain_user_id', 'int', '用户拼团活动id 0没有', 'bargainUserId', 'Integer', NULL, 50, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250892169217, 'sky_shop', 'sky_order', 'type', 'int', '订单类型:0-普通订单，1-视频号订单', 'type', 'Integer', NULL, 51, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250896363521, 'sky_shop', 'sky_order', 'pro_total_price', 'decimal', '商品总价', 'proTotalPrice', 'BigDecimal', 'java.math.BigDecimal', 52, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250908946434, 'sky_shop', 'sky_order', 'before_pay_price', 'decimal', '改价前支付金额', 'beforePayPrice', 'BigDecimal', 'java.math.BigDecimal', 53, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250917335042, 'sky_shop', 'sky_order', 'is_alter_price', 'tinyint', '是否改价,0-否，1-是', 'isAlterPrice', 'Integer', NULL, 54, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250925723649, 'sky_shop', 'sky_order', 'out_trade_no', 'varchar', '商户系统内部的订单号,32个字符内、可包含字母, 其他说明见商户订单号', 'outTradeNo', 'String', NULL, 55, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702203250929917954, 'sky_shop', 'sky_order', 'bank_id', 'bigint', '支付id', 'bankId', 'Long', NULL, 56, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702203250934112257, 'sky_shop', 'sky_order', 'pay_ratio', 'varchar', '支付时点卷比例', 'payRatio', 'String', NULL, 57, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702205965634461697, 'sky_user', 'sys_city', 'id', 'int', '', 'id', 'Integer', NULL, 0, 'DEFAULT', '1', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702205965651238914, 'sky_user', 'sys_city', 'city_id', 'int', '城市id', 'cityId', 'Integer', NULL, 1, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702205965659627522, 'sky_user', 'sys_city', 'level', 'int', '省市级别', 'level', 'Integer', NULL, 2, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702205965663821825, 'sky_user', 'sys_city', 'parent_id', 'int', '父级id', 'parentId', 'Integer', NULL, 3, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702205965676404738, 'sky_user', 'sys_city', 'area_code', 'varchar', '区号', 'areaCode', 'String', NULL, 4, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702205965688987650, 'sky_user', 'sys_city', 'name', 'varchar', '名称', 'name', 'String', NULL, 5, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702205965697376257, 'sky_user', 'sys_city', 'merger_name', 'varchar', '合并名称', 'mergerName', 'String', NULL, 6, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702205965705764865, 'sky_user', 'sys_city', 'lng', 'varchar', '经度', 'lng', 'String', NULL, 7, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702205965714153473, 'sky_user', 'sys_city', 'lat', 'varchar', '纬度', 'lat', 'String', NULL, 8, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702205965718347778, 'sky_user', 'sys_city', 'is_show', 'tinyint', '是否展示', 'isShow', 'Integer', NULL, 9, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702205965722542082, 'sky_user', 'sys_city', 'create_time', 'timestamp', '创建时间', 'createTime', 'LocalDateTime', 'java.time.LocalDateTime', 10, 'INSERT', '0', '0', '0', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702205965739319297, 'sky_user', 'sys_city', 'update_time', 'timestamp', '更新时间', 'updateTime', 'LocalDateTime', 'java.time.LocalDateTime', 11, 'INSERT_UPDATE', '0', '0', '0', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702245755658526721, 'sky_shop', 'sky_freight_temp_region', 'id', 'int', '编号', 'id', 'Integer', NULL, 0, 'DEFAULT', '1', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702245755679498241, 'sky_shop', 'sky_freight_temp_region', 'temp_id', 'int', '模板ID', 'tempId', 'Integer', NULL, 1, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702245755687886850, 'sky_shop', 'sky_freight_temp_region', 'city_id', 'int', '城市ID', 'cityId', 'Integer', NULL, 2, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702245755692081153, 'sky_shop', 'sky_freight_temp_region', 'title', 'text', '描述', 'title', 'String', NULL, 3, 'DEFAULT', '0', '0', '1', '0', 'textarea', NULL, '1', '0', '0', '=', 'textarea', NULL); INSERT INTO `gen_table_column` VALUES (1702245755700469761, 'sky_shop', 'sky_freight_temp_region', 'first', 'decimal', '首件', 'first', 'BigDecimal', 'java.math.BigDecimal', 4, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702245755721441282, 'sky_shop', 'sky_freight_temp_region', 'first_price', 'decimal', '首件运费', 'firstPrice', 'BigDecimal', 'java.math.BigDecimal', 5, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702245755725635586, 'sky_shop', 'sky_freight_temp_region', 'renewal', 'decimal', '续件', 'renewal', 'BigDecimal', 'java.math.BigDecimal', 6, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702245755738218498, 'sky_shop', 'sky_freight_temp_region', 'renewal_price', 'decimal', '续件运费', 'renewalPrice', 'BigDecimal', 'java.math.BigDecimal', 7, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702245755746607105, 'sky_shop', 'sky_freight_temp_region', 'type', 'tinyint', '计费方式 1按件数 2按重量 3按体积', 'type', 'Integer', NULL, 8, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702245755763384322, 'sky_shop', 'sky_freight_temp_region', 'uniqid', 'varchar', '分组唯一值', 'uniqid', 'String', NULL, 9, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702245755771772929, 'sky_shop', 'sky_freight_temp_region', 'status', 'tinyint', '是否无效', 'status', 'Integer', NULL, 10, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1702245755780161537, 'sky_shop', 'sky_freight_temp_region', 'create_time', 'timestamp', '创建时间', 'createTime', 'LocalDateTime', 'java.time.LocalDateTime', 11, 'INSERT', '0', '0', '0', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1702245755792744450, 'sky_shop', 'sky_freight_temp_region', 'update_time', 'timestamp', '更新时间', 'updateTime', 'LocalDateTime', 'java.time.LocalDateTime', 12, 'INSERT_UPDATE', '0', '0', '0', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704045771696447489, 'sky_shop', 'sky_order_info', 'id', 'int', '主键', 'id', 'Integer', NULL, 0, 'DEFAULT', '1', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1704045771713224705, 'sky_shop', 'sky_order_info', 'order_id', 'int', '订单id', 'orderId', 'Integer', NULL, 1, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1704045771721613313, 'sky_shop', 'sky_order_info', 'product_id', 'int', '商品ID', 'productId', 'Integer', NULL, 2, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1704045771725807618, 'sky_shop', 'sky_order_info', 'info', 'text', '购买东西的详细信息', 'info', 'String', NULL, 3, 'DEFAULT', '0', '0', '1', '0', 'textarea', NULL, '1', '0', '0', '=', 'textarea', NULL); INSERT INTO `gen_table_column` VALUES (1704045771734196225, 'sky_shop', 'sky_order_info', 'create_time', 'datetime', '创建时间', 'createTime', 'LocalDateTime', 'java.time.LocalDateTime', 18, 'INSERT', '0', '0', '0', '0', 'datetime', NULL, '0', '0', '0', '=', 'datetime', NULL); INSERT INTO `gen_table_column` VALUES (1704045771750973442, 'sky_shop', 'sky_order_info', 'update_time', 'datetime', '更新时间', 'updateTime', 'LocalDateTime', 'java.time.LocalDateTime', 19, 'INSERT_UPDATE', '0', '0', '0', '0', 'datetime', NULL, '0', '0', '0', '=', 'datetime', NULL); INSERT INTO `gen_table_column` VALUES (1704045771759362050, 'sky_shop', 'sky_order_info', 'order_sn', 'varchar', '订单号', 'orderSn', 'String', NULL, 4, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704045771771944961, 'sky_shop', 'sky_order_info', 'goods_name', 'varchar', '商品名称', 'goodsName', 'String', NULL, 5, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704045771776139266, 'sky_shop', 'sky_order_info', 'attr_value_id', 'int', '规格属性值id', 'attrValueId', 'Integer', NULL, 6, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1704045771780333569, 'sky_shop', 'sky_order_info', 'image', 'varchar', '商品图片', 'image', 'String', NULL, 7, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704045771784527873, 'sky_shop', 'sky_order_info', 'sku', 'varchar', '商品sku', 'sku', 'String', NULL, 8, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704045771792916481, 'sky_shop', 'sky_order_info', 'price', 'decimal', '商品价格', 'price', 'BigDecimal', 'java.math.BigDecimal', 9, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704045771801305089, 'sky_shop', 'sky_order_info', 'pay_num', 'int', '购买数量', 'payNum', 'Integer', NULL, 10, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1704045771809693697, 'sky_shop', 'sky_order_info', 'weight', 'decimal', '重量', 'weight', 'BigDecimal', 'java.math.BigDecimal', 11, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704045771818082306, 'sky_shop', 'sky_order_info', 'volume', 'decimal', '体积', 'volume', 'BigDecimal', 'java.math.BigDecimal', 12, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704045771826470913, 'sky_shop', 'sky_order_info', 'give_integral', 'decimal', '赠送积分', 'giveIntegral', 'BigDecimal', 'java.math.BigDecimal', 13, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704045771834859521, 'sky_shop', 'sky_order_info', 'is_reply', 'tinyint', '是否评价，0-未评价，1-已评价', 'isReply', 'Integer', NULL, 14, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1704045771839053826, 'sky_shop', 'sky_order_info', 'is_sub', 'tinyint', '是否单独分佣,0-否，1-是', 'isSub', 'Integer', NULL, 15, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1704045771847442434, 'sky_shop', 'sky_order_info', 'vip_price', 'decimal', '会员价', 'vipPrice', 'BigDecimal', 'java.math.BigDecimal', 16, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704045771855831042, 'sky_shop', 'sky_order_info', 'product_type', 'int', '商品类型:0-普通，1-秒杀，2-砍价，3-拼团，4-视频号', 'productType', 'Integer', NULL, 17, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1704046405241872386, 'sky_shop', 'sky_order_log', 'oid', 'int', '订单id', 'oid', 'Integer', NULL, 0, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1704046405250260994, 'sky_shop', 'sky_order_log', 'change_type', 'varchar', '操作类型', 'changeType', 'String', NULL, 1, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704046405258649602, 'sky_shop', 'sky_order_log', 'change_message', 'varchar', '操作备注', 'changeMessage', 'String', NULL, 2, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704046405262843906, 'sky_shop', 'sky_order_log', 'create_time', 'timestamp', '操作时间', 'createTime', 'LocalDateTime', 'java.time.LocalDateTime', 3, 'INSERT', '0', '0', '0', '0', 'text', NULL, '0', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704059424810278914, 'sky_user', 'sky_pay_config', 'id', 'int', '', 'id', 'Integer', NULL, 0, 'DEFAULT', '1', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); INSERT INTO `gen_table_column` VALUES (1704059424818667521, 'sky_user', 'sky_pay_config', 'title', 'varchar', '支付方式', 'title', 'String', NULL, 1, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704059424822861825, 'sky_user', 'sky_pay_config', 'mchid', 'varchar', 'Mchid', 'mchid', 'String', NULL, 2, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704059424827056130, 'sky_user', 'sky_pay_config', 'pay_type', 'varchar', '支付方式', 'payType', 'String', NULL, 3, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704059424831250434, 'sky_user', 'sky_pay_config', 'public_key', 'varchar', '公钥', 'publicKey', 'String', NULL, 4, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704059424835444737, 'sky_user', 'sky_pay_config', 'private_key', 'varchar', '私钥', 'privateKey', 'String', NULL, 5, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704059424843833345, 'sky_user', 'sky_pay_config', 'appid', 'varchar', 'appid', 'appid', 'String', NULL, 6, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704059424848027649, 'sky_user', 'sky_pay_config', 'appsecret', 'varchar', '密钥', 'appsecret', 'String', NULL, 7, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704059424852221954, 'sky_user', 'sky_pay_config', 'notify_url', 'varchar', '回调url', 'notifyUrl', 'String', NULL, 8, 'DEFAULT', '0', '0', '1', '0', 'text', NULL, '1', '0', '0', '=', 'text', NULL); INSERT INTO `gen_table_column` VALUES (1704059424856416258, 'sky_user', 'sky_pay_config', 'open', 'smallint', '1开启 0关闭', 'open', 'Integer', NULL, 9, 'DEFAULT', '0', '0', '1', '0', 'number', NULL, '1', '0', '0', '=', 'number', NULL); -- ---------------------------- -- Table structure for gen_template -- ---------------------------- DROP TABLE IF EXISTS `gen_template`; CREATE TABLE `gen_template` ( `id` bigint(0) NOT NULL COMMENT '主键', `template_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板名称', `generator_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板路径', `template_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板描述', `template_code` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板代码', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记', `create_by` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT ' ' COMMENT '创建人', `update_by` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT ' ' COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '模板' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of gen_template -- ---------------------------- INSERT INTO `gen_template` VALUES (1, 'Controller', '${backendPath}/src/main/java/${packagePath}/${moduleName}/controller/${ClassName}Controller.java', '后台Controller', 'package ${package}.${moduleName}.controller;\n\n#if($queryList)\nimport cn.hutool.core.util.StrUtil;\n#end\nimport cn.hutool.core.util.ArrayUtil;\nimport cn.hutool.core.collection.CollUtil;\nimport com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;\nimport com.baomidou.mybatisplus.core.toolkit.Wrappers;\nimport com.baomidou.mybatisplus.extension.plugins.pagination.Page;\nimport com.skycloud.sky.common.core.util.R;\nimport com.skycloud.sky.common.log.annotation.SysLog;\nimport ${package}.${moduleName}.entity.${ClassName}Entity;\nimport ${package}.${moduleName}.service.${ClassName}Service;\nimport org.springframework.security.access.prepost.PreAuthorize;\nimport com.pig4cloud.plugin.excel.annotation.ResponseExcel;\nimport io.swagger.v3.oas.annotations.security.SecurityRequirement;\nimport org.springdoc.core.annotations.ParameterObject;\nimport org.springframework.http.HttpHeaders;\nimport io.swagger.v3.oas.annotations.tags.Tag;\nimport io.swagger.v3.oas.annotations.Operation;\nimport lombok.RequiredArgsConstructor;\nimport org.springframework.web.bind.annotation.*;\n\nimport java.util.List;\nimport java.util.Objects;\n\n/**\n * ${tableComment}\n *\n * @author ${author}\n * @date ${datetime}\n */\n@RestController\n@RequiredArgsConstructor\n@RequestMapping(\"/${functionName}\" )\n@Tag(description = \"${functionName}\" , name = \"${tableComment}管理\" )\n@SecurityRequirement(name = HttpHeaders.AUTHORIZATION)\npublic class ${ClassName}Controller {\n\n private final ${ClassName}Service ${className}Service;\n\n /**\n * 分页查询\n * @param page 分页对象\n * @param ${className} ${tableComment}\n * @return\n */\n @Operation(summary = \"分页查询\" , description = \"分页查询\" )\n @GetMapping(\"/page\" )\n @PreAuthorize(\"@pms.hasPermission(\'${moduleName}_${functionName}_view\')\" )\n public R get${ClassName}Page(@ParameterObject Page page, @ParameterObject ${ClassName}Entity ${className}) {\n LambdaQueryWrapper<${ClassName}Entity> wrapper = Wrappers.lambdaQuery();\n#foreach ($field in $queryList)\n#set($getAttrName=$str.getProperty($field.attrName))\n#set($var=\"${className}.$getAttrName()\")\n#if($field.attrType == \'String\')\n#set($expression=\"StrUtil.isNotBlank\")\n#else\n#set($expression=\"Objects.nonNull\")\n#end\n#if($field.queryType == \'=\')\n wrapper.eq($expression($var),${ClassName}Entity::$getAttrName,$var);\n#elseif( $field.queryType == \'like\' )\n wrapper.like($expression($var),${ClassName}Entity::$getAttrName,$var);\n#elseif( $field.queryType == \'!-\' )\n wrapper.ne($expression($var),${ClassName}Entity::$getAttrName,$var);\n#elseif( $field.queryType == \'>\' )\n wrapper.gt($expression($var),${ClassName}Entity::$getAttrName,$var);\n#elseif( $field.queryType == \'<\' )\n wrapper.lt($expression($var),${ClassName}Entity::$getAttrName,$var);\n#elseif( $field.queryType == \'>=\' )\n wrapper.ge($expression($var),${ClassName}Entity::$getAttrName,$var);\n#elseif( $field.queryType == \'<=\' )\n wrapper.le($expression($var),${ClassName}Entity::$getAttrName,$var);\n#elseif( $field.queryType == \'left like\' )\n wrapper.likeLeft($expression($var),${ClassName}Entity::$getAttrName,$var);\n#elseif( $field.queryType == \'right like\' )\n wrapper.likeRight($expression($var),${ClassName}Entity::$getAttrName,$var);\n#end\n#end\n return R.ok(${className}Service.page(page, wrapper));\n }\n\n\n /**\n * 通过id查询${tableComment}\n * @param ${pk.attrName} id\n * @return R\n */\n @Operation(summary = \"通过id查询\" , description = \"通过id查询\" )\n @GetMapping(\"/{${pk.attrName}}\" )\n @PreAuthorize(\"@pms.hasPermission(\'${moduleName}_${functionName}_view\')\" )\n public R getById(@PathVariable(\"${pk.attrName}\" ) ${pk.attrType} ${pk.attrName}) {\n return R.ok(${className}Service.getById(${pk.attrName}));\n }\n\n /**\n * 新增${tableComment}\n * @param ${className} ${tableComment}\n * @return R\n */\n @Operation(summary = \"新增${tableComment}\" , description = \"新增${tableComment}\" )\n @SysLog(\"新增${tableComment}\" )\n @PostMapping\n @PreAuthorize(\"@pms.hasPermission(\'${moduleName}_${functionName}_add\')\" )\n public R save(@RequestBody ${ClassName}Entity ${className}) {\n return R.ok(${className}Service.save(${className}));\n }\n\n /**\n * 修改${tableComment}\n * @param ${className} ${tableComment}\n * @return R\n */\n @Operation(summary = \"修改${tableComment}\" , description = \"修改${tableComment}\" )\n @SysLog(\"修改${tableComment}\" )\n @PutMapping\n @PreAuthorize(\"@pms.hasPermission(\'${moduleName}_${functionName}_edit\')\" )\n public R updateById(@RequestBody ${ClassName}Entity ${className}) {\n return R.ok(${className}Service.updateById(${className}));\n }\n\n /**\n * 通过id删除${tableComment}\n * @param ids ${pk.attrName}列表\n * @return R\n */\n @Operation(summary = \"通过id删除${tableComment}\" , description = \"通过id删除${tableComment}\" )\n @SysLog(\"通过id删除${tableComment}\" )\n @DeleteMapping\n @PreAuthorize(\"@pms.hasPermission(\'${moduleName}_${functionName}_del\')\" )\n public R removeById(@RequestBody ${pk.attrType}[] ids) {\n return R.ok(${className}Service.removeBatchByIds(CollUtil.toList(ids)));\n }\n\n\n /**\n * 导出excel 表格\n * @param ${className} 查询条件\n * @param ids 导出指定ID\n * @return excel 文件流\n */\n @ResponseExcel\n @GetMapping(\"/export\")\n @PreAuthorize(\"@pms.hasPermission(\'${moduleName}_${functionName}_export\')\" )\n public List<${ClassName}Entity> export(${ClassName}Entity ${className},${pk.attrType}[] ids) {\n return ${className}Service.list(Wrappers.lambdaQuery(${className}).in(ArrayUtil.isNotEmpty(ids), ${ClassName}Entity::$str.getProperty($pk.attrName), ids));\n }\n}', '2023-02-23 01:16:17', '2023-08-28 22:48:06', '0', '', 'admin'); INSERT INTO `gen_template` VALUES (2, 'Service', '${backendPath}/src/main/java/${packagePath}/${moduleName}/service/${ClassName}Service.java', 'Service', 'package ${package}.${moduleName}.service;\n\n#if($ChildClassName)\nimport com.github.yulichang.extension.mapping.base.MPJDeepService;\nimport ${package}.${moduleName}.entity.${ChildClassName}Entity;\n#else\nimport com.baomidou.mybatisplus.extension.service.IService;\n#end\nimport ${package}.${moduleName}.entity.${ClassName}Entity;\n\n#if($ChildClassName)\npublic interface ${ClassName}Service extends MPJDeepService<${ClassName}Entity> {\n Boolean saveDeep(${ClassName}Entity ${className});\n\n Boolean updateDeep(${ClassName}Entity ${className});\n\n Boolean removeDeep(Long[] ids);\n\n Boolean removeChild(Long[] ids);\n#else\npublic interface ${ClassName}Service extends IService<${ClassName}Entity> {\n#end\n\n}', '2023-02-23 01:16:53', '2023-06-04 10:35:25', '0', ' ', ' '); INSERT INTO `gen_template` VALUES (3, 'ServiceImpl', '${backendPath}/src/main/java/${packagePath}/${moduleName}/service/impl/${ClassName}ServiceImpl.java', 'ServiceImpl', 'package ${package}.${moduleName}.service.impl;\n\nimport com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;\nimport ${package}.${moduleName}.entity.${ClassName}Entity;\nimport ${package}.${moduleName}.mapper.${ClassName}Mapper;\nimport ${package}.${moduleName}.service.${ClassName}Service;\nimport org.springframework.stereotype.Service;\n#if($ChildClassName)\nimport cn.hutool.core.collection.CollUtil;\nimport com.baomidou.mybatisplus.core.toolkit.Wrappers;\nimport ${package}.${moduleName}.entity.${ChildClassName}Entity;\nimport ${package}.${moduleName}.mapper.${ChildClassName}Mapper;\nimport org.springframework.transaction.annotation.Transactional;\nimport lombok.RequiredArgsConstructor;\nimport java.util.Objects;\n#end\n/**\n * ${tableComment}\n *\n * @author ${author}\n * @date ${datetime}\n */\n@Service\n#if($ChildClassName)\n@RequiredArgsConstructor\n#end\npublic class ${ClassName}ServiceImpl extends ServiceImpl<${ClassName}Mapper, ${ClassName}Entity> implements ${ClassName}Service {\n#if($ChildClassName)\n private final ${ChildClassName}Mapper ${childClassName}Mapper;\n\n @Override\n @Transactional(rollbackFor = Exception.class)\n public Boolean saveDeep(${ClassName}Entity ${className}) {\n baseMapper.insert(${className});\n for (${ChildClassName}Entity ${childClassName} : ${className}.get${ChildClassName}List()) {\n ${childClassName}.$str.setProperty($childField)(${className}.$str.getProperty($mainField)());\n ${childClassName}Mapper.insert( ${childClassName});\n }\n\n return Boolean.TRUE;\n }\n\n @Override\n @Transactional(rollbackFor = Exception.class)\n public Boolean updateDeep(${ClassName}Entity ${className}) {\n baseMapper.updateById(${className});\n for (${ChildClassName}Entity ${childClassName} : ${className}.get${ChildClassName}List()) {\n#set($getChildPkName=$str.getProperty(${pk.attrName}))\n if (Objects.isNull(${childClassName}.$getChildPkName())) {\n ${childClassName}.$str.setProperty($childField)(${className}.getId());\n ${childClassName}Mapper.insert(${childClassName});\n } else {\n ${childClassName}Mapper.updateById(${childClassName});\n }\n }\n return Boolean.TRUE;\n }\n\n @Override\n @Transactional(rollbackFor = Exception.class)\n public Boolean removeDeep(Long[] ids) {\n baseMapper.deleteBatchIds(CollUtil.toList(ids));\n ${childClassName}Mapper.delete(Wrappers.<${ChildClassName}Entity>lambdaQuery().in(${ChildClassName}Entity::$str.getProperty($childField), ids));\n return Boolean.TRUE;\n }\n\n @Override\n @Transactional(rollbackFor = Exception.class)\n public Boolean removeChild(Long[] ids) {\n ${childClassName}Mapper.deleteBatchIds(CollUtil.toList(ids));\n return Boolean.TRUE;\n }\n#end\n}', '2023-02-23 01:17:36', '2023-08-27 23:29:58', '0', ' ', ' '); INSERT INTO `gen_template` VALUES (4, '实体', '${backendPath}/src/main/java/${packagePath}/${moduleName}/entity/${ClassName}Entity.java', 'Entity', 'package ${package}.${moduleName}.entity;\n\nimport com.baomidou.mybatisplus.annotation.*;\nimport com.baomidou.mybatisplus.extension.activerecord.Model;\nimport io.swagger.v3.oas.annotations.media.Schema;\nimport lombok.Data;\nimport lombok.EqualsAndHashCode;\n#foreach($import in $importList)\nimport $import;\n#end\n#if($ChildClassName)\nimport com.alibaba.excel.annotation.ExcelIgnore;\nimport com.github.yulichang.annotation.EntityMapping;\nimport java.util.List;\n#end\n\n/**\n * ${tableComment}\n *\n * @author ${author}\n * @date ${datetime}\n */\n@Data\n@TableName(\"${tableName}\")\n@EqualsAndHashCode(callSuper = true)\n@Schema(description = \"${tableComment}\")\npublic class ${ClassName}Entity extends Model<${ClassName}Entity> {\n\n#foreach ($field in $fieldList)\n#if(${field.fieldComment})#set($comment=${field.fieldComment})#else #set($comment=${field.attrName})#end\n\n /**\n * $comment\n */\n#if($field.primaryPk == \'1\')\n @TableId(type = IdType.ASSIGN_ID)\n#end\n#if($field.autoFill == \'INSERT\')\n @TableField(fill = FieldFill.INSERT)\n#elseif($field.autoFill == \'INSERT_UPDATE\')\n @TableField(fill = FieldFill.INSERT_UPDATE)\n#elseif($field.autoFill == \'UPDATE\')\n @TableField(fill = FieldFill.UPDATE)\n#end\n#if($field.fieldName == \'del_flag\')\n @TableLogic\n @TableField(fill = FieldFill.INSERT)\n#end\n @Schema(description=\"$comment\"#if($field.hidden),hidden=$field.hidden#end)\n private $field.attrType $field.attrName;\n#end\n#if($ChildClassName)\n @ExcelIgnore\n @TableField(exist = false)\n @EntityMapping(thisField = \"$mainField\", joinField = \"$childField\")\n private List<${ChildClassName}Entity> ${childClassName}List;\n#end\n}', '2023-02-23 01:17:53', '2023-08-27 22:26:06', '0', ' ', ' '); INSERT INTO `gen_template` VALUES (5, 'Mapper', '${backendPath}/src/main/java/${packagePath}/${moduleName}/mapper/${ClassName}Mapper.java', 'Mapper', 'package ${package}.${moduleName}.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport ${package}.${moduleName}.entity.${ClassName}Entity;\nimport org.apache.ibatis.annotations.Mapper;\n\n@Mapper\npublic interface ${ClassName}Mapper extends BaseMapper<${ClassName}Entity> {\n\n\n}', '2023-02-23 01:18:18', '2023-08-28 22:47:02', '0', ' ', 'admin'); INSERT INTO `gen_template` VALUES (6, 'Mapper.xml', '${backendPath}/src/main/resources/mapper/${ClassName}Mapper.xml', 'Mapper.xml', '\n\n\n\n\n \n#foreach ($field in $fieldList)\n #if($field.primaryPk)\n \n #end\n #if(!$field.primaryPk)\n \n #end\n#end\n \n', '2023-02-23 01:18:35', '2023-06-04 10:34:56', '0', ' ', ' '); INSERT INTO `gen_template` VALUES (7, '权限菜单', '${backendPath}/menu/${functionName}_menu.sql', 'menu.sql', '-- 该脚本不要直接执行， 注意维护菜单的父节点ID 默认 父节点-1 \n#set($menuId=${dateTool.getSystemTime()})\n\n-- 菜单SQL\ninsert into sys_menu ( menu_id,parent_id, path, permission, menu_type, icon, del_flag, create_time, sort_order, update_time, name)\nvalues (${menuId}, \'-1\', \'/${moduleName}/${functionName}/index\', \'\', \'0\', \'icon-bangzhushouji\', \'0\', null , \'8\', null , \'${tableComment}管理\');\n\n-- 菜单对应按钮SQL\ninsert into sys_menu ( menu_id,parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name)\nvalues (${math.add($menuId,1)},${menuId}, \'${moduleName}_${functionName}_view\', \'1\', null, \'1\', \'0\', null, \'0\', null, \'${tableComment}查看\');\n\ninsert into sys_menu ( menu_id,parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name)\nvalues (${math.add($menuId,2)},${menuId}, \'${moduleName}_${functionName}_add\', \'1\', null, \'1\', \'0\', null, \'1\', null, \'${tableComment}新增\');\n\ninsert into sys_menu (menu_id, parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name)\nvalues (${math.add($menuId,3)},${menuId}, \'${moduleName}_${functionName}_edit\', \'1\', null, \'1\', \'0\', null, \'2\', null, \'${tableComment}修改\');\n\ninsert into sys_menu (menu_id, parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name)\nvalues (${math.add($menuId,4)},${menuId}, \'${moduleName}_${functionName}_del\', \'1\', null, \'1\', \'0\', null, \'3\', null, \'${tableComment}删除\');\n\ninsert into sys_menu ( menu_id,parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name)\nvalues (${math.add($menuId,5)},${menuId}, \'${moduleName}_${functionName}_export\', \'1\', null, \'1\', \'0\', null, \'3\', null, \'导入导出\');', '2023-02-23 01:19:08', '2023-08-28 22:06:16', '0', ' ', ' '); INSERT INTO `gen_template` VALUES (8, 'api.ts', '${frontendPath}/src/api/${moduleName}/${functionName}.ts', 'api.ts', 'import request from \"/@/utils/request\"\n\nexport function fetchList(query?: Object) {\n return request({\n url: \'/${moduleName}/${functionName}/page\',\n method: \'get\',\n params: query\n })\n}\n\nexport function addObj(obj?: Object) {\n return request({\n url: \'/${moduleName}/${functionName}\',\n method: \'post\',\n data: obj\n })\n}\n\nexport function getObj(id?: string) {\n return request({\n url: \'/${moduleName}/${functionName}/\' + id,\n method: \'get\'\n })\n}\n\nexport function delObjs(ids?: Object) {\n return request({\n url: \'/${moduleName}/${functionName}\',\n method: \'delete\',\n data: ids\n })\n}\n\nexport function putObj(obj?: Object) {\n return request({\n url: \'/${moduleName}/${functionName}\',\n method: \'put\',\n data: obj\n })\n}\n\n#if($ChildClassName)\nexport function delChildObj(ids?: Object) {\n return request({\n url: \'/${moduleName}/${functionName}/child\',\n method: \'delete\',\n data: ids\n })\n}\n#end', '2023-02-23 01:19:23', '2023-06-04 10:34:17', '0', ' ', ' '); INSERT INTO `gen_template` VALUES (9, '表格', '${frontendPath}/src/views/${moduleName}/${functionName}/index.vue', '表格不含i18n', '\n\n', '2023-02-23 01:19:35', '2023-08-28 22:53:55', '0', '', 'admin'); INSERT INTO `gen_template` VALUES (10, '表单', '${frontendPath}/src/views/${moduleName}/${functionName}/form.vue', '表单不含i18n', '\n\n', '2023-02-23 01:19:48', '2023-08-27 22:23:19', '0', '', 'admin'); INSERT INTO `gen_template` VALUES (11, 'i18n英文模板', '${frontendPath}/src/views/${moduleName}/${functionName}/i18n/en.ts', 'i18n英文模板', 'export default {\n ${functionName}: {\n index: \'#\',\n import${className}Tip: \'import ${ClassName}\',\n#foreach($field in $fieldList)\n ${field.attrName}: \'${field.attrName}\',\n#end\n#foreach($field in $fieldList)\n input$str.pascalCase(${field.attrName})Tip: \'input ${field.attrName}\',\n#end\n }\n}', '2023-02-23 01:20:25', '2023-06-04 10:49:25', '0', '', 'admin'); INSERT INTO `gen_template` VALUES (12, 'i18n中文模板', '${frontendPath}/src/views/${moduleName}/${functionName}/i18n/zh-cn.ts', 'i18n中文模板', 'export default {\n ${functionName}: {\n index: \'#\',\n import${className}Tip: \'导入${tableComment}\',\n#foreach($field in $fieldList)\n ${field.attrName}: \'#if(${field.fieldComment})${field.fieldComment}#else ${field.attrName}#end\',\n#end\n#foreach($field in $fieldList)\n input$str.pascalCase(${field.attrName})Tip: \'请输入#if(${field.fieldComment})${field.fieldComment}#else ${field.attrName}#end\',\n#end\n }\n}', '2023-02-23 01:20:40', '2023-06-04 10:49:28', '0', '', 'admin'); -- ---------------------------- -- Table structure for gen_template_group -- ---------------------------- DROP TABLE IF EXISTS `gen_template_group`; CREATE TABLE `gen_template_group` ( `group_id` bigint(0) NOT NULL COMMENT '分组id', `template_id` bigint(0) NOT NULL COMMENT '模板id', PRIMARY KEY (`group_id`, `template_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '模板分组关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of gen_template_group -- ---------------------------- INSERT INTO `gen_template_group` VALUES (1, 1); INSERT INTO `gen_template_group` VALUES (1, 2); INSERT INTO `gen_template_group` VALUES (1, 3); INSERT INTO `gen_template_group` VALUES (1, 4); INSERT INTO `gen_template_group` VALUES (1, 5); INSERT INTO `gen_template_group` VALUES (1, 6); INSERT INTO `gen_template_group` VALUES (1, 7); INSERT INTO `gen_template_group` VALUES (1, 8); INSERT INTO `gen_template_group` VALUES (1, 9); INSERT INTO `gen_template_group` VALUES (1, 10); SET FOREIGN_KEY_CHECKS = 1;