-- MySQL dump 10.13  Distrib 8.0.29, for Linux (x86_64)
--
-- Host: localhost    Database: GW
-- ------------------------------------------------------
-- Server version	8.0.29-0ubuntu0.20.04.3

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 `Gang`
--

DROP TABLE IF EXISTS `Gang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Gang` (
  `gid` int NOT NULL AUTO_INCREMENT,
  `gangnm` varchar(16) NOT NULL,
  PRIMARY KEY (`gid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Gang`
--

LOCK TABLES `Gang` WRITE;
/*!40000 ALTER TABLE `Gang` DISABLE KEYS */;
INSERT INTO `Gang` VALUES (1,'Attacker'),(2,'Defender');
/*!40000 ALTER TABLE `Gang` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Toon`
--

DROP TABLE IF EXISTS `Toon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Toon` (
  `pid` int NOT NULL AUTO_INCREMENT,
  `gid` int NOT NULL,
  `toonnm` varchar(16) NOT NULL,
  `gw` float unsigned DEFAULT '5000',
  `val` double unsigned DEFAULT '1000000000',
  `outs` int unsigned DEFAULT '0',
  `bg` int unsigned DEFAULT '5000',
  `punk` int unsigned DEFAULT '4000',
  `og` int unsigned DEFAULT '3000',
  `merc` int unsigned DEFAULT '10000',
  `dl` tinyint DEFAULT '0',
  `tw` tinyint DEFAULT '0',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Toon`
--

LOCK TABLES `Toon` WRITE;
/*!40000 ALTER TABLE `Toon` DISABLE KEYS */;
INSERT INTO `Toon` VALUES (50,1,'Att01',5000,1000000000,0,5000,4000,3000,0,0,0),(51,1,'Att02',5000,1000000000,0,5000,4000,3000,10000,0,0),(52,1,'Att03',5000,1000000000,0,5000,4000,3000,10000,0,0),(53,1,'Att04',5000,1000000000,0,5000,4000,3000,10000,0,0),(54,1,'Att05',5000,1000000000,0,5000,4000,3000,10000,0,0),(55,1,'Att06',5000,1000000000,0,5000,4000,3000,10000,0,0),(56,1,'Att07',5000,1000000000,0,5000,4000,3000,10000,0,0),(57,1,'Att08',5000,1000000000,0,5000,4000,3000,10000,0,0),(58,1,'Att09',5000,1000000000,0,5000,4000,3000,10000,0,0),(59,1,'Att10',5000,1000000000,0,5000,4000,3000,10000,0,0),(60,1,'Att11',5000,1000000000,0,5000,4000,3000,10000,0,0),(61,1,'Att12',5000,1000000000,0,5000,4000,3000,10000,0,0),(62,1,'Att13',5000,1000000000,0,5000,4000,3000,10000,0,0),(63,1,'Att14',5000,1000000000,0,5000,4000,3000,10000,0,0),(64,1,'Att15',5000,1000000000,0,5000,4000,3000,10000,0,0),(65,1,'Att16',5000,1000000000,0,5000,4000,3000,10000,0,0),(66,1,'Att17',5000,1000000000,0,5000,4000,3000,10000,0,0),(67,1,'Att18',5000,1000000000,0,5000,4000,3000,10000,0,0),(68,1,'Att19',5000,1000000000,0,5000,4000,3000,10000,0,0),(69,1,'Att20',5000,1000000000,0,5000,4000,3000,10000,0,0),(70,1,'Att21',5000,1000000000,0,5000,4000,3000,10000,0,0),(71,1,'Att22',5000,1000000000,0,5000,4000,3000,10000,0,0),(72,1,'Att23',5000,1000000000,0,5000,4000,3000,10000,0,0),(73,1,'Att24',5000,1000000000,0,5000,4000,3000,10000,0,0),(74,1,'Att25',5000,1000000000,0,5000,4000,3000,10000,0,0),(75,2,'Def01',5000,1000000000,0,5000,4000,3000,10000,0,0),(76,2,'Def02',5000,1000000000,0,5000,4000,3000,10000,0,0),(77,2,'Def03',5000,1000000000,0,5000,4000,3000,10000,0,0),(78,2,'Def04',5000,1000000000,0,5000,4000,3000,10000,0,0),(79,2,'Def05',5000,1000000000,0,5000,4000,3000,10000,0,0),(80,2,'Def06',5000,1000000000,0,5000,4000,3000,10000,0,0),(81,2,'Def07',5000,1000000000,0,5000,4000,3000,10000,0,0),(82,2,'Def08',5000,1000000000,0,5000,4000,3000,10000,0,0),(83,2,'Def09',5000,1000000000,0,5000,4000,3000,10000,0,0),(84,2,'Def10',5000,1000000000,0,5000,4000,3000,10000,0,0),(85,2,'Def11',5000,1000000000,0,5000,4000,3000,10000,0,0),(86,2,'Def12',5000,1000000000,0,5000,4000,3000,10000,0,0),(87,2,'Def13',5000,1000000000,0,5000,4000,3000,10000,0,0),(88,2,'Def14',5000,1000000000,0,5000,4000,3000,10000,0,0),(89,2,'Def15',5000,1000000000,0,5000,4000,3000,10000,0,0),(90,2,'Def16',5000,1000000000,0,5000,4000,3000,10000,0,0),(91,2,'Def17',5000,1000000000,0,5000,4000,3000,10000,0,0),(92,2,'Def18',5000,1000000000,0,5000,4000,3000,10000,0,0),(93,2,'Def19',5000,1000000000,0,5000,4000,3000,10000,0,0),(94,2,'Def20',5000,1000000000,0,5000,4000,3000,10000,0,0),(95,2,'Def21',5000,1000000000,0,5000,4000,3000,10000,0,0),(96,2,'Def22',5000,1000000000,0,5000,4000,3000,10000,0,0),(97,2,'Def23',5000,1000000000,0,5000,4000,3000,10000,0,0),(98,2,'Def24',5000,1000000000,0,5000,4000,3000,10000,0,0),(99,2,'Def25',5000,1000000000,0,5000,4000,3000,10000,0,0);
/*!40000 ALTER TABLE `Toon` 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 2022-07-26  9:46:34
