Changeset 772

Timestamp:

09/01/15 16:39:49 (9 years ago)

Author:

Kris Deugau

Message:

/trunk

Tweak 2.7 -> 3.0 update script to fill in the custid on routed and master blocks

File:

• trunk/cgi-bin/db-update.pl (modified) (3 diffs)

trunk/cgi-bin/db-update.pl

@@ -29 +29 @@
   # master blocks move to the allocations table
   my $getm = $dbh->prepare("SELECT cidr,ctime,mtime,rwhois FROM masterblocks");
-  my $insm = $dbh->prepare("INSERT INTO allocations (cidr,type,createstamp,modifystamp,swip) VALUES (?,'mm',?,?,?)");
+  my $insm = $dbh->prepare("INSERT INTO allocations (cidr,type,createstamp,modifystamp,swip,custid) VALUES (?,'mm',?,?,?,?)");
 
   # routed blocks move to the allocations table
   my $getr = $dbh->prepare("SELECT cidr,city FROM routed WHERE cidr <<= ?");
-  my $insr = $dbh->prepare("INSERT INTO allocations (cidr,type,city,parent_id) VALUES (?,'rm',?,?)");
+  my $insr = $dbh->prepare("INSERT INTO allocations (cidr,type,city,parent_id,custid) VALUES (?,'rm',?,?,?)");
   my $rfree = $dbh->prepare("UPDATE freeblocks SET parent_id = ?, routed='m' WHERE cidr <<= ? AND routed='y'");
 
@@ -68 +68 @@
     print "$master\t";
     # copy master to allocations table
-    $insm->execute($master, $mctime, $mmtime, $mswip);
+    $insm->execute($master, $mctime, $mmtime, $mswip, $def_custids{'mm'});
     $get_id->execute;
     my ($mid) = $get_id->fetchrow_array();
@@ -79 +79 @@
       print "  $routed\t";
       # copy routed to allocations table
-      $insr->execute($routed, $rcity, $mid);
+      $insr->execute($routed, $rcity, $mid, $def_custids{'rm'});
       $get_id->execute;
       my ($rid) = $get_id->fetchrow_array();