diff options
Diffstat (limited to 'bin/rt-drop-tables')
| -rwxr-xr-x | bin/rt-drop-tables | 29 | 
1 files changed, 29 insertions, 0 deletions
| 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"; +} + | 
