Added the admin column, and admin test users.

2 files changed, 31 insertions, 8 deletions

diff --git a/res/sql/Data.sql b/res/sql/Data.sql
index d913b6a8..db9e47cf 100644
--- a/res/sql/Data.sql
+++ b/res/sql/Data.sql
@@ -13,7 +13,7 @@
 -- ORDER BY:  `alertnum`
 
 /*!40000 ALTER TABLE `Alerts` DISABLE KEYS */;
-INSERT INTO `Alerts` VALUES (1,1,'alert','The US debt stands at $18,005,654,570,781.04. That is $153,723.01 for every American taxpayer.',NULL,'2011-05-06 17:57:34'),(2,2,'alert','The US debt stands at $18,005,654,570,781.04. That is $153,723.01 for every American taxpayer.',NULL,'2011-05-06 17:57:34'),(3,3,'alert','The US debt stands at $18,005,654,570,781.04. That is $153,723.01 for every American taxpayer.',NULL,'2011-05-06 17:57:34');
+INSERT INTO `Alerts` (`alertnum`, `usernum`, `type`, `message`, `acknowledged`, `created`) VALUES (1,1,'alert','The US debt stands at $18,005,654,570,781.04. That is $153,723.01 for every American taxpayer.',NULL,'2011-05-06 17:57:34'),(2,2,'alert','The US debt stands at $18,005,654,570,781.04. That is $153,723.01 for every American taxpayer.',NULL,'2011-05-06 17:57:34'),(3,3,'alert','The US debt stands at $18,005,654,570,781.04. That is $153,723.01 for every American taxpayer.',NULL,'2011-05-06 17:57:34');
 /*!40000 ALTER TABLE `Alerts` ENABLE KEYS */;
 
 --
