CREATE DATABASE  IF NOT EXISTS `atmail` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `atmail`;
--
-- Host: 127.0.0.1    Database: atmail
-- ------------------------------------------------------


--
-- Table structure for table `ui_account`
--

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;

--
-- Dumping data for table `ui_account`
--

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);


