API tools faq
paste
Advertisement
sergiubadic

dev myales

sergiubadic
Apr 7th, 2016
837
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 38.40 KB | None | 0 0
raw download clone embed print report
  1. -- Adminer 4.2.3 MySQL dump
  2.  
  3. SET NAMES utf8;
  4. SET time_zone = '+00:00';
  5. SET foreign_key_checks = 0;
  6. SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  7.  
  8. DROP TABLE IF EXISTS `abonamente`;
  9. CREATE 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.  
  24. INSERT 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.  
  27. DROP TABLE IF EXISTS `admins`;
  28. CREATE 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.  
  37. INSERT INTO `admins` (`id`, `username`, `parola`, `type`, `timestamp`) VALUES
  38. (1, 'admin', '74b99d0a9f1c249fadaa84e03a7e2c44', '1', '2016-01-12 21:40:25');
  39.  
  40. DROP TABLE IF EXISTS `adrese`;
  41. CREATE 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.  
  52. INSERT 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.  
  59. DROP TABLE IF EXISTS `beneficiari`;
  60. CREATE 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.  
  75. INSERT 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.  
  84. DROP TABLE IF EXISTS `beneficiari_logins`;
  85. CREATE 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.  
  92. INSERT 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.  
  109. DROP TABLE IF EXISTS `blog`;
  110. CREATE 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.  
  118. DROP TABLE IF EXISTS `cereri`;
  119. CREATE 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.  
  129. INSERT 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.  
  145. DROP TABLE IF EXISTS `comenzi`;
  146. CREATE 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.  
  159. INSERT 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.  
  163. DROP TABLE IF EXISTS `domenii`;
  164. CREATE 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.  
  171. INSERT 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.  
  183. DROP TABLE IF EXISTS `inregistrari_neterminate`;
  184. CREATE 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.  
  191. INSERT 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.  
  247. DROP TABLE IF EXISTS `judete`;
  248. CREATE TABLE `judete` (
  249. `id` int(2) NOT NULL,
  250. `nume` varchar(50) NOT NULL
  251. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  252.  
  253. INSERT 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.  
  297. DROP TABLE IF EXISTS `media`;
  298. CREATE 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.  
  307. INSERT 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.  
  316. DROP TABLE IF EXISTS `membri`;
  317. CREATE 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.  
  326. INSERT 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.  
  332. DROP TABLE IF EXISTS `mesaje`;
  333. CREATE 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.  
  342. INSERT 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.  
  350. DROP TABLE IF EXISTS `mesaje_status`;
  351. CREATE 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.  
  357. DROP TABLE IF EXISTS `migrations`;
  358. CREATE TABLE `migrations` (
  359. `version` bigint(20) NOT NULL
  360. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  361.  
  362. INSERT INTO `migrations` (`version`) VALUES
  363. (20160501173000);
  364.  
  365. DROP TABLE IF EXISTS `numar_angajati`;
  366. CREATE 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.  
  373. INSERT INTO `numar_angajati` (`id`, `numar`, `discount`) VALUES
  374. (1, '<5', 0),
  375. (2, '5 - 15', 10),
  376. (3, '15 - 30', 20);
  377.  
  378. DROP TABLE IF EXISTS `orase`;
  379. CREATE 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.  
  385. INSERT 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.  
  707. DROP TABLE IF EXISTS `pachete`;
  708. CREATE 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.  
  716. INSERT 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.  
  721. DROP TABLE IF EXISTS `prestatori`;
  722. CREATE 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.  
  758. INSERT 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', '&lt;p&gt;qdwq&lt;/p&gt;', '&lt;p&gt;asd&lt;/p&gt;\r\n&lt;p&gt;&lt;img src=&quot;public/uploads/media/dummy.png&quot; alt=&quot;&quot; width=&quot;640&quot; height=&quot;480&quot;&gt;&lt;/p&gt;', NULL, '1', '2', '6e8ffd88e1d8ec3af8066cf1aa860ae9.jpg', '534207d186d79f4640bb82116a07dea8.png', 'ceva', 1, '1153c3c47c156dc7281fa536f60d2f90', '[]', '2016-04-02 10:30:50');
  760.  
  761. DROP TABLE IF EXISTS `prestatori_logins`;
  762. CREATE 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.  
  769. INSERT 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.  
  782. DROP TABLE IF EXISTS `preturi_pachete`;
  783. CREATE 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.  
  790. INSERT 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.  
  795. DROP TABLE IF EXISTS `servicii`;
  796. CREATE 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.  
  808. INSERT INTO `servicii` (`id`, `id_prestator`, `titlu`, `descriere`, `pret`, `mod_cumparare`, `cumparare_online`, `timestamp`) VALUES
  809. (1, 30, 'serviciu 1', '&lt;p&gt;descriere&lt;/p&gt;\r\n&lt;p&gt;&lt;strong&gt;serviciu&lt;/strong&gt;&lt;/p&gt;', '100', 'ora', 1, '2016-03-31 12:20:34'),
  810. (2, 33, 'serv 1', '&lt;p&gt;dqwdqwe&lt;/p&gt;', '12', 'fix', 1, '2016-04-06 04:21:59');
  811.  
  812. DROP TABLE IF EXISTS `subdomenii`;
  813. CREATE 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.  
  821. INSERT 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.  
  1129. DROP TABLE IF EXISTS `tipuri_companie`;
  1130. CREATE 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.  
  1137. INSERT 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.  
  1150. DROP TABLE IF EXISTS `tokens`;
  1151. CREATE 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.  
  1160. INSERT 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
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!