Subversion Repositories svnkaklik

Compare Revisions

Ignore whitespace Rev 5 → Rev 6

/web/test/gallery/cpg133/sql/_vti_cnf/basic.sql
0,0 → 1,6
vti_encoding:SR|utf8-nl
vti_timelastmodified:TR|19 Apr 2005 03:17:12 -0000
vti_extenderversion:SR|6.0.2.5516
vti_cacheddtm:TX|19 Apr 2005 03:17:12 -0000
vti_filesize:IR|10008
vti_backlinkinfo:VX|
/web/test/gallery/cpg133/sql/_vti_cnf/schema.sql
0,0 → 1,6
vti_encoding:SR|utf8-nl
vti_timelastmodified:TR|19 Apr 2005 03:17:12 -0000
vti_extenderversion:SR|6.0.2.5516
vti_cacheddtm:TX|19 Apr 2005 03:17:12 -0000
vti_filesize:IR|8525
vti_backlinkinfo:VX|
/web/test/gallery/cpg133/sql/_vti_cnf/update.sql
0,0 → 1,6
vti_encoding:SR|utf8-nl
vti_timelastmodified:TR|19 Apr 2005 03:17:12 -0000
vti_extenderversion:SR|6.0.2.5516
vti_cacheddtm:TX|19 Apr 2005 03:17:12 -0000
vti_filesize:IR|9438
vti_backlinkinfo:VX|
/web/test/gallery/cpg133/sql/basic.sql
0,0 → 1,189
#*************************
# Coppermine Photo Gallery
# ************************
# Copyright (c) 2003-2005 Coppermine Dev Team
# v1.1 originaly written by Gregory DEMAR
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
# ********************************************
# Coppermine version: 1.3.3
# $Source: /cvsroot/coppermine/stable/sql/basic.sql,v $
# $Revision: 1.8 $
# $Author: gaugau $
# $Date: 2005/04/19 03:17:11 $
#**********************************************
 
#
# Dumping data for table `CPG_config`
#
 
INSERT INTO CPG_config VALUES ('albums_per_page', '12');
INSERT INTO CPG_config VALUES ('album_list_cols', '2');
INSERT INTO CPG_config VALUES ('display_pic_info', '0');
INSERT INTO CPG_config VALUES ('alb_list_thumb_size', '50');
 
