--
-- Host: localhost    Database: qwerty2_itodavet
-- ------------------------------------------------------


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `guests`
--

CREATE TABLE `guests` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `identno` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `passportno` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `degree` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `surname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lastname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `institution` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_id` bigint unsigned DEFAULT NULL,
  `sms_verified` int DEFAULT '0',
  `email_verified` int DEFAULT '0',
  `qrhash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qrmatch` int DEFAULT '0',
  `form_submit` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `qrhash` (`qrhash`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `guests`
--

INSERT INTO `guests` VALUES (76,'12345611111',NULL,'qwe','qwe','qwe','qwe','emreozdurna@gmail.com','5304017215',5,1,1,'292698',0,'2022-09-21 21:02:20','2022-09-21 21:02:19','2022-09-21 21:02:20'),(77,'17636363636',NULL,'tamam','murat','tamam','mzndbfb','murat@diciwall.com','5324614896',5,1,1,'720869',0,'2022-09-21 21:05:14','2022-09-21 21:05:13','2022-09-21 21:05:14'),(80,'35866484444',NULL,'ajans koordinatörü','tarık buğra','tokel','rna i̇letişim','bugra@rna.com.tr','5383561901',5,1,1,'166045',0,'2022-09-22 08:34:35','2022-09-22 08:34:34','2022-09-22 08:34:35'),(81,'12345678911',NULL,'test','test','test','test','emreozdurna@gmail.com','5304017215',5,1,1,'145467',0,'2022-09-22 10:31:36','2022-09-22 10:31:35','2022-09-22 10:31:36'),(82,'11111111111',NULL,'test','test','test','test','emreozdurna@gmail.com','5304017215',5,1,1,'137097',0,'2022-09-22 10:39:42','2022-09-22 10:39:41','2022-09-22 10:39:42'),(83,'11111111111',NULL,'test','test','test','test','emreozdurna@gmail.com','5304017215',5,1,1,'998730',0,NULL,'2022-09-22 10:41:44','2022-09-22 10:41:44'),(84,'11111111111',NULL,'test','test','test','test','emreozdurna@gmail.com','5304017215',5,1,1,'409694',0,NULL,'2022-09-22 10:42:53','2022-09-22 10:42:53'),(85,'11111111111',NULL,'test','test','test','test','emreozdurna@gmail.com','5304017215',5,1,1,'903341',0,NULL,'2022-09-22 10:43:02','2022-09-22 10:43:02'),(86,'11111111111',NULL,'test','test','test','test','emreozdurna@gmail.com','5304017215',5,1,1,'879680',0,'2022-09-22 10:43:54','2022-09-22 10:43:53','2022-09-22 10:43:54'),(87,'11111111111',NULL,'test','test','test','test','test@gmail.com','5304017215',5,1,1,'807350',0,NULL,'2022-09-22 10:49:03','2022-09-22 10:49:03'),(88,'11111111111',NULL,'test','test','test','test','test@gmail.com','5304017215',5,1,1,'386474',1,'2022-09-22 10:49:24','2022-09-22 10:49:23','2022-09-22 11:27:03'),(89,'11111111111',NULL,'test','test','test','test','qweqwe@gmail.com','5304017215',5,1,1,'121194',0,NULL,'2022-09-22 11:38:59','2022-09-22 11:38:59'),(90,'11111111111',NULL,'test','test','test','test','qweqwe@gmail.com','5304017215',5,1,1,'322171',0,'2022-09-22 11:39:14','2022-09-22 11:39:13','2022-09-22 11:39:14');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(20,'2022_02_01_215053_create_predicaments_table',17),(24,'2022_02_01_210309_create_guests_table',19),(25,'2022_02_01_220226_create_organizations_table',20);

--
-- Table structure for table `organizations`
--

CREATE TABLE `organizations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `or_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `organizations`
--

INSERT INTO `organizations` VALUES (5,'140. Yıl Özel Ödül Töreni','Haliç Kongre Merkezi','2022-09-25 17:30:00',1,'2022-02-03 22:33:23','2022-09-20 21:20:30');


