diff options
Diffstat (limited to 'rt/etc')
| -rw-r--r-- | rt/etc/drop.Oracle | 6 | ||||
| -rw-r--r-- | rt/etc/initialdata | 38 |
2 files changed, 2 insertions, 42 deletions
diff --git a/rt/etc/drop.Oracle b/rt/etc/drop.Oracle index e120caa65..4ce5de475 100644 --- a/rt/etc/drop.Oracle +++ b/rt/etc/drop.Oracle @@ -14,8 +14,7 @@ DROP TABLE SCRIPCONDITIONS; DROP TABLE SCRIPS; DROP TABLE SESSIONS; DROP TABLE TEMPLATES; -DROP TABLE OBJECTUSTOMFIELDS; -DROP TABLE OBJECTUSTOMFIELDVALUES; +DROP TABLE TICKETCUSTOMFIELDVALUES; DROP TABLE TICKETS; DROP TABLE TRANSACTIONS; DROP TABLE USERS; @@ -34,8 +33,7 @@ DROP SEQUENCE SCRIPACTIONS_seq; DROP SEQUENCE SCRIPCONDITIONS_seq; DROP SEQUENCE SCRIPS_seq; DROP SEQUENCE TEMPLATES_seq; -DROP SEQUENCE OBJECTCUSTOMFIELDVALUES_seq; -DROP SEQUENCE OBJECTCUSTOMFIELDS_seq; +DROP SEQUENCE TICKETCUSTOMFIELDVALUES_seq; DROP SEQUENCE TICKETS_seq; DROP SEQUENCE TRANSACTIONS_seq; DROP SEQUENCE USERS_seq; diff --git a/rt/etc/initialdata b/rt/etc/initialdata index 1d8181d1a..3a21ce1f6 100644 --- a/rt/etc/initialdata +++ b/rt/etc/initialdata @@ -585,41 +585,3 @@ return 0; # ignore $passed; Right => 'SuperUser', }, ); - -# Predefined searches - -@Attributes = ( - { Name => 'Search - My Tickets', - Description => '[_1] highest priority tickets I own', # loc - Content => - { Format => "'<a href=\"__WebPath__/Ticket/Display.html?id=__id__\">__id__</a>/TITLE:#', '<a href=\"__WebPath__/Ticket/Display.html?id=__id__\">__Subject__</a>/TITLE:Subject', Priority, QueueName, ExtendedStatus", - Query => " Owner = '__CurrentUser__' AND ( Status = 'new' OR Status = 'open')", - OrderBy => 'Priority', - Order => 'DESC' }, - }, - { Name => 'Search - Unowned Tickets', - Description => '[_1] newest unowned tickets', # loc - Content => -# 'Take' #loc - { Format => "'<a href=\"__WebPath__/Ticket/Display.html?id=__id__\">__id__</a>/TITLE:#', '<a href=\"__WebPath__/Ticket/Display.html?id=__id__\">__Subject__</a>/TITLE:Subject', QueueName, ExtendedStatus, CreatedRelative, '<A HREF=\"__WebPath__/Ticket/Display.html?Action=Take&id=__id__\">__loc(Take)__</a>/TITLE: ' ", - Query => " Owner = 'Nobody' AND ( Status = 'new' OR Status = 'open')", - OrderBy => 'Created', - Order => 'DESC' }, - }, - { Name => 'HomepageSettings', - Description => 'HomepageSettings', - Content => - { 'body' => # loc - [ { type => 'system', name => 'My Tickets' }, - { type => 'system', name => 'Unowned Tickets' }, - { type => 'component', name => 'QuickCreate'}, - ], - 'summary' => # loc - [ - { type => 'component', name => 'MyReminders' }, - { type => 'component', name => 'Quicksearch' }, - { type => 'component', name => 'RefreshHomepage' }, - ] - }, -} -); |