--
-- Dumping data for table category_user
--

INSERT INTO category_user (catus_id, catus_name, catus_description, catus_date_crea, catus_last_modify) VALUES (1, E'administrador', E'superusuario', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO category_user (catus_id, catus_name, catus_description, catus_date_crea, catus_last_modify) VALUES (2, E'usuario privilegiado', E'usuario privilegiado', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO category_user (catus_id, catus_name, catus_description, catus_date_crea, catus_last_modify) VALUES (3, E'usuario corriente', E'usuario corriente', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

--
-- Dumping data for table level
--

INSERT INTO level (level_id, level_name, level_description, level_comment, level_visual_identity, level_range, level_date_crea, level_last_modify, level_statut) VALUES (DEFAULT, E'público joven', E'Primer contacto con el medio ambiente y el desarrollo sostenible', '', '', 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'P');
INSERT INTO level (level_id, level_name, level_description, level_comment, level_visual_identity, level_range, level_date_crea, level_last_modify, level_statut) VALUES (DEFAULT, E'principiante', E'Algo de conocimiento sobre el desarrollo sostenible', '', '', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'P');
INSERT INTO level (level_id, level_name, level_description, level_comment, level_visual_identity, level_range, level_date_crea, level_last_modify, level_statut) VALUES (DEFAULT, E'medio', E'Bastante conocimiento sobre el desarrollo sostenible, y con ganas de saber más', '', '', 3, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'P');
INSERT INTO level (level_id, level_name, level_description, level_comment, level_visual_identity, level_range, level_date_crea, level_last_modify, level_statut) VALUES (DEFAULT, E'experto', E'Experto en desarrollo sostenible', '', '', 4, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'P');

--
-- Dumping data for table profile
--

INSERT INTO profile (profile_id, profile_email, profile_email_display, profile_city, profile_birthdate, profile_leisures, profile_job, profile_avatar, profile_quotation, profile_signature, profile_date_crea, profile_last_modify) VALUES (DEFAULT, 'cambie_su@direccion.com', 'N', '', '0001-01-01', E'', E'administrador linea21', E'', E'', E'', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

--
-- Dumping data for table rights
--

INSERT INTO rights (rights_id, rights_dashboard, rights_workshop, rights_project, rights_publication, rights_news, rights_yellowpages, rights_theme, rights_scale, rights_level, rights_category_user, rights_date_crea, rights_last_modify) VALUES (DEFAULT, 'A', 'A', 'A', 'A', 'A', 'A', 'A', 'A', 'A', 'A', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

--
-- Dumping data for table scale
--

INSERT INTO scale (scale_id, scale_denomination, scale_surface, scale_inhabitantsnumber, scale_root, scale_comment, scale_dependencies, scale_date_crea, scale_last_modify, scale_statut) VALUES (DEFAULT, E'Escala principal', 0, 0, 0, E'', 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'P');
--
-- Dumping data for table sd_theme
--

INSERT INTO sd_theme (sdtheme_id, sdtheme_name, sdtheme_description, sdtheme_range, sdtheme_date_crea, sdtheme_last_modify) VALUES (DEFAULT, E'social', E'', 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO sd_theme (sdtheme_id, sdtheme_name, sdtheme_description, sdtheme_range, sdtheme_date_crea, sdtheme_last_modify) VALUES (DEFAULT, E'económico', E'', 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO sd_theme (sdtheme_id, sdtheme_name, sdtheme_description, sdtheme_range, sdtheme_date_crea, sdtheme_last_modify) VALUES (DEFAULT, E'entorno', E'', 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO sd_theme (sdtheme_id, sdtheme_name, sdtheme_description, sdtheme_range, sdtheme_date_crea, sdtheme_last_modify) VALUES (DEFAULT, E'gobernanza', E'', 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

--
-- Dumping data for table theme
--

INSERT INTO theme (theme_id, theme_name, theme_visual_uri, theme_sd_theme, theme_desc_dashboard, theme_desc_project, theme_desc_publication, theme_desc_news, theme_desc_workshop, theme_range_dashboard, theme_range_project, theme_range_publication, theme_range_news, theme_range_workshop, theme_date_crea, theme_last_modify, theme_statut) VALUES 
(DEFAULT, E'a modificar', '', 1, E'descripción', E'descripción', E'descripción', E'descripción', E'descripción', 0, 0, 0, 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'P');

--
-- Dumping data for table user
--

INSERT INTO luser (user_id, user_login, user_password, user_community, user_category, user_rights, user_profile, user_date_crea, user_last_modify, user_validity) VALUES (DEFAULT, 'admin', 'ldz8xiJGiGs4U', 1, 1, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Y');


INSERT INTO priority VALUES (1, E'baja', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO priority VALUES (2, E'media', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO priority VALUES (3, E'alta', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