#INSERT INTO CPG_config VALUES ('allowed_file_extensions', 'GIF/PNG/JPG/JPEG/TIF/TIFF');
 
 
# FOR USE WITH VIDEO MOD
INSERT INTO CPG_config VALUES ('allowed_mov_types', 'ALL');
INSERT INTO CPG_config VALUES ('allowed_doc_types', 'ALL');
INSERT INTO CPG_config VALUES ('allowed_snd_types', 'ALL');
INSERT INTO CPG_config VALUES ('allowed_img_types', 'ALL');
 
 
INSERT INTO CPG_config VALUES ('allow_private_albums', '1');
INSERT INTO CPG_config VALUES ('allow_user_registration', '0');
INSERT INTO CPG_config VALUES ('allow_duplicate_emails_addr', '0');
INSERT INTO CPG_config VALUES ('caption_in_thumbview', '1');
INSERT INTO CPG_config VALUES ('views_in_thumbview', '1');
INSERT INTO CPG_config VALUES ('charset', 'language file');
INSERT INTO CPG_config VALUES ('cookie_name', 'cpg133');
INSERT INTO CPG_config VALUES ('cookie_path', '/');
INSERT INTO CPG_config VALUES ('debug_mode', '0');
INSERT INTO CPG_config VALUES ('debug_notice', '0');
INSERT INTO CPG_config VALUES ('default_dir_mode', '0755');
INSERT INTO CPG_config VALUES ('default_file_mode', '0644');
INSERT INTO CPG_config VALUES ('default_sort_order', 'na');
INSERT INTO CPG_config VALUES ('ecards_more_pic_target', 'http://coppermine.sourceforge.net/');
INSERT INTO CPG_config VALUES ('enable_smilies', '1');
INSERT INTO CPG_config VALUES ('filter_bad_words', '0');
INSERT INTO CPG_config VALUES ('forbiden_fname_char', '$/\\\\:*?"\'<>|`');
INSERT INTO CPG_config VALUES ('fullpath', 'albums/');
INSERT INTO CPG_config VALUES ('gallery_admin_email', 'you@somewhere.com');
INSERT INTO CPG_config VALUES ('gallery_description', 'Your online photo album');
INSERT INTO CPG_config VALUES ('gallery_name', 'Coppermine Photo Gallery');
INSERT INTO CPG_config VALUES ('im_options', '-antialias');
INSERT INTO CPG_config VALUES ('impath', '');
INSERT INTO CPG_config VALUES ('jpeg_qual', '80');
INSERT INTO CPG_config VALUES ('keep_votes_time', '30');
INSERT INTO CPG_config VALUES ('lang', 'english');
INSERT INTO CPG_config VALUES ('main_page_layout', 'breadcrumb/catlist/alblist/random,2/lastup,2');
INSERT INTO CPG_config VALUES ('main_table_width', '100%');
INSERT INTO CPG_config VALUES ('make_intermediate', '1');
INSERT INTO CPG_config VALUES ('max_com_lines', '10');
INSERT INTO CPG_config VALUES ('max_com_size', '512');
INSERT INTO CPG_config VALUES ('max_com_wlength', '38');
INSERT INTO CPG_config VALUES ('max_img_desc_length', '512');
INSERT INTO CPG_config VALUES ('max_tabs', '12');
INSERT INTO CPG_config VALUES ('max_upl_size', '1024');
INSERT INTO CPG_config VALUES ('max_upl_width_height', '2048');
INSERT INTO CPG_config VALUES ('min_votes_for_rating', '1');
INSERT INTO CPG_config VALUES ('normal_pfx', 'normal_');
INSERT INTO CPG_config VALUES ('offline', '0');
INSERT INTO CPG_config VALUES ('picture_table_width', '600');
INSERT INTO CPG_config VALUES ('picture_width', '400');
INSERT INTO CPG_config VALUES ('randpos_interval', '1063623637');
INSERT INTO CPG_config VALUES ('read_exif_data', '0');
INSERT INTO CPG_config VALUES ('reg_requires_valid_email', '1');
INSERT INTO CPG_config VALUES ('subcat_level', '2');
INSERT INTO CPG_config VALUES ('theme', 'classic');
INSERT INTO CPG_config VALUES ('thumbcols', '4');
INSERT INTO CPG_config VALUES ('thumbrows', '3');
INSERT INTO CPG_config VALUES ('thumb_method', 'im');
INSERT INTO CPG_config VALUES ('thumb_pfx', 'thumb_');
INSERT INTO CPG_config VALUES ('thumb_width', '100');
INSERT INTO CPG_config VALUES ('userpics', 'userpics/');
INSERT INTO CPG_config VALUES ('user_field1_name', '');
INSERT INTO CPG_config VALUES ('user_field2_name', '');
INSERT INTO CPG_config VALUES ('user_field3_name', '');
INSERT INTO CPG_config VALUES ('user_field4_name', '');
INSERT INTO CPG_config VALUES ('display_comment_count', '0');
INSERT INTO CPG_config VALUES ('show_private', '0');
INSERT INTO CPG_config VALUES ('first_level', '1');
INSERT INTO CPG_config VALUES ('display_film_strip', '1');
INSERT INTO CPG_config VALUES ('max_film_strip_items', '5');
INSERT INTO CPG_config VALUES ('thumb_use', 'any');
INSERT INTO CPG_config VALUES ('comment_email_notification', '0');
#INSERT INTO CPG_config VALUES ('disable_popup_rightclick', '0');
#INSERT INTO CPG_config VALUES ('disable_gallery_rightclick', '0');
INSERT INTO CPG_config VALUES ('read_iptc_data', '0');
INSERT INTO CPG_config VALUES ('reg_notify_admin_email', '0');
INSERT INTO CPG_config VALUES ('disable_comment_flood_protect', '0');
INSERT INTO CPG_config VALUES ('upl_notify_admin_email', '0');
INSERT INTO CPG_config VALUES ('display_uploader', '0');
 
