--
-- 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'administrator', E'super administrator', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO category_user (catus_id, catus_name, catus_description, catus_date_crea, catus_last_modify) VALUES (2, E'privileged user', E'privileged user', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO category_user (catus_id, catus_name, catus_description, catus_date_crea, catus_last_modify) VALUES (3, E'simple user', E'simple user', 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'kids', E'You want to get in touch with sustainable development and environment', '', '', 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'beginner', E'You have a small knowledge of sustainable development', '', '', 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'average', E'You already have good knowledge on sustainable development and want to get more', '', '', 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'expert', E'You are an expert of sustainable development', '', '', 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, 'change_your@address.com', 'N', '', '0001-01-01', E'', E'administrateur 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'Root scale', 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'economic', 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'environment', 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'governance', 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'to modify', '', 1, E'description', E'description', E'description', E'description', E'description', 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'low', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO priority VALUES (2, E'medium', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO priority VALUES (3, E'high', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
