From 47dd1ecaf0aafa66b9c39fff9c91abc1c611b02c Mon Sep 17 00:00:00 2001 From: liu <2021943741@qq.com> Date: 星期二, 27 十月 2026 17:59:46 +0800 Subject: [PATCH] feat(wxcp): 通知支持图片/视频/Markdown/多图文模板与成员预览 --- docs/sql/wxcp_module.sql | 25 ++++++++++++++++++++++++- 1 files changed, 24 insertions(+), 1 deletions(-) diff --git a/docs/sql/wxcp_module.sql b/docs/sql/wxcp_module.sql index b27c5da..765338f 100644 --- a/docs/sql/wxcp_module.sql +++ b/docs/sql/wxcp_module.sql @@ -8,6 +8,8 @@ -- 娲诲姩灏侀潰 record_type = 'wxcp_activity'锛屾椿鍔ㄨ鎯呭浘鐗� record_type = 'wxcp_activity_detail'锛� -- 鍥剧墖閫氱煡 record_type = 'wxcp_activity_image'锛岄檮浠堕�氱煡 record_type = 'wxcp_activity_file'锛� -- 鎶ュ悕闄勪欢 record_type = 'wxcp_activity_signup' +-- 閫氱煡妯″潡鐨勭礌鏉愬悓鐞嗭細record_type = 'wxcp_notice_image' / 'wxcp_notice_file' / +-- 'wxcp_notice_video' / 'wxcp_notice_article_cover' -- ============================================================ -- ---------------------------- @@ -80,7 +82,7 @@ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', `title` varchar(128) NOT NULL COMMENT '閫氱煡鏍囬', `content` text COMMENT '閫氱煡姝ｆ枃', - `notice_type` tinyint NOT NULL DEFAULT 1 COMMENT '閫氱煡妯℃澘锛�1绾枃鏈� 2鍥炬枃鍗＄墖(濉姤/閾炬帴) 3鏂囦欢閫氱煡 4鍥炬枃娑堟伅', + `notice_type` tinyint NOT NULL DEFAULT 1 COMMENT '閫氱煡妯℃澘锛�1绾枃鏈� 2鍥炬枃鍗＄墖(濉姤/閾炬帴) 3鏂囦欢閫氱煡 4鍥炬枃娑堟伅 5鍥剧墖閫氱煡 6瑙嗛閫氱煡 7Markdown 8澶氬浘鏂囨秷鎭�', `summary` varchar(512) DEFAULT NULL COMMENT '鎽樿锛堝浘鏂囧崱鐗�/鍥炬枃娑堟伅锛�', `link_url` varchar(1024) DEFAULT NULL COMMENT '璺宠浆閾炬帴锛堝～鎶�/璇︽儏锛�', `link_btn_text` varchar(32) DEFAULT NULL COMMENT '閾炬帴鎸夐挳鏂囨', @@ -102,6 +104,27 @@ KEY `idx_status` (`status`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = '浼佷笟寰俊閫氱煡'; +-- ---------------------------- +-- 閫氱煡 - 澶氬浘鏂囨秷鎭潯鐩� +-- 浠呫�屽鍥炬枃娑堟伅銆嶆ā鏉夸娇鐢紱灏侀潰鍥惧彧瀛� blob_id锛屽湴鍧�璧伴檮浠朵腑闂磋〃 +-- ---------------------------- +CREATE TABLE IF NOT EXISTS `wxcp_notice_article` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `notice_id` bigint NOT NULL COMMENT '閫氱煡缂栧彿', + `title` varchar(128) NOT NULL COMMENT '鍥炬枃鏍囬', + `description` varchar(512) DEFAULT NULL COMMENT '鍥炬枃鎽樿', + `link_url` varchar(1024) NOT NULL COMMENT '鐐瑰嚮璺宠浆閾炬帴', + `cover_blob_id` bigint DEFAULT NULL COMMENT '灏侀潰鍥� Blob ID', + `sort_no` int NOT NULL DEFAULT 0 COMMENT '鎺掑簭鍙�', + `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`), + KEY `idx_notice_id` (`notice_id`) +) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = '浼佷笟寰俊閫氱煡澶氬浘鏂囨秷鎭潯鐩�'; + -- ============================================================ -- 鍗囩骇鑴氭湰锛氬皝闈㈠浘浠庛�屼笟鍔¤〃瀛樺湴鍧�銆嶆敼涓恒�岄檮浠朵腑闂磋〃銆� -- 宸插缓杩囧簱鐨勭幆澧冩墽琛屼竴娆″嵆鍙紱鏂板簱鎵ц涓婇潰鐨� CREATE TABLE 宸叉槸鏈�鏂扮粨鏋勶紝鏃犻渶鎵ц -- Gitblit v1.9.3