BQi0Y67A

· 7 years ago · Jan 03, 2019, 08:48 PM
1-- Drop tables --
2DROP TABLE IF EXISTS role_icon CASCADE;
3DROP TABLE IF EXISTS status CASCADE;
4DROP TABLE IF EXISTS users_role CASCADE;
5DROP TABLE IF EXISTS users_status CASCADE;
6DROP TABLE IF EXISTS functionality_role CASCADE;
7DROP TABLE IF EXISTS menu CASCADE;
8DROP TABLE IF EXISTS functionality CASCADE;
9DROP TABLE IF EXISTS module CASCADE;
10DROP TABLE IF EXISTS users CASCADE;
11DROP TABLE IF EXISTS role CASCADE;
12
13-- Generate tables structure --
14CREATE TABLE status(
15	id SERIAL NOT NULL PRIMARY KEY,
16	description TEXT NOT NULL
17);
18
19CREATE TABLE users(
20	id SERIAL NOT NULL PRIMARY KEY,
21	name TEXT NOT NULL,
22	surname TEXT NOT NULL,
23	mail TEXT NOT NULL,
24	password TEXT NULL
25);
26
27CREATE TABLE users_status(
28	id SERIAL NOT NULL PRIMARY KEY,
29	users_id INT NOT NULL,
30	status_id INT NOT NULL,
31	fecha_inicio TIMESTAMP default current_timestamp NOT NULL,
32	fecha_fin TIMESTAMP NULL,
33	FOREIGN KEY (users_id) REFERENCES users(id),
34	FOREIGN KEY (status_id) REFERENCES status(id) 
35);
36
37CREATE TABLE role_icon(
38	id SERIAL NOT NULL PRIMARY KEY,
39	icon TEXT NOT NULL
40);
41
42CREATE TABLE role(
43	id SERIAL NOT NULL PRIMARY KEY,
44	description TEXT NOT NULL,
45	role_icon_id INT NOT NULL,
46	FOREIGN KEY (role_icon_id) REFERENCES role_icon(id)
47);
48
49CREATE TABLE module(
50	id SERIAL NOT NULL PRIMARY KEY,
51	description TEXT NOT NULL
52);
53
54CREATE TABLE users_role(
55	id SERIAL NOT NULL PRIMARY KEY,
56	users_id INT NOT NULL,
57	role_id INT NOT NULL,
58	FOREIGN KEY (role_id) REFERENCES role(id),
59	FOREIGN KEY (users_id) REFERENCES users(id) 
60);
61
62CREATE TABLE menu(
63	id SERIAL NOT NULL PRIMARY KEY,
64	description TEXT NOT NULL,
65	route TEXT NULL,
66	module_id INT NULL,
67	menu_id INT NULL,
68	FOREIGN KEY (module_id) REFERENCES module(id),
69	FOREIGN KEY (menu_id) REFERENCES menu(id)
70);
71
72CREATE TABLE functionality(
73	id SERIAL NOT NULL PRIMARY KEY,
74	description TEXT NOT NULL,
75	module_id INT NOT NULL,
76	menu_id INT NULL,
77	FOREIGN KEY (module_id) REFERENCES module(id),
78	FOREIGN KEY (menu_id) REFERENCES menu(id)
79);
80
81CREATE TABLE functionality_role(
82	id SERIAL NOT NULL PRIMARY KEY,
83	functionality_id INT NOT NULL,
84	role_id INT NOT NULL,
85	FOREIGN KEY (role_id) REFERENCES role(id),
86	FOREIGN KEY (functionality_id) REFERENCES functionality(id) 
87);
88
89-- Generate inserts --
90
91-- Role icon -- 
92INSERT INTO "role_icon" ("icon") VALUES ('data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iaXNvLTg4NTktMSI/Pg0KPCEtLSBHZW5lcmF0b3I6IEFkb2JlIElsbHVzdHJhdG9yIDE5LjAuMCwgU1ZHIEV4cG9ydCBQbHVnLUluIC4gU1ZHIFZlcnNpb246IDYuMDAgQnVpbGQgMCkgIC0tPg0KPHN2ZyB2ZXJzaW9uPSIxLjEiIGlkPSJMYXllcl8xIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHhtbG5zOnhsaW5rPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5L3hsaW5rIiB4PSIwcHgiIHk9IjBweCINCgkgdmlld0JveD0iMCAwIDUxMi4wNDUgNTEyLjA0NSIgc3R5bGU9ImVuYWJsZS1iYWNrZ3JvdW5kOm5ldyAwIDAgNTEyLjA0NSA1MTIuMDQ1OyIgeG1sOnNwYWNlPSJwcmVzZXJ2ZSI+DQo8Zz4NCgk8Zz4NCgkJPHJlY3QgeD0iMTk5LjgwNCIgeT0iMzEyLjA0NCIgc3R5bGU9ImZpbGw6I0ZDQjQ3RTsiIHdpZHRoPSIxMTIiIGhlaWdodD0iMTA0Ii8+DQoJPC9nPg0KCTxnPg0KCQk8cGF0aCBzdHlsZT0iZmlsbDojNDI5NkQ5OyIgZD0iTTI4OC4wMjQsNDE3Ljk4OWMtMTkuMjM2LDEyLjIzMS0zMi4wMDEsMTQuMDU1LTMyLjAwMSwxNC4wNTVzLTEyLjc2Mi0xLjgyMy0zMS45OTQtMTQuMDUNCgkJCWMwLDAtMTEuNTU4LTI5LjI4My04LjIyNS0yNS45NWMzLjMzMywzLjMzMyw0MC4yMTksMCw0MC4yMTksMGwzMS43ODEsOEwyODguMDI0LDQxNy45ODl6Ii8+DQoJPC9nPg0KCTxnPg0KCQk8cGF0aCBzdHlsZT0iZmlsbDojOTk2NDU5OyIgZD0iTTM1MS44MDQsMzUyLjA0NGw4My4yNjQsMTQuMDIzYzMzLjUyNSw5LjM5Myw1Mi45NTUsNDIuMjk3LDUyLjk1NSw3My4xMnY1MS44NDINCgkJCWMwLDExLjYwNi0xMC43NDUsMjEuMDE1LTI0LDIxLjAxNWgtNDE2Yy0xMy4yNTUsMC0yNC05LjQwOS0yNC0yMS4wMTV2LTUxLjg0MmMwLTMwLjgyMywxOS40My02My43MjcsNTIuOTU1LTczLjEybDgyLjgyNi0xNC4wMjMNCgkJCWw5Ni4yMTksNDBMMzUxLjgwNCwzNTIuMDQ0eiIvPg0KCTwvZz4NCgk8Zz4NCgkJPHBhdGggc3R5bGU9ImZpbGw6IzdFNUM2MjsiIGQ9Ik0xMjIuNiwzNTguMzQzYzAuMTI0LDAuMjU2LDAuMTIzLDAuNTUsMC4yNzUsMC43OTRjNjAuODIsOTguMDc4LDEyMC4wMzEsMTExLjA0NywxMjYuNTc4LDExMi4xOTUNCgkJCWw1LjE4LDAuOTE0YzAuNDYxLDAuMDg2LDAuOTIyLDAuMTI1LDEuMzkxLDAuMTI1YzAuNDY5LDAsMC45My0wLjAzOSwxLjM5MS0wLjEyNWw1LjE4LTAuOTE0DQoJCQljNi41NDctMS4xNDgsNjUuNzU4LTE0LjExNywxMjYuNTc4LTExMi4xOTVjMC4xNDUtMC4yMzMsMC4xMzktMC41MTMsMC4yNTgtMC43NTdsLTM3LjYyNS02LjMzN2wtOTUuNzgxLDQwbC05Ni4yMTktNDANCgkJCUwxMjIuNiwzNTguMzQzeiIvPg0KCTwvZz4NCgk8Zz4NCgkJPHBhdGggc3R5bGU9ImZpbGw6IzRCQjlFQzsiIGQ9Ik0xODQuMDI0LDMxMi4wNDRsLTMwLjE5OCw0MGw0OC43NjYsNzEuOTgyYzIuODE4LDQuMTU5LDguNzI3LDQuNzIyLDEyLjI4LDEuMTdsNDEuMTUyLTMzLjE1Mg0KCQkJTDE4NC4wMjQsMzEyLjA0NHoiLz4NCgk8L2c+DQoJPGc+DQoJCTxwYXRoIHN0eWxlPSJmaWxsOiM0QkI5RUM7IiBkPSJNMzI4LjAyMywzMTIuMDQ0bDMwLjE5OCw0MGwtNDguNzY2LDcxLjk4MmMtMi44MTgsNC4xNTktOC43MjcsNC43MjItMTIuMjgsMS4xN2wtNDEuMTUyLTMzLjE1Mg0KCQkJTDMyOC4wMjMsMzEyLjA0NHoiLz4NCgk8L2c+DQoJPGc+DQoJCTxwYXRoIHN0eWxlPSJmaWxsOiNGRkRDQUQ7IiBkPSJNMzY4LjIxMiwxNzQuNTY0bC0xNi4xODgtMzguNTJjMCwwLTcwLTM4LjY2Ny0xODQtMjRoLTAuMjE5Yy0yMC40NjIsMjUuODI3LTMyLDU3LjU1LTMyLDk2DQoJCQljMCw3OS41MjksNTMuNzI2LDE0NCwxMjAsMTQ0czEyMC02NC40NzEsMTIwLTE0NGMwLTEyLjkwNi0xLjU0OC0yNS4zNTItNC4yMDItMzcuMjUzDQoJCQlDMzY5LjUzMiwxNzMuMTA1LDM2OC4yMTIsMTc0LjU2NCwzNjguMjEyLDE3NC41NjR6Ii8+DQoJPC9nPg0KCTxnPg0KCQk8Y2lyY2xlIHN0eWxlPSJmaWxsOiNBRUVGRkY7IiBjeD0iMjA3LjgwNCIgY3k9IjIwOC4wNDQiIHI9IjMyIi8+DQoJPC9nPg0KCTxnPg0KCQk8cGF0aCBzdHlsZT0iZmlsbDojRkZGRkZGOyIgZD0iTTIwNy44MDQsMTc2LjA0NGMtOC43OCwwLTE2LjcyNiwzLjU0Ny0yMi41MDcsOS4yNzNsNDUuMjM0LDQ1LjIzNA0KCQkJYzUuNzI3LTUuNzgyLDkuMjczLTEzLjcyNyw5LjI3My0yMi41MDdDMjM5LjgwNCwxOTAuMzcxLDIyNS40NzgsMTc2LjA0NCwyMDcuODA0LDE3Ni4wNDR6Ii8+DQoJPC9nPg0KCTxnPg0KCQk8Y2lyY2xlIHN0eWxlPSJmaWxsOiNBRUVGRkY7IiBjeD0iMzAzLjgwNCIgY3k9IjIwOC4wNDQiIHI9IjMyIi8+DQoJPC9nPg0KCTxnPg0KCQk8cGF0aCBzdHlsZT0iZmlsbDojRkZGRkZGOyIgZD0iTTMwNC4wMjMsMTc2LjA0NGMtOC43OCwwLTE2LjcyNiwzLjU0Ny0yMi41MDcsOS4yNzNsNDUuMjM0LDQ1LjIzNA0KCQkJYzUuNzI3LTUuNzgyLDkuMjczLTEzLjcyNyw5LjI3My0yMi41MDdDMzM2LjAyMywxOTAuMzcxLDMyMS42OTcsMTc2LjA0NCwzMDQuMDIzLDE3Ni4wNDR6Ii8+DQoJPC9nPg0KCTxnPg0KCQk8cGF0aCBzdHlsZT0iZmlsbDojN0U1QzYyOyIgZD0iTTM4My4zNDMsMjAuODE4Yy0xLjQzOC0zLjI4MS00Ljg1Mi01LjE4Ny04LjQ1My00LjY5NWMtMjAuMDQ3LDIuODk4LTQ0LjM1Mi0yLjAxNi03MC4wNjMtNy4xNzINCgkJCWMtNDMuMTI1LTguNjU2LTg3LjY5NS0xNy42MDktMTIyLjUzOSw3LjI1Yy0wLjUwOC0wLjEwMi0xLjAzOS0wLjE1Ni0xLjU4Ni0wLjE1NmMtMzUuNzI3LDAtNjAuNjgsMjkuNjA5LTYwLjY4LDcyDQoJCQljMCwzNC41MjMsMTUuMzA1LDEwMC41NDcsMTUuOTYxLDEwMy4zNDRjMC44MiwzLjUwOCwzLjg5MSw2LjAzOSw3LjQ5Miw2LjE3MmMwLjEwMiwwLjAwOCwwLjIwMywwLjAwOCwwLjI5NywwLjAwOA0KCQkJYzMuNDg0LDAsNi41ODYtMi4yNjYsNy42MzMtNS42MDlsMjIuNzExLTcyLjYwMmM5NS41MzktMTEuMDM5LDE1OC44OTgsMTYuMzQ0LDE3MS42NzIsMjIuNWwxNS4wNDcsMzUuODEyDQoJCQljMS4yOTcsMy4wNzgsNC4zNzUsNS4yMDMsNy43MjcsNC44OTFjMy4zNTItMC4xNDgsNi4yNS0yLjM2Nyw3LjI3My01LjU2M0MzOTkuODEyLDEwMS44NTcsMzkxLjAzMSwzOC4yODYsMzgzLjM0MywyMC44MTh6Ii8+DQoJPC9nPg0KCTxnPg0KCQk8Zz4NCgkJCTxwYXRoIHN0eWxlPSJmaWxsOiM1QzU0NkE7IiBkPSJNMjcyLjAyMywyMTYuMDQ0Yy00LjQyMiwwLTgtMy41NzgtOC04YzAtNC40MTQtMy41ODYtOC04LThjLTQuNDE0LDAtOCwzLjU4Ni04LDgNCgkJCQljMCw0LjQyMi0zLjU3OCw4LTgsOHMtOC0zLjU3OC04LThjMC0xMy4yMzQsMTAuNzY2LTI0LDI0LTI0czI0LDEwLjc2NiwyNCwyNEMyODAuMDIzLDIxMi40NjYsMjc2LjQ0NSwyMTYuMDQ0LDI3Mi4wMjMsMjE2LjA0NHoiDQoJCQkJLz4NCgkJPC9nPg0KCTwvZz4NCgk8Zz4NCgkJPGc+DQoJCQk8cGF0aCBzdHlsZT0iZmlsbDojNUM1NDZBOyIgZD0iTTE3Ni4wMjMsMjA4LjA0NGgtNDAuMjE5Yy00LjQyMiwwLTgtMy41NzgtOC04czMuNTc4LTgsOC04aDQwLjIxOWM0LjQyMiwwLDgsMy41NzgsOCw4DQoJCQkJUzE4MC40NDUsMjA4LjA0NCwxNzYuMDIzLDIwOC4wNDR6Ii8+DQoJCTwvZz4NCgk8L2c+DQoJPGc+DQoJCTxnPg0KCQkJPHBhdGggc3R5bGU9ImZpbGw6IzVDNTQ2QTsiIGQ9Ik0zNzUuODA0LDIwOC4wNDRoLTM5Ljc4MWMtNC40MjIsMC04LTMuNTc4LTgtOHMzLjU3OC04LDgtOGgzOS43ODFjNC40MjIsMCw4LDMuNTc4LDgsOA0KCQkJCVMzODAuMjI2LDIwOC4wNDQsMzc1LjgwNCwyMDguMDQ0eiIvPg0KCQk8L2c+DQoJPC9nPg0KCTxnPg0KCQk8Zz4NCgkJCTxwYXRoIHN0eWxlPSJmaWxsOiM4Njg0OTE7IiBkPSJNMjA4LjAyMywyNDguMDQ0Yy0yMi4wNTUsMC00MC0xNy45NDUtNDAtNDBzMTcuOTQ1LTQwLDQwLTQwczQwLDE3Ljk0NSw0MCw0MA0KCQkJCVMyMzAuMDc4LDI0OC4wNDQsMjA4LjAyMywyNDguMDQ0eiBNMjA4LjAyMywxODQuMDQ0Yy0xMy4yMzQsMC0yNCwxMC43NjYtMjQsMjRzMTAuNzY2LDI0LDI0LDI0czI0LTEwLjc2NiwyNC0yNA0KCQkJCVMyMjEuMjU3LDE4NC4wNDQsMjA4LjAyMywxODQuMDQ0eiIvPg0KCQk8L2c+DQoJPC9nPg0KCTxnPg0KCQk8Zz4NCgkJCTxwYXRoIHN0eWxlPSJmaWxsOiM4Njg0OTE7IiBkPSJNMzA0LjAyMywyNDguMDQ0Yy0yMi4wNTUsMC00MC0xNy45NDUtNDAtNDBzMTcuOTQ1LTQwLDQwLTQwczQwLDE3Ljk0NSw0MCw0MA0KCQkJCVMzMjYuMDc4LDI0OC4wNDQsMzA0LjAyMywyNDguMDQ0eiBNMzA0LjAyMywxODQuMDQ0Yy0xMy4yMzQsMC0yNCwxMC43NjYtMjQsMjRzMTAuNzY2LDI0LDI0LDI0czI0LTEwLjc2NiwyNC0yNA0KCQkJCVMzMTcuMjU3LDE4NC4wNDQsMzA0LjAyMywxODQuMDQ0eiIvPg0KCQk8L2c+DQoJPC9nPg0KCTxnPg0KCQk8cGF0aCBzdHlsZT0iZmlsbDojN0U1QzYyOyIgZD0iTTEwNC4wMjMsNTEyLjA0NHYtNTMuNDkyYzAtMTkuMjM0LTcuNDkyLTM3LjMxMi0yMS4wODYtNTAuOTA2bC0yOS41NTktMjkuNTU5DQoJCQljLTQuMjQsMy4zMTctOC4wNzEsNy4wNy0xMS40NCwxMS4xODVsMjkuNjg3LDI5LjY4N2MxMC41NzgsMTAuNTc4LDE2LjM5OCwyNC42NDEsMTYuMzk4LDM5LjU5NHY1My40OTJMMTA0LjAyMyw1MTIuMDQ0DQoJCQlMMTA0LjAyMyw1MTIuMDQ0eiIvPg0KCTwvZz4NCgk8Zz4NCgkJPHBhdGggc3R5bGU9ImZpbGw6IzdFNUM2MjsiIGQ9Ik00NTguNjY4LDM3OC4wODZsLTI5LjU1OSwyOS41NTljLTEzLjYwMiwxMy41OTQtMjEuMDg2LDMxLjY3Mi0yMS4wODYsNTAuOTA2djUzLjQ5MmgxNnYtNTMuNDkyDQoJCQljMC0xNC45NTMsNS44Mi0yOS4wMTYsMTYuMzk4LTM5LjU5NGwyOS42ODgtMjkuNjg4QzQ2Ni43NCwzODUuMTU2LDQ2Mi45MDgsMzgxLjQwNCw0NTguNjY4LDM3OC4wODZ6Ii8+DQoJPC9nPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjxnPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjxnPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjxnPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjxnPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjxnPg0KPC9nPg0KPC9zdmc+DQo=');
93INSERT INTO "role_icon" ("icon") VALUES ('data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iaXNvLTg4NTktMSI/Pg0KPCEtLSBHZW5lcmF0b3I6IEFkb2JlIElsbHVzdHJhdG9yIDE4LjAuMCwgU1ZHIEV4cG9ydCBQbHVnLUluIC4gU1ZHIFZlcnNpb246IDYuMDAgQnVpbGQgMCkgIC0tPg0KPCFET0NUWVBFIHN2ZyBQVUJMSUMgIi0vL1czQy8vRFREIFNWRyAxLjEvL0VOIiAiaHR0cDovL3d3dy53My5vcmcvR3JhcGhpY3MvU1ZHLzEuMS9EVEQvc3ZnMTEuZHRkIj4NCjxzdmcgdmVyc2lvbj0iMS4xIiBpZD0iQ2FwYV8xIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHhtbG5zOnhsaW5rPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5L3hsaW5rIiB4PSIwcHgiIHk9IjBweCINCgkgdmlld0JveD0iMCAwIDIwMy43MzYgMjAzLjczNiIgc3R5bGU9ImVuYWJsZS1iYWNrZ3JvdW5kOm5ldyAwIDAgMjAzLjczNiAyMDMuNzM2OyIgeG1sOnNwYWNlPSJwcmVzZXJ2ZSI+DQo8Zz4NCgk8cGF0aCBzdHlsZT0iZmlsbDojNTQzQzJBOyIgZD0iTTEwMS44NjcsNjYuMTM5djEzMS4zOTVoNjAuMjZjMCwwLDExLjQ0OS01OS4zNjUsMTEuMTY4LTk1LjExMw0KCQlDMTczLjAxNCw2Ni42NzMsMTAxLjg2Nyw2Ni4xMzksMTAxLjg2Nyw2Ni4xMzl6Ii8+DQoJPHBhdGggc3R5bGU9ImZpbGw6IzU0M0MyQTsiIGQ9Ik0xMDEuODY3LDY2LjEzOXYxMzEuMzk1SDQxLjYwOWMwLDAtMTEuNDQ5LTU5LjM2NS0xMS4xNjgtOTUuMTEzDQoJCUMzMC43MjEsNjYuNjczLDEwMS44NjcsNjYuMTM5LDEwMS44NjcsNjYuMTM5eiIvPg0KCTxnPg0KCQk8Zz4NCgkJCTxyZWN0IHg9Ijg3LjE3IiB5PSIxNTMuNDciIHN0eWxlPSJmaWxsOiNGRENDOUI7IiB3aWR0aD0iMjkuMzk1IiBoZWlnaHQ9IjMyLjkyMyIvPg0KCQkJPHBhdGggc3R5bGU9ImZpbGw6I0ZDQkM4NTsiIGQ9Ik04Ny4xNywxNTcuMzQ4YzAsMCwxMi4zNjUsNy44NzQsMjkuMzk1LDYuMDUxdi05LjkyOUg4Ny4xN1YxNTcuMzQ4eiIvPg0KCQkJPGVsbGlwc2Ugc3R5bGU9ImZpbGw6I0ZDQkM4NTsiIGN4PSI0NC43ODQiIGN5PSIxMDIuNDIiIHJ4PSIxNC4zNDMiIHJ5PSIxNi4zNjQiLz4NCgkJCTxlbGxpcHNlIHN0eWxlPSJmaWxsOiNGQ0JDODU7IiBjeD0iMTU4Ljk1MiIgY3k9IjEwMi40MiIgcng9IjE0LjM0MyIgcnk9IjE2LjM2NCIvPg0KCQkJPHBhdGggc3R5bGU9ImZpbGw6I0ZEQ0M5QjsiIGQ9Ik0xNTguODk0LDcxLjE2NWMwLTI0LjEwNC0xNy42MzctNDEuNzQxLTU3LjAyNi00MS43NDFjLTM5LjM4OSwwLTU3LjAyNSwxNy42MzctNTcuMDI1LDQxLjc0MQ0KCQkJCWMwLDI0LjEwNC00LjExNSw4Ny41OTcsNTcuMDI1LDg3LjU5N0MxNjMuMDA5LDE1OC43NjIsMTU4Ljg5NCw5NS4yNjksMTU4Ljg5NCw3MS4xNjV6Ii8+DQoJCQk8Zz4NCgkJCQk8Zz4NCgkJCQkJPGVsbGlwc2Ugc3R5bGU9ImZpbGw6IzNCMjUxOTsiIGN4PSI3NC4wOTIiIGN5PSI5OC41MDIiIHJ4PSI2LjE3MyIgcnk9IjYuNzYxIi8+DQoJCQkJCTxjaXJjbGUgc3R5bGU9ImZpbGw6I0ZGRkZGRjsiIGN4PSI3MS40MDEiIGN5PSI5NS41MTciIHI9IjEuODQ2Ii8+DQoJCQkJPC9nPg0KCQkJCTxwYXRoIHN0eWxlPSJmaWxsOiM2ODRCMzc7IiBkPSJNNjQuMjE3LDgzLjkyNWMyLjkxOSwxLjExNyw3LjYwNS0zLjc5OCwxOC4zMzUsMC40NzhjMS45NTYsMC43OCwzLjEyMy02LjY2OC04LjM3OC02LjY2OA0KCQkJCQlDNjQuMjE3LDc3LjczNSw2Mi40NTMsODMuMjUsNjQuMjE3LDgzLjkyNXoiLz4NCgkJCQk8Zz4NCgkJCQkJPGVsbGlwc2Ugc3R5bGU9ImZpbGw6IzNCMjUxOTsiIGN4PSIxMzAuNDA2IiBjeT0iOTguNTAyIiByeD0iNi4xNzMiIHJ5PSI2Ljc2MSIvPg0KCQkJCQk8Y2lyY2xlIHN0eWxlPSJmaWxsOiNGRkZGRkY7IiBjeD0iMTI3LjcxNSIgY3k9Ijk1LjUxNyIgcj0iMS44NDYiLz4NCgkJCQk8L2c+DQoJCQkJPHBhdGggc3R5bGU9ImZpbGw6IzY4NEIzNzsiIGQ9Ik0xMzkuNTE5LDgzLjkyNWMtMi45MTksMS4xMTctNy42MDYtMy43OTgtMTguMzM1LDAuNDc4Yy0xLjk1NiwwLjc4LTMuMTIzLTYuNjY4LDguMzc3LTYuNjY4DQoJCQkJCUMxMzkuNTE5LDc3LjczNSwxNDEuMjgyLDgzLjI1LDEzOS41MTksODMuOTI1eiIvPg0KCQkJPC9nPg0KCQkJPHBhdGggc3R5bGU9ImZpbGw6I0ZDQkM4NTsiIGQ9Ik0xMDEuODY3LDEyMi4yODNjLTYuMDk5LDAtOS43NzMtNC41NTctOS43NzMtMi4zNTJjMCwyLjIwNCwxLjc2NCw2LjM5NCw5Ljc3Myw2LjM5NA0KCQkJCWM4LjAxMSwwLDkuNzc0LTQuMTg5LDkuNzc0LTYuMzk0QzExMS42NDIsMTE3LjcyNiwxMDcuOTY3LDEyMi4yODMsMTAxLjg2NywxMjIuMjgzeiIvPg0KCQkJPHBhdGggc3R5bGU9ImZpbGw6I0ZDQkM4NTsiIGQ9Ik0xMDEuODY3LDE0Mi41NTNjLTIuMTA5LDAtMy4zOC0xLjU3NS0zLjM4LTAuODE0YzAsMC43NjMsMC42MSwyLjIxMiwzLjM4LDIuMjEyDQoJCQkJYzIuNzcxLDAsMy4zODEtMS40NDksMy4zODEtMi4yMTJDMTA1LjI0OCwxNDAuOTc4LDEwMy45NzgsMTQyLjU1MywxMDEuODY3LDE0Mi41NTN6Ii8+DQoJCQk8cGF0aCBzdHlsZT0iZmlsbDojRjc5NDVFOyIgZD0iTTEwMS44NjcsMTM2LjkzNmMtOS42NjgsMC0xNS40OTItMy45MzctMTUuNDkyLTIuOTM5czIuNzk1LDQuOTI0LDE1LjQ5Miw0LjkyNA0KCQkJCXMxNS40OTMtMy45MjcsMTUuNDkzLTQuOTI0UzExMS41MzUsMTM2LjkzNiwxMDEuODY3LDEzNi45MzZ6Ii8+DQoJCTwvZz4NCgkJPGNpcmNsZSBzdHlsZT0iZmlsbDojRjlBQThEOyIgY3g9IjY2LjE1NCIgY3k9IjEyMC4xMDgiIHI9IjguMzc3Ii8+DQoJCTxjaXJjbGUgc3R5bGU9ImZpbGw6I0Y5QUE4RDsiIGN4PSIxMzguNjExIiBjeT0iMTIwLjEwOCIgcj0iOC4zNzciLz4NCgk8L2c+DQoJPHBhdGggc3R5bGU9ImZpbGw6I0Y1QTg2MDsiIGQ9Ik0xMDEuODY3LDE2Ni42OTl2MzcuMDM3SDM3LjQ5NUMzNy40OTUsMTg4Ljc0NSw2OC4wNjQsMTY2LjY5OSwxMDEuODY3LDE2Ni42OTl6Ii8+DQoJPHBhdGggc3R5bGU9ImZpbGw6I0Y1QTg2MDsiIGQ9Ik0xMDEuODY3LDE2Ni42OTl2MzcuMDM3aDY0LjM3M0MxNjYuMjQsMTg4Ljc0NSwxMzUuNjcyLDE2Ni42OTksMTAxLjg2NywxNjYuNjk5eiIvPg0KCTxwYXRoIHN0eWxlPSJmaWxsOiNGMThCNDU7IiBkPSJNODkuNiwxNjcuNjUxYy0wLjE4OSwwLjAyNy0wLjM3OSwwLjA2NS0wLjU2OSwwLjA5NGMtMy45NjMsMC42MzQtNy44MjksMS41MjktMTEuNTQzLDIuNjUzDQoJCWwyNC4zOCwzMy4zMzh2LTE4LjUxOEw5MC44NywxNjcuNTAxQzkwLjQ0OSwxNjcuNTYsOTAuMDIsMTY3LjU4Nyw4OS42LDE2Ny42NTF6Ii8+DQoJPHBhdGggc3R5bGU9ImZpbGw6I0YxOEI0NTsiIGQ9Ik0xMTQuMTM1LDE2Ny42NTFjMC4xOSwwLjAyNywwLjM4LDAuMDY1LDAuNTcsMC4wOTRjMy45NjMsMC42MzQsNy44MjksMS41MjksMTEuNTQzLDIuNjUzDQoJCWwtMjQuMzgxLDMzLjMzOHYtMTguNTE4bDEwLjk5OC0xNy43MTZDMTEzLjI4NiwxNjcuNTYsMTEzLjcxNiwxNjcuNTg3LDExNC4xMzUsMTY3LjY1MXoiLz4NCgk8cGF0aCBzdHlsZT0iZmlsbDojNjg0QjM3OyIgZD0iTTEwMS44NjcsMEMzNS40MzYsMCwyNy42NTEsNDYuOTkxLDMwLjQ0MSwxMDIuNDJjMi43OSw1NS40Myw0OS44MjQsODIuNzk3LDQ5LjgyNCw4Mi43OTcNCgkJUzI3LjU2LDEwOS43OSw3MS40MDEsNDMuNjUxYzAsMC04LjIzMiwxNC4xNTctNy43ODYsMjYuMDE1YzAsMCwxMC4zMjgtMy41MjcsMzguMjUzLTMuNTI3YzI3LjkyNiwwLDM4LjI1MywzLjUyNywzOC4yNTMsMy41MjcNCgkJYzAuNDQ3LTExLjg1OC03Ljc4NS0yNi4wMTUtNy43ODUtMjYuMDE1YzQzLjg0MSw2Ni4xMzgtOC44NjUsMTQxLjU2Ni04Ljg2NSwxNDEuNTY2czQ3LjAzNS0yNy4zNjcsNDkuODI1LTgyLjc5Nw0KCQlDMTc2LjA4NSw0Ni45OTEsMTY4LjMsMCwxMDEuODY3LDB6Ii8+DQoJPHBhdGggc3R5bGU9ImZpbGw6I0ZEQ0M5QjsiIGQ9Ik04Ny4xNywxNjcuOTgxbDE0LjY5NywyNC40MDhsMTQuNjk3LTI0LjQwOUMxMTYuNTY1LDE2Ny45OCwxMDEuMzE3LDE2Mi40MjgsODcuMTcsMTY3Ljk4MXoiLz4NCjwvZz4NCjxnPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjxnPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjxnPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjxnPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjxnPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjwvc3ZnPg0K');
94INSERT INTO "role_icon" ("icon") VALUES ('data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iaXNvLTg4NTktMSI/Pg0KPCEtLSBHZW5lcmF0b3I6IEFkb2JlIElsbHVzdHJhdG9yIDE4LjAuMCwgU1ZHIEV4cG9ydCBQbHVnLUluIC4gU1ZHIFZlcnNpb246IDYuMDAgQnVpbGQgMCkgIC0tPg0KPCFET0NUWVBFIHN2ZyBQVUJMSUMgIi0vL1czQy8vRFREIFNWRyAxLjEvL0VOIiAiaHR0cDovL3d3dy53My5vcmcvR3JhcGhpY3MvU1ZHLzEuMS9EVEQvc3ZnMTEuZHRkIj4NCjxzdmcgdmVyc2lvbj0iMS4xIiBpZD0iQ2FwYV8xIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHhtbG5zOnhsaW5rPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5L3hsaW5rIiB4PSIwcHgiIHk9IjBweCINCgkgdmlld0JveD0iMCAwIDE5Ni42NTEgMTk2LjY1MSIgc3R5bGU9ImVuYWJsZS1iYWNrZ3JvdW5kOm5ldyAwIDAgMTk2LjY1MSAxOTYuNjUxOyIgeG1sOnNwYWNlPSJwcmVzZXJ2ZSI+DQo8Zz4NCgk8Zz4NCgkJPHJlY3QgeD0iODMuNjI4IiB5PSIxNDYuMzg2IiBzdHlsZT0iZmlsbDojRkRDQzlCOyIgd2lkdGg9IjI5LjM5NSIgaGVpZ2h0PSIzMi45MjMiLz4NCgkJPHBhdGggc3R5bGU9ImZpbGw6I0ZDQkM4NTsiIGQ9Ik04My42MjgsMTUwLjI2NGMwLDAsMTIuMzY1LDcuODc0LDI5LjM5NSw2LjA1MXYtOS45MjlIODMuNjI4VjE1MC4yNjR6Ii8+DQoJCTxlbGxpcHNlIHN0eWxlPSJmaWxsOiNGQ0JDODU7IiBjeD0iNDEuMjQyIiBjeT0iOTUuMzM2IiByeD0iMTQuMzQzIiByeT0iMTYuMzY0Ii8+DQoJCTxlbGxpcHNlIHN0eWxlPSJmaWxsOiNGQ0JDODU7IiBjeD0iMTU1LjQwOSIgY3k9Ijk1LjMzNiIgcng9IjE0LjM0MyIgcnk9IjE2LjM2NCIvPg0KCQk8cGF0aCBzdHlsZT0iZmlsbDojRkRDQzlCOyIgZD0iTTE1NS4zNTIsNjQuMDhjMC0yNC4xMDQtMTcuNjM3LTQxLjc0LTU3LjAyNi00MS43NGMtMzkuMzg5LDAtNTcuMDI2LDE3LjYzNy01Ny4wMjYsNDEuNzQNCgkJCWMwLDI0LjEwNC00LjExNSw4Ny41OTcsNTcuMDI2LDg3LjU5N0MxNTkuNDY3LDE1MS42NzcsMTU1LjM1Miw4OC4xODUsMTU1LjM1Miw2NC4wOHoiLz4NCgkJPGc+DQoJCQk8Zz4NCgkJCQk8ZWxsaXBzZSBzdHlsZT0iZmlsbDojM0IyNTE5OyIgY3g9IjcwLjU1IiBjeT0iOTEuNDE4IiByeD0iNi4xNzMiIHJ5PSI2Ljc2MSIvPg0KCQkJCTxjaXJjbGUgc3R5bGU9ImZpbGw6I0ZGRkZGRjsiIGN4PSI2Ny44NTkiIGN5PSI4OC40MzMiIHI9IjEuODQ2Ii8+DQoJCQk8L2c+DQoJCQk8cGF0aCBzdHlsZT0iZmlsbDojODY0NjFCOyIgZD0iTTYwLjY3NSw3NC42NjJjMi45MTksMS40Niw3LjYwNi00Ljk2LDE4LjMzNSwwLjYyNWMxLjk1NiwxLjAxOCwzLjEyMy04LjcwOC04LjM3Ny04LjcwOA0KCQkJCUM2MC42NzUsNjYuNTc5LDU4LjkxMSw3My43ODEsNjAuNjc1LDc0LjY2MnoiLz4NCgkJCTxnPg0KCQkJCTxlbGxpcHNlIHN0eWxlPSJmaWxsOiMzQjI1MTk7IiBjeD0iMTI2Ljg2NCIgY3k9IjkxLjQxOCIgcng9IjYuMTczIiByeT0iNi43NjEiLz4NCgkJCQk8Y2lyY2xlIHN0eWxlPSJmaWxsOiNGRkZGRkY7IiBjeD0iMTI0LjE3MyIgY3k9Ijg4LjQzMyIgcj0iMS44NDYiLz4NCgkJCTwvZz4NCgkJCTxwYXRoIHN0eWxlPSJmaWxsOiM4NjQ2MUI7IiBkPSJNMTM1Ljk3Nyw3NC42NjJjLTIuOTE5LDEuNDYtNy42MDYtNC45Ni0xOC4zMzUsMC42MjVjLTEuOTU2LDEuMDE4LTMuMTIzLTguNzA4LDguMzc4LTguNzA4DQoJCQkJQzEzNS45NzcsNjYuNTc5LDEzNy43NCw3My43ODEsMTM1Ljk3Nyw3NC42NjJ6Ii8+DQoJCTwvZz4NCgkJPHBhdGggc3R5bGU9ImZpbGw6I0ZDQkM4NTsiIGQ9Ik05OC4zMjYsMTE1LjE5OGMtNi4xLDAtOS43NzQtNC41NTctOS43NzQtMi4zNTJjMCwyLjIwNCwxLjc2NCw2LjM5Myw5Ljc3NCw2LjM5Mw0KCQkJYzguMDEsMCw5Ljc3NC00LjE4OSw5Ljc3NC02LjM5M0MxMDguMSwxMTAuNjQyLDEwNC40MjUsMTE1LjE5OCw5OC4zMjYsMTE1LjE5OHoiLz4NCgkJPHBhdGggc3R5bGU9ImZpbGw6I0ZDQkM4NTsiIGQ9Ik05OC4zMjYsMTM1LjQ2OWMtMi4xMSwwLTMuMzgxLTEuNTc2LTMuMzgxLTAuODEzYzAsMC43NjMsMC42MSwyLjIxMiwzLjM4MSwyLjIxMg0KCQkJYzIuNzcxLDAsMy4zOC0xLjQ0OSwzLjM4LTIuMjEyQzEwMS43MDYsMTMzLjg5MywxMDAuNDM1LDEzNS40NjksOTguMzI2LDEzNS40Njl6Ii8+DQoJCTxwYXRoIHN0eWxlPSJmaWxsOiNGNzk0NUU7IiBkPSJNOTguMzI2LDEyOS44NTJjLTkuNjY4LDAtMTUuNDkzLTMuOTM3LTE1LjQ5My0yLjkzOWMwLDAuOTk3LDIuNzk2LDQuOTI0LDE1LjQ5Myw0LjkyNA0KCQkJYzEyLjY5NywwLDE1LjQ5My0zLjkyNywxNS40OTMtNC45MjRDMTEzLjgxOCwxMjUuOTE0LDEwNy45OTQsMTI5Ljg1Miw5OC4zMjYsMTI5Ljg1MnoiLz4NCgk8L2c+DQoJPHBhdGggc3R5bGU9ImZpbGw6I0Q1OEU2NDsiIGQ9Ik05OC4zMjYsMTU5LjYxM3YzNy4wMzhIMjYuODk4QzI2Ljg5OCwxODEuNjYsNjQuNTIxLDE1OS42MTMsOTguMzI2LDE1OS42MTN6Ii8+DQoJPHBhdGggc3R5bGU9ImZpbGw6I0Q1OEU2NDsiIGQ9Ik05OC4zMjYsMTU5LjYxM3YzNy4wMzhoNzEuNDI3QzE2OS43NTMsMTgxLjY2LDEzMi4xMjksMTU5LjYxMyw5OC4zMjYsMTU5LjYxM3oiLz4NCgk8cGF0aCBzdHlsZT0iZmlsbDojQkY4MDVBOyIgZD0iTTk4LjMyNiwxNTkuNjEzYy03LjE5LDAtMTQuNTUyLDEuMDA1LTIxLjY4OSwyLjcyMWMwLjA0OCwwLjA2Myw3LjkxNywxMC4yMTMsMjEuNjg5LDEwLjIxMw0KCQljMTIuNzU0LDAsMjEuMjMzLTguNjkyLDIyLjQ2Mi0xMC4wM0MxMTMuNDEsMTYwLjY4NiwxMDUuNzc1LDE1OS42MTMsOTguMzI2LDE1OS42MTN6Ii8+DQoJPHBhdGggc3R5bGU9ImZpbGw6I0ZEQ0M5QjsiIGQ9Ik04My42MjgsMTYwLjg5NWMwLDAsNC4yOTksNS4zMzIsMTQuNjk3LDUuMzMyYzEwLjM5OCwwLDE0LjY5OC01LjMzMiwxNC42OTgtNS4zMzINCgkJUzk3Ljc3NCwxNTUuMzQ0LDgzLjYyOCwxNjAuODk1eiIvPg0KCTxwYXRoIHN0eWxlPSJmaWxsOiM4NjQ2MUI7IiBkPSJNOTguMzI1LDEzOS4xMXYxMy42NjljLTMwLjcxNywwLTQwLjg1Ny0xNi4zNzgtNDMuODYxLTIwLjk0Mw0KCQljLTIuMjI3LTMuMzg3LDE0LjQ1MiwxMS45MDQsMjkuMTY0LDExLjkwNEM5MC4wOTUsMTQzLjc0LDg5LjgwMSwxMzkuMTEsOTguMzI1LDEzOS4xMXoiLz4NCgk8cGF0aCBzdHlsZT0iZmlsbDojODY0NjFCOyIgZD0iTTk4LjMyNSwxMzkuMTF2MTMuNjY5YzMwLjcxOCwwLDQwLjg1OC0xNi4zNzgsNDMuODYxLTIwLjk0Mw0KCQljMi4yMjctMy4zODctMTQuNDUyLDExLjkwNC0yOS4xNjQsMTEuOTA0QzEwNi41NTYsMTQzLjc0LDEwNi44NSwxMzkuMTEsOTguMzI1LDEzOS4xMXoiLz4NCgk8cGF0aCBzdHlsZT0iZmlsbDojODY0NjFCOyIgZD0iTTk4LjcxMiw0OC4yMDdWMEM0OC4zNTQsMCwzOC45NDgsMTguODEzLDM2LjU5Niw1NC4wODZjLTIuMzUyLDM1LjI3NCwyLjk1OCw0Ny40MTcsNi40NzYsNDcuMzcyDQoJCWMzLjUxOC0wLjA0NiwxLjYyNy00MC40NCw2LjQ1OC00OS4xMzZDNTguMzQ5LDM2LjQ0OSw3NC4xMTMsNDguMjA3LDk4LjcxMiw0OC4yMDd6Ii8+DQoJPHBhdGggc3R5bGU9ImZpbGw6Izg2NDYxQjsiIGQ9Ik05OC43MTIsNDguMjA3VjBjNTAuMzU4LDAsNTkuNzY0LDE4LjgxMyw2Mi4xMTYsNTQuMDg2YzIuMzUyLDM1LjI3NC0yLjk1OCw0Ny40MTctNi40NzYsNDcuMzcyDQoJCWMtMy41MTgtMC4wNDYtMS42MjctNDAuNDQtNi40NTgtNDkuMTM2QzEzOS4wNzYsMzYuNDQ5LDEyMy4zMTEsNDguMjA3LDk4LjcxMiw0OC4yMDd6Ii8+DQoJPHBhdGggc3R5bGU9ImZpbGw6Izc0NEEyNTsiIGQ9Ik02Ny4wMTQsMTY1LjEwOWMtMjIuMjA2LDcuNTAyLTQwLjExNSwyMS4xOTktNDAuMTE1LDMxLjU0Mmg0MC4xMTd2LTMxLjU0Mkg2Ny4wMTR6Ii8+DQoJPHBhdGggc3R5bGU9ImZpbGw6IzU3MzUxNDsiIGQ9Ik02OS4xNTEsMTk2LjY1MXYtMzMuODA1YzAsMC01LjczMiwyLjIwNS03LjcxNiwzLjIzM2wtNS44NSwzMC41NzFINjkuMTUxeiIvPg0KCTxwYXRoIHN0eWxlPSJmaWxsOiM3NDRBMjU7IiBkPSJNMTI5LjYzOCwxNjUuMTA5YzIyLjIwNiw3LjUwMiw0MC4xMTUsMjEuMTk5LDQwLjExNSwzMS41NDJoLTQwLjExN3YtMzEuNTQySDEyOS42Mzh6Ii8+DQoJPHBhdGggc3R5bGU9ImZpbGw6IzU3MzUxNDsiIGQ9Ik0xMjcuNSwxOTYuNjUxdi0zMy44MDVjMCwwLDUuNzMyLDIuMjA1LDcuNzE2LDMuMjMzbDUuODUsMzAuNTcxSDEyNy41eiIvPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjxnPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjxnPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjxnPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjxnPg0KPC9nPg0KPGc+DQo8L2c+DQo8Zz4NCjwvZz4NCjxnPg0KPC9nPg0KPC9zdmc+DQo='); 
95
96-- Roles--
97INSERT INTO "role" ("description", "role_icon_id") VALUES ('Administrador de plataforma', '1');
98INSERT INTO "role" ("description", "role_icon_id") VALUES ('Administrador de municipio', '2');
99INSERT INTO "role" ("description", "role_icon_id") VALUES ('Asistente de municipio', '3');
100INSERT INTO "role" ("description", "role_icon_id") VALUES ('Municipio', '1');
101INSERT INTO "role" ("description", "role_icon_id") VALUES ('Desarrollador testing', '2');
102INSERT INTO "role" ("description", "role_icon_id") VALUES ('Desarrollador integrador', '3');
103INSERT INTO "role" ("description", "role_icon_id") VALUES ('Vertical', '1');
104INSERT INTO "role" ("description", "role_icon_id") VALUES ('Desarrollador OpenData', '2');
105INSERT INTO "role" ("description", "role_icon_id") VALUES ('Ciudadano', '3');
106
107-- Estados --
108
109INSERT INTO "status" ("description") VALUES ('Pendiente password');
110INSERT INTO "status" ("description") VALUES ('Activo');
111INSERT INTO "status" ("description") VALUES ('Bloqueado');
112INSERT INTO "status" ("description") VALUES ('Dado de baja');
113
114-- Modulos --
115
116INSERT INTO "module" ("description") VALUES ('Dashboard administrador de plataforma');
117INSERT INTO "module" ("description") VALUES ('Dashboard administrador de smartcity');
118INSERT INTO "module" ("description") VALUES ('Dashboard ciudadano');
119INSERT INTO "module" ("description") VALUES ('Api-portal desarrollador');
120INSERT INTO "module" ("description") VALUES ('Api-portal certificacion');
121INSERT INTO "module" ("description") VALUES ('Api-portal produccion');
122INSERT INTO "module" ("description") VALUES ('Dashboard analitico municipal');
123INSERT INTO "module" ("description") VALUES ('Dashboard analitico plataforma');
124
125-- Menu --
126
127INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Administracion territorio', null, '1', null);
128INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Mantenedor de territorio', 'territories', '1', '1');
129INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Configuracion de territorio', null, '2', null);
130INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Configuracion de niveles', 'levels','2', '3');
131INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Configuracion de unidades', 'units', '2', '3');
132INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Inventario urbano', null, '2', null);
133INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Edificacion', 'edifications','2', '6');
134INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Infraestructura', 'infrastructure','2', '6');   
135INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Categoria', 'category','2', '6');  
136INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Sub-categoria', 'inventory','2', '6');
137INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Roles y usuarios', null, '2', null);
138INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Administrar roles', 'roles','2', '11');
139INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Administrar usuarios', 'user','2', '11');
140INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Unidad de inventario', 'unitsInventoryManager','2', '6');
141INSERT INTO "menu" ("description", "route", "module_id", "menu_id") VALUES ('Carga masiva', 'importUnitsInventory','2', '6');
142
143-- Funcionalidades --
144
145INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('CreaciÃ³n de territorio', '1', '2');
146INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de todos los territorio', '1', '2');
147INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Edicion de territorio', '1', '2');
148INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Eliminacion de territorio', '1', '2');
149INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de un territorio', '1', '2');
150INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Configuracion de niveles', '2', '4');
151INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Edicion de niveles', '2', '4');
152INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Eliminacion de niveles', '2', '4');
153INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Creacion de unidades', '2', '5');
154INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Edicion de unidades', '2', '5');
155INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de unidades por nivel', '2', '5');
156INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Eliminacion de unidades', '2', '5');
157INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Creacion de edificaciones', '2', '7');
158INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Creacion de infraestructura', '2', '8');
159INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Creacion de categorias', '2', '9');
160INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Creacion de inventario', '2', '10');
161INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de una edificaciÃ³n', '2', '7');
162INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de una infraestructura', '2', '8');
163INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de una categoria', '2', '9');
164INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de un inventario', '2', '10');
165INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de todas las edificaciones', '2', '7');
166INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de todas las infraestructuras', '2', '8');
167INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de todas las categorias', '2', '9');
168INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de todos los inventarios', '2', '10');
169INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Edicion de edificaciones', '2', '7');
170INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Edicion de infraestructuras', '2', '8');
171INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Edicion de categorias', '2', '9');
172INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Edicion de inventarios', '2', '10');
173INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Eliminacion de edificacion', '2', '7');
174INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Eliminacion de infraestructura', '2', '8');
175INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Eliminacion de categoria', '2', '9');
176INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Eliminacion de inventario', '2', '10');
177INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Creacion de rol', '2', '12');
178INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Creacion de usuario', '2', '13');
179INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Edicion de rol', '2', '12');
180INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Edicion de usuario', '2', '13');
181INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de un rol', '2', '12');
182INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de un usuario', '2', '13');
183INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de todos los roles', '2', '12');
184INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de todos los usuarios', '2', '13');
185INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Eliminacion de un rol', '2', '12');
186INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Eliminacion de un usuario', '2', '13');
187INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtener token', '2', null);
188INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Generar password', '2', null);
189
190INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Creacion de unidad de inventario', '2', '13');
191INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de una unidad de inventario', '2', '13');
192INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Obtencion de todas las unidades de inventario', '2', '13');
193INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Edicion de una unidad de inventario', '2', '13');
194INSERT INTO "functionality" ("description", "module_id", "menu_id") VALUES ('Eliminacion de una unidad de inventario', '2', '13');
195
196-- Functionality role --
197
198INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('1', '1');
199INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('2', '1');
200INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('3', '1');
201INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('4', '1');
202INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('5', '1');
203INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('6', '2');
204INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('7', '2');
205INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('8', '2');
206INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('9', '2');
207INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('10', '2');
208INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('11', '2');
209INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('12', '2');
210INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('13', '2');
211INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('14', '2');
212INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('15', '2');
213INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('16', '2');
214INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('17', '2');
215INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('18', '2');
216INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('19', '2');
217INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('20', '2');
218INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('21', '2');
219INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('22', '2');
220INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('23', '2');
221INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('24', '2');
222INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('25', '2');
223INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('26', '2');
224INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('27', '2');
225INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('28', '2');
226INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('29', '2');
227INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('30', '2');
228INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('31', '2');
229INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('32', '2');
230INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('33', '2');
231INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('34', '2');
232INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('35', '2');
233INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('36', '2');
234INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('37', '2');
235INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('38', '2');
236INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('39', '2');
237INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('40', '2');
238
239INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('45', '2');
240INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('46', '2');
241INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('47', '2');
242INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('48', '2');
243INSERT INTO "functionality_role" ("functionality_id", "role_id") VALUES ('49', '2');
244
245INSERT INTO "users" ("name", "surname", "mail", "password") VALUES ('Elias', 'Tardon', 'elias.tardon.munoz@gmail.com', '$2a$10$UXLvhukR.zaQ87pTsdfgkuj7t2ww94UbmHy1CEQMoNL7GOtbmTIPO');
246INSERT INTO "users" ("name", "surname", "mail", "password") VALUES ('Marcelo', 'Ketterer', 'm.ketterer01@gmail.com', '$2a$10$UXLvhukR.zaQ87pTsdfgkuj7t2ww94UbmHy1CEQMoNL7GOtbmTIPO');
247INSERT INTO "users" ("name", "surname", "mail", "password") VALUES ('Lotar', 'Medina', 'lotar_91@gmail.com', '$2a$10$UXLvhukR.zaQ87pTsdfgkuj7t2ww94UbmHy1CEQMoNL7GOtbmTIPO');
248INSERT INTO "users" ("name", "surname", "mail", "password") VALUES ('Usuario', 'Prueba', 'Prueba@gmail.com', null);
249
250INSERT INTO "users_role" ("users_id", "role_id") VALUES ('1', '1');
251INSERT INTO "users_role" ("users_id", "role_id") VALUES ('2', '2');
252INSERT INTO "users_role" ("users_id", "role_id") VALUES ('3', '1');
253INSERT INTO "users_role" ("users_id", "role_id") VALUES ('3', '2');
254
255INSERT INTO "users_status" ("users_id", "status_id", "fecha_inicio", "fecha_fin") VALUES ('1', '2', '2018-12-21 19:29:44.724591', null);
256INSERT INTO "users_status" ("users_id", "status_id", "fecha_inicio", "fecha_fin") VALUES ('2', '2', '2018-12-21 19:29:44.724591', null);
257INSERT INTO "users_status" ("users_id", "status_id", "fecha_inicio", "fecha_fin") VALUES ('3', '2', '2018-12-21 19:29:44.724591', null);
258INSERT INTO "users_status" ("users_id", "status_id", "fecha_inicio", "fecha_fin") VALUES ('4', '2', '2018-12-21 19:29:44.724591', null);
259
260-- Drop tables --
261DROP TABLE IF EXISTS edification CASCADE;
262DROP TABLE IF EXISTS inventory_type CASCADE;
263DROP TABLE IF EXISTS category CASCADE;
264DROP TABLE IF EXISTS infrastructure CASCADE;
265
266-- Generate tables structure --
267CREATE TABLE infrastructure(
268	id SERIAL NOT NULL PRIMARY KEY,
269	description TEXT NOT NULL
270);
271
272CREATE TABLE category(
273	id SERIAL NOT NULL PRIMARY KEY,
274    description TEXT NOT NULL,
275    infrastructure_id INT NOT NULL,
276    FOREIGN KEY (infrastructure_id) REFERENCES infrastructure(id)
277);
278
279CREATE TABLE inventory_type(
280	id SERIAL NOT NULL PRIMARY KEY,
281	description TEXT NOT NULL,
282    category_id INT NOT NULL,
283    FOREIGN KEY (category_id) REFERENCES category(id)
284);
285
286CREATE TABLE edification(
287	id SERIAL NOT NULL PRIMARY KEY,
288	description TEXT NOT NULL
289);
290
291-- Inserts
292
293-- Infrastructure
294INSERT INTO "infrastructure" ("description") values ('VÃa publica');
295INSERT INTO "infrastructure" ("description") values ('HidrÃ¡ulica');
296INSERT INTO "infrastructure" ("description") values ('EnergÃ©ticas');
297INSERT INTO "infrastructure" ("description") values ('Comunicaciones');
298INSERT INTO "infrastructure" ("description") values ('Transporte');
299
300--Categories
301INSERT INTO "category" ("description", "infrastructure_id") values ('Accesibilidad', '1');
302INSERT INTO "category" ("description", "infrastructure_id") values ('Seguridad', '1');
303INSERT INTO "category" ("description", "infrastructure_id") values ('1era Necesidad', '1');
304INSERT INTO "category" ("description", "infrastructure_id") values ('SeÃ±alizaciÃ³n', '1');
305INSERT INTO "category" ("description", "infrastructure_id") values ('Alumbrado', '1');
306INSERT INTO "category" ("description", "infrastructure_id") values ('Estacionamientos', '1');
307INSERT INTO "category" ("description", "infrastructure_id") values ('Residual', '1');
308INSERT INTO "category" ("description", "infrastructure_id") values ('Ocio-RecreaciÃ³n', '1');
309INSERT INTO "category" ("description", "infrastructure_id") values ('Potable', '2');
310INSERT INTO "category" ("description", "infrastructure_id") values ('Residual', '2');
311INSERT INTO "category" ("description", "infrastructure_id") values ('Pluvial', '2');
312INSERT INTO "category" ("description", "infrastructure_id") values ('Riego', '2');
313INSERT INTO "category" ("description", "infrastructure_id") values ('Red DistribuciÃ³n ElÃ©ctrica', '3');
314INSERT INTO "category" ("description", "infrastructure_id") values ('Red DistribuciÃ³n Combustible', '3');
315INSERT INTO "category" ("description", "infrastructure_id") values ('Fuentes EnergÃ©ticas', '3');
316INSERT INTO "category" ("description", "infrastructure_id") values ('TelefonÃa Fija', '4');
317INSERT INTO "category" ("description", "infrastructure_id") values ('TelefonÃa MÃ³vil', '4');
318INSERT INTO "category" ("description", "infrastructure_id") values ('Red de Datos', '4');
319INSERT INTO "category" ("description", "infrastructure_id") values ('Terrestre', '5');
320INSERT INTO "category" ("description", "infrastructure_id") values ('AÃ©reo', '5');
321INSERT INTO "category" ("description", "infrastructure_id") values ('MarÃtimo', '5');
322
323--Inventory_type
324INSERT INTO "inventory_type" ("description", "category_id") values ('Ascensores', '1');
325INSERT INTO "inventory_type" ("description", "category_id") values ('Ramplas', '1');
326INSERT INTO "inventory_type" ("description", "category_id") values ('CÃ¡maras Vigilancia', '2');
327INSERT INTO "inventory_type" ("description", "category_id") values ('ProtecciÃ³n cruce de calles', '2');
328INSERT INTO "inventory_type" ("description", "category_id") values ('BaÃ±os PÃºblicos', '3');
329INSERT INTO "inventory_type" ("description", "category_id") values ('SemÃ¡foros', '4');
330INSERT INTO "inventory_type" ("description", "category_id") values ('SeÃ±alÃ©tica Vial', '4');
331INSERT INTO "inventory_type" ("description", "category_id") values ('SeÃ±alÃ©tica Informativa', '4');
332INSERT INTO "inventory_type" ("description", "category_id") values ('Farolas', '5');
333INSERT INTO "inventory_type" ("description", "category_id") values ('Autos', '6');
334INSERT INTO "inventory_type" ("description", "category_id") values ('Carga y Descarga', '6');
335INSERT INTO "inventory_type" ("description", "category_id") values ('Bicicletas', '6');
336INSERT INTO "inventory_type" ("description", "category_id") values ('Motos', '6');
337INSERT INTO "inventory_type" ("description", "category_id") values ('Contenedores', '7');
338INSERT INTO "inventory_type" ("description", "category_id") values ('Basureros', '7');
339INSERT INTO "inventory_type" ("description", "category_id") values ('Bancas', '8');
340INSERT INTO "inventory_type" ("description", "category_id") values ('Estatuas/Monumentos', '8');
341INSERT INTO "inventory_type" ("description", "category_id") values ('Kioscos', '8');
342
343INSERT INTO "inventory_type" ("description", "category_id") values ('Medidores', '9');
344INSERT INTO "inventory_type" ("description", "category_id") values ('Fuentes', '9');
345INSERT INTO "inventory_type" ("description", "category_id") values ('Grifos Emergencia', '9');
346INSERT INTO "inventory_type" ("description", "category_id") values ('Grifos de Agua Bebestible', '9');
347INSERT INTO "inventory_type" ("description", "category_id") values ('Alcantarillas', '10');
348INSERT INTO "inventory_type" ("description", "category_id") values ('Alcantarillas', '11');
349INSERT INTO "inventory_type" ("description", "category_id") values ('Grifos de Riego', '12');
350
351INSERT INTO "inventory_type" ("description", "category_id") values ('EstaciÃ³n de servicios Recarga', '13');
352INSERT INTO "inventory_type" ("description", "category_id") values ('Estaciones de Servicio', '14');
353INSERT INTO "inventory_type" ("description", "category_id") values ('Centrales ElÃ©ctricas', '15');
354
355INSERT INTO "inventory_type" ("description", "category_id") values ('TelÃ©fonos PÃºblicos', '16');
356INSERT INTO "inventory_type" ("description", "category_id") values ('Paraderos Trenes', '16');
357INSERT INTO "inventory_type" ("description", "category_id") values ('Sitios MÃ³viles', '17');
358INSERT INTO "inventory_type" ("description", "category_id") values ('Punto Wifi Free', '18');
359
360INSERT INTO "inventory_type" ("description", "category_id") values ('Paraderos Autobuses', '19');
361INSERT INTO "inventory_type" ("description", "category_id") values ('Paraderos Trenes', '19');
362INSERT INTO "inventory_type" ("description", "category_id") values ('Aeropuertos', '20');
363INSERT INTO "inventory_type" ("description", "category_id") values ('Puertos', '21');
364INSERT INTO "inventory_type" ("description", "category_id") values ('Caletas', '21');
365
366--Edification
367INSERT INTO "edification" ("description") values ('Vivienda');
368INSERT INTO "edification" ("description") values ('Comercio');
369INSERT INTO "edification" ("description") values ('Industria');
370INSERT INTO "edification" ("description") values ('Salud');
371INSERT INTO "edification" ("description") values ('EducaciÃ³n');
372INSERT INTO "edification" ("description") values ('RecreaciÃ³n');
373INSERT INTO "edification" ("description") values ('Gobierno');
374INSERT INTO "edification" ("description") values ('Seguridad');