2QN7Mamj

1DELETE FROM delirium.top15;
2DELETE FROM delirium.users;
3
4CREATE DATABASE IF NOT EXISTS delirium;
5
6CREATE TABLE IF NOT EXISTS delirium.users (
7    steamid VARCHAR(32) PRIMARY KEY,
8    nickname VARCHAR(32),
9    lastseen TIMESTAMP DEFAULT NOW()
10    );
11/*
12DROP TABLE delirium.top15;
13*/
14CREATE TABLE IF NOT EXISTS delirium.top15 (
15    id INT AUTO_INCREMENT PRIMARY KEY,
16    steamid VARCHAR(32),
17    timespeed float(10,6),
18    mapname VARCHAR(64),
19    toptype enum('pro15','nub15')
20    );
21    
22/*
23INSERT INTO delirium.users VALUES("STEAM_0:1:6024394", "ogelami", default);
24INSERT INTO delirium.users VALUES("STEAM_ID_LAN", "lanbanan", default);
25
26INSERT INTO delirium.top15 VALUES(default, "STEAM:d9d9a9a0wd", "401.529902", "df_sinisterblock", 'pro15');
27INSERT INTO delirium.top15 VALUES(default, "STEAM:fwfw", "402.529902", "df_sinisterblocke", 'pro15');
28INSERT INTO delirium.top15 VALUES(default, "STEAM:weqwe", "23.529902", "df_sinisterblock", 'nub15');
29INSERT INTO delirium.top15 VALUES(default, "STEAM:gqwgq", "66.529902", "df_sinisterblock", 'pro15');
30
31DELETE FROM delirium.users WHERE steamid = 'STEAM_ID_LAN';
32
33INSERT INTO delirium.top15 VALUES (default, 'STEAM_ID_LAN', 1.194074, 'df_test', 'pro15')
34*/
35SELECT mapname, steamid, timespeed FROM delirium.top15 WHERE toptype = 'pro15' AND mapname = "df_sinisterblock" ORDER BY timespeed;
36SELECT * FROM delirium.top15;
37SELECT * FROM delirium.users;
38
39SELECT nickname FROM delirium.users WHERE steamid = 'STEAM_ID_LAN';
40SELECT id FROM delirium.top15 WHERE steamid = 'STEAM_ID_LAN' AND mapname = 'df_slackline_s' AND timespeed > 10.544665