-- MySQL dump 10.13 Distrib 5.1.48, for Win32 (ia32) -- -- Host: localhost Database: atmail -- ------------------------------------------------------ -- Server version 5.1.48-community /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `abook_a` -- DROP TABLE IF EXISTS `abook_a`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_a` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_a` -- LOCK TABLES `abook_a` WRITE; /*!40000 ALTER TABLE `abook_a` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_a` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_b` -- DROP TABLE IF EXISTS `abook_b`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_b` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`), KEY `UserEmail_2` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_b` -- LOCK TABLES `abook_b` WRITE; /*!40000 ALTER TABLE `abook_b` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_b` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_c` -- DROP TABLE IF EXISTS `abook_c`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_c` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_c` -- LOCK TABLES `abook_c` WRITE; /*!40000 ALTER TABLE `abook_c` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_c` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_d` -- DROP TABLE IF EXISTS `abook_d`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_d` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_d` -- LOCK TABLES `abook_d` WRITE; /*!40000 ALTER TABLE `abook_d` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_d` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_e` -- DROP TABLE IF EXISTS `abook_e`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_e` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_e` -- LOCK TABLES `abook_e` WRITE; /*!40000 ALTER TABLE `abook_e` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_e` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_f` -- DROP TABLE IF EXISTS `abook_f`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_f` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_f` -- LOCK TABLES `abook_f` WRITE; /*!40000 ALTER TABLE `abook_f` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_f` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_g` -- DROP TABLE IF EXISTS `abook_g`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_g` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_g` -- LOCK TABLES `abook_g` WRITE; /*!40000 ALTER TABLE `abook_g` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_g` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_h` -- DROP TABLE IF EXISTS `abook_h`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_h` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_h` -- LOCK TABLES `abook_h` WRITE; /*!40000 ALTER TABLE `abook_h` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_h` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_i` -- DROP TABLE IF EXISTS `abook_i`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_i` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_i` -- LOCK TABLES `abook_i` WRITE; /*!40000 ALTER TABLE `abook_i` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_i` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_j` -- DROP TABLE IF EXISTS `abook_j`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_j` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_j` -- LOCK TABLES `abook_j` WRITE; /*!40000 ALTER TABLE `abook_j` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_j` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_k` -- DROP TABLE IF EXISTS `abook_k`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_k` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_k` -- LOCK TABLES `abook_k` WRITE; /*!40000 ALTER TABLE `abook_k` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_k` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_l` -- DROP TABLE IF EXISTS `abook_l`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_l` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_l` -- LOCK TABLES `abook_l` WRITE; /*!40000 ALTER TABLE `abook_l` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_l` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_m` -- DROP TABLE IF EXISTS `abook_m`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_m` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_m` -- LOCK TABLES `abook_m` WRITE; /*!40000 ALTER TABLE `abook_m` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_m` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_n` -- DROP TABLE IF EXISTS `abook_n`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_n` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_n` -- LOCK TABLES `abook_n` WRITE; /*!40000 ALTER TABLE `abook_n` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_n` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_o` -- DROP TABLE IF EXISTS `abook_o`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_o` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_o` -- LOCK TABLES `abook_o` WRITE; /*!40000 ALTER TABLE `abook_o` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_o` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_other` -- DROP TABLE IF EXISTS `abook_other`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_other` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_other` -- LOCK TABLES `abook_other` WRITE; /*!40000 ALTER TABLE `abook_other` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_other` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_p` -- DROP TABLE IF EXISTS `abook_p`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_p` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_p` -- LOCK TABLES `abook_p` WRITE; /*!40000 ALTER TABLE `abook_p` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_p` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_q` -- DROP TABLE IF EXISTS `abook_q`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_q` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_q` -- LOCK TABLES `abook_q` WRITE; /*!40000 ALTER TABLE `abook_q` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_q` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_r` -- DROP TABLE IF EXISTS `abook_r`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_r` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_r` -- LOCK TABLES `abook_r` WRITE; /*!40000 ALTER TABLE `abook_r` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_r` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_s` -- DROP TABLE IF EXISTS `abook_s`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_s` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_s` -- LOCK TABLES `abook_s` WRITE; /*!40000 ALTER TABLE `abook_s` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_s` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_shared` -- DROP TABLE IF EXISTS `abook_shared`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_shared` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_shared` -- LOCK TABLES `abook_shared` WRITE; /*!40000 ALTER TABLE `abook_shared` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_shared` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_t` -- DROP TABLE IF EXISTS `abook_t`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_t` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_t` -- LOCK TABLES `abook_t` WRITE; /*!40000 ALTER TABLE `abook_t` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_t` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_u` -- DROP TABLE IF EXISTS `abook_u`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_u` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_u` -- LOCK TABLES `abook_u` WRITE; /*!40000 ALTER TABLE `abook_u` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_u` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_v` -- DROP TABLE IF EXISTS `abook_v`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_v` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_v` -- LOCK TABLES `abook_v` WRITE; /*!40000 ALTER TABLE `abook_v` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_v` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_w` -- DROP TABLE IF EXISTS `abook_w`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_w` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_w` -- LOCK TABLES `abook_w` WRITE; /*!40000 ALTER TABLE `abook_w` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_w` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_x` -- DROP TABLE IF EXISTS `abook_x`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_x` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_x` -- LOCK TABLES `abook_x` WRITE; /*!40000 ALTER TABLE `abook_x` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_x` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_y` -- DROP TABLE IF EXISTS `abook_y`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_y` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_y` -- LOCK TABLES `abook_y` WRITE; /*!40000 ALTER TABLE `abook_y` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_y` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abook_z` -- DROP TABLE IF EXISTS `abook_z`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abook_z` ( `UserEmail` varchar(255) DEFAULT NULL, `UserEmail2` varchar(255) DEFAULT NULL, `UserEmail3` varchar(255) DEFAULT NULL, `UserEmail4` varchar(255) DEFAULT NULL, `UserEmail5` varchar(255) DEFAULT NULL, `UserFirstName` varchar(128) DEFAULT NULL, `UserMiddleName` varchar(128) DEFAULT NULL, `UserLastName` varchar(128) DEFAULT NULL, `UserTitle` varchar(128) DEFAULT NULL, `UserGender` char(1) DEFAULT NULL, `UserDOB` datetime DEFAULT NULL, `UserHomeAddress` varchar(128) DEFAULT NULL, `UserHomeCity` varchar(128) DEFAULT NULL, `UserHomeState` varchar(128) DEFAULT NULL, `UserHomeZip` varchar(128) DEFAULT NULL, `UserHomeCountry` varchar(128) DEFAULT NULL, `UserHomePhone` varchar(128) DEFAULT NULL, `UserHomeMobile` varchar(128) DEFAULT NULL, `UserHomeFax` varchar(128) DEFAULT NULL, `UserURL` varchar(128) DEFAULT NULL, `UserWorkCompany` varchar(128) DEFAULT NULL, `UserWorkTitle` varchar(128) DEFAULT NULL, `UserWorkDept` varchar(128) DEFAULT NULL, `UserWorkOffice` varchar(128) DEFAULT NULL, `UserWorkAddress` varchar(128) DEFAULT NULL, `UserWorkCity` varchar(128) DEFAULT NULL, `UserWorkState` varchar(128) DEFAULT NULL, `UserWorkZip` varchar(128) DEFAULT NULL, `UserWorkCountry` varchar(128) DEFAULT NULL, `UserWorkPhone` varchar(128) DEFAULT NULL, `UserWorkMobile` varchar(128) DEFAULT NULL, `UserWorkFax` varchar(128) DEFAULT NULL, `UserType` varchar(16) DEFAULT NULL, `UserInfo` text, `UserPgpKey` text, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `DateAdded` datetime DEFAULT NULL, `DateModified` varchar(12) DEFAULT NULL, `EntryID` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `UserEmail` (`UserEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abook_z` -- LOCK TABLES `abook_z` WRITE; /*!40000 ALTER TABLE `abook_z` DISABLE KEYS */; /*!40000 ALTER TABLE `abook_z` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_a` -- DROP TABLE IF EXISTS `abookgroup_a`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_a` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_a` -- LOCK TABLES `abookgroup_a` WRITE; /*!40000 ALTER TABLE `abookgroup_a` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_a` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_b` -- DROP TABLE IF EXISTS `abookgroup_b`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_b` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_b` -- LOCK TABLES `abookgroup_b` WRITE; /*!40000 ALTER TABLE `abookgroup_b` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_b` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_c` -- DROP TABLE IF EXISTS `abookgroup_c`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_c` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_c` -- LOCK TABLES `abookgroup_c` WRITE; /*!40000 ALTER TABLE `abookgroup_c` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_c` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_d` -- DROP TABLE IF EXISTS `abookgroup_d`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_d` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_d` -- LOCK TABLES `abookgroup_d` WRITE; /*!40000 ALTER TABLE `abookgroup_d` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_d` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_e` -- DROP TABLE IF EXISTS `abookgroup_e`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_e` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_e` -- LOCK TABLES `abookgroup_e` WRITE; /*!40000 ALTER TABLE `abookgroup_e` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_e` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_f` -- DROP TABLE IF EXISTS `abookgroup_f`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_f` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_f` -- LOCK TABLES `abookgroup_f` WRITE; /*!40000 ALTER TABLE `abookgroup_f` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_f` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_g` -- DROP TABLE IF EXISTS `abookgroup_g`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_g` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_g` -- LOCK TABLES `abookgroup_g` WRITE; /*!40000 ALTER TABLE `abookgroup_g` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_g` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_h` -- DROP TABLE IF EXISTS `abookgroup_h`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_h` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_h` -- LOCK TABLES `abookgroup_h` WRITE; /*!40000 ALTER TABLE `abookgroup_h` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_h` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_i` -- DROP TABLE IF EXISTS `abookgroup_i`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_i` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_i` -- LOCK TABLES `abookgroup_i` WRITE; /*!40000 ALTER TABLE `abookgroup_i` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_i` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_j` -- DROP TABLE IF EXISTS `abookgroup_j`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_j` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_j` -- LOCK TABLES `abookgroup_j` WRITE; /*!40000 ALTER TABLE `abookgroup_j` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_j` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_k` -- DROP TABLE IF EXISTS `abookgroup_k`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_k` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_k` -- LOCK TABLES `abookgroup_k` WRITE; /*!40000 ALTER TABLE `abookgroup_k` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_k` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_l` -- DROP TABLE IF EXISTS `abookgroup_l`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_l` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_l` -- LOCK TABLES `abookgroup_l` WRITE; /*!40000 ALTER TABLE `abookgroup_l` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_l` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_m` -- DROP TABLE IF EXISTS `abookgroup_m`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_m` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_m` -- LOCK TABLES `abookgroup_m` WRITE; /*!40000 ALTER TABLE `abookgroup_m` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_m` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_n` -- DROP TABLE IF EXISTS `abookgroup_n`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_n` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_n` -- LOCK TABLES `abookgroup_n` WRITE; /*!40000 ALTER TABLE `abookgroup_n` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_n` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_o` -- DROP TABLE IF EXISTS `abookgroup_o`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_o` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_o` -- LOCK TABLES `abookgroup_o` WRITE; /*!40000 ALTER TABLE `abookgroup_o` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_o` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_other` -- DROP TABLE IF EXISTS `abookgroup_other`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_other` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_other` -- LOCK TABLES `abookgroup_other` WRITE; /*!40000 ALTER TABLE `abookgroup_other` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_other` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_p` -- DROP TABLE IF EXISTS `abookgroup_p`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_p` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_p` -- LOCK TABLES `abookgroup_p` WRITE; /*!40000 ALTER TABLE `abookgroup_p` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_p` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_q` -- DROP TABLE IF EXISTS `abookgroup_q`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_q` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_q` -- LOCK TABLES `abookgroup_q` WRITE; /*!40000 ALTER TABLE `abookgroup_q` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_q` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_r` -- DROP TABLE IF EXISTS `abookgroup_r`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_r` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_r` -- LOCK TABLES `abookgroup_r` WRITE; /*!40000 ALTER TABLE `abookgroup_r` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_r` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_s` -- DROP TABLE IF EXISTS `abookgroup_s`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_s` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_s` -- LOCK TABLES `abookgroup_s` WRITE; /*!40000 ALTER TABLE `abookgroup_s` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_s` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_shared` -- DROP TABLE IF EXISTS `abookgroup_shared`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_shared` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) NOT NULL DEFAULT '', `id` smallint(6) NOT NULL AUTO_INCREMENT, `Domain` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_shared` -- LOCK TABLES `abookgroup_shared` WRITE; /*!40000 ALTER TABLE `abookgroup_shared` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_shared` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_t` -- DROP TABLE IF EXISTS `abookgroup_t`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_t` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_t` -- LOCK TABLES `abookgroup_t` WRITE; /*!40000 ALTER TABLE `abookgroup_t` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_t` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_u` -- DROP TABLE IF EXISTS `abookgroup_u`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_u` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_u` -- LOCK TABLES `abookgroup_u` WRITE; /*!40000 ALTER TABLE `abookgroup_u` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_u` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_v` -- DROP TABLE IF EXISTS `abookgroup_v`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_v` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_v` -- LOCK TABLES `abookgroup_v` WRITE; /*!40000 ALTER TABLE `abookgroup_v` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_v` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_w` -- DROP TABLE IF EXISTS `abookgroup_w`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_w` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_w` -- LOCK TABLES `abookgroup_w` WRITE; /*!40000 ALTER TABLE `abookgroup_w` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_w` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_x` -- DROP TABLE IF EXISTS `abookgroup_x`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_x` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_x` -- LOCK TABLES `abookgroup_x` WRITE; /*!40000 ALTER TABLE `abookgroup_x` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_x` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_y` -- DROP TABLE IF EXISTS `abookgroup_y`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_y` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_y` -- LOCK TABLES `abookgroup_y` WRITE; /*!40000 ALTER TABLE `abookgroup_y` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_y` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookgroup_z` -- DROP TABLE IF EXISTS `abookgroup_z`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookgroup_z` ( `GroupName` varchar(32) DEFAULT NULL, `GroupEmail` varchar(64) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` mediumint(12) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookgroup_z` -- LOCK TABLES `abookgroup_z` WRITE; /*!40000 ALTER TABLE `abookgroup_z` DISABLE KEYS */; /*!40000 ALTER TABLE `abookgroup_z` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `abookpermissions` -- DROP TABLE IF EXISTS `abookpermissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abookpermissions` ( `AbookID` mediumint(8) unsigned DEFAULT NULL, `Account` varchar(96) NOT NULL DEFAULT '', `Permissions` smallint(1) DEFAULT NULL, `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `Type` varchar(6) DEFAULT NULL, `Domain` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abookpermissions` -- LOCK TABLES `abookpermissions` WRITE; /*!40000 ALTER TABLE `abookpermissions` DISABLE KEYS */; /*!40000 ALTER TABLE `abookpermissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accounts` -- DROP TABLE IF EXISTS `accounts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `accounts` ( `UserAccount` varchar(32) DEFAULT NULL, `Account` varchar(128) NOT NULL DEFAULT '', `Type` varchar(4) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `accounts` -- LOCK TABLES `accounts` WRITE; /*!40000 ALTER TABLE `accounts` DISABLE KEYS */; /*!40000 ALTER TABLE `accounts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailmessage_reply` -- DROP TABLE IF EXISTS `emailmessage_reply`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailmessage_reply` ( `EmailMessage` longtext, `id` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailmessage_reply` -- LOCK TABLES `emailmessage_reply` WRITE; /*!40000 ALTER TABLE `emailmessage_reply` DISABLE KEYS */; /*!40000 ALTER TABLE `emailmessage_reply` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `filter` -- DROP TABLE IF EXISTS `filter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `filter` ( `Header` varchar(32) NOT NULL DEFAULT '', `Value` varchar(255) DEFAULT NULL, `Score` int(2) DEFAULT NULL, `Account` varchar(128) NOT NULL DEFAULT '', `Type` int(1) DEFAULT NULL, `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `Origin` varchar(8) DEFAULT NULL, `Description` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `iHeader` (`Header`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `filter` -- LOCK TABLES `filter` WRITE; /*!40000 ALTER TABLE `filter` DISABLE KEYS */; /*!40000 ALTER TABLE `filter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `log_error` -- DROP TABLE IF EXISTS `log_error`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `log_error` ( `LogMsg` varchar(255) DEFAULT NULL, `LogDate` datetime DEFAULT NULL, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(12) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `LogDate` (`LogDate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `log_error` -- LOCK TABLES `log_error` WRITE; /*!40000 ALTER TABLE `log_error` DISABLE KEYS */; /*!40000 ALTER TABLE `log_error` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `log_login` -- DROP TABLE IF EXISTS `log_login`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `log_login` ( `LogMsg` varchar(64) DEFAULT NULL, `LogDate` datetime DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, `id` bigint(12) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `LogDate` (`LogDate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `log_login` -- LOCK TABLES `log_login` WRITE; /*!40000 ALTER TABLE `log_login` DISABLE KEYS */; /*!40000 ALTER TABLE `log_login` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `log_recvmail` -- DROP TABLE IF EXISTS `log_recvmail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `log_recvmail` ( `LogMsg` varchar(64) DEFAULT NULL, `LogDate` datetime DEFAULT NULL, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(12) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `LogDate` (`LogDate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `log_recvmail` -- LOCK TABLES `log_recvmail` WRITE; /*!40000 ALTER TABLE `log_recvmail` DISABLE KEYS */; /*!40000 ALTER TABLE `log_recvmail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `log_sendmail` -- DROP TABLE IF EXISTS `log_sendmail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `log_sendmail` ( `LogMsg` varchar(64) DEFAULT NULL, `LogDate` datetime DEFAULT NULL, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(12) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `LogDate` (`LogDate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `log_sendmail` -- LOCK TABLES `log_sendmail` WRITE; /*!40000 ALTER TABLE `log_sendmail` DISABLE KEYS */; /*!40000 ALTER TABLE `log_sendmail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `log_sms` -- DROP TABLE IF EXISTS `log_sms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `log_sms` ( `LogMsg` varchar(255) DEFAULT NULL, `LogDate` datetime DEFAULT NULL, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(12) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `LogDate` (`LogDate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `log_sms` -- LOCK TABLES `log_sms` WRITE; /*!40000 ALTER TABLE `log_sms` DISABLE KEYS */; /*!40000 ALTER TABLE `log_sms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `log_spam` -- DROP TABLE IF EXISTS `log_spam`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `log_spam` ( `LogMsg` varchar(255) DEFAULT NULL, `LogDate` datetime DEFAULT NULL, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(12) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `LogDate` (`LogDate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `log_spam` -- LOCK TABLES `log_spam` WRITE; /*!40000 ALTER TABLE `log_spam` DISABLE KEYS */; /*!40000 ALTER TABLE `log_spam` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `log_virus` -- DROP TABLE IF EXISTS `log_virus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `log_virus` ( `LogMsg` varchar(255) DEFAULT NULL, `LogDate` datetime DEFAULT NULL, `Account` varchar(128) NOT NULL DEFAULT '', `id` bigint(12) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `LogDate` (`LogDate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `log_virus` -- LOCK TABLES `log_virus` WRITE; /*!40000 ALTER TABLE `log_virus` DISABLE KEYS */; /*!40000 ALTER TABLE `log_virus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_a` -- DROP TABLE IF EXISTS `mailsort_a`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_a` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_a` -- LOCK TABLES `mailsort_a` WRITE; /*!40000 ALTER TABLE `mailsort_a` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_a` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_b` -- DROP TABLE IF EXISTS `mailsort_b`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_b` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_b` -- LOCK TABLES `mailsort_b` WRITE; /*!40000 ALTER TABLE `mailsort_b` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_b` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_c` -- DROP TABLE IF EXISTS `mailsort_c`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_c` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_c` -- LOCK TABLES `mailsort_c` WRITE; /*!40000 ALTER TABLE `mailsort_c` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_c` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_d` -- DROP TABLE IF EXISTS `mailsort_d`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_d` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_d` -- LOCK TABLES `mailsort_d` WRITE; /*!40000 ALTER TABLE `mailsort_d` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_d` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_e` -- DROP TABLE IF EXISTS `mailsort_e`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_e` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_e` -- LOCK TABLES `mailsort_e` WRITE; /*!40000 ALTER TABLE `mailsort_e` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_e` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_f` -- DROP TABLE IF EXISTS `mailsort_f`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_f` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_f` -- LOCK TABLES `mailsort_f` WRITE; /*!40000 ALTER TABLE `mailsort_f` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_f` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_g` -- DROP TABLE IF EXISTS `mailsort_g`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_g` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_g` -- LOCK TABLES `mailsort_g` WRITE; /*!40000 ALTER TABLE `mailsort_g` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_g` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_h` -- DROP TABLE IF EXISTS `mailsort_h`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_h` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_h` -- LOCK TABLES `mailsort_h` WRITE; /*!40000 ALTER TABLE `mailsort_h` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_h` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_i` -- DROP TABLE IF EXISTS `mailsort_i`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_i` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_i` -- LOCK TABLES `mailsort_i` WRITE; /*!40000 ALTER TABLE `mailsort_i` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_i` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_j` -- DROP TABLE IF EXISTS `mailsort_j`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_j` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_j` -- LOCK TABLES `mailsort_j` WRITE; /*!40000 ALTER TABLE `mailsort_j` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_j` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_k` -- DROP TABLE IF EXISTS `mailsort_k`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_k` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_k` -- LOCK TABLES `mailsort_k` WRITE; /*!40000 ALTER TABLE `mailsort_k` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_k` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_l` -- DROP TABLE IF EXISTS `mailsort_l`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_l` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_l` -- LOCK TABLES `mailsort_l` WRITE; /*!40000 ALTER TABLE `mailsort_l` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_l` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_m` -- DROP TABLE IF EXISTS `mailsort_m`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_m` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_m` -- LOCK TABLES `mailsort_m` WRITE; /*!40000 ALTER TABLE `mailsort_m` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_m` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_n` -- DROP TABLE IF EXISTS `mailsort_n`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_n` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_n` -- LOCK TABLES `mailsort_n` WRITE; /*!40000 ALTER TABLE `mailsort_n` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_n` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_o` -- DROP TABLE IF EXISTS `mailsort_o`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_o` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_o` -- LOCK TABLES `mailsort_o` WRITE; /*!40000 ALTER TABLE `mailsort_o` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_o` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_other` -- DROP TABLE IF EXISTS `mailsort_other`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_other` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_other` -- LOCK TABLES `mailsort_other` WRITE; /*!40000 ALTER TABLE `mailsort_other` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_other` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_p` -- DROP TABLE IF EXISTS `mailsort_p`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_p` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_p` -- LOCK TABLES `mailsort_p` WRITE; /*!40000 ALTER TABLE `mailsort_p` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_p` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_q` -- DROP TABLE IF EXISTS `mailsort_q`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_q` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_q` -- LOCK TABLES `mailsort_q` WRITE; /*!40000 ALTER TABLE `mailsort_q` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_q` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_r` -- DROP TABLE IF EXISTS `mailsort_r`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_r` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_r` -- LOCK TABLES `mailsort_r` WRITE; /*!40000 ALTER TABLE `mailsort_r` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_r` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_s` -- DROP TABLE IF EXISTS `mailsort_s`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_s` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_s` -- LOCK TABLES `mailsort_s` WRITE; /*!40000 ALTER TABLE `mailsort_s` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_s` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_t` -- DROP TABLE IF EXISTS `mailsort_t`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_t` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_t` -- LOCK TABLES `mailsort_t` WRITE; /*!40000 ALTER TABLE `mailsort_t` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_t` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_u` -- DROP TABLE IF EXISTS `mailsort_u`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_u` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_u` -- LOCK TABLES `mailsort_u` WRITE; /*!40000 ALTER TABLE `mailsort_u` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_u` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_v` -- DROP TABLE IF EXISTS `mailsort_v`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_v` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_v` -- LOCK TABLES `mailsort_v` WRITE; /*!40000 ALTER TABLE `mailsort_v` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_v` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_w` -- DROP TABLE IF EXISTS `mailsort_w`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_w` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_w` -- LOCK TABLES `mailsort_w` WRITE; /*!40000 ALTER TABLE `mailsort_w` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_w` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_x` -- DROP TABLE IF EXISTS `mailsort_x`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_x` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_x` -- LOCK TABLES `mailsort_x` WRITE; /*!40000 ALTER TABLE `mailsort_x` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_x` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_y` -- DROP TABLE IF EXISTS `mailsort_y`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_y` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_y` -- LOCK TABLES `mailsort_y` WRITE; /*!40000 ALTER TABLE `mailsort_y` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_y` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailsort_z` -- DROP TABLE IF EXISTS `mailsort_z`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailsort_z` ( `EmailAddress` varchar(64) DEFAULT NULL, `EmailSubject` varchar(64) DEFAULT NULL, `EmailFolder` varchar(32) DEFAULT NULL, `Account` varchar(128) DEFAULT NULL, KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailsort_z` -- LOCK TABLES `mailsort_z` WRITE; /*!40000 ALTER TABLE `mailsort_z` DISABLE KEYS */; /*!40000 ALTER TABLE `mailsort_z` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailthreads` -- DROP TABLE IF EXISTS `mailthreads`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailthreads` ( `MessageID` varchar(128) DEFAULT NULL, `ThreadID` varchar(128) DEFAULT NULL, `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `Account` varchar(128) DEFAULT NULL, `ParentID` mediumint(8) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `MessageID` (`MessageID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mailthreads` -- LOCK TABLES `mailthreads` WRITE; /*!40000 ALTER TABLE `mailthreads` DISABLE KEYS */; /*!40000 ALTER TABLE `mailthreads` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `spellcheck` -- DROP TABLE IF EXISTS `spellcheck`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spellcheck` ( `Account` varchar(128) NOT NULL DEFAULT '', `Word` varchar(40) DEFAULT NULL, `SUnique` varchar(10) DEFAULT '0', `id` bigint(12) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `spellcheck` -- LOCK TABLES `spellcheck` WRITE; /*!40000 ALTER TABLE `spellcheck` DISABLE KEYS */; /*!40000 ALTER TABLE `spellcheck` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `userpermissions` -- DROP TABLE IF EXISTS `userpermissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `userpermissions` ( `Account` varchar(128) DEFAULT NULL, `DateAdded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `id` mediumint(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `userpermissions` -- LOCK TABLES `userpermissions` WRITE; /*!40000 ALTER TABLE `userpermissions` DISABLE KEYS */; /*!40000 ALTER TABLE `userpermissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `Account` varchar(128) NOT NULL DEFAULT '', `PasswordQuestion` varchar(64) DEFAULT NULL, `OtherEmail` varchar(128) DEFAULT NULL, `FirstName` varchar(96) DEFAULT NULL, `LastName` varchar(96) DEFAULT NULL, `BirthDay` smallint(2) DEFAULT NULL, `BirthMonth` smallint(2) DEFAULT NULL, `BirthYear` smallint(4) DEFAULT NULL, `Gender` char(1) DEFAULT NULL, `Industry` varchar(42) DEFAULT NULL, `Occupation` varchar(40) DEFAULT NULL, `Address` varchar(96) DEFAULT NULL, `City` varchar(96) DEFAULT NULL, `PostCode` varchar(36) DEFAULT NULL, `State` varchar(24) DEFAULT NULL, `Country` varchar(32) DEFAULT NULL, `DateModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `DateCreate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `TelHome` varchar(16) DEFAULT NULL, `FaxHome` varchar(16) DEFAULT NULL, `TelWork` varchar(16) DEFAULT NULL, `FaxWork` varchar(16) DEFAULT NULL, `TelMobile` varchar(16) DEFAULT NULL, `TelPager` varchar(16) DEFAULT NULL, `Ugroup` varchar(16) DEFAULT NULL, `UserStatus` int(1) DEFAULT NULL, `MailDir` varchar(255) DEFAULT NULL, `Forward` varchar(128) DEFAULT NULL, `AutoReply` text, `UserQuota` mediumint(8) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `iAccount` (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersession` -- DROP TABLE IF EXISTS `usersession`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersession` ( `Account` varchar(128) NOT NULL DEFAULT '', `Password` varchar(64) DEFAULT NULL, `SessionID` varchar(64) NOT NULL DEFAULT '', `LastLogin` int(10) unsigned DEFAULT NULL, `PasswordMD5` varchar(64) DEFAULT NULL, `SessionData` text, `ChangePass` int(1) DEFAULT NULL, PRIMARY KEY (`Account`), KEY `iAccount` (`SessionID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersession` -- LOCK TABLES `usersession` WRITE; /*!40000 ALTER TABLE `usersession` DISABLE KEYS */; /*!40000 ALTER TABLE `usersession` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_a` -- DROP TABLE IF EXISTS `usersettings_a`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_a` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_a` -- LOCK TABLES `usersettings_a` WRITE; /*!40000 ALTER TABLE `usersettings_a` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_a` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_b` -- DROP TABLE IF EXISTS `usersettings_b`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_b` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_b` -- LOCK TABLES `usersettings_b` WRITE; /*!40000 ALTER TABLE `usersettings_b` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_b` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_c` -- DROP TABLE IF EXISTS `usersettings_c`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_c` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_c` -- LOCK TABLES `usersettings_c` WRITE; /*!40000 ALTER TABLE `usersettings_c` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_c` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_d` -- DROP TABLE IF EXISTS `usersettings_d`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_d` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_d` -- LOCK TABLES `usersettings_d` WRITE; /*!40000 ALTER TABLE `usersettings_d` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_d` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_e` -- DROP TABLE IF EXISTS `usersettings_e`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_e` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_e` -- LOCK TABLES `usersettings_e` WRITE; /*!40000 ALTER TABLE `usersettings_e` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_e` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_f` -- DROP TABLE IF EXISTS `usersettings_f`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_f` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_f` -- LOCK TABLES `usersettings_f` WRITE; /*!40000 ALTER TABLE `usersettings_f` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_f` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_g` -- DROP TABLE IF EXISTS `usersettings_g`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_g` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_g` -- LOCK TABLES `usersettings_g` WRITE; /*!40000 ALTER TABLE `usersettings_g` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_g` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_h` -- DROP TABLE IF EXISTS `usersettings_h`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_h` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_h` -- LOCK TABLES `usersettings_h` WRITE; /*!40000 ALTER TABLE `usersettings_h` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_h` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_i` -- DROP TABLE IF EXISTS `usersettings_i`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_i` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_i` -- LOCK TABLES `usersettings_i` WRITE; /*!40000 ALTER TABLE `usersettings_i` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_i` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_j` -- DROP TABLE IF EXISTS `usersettings_j`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_j` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_j` -- LOCK TABLES `usersettings_j` WRITE; /*!40000 ALTER TABLE `usersettings_j` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_j` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_k` -- DROP TABLE IF EXISTS `usersettings_k`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_k` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_k` -- LOCK TABLES `usersettings_k` WRITE; /*!40000 ALTER TABLE `usersettings_k` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_k` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_l` -- DROP TABLE IF EXISTS `usersettings_l`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_l` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_l` -- LOCK TABLES `usersettings_l` WRITE; /*!40000 ALTER TABLE `usersettings_l` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_l` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_m` -- DROP TABLE IF EXISTS `usersettings_m`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_m` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_m` -- LOCK TABLES `usersettings_m` WRITE; /*!40000 ALTER TABLE `usersettings_m` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_m` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_n` -- DROP TABLE IF EXISTS `usersettings_n`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_n` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_n` -- LOCK TABLES `usersettings_n` WRITE; /*!40000 ALTER TABLE `usersettings_n` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_n` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_o` -- DROP TABLE IF EXISTS `usersettings_o`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_o` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_o` -- LOCK TABLES `usersettings_o` WRITE; /*!40000 ALTER TABLE `usersettings_o` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_o` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_other` -- DROP TABLE IF EXISTS `usersettings_other`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_other` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_other` -- LOCK TABLES `usersettings_other` WRITE; /*!40000 ALTER TABLE `usersettings_other` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_other` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_p` -- DROP TABLE IF EXISTS `usersettings_p`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_p` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_p` -- LOCK TABLES `usersettings_p` WRITE; /*!40000 ALTER TABLE `usersettings_p` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_p` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_q` -- DROP TABLE IF EXISTS `usersettings_q`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_q` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_q` -- LOCK TABLES `usersettings_q` WRITE; /*!40000 ALTER TABLE `usersettings_q` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_q` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_r` -- DROP TABLE IF EXISTS `usersettings_r`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_r` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_r` -- LOCK TABLES `usersettings_r` WRITE; /*!40000 ALTER TABLE `usersettings_r` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_r` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_s` -- DROP TABLE IF EXISTS `usersettings_s`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_s` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_s` -- LOCK TABLES `usersettings_s` WRITE; /*!40000 ALTER TABLE `usersettings_s` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_s` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_t` -- DROP TABLE IF EXISTS `usersettings_t`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_t` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_t` -- LOCK TABLES `usersettings_t` WRITE; /*!40000 ALTER TABLE `usersettings_t` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_t` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_u` -- DROP TABLE IF EXISTS `usersettings_u`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_u` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_u` -- LOCK TABLES `usersettings_u` WRITE; /*!40000 ALTER TABLE `usersettings_u` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_u` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_v` -- DROP TABLE IF EXISTS `usersettings_v`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_v` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_v` -- LOCK TABLES `usersettings_v` WRITE; /*!40000 ALTER TABLE `usersettings_v` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_v` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_w` -- DROP TABLE IF EXISTS `usersettings_w`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_w` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_w` -- LOCK TABLES `usersettings_w` WRITE; /*!40000 ALTER TABLE `usersettings_w` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_w` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_x` -- DROP TABLE IF EXISTS `usersettings_x`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_x` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_x` -- LOCK TABLES `usersettings_x` WRITE; /*!40000 ALTER TABLE `usersettings_x` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_x` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_y` -- DROP TABLE IF EXISTS `usersettings_y`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_y` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_y` -- LOCK TABLES `usersettings_y` WRITE; /*!40000 ALTER TABLE `usersettings_y` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_y` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usersettings_z` -- DROP TABLE IF EXISTS `usersettings_z`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usersettings_z` ( `Account` varchar(128) NOT NULL DEFAULT '', `MboxOrder` varchar(12) DEFAULT NULL, `RealName` varchar(40) DEFAULT NULL, `Refresh` smallint(5) DEFAULT NULL, `EmailHeaders` varchar(8) DEFAULT NULL, `TimeZone` varchar(32) DEFAULT NULL, `MsgNum` varchar(4) DEFAULT NULL, `EmptyTrash` smallint(1) DEFAULT NULL, `NewWindow` smallint(1) DEFAULT NULL, `HtmlEditor` smallint(1) DEFAULT NULL, `ReplyTo` varchar(255) DEFAULT NULL, `Signature` text, `FontStyle` varchar(21) DEFAULT NULL, `LeaveMsgs` smallint(1) DEFAULT NULL, `LoginType` varchar(12) DEFAULT NULL, `Advanced` smallint(1) DEFAULT NULL, `PrimaryColor` varchar(7) DEFAULT NULL, `SecondaryColor` varchar(7) DEFAULT NULL, `LinkColor` varchar(7) DEFAULT NULL, `VlinkColor` varchar(7) DEFAULT NULL, `BgColor` varchar(7) DEFAULT NULL, `TextColor` varchar(7) DEFAULT NULL, `HeaderColor` varchar(7) DEFAULT NULL, `HeadColor` varchar(7) DEFAULT NULL, `MailType` varchar(4) DEFAULT NULL, `ThirdColor` varchar(7) DEFAULT NULL, `Mode` varchar(4) DEFAULT NULL, `Service` smallint(1) DEFAULT NULL, `Language` varchar(10) DEFAULT NULL, `StartPage` char(1) DEFAULT NULL, `OnColor` varchar(7) DEFAULT NULL, `OffColor` varchar(7) DEFAULT NULL, `TextHeadColor` varchar(7) DEFAULT NULL, `SelectColor` varchar(7) DEFAULT NULL, `TopBg` varchar(24) DEFAULT NULL, `AutoTrash` tinyint(1) DEFAULT NULL, `MailServer` varchar(64) DEFAULT NULL, `MailAuth` tinyint(1) DEFAULT NULL, `PGPenable` smallint(1) DEFAULT NULL, `PGPappend` smallint(1) DEFAULT NULL, `PGPsign` smallint(1) DEFAULT NULL, `SpamTreatment` varchar(10) DEFAULT NULL, `AbookTrusted` smallint(1) DEFAULT NULL, `AntiVirus` smallint(1) DEFAULT NULL, `PassCode` varchar(64) DEFAULT NULL, `DateFormat` varchar(8) DEFAULT NULL, `TimeFormat` varchar(8) DEFAULT NULL, `AutoComplete` smallint(1) DEFAULT NULL, `EmailEncoding` varchar(16) DEFAULT NULL, `DisplayImages` smallint(1) DEFAULT NULL, `Ajax` char(1) DEFAULT NULL, `UseSSL` tinyint(1) DEFAULT '0', PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usersettings_z` -- LOCK TABLES `usersettings_z` WRITE; /*!40000 ALTER TABLE `usersettings_z` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings_z` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2017-01-26 8:03:19