-- MySQL dump 10.19  Distrib 10.3.38-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: ais
-- ------------------------------------------------------
-- Server version	10.3.38-MariaDB-0ubuntu0.20.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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 */;

--
-- Table structure for table `xlinks`
--

DROP TABLE IF EXISTS `xlinks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xlinks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `country_id` bigint(20) unsigned DEFAULT NULL,
  `visa_type_id` bigint(20) unsigned DEFAULT NULL,
  `is_resident` tinyint(1) NOT NULL DEFAULT 0,
  `group_size` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `xlinks_country_id_foreign` (`country_id`),
  KEY `xlinks_visa_type_id_foreign` (`visa_type_id`),
  CONSTRAINT `xlinks_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL,
  CONSTRAINT `xlinks_visa_type_id_foreign` FOREIGN KEY (`visa_type_id`) REFERENCES `visa_types` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xlinks`
--

LOCK TABLES `xlinks` WRITE;
/*!40000 ALTER TABLE `xlinks` DISABLE KEYS */;
INSERT INTO `xlinks` VALUES (1,1,1,0,1),(2,2,1,0,1),(3,3,1,0,1),(4,4,1,0,1),(5,5,1,0,1),(6,6,1,0,1),(7,7,1,0,1),(8,7,1,1,1),(9,7,1,1,2),(10,8,1,0,1),(11,9,1,0,1),(12,10,1,0,1),(13,11,1,0,1),(14,12,1,0,1),(15,13,1,0,1),(16,14,1,0,1),(17,15,1,0,1),(18,16,1,0,1),(19,17,1,0,1),(20,18,1,0,1),(21,19,1,0,1),(22,19,1,0,2),(23,19,1,0,3),(24,19,1,1,1),(25,19,1,1,2),(26,19,1,1,3),(27,19,1,1,4),(28,20,1,0,1),(29,21,1,0,1),(30,21,3,0,1),(31,22,1,0,1),(32,23,1,0,1),(33,23,1,0,3),(34,24,1,0,1),(35,25,1,0,1),(36,25,1,0,2),(37,25,3,0,1),(38,26,1,0,1),(39,27,1,0,1),(40,27,1,0,2),(41,27,1,0,3),(42,27,1,0,5),(43,27,1,1,1),(44,28,1,0,1),(45,29,1,0,1),(46,30,1,0,1),(47,31,1,0,1),(48,32,1,0,1),(49,33,1,0,1),(50,33,1,0,2),(51,34,1,0,1),(52,34,1,0,2),(53,34,1,1,1),(54,34,1,1,2),(55,34,1,1,3),(56,34,3,0,1),(57,35,1,0,1),(58,35,1,0,2),(59,35,1,1,1),(60,35,1,1,2),(61,36,1,0,1),(62,36,1,0,3),(63,36,1,1,1),(64,37,1,0,1),(65,37,1,0,2),(66,37,1,1,1),(67,37,1,1,2),(68,37,1,1,3),(69,38,1,0,1),(70,38,1,0,2),(71,38,1,0,3),(72,38,1,0,4),(73,38,1,1,2),(74,40,1,0,1),(75,41,1,0,1),(76,42,1,0,1),(77,43,1,0,1),(78,44,1,0,1),(79,45,1,0,1),(80,46,1,0,1),(81,47,1,0,1),(82,48,1,0,1),(83,49,1,0,1),(84,50,1,0,1),(85,51,1,0,1),(86,21,1,0,2),(87,34,3,0,2),(88,38,1,1,1),(89,21,3,0,4),(90,33,3,0,1),(91,7,3,0,1),(92,21,1,0,4),(93,25,1,1,1),(94,7,1,0,2),(95,13,1,1,1),(96,13,1,1,3),(97,13,1,0,3),(98,25,3,0,2),(99,38,1,0,5),(100,9,1,1,3),(101,38,3,0,1),(102,27,3,0,1),(103,20,1,0,2),(104,32,1,1,1),(105,1,1,1,1),(106,34,3,1,1),(107,7,3,1,1),(108,19,1,0,4),(109,5,1,0,2),(110,7,1,1,3),(111,25,3,0,4),(112,13,1,1,2),(113,13,1,1,4);
/*!40000 ALTER TABLE `xlinks` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-12-31 11:45:13
