-- 
-- 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 ;