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=utf8mb4;
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 care","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","Administrative capacity","Strengthening the capacity of the Public Administration");

CREATE TABLE `lexicon_cycle` (
                                 `idcycle` INT NOT NULL AUTO_INCREMENT,
                                 `cycle` VARCHAR(45) NOT NULL,
                                 PRIMARY KEY (`idcycle`));
INSERT INTO `lexicon_cycle` (`idcycle`,`cycle`) VALUES (-1,'2000-2006');
INSERT INTO `lexicon_cycle` (`idcycle`,`cycle`) VALUES (1,'2007-2013');
INSERT INTO `lexicon_cycle` (`idcycle`,`cycle`) VALUES (2,'2014-2020');
INSERT INTO `lexicon_cycle` (`idcycle`,`cycle`) VALUES (3,'2021-2027');

update lexicon_cycle set idcycle=0 where idcycle=-1;