# MySQL dump 6.0
#
# Host: localhost    Database: atmailtestdb2
#--------------------------------------------------------
# Server version	3.22.24

#
# Table structure for table 'AbookGroup_a'
#
CREATE TABLE AbookGroup_a (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_b'
#
CREATE TABLE AbookGroup_b (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_c'
#
CREATE TABLE AbookGroup_c (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_d'
#
CREATE TABLE AbookGroup_d (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_e'
#
CREATE TABLE AbookGroup_e (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_f'
#
CREATE TABLE AbookGroup_f (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_g'
#
CREATE TABLE AbookGroup_g (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_h'
#
CREATE TABLE AbookGroup_h (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_i'
#
CREATE TABLE AbookGroup_i (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_j'
#
CREATE TABLE AbookGroup_j (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_k'
#
CREATE TABLE AbookGroup_k (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_l'
#
CREATE TABLE AbookGroup_l (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_m'
#
CREATE TABLE AbookGroup_m (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_n'
#
CREATE TABLE AbookGroup_n (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_o'
#
CREATE TABLE AbookGroup_o (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_other'
#
CREATE TABLE AbookGroup_other (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_p'
#
CREATE TABLE AbookGroup_p (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_q'
#
CREATE TABLE AbookGroup_q (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_r'
#
CREATE TABLE AbookGroup_r (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_s'
#
CREATE TABLE AbookGroup_s (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_t'
#
CREATE TABLE AbookGroup_t (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_u'
#
CREATE TABLE AbookGroup_u (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_v'
#
CREATE TABLE AbookGroup_v (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_w'
#
CREATE TABLE AbookGroup_w (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_x'
#
CREATE TABLE AbookGroup_x (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_y'
#
CREATE TABLE AbookGroup_y (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'AbookGroup_z'
#
CREATE TABLE AbookGroup_z (
  GroupName varchar(32),
  GroupEmail varchar(64),
  Account varchar(64) DEFAULT '' NOT NULL,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_a'
#
CREATE TABLE Abook_a (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_b'
#
CREATE TABLE Abook_b (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_c'
#
CREATE TABLE Abook_c (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_d'
#
CREATE TABLE Abook_d (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_e'
#
CREATE TABLE Abook_e (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_f'
#
CREATE TABLE Abook_f (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_g'
#
CREATE TABLE Abook_g (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_h'
#
CREATE TABLE Abook_h (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_i'
#
CREATE TABLE Abook_i (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_j'
#
CREATE TABLE Abook_j (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_k'
#
CREATE TABLE Abook_k (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_l'
#
CREATE TABLE Abook_l (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_m'
#
CREATE TABLE Abook_m (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_n'
#
CREATE TABLE Abook_n (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_o'
#
CREATE TABLE Abook_o (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_other'
#
CREATE TABLE Abook_other (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_p'
#
CREATE TABLE Abook_p (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_q'
#
CREATE TABLE Abook_q (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_r'
#
CREATE TABLE Abook_r (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_s'
#
CREATE TABLE Abook_s (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_t'
#
CREATE TABLE Abook_t (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_u'
#
CREATE TABLE Abook_u (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_v'
#
CREATE TABLE Abook_v (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_w'
#
CREATE TABLE Abook_w (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_x'
#
CREATE TABLE Abook_x (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_y'
#
CREATE TABLE Abook_y (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Abook_z'
#
CREATE TABLE Abook_z (
  UserEmail varchar(64),
  UserFullName varchar(64),
  UserAddress varchar(64),
  UserCity varchar(32),
  UserZip varchar(12),
  UserState varchar(16),
  UserCountry varchar(32),
  UserURL varchar(128),
  UserWorkPhone varchar(16),
  UserHomePhone varchar(16),
  UserFax varchar(16),
  UserType varchar(16),
  UserInfo text,
  Account varchar(64) DEFAULT '' NOT NULL,
  UserCompany varchar(32),
  KEY iAccount (Account)
);

#
# Table structure for table 'Accounts'
#
CREATE TABLE Accounts (
  UserAccount varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  Type varchar(4)
);

#
# Table structure for table 'AdminGroup'
#
CREATE TABLE AdminGroup (
  Username varchar(64) DEFAULT '' NOT NULL,
  Ugroup varchar(32),
  Domain varchar(64),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iUsername (Username)
);

#
# Table structure for table 'AdminUsers'
#
CREATE TABLE AdminUsers (
  Username varchar(64) DEFAULT '' NOT NULL,
  Password varchar(64) DEFAULT '' NOT NULL,
  UAdd tinyint(1),
  UDelete tinyint(1),
  UModify tinyint(1),
  UPurge tinyint(1),
  USearch tinyint(1),
  UList tinyint(1),
  UMigrate tinyint(1),
  ULogs tinyint(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  NumUsers mediumint(6) unsigned,
  Company varchar(64),
  Fullname varchar(64),
  DateCreate datetime,
  SessionID varchar(32),
  LastLogin int(10) unsigned,
  PRIMARY KEY (id),
  KEY iUsername (Username)
);

#
# Table structure for table 'Calander_a'
#
CREATE TABLE Calander_a (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_b'
#
CREATE TABLE Calander_b (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(10),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_c'
#
CREATE TABLE Calander_c (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_d'
#
CREATE TABLE Calander_d (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_e'
#
CREATE TABLE Calander_e (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_f'
#
CREATE TABLE Calander_f (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_g'
#
CREATE TABLE Calander_g (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_h'
#
CREATE TABLE Calander_h (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_i'
#
CREATE TABLE Calander_i (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_j'
#
CREATE TABLE Calander_j (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_k'
#
CREATE TABLE Calander_k (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_l'
#
CREATE TABLE Calander_l (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_m'
#
CREATE TABLE Calander_m (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_n'
#
CREATE TABLE Calander_n (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_o'
#
CREATE TABLE Calander_o (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_other'
#
CREATE TABLE Calander_other (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_p'
#
CREATE TABLE Calander_p (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_q'
#
CREATE TABLE Calander_q (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_r'
#
CREATE TABLE Calander_r (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_s'
#
CREATE TABLE Calander_s (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_t'
#
CREATE TABLE Calander_t (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_u'
#
CREATE TABLE Calander_u (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_v'
#
CREATE TABLE Calander_v (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_w'
#
CREATE TABLE Calander_w (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_x'
#
CREATE TABLE Calander_x (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_y'
#
CREATE TABLE Calander_y (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'Calander_z'
#
CREATE TABLE Calander_z (
  Importance smallint(1),
  UserTo varchar(32) DEFAULT '' NOT NULL,
  UserFrom varchar(32),
  Title varchar(255),
  DatePost timestamp(14),
  CalMessage text,
  Alert smallint(3),
  DateStart datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  DateEnd datetime,
  id smallint(6) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(8),
  Task smallint(1),
  Ref smallint(6),
  Parent tinyint(1),
  Permission tinyint(1),
  PRIMARY KEY (id),
  KEY iUserTo (UserTo)
);

#
# Table structure for table 'ClientBilling'
#
CREATE TABLE ClientBilling (
  Account varchar(64) DEFAULT '' NOT NULL,
  CardNumber varchar(64),
  CardName varchar(64),
  CardExpMonth varchar(4),
  CardExpYear varchar(4),
  PaymentStatus tinyint(4),
  DateSignup datetime,
  DatePaid datetime,
  Amount mediumint(8) unsigned,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Service varchar(32),
  PRIMARY KEY (id)
);

#
# Table structure for table 'ClientPayment'
#
CREATE TABLE ClientPayment (
  Account varchar(64) DEFAULT '' NOT NULL,
  Amount mediumint(8) unsigned,
  PaymentStatus tinyint(4),
  DatePaid datetime,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailDatabase_a'
#
CREATE TABLE EmailDatabase_a (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_b'
#
CREATE TABLE EmailDatabase_b (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_c'
#
CREATE TABLE EmailDatabase_c (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_d'
#
CREATE TABLE EmailDatabase_d (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_e'
#
CREATE TABLE EmailDatabase_e (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_f'
#
CREATE TABLE EmailDatabase_f (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_g'
#
CREATE TABLE EmailDatabase_g (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_h'
#
CREATE TABLE EmailDatabase_h (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_i'
#
CREATE TABLE EmailDatabase_i (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_j'
#
CREATE TABLE EmailDatabase_j (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_k'
#
CREATE TABLE EmailDatabase_k (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_l'
#
CREATE TABLE EmailDatabase_l (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_m'
#
CREATE TABLE EmailDatabase_m (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_n'
#
CREATE TABLE EmailDatabase_n (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_o'
#
CREATE TABLE EmailDatabase_o (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

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

#
# Table structure for table 'EmailDatabase_p'
#
CREATE TABLE EmailDatabase_p (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_q'
#
CREATE TABLE EmailDatabase_q (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_r'
#
CREATE TABLE EmailDatabase_r (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_s'
#
CREATE TABLE EmailDatabase_s (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_t'
#
CREATE TABLE EmailDatabase_t (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_u'
#
CREATE TABLE EmailDatabase_u (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_v'
#
CREATE TABLE EmailDatabase_v (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_w'
#
CREATE TABLE EmailDatabase_w (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_x'
#
CREATE TABLE EmailDatabase_x (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_y'
#
CREATE TABLE EmailDatabase_y (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailDatabase_z'
#
CREATE TABLE EmailDatabase_z (
  EmailSubject varchar(164),
  EmailFrom varchar(164),
  EmailTo varchar(64),
  EmailDate timestamp(12),
  EmailBox varchar(32),
  EmailFlag char(1),
  EmailAttach char(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  EmailUIDL varchar(70),
  EmailSize int(10) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'EmailMessage_Reply'
#
CREATE TABLE EmailMessage_Reply (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_a'
#
CREATE TABLE EmailMessage_a (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_b'
#
CREATE TABLE EmailMessage_b (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_c'
#
CREATE TABLE EmailMessage_c (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_d'
#
CREATE TABLE EmailMessage_d (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_e'
#
CREATE TABLE EmailMessage_e (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_f'
#
CREATE TABLE EmailMessage_f (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_g'
#
CREATE TABLE EmailMessage_g (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_h'
#
CREATE TABLE EmailMessage_h (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_i'
#
CREATE TABLE EmailMessage_i (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_j'
#
CREATE TABLE EmailMessage_j (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_k'
#
CREATE TABLE EmailMessage_k (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_l'
#
CREATE TABLE EmailMessage_l (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_m'
#
CREATE TABLE EmailMessage_m (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_n'
#
CREATE TABLE EmailMessage_n (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_o'
#
CREATE TABLE EmailMessage_o (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_other'
#
CREATE TABLE EmailMessage_other (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_p'
#
CREATE TABLE EmailMessage_p (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_q'
#
CREATE TABLE EmailMessage_q (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_r'
#
CREATE TABLE EmailMessage_r (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_s'
#
CREATE TABLE EmailMessage_s (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_t'
#
CREATE TABLE EmailMessage_t (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_u'
#
CREATE TABLE EmailMessage_u (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_v'
#
CREATE TABLE EmailMessage_v (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_w'
#
CREATE TABLE EmailMessage_w (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_x'
#
CREATE TABLE EmailMessage_x (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_y'
#
CREATE TABLE EmailMessage_y (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailMessage_z'
#
CREATE TABLE EmailMessage_z (
  EmailMessage longtext,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'EmailUIDL_a'
#
CREATE TABLE EmailUIDL_a (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_b'
#
CREATE TABLE EmailUIDL_b (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_c'
#
CREATE TABLE EmailUIDL_c (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_d'
#
CREATE TABLE EmailUIDL_d (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_e'
#
CREATE TABLE EmailUIDL_e (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_f'
#
CREATE TABLE EmailUIDL_f (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_g'
#
CREATE TABLE EmailUIDL_g (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_h'
#
CREATE TABLE EmailUIDL_h (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_i'
#
CREATE TABLE EmailUIDL_i (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_j'
#
CREATE TABLE EmailUIDL_j (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_k'
#
CREATE TABLE EmailUIDL_k (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_l'
#
CREATE TABLE EmailUIDL_l (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_m'
#
CREATE TABLE EmailUIDL_m (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_n'
#
CREATE TABLE EmailUIDL_n (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_o'
#
CREATE TABLE EmailUIDL_o (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_other'
#
CREATE TABLE EmailUIDL_other (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_p'
#
CREATE TABLE EmailUIDL_p (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_q'
#
CREATE TABLE EmailUIDL_q (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_r'
#
CREATE TABLE EmailUIDL_r (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_s'
#
CREATE TABLE EmailUIDL_s (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_t'
#
CREATE TABLE EmailUIDL_t (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_u'
#
CREATE TABLE EmailUIDL_u (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_v'
#
CREATE TABLE EmailUIDL_v (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_w'
#
CREATE TABLE EmailUIDL_w (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_x'
#
CREATE TABLE EmailUIDL_x (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_y'
#
CREATE TABLE EmailUIDL_y (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'EmailUIDL_z'
#
CREATE TABLE EmailUIDL_z (
  EmailUIDL varchar(70) DEFAULT '' NOT NULL,
  EmailType char(1),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iEmailUIDL (EmailUIDL)
);

#
# Table structure for table 'Filter'
#
CREATE TABLE Filter (
  Header varchar(32) DEFAULT '' NOT NULL,
  Value varchar(255),
  Score int(2),
  Account varchar(64) DEFAULT '' NOT NULL,
  Type int(1),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  Origin varchar(8),
  Description varchar(255),
  PRIMARY KEY (id),
  KEY iAccount (Account),
  KEY iHeader (Header)
);

#
# Table structure for table 'Folders'
#
CREATE TABLE Folders (
  id mediumint(6) unsigned DEFAULT '0' NOT NULL auto_increment,
  Account varchar(64) DEFAULT '' NOT NULL,
  FolderName varchar(64) DEFAULT '' NOT NULL,
  FolderSize smallint(6) unsigned,
  FolderMsgs smallint(5) unsigned,
  FlagSeen tinyint(1) DEFAULT '0' NOT NULL,
  FlagAnswered tinyint(1) DEFAULT '0' NOT NULL,
  FlagDeleted tinyint(1) DEFAULT '0' NOT NULL,
  FlagFlagged tinyint(1) DEFAULT '0' NOT NULL,
  FlagRecent tinyint(1) DEFAULT '0' NOT NULL,
  FlagDraft tinyint(1) DEFAULT '0' NOT NULL,
  FlagInferiors tinyint(1) DEFAULT '0' NOT NULL,
  FlagSelect tinyint(1) DEFAULT '0' NOT NULL,
  Permission tinyint(1) DEFAULT '1',
  Subscribe tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'Log_Error'
#
CREATE TABLE Log_Error (
  LogMsg varchar(255),
  LogDate timestamp(12),
  Account varchar(64) DEFAULT '' NOT NULL,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'Log_Login'
#
CREATE TABLE Log_Login (
  LogMsg varchar(64),
  LogDate timestamp(12),
  Account varchar(64) DEFAULT '' NOT NULL,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'Log_RecvMail'
#
CREATE TABLE Log_RecvMail (
  LogMsg varchar(64),
  LogDate timestamp(12),
  Account varchar(64) DEFAULT '' NOT NULL,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'Log_SMS'
#
CREATE TABLE Log_SMS (
  LogMsg varchar(255),
  LogDate timestamp(12),
  Account varchar(128) DEFAULT '' NOT NULL,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'Log_SendMail'
#
CREATE TABLE Log_SendMail (
  LogMsg varchar(64),
  LogDate timestamp(12),
  Account varchar(64) DEFAULT '' NOT NULL,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'Log_Virus'
#
CREATE TABLE Log_Virus (
  LogMsg varchar(255),
  LogDate timestamp(12),
  Account varchar(64) DEFAULT '' NOT NULL,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_a'
#
CREATE TABLE MailSort_a (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_b'
#
CREATE TABLE MailSort_b (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_c'
#
CREATE TABLE MailSort_c (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_d'
#
CREATE TABLE MailSort_d (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_e'
#
CREATE TABLE MailSort_e (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_f'
#
CREATE TABLE MailSort_f (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_g'
#
CREATE TABLE MailSort_g (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_h'
#
CREATE TABLE MailSort_h (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_i'
#
CREATE TABLE MailSort_i (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_j'
#
CREATE TABLE MailSort_j (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_k'
#
CREATE TABLE MailSort_k (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_l'
#
CREATE TABLE MailSort_l (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_m'
#
CREATE TABLE MailSort_m (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_n'
#
CREATE TABLE MailSort_n (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_o'
#
CREATE TABLE MailSort_o (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_other'
#
CREATE TABLE MailSort_other (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_p'
#
CREATE TABLE MailSort_p (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_q'
#
CREATE TABLE MailSort_q (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_r'
#
CREATE TABLE MailSort_r (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_s'
#
CREATE TABLE MailSort_s (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_t'
#
CREATE TABLE MailSort_t (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_u'
#
CREATE TABLE MailSort_u (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_v'
#
CREATE TABLE MailSort_v (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_w'
#
CREATE TABLE MailSort_w (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_x'
#
CREATE TABLE MailSort_x (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_y'
#
CREATE TABLE MailSort_y (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'MailSort_z'
#
CREATE TABLE MailSort_z (
  EmailAddress varchar(64),
  EmailSubject varchar(64),
  EmailFolder varchar(32),
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iAccount (Account)
);

#
# Table structure for table 'SMSCredits'
#
CREATE TABLE SMSCredits (
  Account varchar(128),
  Credit mediumint(8) unsigned DEFAULT '0' NOT NULL,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id)
);

#
# Table structure for table 'SMSfilter'
#
CREATE TABLE SMSfilter (
  Account varchar(128) DEFAULT '' NOT NULL,
  EmailSubject varchar(128),
  EmailSubjectType char(2),
  EmailFrom varchar(128),
  EmailFromType char(2),
  EmailPriority char(1),
  MobileNumber varchar(16),
  Matches mediumint(8) unsigned,
  DateCreated datetime,
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  KEY iAccount (Account),
  PRIMARY KEY (id)
);

#
# Table structure for table 'SMSsent'
#
CREATE TABLE SMSsent (
  Account varchar(128) DEFAULT '' NOT NULL,
  SMSFrom varchar(128),
  SMSTo varchar(128),
  SMSStatus varchar(8),
  SMSmessage varchar(255),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  SMSid varchar(64),
  SMSdate datetime,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'SpamDB_a'
#
CREATE TABLE SpamDB_a (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_b'
#
CREATE TABLE SpamDB_b (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_c'
#
CREATE TABLE SpamDB_c (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_d'
#
CREATE TABLE SpamDB_d (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_e'
#
CREATE TABLE SpamDB_e (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_f'
#
CREATE TABLE SpamDB_f (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_g'
#
CREATE TABLE SpamDB_g (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_h'
#
CREATE TABLE SpamDB_h (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_i'
#
CREATE TABLE SpamDB_i (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_j'
#
CREATE TABLE SpamDB_j (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_k'
#
CREATE TABLE SpamDB_k (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_l'
#
CREATE TABLE SpamDB_l (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_m'
#
CREATE TABLE SpamDB_m (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_n'
#
CREATE TABLE SpamDB_n (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_o'
#
CREATE TABLE SpamDB_o (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_other'
#
CREATE TABLE SpamDB_other (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_p'
#
CREATE TABLE SpamDB_p (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_q'
#
CREATE TABLE SpamDB_q (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_r'
#
CREATE TABLE SpamDB_r (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_s'
#
CREATE TABLE SpamDB_s (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_t'
#
CREATE TABLE SpamDB_t (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_u'
#
CREATE TABLE SpamDB_u (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_v'
#
CREATE TABLE SpamDB_v (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_w'
#
CREATE TABLE SpamDB_w (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_x'
#
CREATE TABLE SpamDB_x (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_y'
#
CREATE TABLE SpamDB_y (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpamDB_z'
#
CREATE TABLE SpamDB_z (
  SpamEmail varchar(64) DEFAULT '' NOT NULL,
  Account varchar(64) DEFAULT '' NOT NULL,
  KEY iSpamEmail (SpamEmail)
);

#
# Table structure for table 'SpellCheck'
#
CREATE TABLE SpellCheck (
  Account varchar(64) DEFAULT '' NOT NULL,
  Word varchar(40),
  SUnique varchar(10) DEFAULT '0',
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY iAccount (Account)
);

#
# Table structure for table 'UserSession'
#
CREATE TABLE UserSession (
  Account varchar(128) DEFAULT '' NOT NULL,
  Password varchar(32) DEFAULT '' NOT NULL,
  SessionID varchar(32) DEFAULT '' NOT NULL,
  LastLogin int(10) unsigned,
  PRIMARY KEY (Account),
  KEY iSessionID (SessionID)
);

#
# Table structure for table 'UserSettings_a'
#
CREATE TABLE UserSettings_a (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_b'
#
CREATE TABLE UserSettings_b (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_c'
#
CREATE TABLE UserSettings_c (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_d'
#
CREATE TABLE UserSettings_d (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_e'
#
CREATE TABLE UserSettings_e (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_f'
#
CREATE TABLE UserSettings_f (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_g'
#
CREATE TABLE UserSettings_g (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_h'
#
CREATE TABLE UserSettings_h (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_i'
#
CREATE TABLE UserSettings_i (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_j'
#
CREATE TABLE UserSettings_j (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_k'
#
CREATE TABLE UserSettings_k (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_l'
#
CREATE TABLE UserSettings_l (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_m'
#
CREATE TABLE UserSettings_m (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_n'
#
CREATE TABLE UserSettings_n (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_o'
#
CREATE TABLE UserSettings_o (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_other'
#
CREATE TABLE UserSettings_other (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_p'
#
CREATE TABLE UserSettings_p (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_q'
#
CREATE TABLE UserSettings_q (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_r'
#
CREATE TABLE UserSettings_r (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_s'
#
CREATE TABLE UserSettings_s (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_t'
#
CREATE TABLE UserSettings_t (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_u'
#
CREATE TABLE UserSettings_u (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_v'
#
CREATE TABLE UserSettings_v (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_w'
#
CREATE TABLE UserSettings_w (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_x'
#
CREATE TABLE UserSettings_x (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_y'
#
CREATE TABLE UserSettings_y (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'UserSettings_z'
#
CREATE TABLE UserSettings_z (
  Account varchar(64) DEFAULT '' NOT NULL,
  Forward varchar(255),
  MboxOrder varchar(12),
  RealName varchar(40),
  Refresh smallint(5),
  EmailHeaders varchar(8),
  TimeZone varchar(4),
  MsgNum varchar(4),
  EmptyTrash smallint(1),
  NewWindow smallint(1),
  HtmlEditor smallint(1),
  ReplyTo varchar(40),
  UserQuota mediumint(8) unsigned,
  Signature text,
  FontStyle varchar(8),
  LeaveMsgs smallint(1),
  LoginType varchar(12),
  Advanced smallint(1),
  PrimaryColor varchar(7),
  SecondaryColor varchar(7),
  LinkColor varchar(7),
  VlinkColor varchar(7),
  BgColor varchar(7),
  TextColor varchar(7),
  HeaderColor varchar(7),
  HeadColor varchar(7),
  MailType varchar(4),
  ThirdColor varchar(7),
  Mode varchar(4),
  AutoReply varchar(255),
  Service smallint(1),
  Language varchar(10),
  StartPage char(1),
  OnColor varchar(7),
  OffColor varchar(7),
  TextHeadColor varchar(7),
  SelectColor varchar(7),
  TopBg varchar(24),
  AutoTrash tinyint(1),
  MailServer varchar(64),
  MailAuth tinyint(1),
  PRIMARY KEY (Account)
);

#
# Table structure for table 'Users'
#
CREATE TABLE Users (
  Account varchar(64) DEFAULT '' NOT NULL,
  PasswordQuestion varchar(64),
  OtherEmail varchar(40),
  FirstName varchar(32),
  LastName varchar(32),
  BirthDay smallint(2),
  BirthMonth smallint(2),
  BirthYear smallint(4),
  Gender char(1),
  Industry varchar(42),
  Occupation varchar(40),
  Address varchar(32),
  City varchar(32),
  PostCode varchar(12),
  State varchar(8),
  Country varchar(32),
  DateCreate timestamp(12),
  id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  TelHome varchar(16),
  FaxHome varchar(16),
  TelWork varchar(16),
  FaxWork varchar(16),
  TelMobile varchar(16),
  TelPager varchar(16),
  Ugroup varchar(16),
  UserStatus int(1),
  PRIMARY KEY (id),
  KEY iAccount (Account)
);