· 7 years ago · Nov 07, 2018, 12:42 AM
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
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET 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--
24CREATE DATABASE IF NOT EXISTS `restful` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
25USE `restful`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `friends`
31--
32
33CREATE 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
45INSERT INTO `friends` (`id`, `name`, `city`, `phone`, `email`) VALUES
46(2, 'Hope', 'Jalandhar (Jullundur)', '060-517-0056', 'semper@nequeIn.ca'),
47(3, 'Merrill', 'Jabbeke', '062-872-8440', 'aliquet@Inscelerisque.com'),
48(4, 'Scott', 'Stamford', '098-800-7431', 'Nullam.feugiat@massanonante.edu'),
49(5, 'Travis', 'Blevio', '051-283-7476', 'Ut.nec@Duiselementum.net'),
50(6, 'Cameran', 'Caruaru', '029-721-5778', 'nulla@dolorelit.org'),
51(7, 'Evangeline', 'Montreal', '037-707-2597', 'amet.ornare.lectus@Morbineque.ca'),
52(8, 'Jin', 'Muridke', '083-761-9301', 'In@sitamet.edu'),
53(9, 'Graiden', 'Warspite', '090-963-8431', 'a.aliquet.vel@semegestas.edu'),
54(10, 'Phyllis', 'Sachs Harbour', '025-124-3352', 'eu@congueIn.net'),
55(11, 'Bruno', 'Laakdal', '074-554-2176', 'Nulla.semper@loremluctusut.org'),
56(12, 'Jasper', 'Coltauco', '015-199-1744', 'adipiscing@molestiesodalesMauris.edu'),
57(13, 'Mark', 'Quimper', '016-927-4469', 'odio@luctusetultrices.ca'),
58(14, 'Haley', 'San Antonio', '018-419-0034', 'a.facilisis.non@dapibusquam.com'),
59(15, 'Margaret', 'Lillianes', '063-246-6175', 'ullamcorper.nisl.arcu@egetvolutpat.org'),
60(16, 'Walter', 'Souvret', '039-218-8416', 'malesuada@rhoncus.net'),
61(17, 'Barbara', 'Timaukel', '030-192-0610', 'non@ligulaNullam.org'),
62(18, 'Rebekah', 'Nancy', '005-706-4301', 'blandit.at.nisi@feugiat.ca'),
63(19, 'Zachary', 'Suarlee', '073-841-5585', 'ipsum.nunc.id@ligulatortordictum.net'),
64(20, 'Rogan', 'Surbo', '087-455-9762', 'interdum@auguescelerisque.org'),
65(21, 'Iola', 'Penticton', '012-037-5823', 'orci.consectetuer.euismod@nibhlaciniaorci.org'),
66(22, 'Vivien', 'Noragugume', '052-549-7195', 'mattis.ornare@lectus.net'),
67(23, 'Troy', 'Avelgem', '043-298-6792', 'montes@ligulaDonecluctus.co.uk'),
68(24, 'Valentine', 'Bamberg', '002-919-3918', 'vitae@Nam.co.uk'),
69(25, 'Justin', 'Fairbanks', '021-177-9769', 'Pellentesque.ultricies@justoeu.edu'),
70(26, 'Tanisha', 'Taber', '063-974-6183', 'diam.dictum.sapien@montesnascetur.net'),
71(27, 'Alana', 'Ruddervoorde', '010-596-5451', 'vulputate.dui@massaQuisqueporttitor.com'),
72(28, 'Rylee', 'Limena', '068-391-6763', 'non.ante.bibendum@nonsollicitudin.ca'),
73(29, 'Sage', 'Hawick', '045-622-7649', 'Aliquam@nulla.org'),
74(30, 'Calvin', 'Innsbruck', '033-603-0924', 'lorem@Praesentinterdumligula.co.uk'),
75(31, 'Kasper', 'Red Deer', '068-846-1911', 'erat.volutpat.Nulla@Maurisquisturpis.com'),
76(32, 'Ali', 'Caprauna', '084-929-8538', 'Donec.luctus.aliquet@nisi.net'),
77(33, 'Jasper', 'Çeşme', '064-923-0423', 'sed.leo.Cras@Nuncsedorci.com'),
78(34, 'Randall', 'Osasco', '095-991-0323', 'sit.amet@porttitor.ca'),
79(35, 'Caesar', 'Bergama', '080-670-6915', 'eleifend.nunc@Proin.ca'),
80(36, 'Ishmael', 'San Cesario di Lecce', '031-498-2978', 'Duis@metusvitaevelit.org'),
81(37, 'Nomlanga', 'New Orleans', '039-536-0730', 'Ut.semper@habitant.net'),
82(38, 'Bruce', 'Patarrá', '081-914-0523', 'Integer.eu@estNunclaoreet.ca'),
83(39, 'Lance', 'Notre-Dame-du-Nord', '040-786-3733', 'lectus@sociisnatoque.co.uk'),
84(40, 'Petra', 'Assen', '071-099-4062', 'quam.quis.diam@gravidamolestie.ca'),
85(41, 'Yael', 'Scarborough', '043-920-4625', 'Nunc.sed.orci@et.com'),
86(42, 'Travis', 'Farrukhabad-cum-Fatehgarh', '088-982-7889', 'dictum.placerat.augue@inceptoshymenaeosMauris.ca'),
87(43, 'Tarik', 'BailiÂvre', '010-546-3863', 'molestie.orci@gravida.edu'),
88(44, 'Kennan', 'Acosse', '030-191-7974', 'Maecenas.iaculis.aliquet@mollislectus.ca'),
89(45, 'Fatima', 'Schiltigheim', '059-430-2593', 'cursus.et.magna@nislelementum.ca'),
90(46, 'Ray', 'Embourg', '050-513-0686', 'dui@arcuSed.co.uk'),
91(47, 'Linus', 'Saint-Herblain', '048-833-4030', 'Etiam.imperdiet@erat.net'),
92(48, 'Patricia', 'Mainz', '096-878-7249', 'Proin@odioEtiamligula.ca'),
93(49, 'Amal', 'Termoli', '019-982-3210', 'velit.in.aliquet@sit.com'),
94(50, 'Tate', 'Çermik', '009-250-3997', 'interdum.Curabitur@lacusvestibulum.org'),
95(51, 'Rhona', 'Warwick', '006-025-7174', 'pharetra@liberoat.net'),
96(52, 'Kylynn', 'Villa Latina', '083-896-6039', 'tortor@velit.edu'),
97(53, 'Abel', 'Arbroath', '024-697-6489', 'Vestibulum.accumsan@imperdietnonvestibulum.org'),
98(54, 'Buckminster', 'Sefro', '019-434-9370', 'Maecenas@eu.net'),
99(55, 'Travis', 'Ancarano', '026-463-5471', 'ut@volutpat.edu'),
100(56, 'Leilani', 'Dornbirn', '005-412-9641', 'quam.a.felis@Integerurna.net'),
101(57, 'Odette', 'Dunfermline', '008-697-4721', 'velit.Pellentesque.ultricies@anteiaculisnec.net'),
102(58, 'Giselle', 'Nadrin', '093-972-0861', 'scelerisque.lorem@velvulputateeu.net'),
103(59, 'Hop', 'Port Moody', '019-545-4051', 'luctus.Curabitur.egestas@consequatenim.edu'),
104(60, 'Brendan', 'Athus', '029-672-1028', 'pede.sagittis.augue@atlacus.org'),
105(61, 'Seth', 'Gosnells', '017-698-6621', 'pharetra@lorem.com'),
106(62, 'Isaac', 'Tirunelveli', '079-223-9487', 'augue.porttitor@In.ca'),
107(63, 'Reece', 'Melbourne', '059-342-6698', 'sociis.natoque@asollicitudinorci.edu'),
108(64, 'Keegan', 'Lebbeke', '002-950-8914', 'dolor.vitae.dolor@Integer.com'),
109(65, 'Ora', 'Camponogara', '029-280-5561', 'adipiscing.ligula@auctorquistristique.com'),
110(66, 'Jescie', 'Oxford County', '073-015-7038', 'vel@dui.co.uk'),
111(67, 'Colt', 'Rothes', '063-593-9628', 'id.blandit@enimEtiamgravida.org'),
112(68, 'Ivan', 'Garbsen', '026-814-1669', 'est.Nunc.ullamcorper@sedpedenec.ca'),
113(69, 'Dylan', 'Ambala Sadar', '025-930-4123', 'arcu@ametmassa.com'),
114(70, 'Cadman', 'Minderhout', '063-543-3478', 'nisl.Quisque@dapibusrutrumjusto.com'),
115(71, 'Cassandra', 'Borgomasino', '072-565-5993', 'aliquet.magna@tellusNunclectus.net'),
116(72, 'Maggy', 'Milano', '034-087-2196', 'porta.elit.a@commodo.edu'),
117(73, 'Jasmine', 'Saint-Marc', '049-056-4335', 'dolor.Nulla.semper@malesuadafamesac.ca'),
118(74, 'Francesca', 'Racine', '053-018-2706', 'dis.parturient@Donec.net'),
119(75, 'Hakeem', 'Dendermonde', '068-098-3574', 'ridiculus.mus@leoelementumsem.net'),
120(76, 'Quon', 'Ananindeua', '077-302-9342', 'eu@turpisegestas.net'),
121(77, 'Adria', 'Jönköping', '040-316-9401', 'justo@nequevitaesemper.com'),
122(78, 'Suki', 'Columbus', '078-958-3119', 'Duis.a.mi@vitaeeratVivamus.com'),
123(79, 'Doris', 'Olcenengo', '075-589-4711', 'sit@Aliquamfringilla.ca'),
124(80, 'Octavia', 'Redruth', '080-139-1716', 'leo.Morbi.neque@lacusEtiambibendum.edu'),
125(81, 'Uma', 'Montone', '088-707-9526', 'augue.malesuada@magnaPhasellusdolor.net'),
126(82, 'Violet', 'Brecon', '020-903-9269', 'tempus.lorem@aliquet.net'),
127(83, 'Geoffrey', 'Cache Creek', '035-078-4451', 'convallis.erat@sagittissemperNam.co.uk'),
128(84, 'Violet', 'Ville de Maniwaki', '029-207-7104', 'augue@Nulla.org'),
129(85, 'Imani', 'Campbelltown', '011-712-0089', 'egestas.lacinia@magnaSuspendisse.net'),
130(86, 'Blake', 'Hoorn', '016-339-9196', 'commodo.auctor@nonsollicitudin.net'),
131(87, 'Marvin', 'Rocca d\'Arce', '060-320-8699', 'fringilla.purus.mauris@Nuncquisarcu.ca'),
132(88, 'Phillip', 'Grande Prairie', '061-314-6758', 'leo.elementum@nuncnullavulputate.edu'),
133(89, 'Allegra', 'Grand Rapids', '027-524-8083', 'Cras.convallis.convallis@quamCurabitur.org'),
134(90, 'Scarlet', 'Villa Faraldi', '023-796-0412', 'sem.magna.nec@sagittis.net'),
135(91, 'Josiah', 'Gontrode', '069-444-0420', 'enim.consequat.purus@acturpisegestas.ca'),
136(92, 'Stewart', 'Kilwinning', '003-108-6476', 'lorem.ac.risus@dolorsitamet.edu'),
137(93, 'Paki', 'Lakewood', '095-826-3767', 'velit.justo@Phasellusvitae.ca'),
138(94, 'Mollie', 'Montrose', '070-842-2708', 'Etiam@idmagnaet.net'),
139(95, 'Orli', 'Lustin', '011-852-3293', 'turpis.egestas@luctuset.net'),
140(96, 'Deborah', 'Belford Roxo', '051-979-7440', 'ultrices@malesuadamalesuada.org'),
141(97, 'Jarrod', 'Deschambault', '088-794-4402', 'vestibulum@Aenean.co.uk'),
142(98, 'Clayton', 'Froidchapelle', '094-496-0694', 'Nam@scelerisquescelerisque.com'),
143(99, 'Ferris', 'Cap-de-la-Madeleine', '042-439-5546', 'tempus.non.lacinia@elit.net');
144
145--
146-- Indexes for dumped tables
147--
148
149--
150-- Indexes for table `friends`
151--
152ALTER 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--
162ALTER TABLE `friends`
163 MODIFY `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;
164COMMIT;
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 */;