127 - I have a 3 - 6mb flat file that I have to import every day for a MLS site. I could normalize this file if I wanted to (Especially the Features part) However, This is much easier to maintain.
Code: Select all
CREATE TABLE `tbl_mls_listings_main` (
`listnum` int(11) NOT NULL default '0',
`listOffCode` int(11) default NULL,
`listAgent` int(11) default NULL,
`statusCode` text,
`catgNum` int(11) default NULL,
`streetName` text,
`streetDir` text,
`streetNum` text,
`listDate` text,
`latitude` text,
`longitude` text,
`city` text,
`listPrice` int(11) default NULL,
`rentalAmt` int(11) default NULL,
`photo_flag` text,
`bedrooms` int(11) default NULL,
`proptype` text,
`areacode` int(11) default NULL,
`common_subd` text,
`county` text,
`zoning` text,
`email_addr` text,
`elem_school` text,
`high_school` text,
`homestead` int(11) default NULL,
`legal_subd` text,
`land_use_code` text,
`middle_school` text,
`full_baths` int(11) default NULL,
`half_baths` int(11) default NULL,
`region` int(11) default NULL,
`state` text,
`tot_sqft` text,
`waterfront_yn` text,
`zipcode` text,
`builder` text,
`new_construct` int(11) default NULL,
`officename` text,
`officephone` text,
`agentname` text,
`agentphone` text,
`zoning_a` text,
`zoning_b` text,
`zoning_c` text,
`ipix` text,
`features1` text,
`features2` text,
`features3` text,
`features4` text,
`features5` text,
`features6` text,
`features7` text,
`features8` text,
`features9` text,
`features10` text,
`features11` text,
`features12` text,
`features13` text,
`features14` text,
`features15` text,
`features16` text,
`features17` text,
`features18` text,
`features19` text,
`features20` text,
`features21` text,
`features22` text,
`features23` text,
`features24` text,
`features25` text,
`features26` text,
`features27` text,
`features28` text,
`features29` text,
`features30` text,
`features31` text,
`features32` text,
`features33` text,
`features34` text,
`features35` text,
`features36` text,
`sect` int(11) default NULL,
`range` int(11) default NULL,
`township` text,
`tot_acres` text,
`bed1_wid` text,
`bed1_lf` text,
`bed1_len` text,
`bed2_wid` text,
`bed2_lf` text,
`bed2_len` text,
`bed3_wid` text,
`bed3_lf` text,
`bed3_len` text,
`bed4_wid` text,
`bed4_lf` text,
`bed4_len` text,
`bed5_wid` text,
`bed5_lf` text,
`bed5_len` text,
`bonus_wid` text,
`bonus_lf` text,
`bonus_len` text,
`break_wid` text,
`break_lf` text,
`break_len` text,
`dining_wid` text,
`dining_lf` text,
`dining_len` text,
`family_wid` text,
`family_lf` text,
`family_len` text,
`great_wid` text,
`great_lf` text,
`great_len` text,
`kitchen_wid` text,
`kitchen_lf` text,
`kitchen_len` text,
`kitchen_wid2` text,
`kitchen_lf2` text,
`kitchen_len2` text,
`living_wid` text,
`living_lf` text,
`living_len` text,
`taxid` text,
`lot_size` text,
`photocount` int(11) default NULL,
PRIMARY KEY (`listnum`)
) TYPE=MyISAM;