INSERT INTO CPG_config VALUES ('language_list', '0');
INSERT INTO CPG_config VALUES ('language_flags', '0');
INSERT INTO CPG_config VALUES ('theme_list', '0');
INSERT INTO CPG_config VALUES ('language_reset', '1');
INSERT INTO CPG_config VALUES ('theme_reset', '1');
 
INSERT INTO CPG_config VALUES ('allow_memberlist', '0');
INSERT INTO CPG_config VALUES ('display_faq', '0');
INSERT INTO CPG_config VALUES ('show_bbcode_help', '1');
INSERT INTO CPG_config VALUES ('log_ecards', '0');
INSERT INTO CPG_config VALUES ('email_comment_notification', '0');
INSERT INTO CPG_config VALUES ('enable_zipdownload', '1');
INSERT INTO CPG_config VALUES ('slideshow_interval', '5000');
 
 
#
# Dumping data for table `CPG_filetypes`
#
 
INSERT INTO CPG_filetypes VALUES ('jpg', 'image/jpg', 'image');
INSERT INTO CPG_filetypes VALUES ('jpeg', 'image/jpeg', 'image');
INSERT INTO CPG_filetypes VALUES ('jpe', 'image/jpe', 'image');
INSERT INTO CPG_filetypes VALUES ('gif', 'image/gif', 'image');
INSERT INTO CPG_filetypes VALUES ('png', 'image/png', 'image');
INSERT INTO CPG_filetypes VALUES ('bmp', 'image/bmp', 'image');
INSERT INTO CPG_filetypes VALUES ('jpc', 'image/jpc', 'image');
INSERT INTO CPG_filetypes VALUES ('jp2', 'image/jp2', 'image');
INSERT INTO CPG_filetypes VALUES ('jpx', 'image/jpx', 'image');
INSERT INTO CPG_filetypes VALUES ('jb2', 'image/jb2', 'image');
INSERT INTO CPG_filetypes VALUES ('swc', 'image/swc', 'image');
INSERT INTO CPG_filetypes VALUES ('iff', 'image/iff', 'image');
 
INSERT INTO CPG_filetypes VALUES ('asf', 'video/x-ms-asf', 'movie');
INSERT INTO CPG_filetypes VALUES ('asx', 'video/x-ms-asx', 'movie');
INSERT INTO CPG_filetypes VALUES ('mpg', 'video/mpeg', 'movie');
INSERT INTO CPG_filetypes VALUES ('mpeg', 'video/mpeg', 'movie');
INSERT INTO CPG_filetypes VALUES ('wmv', 'video/x-ms-wmv', 'movie');
INSERT INTO CPG_filetypes VALUES ('swf', 'application/x-shockwave-flash', 'movie');
INSERT INTO CPG_filetypes VALUES ('avi', 'video/avi', 'movie');
INSERT INTO CPG_filetypes VALUES ('mov', 'video/quicktime', 'movie');
 
INSERT INTO CPG_filetypes VALUES ('mp3', 'audio/mpeg3', 'audio');
INSERT INTO CPG_filetypes VALUES ('midi', 'audio/midi', 'audio');
INSERT INTO CPG_filetypes VALUES ('mid', 'audio/midi', 'audio');
INSERT INTO CPG_filetypes VALUES ('wma', 'audio/x-ms-wma', 'audio');
INSERT INTO CPG_filetypes VALUES ('wav', 'audio/wav', 'audio');
INSERT INTO CPG_filetypes VALUES ('ogg', 'audio/ogg', 'audio');
 
