-
Notifications
You must be signed in to change notification settings - Fork 0
/
art.sql
162 lines (121 loc) · 16.7 KB
/
art.sql
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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
/*
SQLyog Ultimate v10.00 Beta1
MySQL - 8.0.32 : Database - transaction
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`transaction` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `transaction`;
/*Table structure for table `art` */
DROP TABLE IF EXISTS `art`;
CREATE TABLE `art` (
`art_id` int unsigned NOT NULL AUTO_INCREMENT,
`art_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`author` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
`price` double unsigned NOT NULL,
`pic` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`visits` int DEFAULT '0',
`is_sold` tinyint NOT NULL DEFAULT '0',
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`weight` double DEFAULT NULL,
`size` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`art_era` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
`style` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
`user_id` int DEFAULT NULL,
`create_at` datetime DEFAULT NULL,
PRIMARY KEY (`art_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*Data for the table `art` */
insert into `art`(`art_id`,`art_name`,`author`,`price`,`pic`,`visits`,`is_sold`,`description`,`weight`,`size`,`art_era`,`style`,`user_id`,`create_at`) values (1,'asdasdasdasd','2',0.01,'037f4e68c5f4ab37fbbb6468b310ebb5.png',8,0,'asdadasdasd',1,'1','85','2',NULL,'2023-05-03 21:07:14'),(2,'dasdsadsa','2',0.01,'037f4e68c5f4ab37fbbb6468b310ebb5.png',4,0,'daddasda',1,'1','5','5',1,'2023-05-01 21:07:17'),(3,'第接使际打几','10',86,'037f4e68c5f4ab37fbbb6468b310ebb5.png',32,0,'命响列日走书此能由干拉受万增又等参集。为有报联严复运温土增育把加质来等。但引及况老山列使住系在众眼传式被观。学成何权断总千相体转小单正义机育真。照计高严满好取列己因千很子性经复术。',1,'1','58','2',60,'2023-05-09 21:07:19'),(4,'水知目','2',36,'037f4e68c5f4ab37fbbb6468b310ebb5.png',7,0,'结查动热观科没九响县较即相性始强何年。他后组比打非非实农较建增作位表。始动华而数来体那信持共都科。向党来际四老没最在眼调重用阶。清参五身报众约张劳育很决或管易。取红化月厂实存去极维天部走例其了。号王革然作压阶线把度毛战车保个。',1,'1','3','5',60,'2023-05-02 21:07:21'),(5,'直比确斯时铁','02',5,'037f4e68c5f4ab37fbbb6468b310ebb5.png',3,0,'想经该特例结等几维反号油。风门适志立音知手红场研节解之。张物证列至米论别属历严十山三。',1,'1','96','25',60,'2023-05-01 21:07:22'),(6,'身育相此','10',53,'037f4e68c5f4ab37fbbb6468b310ebb5.png',4,0,'即次北部定林南院然进新题身。世给查手给青红每无电再快眼一己。程界发精行不来调间使或集日算县学。只调种转商大度达走开和管种关表效。',1,'5','3','52',60,'2023-05-16 21:07:24'),(7,'则多点','0',23,'037f4e68c5f4ab37fbbb6468b310ebb5.png',0,0,'式小个别提难易本目为先不基维小。西法非形革程持算车广但持周车此。听位多接响速会立系展价只这。消儿万存般光得养论能产习部公。接证装组干道会片山车外步打必。期究线种任保办采真山老片打看然济收织。',1,'10','63','2',60,'2023-05-22 21:07:27'),(8,'研百文过特院场','10',4,'037f4e68c5f4ab37fbbb6468b310ebb5.png',14,0,'土观现写约县得采值小何候压。每社便位什她没来这周色质际期布期需。市山斯起压次代证飞面共位区热。压更白青育四精数龙她养东。',1,'0','3','25',60,'2023-05-23 21:07:28'),(19,'大声道撒多','10',0.01,'037f4e68c5f4ab37fbbb6468b310ebb5.png',1,0,'dwqdqwd',1,'0','3','25',60,'2023-05-10 21:07:30'),(24,'1','1',1,'037f4e68c5f4ab37fbbb6468b310ebb5.png',10,0,'1',1,'1','2001','1',0,'2023-05-15 21:07:32'),(25,'1','1',1,'bf29885e40c46f4ed065ceb225636a40.png',2,0,'1',1,'1','2001','1',0,'2023-05-28 08:23:20'),(26,'s','1',1,'df0d9e2e9323465df98a4a58775dfd4f.png',15,0,'s',1,'1','2001','z1',60,'2023-05-29 06:18:10'),(27,'s','1',1,'7c6e9b441406f4076d5af1e54db78b6f.png',0,1,'s',1,'1','2001','z1',60,'2023-05-29 06:19:45'),(28,'1','1',1,'f4b6a8f36a788e5f53c828e9cac0d48d.png',1,0,'1',1,'1','2001','1',0,'2023-05-29 06:20:09'),(29,'1','11',1,'aadb449df1b89f92c236fd8e8010d467.png',0,0,'1',11,'11','2001','1',0,'2023-05-29 06:20:36'),(30,'clala','clala',999,'e060600401ec9f2ad20a049b2914b947.png',73,0,'clala',999,'999','2023','clala',60,'2023-06-01 17:44:15'),(31,'11','222',11,'cb473d3d170a5de31e8fb2e9e51639af.png',0,0,'11',111111,'11','2011','11',60,'2023-06-01 07:22:38'),(32,'11','222',11,'cdbd2c1e3eb69d3c5a2eb21e856440fb.png',0,0,'11',111111,'11','2011','11',60,'2023-06-01 07:24:59'),(33,'sss','sss',15,'08dd3fc8d870af47190cd3907bbbbf8d.png',0,0,'ss',17,'sss','2002','ssss',60,'2023-06-01 07:25:26'),(34,'zaz','zaza',65656,'a8ab2ecabe3045547d95a0f8e448f3be.png',63,0,'即次北部定林南院然进新题身。世给查手给青红每无电再快眼一己。程界发精行不来调间使或集日算县学。只调种转商大度达走开和管种关表效。即次北部定林南院然进新题身。世给查手给青红每无电再快眼一己。程界发精行不来调间使或集日算县学。只调种转商大度达走开和管种关表效。即次北部定林南院然进新题身。世给查手给青红每无电再快眼一己。程界发精行不来调间使或集日算县学。只调种转商大度达走开和管种关表效。即次北部定林南院然进新题身。世给查手给青红每无电再快眼一己。程界发精行不来调间使或集日算县学。只调种转商大度达走开和管种关表效',65656,'65656','2050','azaza',60,'2023-06-01 17:45:26'),(35,'2023.6.1','2023.6.1',15,'962c0e6a29792b29d170e17ce684bb60.png',3,0,'2023.6.1',15,'2023.6.1','1500','2023.6.1',60,'2023-06-01 17:40:10');
/*Table structure for table `art_order` */
DROP TABLE IF EXISTS `art_order`;
CREATE TABLE `art_order` (
`order_id` int NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL,
`art_id` int NOT NULL,
`buy_time` datetime NOT NULL,
`is_confirm` tinyint(1) NOT NULL DEFAULT '0',
`state` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*Data for the table `art_order` */
insert into `art_order`(`order_id`,`user_id`,`art_id`,`buy_time`,`is_confirm`,`state`) values (1,22,6,'2023-04-10 17:44:18',1,1),(2,22,6,'2023-04-10 17:49:30',0,0),(3,22,5,'2023-04-10 17:49:44',0,1);
/*Table structure for table `cart` */
DROP TABLE IF EXISTS `cart`;
CREATE TABLE `cart` (
`cart_id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`art_id_list` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`update_at` datetime DEFAULT NULL,
PRIMARY KEY (`cart_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*Data for the table `cart` */
insert into `cart`(`cart_id`,`user_id`,`art_id_list`,`update_at`) values (1,60,',30,8,25,35,1','2023-06-02 23:37:20');
/*Table structure for table `comment` */
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
`floor_id` int NOT NULL AUTO_INCREMENT,
`hole_id` int NOT NULL,
`art_id` int NOT NULL,
`user_id` int NOT NULL,
`content` varchar(4095) COLLATE utf8mb4_general_ci DEFAULT NULL,
`likes` int NOT NULL DEFAULT '0',
`create_at` datetime DEFAULT NULL,
`is_deleted` tinyint(1) NOT NULL DEFAULT '0',
`likes_user` varchar(4095) COLLATE utf8mb4_general_ci DEFAULT NULL,
`floor_th` int NOT NULL,
PRIMARY KEY (`floor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*Data for the table `comment` */
insert into `comment`(`floor_id`,`hole_id`,`art_id`,`user_id`,`content`,`likes`,`create_at`,`is_deleted`,`likes_user`,`floor_th`) values (1,1,1,60,'i am the first',1,'2023-05-29 21:11:50',0,'60',1),(2,2,30,60,'依托答辩',1,'2023-05-30 22:52:06',0,',60',1),(3,2,30,60,'114514',1,'2023-05-30 17:17:42',0,',60',2),(4,4,30,60,'你好你好',0,'2023-05-31 14:57:45',0,'',1),(5,5,30,60,'我是第五',0,'2023-05-31 14:58:11',0,NULL,1),(6,6,30,60,'真的吗',0,'2023-05-31 15:24:21',0,NULL,1),(7,7,30,60,'你好你好',0,'2023-05-31 15:25:07',0,NULL,1),(8,2,30,60,'真的答辩',0,'2023-05-31 15:28:16',0,'',3),(9,4,30,60,'你好',0,'2023-05-31 15:33:36',0,NULL,2),(10,5,30,60,'101010',0,'2023-05-31 15:33:45',1,NULL,2),(11,7,30,60,'你坏',0,'2023-05-31 15:33:56',0,NULL,2),(12,8,30,60,'芝士丁真',1,'2023-05-31 15:34:12',0,',60',1),(13,5,30,60,'你怎么被删了',1,'2023-05-31 15:38:50',0,',60',3),(14,9,8,60,'没人？打个郊县',1,'2023-05-31 18:02:47',0,',60',1),(15,2,30,60,'是的',1,'2023-06-02 19:26:16',0,',60',4);
/*Table structure for table `purchase` */
DROP TABLE IF EXISTS `purchase`;
CREATE TABLE `purchase` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL,
`art_id` int NOT NULL,
`buy_at` datetime NOT NULL,
`price` double NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*Data for the table `purchase` */
insert into `purchase`(`id`,`user_id`,`art_id`,`buy_at`,`price`) values (1,60,2,'2023-05-31 17:03:31',0.01),(2,60,2,'2023-05-31 17:07:17',0.01),(3,60,2,'2023-05-31 17:07:44',0.01),(4,60,2,'2023-05-31 17:08:01',0.01),(5,60,2,'2023-05-31 17:09:09',0.01),(6,60,2,'2023-05-31 17:32:10',0.01),(7,60,30,'2023-05-31 17:50:17',2);
/*Table structure for table `transfer_account` */
DROP TABLE IF EXISTS `transfer_account`;
CREATE TABLE `transfer_account` (
`id` int NOT NULL AUTO_INCREMENT,
`from_id` int NOT NULL,
`to_id` int NOT NULL,
`amount` double NOT NULL,
`create_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*Data for the table `transfer_account` */
insert into `transfer_account`(`id`,`from_id`,`to_id`,`amount`,`create_at`) values (1,22,22,1240,'2023-04-08 16:09:34'),(2,22,22,30,'2023-04-08 16:10:59'),(3,22,22,666,'2023-04-08 16:11:13'),(4,22,22,666,'2023-04-08 16:14:21'),(5,22,22,-666,'2023-04-08 16:14:23'),(6,22,22,-114514,'2023-04-08 16:15:53'),(7,22,22,91,'2023-04-08 16:33:24'),(8,22,22,1100,'2023-04-08 16:33:57'),(9,22,22,2691,'2023-04-08 16:47:35'),(10,22,22,0,'2023-04-08 16:53:25'),(11,22,2,5,'2023-04-08 23:06:42'),(12,22,2,70,'2023-04-08 23:08:23'),(13,22,2,5,'2023-04-08 23:09:03'),(14,22,2,5,'2023-04-08 23:16:31'),(15,22,2,0,'2023-04-08 23:16:34'),(16,22,2,-5,'2023-04-08 23:16:38'),(17,22,2,5,'2023-04-08 23:26:32'),(18,22,2,371,'2023-04-10 17:07:04'),(19,22,2,371,'2023-04-10 17:11:55'),(20,22,2,371,'2023-04-10 17:12:30'),(21,22,2,371,'2023-04-10 17:16:42'),(22,22,2,371,'2023-04-10 17:35:14'),(23,22,22,9,'2023-04-10 17:36:06'),(24,22,22,9,'2023-04-10 17:43:43'),(25,22,2,371,'2023-04-10 17:43:52'),(26,22,2,371,'2023-04-10 17:44:18'),(27,22,2,371,'2023-04-10 17:49:29'),(28,22,2,10,'2023-04-10 17:49:44'),(29,2,1,371,'2023-04-10 20:20:06'),(30,4,3,13822,'2023-04-12 12:26:53'),(31,7,7,6259,'2023-04-12 19:18:34'),(32,10,10,6259,'2023-04-12 19:40:04'),(33,11,11,6259,'2023-04-12 19:46:14'),(34,11,1,6259,'2023-04-12 19:46:14'),(35,11,11,6259,'2023-04-12 19:48:07'),(36,11,1,6259,'2023-04-12 19:48:07'),(37,6,6,6259,'2023-04-12 19:52:27'),(38,6,1,6259,'2023-04-12 19:52:27'),(39,22,22,1,'2023-04-14 19:13:47'),(40,22,22,1,'2023-04-14 19:14:22'),(41,12,12,1000,'2023-04-14 19:50:46'),(42,12,1,1000,'2023-04-14 19:50:46'),(43,1,1,36,'2023-04-14 20:20:30'),(44,1,1,0.1,'2023-04-14 20:23:53'),(45,1,1,9,'2023-04-14 20:24:16'),(46,1,1,9,'2023-04-14 20:24:31'),(47,1,1,0.1,'2023-04-14 20:24:55'),(48,1,1,0.01,'2023-04-14 20:25:17'),(49,1,1,0.9,'2023-04-14 20:25:27'),(50,14,14,7440,'2023-04-15 01:02:08'),(51,14,1,7440,'2023-04-15 01:02:08'),(52,17,17,36000000,'2023-04-15 02:01:15'),(53,17,2,36000000,'2023-04-15 02:01:15'),(54,2,17,36000000,'2023-04-15 02:02:18'),(55,17,17,36000000,'2023-04-15 02:02:55'),(56,17,2,36000000,'2023-04-15 02:02:55'),(57,2,1,36000000,'2023-04-15 02:03:05'),(58,1,1,999.6,'2023-04-15 23:15:12'),(59,1,1,1,'2023-04-15 23:18:57'),(60,1,1,1,'2023-04-15 23:19:08'),(61,1,1,3,'2023-04-15 23:19:20'),(62,1,1,1,'2023-04-15 23:19:27'),(63,1,1,100,'2023-04-15 23:19:35'),(64,22,22,1,'2023-04-16 16:54:14'),(65,22,22,1.01,'2023-04-16 16:54:21');
/*Table structure for table `user` */
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`hash` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`gender` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`birthday` date DEFAULT NULL,
`nationality` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`balance` double DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*Data for the table `user` */
insert into `user`(`id`,`username`,`password`,`hash`,`email`,`phone`,`address`,`gender`,`birthday`,`nationality`,`balance`) values (1,'admin','202cb962ac59075b964b07152d234b70','','123@m.fudan.edu.cn','13532321213','asx','sax',NULL,'as',0.09),(3,'hhh','febede4dd696675b3aebdb93cbc01a33','6b1f69e6fc7259f13dfa59ff707c4772','','','sx',NULL,NULL,'x',0),(21,'kkk','e10adc3949ba59abbe56e057f20f883e','','adsads','412','as',NULL,NULL,'sx',0),(22,'python','202cb962ac59075b964b07152d234b70','','859@qq.com','150',NULL,'sa','0000-00-00','a',52),(26,'dollar','202cb962ac59075b964b07152d234b70','','assq@qq.com','13532321212','as',NULL,'0000-00-00',NULL,0),(37,'user','200820e3227815ed1756a6b531e7e0d2','','asasdsasq@qq.com','13911111111','as',NULL,'0000-00-00','sx',252),(38,'shoper','200820e3227815ed1756a6b531e7e0d2','','9slsl@qq.com','13266666666','xa',NULL,'0000-00-00','a',5),(39,'kasdjlask','5b53d0616bc3cf2ad7816da398bf25bf','','n.jdkqcqmoy@qq.com','18614425484',NULL,'sx',NULL,'xx',2),(45,'wssj','d6f050cae921c1a0eae2b5995ca1bc7b','eea58d294534743c7c0beb4446768f25','g.zhjevcfj@qq.com','18174244943','sx','a','0000-00-00','sx',2),(46,'adsadwq','4b9ddedd80b446aea09d3079f9b42971','','s.rytnh@qq.com','18138451245','sx','xas','0000-00-00',NULL,25),(47,'das9d','be272d37655bb01dc0397223787158fd','f0eaa2b6693c8bde416660d643400c21','l.xdhpvfuog@qq.com','19873356162','sxas','sxs',NULL,'xa',25),(48,'asdas','724d4a52db479d1118f0de824415eaf5','','r.soek@qq.com','18617387812','asa',NULL,'0000-00-00','xxas',2),(50,'0','febede4dd696675b3aebdb93cbc01a33','6b1f69e6fc7259f13dfa59ff707c4772',NULL,'',NULL,NULL,NULL,NULL,52),(58,'myh','470b7f272a94ee3a4faff962cff25733','','ww@qq.com','135','哈哈哈哈哈','female','2023-05-25','China',552),(59,'mhyyy','28195a6b4625209b58401bb2fe3b9578','fc4840ad2a5736f2daafae3837cfa1dc','ww@qq.com','135','哈哈哈哈哈','female','2023-05-25','China',252),(60,'myhuu','cfdd718eb49589307a4be37d99176a0c','994573609d89b47d47b0865874450519','ww@qq.com','135','哈哈哈哈哈','female','2023-05-25','China',214546.01000000018),(61,'14451','090f2a522b9ff9ac3dce0e24b009d226','57607a3b448d1c17ee9cec2e1e101108','ww@qq.com','13096969699','哈哈哈哈哈','female','2023-05-20','China',11),(62,'496149964','7d47e86649795665a772dbaa4316633e','415607a5fb90cba4574d3a4227b3d10f','ww@qq.com','13096969696','哈哈哈哈哈','female','2023-05-20','China',14),(63,'wqqwewq','3470416229e9ee4652e5af53b22ed90e','477c3023943b115a50d3d9b81d2a9f67','ww@qq.com','13096969697','哈哈哈哈哈','female','2023-05-20','China',25),(64,'496149964qweqeq','f4050bf3dd40bba16276676d28c4dbe7','349c9136aa14c549332768ee2637fc3c','791@qq.com','13096969691','哈哈哈66666','female','2023-05-17','414',74),(65,'zhu','2b1caaf9e1e00803e3c40d7bfd2303a2','71b50ca20123ebcc2f989f61c207e845','ww@qq.com','13096969695','哈哈哈哈哈','other','2023-05-11','China',7),(66,'66','66','6','6','66','6','6','0000-00-00','6',0);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;