系統基礎表 · Niushop單商戶V5開發手冊

```[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; ```