3.商品管理模块

1.添加商品管理

1.1.添加数据表

CREATE TABLE `product_descriptions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int DEFAULT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB

CREATE TABLE `product_sku_descriptions` (
  `id` int NOT NULL,
  `product_sku_id` int DEFAULT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB

CREATE TABLE `lms_products` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_core` char(16) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `title` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `bar_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  &#