[rt-devel] [rt-announce] RT 3.0.0rc4
Jesse Vincent
jesse at bestpractical.com
Fri Mar 21 12:59:13 EST 2003
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.
_______________________________________________
rt-announce mailing list
rt-announce at lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-announce
More information about the Rt-devel
mailing list