-- MySQL dump 10.11
--
-- Host: localhost    Database: flyhusky_cpm01
-- ------------------------------------------------------
-- Server version	5.0.75-community-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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 `cpg_albums`
--

DROP TABLE IF EXISTS `cpg_albums`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_albums` (
  `aid` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `visibility` int(11) NOT NULL default '0',
  `uploads` enum('YES','NO') NOT NULL default 'NO',
  `comments` enum('YES','NO') NOT NULL default 'YES',
  `votes` enum('YES','NO') NOT NULL default 'YES',
  `pos` int(11) NOT NULL default '0',
  `category` int(11) NOT NULL default '0',
  `thumb` int(11) NOT NULL default '0',
  `keyword` varchar(50) default NULL,
  `alb_password` varchar(32) default NULL,
  `alb_password_hint` text,
  PRIMARY KEY  (`aid`),
  KEY `alb_category` (`category`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='Used to store albums';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_albums`
--

LOCK TABLES `cpg_albums` WRITE;
/*!40000 ALTER TABLE `cpg_albums` DISABLE KEYS */;
INSERT INTO `cpg_albums` VALUES (2,'Husky Photos','',0,'YES','YES','YES',100,0,0,'','',''),(3,'Landing Sites','',0,'NO','YES','YES',101,0,0,NULL,NULL,NULL),(4,'Husky Mods and Updates','',0,'NO','YES','YES',102,0,0,NULL,NULL,NULL),(5,'Anything Else','',0,'NO','YES','YES',103,0,0,NULL,NULL,NULL),(6,'Other Flying Machines','',0,'NO','YES','YES',104,0,0,NULL,NULL,NULL),(7,'Videos','',0,'NO','YES','YES',105,0,0,NULL,NULL,NULL),(8,'TomDs Husky Mods','Pictures of most of TomDs Husky Mods',0,'NO','YES','YES',100,10003,0,'','',''),(9,'New album','',0,'NO','YES','YES',1,10056,0,NULL,NULL,NULL);
/*!40000 ALTER TABLE `cpg_albums` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cpg_banned`
--

DROP TABLE IF EXISTS `cpg_banned`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_banned` (
  `ban_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) default NULL,
  `ip_addr` tinytext,
  `expiry` datetime default NULL,
  `brute_force` tinyint(5) NOT NULL default '0',
  PRIMARY KEY  (`ban_id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='Data about banned users';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_banned`
--

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

--
-- Table structure for table `cpg_bridge`
--

DROP TABLE IF EXISTS `cpg_bridge`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_bridge` (
  `name` varchar(40) NOT NULL default '0',
  `value` varchar(255) NOT NULL default '',
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores the bridging data, not used when unbridged';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_bridge`
--

LOCK TABLES `cpg_bridge` WRITE;
/*!40000 ALTER TABLE `cpg_bridge` DISABLE KEYS */;
INSERT INTO `cpg_bridge` VALUES ('short_name','vbulletin30'),('license_number',''),('db_database_name',''),('db_hostname',''),('db_username',''),('db_password',''),('full_forum_url','http://www.flyhusky.com/vbulletin'),('relative_path_of_forum_from_webroot',''),('relative_path_to_config_file','../vbulletin/'),('logout_flag',''),('use_post_based_groups','0'),('cookie_prefix',''),('table_prefix',''),('user_table',''),('session_table',''),('group_table',''),('group_relation_table',''),('group_mapping_table',''),('use_standard_groups','1'),('validating_group',''),('guest_group',''),('member_group',''),('admin_group',''),('banned_group',''),('global_moderators_group',''),('recovery_logon_failures','0'),('recovery_logon_timestamp','');
/*!40000 ALTER TABLE `cpg_bridge` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cpg_categories`
--

DROP TABLE IF EXISTS `cpg_categories`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_categories` (
  `cid` int(11) NOT NULL auto_increment,
  `owner_id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `pos` int(11) NOT NULL default '0',
  `parent` int(11) NOT NULL default '0',
  `thumb` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cid`),
  KEY `cat_parent` (`parent`),
  KEY `cat_pos` (`pos`),
  KEY `cat_owner_id` (`owner_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Used to store categories';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_categories`
--

LOCK TABLES `cpg_categories` WRITE;
/*!40000 ALTER TABLE `cpg_categories` DISABLE KEYS */;
INSERT INTO `cpg_categories` VALUES (1,0,'User galleries','This category contains albums that belong to Coppermine users.',0,0,0);
/*!40000 ALTER TABLE `cpg_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cpg_comments`
--

DROP TABLE IF EXISTS `cpg_comments`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_comments` (
  `pid` mediumint(10) NOT NULL default '0',
  `msg_id` mediumint(10) NOT NULL auto_increment,
  `msg_author` varchar(25) NOT NULL default '',
  `msg_body` text NOT NULL,
  `msg_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `msg_raw_ip` tinytext,
  `msg_hdr_ip` tinytext,
  `author_md5_id` varchar(32) NOT NULL default '',
  `author_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`msg_id`),
  KEY `com_pic_id` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Used to store comments made on pics';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_comments`
--

LOCK TABLES `cpg_comments` WRITE;
/*!40000 ALTER TABLE `cpg_comments` DISABLE KEYS */;
INSERT INTO `cpg_comments` VALUES (24,1,'admin','Great perspective.','2009-01-09 21:06:34','70.211.124.196','70.211.124.196','',1);
/*!40000 ALTER TABLE `cpg_comments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cpg_config`
--

DROP TABLE IF EXISTS `cpg_config`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_config` (
  `name` varchar(40) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Used to store the configuration options';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_config`
--

LOCK TABLES `cpg_config` WRITE;
/*!40000 ALTER TABLE `cpg_config` DISABLE KEYS */;
INSERT INTO `cpg_config` VALUES ('albums_per_page','12'),('album_list_cols','2'),('display_pic_info','0'),('alb_list_thumb_size','50'),('allowed_mov_types','ALL'),('allowed_doc_types','doc/txt/rtf/pdf/xls/pps/ppt/zip/gz/mdb'),('allowed_snd_types','mp3/midi/mid/wma/wav/ogg'),('allowed_img_types','ALL'),('allow_private_albums','1'),('allow_user_registration','0'),('allow_unlogged_access','1'),('allow_duplicate_emails_addr','0'),('caption_in_thumbview','1'),('views_in_thumbview','1'),('charset','utf-8'),('cookie_name','coppermine'),('cookie_path','/'),('debug_mode','0'),('debug_notice','0'),('default_dir_mode','0755'),('default_file_mode','0644'),('default_sort_order','na'),('ecards_more_pic_target','http://www.flyhusky.com/galleries2/'),('home_target','http://www.flyhusky.com'),('custom_lnk_name',''),('custom_lnk_url',''),('enable_smilies','1'),('filter_bad_words','1'),('forbiden_fname_char','$/\\\\:*?&quot;\'&lt;&gt;|` &amp;'),('fullpath','albums/'),('gallery_admin_email','admin@flyhusky.com'),('gallery_description',''),('gallery_name','Fly Husky Photo Galleries'),('im_options','-antialias'),('impath',''),('jpeg_qual','80'),('keep_votes_time','30'),('lang','english'),('main_page_layout','breadcrumb/catlist/alblist/random,2/lastup,2'),('main_table_width','100%'),('make_intermediate','1'),('max_com_lines','10'),('max_com_size','512'),('max_com_wlength','38'),('max_img_desc_length','512'),('max_tabs','12'),('max_upl_size','92160'),('max_upl_width_height','5120'),('auto_resize','2'),('min_votes_for_rating','1'),('normal_pfx','normal_'),('offline','0'),('picture_table_width','600'),('picture_width','400'),('read_exif_data','0'),('reg_requires_valid_email','1'),('subcat_level','2'),('theme','rainy_day'),('thumbcols','4'),('thumbrows','3'),('thumb_method','gd2'),('thumb_pfx','thumb_'),('thumb_width','100'),('userpics','userpics/'),('vanity_block','1'),('user_profile1_name',''),('user_profile2_name',''),('user_profile3_name',''),('user_profile4_name',''),('user_profile5_name',''),('user_profile6_name',''),('user_field1_name',''),('user_field2_name',''),('user_field3_name',''),('user_field4_name',''),('display_comment_count','0'),('show_private','0'),('first_level','1'),('display_film_strip','1'),('display_film_strip_filename','0'),('max_film_strip_items','5'),('thumb_use','any'),('read_iptc_data','0'),('reg_notify_admin_email','0'),('disable_comment_flood_protect','0'),('upl_notify_admin_email','0'),('display_uploader','0'),('display_filename','0'),('language_list','0'),('language_flags','0'),('theme_list','0'),('language_reset','1'),('theme_reset','1'),('allow_memberlist','0'),('display_faq','0'),('show_bbcode_help','1'),('log_ecards','0'),('email_comment_notification','0'),('enable_zipdownload','1'),('slideshow_interval','5000'),('log_mode','0'),('media_autostart','1'),('enable_encrypted_passwords','1'),('time_offset','-8'),('ban_private_ip','0'),('smtp_host',''),('smtp_username','ssmusser'),('smtp_password','bohica*007'),('enable_plugins','1'),('enable_help','2'),('categories_alpha_sort','0'),('login_threshold','5'),('login_expiry','10'),('allow_email_change','0'),('clickable_keyword_search','1'),('users_can_edit_pics','0'),('show_which_exif','|0|0|0|0|0|0|0|0|1|0|1|1|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|1|0|0|0|1|1|0|0|0|0|1|0|0|0|1|0|0|1|1|0|0|0|0|0|1|0|1|1'),('link_pic_count','0'),('bridge_enable','1'),('language_fallback','1'),('vote_details','0'),('hit_details','0'),('browse_batch_add','1'),('custom_header_path',''),('custom_footer_path',''),('comments_sort_descending','0'),('report_post','0'),('comments_anon_pfx','Guest_'),('admin_activation','0');
/*!40000 ALTER TABLE `cpg_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cpg_dict`
--

DROP TABLE IF EXISTS `cpg_dict`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_dict` (
  `keyId` bigint(20) NOT NULL auto_increment,
  `keyword` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`keyId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Holds the keyword dictionary';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_dict`
--

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

--
-- Table structure for table `cpg_ecards`
--

DROP TABLE IF EXISTS `cpg_ecards`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_ecards` (
  `eid` int(11) NOT NULL auto_increment,
  `sender_name` varchar(50) NOT NULL default '',
  `sender_email` text NOT NULL,
  `recipient_name` varchar(50) NOT NULL default '',
  `recipient_email` text NOT NULL,
  `link` text NOT NULL,
  `date` tinytext NOT NULL,
  `sender_ip` tinytext NOT NULL,
  PRIMARY KEY  (`eid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Used to log ecards';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_ecards`
--

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

--
-- Table structure for table `cpg_exif`
--

DROP TABLE IF EXISTS `cpg_exif`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_exif` (
  `filename` varchar(255) NOT NULL default '',
  `exifData` text NOT NULL,
  UNIQUE KEY `filename` (`filename`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores EXIF data from individual pics';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_exif`
--

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

--
-- Table structure for table `cpg_favpics`
--

DROP TABLE IF EXISTS `cpg_favpics`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_favpics` (
  `user_id` int(11) NOT NULL,
  `user_favpics` text NOT NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores the server side favourites';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_favpics`
--

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

--
-- Table structure for table `cpg_filetypes`
--

DROP TABLE IF EXISTS `cpg_filetypes`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_filetypes` (
  `extension` char(7) NOT NULL default '',
  `mime` char(30) default NULL,
  `content` char(15) default NULL,
  `player` varchar(5) default NULL,
  PRIMARY KEY  (`extension`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Used to store the file extensions';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_filetypes`
--

LOCK TABLES `cpg_filetypes` WRITE;
/*!40000 ALTER TABLE `cpg_filetypes` DISABLE KEYS */;
INSERT INTO `cpg_filetypes` VALUES ('jpg','image/jpg','image',''),('jpeg','image/jpeg','image',''),('jpe','image/jpe','image',''),('gif','image/gif','image',''),('png','image/png','image',''),('bmp','image/bmp','image',''),('jpc','image/jpc','image',''),('jp2','image/jp2','image',''),('jpx','image/jpx','image',''),('jb2','image/jb2','image',''),('swc','image/swc','image','SWF'),('iff','image/iff','image',''),('asf','video/x-ms-asf','movie','WMP'),('asx','video/x-ms-asx','movie','WMP'),('mpg','video/mpeg','movie','WMP'),('mpeg','video/mpeg','movie','WMP'),('wmv','video/x-ms-wmv','movie','WMP'),('swf','application/x-shockwave-flash','movie','SWF'),('avi','video/avi','movie','WMP'),('mov','video/quicktime','movie','QT'),('mp3','audio/mpeg3','audio','WMP'),('midi','audio/midi','audio','WMP'),('mid','audio/midi','audio','WMP'),('wma','audio/x-ms-wma','audio','WMP'),('wav','audio/wav','audio','WMP'),('ogg','audio/ogg','audio',''),('psd','image/psd','image',''),('ram','audio/x-pn-realaudio','document','RMP'),('ra','audio/x-realaudio','document','RMP'),('rm','audio/x-realmedia','document','RMP'),('tiff','image/tiff','document',''),('tif','image/tif','document',''),('doc','application/msword','document',''),('txt','text/plain','document',''),('rtf','text/richtext','document',''),('pdf','application/pdf','document',''),('xls','application/excel','document',''),('pps','application/powerpoint','document',''),('ppt','application/powerpoint','document',''),('zip','application/zip','document',''),('rar','application/rar','document',''),('gz','application/gz','document',''),('mdb','application/msaccess','document','');
/*!40000 ALTER TABLE `cpg_filetypes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cpg_hit_stats`
--

DROP TABLE IF EXISTS `cpg_hit_stats`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_hit_stats` (
  `sid` int(11) NOT NULL auto_increment,
  `pid` varchar(100) NOT NULL default '',
  `ip` varchar(20) NOT NULL default '',
  `search_phrase` varchar(255) NOT NULL default '',
  `sdate` bigint(20) NOT NULL default '0',
  `referer` text NOT NULL,
  `browser` varchar(255) NOT NULL default '',
  `os` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Detailed stats about hits, only used when enabled';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_hit_stats`
--

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

--
-- Table structure for table `cpg_pictures`
--

DROP TABLE IF EXISTS `cpg_pictures`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_pictures` (
  `pid` int(11) NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `filepath` varchar(255) NOT NULL default '',
  `filename` varchar(255) NOT NULL default '',
  `filesize` int(11) NOT NULL default '0',
  `total_filesize` int(11) NOT NULL default '0',
  `pwidth` smallint(6) NOT NULL default '0',
  `pheight` smallint(6) NOT NULL default '0',
  `hits` int(10) NOT NULL default '0',
  `mtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `ctime` int(11) NOT NULL default '0',
  `owner_id` int(11) NOT NULL default '0',
  `owner_name` varchar(40) NOT NULL default '',
  `pic_rating` int(11) NOT NULL default '0',
  `votes` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `caption` text NOT NULL,
  `keywords` varchar(255) NOT NULL default '',
  `approved` enum('YES','NO') NOT NULL default 'NO',
  `galleryicon` int(11) NOT NULL default '0',
  `user1` varchar(255) NOT NULL default '',
  `user2` varchar(255) NOT NULL default '',
  `user3` varchar(255) NOT NULL default '',
  `user4` varchar(255) NOT NULL default '',
  `url_prefix` tinyint(4) NOT NULL default '0',
  `pic_raw_ip` tinytext,
  `pic_hdr_ip` tinytext,
  `lasthit_ip` tinytext,
  `position` int(11) NOT NULL default '0',
  PRIMARY KEY  (`pid`),
  KEY `pic_hits` (`hits`),
  KEY `pic_rate` (`pic_rating`),
  KEY `aid_approved` (`aid`,`approved`),
  KEY `pic_aid` (`aid`),
  KEY `owner_id` (`owner_id`),
  FULLTEXT KEY `search` (`title`,`caption`,`keywords`,`filename`)
) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COMMENT='Used to store data about individual pics';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_pictures`
--

LOCK TABLES `cpg_pictures` WRITE;
/*!40000 ALTER TABLE `cpg_pictures` DISABLE KEYS */;
INSERT INTO `cpg_pictures` VALUES (1,2,'userpics/','89730314_-Users-ssmusser-Desktop-P1010053.jpg',537616,574804,1280,960,118,'2009-06-20 19:16:36',1231393126,0,'Guest',8000,1,'Huskys in the Wild','','','YES',0,'','','','',0,'207.254.41.144','207.254.41.144','166.214.233.7',0),(2,2,'userpics/','IMG_0201.JPG',536201,547381,1600,1200,105,'2009-06-21 18:11:54',1231393238,0,'Guest',0,0,'Husky Takeoff','','','YES',0,'','','','',0,'207.254.41.144','207.254.41.144','24.237.39.58',0),(3,2,'userpics/','DSC00086.JPG',1277518,1292397,2048,1536,109,'2009-06-20 19:35:13',1231393478,0,'Guest',0,0,'Husky Sunset','','','YES',0,'','','','',0,'207.254.41.144','207.254.41.144','166.214.233.7',0),(4,2,'userpics/','02_02_Husky_1.JPG',1942025,1966098,2272,1704,87,'2009-06-20 15:45:14',1231393493,0,'Guest',0,0,'Husky on Hay Field','','','YES',0,'','','','',0,'207.254.41.144','207.254.41.144','74.15.48.137',0),(5,2,'userpics/','Husky_Knik_Glacier.jpg',757629,772660,2592,1944,116,'2009-06-21 18:11:40',1231397284,0,'Guest',0,1,'Husky Photographs','','','YES',0,'','','','',0,'72.35.99.238','72.35.99.238','24.237.39.58',0),(7,3,'userpics/','Fall_Runway_Sept08_002.jpg',160142,189481,1024,768,73,'2009-06-21 18:16:13',1231397506,0,'Guest',5000,2,'Homestead Airstrip On Nizina River','This is our airstrip.  it is one direction land to the west.  2,000 feet long and approximately 100 feet wide.   It can be a little muddy in early spring.  That is Dan Creek in the background -- still active gold mining going on there.','','YES',0,'','','','',0,'72.35.99.238','72.35.99.238','24.237.39.58',0),(8,2,'userpics/','GerogeHusky~0.JPG',143426,171544,1024,768,124,'2009-06-21 18:15:13',1231398289,0,'Guest',0,0,'Husky at Lake George Alaska','','','YES',0,'','','','',0,'72.35.99.238','72.35.99.238','24.237.39.58',0),(9,2,'userpics/','Sourdough_Husky.jpg',175510,220051,768,1024,105,'2009-06-21 19:56:38',1231398456,0,'Guest',0,0,'Husky with Sourdough in Backgroiund','Nizina Homestead','','YES',0,'','','','',0,'72.35.99.238','72.35.99.238','69.251.13.208',0),(10,4,'userpics/','IMG_0365.JPG',162225,187999,640,480,126,'2009-06-21 18:15:35',1231398504,0,'Guest',0,1,'Center console bin and shelf','Console is aluminum, assembled with rivnuts and screws. Removes easily for service.','console','YES',0,'','','','',0,'71.243.198.33','71.243.198.33','71.164.52.47',0),(11,2,'userpics/','0906081230.jpg',77831,101102,640,480,111,'2009-06-20 19:16:17',1231398553,0,'Guest',0,0,'On the river','Gravel bar on the East Fork of the Carson River.','','YES',0,'','','','',0,'71.243.198.33','71.243.198.33','166.214.233.7',0),(12,2,'userpics/','Husky_and_friends.jpg',147876,172226,1650,1275,132,'2009-06-21 18:10:27',1231398655,0,'Guest',0,1,'Bears in Cadence','','','YES',0,'','','','',0,'72.35.99.238','72.35.99.238','24.237.39.58',0),(13,2,'userpics/','HuskyMoose_08_014.jpg',904047,929042,2592,1944,123,'2009-06-21 18:10:09',1231398824,0,'Guest',0,1,'Husky with Moose passing by','','','YES',0,'','','','',0,'72.35.99.238','72.35.99.238','24.237.39.58',0),(14,5,'userpics/','BearpawsWebbSeptt08_002.jpg',19514,36385,448,336,39,'2009-06-21 18:08:41',1231398995,0,'Guest',0,0,'Griz Tracks','','','YES',0,'','','','',0,'72.35.99.238','72.35.99.238','24.237.39.58',0),(15,6,'userpics/10001/','IMG_0629.jpg',128818,150591,1280,960,60,'2009-06-21 18:15:42',1231433353,1,'admin',0,0,'206 and Boeing Business Jet','Galvin parked my 206 next to this BBJ.  Watch out for my prop wash!!','','YES',0,'','','','',0,'207.254.41.144','207.254.41.144','24.237.39.58',0),(17,2,'userpics/','Husky_and_Helicopter.jpg',39458,57759,640,480,122,'2009-06-21 18:10:42',1231452064,0,'Guest',0,0,'Air Support','This guy did a low pass and hover at the airstrip.  My phone camera caught him at the right spot.','Husky Helicopter','YES',0,'','','','',0,'71.0.165.232','71.0.165.232','24.237.39.58',0),(18,2,'userpics/','Red_River_sandbar_6x4-96.jpg',100587,118693,576,384,105,'2009-06-21 18:13:32',1231473429,0,'Guest',10000,1,'Red River sandbar','N478DM - 01/06/04\r\nN33Â° 53&#39; 45.70&quot; W097Â° 27&#39; 33.30&quot;','','YES',0,'','','','',0,'76.186.67.137','76.186.67.137','24.237.39.58',0),(19,2,'userpics/','2005-09-07_Mike_Markham_s_Fly-In_111.JPG',966591,990779,1200,1600,104,'2009-06-20 19:16:33',1231530735,0,'Guest',0,0,'','Final approach to Mike Markham&#39;s Labor Day fly-in','','YES',0,'','','','',0,'216.17.140.27','216.17.140.27','166.214.233.7',0),(20,2,'userpics/','2005-09-07_Mike_Markham_s_Fly-In_105.JPG',937458,958615,1200,1600,99,'2009-06-20 19:16:29',1231530846,0,'Guest',0,0,'','Giving an open door ride ','','YES',0,'','','','',0,'216.17.140.27','216.17.140.27','166.214.233.7',0),(21,2,'userpics/','IMG_6728.jpg',649267,661225,1600,1200,110,'2009-06-21 18:12:39',1231531006,0,'Guest',0,0,'','','','YES',0,'','','','',0,'216.17.140.27','216.17.140.27','24.237.39.58',0),(22,2,'userpics/','IMG_1998.JPG',1244027,1263729,2592,1944,90,'2009-06-21 18:12:12',1231554478,0,'Guest',0,0,'','','','YES',0,'','','','',0,'69.128.156.202','69.128.156.202','24.237.39.58',0),(23,2,'userpics/','IMG_1990.JPG',1508913,1536131,2091,1567,107,'2009-06-21 18:12:09',1231554486,0,'Guest',0,0,'','','','YES',0,'','','','',0,'69.128.156.202','69.128.156.202','24.237.39.58',0),(24,2,'userpics/','IMG_1987.JPG',1175905,1196327,2592,1944,111,'2009-06-21 18:12:05',1231554500,0,'Guest',0,0,'','','','YES',0,'','','','',0,'69.128.156.202','69.128.156.202','24.237.39.58',0),(25,2,'userpics/','IMG_0928.JPG',882845,908563,1865,1398,111,'2009-06-21 18:11:57',1231554518,0,'Guest',0,0,'Fun on the Lake, Northern WI','','','YES',0,'','','','',0,'69.128.156.202','69.128.156.202','24.237.39.58',0),(26,2,'userpics/','Image029_1.jpg',410486,435140,1600,1200,104,'2009-06-21 18:11:50',1231554524,0,'Guest',0,0,'','','','YES',0,'','','','',0,'69.128.156.202','69.128.156.202','24.237.39.58',0),(27,2,'userpics/','husky_1.jpg',1677683,1710689,2547,2111,110,'2009-06-21 18:10:22',1231654115,0,'Guest',0,0,'Arizona backcountry strip, Grand Canyon area...','','','YES',0,'','','','',0,'75.162.99.209','75.162.99.209','24.237.39.58',0),(28,2,'userpics/','n18803856_33603606_466.jpg',39983,57547,453,604,91,'2009-06-21 18:13:20',1231862628,0,'Guest',10000,1,'Husky and Cub formation','','Husky, Supercub, formation, Flight, Airport, Buzzk, low','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','24.237.39.58',0),(29,2,'userpics/','n18803856_33603658_7803.jpg',51789,73384,604,453,82,'2009-06-21 18:13:29',1231862760,0,'Guest',0,0,'Husky Landing at T40','','Aviat, Husky, short, Field, Landing, T40, McGeehee&#39;s Resturant','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','24.237.39.58',0),(30,2,'userpics/','n18803856_33603644_2896.jpg',54372,76240,604,453,84,'2009-06-21 18:13:25',1231862807,0,'Guest',0,0,'Husky and Cub take off','','Formation, Husky, Supercub, Takeoff, Texas, short, Field','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','24.237.39.58',0),(31,2,'userpics/','n16701442_36824568_9075.jpg',32740,47907,604,401,80,'2009-06-21 19:56:22',1231862857,0,'Guest',0,0,'Red River Landing','','Red River, Landing, Beach, Husky, ','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','69.251.13.208',0),(32,2,'userpics/','n16701442_36824550_3452.jpg',40542,57580,401,604,81,'2009-06-21 18:13:04',1231862912,0,'Guest',0,0,'Sunset Shot','','Aviat, Husky, sunset, Tundra, Tires, Sunrise, parked, Night ','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','24.237.39.58',0),(33,2,'userpics/','n16701442_36824548_2669.jpg',43012,60418,604,401,95,'2009-06-21 19:56:48',1231862976,0,'Guest',10000,1,'The Grass is always greener... ','','Husky, Road, Laning, Short, Field, Texas, grass','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','69.251.13.208',0),(34,2,'userpics/','carrie_practicing_husky_jump2.JPG',272626,298456,600,800,110,'2009-06-20 19:35:02',1231863120,0,'Guest',10000,1,'Skydiving the Husky','','Skydiving, Parachute, Freefall, Aviat, Husky, Carrie Dawson, Practice, Jump','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','166.214.233.7',0),(35,2,'userpics/','carrie_practicing_husky_jump.JPG',277157,304822,600,800,122,'2009-06-21 18:14:18',1231863180,0,'Guest',5000,2,'Husky Practice Jump','','Aviat, Husky, Skydive, jump, parachute, freefall, Carrie, Dawson, ','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','24.237.39.58',0),(36,2,'userpics/','DSC_0216.JPG',1437249,1452612,2896,1944,92,'2009-06-20 19:16:58',1232064871,0,'Guest',0,0,'2N2 New Hampshire','Jan 13, 2009','','YES',0,'','','','',0,'75.68.147.77','75.68.147.77','166.214.233.7',0),(37,2,'userpics/','Joni_and_Husky.jpg',34437,51397,604,453,88,'2009-06-21 18:12:55',1232553002,0,'Guest',0,0,'Joni with the Husky','Joni stops to take a quick picture with the husky on a remote beach.','Aviat Husky Beach Bahamas Landing Takeoff STOL short field sand tundra tires horizon blue sky Chet Kuhn','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','24.237.39.58',0),(38,2,'userpics/','Helicopter_and_Husky.jpg',38118,56496,604,453,81,'2009-06-20 19:17:50',1232553092,0,'Guest',6000,1,'Takeing a break ','','Aviat Husky Robinson R-44 Beach Bahamas landing formation short field sand takeoff ocean ','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','166.214.233.7',0),(39,5,'userpics/','Favorite_landing_spot.jpg',63866,90266,604,402,62,'2009-06-21 18:08:58',1232553162,0,'Guest',0,0,'Favorite landing spot','','Robinson R-44 landing pinnical island bahamas bell rock aviat husky chet kuhn','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','24.237.39.58',0),(40,2,'userpics/','Chet_with_his_husky.jpg',42876,64115,604,453,97,'2009-06-20 19:16:53',1232553238,0,'Guest',0,0,'Chet with the Husky','','aviat husky beach tundra tires landing sand short field takeoff stol chet kuhn ocean bahamas beach ','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','166.214.233.7',0),(41,2,'userpics/','Island_background.jpg',29148,43694,604,453,80,'2009-06-21 19:56:55',1232553380,0,'Guest',0,0,'Remote Island Landing','','Aviat Husky Beach Island landing stol sand ocean water chet kuhn take off short field soft ','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','69.251.13.208',0),(42,2,'userpics/','Final_Approach.jpg',44633,67175,453,604,98,'2009-06-20 19:17:06',1232553477,0,'Guest',0,1,'Final Approach','some remote island....','Landing approach sand short aviat husky field sand stol chet kuhn ','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','166.214.233.7',0),(43,2,'userpics/','IMG_2715.JPG',38034,58129,576,384,59,'2009-06-21 18:12:23',1243200219,0,'Guest',0,0,'Ice Fishin&#39;','','','YES',0,'','','','',0,'76.75.57.155','76.75.57.155','24.237.39.58',0),(44,5,'userpics/','IMG_2697.JPG',34653,51879,576,384,35,'2009-06-20 09:45:03',1243200254,0,'Guest',0,0,'Sunset in MT','','','YES',0,'','','','',0,'76.75.57.155','76.75.57.155','75.155.91.78',0),(45,2,'userpics/','IMG_1964.JPG',46985,69032,576,384,57,'2009-06-21 18:11:59',1243200273,0,'Guest',0,0,'Missouri River Sandbar','','','YES',0,'','','','',0,'76.75.57.155','76.75.57.155','24.237.39.58',0),(46,2,'userpics/','IMG_2818.JPG',50770,75530,576,384,51,'2009-06-21 18:12:32',1243200557,0,'Guest',0,0,'Missouri River Breaks, Cow Creek Airport.','','','YES',0,'','','','',0,'76.75.57.155','76.75.57.155','24.237.39.58',0),(47,2,'userpics/','IMG_2708_R1.jpg',25540,40566,576,384,56,'2009-06-21 19:57:03',1243200592,0,'Guest',0,0,'Popping up &quot;VFR Ontop&quot;','','','YES',0,'','','','',0,'76.75.57.155','76.75.57.155','69.251.13.208',0),(62,4,'userpics/10003/','Difference~0.jpg',404055,442933,1200,900,21,'2009-06-21 08:20:20',1243961526,3,'Snowbirdxx',0,0,'Heel Pans for more Legroom','','','YES',0,'','','','',0,'93.132.47.9','93.132.47.9','24.230.134.52',0),(49,4,'userpics/10003/','Kneeroom_tips_001.JPG',224497,253422,1200,900,23,'2009-06-21 18:15:51',1243931949,3,'Snowbirdxx',0,0,'More Legroom / Heelpans','This mod shows the heelpans that provide more legroom for large pilots.','','YES',0,'','','','',0,'93.132.47.9','93.132.47.9','71.164.52.47',0),(48,2,'userpics/','First_Skis_003.jpg',733528,758046,2592,1944,39,'2009-06-21 18:09:41',1243464330,0,'Guest',0,0,'Husky with RF 8001 skis','','','YES',0,'','','','',0,'216.137.216.36','216.137.216.36','24.237.39.58',0),(65,4,'userpics/10003/','AVIATHuskyA1,Pattonville2008,IMG_1676_1net.jpg',113697,142374,800,600,18,'2009-06-21 08:18:32',1244096667,3,'Snowbirdxx',0,0,'Husky with 850s and RF8001 Retract skis','Note the ground clearance','','YES',0,'','','','',0,'95.112.16.201','95.112.16.201','24.230.134.52',0),(50,4,'userpics/10003/','Kneeroom_tips_001~0.JPG',224497,253422,1200,900,19,'2009-06-21 08:31:53',1243932125,3,'Snowbirdxx',0,0,'More Legroom / Heelpans','This mod provides more legroom for large pilots or pilots with large feet.','','YES',0,'','','','',0,'93.132.47.9','93.132.47.9','24.230.134.52',0),(51,4,'userpics/10003/','Difference.jpg',404055,442933,1200,900,17,'2009-06-21 08:19:36',1243932190,3,'Snowbirdxx',0,0,'Letf side has no heelpand, right sid has the prototype installed','Note the difference in Knee clearance','','YES',0,'','','','',0,'93.132.47.9','93.132.47.9','24.230.134.52',0),(63,4,'userpics/10003/','DSC_0030-1.JPG',151816,182139,537,800,14,'2009-06-21 08:21:02',1244096528,3,'Snowbirdxx',0,0,'RF8001 Mainski','Cuvature provides excellent snowhandling','','YES',0,'','','','',0,'95.112.16.201','95.112.16.201','24.230.134.52',0),(64,4,'userpics/10003/','DSC_0027-1.JPG',127124,154284,800,537,17,'2009-06-21 08:20:42',1244096603,3,'Snowbirdxx',0,0,'RF8001 Mainski','27 lbs ea  Hydraulics are connected by a self sealing. self bleeding quick connector','','YES',0,'','','','',0,'95.112.16.201','95.112.16.201','24.230.134.52',0),(55,4,'userpics/10003/','Both~0.jpg',203549,231516,1200,900,19,'2009-06-21 08:18:49',1243933264,3,'Snowbirdxx',0,0,'Tom Ds Husky Mods','','','YES',0,'','','','',0,'93.132.47.9','93.132.47.9','24.230.134.52',0),(56,4,'userpics/10003/','SGSScrew2.jpg',53061,86435,1024,768,30,'2009-06-21 16:27:09',1243933386,3,'Snowbirdxx',0,0,'SGS kit','This is where the SGS kit is located and where the second staple needs to be removed','','YES',0,'','','','',0,'93.132.47.9','93.132.47.9','70.253.75.17',0),(57,4,'userpics/10003/','SGS___Original_Bumper.jpg',16479,30234,800,600,28,'2009-06-21 10:43:54',1243933461,3,'Snowbirdxx',0,0,'SGS kit vs  original Gear stop','Top is the SGS kit on a broken gear, below is the hard original robber stop, which caused the gear to break.','','YES',0,'','','','',0,'93.132.47.9','93.132.47.9','67.185.245.68',0),(59,4,'userpics/10003/','7MA13470179-0020~0.jpg',12368,22622,480,342,13,'2009-06-21 08:17:34',1243933770,3,'Snowbirdxx',0,0,'Wheel Pants for 850s','Behind the wheel is a bulkhead that prevents dirt from acummulating','','YES',0,'','','','',0,'93.132.47.9','93.132.47.9','24.230.134.52',0),(60,4,'userpics/10003/','4MA13470179-0021.jpg',17371,25529,456,697,13,'2009-06-21 08:17:21',1243933800,3,'Snowbirdxx',0,0,'Wheel pants for 850s','Top view','','YES',0,'','','','',0,'93.132.47.9','93.132.47.9','24.230.134.52',0),(61,4,'userpics/10003/','Sidesnowpants.jpg',101786,126755,1024,687,20,'2009-06-21 08:24:07',1243933866,3,'Snowbirdxx',0,0,'Wheel pants for 8509s','Installed in 3&quot; snow. Very classic looking, speed increase very noticable','','YES',0,'','','','',0,'93.132.47.9','93.132.47.9','24.230.134.52',0),(66,4,'userpics/10003/','AVIATHuskyA1,Pattonville10_2_2008,IMG_1672_1_2_netpg.jpg',115886,149632,800,600,20,'2009-06-21 08:18:07',1244096720,3,'Snowbirdxx',0,0,'Husky  w RF 8001','This ground clearance is unmatched ','','YES',0,'','','','',0,'95.112.16.201','95.112.16.201','24.230.134.52',0),(67,4,'userpics/10003/','DSC_0344.JPG',260438,286327,800,537,18,'2009-06-21 08:21:41',1244096767,3,'Snowbirdxx',0,0,'On Skis','Skis are in the Ski landing position. Hydraulics are powered by a small electric pump.','','YES',0,'','','','',0,'95.112.16.201','95.112.16.201','24.230.134.52',0),(68,4,'userpics/10003/','P1000148.JPG',262978,292278,800,600,24,'2009-06-21 16:09:18',1244097992,3,'Snowbirdxx',0,0,'Fuel Cap Fairings','They slide on the existing fuel cap and make you go supersonic.... Dog &amp; copilot are not included','','YES',0,'','','','',0,'95.112.16.201','95.112.16.201','12.189.32.38',0),(69,4,'userpics/10003/','P1000087.JPG',192298,213142,800,450,26,'2009-06-21 08:22:47',1244098040,3,'Snowbirdxx',8000,1,'Fuel Cap fairings','They actually clean up the wing and make you look better on the ramp.','','YES',0,'','','','',0,'95.112.16.201','95.112.16.201','24.230.134.52',0),(70,4,'userpics/10003/','Fuelcaps_056.jpg',63997,81000,800,600,31,'2009-06-21 08:21:47',1244098082,3,'Snowbirdxx',0,0,'Fuel Cap Fairings','The making of the molds','','YES',0,'','','','',0,'95.112.16.201','95.112.16.201','24.230.134.52',0),(71,4,'userpics/10003/','DSC_0343.JPG',259805,284899,800,537,15,'2009-06-21 16:08:57',1244098153,3,'Snowbirdxx',0,0,'Fuel Cap fairings','Looking good on skis and on wheels. They also keep unwanted persons from your fuel cap.','','YES',0,'','','','',0,'95.112.16.201','95.112.16.201','12.189.32.38',0),(72,4,'userpics/10003/','9N7V7685.jpg',153585,177238,800,532,19,'2009-06-21 08:17:39',1244098294,3,'Snowbirdxx',0,0,'Fuel Cap fairings','Flow visualisation showed that the airflow stays attached with the fairing installed. If you would add 10 fuelcaps as they come from the factory along the wingspan, it will slow you down more than 20 kts and the Husky would hardly be able to fly.','','YES',0,'','','','',0,'95.112.16.201','95.112.16.201','24.230.134.52',0);
/*!40000 ALTER TABLE `cpg_pictures` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cpg_plugins`
--

DROP TABLE IF EXISTS `cpg_plugins`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_plugins` (
  `plugin_id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  `path` varchar(128) NOT NULL default '',
  `priority` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`plugin_id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `path` (`path`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores the plugins';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_plugins`
--

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

--
-- Table structure for table `cpg_sessions`
--

DROP TABLE IF EXISTS `cpg_sessions`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_sessions` (
  `session_id` varchar(40) NOT NULL default '',
  `user_id` int(11) default '0',
  `time` int(11) default NULL,
  `remember` int(1) default '0',
  PRIMARY KEY  (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Used to store sessions';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_sessions`
--

LOCK TABLES `cpg_sessions` WRITE;
/*!40000 ALTER TABLE `cpg_sessions` DISABLE KEYS */;
INSERT INTO `cpg_sessions` VALUES ('91a0d58a1686d35c65c86654c97231d7',1,1243549476,0);
/*!40000 ALTER TABLE `cpg_sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cpg_temp_data`
--

DROP TABLE IF EXISTS `cpg_temp_data`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_temp_data` (
  `unique_ID` char(8) NOT NULL,
  `encoded_string` blob NOT NULL,
  `timestamp` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`unique_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Holds temporary file data for multiple file uploads';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_temp_data`
--

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

--
-- Table structure for table `cpg_usergroups`
--

DROP TABLE IF EXISTS `cpg_usergroups`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_usergroups` (
  `group_id` int(11) NOT NULL auto_increment,
  `group_name` varchar(255) NOT NULL default '',
  `group_quota` int(11) NOT NULL default '0',
  `has_admin_access` tinyint(4) NOT NULL default '0',
  `can_rate_pictures` tinyint(4) NOT NULL default '0',
  `can_send_ecards` tinyint(4) NOT NULL default '0',
  `can_post_comments` tinyint(4) NOT NULL default '0',
  `can_upload_pictures` tinyint(4) NOT NULL default '0',
  `can_create_albums` tinyint(4) NOT NULL default '0',
  `pub_upl_need_approval` tinyint(4) NOT NULL default '1',
  `priv_upl_need_approval` tinyint(4) NOT NULL default '1',
  `upload_form_config` tinyint(4) NOT NULL default '3',
  `custom_user_upload` tinyint(4) NOT NULL default '0',
  `num_file_upload` tinyint(4) NOT NULL default '5',
  `num_URI_upload` tinyint(4) NOT NULL default '3',
  PRIMARY KEY  (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Used to store user groups';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_usergroups`
--

LOCK TABLES `cpg_usergroups` WRITE;
/*!40000 ALTER TABLE `cpg_usergroups` DISABLE KEYS */;
INSERT INTO `cpg_usergroups` VALUES (1,'Administrators',0,1,1,1,1,1,1,0,0,3,0,5,3),(2,'Registered',1024,0,1,1,1,1,1,1,0,3,0,5,3),(3,'Guests',0,0,1,0,0,0,0,1,1,0,0,5,3),(4,'Banned',0,0,0,0,0,0,0,1,1,0,0,5,3);
/*!40000 ALTER TABLE `cpg_usergroups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cpg_users`
--

DROP TABLE IF EXISTS `cpg_users`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_users` (
  `user_id` int(11) NOT NULL auto_increment,
  `user_group` int(11) NOT NULL default '2',
  `user_active` enum('YES','NO') NOT NULL default 'NO',
  `user_name` varchar(25) NOT NULL default '',
  `user_password` varchar(40) NOT NULL default '',
  `user_lastvisit` datetime NOT NULL default '0000-00-00 00:00:00',
  `user_regdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `user_group_list` varchar(255) NOT NULL default '',
  `user_email` varchar(255) NOT NULL default '',
  `user_profile1` varchar(255) NOT NULL default '',
  `user_profile2` varchar(255) NOT NULL default '',
  `user_profile3` varchar(255) NOT NULL default '',
  `user_profile4` varchar(255) NOT NULL default '',
  `user_profile5` varchar(255) NOT NULL default '',
  `user_profile6` text NOT NULL,
  `user_actkey` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `user_name` (`user_name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Used to store users, not used when bridged';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_users`
--

LOCK TABLES `cpg_users` WRITE;
/*!40000 ALTER TABLE `cpg_users` DISABLE KEYS */;
INSERT INTO `cpg_users` VALUES (1,1,'YES','admin','5db2e9b6dee918c0f5b79deecbf073d5','2009-05-28 15:52:14','2008-08-08 09:54:50','','you@yourdomain.com','','','','','','','');
/*!40000 ALTER TABLE `cpg_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cpg_vote_stats`
--

DROP TABLE IF EXISTS `cpg_vote_stats`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_vote_stats` (
  `sid` int(11) NOT NULL auto_increment,
  `pid` varchar(100) NOT NULL default '',
  `rating` smallint(6) NOT NULL default '0',
  `ip` varchar(20) NOT NULL default '',
  `sdate` bigint(20) NOT NULL default '0',
  `referer` text NOT NULL,
  `browser` varchar(255) NOT NULL default '',
  `os` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Detailed stats about votes, only used when enabled';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_vote_stats`
--

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

--
-- Table structure for table `cpg_votes`
--

DROP TABLE IF EXISTS `cpg_votes`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cpg_votes` (
  `pic_id` mediumint(9) NOT NULL default '0',
  `user_md5_id` varchar(32) NOT NULL default '',
  `vote_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`pic_id`,`user_md5_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores votes for individual pics';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cpg_votes`
--

LOCK TABLES `cpg_votes` WRITE;
/*!40000 ALTER TABLE `cpg_votes` DISABLE KEYS */;
INSERT INTO `cpg_votes` VALUES (35,'d2fd1c4c96cc79a9b52f0ad6c0a0ae48',1245027005),(38,'f451889cb023dc4fed5b4aaf9a858f0b',1244474568),(12,'87854d82b3583c7d355dffb57bfce608',1243520704),(7,'6ab2a1c75bf91b5cda5a087be3490091',1243361648),(10,'3b9297865568511f5f9724e86926b99f',1243339334),(69,'1d8a327c52660fab6557e991bf570ab1',1244218077);
/*!40000 ALTER TABLE `cpg_votes` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!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 */;

-- Dump completed on 2009-06-22  2:26:08
