API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 3rd, 2016
172
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 18.97 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.5.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: 127.0.0.1
  6. -- Czas generowania: 03 Sty 2016, 14:09
  7. -- Wersja serwera: 10.1.8-MariaDB
  8. -- Wersja PHP: 5.5.30
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8mb4 */;
  18.  
  19. --
  20. -- Baza danych: `anton`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Struktura tabeli dla tabeli `comment`
  27. --
  28.  
  29. CREATE TABLE `comment` (
  30.   `id` int(11) NOT NULL,
  31.   `post_date` date NOT NULL,
  32.   `comment` varchar(150) NOT NULL,
  33.   `post_acceptance` tinyint(1) NOT NULL,
  34.   `user_unique_id_fk` varchar(23) NOT NULL,
  35.   `recipe_unique_id_fk` varchar(23) NOT NULL
  36. ) ENGINE=InnoDB DEFAULT CHARSET=latin2;
  37.  
  38. --
  39. -- Zrzut danych tabeli `comment`
  40. --
  41.  
  42. INSERT INTO `comment` (`id`, `post_date`, `comment`, `post_acceptance`, `user_unique_id_fk`, `recipe_unique_id_fk`) VALUES
  43. (2, '2015-12-31', 'dsadasdasdasd', 1, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  44. (3, '2015-12-31', 'hfghf', 1, '565098d918f160.94675930', '565100c869b006.45533683'),
  45. (4, '2016-01-01', 'Bardzo fajny przepis. Polecam!', 1, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  46. (5, '2016-01-01', 'super przepis', 1, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  47. (6, '2016-01-01', 'xx', 1, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  48. (7, '2016-01-02', 'hffgvc', 1, '565098d918f160.94675930', '565903c0b1d609.67930726'),
  49. (8, '2016-01-02', 'jfsf', 1, '565098d918f160.94675930', '565903c0b1d609.67930726'),
  50. (9, '2016-01-02', 'hfbf', 1, '565098d918f160.94675930', '565100c869b006.45533683'),
  51. (10, '2016-01-02', 'xxx', 1, '565098d918f160.94675930', '565100c869b006.45533683'),
  52. (11, '2016-01-02', 'gsgggsgsgssgsgsggsgsgsgsgshshgsgsgsggshgggsg', 1, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  53. (12, '2016-01-02', 'haha', 1, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  54. (13, '2016-01-02', 'bede', 1, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  55. (14, '2016-01-02', 'gg', 1, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  56. (15, '2016-01-02', 'hfbff', 1, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  57. (16, '2016-01-02', 'bfg', 1, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  58. (17, '2016-01-02', 'gjgg', 1, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  59. (18, '2016-01-02', 'fbf', 1, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  60. (19, '2016-01-02', 'gf', 1, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  61. (20, '2016-01-03', 'Allahu Akbar', 1, '565098d918f160.94675930', '565100c869b006.45533683');
  62.  
  63. -- --------------------------------------------------------
  64.  
  65. --
  66. -- Struktura tabeli dla tabeli `favourite`
  67. --
  68.  
  69. CREATE TABLE `favourite` (
  70.   `id` int(11) NOT NULL,
  71.   `user_unique_id_fk` varchar(23) NOT NULL,
  72.   `recipe_unique_id_fk` varchar(23) NOT NULL
  73. ) ENGINE=InnoDB DEFAULT CHARSET=latin2;
  74.  
  75. --
  76. -- Zrzut danych tabeli `favourite`
  77. --
  78.  
  79. INSERT INTO `favourite` (`id`, `user_unique_id_fk`, `recipe_unique_id_fk`) VALUES
  80. (4, '5650992a961c33.98254196', '565100c869b006.45533683'),
  81. (5, '5650992a961c33.98254196', '5650f91875c1a9.95031530'),
  82. (6, '5650992a961c33.98254196', '5651002e647645.64608919'),
  83. (34, '565096811c0b51.08471830', '5659039745f9a0.99776702'),
  84. (35, '565096811c0b51.08471830', '5650f91875c1a9.95031530'),
  85. (41, '565e6975c401a6.87190339', '565100c869b006.45533683'),
  86. (46, '5665c5bfba9b73.65186397', '5659039745f9a0.99776702'),
  87. (47, '5665c5bfba9b73.65186397', '565903a4c5af40.87636990'),
  88. (174, '565098d918f160.94675930', '565903a4c5af40.87636990'),
  89. (179, '565098d918f160.94675930', '5651002e647645.64608919'),
  90. (180, '565098d918f160.94675930', '565903b955ee43.70286640'),
  91. (181, '565098d918f160.94675930', '565903bd9b8831.00821230'),
  92. (182, '565098d918f160.94675930', '5659039745f9a0.99776702'),
  93. (183, '565098d918f160.94675930', '5659038a7bea68.87391922'),
  94. (184, '565098d918f160.94675930', '565903ad6bbca3.61401243'),
  95. (185, '565098d918f160.94675930', '565903cdbf4740.55243798'),
  96. (187, '565098d918f160.94675930', '565903a1a9de08.61137985'),
  97. (189, '565098d918f160.94675930', '565903c70b1a76.71328189'),
  98. (192, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  99. (193, '565098d918f160.94675930', '565100c869b006.45533683'),
  100. (194, '565098d918f160.94675930', '565903c3eed152.13024639');
  101.  
  102. -- --------------------------------------------------------
  103.  
  104. --
  105. -- Struktura tabeli dla tabeli `like`
  106. --
  107.  
  108. CREATE TABLE `like` (
  109.   `id` int(11) NOT NULL,
  110.   `user_unique_id_fk` varchar(23) NOT NULL,
  111.   `recipe_unique_id_fk` varchar(23) NOT NULL
  112. ) ENGINE=InnoDB DEFAULT CHARSET=latin2;
  113.  
  114. --
  115. -- Zrzut danych tabeli `like`
  116. --
  117.  
  118. INSERT INTO `like` (`id`, `user_unique_id_fk`, `recipe_unique_id_fk`) VALUES
  119. (54, '565098d918f160.94675930', '5659038a7bea68.87391922'),
  120. (58, '565098d918f160.94675930', '565903ad6bbca3.61401243'),
  121. (62, '565098d918f160.94675930', '565903c0b1d609.67930726'),
  122. (65, '565098d918f160.94675930', '5659034a2640d4.19998333'),
  123. (67, '565098d918f160.94675930', '5650f91875c1a9.95031530'),
  124. (68, '565098d918f160.94675930', '565100c869b006.45533683');
  125.  
  126. -- --------------------------------------------------------
  127.  
  128. --
  129. -- Struktura tabeli dla tabeli `recipe`
  130. --
  131.  
  132. CREATE TABLE `recipe` (
  133.   `unique_id` varchar(23) NOT NULL,
  134.   `title` varchar(100) NOT NULL,
  135.   `description` varchar(500) NOT NULL,
  136.   `prep_time` varchar(50) DEFAULT NULL,
  137.   `people_count` int(11) DEFAULT NULL,
  138.   `img_tumbnail_link` varchar(100) NOT NULL,
  139.   `add_date` date NOT NULL,
  140.   `acceptance` tinyint(1) NOT NULL,
  141.   `kitchen_type` varchar(20) NOT NULL,
  142.   `meal_type` varchar(30) NOT NULL,
  143.   `difficulty_lvl` varchar(10) NOT NULL,
  144.   `user_unique_id_fk` varchar(23) NOT NULL
  145. ) ENGINE=InnoDB DEFAULT CHARSET=latin2;
  146.  
  147. --
  148. -- Zrzut danych tabeli `recipe`
  149. --
  150.  
  151. INSERT INTO `recipe` (`unique_id`, `title`, `description`, `prep_time`, `people_count`, `img_tumbnail_link`, `add_date`, `acceptance`, `kitchen_type`, `meal_type`, `difficulty_lvl`, `user_unique_id_fk`) VALUES
  152. ('5650f91875c1a9.95031530', 'Szarlotka', '<i>Opis sposobu wykonania Szarlotki</i><br /><b>gagsag,</b>', 'Około 20 minut', 3, 'http://anton869.linuxpl.eu/recipe_images/szarlotka_z_jablkiem.jpg', '2015-04-22', 1, 'Polska', 'Ciasta', 'łatwy', '565098d918f160.94675930'),
  153. ('5651002e647645.64608919', 'Kotlet mielony po Polsku', 'Opis sposobu wykonania kotleta mielonego', 'W granicach 40 minut', 2, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2015-09-12', 1, 'Polska', 'Dania mięsne', 'łatwy', '5650992a961c33.98254196'),
  154. ('565100c869b006.45533683', 'Naleśniki z serem', 'Opis sposobu wykonania nalesników z serem', 'Ok. 30 minut', 2, 'http://anton869.linuxpl.eu/recipe_images/nalesniki_z_serem.jpg', '2015-10-11', 1, 'Francuska', 'Naleśniki', 'średni', '565098d918f160.94675930'),
  155. ('56590342952536.67184802', 'Azot1', 'Ciekły azot1', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2014-11-22', 1, 'Turecka', 'Ciasta', 'średni', '565098d918f160.94675930'),
  156. ('5659034a2640d4.19998333', 'Azot2', 'Ciekły azot2', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2013-11-22', 1, 'Polska', 'Dania mięsne', 'łatwy', '565098d918f160.94675930'),
  157. ('56590383d343a3.81845640', 'Azot3', 'Ciekły azot3', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2014-12-11', 1, 'Hiszpańska', 'Ciasta', 'średni', '565098d918f160.94675930'),
  158. ('5659038a7bea68.87391922', 'Azot4', 'Ciekły azot4', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2015-10-01', 1, 'Grecka', 'Ciasta', 'trudny', '565098d918f160.94675930'),
  159. ('5659038de528a7.32836467', 'Azot5', 'Ciekły azot5', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2013-10-23', 1, 'Francuska', 'Naleśniki', 'średni', '565098d918f160.94675930'),
  160. ('56590391c66af6.76268516', 'Azot6', 'Ciekły azot6', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2015-07-22', 1, 'Turecka', 'Ciasta', 'łatwy', '565098d918f160.94675930'),
  161. ('5659039745f9a0.99776702', 'Azot7', 'Ciekły azot7', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2015-11-22', 1, 'Grecka', 'Dania mięsne', 'średni', '565098d918f160.94675930'),
  162. ('5659039ae3f310.39380309', 'Azot8', 'Ciekły azot8', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2015-08-22', 1, 'Turecka', 'Ciasta', 'trudny', '565098d918f160.94675930'),
  163. ('5659039e640833.40311578', 'Azot9', 'Ciekły azot9', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2014-07-23', 1, 'Polska', 'Dania mięsne', 'średni', '565098d918f160.94675930'),
  164. ('565903a1a9de08.61137985', 'Azot10', 'Ciekły azot10', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2014-08-22', 1, 'Grecka', 'Ciasta', 'łatwy', '565098d918f160.94675930'),
  165. ('565903a4c5af40.87636990', 'Azot11', 'Ciekły azot11', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2015-10-23', 1, 'Francuska', 'Naleśniki', 'trudny', '565098d918f160.94675930'),
  166. ('565903a89bad53.01475570', 'Azot12', 'Ciekły azot12', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2014-07-22', 1, 'Polska', 'Ciasta', 'łatwy', '565098d918f160.94675930'),
  167. ('565903ad6bbca3.61401243', 'Azot13', 'Ciekły azot13', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2015-09-22', 1, 'Grecka', 'Ciasta', 'średni', '565098d918f160.94675930'),
  168. ('565903b19e2017.48489080', 'Azot14', 'Ciekły azot14', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2015-05-22', 1, 'Hiszpańska', 'Dania mięsne', 'trudny', '565098d918f160.94675930'),
  169. ('565903b5d67bf2.91220662', 'Azot15', 'Ciekły azot15', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2013-06-17', 1, 'Grecka', 'Ciasta', 'łatwy', '565098d918f160.94675930'),
  170. ('565903b955ee43.70286640', 'Azot16', 'Ciekły azot16', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2014-09-17', 1, 'Hiszpańska', 'Naleśniki', 'średni', '565098d918f160.94675930'),
  171. ('565903bd9b8831.00821230', 'Azot17', 'Ciekły azot17', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2014-10-18', 1, 'Polska', 'Ciasta', 'trudny', '565098d918f160.94675930'),
  172. ('565903c0b1d609.67930726', 'Azot18', 'Ciekły azot18', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2015-01-22', 1, 'Francuska', 'Ciasta', 'średni', '565098d918f160.94675930'),
  173. ('565903c3eed152.13024639', 'Azot19', 'Ciekły azot19', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2014-09-21', 1, 'Grecka', 'Naleśniki', 'średni', '565098d918f160.94675930'),
  174. ('565903c70b1a76.71328189', 'Azot20', 'Ciekły azot20', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '2015-04-23', 1, 'Polska', 'Dania mięsne', 'łatwy', '565098d918f160.94675930'),
  175. ('565903ca9fb985.19186296', 'Azot21', 'Ciekły azot', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '1999-11-22', 1, 'Turecka', 'Ciasta', 'średni', '565098d918f160.94675930'),
  176. ('565903cdbf4740.55243798', 'Azot22', 'Ciekły azot', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '1999-11-22', 1, 'Chińska', 'Ciasta', 'średni', '565098d918f160.94675930'),
  177. ('565903d20d7b07.95192289', 'Azot23', 'Ciekły azot', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '1999-11-22', 1, 'ZSRR', 'Ciasta', 'średni', '565098d918f160.94675930'),
  178. ('565903d5afc065.70421031', 'Azot24', 'Ciekły azot', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '1999-11-22', 1, 'ZSRR', 'Ciasta', 'średni', '565098d918f160.94675930'),
  179. ('565903d9529b42.62680267', 'Azot25', 'Ciekły azot', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '1999-11-22', 1, 'ZSRR', 'Ciasta', 'średni', '565098d918f160.94675930'),
  180. ('565903dca89d94.40517960', 'Azot26', 'Ciekły azot', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '1999-11-22', 1, 'ZSRR', 'Ciasta', 'średni', '565098d918f160.94675930'),
  181. ('565903e256a963.07320723', 'Azot27', 'Ciekły azot', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '1999-11-22', 1, 'ZSRR', 'Ciasta', 'średni', '565098d918f160.94675930'),
  182. ('565903e5e4fdd9.48834351', 'Azot28', 'Ciekły azot', '24h na dobe', 3, 'http://anton869.linuxpl.eu/recipe_images/kotlet_mielony_po_polsku.jpg', '1999-11-22', 1, 'ZSRR', 'Ciasta', 'średni', '565098d918f160.94675930');
  183.  
  184. -- --------------------------------------------------------
  185.  
  186. --
  187. -- Struktura tabeli dla tabeli `user`
  188. --
  189.  
  190. CREATE TABLE `user` (
  191.   `unique_id` varchar(23) NOT NULL,
  192.   `email` varchar(100) NOT NULL,
  193.   `encrypted_password` varchar(255) NOT NULL,
  194.   `name` varchar(50) NOT NULL,
  195.   `surname` varchar(50) NOT NULL,
  196.   `created_at` datetime NOT NULL,
  197.   `updated_at` datetime DEFAULT NULL,
  198.   `super_privilage` tinyint(1) NOT NULL
  199. ) ENGINE=InnoDB DEFAULT CHARSET=latin2;
  200.  
  201. --
  202. -- Zrzut danych tabeli `user`
  203. --
  204.  
  205. INSERT INTO `user` (`unique_id`, `email`, `encrypted_password`, `name`, `surname`, `created_at`, `updated_at`, `super_privilage`) VALUES
  206. ('565096811c0b51.08471830', 'sss.sss@ss.ss', '$2y$10$FOkk7uysa.uFz5ob6Nq/D.Cwoh6IYnH/GrjA/0ZFUarIpyr7PMpuW', 'Aaa', 'Bbb', '2015-11-21 17:06:25', NULL, 1),
  207. ('565098d918f160.94675930', 't4underbolt@gmail.com', '$2y$10$rNeEgKGDbrf9RtMw3Zsb6uls/GOJbi/ZYwn3n7MQVqDLDJ94gWjXq', 'Beniamin', 'Abramowicz', '2015-11-21 17:16:25', '2015-12-24 16:13:34', 1),
  208. ('5650992a961c33.98254196', 'mateusz.antoniewski@gmail.com', '$2y$10$gjdoeKt0K5K0huxyFB9vA.s2fq3eitTkB48XcpU3kncBPPoO4DRZC', 'Mateusz', 'Antoniewski', '2015-11-21 17:17:46', NULL, 1),
  209. ('565cbfcadcde80.16308618', 'ccc.ddd@wp.pl', '$2y$10$BAoj82WTY.WKaytmTepIq.iogkMPeqDnX9cbHpM0EelrwxIFYfdMK', 'Ccc', 'Ddd', '2015-11-30 22:29:46', NULL, 1),
  210. ('565cc2402624c5.77851599', 'xxx.xxx@xxx.com', '$2y$10$qiuafewpGb8jLZ4AscUegec31fP/KjkCj3H1/b1dLWf0vmem/iT8K', 'Xxx', 'Xxx', '2015-11-30 22:40:16', NULL, 1),
  211. ('565d7240ee0411.33245447', 'hhddrvi@wpppp.pl', '$2y$10$TRafBtAFiCN.oXRazLsw.Ofmt8TCB.tV2yvz.JxSmJ1U3UC1Ap09O', 'Yyhgiyfc', 'Dygfjdd', '2015-12-01 11:11:13', NULL, 1),
  212. ('565e6975c401a6.87190339', 'anton86993@o2.pl', '$2y$10$/ws6oBgK4LwBpsYG7bfyouZCq6QDmYZB45in8rpPoSfN.YmW3OwFa', 'Mateusz', 'Antoniewski', '2015-12-02 04:45:57', '2015-12-04 02:55:19', 1),
  213. ('5664d7ca5f5f81.99983199', 'andrzej.golota@gmail.com', '$2y$10$g.QqUgOQaKpd83w9kAZ/Y./ADaM5Vo8beCEoThnAPc9ou2FV1Ipq6', 'Andrzej', 'Golota', '2015-12-07 01:50:18', '2015-12-07 01:52:25', 1),
  214. ('5665c5bfba9b73.65186397', 'beni60@wp.pl', '$2y$10$vNvmWzu1lVnVhDsWEGMo.O4L24d1j2JJliQ6zMqGO9n78LidR54eW', 'Twojastara', 'Zapierdala', '2015-12-07 18:45:35', NULL, 1),
  215. ('567604a6563d28.34282525', 'gxghg@hfhgf.pk', '$2y$10$fUOc7Cv0NYwzPU7zIiRhn.k9bMIfNPYvPWoWfRwUn.nd1pOiGZu2.', 'Hgfg', 'Hgmghh', '2015-12-20 02:30:14', NULL, 1),
  216. ('567987d8a9d046.39292655', 'gdgvdd@bfgh.jf', '$2y$10$.US4rQ6Ak5jXvrNucCRtKO30ygg8H8CPzs1zhx2tBYM9thBL.Sq9G', 'Cxx', 'Xcccxgdtff', '2015-12-22 18:26:48', NULL, 1),
  217. ('567b0dbae0fce6.99244236', 'dfht@bfg.kh', '$2y$10$WlPqVw/UZmUDQBBeCFeDfuCGjPVNQG5/pyez9JyTPGePZT78Mo6lG', 'Hfgh', 'Gdhh', '2015-12-23 22:10:18', NULL, 1),
  218. ('567b0e2d3b9f02.62038194', 'vfhvxf@vfg.hc', '$2y$10$4Jm2NuGUvM3ALuMRrD7tC.bicDXefePr6QrdU8amzvDjbSKqzkn4W', 'Ghhfs', 'Gscv', '2015-12-23 22:12:13', NULL, 1),
  219. ('568543adc913c3.53699324', 'vvvv.gfg@gf.jd', '$2y$10$Hd4e2A0i09JIRipAff8.Z.cV9pKbCraGiRzwiUnalU9gSz6glhnAu', 'Bvvvv', 'Vvvvb', '2015-12-31 16:03:09', NULL, 1);
  220.  
  221. --
  222. -- Indeksy dla zrzutĂłw tabel
  223. --
  224.  
  225. --
  226. -- Indexes for table `comment`
  227. --
  228. ALTER TABLE `comment`
  229.   ADD PRIMARY KEY (`id`),
  230.   ADD KEY `user_comment_unique_id_idx` (`user_unique_id_fk`),
  231.   ADD KEY `recipe_comment_unique_id_idx` (`recipe_unique_id_fk`);
  232.  
  233. --
  234. -- Indexes for table `favourite`
  235. --
  236. ALTER TABLE `favourite`
  237.   ADD PRIMARY KEY (`id`),
  238.   ADD KEY `user_favourite_unique_id_idx` (`user_unique_id_fk`),
  239.   ADD KEY `recipe_favourite_unique_id_idx` (`recipe_unique_id_fk`);
  240.  
  241. --
  242. -- Indexes for table `like`
  243. --
  244. ALTER TABLE `like`
  245.   ADD PRIMARY KEY (`id`),
  246.   ADD KEY `user_like_unique_id_idx` (`user_unique_id_fk`),
  247.   ADD KEY `recipe_like_unique_id_idx` (`recipe_unique_id_fk`);
  248.  
  249. --
  250. -- Indexes for table `recipe`
  251. --
  252. ALTER TABLE `recipe`
  253.   ADD PRIMARY KEY (`unique_id`),
  254.   ADD UNIQUE KEY `unique_id_UNIQUE` (`unique_id`);
  255.  
  256. --
  257. -- Indexes for table `user`
  258. --
  259. ALTER TABLE `user`
  260.   ADD PRIMARY KEY (`unique_id`),
  261.   ADD UNIQUE KEY `unique_id_UNIQUE` (`unique_id`);
  262.  
  263. --
  264. -- AUTO_INCREMENT for dumped tables
  265. --
  266.  
  267. --
  268. -- AUTO_INCREMENT dla tabeli `comment`
  269. --
  270. ALTER TABLE `comment`
  271.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
  272. --
  273. -- AUTO_INCREMENT dla tabeli `favourite`
  274. --
  275. ALTER TABLE `favourite`
  276.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=195;
  277. --
  278. -- AUTO_INCREMENT dla tabeli `like`
  279. --
  280. ALTER TABLE `like`
  281.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;
  282. --
  283. -- Ograniczenia dla zrzutĂłw tabel
  284. --
  285.  
  286. --
  287. -- Ograniczenia dla tabeli `comment`
  288. --
  289. ALTER TABLE `comment`
  290.   ADD CONSTRAINT `recipe_comment_unique_id` FOREIGN KEY (`recipe_unique_id_fk`) REFERENCES `recipe` (`unique_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  291.   ADD CONSTRAINT `user_comment_unique_id` FOREIGN KEY (`user_unique_id_fk`) REFERENCES `user` (`unique_id`) ON DELETE CASCADE ON UPDATE CASCADE;
  292.  
  293. --
  294. -- Ograniczenia dla tabeli `favourite`
  295. --
  296. ALTER TABLE `favourite`
  297.   ADD CONSTRAINT `recipe_favourite_unique_id` FOREIGN KEY (`recipe_unique_id_fk`) REFERENCES `recipe` (`unique_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  298.   ADD CONSTRAINT `user_favourite_unique_id` FOREIGN KEY (`user_unique_id_fk`) REFERENCES `user` (`unique_id`) ON DELETE CASCADE ON UPDATE CASCADE;
  299.  
  300. --
  301. -- Ograniczenia dla tabeli `like`
  302. --
  303. ALTER TABLE `like`
  304.   ADD CONSTRAINT `recipe_like_unique_id` FOREIGN KEY (`recipe_unique_id_fk`) REFERENCES `recipe` (`unique_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  305.   ADD CONSTRAINT `user_like_unique_id` FOREIGN KEY (`user_unique_id_fk`) REFERENCES `user` (`unique_id`) ON DELETE CASCADE ON UPDATE CASCADE;
  306.  
  307. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  308. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  309. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
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!