-- /usr/local/nf/bin/mysqldump --force --quick --quote-names -h mysqlhost -u u70365513 -p2a07b3 d60334884 cpg1410_2_albums cpg1410_2_banned cpg1410_2_bridge cpg1410_2_categories cpg1410_2_comments cpg1410_2_config cpg1410_2_dict cpg1410_2_ecards cpg1410_2_exif cpg1410_2_favpics cpg1410_2_filetypes cpg1410_2_hit_stats cpg1410_2_pictures cpg1410_2_plugins cpg1410_2_sessions cpg1410_2_shop cpg1410_2_shop_config cpg1410_2_shop_prices cpg1410_2_temp_data cpg1410_2_usergroups cpg1410_2_users cpg1410_2_vote_stats cpg1410_2_votes -- -- MySQL dump 8.22 -- -- Host: mysqlhost Database: d60334884 --------------------------------------------------------- -- Server version 5.0.24a-log -- -- Table structure for table 'cpg1410_2_albums' -- CREATE TABLE `cpg1410_2_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=2 DEFAULT CHARSET=latin1 COMMENT='Used to store albums'; -- -- Dumping data for table 'cpg1410_2_albums' -- INSERT INTO `cpg1410_2_albums` VALUES (1,'Volleyball','',0,'NO','YES','YES',1,0,0,NULL,NULL,NULL); -- -- Table structure for table 'cpg1410_2_banned' -- CREATE TABLE `cpg1410_2_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 DEFAULT CHARSET=latin1 COMMENT='Data about banned users'; -- -- Dumping data for table 'cpg1410_2_banned' -- -- -- Table structure for table 'cpg1410_2_bridge' -- CREATE TABLE `cpg1410_2_bridge` ( `name` varchar(40) NOT NULL default '0', `value` varchar(255) NOT NULL default '', UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores the bridging data, not used when unbridged'; -- -- Dumping data for table 'cpg1410_2_bridge' -- INSERT INTO `cpg1410_2_bridge` VALUES ('short_name',''); INSERT INTO `cpg1410_2_bridge` VALUES ('license_number',''); INSERT INTO `cpg1410_2_bridge` VALUES ('db_database_name',''); INSERT INTO `cpg1410_2_bridge` VALUES ('db_hostname',''); INSERT INTO `cpg1410_2_bridge` VALUES ('db_username',''); INSERT INTO `cpg1410_2_bridge` VALUES ('db_password',''); INSERT INTO `cpg1410_2_bridge` VALUES ('full_forum_url',''); INSERT INTO `cpg1410_2_bridge` VALUES ('relative_path_of_forum_from_webroot',''); INSERT INTO `cpg1410_2_bridge` VALUES ('relative_path_to_config_file',''); INSERT INTO `cpg1410_2_bridge` VALUES ('logout_flag',''); INSERT INTO `cpg1410_2_bridge` VALUES ('use_post_based_groups',''); INSERT INTO `cpg1410_2_bridge` VALUES ('cookie_prefix',''); INSERT INTO `cpg1410_2_bridge` VALUES ('table_prefix',''); INSERT INTO `cpg1410_2_bridge` VALUES ('user_table',''); INSERT INTO `cpg1410_2_bridge` VALUES ('session_table',''); INSERT INTO `cpg1410_2_bridge` VALUES ('group_table',''); INSERT INTO `cpg1410_2_bridge` VALUES ('group_relation_table',''); INSERT INTO `cpg1410_2_bridge` VALUES ('group_mapping_table',''); INSERT INTO `cpg1410_2_bridge` VALUES ('use_standard_groups','1'); INSERT INTO `cpg1410_2_bridge` VALUES ('validating_group',''); INSERT INTO `cpg1410_2_bridge` VALUES ('guest_group',''); INSERT INTO `cpg1410_2_bridge` VALUES ('member_group',''); INSERT INTO `cpg1410_2_bridge` VALUES ('admin_group',''); INSERT INTO `cpg1410_2_bridge` VALUES ('banned_group',''); INSERT INTO `cpg1410_2_bridge` VALUES ('global_moderators_group',''); INSERT INTO `cpg1410_2_bridge` VALUES ('recovery_logon_failures','0'); INSERT INTO `cpg1410_2_bridge` VALUES ('recovery_logon_timestamp',''); -- -- Table structure for table 'cpg1410_2_categories' -- CREATE TABLE `cpg1410_2_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=3 DEFAULT CHARSET=latin1 COMMENT='Used to store categories'; -- -- Dumping data for table 'cpg1410_2_categories' -- INSERT INTO `cpg1410_2_categories` VALUES (1,0,'User galleries','This category contains albums that belong to Coppermine users.',0,0,0); INSERT INTO `cpg1410_2_categories` VALUES (2,0,'Sports','',1,0,0); -- -- Table structure for table 'cpg1410_2_comments' -- CREATE TABLE `cpg1410_2_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 DEFAULT CHARSET=latin1 COMMENT='Used to store comments made on pics'; -- -- Dumping data for table 'cpg1410_2_comments' -- -- -- Table structure for table 'cpg1410_2_config' -- CREATE TABLE `cpg1410_2_config` ( `name` varchar(40) NOT NULL default '', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store the configuration options'; -- -- Dumping data for table 'cpg1410_2_config' -- INSERT INTO `cpg1410_2_config` VALUES ('albums_per_page','12'); INSERT INTO `cpg1410_2_config` VALUES ('album_list_cols','2'); INSERT INTO `cpg1410_2_config` VALUES ('display_pic_info','0'); INSERT INTO `cpg1410_2_config` VALUES ('alb_list_thumb_size','50'); INSERT INTO `cpg1410_2_config` VALUES ('allowed_mov_types','ALL'); INSERT INTO `cpg1410_2_config` VALUES ('allowed_doc_types','doc/txt/rtf/pdf/xls/pps/ppt/zip/gz/mdb'); INSERT INTO `cpg1410_2_config` VALUES ('allowed_snd_types','mp3/midi/mid/wma/wav/ogg'); INSERT INTO `cpg1410_2_config` VALUES ('allowed_img_types','ALL'); INSERT INTO `cpg1410_2_config` VALUES ('allow_private_albums','1'); INSERT INTO `cpg1410_2_config` VALUES ('allow_user_registration','0'); INSERT INTO `cpg1410_2_config` VALUES ('allow_unlogged_access','1'); INSERT INTO `cpg1410_2_config` VALUES ('allow_duplicate_emails_addr','0'); INSERT INTO `cpg1410_2_config` VALUES ('caption_in_thumbview','1'); INSERT INTO `cpg1410_2_config` VALUES ('views_in_thumbview','1'); INSERT INTO `cpg1410_2_config` VALUES ('charset','utf-8'); INSERT INTO `cpg1410_2_config` VALUES ('cookie_name','cpg143'); INSERT INTO `cpg1410_2_config` VALUES ('cookie_path','/'); INSERT INTO `cpg1410_2_config` VALUES ('debug_mode','0'); INSERT INTO `cpg1410_2_config` VALUES ('debug_notice','0'); INSERT INTO `cpg1410_2_config` VALUES ('default_dir_mode','0755'); INSERT INTO `cpg1410_2_config` VALUES ('default_file_mode','0644'); INSERT INTO `cpg1410_2_config` VALUES ('default_sort_order','na'); INSERT INTO `cpg1410_2_config` VALUES ('ecards_more_pic_target','http://www.shayphoto.ca/cpg1410_2/'); INSERT INTO `cpg1410_2_config` VALUES ('home_target','index.php'); INSERT INTO `cpg1410_2_config` VALUES ('custom_lnk_name',''); INSERT INTO `cpg1410_2_config` VALUES ('custom_lnk_url',''); INSERT INTO `cpg1410_2_config` VALUES ('enable_smilies','1'); INSERT INTO `cpg1410_2_config` VALUES ('filter_bad_words','0'); INSERT INTO `cpg1410_2_config` VALUES ('forbiden_fname_char','$/\\\\:*?"\'<>|` &'); INSERT INTO `cpg1410_2_config` VALUES ('fullpath','albums/'); INSERT INTO `cpg1410_2_config` VALUES ('gallery_admin_email','chris@shayphoto.ca'); INSERT INTO `cpg1410_2_config` VALUES ('gallery_description','Your online photo album'); INSERT INTO `cpg1410_2_config` VALUES ('gallery_name','Coppermine Photo Gallery'); INSERT INTO `cpg1410_2_config` VALUES ('im_options','-antialias'); INSERT INTO `cpg1410_2_config` VALUES ('impath',''); INSERT INTO `cpg1410_2_config` VALUES ('jpeg_qual','80'); INSERT INTO `cpg1410_2_config` VALUES ('keep_votes_time','30'); INSERT INTO `cpg1410_2_config` VALUES ('lang','english'); INSERT INTO `cpg1410_2_config` VALUES ('main_page_layout','breadcrumb/catlist/alblist/random,2/lastup,2'); INSERT INTO `cpg1410_2_config` VALUES ('main_table_width','100%'); INSERT INTO `cpg1410_2_config` VALUES ('make_intermediate','1'); INSERT INTO `cpg1410_2_config` VALUES ('max_com_lines','10'); INSERT INTO `cpg1410_2_config` VALUES ('max_com_size','512'); INSERT INTO `cpg1410_2_config` VALUES ('max_com_wlength','38'); INSERT INTO `cpg1410_2_config` VALUES ('max_img_desc_length','512'); INSERT INTO `cpg1410_2_config` VALUES ('max_tabs','12'); INSERT INTO `cpg1410_2_config` VALUES ('max_upl_size','1024'); INSERT INTO `cpg1410_2_config` VALUES ('max_upl_width_height','2048'); INSERT INTO `cpg1410_2_config` VALUES ('auto_resize','0'); INSERT INTO `cpg1410_2_config` VALUES ('min_votes_for_rating','1'); INSERT INTO `cpg1410_2_config` VALUES ('normal_pfx','normal_'); INSERT INTO `cpg1410_2_config` VALUES ('offline','0'); INSERT INTO `cpg1410_2_config` VALUES ('picture_table_width','600'); INSERT INTO `cpg1410_2_config` VALUES ('picture_width','400'); INSERT INTO `cpg1410_2_config` VALUES ('read_exif_data','0'); INSERT INTO `cpg1410_2_config` VALUES ('reg_requires_valid_email','1'); INSERT INTO `cpg1410_2_config` VALUES ('subcat_level','2'); INSERT INTO `cpg1410_2_config` VALUES ('theme','core'); INSERT INTO `cpg1410_2_config` VALUES ('thumbcols','4'); INSERT INTO `cpg1410_2_config` VALUES ('thumbrows','3'); INSERT INTO `cpg1410_2_config` VALUES ('thumb_method','gd2'); INSERT INTO `cpg1410_2_config` VALUES ('thumb_pfx','thumb_'); INSERT INTO `cpg1410_2_config` VALUES ('thumb_width','100'); INSERT INTO `cpg1410_2_config` VALUES ('userpics','userpics/'); INSERT INTO `cpg1410_2_config` VALUES ('vanity_block','1'); INSERT INTO `cpg1410_2_config` VALUES ('user_profile1_name','Location'); INSERT INTO `cpg1410_2_config` VALUES ('user_profile2_name','Interests'); INSERT INTO `cpg1410_2_config` VALUES ('user_profile3_name','Website'); INSERT INTO `cpg1410_2_config` VALUES ('user_profile4_name','Occupation'); INSERT INTO `cpg1410_2_config` VALUES ('user_profile5_name',''); INSERT INTO `cpg1410_2_config` VALUES ('user_profile6_name','Biography'); INSERT INTO `cpg1410_2_config` VALUES ('user_field1_name',''); INSERT INTO `cpg1410_2_config` VALUES ('user_field2_name',''); INSERT INTO `cpg1410_2_config` VALUES ('user_field3_name',''); INSERT INTO `cpg1410_2_config` VALUES ('user_field4_name',''); INSERT INTO `cpg1410_2_config` VALUES ('display_comment_count','0'); INSERT INTO `cpg1410_2_config` VALUES ('show_private','0'); INSERT INTO `cpg1410_2_config` VALUES ('first_level','1'); INSERT INTO `cpg1410_2_config` VALUES ('display_film_strip','1'); INSERT INTO `cpg1410_2_config` VALUES ('display_film_strip_filename','0'); INSERT INTO `cpg1410_2_config` VALUES ('max_film_strip_items','5'); INSERT INTO `cpg1410_2_config` VALUES ('thumb_use','any'); INSERT INTO `cpg1410_2_config` VALUES ('read_iptc_data','0'); INSERT INTO `cpg1410_2_config` VALUES ('reg_notify_admin_email','0'); INSERT INTO `cpg1410_2_config` VALUES ('disable_comment_flood_protect','0'); INSERT INTO `cpg1410_2_config` VALUES ('upl_notify_admin_email','0'); INSERT INTO `cpg1410_2_config` VALUES ('display_uploader','0'); INSERT INTO `cpg1410_2_config` VALUES ('display_filename','0'); INSERT INTO `cpg1410_2_config` VALUES ('language_list','0'); INSERT INTO `cpg1410_2_config` VALUES ('language_flags','0'); INSERT INTO `cpg1410_2_config` VALUES ('theme_list','0'); INSERT INTO `cpg1410_2_config` VALUES ('language_reset','1'); INSERT INTO `cpg1410_2_config` VALUES ('theme_reset','1'); INSERT INTO `cpg1410_2_config` VALUES ('allow_memberlist','0'); INSERT INTO `cpg1410_2_config` VALUES ('display_faq','0'); INSERT INTO `cpg1410_2_config` VALUES ('show_bbcode_help','1'); INSERT INTO `cpg1410_2_config` VALUES ('log_ecards','0'); INSERT INTO `cpg1410_2_config` VALUES ('email_comment_notification','0'); INSERT INTO `cpg1410_2_config` VALUES ('enable_zipdownload','1'); INSERT INTO `cpg1410_2_config` VALUES ('slideshow_interval','5000'); INSERT INTO `cpg1410_2_config` VALUES ('log_mode','0'); INSERT INTO `cpg1410_2_config` VALUES ('media_autostart','1'); INSERT INTO `cpg1410_2_config` VALUES ('enable_encrypted_passwords','1'); INSERT INTO `cpg1410_2_config` VALUES ('time_offset','0'); INSERT INTO `cpg1410_2_config` VALUES ('ban_private_ip','0'); INSERT INTO `cpg1410_2_config` VALUES ('smtp_host',''); INSERT INTO `cpg1410_2_config` VALUES ('smtp_username',''); INSERT INTO `cpg1410_2_config` VALUES ('smtp_password',''); INSERT INTO `cpg1410_2_config` VALUES ('enable_plugins','1'); INSERT INTO `cpg1410_2_config` VALUES ('enable_help','2'); INSERT INTO `cpg1410_2_config` VALUES ('categories_alpha_sort','0'); INSERT INTO `cpg1410_2_config` VALUES ('login_threshold','5'); INSERT INTO `cpg1410_2_config` VALUES ('login_expiry','10'); INSERT INTO `cpg1410_2_config` VALUES ('allow_email_change','0'); INSERT INTO `cpg1410_2_config` VALUES ('clickable_keyword_search','1'); INSERT INTO `cpg1410_2_config` VALUES ('users_can_edit_pics','0'); INSERT INTO `cpg1410_2_config` VALUES ('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'); INSERT INTO `cpg1410_2_config` VALUES ('alb_desc_thumb','1'); INSERT INTO `cpg1410_2_config` VALUES ('link_pic_count','0'); INSERT INTO `cpg1410_2_config` VALUES ('bridge_enable','0'); INSERT INTO `cpg1410_2_config` VALUES ('language_fallback','1'); INSERT INTO `cpg1410_2_config` VALUES ('vote_details','0'); INSERT INTO `cpg1410_2_config` VALUES ('hit_details','0'); INSERT INTO `cpg1410_2_config` VALUES ('browse_batch_add','1'); INSERT INTO `cpg1410_2_config` VALUES ('custom_header_path',''); INSERT INTO `cpg1410_2_config` VALUES ('custom_footer_path',''); INSERT INTO `cpg1410_2_config` VALUES ('comments_sort_descending','0'); INSERT INTO `cpg1410_2_config` VALUES ('report_post','0'); INSERT INTO `cpg1410_2_config` VALUES ('comments_anon_pfx','Guest_'); INSERT INTO `cpg1410_2_config` VALUES ('admin_activation','0'); -- -- Table structure for table 'cpg1410_2_dict' -- CREATE TABLE `cpg1410_2_dict` ( `keyId` bigint(20) NOT NULL auto_increment, `keyword` varchar(60) NOT NULL default '', PRIMARY KEY (`keyId`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Holds the keyword dictionary'; -- -- Dumping data for table 'cpg1410_2_dict' -- -- -- Table structure for table 'cpg1410_2_ecards' -- CREATE TABLE `cpg1410_2_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=latin1 COMMENT='Used to log ecards'; -- -- Dumping data for table 'cpg1410_2_ecards' -- -- -- Table structure for table 'cpg1410_2_exif' -- CREATE TABLE `cpg1410_2_exif` ( `filename` varchar(255) NOT NULL default '', `exifData` text NOT NULL, UNIQUE KEY `filename` (`filename`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores EXIF data from individual pics'; -- -- Dumping data for table 'cpg1410_2_exif' -- -- -- Table structure for table 'cpg1410_2_favpics' -- CREATE TABLE `cpg1410_2_favpics` ( `user_id` int(11) NOT NULL, `user_favpics` text NOT NULL, PRIMARY KEY (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores the server side favourites'; -- -- Dumping data for table 'cpg1410_2_favpics' -- -- -- Table structure for table 'cpg1410_2_filetypes' -- CREATE TABLE `cpg1410_2_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=latin1 COMMENT='Used to store the file extensions'; -- -- Dumping data for table 'cpg1410_2_filetypes' -- INSERT INTO `cpg1410_2_filetypes` VALUES ('jpg','image/jpg','image',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('jpeg','image/jpeg','image',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('jpe','image/jpe','image',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('gif','image/gif','image',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('png','image/png','image',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('bmp','image/bmp','image',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('jpc','image/jpc','image',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('jp2','image/jp2','image',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('jpx','image/jpx','image',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('jb2','image/jb2','image',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('swc','image/swc','image',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('iff','image/iff','image',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('asf','video/x-ms-asf','movie','WMP'); INSERT INTO `cpg1410_2_filetypes` VALUES ('asx','video/x-ms-asx','movie','WMP'); INSERT INTO `cpg1410_2_filetypes` VALUES ('mpg','video/mpeg','movie','WMP'); INSERT INTO `cpg1410_2_filetypes` VALUES ('mpeg','video/mpeg','movie','WMP'); INSERT INTO `cpg1410_2_filetypes` VALUES ('wmv','video/x-ms-wmv','movie','WMP'); INSERT INTO `cpg1410_2_filetypes` VALUES ('swf','application/x-shockwave-flash','movie','SWF'); INSERT INTO `cpg1410_2_filetypes` VALUES ('avi','video/avi','movie','WMP'); INSERT INTO `cpg1410_2_filetypes` VALUES ('mov','video/quicktime','movie','QT'); INSERT INTO `cpg1410_2_filetypes` VALUES ('mp3','audio/mpeg3','audio','WMP'); INSERT INTO `cpg1410_2_filetypes` VALUES ('midi','audio/midi','audio','WMP'); INSERT INTO `cpg1410_2_filetypes` VALUES ('mid','audio/midi','audio','WMP'); INSERT INTO `cpg1410_2_filetypes` VALUES ('wma','audio/x-ms-wma','audio','WMP'); INSERT INTO `cpg1410_2_filetypes` VALUES ('wav','audio/wav','audio','WMP'); INSERT INTO `cpg1410_2_filetypes` VALUES ('ogg','audio/ogg','audio',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('psd','image/psd','image',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('ram','audio/x-pn-realaudio','document','RMP'); INSERT INTO `cpg1410_2_filetypes` VALUES ('ra','audio/x-realaudio','document','RMP'); INSERT INTO `cpg1410_2_filetypes` VALUES ('rm','audio/x-realmedia','document','RMP'); INSERT INTO `cpg1410_2_filetypes` VALUES ('tiff','image/tiff','document',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('tif','image/tif','document',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('doc','application/msword','document',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('txt','text/plain','document',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('rtf','text/richtext','document',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('pdf','application/pdf','document',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('xls','application/excel','document',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('pps','application/powerpoint','document',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('ppt','application/powerpoint','document',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('zip','application/zip','document',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('rar','application/rar','document',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('gz','application/gz','document',''); INSERT INTO `cpg1410_2_filetypes` VALUES ('mdb','application/msaccess','document',''); -- -- Table structure for table 'cpg1410_2_hit_stats' -- CREATE TABLE `cpg1410_2_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=latin1 COMMENT='Detailed stats about hits, only used when enabled'; -- -- Dumping data for table 'cpg1410_2_hit_stats' -- -- -- Table structure for table 'cpg1410_2_pictures' -- CREATE TABLE `cpg1410_2_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 `owner_id` (`owner_id`), KEY `pic_hits` (`hits`), KEY `pic_rate` (`pic_rating`), KEY `aid_approved` (`aid`,`approved`), KEY `pic_aid` (`aid`), FULLTEXT KEY `search` (`title`,`caption`,`keywords`,`filename`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COMMENT='Used to store data about individual pics'; -- -- Dumping data for table 'cpg1410_2_pictures' -- INSERT INTO `cpg1410_2_pictures` VALUES (1,1,'uploads/','_MG_9599.jpg',32983,61420,450,300,1,'2007-01-30 21:41:17',1170211052,1,'admin',0,0,'','','','YES',0,'','','','',0,'','','24.66.94.140',0); INSERT INTO `cpg1410_2_pictures` VALUES (2,1,'uploads/','_MG_9596.jpg',26091,49084,300,450,1,'2007-01-30 21:41:05',1170211052,1,'admin',0,0,'','','','YES',0,'','','','',0,'','','24.66.94.140',0); INSERT INTO `cpg1410_2_pictures` VALUES (3,1,'uploads/','_MG_9586.jpg',26461,49507,300,450,1,'2007-01-30 21:40:41',1170211052,1,'admin',0,0,'','','','YES',0,'','','','',0,'','','24.66.94.140',0); INSERT INTO `cpg1410_2_pictures` VALUES (4,1,'uploads/','_MG_9607.jpg',33991,63479,450,300,0,'0000-00-00 00:00:00',1170211053,1,'admin',0,0,'','','','YES',0,'','','','',0,'','',NULL,0); INSERT INTO `cpg1410_2_pictures` VALUES (5,1,'uploads/','_MG_9608.jpg',33312,62074,450,300,0,'0000-00-00 00:00:00',1170211053,1,'admin',0,0,'','','','YES',0,'','','','',0,'','',NULL,0); INSERT INTO `cpg1410_2_pictures` VALUES (6,1,'uploads/','_MG_9611.jpg',33298,62698,450,300,0,'0000-00-00 00:00:00',1170211053,1,'admin',0,0,'','','','YES',0,'','','','',0,'','',NULL,0); INSERT INTO `cpg1410_2_pictures` VALUES (7,1,'uploads/','_MG_9612.jpg',31449,59882,450,300,0,'0000-00-00 00:00:00',1170211054,1,'admin',0,0,'','','','YES',0,'','','','',0,'','',NULL,0); INSERT INTO `cpg1410_2_pictures` VALUES (8,1,'uploads/','_MG_9615.jpg',36710,67788,450,300,0,'0000-00-00 00:00:00',1170211055,1,'admin',0,0,'','','','YES',0,'','','','',0,'','',NULL,0); INSERT INTO `cpg1410_2_pictures` VALUES (9,1,'uploads/','_MG_9621.jpg',23727,43449,300,450,0,'0000-00-00 00:00:00',1170211055,1,'admin',0,0,'','','','YES',0,'','','','',0,'','',NULL,0); INSERT INTO `cpg1410_2_pictures` VALUES (10,1,'uploads/','_MG_9595.jpg',27389,50835,450,300,1,'2007-01-30 21:40:55',1170211059,1,'admin',0,0,'','','','YES',0,'','','','',0,'','','24.66.94.140',0); -- -- Table structure for table 'cpg1410_2_plugins' -- CREATE TABLE `cpg1410_2_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 AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Stores the plugins'; -- -- Dumping data for table 'cpg1410_2_plugins' -- INSERT INTO `cpg1410_2_plugins` VALUES (1,'Photo Shop','photo_shop',0); -- -- Table structure for table 'cpg1410_2_sessions' -- CREATE TABLE `cpg1410_2_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=latin1 COMMENT='Used to store sessions'; -- -- Dumping data for table 'cpg1410_2_sessions' -- INSERT INTO `cpg1410_2_sessions` VALUES ('d8a141333799e40ea5d52879d2588c1f',0,1170211329,0); -- -- Table structure for table 'cpg1410_2_shop' -- CREATE TABLE `cpg1410_2_shop` ( `id` int(11) NOT NULL auto_increment, `oid` int(11) NOT NULL default '0', `uid` int(11) NOT NULL default '0', `pid` int(11) NOT NULL default '0', `cd` tinyint(2) NOT NULL default '0', `quantity` int(11) NOT NULL default '0', `size` varchar(40) NOT NULL default '0', `price` decimal(9,2) NOT NULL default '0.00', `otime` int(11) NOT NULL default '0', `status` tinyint(2) NOT NULL default '0', `aktive` tinyint(2) NOT NULL default '0', PRIMARY KEY (`id`,`oid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table 'cpg1410_2_shop' -- -- -- Table structure for table 'cpg1410_2_shop_config' -- CREATE TABLE `cpg1410_2_shop_config` ( `id` int(11) NOT NULL auto_increment, `type` varchar(40) NOT NULL default '0', `name` varchar(40) NOT NULL default '0', `price` decimal(9,2) NOT NULL default '0.00', `max_items` varchar(40) NOT NULL default '0', `priority` int(5) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; -- -- Dumping data for table 'cpg1410_2_shop_config' -- INSERT INTO `cpg1410_2_shop_config` VALUES (1,'photo','4x6','2.00','0',0); INSERT INTO `cpg1410_2_shop_config` VALUES (2,'photo','5x7','3.00','0',1); INSERT INTO `cpg1410_2_shop_config` VALUES (3,'photo','8x10','4.00','0',2); INSERT INTO `cpg1410_2_shop_config` VALUES (4,'cd','25 pictures cd','25.00','25',3); INSERT INTO `cpg1410_2_shop_config` VALUES (5,'cd','50 pictures cd','40.00','50',4); INSERT INTO `cpg1410_2_shop_config` VALUES (6,'cd','100 pictures cd','70.00','100',5); -- -- Table structure for table 'cpg1410_2_shop_prices' -- CREATE TABLE `cpg1410_2_shop_prices` ( `id` int(11) NOT NULL auto_increment, `aid` int(11) NOT NULL default '0', `gid` int(11) NOT NULL default '0', `price` decimal(9,2) NOT NULL default '0.00', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table 'cpg1410_2_shop_prices' -- -- -- Table structure for table 'cpg1410_2_temp_data' -- CREATE TABLE `cpg1410_2_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=latin1 COMMENT='Holds temporary file data for multiple file uploads'; -- -- Dumping data for table 'cpg1410_2_temp_data' -- -- -- Table structure for table 'cpg1410_2_usergroups' -- CREATE TABLE `cpg1410_2_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=latin1 COMMENT='Used to store user groups'; -- -- Dumping data for table 'cpg1410_2_usergroups' -- INSERT INTO `cpg1410_2_usergroups` VALUES (1,'Administrators',0,1,1,1,1,1,1,0,0,3,0,5,3); INSERT INTO `cpg1410_2_usergroups` VALUES (2,'Registered',1024,0,1,1,1,1,1,1,0,3,0,5,3); INSERT INTO `cpg1410_2_usergroups` VALUES (3,'Anonymous',0,0,1,0,0,0,0,1,1,0,0,5,3); INSERT INTO `cpg1410_2_usergroups` VALUES (4,'Banned',0,0,0,0,0,0,0,1,1,0,0,5,3); -- -- Table structure for table 'cpg1410_2_users' -- CREATE TABLE `cpg1410_2_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=latin1 COMMENT='Used to store users, not used when bridged'; -- -- Dumping data for table 'cpg1410_2_users' -- INSERT INTO `cpg1410_2_users` VALUES (1,1,'YES','admin','a7aaffc5edf466a64895e037d5e1b501','2007-01-30 21:33:44','2007-01-30 21:33:36','','chris@shayphoto.ca','','','','','','',''); -- -- Table structure for table 'cpg1410_2_vote_stats' -- CREATE TABLE `cpg1410_2_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=latin1 COMMENT='Detailed stats about votes, only used when enabled'; -- -- Dumping data for table 'cpg1410_2_vote_stats' -- -- -- Table structure for table 'cpg1410_2_votes' -- CREATE TABLE `cpg1410_2_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=latin1 COMMENT='Stores votes for individual pics'; -- -- Dumping data for table 'cpg1410_2_votes' --