World Spa Centers Database is for sale now
Description:
This awesome db includes all kinds of spa centers.
Fields:
1) ID
2) CAT
3) NAME
4) COUNTRY
5) STATE OR CITY OR TOWN (For ex: This field includes "state" names For USA)
6) EXTRA ADDRESS (This db is more indepth)
7) WEBSITE
8) TELEPHONE
9) SPA TYPE
10) EXTRA FEATURES
11) MAIN ADDRESS
12) EXTRA ADDRESS2
13) POSTCODE
There're some extra fields which are bonus from me: website, extra features, extra address2, postcode
Structure:
PHP Code:
CREATE TABLE `site_data` (
`id` bigint(20) NOT NULL auto_increment,
`cat` varchar(50) NOT NULL default '',
`name` varchar(255) character set utf8 collate utf8 NOT NULL default '',
`country` text character set utf8 collate utf8 NOT NULL,
`statecitytown` text character set utf8 collate utf8,
`extraaddress` text character set utf8 collate utf8,
`website` text character set utf8 collate utf8,
`telephone` text character set utf8 collate utf8,
`spatype` text character set utf8 collate utf8,
`extrafeatures` text character set utf8 collate utf8,
`mainaddress` text character set utf8 collate utf8,
`extraaddress2` text character set utf8 collate utf8,
`postcode` text character set utf8 collate utf8,
PRIMARY KEY (`id`),
KEY `cat_index` (`cat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3383 ;
Sample from db:
PHP Code:
INSERT INTO `site_data` VALUES (8, 'N', 'New Life Hiking Spa', 'United States', 'Vermont', 'Killington', 'www.newlifehikingspa.com', '1(866) 389-9598', 'Destination Spa', '25 rooms,$$\n Affordable Spa Vacations, Hiking, Mountains,', 'PO Box 395', 'Killington, Vermont', '05751-0395');
Records: 3.381
Price: 39$
Regards