X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=bin%2Ffix-sequences;h=dc4abd7513cbf7eca6c471f0fce948a95bb706d2;hp=d5349ee74b0ee6f3213489b1af751482f6c8e71a;hb=1f2021c9b76da7cc59e2a981fbac6b24312876d2;hpb=cbf32a25fcfc38632d1262ad8261e679e1c9b7c5 diff --git a/bin/fix-sequences b/bin/fix-sequences index d5349ee74..dc4abd751 100755 --- a/bin/fix-sequences +++ b/bin/fix-sequences @@ -1,8 +1,10 @@ #!/usr/bin/perl -Tw +# run dbdef-create first! + use strict; use DBI; -use DBIx::DBSchema 0.21; +use DBIx::DBSchema 0.26; use DBIx::DBSchema::Table; use DBIx::DBSchema::Column; use DBIx::DBSchema::ColGroup::Unique; @@ -51,9 +53,9 @@ foreach my $table ( @tables ) { my $sql = "SELECT setval( '$seq', - ( SELECT max($primary_key) FROM $table ) );" ); + ( 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; }