rikH3vZ0

1SET FOREIGN_KEY_CHECKS=0;
2SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
3USE timetracker;
4
5DROP TABLE IF EXISTS timesheet;
6/* timesheet table which stores all data from csv file */
7CREATE TABLE timesheet (
8  id INT NOT NULL AUTO_INCREMENT,
9  card_id INT NOT NULL ,
10  date_d DATE NOT NULL ,
11  time_d INT NOT NULL ,
12  status VARCHAR(255) NOT NULL ,
13  upload_id INT NOT NULL ,
14  PRIMARY KEY (id)
15) ENGINE = InnoDB;
16
17DROP TABLE IF EXISTS daily_hours;
18/* daily_hours table stores sum time for every user by day */
19CREATE TABLE daily_hours (
20  id INT NOT NULL AUTO_INCREMENT,
21  card_id INT NOT NULL,
22  date DATE NOT NULL,
23  check_in VARCHAR(255) NOT NULL,
24  check_out VARCHAR(255) NOT NULL,
25  sum_time INT NOT NULL,
26  is_valid TINYINT NOT NULL,
27  PRIMARY KEY (id)
28) ENGINE = InnoDB;
29
30DROP TABLE IF EXISTS monthly_hours;
31/* monthly_hours table stores sum time for every user by month */
32CREATE TABLE monthly_hours (
33  `id` int NOT NULL AUTO_INCREMENT,
34  `card_id` int(11) NOT NULL,
35  `month` int(11) NOT NULL,
36  `sum_time` bigint(20) NOT NULL,
37  `year` int(11) NOT NULL,
38  PRIMARY KEY (`id`)
39) ENGINE = InnoDB;
40
41DROP TABLE IF EXISTS cards;
42/* stores cards which is related to users(employees) */
43CREATE TABLE cards (
44  `id` INT NOT NULL,
45  `date_assigned` DATETIME NULL,
46  `user_id` INT,
47  `is_active` TINYINT NOT NULL,
48  PRIMARY KEY(id)
49) ENGINE = InnoDB;
50
51DROP TABLE IF EXISTS user;
52/* store users(employees) */
53CREATE TABLE user (
54  `id` INT NOT NULL AUTO_INCREMENT,
55  `firstname` VARCHAR(255) NOT NULL,
56  `lastname` VARCHAR(255) NOT NULL,
57  `email` VARCHAR(255) NULL,
58  `skype` VARCHAR(255) NOT NULL,
59  `password` VARCHAR(255) NOT NULL,
60  PRIMARY KEY (`id`)
61) ENGINE = InnoDB;
62
63DROP TABLE IF EXISTS role;
64/* role table */
65CREATE TABLE role (
66  `id` INT NOT NULL AUTO_INCREMENT,
67  `role` VARCHAR(255) NOT NULL,
68  PRIMARY KEY (id)
69) ENGINE = InnoDB;
70
71DROP TABLE IF EXISTS user_role;
72/* many to many user_role table */
73CREATE TABLE user_role (
74  `user_id` INT NOT NULL,
75  `role_id` INT NOT NULL,
76  PRIMARY KEY (user_id, role_id)
77) ENGINE = InnoDB;
78
79DROP TABLE IF EXISTS project;
80/* project table stores projects which users works on */
81CREATE TABLE project (
82  `id` INT AUTO_INCREMENT NOT NULL,
83  `client_id` INT NOT NULL,
84  `name` VARCHAR(255) NOT NULL,
85  `date_start` DATE NOT NULL,
86  `date_end` DATE NOT NULL,
87  `notes` VARCHAR(2000) NOT NULL,
88  PRIMARY KEY(id)
89) ENGINE = InnoDB;
90
91
92DROP TABLE IF EXISTS project_user;
93/* many to many between project and user */
94CREATE TABLE project_user (
95  `project_id` INT NOT NULL,
96  `user_id` INT NOT NULL,
97  PRIMARY KEY (project_id, user_id)
98) ENGINE = InnoDB;
99
100
101DROP TABLE IF EXISTS activity;
102/* stores activity for project */
103CREATE TABLE activity (
104  `id` INT AUTO_INCREMENT NOT NULL,
105  `name` VARCHAR(255),
106  PRIMARY KEY (id)
107) ENGINE = InnoDB;
108
109DROP TABLE IF EXISTS task;
110/* time table stores time for every task which user creates */
111CREATE TABLE task (
112  `id` INT NOT NULL AUTO_INCREMENT,
113  `activity_id` INT,
114  `description` VARCHAR(1200),
115  `time` INT NOT NULL,
116  `start_time` DATETIME NOT NULL,
117  `active` BIT NOT NULL,
118  `project_id` INT,
119  `user_id` INT,
120  PRIMARY KEY (id)
121
122) ENGINE = InnoDB;
123
124DROP TABLE IF EXISTS reset_token;
125CREATE TABLE reset_token (
126  `id` INT NOT NULL AUTO_INCREMENT,
127  `token` VARCHAR(255) NOT NULL,
128  `user_id` INT NOT NULL,
129  `created_at` DATETIME NOT NULL,
130  PRIMARY KEY(id)
131) ENGINE = InnoDB;
132
133
134DROP TABLE IF EXISTS client;
135CREATE TABLE client(
136	`id` INT NOT NULL AUTO_INCREMENT,
137	`name` VARCHAR(255) NOT NULL,
138	`email` VARCHAR(255) NOT NULL,
139	`address` VARCHAR(255) NOT NULL,
140	PRIMARY KEY(id)
141) ENGINE = InnoDB;
142
143DROP TABLE IF EXISTS upload;
144CREATE TABLE upload(
145	`id` INT NOT NULL AUTO_INCREMENT,
146	`date` DATE NOT NULL,
147	PRIMARY KEY(id)
148) ENGINE = InnoDB;
149/*
150DROP TRIGGER IF EXISTS sum_monthly_hours;
151DELIMITER $$
152create trigger sum_monthly_hours
153after insert on daily_hours 
154for each row 
155BEGIN
156	DECLARE myCount INT;
157    
158    SELECT COUNT(*) INTO myCount FROM `monthly_hours` AS dh WHERE dh.card_id = NEW.`card_id` AND dh.month = MONTH(NEW.`date`) AND dh.year = YEAR(NEW.`date`);
159
160	if(myCount = 0) then 
161		insert into `monthly_hours`(`card_id`, `month`, `sum_time`, `year`) 
162        values (NEW.`card_id`,month(NEW.`date`),NEW.`sum_time`,year(NEW.`date`));
163	else
164		update monthly_hours set sum_time = sum_time + NEW.`sum_time` where card_id=NEW.`card_id` and month=month(NEW.`date`) and year=year(NEW.`date`);
165	end if;
166END;$$
167
168DELIMITER ;
169
170ALTER TABLE timesheet ADD CONSTRAINT UQ_CARD_ID_DATE_TIME UNIQUE(card_id, date_d, time_d);
171ALTER TABLE task ADD CONSTRAINT UQ_USER_ID_DATE_TIME UNIQUE(user_id, start_time, time);
172*/
173create index date_idx on timesheet(date_d);
174create index time_idx on timesheet(time_d);
175create index card_id_idx on daily_hours(card_id);
176create index dh_date_idx on daily_hours(date);
177-- create index task_user_id_idx on task(user_id);
178-- create index task_date_idx on task(start_time);
179-- create index task_time on task(time);
180
181alter table timesheet add foreign key (card_id) REFERENCES cards(id);
182alter table cards add foreign key (user_id) REFERENCES user(id);
183alter table project_user add CONSTRAINT `project_user_project_fk` FOREIGN KEY (project_id) REFERENCES project(id) ON DELETE CASCADE ON UPDATE CASCADE;
184alter table project_user add CONSTRAINT `project_user_user_fk` FOREIGN KEY (user_id) REFERENCES user(id) ON DELETE CASCADE ON UPDATE CASCADE;
185alter table task add foreign key (user_id) REFERENCES user(id);
186alter table task add foreign key (project_id) REFERENCES project(id);
187alter table daily_hours add foreign key (card_id) REFERENCES cards(id);
188alter table monthly_hours add foreign key (card_id) REFERENCES cards(id);
189alter table user_role add CONSTRAINT `user_role_user_fk` FOREIGN KEY (user_id) REFERENCES user(id) ON DELETE CASCADE ON UPDATE CASCADE;
190alter table user_role add CONSTRAINT `user_role_role_fk` FOREIGN KEY (role_id) REFERENCES role(id) ON DELETE CASCADE ON UPDATE CASCADE;
191ALTER TABLE project ADD CONSTRAINT `project_client_fk` FOREIGN KEY (client_id) REFERENCES client(id) ON DELETE CASCADE ON UPDATE CASCADE;
192INSERT INTO role(role) VALUES ('ROLE_USER');
193INSERT INTO role(role) VALUES ('ROLE_ADMIN');
194INSERT INTO role(role) VALUES ('ROLE_MANAGER');
195INSERT INTO user(firstname, lastname, email, skype, password) VALUES ('default', 'default', 'default@simple-task.com', 'default', '$2a$10$5b0xYnKcQPvzT7tNgj1KmOSyoC9IsmvYjBInADdezDT1JVYNsO7IS');
196insert into user(id, firstname, lastname, password, skype) values(2, 'Niksa', 'Bogovac', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
197insert into user(id, firstname, lastname, password, skype) values(3,  'Zeljka', 'Bogovac', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
198insert into user(id, firstname, lastname, password, skype) values(4,  'Vladimir', 'Jovicic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
199insert into user(id, firstname, lastname, password, skype) values(5, 'Jaroslav', 'Meleg', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
200insert into user(id, firstname, lastname, password, skype) values(6, 'Nikola', 'Lovic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
201insert into user(id, firstname, lastname, password, skype) values(7, 'Vladimir', 'Mirkovic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
202insert into user(id, firstname, lastname, password, skype) values(8, 'Zoran', 'Luledzija', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
203insert into user(id, firstname, lastname, password, skype) values(9, 'Filip', 'Bjelobaba', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
204insert into user(id, firstname, lastname, password, skype) values(10, 'Predrag', 'Grbatinic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
205insert into user(id, firstname, lastname, password, skype) values(11, 'Marko', 'Miljanovic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
206insert into user(id, firstname, lastname, password, skype) values(12, 'Nikola', 'Kovacevic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
207insert into user(id, firstname, lastname, password, skype) values(13, 'Stefan', 'Tancic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
208insert into user(id, firstname, lastname, password, skype) values(14, 'Aleksandar', 'Milenkovic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
209insert into user(id, firstname, lastname, password, skype) values(15, 'Vuk', 'Jeremic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
210insert into user(id, firstname, lastname, password, skype) values(16, 'Nikola', 'Stanisic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
211insert into user(id, firstname, lastname, password, skype) values(17, 'Milos', 'Zbiljic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
212insert into user(id, firstname, lastname, password, skype) values(18, 'Igor', 'Crevar', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
213insert into user(id, firstname, lastname, password, skype) values(19, 'Tijana', 'Radulovic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
214insert into user(id, firstname, lastname, password, skype) values(20, 'Dusanka', '', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
215insert into user(id, firstname, lastname, password, skype) values(21, 'Dragan', 'Fazekas', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
216insert into user(id, firstname, lastname, password, skype) values(22, 'Stanislav', 'Kukucka', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
217insert into user(id, firstname, lastname, password, skype) values(23, 'Goran', 'Mandic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
218insert into user(id, firstname, lastname, password, skype) values(24, 'Nina', 'Seslija', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
219insert into user(id, firstname, lastname, password, skype) values(25, 'Srdjan', 'Petrovic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
220insert into user(id, firstname, lastname, password, skype) values(26, 'Predrag', 'Vukovic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
221insert into user(id, firstname, lastname, password, skype) values(27, 'Srdjan', 'Radovic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
222insert into user(id, firstname, lastname, password, skype) values(28, 'Rajko', 'Ilic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
223insert into user(id, firstname, lastname, password, skype) values(29, 'Nemanja', 'Gajic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
224insert into user(id, firstname, lastname, password, skype) values(30, 'Branimir', '24', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
225insert into user(id, firstname, lastname, password, skype) values(31, 'Miljana', '28', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
226insert into user(id, firstname, lastname, password, skype) values(32, 'Ivana', '29', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
227insert into user(id, firstname, lastname, password, skype) values(33, 'Goran', '30', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
228insert into user(id, firstname, lastname, password, skype) values(55, '31', '', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
229insert into user(id, firstname, lastname, password, skype) values(34, '33', '', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
230insert into user(id, firstname, lastname, password, skype) values(35, '34', '', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
231insert into user(id, firstname, lastname, password, skype) values(36, '37', '', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
232insert into user(id, firstname, lastname, password, skype) values(40, '41', '', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
233insert into user(id, firstname, lastname, password, skype) values(44, 'Milos', 'Bilic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
234insert into user(id, firstname, lastname, password, skype) values(45, 'Nikola', 'Stojiljkovic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
235insert into user(id, firstname, lastname, password, skype) values(46, 'Milana', 'Jovanov', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
236insert into user(id, firstname, lastname, password, skype) values(47, 'Andja', 'Jelic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
237insert into user(id, firstname, lastname, password, skype) values(48, '48', '48', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
238insert into user(id, firstname, lastname, password, skype) values(50, 'Lost', '', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
239insert into user(id, firstname, lastname, password, skype) values(51, 'Guest', '', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
240insert into user(id, firstname, lastname, password, skype) values(52, 'Branka', 'Vujcic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
241insert into user(id, firstname, lastname, password, skype) values(53, 'Sofija', 'Zunic', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
242insert into user(id, firstname, lastname, password, skype) values(54, 'AvramovV', '', '$2a$10$yyojA0gQIM16JioqZSPTL.ynF55Qkk45IKuZv2.4qUM5ma7Soz.8a', 'skype');
243
244insert into cards(id, date_assigned, is_active, user_id) values(2, null, 1, 2);
245insert into cards(id, date_assigned, is_active, user_id) values(3, null, 1, 3);
246insert into cards(id, date_assigned, is_active, user_id) values(5, null, 1, 4);
247insert into cards(id, date_assigned, is_active, user_id) values(4, null, 0, 50);
248insert into cards(id, date_assigned, is_active, user_id) values(6, null, 1, 5);
249insert into cards(id, date_assigned, is_active, user_id) values(7, null, 1, 6);
250insert into cards(id, date_assigned, is_active, user_id) values(8, null, 1, 19);
251insert into cards(id, date_assigned, is_active, user_id) values(9, null, 1, 7);
252insert into cards(id, date_assigned, is_active, user_id) values(10, null, 1, 8);
253insert into cards(id, date_assigned, is_active, user_id) values(11, null, 1, 9);
254insert into cards(id, date_assigned, is_active, user_id) values(12, null, 1, 10);
255insert into cards(id, date_assigned, is_active, user_id) values(13, null, 1, 11);
256insert into cards(id, date_assigned, is_active, user_id) values(14, null, 1, 12);
257insert into cards(id, date_assigned, is_active, user_id) values(15, null, 1, 13);
258insert into cards(id, date_assigned, is_active, user_id) values(16, null, 1, 14);
259insert into cards(id, date_assigned, is_active, user_id) values(17, null, 1, 15);
260insert into cards(id, date_assigned, is_active, user_id) values(18, null, 1, 16);
261insert into cards(id, date_assigned, is_active, user_id) values(19, null, 1, 51);
262insert into cards(id, date_assigned, is_active, user_id) values(20, null, 1, 17);
263insert into cards(id, date_assigned, is_active, user_id) values(21, null, 1, 18);
264insert into cards(id, date_assigned, is_active, user_id) values(23, null, 1, 19);
265insert into cards(id, date_assigned, is_active, user_id) values(24, null, 1, 30);
266insert into cards(id, date_assigned, is_active, user_id) values(25, null, 1, 21);
267insert into cards(id, date_assigned, is_active, user_id) values(26, null, 1, 53);
268insert into cards(id, date_assigned, is_active, user_id) values(27, null, 1, 22);
269insert into cards(id, date_assigned, is_active, user_id) values(28, null, 1, 31);
270insert into cards(id, date_assigned, is_active, user_id) values(29, null, 1, 32);
271insert into cards(id, date_assigned, is_active, user_id) values(30, null, 1, 33);
272insert into cards(id, date_assigned, is_active, user_id) values(31, null, 1, 55);
273insert into cards(id, date_assigned, is_active, user_id) values(32, null, 1, 24);
274insert into cards(id, date_assigned, is_active, user_id) values(33, null, 1, 34);
275insert into cards(id, date_assigned, is_active, user_id) values(34, null, 1, 35);
276insert into cards(id, date_assigned, is_active, user_id) values(37, null, 1, 36);
277insert into cards(id, date_assigned, is_active, user_id) values(38, null, 1, 25);
278insert into cards(id, date_assigned, is_active, user_id) values(39, null, 1, 26);
279insert into cards(id, date_assigned, is_active, user_id) values(40, null, 1, 27);
280insert into cards(id, date_assigned, is_active, user_id) values(41, null, 1, 40);
281insert into cards(id, date_assigned, is_active, user_id) values(42, null, 1, 28);
282insert into cards(id, date_assigned, is_active, user_id) values(43, null, 1, 29);
283insert into cards(id, date_assigned, is_active, user_id) values(44, null, 1, 44);
284insert into cards(id, date_assigned, is_active, user_id) values(45, null, 1, 45);
285insert into cards(id, date_assigned, is_active, user_id) values(46, null, 1, 46);
286insert into cards(id, date_assigned, is_active, user_id) values(47, null, 1, 54);
287insert into cards(id, date_assigned, is_active, user_id) values(48, null, 1, 47);
288insert into cards(id, date_assigned, is_active, user_id) values(57, null, 1, 52);
289
290insert into user_role values(1, 2);
291insert into user_role values(2, 2);
292insert into user_role values(3, 1);
293insert into user_role values(4, 1);
294insert into user_role values(5, 2);
295insert into user_role values(6, 1);
296insert into user_role values(7, 1);
297insert into user_role values(8, 1);
298insert into user_role values(9, 1);
299insert into user_role values(10, 1);
300insert into user_role values(11, 1);
301insert into user_role values(12, 1);
302insert into user_role values(13, 1);
303insert into user_role values(14, 1);
304insert into user_role values(15, 1);
305insert into user_role values(16, 1);
306insert into user_role values(17, 1);
307insert into user_role values(18, 1);
308insert into user_role values(19, 1);
309insert into user_role values(20, 1);
310insert into user_role values(21, 1);
311insert into user_role values(22, 1);
312insert into user_role values(23, 1);
313insert into user_role values(24, 1);
314insert into user_role values(25, 1);
315insert into user_role values(26, 1);
316insert into user_role values(27, 1);
317insert into user_role values(28, 1);
318insert into user_role values(29, 1);
319insert into user_role values(30, 1);
320insert into user_role values(31, 1);
321insert into user_role values(32, 1);
322insert into user_role values(33, 1);
323insert into user_role values(34, 1);
324insert into user_role values(35, 1);
325insert into user_role values(36, 1);
326insert into user_role values(40, 1);
327insert into user_role values(44, 1);
328insert into user_role values(45, 1);
329insert into user_role values(46, 1);
330insert into user_role values(47, 1);
331insert into user_role values(48, 1);
332insert into user_role values(50, 1);
333insert into user_role values(51, 1);
334insert into user_role values(52, 1);
335insert into user_role values(53, 1);
336insert into user_role values(54, 1);
337insert into user_role values(55, 1);
338
339insert into activity values(1, 'Programming');
340insert into activity values(2, 'Project Management');
341insert into activity values(3, 'QA');
342insert into activity values(4, 'Additional work/request');
343insert into activity values(5, 'Maintenance');
344insert into activity values(6, 'Sick Leave');
345insert into activity values(7, 'Sales');