-- MySQL Workbench Forward Engineering



-- -----------------------------------------------------
-- Table `auth_lexicon_permission`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `auth_lexicon_permission` (
  `idpermission` INT(11) NOT NULL AUTO_INCREMENT,
  `permission` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`idpermission`))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8mb4;


-- -----------------------------------------------------
-- Table `auth_meta_permissions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `auth_meta_permissions` (
  `idauth_permissions` INT(11) NOT NULL AUTO_INCREMENT,
  `auth` INT(11) NOT NULL,
  `permission` INT(11) NOT NULL,
  PRIMARY KEY (`idauth_permissions`),
  INDEX `fk_auth_permission_permission_idx` (`permission` ASC),
  INDEX `fk_auth_permission_auth_idx` (`auth` ASC),
  CONSTRAINT `fk_auth_permission_auth`
    FOREIGN KEY (`auth`)
    REFERENCES `auth` (`idauth`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_auth_permission_permission`
    FOREIGN KEY (`permission`)
    REFERENCES `auth_lexicon_permission` (`idpermission`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8mb4;


-- -----------------------------------------------------
-- Table `auth_role`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `auth_role` (
  `idrole` INT(11) NOT NULL AUTO_INCREMENT,
  `role` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`idrole`))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8mb4;


-- -----------------------------------------------------
-- Table `auth_session`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `auth_session` (
  `idsession` INT(11) NOT NULL AUTO_INCREMENT,
  `session` VARCHAR(255) NOT NULL,
  `auth` INT(11) NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`idsession`),
  INDEX `fk_session_auth_idx` (`auth` ASC),
  CONSTRAINT `fk_session_auth`
    FOREIGN KEY (`auth`)
    REFERENCES `auth` (`idauth`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8mb4;


-- -----------------------------------------------------
-- Table `entity_comment`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `entity_comment` (
  `idcomment` INT(11) NOT NULL AUTO_INCREMENT,
  `entity` INT(11) NOT NULL,
  `record` INT(11) NOT NULL,
  `field` VARCHAR(255) NOT NULL,
  `comment` TEXT NOT NULL,
  `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` INT(11) NOT NULL,
  PRIMARY KEY (`idcomment`),
  INDEX `fk_entity_comment_auth_idx` (`created_by` ASC),
  CONSTRAINT `fk_entity_comment_auth`
    FOREIGN KEY (`created_by`)
    REFERENCES `auth` (`idauth`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8mb4;


-- -----------------------------------------------------
-- Table `entity_report_basic`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `entity_report_basic` (
  `idreport_basic` INT(11) NOT NULL AUTO_INCREMENT,
  `titolo` TEXT NULL DEFAULT NULL,
  `autore` TEXT NULL DEFAULT NULL,
  `id_open_coesione` VARCHAR(255) NULL DEFAULT NULL,
  `api_data` LONGTEXT NULL DEFAULT NULL,
  `indirizzo` TEXT NULL DEFAULT NULL,
  `cap` VARCHAR(5) NULL DEFAULT NULL,
  `lat_` VARCHAR(255) NULL DEFAULT NULL,
  `lon_` VARCHAR(255) NULL DEFAULT NULL,
  `descrizione` TEXT NULL DEFAULT NULL,
  `parte_di_piano` TEXT NULL DEFAULT NULL,
  `titolo_progetto` TEXT NULL DEFAULT NULL,
  `dimensione` TEXT NULL DEFAULT NULL,
  `tema` TEXT NULL DEFAULT NULL,
  `ciclo_di_programmazione` TEXT NULL DEFAULT NULL,
  `programma_operativo` TEXT NULL DEFAULT NULL,
  `giudizio_sintetico` ENUM('Appena iniziato', 'In corso e procede bene', 'Procede con difficoltà', 'Bloccato', 'Concluso e utile', 'Concluso e inefficace') NULL DEFAULT NULL,
  `avanzamento` TEXT NULL DEFAULT NULL,
  `risultato_progetto` TEXT NULL DEFAULT NULL,
  `valutazione_risultati` TINYINT(4) NULL DEFAULT NULL,
  `punti_di_forza` TEXT NULL DEFAULT NULL,
  `punti_deboli` TEXT NULL DEFAULT NULL,
  `problemi_amministrativi` TINYINT(4) NULL DEFAULT NULL,
  `diffusione_twitter` TINYINT(4) NULL DEFAULT NULL,
  `diffusione_facebook` TINYINT(4) NULL DEFAULT NULL,
  `diffusione_instagram` TINYINT(4) NULL DEFAULT NULL,
  `diffusione_eventi` TINYINT(4) NULL DEFAULT NULL,
  `diffusione_open_admin` TINYINT(4) NULL DEFAULT NULL,
  `diffusione_blog` TINYINT(4) NULL DEFAULT NULL,
  `diffusione_offline` TINYINT(4) NULL DEFAULT NULL,
  `diffusione_incontri` TINYINT(4) NULL DEFAULT NULL,
  `diffusione_interviste` TINYINT(4) NULL DEFAULT NULL,
  `diffusione_altro` TEXT NULL DEFAULT NULL,
  `media_connection` TINYINT(4) NULL DEFAULT NULL,
  `tv_locali` TINYINT(4) NULL DEFAULT NULL,
  `tv_nazionali` TINYINT(4) NULL DEFAULT NULL,
  `giornali_locali` TINYINT(4) NULL DEFAULT NULL,
  `giornali_nazionali` TINYINT(4) NULL DEFAULT NULL,
  `blog_online` TINYINT(4) NULL DEFAULT NULL,
  `media_other` TEXT NULL DEFAULT NULL,
  `admin_connection` TINYINT(4) NULL DEFAULT NULL,
  `admin_response_no` TINYINT(4) NULL DEFAULT NULL,
  `admin_response_formal` TINYINT(4) NULL DEFAULT NULL,
  `admin_response_some` TINYINT(4) NULL DEFAULT NULL,
  `admin_response_promises` TINYINT(4) NULL DEFAULT NULL,
  `admin_response_unlocked` TINYINT(4) NULL DEFAULT NULL,
  `admin_response_flagged` TINYINT(4) NULL DEFAULT NULL,
  `admin_altro` TEXT NULL DEFAULT NULL,
  `impact_description` TEXT NULL DEFAULT NULL,
  `rischi` TEXT NULL DEFAULT NULL,
  `soluzioni_progetto` TEXT NULL DEFAULT NULL,
  `raccolta_informazioni` TEXT NULL DEFAULT NULL,
  `visita_diretta` TINYINT(4) NULL DEFAULT NULL,
  `intervista_responsabili_progetto` TINYINT(4) NULL DEFAULT NULL,
  `intervista_utenti_beneficiari` TINYINT(4) NULL DEFAULT NULL,
  `intervista_altri_utenti` TINYINT(4) NULL DEFAULT NULL,
  `intervista_autorita_gestione` TINYINT(4) NULL DEFAULT NULL,
  `intervista_soggetto_programmatore` TINYINT(4) NULL DEFAULT NULL,
  `raccolta_info_web` TINYINT(4) NULL DEFAULT NULL,
  `raccolta_info_attuatore` TINYINT(4) NULL DEFAULT NULL,
  `referenti_politici` TINYINT(4) NULL DEFAULT NULL,
  `intervista_intervistati` TEXT NULL DEFAULT NULL,
  `intervista_domande` TEXT NULL DEFAULT NULL,
  `intervista_risposte` TEXT NULL DEFAULT NULL,
  `problemi_tecnici` INT(11) NULL DEFAULT NULL,
  `risultato_insoddisfacente` INT(11) NULL DEFAULT NULL,
  `non_efficace` INT(11) NULL DEFAULT NULL,
  `non_sufficiente` INT(11) NULL DEFAULT NULL,
  `necessita_interventi_extra` INT(11) NULL DEFAULT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` INT(11) NOT NULL,
  `reviewed_by` INT(11) NULL DEFAULT NULL,
  `status` INT(11) NOT NULL DEFAULT '1' COMMENT 'This field can have the following values: \\n1 = Draft\\n3 = Pending Review\\n5 = In Review\\n7 = Published',
  `status_tab_3` INT(11) NULL DEFAULT '1',
  `tab_3_created_at` TIMESTAMP NULL DEFAULT NULL,
  `author_type` VARCHAR(150) NULL DEFAULT NULL,
  `legacy_id` INT(11) NULL DEFAULT NULL,
  `immagine_monitoraggio_daASOC` VARCHAR(255) NULL DEFAULT NULL,
  `video_daASOC` VARCHAR(255) NULL DEFAULT NULL,
  `immagine_team1_daASOC` VARCHAR(255) NULL DEFAULT NULL,
  `immagine_team2_daASOC` VARCHAR(255) NULL DEFAULT NULL,
  `immagine_team3_daASOC` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`idreport_basic`),
  INDEX `fk_report_basic_creator_idx` (`created_by` ASC),
  INDEX `fk_report_basic_reviewer_idx` (`reviewed_by` ASC),
  INDEX `idx_legacy_id` (`legacy_id` ASC),
  CONSTRAINT `fk_report_basic_creator`
    FOREIGN KEY (`created_by`)
    REFERENCES `auth` (`idauth`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_report_basic_reviewer`
    FOREIGN KEY (`reviewed_by`)
    REFERENCES `auth` (`idauth`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;


-- -----------------------------------------------------
-- Table `lexicon_file_type`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `lexicon_file_type` (
  `idlexicon_file_type` INT(11) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(255) NOT NULL,
  `default_disclosure` TINYINT(4) NULL DEFAULT NULL,
  PRIMARY KEY (`idlexicon_file_type`))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `file_repository`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `file_repository` (
  `idfile_repository` INT(11) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(255) NULL DEFAULT NULL,
  `file_path` VARCHAR(255) NOT NULL,
  `file_size` INT(11) NULL DEFAULT NULL,
  `file_type` INT(11) NOT NULL,
  `disclosure` TINYINT(4) NULL DEFAULT '100',
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified_by` INT(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`idfile_repository`),
  INDEX `fk_file_repository_lexicon_file_type_idx` (`file_type` ASC),
  INDEX `fk_file_respository_modified_by` (`modified_by` ASC),
  CONSTRAINT `fk_file_repository_lexicon_file_type`
    FOREIGN KEY (`file_type`)
    REFERENCES `lexicon_file_type` (`idlexicon_file_type`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_file_respository_modified_by`
    FOREIGN KEY (`modified_by`)
    REFERENCES `auth` (`idauth`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `lexicon_connection_type`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `lexicon_connection_type` (
  `idconnection_type` INT(11) NOT NULL AUTO_INCREMENT,
  `connection_type` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`idconnection_type`))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8mb4;


-- -----------------------------------------------------
-- Table `lexicon_region`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `lexicon_region` (
  `idregion` INT(11) NOT NULL AUTO_INCREMENT,
  `region` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`idregion`))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8mb4;


-- -----------------------------------------------------
-- Table `link_repository`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `link_repository` (
  `idlink_repository` INT(11) NOT NULL AUTO_INCREMENT,
  `URL` TEXT NULL DEFAULT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`idlink_repository`))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8mb4;


-- -----------------------------------------------------
-- Table `meta_connection`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `meta_connection` (
  `idmeta_connection` INT(11) NOT NULL AUTO_INCREMENT,
  `report` INT(11) NOT NULL,
  `connection_type` INT(11) NULL DEFAULT NULL,
  `connection_type_other` VARCHAR(255) NULL DEFAULT NULL,
  `subject` VARCHAR(255) NULL DEFAULT NULL,
  `role` VARCHAR(255) NULL DEFAULT NULL,
  `organisation` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`idmeta_connection`),
  INDEX `fk_meta_connection_report_idx` (`report` ASC),
  INDEX `fk_meta_connection_connection_type_idx` (`connection_type` ASC),
  CONSTRAINT `fk_meta_connection_connection_type`
    FOREIGN KEY (`connection_type`)
    REFERENCES `lexicon_connection_type` (`idconnection_type`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_meta_connection_report`
    FOREIGN KEY (`report`)
    REFERENCES `entity_report_basic` (`idreport_basic`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8mb4;


-- -----------------------------------------------------
-- Table `meta_file_repository`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `meta_file_repository` (
  `idmeta_file_repository` INT(11) NOT NULL AUTO_INCREMENT,
  `entity` INT(11) NOT NULL,
  `record` INT(11) NOT NULL,
  `file_repository` INT(11) NOT NULL,
  PRIMARY KEY (`idmeta_file_repository`),
  INDEX `fk_meta_file_repository_file_idx` (`file_repository` ASC),
  INDEX `idx_file_repository_record` (`record` ASC),
  CONSTRAINT `fk_meta_file_repository_file`
    FOREIGN KEY (`file_repository`)
    REFERENCES `file_repository` (`idfile_repository`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `meta_link_repository`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `meta_link_repository` (
  `idmeta_link_repository` INT(11) NOT NULL AUTO_INCREMENT,
  `entity` INT(11) NOT NULL,
  `record` INT(11) NOT NULL,
  `link_repository` INT(11) NOT NULL,
  PRIMARY KEY (`idmeta_link_repository`),
  INDEX `fk_meta_link_repository_link_idx` (`link_repository` ASC),
  INDEX `idx_link_repository_record` (`record` ASC),
  CONSTRAINT `fk_meta_link_repository_link`
    FOREIGN KEY (`link_repository`)
    REFERENCES `link_repository` (`idlink_repository`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `meta_region`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `meta_region` (
  `idmeta_region` INT(11) NOT NULL,
  `entity` INT(11) NULL DEFAULT NULL,
  `record` INT(11) NULL DEFAULT NULL,
  `region` INT(11) NULL DEFAULT NULL,
  PRIMARY KEY (`idmeta_region`),
  INDEX `fk_region_meta_region_idx` (`region` ASC),
  CONSTRAINT `fk_region_meta_region`
    FOREIGN KEY (`region`)
    REFERENCES `lexicon_region` (`idregion`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4;


-- -----------------------------------------------------
-- Table `video_repository`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `video_repository` (
  `idvideo_repository` INT(11) NOT NULL AUTO_INCREMENT,
  `URL` TEXT NULL DEFAULT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`idvideo_repository`))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8mb4;


-- -----------------------------------------------------
-- Table `meta_video_repository`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `meta_video_repository` (
  `idmeta_video_repository` INT(11) NOT NULL AUTO_INCREMENT,
  `entity` INT(11) NOT NULL,
  `record` INT(11) NOT NULL,
  `video_repository` INT(11) NOT NULL,
  PRIMARY KEY (`idmeta_video_repository`),
  INDEX `fk_meta_video_repository_video_idx` (`video_repository` ASC),
  INDEX `idx_video_repository_record` (`record` ASC),
  CONSTRAINT `fk_meta_video_repository_video`
    FOREIGN KEY (`video_repository`)
    REFERENCES `video_repository` (`idvideo_repository`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8;

CREATE TABLE `lexicon_theme` (
                                 `idtheme` int(11) NOT NULL AUTO_INCREMENT,
                                 `theme` varchar(255) NOT NULL,
                                 `code` varchar(5) NOT NULL,
                                 `description` varchar(255) NOT NULL,
                                 PRIMARY KEY (`idtheme`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `lexicon_cycle` (
                                 `idcycle` INT NOT NULL AUTO_INCREMENT,
                                 `cycle` VARCHAR(45) NOT NULL,
                                 PRIMARY KEY (`idcycle`));


INSERT INTO `lexicon_file_type` (`title`, `default_disclosure`) VALUES ('Avatar', '100');
INSERT INTO `lexicon_file_type` (`title`, `default_disclosure`) VALUES ('Report Attachment', '100');

INSERT INTO `auth_role` (`idrole`, `role`) VALUES ('1', 'Admin');
INSERT INTO `auth_role` (`idrole`, `role`) VALUES ('2', 'Editor');
INSERT INTO `auth_role` (`idrole`, `role`) VALUES ('3', 'Reporter');


INSERT INTO `auth_lexicon_permission` (`idpermission`, `permission`) VALUES ('2', 'Set Permissions');
INSERT INTO `auth_lexicon_permission` (`idpermission`, `permission`) VALUES ('3', 'Create Report');
INSERT INTO `auth_lexicon_permission` (`idpermission`, `permission`) VALUES ('4', 'Assign Report');
INSERT INTO `auth_lexicon_permission` (`idpermission`, `permission`) VALUES ('5', 'Edit Report');
INSERT INTO `auth_lexicon_permission` (`idpermission`, `permission`) VALUES ('6', 'Comment Report');
INSERT INTO `auth_lexicon_permission` (`idpermission`, `permission`) VALUES ('7', 'Approve Report');
INSERT INTO `auth_lexicon_permission` (`idpermission`, `permission`) VALUES ('8', 'Bounce Report');
INSERT INTO `auth_lexicon_permission` (`idpermission`, `permission`) VALUES ('9', 'Manage Report Card');

INSERT INTO `lexicon_connection_type` (`connection_type`) VALUES ('Intervista (fatta o ricevuta)');
INSERT INTO `lexicon_connection_type` (`connection_type`) VALUES ('Partecipazione congiunta a evento pubblico');
INSERT INTO `lexicon_connection_type` (`connection_type`) VALUES ('Partecipazione a audizione / riunione a porte chiuse');
INSERT INTO `lexicon_connection_type` (`connection_type`) VALUES ('Email o contatto telefonico');
INSERT INTO `lexicon_connection_type` (`connection_type`) VALUES ('Partecipazione a evento istituzionale (es. Riunione Comitato di sorveglianza, Consiglio comunale, etc.)');
INSERT INTO `lexicon_connection_type` (`connection_type`) VALUES ('Altro: specificare');

INSERT INTO `lexicon_cycle` (`cycle`) VALUES ('2000-2006');
INSERT INTO `lexicon_cycle` (`cycle`) VALUES ('2007-2013');
INSERT INTO `lexicon_cycle` (`cycle`) VALUES ('2014-2020');
INSERT INTO `lexicon_cycle` (`cycle`) VALUES ('2021-2027');

INSERT INTO lexicon_theme (code, theme, description) VALUES ("01","Research and Innovation","Research and Innovation");
INSERT INTO lexicon_theme (code, theme, description) VALUES ("02","Digital Agenda","Digital Agenda");
INSERT INTO lexicon_theme (code, theme, description) VALUES ("03","Business Competitiveness","Business Competitiveness");
INSERT INTO lexicon_theme (code, theme, description) VALUES ("04","Energy","Energy and energy efficiency");
INSERT INTO lexicon_theme (code, theme, description) VALUES ("05","Environment","Environment and risk prevention");
INSERT INTO lexicon_theme (code, theme, description) VALUES ("06","Culture and Tourism","Cultural, natural and tourist attraction");
INSERT INTO lexicon_theme (code, theme, description) VALUES ("07","Transportation","Transport and network infrastructures");
INSERT INTO lexicon_theme (code, theme, description) VALUES ("08","Employment","Employment and worker mobility");
INSERT INTO lexicon_theme (code, theme, description) VALUES ("09","Social Inclusion","Social Inclusion");
INSERT INTO lexicon_theme (code, theme, description) VALUES ("10","Childhood and Elderly","Childcare and elderly care services");
INSERT INTO lexicon_theme (code, theme, description) VALUES ("11","Education","Education");
INSERT INTO lexicon_theme (code, theme, description) VALUES ("12","Cities and Rural Areas","Urban and rural renewal");
INSERT INTO lexicon_theme (code, theme, description) VALUES ("13","Public Administration Strenghening","Strengthening the capacity of the Public Administration");