| Performing Database Updates |
|
CREATE TABLE IF NOT EXISTS cp_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 `cp_filetypes` DROP INDEX `EXTENSION`, ADD PRIMARY KEY ( `extension` ) | Already Done |
|
INSERT INTO cp_filetypes VALUES ('jpg', 'image/jpg', 'image') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('jpeg', 'image/jpeg', 'image') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('jpe', 'image/jpe', 'image') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('gif', 'image/gif', 'image') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('png', 'image/png', 'image') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('psd', 'image/psd', 'image') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('bmp', 'image/bmp', 'image') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('jpc', 'image/jpc', 'image') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('jp2', 'image/jp2', 'image') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('jpx', 'image/jpx', 'image') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('jb2', 'image/jb2', 'image') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('swc', 'image/swc', 'image') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('iff', 'image/iff', 'image') | Already Done |
|
UPDATE cp_config SET value='ALL' WHERE name='allowed_img_types' | OK |
|
INSERT INTO cp_filetypes VALUES ('asf', 'video/x-ms-asf', 'movie') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('asx', 'video/x-ms-asx', 'movie') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('mpg', 'video/mpeg', 'movie') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('mpeg', 'video/mpeg', 'movie') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('wmv', 'video/x-ms-wmv', 'movie') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('swf', 'application/x-shockwave-flash', 'movie') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('avi', 'video/avi', 'movie') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('mov', 'video/quicktime', 'movie') | Already Done |
|
INSERT INTO cp_config VALUES ('allowed_mov_types', 'ALL') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('mp3', 'audio/mpeg3', 'audio') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('midi', 'audio/midi', 'audio') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('mid', 'audio/midi', 'audio') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('wma', 'audio/x-ms-wma', 'audio') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('wav', 'audio/wav', 'audio') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('ogg', 'audio/ogg', 'audio') | Already Done |
|
INSERT INTO cp_config VALUES ('allowed_snd_types', 'ALL') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('ram', 'audio/x-pn-realaudio', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('ra', 'audio/x-realaudio', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('rm', 'audio/x-realmedia', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('tiff', 'image/tiff', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('tif', 'image/tif', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('doc', 'application/msword', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('txt', 'text/plain', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('rtf', 'text/richtext', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('pdf', 'application/pdf', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('xls', 'application/excel', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('pps', 'application/powerpoint', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('ppt', 'application/powerpoint', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('zip', 'application/zip', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('rar', 'application/rar', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('gz', 'application/gz', 'document') | Already Done |
|
INSERT INTO cp_filetypes VALUES ('mdb', 'application/msaccess', 'document') | Already Done |
|
INSERT INTO cp_config VALUES ('allowed_doc_types', 'ALL') | Already Done |
|
ALTER TABLE cp_comments add msg_raw_ip tinytext | Already Done |
|
ALTER TABLE cp_comments add msg_hdr_ip tinytext | Already Done |
|
ALTER TABLE cp_pictures add pic_raw_ip tinytext | Already Done |
|
ALTER TABLE cp_pictures add pic_hdr_ip tinytext | Already Done |
|
INSERT INTO cp_config VALUES ('thumb_use', 'any') | Already Done |
|
INSERT INTO cp_config VALUES ('show_private', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('first_level', '1') | Already Done |
|
INSERT INTO cp_config VALUES ('display_film_strip', '1') | Already Done |
|
INSERT INTO cp_config VALUES ('max_film_strip_items', '5') | Already Done |
|
INSERT INTO cp_config VALUES ('comment_email_notification', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('read_iptc_data', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('display_uploader', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('reg_notify_admin_email', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('disable_comment_flood_protect', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('upl_notify_admin_email', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('language_list', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('language_flags', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('theme_list', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('language_reset', '1') | Already Done |
|
INSERT INTO cp_config VALUES ('theme_reset', '1') | Already Done |
|
INSERT INTO cp_config VALUES ('offline', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('allow_memberlist', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('display_faq', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('views_in_thumbview', '1') | Already Done |
|
INSERT INTO cp_config VALUES ('show_bbcode_help', '1') | Already Done |
|
INSERT INTO cp_config VALUES ('log_ecards', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('email_comment_notification', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('enable_zipdownload', '1') | Already Done |
|
INSERT INTO cp_config VALUES ('debug_notice', '0') | Already Done |
|
INSERT INTO cp_config VALUES ('slideshow_interval', '5000') | Already Done |
|
ALTER TABLE `cp_categories` ADD `thumb` INT NOT NULL AFTER `parent` | Already Done |
|
ALTER TABLE `cp_albums` ADD `keyword` VARCHAR( 50 ) NOT NULL | Already Done |
|
CREATE TABLE cp_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 | Already Done |
|
CREATE TABLE cp_exif (
`filename` varchar(255) NOT NULL default '',
`exifData` text NOT NULL,
UNIQUE KEY `filename` (`filename`)
) TYPE=MyISAM | Already Done |
|
CREATE TABLE cp_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 `cp_usergroups` ADD `upload_form_config` TINYINT(4) DEFAULT '3' NOT NULL | Already Done |
|
ALTER TABLE `cp_usergroups` ADD `custom_user_upload` TINYINT(4) DEFAULT '0' NOT NULL | Already Done |
|
ALTER TABLE `cp_usergroups` ADD `num_file_upload` TINYINT(4) DEFAULT '5' NOT NULL | Already Done |
|
ALTER TABLE `cp_usergroups` ADD `num_URI_upload` TINYINT(4) DEFAULT '3' NOT NULL | Already Done |
|
CREATE TABLE IF NOT EXISTS `cp_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 `cp_config` SET value='classic' WHERE (name='theme' AND value='default') | OK |
|
DELETE FROM `cp_filetypes` WHERE mime='text/html' | OK |
|
ALTER TABLE `cp_users` CHANGE user_lang user_group_list varchar(255) NOT NULL default '' | Already Done |
|
ALTER TABLE cp_pictures DROP INDEX `owner_id` | OK |
|
ALTER TABLE cp_pictures DROP INDEX `owner_id_2` | Already Done |
|
ALTER TABLE cp_pictures DROP INDEX `owner_id_3` | Already Done |
|
ALTER TABLE cp_pictures DROP INDEX `owner_id_4` | Already Done |
|
ALTER TABLE cp_pictures ADD INDEX owner_id( `owner_id` ) | OK |
|
ALTER TABLE `cp_pictures` ADD `lasthit_ip` TINYTEXT | Already Done |
Upgrade completed
|
Coppermine is now upgraded and ready to roll.
|
Let's continue !
|
