```[sql] -- ---------------------------- -- Table structure for ns_notes -- ---------------------------- DROP TABLE IF EXISTS `ns_notes`; CREATE TABLE `ns_notes` ( `note_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id', `note_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '笔记类型', `note_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标题', `note_abstract` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '摘要', `group_id` int(11) NOT NULL DEFAULT 0 COMMENT '分组id', `cover_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '封面图片类型（0单图 1多图）', `cover_img` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '封面图片', `goods_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品id（根据类型判断商品是单个还是多个）', `goods_highlights` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品亮点（单品有效）', `note_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容', `status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '状态（0草稿箱 1发布）', `is_show_release_time` tinyint(1) NOT NULL DEFAULT 0 COMMENT '发布时间是否显示', `is_show_read_num` tinyint(1) NOT NULL DEFAULT 0 COMMENT '阅读数是否显示', `is_show_dianzan_num` tinyint(1) NOT NULL COMMENT '点赞数是否显示', `read_num` int(11) NOT NULL DEFAULT 0 COMMENT '阅读数', `dianzan_num` int(11) NOT NULL DEFAULT 0 COMMENT '点赞数', `create_time` int(11) NULL DEFAULT 0, `update_time` int(11) NOT NULL DEFAULT 0, `initial_read_num` int(11) NOT NULL DEFAULT 0 COMMENT '初始阅读数', `initial_dianzan_num` int(11) NOT NULL DEFAULT 0 COMMENT '初始点赞数', PRIMARY KEY (`note_id`) USING BTREE, INDEX `IDX_ns_promotion_notes_group_id`(`group_id`) USING BTREE, INDEX `IDX_ns_promotion_notes_site_id`(`site_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_notes_dianzan_record -- ---------------------------- DROP TABLE IF EXISTS `ns_notes_dianzan_record`; CREATE TABLE `ns_notes_dianzan_record` ( `record_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `note_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '分组名称', PRIMARY KEY (`record_id`) USING BTREE, INDEX `IDX_ns_notes_dianzan_record_member_id`(`member_id`) USING BTREE, INDEX `IDX_ns_notes_dianzan_record_note_id`(`note_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 5461 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '笔记点赞记录' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_notes_group -- ---------------------------- DROP TABLE IF EXISTS `ns_notes_group`; CREATE TABLE `ns_notes_group` ( `group_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id', `group_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分组名称', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `notes_num` int(11) NOT NULL DEFAULT 0 COMMENT '笔记数', `release_num` int(11) NOT NULL DEFAULT 0 COMMENT '发布数', `create_time` int(11) NOT NULL DEFAULT 0, `update_time` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`group_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2730 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '笔记分组' ROW_FORMAT = Compact;