java/code/webapp/WEB-INF/pages/channel/erratalist.jsp | 2 -
schema/spacewalk/gendrop.sql | 24 ++++++++++++++++++
2 files changed, 25 insertions(+), 1 deletion(-)
New commits:
commit e864d17977d1c97fdd874d7dd93c2e01cd516031
Author: Justin Sherrill <jsherril(a)redhat.com>
Date: Mon Nov 2 12:59:44 2009 -0500
508771 - fixing incorrect sort on channel errata list page
diff --git a/java/code/webapp/WEB-INF/pages/channel/erratalist.jsp
b/java/code/webapp/WEB-INF/pages/channel/erratalist.jsp
index 4fb0025..d896161 100644
--- a/java/code/webapp/WEB-INF/pages/channel/erratalist.jsp
+++ b/java/code/webapp/WEB-INF/pages/channel/erratalist.jsp
@@ -75,7 +75,7 @@
bound="false"
headerkey="erratalist.jsp.updated"
styleclass="last-column"
- sortattr="updateDate"
+ sortattr="updateDateObj"
defaultsort="desc"
${current.updateDate}
commit b52323b2badf9d344a485841c1095acfe694652d
Author: Justin Sherrill <jsherril(a)redhat.com>
Date: Fri Oct 30 18:23:33 2009 -0400
adding gendrop back to master branch, it was removed during postgres merge
diff --git a/schema/spacewalk/gendrop.sql b/schema/spacewalk/gendrop.sql
new file mode 100644
index 0000000..8d96df3
--- /dev/null
+++ b/schema/spacewalk/gendrop.sql
@@ -0,0 +1,24 @@
+-- Generate all drop staements for the current schema
+--
+-- $Id$
+
+set pagesize 10000
+
+select 'whenever sqlerror exit failure' from dual
+union
+select
+ 'drop ' || lower(object_type) || ' ' || lower(object_name) ||
';' DROP_STATEMENT
+from
+ user_objects
+where
+ lower(object_type) not in ('table', 'index', 'trigger',
'lob')
+UNION
+select
+ 'drop ' || lower(object_type) || ' ' || lower(object_name) || '
cascade constraints;'
+ DROP_STATEMENT
+from
+ user_objects
+where
+ lower(object_type) = 'table'
+ and object_name not like '%$%'
+/