-- MySQL dump 10.13  Distrib 8.0.42, for Win64 (x86_64)
--
-- Host: localhost    Database: banksfinders
-- ------------------------------------------------------
-- Server version	9.2.0-commercial

/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!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 `creditcardstypes`
--

DROP TABLE IF EXISTS `creditcardstypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `creditcardstypes` (
  `idcreditcardstypes` int NOT NULL AUTO_INCREMENT,
  `idcreditcards` int NOT NULL,
  `idcardtype` int NOT NULL,
  PRIMARY KEY (`idcreditcardstypes`),
  KEY `fk_creditcardstypes_1_idx` (`idcardtype`),
  KEY `fk_creditcardstypes_2` (`idcreditcards`),
  CONSTRAINT `fk_creditcardstypes_1` FOREIGN KEY (`idcardtype`) REFERENCES `cardtypes` (`idcardtype`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_creditcardstypes_2` FOREIGN KEY (`idcreditcards`) REFERENCES `creditcards` (`idcreditcards`)
) ENGINE=InnoDB AUTO_INCREMENT=318 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `creditcardstypes`
--
banksfinders`.
LOCK TABLES `creditcardstypes` WRITE;
/*!40000 ALTER TABLE `creditcardstypes` DISABLE KEYS */;
INSERT INTO `creditcardstypes` VALUES (1,1,13),(2,131,13),(3,133,13),(4,156,13),(5,165,13),(6,189,13),(7,190,13),(8,191,13),(9,199,13),(10,204,13),(11,205,13),(12,218,13),(13,220,13),(14,243,13),(15,252,13),(16,276,13),(17,277,13),(18,278,13),(19,286,13),(20,291,13),(21,292,13),(32,140,14),(33,141,14),(34,196,14),(35,197,14),(36,198,14),(37,202,14),(38,203,14),(39,212,14),(40,213,14),(41,214,14),(42,227,14),(43,228,14),(44,283,14),(45,284,14),(46,285,14),(47,289,14),(48,290,14),(49,299,14),(50,300,14),(51,301,14),(63,1,12),(64,128,12),(65,129,12),(66,130,12),(67,131,12),(68,132,12),(69,133,12),(70,134,12),(71,135,12),(72,136,12),(73,137,12),(74,138,12),(75,139,12),(76,140,12),(77,141,12),(78,142,12),(79,143,12),(80,144,12),(81,145,12),(82,146,12),(83,147,12),(84,148,12),(85,149,12),(86,150,12),(87,151,12),(88,152,12),(89,153,12),(90,154,12),(91,155,12),(92,156,12),(93,157,12),(94,158,12),(95,159,12),(96,160,12),(97,161,12),(98,162,12),(99,163,12),(100,164,12),(101,165,12),(102,166,12),(103,167,12),(104,168,12),(105,169,12),(106,170,12),(107,171,12),(108,172,12),(109,173,12),(110,174,12),(111,175,12),(112,176,12),(113,177,12),(114,178,12),(115,179,12),(116,180,12),(117,181,12),(118,182,12),(119,183,12),(120,184,12),(121,185,12),(122,186,12),(123,187,12),(124,188,12),(125,189,12),(126,190,12),(127,191,12),(128,192,12),(129,193,12),(130,194,12),(131,195,12),(132,196,12),(133,197,12),(134,198,12),(135,199,12),(136,200,12),(137,201,12),(138,202,12),(139,203,12),(140,204,12),(141,205,12),(142,206,12),(143,207,12),(144,208,12),(145,209,12),(146,210,12),(147,211,12),(148,212,12),(149,213,12),(150,214,12),(151,215,12),(152,216,12),(153,217,12),(154,218,12),(155,219,12),(156,220,12),(157,221,12),(158,222,12),(159,223,12),(160,224,12),(161,225,12),(162,226,12),(163,227,12),(164,228,12),(165,229,12),(166,230,12),(167,231,12),(168,232,12),(169,233,12),(170,234,12),(171,235,12),(172,236,12),(173,237,12),(174,238,12),(175,239,12),(176,240,12),(177,241,12),(178,242,12),(179,243,12),(180,244,12),(181,245,12),(182,246,12),(183,247,12),(184,248,12),(185,249,12),(186,250,12),(187,251,12),(188,252,12),(189,253,12),(190,254,12),(191,255,12),(192,256,12),(193,257,12),(194,258,12),(195,259,12),(196,260,12),(197,261,12),(198,262,12),(199,263,12),(200,264,12),(201,265,12),(202,266,12),(203,267,12),(204,268,12),(205,269,12),(206,270,12),(207,271,12),(208,272,12),(209,273,12),(210,274,12),(211,275,12),(212,276,12),(213,277,12),(214,278,12),(215,279,12),(216,280,12),(217,281,12),(218,282,12),(219,283,12),(220,284,12),(221,285,12),(222,286,12),(223,287,12),(224,288,12),(225,289,12),(226,290,12),(227,291,12),(228,292,12),(229,293,12),(230,294,12),(231,295,12),(232,296,12),(233,297,12),(234,298,12),(235,299,12),(236,300,12),(237,301,12);
/*!40000 ALTER TABLE `creditcardstypes` 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 2025-05-16 14:18:28