fastadmin_materials_official/culture_tables.sql

-- 企业文化卡片表
CREATE TABLE IF NOT EXISTS `__PREFIX__wwh_culture_card` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `title` varchar(100) NOT NULL COMMENT '卡片标题',
  `subtitle` varchar(100) DEFAULT NULL COMMENT '英文副标题',
  `image` varchar(255) DEFAULT NULL COMMENT '卡片图片',
  `card_type` enum('normal','reverse') NOT NULL DEFAULT 'normal' COMMENT '卡片类型:normal=图片在上,reverse=内容在上',
  `list_type` enum('single','double') NOT NULL DEFAULT 'single' COMMENT '列表类型:single=单列,double=双列',
  `content_items` text COMMENT '内容项目(JSON格式存储)',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '排序权重',
  `status` enum('0','1') NOT NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `lang` enum('1','2') DEFAULT '1' COMMENT '语言:1=简体中文,2=English',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='企业文化卡片表';

-- 企业文化横幅表
CREATE TABLE IF NOT EXISTS `__PREFIX__wwh_culture_banner` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `title` varchar(100) NOT NULL COMMENT '横幅标题',
  `subtitle` varchar(100) DEFAULT NULL COMMENT '英文副标题',
  `image` varchar(255) DEFAULT NULL COMMENT '背景图片',
  `content_type` enum('text','grid_single','grid_double') NOT NULL DEFAULT 'text' COMMENT '内容类型:text=纯文本,grid_single=单列网格,grid_double=双列网格',
  `content_data` text COMMENT '内容数据(JSON格式存储)',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '排序权重',
  `status` enum('0','1') NOT NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `lang` enum('1','2') DEFAULT '1' COMMENT '语言:1=简体中文,2=English',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='企业文化横幅表';

-- 插入示例数据 - 卡片
INSERT INTO `__PREFIX__wwh_culture_card` (`title`, `subtitle`, `image`, `card_type`, `list_type`, `content_items`, `weigh`, `status`, `createtime`, `updatetime`, `lang`) VALUES
('核心理念', 'CORE IDEOLOGY', '/assets/addons/material/images/culture/88.png', 'normal', 'single', '["善用资源","服务建设"]', 90, '1', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), '1'),
('核心价值观', 'CORE VALUE', '/assets/addons/material/images/culture/image.png', 'reverse', 'double', '["创新","和谐","绩效","责任"]', 80, '1', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), '1'),
('文化理念', 'CULTURE IDEA', '/assets/addons/material/images/culture/1.png', 'normal', 'single', '["企业愿人","企业育人","企业为人","让员工与企业共同成长"]', 70, '1', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), '1'),
('四型企业', 'FOUR-TYPE ENTERPRISE', '/assets/addons/material/images/culture/2.png', 'reverse', 'single', '["创新驱动型","质量效益型","制造服务型","社会责任型"]', 60, '1', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), '1'),
('五有干部', 'FIVE CADRES', '/assets/addons/material/images/culture/3.png', 'reverse', 'double', '["有学习能力","有市场意识","有专业水平","有敬业精神","有思想境界"]', 50, '1', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), '1'),
('六星企业', 'SIX-STAR ENTERPRISE', '/assets/addons/material/images/culture/4.png', 'normal', 'double', '["业绩良好","管理精细","品牌知名","先进高效"]', 40, '1', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), '1'),
('企业愿景', 'CORPORATE VISION', '/assets/addons/material/images/culture/5.png', 'reverse', 'single', '["全球优秀的混凝土专业服务商"]', 30, '1', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), '1'),
('安全理念', 'SAFETY CONCEPT', '/assets/addons/material/images/culture/6.png', 'normal', 'single', '["敬畏生命","健康为本"]', 20, '1', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), '1');

-- 插入示例数据 - 横幅
INSERT INTO `__PREFIX__wwh_culture_banner` (`title`, `subtitle`, `image`, `content_type`, `content_data`, `weigh`, `status`, `createtime`, `updatetime`, `lang`) VALUES
('广告语', 'FIVE CADRES', '/assets/addons/material/images/culture/515.png', 'text', '{"text":"我们生产凝聚力"}', 30, '1', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), '1'),
('行为准则', 'FIVE CADRES', '/assets/addons/material/images/culture/15.png', 'grid_double', '{"items":["敬畏","感恩","谦虚","得体"]}', 20, '1', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), '1'),
('三宽三力', 'FIVE CADRES', '/assets/addons/material/images/culture/51.png', 'grid_double', '{"items":["待人宽厚","处事宽容","环境宽松","向心力","亲和力","凝聚力"]}', 10, '1', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), '1');