-- 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=8 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);
/*!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=19 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',''),('license_number',''),('db_database_name',''),('db_hostname',''),('db_username',''),('db_password',''),('full_forum_url',''),('relative_path_of_forum_from_webroot',''),('relative_path_to_config_file',''),('logout_flag',''),('use_post_based_groups',''),('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','0'),('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=43 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,59,'2009-04-23 17:00:31',1231393126,0,'Guest',8000,1,'Huskys in the Wild','','','YES',0,'','','','',0,'207.254.41.144','207.254.41.144','75.68.147.77',0),(2,2,'userpics/','IMG_0201.JPG',536201,547381,1600,1200,53,'2009-04-19 17:24:15',1231393238,0,'Guest',0,0,'Husky Takeoff','','','YES',0,'','','','',0,'207.254.41.144','207.254.41.144','75.100.92.140',0),(3,2,'userpics/','DSC00086.JPG',1277518,1292397,2048,1536,53,'2009-04-23 17:01:24',1231393478,0,'Guest',0,0,'Husky Sunset','','','YES',0,'','','','',0,'207.254.41.144','207.254.41.144','75.68.147.77',0),(4,2,'userpics/','02_02_Husky_1.JPG',1942025,1966098,2272,1704,44,'2009-04-19 17:23:27',1231393493,0,'Guest',0,0,'Husky on Hay Field','','','YES',0,'','','','',0,'207.254.41.144','207.254.41.144','75.100.92.140',0),(5,2,'userpics/','Husky_Knik_Glacier.jpg',757629,772660,2592,1944,61,'2009-05-06 03:12:49',1231397284,0,'Guest',0,1,'Husky Photographs','','','YES',0,'','','','',0,'72.35.99.238','72.35.99.238','38.105.83.11',0),(7,3,'userpics/','Fall_Runway_Sept08_002.jpg',160142,189481,1024,768,31,'2009-05-04 09:30:09',1231397506,0,'Guest',0,1,'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','72.160.103.34',0),(8,2,'userpics/','GerogeHusky~0.JPG',143426,171544,1024,768,57,'2009-05-01 09:15:48',1231398289,0,'Guest',0,0,'Husky at Lake George Alaska','','','YES',0,'','','','',0,'72.35.99.238','72.35.99.238','216.47.56.69',0),(9,2,'userpics/','Sourdough_Husky.jpg',175510,220051,768,1024,51,'2009-04-19 17:24:50',1231398456,0,'Guest',0,0,'Husky with Sourdough in Backgroiund','Nizina Homestead','','YES',0,'','','','',0,'72.35.99.238','72.35.99.238','75.100.92.140',0),(10,4,'userpics/','IMG_0365.JPG',162225,187999,640,480,61,'2009-05-04 09:29:21',1231398504,0,'Guest',0,0,'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','72.160.103.34',0),(11,2,'userpics/','0906081230.jpg',77831,101102,640,480,54,'2009-04-19 17:23:25',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','75.100.92.140',0),(12,2,'userpics/','Husky_and_friends.jpg',147876,172226,1650,1275,65,'2009-04-19 17:24:02',1231398655,0,'Guest',0,0,'Bears in Cadence','','','YES',0,'','','','',0,'72.35.99.238','72.35.99.238','75.100.92.140',0),(13,2,'userpics/','HuskyMoose_08_014.jpg',904047,929042,2592,1944,61,'2009-05-01 09:15:58',1231398824,0,'Guest',0,1,'Husky with Moose passing by','','','YES',0,'','','','',0,'72.35.99.238','72.35.99.238','216.47.56.69',0),(14,5,'userpics/','BearpawsWebbSeptt08_002.jpg',19514,36385,448,336,16,'2009-01-19 15:35:15',1231398995,0,'Guest',0,0,'Griz Tracks','','','YES',0,'','','','',0,'72.35.99.238','72.35.99.238','71.164.45.142',0),(15,6,'userpics/10001/','IMG_0629.jpg',128818,150591,1280,960,30,'2009-04-15 16:44:32',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','67.112.103.142',0),(17,2,'userpics/','Husky_and_Helicopter.jpg',39458,57759,640,480,61,'2009-04-19 17:24:04',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','75.100.92.140',0),(18,2,'userpics/','Red_River_sandbar_6x4-96.jpg',100587,118693,576,384,53,'2009-04-19 17:24:46',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','75.100.92.140',0),(19,2,'userpics/','2005-09-07_Mike_Markham_s_Fly-In_111.JPG',966591,990779,1200,1600,50,'2009-04-19 17:23:20',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','75.100.92.140',0),(20,2,'userpics/','2005-09-07_Mike_Markham_s_Fly-In_105.JPG',937458,958615,1200,1600,46,'2009-04-19 17:23:21',1231530846,0,'Guest',0,0,'','Giving an open door ride ','','YES',0,'','','','',0,'216.17.140.27','216.17.140.27','75.100.92.140',0),(21,2,'userpics/','IMG_6728.jpg',649267,661225,1600,1200,52,'2009-04-19 17:24:21',1231531006,0,'Guest',0,0,'','','','YES',0,'','','','',0,'216.17.140.27','216.17.140.27','75.100.92.140',0),(22,2,'userpics/','IMG_1998.JPG',1244027,1263729,2592,1944,34,'2009-04-19 17:24:20',1231554478,0,'Guest',0,0,'','','','YES',0,'','','','',0,'69.128.156.202','69.128.156.202','75.100.92.140',0),(23,2,'userpics/','IMG_1990.JPG',1508913,1536131,2091,1567,44,'2009-04-19 17:24:19',1231554486,0,'Guest',0,0,'','','','YES',0,'','','','',0,'69.128.156.202','69.128.156.202','75.100.92.140',0),(24,2,'userpics/','IMG_1987.JPG',1175905,1196327,2592,1944,44,'2009-04-19 17:24:17',1231554500,0,'Guest',0,0,'','','','YES',0,'','','','',0,'69.128.156.202','69.128.156.202','75.100.92.140',0),(25,2,'userpics/','IMG_0928.JPG',882845,908563,1865,1398,47,'2009-04-19 17:24:16',1231554518,0,'Guest',0,0,'Fun on the Lake, Northern WI','','','YES',0,'','','','',0,'69.128.156.202','69.128.156.202','75.100.92.140',0),(26,2,'userpics/','Image029_1.jpg',410486,435140,1600,1200,45,'2009-04-19 17:24:13',1231554524,0,'Guest',0,0,'','','','YES',0,'','','','',0,'69.128.156.202','69.128.156.202','75.100.92.140',0),(27,2,'userpics/','husky_1.jpg',1677683,1710689,2547,2111,36,'2009-05-01 09:15:28',1231654115,0,'Guest',0,0,'Arizona backcountry strip, Grand Canyon area...','','','YES',0,'','','','',0,'75.162.99.209','75.162.99.209','216.47.56.69',0),(28,2,'userpics/','n18803856_33603606_466.jpg',39983,57547,453,604,26,'2009-05-04 09:29:45',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','72.160.103.34',0),(29,2,'userpics/','n18803856_33603658_7803.jpg',51789,73384,604,453,23,'2009-04-19 17:24:44',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','75.100.92.140',0),(30,2,'userpics/','n18803856_33603644_2896.jpg',54372,76240,604,453,21,'2009-04-19 17:24:42',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','75.100.92.140',0),(31,2,'userpics/','n16701442_36824568_9075.jpg',32740,47907,604,401,22,'2009-04-19 17:24:35',1231862857,0,'Guest',0,0,'Red River Landing','','Red River, Landing, Beach, Husky, ','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','75.100.92.140',0),(32,2,'userpics/','n16701442_36824550_3452.jpg',40542,57580,401,604,24,'2009-04-19 17:24:33',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','75.100.92.140',0),(33,2,'userpics/','n16701442_36824548_2669.jpg',43012,60418,604,401,27,'2009-04-19 17:24:27',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','75.100.92.140',0),(34,2,'userpics/','carrie_practicing_husky_jump2.JPG',272626,298456,600,800,39,'2009-04-23 17:01:08',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','75.68.147.77',0),(35,2,'userpics/','carrie_practicing_husky_jump.JPG',277157,304822,600,800,44,'2009-04-23 17:00:52',1231863180,0,'Guest',10000,1,'Husky Practice Jump','','Aviat, Husky, Skydive, jump, parachute, freefall, Carrie, Dawson, ','YES',0,'','','','',0,'216.133.2.65','216.133.2.65','75.68.147.77',0),(36,2,'userpics/','DSC_0216.JPG',1437249,1452612,2896,1944,25,'2009-04-23 17:01:27',1232064871,0,'Guest',0,0,'2N2 New Hampshire','Jan 13, 2009','','YES',0,'','','','',0,'75.68.147.77','75.68.147.77','75.68.147.77',0),(37,2,'userpics/','Joni_and_Husky.jpg',34437,51397,604,453,19,'2009-04-19 17:24:24',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','75.100.92.140',0),(38,2,'userpics/','Helicopter_and_Husky.jpg',38118,56496,604,453,12,'2009-05-01 09:15:41',1232553092,0,'Guest',0,0,'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','216.47.56.69',0),(39,5,'userpics/','Favorite_landing_spot.jpg',63866,90266,604,402,15,'2009-04-14 20:11:04',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','76.247.173.221',0),(40,2,'userpics/','Chet_with_his_husky.jpg',42876,64115,604,453,17,'2009-04-23 17:01:17',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','75.68.147.77',0),(41,2,'userpics/','Island_background.jpg',29148,43694,604,453,13,'2009-04-19 17:24:22',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','75.100.92.140',0),(42,2,'userpics/','Final_Approach.jpg',44633,67175,453,604,18,'2009-04-23 17:03: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','75.68.147.77',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 ('192caabf4179a8781490ff927f9ba67c',0,1242364738,0),('dec3d02794823b3241f7e7515c1fb4bb',0,1242368194,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',2048,0,1,0,0,1,0,1,1,3,0,5,3),(4,'Banned',0,0,0,0,0,0,0,0,0,0,0,0,0);
/*!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-14 15:39:20','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 (5,'7a5fdfff55f1c8669eae79d8fbc4e628',1241601172);
/*!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-05-15  6:16:53
