From b07d04cabdee3bf60e1ef9c622e1e71aade7b46a Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Mon, 11 Jul 2005 14:15:09 +0000
Subject: adding rt-drop-tables

---
 bin/rt-drop-tables | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100755 bin/rt-drop-tables

(limited to 'bin/rt-drop-tables')

diff --git a/bin/rt-drop-tables b/bin/rt-drop-tables
new file mode 100755
index 000000000..b027542b3
--- /dev/null
+++ b/bin/rt-drop-tables
@@ -0,0 +1,29 @@
+#!/usr/bin/perl
+
+my @tables = qw(
+Attachments 
+Queues 
+Links 
+Principals 
+Groups 
+ScripConditions 
+Transactions 
+Scrips 
+ACL 
+GroupMembers 
+CachedGroupMembers 
+Users 
+Tickets 
+ScripActions 
+Templates 
+TicketCustomFieldValues 
+CustomFields 
+CustomFieldValues 
+sessions 
+);
+
+foreach my $table ( @tables ) {
+  print "drop table $table;\n";
+  print "drop sequence ${table}_id_seq;\n";
+}
+
-- 
cgit v1.2.1