From 91491239c5d4611b5b1404a7abeb2bb23d0edad5 Mon Sep 17 00:00:00 2001 From: liu <2021943741@qq.com> Date: 星期三, 30 九月 2026 14:26:59 +0800 Subject: [PATCH] feat(wxcp): 活动封面改用附件中间表，报名姓名手机号改为选填 --- docs/sql/wxcp_module.sql | 20 +++++++++++++++++--- 1 files changed, 17 insertions(+), 3 deletions(-) diff --git a/docs/sql/wxcp_module.sql b/docs/sql/wxcp_module.sql index a95f076..8f2a542 100644 --- a/docs/sql/wxcp_module.sql +++ b/docs/sql/wxcp_module.sql @@ -3,8 +3,9 @@ -- 鐩爣搴擄細mom-jssm锛�36.213.150.237:10000锛� -- 璇存槑锛氶」鐩笉浣跨敤澶氱鎴凤紝鍥犳涓嶅惈 tenant_id 瀛楁 -- --- 鎶ュ悕鎻愪氦鐨勫浘鐗�/闄勪欢涓嶈惤鏈ā鍧楃殑琛細 --- 缁熶竴璧� system_storage_attachment 涓棿琛紝record_type = 'wxcp_activity_signup' +-- 娲诲姩灏侀潰銆佹姤鍚嶆彁浜ょ殑鍥剧墖/闄勪欢閮戒笉钀芥湰妯″潡鐨勮〃锛� +-- 缁熶竴璧� system_storage_attachment 涓棿琛紝 +-- 娲诲姩灏侀潰 record_type = 'wxcp_activity'锛屾姤鍚嶉檮浠� record_type = 'wxcp_activity_signup' -- ============================================================ -- ---------------------------- @@ -14,7 +15,6 @@ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', `title` varchar(128) NOT NULL COMMENT '娲诲姩鏍囬', `content` text COMMENT '娲诲姩璇︽儏', - `cover_url` varchar(512) DEFAULT '' COMMENT '灏侀潰鍥惧湴鍧�', `location` varchar(255) DEFAULT '' COMMENT '娲诲姩鍦扮偣', `start_time` datetime DEFAULT NULL COMMENT '娲诲姩寮�濮嬫椂闂�', `end_time` datetime DEFAULT NULL COMMENT '娲诲姩缁撴潫鏃堕棿', @@ -86,3 +86,17 @@ PRIMARY KEY (`id`), KEY `idx_status` (`status`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = '浼佷笟寰俊閫氱煡'; + +-- ============================================================ +-- 鍗囩骇鑴氭湰锛氬皝闈㈠浘浠庛�屼笟鍔¤〃瀛樺湴鍧�銆嶆敼涓恒�岄檮浠朵腑闂磋〃銆� +-- 宸插缓杩囧簱鐨勭幆澧冩墽琛屼竴娆″嵆鍙紱鏂板簱鎵ц涓婇潰鐨� CREATE TABLE 宸叉槸鏈�鏂扮粨鏋勶紝鏃犻渶鎵ц +-- MySQL 鐨� ADD/DROP COLUMN 涓嶆敮鎸� IF NOT EXISTS锛岃繖閲屽厛鍒ゆ柇鍐嶆墽琛� +-- ============================================================ +SET @exists = (SELECT COUNT(*) FROM information_schema.columns + WHERE table_schema = DATABASE() AND table_name = 'wxcp_activity' AND column_name = 'cover_url'); +SET @sql = IF(@exists > 0, + 'ALTER TABLE `wxcp_activity` DROP COLUMN `cover_url`', + 'SELECT 1'); +PREPARE stmt FROM @sql; +EXECUTE stmt; +DEALLOCATE PREPARE stmt; -- Gitblit v1.9.3