-
Notifications
You must be signed in to change notification settings - Fork 27
/
learn-jooq.sql
154 lines (126 loc) · 7.69 KB
/
learn-jooq.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
/*
SQLyog Ultimate
MySQL - 8.0.15 : Database - learn-jooq
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_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*/`learn-jooq` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
USE `learn-jooq`;
/*Table structure for table `s1_user` */
CREATE TABLE `s1_user` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`username` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
`email` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`address` varchar(128) COLLATE utf8mb4_general_ci DEFAULT NULL,
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=343 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='USER TABLE';
/*Data for the table `s1_user` */
insert into `s1_user`(`id`,`username`,`email`,`address`,`create_time`,`update_time`) values
(1,'demo1','demo1@diamondfds.com','China Guangdong Shenzhen','2019-12-27 16:41:42','2019-12-27 16:41:42'),
(2,'admin1','admin1@diamondfsd@gmail.com','China Guanddong Guangzhou','2019-12-27 16:41:42','2019-12-27 16:41:42');
/*Table structure for table `s2_user_message` */
CREATE TABLE `s2_user_message` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`message_title` varchar(60) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '消息标题',
`message_content` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '消息内容',
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户消息内容';
/*Data for the table `s2_user_message` */
insert into `s2_user_message`(`id`,`user_id`,`message_title`,`message_content`,`create_time`,`update_time`) values
(1,1,'demo1','demo-message-content','2019-12-31 17:07:29','2019-12-31 17:08:18'),
(2,1,'demo2','demo-message-content','2019-12-31 17:07:32','2019-12-31 17:08:17'),
(3,2,'user-2-demo1','demo-message-content','2019-12-31 17:08:01','2019-12-31 17:08:19'),
(4,2,'user-2-demo2','demo-message-content','2019-12-31 17:08:09','2019-12-31 17:08:19');
/*Table structure for table `s4_columen_gt22` */
CREATE TABLE `s4_columen_gt22` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`column_1` int(11) DEFAULT NULL COMMENT '列1',
`column_2` int(11) DEFAULT NULL COMMENT '列2',
`column_3` int(11) DEFAULT NULL COMMENT '列3',
`column_4` int(11) DEFAULT NULL COMMENT '列4',
`column_5` int(11) DEFAULT NULL COMMENT '列5',
`column_6` int(11) DEFAULT NULL COMMENT '列6',
`column_7` int(11) DEFAULT NULL COMMENT '列7',
`column_8` int(11) DEFAULT NULL COMMENT '列8',
`column_9` int(11) DEFAULT NULL COMMENT '列_9',
`column_10` int(11) DEFAULT NULL COMMENT '列10',
`column_11` int(11) DEFAULT NULL COMMENT '列11',
`column_12` int(11) DEFAULT NULL COMMENT '列12',
`column_13` int(11) DEFAULT NULL COMMENT '列13',
`column_14` int(11) DEFAULT NULL COMMENT '列14',
`column_15` int(11) DEFAULT NULL COMMENT '列15',
`column_16` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '列16',
`column_17` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '列17',
`column_18` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '列18',
`column_19` timestamp NULL DEFAULT NULL COMMENT '列19',
`column_20` bit(1) DEFAULT NULL COMMENT '列20',
`column_21` tinyint(4) DEFAULT NULL COMMENT '列21',
`column_22` int(11) DEFAULT NULL COMMENT '列22',
`column_23` int(11) DEFAULT NULL COMMENT '列23',
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='表字段超22';
/*Data for the table `s4_columen_gt22` */
/*Table structure for table `s4_no_primary` */
CREATE TABLE `s4_no_primary` (
`column1` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '测试列1',
`column2` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '测试列2',
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*Data for the table `s4_no_primary` */
insert into `s4_no_primary`(`column1`,`column2`,`create_time`,`update_time`) values
('11','21','2020-01-07 11:31:12','2020-01-07 11:31:12'),
('12','22','2020-01-07 11:31:12','2020-01-07 11:31:12');
/*Table structure for table `s4_union_key` */
CREATE TABLE `s4_union_key` (
`uk_1` int(11) NOT NULL COMMENT '联合ID1',
`uk_2` int(11) NOT NULL COMMENT '联合ID2',
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`uk_1`,`uk_2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*Data for the table `s4_union_key` */
insert into `s4_union_key`(`uk_1`,`uk_2`,`create_time`,`update_time`) values
(1,1,'2020-01-07 11:30:12','2020-01-07 11:30:12'),
(1,2,'2020-01-07 11:30:14','2020-01-07 11:30:14');
/*Table structure for table `s9_news` */
CREATE TABLE `s9_news` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`title` varchar(60) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
`content` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '内容',
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='新闻表';
/*Data for the table `s9_news` */
insert into `s9_news`(`id`,`title`,`content`,`create_time`,`update_time`) values
(1,'news1','content1','2020-01-21 11:26:29','2020-01-21 11:26:41'),
(2,'random','c2','2020-01-21 11:26:33','2020-01-21 11:27:26'),
(3,'nothing happen','hello world','2020-01-21 11:26:37','2020-01-21 11:27:31'),
(4,'a language','c++','2020-01-21 11:26:57','2020-01-21 11:27:36'),
(5,'do something','write java code for good','2020-01-21 11:27:06','2020-01-21 11:27:59'),
(6,'just data','big data','2020-01-21 11:27:14','2020-01-21 11:28:05'),
(7,'helll','passl','2020-01-21 11:28:13','2020-01-21 11:28:24'),
(8,'more page ','more page for test','2020-01-21 11:28:35','2020-01-21 11:28:35'),
(9,'good test','test case is good idea','2020-01-21 11:28:42','2020-01-21 11:28:42'),
(10,'idea','intj','2020-01-21 11:28:48','2020-01-21 11:28:48'),
(11,'idea2','eclipse','2020-01-21 11:28:56','2020-01-21 11:28:56'),
(12,'en-page','goods in page','2020-01-21 11:29:10','2020-01-21 11:29:10'),
(13,'role-for','role for nothing','2020-01-21 11:29:18','2020-01-21 11:29:18'),
(14,'check ids','check the ids ','2020-01-21 11:29:26','2020-01-21 11:29:26'),
(15,'id','id is primary key','2020-01-21 11:29:34','2020-01-21 11:29:34'),
(16,'any key','no keys','2020-01-21 11:29:38','2020-01-21 11:29:38');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;