summaryrefslogtreecommitdiff
path: root/data/sql/base/db_auth
diff options
context:
space:
mode:
authorKitzunu <24550914+Kitzunu@users.noreply.github.com>2021-04-15 11:17:14 +0200
committerGitHub <noreply@github.com>2021-04-15 11:17:14 +0200
commit0a12aed4bb03bb7f5490114086b6dab4af5b4ae3 (patch)
treee8fc4afc4e8425ea944d796ee3a4998dd29a660b /data/sql/base/db_auth
parent0bb4ab3e3ebe98381dedc4cb78fa2bfde8df48ad (diff)
fix(DB/Account): Remove default accounts (#5292)
Diffstat (limited to 'data/sql/base/db_auth')
-rw-r--r--data/sql/base/db_auth/account.sql15
-rw-r--r--data/sql/base/db_auth/account_access.sql16
2 files changed, 0 insertions, 31 deletions
diff --git a/data/sql/base/db_auth/account.sql b/data/sql/base/db_auth/account.sql
index 3d7ab68d18..79d3df0932 100644
--- a/data/sql/base/db_auth/account.sql
+++ b/data/sql/base/db_auth/account.sql
@@ -39,21 +39,6 @@ CREATE TABLE `account`
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=UTF8MB4 COMMENT='Account System';
/*!40101 SET character_set_client = @saved_cs_client */;
-LOCK TABLES `account` WRITE;
-/*!40000 ALTER TABLE `account` DISABLE KEYS */;
-INSERT INTO `account` VALUES
-(1,'test1','047ce22643f9b0bd6baeb18d51bf1075a4d43fc6','','','','','','','2016-01-30 21:09:43','127.0.0.1','127.0.0.1',0,0,'00',NULL,0,2,0,'','',0,'',0,0),
-(2,'test2','10eb1ff16cf5380147e8281cd8080a210ecb3c53','','','','','','','2016-01-30 21:09:43','127.0.0.1','127.0.0.1',0,0,'00',NULL,0,2,0,'','',0,'',0,0),
-(3,'test3','e546bbf9ca93ae5291f0b441bb9ea2fa0c466176','','','','','','','2016-01-30 21:09:43','127.0.0.1','127.0.0.1',0,0,'00',NULL,0,2,0,'','',0,'',0,0),
-(4,'test4','61015d83b456a9c6a7defdff07f55265f24097af','','','','','','','2016-01-30 21:09:43','127.0.0.1','127.0.0.1',0,0,'00',NULL,0,2,0,'','',0,'',0,0),
-(5,'test5','dddeac4ffe5f286ec57b7a1ed63bf3a859debe1e','','','','','','','2016-01-30 21:09:43','127.0.0.1','127.0.0.1',0,0,'00',NULL,0,2,0,'','',0,'',0,0),
-(6,'test6','f1f94cdffd83c8c4182d66689077f92c807ab579','','','','','','','2016-01-30 21:09:43','127.0.0.1','127.0.0.1',0,0,'00',NULL,0,2,0,'','',0,'',0,0),
-(7,'test7','6fcd35c35b127be1d9ca040b2b478eb366506ce2','','','','','','','2016-01-30 21:09:43','127.0.0.1','127.0.0.1',0,0,'00',NULL,0,2,0,'','',0,'',0,0),
-(8,'test8','484332ccb02e284e4e0a04573c3fa417f4745fdf','','','','','','','2016-01-30 21:09:43','127.0.0.1','127.0.0.1',0,0,'00',NULL,0,2,0,'','',0,'',0,0),
-(9,'test9','4fce15ed251721f02754d5381ae9d0137b6a6a30','','','','','','','2016-01-30 21:09:43','127.0.0.1','127.0.0.1',0,0,'00',NULL,0,2,0,'','',0,'',0,0),
-(10,'test10','b22d249228e84ab493b39a2bd765bee9b7c0b350','','','','','','','2016-01-30 21:09:43','127.0.0.1','127.0.0.1',0,0,'00',NULL,0,2,0,'','',0,'',0,0);
-/*!40000 ALTER TABLE `account` ENABLE KEYS */;
-UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
diff --git a/data/sql/base/db_auth/account_access.sql b/data/sql/base/db_auth/account_access.sql
index 60dd5387e0..3530f0dc74 100644
--- a/data/sql/base/db_auth/account_access.sql
+++ b/data/sql/base/db_auth/account_access.sql
@@ -17,25 +17,9 @@ CREATE TABLE `account_access`
) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;
/*!40101 SET character_set_client = @saved_cs_client */;
-LOCK TABLES `account_access` WRITE;
-/*!40000 ALTER TABLE `account_access` DISABLE KEYS */;
-INSERT INTO `account_access` VALUES
-(1,4,-1,'Test account - Console Admin'),
-(2,4,-1,'Test account - Console Admin'),
-(3,3,-1,'Test account - Ingame Admin'),
-(4,3,-1,'Test account - Ingame Admin'),
-(5,2,-1,'Test account - Major Game Master'),
-(6,2,-1,'Test account - Major Game Master'),
-(7,1,-1,'Test account - Minor Game Master'),
-(8,1,-1,'Test account - Minor Game Master'),
-(9,0,-1,'Test account - Player'),
-(10,0,-1,'Test account - Player');
-/*!40000 ALTER TABLE `account_access` 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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-