-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jan 02, 2023 at 04:34 PM -- Server version: 10.4.27-MariaDB -- PHP Version: 8.1.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `pokemon` -- CREATE DATABASE IF NOT EXISTS `pokemon` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `pokemon`; -- -------------------------------------------------------- -- -- Table structure for table `ability` -- CREATE TABLE `ability` ( `id` int(11) NOT NULL, `monsterId` int(11) NOT NULL, `name` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `type` int(11) NOT NULL, `power` float NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -- Dumping data for table `ability` -- INSERT INTO `ability` (`id`, `monsterId`, `name`, `description`, `type`, `power`) VALUES (1, 1, 'Thunderbolt', 'Thunderbolt desc', 0, 1000), (2, 1, 'Light Ball', 'Light Ball dedasdasdsa dasdas', 1, 2500), (3, 1, 'Heal light', 'Heal light fgdsfdsfsd', 2, 500), (4, 1, 'Rock', 'Rock Shild', 3, 700), (5, 2, 'Fire Spin', 'Fire Spin fdsfsd', 0, 2500), (6, 2, 'Fire Blast', 'Fire Blast special desc', 1, 3000), (7, 2, 'Earthquake', 'Earthquake heal', 2, 600), (8, 2, 'Toxic ', 'Toxic Shield', 3, 1200), (9, 3, 'Sleep Powder', 'Sleep Powder descdsa', 0, 1000), (10, 3, 'Swords Dance', 'Swords Dance dsadas', 1, 2500), (11, 3, 'Leaf Heal', 'Leaf Heal dfsadasdsa', 2, 1000), (12, 3, 'Rock Shield', 'Rock Shield dfsadas', 3, 1500); -- -------------------------------------------------------- -- -- Table structure for table `history` -- CREATE TABLE `history` ( `id` int(11) NOT NULL, `player` int(11) NOT NULL, `pokemon` int(11) NOT NULL, `time` date NOT NULL, `result` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -- Dumping data for table `history` -- INSERT INTO `history` (`id`, `player`, `pokemon`, `time`, `result`) VALUES (1, 5, 2, '2023-01-02', 1), (2, 2, 1, '2023-01-02', 0), (3, 5, 2, '2023-01-02', 0), (4, 2, 1, '2023-01-02', 1), (5, 2, 1, '2023-01-02', 1), (6, 4, 3, '2023-01-02', 0); -- -------------------------------------------------------- -- -- Table structure for table `monster` -- CREATE TABLE `monster` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `hp` int(11) NOT NULL, `base64Image` varchar(15000) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -- Dumping data for table `monster` -- INSERT INTO `monster` (`id`, `name`, `description`, `hp`, `base64Image`) VALUES (1, 'pikachu', 'munja', 2500, '/9j/4AAQSkZJRgABAQAAAQABAAD/4gHYSUNDX1BST0ZJTEUAAQEAAAHIAAAAAAQwAABtbnRyUkdCIFhZWiAAAAAAAAAAAAAAAABhY3NwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAA9tYAAQAAAADTLQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAlkZXNjAAAA8AAAACRyWFlaAAABFAAAABRnWFlaAAABKAAAABRiWFlaAAABPAAAABR3dHB0AAABUAAAABRyVFJDAAABZAAAAChnVFJDAAABZAAAAChiVFJDAAABZAAAAChjcHJ0AAABjAAAADxtbHVjAAAAAAAAAAEAAAAMZW5VUwAAAAgAAAAcAHMAUgBHAEJYWVogAAAAAAAAb6IAADj1AAADkFhZWiAAAAAAAABimQAAt4UAABjaWFlaIAAAAAAAACSgAAAPhAAAts9YWVogAAAAAAAA9tYAAQAAAADTLXBhcmEAAAAAAAQAAAACZmYAAPKnAAANWQAAE9AAAApbAAAAAAAAAABtbHVjAAAAAAAAAAEAAAAMZW5VUwAAACAAAAAcAEcAbwBvAGcAbABlACAASQBuAGMALgAgADIAMAAxADb/2wBDABALDA4MChAODQ4SERATGCgaGBYWGDEjJR0oOjM9PDkzODdASFxOQERXRTc4UG1RV19iZ2hnPk1xeXBkeFxlZ2P/2wBDARESEhgVGC8aGi9jQjhCY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2P/wAARCAB2AHYDASIAAhEBAxEB/8QAGwAAAgMBAQEAAAAAAAAAAAAAAAEDBAUGAgf/xAA6EAABAwIDBAgEBQIHAAAAAAABAAIDBBESITEFQVFhBhMiMnGRodEUgbHBQlJi4fAVIyRjcoKywuL/xAAZAQEAAwEBAAAAAAAAAAAAAAAAAgMEAQX/xAAfEQADAAIDAQEBAQAAAAAAAAAAAQIDERIhMUETIjL/2gAMAwEAAhEDEQA/APoCSaSAaEiQBc5BcZRdKHbR6axU8LyKSzo2tGjsicR+Y/maA7RCEIAQkhACaSaASaEIBIQhACEIQDQhCAxulVTNDsZ8NK0uqKpwgjA56+gKw9g9GYNlSwVEzjLW9Y27wThbc5gD7ldLX2NVF+ljj4XI9ioWNLqumA0xknwDT97LNkyP9FKLJS47NZCSa0lYJKOaoigaDK+19BqT4DUqlJWTyi0TRC3i6znew9VCskx6zqlvw0VBNXUlObT1UER4PkA+q5/b9Y2j2RUTzPdI/AWsxm4LjkMtPIbl8xpaeaqnZFTxvlkcbBrRclcjIrW0dc69PtUG1dn1EwhgraeSR2jWSAkq4ua6K9Gv6UwVNXhdWEWAGYjHvzW7VVTacBoGOV3dZfXmeAU20ltkT3POyBoLrlxya0auPJQwTzOqTHMGAOZiYG3ysbEE79QoIb4jJI7HK7V32HAIfNhnhcd0gB54uz9SPJU/sm0T4PRpISQryA0k1Xr6kUdHJOcy0ZDiUBWrM69jW5kxnFb8OeV/MqP4ZrpMb3yXtYYXlth8vBZXRzar9o08kzopGEOs8vt2nXOluWH9gtXrC5oJGHkdyw5KStv6XSutEVXLBTse+SSRoY0vcWucSGjebbk4J3mJslNUucxwu0ud1jTffnn6rC23sSr2lVdfSVpjimiEcrMZAc0Endrqr1LLT7Lo4qQF8ghGEvA33zUXT0nL7JKdvWi4zCwkvcXSHvPdmT/OCZnYHBtyXHRoFyfAKCUCePEwjPtNO7l8ltUPUupmSQRNja8XLWgCx3g80x4/0bbZyq4+HNbU6PVfSCeFs8nwlDF2ravkPG27LjnrktzZGxKDY0WCigDXEWdI7NzvErQUFXVNpYsRGJ7smM4n25rdMqJ0UttsVZVCnaA0B0r+637nks9t7ue52KR3ecd/7KG73PMkjsUju8fsOAXoOKw5crt6XhfMaJw7coqk/wCHkcM3Nbib4jMeqA5SRRyVQtELNORkd3flx/marmab6OtpLs1gQQCNCheY2CONrASQ0AAlC9QzHtZXSB0jKaB8ZthmzuLi2FwzWoo6mnZVU74ZRdjxY21HNcpbWjsvTTZiRRxz0bPhyYGObkI7C1/3XMVEtTifTzzSuIJa5peSCukigl2cwU0zs8RwO0D8ycvZQVFGJqj4hha2UjCS4XBHusMNY6ao09Pwu002Ojgkf3nxtcRzIWA6R+ExvtiabO8VtxsDI2sByaAEjDGXiQxsLxo4tF/NVzSTZZF8TxStMdLE1wsQ0XHDktLZMuGSWA7/AO436H1sfmsw1ILjZtmAXL3XA9ATz00zVlokgeycC5jzIB1G8eXrZTx1wrbKb/pG6snakbm1bJjmx7MA/SRc+o/4+C1I3tljbJG4OY4BzSN4Kjq4BU0z4icJcOy7gdQfNbbnlLRRL09mNdLF2g1oLnu0a0XJVRkxcWB7hGS4McdcGdj5LpKalipmWjGZ7zjmXeJWPHhdel1XoqU2zi7t1djwiGY+fHw08Vo6JoW2ZUrSKW2/QQhCkcIKyc01M+UNLnDJo5nRZzayWqBJmLWg2Ijbhv4k39FpVUAqYHRk2OoPA7st6pN2fPE2zHQyE8QWe6pyrI/8E54/SAwRON3MDnfmdm7zOaHRA5tU3U1TR2qfEf8ALeD9bKKJ0hL2zRmN7XWwkjTUHJYai13RcmvhEWkaheJGudG5rHYXEZHgraLDgobOma2JzWQtjYBAWWAvppYW8/JXaewibH+VoC9GJovYWub/ADQxmE3uut7B72VeiPwjn4oXEmG4zbvw895Hz5KntPaks7308QdFE0lrjo53sPX6K1IwSRlt7E6HgdxVCpeyr2aayYtp62HsTMdkJCOHju8vDXjyVc6+oqcpPZDS0UtdeOFoEfdc8jst5czy+i6qNpZG1hcXFoAxO1PMrnej22m4m0M9mg5Qu3f6fby4LpVfjSS6IW3vsSaEKwiCEkIAQhCAazq1uGtY4DOSMg/7T/6WiqO0ey+nfbVxZ4XF/wDqFXlW4ZKfSui6Lry97G95wC8w0Hq/FFlEJ4j+ML11rN7x5oD1oue22xpnZN+rASBc21+3qtmWqaAQzM8VXpqeOprqeOZgkZjJc1wuD2XK3Ev6Ryn0aGyNl7MZDHVUw68nNskmZHy3Eea1l5iijgjEcMbY2DRrRYBe16KWjM3sSaELoEhNCAEkIQDUc8LJ4nRyDsu4ajmpEkBgVcNbRse515YWAkyNtcDmNfK6qUnWbQqupi7JwlxfIMrC27U6jgupexskbmPF2uBBHELN2bsj4CrdL1ge3AWNysbE3z8gFQ8M8tos5vQDYkOGxnmLuPZ9lXm2PUMzhkZKODuyfY+i3EKbxy/hHkzlamKeka109O9rXOwg3ac8zuPJXOj5bLUzvcBjY0Bue4k3+gWvW0rKymfBJo7Q8CqWy9myUc0j5HMN2hoLfxaXJ4aDLxUFi40mjrra7NRCEK8gCEJIBoQhACSEIBoQhAJNCEAIQhAJNCEAk0IQAhCEAkIQgP/Z'), (2, 'charizard', 'vatra', 3000, '/9j/4AAQSkZJRgABAQAAAQABAAD/4gHYSUNDX1BST0ZJTEUAAQEAAAHIAAAAAAQwAABtbnRyUkdCIFhZWiAAAAAAAAAAAAAAAABhY3NwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAA9tYAAQAAAADTLQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAlkZXNjAAAA8AAAACRyWFlaAAABFAAAABRnWFlaAAABKAAAABRiWFlaAAABPAAAABR3dHB0AAABUAAAABRyVFJDAAABZAAAAChnVFJDAAABZAAAAChiVFJDAAABZAAAAChjcHJ0AAABjAAAADxtbHVjAAAAAAAAAAEAAAAMZW5VUwAAAAgAAAAcAHMAUgBHAEJYWVogAAAAAAAAb6IAADj1AAADkFhZWiAAAAAAAABimQAAt4UAABjaWFlaIAAAAAAAACSgAAAPhAAAts9YWVogAAAAAAAA9tYAAQAAAADTLXBhcmEAAAAAAAQAAAACZmYAAPKnAAANWQAAE9AAAApbAAAAAAAAAABtbHVjAAAAAAAAAAEAAAAMZW5VUwAAACAAAAAcAEcAbwBvAGcAbABlACAASQBuAGMALgAgADIAMAAxADb/2wBDABALDA4MChAODQ4SERATGCgaGBYWGDEjJR0oOjM9PDkzODdASFxOQERXRTc4UG1RV19iZ2hnPk1xeXBkeFxlZ2P/2wBDARESEhgVGC8aGi9jQjhCY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2P/wAARCAB2AHYDASIAAhEBAxEB/8QAGwABAAIDAQEAAAAAAAAAAAAAAAQFAQMGAgf/xAA1EAABAwIEAwYGAgEFAQAAAAABAAIDBBEFEiExE0FRBiJhcYGhFJGxwdHwMvFSIzNCg7Lh/8QAGAEBAAMBAAAAAAAAAAAAAAAAAAIDBAH/xAAjEQADAAIDAAIBBQAAAAAAAAAAAQIDERIhMQRBIhMUYYHw/9oADAMBAAIRAxEAPwD6AiLCAyiIgCwiygMLKLCALKIgCIiAIiIAiIgCIiAIoOJ4nDh0V3ubxD/FpPufBc7L2jrXXMZcB4MAHuub70jvSW29HVT1MNPl40gZnNm35lQMXrpKR7WtcWte3ukC5Jvr9vmqvAJRitcZ6hxkyNzNa83sb/b7q9xOkNXThrLZ2m4vz8FB8nL0TXFUt9opKXFpoWZeJmJ5Ta6+d1Oocb4sojq2xxFwuHNOg8/yqeemlhNpI3N5d4W/taA1sdzfKNzYbeizzkqXpmisc0to7dZVTRQVtM+IRytnpX2NzplHkdlarWnsyNaCIRcEXIvzCpsNxHgVUlBVylz2vIZI43v4E/TzsjeglsuVlEXTgREQBUfaHF5aIsgpiOK/c22/bH2VvUTspoHzSGzWC5XCS1RraqWrkI7xOXoB+/QIlyeiN1wnZghz5DLM8ySHUudqvM5tC8+ClNoqt7czaWct68MqLMAYnX25+S0LS8MN8n2yR2en+BxCInRsg73rv9j6Lu185BdkY4WzDXXbZW+G9r8rhFXMJtpn5j8+yopNU39GvFacJb7R1sjGyxuY8AtcLEHmFx0sXDeWO3Gh8+a62nqYaqPiQSB7fDkubrGZppzzEr//AEVmz+Jm3B60dBhsvGw+F5NzlsSeZGn2UlVPZ6XNBNETcscHDwBH/wAKsaiphpWZ55WsHidT5Dmrpe5TKaWqaNeJVrMPopKiS3dHdHUr5rUVM9TVGZz3ZnEndXfaXFm4lNFTU5PDB1vzP79PFU9TGI5AG9FdjlV2zH8nLUfjJ03Z/F3wvbT1shLHgBridGn7BdUvn1g9guNCLq47P4pUMrY6GofnicCGE8v3ZRqOPnhbjy8+n6dUiwiiWlP2qe5mCSlvPQ/IqF2UwkCkjraloLnaxNI0aP8ALzVtjlK6swiohYCXltwBubdFNia1sTGsblaGgBvQdET0ccp6bPa5XtZQGOM1cDe7J3ZABsevr+7rqlpq4op6WSOf/aI73hzuup6ezlzyWjjKHCK6ujzwxtZHyfK7KHeVgSVW1uDVkVU9gYyWx1dG67b9NbLr5sUMkZhpmiKIDKHDct8Om39LbhlLSyUrpJWhxBIdm2aB09LG6h+u3XGTv7WZndHMYZQ1kDS58oiLSCwDUgq2GZ7DI7dziXaW15qJS0sscrxxpHsdIeG0kkht9N/BXbKC8YEjyDvZqxW3bZujjjlFLKamAkUzy1r/AOVjYnpqqSqixOomPEjlJPjf5nmuqxGidFDnjdmA3vuFuwTDI5cKjlqS508lyXNdbLroANlbhdfWirNwpff9HG0tHUQyMllgkZGb2c5hAJ6XSpbJPXCGJpdI6zWtHMrrc/w/Gp5Mk0LrteL2B8R0K8dmsKbHWVFbKQ54OSMHdotufE7fNbMedUv5MGX4rTWvGVlZhtRhcMXxJY5pFszDseh/KhGo+Hq6aZu7JA7zXVYnFnxqnc42aI+vmqDtLhsdJNST04AjndYsbs1wIvbp5eC5OXk3L+iV/H4can/dncotVK4vpIXHdzGn2RcLTaiLKALG6jV9bHQw5395x0a0buK5qsxetnJtI+MX0bFpb13UKtT6WRjqvC/OFRfFtkGXgNbbgZBlvr+dlXyWpKU0UcxmcXXlfaw2At7D5FQKKvxGSTg/ESZCO8XWJt57hbyABYaALPkyrX4l+PE9/kTcOhBzSncHK37qeVWYfVZafKRcBzrEeam/Este/pZVpdELe6Z5q3AMA5krODOycemvowh7R0DuXzBUWV5kdmO3JROJNDX8eBwDmsDTcaHUm30VkUoe2R4uukTpcFkbTNjhla9+fV8lx3LWtpz2VlS0cNKZDE2xkNzr7DoEo6plXCJG6HZzebSpC0zM+ordV4ymq2itlkiDiHNOdpIIuNbe5so9ZGMVwuGGJjxNHMwnMOeve8tSpk8zoqxtPHDxZ3ZnWBGjb3uTy5KbS05hD3Odme83NhoPALPjmubb8LapcEjdGwRxtY3+LQAEWUWooMosLKA5LGaoyYnM2S44ZytHQWv77qvdOOQ+a6vFMJjrrSNytmAtcjQjxVO/CKmJr3ugY1rAXF1xsPdZ6xN1s0zmSnRDoJjG5zz/AMr69LfpW6SfORGzdxtrzWnIYxYkefU81PwvDnVjZJA9rALN1bmvz6+KoU8qLqvjOzbBGIYWtvfmT4r2CpTMEYP5Tv8A+sZfytzsHpHMIcJSTz4jvpe3sr1iZkdlRUVkMByueC//ABv9ei1Qvzgkm7iblT5ezcJFop3NHR7Q76WUCrwqTDrFrs8ZFy5rLBp8VDJietluK1vR7ZiAoJGzMs4E5XNva4/te5Meq6lwio4AxztBYZj6f0oUTP8AWYaiNxjBBdlNtDpe/wC+i6qjhpo4WupWNaxwvcDU+fNTxTXHTOZanltGjCqA0cTnzOL6mXWR5N/T0U9YRaDOZREQBFhZQBeJo+LC+Mm2dpbfpde0QFc/CYpZH53OLH2cTm7xda1z+Nt1LpoeBDkuCcxcSBbUkn7rciAwsoiAIiIDQ+kp3lxdC0l25tYrdssogCLCIDKIiAIiIAiIgCIiAIiIAiIgMLKIgCIiAIiID//Z'), (3, 'bulbasaur', 'zemlja', 2500, '/9j/4AAQSkZJRgABAQAAAQABAAD/4gHYSUNDX1BST0ZJTEUAAQEAAAHIAAAAAAQwAABtbnRyUkdCIFhZWiAAAAAAAAAAAAAAAABhY3NwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAA9tYAAQAAAADTLQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAlkZXNjAAAA8AAAACRyWFlaAAABFAAAABRnWFlaAAABKAAAABRiWFlaAAABPAAAABR3dHB0AAABUAAAABRyVFJDAAABZAAAAChnVFJDAAABZAAAAChiVFJDAAABZAAAAChjcHJ0AAABjAAAADxtbHVjAAAAAAAAAAEAAAAMZW5VUwAAAAgAAAAcAHMAUgBHAEJYWVogAAAAAAAAb6IAADj1AAADkFhZWiAAAAAAAABimQAAt4UAABjaWFlaIAAAAAAAACSgAAAPhAAAts9YWVogAAAAAAAA9tYAAQAAAADTLXBhcmEAAAAAAAQAAAACZmYAAPKnAAANWQAAE9AAAApbAAAAAAAAAABtbHVjAAAAAAAAAAEAAAAMZW5VUwAAACAAAAAcAEcAbwBvAGcAbABlACAASQBuAGMALgAgADIAMAAxADb/2wBDABALDA4MChAODQ4SERATGCgaGBYWGDEjJR0oOjM9PDkzODdASFxOQERXRTc4UG1RV19iZ2hnPk1xeXBkeFxlZ2P/2wBDARESEhgVGC8aGi9jQjhCY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2P/wAARCADqAP8DASIAAhEBAxEB/8QAGwAAAQUBAQAAAAAAAAAAAAAAAAECAwQFBgf/xABHEAABAwIDAwkEBwUGBgMAAAABAAIDBBEFEiExQVETIjJhcYGRobEGUsHRFCMzQmJy4RVDU4KSJHOisvDxNURUg8LSY5Pi/8QAGgEAAwEBAQEAAAAAAAAAAAAAAAECAwQFBv/EACURAQEAAgICAgICAwEAAAAAAAABAhEDIRIxBEETUTJhFCJxsf/aAAwDAQACEQMRAD8A9ASJUiAVCEIAQhCAEIQgBCEIAQhCAEISIBUJHODWlziABtJ3Kk/F6JujJTMf/iaXjxGnmgLyFlnGPcop/wCYsHxKT9ryb6J1uqQKfLH9luNVCzBjLd9HUj+j/wBk4YzT/fjqGdsRPpdPyn7G40UKgMXoj9+QdsLx6hL+16H/AKgf0n5I3DXkLPfjNI0cwTSHgInDzIA81lV2M1FQCyH+zxnaWm7z37B3X7UrnIVsi9i+LinzU9KQ6oPSdtEfb19Xj14EU0tLUtqofrJwecXu6YOhzHz7k1rQ0WAsEkkjY25nHqA3krny5Lb0yuVtWqfFZ6StjnqJppmyEtey9wdCRZuwagK7Bj1U6riEsUIhkkazK0HM25sNb67eCxY2OLuVkHO2Bvuj5qRxe1zHxZc7HteM2zQg/BOclnRzKu4QueoPaBsTpW4nOwAAOY8N1PEWC6AEEAg3BXRLLNxpLsqEITMIQhACEIQAhVf2jR8oYzUxtcDl5zrXPAX2qygFSJUIAQhCAEIQgBZdVihL3RUQa4tNnSu6LTwHvHy9E3FKp0kho4XFoAvM8HUA7GjrO/gO1VGtDWhrQA0CwA3LLPPXURllr0a+PlnZql7p3bRyhuB2DYPBK+RkYu5wChqank+azV3oqLnFxu4knrWFu2dq66tYOi0nyTDXHcweKqIU7Ja+mv8Acak+mye61VM135GNc95+63b+nerDKGd+skjYhwYMx8Tp5FPszvpkvBvgmurJbdIN7lM3DqcdPPIfxPOvcNPJSCipW7KaEfyBPQZ0lS0/aTN73JrZWu6GaT8jS70Wu2KNnQY1vYLJ6NQMpkFTJ0Ycg96Q28hr6JjoGRy3zGR40zH4Dcr9TUBgLGHnbzwVFIBI4hoJOwJVSxGUiPk2mxPqdiJNkiiY7EKtrBtneI29Tb7fUr0gAAAAWAXCez4a3HKIbg5wH9Dl3i6eP01w9BIlQtFhCEIAVPEJnNYyCJxbLMbBw2tb953+t5CtrNa7lq6eba1h5Jnd0j46fyoK3QeYaaBrC0CMDKGgX0VISxRG9IZac8GWy/0nT4orZM85A2N0VckAXKTly5LL00YMaynLWR5R/FjBLe8bR59q1I5GSxiSN7XscLhzTcFcq6obezGvkP4W6eJ081PRwVwdy1I6OnzG7ruzZvzNGnfe/Wm0w5Leq6ZCzuUr/wCPTf8A0O/90Z68/wDMU47ID/7IbbjRUFZUClpZJyM2UaN947AO82CpudVt1fWtaOqMD1VSq+va1suISuDXBwDWNtcdyCuciKJrms57s0jiXPdxcdpTKmbkmWHSOxNeZW/Zztd+eL5O+CqTNqnvLzHG4fhfr4EfFc1wyY+U/aMm5uUJhe5n2kUjP5bjxFwgTRlpcJGlo2kFZ2WewehjHzy8lEbW1c/3R81Yp8PqqmxazkYz9+Uansbt8bK4zD6Oijyyl9S8m5DzoT1gaeN1pjx2+z9d1BC+kp28nG9u3nEG5v8AiPzVpQVTzPTviIDYy0gMaLBZ1NVzuiyOkdmjOUneeHlZPPDxmymUvpsJjpY27XtHesxz3O6Tie0pFls2g6ribsu7sCry1b3izeaPNV0JbIIQhACyp3cpUt7S7w0+K1HmzHHgFku+2Z+Uj0VYhYpZ/o1XBUHZFI1x7L6+V16KvNSLixXcez1YKzCYrm8kX1b+NxsPeLHvW/Hfppx36aaEIWrQIQhARzytggkmf0Y2lx7ALrOgBp6FvKdMNzP63HU+ZKs4qf7C5n8R7GHrBcAfK6pVFQ1znxhuaNnTdf725o+KEZ3pRNybnekSuJcSSkScQUkMz4XZmntHFRqvV1kNI28jucdjBqSgT+mo7EHEc2MA9ZuoJayTKS+XI3tsFzdRitTKSIyIW/h1PiqTyXuzSEvdxcbnzVzCneS/t0UmJ0jTzqhrj+G7vRMbi1ETblSOsscB6Ln0J+ER5OsBBAINwdhCVUsJilhow2YEXcS1p2tHD18VdWagrdDQwNIq5Mss25xHQHAfNVEIVjl41eqa212w97vkqJJJuTcoQgssrl7B2LHiOWpI3PbfvH+/kthY0nNfG73XgeOnxSym8arjWkIQuNqEIQgBCEIBkv2T/wApWXLoA/3Tfu3rTnNoX9iz9qrEBans5XfQ8Tax5tFUWY7qd90/DvWPHzbxn7uzrCeRcWVy6ol1XpaVZ+B1/wC0MNjkebys5kn5hv79D3rQXS6AhCTZtQGdjGeRtPBC4CV8ma51ytG13dcd5CzpyxuWKLSOPQdZ3lWHz3ilrXGxm0jv91g2eOp7+pUkObmy+ghCZJLHC3NK9rG7LuNgkwOfmDHZBd1tAeK5Rz3yPc+UkyE84nbfgupjljmbmie17dl2m4UFXh8FVdzm5ZPfboe/iqxuis+nOIV6TCapkmVgbI3c4G3iP91apsGaCHVL8/4G6Dx2nyV+UT41m01LNVPywt0G152BblHh0NLzunL75+HBWmMaxoaxoa0bABYBKouVqp16CEIUmEIQgBCEIAWRWRkcqwbdbfBa6gqYBKLt6Y804eN1VSKZkrQ5jgbi9k9ZTAWXbqCxxb4GyuU9RmOR513HiuO46brKEIUgIQhAQ1RtCRxNlRVmsfdwYN2pVZXPRI5eblk93b2KRIQCCDsKbESWAHa3Q9yZtj2crvoeJiN5tFUWYep33T8O8Ltl5mRcWuR1hd9g9b9PwyGdx+stlf8AmGh+fetuO9aaYXrS8qWKOJp207TZ1Q7k9NzdrvIHvIV1ZdRK0100zzaOljy34E853ll81ouqta2SpqW0lO1pcG3N+iwcT8Bv8ViwVUMOIuoYpHSMFwHOtbONrRbd8ituvmfhmDSznmVlU63W0kbP5WjxHWuIkJhlZJHtYQR2jZ6IVj8bzwuVdYsHGeU+nAPN2ZQWDcOPf+i3WOD2Ne3Y4XCrV9E2sjaM2R7TdrrX7QiXVeciwVtsPB95zj52+CvqOnhbTwMiabhotc7+tPe5rGOe8gNaLkncEUFQsGrxWWclsBMUfH7zvkp8Ba69Q8klpLRqd+t/UJ+Nk2GuhCa8Oe5kUZs+V2UHhxPcLlSJN3R0URqcziS2njPPcDYvPuj4nu7FcczidlzfRWasshjZTRCzGAaKm97Y25nbOrUk8ELy/UK5wY0ucQGjUknYsirxuxLaRod+N2zuCp4pVzT1D4pOYyN1sgO8ceJUVLRT1cojgidI8gnK3bYb03bw/EmvLN0FBUx1NOHMe5xGjg62YHrsrK52ll+iStljBsNHt4j5roWuD2hzSC0i4I3pMPk/HvDl/VKhCEOZj1VJKaiokiGcB4JYNtso1HHW+ipggi4W8zStlHGNp83fooK2gbMTJFZku/g7t+ajLDfcaTL6qnBU/dkPYVaBuLhZZDmuLHtLXt2tO0JzXuZ0XELnuK2kopp2xi213BUzLI7a8piNGVxLiSdSUiEKiCY3SV442d8Pgnpg+3d+UepQD10XsfUWlqaUnRwErR5H/wAVzq0MBnFPjMD3GzXBzXHqyk+oCrC6qsL27pxDWlzjYAXJKxadpqBTMcNZ3mokB3Nvmt4lo7FexR16XkB0qh3Jdx6X+EFNoW56ypk3MyxDq0zH/MPBdDa+2B7XVHKV8NODzYo8x7XH5DzTaykZT+xIeWjlJXslJ36kW/w6Kh7QPMuL1pHvZR3NA+C2fbORsGE01KzTNILD8LR8yEp7dmXWGGM/6qYac2HU5P8ADA8lZVbDRbDqb+7afJWUPFy/lQoquMy0k0bek+NzR2kKVCCc1T0VRUkZIy1u9zxYD5rfpKZtLTtiab21JO88VMhO5Wl69BTUroo5TK8c9rSG9+30ChQkqXV2V7i9xc46nUqSgh5Zwqnjm/uR1e937urtUBj5eWOn3PuX/lG3x0HetyKMNjdIRzWAkDsVT9teLHfbz3Lyk0kztS95f4m66z2OgAgqakjnOeIx2AX9XeS5WLSJn5Qu09lAP2K07zI+/ionde18ieHFJHMYvGIsYrGAWAlLvEB3xVnCJrxPgJ1jN2/lP638lBjTw/Gqxw2cpbwAHwUNDJyddEdzrsPf+oCPtHyOP8nxpfuTbdQhCbwkLhatYeMbr9xb8ypk0tu8O4Aj0+SpYzJNFStMTi0F9nOboQP97ICerpI6pvO5rx0XjaP0WPNFJTycnKLHcRsd2Kk4B3S5x4u1TeTZuaAeIFinlxbPHkkXEKGOU3DJNu53H9VMubLG43VbS79BCEJAJkernu4mw7B/ookcb5GdI+Q4pzQGtDRsGiDKmySGJvKDa3YnKOoaXwuaNpTx9ie3cyTtkqpKlx+qivFH1m/OPiAO48VHQYlFTmVtUHR55C8SAXbrsvbZoN+iocoWQMikIb9Gbybr6AFuhPlfsQ0hzQQbgi4XSWXLZkxMUe2XEqx0L2vDpHFrmm4N0vtDiTsVnZK2NzGMaGRsdtudvibeAWrLS08xvJCxzvetr4qJuG0jXteIzdpDhd7iLjquk6/83C4zePcixEwRRMjGxrQ3wT0JxjcGB5aQ06AoeaahCEAIQhACEIQFjCIeWqZ38CI+4C5/zeS3nMBjLNgIssfBaqkgpXMlqIo5nSPJa9waekbbeqy1W1ELujNGexwTduE1jHm7GlrQ12jmix7V0ns5ilNR4bUx1MrWGJxka0nVwIGzib38Qs7H6M0eKSED6qcmRh7ekPH1Cy3PY3pOaO0qPVevcZzcc7Pe90sj5X9ORxe7tJuUNNpIyN0jT5hLHFLL9lE9/WBYeJ0V2nwuQva+d4aGkOyN1Jsb6lCOb5HFhhcd/TVQhCp88FHUQtqIHxP2OFuzrUiEByjmOje6N4s9pse1NWrjdNZzapo0Nmv+B+HgspbY3cRlNAgEWOoT45chDZDpsDj6FMSO6JsATtF0s8JlOzwy8atEgC5NgmZ3P0jGnvHZ3cVZqqJsQbURgugeARc3yX+HWolxWadO4axgYNNSdpO0pyEJALQwGlFZi0THC8bGue8dVrepCz11/stQGmoTUyNtJUWIB3MGz1J71eE3V4TdJ7QUBIdVx6NNuWsL2tsdbqtY9XYst9S6CMvqIyGN1MkfOFuNtq7DaLFc/iFCaAmSMXpDtH8L/wDPp2bNy5cN9xSgq6eo+xmY88AdfBTLAxLCjTyirpIw9jXB7oiLgW12bx1KfFsZpo5IDhBOVzM0rXkuaCdjRfZbqSROLym8K2FYnq43U0cTrh5IA00vZc9Te0EL7CpYYj7w1b81qxyRVDA6NzJG3uCDfVCLjlh1YkQmvYHsLSSAeBsUMY2Noaxoa0bABZCDkIUb54YzaSVjD+JwCAkQq5r6Qf8AMRn8rr+iYcTpB+8d3Ru+SFTDK+otnXaozBE7bEw9rQqxxWl3OkP/AG3fJSU1a2rnENPFLJIQSBYC9u0hCvxck71TzSUx208X9AT2RRx9CNjfygBFYZ6KDlqmklYy4aDmYbk9jlROLstzYJb9eUD1Qc4eTL1K0ULPppqqudmIENPxbq53YeHXZX2NDGhrdg67oZ5Y3G6pUIQgghCEA2WNssTo3i7XCxC5eaJ1PM6GTpNO3iNxXVKOaCKduWaNrwNmYXsqxui9uWQuhOFUR/cnue4fFI3CaIG/JE9Re4j1VecLxSYeM2G04cLgxAWO8WWZW0hpHgtuYXHmn3TwPwW4AAAALAJskbZY3RyDM1wsQssptpMtVzyE+eF1NMYnm42td7w+a0cGwWXEnCWS8dIDq7YZOpvV1+HVh43em0m/R2AYScRnE0zf7LGdb/vHcOzj4cV2ibFFHBE2KJgYxgs1oGgCeujGajeTUCQgEEEXBSoTNhVuFvpbyUjS+DaYRtZ+XiOrw4LnMQweOrBno3Na86kfdd8iu/WTjFDG2GSsg+rmGrh92TtHHr29qGdwsvlj7cLHTMgcWuYRINucahTNux+djix/vNNitypgZK4Q1cWSX7tz5tdv/wBXCrfRDT/uhMz3gOcO0b+7wUWV18XysMp4ck1/4rx4nUMbZ7WS9ZOU/wCvBNkxGqfscyMfhbc+J+SuxujeDky6bRaxHaNyfYHaFPlW0+Lw73Ix3vfJ9pI9/U5xt4bExrWt6LQOwLZMbDtY3wSGCI/u2+CW2+OOOPqMhC1TSwn7g7lE6hjPRc5vmjamepKed9LUxVEXTicHAceI7xcd6klpJIwXaOaNpCbT0s1TYxtys99w07uKqM+TPDHH/e9LmOYt+1KlgiDhAzSNpGrnHabenfxTaTDC6z6oabovn8lcpaKKmF2jM87Xu2/orCrTyeX5Vs8OPqACwsEIUcszIrZjzj0WjUnsCbjSIUURlc4ukAY22jNp7ypUAIQhAJcXtfU7kqzsSkcyRj2GxjsT2b/JTR1otaQa8Qno/G62toUX0mG3THgmxyuncHRACH3iOl2dXWkWk6EIQENTAyZrS6NshjcHta7Y6249R2LqaWaOemjlh+zc0Fota3UucV7A5sk8tKTzXfWx+jh4kHvKG/Dl34tpCEJukIQhAIquK/8AC6k+7GXeGvwVtQVkRnop4htkjc3xFkBn4lA2elIe0ODTexWPkmh+zdyrPdeecOw7+/xW9BIJ6aOTaJGB3iFmVEXIylu7aOxDl5J9qR+j1Dw2RuWUbA7muHYfkkNNK37ObMOEgv5j9VO8RS3ieGPO0tNj5KlMJqaW0Uzg06hrucPPXzS1suPkzw/jdJDy7elBm/u3g+tknK26UUo/7ZPomNrp29KKN/W1xb5a+qeMRbvglH9J+KXg6p8zmnvVAkc7oQyu/ky/5rJwjqX7mRDrOY+H6o/aEXuS/wBKQ4izdDKe4D1KPCJy+ZzZeukjKSMEOkJlcN79g7tisKicQcehTn+d4HpdRuq6l2wxxjqBJ8f0VacuXlld5VpKCWsgiJaX5nj7rdT5bFnPzSfayPk6ibDwGiGtDRZoAA3BPQ8U01dM5pygQsG0nV3yHmrNHSugBkmH1r7E5tXAbgTx9EYPRiqqTNIPqYDfX7zto8Nvgrcjs8jncTdKnlNQ1CZLLHCwvle1jRvJskgnjqI+Uidmbe17WSZpEbEKGrfkhI3u0QIzas8qyY+8ChpzNB4i6HdE34JtJGZxFCDbmAvI3D5lW2+k9NT/AEp2Z4+pabW98/JXampipY88rrDYANp7FHV1MdBTCzRfosYNP9Bc/NLJPKZJXZnnwHUEpPJllk0f22/lQTCBFfUXu63H9FsNcHNDmm4IuCuTXQ4S/Ph0V/u3b4Gw8k8sdJl2uIZJyFTBPs5OQX/KeafI37kJk7OUgkZ7zSPJQrG6u3VIUdLLy9LDN/EY13iLqRN3lQkSoBEqEiAy6LmUxiOnIudH2BpIHlZY2O10klNylLzIwcvK73A8Orr/AN1fxMOGIPpbHkqgCZx4gANLfJviVRxhubDJeqx8wqkc3LlrpzUUroJmzMuXtNzc6u4g9q36otlp45WG7TYg9RXOraoHF+D2P3SQD1XTyn258KjTBK0uyuu124O39nFPSOa1zbOAIO4hJsVCi5Jzfs3kdTucPmnRmZ8jY+Rc97r25PnX0vs27kHo9CTMA8sN2vG1rhYjuKVBBAa57msjF3vIa0dZQtDBY2fSZKuZwbFTtsHONgHH5D/Mg5N1rckyhw0Qx7hlvxJ2n1KoKnj2MTOcyGnaYmEZs7hzj3bu/XsWPh7nHE4HFxc4uIJJuSLFLxuto5MpctJMXbKK361xcwi8fADeO39FZwGQ3ni3aPHfofQLRqqaOqi5OUG20EbQeIUdFQx0Yflc57n2u53UjfWkf2tLPq5M8thsbork8nJRF2/YFmIisZ9oqp/J00jvwkDtVjDByTwHdJ417eHwVOoOeeGEbM2d3YNnn6K01xa4OG0G6bS+tI8dY/lonnoZS0dR2/67FmLpauEVlG5g2uF2ngdy5rXeLEaEHcVWF6058p9hbmBn+xvHCQ+gWJqSAASSbADaSth2bC8I2gSvO3cHH5D0Rn+hjGohU8MNQ6lD6l5cXG7bgAhqlrJuRp3kavynKOJWStd6dJhP/CaL+4Z/lCtqOCMQwRxDYxoaO4J6b0CoQhACEJEBl4+x7KeKrjZndC8BwG0sdobd9j3LIxJ7X4VK9pBa5ose9dTLGyaJ8Ugux7S1w4grnKqgilpZWS52zMfklyuIDztDrbNRY96cumPLhubctTU0lVMI49PeduaFvviZBRGOMWa0WCfT08dNEI4m2G08SeJTa11oLcTZFu65cYz0IQm1C3PZikzPlrXjQfVx/wDkfQdxWLHFJPNHBF9pI7K3q6+4XPcu4padlLTRwRCzI2ho6+tKteOfapjeHtxHDpI8jXSt58dx94bu/Z3ri2xNLQWOey/Xs7ivRFy2P4caWd1XE36iU3kA+447+w+vaiKzm5uMQtlaNJQR+Jt/Sy1sMpi2lifM4vc76wNtYNJ6uNrC6y5ReMtDS7NZtm7dTbRa2IVjaai5RhBc8Wjt6qowyuowsVlE2ISkG4aco7kuEMz4g07mNLvh8Sqe1a+BRWjlmP3yGjsH6k+CeXUYY+9tVCFFUS8lETvOgWSlWskzyZRsb6qq94YwuOwJyt0mC1eIRNqYzG2ME5BISM34tAdOH+yv02xx31GYxpbOwu6bmuJ8W6KwrFdhVZQOimqBFkJLLxvJ1Ou8Dgq6DylntcopdOTPaFTxLDZHzGambmz9JtwNeOqUEg3BsQr9PUiQZXaP9UvXcZZRWw7DRTHlZrOl3AbG/qtBB0GqqzVYbpHqeO5Lupk2mmmbE3XU7gqlM11ZiVNG7XPK246hzj5AqBzi4kuNyVrezNPyldLUEc2FmUfmd8gP8SetNuPHt1CEISdQQhCAEiVIgFWHjLnCqc+FtxHEOX6xfm26xZx7CtxZGK0bGxyStdUZppGh4jc4gDQE2GuwILKbmmXHMyS2W+ozC7SMw4i+0daq1z7vawbhcrclopsQbGGMFMyM3Y+Rt3HqDbiw7fDesSrw+ojxDkKgF4cM7nQtc64vssBodPBEc/4rL0qIJABJNgFabhdY+ZzaekmMV7tMgyW6udYrYw72ebE9s1c5sr26iJvQB6+KrZzC2k9nMOdGDXTtIe8WiaRq1vHtPp2reQhS3k1NBZ2NR1E9MyCCB0zJHfWhpaOaNbakbTbuutFIg3JRYXUUWIUsszGspjIbNc+7mkNcfDTiquIYa+pmLoZg2MXyRuGjR1FdFjDZKqaGngy54jyri46agtA79fBZbHFzTduVwJa4cCDY+iN2Obmmuvpkx4I4n62cAcGN18T8lqwxMgibFGLNaLBPQi21gFnVMvKyadEaBWKubI3I0847eoKCio5a+pEEOgGr5LaMHz4BOLwx2lwrDnYlU5TcU8Z+tcN/4R1nyHaF2LWtYwNY0Na0WAA0AUdLTRUdOyCBuVjR3nrPWpUnXjj4xXr6RtdRy07zbONHe6RqD4rinsfFI+KVuWSM5XN4H5Lvlz3tBBFU1kbIuZOxt5JB7u5pG87+rvThZ47jBQlnYaafkZHtJIu07Ljs4p0dNPNAZow3Lta07Xjj1dSbDVI6R7hZziR1lNTc7cgfuOzTalN2uyvY5jrXs4WuEFoOcGtLjsAuV2OC0ZosNjY8Wlfz5PzHd3Cw7lz2CUJrqxkhaTTRHM525zhsA466ns612CVb8eOuwhCRJoVCEIAQhCAEIQgESoQgBCEIAQhCARKhCAoOw+R1RNKKt7BK7MQxjbjQC1yDwVeqwSIU8rqV8zJ8riDnzZndYdcbeFlroQVkvtzclNSSUjGUkYfVTND4ydX8bk7QOPh1KGogqo5o4pWcgHgnOHB17W0Hjv8A9umjhiiLjFExhebuLWgZjxKzPafTCsw6QlZY7xc2PkSO9CLxy+2LTYTU1tVIIn/2cOsZ3kGx3gDeR4eC6mio4aGnEMDbNGpJ2uPEnipYmMjiayNrWMaLBrRYBPQuYyeghCEGFQlwmmmqZJpDKTIQS0SFovYDdY7gr6EBQq8Nidhs1LSwws5QWIIsDxubbbb1WhweR9vpcwaz+HDceLtvgAthCC0wJ/Z1kU8D6BrQ1l7iWRxAOliNDferkOC09w+stVPGwObZjexvzutNCBqEaA0ANAAGgA3JUIQYQhCA/9k='); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id` int(11) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `admin` tinyint(1) NOT NULL, `pokemonId` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `username`, `password`, `admin`, `pokemonId`) VALUES (3, 'cirakg', '$2a$10$tElFyUJsnb9xWuV3PRWOW.HPZ8qwLebQEpfu61eqozUcxC3ydEv7.', 1, NULL), (2, 'cirakg1', '$2a$10$TJHJfYbgZO97r0CJi2eKpeEhOW8wKEO5BGXQBpR33js3R5rM98Y3W', 0, 1), (4, 'cirakg2', '$2a$10$LQsWtrn7OqrNU8wSSfg/6uo47lzQqw27T3ubUDRqFQVZhI6F0uBli', 0, 3), (5, 'cirakg5', '$2a$10$cO0oAPi5O4hoVQWTHuw0fOXXBYLqwJ2V5qrHy32ZjpmR9fTpNBGHy', 0, 2), (6, 'cirakg10', '$2a$10$IiK5l7wFvi/KPliiCpNMCOAuehXvJFofN6ARotiSN.5FuRpjke32G', 0, NULL); -- -- Indexes for dumped tables -- -- -- Indexes for table `ability` -- ALTER TABLE `ability` ADD PRIMARY KEY (`id`); -- -- Indexes for table `history` -- ALTER TABLE `history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `monster` -- ALTER TABLE `monster` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `ability` -- ALTER TABLE `ability` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `history` -- ALTER TABLE `history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `monster` -- ALTER TABLE `monster` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; COMMIT; /*!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 */;