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