[vcl] branch develop updated: VCL-1116 - use database hostnames for ad joined computers

[jf...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

jfthomps pushed a commit to branch develop
in repository https://gitbox.apache.org/repos/asf/vcl.git


The following commit(s) were added to refs/heads/develop by this push:
     new 60a8741  VCL-1116 - use database hostnames for ad joined computers
60a8741 is described below

commit 60a87419b4d267409bede46027d5047fd41caed0
Author: Josh Thompson <jf...@ncsu.edu>
AuthorDate: Fri Jun 7 13:12:53 2019 -0400

    VCL-1116 - use database hostnames for ad joined computers
    
    update-vcl.sql: added AddColumnIfNotExists for addomain.usedbhostnames
---
 mysql/update-vcl.sql | 1 +
 1 file changed, 1 insertion(+)

diff --git a/mysql/update-vcl.sql b/mysql/update-vcl.sql
index b702db3..da77a52 100644
--- a/mysql/update-vcl.sql
+++ b/mysql/update-vcl.sql
@@ -886,6 +886,7 @@ CREATE TABLE IF NOT EXISTS `addomain` (
 
 CALL DropExistingIndices('addomain', 'domainDNSName');
 CALL AddIndexIfNotExists('addomain', 'domainDNSName');
+CALL AddColumnIfNotExists('addomain', 'usedbhostnames', "tinyint(1) unsigned NOT NULL default '0'");
 
 ALTER TABLE `addomain` CHANGE `name` `name` varchar(512) NOT NULL default '';
 ALTER TABLE `addomain` CHANGE `username` `username` varchar(80) NOT NULL default '';