-- MySQL dump 10.13  Distrib 8.0.25, for Win64 (x86_64)
--
-- Host: localhost    Database: automatroni_2021
-- ------------------------------------------------------
-- Server version	8.0.25

/*!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 `accounts`
--

DROP TABLE IF EXISTS `accounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `accounts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `bank_id` bigint unsigned NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rif` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `accounts_bank_id_foreign` (`bank_id`),
  CONSTRAINT `accounts_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `accounts`
--

LOCK TABLES `accounts` WRITE;
/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;

INSERT INTO `accounts` VALUES (2,5,'0105 0117 2111 1713 9700','Automatroni CA','J293914795','mercantil.png','2018-05-22 20:12:33','2018-05-22 20:12:33',NULL);
INSERT INTO `accounts` VALUES (3,3,'0102 0117 9100 0010 9477','Automatroni CA','J293914795',NULL,'2018-05-22 20:12:33','2018-05-22 20:12:33','2018-05-22 20:12:33');
INSERT INTO `accounts` VALUES (4,19,'0163 0226 1922 6300 5953','Automatroni CA','J293914795',NULL,'2018-05-22 20:12:33','2018-05-22 20:12:33','2018-05-22 20:12:33');
INSERT INTO `accounts` VALUES (5,6,'0108 0157 5301 0013 3258','Automatroni CA','J293914795','prov.png','2018-05-22 20:12:33','2018-05-22 20:12:33',NULL);
INSERT INTO `accounts` VALUES (6,5,'PAGO MOVIL 0105 MERCANTIL 0426-5337198','Automatroni CA','J293914795','pmer.png','2019-01-25 20:12:33','2019-01-25 20:12:33',NULL);
INSERT INTO `accounts` VALUES (7,37,'3ECdJXqxw7DFjrgCBtKoE4yqfBX6BTRoju','Automatroni CA','J293914795','007-localbitcoin.jpg','2019-01-25 20:12:33','2019-01-25 20:12:33','2019-01-25 20:12:33');
INSERT INTO `accounts` VALUES (8,34,'nchiquin@gmail.com','NELSON CHIQUIN','V7243776','Zelle_.png','2019-11-12 20:12:33','2019-11-12 20:12:33',NULL);
INSERT INTO `accounts` VALUES (9,35,'300006543','Automatroni CA','J293914795','m_panama-1.png','2020-05-04 20:12:33','2020-05-04 20:12:33',NULL);
INSERT INTO `accounts` VALUES (10,38,'TAJfwzKq6oQfupbKwByUDm4j1g2AFFxHfH nelson.chiquin@automatroni.com','NELSON CHIQUIN','J293914795','USDT TRC20 Automatroni-1.jpg','2021-03-29 20:12:33','2021-03-29 20:12:33',NULL);
INSERT INTO `accounts` VALUES (11,5,'0105 0117 2711 1719 7883','MIGUEL ANGEL CHIQUIN','V7260575','mercantil-1.png','2021-04-09 20:12:33','2021-04-09 20:12:33',NULL);
INSERT INTO `accounts` VALUES (12,5,'PAGO MOVIL 0105 MERCANTIL 0416-5437351','MIGUEL ANGEL CHIQUIN','V7260575','pmer-1.png','2021-04-09 20:12:33','2021-04-09 20:12:33',NULL);
INSERT INTO `accounts` VALUES (13,36,'7501127206','NELSON CHIQUIN','V7243776','amerant.jpg','2021-07-02 20:12:33','2021-07-02 20:12:33',NULL);

/*!40000 ALTER TABLE `accounts` 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 2021-08-18  9:17:25
