Dr.Spy-Serverless/sample_data.sql at master · StDensity/Dr.Spy-Serverless · GitHub

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
PRAGMA defer_foreign_keys=TRUE;
CREATE TABLE activity (
    id INTEGER PRIMARY KEY AUTOINCREMENT,  -- Unique entry ID
    timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,  -- When data was collected
    active_players INTEGER  -- Number of active players at the time
);
INSERT INTO activity VALUES(1,'2025-01-31 08:00:28',0);
INSERT INTO activity VALUES(2,'2025-01-31 08:10:28',0);
INSERT INTO activity VALUES(3,'2025-01-31 08:20:28',5);
INSERT INTO activity VALUES(4,'2025-01-31 08:30:28',4);
INSERT INTO activity VALUES(5,'2025-01-31 08:40:28',4);
INSERT INTO activity VALUES(6,'2025-01-31 08:50:28',4);
INSERT INTO activity VALUES(7,'2025-01-31 09:00:28',6);
INSERT INTO activity VALUES(8,'2025-01-31 09:10:28',6);
INSERT INTO activity VALUES(9,'2025-01-31 09:20:28',0);
INSERT INTO activity VALUES(10,'2025-01-31 09:30:28',0);
INSERT INTO activity VALUES(11,'2025-01-31 09:40:28',0);
INSERT INTO activity VALUES(12,'2025-01-31 09:50:28',0);
INSERT INTO activity VALUES(13,'2025-01-31 10:00:32',0);
INSERT INTO activity VALUES(14,'2025-01-31 10:10:27',0);
INSERT INTO activity VALUES(15,'2025-01-31 10:20:28',3);
INSERT INTO activity VALUES(16,'2025-01-31 10:30:31',5);
INSERT INTO activity VALUES(17,'2025-01-31 10:40:27',6);
INSERT INTO activity VALUES(18,'2025-01-31 10:50:27',4);
INSERT INTO activity VALUES(19,'2025-01-31 11:00:27',1);
INSERT INTO activity VALUES(20,'2025-01-31 11:10:27',1);
INSERT INTO activity VALUES(21,'2025-01-31 11:20:27',1);
INSERT INTO activity VALUES(22,'2025-01-31 11:30:28',1);
INSERT INTO activity VALUES(23,'2025-01-31 11:40:28',1);
INSERT INTO activity VALUES(24,'2025-01-31 11:50:28',1);
INSERT INTO activity VALUES(25,'2025-01-31 12:00:28',1);
INSERT INTO activity VALUES(26,'2025-01-31 12:10:27',0);
INSERT INTO activity VALUES(27,'2025-01-31 12:20:27',0);
INSERT INTO activity VALUES(28,'2025-01-31 12:30:59',1);
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('activity',28);
CREATE INDEX idx_timestamp ON activity (timestamp);