cdaGPfip

1CREATE TABLE IF NOT EXISTS `wp_dbt_listings` (
2  `listingsID` int(11) NOT NULL auto_increment,
3  `address` varchar(255) NOT NULL,
4  `images` varchar(255) NOT NULL,
5  `mls` varchar(255) NOT NULL,
6  `price` varchar(255) NOT NULL,
7  `age` varchar(255) NOT NULL,
8  `link` varchar(255) NOT NULL,
9  `lot_size` varchar(255) NOT NULL,
10  `living_area` varchar(255) NOT NULL,
11  `lot_frontage` varchar(255) NOT NULL,
12  `lot_depth` varchar(255) NOT NULL,
13  `bedrooms` varchar(255) NOT NULL,
14  `bathrooms` varchar(255) NOT NULL,
15  `notes` varchar(255) NOT NULL,
16  `status` varchar(255) NOT NULL,
17  PRIMARY KEY  (`listingsID`)
18) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;