· 10 years ago · Aug 21, 2016, 07:44 PM
1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4
5/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
6/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
7/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
8/*!40101 SET NAMES utf8mb4 */;
9
10-- --------------------------------------------------------
11
12--
13-- Table structure for table `admins`
14--
15-- Creation: Aug 18, 2016 at 01:18 PM
16-- Last update: Aug 21, 2016 at 07:40 PM
17--
18
19DROP TABLE IF EXISTS `admins`;
20CREATE TABLE `admins` (
21 `id` int(3) NOT NULL,
22 `username` varchar(32) NOT NULL,
23 `password` varchar(128) NOT NULL,
24 `pGroup` int(2) NOT NULL,
25 `lastLogin` int(20) NOT NULL,
26 `lastIP` varchar(30) NOT NULL
27) ENGINE=InnoDB DEFAULT CHARSET=utf8;
28
29-- --------------------------------------------------------
30
31--
32-- Table structure for table `admin_logs`
33--
34-- Creation: Aug 19, 2016 at 07:31 PM
35-- Last update: Aug 21, 2016 at 07:40 PM
36--
37
38DROP TABLE IF EXISTS `admin_logs`;
39CREATE TABLE `admin_logs` (
40 `id` int(10) NOT NULL,
41 `action` varchar(64) NOT NULL,
42 `value` varchar(64) NOT NULL,
43 `adminID` int(10) NOT NULL,
44 `ip` varchar(30) NOT NULL,
45 `datetime` int(20) NOT NULL
46) ENGINE=InnoDB DEFAULT CHARSET=utf8;
47
48-- --------------------------------------------------------
49
50--
51-- Table structure for table `bans`
52--
53-- Creation: Aug 19, 2016 at 05:09 PM
54-- Last update: Aug 21, 2016 at 07:40 PM
55--
56
57DROP TABLE IF EXISTS `bans`;
58CREATE TABLE `bans` (
59 `id` int(10) NOT NULL,
60 `email` varchar(64) NOT NULL,
61 `bannedBy` int(10) NOT NULL,
62 `datetime` int(20) NOT NULL
63) ENGINE=InnoDB DEFAULT CHARSET=utf8;
64
65-- --------------------------------------------------------
66
67--
68-- Table structure for table `logs`
69--
70-- Creation: Aug 20, 2016 at 01:27 AM
71--
72
73DROP TABLE IF EXISTS `logs`;
74CREATE TABLE `logs` (
75 `id` int(10) NOT NULL,
76 `username` varchar(64) NOT NULL,
77 `email` varchar(64) NOT NULL,
78 `steamid` varchar(24) NOT NULL,
79 `hwid` varchar(64) NOT NULL,
80 `ip` varchar(30) NOT NULL,
81 `location` varchar(64) NOT NULL,
82 `version` varchar(64) NOT NULL,
83 `datetime` int(20) NOT NULL
84) ENGINE=InnoDB DEFAULT CHARSET=utf8;
85
86-- --------------------------------------------------------
87
88--
89-- Table structure for table `settings`
90--
91-- Creation: Aug 18, 2016 at 04:23 PM
92-- Last update: Aug 21, 2016 at 07:27 PM
93--
94
95DROP TABLE IF EXISTS `settings`;
96CREATE TABLE `settings` (
97 `site` int(1) NOT NULL,
98 `siteName` varchar(64) NOT NULL,
99 `apiKey` varchar(60) NOT NULL,
100 `panelPath` varchar(64) NOT NULL,
101 `disabled` int(1) NOT NULL
102) ENGINE=InnoDB DEFAULT CHARSET=utf8;
103
104--
105-- Dumping data for table `settings`
106--
107
108INSERT INTO `settings` (`site`, `siteName`, `apiKey`, `panelPath`, `disabled`) VALUES
109(1, 'MIDNIGHT', 'A1F157D8EE5E5D23248CB9F8A804004B', '/api', 0);
110
111-- --------------------------------------------------------
112
113--
114-- Table structure for table `warnings`
115--
116-- Creation: Aug 20, 2016 at 05:46 PM
117--
118
119DROP TABLE IF EXISTS `warnings`;
120CREATE TABLE `warnings` (
121 `id` int(10) NOT NULL,
122 `email` varchar(64) NOT NULL,
123 `old_username` varchar(64) NOT NULL,
124 `old_steamid` varchar(24) NOT NULL,
125 `old_hwid` varchar(64) NOT NULL,
126 `old_ip` varchar(64) NOT NULL,
127 `old_location` varchar(64) NOT NULL,
128 `old_datetime` int(20) NOT NULL,
129 `new_username` varchar(64) NOT NULL,
130 `new_steamid` varchar(24) NOT NULL,
131 `new_hwid` varchar(64) NOT NULL,
132 `new_ip` varchar(64) NOT NULL,
133 `new_location` varchar(64) NOT NULL,
134 `datetime` int(20) NOT NULL,
135 `checked` int(1) NOT NULL
136) ENGINE=InnoDB DEFAULT CHARSET=utf8;
137
138--
139-- Indexes for dumped tables
140--
141
142--
143-- Indexes for table `admins`
144--
145ALTER TABLE `admins`
146 ADD PRIMARY KEY (`id`);
147
148--
149-- Indexes for table `admin_logs`
150--
151ALTER TABLE `admin_logs`
152 ADD PRIMARY KEY (`id`);
153
154--
155-- Indexes for table `bans`
156--
157ALTER TABLE `bans`
158 ADD PRIMARY KEY (`id`);
159
160--
161-- Indexes for table `logs`
162--
163ALTER TABLE `logs`
164 ADD PRIMARY KEY (`id`);
165
166--
167-- Indexes for table `settings`
168--
169ALTER TABLE `settings`
170 ADD PRIMARY KEY (`site`);
171
172--
173-- Indexes for table `warnings`
174--
175ALTER TABLE `warnings`
176 ADD PRIMARY KEY (`id`);
177
178--
179-- AUTO_INCREMENT for dumped tables
180--
181
182--
183-- AUTO_INCREMENT for table `admins`
184--
185ALTER TABLE `admins`
186 MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
187--
188-- AUTO_INCREMENT for table `admin_logs`
189--
190ALTER TABLE `admin_logs`
191 MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
192--
193-- AUTO_INCREMENT for table `bans`
194--
195ALTER TABLE `bans`
196 MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
197--
198-- AUTO_INCREMENT for table `logs`
199--
200ALTER TABLE `logs`
201 MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
202--
203-- AUTO_INCREMENT for table `warnings`
204--
205ALTER TABLE `warnings`
206 MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
207/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
208/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
209/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;