@@ -45,7 +45,7 @@ INSERT INTO `Alerts` VALUES (1,1,'alert','The US debt stands at $18,005,654,570,
 -- ORDER BY:  `usernum`
 
 /*!40000 ALTER TABLE `Dispatch` DISABLE KEYS */;
-INSERT INTO `Dispatch` VALUES (1,1,'',0,1,0,5,1,'REJECT',1,'REJECT',1,'MARK',1,'MARK',1,1,'DELETE',1,'DELETE',0,NULL,1,33554432,33554432,256,65536,65536,0),(2,0,'',0,1,0,5,1,'REJECT',1,'REJECT',1,'MARK',1,'MARK',2,1,'DELETE',1,'DELETE',0,NULL,2,33554432,33554432,256,65536,65536,0),(3,1,'',0,1,0,5,1,'REJECT',1,'REJECT',1,'MARK',0,'MARK',3,1,'DELETE',1,'DELETE',0,NULL,3,33554432,33554432,256,65536,65536,0),(4,1,'',0,1,0,5,1,'REJECT',1,'REJECT',1,'MARK',1,'MARK',4,1,'DELETE',1,'DELETE',0,NULL,4,33554432,33554432,256,65536,65536,0);
+INSERT INTO `Dispatch` (`usernum`, `secure`, `forwarded`, `rollout`, `bounces`, `greylist`, `greytime`, `rbl`, `rblaction`, `spf`, `spfaction`, `dkim`, `dkimaction`, `spam`, `spamaction`, `spamfolder`, `virus`, `virusaction`, `phish`, `phishaction`, `filters`, `autoreply`, `inbox`, `send_size_limit`, `recv_size_limit`, `daily_send_limit`, `daily_recv_limit`, `daily_recv_limit_ip`, `class`) VALUES (1,1,'',0,1,0,5,1,'REJECT',1,'REJECT',1,'MARK',1,'MARK',1,1,'DELETE',1,'DELETE',0,NULL,1,33554432,33554432,256,65536,65536,0),(2,0,'',0,1,0,5,1,'REJECT',1,'REJECT',1,'MARK',1,'MARK',2,1,'DELETE',1,'DELETE',0,NULL,2,33554432,33554432,256,65536,65536,0),(3,1,'',0,1,0,5,1,'REJECT',1,'REJECT',1,'MARK',0,'MARK',3,1,'DELETE',1,'DELETE',0,NULL,3,33554432,33554432,256,65536,65536,0),(4,1,'',0,1,0,5,1,'REJECT',1,'REJECT',1,'MARK',1,'MARK',4,1,'DELETE',1,'DELETE',0,NULL,4,33554432,33554432,256,65536,65536,0);
 /*!40000 ALTER TABLE `Dispatch` ENABLE KEYS */;
 
 --
@@ -62,7 +62,7 @@ INSERT INTO `Dispatch` VALUES (1,1,'',0,1,0,5,1,'REJECT',1,'REJECT',1,'MARK',1,'
 -- ORDER BY:  `domnum`
 
 /*!40000 ALTER TABLE `Domains` DISABLE KEYS */;
-INSERT INTO `Domains` VALUES (1,'dark.lavabit.com',0,0,0,0,0,'2010-05-18 02:08:52','2008-03-06 14:52:16'),(2,'lavabit.com',1,1,0,1,1,'2010-05-18 02:08:55','2008-03-06 14:50:50'),(3,'mailshack.com',1,1,0,1,1,'2010-05-18 02:08:56','2008-03-06 14:50:59'),(4,'nerdshack.com',1,1,0,1,1,'2010-05-18 02:08:56','2008-03-06 14:50:55'),(33,'ronweb.net',0,0,1,1,1,'2010-05-18 02:09:03','2008-03-06 14:51:24'),(37,'squeak-seo.com',0,0,1,0,1,'2010-05-18 02:09:03','2008-03-06 14:51:34'),(40,'texasteenage.org',0,0,1,0,0,'2010-05-18 02:09:03','2009-03-05 11:50:04'),(47,'test.com',0,1,0,0,0,'2010-05-18 02:09:04','2008-11-10 10:00:32');
+INSERT INTO `Domains` (`domnum`, `domain`, `restricted`, `mailboxes`, `wildcard`, `dkim`, `spf`, `updated`, `created`) VALUES (1,'dark.lavabit.com',0,0,0,0,0,'2010-05-18 02:08:52','2008-03-06 14:52:16'),(2,'lavabit.com',1,1,0,1,1,'2010-05-18 02:08:55','2008-03-06 14:50:50'),(3,'mailshack.com',1,1,0,1,1,'2010-05-18 02:08:56','2008-03-06 14:50:59'),(4,'nerdshack.com',1,1,0,1,1,'2010-05-18 02:08:56','2008-03-06 14:50:55'),(33,'ronweb.net',0,0,1,1,1,'2010-05-18 02:09:03','2008-03-06 14:51:24'),(37,'squeak-seo.com',0,0,1,0,1,'2010-05-18 02:09:03','2008-03-06 14:51:34'),(40,'texasteenage.org',0,0,1,0,0,'2010-05-18 02:09:03','2009-03-05 11:50:04'),(47,'test.com',0,1,0,0,0,'2010-05-18 02:09:04','2008-11-10 10:00:32');
 /*!40000 ALTER TABLE `Domains` ENABLE KEYS */;
 
 --
@@ -130,7 +130,7 @@ INSERT INTO `Limits` (`plan`, `description`, `corporate`, `paid`, `secure`, `for
 -- ORDER BY:  `usernum`
 
 /*!40000 ALTER TABLE `Log` DISABLE KEYS */;
-INSERT INTO `Log` VALUES (1,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2011-05-05 14:15:59','0.0.0.0'),(2,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2011-05-05 14:16:03','0.0.0.0'),(3,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2011-05-05 14:16:09','0.0.0.0'),(4,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2011-05-05 14:15:59','127.0.0.1');
+INSERT INTO `Log` (`usernum`, `lastpop`, `lastmap`, `lastweb`, `lastchat`, `lastsent`, `lastreceived`, `popsessions`, `mapsessions`, `websessions`, `chatsessions`, `totalsent`, `totalreceived`, `totalbounces`, `created`, `created_ip`) VALUES (1,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2011-05-05 14:15:59','0.0.0.0'),(2,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2011-05-05 14:16:03','0.0.0.0'),(3,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2011-05-05 14:16:09','0.0.0.0'),(4,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2011-05-05 14:15:59','127.0.0.1');
 /*!40000 ALTER TABLE `Log` ENABLE KEYS */;
 
 --
@@ -172,7 +172,7 @@ INSERT INTO `Mailboxes` (`address`, `usernum`) VALUES ('magma@lavabit.com',1),('
 -- ORDER BY:  `usernum`
 
 /*!40000 ALTER TABLE `Profile` DISABLE KEYS */;
-INSERT INTO `Profile` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO `Profile` (`usernum`, `name`, `address_one`, `address_two`, `city`, `state`, `zip`, `country`, `profile`, `phone`, `mobile`, `fax`, `gender`, `language`, `birthdate`, `industry`, `website`, `accessible`) VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
 /*!40000 ALTER TABLE `Profile` ENABLE KEYS */;
 
 --
@@ -210,7 +210,7 @@ INSERT INTO `Profile` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NUL
 -- ORDER BY:  `usernum`
 
 /*!40000 ALTER TABLE `Users` DISABLE KEYS */;
-INSERT INTO `Users` VALUES (1,'magma',NULL, NULL,0,'42a7ead6550ee52360222a0e8783645216c3bb4ade95ab531be13cd3060dcdd085fb534e424e067bc4edfe27a87277daaad6428fee737b3adc3c55608fb23ea5',0,'STANDARD',0,0,NULL,1,1,0,0,4294967296,0,DATE_ADD(NOW(), INTERVAL 3 YEAR),'0000-00-00'),(2,'princess', NULL, NULL,0,'3a5799cbc019beebd5e779a62343a76ff949c829b792ebe2c2fae406eda57268ce200db1ada838936b0ac6804115d60e83e88189705bd3f52f1723f29ce9cfa1',0,'BASIC',0,0,NULL,1,1,0,0,4294967296,0,'0000-00-00','0000-00-00'),(3,'ladar', NULL, NULL,0,'eb5ff977cd0ef6487677b4961995088d3a86caa2e6710829a28047017406e493b6839fbdf69d2e4ee290fee1181ba1a4c105afe7c507e91e5773d71d0461adba',0,'BASIC',0,0,NULL,1,1,0,0,4294967296,0,'0000-00-00','0000-00-00'),(4,'stacie','MOgx1F13HmoSGt05L2AvYwjWVqS_NmEU1b6eaWE9EOb819su6Z2qUvxdsQyx1CCL_xlCYhh2OJhaoxN0UlUIjvZ-yz08TBaWZ7Z0B3ZNrBtTs3OOio4K7pMkDLpXxCjjS2eboU7nNxn1sdrgKLICOZSWtPIDJmAAIyr9GOPF-x4','MAtbJr6lIPOmrYuQMQaPzDq8mNRN8qp9MefYk8vyxnL3DrsuzFeSMhGL5Ew4tDTYA1hNzqroJaoGB8jWpUKAwA',0,NULL,0,'BASIC',0,0,NULL,1,1,0,0,4294967296,0,'0000-00-00','0000-00-00');
+INSERT INTO `Users` (`usernum`, `userid`, `salt`, `auth`, `bonus`, `legacy`, `tls`, `plan`, `locked`, `advertising`, `domain`, `email`, `chat`, `timezone`, `size`, `quota`, `overquota`, `plan_expiration`, `lock_expiration`) VALUES (1,'magma',NULL, NULL,0,'42a7ead6550ee52360222a0e8783645216c3bb4ade95ab531be13cd3060dcdd085fb534e424e067bc4edfe27a87277daaad6428fee737b3adc3c55608fb23ea5',0,'STANDARD',0,0,NULL,1,1,0,0,4294967296,0,DATE_ADD(NOW(), INTERVAL 3 YEAR),'0000-00-00'),(2,'princess', NULL, NULL,0,'3a5799cbc019beebd5e779a62343a76ff949c829b792ebe2c2fae406eda57268ce200db1ada838936b0ac6804115d60e83e88189705bd3f52f1723f29ce9cfa1',0,'BASIC',0,0,NULL,1,1,0,0,4294967296,0,'0000-00-00','0000-00-00'),(3,'ladar', NULL, NULL,0,'eb5ff977cd0ef6487677b4961995088d3a86caa2e6710829a28047017406e493b6839fbdf69d2e4ee290fee1181ba1a4c105afe7c507e91e5773d71d0461adba',0,'BASIC',0,0,NULL,1,1,0,0,4294967296,0,'0000-00-00','0000-00-00'),(4,'stacie','MOgx1F13HmoSGt05L2AvYwjWVqS_NmEU1b6eaWE9EOb819su6Z2qUvxdsQyx1CCL_xlCYhh2OJhaoxN0UlUIjvZ-yz08TBaWZ7Z0B3ZNrBtTs3OOio4K7pMkDLpXxCjjS2eboU7nNxn1sdrgKLICOZSWtPIDJmAAIyr9GOPF-x4','MAtbJr6lIPOmrYuQMQaPzDq8mNRN8qp9MefYk8vyxnL3DrsuzFeSMhGL5Ew4tDTYA1hNzqroJaoGB8jWpUKAwA',0,NULL,0,'BASIC',0,0,NULL,1,1,0,0,4294967296,0,'0000-00-00','0000-00-00');
 /*!40000 ALTER TABLE `Users` ENABLE KEYS */;
 
 --
@@ -232,6 +232,8 @@ INSERT INTO `Users` (`usernum`, `userid`, `salt`, `auth`, `bonus`, `legacy`, `tl
 INSERT INTO `Users` (`usernum`, `userid`, `salt`, `auth`, `bonus`, `legacy`, `tls`, `plan`, `locked`, `advertising`, `domain`, `email`, `chat`, `timezone`, `size`, `quota`, `overquota`, `plan_expiration`, `lock_expiration`) VALUES (8,'lock_abuse','SoRKkslJPq8vrux5nEf4g16hrZwv4_5IHVnC6Pj6rPBshD4Q44DAS8eyxc90P2o-seViuc7cCJ4kJ4T9VJat-t6vmZZdFyzbzOzZAb-SajH4z7gKqDB-uSO35EgEXam4jLT5IGjpP5eybKPoSt9IHUDThvAPWiOMJNAYlYRPbNg','oc7DNB5kzIpRmi91dak-_kaksAIZQc1nTGUb3cWB7JLaT8pGjXHYRwfCNJA7nNMOhMPT2nVIPh0e9VEoAqsBag',0,NULL,1,'PREMIER',4,0,NULL,1,1,0,0,5368709120,0,'2018-08-06','2018-12-04');
 INSERT INTO `Users` (`usernum`, `userid`, `salt`, `auth`, `bonus`, `legacy`, `tls`, `plan`, `locked`, `advertising`, `domain`, `email`, `chat`, `timezone`, `size`, `quota`, `overquota`, `plan_expiration`, `lock_expiration`) VALUES (9,'lock_user','xeyToHadHNNept5xy-yV5IR777gBFx4WGbiPPnbzE3iIJni65hUBhzLOohJHiwhS3kXzHiCCrZKsja036L2-6VZYpwR6f7Q-yQ8V0tQik69W5rKAfhGKS1v27pCNm8gbHkRtNOJZk0fmhpi4OqN3WDT517bUaSujGm_HBw7GFk8','O4sR-aNx1hX381WqXvWp49RiEW6Fg69Pc1eQ0-A0xeZFV05nyQ-88ap0FDxoGuZlN7ipqDivS22-3_1YP53R3A',0,NULL,1,'PREMIER',5,0,NULL,1,1,0,0,5368709120,0,'2018-08-06','2018-12-04');
 INSERT INTO `Users` (`usernum`, `userid`, `salt`, `auth`, `bonus`, `legacy`, `tls`, `plan`, `locked`, `advertising`, `domain`, `email`, `chat`, `timezone`, `size`, `quota`, `overquota`, `plan_expiration`, `lock_expiration`) VALUES (10,'lock_none','kjyZp26SQZjU8OM0xcUTWhyKUl15_stxHeqMpjeFdzMx02Fo8XIVNO5Q8Ah82XSW0XetQ4oEZTik9wyE4SMw02m5lIQGv0HyTDs66o1AjRghWySmuZFFotzJBI_jmx1d66eNNa3HjJENslZJJzmeGBn-uHjT8h_PTlFseNx7EBc','3R38D_2Nucvc7bvTKgAjxr5rV5eawSh9N4sETiqo0EqphM95pRKOFm6xdBxNgxKdfxnSHsfLsiHA1Hc1u_kgyg',0,NULL,1,'STANDARD',0,0,NULL,1,1,0,0,5368709120,0,'2018-08-06','0000-00-00');
+INSERT INTO `Users` (`usernum`, `userid`, `salt`, `auth`, `bonus`, `legacy`, `tls`, `plan`, `locked`, `advertising`, `domain`, `email`, `chat`, `timezone`, `size`, `quota`, `overquota`, `plan_expiration`, `lock_expiration`) VALUES (11,'admin','oeWwiYQqTd5_4adBPBabmn_n_ExStPMuJFXeIZAxQoGHQMAQPUgiFa-7R46MfomkU3C7OR3VzLB1vlfHagTrreodgqf9bMvrQWc7ww8vmmHWPAo8_gyDS9p5AneY0moQtRsdbAs-W-NCTYhY1FatkctrVrX0v7lWXMX35a2KRdA','qAxweeF36vF99qfwyfEEmMUCGwPhIUJs77_75nqPMEsD6N7dJBEMTD2XihlLlbF5mCSHx38bF8g_Phj4T8-3Zg',0,NULL,1,'PREMIER',0,0,NULL,1,1,0,0,21474836480,0,'2018-08-06','0000-00-00');
+INSERT INTO `Users` (`usernum`, `userid`, `salt`, `auth`, `bonus`, `legacy`, `tls`, `plan`, `locked`, `advertising`, `domain`, `email`, `chat`, `timezone`, `size`, `quota`, `overquota`, `plan_expiration`, `lock_expiration`) VALUES (12,'admin@domain.tld','s7IlTeyvFb4zrLuyxjE-Y9afM5YtKl6XG-ojPtiBC5MNQ9mlXSGzWJB3cishF2g7ScoqA13eOwV6cgDY3ImPvi17clzxQX2yuUTHrQJOtIWhihw0GIb-hcnG4c4SHbv5T0kNiI8F_tZYiTI5jrrkifVnUtgHbeG0qyWKplgrLlU','3sp0Jj9UaJCmeaya0Ecc-fG3PyhJFJ0DQYudZw7J7Iwh2ThTxbIk60Zg9gLjjTeHmogBbvL2JAEniS0Cm8twNQ',0,NULL,1,'PREMIER',0,0,NULL,1,1,0,0,21474836480,0,'2018-08-06','0000-00-00');
 
 INSERT INTO `Mailboxes` (`address`, `usernum`) VALUES ('lock_inactive@lavabit.com',5);
 INSERT INTO `Mailboxes` (`address`, `usernum`) VALUES ('lock_inactive@example.com',5);
@@ -245,6 +247,8 @@ INSERT INTO `Mailboxes` (`address`, `usernum`) VALUES ('lock_user@lavabit.com',9
 INSERT INTO `Mailboxes` (`address`, `usernum`) VALUES ('lock_user@example.com',9);
 INSERT INTO `Mailboxes` (`address`, `usernum`) VALUES ('lock_none@lavabit.com',10);
 INSERT INTO `Mailboxes` (`address`, `usernum`) VALUES ('lock_none@example.com',10);
+INSERT INTO `Mailboxes` (`address`, `usernum`) VALUES ('admin@lavabit.com',11);
+INSERT INTO `Mailboxes` (`address`, `usernum`) VALUES ('admin@domain.tld',12);
 
 INSERT INTO `Folders` (`foldernum`, `usernum`, `foldername`, `order`, `type`, `parent`) VALUES (5,5,'Inbox',0,1,0);
 INSERT INTO `Folders` (`foldernum`, `usernum`, `foldername`, `order`, `type`, `parent`) VALUES (6,6,'Inbox',0,1,0);
@@ -252,6 +256,8 @@ INSERT INTO `Folders` (`foldernum`, `usernum`, `foldername`, `order`, `type`, `p
 INSERT INTO `Folders` (`foldernum`, `usernum`, `foldername`, `order`, `type`, `parent`) VALUES (8,8,'Inbox',0,1,0);
 INSERT INTO `Folders` (`foldernum`, `usernum`, `foldername`, `order`, `type`, `parent`) VALUES (9,9,'Inbox',0,1,0);
 INSERT INTO `Folders` (`foldernum`, `usernum`, `foldername`, `order`, `type`, `parent`) VALUES (10,10,'Inbox',0,1,0);
+INSERT INTO `Folders` (`foldernum`, `usernum`, `foldername`, `order`, `type`, `parent`) VALUES (11,11,'Inbox',0,1,0);
+INSERT INTO `Folders` (`foldernum`, `usernum`, `foldername`, `order`, `type`, `parent`) VALUES (12,12,'Inbox',0,1,0);
 
 INSERT INTO `Dispatch` (`usernum`, `secure`, `forwarded`, `rollout`, `bounces`, `greylist`, `greytime`, `rbl`, `rblaction`, `spf`, `spfaction`, `dkim`, `dkimaction`, `spam`, `spamaction`, `spamfolder`, `virus`, `virusaction`, `phish`, `phishaction`, `filters`, `autoreply`, `inbox`, `send_size_limit`, `recv_size_limit`, `daily_send_limit`, `daily_recv_limit`, `daily_recv_limit_ip`, `class`) VALUES (5,1,'',0,1,0,1,0,'REJECT',0,'REJECT',0,'MARK',0,'MARK',5,1,'DELETE',1,'DELETE',0,NULL,5,67108864,67108864,128,8192,8192,0);
 INSERT INTO `Dispatch` (`usernum`, `secure`, `forwarded`, `rollout`, `bounces`, `greylist`, `greytime`, `rbl`, `rblaction`, `spf`, `spfaction`, `dkim`, `dkimaction`, `spam`, `spamaction`, `spamfolder`, `virus`, `virusaction`, `phish`, `phishaction`, `filters`, `autoreply`, `inbox`, `send_size_limit`, `recv_size_limit`, `daily_send_limit`, `daily_recv_limit`, `daily_recv_limit_ip`, `class`) VALUES (6,1,'',0,1,0,1,0,'REJECT',0,'REJECT',0,'MARK',0,'MARK',6,1,'DELETE',1,'DELETE',0,NULL,6,67108864,67108864,128,8192,8192,0);
@@ -259,6 +265,8 @@ INSERT INTO `Dispatch` (`usernum`, `secure`, `forwarded`, `rollout`, `bounces`,
 INSERT INTO `Dispatch` (`usernum`, `secure`, `forwarded`, `rollout`, `bounces`, `greylist`, `greytime`, `rbl`, `rblaction`, `spf`, `spfaction`, `dkim`, `dkimaction`, `spam`, `spamaction`, `spamfolder`, `virus`, `virusaction`, `phish`, `phishaction`, `filters`, `autoreply`, `inbox`, `send_size_limit`, `recv_size_limit`, `daily_send_limit`, `daily_recv_limit`, `daily_recv_limit_ip`, `class`) VALUES (8,1,'',0,1,0,1,0,'REJECT',0,'REJECT',0,'MARK',0,'MARK',8,1,'DELETE',1,'DELETE',0,NULL,8,67108864,67108864,128,8192,8192,0);
 INSERT INTO `Dispatch` (`usernum`, `secure`, `forwarded`, `rollout`, `bounces`, `greylist`, `greytime`, `rbl`, `rblaction`, `spf`, `spfaction`, `dkim`, `dkimaction`, `spam`, `spamaction`, `spamfolder`, `virus`, `virusaction`, `phish`, `phishaction`, `filters`, `autoreply`, `inbox`, `send_size_limit`, `recv_size_limit`, `daily_send_limit`, `daily_recv_limit`, `daily_recv_limit_ip`, `class`) VALUES (9,1,'',0,1,0,1,0,'REJECT',0,'REJECT',0,'MARK',0,'MARK',9,1,'DELETE',1,'DELETE',0,NULL,9,67108864,67108864,128,8192,8192,0);
 INSERT INTO `Dispatch` (`usernum`, `secure`, `forwarded`, `rollout`, `bounces`, `greylist`, `greytime`, `rbl`, `rblaction`, `spf`, `spfaction`, `dkim`, `dkimaction`, `spam`, `spamaction`, `spamfolder`, `virus`, `virusaction`, `phish`, `phishaction`, `filters`, `autoreply`, `inbox`, `send_size_limit`, `recv_size_limit`, `daily_send_limit`, `daily_recv_limit`, `daily_recv_limit_ip`, `class`) VALUES (10,1,'',0,1,0,1,0,'REJECT',0,'REJECT',0,'MARK',0,'MARK',10,1,'DELETE',1,'DELETE',0,NULL,10,67108864,67108864,128,8192,8192,0);
+INSERT INTO `Dispatch` (`usernum`, `secure`, `forwarded`, `rollout`, `bounces`, `greylist`, `greytime`, `rbl`, `rblaction`, `spf`, `spfaction`, `dkim`, `dkimaction`, `spam`, `spamaction`, `spamfolder`, `virus`, `virusaction`, `phish`, `phishaction`, `filters`, `autoreply`, `inbox`, `send_size_limit`, `recv_size_limit`, `daily_send_limit`, `daily_recv_limit`, `daily_recv_limit_ip`, `class`) VALUES (11,1,'',0,1,0,1,0,'REJECT',0,'REJECT',0,'MARK',0,'MARK',11,1,'DELETE',1,'DELETE',0,NULL,11,134217728,134217728,128,8192,8192,0);
+INSERT INTO `Dispatch` (`usernum`, `secure`, `forwarded`, `rollout`, `bounces`, `greylist`, `greytime`, `rbl`, `rblaction`, `spf`, `spfaction`, `dkim`, `dkimaction`, `spam`, `spamaction`, `spamfolder`, `virus`, `virusaction`, `phish`, `phishaction`, `filters`, `autoreply`, `inbox`, `send_size_limit`, `recv_size_limit`, `daily_send_limit`, `daily_recv_limit`, `daily_recv_limit_ip`, `class`) VALUES (12,1,'',0,1,0,1,0,'REJECT',0,'REJECT',0,'MARK',0,'MARK',12,1,'DELETE',1,'DELETE',0,NULL,12,134217728,134217728,128,8192,8192,0);
 
 INSERT INTO `Log` (`usernum`, `lastpop`, `lastmap`, `lastweb`, `lastchat`, `lastsent`, `lastreceived`, `popsessions`, `mapsessions`, `websessions`, `chatsessions`, `totalsent`, `totalreceived`, `totalbounces`, `created`, `created_ip`) VALUES (5,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2018-08-06 21:51:57','127.0.0.1');
 INSERT INTO `Log` (`usernum`, `lastpop`, `lastmap`, `lastweb`, `lastchat`, `lastsent`, `lastreceived`, `popsessions`, `mapsessions`, `websessions`, `chatsessions`, `totalsent`, `totalreceived`, `totalbounces`, `created`, `created_ip`) VALUES (6,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2018-08-06 21:51:57','127.0.0.1');
@@ -266,6 +274,8 @@ INSERT INTO `Log` (`usernum`, `lastpop`, `lastmap`, `lastweb`, `lastchat`, `last
 INSERT INTO `Log` (`usernum`, `lastpop`, `lastmap`, `lastweb`, `lastchat`, `lastsent`, `lastreceived`, `popsessions`, `mapsessions`, `websessions`, `chatsessions`, `totalsent`, `totalreceived`, `totalbounces`, `created`, `created_ip`) VALUES (8,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2018-08-06 21:51:57','127.0.0.1');
 INSERT INTO `Log` (`usernum`, `lastpop`, `lastmap`, `lastweb`, `lastchat`, `lastsent`, `lastreceived`, `popsessions`, `mapsessions`, `websessions`, `chatsessions`, `totalsent`, `totalreceived`, `totalbounces`, `created`, `created_ip`) VALUES (9,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2018-08-06 21:51:57','127.0.0.1');
 INSERT INTO `Log` (`usernum`, `lastpop`, `lastmap`, `lastweb`, `lastchat`, `lastsent`, `lastreceived`, `popsessions`, `mapsessions`, `websessions`, `chatsessions`, `totalsent`, `totalreceived`, `totalbounces`, `created`, `created_ip`) VALUES (10,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2018-08-06 21:51:57','127.0.0.1');
+INSERT INTO `Log` (`usernum`, `lastpop`, `lastmap`, `lastweb`, `lastchat`, `lastsent`, `lastreceived`, `popsessions`, `mapsessions`, `websessions`, `chatsessions`, `totalsent`, `totalreceived`, `totalbounces`, `created`, `created_ip`) VALUES (11,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2019-06-06 21:51:57','127.0.0.1');
+INSERT INTO `Log` (`usernum`, `lastpop`, `lastmap`, `lastweb`, `lastchat`, `lastsent`, `lastreceived`, `popsessions`, `mapsessions`, `websessions`, `chatsessions`, `totalsent`, `totalreceived`, `totalbounces`, `created`, `created_ip`) VALUES (12,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'2019-06-06 21:52:17','127.0.0.1');
 
 INSERT INTO `Profile` (`usernum`, `name`, `address_one`, `address_two`, `city`, `state`, `zip`, `country`, `profile`, `phone`, `mobile`, `fax`, `gender`, `language`, `birthdate`, `industry`, `website`, `accessible`) VALUES (5,'','','','','',0,'',NULL,'','','',NULL,'','0000-00-00','','',0);
 INSERT INTO `Profile` (`usernum`, `name`, `address_one`, `address_two`, `city`, `state`, `zip`, `country`, `profile`, `phone`, `mobile`, `fax`, `gender`, `language`, `birthdate`, `industry`, `website`, `accessible`) VALUES (6,'','','','','',0,'',NULL,'','','',NULL,'','0000-00-00','','',0);
@@ -273,6 +283,8 @@ INSERT INTO `Profile` (`usernum`, `name`, `address_one`, `address_two`, `city`,
 INSERT INTO `Profile` (`usernum`, `name`, `address_one`, `address_two`, `city`, `state`, `zip`, `country`, `profile`, `phone`, `mobile`, `fax`, `gender`, `language`, `birthdate`, `industry`, `website`, `accessible`) VALUES (8,'','','','','',0,'',NULL,'','','',NULL,'','0000-00-00','','',0);
 INSERT INTO `Profile` (`usernum`, `name`, `address_one`, `address_two`, `city`, `state`, `zip`, `country`, `profile`, `phone`, `mobile`, `fax`, `gender`, `language`, `birthdate`, `industry`, `website`, `accessible`) VALUES (9,'','','','','',0,'',NULL,'','','',NULL,'','0000-00-00','','',0);
 INSERT INTO `Profile` (`usernum`, `name`, `address_one`, `address_two`, `city`, `state`, `zip`, `country`, `profile`, `phone`, `mobile`, `fax`, `gender`, `language`, `birthdate`, `industry`, `website`, `accessible`) VALUES (10,'','','','','',0,'',NULL,'','','',NULL,'','0000-00-00','','',0);
+INSERT INTO `Profile` (`usernum`, `name`, `address_one`, `address_two`, `city`, `state`, `zip`, `country`, `profile`, `phone`, `mobile`, `fax`, `gender`, `language`, `birthdate`, `industry`, `website`, `accessible`) VALUES (11,'','','','','',0,'',NULL,'','','',NULL,'','0000-00-00','','',0);
+INSERT INTO `Profile` (`usernum`, `name`, `address_one`, `address_two`, `city`, `state`, `zip`, `country`, `profile`, `phone`, `mobile`, `fax`, `gender`, `language`, `birthdate`, `industry`, `website`, `accessible`) VALUES (12,'','','','','',0,'',NULL,'','','',NULL,'','0000-00-00','','',0);
 
 INSERT INTO `Realms` (`usernum`, `serial`, `label`, `shard`, `rotated`) VALUES (5,0,'mail','J7mUSSOGSL12qPUxFhyU50fu5ba-1hhGKRxW0EWFwRe11137-R3_oN55ashjtBxCySfcnLSYkJYGuuD_rTvxqQ',1);
 INSERT INTO `Realms` (`usernum`, `serial`, `label`, `shard`, `rotated`) VALUES (6,0,'mail','yoU9p4UIJOy6uEyCu5xDsMd2JSl5S0zcaRfA795TdcFHe7nOspx0d7XS-ojdzdgEfM2NxnQjZj6vukWj4C26cg',1);
@@ -280,6 +292,8 @@ INSERT INTO `Realms` (`usernum`, `serial`, `label`, `shard`, `rotated`) VALUES (
 INSERT INTO `Realms` (`usernum`, `serial`, `label`, `shard`, `rotated`) VALUES (8,0,'mail','q2Zg_FtCXd-HOf6J4npsRFMuDqaPzqL3DlRthmvU7CDSpvMfeWLmAk48OxmlIrvpqtDBbYH_VEVzHtgSFPnLIg',1);
 INSERT INTO `Realms` (`usernum`, `serial`, `label`, `shard`, `rotated`) VALUES (9,0,'mail','s-sRVHTkJ-Fb0hiMy67SZ8b7TjZj9vRcnN4TMFZnZ144Ymaexz5V-J9-P-rzwXz31gkefoRL5Aso5A2FzwhLfQ',1);
 INSERT INTO `Realms` (`usernum`, `serial`, `label`, `shard`, `rotated`) VALUES (10,0,'mail','J-SNFdBrDZOdbQAWKmqOpMto2qzJ7OBwm5LjEyUVl_Hv0-hpifQOZbmK2fF2BlZlsk5v-zvRSx_waChcOeDwHg',1);
+INSERT INTO `Realms` (`usernum`, `serial`, `label`, `shard`, `rotated`) VALUES (11,0,'mail','ayaz9MGxjxB47GI6dexrvnoCJyVNsI_8aOetvt3QekXNjVKhmxVQX7W90hL2622uaqIWenxG9HdkqBQkXTk4SA',1);
+INSERT INTO `Realms` (`usernum`, `serial`, `label`, `shard`, `rotated`) VALUES (12,0,'mail','rMeZj2pY-oHaHPNX98vVkXXpCQCyB_06WjXcTzo7w89itRX4YOJMDcLCsgolzw6imt_fb11APn76ZAl6CkHDlQ',1);
 
 INSERT INTO `Keys` (`usernum`, `signet`, `key`) VALUES (5,'Bv0AAMcBIGjvYcdQfpPvkH87Ba5S_UrbANRKylQN_PbCu1__7mucAiECIlHjcxYlWwpKqG1rLChG_VfnLLNiw96w2U9D7LqE2TgFpK30lThNAhc0CXPlz52ojBrEHunqLOS0UYkmdcpV7ghy8ITNzeAuRD5JJc_35-ed57_Nc0G6PIajnX604ibODga94HB4x_Q9qW4AVn1NmVe9xtFaQ3DHY5tVorv37Hv5I97vW_i_JI7mBC4gq5xLqXzg0d7SvOPC1GBhreqaBLsG','B7gAAABwEbYYgGZ2KWZccjQnbAuKsAFV-BdFOES7nQEda_WBhFRQ4jOqq7QDNB2jLcVCrHDcUIQk05PhHmfUJRvSiTRkDd50jZ3EIb3r2ka26RdXHy851fGLFz6Bu488uArUcsXk205G3mPiNZNlDnoVSSeIbg');
 INSERT INTO `Keys` (`usernum`, `signet`, `key`) VALUES (6,'Bv0AAMcBIMgKxxDI9j63snbL6BFc8vtnD4mWqX78CUYVqJdLUbCJAiED_qdPu8l7Exp38OgQPu5Nm4LX3aowPiP9DksEtfLRFScFuVKSGjHjM2y4DlctLgAMU_leBU6HrkW5cK5vMUNNzowTyUQjmt1Bg2SNne0RxaqY16_5v5p12jv17q8pHBvTBAa5bRTwiB9sPaJi8NYseS6tfF2EX0ZBAsKIth22EFu28mxKm-Y0muwD7_xk-48HjIP2XxpDBKGMBQpAl9Ub13cD','B7gAAABww4bGGnpnRfFspmSK85VeWddBe2-j2Y7F5A4ZV-yjbxWAnshItRBIup2Jx_hjwVjQOGC6RkLTDKXQgxiUaDLMchRU3YmWVIU9jrGZfrU5LPmaU2q2OXh3BFPv1pqM45pu9EV9QLecEsMg7I8hdF3BCA');
@@ -287,4 +301,10 @@ INSERT INTO `Keys` (`usernum`, `signet`, `key`) VALUES (7,'Bv0AAMcBIBUB_xhqusTb6
 INSERT INTO `Keys` (`usernum`, `signet`, `key`) VALUES (8,'Bv0AAMcBIBPzMUMtpD4ljHMNHFe5ErI3dFOOLgBDVgE2qAzqZ7zhAiEDWispbjAcBBqWRbytkVs8QRkczm9dj-JCXvyjWgD8BGcFI8mloo5VenKRKzUrqeKT4un66Oj5oITrTKqzYmdykC53vw_7vQu1HniycTTEKtGmaRy85j-grNBf4IEKCo3TDgZTYM3DlA_0-1VIZslx4bHIgB5dW1DnwK8V9WxmHJXs2tqzAebT39-iF_LstRrzXl31y_jEPC2sNqXDA6DnTxUF','B7gAAABw2L82NfcMDfohoosHwm1HTH-frSPR0mQG-4_p7o8MeWxJtmWclOQT66vdQMm1zttNQU9bz4LztFL38YrhFyNW1KMa1-S9lN6zOmNp_YcEjTcWIM4Xlo5HJ9UGkSc6uOyMWWI5EyG0_WmIemNq-KVdaQ');
 INSERT INTO `Keys` (`usernum`, `signet`, `key`) VALUES (9,'Bv0AAMcBIFOpc1aSEwxEEC2Vej9iuFyuY9ukebtBrHNPwB21wRZeAiECqrOPSNCf-gG8eDSWSjlNnz-h8tllvOHX1aRpeMeX3cIF-xmtPFLFBuCWEHgaH2dOendbCLV5urjMJ9jQx8dMNMtek12sV6iZUU3y293vJjkFBdhBwJh-rWODSrds_acaCgYY2PQJ9aT5UP1ckb7E2YQbOuxB_cQdMJLv1y2KO9miutpS3fh73bH-CZhw1uFSz1i9gRnI6FBc5tGOWmHNZjME','B7gAAABwwXHGYntnrZh7CEbQVjKY_8rlpCW-7-VeudSWd8oiWc0e4VbKgMD9pfGy2eR7ZgpqqfUkcNG757el2wYEKCkwug4ukoTryJioZbngPtFRuYfgPXTLYMtkWKOjq3t6AZrBDuRpBV6WGYO2HbMH7XaLmA');
 INSERT INTO `Keys` (`usernum`, `signet`, `key`) VALUES (10,'Bv0AAMcBIFRTWQk5ujJLTbLM1hDDIQksos-DkcnKnRXRF2u1N91LAiEC7FjFR8HM-F73_8Vuczq2dPCxcGLjQv6JHOLHpRuRUX8FK4R52zgWIXh2DOU7eL3jlez7LxGJN_wEiA4j0JwEgXWDqSI3U8IdXfeX0twz-lQLphqdxReu_eQCDW1GavFpAAY-6IWrOCAcU0xMuGhf85RfemNo2UNT8h_oIkTKPVfk8QISXmkC9AZK8lw-9dvViawPME58t9d9yFaBNg0iCzkJ','B7gAAABwc17c0xKII99ZsXlbn0beMsl9w0wOXX7MJbuRgrSvrvJY3L5KGee-dOTPMtUhmVHFOPZqSXw5a0bKa2ueVySQ8S_LyTLLDOSSaWgLjaX2knSpRHHhrq61OJAxDy7bCAhq2ERfJxMwtdUzQKbCd4QhFQ');
+INSERT INTO `Keys` (`usernum`, `signet`, `key`) VALUES (11,'Bv0AAMcBILoZ8zQDuMx5RcknJJWRWXs96cw0ryKR_yvoUj_IrGRwAiECdKNcR8cCHcjYx8jeh1OmHiJyUoWLPaB0W3cvRV8lTz0FvJx1GQVNeiwoRS1ivEnpfvkYn_EAjQSkt43TKgV_8OuYennENYfcjGmmh74IENtIoxUXCnmuXK04p_Mc3Qr-AQZXXVy-OL5PyolhPTpsKM6e6_ZMA_AaJzd8flfbcbCuDUjWI3ji839x5UX0edA8_xkN6_P9PlE5CWYhPIc5PzAD','B7gAAABwNOwejEwYL8ybbeHJplEvvx7sXkEehj9TWRFOYfMa7IMyfKlTkqEHiZK0sL-hpgBgAXYSozlC6zay7Wd1hrRGWfN9UvMNOYjN2b4oZfOPM3CwYbC1VOlyUfhyksYnY2NSqyng69ZLip62ogo5jh3qkQ');
+INSERT INTO `Keys` (`usernum`, `signet`, `key`) VALUES (12,'Bv0AAMcBIGBTTwHowkoHI45E5zgEwe4Nl9YRFUs_GoDCNxA3JT4NAiECYDYmnRdVCdL6ED5Nn89mIrUEeNMeq01llGgbCeQ0FocF_-7tYLUWLAD4Qtvlk-Qcp0Nd3up5UMdnqraPCjamA6cQVvAK57LngMttC67lXNGWVxYgL5LfVwh3Few0Rs1eDQbR0lz_337hnejZi7MR5BvzANWnSxuFmcaE564iTlox-thNpxM7vXBenuAVtHaW7XF52amKPxuE3-bT3R0aPiMK','B7gAAABwT47uOrTNCUW3mChwL3ymuA6oK9LWQ_XAuUFK7tuLGYy5uB4qZREjMbqMUCz8TP1P5dDOa3pvHvD03v_QV-Nmn_ORIUjBqkyVLofalYwfjCU4ZvT-5Zcy1vyVOfIt6eGL_ie89t2fCjOUaKu-NR1Eow');
+
+UPDATE `Users` SET `admin` = 2 WHERE `userid` = 'admin';
+UPDATE `Users` SET `admin` = 1, `domain` = 'admin@domain.tld' WHERE `userid` = 'admin@domain.tld';
+INSERT INTO `Domains` (`domnum`, `domain`, `restricted`, `mailboxes`, `wildcard`, `dkim`, `spf`, `updated`, `created`) VALUES (NULL,'domain.tld',0,0,0,0,0,'0000-00-00 00:00:00','2019-06-06 21:52:17');
 
diff --git a/res/sql/Migration.sql b/res/sql/Migration.sql
index cb4aa937..52ec4c28 100644
--- a/res/sql/Migration.sql
+++ b/res/sql/Migration.sql
@@ -73,9 +73,12 @@ CREATE TABLE `Realms` (
 ALTER TABLE `Realms` 
 ADD COLUMN `rotated` TINYINT(1) NOT NULL DEFAULT '0' AFTER `shard`;
 
-ALTER TABLE `Codes` ADD COLUMN `years` TINYINT(2) NOT NULL DEFAULT '1' AFTER `plan`;
+ALTER TABLE `Codes` ADD COLUMN `years` tinyint(2) NOT NULL DEFAULT '1' AFTER `plan`;
+
+ALTER TABLE `Users` ADD COLUMN `admin` tinyint(2) NOT NULL DEFAULT '0' AFTER `overquota`;
+
+ALTER TABLE `Limits` ADD COLUMN `quota` bigint(20) NOT NULL DEFAULT '21474836480' AFTER `daily_recv_limit_ip_max`;
 
-ALTER TABLE `Limits` ADD COLUMN `quota` BIGINT(20) NOT NULL DEFAULT '21474836480' AFTER `daily_recv_limit_ip_max`;
 DROP TABLE IF EXISTS `Requests`;
 CREATE TABLE `Requests` (
   `requestnum` bigint(20) unsigned NOT NULL AUTO_INCREMENT,