You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vcl.apache.org by ar...@apache.org on 2017/03/15 18:19:14 UTC

svn commit: r1787088 - /vcl/trunk/mysql/vcl.sql

Author: arkurth
Date: Wed Mar 15 18:19:14 2017
New Revision: 1787088

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

Modified:
    vcl/trunk/mysql/vcl.sql

Modified: vcl/trunk/mysql/vcl.sql
URL: http://svn.apache.org/viewvc/vcl/trunk/mysql/vcl.sql?rev=1787088&r1=1787087&r2=1787088&view=diff
==============================================================================
--- vcl/trunk/mysql/vcl.sql (original)
+++ vcl/trunk/mysql/vcl.sql Wed Mar 15 18:19:14 2017
@@ -31,15 +31,12 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
 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;