diff options
author | stolenvw <stolenvw@hotmail.com> | 2021-04-02 18:13:17 -0400 |
---|---|---|
committer | stolenvw <stolenvw@hotmail.com> | 2021-04-02 18:13:17 -0400 |
commit | 14e29dd15037c9368081bfb0a9ac5c689c289eb4 (patch) | |
tree | c8dcdb93d7e2f3894eccd941d7bfb87826569ef9 /table_info.sql | |
parent | bf99d7c230228385e5fa29b024301c3dfde8144e (diff) |
Valheim plus discord bot
Diffstat (limited to 'table_info.sql')
-rw-r--r-- | table_info.sql | 80 |
1 files changed, 80 insertions, 0 deletions
diff --git a/table_info.sql b/table_info.sql new file mode 100644 index 0000000..c5544af --- /dev/null +++ b/table_info.sql @@ -0,0 +1,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; |