summaryrefslogtreecommitdiff
path: root/bin/sequences.reset
diff options
context:
space:
mode:
authorcvs2git <cvs2git>2010-12-27 00:04:45 +0000
committercvs2git <cvs2git>2010-12-27 00:04:45 +0000
commitc82d349f864e6bd9f96fd1156903bc1f7193a203 (patch)
treee117a87533656110b6acd56fc0ca64289892a9f5 /bin/sequences.reset
parent74e058c8a010ef6feb539248a550d0bb169c1e94 (diff)
This commit was manufactured by cvs2svn to create tag 'TORRUS_1_0_9'.TORRUS_1_0_9
Diffstat (limited to 'bin/sequences.reset')
-rw-r--r--bin/sequences.reset32
1 files changed, 0 insertions, 32 deletions
diff --git a/bin/sequences.reset b/bin/sequences.reset
deleted file mode 100644
index 2dc1d3bb2..000000000
--- a/bin/sequences.reset
+++ /dev/null
@@ -1,32 +0,0 @@
-#!/usr/bin/perl
-
-use FS::UID qw(adminsuidsetup);
-use FS::Record qw(dbdef dbh);
-
-my $user = shift;
-adminsuidsetup $user or die;
-
-foreach my $table ( dbdef->tables ) {
- my $primary_key = dbdef->table($table)->primary_key;
- next unless $primary_key;
- #my $local = dbdef->table($table)->column($primary_key)->local;
- ##next unless $default =~ /nextval/;
- #print "$local\n";
-
- my $statement = "select setval('${table}_${primary_key}_seq', ( select max($primary_key) from $table ) )";
-
- print "$statement;\n";
- next;
-
- my $sth = dbh->prepare($statement) or do {
- warn dbh->errstr. " preparing $statement\n";
- next;
- };
- $sth->execute or do {
- warn dbh->errstr. " executing $statement\n";
- dbh->commit;
- next;
- }
-
-}
-