USE [% pn %];

    ALTER TABLE [% table_prefix %]_users add timezone_offset float(3,1) not null default 12.0;
    ALTER TABLE [% table_prefix %]_referer ADD COLUMN frequency INT(15) AFTER url;
    ALTER TABLE [% table_prefix %]_authors ADD COLUMN radminblocks tinyint(2) DEFAULT '0' NOT NULL AFTER radminreviews;
    ALTER TABLE [% table_prefix %]_stories add withcomm int(1) DEFAULT '0' NOT NULL AFTER alanguage;
    ALTER TABLE [% table_prefix %]_autonews add withcomm int(1) DEFAULT '0' NOT NULL AFTER alanguage;
    ALTER TABLE [% table_prefix %]_queue add arcd int(1) DEFAULT '0' NOT NULL AFTER uid;
    ALTER TABLE [% table_prefix %]_faqcategories add parent_id TINYINT (3) DEFAULT '0' NOT NULL;
    ALTER TABLE [% table_prefix %]_faqanswer ADD submittedby VARCHAR(250) DEFAULT '' NOT NULL;
    ALTER TABLE [% table_prefix %]_authors add admlanguage varchar(30) NOT NULL;
    ALTER TABLE [% table_prefix %]_autonews add alanguage varchar(30) NOT NULL;
    ALTER TABLE [% table_prefix %]_blocks add blanguage varchar(30) NOT NULL;
    ALTER TABLE [% table_prefix %]_ephem add elanguage varchar(30) NOT NULL;
    ALTER TABLE [% table_prefix %]_faqcategories add flanguage varchar(30) NOT NULL;
    ALTER TABLE [% table_prefix %]_poll_desc add planguage varchar(30) NOT NULL;
    ALTER TABLE [% table_prefix %]_queue add alanguage varchar(30) NOT NULL;
    ALTER TABLE [% table_prefix %]_reviews add rlanguage varchar(30) NOT NULL;
    ALTER TABLE [% table_prefix %]_reviews_add add rlanguage varchar(30) NOT NULL;
    ALTER TABLE [% table_prefix %]_seccont add slanguage varchar(30) NOT NULL;
    ALTER TABLE [% table_prefix %]_stories add alanguage varchar(30) NOT NULL;
    ALTER TABLE [% table_prefix %]_stories add themeoverride varchar(30) NOT NULL default '';
    ALTER TABLE [% table_prefix %]_stories_cat add themeoverride varchar(30) NOT NULL default '';
    ALTER TABLE [% table_prefix %]_stories_cat modify title varchar(40) NOT NULL DEFAULT '';
    ALTER TABLE [% table_prefix %]_faqanswer modify text DEFAULT NULL;
    ALTER TABLE [% table_prefix %]_advblocks RENAME TO [% table_prefix %]_blocks;
    ALTER TABLE [% table_prefix %]_blocks CHANGE bid bid INT UNSIGNED NOT NULL AUTO_INCREMENT;
    ALTER TABLE [% table_prefix %]_blocks CHANGE bkey bkey VARCHAR(255) NOT NULL;
    AlTER TABLE [% table_prefix %]_blocks CHANGE title title VARCHAR(255) NOT NULL;
    ALTER TABLE [% table_prefix %]_blocks CHANGE url url VARCHAR(255) NOT NULL;
    ALTER TABLE [% table_prefix %]_blocks CHANGE weight weight DECIMAL(10,1) NOT NULL DEFAULT 0;
    ALTER TABLE [% table_prefix %]_blocks CHANGE active active TINYINT UNSIGNED NOT NULL DEFAULT 0;
    ALTER TABLE [% table_prefix %]_blocks CHANGE refresh refresh INT UNSIGNED NOT NULL DEFAULT 0;
    ALTER TABLE [% table_prefix %]_blocks CHANGE time last_update TIMESTAMP;
    ALTER TABLE [% table_prefix %]_advheadlines RENAME TO [% table_prefix %]_headlines;
    ALTER TABLE [% table_prefix %]_headlines CHANGE hid id INT UNSIGNED NOT NULL AUTO_INCREMENT;
    ALTER TABLE [% table_prefix %]_headlines CHANGE sitename sitename VARCHAR(255) NOT NULL DEFAULT '';
    ALTER TABLE [% table_prefix %]_headlines CHANGE headlinesurl rssurl VARCHAR(255) NOT NULL DEFAULT '';
    ALTER TABLE [% table_prefix %]_headlines ADD siteurl VARCHAR(255) NOT NULL DEFAULT '';
    ALTER TABLE [% table_prefix %]_queue add bodytext text;
    ALTER TABLE [% table_prefix %]_links_links CHANGE pn_url VARCHAR(255) NOT NULL DEFAULT '';
    ALTER TABLE [% table_prefix %]_links_modrequest CHANGE pn_url VARCHAR(255) NOT NULL DEFAULT '';
    ALTER TABLE [% table_prefix %]_links_newlink CHANGE pn_url VARCHAR(255) NOT NULL DEFAULT '';
    ALTER TABLE [% table_prefix %]_faqanswer CHANGE pn_id INT(6) NOT NULL auto_increment;
    ALTER TABLE [% table_prefix %]_faqanswer CHANGE pn_id_cat INT(6) DEFAULT NULL;
    ALTER TABLE [% table_prefix %]_faqcategories CHANGE pn_id_cat INT(6) NOT NULL auto_increment;
    ALTER TABLE [% table_prefix %]_faqcategories CHANGE pn_parent_id INT(6) DEFAULT '0' NOT NULL;
    ALTER TABLE [% table_prefix %]_topics CHANGE pn_itopicid TINYINT(4) NOT NULL auto_increment
    ALTER TABLE [% table_prefix %]_autonews CHANGE pn_topic TINYINT(4) DEFAULT '1' NOT NULL;
    ALTER TABLE [% table_prefix %]_stories CHANGE pn_topic TINYINT(4) DEFAULT '1' NOT NULL;

