asimryu

restful api sql

Nov 13th, 2018
322
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 9.22 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.7.4
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Sep 14, 2018 at 01:10 AM
  7. -- Server version: 10.1.28-MariaDB
  8. -- PHP Version: 7.1.10
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  13. SET time_zone = "+00:00";
  14.  
  15.  
  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  19. /*!40101 SET NAMES utf8mb4 */;
  20.  
  21. --
  22. -- Database: `restful`
  23. --
  24. CREATE DATABASE IF NOT EXISTS `restful` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
  25. USE `restful`;
  26.  
  27. -- --------------------------------------------------------
  28.  
  29. --
  30. -- Table structure for table `friends`
  31. --
  32.  
  33. CREATE TABLE `friends` (
  34.   `id` mediumint(8) UNSIGNED NOT NULL,
  35.   `name` VARCHAR(255) DEFAULT NULL,
  36.   `city` VARCHAR(255) DEFAULT NULL,
  37.   `phone` VARCHAR(100) DEFAULT NULL,
  38.   `email` VARCHAR(255) DEFAULT NULL
  39. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  40.  
  41. --
  42. -- Dumping data for table `friends`
  43. --
  44.  
  45. INSERT INTO `friends` (`id`, `name`, `city`, `phone`, `email`) VALUES
  46. (2, 'Hope', 'Jalandhar (Jullundur)', '060-517-0056', '[email protected]'),
  47. (3, 'Merrill', 'Jabbeke', '062-872-8440', '[email protected]'),
  48. (4, 'Scott', 'Stamford', '098-800-7431', '[email protected]'),
  49. (5, 'Travis', 'Blevio', '051-283-7476', '[email protected]'),
  50. (6, 'Cameran', 'Caruaru', '029-721-5778', '[email protected]'),
  51. (7, 'Evangeline', 'Montreal', '037-707-2597', '[email protected]'),
  52. (8, 'Jin', 'Muridke', '083-761-9301', '[email protected]'),
  53. (9, 'Graiden', 'Warspite', '090-963-8431', '[email protected]'),
  54. (10, 'Phyllis', 'Sachs Harbour', '025-124-3352', '[email protected]'),
  55. (11, 'Bruno', 'Laakdal', '074-554-2176', '[email protected]'),
  56. (12, 'Jasper', 'Coltauco', '015-199-1744', '[email protected]'),
  57. (13, 'Mark', 'Quimper', '016-927-4469', '[email protected]'),
  58. (14, 'Haley', 'San Antonio', '018-419-0034', '[email protected]'),
  59. (15, 'Margaret', 'Lillianes', '063-246-6175', '[email protected]'),
  60. (16, 'Walter', 'Souvret', '039-218-8416', '[email protected]'),
  61. (17, 'Barbara', 'Timaukel', '030-192-0610', '[email protected]'),
  62. (18, 'Rebekah', 'Nancy', '005-706-4301', '[email protected]'),
  63. (19, 'Zachary', 'Suarlee', '073-841-5585', '[email protected]'),
  64. (20, 'Rogan', 'Surbo', '087-455-9762', '[email protected]'),
  65. (21, 'Iola', 'Penticton', '012-037-5823', '[email protected]'),
  66. (22, 'Vivien', 'Noragugume', '052-549-7195', '[email protected]'),
  67. (23, 'Troy', 'Avelgem', '043-298-6792', '[email protected]'),
  68. (24, 'Valentine', 'Bamberg', '002-919-3918', '[email protected]'),
  69. (25, 'Justin', 'Fairbanks', '021-177-9769', '[email protected]'),
  70. (26, 'Tanisha', 'Taber', '063-974-6183', '[email protected]'),
  71. (27, 'Alana', 'Ruddervoorde', '010-596-5451', '[email protected]'),
  72. (28, 'Rylee', 'Limena', '068-391-6763', '[email protected]'),
  73. (29, 'Sage', 'Hawick', '045-622-7649', '[email protected]'),
  74. (30, 'Calvin', 'Innsbruck', '033-603-0924', '[email protected]'),
  75. (31, 'Kasper', 'Red Deer', '068-846-1911', '[email protected]'),
  76. (32, 'Ali', 'Caprauna', '084-929-8538', '[email protected]'),
  77. (33, 'Jasper', 'Çeşme', '064-923-0423', '[email protected]'),
  78. (34, 'Randall', 'Osasco', '095-991-0323', '[email protected]'),
  79. (35, 'Caesar', 'Bergama', '080-670-6915', '[email protected]'),
  80. (36, 'Ishmael', 'San Cesario di Lecce', '031-498-2978', '[email protected]'),
  81. (37, 'Nomlanga', 'New Orleans', '039-536-0730', '[email protected]'),
  82. (38, 'Bruce', 'Patarrá', '081-914-0523', '[email protected]'),
  83. (39, 'Lance', 'Notre-Dame-du-Nord', '040-786-3733', '[email protected]'),
  84. (40, 'Petra', 'Assen', '071-099-4062', '[email protected]'),
  85. (41, 'Yael', 'Scarborough', '043-920-4625', '[email protected]'),
  86. (42, 'Travis', 'Farrukhabad-cum-Fatehgarh', '088-982-7889', '[email protected]'),
  87. (43, 'Tarik', 'Bailivre', '010-546-3863', '[email protected]'),
  88. (44, 'Kennan', 'Acosse', '030-191-7974', '[email protected]'),
  89. (45, 'Fatima', 'Schiltigheim', '059-430-2593', '[email protected]'),
  90. (46, 'Ray', 'Embourg', '050-513-0686', '[email protected]'),
  91. (47, 'Linus', 'Saint-Herblain', '048-833-4030', '[email protected]'),
  92. (48, 'Patricia', 'Mainz', '096-878-7249', '[email protected]'),
  93. (49, 'Amal', 'Termoli', '019-982-3210', '[email protected]'),
  94. (50, 'Tate', 'Çermik', '009-250-3997', '[email protected]'),
  95. (51, 'Rhona', 'Warwick', '006-025-7174', '[email protected]'),
  96. (52, 'Kylynn', 'Villa Latina', '083-896-6039', '[email protected]'),
  97. (53, 'Abel', 'Arbroath', '024-697-6489', '[email protected]'),
  98. (54, 'Buckminster', 'Sefro', '019-434-9370', '[email protected]'),
  99. (55, 'Travis', 'Ancarano', '026-463-5471', '[email protected]'),
  100. (56, 'Leilani', 'Dornbirn', '005-412-9641', '[email protected]'),
  101. (57, 'Odette', 'Dunfermline', '008-697-4721', '[email protected]'),
  102. (58, 'Giselle', 'Nadrin', '093-972-0861', '[email protected]'),
  103. (59, 'Hop', 'Port Moody', '019-545-4051', '[email protected]'),
  104. (60, 'Brendan', 'Athus', '029-672-1028', '[email protected]'),
  105. (61, 'Seth', 'Gosnells', '017-698-6621', '[email protected]'),
  106. (62, 'Isaac', 'Tirunelveli', '079-223-9487', '[email protected]'),
  107. (63, 'Reece', 'Melbourne', '059-342-6698', '[email protected]'),
  108. (64, 'Keegan', 'Lebbeke', '002-950-8914', '[email protected]'),
  109. (65, 'Ora', 'Camponogara', '029-280-5561', '[email protected]'),
  110. (66, 'Jescie', 'Oxford County', '073-015-7038', '[email protected]'),
  111. (67, 'Colt', 'Rothes', '063-593-9628', '[email protected]'),
  112. (68, 'Ivan', 'Garbsen', '026-814-1669', '[email protected]'),
  113. (69, 'Dylan', 'Ambala Sadar', '025-930-4123', '[email protected]'),
  114. (70, 'Cadman', 'Minderhout', '063-543-3478', '[email protected]'),
  115. (71, 'Cassandra', 'Borgomasino', '072-565-5993', '[email protected]'),
  116. (72, 'Maggy', 'Milano', '034-087-2196', '[email protected]'),
  117. (73, 'Jasmine', 'Saint-Marc', '049-056-4335', '[email protected]'),
  118. (74, 'Francesca', 'Racine', '053-018-2706', '[email protected]'),
  119. (75, 'Hakeem', 'Dendermonde', '068-098-3574', '[email protected]'),
  120. (76, 'Quon', 'Ananindeua', '077-302-9342', '[email protected]'),
  121. (77, 'Adria', 'Jönköping', '040-316-9401', '[email protected]'),
  122. (78, 'Suki', 'Columbus', '078-958-3119', '[email protected]'),
  123. (79, 'Doris', 'Olcenengo', '075-589-4711', '[email protected]'),
  124. (80, 'Octavia', 'Redruth', '080-139-1716', '[email protected]'),
  125. (81, 'Uma', 'Montone', '088-707-9526', '[email protected]'),
  126. (82, 'Violet', 'Brecon', '020-903-9269', '[email protected]'),
  127. (83, 'Geoffrey', 'Cache Creek', '035-078-4451', '[email protected]'),
  128. (84, 'Violet', 'Ville de Maniwaki', '029-207-7104', '[email protected]'),
  129. (85, 'Imani', 'Campbelltown', '011-712-0089', '[email protected]'),
  130. (86, 'Blake', 'Hoorn', '016-339-9196', '[email protected]'),
  131. (87, 'Marvin', 'Rocca d\'Arce', '060-320-8699', '[email protected]'),
  132. (88, 'Phillip', 'Grande Prairie', '061-314-6758', '[email protected]'),
  133. (89, 'Allegra', 'Grand Rapids', '027-524-8083', '[email protected]'),
  134. (90, 'Scarlet', 'Villa Faraldi', '023-796-0412', '[email protected]'),
  135. (91, 'Josiah', 'Gontrode', '069-444-0420', '[email protected]'),
  136. (92, 'Stewart', 'Kilwinning', '003-108-6476', '[email protected]'),
  137. (93, 'Paki', 'Lakewood', '095-826-3767', '[email protected]'),
  138. (94, 'Mollie', 'Montrose', '070-842-2708', '[email protected]'),
  139. (95, 'Orli', 'Lustin', '011-852-3293', '[email protected]'),
  140. (96, 'Deborah', 'Belford Roxo', '051-979-7440', '[email protected]'),
  141. (97, 'Jarrod', 'Deschambault', '088-794-4402', '[email protected]'),
  142. (98, 'Clayton', 'Froidchapelle', '094-496-0694', '[email protected]'),
  143. (99, 'Ferris', 'Cap-de-la-Madeleine', '042-439-5546', '[email protected]');
  144.  
  145. --
  146. -- Indexes for dumped tables
  147. --
  148.  
  149. --
  150. -- Indexes for table `friends`
  151. --
  152. ALTER TABLE `friends`
  153.   ADD PRIMARY KEY (`id`);
  154.  
  155. --
  156. -- AUTO_INCREMENT for dumped tables
  157. --
  158.  
  159. --
  160. -- AUTO_INCREMENT for table `friends`
  161. --
  162. ALTER TABLE `friends`
  163.   MODIFY `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;
  164. COMMIT;
  165.  
  166. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  167. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  168. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment