```[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層命名規范
- 前端(管理頁面)命名
- 控制器命名規范
- 入門指導
- 偽靜態配置
- 數據庫配置
- 系統環境
- 系統框架
- 目錄結構
- 數據庫操作
- 標準代碼(前端)
- 提示面板
- 表單
- 插件開發
- 插件目錄
- 插件開發說明
- 事件開發
- 常用事件
- 數據字典
- 系統基礎表
- 微信小程序相關
- 微信公眾號相關
- 配送相關表
- 商品相關表
- 店鋪網站設置相關
- 門店相關表
- 會員相關表
- 訂單相關表
- 營銷(組合套餐)
- 營銷(砍價)
- 營銷(優惠券)
- 營銷(限時折扣)
- 營銷(滿額包郵)
- 營銷(互動游戲)
- 營銷(團購)
- 營銷(滿減送)
- 營銷(拼團)
- 營銷(秒殺)
- 營銷(專題)
- 應用(分銷)
- 應用(店鋪筆記)
- 應用(小票打印)
- 應用(積分兌換)