#
# Dumping data for table category_user
#
INSERT INTO l21_category_user (catus_id, catus_name, catus_description, catus_date_crea, catus_last_modify) VALUES (1, '{db-01}', '{db-02}', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO l21_category_user (catus_id, catus_name, catus_description, catus_date_crea, catus_last_modify) VALUES (2, '{db-03}', '{db-03}', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO l21_category_user (catus_id, catus_name, catus_description, catus_date_crea, catus_last_modify) VALUES (3, '{db-04}', '{db-04}', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);


#
# Dumping data for table profile
#
INSERT INTO l21_profile (profile_id, profile_firstname, profile_lastname, 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 (1, '', '', '{db-13}', 'N', '', '0001-01-01', '', '{db-14}', '', '', '', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
#
# Dumping data for table rights
#
INSERT INTO l21_rights (rights_id, rights_dashboard, rights_workshop, rights_project, rights_publication, rights_news, rights_yellowpages, rights_level, rights_scale, rights_category_user, rights_date_crea, rights_last_modify) VALUES (1, 'A', 'A', 'A', 'A', 'A', 'A', 'A', 'A', 'A', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

#
# Dumping data for table scale
#
INSERT INTO l21_scale (scale_id, scale_denomination, scale_surface, scale_inhabitantsnumber, scale_cin, scale_extradata, scale_root, scale_comment, scale_dependencies, scale_date_crea, scale_last_modify, scale_statut) VALUES (1, '{db-15}', 0, 0, '', '', 0, '', 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'P');

# Insert main levels - table level
#
INSERT INTO l21_level (level_id, level_name, level_code, level_label, level_parent, level_desc_project, level_desc_dashboard, level_desc_publication, level_desc_news, level_desc_workshop, level_range, level_date_crea, level_last_modify, level_status) VALUES (1, '{db-16}', '', '{db-26}', 0, '', '', '', '', '', 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'P');
INSERT INTO l21_level (level_id, level_name, level_code, level_label, level_parent, level_desc_project, level_desc_dashboard, level_desc_publication, level_desc_news, level_desc_workshop, level_range, level_date_crea, level_last_modify, level_status) VALUES (2, '{db-17}', '', '{db-26}', 0, '', '', '', '', '', 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'P');
INSERT INTO l21_level (level_id, level_name, level_code, level_label, level_parent, level_desc_project, level_desc_dashboard, level_desc_publication, level_desc_news, level_desc_workshop, level_range, level_date_crea, level_last_modify, level_status) VALUES (3, '{db-18}', '', '{db-26}', 0, '', '', '', '', '', 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'P');
INSERT INTO l21_level (level_id, level_name, level_code, level_label, level_parent, level_desc_project, level_desc_dashboard, level_desc_publication, level_desc_news, level_desc_workshop, level_range, level_date_crea, level_last_modify, level_status) VALUES (4, '{db-19}', '', '{db-26}', 0, '', '', '', '', '', 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'P');
INSERT INTO l21_level (level_id, level_name, level_code, level_label, level_parent, level_desc_project, level_desc_dashboard, level_desc_publication, level_desc_news, level_desc_workshop, level_range, level_date_crea, level_last_modify, level_status) VALUES (5, '{db-25}', '', '{db-20}', 0, '', '', '', '', '', 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'P');

#
# Insert - sub-level
#
INSERT INTO l21_level (level_id, level_name, level_code, level_label, level_parent, level_desc_project, level_desc_dashboard, level_desc_publication, level_desc_news, level_desc_workshop, level_range, level_date_crea, level_last_modify, level_status) VALUES (6, '{db-20}', '', '{db-27}', 1, '{db-21}', '{db-21}', '{db-21}', '{db-21}', '{db-21}', 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'P');


#
# Dumping data for table user
#
INSERT INTO l21_user (user_id, user_login, user_password, user_community, user_category, user_rights, user_profile, user_date_crea, user_last_modify, user_validity) VALUES (1, 'admin', 'ldz8xiJGiGs4U', 1, 1, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Y');

#
# Dumping data for table priority
#
INSERT INTO l21_priority (priority_id, priority_name, priority_date_crea, priority_last_modify) VALUES (1, '{db-22}', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO l21_priority (priority_id, priority_name, priority_date_crea, priority_last_modify) VALUES (2, '{db-23}', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO l21_priority (priority_id, priority_name, priority_date_crea, priority_last_modify) VALUES (3, '{db-24}', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

# Populate l21_finalities table
INSERT INTO `l21_finalities` VALUES (1,'La lutte contre le changement climatique','2016-07-20 12:00:01','2016-07-20 10:00:01','P'),(2,'La préservation de la biodiversité, des milieux et des ressources','2016-07-20 12:00:01','2016-07-20 10:00:01','P'),(3,'La cohésion sociale et la solidarité entre les territoires et les générations','2016-07-20 12:01:01','2016-07-20 10:01:01','P'),(4,'L’épanouissement des êtres humains','2016-07-20 12:01:01','2016-07-20 10:01:01','P'),(5,'Une dynamique de développement suivant des modes de production et de consommation responsables','2016-07-20 12:01:15','2016-07-20 10:01:15','P');

