Linux ip-172-31-33-47 5.4.0-1045-aws #47~18.04.1-Ubuntu SMP Tue Apr 13 15:58:14 UTC 2021 x86_64
Apache/2.4.29 (Ubuntu)
: 172.31.33.47 | : 3.17.187.188
Cant Read [ /etc/named.conf ]
7.4.20
www-data
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
var /
www /
html /
betpair /
[ HOME SHELL ]
Name
Size
Permission
Action
.git
[ DIR ]
drwxrwxr-x
betpair
[ DIR ]
drwxrwxr-x
betting
[ DIR ]
drwxrwxr-x
.gitignore
117
B
-rw-rw-r--
betpair.sql
25.84
KB
-rw-rw-r--
manage.py
627
B
-rwxrwxr-x
requirements.txt
305
B
-rw-rw-r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : betpair.sql
-- MySQL dump 10.13 Distrib 8.0.22, for osx10.14 (x86_64) -- -- Host: localhost Database: betme -- ------------------------------------------------------ -- Server version 8.0.22 /*!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 `auth_group` -- DROP TABLE IF EXISTS `auth_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_group` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_group` -- LOCK TABLES `auth_group` WRITE; /*!40000 ALTER TABLE `auth_group` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_group_permissions` -- DROP TABLE IF EXISTS `auth_group_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_group_permissions` ( `id` int NOT NULL AUTO_INCREMENT, `group_id` int NOT NULL, `permission_id` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`), KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`), CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`), CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_group_permissions` -- LOCK TABLES `auth_group_permissions` WRITE; /*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_permission` -- DROP TABLE IF EXISTS `auth_permission`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_permission` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `content_type_id` int NOT NULL, `codename` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`), CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_permission` -- LOCK TABLES `auth_permission` WRITE; /*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */; INSERT INTO `auth_permission` VALUES (1,'Can add bet',1,'add_bet'),(2,'Can change bet',1,'change_bet'),(3,'Can delete bet',1,'delete_bet'),(4,'Can view bet',1,'view_bet'),(5,'Can add event',2,'add_event'),(6,'Can change event',2,'change_event'),(7,'Can delete event',2,'delete_event'),(8,'Can view event',2,'view_event'),(9,'Can add event option',3,'add_eventoption'),(10,'Can change event option',3,'change_eventoption'),(11,'Can delete event option',3,'delete_eventoption'),(12,'Can view event option',3,'view_eventoption'),(13,'Can add player',4,'add_player'),(14,'Can change player',4,'change_player'),(15,'Can delete player',4,'delete_player'),(16,'Can view player',4,'view_player'),(17,'Can add player bet',5,'add_playerbet'),(18,'Can change player bet',5,'change_playerbet'),(19,'Can delete player bet',5,'delete_playerbet'),(20,'Can view player bet',5,'view_playerbet'),(21,'Can add payment',6,'add_payment'),(22,'Can change payment',6,'change_payment'),(23,'Can delete payment',6,'delete_payment'),(24,'Can view payment',6,'view_payment'),(25,'Can add log entry',7,'add_logentry'),(26,'Can change log entry',7,'change_logentry'),(27,'Can delete log entry',7,'delete_logentry'),(28,'Can view log entry',7,'view_logentry'),(29,'Can add permission',8,'add_permission'),(30,'Can change permission',8,'change_permission'),(31,'Can delete permission',8,'delete_permission'),(32,'Can view permission',8,'view_permission'),(33,'Can add group',9,'add_group'),(34,'Can change group',9,'change_group'),(35,'Can delete group',9,'delete_group'),(36,'Can view group',9,'view_group'),(37,'Can add user',10,'add_user'),(38,'Can change user',10,'change_user'),(39,'Can delete user',10,'delete_user'),(40,'Can view user',10,'view_user'),(41,'Can add content type',11,'add_contenttype'),(42,'Can change content type',11,'change_contenttype'),(43,'Can delete content type',11,'delete_contenttype'),(44,'Can view content type',11,'view_contenttype'),(45,'Can add session',12,'add_session'),(46,'Can change session',12,'change_session'),(47,'Can delete session',12,'delete_session'),(48,'Can view session',12,'view_session'); /*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_user` -- DROP TABLE IF EXISTS `auth_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_user` ( `id` int NOT NULL AUTO_INCREMENT, `password` varchar(128) NOT NULL, `last_login` datetime(6) DEFAULT NULL, `is_superuser` tinyint(1) NOT NULL, `username` varchar(150) NOT NULL, `first_name` varchar(30) NOT NULL, `last_name` varchar(150) NOT NULL, `email` varchar(254) NOT NULL, `is_staff` tinyint(1) NOT NULL, `is_active` tinyint(1) NOT NULL, `date_joined` datetime(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_user` -- LOCK TABLES `auth_user` WRITE; /*!40000 ALTER TABLE `auth_user` DISABLE KEYS */; INSERT INTO `auth_user` VALUES (1,'pbkdf2_sha256$180000$EnVWUsb4NgfY$IZYN85dPPV1FDVqwr8/KHAw6M4P8Oq1Wc+53BJUxU/s=','2021-02-12 16:02:14.057378',1,'reptofrank','','','reptofrank@gmail.com',1,1,'2021-02-12 16:01:58.777010'),(2,'pbkdf2_sha256$180000$hQB5vx4NQOji$nu4APglRbyou/LsoZon0GQmI90rrjtF2/2utYMCxyM8=','2021-02-12 16:04:41.636930',0,'mike','','','mike@gmail.com',0,1,'2021-02-12 16:04:41.337675'),(3,'pbkdf2_sha256$180000$6dYTtyhL4cfQ$Q0nK4wjtlHmPAtwhcgFtXGGEc4OtvEgis4MQcc62rQY=','2021-02-21 23:04:12.984320',0,'mike.james','','','mike.james@gmail.com',0,1,'2021-02-21 23:04:12.724144'),(4,'pbkdf2_sha256$180000$rFDoxAcuoL5M$xzCF8MSarlZWtjL2Nnz1zKwPNi6y+tf/3tv/SztX4WU=','2021-02-21 23:24:40.648896',0,'chids','','','chids@gmail.com',0,1,'2021-02-21 23:24:40.445460'),(5,'pbkdf2_sha256$180000$9h083vtbDY3U$HiEHjJjY0remMsb6xKwfseo70ql1PFjDfAWARqgpbbM=','2021-02-23 16:26:40.888457',0,'uche','','','uche@gmail.com',0,1,'2021-02-23 16:26:40.675805'); /*!40000 ALTER TABLE `auth_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_user_groups` -- DROP TABLE IF EXISTS `auth_user_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_user_groups` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `group_id` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`), KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`), CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`), CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_user_groups` -- LOCK TABLES `auth_user_groups` WRITE; /*!40000 ALTER TABLE `auth_user_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_user_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_user_user_permissions` -- DROP TABLE IF EXISTS `auth_user_user_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_user_user_permissions` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `permission_id` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`), KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`), CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`), CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_user_user_permissions` -- LOCK TABLES `auth_user_user_permissions` WRITE; /*!40000 ALTER TABLE `auth_user_user_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_user_user_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `betting_bet` -- DROP TABLE IF EXISTS `betting_bet`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `betting_bet` ( `id` int NOT NULL AUTO_INCREMENT, `bet_key` varchar(255) NOT NULL, `private` tinyint(1) NOT NULL, `type` varchar(255) NOT NULL, `minimum` int NOT NULL, `initiator_id` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `bet_key` (`bet_key`), KEY `betting_bet_initiator_id_c21b1197_fk_betting_player_id` (`initiator_id`), CONSTRAINT `betting_bet_initiator_id_c21b1197_fk_betting_player_id` FOREIGN KEY (`initiator_id`) REFERENCES `betting_player` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `betting_bet` -- LOCK TABLES `betting_bet` WRITE; /*!40000 ALTER TABLE `betting_bet` DISABLE KEYS */; INSERT INTO `betting_bet` VALUES (1,'dbcdd120-4da6-494d-849c-cb5155aaa3b7',0,'variable',2000,1),(2,'9affd557-b04f-414c-85f2-baf4707017db',0,'fixed',3000,1),(3,'f54f8514-7026-4675-9ebd-1ea490f958d1',0,'variable',500,1),(4,'52234de8-d103-4c7e-9f54-9010a11e6565',0,'fixed',3000,2),(5,'aa76d068-c647-4cf4-bfff-c4d99795a419',0,'fixed',2000,2),(6,'df2bf2a8-e1e1-4c9d-8249-7fb3e1015e00',0,'fixed',2000,2),(7,'05cd1e6d-b863-4d96-9615-a2ec89a7254d',0,'variable',500,2),(8,'4b5ce20b-153d-410f-bdeb-4147c3748e82',0,'fixed',1000,2),(9,'3aa82878-8630-4625-a6d0-a012e9d1defc',0,'fixed',2000,4),(10,'76c9a869-94f1-45a9-b0c0-977050d2fe55',0,'variable',500,4); /*!40000 ALTER TABLE `betting_bet` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `betting_event` -- DROP TABLE IF EXISTS `betting_event`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `betting_event` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(200) NOT NULL, `start_date` datetime(6) NOT NULL, `end_date` datetime(6) NOT NULL, `image` varchar(255) NOT NULL, `description` varchar(255) DEFAULT NULL, `slug` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), UNIQUE KEY `slug` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `betting_event` -- LOCK TABLES `betting_event` WRITE; /*!40000 ALTER TABLE `betting_event` DISABLE KEYS */; INSERT INTO `betting_event` VALUES (1,'Man City VS Tottenham','2021-02-14 18:00:00.000000','2021-02-14 20:00:00.000000','/images/mancity.jpeg',NULL,'man-city-vs-tottenham'),(2,'Nordsjaelland VS Odense Boldklub','2021-02-07 14:00:00.000000','2021-02-07 14:00:00.000000','https://cdn.soccersapi.com/images/soccer/teams/80/726.png',NULL,'nordsjaelland-vs-odense-boldklub'),(3,'Sonderjyske VS Vejle','2021-02-07 14:00:00.000000','2021-02-07 14:00:00.000000','https://cdn.soccersapi.com/images/soccer/teams/80/718.png',NULL,'sonderjyske-vs-vejle'),(4,'Horsens VS FC Copenhagen','2021-02-07 16:00:00.000000','2021-02-07 16:00:00.000000','https://cdn.soccersapi.com/images/soccer/teams/80/716.png',NULL,'horsens-vs-fc-copenhagen'),(5,'Aarhus VS Lyngby','2021-02-07 18:00:00.000000','2021-02-07 18:00:00.000000','https://cdn.soccersapi.com/images/soccer/teams/80/720.png',NULL,'aarhus-vs-lyngby'),(6,'Broendby VS Aalborg','2021-02-07 20:00:00.000000','2021-02-07 20:00:00.000000','https://cdn.soccersapi.com/images/soccer/teams/80/724.png',NULL,'broendby-vs-aalborg'),(7,'Odense Boldklub VS Randers','2021-02-28 14:00:00.000000','2021-02-28 14:00:00.000000','https://cdn.soccersapi.com/images/soccer/teams/80/722.png',NULL,'odense-boldklub-vs-randers'),(8,'Nordsjaelland VS Aalborg','2021-02-28 14:00:00.000000','2021-02-28 14:00:00.000000','https://cdn.soccersapi.com/images/soccer/teams/80/726.png',NULL,'nordsjaelland-vs-aalborg'),(9,'FC Copenhagen VS Aarhus','2021-02-28 16:00:00.000000','2021-02-28 16:00:00.000000','https://cdn.soccersapi.com/images/soccer/teams/80/79.png',NULL,'fc-copenhagen-vs-aarhus'),(10,'Midtjylland VS Broendby','2021-02-28 18:00:00.000000','2021-02-28 18:00:00.000000','https://cdn.soccersapi.com/images/soccer/teams/80/725.png',NULL,'midtjylland-vs-broendby'); /*!40000 ALTER TABLE `betting_event` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `betting_eventoption` -- DROP TABLE IF EXISTS `betting_eventoption`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `betting_eventoption` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `event_id` int NOT NULL, PRIMARY KEY (`id`), KEY `betting_eventoption_event_id_d6f75556_fk_betting_event_id` (`event_id`), CONSTRAINT `betting_eventoption_event_id_d6f75556_fk_betting_event_id` FOREIGN KEY (`event_id`) REFERENCES `betting_event` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `betting_eventoption` -- LOCK TABLES `betting_eventoption` WRITE; /*!40000 ALTER TABLE `betting_eventoption` DISABLE KEYS */; INSERT INTO `betting_eventoption` VALUES (1,'Man City wins',1),(2,'Tottenham Wins',1),(3,'Nordsjaelland wins',2),(4,'Odense Boldklub wins',2),(5,'Draw',2),(6,'Sonderjyske wins',3),(7,'Vejle wins',3),(8,'Draw',3),(9,'Horsens wins',4),(10,'FC Copenhagen wins',4),(11,'Draw',4),(12,'Aarhus wins',5),(13,'Lyngby wins',5),(14,'Draw',5),(15,'Broendby wins',6),(16,'Aalborg wins',6),(17,'Draw',6),(18,'Odense Boldklub wins',7),(19,'Randers wins',7),(20,'Draw',7),(21,'Nordsjaelland wins',8),(22,'Aalborg wins',8),(23,'Draw',8),(24,'FC Copenhagen wins',9),(25,'Aarhus wins',9),(26,'Draw',9),(27,'Midtjylland wins',10),(28,'Broendby wins',10),(29,'Draw',10); /*!40000 ALTER TABLE `betting_eventoption` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `betting_payment` -- DROP TABLE IF EXISTS `betting_payment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `betting_payment` ( `id` int NOT NULL AUTO_INCREMENT, `amount` int NOT NULL, `date_paid` datetime(6) NOT NULL, `user_id` int NOT NULL, PRIMARY KEY (`id`), KEY `betting_payment_user_id_9a8252ef_fk_betting_player_id` (`user_id`), CONSTRAINT `betting_payment_user_id_9a8252ef_fk_betting_player_id` FOREIGN KEY (`user_id`) REFERENCES `betting_player` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `betting_payment` -- LOCK TABLES `betting_payment` WRITE; /*!40000 ALTER TABLE `betting_payment` DISABLE KEYS */; /*!40000 ALTER TABLE `betting_payment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `betting_player` -- DROP TABLE IF EXISTS `betting_player`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `betting_player` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `phone_number` varchar(20) DEFAULT NULL, `balance` int NOT NULL, `user_id` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`), CONSTRAINT `betting_player_user_id_b78f3589_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `betting_player` -- LOCK TABLES `betting_player` WRITE; /*!40000 ALTER TABLE `betting_player` DISABLE KEYS */; INSERT INTO `betting_player` VALUES (1,'mike',NULL,-500,2),(2,'mike.james',NULL,1000,3),(3,'chids',NULL,9000,4),(4,'uche',NULL,7000,5); /*!40000 ALTER TABLE `betting_player` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `betting_playerbet` -- DROP TABLE IF EXISTS `betting_playerbet`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `betting_playerbet` ( `id` int NOT NULL AUTO_INCREMENT, `date_placed` datetime(6) NOT NULL, `amount` int NOT NULL, `bet_id` int NOT NULL, `player_id` int NOT NULL, `selection_id` int NOT NULL, PRIMARY KEY (`id`), KEY `betting_playerbet_bet_id_aa14f401_fk_betting_bet_id` (`bet_id`), KEY `betting_playerbet_player_id_5809232f_fk_betting_player_id` (`player_id`), KEY `betting_playerbet_selection_id_8c746bc5_fk_betting_e` (`selection_id`), CONSTRAINT `betting_playerbet_bet_id_aa14f401_fk_betting_bet_id` FOREIGN KEY (`bet_id`) REFERENCES `betting_bet` (`id`), CONSTRAINT `betting_playerbet_player_id_5809232f_fk_betting_player_id` FOREIGN KEY (`player_id`) REFERENCES `betting_player` (`id`), CONSTRAINT `betting_playerbet_selection_id_8c746bc5_fk_betting_e` FOREIGN KEY (`selection_id`) REFERENCES `betting_eventoption` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `betting_playerbet` -- LOCK TABLES `betting_playerbet` WRITE; /*!40000 ALTER TABLE `betting_playerbet` DISABLE KEYS */; INSERT INTO `betting_playerbet` VALUES (1,'2021-02-12 16:02:39.353420',3000,1,1,1),(2,'2021-02-21 18:54:51.839028',3000,2,1,20),(3,'2021-02-21 18:54:51.839028',1000,3,1,24),(4,'2021-02-21 18:54:51.839028',3000,4,2,24),(5,'2021-02-21 18:54:51.839028',2000,5,2,26),(6,'2021-02-21 18:54:51.839028',2000,6,2,18),(7,'2021-02-21 18:54:51.839028',1000,7,2,19),(8,'2021-02-21 23:24:08.907027',1000,8,2,27),(9,'2021-02-21 23:34:21.338364',1000,8,3,28),(10,'2021-02-23 16:26:13.913875',2000,9,4,21),(11,'2021-02-23 16:26:13.913875',1000,10,4,21); /*!40000 ALTER TABLE `betting_playerbet` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_admin_log` -- DROP TABLE IF EXISTS `django_admin_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_admin_log` ( `id` int NOT NULL AUTO_INCREMENT, `action_time` datetime(6) NOT NULL, `object_id` longtext, `object_repr` varchar(200) NOT NULL, `action_flag` smallint unsigned NOT NULL, `change_message` longtext NOT NULL, `content_type_id` int DEFAULT NULL, `user_id` int NOT NULL, PRIMARY KEY (`id`), KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`), KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`), CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`), CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `django_admin_log_chk_1` CHECK ((`action_flag` >= 0)) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_admin_log` -- LOCK TABLES `django_admin_log` WRITE; /*!40000 ALTER TABLE `django_admin_log` DISABLE KEYS */; INSERT INTO `django_admin_log` VALUES (1,'2021-02-12 16:03:31.955455','1','Man City VS Tottenham',1,'[{\"added\": {}}, {\"added\": {\"name\": \"event option\", \"object\": \"Man City wins\"}}, {\"added\": {\"name\": \"event option\", \"object\": \"Tottenham Wins\"}}]',2,1); /*!40000 ALTER TABLE `django_admin_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_content_type` -- DROP TABLE IF EXISTS `django_content_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_content_type` ( `id` int NOT NULL AUTO_INCREMENT, `app_label` varchar(100) NOT NULL, `model` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_content_type` -- LOCK TABLES `django_content_type` WRITE; /*!40000 ALTER TABLE `django_content_type` DISABLE KEYS */; INSERT INTO `django_content_type` VALUES (7,'admin','logentry'),(9,'auth','group'),(8,'auth','permission'),(10,'auth','user'),(1,'betting','bet'),(2,'betting','event'),(3,'betting','eventoption'),(6,'betting','payment'),(4,'betting','player'),(5,'betting','playerbet'),(11,'contenttypes','contenttype'),(12,'sessions','session'); /*!40000 ALTER TABLE `django_content_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_migrations` -- DROP TABLE IF EXISTS `django_migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_migrations` ( `id` int NOT NULL AUTO_INCREMENT, `app` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `applied` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_migrations` -- LOCK TABLES `django_migrations` WRITE; /*!40000 ALTER TABLE `django_migrations` DISABLE KEYS */; INSERT INTO `django_migrations` VALUES (55,'contenttypes','0001_initial','2021-02-12 16:00:15.272764'),(56,'auth','0001_initial','2021-02-12 16:00:15.505371'),(57,'admin','0001_initial','2021-02-12 16:00:16.253278'),(58,'admin','0002_logentry_remove_auto_add','2021-02-12 16:00:16.352839'),(59,'admin','0003_logentry_add_action_flag_choices','2021-02-12 16:00:16.364502'),(60,'contenttypes','0002_remove_content_type_name','2021-02-12 16:00:16.513992'),(61,'auth','0002_alter_permission_name_max_length','2021-02-12 16:00:16.618176'),(62,'auth','0003_alter_user_email_max_length','2021-02-12 16:00:16.661567'),(63,'auth','0004_alter_user_username_opts','2021-02-12 16:00:16.670237'),(64,'auth','0005_alter_user_last_login_null','2021-02-12 16:00:16.762048'),(65,'auth','0006_require_contenttypes_0002','2021-02-12 16:00:16.764370'),(66,'auth','0007_alter_validators_add_error_messages','2021-02-12 16:00:16.774291'),(67,'auth','0008_alter_user_username_max_length','2021-02-12 16:00:16.838229'),(68,'auth','0009_alter_user_last_name_max_length','2021-02-12 16:00:16.993754'),(69,'auth','0010_alter_group_name_max_length','2021-02-12 16:00:17.040377'),(70,'auth','0011_update_proxy_permissions','2021-02-12 16:00:17.048729'),(71,'betting','0001_initial','2021-02-12 16:00:17.323829'),(72,'sessions','0001_initial','2021-02-12 16:00:17.669654'); /*!40000 ALTER TABLE `django_migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_session` -- DROP TABLE IF EXISTS `django_session`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_session` ( `session_key` varchar(40) NOT NULL, `session_data` longtext NOT NULL, `expire_date` datetime(6) NOT NULL, PRIMARY KEY (`session_key`), KEY `django_session_expire_date_a5c62663` (`expire_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_session` -- LOCK TABLES `django_session` WRITE; /*!40000 ALTER TABLE `django_session` DISABLE KEYS */; INSERT INTO `django_session` VALUES ('pjlysykyd6apfung0nu3wxcz0p7doii7','ZTJkZTZhNDExNTQ4NGVmMmM1MjQ0ZTY5YjY4ODY1YzQxMDk5MmRmMDp7Il9hdXRoX3VzZXJfaWQiOiIxIiwiX2F1dGhfdXNlcl9iYWNrZW5kIjoiZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5kcy5Nb2RlbEJhY2tlbmQiLCJfYXV0aF91c2VyX2hhc2giOiI5NmVkYTA0NWZhMTZmNjM0NTZkZTQ1Y2U2YzgyM2Y1YWNlZGRhM2YzIn0=','2021-02-26 16:02:14.059508'),('uple686pucdetawy1wxpkbpabsyi26ml','ZTJlNGUyODY4MWRhNzM3NzhhYTY3NzVmODUxZDc5ZWY2YzY0ODljMTp7Il9hdXRoX3VzZXJfaWQiOiI1IiwiX2F1dGhfdXNlcl9iYWNrZW5kIjoiZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5kcy5Nb2RlbEJhY2tlbmQiLCJfYXV0aF91c2VyX2hhc2giOiIxNTZkNTM0ZjMxMDRlNmVhMDE0MGVhNTNiNzE4ODhjYTdhYzEwN2M0In0=','2021-03-09 16:26:40.904296'); /*!40000 ALTER TABLE `django_session` 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 2021-02-23 17:38:06
Close