· 6 years ago · Sep 28, 2019, 05:37 AM
1-- Current Database: `skyrealms_permissions`
2--
3
4CREATE DATABASE /*!32312 IF NOT EXISTS*/ `skyrealms_permissions` /*!40100 DEFAULT CHARACTER SET latin1 */;
5
6USE `skyrealms_permissions`;
7
8--
9-- Table structure for table `groupparents`
10--
11
12DROP TABLE IF EXISTS `groupparents`;
13/*!40101 SET @saved_cs_client = @@character_set_client */;
14/*!40101 SET character_set_client = utf8 */;
15CREATE TABLE `groupparents` (
16 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
17 `groupid` int(10) unsigned NOT NULL,
18 `parentgroupid` int(10) unsigned NOT NULL,
19 PRIMARY KEY (`id`),
20 UNIQUE KEY `id_UNIQUE` (`id`)
21) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
22/*!40101 SET character_set_client = @saved_cs_client */;
23
24--
25-- Dumping data for table `groupparents`
26--
27
28LOCK TABLES `groupparents` WRITE;
29/*!40000 ALTER TABLE `groupparents` DISABLE KEYS */;
30INSERT INTO `groupparents` VALUES (5,2,1),(6,3,2),(7,4,3),(8,5,4),(9,6,5),(10,7,1),(11,8,7),(12,9,8),(13,10,9),(14,11,10),(15,12,11);
31/*!40000 ALTER TABLE `groupparents` ENABLE KEYS */;
32UNLOCK TABLES;
33
34--
35-- Table structure for table `grouppermissions`
36--
37
38DROP TABLE IF EXISTS `grouppermissions`;
39/*!40101 SET @saved_cs_client = @@character_set_client */;
40/*!40101 SET character_set_client = utf8 */;
41CREATE TABLE `grouppermissions` (
42 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
43 `groupid` int(10) unsigned NOT NULL,
44 `permission` varchar(128) NOT NULL,
45 `world` varchar(128) NOT NULL,
46 `server` varchar(128) NOT NULL,
47 `expires` datetime DEFAULT NULL,
48 PRIMARY KEY (`id`)
49) ENGINE=InnoDB AUTO_INCREMENT=504 DEFAULT CHARSET=utf8;
50/*!40101 SET character_set_client = @saved_cs_client */;
51
52--
53-- Dumping data for table `grouppermissions`
54--
55
56LOCK TABLES `grouppermissions` WRITE;
57/*!40000 ALTER TABLE `grouppermissions` DISABLE KEYS */;
58INSERT INTO `grouppermissions` VALUES (10,1,'chatformat.default','','',NULL),(11,1,'chatformat.utf','','',NULL),(12,1,'deluxechat.pm','','',NULL),(13,1,'animatednames.group.default','','',NULL),(14,1,'askyblock.island.*','','',NULL),(15,1,'askyblock.team.create','','',NULL),(16,1,'askyblock.team.kick','','',NULL),(17,1,'askyblock.team.makeleader','','',NULL),(18,1,'askyblock.team.join','','',NULL),(19,1,'askyblock.coop','','',NULL),(20,1,'askyblock.island.controlpanel','','',NULL),(21,1,'askyblock.craft.enderchest','','',NULL),(22,1,'auctions.command.bid','','',NULL),(23,1,'auctions.command.cancel','','',NULL),(24,1,'auctions.command.end','','',NULL),(25,1,'auctions.command.ignore','','',NULL),(26,1,'auctions.command.impound','','',NULL),(27,1,'auctions.command.info','','',NULL),(28,1,'auctions.command.queue','','',NULL),(29,1,'auctions.command.start','','',NULL),(30,1,'auctions.command.toggle','','',NULL),(31,1,'banknotes.withdraw','','',NULL),(32,1,'banknotes.deposit','','',NULL),(33,1,'blivtrails.remove-trail','','',NULL),(34,1,'blivtrails.options','','',NULL),(35,1,'blivtrails.options.type','','',NULL),(36,1,'blivtrails.options.type.trace','','',NULL),(37,1,'blivtrails.options.type.random','','',NULL),(38,1,'blivtrails.options.type.dynamic','','',NULL),(39,1,'blivtrails.options.length','','',NULL),(40,1,'blivtrails.options.length.short','','',NULL),(41,1,'blivtrails.options.length.medium','','',NULL),(42,1,'blivtrails.options.length.long','','',NULL),(43,1,'blivtrails.options.height','','',NULL),(44,1,'blivtrails.options.height.feet','','',NULL),(45,1,'blivtrails.options.height.waist','','',NULL),(46,1,'blivtrails.options.height.halo','','',NULL),(47,1,'blivtrails.options.colour','','',NULL),(48,1,'chatreaction.wins','','',NULL),(49,1,'chatreaction.wins.others','','',NULL),(50,1,'chatreaction.top','','',NULL),(51,1,'skyrealms.commands','','',NULL),(52,1,'deluxemenus.open','','',NULL),(53,1,'deluxemenus.menu.*','','',NULL),(54,1,'deluxetags.gui','','',NULL),(55,1,'deluxetags.select','','',NULL),(56,1,'deluxetags.list','','',NULL),(57,1,'deluxetags.list.all','','',NULL),(58,1,'deluxetags.list.player','','',NULL),(59,1,'deluxetags.clear','','',NULL),(60,1,'echopet.pet','','',NULL),(61,1,'echopet.pet.remove','','',NULL),(62,1,'echopet.pet.list','','',NULL),(63,1,'echopet.pet.info','','',NULL),(64,1,'echopet.pet.menu','','',NULL),(65,1,'echopet.pet.show','','',NULL),(66,1,'echopet.pet.hide','','',NULL),(67,1,'echopet.pet.call','','',NULL),(68,1,'echopet.pet.name','','',NULL),(69,1,'echopet.pet.select','','',NULL),(70,1,'guiredeemmcmmo.credits.other','','',NULL),(71,1,'libsdisguises.undisguise','','',NULL),(72,1,'iteminchat.use','','',NULL),(73,1,'parallaxquicksell.use','','',NULL),(74,1,'parallaxquicksell.sellall','','',NULL),(75,1,'block.use','','',NULL),(76,1,'glow.use','','',NULL),(77,1,'permissiontimer.info','','',NULL),(78,1,'playervaults.commands.use','','',NULL),(79,1,'playervaults.signs.use','','',NULL),(80,1,'playervaults.amount.1','','',NULL),(81,1,'rankvouchers.list','','',NULL),(82,1,'rankvouchers.help','','',NULL),(83,1,'shopguiplus.shop','','',NULL),(84,1,'shopguiplus.shops.*','','',NULL),(85,1,'treetwerk.use','','',NULL),(86,1,'essentials.balance','','',NULL),(87,1,'essentials.balance.other','','',NULL),(88,1,'essentials.balancetop','','',NULL),(89,1,'essentials.pay','','',NULL),(90,1,'essentials.help','','',NULL),(91,1,'essentials.helpop','','',NULL),(92,1,'essentials.ignore','','',NULL),(93,1,'essentials.info','','',NULL),(94,1,'essentials.itemdb','','',NULL),(95,1,'essentials.mail','','',NULL),(96,1,'essentials.mail.send','','',NULL),(97,1,'essentials.motd','','',NULL),(98,1,'essentials.msg','','',NULL),(99,1,'essentials.rules','','',NULL),(100,1,'essentials.ping','','',NULL),(101,1,'essentials.spawn','','',NULL),(102,1,'essentials.delhome','','',NULL),(103,1,'essentials.home','','',NULL),(104,1,'essentials.home.bed','','',NULL),(105,1,'essentials.sethome','','',NULL),(106,1,'essentials.sethome.bed','','',NULL),(107,1,'essentials.sethome.multiple','','',NULL),(108,1,'essentials.tpa','','',NULL),(109,1,'essentials.tpaccept','','',NULL),(110,1,'essentials.tpahere','','',NULL),(111,1,'essentials.tpdeny','','',NULL),(112,1,'essentials.warp','','',NULL),(113,1,'essentials.warp.list','','',NULL),(114,1,'bottles.use','','',NULL),(115,1,'essentials.kit','','',NULL),(116,1,'essentials.kits.Starter','','',NULL),(117,1,'bukkit.command.tps','','',NULL),(118,1,'headdb.open','','',NULL),(119,1,'headdb.allowBuy.*','','',NULL),(120,1,'ChestShop.shop.*','','',NULL),(121,1,'trading.trade','','',NULL),(122,1,'airbar.group.default','','',NULL),(123,1,'options.Music','','Hub',NULL),(124,1,'options.Speed','','Hub',NULL),(125,1,'options.Jump','','Hub',NULL),(126,1,'options.Stacker','','Hub',NULL),(127,1,'DJP.*','','Hub',NULL),(128,1,'slashserver.Tropics','','',NULL),(129,1,'slashserver.Hub','','',NULL),(130,1,'casino.coinflip','','',NULL),(131,1,'casino.coinflipnew','','',NULL),(132,1,'casino.rps','','',NULL),(133,1,'casino.rpsnew','','',NULL),(134,1,'casino.jackpot','','',NULL),(135,1,'casino.stats','','',NULL),(136,1,'titleadvanced.group.default','','',NULL),(137,1,'askyblock.island.settings','','',NULL),(138,1,'askyblock.settings.*','','',NULL),(139,1,'silkspawners.place.*','','',NULL),(140,1,'tokenmanager.use.*','','',NULL),(141,1,'deatheffects.gui','','',NULL),(142,1,'essentials.kits.Farmer','','',NULL),(143,1,'nicky.realname','','',NULL),(144,1,'pp.use','','',NULL),(145,1,'BungeePortals.portal.*','','',NULL),(146,1,'essentials.warps.auction','','',NULL),(147,1,'essentials.warps.auctions','','',NULL),(148,1,'essentials.warps.board','','',NULL),(149,1,'essentials.warps.boards','','',NULL),(150,1,'essentials.warps.casino','','',NULL),(151,1,'essentials.warps.crate','','',NULL),(152,1,'essentials.warps.crates','','',NULL),(153,1,'essentials.warps.island','','',NULL),(154,1,'essentials.warps.jackpot','','',NULL),(155,1,'essentials.warps.leader','','',NULL),(156,1,'essentials.warps.leaderboards','','',NULL),(157,1,'essentials.warps.portal','','',NULL),(158,1,'essentials.warps.shop','','',NULL),(159,1,'essentials.warps.nether','','',NULL),(160,1,'noflyzone.autofly.all','','',NULL),(161,1,'essentials.warps.tokens','','',NULL),(162,1,'essentials.warps.token','','',NULL),(163,1,'essentials.warps.tokenshop','','',NULL),(164,1,'essentials.warps.tokensshop','','',NULL),(165,1,'essentials.warps.buy','','',NULL),(166,1,'essentials.warps.donation','','',NULL),(167,2,'litebans.mute','','',NULL),(168,2,'litebans.tempmute','','',NULL),(169,2,'litebans.unmute','','',NULL),(170,2,'litebans.warn','','',NULL),(171,2,'litebans.unwarn','','',NULL),(172,2,'litebans.history','','',NULL),(173,2,'litebans.warnings','','',NULL),(174,2,'litebans.staffhistory','','',NULL),(175,2,'-chatformat.default','','',NULL),(176,2,'chatformat.Helper','','',NULL),(177,2,'-animatednames.group.default','','',NULL),(178,2,'animatednames.group.Helper','','',NULL),(179,3,'litebans.kick','','',NULL),(180,3,'litebans.vanish','','',NULL),(181,3,'essentials.invsee','','',NULL),(182,3,'essentials.clearinventory','','',NULL),(183,3,'essentials.spawn.other','','',NULL),(184,3,'deluxechat.color','','',NULL),(185,3,'deluxechat.formatting','','',NULL),(186,3,'deluxechat.hidden','','',NULL),(187,3,'deluxechat.url','','',NULL),(188,3,'-chatformat.Helper','','',NULL),(189,3,'chatformat.Moderator','','',NULL),(190,3,'nicky.set','','',NULL),(191,3,'nicky.set.other','','',NULL),(192,3,'nicky.del','','',NULL),(193,3,'nicky.del.other','','',NULL),(194,3,'nicky.color.normal','','',NULL),(195,3,'nicky.realname','','',NULL),(196,3,'nicky.color.normal','','',NULL),(197,3,'-nicky.color.1','','',NULL),(198,3,'-nicky.color.0','','',NULL),(199,3,'-animatednames.group.Helper','','',NULL),(200,3,'animatednames.group.Moderator','','',NULL),(201,4,'litebans.ban','','',NULL),(202,4,'litebans.tempban','','',NULL),(203,4,'litebans.unban','','',NULL),(204,4,'litebans.banlist','','',NULL),(205,4,'litebans.checkban','','',NULL),(206,4,'litebans.lastuuid','','',NULL),(207,4,'litebans.togglechat','','',NULL),(208,4,'litebans.togglechat.bypass','','',NULL),(209,4,'litebans.clearchat','','',NULL),(210,4,'litebans.clearchat.bypass','','',NULL),(211,4,'essentials.gamemode','','',NULL),(212,4,'essentials.give','','',NULL),(213,4,'essentials.god','','',NULL),(214,4,'essentials.speed','','',NULL),(215,4,'essentials.speed.walk','','',NULL),(216,4,'essentials.speed.fly','','',NULL),(217,4,'essentials.time','','',NULL),(218,4,'essentials.time.set','','',NULL),(219,4,'essentials.afk','','',NULL),(220,4,'essentials.near','','',NULL),(221,4,'deluxechat.socialspy','','',NULL),(222,4,'-chatformat.Moderator','','',NULL),(223,4,'chatformat.Admin','','',NULL),(224,4,'essentials.tp','','',NULL),(225,4,'essentials.fly','','',NULL),(226,4,'essentials.gamemode.creative','','',NULL),(227,4,'essentials.gamemode.survival','','',NULL),(228,4,'essentials.tphere','','',NULL),(229,4,'-animatednames.group.Moderator','','',NULL),(230,4,'animatednames.group.Admin','','',NULL),(231,5,'-chatformat.Admin','','',NULL),(232,5,'chatformat.Manager','','',NULL),(233,5,'litebans.dupeip','','',NULL),(234,5,'-animatednames.group.Admin','','',NULL),(235,5,'animatednames.group.Manager','','',NULL),(236,6,'*','','',NULL),(237,6,'-chatformat.Manager','','',NULL),(238,6,'chatformat.Owner','','',NULL),(239,6,'-animatednames.group.default','','',NULL),(240,6,'-animatednames.group.Sky','','',NULL),(241,6,'-animatednames.group.Heaven','','',NULL),(242,6,'-animatednames.group.Astral','','',NULL),(243,6,'-animatednames.group.Celestial','','',NULL),(244,6,'-animatednames.group.Lunar','','',NULL),(245,6,'-animatednames.group.Manager','','',NULL),(246,6,'animatednames.group.Owner','','',NULL),(247,7,'chatformat.gaia','','',NULL),(248,7,'-chatformat.default','','',NULL),(249,7,'-animatednames.group.default','','',NULL),(250,7,'animatednames.group.Gaia','','',NULL),(251,7,'blivtrails.angry-villager','','',NULL),(252,7,'blivtrails.criticals','','',NULL),(253,7,'blivtrails.criticals-magic','','',NULL),(254,7,'blivtrails.drip-lava','','',NULL),(255,7,'blivtrails.drip-water','','',NULL),(256,7,'deatheffects.flame','','',NULL),(257,7,'deatheffects.bloodhelix','','',NULL),(258,7,'deatheffects.nuke','','',NULL),(259,7,'deatheffects.rainbow','','',NULL),(260,7,'deatheffects.heart','','',NULL),(261,7,'deatheffects.firework','','',NULL),(262,7,'echopet.pet.type.bat','','',NULL),(263,7,'echopet.pet.type.blaze','','',NULL),(264,7,'echopet.pet.type.cavespider','','',NULL),(265,7,'echopet.pet.type.chicken','','',NULL),(266,7,'echopet.pet.type.cow','','',NULL),(267,7,'emotes.emote.Grin','','',NULL),(268,7,'emotes.emote.Love','','',NULL),(269,7,'emotes.emote.Goofy','','',NULL),(270,7,'essentials.afk','','',NULL),(271,7,'essentials.repair','','',NULL),(272,7,'essentials.hat','','',NULL),(273,7,'essentials.suicide','','',NULL),(274,7,'essentials.back','','',NULL),(275,7,'essentials.keepxp','','',NULL),(276,7,'essentials.joinfullserver','','',NULL),(277,7,'libsdisguises.disguise.Bat','','',NULL),(278,7,'libsdisguises.disguise.Chicken','','',NULL),(279,7,'libsdisguises.disguise.Cow','','',NULL),(280,7,'libsdisguises.disguise.Squid','','',NULL),(281,7,'libsdisguises.disguise.Villager','','',NULL),(282,7,'silkspawners.silkdrop.*','','',NULL),(283,8,'chatformat.sky','','',NULL),(284,8,'-chatformat.gaia','','',NULL),(285,8,'-animatednames.group.Gaia','','',NULL),(286,8,'animatednames.group.Sky','','',NULL),(287,8,'blivtrails.enchant','','',NULL),(288,8,'blivtrails.explosion-smoke','','',NULL),(289,8,'blivtrails.firework','','',NULL),(290,8,'blivtrails.flame','','',NULL),(291,8,'blivtrails.happy-villager','','',NULL),(292,8,'deatheffects.cloud','','',NULL),(293,8,'deatheffects.lightning','','',NULL),(294,8,'deatheffects.coin','','',NULL),(295,8,'deatheffects.potion','','',NULL),(296,8,'deatheffects.blood','','',NULL),(297,8,'deatheffects.note','','',NULL),(298,8,'echopet.pet.type.creeper','','',NULL),(299,8,'echopet.pet.type.enderdragon','','',NULL),(300,8,'echopet.pet.type.enderman','','',NULL),(301,8,'echopet.pet.type.ghast','','',NULL),(302,8,'echopet.pet.type.horse','','',NULL),(303,8,'emotes.emote.Dizzy','','',NULL),(304,8,'emotes.emote.Relax','','',NULL),(305,8,'emotes.emote.Cool','','',NULL),(306,8,'essentials.itemdb','','',NULL),(307,8,'libsdisguises.disguise.Witch','','',NULL),(308,8,'libsdisguises.disguise.Ocelot','','',NULL),(309,8,'libsdisguises.disguise.Pig','','',NULL),(310,8,'libsdisguises.disguise.Spider','','',NULL),(311,8,'libsdisguises.disguise.Cave_Spider','','',NULL),(312,9,'chatformat.heaven','','',NULL),(313,9,'-chatformat.sky','','',NULL),(314,9,'-animatednames.group.Sky','','',NULL),(315,9,'animatednames.group.Heaven','','',NULL),(316,9,'blivtrails.hearts','','',NULL),(317,9,'blivtrails.lava','','',NULL),(318,9,'blivtrails.note','','',NULL),(319,9,'blivtrails.portal','','',NULL),(320,9,'blivtrails.redstone','','',NULL),(321,9,'deatheffects.flower','','',NULL),(322,9,'deatheffects.chess','','',NULL),(323,9,'deatheffects.tnt','','',NULL),(324,9,'deatheffects.treasure','','',NULL),(325,9,'deatheffects.water','','',NULL),(326,9,'deatheffects.lava','','',NULL),(327,9,'echopet.pet.type.human','','',NULL),(328,9,'echopet.pet.type.irongolem','','',NULL),(329,9,'echopet.pet.type.magmacube','','',NULL),(330,9,'echopet.pet.type.mushroomcow','','',NULL),(331,9,'echopet.pet.type.ocelot','','',NULL),(332,9,'emotes.emote.Frown','','',NULL),(333,9,'emotes.emote.Cry','','',NULL),(334,9,'emotes.emote.Cheeky','','',NULL),(335,9,'essentials.tpahere','','',NULL),(336,9,'libsdisguises.disguise.Ghast','','',NULL),(337,9,'libsdisguises.disguise.Blaze','','',NULL),(338,9,'libsdisguises.disguise.Mushroom_Cow','','',NULL),(339,9,'libsdisguises.disguise.Slime','','',NULL),(340,9,'libsdisguises.disguise.Skeleton','','',NULL),(341,10,'chatformat.astral','','',NULL),(342,10,'-chatformat.heaven','','',NULL),(343,10,'-animatednames.group.Heaven','','',NULL),(344,10,'animatednames.group.Astral','','',NULL),(345,10,'blivtrails.slime','','',NULL),(346,10,'blivtrails.smoke','','',NULL),(347,10,'blivtrails.snow-ball','','',NULL),(348,10,'blivtrails.snow-shovel','','',NULL),(349,10,'blivtrails.spell','','',NULL),(350,10,'deatheffects.ender','','',NULL),(351,10,'deatheffects.warm','','',NULL),(352,10,'deatheffects.cold','','',NULL),(353,10,'deatheffects.pastel','','',NULL),(354,10,'deatheffects.fish','','',NULL),(355,10,'deatheffects.cookie','','',NULL),(356,10,'echopet.pet.type.pig','','',NULL),(357,10,'echopet.pet.type.pigzombie','','',NULL),(358,10,'echopet.pet.type.sheep','','',NULL),(359,10,'echopet.pet.type.silverfish','','',NULL),(360,10,'echopet.pet.type.skeleton','','',NULL),(361,10,'emotes.emote.Spicy','','',NULL),(362,10,'emotes.emote.DealWithIt','','',NULL),(363,10,'emotes.emote.Smile','','',NULL),(364,10,'essentials.kittycannon','','',NULL),(365,10,'libsdisguises.disguise.Pig_Zombie','','',NULL),(366,10,'libsdisguises.disguise.Sheep','','',NULL),(367,10,'libsdisguises.disguise.Giant','','',NULL),(368,10,'libsdisguises.disguise.Rabbit','','',NULL),(369,10,'libsdisguises.disguise.Wolf','','',NULL),(370,11,'chatformat.celestial','','',NULL),(371,11,'-chatformat.astral','','',NULL),(372,11,'-animatednames.group.Astral','','',NULL),(373,11,'animatednames.group.Celestial','','',NULL),(374,11,'blivtrails.spell-instant','','',NULL),(375,11,'blivtrails.spell-mob','','',NULL),(376,11,'blivtrails.spell-witch','','',NULL),(377,11,'blivtrails.town-aura','','',NULL),(378,11,'blivtrails.water-drop','','',NULL),(379,11,'deatheffects.snow','','',NULL),(380,11,'deatheffects.smoke','','',NULL),(381,11,'deatheffects.meat','','',NULL),(382,11,'deatheffects.angry','','',NULL),(383,11,'deatheffects.happy','','',NULL),(384,11,'deatheffects.enchanted','','',NULL),(385,11,'echopet.pet.type.slime','','',NULL),(386,11,'echopet.pet.type.snowman','','',NULL),(387,11,'echopet.pet.type.spider','','',NULL),(388,11,'echopet.pet.type.squid','','',NULL),(389,11,'echopet.pet.type.villager','','',NULL),(390,11,'emotes.emote.SunTan','','',NULL),(391,11,'emotes.emote.Wink','','',NULL),(392,11,'emotes.emote.Rage','','',NULL),(393,11,'essentials.enderchest','','',NULL),(394,11,'libsdisguises.disguise.Zombie','','',NULL),(395,11,'libsdisguises.disguise.Wolf','','',NULL),(396,11,'libsdisguises.disguise.Zombie_Villager','','',NULL),(397,11,'libsdisguises.disguise.Snowman','','',NULL),(398,11,'libsdisguises.disguise.Silverfish','','',NULL),(399,11,'nicky.set','','',NULL),(400,11,'nicky.del','','',NULL),(401,12,'chatformat.lunar','','',NULL),(402,12,'-chatformat.celestial','','',NULL),(403,12,'-animatednames.group.Celestial','','',NULL),(404,12,'animatednames.group.Lunar','','',NULL),(405,12,'blivtrails.water-splash','','',NULL),(406,12,'blivtrails.end-rod','','',NULL),(407,12,'blivtrails.dragon-breath','','',NULL),(408,12,'blivtrails.damage-indicator','','',NULL),(409,12,'blivtrails.sweep-attack','','',NULL),(410,12,'deatheffects.sun','','',NULL),(411,12,'deatheffects.thunder','','',NULL),(412,12,'deatheffects.coal','','',NULL),(413,12,'deatheffects.iron','','',NULL),(414,12,'deatheffects.gold','','',NULL),(415,12,'deatheffects.diamond','','',NULL),(416,12,'deatheffects.emerald','','',NULL),(417,12,'deatheffects.circle','','',NULL),(418,12,'echopet.pet.type.witch','','',NULL),(419,12,'echopet.pet.type.wither','','',NULL),(420,12,'echopet.pet.type.wolf','','',NULL),(421,12,'echopet.pet.type.zombie','','',NULL),(422,12,'emotes.emote.RIP','','',NULL),(423,12,'emotes.emote.Sleepy','','',NULL),(424,12,'emotes.emote.Surprised','','',NULL),(425,12,'essentials.near','','',NULL),(426,12,'essentials.invsee','','',NULL),(427,12,'libsdisguises.disguise.Horse','','',NULL),(428,12,'libsdisguises.disguise.Blaze','','',NULL),(429,12,'libsdisguises.disguise.Magma_Cube','','',NULL),(430,12,'libsdisguises.disguise.Skeleton_Horse','','',NULL),(431,12,'libsdisguises.disguise.Wither','','',NULL),(432,12,'nicky.color.normal','','',NULL),(433,12,'-nicky.color.0','','',NULL),(434,12,'-nicky.color.1','','',NULL),(435,6,'-SpawnJoin.bypass','','',NULL),(436,6,'-vs.override','','',NULL),(437,1,'greenhouses.player','','',NULL),(438,1,'xr.register','','',NULL),(439,1,'xr.changeemail','','',NULL),(440,1,'xr.changepassword','','',NULL),(441,1,'essentials.warps.pvp','','',NULL),(442,2,'AAC.notify','','',NULL),(443,1,'nfdr.nodamage','','',NULL),(444,1,'chatcontrol.bypass.swear','','',NULL),(445,6,'-auction.noah','','',NULL),(446,6,'-ezprotector.notify.*','','',NULL),(449,1,'ultracosmetics.openmenu','','',NULL),(450,1,'ultracosmetics.command.clear','','',NULL),(451,1,'ultracosmetics.command.gadgets','','',NULL),(452,1,'ultracosmetics.command.menu','','',NULL),(453,1,'ultracosmetics.gadgets.*','','',NULL),(454,1,'ultracosmetics.mounts.*','','',NULL),(455,1,'ultracosmetics.suits.*','','',NULL),(456,7,'playervaults.amount.2','','',NULL),(457,8,'playervaults.amount.3','','',NULL),(458,9,'playervaults.amount.4','','',NULL),(459,10,'playervaults.amount.5','','',NULL),(460,11,'playervaults.amount.6','','',NULL),(461,12,'playervaults.amount.7','','',NULL),(462,1,'onlinetime.own','','',NULL),(463,1,'onlinetime.others','','',NULL),(464,1,'onlinetime.top','','',NULL),(465,1,'onlinetime.team','','',NULL),(466,4,'askyblock.mod.bypassprotect','','',NULL),(467,1,'unitygen.limit.bypass','','',NULL),(468,1,'essentials.warps.gems','','',NULL),(469,1,'essentials.warps.gem','','',NULL),(470,1,'essentials.warps.gemshop','','',NULL),(471,1,'essentials.warps.gemsshop','','',NULL),(472,1,'slashserver.Summit','','',NULL),(473,1,'enchantmentbook.use','','',NULL),(474,3,'askyblock.excludetopten','','',NULL),(475,1,'enchantmentbooktool.get','','',NULL),(476,4,'litebans.unlimited','','',NULL),(477,4,'litebans.unlimited.ban','','',NULL),(478,4,'litebans.unlimited.mute','','',NULL),(479,1,'gangsplus.gang.*','','',NULL),(480,1,'gangsplus.gangchat','','',NULL),(484,1,'mycommand.block.all.use','','',NULL),(485,1,'-tokenmanager.use.shop','','Hub',NULL),(486,7,'hub.dailygems.gaia','','',NULL),(487,8,'hub.dailygems.sky','','',NULL),(488,9,'hub.dailygems.heaven','','',NULL),(490,10,'hub.dailygems.astral','','',NULL),(491,11,'hub.dailygems.celestial','','',NULL),(492,12,'hub.dailygems.Lunar','','',NULL),(493,1,'slashserver.Hub2','','',NULL),(494,1,'tdr.use','','',NULL),(495,1,'tdr.sounds','','',NULL),(497,1,'luckyblock.break','','',NULL),(498,1,'echopet.pet.ride.*','','',NULL),(499,1,'essentials.feed','','',NULL),(500,1,'essentials.repair','','',NULL),(501,1,'essentials.repair.all','','',NULL),(502,1,'essentials.repair.armor','','',NULL),(503,1,'essentials.repair.enchanted','','',NULL);
59/*!40000 ALTER TABLE `grouppermissions` ENABLE KEYS */;
60UNLOCK TABLES;
61
62--
63-- Table structure for table `groupprefixes`
64--
65
66DROP TABLE IF EXISTS `groupprefixes`;
67/*!40101 SET @saved_cs_client = @@character_set_client */;
68/*!40101 SET character_set_client = utf8 */;
69CREATE TABLE `groupprefixes` (
70 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
71 `groupid` int(10) unsigned NOT NULL,
72 `prefix` text NOT NULL,
73 `server` text NOT NULL,
74 PRIMARY KEY (`id`),
75 UNIQUE KEY `id_UNIQUE` (`id`)
76) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;
77/*!40101 SET character_set_client = @saved_cs_client */;
78
79--
80-- Dumping data for table `groupprefixes`
81--
82
83LOCK TABLES `groupprefixes` WRITE;
84/*!40000 ALTER TABLE `groupprefixes` DISABLE KEYS */;
85INSERT INTO `groupprefixes` VALUES (28,1,'&8[&7Member&8]&7 ',''),(29,2,'&8[&2Helper&8]&2 ',''),(30,3,'&8[&3Mod&8]&3 ',''),(31,4,'&8[&4Admin&8]&4 ',''),(32,5,'&8[&5Manager&8]&5 ',''),(33,6,'&8[&6Owner&8]&6 ',''),(34,7,'&8[&aGaia&8]&a ',''),(35,8,'&8[&bSky&8]&b ',''),(36,9,'&8[&eHeaven&8]&e ',''),(37,10,'&8[&cAstral&8]&c ',''),(38,11,'&8[&5Celestial&8]&5 ',''),(39,12,'&8[&9Lunar&8]&9 ','');
86/*!40000 ALTER TABLE `groupprefixes` ENABLE KEYS */;
87UNLOCK TABLES;
88
89--
90-- Table structure for table `groups`
91--
92
93DROP TABLE IF EXISTS `groups`;
94/*!40101 SET @saved_cs_client = @@character_set_client */;
95/*!40101 SET character_set_client = utf8 */;
96CREATE TABLE `groups` (
97 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
98 `name` varchar(255) NOT NULL,
99 `ladder` varchar(64) NOT NULL,
100 `rank` int(11) NOT NULL,
101 PRIMARY KEY (`id`),
102 UNIQUE KEY `id_UNIQUE` (`id`),
103 UNIQUE KEY `name_UNIQUE` (`name`)
104) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
105/*!40101 SET character_set_client = @saved_cs_client */;
106
107--
108-- Dumping data for table `groups`
109--
110
111LOCK TABLES `groups` WRITE;
112/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
113INSERT INTO `groups` VALUES (1,'Member','Starter',1),(2,'Helper','Staff',1),(3,'Moderator','Staff',2),(4,'Admin','Staff',3),(5,'Manager','Staff',4),(6,'Owner','Staff',5),(7,'Gaia','Donor',1),(8,'Sky','Donor',2),(9,'Heaven','Donor',3),(10,'Astral','Donor',4),(11,'Celestial','Donor',5),(12,'Lunar','Donor',6);
114/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
115UNLOCK TABLES;
116
117--
118-- Table structure for table `groupsuffixes`
119--
120
121DROP TABLE IF EXISTS `groupsuffixes`;
122/*!40101 SET @saved_cs_client = @@character_set_client */;
123/*!40101 SET character_set_client = utf8 */;
124CREATE TABLE `groupsuffixes` (
125 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
126 `groupid` int(10) unsigned NOT NULL,
127 `suffix` text NOT NULL,
128 `server` text NOT NULL,
129 PRIMARY KEY (`id`),
130 UNIQUE KEY `id_UNIQUE` (`id`)
131) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
132/*!40101 SET character_set_client = @saved_cs_client */;
133
134--
135-- Dumping data for table `groupsuffixes`
136--
137
138LOCK TABLES `groupsuffixes` WRITE;
139/*!40000 ALTER TABLE `groupsuffixes` DISABLE KEYS */;
140INSERT INTO `groupsuffixes` VALUES (5,1,'',''),(6,2,'',''),(7,3,'',''),(8,4,'',''),(9,5,'',''),(10,6,'',''),(11,7,'',''),(12,8,'',''),(13,9,'',''),(14,10,'',''),(15,11,'',''),(16,12,'','');
141/*!40000 ALTER TABLE `groupsuffixes` ENABLE KEYS */;
142UNLOCK TABLES;
143
144--
145-- Table structure for table `playergroups`
146--
147
148DROP TABLE IF EXISTS `playergroups`;
149/*!40101 SET @saved_cs_client = @@character_set_client */;
150/*!40101 SET character_set_client = utf8 */;
151CREATE TABLE `playergroups` (
152 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
153 `playeruuid` varchar(36) NOT NULL,
154 `groupid` int(10) unsigned NOT NULL,
155 `server` text NOT NULL,
156 `negated` tinyint(1) NOT NULL DEFAULT '0',
157 `expires` datetime DEFAULT NULL,
158 PRIMARY KEY (`id`),
159 UNIQUE KEY `id_UNIQUE` (`id`)
160) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8;
161/*!40101 SET character_set_client = @saved_cs_client */;