diff options
author | cvs2git <cvs2git> | 2006-01-05 09:34:30 +0000 |
---|---|---|
committer | cvs2git <cvs2git> | 2006-01-05 09:34:30 +0000 |
commit | 0c525f3ba7b2b6730b8939b950e4d76dd16802a9 (patch) | |
tree | 9d0c5411f52238759ca3484d5ecc036dc6905414 /bin/sequences.reset | |
parent | 8f5c91d6c7a8dc85a8b6768a149b4c7b3e144c38 (diff) |
This commit was manufactured by cvs2svn to create tag 'SQL_LEDGER_2_4_4'.SQL_LEDGER_2_4_4
Diffstat (limited to 'bin/sequences.reset')
-rw-r--r-- | bin/sequences.reset | 32 |
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; - } - -} - |