X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=bin%2Ffs-radius-add-check;h=4e4769e58db853a66bddd4c616d8c2dd86c64682;hp=35f4d32626892da1d456e73fb7225f2b956ad29b;hb=239484572a9191100993bb1e85ffe8834689feb0;hpb=dac484e8356be5b235cacebe83059b7eb6588c13 diff --git a/bin/fs-radius-add-check b/bin/fs-radius-add-check index 35f4d3262..4e4769e58 100755 --- a/bin/fs-radius-add-check +++ b/bin/fs-radius-add-check @@ -39,12 +39,21 @@ my($char_d) = 80; #default maxlength for text fields ### foreach my $attribute ( @attributes ) { + my $statement = "ALTER TABLE svc_acct ADD COLUMN rc_$attribute varchar($char_d) NULL"; my $sth = $dbh->prepare( $statement ) or warn "Error preparing $statement: ". $dbh->errstr; my $rc = $sth->execute or warn "Error executing $statement: ". $sth->errstr; + + $statement = + "ALTER TABLE h_svc_acct ADD COLUMN rc_$attribute varchar($char_d) NULL"; + $sth = $dbh->prepare( $statement ) + or warn "Error preparing $statement: ". $dbh->errstr; + $rc = $sth->execute + or warn "Error executing $statement: ". $sth->errstr; + } $dbh->commit or die $dbh->errstr;