Repository navigation
Expand file tree
/
Copy pathsql.sql
More file actions
147 lines (126 loc) · 25.8 KB
/
Copy pathsql.sql
File metadata and controls
147 lines (126 loc) · 25.8 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
-- MySQL dump 10.13 Distrib 8.0.31, for Linux (x86_64)
--
-- Host: 127.0.0.1 Database: wynnguessr
-- ------------------------------------------------------
-- Server version 8.0.31-google
/*!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 */;
--
-- Current Database: `wynnguessr`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `wynnguessr` /*!40100 DEFAULT CHARACTER SET utf8mb3 */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `wynnguessr`;
--
-- Table structure for table `matches`
--
DROP TABLE IF EXISTS `matches`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `matches` (
`matchID` int NOT NULL AUTO_INCREMENT,
`player_one_id` int DEFAULT NULL,
`player_two_id` int DEFAULT NULL,
`player_one_elo_change` int DEFAULT NULL,
`player_two_elo_change` int DEFAULT NULL,
`winnerID` int DEFAULT NULL,
`time-of-play` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`matchID`)
) ENGINE=InnoDB AUTO_INCREMENT=178 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `matches`
--
LOCK TABLES `matches` WRITE;
/*!40000 ALTER TABLE `matches` DISABLE KEYS */;
INSERT INTO `matches` VALUES (1,2,3,-10,10,3,'2023-08-19 18:56:38'),(2,2,3,NULL,NULL,NULL,'2023-08-19 18:59:01'),(3,3,2,NULL,NULL,NULL,'2023-08-19 19:01:04'),(4,2,2,NULL,NULL,NULL,'2023-08-19 19:01:10'),(5,2,3,-10,10,3,'2023-08-19 19:01:21'),(6,2,3,-10,10,3,'2023-08-19 19:06:44'),(7,2,2,10,-10,2,'2023-08-19 20:48:18'),(8,2,2,10,-10,2,'2023-08-19 20:50:04'),(9,2,2,NULL,NULL,NULL,'2023-08-19 20:56:36'),(10,2,2,NULL,NULL,NULL,'2023-08-19 20:58:16'),(11,2,2,NULL,NULL,NULL,'2023-08-19 21:01:17'),(12,2,2,NULL,NULL,NULL,'2023-08-19 21:03:08'),(13,2,2,NULL,NULL,NULL,'2023-08-19 21:04:20'),(14,2,2,NULL,NULL,NULL,'2023-08-19 21:05:27'),(15,2,2,10,-10,2,'2023-08-19 21:07:12'),(16,2,2,NULL,NULL,NULL,'2023-08-19 21:23:38'),(17,2,2,NULL,NULL,NULL,'2023-08-19 21:24:35'),(18,2,2,NULL,NULL,NULL,'2023-08-19 21:25:13'),(19,2,2,10,-10,2,'2023-08-19 21:27:22'),(20,2,2,10,-10,2,'2023-08-19 21:35:35'),(21,2,2,10,-10,2,'2023-08-19 21:37:24'),(22,6,2,-10,10,2,'2023-08-19 23:13:50'),(23,2,2,NULL,NULL,NULL,'2023-08-20 00:22:24'),(24,2,2,NULL,NULL,NULL,'2023-08-20 01:14:17'),(25,2,2,NULL,NULL,NULL,'2023-08-20 01:15:20'),(26,2,2,NULL,NULL,NULL,'2023-08-20 01:15:22'),(27,2,2,10,-10,2,'2023-08-20 01:21:11'),(28,2,3,NULL,NULL,NULL,'2023-08-20 02:40:33'),(29,3,3,NULL,NULL,NULL,'2023-08-20 02:55:22'),(30,3,2,NULL,NULL,NULL,'2023-08-20 02:55:33'),(31,3,2,NULL,NULL,NULL,'2023-08-20 03:07:16'),(32,2,3,NULL,NULL,NULL,'2023-08-20 03:09:32'),(33,3,2,NULL,NULL,NULL,'2023-08-20 03:12:06'),(34,2,3,NULL,NULL,NULL,'2023-08-20 03:12:16'),(35,3,2,NULL,NULL,NULL,'2023-08-20 03:13:51'),(36,3,2,NULL,NULL,NULL,'2023-08-20 03:33:01'),(37,2,3,NULL,NULL,NULL,'2023-08-20 03:34:46'),(38,2,3,NULL,NULL,NULL,'2023-08-20 03:36:52'),(39,2,3,NULL,NULL,NULL,'2023-08-20 03:39:00'),(40,3,2,NULL,NULL,NULL,'2023-08-20 03:40:30'),(41,2,3,NULL,NULL,NULL,'2023-08-20 03:41:25'),(42,2,3,NULL,NULL,NULL,'2023-08-20 03:42:28'),(43,2,3,NULL,NULL,NULL,'2023-08-20 03:50:42'),(44,2,3,NULL,NULL,NULL,'2023-08-20 03:52:15'),(45,2,3,NULL,NULL,NULL,'2023-08-20 03:53:27'),(46,2,2,NULL,NULL,NULL,'2023-08-20 03:54:22'),(47,3,3,NULL,NULL,NULL,'2023-08-20 03:54:36'),(48,3,3,NULL,NULL,NULL,'2023-08-20 03:54:48'),(49,2,2,NULL,NULL,NULL,'2023-08-20 03:55:04'),(50,2,3,NULL,NULL,NULL,'2023-08-20 03:55:14'),(51,2,3,NULL,NULL,NULL,'2023-08-20 04:01:01'),(52,2,3,NULL,NULL,NULL,'2023-08-20 04:08:18'),(53,3,2,NULL,NULL,NULL,'2023-08-20 04:10:48'),(54,2,3,NULL,NULL,NULL,'2023-08-20 04:14:19'),(55,3,2,NULL,NULL,NULL,'2023-08-20 04:15:35'),(56,2,3,NULL,NULL,NULL,'2023-08-20 04:16:46'),(57,3,2,NULL,NULL,NULL,'2023-08-20 04:18:56'),(58,3,2,NULL,NULL,NULL,'2023-08-20 04:20:09'),(59,2,3,NULL,NULL,NULL,'2023-08-20 04:22:19'),(60,3,2,NULL,NULL,NULL,'2023-08-20 04:23:21'),(61,3,2,NULL,NULL,NULL,'2023-08-20 04:24:54'),(62,2,3,NULL,NULL,NULL,'2023-08-20 04:27:02'),(63,3,2,NULL,NULL,NULL,'2023-08-20 04:28:38'),(64,2,3,NULL,NULL,NULL,'2023-08-20 04:31:17'),(65,3,3,NULL,NULL,NULL,'2023-08-20 04:33:47'),(66,2,3,NULL,NULL,NULL,'2023-08-20 04:34:29'),(67,3,3,NULL,NULL,NULL,'2023-08-20 04:35:56'),(68,3,2,NULL,NULL,NULL,'2023-08-20 04:36:06'),(69,3,2,NULL,NULL,NULL,'2023-08-20 04:36:43'),(70,2,3,NULL,NULL,NULL,'2023-08-20 04:40:58'),(71,3,2,-10,10,2,'2023-08-20 04:42:24'),(72,2,3,NULL,NULL,NULL,'2023-08-20 04:45:22'),(73,2,3,NULL,NULL,NULL,'2023-08-20 04:46:56'),(74,3,2,NULL,NULL,NULL,'2023-08-20 04:52:45'),(75,3,2,NULL,NULL,NULL,'2023-08-20 04:55:43'),(76,3,2,NULL,NULL,NULL,'2023-08-20 04:56:39'),(77,3,2,NULL,NULL,NULL,'2023-08-20 04:57:16'),(78,2,3,NULL,NULL,NULL,'2023-08-20 04:58:01'),(79,2,3,-10,10,3,'2023-08-20 04:58:49'),(80,3,2,-10,10,2,'2023-08-20 04:59:21'),(81,3,2,-10,10,2,'2023-08-20 14:55:21'),(82,3,3,10,-10,3,'2023-08-20 14:56:54'),(83,3,2,-10,10,2,'2023-08-20 15:09:06'),(84,3,2,NULL,NULL,NULL,'2023-08-20 15:13:17'),(85,3,2,NULL,NULL,NULL,'2023-08-20 15:16:40'),(86,3,2,NULL,NULL,NULL,'2023-08-20 16:39:58'),(87,3,3,NULL,NULL,NULL,'2023-08-20 16:40:46'),(88,2,3,NULL,NULL,NULL,'2023-08-20 16:41:00'),(89,2,3,NULL,NULL,NULL,'2023-08-20 16:41:49'),(90,2,2,NULL,NULL,NULL,'2023-08-20 16:43:07'),(91,2,2,NULL,NULL,NULL,'2023-08-20 16:43:39'),(92,2,2,NULL,NULL,NULL,'2023-08-20 16:44:25'),(93,2,2,NULL,NULL,NULL,'2023-08-20 16:45:04'),(94,2,2,NULL,NULL,NULL,'2023-08-20 16:46:00'),(95,2,3,NULL,NULL,NULL,'2023-08-20 16:46:32'),(96,2,3,-10,10,3,'2023-08-20 16:47:59'),(97,3,2,NULL,NULL,NULL,'2023-08-20 16:49:33'),(98,2,3,-10,10,3,'2023-08-20 16:50:06'),(99,2,3,NULL,NULL,NULL,'2023-08-20 16:50:54'),(100,3,2,NULL,NULL,NULL,'2023-08-20 16:53:49'),(101,2,3,NULL,NULL,NULL,'2023-08-20 16:59:26'),(102,2,3,NULL,NULL,NULL,'2023-08-20 17:00:10'),(103,3,2,NULL,NULL,NULL,'2023-08-20 17:18:26'),(104,3,2,NULL,NULL,NULL,'2023-08-20 17:26:09'),(105,2,3,NULL,NULL,NULL,'2023-08-20 17:30:18'),(106,3,2,NULL,NULL,NULL,'2023-08-20 17:31:22'),(107,3,2,NULL,NULL,NULL,'2023-08-20 17:32:42'),(108,2,3,NULL,NULL,NULL,'2023-08-20 17:36:12'),(109,3,2,NULL,NULL,NULL,'2023-08-20 17:50:10'),(110,2,3,NULL,NULL,NULL,'2023-08-20 17:51:23'),(111,3,2,-10,10,2,'2023-08-20 17:57:57'),(112,2,3,-10,10,3,'2023-08-20 18:01:47'),(113,3,2,-10,10,2,'2023-08-20 18:04:28'),(114,3,2,-10,10,2,'2023-08-20 18:08:56'),(115,3,2,-10,10,2,'2023-08-20 18:10:44'),(116,2,3,NULL,NULL,NULL,'2023-08-20 18:13:22'),(117,3,2,NULL,NULL,NULL,'2023-08-20 18:16:11'),(118,2,3,-10,10,3,'2023-08-20 18:17:58'),(119,2,3,-10,10,3,'2023-08-20 18:25:36'),(120,2,3,-10,10,3,'2023-08-20 18:31:20'),(121,3,3,NULL,NULL,NULL,'2023-08-20 20:13:56'),(122,5,5,NULL,NULL,NULL,'2023-08-20 20:36:41'),(123,2,2,NULL,NULL,NULL,'2023-08-20 20:58:55'),(124,3,3,NULL,NULL,NULL,'2023-08-20 20:59:13'),(125,2,2,NULL,NULL,NULL,'2023-08-20 20:59:31'),(126,2,2,NULL,NULL,NULL,'2023-08-20 20:59:42'),(127,2,2,NULL,NULL,NULL,'2023-08-20 20:59:44'),(128,2,2,10,-10,2,'2023-08-20 20:59:50'),(129,2,2,10,-10,2,'2023-08-20 21:02:58'),(130,3,3,NULL,NULL,NULL,'2023-08-20 21:17:08'),(131,2,2,NULL,NULL,NULL,'2023-08-20 21:17:27'),(132,3,3,NULL,NULL,NULL,'2023-08-20 21:57:25'),(133,3,3,NULL,NULL,NULL,'2023-08-20 21:57:37'),(134,2,2,NULL,NULL,NULL,'2023-08-20 21:59:40'),(135,2,2,NULL,NULL,NULL,'2023-08-20 22:00:40'),(136,2,2,NULL,NULL,NULL,'2023-08-20 22:00:42'),(137,2,2,NULL,NULL,NULL,'2023-08-20 22:00:45'),(138,2,2,NULL,NULL,NULL,'2023-08-20 22:00:54'),(139,2,2,NULL,NULL,NULL,'2023-08-20 22:03:05'),(140,2,2,NULL,NULL,NULL,'2023-08-20 22:03:28'),(141,2,2,NULL,NULL,NULL,'2023-08-20 22:04:46'),(142,2,2,10,-10,2,'2023-08-20 22:07:26'),(143,2,2,NULL,NULL,NULL,'2023-08-20 22:09:29'),(144,2,2,10,-10,2,'2023-08-20 22:10:40'),(145,2,2,NULL,NULL,NULL,'2023-08-20 22:13:22'),(146,2,2,NULL,NULL,NULL,'2023-08-20 22:15:06'),(147,2,2,10,-10,2,'2023-08-20 22:16:27'),(148,2,2,NULL,NULL,NULL,'2023-08-20 22:17:05'),(149,2,2,NULL,NULL,NULL,'2023-08-20 22:18:29'),(150,2,2,NULL,NULL,NULL,'2023-08-20 22:18:34'),(151,2,2,NULL,NULL,NULL,'2023-08-20 22:18:35'),(152,2,2,NULL,NULL,NULL,'2023-08-20 22:18:42'),(153,2,5,NULL,NULL,NULL,'2023-08-20 22:21:12'),(154,5,5,NULL,NULL,NULL,'2023-08-20 22:21:41'),(155,2,2,NULL,NULL,NULL,'2023-08-20 22:27:36'),(156,2,2,NULL,NULL,NULL,'2023-08-20 22:27:51'),(157,2,2,10,-10,2,'2023-08-20 22:27:54'),(158,3,2,NULL,NULL,NULL,'2023-08-20 22:36:10'),(159,3,3,NULL,NULL,NULL,'2023-08-20 22:42:23'),(160,2,3,-10,10,3,'2023-08-20 22:43:03'),(161,2,2,NULL,NULL,NULL,'2023-08-20 22:46:04'),(162,2,3,-10,10,3,'2023-08-20 22:46:15'),(163,3,2,-10,10,2,'2023-08-20 22:47:46'),(164,2,3,-10,10,3,'2023-08-20 22:57:35'),(165,2,3,NULL,NULL,NULL,'2023-08-20 23:02:16'),(166,3,2,-10,10,2,'2023-08-20 23:05:50'),(167,2,3,-10,10,3,'2023-08-20 23:13:38'),(168,3,2,-10,10,2,'2023-08-20 23:18:26'),(169,3,2,NULL,NULL,NULL,'2023-08-20 23:23:11'),(170,2,2,NULL,NULL,NULL,'2023-08-20 23:28:07'),(171,2,2,NULL,NULL,NULL,'2023-08-20 23:28:08'),(172,2,2,NULL,NULL,NULL,'2023-08-20 23:28:14'),(173,3,2,-10,10,2,'2023-08-20 23:52:06'),(174,2,2,10,-10,2,'2023-08-20 23:57:16'),(175,3,2,-10,10,2,'2023-08-20 23:57:58'),(176,2,3,-10,10,3,'2023-08-20 23:59:16'),(177,2,2,10,-10,2,'2023-08-21 01:15:17');
/*!40000 ALTER TABLE `matches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `panoramas`
--
DROP TABLE IF EXISTS `panoramas`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `panoramas` (
`panoramaID` int NOT NULL AUTO_INCREMENT,
`cubemap-filename` varchar(256) DEFAULT NULL,
`lat` int DEFAULT NULL,
`lng` int DEFAULT NULL,
PRIMARY KEY (`panoramaID`)
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `panoramas`
--
LOCK TABLES `panoramas` WRITE;
/*!40000 ALTER TABLE `panoramas` DISABLE KEYS */;
INSERT INTO `panoramas` VALUES (1,'offshore-corkus-settlement-cube-map.json',2254,235),(2,'air-temple-lower-cube-map.json',4729,2912),(3,'mysterious-manor-cube-map.json ',2339,1533),(5,'lions-den-cube-map.json',4533,3934),(6,'raiders-base-lower-watch-tower-cube-map.json',4138,3843),(7,'sky-islands-ice-castle-cube-map.json',4533,3954),(9,'zhight-island-yellow-ship-cube-map.json',2754,1815),(132,'renamed5MoKKWERp8cKJyBpN3BaB5.json',4770,2997),(133,'renamedNwRY7QiPHB5MDoKUbSXMTM.json',1817,2902),(134,'renamediPC3vuyXvDXpeRR4BoajTY.json',4526,695),(135,'renamedEyqvnxCCST6yktF7qBTwtH.json',623,2149),(136,'renameddg9n9pqNFzfjvtq5PurygE.json',4579,1260),(137,'renamedWHzbPmWE4KAcpFw5XyScfa.json',2768,875),(138,'renamednouBgZNnaReEzuRKVqZxeZ.json',4431,566),(139,'renamed78oWV4ydXTVjxmdyXbbpuT.json',4703,2860),(140,'renamedaBHQdJU2KBKsk9QZZNdd2d.json',3164,1081),(141,'renamedMDTNvkf8fUH7Hdd8ppUzjT.json',4133,1566),(142,'renamed4DTWYxnyiosCdUAC6t67hR.json',2857,610),(143,'renamedGLPMsxPkwLT8UeCGXchrAK.json',218,1345),(144,'renamedUH5XqRiCZARKJqXsjFkLYx.json',1040,1722),(145,'renamed3qapriavunCVf6NMdJkqzo.json',2005,2153),(146,'renamed3GrsU3LBTk4PvPHfE47uPx.json',4668,384),(147,'renamedAq5avBQQHHBXtAsBj3nr4z.json',4402,1225),(148,'renamedHPd6C8WXdQj9Rey8HFM3Wb.json',1427,3142),(149,'renamed29yeA3ivsLZRMB3xV4wNbN.json',5236,1760),(150,'renamedirWbFDmeRJbCt2Av4dtnhh.json',4145,948),(151,'renamediLUwNkxHWZZ4jEwNZszugo.json',1275,2345),(152,'renamed5MoKKWERp8cKJyBpN3BaB5.json',4770,2997),(153,'renamedNwRY7QiPHB5MDoKUbSXMTM.json',1817,2902),(154,'renamediPC3vuyXvDXpeRR4BoajTY.json',4526,695),(155,'renamedEyqvnxCCST6yktF7qBTwtH.json',623,2149),(156,'renameddg9n9pqNFzfjvtq5PurygE.json',4579,1260),(157,'renamedWHzbPmWE4KAcpFw5XyScfa.json',2768,875),(158,'renamednouBgZNnaReEzuRKVqZxeZ.json',4431,566),(159,'renamed78oWV4ydXTVjxmdyXbbpuT.json',4703,2860),(160,'renamedaBHQdJU2KBKsk9QZZNdd2d.json',3164,1081),(161,'renamedMDTNvkf8fUH7Hdd8ppUzjT.json',4133,1566),(162,'renamed4DTWYxnyiosCdUAC6t67hR.json',2857,610),(163,'renamedGLPMsxPkwLT8UeCGXchrAK.json',218,1345),(164,'renamedUH5XqRiCZARKJqXsjFkLYx.json',1040,1722),(165,'renamed3qapriavunCVf6NMdJkqzo.json',2005,2153),(166,'renamed3GrsU3LBTk4PvPHfE47uPx.json',4668,384),(167,'renamedAq5avBQQHHBXtAsBj3nr4z.json',4402,1225),(168,'renamedHPd6C8WXdQj9Rey8HFM3Wb.json',1427,3142),(169,'renamed29yeA3ivsLZRMB3xV4wNbN.json',5236,1760),(170,'renamedirWbFDmeRJbCt2Av4dtnhh.json',4145,948),(171,'renamediLUwNkxHWZZ4jEwNZszugo.json',1275,2345);
/*!40000 ALTER TABLE `panoramas` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rounds`
--
DROP TABLE IF EXISTS `rounds`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rounds` (
`roundID` int NOT NULL AUTO_INCREMENT,
`matchID` int DEFAULT NULL,
`round_stage` int DEFAULT NULL,
`panoramaID` int DEFAULT NULL,
`score` int DEFAULT NULL,
`lat` int DEFAULT NULL,
`lng` int DEFAULT NULL,
PRIMARY KEY (`roundID`)
) ENGINE=InnoDB AUTO_INCREMENT=584 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `rounds`
--
LOCK TABLES `rounds` WRITE;
/*!40000 ALTER TABLE `rounds` DISABLE KEYS */;
INSERT INTO `rounds` VALUES (214,21,0,147,2720,2543,2720),(215,21,1,147,50000,50000,50000),(216,21,2,142,2720,2543,2720),(217,21,3,142,50000,50000,50000),(218,21,4,149,2720,2543,2720),(219,21,5,149,50000,50000,50000),(220,21,6,7,2720,2543,2720),(221,21,7,7,50000,50000,50000),(222,21,8,133,2720,2543,2720),(223,21,9,133,50000,50000,50000),(224,22,0,144,1270,4772,1270),(225,22,1,144,411,5292,411),(226,22,2,146,829,4610,829),(227,22,3,146,696,4752,696),(228,22,4,141,664,1763,664),(229,22,5,141,1700,4150,1700),(230,22,6,147,2221,4384,2221),(231,22,7,147,1424,4604,1424),(232,22,8,3,1534,2337,1534),(233,22,9,3,50000,50000,50000),(234,27,0,2,1624,3072,1624),(235,27,1,2,50000,50000,50000),(236,27,2,132,1624,3072,1624),(237,27,3,132,50000,50000,50000),(238,27,4,139,1624,3072,1624),(239,27,5,139,50000,50000,50000),(240,27,6,135,1624,3072,1624),(241,27,7,135,50000,50000,50000),(242,27,8,144,1624,3072,1624),(243,27,9,144,50000,50000,50000),(244,71,0,151,171,274,171),(245,71,1,151,97,235,97),(246,71,2,145,100,277,100),(247,71,3,145,246,267,246),(248,71,4,6,150,331,150),(249,71,5,6,225,303,225),(250,71,6,140,289,201,289),(251,71,7,140,219,189,219),(252,71,8,135,136,210,136),(253,71,9,135,172,110,172),(254,79,0,133,-34,347,-34),(255,79,1,133,275,208,275),(256,79,2,133,266,231,266),(257,79,3,133,24,206,24),(258,79,4,4,237,294,237),(259,79,5,4,101,247,101),(260,79,6,151,111,269,111),(261,79,7,151,411,387,411),(262,79,8,2,304,221,304),(263,79,9,2,111,269,111),(264,80,0,138,206,324,206),(265,80,1,138,-8,225,-8),(266,80,2,137,175,259,175),(267,80,3,137,355,174,355),(268,80,4,143,212,276,212),(269,80,5,143,-80,149,-80),(270,80,6,145,66,220,66),(271,80,7,145,50000,50000,50000),(272,80,8,151,223,286,223),(273,80,9,151,53,293,53),(274,81,0,2,41,268,41),(275,81,1,2,3,188,3),(276,81,2,8,313,475,313),(277,81,3,8,154,597,154),(278,81,4,144,267,481,267),(279,81,5,144,312,334,312),(280,81,6,151,334,373,334),(281,81,7,151,172,417,172),(282,81,8,141,183,424,183),(283,81,9,141,263,237,263),(284,82,0,144,178,304,178),(285,82,1,144,50000,50000,50000),(286,82,2,142,211,330,211),(287,82,3,142,50000,50000,50000),(288,82,4,9,241,313,241),(289,82,5,9,50000,50000,50000),(290,82,6,150,173,285,173),(291,82,7,150,50000,50000,50000),(292,82,8,144,191,342,191),(293,82,9,144,50000,50000,50000),(294,83,0,140,2021,3066,2021),(295,83,1,140,276,247,276),(296,83,2,143,1868,3257,1868),(297,83,3,143,97,285,97),(298,83,4,7,1909,3235,1909),(299,83,5,7,140,175,140),(300,83,6,145,2001,3127,2001),(301,83,7,145,174,115,174),(302,83,8,142,2035,3253,2035),(303,83,9,142,203,104,203),(304,96,0,137,3392,3201,3392),(305,96,1,137,50000,50000,50000),(306,96,2,6,2832,3576,2832),(307,96,3,6,2464,2433,2464),(308,96,4,2,2112,2639,2112),(309,96,5,2,2528,2239,2528),(310,96,6,140,2528,2239,2528),(311,96,7,140,784,2618,784),(312,96,8,141,1687,4152,1687),(313,96,9,141,1072,2706,1072),(314,98,0,5,880,2616,880),(315,98,1,5,2672,3278,2672),(316,98,2,8,2104,2352,2104),(317,98,3,8,1952,2711,1952),(318,98,4,6,2120,2208,2120),(319,98,5,6,1600,2480,1600),(320,98,6,143,1792,2703,1792),(321,98,7,143,1408,1784,1408),(322,98,8,6,2000,2559,2000),(323,98,9,6,1704,3905,1704),(324,111,0,138,728,4336,728),(325,111,1,138,312,4392,312),(326,111,2,9,1928,2424,1928),(327,111,3,9,400,3319,400),(328,111,4,1,528,2496,528),(329,111,5,1,344,3144,344),(330,111,6,4,96,3041,96),(331,111,7,4,160,2289,160),(332,111,8,149,544,2966,544),(333,111,9,149,832,2584,832),(334,112,0,146,1320,3024,1320),(335,112,1,146,1200,2639,1200),(336,112,2,144,736,2576,736),(337,112,3,144,288,2016,288),(338,112,4,140,-40,2849,-40),(339,112,5,140,696,2830,696),(340,112,6,147,480,2593,480),(341,112,7,147,864,2617,864),(342,112,8,2,600,3257,600),(343,112,9,2,1208,2569,1208),(344,113,0,138,536,3623,536),(345,113,1,138,856,2448,856),(346,113,2,151,32,2448,32),(347,113,3,151,240,2648,240),(348,113,4,146,1808,3368,1808),(349,113,5,146,496,2960,496),(350,113,6,3,2032,3567,2032),(351,113,7,3,1704,3158,1704),(352,113,8,6,2672,3537,2672),(353,113,9,6,1696,2711,1696),(354,114,0,134,96,3393,96),(355,114,1,134,2208,2657,2208),(356,114,2,139,1248,3800,1248),(357,114,3,139,1200,3286,1200),(358,114,4,4,2192,3805,2192),(359,114,5,4,1088,4665,1088),(360,114,6,140,744,2720,744),(361,114,7,140,1976,3719,1976),(362,114,8,7,1736,3912,1736),(363,114,9,7,-160,2520,-160),(364,115,0,145,2304,3024,2304),(365,115,1,145,896,2960,896),(366,115,2,7,2191,1990,2191),(367,115,3,7,992,2977,992),(368,115,4,135,1992,2608,1992),(369,115,5,135,2206,1988,2206),(370,115,6,146,2091,602,2091),(371,115,7,146,992,2670,992),(372,115,8,148,364,4685,364),(373,115,9,148,2355,568,2355),(374,118,0,9,520,3511,520),(375,118,1,9,-2148,9000,-2148),(376,118,2,134,-1436,1319,-1436),(377,118,3,134,1432,1992,1432),(378,118,4,134,952,2465,952),(379,118,5,134,-8,3295,-8),(380,118,6,135,752,3337,752),(381,118,7,135,344,2759,344),(382,118,8,141,344,2759,344),(383,118,9,141,3080,1440,3080),(384,119,0,143,1696,2959,1696),(385,119,1,143,3024,2480,3024),(386,119,2,151,2136,2742,2136),(387,119,3,151,2712,1943,2712),(388,119,4,142,1760,2528,1760),(389,119,5,142,1864,2689,1864),(390,119,6,4,448,2665,448),(391,119,7,4,1176,2368,1176),(392,119,8,150,488,3017,488),(393,119,9,150,768,976,768),(394,120,0,137,1272,3032,1272),(395,120,1,137,-184,2944,-184),(396,120,2,132,792,2902,792),(397,120,3,132,1864,2161,1864),(398,120,4,5,936,2256,936),(399,120,5,5,1784,3223,1784),(400,120,6,143,848,3177,848),(401,120,7,143,1328,1375,1328),(402,120,8,132,2408,2394,2408),(403,120,9,132,2496,2560,2496),(404,128,0,3,2120,2000,2120),(405,128,1,3,2120,2000,2120),(406,128,2,137,2192,1914,2192),(407,128,3,137,2192,1914,2192),(408,128,4,137,2128,1536,2128),(409,128,5,137,2128,1536,2128),(410,128,6,137,328,2743,328),(411,128,7,137,328,2743,328),(412,128,8,150,160,3257,160),(413,128,9,150,160,3257,160),(414,129,0,140,64,3007,64),(415,129,1,140,64,3007,64),(416,129,2,151,8,2946,8),(417,129,3,151,8,2946,8),(418,129,4,144,2256,2041,2256),(419,129,5,144,2256,2041,2256),(420,129,6,2,2913,4742,2913),(421,129,7,2,2913,4742,2913),(422,129,8,147,1377,4457,1377),(423,129,9,147,1377,4457,1377),(424,142,0,135,2752,2969,2752),(425,142,1,135,2752,2969,2752),(426,142,2,140,904,4569,904),(427,142,3,140,904,4569,904),(428,142,4,133,2238,2090,2238),(429,142,5,133,2238,2090,2238),(430,142,6,138,408,5066,408),(431,142,7,138,408,5066,408),(432,142,8,6,160,5482,160),(433,142,9,6,160,5482,160),(434,144,0,145,4393,2271,4393),(435,144,1,145,4393,2271,4393),(436,144,2,8,4552,1649,4552),(437,144,3,8,4552,1649,4552),(438,144,4,145,3376,951,3376),(439,144,5,145,3376,951,3376),(440,144,6,6,2911,777,2911),(441,144,7,6,2911,777,2911),(442,144,8,6,3328,1097,3328),(443,144,9,6,3328,1097,3328),(444,147,0,5,0,3281,2360),(445,147,1,5,0,3281,2360),(446,147,2,7,0,3281,2360),(447,147,3,7,0,3281,2360),(448,147,4,4,2274,168,408),(449,147,5,4,2274,168,408),(450,147,6,6,2088,312,784),(451,147,7,6,2088,312,784),(452,147,8,148,2360,1488,3016),(453,147,9,148,2360,1488,3016),(454,157,0,144,260,3240,2143),(455,157,1,144,260,3240,2143),(456,157,2,146,0,2785,2913),(457,157,3,146,0,2785,2913),(458,157,4,136,1218,3336,1570),(459,157,5,136,1218,3336,1570),(460,157,6,5,0,3330,2567),(461,157,7,5,0,3330,2567),(462,157,8,145,1164,2054,3488),(463,157,9,145,1164,2054,3488),(464,160,0,147,2104,4567,1585),(465,160,1,147,0,3797,4136),(466,160,2,140,1970,2657,928),(467,160,3,140,2193,3439,945),(468,160,4,141,0,904,2240),(469,160,5,141,1736,3608,2121),(470,160,6,2,0,2432,2674),(471,160,7,2,0,3281,2409),(472,160,8,2,1012,1049,1663),(473,160,9,2,123,2503,1528),(474,162,0,8,2043,552,712),(475,162,1,8,0,2417,2570),(476,162,2,144,2368,922,1782),(477,162,3,144,2239,825,1575),(478,162,4,151,1784,690,2758),(479,162,5,151,1299,2425,2000),(480,162,6,133,981,316,3135),(481,162,7,133,1002,2942,1914),(482,162,8,148,2289,1353,2944),(483,162,9,148,2428,1362,3110),(484,163,0,142,17,4293,2636),(485,163,1,142,0,2823,3256),(486,163,2,143,0,2495,3520),(487,163,3,143,0,2625,4255),(488,163,4,151,769,2815,3136),(489,163,5,151,1627,2137,2207),(490,163,6,143,0,2449,2655),(491,163,7,143,0,2632,2738),(492,163,8,2,0,2625,2671),(493,163,9,2,135,1481,2431),(494,164,0,136,0,2762,3193),(495,164,1,136,0,2112,2462),(496,164,2,2,0,3272,2495),(497,164,3,2,0,3498,1586),(498,164,4,135,0,3152,2793),(499,164,5,135,1137,1983,2247),(500,164,6,133,1534,2735,3200),(501,164,7,133,1645,2302,2198),(502,164,8,4,0,2951,2849),(503,164,9,4,0,2161,2297),(504,166,0,9,0,2201,2647),(505,166,1,9,253,1801,1832),(506,166,2,140,1362,2591,2064),(507,166,3,140,1066,1734,974),(508,166,4,9,514,304,2168),(509,166,5,9,0,50000,50000),(510,166,6,137,1178,1809,1784),(511,166,7,137,0,50000,50000),(512,166,8,145,2109,2072,1768),(513,166,9,145,1696,2639,2648),(514,167,0,151,909,2817,2736),(515,167,1,151,0,50000,50000),(516,167,2,4,0,2073,2368),(517,167,3,4,0,2793,2209),(518,167,4,7,1141,625,1744),(519,167,5,7,893,1791,1286),(520,167,6,8,1237,1655,784),(521,167,7,8,394,2032,1710),(522,167,8,151,849,2918,2178),(523,167,9,151,2054,935,2056),(524,168,0,5,0,2352,4384),(525,168,1,5,0,3127,3560),(526,168,2,146,703,3824,1970),(527,168,3,146,0,1623,2873),(528,168,4,139,591,2969,2062),(529,168,5,139,0,1592,2102),(530,168,6,133,627,3206,1646),(531,168,7,133,1167,2665,1874),(532,168,8,144,888,2503,2399),(533,168,9,144,918,2287,2694),(534,173,0,150,677,2565,1857),(535,173,1,150,2020,4043,1417),(536,173,2,150,2017,4055,1422),(537,173,3,150,2477,4124,958),(538,173,4,136,2254,4806,1166),(539,173,5,136,2210,4491,1536),(540,173,6,3,2400,296,232),(541,173,7,3,1954,681,-160),(542,173,8,3,2282,64,16),(543,173,9,3,2122,489,432),(544,174,0,133,2100,1641,2543),(545,174,1,133,2100,1641,2543),(546,174,2,6,0,2495,2241),(547,174,3,6,0,2495,2241),(548,174,4,4,492,1031,1968),(549,174,5,4,492,1031,1968),(550,174,6,138,0,1079,1024),(551,174,7,138,0,1079,1024),(552,174,8,148,1007,1216,1664),(553,174,9,148,1007,1216,1664),(554,175,0,146,0,1391,3088),(555,175,1,146,0,4486,-2744),(556,175,2,4,0,5926,896),(557,175,3,4,1896,680,232),(558,175,4,6,0,1710,2656),(559,175,5,6,1049,1608,-439),(560,175,6,139,125,2381,2360),(561,175,7,139,44,2358,2128),(562,175,8,146,1919,4365,880),(563,175,9,146,2046,4486,800),(564,176,0,6,0,2272,2826),(565,176,1,6,0,1815,3144),(566,176,2,147,218,2350,2224),(567,176,3,147,484,2474,1814),(568,176,4,8,0,2295,2376),(569,176,5,8,0,1832,2457),(570,176,6,4,0,2414,2216),(571,176,7,4,0,2463,2062),(572,176,8,141,2308,4122,1758),(573,176,9,141,0,1350,2112),(574,177,0,6,0,1209,2640),(575,177,1,6,0,1209,2640),(576,177,2,1,2500,2253,233),(577,177,3,1,2500,2253,233),(578,177,4,5,2424,2160,3131),(579,177,5,5,2424,2160,3131),(580,177,6,3,2500,2339,1529),(581,177,7,3,2500,2339,1529),(582,177,8,7,2500,4533,3951),(583,177,9,7,2500,4533,3951);
/*!40000 ALTER TABLE `rounds` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
`id` int NOT NULL AUTO_INCREMENT,
`username` varchar(20) DEFAULT NULL,
`email` varchar(256) DEFAULT NULL,
`pwd` varchar(256) DEFAULT NULL,
`elo` int DEFAULT '1000',
`creation-time` datetime DEFAULT CURRENT_TIMESTAMP,
`is-admin` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'asdfafd','asdfasfd@123123gmail.com','$2y$12$8XeLkw05yCLxxOWsuJOf8emeJcpegJFgq0xOa/VlevFAwgW59LONy',1000,'2023-08-03 22:00:56',0),(2,'root','root@root.co','$2y$12$eSsgW0K73kiv54qz3IpS/OwiddOgJecO9vS44ZB05x4BBKcbSLHnm',1020,'2023-08-03 22:01:27',0),(3,'ammel','ae@22.cmo','$2y$12$aRLGY6bgdTBMBiLkMkjiUu/qFEajPXqMGY.eR9gU2Vr28MY8mnhRu',990,'2023-08-05 23:19:25',0),(4,'gamer','gamer@vom.com','$2y$12$P1.1Eo58scWmUR.R.yXAruzDkIUYciadf8aW4XhKGDDc69v97LV72',1000,'2023-08-14 18:17:51',0),(5,'pop','opop@afd1.com','$2y$12$MJ251oQ15WoctHg0crV42e/wWAeCkVbWVc960CLRdBlHvfAMxq7Ma',1000,'2023-08-14 18:18:31',0),(6,'Caywu','kaivonnassau@gmail.com','$2y$12$pR.FeVnehDls3GIV3XWClOUMhLHRbw3898Cwj.vU7boXgtwNH80GK',990,'2023-08-19 23:13:13',0);
/*!40000 ALTER TABLE `users` 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 2023-08-26 16:44:55