eb_store_product_description.sql 1.1 KB

1234567891011121314151617181920212223242526272829303132
  1. /*
  2. Navicat Premium Data Transfer
  3. Source Server : 幸福家【新】
  4. Source Server Type : MySQL
  5. Source Server Version : 50744
  6. Source Host : localhost:3306
  7. Source Schema : nanjinglongzhu_c
  8. Target Server Type : MySQL
  9. Target Server Version : 50744
  10. File Encoding : 65001
  11. Date: 03/01/2025 14:55:10
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Table structure for eb_store_product_description
  17. -- ----------------------------
  18. DROP TABLE IF EXISTS `eb_store_product_description`;
  19. CREATE TABLE `eb_store_product_description` (
  20. `product_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品ID',
  21. `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '商品详情',
  22. `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商品类型',
  23. INDEX `product_id`(`product_id`, `type`) USING BTREE,
  24. INDEX `type`(`type`, `product_id`) USING BTREE
  25. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品详情表' ROW_FORMAT = Dynamic;
  26. SET FOREIGN_KEY_CHECKS = 1;