Startseite Erkunden Hilfe
Anmelden
tea
/
kxmall-main
1
0
Fork 0
Dateien Issues 0 Pull-Requests 0 Wiki
Struktur: 24cf606d27
Branches Tags
kxmall-main
/
doc
/
sql
/
increment
/
20231115kxmall3.sql

20231115kxmall3.sql 6.2 KB
Verlauf Originalformat

1234567891011121314151617 
  1. DROP TABLE IF EXISTS `kx_page_template`;
    2. 

  2. CREATE TABLE `kx_page_template`  (
    3. 

  3.                                      `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    4. 

  4.                                      `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0停用1启用',
    5. 

  5.                                      `content` json NULL COMMENT '首页json格式',
    6. 

  6.                                      `create_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
    7. 

  7.                                      `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
    8. 

  8.                                      `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    9. 

  9.                                      `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    10. 

  10.                                      PRIMARY KEY (`id`) USING BTREE
    11. 

  11. ) ENGINE = InnoDB AUTO_INCREMENT = 1724267729304731650 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '首页页面模板' ROW_FORMAT = Dynamic;
    12. 

  12. 

  13. -- ----------------------------
    14. 

  14. -- Records of kx_page_template
    15. 

  15. -- ----------------------------
    16. 

  16. INSERT INTO `kx_page_template` VALUES (1724267672903925762, 0, '{\"moduleList\": [{\"id\": \"navigation\", \"_uid\": \"navigation_igj0d52p0e00\", \"limit\": 1, \"style\": {\"backgroundPosition\": \"-10px -345px\", \"hoverBackgroundPosition\": \"-50px -345px\"}, \"title\": \"图文导航\", \"options\": {\"banner\": {\"imgStyle\": \"100% 100%\", \"showStyle\": \"12px 12px 0px\"}, \"bgColor\": \"#FFFFFF\", \"fontColor\": \"#FF2200\", \"iconStyle\": \"50%\", \"showStyle\": \"0px\"}, \"selectable\": true}, {\"id\": \"announcement\", \"_uid\": \"announcement_ia7pgolmmkk0\", \"limit\": 1, \"style\": {\"backgroundPosition\": \"-90px -345px\", \"hoverBackgroundPosition\": \"-130px -345px\"}, \"title\": \"通知公告\", \"options\": {}, \"selectable\": true}, {\"id\": \"special\", \"_uid\": \"special_jb9bq9lo5vg0\", \"limit\": 1, \"style\": {\"backgroundPosition\": \"-250px -345px\", \"hoverBackgroundPosition\": \"-290px -345px\"}, \"title\": \"今日特价\", \"options\": {\"banner\": {\"show\": true, \"imgUrl\": \"\", \"imgStyle\": \"cover\", \"showStyle\": \"0px\"}, \"scroll\": false}, \"selectable\": true}, {\"id\": \"recommend\", \"_uid\": \"recommend_p2haoj8p4000\", \"limit\": 1, \"style\": {\"backgroundPosition\": \"-10px -384px\", \"hoverBackgroundPosition\": \"-50px -384px\"}, \"title\": \"热卖推荐\", \"options\": {\"banner\": {\"show\": true, \"imgUrl\": \"\", \"imgStyle\": \"100% 100%\", \"showStyle\": \"0px\"}, \"scroll\": true}, \"selectable\": true}], \"pageOptions\": {\"name\": \"1\", \"isUseDefaultPic\": true}, \"footerModule\": {\"id\": \"footer\", \"title\": \"底部导航\", \"options\": {\"bgColor\": \"\", \"navItems\": [{\"_uid\": \"tl0kk9ota580\", \"icon\": {\"active\": \"\", \"default\": \"\"}, \"text\": \"首页\", \"sortable\": false, \"removable\": false}, {\"_uid\": \"thelhu84gt80\", \"icon\": {\"active\": \"\", \"default\": \"\"}, \"text\": \"我的\", \"sortable\": true, \"removable\": false}], \"fontColor\": {\"active\": \"\", \"default\": \"\"}}, \"selectable\": false}, \"headerModule\": {\"id\": \"header\", \"title\": \"页面头部\", \"options\": {\"bgImg\": {\"top\": \"\", \"bottom\": \"\"}, \"hints\": [{\"icon\": \"\", \"text\": \"免费配送\"}, {\"icon\": \"\", \"text\": \"晚到必赔\"}, {\"icon\": \"\", \"text\": \"专业检测\"}, {\"icon\": \"\", \"text\": \"30分钟达\"}], \"search\": {\"show\": false, \"placeholder\": \"\"}, \"swiper\": {\"show\": true, \"imgStyle\": \"100% 100%\", \"showStyle\": \"12px 20px 0px\"}}, \"selectable\": false}}', 'admin', 'admin', '2023-11-14 11:27:03', '2023-11-15 22:41:29');
    17. 

  17. INSERT INTO `kx_page_template` VALUES (1724267729304731649, 1, '{\"moduleList\": [{\"id\": \"announcement\", \"_uid\": \"announcement_velftufbt1o0\", \"limit\": 1, \"style\": {\"backgroundPosition\": \"-90px -345px\", \"hoverBackgroundPosition\": \"-130px -345px\"}, \"title\": \"通知公告\", \"options\": {}, \"selectable\": true}, {\"id\": \"navigation\", \"_uid\": \"navigation_124p8hba2l180\", \"limit\": 1, \"style\": {\"backgroundPosition\": \"-10px -345px\", \"hoverBackgroundPosition\": \"-50px -345px\"}, \"title\": \"图文导航\", \"options\": {\"banner\": {\"imgStyle\": \"100% 100%\", \"showStyle\": \"12px 12px 0px\"}, \"bgColor\": \"#FFFFFF\", \"fontColor\": null, \"iconStyle\": \"50%\", \"showStyle\": \"0px\"}, \"selectable\": true}, {\"id\": \"special\", \"_uid\": \"special_lmqte3o8qqk0\", \"limit\": 1, \"style\": {\"backgroundPosition\": \"-250px -345px\", \"hoverBackgroundPosition\": \"-290px -345px\"}, \"title\": \"今日特价\", \"options\": {\"banner\": {\"show\": true, \"imgUrl\": \"\", \"imgStyle\": \"100% 100%\", \"showStyle\": \"12px 12px 0px\"}, \"scroll\": true}, \"selectable\": true}, {\"id\": \"recommend\", \"_uid\": \"recommend_p8gjlc2llj40\", \"limit\": 1, \"style\": {\"backgroundPosition\": \"-10px -384px\", \"hoverBackgroundPosition\": \"-50px -384px\"}, \"title\": \"热卖推荐\", \"options\": {\"banner\": {\"show\": true, \"imgUrl\": \"\", \"imgStyle\": \"100% 100%\", \"showStyle\": \"12px 12px 0px\"}, \"scroll\": false}, \"selectable\": true}], \"pageOptions\": {\"name\": \"2\", \"isUseDefaultPic\": true}, \"footerModule\": {\"id\": \"footer\", \"title\": \"底部导航\", \"options\": {\"bgColor\": \"\", \"navItems\": [{\"_uid\": \"tl0kk9ota580\", \"icon\": {\"active\": \"\", \"default\": \"\"}, \"text\": \"首页\", \"sortable\": false, \"removable\": false}, {\"_uid\": \"thelhu84gt80\", \"icon\": {\"active\": \"\", \"default\": \"\"}, \"text\": \"我的\", \"sortable\": true, \"removable\": false}], \"fontColor\": {\"active\": \"\", \"default\": \"\"}}, \"selectable\": false}, \"headerModule\": {\"id\": \"header\", \"title\": \"页面头部\", \"options\": {\"bgImg\": {\"top\": \"\", \"bottom\": \"\"}, \"hints\": [{\"icon\": \"\", \"text\": \"免费配送5\"}, {\"icon\": \"\", \"text\": \"晚到必赔\"}, {\"icon\": \"\", \"text\": \"专业检测\"}, {\"icon\": \"\", \"text\": \"30分钟达\"}], \"search\": {\"show\": true, \"placeholder\": \"855\"}, \"swiper\": {\"show\": true, \"imgStyle\": \"100% 100%\", \"showStyle\": \"12px 20px 0px\"}}, \"selectable\": false}}', 'admin', 'admin', '2023-11-14 11:27:17', '2023-11-15 22:52:38');
    18.