This commit was generated by cvs2svn to compensate for changes in r6255,

which included commits to RCS files with non-trunk default branches.

2 files changed, 43 insertions, 3 deletions

diff --git a/rt/etc/drop.Oracle b/rt/etc/drop.Oracle
index 4ce5de475..475e984e1 100644
--- a/rt/etc/drop.Oracle
+++ b/rt/etc/drop.Oracle
@@ -14,7 +14,8 @@ DROP TABLE SCRIPCONDITIONS;
 DROP TABLE SCRIPS;
 DROP TABLE SESSIONS;
 DROP TABLE TEMPLATES;
-DROP TABLE TICKETCUSTOMFIELDVALUES;
+DROP TABLE OBJECTCUSTOMFIELDS;
+DROP TABLE OBJECTCUSTOMFIELDVALUES;
 DROP TABLE TICKETS;
 DROP TABLE TRANSACTIONS;
 DROP TABLE USERS;
@@ -33,7 +34,8 @@ DROP SEQUENCE SCRIPACTIONS_seq;
 DROP SEQUENCE SCRIPCONDITIONS_seq;
 DROP SEQUENCE SCRIPS_seq;
 DROP SEQUENCE TEMPLATES_seq;
-DROP SEQUENCE TICKETCUSTOMFIELDVALUES_seq;
+DROP SEQUENCE OBJECTCUSTOMFIELDVALUES_seq;
+DROP SEQUENCE OBJECTCUSTOMFIELDS_seq;
 DROP SEQUENCE TICKETS_seq;
 DROP SEQUENCE TRANSACTIONS_seq;
 DROP SEQUENCE USERS_seq;
diff --git a/rt/etc/initialdata b/rt/etc/initialdata
index 3a21ce1f6..54fa9d195 100644
--- a/rt/etc/initialdata
+++ b/rt/etc/initialdata
@@ -136,7 +136,7 @@
        Description =>
          'Create new tickets based on this scrip\'s template',             # loc
        ExecModule => 'CreateTickets', },
-    { Name        => 'Open Tickets',
+    { Name        => 'Open Tickets',                                      # loc
       Description => 'Open tickets on correspondence',                    # loc
       ExecModule  => 'AutoOpen' },
 );
@@ -585,3 +585,41 @@ 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:&nbsp;' ",
+        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' },
+	]
+    },
+}
+);