ySWBT5H3

1BEGIN;
2
3DROP TABLE IF EXISTS `user_roles`;
4DROP TABLE IF EXISTS `roles`;
5DROP TABLE IF EXISTS `queues`;
6DROP TABLE IF EXISTS `users`;
7
8CREATE TABLE `users` (
9  `id` bigint(20) NOT NULL AUTO_INCREMENT,
10  `first_name` varchar(40) NOT NULL,
11  `last_name` varchar(15) NOT NULL,
12  `email` varchar(40) NOT NULL,
13  `password` varchar(100) NOT NULL,
14  PRIMARY KEY (`id`),
15  UNIQUE KEY `uk_users_email` (`email`)
16) ENGINE=InnoDB DEFAULT CHARSET=utf8;
17
18
19CREATE TABLE `roles` (
20  `id` bigint(20) NOT NULL AUTO_INCREMENT,
21  `name` varchar(60) NOT NULL,
22  PRIMARY KEY (`id`),
23  UNIQUE KEY `uk_roles_name` (`name`)
24) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
25
26CREATE TABLE `user_roles` (
27  `user_id` bigint(20) NOT NULL,
28  `role_id` bigint(20) NOT NULL,
29  PRIMARY KEY (`user_id`,`role_id`),
30  KEY `fk_user_roles_role_id` (`role_id`),
31  CONSTRAINT `fk_user_roles_role_id` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
32  CONSTRAINT `fk_user_roles_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
33) ENGINE=InnoDB DEFAULT CHARSET=utf8;
34
35CREATE TABLE `queues` (
36  `id` bigint(20) NOT NULL AUTO_INCREMENT,
37  `quque_name` varchar(20) NOT NULL,
38  `user_id` bigint(20) NOT NULL, 
39  `finished` boolean,
40  `created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
41  `updated_at` timestamp DEFAULT CURRENT_TIMESTAMP,
42  PRIMARY KEY (`id`),
43  CONSTRAINT `fk_queues_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
44) ENGINE=InnoDB DEFAULT CHARSET=utf8;
45
46
47SELECT 'LOADING Roles' as 'INFO';
48INSERT IGNORE INTO roles(id,`name`) VALUES(1,'ROLE_ADMIN');
49INSERT IGNORE INTO roles(id,`name`) VALUES(2,'ROLE_USER');
50
51SELECT 'LOADING Users' as 'INFO';
52INSERT INTO users (`first_name`,`last_name`,`email`,`password`) VALUES
53("admin", "admin", "admin@admin.com","$2a$10$zVRbsmuxar7PibSddr8a8e1IbyzfjSXgn5N1HtqRxdy24kCuhuVdy"),
54("admin1", "admin1", "admin@admin.com1","$2a$10$zVRbsmuxar7PibSddr8a8e1IbyzfjSXgn5N1HtqRxdy24kCuhuVdy");
55;
56
57SELECT 'LOADING User Roles' as 'INFO';
58INSERT INTO user_roles (`user_id`,`role_id`)  VALUES(1,1),
59INSERT INTO user_roles (`user_id`,`role_id`)  VALUES(2,1)
60;