use [% cpm %];


ALTER TABLE `[% table_prefix %]_albums`
ADD COLUMN `alb_hits` int(10) NOT NULL default '0';
ALTER TABLE `[% table_prefix %]_albums`
ADD COLUMN `owner` int(11) NOT NULL default '1';
ALTER TABLE `[% table_prefix %]_albums`
ADD COLUMN `moderator_group` int(11) NOT NULL default '0';
ALTER TABLE `[% table_prefix %]_albums`
ADD INDEX `moderator_group` (`moderator_group`);
ALTER TABLE `[% table_prefix %]_albums`
ADD INDEX `visibility` (`visibility`);


ALTER TABLE `[% table_prefix %]_banned`
ADD COLUMN `user_name` varchar(255) NOT NULL default '';
ALTER TABLE `[% table_prefix %]_banned`
ADD COLUMN `email` varchar(255) NOT NULL default '';


ALTER TABLE `[% table_prefix %]_categories`
ADD COLUMN `depth` tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE `[% table_prefix %]_categories`
ADD COLUMN `lft` mediumint(8) unsigned NOT NULL default '0';
ALTER TABLE `[% table_prefix %]_categories`
ADD COLUMN `rgt` mediumint(8) unsigned NOT NULL default '0';
ALTER TABLE `[% table_prefix %]_categories`
ADD INDEX `depth_cid` (`depth`,`cid`);
ALTER TABLE `[% table_prefix %]_categories`
ADD INDEX `lft_depth` (`lft`,`depth`);


