yvjia/db/b2c_goods_unit.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/08/18 12:51:10
*/

DROP TABLE IF EXISTS `b2c_goods_unit`;

CREATE TABLE `b2c_goods_unit` (
   PRIMARY KEY (`id`),
   `id` BIGINT(10) AUTO_INCREMENT COMMENT 'ID',
   `unit_name` VARCHAR(255) NOT NULL COMMENT '商品单位名称',
   `sort` BIGINT(10) DEFAULT '1' COMMENT '排序'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='商品单位表';

INSERT INTO b2c_goods_unit (id, unit_name, sort)
VALUES
    (1, '件', 1), (2, '箱', 2), (3, '包', 3), (4, '瓶', 4), (5, '罐', 5),
    (6, '套', 6), (7, '盒', 7), (8, '支', 8), (9, '台', 9), (10, '本', 10),
    (11, '袋', 11), (12, '卷', 12), (13, '片', 13), (14, '对', 14)
;