[rt-announce] RT 3.0.0rc4

[Jesse Vincent]

RT 3.0 RC4 Release notes

 There are several minor isses with RC4 that will be slipstreamed in 
 before 3.0.0, but otherwise, I believe we're basically there.

 You can pick up this release from 
 
        http://fsck.com/pub/rt/devel/rt-3-0-0rc4.tar.gz
    
      Changelog

      23     11	  New french translation
      25     12	  Brazilian Portuguese translation
      26     13	  Postgres fixes
      27     14	  Postgres schema tweak
      28     15	  Further postgres tweaks and fixes
      29     16	  RT should now be less overzealous about opening and then
		  marking a ticket 'new' again
      30     17	  Bumping to 3.0.0rc4

        As is often the case, several schema issues popped up at the last minute. Below are instructions for bringing an existing database up to date.


        Mysql:

        New column added

        mysql rt3 -e 'alter table sessions add column LastUpdated timestamp'


        Postgres:

        Several unavoidable changes have been made to RT's postgres database
        schema. 

        You'll need to issue the following commands to postgres in order
        to bring your schema up to date:

        ALTER TABLE Attachments RENAME COLUMN Content to OldContent;
        ALTER TABLE Attachments ADD COLUMN Content text NULL;
        UPDATE Attachments SET Content = OldContent;
        ALTER TABLE Attachments RENAME COLUMN Headers to OldHeaders;
        ALTER TABLE Attachments ADD COLUMN Headers text NULL;
        UPDATE Attachments SET Headers = OldHeaders;
        ALTER TABLE sessions ADD COLUMN LastUpdated TIMESTAMP not null default current_timestamp;

        (The following two commands will only work on Postgres 7.3)

        ALTER TABLE Attachments DROP Column OldContent;
        ALTER TABLE Attachments DROP Column OldHeaders;
-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.