-- MySQL dump 8.23
--
-- Host: localhost    Database: atmail404new
---------------------------------------------------------
-- Server version	3.23.58-log

--
-- Table structure for table `AbookGroup_a`
--

CREATE TABLE AbookGroup_a (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_b`
--

CREATE TABLE AbookGroup_b (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_c`
--

CREATE TABLE AbookGroup_c (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_d`
--

CREATE TABLE AbookGroup_d (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_e`
--

CREATE TABLE AbookGroup_e (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_f`
--

CREATE TABLE AbookGroup_f (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_g`
--

CREATE TABLE AbookGroup_g (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_h`
--

CREATE TABLE AbookGroup_h (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_i`
--

CREATE TABLE AbookGroup_i (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_j`
--

CREATE TABLE AbookGroup_j (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_k`
--

CREATE TABLE AbookGroup_k (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_l`
--

CREATE TABLE AbookGroup_l (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_m`
--

CREATE TABLE AbookGroup_m (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_n`
--

CREATE TABLE AbookGroup_n (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_o`
--

CREATE TABLE AbookGroup_o (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_other`
--

CREATE TABLE AbookGroup_other (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_p`
--

CREATE TABLE AbookGroup_p (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_q`
--

CREATE TABLE AbookGroup_q (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_r`
--

CREATE TABLE AbookGroup_r (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_s`
--

CREATE TABLE AbookGroup_s (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_shared`
--

CREATE TABLE AbookGroup_shared (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id smallint(6) NOT NULL auto_increment,
  Domain varchar(64) default NULL,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_t`
--

CREATE TABLE AbookGroup_t (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_u`
--

CREATE TABLE AbookGroup_u (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_v`
--

CREATE TABLE AbookGroup_v (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_w`
--

CREATE TABLE AbookGroup_w (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_x`
--

CREATE TABLE AbookGroup_x (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_y`
--

CREATE TABLE AbookGroup_y (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookGroup_z`
--

CREATE TABLE AbookGroup_z (
  GroupName varchar(32) default NULL,
  GroupEmail varchar(64) default NULL,
  Account varchar(128) default NULL,
  id mediumint(12) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `AbookPermissions`
--

CREATE TABLE AbookPermissions (
  AbookID mediumint(8) unsigned default NULL,
  Account varchar(96) NOT NULL default '',
  Permissions smallint(1) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  Type varchar(6) default NULL,
  Domain varchar(64) default NULL,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY AbookID (AbookID)
);

--
-- Table structure for table `Abook_a`
--

CREATE TABLE Abook_a (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_b`
--

CREATE TABLE Abook_b (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail),
  KEY UserEmail_2 (UserEmail)
);

--
-- Table structure for table `Abook_c`
--

CREATE TABLE Abook_c (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_d`
--

CREATE TABLE Abook_d (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_e`
--

CREATE TABLE Abook_e (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_f`
--

CREATE TABLE Abook_f (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_g`
--

CREATE TABLE Abook_g (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_h`
--

CREATE TABLE Abook_h (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_i`
--

CREATE TABLE Abook_i (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_j`
--

CREATE TABLE Abook_j (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_k`
--

CREATE TABLE Abook_k (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_l`
--

CREATE TABLE Abook_l (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_m`
--

CREATE TABLE Abook_m (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_n`
--

CREATE TABLE Abook_n (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_o`
--

CREATE TABLE Abook_o (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_other`
--

CREATE TABLE Abook_other (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_p`
--

CREATE TABLE Abook_p (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_q`
--

CREATE TABLE Abook_q (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_r`
--

CREATE TABLE Abook_r (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_s`
--

CREATE TABLE Abook_s (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_shared`
--

CREATE TABLE Abook_shared (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(64) NOT NULL default '',
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `Abook_t`
--

CREATE TABLE Abook_t (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_u`
--

CREATE TABLE Abook_u (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_v`
--

CREATE TABLE Abook_v (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_w`
--

CREATE TABLE Abook_w (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_x`
--

CREATE TABLE Abook_x (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_y`
--

CREATE TABLE Abook_y (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Abook_z`
--

CREATE TABLE Abook_z (
  UserEmail varchar(255) default NULL,
  UserEmail2 varchar(255) default NULL,
  UserEmail3 varchar(255) default NULL,
  UserEmail4 varchar(255) default NULL,
  UserEmail5 varchar(255) default NULL,
  UserFirstName varchar(128) default NULL,
  UserMiddleName varchar(128) default NULL,
  UserLastName varchar(128) default NULL,
  UserTitle varchar(128) default NULL,
  UserGender char(1) default NULL,
  UserDOB datetime default NULL,
  UserHomeAddress varchar(128) default NULL,
  UserHomeCity varchar(128) default NULL,
  UserHomeState varchar(128) default NULL,
  UserHomeZip varchar(128) default NULL,
  UserHomeCountry varchar(128) default NULL,
  UserHomePhone varchar(128) default NULL,
  UserHomeMobile varchar(128) default NULL,
  UserHomeFax varchar(128) default NULL,
  UserURL varchar(128) default NULL,
  UserWorkCompany varchar(128) default NULL,
  UserWorkTitle varchar(128) default NULL,
  UserWorkDept varchar(128) default NULL,
  UserWorkOffice varchar(128) default NULL,
  UserWorkAddress varchar(128) default NULL,
  UserWorkCity varchar(128) default NULL,
  UserWorkState varchar(128) default NULL,
  UserWorkZip varchar(128) default NULL,
  UserWorkCountry varchar(128) default NULL,
  UserWorkPhone varchar(128) default NULL,
  UserWorkMobile varchar(128) default NULL,
  UserWorkFax varchar(128) default NULL,
  UserType varchar(16) default NULL,
  UserInfo text,
  UserPgpKey text,
  UserSMIMEcert text,
  Account varchar(128) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  DateAdded datetime default NULL,
  DateModified varchar(12) default NULL,
  EntryID varchar(64) default NULL,
  SM_public blob,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY UserEmail (UserEmail)
);

--
-- Table structure for table `Accounts`
--

CREATE TABLE Accounts (
  UserAccount varchar(32) default NULL,
  Account varchar(128) default NULL,
  Type varchar(4) default NULL,
  MailServer varchar(64) default NULL
);

--
-- Table structure for table `AdminGroup`
--

CREATE TABLE AdminGroup (
  Username varchar(64) NOT NULL default '',
  Ugroup varchar(32) default NULL,
  Domain varchar(64) default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iUsername (Username)
);

--
-- Table structure for table `AdminUsers`
--

CREATE TABLE AdminUsers (
  Username varchar(64) NOT NULL default '',
  Password varchar(64) NOT NULL default '',
  UAdd tinyint(1) default NULL,
  UDelete tinyint(1) default NULL,
  UModify tinyint(1) default NULL,
  UPurge tinyint(1) default NULL,
  USearch tinyint(1) default NULL,
  UList tinyint(1) default NULL,
  UMigrate tinyint(1) default NULL,
  ULogs tinyint(1) default NULL,
  UAlias tinyint(1) default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  NumUsers mediumint(6) unsigned default NULL,
  Company varchar(64) default NULL,
  Fullname varchar(64) default NULL,
  DateCreate datetime default NULL,
  SessionID varchar(32) default NULL,
  LastLogin int(10) unsigned default NULL,
  NumQuota mediumint(6) unsigned default NULL,
  UBrand tinyint(1) default NULL,
  BrandDomain varchar(128) default NULL,
  UGroupAssign tinyint(1) default NULL,
  UAll tinyint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUsername (Username)
);

--
-- Table structure for table `Calander_a`
--

CREATE TABLE Calander_a (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_b`
--

CREATE TABLE Calander_b (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_c`
--

CREATE TABLE Calander_c (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_d`
--

CREATE TABLE Calander_d (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_e`
--

CREATE TABLE Calander_e (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_f`
--

CREATE TABLE Calander_f (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_g`
--

CREATE TABLE Calander_g (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_h`
--

CREATE TABLE Calander_h (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_i`
--

CREATE TABLE Calander_i (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_j`
--

CREATE TABLE Calander_j (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_k`
--

CREATE TABLE Calander_k (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_l`
--

CREATE TABLE Calander_l (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_m`
--

CREATE TABLE Calander_m (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_n`
--

CREATE TABLE Calander_n (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_o`
--

CREATE TABLE Calander_o (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_other`
--

CREATE TABLE Calander_other (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_p`
--

CREATE TABLE Calander_p (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_q`
--

CREATE TABLE Calander_q (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_r`
--

CREATE TABLE Calander_r (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_s`
--

CREATE TABLE Calander_s (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_shared`
--

CREATE TABLE Calander_shared (
  Importance smallint(1) default NULL,
  UserTo varchar(128) NOT NULL default '',
  UserFrom varchar(128) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) NOT NULL auto_increment,
  Type varchar(8) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_t`
--

CREATE TABLE Calander_t (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_u`
--

CREATE TABLE Calander_u (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_v`
--

CREATE TABLE Calander_v (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_w`
--

CREATE TABLE Calander_w (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_x`
--

CREATE TABLE Calander_x (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_y`
--

CREATE TABLE Calander_y (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `Calander_z`
--

CREATE TABLE Calander_z (
  Importance smallint(1) default NULL,
  UserTo varchar(64) default NULL,
  UserFrom varchar(64) default NULL,
  Title varchar(255) default NULL,
  DatePost timestamp(14) NOT NULL,
  CalMessage text,
  Alert smallint(3) default NULL,
  DateStart datetime NOT NULL default '0000-00-00 00:00:00',
  DateEnd datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Type varchar(16) default NULL,
  Task smallint(1) default NULL,
  Ref smallint(6) default NULL,
  Parent tinyint(1) default NULL,
  Permission tinyint(1) default NULL,
  EntryID varchar(64) default NULL,
  DateModified varchar(12) default NULL,
  Location varchar(64) default NULL,
  AllDayEvent smallint(1) default NULL,
  PRIMARY KEY  (id),
  KEY iUserTo (UserTo)
);

--
-- Table structure for table `CalendarPermissions`
--

CREATE TABLE CalendarPermissions (
  CalID mediumint(8) unsigned default NULL,
  Account varchar(128) NOT NULL default '',
  Permissions smallint(1) default NULL,
  Type varchar(6) default NULL,
  id bigint(10) unsigned NOT NULL auto_increment,
  Domain varchar(64) default NULL,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `ClientBilling`
--

CREATE TABLE ClientBilling (
  Account varchar(128) default NULL,
  CardNumber varchar(64) default NULL,
  CardName varchar(64) default NULL,
  CardExpMonth varchar(4) default NULL,
  CardExpYear varchar(4) default NULL,
  PaymentStatus tinyint(4) default NULL,
  DateSignup datetime default NULL,
  DatePaid datetime default NULL,
  Amount mediumint(8) unsigned default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Service varchar(32) default NULL,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `ClientPayment`
--

CREATE TABLE ClientPayment (
  Account varchar(128) default NULL,
  Amount mediumint(8) unsigned default NULL,
  PaymentStatus tinyint(4) default NULL,
  DatePaid datetime default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `Domains`
--

CREATE TABLE Domains (
  Hostname varchar(255) NOT NULL default '',
  Enable char(1) default NULL,
  PRIMARY KEY  (Hostname)
);

--
-- Table structure for table `EmailDatabase_a`
--

CREATE TABLE EmailDatabase_a (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_b`
--

CREATE TABLE EmailDatabase_b (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_c`
--

CREATE TABLE EmailDatabase_c (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_d`
--

CREATE TABLE EmailDatabase_d (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_e`
--

CREATE TABLE EmailDatabase_e (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_f`
--

CREATE TABLE EmailDatabase_f (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_g`
--

CREATE TABLE EmailDatabase_g (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_h`
--

CREATE TABLE EmailDatabase_h (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_i`
--

CREATE TABLE EmailDatabase_i (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_j`
--

CREATE TABLE EmailDatabase_j (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_k`
--

CREATE TABLE EmailDatabase_k (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_l`
--

CREATE TABLE EmailDatabase_l (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_m`
--

CREATE TABLE EmailDatabase_m (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_n`
--

CREATE TABLE EmailDatabase_n (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_o`
--

CREATE TABLE EmailDatabase_o (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_other`
--

CREATE TABLE EmailDatabase_other (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_p`
--

CREATE TABLE EmailDatabase_p (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_q`
--

CREATE TABLE EmailDatabase_q (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_r`
--

CREATE TABLE EmailDatabase_r (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_s`
--

CREATE TABLE EmailDatabase_s (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_t`
--

CREATE TABLE EmailDatabase_t (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_u`
--

CREATE TABLE EmailDatabase_u (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_v`
--

CREATE TABLE EmailDatabase_v (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_w`
--

CREATE TABLE EmailDatabase_w (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_x`
--

CREATE TABLE EmailDatabase_x (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_y`
--

CREATE TABLE EmailDatabase_y (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailDatabase_z`
--

CREATE TABLE EmailDatabase_z (
  EmailSubject varchar(164) default NULL,
  EmailFrom varchar(164) default NULL,
  EmailTo varchar(64) default NULL,
  EmailModified timestamp(12) NOT NULL,
  EmailDate timestamp(12) NOT NULL,
  EmailBox varchar(32) default NULL,
  EmailFlag char(1) default NULL,
  EmailAttach char(1) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  EmailUIDL varchar(70) default NULL,
  EmailSize int(10) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `EmailMessage_Reply`
--

CREATE TABLE EmailMessage_Reply (
  EmailMessage longtext,
  id mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_a`
--

CREATE TABLE EmailMessage_a (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_b`
--

CREATE TABLE EmailMessage_b (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_c`
--

CREATE TABLE EmailMessage_c (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_d`
--

CREATE TABLE EmailMessage_d (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_e`
--

CREATE TABLE EmailMessage_e (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_f`
--

CREATE TABLE EmailMessage_f (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_g`
--

CREATE TABLE EmailMessage_g (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_h`
--

CREATE TABLE EmailMessage_h (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_i`
--

CREATE TABLE EmailMessage_i (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_j`
--

CREATE TABLE EmailMessage_j (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_k`
--

CREATE TABLE EmailMessage_k (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_l`
--

CREATE TABLE EmailMessage_l (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_m`
--

CREATE TABLE EmailMessage_m (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_n`
--

CREATE TABLE EmailMessage_n (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_o`
--

CREATE TABLE EmailMessage_o (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_other`
--

CREATE TABLE EmailMessage_other (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_p`
--

CREATE TABLE EmailMessage_p (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_q`
--

CREATE TABLE EmailMessage_q (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_r`
--

CREATE TABLE EmailMessage_r (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_s`
--

CREATE TABLE EmailMessage_s (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_t`
--

CREATE TABLE EmailMessage_t (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_u`
--

CREATE TABLE EmailMessage_u (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_v`
--

CREATE TABLE EmailMessage_v (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_w`
--

CREATE TABLE EmailMessage_w (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_x`
--

CREATE TABLE EmailMessage_x (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_y`
--

CREATE TABLE EmailMessage_y (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailMessage_z`
--

CREATE TABLE EmailMessage_z (
  EmailMessage longtext,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `EmailUIDL_a`
--

CREATE TABLE EmailUIDL_a (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_b`
--

CREATE TABLE EmailUIDL_b (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_c`
--

CREATE TABLE EmailUIDL_c (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_d`
--

CREATE TABLE EmailUIDL_d (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_e`
--

CREATE TABLE EmailUIDL_e (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_f`
--

CREATE TABLE EmailUIDL_f (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_g`
--

CREATE TABLE EmailUIDL_g (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_h`
--

CREATE TABLE EmailUIDL_h (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_i`
--

CREATE TABLE EmailUIDL_i (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_j`
--

CREATE TABLE EmailUIDL_j (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_k`
--

CREATE TABLE EmailUIDL_k (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_l`
--

CREATE TABLE EmailUIDL_l (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_m`
--

CREATE TABLE EmailUIDL_m (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_n`
--

CREATE TABLE EmailUIDL_n (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_o`
--

CREATE TABLE EmailUIDL_o (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_other`
--

CREATE TABLE EmailUIDL_other (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_p`
--

CREATE TABLE EmailUIDL_p (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_q`
--

CREATE TABLE EmailUIDL_q (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_r`
--

CREATE TABLE EmailUIDL_r (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_s`
--

CREATE TABLE EmailUIDL_s (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_t`
--

CREATE TABLE EmailUIDL_t (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_u`
--

CREATE TABLE EmailUIDL_u (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_v`
--

CREATE TABLE EmailUIDL_v (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_w`
--

CREATE TABLE EmailUIDL_w (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_x`
--

CREATE TABLE EmailUIDL_x (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_y`
--

CREATE TABLE EmailUIDL_y (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `EmailUIDL_z`
--

CREATE TABLE EmailUIDL_z (
  EmailUIDL varchar(70) NOT NULL default '',
  EmailType char(1) default NULL,
  Account varchar(128) NOT NULL default '',
  KEY iEmailUIDL (EmailUIDL)
);

--
-- Table structure for table `Filter`
--

CREATE TABLE Filter (
  Header varchar(32) NOT NULL default '',
  Value varchar(255) default NULL,
  Score int(2) default NULL,
  Account varchar(128) default NULL,
  Type int(1) default NULL,
  id mediumint(8) unsigned NOT NULL auto_increment,
  Origin varchar(8) default NULL,
  Description varchar(255) default NULL,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY iHeader (Header)
);

--
-- Table structure for table `Folders`
--

CREATE TABLE Folders (
  id bigint(12) unsigned NOT NULL auto_increment,
  Account varchar(128) NOT NULL default '',
  FolderName varchar(64) NOT NULL default '',
  FolderSize smallint(6) unsigned default NULL,
  FolderMsgs smallint(5) unsigned default NULL,
  FlagSeen tinyint(1) NOT NULL default '0',
  FlagAnswered tinyint(1) NOT NULL default '0',
  FlagDeleted tinyint(1) NOT NULL default '0',
  FlagFlagged tinyint(1) NOT NULL default '0',
  FlagRecent tinyint(1) NOT NULL default '0',
  FlagDraft tinyint(1) NOT NULL default '0',
  FlagInferiors tinyint(1) NOT NULL default '0',
  FlagSelect tinyint(1) NOT NULL default '0',
  Permission tinyint(1) default '1',
  Subscribe tinyint(1) NOT NULL default '0',
  ParentID bigint(12) unsigned default NULL,
  PRIMARY KEY  (id),
  KEY iAccount (Account)
);

--
-- Table structure for table `Groups`
--

CREATE TABLE Groups (
  GroupName varchar(64) NOT NULL default '',
  GroupDescription varchar(64) default NULL,
  GroupPrice varchar(5) default NULL,
  GroupQuota mediumint(8) unsigned default NULL,
  MailForwarding int(1) default NULL,
  SMSSupport int(1) default NULL,
  POP3Support int(1) default NULL,
  IMAPSupport int(1) default NULL,
  MultiSupport int(1) default NULL,
  PersonalSpam int(1) default NULL,
  GlobalAbookRead int(1) default NULL,
  GlobalAbook int(1) default NULL,
  AV int(1) default NULL,
  SpamSupport int(1) default NULL,
  PRIMARY KEY  (GroupName)
);

--
-- Table structure for table `Log_Error`
--

CREATE TABLE Log_Error (
  LogMsg varchar(255) default NULL,
  LogDate datetime default NULL,
  Account varchar(128) NOT NULL default '',
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY LogDate (LogDate)
);

--
-- Table structure for table `Log_Login`
--

CREATE TABLE Log_Login (
  LogMsg varchar(64) default NULL,
  LogDate datetime default NULL,
  Account varchar(128) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY LogDate (LogDate)
);

--
-- Table structure for table `Log_RecvMail`
--

CREATE TABLE Log_RecvMail (
  LogMsg varchar(64) default NULL,
  LogDate datetime default NULL,
  Account varchar(128) NOT NULL default '',
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY LogDate (LogDate)
);

--
-- Table structure for table `Log_SMS`
--

CREATE TABLE Log_SMS (
  LogMsg varchar(255) default NULL,
  LogDate datetime default NULL,
  Account varchar(128) NOT NULL default '',
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY LogDate (LogDate)
);

--
-- Table structure for table `Log_SendMail`
--

CREATE TABLE Log_SendMail (
  LogMsg varchar(64) default NULL,
  LogDate datetime default NULL,
  Account varchar(128) NOT NULL default '',
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY LogDate (LogDate)
);

--
-- Table structure for table `Log_Spam`
--

CREATE TABLE Log_Spam (
  LogMsg varchar(255) default NULL,
  LogDate datetime default NULL,
  Account varchar(128) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY LogDate (LogDate)
);

--
-- Table structure for table `Log_Virus`
--

CREATE TABLE Log_Virus (
  LogMsg varchar(255) default NULL,
  LogDate datetime default NULL,
  Account varchar(128) default NULL,
  id bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY iAccount (Account),
  KEY LogDate (LogDate)
);

--
-- Table structure for table `MailAliases`
--

CREATE TABLE MailAliases (
  AliasName varchar(200) default NULL,
  AliasTo varchar(200) default NULL,
  Domain varchar(128) default NULL,
  DateCreate datetime default NULL,
  id bigint(20) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

--
-- Table structure for table `MailRelay`
--

CREATE TABLE MailRelay (
  IPaddress varchar(15) NOT NULL default '',
  DateAdded timestamp(14) NOT NULL,
  Account varchar(128) default NULL,
  PRIMARY KEY  (IPaddress),
  KEY DateAdded (DateAdded),
  KEY Account (Account)
);

--
-- Table structure for table `MailSort_a`
--

CREATE TABLE MailSort_a (
  EmailAddress varchar(64) default NULL,
  EmailSubject varchar(64) default NULL,
  EmailFolder varchar(32) default NULL,
  Account varchar(128) default NULL,
  KEY iAccount (Account)
);

--
-- Table structure for table `MailSort_b`
--

CREATE TABLE MailSort_b (
  EmailAddress varchar(64) default NULL,
  EmailSubject varchar(64) default NULL,
  EmailFolder varchar(32) default NULL,
  Account varchar(128) default NULL,
  KEY iAccount (Account)
);

--
-- Table structure for table `MailSort_c`
--

CREATE TABLE MailSort_c (
  EmailAddress varchar(64) default NULL,
  EmailSubject varchar(64) default NULL,
  EmailFolder varchar(32) default NULL,
  Account varchar(128) default NULL,
  KEY iAccount (Account)
);

--
-- Table structure for table `MailSort_d`
--

CREATE TABLE MailSort_d (
  EmailAddress varchar(64) default NULL,
  EmailSubject varchar(64) default NULL,
  EmailFolder varchar(32) default NULL,
  Account varchar(128) default NULL,
  KEY iAccount (Account)
);

--
-- Table structure for table `MailSort_e`
--

CREATE TABLE MailSort_e (
  EmailAddress varchar(64) default NULL,
  EmailSubject varchar(64) default NULL,
  EmailFolder varchar(32) default NULL,
  Account varchar(128) default NULL,
  KEY iAccount (Account)
);

--
-- Table structure for table `MailSort_f`
--

CREATE TABLE MailSort_f (
  EmailAddress varchar(64) default NULL,
  EmailSubject varchar(64) default NULL,
  EmailFolder varchar(32) default NULL,
  Account varchar(128) default NULL,
  KEY iAccount (Account)
);

--
-- Table structure for table `MailSort_g`
--

CREATE TABLE MailSort_g (
  EmailAddress varchar(64) default NULL,
  EmailSubject varchar(64) default NULL,
  EmailFolder varchar(32) default NULL,
  Account varchar(128) default NULL,
  KEY iAccount (Account)
);

--
-- Table structure for table `MailSort_h`
--

CREATE TABLE MailSort_h (
  EmailAddress varchar(64) default NULL,
  EmailSubject varchar(64) default NULL,
  EmailFolder varchar(32) default NULL,
  Account varchar(128) default NULL,
  KEY iAccount (Account)
);

--
-- Table structure for table `MailSort_i`
--

CREATE TABLE MailSort_i (
  EmailAddress varchar(64) default NULL,
  EmailSubject varchar(64) default NULL,
  EmailFolder varchar(32) default NULL,
  Account varchar(128) default NULL,
  KEY iAccount (Account)
);

--
-- Table structure for table `MailSort_j`
--

CREATE TABLE MailSort_j (
  EmailAddress varchar(64) default NULL,
  EmailSubject varchar(64) default NULL,
  EmailFolder varchar(32) default NULL,
  Account varchar(128) default NULL,
  KEY iAccount (Account)
);

--
-- Table structure for table `MailSort_k`
--

CREATE TABLE MailSort_k (
  EmailAddress varchar(64) default NULL,
  EmailSubject varchar(64) default NULL,
  EmailFolder varchar(32) default NULL,
  Account varchar(128) default NULL,
  KEY iAccount (Account)
);

--
-- Table structure for table `MailSort_l`
--

CREATE TABLE MailSort_l (
  EmailAddress varchar(64) default NULL,
  EmailSubject varchar(64) default NULL,
  EmailFolder varchar(32) default NULL,
  Account varchar(128) default NULL,
  KEY iAccount (Account)
);

--
-- Table structure for table `MailSort_m`
--

CREATE TABLE MailSort_m (