--
-- Host: localhost    Database: maps
-- ------------------------------------------------------


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8_unicode_ci NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_reserved_reserved_at_index` (`queue`,`reserved`,`reserved_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `maps`
--

CREATE TABLE `maps` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `nameMap` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `apiKey` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `public` int(11) DEFAULT NULL,
  `finished` int(11) DEFAULT NULL,
  `descript` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lat` double(12,10) DEFAULT NULL,
  `lon` double(12,10) DEFAULT NULL,
  `picNum` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `maps`
--

INSERT INTO `maps` VALUES (70,1,'Imanjeddjdk','2b564d49eb41227a9db1e292b32927b5',1,1,'',NULL,NULL,NULL,'2017-09-11 19:25:04','2017-09-11 19:25:04'),(71,1,'Imanjce Biotehnickog','a9c9ba4fb73e8a4f5c15992e9a48490a',1,1,'',NULL,NULL,NULL,'2017-09-11 19:25:26','2017-09-11 19:25:26'),(72,1,'Novo ime','07b2426be2ad331fa787ec9b7a2b0f8c',1,1,'',NULL,NULL,NULL,'2017-09-11 19:25:42','2017-09-11 19:25:42'),(73,1,'Mapa11','9e7ddbfe4b508007b2730f89a7ab7c45',1,1,'',NULL,NULL,NULL,'2017-09-11 19:26:00','2017-09-11 19:26:00'),(74,1,'Mapa11','7f5cfa2b5f1c5ba572a3a18706cc7ce2',1,1,'',NULL,NULL,NULL,'2017-09-11 19:36:05','2017-09-11 19:36:05'),(75,1,'maap','b1e034308a8174fb88095fafef3bf0b9',1,1,'',NULL,NULL,NULL,'2017-09-12 04:53:09','2017-09-12 04:53:09'),(76,1,'Mapa','9e2e4831cb46527b4bcc5b9754b6f272',1,1,'',NULL,NULL,NULL,'2017-09-12 05:14:25','2017-09-12 05:14:25');

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

CREATE TABLE `migrations` (
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `migrations` VALUES ('2014_10_12_000000_create_session_table',1),('2014_10_12_000000_create_users_table',2),('2014_10_12_100000_create_password_resets_table',2),('2016_07_16_032557_create_maps_table',2),('2016_07_17_215332_create_sessions_table',3),('2016_07_18_071840_create_jobs_table',3),('2016_09_14_155528_CreateNodesTable',3);

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  KEY `password_resets_email_index` (`email`),
  KEY `password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8_unicode_ci,
  `payload` text COLLATE utf8_unicode_ci NOT NULL,
  `last_activity` int(11) NOT NULL,
  UNIQUE KEY `sessions_id_unique` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sessions`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `prezime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_name_unique` (`name`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'zarkoz','zarkoz@ac.me','$2y$10$/jw757VTK7KF1uoWbxYmk.0Py3MUNrdWAD5JHK56cBx1/6gfcaoj2','','','USA5z0E6EOcUGOmK46D8x4FQsk0REZKms4ui7iuBnt6E5ShbxFKCOai4YOro','2016-09-14 14:26:12','2017-09-10 15:30:51'),(2,'mirko','mirkd@dkdk.com','$2y$10$LFm.MQoAGWsgn6TKP.c61eqLSYI1eVLS.5N3/8R39/5JmIAczv8Wq','Miekodkdkd','','ncO8hERUBXfCBYiJTUjdSfhCop6Ky31oen3pOXlwgI5TyvOsciYEKWJbzFR8','2016-09-14 14:42:11','2016-09-14 14:43:40'),(3,'ddnd','zarkoz@cdkkdkd.com','$2y$10$bVNYrFj6jIPfrwXPiPUK2eD/o/1eB2R5yaA26ZgzXdlc5QMOWX.4W','ddnd','djdjd',NULL,'2016-09-14 14:44:10','2016-09-14 14:44:10'),(4,'tpopovic@ac.me','tpopovic@ac.me','$2y$10$ixaseQfIX68j9Qg7XNueF.egEvFnsLcKZ3u0tsEsgaaZSNINzd8Si','Tomo','Popovic',NULL,'2016-09-15 04:30:22','2016-09-15 04:30:22');


