From 3e994a81a8b407c0076eaf90649fbf98e71082e2 Mon Sep 17 00:00:00 2001
From: Michael Fürmann <michael@spicyweb.de>
Date: Thu, 19 Feb 2015 10:04:10 -0500
Subject: [PATCH] XMPP User and domain changes and Metronome SQL Auth scripts

---
 install/sql/incremental/upd_0081.sql |    6 +-----
 1 files changed, 1 insertions(+), 5 deletions(-)

diff --git a/install/sql/incremental/upd_0081.sql b/install/sql/incremental/upd_0081.sql
index 5acfc73..ce16a5b 100644
--- a/install/sql/incremental/upd_0081.sql
+++ b/install/sql/incremental/upd_0081.sql
@@ -23,7 +23,7 @@
   `server_id` int(11) unsigned NOT NULL default '0',
   `domain` varchar(255) NOT NULL default '',
 
-  `auth_method` ENUM( 'isp', 'plain', 'hashed' ) NOT NULL default 'hashed',
+  `management_method` ENUM( 'normal', 'maildomain' ) NOT NULL default 'normal',
   `public_registration` ENUM( 'n', 'y' ) NOT NULL default 'n',
   `registration_url` varchar(255) NOT NULL DEFAULT '',
   `registration_message` varchar(255) NOT NULL DEFAULT '',
@@ -66,12 +66,8 @@
   `sys_perm_group` varchar(5) NOT NULL default '',
   `sys_perm_other` varchar(5) NOT NULL default '',
   `server_id` int(11) unsigned NOT NULL default '0',
-  `xmpp_domain_id` int(11) unsigned NOT NULL default '0',
-  `login` varchar(255) NOT NULL default '',
   `jid` varchar(255) NOT NULL default '',
   `password` varchar(255) NOT NULL default '',
-  `is_domain_admin` enum('n','y') NOT NULL default 'n',
-  `is_muc_admin` enum('n','y') NOT NULL default 'n',
   `active` enum('n','y') NOT NULL DEFAULT 'n',
   PRIMARY KEY  (`xmppuser_id`),
   KEY `server_id` (`server_id`,`jid`),

--
Gitblit v1.9.1