API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 3rd, 2018
748
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 31.53 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.5.4.1deb2ubuntu2
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Czas generowania: 03 Cze 2018, 19:18
  7. -- Wersja serwera: 5.7.22-0ubuntu0.16.04.1
  8. -- Wersja PHP: 7.2.4-1+ubuntu16.04.1+deb.sury.org+1
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Baza danych: `re_agency`
  15. --
  16.  
  17. -- --------------------------------------------------------
  18.  
  19. --
  20. -- Struktura tabeli dla tabeli `advertisements`
  21. --
  22.  
  23. CREATE TABLE `advertisements` (
  24. `id` int(10) UNSIGNED NOT NULL,
  25. `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  26. `status` tinyint(4) NOT NULL,
  27. `admin_notes` text COLLATE utf8mb4_unicode_ci,
  28. `date_of_announcement` date NOT NULL,
  29. `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  30. `price` int(11) NOT NULL,
  31. `created_at` timestamp NULL DEFAULT NULL,
  32. `updated_at` timestamp NULL DEFAULT NULL,
  33. `user_id` int(10) UNSIGNED DEFAULT NULL
  34. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  35.  
  36. --
  37. -- Zrzut danych tabeli `advertisements`
  38. --
  39.  
  40. INSERT INTO `advertisements` (`id`, `type`, `status`, `admin_notes`, `date_of_announcement`, `description`, `price`, `created_at`, `updated_at`, `user_id`) VALUES
  41. (116, 'sale', 3, NULL, '2018-05-28', 'Nice House', 120000, '2018-05-28 11:41:43', '2018-05-29 04:36:27', 1),
  42. (122, 'sale', 0, NULL, '2018-05-28', '123', 123, '2018-05-28 14:24:39', '2018-05-28 14:24:39', 11),
  43. (126, 'sale', 2, NULL, '2018-05-28', '123', 123, '2018-05-28 14:56:16', '2018-05-28 15:18:14', 1),
  44. (134, 'sale', 2, 'Hej nie koty', '2018-05-29', '22', 22, '2018-05-29 10:18:03', '2018-05-29 11:50:21', 14),
  45. (136, 'sale', 1, NULL, '2018-05-29', '111', 1, '2018-05-29 11:37:10', '2018-05-29 11:37:30', 1);
  46.  
  47. -- --------------------------------------------------------
  48.  
  49. --
  50. -- Struktura tabeli dla tabeli `migrations`
  51. --
  52.  
  53. CREATE TABLE `migrations` (
  54. `id` int(10) UNSIGNED NOT NULL,
  55. `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  56. `batch` int(11) NOT NULL
  57. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  58.  
  59. --
  60. -- Zrzut danych tabeli `migrations`
  61. --
  62.  
  63. INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  64. (1, '2014_10_12_000000_create_users_table', 1),
  65. (2, '2014_10_12_100000_create_password_resets_table', 1),
  66. (3, '2018_04_11_095536_create_personal_datas_table', 1),
  67. (4, '2018_04_11_095917_create_roles_table', 1),
  68. (5, '2018_04_11_095938_create_properties_table', 1),
  69. (6, '2018_04_11_100006_create_advertisements_table', 1),
  70. (7, '2018_04_11_104013_create_role_user', 1),
  71. (8, '2018_04_11_111740_update_personal_datas', 1),
  72. (9, '2018_04_11_111918_update_advertisements', 1),
  73. (10, '2018_04_27_085225_create_photos_table', 2),
  74. (11, '2014_10_12_000000_scout_index', 3);
  75.  
  76. -- --------------------------------------------------------
  77.  
  78. --
  79. -- Struktura tabeli dla tabeli `password_resets`
  80. --
  81.  
  82. CREATE TABLE `password_resets` (
  83. `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  84. `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  85. `created_at` timestamp NULL DEFAULT NULL
  86. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  87.  
  88. -- --------------------------------------------------------
  89.  
  90. --
  91. -- Struktura tabeli dla tabeli `personal_datas`
  92. --
  93.  
  94. CREATE TABLE `personal_datas` (
  95. `id` int(10) UNSIGNED NOT NULL,
  96. `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  97. `surname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  98. `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  99. `country` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  100. `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  101. `street` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  102. `street_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  103. `postal_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  104. `created_at` timestamp NULL DEFAULT NULL,
  105. `updated_at` timestamp NULL DEFAULT NULL,
  106. `user_id` int(10) UNSIGNED DEFAULT NULL
  107. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  108.  
  109. --
  110. -- Zrzut danych tabeli `personal_datas`
  111. --
  112.  
  113. INSERT INTO `personal_datas` (`id`, `name`, `surname`, `phone_number`, `country`, `city`, `street`, `street_number`, `postal_code`, `created_at`, `updated_at`, `user_id`) VALUES
  114. (14, 'Kuba', 'Q', '666-666-666', 'Poland', 'Brz', 'Nta', '33', '32-620', '2018-05-28 06:55:55', '2018-05-28 06:56:30', 11);
  115.  
  116. -- --------------------------------------------------------
  117.  
  118. --
  119. -- Struktura tabeli dla tabeli `photos`
  120. --
  121.  
  122. CREATE TABLE `photos` (
  123. `id` int(10) UNSIGNED NOT NULL,
  124. `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  125. `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  126. `thumb_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  127. `advertisement_id` int(10) UNSIGNED NOT NULL,
  128. `created_at` timestamp NULL DEFAULT NULL,
  129. `updated_at` timestamp NULL DEFAULT NULL
  130. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  131.  
  132. --
  133. -- Zrzut danych tabeli `photos`
  134. --
  135.  
  136. INSERT INTO `photos` (`id`, `name`, `url`, `thumb_url`, `advertisement_id`, `created_at`, `updated_at`) VALUES
  137. (181, 'i1uw6R1OIV0GKZLo.jpeg', 'https://www.reagency.tk/uploads/images/116/i1uw6R1OIV0GKZLo.jpeg', 'https://www.reagency.tk/uploads/images/116/thumbnails/thumb_i1uw6R1OIV0GKZLo.jpeg', 116, '2018-05-28 11:45:09', '2018-05-28 11:45:09'),
  138. (203, 'OM1Ur6MbeARpL76h.jpeg', 'https://www.reagency.tk/uploads/images/126/OM1Ur6MbeARpL76h.jpeg', 'https://www.reagency.tk/uploads/images/126/thumbnails/thumb_OM1Ur6MbeARpL76h.jpeg', 126, '2018-05-28 14:56:34', '2018-05-28 14:56:34'),
  139. (241, 'i8FGojT8BJ8C1hE8.jpeg', 'https://www.reagency.tk/uploads/images/122/i8FGojT8BJ8C1hE8.jpeg', 'https://www.reagency.tk/uploads/images/122/thumbnails/thumb_i8FGojT8BJ8C1hE8.jpeg', 122, '2018-05-29 06:39:55', '2018-05-29 06:39:55'),
  140. (246, 'zrm41EpQotG19NrW.jpeg', 'https://www.reagency.tk/uploads/images/122/zrm41EpQotG19NrW.jpeg', 'https://www.reagency.tk/uploads/images/122/thumbnails/thumb_zrm41EpQotG19NrW.jpeg', 122, '2018-05-29 07:01:55', '2018-05-29 07:01:55'),
  141. (247, 'v19qFseqmzqNErgf.jpeg', 'https://www.reagency.tk/uploads/images/122/v19qFseqmzqNErgf.jpeg', 'https://www.reagency.tk/uploads/images/122/thumbnails/thumb_v19qFseqmzqNErgf.jpeg', 122, '2018-05-29 07:01:55', '2018-05-29 07:01:55'),
  142. (248, 'cwoW2yjHqW0cjVDM.png', 'https://www.reagency.tk/uploads/images/122/cwoW2yjHqW0cjVDM.png', 'https://www.reagency.tk/uploads/images/122/thumbnails/thumb_cwoW2yjHqW0cjVDM.png', 122, '2018-05-29 07:01:55', '2018-05-29 07:01:55'),
  143. (249, 'gFmJhTlvVjo5F2ys.jpeg', 'https://www.reagency.tk/uploads/images/122/gFmJhTlvVjo5F2ys.jpeg', 'https://www.reagency.tk/uploads/images/122/thumbnails/thumb_gFmJhTlvVjo5F2ys.jpeg', 122, '2018-05-29 07:33:40', '2018-05-29 07:33:40'),
  144. (250, 'QuqpTqPNkhkUJm4r.jpeg', 'https://www.reagency.tk/uploads/images/122/QuqpTqPNkhkUJm4r.jpeg', 'https://www.reagency.tk/uploads/images/122/thumbnails/thumb_QuqpTqPNkhkUJm4r.jpeg', 122, '2018-05-29 07:33:40', '2018-05-29 07:33:40'),
  145. (251, 'bSkiNnJtJq9vduEL.png', 'https://www.reagency.tk/uploads/images/122/bSkiNnJtJq9vduEL.png', 'https://www.reagency.tk/uploads/images/122/thumbnails/thumb_bSkiNnJtJq9vduEL.png', 122, '2018-05-29 07:33:41', '2018-05-29 07:33:41'),
  146. (252, '5llLtCSzJG0Y3wEA.jpeg', 'https://www.reagency.tk/uploads/images/134/5llLtCSzJG0Y3wEA.jpeg', 'https://www.reagency.tk/uploads/images/134/thumbnails/thumb_5llLtCSzJG0Y3wEA.jpeg', 134, '2018-05-29 10:18:49', '2018-05-29 10:18:49'),
  147. (261, 'D9vyN0kJDi1Bq5ek.jpeg', 'https://www.reagency.tk/uploads/images/136/D9vyN0kJDi1Bq5ek.jpeg', 'https://www.reagency.tk/uploads/images/136/thumbnails/thumb_D9vyN0kJDi1Bq5ek.jpeg', 136, '2018-05-29 11:37:30', '2018-05-29 11:37:30');
  148.  
  149. -- --------------------------------------------------------
  150.  
  151. --
  152. -- Struktura tabeli dla tabeli `properties`
  153. --
  154.  
  155. CREATE TABLE `properties` (
  156. `id` int(10) UNSIGNED NOT NULL,
  157. `property_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  158. `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  159. `date_of_registration` date NOT NULL,
  160. `property_area` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  161. `date_of_construction` date DEFAULT NULL,
  162. `number_of_floors` int(11) DEFAULT NULL,
  163. `number_of_rooms` int(11) DEFAULT NULL,
  164. `floor` int(11) DEFAULT NULL,
  165. `balcony` tinyint(1) DEFAULT NULL,
  166. `garage` tinyint(1) DEFAULT NULL,
  167. `land_area` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  168. `country` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  169. `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  170. `street` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  171. `street_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  172. `postal_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  173. `created_at` timestamp NULL DEFAULT NULL,
  174. `updated_at` timestamp NULL DEFAULT NULL,
  175. `advertisement_id` int(10) UNSIGNED DEFAULT NULL
  176. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  177.  
  178. --
  179. -- Zrzut danych tabeli `properties`
  180. --
  181.  
  182. INSERT INTO `properties` (`id`, `property_type`, `description`, `date_of_registration`, `property_area`, `date_of_construction`, `number_of_floors`, `number_of_rooms`, `floor`, `balcony`, `garage`, `land_area`, `country`, `city`, `street`, `street_number`, `postal_code`, `created_at`, `updated_at`, `advertisement_id`) VALUES
  183. (92, 'House', 'Nice house for a nice guy', '2018-05-01', '150', '2018-05-03', 1, 4, 0, 0, 1, '300', 'USA', 'Palo alto', 'nice', '5', '94020', '2018-05-28 11:45:09', '2018-05-28 11:45:09', 116),
  184. (98, 'Flat', '213', '2018-05-09', '123', '2018-05-11', 123, 12, 123, 123, 123, '123', '123', '123', '123', '123', '123', '2018-05-28 14:56:34', '2018-05-28 14:56:34', 126),
  185. (102, 'House', 'Super budyneczek', '2001-02-22', '212', '1993-12-31', 12, 1, 2, 1, 2, '121', 'Poland', 'Oswiecim', 'Dziwakow', '23', '32-600', '2018-05-29 10:18:49', '2018-05-29 10:18:49', 134),
  186. (104, 'Flat', '1', '2018-05-03', '1', '2018-05-10', 1, 1, 1, 1, 1, '1', '1', '1', '1', '1', '32-600', '2018-05-29 11:37:30', '2018-05-29 11:37:30', 136);
  187.  
  188. -- --------------------------------------------------------
  189.  
  190. --
  191. -- Struktura tabeli dla tabeli `roles`
  192. --
  193.  
  194. CREATE TABLE `roles` (
  195. `id` int(10) UNSIGNED NOT NULL,
  196. `role_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  197. `created_at` timestamp NULL DEFAULT NULL,
  198. `updated_at` timestamp NULL DEFAULT NULL
  199. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  200.  
  201. --
  202. -- Zrzut danych tabeli `roles`
  203. --
  204.  
  205. INSERT INTO `roles` (`id`, `role_name`, `created_at`, `updated_at`) VALUES
  206. (1, 'administrator', '2018-04-24 07:26:11', '2018-04-24 07:26:11'),
  207. (2, 'user', '2018-04-24 07:26:11', '2018-04-24 07:26:11');
  208.  
  209. -- --------------------------------------------------------
  210.  
  211. --
  212. -- Struktura tabeli dla tabeli `role_user`
  213. --
  214.  
  215. CREATE TABLE `role_user` (
  216. `id` int(10) UNSIGNED NOT NULL,
  217. `role_id` int(10) UNSIGNED NOT NULL,
  218. `user_id` int(10) UNSIGNED NOT NULL,
  219. `created_at` timestamp NULL DEFAULT NULL,
  220. `updated_at` timestamp NULL DEFAULT NULL
  221. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  222.  
  223. --
  224. -- Zrzut danych tabeli `role_user`
  225. --
  226.  
  227. INSERT INTO `role_user` (`id`, `role_id`, `user_id`, `created_at`, `updated_at`) VALUES
  228. (1, 1, 1, '2018-04-24 07:26:11', '2018-04-24 07:26:11'),
  229. (11, 2, 11, '2018-05-01 07:41:14', '2018-05-01 07:41:14'),
  230. (14, 1, 14, '2018-05-16 18:32:08', '2018-05-16 18:32:08'),
  231. (22, 2, 22, '2018-05-29 11:54:46', '2018-05-29 11:54:46');
  232.  
  233. -- --------------------------------------------------------
  234.  
  235. --
  236. -- Struktura tabeli dla tabeli `scout_index`
  237. --
  238.  
  239. CREATE TABLE `scout_index` (
  240. `index` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  241. `objectID` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  242. `entry` text COLLATE utf8mb4_unicode_ci NOT NULL
  243. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  244.  
  245. --
  246. -- Zrzut danych tabeli `scout_index`
  247. --
  248.  
  249. INSERT INTO `scout_index` (`index`, `objectID`, `entry`) VALUES
  250. ('advertisements', '108', '[108,"rent",3,null,"2028-05-20","test1",100,"2018-05-28 08:53:08","2018-05-28 08:54:24"]'),
  251. ('advertisements', '11', '[11,"sprzeda\\u017c",1,"2018-04-24","opisik",120000,"2018-04-24 11:40:49","2018-05-06 16:01:46",{"id":1,"property_type":"Dzia\\u0142ka","description":"Dzialka taka o","date_of_registration":"2013-03-02","property_area":null,"date_of_construction":null,"number_of_floors":null,"number_of_rooms":null,"floor":null,"balcony":null,"garage":null,"land_area":"100km2","country":"Poland","city":"Oswiecim","street":"Kwiatowa","street_number":"32","postal_code":"32-600","created_at":"2018-04-24 12:33:56","updated_at":"2018-04-24 12:33:56"}]'),
  252. ('advertisements', '110', '[110,"sale",1,null,"2028-05-20","test4",211,"2018-05-28 08:59:35","2018-05-28 09:00:00",{"id":79,"property_type":"dom","description":"test4","date_of_registration":"2018-05-09","property_area":null,"date_of_construction":"2018-05-09","number_of_floors":null,"number_of_rooms":null,"floor":null,"balcony":null,"garage":null,"land_area":"12","country":"test4","city":"test4","street":"test4","street_number":"test4","postal_code":"test4","created_at":"2018-05-28 08:59:59","updated_at":"2018-05-28 08:59:59","advertisement_id":null}]'),
  253. ('advertisements', '116', '[116,"sale",3,null,"2018-05-28","Nice House",120000,"2018-05-28 13:41:43","2018-05-29 06:36:27",{"id":92,"property_type":"House","description":"Nice house for a nice guy","date_of_registration":"2018-05-01","property_area":"150","date_of_construction":"2018-05-03","number_of_floors":1,"number_of_rooms":4,"floor":0,"balcony":0,"garage":1,"land_area":"300","country":"USA","city":"Palo alto","street":"nice","street_number":"5","postal_code":"94020","created_at":"2018-05-28 13:45:09","updated_at":"2018-05-28 13:45:09","advertisement_id":116},{"id":1,"name":"admin","email":"admin@admin.com","active":1,"created_at":"2018-04-24 09:26:11","updated_at":"2018-04-24 09:26:11"}]'),
  254. ('advertisements', '117', '[117,"sale",3,null,"2018-05-28","Gda\\u0144sk, Przymorze",250,"2018-05-28 15:45:31","2018-05-28 16:17:11",{"id":93,"property_type":"Flat","description":"Opis Oferta sprzeda\\u017cy kawalerki, 2 pi\\u0119tro, niski blok, ul. Opolska na Przymorzu. Wok\\u00f3\\u0142 pe\\u0142na infrastruktura handlowo - us\\u0142ugowa oraz przedszkola i szko\\u0142a. Niew\\u0105tpliwym atutem jest blisko\\u015b\\u0107 morza oraz teren\\u00f3w zielonych, a tak\\u017ce komunikacji miejskiej. Budynek z lat siedemdziesi\\u0105tych, w bardzo dobrym stanie, po remoncie elewacji. Klatka schodowa w trakcie remontu. Mieszkanie znajduje si\\u0119 na 2 pietrze w niskim bloku. Sk\\u0142ada si\\u0119 z pokoju z wyj\\u015bciem na balkon z widokiem na ziele\\u0144, kuchni z oknem, \\u0142azienki i korytarza z miejscem na zabudow\\u0119. Mieszkanie do w\\u0142asnej aran\\u017cacji, okna PCV. Zapraszam na prezentacj\\u0119. _ KUP Z NAMI - KORZYSTNIE, SZYBKO I BEZPIECZNIE! - 0% prowizji od kupuj\\u0105cego i \\u017cadnych dodatkowych oraz ukrytych koszt\\u00f3w - gwarantujemy bezpieczny zakup i najlepsz\\u0105 cen\\u0119 - oferujemy skuteczn\\u0105 i bezp\\u0142atn\\u0105 pomoc w uzyskaniu kredytu - zapewniamy fachowe doradztwo przy zakupie pod inwestycj\\u0119","date_of_registration":"2018-05-28","property_area":null,"date_of_construction":"2018-05-21","number_of_floors":2,"number_of_rooms":1,"floor":null,"balcony":1,"garage":0,"land_area":"292","country":"Polska","city":"Gda\\u0144sk","street":"Przymorze wielkie","street_number":"20","postal_code":"22-100","created_at":"2018-05-28 15:51:03","updated_at":"2018-05-28 15:51:03","advertisement_id":117},{"id":19,"name":"Mateusz","email":"mateuszwojtas@interia.pl","active":1,"created_at":"2018-05-26 15:03:46","updated_at":"2018-05-26 15:05:08"}]'),
  255. ('advertisements', '118', '[118,"sale",2,null,"2018-05-28","Wejherowski, Rumia, Rumia",3400000,"2018-05-28 15:56:32","2018-05-28 16:49:42",{"id":94,"property_type":"House","description":"Dom z du\\u017cym ogrodem, pa parterze otwarta kuchnia z jadalni\\u0105 i wyj\\u015bciem na taras, \\u0142azienka i sypialnia z szaf\\u0105,na pi\\u0119trze 4 sypialnie i du\\u017ca \\u0142azienka z wann\\u0105 i prysznicem... Do domu przynale\\u017cy r\\u00f3wnie\\u017c warsztat, magazyn, oraz dom z dwoma mieszkaniami i lokalami u\\u017cytkowymi-obecnie wynajmowane. Zapraszamy na prezentacj\\u0119.","date_of_registration":"2018-05-15","property_area":null,"date_of_construction":"2018-05-14","number_of_floors":3,"number_of_rooms":7,"floor":null,"balcony":2,"garage":1,"land_area":"1000","country":"Polska","city":"Rumia","street":"Starowiejska","street_number":"25","postal_code":"84-200","created_at":"2018-05-28 16:01:16","updated_at":"2018-05-28 16:01:16","advertisement_id":118},{"id":19,"name":"Mateusz","email":"mateuszwojtas@interia.pl","active":1,"created_at":"2018-05-26 15:03:46","updated_at":"2018-05-26 15:05:08"}]'),
  256. ('advertisements', '119', '[119,"sale",2,null,"2018-05-28","Pucki, Kosakowo, Mosty",521400,"2018-05-28 16:03:54","2018-05-28 16:17:06",{"id":95,"property_type":"Building land","description":"Atrakcyjna dzia\\u0142ka budowlano-inwestycyjna po\\u0142o\\u017cona w Mostach, Gmina Kosakowo. Widok na zatok\\u0119 w odleg\\u0142o\\u015bci 1km od morza. Dojazd do Gdyni zajmuje 15 min, . Przy dzia\\u0142ce jest droga dojazdowa. Media : pr\\u0105d i gaz, woda i kanalizacja . Wok\\u00f3\\u0142 powstaje zabudowa jednorodzinna. Przeznaczenie terenu: - mieszkaniowe. W pobli\\u017cu wiele atrakcyjnych miejsc: do pla\\u017cy z nowoczesn\\u0105 przystani\\u0105 ryback\\u0105 w Mechelinkach 1 km, Rezerwat Przyrody Beka z licznymi \\u015bcie\\u017ckami rowerowymi oraz Mecheli\\u0144skie \\u0141\\u0105k ps. Dzalka jest z 3 stron ogrodzona ! ZAPRASZAM NA PREZENTACJE","date_of_registration":"2018-05-21","property_area":null,"date_of_construction":null,"number_of_floors":null,"number_of_rooms":null,"floor":null,"balcony":null,"garage":null,"land_area":"1620","country":"Polska","city":"Gdynia","street":"Gdy\\u0144ska","street_number":"15","postal_code":"80-001","created_at":"2018-05-28 16:09:57","updated_at":"2018-05-28 16:09:57","advertisement_id":119},{"id":19,"name":"Mateusz","email":"mateuszwojtas@interia.pl","active":1,"created_at":"2018-05-26 15:03:46","updated_at":"2018-05-26 15:05:08"}]'),
  257. ('advertisements', '12', '[12,"Wynajem",1,"2014-04-24","DIVY z roksy",666,"2018-04-24 11:43:57","2018-05-06 16:01:51",{"id":2,"property_type":"Dzia\\u0142ka","description":"No zmieniamy dane dzialki","date_of_registration":"2013-05-21","property_area":null,"date_of_construction":null,"number_of_floors":null,"number_of_rooms":null,"floor":null,"balcony":null,"garage":0,"land_area":"666km2","country":"Poland","city":"Oswiecim","street":"Lipowa","street_number":"32","postal_code":"32-600","created_at":"2018-04-24 12:36:08","updated_at":"2018-04-24 13:08:02"}]'),
  258. ('advertisements', '121', '[121,"rent",2,":DD","2018-05-28","Wynajm\\u0119 STANOWISKO FRYZJERSKIE-Centrum Gdyni",1500,"2018-05-28 16:13:09","2018-05-29 13:24:22",{"id":96,"property_type":"Premises","description":"sTANOWISKO FRYZJERSKIE w cenie czynszu wszystkie op\\u0142aty, mo\\u017cliwo\\u015b\\u0107 skorzystania z us\\u0142ug recepcji, umowa minimum na rok, jednomiesi\\u0119czna kaucja . Okolo 900 klientow w miesiacu w sezonie...Bardzo duzy ruch przez caly rok. Doskonale wypozycjonowana strona internetowa !!! Salon dziala juz 25 lat","date_of_registration":"2018-05-22","property_area":"150","date_of_construction":"2018-05-23","number_of_floors":1,"number_of_rooms":2,"floor":null,"balcony":null,"garage":null,"land_area":"150","country":"Polska","city":"Gdynia","street":"\\u015al\\u0105ska","street_number":"24","postal_code":"80-003","created_at":"2018-05-28 16:16:12","updated_at":"2018-05-28 16:16:12","advertisement_id":121},{"id":19,"name":"Mateusz","email":"mateuszwojtas@interia.pl","active":1,"created_at":"2018-05-26 15:03:46","updated_at":"2018-05-26 15:05:08"}]'),
  259. ('advertisements', '122', '[122,"sale",0,null,"2018-05-28","123",123,"2018-05-28 16:24:39","2018-05-28 16:24:39",null,{"id":11,"name":"kubus","email":"jakkoz91@gmail.com","active":1,"created_at":"2018-05-01 09:41:14","updated_at":"2018-05-01 09:49:34"}]'),
  260. ('advertisements', '123', '[123,"sale",3,null,"2018-05-28","\\u015amieciara",666,"2018-05-28 16:34:57","2018-05-28 16:43:47",{"id":97,"property_type":"Flat","description":"Haha :DDDD","date_of_registration":"2018-05-05","property_area":"1","date_of_construction":"2018-05-13","number_of_floors":1,"number_of_rooms":1,"floor":1,"balcony":1,"garage":1,"land_area":"1","country":"Polska","city":"O\\u015bwi\\u0119cim","street":"Taka","street_number":"2","postal_code":"32-600","created_at":"2018-05-28 16:39:21","updated_at":"2018-05-28 16:39:21","advertisement_id":123},{"id":15,"name":"kukus","email":"p.kuba1993@gmail.com","active":1,"created_at":"2018-05-17 11:21:24","updated_at":"2018-05-17 11:21:24"}]'),
  261. ('advertisements', '126', '[126,"sale",2,null,"2018-05-28","123",123,"2018-05-28 16:56:16","2018-05-28 17:18:14",{"id":98,"property_type":"Flat","description":"213","date_of_registration":"2018-05-09","property_area":"123","date_of_construction":"2018-05-11","number_of_floors":123,"number_of_rooms":12,"floor":123,"balcony":123,"garage":123,"land_area":"123","country":"123","city":"123","street":"123","street_number":"123","postal_code":"123","created_at":"2018-05-28 16:56:34","updated_at":"2018-05-28 16:56:34","advertisement_id":126},{"id":1,"name":"admin","email":"admin@admin.com","active":1,"created_at":"2018-04-24 09:26:11","updated_at":"2018-04-24 09:26:11"}]'),
  262. ('advertisements', '134', '[134,"sale",2,"Hej nie koty","2018-05-29","22",22,"2018-05-29 12:18:03","2018-05-29 13:50:21",{"id":102,"property_type":"House","description":"Super budyneczek","date_of_registration":"2001-02-22","property_area":"212","date_of_construction":"1993-12-31","number_of_floors":12,"number_of_rooms":1,"floor":2,"balcony":1,"garage":2,"land_area":"121","country":"Poland","city":"Oswiecim","street":"Dziwakow","street_number":"23","postal_code":"32-600","created_at":"2018-05-29 12:18:49","updated_at":"2018-05-29 12:18:49","advertisement_id":134},{"id":14,"name":"Lukasz","email":"lpazdur07@gmail.com","active":1,"created_at":"2018-05-16 20:32:08","updated_at":"2018-05-16 20:34:45"}]'),
  263. ('advertisements', '136', '[136,"sale",1,null,"2018-05-29","111",1,"2018-05-29 13:37:10","2018-05-29 13:37:30",{"id":104,"property_type":"Flat","description":"1","date_of_registration":"2018-05-03","property_area":"1","date_of_construction":"2018-05-10","number_of_floors":1,"number_of_rooms":1,"floor":1,"balcony":1,"garage":1,"land_area":"1","country":"1","city":"1","street":"1","street_number":"1","postal_code":"32-600","created_at":"2018-05-29 13:37:30","updated_at":"2018-05-29 13:37:30","advertisement_id":136},{"id":1,"name":"admin","email":"admin@admin.com","active":1,"created_at":"2018-04-24 09:26:11","updated_at":"2018-04-24 09:26:11"}]'),
  264. ('advertisements', '137', '[137,"sale",1,null,"2018-05-29","Przedajemy dom",543,"2018-05-29 13:51:18","2018-05-29 13:53:00",{"id":105,"property_type":"House","description":"no co\\u015b tam","date_of_registration":"2018-05-16","property_area":"1231","date_of_construction":"2018-05-15","number_of_floors":1,"number_of_rooms":1,"floor":2,"balcony":3,"garage":1,"land_area":"1231","country":"aknn","city":"nsacfh","street":"sca","street_number":"asdsa","postal_code":"ascq","created_at":"2018-05-29 13:53:00","updated_at":"2018-05-29 13:53:00","advertisement_id":137},{"id":19,"name":"Mateusz","email":"mateuszwojtas@interia.pl","active":1,"created_at":"2018-05-26 15:03:46","updated_at":"2018-05-26 15:05:08"}]'),
  265. ('advertisements', '14', '[14,"sprzeda\\u017c",3,"2018-04-24","opisik",120000,"2018-04-24 11:40:49","2018-05-25 09:07:21"]'),
  266. ('advertisements', '15', '[15,"Wynajem",3,"2014-04-24","DIVY z roksy",666,"2018-04-24 11:43:57","2018-05-25 09:05:02"]'),
  267. ('advertisements', '2', '[2,"sprzeda\\u017c",3,"2018-04-24","opisik",120000,"2018-04-24 11:40:49","2018-05-23 16:07:09"]'),
  268. ('advertisements', '3', '[3,"Wynajem",3,"2014-04-24","DIVY z roksy",666,"2018-04-24 11:43:57","2018-05-06 11:19:46",{"id":2,"property_type":"Dzia\\u0142ka","description":"No zmieniamy dane dzialki","date_of_registration":"2013-05-21","property_area":null,"date_of_construction":null,"number_of_floors":null,"number_of_rooms":null,"floor":null,"balcony":null,"garage":0,"land_area":"666km2","country":"Poland","city":"Oswiecim","street":"Lipowa","street_number":"32","postal_code":"32-600","created_at":"2018-04-24 12:36:08","updated_at":"2018-04-24 13:08:02"}]'),
  269. ('advertisements', '73', '[73,"sprzedaz",2,null,"2023-05-20","jest",20000,"2018-05-23 21:44:04","2018-05-26 14:18:20"]'),
  270. ('advertisements', '77', '[77,"sprzedaz",3,null,"2025-05-20","hehehehe",123,"2018-05-25 12:44:24","2018-05-27 22:43:20"]'),
  271. ('advertisements', '78', '[78,"sprzedaz",3,null,"2025-05-20","asdasd",123,"2018-05-25 12:48:00","2018-05-27 22:43:20"]'),
  272. ('advertisements', '79', '[79,"sale",3,null,"2025-05-20","2",2,"2018-05-25 13:08:11","2018-05-27 22:43:21"]'),
  273. ('advertisements', '8', '[8,"sprzeda\\u017c",1,"2018-04-24","opisik",120000,"2018-04-24 11:40:49","2018-05-06 15:57:59",{"id":1,"property_type":"Dzia\\u0142ka","description":"Dzialka taka o","date_of_registration":"2013-03-02","property_area":null,"date_of_construction":null,"number_of_floors":null,"number_of_rooms":null,"floor":null,"balcony":null,"garage":null,"land_area":"100km2","country":"Poland","city":"Oswiecim","street":"Kwiatowa","street_number":"32","postal_code":"32-600","created_at":"2018-04-24 12:33:56","updated_at":"2018-04-24 12:33:56"}]'),
  274. ('advertisements', '85', '[85,"sprzedaz",0,"2025-05-20","123",123,"2018-05-25 19:02:35","2018-05-25 19:02:54",null]'),
  275. ('advertisements', '86', '[86,"sprzedaz",2,"2025-05-20","1",2,"2018-05-25 19:07:34","2018-05-26 10:20:04"]'),
  276. ('advertisements', '87', '[87,"wynajem",3,null,"2026-05-20","6576",2312,"2018-05-26 10:32:14","2018-05-27 22:44:13"]'),
  277. ('advertisements', '9', '[9,"Wynajem",1,"2014-04-24","DIVY z roksy",666,"2018-04-24 11:43:57","2018-05-06 15:58:05",{"id":2,"property_type":"Dzia\\u0142ka","description":"No zmieniamy dane dzialki","date_of_registration":"2013-05-21","property_area":null,"date_of_construction":null,"number_of_floors":null,"number_of_rooms":null,"floor":null,"balcony":null,"garage":0,"land_area":"666km2","country":"Poland","city":"Oswiecim","street":"Lipowa","street_number":"32","postal_code":"32-600","created_at":"2018-04-24 12:36:08","updated_at":"2018-04-24 13:08:02"}]'),
  278. ('advertisements', '99', '["rent","28.05.2018","sacacasc",0,"100","2018-05-28 07:34:57","2018-05-28 07:34:57",99]');
  279.  
  280. -- --------------------------------------------------------
  281.  
  282. --
  283. -- Struktura tabeli dla tabeli `users`
  284. --
  285.  
  286. CREATE TABLE `users` (
  287. `id` int(10) UNSIGNED NOT NULL,
  288. `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  289. `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  290. `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  291. `active` tinyint(1) NOT NULL,
  292. `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  293. `created_at` timestamp NULL DEFAULT NULL,
  294. `updated_at` timestamp NULL DEFAULT NULL
  295. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  296.  
  297. --
  298. -- Zrzut danych tabeli `users`
  299. --
  300.  
  301. INSERT INTO `users` (`id`, `name`, `email`, `password`, `active`, `remember_token`, `created_at`, `updated_at`) VALUES
  302. (1, 'admin', 'admin@admin.com', '$2y$10$0yWnKuLaHQH3Z8O2s7aqCupiStGPkV5sFiT6t5YKwrJjYO.8oW/Li', 1, NULL, '2018-04-24 07:26:11', '2018-04-24 07:26:11'),
  303. (11, 'kubus', 'jakkoz91@gmail.com', '$2y$10$yi3purIoRyLc6BfGjR7aa.zLw/1TvkvD02sj12wrO7dYbOvfzEoXu', 1, NULL, '2018-05-01 07:41:14', '2018-05-01 07:49:34'),
  304. (14, 'Lukasz', 'lpazdur07@gmail.com', '$2y$10$fRiINPYyPtGuzNELR.b8oOzVtV.dHpMKBR1/qi58uDTh37b6JF3GW', 1, NULL, '2018-05-16 18:32:08', '2018-05-16 18:34:45'),
  305. (22, 'kuba', 'p.kuba1993@gmail.com', '$2y$10$SP4jHdg/pufJAbOf94UxpeOtqaD8d/E3vvcGGvyptWc9PKZoeDL7a', 1, NULL, '2018-05-29 11:54:46', '2018-05-29 11:55:53');
  306.  
  307. --
  308. -- Indeksy dla zrzutów tabel
  309. --
  310.  
  311. --
  312. -- Indexes for table `advertisements`
  313. --
  314. ALTER TABLE `advertisements`
  315. ADD PRIMARY KEY (`id`),
  316. ADD KEY `advertisements_user_id_foreign` (`user_id`);
  317.  
  318. --
  319. -- Indexes for table `migrations`
  320. --
  321. ALTER TABLE `migrations`
  322. ADD PRIMARY KEY (`id`);
  323.  
  324. --
  325. -- Indexes for table `password_resets`
  326. --
  327. ALTER TABLE `password_resets`
  328. ADD KEY `password_resets_email_index` (`email`);
  329.  
  330. --
  331. -- Indexes for table `personal_datas`
  332. --
  333. ALTER TABLE `personal_datas`
  334. ADD PRIMARY KEY (`id`),
  335. ADD KEY `personal_datas_user_id_foreign` (`user_id`);
  336.  
  337. --
  338. -- Indexes for table `photos`
  339. --
  340. ALTER TABLE `photos`
  341. ADD PRIMARY KEY (`id`),
  342. ADD KEY `photos_advertisement_id_foreign` (`advertisement_id`);
  343.  
  344. --
  345. -- Indexes for table `properties`
  346. --
  347. ALTER TABLE `properties`
  348. ADD PRIMARY KEY (`id`),
  349. ADD KEY `property_advertisements_id_foreign` (`advertisement_id`);
  350.  
  351. --
  352. -- Indexes for table `roles`
  353. --
  354. ALTER TABLE `roles`
  355. ADD PRIMARY KEY (`id`);
  356.  
  357. --
  358. -- Indexes for table `role_user`
  359. --
  360. ALTER TABLE `role_user`
  361. ADD PRIMARY KEY (`id`),
  362. ADD KEY `role_user_user_id_foreign` (`user_id`),
  363. ADD KEY `role_user_role_id_foreign` (`role_id`);
  364.  
  365. --
  366. -- Indexes for table `scout_index`
  367. --
  368. ALTER TABLE `scout_index`
  369. ADD UNIQUE KEY `scout_index_index_objectid_unique` (`index`,`objectID`);
  370.  
  371. --
  372. -- Indexes for table `users`
  373. --
  374. ALTER TABLE `users`
  375. ADD PRIMARY KEY (`id`),
  376. ADD UNIQUE KEY `users_email_unique` (`email`);
  377.  
  378. --
  379. -- AUTO_INCREMENT for dumped tables
  380. --
  381.  
  382. --
  383. -- AUTO_INCREMENT dla tabeli `advertisements`
  384. --
  385. ALTER TABLE `advertisements`
  386. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=138;
  387. --
  388. -- AUTO_INCREMENT dla tabeli `migrations`
  389. --
  390. ALTER TABLE `migrations`
  391. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
  392. --
  393. -- AUTO_INCREMENT dla tabeli `personal_datas`
  394. --
  395. ALTER TABLE `personal_datas`
  396. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
  397. --
  398. -- AUTO_INCREMENT dla tabeli `photos`
  399. --
  400. ALTER TABLE `photos`
  401. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=264;
  402. --
  403. -- AUTO_INCREMENT dla tabeli `properties`
  404. --
  405. ALTER TABLE `properties`
  406. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=106;
  407. --
  408. -- AUTO_INCREMENT dla tabeli `roles`
  409. --
  410. ALTER TABLE `roles`
  411. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  412. --
  413. -- AUTO_INCREMENT dla tabeli `role_user`
  414. --
  415. ALTER TABLE `role_user`
  416. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
  417. --
  418. -- AUTO_INCREMENT dla tabeli `users`
  419. --
  420. ALTER TABLE `users`
  421. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
  422. --
  423. -- Ograniczenia dla zrzutów tabel
  424. --
  425.  
  426. --
  427. -- Ograniczenia dla tabeli `advertisements`
  428. --
  429. ALTER TABLE `advertisements`
  430. ADD CONSTRAINT `advertisements_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  431.  
  432. --
  433. -- Ograniczenia dla tabeli `personal_datas`
  434. --
  435. ALTER TABLE `personal_datas`
  436. ADD CONSTRAINT `personal_datas_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  437.  
  438. --
  439. -- Ograniczenia dla tabeli `photos`
  440. --
  441. ALTER TABLE `photos`
  442. ADD CONSTRAINT `photos_advertisement_id_foreign` FOREIGN KEY (`advertisement_id`) REFERENCES `advertisements` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  443.  
  444. --
  445. -- Ograniczenia dla tabeli `properties`
  446. --
  447. ALTER TABLE `properties`
  448. ADD CONSTRAINT `property_advertisements_id_foreign` FOREIGN KEY (`advertisement_id`) REFERENCES `advertisements` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  449.  
  450. --
  451. -- Ograniczenia dla tabeli `role_user`
  452. --
  453. ALTER TABLE `role_user`
  454. ADD CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  455. ADD CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!