X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=bin%2Ffix-sequences;h=2ff89d3e58299b75e52abe7cb8b14cd08da337af;hp=70b6df601e03c2843d3005db6ffb8ec6fba27b87;hb=e975ed0585280f4cbb90b02f57114dedc43f58be;hpb=6dca9c84fb27d3c01d94b993c56ea66f25d94fb2 diff --git a/bin/fix-sequences b/bin/fix-sequences index 70b6df601..2ff89d3e5 100755 --- a/bin/fix-sequences +++ b/bin/fix-sequences @@ -1,5 +1,7 @@ #!/usr/bin/perl -Tw +# run dbdef-create first! + use strict; use DBI; use DBIx::DBSchema 0.21; @@ -53,7 +55,7 @@ foreach my $table ( @tables ) { my $sql = "SELECT setval( '$seq', ( SELECT max($primary_key) FROM $table ) );"; - warn $col->default. " $seq\n$sql\n"; + #warn $col->default. " $seq\n$sql\n"; $dbh->do( $sql ) or die $dbh->errstr; }