yy0f3tQG

1-- Types
2
3DROP TYPE IF EXISTS "priority" CASCADE;
4DROP TYPE IF EXISTS task_status CASCADE;
5DROP TYPE IF EXISTS invite_status CASCADE;
6DROP TYPE IF EXISTS report_reason CASCADE;
7DROP TYPE IF EXISTS event_type CASCADE;
8DROP TYPE IF EXISTS report_type CASCADE;
9DROP TYPE IF EXISTS log_types CASCADE;
10
11DROP TABLE IF EXISTS users CASCADE;
12DROP TABLE IF EXISTS courses CASCADE;
13DROP TABLE IF EXISTS course_units CASCADE;
14DROP TABLE IF EXISTS course_unit_users CASCADE;
15DROP TABLE IF EXISTS faculties CASCADE;
16DROP TABLE IF EXISTS faculty_courses CASCADE;
17DROP TABLE IF EXISTS rooms CASCADE;
18DROP TABLE IF EXISTS events CASCADE;
19DROP TABLE IF EXISTS event_rooms CASCADE;
20DROP TABLE IF EXISTS threads CASCADE;
21DROP TABLE IF EXISTS thread_responses CASCADE;
22DROP TABLE IF EXISTS reports CASCADE;
23DROP TABLE IF EXISTS workgroups CASCADE;
24DROP TABLE IF EXISTS workgroup_collaborators CASCADE;
25DROP TABLE IF EXISTS taskgroups CASCADE;
26DROP TABLE IF EXISTS tasks CASCADE;
27DROP TABLE IF EXISTS task_responsible CASCADE;
28DROP TABLE IF EXISTS subscribed_user_tasks CASCADE;
29DROP TABLE IF EXISTS logs CASCADE;
30DROP TABLE IF EXISTS notifications CASCADE;
31DROP TABLE IF EXISTS invites CASCADE;
32DROP TABLE IF EXISTS invited_users CASCADE;
33DROP TABLE IF EXISTS course_units CASCADE;
34DROP TABLE IF EXISTS course_unit_votes CASCADE;
35DROP TABLE IF EXISTS exam_rooms CASCADE;
36DROP TABLE IF EXISTS group_request_respondents CASCADE;
37
38CREATE TYPE "priority" AS ENUM ('High', 'Medium', 'Low');
39CREATE TYPE task_status AS ENUM ('To do', 'Done');
40CREATE TYPE invite_status AS ENUM ('Accepted', 'Rejected', 'Pending');
41CREATE TYPE report_reason AS ENUM ('Inappropriate', 'Offensive', 'Spam', 'Not relevant', 'Other');
42CREATE TYPE event_type AS ENUM ('Delivery', 'Exam', 'Other');
43CREATE TYPE report_type AS ENUM ('User', 'Thread', 'ThreadResponse');
44CREATE TYPE log_types AS ENUM ('create', 'statusChange');
45
46-- Tables
47
48/* R1 user */
49
50CREATE TABLE users (
51    id SERIAL PRIMARY KEY,
52    name text NOT NULL UNIQUE,
53    email text NOT NULL UNIQUE,
54    first_name text,
55    last_name text,
56    "image" text DEFAULT 'genericUser.png',
57    bio text,
58    "password" text NOT NULL,
59    is_banned BOOLEAN NOT NULL DEFAULT false,
60    is_admin BOOLEAN NOT NULL DEFAULT false,
61    is_regent BOOLEAN NOT NULL DEFAULT false,
62    remember_token VARCHAR
63);
64
65/* R3 */
66CREATE TABLE courses (
67    id SERIAL PRIMARY KEY,
68    "name" text NOT NULL,
69    acronym text
70);
71
72/* R2 */
73CREATE TABLE course_units (
74    id SERIAL PRIMARY KEY,
75    "name" text NOT NULL,
76    acronym text NOT NULL,
77    "description" text,
78    program text,
79    max_members_per_group int NOT NULL,
80    avg_complexity FLOAT(8),
81    avg_time_spent FLOAT(8),
82    avg_difficulty FLOAT(8),
83    id_course INTEGER REFERENCES courses (id) ON UPDATE CASCADE ON DELETE CASCADE
84);
85
86/* R16 */
87CREATE TABLE course_unit_users (
88    course_unit_id INTEGER REFERENCES course_units (id) ON UPDATE CASCADE ON DELETE CASCADE,
89    user_id INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
90    PRIMARY KEY (course_unit_id, user_id)
91);
92
93/* r4 */
94
95CREATE TABLE faculties (
96    id SERIAL PRIMARY KEY,
97    name text NOT NULL UNIQUE,
98    acronym text
99);
100
101/* R17 */
102CREATE TABLE faculty_courses (
103    id_faculty INTEGER REFERENCES faculties (id) ON UPDATE CASCADE ON DELETE CASCADE,
104    id_course INTEGER REFERENCES courses (id) ON UPDATE CASCADE ON DELETE CASCADE,
105    PRIMARY KEY (id_faculty, id_course)
106);
107
108/* R5 */
109CREATE TABLE rooms (
110    id SERIAL PRIMARY KEY,
111    designation text NOT NULL,
112    id_faculty INTEGER REFERENCES faculties (id) ON UPDATE CASCADE ON DELETE CASCADE
113);
114
115/* R6 */
116CREATE TABLE events (
117    id SERIAL PRIMARY KEY,
118    "name" text NOT NULL,
119    "datetime" TIMESTAMP WITH TIME zone DEFAULT now() NOT NULL,
120    "description" text,
121    id_course_unit INTEGER REFERENCES course_units (id) ON UPDATE CASCADE ON DELETE CASCADE,
122    id_faculty INTEGER REFERENCES faculties (id) ON UPDATE CASCADE ON DELETE CASCADE,
123    type event_type NOT NULL
124);
125
126/* R18 */
127CREATE TABLE exam_rooms (
128    id_event INTEGER REFERENCES events (id) ON UPDATE CASCADE ON DELETE CASCADE,
129    id_room INTEGER REFERENCES rooms (id) ON UPDATE CASCADE ON DELETE CASCADE,
130    PRIMARY KEY (id_event, id_room)
131);
132
133/* R7 */
134CREATE TABLE threads (
135    id SERIAL PRIMARY KEY,
136    author INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
137    course_unit_id INTEGER REFERENCES course_units (id) ON UPDATE CASCADE ON DELETE CASCADE,
138    title text NOT NULL,
139    "text" text NOT NULL,
140    "datetime" TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL,
141    is_deactivated BOOLEAN NOT NULL DEFAULT false
142);
143
144/* R8 */
145CREATE TABLE thread_responses (
146    id SERIAL PRIMARY KEY,
147    author INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
148    thread_id INTEGER REFERENCES threads (id) ON UPDATE CASCADE ON DELETE CASCADE,
149    title text NOT NULL,
150    "text" text NOT NULL,
151    "datetime" TIMESTAMP WITH TIME zone DEFAULT now() NOT NULL,
152    is_deactivated BOOLEAN NOT NULL DEFAULT false
153);
154
155/* r9 */
156CREATE TABLE reports (
157    id SERIAL PRIMARY KEY,
158    reporter INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
159    "datetime" TIMESTAMP WITH TIME zone DEFAULT now() NOT NULL,
160    reason report_reason NOT NULL,
161    type report_type NOT NULL,
162    reported_user INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
163    reported_thread INTEGER REFERENCES threads (id) ON UPDATE CASCADE ON DELETE CASCADE,
164    reported_thread_response INTEGER REFERENCES thread_responses (id) ON UPDATE CASCADE ON DELETE CASCADE,
165    analysed BOOLEAN NOT NULL DEFAULT false
166);
167
168/* R10 */
169CREATE TABLE workgroups (
170    id SERIAL PRIMARY KEY,
171    coordinator INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
172    course_unit_id INTEGER REFERENCES course_units (id) ON UPDATE CASCADE ON DELETE CASCADE,
173    "year" INTEGER NOT NULL,
174    number_members INTEGER,
175    is_active BOOLEAN NOT NULL DEFAULT true,
176    is_group_request_active BOOLEAN  NOT NULL DEFAULT false,
177    is_banned BOOLEAN NOT NULL DEFAULT false,
178    CONSTRAINT CHK_VALUES CHECK (number_members > 0)
179);
180
181/* R19 */
182CREATE TABLE workgroup_collaborators (
183    workgroup_id INTEGER REFERENCES workgroups (id) ON UPDATE CASCADE ON DELETE CASCADE,
184    user_id INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
185    PRIMARY KEY (workgroup_id, user_id)
186);
187
188/* R11 */
189CREATE TABLE taskgroups (
190    id SERIAL PRIMARY KEY,
191    id_workgroup INTEGER REFERENCES workgroups (id) ON UPDATE CASCADE ON DELETE CASCADE,
192    title text NOT NULL,
193    "description" text
194);
195
196/* R12 */
197CREATE TABLE tasks (
198    id SERIAL PRIMARY KEY,
199    id_taskgroup INTEGER REFERENCES taskgroups (id) ON UPDATE CASCADE ON DELETE CASCADE,
200    title text NOT NULL,
201    "priority" priority NOT NULL,
202    "status" task_status NOT NULL DEFAULT 'To do',
203    last_user_to_update INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE
204);
205
206/* R20 */
207CREATE TABLE task_responsible (
208    id_task INTEGER REFERENCES tasks (id) ON UPDATE CASCADE ON DELETE CASCADE,
209    id_user INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
210    PRIMARY KEY (id_task, id_user)
211);
212
213/* R21 */
214CREATE TABLE subscribed_user_tasks (
215    id_user INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
216    id_task INTEGER REFERENCES tasks (id) ON UPDATE CASCADE ON DELETE CASCADE,
217    PRIMARY KEY (id_task, id_user)
218);
219
220/* R13 */
221CREATE TABLE logs (
222    id SERIAL PRIMARY KEY,
223    "datetime" TIMESTAMP WITH TIME zone DEFAULT now() NOT NULL,
224    id_user INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
225    id_task INTEGER REFERENCES tasks (id) ON UPDATE CASCADE ON DELETE CASCADE,
226    type log_types NOT NULL
227);
228
229/* R22 */
230CREATE TABLE notifications (
231    id SERIAL PRIMARY KEY,
232    id_log INTEGER REFERENCES logs (id) ON UPDATE CASCADE ON DELETE CASCADE,
233    id_user INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
234    seen BOOLEAN NOT NULL DEFAULT false
235);
236
237/* R14 */
238CREATE TABLE invites (
239    id SERIAL PRIMARY KEY,
240    author INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
241    id_workgroup INTEGER REFERENCES workgroups(id) ON UPDATE CASCADE ON DELETE CASCADE,
242    invited_user INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
243    "status" invite_status NOT NULL DEFAULT 'Pending'
244);
245
246/* R23 */
247CREATE TABLE course_unit_votes (
248    id SERIAL PRIMARY KEY,
249    id_user INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
250    id_course_unit INTEGER REFERENCES course_units (id) ON UPDATE CASCADE ON DELETE CASCADE,
251    complexity INTEGER,
252    time_spent INTEGER,
253    difficulty INTEGER,
254    CONSTRAINT CHK_VALUES_VOTE CHECK (complexity>=0 AND complexity<=5 AND time_spent>=0 AND time_spent<=5 AND difficulty>=0 AND difficulty<=5)
255);
256
257/* R24 */
258CREATE TABLE group_request_respondents (
259    id_user INTEGER REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
260    id_workgroup INTEGER REFERENCES workgroups (id) ON UPDATE CASCADE ON DELETE CASCADE,
261    PRIMARY KEY (id_user, id_workgroup)
262);
263
264/* TEST INSERTS */
265/* USER */
266INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
267VALUES ('TheUserNumber1','admin@sapo.pt','João', 'Morais', 'TheUserNumber1.jpg', 'I am the admin!', '$2y$10$7chZmHlb8kqaucAby14Wg.4h0E7tjeehCx2sLYKSNFzIvIMiWHU9a', FALSE, TRUE, FALSE, NULL); /* hash 123456 */
268
269INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
270VALUES ('CatFish','myemail@gmail.com','Maria', 'Moura', 'CatFish.jpg', 'A cat chasing a fish', 'FWSEUIYLB432', FALSE, FALSE, FALSE, NULL);
271
272INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
273VALUES ('K-Dot','kdot@gmail.com','Kendrick', 'Duckworth', 'K-Dot.jpg', 'How much a dollar cost', 'UID&WGVFWUD7', FALSE, FALSE, FALSE, NULL);
274
275INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
276VALUES ('Madlib','mad@gmail.com','Otis', 'Jackson', 'Madlib.jpg', 'Piñata', 'YDVUJVL87934', FALSE, FALSE, FALSE, NULL);
277
278INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
279VALUES ('MF_DOOM','madvillainy@gmail.com','Daniel', 'Dumile', 'MF_DOOM.jpg', 'ALL CAPS WHEN YOU SPELL THE MANS NAME', 'HJBDFV78844', FALSE, FALSE, FALSE, NULL);
280
281INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
282VALUES ('Little_Simz','LittleSimz@gmail.com','Simbiatu', 'Ajikawo', 'Little_Simz.jpg', 'GREY Area', 'HJBOUH789996', FALSE, FALSE, FALSE, NULL);
283
284INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
285VALUES ('Janelle_Monae','Janelle_Monae@gmail.com','Janelle', 'Robinson', 'Janelle_Monae.jpg', 'Take a Byte', 'OPIWSEUDE932U', FALSE, FALSE, FALSE, NULL);
286
287INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
288VALUES ('Jack_White','Jack@gmail.com','John', 'Gillis', 'Jack_White.jpg', NULL, 'OGBC80DWEHJDWU', FALSE, FALSE, FALSE, NULL);
289
290INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
291VALUES ('Fever_Ray','itsSoDamnHot@gmail.com','Karin', 'Andersson', 'Fever_Ray.jpg', 'Concrete Walls', 'BIEWDFC876WDCU', FALSE, FALSE, FALSE, NULL);
292
293INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
294VALUES ('Frank Ocean','blonde@gmail.com','Christopher', 'Breaux', 'Frank_Ocean.jpg', 'Good Guy', 'BIEPFVE83RFD3HJ', FALSE, FALSE, FALSE, NULL);
295
296INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
297VALUES ('JuliaH','jhma@gmail.com','Julia', 'Holter', 'JuliaH.jpg', NULL, 'BYHOGUOG8723EJU', FALSE, FALSE, FALSE, NULL);
298
299INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
300VALUES ('Flume','flumeInTheHouse@gmail.com','Harley', 'Streten', 'Flume.jpg', 'Hi this is Flume', 'HIHGIGUOV5657K7', FALSE, FALSE, FALSE, NULL);
301
302INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
303VALUES ('Tyler_the_Creator','FlowerBoy@gmail.com','Tyler', 'Okonma', 'Tyler_the_Creator.jpg', 'I AINT GOT TIIIIIIIIIIIIIIIIIIIIIIIIIIIMMMMEEEEEEEEEEEEEEEE', 'G8E90DFVCE98GEOC', FALSE, FALSE, FALSE, NULL);
304
305INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
306VALUES ('FranciscoAlves19','falves98@gmail.com','Francisco', 'Alves', 'default.jpg', 'Living my best life... I aint going back and forth with you ninjas', 'K6HL4DFVCE98GEOC', FALSE, FALSE, FALSE, NULL);
307
308INSERT INTO users (name, email, first_name, last_name, bio, password, remember_token) 
309VALUES ('DaBaby','Babysitter@gmail.com','Jonathan', 'Kirk', 'Im going baby on baby!!!', 'G8E90DFVCE98GEOC', NULL);
310
311INSERT INTO users (name, email, first_name, last_name, bio, password, remember_token) 
312VALUES ('Mariana11','up00000001@fe.up.pt','Mariana', 'Costa', 'Esta é a minha descrição. Não sei o que dizer.', 'PBI560UVNO98KEOC', NULL);
313
314INSERT INTO users (name, email, first_name, last_name, bio, password, remember_token) 
315VALUES ('DinisMoreira75','up00000002@fe.up.pt','Dinis', 'Moreira', 'Também não sei o que meter na minha descrição. Feels Bad.', 'FG8E90UVNO98KEOC', NULL);
316
317INSERT INTO users (name, email, first_name, last_name, bio, password, remember_token) 
318VALUES ('RicardoMoura','up00000003@fe.up.pt','Ricardo', 'Moura', NULL, 'KA523JUVNO98KEOC', NULL);
319
320INSERT INTO users (name, email, first_name, last_name, bio, password, remember_token) 
321VALUES ('JoaoGoncalves17','up00000004@fe.up.pt','João', 'Gonçalves', NULL, '627GH0UVNO98KEOC', NULL);
322
323INSERT INTO users (name, email, first_name, last_name, bio, password, remember_token) 
324VALUES ('psousa','up00000005@fe.up.pt','Pedro', 'Sousa', NULL, 'A27GH0UVNO98KEOC', NULL);
325
326INSERT INTO users (name, email, first_name, last_name, bio, password, remember_token) 
327VALUES ('JCanas','up00000006@fe.up.pt','João', 'Canas', NULL, 'A27GH0UVNO98KEOC', NULL);
328
329INSERT INTO users (name, email, first_name, last_name, bio, password, remember_token) 
330VALUES ('FAlves','up00000007@fe.up.pt','Fernando', 'Alves', NULL, 'B27GH0UVNO98KEOC', NULL);
331
332INSERT INTO users (name, email, first_name, last_name, bio, password, remember_token) 
333VALUES ('ACosta','up00000008@fe.up.pt','Ana', 'Costa', NULL, 'C27GH0UVNO98KEOC', NULL);
334
335INSERT INTO users (name, email, first_name, last_name, bio, password, remember_token) 
336VALUES ('SMendes','up00000009@fe.up.pt','Sara', 'Mendes', NULL, 'D27GH0UVNO98KEOC', NULL);
337
338INSERT INTO users (name, email, first_name, last_name, bio, password, remember_token) 
339VALUES ('JMota','up00000010@fe.up.pt','Joana', 'Mota', NULL, 'E27GH0UVNO98KEOC', NULL);
340
341INSERT INTO users (name, email, first_name, last_name, bio, password, remember_token) 
342VALUES ('APaelhas','up00000011@fe.up.pt','Alberto', 'Paelhas', NULL, 'F27GH0UVNO98KEOC', NULL);
343
344INSERT INTO users (name, email, first_name, last_name, bio, password, remember_token) 
345VALUES ('JAlb','up00000013@fe.up.pt','Joaquim', 'Alberto', NULL, 'F27GH0UVNO98KEOC', NULL);
346
347INSERT INTO users (name, email, first_name, last_name, bio, password, remember_token) 
348VALUES ('BrunoPer','up00000014@fe.up.pt','Bruno', 'Pereira', NULL, 'F27GH0UVNO98KEOC', NULL);
349
350/* courses */
351
352INSERT INTO courses ("name", acronym) 
353VALUES ('Master in Informatics and Computing Engineering','MIEIC');
354
355INSERT INTO courses ("name", acronym) 
356VALUES ('Master in Electrical and Computers Engineering','MIEEC');
357
358INSERT INTO courses ("name", acronym) 
359VALUES ('Master in Bioengineering','MIB');
360
361INSERT INTO courses ("name", acronym) 
362VALUES ('Master Degree in Medicine','MIMED');
363
364INSERT INTO courses ("name", acronym) 
365VALUES ('Master in Economic','ME');
366
367INSERT INTO courses ("name", acronym) 
368VALUES ('Master in Chemical Engineering','MIEQ');
369
370INSERT INTO courses ("name", acronym) 
371VALUES ('Master in Metallurgical and Materials Engineering','MIEMM');
372
373INSERT INTO courses ("name", acronym) 
374VALUES ('Master in Mechanical Engineering','MIEM');
375
376INSERT INTO courses ("name", acronym) 
377VALUES ('Master in Physical Engineering','MIEF');
378
379INSERT INTO courses ("name", acronym) 
380VALUES ('Master in Engineering and Industrial Management','MIEGI');
381
382/* course_units */
383
384INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
385VALUES ('Compilers','COMP','Provide concepts which allow to: understand the languages’ compilation phases, in particular for imperative and object-oriented (OO) languages; specify the syntax and semantics of a programming language; understand and use the data structures and the main algorithms used to implement compilers.',
386NULL, 4, 4.1, 4.2, 4.4, 1);
387
388INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
389VALUES ('Artificial Intelligence','IART','This courses provides a set of subjects (topics) that are the core of the Artificial Intelligence and Intelligent System area. The main objectives are: To know what characterizes and distinguishes AI and how to apply it. To know how to automatically represent, acquire, manipulate and apply knowledge using Computational Algorithms and Systems. To develop small projects using AI techniques. Percentual Distribution: Scientific component: 60%; Technological component: 40%',
390NULL, 3, 3.9, 4.2, 4.5, 1);
391
392INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
393VALUES ('Distributed Systems','SDIS','One of the most important recent developments in computing is the growth of distributed applications, as witnessed by the sheer number of Web-based applications, many of them mobile. This courses unit has to main objectives: give students theoretical knowledge on distributed systems so they can make correct decisions when confronted with the need to implement such a system; provide students with practical knowledge so they can develop applications taking into account potential advantages of distributed environments. Scientific: 50%; Technological: 50%',
394NULL, 2, 4.4, 4.5, 4.6, 1);
395
396INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
397VALUES ('Database and Web Applications Laboratory','LBAW','The unit aims at revisit the learning outcome of databases and web languages ​​and technologies, providing a practical perspective on this core areas of computer engineering. In this courses, the students will learn how to design and develop web-based information systems backed by database management systems.',
398NULL, 4, 4.2, 4.1, 4.0, 1);
399
400INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
401VALUES ('Object Oriented Programming Laboratory','LPOO','The unit aims at Develop and enhance object-oriented programming skills, using a modern object-oriented programming language (Java), representative of the languages used for developing application software; Developing object-oriented design skills, employing UML, and upholding good design principles and patterns; Learn to develop applications with graphical user interfaces (GUI) and usage of large software libraries; Acquire the habit of following good practices in software development (iterative development, unit testing, debugging, SCV, refactoring, pair programming, etc.). ',
402NULL, 3, 3.2, 4.3, 3.0, 1);
403
404INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
405VALUES ('Electronic 2','ELEC2','A primary objective of the courses, the continuation of Electronics 1 -- in which a wide range of subjects was covered in a relatively shallow depth -- is the analysis and design of IC multistage broadband amplifiers, both with CMOS or BJT technology. The frequency response of the amplifiers is addressed in detail. Feedback, its basic topologies, characteristics and stability and compensation issues are also analyzed. The study and analysis of characteristics for some typical topologies with both BJT and CMOS, but also with hybrids - BICMOS In sequence of the studies, the next step is to introduce digital circuits. The switching behavior of devices will be subject of analysis (switching from cut-off to conduction and vice-versa). A brief survey will be given on the different logic families, presenting not only the more recent, but as well as the others introduced in the past for a better perception of the reasons behind alterations suffered along the time.',
406NULL, 4, 4.2, 4.1, 4.0, 2);
407
408INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
409VALUES ('Bio Chemestry II','BCII','Branch of Biomedical Engineering biomedical instrumentation, processing and analysis of signals and biomedical images, medical devices (external and internal prosthesis), tissue engineering (namely regenerative medicine), telemedicine, bioinformatics, medical robotics (minimally invasive surgery) and bionics.',
410NULL, 2, 3.2, 4.3, 3.0, 3);
411
412INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
413VALUES ('Microeconomics I','MICI','The onjectives are  understanding some basic economic instruments and principles; applying those instruments and principles to some economic problems, mainly individual decision-making problems and market problems.',
414NULL, 2, 3.2, 4.3, 4.0, 5);
415
416INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
417VALUES ('Macroconomics I','MACI','The courses focuses on (i) basic concepts and measurement of the main macroeconomic variables, (ii) core models for short-term macroeconomic analysis, and (iii) microeconomic foundations for modelling private aggregate demand.',
418NULL, 3, 3.8, 4.2, 3.7, 5);
419
420INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
421VALUES ('Molecular Genetics', 'GMOL','The main objective of the UC “Molecular Genetics ” is to transmit student the more recent knowledge about the dynamics of the human genome and the mechanisms that allow molecular information transmission from DNA to protein.  Indeed, the syllabus is extensively dedicated to molecular mechanisms of maintenance of integrity of the genome, methodology employed for study, diagnostic and gene-based therapies.',
422NULL, 1, 3.2, 1.3, 4.0, 4);
423
424INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
425VALUES ('Morphophysiology of the Locomotor Apparatus','MAL','At the end of this courses unit, students should :Be acquainted with the general principles of Anatomy, Histology and Physiology. This courses unit will stimulate students’ observation skills by acquainting them with the anatomical, histological and physiological terminology. It will also endow them with description techniques, which will make them apply the adequate terminology;- Be acquainted with the normal structure, both macroscopic and microscopic and the normal function of the locomotor apparatus;To acquire a solid basis of knowledge that can be used in the different fields of morphophysiology, in other courses units and in upcoming clinical activities. ',
426NULL, 1, 4.2, 4.6, 5.0, 4);
427
428INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
429VALUES ('Computer Programming I','PC I','The aim of this courses is to provide students with fundamental knowledge about Information and Communication Technology (ICT) and, in particular, allow them to develop their skills in computer programming.',
430NULL, 1, 4.2, 4.6, 5.0, 10);
431
432INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
433VALUES ('Electronics 3','ELEC3','This curricular unit aims at empowering students with the competences of design and analysis of the main signal conditioning analogue and digital functions/modules, i. e., analogue sampling and multiplexing circuits, filters, tuned amplifiers, oscillators and multivibrators, PLL, A/D and D/A converters, and simple logic gates.  The theoretical study is complemented in the lab classes with the realization of simulation and experimental work, where the design and characterization of circuits is experienced and functional non-idealities are identified.',
434NULL, 1, 4.2, 4.6, 5.0, 2);
435
436INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
437VALUES ('Digital Signal Processing','PDSI','This courses aims at motivating students to the fundamental concepts, techniques and tools of analysis and design in Discrete-Time Signal Processing (PDS). A particular emphasis is given to specific topics, notably sampling and reconstruction of signals; the Z transform; the design and realization of digital FIR and IIR filters; the Discrete Fourier Transform (DFT), its properties and fast implementation alternatives (FFT); practical applications of the DFT including correlation studies and spectral analysis; and multirate signal processing combining decimation and interpolation. A related goal is to motivate students to laboratory experimentation comprising the design, testing and validation of practical solutions to selected challenges of discrete signal processing, by adotping an approach of "hands-on" and "learning-by-doing".',
438NULL, 1, 4.2, 4.6, 5.0, 2);
439
440INSERT INTO course_units ("name", acronym, "description", program, max_members_per_group, avg_complexity, avg_time_spent, avg_difficulty, id_course) 
441VALUES ('Principles of Telecommunications 1','FTEL1','This courses aims to acquaint students with technical knowledge on important aspects of analog and digital communications. At the same time, it also aims to develop students’ personal and professional skills. Two issues are addressed: Acquisition of technical knowledge: courses themes exposed in tutorial classes include digital transmission of information (quantization, baseband transmission, modulations, synchronization and noise effects in communications). Students will be able to choose the most adequate communication solution and predict problems caused by e.g. intersymbol interference or a high error rate probability. Students get familiar with these concepts in theoretical-practical classes and in laboratory classes; Development of personal and professional attitudes: Exercises and lab assignments contribute to develop students’ “engineering reasoning and problem solving” and “experimentation and knowledge discovery”.',
442NULL, 1, 4.2, 4.6, 5.0, 2);
443
444/* course_unitsUser */
445
446INSERT INTO course_unit_users (course_unit_id, user_id) 
447VALUES (1,2);
448
449INSERT INTO course_unit_users (course_unit_id, user_id) 
450VALUES (1,4);
451
452INSERT INTO course_unit_users (course_unit_id, user_id) 
453VALUES (2,6);
454
455INSERT INTO course_unit_users (course_unit_id, user_id) 
456VALUES (2,5);
457
458INSERT INTO course_unit_users (course_unit_id, user_id) 
459VALUES (2,9);
460
461INSERT INTO course_unit_users (course_unit_id, user_id) 
462VALUES (3,3);
463
464INSERT INTO course_unit_users (course_unit_id, user_id) 
465VALUES (3,7);
466
467INSERT INTO course_unit_users (course_unit_id, user_id) 
468VALUES (6,10);
469
470INSERT INTO course_unit_users (course_unit_id, user_id) 
471VALUES (6,13);
472
473INSERT INTO course_unit_users (course_unit_id, user_id) 
474VALUES (6,14);
475
476INSERT INTO course_unit_users (course_unit_id, user_id) 
477VALUES (7,11);
478
479INSERT INTO course_unit_users (course_unit_id, user_id) 
480VALUES (7,12);
481
482INSERT INTO course_unit_users (course_unit_id, user_id) 
483VALUES (4,16);
484
485INSERT INTO course_unit_users (course_unit_id, user_id) 
486VALUES (4,17);
487
488INSERT INTO course_unit_users (course_unit_id, user_id) 
489VALUES (4,18);
490
491INSERT INTO course_unit_users (course_unit_id, user_id) 
492VALUES (4,19);
493
494INSERT INTO course_unit_users (course_unit_id, user_id) 
495VALUES (5,16);
496
497INSERT INTO course_unit_users (course_unit_id, user_id) 
498VALUES (5,17);
499
500INSERT INTO course_unit_users (course_unit_id, user_id) 
501VALUES (5,18);
502
503INSERT INTO course_unit_users (course_unit_id, user_id) 
504VALUES (5,19);
505
506INSERT INTO course_unit_users (course_unit_id, user_id) 
507VALUES (8,8);
508
509INSERT INTO course_unit_users (course_unit_id, user_id) 
510VALUES (9,8);
511
512INSERT INTO course_unit_users (course_unit_id, user_id) 
513VALUES (8,10);
514
515INSERT INTO course_unit_users (course_unit_id, user_id) 
516VALUES (9,10);
517
518INSERT INTO course_unit_users (course_unit_id, user_id) 
519VALUES (10,11);
520
521INSERT INTO course_unit_users (course_unit_id, user_id) 
522VALUES (11,11);
523
524INSERT INTO course_unit_users (course_unit_id, user_id) 
525VALUES (10,12);
526
527INSERT INTO course_unit_users (course_unit_id, user_id) 
528VALUES (11,12);
529
530INSERT INTO course_unit_users (course_unit_id, user_id) 
531VALUES (13,10);
532
533INSERT INTO course_unit_users (course_unit_id, user_id) 
534VALUES (14,10);
535
536INSERT INTO course_unit_users (course_unit_id, user_id) 
537VALUES (15,10);
538
539/* faculties */
540
541INSERT INTO faculties ("name", acronym) 
542VALUES ('Faculty of Engineering of the University of Porto','FEUP');
543
544INSERT INTO faculties ("name", acronym) 
545VALUES ('Instituto de Ciências Biomédicas Abel Salazar','ICBAS');
546
547INSERT INTO faculties ("name", acronym) 
548VALUES ('Faculty of Medicine','FMUP');
549
550INSERT INTO faculties ("name", acronym) 
551VALUES ('Faculty of Economics','FEP');
552
553INSERT INTO faculties ("name", acronym) 
554VALUES ('Faculty of Architecture','FAUP');
555
556INSERT INTO faculties ("name", acronym) 
557VALUES ('Faculty of Dental Medicine','FMDUP');
558
559INSERT INTO faculties ("name", acronym) 
560VALUES ('Faculty of Fine Arts','FBAUP');
561
562INSERT INTO faculties ("name", acronym) 
563VALUES ('Faculty of Law','FDUP');
564
565INSERT INTO faculties ("name", acronym) 
566VALUES ('Faculty of Letters','FLUP');
567
568INSERT INTO faculties ("name", acronym) 
569VALUES ('Faculty of Nutrition and Food Science','FCNAUP');
570
571INSERT INTO faculties ("name", acronym) 
572VALUES ('Faculty of Pharmacy','FFUP');
573
574INSERT INTO faculties ("name", acronym) 
575VALUES ('Faculty of Psychology and Educational Sciences','FPCEUP');
576
577INSERT INTO faculties ("name", acronym) 
578VALUES ('Faculty of Sciences','FCUP');
579
580INSERT INTO faculties ("name", acronym) 
581VALUES ('Faculty of Sport','FADEUP');
582
583/* facultycourses */
584
585INSERT INTO faculty_courses (id_faculty, id_course) 
586VALUES (1,1);
587
588INSERT INTO faculty_courses (id_faculty, id_course) 
589VALUES (1,2);
590
591INSERT INTO faculty_courses (id_faculty, id_course) 
592VALUES (2,3);
593
594INSERT INTO faculty_courses (id_faculty, id_course) 
595VALUES (3,4);
596
597INSERT INTO faculty_courses (id_faculty, id_course) 
598VALUES (4,5);
599
600INSERT INTO faculty_courses (id_faculty, id_course) 
601VALUES (1,6);
602
603INSERT INTO faculty_courses (id_faculty, id_course) 
604VALUES (1,7);
605
606INSERT INTO faculty_courses (id_faculty, id_course) 
607VALUES (1,8);
608
609INSERT INTO faculty_courses (id_faculty, id_course) 
610VALUES (1,9);
611
612INSERT INTO faculty_courses (id_faculty, id_course) 
613VALUES (1,10);
614
615/* rooms */
616
617INSERT INTO rooms (designation, id_faculty) 
618VALUES ('B301', 1);
619
620INSERT INTO rooms (designation, id_faculty) 
621VALUES ('D302', 2);
622
623INSERT INTO rooms (designation, id_faculty) 
624VALUES ('B303', 1);
625
626INSERT INTO rooms (designation, id_faculty) 
627VALUES ('B332', 1);
628
629INSERT INTO rooms (designation, id_faculty) 
630VALUES ('H002', 3);
631
632INSERT INTO rooms (designation, id_faculty) 
633VALUES ('H005', 3);
634
635INSERT INTO rooms (designation, id_faculty) 
636VALUES ('105', 4);
637
638INSERT INTO rooms (designation, id_faculty) 
639VALUES ('115', 4);
640
641INSERT INTO rooms (designation, id_faculty) 
642VALUES ('215', 4);
643
644INSERT INTO rooms (designation, id_faculty) 
645VALUES ('123', 5);
646
647INSERT INTO rooms (designation, id_faculty) 
648VALUES ('A23', 6);
649
650INSERT INTO rooms (designation, id_faculty) 
651VALUES ('C3', 7);
652
653INSERT INTO rooms (designation, id_faculty) 
654VALUES ('Z1A', 8);
655
656INSERT INTO rooms (designation, id_faculty) 
657VALUES ('B302', 1);
658
659INSERT INTO rooms (designation, id_faculty) 
660VALUES ('B303', 1);
661
662INSERT INTO rooms (designation, id_faculty) 
663VALUES ('B304', 1);
664
665INSERT INTO rooms (designation, id_faculty) 
666VALUES ('B305', 1);
667
668INSERT INTO rooms (designation, id_faculty) 
669VALUES ('B306', 1);
670
671INSERT INTO rooms (designation, id_faculty) 
672VALUES ('B307', 1);
673
674/* event */
675
676INSERT INTO events ("name", "datetime", "description", id_course_unit, id_faculty, type) 
677VALUES ('Exame de COMP', '20180618 10:34:09 AM', 'The minimum note is 8.0 in a scale 0-20.', 1, 1, 'Exam');
678
679INSERT INTO events ("name", "datetime", "description", id_course_unit, id_faculty, type) 
680VALUES ('Exame de LPOO', '20181218 02:00:00 PM', 'The minimum note is 7.5 in a scale 0-20.', 1, 1, 'Exam');
681
682INSERT INTO events ("name", "datetime", "description", id_course_unit, id_faculty, type) 
683VALUES ('LBAW A1 Delivery', '20190308 08:00:00 PM', 'Deliver your project in a zip containing the source code and the relatory.', 1, 1, 'Delivery');
684
685INSERT INTO events ("name", "datetime", "description", id_course_unit, id_faculty, type) 
686VALUES ('LBAW A2 Delivery', '20190316 08:00:00 PM', 'Deliver your project in a zip containing the source code and the relatory.', 1, 1, 'Delivery');
687
688INSERT INTO events ("name", "datetime", "description", id_course_unit, id_faculty, type) 
689VALUES ('LBAW A3 Delivery', '20190322 08:00:00 PM', 'Deliver your project in a zip containing the source code and the relatory.', 1, 1, 'Delivery');
690
691INSERT INTO events ("name", "datetime", "description", id_course_unit, id_faculty, type) 
692VALUES ('LBAW A4 Delivery', '20190408 08:00:00 PM', 'Deliver your project in a zip containing the source code and the relatory.', 1, 1, 'Delivery');
693
694INSERT INTO events ("name", "datetime", "description", id_course_unit, id_faculty, type) 
695VALUES ('Bio Chemestry II Exam', '20190115 09:30:00 AM', 'The minimum note is 7.0 in a scale 0-20', 7, 2, 'Exam');
696
697INSERT INTO events ("name", "datetime", "description", id_course_unit, id_faculty, type) 
698VALUES ('MACI Mini-Test 1', '20190115 09:30:00 AM', 'The minimum note is 9.0 in a scale 0-20', 9, 4, 'Exam');
699
700INSERT INTO events ("name", "datetime", "description", id_course_unit, id_faculty, type) 
701VALUES ('MACI Mini-Test 2', '20190215 09:30:00 AM', 'The minimum note is 5.0 in a scale 0-20', 9, 4, 'Exam');
702
703INSERT INTO events ("name", "datetime", "description", id_course_unit, id_faculty, type) 
704VALUES ('MAL Delivery 1', '20190315 09:30:00 AM', 'Submit in a pdf format', 9, 4, 'Delivery');
705
706/* exam_rooms */
707
708INSERT INTO exam_rooms (id_event , id_room) 
709VALUES (1, 1);
710
711INSERT INTO exam_rooms (id_event , id_room) 
712VALUES (2, 4);
713
714INSERT INTO exam_rooms (id_event , id_room) 
715VALUES (7, 2);
716
717INSERT INTO exam_rooms (id_event , id_room) 
718VALUES (8, 7);
719
720INSERT INTO exam_rooms (id_event , id_room) 
721VALUES (9, 9);
722
723/* thread */
724
725INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
726VALUES (1, 1, 'EXAM', 'Do not exceed the absence limit and obtain a minimum of 40% in the project.', '20180718 10:34:09 AM');
727
728INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
729VALUES (1, 1, 'EXAM2', 'Exceed the absence limit and obtain a minimum of 10% in the Exam.', '20180818 10:34:09 AM');
730
731INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
732VALUES (3, 4, 'A1-Delivery', 'You can now submit your work. It has to be in a zip format containing only the code you wrote and the pdf with the report. Good Luck.', '20190306 10:34:09 AM');
733
734INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
735VALUES (3, 4, 'A2-Delivery', 'You can now submit your work. As in past, your submission has to be in a zip format containing only the code you wrote and the pdf with the report. Good Luck.', '20190316 10:00:00 AM');
736
737INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
738VALUES (1, 7, 'EXAM', 'Do not exceed the absence limit and obtain a minimum of 40% in the project.', '20180918 10:34:09 AM');
739
740INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
741VALUES (13, 4, 'A3-Delivery', 'You can now submit your work. As in past, your submission has to be in a zip format containing only the code you wrote and the pdf with the report. Good Luck.', '20190320 10:00:00 AM');
742
743INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
744VALUES (11, 4, 'A4-Delivery', 'You can now submit your work. As in past, your submission has to be in a zip format containing only the code you wrote and the pdf with the report. Good Luck.', '20190406 10:00:00 AM');
745
746INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
747VALUES (10, 4, 'A3: Using Loren ipsum', 'User interfaces of the prototype should resemble as much as possible the intended final product to be more effective. If you dont have plausible content just now, then you may use Loren.', '20190406 10:00:00 AM');
748
749INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
750VALUES (9, 4, 'A5: How to represent a PK', 'Notice how the problem was bypassed in the published template by using bold.', '20190406 10:00:00 AM');
751
752INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
753VALUES (20, 4, 'A6: Issue with inserts without a specific ID', 'Good evening, If anyone is having an error similar to "duplicate key violates unique constraint" while populating the database, in particular after inserting tuples to a table with specific IDs, and then trying to insert more without specifying an ID (assuming you have "Serial" in the key value), I found this post with an easy fix: https://stackoverflow.com/questions/4448340/postgresql-duplicate-key-violates-unique-constraint. Regards, Group 63', '20190406 10:00:00 AM');
754
755INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
756VALUES (10, 4, 'Install laravel/telescope', 'Dear students, If you want to make use of the "telescope" debug tool, you have to update Laravel to version 5.8 and then add laravel/telescope. Have a look at the attached file with our log. -- jlopes', '20190406 10:00:00 AM');
757
758INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
759VALUES (10, 4, 'LBAW Component gradings', 'Dear students, The grades of the component ER have been published in the Moodle Components Matrix. -- JCL', '20190406 10:00:00 AM');
760
761INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
762VALUES (10, 4, 'Custom Types', 'Dear Students, phpPgAdmin 5.1 installed in the machine (http://dbm.fe.up.pt/phppgadmin/) does not show "Types". Maybe it is better to use pgAdmin4 (https://www.pgadmin.org/) to get the interface shown in Joãos previous message, Actually, pgAdmin is the tool we provide, as a Docker container, in LBAWs framework (come to tomorrows lecture). -- jlopes', '20190406 10:00:00 AM');
763
764INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
765VALUES (10, 4, 'Changes to T3 Guide', 'Dear students, Please take into account that the T3 guide was slightly changed, namely the topics 7, 8 and 9 which were added or changed. Have a nice week.', '20190406 10:00:00 AM');
766
767INSERT INTO threads (author, course_unit_id, title, "text", "datetime") 
768VALUES (10, 4, 'Gradings T1', 'Dear students, You can consult in moodle the gradings obtained in assignment T1. Best regards, JPF', '20190406 10:00:00 AM');
769
770/* threadResponse */
771
772INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
773VALUES (17, 4, 'EXAM', 'Can it be delivered in a rar file?', '20190306 10:54:09 AM');
774
775INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
776VALUES (3, 4, 'EXAM2', 'No, it can not', '20190306 12:04:09 AM');
777
778INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
779VALUES (18, 1, 'Structure', 'Will the test be in the FEUP computers or do we need to bring ours?', '20180718 11:34:09 AM');
780
781INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
782VALUES (1, 1, 'EXAM', 'In the test you will be using FEUP computers, as usual.', '20190119 05:34:09 PM');
783
784INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
785VALUES (6, 4, 'IDK', 'Feel Bad', '20190307 12:00:09 AM');
786
787INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
788VALUES (14, 1, 'RE', 'rip.', '20190120 12:01:09 AM');
789
790INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
791VALUES (14, 2, 'RE', 'ok', '20190120 12:02:09 AM');
792
793INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
794VALUES (14, 3, 'RE', 'thanks', '20190120 12:03:09 AM');
795
796INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
797VALUES (1, 4, 'RE', 'ok', '20190120 12:04:09 AM');
798
799INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
800VALUES (2, 5, 'RE', 'ok', '20190120 12:05:09 AM');
801
802INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
803VALUES (3, 6, 'RE', 'ok', '20190120 12:05:09 AM');
804
805INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
806VALUES (4, 7, 'RE', 'wow', '20190120 12:05:09 AM');
807
808INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
809VALUES (5, 8, 'RE', 'ok', '20190120 12:05:09 AM');
810
811INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
812VALUES (6, 9, 'RE', 'hmmm', '20190120 12:05:09 AM');
813
814INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
815VALUES (7, 10, 'bot5', 'Imma spam5', '20190120 12:05:09 AM');
816
817INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
818VALUES (8, 11, 'bot5', 'Imma spam5', '20190120 12:05:09 AM');
819
820INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
821VALUES (9, 12, 'RE', 'thanks', '20190120 12:05:09 AM');
822
823INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
824VALUES (10, 13, 'RE', 'ok', '20190120 12:05:09 AM');
825
826INSERT INTO thread_responses (author, thread_id, title, "text", "datetime") 
827VALUES (11, 14, 'RE', 'nice', '20190120 12:05:09 AM');
828
829/* report */
830
831INSERT INTO reports (reporter, "datetime", reason, type, reported_user, reported_thread, reported_thread_response) 
832VALUES (8, '20190218 10:34:09 AM', 'Inappropriate', 'User', 9,NULL,NULL);
833
834INSERT INTO reports (reporter, "datetime", reason, type, reported_user, reported_thread, reported_thread_response) 
835VALUES (4, '20190223 10:00:09 PM', 'Inappropriate', 'User', 9,NULL,NULL);
836
837INSERT INTO reports (reporter, "datetime", reason, type, reported_user, reported_thread, reported_thread_response) 
838VALUES (3, '20190318 10:34:09 AM', 'Spam', 'Thread', NULL,4,NULL);
839
840INSERT INTO reports (reporter, "datetime", reason, type, reported_user, reported_thread, reported_thread_response) 
841VALUES (13, '20180724 05:34:09 AM', 'Spam', 'ThreadResponse', NULL,NULL,3);
842
843INSERT INTO reports (reporter, "datetime", reason, type, reported_user, reported_thread, reported_thread_response) 
844VALUES (12, '20180720 11:34:09 AM', 'Not relevant', 'ThreadResponse', NULL,NULL,3);
845
846INSERT INTO reports (reporter, "datetime", reason, type, reported_user, reported_thread, reported_thread_response, analysed) 
847VALUES (12, '20190218 10:34:09 AM', 'Offensive', 'User', 9,NULL,NULL,true);
848
849INSERT INTO reports (reporter, "datetime", reason, type, reported_user, reported_thread, reported_thread_response) 
850VALUES (2, '20190121 10:35:09 AM', 'Spam', 'ThreadResponse', NULL,NULL,5);
851
852INSERT INTO reports (reporter, "datetime", reason, type, reported_user, reported_thread, reported_thread_response) 
853VALUES (2, '20190121 10:36:09 AM', 'Spam', 'ThreadResponse', NULL,NULL,6);
854
855INSERT INTO reports (reporter, "datetime", reason, type, reported_user, reported_thread, reported_thread_response) 
856VALUES (2, '20190121 10:37:09 AM', 'Spam', 'ThreadResponse', NULL,NULL,7);
857
858INSERT INTO reports (reporter, "datetime", reason, type, reported_user, reported_thread, reported_thread_response) 
859VALUES (2, '20190121 10:38:09 AM', 'Spam', 'ThreadResponse', NULL,NULL,8);
860
861INSERT INTO reports (reporter, "datetime", reason, type, reported_user, reported_thread, reported_thread_response) 
862VALUES (2, '20190121 10:39:09 AM', 'Spam', 'ThreadResponse', NULL,NULL,9);
863
864INSERT INTO reports (reporter, "datetime", reason, type, reported_user, reported_thread, reported_thread_response) 
865VALUES (2, '20190121 10:40:09 AM', 'Spam', 'ThreadResponse', NULL,NULL,10);
866
867INSERT INTO reports (reporter, "datetime", reason, type, reported_user, reported_thread, reported_thread_response)
868VALUES (7, '20190121 10:44:09 AM', 'Spam', 'ThreadResponse', NULL,NULL,5);
869
870INSERT INTO reports (reporter, "datetime", reason, type, reported_user, reported_thread, reported_thread_response) 
871VALUES (7, '20190121 10:54:09 AM', 'Spam', 'ThreadResponse', NULL,NULL,6);
872
873/* workgroup */
874
875INSERT INTO workgroups (coordinator, course_unit_id, "year", number_members, is_active, is_group_request_active, is_banned)
876VALUES (8, 1, 2018,  2, FALSE,false,true);
877
878INSERT INTO workgroups (coordinator, course_unit_id, "year", number_members, is_active,is_group_request_active)
879VALUES (16, 4, 2019, 4, FALSE,  false);
880
881INSERT INTO workgroups (coordinator, course_unit_id, "year", number_members, is_active,is_group_request_active)
882VALUES (11, 11, 2019,1, FALSE,   false);
883
884INSERT INTO workgroups (coordinator, course_unit_id, "year",number_members, is_active, is_group_request_active)
885VALUES (12, 11, 2019, 1,  FALSE, false);
886
887INSERT INTO workgroups (coordinator, course_unit_id, "year", number_members, is_active,is_group_request_active)
888VALUES (2, 2, 2016, 3,  FALSE,false);
889
890INSERT INTO workgroups (coordinator, course_unit_id, "year", number_members, is_active,is_group_request_active)
891VALUES (1, 2, 2019, 3,  FALSE, false);
892
893
894/* workgroupCollaborator */
895
896INSERT INTO workgroup_collaborators (workgroup_id, user_id) 
897VALUES (1, 4);
898
899INSERT INTO workgroup_collaborators (workgroup_id, user_id) 
900VALUES (1, 2);
901
902INSERT INTO workgroup_collaborators (workgroup_id, user_id) 
903VALUES (1, 3);
904
905INSERT INTO workgroup_collaborators (workgroup_id, user_id) 
906VALUES (2, 17);
907
908INSERT INTO workgroup_collaborators (workgroup_id, user_id) 
909VALUES (2, 18);
910
911INSERT INTO workgroup_collaborators (workgroup_id, user_id) 
912VALUES (2, 19);
913
914INSERT INTO workgroup_collaborators (workgroup_id, user_id) 
915VALUES (3, 1);
916
917INSERT INTO workgroup_collaborators (workgroup_id, user_id) 
918VALUES (5, 14);
919
920INSERT INTO workgroup_collaborators (workgroup_id, user_id) 
921VALUES (5, 15);
922
923/* taskGroup */
924
925INSERT INTO taskgroups (id_workgroup, title, "description") 
926VALUES (1, 'Delivery1', 'Mockups');
927
928INSERT INTO taskgroups (id_workgroup, title, "description") 
929VALUES (2, 'A1', 'Project presentation');
930
931INSERT INTO taskgroups (id_workgroup, title, "description") 
932VALUES (2, 'A2', 'Actors and User stories');
933
934INSERT INTO taskgroups (id_workgroup, title, "description") 
935VALUES (2, 'A3', 'User Interfaces Design');
936
937INSERT INTO taskgroups (id_workgroup, title, "description") 
938VALUES (2, 'A4', 'Implementation of the user interfaces');
939
940INSERT INTO taskgroups (id_workgroup, title, "description") 
941VALUES (3, 'Delivery1', 'Mockups');
942
943INSERT INTO taskgroups (id_workgroup, title, "description") 
944VALUES (3, 'Delivery2', 'Work');
945
946INSERT INTO taskgroups (id_workgroup, title, "description") 
947VALUES (4, 'Delivery1', 'Mockups');
948
949INSERT INTO taskgroups (id_workgroup, title, "description") 
950VALUES (4, 'Delivery2', 'Work');
951
952INSERT INTO taskgroups (id_workgroup, title, "description") 
953VALUES (5, 'SONG1', 'MUSIC');
954
955INSERT INTO taskgroups (id_workgroup, title, "description") 
956VALUES (5, 'SONG2', 'MUSIC');
957
958INSERT INTO taskgroups (id_workgroup, title, "description") 
959VALUES (5, 'Album', 'MUSIC');
960
961/* task */
962
963INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
964VALUES (1, 'homepage', 'High', 'To do', 1);
965
966INSERT INTO tasks (id_taskgroup,  title, "priority", last_user_to_update) 
967VALUES (2, 'Work Description', 'High', 17);
968
969INSERT INTO tasks (id_taskgroup,  title, "priority", last_user_to_update) 
970VALUES (3, 'Actors', 'Medium', 16);
971
972INSERT INTO tasks (id_taskgroup,  title, "priority", last_user_to_update) 
973VALUES (3, 'User Stories', 'High', 18);
974
975INSERT INTO tasks (id_taskgroup,  title, "priority", last_user_to_update) 
976VALUES (3, 'Annex: Supplementary requirements', 'Low', 19);
977
978INSERT INTO tasks (id_taskgroup,  title, "priority", last_user_to_update) 
979VALUES (4, 'Interface and common features', 'High', 16);
980
981INSERT INTO tasks (id_taskgroup,  title, "priority", last_user_to_update) 
982VALUES (4, 'Sitemap', 'High', 17);
983
984INSERT INTO tasks (id_taskgroup,  title, "priority", last_user_to_update) 
985VALUES (4, 'Storyboards', 'Medium', 18);
986
987INSERT INTO tasks (id_taskgroup,  title, "priority", last_user_to_update) 
988VALUES (4, 'Interfaces', 'High', 19);
989
990INSERT INTO tasks (id_taskgroup,  title, "priority", last_user_to_update) 
991VALUES (4, 'Code Development', 'High', 18);
992
993INSERT INTO tasks (id_taskgroup,  title, "priority", last_user_to_update) 
994VALUES (5, 'Conceptual Data Model', 'High', 17);
995
996INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
997VALUES (6, 'mockup', 'High', 'To do', 11);
998
999INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1000VALUES (7, 'draw', 'Medium', 'To do', 11);
1001
1002INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1003VALUES (7, 'implement', 'High', 'To do', 11);
1004
1005INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1006VALUES (8, 'mockup', 'High', 'To do', 12);
1007
1008INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1009VALUES (9, 'Introduction', 'Low', 'To do', 12);
1010
1011INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1012VALUES (9, 'draw+implement', 'High', 'To do', 12);
1013
1014INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1015VALUES (9, 'Conclusion', 'Medium', 'To do', 12);
1016
1017INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1018VALUES (8, 'populate', 'Medium', 'To do', 12);
1019
1020INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1021VALUES (6, 'populate', 'Medium', 'To do', 11);
1022
1023INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1024VALUES (7, 'Conclusion', 'Low', 'To do', 11);
1025
1026INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1027VALUES (7, 'Conclusion', 'Low', 'To do', 11);
1028
1029INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1030VALUES (10, 'Lyrics', 'Low', 'To do', 15);
1031
1032INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1033VALUES (10, 'Beat', 'High', 'To do', 14);
1034
1035INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1036VALUES (11, 'Lyrics', 'High', 'To do', 2);
1037
1038INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1039VALUES (11, 'Beat', 'Low', 'To do', 2);
1040
1041INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1042VALUES (12, 'Production', 'High', 'To do', 14);
1043
1044INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1045VALUES (12, 'Publicity', 'Medium', 'To do', 2);
1046
1047INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1048VALUES (12, 'Label', 'High', 'To do', 15);
1049
1050INSERT INTO tasks (id_taskgroup,  title, "priority", "status", last_user_to_update) 
1051VALUES (12, 'Release-Date', 'Low', 'To do', 2);
1052/* taskResponsible */
1053
1054INSERT INTO task_responsible(id_task, id_user) 
1055VALUES (1, 1);
1056
1057INSERT INTO task_responsible(id_task, id_user) 
1058VALUES (2, 19);
1059
1060INSERT INTO task_responsible(id_task, id_user) 
1061VALUES (3, 18);
1062
1063INSERT INTO task_responsible(id_task, id_user) 
1064VALUES (4, 16);
1065
1066INSERT INTO task_responsible(id_task, id_user) 
1067VALUES (5, 17);
1068
1069INSERT INTO task_responsible(id_task, id_user) 
1070VALUES (6, 18);
1071
1072INSERT INTO task_responsible(id_task, id_user) 
1073VALUES (7, 17);
1074
1075INSERT INTO task_responsible(id_task, id_user) 
1076VALUES (8, 19);
1077
1078INSERT INTO task_responsible(id_task, id_user) 
1079VALUES (9, 16);
1080
1081INSERT INTO task_responsible(id_task, id_user) 
1082VALUES (10, 16);
1083
1084INSERT INTO task_responsible(id_task, id_user) 
1085VALUES (10, 17);
1086
1087INSERT INTO task_responsible(id_task, id_user) 
1088VALUES (10, 18);
1089
1090INSERT INTO task_responsible(id_task, id_user) 
1091VALUES (10, 19);
1092
1093INSERT INTO task_responsible(id_task, id_user) 
1094VALUES (11, 17);
1095
1096INSERT INTO task_responsible(id_task, id_user) 
1097VALUES (12, 11);
1098
1099INSERT INTO task_responsible(id_task, id_user) 
1100VALUES (13, 11);
1101
1102INSERT INTO task_responsible(id_task, id_user) 
1103VALUES (14, 11);
1104
1105INSERT INTO task_responsible(id_task, id_user) 
1106VALUES (15, 12);
1107
1108INSERT INTO task_responsible(id_task, id_user) 
1109VALUES (16, 12);
1110
1111INSERT INTO task_responsible(id_task, id_user) 
1112VALUES (17, 12);
1113
1114INSERT INTO task_responsible(id_task, id_user) 
1115VALUES (18, 12);
1116
1117INSERT INTO task_responsible(id_task, id_user) 
1118VALUES (19, 12);
1119
1120INSERT INTO task_responsible(id_task, id_user) 
1121VALUES (20, 11);
1122
1123INSERT INTO task_responsible(id_task, id_user) 
1124VALUES (21, 11);
1125
1126INSERT INTO task_responsible(id_task, id_user) 
1127VALUES (22, 11);
1128
1129INSERT INTO task_responsible(id_task, id_user) 
1130VALUES (23, 2);
1131
1132INSERT INTO task_responsible(id_task, id_user) 
1133VALUES (24, 2);
1134
1135INSERT INTO task_responsible(id_task, id_user) 
1136VALUES (25, 15);
1137
1138INSERT INTO task_responsible(id_task, id_user) 
1139VALUES (26, 2);
1140
1141INSERT INTO task_responsible(id_task, id_user) 
1142VALUES (27, 2);
1143
1144INSERT INTO task_responsible(id_task, id_user) 
1145VALUES (28, 14);
1146
1147INSERT INTO task_responsible(id_task, id_user) 
1148VALUES (29, 14);
1149
1150INSERT INTO task_responsible(id_task, id_user) 
1151VALUES (30, 15);
1152
1153/* subscribedUserTask */
1154
1155INSERT INTO subscribed_user_tasks(id_user, id_task) 
1156VALUES (1, 1);
1157
1158INSERT INTO subscribed_user_tasks(id_user, id_task) 
1159VALUES (16, 3);
1160
1161INSERT INTO subscribed_user_tasks(id_user, id_task) 
1162VALUES (16, 2);
1163
1164INSERT INTO subscribed_user_tasks(id_user, id_task) 
1165VALUES (16, 5);
1166
1167INSERT INTO subscribed_user_tasks(id_user, id_task) 
1168VALUES (16, 10);
1169
1170INSERT INTO subscribed_user_tasks(id_user, id_task) 
1171VALUES (17, 10);
1172
1173INSERT INTO subscribed_user_tasks(id_user, id_task) 
1174VALUES (17, 3);
1175
1176INSERT INTO subscribed_user_tasks(id_user, id_task) 
1177VALUES (17, 6);
1178
1179INSERT INTO subscribed_user_tasks(id_user, id_task) 
1180VALUES (18, 10);
1181
1182INSERT INTO subscribed_user_tasks(id_user, id_task) 
1183VALUES (18, 11);
1184
1185INSERT INTO subscribed_user_tasks(id_user, id_task) 
1186VALUES (18, 9);
1187
1188INSERT INTO subscribed_user_tasks(id_user, id_task) 
1189VALUES (18, 5);
1190
1191INSERT INTO subscribed_user_tasks(id_user, id_task) 
1192VALUES (19, 10);
1193
1194INSERT INTO subscribed_user_tasks(id_user, id_task) 
1195VALUES (19, 3);
1196
1197INSERT INTO subscribed_user_tasks(id_user, id_task) 
1198VALUES (19, 2);
1199
1200INSERT INTO subscribed_user_tasks(id_user, id_task) 
1201VALUES (11, 12);
1202
1203INSERT INTO subscribed_user_tasks(id_user, id_task) 
1204VALUES (11, 14);
1205
1206INSERT INTO subscribed_user_tasks(id_user, id_task) 
1207VALUES (12, 15);
1208
1209INSERT INTO subscribed_user_tasks(id_user, id_task) 
1210VALUES (12, 16);
1211
1212INSERT INTO subscribed_user_tasks(id_user, id_task) 
1213VALUES (12, 18);
1214
1215/* log */
1216
1217INSERT INTO logs ("datetime", id_user, id_task, type) 
1218VALUES ('20190218 10:34:09 AM', 1,1, 'create');
1219
1220INSERT INTO logs ("datetime", id_user, id_task, type) 
1221VALUES ('20190325 10:34:09 AM', 17,10, 'create');
1222
1223INSERT INTO logs ("datetime", id_user, id_task, type) 
1224VALUES ('20190327 10:15:00 PM', 19,10, 'statusChange');
1225
1226INSERT INTO logs ("datetime", id_user, id_task, type) 
1227VALUES ('20190330 10:34:09 AM', 16,6, 'create');
1228
1229INSERT INTO logs ("datetime", id_user, id_task, type) 
1230VALUES ('20190305 10:34:09 AM', 17,11, 'create');
1231
1232INSERT INTO logs ("datetime", id_user, id_task, type) 
1233VALUES ('20190305 12:34:09 AM', 11, 12, 'create');
1234
1235INSERT INTO logs ("datetime", id_user, id_task, type) 
1236VALUES ('20190305 12:34:09 AM', 11, 12, 'statusChange');
1237
1238INSERT INTO logs ("datetime", id_user, id_task, type) 
1239VALUES ('20190310 12:34:09 AM', 11, 12, 'statusChange');
1240
1241INSERT INTO logs ("datetime", id_user, id_task, type) 
1242VALUES ('20190310 12:04:09 AM', 12, 16, 'create');
1243
1244INSERT INTO logs ("datetime", id_user, id_task, type) 
1245VALUES ('20190315 12:04:09 AM', 12, 18, 'create');
1246
1247/* notification */
1248
1249INSERT INTO notifications (id_log, id_user)
1250VALUES (1, 1);
1251
1252INSERT INTO notifications (id_log, id_user)
1253VALUES (2, 16);
1254
1255INSERT INTO notifications (id_log, id_user)
1256VALUES (2, 17);
1257
1258INSERT INTO notifications (id_log, id_user)
1259VALUES (2, 18);
1260
1261INSERT INTO notifications (id_log, id_user)
1262VALUES (3, 16);
1263
1264INSERT INTO notifications (id_log, id_user)
1265VALUES (3, 17);
1266
1267INSERT INTO notifications (id_log, id_user)
1268VALUES (3, 18);
1269
1270INSERT INTO notifications (id_log, id_user)
1271VALUES (3, 19);
1272
1273INSERT INTO notifications (id_log, id_user)
1274VALUES (5, 18);
1275
1276INSERT INTO notifications (id_log, id_user)
1277VALUES (4, 19);
1278
1279INSERT INTO notifications (id_log, id_user)
1280VALUES (6, 11);
1281
1282INSERT INTO notifications (id_log, id_user)
1283VALUES (7, 11);
1284
1285INSERT INTO notifications (id_log, id_user)
1286VALUES (8, 11);
1287
1288INSERT INTO notifications (id_log, id_user)
1289VALUES (9, 12);
1290
1291INSERT INTO notifications (id_log, id_user)
1292VALUES (10, 12);
1293
1294/* invite */
1295
1296INSERT INTO invites(author, id_workgroup, invited_user, "status") 
1297VALUES (8, 1, 3,'Accepted');
1298
1299INSERT INTO invites(author, id_workgroup, invited_user, "status") 
1300VALUES (8, 1, 5,'Pending');
1301
1302INSERT INTO invites(author, id_workgroup, invited_user, "status") 
1303VALUES (8, 1, 9,'Pending');
1304
1305INSERT INTO invites(author, id_workgroup, invited_user, "status") 
1306VALUES (16, 1, 19,'Accepted');
1307
1308INSERT INTO invites(author, id_workgroup, invited_user, "status") 
1309VALUES (16, 1, 4,'Rejected');
1310
1311INSERT INTO invites(author, id_workgroup, invited_user, "status") 
1312VALUES (16, 1, 7,'Rejected');
1313
1314INSERT INTO invites(author, id_workgroup, invited_user, "status") 
1315VALUES (17, 2, 3,'Rejected');
1316
1317/* course_unitsVote */
1318
1319INSERT INTO course_unit_votes(id_user, id_course_unit, complexity, time_spent, difficulty) 
1320VALUES (3, 3, 5.0, 4.2, 4.3);
1321
1322INSERT INTO course_unit_votes(id_user, id_course_unit, complexity, time_spent, difficulty) 
1323VALUES (17, 4, 2.0, 2.2, 1.3);
1324
1325INSERT INTO course_unit_votes(id_user, id_course_unit, complexity, time_spent, difficulty) 
1326VALUES (18, 4, 5.0, 4.5, 2.3);
1327
1328INSERT INTO course_unit_votes(id_user, id_course_unit, complexity, time_spent, difficulty) 
1329VALUES (17, 4, 2.6, 3.1, 3.3);
1330
1331INSERT INTO course_unit_votes(id_user, id_course_unit, complexity, time_spent, difficulty) 
1332VALUES (19, 4, 3.0, 2.2, 3.9);
1333
1334/* groupRequestRespondent */
1335
1336INSERT INTO group_request_respondents (id_user, id_workgroup)
1337VALUES (1, 1);
1338
1339INSERT INTO group_request_respondents (id_user, id_workgroup)
1340VALUES (3, 1);
1341
1342INSERT INTO group_request_respondents (id_user, id_workgroup)
1343VALUES (7, 1);
1344
1345INSERT INTO group_request_respondents (id_user, id_workgroup)
1346VALUES (7, 2);
1347
1348INSERT INTO group_request_respondents (id_user, id_workgroup)
1349VALUES (3, 2);
1350
1351INSERT INTO group_request_respondents (id_user, id_workgroup)
1352VALUES (4, 2);
1353
1354INSERT INTO group_request_respondents (id_user, id_workgroup)
1355VALUES (19, 2);
1356
1357/* BANNED */
1358
1359INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
1360VALUES ('JuliaHa','jhmaa@gmail.com','Julia', 'Holter', 'JuliaH.jpg', NULL, 'BYHOGUOG8723EJU', true, FALSE, FALSE, NULL);
1361
1362INSERT INTO users (name, email, first_name, last_name , image, bio, password, is_banned, is_admin, is_regent, remember_token) 
1363VALUES ('Flumea','flumeaInTheHouse@gmail.com','Harley', 'Streten', 'Flume.jpg', 'Hi this is Flume', 'HIHGIGUOV5657K7', true, FALSE, FALSE, NULL);
1364
1365
1366INSERT INTO threads (author, course_unit_id, title, "text", "datetime",is_deactivated) 
1367VALUES (1, 1, 'EXAM', 'Do not exceed the absence limit and obtain a minimum of 40% in the project.', '20180718 10:34:09 AM',true);
1368
1369INSERT INTO threads (author, course_unit_id, title, "text", "datetime",is_deactivated) 
1370VALUES (1, 1, 'EXAM2', 'Exceed the absence limit and obtain a minimum of 10% in the Exam.', '20180818 10:34:09 AM',true);
1371
1372
1373INSERT INTO workgroups (coordinator, course_unit_id, "year", number_members, is_active, is_group_request_active, is_banned)
1374VALUES (8, 1, 2018,  2, FALSE,false,true);
1375
1376INSERT INTO workgroups (coordinator, course_unit_id, "year", number_members, is_active,is_group_request_active,is_banned)
1377VALUES (16, 4, 2019, 4, FALSE, false,true);