--
-- Host: localhost    Database: du_DUform
-- ------------------------------------------------------


--
-- Table structure for table `adhar_fees`
--

CREATE TABLE `adhar_fees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fees` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `adhar_fees`
--


--
-- Table structure for table `admin_msg`
--

CREATE TABLE `admin_msg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg_by` text COLLATE utf8_unicode_ci NOT NULL,
  `msg_to` text COLLATE utf8_unicode_ci NOT NULL,
  `msg` text COLLATE utf8_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `status` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ur',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `admin_msg`
--

INSERT INTO `admin_msg` VALUES (21,'Userr1','admin','admin','2021-06-15','r'),(22,'admin','User1','How may I help you?','2021-06-15','r'),(24,'admin','vendor552','How may I help you?','2021-06-15','r');

--
-- Table structure for table `ao_code`
--

CREATE TABLE `ao_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `city_id` text NOT NULL,
  `word-circle` text NOT NULL,
  `description` text NOT NULL,
  `area_code` text NOT NULL,
  `ao_type` text NOT NULL,
  `range_code` text NOT NULL,
  `ao_number` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ao_code`
--


--
-- Table structure for table `applicant_title`
--

CREATE TABLE `applicant_title` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `applicant_title`
--

INSERT INTO `applicant_title` VALUES (1,'Shane1');

--
-- Table structure for table `bank_details`
--

CREATE TABLE `bank_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bank_name` text NOT NULL,
  `ifsc` text NOT NULL,
  `address` text NOT NULL,
  `ac_holder` text NOT NULL,
  `acc_no` text NOT NULL,
  `logo` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bank_details`
--

INSERT INTO `bank_details` VALUES (1,'','','','','','');

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `image` text NOT NULL,
  `description` text NOT NULL,
  `author` text NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` VALUES (4,'Question Post','transupload/90_How-Much-Should-You-Spend-On-Carpet-Cleaning-Services.jpg','Description Text','Admin','2021-05-23');

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `image` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category`
--

INSERT INTO `category` VALUES (2,'Real Estate & Sales Property ','transupload/90_real-state-house-sold-plan-businessman-with-magnifying-glass_24640-35659.jpg'),(3,'Cleaning and Disinfection','transupload/407_Cleaning-Disinfecting-Home-Graphics-sickroom2-cleaner-300x300-1.jpg'),(5,'Home & Office Improvement','transupload/380_improvement.jpg'),(6,'Events & Weddings','transupload/335_happy-tiny-business-people-dancing-having-fun-drinking-wine-corporate-party-team-building-activity-corporate-event-idea-concept-pinkish-coral-bluevector-isolated-illustration_335657-1414.jpg'),(7,'Teaching & Tutoring','transupload/337_Teaching-1.jpg'),(8,'Business & Professional','transupload/306_shutterstock_1145284904_372957.jpg'),(9,'Automotive & Transport','transupload/130_travel-transport-vector-4444162.jpg'),(12,'Personal & Family','transupload/319_big-family-meeting_74855-5220.jpg'),(13,'Beauty, Fitness & Wellness','transupload/256_Health.jpg'),(14,'Freelance (Knowledge Work)','transupload/400_freelance1.jpg'),(15,'Household & Appliances Maintenance','transupload/41_home appliances.jpg'),(16,'Job','transupload/341_job_candidates_selection_concept_colored_human_icons_design_6826934.jpg'),(18,'Retails & Wholesale Supplier','transupload/229_best-templates.jpg'),(19,'Home & Office Decoration','transupload/88_home decor.jpg'),(20,'Home & Office Security System','transupload/445_home security.jpg'),(21,'IT & Electronic Maintenance','transupload/257_it repair 1.jpg'),(22,'Coaching & Sales','transupload/244_coaching-1.jpg'),(23,'Food & Travel','transupload/46_food n travel.jpg');

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `state_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cities`
--


--
-- Table structure for table `cms`
--

CREATE TABLE `cms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cms`
--

INSERT INTO `cms` VALUES (1,'About ','VShopi5 is an online service marketplace providing a platform for customers to book services. Services include Home Cleaning, Promoter, Event-model, Handyman, Moving Help, Photographer etc. No more waiting for quotation, you can directly post job and will get cheapest price from vendor.  '),(2,'Payment Instruction','    If you want to purchase this product , you have to pay to our paypal or skrill or Neteller ( Email id example@gmail.com ). After that you need to upload a screen-short and submit , Admin will check and approve it , you will get Activation key also.    '),(3,'Terms and Conditions',' These Terms of Use govern the use of the services offered by VShopi5 at the www. vshopi5.com Web Service. Such services and web site together are hereinafter referred to as the “Platformâ€. Please read these Terms of Use and the VShopi5.com Privacy Policy carefully (the “Privacy Policyâ€) before using the Platform. You can read the Privacy Policy here. Your use of the Platform constitutes your acceptance of and agreement to all of the terms and conditions in these Terms of Use and the Privacy Policy and your representation that you are 18 years of age or older. If you object to anything in these Terms of Use or the Privacy Policy, you are not permitted to use the Platform. The Privacy Policy is incorporated by reference into these Terms of Use and these Terms of Use and the Privacy together are hereinafter referred to as this “Agreement.â€\r\nThis Agreement is subject to change at any time, effective upon posting on the Platform. Your use of the Platform after such posting will constitute your acceptance of and agreement to such changes. Therefore, you should frequently review these Terms of Use and the Privacy Policy to see if they have been changed.<p>\r\nVShopi5.com Connects Service Providers and Service Users<p>\r\nVShopi5 is an internet platform which provides a forum which connects individuals seeking to obtain services (“Service Userâ€) and/or individuals seeking to provide task services (“Service Providerâ€). <p>\r\n1. Function and Purpose<p>\r\nYou acknowledge that the Website functions as an online platform for Service Users to connect with Service Providers for the purposes of transacting to respectively receive and provide Services. VShopi5 is not itself a Service Professional or a Service User.\r\n2. License to Access<p>\r\nVShopi5 hereby grants you a non-exclusive, revocable license to use the Website as set forth in these Terms of Use, provided however that: 1. you will not copy, distribute, or make derivative works of the Website in any medium without VShopi5’s prior written consent;<p>\r\n2. you will not alter or modify any part of the Website other than as may be reasonably necessary to use the Website for its intended purposes; and<p>\r\n3. you will otherwise act in accordance with these Terms of Use and with all applicable laws.<p>\r\n3. Account<p>\r\n1. You may generally use and browse the Website without registering or providing your personal details. However, in order to be part of Service Provider, you are required to create an Account and submit a verification card such as Passport/Identity Card/Driver License. VShopi5 reserves the rights to remove your account if you do not follow the rules.<p>\r\n2. You are solely responsible for safeguarding your Password and shall keep your Password secure at all times. You shall be solely responsible for all activity that occurs on your Account and you shall notify VShopi5 immediately of any breach of security or any unauthorized use of your Account. Similarly, you shall never use another person’s Account without permission. You agree that you will not misrepresent yourself or represent yourself as another user of the Website and/or the Services offered through the Website. You hereby acknowledge and agree that VShopi5 will not be liable for your losses caused by an unauthorized use of your Account. Notwithstanding, you may be liable for the losses of VShopi5 or others due to such unauthorized use<p>\r\n3. In addition and in connection with the use of your Account, you acknowledge and agree that:3.1. You will not copy or distribute any part of the Website in any medium without VShopi5’s prior written authorisation;\r\n3.2. You shall not publish your personal website/blog/facebook or any social media page that links to your services in your listing page in VShopi5;\r\n3.3. You will provide accurate and complete information when creating your Account;\r\n3.4. You shall not use any automated system, including but not limited to, “robots,â€ “spiders,â€ “offline readers,â€ “scrapers,â€ etc., to access the Website for any purpose without VShopi5 prior written approval;\r\n3.5. You shall not in any manual or automated manner collect Service Providers or Service Users information, including but not limited to, names, addresses, phone numbers, or email addresses, copying copyrighted text, or otherwise misuse or misappropriate Website information or content, including but not limited to, use on a “mirroredâ€, competitive, or third party site;\r\n3.6. You shall not in any way that transmits more request messages to the VShopi5 servers, or any server of a VShopi5 subsidiary or affiliate, in a given period of time than a human can reasonably produce in the same period by using a conventional online web browser; provided, however, that the operators of public search engines may use spiders or robots to copy materials from the site for the sole purpose of creating publicly available searchable indices of the materials, but not caches or archives of such material. VShopi5 reserves the right to revoke these exceptions either generally or in specific cases;\r\n3.7. You shall not recruit, solicit, or contact via any medium, any Service Providers or Service Users for employment or contracting for a business not affiliated with VShopi5 without prior, written authorization from VShopi5;\r\n3.8. You shall not take any action that (i) unreasonably encumbers or, in VShopi5’s sole discretion, may unreasonably encumber the Website’s infrastructure; (ii) interferes or attempts to interfere with the proper working of the Website or any third-party participation in the Website; or (iii) bypasses VShopi5’s measures that are used to prevent or restrict access to the Website; and\r\n3.9. You agree not to collect or harvest any personally identifiable data, including without limitation, names or other Account information, from the Website, nor to use the communication systems provided by the Website for any commercial solicitation purposes<p>\r\n4. Your Submitted Content – Prohibitions, Representations and Warranties<p>\r\n1. You shall not upload, post, transmit, transfer, disseminate, distribute, or facilitate distribution of any content, including text, images, video, sound, data, information, or software, to any part of the Website including but not limited to (i) your profile; (ii) the posting of your Service; (iii) the posting of your desired Service; or (iv) the posting of any opinions or reviews in connection with the Website, the Service, the Service Provider (collectively referred to as “Submitted Contentâ€) that1.1. misrepresents the source of anything you post, including impersonation of another individual or entity of any false or inaccurate biographical information for any Service Providers, provides or create links to external sites that violate this Terms of Use, is intended to harm or exploit any individual in any way or is designed to solicit, or collect personally identifiable information of any person without his or her express consent;\r\n1.2. invades anyone’s privacy by attempting to harvest, collect or otherwise utilize or publish any of their information without their knowledge and willing consent;\r\n1.3. contains falsehoods or misrepresentations that could damage VShopi5 or any third party;\r\n1.4. is pornographic, harassing, hateful, illegal, obscene, defamatory, libelous, slanderous, threatening, discriminatory, racially, culturally, or ethnically offensive; incites, advocates, or expresses pornography, obscenity, vulgarity, profanity, hatred, bigotry, racism or gratuitous violence, encourages conduct that would be considered a criminal offence, give rise to civil liability or violate any law, promotes racism, hatred or physical harm of any kind against any group or individual, contains nudity, violence or inappropriate subject matter, or is otherwise inappropriate;\r\n1.5. is in whole or part copyrighted, protected trade secret or otherwise subject to third-party proprietary rights, including privacy and publicity rights, unless you are the owner of such rights or have permission from the rightful owner to post the material and to grant VShopi5 all of the license rights granted therein;\r\n1.6. is intended to threaten, stalk, defame, defraud, degrade, victimize, or intimidate an individual or group of individuals for any reason or to incite or encourage anyone else to do so;\r\n1.7. intends to harm or disrupt another user’s computer or would allow others to illegally access software or bypass security on websites or servers through any means;\r\n1.8. advertises or solicits a business not related to or appropriate for the Website (as determined by VShopi5 in its sole discretion);\r\n1.9. contains or could be considered “junk mailâ€, “spamâ€, “chain lettersâ€, “pyramid schemesâ€, “affiliate marketingâ€, or unsolicited commercial advertisement;\r\n1.10. contains advertising for Potion schemes, discount cards, credit counselling, online surveys or online contests;\r\n1.11. distributes or contains viruses or any other technologies that may harm VShopi5 , or the interests or property of VShopi5 users;\r\n1.12. contains links to commercial services or websites, except as allowed pursuant to the Terms of Use;\r\n1.13. is non-local or irrelevant content; or\r\n1.14. contains identical content to other open Postings you have already posted, or uses any form of automated device or computer programmer that enables the submission of Postings without the express written consent of VShopi5.\r\n2. You will not send messages to other users whom you have made contact with via or through the Website containing:\r\n2.1. offers to make national or international money transfers for amounts exceeding the asking price of a service, with intent to request a refund of any portion of the payment; or\r\n2.2. unsolicited advertising or marketing of a service that is (i) not offered on the Website; or (ii) is offered on an external website.\r\n3. While using the Website, you shall not:3.1. post content or items in any inappropriate category or areas on the Website;\r\n3.2. violate any laws, third-party rights, Account Policies, or any provision of the Terms of Use, such as the prohibitions described above;\r\n3.3. fail to deliver payment for Services purchased by you, unless the Service Professional has materially changed the description of the Service after you negotiate an agreement for such Service, a clear typographical error is made, or you cannot authenticate the Service Professional’s identity;\r\n3.4. fail to perform Services purchased from you, unless the Service User fails to materially meet the terms of the mutually agreed upon;\r\n3.5. circumvent or manipulate any fee structure or billing process that we may have or implement;\r\n3.6. post false, inaccurate, misleading, defamatory, or libelous content (including personal information about any Website user);\r\n3.7. take any action that may undermine any feature that VShopi5 has or may come up with for the purposes of the Website; or\r\n3.8. leave any untrue or inappropriate feedback about a Service Professional and you shall at all times use careful and good judgment in leaving any feedback\r\n4. You are solely and fully responsible for your own Submitted Content and the consequences of posting or publishing it. You hereby affirm, represent, and/or warrant that:4.1. you own or have the necessary licenses, rights, consents, and permissions to use and authorize VShopi5 to use all patent, trademark, trade secret, copyright or other proprietary rights in and to any and all Submitted Content;\r\n4.2. you have the written consent, release, and/or permission of each and every identifiable individual person in the Submitted Content to use the name or likeness of each and every such identifiable individual person; and\r\n4.3. you agree to pay for all royalties, fees, and any other monies owing any person by reason of any Submitted Content posted by you to or through the Website.\r\n\r\n5. You retain all of your ownership rights in your Submitted Content. You hereby grant, and you represent and warrant that you have the right to grant to VShopi5 a perpetual, worldwide, non-exclusive, royalty-free, sublicensable and transferable license to link to, use, reproduce, distribute, reformat, translate, prepare derivative works of, display, and perform the Submitted Content in connection with the Website and VShopi5’s (and its successor’s) business operations, including without limitation, for the promotion and redistribution of any part or all of the Website (and any derivative works in any media formats and through any media channels).\r\n6. You also hereby grant each user of the Website a non-exclusive license to access your Submitted Content through the Website, and to read and use, such Submitted Content as permitted through the functionality of the Website and under these Terms of Use\r\n5. VShopi5 – Disclaimers and Right to Remove Submitted Content\r\n1. VShopi5 does not endorse any Submitted Content or any opinion, recommendation, or advice provided by any users and VShopi5 expressly disclaims any and all liability in connection with all Submitted Content.\r\n2. VShopi5 does not permit copyright infringing activities and infringement of intellectual property rights on the Website, and VShopi5 will remove any Data or Submitted Content in its sole discretion, upon being notified or having reason to believe that an infringement has occurred, without prior notice to a user who has or is suspected to have conducted such infringement. VShopi5 may take any action or steps it deems fit in its sole discretion against such infringer.\r\n3. VShopi5 reserves the right in its sole and absolute discretion to decide whether any Data or Submitted Content is appropriate and complies with these Terms of Use for any and all violations.\r\n4. You acknowledge and understand that when using the Website, you will be exposed to Submitted Content:4.1. from a variety of sources and that VShopi5 is not responsible for the accuracy, usefulness, safety, or intellectual property rights of or relating to such Submitted Content; and\r\n4.2. that is or may be inaccurate, offensive, indecent, or objectionable, and you agree to and hereby waive any legal or equitable rights or remedies you have or may have against VShopi5 , and agree to indemnify and hold VShopi5, its owners, members, managers, operators, directors, officers, agents, affiliates, and/or licensors, harmless to the fullest extent allowed by law regarding all matters related to your use of the Website.\r\n\r\n5. You are solely responsible for the photos, profiles and other content, including, without limitation, Submitted Content, that you publish or display on or through the Website, or transmit to other Website users. You understand and agree that VShopi5 may, in its sole discretion and without incurring any liability, review and delete or remove any Submitted Content that violates this Terms of Use or which might be offensive, illegal, or that might violate the rights, harm, or threaten the safety of Website users or others.\r\n6. Service Provider\r\n1. If you are an individual using the Website and / or have register for an Account as a Service Provider, you represent and warrant that you have the authority to bind the individual and / or company that is responsible for and operates the business as a Service Provider and your acceptance of the Terms of Use will be deemed an acceptance by that Service Provider.\r\n2. By signing up, registering or creating an Account on the Website as a Service Provider, you agree and undertake to comply with any requests for information which we may make for the purpose of verifying the legality, legitimacy, conduct and proper establishment of your (i) business, company or operations; and / or (ii) provision of your Service.3. Service Providers shall not:3.1. register or list on the Website in a category of Service which they do not offer or that is irrelevant to or inappropriate for the Service they are offering;\r\n3.2. misrepresent the location(s) at which they will provide a Service;\r\n3.3. include third party brand names or other inappropriate keywords in their Profile, title or any posting, messages or submission made in or through the Website;\r\n3.4. use misleading titles, words or phrases that do not accurately describe the Service they provide;\r\n3.5. include any information in their Profile that is fraudulent or otherwise incorrect;\r\n3.6. do anything to circumvent or avoid any fees that VShopi5 may charge;\r\n3.7. conduct fraud or misconduct on any promotions or partnerships which VShopi5 may conduct;\r\n3.8. use their Profile or the Website for promoting (i) products or goods; (ii) Services which are not offered by the Service Provider through the Website; (iii) Services which are not a recognized category on the Website; (iv) any website, service, product, party or any thing not directly related to their Service or otherwise prohibited by VShopi5 in its sole discretion from time to time; or (iv) any services that may be prohibited under law;\r\n3.9. solicit Service Users or any person to pay or do anything not specifically permitted by these Terms of Use or by VShopi5 as it may in its sole discretion determine from time to time;\r\n3.10. offer or solicit any Service or do anything that contravenes these Terms of Use, the Privacy Policy or any laws.\r\n7. Service Users\r\n1. Service Users shall not:1.1. commit to purchasing or using a Service with no intention of paying for such Service;\r\n1.2. sign up, request or negotiate a price for, use, or otherwise solicit a Service (i) with no genuine intention as at the time of such conduct of following through with your use of or payment for the Service; (ii) for the purposes of using pricing, quotations or other information received in doing so for commercial or competitive purposes, business or market intelligence purposes or general surveying; or (iii) any other non-personal use;\r\n1.3. request for or agree to purchase a Service when (i) you know, have reason to believe or have been put on notice that you do not meet the Service Provider’s terms; or (ii) with the intention of causing disruption, committing fraud or other tortious or illegal purpose.\r\n8. No Confidentiality\r\nWithout prejudice to the Privacy Policy, you acknowledge and agree that VShopi5 does not guarantee any confidentiality with respect to any Submitted Content by users, including without limitation, your Profile or information conveyed, posted or shared by you, that is hosted and / or published on the Website.\r\n9. Modifications to Terms of Use or Privacy Policy\r\nVShopi5 reserves the right, in its sole discretion, to change, modify or otherwise amend the Terms of Use and any other documents incorporated by reference at any time. It is your responsibility to review the Terms of Use for any changes. Your use of the Website following any amendment of the Terms of Use will signify your assent to and acceptance of any revised Terms of Use. If you do not agree to abide by these or any future Terms of Use, please do not use or access the Website.\r\n10. Termination\r\n1. VShopi5 reserves the right at any time and from time to time to modify or discontinue, temporarily or permanently, the Website or any part thereof with or without notice and in its sole discretion. You agree that VShopi5 shall not be liable to you or to any third party for any modification, suspension or discontinuance of VShopi5’s services.\r\n2. You hereby acknowledge and agree that VShopi5 in its sole and absolute discretion has the right but not the obligation to delete, terminate, or deactivate your Account, block your email or IP address, cancel the Website or otherwise terminate your access to or participation in the use of the Website or any part thereof, or remove and discard any Submitted Content on the Website immediately and without notice and for any reason which is may but is not obliged to disclose.\r\n3. Upon termination of your Account, your right to participate in the Website in any way shall automatically terminate.\r\n4. Upon termination the following shall occur:4.1. your Account will be disabled and you may not be granted access to your Account or any files or other data contained in your Account. However, such residual data may remain in the VShopi5 system;\r\n4.2. all licenses granted to you will immediately terminate;\r\n4.3. VShopi5 shall not be liable to you or any third party for any termination of your access to the Website. VShopi5 retains the right to use any data collected from your use of the Website; and\r\n4.4 all related licenses you have granted VShopi5 hereunder shall remain in effect for the foregoing purpose. In no event is VShopi5 obligated to return any Submitted Content to you. All terms and conditions and rights in favor of VShopi5 survive termination and remain in the full benefit of VShopi5.\r\n4.5 You agree to indemnify and hold VShopi5, and its officers, managers, members, affiliates, successor, assigns, directors, agents, suppliers, and employees harmless from any claim or demand, including reasonable attorneys’ fees and court costs, made by any third party due to or arising out of the termination.\r\n11. Intellectual Property Rights\r\n1. The content on the Website (exclusive of all Submitted Content), including without limitation, the text, software, scripts, graphics, photos, sounds, music, videos, interactive features and the like (“Dataâ€) and the trademarks, service marks and logos contained therein (“Marksâ€), are owned by VShopi5, subject to copyright and other intellectual property rights under Malaysian laws, other applicable laws and international conventions. Such Data and / or Marks are or may become protected by copyright, trademark, patent, trade secret and other laws, and VShopi5 owns and retains all rights in such Data and Marks. All other trademarks, names and logos on this Website are the property of their respective owners.\r\n2. Data on the Website is provided to you for your information and personal use only and may not be used, copied, reproduced, distributed, transmitted, broadcast, displayed, sold, licensed, or otherwise exploited for any other purposes whatsoever without the prior written consent of the respective owners.\r\n3. VShopi5 reserves all rights not expressly granted in and to the Website and the Data. You agree not to use, copy, or distribute, any of the Data other than as expressly permitted herein, including any use, copying, or distribution of Submitted Content obtained through the Website for any commercial purposes. If you download or print a copy of the Data for personal use, you must retain all copyright and other proprietary notices contained thereon. You agree not to circumvent, disable or otherwise interfere with security features of the Website or features that prevent or restrict use or copying of any Data or enforce limitations on use of the Website or the Data therein.\r\n12. Disputes\r\n1. Your interactions with other users, whether individuals, companies and/or organizations and whether Service Provider or Service Users, found on or through the Website, including payment of and performance of any Service, and any other terms, conditions, warranties or representations associated with such transactions or dealings, are solely between you and such third party or user. You should take reasonable precautions and conduct any necessary investigation or inquiries you deem necessary or appropriate before proceeding to hire, pay or transact with such third party or user for any purpose whatsoever.\r\n2. You understand and acknowledge that deciding whether to:2.1. use the Services of a Service Provider\r\n2.2. provide Services to a Service User; or\r\n2.3. use information contained in any Submitted Content\r\nis your personal decision, for which you alone are responsible. You understand that VShopi5 does not and cannot make representations as to the suitability of any user you may decide to interact with on or through the Website and/or the accuracy or suitability of any advice, information, or recommendations made by any user.\r\n2.4. In the event of any dispute between you and a Service User, Service Provider or any other third party or user in relation to the Website, such dispute shall be resolved between you and such Service User, Service Provider or any third party or user, and VShopi5 shall not have or hold any responsibility, liability or obligation in relation thereof.\r\n2.5. NOTWITHSTANDING THE FOREGOING, YOU AGREE THAT STARTASKER SHALL NOT BE RESPONSIBLE OR LIABLE FOR ANY LOSS OR DAMAGE OF ANY SORT WHATSOEVER INCURRED AS THE RESULT OF ANY SUCH TRANSACTION OR DEALINGS. IF THERE IS A DISPUTE BETWEEN USERS ON THE WEBSITE, OR BETWEEN USERS AND ANY THIRD PARTY, YOU ACKNOWLEDGE AND AGREE THAT STARTASKER IS UNDER NO OBLIGATION TO BE INVOLVED. IN THE EVENT THAT A DISPUTE ARISES BETWEEN YOU AND ONE OR MORE USERS OR ANY THIRD PARTY, YOU HEREBY RELEASE STARTASKER, ITS OFFICERS, MANAGERS, MEMBERS, DIRECTORS, EMPLOYEES, ATTORNEYS, AGENTS, AND SUCCESSORS IN RIGHTS FROM ANY CLAIMS, DEMANDS, AND DAMAGES (ACTUAL AND CONSEQUENTIAL) OF EVERY KIND OR NATURE, KNOWN OR UNKNOWN, SUSPECTED OR UNSUSPECTED, FORESEEABLE OR UNFORESEEABLE, DISCLOSED OR UNDISCLOSED, ARISING OUT OF OR IN ANY WAY RELATED TO SUCH DISPUTES AND/OR THE WEBSITE OR ANY SERVICE PROVIDED THEREUNDER.\r\n13. Advertisements and Third Party Links\r\n1. Aspects of the Website and other VShopi5 services may be supported by advertising revenue. As such, VShopi5 may display advertisements and promotions on the service. The manner, mode and extent of advertising by VShopi5 on the Website are subject to change and the appearance of advertisements on the Website does not necessarily imply endorsement by VShopi5 of any advertised products or services. You agree that VShopi5 shall not be responsible or liable for any loss or damage of any sort incurred by you as a result of any such dealings or as the result of the presence of such advertisers on the Website.\r\n2. The Website may provide, or third parties may provide, links, contact forms and/or phone numbers to other websites or resources, including, without limitation, social networking, blogging and similar websites through which you are able to log into the Website using your existing account and log-in credentials for such third-party websites. You acknowledge and agree that VShopi5 is not responsible for the availability of such external sites or resources, and is not responsible or liable for any content, advertising, products, goods or services on or available from such websites or resources. Unless expressly stated on the Website, links to third-party sites should in no way be considered as or interpreted to be VShopi5’s endorsement of such third-party sites or any product or service offered through them.\r\n3. We do not monitor or have any control over, and make no claim or representation regarding third party websites. To the extent such links are provided by us, they are provided only as a convenience, and a link to a third-party website does not imply our endorsement, adoption or sponsorship of, or affiliation with, such third-party website.\r\n4. You further acknowledge and agree that VShopi5 shall not be responsible or liable, directly or indirectly, for any damage or loss caused or alleged to be caused by or in connection with use of or reliance on any such content, advertising, product, goods or services available on or through any such website or resource. Once you leave our Website, these Terms and Conditions no longer govern you and you are advised to check the terms and conditions of those websites. You also acknowledge that it is your obligation to comply with any terms and conditions of any third parties that you may come into contact with either directly or indirectly through the use of the Website, and you accept all responsibility thereof. Your dealings and communications through the Website with any party other than VShopi5 are solely between you and such third party. Any complaints, concerns or questions you have relating to materials provided by third parties should be forwarded directly to the applicable third party\r\n14. Disclaimer of Warranties, Limitation of Liability and Indemnities\r\n1. YOU EXPRESSLY ACKNOWLEDGE AND AGREE THAT THE USE OF THE WEBSITE IS AT YOUR SOLE RISK. STARTASKER, ITS OFFICERS, DIRECTORS, EMPLOYEES AND AGENTS MAKE NO WARRANTIES AND/OR REPRESENTATIONS AND DISCLAIM ALL WARRANTIES, REPRESENTATIONS AND/OR CONDITIONS WHETHER EXPRESS OR IMPLIED ARISING OR RESULTING FROM OR UNDER AND IN CONNECTION WITH THE WEBSITE AND FROM YOUR USE OR INABILITY TO USE THEREOF INCLUDING BUT NOT LIMITED TO:-\r\n2. THE ACCURACY, COMPLETENESS, MERCHANTABILITY, SATISFACTORY QUALITY, UNINTERRUPTED OR ERROR-FREE SERVICE OR OPERATION, CONTINUITY AND AVAILABILITY OF SERVICE OR OPERATION, COMPATIBILITY AND USABILITY WITH THIRD PARTY OR OTHER SERVICES, FITNESS FOR A PARTICULAR PURPOSE, QUIET ENJOYMENT, AND NONINFRINGEMENT OF THIRD PARTY RIGHTS OF THE WEBSITE OR ANY SERVICE THAT STARTASKER PROVIDES\r\n3. ANY ERRORS, MISTAKES, OMISSIONS OR INACCURACIES IN ANY MATERIAL, CONTENT, MESSAGE, TRANSMISSION OR ACT, WHETHER POSTED, EMAILED, TRANSMITTED, SUBMITTED, ADVERTISED, OFFERED OR OTHERWISE MADE AVAILABLE IN THE WEBSITE (WHETHER BY STARTASKER OR ANY THIRD PARTY THROUGH THE WEBSITE);\r\n4. ANY UNAUTHORIZED ACCESS TO OR USE OF THE WEBSITE OR STARTASKER’S SERVERS, DATA OR INFORMATION;\r\n5. ANY CESSATION, TERMINATION OR DISTURBANCE OF TRANSMISSION TO OR FROM THE WEBSITE;\r\n6. ANY COMPUTER VIRUSES, WORMS, TROJAN HORSES OR OTHER MALWARE OR BY TRESPASS OR BURDENING NETWORK CAPACITY WHETHER TRANSMITTED TO OR THROUGH THE WEBSITE WHETHER DUE TO THE ACTIONS OF ANY THIRD PARTIES OR OTHERWISE;\r\n7. ANY TRANSACTION OR TRANSMISSION BETWEEN YOU AND ANY THIRD PARTY PROVIDER OF PRODUCTS OR SERVICES OF ANY KIND IN ANY MEDIUM WHATSOEVER;\r\n8. ANY HARASSMENT, ABUSE, STALKING, THREATENING, DEFAMATORY, OFFENSIVE, INFRINGING, VIOLATING OR ILLEGAL SUBMISSION, MATERIAL, CONTENT, MESSAGE, TRANSMISSION OR ACT BY ANY USER OF THE WEBSITE OR OTHERWISE.\r\n\r\n9. YOU AGREE TO INDEMNIFY AND HOLD HARMLESS TO THE FULLEST EXTENT ALLOWED BY LAW, STARTASKER, ITS OFFICERS, DIRECTORS, EMPLOYEES AND AGENTS FROM AND AGAINST ANY AND ALL CLAIMS, DAMAGES, OBLIGATIONS, LOSSES, LIABILITIES, COSTS, DEBTS AND/OR EXPENSES OF ANY NATURE WHATSOEVER ARISING FROM YOUR USE OF THE WEBSITE, YOUR BREACH AND/OR VIOLATION OF ANY TERM OF THESE TERMS OF USE, YOUR BREACH AND/OR VIOLATION OF ANY THIRD PARTY RIGHT OF ANY NATURE WHATSOEVER, INCLUDING BUT NOT LIMITED TO COPYRIGHT, INTELLECTUAL PROPERTY, PROPERTY AND/OR PRIVACY RIGHTS.\r\n15. Fees and Taxes\r\n1. VShopi5 reserves the right at its sole discretion to charge fees to Service Users and / or Service Providers for the VShopi5 Service and the use of the Website, including but not limited to fees for contacting Service Users, responding to requests from Service Users, or conducting transactions with Service Users through VShopi5. VShopi5 reserves the right to charge fees for such facilities at its sole discretion and by using the Website, you agree to pay any such fees as VShopi5 may notify to you and prescribe from time to time.\r\n2. VShopi5 acts solely as an online platform for Service Users to connect with Service Providers for the purposes of transacting to respectively receive and provide Services. VShopi5 is not itself a Service Provider or a Service User, and is not responsible to account for or pay any tax or comply with any laws relating to tax or relevant compliance for any transaction, sale or service provided by any Service Provider to any Service User. You understand, acknowledge and agree that you are solely responsible for your own tax reporting and statutory compliance obligations\r\n16. Not Party / No Agency or Partnership\r\n1. You hereby acknowledge and agree that VShopi5 is NOT a party to any oral or written agreement for Service or any agreement or contract entered into between Service Users and Service Providers in connection with any Service offered, directly or indirectly, through the Website.\r\n2. No agency, partnership, joint venture, or employment is created as a result of the Terms of Use or your use of any part of the Website. You do not have any authority whatsoever to bind VShopi5 in any respect. All Service Providers are independent of VShopi5. Neither VShopi5 nor any users of the Website may direct or control the day-to-day activities of the other, or create or assume any obligation on behalf of the other.\r\n17. Entire Terms\r\nThe Terms of Use, together with the Privacy Policy and any other legal notices or Additional Policies published by VShopi5 on the Website, shall constitute the entire agreement between you and VShopi5 concerning the Website. If any provision of the Terms of Use is deemed invalid by a court of competent jurisdiction, the invalidity of such provision shall not affect the validity of the remaining provisions of the Terms of Use, which shall remain in full force and effect.\r\n18. Governing Law\r\nThese Terms of Use shall be governed by the laws of Malaysia and you agree to submit to the jurisdiction of the courts of Malaysia in the event of any claims or disputes.\r\n\r\nI HEREBY ACKNOWLEDGE THAT I HAVE READ AND UNDERSTAND THE FOREGOING TERMS OF USE AND THE NEEDTO.COM PRIVACY POLICY AND AGREE THAT MY USE OF THE PLATFORM IS AN ACKNOWLEDGMENT OF MY AGREEMENT TO BE BOUND BY THE TERMS AND CONDITIONS OF THIS AGREEMENT. '),(4,'Privacy Policy','Privacy Policy\r\nThis Privacy Policy is effective as of 24 Mei 2021.\r\nVShopi5’s mission is to empower people to find and hire the best providers for their service needs, and to be a driver of commerce for businesses. We value your privacy. You are given the power to decide what personal information you share with us. We also let you know how we may use the personal information that you share with us. Defined terms used here shall bear the same meaning as defined in our Terms and Conditions, unless otherwise stated.\r\nVShopi5 is committed to complying with the Personal Data Protection Act 2010 (“PDPAâ€) of Malaysia. This Privacy Policy Statement sets out how VShopi5 collects and uses your personal data. It also sets out the measures that we put in place with regards to personal data protection.\r\nCollection and Use of Personal Data\r\nYou can generally use and browse the Website without providing any Personal Data and may remain anonymous\r\nHowever, to gain the full benefit and optimum experience of our Website, you may elect and decide to create an Account or to register your details with us, in which case you may be required to provide personal information such as (but not limited to) your name, telephone number, general geographical location or address, e-mail address or any other information which may identify you (“Personal Dataâ€).\r\nSuch Personal Data may be used to:\r\n1.Enable you to access and use the Website and VShopi5 Services;\r\n2.send you emails, SMS or other form of communication which is related to your use of the Website, such as to verify your identity, personal information, refer you to Service Professionals for Services that you have requested or for other purposes related to the VShopi5 Service; and\r\n3.add you to our mailing list, to send you marketing and promotional materials which we think you may be interested in from time to time. You can at any time decide to unsubscribe from our mailing list and to stop receiving marketing and promotional materials via the links in such communication or by emailing us at sales@vshopi5.com.\r\nHOW DO WE USE THE INFORMATION YOU PROVIDE US?\r\nWe may collect, use, disclose and/or process your personal data for one or more of the following purposes:\r\n1.to consider and/or process your application/transaction with us or your transactions or communications with third parties via the Services;\r\n2.to manage, operate, provide and/or administer your use of and/or access to our Services and our Platform, as well as your relationship and user account with us;\r\n3.to manage, operate, administer and provide you with as well as to facilitate the provision of our Services, including, without limitation, remembering your preferences;\r\n4.to tailor your experience through the Services by displaying content according to your interests and preferences, providing a faster method for you to access your account and submit information to us and allowing us to contact you, if necessary;\r\n5.to respond to, process, deal with or complete a transaction and/or to fulfil your requests for certain products and services and notify you of service issues and unusual account actions\r\n6.to enforce our Terms of Service or any applicable end user license agreements;\r\n7.to protect personal safety and the rights, property or safety of others;\r\n8.for identification and/or verification;\r\n9.to maintain and administer any software updates and/or other updates and support that may be required from time to time to ensure the smooth running of our Services;\r\n10.to deal with or facilitate customer service, carry out your instructions, deal with or respond to any enquiries given by (or purported to be given by) you or on your behalf\r\n11.to contact you or communicate with you via voice call, text message and/or fax message, email and/or postal mail or otherwise for the purposes of administering and/or managing your relationship with us or your use of our Services, such as but not limited to communicating administrative information to you relating to our Services. You acknowledge and agree that such communication by us could be by way of the mailing of correspondence, documents or notices to you, which could involve disclosure of certain personal data about you to bring about delivery of the same as well as on the external cover of envelopes/mail packages;\r\n12.to allow other users to interact or connect with you on the Platform, including to inform you when another User has sent you a private message or posted a comment for you on the Platform;\r\n13.to conduct research, analysis and development activities (including, but not limited to, data analytics, surveys, product and service development and/or profiling), to analyze how you use our Services, to improve our Services or products and/or to enhance your customer experience;\r\n14.to allow for audits and surveys to, among other things, validate the size and composition of our target audience, and understand their experience with VShopi5’s Services;\r\n15.where you give us your prior consent, for marketing and in this regard, to send you by various modes of communication such as postal mail, email, location-based services or otherwise, marketing and promotional information and materials relating to products and/or services (including, without limitation, products and/or services of third parties whom VShopi5 may collaborate or tie up with) that  VShopi5 (and/or its affiliates or related corporations) may be selling, marketing or promoting, whether such products or services exist now or are created in the future.\r\n16.to respond to legal processes or to comply with or as required by any applicable law, governmental or regulatory requirements of any relevant jurisdiction, including, without limitation, meeting the requirements to make disclosure under the requirements of any law binding on VShopi5 or on its related corporations or affiliates;\r\n17.to produce statistics and research for internal and statutory reporting and/or record-keeping requirements;\r\n18.to carry out due diligence or other screening activities (including, without limitation, background checks) in accordance with legal or regulatory obligations or our risk management procedures that may be required by law or that may have been put in place by us;\r\n19.to audit our Services or VShopi5\'s business;\r\n20.to share your data with third party for fulfillment of your transaction with us or refunds;\r\n21.to prevent or investigate any actual or suspected violation of our Terms of Service, fraud, unlawful activity, omission or misconduct, whether relating to your use of our Services or any other matter arising from your relationship with us.\r\n22.to store, host, back up (whether for disaster recovery or otherwise) of your personal data, whether within or outside of your jurisdiction;\r\n23.to deal with and/or facilitate a business asset transaction or a potential business asset transaction, where such transaction involves VShopi5 as a participant or involves only a related corporation or affiliate of VShopi5 as a participant or involves VShopi5 and/or any one or more of VShopi5 related corporations or affiliates as participant(s), and there may be other third party organizations who are participants in such transaction. A “business asset transactionâ€ refers to the purchase, sale, lease, merger, amalgamation or any other acquisition, disposal or financing of an organization or a portion of an organization or of any of the business or assets of an organization; and/or\r\n24.any other purposes which we notify you of at the time of obtaining your consent. (collectively, the “Purposesâ€).\r\nAs the purposes for which we will/may collect, use, disclose or process your personal data depend on the circumstances at hand, such purpose may not appear above. However, we will notify you of such other purpose at the time of obtaining your consent, unless processing of the applicable data without your consent is permitted by the Privacy Laws.\r\nSharing of Information From The Services\r\nOur Services enable users to share personal information with each other, in almost all occasions without VShopi5’s involvement, to complete transactions. In a typical transaction, users may have access to each other’s name, user ID, email address and other contact and postage information. Users in possession of another user’s personal data (the “Receiving Partyâ€) must\r\n1.comply with all applicable Privacy Laws\r\n2.allow the other user (the “Disclosing Partyâ€) to remove him/herself from the Receiving Party’s database; and\r\n3.allow the Disclosing Party to review what information have been collected about them by the Receiving Party.\r\nHow Does VShopi5 Protect Customer Information?\r\nWe implement a variety of security measures and strive to ensure the security of your personal data on our systems. User personal data is contained behind secured networks and is only accessible by a limited number of employees who have special access rights to such systems However, there can inevitably be no guarantee of absolute security.\r\nWe will retain personal data in accordance with the Privacy Laws and/or other applicable laws. That is, we will destroy or anonymize your personal data as soon as it is reasonable to assume that (i) the purpose for which that personal data was collected is no longer being served by the retention of such personal data; and (ii) retention is no longer necessary for any legal or business purposes. If you cease using the Platform, or your permission to use the Platform and/or the Services is terminated or withdrawn, we may continue storing, using and/or disclosing your personal data in accordance with this Privacy Policy and our obligations under the Privacy Laws. Subject to applicable law, we may securely dispose of your personal data without prior notice to you.\r\nDoes VShopi5 Disclose The Information It collects From It\'s Visitors TO\r\nIn conducting our business, we will/may need to disclose your personal data to our third party service providers, agents and/or our affiliates or related corporations, and/or other third parties, for one or more of the above-stated Purposes. Such third party service providers, agents and/or affiliates or related corporations and/or other third parties would be processing your personal data either on our behalf or otherwise, for one or more of the above-stated Purposes. Such third parties include, without limitation:\r\n1.our subsidiaries, affiliates and related corporations;\r\n2.other users of our Platform for one or more of the above-stated Purposes\r\n3.contractors, agents, service providers and other third parties we use to support our business. These include but are not limited to those which provide administrative or other services to us such as mailing houses, telecommunication companies, information technology companies and data centers;\r\n4.a buyer or other successor in the event of a merger, divestiture, restructuring, reorganization, dissolution or other sale or transfer of some or all of VShopi5’s assets, whether as a going concern or as part of bankruptcy, liquidation or similar proceeding, in which personal data held by VShopi5 about our Service Users is among the assets transferred; or to a counterparty in a business asset transaction that VShopi5 any of its affiliates or related corporations is involved in; and\r\n5.third parties to whom disclosure by us is for one or more of the Purposes and such third parties would in turn be collecting and processing your personal data for one or more of the Purposes.\r\nThis may require, among other things, share statistical and demographic information about our Users and their use of the Services with suppliers of advertisements and programming. This would not include anything that could be used to identify you specifically or to discover individual information about you.\r\nFor the avoidance of doubt, in the event that Privacy Laws or other applicable laws permit an organization such as us to collect, use or disclose your personal data without your consent, such permission granted by the laws shall continue to apply.\r\nThird parties may unlawfully intercept or access personal data transmitted to or contained on the Platform, technologies may malfunction or not work as anticipated, or someone might access, abuse or misuse information through no fault of ours. We will nevertheless deploy reasonable security arrangements to protect your personal data as required by the Privacy Laws; however there can inevitably be no guarantee of absolute security such as but not limited to when unauthorized disclosure arises from malicious and sophisticated hacking by malcontents through no fault of ours.\r\nInformation On Children\r\nThe Services are not intended for children under the age of 13. We do not knowingly collect or maintain any personal data or non-personally-identifiable information from anyone under the age of 13 nor is any part of our Platform or other Services directed to children under the age of 13. As a parent or a legal guardian, please do not allow such children under your care to submit personal data to VShopi5, you hereby consent to the processing of the child\'s personal data and accept and agree to be bound by this Policy on behalf of such child. We will close any accounts used exclusively by such children and will remove and/or delete any personal data we believe was submitted without parental consent by any child under the age of 13.\r\nInformation collected By Third Parties\r\nOur Platform uses Google Analytics, a web analytics service provided by Google, Inc. (\"Google\"). Google Analytics uses cookies, which are text files placed on your computer, to help the Platform analyze how Users use the Platform. The information generated by the cookie about your use of the Platform (including your IP address) will be transmitted to and stored by Google on servers in the United States. Google will use this information for the purpose of evaluating your use of the Platform, compiling reports on Platform activity for Platform operators and providing other services relating to Platform activity and Internet usage. Google may also transfer this information to third parties where required to do so by law, or where such third parties process the information on Google\'s behalf. Google will not associate your IP address with any other data held by Google.\r\nWe, and third parties, may from time to time make software applications downloads available for your use on or through the Services. These applications may separately access, and allow a third party to view, your identifiable information, such as your name, your user ID, your computer\'s IP Address or other information such as any cookies that you may previously have installed or that were installed for you by a third party software application or website. Additionally, these applications may ask you to provide additional information directly to third parties. Third party products or services provided through these applications are not owned or controlled by K. You are encouraged to read the terms and other policies published by such third parties on their websites or otherwise.\r\nDisclaimer Regarding Security AND Third Party Sites\r\nWE DO NOT GUARANTEE THE SECURITY OF PERSONAL DATA AND/OR OTHER INFORMATION THAT YOU PROVIDE ON THIRD PARTY SITES. We do implement a variety of security measures to maintain the safety of your personal data that is in our possession or under our control. Your personal data is contained behind secured networks and is only accessible by a limited number of persons who have special access rights to such systems, and are required to keep the personal data confidential. When you place orders or access your personal data, we offer the use of a secure server. All personal data or sensitive information you supply is encrypted into our databases to be only accessed as stated above.\r\nIn an attempt to provide you with increased value, we may choose various third party websites to link to, and frame within, the Platform. We may also participate in co-branding and other relationships to offer e-commerce and other services and features to our visitors. These linked sites have separate and independent privacy policies as well as security arrangements. Even if the third party is affiliated with us, we have no control over these linked sites, each of which has separate privacy and data collection practices independent of us. Data collected by our co-brand partners or third party web sites (even if offered on or through our Platform) may not be received by us.\r\nWe therefore have no responsibility or liability for the content, security arrangements (or lack thereof) and activities of these linked sites. These linked sites are only for your convenience and you therefore access them at your own risk. Nonetheless, we seek to protect the integrity of our Platform and the links placed upon each of them and therefore welcome any feedback about these linked sites (including, without limitation, if a specific link does not work).\r\nOther Information Collected\r\nWhen you visit our Website, we may also automatically record information that your browser sends whenever you visit a website. This data does not identify you as an individual and may include:\r\n1.Your computer\'s IP address;\r\n2.Browser type;\r\n3.The pages you visit on our Website; and\r\n4.The time spent on those pages, items and information searched for on our site, access times and dates, and other statistics.\r\nThis information is collected for analysis and evaluation in order to help us improve the Website and VShopi5 Services. This data is collected anonymously and will not be used in association with any Personal Data.\r\nAs part of the above, we may use cookies and Google Analytics. We may also use remarketing with Google Analytics to advertise online. Third-party vendors, including Google, may show our ads on websites across the Internet. We and third-party vendors, including Google, use first-party cookies (such as the Google Analytics cookie) and third-party cookies (such as the DoubleClick cookie) together to inform, optimize, and serve ads based on visitors’ past visits to our website, as well as report how ad impressions, other uses of ad services, and interactions with these ad impressions and ad services are related to visits to our website.\r\nLinks to Other Websites\r\nWe may provide links to other websites that we do not control, these include those of our Service Professionals. We do not assume responsibility for the privacy practices, products, services or any other content of any websites or pages that is not under our control. We do not bear any responsibility for any actions or policies of third-party websites. Moreover, we disclaim all responsibility for the subsequent use of an email address or any other personally identifiable information you have provided to an affiliate store or any other website we might link to that is not under our control. You are advised to check the privacy policies of those websites upon visiting them.\r\nDisclosure of information\r\nWe do not sell, distribute or lease Personal Data or information that you provide or which VShopi5 otherwise comes by to third parties unless required by law, or with your permission. We may however disclose or transfer Personal Data or information for the purposes of rendering our services to you and this may include disclosure to any professional, third party service providers to us, who are formally engaged by us to help us make available and provide the Website and the VShopi5 Service.\r\nProtection of information\r\nVShopi5 is committed to take all reasonable and practical steps to ensure that any personal information or data that we collect or come into possession of is protected against loss, misuse, abuse, modification or any unauthorized or accidental use, access, disclosure, modification, alteration or destruction. We ensure that all Personal Data collected will be safely and securely stored. We protect your personal information by:\r\n1.Restricting access to Personal Data;\r\n2.Maintaining and implementing measures to prevent unauthorized computer access; and\r\n3.Securely destroying and / or deleting your personal information when it\'s no longer needed.\r\nContact Information for Access, Correction, Enquiries\r\nShould you wish to:\r\n1.access; or\r\n2.make any corrections to,\r\nthe Personal Data which VShopi5 has collected from you, or otherwise have any enquiries in respect of your Personal Data, please feel free to contact us via e-mail at sales@vshopi5.com.\r\nChanges to this Privacy Policy\r\nVShopi5 may revise this Privacy Policy from time to time, as it may deem necessary. You will be notified of any such changes. By accessing or continuing use of our services after any changes to this Privacy Policy, you agree to be bound by this Privacy Policy including any changes made to it. If you have any questions regarding this Privacy Policy, you may contact us at sales@vshopi5.com.\r\n');

--
-- Table structure for table `complain_histry`
--

CREATE TABLE `complain_histry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg_by` text NOT NULL,
  `msg` text NOT NULL,
  `complain_id` text NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `complain_histry`
--

INSERT INTO `complain_histry` VALUES (3,'admin','reply msg from admin					','2','2020-06-22');

--
-- Table structure for table `complaint`
--

CREATE TABLE `complaint` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `complain_id` text NOT NULL,
  `subject` text NOT NULL,
  `username` text NOT NULL,
  `date` date NOT NULL,
  `status` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `complaint`
--

INSERT INTO `complaint` VALUES (6,'R65bofW444','test complaint','RATA76116','2020-07-25','1');

--
-- Table structure for table `contact_information`
--

CREATE TABLE `contact_information` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` text NOT NULL,
  `phone` text NOT NULL,
  `address` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact_information`
--

INSERT INTO `contact_information` VALUES (1,'shane@jowdy.com','800.349.9002','1945 Lockhill Selma Rd, Suite 202, San Antonio, TX  78213');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sortname` varchar(3) NOT NULL,
  `name` varchar(150) NOT NULL,
  `phonecode` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'AF','Afghanistan',93),(2,'AL','Albania',355),(3,'DZ','Algeria',213),(4,'AS','American Samoa',1684),(5,'AD','Andorra',376),(6,'AO','Angola',244),(7,'AI','Anguilla',1264),(8,'AQ','Antarctica',0),(9,'AG','Antigua And Barbuda',1268),(10,'AR','Argentina',54),(11,'AM','Armenia',374),(12,'AW','Aruba',297),(13,'AU','Australia',61),(14,'AT','Austria',43),(15,'AZ','Azerbaijan',994),(16,'BS','Bahamas The',1242),(17,'BH','Bahrain',973),(18,'BD','Bangladesh',880),(19,'BB','Barbados',1246),(20,'BY','Belarus',375),(21,'BE','Belgium',32),(22,'BZ','Belize',501),(23,'BJ','Benin',229),(24,'BM','Bermuda',1441),(25,'BT','Bhutan',975),(26,'BO','Bolivia',591),(27,'BA','Bosnia and Herzegovina',387),(28,'BW','Botswana',267),(29,'BV','Bouvet Island',0),(30,'BR','Brazil',55),(31,'IO','British Indian Ocean Territory',246),(32,'BN','Brunei',673),(33,'BG','Bulgaria',359),(34,'BF','Burkina Faso',226),(35,'BI','Burundi',257),(36,'KH','Cambodia',855),(37,'CM','Cameroon',237),(38,'CA','Canada',1),(39,'CV','Cape Verde',238),(40,'KY','Cayman Islands',1345),(41,'CF','Central African Republic',236),(42,'TD','Chad',235),(43,'CL','Chile',56),(44,'CN','China',86),(45,'CX','Christmas Island',61),(46,'CC','Cocos (Keeling) Islands',672),(47,'CO','Colombia',57),(48,'KM','Comoros',269),(49,'CG','Republic Of The Congo',242),(50,'CD','Democratic Republic Of The Congo',242),(51,'CK','Cook Islands',682),(52,'CR','Costa Rica',506),(53,'CI','Cote D\'Ivoire (Ivory Coast)',225),(54,'HR','Croatia (Hrvatska)',385),(55,'CU','Cuba',53),(56,'CY','Cyprus',357),(57,'CZ','Czech Republic',420),(58,'DK','Denmark',45),(59,'DJ','Djibouti',253),(60,'DM','Dominica',1767),(61,'DO','Dominican Republic',1809),(62,'TP','East Timor',670),(63,'EC','Ecuador',593),(64,'EG','Egypt',20),(65,'SV','El Salvador',503),(66,'GQ','Equatorial Guinea',240),(67,'ER','Eritrea',291),(68,'EE','Estonia',372),(69,'ET','Ethiopia',251),(70,'XA','External Territories of Australia',61),(71,'FK','Falkland Islands',500),(72,'FO','Faroe Islands',298),(73,'FJ','Fiji Islands',679),(74,'FI','Finland',358),(75,'FR','France',33),(76,'GF','French Guiana',594),(77,'PF','French Polynesia',689),(78,'TF','French Southern Territories',0),(79,'GA','Gabon',241),(80,'GM','Gambia The',220),(81,'GE','Georgia',995),(82,'DE','Germany',49),(83,'GH','Ghana',233),(84,'GI','Gibraltar',350),(85,'GR','Greece',30),(86,'GL','Greenland',299),(87,'GD','Grenada',1473),(88,'GP','Guadeloupe',590),(89,'GU','Guam',1671),(90,'GT','Guatemala',502),(91,'XU','Guernsey and Alderney',44),(92,'GN','Guinea',224),(93,'GW','Guinea-Bissau',245),(94,'GY','Guyana',592),(95,'HT','Haiti',509),(96,'HM','Heard and McDonald Islands',0),(97,'HN','Honduras',504),(98,'HK','Hong Kong S.A.R.',852),(99,'HU','Hungary',36),(100,'IS','Iceland',354),(101,'IN','India',91),(102,'ID','Indonesia',62),(103,'IR','Iran',98),(104,'IQ','Iraq',964),(105,'IE','Ireland',353),(106,'IL','Israel',972),(107,'IT','Italy',39),(108,'JM','Jamaica',1876),(109,'JP','Japan',81),(110,'XJ','Jersey',44),(111,'JO','Jordan',962),(112,'KZ','Kazakhstan',7),(113,'KE','Kenya',254),(114,'KI','Kiribati',686),(115,'KP','Korea North',850),(116,'KR','Korea South',82),(117,'KW','Kuwait',965),(118,'KG','Kyrgyzstan',996),(119,'LA','Laos',856),(120,'LV','Latvia',371),(121,'LB','Lebanon',961),(122,'LS','Lesotho',266),(123,'LR','Liberia',231),(124,'LY','Libya',218),(125,'LI','Liechtenstein',423),(126,'LT','Lithuania',370),(127,'LU','Luxembourg',352),(128,'MO','Macau S.A.R.',853),(129,'MK','Macedonia',389),(130,'MG','Madagascar',261),(131,'MW','Malawi',265),(132,'MY','Malaysia',60),(133,'MV','Maldives',960),(134,'ML','Mali',223),(135,'MT','Malta',356),(136,'XM','Man (Isle of)',44),(137,'MH','Marshall Islands',692),(138,'MQ','Martinique',596),(139,'MR','Mauritania',222),(140,'MU','Mauritius',230),(141,'YT','Mayotte',269),(142,'MX','Mexico',52),(143,'FM','Micronesia',691),(144,'MD','Moldova',373),(145,'MC','Monaco',377),(146,'MN','Mongolia',976),(147,'MS','Montserrat',1664),(148,'MA','Morocco',212),(149,'MZ','Mozambique',258),(150,'MM','Myanmar',95),(151,'NA','Namibia',264),(152,'NR','Nauru',674),(153,'NP','Nepal',977),(154,'AN','Netherlands Antilles',599),(155,'NL','Netherlands The',31),(156,'NC','New Caledonia',687),(157,'NZ','New Zealand',64),(158,'NI','Nicaragua',505),(159,'NE','Niger',227),(160,'NG','Nigeria',234),(161,'NU','Niue',683),(162,'NF','Norfolk Island',672),(163,'MP','Northern Mariana Islands',1670),(164,'NO','Norway',47),(165,'OM','Oman',968),(166,'PK','Pakistan',92),(167,'PW','Palau',680),(168,'PS','Palestinian Territory Occupied',970),(169,'PA','Panama',507),(170,'PG','Papua new Guinea',675),(171,'PY','Paraguay',595),(172,'PE','Peru',51),(173,'PH','Philippines',63),(174,'PN','Pitcairn Island',0),(175,'PL','Poland',48),(176,'PT','Portugal',351),(177,'PR','Puerto Rico',1787),(178,'QA','Qatar',974),(179,'RE','Reunion',262),(180,'RO','Romania',40),(181,'RU','Russia',70),(182,'RW','Rwanda',250),(183,'SH','Saint Helena',290),(184,'KN','Saint Kitts And Nevis',1869),(185,'LC','Saint Lucia',1758),(186,'PM','Saint Pierre and Miquelon',508),(187,'VC','Saint Vincent And The Grenadines',1784),(188,'WS','Samoa',684),(189,'SM','San Marino',378),(190,'ST','Sao Tome and Principe',239),(191,'SA','Saudi Arabia',966),(192,'SN','Senegal',221),(193,'RS','Serbia',381),(194,'SC','Seychelles',248),(195,'SL','Sierra Leone',232),(196,'SG','Singapore',65),(197,'SK','Slovakia',421),(198,'SI','Slovenia',386),(199,'XG','Smaller Territories of the UK',44),(200,'SB','Solomon Islands',677),(201,'SO','Somalia',252),(202,'ZA','South Africa',27),(203,'GS','South Georgia',0),(204,'SS','South Sudan',211),(205,'ES','Spain',34),(206,'LK','Sri Lanka',94),(207,'SD','Sudan',249),(208,'SR','Suriname',597),(209,'SJ','Svalbard And Jan Mayen Islands',47),(210,'SZ','Swaziland',268),(211,'SE','Sweden',46),(212,'CH','Switzerland',41),(213,'SY','Syria',963),(214,'TW','Taiwan',886),(215,'TJ','Tajikistan',992),(216,'TZ','Tanzania',255),(217,'TH','Thailand',66),(218,'TG','Togo',228),(219,'TK','Tokelau',690),(220,'TO','Tonga',676),(221,'TT','Trinidad And Tobago',1868),(222,'TN','Tunisia',216),(223,'TR','Turkey',90),(224,'TM','Turkmenistan',7370),(225,'TC','Turks And Caicos Islands',1649),(226,'TV','Tuvalu',688),(227,'UG','Uganda',256),(228,'UA','Ukraine',380),(229,'AE','United Arab Emirates',971),(230,'GB','United Kingdom',44),(231,'US','United States',1),(232,'UM','United States Minor Outlying Islands',1),(233,'UY','Uruguay',598),(234,'UZ','Uzbekistan',998),(235,'VU','Vanuatu',678),(236,'VA','Vatican City State (Holy See)',39),(237,'VE','Venezuela',58),(238,'VN','Vietnam',84),(239,'VG','Virgin Islands (British)',1284),(240,'VI','Virgin Islands (US)',1340),(241,'WF','Wallis And Futuna Islands',681),(242,'EH','Western Sahara',212),(243,'YE','Yemen',967),(244,'YU','Yugoslavia',38),(245,'ZM','Zambia',260),(246,'ZW','Zimbabwe',263);

