ps_home_block.sql 879 B

12345678910111213141516
  1. CREATE TABLE IF NOT EXISTS `fa_ps_home_block` (
  2. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  3. `type` varchar(20) NOT NULL DEFAULT 'custom' COMMENT 'hero/stats/steps/features/cta/custom',
  4. `name` varchar(64) NOT NULL DEFAULT '' COMMENT '后台备注名',
  5. `kicker` varchar(64) NOT NULL DEFAULT '' COMMENT '小标题',
  6. `title` varchar(120) NOT NULL DEFAULT '' COMMENT '主标题',
  7. `subtitle` varchar(255) NOT NULL DEFAULT '' COMMENT '说明',
  8. `content` text COMMENT '模块内容 JSON',
  9. `weigh` int(11) NOT NULL DEFAULT '0' COMMENT '越大越靠前',
  10. `status` enum('normal','hidden') NOT NULL DEFAULT 'normal',
  11. `createtime` bigint(16) DEFAULT NULL,
  12. `updatetime` bigint(16) DEFAULT NULL,
  13. PRIMARY KEY (`id`),
  14. KEY `weigh` (`weigh`),
  15. KEY `status` (`status`)
  16. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='工厂端首页模块';