-- MySQL dump 10.9
--
-- Host: localhost    Database: jodyf_imga2
-- ------------------------------------------------------
-- Server version	4.1.22-standard-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `4images_categories`
--

DROP TABLE IF EXISTS `4images_categories`;
CREATE TABLE `4images_categories` (
  `cat_id` int(10) unsigned NOT NULL auto_increment,
  `cat_name` varchar(255) NOT NULL default '',
  `cat_description` text NOT NULL,
  `cat_parent_id` int(10) unsigned NOT NULL default '0',
  `cat_hits` int(10) unsigned NOT NULL default '0',
  `cat_order` int(10) unsigned NOT NULL default '0',
  `auth_viewcat` tinyint(2) NOT NULL default '0',
  `auth_viewimage` tinyint(2) NOT NULL default '0',
  `auth_download` tinyint(2) NOT NULL default '0',
  `auth_upload` tinyint(2) NOT NULL default '0',
  `auth_directupload` tinyint(2) NOT NULL default '0',
  `auth_vote` tinyint(2) NOT NULL default '0',
  `auth_sendpostcard` tinyint(2) NOT NULL default '0',
  `auth_readcomment` tinyint(2) NOT NULL default '0',
  `auth_postcomment` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `cat_parent_id` (`cat_parent_id`),
  KEY `cat_order` (`cat_order`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_categories`
--

LOCK TABLES `4images_categories` WRITE;
/*!40000 ALTER TABLE `4images_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `4images_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4images_comments`
--

DROP TABLE IF EXISTS `4images_comments`;
CREATE TABLE `4images_comments` (
  `comment_id` int(10) unsigned NOT NULL auto_increment,
  `image_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `user_name` varchar(100) NOT NULL default '',
  `comment_headline` varchar(255) NOT NULL default '',
  `comment_text` text NOT NULL,
  `comment_ip` varchar(20) NOT NULL default '',
  `comment_date` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`comment_id`),
  KEY `image_id` (`image_id`),
  KEY `user_id` (`user_id`),
  KEY `comment_date` (`comment_date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_comments`
--

LOCK TABLES `4images_comments` WRITE;
/*!40000 ALTER TABLE `4images_comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `4images_comments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4images_groupaccess`
--

DROP TABLE IF EXISTS `4images_groupaccess`;
CREATE TABLE `4images_groupaccess` (
  `group_id` int(10) unsigned NOT NULL default '0',
  `cat_id` int(10) unsigned NOT NULL default '0',
  `auth_viewcat` tinyint(1) NOT NULL default '0',
  `auth_viewimage` tinyint(1) NOT NULL default '0',
  `auth_download` tinyint(1) NOT NULL default '0',
  `auth_upload` tinyint(1) NOT NULL default '0',
  `auth_directupload` tinyint(1) NOT NULL default '0',
  `auth_vote` tinyint(1) NOT NULL default '0',
  `auth_sendpostcard` tinyint(1) NOT NULL default '0',
  `auth_readcomment` tinyint(1) NOT NULL default '0',
  `auth_postcomment` tinyint(1) NOT NULL default '0',
  KEY `group_id` (`group_id`),
  KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_groupaccess`
--

LOCK TABLES `4images_groupaccess` WRITE;
/*!40000 ALTER TABLE `4images_groupaccess` DISABLE KEYS */;
/*!40000 ALTER TABLE `4images_groupaccess` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4images_groupmatch`
--

DROP TABLE IF EXISTS `4images_groupmatch`;
CREATE TABLE `4images_groupmatch` (
  `group_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `groupmatch_startdate` int(11) unsigned NOT NULL default '0',
  `groupmatch_enddate` int(11) unsigned NOT NULL default '0',
  KEY `group_id` (`group_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_groupmatch`
--

LOCK TABLES `4images_groupmatch` WRITE;
/*!40000 ALTER TABLE `4images_groupmatch` DISABLE KEYS */;
/*!40000 ALTER TABLE `4images_groupmatch` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4images_groups`
--

DROP TABLE IF EXISTS `4images_groups`;
CREATE TABLE `4images_groups` (
  `group_id` int(10) unsigned NOT NULL auto_increment,
  `group_name` varchar(100) NOT NULL default '',
  `group_type` tinyint(2) NOT NULL default '1',
  PRIMARY KEY  (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_groups`
--

LOCK TABLES `4images_groups` WRITE;
/*!40000 ALTER TABLE `4images_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `4images_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4images_images`
--

DROP TABLE IF EXISTS `4images_images`;
CREATE TABLE `4images_images` (
  `image_id` int(10) unsigned NOT NULL auto_increment,
  `cat_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `image_name` varchar(255) NOT NULL default '',
  `image_description` text NOT NULL,
  `image_keywords` text NOT NULL,
  `image_date` int(11) unsigned NOT NULL default '0',
  `image_active` tinyint(1) NOT NULL default '1',
  `image_media_file` varchar(255) NOT NULL default '',
  `image_thumb_file` varchar(255) NOT NULL default '',
  `image_download_url` varchar(255) NOT NULL default '',
  `image_allow_comments` tinyint(1) NOT NULL default '1',
  `image_comments` int(10) unsigned NOT NULL default '0',
  `image_downloads` int(10) unsigned NOT NULL default '0',
  `image_votes` int(10) unsigned NOT NULL default '0',
  `image_rating` decimal(4,2) NOT NULL default '0.00',
  `image_hits` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`image_id`),
  KEY `cat_id` (`cat_id`),
  KEY `user_id` (`user_id`),
  KEY `image_date` (`image_date`),
  KEY `image_active` (`image_active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_images`
--

LOCK TABLES `4images_images` WRITE;
/*!40000 ALTER TABLE `4images_images` DISABLE KEYS */;
/*!40000 ALTER TABLE `4images_images` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4images_images_temp`
--

DROP TABLE IF EXISTS `4images_images_temp`;
CREATE TABLE `4images_images_temp` (
  `image_id` int(10) unsigned NOT NULL auto_increment,
  `cat_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `image_name` varchar(255) NOT NULL default '',
  `image_description` text NOT NULL,
  `image_keywords` text NOT NULL,
  `image_date` int(11) unsigned NOT NULL default '0',
  `image_media_file` varchar(255) NOT NULL default '',
  `image_thumb_file` varchar(255) NOT NULL default '',
  `image_download_url` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`image_id`),
  KEY `cat_id` (`cat_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_images_temp`
--

LOCK TABLES `4images_images_temp` WRITE;
/*!40000 ALTER TABLE `4images_images_temp` DISABLE KEYS */;
/*!40000 ALTER TABLE `4images_images_temp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4images_lightboxes`
--

DROP TABLE IF EXISTS `4images_lightboxes`;
CREATE TABLE `4images_lightboxes` (
  `lightbox_id` varchar(32) NOT NULL default '',
  `user_id` int(11) NOT NULL default '0',
  `lightbox_lastaction` int(11) unsigned NOT NULL default '0',
  `lightbox_image_ids` text,
  KEY `lightbox_id` (`lightbox_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_lightboxes`
--

LOCK TABLES `4images_lightboxes` WRITE;
/*!40000 ALTER TABLE `4images_lightboxes` DISABLE KEYS */;
/*!40000 ALTER TABLE `4images_lightboxes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4images_postcards`
--

DROP TABLE IF EXISTS `4images_postcards`;
CREATE TABLE `4images_postcards` (
  `postcard_id` varchar(32) NOT NULL default '',
  `image_id` int(10) unsigned NOT NULL default '0',
  `postcard_date` int(11) unsigned NOT NULL default '0',
  `postcard_bg_color` varchar(100) NOT NULL default '',
  `postcard_border_color` varchar(100) NOT NULL default '',
  `postcard_font_color` varchar(100) NOT NULL default '',
  `postcard_font_face` varchar(100) NOT NULL default '',
  `postcard_sender_name` varchar(255) NOT NULL default '',
  `postcard_sender_email` varchar(255) NOT NULL default '',
  `postcard_recipient_name` varchar(255) NOT NULL default '',
  `postcard_recipient_email` varchar(255) NOT NULL default '',
  `postcard_headline` varchar(255) NOT NULL default '',
  `postcard_message` text NOT NULL,
  PRIMARY KEY  (`postcard_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_postcards`
--

LOCK TABLES `4images_postcards` WRITE;
/*!40000 ALTER TABLE `4images_postcards` DISABLE KEYS */;
/*!40000 ALTER TABLE `4images_postcards` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4images_sessions`
--

DROP TABLE IF EXISTS `4images_sessions`;
CREATE TABLE `4images_sessions` (
  `session_id` varchar(32) NOT NULL default '',
  `session_user_id` int(11) NOT NULL default '0',
  `session_lastaction` int(11) unsigned NOT NULL default '0',
  `session_location` varchar(255) NOT NULL default '',
  `session_ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`session_id`),
  KEY `session_user_id` (`session_user_id`),
  KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_sessions`
--

LOCK TABLES `4images_sessions` WRITE;
/*!40000 ALTER TABLE `4images_sessions` DISABLE KEYS */;
INSERT INTO `4images_sessions` VALUES ('7d8f451a1f4c49409dd37e838ec19cb4',-1,1173803678,'index.php','196.11.241.41');
/*!40000 ALTER TABLE `4images_sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4images_sessionvars`
--

DROP TABLE IF EXISTS `4images_sessionvars`;
CREATE TABLE `4images_sessionvars` (
  `session_id` varchar(32) NOT NULL default '',
  `sessionvars_name` varchar(30) NOT NULL default '',
  `sessionvars_value` text,
  KEY `session_id` (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_sessionvars`
--

LOCK TABLES `4images_sessionvars` WRITE;
/*!40000 ALTER TABLE `4images_sessionvars` DISABLE KEYS */;
/*!40000 ALTER TABLE `4images_sessionvars` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4images_settings`
--

DROP TABLE IF EXISTS `4images_settings`;
CREATE TABLE `4images_settings` (
  `setting_name` varchar(255) NOT NULL default '',
  `setting_value` mediumtext NOT NULL,
  PRIMARY KEY  (`setting_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_settings`
--

LOCK TABLES `4images_settings` WRITE;
/*!40000 ALTER TABLE `4images_settings` DISABLE KEYS */;
INSERT INTO `4images_settings` VALUES ('site_name','jodyforrester.com'),('site_email','jodyforrester@gmail.com'),('use_smtp','0'),('smtp_host',''),('smtp_username',''),('smtp_password',''),('template_dir','default'),('language_dir','english'),('date_format','d.m.Y'),('time_format','H:i'),('convert_tool','gd'),('convert_tool_path',''),('gz_compress','0'),('gz_compress_level','6'),('cat_cells','2'),('cat_table_width','100%'),('cat_table_cellspacing','1'),('cat_table_cellpadding','3'),('num_subcats','3'),('image_order','image_name'),('image_sort','ASC'),('new_cutoff','10'),('image_border','1'),('image_cells','3'),('default_image_rows','3'),('custom_row_steps','10'),('image_table_width','100%'),('image_table_cellspacing','1'),('image_table_cellpadding','3'),('upload_mode','2'),('allowed_mediatypes','jpg,gif,png,aif,au,avi,mid,mov,mp3,mpg,swf,wav,ra,rm,zip,pdf'),('max_thumb_width','300'),('max_thumb_height','300'),('max_thumb_size','100'),('max_image_width','1024'),('max_image_height','1024'),('max_media_size','2000'),('upload_notify','0'),('upload_emails',''),('auto_thumbnail','1'),('auto_thumbnail_dimension','100'),('auto_thumbnail_resize_type','1'),('auto_thumbnail_quality','75'),('badword_list','fuck {fuck}'),('badword_replace_char','*'),('wordwrap_comments','50'),('html_comments','0'),('bb_comments','1'),('bb_img_comments','0'),('category_separator',' / '),('paging_range','5'),('user_edit_image','1'),('user_delete_image','1'),('user_edit_comments','1'),('user_delete_comments','1'),('account_activation','1'),('activation_time','14'),('session_timeout','15'),('display_whosonline','1'),('highlight_admin','1');
/*!40000 ALTER TABLE `4images_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4images_users`
--

DROP TABLE IF EXISTS `4images_users`;
CREATE TABLE `4images_users` (
  `user_id` int(11) NOT NULL auto_increment,
  `user_level` int(11) NOT NULL default '1',
  `user_name` varchar(255) NOT NULL default '',
  `user_password` varchar(255) NOT NULL default '',
  `user_email` varchar(255) NOT NULL default '',
  `user_showemail` tinyint(1) NOT NULL default '0',
  `user_allowemails` tinyint(1) NOT NULL default '1',
  `user_invisible` tinyint(1) NOT NULL default '0',
  `user_joindate` int(11) unsigned NOT NULL default '0',
  `user_activationkey` varchar(32) NOT NULL default '',
  `user_lastaction` int(11) unsigned NOT NULL default '0',
  `user_location` varchar(255) NOT NULL default '',
  `user_lastvisit` int(11) unsigned NOT NULL default '0',
  `user_comments` int(10) unsigned NOT NULL default '0',
  `user_homepage` varchar(255) NOT NULL default '',
  `user_icq` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`user_id`),
  KEY `user_lastaction` (`user_lastaction`),
  KEY `user_name` (`user_name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_users`
--

LOCK TABLES `4images_users` WRITE;
/*!40000 ALTER TABLE `4images_users` DISABLE KEYS */;
INSERT INTO `4images_users` VALUES (-1,-1,'Guest','0493984f537120be0b8d96bc9b69cdd2','',0,0,0,0,'',0,'',0,0,'',''),(1,9,'2muppets','f4f52c274b8b0af7593e8d85f45ae7f1','jodyforrester@gmail.com',1,1,0,1173803645,'1e3457c0b2052a9633b886fd75ef91e0',1173803645,'index.php',1173803645,0,'','');
/*!40000 ALTER TABLE `4images_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4images_wordlist`
--

DROP TABLE IF EXISTS `4images_wordlist`;
CREATE TABLE `4images_wordlist` (
  `word_text` varchar(50) NOT NULL default '',
  `word_id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`word_id`),
  UNIQUE KEY `word_text` (`word_text`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_wordlist`
--

LOCK TABLES `4images_wordlist` WRITE;
/*!40000 ALTER TABLE `4images_wordlist` DISABLE KEYS */;
/*!40000 ALTER TABLE `4images_wordlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4images_wordmatch`
--

DROP TABLE IF EXISTS `4images_wordmatch`;
CREATE TABLE `4images_wordmatch` (
  `image_id` int(10) unsigned NOT NULL default '0',
  `word_id` int(10) unsigned NOT NULL default '0',
  `name_match` tinyint(1) NOT NULL default '0',
  `desc_match` tinyint(1) NOT NULL default '0',
  `keys_match` tinyint(1) NOT NULL default '0',
  UNIQUE KEY `image_word_id` (`image_id`,`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `4images_wordmatch`
--

LOCK TABLES `4images_wordmatch` WRITE;
/*!40000 ALTER TABLE `4images_wordmatch` DISABLE KEYS */;
/*!40000 ALTER TABLE `4images_wordmatch` ENABLE KEYS */;
UNLOCK TABLES;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;