--
-- Table structure for table `credit_package`
--

CREATE TABLE `credit_package` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `price` varchar(1000) NOT NULL,
  `credit` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `credit_package`
--

INSERT INTO `credit_package` VALUES (4,'10 Credits','3.00','10'),(5,'50 Credits','13.00','50'),(6,'100 Credits','25.00','100');

--
-- Table structure for table `customer`
--

CREATE TABLE `customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_name` text NOT NULL,
  `address` text NOT NULL,
  `location` text NOT NULL,
  `emirates` text NOT NULL,
  `country` text NOT NULL,
  `contact_person` text NOT NULL,
  `mobile_number` text NOT NULL,
  `trade_li_no` text NOT NULL,
  `lic_side1` text NOT NULL,
  `lic_side2` text NOT NULL,
  `expiry_date` text NOT NULL,
  `issued_by` text NOT NULL,
  `import_code` text NOT NULL,
  `VAT_reg_no` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` VALUES (2,'juhi roya','kolkatab','kolkatac','gfds125445d','indiae','mr johnf','9187452358g','hhiii455h','transupload/8_Tulips.jpg','transupload/146_Desert.jpg','12-12-2020i','kjgj','kl124568k','gh14000l');

--
-- Table structure for table `download`
--

CREATE TABLE `download` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `file_path` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `download`
--

INSERT INTO `download` VALUES (1,'Pan card application form','transupload/338_1537645444.pdf'),(2,'Pan update form','transupload/93_3 PAN CR Form PDF.pdf'),(4,'Scanning Software','transupload/442_naps2-5.8.2-setup.exe');

--
-- Table structure for table `driver`
--

CREATE TABLE `driver` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `driver_name` text NOT NULL,
  `email` text NOT NULL,
  `licence` text NOT NULL,
  `passport` text NOT NULL,
  `visa` text NOT NULL,
  `phone` varchar(1000) NOT NULL,
  `assign_vehicle` text NOT NULL,
  `lic_issue_by` text NOT NULL,
  `lic_issue_date` text NOT NULL,
  `lic_exp_date` text NOT NULL,
  `lic_side1` text NOT NULL,
  `lic_side2` text NOT NULL,
  `pass_issue_cun` text NOT NULL,
  `pass_issue_date` text NOT NULL,
  `pass_exp_date` text NOT NULL,
  `pass_side1` text NOT NULL,
  `visa_sponsor_by` text NOT NULL,
  `visa_issue_date` text NOT NULL,
  `visa_exp_date` text NOT NULL,
  `visa_side1` text NOT NULL,
  `emirates_id` text NOT NULL,
  `emirate_exp_date` text NOT NULL,
  `emirates_side1` text NOT NULL,
  `emirates_side2` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `driver`
--


--
-- Table structure for table `event_planer`
--

CREATE TABLE `event_planer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text,
  `title` text,
  `email` text,
  `office` text,
  `mobile` text,
  `company` text,
  `address` text,
  `city` text,
  `state` text,
  `zip` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `event_planer`
