· 7 years ago · Jan 25, 2019, 02:24 AM
1-- phpMyAdmin SQL Dump
2-- version 4.8.3
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- ìƒì„± 시간: 19-01-23 07:55
7-- 서버 ë²„ì „: 10.1.35-MariaDB
8-- PHP ë²„ì „: 7.2.9
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-- ë°ì´í„°ë² ì´ìŠ¤: `restful`
23--
24CREATE DATABASE IF NOT EXISTS `restful` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
25USE `restful`;
26
27-- --------------------------------------------------------
28
29--
30-- í…Œì´ë¸” 구조 `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 `photo` varchar(50) NOT NULL
40) ENGINE=InnoDB DEFAULT CHARSET=utf8;
41
42--
43-- í…Œì´ë¸”ì˜ ë¤í”„ ë°ì´í„° `friends`
44--
45
46INSERT INTO `friends` (`id`, `name`, `city`, `phone`, `email`, `photo`) VALUES
47(4, 'Scott', 'Stamford', '098-800-7431', 'Nullam.feugiat@massanonante.edu', ''),
48(5, 'Travis', 'Blevio', '051-283-7476', 'Ut.nec@Duiselementum.net', ''),
49(6, 'Cameran', 'Caruaru', '029-721-5778', 'nulla@dolorelit.org', ''),
50(7, 'Evangeline', 'Montreal', '037-707-2597', 'amet.ornare.lectus@Morbineque.ca', ''),
51(8, 'Jin', 'Muridke', '083-761-9301', 'In@sitamet.edu', ''),
52(9, 'Graiden', 'Warspite', '090-963-8431', 'a.aliquet.vel@semegestas.edu', ''),
53(10, 'Phyllis', 'Sachs Harbour', '025-124-3352', 'eu@congueIn.net', ''),
54(11, 'Bruno', 'Laakdal', '074-554-2176', 'Nulla.semper@loremluctusut.org', ''),
55(12, 'Jasper', 'Coltauco', '015-199-1744', 'adipiscing@molestiesodalesMauris.edu', ''),
56(13, 'Mark', 'Quimper', '016-927-4469', 'odio@luctusetultrices.ca', ''),
57(14, 'Haley', 'San Antonio', '018-419-0034', 'a.facilisis.non@dapibusquam.com', ''),
58(15, 'Margaret', 'Lillianes', '063-246-6175', 'ullamcorper.nisl.arcu@egetvolutpat.org', ''),
59(16, 'Walter', 'Souvret', '039-218-8416', 'malesuada@rhoncus.net', ''),
60(17, 'Barbara', 'Timaukel', '030-192-0610', 'non@ligulaNullam.org', ''),
61(18, 'Rebekah', 'Nancy', '005-706-4301', 'blandit.at.nisi@feugiat.ca', ''),
62(19, 'Zachary', 'Suarlee', '073-841-5585', 'ipsum.nunc.id@ligulatortordictum.net', ''),
63(20, 'Rogan', 'Surbo', '087-455-9762', 'interdum@auguescelerisque.org', ''),
64(21, 'Iola', 'Penticton', '012-037-5823', 'orci.consectetuer.euismod@nibhlaciniaorci.org', ''),
65(22, 'Vivien', 'Noragugume', '052-549-7195', 'mattis.ornare@lectus.net', ''),
66(23, 'Troy', 'Avelgem', '043-298-6792', 'montes@ligulaDonecluctus.co.uk', ''),
67(24, 'Valentine', 'Bamberg', '002-919-3918', 'vitae@Nam.co.uk', ''),
68(25, 'Justin', 'Fairbanks', '021-177-9769', 'Pellentesque.ultricies@justoeu.edu', ''),
69(26, 'Tanisha', 'Taber', '063-974-6183', 'diam.dictum.sapien@montesnascetur.net', ''),
70(27, 'Alana', 'Ruddervoorde', '010-596-5451', 'vulputate.dui@massaQuisqueporttitor.com', ''),
71(28, 'Rylee', 'Limena', '068-391-6763', 'non.ante.bibendum@nonsollicitudin.ca', ''),
72(29, 'Sage', 'Hawick', '045-622-7649', 'Aliquam@nulla.org', ''),
73(30, 'Calvin', 'Innsbruck', '033-603-0924', 'lorem@Praesentinterdumligula.co.uk', ''),
74(31, 'Kasper', 'Red Deer', '068-846-1911', 'erat.volutpat.Nulla@Maurisquisturpis.com', ''),
75(32, 'Ali', 'Caprauna', '084-929-8538', 'Donec.luctus.aliquet@nisi.net', ''),
76(33, 'Jasper', 'Çeşme', '064-923-0423', 'sed.leo.Cras@Nuncsedorci.com', ''),
77(34, 'Randall', 'Osasco', '095-991-0323', 'sit.amet@porttitor.ca', ''),
78(35, 'Caesar', 'Bergama', '080-670-6915', 'eleifend.nunc@Proin.ca', ''),
79(36, 'Ishmael', 'San Cesario di Lecce', '031-498-2978', 'Duis@metusvitaevelit.org', ''),
80(37, 'Nomlanga', 'New Orleans', '039-536-0730', 'Ut.semper@habitant.net', ''),
81(38, 'Bruce', 'Patarrá', '081-914-0523', 'Integer.eu@estNunclaoreet.ca', ''),
82(39, 'Lance', 'Notre-Dame-du-Nord', '040-786-3733', 'lectus@sociisnatoque.co.uk', ''),
83(40, 'Petra', 'Assen', '071-099-4062', 'quam.quis.diam@gravidamolestie.ca', ''),
84(41, 'Yael', 'Scarborough', '043-920-4625', 'Nunc.sed.orci@et.com', ''),
85(42, 'Travis', 'Farrukhabad-cum-Fatehgarh', '088-982-7889', 'dictum.placerat.augue@inceptoshymenaeosMauris.ca', ''),
86(43, 'Tarik', 'BailiÂvre', '010-546-3863', 'molestie.orci@gravida.edu', ''),
87(44, 'Kennan', 'Acosse', '030-191-7974', 'Maecenas.iaculis.aliquet@mollislectus.ca', ''),
88(45, 'Fatima', 'Schiltigheim', '059-430-2593', 'cursus.et.magna@nislelementum.ca', ''),
89(46, 'Ray', 'Embourg', '050-513-0686', 'dui@arcuSed.co.uk', ''),
90(47, 'Linus', 'Saint-Herblain', '048-833-4030', 'Etiam.imperdiet@erat.net', ''),
91(48, 'Patricia', 'Mainz', '096-878-7249', 'Proin@odioEtiamligula.ca', ''),
92(49, 'Amal', 'Termoli', '019-982-3210', 'velit.in.aliquet@sit.com', ''),
93(50, 'Tate', 'Çermik', '009-250-3997', 'interdum.Curabitur@lacusvestibulum.org', ''),
94(51, 'Rhona', 'Warwick', '006-025-7174', 'pharetra@liberoat.net', ''),
95(52, 'Kylynn', 'Villa Latina', '083-896-6039', 'tortor@velit.edu', ''),
96(53, 'Abel', 'Arbroath', '024-697-6489', 'Vestibulum.accumsan@imperdietnonvestibulum.org', ''),
97(54, 'Buckminster', 'Sefro', '019-434-9370', 'Maecenas@eu.net', ''),
98(55, 'Travis', 'Ancarano', '026-463-5471', 'ut@volutpat.edu', ''),
99(56, 'Leilani', 'Dornbirn', '005-412-9641', 'quam.a.felis@Integerurna.net', ''),
100(57, 'Odette', 'Dunfermline', '008-697-4721', 'velit.Pellentesque.ultricies@anteiaculisnec.net', ''),
101(58, 'Giselle', 'Nadrin', '093-972-0861', 'scelerisque.lorem@velvulputateeu.net', ''),
102(59, 'Hop', 'Port Moody', '019-545-4051', 'luctus.Curabitur.egestas@consequatenim.edu', ''),
103(60, 'Brendan', 'Athus', '029-672-1028', 'pede.sagittis.augue@atlacus.org', ''),
104(61, 'Seth', 'Gosnells', '017-698-6621', 'pharetra@lorem.com', ''),
105(62, 'Isaac', 'Tirunelveli', '079-223-9487', 'augue.porttitor@In.ca', ''),
106(63, 'Reece', 'Melbourne', '059-342-6698', 'sociis.natoque@asollicitudinorci.edu', ''),
107(64, 'Keegan', 'Lebbeke', '002-950-8914', 'dolor.vitae.dolor@Integer.com', ''),
108(65, 'Ora', 'Camponogara', '029-280-5561', 'adipiscing.ligula@auctorquistristique.com', ''),
109(66, 'Jescie', 'Oxford County', '073-015-7038', 'vel@dui.co.uk', ''),
110(67, 'Colt', 'Rothes', '063-593-9628', 'id.blandit@enimEtiamgravida.org', ''),
111(68, 'Ivan', 'Garbsen', '026-814-1669', 'est.Nunc.ullamcorper@sedpedenec.ca', ''),
112(69, 'Dylan', 'Ambala Sadar', '025-930-4123', 'arcu@ametmassa.com', ''),
113(70, 'Cadman', 'Minderhout', '063-543-3478', 'nisl.Quisque@dapibusrutrumjusto.com', ''),
114(71, 'Cassandra', 'Borgomasino', '072-565-5993', 'aliquet.magna@tellusNunclectus.net', ''),
115(72, 'Maggy', 'Milano', '034-087-2196', 'porta.elit.a@commodo.edu', ''),
116(73, 'Jasmine', 'Saint-Marc', '049-056-4335', 'dolor.Nulla.semper@malesuadafamesac.ca', ''),
117(74, 'Francesca', 'Racine', '053-018-2706', 'dis.parturient@Donec.net', ''),
118(75, 'Hakeem', 'Dendermonde', '068-098-3574', 'ridiculus.mus@leoelementumsem.net', ''),
119(76, 'Quon', 'Ananindeua', '077-302-9342', 'eu@turpisegestas.net', ''),
120(77, 'Adria', 'Jönköping', '040-316-9401', 'justo@nequevitaesemper.com', ''),
121(78, 'Suki', 'Columbus', '078-958-3119', 'Duis.a.mi@vitaeeratVivamus.com', ''),
122(79, 'Doris', 'Olcenengo', '075-589-4711', 'sit@Aliquamfringilla.ca', ''),
123(80, 'Octavia', 'Redruth', '080-139-1716', 'leo.Morbi.neque@lacusEtiambibendum.edu', ''),
124(81, 'Uma', 'Montone', '088-707-9526', 'augue.malesuada@magnaPhasellusdolor.net', ''),
125(82, 'Violet', 'Brecon', '020-903-9269', 'tempus.lorem@aliquet.net', ''),
126(83, 'Geoffrey', 'Cache Creek', '035-078-4451', 'convallis.erat@sagittissemperNam.co.uk', ''),
127(84, 'Violet', 'Ville de Maniwaki', '029-207-7104', 'augue@Nulla.org', ''),
128(85, 'Imani', 'Campbelltown', '011-712-0089', 'egestas.lacinia@magnaSuspendisse.net', ''),
129(86, 'Blake', 'Hoorn', '016-339-9196', 'commodo.auctor@nonsollicitudin.net', ''),
130(87, 'Marvin', 'Rocca d\'Arce', '060-320-8699', 'fringilla.purus.mauris@Nuncquisarcu.ca', ''),
131(88, 'Phillip', 'Grande Prairie', '061-314-6758', 'leo.elementum@nuncnullavulputate.edu', ''),
132(89, 'Allegra', 'Grand Rapids', '027-524-8083', 'Cras.convallis.convallis@quamCurabitur.org', ''),
133(90, 'Scarlet', 'Villa Faraldi', '023-796-0412', 'sem.magna.nec@sagittis.net', ''),
134(91, 'Josiah', 'Gontrode', '069-444-0420', 'enim.consequat.purus@acturpisegestas.ca', ''),
135(92, 'Stewart', 'Kilwinning', '003-108-6476', 'lorem.ac.risus@dolorsitamet.edu', ''),
136(93, 'Paki', 'Lakewood', '095-826-3767', 'velit.justo@Phasellusvitae.ca', ''),
137(94, 'Mollie', 'Montrose', '070-842-2708', 'Etiam@idmagnaet.net', ''),
138(95, 'Orli', 'Lustin', '011-852-3293', 'turpis.egestas@luctuset.net', ''),
139(96, 'Deborah', 'Belford Roxo', '051-979-7440', 'ultrices@malesuadamalesuada.org', ''),
140(97, 'Jarrod', 'Deschambault', '088-794-4402', 'vestibulum@Aenean.co.uk', ''),
141(98, 'Clayton', 'Froidchapelle', '094-496-0694', 'Nam@scelerisquescelerisque.com', ''),
142(99, 'Ferris', 'Cap-de-la-Madeleine', '042-439-5546', 'tempus.non.lacinia@elit.net', ''),
143(100, '김개똥', '서울', '11111', 'abc@aaaa.com', ''),
144(101, '호호호', '광주', '1111111111111', 'abcd@assdfadf.com', ''),
145(103, '사진가', 'Olympus', '010-1111-2345', 'photo@test.com', ''),
146(104, '사진가2', 'ë„ì‹œ', '011-123-4567', 'email@photo.com', ''),
147(105, 'eryrty', 'rtyrey', 'rye', 'rtyrey', ''),
148(106, 'eryrty', 'rtyrey', 'rye', 'rtyrey', ''),
149(107, 'sdd', 'sdafsaf', 'sadfsa', 'safdsadf', ''),
150(108, 'sadff', 'asfasf', 'safsadf', 'asdfasdf', ''),
151(109, 'dsgdsg', 'dsgdsfg', 'dfsgsdg', 'sdfgsdg', ''),
152(110, 'ã…ㄴㄹㄴã…ㅇㄹ', 'ã„´ã…ㅇㄻㄴㄹ', 'ã„´ã…ㄹㄴã…ㄹ', 'ã…ㄴㅇㄹㄴã…ㄹ', ''),
153(111, 'ã…ㄴㄹㄴã…ㅇㄹ', 'ã„´ã…ㅇㄻㄴㄹ', 'ã„´ã…ㄹㄴã…ㄹ', 'ã…ㄴㅇㄹㄴã…ㄹ', ''),
154(112, 'ã…ㄴㄹㄴã…ㅇㄹ', 'ã„´ã…ㅇㄻㄴㄹ', 'ã„´ã…ㄹㄴã…ㄹ', 'ã…ㄴㅇㄹㄴã…ㄹ', ''),
155(113, 'ㄴㅇㄹㄴã…', 'ã„´ã…‡ã…ㅇㄻㄴ', 'ã„´ã…ㄹㅇㄴã…', 'ã„´ã…ㄹㄹ', ''),
156(114, 'ã„´ã…ㅇㄹㄴã…ㄹ', 'ã„´ã…ㄹㄴã…ㄹ', 'ㄴㅇㄹㄴã…', 'ã„´ã…ㄹ', ''),
157(115, 'ã„´ã…ㅇㄹㄴã…ㄹ', 'ã„´ã…‡ã…ㄹㄴã…ㄹ', 'ã„´ã…ㄹㅇㄴã…ㄹ', 'ã„´ã…ㅇㄹㄴã…', ''),
158(116, 'ã…ㄴㄹㄴã…ㅇㄹ', 'ã„´ã…ㄹㄴã…ㄹ', 'ã„´ã…ㄹㅇㄴã…ㅇㄹ', 'ã…ㄴㄹㄴã…ㄹㅇ', ''),
159(117, 'ã…ㄴㄹㄴã…ㅇㄹ', 'ã„´ã…ㄹㄴã…ㄹ', 'ã„´ã…ㄹㅇㄴã…ㅇㄹ', 'ã…ㄴㄹㄴã…ㄹㅇ', ''),
160(118, '345345345', '345345', 'ã„´ã…ㅇㄹㅇㅀㄴㅇㅀ', 'ã„´ã…ㅇㄹㄴㅇㅎㄴㅇㅀㄴㅇㅀ', '20190123022250.jpg'),
161(119, '가가가', '대구', '000-111-999', 'gaga@gaga.com', '20190123061316.jpg'),
162(120, '테스트', '부산', '111-222-333', 'eeee@mail.com', '20190123061450.jpg'),
163(121, 'ads', 'sdafsadf', 'sdafsadf', 'saf', '20190123061502.jpg');
164
165-- --------------------------------------------------------
166
167--
168-- í…Œì´ë¸” 구조 `users`
169--
170
171CREATE TABLE `users` (
172 `id` int(11) NOT NULL,
173 `username` varchar(20) NOT NULL,
174 `userid` varchar(20) NOT NULL,
175 `userpw` varchar(100) NOT NULL
176) ENGINE=InnoDB DEFAULT CHARSET=utf8;
177
178--
179-- í…Œì´ë¸”ì˜ ë¤í”„ ë°ì´í„° `users`
180--
181
182INSERT INTO `users` (`id`, `username`, `userid`, `userpw`) VALUES
183(1, '관리ìž', 'admin', '*A4B6157319038724E3560894F7F932C8886EBFCF'),
184(8, 'í™ê¸¸ë™', 'hong', '*89C6B530AA78695E257E55D63C00A6EC9AD3E977'),
185(9, 'ê¹€ì² ìˆ˜', 'kim', '*89C6B530AA78695E257E55D63C00A6EC9AD3E977');
186
187--
188-- ë¤í”„ëœ í…Œì´ë¸”ì˜ ì¸ë±ìŠ¤
189--
190
191--
192-- í…Œì´ë¸”ì˜ ì¸ë±ìŠ¤ `friends`
193--
194ALTER TABLE `friends`
195 ADD PRIMARY KEY (`id`);
196
197--
198-- í…Œì´ë¸”ì˜ ì¸ë±ìŠ¤ `users`
199--
200ALTER TABLE `users`
201 ADD PRIMARY KEY (`id`);
202
203--
204-- ë¤í”„ëœ í…Œì´ë¸”ì˜ AUTO_INCREMENT
205--
206
207--
208-- í…Œì´ë¸”ì˜ AUTO_INCREMENT `friends`
209--
210ALTER TABLE `friends`
211 MODIFY `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=122;
212
213--
214-- í…Œì´ë¸”ì˜ AUTO_INCREMENT `users`
215--
216ALTER TABLE `users`
217 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
218COMMIT;
219
220/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
221/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
222/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;