/*
        UPDATE [% table_prefix %]_autonews SET alanguage='$language' ';
        UPDATE [% table_prefix %]_ephem SET elanguage='$language' ';
        UPDATE [% table_prefix %]_faqcategories SET flanguage='$language' ';
        UPDATE [% table_prefix %]_poll_desc SET planguage='$language' ';
        UPDATE [% table_prefix %]_queue SET alanguage='$language' ';
        UPDATE [% table_prefix %]_reviews SET rlanguage='$language' ';
        UPDATE [% table_prefix %]_reviews_add SET rlanguage='$language' ';
        UPDATE [% table_prefix %]_seccont SET slanguage='$language' ';
        UPDATE [% table_prefix %]_stories SET alanguage='$language' ';

*/
        UPDATE [ % table_prefix %]_message SET pn_title='Welcome to PostNuke, the =-Phoenix-= release (0.763)'  WHERE pn_mid = '1';
        UPDATE [% table_prefix %]_blocks SET bkey='text' WHERE bkey='';

        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '0', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '1', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '2', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '3', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '4', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '5', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '6', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '7', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '8', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '9', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '10', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '11', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '12', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '13', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '14', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '15', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '16', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '17', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '18', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '19', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '20', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '21', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '22', '0');
        INSERT INTO [% table_prefix %]_stats_hour (hour, hits) VALUES ( '23', '0');
        INSERT INTO [% table_prefix %]_stats_month (month, hits) VALUES ( '1', '0');
        INSERT INTO [% table_prefix %]_stats_month (month, hits) VALUES ( '2', '0');
        INSERT INTO [% table_prefix %]_stats_month (month, hits) VALUES ( '3', '0');
        INSERT INTO [% table_prefix %]_stats_month (month, hits) VALUES ( '4', '0');
        INSERT INTO [% table_prefix %]_stats_month (month, hits) VALUES ( '5', '0');
        INSERT INTO [% table_prefix %]_stats_month (month, hits) VALUES ( '6', '0');
        INSERT INTO [% table_prefix %]_stats_month (month, hits) VALUES ( '7', '0');
        INSERT INTO [% table_prefix %]_stats_month (month, hits) VALUES ( '8', '0');
        INSERT INTO [% table_prefix %]_stats_month (month, hits) VALUES ( '9', '0');
        INSERT INTO [% table_prefix %]_stats_month (month, hits) VALUES ( '10', '0');
        INSERT INTO [% table_prefix %]_stats_month (month, hits) VALUES ( '11', '0');
        INSERT INTO [% table_prefix %]_stats_month (month, hits) VALUES ( '12', '0');
        INSERT INTO [% table_prefix %]_stats_week (weekday, hits) VALUES ( '0', '0');
        INSERT INTO [% table_prefix %]_stats_week (weekday, hits) VALUES ( '1', '0');
        INSERT INTO [% table_prefix %]_stats_week (weekday, hits) VALUES ( '2', '0');
        INSERT INTO [% table_prefix %]_stats_week (weekday, hits) VALUES ( '3', '0');
        INSERT INTO [% table_prefix %]_stats_week (weekday, hits) VALUES ( '4', '0');
        INSERT INTO [% table_prefix %]_stats_week (weekday, hits) VALUES ( '5', '0');
        INSERT INTO [% table_prefix %]_stats_week (weekday, hits) VALUES ( '6', '0');

/*        
        INSERT INTO TABLE [% table_prefix %]_message VALUES  ( '1', 'New Message system', 'The new message system was written for Multilingual PHP-Nuke 5 available at <a href=\"http://www.webmasters.be\" target=\"_blank\">http://www.webmasters.be</a>. The original version in Nuke 5 allowed the admin to post only 1 message either to \'ALL visitors\' OR \'Anonymous users only\' OR \'Registered users only\' OR \'Admins only\'.<br>The new system allows admin(s) to post <b>multiple</b> messages in <b>multiple languages</b>, visible to different types of users. There is also an option to post a message to ALL languages at once...<br><br><br>Crocket', '993373194', '0', '1', '1', '');
        INSERT INTO [% table_prefix %]_blocks_buttons (id, bid, title, url, images) VALUES (NULL, $row[bid], '$v[title]', '$v[url]', '$image');
*/