INSERT INTO CPG_filetypes VALUES ('psd', 'image/psd', 'image');
INSERT INTO CPG_filetypes VALUES ('ram', 'audio/x-pn-realaudio', 'document');
INSERT INTO CPG_filetypes VALUES ('ra', 'audio/x-realaudio', 'document');
INSERT INTO CPG_filetypes VALUES ('rm', 'audio/x-realmedia', 'document');
INSERT INTO CPG_filetypes VALUES ('tiff', 'image/tiff', 'document');
INSERT INTO CPG_filetypes VALUES ('tif', 'image/tif', 'document');
INSERT INTO CPG_filetypes VALUES ('doc', 'application/msword', 'document');
INSERT INTO CPG_filetypes VALUES ('txt', 'text/plain', 'document');
INSERT INTO CPG_filetypes VALUES ('rtf', 'text/richtext', 'document');
INSERT INTO CPG_filetypes VALUES ('pdf', 'application/pdf', 'document');
INSERT INTO CPG_filetypes VALUES ('xls', 'application/excel', 'document');
INSERT INTO CPG_filetypes VALUES ('pps', 'application/powerpoint', 'document');
INSERT INTO CPG_filetypes VALUES ('ppt', 'application/powerpoint', 'document');
INSERT INTO CPG_filetypes VALUES ('zip', 'application/zip', 'document');
INSERT INTO CPG_filetypes VALUES ('rar', 'application/rar', 'document');
INSERT INTO CPG_filetypes VALUES ('gz', 'application/gz', 'document');
INSERT INTO CPG_filetypes VALUES ('mdb', 'application/msaccess', 'document');
 
 
#
# Dumping data for table `CPG_usergroups`
#
 
INSERT INTO CPG_usergroups VALUES (1, 'Administrators', 0, 1, 1, 1, 1, 1, 1, 0, 0, 3, 0, 5, 3);
INSERT INTO CPG_usergroups VALUES (2, 'Registered', 1024, 0, 1, 1, 1, 1, 1, 1, 0, 3, 0, 5, 3);
INSERT INTO CPG_usergroups VALUES (3, 'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3);
INSERT INTO CPG_usergroups VALUES (4, 'Banned', 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3);
 
#
# Dumping data for table `CPG_categories`
#
 
INSERT INTO CPG_categories VALUES (1, 0, 'User galleries', 'This category contains albums that belong to Coppermine users.', 0, 0, 0, 0, 0, 0, 'NO');
/web/test/gallery/cpg133/sql/schema.sql
0,0 → 1,262
#*************************
# Coppermine Photo Gallery
# ************************
# Copyright (c) 2003-2005 Coppermine Dev Team
# v1.1 originaly written by Gregory DEMAR
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
# ********************************************
# Coppermine version: 1.3.3
# $Source: /cvsroot/coppermine/stable/sql/schema.sql,v $
# $Revision: 1.4 $
# $Author: gaugau $
# $Date: 2005/04/19 03:17:12 $
#**********************************************
 
#
# Table structure for table `CPG_albums`
#
 
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',
pic_count int(11) NOT NULL default '0',
thumb int(11) NOT NULL default '0',
last_addition datetime NOT NULL default '0000-00-00 00:00:00',
stat_uptodate enum('YES','NO') NOT NULL default 'NO',
keyword VARCHAR( 50 ),
PRIMARY KEY (aid),
KEY alb_category (category)
) TYPE=MyISAM;
# --------------------------------------------------------
 
#
# Table structure for table `CPG_categories`
#
 
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',
subcat_count int(11) NOT NULL default '0',
alb_count int(11) NOT NULL default '0',
pic_count int(11) NOT NULL default '0',
stat_uptodate enum('YES','NO') NOT NULL default 'NO',
PRIMARY KEY (cid),
KEY cat_parent (parent),
KEY cat_pos (pos),
KEY cat_owner_id (owner_id)
) TYPE=MyISAM;
# --------------------------------------------------------
 
