CREATE TABLE `promotion_diy_template` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '装修模板编号',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板名称',
`used` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否使用',
`property` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '模板属性,JSON 格式',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='装修模板';
CREATE TABLE `promotion_diy_page` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '装修页面编号',
`template_id` bigint DEFAULT NULL COMMENT '装修模板编号',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '页面名称',
`property` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '页面属性,JSON 格式',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='装修页面';