--

INSERT INTO `event_planer` VALUES (1,'Shane Graef','Support','shane@jowdy.com','800.349.9002 106','972.273.0437','Jowdy Photography','1945 Lockhill Selma Rd, Suite 202','San Antonio','TX','78213'),(2,'Erin Berkley','Meeting & Event Services (MES)','eberkley@deloitte.com','','(469) 731 6821','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76265'),(3,'Amanda Braucht','Meeting & Event Services (MES)','abraucht@deloitte.com','682.388.6268','682.201.7171','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76264'),(4,'Lauren Bridges','Meeting & Event Services (MES)','labridges@deloitte.com','(682) 388-6142','(469) 496-8239','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76264'),(5,'Tiffany Bussey','Meeting & Event Services (MES)','tbussey@deloitte.com','(682) 388-6178','(682) 201-4098','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(6,'John Canterino','Meeting & Event Services (MES)','jcanterino@deloitte.com','(682) 388-6120','(682) 201-4344','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(7,'Kama Carter','DU--Benchmark Conference Services','kacarter@deloitte.com','(682) 388-6222','(469) 243-8447','Benchmark Hospitality','One Deloitte Way','Westlake','Texas','76269'),(8,'Amanda Coss','Meeting & Event Services (MES)','acoss@deloitte.com','(682) 388-1334','(682) 321-0217','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76263'),(9,'Laura Deane','Meeting & Event Services (MES)','ladeane@deloitte.com','(682) 388-6108','(817) 371-9710','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(10,'Emily Dempster','Meeting & Event Services (MES)','edempster@deloitte.com','','(817) 201-6951','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(11,'Shayna Fears','Meeting & Event Services (MES)','sfears@deloitte.com','(682) 388-6194','(682) 213-1117','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(12,'Brittany Goodwin','Meeting & Event Services (MES)','brgoodwin@deloitte.com','','(940) 465-3319','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76263'),(13,'Rachel Hamende','Meeting & Event Services (MES)','rhamende@deloitte.com','(682) 388-6091','(682) 238-8944','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(14,'Kelsey Hanna','DU Tester','kehanna@deloitte.com','(682) 388-6007','(214) 437-6667','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(15,'Rachel Hernandez','Meeting & Event Services (MES)','rachernandez@deloitte.com','','(469) 855-5941','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(16,'Joy Israel','Meeting & Event Services (MES)','jisrael@deloitte.com','(682) 388-6182','(940) 205-8471','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76270'),(17,'Tiffany Jones','Meeting & Event Services (MES)','tifjones@deloitte.com','(682) 216-5952','(682) 216-5952','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(18,'Theresa Kane','Meeting & Event Services (MES)','tkane@deloitte.com','(682) 388-6109','(940) 222-0004','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(19,'Darryl Leavitt','Meeting & Event Services (MES)','dleavitt@deloitte.com','','(469) 417-2703','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(20,'Megan Mack','Meeting & Event Services (MES)','memack@deloitte.com','(682) 388-6133','(817) 619-3198','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(21,'Shanna Marko','Meeting & Event Services (MES)','smarko@deloitte.com','(682) 388-6050','(682) 201-6079','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(22,'Anne Masterson','DU--Benchmark Conference Services','amasterson@deloitte.com','(682) 388-6122','(214) 287-7725','Benchmark Hospitality','One Deloitte Way','Westlake','Texas','76262'),(23,'Hollie Matthews','Meeting & Event Services (MES)','hmatthews@deloitte.com','(682) 388-6130','(512) 468-6497','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76266'),(24,'Brittani McDermott','Meeting & Event Services (MES)','bmcdermott@deloitte.com','(682) 388-6149','(940) 218-0069','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(25,'Alea Meintser','Meeting & Event Services (MES)','ameintser@deloitte.com','(682) 388-6069','(817) 374-9716','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(26,'Caroline Morley','Meeting & Event Services (MES)','camorley@deloitte.com','(682) 388-6185','(469) 381-9312','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(27,'Jenna Park','Meeting & Event Services (MES)','jennapark@deloitte.com','(682) 388-6050','(214) 973-2498','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(28,'Brannon Smith','Meeting & Event Services (MES)','brannsmith@deloitte.com','','(214) 998-0547','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(29,'Tracey Taylor','Meeting & Event Services (MES)','tractaylor@deloitte.com','(682) 388-6152','(940) 231-9458','Deloitte Services LP','One Deloitte Way','Westlake','Texas','76262'),(30,'Josh Wilson','DU--Benchmark Conference Services','joshwilson8@deloitte.com','(682) 388-1343','(682) 270-6869','Benchmark Hospitality','One Deloitte Way','Westlake','Texas','76262');

--
-- Table structure for table `expence`
--

CREATE TABLE `expence` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `paid_to` text NOT NULL,
  `exp_type` text NOT NULL,
  `vehicle_no` text NOT NULL,
  `driver_name` text NOT NULL,
  `amount` text NOT NULL,
  `referance` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `expence`
--

INSERT INTO `expence` VALUES (1,'souravbb','2','2','6','500222','ref no 2hh3bbb');

--
-- Table structure for table `expence_type`
--

CREATE TABLE `expence_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `expence_name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `expence_type`
--

INSERT INTO `expence_type` VALUES (2,'Telephone bill');

--
-- Table structure for table `facebook_pixel`
--

CREATE TABLE `facebook_pixel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `facebook_pixel`
--

INSERT INTO `facebook_pixel` VALUES (1,'<!-- Facebook Pixel Code -->\r\n<script>\r\n  !function(f,b,e,v,n,t,s)\r\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\r\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\r\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version=\'2.0\';\r\n  n.queue=[];t=b.createElement(e);t.async=!0;\r\n  t.src=v;s=b.getElementsByTagName(e)[0];\r\n  s.parentNode.insertBefore(t,s)}(window, document,\'script\',\r\n  \'https://connect.facebook.net/en_US/fbevents.js\');\r\n  fbq(\'init\', \'2868927613419971\');\r\n  fbq(\'track\', \'PageView\');\r\n</script>\r\n<noscript><img height=\"1\" width=\"1\" style=\"display:none\"\r\n  src=\"https://www.facebook.com/tr?id=2868927613419971&ev=PageView&noscript=1\"\r\n/></noscript>\r\n<!-- End Facebook Pixel Code -->');

--
-- Table structure for table `features`
--

CREATE TABLE `features` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `image` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `features`
--

INSERT INTO `features` VALUES (3,'Instant Setup','transupload/111_cursor.png','Easy to setup , First you need to login and purchase , Ten you can setup'),(4,'Fast Loading','transupload/426_rocket-launch.png','It is very fast , take few minute to install and loading.'),(5,'24/7 Support','transupload/493_headphones.png','You will get 24/7 support.');

--
-- Table structure for table `freelancer_report`
--

CREATE TABLE `freelancer_report` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `reason` text NOT NULL,
  `description` text NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `freelancer_report`
--

INSERT INTO `freelancer_report` VALUES (1,'mili','','hi this is  not goood freelancer','2021-05-17'),(2,'mili','Skill Not Good','not experienced  ,  very poor experience ','2021-05-17'),(3,'mili','Skill Not Good','not experienced  ,  very poor experience ','2021-05-17');

--
-- Table structure for table `guest_admin_msg`
--

CREATE TABLE `guest_admin_msg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg_by` text COLLATE utf8_unicode_ci NOT NULL,
  `msg_to` text COLLATE utf8_unicode_ci NOT NULL,
  `msg` text COLLATE utf8_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `status` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ur',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `guest_admin_msg`
--

INSERT INTO `guest_admin_msg` VALUES (87,'Guest280','admin','test','2021-06-21','r');

--
-- Table structure for table `how-it-works`
--

CREATE TABLE `how-it-works` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text1` text NOT NULL,
  `text2` text NOT NULL,
  `text3` text NOT NULL,
  `youtube_link` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `how-it-works`
--

INSERT INTO `how-it-works` VALUES (1,'Need some help? Tell us what services you need and where do you need them - directly from our website or mobile app. ','Depending on the service, we will send quotes or assign you a vendor at fixed prices. Speed, reliability, value and satisfaction is our priority.','Hire the right vendor for your job request. Once the vendor completed the job, you can pay them directly .','https://www.youtube.com/watch?v=F0GHgVp7IlI');

--
-- Table structure for table `job`
--

CREATE TABLE `job` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_id` text NOT NULL,
  `title` text NOT NULL,
  `username` text NOT NULL,
  `category` varchar(1000) NOT NULL,
  `country` varchar(1000) NOT NULL,
  `state` varchar(1000) NOT NULL,
  `address` text NOT NULL,
  `experience` text NOT NULL,
  `description` text NOT NULL,
  `vacancy` text NOT NULL,
  `image` text NOT NULL,
  `subcategory` varchar(1000) NOT NULL,
  `city` varchar(1000) NOT NULL,
  `city_name` text NOT NULL,
  `zip` text NOT NULL,
  `status` varchar(1000) NOT NULL DEFAULT '1',
  `date` date NOT NULL,
  `job_comple_date` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `job`
--


--
-- Table structure for table `job_bid`
--

CREATE TABLE `job_bid` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_id` text NOT NULL,
  `recruiter` text NOT NULL,
  `freelancer` text NOT NULL,
  `proposal` text NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `job_bid`
--


--
-- Table structure for table `job_report`
--

CREATE TABLE `job_report` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_id` text NOT NULL,
  `reason` text NOT NULL,
  `description` text NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `job_report`
--


--
-- Table structure for table `latest_news`
--

CREATE TABLE `latest_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `latest_news`
--

INSERT INTO `latest_news` VALUES (1,' e-PAN within 3-5 days '),(2,' Pan application fees only Rs 107/-'),(3,' Register as franchise today !!!');

--
-- Table structure for table `logo`
--

CREATE TABLE `logo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lgo_title` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logo`
--

INSERT INTO `logo` VALUES (1,'LOGO');

--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `recruiter` text NOT NULL,
  `freelancer` text NOT NULL,
  `message` text NOT NULL,
  `by` text NOT NULL,
  `date` date NOT NULL,
  `status` varchar(1000) NOT NULL DEFAULT 'ur',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `message`
--


--
-- Table structure for table `my_favorite`
--

CREATE TABLE `my_favorite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `job_id` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `my_favorite`
--


--
-- Table structure for table `navigation_tab`
--

CREATE TABLE `navigation_tab` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `navigation_tab`
--

INSERT INTO `navigation_tab` VALUES (1,'HOME'),(2,'FEATURES'),(3,'PRICE'),(4,'TESTIMONIAL'),(5,'LOGIN'),(6,'CONTACT');

--
-- Table structure for table `pan_update_require_field`
--

CREATE TABLE `pan_update_require_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pan_update_require_field`
--

INSERT INTO `pan_update_require_field` VALUES (1,'name'),(2,'DOB'),(3,'Gender'),(4,'Father\'s Name'),(5,'Mobile Number'),(6,'Email ID'),(7,'Address'),(8,'Photograph'),(9,'Signature'),(10,'Re Print');

--
-- Table structure for table `pancard`
--

CREATE TABLE `pancard` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ao_code` text NOT NULL,
  `ao_type` text NOT NULL,
  `range_code` text NOT NULL,
  `ao_no` text NOT NULL,
  `applicant_title` text NOT NULL,
  `fname` text NOT NULL,
  `mname` text NOT NULL,
  `lname` text NOT NULL,
  `name_on_card` text NOT NULL,
  `dbo` text NOT NULL,
  `guardian_name` text NOT NULL,
  `guardian_aadhar` text NOT NULL,
  `father_fname` text NOT NULL,
  `father_mname` text NOT NULL,
  `father_lname` text NOT NULL,
  `gender` text NOT NULL,
  `mobile_no` text NOT NULL,
  `email` text NOT NULL,
  `house_no` text NOT NULL,
  `village` text NOT NULL,
  `post` text NOT NULL,
  `state` text NOT NULL,
  `tehsil` text NOT NULL,
  `distric` text NOT NULL,
  `pin_code` text NOT NULL,
  `adhar_name` text NOT NULL,
  `adhar_no` text NOT NULL,
  `identity_proof` text NOT NULL,
  `address_proof` text NOT NULL,
  `dbo_proof` text NOT NULL,
  `adhar_from_path` text NOT NULL,
  `panfees` text NOT NULL,
  `date` date NOT NULL,
  `retailer` text NOT NULL,
  `token_no` text NOT NULL,
  `token_path` text NOT NULL,
  `ackn_no` text NOT NULL,
  `ack_path` text NOT NULL,
  `reason` text NOT NULL,
  `pan_reqest_type` varchar(1000) NOT NULL DEFAULT '1',
  `status` varchar(1000) NOT NULL DEFAULT '1',
  `panno` text NOT NULL,
  `panproof` text NOT NULL,
  `panreqfield` text NOT NULL,
  `hard_copy` varchar(1000) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pancard`
--


--
-- Table structure for table `pancard_fees`
--

CREATE TABLE `pancard_fees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fees` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pancard_fees`
--

INSERT INTO `pancard_fees` VALUES (1,'110.00');

--
-- Table structure for table `photographer`
--

CREATE TABLE `photographer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text,
  `email` text,
  `phone` text,
  `location` text,
  `function` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `photographer`
--

INSERT INTO `photographer` VALUES (3,'Shane Graef','shane@jowdy.com','972.273.0437','DFW','Technology Support'),(4,'Jeff Jowdy','Jeff@Jowdy.com','(214) 642-2222','DFW','National Support'),(5,'Tom Abrahamson','tom@jowdy.com','(210) 643-0900','San Antonio','National Support'),(6,'Joe Perrin','joe@jowdy.com','(817) 808-2715','DFW','DFW Support'),(7,'Ryan Littlefield','ryan@jowdy.com','(210) 776-5219','San Antonio','Image Editor'),(8,'Matt Fenstermacher','matt@jowdy.net','(817) 726-4161','DFW','Photographer'),(9,'Amir Jianpanah','amir@jowdy.com','(972) 413-0130','DFW','Photographer'),(10,'Micah Templeton','micah@jowdy.net','(903) 754-2492','DFW','Photographer'),(11,'Don Weaver','don@jowdy.net','(972) 454-0528','DFW','Photographer'),(12,'Annette Udvardi','photopiatx@yahoo.com','(817) 229-8766','Colorado','Photographer'),(13,'Alex Chavez','Alex@jowdy.net','(469) 773-1135','DFW','Photographer'),(14,'Dakota Sillyman','dakotasillyman@gmail.com','(423) 963-3793','Chicago','Photographer'),(15,'Joe Ubakke','joeuphoto@gmail.com','(312) 625-7005','Chicago','Photographer'),(16,'Jim Vondruska','jimvondruska@gmail.com','(708) 205-8804','Chicago','Photographer');

--
-- Table structure for table `photographer_attire`
--

CREATE TABLE `photographer_attire` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `photographer_attire`
--

INSERT INTO `photographer_attire` VALUES (2,'Jowdy Uniform, Black'),(3,'Suite & Tie'),(4,'test');

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `category` text NOT NULL,
  `price` text NOT NULL,
  `description` text NOT NULL,
  `image` text NOT NULL,
  `notice` text NOT NULL,
  `validity` text NOT NULL,
  `no_of_regd` text NOT NULL,
  `regdnotice` text NOT NULL,
  `status` varchar(1000) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product`
--

INSERT INTO `product` VALUES (1,'product 1','2','30','       Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley       ','transupload/312_Chrysanthemum.jpg','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book','30','6','            ','1'),(2,'product 2','2','35',' Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley ','transupload/351_Jellyfish.jpg','','30','2','  ','1'),(3,'Product 3','3','40',' Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley ','transupload/116_Tulips.jpg','','30','1','  ','1'),(4,'test pro 7','2','50','    desdsd dfdsfs cvdsfsdf vdsfdsf vsdfsf sdfsf    ','transupload/44_Lighthouse.jpg','notice  notice   notice   notice   notice  notice   notice   notice  mbnmbm','l','6','product Register  notice     product Register  notice   product Register  notice   product Register  notice  ','1'),(5,'product 1   --- > Trial','4','0','  this is  trial  product  this is  trial  product  this is  trial  product  this is  trial  product  this is  trial  product  this is  trial  product   ','transupload/321_Desert.jpg','product notice product notice  product notice product notice  product notice ','7','l','   product registration notice product registration notice product registration notice product registration notice  ','2'),(6,'test  product  0002','4','10','  ghjgvj  gfjfgj fgjgfj fgjfgjg  fdhfh nfdhfhj nfgjfgj','transupload/215_Hydrangeas.jpg','notice notice notice notice notice notice notice notice notice notice notice notice notice notice notice notice notice notice notice notice','7','3','register notice register notice register notice register notice register notice register notice register notice register notice register notice register notice','1');

--
-- Table structure for table `qualification_category`
--

CREATE TABLE `qualification_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `qualification_category`
--

INSERT INTO `qualification_category` VALUES (1,'MCA'),(2,'BTech'),(3,'MTech'),(4,'Graduate'),(5,'MBA'),(6,'BBA');

--
-- Table structure for table `question_answer`
--

CREATE TABLE `question_answer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` text NOT NULL,
  `answer` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `question_answer`
--

INSERT INTO `question_answer` VALUES (2,'question 1',' Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s,'),(4,'Question 2',' Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since th 2'),(5,'question 3','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the');

--
-- Table structure for table `question_answer2`
--

CREATE TABLE `question_answer2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` text NOT NULL,
  `answer` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `question_answer2`
--

INSERT INTO `question_answer2` VALUES (1,'Terms and Condition','<p><strong>Question 1 ?</strong></p>\r\n<p><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Lorem ipsome is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the .</span></p>\r\n<p><strong><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Question 2 ?</span></strong></p>\r\n<p><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Lorem ipsome is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the</span></p>\r\n<p><strong><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Question 3 ?</span></strong></p>\r\n<p><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Lorem ipsome is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the</span></p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>'),(2,'Privacy Policy','<p><strong>Question 1 ?</strong></p>\r\n<p><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Lorem ipsome is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the .</span></p>\r\n<p><strong><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Question 2 ?</span></strong></p>\r\n<p><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Lorem ipsome is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the</span></p>\r\n<p><strong><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Question 3 ?</span></strong></p>\r\n<p><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Lorem ipsome is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the</span></p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>'),(3,'Refund Policy','<p><strong>Question 1 ?</strong></p>\r\n<p><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Lorem ipsome is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the .</span></p>\r\n<p><strong><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Question 2 ?</span></strong></p>\r\n<p><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Lorem ipsome is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the</span></p>\r\n<p><strong><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Question 3 ?</span></strong></p>\r\n<p><span style=\"font-family: \'Open Sans\', Arial, sans-serif; text-align: justify;\">Lorem ipsome is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the</span></p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>');

--
-- Table structure for table `reatiler_news`
--

CREATE TABLE `reatiler_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` text NOT NULL,
  `image` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reatiler_news`
--

INSERT INTO `reatiler_news` VALUES (1,'      ','transupload/56_338_1537645444 (2) 123456-page-001.jpg'),(6,' 2','transupload/462_338_1537645444 (2) 123456-page-002.jpg');

--
-- Table structure for table `registration_fees`
--

CREATE TABLE `registration_fees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `price` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `registration_fees`
--

INSERT INTO `registration_fees` VALUES (1,'500.00');

--
-- Table structure for table `retailer_balance`
--

CREATE TABLE `retailer_balance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `trans_no` text NOT NULL,
  `other_details` text NOT NULL,
  `amount` text NOT NULL,
  `trans_by` text NOT NULL,
  `screenshort` text NOT NULL,
  `trans_date` text NOT NULL,
  `status` varchar(1000) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `retailer_balance`
--

INSERT INTO `retailer_balance` VALUES (1,'mou1952','1245687','for wallet balance','500','2','screenshort/135_Hydrangeas.jpg','2020-06-08','2'),(2,'mou1952','nnnnn','for testt','320','1','screenshort/233_Chrysanthemum.jpg','2020-06-22','3'),(3,'ANIN9812','1223366','rmnn11','500','2','screenshort/386_JOB CARD.jpg','2020-06-22','2'),(4,'RATA76116','IHM9124098','RATAN GHORAI','500','3','screenshort/52_25062020.png','2020-06-25','2'),(7,'SUJA33113','2750523447','Wallet money ','500','1','screenshort/16_Wed Jul 01 12:12:47 GMT+05:30 2020.jpg','2020-07-01','2'),(8,'PALA35915','018425489320','hiii','500','3','screenshort/387_WhatsApp Image 2020-07-02 at 9.25.02 AM.jpeg','2020-07-02','2'),(9,'SUBR92217','P2007021552074359561565','subrata bhakta','1000','1','screenshort/299_trans.jpeg','2020-07-02','2'),(10,'RATA76116','P2007021940444722972010','RATAN GHORAI','500','1','screenshort/46_R02072020.jpeg','2020-02-07','2'),(11,'SUJA33113','2758815618','Wallet money ','500','1','screenshort/390_Fri Jul 03 11:35:28 GMT+05:30 2020.jpg','2020-07-03','2'),(12,'KALI66829','018538772013','KALI66829','1000','1','screenshort/325_WhatsApp Image 2020-07-03 at 12.01.57.jpeg','2020-03-07','2'),(13,'SUVA87223','P2007031909505521917134','SUVA87223','535','3','screenshort/68_WhatsApp Image 2020-07-03 at 7.11.08 PM.jpeg','2020-07-03','2'),(14,'RATA76116','IHM9730631','RATAN GHORAI','1000','3','screenshort/260_572020.png','2020-07-05','2'),(15,'SUBR92217','P2007061655202953207377','SUBRATA BHAKTA','1000','1','screenshort/368_WhatsApp Image 2020-07-06 at 4.55.59 PM.jpeg','2020-07-06','2'),(16,'Soum25535','525889','soumen jana','110','1','screenshort/372_soumen.jpg','2020-07-06','2'),(17,'Basu87438','p2007081724131172843139','basudev patra','700','3','screenshort/277_2b7d3d09-d917-48a2-9aff-77825b4f5493.jpg','2020-07-08','2'),(18,'Basu87438','p20070824437429490046','basudev patra','1000','3','screenshort/9_1b5cee1c-57e0-43a6-aa95-da8b0fa30741.jpg','2020-07-08','2'),(19,'Sukd86018','125698745632574','sukdeb','1000','3','screenshort/476_sukdeb20200310_10114502.jpg','2020-07-10','2'),(20,'SOUM4941','94510','soumen giri','500','1','screenshort/266_SOUMEN.jpg','2020-07-10','2'),(21,'ARIJ90828','IHN0146622','ARIJ90828','550','3','screenshort/41_State_Bank_of_India.png','2020-07-11','2'),(22,'SOUM4941','92195','soumen giri','500','1','screenshort/50_7be3f0dc-f9c5-4d80-bea7-f81962088b42.jpg','2020-07-11','2'),(23,'SAUM46743','864447','saumen sahoo','720','1','screenshort/213_be71dae2-d5df-48c5-a24b-0a5bb2100699.jpg','2020-12-07','2'),(24,'KALI66829','018538772013','KALI66829','300','1','screenshort/161_WhatsApp Image 2020-07-03 at 11.46.01.jpeg','2020-07-12','2'),(25,'SK J10526','1234','sk jaynal','1000','1','screenshort/365_11.jpg','2020-07-12','2'),(26,'KALI66829','018538772013','KALI','1400','1','screenshort/271_ce15e3a7-0ee4-4c2d-ba2d-7b4948808dcc.jpg','2020-07-13','2'),(27,'SOUM54045','541254873215','soumen','1000','1','screenshort/266_c5857279-1526-47f8-93e5-1f72d3cb1c07.jpg','2020-07-16','2'),(28,'RAHU71839','IHN0501425','RAHU71839','300','1','screenshort/292_Untitled.png','2020-07-17','2'),(29,'Subh83934','123456','subhajit maity','1000','1','screenshort/389_Tulips.jpg','2020-07-17','2'),(30,'SUVA87223','P2007171852348370599812','SUVA87223','450','1','screenshort/163_WhatsApp Image 2020-07-17 at 6.59.42 PM.jpeg','2020-07-17','2'),(31,'RATA76116','0111222','fund transfer for credit wallet','350','1','screenshort/447_Lighthouse.jpg','2020-09-24','1');

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `heading` text NOT NULL,
  `text2` text NOT NULL,
  `text3` text NOT NULL,
  `text4` text NOT NULL,
  `image` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` VALUES (10,'The Best Tele Product','Starting     30 /  Key','1 click install','24/7 Support','transupload/394_2.png');

--
-- Table structure for table `slider_text`
--

CREATE TABLE `slider_text` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text1` text NOT NULL,
  `text2` text NOT NULL,
  `text3` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slider_text`
--

INSERT INTO `slider_text` VALUES (1,'Hire Service Providers','for any job, Online.','Hire the best professionals for any service you or your family need');

--
-- Table structure for table `social_link`
--

CREATE TABLE `social_link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `link` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `social_link`
--

INSERT INTO `social_link` VALUES (1,'Facebook','https://www.facebook.com/ServiceWebPlatform'),(2,'Youtube','https://www.youtube.com/'),(3,'Twitter','https://www.twilio.com/');

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `country_id` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4122 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `states`
--

INSERT INTO `states` VALUES (1,'Andaman and Nicobar Islands',101),(2,'Andhra Pradesh',101),(3,'Arunachal Pradesh',101),(4,'Assam',101),(5,'Bihar',101),(6,'Chandigarh',101),(7,'Chhattisgarh',101),(8,'Dadra and Nagar Haveli',101),(9,'Daman and Diu',101),(10,'Delhi',101),(11,'Goa',101),(12,'Gujarat',101),(13,'Haryana',101),(14,'Himachal Pradesh',101),(15,'Jammu and Kashmir',101),(16,'Jharkhand',101),(17,'Karnataka',101),(18,'Kenmore',101),(19,'Kerala',101),(20,'Lakshadweep',101),(21,'Madhya Pradesh',101),(22,'Maharashtra',101),(23,'Manipur',101),(24,'Meghalaya',101),(25,'Mizoram',101),(26,'Nagaland',101),(27,'Narora',101),(28,'Natwar',101),(29,'Odisha',101),(30,'Paschim Medinipur',101),(31,'Pondicherry',101),(32,'Punjab',101),(33,'Rajasthan',101),(34,'Sikkim',101),(35,'Tamil Nadu',101),(36,'Telangana',101),(37,'Tripura',101),(38,'Uttar Pradesh',101),(39,'Uttarakhand',101),(40,'Vaishali',101),(41,'West Bengal',101),(42,'Badakhshan',1),(43,'Badgis',1),(44,'Baglan',1),(45,'Balkh',1),(46,'Bamiyan',1),(47,'Farah',1),(48,'Faryab',1),(49,'Gawr',1),(50,'Gazni',1),(51,'Herat',1),(52,'Hilmand',1),(53,'Jawzjan',1),(54,'Kabul',1),(55,'Kapisa',1),(56,'Khawst',1),(57,'Kunar',1),(58,'Lagman',1),(59,'Lawghar',1),(60,'Nangarhar',1),(61,'Nimruz',1),(62,'Nuristan',1),(63,'Paktika',1),(64,'Paktiya',1),(65,'Parwan',1),(66,'Qandahar',1),(67,'Qunduz',1),(68,'Samangan',1),(69,'Sar-e Pul',1),(70,'Takhar',1),(71,'Uruzgan',1),(72,'Wardag',1),(73,'Zabul',1),(74,'Berat',2),(75,'Bulqize',2),(76,'Delvine',2),(77,'Devoll',2),(78,'Dibre',2),(79,'Durres',2),(80,'Elbasan',2),(81,'Fier',2),(82,'Gjirokaster',2),(83,'Gramsh',2),(84,'Has',2),(85,'Kavaje',2),(86,'Kolonje',2),(87,'Korce',2),(88,'Kruje',2),(89,'Kucove',2),(90,'Kukes',2),(91,'Kurbin',2),(92,'Lezhe',2),(93,'Librazhd',2),(94,'Lushnje',2),(95,'Mallakaster',2),(96,'Malsi e Madhe',2),(97,'Mat',2),(98,'Mirdite',2),(99,'Peqin',2),(100,'Permet',2),(101,'Pogradec',2),(102,'Puke',2),(103,'Sarande',2),(104,'Shkoder',2),(105,'Skrapar',2),(106,'Tepelene',2),(107,'Tirane',2),(108,'Tropoje',2),(109,'Vlore',2),(110,'\'Ayn Daflah',3),(111,'\'Ayn Tamushanat',3),(112,'Adrar',3),(113,'Algiers',3),(114,'Annabah',3),(115,'Bashshar',3),(116,'Batnah',3),(117,'Bijayah',3),(118,'Biskrah',3),(119,'Blidah',3),(120,'Buirah',3),(121,'Bumardas',3),(122,'Burj Bu Arririj',3),(123,'Ghalizan',3),(124,'Ghardayah',3),(125,'Ilizi',3),(126,'Jijili',3),(127,'Jilfah',3),(128,'Khanshalah',3),(129,'Masilah',3),(130,'Midyah',3),(131,'Milah',3),(132,'Muaskar',3),(133,'Mustaghanam',3),(134,'Naama',3),(135,'Oran',3),(136,'Ouargla',3),(137,'Qalmah',3),(138,'Qustantinah',3),(139,'Sakikdah',3),(140,'Satif',3),(141,'Sayda\'',3),(142,'Sidi ban-al-\'Abbas',3),(143,'Suq Ahras',3),(144,'Tamanghasat',3),(145,'Tibazah',3),(146,'Tibissah',3),(147,'Tilimsan',3),(148,'Tinduf',3),(149,'Tisamsilt',3),(150,'Tiyarat',3),(151,'Tizi Wazu',3),(152,'Umm-al-Bawaghi',3),(153,'Wahran',3),(154,'Warqla',3),(155,'Wilaya d Alger',3),(156,'Wilaya de Bejaia',3),(157,'Wilaya de Constantine',3),(158,'al-Aghwat',3),(159,'al-Bayadh',3),(160,'al-Jaza\'ir',3),(161,'al-Wad',3),(162,'ash-Shalif',3),(163,'at-Tarif',3),(164,'Eastern',4),(165,'Manu\'a',4),(166,'Swains Island',4),(167,'Western',4),(168,'Andorra la Vella',5),(169,'Canillo',5),(170,'Encamp',5),(171,'La Massana',5),(172,'Les Escaldes',5),(173,'Ordino',5),(174,'Sant Julia de Loria',5),(175,'Bengo',6),(176,'Benguela',6),(177,'Bie',6),(178,'Cabinda',6),(179,'Cunene',6),(180,'Huambo',6),(181,'Huila',6),(182,'Kuando-Kubango',6),(183,'Kwanza Norte',6),(184,'Kwanza Sul',6),(185,'Luanda',6),(186,'Lunda Norte',6),(187,'Lunda Sul',6),(188,'Malanje',6),(189,'Moxico',6),(190,'Namibe',6),(191,'Uige',6),(192,'Zaire',6),(193,'Other Provinces',7),(194,'Sector claimed by Argentina/Ch',8),(195,'Sector claimed by Argentina/UK',8),(196,'Sector claimed by Australia',8),(197,'Sector claimed by France',8),(198,'Sector claimed by New Zealand',8),(199,'Sector claimed by Norway',8),(200,'Unclaimed Sector',8),(201,'Barbuda',9),(202,'Saint George',9),(203,'Saint John',9),(204,'Saint Mary',9),(205,'Saint Paul',9),(206,'Saint Peter',9),(207,'Saint Philip',9),(208,'Buenos Aires',10),(209,'Catamarca',10),(210,'Chaco',10),(211,'Chubut',10),(212,'Cordoba',10),(213,'Corrientes',10),(214,'Distrito Federal',10),(215,'Entre Rios',10),(216,'Formosa',10),(217,'Jujuy',10),(218,'La Pampa',10),(219,'La Rioja',10),(220,'Mendoza',10),(221,'Misiones',10),(222,'Neuquen',10),(223,'Rio Negro',10),(224,'Salta',10),(225,'San Juan',10),(226,'San Luis',10),(227,'Santa Cruz',10),(228,'Santa Fe',10),(229,'Santiago del Estero',10),(230,'Tierra del Fuego',10),(231,'Tucuman',10),(232,'Aragatsotn',11),(233,'Ararat',11),(234,'Armavir',11),(235,'Gegharkunik',11),(236,'Kotaik',11),(237,'Lori',11),(238,'Shirak',11),(239,'Stepanakert',11),(240,'Syunik',11),(241,'Tavush',11),(242,'Vayots Dzor',11),(243,'Yerevan',11),(244,'Aruba',12),(245,'Auckland',13),(246,'Australian Capital Territory',13),(247,'Balgowlah',13),(248,'Balmain',13),(249,'Bankstown',13),(250,'Baulkham Hills',13),(251,'Bonnet Bay',13),(252,'Camberwell',13),(253,'Carole Park',13),(254,'Castle Hill',13),(255,'Caulfield',13),(256,'Chatswood',13),(257,'Cheltenham',13),(258,'Cherrybrook',13),(259,'Clayton',13),(260,'Collingwood',13),(261,'Frenchs Forest',13),(262,'Hawthorn',13),(263,'Jannnali',13),(264,'Knoxfield',13),(265,'Melbourne',13),(266,'New South Wales',13),(267,'Northern Territory',13),(268,'Perth',13),(269,'Queensland',13),(270,'South Australia',13),(271,'Tasmania',13),(272,'Templestowe',13),(273,'Victoria',13),(274,'Werribee south',13),(275,'Western Australia',13),(276,'Wheeler',13),(277,'Bundesland Salzburg',14),(278,'Bundesland Steiermark',14),(279,'Bundesland Tirol',14),(280,'Burgenland',14),(281,'Carinthia',14),(282,'Karnten',14),(283,'Liezen',14),(284,'Lower Austria',14),(285,'Niederosterreich',14),(286,'Oberosterreich',14),(287,'Salzburg',14),(288,'Schleswig-Holstein',14),(289,'Steiermark',14),(290,'Styria',14),(291,'Tirol',14),(292,'Upper Austria',14),(293,'Vorarlberg',14),(294,'Wien',14),(295,'Abseron',15),(296,'Baki Sahari',15),(297,'Ganca',15),(298,'Ganja',15),(299,'Kalbacar',15),(300,'Lankaran',15),(301,'Mil-Qarabax',15),(302,'Mugan-Salyan',15),(303,'Nagorni-Qarabax',15),(304,'Naxcivan',15),(305,'Priaraks',15),(306,'Qazax',15),(307,'Saki',15),(308,'Sirvan',15),(309,'Xacmaz',15),(310,'Abaco',16),(311,'Acklins Island',16),(312,'Andros',16),(313,'Berry Islands',16),(314,'Biminis',16),(315,'Cat Island',16),(316,'Crooked Island',16),(317,'Eleuthera',16),(318,'Exuma and Cays',16),(319,'Grand Bahama',16),(320,'Inagua Islands',16),(321,'Long Island',16),(322,'Mayaguana',16),(323,'New Providence',16),(324,'Ragged Island',16),(325,'Rum Cay',16),(326,'San Salvador',16),(327,'\'Isa',17),(328,'Badiyah',17),(329,'Hidd',17),(330,'Jidd Hafs',17),(331,'Mahama',17),(332,'Manama',17),(333,'Sitrah',17),(334,'al-Manamah',17),(335,'al-Muharraq',17),(336,'ar-Rifa\'a',17),(337,'Bagar Hat',18),(338,'Bandarban',18),(339,'Barguna',18),(340,'Barisal',18),(341,'Bhola',18),(342,'Bogora',18),(343,'Brahman Bariya',18),(344,'Chandpur',18),(345,'Chattagam',18),(346,'Chittagong Division',18),(347,'Chuadanga',18),(348,'Dhaka',18),(349,'Dinajpur',18),(350,'Faridpur',18),(351,'Feni',18),(352,'Gaybanda',18),(353,'Gazipur',18),(354,'Gopalganj',18),(355,'Habiganj',18),(356,'Jaipur Hat',18),(357,'Jamalpur',18),(358,'Jessor',18),(359,'Jhalakati',18),(360,'Jhanaydah',18),(361,'Khagrachhari',18),(362,'Khulna',18),(363,'Kishorganj',18),(364,'Koks Bazar',18),(365,'Komilla',18),(366,'Kurigram',18),(367,'Kushtiya',18),(368,'Lakshmipur',18),(369,'Lalmanir Hat',18),(370,'Madaripur',18),(371,'Magura',18),(372,'Maimansingh',18),(373,'Manikganj',18),(374,'Maulvi Bazar',18),(375,'Meherpur',18),(376,'Munshiganj',18),(377,'Naral',18),(378,'Narayanganj',18),(379,'Narsingdi',18),(380,'Nator',18),(381,'Naugaon',18),(382,'Nawabganj',18),(383,'Netrakona',18),(384,'Nilphamari',18),(385,'Noakhali',18),(386,'Pabna',18),(387,'Panchagarh',18),(388,'Patuakhali',18),(389,'Pirojpur',18),(390,'Rajbari',18),(391,'Rajshahi',18),(392,'Rangamati',18),(393,'Rangpur',18),(394,'Satkhira',18),(395,'Shariatpur',18),(396,'Sherpur',18),(397,'Silhat',18),(398,'Sirajganj',18),(399,'Sunamganj',18),(400,'Tangayal',18),(401,'Thakurgaon',18),(402,'Christ Church',19),(403,'Saint Andrew',19),(404,'Saint George',19),(405,'Saint James',19),(406,'Saint John',19),(407,'Saint Joseph',19),(408,'Saint Lucy',19),(409,'Saint Michael',19),(410,'Saint Peter',19),(411,'Saint Philip',19),(412,'Saint Thomas',19),(413,'Brest',20),(414,'Homjel\'',20),(415,'Hrodna',20),(416,'Mahiljow',20),(417,'Mahilyowskaya Voblasts',20),(418,'Minsk',20),(419,'Minskaja Voblasts\'',20),(420,'Petrik',20),(421,'Vicebsk',20),(422,'Antwerpen',21),(423,'Berchem',21),(424,'Brabant',21),(425,'Brabant Wallon',21),(426,'Brussel',21),(427,'East Flanders',21),(428,'Hainaut',21),(429,'Liege',21),(430,'Limburg',21),(431,'Luxembourg',21),(432,'Namur',21),(433,'Ontario',21),(434,'Oost-Vlaanderen',21),(435,'Provincie Brabant',21),(436,'Vlaams-Brabant',21),(437,'Wallonne',21),(438,'West-Vlaanderen',21),(439,'Belize',22),(440,'Cayo',22),(441,'Corozal',22),(442,'Orange Walk',22),(443,'Stann Creek',22),(444,'Toledo',22),(445,'Alibori',23),(446,'Atacora',23),(447,'Atlantique',23),(448,'Borgou',23),(449,'Collines',23),(450,'Couffo',23),(451,'Donga',23),(452,'Littoral',23),(453,'Mono',23),(454,'Oueme',23),(455,'Plateau',23),(456,'Zou',23),(457,'Hamilton',24),(458,'Saint George',24),(459,'Bumthang',25),(460,'Chhukha',25),(461,'Chirang',25),(462,'Daga',25),(463,'Geylegphug',25),(464,'Ha',25),(465,'Lhuntshi',25),(466,'Mongar',25),(467,'Pemagatsel',25),(468,'Punakha',25),(469,'Rinpung',25),(470,'Samchi',25),(471,'Samdrup Jongkhar',25),(472,'Shemgang',25),(473,'Tashigang',25),(474,'Timphu',25),(475,'Tongsa',25),(476,'Wangdiphodrang',25),(477,'Beni',26),(478,'Chuquisaca',26),(479,'Cochabamba',26),(480,'La Paz',26),(481,'Oruro',26),(482,'Pando',26),(483,'Potosi',26),(484,'Santa Cruz',26),(485,'Tarija',26),(486,'Federacija Bosna i Hercegovina',27),(487,'Republika Srpska',27),(488,'Central Bobonong',28),(489,'Central Boteti',28),(490,'Central Mahalapye',28),(491,'Central Serowe-Palapye',28),(492,'Central Tutume',28),(493,'Chobe',28),(494,'Francistown',28),(495,'Gaborone',28),(496,'Ghanzi',28),(497,'Jwaneng',28),(498,'Kgalagadi North',28),(499,'Kgalagadi South',28),(500,'Kgatleng',28),(501,'Kweneng',28),(502,'Lobatse',28),(503,'Ngamiland',28),(504,'Ngwaketse',28),(505,'North East',28),(506,'Okavango',28),(507,'Orapa',28),(508,'Selibe Phikwe',28),(509,'South East',28),(510,'Sowa',28),(511,'Bouvet Island',29),(512,'Acre',30),(513,'Alagoas',30),(514,'Amapa',30),(515,'Amazonas',30),(516,'Bahia',30),(517,'Ceara',30),(518,'Distrito Federal',30),(519,'Espirito Santo',30),(520,'Estado de Sao Paulo',30),(521,'Goias',30),(522,'Maranhao',30),(523,'Mato Grosso',30),(524,'Mato Grosso do Sul',30),(525,'Minas Gerais',30),(526,'Para',30),(527,'Paraiba',30),(528,'Parana',30),(529,'Pernambuco',30),(530,'Piaui',30),(531,'Rio Grande do Norte',30),(532,'Rio Grande do Sul',30),(533,'Rio de Janeiro',30),(534,'Rondonia',30),(535,'Roraima',30),(536,'Santa Catarina',30),(537,'Sao Paulo',30),(538,'Sergipe',30),(539,'Tocantins',30),(540,'British Indian Ocean Territory',31),(541,'Belait',32),(542,'Brunei-Muara',32),(543,'Temburong',32),(544,'Tutong',32),(545,'Blagoevgrad',33),(546,'Burgas',33),(547,'Dobrich',33),(548,'Gabrovo',33),(549,'Haskovo',33),(550,'Jambol',33),(551,'Kardzhali',33),(552,'Kjustendil',33),(553,'Lovech',33),(554,'Montana',33),(555,'Oblast Sofiya-Grad',33),(556,'Pazardzhik',33),(557,'Pernik',33),(558,'Pleven',33),(559,'Plovdiv',33),(560,'Razgrad',33),(561,'Ruse',33),(562,'Shumen',33),(563,'Silistra',33),(564,'Sliven',33),(565,'Smoljan',33),(566,'Sofija grad',33),(567,'Sofijska oblast',33),(568,'Stara Zagora',33),(569,'Targovishte',33),(570,'Varna',33),(571,'Veliko Tarnovo',33),(572,'Vidin',33),(573,'Vraca',33),(574,'Yablaniza',33),(575,'Bale',34),(576,'Bam',34),(577,'Bazega',34),(578,'Bougouriba',34),(579,'Boulgou',34),(580,'Boulkiemde',34),(581,'Comoe',34),(582,'Ganzourgou',34),(583,'Gnagna',34),(584,'Gourma',34),(585,'Houet',34),(586,'Ioba',34),(587,'Kadiogo',34),(588,'Kenedougou',34),(589,'Komandjari',34),(590,'Kompienga',34),(591,'Kossi',34),(592,'Kouritenga',34),(593,'Kourweogo',34),(594,'Leraba',34),(595,'Mouhoun',34),(596,'Nahouri',34),(597,'Namentenga',34),(598,'Noumbiel',34),(599,'Oubritenga',34),(600,'Oudalan',34),(601,'Passore',34),(602,'Poni',34),(603,'Sanguie',34),(604,'Sanmatenga',34),(605,'Seno',34),(606,'Sissili',34),(607,'Soum',34),(608,'Sourou',34),(609,'Tapoa',34),(610,'Tuy',34),(611,'Yatenga',34),(612,'Zondoma',34),(613,'Zoundweogo',34),(614,'Bubanza',35),(615,'Bujumbura',35),(616,'Bururi',35),(617,'Cankuzo',35),(618,'Cibitoke',35),(619,'Gitega',35),(620,'Karuzi',35),(621,'Kayanza',35),(622,'Kirundo',35),(623,'Makamba',35),(624,'Muramvya',35),(625,'Muyinga',35),(626,'Ngozi',35),(627,'Rutana',35),(628,'Ruyigi',35),(629,'Banteay Mean Chey',36),(630,'Bat Dambang',36),(631,'Kampong Cham',36),(632,'Kampong Chhnang',36),(633,'Kampong Spoeu',36),(634,'Kampong Thum',36),(635,'Kampot',36),(636,'Kandal',36),(637,'Kaoh Kong',36),(638,'Kracheh',36),(639,'Krong Kaeb',36),(640,'Krong Pailin',36),(641,'Krong Preah Sihanouk',36),(642,'Mondol Kiri',36),(643,'Otdar Mean Chey',36),(644,'Phnum Penh',36),(645,'Pousat',36),(646,'Preah Vihear',36),(647,'Prey Veaeng',36),(648,'Rotanak Kiri',36),(649,'Siem Reab',36),(650,'Stueng Traeng',36),(651,'Svay Rieng',36),(652,'Takaev',36),(653,'Adamaoua',37),(654,'Centre',37),(655,'Est',37),(656,'Littoral',37),(657,'Nord',37),(658,'Nord Extreme',37),(659,'Nordouest',37),(660,'Ouest',37),(661,'Sud',37),(662,'Sudouest',37),(663,'Alberta',38),(664,'British Columbia',38),(665,'Manitoba',38),(666,'New Brunswick',38),(667,'Newfoundland and Labrador',38),(668,'Northwest Territories',38),(669,'Nova Scotia',38),(670,'Nunavut',38),(671,'Ontario',38),(672,'Prince Edward Island',38),(673,'Quebec',38),(674,'Saskatchewan',38),(675,'Yukon',38),(676,'Boavista',39),(677,'Brava',39),(678,'Fogo',39),(679,'Maio',39),(680,'Sal',39),(681,'Santo Antao',39),(682,'Sao Nicolau',39),(683,'Sao Tiago',39),(684,'Sao Vicente',39),(685,'Grand Cayman',40),(686,'Bamingui-Bangoran',41),(687,'Bangui',41),(688,'Basse-Kotto',41),(689,'Haut-Mbomou',41),(690,'Haute-Kotto',41),(691,'Kemo',41),(692,'Lobaye',41),(693,'Mambere-Kadei',41),(694,'Mbomou',41),(695,'Nana-Gribizi',41),(696,'Nana-Mambere',41),(697,'Ombella Mpoko',41),(698,'Ouaka',41),(699,'Ouham',41),(700,'Ouham-Pende',41),(701,'Sangha-Mbaere',41),(702,'Vakaga',41),(703,'Batha',42),(704,'Biltine',42),(705,'Bourkou-Ennedi-Tibesti',42),(706,'Chari-Baguirmi',42),(707,'Guera',42),(708,'Kanem',42),(709,'Lac',42),(710,'Logone Occidental',42),(711,'Logone Oriental',42),(712,'Mayo-Kebbi',42),(713,'Moyen-Chari',42),(714,'Ouaddai',42),(715,'Salamat',42),(716,'Tandjile',42),(717,'Aisen',43),(718,'Antofagasta',43),(719,'Araucania',43),(720,'Atacama',43),(721,'Bio Bio',43),(722,'Coquimbo',43),(723,'Libertador General Bernardo O\'',43),(724,'Los Lagos',43),(725,'Magellanes',43),(726,'Maule',43),(727,'Metropolitana',43),(728,'Metropolitana de Santiago',43),(729,'Tarapaca',43),(730,'Valparaiso',43),(731,'Anhui',44),(734,'Aomen',44),(735,'Beijing',44),(736,'Beijing Shi',44),(737,'Chongqing',44),(738,'Fujian',44),(740,'Gansu',44),(741,'Guangdong',44),(743,'Guangxi',44),(744,'Guizhou',44),(745,'Hainan',44),(746,'Hebei',44),(747,'Heilongjiang',44),(748,'Henan',44),(749,'Hubei',44),(750,'Hunan',44),(751,'Jiangsu',44),(753,'Jiangxi',44),(754,'Jilin',44),(755,'Liaoning',44),(757,'Nei Monggol',44),(758,'Ningxia Hui',44),(759,'Qinghai',44),(760,'Shaanxi',44),(761,'Shandong',44),(763,'Shanghai',44),(764,'Shanxi',44),(765,'Sichuan',44),(766,'Tianjin',44),(767,'Xianggang',44),(768,'Xinjiang',44),(769,'Xizang',44),(770,'Yunnan',44),(771,'Zhejiang',44),(773,'Christmas Island',45),(774,'Cocos (Keeling) Islands',46),(775,'Amazonas',47),(776,'Antioquia',47),(777,'Arauca',47),(778,'Atlantico',47),(779,'Bogota',47),(780,'Bolivar',47),(781,'Boyaca',47),(782,'Caldas',47),(783,'Caqueta',47),(784,'Casanare',47),(785,'Cauca',47),(786,'Cesar',47),(787,'Choco',47),(788,'Cordoba',47),(789,'Cundinamarca',47),(790,'Guainia',47),(791,'Guaviare',47),(792,'Huila',47),(793,'La Guajira',47),(794,'Magdalena',47),(795,'Meta',47),(796,'Narino',47),(797,'Norte de Santander',47),(798,'Putumayo',47),(799,'Quindio',47),(800,'Risaralda',47),(801,'San Andres y Providencia',47),(802,'Santander',47),(803,'Sucre',47),(804,'Tolima',47),(805,'Valle del Cauca',47),(806,'Vaupes',47),(807,'Vichada',47),(808,'Mwali',48),(809,'Njazidja',48),(810,'Nzwani',48),(811,'Bouenza',49),(812,'Brazzaville',49),(813,'Cuvette',49),(814,'Kouilou',49),(815,'Lekoumou',49),(816,'Likouala',49),(817,'Niari',49),(818,'Plateaux',49),(819,'Pool',49),(820,'Sangha',49),(821,'Bandundu',50),(822,'Bas-Congo',50),(823,'Equateur',50),(824,'Haut-Congo',50),(825,'Kasai-Occidental',50),(826,'Kasai-Oriental',50),(827,'Katanga',50),(828,'Kinshasa',50),(829,'Maniema',50),(830,'Nord-Kivu',50),(831,'Sud-Kivu',50),(832,'Aitutaki',51),(833,'Atiu',51),(834,'Mangaia',51),(835,'Manihiki',51),(836,'Mauke',51),(837,'Mitiaro',51),(838,'Nassau',51),(839,'Pukapuka',51),(840,'Rakahanga',51),(841,'Rarotonga',51),(842,'Tongareva',51),(843,'Alajuela',52),(844,'Cartago',52),(845,'Guanacaste',52),(846,'Heredia',52),(847,'Limon',52),(848,'Puntarenas',52),(849,'San Jose',52),(850,'Abidjan',53),(851,'Agneby',53),(852,'Bafing',53),(853,'Denguele',53),(854,'Dix-huit Montagnes',53),(855,'Fromager',53),(856,'Haut-Sassandra',53),(857,'Lacs',53),(858,'Lagunes',53),(859,'Marahoue',53),(860,'Moyen-Cavally',53),(861,'Moyen-Comoe',53),(862,'N\'zi-Comoe',53),(863,'Sassandra',53),(864,'Savanes',53),(865,'Sud-Bandama',53),(866,'Sud-Comoe',53),(867,'Vallee du Bandama',53),(868,'Worodougou',53),(869,'Zanzan',53),(870,'Bjelovar-Bilogora',54),(871,'Dubrovnik-Neretva',54),(872,'Grad Zagreb',54),(873,'Istra',54),(874,'Karlovac',54),(875,'Koprivnica-Krizhevci',54),(876,'Krapina-Zagorje',54),(877,'Lika-Senj',54),(878,'Medhimurje',54),(879,'Medimurska Zupanija',54),(880,'Osijek-Baranja',54),(881,'Osjecko-Baranjska Zupanija',54),(882,'Pozhega-Slavonija',54),(883,'Primorje-Gorski Kotar',54),(884,'Shibenik-Knin',54),(885,'Sisak-Moslavina',54),(886,'Slavonski Brod-Posavina',54),(887,'Split-Dalmacija',54),(888,'Varazhdin',54),(889,'Virovitica-Podravina',54),(890,'Vukovar-Srijem',54),(891,'Zadar',54),(892,'Zagreb',54),(893,'Camaguey',55),(894,'Ciego de Avila',55),(895,'Cienfuegos',55),(896,'Ciudad de la Habana',55),(897,'Granma',55),(898,'Guantanamo',55),(899,'Habana',55),(900,'Holguin',55),(901,'Isla de la Juventud',55),(902,'La Habana',55),(903,'Las Tunas',55),(904,'Matanzas',55),(905,'Pinar del Rio',55),(906,'Sancti Spiritus',55),(907,'Santiago de Cuba',55),(908,'Villa Clara',55),(909,'Government controlled area',56),(910,'Limassol',56),(911,'Nicosia District',56),(912,'Paphos',56),(913,'Turkish controlled area',56),(914,'Central Bohemian',57),(915,'Frycovice',57),(916,'Jihocesky Kraj',57),(917,'Jihochesky',57),(918,'Jihomoravsky',57),(919,'Karlovarsky',57),(920,'Klecany',57),(921,'Kralovehradecky',57),(922,'Liberecky',57),(923,'Lipov',57),(924,'Moravskoslezsky',57),(925,'Olomoucky',57),(926,'Olomoucky Kraj',57),(927,'Pardubicky',57),(928,'Plzensky',57),(929,'Praha',57),(930,'Rajhrad',57),(931,'Smirice',57),(932,'South Moravian',57),(933,'Straz nad Nisou',57),(934,'Stredochesky',57),(935,'Unicov',57),(936,'Ustecky',57),(937,'Valletta',57),(938,'Velesin',57),(939,'Vysochina',57),(940,'Zlinsky',57),(941,'Arhus',58),(942,'Bornholm',58),(943,'Frederiksborg',58),(944,'Fyn',58),(945,'Hovedstaden',58),(946,'Kobenhavn',58),(947,'Kobenhavns Amt',58),(948,'Kobenhavns Kommune',58),(949,'Nordjylland',58),(950,'Ribe',58),(951,'Ringkobing',58),(952,'Roervig',58),(953,'Roskilde',58),(954,'Roslev',58),(955,'Sjaelland',58),(956,'Soeborg',58),(957,'Sonderjylland',58),(958,'Storstrom',58),(959,'Syddanmark',58),(960,'Toelloese',58),(961,'Vejle',58),(962,'Vestsjalland',58),(963,'Viborg',58),(964,'\'Ali Sabih',59),(965,'Dikhil',59),(966,'Jibuti',59),(967,'Tajurah',59),(968,'Ubuk',59),(969,'Saint Andrew',60),(970,'Saint David',60),(971,'Saint George',60),(972,'Saint John',60),(973,'Saint Joseph',60),(974,'Saint Luke',60),(975,'Saint Mark',60),(976,'Saint Patrick',60),(977,'Saint Paul',60),(978,'Saint Peter',60),(979,'Azua',61),(980,'Bahoruco',61),(981,'Barahona',61),(982,'Dajabon',61),(983,'Distrito Nacional',61),(984,'Duarte',61),(985,'El Seybo',61),(986,'Elias Pina',61),(987,'Espaillat',61),(988,'Hato Mayor',61),(989,'Independencia',61),(990,'La Altagracia',61),(991,'La Romana',61),(992,'La Vega',61),(993,'Maria Trinidad Sanchez',61),(994,'Monsenor Nouel',61),(995,'Monte Cristi',61),(996,'Monte Plata',61),(997,'Pedernales',61),(998,'Peravia',61),(999,'Puerto Plata',61),(1000,'Salcedo',61),(1001,'Samana',61),(1002,'San Cristobal',61),(1003,'San Juan',61),(1004,'San Pedro de Macoris',61),(1005,'Sanchez Ramirez',61),(1006,'Santiago',61),(1007,'Santiago Rodriguez',61),(1008,'Valverde',61),(1009,'Aileu',62),(1010,'Ainaro',62),(1011,'Ambeno',62),(1012,'Baucau',62),(1013,'Bobonaro',62),(1014,'Cova Lima',62),(1015,'Dili',62),(1016,'Ermera',62),(1017,'Lautem',62),(1018,'Liquica',62),(1019,'Manatuto',62),(1020,'Manufahi',62),(1021,'Viqueque',62),(1022,'Azuay',63),(1023,'Bolivar',63),(1024,'Canar',63),(1025,'Carchi',63),(1026,'Chimborazo',63),(1027,'Cotopaxi',63),(1028,'El Oro',63),(1029,'Esmeraldas',63),(1030,'Galapagos',63),(1031,'Guayas',63),(1032,'Imbabura',63),(1033,'Loja',63),(1034,'Los Rios',63),(1035,'Manabi',63),(1036,'Morona Santiago',63),(1037,'Napo',63),(1038,'Orellana',63),(1039,'Pastaza',63),(1040,'Pichincha',63),(1041,'Sucumbios',63),(1042,'Tungurahua',63),(1043,'Zamora Chinchipe',63),(1044,'Aswan',64),(1045,'Asyut',64),(1046,'Bani Suwayf',64),(1047,'Bur Sa\'id',64),(1048,'Cairo',64),(1049,'Dumyat',64),(1050,'Kafr-ash-Shaykh',64),(1051,'Matruh',64),(1052,'Muhafazat ad Daqahliyah',64),(1053,'Muhafazat al Fayyum',64),(1054,'Muhafazat al Gharbiyah',64),(1055,'Muhafazat al Iskandariyah',64),(1056,'Muhafazat al Qahirah',64),(1057,'Qina',64),(1058,'Sawhaj',64),(1059,'Sina al-Janubiyah',64),(1060,'Sina ash-Shamaliyah',64),(1061,'ad-Daqahliyah',64),(1062,'al-Bahr-al-Ahmar',64),(1063,'al-Buhayrah',64),(1064,'al-Fayyum',64),(1065,'al-Gharbiyah',64),(1066,'al-Iskandariyah',64),(1067,'al-Ismailiyah',64),(1068,'al-Jizah',64),(1069,'al-Minufiyah',64),(1070,'al-Minya',64),(1071,'al-Qahira',64),(1072,'al-Qalyubiyah',64),(1073,'al-Uqsur',64),(1074,'al-Wadi al-Jadid',64),(1075,'as-Suways',64),(1076,'ash-Sharqiyah',64),(1077,'Ahuachapan',65),(1078,'Cabanas',65),(1079,'Chalatenango',65),(1080,'Cuscatlan',65),(1081,'La Libertad',65),(1082,'La Paz',65),(1083,'La Union',65),(1084,'Morazan',65),(1085,'San Miguel',65),(1086,'San Salvador',65),(1087,'San Vicente',65),(1088,'Santa Ana',65),(1089,'Sonsonate',65),(1090,'Usulutan',65),(1091,'Annobon',66),(1092,'Bioko Norte',66),(1093,'Bioko Sur',66),(1094,'Centro Sur',66),(1095,'Kie-Ntem',66),(1096,'Litoral',66),(1097,'Wele-Nzas',66),(1098,'Anseba',67),(1099,'Debub',67),(1100,'Debub-Keih-Bahri',67),(1101,'Gash-Barka',67),(1102,'Maekel',67),(1103,'Semien-Keih-Bahri',67),(1104,'Harju',68),(1105,'Hiiu',68),(1106,'Ida-Viru',68),(1107,'Jarva',68),(1108,'Jogeva',68),(1109,'Laane',68),(1110,'Laane-Viru',68),(1111,'Parnu',68),(1112,'Polva',68),(1113,'Rapla',68),(1114,'Saare',68),(1115,'Tartu',68),(1116,'Valga',68),(1117,'Viljandi',68),(1118,'Voru',68),(1119,'Addis Abeba',69),(1120,'Afar',69),(1121,'Amhara',69),(1122,'Benishangul',69),(1123,'Diredawa',69),(1124,'Gambella',69),(1125,'Harar',69),(1126,'Jigjiga',69),(1127,'Mekele',69),(1128,'Oromia',69),(1129,'Somali',69),(1130,'Southern',69),(1131,'Tigray',69),(1132,'Christmas Island',70),(1133,'Cocos Islands',70),(1134,'Coral Sea Islands',70),(1135,'Falkland Islands',71),(1136,'South Georgia',71),(1137,'Klaksvik',72),(1138,'Nor ara Eysturoy',72),(1139,'Nor oy',72),(1140,'Sandoy',72),(1141,'Streymoy',72),(1142,'Su uroy',72),(1143,'Sy ra Eysturoy',72),(1144,'Torshavn',72),(1145,'Vaga',72),(1146,'Central',73),(1147,'Eastern',73),(1148,'Northern',73),(1149,'South Pacific',73),(1150,'Western',73),(1151,'Ahvenanmaa',74),(1152,'Etela-Karjala',74),(1153,'Etela-Pohjanmaa',74),(1154,'Etela-Savo',74),(1155,'Etela-Suomen Laani',74),(1156,'Ita-Suomen Laani',74),(1157,'Ita-Uusimaa',74),(1158,'Kainuu',74),(1159,'Kanta-Hame',74),(1160,'Keski-Pohjanmaa',74),(1161,'Keski-Suomi',74),(1162,'Kymenlaakso',74),(1163,'Lansi-Suomen Laani',74),(1164,'Lappi',74),(1165,'Northern Savonia',74),(1166,'Ostrobothnia',74),(1167,'Oulun Laani',74),(1168,'Paijat-Hame',74),(1169,'Pirkanmaa',74),(1170,'Pohjanmaa',74),(1171,'Pohjois-Karjala',74),(1172,'Pohjois-Pohjanmaa',74),(1173,'Pohjois-Savo',74),(1174,'Saarijarvi',74),(1175,'Satakunta',74),(1176,'Southern Savonia',74),(1177,'Tavastia Proper',74),(1178,'Uleaborgs Lan',74),(1179,'Uusimaa',74),(1180,'Varsinais-Suomi',74),(1181,'Ain',75),(1182,'Aisne',75),(1183,'Albi Le Sequestre',75),(1184,'Allier',75),(1185,'Alpes-Cote dAzur',75),(1186,'Alpes-Maritimes',75),(1187,'Alpes-de-Haute-Provence',75),(1188,'Alsace',75),(1189,'Aquitaine',75),(1190,'Ardeche',75),(1191,'Ardennes',75),(1192,'Ariege',75),(1193,'Aube',75),(1194,'Aude',75),(1195,'Auvergne',75),(1196,'Aveyron',75),(1197,'Bas-Rhin',75),(1198,'Basse-Normandie',75),(1199,'Bouches-du-Rhone',75),(1200,'Bourgogne',75),(1201,'Bretagne',75),(1202,'Brittany',75),(1203,'Burgundy',75),(1204,'Calvados',75),(1205,'Cantal',75),(1206,'Cedex',75),(1207,'Centre',75),(1208,'Charente',75),(1209,'Charente-Maritime',75),(1210,'Cher',75),(1211,'Correze',75),(1212,'Corse-du-Sud',75),(1213,'Cote-d\'Or',75),(1214,'Cotes-d\'Armor',75),(1215,'Creuse',75),(1216,'Crolles',75),(1217,'Deux-Sevres',75),(1218,'Dordogne',75),(1219,'Doubs',75),(1220,'Drome',75),(1221,'Essonne',75),(1222,'Eure',75),(1223,'Eure-et-Loir',75),(1224,'Feucherolles',75),(1225,'Finistere',75),(1226,'Franche-Comte',75),(1227,'Gard',75),(1228,'Gers',75),(1229,'Gironde',75),(1230,'Haut-Rhin',75),(1231,'Haute-Corse',75),(1232,'Haute-Garonne',75),(1233,'Haute-Loire',75),(1234,'Haute-Marne',75),(1235,'Haute-Saone',75),(1236,'Haute-Savoie',75),(1237,'Haute-Vienne',75),(1238,'Hautes-Alpes',75),(1239,'Hautes-Pyrenees',75),(1240,'Hauts-de-Seine',75),(1241,'Herault',75),(1242,'Ile-de-France',75),(1243,'Ille-et-Vilaine',75),(1244,'Indre',75),(1245,'Indre-et-Loire',75),(1246,'Isere',75),(1247,'Jura',75),(1248,'Klagenfurt',75),(1249,'Landes',75),(1250,'Languedoc-Roussillon',75),(1251,'Larcay',75),(1252,'Le Castellet',75),(1253,'Le Creusot',75),(1254,'Limousin',75),(1255,'Loir-et-Cher',75),(1256,'Loire',75),(1257,'Loire-Atlantique',75),(1258,'Loiret',75),(1259,'Lorraine',75),(1260,'Lot',75),(1261,'Lot-et-Garonne',75),(1262,'Lower Normandy',75),(1263,'Lozere',75),(1264,'Maine-et-Loire',75),(1265,'Manche',75),(1266,'Marne',75),(1267,'Mayenne',75),(1268,'Meurthe-et-Moselle',75),(1269,'Meuse',75),(1270,'Midi-Pyrenees',75),(1271,'Morbihan',75),(1272,'Moselle',75),(1273,'Nievre',75),(1274,'Nord',75),(1275,'Nord-Pas-de-Calais',75),(1276,'Oise',75),(1277,'Orne',75),(1278,'Paris',75),(1279,'Pas-de-Calais',75),(1280,'Pays de la Loire',75),(1281,'Pays-de-la-Loire',75),(1282,'Picardy',75),(1283,'Puy-de-Dome',75),(1284,'Pyrenees-Atlantiques',75),(1285,'Pyrenees-Orientales',75),(1286,'Quelmes',75),(1287,'Rhone',75),(1288,'Rhone-Alpes',75),(1289,'Saint Ouen',75),(1290,'Saint Viatre',75),(1291,'Saone-et-Loire',75),(1292,'Sarthe',75),(1293,'Savoie',75),(1294,'Seine-Maritime',75),(1295,'Seine-Saint-Denis',75),(1296,'Seine-et-Marne',75),(1297,'Somme',75),(1298,'Sophia Antipolis',75),(1299,'Souvans',75),(1300,'Tarn',75),(1301,'Tarn-et-Garonne',75),(1302,'Territoire de Belfort',75),(1303,'Treignac',75),(1304,'Upper Normandy',75),(1305,'Val-d\'Oise',75),(1306,'Val-de-Marne',75),(1307,'Var',75),(1308,'Vaucluse',75),(1309,'Vellise',75),(1310,'Vendee',75),(1311,'Vienne',75),(1312,'Vosges',75),(1313,'Yonne',75),(1314,'Yvelines',75),(1315,'Cayenne',76),(1316,'Saint-Laurent-du-Maroni',76),(1317,'Iles du Vent',77),(1318,'Iles sous le Vent',77),(1319,'Marquesas',77),(1320,'Tuamotu',77),(1321,'Tubuai',77),(1322,'Amsterdam',78),(1323,'Crozet Islands',78),(1324,'Kerguelen',78),(1325,'Estuaire',79),(1326,'Haut-Ogooue',79),(1327,'Moyen-Ogooue',79),(1328,'Ngounie',79),(1329,'Nyanga',79),(1330,'Ogooue-Ivindo',79),(1331,'Ogooue-Lolo',79),(1332,'Ogooue-Maritime',79),(1333,'Woleu-Ntem',79),(1334,'Banjul',80),(1335,'Basse',80),(1336,'Brikama',80),(1337,'Janjanbureh',80),(1338,'Kanifing',80),(1339,'Kerewan',80),(1340,'Kuntaur',80),(1341,'Mansakonko',80),(1342,'Abhasia',81),(1343,'Ajaria',81),(1344,'Guria',81),(1345,'Imereti',81),(1346,'Kaheti',81),(1347,'Kvemo Kartli',81),(1348,'Mcheta-Mtianeti',81),(1349,'Racha',81),(1350,'Samagrelo-Zemo Svaneti',81),(1351,'Samche-Zhavaheti',81),(1352,'Shida Kartli',81),(1353,'Tbilisi',81),(1354,'Auvergne',82),(1355,'Baden-Wurttemberg',82),(1356,'Bavaria',82),(1357,'Bayern',82),(1358,'Beilstein Wurtt',82),(1359,'Berlin',82),(1360,'Brandenburg',82),(1361,'Bremen',82),(1362,'Dreisbach',82),(1363,'Freistaat Bayern',82),(1364,'Hamburg',82),(1365,'Hannover',82),(1366,'Heroldstatt',82),(1367,'Hessen',82),(1368,'Kortenberg',82),(1369,'Laasdorf',82),(1370,'Land Baden-Wurttemberg',82),(1371,'Land Bayern',82),(1372,'Land Brandenburg',82),(1373,'Land Hessen',82),(1374,'Land Mecklenburg-Vorpommern',82),(1375,'Land Nordrhein-Westfalen',82),(1376,'Land Rheinland-Pfalz',82),(1377,'Land Sachsen',82),(1378,'Land Sachsen-Anhalt',82),(1379,'Land Thuringen',82),(1380,'Lower Saxony',82),(1381,'Mecklenburg-Vorpommern',82),(1382,'Mulfingen',82),(1383,'Munich',82),(1384,'Neubeuern',82),(1385,'Niedersachsen',82),(1386,'Noord-Holland',82),(1387,'Nordrhein-Westfalen',82),(1388,'North Rhine-Westphalia',82),(1389,'Osterode',82),(1390,'Rheinland-Pfalz',82),(1391,'Rhineland-Palatinate',82),(1392,'Saarland',82),(1393,'Sachsen',82),(1394,'Sachsen-Anhalt',82),(1395,'Saxony',82),(1396,'Schleswig-Holstein',82),(1397,'Thuringia',82),(1398,'Webling',82),(1399,'Weinstrabe',82),(1400,'schlobborn',82),(1401,'Ashanti',83),(1402,'Brong-Ahafo',83),(1403,'Central',83),(1404,'Eastern',83),(1405,'Greater Accra',83),(1406,'Northern',83),(1407,'Upper East',83),(1408,'Upper West',83),(1409,'Volta',83),(1410,'Western',83),(1411,'Gibraltar',84),(1412,'Acharnes',85),(1413,'Ahaia',85),(1414,'Aitolia kai Akarnania',85),(1415,'Argolis',85),(1416,'Arkadia',85),(1417,'Arta',85),(1418,'Attica',85),(1419,'Attiki',85),(1420,'Ayion Oros',85),(1421,'Crete',85),(1422,'Dodekanisos',85),(1423,'Drama',85),(1424,'Evia',85),(1425,'Evritania',85),(1426,'Evros',85),(1427,'Evvoia',85),(1428,'Florina',85),(1429,'Fokis',85),(1430,'Fthiotis',85),(1431,'Grevena',85),(1432,'Halandri',85),(1433,'Halkidiki',85),(1434,'Hania',85),(1435,'Heraklion',85),(1436,'Hios',85),(1437,'Ilia',85),(1438,'Imathia',85),(1439,'Ioannina',85),(1440,'Iraklion',85),(1441,'Karditsa',85),(1442,'Kastoria',85),(1443,'Kavala',85),(1444,'Kefallinia',85),(1445,'Kerkira',85),(1446,'Kiklades',85),(1447,'Kilkis',85),(1448,'Korinthia',85),(1449,'Kozani',85),(1450,'Lakonia',85),(1451,'Larisa',85),(1452,'Lasithi',85),(1453,'Lesvos',85),(1454,'Levkas',85),(1455,'Magnisia',85),(1456,'Messinia',85),(1457,'Nomos Attikis',85),(1458,'Nomos Zakynthou',85),(1459,'Pella',85),(1460,'Pieria',85),(1461,'Piraios',85),(1462,'Preveza',85),(1463,'Rethimni',85),(1464,'Rodopi',85),(1465,'Samos',85),(1466,'Serrai',85),(1467,'Thesprotia',85),(1468,'Thessaloniki',85),(1469,'Trikala',85),(1470,'Voiotia',85),(1471,'West Greece',85),(1472,'Xanthi',85),(1473,'Zakinthos',85),(1474,'Aasiaat',86),(1475,'Ammassalik',86),(1476,'Illoqqortoormiut',86),(1477,'Ilulissat',86),(1478,'Ivittuut',86),(1479,'Kangaatsiaq',86),(1480,'Maniitsoq',86),(1481,'Nanortalik',86),(1482,'Narsaq',86),(1483,'Nuuk',86),(1484,'Paamiut',86),(1485,'Qaanaaq',86),(1486,'Qaqortoq',86),(1487,'Qasigiannguit',86),(1488,'Qeqertarsuaq',86),(1489,'Sisimiut',86),(1490,'Udenfor kommunal inddeling',86),(1491,'Upernavik',86),(1492,'Uummannaq',86),(1493,'Carriacou-Petite Martinique',87),(1494,'Saint Andrew',87),(1495,'Saint Davids',87),(1496,'Saint George\'s',87),(1497,'Saint John',87),(1498,'Saint Mark',87),(1499,'Saint Patrick',87),(1500,'Basse-Terre',88),(1501,'Grande-Terre',88),(1502,'Iles des Saintes',88),(1503,'La Desirade',88),(1504,'Marie-Galante',88),(1505,'Saint Barthelemy',88),(1506,'Saint Martin',88),(1507,'Agana Heights',89),(1508,'Agat',89),(1509,'Barrigada',89),(1510,'Chalan-Pago-Ordot',89),(1511,'Dededo',89),(1512,'Hagatna',89),(1513,'Inarajan',89),(1514,'Mangilao',89),(1515,'Merizo',89),(1516,'Mongmong-Toto-Maite',89),(1517,'Santa Rita',89),(1518,'Sinajana',89),(1519,'Talofofo',89),(1520,'Tamuning',89),(1521,'Yigo',89),(1522,'Yona',89),(1523,'Alta Verapaz',90),(1524,'Baja Verapaz',90),(1525,'Chimaltenango',90),(1526,'Chiquimula',90),(1527,'El Progreso',90),(1528,'Escuintla',90),(1529,'Guatemala',90),(1530,'Huehuetenango',90),(1531,'Izabal',90),(1532,'Jalapa',90),(1533,'Jutiapa',90),(1534,'Peten',90),(1535,'Quezaltenango',90),(1536,'Quiche',90),(1537,'Retalhuleu',90),(1538,'Sacatepequez',90),(1539,'San Marcos',90),(1540,'Santa Rosa',90),(1541,'Solola',90),(1542,'Suchitepequez',90),(1543,'Totonicapan',90),(1544,'Zacapa',90),(1545,'Alderney',91),(1546,'Castel',91),(1547,'Forest',91),(1548,'Saint Andrew',91),(1549,'Saint Martin',91),(1550,'Saint Peter Port',91),(1551,'Saint Pierre du Bois',91),(1552,'Saint Sampson',91),(1553,'Saint Saviour',91),(1554,'Sark',91),(1555,'Torteval',91),(1556,'Vale',91),(1557,'Beyla',92),(1558,'Boffa',92),(1559,'Boke',92),(1560,'Conakry',92),(1561,'Coyah',92),(1562,'Dabola',92),(1563,'Dalaba',92),(1564,'Dinguiraye',92),(1565,'Faranah',92),(1566,'Forecariah',92),(1567,'Fria',92),(1568,'Gaoual',92),(1569,'Gueckedou',92),(1570,'Kankan',92),(1571,'Kerouane',92),(1572,'Kindia',92),(1573,'Kissidougou',92),(1574,'Koubia',92),(1575,'Koundara',92),(1576,'Kouroussa',92),(1577,'Labe',92),(1578,'Lola',92),(1579,'Macenta',92),(1580,'Mali',92),(1581,'Mamou',92),(1582,'Mandiana',92),(1583,'Nzerekore',92),(1584,'Pita',92),(1585,'Siguiri',92),(1586,'Telimele',92),(1587,'Tougue',92),(1588,'Yomou',92),(1589,'Bafata',93),(1590,'Bissau',93),(1591,'Bolama',93),(1592,'Cacheu',93),(1593,'Gabu',93),(1594,'Oio',93),(1595,'Quinara',93),(1596,'Tombali',93),(1597,'Barima-Waini',94),(1598,'Cuyuni-Mazaruni',94),(1599,'Demerara-Mahaica',94),(1600,'East Berbice-Corentyne',94),(1601,'Essequibo Islands-West Demerar',94),(1602,'Mahaica-Berbice',94),(1603,'Pomeroon-Supenaam',94),(1604,'Potaro-Siparuni',94),(1605,'Upper Demerara-Berbice',94),(1606,'Upper Takutu-Upper Essequibo',94),(1607,'Artibonite',95),(1608,'Centre',95),(1609,'Grand\'Anse',95),(1610,'Nord',95),(1611,'Nord-Est',95),(1612,'Nord-Ouest',95),(1613,'Ouest',95),(1614,'Sud',95),(1615,'Sud-Est',95),(1616,'Heard and McDonald Islands',96),(1617,'Atlantida',97),(1618,'Choluteca',97),(1619,'Colon',97),(1620,'Comayagua',97),(1621,'Copan',97),(1622,'Cortes',97),(1623,'Distrito Central',97),(1624,'El Paraiso',97),(1625,'Francisco Morazan',97),(1626,'Gracias a Dios',97),(1627,'Intibuca',97),(1628,'Islas de la Bahia',97),(1629,'La Paz',97),(1630,'Lempira',97),(1631,'Ocotepeque',97),(1632,'Olancho',97),(1633,'Santa Barbara',97),(1634,'Valle',97),(1635,'Yoro',97),(1636,'Hong Kong',98),(1637,'Bacs-Kiskun',99),(1638,'Baranya',99),(1639,'Bekes',99),(1640,'Borsod-Abauj-Zemplen',99),(1641,'Budapest',99),(1642,'Csongrad',99),(1643,'Fejer',99),(1644,'Gyor-Moson-Sopron',99),(1645,'Hajdu-Bihar',99),(1646,'Heves',99),(1647,'Jasz-Nagykun-Szolnok',99),(1648,'Komarom-Esztergom',99),(1649,'Nograd',99),(1650,'Pest',99),(1651,'Somogy',99),(1652,'Szabolcs-Szatmar-Bereg',99),(1653,'Tolna',99),(1654,'Vas',99),(1655,'Veszprem',99),(1656,'Zala',99),(1657,'Austurland',100),(1658,'Gullbringusysla',100),(1659,'Hofu borgarsva i',100),(1660,'Nor urland eystra',100),(1661,'Nor urland vestra',100),(1662,'Su urland',100),(1663,'Su urnes',100),(1664,'Vestfir ir',100),(1665,'Vesturland',100),(1666,'Aceh',102),(1667,'Bali',102),(1668,'Bangka-Belitung',102),(1669,'Banten',102),(1670,'Bengkulu',102),(1671,'Gandaria',102),(1672,'Gorontalo',102),(1673,'Jakarta',102),(1674,'Jambi',102),(1675,'Jawa Barat',102),(1676,'Jawa Tengah',102),(1677,'Jawa Timur',102),(1678,'Kalimantan Barat',102),(1679,'Kalimantan Selatan',102),(1680,'Kalimantan Tengah',102),(1681,'Kalimantan Timur',102),(1682,'Kendal',102),(1683,'Lampung',102),(1684,'Maluku',102),(1685,'Maluku Utara',102),(1686,'Nusa Tenggara Barat',102),(1687,'Nusa Tenggara Timur',102),(1688,'Papua',102),(1689,'Riau',102),(1690,'Riau Kepulauan',102),(1691,'Solo',102),(1692,'Sulawesi Selatan',102),(1693,'Sulawesi Tengah',102),(1694,'Sulawesi Tenggara',102),(1695,'Sulawesi Utara',102),(1696,'Sumatera Barat',102),(1697,'Sumatera Selatan',102),(1698,'Sumatera Utara',102),(1699,'Yogyakarta',102),(1700,'Ardabil',103),(1701,'Azarbayjan-e Bakhtari',103),(1702,'Azarbayjan-e Khavari',103),(1703,'Bushehr',103),(1704,'Chahar Mahal-e Bakhtiari',103),(1705,'Esfahan',103),(1706,'Fars',103),(1707,'Gilan',103),(1708,'Golestan',103),(1709,'Hamadan',103),(1710,'Hormozgan',103),(1711,'Ilam',103),(1712,'Kerman',103),(1713,'Kermanshah',103),(1714,'Khorasan',103),(1715,'Khuzestan',103),(1716,'Kohgiluyeh-e Boyerahmad',103),(1717,'Kordestan',103),(1718,'Lorestan',103),(1719,'Markazi',103),(1720,'Mazandaran',103),(1721,'Ostan-e Esfahan',103),(1722,'Qazvin',103),(1723,'Qom',103),(1724,'Semnan',103),(1725,'Sistan-e Baluchestan',103),(1726,'Tehran',103),(1727,'Yazd',103),(1728,'Zanjan',103),(1729,'Babil',104),(1730,'Baghdad',104),(1731,'Dahuk',104),(1732,'Dhi Qar',104),(1733,'Diyala',104),(1734,'Erbil',104),(1735,'Irbil',104),(1736,'Karbala',104),(1737,'Kurdistan',104),(1738,'Maysan',104),(1739,'Ninawa',104),(1740,'Salah-ad-Din',104),(1741,'Wasit',104),(1742,'al-Anbar',104),(1743,'al-Basrah',104),(1744,'al-Muthanna',104),(1745,'al-Qadisiyah',104),(1746,'an-Najaf',104),(1747,'as-Sulaymaniyah',104),(1748,'at-Ta\'mim',104),(1749,'Armagh',105),(1750,'Carlow',105),(1751,'Cavan',105),(1752,'Clare',105),(1753,'Cork',105),(1754,'Donegal',105),(1755,'Dublin',105),(1756,'Galway',105),(1757,'Kerry',105),(1758,'Kildare',105),(1759,'Kilkenny',105),(1760,'Laois',105),(1761,'Leinster',105),(1762,'Leitrim',105),(1763,'Limerick',105),(1764,'Loch Garman',105),(1765,'Longford',105),(1766,'Louth',105),(1767,'Mayo',105),(1768,'Meath',105),(1769,'Monaghan',105),(1770,'Offaly',105),(1771,'Roscommon',105),(1772,'Sligo',105),(1773,'Tipperary North Riding',105),(1774,'Tipperary South Riding',105),(1775,'Ulster',105),(1776,'Waterford',105),(1777,'Westmeath',105),(1778,'Wexford',105),(1779,'Wicklow',105),(1780,'Beit Hanania',106),(1781,'Ben Gurion Airport',106),(1782,'Bethlehem',106),(1783,'Caesarea',106),(1784,'Centre',106),(1785,'Gaza',106),(1786,'Hadaron',106),(1787,'Haifa District',106),(1788,'Hamerkaz',106),(1789,'Hazafon',106),(1790,'Hebron',106),(1791,'Jaffa',106),(1792,'Jerusalem',106),(1793,'Khefa',106),(1794,'Kiryat Yam',106),(1795,'Lower Galilee',106),(1796,'Qalqilya',106),(1797,'Talme Elazar',106),(1798,'Tel Aviv',106),(1799,'Tsafon',106),(1800,'Umm El Fahem',106),(1801,'Yerushalayim',106),(1802,'Abruzzi',107),(1803,'Abruzzo',107),(1804,'Agrigento',107),(1805,'Alessandria',107),(1806,'Ancona',107),(1807,'Arezzo',107),(1808,'Ascoli Piceno',107),(1809,'Asti',107),(1810,'Avellino',107),(1811,'Bari',107),(1812,'Basilicata',107),(1813,'Belluno',107),(1814,'Benevento',107),(1815,'Bergamo',107),(1816,'Biella',107),(1817,'Bologna',107),(1818,'Bolzano',107),(1819,'Brescia',107),(1820,'Brindisi',107),(1821,'Calabria',107),(1822,'Campania',107),(1823,'Cartoceto',107),(1824,'Caserta',107),(1825,'Catania',107),(1826,'Chieti',107),(1827,'Como',107),(1828,'Cosenza',107),(1829,'Cremona',107),(1830,'Cuneo',107),(1831,'Emilia-Romagna',107),(1832,'Ferrara',107),(1833,'Firenze',107),(1834,'Florence',107),(1835,'Forli-Cesena ',107),(1836,'Friuli-Venezia Giulia',107),(1837,'Frosinone',107),(1838,'Genoa',107),(1839,'Gorizia',107),(1840,'L\'Aquila',107),(1841,'Lazio',107),(1842,'Lecce',107),(1843,'Lecco',107),(1845,'Liguria',107),(1846,'Lodi',107),(1847,'Lombardia',107),(1848,'Lombardy',107),(1849,'Macerata',107),(1850,'Mantova',107),(1851,'Marche',107),(1852,'Messina',107),(1853,'Milan',107),(1854,'Modena',107),(1855,'Molise',107),(1856,'Molteno',107),(1857,'Montenegro',107),(1858,'Monza and Brianza',107),(1859,'Naples',107),(1860,'Novara',107),(1861,'Padova',107),(1862,'Parma',107),(1863,'Pavia',107),(1864,'Perugia',107),(1865,'Pesaro-Urbino',107),(1866,'Piacenza',107),(1867,'Piedmont',107),(1868,'Piemonte',107),(1869,'Pisa',107),(1870,'Pordenone',107),(1871,'Potenza',107),(1872,'Puglia',107),(1873,'Reggio Emilia',107),(1874,'Rimini',107),(1875,'Roma',107),(1876,'Salerno',107),(1877,'Sardegna',107),(1878,'Sassari',107),(1879,'Savona',107),(1880,'Sicilia',107),(1881,'Siena',107),(1882,'Sondrio',107),(1883,'South Tyrol',107),(1884,'Taranto',107),(1885,'Teramo',107),(1886,'Torino',107),(1887,'Toscana',107),(1888,'Trapani',107),(1889,'Trentino-Alto Adige',107),(1890,'Trento',107),(1891,'Treviso',107),(1892,'Udine',107),(1893,'Umbria',107),(1894,'Valle d\'Aosta',107),(1895,'Varese',107),(1896,'Veneto',107),(1897,'Venezia',107),(1898,'Verbano-Cusio-Ossola',107),(1899,'Vercelli',107),(1900,'Verona',107),(1901,'Vicenza',107),(1902,'Viterbo',107),(1903,'Buxoro Viloyati',108),(1904,'Clarendon',108),(1905,'Hanover',108),(1906,'Kingston',108),(1907,'Manchester',108),(1908,'Portland',108),(1909,'Saint Andrews',108),(1910,'Saint Ann',108),(1911,'Saint Catherine',108),(1912,'Saint Elizabeth',108),(1913,'Saint James',108),(1914,'Saint Mary',108),(1915,'Saint Thomas',108),(1916,'Trelawney',108),(1917,'Westmoreland',108),(1918,'Aichi',109),(1919,'Akita',109),(1920,'Aomori',109),(1921,'Chiba',109),(1922,'Ehime',109),(1923,'Fukui',109),(1924,'Fukuoka',109),(1925,'Fukushima',109),(1926,'Gifu',109),(1927,'Gumma',109),(1928,'Hiroshima',109),(1929,'Hokkaido',109),(1930,'Hyogo',109),(1931,'Ibaraki',109),(1932,'Ishikawa',109),(1933,'Iwate',109),(1934,'Kagawa',109),(1935,'Kagoshima',109),(1936,'Kanagawa',109),(1937,'Kanto',109),(1938,'Kochi',109),(1939,'Kumamoto',109),(1940,'Kyoto',109),(1941,'Mie',109),(1942,'Miyagi',109),(1943,'Miyazaki',109),(1944,'Nagano',109),(1945,'Nagasaki',109),(1946,'Nara',109),(1947,'Niigata',109),(1948,'Oita',109),(1949,'Okayama',109),(1950,'Okinawa',109),(1951,'Osaka',109),(1952,'Saga',109),(1953,'Saitama',109),(1954,'Shiga',109),(1955,'Shimane',109),(1956,'Shizuoka',109),(1957,'Tochigi',109),(1958,'Tokushima',109),(1959,'Tokyo',109),(1960,'Tottori',109),(1961,'Toyama',109),(1962,'Wakayama',109),(1963,'Yamagata',109),(1964,'Yamaguchi',109),(1965,'Yamanashi',109),(1966,'Grouville',110),(1967,'Saint Brelade',110),(1968,'Saint Clement',110),(1969,'Saint Helier',110),(1970,'Saint John',110),(1971,'Saint Lawrence',110),(1972,'Saint Martin',110),(1973,'Saint Mary',110),(1974,'Saint Peter',110),(1975,'Saint Saviour',110),(1976,'Trinity',110),(1977,'\'Ajlun',111),(1978,'Amman',111),(1979,'Irbid',111),(1980,'Jarash',111),(1981,'Ma\'an',111),(1982,'Madaba',111),(1983,'al-\'Aqabah',111),(1984,'al-Balqa\'',111),(1985,'al-Karak',111),(1986,'al-Mafraq',111),(1987,'at-Tafilah',111),(1988,'az-Zarqa\'',111),(1989,'Akmecet',112),(1990,'Akmola',112),(1991,'Aktobe',112),(1992,'Almati',112),(1993,'Atirau',112),(1994,'Batis Kazakstan',112),(1995,'Burlinsky Region',112),(1996,'Karagandi',112),(1997,'Kostanay',112),(1998,'Mankistau',112),(1999,'Ontustik Kazakstan',112),(2000,'Pavlodar',112),(2001,'Sigis Kazakstan',112),(2002,'Soltustik Kazakstan',112),(2003,'Taraz',112),(2004,'Central',113),(2005,'Coast',113),(2006,'Eastern',113),(2007,'Nairobi',113),(2008,'North Eastern',113),(2009,'Nyanza',113),(2010,'Rift Valley',113),(2011,'Western',113),(2012,'Abaiang',114),(2013,'Abemana',114),(2014,'Aranuka',114),(2015,'Arorae',114),(2016,'Banaba',114),(2017,'Beru',114),(2018,'Butaritari',114),(2019,'Kiritimati',114),(2020,'Kuria',114),(2021,'Maiana',114),(2022,'Makin',114),(2023,'Marakei',114),(2024,'Nikunau',114),(2025,'Nonouti',114),(2026,'Onotoa',114),(2027,'Phoenix Islands',114),(2028,'Tabiteuea North',114),(2029,'Tabiteuea South',114),(2030,'Tabuaeran',114),(2031,'Tamana',114),(2032,'Tarawa North',114),(2033,'Tarawa South',114),(2034,'Teraina',114),(2035,'Chagangdo',115),(2036,'Hamgyeongbukto',115),(2037,'Hamgyeongnamdo',115),(2038,'Hwanghaebukto',115),(2039,'Hwanghaenamdo',115),(2040,'Kaeseong',115),(2041,'Kangweon',115),(2042,'Nampo',115),(2043,'Pyeonganbukto',115),(2044,'Pyeongannamdo',115),(2045,'Pyeongyang',115),(2046,'Yanggang',115),(2047,'Busan',116),(2048,'Cheju',116),(2049,'Chollabuk',116),(2050,'Chollanam',116),(2051,'Chungbuk',116),(2052,'Chungcheongbuk',116),(2053,'Chungcheongnam',116),(2054,'Chungnam',116),(2055,'Daegu',116),(2056,'Gangwon-do',116),(2057,'Goyang-si',116),(2058,'Gyeonggi-do',116),(2059,'Gyeongsang ',116),(2060,'Gyeongsangnam-do',116),(2061,'Incheon',116),(2062,'Jeju-Si',116),(2063,'Jeonbuk',116),(2064,'Kangweon',116),(2065,'Kwangju',116),(2066,'Kyeonggi',116),(2067,'Kyeongsangbuk',116),(2068,'Kyeongsangnam',116),(2069,'Kyonggi-do',116),(2070,'Kyungbuk-Do',116),(2071,'Kyunggi-Do',116),(2072,'Kyunggi-do',116),(2073,'Pusan',116),(2074,'Seoul',116),(2075,'Sudogwon',116),(2076,'Taegu',116),(2077,'Taejeon',116),(2078,'Taejon-gwangyoksi',116),(2079,'Ulsan',116),(2080,'Wonju',116),(2081,'gwangyoksi',116),(2082,'Al Asimah',117),(2083,'Hawalli',117),(2084,'Mishref',117),(2085,'Qadesiya',117),(2086,'Safat',117),(2087,'Salmiya',117),(2088,'al-Ahmadi',117),(2089,'al-Farwaniyah',117),(2090,'al-Jahra',117),(2091,'al-Kuwayt',117),(2092,'Batken',118),(2093,'Bishkek',118),(2094,'Chui',118),(2095,'Issyk-Kul',118),(2096,'Jalal-Abad',118),(2097,'Naryn',118),(2098,'Osh',118),(2099,'Talas',118),(2100,'Attopu',119),(2101,'Bokeo',119),(2102,'Bolikhamsay',119),(2103,'Champasak',119),(2104,'Houaphanh',119),(2105,'Khammouane',119),(2106,'Luang Nam Tha',119),(2107,'Luang Prabang',119),(2108,'Oudomxay',119),(2109,'Phongsaly',119),(2110,'Saravan',119),(2111,'Savannakhet',119),(2112,'Sekong',119),(2113,'Viangchan Prefecture',119),(2114,'Viangchan Province',119),(2115,'Xaignabury',119),(2116,'Xiang Khuang',119),(2117,'Aizkraukles',120),(2118,'Aluksnes',120),(2119,'Balvu',120),(2120,'Bauskas',120),(2121,'Cesu',120),(2122,'Daugavpils',120),(2123,'Daugavpils City',120),(2124,'Dobeles',120),(2125,'Gulbenes',120),(2126,'Jekabspils',120),(2127,'Jelgava',120),(2128,'Jelgavas',120),(2129,'Jurmala City',120),(2130,'Kraslavas',120),(2131,'Kuldigas',120),(2132,'Liepaja',120),(2133,'Liepajas',120),(2134,'Limbazhu',120),(2135,'Ludzas',120),(2136,'Madonas',120),(2137,'Ogres',120),(2138,'Preilu',120),(2139,'Rezekne',120),(2140,'Rezeknes',120),(2141,'Riga',120),(2142,'Rigas',120),(2143,'Saldus',120),(2144,'Talsu',120),(2145,'Tukuma',120),(2146,'Valkas',120),(2147,'Valmieras',120),(2148,'Ventspils',120),(2149,'Ventspils City',120),(2150,'Beirut',121),(2151,'Jabal Lubnan',121),(2152,'Mohafazat Liban-Nord',121),(2153,'Mohafazat Mont-Liban',121),(2154,'Sidon',121),(2155,'al-Biqa',121),(2156,'al-Janub',121),(2157,'an-Nabatiyah',121),(2158,'ash-Shamal',121),(2159,'Berea',122),(2160,'Butha-Buthe',122),(2161,'Leribe',122),(2162,'Mafeteng',122),(2163,'Maseru',122),(2164,'Mohale\'s Hoek',122),(2165,'Mokhotlong',122),(2166,'Qacha\'s Nek',122),(2167,'Quthing',122),(2168,'Thaba-Tseka',122),(2169,'Bomi',123),(2170,'Bong',123),(2171,'Grand Bassa',123),(2172,'Grand Cape Mount',123),(2173,'Grand Gedeh',123),(2174,'Loffa',123),(2175,'Margibi',123),(2176,'Maryland and Grand Kru',123),(2177,'Montserrado',123),(2178,'Nimba',123),(2179,'Rivercess',123),(2180,'Sinoe',123),(2181,'Ajdabiya',124),(2182,'Fezzan',124),(2183,'Banghazi',124),(2184,'Darnah',124),(2185,'Ghadamis',124),(2186,'Gharyan',124),(2187,'Misratah',124),(2188,'Murzuq',124),(2189,'Sabha',124),(2190,'Sawfajjin',124),(2191,'Surt',124),(2192,'Tarabulus',124),(2193,'Tarhunah',124),(2194,'Tripolitania',124),(2195,'Tubruq',124),(2196,'Yafran',124),(2197,'Zlitan',124),(2198,'al-\'Aziziyah',124),(2199,'al-Fatih',124),(2200,'al-Jabal al Akhdar',124),(2201,'al-Jufrah',124),(2202,'al-Khums',124),(2203,'al-Kufrah',124),(2204,'an-Nuqat al-Khams',124),(2205,'ash-Shati\'',124),(2206,'az-Zawiyah',124),(2207,'Balzers',125),(2208,'Eschen',125),(2209,'Gamprin',125),(2210,'Mauren',125),(2211,'Planken',125),(2212,'Ruggell',125),(2213,'Schaan',125),(2214,'Schellenberg',125),(2215,'Triesen',125),(2216,'Triesenberg',125),(2217,'Vaduz',125),(2218,'Alytaus',126),(2219,'Anyksciai',126),(2220,'Kauno',126),(2221,'Klaipedos',126),(2222,'Marijampoles',126),(2223,'Panevezhio',126),(2224,'Panevezys',126),(2225,'Shiauliu',126),(2226,'Taurages',126),(2227,'Telshiu',126),(2228,'Telsiai',126),(2229,'Utenos',126),(2230,'Vilniaus',126),(2231,'Capellen',127),(2232,'Clervaux',127),(2233,'Diekirch',127),(2234,'Echternach',127),(2235,'Esch-sur-Alzette',127),(2236,'Grevenmacher',127),(2237,'Luxembourg',127),(2238,'Mersch',127),(2239,'Redange',127),(2240,'Remich',127),(2241,'Vianden',127),(2242,'Wiltz',127),(2243,'Macau',128),(2244,'Berovo',129),(2245,'Bitola',129),(2246,'Brod',129),(2247,'Debar',129),(2248,'Delchevo',129),(2249,'Demir Hisar',129),(2250,'Gevgelija',129),(2251,'Gostivar',129),(2252,'Kavadarci',129),(2253,'Kichevo',129),(2254,'Kochani',129),(2255,'Kratovo',129),(2256,'Kriva Palanka',129),(2257,'Krushevo',129),(2258,'Kumanovo',129),(2259,'Negotino',129),(2260,'Ohrid',129),(2261,'Prilep',129),(2262,'Probishtip',129),(2263,'Radovish',129),(2264,'Resen',129),(2265,'Shtip',129),(2266,'Skopje',129),(2267,'Struga',129),(2268,'Strumica',129),(2269,'Sveti Nikole',129),(2270,'Tetovo',129),(2271,'Valandovo',129),(2272,'Veles',129),(2273,'Vinica',129),(2274,'Antananarivo',130),(2275,'Antsiranana',130),(2276,'Fianarantsoa',130),(2277,'Mahajanga',130),(2278,'Toamasina',130),(2279,'Toliary',130),(2280,'Balaka',131),(2281,'Blantyre City',131),(2282,'Chikwawa',131),(2283,'Chiradzulu',131),(2284,'Chitipa',131),(2285,'Dedza',131),(2286,'Dowa',131),(2287,'Karonga',131),(2288,'Kasungu',131),(2289,'Lilongwe City',131),(2290,'Machinga',131),(2291,'Mangochi',131),(2292,'Mchinji',131),(2293,'Mulanje',131),(2294,'Mwanza',131),(2295,'Mzimba',131),(2296,'Mzuzu City',131),(2297,'Nkhata Bay',131),(2298,'Nkhotakota',131),(2299,'Nsanje',131),(2300,'Ntcheu',131),(2301,'Ntchisi',131),(2302,'Phalombe',131),(2303,'Rumphi',131),(2304,'Salima',131),(2305,'Thyolo',131),(2306,'Zomba Municipality',131),(2307,'Johor',132),(2308,'Kedah',132),(2309,'Kelantan',132),(2310,'Kuala Lumpur',132),(2311,'Labuan',132),(2312,'Melaka',132),(2313,'Negeri Johor',132),(2314,'Negeri Sembilan',132),(2315,'Pahang',132),(2316,'Penang',132),(2317,'Perak',132),(2318,'Perlis',132),(2319,'Pulau Pinang',132),(2320,'Sabah',132),(2321,'Sarawak',132),(2322,'Selangor',132),(2323,'Sembilan',132),(2324,'Terengganu',132),(2325,'Alif Alif',133),(2326,'Alif Dhaal',133),(2327,'Baa',133),(2328,'Dhaal',133),(2329,'Faaf',133),(2330,'Gaaf Alif',133),(2331,'Gaaf Dhaal',133),(2332,'Ghaviyani',133),(2333,'Haa Alif',133),(2334,'Haa Dhaal',133),(2335,'Kaaf',133),(2336,'Laam',133),(2337,'Lhaviyani',133),(2338,'Male',133),(2339,'Miim',133),(2340,'Nuun',133),(2341,'Raa',133),(2342,'Shaviyani',133),(2343,'Siin',133),(2344,'Thaa',133),(2345,'Vaav',133),(2346,'Bamako',134),(2347,'Gao',134),(2348,'Kayes',134),(2349,'Kidal',134),(2350,'Koulikoro',134),(2351,'Mopti',134),(2352,'Segou',134),(2353,'Sikasso',134),(2354,'Tombouctou',134),(2355,'Gozo and Comino',135),(2356,'Inner Harbour',135),(2357,'Northern',135),(2358,'Outer Harbour',135),(2359,'South Eastern',135),(2360,'Valletta',135),(2361,'Western',135),(2362,'Castletown',136),(2363,'Douglas',136),(2364,'Laxey',136),(2365,'Onchan',136),(2366,'Peel',136),(2367,'Port Erin',136),(2368,'Port Saint Mary',136),(2369,'Ramsey',136),(2370,'Ailinlaplap',137),(2371,'Ailuk',137),(2372,'Arno',137),(2373,'Aur',137),(2374,'Bikini',137),(2375,'Ebon',137),(2376,'Enewetak',137),(2377,'Jabat',137),(2378,'Jaluit',137),(2379,'Kili',137),(2380,'Kwajalein',137),(2381,'Lae',137),(2382,'Lib',137),(2383,'Likiep',137),(2384,'Majuro',137),(2385,'Maloelap',137),(2386,'Mejit',137),(2387,'Mili',137),(2388,'Namorik',137),(2389,'Namu',137),(2390,'Rongelap',137),(2391,'Ujae',137),(2392,'Utrik',137),(2393,'Wotho',137),(2394,'Wotje',137),(2395,'Fort-de-France',138),(2396,'La Trinite',138),(2397,'Le Marin',138),(2398,'Saint-Pierre',138),(2399,'Adrar',139),(2400,'Assaba',139),(2401,'Brakna',139),(2402,'Dhakhlat Nawadibu',139),(2403,'Hudh-al-Gharbi',139),(2404,'Hudh-ash-Sharqi',139),(2405,'Inshiri',139),(2406,'Nawakshut',139),(2407,'Qidimagha',139),(2408,'Qurqul',139),(2409,'Taqant',139),(2410,'Tiris Zammur',139),(2411,'Trarza',139),(2412,'Black River',140),(2413,'Eau Coulee',140),(2414,'Flacq',140),(2415,'Floreal',140),(2416,'Grand Port',140),(2417,'Moka',140),(2418,'Pamplempousses',140),(2419,'Plaines Wilhelm',140),(2420,'Port Louis',140),(2421,'Riviere du Rempart',140),(2422,'Rodrigues',140),(2423,'Rose Hill',140),(2424,'Savanne',140),(2425,'Mayotte',141),(2426,'Pamanzi',141),(2427,'Aguascalientes',142),(2428,'Baja California',142),(2429,'Baja California Sur',142),(2430,'Campeche',142),(2431,'Chiapas',142),(2432,'Chihuahua',142),(2433,'Coahuila',142),(2434,'Colima',142),(2435,'Distrito Federal',142),(2436,'Durango',142),(2437,'Estado de Mexico',142),(2438,'Guanajuato',142),(2439,'Guerrero',142),(2440,'Hidalgo',142),(2441,'Jalisco',142),(2442,'Mexico',142),(2443,'Michoacan',142),(2444,'Morelos',142),(2445,'Nayarit',142),(2446,'Nuevo Leon',142),(2447,'Oaxaca',142),(2448,'Puebla',142),(2449,'Queretaro',142),(2450,'Quintana Roo',142),(2451,'San Luis Potosi',142),(2452,'Sinaloa',142),(2453,'Sonora',142),(2454,'Tabasco',142),(2455,'Tamaulipas',142),(2456,'Tlaxcala',142),(2457,'Veracruz',142),(2458,'Yucatan',142),(2459,'Zacatecas',142),(2460,'Chuuk',143),(2461,'Kusaie',143),(2462,'Pohnpei',143),(2463,'Yap',143),(2464,'Balti',144),(2465,'Cahul',144),(2466,'Chisinau',144),(2467,'Chisinau Oras',144),(2468,'Edinet',144),(2469,'Gagauzia',144),(2470,'Lapusna',144),(2471,'Orhei',144),(2472,'Soroca',144),(2473,'Taraclia',144),(2474,'Tighina',144),(2475,'Transnistria',144),(2476,'Ungheni',144),(2477,'Fontvieille',145),(2478,'La Condamine',145),(2479,'Monaco-Ville',145),(2480,'Monte Carlo',145),(2481,'Arhangaj',146),(2482,'Bajan-Olgij',146),(2483,'Bajanhongor',146),(2484,'Bulgan',146),(2485,'Darhan-Uul',146),(2486,'Dornod',146),(2487,'Dornogovi',146),(2488,'Dundgovi',146),(2489,'Govi-Altaj',146),(2490,'Govisumber',146),(2491,'Hentij',146),(2492,'Hovd',146),(2493,'Hovsgol',146),(2494,'Omnogovi',146),(2495,'Orhon',146),(2496,'Ovorhangaj',146),(2497,'Selenge',146),(2498,'Suhbaatar',146),(2499,'Tov',146),(2500,'Ulaanbaatar',146),(2501,'Uvs',146),(2502,'Zavhan',146),(2503,'Montserrat',147),(2504,'Agadir',148),(2505,'Casablanca',148),(2506,'Chaouia-Ouardigha',148),(2507,'Doukkala-Abda',148),(2508,'Fes-Boulemane',148),(2509,'Gharb-Chrarda-Beni Hssen',148),(2510,'Guelmim',148),(2511,'Kenitra',148),(2512,'Marrakech-Tensift-Al Haouz',148),(2513,'Meknes-Tafilalet',148),(2514,'Oriental',148),(2515,'Oujda',148),(2516,'Province de Tanger',148),(2517,'Rabat-Sale-Zammour-Zaer',148),(2518,'Sala Al Jadida',148),(2519,'Settat',148),(2520,'Souss Massa-Draa',148),(2521,'Tadla-Azilal',148),(2522,'Tangier-Tetouan',148),(2523,'Taza-Al Hoceima-Taounate',148),(2524,'Wilaya de Casablanca',148),(2525,'Wilaya de Rabat-Sale',148),(2526,'Cabo Delgado',149),(2527,'Gaza',149),(2528,'Inhambane',149),(2529,'Manica',149),(2530,'Maputo',149),(2531,'Maputo Provincia',149),(2532,'Nampula',149),(2533,'Niassa',149),(2534,'Sofala',149),(2535,'Tete',149),(2536,'Zambezia',149),(2537,'Ayeyarwady',150),(2538,'Bago',150),(2539,'Chin',150),(2540,'Kachin',150),(2541,'Kayah',150),(2542,'Kayin',150),(2543,'Magway',150),(2544,'Mandalay',150),(2545,'Mon',150),(2546,'Nay Pyi Taw',150),(2547,'Rakhine',150),(2548,'Sagaing',150),(2549,'Shan',150),(2550,'Tanintharyi',150),(2551,'Yangon',150),(2552,'Caprivi',151),(2553,'Erongo',151),(2554,'Hardap',151),(2555,'Karas',151),(2556,'Kavango',151),(2557,'Khomas',151),(2558,'Kunene',151),(2559,'Ohangwena',151),(2560,'Omaheke',151),(2561,'Omusati',151),(2562,'Oshana',151),(2563,'Oshikoto',151),(2564,'Otjozondjupa',151),(2565,'Yaren',152),(2566,'Bagmati',153),(2567,'Bheri',153),(2568,'Dhawalagiri',153),(2569,'Gandaki',153),(2570,'Janakpur',153),(2571,'Karnali',153),(2572,'Koshi',153),(2573,'Lumbini',153),(2574,'Mahakali',153),(2575,'Mechi',153),(2576,'Narayani',153),(2577,'Rapti',153),(2578,'Sagarmatha',153),(2579,'Seti',153),(2580,'Bonaire',154),(2581,'Curacao',154),(2582,'Saba',154),(2583,'Sint Eustatius',154),(2584,'Sint Maarten',154),(2585,'Amsterdam',155),(2586,'Benelux',155),(2587,'Drenthe',155),(2588,'Flevoland',155),(2589,'Friesland',155),(2590,'Gelderland',155),(2591,'Groningen',155),(2592,'Limburg',155),(2593,'Noord-Brabant',155),(2594,'Noord-Holland',155),(2595,'Overijssel',155),(2596,'South Holland',155),(2597,'Utrecht',155),(2598,'Zeeland',155),(2599,'Zuid-Holland',155),(2600,'Iles',156),(2601,'Nord',156),(2602,'Sud',156),(2603,'Area Outside Region',157),(2604,'Auckland',157),(2605,'Bay of Plenty',157),(2606,'Canterbury',157),(2607,'Christchurch',157),(2608,'Gisborne',157),(2609,'Hawke\'s Bay',157),(2610,'Manawatu-Wanganui',157),(2611,'Marlborough',157),(2612,'Nelson',157),(2613,'Northland',157),(2614,'Otago',157),(2615,'Rodney',157),(2616,'Southland',157),(2617,'Taranaki',157),(2618,'Tasman',157),(2619,'Waikato',157),(2620,'Wellington',157),(2621,'West Coast',157),(2622,'Atlantico Norte',158),(2623,'Atlantico Sur',158),(2624,'Boaco',158),(2625,'Carazo',158),(2626,'Chinandega',158),(2627,'Chontales',158),(2628,'Esteli',158),(2629,'Granada',158),(2630,'Jinotega',158),(2631,'Leon',158),(2632,'Madriz',158),(2633,'Managua',158),(2634,'Masaya',158),(2635,'Matagalpa',158),(2636,'Nueva Segovia',158),(2637,'Rio San Juan',158),(2638,'Rivas',158),(2639,'Agadez',159),(2640,'Diffa',159),(2641,'Dosso',159),(2642,'Maradi',159),(2643,'Niamey',159),(2644,'Tahoua',159),(2645,'Tillabery',159),(2646,'Zinder',159),(2647,'Abia',160),(2648,'Abuja Federal Capital Territor',160),(2649,'Adamawa',160),(2650,'Akwa Ibom',160),(2651,'Anambra',160),(2652,'Bauchi',160),(2653,'Bayelsa',160),(2654,'Benue',160),(2655,'Borno',160),(2656,'Cross River',160),(2657,'Delta',160),(2658,'Ebonyi',160),(2659,'Edo',160),(2660,'Ekiti',160),(2661,'Enugu',160),(2662,'Gombe',160),(2663,'Imo',160),(2664,'Jigawa',160),(2665,'Kaduna',160),(2666,'Kano',160),(2667,'Katsina',160),(2668,'Kebbi',160),(2669,'Kogi',160),(2670,'Kwara',160),(2671,'Lagos',160),(2672,'Nassarawa',160),(2673,'Niger',160),(2674,'Ogun',160),(2675,'Ondo',160),(2676,'Osun',160),(2677,'Oyo',160),(2678,'Plateau',160),(2679,'Rivers',160),(2680,'Sokoto',160),(2681,'Taraba',160),(2682,'Yobe',160),(2683,'Zamfara',160),(2684,'Niue',161),(2685,'Norfolk Island',162),(2686,'Northern Islands',163),(2687,'Rota',163),(2688,'Saipan',163),(2689,'Tinian',163),(2690,'Akershus',164),(2691,'Aust Agder',164),(2692,'Bergen',164),(2693,'Buskerud',164),(2694,'Finnmark',164),(2695,'Hedmark',164),(2696,'Hordaland',164),(2697,'Moere og Romsdal',164),(2698,'Nord Trondelag',164),(2699,'Nordland',164),(2700,'Oestfold',164),(2701,'Oppland',164),(2702,'Oslo',164),(2703,'Rogaland',164),(2704,'Soer Troendelag',164),(2705,'Sogn og Fjordane',164),(2706,'Stavern',164),(2707,'Sykkylven',164),(2708,'Telemark',164),(2709,'Troms',164),(2710,'Vest Agder',164),(2711,'Vestfold',164),(2712,'ÃÂ˜stfold',164),(2713,'Al Buraimi',165),(2714,'Dhufar',165),(2715,'Masqat',165),(2716,'Musandam',165),(2717,'Rusayl',165),(2718,'Wadi Kabir',165),(2719,'ad-Dakhiliyah',165),(2720,'adh-Dhahirah',165),(2721,'al-Batinah',165),(2722,'ash-Sharqiyah',165),(2723,'Baluchistan',166),(2724,'Federal Capital Area',166),(2725,'Federally administered Tribal ',166),(2726,'North-West Frontier',166),(2727,'Northern Areas',166),(2728,'Punjab',166),(2729,'Sind',166),(2730,'Aimeliik',167),(2731,'Airai',167),(2732,'Angaur',167),(2733,'Hatobohei',167),(2734,'Kayangel',167),(2735,'Koror',167),(2736,'Melekeok',167),(2737,'Ngaraard',167),(2738,'Ngardmau',167),(2739,'Ngaremlengui',167),(2740,'Ngatpang',167),(2741,'Ngchesar',167),(2742,'Ngerchelong',167),(2743,'Ngiwal',167),(2744,'Peleliu',167),(2745,'Sonsorol',167),(2746,'Ariha',168),(2747,'Bayt Lahm',168),(2748,'Bethlehem',168),(2749,'Dayr-al-Balah',168),(2750,'Ghazzah',168),(2751,'Ghazzah ash-Shamaliyah',168),(2752,'Janin',168),(2753,'Khan Yunis',168),(2754,'Nabulus',168),(2755,'Qalqilyah',168),(2756,'Rafah',168),(2757,'Ram Allah wal-Birah',168),(2758,'Salfit',168),(2759,'Tubas',168),(2760,'Tulkarm',168),(2761,'al-Khalil',168),(2762,'al-Quds',168),(2763,'Bocas del Toro',169),(2764,'Chiriqui',169),(2765,'Cocle',169),(2766,'Colon',169),(2767,'Darien',169),(2768,'Embera',169),(2769,'Herrera',169),(2770,'Kuna Yala',169),(2771,'Los Santos',169),(2772,'Ngobe Bugle',169),(2773,'Panama',169),(2774,'Veraguas',169),(2775,'East New Britain',170),(2776,'East Sepik',170),(2777,'Eastern Highlands',170),(2778,'Enga',170),(2779,'Fly River',170),(2780,'Gulf',170),(2781,'Madang',170),(2782,'Manus',170),(2783,'Milne Bay',170),(2784,'Morobe',170),(2785,'National Capital District',170),(2786,'New Ireland',170),(2787,'North Solomons',170),(2788,'Oro',170),(2789,'Sandaun',170),(2790,'Simbu',170),(2791,'Southern Highlands',170),(2792,'West New Britain',170),(2793,'Western Highlands',170),(2794,'Alto Paraguay',171),(2795,'Alto Parana',171),(2796,'Amambay',171),(2797,'Asuncion',171),(2798,'Boqueron',171),(2799,'Caaguazu',171),(2800,'Caazapa',171),(2801,'Canendiyu',171),(2802,'Central',171),(2803,'Concepcion',171),(2804,'Cordillera',171),(2805,'Guaira',171),(2806,'Itapua',171),(2807,'Misiones',171),(2808,'Neembucu',171),(2809,'Paraguari',171),(2810,'Presidente Hayes',171),(2811,'San Pedro',171),(2812,'Amazonas',172),(2813,'Ancash',172),(2814,'Apurimac',172),(2815,'Arequipa',172),(2816,'Ayacucho',172),(2817,'Cajamarca',172),(2818,'Cusco',172),(2819,'Huancavelica',172),(2820,'Huanuco',172),(2821,'Ica',172),(2822,'Junin',172),(2823,'La Libertad',172),(2824,'Lambayeque',172),(2825,'Lima y Callao',172),(2826,'Loreto',172),(2827,'Madre de Dios',172),(2828,'Moquegua',172),(2829,'Pasco',172),(2830,'Piura',172),(2831,'Puno',172),(2832,'San Martin',172),(2833,'Tacna',172),(2834,'Tumbes',172),(2835,'Ucayali',172),(2836,'Batangas',173),(2837,'Bicol',173),(2838,'Bulacan',173),(2839,'Cagayan',173),(2840,'Caraga',173),(2841,'Central Luzon',173),(2842,'Central Mindanao',173),(2843,'Central Visayas',173),(2844,'Cordillera',173),(2845,'Davao',173),(2846,'Eastern Visayas',173),(2847,'Greater Metropolitan Area',173),(2848,'Ilocos',173),(2849,'Laguna',173),(2850,'Luzon',173),(2851,'Mactan',173),(2852,'Metropolitan Manila Area',173),(2853,'Muslim Mindanao',173),(2854,'Northern Mindanao',173),(2855,'Southern Mindanao',173),(2856,'Southern Tagalog',173),(2857,'Western Mindanao',173),(2858,'Western Visayas',173),(2859,'Pitcairn Island',174),(2860,'Biale Blota',175),(2861,'Dobroszyce',175),(2862,'Dolnoslaskie',175),(2863,'Dziekanow Lesny',175),(2864,'Hopowo',175),(2865,'Kartuzy',175),(2866,'Koscian',175),(2867,'Krakow',175),(2868,'Kujawsko-Pomorskie',175),(2869,'Lodzkie',175),(2870,'Lubelskie',175),(2871,'Lubuskie',175),(2872,'Malomice',175),(2873,'Malopolskie',175),(2874,'Mazowieckie',175),(2875,'Mirkow',175),(2876,'Opolskie',175),(2877,'Ostrowiec',175),(2878,'Podkarpackie',175),(2879,'Podlaskie',175),(2880,'Polska',175),(2881,'Pomorskie',175),(2882,'Poznan',175),(2883,'Pruszkow',175),(2884,'Rymanowska',175),(2885,'Rzeszow',175),(2886,'Slaskie',175),(2887,'Stare Pole',175),(2888,'Swietokrzyskie',175),(2889,'Warminsko-Mazurskie',175),(2890,'Warsaw',175),(2891,'Wejherowo',175),(2892,'Wielkopolskie',175),(2893,'Wroclaw',175),(2894,'Zachodnio-Pomorskie',175),(2895,'Zukowo',175),(2896,'Abrantes',176),(2897,'Acores',176),(2898,'Alentejo',176),(2899,'Algarve',176),(2900,'Braga',176),(2901,'Centro',176),(2902,'Distrito de Leiria',176),(2903,'Distrito de Viana do Castelo',176),(2904,'Distrito de Vila Real',176),(2905,'Distrito do Porto',176),(2906,'Lisboa e Vale do Tejo',176),(2907,'Madeira',176),(2908,'Norte',176),(2909,'Paivas',176),(2910,'Arecibo',177),(2911,'Bayamon',177),(2912,'Carolina',177),(2913,'Florida',177),(2914,'Guayama',177),(2915,'Humacao',177),(2916,'Mayaguez-Aguadilla',177),(2917,'Ponce',177),(2918,'Salinas',177),(2919,'San Juan',177),(2920,'Doha',178),(2921,'Jarian-al-Batnah',178),(2922,'Umm Salal',178),(2923,'ad-Dawhah',178),(2924,'al-Ghuwayriyah',178),(2925,'al-Jumayliyah',178),(2926,'al-Khawr',178),(2927,'al-Wakrah',178),(2928,'ar-Rayyan',178),(2929,'ash-Shamal',178),(2930,'Saint-Benoit',179),(2931,'Saint-Denis',179),(2932,'Saint-Paul',179),(2933,'Saint-Pierre',179),(2934,'Alba',180),(2935,'Arad',180),(2936,'Arges',180),(2937,'Bacau',180),(2938,'Bihor',180),(2939,'Bistrita-Nasaud',180),(2940,'Botosani',180),(2941,'Braila',180),(2942,'Brasov',180),(2943,'Bucuresti',180),(2944,'Buzau',180),(2945,'Calarasi',180),(2946,'Caras-Severin',180),(2947,'Cluj',180),(2948,'Constanta',180),(2949,'Covasna',180),(2950,'Dambovita',180),(2951,'Dolj',180),(2952,'Galati',180),(2953,'Giurgiu',180),(2954,'Gorj',180),(2955,'Harghita',180),(2956,'Hunedoara',180),(2957,'Ialomita',180),(2958,'Iasi',180),(2959,'Ilfov',180),(2960,'Maramures',180),(2961,'Mehedinti',180),(2962,'Mures',180),(2963,'Neamt',180),(2964,'Olt',180),(2965,'Prahova',180),(2966,'Salaj',180),(2967,'Satu Mare',180),(2968,'Sibiu',180),(2969,'Sondelor',180),(2970,'Suceava',180),(2971,'Teleorman',180),(2972,'Timis',180),(2973,'Tulcea',180),(2974,'Valcea',180),(2975,'Vaslui',180),(2976,'Vrancea',180),(2977,'Adygeja',181),(2978,'Aga',181),(2979,'Alanija',181),(2980,'Altaj',181),(2981,'Amur',181),(2982,'Arhangelsk',181),(2983,'Astrahan',181),(2984,'Bashkortostan',181),(2985,'Belgorod',181),(2986,'Brjansk',181),(2987,'Burjatija',181),(2988,'Chechenija',181),(2989,'Cheljabinsk',181),(2990,'Chita',181),(2991,'Chukotka',181),(2992,'Chuvashija',181),(2993,'Dagestan',181),(2994,'Evenkija',181),(2995,'Gorno-Altaj',181),(2996,'Habarovsk',181),(2997,'Hakasija',181),(2998,'Hanty-Mansija',181),(2999,'Ingusetija',181),(3000,'Irkutsk',181),(3001,'Ivanovo',181),(3002,'Jamalo-Nenets',181),(3003,'Jaroslavl',181),(3004,'Jevrej',181),(3005,'Kabardino-Balkarija',181),(3006,'Kaliningrad',181),(3007,'Kalmykija',181),(3008,'Kaluga',181),(3009,'Kamchatka',181),(3010,'Karachaj-Cherkessija',181),(3011,'Karelija',181),(3012,'Kemerovo',181),(3013,'Khabarovskiy Kray',181),(3014,'Kirov',181),(3015,'Komi',181),(3016,'Komi-Permjakija',181),(3017,'Korjakija',181),(3018,'Kostroma',181),(3019,'Krasnodar',181),(3020,'Krasnojarsk',181),(3021,'Krasnoyarskiy Kray',181),(3022,'Kurgan',181),(3023,'Kursk',181),(3024,'Leningrad',181),(3025,'Lipeck',181),(3026,'Magadan',181),(3027,'Marij El',181),(3028,'Mordovija',181),(3029,'Moscow',181),(3030,'Moskovskaja Oblast',181),(3031,'Moskovskaya Oblast',181),(3032,'Moskva',181),(3033,'Murmansk',181),(3034,'Nenets',181),(3035,'Nizhnij Novgorod',181),(3036,'Novgorod',181),(3037,'Novokusnezk',181),(3038,'Novosibirsk',181),(3039,'Omsk',181),(3040,'Orenburg',181),(3041,'Orjol',181),(3042,'Penza',181),(3043,'Perm',181),(3044,'Primorje',181),(3045,'Pskov',181),(3046,'Pskovskaya Oblast',181),(3047,'Rjazan',181),(3048,'Rostov',181),(3049,'Saha',181),(3050,'Sahalin',181),(3051,'Samara',181),(3052,'Samarskaya',181),(3053,'Sankt-Peterburg',181),(3054,'Saratov',181),(3055,'Smolensk',181),(3056,'Stavropol',181),(3057,'Sverdlovsk',181),(3058,'Tajmyrija',181),(3059,'Tambov',181),(3060,'Tatarstan',181),(3061,'Tjumen',181),(3062,'Tomsk',181),(3063,'Tula',181),(3064,'Tver',181),(3065,'Tyva',181),(3066,'Udmurtija',181),(3067,'Uljanovsk',181),(3068,'Ulyanovskaya Oblast',181),(3069,'Ust-Orda',181),(3070,'Vladimir',181),(3071,'Volgograd',181),(3072,'Vologda',181),(3073,'Voronezh',181),(3074,'Butare',182),(3075,'Byumba',182),(3076,'Cyangugu',182),(3077,'Gikongoro',182),(3078,'Gisenyi',182),(3079,'Gitarama',182),(3080,'Kibungo',182),(3081,'Kibuye',182),(3082,'Kigali-ngali',182),(3083,'Ruhengeri',182),(3084,'Ascension',183),(3085,'Gough Island',183),(3086,'Saint Helena',183),(3087,'Tristan da Cunha',183),(3088,'Christ Church Nichola Town',184),(3089,'Saint Anne Sandy Point',184),(3090,'Saint George Basseterre',184),(3091,'Saint George Gingerland',184),(3092,'Saint James Windward',184),(3093,'Saint John Capesterre',184),(3094,'Saint John Figtree',184),(3095,'Saint Mary Cayon',184),(3096,'Saint Paul Capesterre',184),(3097,'Saint Paul Charlestown',184),(3098,'Saint Peter Basseterre',184),(3099,'Saint Thomas Lowland',184),(3100,'Saint Thomas Middle Island',184),(3101,'Trinity Palmetto Point',184),(3102,'Anse-la-Raye',185),(3103,'Canaries',185),(3104,'Castries',185),(3105,'Choiseul',185),(3106,'Dennery',185),(3107,'Gros Inlet',185),(3108,'Laborie',185),(3109,'Micoud',185),(3110,'Soufriere',185),(3111,'Vieux Fort',185),(3112,'Miquelon-Langlade',186),(3113,'Saint-Pierre',186),(3114,'Charlotte',187),(3115,'Grenadines',187),(3116,'Saint Andrew',187),(3117,'Saint David',187),(3118,'Saint George',187),(3119,'Saint Patrick',187),(3120,'A\'ana',188),(3121,'Aiga-i-le-Tai',188),(3122,'Atua',188),(3123,'Fa\'asaleleaga',188),(3124,'Gaga\'emauga',188),(3125,'Gagaifomauga',188),(3126,'Palauli',188),(3127,'Satupa\'itea',188),(3128,'Tuamasaga',188),(3129,'Va\'a-o-Fonoti',188),(3130,'Vaisigano',188),(3131,'Acquaviva',189),(3132,'Borgo Maggiore',189),(3133,'Chiesanuova',189),(3134,'Domagnano',189),(3135,'Faetano',189),(3136,'Fiorentino',189),(3137,'Montegiardino',189),(3138,'San Marino',189),(3139,'Serravalle',189),(3140,'Agua Grande',190),(3141,'Cantagalo',190),(3142,'Lemba',190),(3143,'Lobata',190),(3144,'Me-Zochi',190),(3145,'Pague',190),(3146,'Al Khobar',191),(3147,'Aseer',191),(3148,'Ash Sharqiyah',191),(3149,'Asir',191),(3150,'Central Province',191),(3151,'Eastern Province',191),(3152,'Ha\'il',191),(3153,'Jawf',191),(3154,'Jizan',191),(3155,'Makkah',191),(3156,'Najran',191),(3157,'Qasim',191),(3158,'Tabuk',191),(3159,'Western Province',191),(3160,'al-Bahah',191),(3161,'al-Hudud-ash-Shamaliyah',191),(3162,'al-Madinah',191),(3163,'ar-Riyad',191),(3164,'Dakar',192),(3165,'Diourbel',192),(3166,'Fatick',192),(3167,'Kaolack',192),(3168,'Kolda',192),(3169,'Louga',192),(3170,'Saint-Louis',192),(3171,'Tambacounda',192),(3172,'Thies',192),(3173,'Ziguinchor',192),(3174,'Central Serbia',193),(3175,'Kosovo and Metohija',193),(3176,'Vojvodina',193),(3177,'Anse Boileau',194),(3178,'Anse Royale',194),(3179,'Cascade',194),(3180,'Takamaka',194),(3181,'Victoria',194),(3182,'Eastern',195),(3183,'Northern',195),(3184,'Southern',195),(3185,'Western',195),(3186,'Singapore',196),(3187,'Banskobystricky',197),(3188,'Bratislavsky',197),(3189,'Kosicky',197),(3190,'Nitriansky',197),(3191,'Presovsky',197),(3192,'Trenciansky',197),(3193,'Trnavsky',197),(3194,'Zilinsky',197),(3195,'Benedikt',198),(3196,'Gorenjska',198),(3197,'Gorishka',198),(3198,'Jugovzhodna Slovenija',198),(3199,'Koroshka',198),(3200,'Notranjsko-krashka',198),(3201,'Obalno-krashka',198),(3202,'Obcina Domzale',198),(3203,'Obcina Vitanje',198),(3204,'Osrednjeslovenska',198),(3205,'Podravska',198),(3206,'Pomurska',198),(3207,'Savinjska',198),(3208,'Slovenian Littoral',198),(3209,'Spodnjeposavska',198),(3210,'Zasavska',198),(3211,'Pitcairn',199),(3212,'Central',200),(3213,'Choiseul',200),(3214,'Guadalcanal',200),(3215,'Isabel',200),(3216,'Makira and Ulawa',200),(3217,'Malaita',200),(3218,'Rennell and Bellona',200),(3219,'Temotu',200),(3220,'Western',200),(3221,'Awdal',201),(3222,'Bakol',201),(3223,'Banadir',201),(3224,'Bari',201),(3225,'Bay',201),(3226,'Galgudug',201),(3227,'Gedo',201),(3228,'Hiran',201),(3229,'Jubbada Hose',201),(3230,'Jubbadha Dexe',201),(3231,'Mudug',201),(3232,'Nugal',201),(3233,'Sanag',201),(3234,'Shabellaha Dhexe',201),(3235,'Shabellaha Hose',201),(3236,'Togdher',201),(3237,'Woqoyi Galbed',201),(3238,'Eastern Cape',202),(3239,'Free State',202),(3240,'Gauteng',202),(3241,'Kempton Park',202),(3242,'Kramerville',202),(3243,'KwaZulu Natal',202),(3244,'Limpopo',202),(3245,'Mpumalanga',202),(3246,'North West',202),(3247,'Northern Cape',202),(3248,'Parow',202),(3249,'Table View',202),(3250,'Umtentweni',202),(3251,'Western Cape',202),(3252,'South Georgia',203),(3253,'Central Equatoria',204),(3254,'A Coruna',205),(3255,'Alacant',205),(3256,'Alava',205),(3257,'Albacete',205),(3258,'Almeria',205),(3260,'Asturias',205),(3261,'Avila',205),(3262,'Badajoz',205),(3263,'Balears',205),(3264,'Barcelona',205),(3267,'Burgos',205),(3268,'Caceres',205),(3269,'Cadiz',205),(3270,'Cantabria',205),(3271,'Castello',205),(3273,'Ceuta',205),(3274,'Ciudad Real',205),(3281,'Cordoba',205),(3282,'Cuenca',205),(3284,'Girona',205),(3285,'Granada',205),(3286,'Guadalajara',205),(3287,'Guipuzcoa',205),(3288,'Huelva',205),(3289,'Huesca',205),(3290,'Jaen',205),(3291,'La Rioja',205),(3292,'Las Palmas',205),(3293,'Leon',205),(3295,'Lleida',205),(3296,'Lugo',205),(3297,'Madrid',205),(3298,'Malaga',205),(3299,'Melilla',205),(3300,'Murcia',205),(3301,'Navarra',205),(3302,'Ourense',205),(3303,'Pais Vasco',205),(3304,'Palencia',205),(3305,'Pontevedra',205),(3306,'Salamanca',205),(3308,'Segovia',205),(3309,'Sevilla',205),(3310,'Soria',205),(3311,'Tarragona',205),(3312,'Santa Cruz de Tenerife',205),(3313,'Teruel',205),(3314,'Toledo',205),(3315,'Valencia',205),(3316,'Valladolid',205),(3317,'Vizcaya',205),(3318,'Zamora',205),(3319,'Zaragoza',205),(3320,'Amparai',206),(3321,'Anuradhapuraya',206),(3322,'Badulla',206),(3323,'Boralesgamuwa',206),(3324,'Colombo',206),(3325,'Galla',206),(3326,'Gampaha',206),(3327,'Hambantota',206),(3328,'Kalatura',206),(3329,'Kegalla',206),(3330,'Kilinochchi',206),(3331,'Kurunegala',206),(3332,'Madakalpuwa',206),(3333,'Maha Nuwara',206),(3334,'Malwana',206),(3335,'Mannarama',206),(3336,'Matale',206),(3337,'Matara',206),(3338,'Monaragala',206),(3339,'Mullaitivu',206),(3340,'North Eastern Province',206),(3341,'North Western Province',206),(3342,'Nuwara Eliya',206),(3343,'Polonnaruwa',206),(3344,'Puttalama',206),(3345,'Ratnapuraya',206),(3346,'Southern Province',206),(3347,'Tirikunamalaya',206),(3348,'Tuscany',206),(3349,'Vavuniyawa',206),(3350,'Western Province',206),(3351,'Yapanaya',206),(3352,'kadawatha',206),(3353,'A\'ali-an-Nil',207),(3354,'Bahr-al-Jabal',207),(3355,'Central Equatoria',207),(3356,'Gharb Bahr-al-Ghazal',207),(3357,'Gharb Darfur',207),(3358,'Gharb Kurdufan',207),(3359,'Gharb-al-Istiwa\'iyah',207),(3360,'Janub Darfur',207),(3361,'Janub Kurdufan',207),(3362,'Junqali',207),(3363,'Kassala',207),(3364,'Nahr-an-Nil',207),(3365,'Shamal Bahr-al-Ghazal',207),(3366,'Shamal Darfur',207),(3367,'Shamal Kurdufan',207),(3368,'Sharq-al-Istiwa\'iyah',207),(3369,'Sinnar',207),(3370,'Warab',207),(3371,'Wilayat al Khartum',207),(3372,'al-Bahr-al-Ahmar',207),(3373,'al-Buhayrat',207),(3374,'al-Jazirah',207),(3375,'al-Khartum',207),(3376,'al-Qadarif',207),(3377,'al-Wahdah',207),(3378,'an-Nil-al-Abyad',207),(3379,'an-Nil-al-Azraq',207),(3380,'ash-Shamaliyah',207),(3381,'Brokopondo',208),(3382,'Commewijne',208),(3383,'Coronie',208),(3384,'Marowijne',208),(3385,'Nickerie',208),(3386,'Para',208),(3387,'Paramaribo',208),(3388,'Saramacca',208),(3389,'Wanica',208),(3390,'Svalbard',209),(3391,'Hhohho',210),(3392,'Lubombo',210),(3393,'Manzini',210),(3394,'Shiselweni',210),(3395,'Alvsborgs Lan',211),(3396,'Angermanland',211),(3397,'Blekinge',211),(3398,'Bohuslan',211),(3399,'Dalarna',211),(3400,'Gavleborg',211),(3401,'Gaza',211),(3402,'Gotland',211),(3403,'Halland',211),(3404,'Jamtland',211),(3405,'Jonkoping',211),(3406,'Kalmar',211),(3407,'Kristianstads',211),(3408,'Kronoberg',211),(3409,'Norrbotten',211),(3410,'Orebro',211),(3411,'Ostergotland',211),(3412,'Saltsjo-Boo',211),(3413,'Skane',211),(3414,'Smaland',211),(3415,'Sodermanland',211),(3416,'Stockholm',211),(3417,'Uppsala',211),(3418,'Varmland',211),(3419,'Vasterbotten',211),(3420,'Vastergotland',211),(3421,'Vasternorrland',211),(3422,'Vastmanland',211),(3423,'Vastra Gotaland',211),(3424,'Aargau',212),(3425,'Appenzell Inner-Rhoden',212),(3426,'Appenzell-Ausser Rhoden',212),(3427,'Basel-Landschaft',212),(3428,'Basel-Stadt',212),(3429,'Bern',212),(3430,'Canton Ticino',212),(3431,'Fribourg',212),(3432,'Geneve',212),(3433,'Glarus',212),(3434,'Graubunden',212),(3435,'Heerbrugg',212),(3436,'Jura',212),(3437,'Kanton Aargau',212),(3438,'Luzern',212),(3439,'Morbio Inferiore',212),(3440,'Muhen',212),(3441,'Neuchatel',212),(3442,'Nidwalden',212),(3443,'Obwalden',212),(3444,'Sankt Gallen',212),(3445,'Schaffhausen',212),(3446,'Schwyz',212),(3447,'Solothurn',212),(3448,'Thurgau',212),(3449,'Ticino',212),(3450,'Uri',212),(3451,'Valais',212),(3452,'Vaud',212),(3453,'Vauffelin',212),(3454,'Zug',212),(3455,'Zurich',212),(3456,'Aleppo',213),(3457,'Dar\'a',213),(3458,'Dayr-az-Zawr',213),(3459,'Dimashq',213),(3460,'Halab',213),(3461,'Hamah',213),(3462,'Hims',213),(3463,'Idlib',213),(3464,'Madinat Dimashq',213),(3465,'Tartus',213),(3466,'al-Hasakah',213),(3467,'al-Ladhiqiyah',213),(3468,'al-Qunaytirah',213),(3469,'ar-Raqqah',213),(3470,'as-Suwayda',213),(3471,'Changhua County',214),(3472,'Chiayi County',214),(3473,'Chiayi City',214),(3474,'Taipei City',214),(3475,'Hsinchu County',214),(3476,'Hsinchu City',214),(3477,'Hualien County',214),(3480,'Kaohsiung City',214),(3481,'Keelung City',214),(3482,'Kinmen County',214),(3483,'Miaoli County',214),(3484,'Nantou County',214),(3486,'Penghu County',214),(3487,'Pingtung County',214),(3488,'Taichung City',214),(3492,'Tainan City',214),(3493,'New Taipei City',214),(3495,'Taitung County',214),(3496,'Taoyuan City',214),(3497,'Yilan County',214),(3498,'YunLin County',214),(3500,'Dushanbe',215),(3501,'Gorno-Badakhshan',215),(3502,'Karotegin',215),(3503,'Khatlon',215),(3504,'Sughd',215),(3505,'Arusha',216),(3506,'Dar es Salaam',216),(3507,'Dodoma',216),(3508,'Iringa',216),(3509,'Kagera',216),(3510,'Kigoma',216),(3511,'Kilimanjaro',216),(3512,'Lindi',216),(3513,'Mara',216),(3514,'Mbeya',216),(3515,'Morogoro',216),(3516,'Mtwara',216),(3517,'Mwanza',216),(3518,'Pwani',216),(3519,'Rukwa',216),(3520,'Ruvuma',216),(3521,'Shinyanga',216),(3522,'Singida',216),(3523,'Tabora',216),(3524,'Tanga',216),(3525,'Zanzibar and Pemba',216),(3526,'Amnat Charoen',217),(3527,'Ang Thong',217),(3528,'Bangkok',217),(3529,'Buri Ram',217),(3530,'Chachoengsao',217),(3531,'Chai Nat',217),(3532,'Chaiyaphum',217),(3533,'Changwat Chaiyaphum',217),(3534,'Chanthaburi',217),(3535,'Chiang Mai',217),(3536,'Chiang Rai',217),(3537,'Chon Buri',217),(3538,'Chumphon',217),(3539,'Kalasin',217),(3540,'Kamphaeng Phet',217),(3541,'Kanchanaburi',217),(3542,'Khon Kaen',217),(3543,'Krabi',217),(3544,'Krung Thep',217),(3545,'Lampang',217),(3546,'Lamphun',217),(3547,'Loei',217),(3548,'Lop Buri',217),(3549,'Mae Hong Son',217),(3550,'Maha Sarakham',217),(3551,'Mukdahan',217),(3552,'Nakhon Nayok',217),(3553,'Nakhon Pathom',217),(3554,'Nakhon Phanom',217),(3555,'Nakhon Ratchasima',217),(3556,'Nakhon Sawan',217),(3557,'Nakhon Si Thammarat',217),(3558,'Nan',217),(3559,'Narathiwat',217),(3560,'Nong Bua Lam Phu',217),(3561,'Nong Khai',217),(3562,'Nonthaburi',217),(3563,'Pathum Thani',217),(3564,'Pattani',217),(3565,'Phangnga',217),(3566,'Phatthalung',217),(3567,'Phayao',217),(3568,'Phetchabun',217),(3569,'Phetchaburi',217),(3570,'Phichit',217),(3571,'Phitsanulok',217),(3572,'Phra Nakhon Si Ayutthaya',217),(3573,'Phrae',217),(3574,'Phuket',217),(3575,'Prachin Buri',217),(3576,'Prachuap Khiri Khan',217),(3577,'Ranong',217),(3578,'Ratchaburi',217),(3579,'Rayong',217),(3580,'Roi Et',217),(3581,'Sa Kaeo',217),(3582,'Sakon Nakhon',217),(3583,'Samut Prakan',217),(3584,'Samut Sakhon',217),(3585,'Samut Songkhran',217),(3586,'Saraburi',217),(3587,'Satun',217),(3588,'Si Sa Ket',217),(3589,'Sing Buri',217),(3590,'Songkhla',217),(3591,'Sukhothai',217),(3592,'Suphan Buri',217),(3593,'Surat Thani',217),(3594,'Surin',217),(3595,'Tak',217),(3596,'Trang',217),(3597,'Trat',217),(3598,'Ubon Ratchathani',217),(3599,'Udon Thani',217),(3600,'Uthai Thani',217),(3601,'Uttaradit',217),(3602,'Yala',217),(3603,'Yasothon',217),(3604,'Centre',218),(3605,'Kara',218),(3606,'Maritime',218),(3607,'Plateaux',218),(3608,'Savanes',218),(3609,'Atafu',219),(3610,'Fakaofo',219),(3611,'Nukunonu',219),(3612,'Eua',220),(3613,'Ha\'apai',220),(3614,'Niuas',220),(3615,'Tongatapu',220),(3616,'Vava\'u',220),(3617,'Arima-Tunapuna-Piarco',221),(3618,'Caroni',221),(3619,'Chaguanas',221),(3620,'Couva-Tabaquite-Talparo',221),(3621,'Diego Martin',221),(3622,'Glencoe',221),(3623,'Penal Debe',221),(3624,'Point Fortin',221),(3625,'Port of Spain',221),(3626,'Princes Town',221),(3627,'Saint George',221),(3628,'San Fernando',221),(3629,'San Juan',221),(3630,'Sangre Grande',221),(3631,'Siparia',221),(3632,'Tobago',221),(3633,'Aryanah',222),(3634,'Bajah',222),(3635,'Bin \'Arus',222),(3636,'Binzart',222),(3637,'Gouvernorat de Ariana',222),(3638,'Gouvernorat de Nabeul',222),(3639,'Gouvernorat de Sousse',222),(3640,'Hammamet Yasmine',222),(3641,'Jundubah',222),(3642,'Madaniyin',222),(3643,'Manubah',222),(3644,'Monastir',222),(3645,'Nabul',222),(3646,'Qabis',222),(3647,'Qafsah',222),(3648,'Qibili',222),(3649,'Safaqis',222),(3650,'Sfax',222),(3651,'Sidi Bu Zayd',222),(3652,'Silyanah',222),(3653,'Susah',222),(3654,'Tatawin',222),(3655,'Tawzar',222),(3656,'Tunis',222),(3657,'Zaghwan',222),(3658,'al-Kaf',222),(3659,'al-Mahdiyah',222),(3660,'al-Munastir',222),(3661,'al-Qasrayn',222),(3662,'al-Qayrawan',222),(3663,'Adana',223),(3664,'Adiyaman',223),(3665,'Afyon',223),(3666,'Agri',223),(3667,'Aksaray',223),(3668,'Amasya',223),(3669,'Ankara',223),(3670,'Antalya',223),(3671,'Ardahan',223),(3672,'Artvin',223),(3673,'Aydin',223),(3674,'Balikesir',223),(3675,'Bartin',223),(3676,'Batman',223),(3677,'Bayburt',223),(3678,'Bilecik',223),(3679,'Bingol',223),(3680,'Bitlis',223),(3681,'Bolu',223),(3682,'Burdur',223),(3683,'Bursa',223),(3684,'Canakkale',223),(3685,'Cankiri',223),(3686,'Corum',223),(3687,'Denizli',223),(3688,'Diyarbakir',223),(3689,'Duzce',223),(3690,'Edirne',223),(3691,'Elazig',223),(3692,'Erzincan',223),(3693,'Erzurum',223),(3694,'Eskisehir',223),(3695,'Gaziantep',223),(3696,'Giresun',223),(3697,'Gumushane',223),(3698,'Hakkari',223),(3699,'Hatay',223),(3700,'Icel',223),(3701,'Igdir',223),(3702,'Isparta',223),(3703,'Istanbul',223),(3704,'Izmir',223),(3705,'Kahramanmaras',223),(3706,'Karabuk',223),(3707,'Karaman',223),(3708,'Kars',223),(3709,'Karsiyaka',223),(3710,'Kastamonu',223),(3711,'Kayseri',223),(3712,'Kilis',223),(3713,'Kirikkale',223),(3714,'Kirklareli',223),(3715,'Kirsehir',223),(3716,'Kocaeli',223),(3717,'Konya',223),(3718,'Kutahya',223),(3719,'Lefkosa',223),(3720,'Malatya',223),(3721,'Manisa',223),(3722,'Mardin',223),(3723,'Mugla',223),(3724,'Mus',223),(3725,'Nevsehir',223),(3726,'Nigde',223),(3727,'Ordu',223),(3728,'Osmaniye',223),(3729,'Rize',223),(3730,'Sakarya',223),(3731,'Samsun',223),(3732,'Sanliurfa',223),(3733,'Siirt',223),(3734,'Sinop',223),(3735,'Sirnak',223),(3736,'Sivas',223),(3737,'Tekirdag',223),(3738,'Tokat',223),(3739,'Trabzon',223),(3740,'Tunceli',223),(3741,'Usak',223),(3742,'Van',223),(3743,'Yalova',223),(3744,'Yozgat',223),(3745,'Zonguldak',223),(3746,'Ahal',224),(3747,'Asgabat',224),(3748,'Balkan',224),(3749,'Dasoguz',224),(3750,'Lebap',224),(3751,'Mari',224),(3752,'Grand Turk',225),(3753,'South Caicos and East Caicos',225),(3754,'Funafuti',226),(3755,'Nanumanga',226),(3756,'Nanumea',226),(3757,'Niutao',226),(3758,'Nui',226),(3759,'Nukufetau',226),(3760,'Nukulaelae',226),(3761,'Vaitupu',226),(3762,'Central',227),(3763,'Eastern',227),(3764,'Northern',227),(3765,'Western',227),(3766,'Cherkas\'ka',228),(3767,'Chernihivs\'ka',228),(3768,'Chernivets\'ka',228),(3769,'Crimea',228),(3770,'Dnipropetrovska',228),(3771,'Donets\'ka',228),(3772,'Ivano-Frankivs\'ka',228),(3773,'Kharkiv',228),(3774,'Kharkov',228),(3775,'Khersonska',228),(3776,'Khmel\'nyts\'ka',228),(3777,'Kirovohrad',228),(3778,'Krym',228),(3779,'Kyyiv',228),(3780,'Kyyivs\'ka',228),(3781,'L\'vivs\'ka',228),(3782,'Luhans\'ka',228),(3783,'Mykolayivs\'ka',228),(3784,'Odes\'ka',228),(3785,'Odessa',228),(3786,'Poltavs\'ka',228),(3787,'Rivnens\'ka',228),(3788,'Sevastopol\'',228),(3789,'Sums\'ka',228),(3790,'Ternopil\'s\'ka',228),(3791,'Volyns\'ka',228),(3792,'Vynnyts\'ka',228),(3793,'Zakarpats\'ka',228),(3794,'Zaporizhia',228),(3795,'Zhytomyrs\'ka',228),(3796,'Abu Zabi',229),(3797,'Ajman',229),(3798,'Dubai',229),(3799,'Ras al-Khaymah',229),(3800,'Sharjah',229),(3801,'Sharjha',229),(3802,'Umm al Qaywayn',229),(3803,'al-Fujayrah',229),(3804,'ash-Shariqah',229),(3805,'Aberdeen',230),(3806,'Aberdeenshire',230),(3807,'Argyll',230),(3808,'Armagh',230),(3809,'Bedfordshire',230),(3810,'Belfast',230),(3811,'Berkshire',230),(3812,'Birmingham',230),(3813,'Brechin',230),(3814,'Bridgnorth',230),(3815,'Bristol',230),(3816,'Buckinghamshire',230),(3817,'Cambridge',230),(3818,'Cambridgeshire',230),(3819,'Channel Islands',230),(3820,'Cheshire',230),(3821,'Cleveland',230),(3822,'Co Fermanagh',230),(3823,'Conwy',230),(3824,'Cornwall',230),(3825,'Coventry',230),(3826,'Craven Arms',230),(3827,'Cumbria',230),(3828,'Denbighshire',230),(3829,'Derby',230),(3830,'Derbyshire',230),(3831,'Devon',230),(3832,'Dial Code Dungannon',230),(3833,'Didcot',230),(3834,'Dorset',230),(3835,'Dunbartonshire',230),(3836,'Durham',230),(3837,'East Dunbartonshire',230),(3838,'East Lothian',230),(3839,'East Midlands',230),(3840,'East Sussex',230),(3841,'East Yorkshire',230),(3842,'England',230),(3843,'Essex',230),(3844,'Fermanagh',230),(3845,'Fife',230),(3846,'Flintshire',230),(3847,'Fulham',230),(3848,'Gainsborough',230),(3849,'Glocestershire',230),(3850,'Gwent',230),(3851,'Hampshire',230),(3852,'Hants',230),(3853,'Herefordshire',230),(3854,'Hertfordshire',230),(3855,'Ireland',230),(3856,'Isle Of Man',230),(3857,'Isle of Wight',230),(3858,'Kenford',230),(3859,'Kent',230),(3860,'Kilmarnock',230),(3861,'Lanarkshire',230),(3862,'Lancashire',230),(3863,'Leicestershire',230),(3864,'Lincolnshire',230),(3865,'Llanymynech',230),(3866,'London',230),(3867,'Ludlow',230),(3868,'Manchester',230),(3869,'Mayfair',230),(3870,'Merseyside',230),(3871,'Mid Glamorgan',230),(3872,'Middlesex',230),(3873,'Mildenhall',230),(3874,'Monmouthshire',230),(3875,'Newton Stewart',230),(3876,'Norfolk',230),(3877,'North Humberside',230),(3878,'North Yorkshire',230),(3879,'Northamptonshire',230),(3880,'Northants',230),(3881,'Northern Ireland',230),(3882,'Northumberland',230),(3883,'Nottinghamshire',230),(3884,'Oxford',230),(3885,'Powys',230),(3886,'Roos-shire',230),(3887,'SUSSEX',230),(3888,'Sark',230),(3889,'Scotland',230),(3890,'Scottish Borders',230),(3891,'Shropshire',230),(3892,'Somerset',230),(3893,'South Glamorgan',230),(3894,'South Wales',230),(3895,'South Yorkshire',230),(3896,'Southwell',230),(3897,'Staffordshire',230),(3898,'Strabane',230),(3899,'Suffolk',230),(3900,'Surrey',230),(3901,'Sussex',230),(3902,'Twickenham',230),(3903,'Tyne and Wear',230),(3904,'Tyrone',230),(3905,'Utah',230),(3906,'Wales',230),(3907,'Warwickshire',230),(3908,'West Lothian',230),(3909,'West Midlands',230),(3910,'West Sussex',230),(3911,'West Yorkshire',230),(3912,'Whissendine',230),(3913,'Wiltshire',230),(3914,'Wokingham',230),(3915,'Worcestershire',230),(3916,'Wrexham',230),(3917,'Wurttemberg',230),(3918,'Yorkshire',230),(3919,'Alabama',231),(3920,'Alaska',231),(3921,'Arizona',231),(3922,'Arkansas',231),(3923,'Byram',231),(3924,'California',231),(3925,'Cokato',231),(3926,'Colorado',231),(3927,'Connecticut',231),(3928,'Delaware',231),(3929,'District of Columbia',231),(3930,'Florida',231),(3931,'Georgia',231),(3932,'Hawaii',231),(3933,'Idaho',231),(3934,'Illinois',231),(3935,'Indiana',231),(3936,'Iowa',231),(3937,'Kansas',231),(3938,'Kentucky',231),(3939,'Louisiana',231),(3940,'Lowa',231),(3941,'Maine',231),(3942,'Maryland',231),(3943,'Massachusetts',231),(3944,'Medfield',231),(3945,'Michigan',231),(3946,'Minnesota',231),(3947,'Mississippi',231),(3948,'Missouri',231),(3949,'Montana',231),(3950,'Nebraska',231),(3951,'Nevada',231),(3952,'New Hampshire',231),(3953,'New Jersey',231),(3954,'New Jersy',231),(3955,'New Mexico',231),(3956,'New York',231),(3957,'North Carolina',231),(3958,'North Dakota',231),(3959,'Ohio',231),(3960,'Oklahoma',231),(3961,'Ontario',231),(3962,'Oregon',231),(3963,'Pennsylvania',231),(3964,'Ramey',231),(3965,'Rhode Island',231),(3966,'South Carolina',231),(3967,'South Dakota',231),(3968,'Sublimity',231),(3969,'Tennessee',231),(3970,'Texas',231),(3971,'Trimble',231),(3972,'Utah',231),(3973,'Vermont',231),(3974,'Virginia',231),(3975,'Washington',231),(3976,'West Virginia',231),(3977,'Wisconsin',231),(3978,'Wyoming',231),(3979,'United States Minor Outlying I',232),(3980,'Artigas',233),(3981,'Canelones',233),(3982,'Cerro Largo',233),(3983,'Colonia',233),(3984,'Durazno',233),(3985,'FLorida',233),(3986,'Flores',233),(3987,'Lavalleja',233),(3988,'Maldonado',233),(3989,'Montevideo',233),(3990,'Paysandu',233),(3991,'Rio Negro',233),(3992,'Rivera',233),(3993,'Rocha',233),(3994,'Salto',233),(3995,'San Jose',233),(3996,'Soriano',233),(3997,'Tacuarembo',233),(3998,'Treinta y Tres',233),(3999,'Andijon',234),(4000,'Buhoro',234),(4001,'Buxoro Viloyati',234),(4002,'Cizah',234),(4003,'Fargona',234),(4004,'Horazm',234),(4005,'Kaskadar',234),(4006,'Korakalpogiston',234),(4007,'Namangan',234),(4008,'Navoi',234),(4009,'Samarkand',234),(4010,'Sirdare',234),(4011,'Surhondar',234),(4012,'Toskent',234),(4013,'Malampa',235),(4014,'Penama',235),(4015,'Sanma',235),(4016,'Shefa',235),(4017,'Tafea',235),(4018,'Torba',235),(4019,'Vatican City State (Holy See)',236),(4020,'Amazonas',237),(4021,'Anzoategui',237),(4022,'Apure',237),(4023,'Aragua',237),(4024,'Barinas',237),(4025,'Bolivar',237),(4026,'Carabobo',237),(4027,'Cojedes',237),(4028,'Delta Amacuro',237),(4029,'Distrito Federal',237),(4030,'Falcon',237),(4031,'Guarico',237),(4032,'Lara',237),(4033,'Merida',237),(4034,'Miranda',237),(4035,'Monagas',237),(4036,'Nueva Esparta',237),(4037,'Portuguesa',237),(4038,'Sucre',237),(4039,'Tachira',237),(4040,'Trujillo',237),(4041,'Vargas',237),(4042,'Yaracuy',237),(4043,'Zulia',237),(4044,'Bac Giang',238),(4045,'Binh Dinh',238),(4046,'Binh Duong',238),(4047,'Da Nang',238),(4048,'Dong Bang Song Cuu Long',238),(4049,'Dong Bang Song Hong',238),(4050,'Dong Nai',238),(4051,'Dong Nam Bo',238),(4052,'Duyen Hai Mien Trung',238),(4053,'Hanoi',238),(4054,'Hung Yen',238),(4055,'Khu Bon Cu',238),(4056,'Long An',238),(4057,'Mien Nui Va Trung Du',238),(4058,'Thai Nguyen',238),(4059,'Thanh Pho Ho Chi Minh',238),(4060,'Thu Do Ha Noi',238),(4061,'Tinh Can Tho',238),(4062,'Tinh Da Nang',238),(4063,'Tinh Gia Lai',238),(4064,'Anegada',239),(4065,'Jost van Dyke',239),(4066,'Tortola',239),(4067,'Saint Croix',240),(4068,'Saint John',240),(4069,'Saint Thomas',240),(4070,'Alo',241),(4071,'Singave',241),(4072,'Wallis',241),(4073,'Bu Jaydur',242),(4074,'Wad-adh-Dhahab',242),(4075,'al-\'Ayun',242),(4076,'as-Samarah',242),(4077,'\'Adan',243),(4078,'Abyan',243),(4079,'Dhamar',243),(4080,'Hadramaut',243),(4081,'Hajjah',243),(4082,'Hudaydah',243),(4083,'Ibb',243),(4084,'Lahij',243),(4085,'Ma\'rib',243),(4086,'Madinat San\'a',243),(4087,'Sa\'dah',243),(4088,'Sana',243),(4089,'Shabwah',243),(4090,'Ta\'izz',243),(4091,'al-Bayda',243),(4092,'al-Hudaydah',243),(4093,'al-Jawf',243),(4094,'al-Mahrah',243),(4095,'al-Mahwit',243),(4096,'Central Serbia',244),(4097,'Kosovo and Metohija',244),(4098,'Montenegro',244),(4099,'Republic of Serbia',244),(4100,'Serbia',244),(4101,'Vojvodina',244),(4102,'Central',245),(4103,'Copperbelt',245),(4104,'Eastern',245),(4105,'Luapala',245),(4106,'Lusaka',245),(4107,'North-Western',245),(4108,'Northern',245),(4109,'Southern',245),(4110,'Western',245),(4111,'Bulawayo',246),(4112,'Harare',246),(4113,'Manicaland',246),(4114,'Mashonaland Central',246),(4115,'Mashonaland East',246),(4116,'Mashonaland West',246),(4117,'Masvingo',246),(4118,'Matabeleland North',246),(4119,'Matabeleland South',246),(4120,'Midlands',246),(4121,'Lienchiang County',214);

--
-- Table structure for table `subcategory`
--

CREATE TABLE `subcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `category` text NOT NULL,
  `bid_price` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subcategory`
--

INSERT INTO `subcategory` VALUES (26,'Alarm & CCTV Services','20','2'),(28,'Audio Visual Specialist','5','2'),(29,'Auto-gate Services','20','2'),(30,'Bathroom Accessories Services','5','2'),(31,'Cabinet Contractor','5','2'),(32,'Carpet Installer and Supplier','19','2'),(33,'Curtain and Blinds Services','19','2'),(34,'Door & Gate Installer & Supplier','5','2'),(35,'Electric Fence Installer and Supplier','20','2'),(36,'Glass Installer and Supplier','5','2'),(37,'Grille & Metal Installer & Supplier','5','2'),(38,'House Painting & Wall Painting','19','2'),(40,'Vinyl flooring supply & install','19','2'),(41,'Landscape Gardener','5','2'),(42,'Lighting Installer & Supplier','5','2'),(43,'Mosquito Net Suppliers','5','2'),(44,'Plaster Ceiling Supplier & Installer','19','2'),(45,'Renovation Contractor','5','2'),(46,'Security Window Installer','20','2'),(47,'Swimming Pool Maintenance & Build','5','2'),(48,'Tile Supplier & Installer','5','2'),(50,'Wallpaper Supplier','19','2'),(51,'Window Installer and Supplier','5','2'),(53,'Electrical and Wiring Services','5','2'),(55,'Furniture Installer','5','2'),(56,'Grass Cutter','5','2'),(60,'Locksmith','20','2'),(61,'Pest Control','5','2'),(63,'Carpet Cleaning','3','2'),(64,'Curtain Cleaning','3','2'),(65,'Disinfection Services','3','2'),(66,'Home Cleaning','3','2'),(67,'Move In / Move Out Cleaning','3','2'),(68,'Post Renovation Cleaning','3','2'),(69,'Sofa, Mattress Cleaning','3','2'),(70,'Roof Cleaning','3','2'),(71,'Balloon Artist','6','2'),(72,'Bands and Singers','6','2'),(75,'Clown','6','2'),(76,'Photographer & Videographer','6','2'),(78,'Custom Shoes & Heels Designer','6','2'),(79,'Custom Suit Designer','6','2'),(80,'Deejay','6','2'),(81,'Dressmaker','6','2'),(82,'Emcee','6','2'),(83,'Event Decorator & Event Equipment and Set-up','6','2'),(85,'Event Venue','6','2'),(86,'Face Painter','6','2'),(87,'Home Catering and Tingkat','6','2'),(88,'Makeup Artist and Hairstylist ','13','2'),(89,'Party and Goody Bag Supplier','6','2'),(90,'Private Chef','6','2'),(91,'Wedding Car Rental','6','2'),(92,'Wedding Dress Designer','6','2'),(93,'Wedding Gifts & Favors','6','2'),(96,'Acting Lessons','7','2'),(97,'Aerobics Classes and Lessons','7','2'),(98,'Art Classes and Lessons','7','2'),(99,'Badminton Coach','7','2'),(100,'Ballet Lessons','7','2'),(101,'Ballroom Dance Lessons','7','2'),(102,'Business Courses','7','2'),(103,'Children Enrichment Lessons','7','2'),(104,'Chinese Classes and Lessons','7','2'),(105,'Cooking & Bakery Class','7','2'),(106,'Dance Lessons','7','2'),(107,'Drum Lessons','7','2'),(108,'English Language Lessons','7','2'),(109,'Facial Treatment','7','2'),(110,'Finance Classes &Lessons','7','2'),(111,'Flute Lessons','7','2'),(112,'French Language Classes','7','2'),(113,'Guitar Lessons','7','2'),(114,'Home and Elderly Caregiver','7','2'),(115,'Japanese Language Lessons','7','2'),(116,'Korean Language Lessons','7','2'),(117,'Language Translator','7','2'),(118,'Lessons: Others','7','2'),(119,'Malay Language Lessons','7','2'),(120,'Manicurist, Pedicurist','7','2'),(122,'Massage Therapy','7','2'),(123,'Maternity Caregiver','7','2'),(124,'Meditation Lessons','7','2'),(125,'Music Lessons','7','2'),(127,'Personal Trainer','7','2'),(128,'Photography Lessons','7','2'),(129,'Physiotherapist','7','2'),(130,'Piano Lessons','7','2'),(131,'Pilates Instructor','7','2'),(132,'Salsa Dance Lessons','7','2'),(133,'Spanish Language Lessons','7','2'),(134,'Squash Coach','7','2'),(135,'Swimming Lessons','7','2'),(136,'Tamil Language Lessons','7','2'),(137,'Tennis Coach','7','2'),(138,'Thai Language Lessons','7','2'),(139,'Vietnamese Language Lessons','7','2'),(140,'Violin Lessons','7','2'),(141,'Wellness','7','2'),(142,'Yoga Instructor','7','2'),(143,'Zumba Lessons','7','2'),(145,'Furniture Services','5','2'),(146,'Magician','6','2'),(147,'Architect','8','2'),(148,'Advertising','8','2.00'),(149,'Alcohol and Liquor Supplier','8','2'),(150,'Custom Shoes and Heels Designer','8','2'),(151,'Business Advisor and Consultant','8','2'),(152,'Copy Editor & Writer & Copywriter','8','2'),(153,'Accountant','8','2'),(154,'Gifts and Hampers','8','2'),(155,'Printing Services','8','2'),(156,'Courier Services','8','2'),(157,'Digital Marketing & Social Media Specialist','22','2'),(158,'Home, Smart Home and Office Networking','5','2'),(159,'Interior Designer','19','2'),(160,'Language Translator','8','2'),(161,'Personal driver','8','2'),(162,'Video Editor','8','2'),(163,'Computer & Laptop Repair','21','2'),(164,'Mobile Phone Repair','21','2'),(165,'Automatic Sliding Door Repair','15','2'),(166,'Kitchen Exhaust Repair','15','2'),(167,'Roller Shutter Repair','15','2'),(168,'Signage Repair','15','2'),(169,'Roof supply, install, repair','15','2'),(170,'Floor Repair and Polish','15','2'),(171,'Fridge Repair','15','2'),(172,'Furniture Repair and Upholstery','15','2'),(173,'Oven Repair','15','2'),(174,'TV Repair','15','2'),(175,'Washing Machine Repair','15','2'),(177,'Babysitter & Childcare','12','2'),(178,'Domestic Maid Agency','12','2'),(179,'Feng Shui Consultant','12','2'),(180,'Insurance Agent','12','2'),(181,'Laundry and Dry Cleaning','12','2'),(182,'Maternity Caregiver','12','2'),(183,'Private Investigator','12','2'),(184,'Web Designer','14','3'),(185,'Software Freelancer','14','3'),(186,'Invitation Card Designer and Printer','14','2'),(187,'Graphic Designer','14','3'),(188,'Aircon Servicing','5','2'),(189,'Plumber Services','5','2'),(191,'Computer & Electronic','5','2'),(192,'Jobseeker','16','2'),(193,'Travel Agency','23','2'),(194,'Cake Baker','17','2'),(195,'Caterers','17','2'),(196,'Private Chef','17','2'),(197,'Restaurant Services','17','2'),(198,'Facial Treatment','13','2'),(199,'Massage Therapy','13','2'),(200,'Martial Arts','13','2'),(201,'Nutritionist','13','2'),(202,'Beauty & Salon & Barbers Services','13','2'),(203,'Healthy Food & Beverage','13','2'),(204,'Fitness & Personal Training','13','2'),(205,'Rehabilitation & Wellness','13','2'),(206,'Moving Service','9','2'),(207,'Lorry rental & Car Rental','9','2'),(208,'Motor Insurance Agent','9','2'),(209,'Car Repair & Services & Parts','9','2'),(210,'Youtuber','16','3'),(211,'Farming & Agriculture','18','2'),(212,'Bakery','18','2'),(213,'Manufacturing','18','2'),(215,'Cosmetic & Perfume','13','2'),(216,'Car Washing and Detailing','9','1'),(217,'Canvas Print','19','2'),(218,'Sell Property','2','2'),(219,'Rent Property','2','2'),(220,'Cake Baker','23','1'),(221,'Caterers','23','2'),(222,'Private Chef','23','2'),(223,'Restaurant','23','2'),(224,'Airbnb','23','2'),(225,'Hotel, Motel','23','2'),(226,'Wallpaper Printing','19','5'),(227,'Wallpaper Installer','19','2'),(228,'Pet Care','12','2'),(229,'Landscaping','12','2'),(230,'Food Delivery','23','1'),(231,'Eldercare and companionship','12','2'),(232,'Florist','18','2'),(233,'Bird Nest','18','2'),(234,'Extend Car Warranty','9','2'),(235,'Carton Box','18','2'),(236,'Large Format Printing','18','2'),(237,'Courier Services / Logistic','9','2'),(238,' HR Recruiter ','16','3'),(239,'Funeral Industry / Service','12','2'),(240,'Kids accessories & Stationery','18','2'),(241,'Snack & Drink','18','2');

--
-- Table structure for table `tech_video`
--

CREATE TABLE `tech_video` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `TITLE` text NOT NULL,
  `link` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tech_video`
--

INSERT INTO `tech_video` VALUES (1,'HOW TO UPLOAD YOUTUBE VIDEO','https://www.youtube.com/embed/ON_JOYgUPfE'),(2,'HOW IT WORKS VENDOR ','https://www.youtube.com/embed/BSTe1MEJIhE'),(3,'HOW IT WORKS USER','https://www.youtube.com/watch?v=vzYwwZmmLT0');

--
-- Table structure for table `testimonial`
--

CREATE TABLE `testimonial` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `heading` text NOT NULL,
  `description` text NOT NULL,
  `image` text NOT NULL,
  `city` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonial`
--

INSERT INTO `testimonial` VALUES (6,'Ronne Galle','Best Freelancer Patform',' Hi , i posted a job few days ago , i got best vandor , he was very experienced','transupload/343_img-02.jpg','saltake,malasaya'),(7,'jaita','great to find vendor',' Hi guys , i used this website for last 5 years , it is easy to hire experienced person ','transupload/429_img-08.jpg','SINGAPORE'),(8,'Arun','Good freelance website','Hi If you trying to find a good freelancer , you can post your job here  ,  it is  easy to hire freelancer  ','transupload/227_img-05.jpg','SINGAPORE'),(9,'Salim ','Best Freelancer marketplace',' Hi i am a vendor , i got 46+ job in a month , Also commission is very low.','transupload/138_img-04.jpg','TORONTO , CA');

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transction_id` text NOT NULL,
  `username` text NOT NULL,
  `amount` text NOT NULL,
  `description` text NOT NULL,
  `txn_type` varchar(1000) NOT NULL,
  `previous_balance` text NOT NULL,
  `current_balance` text NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=171 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` VALUES (142,'2021061514431839','vendor552','3','Bid Price ','d','15','12','2021-06-15'),(143,'2021061516012026','vendor','3','Bid Price ','d','32','29','2021-06-16'),(144,'2021061523501960','mili','3','Bid Price ','d','240','237','2021-06-16'),(145,'2021061606571057','vendor552','3','Bid Price ','d','12','9','2021-06-16'),(146,'2021061608412098','vendor','3','Bid Price ','d','29','26','2021-06-16'),(147,'2021061614393105','windy','1.00','Wallet Credit','c','','10','2021-06-16'),(148,'2021061704202879','MikuMiku','2','Bid Price ','d','10','8','2021-06-17'),(149,'2021061802531315','vendor','2','Bid Price ','d','26','24','2021-06-18'),(150,'2021062101371953','vendor','2','Bid Price ','d','24','22','2021-06-21'),(151,'2021062203504156','ranjit','3','Bid Price ','d','500','497','2021-06-22'),(153,'2021070904421685','vendor','22','Add Youtube Video  ','d','22','0','2021-07-09'),(154,'2021071001572248','vendor','5','Add Youtube Video  ','d','10','5','2021-07-10'),(155,'2021071002024599','vendor','2','Bid Price ','d','5','3','2021-07-10'),(156,'202107100214204','vendor','5','Add Youtube Video  ','d','13','8','2021-07-10'),(157,'2021071002153467','vendor','5','Add Youtube Video  ','d','8','3','2021-07-10'),(158,'202107141421889','vendor','2','Add Youtube Video  ','d','3','1','2021-07-14'),(159,'2021071802502101','Kenkoo','2','Add Youtube Video  ','d','10','8','2021-07-18'),(160,'2021071803014621','Kenkoo','2','Add Youtube Video  ','d','8','6','2021-07-18'),(161,'2021071804182572','Kenkoo','2','Add Youtube Video  ','d','8','6','2021-07-18'),(162,'2021071816193339','frankiekuan','2','Bid Price ','d','10','8','2021-07-19'),(163,'2021071816203012','vendor','3','Bid Price ','d','101','98','2021-07-19'),(164,'2021071816243705','vendor','3','Bid Price ','d','98','95','2021-07-19'),(165,'202107240417542','vendor','3','Bid Price ','d','95','92','2021-07-24'),(166,'2021072501133233','vendor','3','Bid Price ','d','92','89','2021-07-25'),(167,'2021072513141250','classic','2','Add Youtube Video  ','d','10','8','2021-07-25'),(168,'202107251316907','classic','2','Add Youtube Video  ','d','8','6','2021-07-25'),(169,'2021072513172353','classic','2','Add Youtube Video  ','d','6','4','2021-07-25'),(170,'2021072707072940','Moonsoul','2','Add Youtube Video  ','d','10','8','2021-07-27');

--
-- Table structure for table `user_project _image`
--

CREATE TABLE `user_project _image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` text COLLATE utf8_unicode_ci NOT NULL,
  `image` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_project _image`
--

INSERT INTO `user_project _image` VALUES (11,'vendor552','upload/146_WhatsApp Image 2020-12-02 at 14.53.10.jpg'),(12,'vendor552','upload/255_WhatsApp Image 2020-12-02 at 14.53.11 (1).jpg'),(13,'vendor552','upload/481_WhatsApp Image 2020-12-02 at 14.53.11.jpg'),(14,'vendor552','upload/122_WhatsApp Image 2020-12-02 at 14.53.12 (1).jpg'),(15,'vendor552','upload/13_WhatsApp Image 2020-12-02 at 14.53.12.jpg'),(16,'vendor552','upload/342_WhatsApp Image 2020-12-02 at 14.53.13 (1).jpg'),(17,'vendor552','upload/180_WhatsApp Image 2020-12-02 at 14.53.13.jpg'),(18,'vendor552','upload/226_WhatsApp Image 2020-12-02 at 14.53.14.jpg'),(19,'vendor552','upload/396_WhatsApp Image 2020-12-02 at 14.53.20.jpg'),(20,'windy','upload/446_WhatsApp Image 2020-12-05 at 19.36.51 (1).jpg'),(21,'windy','upload/171_WhatsApp Image 2020-12-05 at 19.36.51 (41).jpg'),(22,'windy','upload/138_WhatsApp Image 2020-12-05 at 19.36.51 (39).jpg'),(23,'windy','upload/53_WhatsApp Image 2020-12-02 at 19.56.30 (1).jpg'),(24,'vendor552','upload/304_16894507.jpg'),(25,'vendor552','upload/136_Buy 1 Free 1 Surprised.jpg'),(26,'windy','upload/189_11822136.jpg'),(27,'windy','upload/157_14425863.jpg'),(28,'windy','upload/251_14981715.jpg'),(29,'windy','upload/79_15136897.jpg'),(30,'windy','upload/287_15382073.jpg'),(31,'windy','upload/159_11822136.jpg'),(32,'windy','upload/260_14425863.jpg'),(33,'windy','upload/436_14981715.jpg'),(34,'ranjit','upload/413_Chrysanthemum.jpg'),(35,'ranjit','upload/70_Tulips.jpg'),(36,'ranjit','upload/396_Tulips.jpg'),(37,'ranjit','upload/390_Penguins.jpg'),(38,'ranjit','upload/220_Lighthouse.jpg'),(39,'ranjit','upload/97_Chrysanthemum.jpg'),(40,'ranjit','upload/315_Desert.jpg'),(41,'ranjit','upload/477_Chrysanthemum.jpg'),(42,'ranjit','upload/9_Tulips.jpg'),(43,'ranjit','upload/254_Chrysanthemum.jpg'),(44,'ranjit','upload/359_Desert.jpg'),(45,'ranjit','upload/254_Chrysanthemum.jpg'),(46,'ranjit','upload/359_Desert.jpg'),(47,'windy','upload/189_1031747011.jpg'),(48,'windy','upload/141_1358430179.jpg'),(49,'windy','upload/428_1461501530_web.jpg'),(52,'MikuMiku','upload/2_istockphoto-953022918-612x612.jpg'),(54,'MikuMiku','upload/357_boost-revenue.jpg'),(57,'vendor','upload/355_WhatsApp Image 2018-08-06 at 3.03.21 PM (1).jpeg'),(58,'vendor','upload/235_WhatsApp Image 2018-08-12 at 8.38.03 PM (1).jpeg'),(59,'vendor','upload/149_WhatsApp Image 2018-08-12 at 8.49.18 PM (2).jpeg'),(60,'vendor','upload/69_WhatsApp Image 2018-08-12 at 8.38.03 PM.jpeg'),(61,'vendor','upload/246_WhatsApp Image 2018-08-12 at 8.49.18 PM (3).jpeg'),(62,'vendor','upload/422_WhatsApp Image 2018-08-12 at 8.49.18 PM (7).jpeg'),(63,'vendor','upload/22_WhatsApp Image 2018-08-12 at 8.49.18 PM (10).jpeg'),(64,'vendor','upload/166_WhatsApp Image 2018-08-12 at 8.49.18 PM (14).jpeg'),(65,'vendor','upload/108_WhatsApp Image 2018-08-12 at 8.49.18 PM (16).jpeg'),(66,'vendor','upload/46_WhatsApp Image 2018-08-12 at 8.49.18 PM (18).jpeg'),(68,'marcochaw','upload/231_unnamed.jpeg'),(71,'Lovelife Wellness','upload/111_saltRoom.jpg'),(72,'Lovelife Wellness','upload/63_crystalLite.jpg'),(73,'Lovelife Wellness','upload/84_scalarWave.jpg'),(74,'Lovelife Wellness','upload/136_reiki.jpg'),(75,'Lovelife Wellness','upload/350_auraReading.jpg'),(76,'Lovelife Wellness','upload/494_backBone.jpg'),(77,'Lovelife Wellness','upload/481_candleOil.jpg'),(78,'Lovelife Wellness','upload/491_detox.jpg'),(79,'Lovelife Wellness','upload/188_fumigation.jpg'),(80,'Pureal','upload/238_Magical Essential Oil_Abundance-01.jpg'),(81,'Pureal','upload/27_Magical Essential Oil_Lovess-01.jpg'),(82,'Pureal','upload/298_Screen Shot 2021-07-16 at 12.59.05 AM.jpg'),(83,'Pureal','upload/64_Screen Shot 2021-07-16 at 12.40.23 AM.jpg'),(84,'Pureal','upload/204_Screen Shot 2021-07-16 at 12.39.59 AM.jpg'),(85,'Pureal','upload/122_Screen Shot 2021-07-16 at 1.10.32 AM.jpg'),(86,'Pureal','upload/279_Screen Shot 2021-07-16 at 12.40.42 AM.png'),(87,'Pureal','upload/200_Screen Shot 2021-07-16 at 1.15.10 AM.jpg'),(88,'Pureal','upload/461_Screen Shot 2021-07-16 at 1.03.40 AM.jpg'),(89,'KenKoo','upload/274_Screenshot_20210329_140131_edit_562369005736063.jpg'),(90,'KenKoo','upload/55_watermark_Sat_26062021_130946_edit_3291653136178461.png'),(91,'Kenkoo','upload/229_IMG_20210703_091103_201.jpg'),(92,'Kenkoo','upload/338_IMG_20210621_010851_130.jpg'),(93,'Kenkoo','upload/71_IMG_20210529_205028_343.jpg'),(94,'Kenkoo','upload/498_IMG_20210717_091053_827.jpg'),(95,'Kenkoo','upload/169_IMG_20210716_093220_774.jpg'),(96,'Kenkoo','upload/174_IMG_20210628_100149_041.jpg'),(97,'Kenkoo','upload/123_IMG_20210529_133410_527.jpg'),(98,'Kenkoo','upload/382_watermark_Mon_12072021_182859_edit_551059882524248.png'),(99,'Kenkoo','upload/253_FB_IMG_1616997996318.jpg'),(100,'JOCELYN_LEELI','upload/140_49741346_1004867589697788_430642326226862080_n.jpg'),(101,'JOCELYN_LEELI','upload/156_img023_副本.jpg'),(102,'JOCELYN_LEELI','upload/400_2cc2d4f1-3a3d-4f64-881b-583bc5bbf15d.jpg'),(103,'JOCELYN_LEELI','upload/370_5f363c68-eb63-4d9c-bb49-098453fc1679.jpg'),(104,'Andreii budnichenko','upload/373_sdfs.PNG'),(105,'Moonsoul','upload/470_184BBA8B-FCFF-4AB3-8544-40FE2A0E1C9D.png'),(106,'Moonsoul','upload/122_C7B209F9-3BA7-4A6F-9F6E-B17E2C97810C.jpeg'),(107,'Moonsoul','upload/120_53963A48-964C-4E69-9605-F03AEC71FEB6.jpeg'),(108,'Moonsoul','upload/363_3C880CB6-E149-42A4-B847-2658D5C5386A.jpeg'),(109,'Moonsoul','upload/387_E4B14830-6DE6-4F7E-8F20-90A9BC646820.jpeg'),(111,'classic','upload/277_211427228_4691665650862381_8009883130037810995_n.jpg'),(112,'classic','upload/21_217282297_4691666234195656_1399702573190301153_n.jpg'),(113,'classic','upload/311_216612621_4691666387528974_1428717750638485801_n.jpg'),(114,'classic','upload/281_217540778_4691666644195615_8533268953364823737_n.jpg'),(115,'classic','upload/347_175671718_4436032636425685_4922030602429219534_n.jpg'),(116,'classic','upload/470_160908578_4345428965486053_4921534696883964195_n.jpg'),(117,'classic','upload/144_176103524_4453652414663707_2074395298711168603_n.jpg'),(118,'classic','upload/40_176147944_4453652561330359_273410483219534334_n.jpg'),(119,'lily ','upload/311_mmexport1624197109921.jpg'),(120,'gafitcouple','upload/412_71D0E9D9-EC91-4CF7-B09A-D984B2EF19F9.jpeg'),(121,'gafitcouple','upload/326_42198544-6CC5-4F97-90D7-54987C82AC62.jpeg'),(122,'gafitcouple','upload/95_98C974F2-956D-4888-B2A7-253517244476.jpeg'),(123,'gafitcouple','upload/360_AAC372F6-FCB0-4857-ACEB-B12C6E69CADE.jpeg'),(124,'gafitcouple','upload/209_C23291EA-CACA-43EA-B435-00F94F14B513.jpeg'),(126,'ric','upload/491_FB_IMG_1626857202066.jpg'),(127,'ric','upload/422_FB_IMG_1626857186665.jpg'),(128,'ric','upload/408_FB_IMG_1626857180768.jpg'),(129,'ric','upload/21_FB_IMG_1626857198339.jpg'),(130,'lily','upload/424_mmexport1624197115287.jpg'),(132,'lily','upload/197_mmexport1624197112795.jpg'),(133,'lily','upload/378_mmexport1624197106577.jpg'),(134,'lily','upload/384_mmexport1620791193218.jpg'),(135,'lily','upload/385_Polish_20210628_102600675.png'),(136,'caseylow','upload/342_Melati_FB-Ads_eng.jpg'),(137,'caseylow','upload/283_melati-ads_Map.jpg'),(138,'caseylow','upload/215_melati-ads_Layout.jpg'),(139,'caseylow','upload/267_melati-ads_LRT.jpg'),(140,'caseylow','upload/43_melati-ads_Why.jpg'),(146,'ling\'s','upload/329_1.jpg'),(147,'ling\'s','upload/221_2.jpg'),(148,'ling\'s','upload/155_3.jpg'),(149,'ling\'s','upload/364_4.jpg'),(150,'lings','upload/235_1.jpg'),(151,'lings','upload/235_2.jpg'),(152,'lings','upload/355_3.jpg'),(153,'lings','upload/287_4.jpg');

--
-- Table structure for table `user_youtube_video`
--

CREATE TABLE `user_youtube_video` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `username` text NOT NULL,
  `image` text,
  `link` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_youtube_video`
--

INSERT INTO `user_youtube_video` VALUES (3,'How Design, Print and Install','vendor','upload/412_hd-youtube-logo-png-transparent-background-20.png','https://www.youtube.com/embed/joY8Yf_vzMc'),(4,'Mural Wallpaper Printing','vendor','upload/108_2.jpg','https://www.youtube.com/embed/y1g9krpaDFs'),(5,'Canvas Printing','vendor','upload/177_hd-youtube-logo-png-transparent-background-20.png','https://www.youtube.com/embed/f5Sv3dWJmQs'),(8,'KS Knight Steel Company Profile','Kenkoo','upload/343_Screenshot_20210329_140131_edit_562369005736063.jpg','https://www.youtube.com/embed/4Twb_k3nbxY'),(9,'Thanks for supporting us','Kenkoo','upload/239_Screenshot_20210426_171817.jpg','https://www.youtube.com/embed/2Hx5RxKnWoc'),(10,'Shampoo ','classic','upload/167_IMG_20201026_141228.jpg','https://www.youtube.com/embed/6cZaTTfqnI8'),(11,'Shampoo ','classic','upload/432_IMG_20201026_141202.jpg','https://www.youtube.com/embed/_Dca2BUBsRU'),(12,'Shampoo ','classic','upload/43_IMG_20201026_141248.jpg','https://www.youtube.com/embed/LLhanm2ZQR4'),(13,'BeeBeige UV SPF50 perfect skin concealer with instant glowing effect','Moonsoul','upload/431_133f80b0-18f6-4566-bbea-e70fe9851570.JPG','https://www.youtube.com/embed/LwysMHfQIvc');

--
-- Table structure for table `vehicle_type`
--

CREATE TABLE `vehicle_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vehicle_type`
--

INSERT INTO `vehicle_type` VALUES (1,'Type A'),(2,'Type B');

--
-- Table structure for table `vehicles`
--

CREATE TABLE `vehicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vehicle_type` text NOT NULL,
  `plate_no` text NOT NULL,
  `chase_number` text NOT NULL,
  `plate_code` text NOT NULL,
  `emirates` text NOT NULL,
  `plate_type` text NOT NULL,
  `tc_no` text NOT NULL,
  `owner_name` text NOT NULL,
  `emirates_side1` text NOT NULL,
  `emirates_side2` text NOT NULL,
  `post_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vehicles`
--

INSERT INTO `vehicles` VALUES (1,'Truck002','12-8-2020','12222','1233322klo','','','','','','','0000-00-00'),(2,'Truck003','12-8-2020','12222klo','1233322','','','','','','','0000-00-00'),(3,'vehicle001','5214784596','ghfhf1225','v25147844','gfds125445','hhhjju','12233','mmmm','','','0000-00-00'),(4,'vehicle 3','mn21145','ggff12254','bvggf1254','vffdh12254','hhhjju','t1254556','arunn','','','0000-00-00'),(5,'2','5214784596h','12222m','bvggf1254i','gfds125445j','hhhjjuk','12233l','mmmmn','transupload/113_Hydrangeas.jpg','transupload/97_Desert.jpg','0000-00-00');

--
-- Table structure for table `youtube`
--

CREATE TABLE `youtube` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `link` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `youtube`
--

INSERT INTO `youtube` VALUES (3,'pan card update ','https://www.youtube.com/embed/awxYVxI6ILg\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture');

--
-- Table structure for table `youtube_video_cost`
--

CREATE TABLE `youtube_video_cost` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `price` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `youtube_video_cost`
--

INSERT INTO `youtube_video_cost` VALUES (1,'2');


