--
-- Host: localhost    Database: exotic
-- ------------------------------------------------------


--
-- Table structure for table `account`
--

CREATE TABLE `account` (
  `id` tinyint(5) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `password` varchar(30) NOT NULL default '',
  `firstname` varchar(30) NOT NULL default '',
  `secondname` varchar(30) NOT NULL default '',
  `email` varchar(60) NOT NULL default '',
  `phone` varchar(20) NOT NULL default '',
  `last_visit` datetime NOT NULL default '0000-00-00 00:00:00',
  `admin` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=koi8r;

--
-- Dumping data for table `account`
--

INSERT INTO `account` VALUES (1,'charles','charles','no','no','charles.aunger@eknowlogy.com','no','2006-09-28 20:24:03',0),(2,'julian','golfgolf','no','no','julian.spender@stayina.com','no','2006-10-13 10:51:07',0),(3,'jerry smythe','coral','no','no','jerry@tritell.com','no','2006-10-18 14:36:08',0),(4,'julian1','golf','no','no','julian@coralestatesuk.com','no','2006-11-28 19:44:24',0),(5,'a','123456','no','no','exchange@infocreek.com','no','2006-11-30 12:55:17',0),(6,'ilya','qazwsx','no','no','ilya@khamushkin.com','no','2006-12-01 13:39:05',0);

--
-- Table structure for table `account_to_product`
--

CREATE TABLE `account_to_product` (
  `id` tinyint(5) NOT NULL auto_increment,
  `account` tinyint(5) NOT NULL default '0',
  `product` tinyint(5) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=koi8r;

--
-- Dumping data for table `account_to_product`
--

INSERT INTO `account_to_product` VALUES (1,1,1),(4,5,1),(3,4,15),(5,6,7),(6,4,1);

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` tinyint(5) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=koi8r;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` VALUES (2,'Dominican Republic','The Dominican Republic is<em><strong> </strong></em>one of the Caribbean\'s most popular islands with stunning tropical beaches and beautiful scenery. This island is baked in glorious sunshine and offers something for everyone, from exploring the colonial architecture to trying one of the many watersports. Prepare to be enchanted by the friendly islanders, beautiful scenery and hypnotic rhythm of the merengue. The Dominican Republic represents an excellent investment opportunity.'),(7,'Thailand','Thailand is an amazing country with an enchanting culture which has earned it the compliment of &quot;Land of Endless Smiles&quot;. For those seeking pure relaxation, Thailand\'s coastline and islands are sensational, with glorious sun-soaked, white sandy beaches lapped by crystal clear warm waters. The quality of developments and investment opportunities are unrivalled at present.'),(6,'Morocco','An exotic blend of old and new, blessed with sun-drenched beaches, ancient medinas and colourful souks. Morocco is taking foreign property investment very seriously with huge investment in infrastructure. The stunning developments promise excellent returns as well as an ideal place to explore this fascinating country.');

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` tinyint(4) NOT NULL auto_increment,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(150) NOT NULL default '',
  `short_body` text NOT NULL,
  `body` text NOT NULL,
  `source` varchar(80) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `date` (`date`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=koi8r;

--
-- Dumping data for table `news`
--

INSERT INTO `news` VALUES (2,'2006-09-27 08:52:27','Condominiums in the Hills','Tamarind Hills is without doubt one of the best located and thoughtfully designed residential property projects in Phuket.','Situated on the hillside above the beautiful Band Tao Beach, Tamarind Hills offers purchasers a chance to invest in one of the worlds most idyllic location where they can hope to achieve substantial capital gains, excellent investment yields and the advantage of owning a superb property in Asias premier resort destination.  Tamarind Hills comprises four phases of spacious and generously proportioned two and three-bedroom luxury residential apartment and an exclusive Boutique Resort &amp; Spa . Residents will also have use of the luxurious Beach Club situated just three minutes drive away and a host of other excellent on-site facilities including nine swimming pools, two international restaurants and a tennis court.  All apartments at tamarind Hills have spectacular panoramic sea views over the beautiful Andaman Sea.','www.exoticproperties.com'),(3,'2006-09-27 08:52:50','Turtle Cove Phuket - an Oasis by the beach','We are proud to introduce you to Turtle Cove, an exclusive low-rise development situated in an area of outstanding natural beauty .','Uniquely positioned on Mai Khao beach , one of the island\'s finest stretches of white sand, this will be peaceful and secluded development . With spectacular views of the Andaman sea and the lush tropical landscape of Nai Ying National Park ,turtle Cove offers and affordable opportunity to experience some truly memorable holiday.<br />\r\n<br />','www.exoticproperties.com'),(11,'2006-11-30 16:04:37','Club Lersuang, Phuket','Only 6 apartments remain in the Club Lersuang development in Phuket','Luxury Apartments &amp; Pent House. Situated only 4 minutes walk to the beach. Our new project Club Lersuang comprising 2, 3,and 4 bedroom luxury apartments surrounding a large shared pool hidden in lush tropical vegetation. 65 luxury 1,2 and 3 bedroom apartments with pent house. <br />\r\n<br />\r\nThe standard Lersuang quality of build. <br />\r\n<br />\r\nFacilities included.... <br />\r\n1. Huge 250 meter swimming pool. <br />\r\n2. 24 hours reception. <br />\r\n3. Restaurant. <br />\r\n4. Fully equiped gym and fitness center. <br />\r\n5. Sauna. <br />\r\n6. Steam room. <br />\r\n7. Jacuzzi. <br />\r\n8. Internet cafe (ADSL). <br />\r\n9. Games room. <br />\r\n10. 24 hours security. <br />\r\n11. Tropical landscaped gardens.','www.exoticproperties.com'),(10,'2006-11-30 15:53:46','Punta Perla - a stunning development in Dominican Republic','The amazing Punta Perla development has won &quot;Best International Property&quot;..','Punta Perla&nbsp; won<br />\r\n<img width=\"16\" height=\"16\" src=\"http://www.propertyawards.net/images2/star.gif\" alt=\"\" /><img width=\"16\" height=\"16\" src=\"http://www.propertyawards.net/images2/star.gif\" alt=\"\" /><img width=\"16\" height=\"16\" border=\"0\" src=\"http://www.propertyawards.net/images2/star.gif\" alt=\"\" /><img width=\"16\" height=\"16\" src=\"http://www.propertyawards.net/images2/star.gif\" alt=\"\" /> Best International Development - Caribbean<br />\r\n<br />\r\n12th International Property Awards presentation dinner in London on November 3, 2006, saw Punta Perla win Best Caribbean Development category. The awards have been dubbed &quot;the Oscars of the Property Industry&quot;<br />\r\n<br />\r\nFind out more in our Dominican Republic property section.','www.exoticproperties.com');

--
-- Table structure for table `pages_meta`
--

CREATE TABLE `pages_meta` (
  `id` int(3) NOT NULL auto_increment,
  `slug` varchar(50) NOT NULL default '',
  `title` varchar(175) NOT NULL default '',
  `description` text NOT NULL,
  `keywords` varchar(240) NOT NULL default '',
  `content` text NOT NULL,
  `parent` int(11) NOT NULL default '0',
  PRIMARY KEY  (`slug`),
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pages_meta`
--

INSERT INTO `pages_meta` VALUES (3,'home','Home','about property sales','property sales','<table width=\"490\" cellspacing=\"1\" cellpadding=\"1\" border=\"1\" align=\"\" summary=\"\">\r\n    <tbody>\r\n        <tr>\r\n            <td><font size=\"1\">Exotic Property Sales are members of the Association International Property Professionals.The AIPP has been set up to guide and to regulate the international property industry. It will give the buyer of international property confidence in choosing where to spend their money. Companies who are listed as Members have signed up to follow the industry <a href=\"http://www.aipp.org.uk/code_of_conduct.asp\" target=\"_self\">Code of Conduct</a>, established to help the consumer in buying overseas. These guidelines dictate that a professional approach is followed and that companies act with honesty, transparency and integrity at all times. Any failure in their actions will lead to disciplinary action to which, once again, they have agreed.</font></td>\r\n            <td><img width=\"60\" height=\"103\" src=\"/pictures/pages/Image/AIPPMEMBER(1).jpg\" alt=\"\" /><br />\r\n            </td>\r\n        </tr>\r\n    </tbody>\r\n</table>',0),(4,'about_us','About Exotic Properties - Real Estate and Property in Caribbean, Thailand  & Dominican Republic','Exotic Properties - Real Estate and Property specialists for apartments and villas in the Caribbean, Thailand  & Dominican Republic. Beach front property.','Caribbean Real Estate Dominican Republic Thailand Property','<div><strong>About Us</strong></div>\r\n<p><span>Exotic Property Sales Ltd is a </span>UK<span> registered company with offices in Brighton Marina, </span>East Sussex.</p>\r\n<p><span>We have worked in the Real Estate market starting in the Costa del Sol, </span>Spain and then Bulgaria.</p>\r\n<p><span>We have used our many contacts to source what we consider to be excellent property investment in some of the most alluring and popular areas of the world, where foreign investors are highly active at this time.</span></p>\r\n<p><span>Our company carries out due diligence on every new developer, backed by our retained </span>UK lawyers in Brighton<span>.&nbsp;This reassures you that we have asked all the right questions, and seen all relevant land titles, building licenses etc, before introducing the developments to you the buyer.</span></p>\r\n<p><span>Our property advisors are exactly that.&nbsp;Mature property investors themselves, with portfolios including </span>UK<span> as well as foreign property portfolios.&nbsp;They speak your language, and are highly knowledgeable in all areas of property investment.</span></p>\r\n<p><span>Whether this is the first time you are buying abroad, an experienced buyer or a major investor, Exotic Property Sales has the product, experience and knowledge to help you make an informed and successful property purchase</span></p>',0),(5,'properties','Properties','properties for sale','','',0),(6,'guide','Buyers guide','guide to by','','<br />\r\nOur buyers guides provide useful information for your chosen area of investment. If you would like to know more when you register an interest in a property one of our experienced advisors (they are not sales people - they are property investors themselves) will be able to tell you more.',0),(27,'Dominican Republic','Dominican Republic buyers guide','Buying Real Estate and Beachfront Property in the Dominican Republic','Buying Real Estate and Beachfront Property in the Dominican Republic','<br />\r\n<font face=\"Arial, sans-serif\"><font size=\"2\"><strong>The Dominican Republic</strong></font></font>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">The Land Registry Law of 1947 and its amendments govern real estate transactions in the Dominican Republic. Property ownership is proved by a &lsquo;Title Certificate&rsquo;, which is issued by the corresponding Title Registry. The required steps to convey or transfer ownership of real estate from a Seller to a Buyer are the following:</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">1. Purchase and Sale Agreement</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">Buyer and Seller must sign a &lsquo;Purchase and Sale Agreement&rsquo; before a Public Notary who will authenticate the signature of the parties involved in the transaction. (Notaries in the Dominican Republic are required to have a law degree). The Purchase and Sale Agreement has to contain the legal description of the property, the agreed sale price, payment and other conditions and stipulations of sale.</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">2. Payment of Tax</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">In practice and by custom, the Buyer has the duty to pay at the corresponding Internal Revenue Office the appropriate taxes to convey or transfer ownership of real estate. The Seller must provide, if applicable, payment of the Impuesto sobre las Viviendas Suntuarias y los Solares Urbanos no Edificados (IVSS).</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">3. Deposit of Documents</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">After payment of tax, the Seller has to deposit at the corresponding Title Registry, the following documents:</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">A. Original of the Purchase and Sale Agreement</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">B. Title Certificate of the property (Duplicado del Dueno)</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">C. Original document evidencing tax payment</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">D. Copy of Buyer&rsquo;s and Seller&rsquo;s Identification card (Cedula de Identidad y Electoral or passport)</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">E. If applicable, any document authorizing the Title Registry to cancel any mortgage affecting the property.</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">4. Issuance of the Title Certificate</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">The Title Registry will review that all requirements and documents are fulfilled and completed to proceed with the recording of the new sale. The Title Registry will cancel the submitted Title Certificate and issues a new Title Certificate in favour of the Buyer. The time from the filing of the documents to issue the new Title Certificate may vary from time to time, depending on the amount work that the Title Registry has at that moment, usually it takes one month. Once issued the Title Certificate, Buyer may with its personal ID retire the Title Certificate in its favour or may grant to an attorney a power authorising its attorney to retire the Title Certificate.</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\"><u><strong>Due Diligence</strong></u></font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">The process below is carried out by Exotic Property Sales prior to accepting any development for sale. </font></font> </p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">Before purchasing a property, it is recommended that the Buyer be assisted by a title company to do the corresponding due diligence and title research. To initiate the due diligence the title company must be provided with the following documents:</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">1. Copy of the Title Certificate of the property</font></font></p>\r\n<ol start=\"2\">\r\n    <li>\r\n    <p style=\"margin-bottom: 0cm;\"><font face=\"Arial, sans-serif\"><font size=\"2\">Copy 	of the survey plan of property, issued by Direccion General de 	Mensuras Catastrales. </font></font> 	</p>\r\n    </li>\r\n    <li>\r\n    <p><font face=\"Arial, sans-serif\"><font size=\"2\">Copy of Seller&rsquo;s 	identification card (Cedula de Identidad y Electoral or </font></font> 	</p>\r\n    </li>\r\n</ol>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">Passport. </font></font> </p>\r\n<ol start=\"4\">\r\n    <li>\r\n    <p><font face=\"Arial, sans-serif\"><font size=\"2\">Copy of the tax 	receipt evidencing the last payment of IVSS or original 	certification from the Internal Revenue Office, declaring that the 	property in exempted from the payment of IVSS. </font></font> 	</p>\r\n    </li>\r\n</ol>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">If the Seller is a legal entity:</font></font></p>\r\n<ol>\r\n    <li>\r\n    <p><font face=\"Arial, sans-serif\"><font size=\"2\">Copy of the 	corporate documents, including Bylaws, Shareholders and/or </font></font> 	</p>\r\n    </li>\r\n</ol>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">Board of Directors Resolution authorising the sale of the property and granting power to sign the documents on behalf of the company.</font></font></p>\r\n<ol start=\"2\">\r\n    <li>\r\n    <p><font face=\"Arial, sans-serif\"><font size=\"2\">Satisfactory 	evidence that the company is in good standing with applicable </font></font> 	</p>\r\n    </li>\r\n</ol>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">Governmental authorities and complies with existing laws, is duly recorded with applicable governmental authorities and/or registries.</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">If the subject property is a condo:</font></font></p>\r\n<ol>\r\n    <li>\r\n    <p style=\"margin-bottom: 0cm;\"><font face=\"Arial, sans-serif\"><font size=\"2\">Copy 	of the condominium declaration </font></font> 	</p>\r\n    </li>\r\n    <li>\r\n    <p style=\"margin-bottom: 0cm;\"><font face=\"Arial, sans-serif\"><font size=\"2\">Copy 	of the condominium regulations </font></font> 	</p>\r\n    </li>\r\n    <li>\r\n    <p style=\"margin-bottom: 0cm;\"><font face=\"Arial, sans-serif\"><font size=\"2\">Copy 	of the survey plan of the property, issued by Direccion General de 	Mensuras Catastrales </font></font> 	</p>\r\n    </li>\r\n    <li>\r\n    <p><font face=\"Arial, sans-serif\"><font size=\"2\">Evidence that all 	maintenance fees or assessments of any kind are paid. </font></font> 	</p>\r\n    </li>\r\n</ol>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\"><u><strong>Tax Payment</strong></u></font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">The total tax payment for the conveyance of the property is 3% of the property value established by the Internal Revenue Office. Also, all contribution in kind of a property to a company is subject to pay a 3% based on the contribution value.</font></font></p>\r\n<p><br />\r\n<br />\r\n</p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\"><u><strong>Purchase of Real Estate by Foreigners</strong></u></font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">There are no restrictions on foreigners purchasing a property in the Dominican Republic. Formerly, Decree 2543 of March 22 1945 and its amendments required that foreigners obtain Presidential approval before buying a property. Decree 21-98 of January 8 1998 abolished this regulation and established as the only requirement that the Title Registry keeps records, of all purchases made by foreigners.</font></font></p>\r\n<p><font face=\"Arial, sans-serif\"><font size=\"2\">Currently, there is no legislation in a language that sets forth the procedures for which a foreign company may purchase a property in the Dominican Republic. In practice, however, foreign companies must satisfy, in addition to the requirements established, the requirements set for a national company to be able to acquire real estate. In addition the following documents are also required:</font></font></p>\r\n<ol>\r\n    <li>\r\n    <p><font face=\"Arial, sans-serif\"><font size=\"2\">Incorporation 	documents duly legalised by the Consulate of the Dominican Republic 	at the country where the company was originally incorporated and 	translated into Spanish (by a legal interpreter). </font></font> 	</p>\r\n    </li>\r\n</ol>\r\n<ol start=\"2\">\r\n    <li>\r\n    <p><font face=\"Arial, sans-serif\"><font size=\"2\">Minutes of the 	Shareholders Resolution appointing the current Board of Directors. </font></font> 	</p>\r\n    </li>\r\n</ol>\r\n<ol start=\"3\">\r\n    <li>\r\n    <p><font face=\"Arial, sans-serif\"><font size=\"2\">Minutes of the 	Shareholders or Board of Directors Resolution of the Company, 	granting power to the company&rsquo;s representative to acquire the 	property. </font></font> 	</p>\r\n    </li>\r\n</ol>\r\n<ol start=\"4\">\r\n    <li>\r\n    <p><font face=\"Arial, sans-serif\"><font size=\"2\">Tax 	identification number of the company granted by the Internal Revenue 	Office. </font></font> 	</p>\r\n    </li>\r\n</ol>',6),(7,'guide_thailand','Thailand buyers guide','Buying Real Estate and Beachfront Property in Thailand','Buying Real Estate and Beachfront Property in Thailand','<br />\r\nOur Thailand buyers guide is currently not available please email for the latest version<br />\r\n<br />\r\n<a href=\"http://exotic.infocreek.com/\"><br />\r\n</a>',6),(9,'news','News','bjkhjkhjkh','ddd','',0),(10,'contact','Contact us','contact us...','','<p>Our business partners are chosen for their first class reputation, companies like TTT Moneycorp and St James Place. We aim to provide the highest standards of service and professionalism to all our clients, this is borne out through our membership of the AIPP (Association International Property Professionals). The code of conduct we abide by ensures you can be confident of the highest levels of service from Exotic Property Sales. <br />\r\n</p>\r\n<div>Exotic Property Sales Ltd <br />\r\nSuite 7 <br />\r\nThe Octagon <br />\r\nBrighton Marina Village <br />\r\nEast Sussex <br />\r\nBN2 5WA <br />\r\nTelephone 01273 626139 <br />\r\nFax: 01273 676971 <br />\r\nEmail: info@exoticpropertysales.com<br />\r\n<br />\r\n<a href=\"http://www.aipp.org.uk/\"><img width=\"70\" height=\"120\" src=\"/pictures/pages/Image/AIPPMEMBER.jpg\" alt=\"\" /></a><br />\r\n<br />\r\n<br />\r\n<br />\r\n<table width=\"16\" height=\"23\" cellspacing=\"1\" cellpadding=\"1\" border=\"1\" align=\"\" summary=\"\">\r\n</table>\r\n<table width=\"0\" cellspacing=\"1\" cellpadding=\"1\" border=\"1\" align=\"\" summary=\"\">\r\n</table>\r\n</div>',0),(11,'login','Log in','login page','hjghjg','',0),(12,'privacy','Privacy','privacy page','','<p><span><span>Privacy - Consent to Collect, Process and Transfer Personal Data</span></span><span><br />\r\n<br />\r\n</span><span><span>Use of this Web site may result in personal data about you being collected or processed by, and transferred to, Exotic Property Sales Ltd in countries where legal systems may provide only limited protection for personal data. Such transfers may include personal data you directly provide (such as your name or email address) and personal data automatically collected or processed (such as your internet domain or IP address) as part of the operation of this Web site or during the course of your activities on or use of this Web site. By using this Web site, you expressly consent to any collection, processing, transfer or use of any personal data. If you do not agree and consent to any transfer, processing, collection or use of such information, please discontinue your access or use of this Web site. </span></span><strong><span><br />\r\n<br />\r\n<span>Where collection, processing or transfer of personal data results from your use of this Web site, Exotic Property Sales Ltd does not warrant or represent that you will have the ability to control or prevent the collection, processing, use, or further transfer of such information; however, Exotic Property Sales Ltd will not transfer any such personal data to any company outside of the Exotic Property Sales Ltd family of companies without your prior consent. You understand and agree that, with respect to personal data, you may not be able to access such information in the future; correct inaccuracies, if any; erase or cause removal of such information; or block collection or transfer of such information. Exotic Property Sales Ltd makes no other representation regarding the collection, processing or transfer or use of any personal data. In no event shall Exotic Property Sales Ltd be liable to you or others for any damages resulting from any transfer, processing, collection or use of personal data resulting from your use of this Web site. </span></span></strong></p>\r\n<p><span>Exotic Property Sales Ltd may use &quot;cookies&quot; in connection with operation of its Web site(s). Cookies are small pieces of information that are stored on your computer by the Exotic Property Sales Ltd server (passing through your Netscape Navigator&reg; or Internet ExplorerTM browser). Cookies are used for record-keeping purposes&ndash;the stored information can be retrieved by the same Exotic Property Sales Ltd server that created the cookie. This allows Exotic Property Sales Ltd to personalize, monitor, or regulate the use of this site, and also permits Exotic Property Sales Ltd to automate the access and data-entry functions of the site (e.g., login information), to store on-line ordering information for purchases you may make while visiting the site, and to tailor the appearance or presentation of the site to your preferences or interests. In addition, cookies allow Exotic Property Sales Ltd to track usage of the site (e.g., to determine which areas of the site are useful or popular) and permit us to improve and update the site effectively. </span></p>\r\n<p><span>The use of cookies is common in the industry, and they are used at most major sites. Cookies will not be used to pass any information from your computer except the specific information placed into the cookie from one participating Exotic Property Sales Ltd Web site when the cookie is retrieved by another participating Exotic Property Sales Ltd web site. You may wish to adjust your Web browser to inform you whenever a cookie is to be used, or to reject all cookies automatically. However, if you elect not to accept cookies, some parts of the Web site may not function properly or permit access. For more information on cookies, see http://www.cookiecentral.com/faq.htm </span></p>\r\n<div><span>Disclaimer</span></div>\r\n<p><span>This Web site is designed to provide general information about the Exotic Property Sales Ltd and its subsidiary and associated undertakings and their respective businesses. <br />\r\n<br />\r\nIt is essential that you verify all information with us before taking any action in reliance upon it. It is a condition of allowing you free access to the material on this Web site that you accept that we will not be liable for any action that you may take in reliance on the information. </span></p>\r\nThis Web site complies with United Kingdom<span> law only. <br />\r\n<br />\r\nExotic Property Sales Ltd will not accept responsibility for compliance with the laws of any other jurisdiction.</span>',0),(13,'terms','Terms','terms page','','',0),(14,'links','Links','links page','','<a target=\"_blank\" href=\"http://www.puntaperlasales.com/index.shtml\">Linked site</a>',0),(15,'sitemap','Sitemap','sitemap page','','',0),(16,'currency','Currency','currency page','','<br />\r\n<script src=\"http://www.moneycorp.com/marketing/currency_converter.js.cfm?Agentid=10023097&ButtonID=2\"></script>',0),(20,'send2friend','Send page to a friend','','','',0),(28,'Morocco Buyers Guide','Morocco buyers guide','Buying Real Estate and Beachfront Property in Morocco','Buying Real Estate and Beachfront Property in Morocco','Our Morocco buyers guide is currently not available please email for the latest version<br />\r\n<br />\r\n<br />\r\n<a href=\"http://exotic.infocreek.com/\"><br />\r\n</a>',6);

--
-- Table structure for table `picture`
--

CREATE TABLE `picture` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `path` varchar(200) NOT NULL default '',
  `product` int(11) NOT NULL default '0',
  `is_main` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=258 DEFAULT CHARSET=koi8r;

--
-- Dumping data for table `picture`
--

INSERT INTO `picture` VALUES (16,'','pic16.jpg',7,0),(17,'Golf Apartments','pic17.jpg',7,1),(64,'Snorkelling','pic64.jpg',1,1),(19,'','pic19.jpg',8,0),(29,'Front of building','pic29.jpg',8,1),(14,'Punta Perla overhead','pic14.jpg',7,0),(21,'Infinity Heights Living Room','pic21.jpg',8,0),(22,'Surin Beach2','pic22.jpg',8,0),(31,'Linked Golf Villa','pic31.jpg',13,1),(32,'Punta Perla Golf Villa','pic32.jpg',13,0),(47,'Mai Khao Beach','pic47.jpg',1,0),(33,'Punta Perla Beach','pic33.jpg',13,0),(34,'Punta Perla Land & Sea','pic34.jpg',13,0),(35,'Punta Perla Townhouses','pic35.jpg',14,1),(37,'Punta Perla Beach','pic37.jpg',14,0),(38,'Punta Perla Coastal Aerial','pic38.jpg',14,0),(39,'Star Island Aerial','pic39.jpg',15,1),(40,'Star Island Interior','pic40.jpg',15,0),(41,'Star Island Marina','pic41.jpg',15,0),(42,'Punta Perla Beach','pic42.jpg',15,0),(68,'Mai Khao Beach','pic68.jpg',1,0),(44,'Turtle Cove Masterplan','pic44.jpg',1,0),(45,'Turtle Cove aerial','pic45.jpg',1,0),(48,'2 bed floor plan','pic48.jpg',8,0),(49,'2 bed roof plan','pic49.jpg',8,0),(50,'3 Bed Floor Plan','pic50.jpg',8,0),(51,'3 bed Roof plan','pic51.jpg',8,0),(119,'Pool View','',17,0),(54,'Les Cascades, Saidia','pic54.jpg',19,1),(55,'Les Cascades, Saidia','pic55.jpg',19,0),(57,'Les Cascades, Saidia','pic57.jpg',19,0),(127,'Chaweng Panoramic','',45,1),(65,'Interior impression','pic65.jpg',1,0),(66,'Interior impression','pic66.jpg',1,0),(67,'Floor Plan','pic67.jpg',1,0),(69,'Development  as of 15 Nov 2006','pic69.jpg',1,0),(72,'Living Room','pic72.jpg',22,0),(73,'Dining Room','pic73.jpg',22,0),(74,'Bedroom','pic74.jpg',22,0),(75,'Kitchen','pic75.jpg',22,0),(76,'Location Map','pic76.jpg',22,0),(77,'Chaweng Residence','pic77.jpg',26,1),(78,'Swimming Pool','pic78.jpg',26,0),(79,'Swimming Pool & View','pic79.jpg',26,0),(80,'View from Chaweng','pic80.jpg',26,0),(82,'Chaweng Kitchen','pic82.jpg',26,0),(84,'Penthouse interior','pic84.jpg',30,1),(85,'Penthouse interior','pic85.jpg',30,0),(86,'Balcony of Type D property','pic86.jpg',30,0),(87,'View from development','pic87.jpg',30,0),(88,'test image 55','',36,1),(122,'Les Cascades Golf','',19,0),(91,'','',36,0),(92,'TESTING','',36,0),(111,'Beach Apartments','',16,1),(120,'Golf Apartments','',17,1),(121,'Golf Apartments','',17,0),(118,'Clubhouse Pool','',17,0),(112,'Beach Apartments 2','',16,0),(113,'Location of apartments','',16,0),(252,'View from the site','',45,0),(253,'','',45,0),(254,'View from the site','',45,0),(255,'Detached House','',22,1),(256,'Town House','',22,0),(257,'Twinhouse','',22,0);

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

CREATE TABLE `product` (
  `id` tinyint(5) NOT NULL auto_increment,
  `product_category` tinyint(5) NOT NULL default '0',
  `name` varchar(30) NOT NULL default '',
  `description` text NOT NULL,
  `pub_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `price` int(11) NOT NULL default '0',
  `general_picture` varchar(200) NOT NULL default '',
  `location` tinyint(5) NOT NULL default '0',
  `isSpecOffer` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=koi8r;

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

INSERT INTO `product` VALUES (1,1,'Turtle Cove','We are proud to introduce you to Turtle Cove an exclusive resort in the stunning Island of Phuket. Uniquely positioned on Mai Khao beach one of the islands finest stretches of white sand, with spectacular views of the Andaman Sea and the lush tropical landscape of Nai Yang National park.  Turtle Cove offers five star resort facilities including a large swimming pool, restaurant cafe and bar, concierge service and spa. A wide range of beach equipment will be available.     <br />\r\n&nbsp;<br />\r\n<strong>Easily Accessible</strong><br />\r\n<p align=\"justify\"> Turtle Cove is easily accessible and only a 10 minutes drive from Phuket International Airport. Nearby are some of the world&rsquo;s leading 5-star hotels and premier golf courses, namely Blue Canyon and Mission Hills.</p>\r\n<br />\r\n- Large swimming pool <br />\r\n- Oriental spa <br />\r\n- Gymnasium <br />\r\n- Internet cafe<br />\r\n- Restaurant <br />\r\n- 24 hours security <br />\r\n- 24 hours concierge and reception <br />\r\n- Laundry service<br />\r\n<br />\r\nTypical dimesions<br />\r\n<br />\r\n<table width=\"364\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#e8e8e8\" border=\"1\">\r\n    <tbody>\r\n        <tr class=\"t1\">\r\n            <td width=\"128\" class=\"t2\">\r\n            <div align=\"center\">Area</div>\r\n            </td>\r\n            <td width=\"131\">\r\n            <div align=\"center\" class=\"t2\">Dimentions (m)</div>\r\n            </td>\r\n            <td width=\"105\">\r\n            <div align=\"center\" class=\"t2\">Area (sqm)</div>\r\n            </td>\r\n        </tr>\r\n        <tr class=\"t1\">\r\n            <td height=\"20\">\r\n            <div align=\"center\">Master bedroom</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">4.5 x 5.5</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">24.75</div>\r\n            </td>\r\n        </tr>\r\n        <tr class=\"t1\">\r\n            <td height=\"20\">\r\n            <div align=\"center\">Master bathroom</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">2.5 x 3.0</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">7.5</div>\r\n            </td>\r\n        </tr>\r\n        <tr class=\"t1\">\r\n            <td height=\"20\">\r\n            <div align=\"center\">Guest bedroom</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">4.5 x 4.5</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">20.25</div>\r\n            </td>\r\n        </tr>\r\n        <tr class=\"t1\">\r\n            <td height=\"20\">\r\n            <div align=\"center\">Living area</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">4.5 x 5.0</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">22.5</div>\r\n            </td>\r\n        </tr>\r\n        <tr class=\"t1\">\r\n            <td height=\"20\">\r\n            <div align=\"center\">Dining</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">4.5 x 4.0</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">18.0</div>\r\n            </td>\r\n        </tr>\r\n        <tr class=\"t1\">\r\n            <td height=\"20\">\r\n            <div align=\"center\">Kitchen</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">3.4 x 4.5</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">15.3</div>\r\n            </td>\r\n        </tr>\r\n        <tr class=\"t1\">\r\n            <td height=\"20\">\r\n            <div align=\"center\">WC</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">1.6 x 3.0</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">4.8</div>\r\n            </td>\r\n        </tr>\r\n        <tr class=\"t1\">\r\n            <td height=\"20\">\r\n            <div align=\"center\">Terrace</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">n/a</div>\r\n            </td>\r\n            <td>\r\n            <div align=\"center\">27.0</div>\r\n            </td>\r\n        </tr>\r\n        <tr class=\"t1\">\r\n            <td height=\"20\">\r\n            <div align=\"center\" class=\"t2\">Total area</div>\r\n            </td>\r\n            <td>&nbsp;</td>\r\n            <td>\r\n            <div align=\"center\" class=\"t2\">140.0</div>\r\n            </td>\r\n        </tr>\r\n    </tbody>\r\n</table>\r\n<br />\r\n<br />\r\n<br />\r\n<strong><a href=\"http://www.turtlecovephuket.com/\">Visit the Turtle Cove Website</a><br />\r\n<br />\r\n<u>About the developer</u><br />\r\n</strong>\r\n<p align=\"justify\" class=\"t1\"><strong>Lersuang Group Holdings</strong> - As one of Phuket&rsquo;s leading project management companies, Lersuang Group Holdings fuse Thai character with the latest in design and construction. A pioneer in their field, several of the island&rsquo;s leading developments, including the luxury Lersuang Apartments and villas, have been built by Lersuang Group Holdings.</p>\r\n<p align=\"justify\" class=\"t1\"><br />\r\n</p><br />\r\n<script src=\"http://www.moneycorp.com/marketing/currency_converter.js.cfm?Agentid=10023097&ButtonID=2\"></script>','2006-09-27 08:59:28',213000,'',7,0),(8,0,'Infinity Heights Phuket','Infinity Heights is an exclusive development of 81 luxury residences offering 2 and 3 bedroom apartments with 27 Penthouses which enjoy expansive roof top terraces encompassing a tropical Sala, hard wood decking and an essential plunge pool.\r\n<p>The floorplans have been carefully designed to maximize space while including all the modern amenities you require to relax, enjoy and entertain.</p>\r\n<p>Careful attention has been taken to ensure Infinity Heights is constructed to the highest standards with particular attention to landscaping and creating a lush tropical environment to combine and enhance the area of Surin.</p>\r\n<p>Surin is a long casuarina &ndash; lined beach with crystal clear waters, pure white sands and with its perfect West Coast perspective offers some of the best sunset views in Phuket.</p>\r\n<p>The Surin Area has become renowned for quality and prestige as the premium location for the most exclusive properties in Phuket. As a result the area has attracted some of the finest restaurants and hotels offering a wide variety of choice for residents and visitors.</p>\r\n<p> Within just 10 minutes residences have access to the Laguna Phuket Group of Hotels, including the world renowned Laguna Golf Course, a wide array of restaurants and spas combined with sporting and recreational facilities.</p>\r\n<br />\r\n<p><a href=\"http://www.infinityheights.com\">visit the Infinity Heights website</a></p><br />\r\n<script src=\"http://www.moneycorp.com/marketing/currency_converter.js.cfm?Agentid=10023097&ButtonID=2\"></script>','2006-10-30 15:59:01',189900,'',7,1),(13,0,'Punta Perla Golf Villas','Punta Perla is a master planned resort situated on the Eastern tip of the Dominican Republic in the established area of Punta Cana. <br />\r\n<br />\r\nSet in approximately ten million square metres of natural prime Caribbean real-estate, Punta Perla offers the last beachfront development opportunity of this size in the Punta Cana region.<br />\r\n<br />\r\nFrom its conception, Punta Perla has been carefully planned to become one of the premier resorts in the Caribbean and will evolve into a first class living and vacation experience. Low density population of properties within the resort is key to the developer&rsquo;s plans for Punta Perla with only 11 people per acre all set in over 2,500 acres. <strong><br />\r\n<br />\r\n</strong>Luxurious villas, bungalows, townhouses and apartments will flank the tees, greens and fairways on the three signature golf courses. The choice of properties is varied, with two and three bed villas, townhouses and bungalows as well as a selection of apartments and penthouses. Many will be front line on the golf course with the hospitality and entertainment of one of the three clubhouses not far away.<br />\r\n<strong><br />\r\n<u>Linked Villas</u></strong><br />\r\n<p>The competitive price of the Golf Linked Villas<strong> </strong>(Poblados) belie their size, quality and position interspersed throughout the three magnificent signature golf courses. Each home offers stunning aspects of beautifully manicured fairways and beyond.</p>\r\n<p><u><strong>Private Villas</strong></u><br />\r\n</p>\r\n<p>Several different styles of private villas, most within their own generously proportioned private gardens, hug the edge of the golf courses. Grouped in small clusters, the villas and bungalows offer a level of quality and privacy rarely found. Designed to integrate the exterior with the interior, they offer the finest of living experiences. </p>\r\n<p>Each building is arranged around private tropical gardens, swimming pools and ornamental water features, which lead onto the course.</p>\r\n<br />\r\n<br />\r\n<br />\r\n* GUARANTEED RENTAL RETURN     <br />\r\n* NO CAPITAL GAINS TAX     <br />\r\n* NO INCOME TAX     <br />\r\n* NO PROPERTY PURCHASE TAX<br />\r\n<br />\r\nYou can visit the developers site here...<strong><a href=\"http://www.puntaperla.co.uk\">www.puntaperla.co.uk</a></strong><br />\r\n<script src=\"http://www.moneycorp.com/marketing/currency_converter.js.cfm?Agentid=10023097&ButtonID=2\"></script>','2006-11-08 14:50:20',212000,'',2,0),(7,1,'Punta Perla Golf Apartments','Punta Perla is a master planned resort situated on the Eastern tip of the Dominican Republic in the established area of Punta Cana. <br />\r\n<br />\r\nSet in approximately ten million square metres of natural prime Caribbean real-estate, Punta Perla offers the last beachfront development opportunity of this size in the Punta Cana region.<br />\r\n<br />\r\nFrom its conception, Punta Perla has been carefully planned to become one of the premier resorts in the Caribbean and will evolve into a first class living and vacation experience. Low density population of properties within the resort is key to the developer&rsquo;s plans for Punta Perla with only 11 people per acre all set in over 2,500 acres. <strong><br />\r\n<br />\r\n</strong>Luxurious villas, bungalows, townhouses and apartments will flank the tees, greens and fairways on the three signature golf courses. The choice of properties is varied, with two and three bed villas, townhouses and bungalows as well as a selection of apartments and penthouses. Many will be front line on the golf course with the hospitality and entertainment of one of the three clubhouses not far away.<br />\r\n<br />\r\nThe competitive price of the <strong>Golf Apartments </strong>belie their size, quality and position interspersed throughout the three magnificent signature golf courses. Each home offers stunning aspects of beautifully manicured fairways and beyond.  Each building is arranged around private tropical gardens, swimming pools and ornamental water features, which lead onto the course. Each solid wood terrace will benefit from its own built in spa pool and give stunning views of the surroundings.      <br />\r\n<br />\r\n<br />\r\n* GUARANTEED RENTAL RETURN     <br />\r\n* NO CAPITAL GAINS TAX     <br />\r\n* NO INCOME TAX     <br />\r\n* NO PROPERTY PURCHASE TAX<br />\r\n<br />\r\nYou can visit the developers site here...<strong><a href=\"http://www.puntaperla.co.uk\">www.puntaperla.co.uk</a></strong><br />\r\n<script src=\"http://www.moneycorp.com/marketing/currency_converter.js.cfm?Agentid=10023097&ButtonID=2\"></script>','2006-10-23 08:47:47',198000,'',2,0),(14,0,'Punta Perla Golf Townhouses','Punta Perla is a master planned resort situated on the Eastern tip of the Dominican Republic in the established area of Punta Cana. <br />\r\n<br />\r\nSet in approximately ten million square metres of natural prime Caribbean real-estate, Punta Perla offers the last beachfront development opportunity of this size in the Punta Cana region.<br />\r\n<br />\r\nFrom its conception, Punta Perla has been carefully planned to become one of the premier resorts in the Caribbean and will evolve into a first class living and vacation experience. Low density population of properties within the resort is key to the developer&rsquo;s plans for Punta Perla with only 11 people per acre all set in over 2,500 acres. <strong><br />\r\n<br />\r\n</strong>Luxurious villas, bungalows, townhouses and apartments will flank the tees, greens and fairways on the three signature golf courses. The choice of properties is varied, with two and three bed villas, townhouses and bungalows as well as a selection of apartments and penthouses. Many will be front line on the golf course with the hospitality and entertainment of one of the three clubhouses not far away.<br />\r\n<font color=\"#000000\"><strong><br />\r\n<u>Townhouses</u></strong></font><font color=\"#000000\"><br />\r\n</font>\r\n<p><font color=\"#000000\">The competitive price of the Golf Townhouses belie their size, quality and position interspersed throughout the three magnificent signature golf courses. Each home offers stunning aspects of beautifully manicured fairways and beyond. </font></p>\r\n<p><font color=\"#000000\">Each building is arranged around private tropical gardens and ornamental water features, which lead onto the course. The property has owners parking, direct access to the gold courses and they also benefit from individual plunge pools. </font><br />\r\n</p>\r\n<p><br />\r\n</p>\r\n* GUARANTEED RENTAL RETURN     <br />\r\n* NO CAPITAL GAINS TAX     <br />\r\n* NO INCOME TAX     <br />\r\n* NO PROPERTY PURCHASE TAX<br />\r\n<br />\r\nYou can visit the developers site here...<strong><a href=\"http://www.puntaperla.co.uk\">www.puntaperla.co.uk</a></strong><br />\r\n<script src=\"http://www.moneycorp.com/marketing/currency_converter.js.cfm?Agentid=10023097&ButtonID=2\"></script>','2006-11-08 15:09:23',215000,'',2,0),(15,0,'Star Island Punta Perla','The private gated community of Star Island offers one of the most prestigious positions within Punta Perla. Access is available only to owners and their guests who benefit from a private spa club with magnificent views. The central positioning of the apartments is in a tropical paradise of water, flora and fauna.<br />\r\n<br />\r\nThe stunning development of Star Island will house Apartments, Bungalows and Penthouses.<br />\r\n<br />\r\n<strong>Star Island Apartments</strong><br />\r\n<br />\r\nThe central   positioning of the apartments is in a tropical paradise of water, flora and   fauna.<br />\r\nLimited to only 66 exclusive apartments, set on a private island yet within minutes of the amazing facilities of the resort.<br />\r\n<strong><br />\r\nStar Island Bungalows<br />\r\n<br />\r\n</strong>The Star Island bungalows are all carefully positioned around the edge of Star Island and are the jewels of the marina. Each of the bungalows has 126.5m2 of living area set within a 300m2 plot, their own splash pool and a private mooring.<br />\r\n<br />\r\n<strong>About Punta Perla</strong><br />\r\n<br />\r\nPunta Perla is a master planned resort situated on the Eastern tip of the Dominican Republic in the established area of Punta Cana. <br />\r\n<br />\r\nSet in approximately ten million square metres of natural prime Caribbean real-estate, Punta Perla offers the last beachfront development opportunity of this size in the Punta Cana region.<br />\r\n<br />\r\nFrom its conception, Punta Perla has been carefully planned to become one of the premier resorts in the Caribbean and will evolve into a first class living and vacation experience. Low density population of properties within the resort is key to the developer&rsquo;s plans for Punta Perla with only 11 people per acre all set in over 2,500 acres. <strong><br />\r\n</strong><br />\r\nvisit the developers website here <a href=\"http://www.puntaperla.co.uk\">www.puntaperla.co.uk</a><br />\r\n<script src=\"http://www.moneycorp.com/marketing/currency_converter.js.cfm?Agentid=10023097&ButtonID=2\"></script>','2006-11-08 16:23:24',281000,'',2,0),(16,0,'Punta Perla Beach Apartments','Each apartment has a magnificent sea view. Only a few steps from the stunning Caribbean sea the design is set around the tropical gardens which give the feel of seclusion and luxury.\r\n<p>The beach and surrounding areas of the apartments are totally private living and are only accessible to residents and guests on Punta Perla.</p>\r\n<ul>\r\n    <li>GUARANTEED RENTAL RETURN</li>\r\n    <li>NO CAPITAL GAINS   TAX</li>\r\n    <li>NO INCOME TAX</li>\r\n    <li>NO PROPERTY PURCHASE TAX</li>\r\n</ul>\r\nPunta Perla is a master planned resort situated on the Eastern tip of the Dominican Republic in the established area of Punta Cana. <br />\r\n<br />\r\nSet in approximately ten million square metres of natural prime Caribbean real-estate, Punta Perla offers the last beachfront development opportunity of this size in the Punta Cana region.<br />\r\n<br />\r\nFrom its conception, Punta Perla has been carefully planned to become one of the premier resorts in the Caribbean and will evolve into a first class living and vacation experience. Low density population of properties within the resort is key to the developer&rsquo;s plans for Punta Perla with only 11 people per acre all set in over 2,500 acres. <strong><br />\r\n</strong><br />\r\nvisit the developers website here <a href=\"http://www.puntaperla.co.uk\">www.puntaperla.co.uk</a>\r\n<ul><br />\r\n    <br />\r\n</ul>\r\n<br />\r\n<script src=\"http://www.moneycorp.com/marketing/currency_converter.js.cfm?Agentid=10023097&ButtonID=2\"></script>','2006-11-08 16:34:19',292000,'',2,0),(17,0,'Le Jardin de Fleur, Saidia','Saidia is located along the Mediterranean coast of Northern Morocco          just 60km from Melilla, Oujda and Nador, international airports. Saidia is renowned for its beautiful, clean, white sandy beaches and crystal-clear water. Saidia itself is a pleasant resort town with a 17th century fortress and a 19th century kasbah, that makes a great base for excursions. The area is ideal for all types of water sports, with a lovely bay providing a safe place for sailing. Every August, the Music and Popular Arts Festival          gathers thousands of visitors to the town. The area is surrounded by a          natural bird preserve of marsh and woodland, and access to the main beach          is through a eucalyptus forest. <br />\r\n<p>&nbsp;</p>\r\n<p>Mediterrania Saidia has been carefully designed allowing only low          level, low density buildings and numerous parks, gardens and recreational          areas. The resort will encompass three 18-hole golf courses, luxury 4          and 5 star hotels, 740 berth marina, commercial centre including many          shops restaurants, beach bars, a thalassothermic Spa facility, aqua park,          cinema, equestrian centre, essentially all that anyone could desire from          a holiday resort!</p>\r\n<br />\r\n<strong>Le Jardin de Fleur sur Mer</strong> is a small apartment development                      of only 126 properties<strong> </strong>in a fantastic location overlooking                      the golf course out to Sea. It will consist of 2 bed/2 bath                      and 3 bed/3 bath apartments and 1 bed and 2 bed penthouses,                      all constructed low rise. The ground floor Apts will have                      <strong>very spacious gardens</strong> and the penthouses will have                      large terraces and solariums. Each property will have <strong>a                      designated parking bay</strong>. <br />\r\n<br />\r\nAll of the properties (even the ground floor) will have <strong>beautiful                      views to the beach and sea</strong> with some of the blocks having                      golf course views across a lake as well. Property owners on                      this development will enjoy the facilities of a spacious Club                      House, communal pool and childrens play are all within the                      complex. <br />\r\n<br />\r\nAll properties have a <strong>fully fitted kitchen</strong> with the                      latest appliances, <strong>hot/cold air conditioning</strong>, satellite                      TV and come <strong>fully furnished</strong> including garden or terrace                      furniture. All properties will be built according to European                      standards and will have a 10 year construction guarantee.                      <br />\r\n<br />\r\n<br />\r\n<strong>Special features</strong> of Le Jardin de Fleur sur Mer apartments                      include <br />\r\n<div style=\"width: 380px; margin-top: 5px; clear: both;\">\r\n<ul style=\"list-style-position: outside; margin-left: 0pt;\">\r\n    <li>Fully fitted kitchen                          </li>\r\n    <li>Fully furnished 						</li>\r\n    <li>Hot/Cold air conditioning                         </li>\r\n    <li>Club House 						</li>\r\n    <li>Communal pool and childrens play area                          </li>\r\n    <li>Designated parking bay</li>\r\n</ul>\r\n</div>\r\n<p><a href=\"http://www.lejardindefleur.com/site/home.html\"><strong>Visit the Le Jardin de Fleur homepage</strong></a><br />\r\n<br />\r\n</p>\r\n<p><br />\r\n</p>\r\n<br />\r\n<script src=\"http://www.moneycorp.com/marketing/currency_converter.js.cfm?Agentid=10023097&ButtonID=2\"></script>','2006-11-13 14:09:18',122369,'',6,0),(19,0,'Le Jardin de Fleur Les Cascade','Saidia is located along the Mediterranean coast of Northern Morocco just 60km from Melilla, Oujda and Nador, international airports. Saidia is renowned for its beautiful, clean, white sandy beaches and crystal-clear water. Saidia itself is a pleasant resort town with a 17th century fortress and a 19th century kasbah, that makes a great base for excursions. The area is ideal for all types of water sports, with a lovely bay providing a safe place for sailing. Every August, the Music and Popular Arts Festival gathers thousands of visitors to the town. The area is surrounded by a natural bird preserve of marsh and woodland, and access to the main beach is through a eucalyptus forest. <br />\r\n</p>\r\n<p>Mediterrania Saidia has been carefully designed allowing only low level, low density buildings and numerous parks, gardens and recreational areas. The resort will encompass three 18-hole golf courses, luxury 4 and 5 star hotels, 740 berth marina, commercial centre including many shops restaurants, beach bars, a thalassothermic Spa facility, aqua park, cinema, equestrian centre, essentially all that anyone could desire from a holiday resort!</p>\r\n<strong>Les Cascades is a truly stunning project</strong> in Mediterrania                      Saidia consisting of 50 townhouses in 3 different styles:                      Marguerite, Tulipe and Orchid&eacute;e. They all comprise                      of 3 bedrooms, 3 en-suite bathrooms and are built over 3 levels.                      The master bedroom is <strong>exceptionally spacious</strong> with a                      glass wall separating it from the bathroom. The properties                      will be built to a very high standard, with marble flooring                      throughout and German NOBILIA kitchens. <br />\r\n<br />\r\nThe design of our townhouses is <strong>modern Moroccan style</strong>                      with stainless steel and wooden accents and is truly unique                      with many special features such as the<strong> roof top swimming                      pool</strong> with a waterfall cascading to the ground. <br />\r\n<br />\r\nThe Townhouses also come fully furnished, with air-conditioning,                      a large clubhouse and beautifully landscaped gardens. Amongst                      many others, residents will also be able to enjoy the following                      amenities: <strong>putting green</strong>, communal swimming pool with                      <strong>a small beach</strong>, tennis courts, and a boule/petanque                      court. <br />\r\n<br />\r\n<strong>Special features</strong> of the Les Cascades project include                      <br />\r\n<div style=\"width: 380px; margin-top: 5px; clear: both;\">\r\n<ul style=\"list-style-position: outside; margin-left: 0pt;\"> <a href=\"http://www.findanoverseasproperty.com/location/morocco/mediterrania_saidia/index.asp\">    </a>\r\n    <li>Very spacious design                         </li>\r\n    <a href=\"http://www.findanoverseasproperty.com/location/morocco/mediterrania_saidia/index.asp\">    </a>\r\n    <li>From 140sq m up to 174sq m                         </li>\r\n    <a href=\"http://www.findanoverseasproperty.com/location/morocco/mediterrania_saidia/index.asp\">    </a>\r\n    <li>Fully furnished 						</li>\r\n    <a href=\"http://www.findanoverseasproperty.com/location/morocco/mediterrania_saidia/index.asp\">    </a>\r\n    <li>Roof Top pool with cascade                         </li>\r\n    <a href=\"http://www.findanoverseasproperty.com/location/morocco/mediterrania_saidia/index.asp\">    </a>\r\n    <li>Modern internal features                         </li>\r\n    <a href=\"http://www.findanoverseasproperty.com/location/morocco/mediterrania_saidia/index.asp\">    </a>\r\n    <li>Club House 						</li>\r\n    <a href=\"http://www.findanoverseasproperty.com/location/morocco/mediterrania_saidia/index.asp\">    </a>\r\n    <li>Putting Green and Tennis courts 						</li>\r\n    <a href=\"http://www.findanoverseasproperty.com/location/morocco/mediterrania_saidia/index.asp\">    </a>\r\n    <li>Boule/Petanque pitch</li>\r\n</ul>\r\n<strong><a href=\"http://www.lejardindefleur.com/site/home.html\">Visit the Le Jardin De Fleur homepage here<br />\r\n</a></strong> </div>\r\n<br />\r\n<script src=\"http://www.moneycorp.com/marketing/currency_converter.js.cfm?Agentid=10023097&ButtonID=2\"></script>','2006-11-13 17:30:59',185780,'',6,1),(22,0,'Lersuang Village','For the first time in Phuket, Lersuang Village offers buyers a<br />\r\nquality built house in paradise at a truly affordable price. <font face=\"Arial\"><br />\r\n</font>Lersuang Village is the first and only integrated residential <font face=\"Arial\"><br />\r\n</font>estate home project comprising 223 Town Houses, Twin Houses and <font face=\"Arial\"><br />\r\n</font>Single Houses. Located in the heart of Chengtalay on Srisoonthorn <br />\r\nroad and set amidst tropical trees in lushly landscaped surroundings<br />\r\nthese contemporary homes exude quality craftsmanship and functional <font face=\"Arial\"><br />\r\n</font>design at an affordable price. Lersuang Village is a self contained <font face=\"Arial\"><br />\r\n</font>community with a shared pool, clubhouse facilities, playground and <font face=\"Arial\"><br />\r\n</font>24 hour manned security. <br />\r\n<pre><font face=\"Arial\">Lersuang Village will be located just behind Phuket&rsquo;s newest <br />proposed retail center, Lersuang Retail Park, which will comprise a <br />full food market, cinema, bowling alley, and numerous retail shops. <br />Additionally, Lersuang Village will be within walking distance of <br />Thai schools, Thalang Hospital, Municipality of Cherngtalay and just <br />minutes from Phuket&rsquo;s most prestigious West Coast beaches (Surin, <br />Bang Tao, and Layan). Also, Lersuang Village will be located just <br />20 minutes from Phuket International Airport and 15 minutes from <br />Phuket Town. </font> <br /><font face=\"Arial\">There are three different sizes of property in the the Village:<br /><br /><u>Single House</u></font><font><font face=\"Arial\">- from &pound;92,800 (6,499,000 Baht)</font></font><font face=\"Arial\"><br /><br />The Lersuang Village Single House is a modern, beautifully <br />designed home with 200 spacious square meters spread across two <br />levels. Inside on the ground floor level there is a dining room, living room, <br />one half bathroom, and kitchen area that, as an option, can be fitted with <br />either Thai or Western standard cabinets and appliances. Outside there <br />are two covered terrace areas, a car park that can accommodate two <br />vehicles and an area for an optional, full size in ground swimming pool. <br />Upstairs there is one master bedroom with a full en-suite bathroom <br />and covered balcony and two guest bedrooms, one with its own <br />covered balcony, which share a second full bathroom. Also, there is an <br />additional living room that could easily be used as a fourth bedroom. <br />The Lersuang Village Single House will sit on an average land plot of 224 <br />square meters. <br /><br /><br /><u>Twin House</u></font> <font face=\"Arial\">- from &pound;64,000 (4,499,000 Baht)</font><br /><font face=\"Arial\">Inside on the ground floor level there is a dining room, <br />living room, one half bathroom, and kitchen area that, as an option, <br />can be fitted with either Thai or Western standard cabinets and <br />appliances. Outside there is large covered terrace area and a car <br />park that can accommodate one vehicle. Upstairs there is one master <br />bedroom with a full en-suite bathroom and covered terrace and two <br />guest bedrooms which share a second full bathroom. Also, there <br />is an additional living room that could easily be used as a fourth <br />bedroom. The Lersuang Village Twin House will sit on an average <br />land plot of 160 square meters. </font> <br /><font face=\"Arial\"><u><br />Town House</u>  </font><font face=\"Arial\">- from &pound;35,700 (2,499,000 Baht)<br /></font><font face=\"Arial\">The Lersuang Village Town House is ideal for small families <br />or part time Phuket residents. With 120 square meters spread across <br />two levels the townhouse retains great functional design. Inside on <br />the ground floor level there is a dining room, living room, one half <br />bathroom, and kitchen area that, as an option, can be fitted with <br />either Thai or Western standard cabinets and appliances. Outside <br />there is comfortable covered terrace area and a car park that can <br />accommodate one vehicle. Upstairs there is one master bedroom <br />and one guest bedroom which share a full bathroom. The Lersuang <br />Village Town House will sit on an average land plot of 80 square <br />meters. </font> <br /><br /><a href=\"http://www.lersuangvillage.com/\"><font face=\"Arial\">Visit the Lersuang Village Website</font></a></pre>','2006-11-15 17:41:32',35700,'',7,1),(26,0,'Chaweng Residence','This new development is in the north of the island, near to Chaweng beach. It is being built into a coconut covered hillside and is close to facilities and beaches. This development enjoys<br />\r\n<br />\r\nSome stunning <strong>views overlooking Chaweng, and Chaweng Lake</strong>. 					<br />\r\n<br />\r\nThere will be only 8 luxury villas, with spacious land plots, offering fine living in surrounds combining the best of both new and traditional Thai design. They will be <strong>built to                      blend in</strong> with their environment within this small development                      of 5 rai of hillside (8,000 sq.m). <br />\r\n<br />\r\nEach villa is designed for comfort and style with top quality finishings throughout. They house 2 or 3 bedrooms on one level with a choice of having another level, with a bedroom and bathroom built underneath. Each villa has its own private pool 8 x 4 m plus a sala within large terraces. Plot sizes range from 490-620 sq.m. with villas from 120 sq.m. The architecture will be of the highest quality, the roof is a special brown prestige tile, and the houses will enjoy extremely spacious living areas. The kitchen will be fitted to fully westernised standard, air conditioning will be in all bedrooms and alarms fitted. Other luxury fittings may be included to the customers specifications, e.g. gym, satellite, electric blinds, flat screen TVs, CCTV, etc. <br />\r\n<br />\r\nInterior decoration, gardeners, cleaners, maintenance help                      etc. can be arranged upon request. <br />\r\n<br />\r\nNumber 7 is the showhouse now, (see the picture provided) and construction has started on plot number 8, which will soon be the new showhouse. This should be complete February 2007. <br />\r\n<br />\r\nThe location is very central, close to Chaweng, 5 minutes to the new Lotus/Tesco and 15 minutes drive from the airport. 					<br />\r\n<br />\r\n<strong>Prices now range from 9.9 M THB -12.9 M THB (&pound;138K                      - &pound;166K)</strong> and include house, land and land transfer                      fees. <strong>Once completed they will sell for 3 M THB more</strong>.','2006-11-16 18:17:34',138000,'',7,0),(30,0,'Tamarind Hills, Phuket','Phuket is quite simply the ultimate lifestyle destination. Located 8deg north of the equator, just off the southwest coast of Thailand, Phuket is Thailand\'s largest tropical island situated in the unspoilt Andaman Sea. <br />\r\nThe Island&rsquo;s tropical climate creates a lush green paradise that is studded by stunning blue seas, rice paddies, rubber and coconut <br />\r\nplantations and white, sandy beaches. It is perfect for enjoying outdoor activities year-round, and its average water temperature of&nbsp; 24 degC (78degF) creates an underwater environment that is unmatched for its variety of aquatic species.<br />\r\n<br />\r\n<br />\r\n<strong>The Property &ndash; Tamarind Hills - Luxury Sea View Apartments in Paradise </strong><br />\r\n<br />\r\nTamarind Hills is without doubt one of the best located and thoughtfully designed residential property projects in Phuket. Situated on the hillside above the beautiful Bang Tao Beach, Tamarind Hills comprises four phases of spacious and generously proportioned two and three-bedroom luxury residential apartments, an exclusive boutique Resort &amp; Spa with a tranquil stream flowing through some of the most beautiful landscaping in Thailand. <br />\r\n<br />\r\nAll apartments at Tamarind Hills have spectacular panoramic views over the beautiful Andaman Sea. The property includes six Infinity pools and two Freeform pools, two International restaurants<br />\r\nSunset bar and a tenniscourt. <br />\r\nResidents will also have unlimited use of the luxurious Beach Club situated just three minutes drive away on the unspoilt Bang Tao Beach. <br />\r\n<br />\r\nAn Exclusive Experience <br />\r\n<br />\r\n-Tamarind Hills will be operated as a luxury Resort and Spa destination.<br />\r\n-Clubhouse facilities include a gym, library, cr&egrave;che and business center. <br />\r\n-Wireless broadband internet access will be provided throughout the development.  Our clubhouse -Concierge service will take care of any services you may require.','2006-11-17 15:15:16',0,'',7,0),(45,0,'Chaweng Panoramic','This is a fantastic opportunity to purchase luxury villas                      at <font color=\"#0000ff\"><strong>specially negotiated prices</strong></font>                      in a new untouched location on Koh Samui, <font color=\"#0000ff\"><strong>saving around 10-11 &frac12;                      %</strong></font> on the completion price. Excavation, road-building                      and services are currently underway and the completion date                      is mid 2007. All Licenses are in place.<br />\r\n<br />\r\nThis wonderful new off-plan development is set in a <strong>untouched                      location</strong> half way up a lush and tranquil hillside with                      <strong>spectacular views overlooking Chaweng, Choeng Mon and out                      to Koh Phangan</strong>. <br />\r\n<br />\r\nWithin 17 rai of hillside (27,200 sq.m), <strong>26 new luxury                      villas</strong> will be built in generous land plots, sympathetically                      built to blend in with the existing coconut trees, flora                      fauna and rock formations, maximising the feeling of privacy                      and space whilst epitomising each villas amazing views.                      No other developments are close-by. <br />\r\n<br />\r\nThe villas will be designed in the latest Bali-style,                      there will be 4 sizes available and they will range                      from 3 bedroom with maids quarter, to 5 bedroom with maids                      quarter. <br />\r\n<br />\r\nEach villa of course includes its own private pool                      ranging from 50m2 to 75m2, plus salas alongside large terraces                      and outdoor entertainment decks. <br />\r\n<br />\r\nThe architecture will be of the highest quality, and the houses                      will enjoy extremely spacious living areas. <br />\r\n<br />\r\nThe kitchen will be fitted to fully westernised standard,                      air conditioning will be throughout and alarms fitted. <br />\r\n<br />\r\nOther luxury fittings may be included to the customers specifications,                      e.g. gym, satellite, electric blinds, flat screen TVs, CCTV,                      etc. <br />\r\n<br />\r\nThe location is very central, close to Chaweng, 5 minutes                      to the new Lotus/Tesco and 15 minutes drive from the airport.<br />\r\n<br />\r\nTable below highlights the property sizes and specifications.<br />\r\n<br />\r\n<table width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" bordercolor=\"#cccccc\" border=\"1\">\r\n    <tbody>\r\n        <tr>\r\n            <td>&nbsp;</td>\r\n            <td>&nbsp;</td>\r\n            <td>&nbsp;</td>\r\n            <td>&nbsp;</td>\r\n            <td>&nbsp;</td>\r\n        </tr>\r\n        <tr>\r\n            <td>&nbsp;</td>\r\n            <td align=\"center\">Inside<br />\r\n            sq.m</td>\r\n            <td align=\"center\">Outside<br />\r\n            sq.m</td>\r\n            <td align=\"center\">Total<br />\r\n            sq.m</td>\r\n            <td>&nbsp;</td>\r\n        </tr>\r\n        <tr valign=\"top\">\r\n            <td>1</td>\r\n            <td align=\"center\">200</td>\r\n            <td align=\"center\">280</td>\r\n            <td align=\"center\">480</td>\r\n            <td>3 bedrooms plus maids quarter, <br />\r\n            5 Bathrooms</td>\r\n        </tr>\r\n        <tr valign=\"top\">\r\n            <td>2</td>\r\n            <td align=\"center\">220</td>\r\n            <td align=\"center\">335</td>\r\n            <td align=\"center\">555</td>\r\n            <td>4 bedrooms plus maids quarter, <br />\r\n            6 Bathrooms</td>\r\n        </tr>\r\n        <tr valign=\"top\">\r\n            <td>3</td>\r\n            <td align=\"center\">195</td>\r\n            <td align=\"center\">260</td>\r\n            <td align=\"center\">455</td>\r\n            <td>3 bedrooms plus maids quarter, <br />\r\n            5 Bathrooms</td>\r\n        </tr>\r\n        <tr valign=\"top\">\r\n            <td>4</td>\r\n            <td align=\"center\">222</td>\r\n            <td align=\"center\">275</td>\r\n            <td align=\"center\">497</td>\r\n            <td>4 bedrooms plus maids quarter, <br />\r\n            5 Bathrooms</td>\r\n        </tr>\r\n    </tbody>\r\n</table>\r\n<br />\r\nOur <strong>specially negotiated prices range from 26-29M THB</strong> depending on which plot, the plot size, and the size of the                      building. <br />\r\n<br />\r\n<strong>Completion due December 2007. </strong><br />\r\nPrices range from 26-29M THB now. Once completed they will sell                      for 3M THB more.<br />\r\n<script src=\"http://www.moneycorp.com/marketing/currency_converter.js.cfm?Agentid=10023097&ButtonID=2\"></script>','2006-12-05 13:01:37',369000,'',7,0);

--
-- Table structure for table `product_category`
--

CREATE TABLE `product_category` (
  `id` tinyint(4) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `description` text NOT NULL,
  `icon` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=koi8r;

--
-- Dumping data for table `product_category`
--

INSERT INTO `product_category` VALUES (1,'test category 1 - *','testing testing ',''),(2,'test category 2','descr descr descr descr descr descr descr descr descr ',''),(3,'test category 3','descr descr descr descr descr descr descr descr ',''),(4,'test category 4','descr descr descr descr descr ','');

--
-- Table structure for table `product_related`
--

CREATE TABLE `product_related` (
  `product_id` tinyint(5) NOT NULL default '0',
  `related_id` tinyint(5) NOT NULL default '0',
  `rel_id` tinyint(5) NOT NULL auto_increment,
  PRIMARY KEY  (`rel_id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=koi8r;

--
-- Dumping data for table `product_related`
--

INSERT INTO `product_related` VALUES (8,1,24),(19,17,28),(37,31,20);

--
-- Table structure for table `property`
--

CREATE TABLE `property` (
  `id` tinyint(5) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=koi8r;

--
-- Dumping data for table `property`
--

INSERT INTO `property` VALUES (1,'Furniture Pack Included',''),(2,'Completion Date',''),(3,'Property Type(s)',''),(4,'Location',''),(5,'Payment plan','');

--
-- Table structure for table `property_value`
--

CREATE TABLE `property_value` (
  `id` tinyint(5) NOT NULL auto_increment,
  `product` tinyint(5) NOT NULL default '0',
  `property` tinyint(5) NOT NULL default '0',
  `value` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=70 DEFAULT CHARSET=koi8r;

--
-- Dumping data for table `property_value`
--

INSERT INTO `property_value` VALUES (1,8,1,'tba'),(2,8,3,'Luxury hillside apartments and penthouses'),(3,8,2,'please enquire'),(4,8,4,'Close to beach, commanding views of Surin beach'),(8,15,2,'2008'),(7,15,1,'no'),(9,15,3,'Apartments and Bungalows'),(10,15,4,'On a private Island'),(11,16,1,'no'),(12,16,2,'2008'),(13,16,3,'2 bed and Penthouse beachside apartments'),(14,16,4,'Beachside'),(15,19,1,'fully fitted kitchen'),(16,19,2,'please enquire'),(17,19,3,'Townhouses'),(18,19,4,'Close to beach'),(19,33,2,'Completed April 06'),(20,34,2,'test'),(21,34,3,'test'),(22,34,4,'test'),(23,1,1,'tba'),(24,1,3,'Beachside luxury apartments, Freehold available'),(25,1,4,'Maikhao Beach, Phuket'),(26,1,5,'please enquire'),(31,30,1,'tba'),(32,30,2,'tba'),(33,30,3,'tba'),(46,13,1,'tba'),(47,13,2,'2009'),(48,13,3,'2 & 3 Bed Villas'),(49,13,4,'close to beach'),(50,7,1,'tba'),(51,7,2,'2009'),(52,7,3,'2 bed &  Penthouse Apartments'),(53,7,4,'close to beach'),(54,14,1,'tba'),(55,14,2,'2009'),(56,14,3,'2 & 3 Bed Townhouse'),(57,14,5,'please enquire'),(58,17,1,'please enquire'),(59,17,2,'please enquire'),(60,17,3,'Apartments & Penthouses'),(61,17,4,'Close to the beach'),(69,22,4,'Inland close to beaches'),(67,22,2,'please enquire'),(68,22,3,'Detached, Semi Detached and Townhouses'),(66,22,1,'please enquire');

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

CREATE TABLE `question_answer` (
  `id` tinyint(5) NOT NULL auto_increment,
  `account` tinyint(5) NOT NULL default '0',
  `question` text NOT NULL,
  `answer` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=koi8r;

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

INSERT INTO `question_answer` VALUES (1,2,'racing','le mans'),(2,4,'dog','cat'),(3,5,'a','a');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `sid` varchar(32) NOT NULL default '',
  `atime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `data` text NOT NULL,
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=koi8r;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES ('4a22c8bbcb0b52a5c0988a56f99e08e5','2006-12-07 15:01:24',''),('411d061398f08c146a4780310b1f7243','2006-12-07 11:24:36',''),('12b80bee607e8687aafc73dc556d6602','2006-12-07 15:15:47',''),('3a04295a7acf4a9b50b7995bbbefaa14','2006-12-07 13:13:30',''),('338462e0413addb615e03254b0f6f41b','2006-12-07 13:17:23',''),('58360959a64b30286f2e941783d5c6ee','2006-12-07 15:01:47',''),('e158182950c70a4da8da553f5bd799f2','2006-12-07 17:39:27',''),('9ef1f679d4304c58420a00a1874b6b42','2006-12-07 18:39:01','');

--
-- Table structure for table `state`
--

CREATE TABLE `state` (
  `id` tinyint(5) NOT NULL auto_increment,
  `product` tinyint(5) NOT NULL default '0',
  `pub_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `milestone` tinyint(1) NOT NULL default '0',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=koi8r;

--
-- Dumping data for table `state`
--



