Performing Database Updates

CREATE TABLE IF NOT EXISTS cpg14x_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) ) TYPE=MyISAM COMMENT='Used to store sessions'OK
CREATE TABLE IF NOT EXISTS cpg14x_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'OK
ALTER TABLE `cpg14x_filetypes` DROP INDEX `EXTENSION`, ADD PRIMARY KEY ( `extension` )Already Done
ALTER TABLE `cpg14x_filetypes` ADD `player` VARCHAR( 5 ) Already Done
INSERT INTO cpg14x_filetypes VALUES ('jpg', 'image/jpg', 'image', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('jpeg', 'image/jpeg', 'image', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('jpe', 'image/jpe', 'image', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('gif', 'image/gif', 'image', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('png', 'image/png', 'image', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('psd', 'image/psd', 'image', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('bmp', 'image/bmp', 'image', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('jpc', 'image/jpc', 'image', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('jp2', 'image/jp2', 'image', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('jpx', 'image/jpx', 'image', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('jb2', 'image/jb2', 'image', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('swc', 'image/swc', 'image', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('iff', 'image/iff', 'image', '')Already Done
UPDATE cpg14x_config SET value='ALL' WHERE name='allowed_img_types'OK
INSERT INTO cpg14x_filetypes VALUES ('asf', 'video/x-ms-asf', 'movie', 'WMP')Already Done
INSERT INTO cpg14x_filetypes VALUES ('asx', 'video/x-ms-asx', 'movie', 'WMP')Already Done
INSERT INTO cpg14x_filetypes VALUES ('mpg', 'video/mpeg', 'movie', 'WMP')Already Done
INSERT INTO cpg14x_filetypes VALUES ('mpeg', 'video/mpeg', 'movie', 'WMP')Already Done
INSERT INTO cpg14x_filetypes VALUES ('wmv', 'video/x-ms-wmv', 'movie', 'WMP')Already Done
INSERT INTO cpg14x_filetypes VALUES ('swf', 'application/x-shockwave-flash', 'movie', 'SWF')Already Done
INSERT INTO cpg14x_filetypes VALUES ('avi', 'video/avi', 'movie', 'WMP')Already Done
INSERT INTO cpg14x_filetypes VALUES ('mov', 'video/quicktime', 'movie', 'QT')Already Done
INSERT INTO cpg14x_config VALUES ('allowed_mov_types', 'ALL')Already Done
INSERT INTO cpg14x_filetypes VALUES ('mp3', 'audio/mpeg3', 'audio', 'WMP')Already Done
INSERT INTO cpg14x_filetypes VALUES ('midi', 'audio/midi', 'audio', 'WMP')Already Done
INSERT INTO cpg14x_filetypes VALUES ('mid', 'audio/midi', 'audio', 'WMP')Already Done
INSERT INTO cpg14x_filetypes VALUES ('wma', 'audio/x-ms-wma', 'audio', 'WMP')Already Done
INSERT INTO cpg14x_filetypes VALUES ('wav', 'audio/wav', 'audio', 'WMP')Already Done
INSERT INTO cpg14x_filetypes VALUES ('ogg', 'audio/ogg', 'audio', '')Already Done
INSERT INTO cpg14x_config VALUES ('allowed_snd_types', 'ALL')Already Done
INSERT INTO cpg14x_filetypes VALUES ('ram', 'audio/x-pn-realaudio', 'document', 'RMP')Already Done
INSERT INTO cpg14x_filetypes VALUES ('ra', 'audio/x-realaudio', 'document', 'RMP')Already Done
INSERT INTO cpg14x_filetypes VALUES ('rm', 'audio/x-realmedia', 'document', 'RMP')Already Done
INSERT INTO cpg14x_filetypes VALUES ('tiff', 'image/tiff', 'document', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('tif', 'image/tif', 'document', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('doc', 'application/msword', 'document', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('txt', 'text/plain', 'document', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('rtf', 'text/richtext', 'document', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('pdf', 'application/pdf', 'document', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('xls', 'application/excel', 'document', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('pps', 'application/powerpoint', 'document', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('ppt', 'application/powerpoint', 'document', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('zip', 'application/zip', 'document', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('rar', 'application/rar', 'document', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('gz', 'application/gz', 'document', '')Already Done
INSERT INTO cpg14x_filetypes VALUES ('mdb', 'application/msaccess', 'document', '')Already Done
INSERT INTO cpg14x_config VALUES ('allowed_doc_types', 'ALL')Already Done
UPDATE cpg14x_filetypes SET player='WMP' WHERE extension IN ('asf','asx','mpg','mpeg','wmv','avi','mp3','midi','mid','wma','wav')OK
UPDATE cpg14x_filetypes SET player='QT' WHERE extension IN ('mov')OK
UPDATE cpg14x_filetypes SET player='RMP' WHERE extension IN ('ra','ram','rm')OK
UPDATE cpg14x_filetypes SET player='SWF' WHERE extension IN ('swc','swf')OK
ALTER TABLE cpg14x_comments add msg_raw_ip tinytextAlready Done
ALTER TABLE cpg14x_comments add msg_hdr_ip tinytextAlready Done
ALTER TABLE cpg14x_pictures add pic_raw_ip tinytextAlready Done
ALTER TABLE cpg14x_pictures add pic_hdr_ip tinytextAlready Done
INSERT INTO cpg14x_config VALUES ('thumb_use', 'any')Already Done
INSERT INTO cpg14x_config VALUES ('show_private', '0')Already Done
INSERT INTO cpg14x_config VALUES ('first_level', '1')Already Done
INSERT INTO cpg14x_config VALUES ('display_film_strip', '1')Already Done
INSERT INTO cpg14x_config VALUES ('display_film_strip_filename', '0')Already Done
INSERT INTO cpg14x_config VALUES ('max_film_strip_items', '5')Already Done
INSERT INTO cpg14x_config VALUES ('read_iptc_data', '0')Already Done
INSERT INTO cpg14x_config VALUES ('display_uploader', '0')Already Done
INSERT INTO cpg14x_config VALUES ('display_filename','0')Already Done
INSERT INTO cpg14x_config VALUES ('reg_notify_admin_email', '0')Already Done
INSERT INTO cpg14x_config VALUES ('disable_comment_flood_protect', '0')Already Done
INSERT INTO cpg14x_config VALUES ('upl_notify_admin_email', '0')Already Done
INSERT INTO cpg14x_config VALUES ('language_list', '0')Already Done
INSERT INTO cpg14x_config VALUES ('language_flags', '0')Already Done
INSERT INTO cpg14x_config VALUES ('theme_list', '0')Already Done
INSERT INTO cpg14x_config VALUES ('language_reset', '1')Already Done
INSERT INTO cpg14x_config VALUES ('theme_reset', '1')Already Done
INSERT INTO cpg14x_config VALUES ('offline', '0')Already Done
INSERT INTO cpg14x_config VALUES ('vanity_block','1')Already Done
INSERT INTO cpg14x_config VALUES ('allow_memberlist', '0')Already Done
INSERT INTO cpg14x_config VALUES ('display_faq', '0')Already Done
INSERT INTO cpg14x_config VALUES ('views_in_thumbview', '1')Already Done
INSERT INTO cpg14x_config VALUES ('show_bbcode_help', '1')Already Done
INSERT INTO cpg14x_config VALUES ('log_ecards', '0')Already Done
INSERT INTO cpg14x_config VALUES ('email_comment_notification', '0')Already Done
INSERT INTO cpg14x_config VALUES ('enable_zipdownload', '1')Already Done
INSERT INTO cpg14x_config VALUES ('debug_notice', '0')Already Done
INSERT INTO cpg14x_config VALUES ('slideshow_interval', '5000')Already Done
INSERT INTO cpg14x_config VALUES ('log_mode', '0')Already Done
INSERT INTO cpg14x_config VALUES ('media_autostart', '1')Already Done
INSERT INTO cpg14x_config VALUES ('enable_encrypted_passwords','0')Already Done
ALTER TABLE `cpg14x_categories` ADD `thumb` INT NOT NULL AFTER `parent` Already Done
ALTER TABLE `cpg14x_albums` ADD `keyword` VARCHAR( 50 ) NOT NULL Already Done
CREATE TABLE cpg14x_banned ( ban_id int(11) NOT NULL auto_increment, user_id int(11) DEFAULT NULL, ip_addr tinytext, expiry datetime DEFAULT NULL, PRIMARY KEY (ban_id) ) TYPE=MyISAMAlready Done
CREATE TABLE cpg14x_exif ( `filename` varchar(255) NOT NULL default '', `exifData` text NOT NULL, UNIQUE KEY `filename` (`filename`) ) TYPE=MyISAMAlready Done
CREATE TABLE cpg14x_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'Already Done
ALTER TABLE `cpg14x_usergroups` ADD `upload_form_config` TINYINT(4) DEFAULT '3' NOT NULLAlready Done
ALTER TABLE `cpg14x_usergroups` ADD `custom_user_upload` TINYINT(4) DEFAULT '0' NOT NULLAlready Done
ALTER TABLE `cpg14x_usergroups` ADD `num_file_upload` TINYINT(4) DEFAULT '5' NOT NULLAlready Done
ALTER TABLE `cpg14x_usergroups` ADD `num_URI_upload` TINYINT(4) DEFAULT '3' NOT NULLAlready Done
CREATE TABLE IF NOT EXISTS `cpg14x_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'OK
UPDATE `cpg14x_config` SET value='classic' WHERE (name='theme' AND value='default')OK
DELETE FROM `cpg14x_filetypes` WHERE mime='text/html'OK
UPDATE `cpg14x_config` SET value='$/\\\\:*?"\'<>|` &' WHERE name='forbiden_fname_char'OK
ALTER TABLE `cpg14x_users` CHANGE user_lang user_group_list varchar(255) NOT NULL default ''Already Done
ALTER TABLE cpg14x_pictures DROP INDEX `owner_id`OK
ALTER TABLE cpg14x_pictures DROP INDEX `owner_id_2`Already Done
ALTER TABLE cpg14x_pictures ADD INDEX owner_id( `owner_id` )OK
ALTER TABLE cpg14x_pictures ADD `galleryicon` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `approved`Already Done
ALTER TABLE `cpg14x_pictures` ADD `lasthit_ip` TINYTEXT Already Done
CREATE TABLE `cpg14x_favpics` ( `user_id` INT( 11 ) NOT NULL , `user_favpics` TEXT NOT NULL , PRIMARY KEY ( `user_id` ) ) COMMENT = 'Stores the server side favourites'Already Done
CREATE TABLE cpg14x_dict ( keyId bigint(20) NOT NULL auto_increment, keyword varchar(60) NOT NULL default '', PRIMARY KEY (keyId) ) TYPE=MyISAM COMMENT = 'Holds the keyword dictionary'Already Done
ALTER TABLE `cpg14x_users` CHANGE `user_location` `user_profile1` VARCHAR(255)Already Done
ALTER TABLE `cpg14x_users` CHANGE `user_interests` `user_profile2` VARCHAR(255)Already Done
ALTER TABLE `cpg14x_users` CHANGE `user_website` `user_profile3` VARCHAR(255)Already Done
ALTER TABLE `cpg14x_users` CHANGE `user_occupation` `user_profile4` VARCHAR(255)Already Done
ALTER TABLE `cpg14x_users` ADD `user_profile5` varchar(255) default '' NOT NULLAlready Done
ALTER TABLE `cpg14x_users` ADD `user_profile6` varchar(255) default '' NOT NULLAlready Done
ALTER TABLE `cpg14x_users` CHANGE `user_password` `user_password` VARCHAR( 40 ) NOT NULL default ''OK
INSERT INTO cpg14x_config VALUES ('user_profile1_name', 'Location')Already Done
INSERT INTO cpg14x_config VALUES ('user_profile2_name', 'Interests')Already Done
INSERT INTO cpg14x_config VALUES ('user_profile3_name', 'Website')Already Done
INSERT INTO cpg14x_config VALUES ('user_profile4_name', 'Occupation')Already Done
INSERT INTO cpg14x_config VALUES ('user_profile5_name', '')Already Done
INSERT INTO cpg14x_config VALUES ('user_profile6_name', 'Biography')Already Done
INSERT INTO cpg14x_config VALUES ('language_fallback', '0')Already Done
INSERT INTO cpg14x_config VALUES ('time_offset', '0')Already Done
ALTER TABLE `cpg14x_users` CHANGE `user_profile6` `user_profile6` TEXT NOT NULLOK
ALTER TABLE `cpg14x_albums` ADD `alb_password` varchar(32) default ''Already Done
INSERT INTO cpg14x_config VALUES ('ban_private_ip', '0')Already Done
INSERT INTO cpg14x_config VALUES ('smtp_host', '')Already Done
INSERT INTO cpg14x_config VALUES ('smtp_username', '')Already Done
INSERT INTO cpg14x_config VALUES ('smtp_password', '')Already Done
INSERT INTO cpg14x_config VALUES ('enable_plugins', '1')Already Done
CREATE TABLE cpg14x_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) ) TYPE=MyISAM COMMENT='Stores the plugins'Already Done
INSERT INTO cpg14x_config VALUES ('enable_help', '2')Already Done
INSERT INTO cpg14x_config VALUES ('allow_email_change', '0')Already Done
INSERT INTO cpg14x_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')Already Done
DELETE FROM cpg14x_config WHERE `name` = 'alb_desc_thumb'OK
ALTER TABLE `cpg14x_albums` ADD `alb_password_hint` TEXT Already Done
INSERT INTO cpg14x_config VALUES ('categories_alpha_sort', '0')Already Done
ALTER TABLE `cpg14x_banned` ADD `brute_force` TINYINT( 5 ) DEFAULT '0' NOT NULL Already Done
INSERT INTO cpg14x_config VALUES ('login_threshold', '5')Already Done
INSERT INTO cpg14x_config VALUES ('login_expiry', '10')Already Done
INSERT INTO cpg14x_config VALUES ('clickable_keyword_search', '1')Already Done
INSERT INTO cpg14x_config VALUES ('link_pic_count', '0')Already Done
ALTER TABLE cpg14x_pictures ADD position INT(11) DEFAULT '0' NOT NULLAlready Done
INSERT INTO cpg14x_config VALUES ('auto_resize', '0')Already Done
CREATE TABLE cpg14x_bridge ( name varchar(40) NOT NULL default '0', value varchar(255) NOT NULL default '', UNIQUE KEY name (name) ) TYPE=MyISAMAlready Done
INSERT INTO cpg14x_bridge VALUES ('short_name', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('license_number', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('db_database_name', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('db_hostname', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('db_username', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('db_password', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('full_forum_url', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('relative_path_of_forum_from_webroot', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('relative_path_to_config_file', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('logout_flag', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('use_post_based_groups', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('cookie_prefix', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('table_prefix', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('user_table', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('session_table', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('group_table', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('group_relation_table', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('group_mapping_table', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('use_standard_groups', '1')Already Done
INSERT INTO cpg14x_bridge VALUES ('validating_group', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('guest_group', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('member_group', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('admin_group', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('banned_group', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('global_moderators_group', '')Already Done
INSERT INTO cpg14x_bridge VALUES ('recovery_logon_failures', '0')Already Done
INSERT INTO cpg14x_bridge VALUES ('recovery_logon_timestamp', '')Already Done
INSERT INTO cpg14x_config VALUES ('bridge_enable', '0')Already Done
CREATE TABLE cpg14x_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`) )Already Done
INSERT INTO cpg14x_config VALUES ('vote_details', '0')Already Done
CREATE TABLE cpg14x_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`) )Already Done
INSERT INTO cpg14x_config VALUES ('hit_details', '0')Already Done
INSERT INTO cpg14x_config VALUES ('browse_batch_add', '1')Already Done
INSERT INTO cpg14x_config VALUES ('custom_header_path', '')Already Done
INSERT INTO cpg14x_config VALUES ('custom_footer_path', '')Already Done
INSERT INTO cpg14x_config VALUES ('comments_sort_descending', '0')Already Done
INSERT INTO cpg14x_config VALUES ('report_post', '0')Already Done
INSERT INTO cpg14x_config VALUES ('users_can_edit_pics', '0')Already Done
INSERT INTO cpg14x_config VALUES ('allow_unlogged_access', '1')Already Done
INSERT INTO cpg14x_config VALUES ('home_target', 'index.php')Already Done
DELETE FROM cpg14x_config WHERE `name` = 'comment_email_notification'OK
DELETE FROM cpg14x_config WHERE `name` = 'hide_admin_uploader'OK
INSERT INTO cpg14x_config VALUES ('custom_lnk_name', '')Already Done
INSERT INTO cpg14x_config VALUES ('custom_lnk_url', '')Already Done
INSERT INTO cpg14x_config VALUES ('comments_anon_pfx', 'Guest_')Already Done
DELETE FROM cpg14x_config WHERE `name` = 'admin_activate'OK
INSERT INTO cpg14x_config VALUES ('admin_activation', '0')Already Done
ALTER TABLE cpg14x_pictures CHANGE `mtime` `mtime` DATETIMEOK
DELETE FROM cpg14x_exifOK
DELETE FROM cpg14x_config WHERE `name` = 'randpos_interval'OK
ALTER TABLE cpg14x_pictures DROP INDEX `randpos`Already Done
ALTER TABLE cpg14x_pictures DROP `randpos`Already Done
ALTER TABLE `cpg14x_pictures` CHANGE `mtime` `mtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'OK
ALTER TABLE `cpg14x_albums` CHANGE `description` `description` TEXT NOT NULLOK

Upgrade completed

It's recommended to check your file versions if you just upgraded from an older version of coppermine.
If you didn't (or you don't want to check), you can go to your gallery's start page