若依通用商城-测试数据直接复制使用-jftype

/*
Navicat MySQL Data Transfer

Source Server         : 127
Source Server Version : 80022
Source Host           : 127.0.0.1:3306
Source Database       : shop_ry

Target Server Type    : MYSQL
Target Server Version : 80022
File Encoding         : 65001

Date: 2026-05-18 16:11:30
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for jftype
-- ----------------------------
DROP TABLE IF EXISTS `jftype`;
CREATE TABLE `jftype` (
  `type_id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `tname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '分类名称',
  `tsort` int NOT NULL COMMENT '排序字段',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='分类';

-- ----------------------------
-- Records of jftype
-- ----------------------------
INSERT INTO `jftype` VALUES ('1', '手机数码', '1', '2023-01-01 10:00:00');
INSERT INTO `jftype` VALUES ('2', '电脑办公', '2', '2023-01-01 10:05:00');
INSERT INTO `jftype` VALUES ('3', '家用电器', '3', '2023-01-01 10:10:00');
INSERT INTO `jftype` VALUES ('4', '服饰内衣', '4', '2023-01-01 10:15:00');
INSERT INTO `jftype` VALUES ('5', '鞋靴箱包', '5', '2023-01-01 10:20:00');
INSERT INTO `jftype` VALUES ('6', '运动户外', '6', '2023-01-01 10:25:00');
INSERT INTO `jftype` VALUES ('7', '美妆护肤', '7', '2023-01-01 10:30:00');
INSERT INTO `jftype` VALUES ('8', '珠宝首饰', '8', '2023-01-01 10:35:00');
INSERT INTO `jftype` VALUES ('9', '食品生鲜', '9', '2023-01-01 10:40:00');
INSERT INTO `jftype` VALUES ('10', '母婴用品', '10', '2023-01-01 10:45:00');
INSERT INTO `jftype` VALUES ('11', '家居家装', '11', '2023-01-01 10:50:00');