· 8 years ago · Feb 17, 2018, 02:02 AM
1ubuntu@ip-172-31-31-43:~$ cat /home/steam/schema.sql
2-- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
3--
4-- Host: localhost Database: steam
5-- ------------------------------------------------------
6-- Server version 5.7.21-0ubuntu0.16.04.1
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
10/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
11/*!40101 SET NAMES utf8 */;
12/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
13/*!40103 SET TIME_ZONE='+00:00' */;
14/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
15/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
16/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
17/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
18
19--
20-- Table structure for table `kills`
21--
22
23DROP TABLE IF EXISTS `kills`;
24/*!40101 SET @saved_cs_client = @@character_set_client */;
25/*!40101 SET character_set_client = utf8 */;
26CREATE TABLE `kills` (
27 `steamId` char(65) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
28 `kills` char(65) DEFAULT NULL,
29 `deaths` char(65) DEFAULT NULL,
30 `hskills` char(65) DEFAULT NULL,
31 PRIMARY KEY (`steamId`)
32) ENGINE=InnoDB DEFAULT CHARSET=latin1;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Table structure for table `rounds`
37--
38
39DROP TABLE IF EXISTS `rounds`;
40/*!40101 SET @saved_cs_client = @@character_set_client */;
41/*!40101 SET character_set_client = utf8 */;
42CREATE TABLE `rounds` (
43 `steamId` char(65) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
44 `rounds` char(65) DEFAULT NULL,
45 `wins` char(65) DEFAULT NULL,
46 PRIMARY KEY (`steamId`)
47) ENGINE=InnoDB DEFAULT CHARSET=latin1;
48/*!40101 SET character_set_client = @saved_cs_client */;
49
50--
51-- Table structure for table `sm_admins`
52--
53
54DROP TABLE IF EXISTS `sm_admins`;
55/*!40101 SET @saved_cs_client = @@character_set_client */;
56/*!40101 SET character_set_client = utf8 */;
57CREATE TABLE `sm_admins` (
58 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
59 `authtype` enum('steam','name','ip') NOT NULL,
60 `identity` varchar(65) NOT NULL,
61 `password` varchar(65) DEFAULT NULL,
62 `flags` varchar(30) NOT NULL,
63 `name` varchar(65) NOT NULL,
64 `immunity` int(10) unsigned NOT NULL,
65 PRIMARY KEY (`id`)
66) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Table structure for table `sm_admins_groups`
71--
72
73DROP TABLE IF EXISTS `sm_admins_groups`;
74/*!40101 SET @saved_cs_client = @@character_set_client */;
75/*!40101 SET character_set_client = utf8 */;
76CREATE TABLE `sm_admins_groups` (
77 `admin_id` int(10) unsigned NOT NULL,
78 `group_id` int(10) unsigned NOT NULL,
79 `inherit_order` int(10) NOT NULL,
80 PRIMARY KEY (`admin_id`,`group_id`)
81) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82/*!40101 SET character_set_client = @saved_cs_client */;
83
84--
85-- Table structure for table `sm_config`
86--
87
88DROP TABLE IF EXISTS `sm_config`;
89/*!40101 SET @saved_cs_client = @@character_set_client */;
90/*!40101 SET character_set_client = utf8 */;
91CREATE TABLE `sm_config` (
92 `cfg_key` varchar(32) NOT NULL,
93 `cfg_value` varchar(255) NOT NULL,
94 PRIMARY KEY (`cfg_key`)
95) ENGINE=InnoDB DEFAULT CHARSET=latin1;
96/*!40101 SET character_set_client = @saved_cs_client */;
97
98--
99-- Table structure for table `sm_group_immunity`
100--
101
102DROP TABLE IF EXISTS `sm_group_immunity`;
103/*!40101 SET @saved_cs_client = @@character_set_client */;
104/*!40101 SET character_set_client = utf8 */;
105CREATE TABLE `sm_group_immunity` (
106 `group_id` int(10) unsigned NOT NULL,
107 `other_id` int(10) unsigned NOT NULL,
108 PRIMARY KEY (`group_id`,`other_id`)
109) ENGINE=InnoDB DEFAULT CHARSET=latin1;
110/*!40101 SET character_set_client = @saved_cs_client */;
111
112--
113-- Table structure for table `sm_group_overrides`
114--
115
116DROP TABLE IF EXISTS `sm_group_overrides`;
117/*!40101 SET @saved_cs_client = @@character_set_client */;
118/*!40101 SET character_set_client = utf8 */;
119CREATE TABLE `sm_group_overrides` (
120 `group_id` int(10) unsigned NOT NULL,
121 `type` enum('command','group') NOT NULL,
122 `name` varchar(32) NOT NULL,
123 `access` enum('allow','deny') NOT NULL,
124 PRIMARY KEY (`group_id`,`type`,`name`)
125) ENGINE=InnoDB DEFAULT CHARSET=latin1;
126/*!40101 SET character_set_client = @saved_cs_client */;
127
128--
129-- Table structure for table `sm_groups`
130--
131
132DROP TABLE IF EXISTS `sm_groups`;
133/*!40101 SET @saved_cs_client = @@character_set_client */;
134/*!40101 SET character_set_client = utf8 */;
135CREATE TABLE `sm_groups` (
136 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
137 `flags` varchar(30) NOT NULL,
138 `name` varchar(120) NOT NULL,
139 `immunity_level` int(1) unsigned NOT NULL,
140 PRIMARY KEY (`id`)
141) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
142/*!40101 SET character_set_client = @saved_cs_client */;
143
144--
145-- Table structure for table `sm_overrides`
146--
147
148DROP TABLE IF EXISTS `sm_overrides`;
149/*!40101 SET @saved_cs_client = @@character_set_client */;
150/*!40101 SET character_set_client = utf8 */;
151CREATE TABLE `sm_overrides` (
152 `type` enum('command','group') NOT NULL,
153 `name` varchar(32) NOT NULL,
154 `flags` varchar(30) NOT NULL,
155 PRIMARY KEY (`type`,`name`)
156) ENGINE=InnoDB DEFAULT CHARSET=latin1;
157/*!40101 SET character_set_client = @saved_cs_client */;
158
159--
160-- Table structure for table `steam`
161--
162
163DROP TABLE IF EXISTS `steam`;
164/*!40101 SET @saved_cs_client = @@character_set_client */;
165/*!40101 SET character_set_client = utf8 */;
166CREATE TABLE `steam` (
167 `steamId` char(65) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
168 `rank` char(65) DEFAULT NULL,
169 `age` char(65) DEFAULT NULL,
170 PRIMARY KEY (`steamId`)
171) ENGINE=InnoDB DEFAULT CHARSET=latin1;
172/*!40101 SET character_set_client = @saved_cs_client */;
173
174--
175-- Table structure for table `steamname`
176--
177
178DROP TABLE IF EXISTS `steamname`;
179/*!40101 SET @saved_cs_client = @@character_set_client */;
180/*!40101 SET character_set_client = utf8 */;
181CREATE TABLE `steamname` (
182 `steamId` char(65) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
183 `name` char(255) DEFAULT NULL,
184 PRIMARY KEY (`steamId`)
185) ENGINE=InnoDB DEFAULT CHARSET=latin1;
186/*!40101 SET character_set_client = @saved_cs_client */;
187/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
188
189/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
190/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
191/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
192/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
193/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
194/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
195/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
196
197-- Dump completed on 2018-02-07 13:51:02
198ubuntu@ip-172-31-31-43:~$