店鋪網站設置相關 · Niushop單商戶V5開發手冊

```[sql] 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) NOT NULL DEFAULT '' COMMENT '廣告內容描述', adv_url varchar(255) NOT NULL DEFAULT '' COMMENT '廣告鏈接', adv_image varchar(255) 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) NOT NULL DEFAULT '#FFFFFF' COMMENT '背景色', PRIMARY KEY (adv_id) ) ENGINE = INNODB, CHARACTER SET utf8, COLLATE utf8_general_ci, COMMENT = '廣告表'; 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) NOT NULL DEFAULT '' COMMENT '廣告位置名', ap_intro varchar(255) 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) NOT NULL DEFAULT '', ap_background_color varchar(50) NOT NULL DEFAULT '#FFFFFF' COMMENT '廣告位背景色默認白色', type tinyint(4) NOT NULL DEFAULT 1 COMMENT '廣告位所在位置類型 1 pc端 2 手機端', keyword varchar(255) NOT NULL DEFAULT '' COMMENT '關鍵字', PRIMARY KEY (ap_id) ) ENGINE = INNODB, CHARACTER SET utf8, COLLATE utf8_general_ci, COMMENT = '廣告位表'; CREATE TABLE ns_help ( id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵id', app_module varchar(255) NOT NULL DEFAULT '' COMMENT '應用模塊', title varchar(255) NOT NULL DEFAULT '' COMMENT '幫助主題', link_address varchar(1000) NOT NULL DEFAULT '' COMMENT '鏈接地址', content text DEFAULT NULL COMMENT '幫助內容', class_id int(11) NOT NULL DEFAULT 0 COMMENT '幫助類型id', class_name varchar(50) NOT NULL DEFAULT '' COMMENT '幫助類型名稱', sort int(11) NOT NULL DEFAULT 0 COMMENT '排序號', create_time int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', modify_time int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', PRIMARY KEY (id) ) ENGINE = INNODB, CHARACTER SET utf8, COLLATE utf8_general_ci, COMMENT = '幫助文章表'; CREATE TABLE ns_help_class ( class_id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', app_module varchar(255) NOT NULL DEFAULT '' COMMENT '應用模塊', class_name varchar(50) NOT NULL DEFAULT '' COMMENT '幫助類型名稱', sort int(11) NOT NULL DEFAULT 0 COMMENT '排序號', create_time int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', modify_time int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', PRIMARY KEY (class_id) ) ENGINE = INNODB, CHARACTER SET utf8, COLLATE utf8_general_ci, COMMENT = '幫助類型'; -- ---------------------------- -- Table structure for ns_notice -- ---------------------------- DROP TABLE IF EXISTS `ns_notice`; CREATE TABLE `ns_notice` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', `site_id` int(10) NOT NULL DEFAULT 0 COMMENT '站點id', `title` 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 '內容', `is_top` int(11) NOT NULL DEFAULT 0 COMMENT '是否置頂', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', `receiving_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接受對象', `receiving_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接受對象名稱', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 43 AVG_ROW_LENGTH = 1024 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '公告' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_shop -- ---------------------------- DROP TABLE IF EXISTS `ns_shop`; CREATE TABLE `ns_shop` ( `site_id` int(11) NOT NULL, `shop_status` int(11) NOT NULL DEFAULT 1 COMMENT '店鋪經營狀態（0.關閉，1正常）', `close_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店鋪關閉原因', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序號', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '經營時間', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '關閉時間', `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店鋪頭像（大圖）', `banner` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店鋪條幅', `qq` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯系人qq', `ww` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯系人阿里旺旺', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯系人姓名', `telephone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯系電話', `mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯系手機號', `workingtime` int(11) NOT NULL DEFAULT 0 COMMENT '工作時間', `province` int(11) NOT NULL DEFAULT 0 COMMENT '省id', `province_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省名稱', `city` int(11) NOT NULL DEFAULT 0 COMMENT '城市id', `city_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '城市名稱', `district` int(11) NOT NULL DEFAULT 0 COMMENT '區縣id', `district_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '區縣地址', `community` int(11) NOT NULL DEFAULT 0 COMMENT '鄉鎮地址id', `community_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '鄉鎮地址名稱', `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '詳細地址', `full_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '完整地址', `longitude` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '經度', `latitude` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '緯度', `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `store_settlement_time` int(11) NOT NULL DEFAULT 0 COMMENT '門店最后結算時間', `work_week` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '工作日', PRIMARY KEY (`site_id`) USING BTREE ) ENGINE = InnoDB AVG_ROW_LENGTH = 512 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '店鋪表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_shop_address -- ---------------------------- DROP TABLE IF EXISTS `ns_shop_address`; CREATE TABLE `ns_shop_address` ( `id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0, `contact_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯系人', `mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯系人手機號', `postcode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '郵政編碼', `province_id` int(11) NOT NULL DEFAULT 0 COMMENT '省', `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '市', `district_id` int(11) NOT NULL DEFAULT 0 COMMENT '縣', `community_id` int(11) NOT NULL DEFAULT 0 COMMENT '鄉鎮', `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '詳細地址', `full_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收票地址', `is_return` tinyint(1) NOT NULL DEFAULT 0 COMMENT '退貨地址', `is_return_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是默認退貨地址', `is_delivery` tinyint(1) NOT NULL DEFAULT 0 COMMENT '發貨地址', `update_time` int(11) NOT NULL DEFAULT 0, 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_site -- ---------------------------- DROP TABLE IF EXISTS `ns_site`; CREATE TABLE `ns_site` ( `site_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '站點id', `site_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點類型', `site_domain` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點域名', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `site_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點名稱', `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點用戶', `logo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點logo', `seo_keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點關鍵字', `seo_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點描述', PRIMARY KEY (`site_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 AVG_ROW_LENGTH = 114 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '站點基礎表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_site_diy_view -- ---------------------------- DROP TABLE IF EXISTS `ns_site_diy_view`; CREATE TABLE `ns_site_diy_view` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `addon_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 '模板名稱', `value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置值', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'shop' COMMENT '應用模塊:shop、store', `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '圖標', `template_id` int(11) NOT NULL DEFAULT 0 COMMENT '模板id', PRIMARY KEY (`id`) USING BTREE, INDEX `IDX_nc_site_diy_view`(`site_id`, `name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 742 AVG_ROW_LENGTH = 1866 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '店鋪自定義模板表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_stat_shop -- ---------------------------- DROP TABLE IF EXISTS `ns_stat_shop`; CREATE TABLE `ns_stat_shop` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `year` int(11) NOT NULL DEFAULT 0 COMMENT '年', `month` int(11) NOT NULL DEFAULT 0 COMMENT '月', `day` int(11) NOT NULL DEFAULT 0 COMMENT '日', `day_time` int(11) NOT NULL DEFAULT 0 COMMENT '當日時間', `order_total` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '訂單金額', `shipping_total` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '運費金額', `refund_total` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '退款金額', `order_pay_count` int(11) NOT NULL DEFAULT 0 COMMENT '訂單總數', `goods_pay_count` int(11) NOT NULL DEFAULT 0 COMMENT '訂單商品總數', `shop_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '店鋪金額', `platform_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '平臺金額', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', `collect_shop` int(11) NOT NULL DEFAULT 0 COMMENT '店鋪收藏量', `collect_goods` int(11) NOT NULL DEFAULT 0 COMMENT '商品收藏量', `visit_count` int(11) NOT NULL DEFAULT 0 COMMENT '瀏覽量', `order_count` int(11) NOT NULL DEFAULT 0 COMMENT '訂單量（總）', `goods_count` int(11) NOT NULL DEFAULT 0 COMMENT '訂單商品量（總）', `add_goods_count` int(11) NOT NULL DEFAULT 0 COMMENT '添加商品數', `member_count` int(11) NOT NULL DEFAULT 0 COMMENT '會員統計', PRIMARY KEY (`id`) USING BTREE, INDEX `IDX_ns_stat_shop_day`(`day`) USING BTREE, INDEX `IDX_ns_stat_shop_day_time`(`day_time`) USING BTREE, INDEX `IDX_ns_stat_shop_month`(`month`) USING BTREE, INDEX `IDX_ns_stat_shop_site_id`(`site_id`) USING BTREE, INDEX `IDX_ns_stat_shop_year`(`year`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 AVG_ROW_LENGTH = 154 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; ```