[rt-users] RT 4.4: Leftover RTx Tables in DB

[Kevin Buckley]

Been following/using RT's Assets since the Extension days but had upgraded
to RT 4.4.0rc1 a while back now.

Came to run an SQL query, held in a file, against the underlying DB, so as
to produce some output in a format that matches that shown in a vendor's
portal display.

Was mystified as to why a couple of recent additions to my Asset catalogs
were not showing up.

Eventually realied that the SQL query had been written thus

SELECT
       SuppSNum.Content as 'Serial Num',
       RPAD(RTxAssets.Name, 20, ' ') as 'Host name',
       SuppSite.Content as 'Site Id',
       Warranty.Content as 'Expiration Date'
  FROM RTxAssets,
       ObjectCustomFieldValues as Warranty,
       ObjectCustomFieldValues as SuppSNum,
       ObjectCustomFieldValues as SuppSite
...

so against the old RT::Extension tables, which are clearly still within the DB.

Dropping the RTx so as to query the upgraded tables gave me the current details.

Can I just bin the (two ?) RTx tables ?

 RTxAssets
 RTxCatalogs

or are there "things to look out for" ?

Kevin M. Buckley

eScience Consultant
School of Engineering and Computer Science
Victoria University of Wellington
New Zealand