Advertisement
IvanSostarko

baza matko

Jul 11th, 2015
825
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 47.37 KB | None | 0 0
  1. -- Adminer 4.2.1 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 `add_company`;
  9. CREATE TABLE `add_company` (
  10. `id` int(11) NOT NULL AUTO_INCREMENT,
  11. `company` varchar(64) NOT NULL,
  12. `country` varchar(64) NOT NULL,
  13. `city` varchar(64) NOT NULL,
  14. `url` varchar(64) NOT NULL,
  15. `email` varchar(64) NOT NULL,
  16. `phone` varchar(64) NOT NULL,
  17. `resolved` int(1) NOT NULL DEFAULT '0',
  18. `updated_at` datetime NOT NULL,
  19. `created_at` datetime NOT NULL,
  20. PRIMARY KEY (`id`)
  21. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  22.  
  23.  
  24. DROP TABLE IF EXISTS `app`;
  25. CREATE TABLE `app` (
  26. `id` int(11) NOT NULL AUTO_INCREMENT,
  27. `terms` text NOT NULL,
  28. `windows_url` varchar(64) NOT NULL,
  29. `iphone_url` varchar(64) NOT NULL,
  30. `android_url` varchar(64) NOT NULL,
  31. `website` varchar(32) NOT NULL,
  32. `facebook_page` varchar(64) NOT NULL,
  33. `twitter_page` varchar(64) NOT NULL,
  34. `email` varchar(64) NOT NULL,
  35. `maintenance` int(11) NOT NULL,
  36. `version_wp` int(11) NOT NULL,
  37. `updated_at` datetime NOT NULL,
  38. `created_at` datetime NOT NULL,
  39. PRIMARY KEY (`id`)
  40. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  41.  
  42. INSERT INTO `app` (`id`, `terms`, `windows_url`, `iphone_url`, `android_url`, `website`, `facebook_page`, `twitter_page`, `email`, `maintenance`, `version_wp`, `updated_at`, `created_at`) VALUES
  43. (1, '<p>\r\n Terms Of Service &amp; Privacy Policy\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n Privacy policy together with terms of service have been compiled to better serve those who are concerned with how their \'Personally identifiable\r\n information\' (PII) is being used online. Please read our privacy policy carefully to get a clear understanding of how we collect, use, protect or otherwise\r\n handle your Personally Identifiable Information in accordance with our website. Also are there are Terms of service.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n What personal information do we collect from the people that visit our blog, website or app?\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n When ordering or registering on our site, as appropriate, you may be asked to enter your email address, credit card information or other details to help\r\n you with your experience.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n When do we collect information?\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n We collect information from you when you register on our site, fill out a form or enter information on our site.\r\n</p>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<p>\r\n How do we use your information?\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n We may use the information we collect from you when you register, make a purchase, sign up for our newsletter, respond to a survey or marketing\r\n communication, surf the website, or use certain other site features in the following ways:\r\n</p>\r\n<br/>\r\n<p>\r\n • To personalize user\'s experience and to allow us to deliver the type of content and product offerings in which you are most interested.\r\n</p>\r\n<br/>\r\n<p>\r\n • To allow us to better service you in responding to your customer service requests.\r\n</p>\r\n<br/>\r\n<p>\r\n • To quickly process your transactions.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n How do we protect visitor information?\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n Our website is scanned on a regular basis for security holes and known vulnerabilities in order to make your visit to our site as safe as possible.\r\n</p>\r\n<br/>\r\n<p>\r\n We use regular Malware Scanning.\r\n</p>\r\n<br/>\r\n<p>\r\n Your personal information is contained behind secured networks and is only accessible by a limited number of persons who have special access rights to such\r\n systems, and are required to keep the information confidential. In addition, all sensitive/credit information you supply is encrypted.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n We implement a variety of security measures when a user enters, submits, or accesses their information to maintain the safety of your personal information.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n All transactions are processed through a gateway provider and are not stored or processed on our servers.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n Do we use \'cookies\'?\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n Yes. Cookies are small files that a site or its service provider transfers to your computer\'s hard drive through your Web browser (if you allow) that\r\n enables the site\'s or service provider\'s systems to recognize your browser and capture and remember certain information. For instance, we use cookies to\r\n help us remember and process the history of your orders and favourites. They are also used to help us understand your preferences based on previous or\r\n current site activity, which enables us to provide you with improved services. We also use cookies to help us compile aggregate data about site traffic and\r\n site interaction so that we can offer better site experiences and tools in the future.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n We use cookies to:\r\n</p>\r\n<br/>\r\n<p>\r\n • Understand and save user\'s preferences for future visits.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n You can choose to have your computer or device warn you each time a cookie is being sent, or you can choose to turn off all cookies. You do this through\r\n your browser (like Internet Explorer) settings. Each browser is a little different, so look at your browser\'s Help menu to learn the correct way to modify\r\n your cookies.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n If you disable cookies off, some features will be disabled It won\'t affect the users experience that make your site experience more efficient and some of\r\n our services will not function properly.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n However, you can still place orders .\r\n</p>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<p>\r\n Third Party Disclosure\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n We do not sell, trade, or otherwise transfer to outside parties your personally identifiable information unless we provide you with advance notice. This\r\n does not include website hosting partners and other parties who assist us in operating our website, conducting our business, or servicing you, so long as\r\n those parties agree to keep this information confidential. We may also release your information when we believe release is appropriate to comply with the\r\n law, enforce our site policies, or protect ours or others\' rights, property, or safety.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n However, non-personally identifiable visitor information may be provided to other parties for marketing, advertising, or other uses.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n Third party links\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n Occasionally, at our discretion, we may include or offer third party products or services on our website. These third party sites have separate and\r\n independent privacy policies. We therefore have no responsibility or liability for the content and activities of these linked sites. Nonetheless, we seek\r\n to protect the integrity of our site and welcome any feedback about these sites.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n Google\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n Google\'s advertising requirements can be summed up by Google\'s Advertising Principles. They are put in place to provide a positive experience for users.\r\n https://support.google.com/adwordspolicy/answer/1316548?hl=en\r\n</p>\r\n<br/>\r\n<p>\r\n We have not enabled Google AdSense on our site but we may do so in the future.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n How does our site handle do not track signals?\r\n</p>\r\n<br/>\r\n<p>\r\n We honor do not track signals and do not track, plant cookies, or use advertising when a Do Not Track (DNT) browser mechanism is in place.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n Does our site allow third party behavioral tracking?\r\n</p>\r\n<br/>\r\n<p>\r\n It\'s also important to note that we do not allow third party behavioral tracking\r\n</p>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<p>\r\n COPPA (Children Online Privacy Protection Act)\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n When it comes to the collection of personal information from children under 13, the Children\'s Online Privacy Protection Act (COPPA) puts parents in\r\n control. The Federal Trade Commission, the nation\'s consumer protection agency, enforces the COPPA Rule, which spells out what operators of websites and\r\n online services must do to protect children\'s privacy and safety online.\r\n</p>\r\n<br/>\r\n<p>\r\n We do not specifically market to children under 13.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n Fair Information Practices\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n The Fair Information Practices Principles form the backbone of privacy law in the United States and the concepts they include have played a significant\r\n role in the development of data protection laws around the globe. Understanding the Fair Information Practice Principles and how they should be implemented\r\n is critical to comply with the various privacy laws that protect personal information.\r\n</p>\r\n<br/>\r\n<p>\r\n In order to be in line with Fair Information Practices we will take the following responsive action, should a data breach occur:\r\n</p>\r\n<br/>\r\n<p>\r\n We will notify the users via email\r\n</p>\r\n<br/>\r\n<p>\r\n • Within 1 business day\r\n</p>\r\n<br/>\r\n<p>\r\n We will notify the users via in site notification\r\n</p>\r\n<br/>\r\n<p>\r\n • Within 1 business day\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n We also agree to the individual redress principle, which requires that individuals have a right to pursue legally enforceable rights against data\r\n collectors and processors who fail to adhere to the law. This principle requires not only that individuals have enforceable rights against data users, but\r\n also that individuals have recourse to courts or a government agency to investigate and/or prosecute non-compliance by data processors.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n CAN SPAM Act\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n The CAN-SPAM Act is a law that sets the rules for commercial email, establishes requirements for commercial messages, gives recipients the right to have\r\n emails stopped from being sent to them, and spells out tough penalties for violations.\r\n</p>\r\n<br/>\r\n<p>\r\n We collect your email address in order to:\r\n</p>\r\n<br/>\r\n<p>\r\n • Send information, respond to inquiries, and/or other requests or questions.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n To be in accordance with CANSPAM we agree to the following:\r\n</p>\r\n<br/>\r\n<p>\r\n • NOT use false, or misleading subjects or email addresses\r\n</p>\r\n<br/>\r\n<p>\r\n • Identify the message as an advertisement in some reasonable way\r\n</p>\r\n<br/>\r\n<p>\r\n • Include the physical address of our business or site headquarters\r\n</p>\r\n<br/>\r\n<p>\r\n • Monitor third party email marketing services for compliance, if one is used.\r\n</p>\r\n<br/>\r\n<p>\r\n • Honor opt-out/unsubscribe requests quickly\r\n</p>\r\n<br/>\r\n<p>\r\n • Allow users to unsubscribe by using the link at the bottom of each email\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n If at any time you would like to unsubscribe from receiving future emails, you can email us at\r\n</p>\r\n<br/>\r\n<p>\r\n info@cab-app.eu and we will promptly remove you from ALL correspondence.\r\n</p>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<p>\r\n Terms of service\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n Further in these Terms of Service, end-user will be addressed as: “you“ and/or “user“ and/or “company“, while CabApp and all products that are made,\r\n published and developed by CabApp will be refered as “we“, “CabApp“,\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n Tracking location\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n Any application issued by CabApp will track your location only when you are tracking it yourself inside the application. CabApp will store these tracks to\r\n improve your future expirience of using CabApp products. Also, CabApp will store your location when you order a taxi service through any of CabApp\'s\r\n applications in order to improve your future expirience of using CabApp\'s products.\r\n</p>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<p>\r\n Using Internet\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n CabApp\'s produtcs use interenet connection to connect and update dana inside applications. CabApp is not responsible in any way of your expenses with your\r\n mobile service provider.\r\n</p>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<p>\r\n Using a taxi service ordered over one of CabApp\'s applications\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n CabApp is not responsible in any way of taxi cars and/or taxi drivers and/or taxi companies and/or their behaviour and any other things that can happen to\r\n you before, during and after using services provided by any of CabApp\'s applications.\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n Copyright and trademark\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n CabApp, CabUp and CabApp and CabUp logos are registered trademark of CabApp, all rights reserved.\r\n</p>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<p>\r\n Contacting Us\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n If there are any questions regarding this privacy policy you may contact us using the information below.\r\n</p>\r\n<br/>\r\n<p>\r\n www.cab-app.eu\r\n</p>\r\n<br/>\r\n<br/>\r\n<p>\r\n CabApp\r\n</p>\r\n<br/>\r\n<p>\r\n 10000 Zagreb\r\n</p>\r\n<br/>\r\n<p>\r\n Croatia\r\n</p>\r\n<br/>\r\n<p>\r\n info@cab-app.eu\r\n</p>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<p>\r\n Copyright 2015 CabApp , all rights reserved\r\n</p>\r\n<br/>\r\n<p>\r\n Last Edited on 2015-05-24\r\n</p>\r\n<br/>\r\n<br/>\r\n', 'windows url', 'iphone', 'android', 'http://cabup.eu', 'facebook', 'twitter', 'info@cab-app.eu', 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  44.  
  45. DROP TABLE IF EXISTS `cities`;
  46. CREATE TABLE `cities` (
  47. `id` int(11) NOT NULL AUTO_INCREMENT,
  48. `city` varchar(64) COLLATE utf8_bin NOT NULL,
  49. `country_id` int(11) NOT NULL,
  50. `latitude` varchar(64) COLLATE utf8_bin NOT NULL,
  51. `longitude` varchar(64) COLLATE utf8_bin NOT NULL,
  52. `updated_at` datetime NOT NULL,
  53. `created_at` datetime NOT NULL,
  54. PRIMARY KEY (`id`)
  55. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  56.  
  57. INSERT INTO `cities` (`id`, `city`, `country_id`, `latitude`, `longitude`, `updated_at`, `created_at`) VALUES
  58. (1, 'Zagreb', 1, '45.815011', '15.981919', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  59. (2, 'Osijek', 1, '45.554962', '18.695514', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  60. (3, 'Vara&#382;din', 1, '46.305746', '16.336607', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  61. (4, 'Velika Gorica', 1, '45.714212', '16.075243', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  62. (5, 'Dubrovnik', 1, '42.650661', '18.094424', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  63. (6, 'Karlovac', 1, '45.492897', '15.555268', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  64. (7, 'Samobor', 1, '45.801093', '15.711048', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  65. (8, 'Pula', 1, '44.866623', '13.849579', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  66. (9, 'Slavonski Brod', 1, '45.163143', '18.011608', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  67. (10, 'Ljubljana', 2, '46.056947', '14.505751', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  68. (11, 'Maribor', 2, '46.554650', '15.645881', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  69. (12, 'Split', 1, '43.508132', '16.440193', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  70. (13, '&#352;ibenik', 1, '43.735020', '15.895204', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  71. (14, 'Rijeka', 0, '45.327063', '14.442176', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  72.  
  73. DROP TABLE IF EXISTS `companies`;
  74. CREATE TABLE `companies` (
  75. `id` int(11) NOT NULL AUTO_INCREMENT,
  76. `company` varchar(64) COLLATE utf8_bin NOT NULL,
  77. `start` float NOT NULL,
  78. `km` float NOT NULL,
  79. `bonus_km` varchar(32) COLLATE utf8_bin NOT NULL,
  80. `phone` varchar(32) COLLATE utf8_bin NOT NULL,
  81. `web` varchar(64) COLLATE utf8_bin NOT NULL,
  82. `email` varchar(32) COLLATE utf8_bin NOT NULL,
  83. `country_id` int(11) NOT NULL,
  84. `city_id` int(11) NOT NULL,
  85. `currency_id` int(11) NOT NULL,
  86. `updated_at` datetime NOT NULL,
  87. `created_at` datetime NOT NULL,
  88. PRIMARY KEY (`id`)
  89. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  90.  
  91. INSERT INTO `companies` (`id`, `company`, `start`, `km`, `bonus_km`, `phone`, `web`, `email`, `country_id`, `city_id`, `currency_id`, `updated_at`, `created_at`) VALUES
  92. (1, 'Eko Taxi', 8.8, 6, '0', '0607777', 'www.ekotaxi.hr', 'info@ekotaxi.hr', 1, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  93. (2, 'Radio Taxi Zagreb', 10, 6, '0', '1717', 'http://www.radio-taksi-zagreb.hr/', 'info@radio-taksi-zagreb.hr', 1, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  94. (3, 'Taxi 3430', 19, 7, '0', '+385912223430', 'http://www.taxi3430.hr', 'taxi@taxi3430.hr', 1, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  95. (4, 'Student Taxi Osijek', 20, 7, '5', '+38531200100', 'http://studentitaxi.wordpress.com', 'studenttaxios@gmail.com', 1, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  96. (5, 'TAXI iNOVA - unutar VZ', 19.9, 0, '0', '+385951111777', 'http://www.taxi-inova.hr', 'info@taxi-inova.hr', 1, 3, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  97. (6, 'TAXI iNOVA - izvan VZ', 9, 4, '5', '+385951111777', 'http://www.taxi-inova.hr', 'info@taxi-inova.hr', 1, 3, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  98. (7, 'Taxi Gorica', 16, 9, '0', '+38598660003', 'http://www.taxi-gorica.hr/', 'info@taxi-gorica.hr', 1, 4, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  99. (8, 'Taxi Kazo Dubrovnik', 27, 10, '0', '+38598244868', 'http://dubrovnik-taxi-premium.com/', 'kazo@hi.htnet.hr', 1, 5, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  100. (9, 'Taxi Ambassador', 20, 6, '3', '+385993210123', 'http://www.taxi-karlovac.com', 'taxi.ambasador@gmail.com', 1, 6, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  101. (10, 'City Taxi Samobor', 27, 7.2, '3', '0607654', 'http://www.citytaxi.hr', 'info@citytaxi.hr ', 1, 7, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  102. (11, 'Taxi Samobor - Ivan Crnjak', 30, 8, '3', '+385912530040', 'http://www.taxi-samobor.tk', 'taxicrnjak@net.hr', 1, 7, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  103. (12, 'Taxi Aldo Pula', 20, 8, '0', '+38598367367', 'http://www.taxi-aldo.hr', 'info@taxi-aldo.hr', 1, 8, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  104. (13, 'Taxi Edi Pula', 15, 10, '0', '+38598440844', 'http://www.taxipula.com/', 'info@taxipula.com', 1, 8, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  105. (14, 'Taxi Zoki Brada', 15, 7, '0', '+385923064646', 'http://www.taxizokibrada.com/', 'zoran.racic1@pu.t-com.hr', 1, 8, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  106. (15, 'Taxi Dobra Vila', 20, 7, '0', '+385912339993', 'http://www.taxidobravila.com/', 'taxidobravila@gmail.com', 1, 9, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  107. (16, 'Taxi Novi Val', 20, 20, '5', '+385914300001', 'http://www.taxinovival.com', 'info@taxinovival.com', 1, 9, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  108. (17, 'Taxi Auto Reli', 20, 4, '5', '+385913000404', 'http://www.autorelitaxi.com', 'info@autorelitaxi.com', 1, 9, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  109. (18, 'Intertours Taxi', 1, 1.29, '0', '080311311', 'http://www.taxi-intertours.si/', 'info@taxi-intertours.si', 2, 1, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  110. (19, 'Gea Taxi', 1, 1, '0', '+3864333444', 'http://www.gea-taxi.biz/', 'info@gea-taxi.biz', 2, 1, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  111. (20, 'Taxi Drustvo Ljubljana', 1.5, 1.1, '0', '+38612349000', 'http://www.taxi-ljubljana.si/', 'info@taxi-ljubljana.si', 2, 1, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  112. (21, 'Taxi Laguna', 0.93, 0.89, '0', '0801233', 'http://www.taxi-laguna.com', 'taxi.laguna@siol.net', 2, 1, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  113. (22, 'Iguana Taxi', 0.93, 0.89, '0', '0801889', 'http://iguanaplus.com/taksi-ljubljana/slo', 'iguanaplus@hotmail.com', 2, 1, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  114. (23, 'Taxi Metro', 0.95, 0.89, '0', '0801190', 'http://www.taximetro.si/', 'info@taximetro.si', 2, 1, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  115. (24, 'Rumeni Taxi', 1, 1.9, '0', '+38641731831', 'http://www.rumenitaxi.com/', 'info@rumenitaxi.com', 2, 1, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  116. (25, 'Taxi Maribor', 0.95, 0.9, '0', '0801720', 'http://www.taxi-maribor.com/', 'peter.rola@triera.net', 2, 2, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  117. (26, 'Auto Taxi Split', 20, 10, '0', '+38598510332', 'http://http://www.autotaxisplit-leut.hr', 'autotaxisplit@gmail.com', 1, 26, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  118. (27, 'Taxi Cammeo - Zagreb', 15, 6, '2', '+385 1 12 12', 'http://taxi-cammeo.hr/', 'info-zagreb@taxi-cammeo.hr', 1, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  119. (28, 'Taxi Cammeo - Varazdin', 20, 5, '5', '+385 1 12 12', 'http://taxi-cammeo.hr/', 'info-varazdin@taxi-cammeo.hr', 1, 3, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  120. (29, 'Taxi Cammeo - &#352;ibenik', 40, 10, '5', '+385 1 12 12', 'http://taxi-cammeo.hr/', 'info-sibenik@taxi-cammeo.hr', 1, 13, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  121. (30, 'Taxi Cammeo - Rijeka', 20, 5, '5', '+385 1 12 12', 'http://taxi-cammeo.hr/', 'info-rijeka@taxi-cammeo.hr', 1, 14, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  122. (31, 'Taxi Cammeo - Osijek', 20, 5, '5', '+385 1 12 12', 'http://taxi-cammeo.hr/', 'info-osijek@taxi-cammeo.hr', 1, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  123.  
  124. DROP TABLE IF EXISTS `countries`;
  125. CREATE TABLE `countries` (
  126. `id` int(11) NOT NULL AUTO_INCREMENT,
  127. `country` varchar(64) COLLATE utf8_bin NOT NULL,
  128. `img_wp` varchar(64) COLLATE utf8_bin NOT NULL,
  129. `country_code` varchar(64) COLLATE utf8_bin NOT NULL,
  130. `updated_at` datetime NOT NULL,
  131. `created_at` datetime NOT NULL,
  132. PRIMARY KEY (`id`)
  133. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  134.  
  135. INSERT INTO `countries` (`id`, `country`, `img_wp`, `country_code`, `updated_at`, `created_at`) VALUES
  136. (1, 'Croatia', '\"http://cab-app.eu/api/images/flags/hr.png\"', '+385', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  137. (2, 'Slovenia', '\"http://cab-app.eu/api/images/flags/slovenia.png\"', '+386', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  138.  
  139. DROP TABLE IF EXISTS `currencies`;
  140. CREATE TABLE `currencies` (
  141. `id` int(11) NOT NULL AUTO_INCREMENT,
  142. `currency` varchar(32) COLLATE utf8_bin NOT NULL,
  143. `simbol` varchar(32) COLLATE utf8_bin NOT NULL,
  144. `updated_at` datetime NOT NULL,
  145. `created_at` datetime NOT NULL,
  146. PRIMARY KEY (`id`)
  147. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  148.  
  149. INSERT INTO `currencies` (`id`, `currency`, `simbol`, `updated_at`, `created_at`) VALUES
  150. (1, 'Kuna', 'Kn', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  151. (2, 'Euro', '&#8364;', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  152.  
  153. DROP TABLE IF EXISTS `favorites`;
  154. CREATE TABLE `favorites` (
  155. `id` int(11) NOT NULL AUTO_INCREMENT,
  156. `user_id` int(11) NOT NULL,
  157. `favorite` varchar(128) NOT NULL,
  158. `start` varchar(128) NOT NULL,
  159. `end` varchar(128) NOT NULL,
  160. `updated_at` datetime NOT NULL,
  161. `created_at` datetime NOT NULL,
  162. PRIMARY KEY (`id`)
  163. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  164.  
  165.  
  166. DROP TABLE IF EXISTS `intelligence`;
  167. CREATE TABLE `intelligence` (
  168. `id` int(11) NOT NULL AUTO_INCREMENT,
  169. `start` varchar(128) NOT NULL,
  170. `end` varchar(128) NOT NULL,
  171. `direction` varchar(128) NOT NULL,
  172. `time` float NOT NULL,
  173. `country_id` int(11) NOT NULL,
  174. `city_id` int(11) NOT NULL,
  175. `user_id` int(11) NOT NULL,
  176. `language_id` int(11) NOT NULL,
  177. `updated_at` datetime NOT NULL,
  178. `created_at` datetime NOT NULL,
  179. PRIMARY KEY (`id`)
  180. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  181.  
  182.  
  183. DROP TABLE IF EXISTS `languages`;
  184. CREATE TABLE `languages` (
  185. `id` int(11) NOT NULL AUTO_INCREMENT,
  186. `language` varchar(32) NOT NULL,
  187. `updated_at` datetime NOT NULL,
  188. `created_at` datetime NOT NULL,
  189. PRIMARY KEY (`id`)
  190. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  191.  
  192. INSERT INTO `languages` (`id`, `language`, `updated_at`, `created_at`) VALUES
  193. (1, 'Croatian', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  194.  
  195. DROP TABLE IF EXISTS `poi`;
  196. CREATE TABLE `poi` (
  197. `id` int(11) NOT NULL AUTO_INCREMENT,
  198. `city_id` int(11) NOT NULL,
  199. `name` varchar(64) NOT NULL,
  200. `address` varchar(128) NOT NULL,
  201. `updated_at` datetime NOT NULL,
  202. `created_at` datetime NOT NULL,
  203. PRIMARY KEY (`id`)
  204. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  205.  
  206. INSERT INTO `poi` (`id`, `city_id`, `name`, `address`, `updated_at`, `created_at`) VALUES
  207. (1, 1, 'Glavni &#382;eljezni&#269;ki kolodvor', 'Trg kralja Tomislava 12, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  208. (2, 1, 'Autobusni kolodvor', 'Avenija Marina Drzica 4, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  209. (3, 1, 'Po&#353;ta Branimirova 4', 'Branimirova 4, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  210. (4, 1, 'Po&#353;ta, Dubrava', 'Dubrava 53, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  211. (5, 1, 'Po&#353;ta, Ilica', 'Ilica 508, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  212. (6, 1, 'Po&#353;ta Britanski trg', 'Britanski trg 11, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  213. (7, 1, 'KOTA', 'Meduli&#263;eva 10, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  214. (8, 1, 'Booksa', 'Marti&#263;eva 14D, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  215. (9, 1, 'Vanilla', 'Branimirova 29, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  216. (10, 1, 'Murano', 'Radni&#269;ka cesta 46, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  217. (11, 1, 'KSET', 'Unska 3, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  218. (12, 1, '1st coffee', 'Preradovi&#263;eva 12, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  219. (13, 1, 'Tvornica kulture', '&#353;ubi&#263;eva 2, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  220. (14, 1, 'Egoist', 'Pako&#353;tanska 5, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  221. (15, 1, 'Baredo Caffe', 'Var&#353;avska 5a, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  222. (16, 1, 'Esplanade 1925', 'Mihanovi&#263;eva 1, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  223. (17, 1, 'Cake Land', 'Bukova&#269;ka 27, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  224. (18, 1, 'Panorama Zagreb Hotel', 'Trg Kre&#353;imira &#263;osi&#263;a 9, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  225. (19, 1, 'DoubleTree by Hilton Hotel Zagreb', 'Ulica grada Vukovara 269A, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  226. (20, 1, 'Palace Hotel', 'Trg Josipa Jurja Strossmayera 10, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  227. (21, 1, 'Esplanade Zagreb Hotel', 'Mihanovi&#263;eva 1, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  228. (22, 1, 'Hotel Sheraton Zagreb', 'Ulica kneza Borne 2, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  229. (23, 1, 'Hotel Zovko', 'Slavonska Avenija 59, Zagreb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  230. (24, 2, '&#382;eljezni&#269;ki kolodvor Osijek', 'Trg Lavoslava Ru&#382;i&#269;ke 2, Osijek', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  231. (25, 2, 'Autobusni kolodvor Osijek', 'Ulica Bartola Ka&#353;i&#263;a 70, Osijek', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  232. (26, 2, 'Hotel Vila Ariston', 'Ulica fra Andrije Ka&#269;i&#263;a Mio&#353;i&#263;a 6, Osijek', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  233. (27, 2, 'Hotel Drava', 'Ulica Ivana Gunduli&#263;a 25A, Osijek', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  234. (28, 2, 'Hotel Millennium', 'Ulica kralja Petra Sva&#269;i&#263;a 12, Osijek', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  235. (29, 2, 'Hotel Central', 'Trg Ante Star&#269;evi&#263;a 6, Osijek', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  236. (30, 2, 'Hotel Silver', 'Ulica Martina Divalta 84, Osijek', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  237. (31, 2, 'Hotel Osijek', '&#353;ama&#269;ka 4, Osijek', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  238. (32, 3, 'Hotel Turist', 'Aleja kralja Zvonimira 1, Vara&#382;din', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  239. (33, 3, 'Hotel Vara&#382;din', 'Kolodvorska ulica 19, Vara&#382;din', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  240. (34, 3, 'Hotel Istra', 'Ulica Ivana Kukuljevi&#263;a Sakcinskog 6, Vara&#382;din', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  241. (35, 3, 'Pansion Garestin', 'Zagreba&#269;ka ulica 34, Vara&#382;din', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  242. (36, 3, 'Hotel Park', 'Ulica Zrinsko Frankopanska 14, Vara&#382;din', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  243. (37, 3, '&#382;eljezni&#269;ka postaja Vara&#382;din', 'Kolodvorska ulica 17, Vara&#382;din', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  244. (38, 3, 'Autobusna postaja Vara&#382;din', 'Zrinskih I Frankopana BB, Vara&#382;din', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  245. (39, 4, 'Autobusni kolodvor Velika Gorica', 'Trg kralja Petra Kre&#353;imira IV BB, Velika Gorica', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  246. (40, 4, 'ROOMS PLESO', 'Ulica Vladimira Nazora 8, Velika Gorica', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  247. (41, 4, 'Hotel Bijela Ru&#382;a', 'Trg kralja Tomislava 38, Velika Gorica', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  248. (42, 4, 'Garni Hotel', 'Mikul&#269;i&#263;eva ulica 7A, Velika Gorica', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  249. (43, 4, 'Preno&#263;i&#353;te Barba Niko', 'Ple&#353;ka ulica 125, Velika Gorica', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  250. (44, 4, 'Guesthouse \"Stari Jasen\"', 'Ulica Karla Weingartnera 11, Velika Gorica', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  251. (45, 4, 'Best Wester Hotel Stella', 'Nadinska ulica, Velika Gorica', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  252. (46, 5, 'Trajektna luka Dubrovnik', 'Obala pape Ivana Pavla II 44A, Dubrovnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  253. (47, 5, 'Autobusni kolodvor Dubrovnik', 'Obala pape Ivana Pavla II 44A, Dubrovnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  254. (48, 5, 'Hotel Dubrovnik', '&#353;etali&#353;te kralja Zvonimira 16, Dubrovnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  255. (49, 5, 'Hotel Dubrovnik Palace', 'Masarykov put 20, Dubrovnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  256. (50, 5, 'Hilton Imperial Dubrovnik Hotel', 'Ulica Marijana Bla&#382;i&#263;a 2, Dubrovnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  257. (51, 5, 'Rixos Libertas Dubrovnik', 'Liechtensteinov put 3, Dubrovnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  258. (52, 5, 'Hotel Lapad', 'Lapadska obala 37, Dubrovnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  259. (53, 5, 'Hotel Neptun', 'Ulica kardinala Stepinca, Dubrovnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  260. (54, 5, 'Hotel Lero', 'Ulica Iva Vojnovi&#263;a 14, Dubrovnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  261. (55, 5, 'Valamar Lacroma Dubrovnik', 'Ulica Iva Dul&#269;i&#263;a 34, Dubrovnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  262. (56, 5, 'Tirena Hotel', 'Ulica Iva Dul&#269;i&#263;a 36, Dubrovnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  263. (57, 5, 'Kompas', 'Op&#263;ina Dubrobvnik, Dubrovnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  264. (58, 6, '&#382;eljezni&#269;ka postaja Karlovac', 'Mahi&#269;no BB, Karlovac', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  265. (59, 6, 'Autobusni kolodvor Karlova', 'Prilaz Vje&#263;eslava Holjevca 2, Karlovac', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  266. (60, 6, 'Hotel Europa', 'Banija 161, Karlovac', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  267. (61, 6, 'Hotel Carlstadt', 'A. Vraniczanya 1, Karlovac', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  268. (62, 6, 'Hotel Dragani&#263;', 'Dragani&#263; bb, Karlovac', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  269. (63, 6, 'Hotel Korana', 'Perivoj Josipa Vrbani&#263;a 8, Karlovac', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  270. (64, 6, 'Hotel Restaurant &#382;ganjer', 'Jela&#353;i 41, Karlovac', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  271. (65, 6, 'Rooms Ma La', 'Sveta Margareta 25A, Karlovac', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  272. (66, 6, 'Hostel Na putu', 'Trg bana Petra Zrinskog 17, Karlovac', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  273. (67, 7, 'Autobusni kolodvor Samobor', '151. samoborske brigade HV 1, Samobor', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  274. (68, 7, 'Hotel Lavica', 'Ferde Livadi&#263;a 5, Samobor', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  275. (69, 7, 'Kavana Lidivac', 'Trg kralja Tomislava 1, Samobor', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  276. (70, 7, 'Hotel Livadi&#263;', 'Trg kralja Tomislava 1, Samobor', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  277. (71, 7, 'Hostel Samobor', 'Obrtni&#269;ka 34, Samobor', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  278. (72, 7, 'Samoborski slapovi', 'Hamor 16, Samobor', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  279. (73, 7, 'Garni sobe Samobor', 'Josipa Jela&#269;i&#263;a 30, Samobor', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  280. (74, 8, 'Autobusni kolodvor Pula', 'Trg 1. istarske brigade 10, Pula', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  281. (75, 8, 'Hotel Pula', 'Sisplac 31, Pula', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  282. (76, 8, 'Hotel Riviera', 'Splitska ulica 1, Pula', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  283. (77, 8, 'Hotel Park Pula', 'Verudela 31, Pula', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  284. (78, 8, 'Hotel Brioni', 'Verudela 16, Pula', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  285. (79, 8, 'Boutique Hotel Valsabbion', 'Pje&#353;&#269;ana uvala VII ogranak, Pula', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  286. (80, 8, 'Park Plaza Histria Pula', 'Verudela 17, Pula', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  287. (81, 8, 'Hotel Galija', 'Epulonova ulica 3, Pula', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  288. (82, 8, 'Hotel Scaletta', 'Flavijevska ulica 26, Pula', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  289. (83, 8, 'Horizont Resort', 'Verudela 6, Pula', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  290. (84, 9, 'Autobusni kolodvor Slavonski Brod', 'Trg hrvatskog prolje&#263;a BB, Slavonski Brod', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  291. (85, 9, '&#382;eljezni&#269;ki kolodvor Slavonski Brod', 'Trg hrvatskog prolje&#263;a 4, Slavonski Brod', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  292. (86, 9, 'Hotel Central SB', 'Ulica Petra Kre&#353;imira IV 45, Slavonski Brod', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  293. (87, 9, 'Hotel Savus', 'Doktora Ante Star&#269;evi&#263;a 2a, Slavonski Brod', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  294. (88, 9, 'Art Hotel', 'Ulica Nikole Zrinskog 44, Slavonski Brod', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  295. (89, 9, 'Hotel Garten', 'Vinogorska ulica 69, Slavonski Brod', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  296. (90, 9, 'Hotel Zovko Slavonski Brod', 'Sjeverna Vezna Cesta bb, Slavonski Brod', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  297. (91, 9, 'Rooms Levicki', 'Ulica Ante Star&#269;evi&#263;a 4, Slavonski Brod', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  298. (92, 9, 'Pansion Antonio', 'Ulica Frane Buli&#263;a 22, Slavonski Brod', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  299. (93, 9, 'Stupni&#269;ki Dvori - Hotel, Winery & Restaurant', 'Vinogradska cesta 65, Slavonski Brod', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  300. (94, 10, 'Avtobusna postaja Ljubljana', 'Trg Osvobodilne fronte 4, Ljubljana', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  301. (95, 10, '&#382;elezni&#353;ka postaja Ljubljana', 'Trg Osvobodilne fronte 6, Ljubljana', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  302. (96, 10, 'City Hotel Ljubljana', 'Dalmatinova 15, Ljubljana', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  303. (97, 10, 'Grand Hotel Ljubljana', 'Miklo&#353;i&#269;eva cesta 1, Ljubljana', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  304. (98, 10, 'Hotel Park', 'Tabor 9, Ljubljana', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  305. (99, 10, 'Four Points by Sheraton Ljubljana Mons', 'Pot za Brdom 4, Ljubljana', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  306. (100, 11, 'Hotel City Maribor', 'Ulica kneza Koclja 22, Maribor', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  307. (101, 11, 'Hotel Habakuk', 'Pohorska ulica 59, Maribor', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  308. (102, 11, 'Hotel Piramida', 'Ulica heroja &#353;landra 10, Maribor', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  309. (103, 11, 'Hostel UNI', 'Volkmerjev prehod 7, Maribor', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  310. (104, 11, 'Hotel Betnava', 'Ulica Eve Lov&#353;e 15, Maribor', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  311. (105, 11, 'Avtobusna postaja Maribor', 'Mlinska ulica 1, Maribor', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  312. (106, 11, 'S&#382; Kolodvor Maribor', 'Partizanska cesta 50, Maribor', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  313.  
  314. DROP TABLE IF EXISTS `rating`;
  315. CREATE TABLE `rating` (
  316. `id` int(11) NOT NULL AUTO_INCREMENT,
  317. `rate` int(11) NOT NULL DEFAULT '0',
  318. `comment` varchar(512) NOT NULL,
  319. `user_id` int(11) NOT NULL,
  320. `company_id` int(11) NOT NULL,
  321. `updated_at` datetime NOT NULL,
  322. `created_at` datetime NOT NULL,
  323. PRIMARY KEY (`id`)
  324. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  325.  
  326. INSERT INTO `rating` (`id`, `rate`, `comment`, `user_id`, `company_id`, `updated_at`, `created_at`) VALUES
  327. (1, 4, 'Ugodno i mirno', 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  328. (2, 2, 'Visoka cijena', 2, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  329. (3, 5, 'Izvrsno iskustvo, preporuka!', 3, 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  330. (4, 1, 'Neugodna vožnja, izbjegavati', 4, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  331. (5, 5, 'Music was great, polite driver', 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  332. (6, 3, 'bilo je i boljih', 6, 6, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  333. (7, 2, 'katastrofa', 7, 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  334. (8, 4, 'ok cijena, ?udan miris u autu', 8, 8, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  335. (9, 4, 'ok', 9, 9, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  336. (10, 1, 'kriva ruta, taksimetar nije radio', 10, 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  337. (11, 3, 'cudna cijena', 11, 11, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  338. (12, 5, 'najbolja voznja ikad, dobio popust na kilometre', 12, 12, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  339. (13, 2, 'probavljivo, nedostaje sluzbeno stajaliste', 13, 13, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  340. (14, 3, 'prva voznja u taksiju, proslo je ok, cijena povisoka', 14, 14, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  341. (15, 4, 'ok', 15, 15, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  342. (16, 5, 'super cijena, raspolozeni vozac, super usluga!!', 16, 16, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  343. (17, 4, 'brzo, jeftino, neugodna sjedala', 17, 17, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  344. (18, 3, 'mrvice na zadnjem sjedistu', 18, 18, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  345. (19, 5, 'od sad putujem samo Gea taksijem!', 19, 19, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  346. (20, 4, 'great service, a bit slow though', 20, 20, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  347. (21, 2, 'pocasno in drago...', 21, 21, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  348. (22, 1, 'katastrofa , boleca izkusnja', 22, 22, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  349. (23, 5, 'metro very gud', 23, 23, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  350. (24, 4, 'zelo drag', 24, 24, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  351. (25, 5, 'priporocilo', 25, 25, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  352. (26, 5, 'prvi puta se vozim taksijem 3430 i preporuka', 3, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  353. (27, 1, 'taximeter didnt run, payed 10 euros for one kilometer', 18, 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  354. (28, 5, 'raccomandazione', 27, 14, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  355. (29, 4, 'nakon kremsnita super nacin kako stici do odredista', 26, 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  356. (30, 2, 'costoso e maleducato', 28, 24, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  357. (31, 5, 'superiska', 29, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  358. (32, 4, 'great value, mediocre vehicle', 30, 25, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  359. (33, 2, 'bezobrazan vozac', 18, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  360. (34, 4, 'preglasna glazba, inace ok', 31, 15, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  361. (35, 5, 'jako brzo, dobra cijena, super', 32, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  362. (36, 3, 'predugo cekanje taksija, bezobrazluk vozaca', 33, 11, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  363. (37, 5, 'podrzavam ekolosku voznju :)', 34, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  364. (38, 4, 'prvi put se vozim u Priusu, fora je, tiho i mirno. Preporuka za Eko Taxi!', 35, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  365. (39, 4, 'ok', 36, 20, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  366. (40, 4, 'ampak dobro', 37, 20, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  367. (41, 3, 'dosta skupo u odnosu na druge', 38, 8, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  368. (42, 5, 'izvrsna cijena, besplatan wifi', 39, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  369. (43, 4, 'bonus kilometri definitivno vrijede, jako jeftino ako se vozi vise ljudi', 39, 6, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  370. (44, 4, 'studentima super nacin prijevoza do faksa', 40, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  371. (45, 5, 'Jeftina voznja, kozna sjedala', 32, 27, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  372. (46, 4, 'Vozac zaboravio upaliti taksimetar pa je povisio cijenu, i dalje dobro', 35, 29, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  373. (47, 5, 'Zasto u ostalim gradovima nije tako jeftina voznja? ', 3, 28, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  374. (48, 2, 'Nazalost nove cijene su jako lose', 11, 29, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  375. (49, 0, 'Nisam ni znala da je Cammeo i u Rijeci, thumbs up!', 19, 30, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  376. (50, 1, 'Vozac zapalio cigaretu dok je vozio, cijeli taksi je smrdio.', 29, 31, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  377.  
  378. DROP TABLE IF EXISTS `support`;
  379. CREATE TABLE `support` (
  380. `id` int(11) NOT NULL AUTO_INCREMENT,
  381. `message` text NOT NULL,
  382. `user_id` int(11) NOT NULL,
  383. `resolved` int(11) NOT NULL,
  384. `updated_at` datetime NOT NULL,
  385. `created_at` datetime NOT NULL,
  386. PRIMARY KEY (`id`)
  387. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  388.  
  389.  
  390. DROP TABLE IF EXISTS `users`;
  391. CREATE TABLE `users` (
  392. `id` int(11) NOT NULL AUTO_INCREMENT,
  393. `name` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  394. `last_name` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  395. `email` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  396. `phone` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  397. `country_code` int(11) DEFAULT '1',
  398. `password` varchar(128) COLLATE utf8_bin DEFAULT NULL,
  399. `country_id` int(11) DEFAULT NULL,
  400. `language_id` int(11) DEFAULT NULL,
  401. `city_id` int(11) DEFAULT NULL,
  402. `os` int(11) DEFAULT NULL,
  403. `location` int(11) DEFAULT '1',
  404. `notifications` int(11) DEFAULT '1',
  405. `newsletter` int(11) DEFAULT '1',
  406. `is_admin` int(11) DEFAULT '0',
  407. `updated_at` datetime DEFAULT NULL,
  408. `created_at` datetime DEFAULT NULL,
  409. PRIMARY KEY (`id`)
  410. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  411.  
  412. INSERT INTO `users` (`id`, `name`, `last_name`, `email`, `phone`, `country_code`, `password`, `country_id`, `language_id`, `city_id`, `os`, `location`, `notifications`, `newsletter`, `is_admin`, `updated_at`, `created_at`) VALUES
  413. (1, 'Ksenija', 'Demo', 'ksenija@demo.com', NULL, 1, 'gpr3g108', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  414. (2, 'Mario', 'Demo', 'mario2@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  415. (3, 'Slaven', 'Demo', 'slaven@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  416. (4, 'Marta', 'Demo', 'marta@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  417. (5, 'Ivan', 'Demo', 'ivan@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  418. (6, 'Ivan', 'Demo', 'ivan2@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  419. (7, 'Jelena', 'Demo', 'jelena@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  420. (8, 'Petar', 'Demo', 'petar@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  421. (9, 'Dražen', 'Demo', 'drazen@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  422. (10, 'Ana', 'Demo', 'ana@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  423. (11, 'Ana', 'Demo', 'ana2@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  424. (12, 'Valerija', 'Demo', 'valerija@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  425. (13, 'Nika', 'Demo', 'nika@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  426. (14, 'Filip', 'Demo', 'filip@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  427. (15, 'Suzana', 'Demo', 'suzana@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  428. (16, 'Josip', 'Demo', 'josip@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  429. (17, 'Josip', 'Demo', 'josip2@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  430. (18, 'Ivana', 'Demo', 'ivana@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  431. (19, 'Ivana', 'Demo', 'ivana2@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  432. (20, 'Lucija', 'Demo', 'lucija@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  433. (21, 'Vesna', 'Demo', 'vesna@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  434. (22, 'Mirko', 'Demo', 'mirko@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  435. (23, 'Darko', 'Demo', 'darko@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  436. (24, 'Stjepan', 'Demo', 'stjepan@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  437. (25, 'Siniša', 'Demo', 'sinisa@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  438. (26, 'Mirjana', 'Demo', 'mirjana@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  439. (27, 'Ante', 'Demo', 'ante@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  440. (28, 'Anamarija', 'Demo', 'anamarija@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  441. (29, 'Jakov', 'Demo', 'jakov@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  442. (30, 'Tomislav', 'Demo', 'tomislav@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  443. (31, 'Tomislav', 'Demo', 'tomislav2@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  444. (32, 'Antonio', 'Demo', 'antonio@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  445. (33, 'Snježana', 'Demo', 'snjezana@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  446. (34, 'Martina', 'Demo', 'martina@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  447. (35, 'Zdravko', 'Demo', 'zdravko@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  448. (36, 'Luka', 'Demo', 'luka@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  449. (37, 'Luka', 'Demo', 'luka2@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  450. (38, 'Josip', 'Demo', 'josip@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  451. (39, 'Josipa', 'Demo', 'josipa@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  452. (40, 'Karlo', 'Demo', 'karlo@demo.com', NULL, 1, 'gpr8g103', 1, 1, 1, NULL, 1, 1, 1, 0, NULL, NULL),
  453. (43, NULL, NULL, 'ivko@net.hr', '123', 1, '$2y$10$9e6boDAsSd6lA95yoiZl1uvv1tBt9uVZQNzDwzHuzdff09duKduTe', 1, 1, 1, 1, 1, 1, 1, 0, '2015-06-21 23:50:34', '2015-06-21 23:50:34');
  454.  
  455. -- 2015-06-30 20:08:40
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement