Between RT 1.3.37 and RT 1.3.38, there will be schema changes.
The following commands will alter your RT database to cope with the
new state of the world. As always, I recommend backing up your database
before mucking with it.
-j
mysql> alter table Users CHANGE UserId Name varchar(120);
Query OK, 8 rows affected (0.22 sec)
Records: 8 Duplicates: 0 Warnings: 0
mysql> alter table Queues CHANGE QueueId Name varchar(40) not null default ‘’;
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> alter table Templates CHANGE Title Description varchar(120);
Query OK, 7 rows affected (0.00 sec)
Records: 7 Duplicates: 0 Warnings: 0
mysql> alter table Templates CHANGE Alias Name varchar(40) not null default ‘’;
Query OK, 7 rows affected (0.00 sec)
Records: 7 Duplicates: 0 Warnings: 0
mysql> alter table Tickets CHANGE Alias Name varchar(40) unique;
Query OK, 94 rows affected (0.03 sec)
Records: 94 Duplicates: 0 Warnings: 0
jesse reed vincent – root@eruditorum.org – jesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
Transporters are so ungodly. if god had wanted us to travel great distances
instantaneously, he would have given us an internal
materialisation/dematerialisation control.
– Shoshe Cole