CREATE TABLE `grid` ( `item_id` int(11) NOT NULL auto_increment, `item` blob, `date` varchar(50) default NULL, `mulberrygrove` tinyint(2) default '0', `greenville` tinyint(2) default '0', `morrisonville` tinyint(2) default '0', `taylorville` tinyint(4) default '0', `edinburg` tinyint(2) default '0', `pana` tinyint(2) default '0', `southfork` tinyint(2) default '0', `altamont` tinyint(2) default '0', `beechercity` tinyint(2) default '0', `dieterich` tinyint(2) default '0', `effingham` tinyint(2) default '0', `teutopolis` tinyint(2) default '0', `brownstown` tinyint(2) default '0', `stelmo` tinyint(2) default '0', `vandalia` tinyint(2) default '0', `ramsey` tinyint(2) default '0', `panhandle` tinyint(2) default '0', `hillsboro` tinyint(2) default '0', `litchfield` tinyint(2) default '0', `nokomis` tinyint(2) default '0', PRIMARY KEY (`item_id`), UNIQUE KEY `item_id_2` (`item_id`), KEY `item_id` (`item_id`) ) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;