it would help to set the permissions on the lockfile right, so the kids can open...

[freeside.git] / bin / create-history-tables

diff --git a/bin/create-history-tables b/bin/create-history-tables
index 9ed641e..c610e70 100755 (executable)
--- a/bin/create-history-tables
+++ b/bin/create-history-tables
@@ -18,11 +18,12 @@ my $schema = dbdef();
 #false laziness w/fs-setup
 my @tables = scalar(@ARGV)
                ? @ARGV
-               : grep { ! /^h_/ } $schema->tables;
+               : grep { ! /^(h|pg)_/ } $schema->tables;
 foreach my $table ( @tables ) {
+  next if grep { /^h_$table/ } $schema->tables;
   warn "creating history table for $table\n";
   my $tableobj = $schema->table($table)
-    or die "unknown talble $table (did you run dbdef-create?)\n";
+    or die "unknown table $table (did you run dbdef-create?)\n";
   my $h_tableobj = DBIx::DBSchema::Table->new( {
     name        => "h_$table",
     primary_key => 'historynum',