svn commit: r1787091 - /vcl/trunk/mysql/update-vcl.sql

[arkurth]

Author: arkurth
Date: Wed Mar 15 18:30:18 2017
New Revision: 1787091

URL: http://svn.apache.org/viewvc?rev=1787091&view=rev
Log:
VCL-867
Removed unused columns from addomain table added during development in 
update-vcl.sql:
* domainNetBIOSName
* domainControllers
* logindescription

Modified:
    vcl/trunk/mysql/update-vcl.sql

Modified: vcl/trunk/mysql/update-vcl.sql
URL: 
http://svn.apache.org/viewvc/vcl/trunk/mysql/update-vcl.sql?rev=1787091&r1=1787090&r2=1787091&view=diff
==============================================================================
--- vcl/trunk/mysql/update-vcl.sql (original)
+++ vcl/trunk/mysql/update-vcl.sql Wed Mar 15 18:30:18 2017
@@ -870,15 +870,12 @@ ALTER TABLE `computerloadlog` CHANGE `lo
 
 CREATE TABLE IF NOT EXISTS `addomain` (
   `id` tinyint(3) unsigned NOT NULL auto_increment,
-  `name` varchar(30) NOT NULL default '',
   `ownerid` mediumint(8) unsigned NOT NULL,
+  `name` varchar(30) NOT NULL default '',
   `domainDNSName` varchar(70) NOT NULL default '',
-  `domainNetBIOSName` varchar(15) default NULL,
+  `dnsServers` varchar(512) default NULL,
   `username` varchar(64) default NULL,
   `password` varchar(256) default NULL,
-  `dnsServers` varchar(512) default NULL,
-  `domainControllers` varchar(512) NOT NULL,
-  `logindescription` text,
   PRIMARY KEY (`id`),
   UNIQUE KEY `domainDNSName` (`domainDNSName`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;