X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=bin%2Frt-drop-tables;fp=bin%2Frt-drop-tables;h=b027542b360554e9b312e3d3e15cf2f21310e4b1;hb=b07d04cabdee3bf60e1ef9c622e1e71aade7b46a;hp=0000000000000000000000000000000000000000;hpb=59e0ebbe4d3a271fe46cf5c5b664aeda888d7790;p=freeside.git

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";
+}
+