#
# Table structure for table `CPG_comments`
#
 
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)
) TYPE=MyISAM;
# --------------------------------------------------------
 
#
# Table structure for table `CPG_config`
#
 
CREATE TABLE CPG_config (
name varchar(40) NOT NULL default '',
value varchar(255) NOT NULL default '',
PRIMARY KEY (name)
) TYPE=MyISAM;
# --------------------------------------------------------
 
#
# Table structure for table `CPG_pictures`
#
 
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 timestamp(14) NOT NULL,
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',
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',
randpos int(11) NOT NULL default '0',
pic_raw_ip tinytext,
pic_hdr_ip tinytext,
PRIMARY KEY (pid),
KEY owner_id (owner_id),
KEY pic_hits (hits),
KEY pic_rate (pic_rating),
KEY aid_approved (aid,approved),
KEY randpos (randpos),
KEY pic_aid (aid),
FULLTEXT KEY search (title,caption,keywords,filename)
) TYPE=MyISAM;
# --------------------------------------------------------
 
#
# Table structure for table `CPG_usergroups`
#
 
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)
) TYPE=MyISAM;
# --------------------------------------------------------
 
#
# Table structure for table `CPG_users`
#
 
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(25) 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_website varchar(255) NOT NULL default '',
user_location varchar(255) NOT NULL default '',
user_interests varchar(255) NOT NULL default '',
user_occupation varchar(255) NOT NULL default '',
user_actkey varchar(32) NOT NULL default '',
PRIMARY KEY (user_id),
UNIQUE KEY user_name (user_name)
) TYPE=MyISAM;
# --------------------------------------------------------
 
#
# Table structure for table `CPG_votes`
#
 
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)
) TYPE=MyISAM;
#---------------------------------------------------------
 
#
# Table structure for table `CPG_banned`
#
 
CREATE TABLE CPG_banned (
ban_id int(11) NOT NULL auto_increment,
user_id int(11) DEFAULT NULL,
ip_addr tinytext DEFAULT NULL,
expiry datetime DEFAULT NULL,
PRIMARY KEY (ban_id)
) TYPE=MyISAM;
#---------------------------------------------------------
 
#
# Table structure for table `CPG_exif`
#
 
CREATE TABLE CPG_exif (
`filename` varchar(255) NOT NULL default '',
`exifData` text NOT NULL,
UNIQUE KEY `filename` (`filename`)
) TYPE=MyISAM;
# --------------------------------------------------------
 
#
# Table structure for table `CPG_filetypes`
#
 
CREATE TABLE IF NOT EXISTS CPG_filetypes (
extension char(7) NOT NULL default '',
mime char(30) default NULL,
content char(15) default NULL,
PRIMARY KEY (extension)
) TYPE=MyISAM COMMENT='Used to store the file extensions';
 
 
#
# Table structure for table `CPG_ecards`
#
 
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)
) TYPE=MyISAM COMMENT='Used to log ecards';
 
 
 
#
# Table structure for table `CPG_temp_data`
#
 
CREATE TABLE IF NOT EXISTS `CPG_temp_data` (
`unique_ID` CHAR( 8 ) NOT NULL ,
`encoded_string` BLOB NOT NULL ,
`timestamp` INT( 11 ) UNSIGNED NOT NULL ,
PRIMARY KEY ( `unique_ID` )
) TYPE = MYISAM COMMENT = 'Holds temporary file data for multiple file uploads';
/web/test/gallery/cpg133/sql/update.sql
0,0 → 1,228
#*************************
# Coppermine Photo Gallery
# ************************
# Copyright (c) 2003-2005 Coppermine Dev Team
# v1.1 originaly written by Gregory DEMAR
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
# ********************************************
# Coppermine version: 1.3.3
# $Source: /cvsroot/coppermine/stable/sql/update.sql,v $
# $Revision: 1.14 $
# $Author: gaugau $
# $Date: 2005/04/19 03:17:12 $
#**********************************************
 
