Repository navigation
Expand file tree
/
Copy pathclouddemo.sql
More file actions
60 lines (55 loc) · 3.28 KB
/
Copy pathclouddemo.sql
File metadata and controls
60 lines (55 loc) · 3.28 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
SET NAMES utf8 ;
-- Table structure for table `t_product`
DROP TABLE IF EXISTS `t_product`;
SET character_set_client = utf8mb4 ;
CREATE TABLE `t_product` (
`id` bigint(20) NOT NULL COMMENT 'ID',
`product_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '产品名称',
`product_img` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '产品图片(base64)',
`product_desc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '产品描述',
`price` decimal(10,2) NOT NULL COMMENT '产品单价',
`product_num` int DEFAULT 0 COMMENT '产品当前数量',
`sort_index` int(11) DEFAULT '0' COMMENT '排序',
`enable_flag` tinyint(1) DEFAULT '1' COMMENT '是否启用(1-是,0-否)',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_product_name` (`product_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='产品表';
-- LOCK TABLES `t_product` WRITE;
-- /*!40000 ALTER TABLE `t_product` DISABLE KEYS */;
-- INSERT INTO `t_product` VALUES (1931396915971227648,'产品1','http://x.png',10.00,'产品描述',0,1,'2025-06-08 01:04:43','2025-06-08 01:04:43');
-- /*!40000 ALTER TABLE `t_product` ENABLE KEYS */;
-- UNLOCK TABLES;
-- Table structure for table `t_user`
DROP TABLE IF EXISTS `t_user`;
SET character_set_client = utf8mb4 ;
CREATE TABLE `t_user` (
`id` bigint(20) NOT NULL COMMENT 'ID',
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '帐号',
`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码(加密存储)',
`nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '昵称(可修改)',
`avatar_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '头像(可修改)',
`enable_flag` tinyint(1) DEFAULT '1' COMMENT '是否启用(1-是,0-否)',
`money` decimal(10,1) DEFAULT 0.0 COMMENT '余额',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户表';
-- LOCK TABLES `t_user` WRITE;
--
-- UNLOCK TABLES;
DROP TABLE IF EXISTS `t_order`;
SET character_set_client = utf8mb4 ;
CREATE TABLE `t_order` (
`id` bigint(20) NOT NULL COMMENT '订单ID',
`product_id` bigint(20) NOT NULL COMMENT '产品ID',
`user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
`quantity` decimal(10,2) DEFAULT NULL COMMENT '数量',
`totalPrice` decimal(10,2) DEFAULT NULL COMMENT '总价',
`status` varchar(50) DEFAULT NULL COMMENT '订单状态',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单表';