CREATE DATABASE IF NOT EXISTS `atmail` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `atmail`; -- MySQL dump 10.13 Distrib 5.6.13, for Win32 (x86) -- -- Host: 127.0.0.1 Database: atmail -- ------------------------------------------------------ -- Server version 5.5.16 /*!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 `ui_account` -- DROP TABLE IF EXISTS `ui_account`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ui_account` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `userId` mediumint(8) unsigned NOT NULL, `serverAddress` varchar(256) CHARACTER SET utf8 DEFAULT NULL, `replyAddress` varchar(256) CHARACTER SET utf8 DEFAULT NULL, `accountEmail` varchar(256) CHARACTER SET utf8 DEFAULT NULL, `accountName` varchar(256) CHARACTER SET utf8 DEFAULT NULL, `signature` text CHARACTER SET utf8, `realName` varchar(256) CHARACTER SET utf8 DEFAULT NULL, `protocol` varchar(10) CHARACTER SET utf8 DEFAULT 'IMAP', `password` varchar(256) CHARACTER SET utf8 DEFAULT NULL, `nickname` varchar(256) CHARACTER SET utf8 DEFAULT NULL, `capacity` int(5) NOT NULL DEFAULT '1', `primary` tinyint(1) NOT NULL DEFAULT '0', `quota` mediumint(8) NOT NULL DEFAULT '0', `port` int(5) NOT NULL DEFAULT '993', `unreadMail` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `userId` (`userId`) ) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ui_account` -- LOCK TABLES `ui_account` WRITE; /*!40000 ALTER TABLE `ui_account` DISABLE KEYS */; INSERT INTO `ui_account` VALUES (1,1,'imap.gmail.com:993','atmai1@bigvi.com','tcga00@gmail.com','Gmail','stuff','Ignatz','IMAP','Peru.995','100',1,1,20,993,33),(2,1,'imap.gmail.com:993','atmail2@bigvi.com','tcga00@gmail.com','Yahoo','stuff','Ignatz','IMAP','Peru.995','100',1,1,20,993,0),(3,1,'imap.gmail.com:993','atmail3@bigvi.com','tcga00@gmail.com','Hotmail','','','IMAP','Peru.995','',1,0,0,993,1),(4,2,'imap.gmail.com:993','atmail4@bigvi.com','tcga00@gmail.com','Yahoo','','','IMAP','Peru.995','',1,0,0,993,229),(5,2,'imap.gmail.com:993','atmail5@bigvi.com','tcga00@gmail.com','Gmail','','','IMAP','Peru.995','',1,0,0,993,339393),(6,2,'imap.gmail.com:993','atmail6@bigvi.com','tcga00@gmail.com','AOL','','','IMAP','Peru.995','',1,0,0,993,3),(7,3,'imap.gmail.com:993','atmail7@bigvi.com','tcga00@gmail.com','Gmail','','','IMAP','Peru.995','',1,0,0,993,29),(8,4,'imap.gmail.com:993','atmail8@bigvi.com','tcga00@gmail.com','Yahoo','','','IMAP','Peru.995','',1,0,0,993,12),(9,4,'imap.gmail.com:993','atmail9@bigvi.com','tcga00@gmail.com','Hotmail','','','IMAP','Peru.995','',1,0,0,993,44),(10,4,'imap.gmail.com:993','atmail10@bigvi.com','tcga00@gmail.com','Gmail','','','IMAP','Peru.995','',1,0,0,993,2),(11,4,'imap.gmail.com:993','atmail11@bigvi.com','tcga00@gmail.com','AOL','','','IMAP','Peru.995','',1,0,0,993,4),(12,0,'','','','','','','IMAP','','',1,0,0,993,0),(13,0,'','','','','','','IMAP','','',1,0,0,993,0),(14,0,'','','','','','','IMAP','','',1,0,0,993,0),(15,0,'','','','','','','IMAP','','',1,0,0,993,0),(16,0,'','','','','','','IMAP','','',1,0,0,993,0),(17,0,'','','','','','','IMAP','','',1,0,0,993,0),(18,0,'','','','','','','IMAP','','',1,0,0,993,0),(19,0,'','','','','','','IMAP','','',1,0,0,993,0),(20,0,'','','','','','','IMAP','','',1,0,0,993,0),(21,0,'','','','','','','IMAP','','',1,0,0,993,0),(22,0,'','','','','','','IMAP','','',1,0,0,993,0),(23,0,'','','','','','','IMAP','','',1,0,0,993,0),(24,0,'','','','','','','IMAP','','',1,0,0,993,0),(25,2,'','','','','','','IMAP','','',1,0,0,993,0),(26,2,'','','','','','','IMAP','','',1,0,0,993,0),(27,2,'','','','','','','IMAP','','',1,0,0,993,0),(29,0,'','','','','','','IMAP','','',1,0,0,993,0),(30,0,'','','','','','','IMAP','','',1,0,0,993,0),(31,2,'localhost','a','b','d','e','f','IMAP','g','h',1,0,0,993,900),(32,2,'localhost','','','','','','IMAP','','',1,0,0,993,0),(33,2,'localhost','','','','','','IMAP','','qwerty',1,0,0,993,0),(34,2,'localhost','','','','','','IMAP','','',1,0,0,993,0),(35,4,'localhost','','','','','','IMAP','','',1,0,0,993,0),(36,4,'localhost','','','','','','IMAP','','',1,0,0,993,0),(37,4,'localhosty','','','','','','IMAP','','',1,0,0,993,0),(38,2,'localhost','','','','','','IMAP','','',1,0,0,993,0); /*!40000 ALTER TABLE `ui_account` 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 2014-03-13 16:31:41