#
# Table structure for table `CPG_filetypes`
#
 
CREATE TABLE IF NOT EXISTS CPG_filetypes (
extension char(7) NOT NULL default '',
mime char(30) default NULL,
content char(15) default NULL,
KEY extension (extension)
) TYPE=MyISAM COMMENT='Used to store the file extensions';
 
ALTER TABLE `CPG_filetypes` DROP INDEX `EXTENSION`, ADD PRIMARY KEY ( `extension` );
 
INSERT INTO CPG_filetypes VALUES ('jpg', 'image/jpg', 'image');
INSERT INTO CPG_filetypes VALUES ('jpeg', 'image/jpeg', 'image');
INSERT INTO CPG_filetypes VALUES ('jpe', 'image/jpe', 'image');
INSERT INTO CPG_filetypes VALUES ('gif', 'image/gif', 'image');
INSERT INTO CPG_filetypes VALUES ('png', 'image/png', 'image');
INSERT INTO CPG_filetypes VALUES ('psd', 'image/psd', 'image');
INSERT INTO CPG_filetypes VALUES ('bmp', 'image/bmp', 'image');
INSERT INTO CPG_filetypes VALUES ('jpc', 'image/jpc', 'image');
INSERT INTO CPG_filetypes VALUES ('jp2', 'image/jp2', 'image');
INSERT INTO CPG_filetypes VALUES ('jpx', 'image/jpx', 'image');
INSERT INTO CPG_filetypes VALUES ('jb2', 'image/jb2', 'image');
INSERT INTO CPG_filetypes VALUES ('swc', 'image/swc', 'image');
INSERT INTO CPG_filetypes VALUES ('iff', 'image/iff', 'image');
UPDATE CPG_config SET value='ALL' WHERE name='allowed_img_types';
 
INSERT INTO CPG_filetypes VALUES ('asf', 'video/x-ms-asf', 'movie');
INSERT INTO CPG_filetypes VALUES ('asx', 'video/x-ms-asx', 'movie');
INSERT INTO CPG_filetypes VALUES ('mpg', 'video/mpeg', 'movie');
INSERT INTO CPG_filetypes VALUES ('mpeg', 'video/mpeg', 'movie');
INSERT INTO CPG_filetypes VALUES ('wmv', 'video/x-ms-wmv', 'movie');
INSERT INTO CPG_filetypes VALUES ('swf', 'application/x-shockwave-flash', 'movie');
INSERT INTO CPG_filetypes VALUES ('avi', 'video/avi', 'movie');
INSERT INTO CPG_filetypes VALUES ('mov', 'video/quicktime', 'movie');
INSERT INTO CPG_config VALUES ('allowed_mov_types', 'ALL');
 
INSERT INTO CPG_filetypes VALUES ('mp3', 'audio/mpeg3', 'audio');
INSERT INTO CPG_filetypes VALUES ('midi', 'audio/midi', 'audio');
INSERT INTO CPG_filetypes VALUES ('mid', 'audio/midi', 'audio');
INSERT INTO CPG_filetypes VALUES ('wma', 'audio/x-ms-wma', 'audio');
INSERT INTO CPG_filetypes VALUES ('wav', 'audio/wav', 'audio');
INSERT INTO CPG_filetypes VALUES ('ogg', 'audio/ogg', 'audio');
INSERT INTO CPG_config VALUES ('allowed_snd_types', 'ALL');
 
