| CREATE TABLE IF NOT EXISTS cpg_sessions ( session_id varchar(40) NOT NULL default '''', user_id int(11) default ''0'', time int(11) default NULL, remember int(1) default ''0'', PRIMARY KEY (session_id) ) TYPE=MyISAM COMMENT=''Used to store sessions'' | Already Done |
| 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'' | Already Done |
| ALTER TABLE `cpg_filetypes` DROP INDEX `EXTENSION`, ADD PRIMARY KEY ( `extension` ) | Already Done |
| ALTER TABLE `cpg_filetypes` ADD `player` VARCHAR( 5 ) | Already Done |
| INSERT INTO cpg_filetypes VALUES (''jpg'', ''image/jpg'', ''image'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''jpeg'', ''image/jpeg'', ''image'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''jpe'', ''image/jpe'', ''image'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''gif'', ''image/gif'', ''image'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''png'', ''image/png'', ''image'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''psd'', ''image/psd'', ''image'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''bmp'', ''image/bmp'', ''image'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''jpc'', ''image/jpc'', ''image'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''jp2'', ''image/jp2'', ''image'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''jpx'', ''image/jpx'', ''image'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''jb2'', ''image/jb2'', ''image'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''swc'', ''image/swc'', ''image'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''iff'', ''image/iff'', ''image'', '''') | Already Done |
| UPDATE cpg_config SET value=''ALL'' WHERE name=''allowed_img_types'' | Already Done |
| INSERT INTO cpg_filetypes VALUES (''asf'', ''video/x-ms-asf'', ''movie'', ''WMP'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''asx'', ''video/x-ms-asx'', ''movie'', ''WMP'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''mpg'', ''video/mpeg'', ''movie'', ''WMP'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''mpeg'', ''video/mpeg'', ''movie'', ''WMP'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''wmv'', ''video/x-ms-wmv'', ''movie'', ''WMP'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''swf'', ''application/x-shockwave-flash'', ''movie'', ''SWF'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''avi'', ''video/avi'', ''movie'', ''WMP'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''mov'', ''video/quicktime'', ''movie'', ''QT'') | Already Done |
| INSERT INTO cpg_config VALUES (''allowed_mov_types'', ''ALL'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''mp3'', ''audio/mpeg3'', ''audio'', ''WMP'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''midi'', ''audio/midi'', ''audio'', ''WMP'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''mid'', ''audio/midi'', ''audio'', ''WMP'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''wma'', ''audio/x-ms-wma'', ''audio'', ''WMP'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''wav'', ''audio/wav'', ''audio'', ''WMP'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''ogg'', ''audio/ogg'', ''audio'', '''') | Already Done |
| INSERT INTO cpg_config VALUES (''allowed_snd_types'', ''ALL'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''ram'', ''audio/x-pn-realaudio'', ''document'', ''RMP'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''ra'', ''audio/x-realaudio'', ''document'', ''RMP'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''rm'', ''audio/x-realmedia'', ''document'', ''RMP'') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''tiff'', ''image/tiff'', ''document'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''tif'', ''image/tif'', ''document'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''doc'', ''application/msword'', ''document'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''txt'', ''text/plain'', ''document'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''rtf'', ''text/richtext'', ''document'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''pdf'', ''application/pdf'', ''document'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''xls'', ''application/excel'', ''document'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''pps'', ''application/powerpoint'', ''document'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''ppt'', ''application/powerpoint'', ''document'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''zip'', ''application/zip'', ''document'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''rar'', ''application/rar'', ''document'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''gz'', ''application/gz'', ''document'', '''') | Already Done |
| INSERT INTO cpg_filetypes VALUES (''mdb'', ''application/msaccess'', ''document'', '''') | Already Done |
| INSERT INTO cpg_config VALUES (''allowed_doc_types'', ''ALL'') | Already Done |
| UPDATE cpg_filetypes SET player=''WMP'' WHERE extension IN (''asf'',''asx'',''mpg'',''mpeg'',''wmv'',''avi'',''mp3'',''midi'',''mid'',''wma'',''wav'') | Already Done |
| UPDATE cpg_filetypes SET player=''QT'' WHERE extension IN (''mov'') | Already Done |
| UPDATE cpg_filetypes SET player=''RMP'' WHERE extension IN (''ra'',''ram'',''rm'') | Already Done |
| UPDATE cpg_filetypes SET player=''SWF'' WHERE extension IN (''swc'',''swf'') | Already Done |
| ALTER TABLE cpg_comments add msg_raw_ip tinytext | Already Done |
| ALTER TABLE cpg_comments add msg_hdr_ip tinytext | Already Done |
| ALTER TABLE cpg_pictures add pic_raw_ip tinytext | Already Done |
| ALTER TABLE cpg_pictures add pic_hdr_ip tinytext | Already Done |
| INSERT INTO cpg_config VALUES (''thumb_use'', ''any'') | Already Done |
| INSERT INTO cpg_config VALUES (''show_private'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''first_level'', ''1'') | Already Done |
| INSERT INTO cpg_config VALUES (''display_film_strip'', ''1'') | Already Done |
| INSERT INTO cpg_config VALUES (''display_film_strip_filename'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''max_film_strip_items'', ''5'') | Already Done |
| INSERT INTO cpg_config VALUES (''read_iptc_data'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''display_uploader'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''display_filename'',''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''reg_notify_admin_email'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''disable_comment_flood_protect'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''upl_notify_admin_email'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''language_list'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''language_flags'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''theme_list'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''language_reset'', ''1'') | Already Done |
| INSERT INTO cpg_config VALUES (''theme_reset'', ''1'') | Already Done |
| INSERT INTO cpg_config VALUES (''offline'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''vanity_block'',''1'') | Already Done |
| INSERT INTO cpg_config VALUES (''allow_memberlist'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''display_faq'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''views_in_thumbview'', ''1'') | Already Done |
| INSERT INTO cpg_config VALUES (''show_bbcode_help'', ''1'') | Already Done |
| INSERT INTO cpg_config VALUES (''log_ecards'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''email_comment_notification'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''enable_zipdownload'', ''1'') | Already Done |
| INSERT INTO cpg_config VALUES (''debug_notice'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''slideshow_interval'', ''5000'') | Already Done |
| INSERT INTO cpg_config VALUES (''log_mode'', ''0'') | Already Done |
| INSERT INTO cpg_config VALUES (''media_autostart'', ''1'') | Already Done |
| INSERT INTO cpg_config VALUES (''enable_encrypted_passwords'',''0'') | Already Done |
| ALTER TABLE `cpg_categories` ADD `thumb` INT NOT NULL AFTER `parent` | Already Done |
| ALTER TABLE `cpg_albums` ADD `keyword` VARCHAR( 50 ) NOT NULL | Already Done |
| CREATE TABLE cpg_banned ( ban_id int(11) NOT NULL auto_increment, user_id int(11) DEFAULT NULL, ip_addr tinytext, expiry datetime DEFAULT NULL, PRIMARY KEY (ban_id) ) TYPE=MyISAM | Already Done |
| CREATE TABLE cpg_exif ( `filename` varchar(255) NOT NULL default '''', `exifData` text NOT NULL, UNIQUE KEY `filename` (`filename`) ) TYPE=MyISAM | Already Done |
| 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'' | Already Done |
| ALTER TABLE `cpg_usergroups` ADD `upload_form_config` TINYINT(4) DEFAULT ''3'' NOT NULL | Already Done |
| ALTER TABLE `cpg_usergroups` ADD `custom_user_upload` TINYINT(4) DEFAULT ''0'' NOT NULL | Already Done |
| ALTER TABLE `cpg_usergroups` ADD `num_file_upload` TINYINT(4) DEFAULT ''5'' NOT NULL | Already Done |
| ALTER TABLE `cpg_usergroups` ADD `num_URI_upload` TINYINT(4) DEFAULT ''3'' NOT NULL | Already Done |
| 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'' | Already Done |
| UPDATE `cpg_config` SET value=''classic'' WHERE (name=''theme'' AND value=''default'') | Already Done |
| DELETE FROM `cpg_filetypes` WHERE mime=''text/html'' | Already Done |
| UPDATE `cpg_config` SET value=''$/\\\\:*?" | Already Done |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done | |
| Already Done |
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