DROP TABLE IF EXISTS `[% table_prefix %]_categorymap`;
CREATE TABLE `[% table_prefix %]_categorymap` (
  `cid` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY  (`cid`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Holds the categories where groups can create albums';


ALTER TABLE `[% table_prefix %]_comments`
ADD COLUMN `approval` enum('YES','NO') NOT NULL default 'YES';
ALTER TABLE `[% table_prefix %]_comments`
ADD COLUMN `spam` enum('YES','NO') NOT NULL default 'NO';
ALTER TABLE `[% table_prefix %]_comments`
ADD INDEX `author_id` (`author_id`);


INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('alb_desc_thumb', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('allow_user_account_delete', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('allow_user_album_keyword', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('allow_user_edit_after_cat_close', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('allow_user_move_album', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('allow_user_upload_choice', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('batch_proc_limit', '2');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('browse_by_date', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('comment_akismet_api_key', '');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('comment_akismet_counter', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('comment_akismet_enable', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('comment_akismet_group', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('comment_approval', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('comment_captcha', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('comment_placeholder', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('comment_promote_registration', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('comments_per_page', '20');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('comment_user_edit', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('contact_form_guest_email_field', '2');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('contact_form_guest_enable', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('contact_form_guest_name_field', '2');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('contact_form_registered_enable', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('contact_form_sender_email', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('contact_form_subject_content', 'Coppermine gallery contact form');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('contact_form_subject_field', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('count_admin_hits', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('count_album_hits', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('count_file_hits', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('display_comment_approval_only', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('display_coppermine_news', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('display_redirection_page', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('display_reset_boxes_in_config', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('display_sidebar_guest', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('display_sidebar_user', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('display_stats_on_index', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('display_thumbnail_rating', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('display_thumbs_batch_add', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('display_xp_publish_link', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('ecard_flash', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('enable_menu_icons', '2');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('enable_thumb_watermark', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('enable_unsharp', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('enable_watermark', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('fullsize_padding_x', '5');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('fullsize_padding_y', '3');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('global_registration_pw', '');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('guest_token_cleanup', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('keyword_separator', ';');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('language_autodetect', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('login_method', 'username');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('old_style_rating', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('orig_pfx', 'orig_');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('performance_page_generation_time', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('performance_page_query_count', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('performance_page_query_time', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('performance_timestamp', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('personal_album_on_registration', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('picinfo_movie_download_link', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('picture_use', 'thumb');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('purge_expired_bans', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('rate_own_files', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('rating_stars_amount', '5');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('reduce_watermark', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('registration_captcha', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('session_cleanup', '1276716928');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('silly_safe_mode', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('site_token', MD5(RAND()));
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('form_token_lifetime', '900');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('slideshow_hits', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('tabs_dropdown', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('thumb_height', '128'); -- set to thumb_width
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('thumbnail_to_fullsize', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('transparent_overlay', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('unsharp_amount', '120');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('unsharp_radius', '0.5');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('unsharp_threshold', '3');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('upload_mechanism', 'swfupload');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('user_registration_disclaimer', '1');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('watermark_file', 'images/watermark.png');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('watermark_transparency', '40');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('watermark_transparency_featherx', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('watermark_transparency_feathery', '0');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('where_put_watermark', 'southeast');
INSERT IGNORE INTO `[% table_prefix %]_config` (`name`, `value`) VALUES ('which_files_to_watermark', 'both');


ALTER TABLE `[% table_prefix %]_dict`
CHANGE COLUMN `keyword` `keyword` varchar(60) NOT NULL;
ALTER TABLE `[% table_prefix %]_dict`
ADD INDEX `keyword` (`keyword`);


ALTER TABLE `[% table_prefix %]_exif`
ADD COLUMN `pid` int(11) NOT NULL;

UPDATE `[% table_prefix %]_exif`
INNER JOIN `[% table_prefix %]_pictures`
ON `[% table_prefix %]_exif`.`filename` = concat(
    (
        SELECT `value`
        FROM `[% table_prefix %]_config`
        WHERE `name` = 'fullpath'
    ),
    `[% table_prefix %]_pictures`.`filepath`,
    `[% table_prefix %]_pictures`.`filename`
)
SET `[% table_prefix %]_exif`.`pid` = `[% table_prefix %]_pictures`.`pid`;

ALTER TABLE `[% table_prefix %]_exif`
DROP COLUMN `filename`;
ALTER TABLE `[% table_prefix %]_exif`
ADD PRIMARY KEY (`pid`);


ALTER TABLE `[% table_prefix %]_filetypes`
CHANGE COLUMN `mime` `mime` char(254) default NULL;


ALTER TABLE `[% table_prefix %]_hit_stats`
ADD COLUMN `uid` int(11) NOT NULL default '0';


DROP TABLE IF EXISTS `[% table_prefix %]_languages`;
CREATE TABLE `[% table_prefix %]_languages` (
  `lang_id` varchar(40) NOT NULL default '',
  `english_name` varchar(70) default NULL,
  `native_name` varchar(70) default NULL,
  `custom_name` varchar(70) default NULL,
  `flag` varchar(15) default NULL,
  `abbr` varchar(15) NOT NULL default '',
  `available` enum('YES','NO') NOT NULL default 'NO',
  `enabled` enum('YES','NO') NOT NULL default 'NO',
  `complete` enum('YES','NO') NOT NULL default 'NO',
  PRIMARY KEY  (`lang_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Contains the language file definitions';


INSERT INTO `[% table_prefix %]_languages` (`lang_id`, `english_name`, `native_name`, `custom_name`, `flag`, `abbr`, `available`, `enabled`, `complete`) VALUES
('albanian', 'Albanian', 'Albanian', NULL, 'al', 'al', 'NO', 'NO', 'NO'),
('arabic', 'Arabic', '&#1575;&#1604;&#1593;&#1585;&#1576;&#1610;&#1577;', NULL, 'sa', 'ar', 'NO', 'NO', 'NO'),
('armenian', 'Armenian', '', NULL, '', '', 'NO', 'NO', 'NO'),
('azerbaijani', 'Azerbaijani', '', NULL, 'az', '', 'NO', 'NO', 'NO'),
('basque', 'Basque', 'Euskera', NULL, 'basque', '', 'NO', 'NO', 'NO'),
('bosnian', 'Bosnian', 'Bosanski', NULL, 'ba', '', 'NO', 'NO', 'NO'),
('brazilian_portuguese', 'Portuguese (Brazilian)', 'Portugu&ecirc;s Brasileiro', NULL, 'br', '', 'NO', 'NO', 'NO'),
('bulgarian', 'Bulgarian', '&#1041;&#1098;&#1083;&#1075;&#1072;&#1088;&#1089;&#1082;&#1080;', NULL, 'bg', '', 'YES', 'YES', 'NO'),
('byelorussian', 'Byelorussian', '', NULL, 'by', '', 'NO', 'NO', 'NO'),
('catalan', 'Catalan', 'Catal&agrave;', NULL, 'catalonia', '', 'NO', 'NO', 'NO'),
('chinese_big5', 'Chinese traditional', '&#20013;&#25991; - &#32321;&#39636;', NULL, 'tw', 'cn', 'NO', 'NO', 'NO'),
('chinese_gb', 'Chinese simplified', '&#20013;&#25991; - &#31616;&#20307;', NULL, 'cn', 'cn', 'YES', 'YES', 'NO'),
('croatian', 'Croatian', 'Hrvatski', NULL, 'hr', '', 'NO', 'NO', 'NO'),
('czech', 'Czech', '&#x010C;esky', NULL, 'cz', 'cz', 'YES', 'YES', 'NO'),
('danish', 'Danish', 'Dansk', NULL, 'dk', 'dk', 'NO', 'NO', 'NO'),
('dutch', 'Dutch', 'Nederlands', NULL, 'nl', 'nl', 'NO', 'NO', 'NO'),
('english', 'English (US)', 'English (US)', NULL, 'us', 'en', 'YES', 'YES', 'YES'),
('english_gb', 'English (British)', 'English (British)', NULL, 'gb', 'en', 'NO', 'NO', 'NO'),
('estonian', 'Estonian', 'Eesti', NULL, 'ee', 'ee', 'NO', 'NO', 'NO'),
('filipino', 'Filipino Tagalog', '', NULL, 'ph', '', 'NO', 'NO', 'NO'),
('finnish', 'Finnish', 'Suomea', NULL, 'fi', '', 'YES', 'YES', 'YES'),
('french', 'French', 'Fran&ccedil;ais', NULL, 'fr', 'fr', 'YES', 'YES', 'YES'),
('galician', 'Galician', 'Galego', NULL, 'galician', '', 'NO', 'NO', 'NO'),
('georgian', 'Georgian', '&#4325;&#4304;&#4320;&#4311;&#4323;&#4314;&#4312;', NULL, 'ge', '', 'NO', 'NO', 'NO'),
('german', 'German (informal)', 'Deutsch (Du)', NULL, 'de', 'de', 'YES', 'YES', 'YES'),
('german_formal', 'German (formal)', 'Deutsch (Sie)', NULL, 'de', 'de', 'YES', 'YES', 'YES'),
('greek', 'Greek', '&#917;&#955;&#955;&#951;&#957;&#953;&#954;&#940;', NULL, 'gr', 'gr', 'YES', 'YES', 'YES'),
('hebrew', 'Hebrew', '&#1506;&#1489;&#1512;&#1497;&#1514;', NULL, 'il', '', 'NO', 'NO', 'NO'),
('hindi', 'Hindi', '&#2361;&#2367;&#2344;&#2381;&#2342;&#2368;', NULL, 'in', '', 'NO', 'NO', 'NO'),
('hungarian', 'Hungarian', 'Magyarul', NULL, 'hu', '', 'NO', 'NO', 'NO'),
('icelandic', 'Icelandic', '', NULL, 'is', '', 'NO', 'NO', 'NO'),
('indonesian', 'Indonesian', 'Bahasa Indonesia', NULL, 'id', '', 'NO', 'NO', 'NO'),
('italian', 'Italian', 'Italiano', NULL, 'it', 'it', 'NO', 'NO', 'NO'),
('japanese', 'Japanese', '&#26085;&#26412;&#35486;', NULL, 'jp', 'jp', 'NO', 'NO', 'NO'),
('kazakh', 'Kazakh', '', NULL, 'kz', '', 'NO', 'NO', 'NO'),
('korean', 'Korean', '&#54620;&#44397;&#50612;', NULL, 'kr', '', 'NO', 'NO', 'NO'),
('kurdish', 'Kurdish', '&#1603;&#1608;&#1585;&#1583;&#1740;', NULL, 'kurdish', '', 'NO', 'NO', 'NO'),
('kyrgyz', 'Kyrgyz', '', NULL, 'kg', '', 'NO', 'NO', 'NO'),
('laothian', 'Laothian ', '', NULL, 'la', '', 'NO', 'NO', 'NO'),
('latvian', 'Latvian', 'Latvian', NULL, 'lv', '', 'NO', 'NO', 'NO'),
('lithuanian', 'Lithuanian', 'Letzeburgisch', NULL, 'lu', '', 'NO', 'NO', 'NO'),
('luxembourgish', 'Luxembourgish', 'Lietuvi&#0353;kai', NULL, 'lt', '', 'NO', 'NO', 'NO'),
('macedonian', 'Macedonian', '&#1052;&#1072;&#1082;&#1077;&#1076;&#1086;&#1085;&#1089;&#1082;&#1080;', NULL, 'mk', '', 'NO', 'NO', 'NO'),
('malay', 'Malay', 'Bahasa Melayu', NULL, 'my', '', 'NO', 'NO', 'NO'),
('maltese', 'Maltese', '', NULL, 'mt', '', 'NO', 'NO', 'NO'),
('mongolian', 'Mongolian', '', NULL, 'mn', '', 'NO', 'NO', 'NO'),
('nepali', 'Nepali', '', NULL, 'np', '', 'NO', 'NO', 'NO'),
('norwegian', 'Norwegian', 'Norsk', NULL, 'no', 'no', 'NO', 'NO', 'NO'),
('persian', 'Persian', '&#1601;&#1575;&#1585;&#1587;&#1740;', NULL, 'ir', '', 'NO', 'NO', 'NO'),
('polish', 'Polish', 'Polski', NULL, 'pl', 'pl', 'YES', 'YES', 'YES'),
('portuguese', 'Portuguese (Portugal)', 'Portugu&ecirc;s', NULL, 'pt', '', 'NO', 'NO', 'NO'),
('romanian', 'Romanian', 'Rom&acirc;n&atilde;', NULL, 'ro', '', 'NO', 'NO', 'NO'),
('russian', 'Russian', '&#1056;&#1091;&#1089;&#1089;&#1082;&#1080;&#1081;', NULL, 'ru', 'ru', 'YES', 'YES', 'YES'),
('slovak', 'Slovak', 'Slovensky', NULL, 'sk', '', 'NO', 'NO', 'NO'),
('slovenian', 'Slovenian', 'Slovensko', NULL, 'si', '', 'YES', 'YES', 'NO'),
('spanish', 'Spanish', 'Espa&ntilde;ol', NULL, 'es', 'es', 'YES', 'YES', 'YES'),
('spanish_mx', 'Mexican Spanish', 'Espa&ntilde;ol mexicano', NULL, 'mx', 'mx', 'YES', 'YES', 'NO'),
('swedish', 'Swedish', 'Svenska', NULL, 'se', '', 'NO', 'NO', 'NO'),
('thai', 'Thai', '&#3652;&#3607;&#3618;', NULL, 'th', '', 'NO', 'NO', 'NO'),
('tigrinya', 'Tigrinya', '', NULL, 'er', '', 'NO', 'NO', 'NO'),
('twi', 'Twi', '', NULL, 'gh', '', 'NO', 'NO', 'NO'),
('uighur', 'Uighur', 'Uighur', NULL, 'uighur', '', 'NO', 'NO', 'NO'),
('ukrainian', 'Ukrainian', '&#1059;&#1082;&#1088;&#1072;&#1111;&#1085;&#1089;&#1100;&#1082;&#1072;', NULL, 'ua', '', 'YES', 'YES', 'YES'),
('uzbek', 'Uzbek', '', NULL, 'uz', '', 'NO', 'NO', 'NO'),
('vietnamese', 'Vietnamese', 'Tieng Viet', NULL, 'vn', '', 'NO', 'NO', 'NO'),
('welsh', 'Welsh', 'Cymraeg', NULL, 'wales', '', 'NO', 'NO', 'NO');


ALTER TABLE `[% table_prefix %]_pictures`
DROP COLUMN `owner_name`;
ALTER TABLE `[% table_prefix %]_pictures`
ADD COLUMN `guest_token` varchar(32) default '';
ALTER TABLE `[% table_prefix %]_pictures`
DROP INDEX `pic_aid`;
ALTER TABLE `[% table_prefix %]_pictures`
ADD INDEX `pic_aid` (`aid`,`pid`);
ALTER TABLE `[% table_prefix %]_sessions`
CHANGE COLUMN `session_id` `session_id` char(32) NOT NULL default '';


DROP TABLE `[% table_prefix %]_temp_data`;


DROP TABLE IF EXISTS `[% table_prefix %]_temp_messages`;
CREATE TABLE `[% table_prefix %]_temp_messages` (
  `message_id` varchar(80) NOT NULL default '',
  `user_id` int(11) default '0',
  `time` int(11) default NULL,
  `message` text NOT NULL,
  PRIMARY KEY  (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store messages from one page to the other';


ALTER TABLE `[% table_prefix %]_usergroups`
DROP COLUMN `upload_form_config`;
ALTER TABLE `[% table_prefix %]_usergroups`
DROP COLUMN `num_file_upload`;
ALTER TABLE `[% table_prefix %]_usergroups`
DROP COLUMN `custom_user_upload`;
ALTER TABLE `[% table_prefix %]_usergroups`
DROP COLUMN `num_URI_upload`;
ALTER TABLE `[% table_prefix %]_usergroups`
ADD COLUMN `access_level` tinyint(4) NOT NULL default '3';


ALTER TABLE `[% table_prefix %]_users`
ADD COLUMN `user_language` varchar(40) NOT NULL default '';
ALTER TABLE `[% table_prefix %]_users`
DROP INDEX `user_name`;
ALTER TABLE `[% table_prefix %]_users`
ADD INDEX `user_name` (`user_name`);
ALTER TABLE `[% table_prefix %]_users`
ADD INDEX `user_group` (`user_group`);


ALTER TABLE `[% table_prefix %]_vote_stats`
ADD COLUMN `uid` int(11) NOT NULL default '0';
