USE [% pn %]; 
 
ALTER TABLE [% table_prefix %]_comments ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_counter ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_downloads_categories ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_downloads_downloads ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_downloads_editorials ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_downloads_modrequest ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_downloads_newdownload ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_downloads_subcategories ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_downloads_votedata ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_faqanswer ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_faqcategories ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_languages_constant ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_languages_file ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_languages_translation ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_links_categories ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_links_editorials ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_links_links ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_links_modrequest ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_links_newlink ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_links_votedata ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_poll_check ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_poll_data ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_poll_desc ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_pollcomments ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_referer ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_reviews ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_reviews_add ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_reviews_add ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_reviews_comments ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_reviews_main ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_seccont ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_sections ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_stats_date ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_stats_hour ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_stats_month ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_stats_week ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_theme_addons ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_theme_blcontrol ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_theme_cache ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_theme_layout ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_theme_palette ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_theme_skins ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_theme_tplfile ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_theme_tplsource ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_theme_zones ENGINE=InnoDB;
ALTER TABLE [% table_prefix %]_topics ENGINE=InnoDB;

ALTER TABLE [% table_prefix %]_blocks MODIFY COLUMN `pn_last_update` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP;
ALTER TABLE [% table_prefix %]_userblocks MODIFY COLUMN `pn_last_update` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP;
ALTER TABLE [% table_prefix %]_theme_tplsource MODIFY COLUMN `tpl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP;

INSERT INTO `[% table_prefix %]_module_vars` VALUES (NULL, '/PNConfig', 'safehtml', 's:1:"1";');
INSERT INTO `[% table_prefix %]_module_vars` VALUES (NULL, '/PNConfig', 'idnnames', 'i:0;');
 
UPDATE `[% table_prefix %]_message` SET pn_title='Welcome to PostNuke, the =-Phoenix-= release (0.762)' WHERE pn_mid='1'; 

UPDATE `[% table_prefix %]_module_vars` SET pn_value='' WHERE pn_value='0' AND pn_id='9';
UPDATE `[% table_prefix %]_module_vars` SET pn_value='s:7:"12.2005";' WHERE pn_value='s:7:"08.2005";' AND pn_id='19';
UPDATE `[% table_prefix %]_module_vars` SET pn_value='0' WHERE pn_value='' AND ( pn_id='115' OR pn_id='115' OR pn_id='118' OR pn_id='119' OR pn_id='120' OR pn_id='121' OR pn_id='123' OR pn_id='124' OR pn_id='125' OR pn_id='126' OR pn_id='127' OR pn_id='128');
 
UPDATE `[% table_prefix %]_modules` SET pn_description='Postnuke Administration Module' WHERE pn_id='1';
UPDATE `[% table_prefix %]_modules` SET pn_description='Modify permissions security' WHERE pn_id='5';
UPDATE `[% table_prefix %]_modules` SET pn_description='A module to display the news on your index page' WHERE pn_id='6';
UPDATE `[% table_prefix %]_modules` SET pn_description='PN-Core user module' WHERE pn_id='7';
UPDATE `[% table_prefix %]_modules` SET pn_version='1.20' WHERE pn_id='31';
UPDATE `[% table_prefix %]_modules` SET pn_version='pn_bbsmile' WHERE pn_id='32';
UPDATE `[% table_prefix %]_modules` SET pn_version='1.4' WHERE pn_id='42';
