summaryrefslogtreecommitdiff
path: root/table_info.sql
blob: c5544afa2ba41b271c7ac4f20fefffed8c8274d7 (plain)
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
--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` text NOT NULL,
  `smessage` text NOT NULL,
  `image` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `type` (`type`(7)) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Data for table `events`
--


INSERT INTO `events` (`id`, `type`, `smessage`, `image`) VALUES
(1, 'Skeletons', 'Skeleton Surprise', 'skeleton.png'),
(2, 'Blobs', '..', 'Ooze.png'),
(3, 'Foresttrolls', 'The ground is shaking', 'troll.png'),
(4, 'Wolves', 'You are being hunted', 'wolf.png'),
(5, 'Surtlings', 'There\'s a smell of sulfur in the air', 'surtling.png'),
(6, 'Eikthyrnir', 'Meadows', 'Eikthyr.png'),
(7, 'GDKing', 'Black Forest', 'The_Elder.png'),
(8, 'Bonemass', 'Swamp', 'Bonemass.png'),
(9, 'Dragonqueen', 'Mountain', 'Moder.png'),
(10, 'GoblinKing', 'Plains', 'Yagluth.png'),
(11, 'army_eikthyr', 'Eikthyr rallies the creatures of the forest', 'Boar.png'),
(12, 'army_theelder', 'The forest is moving...', 'Greydwarf.png'),
(13, 'army_bonemass', 'A foul smell from the swamp', 'Draugr.png'),
(14, 'army_moder', 'A cold wind blows from the mountains', 'Drake.png'),
(15, 'army_goblin', 'The horde is attacking', 'Fuling.png');

--
-- Table structure for table `exstats` (Optinal Table only needed if enabling Extra Server Info in Config)
--

CREATE TABLE `exstats` (
  `id` int NOT NULL AUTO_INCREMENT,
  `savezdos` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `savesec` varchar(10) DEFAULT NULL,
  `worldsize` varchar(10) DEFAULT NULL,
  `serverversion` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `plusversion` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `gameday` int DEFAULT NULL,
  `timestamp` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `players`
--

CREATE TABLE `players` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user` varchar(100) NOT NULL,
  `deaths` int NOT NULL DEFAULT '0',
  `valid` varchar(50) DEFAULT NULL,
  `startdate` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `playtime` bigint DEFAULT '0',
  `jointime` bigint DEFAULT NULL,
  `ingame` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `users` (`user`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `serverstats`
--

CREATE TABLE `serverstats` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` varchar(20) DEFAULT NULL,
  `timestamp` bigint DEFAULT NULL,
  `users` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;