backend/satellite_tools/rhn-schema-stats | 17 ++++++++++++++++- 1 file changed, 16 insertions(+), 1 deletion(-)
New commits: commit 846996f29834691f7f16e02dd1a7917c948a617b Author: Milan Zazrivec mzazrivec@redhat.com Date: Wed Oct 7 12:33:10 2009 +0200
Include constraint info in schema statistics
diff --git a/backend/satellite_tools/rhn-schema-stats b/backend/satellite_tools/rhn-schema-stats index 03c5de9..613002d 100755 --- a/backend/satellite_tools/rhn-schema-stats +++ b/backend/satellite_tools/rhn-schema-stats @@ -9,7 +9,7 @@ connect=$(spacewalk-cfg-get default_db) [ -n "$2" ] && connect=$2
sql=" -set pagesize 2000 linesize 140 +set pagesize 4000 linesize 200 set serverout on
declare @@ -23,6 +23,21 @@ begin end; /
+column constraint_name format a30 heading "CONSTRAINT NAME" +column constraint_type format a4 heading "TYPE" +column table_name format a30 heading "TABLE NAME" +column search_condition heading "SEARCH CONDITION" +column r_constraint_name format a30 heading "REFERENCED CONSTRAINT" + +select + constraint_name, constraint_type, table_name, search_condition, r_constraint_name +from + user_constraints +where + table_name not like '%BIN%' +order by + table_name, constraint_type; + column label format a30 column name format a25 column epoch format a10
spacewalk-commits@lists.fedorahosted.org