-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Versione server:              10.4.22-MariaDB - mariadb.org binary distribution
-- S.O. server:                  Win64
-- HeidiSQL Versione:            11.3.0.6376
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- Dump della struttura del database trfcmcauthorized
CREATE DATABASE IF NOT EXISTS `trfcmcauthorized` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `trfcmcauthorized`;

-- Dump della struttura di tabella trfcmcauthorized.additionalrequirements
CREATE TABLE IF NOT EXISTS `additionalrequirements` (
  `idadditionalrequirements` int(11) NOT NULL AUTO_INCREMENT,
  `name_additionalrequirements` varchar(250) NOT NULL,
  `idarticletype` int(11) NOT NULL,
  `name_additionalrequirements_it` varchar(200) DEFAULT NULL,
  `additionalrequirementshelp_it` varchar(250) DEFAULT NULL,
  `name_additionalrequirements_en` varchar(250) DEFAULT NULL,
  `additionalrequirementshelp_en` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`idadditionalrequirements`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.additionalrequirements: ~40 rows (circa)
INSERT INTO `additionalrequirements` (`idadditionalrequirements`, `name_additionalrequirements`, `idarticletype`, `name_additionalrequirements_it`, `additionalrequirementshelp_it`, `name_additionalrequirements_en`, `additionalrequirementshelp_en`) VALUES
	(1, 'name_additionalrequirements_', 1, 'A', NULL, 'A', NULL),
	(2, 'name_additionalrequirements_', 1, 'AN', NULL, 'AN', NULL),
	(3, 'name_additionalrequirements_', 1, 'B', NULL, 'B', NULL),
	(4, 'name_additionalrequirements_', 1, 'C', NULL, 'C', NULL),
	(5, 'name_additionalrequirements_', 1, 'Calzatura elettricamente isolante', NULL, '\nElectrically insulating footwear', NULL),
	(6, 'name_additionalrequirements_', 1, 'CH', NULL, 'CH', NULL),
	(7, 'name_additionalrequirements_', 1, 'CI', NULL, 'CI', NULL),
	(8, 'name_additionalrequirements_', 1, 'CR', NULL, 'CR', NULL),
	(9, 'name_additionalrequirements_', 1, 'E', NULL, 'E', NULL),
	(10, 'name_additionalrequirements_', 1, 'FO', NULL, 'FO', NULL),
	(11, 'name_additionalrequirements_', 1, 'HI', NULL, 'HI', NULL),
	(12, 'name_additionalrequirements_', 1, 'HI1', NULL, 'HI1', NULL),
	(13, 'name_additionalrequirements_', 1, 'HI2', NULL, 'HI2', NULL),
	(14, 'name_additionalrequirements_', 1, 'HI3', NULL, 'HI3', NULL),
	(15, 'name_additionalrequirements_', 1, 'HRO', NULL, 'HRO', NULL),
	(16, 'name_additionalrequirements_', 1, 'IPA', NULL, 'IPA', NULL),
	(17, 'name_additionalrequirements_', 1, 'IPS', NULL, 'IPS', NULL),
	(18, 'name_additionalrequirements_', 1, 'M', NULL, 'M', NULL),
	(19, 'name_additionalrequirements_', 1, 'P', NULL, 'P', NULL),
	(20, 'name_additionalrequirements_', 1, 'SRA', NULL, 'SRA', NULL),
	(21, 'name_additionalrequirements_', 1, 'SRB', NULL, 'SRB', NULL),
	(22, 'name_additionalrequirements_', 1, 'SRC', NULL, 'SRC', NULL),
	(23, 'name_additionalrequirements_', 1, 'T', NULL, 'T', NULL),
	(24, 'name_additionalrequirements_', 1, 'WAD', NULL, 'WAD', NULL),
	(25, 'name_additionalrequirements_', 1, 'WR', NULL, 'WR', NULL),
	(26, 'name_additionalrequirements_', 1, 'WRU', NULL, 'WRU', NULL),
	(27, 'name_additionalrequirements_', 2, 'Comportamento al fuoco', NULL, 'Fire behavior', NULL),
	(28, 'name_additionalrequirements_', 2, 'Flessibilità al freddo estremo ', NULL, 'Extreme cold flexibility', NULL),
	(29, 'name_additionalrequirements_', 2, 'Resistenza ai piccoli spruzzi di metallo fuso', NULL, 'Resistance to small molten metal splash', NULL),
	(30, 'name_additionalrequirements_', 2, 'Resistenza al calore convettivo', NULL, 'Convective heat resistance', NULL),
	(31, 'name_additionalrequirements_', 2, 'Resistenza al calore per contatto', NULL, 'Contact heat resistance', NULL),
	(32, 'name_additionalrequirements_', 2, 'Resistenza al calore radiante', NULL, 'Radiant heat resistance', NULL),
	(33, 'name_additionalrequirements_', 2, 'Resistenza al freddo convettivo', NULL, 'Convective cold resistance', NULL),
	(34, 'name_additionalrequirements_', 2, 'Resistenza al freddo per contatto', NULL, 'Resistenza al freddo per contatto /\nContact cold resistance', NULL),
	(35, 'name_additionalrequirements_', 2, 'Resistenza al taglio da lama', NULL, 'Blade cut resistance', NULL),
	(36, 'name_additionalrequirements_', 2, 'Resistenza al taglio TDM', NULL, 'TDM cut resistance', NULL),
	(37, 'name_additionalrequirements_', 2, 'Resistenza alla perforazione', NULL, 'Puncture resistance', NULL),
	(38, 'name_additionalrequirements_', 2, 'Resistenza all\'abrasione', NULL, 'Abrasion resistance', NULL),
	(39, 'name_additionalrequirements_', 2, 'Resistenza alle grandi proiezioni di metallo fuso', NULL, 'Resistance to the effects of molten metal', NULL),
	(40, 'name_additionalrequirements_', 2, 'Resistenza allo strappo', NULL, 'Tear resistance', NULL);

-- Dump della struttura di tabella trfcmcauthorized.article_characteristic
CREATE TABLE IF NOT EXISTS `article_characteristic` (
  `idarticlecharacteristic` int(11) NOT NULL AUTO_INCREMENT,
  `name_articlecharacteristic` varchar(250) NOT NULL,
  `name_articlecharacteristic_eng` varchar(250) NOT NULL,
  `description_articlecharacteristic` text DEFAULT NULL,
  `idarticletype` int(11) NOT NULL,
  `variablehelp_articlecharacteristic` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`idarticlecharacteristic`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.article_characteristic: ~29 rows (circa)
INSERT INTO `article_characteristic` (`idarticlecharacteristic`, `name_articlecharacteristic`, `name_articlecharacteristic_eng`, `description_articlecharacteristic`, `idarticletype`, `variablehelp_articlecharacteristic`) VALUES
	(1, 'Calzature di protezione per motociclisti', 'Protective footwear for motorcycle riders', NULL, 1, NULL),
	(3, 'Calzature di protezione contro agenti chimici - Contatto limitato', 'Footwear protecting against chemicals - Limited contact', NULL, 1, NULL),
	(4, 'Calzature di protezione contro agenti chimici - Contatto prolungato', 'Footwear protecting against chemicals Prolonged contact', NULL, 1, NULL),
	(5, 'Calzature per Vigili del Fuoco', 'Footwear for firefighters', NULL, 1, NULL),
	(6, 'Calzature di protezione dielettrica per lavori sotto tensione', 'Live working - Footwear for electrical protection', NULL, 1, NULL),
	(7, 'Calzature di sicurezza con resistenza al taglio da sega a catena', 'Safety footwear with resistance to chain saw cutting', NULL, 1, NULL),
	(8, 'Calzature di sicurezza', 'Safety footwear', NULL, 1, NULL),
	(9, 'Calzature di protezione', 'Protective footwear', NULL, 1, NULL),
	(10, 'Calzature da lavoro', 'Occupational footwear', NULL, 1, NULL),
	(11, 'Calzature di protezione contro i rischi presenti nelle fonderie', 'Footwear protecting against risks in foundries', NULL, 1, NULL),
	(12, 'Calzature di protezione contro i rischi presenti nelle operazioni di saldatura', 'Footwear protecting against risks in welding', NULL, 1, NULL),
	(13, 'Guanti e proteggi-braccia di maglia metallica', 'Chain mail gloves and arm guards', NULL, 2, NULL),
	(14, 'Guanti e proteggi-braccia costruiti con materiale diverso dalla maglia metallica', 'Gloves and arm guards made of material other than chain mail', NULL, 2, NULL),
	(15, 'Guanti di protezione per saldatori', 'Protective gloves for welders', NULL, 2, NULL),
	(16, 'Guanti di protezione per motociclisti', 'Protective gloves for motorcycle riders', NULL, 2, NULL),
	(17, 'Guanti e proteggi-braccia contro tagli causati da coltelli motorizzati', 'Gloves and armguards protecting against cuts by powered knives', NULL, 2, NULL),
	(18, 'Guanti con effetto di protezione per i portieri di calcio', 'Gloves with protective effect for association football goal keepers', NULL, 2, NULL),
	(19, 'Guanti di protezione - Proprietà elettrostatiche', 'Protective gloves - Electrostatic properties', NULL, 2, NULL),
	(20, 'Guanti di protezione contro rischi meccanici', 'Protective gloves against mechanical risks', NULL, 2, NULL),
	(21, 'Guanti di protezione e altri dispositivi di protezione delle mani contro rischi termici (calore e/o fuoco)', 'Protective gloves and other hand protective equipments against thermal risks (heat and/or fire)', NULL, 2, NULL),
	(22, 'Guanti di protezione - Requisiti generali e metodi di prova', 'Protective gloves - General requirements and test methods', NULL, 2, NULL),
	(23, 'Guanti di protezione contro le radiazioni ionizzanti e la contaminazione radioattiva', 'Protective gloves against ionizing radiation and radioactive contamination', NULL, 2, NULL),
	(24, 'Guanti di protezione contro il freddo', 'Protective gloves against cold', NULL, 2, NULL),
	(25, 'Guanti di protezione per Vigili del Fuoco', 'Protective gloves for Firefighters', NULL, 2, NULL),
	(26, 'Guanti di protezione dalle vibrazioni meccaniche e urti ', 'Protective gloves against mechanical vibration and shock', NULL, 2, NULL),
	(27, 'Guanti di protezione per utilizzatori di seghe a catena portatili', 'Protective gloves for users of hand-held chainsaws', NULL, 2, NULL),
	(28, 'Guanti di protezione contro i prodotti chimici', 'Protective gloves against dangerous chemicals', NULL, 2, NULL),
	(29, 'Guanti di protezione contro i microorganismi pericolosi', 'Protective gloves against dangerous micro-organisms', NULL, 2, NULL),
	(30, 'Semimaschere filtranti antipolvere', 'Filtering half masks to protect against particles', NULL, 3, NULL);

-- Dump della struttura di tabella trfcmcauthorized.article_measure
CREATE TABLE IF NOT EXISTS `article_measure` (
  `idarticlemeasure` int(11) NOT NULL AUTO_INCREMENT,
  `value_articlemeasure` varchar(200) NOT NULL,
  `description_articlemeasure` text DEFAULT NULL,
  `idarticletype` int(11) NOT NULL,
  PRIMARY KEY (`idarticlemeasure`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.article_measure: ~0 rows (circa)

-- Dump della struttura di tabella trfcmcauthorized.article_type
CREATE TABLE IF NOT EXISTS `article_type` (
  `idarticletype` int(11) NOT NULL AUTO_INCREMENT,
  `name_articletype` varchar(200) NOT NULL,
  `description_articletype` text DEFAULT NULL,
  `name_articletypeeng` varchar(200) NOT NULL,
  PRIMARY KEY (`idarticletype`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.article_type: ~3 rows (circa)
INSERT INTO `article_type` (`idarticletype`, `name_articletype`, `description_articletype`, `name_articletypeeng`) VALUES
	(1, 'Calzatura', NULL, 'Shoe'),
	(2, 'Guanto', NULL, 'Glove'),
	(3, 'Semimaschere', NULL, 'Semi Mask');

-- Dump della struttura di tabella trfcmcauthorized.auditdpi
CREATE TABLE IF NOT EXISTS `auditdpi` (
  `idauditdpi` int(11) NOT NULL AUTO_INCREMENT,
  `idtrfdetails` int(11) NOT NULL,
  `idcertificate` int(11) NOT NULL,
  `certificatenumber` varchar(100) NOT NULL,
  `issuebycimac` char(3) NOT NULL,
  `moduleselection` varchar(200) NOT NULL,
  `sampleinstore` char(3) NOT NULL,
  `filenameaudit` varchar(150) DEFAULT NULL,
  `filenameauditdescription` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`idauditdpi`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.auditdpi: ~9 rows (circa)
INSERT INTO `auditdpi` (`idauditdpi`, `idtrfdetails`, `idcertificate`, `certificatenumber`, `issuebycimac`, `moduleselection`, `sampleinstore`, `filenameaudit`, `filenameauditdescription`) VALUES
	(1, 160, 5, '21-12348', 'no', 'ABCD', '', '1649783951_Documento_sanitario_MSRRRA88A41E063P_20220410214318.pdf', NULL),
	(3, 160, 0, '22', 'no', 'jk', 'yes', 'A', NULL),
	(4, 160, 0, '26', 'no', 'fghf', 'f', 'dggd', NULL),
	(8, 160, 0, 'ahahah', 'no', 'ahahah', 'a', 'ahahah', NULL),
	(9, 160, 0, 'uhuhuhaaaa', 'no', 'uhuhuh', 'Y', 'uhuhuh', NULL),
	(10, 160, 0, 'gdgdfgfd', 'no', 'dgdg', 'yes', '1649782404_Documento_sanitario_MSRRRA88A41E063P_20220410214301.pdf', NULL),
	(11, 160, 0, 'aasas', 'yes', 'asassa', 'y', '1649777794_WhatsApp Image 2022-04-04 at 19.07.44.jpeg', NULL),
	(12, 160, 0, 'gyg', 'yes', 'iiuiui', '', '1649782303_aaa.Informat ICCS ott21 (1).pdf', NULL),
	(13, 160, 0, 'gggg', 'yes', 'ggg', '', '1649784069_Documento_sanitario_MSRRRA88A41E063P_20220410214318.pdf', NULL);

-- Dump della struttura di tabella trfcmcauthorized.auditmanufacturer
CREATE TABLE IF NOT EXISTS `auditmanufacturer` (
  `idauditmanufacturer` int(11) NOT NULL AUTO_INCREMENT,
  `nameauditmanufacturer` varchar(150) NOT NULL DEFAULT '',
  `idtrfdetails` int(11) NOT NULL,
  PRIMARY KEY (`idauditmanufacturer`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.auditmanufacturer: ~5 rows (circa)
INSERT INTO `auditmanufacturer` (`idauditmanufacturer`, `nameauditmanufacturer`, `idtrfdetails`) VALUES
	(1, 'Prova', 99),
	(2, 'Prova', 99),
	(3, 'asd', 99),
	(4, 'asd', 99),
	(5, 'asd', 99);

-- Dump della struttura di tabella trfcmcauthorized.auth_announcements
CREATE TABLE IF NOT EXISTS `auth_announcements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `auth_announcements_user_id_foreign` (`user_id`),
  CONSTRAINT `auth_announcements_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `auth_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella trfcmcauthorized.auth_announcements: ~0 rows (circa)

-- Dump della struttura di tabella trfcmcauthorized.auth_countries
CREATE TABLE IF NOT EXISTS `auth_countries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `capital` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `citizenship` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_sub_unit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `full_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `iso_3166_2` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `iso_3166_3` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `region_code` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `sub_region_code` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `eea` tinyint(1) NOT NULL DEFAULT 0,
  `calling_code` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flag` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=895 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella trfcmcauthorized.auth_countries: ~249 rows (circa)
INSERT INTO `auth_countries` (`id`, `capital`, `citizenship`, `country_code`, `currency`, `currency_code`, `currency_sub_unit`, `currency_symbol`, `full_name`, `iso_3166_2`, `iso_3166_3`, `name`, `region_code`, `sub_region_code`, `eea`, `calling_code`, `flag`) VALUES
	(4, 'Kabul', 'Afghan', '004', 'afghani', 'AFN', 'pul', '؋', 'Islamic Republic of Afghanistan', 'AF', 'AFG', 'Afghanistan', '142', '034', 0, '93', 'AF.png'),
	(8, 'Tirana', 'Albanian', '008', 'lek', 'ALL', '(qindar (pl. qindarka))', 'Lek', 'Republic of Albania', 'AL', 'ALB', 'Albania', '150', '039', 0, '355', 'AL.png'),
	(10, 'Antartica', 'of Antartica', '010', '', '', '', '', 'Antarctica', 'AQ', 'ATA', 'Antarctica', '', '', 0, '672', 'AQ.png'),
	(12, 'Algiers', 'Algerian', '012', 'Algerian dinar', 'DZD', 'centime', 'DZD', 'People’s Democratic Republic of Algeria', 'DZ', 'DZA', 'Algeria', '002', '015', 0, '213', 'DZ.png'),
	(16, 'Pago Pago', 'American Samoan', '016', 'US dollar', 'USD', 'cent', '$', 'Territory of American', 'AS', 'ASM', 'American Samoa', '009', '061', 0, '1', 'AS.png'),
	(20, 'Andorra la Vella', 'Andorran', '020', 'euro', 'EUR', 'cent', '€', 'Principality of Andorra', 'AD', 'AND', 'Andorra', '150', '039', 0, '376', 'AD.png'),
	(24, 'Luanda', 'Angolan', '024', 'kwanza', 'AOA', 'cêntimo', 'Kz', 'Republic of Angola', 'AO', 'AGO', 'Angola', '002', '017', 0, '244', 'AO.png'),
	(28, 'St John’s', 'of Antigua and Barbuda', '028', 'East Caribbean dollar', 'XCD', 'cent', '$', 'Antigua and Barbuda', 'AG', 'ATG', 'Antigua and Barbuda', '019', '029', 0, '1', 'AG.png'),
	(31, 'Baku', 'Azerbaijani', '031', 'Azerbaijani manat', 'AZN', 'kepik (inv.)', 'ман', 'Republic of Azerbaijan', 'AZ', 'AZE', 'Azerbaijan', '142', '145', 0, '994', 'AZ.png'),
	(32, 'Buenos Aires', 'Argentinian', '032', 'Argentine peso', 'ARS', 'centavo', '$', 'Argentine Republic', 'AR', 'ARG', 'Argentina', '019', '005', 0, '54', 'AR.png'),
	(36, 'Canberra', 'Australian', '036', 'Australian dollar', 'AUD', 'cent', '$', 'Commonwealth of Australia', 'AU', 'AUS', 'Australia', '009', '053', 0, '61', 'AU.png'),
	(40, 'Vienna', 'Austrian', '040', 'euro', 'EUR', 'cent', '€', 'Republic of Austria', 'AT', 'AUT', 'Austria', '150', '155', 1, '43', 'AT.png'),
	(44, 'Nassau', 'Bahamian', '044', 'Bahamian dollar', 'BSD', 'cent', '$', 'Commonwealth of the Bahamas', 'BS', 'BHS', 'Bahamas', '019', '029', 0, '1', 'BS.png'),
	(48, 'Manama', 'Bahraini', '048', 'Bahraini dinar', 'BHD', 'fils (inv.)', 'BHD', 'Kingdom of Bahrain', 'BH', 'BHR', 'Bahrain', '142', '145', 0, '973', 'BH.png'),
	(50, 'Dhaka', 'Bangladeshi', '050', 'taka (inv.)', 'BDT', 'poisha (inv.)', 'BDT', 'People’s Republic of Bangladesh', 'BD', 'BGD', 'Bangladesh', '142', '034', 0, '880', 'BD.png'),
	(51, 'Yerevan', 'Armenian', '051', 'dram (inv.)', 'AMD', 'luma', 'AMD', 'Republic of Armenia', 'AM', 'ARM', 'Armenia', '142', '145', 0, '374', 'AM.png'),
	(52, 'Bridgetown', 'Barbadian', '052', 'Barbados dollar', 'BBD', 'cent', '$', 'Barbados', 'BB', 'BRB', 'Barbados', '019', '029', 0, '1', 'BB.png'),
	(56, 'Brussels', 'Belgian', '056', 'euro', 'EUR', 'cent', '€', 'Kingdom of Belgium', 'BE', 'BEL', 'Belgium', '150', '155', 1, '32', 'BE.png'),
	(60, 'Hamilton', 'Bermudian', '060', 'Bermuda dollar', 'BMD', 'cent', '$', 'Bermuda', 'BM', 'BMU', 'Bermuda', '019', '021', 0, '1', 'BM.png'),
	(64, 'Thimphu', 'Bhutanese', '064', 'ngultrum (inv.)', 'BTN', 'chhetrum (inv.)', 'BTN', 'Kingdom of Bhutan', 'BT', 'BTN', 'Bhutan', '142', '034', 0, '975', 'BT.png'),
	(68, 'Sucre (BO1)', 'Bolivian', '068', 'boliviano', 'BOB', 'centavo', '$b', 'Plurinational State of Bolivia', 'BO', 'BOL', 'Bolivia, Plurinational State of', '019', '005', 0, '591', 'BO.png'),
	(70, 'Sarajevo', 'of Bosnia and Herzegovina', '070', 'convertible mark', 'BAM', 'fening', 'KM', 'Bosnia and Herzegovina', 'BA', 'BIH', 'Bosnia and Herzegovina', '150', '039', 0, '387', 'BA.png'),
	(72, 'Gaborone', 'Botswanan', '072', 'pula (inv.)', 'BWP', 'thebe (inv.)', 'P', 'Republic of Botswana', 'BW', 'BWA', 'Botswana', '002', '018', 0, '267', 'BW.png'),
	(74, 'Bouvet island', 'of Bouvet island', '074', '', '', '', 'kr', 'Bouvet Island', 'BV', 'BVT', 'Bouvet Island', '', '', 0, '47', 'BV.png'),
	(76, 'Brasilia', 'Brazilian', '076', 'real (pl. reais)', 'BRL', 'centavo', 'R$', 'Federative Republic of Brazil', 'BR', 'BRA', 'Brazil', '019', '005', 0, '55', 'BR.png'),
	(84, 'Belmopan', 'Belizean', '084', 'Belize dollar', 'BZD', 'cent', 'BZ$', 'Belize', 'BZ', 'BLZ', 'Belize', '019', '013', 0, '501', 'BZ.png'),
	(86, 'Diego Garcia', 'Changosian', '086', 'US dollar', 'USD', 'cent', '$', 'British Indian Ocean Territory', 'IO', 'IOT', 'British Indian Ocean Territory', '', '', 0, '246', 'IO.png'),
	(90, 'Honiara', 'Solomon Islander', '090', 'Solomon Islands dollar', 'SBD', 'cent', '$', 'Solomon Islands', 'SB', 'SLB', 'Solomon Islands', '009', '054', 0, '677', 'SB.png'),
	(92, 'Road Town', 'British Virgin Islander;', '092', 'US dollar', 'USD', 'cent', '$', 'British Virgin Islands', 'VG', 'VGB', 'Virgin Islands, British', '019', '029', 0, '1', 'VG.png'),
	(96, 'Bandar Seri Begawan', 'Bruneian', '096', 'Brunei dollar', 'BND', 'sen (inv.)', '$', 'Brunei Darussalam', 'BN', 'BRN', 'Brunei Darussalam', '142', '035', 0, '673', 'BN.png'),
	(100, 'Sofia', 'Bulgarian', '100', 'lev (pl. leva)', 'BGN', 'stotinka', 'лв', 'Republic of Bulgaria', 'BG', 'BGR', 'Bulgaria', '150', '151', 1, '359', 'BG.png'),
	(104, 'Yangon', 'Burmese', '104', 'kyat', 'MMK', 'pya', 'K', 'Union of Myanmar/', 'MM', 'MMR', 'Myanmar', '142', '035', 0, '95', 'MM.png'),
	(108, 'Bujumbura', 'Burundian', '108', 'Burundi franc', 'BIF', 'centime', 'BIF', 'Republic of Burundi', 'BI', 'BDI', 'Burundi', '002', '014', 0, '257', 'BI.png'),
	(112, 'Minsk', 'Belarusian', '112', 'Belarusian rouble', 'BYR', 'kopek', 'p.', 'Republic of Belarus', 'BY', 'BLR', 'Belarus', '150', '151', 0, '375', 'BY.png'),
	(116, 'Phnom Penh', 'Cambodian', '116', 'riel', 'KHR', 'sen (inv.)', '៛', 'Kingdom of Cambodia', 'KH', 'KHM', 'Cambodia', '142', '035', 0, '855', 'KH.png'),
	(120, 'Yaoundé', 'Cameroonian', '120', 'CFA franc (BEAC)', 'XAF', 'centime', 'FCF', 'Republic of Cameroon', 'CM', 'CMR', 'Cameroon', '002', '017', 0, '237', 'CM.png'),
	(124, 'Ottawa', 'Canadian', '124', 'Canadian dollar', 'CAD', 'cent', '$', 'Canada', 'CA', 'CAN', 'Canada', '019', '021', 0, '1', 'CA.png'),
	(132, 'Praia', 'Cape Verdean', '132', 'Cape Verde escudo', 'CVE', 'centavo', 'CVE', 'Republic of Cape Verde', 'CV', 'CPV', 'Cape Verde', '002', '011', 0, '238', 'CV.png'),
	(136, 'George Town', 'Caymanian', '136', 'Cayman Islands dollar', 'KYD', 'cent', '$', 'Cayman Islands', 'KY', 'CYM', 'Cayman Islands', '019', '029', 0, '1', 'KY.png'),
	(140, 'Bangui', 'Central African', '140', 'CFA franc (BEAC)', 'XAF', 'centime', 'CFA', 'Central African Republic', 'CF', 'CAF', 'Central African Republic', '002', '017', 0, '236', 'CF.png'),
	(144, 'Colombo', 'Sri Lankan', '144', 'Sri Lankan rupee', 'LKR', 'cent', '₨', 'Democratic Socialist Republic of Sri Lanka', 'LK', 'LKA', 'Sri Lanka', '142', '034', 0, '94', 'LK.png'),
	(148, 'N’Djamena', 'Chadian', '148', 'CFA franc (BEAC)', 'XAF', 'centime', 'XAF', 'Republic of Chad', 'TD', 'TCD', 'Chad', '002', '017', 0, '235', 'TD.png'),
	(152, 'Santiago', 'Chilean', '152', 'Chilean peso', 'CLP', 'centavo', 'CLP', 'Republic of Chile', 'CL', 'CHL', 'Chile', '019', '005', 0, '56', 'CL.png'),
	(156, 'Beijing', 'Chinese', '156', 'renminbi-yuan (inv.)', 'CNY', 'jiao (10)', '¥', 'People’s Republic of China', 'CN', 'CHN', 'China', '142', '030', 0, '86', 'CN.png'),
	(158, 'Taipei', 'Taiwanese', '158', 'new Taiwan dollar', 'TWD', 'fen (inv.)', 'NT$', 'Republic of China, Taiwan (TW1)', 'TW', 'TWN', 'Taiwan, Province of China', '142', '030', 0, '886', 'TW.png'),
	(162, 'Flying Fish Cove', 'Christmas Islander', '162', 'Australian dollar', 'AUD', 'cent', '$', 'Christmas Island Territory', 'CX', 'CXR', 'Christmas Island', '', '', 0, '61', 'CX.png'),
	(166, 'Bantam', 'Cocos Islander', '166', 'Australian dollar', 'AUD', 'cent', '$', 'Territory of Cocos (Keeling) Islands', 'CC', 'CCK', 'Cocos (Keeling) Islands', '', '', 0, '61', 'CC.png'),
	(170, 'Santa Fe de Bogotá', 'Colombian', '170', 'Colombian peso', 'COP', 'centavo', '$', 'Republic of Colombia', 'CO', 'COL', 'Colombia', '019', '005', 0, '57', 'CO.png'),
	(174, 'Moroni', 'Comorian', '174', 'Comorian franc', 'KMF', '', 'KMF', 'Union of the Comoros', 'KM', 'COM', 'Comoros', '002', '014', 0, '269', 'KM.png'),
	(175, 'Mamoudzou', 'Mahorais', '175', 'euro', 'EUR', 'cent', '€', 'Departmental Collectivity of Mayotte', 'YT', 'MYT', 'Mayotte', '002', '014', 0, '262', 'YT.png'),
	(178, 'Brazzaville', 'Congolese', '178', 'CFA franc (BEAC)', 'XAF', 'centime', 'FCF', 'Republic of the Congo', 'CG', 'COG', 'Congo', '002', '017', 0, '242', 'CG.png'),
	(180, 'Kinshasa', 'Congolese', '180', 'Congolese franc', 'CDF', 'centime', 'CDF', 'Democratic Republic of the Congo', 'CD', 'COD', 'Congo, the Democratic Republic of the', '002', '017', 0, '243', 'CD.png'),
	(184, 'Avarua', 'Cook Islander', '184', 'New Zealand dollar', 'NZD', 'cent', '$', 'Cook Islands', 'CK', 'COK', 'Cook Islands', '009', '061', 0, '682', 'CK.png'),
	(188, 'San José', 'Costa Rican', '188', 'Costa Rican colón (pl. colones)', 'CRC', 'céntimo', '₡', 'Republic of Costa Rica', 'CR', 'CRI', 'Costa Rica', '019', '013', 0, '506', 'CR.png'),
	(191, 'Zagreb', 'Croatian', '191', 'kuna (inv.)', 'HRK', 'lipa (inv.)', 'kn', 'Republic of Croatia', 'HR', 'HRV', 'Croatia', '150', '039', 1, '385', 'HR.png'),
	(192, 'Havana', 'Cuban', '192', 'Cuban peso', 'CUP', 'centavo', '₱', 'Republic of Cuba', 'CU', 'CUB', 'Cuba', '019', '029', 0, '53', 'CU.png'),
	(196, 'Nicosia', 'Cypriot', '196', 'euro', 'EUR', 'cent', 'CYP', 'Republic of Cyprus', 'CY', 'CYP', 'Cyprus', '142', '145', 1, '357', 'CY.png'),
	(203, 'Prague', 'Czech', '203', 'Czech koruna (pl. koruny)', 'CZK', 'halér', 'Kč', 'Czech Republic', 'CZ', 'CZE', 'Czech Republic', '150', '151', 1, '420', 'CZ.png'),
	(204, 'Porto Novo (BJ1)', 'Beninese', '204', 'CFA franc (BCEAO)', 'XOF', 'centime', 'XOF', 'Republic of Benin', 'BJ', 'BEN', 'Benin', '002', '011', 0, '229', 'BJ.png'),
	(208, 'Copenhagen', 'Danish', '208', 'Danish krone', 'DKK', 'øre (inv.)', 'kr', 'Kingdom of Denmark', 'DK', 'DNK', 'Denmark', '150', '154', 1, '45', 'DK.png'),
	(212, 'Roseau', 'Dominican', '212', 'East Caribbean dollar', 'XCD', 'cent', '$', 'Commonwealth of Dominica', 'DM', 'DMA', 'Dominica', '019', '029', 0, '1', 'DM.png'),
	(214, 'Santo Domingo', 'Dominican', '214', 'Dominican peso', 'DOP', 'centavo', 'RD$', 'Dominican Republic', 'DO', 'DOM', 'Dominican Republic', '019', '029', 0, '1', 'DO.png'),
	(218, 'Quito', 'Ecuadorian', '218', 'US dollar', 'USD', 'cent', '$', 'Republic of Ecuador', 'EC', 'ECU', 'Ecuador', '019', '005', 0, '593', 'EC.png'),
	(222, 'San Salvador', 'Salvadoran', '222', 'Salvadorian colón (pl. colones)', 'SVC', 'centavo', '$', 'Republic of El Salvador', 'SV', 'SLV', 'El Salvador', '019', '013', 0, '503', 'SV.png'),
	(226, 'Malabo', 'Equatorial Guinean', '226', 'CFA franc (BEAC)', 'XAF', 'centime', 'FCF', 'Republic of Equatorial Guinea', 'GQ', 'GNQ', 'Equatorial Guinea', '002', '017', 0, '240', 'GQ.png'),
	(231, 'Addis Ababa', 'Ethiopian', '231', 'birr (inv.)', 'ETB', 'cent', 'ETB', 'Federal Democratic Republic of Ethiopia', 'ET', 'ETH', 'Ethiopia', '002', '014', 0, '251', 'ET.png'),
	(232, 'Asmara', 'Eritrean', '232', 'nakfa', 'ERN', 'cent', 'Nfk', 'State of Eritrea', 'ER', 'ERI', 'Eritrea', '002', '014', 0, '291', 'ER.png'),
	(233, 'Tallinn', 'Estonian', '233', 'euro', 'EUR', 'cent', 'kr', 'Republic of Estonia', 'EE', 'EST', 'Estonia', '150', '154', 1, '372', 'EE.png'),
	(234, 'Tórshavn', 'Faeroese', '234', 'Danish krone', 'DKK', 'øre (inv.)', 'kr', 'Faeroe Islands', 'FO', 'FRO', 'Faroe Islands', '150', '154', 0, '298', 'FO.png'),
	(238, 'Stanley', 'Falkland Islander', '238', 'Falkland Islands pound', 'FKP', 'new penny', '£', 'Falkland Islands', 'FK', 'FLK', 'Falkland Islands (Malvinas)', '019', '005', 0, '500', 'FK.png'),
	(239, 'King Edward Point (Grytviken)', 'of South Georgia and the South Sandwich Islands', '239', '', '', '', '£', 'South Georgia and the South Sandwich Islands', 'GS', 'SGS', 'South Georgia and the South Sandwich Islands', '', '', 0, '44', 'GS.png'),
	(242, 'Suva', 'Fijian', '242', 'Fiji dollar', 'FJD', 'cent', '$', 'Republic of Fiji', 'FJ', 'FJI', 'Fiji', '009', '054', 0, '679', 'FJ.png'),
	(246, 'Helsinki', 'Finnish', '246', 'euro', 'EUR', 'cent', '€', 'Republic of Finland', 'FI', 'FIN', 'Finland', '150', '154', 1, '358', 'FI.png'),
	(248, 'Mariehamn', 'Åland Islander', '248', 'euro', 'EUR', 'cent', NULL, 'Åland Islands', 'AX', 'ALA', 'Åland Islands', '150', '154', 0, '358', NULL),
	(250, 'Paris', 'French', '250', 'euro', 'EUR', 'cent', '€', 'French Republic', 'FR', 'FRA', 'France', '150', '155', 1, '33', 'FR.png'),
	(254, 'Cayenne', 'Guianese', '254', 'euro', 'EUR', 'cent', '€', 'French Guiana', 'GF', 'GUF', 'French Guiana', '019', '005', 0, '594', 'GF.png'),
	(258, 'Papeete', 'Polynesian', '258', 'CFP franc', 'XPF', 'centime', 'XPF', 'French Polynesia', 'PF', 'PYF', 'French Polynesia', '009', '061', 0, '689', 'PF.png'),
	(260, 'Port-aux-Francais', 'of French Southern and Antarctic Lands', '260', 'euro', 'EUR', 'cent', '€', 'French Southern and Antarctic Lands', 'TF', 'ATF', 'French Southern Territories', '', '', 0, '33', 'TF.png'),
	(262, 'Djibouti', 'Djiboutian', '262', 'Djibouti franc', 'DJF', '', 'DJF', 'Republic of Djibouti', 'DJ', 'DJI', 'Djibouti', '002', '014', 0, '253', 'DJ.png'),
	(266, 'Libreville', 'Gabonese', '266', 'CFA franc (BEAC)', 'XAF', 'centime', 'FCF', 'Gabonese Republic', 'GA', 'GAB', 'Gabon', '002', '017', 0, '241', 'GA.png'),
	(268, 'Tbilisi', 'Georgian', '268', 'lari', 'GEL', 'tetri (inv.)', 'GEL', 'Georgia', 'GE', 'GEO', 'Georgia', '142', '145', 0, '995', 'GE.png'),
	(270, 'Banjul', 'Gambian', '270', 'dalasi (inv.)', 'GMD', 'butut', 'D', 'Republic of the Gambia', 'GM', 'GMB', 'Gambia', '002', '011', 0, '220', 'GM.png'),
	(275, NULL, 'Palestinian', '275', NULL, NULL, NULL, '₪', NULL, 'PS', 'PSE', 'Palestinian Territory, Occupied', '142', '145', 0, '970', 'PS.png'),
	(276, 'Berlin', 'German', '276', 'euro', 'EUR', 'cent', '€', 'Federal Republic of Germany', 'DE', 'DEU', 'Germany', '150', '155', 1, '49', 'DE.png'),
	(288, 'Accra', 'Ghanaian', '288', 'Ghana cedi', 'GHS', 'pesewa', '¢', 'Republic of Ghana', 'GH', 'GHA', 'Ghana', '002', '011', 0, '233', 'GH.png'),
	(292, 'Gibraltar', 'Gibraltarian', '292', 'Gibraltar pound', 'GIP', 'penny', '£', 'Gibraltar', 'GI', 'GIB', 'Gibraltar', '150', '039', 0, '350', 'GI.png'),
	(296, 'Tarawa', 'Kiribatian', '296', 'Australian dollar', 'AUD', 'cent', '$', 'Republic of Kiribati', 'KI', 'KIR', 'Kiribati', '009', '057', 0, '686', 'KI.png'),
	(300, 'Athens', 'Greek', '300', 'euro', 'EUR', 'cent', '€', 'Hellenic Republic', 'GR', 'GRC', 'Greece', '150', '039', 1, '30', 'GR.png'),
	(304, 'Nuuk', 'Greenlander', '304', 'Danish krone', 'DKK', 'øre (inv.)', 'kr', 'Greenland', 'GL', 'GRL', 'Greenland', '019', '021', 0, '299', 'GL.png'),
	(308, 'St George’s', 'Grenadian', '308', 'East Caribbean dollar', 'XCD', 'cent', '$', 'Grenada', 'GD', 'GRD', 'Grenada', '019', '029', 0, '1', 'GD.png'),
	(312, 'Basse Terre', 'Guadeloupean', '312', 'euro', 'EUR', 'cent', '€', 'Guadeloupe', 'GP', 'GLP', 'Guadeloupe', '019', '029', 0, '590', 'GP.png'),
	(316, 'Agaña (Hagåtña)', 'Guamanian', '316', 'US dollar', 'USD', 'cent', '$', 'Territory of Guam', 'GU', 'GUM', 'Guam', '009', '057', 0, '1', 'GU.png'),
	(320, 'Guatemala City', 'Guatemalan', '320', 'quetzal (pl. quetzales)', 'GTQ', 'centavo', 'Q', 'Republic of Guatemala', 'GT', 'GTM', 'Guatemala', '019', '013', 0, '502', 'GT.png'),
	(324, 'Conakry', 'Guinean', '324', 'Guinean franc', 'GNF', '', 'GNF', 'Republic of Guinea', 'GN', 'GIN', 'Guinea', '002', '011', 0, '224', 'GN.png'),
	(328, 'Georgetown', 'Guyanese', '328', 'Guyana dollar', 'GYD', 'cent', '$', 'Cooperative Republic of Guyana', 'GY', 'GUY', 'Guyana', '019', '005', 0, '592', 'GY.png'),
	(332, 'Port-au-Prince', 'Haitian', '332', 'gourde', 'HTG', 'centime', 'G', 'Republic of Haiti', 'HT', 'HTI', 'Haiti', '019', '029', 0, '509', 'HT.png'),
	(334, 'Territory of Heard Island and McDonald Islands', 'of Territory of Heard Island and McDonald Islands', '334', '', '', '', '$', 'Territory of Heard Island and McDonald Islands', 'HM', 'HMD', 'Heard Island and McDonald Islands', '', '', 0, '61', 'HM.png'),
	(336, 'Vatican City', 'of the Holy See/of the Vatican', '336', 'euro', 'EUR', 'cent', '€', 'the Holy See/ Vatican City State', 'VA', 'VAT', 'Holy See (Vatican City State)', '150', '039', 0, '39', 'VA.png'),
	(340, 'Tegucigalpa', 'Honduran', '340', 'lempira', 'HNL', 'centavo', 'L', 'Republic of Honduras', 'HN', 'HND', 'Honduras', '019', '013', 0, '504', 'HN.png'),
	(344, '(HK3)', 'Hong Kong Chinese', '344', 'Hong Kong dollar', 'HKD', 'cent', '$', 'Hong Kong Special Administrative Region of the People’s Republic of China (HK2)', 'HK', 'HKG', 'Hong Kong', '142', '030', 0, '852', 'HK.png'),
	(348, 'Budapest', 'Hungarian', '348', 'forint (inv.)', 'HUF', '(fillér (inv.))', 'Ft', 'Republic of Hungary', 'HU', 'HUN', 'Hungary', '150', '151', 1, '36', 'HU.png'),
	(352, 'Reykjavik', 'Icelander', '352', 'króna (pl. krónur)', 'ISK', '', 'kr', 'Republic of Iceland', 'IS', 'ISL', 'Iceland', '150', '154', 0, '354', 'IS.png'),
	(356, 'New Delhi', 'Indian', '356', 'Indian rupee', 'INR', 'paisa', '₹', 'Republic of India', 'IN', 'IND', 'India', '142', '034', 0, '91', 'IN.png'),
	(360, 'Jakarta', 'Indonesian', '360', 'Indonesian rupiah (inv.)', 'IDR', 'sen (inv.)', 'Rp', 'Republic of Indonesia', 'ID', 'IDN', 'Indonesia', '142', '035', 0, '62', 'ID.png'),
	(364, 'Tehran', 'Iranian', '364', 'Iranian rial', 'IRR', '(dinar) (IR1)', '﷼', 'Islamic Republic of Iran', 'IR', 'IRN', 'Iran, Islamic Republic of', '142', '034', 0, '98', 'IR.png'),
	(368, 'Baghdad', 'Iraqi', '368', 'Iraqi dinar', 'IQD', 'fils (inv.)', 'IQD', 'Republic of Iraq', 'IQ', 'IRQ', 'Iraq', '142', '145', 0, '964', 'IQ.png'),
	(372, 'Dublin', 'Irish', '372', 'euro', 'EUR', 'cent', '€', 'Ireland (IE1)', 'IE', 'IRL', 'Ireland', '150', '154', 1, '353', 'IE.png'),
	(376, '(IL1)', 'Israeli', '376', 'shekel', 'ILS', 'agora', '₪', 'State of Israel', 'IL', 'ISR', 'Israel', '142', '145', 0, '972', 'IL.png'),
	(380, 'Rome', 'Italian', '380', 'euro', 'EUR', 'cent', '€', 'Italian Republic', 'IT', 'ITA', 'Italy', '150', '039', 1, '39', 'IT.png'),
	(384, 'Yamoussoukro (CI1)', 'Ivorian', '384', 'CFA franc (BCEAO)', 'XOF', 'centime', 'XOF', 'Republic of Côte d’Ivoire', 'CI', 'CIV', 'Côte d\'Ivoire', '002', '011', 0, '225', 'CI.png'),
	(388, 'Kingston', 'Jamaican', '388', 'Jamaica dollar', 'JMD', 'cent', '$', 'Jamaica', 'JM', 'JAM', 'Jamaica', '019', '029', 0, '1', 'JM.png'),
	(392, 'Tokyo', 'Japanese', '392', 'yen (inv.)', 'JPY', '(sen (inv.)) (JP1)', '¥', 'Japan', 'JP', 'JPN', 'Japan', '142', '030', 0, '81', 'JP.png'),
	(398, 'Astana', 'Kazakh', '398', 'tenge (inv.)', 'KZT', 'tiyn', 'лв', 'Republic of Kazakhstan', 'KZ', 'KAZ', 'Kazakhstan', '142', '143', 0, '7', 'KZ.png'),
	(400, 'Amman', 'Jordanian', '400', 'Jordanian dinar', 'JOD', '100 qirsh', 'JOD', 'Hashemite Kingdom of Jordan', 'JO', 'JOR', 'Jordan', '142', '145', 0, '962', 'JO.png'),
	(404, 'Nairobi', 'Kenyan', '404', 'Kenyan shilling', 'KES', 'cent', 'KES', 'Republic of Kenya', 'KE', 'KEN', 'Kenya', '002', '014', 0, '254', 'KE.png'),
	(408, 'Pyongyang', 'North Korean', '408', 'North Korean won (inv.)', 'KPW', 'chun (inv.)', '₩', 'Democratic People’s Republic of Korea', 'KP', 'PRK', 'Korea, Democratic People\'s Republic of', '142', '030', 0, '850', 'KP.png'),
	(410, 'Seoul', 'South Korean', '410', 'South Korean won (inv.)', 'KRW', '(chun (inv.))', '₩', 'Republic of Korea', 'KR', 'KOR', 'Korea, Republic of', '142', '030', 0, '82', 'KR.png'),
	(414, 'Kuwait City', 'Kuwaiti', '414', 'Kuwaiti dinar', 'KWD', 'fils (inv.)', 'KWD', 'State of Kuwait', 'KW', 'KWT', 'Kuwait', '142', '145', 0, '965', 'KW.png'),
	(417, 'Bishkek', 'Kyrgyz', '417', 'som', 'KGS', 'tyiyn', 'лв', 'Kyrgyz Republic', 'KG', 'KGZ', 'Kyrgyzstan', '142', '143', 0, '996', 'KG.png'),
	(418, 'Vientiane', 'Lao', '418', 'kip (inv.)', 'LAK', '(at (inv.))', '₭', 'Lao People’s Democratic Republic', 'LA', 'LAO', 'Lao People\'s Democratic Republic', '142', '035', 0, '856', 'LA.png'),
	(422, 'Beirut', 'Lebanese', '422', 'Lebanese pound', 'LBP', '(piastre)', '£', 'Lebanese Republic', 'LB', 'LBN', 'Lebanon', '142', '145', 0, '961', 'LB.png'),
	(426, 'Maseru', 'Basotho', '426', 'loti (pl. maloti)', 'LSL', 'sente', 'L', 'Kingdom of Lesotho', 'LS', 'LSO', 'Lesotho', '002', '018', 0, '266', 'LS.png'),
	(428, 'Riga', 'Latvian', '428', 'euro', 'EUR', 'cent', 'Ls', 'Republic of Latvia', 'LV', 'LVA', 'Latvia', '150', '154', 1, '371', 'LV.png'),
	(430, 'Monrovia', 'Liberian', '430', 'Liberian dollar', 'LRD', 'cent', '$', 'Republic of Liberia', 'LR', 'LBR', 'Liberia', '002', '011', 0, '231', 'LR.png'),
	(434, 'Tripoli', 'Libyan', '434', 'Libyan dinar', 'LYD', 'dirham', 'LYD', 'Socialist People’s Libyan Arab Jamahiriya', 'LY', 'LBY', 'Libya', '002', '015', 0, '218', 'LY.png'),
	(438, 'Vaduz', 'Liechtensteiner', '438', 'Swiss franc', 'CHF', 'centime', 'CHF', 'Principality of Liechtenstein', 'LI', 'LIE', 'Liechtenstein', '150', '155', 0, '423', 'LI.png'),
	(440, 'Vilnius', 'Lithuanian', '440', 'euro', 'EUR', 'cent', 'Lt', 'Republic of Lithuania', 'LT', 'LTU', 'Lithuania', '150', '154', 1, '370', 'LT.png'),
	(442, 'Luxembourg', 'Luxembourger', '442', 'euro', 'EUR', 'cent', '€', 'Grand Duchy of Luxembourg', 'LU', 'LUX', 'Luxembourg', '150', '155', 1, '352', 'LU.png'),
	(446, 'Macao (MO3)', 'Macanese', '446', 'pataca', 'MOP', 'avo', 'MOP', 'Macao Special Administrative Region of the People’s Republic of China (MO2)', 'MO', 'MAC', 'Macao', '142', '030', 0, '853', 'MO.png'),
	(450, 'Antananarivo', 'Malagasy', '450', 'ariary', 'MGA', 'iraimbilanja (inv.)', 'MGA', 'Republic of Madagascar', 'MG', 'MDG', 'Madagascar', '002', '014', 0, '261', 'MG.png'),
	(454, 'Lilongwe', 'Malawian', '454', 'Malawian kwacha (inv.)', 'MWK', 'tambala (inv.)', 'MK', 'Republic of Malawi', 'MW', 'MWI', 'Malawi', '002', '014', 0, '265', 'MW.png'),
	(458, 'Kuala Lumpur (MY1)', 'Malaysian', '458', 'ringgit (inv.)', 'MYR', 'sen (inv.)', 'RM', 'Malaysia', 'MY', 'MYS', 'Malaysia', '142', '035', 0, '60', 'MY.png'),
	(462, 'Malé', 'Maldivian', '462', 'rufiyaa', 'MVR', 'laari (inv.)', 'Rf', 'Republic of Maldives', 'MV', 'MDV', 'Maldives', '142', '034', 0, '960', 'MV.png'),
	(466, 'Bamako', 'Malian', '466', 'CFA franc (BCEAO)', 'XOF', 'centime', 'XOF', 'Republic of Mali', 'ML', 'MLI', 'Mali', '002', '011', 0, '223', 'ML.png'),
	(470, 'Valletta', 'Maltese', '470', 'euro', 'EUR', 'cent', 'MTL', 'Republic of Malta', 'MT', 'MLT', 'Malta', '150', '039', 1, '356', 'MT.png'),
	(474, 'Fort-de-France', 'Martinican', '474', 'euro', 'EUR', 'cent', '€', 'Martinique', 'MQ', 'MTQ', 'Martinique', '019', '029', 0, '596', 'MQ.png'),
	(478, 'Nouakchott', 'Mauritanian', '478', 'ouguiya', 'MRO', 'khoum', 'UM', 'Islamic Republic of Mauritania', 'MR', 'MRT', 'Mauritania', '002', '011', 0, '222', 'MR.png'),
	(480, 'Port Louis', 'Mauritian', '480', 'Mauritian rupee', 'MUR', 'cent', '₨', 'Republic of Mauritius', 'MU', 'MUS', 'Mauritius', '002', '014', 0, '230', 'MU.png'),
	(484, 'Mexico City', 'Mexican', '484', 'Mexican peso', 'MXN', 'centavo', '$', 'United Mexican States', 'MX', 'MEX', 'Mexico', '019', '013', 0, '52', 'MX.png'),
	(492, 'Monaco', 'Monegasque', '492', 'euro', 'EUR', 'cent', '€', 'Principality of Monaco', 'MC', 'MCO', 'Monaco', '150', '155', 0, '377', 'MC.png'),
	(496, 'Ulan Bator', 'Mongolian', '496', 'tugrik', 'MNT', 'möngö (inv.)', '₮', 'Mongolia', 'MN', 'MNG', 'Mongolia', '142', '030', 0, '976', 'MN.png'),
	(498, 'Chisinau', 'Moldovan', '498', 'Moldovan leu (pl. lei)', 'MDL', 'ban', 'MDL', 'Republic of Moldova', 'MD', 'MDA', 'Moldova, Republic of', '150', '151', 0, '373', 'MD.png'),
	(499, 'Podgorica', 'Montenegrin', '499', 'euro', 'EUR', 'cent', '€', 'Montenegro', 'ME', 'MNE', 'Montenegro', '150', '039', 0, '382', 'ME.png'),
	(500, 'Plymouth (MS2)', 'Montserratian', '500', 'East Caribbean dollar', 'XCD', 'cent', '$', 'Montserrat', 'MS', 'MSR', 'Montserrat', '019', '029', 0, '1', 'MS.png'),
	(504, 'Rabat', 'Moroccan', '504', 'Moroccan dirham', 'MAD', 'centime', 'MAD', 'Kingdom of Morocco', 'MA', 'MAR', 'Morocco', '002', '015', 0, '212', 'MA.png'),
	(508, 'Maputo', 'Mozambican', '508', 'metical', 'MZN', 'centavo', 'MT', 'Republic of Mozambique', 'MZ', 'MOZ', 'Mozambique', '002', '014', 0, '258', 'MZ.png'),
	(512, 'Muscat', 'Omani', '512', 'Omani rial', 'OMR', 'baiza', '﷼', 'Sultanate of Oman', 'OM', 'OMN', 'Oman', '142', '145', 0, '968', 'OM.png'),
	(516, 'Windhoek', 'Namibian', '516', 'Namibian dollar', 'NAD', 'cent', '$', 'Republic of Namibia', 'NA', 'NAM', 'Namibia', '002', '018', 0, '264', 'NA.png'),
	(520, 'Yaren', 'Nauruan', '520', 'Australian dollar', 'AUD', 'cent', '$', 'Republic of Nauru', 'NR', 'NRU', 'Nauru', '009', '057', 0, '674', 'NR.png'),
	(524, 'Kathmandu', 'Nepalese', '524', 'Nepalese rupee', 'NPR', 'paisa (inv.)', '₨', 'Nepal', 'NP', 'NPL', 'Nepal', '142', '034', 0, '977', 'NP.png'),
	(528, 'Amsterdam (NL2)', 'Dutch', '528', 'euro', 'EUR', 'cent', '€', 'Kingdom of the Netherlands', 'NL', 'NLD', 'Netherlands', '150', '155', 1, '31', 'NL.png'),
	(531, 'Willemstad', 'Curaçaoan', '531', 'Netherlands Antillean guilder (CW1)', 'ANG', 'cent', NULL, 'Curaçao', 'CW', 'CUW', 'Curaçao', '019', '029', 0, '599', NULL),
	(533, 'Oranjestad', 'Aruban', '533', 'Aruban guilder', 'AWG', 'cent', 'ƒ', 'Aruba', 'AW', 'ABW', 'Aruba', '019', '029', 0, '297', 'AW.png'),
	(534, 'Philipsburg', 'Sint Maartener', '534', 'Netherlands Antillean guilder (SX1)', 'ANG', 'cent', NULL, 'Sint Maarten', 'SX', 'SXM', 'Sint Maarten (Dutch part)', '019', '029', 0, '721', NULL),
	(535, NULL, 'of Bonaire, Sint Eustatius and Saba', '535', 'US dollar', 'USD', 'cent', NULL, NULL, 'BQ', 'BES', 'Bonaire, Sint Eustatius and Saba', '019', '029', 0, '599', NULL),
	(540, 'Nouméa', 'New Caledonian', '540', 'CFP franc', 'XPF', 'centime', 'XPF', 'New Caledonia', 'NC', 'NCL', 'New Caledonia', '009', '054', 0, '687', 'NC.png'),
	(548, 'Port Vila', 'Vanuatuan', '548', 'vatu (inv.)', 'VUV', '', 'Vt', 'Republic of Vanuatu', 'VU', 'VUT', 'Vanuatu', '009', '054', 0, '678', 'VU.png'),
	(554, 'Wellington', 'New Zealander', '554', 'New Zealand dollar', 'NZD', 'cent', '$', 'New Zealand', 'NZ', 'NZL', 'New Zealand', '009', '053', 0, '64', 'NZ.png'),
	(558, 'Managua', 'Nicaraguan', '558', 'córdoba oro', 'NIO', 'centavo', 'C$', 'Republic of Nicaragua', 'NI', 'NIC', 'Nicaragua', '019', '013', 0, '505', 'NI.png'),
	(562, 'Niamey', 'Nigerien', '562', 'CFA franc (BCEAO)', 'XOF', 'centime', 'XOF', 'Republic of Niger', 'NE', 'NER', 'Niger', '002', '011', 0, '227', 'NE.png'),
	(566, 'Abuja', 'Nigerian', '566', 'naira (inv.)', 'NGN', 'kobo (inv.)', '₦', 'Federal Republic of Nigeria', 'NG', 'NGA', 'Nigeria', '002', '011', 0, '234', 'NG.png'),
	(570, 'Alofi', 'Niuean', '570', 'New Zealand dollar', 'NZD', 'cent', '$', 'Niue', 'NU', 'NIU', 'Niue', '009', '061', 0, '683', 'NU.png'),
	(574, 'Kingston', 'Norfolk Islander', '574', 'Australian dollar', 'AUD', 'cent', '$', 'Territory of Norfolk Island', 'NF', 'NFK', 'Norfolk Island', '009', '053', 0, '672', 'NF.png'),
	(578, 'Oslo', 'Norwegian', '578', 'Norwegian krone (pl. kroner)', 'NOK', 'øre (inv.)', 'kr', 'Kingdom of Norway', 'NO', 'NOR', 'Norway', '150', '154', 0, '47', 'NO.png'),
	(580, 'Saipan', 'Northern Mariana Islander', '580', 'US dollar', 'USD', 'cent', '$', 'Commonwealth of the Northern Mariana Islands', 'MP', 'MNP', 'Northern Mariana Islands', '009', '057', 0, '1', 'MP.png'),
	(581, 'United States Minor Outlying Islands', 'of United States Minor Outlying Islands', '581', 'US dollar', 'USD', 'cent', '$', 'United States Minor Outlying Islands', 'UM', 'UMI', 'United States Minor Outlying Islands', '', '', 0, '1', 'UM.png'),
	(583, 'Palikir', 'Micronesian', '583', 'US dollar', 'USD', 'cent', '$', 'Federated States of Micronesia', 'FM', 'FSM', 'Micronesia, Federated States of', '009', '057', 0, '691', 'FM.png'),
	(584, 'Majuro', 'Marshallese', '584', 'US dollar', 'USD', 'cent', '$', 'Republic of the Marshall Islands', 'MH', 'MHL', 'Marshall Islands', '009', '057', 0, '692', 'MH.png'),
	(585, 'Melekeok', 'Palauan', '585', 'US dollar', 'USD', 'cent', '$', 'Republic of Palau', 'PW', 'PLW', 'Palau', '009', '057', 0, '680', 'PW.png'),
	(586, 'Islamabad', 'Pakistani', '586', 'Pakistani rupee', 'PKR', 'paisa', '₨', 'Islamic Republic of Pakistan', 'PK', 'PAK', 'Pakistan', '142', '034', 0, '92', 'PK.png'),
	(591, 'Panama City', 'Panamanian', '591', 'balboa', 'PAB', 'centésimo', 'B/.', 'Republic of Panama', 'PA', 'PAN', 'Panama', '019', '013', 0, '507', 'PA.png'),
	(598, 'Port Moresby', 'Papua New Guinean', '598', 'kina (inv.)', 'PGK', 'toea (inv.)', 'PGK', 'Independent State of Papua New Guinea', 'PG', 'PNG', 'Papua New Guinea', '009', '054', 0, '675', 'PG.png'),
	(600, 'Asunción', 'Paraguayan', '600', 'guaraní', 'PYG', 'céntimo', 'Gs', 'Republic of Paraguay', 'PY', 'PRY', 'Paraguay', '019', '005', 0, '595', 'PY.png'),
	(604, 'Lima', 'Peruvian', '604', 'new sol', 'PEN', 'céntimo', 'S/.', 'Republic of Peru', 'PE', 'PER', 'Peru', '019', '005', 0, '51', 'PE.png'),
	(608, 'Manila', 'Filipino', '608', 'Philippine peso', 'PHP', 'centavo', 'Php', 'Republic of the Philippines', 'PH', 'PHL', 'Philippines', '142', '035', 0, '63', 'PH.png'),
	(612, 'Adamstown', 'Pitcairner', '612', 'New Zealand dollar', 'NZD', 'cent', '$', 'Pitcairn Islands', 'PN', 'PCN', 'Pitcairn', '009', '061', 0, '649', 'PN.png'),
	(616, 'Warsaw', 'Polish', '616', 'zloty', 'PLN', 'grosz (pl. groszy)', 'zł', 'Republic of Poland', 'PL', 'POL', 'Poland', '150', '151', 1, '48', 'PL.png'),
	(620, 'Lisbon', 'Portuguese', '620', 'euro', 'EUR', 'cent', '€', 'Portuguese Republic', 'PT', 'PRT', 'Portugal', '150', '039', 1, '351', 'PT.png'),
	(624, 'Bissau', 'Guinea-Bissau national', '624', 'CFA franc (BCEAO)', 'XOF', 'centime', 'XOF', 'Republic of Guinea-Bissau', 'GW', 'GNB', 'Guinea-Bissau', '002', '011', 0, '245', 'GW.png'),
	(626, 'Dili', 'East Timorese', '626', 'US dollar', 'USD', 'cent', '$', 'Democratic Republic of East Timor', 'TL', 'TLS', 'Timor-Leste', '142', '035', 0, '670', 'TL.png'),
	(630, 'San Juan', 'Puerto Rican', '630', 'US dollar', 'USD', 'cent', '$', 'Commonwealth of Puerto Rico', 'PR', 'PRI', 'Puerto Rico', '019', '029', 0, '1', 'PR.png'),
	(634, 'Doha', 'Qatari', '634', 'Qatari riyal', 'QAR', 'dirham', '﷼', 'State of Qatar', 'QA', 'QAT', 'Qatar', '142', '145', 0, '974', 'QA.png'),
	(638, 'Saint-Denis', 'Reunionese', '638', 'euro', 'EUR', 'cent', '€', 'Réunion', 'RE', 'REU', 'Réunion', '002', '014', 0, '262', 'RE.png'),
	(642, 'Bucharest', 'Romanian', '642', 'Romanian leu (pl. lei)', 'RON', 'ban (pl. bani)', 'lei', 'Romania', 'RO', 'ROU', 'Romania', '150', '151', 1, '40', 'RO.png'),
	(643, 'Moscow', 'Russian', '643', 'Russian rouble', 'RUB', 'kopek', 'руб', 'Russian Federation', 'RU', 'RUS', 'Russian Federation', '150', '151', 0, '7', 'RU.png'),
	(646, 'Kigali', 'Rwandan; Rwandese', '646', 'Rwandese franc', 'RWF', 'centime', 'RWF', 'Republic of Rwanda', 'RW', 'RWA', 'Rwanda', '002', '014', 0, '250', 'RW.png'),
	(652, 'Gustavia', 'of Saint Barthélemy', '652', 'euro', 'EUR', 'cent', NULL, 'Collectivity of Saint Barthélemy', 'BL', 'BLM', 'Saint Barthélemy', '019', '029', 0, '590', NULL),
	(654, 'Jamestown', 'Saint Helenian', '654', 'Saint Helena pound', 'SHP', 'penny', '£', 'Saint Helena, Ascension and Tristan da Cunha', 'SH', 'SHN', 'Saint Helena, Ascension and Tristan da Cunha', '002', '011', 0, '290', 'SH.png'),
	(659, 'Basseterre', 'Kittsian; Nevisian', '659', 'East Caribbean dollar', 'XCD', 'cent', '$', 'Federation of Saint Kitts and Nevis', 'KN', 'KNA', 'Saint Kitts and Nevis', '019', '029', 0, '1', 'KN.png'),
	(660, 'The Valley', 'Anguillan', '660', 'East Caribbean dollar', 'XCD', 'cent', '$', 'Anguilla', 'AI', 'AIA', 'Anguilla', '019', '029', 0, '1', 'AI.png'),
	(662, 'Castries', 'Saint Lucian', '662', 'East Caribbean dollar', 'XCD', 'cent', '$', 'Saint Lucia', 'LC', 'LCA', 'Saint Lucia', '019', '029', 0, '1', 'LC.png'),
	(663, 'Marigot', 'of Saint Martin', '663', 'euro', 'EUR', 'cent', NULL, 'Collectivity of Saint Martin', 'MF', 'MAF', 'Saint Martin (French part)', '019', '029', 0, '590', NULL),
	(666, 'Saint-Pierre', 'St-Pierrais; Miquelonnais', '666', 'euro', 'EUR', 'cent', '€', 'Territorial Collectivity of Saint Pierre and Miquelon', 'PM', 'SPM', 'Saint Pierre and Miquelon', '019', '021', 0, '508', 'PM.png'),
	(670, 'Kingstown', 'Vincentian', '670', 'East Caribbean dollar', 'XCD', 'cent', '$', 'Saint Vincent and the Grenadines', 'VC', 'VCT', 'Saint Vincent and the Grenadines', '019', '029', 0, '1', 'VC.png'),
	(674, 'San Marino', 'San Marinese', '674', 'euro', 'EUR', 'cent', '€', 'Republic of San Marino', 'SM', 'SMR', 'San Marino', '150', '039', 0, '378', 'SM.png'),
	(678, 'São Tomé', 'São Toméan', '678', 'dobra', 'STD', 'centavo', 'Db', 'Democratic Republic of São Tomé and Príncipe', 'ST', 'STP', 'Sao Tome and Principe', '002', '017', 0, '239', 'ST.png'),
	(682, 'Riyadh', 'Saudi Arabian', '682', 'riyal', 'SAR', 'halala', '﷼', 'Kingdom of Saudi Arabia', 'SA', 'SAU', 'Saudi Arabia', '142', '145', 0, '966', 'SA.png'),
	(686, 'Dakar', 'Senegalese', '686', 'CFA franc (BCEAO)', 'XOF', 'centime', 'XOF', 'Republic of Senegal', 'SN', 'SEN', 'Senegal', '002', '011', 0, '221', 'SN.png'),
	(688, 'Belgrade', 'Serb', '688', 'Serbian dinar', 'RSD', 'para (inv.)', NULL, 'Republic of Serbia', 'RS', 'SRB', 'Serbia', '150', '039', 0, '381', NULL),
	(690, 'Victoria', 'Seychellois', '690', 'Seychelles rupee', 'SCR', 'cent', '₨', 'Republic of Seychelles', 'SC', 'SYC', 'Seychelles', '002', '014', 0, '248', 'SC.png'),
	(694, 'Freetown', 'Sierra Leonean', '694', 'leone', 'SLL', 'cent', 'Le', 'Republic of Sierra Leone', 'SL', 'SLE', 'Sierra Leone', '002', '011', 0, '232', 'SL.png'),
	(702, 'Singapore', 'Singaporean', '702', 'Singapore dollar', 'SGD', 'cent', '$', 'Republic of Singapore', 'SG', 'SGP', 'Singapore', '142', '035', 0, '65', 'SG.png'),
	(703, 'Bratislava', 'Slovak', '703', 'euro', 'EUR', 'cent', 'Sk', 'Slovak Republic', 'SK', 'SVK', 'Slovakia', '150', '151', 1, '421', 'SK.png'),
	(704, 'Hanoi', 'Vietnamese', '704', 'dong', 'VND', '(10 hào', '₫', 'Socialist Republic of Vietnam', 'VN', 'VNM', 'Viet Nam', '142', '035', 0, '84', 'VN.png'),
	(705, 'Ljubljana', 'Slovene', '705', 'euro', 'EUR', 'cent', '€', 'Republic of Slovenia', 'SI', 'SVN', 'Slovenia', '150', '039', 1, '386', 'SI.png'),
	(706, 'Mogadishu', 'Somali', '706', 'Somali shilling', 'SOS', 'cent', 'S', 'Somali Republic', 'SO', 'SOM', 'Somalia', '002', '014', 0, '252', 'SO.png'),
	(710, 'Pretoria (ZA1)', 'South African', '710', 'rand', 'ZAR', 'cent', 'R', 'Republic of South Africa', 'ZA', 'ZAF', 'South Africa', '002', '018', 0, '27', 'ZA.png'),
	(716, 'Harare', 'Zimbabwean', '716', 'Zimbabwe dollar (ZW1)', 'ZWL', 'cent', 'Z$', 'Republic of Zimbabwe', 'ZW', 'ZWE', 'Zimbabwe', '002', '014', 0, '263', 'ZW.png'),
	(724, 'Madrid', 'Spaniard', '724', 'euro', 'EUR', 'cent', '€', 'Kingdom of Spain', 'ES', 'ESP', 'Spain', '150', '039', 1, '34', 'ES.png'),
	(728, 'Juba', 'South Sudanese', '728', 'South Sudanese pound', 'SSP', 'piaster', NULL, 'Republic of South Sudan', 'SS', 'SSD', 'South Sudan', '002', '015', 0, '211', NULL),
	(729, 'Khartoum', 'Sudanese', '729', 'Sudanese pound', 'SDG', 'piastre', NULL, 'Republic of the Sudan', 'SD', 'SDN', 'Sudan', '002', '015', 0, '249', NULL),
	(732, 'Al aaiun', 'Sahrawi', '732', 'Moroccan dirham', 'MAD', 'centime', 'MAD', 'Western Sahara', 'EH', 'ESH', 'Western Sahara', '002', '015', 0, '212', 'EH.png'),
	(740, 'Paramaribo', 'Surinamese', '740', 'Surinamese dollar', 'SRD', 'cent', '$', 'Republic of Suriname', 'SR', 'SUR', 'Suriname', '019', '005', 0, '597', 'SR.png'),
	(744, 'Longyearbyen', 'of Svalbard', '744', 'Norwegian krone (pl. kroner)', 'NOK', 'øre (inv.)', 'kr', 'Svalbard and Jan Mayen', 'SJ', 'SJM', 'Svalbard and Jan Mayen', '150', '154', 0, '47', 'SJ.png'),
	(748, 'Mbabane', 'Swazi', '748', 'lilangeni', 'SZL', 'cent', 'SZL', 'Kingdom of Swaziland', 'SZ', 'SWZ', 'Swaziland', '002', '018', 0, '268', 'SZ.png'),
	(752, 'Stockholm', 'Swedish', '752', 'krona (pl. kronor)', 'SEK', 'öre (inv.)', 'kr', 'Kingdom of Sweden', 'SE', 'SWE', 'Sweden', '150', '154', 1, '46', 'SE.png'),
	(756, 'Berne', 'Swiss', '756', 'Swiss franc', 'CHF', 'centime', 'CHF', 'Swiss Confederation', 'CH', 'CHE', 'Switzerland', '150', '155', 0, '41', 'CH.png'),
	(760, 'Damascus', 'Syrian', '760', 'Syrian pound', 'SYP', 'piastre', '£', 'Syrian Arab Republic', 'SY', 'SYR', 'Syrian Arab Republic', '142', '145', 0, '963', 'SY.png'),
	(762, 'Dushanbe', 'Tajik', '762', 'somoni', 'TJS', 'diram', 'TJS', 'Republic of Tajikistan', 'TJ', 'TJK', 'Tajikistan', '142', '143', 0, '992', 'TJ.png'),
	(764, 'Bangkok', 'Thai', '764', 'baht (inv.)', 'THB', 'satang (inv.)', '฿', 'Kingdom of Thailand', 'TH', 'THA', 'Thailand', '142', '035', 0, '66', 'TH.png'),
	(768, 'Lomé', 'Togolese', '768', 'CFA franc (BCEAO)', 'XOF', 'centime', 'XOF', 'Togolese Republic', 'TG', 'TGO', 'Togo', '002', '011', 0, '228', 'TG.png'),
	(772, '(TK2)', 'Tokelauan', '772', 'New Zealand dollar', 'NZD', 'cent', '$', 'Tokelau', 'TK', 'TKL', 'Tokelau', '009', '061', 0, '690', 'TK.png'),
	(776, 'Nuku’alofa', 'Tongan', '776', 'pa’anga (inv.)', 'TOP', 'seniti (inv.)', 'T$', 'Kingdom of Tonga', 'TO', 'TON', 'Tonga', '009', '061', 0, '676', 'TO.png'),
	(780, 'Port of Spain', 'Trinidadian; Tobagonian', '780', 'Trinidad and Tobago dollar', 'TTD', 'cent', 'TT$', 'Republic of Trinidad and Tobago', 'TT', 'TTO', 'Trinidad and Tobago', '019', '029', 0, '1', 'TT.png'),
	(784, 'Abu Dhabi', 'Emirian', '784', 'UAE dirham', 'AED', 'fils (inv.)', 'AED', 'United Arab Emirates', 'AE', 'ARE', 'United Arab Emirates', '142', '145', 0, '971', 'AE.png'),
	(788, 'Tunis', 'Tunisian', '788', 'Tunisian dinar', 'TND', 'millime', 'TND', 'Republic of Tunisia', 'TN', 'TUN', 'Tunisia', '002', '015', 0, '216', 'TN.png'),
	(792, 'Ankara', 'Turk', '792', 'Turkish lira (inv.)', 'TRY', 'kurus (inv.)', '₺', 'Republic of Turkey', 'TR', 'TUR', 'Turkey', '142', '145', 0, '90', 'TR.png'),
	(795, 'Ashgabat', 'Turkmen', '795', 'Turkmen manat (inv.)', 'TMT', 'tenge (inv.)', 'm', 'Turkmenistan', 'TM', 'TKM', 'Turkmenistan', '142', '143', 0, '993', 'TM.png'),
	(796, 'Cockburn Town', 'Turks and Caicos Islander', '796', 'US dollar', 'USD', 'cent', '$', 'Turks and Caicos Islands', 'TC', 'TCA', 'Turks and Caicos Islands', '019', '029', 0, '1', 'TC.png'),
	(798, 'Funafuti', 'Tuvaluan', '798', 'Australian dollar', 'AUD', 'cent', '$', 'Tuvalu', 'TV', 'TUV', 'Tuvalu', '009', '061', 0, '688', 'TV.png'),
	(800, 'Kampala', 'Ugandan', '800', 'Uganda shilling', 'UGX', 'cent', 'UGX', 'Republic of Uganda', 'UG', 'UGA', 'Uganda', '002', '014', 0, '256', 'UG.png'),
	(804, 'Kiev', 'Ukrainian', '804', 'hryvnia', 'UAH', 'kopiyka', '₴', 'Ukraine', 'UA', 'UKR', 'Ukraine', '150', '151', 0, '380', 'UA.png'),
	(807, 'Skopje', 'of the former Yugoslav Republic of Macedonia', '807', 'denar (pl. denars)', 'MKD', 'deni (inv.)', 'ден', 'the former Yugoslav Republic of Macedonia', 'MK', 'MKD', 'Macedonia, the former Yugoslav Republic of', '150', '039', 0, '389', 'MK.png'),
	(818, 'Cairo', 'Egyptian', '818', 'Egyptian pound', 'EGP', 'piastre', '£', 'Arab Republic of Egypt', 'EG', 'EGY', 'Egypt', '002', '015', 0, '20', 'EG.png'),
	(826, 'London', 'British', '826', 'pound sterling', 'GBP', 'penny (pl. pence)', '£', 'United Kingdom of Great Britain and Northern Ireland', 'GB', 'GBR', 'United Kingdom', '150', '154', 1, '44', 'GB.png'),
	(831, 'St Peter Port', 'of Guernsey', '831', 'Guernsey pound (GG2)', 'GGP (GG2)', 'penny (pl. pence)', NULL, 'Bailiwick of Guernsey', 'GG', 'GGY', 'Guernsey', '150', '154', 0, '44', NULL),
	(832, 'St Helier', 'of Jersey', '832', 'Jersey pound (JE2)', 'JEP (JE2)', 'penny (pl. pence)', NULL, 'Bailiwick of Jersey', 'JE', 'JEY', 'Jersey', '150', '154', 0, '44', NULL),
	(833, 'Douglas', 'Manxman; Manxwoman', '833', 'Manx pound (IM2)', 'IMP (IM2)', 'penny (pl. pence)', NULL, 'Isle of Man', 'IM', 'IMN', 'Isle of Man', '150', '154', 0, '44', NULL),
	(834, 'Dodoma (TZ1)', 'Tanzanian', '834', 'Tanzanian shilling', 'TZS', 'cent', 'TZS', 'United Republic of Tanzania', 'TZ', 'TZA', 'Tanzania, United Republic of', '002', '014', 0, '255', 'TZ.png'),
	(840, 'Washington DC', 'American', '840', 'US dollar', 'USD', 'cent', '$', 'United States of America', 'US', 'USA', 'United States', '019', '021', 0, '1', 'US.png'),
	(850, 'Charlotte Amalie', 'US Virgin Islander', '850', 'US dollar', 'USD', 'cent', '$', 'United States Virgin Islands', 'VI', 'VIR', 'Virgin Islands, U.S.', '019', '029', 0, '1', 'VI.png'),
	(854, 'Ouagadougou', 'Burkinabe', '854', 'CFA franc (BCEAO)', 'XOF', 'centime', 'XOF', 'Burkina Faso', 'BF', 'BFA', 'Burkina Faso', '002', '011', 0, '226', 'BF.png'),
	(858, 'Montevideo', 'Uruguayan', '858', 'Uruguayan peso', 'UYU', 'centésimo', '$U', 'Eastern Republic of Uruguay', 'UY', 'URY', 'Uruguay', '019', '005', 0, '598', 'UY.png'),
	(860, 'Tashkent', 'Uzbek', '860', 'sum (inv.)', 'UZS', 'tiyin (inv.)', 'лв', 'Republic of Uzbekistan', 'UZ', 'UZB', 'Uzbekistan', '142', '143', 0, '998', 'UZ.png'),
	(862, 'Caracas', 'Venezuelan', '862', 'bolívar fuerte (pl. bolívares fuertes)', 'VEF', 'céntimo', 'Bs', 'Bolivarian Republic of Venezuela', 'VE', 'VEN', 'Venezuela, Bolivarian Republic of', '019', '005', 0, '58', 'VE.png'),
	(876, 'Mata-Utu', 'Wallisian; Futunan; Wallis and Futuna Islander', '876', 'CFP franc', 'XPF', 'centime', 'XPF', 'Wallis and Futuna', 'WF', 'WLF', 'Wallis and Futuna', '009', '061', 0, '681', 'WF.png'),
	(882, 'Apia', 'Samoan', '882', 'tala (inv.)', 'WST', 'sene (inv.)', 'WS$', 'Independent State of Samoa', 'WS', 'WSM', 'Samoa', '009', '061', 0, '685', 'WS.png'),
	(887, 'San’a', 'Yemenite', '887', 'Yemeni rial', 'YER', 'fils (inv.)', '﷼', 'Republic of Yemen', 'YE', 'YEM', 'Yemen', '142', '145', 0, '967', 'YE.png'),
	(894, 'Lusaka', 'Zambian', '894', 'Zambian kwacha (inv.)', 'ZMW', 'ngwee (inv.)', 'ZK', 'Republic of Zambia', 'ZM', 'ZMB', 'Zambia', '002', '014', 0, '260', 'ZM.png');

-- Dump della struttura di tabella trfcmcauthorized.auth_migrations
CREATE TABLE IF NOT EXISTS `auth_migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella trfcmcauthorized.auth_migrations: ~11 rows (circa)
INSERT INTO `auth_migrations` (`id`, `migration`, `batch`) VALUES
	(1, '2014_10_12_100000_create_password_resets_table', 1),
	(2, '2015_09_19_191655_setup_countries_table', 1),
	(3, '2015_10_10_170827_create_users_table', 1),
	(4, '2015_10_10_171049_create_social_login_table', 1),
	(5, '2015_12_24_080704_setup_authorization_tables', 1),
	(6, '2015_12_24_152327_create_sessions_table', 1),
	(7, '2015_12_29_224252_create_user_activity_table', 1),
	(8, '2015_12_30_171734_add_foreign_keys', 1),
	(9, '2017_08_24_000000_create_settings_table', 1),
	(10, '2019_08_22_140712_create_announcements_table', 1),
	(11, '2019_12_14_000001_create_personal_access_tokens_table', 1);

-- Dump della struttura di tabella trfcmcauthorized.auth_password_resets
CREATE TABLE IF NOT EXISTS `auth_password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `auth_password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella trfcmcauthorized.auth_password_resets: ~0 rows (circa)

-- Dump della struttura di tabella trfcmcauthorized.auth_permissions
CREATE TABLE IF NOT EXISTS `auth_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `removable` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permissions_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella trfcmcauthorized.auth_permissions: ~8 rows (circa)
INSERT INTO `auth_permissions` (`id`, `name`, `display_name`, `description`, `removable`, `created_at`, `updated_at`) VALUES
	(1, 'users.manage', 'Manage Users', 'Manage users and their sessions.', 0, '2022-03-12 08:25:51', '2022-03-12 08:25:51'),
	(2, 'users.activity', 'View System Activity Log', 'View activity log for all system users.', 0, '2022-03-12 08:25:51', '2022-03-12 08:25:51'),
	(3, 'roles.manage', 'Manage Roles', 'Manage system roles.', 0, '2022-03-12 08:25:51', '2022-03-12 08:25:51'),
	(4, 'permissions.manage', 'Manage Permissions', 'Manage role permissions.', 0, '2022-03-12 08:25:51', '2022-03-12 08:25:51'),
	(5, 'settings.general', 'Update General System Settings', '', 0, '2022-03-12 08:25:51', '2022-03-12 08:25:51'),
	(6, 'settings.auth', 'Update Authentication Settings', 'Update authentication and registration system settings.', 0, '2022-03-12 08:25:51', '2022-03-12 08:25:51'),
	(7, 'settings.notifications', 'Update Notifications Settings', '', 0, '2022-03-12 08:25:51', '2022-03-12 08:25:51'),
	(8, 'announcements.manage', 'Manage Announcements', '', 0, '2022-03-12 08:25:51', '2022-03-12 08:25:51');

-- Dump della struttura di tabella trfcmcauthorized.auth_permission_role
CREATE TABLE IF NOT EXISTS `auth_permission_role` (
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `auth_permission_role_role_id_foreign` (`role_id`),
  CONSTRAINT `auth_permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `auth_permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `auth_permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `auth_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella trfcmcauthorized.auth_permission_role: ~8 rows (circa)
INSERT INTO `auth_permission_role` (`permission_id`, `role_id`) VALUES
	(1, 1),
	(2, 1),
	(3, 1),
	(4, 1),
	(5, 1),
	(6, 1),
	(7, 1),
	(8, 1);

-- Dump della struttura di tabella trfcmcauthorized.auth_personal_access_tokens
CREATE TABLE IF NOT EXISTS `auth_personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_personal_access_tokens_token_unique` (`token`),
  KEY `auth_personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella trfcmcauthorized.auth_personal_access_tokens: ~0 rows (circa)

-- Dump della struttura di tabella trfcmcauthorized.auth_roles
CREATE TABLE IF NOT EXISTS `auth_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `removable` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella trfcmcauthorized.auth_roles: ~4 rows (circa)
INSERT INTO `auth_roles` (`id`, `name`, `display_name`, `description`, `removable`, `created_at`, `updated_at`) VALUES
	(1, 'Admin', 'Admin', 'System administrator.', 0, '2022-03-12 08:25:51', '2022-03-12 08:25:51'),
	(2, 'User', 'User', 'Default system user.', 0, '2022-03-12 08:25:51', '2022-03-12 08:25:51'),
	(3, 'Owner', 'Owner', 'Owner of the portal', 1, '2022-03-12 08:26:27', '2022-03-12 08:26:27'),
	(4, 'Superuser', 'Superuser', 'company administrator', 1, '2022-03-12 08:26:43', '2022-03-12 08:26:43');

-- Dump della struttura di tabella trfcmcauthorized.auth_sessions
CREATE TABLE IF NOT EXISTS `auth_sessions` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payload` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int(11) NOT NULL,
  UNIQUE KEY `auth_sessions_id_unique` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella trfcmcauthorized.auth_sessions: ~3 rows (circa)
INSERT INTO `auth_sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
	('1W8bXLknAQBuCJfAIr2N01ENA65k9t9NoBvAUX3u', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoiMjBZR1ZJNUgwdXk5SFI0SzFHbDRrRkFFekJXTVdqNnE4b2lrczNScCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0NzoiaHR0cHM6Ly9sb2NhbGhvc3QvY21jLWZyb250ZW5kLWF1dGhvcml6ZS9wdWJsaWMiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo1MzoiaHR0cHM6Ly9sb2NhbGhvc3QvY21jLWZyb250ZW5kLWF1dGhvcml6ZS9wdWJsaWMvbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfM2RjN2E5MTNlZjVmZDRiODkwZWNhYmUzNDg3MDg1NTczZTE2Y2Y4MiI7aTozO3M6MjI6IlBIUERFQlVHQkFSX1NUQUNLX0RBVEEiO2E6MDp7fX0=', 1649745774),
	('J8PhimeDpHUUxdkYOr5lSAlgkjkD6ys7TI69VhLA', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiUWNMQ245T1BuVlp5MmIzYkZXNlhQSFlnb2xvb1VqdVo0RFh6YVI0VyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo2MToiaHR0cHM6Ly9sb2NhbGhvc3QvY21jLWZyb250ZW5kLWF1dGhvcml6ZS9wdWJsaWMvZGFzaGJvYXJkLnBocCI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjYxOiJodHRwczovL2xvY2FsaG9zdC9jbWMtZnJvbnRlbmQtYXV0aG9yaXplL3B1YmxpYy9kYXNoYm9hcmQucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czoyMjoiUEhQREVCVUdCQVJfU1RBQ0tfREFUQSI7YToxOntzOjMzOiJYM2Y2NTgzMTFhNDhmNzQ4N2U0YjViYzQ5ZWVlZmRmMTciO047fX0=', 1649778392),
	('uZHufxPSPXJbEOAkbZuliIBu3AwmOKETGm3iLY6R', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiT0RRNDVja0hOV25IbFRPNUpTMmhMbzlrS0xVYk5hdVVaMldNZWY0ZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTM6Imh0dHBzOi8vbG9jYWxob3N0L2NtYy1mcm9udGVuZC1hdXRob3JpemUvcHVibGljL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzNkYzdhOTEzZWY1ZmQ0Yjg5MGVjYWJlMzQ4NzA4NTU3M2UxNmNmODIiO2k6MztzOjIyOiJQSFBERUJVR0JBUl9TVEFDS19EQVRBIjthOjA6e319', 1649785000);

-- Dump della struttura di tabella trfcmcauthorized.auth_settings
CREATE TABLE IF NOT EXISTS `auth_settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `auth_settings_key_index` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella trfcmcauthorized.auth_settings: ~0 rows (circa)

-- Dump della struttura di tabella trfcmcauthorized.auth_social_logins
CREATE TABLE IF NOT EXISTS `auth_social_logins` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `provider` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `provider_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `auth_social_logins_user_id_foreign` (`user_id`),
  CONSTRAINT `auth_social_logins_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `auth_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella trfcmcauthorized.auth_social_logins: ~0 rows (circa)

-- Dump della struttura di tabella trfcmcauthorized.auth_users
CREATE TABLE IF NOT EXISTS `auth_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` int(10) unsigned DEFAULT NULL,
  `role_id` int(10) unsigned NOT NULL,
  `birthday` date DEFAULT NULL,
  `last_login` timestamp NULL DEFAULT NULL,
  `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `two_factor_country_code` int(11) DEFAULT NULL,
  `two_factor_phone` bigint(20) unsigned DEFAULT NULL,
  `two_factor_options` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `announcements_last_read_at` timestamp NULL DEFAULT NULL,
  `idcompany` int(11) DEFAULT NULL,
  `langid` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_users_email_unique` (`email`),
  KEY `auth_users_created_at_index` (`created_at`),
  KEY `auth_users_username_index` (`username`),
  KEY `auth_users_status_index` (`status`),
  KEY `auth_users_country_id_foreign` (`country_id`),
  KEY `auth_users_role_id_foreign` (`role_id`),
  CONSTRAINT `auth_users_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `auth_countries` (`id`) ON DELETE SET NULL,
  CONSTRAINT `auth_users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `auth_roles` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella trfcmcauthorized.auth_users: ~3 rows (circa)
INSERT INTO `auth_users` (`id`, `email`, `username`, `password`, `first_name`, `last_name`, `phone`, `avatar`, `address`, `country_id`, `role_id`, `birthday`, `last_login`, `status`, `two_factor_country_code`, `two_factor_phone`, `two_factor_options`, `email_verified_at`, `remember_token`, `created_at`, `updated_at`, `announcements_last_read_at`, `idcompany`, `langid`) VALUES
	(1, 'admin@example.com', 'admin', '$2y$10$grQ3mP/PkF42wgdzdkBHdeghU.EhtQa0xv15xKQigT853wRo/7lfK', 'Vanguard', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2022-03-28 12:47:41', 'Active', NULL, NULL, NULL, '2022-03-12 08:25:51', NULL, '2022-03-12 08:25:51', '2022-03-28 12:47:41', NULL, 0, 0),
	(2, 'info@acscreativesolutions.com', 'solocla', '$2y$10$h2YxaytQUDJ8T3ikBwSn9O7YimCsWhmYOWfXmiB9WLNtSUxMM2scO', 'Claudio', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'Active', NULL, NULL, NULL, '2022-03-12 08:27:18', NULL, '2022-03-12 08:27:18', '2022-03-12 08:27:18', NULL, 0, 0),
	(3, 'info@prova.com', 'prova', '$2y$10$BkurlKgsGI9RjI0KMzw0duPfEZeIlyRzCe05F7QO.0yuNzulAE4w2', 'Claudio', NULL, NULL, NULL, NULL, 380, 2, NULL, '2022-04-12 13:46:35', 'Active', NULL, NULL, NULL, '2022-03-12 08:27:45', NULL, '2022-03-12 08:27:45', '2022-04-12 13:46:35', NULL, 1, 1);

-- Dump della struttura di tabella trfcmcauthorized.auth_user_activity
CREATE TABLE IF NOT EXISTS `auth_user_activity` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `auth_user_activity_user_id_foreign` (`user_id`),
  CONSTRAINT `auth_user_activity_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `auth_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella trfcmcauthorized.auth_user_activity: ~75 rows (circa)
INSERT INTO `auth_user_activity` (`id`, `description`, `user_id`, `ip_address`, `user_agent`, `created_at`) VALUES
	(1, 'Logged in.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 08:26:02'),
	(2, 'Created new role called Owner.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 08:26:27'),
	(3, 'Created new role called Superuser.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 08:26:43'),
	(4, 'Logged out.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 08:29:48'),
	(5, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 08:35:15'),
	(6, 'Logged out.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 08:35:20'),
	(7, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 08:37:38'),
	(8, 'Logged out.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 08:37:43'),
	(9, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 09:05:24'),
	(10, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 10:12:19'),
	(11, 'Logged out.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 10:15:04'),
	(12, 'Logged in.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 10:15:08'),
	(13, 'Logged out.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 10:16:56'),
	(14, 'Logged in.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 10:16:58'),
	(15, 'Logged out.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 10:18:03'),
	(16, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 10:18:30'),
	(17, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 13:17:34'),
	(18, 'Logged out.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 13:33:47'),
	(19, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 13:33:49'),
	(20, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 13:37:29'),
	(21, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 13:37:37'),
	(22, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 17:59:10'),
	(23, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:11:37'),
	(24, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:25:35'),
	(25, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:25:39'),
	(26, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:26:46'),
	(27, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:26:51'),
	(28, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:26:54'),
	(29, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:26:56'),
	(30, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:27:57'),
	(31, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:42:55'),
	(32, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:42:59'),
	(33, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:43:20'),
	(34, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:43:43'),
	(35, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:44:53'),
	(36, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:44:57'),
	(37, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:48:06'),
	(38, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:49:42'),
	(39, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 18:56:56'),
	(40, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 19:35:27'),
	(41, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 19:36:04'),
	(42, 'Logged out.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 19:37:31'),
	(43, 'Logged in.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-12 19:37:36'),
	(44, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-13 07:06:27'),
	(45, 'Logged out.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-13 07:09:03'),
	(46, 'Logged in.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-13 07:09:07'),
	(47, 'Logged out.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-13 07:16:16'),
	(48, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-13 07:16:20'),
	(49, 'Logged in.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-13 14:36:32'),
	(50, 'Logged in.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-14 16:18:42'),
	(51, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-15 15:37:24'),
	(52, 'Logged out.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-15 17:16:15'),
	(53, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-15 17:16:18'),
	(54, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-16 16:14:33'),
	(55, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-16 19:17:12'),
	(56, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36', '2022-03-18 18:33:51'),
	(57, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.74 Safari/537.36', '2022-03-21 18:50:24'),
	(58, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.74 Safari/537.36', '2022-03-22 15:34:41'),
	(59, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-23 17:17:45'),
	(60, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-24 10:49:00'),
	(61, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-24 16:44:43'),
	(62, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-25 06:22:18'),
	(63, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-25 13:26:00'),
	(64, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-26 16:23:08'),
	(65, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-27 05:24:32'),
	(66, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-27 17:02:55'),
	(67, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-28 11:28:17'),
	(68, 'Logged out.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-28 11:28:39'),
	(69, 'Logged in.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-28 11:28:49'),
	(70, 'Logged out.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-28 11:28:58'),
	(71, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-28 11:29:06'),
	(72, 'Updated profile details.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-28 11:55:17'),
	(73, 'Logged out.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-28 12:47:37'),
	(74, 'Logged in.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-28 12:47:41'),
	(75, 'Logged out.', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-28 12:48:16'),
	(76, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-28 12:48:21'),
	(77, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36', '2022-03-29 13:22:35'),
	(78, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.60 Safari/537.36', '2022-04-02 06:27:03'),
	(79, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.60 Safari/537.36', '2022-04-02 08:27:10'),
	(80, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.60 Safari/537.36', '2022-04-02 11:01:15'),
	(81, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.60 Safari/537.36', '2022-04-02 14:43:00'),
	(82, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.60 Safari/537.36', '2022-04-03 04:54:54'),
	(83, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.60 Safari/537.36', '2022-04-03 07:25:03'),
	(84, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.60 Safari/537.36', '2022-04-03 10:48:32'),
	(85, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.60 Safari/537.36', '2022-04-03 12:48:40'),
	(86, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.60 Safari/537.36', '2022-04-03 14:54:32'),
	(87, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-05 14:00:41'),
	(88, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-05 17:06:15'),
	(89, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-06 13:30:12'),
	(90, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-06 17:24:19'),
	(91, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-07 04:01:56'),
	(92, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-07 16:24:56'),
	(93, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-08 07:50:20'),
	(94, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-08 10:37:51'),
	(95, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-08 12:53:57'),
	(96, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-09 11:04:17'),
	(97, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-09 13:30:59'),
	(98, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-09 17:09:34'),
	(99, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-10 09:32:21'),
	(100, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-10 14:19:54'),
	(101, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-10 17:32:01'),
	(102, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-11 04:43:43'),
	(103, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-11 07:29:57'),
	(104, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-11 11:14:15'),
	(105, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-11 14:33:03'),
	(106, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-12 04:40:25'),
	(107, 'Logged in.', 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-12 13:46:35');

-- Dump della struttura di tabella trfcmcauthorized.certificationtype
CREATE TABLE IF NOT EXISTS `certificationtype` (
  `idcertificationtype` int(11) NOT NULL AUTO_INCREMENT,
  `name_certification` varchar(250) NOT NULL,
  `fmcode_certification` varchar(50) NOT NULL,
  `variable_helpname` varchar(50) NOT NULL,
  `internald_description` text DEFAULT NULL,
  `leftmenulist` varchar(50) DEFAULT NULL,
  `certificationname` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`idcertificationtype`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.certificationtype: ~7 rows (circa)
INSERT INTO `certificationtype` (`idcertificationtype`, `name_certification`, `fmcode_certification`, `variable_helpname`, `internald_description`, `leftmenulist`, `certificationname`) VALUES
	(1, 'M16 + M30S', '-', 'certificatem16m30s', '1', '1,2,3,4,5,6,7,8', 'no variantew'),
	(2, 'M15C', '-', '-', '2', '1,2,3,4,5,6,8', '1checkbox'),
	(3, 'M15B + M30S', '-', '-', '3', '1,2,3,4,5,6,7,8', '2checkbox'),
	(4, 'M15A +M30S', '-', '-', '4', '1,2,3,4,5,6,8', '3checkbox'),
	(5, 'M18A', '-', '-', '5', '1,8,9', '4checbox'),
	(6, 'M18B', '-', '-', '6', '1,8', '5checkbox'),
	(7, 'M16 + M30S Var', '', '', '7', '1,2,3,4,5,6,7,8', 'variante');

-- Dump della struttura di tabella trfcmcauthorized.chemicalagent
CREATE TABLE IF NOT EXISTS `chemicalagent` (
  `idchemicalagent` int(11) NOT NULL AUTO_INCREMENT,
  `name_chemicalagent` varchar(250) NOT NULL,
  `description_chemicalagent` text DEFAULT NULL,
  `idstandard` int(11) NOT NULL,
  `idarticletype` int(11) NOT NULL,
  `variablehelp_chemialagent` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`idchemicalagent`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.chemicalagent: ~20 rows (circa)
INSERT INTO `chemicalagent` (`idchemicalagent`, `name_chemicalagent`, `description_chemicalagent`, `idstandard`, `idarticletype`, `variablehelp_chemialagent`) VALUES
	(1, 'A - Metanolo / A - Methanol', NULL, 0, 0, NULL),
	(2, 'B - Acetone', NULL, 0, 0, NULL),
	(3, 'C - Acetonitrile', NULL, 0, 0, NULL),
	(4, 'D - Diclorometano / D - Dichloromethane', NULL, 0, 0, NULL),
	(5, 'E - Sulfuro di carbonio / E - Carbon disulphide', NULL, 0, 0, NULL),
	(6, 'F - Toluene', NULL, 0, 0, NULL),
	(7, 'G - Dietilammina / G - Diethylamine', NULL, 0, 0, NULL),
	(8, 'H - Tetraidrofurano / H - Tetrahydrofuran', NULL, 0, 0, NULL),
	(9, 'I - Acetato di etile / I - Ethyl acetate', NULL, 0, 0, NULL),
	(10, 'J - n-Eptano / J - n-Heptane', NULL, 0, 0, NULL),
	(11, 'K - Idrossido di sodio 40% / K - Sodium hydroxide 40%', NULL, 0, 0, NULL),
	(12, 'L - Acido Solforico 96% / L - Sulphuric acid 96%', NULL, 0, 0, NULL),
	(13, 'M - Acido Nitrico 65% / M - Nitric acid 65%', NULL, 0, 0, NULL),
	(14, 'N - Acido acetico 99% / N - Acetic acid 99%', NULL, 0, 0, NULL),
	(15, 'O - Idrossido di ammonio 95% / O - Ammonium hydroxide 95%', NULL, 0, 0, NULL),
	(16, 'P - Perossido di idrogeno 30% / P - Hydrogen peroxide 30%', NULL, 0, 0, NULL),
	(17, 'Q - Isopropanolo / Q - Isopropanol', NULL, 0, 0, NULL),
	(18, 'R - Ipoclorito di sodio (13±1%) / R - Sodium Hypochlorite (13±1%)', NULL, 0, 0, NULL),
	(19, 'S - Acido fluoridrico 40% / S - Hydrofluoric acid 40%', NULL, 0, 0, NULL),
	(20, 'T - Formaldeide 37% / T - Formaldehyde 37%', NULL, 0, 0, NULL);

-- Dump della struttura di tabella trfcmcauthorized.colorstab
CREATE TABLE IF NOT EXISTS `colorstab` (
  `idcolorstab` int(11) NOT NULL AUTO_INCREMENT,
  `name_colorstab` varchar(50) NOT NULL,
  `code_colorstab` varchar(50) NOT NULL,
  `variablename_colorstab` varchar(50) NOT NULL,
  PRIMARY KEY (`idcolorstab`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.colorstab: ~0 rows (circa)

-- Dump della struttura di tabella trfcmcauthorized.company
CREATE TABLE IF NOT EXISTS `company` (
  `idcompany` int(11) NOT NULL AUTO_INCREMENT,
  `companyname_company` varchar(200) NOT NULL,
  `address_company` varchar(200) NOT NULL,
  `city_company` varchar(200) NOT NULL,
  `zip_company` varchar(100) NOT NULL,
  `country_company` varchar(200) NOT NULL,
  `piva_company` varchar(100) NOT NULL,
  `telephone_company` varchar(200) DEFAULT NULL,
  `email_company` varchar(200) DEFAULT NULL,
  `maincontactname_company` varchar(100) DEFAULT NULL,
  `maincontactsurname_company` varchar(100) DEFAULT NULL,
  `maincontactmail_company` varchar(100) DEFAULT NULL,
  `maincontactphone_company` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`idcompany`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.company: ~0 rows (circa)
INSERT INTO `company` (`idcompany`, `companyname_company`, `address_company`, `city_company`, `zip_company`, `country_company`, `piva_company`, `telephone_company`, `email_company`, `maincontactname_company`, `maincontactsurname_company`, `maincontactmail_company`, `maincontactphone_company`) VALUES
	(1, 'ACS', 'via prova 5', 'ProvaCity', '11111', 'Italy', '11223344', '112233445566', 'info@prova.it', 'Claudio', 's1', 's', 's');

-- Dump della struttura di tabella trfcmcauthorized.contacts
CREATE TABLE IF NOT EXISTS `contacts` (
  `idcontacts` int(11) NOT NULL AUTO_INCREMENT,
  `idtrf` int(11) DEFAULT NULL,
  `kindofcontacts` varchar(50) DEFAULT NULL,
  `companyname` varchar(250) DEFAULT NULL,
  `piva` varchar(50) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `city` varchar(200) DEFAULT NULL,
  `cap` varchar(10) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `telephone` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `contactname` varchar(200) DEFAULT NULL,
  `contactsurname` varchar(200) DEFAULT NULL,
  `companyid` int(11) DEFAULT NULL,
  `tempcode` varchar(70) NOT NULL,
  PRIMARY KEY (`idcontacts`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.contacts: ~3 rows (circa)
INSERT INTO `contacts` (`idcontacts`, `idtrf`, `kindofcontacts`, `companyname`, `piva`, `address`, `city`, `cap`, `country`, `telephone`, `email`, `contactname`, `contactsurname`, `companyid`, `tempcode`) VALUES
	(2, 82, 'ACS', '', '', 'frederick', 'Lomdon', '0099', 'UK', '123456789', 'info@acs.com', 'Cla', 'ACSCla', NULL, '1-1644141203'),
	(6, 84, 'intermediate', 'hhkhjhk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '1-1644142883'),
	(7, 87, 'intermediate', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '1-1645548867'),
	(8, 122, 'intermediate', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '3-1647971939');

-- Dump della struttura di tabella trfcmcauthorized.dpicategory
CREATE TABLE IF NOT EXISTS `dpicategory` (
  `iddpicategory` int(11) NOT NULL AUTO_INCREMENT,
  `value_dpicategory` varchar(200) NOT NULL,
  `description_dpicategory` text DEFAULT NULL,
  `idarticletype` int(11) NOT NULL,
  `variablehelp_articletype` varchar(200) DEFAULT '',
  PRIMARY KEY (`iddpicategory`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.dpicategory: ~2 rows (circa)
INSERT INTO `dpicategory` (`iddpicategory`, `value_dpicategory`, `description_dpicategory`, `idarticletype`, `variablehelp_articletype`) VALUES
	(2, 'II', NULL, 0, ''),
	(3, 'III', NULL, 0, '');

-- Dump della struttura di tabella trfcmcauthorized.fileattached
CREATE TABLE IF NOT EXISTS `fileattached` (
  `idfileattached` int(11) NOT NULL AUTO_INCREMENT,
  `idtrfdetails` int(11) NOT NULL,
  `filename_fileattached` varchar(200) NOT NULL,
  `description_fileattached` text DEFAULT NULL,
  PRIMARY KEY (`idfileattached`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.fileattached: ~11 rows (circa)
INSERT INTO `fileattached` (`idfileattached`, `idtrfdetails`, `filename_fileattached`, `description_fileattached`) VALUES
	(4, 41, '41-1641660275assistenza.pdf', 'guhjh'),
	(5, 41, '41-1641660662Documento.pdf', 'xdfdfs'),
	(6, 41, '41-1641670561invoice33.pdf', 'sfsdd'),
	(7, 41, '41-1641670751Lietti-Bianchi.pdf', 'ffff'),
	(8, 41, '41-1641671298assistenza.pdf', 'pollo'),
	(9, 42, '42-1641749410assistenza.pdf', 'Prova'),
	(10, 45, '45-1641837911assistenza.pdf', 'asas'),
	(11, 46, '46-1641844509assistenza.pdf', 'Rapporto 223454'),
	(12, 46, '46-1641844614assistenza.pdf', 'dggdffgd'),
	(13, 48, '48-1641977539backend_cimac.pdf', 'prova'),
	(14, 50, '50-1641980356backend_cimac.pdf', 'Rapporto precedente');

-- Dump della struttura di tabella trfcmcauthorized.identificationparts
CREATE TABLE IF NOT EXISTS `identificationparts` (
  `ididentificationparts` int(11) NOT NULL AUTO_INCREMENT,
  `description_identificationparts` varchar(250) NOT NULL,
  `article_identificationparts` varchar(250) NOT NULL,
  `color_identificationparts` varchar(250) NOT NULL,
  `component_identificationparts` varchar(250) DEFAULT NULL,
  `material_identificationparts` varchar(250) DEFAULT NULL,
  `cmcreportnumber_identificationparts` varchar(250) DEFAULT NULL,
  `cmcreportdate_identificationparts` date DEFAULT NULL,
  `thirdlabreportnumber_identificationparts` varchar(250) DEFAULT NULL,
  `thirdlabreportdate_identificationparts` date DEFAULT NULL,
  `reportof` varchar(250) DEFAULT NULL,
  `idtrfdetails` int(11) DEFAULT NULL,
  `kindoftest` char(3) DEFAULT NULL,
  PRIMARY KEY (`ididentificationparts`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.identificationparts: ~36 rows (circa)
INSERT INTO `identificationparts` (`ididentificationparts`, `description_identificationparts`, `article_identificationparts`, `color_identificationparts`, `component_identificationparts`, `material_identificationparts`, `cmcreportnumber_identificationparts`, `cmcreportdate_identificationparts`, `thirdlabreportnumber_identificationparts`, `thirdlabreportdate_identificationparts`, `reportof`, `idtrfdetails`, `kindoftest`) VALUES
	(1, 'Tomaia', '6754', 'Bianco', '', '', NULL, NULL, NULL, NULL, NULL, 41, 'new'),
	(15, 'Prova--Test2', 'fsss1221', 'ordffhdangenn,', '', '', 'dgdfg', '2025-01-21', 'gdgd', '2030-01-02', NULL, 42, 'abc'),
	(16, 'Prova', 'uy', 'orange', '', '', '78765', '2022-01-12', NULL, '2022-01-04', NULL, 42, 'new'),
	(34, 'pelle tomaia', '789', 'Rossa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 42, 'new'),
	(36, 'pelle tomaia', '789', 'Rossa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 42, 'new'),
	(37, 'pelle tomaia', '789', 'Rossa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 42, 'new'),
	(38, 'Pelle Tomaia', '12345', 'Rossa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 45, 'new'),
	(39, 'jkjl', 'jkjkljkl', 'jkljlk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 42, 'new'),
	(40, 'Tomaia', '1223', 'Rosso', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 46, 'new'),
	(41, 'uhiyu', 'uyu', 'Verde', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 46, 'new'),
	(42, 'outersole', 'Aurora', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 47, 'new'),
	(44, 'outersole', 'ggjhg', 'red', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 47, 'new'),
	(45, 'toe', 'jkbmn', 'grey', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 47, 'new'),
	(46, 'toe', 'jkbmn', 'grey', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 47, 'new'),
	(47, 'toe', 'jkbmn', 'grey', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 47, 'new'),
	(48, 'toe', 'jkbmn', 'grey', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 47, 'new'),
	(49, 'toe', 'jhgjjh', 'cyan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 48, 'new'),
	(50, 'back', 'jbjbm', 'darkblue', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 48, 'new'),
	(51, 'heel', 'a12345', 'silver', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, 'new'),
	(52, 'hjhjhkj', 'hjjk', 'red', NULL, NULL, NULL, NULL, '15-12345', '2020-01-07', NULL, 50, 'trd'),
	(53, 'heel', 'a12345', 'silver', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, 'new'),
	(54, 'toebox', 'jhjh', 'cyan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 58, 'new'),
	(55, 'middle', 'c', 'red', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, 'new'),
	(56, 'outersole', 'sadds', 'red', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 65, 'new'),
	(57, 'outersole', 'ClaudioS', 'red', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 65, 'new'),
	(58, 'Listino portaocchielli', 'jkkh', 'magenta', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 93, 'new'),
	(59, 'Listino portaocchielli', 'Prova', 'magenta', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 93, 'new'),
	(60, 'Listino portaocchielli', 'Claus', 'magenta', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 93, 'new'),
	(61, 'Listino portaocchielli', '', 'magenta', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 93, 'new'),
	(62, 'Listino portaocchielli', '', 'magenta', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 93, 'new'),
	(63, 'Listino portaocchielli', '', 'magenta', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 93, 'new'),
	(64, 'Suola', 'SCD', 'red', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 127, 'new'),
	(65, 'hjhj', 'hjhkj', 'hjhkk', NULL, NULL, NULL, NULL, '78978798', '2021-11-12', NULL, 150, 'trd'),
	(66, 'dgdg', 'dgdfg', 'dggd', NULL, NULL, NULL, NULL, 'dgdg', '2022-03-29', NULL, 150, 'trd'),
	(68, 'jhjhkj', 'HGGVH', 'red', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 161, 'new'),
	(69, 'Suola', 'Claudio', 'red', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 165, 'new');

-- Dump della struttura di tabella trfcmcauthorized.languages
CREATE TABLE IF NOT EXISTS `languages` (
  `idlanguages` int(11) NOT NULL AUTO_INCREMENT,
  `name_languages` varchar(50) NOT NULL,
  `flag_languages` varchar(100) NOT NULL,
  `active_languages` char(1) NOT NULL DEFAULT '',
  `acronym_languages` varchar(3) NOT NULL,
  PRIMARY KEY (`idlanguages`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.languages: ~2 rows (circa)
INSERT INTO `languages` (`idlanguages`, `name_languages`, `flag_languages`, `active_languages`, `acronym_languages`) VALUES
	(1, 'Italiano', 'italy_flag.jpg', 'Y', 'it'),
	(2, 'English', 'uk_flag.jpg', 'Y', 'en');

-- Dump della struttura di tabella trfcmcauthorized.liststdaddrequirements
CREATE TABLE IF NOT EXISTS `liststdaddrequirements` (
  `idliststdaddrequirements` int(11) NOT NULL AUTO_INCREMENT,
  `idstandard` int(11) NOT NULL,
  `idadditionalrequirements` int(11) NOT NULL,
  PRIMARY KEY (`idliststdaddrequirements`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.liststdaddrequirements: ~0 rows (circa)

-- Dump della struttura di tabella trfcmcauthorized.modelarticle
CREATE TABLE IF NOT EXISTS `modelarticle` (
  `idmodelarticle` int(11) NOT NULL AUTO_INCREMENT,
  `namemodelarticle` varchar(150) NOT NULL,
  `namemodelarticle_eng` varchar(150) NOT NULL,
  `idarticletype` int(11) NOT NULL,
  PRIMARY KEY (`idmodelarticle`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.modelarticle: ~9 rows (circa)
INSERT INTO `modelarticle` (`idmodelarticle`, `namemodelarticle`, `namemodelarticle_eng`, `idarticletype`) VALUES
	(1, 'Calzatura bassa', 'Low shoe', 1),
	(2, 'Calzatura alla caviglia', 'Ankle boot', 1),
	(3, 'Stivale al polpaccio', 'Half-knee boot', 1),
	(4, 'Stivale al ginocchio', 'Knee-height boot', 1),
	(5, 'Stivale alla coscia', 'Thigh boot', 1),
	(6, 'Zoccolo', 'Clog', 1),
	(7, 'Guanto a 5 dita', '5-fingered glove', 2),
	(8, 'Guanto a 3 dita', '3-fingered glove', 2),
	(9, 'Moffola', 'Mitten', 2),
	(10, 'Semimaschera filtrante antipolvere', 'Filtering half mask to protect against particles', 3);

-- Dump della struttura di tabella trfcmcauthorized.protectioncategory
CREATE TABLE IF NOT EXISTS `protectioncategory` (
  `idprotectioncategory` int(11) NOT NULL AUTO_INCREMENT,
  `name_protectioncategory` varchar(200) NOT NULL,
  `description:_protectioncategory` text DEFAULT NULL,
  `idarticletype` text NOT NULL,
  `variablehelp_protectioncategory` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`idprotectioncategory`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.protectioncategory: ~34 rows (circa)
INSERT INTO `protectioncategory` (`idprotectioncategory`, `name_protectioncategory`, `description:_protectioncategory`, `idarticletype`, `variablehelp_protectioncategory`) VALUES
	(3, 'F1A', NULL, '2', NULL),
	(4, 'F1I', NULL, '2', NULL),
	(5, 'F1PA', NULL, '2', NULL),
	(6, 'F1PI', NULL, '2', NULL),
	(7, 'F2A', NULL, '2', NULL),
	(8, 'F2I', NULL, '2', NULL),
	(9, 'F3A', NULL, '2', NULL),
	(10, 'F3I', NULL, '2', NULL),
	(11, 'Livello 1 / Level 1 (20 m/s)', NULL, '2', NULL),
	(12, 'Livello 2 / Level 2 (24 m/s)', NULL, '2', NULL),
	(13, 'Livello 3 / Level 3 (28 m/s)', NULL, '2', NULL),
	(14, 'O1', NULL, '2', NULL),
	(15, 'O2', NULL, '2', NULL),
	(16, 'O3', NULL, '2', NULL),
	(17, 'O4', NULL, '2', NULL),
	(18, 'O5', NULL, '2', NULL),
	(19, 'OB', NULL, '2', NULL),
	(20, 'OBH', NULL, '2', NULL),
	(21, 'P1', NULL, '2', NULL),
	(22, 'P2', NULL, '2', NULL),
	(23, 'P3', NULL, '2', NULL),
	(24, 'P4', NULL, '2', NULL),
	(25, 'P5', NULL, '2', NULL),
	(26, 'PB', NULL, '2', NULL),
	(27, 'PBH', NULL, '2', NULL),
	(28, 'S1', NULL, '2', NULL),
	(29, 'S2', NULL, '2', NULL),
	(30, 'S3', NULL, '2', NULL),
	(31, 'S4', NULL, '2', NULL),
	(32, 'S5', NULL, '2', NULL),
	(33, 'SB', NULL, '2', NULL),
	(34, 'SBH', NULL, '2', NULL);

-- Dump della struttura di tabella trfcmcauthorized.shoesmultiselection
CREATE TABLE IF NOT EXISTS `shoesmultiselection` (
  `idshoesmultiselection` int(11) NOT NULL AUTO_INCREMENT,
  `name_shoesmultiselection` varchar(250) NOT NULL,
  `description_shoesmultiselection` text NOT NULL,
  `acronym_shoesmultiselection` varchar(100) NOT NULL,
  PRIMARY KEY (`idshoesmultiselection`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.shoesmultiselection: ~0 rows (circa)

-- Dump della struttura di tabella trfcmcauthorized.standards
CREATE TABLE IF NOT EXISTS `standards` (
  `idstandards` int(11) NOT NULL AUTO_INCREMENT,
  `fmidstandards` int(11) NOT NULL,
  `standardname` varchar(250) NOT NULL,
  `standardname_eng` varchar(250) DEFAULT NULL,
  `standardcode` varchar(250) NOT NULL,
  `idarticletype` int(11) NOT NULL,
  `idarticlecharacteristic` int(11) DEFAULT NULL,
  `iddpicategory` int(11) DEFAULT NULL,
  `virusset` char(1) DEFAULT NULL,
  `chemicalsset` char(1) DEFAULT NULL,
  PRIMARY KEY (`idstandards`),
  UNIQUE KEY `fmidstandards` (`fmidstandards`)
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.standards: ~30 rows (circa)
INSERT INTO `standards` (`idstandards`, `fmidstandards`, `standardname`, `standardname_eng`, `standardcode`, `idarticletype`, `idarticlecharacteristic`, `iddpicategory`, `virusset`, `chemicalsset`) VALUES
	(5, 999, 'prova', 'trial', '12345', 1, 5, 2, 'Y', 'Y'),
	(127, 8, 'Guanti di protezione contro rischi meccanici', 'Protective gloves against mechanical risks', 'EN 388:2016A1:2018', 2, 0, NULL, NULL, NULL),
	(128, 9, 'Guanti di protezione e altri dispositivi di protezione delle mani contro rischi termici (calore e/o fuoco)', 'Protective gloves and other hand protective equipments against thermal risks (heat and/or fire)', 'EN 407:2004', 2, NULL, NULL, NULL, NULL),
	(129, 10, 'Guanti di protezione - Requisiti generali e metodi di prova', 'Protective gloves - General requirements and test methods', 'EN 420:2003+A1:2009', 2, NULL, NULL, NULL, NULL),
	(130, 11, 'Guanti di protezione contro le radiazioni ionizzanti e la contaminazione radioattiva', 'Protective gloves against ionizing radiation and radioactive contamination', 'EN 421:2010', 2, NULL, NULL, NULL, NULL),
	(131, 12, 'Guanti di protezione contro il freddo', 'Protective gloves against cold', 'EN 511:2006', 2, NULL, NULL, NULL, NULL),
	(132, 13, 'Guanti di protezione per vigili del fuoco', 'Protective gloves for Firefighters', 'EN 659:2003+A1:2008', 2, NULL, NULL, NULL, NULL),
	(133, 14, 'Vibrazioni meccaniche e urti - Vibrazioni al sistema mano-braccio - Metodo per la misurazione e la valutazione della trasmissibilità delle vibrazioni dai guanti al palmo della mano', 'Mechanical vibration and shock - Hand-arm vibration - Measurement and evaluation of the vibration transmissibility of gloves at the palm of the hand', 'EN ISO 10819:2013 A1:2019', 2, NULL, NULL, NULL, NULL),
	(134, 15, 'Indumenti di protezione per utilizzatori di seghe a catena portatili - Parte 4: Requisiti prestazionali e metodi di prova per guanti di protezione', 'Protective clothing for users of hand-held chainsaws - Part 4: Performance requirements and test methods for protective gloves', 'EN ISO 11393-4:2019', 2, NULL, NULL, NULL, NULL),
	(135, 16, 'Guanti di protezione contro i prodotti chimici e microorganismi pericolosi - Parte 1: Terminologia e requisiti prestazionali per rischi chimici', 'Protective gloves against dangerous chemicals and micro-organisms - Part 1: Terminology and performance requirements for chemical risks', 'EN ISO 374-1:2016', 2, NULL, NULL, NULL, 'Y'),
	(136, 17, 'Guanti di protezione contro i prodotti chimici e microorganismi pericolosi - Parte 5: Terminologia e requisiti prestazionali per rischi da microorganismi', 'Protective gloves against dangerous chemicals and micro-organisms - Part 5: Terminology and performance requirements for micro-organisms risks', 'EN ISO 374-5:2016', 2, NULL, NULL, 'Y', NULL),
	(137, 18, 'Calzature di protezione per motociclisti - Requisiti e metodi di prova', 'Protective footwear for motorcycle riders - Requirements and test methods', 'EN 13634:2017', 1, 1, 2, NULL, NULL),
	(138, 19, 'Calzature di protezione contro agenti chimici - Parte 2: Requisiti per il contatto limitato con gli agenti chimici', 'Footwear protecting against chemicals - Part 2: Requirements for limited contact with chemicals', 'EN 13832-2:2018', 1, NULL, NULL, NULL, NULL),
	(139, 20, 'Calzature di protezione contro agenti chimici - Parte 3: Requisiti per il contatto prolungato con gli agenti chimici', 'Footwear protecting against chemicals - Part 3: Requirements for prolonged contact with chemicals', 'EN 13832-3:2018', 1, NULL, NULL, NULL, 'Y'),
	(140, 21, 'Calzature per vigili del fuoco', 'Footwear for firefighters', 'EN 15090:2012', 1, NULL, NULL, NULL, NULL),
	(141, 22, 'Lavori sotto tensione - Calzature di protezione dielettrica', 'Live working - Footwear for electrical protection - Insulating footwear and overboots', 'EN 50321-1:2018+AC:2018', 1, NULL, NULL, NULL, NULL),
	(142, 23, 'Calzature di sicurezza con resistenza al taglio da sega a catena', 'Safety footwear with resistance to chain saw cutting', 'EN ISO 17249:2013+AC:2014', 1, NULL, NULL, NULL, NULL),
	(143, 24, 'Personal protective equipment - Safety footwear', 'Personal protective equipment - Safety footwear', 'EN ISO 20345:2011', 1, NULL, NULL, NULL, NULL),
	(144, 25, 'Dispositivi di protezione individuale - Calzature di protezione', 'Personal protective equipment - Protective footwear', 'EN ISO 20346:2014', 1, NULL, NULL, NULL, NULL),
	(145, 26, 'Dispositivi di protezione individuale - Calzature da lavoro', 'Personal protective equipment - Occupational footwear', 'EN ISO 20347:2012', 1, NULL, NULL, NULL, NULL),
	(146, 27, 'Dispositivi di protezione individuale - Calzature di protezione contro i rischi presenti nelle fonderie e nelle operazioni di saldatura - Parte 1: Requisiti e metodo di prova per la protezione contro i rischi presenti nelle fonderie', 'Personal protective equipment - Footwear protecting against risks in foundries and welding - Part 1: Requirements and test methods for protection against risks in foundries', 'EN ISO 20349-1:2017', 1, NULL, NULL, NULL, NULL),
	(147, 28, 'Dispositivi di protezione individuale - Calzature di protezione contro i rischi presenti nelle fonderie e nelle operazioni di saldatura - Parte 2: Requisiti e metodi di prova per la protezione contro i rischi presenti nelle operazioni di saldatura e ', 'Personal protective equipment - Footwear protecting against risks in foundries and welding - Part 1: Requirements and test methods for protection against risks in foundries', 'EN ISO 20349-2:2017', 1, NULL, NULL, NULL, NULL),
	(157, 0, 'Guanti e proteggi-braccia di maglia metallica', 'Chain mail gloves and arm guards', 'EN 1082-1:1996', 2, NULL, NULL, NULL, NULL),
	(161, 5, 'Guanti e proteggi-braccia costruiti con materiale diverso dalla maglia metallica', 'Gloves and arm guards made of material other than chain mail', 'EN 1082-2:2000', 2, NULL, NULL, NULL, NULL),
	(164, 6, 'Guanti di protezione per saldatori', 'Protective gloves for welders', 'EN 12477:2001+A1:2005', 2, NULL, NULL, NULL, NULL),
	(166, 7, 'Guanti di protezione per motociclisti - Requisiti e metodi di prova', 'Protective gloves for motorcycle riders - Requirements and test methods', 'EN 13594:2015', 2, 0, NULL, NULL, NULL),
	(167, 2, 'Indumenti di protezione - Guanti e proteggi-braccia contro tagli causati da coltelli motorizzati - Requisiti e metodi di prova', 'Protective clothing - Gloves and armguards protecting against cuts by powered knives - Requirements and test methods', 'EN 14328:2005', 2, NULL, NULL, NULL, NULL),
	(168, 3, 'Indumenti di protezione - Guanti con effetto di protezione per i portieri di calcio', 'Protective clothing - Gloves with protective effect for association football goal keepers', 'EN 16027:2011', 2, NULL, NULL, NULL, NULL),
	(170, 4, 'Guanti di protezione - Proprietà elettrostatiche', 'Protective gloves - Electrostatic properties', 'EN 16350:2014', 2, NULL, NULL, NULL, NULL),
	(171, 29, 'Dispositivi di protezione delle vie respiratorie - Semimaschere filtranti antipolvere - Requisiti, prove, marcatura', 'Respiratory protective devices - Filtering half masks to protect against particles - Requirements, testing, marking', 'EN 149:2001+A1:2009', 3, NULL, NULL, NULL, NULL);

-- Dump della struttura di tabella trfcmcauthorized.stddpicategory
CREATE TABLE IF NOT EXISTS `stddpicategory` (
  `idstddpicategory` int(11) NOT NULL AUTO_INCREMENT,
  `idstandards` int(11) NOT NULL,
  `iddpicategory` int(11) NOT NULL,
  PRIMARY KEY (`idstddpicategory`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.stddpicategory: ~1 rows (circa)
INSERT INTO `stddpicategory` (`idstddpicategory`, `idstandards`, `iddpicategory`) VALUES
	(1, 5, 2),
	(5, 5, 3);

-- Dump della struttura di tabella trfcmcauthorized.stdprotectioncat
CREATE TABLE IF NOT EXISTS `stdprotectioncat` (
  `idstdprotectioncat` int(11) NOT NULL AUTO_INCREMENT,
  `idstandards` int(11) NOT NULL,
  `idprotectioncategory` int(11) NOT NULL,
  PRIMARY KEY (`idstdprotectioncat`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.stdprotectioncat: ~3 rows (circa)
INSERT INTO `stdprotectioncat` (`idstdprotectioncat`, `idstandards`, `idprotectioncategory`) VALUES
	(10, 5, 8),
	(11, 5, 11),
	(12, 5, 18);

-- Dump della struttura di tabella trfcmcauthorized.trf-details
CREATE TABLE IF NOT EXISTS `trf-details` (
  `idtrfdetails` int(11) NOT NULL AUTO_INCREMENT,
  `trfnumber` int(11) NOT NULL,
  `idcompany` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `idcertification` int(11) NOT NULL,
  `previousreportnumber` varchar(50) DEFAULT NULL,
  `sample_description` varchar(250) NOT NULL,
  `measurefrom` varchar(50) DEFAULT NULL,
  `measureto` varchar(50) DEFAULT NULL,
  `model` varchar(250) NOT NULL,
  `idarticletype` int(1) unsigned zerofill NOT NULL,
  `idarticle_characteristics` int(11) DEFAULT NULL,
  `idprotection_category` int(11) NOT NULL,
  `iddpi_category` int(11) NOT NULL,
  `registeredmark` varchar(200) DEFAULT NULL,
  `virus_protection` varchar(1) DEFAULT NULL,
  `dateintrf` int(11) NOT NULL,
  `tempcode` varchar(80) NOT NULL,
  `virusprotection` char(1) DEFAULT NULL,
  `shoesorthopedic` char(1) DEFAULT NULL,
  `autoclavable` char(1) DEFAULT NULL,
  `esd` char(1) DEFAULT NULL,
  `slipping` varchar(50) DEFAULT NULL,
  `photofilename` varchar(250) DEFAULT NULL,
  `notificatedorganismname` varchar(200) DEFAULT NULL,
  `signedon` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`idtrfdetails`),
  UNIQUE KEY `trfnumber` (`trfnumber`)
) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.trf-details: ~148 rows (circa)
INSERT INTO `trf-details` (`idtrfdetails`, `trfnumber`, `idcompany`, `iduser`, `idcertification`, `previousreportnumber`, `sample_description`, `measurefrom`, `measureto`, `model`, `idarticletype`, `idarticle_characteristics`, `idprotection_category`, `iddpi_category`, `registeredmark`, `virus_protection`, `dateintrf`, `tempcode`, `virusprotection`, `shoesorthopedic`, `autoclavable`, `esd`, `slipping`, `photofilename`, `notificatedorganismname`, `signedon`) VALUES
	(1, 1, 1, 1, 3, NULL, 'jhkhjhjkhjkjk', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(15, 15, 1, 1, 7, '98655', 'qwer', '5.0', NULL, '123', 2, 5, 0, 0, NULL, NULL, 0, '1-1640531621', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(17, 16, 1, 1, 7, '21-12345', 'qwerty', '2345.0', NULL, '12345', 1, 2, 0, 0, NULL, NULL, 0, '1-1640690812', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(18, 17, 1, 1, 7, NULL, 'bbbbb', '0.0', NULL, 'bbbbb', 1, 5, 0, 0, NULL, NULL, 0, '1-1640698101', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(19, 18, 1, 1, 1, NULL, 'Descrizione', '0.0', NULL, 'Modello', 0, NULL, 0, 0, NULL, NULL, 0, '1-1640788979', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(20, 19, 1, 1, 1, NULL, 'au', '11.0', NULL, '00', 1, NULL, 0, 0, NULL, NULL, 0, '1-1640799082', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(21, 20, 1, 1, 1, NULL, 'popo', '9.0', NULL, '09', 1, NULL, 0, 0, NULL, NULL, 0, '1-1640799308', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(22, 21, 1, 1, 1, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1640799405', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(23, 22, 1, 1, 1, NULL, 'uuu', '222.0', NULL, '222', 1, NULL, 0, 0, NULL, NULL, 0, '1-1640799473', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(34, 23, 1, 1, 1, NULL, 'prova1', '2.0', NULL, '1', 1, 1, 0, 0, NULL, NULL, 0, '1-1640862047', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(35, 24, 1, 1, 1, NULL, 'jkhkjhsd', '5.0', NULL, '5678', 1, 1, 0, 0, NULL, NULL, 0, '1-1640889122', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(36, 25, 1, 1, 2, NULL, 'ppppp', '7877.0', NULL, '0000', 1, 2, 0, 0, NULL, NULL, 0, '1-1641210387', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(37, 26, 1, 1, 3, NULL, 'adda', '23.0', NULL, '123', 1, NULL, 0, 0, NULL, NULL, 0, '1-1641288483', NULL, 'Y', NULL, 'Y', 'SRA', NULL, NULL, NULL),
	(38, 27, 1, 1, 0, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(39, 28, 1, 1, 1, NULL, 'weert', '345.0', NULL, '123', 1, 1, 0, 0, NULL, NULL, 0, '1-1641370548', NULL, 'Y', NULL, 'Y', 'SRA', '39-1641374640images.jpg', NULL, NULL),
	(40, 29, 1, 1, 1, NULL, '', NULL, NULL, '', 1, NULL, 0, 0, NULL, NULL, 0, '1-1641398707', NULL, NULL, 'Y', 'Y', 'SRA', '40-1641398740download.jpg', NULL, NULL),
	(41, 30, 1, 1, 1, NULL, 'pollo', '2222.0', NULL, '55555', 1, 4, 0, 0, NULL, NULL, 0, '1-1641464918', NULL, NULL, 'Y', 'Y', 'No', '41-1641464925u-power-rl20216-scarpe-antinfortunistiche-basse-verok-s1p-src_1_full.jpg', NULL, NULL),
	(42, 31, 1, 1, 1, NULL, 'jnjk', '8980.0', NULL, '8980', 1, 3, 0, 0, NULL, NULL, 0, '1-1641543701', NULL, NULL, NULL, NULL, 'No', '42-1641543721download (1).jpg', NULL, NULL),
	(43, 32, 1, 1, 4, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1641655357', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(44, 33, 1, 1, 5, '21-5647', 'dfsfd', '0.0', NULL, 'sfsd', 2, 2, 0, 0, NULL, NULL, 0, '1-1641828831', 'Y', NULL, NULL, NULL, NULL, '44-1641828854111954621a-002_01_260Wx260H.jpg', NULL, NULL),
	(45, 34, 1, 1, 4, '21-578', 'Prova Scarpa', '11.0', NULL, '12345', 1, 4, 0, 0, NULL, NULL, 0, '1-1641835189', NULL, NULL, 'Y', NULL, 'No', '45-1641835360download.jpg', NULL, NULL),
	(46, 35, 1, 1, 5, '21-15897', 'Prova 3', '123.0', NULL, 'chiaro', 1, 5, 0, 0, NULL, NULL, 0, '1-1641844181', NULL, 'Y', NULL, NULL, 'SRA', '46-1641844197images (11).jpg', NULL, NULL),
	(47, 36, 1, 1, 2, '21-12345', 'prova 5', '888.0', NULL, 'fgt', 1, 2, 0, 0, NULL, NULL, 0, '1-1641906062', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(48, 37, 1, 1, 1, NULL, 'Prova 5', '1212.0', NULL, '1234', 1, 3, 0, 0, NULL, NULL, 0, '1-1641977159', NULL, 'Y', 'Y', NULL, 'SRA', '48-164197718255a966f3371d22c6178b62ed.jpg', NULL, NULL),
	(49, 38, 1, 1, 7, '20-12345', '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1641979445', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(50, 39, 1, 1, 7, '20-12345', 'Scarpa rossa', '42.0', NULL, 'A12345', 1, 1, 0, 0, NULL, NULL, 0, '1-1641979482', NULL, 'Y', NULL, NULL, 'SRB', '50-164197954955a966f3371d22c6178b62ed.jpg', NULL, NULL),
	(51, 40, 1, 1, 4, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1641980530', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(52, 41, 1, 1, 7, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1641982143', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(53, 42, 1, 1, 3, NULL, 'prova', '43.0', NULL, '123', 1, 4, 0, 0, NULL, NULL, 0, '1-1642687259', NULL, NULL, NULL, NULL, NULL, '53-1642695954homepage-tiles-yeezy.jpg', NULL, NULL),
	(54, 43, 1, 1, 5, '12345', 'Prova15', '42.0', NULL, '2', 1, 5, 0, 0, NULL, NULL, 0, '1-1642696850', NULL, NULL, NULL, NULL, NULL, '54-1642700072images (6).jpg', NULL, NULL),
	(55, 44, 1, 1, 3, NULL, 'asd', '38.0', NULL, 'l01', 1, 5, 0, 0, NULL, NULL, 0, '1-1642773688', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(56, 45, 1, 1, 6, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1642778909', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(57, 46, 1, 1, 5, NULL, 'xaxa', '0.0', NULL, 'xaxa', 2, 4, 0, 0, NULL, NULL, 0, '1-1642779001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(58, 47, 1, 1, 3, NULL, 'prova 20', '41.0', NULL, 'a123', 1, 4, 0, 0, NULL, NULL, 0, '1-1642869802', NULL, 'Y', 'Y', NULL, 'SRA', NULL, NULL, NULL),
	(59, 48, 1, 1, 4, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1642880113', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(60, 49, 1, 1, 4, NULL, 'Prova 21', '41.0', NULL, '909\'', 1, 4, 0, 0, NULL, NULL, 0, '1-1642936634', NULL, 'Y', NULL, NULL, 'SRA', '60-1642952737u-power-rl20216-scarpe-antinfortunistiche-basse-verok-s1p-src_1_full.jpg', NULL, NULL),
	(61, 50, 1, 1, 3, NULL, 'hfhg', '0.0', NULL, 'fh', 1, 4, 0, 0, NULL, NULL, 0, '1-1642953192', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(62, 51, 1, 1, 4, NULL, 'werrwewer', '0.0', NULL, 'wewrewr', 2, 4, 0, 0, NULL, NULL, 0, '1-1642953396', NULL, NULL, NULL, NULL, NULL, '62-1642960239images (5).jpg', NULL, NULL),
	(63, 52, 1, 1, 3, NULL, 'dgdg', '0.0', NULL, 'dgdg', 1, 4, 0, 0, NULL, NULL, 0, '1-1643043437', NULL, NULL, NULL, 'Y', 'No', NULL, NULL, NULL),
	(64, 53, 1, 1, 5, NULL, 'nkln', NULL, NULL, 'gn', 1, NULL, 0, 0, NULL, NULL, 0, '1-1643045924', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(65, 54, 1, 1, 3, NULL, 'ooioi', '0.0', NULL, 'ioi', 1, 4, 0, 0, NULL, NULL, 0, '1-1643128111', NULL, NULL, 'Y', NULL, 'No', NULL, NULL, NULL),
	(66, 55, 1, 1, 2, '6786868', '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1643747193', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(67, 56, 1, 1, 2, '12345678', '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1643747273', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(68, 57, 1, 1, 2, '67890', '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1643747400', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(69, 58, 1, 1, 2, '00099877', '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1643747589', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(70, 59, 1, 1, 3, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1643823245', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(71, 60, 1, 1, 2, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1643823380', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(72, 61, 1, 1, 7, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1643823392', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(73, 62, 1, 1, 7, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1643823446', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(74, 63, 1, 1, 7, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1643823548', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(75, 64, 1, 1, 7, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1643823560', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(76, 65, 1, 1, 7, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1643823737', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(77, 66, 1, 1, 1, NULL, 'dsdfs', '0.0', NULL, 'sfds', 1, 4, 0, 0, NULL, NULL, 0, '1-1643823744', NULL, 'Y', NULL, NULL, 'SRA', '77-1643823769Copia di Copia di Copia di Copia di Copia di Giapponese Sushi Foto Cibo Instagram Post (3).png', NULL, NULL),
	(78, 67, 1, 1, 2, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1643832017', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(79, 68, 1, 1, 2, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1643875082', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(80, 69, 1, 1, 2, NULL, 'errwere', '24234.0', NULL, 'werrwe', 1, 1, 0, 0, NULL, NULL, 0, '1-1643876558', NULL, NULL, NULL, NULL, NULL, '80-16438766141_160943_TH_ALT1.jpg', 'CIMAC', NULL),
	(81, 70, 1, 1, 2, NULL, 'werwer', '0.0', NULL, 'werrwe', 1, 5, 0, 0, NULL, NULL, 0, '1-1643877634', NULL, NULL, NULL, 'Y', 'No', NULL, 'CIMAC', NULL),
	(82, 71, 1, 1, 2, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1644141203', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(83, 72, 1, 1, 5, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1644142395', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(84, 73, 1, 1, 3, NULL, 'Prova', '35', '43', '12', 1, 4, 0, 0, 'Ciao Ciao ACS', NULL, 0, '1-1644142883', NULL, NULL, NULL, 'Y', 'No', '84-1644156585images (8).jpg', NULL, NULL),
	(85, 74, 1, 1, 2, NULL, 'ad', '6', '6', 'adsa', 2, 1, 0, 0, '656', NULL, 0, '1-1644343245', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(86, 75, 1, 1, 3, NULL, 'sffsd', '3', '3', 'sfsd', 1, 4, 0, 0, 'wer', NULL, 0, '1-1644352887', NULL, NULL, 'Y', NULL, 'No', NULL, NULL, NULL),
	(87, 76, 1, 1, 1, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1645548867', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(88, 77, 1, 1, 4, NULL, 'sdfsdf', NULL, NULL, 'sdff', 1, NULL, 0, 0, NULL, NULL, 0, '1-1645636462', NULL, NULL, 'Y', NULL, 'No', NULL, NULL, NULL),
	(89, 78, 1, 1, 6, NULL, 'fsdf', NULL, NULL, 'sdfsdf', 1, NULL, 0, 0, NULL, NULL, 0, '1-1645725926', NULL, NULL, 'Y', NULL, 'No', NULL, NULL, NULL),
	(90, 79, 1, 1, 1, NULL, 'bhbjh', NULL, NULL, '', 1, NULL, 0, 0, NULL, NULL, 0, '1-1645976605', NULL, NULL, 'Y', NULL, 'No', NULL, NULL, NULL),
	(91, 80, 1, 3, 1, NULL, 'sfs', NULL, NULL, '', 1, NULL, 0, 0, NULL, NULL, 0, '1-1645978686', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(92, 81, 1, 1, 2, NULL, 'wrwerwer', NULL, NULL, '', 2, NULL, 0, 0, NULL, NULL, 0, '1-1645980753', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(93, 82, 1, 3, 4, NULL, 'sasd', NULL, NULL, 'asdda', 1, 5, 0, 0, NULL, NULL, 0, '1-1646130384', NULL, NULL, 'Y', NULL, 'No', NULL, NULL, NULL),
	(94, 83, 1, 1, 2, NULL, 'jo', NULL, NULL, '', 1, NULL, 0, 0, NULL, NULL, 0, '1-1646158031', NULL, NULL, NULL, NULL, 'No', NULL, 'CIMAC', NULL),
	(95, 84, 1, 1, 5, NULL, '', NULL, NULL, '', 1, NULL, 0, 0, NULL, NULL, 0, '1-1646336444', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(96, 85, 1, 1, 7, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1646478174', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(97, 86, 1, 1, 4, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1646478832', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(98, 87, 1, 1, 2, NULL, 'dsd', NULL, NULL, '', 1, NULL, 0, 0, NULL, NULL, 0, '1-1646480745', NULL, NULL, NULL, NULL, 'No', NULL, 'CIMAC', NULL),
	(99, 88, 1, 1, 5, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1646556942', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(100, 89, 1, 1, 5, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1646570114', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(101, 90, 1, 1, 5, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1646581538', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(102, 91, 1, 1, 2, NULL, 'hjkh', NULL, NULL, '', 1, NULL, 0, 0, NULL, NULL, 0, '1-1646584158', NULL, NULL, 'Y', NULL, 'No', NULL, 'CIMAC', NULL),
	(103, 92, 1, 1, 2, NULL, 'jkjkh', NULL, NULL, '3', 1, NULL, 0, 0, NULL, NULL, 0, '1-1646585261', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(104, 93, 1, 1, 2, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '1-1646670771', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(105, 94, 1, 1, 2, NULL, 'sfsfd', NULL, NULL, '3', 1, NULL, 0, 0, NULL, NULL, 0, '1-1646761302', NULL, NULL, NULL, NULL, 'No', NULL, 'CIMAC', NULL),
	(106, 95, 1, 0, 2, NULL, 'ss', '4', '3', '3', 1, 5, 0, 0, 'sdf', NULL, 0, '{', NULL, NULL, 'Y', NULL, 'No', NULL, 'CIMAC', NULL),
	(107, 96, 1, 3, 2, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1647009725', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(108, 97, 1, 3, 3, NULL, 'xcvvc', '6', '9', '3', 1, 4, 0, 0, 'vxv', NULL, 0, '3-1647009791', NULL, NULL, NULL, 'Y', 'No', NULL, NULL, NULL),
	(109, 98, 1, 3, 2, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1647010447', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(110, 99, 1, 3, 2, NULL, 'uihu', NULL, NULL, '3', 2, 4, 0, 0, NULL, NULL, 0, '3-1647016911', NULL, NULL, NULL, NULL, NULL, '110-16470169462542115.jpg', 'CIMAC', NULL),
	(111, 100, 1, 3, 5, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1647016969', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(112, 101, 1, 3, 6, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1647018816', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(113, 102, 1, 3, 3, NULL, 'ssdf', NULL, NULL, '3', 1, NULL, 0, 0, NULL, NULL, 0, '3-1647083061', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(114, 103, 1, 3, 2, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1647096200', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(115, 104, 1, 3, 2, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1647158815', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(116, 105, 1, 3, 2, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1647368181', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(117, 106, 1, 3, 1, NULL, 'dnadsnnk', '9898', '898980', '3', 1, 4, 0, 0, 'sss', NULL, 0, '3-1647453348', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(118, 107, 1, 3, 2, NULL, 'ABC123', '36', '44', '3', 1, 3, 0, 0, 'ACS Mark', NULL, 0, '3-1647461835', NULL, NULL, NULL, NULL, NULL, '118-1647461860list-HFM-CRN_HFS-CrimsonNavy_AngleR_0928-72dpi-770x500.jpg', 'CIMAC', NULL),
	(119, 108, 1, 3, 1, NULL, 'gdff', '34', '45', '3', 1, 4, 0, 0, 'erterert', NULL, 0, '3-1647632153', NULL, NULL, NULL, NULL, 'No', '119-1647632185download.jpg', NULL, NULL),
	(120, 109, 1, 3, 2, NULL, 'bjkhjhjkk', NULL, NULL, '3', 1, NULL, 0, 0, NULL, NULL, 0, '3-1647892227', NULL, NULL, 'Y', NULL, 'No', NULL, 'CIMAC', NULL),
	(121, 110, 1, 3, 1, NULL, 'sdff', NULL, NULL, '2', 2, NULL, 0, 0, NULL, NULL, 0, '3-1647966885', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(122, 111, 1, 3, 5, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1647971939', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(123, 112, 1, 3, 2, NULL, 'xcvxvxvc', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648059471', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(124, 113, 1, 3, 5, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1648474221', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(125, 114, 1, 3, 1, NULL, 'gdfdg', NULL, NULL, '2', 1, 11, 0, 0, NULL, NULL, 0, '3-1648474294', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(126, 115, 1, 3, 2, NULL, 'sdfsdfsdf', NULL, NULL, '2', 1, 9, 0, 0, NULL, NULL, 0, '3-1648476592', NULL, NULL, NULL, NULL, 'No', NULL, 'CIMAC', NULL),
	(127, 116, 1, 3, 2, NULL, 'prova', NULL, NULL, '2', 1, 29, 0, 0, NULL, NULL, 0, '3-1648477959', NULL, NULL, NULL, NULL, 'No', NULL, 'CIMAC', NULL),
	(128, 117, 1, 3, 2, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1648479015', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(129, 118, 1, 3, 2, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1648567365', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(130, 119, 1, 3, 7, NULL, 'dsad', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648568269', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(131, 120, 1, 3, 4, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1648569561', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(132, 121, 1, 3, 5, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1648569792', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(133, 122, 1, 3, 2, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1648570348', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(134, 123, 1, 3, 1, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1648570865', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(135, 124, 1, 3, 1, NULL, 'adsdasdas', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648571753', NULL, NULL, 'Y', NULL, 'No', NULL, NULL, NULL),
	(136, 125, 1, 3, 3, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1648574102', NULL, NULL, NULL, NULL, NULL, NULL, 'CIMAC', NULL),
	(137, 126, 1, 3, 5, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1648888069', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(138, 127, 1, 3, 2, NULL, 'dfg', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648888581', NULL, NULL, NULL, NULL, 'No', NULL, 'CIMAC', NULL),
	(139, 128, 1, 3, 3, NULL, 'dgdf', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648888769', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(140, 129, 1, 3, 4, NULL, 'sdgddf', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648888790', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(141, 130, 1, 3, 1, NULL, 'sdff', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648888892', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(142, 131, 1, 3, 1, NULL, 'sdf', '34', '42', '2', 1, 3, 0, 0, NULL, NULL, 0, '3-1648889111', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(143, 132, 1, 3, 1, NULL, 'hjkj', NULL, NULL, '2', 2, NULL, 0, 0, NULL, NULL, 0, '3-1648890403', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(144, 133, 1, 3, 1, NULL, 'jhhjk', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648890507', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(145, 134, 1, 3, 1, NULL, 'ghjghj', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648890691', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(146, 135, 1, 3, 1, NULL, 'sfsf', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648890939', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(147, 136, 1, 3, 1, NULL, 'ghjgj', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648891212', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(148, 137, 1, 3, 1, NULL, 'dgfg', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648892202', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(149, 138, 1, 3, 1, NULL, 'bjhg', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648893591', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(150, 139, 1, 3, 1, NULL, 'khk', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648895232', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(151, 140, 1, 3, 1, NULL, 'dffgddg', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648904487', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(152, 141, 1, 3, 1, NULL, 'jhhj', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648906640', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(153, 142, 1, 3, 1, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1648970613', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(154, 143, 1, 3, 1, NULL, 'xcvxvx', NULL, NULL, '2', 1, 6, 0, 0, NULL, NULL, 0, '3-1648977906', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(155, 144, 1, 3, 1, NULL, 'jhgjhgjh', NULL, NULL, '1', 1, 3, 0, 0, NULL, NULL, 0, '3-1648990115', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(156, 145, 1, 3, 1, NULL, 'jioiuo', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648998041', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(157, 146, 1, 3, 1, NULL, 'jiljil', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648998234', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(158, 147, 1, 3, 1, NULL, 'hih', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1648998356', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(159, 148, 1, 3, 1, NULL, 'wefwfe', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649004874', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(160, 149, 1, 3, 1, NULL, 'sdffd', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649174445', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(161, 150, 1, 3, 1, NULL, 'klòlok', NULL, NULL, '2', 2, NULL, 0, 0, NULL, NULL, 0, '3-1649185577', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(162, 151, 1, 3, 1, NULL, 'sdfsfs', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649259015', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(163, 152, 1, 3, 1, NULL, 'sdfdfssdf', NULL, NULL, '1', 1, 1, 0, 0, NULL, NULL, 0, '3-1649355901', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(164, 153, 1, 3, 1, NULL, 'lllll', NULL, NULL, '3', 1, 4, 0, 0, NULL, NULL, 0, '3-1649413135', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(165, 154, 1, 3, 1, NULL, 'sdffs', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649421474', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(166, 155, 1, 3, 1, NULL, 'xccv', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649429640', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(167, 156, 1, 3, 5, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1649429718', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(168, 157, 1, 3, 1, NULL, 'zxczcx', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649509460', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(169, 158, 1, 3, 1, NULL, 'gdgd', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649518261', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(170, 159, 1, 3, 1, NULL, 'ddg', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649531376', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(171, 160, 1, 3, 1, NULL, 'sfsdf', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649590344', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(172, 161, 1, 3, 1, NULL, '', NULL, NULL, '', 0, NULL, 0, 0, NULL, NULL, 0, '3-1649607794', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(173, 162, 1, 3, 1, NULL, 'asssaaasaaa', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649608245', NULL, NULL, NULL, NULL, 'No', NULL, NULL, NULL),
	(174, 163, 1, 3, 1, NULL, 'ghghgfhffghfgh', NULL, NULL, '2', 1, 6, 0, 0, NULL, NULL, 0, '3-1649610371', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(175, 164, 1, 3, 1, NULL, 'dgffgdf', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649619124', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(176, 165, 1, 3, 1, NULL, 'sdffssd', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649659427', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(177, 166, 1, 3, 1, NULL, 's', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649682859', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(178, 167, 1, 3, 1, NULL, 'zxc', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649683554', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(179, 168, 1, 3, 1, NULL, 'adad', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649694786', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(180, 169, 1, 3, 1, NULL, 'sdff', NULL, NULL, '2', 1, NULL, 0, 0, NULL, NULL, 0, '3-1649745642', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(181, 170, 1, 3, 1, NULL, 'jjjj', NULL, NULL, '2', 1, 9, 0, 0, NULL, NULL, 0, '3-1649778398', NULL, NULL, NULL, NULL, NULL, '181-1649784995128069.jpg', NULL, NULL);

-- Dump della struttura di tabella trfcmcauthorized.trfaddrequirements
CREATE TABLE IF NOT EXISTS `trfaddrequirements` (
  `idtrfaddrequirements` int(11) NOT NULL AUTO_INCREMENT,
  `idtrf` int(11) NOT NULL,
  `idadditionalrequirements` int(11) NOT NULL,
  PRIMARY KEY (`idtrfaddrequirements`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.trfaddrequirements: ~38 rows (circa)
INSERT INTO `trfaddrequirements` (`idtrfaddrequirements`, `idtrf`, `idadditionalrequirements`) VALUES
	(1, 39, 1),
	(2, 39, 5),
	(3, 39, 2),
	(4, 39, 8),
	(31, 39, 3),
	(32, 39, 7),
	(33, 39, 4),
	(34, 40, 4),
	(35, 41, 2),
	(36, 42, 9),
	(37, 44, 30),
	(38, 44, 34),
	(39, 45, 1),
	(40, 45, 9),
	(41, 46, 8),
	(42, 46, 2),
	(43, 48, 2),
	(44, 48, 4),
	(45, 50, 8),
	(46, 50, 3),
	(47, 50, 9),
	(48, 50, 2),
	(49, 55, 1),
	(50, 58, 1),
	(51, 58, 4),
	(52, 60, 1),
	(53, 63, 1),
	(54, 65, 20),
	(55, 77, 1),
	(56, 81, 1),
	(57, 84, 16),
	(58, 86, 17),
	(59, 118, 20),
	(60, 89, 18),
	(61, 90, 15),
	(62, 118, 14),
	(63, 105, 0),
	(64, 118, 2),
	(65, 119, 1),
	(66, 119, 2),
	(67, 126, 1),
	(68, 126, 3),
	(69, 164, 1);

-- Dump della struttura di tabella trfcmcauthorized.trfchemicalagent
CREATE TABLE IF NOT EXISTS `trfchemicalagent` (
  `idtrfchemicalagent` int(11) NOT NULL AUTO_INCREMENT,
  `idtrf` int(11) NOT NULL,
  `idchemicalagent` int(11) NOT NULL,
  PRIMARY KEY (`idtrfchemicalagent`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.trfchemicalagent: ~30 rows (circa)
INSERT INTO `trfchemicalagent` (`idtrfchemicalagent`, `idtrf`, `idchemicalagent`) VALUES
	(1, 39, 2),
	(2, 39, 4),
	(3, 39, 7),
	(4, 39, 11),
	(5, 39, 3),
	(6, 40, 2),
	(7, 41, 4),
	(8, 42, 12),
	(9, 44, 2),
	(10, 44, 8),
	(11, 45, 1),
	(12, 45, 5),
	(13, 46, 8),
	(14, 48, 2),
	(15, 48, 4),
	(16, 50, 1),
	(17, 50, 5),
	(18, 55, 2),
	(19, 58, 1),
	(20, 60, 1),
	(21, 63, 1),
	(22, 65, 15),
	(23, 77, 2),
	(24, 81, 2),
	(25, 81, 18),
	(26, 81, 13),
	(27, 81, 8),
	(28, 84, 17),
	(29, 88, 17),
	(30, 89, 11);

-- Dump della struttura di tabella trfcmcauthorized.trfstandards
CREATE TABLE IF NOT EXISTS `trfstandards` (
  `idtrfstandards` int(11) NOT NULL AUTO_INCREMENT,
  `idtrfdetails` int(11) NOT NULL,
  `idstandards` int(11) NOT NULL,
  `idprotectioncategory` int(11) DEFAULT NULL,
  `iddpicategory` int(11) DEFAULT NULL,
  PRIMARY KEY (`idtrfstandards`)
) ENGINE=InnoDB AUTO_INCREMENT=198 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.trfstandards: ~136 rows (circa)
INSERT INTO `trfstandards` (`idtrfstandards`, `idtrfdetails`, `idstandards`, `idprotectioncategory`, `iddpicategory`) VALUES
	(1, 34, 1, 0, 0),
	(24, 34, 5, 0, 0),
	(25, 34, 6, 0, 0),
	(26, 35, 1, 0, 0),
	(27, 35, 5, 0, 0),
	(28, 35, 6, 0, 0),
	(29, 36, 6, 0, 0),
	(30, 36, 1, 0, 0),
	(31, 36, 5, 0, 0),
	(32, 37, 5, 0, 0),
	(33, 39, 5, 0, 0),
	(34, 40, 5, 0, 0),
	(35, 41, 5, 0, 0),
	(36, 41, 1, 0, 0),
	(37, 42, 1, 0, 0),
	(38, 45, 138, 0, 0),
	(39, 45, 144, 0, 0),
	(40, 46, 5, 0, 0),
	(41, 46, 137, 0, 0),
	(42, 46, 140, 0, 0),
	(43, 47, 138, 0, 0),
	(44, 47, 139, 0, 0),
	(45, 47, 140, 0, 0),
	(46, 48, 5, 0, 0),
	(47, 48, 6, 0, 0),
	(48, 48, 142, 0, 0),
	(49, 50, 137, 0, 0),
	(50, 50, 138, 0, 0),
	(51, 50, 139, 0, 0),
	(52, 50, 140, 0, 0),
	(53, 55, 6, 0, 0),
	(54, 55, 138, 0, 0),
	(55, 57, 129, 0, 0),
	(56, 57, 130, 0, 0),
	(57, 58, 1, 0, 0),
	(58, 58, 5, 0, 0),
	(59, 60, 138, 0, 0),
	(60, 60, 139, 0, 0),
	(61, 61, 139, 0, 0),
	(62, 61, 141, 0, 0),
	(63, 63, 138, 0, 0),
	(64, 65, 147, 0, 0),
	(65, 77, 6, 0, 0),
	(66, 77, 137, 0, 0),
	(67, 81, 146, 0, 0),
	(68, 84, 141, 0, 0),
	(73, 84, 131, 0, 0),
	(75, 84, 139, 0, 0),
	(76, 89, 138, 0, 0),
	(77, 90, 1, 0, 0),
	(78, 91, 137, 0, 0),
	(79, 92, 127, 0, 0),
	(80, 93, 142, 0, 0),
	(81, 93, 147, 0, 0),
	(82, 95, 144, 0, 0),
	(83, 95, 140, 0, 0),
	(84, 95, 141, 0, 0),
	(85, 98, 141, 0, 0),
	(86, 102, 138, 0, 0),
	(87, 105, 137, 0, 0),
	(88, 106, 139, 0, 0),
	(89, 106, 140, 0, 0),
	(90, 108, 141, 0, 0),
	(91, 118, 1, 0, 0),
	(92, 118, 5, 0, 0),
	(93, 118, 6, 0, 0),
	(94, 118, 137, 0, 0),
	(95, 118, 138, 0, 0),
	(96, 118, 139, 0, 0),
	(97, 118, 140, 0, 0),
	(98, 118, 141, 0, 0),
	(99, 118, 142, 0, 0),
	(100, 118, 143, 0, 0),
	(101, 118, 144, 0, 0),
	(102, 118, 145, 0, 0),
	(103, 118, 146, 0, 0),
	(104, 118, 147, 0, 0),
	(105, 119, 138, 0, 0),
	(106, 119, 140, 0, 0),
	(107, 120, 139, 0, 0),
	(108, 125, 144, 0, 0),
	(109, 126, 146, 0, 0),
	(110, 127, 143, 0, 0),
	(111, 130, 145, 0, 0),
	(112, 135, 142, 0, 0),
	(113, 138, 143, 0, 0),
	(114, 138, 138, 0, 0),
	(115, 138, 139, 0, 0),
	(116, 142, 139, 0, 0),
	(117, 143, 136, 0, 0),
	(127, 148, 137, 0, 0),
	(128, 148, 139, 0, 0),
	(129, 149, 137, 0, 0),
	(130, 149, 139, 0, 0),
	(131, 151, 147, 0, 0),
	(132, 155, 147, 0, 0),
	(133, 156, 145, 0, 0),
	(134, 156, 5, 0, 0),
	(135, 157, 5, 0, 0),
	(136, 158, 5, 0, 0),
	(137, 158, 137, 0, 0),
	(139, 159, 5, 0, 0),
	(140, 159, 140, 0, 0),
	(141, 0, 0, 6, 2),
	(142, 0, 0, 10, 2),
	(143, 160, 131, 19, 2),
	(144, 0, 160, 5, 2),
	(145, 160, 5, 0, 2),
	(164, 169, 5, 0, 0),
	(165, 169, 137, 0, 0),
	(166, 170, 5, 14, 2),
	(167, 170, 137, 19, 3),
	(168, 170, 147, 12, 2),
	(169, 0, 0, 0, 0),
	(170, 0, 0, 0, 0),
	(171, 0, 0, 5, 0),
	(172, 171, 143, 0, 0),
	(173, 173, 5, 0, 0),
	(174, 0, 0, 4, 0),
	(175, 0, 0, 4, 3),
	(176, 174, 5, 3, 2),
	(177, 174, 139, 3, 2),
	(178, 174, 146, 3, 2),
	(179, 0, 127, 0, 0),
	(180, 175, 5, 16, 3),
	(181, 175, 137, 0, 0),
	(184, 160, 129, 1, 1),
	(185, 160, 128, 1, 1),
	(187, 176, 5, 18, 2),
	(188, 176, 137, 3, 2),
	(189, 160, 5, 1, 0),
	(190, 177, 5, 18, 2),
	(191, 177, 137, 20, 2),
	(192, 177, 147, 14, 2),
	(193, 178, 147, 16, 2),
	(194, 179, 143, 3, 2),
	(195, 179, 144, NULL, NULL),
	(196, 180, 5, 3, 2),
	(197, 180, 137, NULL, NULL);

-- Dump della struttura di tabella trfcmcauthorized.trfsteps
CREATE TABLE IF NOT EXISTS `trfsteps` (
  `idtrfsteps` int(11) NOT NULL AUTO_INCREMENT,
  `descriptionsteps` varchar(100) NOT NULL DEFAULT '0',
  `codesteps` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`idtrfsteps`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.trfsteps: ~8 rows (circa)
INSERT INTO `trfsteps` (`idtrfsteps`, `descriptionsteps`, `codesteps`) VALUES
	(1, 'certificazione', 1),
	(2, 'descrizione', 2),
	(3, 'standard', 3),
	(4, 'additionalinfo', 4),
	(5, 'addrequirements', 5),
	(6, 'chemicalagent', 6),
	(7, 'identificationparts', 7),
	(8, 'adddocument', 8),
	(9, 'samplestore', 9);

-- Dump della struttura di tabella trfcmcauthorized.wheretrfstep
CREATE TABLE IF NOT EXISTS `wheretrfstep` (
  `idwheretrfstep` int(11) NOT NULL AUTO_INCREMENT,
  `idtrf` int(11) NOT NULL,
  `code` int(11) NOT NULL,
  PRIMARY KEY (`idwheretrfstep`)
) ENGINE=InnoDB AUTO_INCREMENT=976 DEFAULT CHARSET=utf8mb4;

-- Dump dei dati della tabella trfcmcauthorized.wheretrfstep: ~767 rows (circa)
INSERT INTO `wheretrfstep` (`idwheretrfstep`, `idtrf`, `code`) VALUES
	(2, 57, 1),
	(3, 57, 2),
	(4, 58, 1),
	(5, 58, 2),
	(6, 58, 3),
	(9, 58, 4),
	(12, 58, 5),
	(13, 58, 6),
	(15, 58, 7),
	(16, 58, 7),
	(17, 58, 7),
	(18, 58, 7),
	(19, 58, 7),
	(20, 58, 7),
	(21, 58, 7),
	(22, 58, 7),
	(23, 58, 7),
	(24, 58, 7),
	(25, 58, 7),
	(26, 58, 7),
	(27, 58, 7),
	(28, 58, 7),
	(29, 58, 7),
	(30, 58, 7),
	(31, 58, 7),
	(32, 58, 7),
	(33, 58, 7),
	(34, 59, 1),
	(35, 60, 1),
	(36, 60, 2),
	(37, 60, 2),
	(38, 60, 3),
	(39, 60, 3),
	(40, 60, 3),
	(41, 60, 4),
	(42, 60, 4),
	(43, 60, 5),
	(44, 60, 5),
	(45, 60, 6),
	(46, 60, 6),
	(47, 60, 7),
	(48, 60, 7),
	(49, 60, 7),
	(50, 61, 1),
	(51, 61, 2),
	(52, 61, 3),
	(53, 61, 3),
	(54, 61, 3),
	(55, 61, 3),
	(56, 61, 3),
	(57, 61, 3),
	(58, 61, 3),
	(59, 61, 3),
	(60, 61, 3),
	(61, 61, 3),
	(62, 61, 3),
	(63, 62, 1),
	(64, 62, 2),
	(65, 62, 2),
	(66, 63, 1),
	(67, 63, 2),
	(68, 63, 3),
	(69, 63, 2),
	(70, 63, 3),
	(71, 63, 4),
	(72, 63, 5),
	(73, 63, 5),
	(74, 63, 6),
	(75, 63, 6),
	(76, 63, 6),
	(77, 64, 1),
	(78, 64, 2),
	(79, 64, 2),
	(80, 64, 2),
	(81, 65, 1),
	(82, 65, 2),
	(83, 65, 3),
	(84, 65, 4),
	(85, 65, 4),
	(86, 65, 3),
	(87, 65, 3),
	(88, 65, 3),
	(89, 65, 3),
	(90, 65, 3),
	(91, 65, 4),
	(92, 65, 4),
	(93, 65, 5),
	(94, 65, 5),
	(95, 65, 5),
	(96, 65, 6),
	(97, 65, 6),
	(98, 65, 6),
	(99, 65, 6),
	(100, 65, 6),
	(101, 65, 6),
	(102, 65, 6),
	(103, 65, 6),
	(104, 65, 6),
	(105, 65, 6),
	(106, 65, 6),
	(107, 65, 6),
	(108, 65, 6),
	(109, 65, 6),
	(110, 65, 6),
	(111, 65, 6),
	(112, 65, 6),
	(113, 65, 6),
	(114, 65, 6),
	(115, 66, 1),
	(116, 67, 1),
	(117, 68, 1),
	(118, 69, 1),
	(119, 70, 1),
	(120, 71, 1),
	(121, 72, 1),
	(122, 73, 1),
	(123, 74, 1),
	(124, 75, 1),
	(125, 76, 1),
	(126, 77, 1),
	(127, 77, 2),
	(128, 77, 2),
	(129, 77, 3),
	(130, 77, 4),
	(131, 77, 5),
	(132, 77, 5),
	(133, 77, 6),
	(134, 77, 7),
	(135, 77, 7),
	(136, 77, 7),
	(137, 77, 7),
	(138, 77, 7),
	(139, 77, 7),
	(140, 77, 7),
	(141, 77, 7),
	(142, 77, 7),
	(143, 77, 7),
	(144, 77, 7),
	(145, 77, 7),
	(146, 77, 6),
	(147, 77, 5),
	(148, 77, 3),
	(149, 77, 2),
	(150, 78, 1),
	(151, 79, 1),
	(152, 80, 1),
	(153, 80, 2),
	(154, 81, 1),
	(155, 81, 2),
	(156, 81, 3),
	(157, 81, 4),
	(158, 81, 5),
	(159, 81, 5),
	(160, 81, 5),
	(161, 81, 5),
	(162, 81, 5),
	(163, 81, 6),
	(164, 82, 1),
	(165, 83, 1),
	(166, 84, 1),
	(167, 84, 2),
	(168, 84, 3),
	(169, 84, 4),
	(170, 84, 5),
	(171, 84, 5),
	(172, 84, 6),
	(173, 84, 6),
	(174, 84, 6),
	(175, 84, 7),
	(176, 84, 6),
	(177, 84, 5),
	(178, 84, 5),
	(179, 84, 6),
	(180, 84, 7),
	(181, 84, 7),
	(182, 84, 8),
	(183, 84, 7),
	(184, 84, 7),
	(185, 84, 8),
	(186, 84, 8),
	(187, 84, 8),
	(188, 84, 8),
	(189, 84, 8),
	(190, 84, 8),
	(191, 84, 8),
	(192, 84, 8),
	(193, 84, 8),
	(194, 84, 8),
	(195, 84, 8),
	(196, 84, 8),
	(197, 84, 8),
	(198, 84, 8),
	(199, 85, 1),
	(200, 85, 2),
	(201, 85, 2),
	(202, 85, 3),
	(203, 85, 3),
	(204, 85, 3),
	(205, 85, 2),
	(206, 85, 2),
	(207, 85, 3),
	(208, 85, 2),
	(209, 85, 2),
	(210, 85, 2),
	(211, 85, 3),
	(212, 85, 2),
	(213, 85, 2),
	(214, 85, 3),
	(215, 85, 2),
	(216, 85, 3),
	(217, 85, 2),
	(218, 86, 1),
	(219, 86, 2),
	(220, 86, 3),
	(221, 86, 4),
	(222, 86, 3),
	(223, 86, 2),
	(224, 86, 2),
	(225, 86, 3),
	(226, 86, 4),
	(227, 86, 6),
	(228, 86, 3),
	(229, 87, 1),
	(230, 87, 2),
	(231, 87, 6),
	(232, 87, 7),
	(233, 87, 8),
	(234, 87, 8),
	(235, 87, 8),
	(236, 87, 8),
	(237, 87, 8),
	(238, 87, 8),
	(239, 87, 8),
	(240, 87, 8),
	(241, 87, 8),
	(242, 87, 8),
	(243, 87, 8),
	(244, 87, 8),
	(245, 87, 8),
	(246, 87, 8),
	(247, 87, 8),
	(248, 87, 8),
	(249, 87, 8),
	(250, 87, 8),
	(251, 87, 8),
	(252, 87, 8),
	(253, 87, 8),
	(254, 87, 8),
	(255, 87, 8),
	(256, 87, 8),
	(257, 87, 8),
	(258, 87, 8),
	(259, 87, 8),
	(260, 87, 8),
	(261, 87, 8),
	(262, 87, 8),
	(263, 87, 8),
	(264, 87, 8),
	(265, 87, 8),
	(266, 87, 8),
	(267, 87, 8),
	(268, 87, 8),
	(269, 87, 8),
	(270, 87, 8),
	(271, 87, 8),
	(272, 88, 1),
	(273, 88, 2),
	(274, 88, 3),
	(275, 88, 4),
	(276, 88, 5),
	(277, 88, 5),
	(278, 88, 6),
	(279, 88, 7),
	(280, 88, 8),
	(281, 88, 8),
	(282, 88, 8),
	(283, 88, 8),
	(284, 88, 8),
	(285, 88, 8),
	(286, 88, 8),
	(287, 88, 8),
	(288, 89, 1),
	(289, 89, 2),
	(290, 89, 3),
	(291, 89, 4),
	(292, 89, 5),
	(293, 89, 5),
	(294, 89, 6),
	(295, 89, 7),
	(296, 89, 8),
	(297, 89, 8),
	(298, 89, 8),
	(299, 89, 8),
	(300, 89, 8),
	(301, 89, 8),
	(302, 89, 8),
	(303, 89, 8),
	(304, 89, 8),
	(305, 89, 8),
	(306, 89, 8),
	(307, 89, 8),
	(308, 89, 8),
	(309, 89, 8),
	(310, 89, 8),
	(311, 89, 8),
	(312, 89, 8),
	(313, 89, 8),
	(314, 89, 8),
	(315, 89, 8),
	(316, 89, 8),
	(317, 90, 1),
	(318, 90, 2),
	(319, 90, 3),
	(320, 90, 4),
	(321, 90, 6),
	(322, 90, 7),
	(323, 90, 8),
	(324, 90, 8),
	(325, 90, 8),
	(326, 90, 8),
	(327, 90, 8),
	(328, 90, 8),
	(329, 90, 8),
	(330, 90, 8),
	(331, 90, 8),
	(332, 90, 8),
	(333, 90, 8),
	(334, 90, 8),
	(335, 90, 8),
	(336, 91, 1),
	(337, 91, 2),
	(338, 91, 3),
	(339, 91, 4),
	(340, 91, 6),
	(341, 91, 6),
	(342, 91, 6),
	(343, 91, 6),
	(344, 91, 6),
	(345, 91, 6),
	(346, 91, 6),
	(347, 91, 6),
	(348, 91, 6),
	(349, 91, 6),
	(350, 91, 6),
	(351, 91, 6),
	(352, 91, 6),
	(353, 91, 6),
	(354, 91, 6),
	(355, 91, 7),
	(356, 91, 7),
	(357, 92, 1),
	(358, 92, 2),
	(359, 92, 2),
	(360, 92, 2),
	(361, 92, 2),
	(362, 92, 2),
	(363, 92, 2),
	(364, 92, 2),
	(365, 92, 2),
	(366, 92, 6),
	(367, 92, 7),
	(368, 92, 8),
	(369, 92, 8),
	(370, 93, 1),
	(371, 93, 2),
	(372, 93, 3),
	(373, 93, 4),
	(374, 93, 6),
	(375, 93, 6),
	(376, 93, 6),
	(377, 93, 6),
	(378, 93, 6),
	(379, 93, 6),
	(380, 93, 6),
	(381, 93, 6),
	(382, 93, 6),
	(383, 93, 6),
	(384, 93, 6),
	(385, 93, 6),
	(386, 93, 6),
	(387, 93, 6),
	(388, 93, 6),
	(389, 93, 6),
	(390, 93, 6),
	(391, 93, 6),
	(392, 93, 6),
	(393, 93, 6),
	(394, 93, 6),
	(395, 93, 6),
	(396, 93, 6),
	(397, 93, 6),
	(398, 93, 6),
	(399, 93, 6),
	(400, 93, 6),
	(401, 93, 6),
	(402, 93, 6),
	(403, 93, 6),
	(404, 93, 6),
	(405, 93, 6),
	(406, 93, 6),
	(407, 94, 1),
	(408, 94, 2),
	(409, 94, 3),
	(410, 94, 4),
	(411, 94, 6),
	(412, 94, 6),
	(413, 94, 6),
	(414, 95, 1),
	(415, 95, 2),
	(416, 95, 2),
	(417, 95, 3),
	(418, 95, 3),
	(419, 95, 4),
	(420, 95, 4),
	(421, 95, 6),
	(422, 95, 6),
	(423, 95, 7),
	(424, 95, 8),
	(425, 95, 7),
	(426, 95, 6),
	(427, 95, 3),
	(428, 95, 2),
	(429, 95, 2),
	(430, 95, 2),
	(431, 95, 2),
	(432, 95, 2),
	(433, 95, 2),
	(434, 95, 2),
	(435, 95, 2),
	(436, 95, 3),
	(437, 95, 4),
	(438, 95, 6),
	(439, 95, 7),
	(440, 95, 8),
	(441, 95, 8),
	(442, 95, 8),
	(443, 95, 8),
	(444, 95, 8),
	(445, 96, 1),
	(446, 97, 1),
	(447, 98, 1),
	(448, 98, 2),
	(449, 98, 3),
	(450, 98, 4),
	(451, 98, 6),
	(452, 98, 7),
	(453, 98, 8),
	(454, 98, 8),
	(455, 98, 7),
	(456, 99, 1),
	(457, 100, 1),
	(458, 101, 1),
	(459, 102, 1),
	(460, 102, 2),
	(461, 102, 3),
	(462, 102, 4),
	(463, 102, 5),
	(464, 102, 6),
	(465, 102, 7),
	(466, 102, 8),
	(467, 102, 8),
	(468, 102, 7),
	(469, 102, 6),
	(470, 102, 5),
	(471, 102, 6),
	(472, 102, 6),
	(473, 102, 5),
	(474, 102, 6),
	(475, 102, 5),
	(476, 102, 5),
	(477, 102, 6),
	(478, 102, 6),
	(479, 103, 1),
	(480, 103, 2),
	(481, 104, 1),
	(482, 105, 1),
	(483, 105, 2),
	(484, 105, 3),
	(485, 105, 4),
	(486, 105, 6),
	(487, 105, 7),
	(488, 105, 8),
	(489, 106, 1),
	(490, 106, 2),
	(491, 106, 3),
	(492, 106, 4),
	(493, 106, 5),
	(494, 106, 6),
	(495, 106, 7),
	(496, 106, 8),
	(497, 106, 8),
	(498, 106, 2),
	(499, 106, 3),
	(500, 106, 4),
	(501, 106, 5),
	(502, 106, 6),
	(503, 106, 7),
	(504, 106, 8),
	(505, 106, 7),
	(506, 107, 1),
	(507, 108, 1),
	(508, 108, 2),
	(509, 108, 3),
	(510, 108, 4),
	(511, 108, 6),
	(512, 108, 7),
	(513, 108, 8),
	(514, 108, 7),
	(515, 108, 8),
	(516, 108, 8),
	(517, 108, 8),
	(518, 109, 1),
	(519, 110, 1),
	(520, 110, 2),
	(521, 111, 1),
	(522, 112, 1),
	(523, 113, 1),
	(524, 113, 2),
	(525, 113, 3),
	(526, 113, 4),
	(527, 113, 6),
	(528, 113, 7),
	(529, 113, 8),
	(530, 114, 1),
	(531, 115, 1),
	(532, 116, 1),
	(533, 117, 1),
	(534, 117, 2),
	(535, 117, 2),
	(536, 118, 1),
	(537, 118, 2),
	(538, 118, 3),
	(539, 119, 1),
	(540, 119, 2),
	(541, 119, 3),
	(542, 119, 4),
	(543, 119, 5),
	(544, 120, 1),
	(545, 120, 2),
	(546, 120, 3),
	(547, 120, 4),
	(548, 120, 5),
	(549, 120, 6),
	(550, 121, 1),
	(551, 121, 2),
	(552, 121, 2),
	(553, 121, 2),
	(554, 122, 1),
	(555, 122, 8),
	(556, 122, 8),
	(557, 123, 1),
	(558, 123, 2),
	(559, 123, 2),
	(560, 124, 1),
	(561, 125, 1),
	(562, 125, 2),
	(563, 125, 2),
	(564, 126, 1),
	(565, 126, 2),
	(566, 126, 3),
	(567, 126, 4),
	(568, 126, 3),
	(569, 126, 3),
	(570, 126, 3),
	(571, 126, 4),
	(572, 126, 3),
	(573, 126, 3),
	(574, 126, 4),
	(575, 127, 1),
	(576, 127, 2),
	(577, 127, 3),
	(578, 127, 4),
	(579, 127, 6),
	(580, 127, 6),
	(581, 128, 1),
	(582, 129, 1),
	(583, 130, 1),
	(584, 130, 2),
	(585, 130, 3),
	(586, 130, 4),
	(587, 130, 6),
	(588, 130, 7),
	(589, 130, 8),
	(590, 130, 7),
	(591, 130, 6),
	(592, 130, 3),
	(593, 130, 2),
	(594, 130, 3),
	(595, 130, 4),
	(596, 130, 6),
	(597, 130, 7),
	(598, 130, 6),
	(599, 130, 3),
	(600, 131, 1),
	(601, 132, 1),
	(602, 133, 1),
	(603, 134, 1),
	(604, 135, 1),
	(605, 135, 2),
	(606, 135, 2),
	(607, 135, 2),
	(608, 135, 2),
	(609, 135, 2),
	(610, 135, 3),
	(611, 135, 3),
	(612, 135, 4),
	(613, 135, 4),
	(614, 135, 6),
	(615, 135, 6),
	(616, 135, 7),
	(617, 135, 7),
	(618, 135, 8),
	(619, 135, 8),
	(620, 135, 8),
	(621, 135, 7),
	(622, 135, 6),
	(623, 135, 3),
	(624, 135, 4),
	(625, 135, 6),
	(626, 135, 7),
	(627, 136, 1),
	(628, 137, 1),
	(629, 138, 1),
	(630, 138, 2),
	(631, 138, 3),
	(632, 138, 4),
	(633, 138, 6),
	(634, 138, 3),
	(635, 138, 2),
	(636, 138, 3),
	(637, 138, 4),
	(638, 138, 6),
	(639, 138, 3),
	(640, 138, 2),
	(641, 138, 3),
	(642, 138, 4),
	(643, 138, 5),
	(644, 138, 5),
	(645, 138, 6),
	(646, 139, 1),
	(647, 139, 2),
	(648, 139, 3),
	(649, 139, 4),
	(650, 139, 6),
	(651, 140, 1),
	(652, 140, 2),
	(653, 140, 3),
	(654, 140, 4),
	(655, 140, 6),
	(656, 141, 1),
	(657, 141, 2),
	(658, 142, 1),
	(659, 142, 2),
	(660, 142, 3),
	(661, 142, 4),
	(662, 142, 5),
	(663, 142, 6),
	(664, 142, 7),
	(665, 142, 8),
	(666, 142, 2),
	(667, 142, 2),
	(668, 143, 1),
	(669, 143, 2),
	(670, 143, 3),
	(671, 143, 3),
	(672, 143, 3),
	(673, 144, 1),
	(674, 144, 2),
	(675, 144, 3),
	(676, 145, 1),
	(677, 145, 2),
	(678, 145, 3),
	(679, 145, 3),
	(680, 145, 4),
	(681, 145, 4),
	(682, 145, 5),
	(683, 145, 6),
	(684, 145, 7),
	(685, 145, 7),
	(686, 146, 1),
	(687, 146, 2),
	(688, 146, 3),
	(689, 146, 3),
	(690, 146, 4),
	(691, 146, 5),
	(692, 146, 7),
	(693, 146, 5),
	(694, 146, 7),
	(695, 146, 8),
	(696, 147, 1),
	(697, 147, 2),
	(698, 147, 3),
	(699, 147, 4),
	(700, 147, 4),
	(701, 147, 4),
	(702, 147, 4),
	(703, 147, 4),
	(704, 147, 4),
	(705, 147, 4),
	(706, 147, 4),
	(707, 147, 4),
	(708, 147, 4),
	(709, 147, 5),
	(710, 147, 5),
	(711, 147, 4),
	(712, 147, 5),
	(713, 148, 1),
	(714, 148, 2),
	(715, 148, 3),
	(716, 148, 4),
	(717, 148, 5),
	(718, 148, 5),
	(719, 148, 4),
	(720, 148, 5),
	(721, 148, 5),
	(722, 148, 4),
	(723, 148, 5),
	(724, 148, 5),
	(725, 148, 4),
	(726, 148, 5),
	(727, 148, 7),
	(728, 148, 4),
	(729, 148, 5),
	(730, 148, 5),
	(731, 148, 5),
	(732, 148, 5),
	(733, 148, 5),
	(734, 148, 7),
	(735, 148, 8),
	(736, 148, 5),
	(737, 148, 3),
	(738, 148, 4),
	(739, 148, 5),
	(740, 148, 4),
	(741, 148, 5),
	(742, 148, 5),
	(743, 148, 6),
	(744, 148, 6),
	(745, 149, 1),
	(746, 149, 2),
	(747, 149, 3),
	(748, 149, 3),
	(749, 149, 3),
	(750, 149, 3),
	(751, 149, 3),
	(752, 149, 3),
	(753, 149, 3),
	(754, 149, 3),
	(755, 149, 3),
	(756, 149, 4),
	(757, 149, 4),
	(758, 149, 4),
	(759, 149, 4),
	(760, 149, 4),
	(761, 149, 3),
	(762, 149, 4),
	(763, 149, 3),
	(764, 149, 3),
	(765, 149, 3),
	(766, 149, 3),
	(767, 149, 4),
	(768, 149, 3),
	(769, 149, 4),
	(770, 149, 4),
	(771, 149, 3),
	(772, 149, 4),
	(773, 149, 4),
	(774, 149, 4),
	(775, 149, 3),
	(776, 149, 4),
	(777, 149, 4),
	(778, 149, 5),
	(779, 149, 5),
	(780, 149, 4),
	(781, 149, 5),
	(782, 149, 6),
	(783, 149, 6),
	(784, 149, 6),
	(785, 149, 6),
	(786, 149, 4),
	(787, 149, 5),
	(788, 149, 4),
	(789, 149, 5),
	(790, 149, 6),
	(791, 149, 6),
	(792, 149, 6),
	(793, 149, 7),
	(794, 149, 7),
	(795, 149, 6),
	(796, 149, 7),
	(797, 149, 8),
	(798, 149, 8),
	(799, 149, 7),
	(800, 150, 1),
	(801, 150, 2),
	(802, 150, 3),
	(803, 150, 4),
	(804, 150, 5),
	(805, 150, 7),
	(806, 151, 1),
	(807, 151, 2),
	(808, 151, 3),
	(809, 151, 4),
	(810, 151, 5),
	(811, 151, 7),
	(812, 151, 8),
	(813, 151, 8),
	(814, 151, 8),
	(815, 151, 8),
	(816, 151, 8),
	(817, 151, 8),
	(818, 151, 8),
	(819, 151, 8),
	(820, 151, 8),
	(821, 151, 8),
	(822, 151, 8),
	(823, 151, 8),
	(824, 151, 8),
	(825, 152, 1),
	(826, 152, 2),
	(827, 152, 3),
	(828, 152, 3),
	(829, 153, 1),
	(830, 153, 2),
	(831, 154, 1),
	(832, 154, 2),
	(833, 154, 3),
	(834, 154, 3),
	(835, 154, 3),
	(836, 154, 3),
	(837, 155, 1),
	(838, 155, 2),
	(839, 155, 3),
	(840, 156, 1),
	(841, 156, 2),
	(842, 156, 3),
	(843, 157, 1),
	(844, 157, 2),
	(845, 157, 3),
	(846, 158, 1),
	(847, 158, 2),
	(848, 158, 3),
	(849, 159, 1),
	(850, 159, 2),
	(851, 159, 3),
	(852, 160, 1),
	(853, 160, 2),
	(854, 160, 3),
	(855, 160, 3),
	(856, 161, 1),
	(857, 161, 2),
	(858, 161, 3),
	(859, 161, 7),
	(860, 161, 7),
	(861, 161, 7),
	(862, 162, 1),
	(863, 162, 2),
	(864, 162, 3),
	(865, 163, 1),
	(866, 163, 2),
	(867, 163, 3),
	(868, 163, 3),
	(869, 163, 3),
	(870, 163, 4),
	(871, 163, 5),
	(872, 163, 7),
	(873, 163, 8),
	(874, 163, 8),
	(875, 164, 1),
	(876, 164, 2),
	(877, 164, 3),
	(878, 164, 4),
	(879, 164, 5),
	(880, 164, 7),
	(881, 165, 1),
	(882, 165, 2),
	(883, 165, 3),
	(884, 165, 4),
	(885, 165, 5),
	(886, 165, 7),
	(887, 165, 7),
	(888, 165, 7),
	(889, 165, 7),
	(890, 165, 7),
	(891, 165, 7),
	(892, 165, 7),
	(893, 165, 7),
	(894, 165, 7),
	(895, 165, 7),
	(896, 165, 7),
	(897, 165, 7),
	(898, 165, 7),
	(899, 165, 7),
	(900, 165, 7),
	(901, 165, 7),
	(902, 165, 7),
	(903, 165, 7),
	(904, 165, 7),
	(905, 165, 7),
	(906, 165, 7),
	(907, 165, 7),
	(908, 165, 7),
	(909, 166, 1),
	(910, 166, 2),
	(911, 166, 3),
	(912, 166, 4),
	(913, 166, 5),
	(914, 166, 7),
	(915, 166, 7),
	(916, 167, 1),
	(917, 167, 2),
	(918, 168, 1),
	(919, 168, 2),
	(920, 168, 3),
	(921, 168, 3),
	(922, 169, 1),
	(923, 169, 2),
	(924, 169, 3),
	(925, 170, 1),
	(926, 170, 2),
	(927, 170, 3),
	(928, 171, 1),
	(929, 171, 2),
	(930, 171, 3),
	(931, 171, 4),
	(932, 171, 5),
	(933, 171, 7),
	(934, 171, 8),
	(935, 171, 8),
	(936, 172, 1),
	(937, 172, 2),
	(938, 173, 1),
	(939, 173, 2),
	(940, 173, 3),
	(941, 173, 4),
	(942, 173, 5),
	(943, 173, 4),
	(944, 173, 5),
	(945, 173, 6),
	(946, 173, 7),
	(947, 174, 1),
	(948, 174, 2),
	(949, 174, 3),
	(950, 175, 1),
	(951, 175, 2),
	(952, 175, 3),
	(953, 176, 1),
	(954, 176, 2),
	(955, 176, 3),
	(956, 177, 1),
	(957, 177, 2),
	(958, 177, 3),
	(959, 177, 4),
	(960, 178, 1),
	(961, 178, 2),
	(962, 178, 3),
	(963, 178, 3),
	(964, 179, 1),
	(965, 179, 2),
	(966, 179, 3),
	(967, 180, 1),
	(968, 180, 2),
	(969, 180, 3),
	(970, 181, 1),
	(971, 181, 2),
	(972, 181, 3),
	(973, 181, 3),
	(974, 181, 3),
	(975, 181, 3);

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;