INSERT INTO CPG_filetypes VALUES ('ram', 'audio/x-pn-realaudio', 'document');
INSERT INTO CPG_filetypes VALUES ('ra', 'audio/x-realaudio', 'document');
INSERT INTO CPG_filetypes VALUES ('rm', 'audio/x-realmedia', 'document');
INSERT INTO CPG_filetypes VALUES ('tiff', 'image/tiff', 'document');
INSERT INTO CPG_filetypes VALUES ('tif', 'image/tif', 'document');
INSERT INTO CPG_filetypes VALUES ('doc', 'application/msword', 'document');
INSERT INTO CPG_filetypes VALUES ('txt', 'text/plain', 'document');
INSERT INTO CPG_filetypes VALUES ('rtf', 'text/richtext', 'document');
INSERT INTO CPG_filetypes VALUES ('pdf', 'application/pdf', 'document');
INSERT INTO CPG_filetypes VALUES ('xls', 'application/excel', 'document');
INSERT INTO CPG_filetypes VALUES ('pps', 'application/powerpoint', 'document');
INSERT INTO CPG_filetypes VALUES ('ppt', 'application/powerpoint', 'document');
INSERT INTO CPG_filetypes VALUES ('zip', 'application/zip', 'document');
INSERT INTO CPG_filetypes VALUES ('rar', 'application/rar', 'document');
INSERT INTO CPG_filetypes VALUES ('gz', 'application/gz', 'document');
INSERT INTO CPG_filetypes VALUES ('mdb', 'application/msaccess', 'document');
INSERT INTO CPG_config VALUES ('allowed_doc_types', 'ALL');
 
 
#
# Modify structure for table `CPG_comments`
#
 
ALTER TABLE CPG_comments add msg_raw_ip tinytext;
ALTER TABLE CPG_comments add msg_hdr_ip tinytext;
ALTER TABLE CPG_pictures add pic_raw_ip tinytext;
ALTER TABLE CPG_pictures add pic_hdr_ip tinytext;
 
 
INSERT INTO CPG_config VALUES ('thumb_use', 'any');
INSERT INTO CPG_config VALUES ('show_private', '0');
INSERT INTO CPG_config VALUES ('first_level', '1');
INSERT INTO CPG_config VALUES ('display_film_strip', '1');
INSERT INTO CPG_config VALUES ('max_film_strip_items', '5');
INSERT INTO CPG_config VALUES ('comment_email_notification', '0');
INSERT INTO CPG_config VALUES ('read_iptc_data', '0');
INSERT INTO CPG_config VALUES ('display_uploader', '0');
 
#gtroll wil implement
#INSERT INTO CPG_config VALUES ('picinfo_display_filename', '1');
#INSERT INTO CPG_config VALUES ('picinfo_display_album_name', '1');
#INSERT INTO CPG_config VALUES ('picinfo_display_file_size', '1');
#INSERT INTO CPG_config VALUES ('picinfo_display_dimensions', '1');
#INSERT INTO CPG_config VALUES ('picinfo_display_count_displayed', '1');
#INSERT INTO CPG_config VALUES ('picinfo_display_URL', '1');
#INSERT INTO CPG_config VALUES ('picinfo_display_URL_bookmark', '1');
#INSERT INTO CPG_config VALUES ('picinfo_display_favorites', 1');
 
INSERT INTO CPG_config VALUES ('reg_notify_admin_email', '0');
INSERT INTO CPG_config VALUES ('disable_comment_flood_protect', '0');
INSERT INTO CPG_config VALUES ('upl_notify_admin_email', '0');
 
INSERT INTO CPG_config VALUES ('language_list', '0');
INSERT INTO CPG_config VALUES ('language_flags', '0');
INSERT INTO CPG_config VALUES ('theme_list', '0');
INSERT INTO CPG_config VALUES ('language_reset', '1');
INSERT INTO CPG_config VALUES ('theme_reset', '1');
INSERT INTO CPG_config VALUES ('offline', '0');
 
