-- Adminer 4.8.1 MySQL 8.0.41-0ubuntu0.22.04.1 dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

SET NAMES utf8mb4;

DROP TABLE IF EXISTS `_language_spoken`;
CREATE TABLE `_language_spoken` (
  `id` int NOT NULL AUTO_INCREMENT,
  `iso_639_1` char(2) NOT NULL,
  `language_name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=183 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `_language_spoken` (`id`, `iso_639_1`, `language_name`) VALUES
(1,	'ab',	'Abkhaz'),
(2,	'aa',	'Afar'),
(3,	'af',	'Afrikaans'),
(4,	'ak',	'Akan'),
(5,	'sq',	'Albanian'),
(6,	'am',	'Amharic'),
(7,	'ar',	'Arabic'),
(8,	'an',	'Aragonese'),
(9,	'hy',	'Armenian'),
(10,	'as',	'Assamese'),
(11,	'av',	'Avaric'),
(12,	'ae',	'Avestan'),
(13,	'ay',	'Aymara'),
(14,	'az',	'Azerbaijani'),
(15,	'bm',	'Bambara'),
(16,	'ba',	'Bashkir'),
(17,	'eu',	'Basque'),
(18,	'be',	'Belarusian'),
(19,	'bn',	'Bengali'),
(20,	'bh',	'Bihari languages'),
(21,	'bi',	'Bislama'),
(22,	'bs',	'Bosnian'),
(23,	'br',	'Breton'),
(24,	'bg',	'Bulgarian'),
(25,	'my',	'Burmese'),
(26,	'ca',	'Catalan; Valencian'),
(27,	'ch',	'Chamorro'),
(28,	'ce',	'Chechen'),
(29,	'ny',	'Chichewa; Chewa; Nyanja'),
(30,	'zh',	'Chinese'),
(31,	'cv',	'Chuvash'),
(32,	'kw',	'Cornish'),
(33,	'co',	'Corsican'),
(34,	'cr',	'Cree'),
(35,	'hr',	'Croatian'),
(36,	'cs',	'Czech'),
(37,	'da',	'Danish'),
(38,	'dv',	'Divehi; Dhivehi; Maldivian'),
(39,	'nl',	'Dutch'),
(40,	'dz',	'Dzongkha'),
(41,	'en',	'English'),
(42,	'eo',	'Esperanto'),
(43,	'et',	'Estonian'),
(44,	'ee',	'Ewe'),
(45,	'fo',	'Faroese'),
(46,	'fj',	'Fijian'),
(47,	'fi',	'Finnish'),
(48,	'fr',	'French'),
(49,	'ff',	'Fulah'),
(50,	'gl',	'Galician'),
(51,	'ka',	'Georgian'),
(52,	'de',	'German'),
(53,	'el',	'Greek, Modern'),
(54,	'gn',	'Guarani'),
(55,	'gu',	'Gujarati'),
(56,	'ht',	'Haitian; Haitian Creole'),
(57,	'ha',	'Hausa'),
(58,	'he',	'Hebrew'),
(59,	'hz',	'Herero'),
(60,	'hi',	'Hindi'),
(61,	'ho',	'Hiri Motu'),
(62,	'hu',	'Hungarian'),
(63,	'ia',	'Interlingua'),
(64,	'id',	'Indonesian'),
(65,	'ie',	'Interlingue'),
(66,	'ga',	'Irish'),
(67,	'ig',	'Igbo'),
(68,	'ik',	'Inupiaq'),
(69,	'io',	'Ido'),
(70,	'is',	'Icelandic'),
(71,	'it',	'Italian'),
(72,	'iu',	'Inuktitut'),
(73,	'ja',	'Japanese'),
(74,	'jv',	'Javanese'),
(75,	'kl',	'Kalaallisut; Greenlandic'),
(76,	'kn',	'Kannada'),
(77,	'kr',	'Kanuri'),
(78,	'ks',	'Kashmiri'),
(79,	'kk',	'Kazakh'),
(80,	'km',	'Central Khmer'),
(81,	'ki',	'Kikuyu; Gikuyu'),
(82,	'rw',	'Kinyarwanda'),
(83,	'ky',	'Kirghiz; Kyrgyz'),
(84,	'kv',	'Komi'),
(85,	'kg',	'Kongo'),
(86,	'ko',	'Korean'),
(87,	'ku',	'Kurdish'),
(88,	'kj',	'Kuanyama; Kwanyama'),
(89,	'la',	'Latin'),
(90,	'lb',	'Luxembourgish; Letzeburgesch'),
(91,	'lg',	'Ganda'),
(92,	'li',	'Limburgan; Limburger; Limburgish'),
(93,	'ln',	'Lingala'),
(94,	'lo',	'Lao'),
(95,	'lt',	'Lithuanian'),
(96,	'lu',	'Luba-Katanga'),
(97,	'lv',	'Latvian'),
(98,	'gv',	'Manx'),
(99,	'mk',	'Macedonian'),
(100,	'mg',	'Malagasy'),
(101,	'ms',	'Malay'),
(102,	'ml',	'Malayalam'),
(103,	'mt',	'Maltese'),
(104,	'mi',	'Maori'),
(105,	'mr',	'Marathi'),
(106,	'mh',	'Marshallese'),
(107,	'mn',	'Mongolian'),
(108,	'na',	'Nauru'),
(109,	'nv',	'Navajo; Navaho'),
(110,	'nd',	'North Ndebele'),
(111,	'ne',	'Nepali'),
(112,	'ng',	'Ndonga'),
(113,	'nb',	'Norwegian Bokmål'),
(114,	'nn',	'Norwegian Nynorsk'),
(115,	'no',	'Norwegian'),
(116,	'ii',	'Sichuan Yi; Nuosu'),
(117,	'nr',	'South Ndebele'),
(118,	'oc',	'Occitan'),
(119,	'oj',	'Ojibwa'),
(120,	'cu',	'Church Slavic; Old Slavonic; Church Slavonic; Old Bulgarian; Old Church Slavonic'),
(121,	'om',	'Oromo'),
(122,	'or',	'Oriya'),
(123,	'os',	'Ossetian; Ossetic'),
(124,	'pi',	'Pali'),
(125,	'ps',	'Pashto; Pushto'),
(126,	'fa',	'Persian'),
(127,	'pl',	'Polish'),
(128,	'pt',	'Portuguese'),
(129,	'pa',	'Punjabi; Panjabi'),
(130,	'qu',	'Quechua'),
(131,	'ro',	'Romanian; Moldavian; Moldovan'),
(132,	'rm',	'Romansh'),
(133,	'rn',	'Rundi'),
(134,	'ru',	'Russian'),
(135,	'se',	'Northern Sami'),
(136,	'sm',	'Samoan'),
(137,	'sg',	'Sango'),
(138,	'sa',	'Sanskrit'),
(139,	'sc',	'Sardinian'),
(140,	'sr',	'Serbian'),
(141,	'sn',	'Shona'),
(142,	'sd',	'Sindhi'),
(143,	'si',	'Sinhala; Sinhalese'),
(144,	'sk',	'Slovak'),
(145,	'sl',	'Slovenian'),
(146,	'so',	'Somali'),
(147,	'st',	'Southern Sotho'),
(148,	'es',	'Spanish; Castilian'),
(149,	'su',	'Sundanese'),
(150,	'sw',	'Swahili'),
(151,	'ss',	'Swati'),
(152,	'sv',	'Swedish'),
(153,	'ta',	'Tamil'),
(154,	'te',	'Telugu'),
(155,	'tg',	'Tajik'),
(156,	'th',	'Thai'),
(157,	'ti',	'Tigrinya'),
(158,	'bo',	'Tibetan'),
(159,	'tk',	'Turkmen'),
(160,	'tl',	'Tagalog'),
(161,	'tn',	'Tswana'),
(162,	'to',	'Tonga (Tonga Islands)'),
(163,	'tr',	'Turkish'),
(164,	'ts',	'Tsonga'),
(165,	'tt',	'Tatar'),
(166,	'tw',	'Twi'),
(167,	'ty',	'Tahitian'),
(168,	'ug',	'Uighur; Uyghur'),
(169,	'uk',	'Ukrainian'),
(170,	'ur',	'Urdu'),
(171,	'uz',	'Uzbek'),
(172,	've',	'Venda'),
(173,	'vi',	'Vietnamese'),
(174,	'vo',	'Volapük'),
(175,	'wa',	'Walloon'),
(176,	'cy',	'Welsh'),
(177,	'wo',	'Wolof'),
(178,	'xh',	'Xhosa'),
(179,	'yi',	'Yiddish'),
(180,	'yo',	'Yoruba'),
(181,	'za',	'Zhuang; Chuang'),
(182,	'zu',	'Zulu');

DROP TABLE IF EXISTS `_location_countries`;
CREATE TABLE `_location_countries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=195 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `_location_countries` (`id`, `name`) VALUES
(1,	'Afghanistan'),
(2,	'Albania'),
(3,	'Algeria'),
(4,	'Andorra'),
(5,	'Angola'),
(6,	'Antigua and Barbuda'),
(7,	'Argentina'),
(8,	'Armenia'),
(9,	'Australia'),
(10,	'Austria'),
(11,	'Azerbaijan'),
(12,	'Bahamas'),
(13,	'Bahrain'),
(14,	'Bangladesh'),
(15,	'Barbados'),
(16,	'Belarus'),
(17,	'Belgium'),
(18,	'Belize'),
(19,	'Benin'),
(20,	'Bhutan'),
(21,	'Bolivia'),
(22,	'Bosnia and Herzegovina'),
(23,	'Botswana'),
(24,	'Brazil'),
(25,	'Brunei'),
(26,	'Bulgaria'),
(27,	'Burkina Faso'),
(28,	'Burundi'),
(29,	'Cabo Verde'),
(30,	'Cambodia'),
(31,	'Cameroon'),
(32,	'Canada'),
(33,	'Central African Republic'),
(34,	'Chad'),
(35,	'Chile'),
(36,	'China'),
(37,	'Colombia'),
(38,	'Comoros'),
(39,	'Congo, Democratic Republic of the'),
(40,	'Congo, Republic of the'),
(41,	'Costa Rica'),
(42,	'Croatia'),
(43,	'Cuba'),
(44,	'Cyprus'),
(45,	'Czech Republic'),
(46,	'Denmark'),
(47,	'Djibouti'),
(48,	'Dominica'),
(49,	'Dominican Republic'),
(50,	'Ecuador'),
(51,	'Egypt'),
(52,	'El Salvador'),
(53,	'Equatorial Guinea'),
(54,	'Eritrea'),
(55,	'Estonia'),
(56,	'Eswatini'),
(57,	'Ethiopia'),
(58,	'Fiji'),
(59,	'Finland'),
(60,	'France'),
(61,	'Gabon'),
(62,	'Gambia'),
(63,	'Georgia'),
(64,	'Germany'),
(65,	'Ghana'),
(66,	'Greece'),
(67,	'Grenada'),
(68,	'Guatemala'),
(69,	'Guinea'),
(70,	'Guinea-Bissau'),
(71,	'Guyana'),
(72,	'Haiti'),
(73,	'Honduras'),
(74,	'Hungary'),
(75,	'Iceland'),
(76,	'India'),
(77,	'Indonesia'),
(78,	'Iran'),
(79,	'Iraq'),
(80,	'Ireland'),
(81,	'Israel'),
(82,	'Italy'),
(83,	'Jamaica'),
(84,	'Japan'),
(85,	'Jordan'),
(86,	'Kazakhstan'),
(87,	'Kenya'),
(88,	'Kiribati'),
(89,	'Kuwait'),
(90,	'Kyrgyzstan'),
(91,	'Laos'),
(92,	'Latvia'),
(93,	'Lebanon'),
(94,	'Lesotho'),
(95,	'Liberia'),
(96,	'Libya'),
(97,	'Liechtenstein'),
(98,	'Lithuania'),
(99,	'Luxembourg'),
(100,	'Madagascar'),
(101,	'Malawi'),
(102,	'Malaysia'),
(103,	'Maldives'),
(104,	'Mali'),
(105,	'Malta'),
(106,	'Marshall Islands'),
(107,	'Mauritania'),
(108,	'Mauritius'),
(109,	'Mexico'),
(110,	'Micronesia'),
(111,	'Moldova'),
(112,	'Monaco'),
(113,	'Mongolia'),
(114,	'Montenegro'),
(115,	'Morocco'),
(116,	'Mozambique'),
(117,	'Myanmar'),
(118,	'Namibia'),
(119,	'Nauru'),
(120,	'Nepal'),
(121,	'Netherlands'),
(122,	'New Zealand'),
(123,	'Nicaragua'),
(124,	'Niger'),
(125,	'Nigeria'),
(126,	'North Korea'),
(127,	'North Macedonia'),
(128,	'Norway'),
(129,	'Oman'),
(130,	'Pakistan'),
(131,	'Palau'),
(132,	'Panama'),
(133,	'Papua New Guinea'),
(134,	'Paraguay'),
(135,	'Peru'),
(136,	'Philippines'),
(137,	'Poland'),
(138,	'Portugal'),
(139,	'Qatar'),
(140,	'Romania'),
(141,	'Russia'),
(142,	'Rwanda'),
(143,	'Saint Kitts and Nevis'),
(144,	'Saint Lucia'),
(145,	'Saint Vincent and the Grenadines'),
(146,	'Samoa'),
(147,	'San Marino'),
(148,	'Sao Tome and Principe'),
(149,	'Saudi Arabia'),
(150,	'Senegal'),
(151,	'Serbia'),
(152,	'Seychelles'),
(153,	'Sierra Leone'),
(154,	'Singapore'),
(155,	'Slovakia'),
(156,	'Slovenia'),
(157,	'Solomon Islands'),
(158,	'Somalia'),
(159,	'South Africa'),
(160,	'South Korea'),
(161,	'South Sudan'),
(162,	'Spain'),
(163,	'Sri Lanka'),
(164,	'Sudan'),
(165,	'Suriname'),
(166,	'Sweden'),
(167,	'Switzerland'),
(168,	'Syria'),
(169,	'Tajikistan'),
(170,	'Tanzania'),
(171,	'Thailand'),
(172,	'Timor-Leste'),
(173,	'Togo'),
(174,	'Tonga'),
(175,	'Trinidad and Tobago'),
(176,	'Tunisia'),
(177,	'Turkey'),
(178,	'Turkmenistan'),
(179,	'Tuvalu'),
(180,	'Uganda'),
(181,	'Ukraine'),
(182,	'United Arab Emirates'),
(183,	'United Kingdom'),
(184,	'United States'),
(185,	'Uruguay'),
(186,	'Uzbekistan'),
(187,	'Vanuatu'),
(188,	'Venezuela'),
(189,	'Vietnam'),
(190,	'Yemen'),
(191,	'Zambia'),
(192,	'Zimbabwe'),
(193,	'Taiwan'),
(194,	'Transnistria');

DROP TABLE IF EXISTS `_location_nationalities`;
CREATE TABLE `_location_nationalities` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=196 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `_location_nationalities` (`id`, `name`) VALUES
(1,	'Afghan'),
(2,	'Albanian'),
(3,	'Algerian'),
(4,	'Andorran'),
(5,	'Angolan'),
(6,	'Antiguan or Barbudan'),
(7,	'Argentine'),
(8,	'Armenian'),
(9,	'Australian'),
(10,	'Austrian'),
(11,	'Azerbaijani'),
(12,	'Bahamian'),
(13,	'Bahraini'),
(14,	'Bangladeshi'),
(15,	'Barbadian'),
(16,	'Belarusian'),
(17,	'Belgian'),
(18,	'Belizean'),
(19,	'Beninese'),
(20,	'Bhutanese'),
(21,	'Bolivian'),
(22,	'Bosnian or Herzegovinian'),
(23,	'Botswanan'),
(24,	'Brazilian'),
(25,	'Bruneian'),
(26,	'Bulgarian'),
(27,	'Burkinabé'),
(28,	'Burundian'),
(29,	'Cabo Verdean'),
(30,	'Cambodian'),
(31,	'Cameroonian'),
(32,	'Canadian'),
(33,	'Central African'),
(34,	'Chadian'),
(35,	'Chilean'),
(36,	'Chinese'),
(37,	'Colombian'),
(38,	'Comorian'),
(39,	'Congolese (Democratic Republic)'),
(40,	'Congolese (Republic)'),
(41,	'Costa Rican'),
(42,	'Croatian'),
(43,	'Cuban'),
(44,	'Cypriot'),
(45,	'Czech'),
(46,	'Danish'),
(47,	'Djiboutian'),
(48,	'Dominican'),
(49,	'Dominican (Dominican Republic)'),
(50,	'Ecuadorian'),
(51,	'Egyptian'),
(52,	'Salvadoran'),
(53,	'Equatorial Guinean'),
(54,	'Eritrean'),
(55,	'Estonian'),
(56,	'Eswatini'),
(57,	'Ethiopian'),
(58,	'Fijian'),
(59,	'Finnish'),
(60,	'French'),
(61,	'Gabonese'),
(62,	'Gambian'),
(63,	'Georgian'),
(64,	'German'),
(65,	'Ghanaian'),
(66,	'Greek'),
(67,	'Grenadian'),
(68,	'Guatemalan'),
(69,	'Guinean'),
(70,	'Bissau-Guinean'),
(71,	'Guyanese'),
(72,	'Haitian'),
(73,	'Honduran'),
(74,	'Hungarian'),
(75,	'Icelandic'),
(76,	'Indian'),
(77,	'Indonesian'),
(78,	'Iranian'),
(79,	'Iraqi'),
(80,	'Irish'),
(81,	'Israeli'),
(82,	'Italian'),
(83,	'Jamaican'),
(84,	'Japanese'),
(85,	'Jordanian'),
(86,	'Kazakh'),
(87,	'Kenyan'),
(88,	'I-Kiribati'),
(89,	'Kuwaiti'),
(90,	'Kyrgyz'),
(91,	'Lao'),
(92,	'Latvian'),
(93,	'Lebanese'),
(94,	'Basotho'),
(95,	'Liberian'),
(96,	'Libyan'),
(97,	'Liechtensteiner'),
(98,	'Lithuanian'),
(99,	'Luxembourgish'),
(100,	'Malagasy'),
(101,	'Malawian'),
(102,	'Malaysian'),
(103,	'Maldivian'),
(104,	'Malian'),
(105,	'Maltese'),
(106,	'Marshallese'),
(107,	'Mauritanian'),
(108,	'Mauritian'),
(109,	'Mexican'),
(110,	'Micronesian'),
(111,	'Moldovan'),
(112,	'Monégasque'),
(113,	'Mongolian'),
(114,	'Montenegrin'),
(115,	'Moroccan'),
(116,	'Mozambican'),
(117,	'Burmese'),
(118,	'Namibian'),
(119,	'Nauruan'),
(120,	'Nepali'),
(121,	'Dutch'),
(122,	'New Zealander'),
(123,	'Nicaraguan'),
(124,	'Nigerien'),
(125,	'Nigerian'),
(126,	'North Korean'),
(127,	'Macedonian'),
(128,	'Norwegian'),
(129,	'Omani'),
(130,	'Pakistani'),
(131,	'Palauan'),
(132,	'Panamanian'),
(133,	'Papua New Guinean'),
(134,	'Paraguayan'),
(135,	'Peruvian'),
(136,	'Filipino'),
(137,	'Polish'),
(138,	'Portuguese'),
(139,	'Qatari'),
(140,	'Romanian'),
(141,	'Russian'),
(142,	'Rwandan'),
(143,	'Kittitian or Nevisian'),
(144,	'Saint Lucian'),
(145,	'Saint Vincentian'),
(146,	'Samoan'),
(147,	'Sammarinese'),
(148,	'São Toméan'),
(149,	'Saudi'),
(150,	'Senegalese'),
(151,	'Serbian'),
(152,	'Seychellois'),
(153,	'Sierra Leonean'),
(154,	'Singaporean'),
(155,	'Slovak'),
(156,	'Slovene'),
(157,	'Solomon Islander'),
(158,	'Somali'),
(159,	'South African'),
(160,	'South Korean'),
(161,	'South Sudanese'),
(162,	'Spanish'),
(163,	'Sri Lankan'),
(164,	'Sudanese'),
(165,	'Surinamese'),
(166,	'Swedish'),
(167,	'Swiss'),
(168,	'Syrian'),
(169,	'Tajik'),
(170,	'Tanzanian'),
(171,	'Thai'),
(172,	'Timorese'),
(173,	'Togolese'),
(174,	'Tongan'),
(175,	'Trinidadian or Tobagonian'),
(176,	'Tunisian'),
(177,	'Turkish'),
(178,	'Turkmen'),
(179,	'Tuvaluan'),
(180,	'Ugandan'),
(181,	'Ukrainian'),
(182,	'Emirati'),
(183,	'British'),
(184,	'American'),
(185,	'Uruguayan'),
(186,	'Uzbek'),
(187,	'Ni-Vanuatu'),
(188,	'Venezuelan'),
(189,	'Vietnamese'),
(190,	'Yemeni'),
(191,	'Zambian'),
(192,	'Zimbabwean'),
(193,	'Palestinian'),
(194,	'Taiwanese'),
(195,	'Transnistrian');

DROP TABLE IF EXISTS `_terms_of_services`;
CREATE TABLE `_terms_of_services` (
  `id` int NOT NULL AUTO_INCREMENT,
  `content` longtext NOT NULL,
  `version` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `_terms_of_services` (`id`, `content`, `version`) VALUES
(1,	'aaaaa',	2);

DROP TABLE IF EXISTS `jobs_categories`;
CREATE TABLE `jobs_categories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_it` varchar(255) NOT NULL,
  `name_en` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `jobs_categories` (`id`, `name_it`, `name_en`) VALUES
(1,	'Agricoltura, silvicoltura e pesca',	'Agriculture, forestry and fishing'),
(2,	'Produzioni alimentari',	'Food production'),
(3,	'Legno e arredo',	'Wood and furniture'),
(4,	'Carta e cartotecnica',	'Paper and paper products'),
(5,	'Tessile, abbigliamento, calzaturiero e sistema moda',	'Textile, clothing, footwear and fashion system'),
(6,	'Chimica',	'Chemistry'),
(7,	'Estrazione gas, petrolio, carbone, minerali e lavorazione pietre',	'Gas, oil, coal, minerals extraction and stone processing'),
(8,	'Vetro, ceramica e materiali da costruzione',	'Glass, ceramics and construction materials'),
(9,	'Edilizia',	'Construction'),
(10,	'Meccanica, produzione e manutenzione di macchine, impiantistica',	'Mechanics, machinery production and maintenance, plant engineering'),
(11,	'Trasporti e logistica',	'Transport and logistics'),
(12,	'Servizi di distribuzione commerciale',	'Commercial distribution services'),
(13,	'Servizi finanziari e assicurativi',	'Financial and insurance services'),
(14,	'Servizi digitali',	'Digital services'),
(15,	'Servizi di telecomunicazione e poste',	'Telecommunications and postal services'),
(16,	'Servizi di public utilities',	'Public utilities services'),
(17,	'Stampa ed editoria',	'Printing and publishing'),
(18,	'Servizi di educazione, formazione e lavoro',	'Education, training and labor services'),
(19,	'Servizi socio-sanitari',	'Social and health services'),
(20,	'Servizi alla persona',	'Personal services'),
(21,	'Servizi di attività ricreative e sportive',	'Recreational and sports services'),
(22,	'Servizi culturali e di spettacolo',	'Cultural and entertainment services'),
(23,	'Servizi turistici',	'Tourism services'),
(24,	'Area comune',	'Common area');

DROP TABLE IF EXISTS `membership_plans`;
CREATE TABLE `membership_plans` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `membership_plans` (`id`, `name`) VALUES
(1,	'Free Plan');

DROP TABLE IF EXISTS `skills`;
CREATE TABLE `skills` (
  `id` int NOT NULL AUTO_INCREMENT,
  `job_category_id` int NOT NULL,
  `name_it` varchar(255) NOT NULL,
  `name_en` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `job_category_id` (`job_category_id`),
  CONSTRAINT `skills_ibfk_1` FOREIGN KEY (`job_category_id`) REFERENCES `jobs_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=241 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `skills` (`id`, `job_category_id`, `name_it`, `name_en`) VALUES
(1,	1,	'Gestione della produzione agricola',	'Agricultural production management'),
(2,	1,	'Conoscenze di coltivazione e allevamento',	'Crop and livestock knowledge'),
(3,	1,	'Gestione del suolo e delle risorse naturali',	'Soil and natural resource management'),
(4,	1,	'Tecniche di irrigazione e drenaggio',	'Irrigation and drainage techniques'),
(5,	1,	'Monitoraggio della qualità dei prodotti',	'Product quality monitoring'),
(6,	1,	'Conoscenze di macchinari agricoli',	'Knowledge of agricultural machinery'),
(7,	1,	'Sicurezza sul lavoro in ambiente rurale',	'Rural workplace safety'),
(8,	1,	'Pianificazione stagionale delle attività',	'Seasonal activity planning'),
(9,	1,	'Gestione sostenibile delle risorse forestali',	'Sustainable forest resource management'),
(10,	1,	'Conoscenze di pesca e gestione acquacoltura',	'Fishing and aquaculture management'),
(11,	2,	'Sicurezza alimentare e igiene',	'Food safety and hygiene'),
(12,	2,	'Controllo qualità dei prodotti',	'Product quality control'),
(13,	2,	'Gestione della produzione industriale',	'Industrial production management'),
(14,	2,	'Conoscenza dei processi di trasformazione alimentare',	'Knowledge of food processing'),
(15,	2,	'Pianificazione e organizzazione della produzione',	'Production planning and organization'),
(16,	2,	'Conoscenze di conservazione e stoccaggio',	'Storage and preservation knowledge'),
(17,	2,	'Controllo materie prime e fornitori',	'Raw material and supplier control'),
(18,	2,	'Conoscenze normative del settore alimentare',	'Food industry regulations knowledge'),
(19,	2,	'Innovazione e sviluppo prodotto',	'Product innovation and development'),
(20,	2,	'Manutenzione macchinari di produzione',	'Maintenance of production machinery'),
(21,	3,	'Conoscenza dei materiali lignei',	'Knowledge of wood materials'),
(22,	3,	'Tecniche di lavorazione del legno',	'Woodworking techniques'),
(23,	3,	'Progettazione di mobili e arredi',	'Furniture and interior design'),
(24,	3,	'Uso di macchinari per falegnameria',	'Use of carpentry machinery'),
(25,	3,	'Controllo qualità prodotti finiti',	'Finished product quality control'),
(26,	3,	'Gestione del ciclo produttivo',	'Production cycle management'),
(27,	3,	'Conoscenze di design e ergonomia',	'Design and ergonomics knowledge'),
(28,	3,	'Pianificazione e gestione del magazzino',	'Warehouse planning and management'),
(29,	3,	'Sicurezza sul lavoro in falegnameria',	'Carpentry workplace safety'),
(30,	3,	'Innovazione e sostenibilità dei materiali',	'Material innovation and sustainability'),
(31,	4,	'Conoscenze dei processi di produzione della carta',	'Knowledge of paper production processes'),
(32,	4,	'Gestione macchinari di stampa e taglio',	'Printing and cutting machinery management'),
(33,	4,	'Controllo qualità della produzione cartaria',	'Paper production quality control'),
(34,	4,	'Pianificazione della produzione e logistica',	'Production planning and logistics'),
(35,	4,	'Conoscenza dei materiali e delle grammature',	'Materials and weight knowledge'),
(36,	4,	'Tecniche di imballaggio e confezionamento',	'Packaging techniques'),
(37,	4,	'Sicurezza industriale',	'Industrial safety'),
(38,	4,	'Innovazione dei processi produttivi',	'Innovation in production processes'),
(39,	4,	'Gestione dei rifiuti e riciclo dei materiali',	'Waste management and material recycling'),
(40,	4,	'Gestione dei fornitori di materie prime',	'Supplier management of raw materials'),
(41,	5,	'Conoscenze di tessuti e materiali',	'Fabric and material knowledge'),
(42,	5,	'Tecniche di confezionamento e cucito',	'Sewing and garment construction techniques'),
(43,	5,	'Progettazione di abbigliamento e calzature',	'Clothing and footwear design'),
(44,	5,	'Gestione della produzione tessile',	'Textile production management'),
(45,	5,	'Controllo qualità tessuti e prodotti finiti',	'Fabric and product quality control'),
(46,	5,	'Sviluppo prodotto e innovazione',	'Product development and innovation'),
(47,	5,	'Gestione fornitori e filiera',	'Supplier and supply chain management'),
(48,	5,	'Conoscenze di moda e tendenze',	'Fashion and trend knowledge'),
(49,	5,	'Sicurezza sul lavoro in laboratorio e produzione',	'Workplace safety in lab and production'),
(50,	5,	'Marketing e promozione nel settore moda',	'Marketing and promotion in fashion sector'),
(51,	6,	'Conoscenze di chimica generale e applicata',	'Knowledge of general and applied chemistry'),
(52,	6,	'Gestione di laboratori chimici',	'Chemical laboratory management'),
(53,	6,	'Analisi e controllo qualità',	'Analysis and quality control'),
(54,	6,	'Sicurezza e normative chimiche',	'Chemical safety and regulations'),
(55,	6,	'Ricerca e sviluppo di nuovi composti',	'Research and development of new compounds'),
(56,	6,	'Gestione dei reagenti e materiali chimici',	'Management of reagents and chemical materials'),
(57,	6,	'Processi di sintesi chimica',	'Chemical synthesis processes'),
(58,	6,	'Automazione e strumentazione di laboratorio',	'Laboratory automation and instrumentation'),
(59,	6,	'Trattamento rifiuti chimici',	'Chemical waste treatment'),
(60,	6,	'Innovazione e miglioramento dei processi',	'Process innovation and improvement'),
(61,	7,	'Gestione delle attività di estrazione',	'Extraction operations management'),
(62,	7,	'Sicurezza in miniere e impianti',	'Mine and plant safety'),
(63,	7,	'Analisi geologica e mineraria',	'Geological and mining analysis'),
(64,	7,	'Tecniche di perforazione e scavo',	'Drilling and excavation techniques'),
(65,	7,	'Gestione impianti di trattamento materiali',	'Material processing plant management'),
(66,	7,	'Manutenzione macchinari industriali',	'Industrial machinery maintenance'),
(67,	7,	'Controllo qualità e monitoraggio ambientale',	'Quality control and environmental monitoring'),
(68,	7,	'Pianificazione e logistica estrattiva',	'Extraction planning and logistics'),
(69,	7,	'Gestione risorse naturali e sostenibilità',	'Natural resource management and sustainability'),
(70,	7,	'Innovazione tecnologica nel settore minerario',	'Technological innovation in mining'),
(71,	8,	'Conoscenze sui materiali da costruzione',	'Knowledge of construction materials'),
(72,	8,	'Processi di produzione di vetro e ceramica',	'Glass and ceramic production processes'),
(73,	8,	'Controllo qualità dei materiali',	'Material quality control'),
(74,	8,	'Gestione macchinari industriali',	'Industrial machinery management'),
(75,	8,	'Sicurezza sul lavoro in produzione',	'Workplace safety in production'),
(76,	8,	'Progettazione e sviluppo prodotto',	'Product design and development'),
(77,	8,	'Gestione della logistica e magazzino',	'Logistics and warehouse management'),
(78,	8,	'Automazione e miglioramento dei processi',	'Process automation and improvement'),
(79,	8,	'Ricerca e innovazione nei materiali',	'Material research and innovation'),
(80,	8,	'Gestione dei fornitori e approvvigionamento',	'Supplier and procurement management'),
(81,	9,	'Progettazione e pianificazione cantieri',	'Construction site design and planning'),
(82,	9,	'Gestione dei materiali da costruzione',	'Construction material management'),
(83,	9,	'Sicurezza sul cantiere',	'Construction site safety'),
(84,	9,	'Gestione del personale e squadre operative',	'Personnel and team management'),
(85,	9,	'Controllo qualità delle opere',	'Work quality control'),
(86,	9,	'Lettura e interpretazione dei progetti',	'Blueprint reading and interpretation'),
(87,	9,	'Gestione dei fornitori e appaltatori',	'Supplier and contractor management'),
(88,	9,	'Pianificazione temporale e logistica',	'Scheduling and logistics planning'),
(89,	9,	'Innovazione e nuove tecnologie in edilizia',	'Innovation and new technologies in construction'),
(90,	9,	'Gestione costi e budget dei cantieri',	'Construction cost and budget management'),
(91,	10,	'Progettazione meccanica e ingegneristica',	'Mechanical and engineering design'),
(92,	10,	'Manutenzione macchinari industriali',	'Industrial machinery maintenance'),
(93,	10,	'Controllo qualità della produzione',	'Production quality control'),
(94,	10,	'Automazione e robotica industriale',	'Industrial automation and robotics'),
(95,	10,	'Gestione impianti e linee produttive',	'Plant and production line management'),
(96,	10,	'Sicurezza sul lavoro in industria',	'Workplace safety in industry'),
(97,	10,	'Pianificazione e ottimizzazione della produzione',	'Production planning and optimization'),
(98,	10,	'Analisi dei guasti e problem solving',	'Failure analysis and problem solving'),
(99,	10,	'Gestione fornitori e componentistica',	'Supplier and component management'),
(100,	10,	'Innovazione tecnologica e processi produttivi',	'Technological innovation and production processes'),
(101,	11,	'Gestione della logistica e magazzino',	'Logistics and warehouse management'),
(102,	11,	'Pianificazione dei trasporti',	'Transport planning'),
(103,	11,	'Gestione flotte e mezzi di trasporto',	'Fleet and transport management'),
(104,	11,	'Sicurezza e normative nel trasporto',	'Transport safety and regulations'),
(105,	11,	'Ottimizzazione percorsi e tempi',	'Route and time optimization'),
(106,	11,	'Controllo qualità e monitoraggio spedizioni',	'Shipment quality control and monitoring'),
(107,	11,	'Gestione dei fornitori di trasporto',	'Transport supplier management'),
(108,	11,	'Gestione delle merci e inventario',	'Goods and inventory management'),
(109,	11,	'Automazione dei processi logistici',	'Logistics process automation'),
(110,	11,	'Innovazione e nuove tecnologie nei trasporti',	'Innovation and new transport technologies'),
(111,	12,	'Gestione punti vendita e store management',	'Store management'),
(112,	12,	'Merchandising e esposizione prodotti',	'Merchandising and product display'),
(113,	12,	'Gestione fornitori e approvvigionamento',	'Supplier and procurement management'),
(114,	12,	'Pianificazione e organizzazione vendite',	'Sales planning and organization'),
(115,	12,	'Gestione del personale e team',	'Personnel and team management'),
(116,	12,	'Controllo qualità prodotti e servizi',	'Product and service quality control'),
(117,	12,	'Analisi mercato e trend',	'Market and trend analysis'),
(118,	12,	'Gestione logistica interna',	'Internal logistics management'),
(119,	12,	'Customer service e soddisfazione clienti',	'Customer service and satisfaction'),
(120,	12,	'Innovazione commerciale e strategie marketing',	'Commercial innovation and marketing strategies'),
(121,	13,	'Gestione contabile e finanziaria',	'Accounting and financial management'),
(122,	13,	'Analisi dei rischi e controllo interno',	'Risk analysis and internal control'),
(123,	13,	'Gestione portafogli e investimenti',	'Portfolio and investment management'),
(124,	13,	'Conoscenze normative e compliance',	'Regulatory knowledge and compliance'),
(125,	13,	'Customer service e gestione clienti',	'Customer service and client management'),
(126,	13,	'Elaborazione pratiche assicurative',	'Insurance claim processing'),
(127,	13,	'Pianificazione finanziaria e strategica',	'Financial and strategic planning'),
(128,	13,	'Valutazione del credito e dei rischi',	'Credit and risk assessment'),
(129,	13,	'Gestione operazioni bancarie e transazioni',	'Banking operations and transaction management'),
(130,	13,	'Innovazione e digitalizzazione dei servizi',	'Innovation and digitalization of services'),
(131,	14,	'Sviluppo software e programmazione',	'Software development and programming'),
(132,	14,	'Gestione sistemi e infrastrutture IT',	'IT systems and infrastructure management'),
(133,	14,	'Sicurezza informatica e protezione dati',	'Cybersecurity and data protection'),
(134,	14,	'Analisi dati e business intelligence',	'Data analysis and business intelligence'),
(135,	14,	'Gestione progetti digitali',	'Digital project management'),
(136,	14,	'User experience e design digitale',	'User experience and digital design'),
(137,	14,	'Automazione dei processi digitali',	'Digital process automation'),
(138,	14,	'Supporto tecnico e assistenza utenti',	'Technical support and user assistance'),
(139,	14,	'Innovazione e nuove tecnologie digitali',	'Innovation and new digital technologies'),
(140,	14,	'Marketing digitale e gestione contenuti',	'Digital marketing and content management'),
(141,	15,	'Gestione reti e infrastrutture di telecomunicazione',	'Telecommunication networks and infrastructure management'),
(142,	15,	'Installazione e manutenzione impianti',	'Installation and maintenance of systems'),
(143,	15,	'Gestione sistemi di posta e logistica',	'Postal and logistics systems management'),
(144,	15,	'Assistenza clienti e supporto tecnico',	'Customer service and technical support'),
(145,	15,	'Sicurezza e normativa nel settore',	'Sector safety and regulations'),
(146,	15,	'Pianificazione e ottimizzazione reti',	'Network planning and optimization'),
(147,	15,	'Controllo qualità servizi e performance',	'Service quality and performance monitoring'),
(148,	15,	'Automazione e innovazione tecnologica',	'Automation and technological innovation'),
(149,	15,	'Gestione fornitori e partner',	'Supplier and partner management'),
(150,	15,	'Analisi dati e monitoraggio traffico',	'Data analysis and traffic monitoring'),
(151,	16,	'Gestione reti idriche ed energetiche',	'Water and energy network management'),
(152,	16,	'Manutenzione impianti e infrastrutture',	'Plant and infrastructure maintenance'),
(153,	16,	'Sicurezza sul lavoro e normativa',	'Workplace safety and regulations'),
(154,	16,	'Gestione fornitori e appaltatori',	'Supplier and contractor management'),
(155,	16,	'Monitoraggio consumi e prestazioni',	'Consumption and performance monitoring'),
(156,	16,	'Pianificazione operativa e logistico-tecnica',	'Operational and technical planning'),
(157,	16,	'Innovazione e tecnologie sostenibili',	'Innovation and sustainable technologies'),
(158,	16,	'Gestione emergenze e continuità servizi',	'Emergency management and service continuity'),
(159,	16,	'Analisi dati e reporting',	'Data analysis and reporting'),
(160,	16,	'Gestione clienti e comunicazione pubblica',	'Customer management and public communication'),
(161,	17,	'Gestione produzione editoriale',	'Editorial production management'),
(162,	17,	'Scrittura e revisione testi',	'Writing and text editing'),
(163,	17,	'Progettazione grafica e impaginazione',	'Graphic design and layout'),
(164,	17,	'Gestione dei contenuti digitali e cartacei',	'Digital and print content management'),
(165,	17,	'Pianificazione e organizzazione pubblicazioni',	'Publication planning and organization'),
(166,	17,	'Controllo qualità e coerenza contenuti',	'Content quality and consistency control'),
(167,	17,	'Marketing e promozione editoriale',	'Editorial marketing and promotion'),
(168,	17,	'Gestione fornitori e collaboratori',	'Supplier and collaborator management'),
(169,	17,	'Innovazione e tecnologie editoriali',	'Editorial innovation and technologies'),
(170,	17,	'Distribuzione e logistica editoriale',	'Editorial distribution and logistics'),
(171,	18,	'Progettazione e pianificazione corsi',	'Course design and planning'),
(172,	18,	'Gestione studenti e partecipanti',	'Student and participant management'),
(173,	18,	'Valutazione e monitoraggio apprendimento',	'Learning assessment and monitoring'),
(174,	18,	'Didattica digitale e metodologie innovative',	'Digital teaching and innovative methodologies'),
(175,	18,	'Gestione risorse educative e materiali',	'Educational resource and material management'),
(176,	18,	'Orientamento e supporto alla carriera',	'Career guidance and support'),
(177,	18,	'Gestione docenti e personale educativo',	'Management of teachers and educational staff'),
(178,	18,	'Normativa e sicurezza scolastica',	'School regulations and safety'),
(179,	18,	'Analisi e report sulle attività formative',	'Analysis and reporting of training activities'),
(180,	18,	'Promozione e comunicazione educativa',	'Educational promotion and communication'),
(181,	19,	'Assistenza sanitaria e sociale',	'Health and social care'),
(182,	19,	'Gestione pazienti e utenti',	'Patient and user management'),
(183,	19,	'Valutazione bisogni e piani di cura',	'Needs assessment and care planning'),
(184,	19,	'Somministrazione farmaci e trattamenti',	'Medication and treatment administration'),
(185,	19,	'Supporto psicologico e sociale',	'Psychological and social support'),
(186,	19,	'Gestione personale sanitario e operatori',	'Healthcare and staff management'),
(187,	19,	'Normativa e sicurezza in ambito sanitario',	'Healthcare regulations and safety'),
(188,	19,	'Promozione salute e prevenzione',	'Health promotion and prevention'),
(189,	19,	'Gestione emergenze sanitarie',	'Healthcare emergency management'),
(190,	19,	'Innovazione e tecnologie in sanità',	'Healthcare innovation and technology'),
(191,	20,	'Assistenza diretta e cura personale',	'Direct assistance and personal care'),
(192,	20,	'Gestione clienti e utenti',	'Client and user management'),
(193,	20,	'Pianificazione e organizzazione attività',	'Activity planning and organization'),
(194,	20,	'Consulenza e supporto individuale',	'Consulting and individual support'),
(195,	20,	'Gestione risorse e materiali',	'Resource and material management'),
(196,	20,	'Normativa e sicurezza sul lavoro',	'Workplace regulations and safety'),
(197,	20,	'Promozione benessere e qualità della vita',	'Wellbeing and quality of life promotion'),
(198,	20,	'Formazione e aggiornamento professionale',	'Professional training and development'),
(199,	20,	'Gestione emergenze e interventi urgenti',	'Emergency and urgent interventions management'),
(200,	20,	'Innovazione e nuovi servizi alla persona',	'Innovation and new personal services'),
(201,	21,	'Organizzazione attività sportive e ricreative',	'Organization of sports and recreational activities'),
(202,	21,	'Gestione strutture e impianti sportivi',	'Management of sports facilities and venues'),
(203,	21,	'Gestione utenti e partecipanti',	'Participant and user management'),
(204,	21,	'Sicurezza e normativa in ambito sportivo',	'Safety and regulations in sports'),
(205,	21,	'Formazione e coaching',	'Training and coaching'),
(206,	21,	'Pianificazione eventi e competizioni',	'Event and competition planning'),
(207,	21,	'Promozione e marketing delle attività',	'Activity promotion and marketing'),
(208,	21,	'Gestione risorse e materiali',	'Resource and material management'),
(209,	21,	'Valutazione performance e miglioramento',	'Performance assessment and improvement'),
(210,	21,	'Innovazione e nuove tecnologie nello sport',	'Innovation and new technologies in sports'),
(211,	22,	'Organizzazione eventi culturali e spettacoli',	'Organization of cultural events and shows'),
(212,	22,	'Gestione artisti e collaboratori',	'Management of artists and collaborators'),
(213,	22,	'Pianificazione e programmazione attività',	'Activity planning and programming'),
(214,	22,	'Promozione e comunicazione',	'Promotion and communication'),
(215,	22,	'Gestione strutture e location',	'Management of venues and locations'),
(216,	22,	'Controllo qualità e supervisione',	'Quality control and supervision'),
(217,	22,	'Gestione risorse e materiali',	'Resource and material management'),
(218,	22,	'Analisi audience e trend culturali',	'Audience analysis and cultural trends'),
(219,	22,	'Normativa e sicurezza negli eventi',	'Event regulations and safety'),
(220,	22,	'Innovazione e tecnologie nello spettacolo',	'Innovation and technology in entertainment'),
(221,	23,	'Organizzazione e gestione tour e viaggi',	'Organization and management of tours and travel'),
(222,	23,	'Assistenza clienti e guide turistiche',	'Customer assistance and tour guiding'),
(223,	23,	'Promozione e marketing turistico',	'Tourism promotion and marketing'),
(224,	23,	'Gestione strutture ricettive',	'Accommodation management'),
(225,	23,	'Pianificazione itinerari e logistica',	'Itinerary planning and logistics'),
(226,	23,	'Gestione fornitori e partner',	'Supplier and partner management'),
(227,	23,	'Controllo qualità dei servizi',	'Service quality control'),
(228,	23,	'Normativa e sicurezza in ambito turistico',	'Tourism regulations and safety'),
(229,	23,	'Analisi mercato e trend turistici',	'Market and tourism trend analysis'),
(230,	23,	'Innovazione e nuove tecnologie nel turismo',	'Innovation and new technologies in tourism'),
(231,	24,	'Gestione amministrativa e documentale',	'Administrative and document management'),
(232,	24,	'Comunicazione interna ed esterna',	'Internal and external communication'),
(233,	24,	'Organizzazione e pianificazione attività',	'Activity organization and planning'),
(234,	24,	'Supporto alla gestione risorse',	'Resource management support'),
(235,	24,	'Controllo qualità e procedure',	'Quality and procedure control'),
(236,	24,	'Analisi dati e reportistica',	'Data analysis and reporting'),
(237,	24,	'Sicurezza e normativa sul lavoro',	'Workplace safety and regulations'),
(238,	24,	'Innovazione e miglioramento dei processi',	'Process innovation and improvement'),
(239,	24,	'Gestione fornitori e collaborazioni',	'Supplier and collaboration management'),
(240,	24,	'Formazione e aggiornamento professionale',	'Professional training and development');

-- 2025-11-19 10:52:06
