· 10 years ago · Apr 07, 2016, 01:36 PM
1-- Adminer 4.2.3 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `abonamente`;
9CREATE TABLE `abonamente` (
10 `id` int(11) NOT NULL AUTO_INCREMENT,
11 `id_prestator` int(11) NOT NULL,
12 `perioada` int(2) NOT NULL,
13 `total` float NOT NULL,
14 `discount` float NOT NULL,
15 `suma` float NOT NULL,
16 `platit` int(1) NOT NULL DEFAULT '0',
17 `inceput` date NOT NULL,
18 `sfarsit` date NOT NULL,
19 `metoda_plata` enum('0','1') NOT NULL,
20 `timestamp` datetime NOT NULL,
21 PRIMARY KEY (`id`)
22) ENGINE=InnoDB DEFAULT CHARSET=utf8;
23
24INSERT INTO `abonamente` (`id`, `id_prestator`, `perioada`, `total`, `discount`, `suma`, `platit`, `inceput`, `sfarsit`, `metoda_plata`, `timestamp`) VALUES
25(52, 33, 2, 576.704, 0, 547.87, 1, '2016-04-04', '2016-10-04', '0', '2016-04-06 04:39:59');
26
27DROP TABLE IF EXISTS `admins`;
28CREATE TABLE `admins` (
29 `id` int(11) NOT NULL AUTO_INCREMENT,
30 `username` varchar(50) NOT NULL,
31 `parola` varchar(100) NOT NULL,
32 `type` enum('1','2','3') NOT NULL COMMENT '1-globalAdmin;2-prestatorAdmin;3-prestatorUtilizator',
33 `timestamp` datetime NOT NULL,
34 PRIMARY KEY (`id`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36
37INSERT INTO `admins` (`id`, `username`, `parola`, `type`, `timestamp`) VALUES
38(1, 'admin', '74b99d0a9f1c249fadaa84e03a7e2c44', '1', '2016-01-12 21:40:25');
39
40DROP TABLE IF EXISTS `adrese`;
41CREATE TABLE `adrese` (
42 `id` int(5) NOT NULL AUTO_INCREMENT,
43 `id_prestator` int(5) NOT NULL,
44 `titlu` varchar(50) NOT NULL,
45 `adresa` text NOT NULL,
46 `oras` int(4) NOT NULL,
47 `judet` int(4) NOT NULL,
48 `coordonate` varchar(200) NOT NULL,
49 PRIMARY KEY (`id`)
50) ENGINE=InnoDB DEFAULT CHARSET=utf8;
51
52INSERT INTO `adrese` (`id`, `id_prestator`, `titlu`, `adresa`, `oras`, `judet`, `coordonate`) VALUES
53(10, 34, 'asd asd', 'asd asd', 10, 4, '44.936664--26.01286159999995'),
54(11, 34, 'adresa 2', 'strada numar', 81, 14, '46.1236975--24.040018499999974'),
55(15, 33, 'Locatie 1', 'Drajna de Jos', 310, 32, '45.222731--26.05887830000006'),
56(16, 33, 'Locatie 2', 'iasi', 147, 25, '47.1584549--27.601441799999975'),
57(17, 36, 'asda', 'asd', 12, 3, '45.222731--26.05887830000006');
58
59DROP TABLE IF EXISTS `beneficiari`;
60CREATE TABLE `beneficiari` (
61 `id` int(11) NOT NULL AUTO_INCREMENT,
62 `nume` varchar(50) NOT NULL,
63 `prenume` varchar(50) NOT NULL,
64 `email` varchar(50) NOT NULL,
65 `telefon` varchar(12) DEFAULT NULL,
66 `adresa` varchar(255) DEFAULT NULL,
67 `parola` varchar(100) NOT NULL,
68 `activ` int(1) NOT NULL DEFAULT '0',
69 `imagine` varchar(100) DEFAULT NULL,
70 `fbid` varchar(50) DEFAULT NULL,
71 `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
72 PRIMARY KEY (`id`)
73) ENGINE=InnoDB DEFAULT CHARSET=utf8;
74
75INSERT INTO `beneficiari` (`id`, `nume`, `prenume`, `email`, `telefon`, `adresa`, `parola`, `activ`, `imagine`, `fbid`, `timestamp`) VALUES
76(1, 'asdasd', 'asdasd', 'alin.xear@gmail.com', '0735123123', 'adresa', '37397fabd2752d1ddde58965db38b189', 1, NULL, NULL, '2016-03-17 11:39:31'),
77(2, 'asdasd', 'asdasd', 'mi_au_ciordit_parola@yahoo.com', '1231231231', 'asda', '37397fabd2752d1ddde58965db38b189', 0, NULL, NULL, '2016-03-17 12:04:41'),
78(4, 'Badic', 'Sergiu', 'sergiu.badic@kubisinteractive.com', '', '', 'a8f5f167f44f4964e6c998dee827110c', 1, 'de911aa3b03104bfd756cb973ebd164d.png', NULL, '2016-03-20 19:31:51'),
79(7, 'Sergiu', 'Badic', '', '', '', '', 1, NULL, '1251709948190456', '2016-03-30 21:00:00'),
80(8, 'sergiu', 'badic', 'asd@asd.ro', '0751057555', 'asd', 'a8f5f167f44f4964e6c998dee827110c', 0, NULL, NULL, '2016-04-02 07:40:22'),
81(9, 'asd', 'asd', 'asd@asd.roz', '0712312311', 'dqwdqw', 'a8f5f167f44f4964e6c998dee827110c', 1, NULL, NULL, '2016-04-06 12:29:41'),
82(10, 'Badic', 'Sergiu', 'sergiu.badic@gmail.com', NULL, NULL, 'a8f5f167f44f4964e6c998dee827110c', 0, NULL, NULL, '2016-04-07 08:54:06');
83
84DROP TABLE IF EXISTS `beneficiari_logins`;
85CREATE TABLE `beneficiari_logins` (
86 `id` int(11) NOT NULL AUTO_INCREMENT,
87 `id_beneficiar` int(11) NOT NULL,
88 `timestamp` datetime NOT NULL,
89 PRIMARY KEY (`id`)
90) ENGINE=InnoDB DEFAULT CHARSET=utf8;
91
92INSERT INTO `beneficiari_logins` (`id`, `id_beneficiar`, `timestamp`) VALUES
93(1, 1, '2016-03-17 01:39:43'),
94(2, 1, '2016-03-17 01:58:33'),
95(3, 1, '2016-03-17 02:37:48'),
96(4, 1, '2016-03-17 07:33:15'),
97(5, 3, '2016-03-17 10:45:14'),
98(6, 3, '2016-03-17 10:47:17'),
99(7, 3, '2016-03-17 11:34:44'),
100(8, 3, '2016-03-17 11:49:39'),
101(9, 3, '2016-03-19 08:57:24'),
102(10, 4, '2016-03-20 04:53:58'),
103(11, 4, '2016-03-20 05:23:38'),
104(12, 4, '2016-03-20 07:21:04'),
105(13, 4, '2016-03-20 07:55:05'),
106(14, 4, '2016-03-20 08:33:26'),
107(15, 9, '2016-04-06 02:49:15');
108
109DROP TABLE IF EXISTS `blog`;
110CREATE TABLE `blog` (
111 `blog_id` int(5) unsigned NOT NULL AUTO_INCREMENT,
112 `blog_title` varchar(100) NOT NULL,
113 `blog_description` text,
114 PRIMARY KEY (`blog_id`)
115) ENGINE=InnoDB DEFAULT CHARSET=utf8;
116
117
118DROP TABLE IF EXISTS `cereri`;
119CREATE TABLE `cereri` (
120 `id` int(5) NOT NULL AUTO_INCREMENT,
121 `id_companie` int(5) NOT NULL,
122 `nume_companie` varchar(50) NOT NULL,
123 `tip_cerere` varchar(100) NOT NULL,
124 `mesaj` text NOT NULL,
125 `timestamp` datetime NOT NULL,
126 PRIMARY KEY (`id`)
127) ENGINE=InnoDB DEFAULT CHARSET=utf8;
128
129INSERT INTO `cereri` (`id`, `id_companie`, `nume_companie`, `tip_cerere`, `mesaj`, `timestamp`) VALUES
130(1, 30, 'Companie', 'Cerere schimbare informatii', 'test', '2016-03-31 12:47:36'),
131(2, 30, 'Companie', 'Cerere schimbare informatii', 'test 2', '2016-03-31 12:47:58'),
132(3, 30, 'Companie', 'Cerere schimbare informatii', 'qweqw', '2016-03-31 12:48:05'),
133(4, 30, 'Companie', 'Cerere schimbare informatii', 'qweqw', '2016-03-31 12:48:11'),
134(5, 30, 'Companie', 'Cerere schimbare informatii', 'qwdq', '2016-03-31 12:48:29'),
135(6, 30, 'Companie', 'Cerere schimbare informatii', 'qwdq', '2016-03-31 12:48:35'),
136(7, 30, 'Companie', 'Cerere schimbare informatii', 'qwcqwv', '2016-03-31 12:48:59'),
137(8, 30, 'Companie', 'Cerere schimbare informatii', 'qwcqwv', '2016-03-31 12:49:00'),
138(9, 30, 'Companie', 'Cerere schimbare informatii', 'qwcqwv', '2016-03-31 12:49:00'),
139(10, 30, 'Companie', 'Cerere schimbare informatii', 'qwd', '2016-03-31 12:49:14'),
140(11, 30, 'Companie', 'Cerere schimbare informatii', 'qwd', '2016-03-31 12:49:15'),
141(12, 30, 'Companie', 'Cerere schimbare informatii', 'qweqq', '2016-03-31 12:49:50'),
142(13, 30, 'Companie', 'Cerere schimbare informatii', 'qweqq', '2016-03-31 12:57:48'),
143(14, 30, 'Companie', 'Cerere schimbare informatii', 'qwdqwd', '2016-03-31 01:00:08');
144
145DROP TABLE IF EXISTS `comenzi`;
146CREATE TABLE `comenzi` (
147 `id` int(6) NOT NULL AUTO_INCREMENT,
148 `cod` varchar(6) NOT NULL,
149 `id_beneficiar` int(6) NOT NULL,
150 `id_serviciu` int(6) NOT NULL,
151 `detalii_factura` varchar(100) DEFAULT NULL,
152 `observatii` text,
153 `status` enum('0','1') DEFAULT '0',
154 `data_validare` date DEFAULT NULL,
155 `timestamp` datetime NOT NULL,
156 PRIMARY KEY (`id`)
157) ENGINE=InnoDB DEFAULT CHARSET=utf8;
158
159INSERT INTO `comenzi` (`id`, `cod`, `id_beneficiar`, `id_serviciu`, `detalii_factura`, `observatii`, `status`, `data_validare`, `timestamp`) VALUES
160(1, '24F5SV', 1, 1, NULL, NULL, '1', '2016-03-31', '2016-03-27 10:21:26'),
161(2, '24F5SV', 2, 2, NULL, NULL, '0', NULL, '2016-03-27 10:21:26');
162
163DROP TABLE IF EXISTS `domenii`;
164CREATE TABLE `domenii` (
165 `id` int(11) NOT NULL AUTO_INCREMENT,
166 `domeniu` varchar(100) NOT NULL,
167 `discount` int(4) NOT NULL,
168 PRIMARY KEY (`id`)
169) ENGINE=InnoDB DEFAULT CHARSET=utf8;
170
171INSERT INTO `domenii` (`id`, `domeniu`, `discount`) VALUES
172(2, 'Menajere', -10),
173(3, 'Bone', -10),
174(4, 'Ingrijire animale', 0),
175(5, 'Consultanta / Consultanta financiara', 0),
176(6, 'Foto - Video', 0),
177(7, 'Auto - Moto', 0),
178(8, 'Sanatate', 10),
179(9, 'Ingrijire personala', 10),
180(10, 'Evenimente festive', 10),
181(11, 'Constructii / Mesteri / Mestesugari', 10);
182
183DROP TABLE IF EXISTS `inregistrari_neterminate`;
184CREATE TABLE `inregistrari_neterminate` (
185 `id` int(5) NOT NULL AUTO_INCREMENT,
186 `email` varchar(50) NOT NULL,
187 `timestamp` datetime NOT NULL,
188 PRIMARY KEY (`id`)
189) ENGINE=InnoDB DEFAULT CHARSET=utf8;
190
191INSERT INTO `inregistrari_neterminate` (`id`, `email`, `timestamp`) VALUES
192(1, 'xcz@asdad.ro', '2016-03-23 09:59:16'),
193(2, 'qwkjn@adasd.eo', '2016-03-23 10:28:19'),
194(3, 's@xcz.ro', '2016-03-27 01:19:42'),
195(4, 'asdxcv@sdv.ro', '2016-03-27 01:51:06'),
196(5, 'dqwd@bb.rto', '2016-03-27 01:59:53'),
197(6, 'sergiu.badic@gmail.comxzczxc', '2016-03-27 02:14:42'),
198(7, 's@b.roeditzxc', '2016-03-27 02:15:49'),
199(8, 'sergiu.badic@kubisinteractive.comzxc', '2016-03-27 02:17:44'),
200(9, 'sergiu.badic@gmail.comx', '2016-03-27 02:18:30'),
201(10, 'sergiu.badic@gmail.comzxv', '2016-03-27 02:23:48'),
202(11, 'qwdx@dv.ro', '2016-03-27 02:26:13'),
203(12, 'sergiu.badic@gmail.comz', '2016-03-27 02:27:56'),
204(13, 'qwe@asdqwe.eo', '2016-03-27 02:30:25'),
205(14, 'kjndvkj@askd.ro', '2016-03-27 02:32:50'),
206(15, 'qwd@qwe.ro', '2016-03-27 02:33:40'),
207(16, 'qwd', '2016-03-27 02:34:55'),
208(17, 'qwd@asd.ro', '2016-03-27 02:35:11'),
209(18, 'sergiu.badic@gmail.comv', '2016-03-27 03:14:32'),
210(19, 'zxvsergiu.badic@gmail.com', '2016-03-27 03:23:42'),
211(20, 'sergiu.badic@gmail.coms', '2016-03-27 03:24:19'),
212(21, 'sergiu.badic@kubisinteractive.comxc', '2016-03-27 03:27:00'),
213(22, 'sergiu.badic@gmail.comzxc', '2016-03-27 03:29:17'),
214(24, 'sdvs', '2016-03-27 10:53:02'),
215(25, 'sdvs@asd.ro', '2016-03-27 10:53:15'),
216(26, 's@ve.rp', '2016-03-27 10:55:34'),
217(27, 'sss@b.ro', '2016-03-27 11:00:29'),
218(29, 'asds@b.ro', '2016-03-28 09:01:23'),
219(30, 'kjnbvkdf@bmdkfb.ro', '2016-03-28 09:04:21'),
220(31, 'szxczxc@bsdas.ro', '2016-03-28 09:05:51'),
221(32, 'sergiu.badic@gmail.comxcvxcvxcv', '2016-03-28 09:08:08'),
222(35, 'sxcz@assad.ro', '2016-03-28 09:27:00'),
223(36, 'asds@asd.ro', '2016-03-28 09:28:45'),
224(37, 'sdds@ascad.ro', '2016-03-28 09:34:59'),
225(38, 'asd@asdr.ro', '2016-03-28 09:39:15'),
226(40, 'asd@cvxc.ro', '2016-03-28 09:43:02'),
227(41, 'asdzxc@asd.ro', '2016-03-28 09:47:13'),
228(42, 'xcz@asc.ro', '2016-03-28 09:48:12'),
229(43, 'xc@asd.ro', '2016-03-28 09:56:23'),
230(44, 'qcv', '2016-03-28 09:57:41'),
231(45, 'qcv@asd.ro', '2016-03-28 09:57:48'),
232(46, 'asd@sdasd.ro', '2016-03-28 10:10:32'),
233(47, 'vcx@sbv.ro', '2016-03-28 10:13:50'),
234(48, 'sasd@b.ro', '2016-03-28 10:16:50'),
235(52, 's@bbr.ro', '2016-03-28 11:20:43'),
236(54, 's@bb.ro', '2016-03-29 10:24:02'),
237(55, 'asd@vasd.ro', '2016-04-06 10:55:59'),
238(56, 'sergiu.badic@gmail.com', '2016-04-06 11:23:46'),
239(57, 'doctor@ontracktesting.com', '2016-04-06 11:24:32'),
240(58, 'sergiu.badic@gmail.comasda', '2016-04-06 11:27:14'),
241(59, 's@b.roasd', '2016-04-06 11:38:43'),
242(62, 'sergiu.badic@gmail.comasdasd', '2016-04-06 03:14:37'),
243(63, 'sergiu.badic@gmail.comasdasdzxc', '2016-04-06 03:14:49'),
244(64, 's@b.roqweqwe', '2016-04-06 03:14:58'),
245(65, 'qwefs@asfkjnk.ro', '2016-04-06 03:18:48');
246
247DROP TABLE IF EXISTS `judete`;
248CREATE TABLE `judete` (
249 `id` int(2) NOT NULL,
250 `nume` varchar(50) NOT NULL
251) ENGINE=InnoDB DEFAULT CHARSET=utf8;
252
253INSERT INTO `judete` (`id`, `nume`) VALUES
254(1, 'Alba'),
255(2, 'Arad'),
256(3, 'Arges'),
257(4, 'Bacau'),
258(5, 'Bihor'),
259(6, 'Bistrita Nasaud'),
260(7, 'Botosani'),
261(8, 'Brasov'),
262(9, 'Braila'),
263(10, 'Bucuresti'),
264(11, 'Buzau'),
265(12, 'Caras Severin'),
266(13, 'Calarasi'),
267(14, 'Cluj'),
268(15, 'Constanta'),
269(16, 'Covasna'),
270(17, 'Dambovita'),
271(18, 'Dolj'),
272(19, 'Galati'),
273(20, 'Giurgiu'),
274(21, 'Gorj'),
275(22, 'Harghita'),
276(23, 'Hunedoara'),
277(24, 'Ialomita'),
278(25, 'Iasi'),
279(26, 'Ilfov'),
280(27, 'Maramures'),
281(28, 'Mehedinti'),
282(29, 'Mures'),
283(30, 'Neamt'),
284(31, 'Olt'),
285(32, 'Prahova'),
286(33, 'Satu Mare'),
287(34, 'Salaj'),
288(35, 'Sibiu'),
289(36, 'Suceava'),
290(37, 'Teleorman'),
291(38, 'Timis'),
292(39, 'Tulcea'),
293(40, 'Vaslui'),
294(41, 'Valcea'),
295(42, 'Vrancea');
296
297DROP TABLE IF EXISTS `media`;
298CREATE TABLE `media` (
299 `id` int(11) NOT NULL AUTO_INCREMENT,
300 `media` varchar(100) NOT NULL,
301 `parent` int(5) NOT NULL,
302 `type` int(2) NOT NULL,
303 `main` int(1) NOT NULL DEFAULT '0',
304 PRIMARY KEY (`id`)
305) ENGINE=InnoDB DEFAULT CHARSET=utf8;
306
307INSERT INTO `media` (`id`, `media`, `parent`, `type`, `main`) VALUES
308(1, '444caa87f4efc4bd1ed651f923e47390.png', 1, 1, 1),
309(2, '3e7d9b474650810cb645913b77dd0b32.png', 2, 1, 1),
310(3, '5088f8c75840c5f776385ee8a5af8945.png', 1, 1, 1),
311(4, '08ece9ea2bf6a6ae9776cb8d8853bb2b.png', 2, 1, 1),
312(5, '77c522f9c726a3453b81a134a88a13d9.png', 1, 1, 1),
313(6, 'f5921ca40ddd1d11244f4b8803b554c8.jpg', 1, 1, 0),
314(7, 'bb0cf1b62b9c692dcbb73fffc4abf521.jpg', 2, 1, 1);
315
316DROP TABLE IF EXISTS `membri`;
317CREATE TABLE `membri` (
318 `id` int(5) NOT NULL AUTO_INCREMENT,
319 `nume` varchar(50) NOT NULL,
320 `functie` varchar(50) NOT NULL,
321 `poza` varchar(100) NOT NULL,
322 `id_prestator` int(5) NOT NULL,
323 PRIMARY KEY (`id`)
324) ENGINE=InnoDB DEFAULT CHARSET=utf8;
325
326INSERT INTO `membri` (`id`, `nume`, `functie`, `poza`, `id_prestator`) VALUES
327(1, 'nume', 'functie', 'abd9fc9f70e17cd67cc9e5e2ab9467d3.png', 2),
328(2, 'nume 2', 'functie 2', '55adb5f3418c90306055909f2861bbfb.png', 2),
329(3, 'membru nume', 'membru functie', 'f41fe9fb2d90d3372b273b95936910a3.png', 30),
330(4, 'mem', 'fct', 'aa60877ccff7e1ec3e0a2951984cd819.jpg', 33);
331
332DROP TABLE IF EXISTS `mesaje`;
333CREATE TABLE `mesaje` (
334 `id` int(7) NOT NULL AUTO_INCREMENT,
335 `id_prestator` int(5) NOT NULL,
336 `subiect` varchar(50) NOT NULL,
337 `mesaj` text NOT NULL,
338 `timestamp` datetime NOT NULL,
339 PRIMARY KEY (`id`)
340) ENGINE=InnoDB DEFAULT CHARSET=utf8;
341
342INSERT INTO `mesaje` (`id`, `id_prestator`, `subiect`, `mesaj`, `timestamp`) VALUES
343(1, 33, 'subiect', '<p>mesaj</p>\r\n<p><strong>bold</strong></p>', '2016-04-03 09:05:55'),
344(2, 33, 'subiect', '<p>mesaj</p>\r\n<p><strong>bold</strong></p>', '2016-04-03 09:06:04'),
345(3, 34, 'subiect', '<p>mesaj</p>\r\n<p><strong>bold</strong></p>', '2016-04-03 09:06:04'),
346(4, 0, 'sub', '<p>asd</p>', '2016-04-03 09:06:21'),
347(5, 33, 'dqwdq', '<p><span underline;">wd</span></p>', '2016-04-03 09:08:35'),
348(6, 34, 'subiect', '<p>mesaj</p>', '2016-04-03 09:36:09');
349
350DROP TABLE IF EXISTS `mesaje_status`;
351CREATE TABLE `mesaje_status` (
352 `id_prestator` int(5) NOT NULL,
353 `status` enum('0','1','2') NOT NULL
354) ENGINE=InnoDB DEFAULT CHARSET=latin1;
355
356
357DROP TABLE IF EXISTS `migrations`;
358CREATE TABLE `migrations` (
359 `version` bigint(20) NOT NULL
360) ENGINE=InnoDB DEFAULT CHARSET=utf8;
361
362INSERT INTO `migrations` (`version`) VALUES
363(20160501173000);
364
365DROP TABLE IF EXISTS `numar_angajati`;
366CREATE TABLE `numar_angajati` (
367 `id` int(3) NOT NULL AUTO_INCREMENT,
368 `numar` varchar(10) NOT NULL,
369 `discount` int(3) NOT NULL,
370 PRIMARY KEY (`id`)
371) ENGINE=InnoDB DEFAULT CHARSET=utf8;
372
373INSERT INTO `numar_angajati` (`id`, `numar`, `discount`) VALUES
374(1, '<5', 0),
375(2, '5 - 15', 10),
376(3, '15 - 30', 20);
377
378DROP TABLE IF EXISTS `orase`;
379CREATE TABLE `orase` (
380 `id` int(3) NOT NULL AUTO_INCREMENT,
381 `nume` varchar(100) NOT NULL,
382 PRIMARY KEY (`id`)
383) ENGINE=InnoDB DEFAULT CHARSET=utf8;
384
385INSERT INTO `orase` (`id`, `nume`) VALUES
386(1, 'Abrud'),
387(2, 'Adjud'),
388(3, 'Agnita'),
389(4, 'Aiud'),
390(5, 'Alba Iulia'),
391(6, 'Alesd'),
392(7, 'Alexandria'),
393(8, 'Amara'),
394(9, 'Anina'),
395(10, 'Aninoasa'),
396(11, 'Arad'),
397(12, 'Ardud'),
398(13, 'Avrig'),
399(14, 'Azuga'),
400(15, 'Babadag'),
401(16, 'Babeni'),
402(17, 'Bacau'),
403(18, 'Baia de Arama'),
404(19, 'Baia de Aries'),
405(20, 'Baia Mare'),
406(21, 'Baia Sprie'),
407(22, 'Baicoi'),
408(23, 'Baile Govora'),
409(24, 'Baile Herculane'),
410(25, 'Baile Olanesti'),
411(26, 'Baile Tusnad'),
412(27, 'Bailesti'),
413(28, 'Balan'),
414(29, 'Balcesti'),
415(30, 'Bals'),
416(31, 'Baneasa'),
417(32, 'Baraolt'),
418(33, 'Barlad'),
419(34, 'Bechet'),
420(35, 'Beclean'),
421(36, 'Beius'),
422(37, 'Berbesti'),
423(38, 'Beresti'),
424(39, 'Bicaz'),
425(40, 'Bistrita'),
426(41, 'Blaj'),
427(42, 'Bocsa'),
428(43, 'Boldesti-Scaeni'),
429(44, 'Bolintin-Vale'),
430(45, 'Borsa'),
431(46, 'Borsec'),
432(47, 'Botosani'),
433(48, 'Brad'),
434(49, 'Bragadiru'),
435(50, 'Braila'),
436(51, 'Brasov'),
437(52, 'Breaza'),
438(53, 'Brezoi'),
439(54, 'Brosteni'),
440(55, 'Bucecea'),
441(56, 'Bucuresti'),
442(62, 'Budesti'),
443(63, 'Buftea'),
444(64, 'Buhusi'),
445(65, 'Bumbesti-Jiu'),
446(66, 'Busteni'),
447(67, 'Buzau'),
448(68, 'Buzias'),
449(69, 'Cajvana'),
450(70, 'Calafat'),
451(71, 'Calan'),
452(72, 'Calarasi'),
453(73, 'Calimanesti'),
454(74, 'Campeni'),
455(75, 'Campia Turzii'),
456(76, 'Campina'),
457(77, 'Campulung Moldovenesc'),
458(78, 'Campulung'),
459(79, 'Caracal'),
460(80, 'Caransebes'),
461(81, 'Carei'),
462(82, 'Cavnic'),
463(83, 'Cazanesti'),
464(84, 'Cehu Silvaniei'),
465(85, 'Cernavoda'),
466(86, 'Chisineu-Cris'),
467(87, 'Chitila'),
468(88, 'Ciacova'),
469(89, 'Cisnadie'),
470(90, 'Cluj-Napoca'),
471(91, 'Codlea'),
472(92, 'Comanesti'),
473(93, 'Comarnic'),
474(94, 'Constanta'),
475(95, 'Copsa Mica'),
476(96, 'Corabia'),
477(97, 'Costesti'),
478(98, 'Covasna'),
479(99, 'Craiova'),
480(100, 'Cristuru Secuiesc'),
481(101, 'Cugir'),
482(102, 'Curtea de Arges'),
483(103, 'Curtici'),
484(104, 'Dabuleni'),
485(105, 'Darabani'),
486(106, 'Darmanesti'),
487(107, 'Dej'),
488(108, 'Deta'),
489(109, 'Deva'),
490(110, 'Dolhasca'),
491(111, 'Dorohoi'),
492(112, 'Draganesti-Olt'),
493(113, 'Dragasani'),
494(114, 'Dragomiresti'),
495(115, 'Drobeta-Turnu Severin'),
496(116, 'Dumbraveni'),
497(117, 'Eforie'),
498(118, 'Fagaras'),
499(119, 'Faget'),
500(120, 'Falticeni'),
501(121, 'Faurei'),
502(122, 'Fetesti'),
503(123, 'Fieni'),
504(124, 'Fierbinti-Targ'),
505(125, 'Filiasi'),
506(126, 'Flamanzi'),
507(127, 'Focsani'),
508(128, 'Frasin'),
509(129, 'Fundulea'),
510(130, 'Gaesti'),
511(131, 'Galati'),
512(132, 'Gataia'),
513(133, 'Geoagiu'),
514(134, 'Gheorgheni'),
515(135, 'Gherla'),
516(136, 'Ghimbav'),
517(137, 'Giurgiu'),
518(138, 'Gura Humorului'),
519(139, 'Harlau'),
520(140, 'Harsova'),
521(141, 'Hateg'),
522(142, 'Horezu'),
523(143, 'Huedin'),
524(144, 'Hunedoara'),
525(145, 'Husi'),
526(146, 'Ianca'),
527(147, 'Iasi'),
528(148, 'Iernut'),
529(149, 'Ineu'),
530(150, 'Insuratei'),
531(151, 'Intorsura Buzaului'),
532(152, 'Isaccea'),
533(153, 'Jibou'),
534(154, 'Jimbolia'),
535(155, 'Lehliu Gara'),
536(156, 'Lipova'),
537(157, 'Liteni'),
538(158, 'Livada'),
539(159, 'Ludus'),
540(160, 'Lugoj'),
541(161, 'Lupeni'),
542(162, 'Macin'),
543(163, 'Magurele'),
544(164, 'Mangalia'),
545(165, 'Marasesti'),
546(166, 'Marghita'),
547(167, 'Medgidia'),
548(168, 'Medias'),
549(169, 'Miercurea Ciuc'),
550(170, 'Miercurea Nirajului'),
551(171, 'Miercurea Sibiului'),
552(172, 'Mihailesti'),
553(173, 'Milisauti'),
554(174, 'Mioveni'),
555(175, 'Mizil'),
556(176, 'Moinesti'),
557(177, 'Moldova Noua'),
558(178, 'Moreni'),
559(179, 'Motru'),
560(180, 'Murfatlar'),
561(181, 'Murgeni'),
562(182, 'Nadlac'),
563(183, 'Nasaud'),
564(184, 'Navodari'),
565(185, 'Negresti'),
566(186, 'Negresti-Oas'),
567(187, 'Negru Voda'),
568(188, 'Nehoiu'),
569(189, 'Novaci'),
570(190, 'Nucet'),
571(191, 'Ocna Mures'),
572(192, 'Ocna Sibiului'),
573(193, 'Ocnele Mari'),
574(194, 'Odobesti'),
575(195, 'Odorheiu Secuiesc'),
576(196, 'Oltenita'),
577(197, 'Onesti'),
578(198, 'Oradea'),
579(199, 'Orastie'),
580(200, 'Oravita'),
581(201, 'Orsova'),
582(202, 'Otelu Rosu'),
583(203, 'Otopeni'),
584(204, 'Ovidiu'),
585(205, 'Panciu'),
586(206, 'Pancota'),
587(207, 'Pantelimon'),
588(208, 'Pascani'),
589(209, 'Patarlagele'),
590(210, 'Pecica'),
591(211, 'Petrila'),
592(212, 'Petrosani'),
593(213, 'Piatra Neamt'),
594(214, 'Piatra-Olt'),
595(215, 'Pitesti'),
596(216, 'Ploiesti'),
597(217, 'Plopeni'),
598(218, 'Podu Iloaiei'),
599(219, 'Pogoanele'),
600(220, 'Popesti-Leordeni'),
601(221, 'Potcoava'),
602(222, 'Predeal'),
603(223, 'Pucioasa'),
604(224, 'Racari'),
605(225, 'Radauti'),
606(226, 'Ramnicu Sarat'),
607(227, 'Ramnicu Valcea'),
608(228, 'Rasnov'),
609(229, 'Recas'),
610(230, 'Reghin'),
611(231, 'Resita'),
612(232, 'Roman'),
613(233, 'Rosiorii de Vede'),
614(234, 'Rovinari'),
615(235, 'Roznov'),
616(236, 'Rupea'),
617(237, 'Sacele'),
618(238, 'Sacueni'),
619(239, 'Salcea'),
620(240, 'Saliste'),
621(241, 'Salistea de Sus'),
622(242, 'Salonta'),
623(243, 'Sangeorgiu de Padure'),
624(244, 'Sangeorz-Bai'),
625(245, 'Sannicolau Mare'),
626(246, 'Santana'),
627(247, 'Sarmasu'),
628(248, 'Satu Mare'),
629(249, 'Saveni'),
630(250, 'Scornicesti'),
631(251, 'Sebes'),
632(252, 'Sebis'),
633(253, 'Segarcea'),
634(254, 'Seini'),
635(255, 'Sfantu Gheorghe'),
636(256, 'Sibiu'),
637(257, 'Sighetu Marmatiei'),
638(258, 'Sighisoara'),
639(259, 'Simeria'),
640(260, 'Simleu Silvaniei'),
641(261, 'Sinaia'),
642(262, 'Siret'),
643(263, 'Slanic'),
644(264, 'Slanic-Moldova'),
645(265, 'Slatina'),
646(266, 'Slobozia'),
647(267, 'Solca'),
648(268, 'Somcuta Mare'),
649(269, 'Sovata'),
650(270, 'Stefanesti, Arges'),
651(271, 'Stefanesti, Botosani'),
652(272, 'Stei'),
653(273, 'Strehaia'),
654(274, 'Suceava'),
655(275, 'Sulina'),
656(276, 'Talmaciu'),
657(277, 'Tandarei'),
658(278, 'Targoviste'),
659(279, 'Targu Bujor'),
660(280, 'Targu Carbunesti'),
661(281, 'Targu Frumos'),
662(282, 'Targu Jiu'),
663(283, 'Targu Lapus'),
664(284, 'Targu Mures'),
665(285, 'Targu Neamt'),
666(286, 'Targu Ocna'),
667(287, 'Targu Secuiesc'),
668(288, 'Tarnaveni'),
669(289, 'Tasnad'),
670(290, 'Tautii-Magheraus'),
671(291, 'Techirghiol'),
672(292, 'Tecuci'),
673(293, 'Teius'),
674(294, 'Ticleni'),
675(295, 'Timisoara'),
676(296, 'Tismana'),
677(297, 'Titu'),
678(298, 'Toplita'),
679(299, 'Topoloveni'),
680(300, 'Tulcea'),
681(301, 'Turceni'),
682(302, 'Turda'),
683(303, 'Turnu Magurele'),
684(304, 'Ulmeni'),
685(305, 'Ungheni'),
686(306, 'Uricani'),
687(307, 'Urlati'),
688(308, 'Urziceni'),
689(309, 'Valea lui Mihai'),
690(310, 'Valenii de Munte'),
691(311, 'Vanju Mare'),
692(312, 'Vascau'),
693(313, 'Vaslui'),
694(314, 'Vatra Dornei'),
695(315, 'Vicovu de Sus'),
696(316, 'Victoria'),
697(317, 'Videle'),
698(318, 'Viseu de Sus'),
699(319, 'Vlahita'),
700(320, 'Voluntari'),
701(321, 'Vulcan'),
702(322, 'Zalau'),
703(323, 'Zarnesti'),
704(324, 'Zimnicea'),
705(325, 'Zlatna');
706
707DROP TABLE IF EXISTS `pachete`;
708CREATE TABLE `pachete` (
709 `id` int(3) NOT NULL AUTO_INCREMENT,
710 `nume` varchar(10) NOT NULL,
711 `pret` float NOT NULL,
712 `discount` int(3) NOT NULL,
713 PRIMARY KEY (`id`)
714) ENGINE=InnoDB DEFAULT CHARSET=utf8;
715
716INSERT INTO `pachete` (`id`, `nume`, `pret`, `discount`) VALUES
717(1, '3 Luni', 396.704, 0),
718(2, '6 Luni', 576.704, -5),
719(3, '12 Luni', 906.704, -10);
720
721DROP TABLE IF EXISTS `prestatori`;
722CREATE TABLE `prestatori` (
723 `id` int(11) NOT NULL AUTO_INCREMENT,
724 `tip_companie` varchar(20) NOT NULL,
725 `nume` varchar(50) NOT NULL,
726 `brand` varchar(50) NOT NULL,
727 `cod_identificare` varchar(50) NOT NULL,
728 `registrul_comertului` varchar(50) NOT NULL,
729 `iban` varchar(50) NOT NULL,
730 `sucursala` varchar(50) NOT NULL,
731 `categorie` varchar(50) NOT NULL,
732 `subcategorie` varchar(50) NOT NULL,
733 `subcategorii_secundare` varchar(255) NOT NULL,
734 `adresa` varchar(255) NOT NULL,
735 `oras` varchar(50) NOT NULL,
736 `judet` varchar(50) NOT NULL,
737 `cod_postal` varchar(10) NOT NULL,
738 `persoana_contact` varchar(50) NOT NULL,
739 `functie_persoana_contact` varchar(50) NOT NULL,
740 `email` varchar(50) NOT NULL,
741 `telefon` varchar(10) NOT NULL,
742 `website` varchar(80) NOT NULL,
743 `descriere` text,
744 `prezentare` text,
745 `program` text,
746 `status_abonament` enum('0','1') NOT NULL,
747 `numar_angajati` varchar(20) NOT NULL,
748 `logo` varchar(100) DEFAULT NULL,
749 `cover` varchar(100) DEFAULT NULL,
750 `slug` varchar(100) DEFAULT NULL,
751 `status` int(1) DEFAULT '0',
752 `parola` varchar(100) DEFAULT NULL,
753 `certificari` varchar(50) DEFAULT '[]',
754 `timestamp` datetime NOT NULL,
755 PRIMARY KEY (`id`)
756) ENGINE=InnoDB DEFAULT CHARSET=utf8;
757
758INSERT INTO `prestatori` (`id`, `tip_companie`, `nume`, `brand`, `cod_identificare`, `registrul_comertului`, `iban`, `sucursala`, `categorie`, `subcategorie`, `subcategorii_secundare`, `adresa`, `oras`, `judet`, `cod_postal`, `persoana_contact`, `functie_persoana_contact`, `email`, `telefon`, `website`, `descriere`, `prezentare`, `program`, `status_abonament`, `numar_angajati`, `logo`, `cover`, `slug`, `status`, `parola`, `certificari`, `timestamp`) VALUES
759(33, '2', 'companie', '', 'ro', 'j', 'cnt', 'suc', '6', '80', '[\"78\",\"79\"]', 'sasd', '2', '3', 'asd', 'sergiu', 'dev', 'sergiu.badic@kubisinteractive.com', '0712123122', 'www.asd.roedit', '<p>qdwq</p>', '<p>asd</p>\r\n<p><img src="public/uploads/media/dummy.png" alt="" width="640" height="480"></p>', NULL, '1', '2', '6e8ffd88e1d8ec3af8066cf1aa860ae9.jpg', '534207d186d79f4640bb82116a07dea8.png', 'ceva', 1, '1153c3c47c156dc7281fa536f60d2f90', '[]', '2016-04-02 10:30:50');
760
761DROP TABLE IF EXISTS `prestatori_logins`;
762CREATE TABLE `prestatori_logins` (
763 `id` int(11) NOT NULL AUTO_INCREMENT,
764 `id_prestator` int(11) NOT NULL,
765 `timestamp` datetime NOT NULL,
766 PRIMARY KEY (`id`)
767) ENGINE=InnoDB DEFAULT CHARSET=utf8;
768
769INSERT INTO `prestatori_logins` (`id`, `id_prestator`, `timestamp`) VALUES
770(1, 2, '2016-03-20 07:22:00'),
771(2, 2, '2016-03-20 07:57:51'),
772(3, 2, '2016-03-20 08:33:11'),
773(4, 2, '2016-03-23 08:13:06'),
774(5, 1, '2016-03-26 08:20:03'),
775(6, 1, '2016-03-27 10:17:32'),
776(7, 30, '2016-03-31 12:21:25'),
777(8, 33, '2016-04-02 02:10:33'),
778(9, 33, '2016-04-02 02:53:00'),
779(10, 33, '2016-04-03 10:04:59'),
780(11, 33, '2016-04-04 08:37:51');
781
782DROP TABLE IF EXISTS `preturi_pachete`;
783CREATE TABLE `preturi_pachete` (
784 `id` int(3) NOT NULL AUTO_INCREMENT,
785 `nume` varchar(50) NOT NULL,
786 `pret` float NOT NULL,
787 PRIMARY KEY (`id`)
788) ENGINE=InnoDB DEFAULT CHARSET=utf8;
789
790INSERT INTO `preturi_pachete` (`id`, `nume`, `pret`) VALUES
791(1, '3 Luni', 396.704),
792(2, '6 Luni', 576.704),
793(3, '12 Luni', 906.704);
794
795DROP TABLE IF EXISTS `servicii`;
796CREATE TABLE `servicii` (
797 `id` int(5) NOT NULL AUTO_INCREMENT,
798 `id_prestator` int(5) NOT NULL,
799 `titlu` varchar(50) NOT NULL,
800 `descriere` text NOT NULL,
801 `pret` varchar(20) NOT NULL,
802 `mod_cumparare` varchar(20) NOT NULL,
803 `cumparare_online` int(1) NOT NULL DEFAULT '0',
804 `timestamp` datetime NOT NULL,
805 PRIMARY KEY (`id`)
806) ENGINE=InnoDB DEFAULT CHARSET=utf8;
807
808INSERT INTO `servicii` (`id`, `id_prestator`, `titlu`, `descriere`, `pret`, `mod_cumparare`, `cumparare_online`, `timestamp`) VALUES
809(1, 30, 'serviciu 1', '<p>descriere</p>\r\n<p><strong>serviciu</strong></p>', '100', 'ora', 1, '2016-03-31 12:20:34'),
810(2, 33, 'serv 1', '<p>dqwdqwe</p>', '12', 'fix', 1, '2016-04-06 04:21:59');
811
812DROP TABLE IF EXISTS `subdomenii`;
813CREATE TABLE `subdomenii` (
814 `id` int(11) NOT NULL AUTO_INCREMENT,
815 `subdomeniu` varchar(100) NOT NULL,
816 `discount` int(4) NOT NULL,
817 `id_domeniu` int(11) NOT NULL,
818 PRIMARY KEY (`id`)
819) ENGINE=InnoDB DEFAULT CHARSET=utf8;
820
821INSERT INTO `subdomenii` (`id`, `subdomeniu`, `discount`, `id_domeniu`) VALUES
822(1, 'Meditatii engleza', -10, 1),
823(2, 'Meditatii romana', -10, 1),
824(3, 'Meditatii franceza', -10, 1),
825(4, 'Meditatii utilizare calculator', -10, 1),
826(5, 'Meditatii matematica', 0, 1),
827(6, 'Meditatii germana', 0, 1),
828(7, 'Meditatii chitara', 0, 1),
829(8, 'Meditatii fizica', 0, 1),
830(9, 'Meditatii informatica', 0, 1),
831(10, 'Meditatii biologie', 0, 1),
832(11, 'Meditatii desen', 0, 1),
833(12, 'Meditatii istorie', 0, 1),
834(13, 'Meditatii contabilitate', 0, 1),
835(14, 'Meditatii pictura', 0, 1),
836(15, 'Meditatii psihologie', 0, 1),
837(16, 'Meditatii geografie', 0, 1),
838(17, 'Meditatii jurnalism', 0, 1),
839(18, 'Meditatii statistica', 0, 1),
840(19, 'Meditatii dans', 0, 1),
841(20, 'Meditatii finante', 0, 1),
842(21, 'Meditatii fiscalitate', 0, 1),
843(22, 'Meditatii grafica pe calculator', 0, 1),
844(23, 'Meditatii logica', 0, 1),
845(24, 'Meditatii istoria artei', 0, 1),
846(25, 'Meditatii logopedie', 0, 1),
847(26, 'Meditatii maghiara', 0, 1),
848(27, 'Meditatii programare', 0, 1),
849(28, 'Meditatii filozofie', 0, 1),
850(29, 'Meditatii rezistenta materialelor', 0, 1),
851(30, 'Meditatii sociologie', 0, 1),
852(31, 'Meditatii sport', 0, 1),
853(32, 'Meditatii muzica', 10, 1),
854(33, 'Meditatii chimie', 10, 1),
855(34, 'Meditatii italiana', 10, 1),
856(35, 'Meditatii spaniola', 10, 1),
857(36, 'Meditatii pian', 10, 1),
858(37, 'Meditatii economie', 10, 1),
859(38, 'Meditatii rusa', 10, 1),
860(39, 'Meditatii chineza', 10, 1),
861(40, 'Meditatii drept', 10, 1),
862(41, 'Meditatii olandeza', 10, 1),
863(42, 'Meditatii canto', 10, 1),
864(43, 'Meditatii latina', 10, 1),
865(44, 'Meditatii actorie', 10, 1),
866(45, 'Meditatii alte limbi straine', 10, 1),
867(46, 'Meditatii autocad', 10, 1),
868(47, 'Meditatii design', 10, 1),
869(48, 'Meditatii estetica', 10, 1),
870(49, 'Meditatii neogreaca', 10, 1),
871(50, 'Meditatii online', 10, 1),
872(51, 'La cerere', -10, 2),
873(52, 'Interne', 10, 2),
874(53, 'Baby Sitting', -10, 3),
875(54, 'Bone Part-time', 0, 3),
876(55, 'Bone Full-time', 10, 3),
877(56, 'Dresori', -10, 4),
878(57, 'Dog sitting', -10, 4),
879(58, 'Asociatii pentru protectia animalelor', -10, 4),
880(59, 'Ambulanta veterinara', 0, 4),
881(60, 'Crescatori de animale', 0, 4),
882(61, 'Clinici veterinare', 10, 4),
883(62, 'Farmacii veterinare', 10, 4),
884(63, 'Saloane cosmetica animale', 10, 4),
885(64, 'Pensiuni animale', 10, 4),
886(65, 'Pet shop', 10, 4),
887(66, 'Inspector resurse umane', -10, 5),
888(67, 'HR - Organizare interna', -10, 5),
889(68, 'Protectia muncii', -10, 5),
890(69, 'Consultanta proiecte europene', 0, 5),
891(70, 'Mediator', 0, 5),
892(71, 'Traducator', 0, 5),
893(72, 'Contabil', 0, 5),
894(73, 'Detectiv', 0, 5),
895(74, 'Broker-asigurari', 10, 5),
896(75, 'Jurist', 10, 5),
897(76, 'Avocat', 10, 5),
898(77, 'Notari publici', 10, 5),
899(78, 'Portrete', -10, 6),
900(79, 'Evenimente', 0, 6),
901(80, 'Familie si copii', 0, 6),
902(81, 'Studio foto propriu', 0, 6),
903(82, 'Nunta', 10, 6),
904(83, 'Botez', 10, 6),
905(84, 'Fashion', 10, 6),
906(85, 'Produse si publicitate', 10, 6),
907(86, 'Fotograf profesionist', 10, 6),
908(87, 'Anvelope', -10, 7),
909(88, 'Auto recuperate', -10, 7),
910(89, 'Consumabile auto', -10, 7),
911(90, 'Dezmembrari auto', -10, 7),
912(91, 'Rulote', -10, 7),
913(92, 'Jucarii & machete auto', -10, 7),
914(93, 'Manuale auto service', -10, 7),
915(94, 'Statii ITP', -10, 7),
916(95, 'Tractari Auto', -10, 7),
917(96, 'Vulcanizare Service Roti', -10, 7),
918(97, 'Accesorii auto', 0, 7),
919(98, 'Piese auto', 0, 7),
920(99, 'Climatizare auto', 0, 7),
921(100, 'Electrica auto', 0, 7),
922(101, 'Inscriptionari oglinzi', 0, 7),
923(102, 'Parbrize auto si geamuri', 0, 7),
924(103, 'Scoala de Pilotaj', 0, 7),
925(104, 'Scoala de Soferi', 0, 7),
926(105, 'Service auto', 0, 7),
927(106, 'Stickere si Colantari auto', 0, 7),
928(107, 'Tapiterii auto', 0, 7),
929(108, 'Tinichigerie auto', 0, 7),
930(109, 'Vopsitorie auto', 0, 7),
931(110, 'Echipamente si accesorii moto', 0, 7),
932(111, 'Piese moto', 0, 7),
933(112, 'Service moto', 0, 7),
934(113, 'Alarme auto', 0, 7),
935(114, 'Instalatori Car Audio', 0, 7),
936(115, 'Magazine Car Audio', 0, 7),
937(116, 'Monitorizare GPS', 0, 7),
938(117, 'Multimedia', 0, 7),
939(118, 'Statii radio cb', 0, 7),
940(119, 'Asistenta juridica', 10, 7),
941(120, 'Parcuri auto', 10, 7),
942(121, 'Detailing & cosmetica auto', 10, 7),
943(122, 'Folie auto', 10, 7),
944(123, 'Inmatriculari auto', 10, 7),
945(124, 'Rent a Car', 10, 7),
946(125, 'ATV-uri', 10, 7),
947(126, 'Motociclete', 10, 7),
948(127, 'Scutere', 10, 7),
949(128, 'Tuning moto', 10, 7),
950(129, 'Navigatii & GPS', 10, 7),
951(130, 'Analize Medicale', -10, 8),
952(131, 'Analize Medicale Si Investigatii', -10, 8),
953(132, 'Cardiologie', -10, 8),
954(133, 'Chirurgie Orala Si Maxilo Faciala', -10, 8),
955(134, 'Cosmetica Dentara', -10, 8),
956(135, 'Dermatologie', -10, 8),
957(136, 'Dermatovenerologie', -10, 8),
958(137, 'Diabet Zaharat Nutritie', -10, 8),
959(138, 'Ecografie', -10, 8),
960(139, 'Endocrinologie', -10, 8),
961(140, 'Fiziokinetoterapie ', -10, 8),
962(141, 'Fizioterapie', -10, 8),
963(142, 'Ingrijire La Domiciliu', -10, 8),
964(143, 'Kinetoterapie', -10, 8),
965(144, 'Logopedie', -10, 8),
966(145, 'Medicina De Familie', -10, 8),
967(146, 'Medicina Generala', -10, 8),
968(147, 'Medicina Interna', -10, 8),
969(148, 'Medicina Muncii', -10, 8),
970(149, 'Neurologie', -10, 8),
971(150, 'Obstetrica Ginecologie', -10, 8),
972(151, 'Oftalmologie', -10, 8),
973(152, 'ORL', -10, 8),
974(153, 'Ortodontie Si Ortopedie Dento', -10, 8),
975(154, 'Ortopedie Si Traumatologie', -10, 8),
976(155, 'Pediatrie', -10, 8),
977(156, 'Psihiatrie', -10, 8),
978(157, 'Psihologie', -10, 8),
979(158, 'Psihoterapie', -10, 8),
980(159, 'Radiologie Imagistica', -10, 8),
981(160, 'Recuperare Medicina Fizica', -10, 8),
982(161, 'Reumatologie', -10, 8),
983(162, 'Stomatologie', -10, 8),
984(163, 'Urologie', -10, 8),
985(164, 'Acupunctura', 0, 8),
986(165, 'Alergologie Si Imunologie', 0, 8),
987(166, 'Balneofizioterapie', 0, 8),
988(167, 'Chirurgie Dento Alveolara', 0, 8),
989(168, 'Chirurgie Generala', 0, 8),
990(169, 'Chirurgie Plastica', 0, 8),
991(170, 'Cosmetica', 0, 8),
992(171, 'Dermatochirurgie', 0, 8),
993(172, 'Estetica', 0, 8),
994(173, 'Gastroenterologie', 0, 8),
995(174, 'Hematologie', 0, 8),
996(175, 'Imagistica Medicala', 0, 8),
997(176, 'Implantologie Dentara', 0, 8),
998(177, 'Medicina Alternativa', 0, 8),
999(178, 'Medicina De Laborator', 0, 8),
1000(179, 'Nefrologie', 0, 8),
1001(180, 'Nutritie Diete', 0, 8),
1002(181, 'Oncologie', 0, 8),
1003(182, 'Pediatrie Si Neonatologie', 0, 8),
1004(183, 'Pediatrie Si Ortodontie', 0, 8),
1005(184, 'Pneumologie', 0, 8),
1006(185, 'Sexologie', 0, 8),
1007(186, 'Sport Sanatate', 0, 8),
1008(187, 'Anatomie Patologica', 10, 8),
1009(188, 'Andrologie', 10, 8),
1010(189, 'Anestezie Si Terapie Intensiva', 10, 8),
1011(190, 'Aparatura Medicala', 10, 8),
1012(191, 'Apifitoterapie', 10, 8),
1013(192, 'Boli Infectioase', 10, 8),
1014(193, 'Cardiologie Interventionala', 10, 8),
1015(194, 'Celule Stem', 10, 8),
1016(195, 'Chirurgie Cardiovasculara', 10, 8),
1017(196, 'Chirurgie Pediatrica', 10, 8),
1018(197, 'Chirurgie Toracica', 10, 8),
1019(198, 'Chirurgie Vasculara', 10, 8),
1020(199, 'Dependenta De Alcool Si Droguri', 10, 8),
1021(200, 'Drenaj Limfatic', 10, 8),
1022(201, 'Epidemiologie', 10, 8),
1023(202, 'Farmaceutica Si Cosmetica', 10, 8),
1024(203, 'Farmacologie Clinica', 10, 8),
1025(204, 'Flebologie', 10, 8),
1026(205, 'Genetica Medicala', 10, 8),
1027(206, 'Geriatrie Si Gerontologie', 10, 8),
1028(207, 'Homeopatie', 10, 8),
1029(208, 'Laborator Farmaceutic', 10, 8),
1030(209, 'Laborator Tehnica Dentara', 10, 8),
1031(210, 'Medicina Ayurvedica', 10, 8),
1032(211, 'Medicina De Urgenta', 10, 8),
1033(212, 'Medicina Legala', 10, 8),
1034(213, 'Medicina Nucleara', 10, 8),
1035(214, 'Neurochirurgie', 10, 8),
1036(215, 'Ozonterapie', 10, 8),
1037(216, 'Pneumofiziologie', 10, 8),
1038(217, 'Proctologie', 10, 8),
1039(218, 'Radiologie Interventionala', 10, 8),
1040(219, 'Radioterapie', 10, 8),
1041(220, 'Sanatate Publica', 10, 8),
1042(221, 'Stiinte Medicale', 10, 8),
1043(222, 'Pentru barbati', -10, 9),
1044(223, 'Servicii la domiciliu', -10, 9),
1045(224, 'Coafura/frizerie', 0, 9),
1046(225, 'Manechiura', 0, 9),
1047(226, 'Make-up', 0, 9),
1048(227, 'Epilare definitiva', 0, 9),
1049(228, 'Centre de masaj', 0, 9),
1050(229, 'Centre de santatate SPA', 0, 9),
1051(230, 'Centre de tratament', 0, 9),
1052(231, 'Centre Sauna/Piscina', 0, 9),
1053(232, 'De infrumusetare', 10, 9),
1054(233, 'Extensii par', 10, 9),
1055(234, 'Cosmetica', 10, 9),
1056(235, 'Unghii false', 10, 9),
1057(236, 'Bronzare (solar)', 10, 9),
1058(237, 'Bronzare organica', 10, 9),
1059(238, 'Saloane organice (produse BIO)', 10, 9),
1060(239, 'Saloane de Tatuaje/Piercing', 10, 9),
1061(240, 'Remodelara corporala', 10, 9),
1062(241, 'Centre de chirurgie estetica', 10, 9),
1063(242, 'Cluburi Fitness/aerobic', 10, 9),
1064(243, 'Efecte nunta', -10, 10),
1065(244, 'Foto - video', -10, 10),
1066(245, 'Hostess, paza nunta', -10, 10),
1067(246, 'Cavaleri, domnisoare', -10, 10),
1068(247, 'Invitatii nunta, meniuri', -10, 10),
1069(248, 'Marturii, cadouri invitati', -10, 10),
1070(249, 'Servicii extra', -10, 10),
1071(250, 'Sonorizare, DJ, formatii', -10, 10),
1072(251, 'Agentii nunti', 0, 10),
1073(252, 'Flori, lumanari nunta', 0, 10),
1074(253, 'Saloane de frumusete', 0, 10),
1075(254, 'Cadouri nunta', 0, 10),
1076(255, 'Decoratiuni nunta', 0, 10),
1077(256, 'Imbracaminte ocazie femei', 0, 10),
1078(257, 'Imbracaminte ocazie barbati', 0, 10),
1079(258, 'Rochii mireasa', 0, 10),
1080(259, 'Tortul miresei, dulciuri', 0, 10),
1081(260, 'Transport nunta', 0, 10),
1082(261, 'Verighete, bijuterii', 0, 10),
1083(262, 'Voiaj nunta', 0, 10),
1084(263, 'Biserici nunti', 10, 10),
1085(264, 'Costume mire, accesorii', 10, 10),
1086(265, 'Oficii stare civila', 10, 10),
1087(266, 'Restaurante, locatii, catering', 10, 10),
1088(267, 'Zugrav - Amenajari interioare', -10, 11),
1089(268, 'Zidar - Constructor', -10, 11),
1090(269, 'Instalator apa', -10, 11),
1091(270, 'Parchetar', -10, 11),
1092(271, 'Cosar', -10, 11),
1093(272, 'Sobar', -10, 11),
1094(273, 'Gradinar', -10, 11),
1095(274, 'Geamgiu', -10, 11),
1096(275, 'Diriginte de santier', -10, 11),
1097(276, 'Tapiter', -10, 11),
1098(277, 'Tinichigiu', -10, 11),
1099(278, 'Sudor', -10, 11),
1100(279, 'Altele (Mestesuguri)', -10, 11),
1101(280, 'Croitor', -10, 11),
1102(281, 'Strungar', -10, 11),
1103(282, 'Lacatus-confectii metalice', -10, 11),
1104(283, 'Cizmar', -10, 11),
1105(284, 'Inginer de structura', -10, 11),
1106(285, 'Tamplar - Dulgher', 0, 11),
1107(286, 'Cadastru', 0, 11),
1108(287, 'Tamplarie PVC - Geam termopan', 0, 11),
1109(288, 'Reparatii Electronice si electrocasnice', 0, 11),
1110(289, 'Instalare si service aer conditionat', 0, 11),
1111(290, 'Electronist-electrocasnice', 0, 11),
1112(291, 'Service masini de spalat', 0, 11),
1113(292, 'Service frigidere', 0, 11),
1114(293, 'Service GSM', 0, 11),
1115(294, 'Service audio-video', 0, 11),
1116(295, 'Altele (Constructii si amenajari)', 0, 11),
1117(296, 'Electrician', 0, 11),
1118(297, 'Design interior', 10, 11),
1119(298, 'Mobila', 10, 11),
1120(299, 'Hidroizolatii', 10, 11),
1121(300, 'Acoperisuri', 10, 11),
1122(301, 'Alpinist utilitar', 10, 11),
1123(302, 'Instalator gaze', 10, 11),
1124(303, 'Termoizolatii', 10, 11),
1125(304, 'Sisteme de securitate', 10, 11),
1126(305, 'Arhitect', 10, 11),
1127(306, 'Altele (Arhitectura-proiectare)', 10, 11);
1128
1129DROP TABLE IF EXISTS `tipuri_companie`;
1130CREATE TABLE `tipuri_companie` (
1131 `id` int(11) NOT NULL AUTO_INCREMENT,
1132 `nume` varchar(50) NOT NULL,
1133 `discount` int(3) NOT NULL,
1134 PRIMARY KEY (`id`)
1135) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1136
1137INSERT INTO `tipuri_companie` (`id`, `nume`, `discount`) VALUES
1138(1, 'PFA', -10),
1139(2, 'II - Intrep Indiv', -10),
1140(3, 'IF - Intrep Fam', -10),
1141(4, 'SRL', 0),
1142(5, 'SCS', 0),
1143(6, 'SNC', 0),
1144(7, 'SA', 10),
1145(8, 'SCA', 10),
1146(9, 'GIE', 10),
1147(10, 'GEIE', 10),
1148(11, 'SE', 10);
1149
1150DROP TABLE IF EXISTS `tokens`;
1151CREATE TABLE `tokens` (
1152 `id` int(11) NOT NULL AUTO_INCREMENT,
1153 `token` varchar(100) NOT NULL,
1154 `email` varchar(50) NOT NULL,
1155 `tip` int(1) NOT NULL,
1156 `timestamp` datetime NOT NULL,
1157 PRIMARY KEY (`id`)
1158) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1159
1160INSERT INTO `tokens` (`id`, `token`, `email`, `tip`, `timestamp`) VALUES
1161(1, '997da698c37e7970711635bd884abf89', 'alin.xear@gmail.com', 1, '2016-03-17 01:38:48'),
1162(2, '66a345a94b8b085429a119e561dee3ef', 'mi_au_ciordit_parola@yahoo.com', 1, '2016-03-17 02:04:41'),
1163(3, '34a551aea0f79ca49b9376fb07b60953', 'sergiu.badic@gmail.com', 1, '2016-03-17 10:41:38'),
1164(4, 'ea7287b98794f594360dd2e321337a9b', 'sergiu.badic@gmail.com', 2, '2016-03-17 11:12:18'),
1165(5, 'd9720db9dd24df04c94ae9a7b7cdf845', 'sergiu.badic@gmail.com', 2, '2016-03-17 23:25:29'),
1166(6, '36b1e4c6e95901d9e6a537bef9f7d8a8', 'sergiu.badic@kubisinteractive.com', 1, '2016-03-20 04:50:13'),
1167(7, 'a6b497c8964adf1f1fde38e18d4c699c', 'asd@asd.ro', 1, '2016-04-02 10:40:22'),
1168(8, '0652ad8e3463e881b7aec0f188608c4b', 'asd@asd.roz', 1, '2016-04-06 02:48:30'),
1169(9, '79c104643db78649e3d996c59b82c775', 'sergiu.badic@gmail.com', 1, '2016-04-07 11:54:06');
1170
1171-- 2016-04-07 13:32:46