INSERT INTO CPG_config VALUES ('allow_memberlist', '0');
INSERT INTO CPG_config VALUES ('display_faq', '0');
INSERT INTO CPG_config VALUES ('views_in_thumbview', '1');
INSERT INTO CPG_config VALUES ('show_bbcode_help', '1');
INSERT INTO CPG_config VALUES ('log_ecards', '0');
INSERT INTO CPG_config VALUES ('email_comment_notification', '0');
INSERT INTO CPG_config VALUES ('enable_zipdownload', '1');
INSERT INTO CPG_config VALUES ('debug_notice', '0');
INSERT INTO CPG_config VALUES ('slideshow_interval', '5000');
 
 
# Modify structure for category thumb
ALTER TABLE `CPG_categories` ADD `thumb` INT NOT NULL AFTER `parent` ;
 
# Modify structure for multi album pictures
ALTER TABLE `CPG_albums` ADD `keyword` VARCHAR( 50 ) NOT NULL ;
 
 
#
# Table structure for table `CPG_banned`
#
 
CREATE TABLE CPG_banned (
ban_id int(11) NOT NULL auto_increment,
user_id int(11) DEFAULT NULL,
ip_addr tinytext DEFAULT NULL,
expiry datetime DEFAULT NULL,
PRIMARY KEY (ban_id)
) TYPE=MyISAM;
 
#
# Table structure for table `CPG_exif`
#
CREATE TABLE CPG_exif (
`filename` varchar(255) NOT NULL default '',
`exifData` text NOT NULL,
UNIQUE KEY `filename` (`filename`)
) TYPE=MyISAM;
 
#
# Table structure for table `CPG_ecards`
#
 
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)
) TYPE=MyISAM COMMENT='Used to log ecards';
 
#
# Modify structure for table 'CPG_usergroups' - Upload form control - Hyperion
#
 
ALTER TABLE `CPG_usergroups` ADD `upload_form_config` TINYINT(4) DEFAULT '3' NOT NULL;
ALTER TABLE `CPG_usergroups` ADD `custom_user_upload` TINYINT(4) DEFAULT '0' NOT NULL;
ALTER TABLE `CPG_usergroups` ADD `num_file_upload` TINYINT(4) DEFAULT '5' NOT NULL;
ALTER TABLE `CPG_usergroups` ADD `num_URI_upload` TINYINT(4) DEFAULT '3' NOT NULL;
 
 
 
#
# Table structure for table `CPG_temp_data` - Temporary data for file uploads - Hyperion
#
 
CREATE TABLE IF NOT EXISTS `CPG_temp_data` (
`unique_ID` CHAR( 8 ) NOT NULL ,
`encoded_string` BLOB NOT NULL ,
`timestamp` INT( 11 ) UNSIGNED NOT NULL ,
PRIMARY KEY ( `unique_ID` )
) TYPE = MYISAM COMMENT = 'Holds temporary file data for multiple file uploads';
 
#
# Close security hole and re-point default theme in 1.3 - Jack
#
 
UPDATE `CPG_config` SET value='classic' WHERE (name='theme' AND value='default');
DELETE FROM `CPG_filetypes` WHERE mime='text/html';
 
#
# Finally remove all user_lang references - Jack
#
 
ALTER TABLE `CPG_users` CHANGE user_lang user_group_list varchar(255) NOT NULL default '';
 
#
# Fix usermgr timing out with 1k+ users -Omni
#
ALTER TABLE CPG_pictures DROP INDEX `owner_id`;
ALTER TABLE CPG_pictures DROP INDEX `owner_id_2`;
ALTER TABLE CPG_pictures DROP INDEX `owner_id_3`;
ALTER TABLE CPG_pictures DROP INDEX `owner_id_4`;
ALTER TABLE CPG_pictures ADD INDEX owner_id( `owner_id` );
 
 
#
# Record the last hit IP
#
 
ALTER TABLE `CPG_pictures` ADD `lasthit_ip` TINYTEXT ;