Miscellany

CREATE TABLE `listings` ( 
				   `id` int(11) NOT NULL auto_increment, 
				   `address` varchar(255) collate latin1_general_ci NOT NULL, 
				   `apt` varchar(5) collate latin1_general_ci NOT NULL, 
				   `bedrooms` tinyint(1) NOT NULL, 
				   `bath` tinyint(1) NOT NULL, 
				   `city` varchar(255) collate latin1_general_ci NOT NULL, 
				   `furnished` varchar(1) collate latin1_general_ci NOT NULL, 
				   `disposal` varchar(1) collate latin1_general_ci NOT NULL, 
				   `ac` varchar(1) collate latin1_general_ci NOT NULL, 
				   `dishw` varchar(1) collate latin1_general_ci NOT NULL, 
				   `balcony` varchar(1) collate latin1_general_ci NOT NULL, 
				   `patio` varchar(1) collate latin1_general_ci NOT NULL, 
				   `parking` varchar(1) collate latin1_general_ci NOT NULL, 
				   `available` varchar(1) collate latin1_general_ci NOT NULL, 
				   `proptype` varchar(10) collate latin1_general_ci NOT NULL,
				   `path` varchar(255) collate latin1_general_ci NOT NULL,
				   PRIMARY KEY  (`id`) 
				 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1112