dbtest.sql

DROP TABLE IF EXISTS `Users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `Users` (
  `id` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `Users` WRITE;
/*!40000 ALTER TABLE `Users` DISABLE KEYS */;
INSERT INTO `Users` VALUES
('viktor');
/*!40000 ALTER TABLE `Users` ENABLE KEYS */;
UNLOCK TABLES;

DROP TABLE IF EXISTS `Countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `Countries` (
  `id` varchar(2) NOT NULL,
  `name_rus` varchar(100) NOT NULL,
  `name_eng` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_name_rus` (`name_rus`),
  UNIQUE KEY `u_name_eng` (`name_eng`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `Countries` WRITE;
/*!40000 ALTER TABLE `Countries` DISABLE KEYS */;
INSERT INTO `Countries` VALUES
('AB','Абхазия','Abkhazia'),
('AD','Андорра','Andorra'),
('AE','Объединённые Арабские Эмираты','United Arab Emirates'),
('AF','Афганистан','Afghanistan'),
('AG','Антигуа и Барбуда','Antigua and Barbuda'),
('AI','Ангилья','Anguilla'),
('AL','Албания','Albania'),
('AM','Армения','Armenia'),
('AO','Ангола','Angola'),
('AQ','Антарктида','Antarctica'),
('AR','Аргентина','Argentina'),
('AS','Американское Самоа','American Samoa'),
('AT','Австрия','Austria'),
('AU','Австралия','Australia'),
('AW','Аруба','Aruba'),
('AX','Аландские Острова','Åland Islands'),
('AZ','Азербайджан','Azerbaijan'),
('BA','Босния и Герцеговина','Bosnia and Herzegovina'),
('BB','Барбадос','Barbados'),
('BD','Бангладеш','Bangladesh'),
('BE','Бельгия','Belgium'),
('BF','Буркина-Фасо','Burkina Faso'),
('BG','Болгария','Bulgaria'),
('BH','Бахрейн','Bahrain'),
('BI','Бурунди','Burundi'),
('BJ','Бенин','Benin'),
('BL','Сен-Бартелеми','Saint Barthélemy'),
('BM','Бермуды','Bermuda'),
('BN','Бруней','Brunei'),
('BO','Боливия','Bolivia'),
('BQ','Бонэйр','Bonaire'),
('BR','Бразилия','Brazil'),
('BS','Багамы','Bahamas'),
('BT','Бутан','Bhutan'),
('BV','Остров Буве','Bouvet Island'),
('BW','Ботсвана','Botswana'),
('BY','Беларусь','Belarus'),
('BZ','Белиз','Belize'),
('CA','Канада','Canada'),
('CC','Кокосовые Острова','Cocos Islands'),
('CD','Демократическая Республика Конго','Congo, the Democratic Republic of the'),
('CF','Центральноафриканская Республика','Central African Republic'),
('CG','Конго','Congo'),
('CH','Швейцария','Switzerland'),
('CI','Кот Д\'ивуар','Côte d\'Ivoire'),
('CK','Острова Кука','Cook Islands'),
('CL','Чили','Chile'),
('CM','Камерун','Cameroon'),
('CN','Китай','China'),
('CO','Колумбия','Colombia'),
('CR','Коста-Рика','Costa Rica'),
('CU','Куба','Cuba'),
('CV','Кабо-Верде','Cape Verde'),
('CW','Кюрасао','Curaçao'),
('CX','Остров Рождества','Christmas Island'),
('CY','Кипр','Cyprus'),
('CZ','Чехия','Czech Republic'),
('DE','Германия','Germany'),
('DJ','Джибути','Djibouti'),
('DK','Дания','Denmark'),
('DM','Доминика','Dominica'),
('DO','Доминиканская Республика','Dominican Republic'),
('DZ','Алжир','Algeria'),
('EC','Эквадор','Ecuador'),
('EE','Эстония','Estonia'),
('EG','Египет','Egypt'),
('EH','Западная Сахара','Western Sahara'),
('ER','Эритрея','Eritrea'),
('ES','Испания','Spain'),
('ET','Эфиопия','Ethiopia'),
('EU','Европейский Союз','European Union'),
('FI','Финляндия','Finland'),
('FJ','Фиджи','Fiji'),
('FK','Фолклендские Острова','Falkland Islands'),
('FM','Микронезия','Micronesia'),
('FO','Фарерские Острова','Faroe Islands'),
('FR','Франция','France'),
('GA','Габон','Gabon'),
('GB','Соединённое Королевство','United Kingdom'),
('GD','Гренада','Grenada'),
('GE','Грузия','Georgia'),
('GF','Французская Гвиана','French Guiana'),
('GG','Гернси','Guernsey'),
('GH','Гана','Ghana'),
('GI','Гибралтар','Gibraltar'),
('GL','Гренландия','Greenland'),
('GM','Гамбия','Gambia'),
('GN','Гвинея','Guinea'),
('GP','Гваделупа','Guadeloupe'),
('GQ','Экваториальная Гвинея','Equatorial Guinea'),
('GR','Греция','Greece'),
('GS','Южная Георгия и Южные Сандвичевы Острова','South Georgia and the South Sandwich Islands'),
('GT','Гватемала','Guatemala'),
('GU','Гуам','Guam'),
('GW','Гвинея-Бисау','Guinea-Bissau'),
('GY','Гайана','Guyana'),
('HK','Гонконг','Hong Kong'),
('HM','Остров Херд и острова Макдональд','Heard Island and McDonald Islands'),
('HN','Гондурас','Honduras'),
('HR','Хорватия','Croatia'),
('HT','Гаити','Haiti'),
('HU','Венгрия','Hungary'),
('ID','Индонезия','Indonesia'),
('IE','Ирландия','Ireland'),
('IL','Израиль','Israel'),
('IM','Остров Мэн','Isle of Man'),
('IN','Индия','India'),
('IO','Британская Территория в Индийском Океане','British Indian Ocean Territory'),
('IQ','Ирак','Iraq'),
('IR','Иран','Iran'),
('IS','Исландия','Iceland'),
('IT','Италия','Italy'),
('JE','Джерси','Jersey'),
('JM','Ямайка','Jamaica'),
('JO','Иордания','Jordan'),
('JP','Япония','Japan'),
('KE','Кения','Kenya'),
('KG','Кыргызстан','Kyrgyzstan'),
('KH','Камбоджа','Cambodia'),
('KI','Кирибати','Kiribati'),
('KM','Коморские Острова','Comoros'),
('KN','Сент-Китс и Невис','Saint Kitts and Nevis'),
('KP','Корейская Народно-Демократическая Республика','Korea, Democratic People\'s Republic of'),
('KR','Корея','Korea'),
('KW','Кувейт','Kuwait'),
('KY','Острова Кайман','Cayman Islands'),
('KZ','Казахстан','Kazakhstan'),
('LA','Лаосская Народно-Демократическая Республика','Lao People\'s Democratic Republic'),
('LB','Ливан','Lebanon'),
('LC','Сент-Люсия','Saint Lucia'),
('LI','Лихтенштейн','Liechtenstein'),
('LK','Шри-Ланка','Sri Lanka'),
('LR','Либерия','Liberia'),
('LS','Лесото','Lesotho'),
('LT','Литва','Lithuania'),
('LU','Люксембург','Luxembourg'),
('LV','Латвия','Latvia'),
('LY','Ливия','Libya'),
('MA','Марокко','Morocco'),
('MC','Монако','Monaco'),
('MD','Молдова','Moldova'),
('ME','Черногория','Montenegro'),
('MF','Сен-Мартен','Saint Martin'),
('MG','Мадагаскар','Madagascar'),
('MH','Маршалловы Острова','Marshall Islands'),
('MK','Северная Македония','Macedonia'),
('ML','Мали','Mali'),
('MM','Мьянма','Myanmar'),
('MN','Монголия','Mongolia'),
('MO','Макао','Macao'),
('MP','Северные Марианские Острова','Northern Mariana Islands'),
('MQ','Мартиника','Martinique'),
('MR','Мавритания','Mauritania'),
('MS','Монтсеррат','Montserrat'),
('MT','Мальта','Malta'),
('MU','Маврикий','Mauritius'),
('MV','Мальдивы','Maldives'),
('MW','Малави','Malawi'),
('MX','Мексика','Mexico'),
('MY','Малайзия','Malaysia'),
('MZ','Мозамбик','Mozambique'),
('NA','Намибия','Namibia'),
('NC','Новая Каледония','New Caledonia'),
('NE','Нигер','Niger'),
('NF','Остров Норфолк','Norfolk Island'),
('NG','Нигерия','Nigeria'),
('NI','Никарагуа','Nicaragua'),
('NL','Нидерланды','Netherlands'),
('NO','Норвегия','Norway'),
('NP','Непал','Nepal'),
('NR','Науру','Nauru'),
('NU','Ниуэ','Niue'),
('NZ','Новая Зеландия','New Zealand'),
('OM','Оман','Oman'),
('OS','Южная Осетия','South Ossetia'),
('PA','Панама','Panama'),
('PE','Перу','Peru'),
('PF','Французская Полинезия','French Polynesia'),
('PG','Папуа Новая Гвинея','Papua New Guinea'),
('PH','Филиппины','Philippines'),
('PK','Пакистан','Pakistan'),
('PL','Польша','Poland'),
('PM','Сен-Пьер и Микелон','Saint Pierre and Miquelon'),
('PN','Питкерн','Pitcairn'),
('PR','Пуэрто-Рико','Puerto Rico'),
('PS','Палестина','Palestine'),
('PT','Португалия','Portugal'),
('PW','Палау','Palau'),
('PY','Парагвай','Paraguay'),
('QA','Катар','Qatar'),
('RE','Реюньон','Réunion'),
('RO','Румыния','Romania'),
('RS','Сербия','Serbia'),
('RU','Россия','Russian Federation'),
('RW','Руанда','Rwanda'),
('SA','Саудовская Аравия','Saudi Arabia'),
('SB','Соломоновы Острова','Solomon Islands'),
('SC','Сейшелы','Seychelles'),
('SD','Судан','Sudan'),
('SE','Швеция','Sweden'),
('SG','Сингапур','Singapore'),
('SH','Святая Елена','Saint Helena'),
('SI','Словения','Slovenia'),
('SJ','Шпицберген и Ян Майен','Svalbard and Jan Mayen'),
('SK','Словакия','Slovakia'),
('SL','Сьерра-Леоне','Sierra Leone'),
('SM','Сан-Марино','San Marino'),
('SN','Сенегал','Senegal'),
('SO','Сомали','Somalia'),
('SR','Суринам','Suriname'),
('SS','Южный Судан','South Sudan'),
('ST','Сан-Томе и Принсипи','Sao Tome and Principe'),
('SV','Сальвадор','El Salvador'),
('SX','Синт-Мартен','Sint Maarten'),
('SY','Сирийская Арабская Республика','Syrian Arab Republic'),
('SZ','Эсватини','Eswatini'),
('TC','Острова Теркс и Кайкос','Turks and Caicos Islands'),
('TD','Чад','Chad'),
('TF','Французские Южные Территории','French Southern Territories'),
('TG','Того','Togo'),
('TH','Таиланд','Thailand'),
('TJ','Таджикистан','Tajikistan'),
('TK','Токелау','Tokelau'),
('TL','Тимор-Лесте','Timor-Leste'),
('TM','Туркменистан','Turkmenistan'),
('TN','Тунис','Tunisia'),
('TO','Тонга','Tonga'),
('TR','Турция','Turkey'),
('TT','Тринидад и Тобаго','Trinidad and Tobago'),
('TV','Тувалу','Tuvalu'),
('TW','Тайвань','Taiwan'),
('TZ','Танзания','Tanzania'),
('UA','Украина','Ukraine'),
('UG','Уганда','Uganda'),
('UM','Внешние малые острова США','United States Minor Outlying Islands'),
('US','Соединённые Штаты Америки','United States'),
('UY','Уругвай','Uruguay'),
('UZ','Узбекистан','Uzbekistan'),
('VA','Ватикан','Vatican'),
('VC','Сент-Винсент и Гренадины','Saint Vincent and the Grenadines'),
('VE','Венесуэла','Venezuela'),
('VG','Виргинские Острова, Британские','Virgin Islands, British'),
('VI','Виргинские Острова, США','Virgin Islands, U.S.'),
('VN','Вьетнам','Viet Nam'),
('VU','Вануату','Vanuatu'),
('WF','Уоллис и Футуна','Wallis and Futuna'),
('WS','Самоа','Samoa'),
('YE','Йемен','Yemen'),
('YT','Майотта','Mayotte'),
('ZA','Южная Африка','South Africa'),
('ZM','Республика Замбия','Zambia'),
('ZW','Зимбабве','Zimbabwe');
/*!40000 ALTER TABLE `Countries` ENABLE KEYS */;
UNLOCK TABLES;

DROP TABLE IF EXISTS `Manufacturers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `Manufacturers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `country_id` varchar(2) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_manufacturer` (`name`,`country_id`),
  KEY `fk_Manufacturers__country` (`country_id`),
  CONSTRAINT `fk_Manufacturers__country` FOREIGN KEY (`country_id`) REFERENCES `Countries` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `Manufacturers` WRITE;
/*!40000 ALTER TABLE `Manufacturers` DISABLE KEYS */;
INSERT INTO `Manufacturers` VALUES
(8,'MAN1','CH'),
(2,'MAN2','DE'),
(7,'MAN3','DE');
/*!40000 ALTER TABLE `Manufacturers` ENABLE KEYS */;
UNLOCK TABLES;

DROP TABLE IF EXISTS `SuppliesCategories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `SuppliesCategories` (
  `id` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `SuppliesCategories` WRITE;
/*!40000 ALTER TABLE `SuppliesCategories` DISABLE KEYS */;
INSERT INTO `SuppliesCategories` VALUES
('equipment','Lab equipment','Sample description');
/*!40000 ALTER TABLE `SuppliesCategories` ENABLE KEYS */;
UNLOCK TABLES;

DROP TABLE IF EXISTS `Supplies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `Supplies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `category_id` varchar(100) NOT NULL,
  `manufacturer_id` int(10) unsigned DEFAULT NULL,
  `sn` varchar(100) DEFAULT NULL,
  `produced` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_supply` (`name`,`sn`) USING BTREE,
  KEY `fk_Supplies__manufacturer` (`manufacturer_id`),
  KEY `fk_Supplies__category` (`category_id`),
  CONSTRAINT `fk_Supplies__category` FOREIGN KEY (`category_id`) REFERENCES `SuppliesCategories` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_Supplies__manufacturer` FOREIGN KEY (`manufacturer_id`) REFERENCES `Manufacturers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `Supplies` WRITE;
/*!40000 ALTER TABLE `Supplies` DISABLE KEYS */;
INSERT INTO `Supplies` VALUES
(1,'EQ1 TYPE1','desc1','equipment',2,'sn1',NULL),
(2,'EQ5','desc1','equipment',2,'sn2',NULL),
(3,'EQ1 TYPE2','desc2','equipment',2,'sn3',NULL),
(4,'EQ1 TYPE2','desc2','equipment',2,'sn4',NULL),
(5,'EQ3 TYPE1','desc2','equipment',2,'sn5',NULL),
(6,'EQ4 TYPE1','desc3','equipment',2,'sn6050',NULL),
(7,'EQ4 TYPE1','desc3','equipment',2,'sn7',NULL),
(8,'EQ4 TYPE2','desc3','equipment',2,'sn8050',NULL),
(9,'EQ4 TYPE3','desc4','equipment',2,'sn9',NULL),
(10,'EQ3 TYPE2','desc5','equipment',2,'sn10050',NULL),
(11,'EQ4 TYPE4','desc6','equipment',2,'sn11',NULL),
(12,'EQ4 TYPE4','desc6','equipment',2,'sn12',NULL),
(13,'EQ4 TYPE4','desc6','equipment',2,'sn13',NULL),
(14,'EQ3 TYPE3','desc7','equipment',2,'sn14',NULL),
(15,'EQ6','desc6','equipment',7,'sn15',NULL),
(16,'EQ4 TYPE5','desc8','equipment',2,'sn16',NULL),
(17,'EQ4 TYPE5','desc8','equipment',2,'sn17050',NULL),
(18,'EQ4 TYPE6','desc9','equipment',8,'sn18',NULL),
(19,'EQ4 TYPE7','desc10','equipment',8,'sn19',NULL),
(20,'EQ3 TYPE4','desc11','equipment',2,'sn20050',NULL),
(21,'EQ2 TYPE1','desc12','equipment',2,'sn21',NULL),
(22,'EQ2 TYPE1','desc12','equipment',2,'sn22',NULL);
/*!40000 ALTER TABLE `Supplies` ENABLE KEYS */;
UNLOCK TABLES;

DROP TABLE IF EXISTS `MIRegister`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `MIRegister` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `number` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_number` (`number`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `MIRegister` WRITE;
/*!40000 ALTER TABLE `MIRegister` DISABLE KEYS */;
INSERT INTO `MIRegister` VALUES
(1,'CODE1','NAME1','TYPE1'),
(2,'CODE2','NAME2','TYPE2');
/*!40000 ALTER TABLE `MIRegister` ENABLE KEYS */;
UNLOCK TABLES;

DROP TABLE IF EXISTS `Equipment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `Equipment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `type` enum('measuring','testing','auxiliary') NOT NULL,
  `comissioned` date DEFAULT NULL,
  `decomissioned` date DEFAULT NULL,
  `specs` text DEFAULT NULL,
  `responsible_id` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_name` (`name`),
  KEY `fk_Equipment__responsible` (`responsible_id`),
  CONSTRAINT `fk_Equipment__responsible` FOREIGN KEY (`responsible_id`) REFERENCES `Users` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `Equipment` WRITE;
/*!40000 ALTER TABLE `Equipment` DISABLE KEYS */;
INSERT INTO `Equipment` VALUES
(1,'HPLC01','measuring',NULL,NULL,NULL,'viktor'),
(2,'HPLC02','measuring',NULL,NULL,NULL,'viktor'),
(3,'HPLC03','measuring',NULL,NULL,NULL,'viktor'),
(4,'HPLC04','measuring',NULL,NULL,NULL,'viktor'),
(5,'HPLC05','measuring',NULL,NULL,NULL,'viktor'),
(6,'HPLC06','measuring',NULL,NULL,NULL,'viktor'),
(8,'HPLC07','measuring',NULL,NULL,NULL,'viktor');
/*!40000 ALTER TABLE `Equipment` ENABLE KEYS */;
UNLOCK TABLES;

DROP TABLE IF EXISTS `EquipmentVerifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `EquipmentVerifications` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `equipment_id` int(10) unsigned NOT NULL,
  `miregister_id` int(10) unsigned NOT NULL,
  `ts` date NOT NULL,
  `upto` date NOT NULL,
  `organization` varchar(100) NOT NULL,
  `certificate` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_certificate` (`certificate`),
  UNIQUE KEY `u_verification` (`equipment_id`,`ts`) USING BTREE,
  KEY `fk_EquipmentVerification__miregister` (`miregister_id`),
  CONSTRAINT `fk_EquipmentVerification__equipment` FOREIGN KEY (`equipment_id`) REFERENCES `Equipment` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_EquipmentVerification__miregister` FOREIGN KEY (`miregister_id`) REFERENCES `MIRegister` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `EquipmentVerifications` WRITE;
/*!40000 ALTER TABLE `EquipmentVerifications` DISABLE KEYS */;
INSERT INTO `EquipmentVerifications` VALUES
(1,3,2,'2024-08-09','2025-08-08','ORG1','ABC1'),
(2,3,2,'2025-08-06','2026-08-05','ORG1','ABC2'),
(3,2,1,'2019-10-16','2020-10-16','ORG2','BCD1'),
(4,2,1,'2020-11-17','2021-11-16','ORG3','CDE1'),
(5,2,1,'2021-12-10','2022-12-09','ORG1','ABC3'),
(6,2,1,'2022-12-02','2023-12-01','ORG1','ABC4'),
(7,2,1,'2023-12-01','2024-11-30','ORG1','ABC5'),
(8,2,1,'2024-11-29','2025-11-28','ORG1','ABC6'),
(9,4,1,'2025-08-06','2026-08-05','ORG1','ABC7'),
(10,1,1,'2025-08-06','2026-08-05','ORG1','ABC8');
/*!40000 ALTER TABLE `EquipmentVerifications` ENABLE KEYS */;
UNLOCK TABLES;

DROP TABLE IF EXISTS `EquipmentVerifications2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `EquipmentVerifications2` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `equipment_id` int(10) unsigned NOT NULL,
  `miregister_id` int(10) unsigned NOT NULL,
  `ts` int(11) NOT NULL,
  `upto` int(11) NOT NULL,
  `organization` varchar(100) NOT NULL,
  `certificate` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_certificate` (`certificate`),
  UNIQUE KEY `u_verification` (`equipment_id`,`ts`) USING BTREE,
  KEY `fk_EquipmentVerification__miregister2` (`miregister_id`),
  CONSTRAINT `fk_EquipmentVerification__equipment2` FOREIGN KEY (`equipment_id`) REFERENCES `Equipment` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_EquipmentVerification__miregister2` FOREIGN KEY (`miregister_id`) REFERENCES `MIRegister` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `EquipmentVerifications2` WRITE;
/*!40000 ALTER TABLE `EquipmentVerifications2` DISABLE KEYS */;
INSERT INTO `EquipmentVerifications2` VALUES
(1,3,2,1759,2123,'ORG1','ABC1'),
(2,3,2,2121,2485,'ORG1','ABC2'),
(3,2,1,0,366,'ORG2','BCD1'),
(4,2,1,398,762,'ORG3','CDE1'),
(5,2,1,786,1150,'ORG1','ABC3'),
(6,2,1,1143,1507,'ORG1','ABC4'),
(7,2,1,1507,1872,'ORG1','ABC5'),
(8,2,1,1871,2235,'ORG1','ABC6'),
(9,4,1,2121,2485,'ORG1','ABC7'),
(10,1,1,2121,2485,'ORG1','ABC8');
/*!40000 ALTER TABLE `EquipmentVerifications2` ENABLE KEYS */;
UNLOCK TABLES;

DROP TABLE IF EXISTS `Equipment_Supplies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `Equipment_Supplies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `equipment_id` int(10) unsigned NOT NULL,
  `supply_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_equipmentsupply` (`equipment_id`,`supply_id`),
  CONSTRAINT `fk_Equipment_Supplies__equipment` FOREIGN KEY (`equipment_id`) REFERENCES `Equipment` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_Equipment_Supplies__supply` FOREIGN KEY (`supply_id`) REFERENCES `Supplies` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `Equipment_Supplies` WRITE;
/*!40000 ALTER TABLE `Equipment_Supplies` DISABLE KEYS */;
INSERT INTO `Equipment_Supplies` VALUES
(1,1,1),
(5,1,6),
(2,1,11),
(3,1,16),
(4,1,21),
(7,2,3),
(6,2,7),
(9,2,15),
(8,2,18),
(13,3,2),
(10,3,9),
(12,3,12),
(11,3,17),
(14,3,22),
(16,4,4),
(15,4,8),
(17,4,13),
(18,4,19),
(22,5,5),
(19,5,10),
(21,5,14),
(20,5,20);
/*!40000 ALTER TABLE `Equipment_Supplies` ENABLE KEYS */;
UNLOCK TABLES;