Something

-- -- Table structure for table `images`-- CREATE TABLE `images` (  `id` int(11) NOT NULL auto_increment,  `member_id` int(11) NOT NULL default '0',  `description` varchar(150) NOT NULL default '',  `filename` varchar(30) NOT NULL default '',  `extension` varchar(5) NOT NULL default '',  `category_id` int(11) NOT NULL default '0',  `gender` enum('Male','Female','Both') NOT NULL default 'Male',  `views` int(11) NOT NULL default '0',  `added` datetime NOT NULL default '0000-00-00 00:00:00',  PRIMARY KEY  (`id`),  KEY `gender` (`gender`,`added`)) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;-- ---------------------------------------------------------- -- Table structure for table `views`-- CREATE TABLE `views` (  `id` int(11) NOT NULL auto_increment,  `image_id` varchar(100) NOT NULL default '',  `viewed` datetime NOT NULL default '0000-00-00 00:00:00',  `ipaddress` varchar(30) NOT NULL default '',  PRIMARY KEY  (`id`),  KEY `veiw_type` (`veiw_type`,`viewed`,`ipaddress`),  KEY `veiw_input` (`veiw_input`)) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;