```[sql]
-- ----------------------------
-- Table structure for ns_addon
-- ----------------------------
DROP TABLE IF EXISTS `ns_addon`;
CREATE TABLE `ns_addon` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '插件名称或者标识',
`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '插件类型',
`icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '插件图标',
`title` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '中文名',
`description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '插件描述',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态',
`author` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '作者',
`version` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '版本号',
`version_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '版本编号',
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '详情',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '安装时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `UK_nc_addons_name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 238 AVG_ROW_LENGTH = 630 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '插件表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_adv
-- ----------------------------
DROP TABLE IF EXISTS `ns_adv`;
CREATE TABLE `ns_adv` (
`adv_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id',
`ap_id` int(11) NOT NULL DEFAULT 0 COMMENT '广告位id',
`adv_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '广告内容描述',
`adv_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '广告链接',
`adv_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '广告内容图片',
`slide_sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序号',
`price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '广告价格/月',
`background` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '#FFFFFF' COMMENT '背景色',
PRIMARY KEY (`adv_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1638 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '广告表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_adv_position
-- ----------------------------
DROP TABLE IF EXISTS `ns_adv_position`;
CREATE TABLE `ns_adv_position` (
`ap_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '广告位置id',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id',
`ap_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '广告位置名',
`ap_intro` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '广告位简介',
`ap_height` int(10) NOT NULL DEFAULT 0 COMMENT '广告位高度',
`ap_width` int(10) NOT NULL DEFAULT 0 COMMENT '广告位宽度',
`default_content` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`ap_background_color` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '#FFFFFF' COMMENT '广告位背景色 默认白色',
`type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '广告位所在位置类型 1 pc端 2 手机端',
`keyword` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '关键字',
PRIMARY KEY (`ap_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2730 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '广告位表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_area
-- ----------------------------
DROP TABLE IF EXISTS `ns_area`;
CREATE TABLE `ns_area` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`pid` int(11) NOT NULL DEFAULT 0 COMMENT '父级',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称',
`shortname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '简称',
`longitude` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '经度',
`latitude` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '纬度',
`level` smallint(6) NOT NULL DEFAULT 0 COMMENT '级别',
`sort` mediumint(9) NOT NULL DEFAULT 0 COMMENT '排序',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态1有效',
PRIMARY KEY (`id`) USING BTREE,
INDEX `IDX_nc_area`(`name`, `shortname`) USING BTREE,
INDEX `level`(`level`, `sort`, `status`) USING BTREE,
INDEX `longitude`(`longitude`, `latitude`) USING BTREE,
INDEX `pid`(`pid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 659004503 AVG_ROW_LENGTH = 574 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '地址表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_config
-- ----------------------------
DROP TABLE IF EXISTS `ns_config`;
CREATE TABLE `ns_config` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id（店铺，分站）,总平台端为0',
`app_module` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '应用端口关键字',
`config_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置项关键字',
`value` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置值json',
`config_desc` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述',
`is_use` tinyint(4) NOT NULL DEFAULT 1 COMMENT '是否启用 1启用 0不启用',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
`modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `IDX_sys_config_site_id`(`site_id`, `app_module`, `config_key`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 675 AVG_ROW_LENGTH = 988 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统配置表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_cron
-- ----------------------------
DROP TABLE IF EXISTS `ns_cron`;
CREATE TABLE `ns_cron` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`type` int(11) NOT NULL DEFAULT 1 COMMENT '1.固定任务 2.循环任务',
`period` int(11) NOT NULL DEFAULT 0 COMMENT '循环周期（分钟）',
`period_type` int(11) NOT NULL DEFAULT 0 COMMENT '循环周期类型 0默认分钟 1.月 2.周 3. 日',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '任务名称',
`event` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '执行事件',
`execute_time` int(11) NOT NULL DEFAULT 0 COMMENT '待执行时间',
`relate_id` int(11) NOT NULL DEFAULT 0 COMMENT '关联关键字id',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `IDX_sys_cron_execute_time`(`execute_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6324 AVG_ROW_LENGTH = 212 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '计划任务表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_cron_log
-- ----------------------------
DROP TABLE IF EXISTS `ns_cron_log`;
CREATE TABLE `ns_cron_log` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '任务名称',
`event` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '任务事件',
`execute_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '执行时间',
`relate_id` int(11) NOT NULL DEFAULT 0 COMMENT '关联id',
`is_success` int(11) NOT NULL DEFAULT 1 COMMENT '是否成功',
`message` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '返回结果',
PRIMARY KEY (`id`) USING BTREE,
INDEX `IDX_nc_cron_execute_list_execute_time`(`execute_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 80 AVG_ROW_LENGTH = 135 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '事件执行记录' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_div_template
-- ----------------------------
DROP TABLE IF EXISTS `ns_div_template`;
CREATE TABLE `ns_div_template` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板名称',
`desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述',
`mark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板标识',
`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类型 DIYVIEW_INDEX：主页',
`value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板数据',
`image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板图片',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 AVG_ROW_LENGTH = 397312 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_diy_view_util
-- ----------------------------
DROP TABLE IF EXISTS `ns_diy_view_util`;
CREATE TABLE `ns_diy_view_util` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标识',
`title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '组件名称',
`type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'SYSTEM' COMMENT '组件类型，SYSTEM 系统组件，ADDON 营销组件，OTHER 其他组件',
`controller` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '组件控制器名称',
`value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置:json格式',
`addon_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '插件标识',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序号',
`support_diy_view` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支持的自定义页面（为空表示公共组件都支持）',
`max_count` int(11) NOT NULL DEFAULT 0 COMMENT '限制添加次数',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name`(`name`) USING BTREE,
INDEX `IDX_nc_diy_view_util_controller`(`controller`) USING BTREE,
INDEX `IDX_nc_diy_view_util_sort`(`sort`) USING BTREE,
INDEX `IDX_nc_diy_view_util_type`(`type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4560 AVG_ROW_LENGTH = 630 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '自定义模板组件' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_document
-- ----------------------------
DROP TABLE IF EXISTS `ns_document`;
CREATE TABLE `ns_document` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id（店铺，分站）,总平台端为0',
`app_module` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '应用模块',
`document_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '关键字',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文本关键字',
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '文本内容',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
`modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 257 AVG_ROW_LENGTH = 4096 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统配置性相关文件' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_group
-- ----------------------------
DROP TABLE IF EXISTS `ns_group`;
CREATE TABLE `ns_group` (
`group_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id（店铺，分站,门店，供应商）,总平台端为0',
`app_module` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '使用端口',
`group_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户组名称',
`group_status` int(11) NOT NULL DEFAULT 1 COMMENT '用户组状态',
`is_system` int(1) NOT NULL DEFAULT 0 COMMENT '是否是系统用户组',
`menu_array` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '系统菜单权限组，用，隔开',
`desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
`modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
PRIMARY KEY (`group_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 571 AVG_ROW_LENGTH = 334 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户组表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_link
-- ----------------------------
DROP TABLE IF EXISTS `ns_link`;
CREATE TABLE `ns_link` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`addon_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标识',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '中文名称',
`parent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '父级',
`sort` int(11) NOT NULL COMMENT '排序',
`level` int(11) NOT NULL DEFAULT 0 COMMENT '级别',
`web_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'pc端页面跳转路径',
`wap_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'wap端跳转路径',
`icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图标',
`support_diy_view` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支持的自定义页面（为空表示公共组件都支持）',
PRIMARY KEY (`id`) USING BTREE,
INDEX `IDX_nc_link`(`addon_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3547 AVG_ROW_LENGTH = 780 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '链接入口' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_menu
-- ----------------------------
DROP TABLE IF EXISTS `ns_menu`;
CREATE TABLE `ns_menu` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
`app_module` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'admin' COMMENT '应用模块',
`addon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '所属插件',
`title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '菜单标题',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '菜单关键字',
`parent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上级菜单',
`level` int(11) NOT NULL DEFAULT 1 COMMENT '深度等级',
`url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '链接地址',
`is_show` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否展示',
`sort` int(10) NOT NULL DEFAULT 0 COMMENT '排序（同级有效）',
`desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述',
`is_icon` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是矢量菜单图',
`picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图片(矢量图)',
`picture_select` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图片(矢量图)(选中)',
`is_control` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否控制权限',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 119035 AVG_ROW_LENGTH = 225 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_message
-- ----------------------------
DROP TABLE IF EXISTS `ns_message`;
CREATE TABLE `ns_message` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id',
`keywords` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '关键字',
`sms_is_open` tinyint(1) NOT NULL DEFAULT 0 COMMENT '短信消息是否启动',
`wechat_is_open` int(11) NOT NULL DEFAULT 0 COMMENT '微信公众号消息',
`wechat_template_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信公众号ID',
`weapp_is_open` int(11) NOT NULL DEFAULT 0 COMMENT '微信小程序是否启动',
`weapp_json` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信小程序配置参数',
`aliapp_is_open` int(11) NOT NULL DEFAULT 0 COMMENT '支付宝小程序是否启动',
`aliapp_json` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付宝小程序配置参数',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 84 AVG_ROW_LENGTH = 910 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息管理' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_message_email_records
-- ----------------------------
DROP TABLE IF EXISTS `ns_message_email_records`;
CREATE TABLE `ns_message_email_records` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id',
`account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接收者账号',
`status` int(11) NOT NULL DEFAULT 0 COMMENT '发送状态',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标题',
`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '内容',
`keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '消息类型关键字',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
`send_time` int(11) NOT NULL DEFAULT 0 COMMENT '发送时间',
`result` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '发送结果',
`keywords_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '关键字名称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 398 AVG_ROW_LENGTH = 323 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '邮箱信息发送记录' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_message_send_log
-- ----------------------------
DROP TABLE IF EXISTS `ns_message_send_log`;
CREATE TABLE `ns_message_send_log` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id',
`keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '关键字',
`message_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '消息类型',
`addon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '执行插件',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主题',
`message_json` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '消息内容json',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
`send_time` int(11) NOT NULL DEFAULT 0 COMMENT '发送时间',
`send_log` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '发送结果',
`is_success` int(11) NOT NULL DEFAULT 0 COMMENT '是否发送成功',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息发送日志' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_message_sms_records
-- ----------------------------
DROP TABLE IF EXISTS `ns_message_sms_records`;
CREATE TABLE `ns_message_sms_records` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id',
`account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接收人账号',
`keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '消息类型关键字',
`status` int(11) NOT NULL DEFAULT 0 COMMENT '发送状态',
`result` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '结果',
`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '短信内容',
`var_parse` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '短信内容变量解析 json',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
`send_time` int(11) NOT NULL DEFAULT 0 COMMENT '发送时间',
`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板编号',
`addon` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '发送插件',
`addon_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '发送方式名称',
`keywords_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '关键字名称',
`site_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站点名称',
`sys_uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 854 AVG_ROW_LENGTH = 355 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '短信消息发送记录' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_message_template
-- ----------------------------
DROP TABLE IF EXISTS `ns_message_template`;
CREATE TABLE `ns_message_template` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`addon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '插件',
`keywords` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '关键字',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主题',
`message_type` int(11) NOT NULL DEFAULT 1 COMMENT '消息类型 1 买家消息 2 卖家消息',
`message_json` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置参数',
`sms_addon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '发送短信插件',
`sms_json` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '短信配置参数',
`sms_content` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '短信内容',
`wechat_json` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置参数',
`weapp_json` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信小程序配置参数',
`aliapp_json` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付宝小程序配置参数',
`support_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支持场景 如小程序 wep端',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 AVG_ROW_LENGTH = 862 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息管理' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_message_variable
-- ----------------------------
DROP TABLE IF EXISTS `ns_message_variable`;
CREATE TABLE `ns_message_variable` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '变量名',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '变量',
`support_message_array` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支持消息',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 AVG_ROW_LENGTH = 5461 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息模板变量' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_message_wechat_records
-- ----------------------------
DROP TABLE IF EXISTS `ns_message_wechat_records`;
CREATE TABLE `ns_message_wechat_records` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id',
`open_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接收者账号',
`status` int(11) NOT NULL DEFAULT 0 COMMENT '发送状态',
`keyword_json` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板消息字段',
`keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '消息类型关键字',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
`send_time` int(11) NOT NULL DEFAULT 0 COMMENT '发送时间',
`result` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '发送结果',
`url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '发送模板消息携带链接',
`keywords_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '关键字名称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信公众号消息发送记录' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_sys_upgrade_log
-- ----------------------------
DROP TABLE IF EXISTS `ns_sys_upgrade_log`;
CREATE TABLE `ns_sys_upgrade_log` (
`log_id` int(11) NOT NULL AUTO_INCREMENT,
`upgrade_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '升级编号 每次的编号都不同',
`upgrade_time` int(11) NOT NULL DEFAULT 0 COMMENT '升级时间 记录开始时间',
`version_info` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '版本信息 json数据 包含升级前和升级后的基本信息',
`backup_root` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备份文件和sql的根目录',
`download_root` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '下载文件的根目录',
`status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '升级状态 0 进行中 1 升级成功 2 升级失败',
`error_message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '升级失败错误信息',
PRIMARY KEY (`log_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统升级日志' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_user
-- ----------------------------
DROP TABLE IF EXISTS `ns_user`;
CREATE TABLE `ns_user` (
`uid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`sys_uid` int(11) NOT NULL DEFAULT 0 COMMENT '系统用户id',
`app_module` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '应用模块',
`app_group` int(11) NOT NULL DEFAULT 0 COMMENT '应用所属组',
`is_admin` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否是管理员',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id',
`group_id` int(11) NOT NULL DEFAULT 0 COMMENT '权限id',
`group_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '权限组',
`username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '账号',
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '密码',
`member_id` int(11) NOT NULL DEFAULT 0 COMMENT '会员id',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) NOT NULL DEFAULT 0,
`status` int(11) NOT NULL DEFAULT 1 COMMENT '状态 1 正常',
`login_time` int(11) NOT NULL DEFAULT 0 COMMENT '最新一次登陆时间',
`login_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '最新登录ip',
PRIMARY KEY (`uid`) USING BTREE,
INDEX `IDX_ns_user`(`group_id`, `app_module`) USING BTREE,
INDEX `IDX_ns_user_member_id`(`member_id`) USING BTREE,
INDEX `IDX_ns_user_site_id`(`site_id`) USING BTREE,
INDEX `IDX_ns_user_username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 682 AVG_ROW_LENGTH = 228 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '站点后台用户表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_user_log
-- ----------------------------
DROP TABLE IF EXISTS `ns_user_log`;
CREATE TABLE `ns_user_log` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`uid` int(11) NOT NULL DEFAULT 0 COMMENT '操作用户ID',
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '昵称',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id',
`url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '对应url',
`data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '传输数据',
`ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'ip地址',
`action_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作行为',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `IDX_ns_user_log`(`uid`, `site_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9874 AVG_ROW_LENGTH = 120 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户操作日志' ROW_FORMAT = Compact;
```
- 序言
- 商城简介
- 代码规范
- model层命名规范
- 前端（管理页面）命名
- 控制器命名规范
- 入门指导
- 伪静态配置
- 数据库配置
- 系统环境
- 系统框架
- 目录结构
- 数据库操作
- 标准代码(前端)
- 提示面板
- 表单
- 插件开发
- 插件目录
- 插件开发说明
- 事件开发
- 常用事件
- 数据字典
- 系统基础表
- 微信小程序相关
- 微信公众号相关
- 配送相关表
- 商品相关表
- 店铺网站设置相关
- 门店相关表
- 会员相关表
- 订单相关表
- 营销（组合套餐）
- 营销（砍价）
- 营销（优惠券）
- 营销（限时折扣）
- 营销（满额包邮）
- 营销（互动游戏）
- 营销（团购）
- 营销（满减送）
- 营销（拼团）
- 营销（秒杀）
- 营销（专题）
- 应用（分销）
- 应用（店铺笔记）
- 应用（小票打印）
- 应用（积分兑换）