-
-
Save wfjsw/4615638fd71a9730f0e914f87d9735b7 to your computer and use it in GitHub Desktop.
YAKS Database Schema
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Navicat Premium Data Transfer | |
| Source Server : Big | |
| Source Server Type : PostgreSQL | |
| Source Server Version : 110000 | |
| Source Host : localhost:5432 | |
| Source Catalog : kedama_stats | |
| Source Schema : public | |
| Target Server Type : PostgreSQL | |
| Target Server Version : 110000 | |
| File Encoding : 65001 | |
| Date: 08/12/2018 17:09:27 | |
| */ | |
| -- ---------------------------- | |
| -- Table structure for T_player_info | |
| -- ---------------------------- | |
| DROP TABLE IF EXISTS "public"."T_player_info"; | |
| CREATE TABLE "public"."T_player_info" ( | |
| "uuid" char(32) COLLATE "pg_catalog"."default" NOT NULL, | |
| "banned" bool NOT NULL, | |
| "names" jsonb, | |
| "playername" text COLLATE "pg_catalog"."default" NOT NULL, | |
| "seen" int8 NOT NULL, | |
| "time_last" int8 NOT NULL, | |
| "time_lived" int4 NOT NULL, | |
| "time_start" int8 NOT NULL, | |
| "lastUpdate" int8 | |
| ) | |
| ; | |
| -- ---------------------------- | |
| -- Table structure for T_server_ping | |
| -- ---------------------------- | |
| DROP TABLE IF EXISTS "public"."T_server_ping"; | |
| CREATE TABLE "public"."T_server_ping" ( | |
| "id" int8 NOT NULL DEFAULT nextval('"T_server_ping_id_seq"'::regclass), | |
| "timestamp" int4 NOT NULL, | |
| "server_name" text COLLATE "pg_catalog"."default", | |
| "online" int2 NOT NULL | |
| ) | |
| ; | |
| -- ---------------------------- | |
| -- Uniques structure for table T_player_info | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_info" ADD CONSTRAINT "uuid" UNIQUE ("uuid"); | |
| -- ---------------------------- | |
| -- Primary Key structure for table T_player_info | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_info" ADD CONSTRAINT "T_player_info_pkey" PRIMARY KEY ("uuid", "playername"); | |
| -- ---------------------------- | |
| -- Primary Key structure for table T_server_ping | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_server_ping" ADD CONSTRAINT "T_server_ping_pkey" PRIMARY KEY ("id"); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Navicat Premium Data Transfer | |
| Source Server : Big | |
| Source Server Type : PostgreSQL | |
| Source Server Version : 110000 | |
| Source Host : localhost:5432 | |
| Source Catalog : kedama_stats | |
| Source Schema : public | |
| Target Server Type : PostgreSQL | |
| Target Server Version : 110000 | |
| File Encoding : 65001 | |
| Date: 08/12/2018 17:09:10 | |
| */ | |
| -- ---------------------------- | |
| -- Table structure for T_player_stats_broken | |
| -- ---------------------------- | |
| DROP TABLE IF EXISTS "public"."T_player_stats_broken"; | |
| CREATE TABLE "public"."T_player_stats_broken" ( | |
| "id" int8 NOT NULL DEFAULT nextval('"T_player_stats_broken_id_seq"'::regclass), | |
| "uuid" char(32) COLLATE "pg_catalog"."default", | |
| "lastUpdate" int8, | |
| "diamond_helmet" int4, | |
| "shears" int4, | |
| "diamond_shovel" int4, | |
| "wooden_sword" int4, | |
| "fishing_rod" int4, | |
| "iron_hoe" int4, | |
| "stone_hoe" int4, | |
| "wooden_hoe" int4, | |
| "diamond_hoe" int4, | |
| "diamond_axe" int4, | |
| "golden_sword" int4, | |
| "iron_sword" int4, | |
| "bow" int4, | |
| "stone_sword" int4, | |
| "flint_and_steel" int4, | |
| "iron_leggings" int4, | |
| "diamond_pickaxe" int4, | |
| "iron_pickaxe" int4, | |
| "iron_shovel" int4, | |
| "stone_pickaxe" int4, | |
| "iron_boots" int4, | |
| "iron_chestplate" int4, | |
| "iron_axe" int4, | |
| "iron_helmet" int4, | |
| "wooden_axe" int4, | |
| "stone_shovel" int4, | |
| "wooden_pickaxe" int4, | |
| "shield" int4, | |
| "leather_leggings" int4, | |
| "stone_axe" int4, | |
| "golden_boots" int4, | |
| "wooden_shovel" int4, | |
| "leather_helmet" int4, | |
| "chainmail_leggings" int4, | |
| "golden_helmet" int4, | |
| "golden_leggings" int4, | |
| "chainmail_chestplate" int4, | |
| "golden_chestplate" int4, | |
| "leather_boots" int4, | |
| "leather_chestplate" int4, | |
| "diamond_leggings" int4, | |
| "diamond_sword" int4, | |
| "diamond_chestplate" int4, | |
| "chainmail_helmet" int4, | |
| "diamond_boots" int4, | |
| "golden_pickaxe" int4, | |
| "golden_hoe" int4, | |
| "chainmail_boots" int4, | |
| "golden_axe" int4, | |
| "golden_shovel" int4 | |
| ) | |
| ; | |
| -- ---------------------------- | |
| -- Table structure for T_player_stats_crafted | |
| -- ---------------------------- | |
| DROP TABLE IF EXISTS "public"."T_player_stats_crafted"; | |
| CREATE TABLE "public"."T_player_stats_crafted" ( | |
| "id" int8 NOT NULL DEFAULT nextval('"T_player_stats_crafted_id_seq"'::regclass), | |
| "uuid" char(32) COLLATE "pg_catalog"."default", | |
| "lastUpdate" int8, | |
| "melon" int4, | |
| "birch_boat" int4, | |
| "blaze_powder" int4, | |
| "diamond_shovel" int4, | |
| "nether_brick" int4, | |
| "shulker_box" int4, | |
| "beacon" int4, | |
| "stone_pressure_plate" int4, | |
| "iron_door" int4, | |
| "lime_concrete_powder" int4, | |
| "redstone_lamp" int4, | |
| "end_rod" int4, | |
| "jungle_boat" int4, | |
| "chest_minecart" int4, | |
| "sticky_piston" int4, | |
| "stone_brick_stairs" int4, | |
| "wooden_hoe" int4, | |
| "stone_slab" int4, | |
| "iron_pickaxe" int4, | |
| "sandstone" int4, | |
| "golden_carrot" int4, | |
| "jukebox" int4, | |
| "iron_nugget" int4, | |
| "diamond_hoe" int4, | |
| "jack_o_lantern" int4, | |
| "spruce_fence" int4, | |
| "spruce_stairs" int4, | |
| "stone_pickaxe" int4, | |
| "spruce_boat" int4, | |
| "lead" int4, | |
| "light_blue_glazed_terracotta" int4, | |
| "leather_helmet" int4, | |
| "enchanted_book" int4, | |
| "oak_fence_gate" int4, | |
| "fermented_spider_eye" int4, | |
| "birch_trapdoor" int4, | |
| "writable_book" int4, | |
| "iron_shovel" int4, | |
| "armor_stand" int4, | |
| "note_block" int4, | |
| "stone" int4, | |
| "snow" int4, | |
| "heavy_weighted_pressure_plate" int4, | |
| "cake" int4, | |
| "stone_brick_slab" int4, | |
| "bow" int4, | |
| "comparator" int4, | |
| "chest" int4, | |
| "oak_button" int4, | |
| "rail" int4, | |
| "ender_eye" int4, | |
| "stone_bricks" int4, | |
| "oak_fence" int4, | |
| "sea_lantern" int4, | |
| "dropper" int4, | |
| "arrow" int4, | |
| "cauldron" int4, | |
| "iron_helmet" int4, | |
| "spectral_arrow" int4, | |
| "white_stained_glass_pane" int4, | |
| "dispenser" int4, | |
| "tnt" int4, | |
| "stick" int4, | |
| "iron_ingot" int4, | |
| "dark_oak_fence_gate" int4, | |
| "orange_glazed_terracotta" int4, | |
| "oak_door" int4, | |
| "fishing_rod" int4, | |
| "tripwire_hook" int4, | |
| "leather_boots" int4, | |
| "furnace" int4, | |
| "piston" int4, | |
| "oak_trapdoor" int4, | |
| "flint_and_steel" int4, | |
| "white_concrete_powder" int4, | |
| "cobblestone_wall" int4, | |
| "purpur_block" int4, | |
| "glistering_melon_slice" int4, | |
| "ink_sac" int4, | |
| "iron_trapdoor" int4, | |
| "iron_sword" int4, | |
| "black_banner" int4, | |
| "sign" int4, | |
| "acacia_boat" int4, | |
| "jungle_planks" int4, | |
| "jungle_door" int4, | |
| "anvil" int4, | |
| "torch" int4, | |
| "ender_chest" int4, | |
| "light_gray_concrete_powder" int4, | |
| "oak_pressure_plate" int4, | |
| "birch_slab" int4, | |
| "slime_block" int4, | |
| "lever" int4, | |
| "bookshelf" int4, | |
| "iron_bars" int4, | |
| "red_concrete_powder" int4, | |
| "quartz_block" int4, | |
| "glass" int4, | |
| "light_blue_terracotta" int4, | |
| "repeater" int4, | |
| "melon_seeds" int4, | |
| "birch_fence_gate" int4, | |
| "acacia_fence" int4, | |
| "birch_door" int4, | |
| "cooked_rabbit" int4, | |
| "glass_bottle" int4, | |
| "emerald" int4, | |
| "diamond_axe" int4, | |
| "spruce_door" int4, | |
| "clock" int4, | |
| "hay_block" int4, | |
| "oak_wood" int4, | |
| "tnt_minecart" int4, | |
| "compass" int4, | |
| "iron_block" int4, | |
| "white_terracotta" int4, | |
| "gold_ingot" int4, | |
| "light_gray_dye" int4, | |
| "birch_stairs" int4, | |
| "fire_charge" int4, | |
| "spruce_fence_gate" int4, | |
| "prismarine" int4, | |
| "leather_leggings" int4, | |
| "bone_meal" int4, | |
| "diamond" int4, | |
| "dark_oak_fence" int4, | |
| "detector_rail" int4, | |
| "ladder" int4, | |
| "redstone_block" int4, | |
| "jungle_fence" int4, | |
| "dark_oak_planks" int4, | |
| "wheat" int4, | |
| "coal_block" int4, | |
| "daylight_detector" int4, | |
| "conduit" int4, | |
| "white_stained_glass" int4, | |
| "glowstone" int4, | |
| "golden_apple" int4, | |
| "iron_leggings" int4, | |
| "white_bed" int4, | |
| "oak_planks" int4, | |
| "dark_oak_boat" int4, | |
| "dark_oak_door" int4, | |
| "hopper" int4, | |
| "iron_boots" int4, | |
| "written_book" int4, | |
| "stone_hoe" int4, | |
| "quartz_stairs" int4, | |
| "item_frame" int4, | |
| "oak_slab" int4, | |
| "map" int4, | |
| "crafting_table" int4, | |
| "spruce_planks" int4, | |
| "rose_red" int4, | |
| "gold_block" int4, | |
| "hopper_minecart" int4, | |
| "birch_planks" int4, | |
| "pumpkin_seeds" int4, | |
| "shield" int4, | |
| "book" int4, | |
| "iron_chestplate" int4, | |
| "paper" int4, | |
| "diamond_pickaxe" int4, | |
| "emerald_block" int4, | |
| "birch_fence" int4, | |
| "light_weighted_pressure_plate" int4, | |
| "light_blue_dye" int4, | |
| "snow_block" int4, | |
| "redstone_torch" int4, | |
| "sponge" int4, | |
| "shears" int4, | |
| "light_gray_stained_glass_pane" int4, | |
| "wooden_sword" int4, | |
| "cookie" int4, | |
| "gray_glazed_terracotta" int4, | |
| "redstone" int4, | |
| "coal" int4, | |
| "light_gray_stained_glass" int4, | |
| "stone_button" int4, | |
| "gray_dye" int4, | |
| "diamond_block" int4, | |
| "glass_pane" int4, | |
| "leather" int4, | |
| "iron_axe" int4, | |
| "iron_hoe" int4, | |
| "slime_ball" int4, | |
| "minecart" int4, | |
| "observer" int4, | |
| "cooked_beef" int4, | |
| "sugar" int4, | |
| "cooked_cod" int4, | |
| "bone_block" int4, | |
| "dark_oak_stairs" int4, | |
| "pink_concrete_powder" int4, | |
| "nether_bricks" int4, | |
| "bucket" int4, | |
| "air" int4, | |
| "oak_boat" int4, | |
| "white_wool" int4, | |
| "gold_nugget" int4, | |
| "pumpkin_pie" int4, | |
| "end_crystal" int4, | |
| "purple_concrete_powder" int4, | |
| "lapis_block" int4, | |
| "trapped_chest" int4, | |
| "firework_rocket" int4, | |
| "diamond_helmet" int4, | |
| "golden_axe" int4, | |
| "golden_pickaxe" int4, | |
| "mossy_cobblestone" int4, | |
| "painting" int4, | |
| "golden_leggings" int4, | |
| "dark_prismarine" int4, | |
| "magenta_wool" int4, | |
| "blue_shulker_box" int4, | |
| "prismarine_brick_stairs" int4, | |
| "terracotta" int4, | |
| "polished_diorite" int4, | |
| "prismarine_slab" int4, | |
| "enchanting_table" int4, | |
| "acacia_stairs" int4, | |
| "magenta_glazed_terracotta" int4, | |
| "cobblestone_slab" int4, | |
| "jungle_stairs" int4, | |
| "bricks" int4, | |
| "golden_boots" int4, | |
| "white_banner" int4, | |
| "prismarine_brick_slab" int4, | |
| "spruce_trapdoor" int4, | |
| "beetroot_soup" int4, | |
| "golden_chestplate" int4, | |
| "mossy_stone_bricks" int4, | |
| "mushroom_stew" int4, | |
| "golden_shovel" int4, | |
| "prismarine_stairs" int4, | |
| "diamond_chestplate" int4, | |
| "dark_prismarine_stairs" int4, | |
| "magenta_shulker_box" int4, | |
| "diamond_leggings" int4, | |
| "magenta_dye" int4, | |
| "flower_pot" int4, | |
| "wooden_shovel" int4, | |
| "cooked_porkchop" int4, | |
| "prismarine_bricks" int4, | |
| "rabbit_stew" int4, | |
| "stone_shovel" int4, | |
| "white_carpet" int4, | |
| "spruce_slab" int4, | |
| "diamond_boots" int4, | |
| "golden_helmet" int4, | |
| "polished_granite" int4, | |
| "wooden_axe" int4, | |
| "oak_stairs" int4, | |
| "golden_hoe" int4, | |
| "brick" int4, | |
| "purple_glazed_terracotta" int4, | |
| "cobblestone_stairs" int4, | |
| "golden_sword" int4, | |
| "wooden_pickaxe" int4, | |
| "baked_potato" int4, | |
| "brewing_stand" int4, | |
| "leather_chestplate" int4, | |
| "stone_sword" int4, | |
| "popped_chorus_fruit" int4, | |
| "jungle_trapdoor" int4, | |
| "blue_ice" int4, | |
| "filled_map" int4, | |
| "diamond_sword" int4, | |
| "bowl" int4, | |
| "stone_axe" int4, | |
| "bread" int4, | |
| "dark_prismarine_slab" int4, | |
| "lapis_lazuli" int4, | |
| "clay" int4, | |
| "carrot_on_a_stick" int4, | |
| "cooked_chicken" int4, | |
| "birch_button" int4, | |
| "birch_pressure_plate" int4, | |
| "nether_brick_slab" int4, | |
| "quartz_slab" int4, | |
| "cooked_mutton" int4, | |
| "acacia_door" int4, | |
| "acacia_fence_gate" int4, | |
| "dirt" int4, | |
| "jungle_fence_gate" int4, | |
| "dark_oak_pressure_plate" int4, | |
| "chiseled_quartz_block" int4, | |
| "gray_stained_glass_pane" int4, | |
| "blue_stained_glass" int4, | |
| "nether_brick_fence" int4, | |
| "red_nether_bricks" int4, | |
| "cactus_green" int4, | |
| "packed_ice" int4, | |
| "yellow_bed" int4, | |
| "quartz" int4, | |
| "yellow_glazed_terracotta" int4, | |
| "cyan_glazed_terracotta" int4, | |
| "red_sandstone_slab" int4, | |
| "black_glazed_terracotta" int4, | |
| "black_stained_glass_pane" int4, | |
| "light_gray_glazed_terracotta" int4, | |
| "nether_brick_stairs" int4, | |
| "blue_carpet" int4, | |
| "magenta_banner" int4, | |
| "red_sandstone" int4, | |
| "spruce_pressure_plate" int4, | |
| "quartz_pillar" int4, | |
| "brown_carpet" int4, | |
| "cyan_terracotta" int4, | |
| "green_glazed_terracotta" int4, | |
| "dark_oak_slab" int4, | |
| "light_blue_stained_glass" int4, | |
| "sandstone_stairs" int4, | |
| "spruce_button" int4, | |
| "dark_oak_trapdoor" int4, | |
| "end_stone_bricks" int4, | |
| "pink_glazed_terracotta" int4, | |
| "cyan_dye" int4, | |
| "black_stained_glass" int4, | |
| "magenta_terracotta" int4, | |
| "white_shulker_box" int4, | |
| "red_banner" int4, | |
| "purpur_slab" int4, | |
| "dark_oak_button" int4, | |
| "purpur_pillar" int4, | |
| "powered_rail" int4, | |
| "mossy_cobblestone_wall" int4, | |
| "charcoal" int4, | |
| "magma_cream" int4, | |
| "cut_sandstone" int4, | |
| "red_glazed_terracotta" int4, | |
| "sandstone_slab" int4, | |
| "chiseled_stone_bricks" int4, | |
| "polished_andesite" int4, | |
| "dried_kelp_block" int4, | |
| "dried_kelp" int4, | |
| "activator_rail" int4, | |
| "turtle_helmet" int4, | |
| "brick_stairs" int4, | |
| "magma_block" int4, | |
| "light_blue_stained_glass_pane" int4, | |
| "jungle_button" int4, | |
| "furnace_minecart" int4, | |
| "dandelion_yellow" int4, | |
| "purpur_stairs" int4, | |
| "light_gray_carpet" int4, | |
| "trident" int4, | |
| "blue_glazed_terracotta" int4, | |
| "nether_wart_block" int4, | |
| "acacia_planks" int4, | |
| "acacia_slab" int4, | |
| "red_bed" int4, | |
| "spruce_wood" int4, | |
| "cracked_stone_bricks" int4, | |
| "brown_bed" int4, | |
| "light_gray_shulker_box" int4, | |
| "light_blue_wool" int4, | |
| "brown_shulker_box" int4, | |
| "chiseled_sandstone" int4, | |
| "cooked_salmon" int4, | |
| "brown_wool" int4, | |
| "light_blue_shulker_box" int4, | |
| "orange_stained_glass" int4, | |
| "yellow_concrete_powder" int4, | |
| "orange_dye" int4, | |
| "orange_bed" int4, | |
| "red_stained_glass_pane" int4, | |
| "jungle_pressure_plate" int4, | |
| "brick_slab" int4, | |
| "pink_carpet" int4, | |
| "brown_stained_glass" int4, | |
| "pink_bed" int4, | |
| "dark_oak_wood" int4, | |
| "red_terracotta" int4, | |
| "pink_shulker_box" int4, | |
| "light_gray_bed" int4, | |
| "experience_bottle" int4, | |
| "pink_dye" int4, | |
| "birch_wood" int4, | |
| "black_bed" int4, | |
| "gray_carpet" int4, | |
| "gray_bed" int4, | |
| "orange_carpet" int4, | |
| "red_carpet" int4, | |
| "light_blue_banner" int4, | |
| "yellow_banner" int4, | |
| "green_banner" int4, | |
| "orange_shulker_box" int4, | |
| "black_concrete_powder" int4, | |
| "red_shulker_box" int4, | |
| "brown_concrete_powder" int4, | |
| "black_shulker_box" int4, | |
| "yellow_shulker_box" int4, | |
| "orange_concrete_powder" int4, | |
| "cyan_banner" int4, | |
| "lime_shulker_box" int4, | |
| "lime_dye" int4, | |
| "black_carpet" int4, | |
| "blue_stained_glass_pane" int4, | |
| "green_bed" int4, | |
| "green_stained_glass" int4, | |
| "blue_bed" int4, | |
| "green_stained_glass_pane" int4, | |
| "orange_wool" int4, | |
| "orange_banner" int4, | |
| "apple" int4, | |
| "light_blue_bed" int4, | |
| "white_glazed_terracotta" int4, | |
| "jungle_slab" int4, | |
| "lime_stained_glass" int4, | |
| "gray_stained_glass" int4, | |
| "yellow_stained_glass" int4, | |
| "yellow_carpet" int4, | |
| "red_sandstone_stairs" int4, | |
| "green_shulker_box" int4, | |
| "chainmail_chestplate" int4, | |
| "jungle_wood" int4, | |
| "pink_banner" int4, | |
| "acacia_wood" int4, | |
| "red_wool" int4, | |
| "blue_concrete_powder" int4, | |
| "player_head" int4, | |
| "tropical_fish_bucket" int4, | |
| "dolphin_spawn_egg" int4, | |
| "yellow_stained_glass_pane" int4, | |
| "pink_stained_glass" int4, | |
| "red_stained_glass" int4, | |
| "purple_shulker_box" int4, | |
| "gray_wool" int4, | |
| "purple_dye" int4, | |
| "magenta_stained_glass" int4, | |
| "blue_terracotta" int4, | |
| "chainmail_helmet" int4, | |
| "name_tag" int4, | |
| "chainmail_leggings" int4, | |
| "light_blue_carpet" int4, | |
| "magenta_stained_glass_pane" int4, | |
| "green_carpet" int4, | |
| "ender_pearl" int4, | |
| "pink_wool" int4, | |
| "firework_star" int4, | |
| "magenta_carpet" int4, | |
| "sunflower" int4, | |
| "green_concrete_powder" int4, | |
| "purple_carpet" int4, | |
| "lime_carpet" int4, | |
| "cyan_carpet" int4, | |
| "blue_banner" int4, | |
| "chiseled_red_sandstone" int4, | |
| "cut_red_sandstone" int4, | |
| "yellow_wool" int4, | |
| "acacia_trapdoor" int4, | |
| "green_wool" int4, | |
| "coarse_dirt" int4, | |
| "purple_stained_glass_pane" int4, | |
| "purple_stained_glass" int4, | |
| "light_gray_banner" int4, | |
| "blue_wool" int4, | |
| "cyan_bed" int4, | |
| "black_wool" int4, | |
| "acacia_button" int4, | |
| "purple_wool" int4, | |
| "chainmail_boots" int4, | |
| "andesite" int4, | |
| "magenta_bed" int4, | |
| "light_gray_wool" int4, | |
| "gray_concrete_powder" int4, | |
| "gray_shulker_box" int4, | |
| "orange_stained_glass_pane" int4, | |
| "pink_stained_glass_pane" int4, | |
| "lime_banner" int4, | |
| "lime_wool" int4, | |
| "purple_banner" int4, | |
| "acacia_pressure_plate" int4, | |
| "black_terracotta" int4, | |
| "cyan_shulker_box" int4, | |
| "green_terracotta" int4, | |
| "purple_terracotta" int4, | |
| "gray_terracotta" int4, | |
| "brown_stained_glass_pane" int4, | |
| "light_gray_terracotta" int4, | |
| "cyan_wool" int4, | |
| "yellow_terracotta" int4, | |
| "brown_terracotta" int4 | |
| ) | |
| ; | |
| -- ---------------------------- | |
| -- Table structure for T_player_stats_custom | |
| -- ---------------------------- | |
| DROP TABLE IF EXISTS "public"."T_player_stats_custom"; | |
| CREATE TABLE "public"."T_player_stats_custom" ( | |
| "id" int8 NOT NULL DEFAULT nextval('"T_player_stats_custom_id_seq"'::regclass), | |
| "uuid" char(32) COLLATE "pg_catalog"."default", | |
| "lastUpdate" int8, | |
| "interact_with_crafting_table" int4, | |
| "deaths" int4, | |
| "jump" int4, | |
| "play_record" int4, | |
| "inspect_dispenser" int4, | |
| "horse_one_cm" int4, | |
| "inspect_dropper" int4, | |
| "inspect_hopper" int4, | |
| "tune_noteblock" int4, | |
| "time_since_rest" int4, | |
| "swim_one_cm" int4, | |
| "open_chest" int4, | |
| "open_shulker_box" int4, | |
| "damage_resisted" int4, | |
| "play_noteblock" int4, | |
| "talked_to_villager" int4, | |
| "interact_with_brewingstand" int4, | |
| "interact_with_beacon" int4, | |
| "boat_one_cm" int4, | |
| "damage_taken" int4, | |
| "aviate_one_cm" int4, | |
| "eat_cake_slice" int4, | |
| "leave_game" int4, | |
| "time_since_death" int4, | |
| "enchant_item" int4, | |
| "interact_with_furnace" int4, | |
| "traded_with_villager" int4, | |
| "sleep_in_bed" int4, | |
| "damage_dealt" int4, | |
| "sneak_time" int4, | |
| "fly_one_cm" int4, | |
| "fish_caught" int4, | |
| "fall_one_cm" int4, | |
| "animals_bred" int4, | |
| "sprint_one_cm" int4, | |
| "drop" int4, | |
| "walk_on_water_one_cm" int4, | |
| "play_one_minute" int4, | |
| "open_enderchest" int4, | |
| "player_kills" int4, | |
| "crouch_one_cm" int4, | |
| "mob_kills" int4, | |
| "climb_one_cm" int4, | |
| "walk_one_cm" int4, | |
| "walk_under_water_one_cm" int4, | |
| "pot_flower" int4, | |
| "damage_absorbed" int4, | |
| "trigger_trapped_chest" int4, | |
| "minecart_one_cm" int4, | |
| "pig_one_cm" int4, | |
| "damage_blocked_by_shield" int4, | |
| "clean_banner" int4, | |
| "fill_cauldron" int4, | |
| "use_cauldron" int4, | |
| "clean_armor" int4, | |
| "damage_dealt_absorbed" int4, | |
| "clean_shulker_box" int4, | |
| "damage_dealt_resisted" int4 | |
| ) | |
| ; | |
| -- ---------------------------- | |
| -- Table structure for T_player_stats_dropped | |
| -- ---------------------------- | |
| DROP TABLE IF EXISTS "public"."T_player_stats_dropped"; | |
| CREATE TABLE "public"."T_player_stats_dropped" ( | |
| "id" int8 NOT NULL DEFAULT nextval('"T_player_stats_dropped_id_seq"'::regclass), | |
| "uuid" char(32) COLLATE "pg_catalog"."default", | |
| "lastUpdate" int8, | |
| "iron_sword" int4, | |
| "porkchop" int4, | |
| "lapis_lazuli" int4, | |
| "chorus_fruit" int4, | |
| "glass_bottle" int4, | |
| "diamond" int4, | |
| "crafting_table" int4, | |
| "cooked_porkchop" int4, | |
| "dark_oak_slab" int4, | |
| "cracked_stone_bricks" int4, | |
| "red_mushroom" int4, | |
| "emerald" int4, | |
| "gold_block" int4, | |
| "birch_fence" int4, | |
| "dark_oak_fence" int4, | |
| "writable_book" int4, | |
| "gold_nugget" int4, | |
| "sand" int4, | |
| "dark_oak_planks" int4, | |
| "fermented_spider_eye" int4, | |
| "fishing_rod" int4, | |
| "white_wool" int4, | |
| "birch_stairs" int4, | |
| "dark_oak_door" int4, | |
| "compass" int4, | |
| "diamond_block" int4, | |
| "lever" int4, | |
| "iron_nugget" int4, | |
| "cooked_chicken" int4, | |
| "wheat" int4, | |
| "obsidian" int4, | |
| "rotten_flesh" int4, | |
| "oak_planks" int4, | |
| "glowstone_dust" int4, | |
| "music_disc_far" int4, | |
| "rabbit_foot" int4, | |
| "red_mushroom_block" int4, | |
| "sea_lantern" int4, | |
| "coal_ore" int4, | |
| "jungle_log" int4, | |
| "music_disc_mall" int4, | |
| "leather_boots" int4, | |
| "leather_leggings" int4, | |
| "glass" int4, | |
| "beef" int4, | |
| "stone_brick_stairs" int4, | |
| "golden_boots" int4, | |
| "orange_shulker_box" int4, | |
| "wheat_seeds" int4, | |
| "clock" int4, | |
| "light_gray_stained_glass_pane" int4, | |
| "book" int4, | |
| "prismarine_crystals" int4, | |
| "golden_apple" int4, | |
| "coal_block" int4, | |
| "sign" int4, | |
| "turtle_egg" int4, | |
| "lava_bucket" int4, | |
| "cobweb" int4, | |
| "diamond_horse_armor" int4, | |
| "ink_sac" int4, | |
| "lapis_ore" int4, | |
| "potion" int4, | |
| "oak_stairs" int4, | |
| "jungle_boat" int4, | |
| "chainmail_leggings" int4, | |
| "trapped_chest" int4, | |
| "lily_pad" int4, | |
| "stone_brick_slab" int4, | |
| "snow_block" int4, | |
| "player_head" int4, | |
| "sticky_piston" int4, | |
| "experience_bottle" int4, | |
| "white_carpet" int4, | |
| "iron_boots" int4, | |
| "name_tag" int4, | |
| "light_gray_concrete" int4, | |
| "white_terracotta" int4, | |
| "white_shulker_box" int4, | |
| "shears" int4, | |
| "diamond_sword" int4, | |
| "spruce_boat" int4, | |
| "spruce_planks" int4, | |
| "diamond_pickaxe" int4, | |
| "redstone_torch" int4, | |
| "stone_pressure_plate" int4, | |
| "stone_bricks" int4, | |
| "sandstone" int4, | |
| "bow" int4, | |
| "magma_block" int4, | |
| "cooked_rabbit" int4, | |
| "terracotta" int4, | |
| "soul_sand" int4, | |
| "oak_log" int4, | |
| "ender_pearl" int4, | |
| "nether_star" int4, | |
| "dark_oak_sapling" int4, | |
| "tube_coral_block" int4, | |
| "leather" int4, | |
| "jungle_planks" int4, | |
| "black_banner" int4, | |
| "birch_slab" int4, | |
| "cod" int4, | |
| "music_disc_13" int4, | |
| "cobblestone_stairs" int4, | |
| "dark_oak_log" int4, | |
| "packed_ice" int4, | |
| "ice" int4, | |
| "snowball" int4, | |
| "black_shulker_box" int4, | |
| "wet_sponge" int4, | |
| "gold_ingot" int4, | |
| "purpur_block" int4, | |
| "beetroot" int4, | |
| "cooked_mutton" int4, | |
| "mycelium" int4, | |
| "leather_chestplate" int4, | |
| "trident" int4, | |
| "dropper" int4, | |
| "beetroot_seeds" int4, | |
| "birch_door" int4, | |
| "iron_ore" int4, | |
| "iron_bars" int4, | |
| "white_concrete_powder" int4, | |
| "splash_potion" int4, | |
| "stone_hoe" int4, | |
| "bread" int4, | |
| "vine" int4, | |
| "golden_helmet" int4, | |
| "activator_rail" int4, | |
| "tropical_fish" int4, | |
| "spruce_stairs" int4, | |
| "acacia_log" int4, | |
| "iron_block" int4, | |
| "milk_bucket" int4, | |
| "repeater" int4, | |
| "melon_slice" int4, | |
| "white_concrete" int4, | |
| "light_gray_shulker_box" int4, | |
| "yellow_shulker_box" int4, | |
| "iron_door" int4, | |
| "light_gray_stained_glass" int4, | |
| "fire_charge" int4, | |
| "music_disc_strad" int4, | |
| "jungle_leaves" int4, | |
| "music_disc_ward" int4, | |
| "music_disc_wait" int4, | |
| "cactus" int4, | |
| "tripwire_hook" int4, | |
| "redstone_block" int4, | |
| "kelp" int4, | |
| "oak_trapdoor" int4, | |
| "birch_pressure_plate" int4, | |
| "comparator" int4, | |
| "shulker_box" int4, | |
| "flint_and_steel" int4, | |
| "oak_button" int4, | |
| "andesite" int4, | |
| "golden_leggings" int4, | |
| "oak_sapling" int4, | |
| "spruce_log" int4, | |
| "magma_cream" int4, | |
| "nautilus_shell" int4, | |
| "clay" int4, | |
| "piston" int4, | |
| "cooked_beef" int4, | |
| "cookie" int4, | |
| "saddle" int4, | |
| "purpur_stairs" int4, | |
| "bubble_coral_fan" int4, | |
| "elytra" int4, | |
| "dragon_breath" int4, | |
| "rail" int4, | |
| "leather_helmet" int4, | |
| "item_frame" int4, | |
| "light_weighted_pressure_plate" int4, | |
| "dirt" int4, | |
| "melon" int4, | |
| "stone_button" int4, | |
| "jack_o_lantern" int4, | |
| "cactus_green" int4, | |
| "wooden_sword" int4, | |
| "bone_block" int4, | |
| "sunflower" int4, | |
| "phantom_membrane" int4, | |
| "sugar" int4, | |
| "iron_pickaxe" int4, | |
| "music_disc_stal" int4, | |
| "dark_oak_boat" int4, | |
| "end_crystal" int4, | |
| "bone" int4, | |
| "oak_door" int4, | |
| "emerald_block" int4, | |
| "sugar_cane" int4, | |
| "music_disc_chirp" int4, | |
| "golden_chestplate" int4, | |
| "detector_rail" int4, | |
| "nether_brick" int4, | |
| "birch_sapling" int4, | |
| "end_stone" int4, | |
| "light_gray_carpet" int4, | |
| "white_bed" int4, | |
| "dark_oak_fence_gate" int4, | |
| "salmon" int4, | |
| "tipped_arrow" int4, | |
| "heavy_weighted_pressure_plate" int4, | |
| "charcoal" int4, | |
| "jungle_stairs" int4, | |
| "hopper" int4, | |
| "ladder" int4, | |
| "spruce_slab" int4, | |
| "end_stone_bricks" int4, | |
| "ghast_tear" int4, | |
| "egg" int4, | |
| "enchanted_book" int4, | |
| "iron_ingot" int4, | |
| "birch_leaves" int4, | |
| "tnt" int4, | |
| "oak_fence" int4, | |
| "purpur_slab" int4, | |
| "feather" int4, | |
| "iron_helmet" int4, | |
| "cobblestone" int4, | |
| "apple" int4, | |
| "granite" int4, | |
| "spruce_door" int4, | |
| "chainmail_helmet" int4, | |
| "coal" int4, | |
| "pufferfish" int4, | |
| "end_rod" int4, | |
| "jungle_slab" int4, | |
| "golden_carrot" int4, | |
| "sponge" int4, | |
| "wooden_hoe" int4, | |
| "rabbit" int4, | |
| "diamond_helmet" int4, | |
| "dead_bush" int4, | |
| "heart_of_the_sea" int4, | |
| "iron_shovel" int4, | |
| "paper" int4, | |
| "string" int4, | |
| "magenta_shulker_box" int4, | |
| "spruce_sapling" int4, | |
| "purpur_pillar" int4, | |
| "furnace" int4, | |
| "redstone_ore" int4, | |
| "stone_sword" int4, | |
| "cobblestone_wall" int4, | |
| "bowl" int4, | |
| "diamond_hoe" int4, | |
| "chicken" int4, | |
| "slime_block" int4, | |
| "stone_slab" int4, | |
| "nether_bricks" int4, | |
| "pumpkin_seeds" int4, | |
| "potato" int4, | |
| "hay_block" int4, | |
| "stone" int4, | |
| "carved_pumpkin" int4, | |
| "spider_eye" int4, | |
| "birch_boat" int4, | |
| "red_sandstone_stairs" int4, | |
| "gold_ore" int4, | |
| "birch_planks" int4, | |
| "brown_mushroom" int4, | |
| "dark_oak_stairs" int4, | |
| "diamond_axe" int4, | |
| "baked_potato" int4, | |
| "lime_shulker_box" int4, | |
| "music_disc_11" int4, | |
| "flint" int4, | |
| "dispenser" int4, | |
| "seagrass" int4, | |
| "cooked_cod" int4, | |
| "white_stained_glass_pane" int4, | |
| "pumpkin_pie" int4, | |
| "brown_mushroom_block" int4, | |
| "armor_stand" int4, | |
| "gravel" int4, | |
| "diamond_shovel" int4, | |
| "prismarine" int4, | |
| "carrot" int4, | |
| "shulker_shell" int4, | |
| "poppy" int4, | |
| "rabbit_hide" int4, | |
| "oak_fence_gate" int4, | |
| "gunpowder" int4, | |
| "birch_trapdoor" int4, | |
| "skeleton_skull" int4, | |
| "glowstone" int4, | |
| "lingering_potion" int4, | |
| "melon_seeds" int4, | |
| "chainmail_boots" int4, | |
| "chest" int4, | |
| "gray_shulker_box" int4, | |
| "arrow" int4, | |
| "powered_rail" int4, | |
| "prismarine_bricks" int4, | |
| "quartz" int4, | |
| "written_book" int4, | |
| "oak_leaves" int4, | |
| "netherrack" int4, | |
| "firework_rocket" int4, | |
| "water_bucket" int4, | |
| "oak_slab" int4, | |
| "chorus_flower" int4, | |
| "mossy_cobblestone" int4, | |
| "minecart" int4, | |
| "bookshelf" int4, | |
| "diamond_leggings" int4, | |
| "poisonous_potato" int4, | |
| "prismarine_shard" int4, | |
| "lead" int4, | |
| "spectral_arrow" int4, | |
| "observer" int4, | |
| "grass_block" int4, | |
| "stick" int4, | |
| "diorite" int4, | |
| "brewing_stand" int4, | |
| "torch" int4, | |
| "iron_leggings" int4, | |
| "iron_axe" int4, | |
| "bucket" int4, | |
| "music_disc_cat" int4, | |
| "lapis_block" int4, | |
| "dandelion" int4, | |
| "redstone" int4, | |
| "ender_chest" int4, | |
| "nether_wart" int4, | |
| "blaze_rod" int4, | |
| "iron_hoe" int4, | |
| "ender_eye" int4, | |
| "acacia_leaves" int4, | |
| "glass_pane" int4, | |
| "filled_map" int4, | |
| "shield" int4, | |
| "diamond_chestplate" int4, | |
| "iron_chestplate" int4, | |
| "mossy_stone_bricks" int4, | |
| "oak_boat" int4, | |
| "golden_sword" int4, | |
| "diamond_boots" int4, | |
| "slime_ball" int4, | |
| "beacon" int4, | |
| "stone_pickaxe" int4, | |
| "music_disc_mellohi" int4, | |
| "nether_quartz_ore" int4, | |
| "white_stained_glass" int4, | |
| "light_blue_shulker_box" int4, | |
| "nether_brick_fence" int4, | |
| "quartz_block" int4, | |
| "cooked_salmon" int4, | |
| "cocoa_beans" int4, | |
| "clay_ball" int4, | |
| "sea_pickle" int4, | |
| "peony" int4, | |
| "pink_shulker_box" int4, | |
| "popped_chorus_fruit" int4, | |
| "blue_shulker_box" int4, | |
| "acacia_boat" int4, | |
| "jungle_fence" int4, | |
| "prismarine_brick_stairs" int4, | |
| "carrot_on_a_stick" int4, | |
| "redstone_lamp" int4, | |
| "mutton" int4, | |
| "tube_coral" int4, | |
| "horn_coral_fan" int4, | |
| "fire_coral_fan" int4, | |
| "polished_granite" int4, | |
| "spruce_fence_gate" int4, | |
| "chiseled_sandstone" int4, | |
| "polished_diorite" int4, | |
| "totem_of_undying" int4, | |
| "brain_coral" int4, | |
| "wooden_pickaxe" int4, | |
| "oak_pressure_plate" int4, | |
| "red_shulker_box" int4, | |
| "horn_coral" int4, | |
| "bone_meal" int4, | |
| "brain_coral_fan" int4, | |
| "blaze_powder" int4, | |
| "dark_prismarine_slab" int4, | |
| "polished_andesite" int4, | |
| "magenta_glazed_terracotta" int4, | |
| "red_sandstone_slab" int4, | |
| "spruce_fence" int4, | |
| "light_blue_dye" int4, | |
| "wooden_shovel" int4, | |
| "blue_orchid" int4, | |
| "tube_coral_fan" int4, | |
| "acacia_door" int4, | |
| "birch_log" int4, | |
| "white_tulip" int4, | |
| "brown_shulker_box" int4, | |
| "enchanting_table" int4, | |
| "bubble_coral" int4, | |
| "anvil" int4, | |
| "light_gray_wool" int4, | |
| "snow" int4, | |
| "dragon_egg" int4, | |
| "cake" int4, | |
| "blue_ice" int4, | |
| "pink_carpet" int4, | |
| "yellow_carpet" int4, | |
| "jungle_door" int4, | |
| "gray_carpet" int4, | |
| "pink_tulip" int4, | |
| "nether_brick_slab" int4, | |
| "light_blue_carpet" int4, | |
| "light_blue_bed" int4, | |
| "stone_axe" int4, | |
| "acacia_fence" int4, | |
| "dead_tube_coral_block" int4, | |
| "stone_shovel" int4, | |
| "quartz_slab" int4, | |
| "nether_brick_stairs" int4, | |
| "black_terracotta" int4, | |
| "chainmail_chestplate" int4, | |
| "dead_horn_coral_block" int4, | |
| "dead_brain_coral_block" int4, | |
| "music_disc_blocks" int4, | |
| "pink_dye" int4, | |
| "painting" int4, | |
| "mushroom_stew" int4, | |
| "wooden_axe" int4, | |
| "daylight_detector" int4, | |
| "red_wool" int4, | |
| "orange_glazed_terracotta" int4, | |
| "birch_fence_gate" int4, | |
| "quartz_stairs" int4, | |
| "sandstone_stairs" int4, | |
| "note_block" int4, | |
| "hopper_minecart" int4, | |
| "golden_horse_armor" int4, | |
| "bricks" int4, | |
| "diamond_ore" int4, | |
| "flower_pot" int4, | |
| "rabbit_stew" int4, | |
| "golden_pickaxe" int4, | |
| "green_shulker_box" int4, | |
| "iron_horse_armor" int4, | |
| "map" int4, | |
| "dark_oak_trapdoor" int4, | |
| "golden_shovel" int4, | |
| "rose_bush" int4, | |
| "cobblestone_slab" int4, | |
| "chest_minecart" int4, | |
| "pink_glazed_terracotta" int4, | |
| "gray_glazed_terracotta" int4, | |
| "grass" int4, | |
| "iron_trapdoor" int4, | |
| "turtle_helmet" int4, | |
| "gray_stained_glass" int4, | |
| "acacia_fence_gate" int4, | |
| "pumpkin" int4, | |
| "spruce_trapdoor" int4, | |
| "red_glazed_terracotta" int4, | |
| "acacia_slab" int4, | |
| "light_blue_stained_glass_pane" int4, | |
| "brick" int4, | |
| "emerald_ore" int4, | |
| "jungle_trapdoor" int4, | |
| "firework_star" int4, | |
| "yellow_glazed_terracotta" int4, | |
| "dried_kelp" int4, | |
| "beetroot_soup" int4, | |
| "chiseled_stone_bricks" int4, | |
| "light_blue_stained_glass" int4, | |
| "red_terracotta" int4, | |
| "orange_terracotta" int4, | |
| "tropical_fish_bucket" int4, | |
| "spruce_button" int4, | |
| "sandstone_slab" int4, | |
| "cut_sandstone" int4, | |
| "dried_kelp_block" int4, | |
| "jungle_fence_gate" int4, | |
| "purple_glazed_terracotta" int4, | |
| "cauldron" int4, | |
| "oxeye_daisy" int4, | |
| "orange_tulip" int4, | |
| "dark_oak_leaves" int4, | |
| "spruce_leaves" int4, | |
| "acacia_stairs" int4, | |
| "spruce_wood" int4, | |
| "light_gray_terracotta" int4, | |
| "stripped_dark_oak_log" int4, | |
| "red_nether_bricks" int4, | |
| "brick_slab" int4, | |
| "dark_oak_wood" int4, | |
| "cyan_shulker_box" int4, | |
| "pufferfish_bucket" int4, | |
| "spruce_pressure_plate" int4, | |
| "fire_coral" int4, | |
| "conduit" int4, | |
| "birch_wood" int4, | |
| "azure_bluet" int4, | |
| "dark_prismarine" int4, | |
| "bubble_coral_block" int4, | |
| "brick_stairs" int4, | |
| "golden_hoe" int4, | |
| "red_tulip" int4, | |
| "golden_axe" int4, | |
| "stripped_oak_log" int4, | |
| "yellow_banner" int4, | |
| "stripped_jungle_log" int4, | |
| "fern" int4, | |
| "stripped_spruce_log" int4, | |
| "light_blue_wool" int4, | |
| "black_stained_glass" int4, | |
| "orange_bed" int4, | |
| "brown_concrete" int4, | |
| "acacia_planks" int4, | |
| "orange_concrete" int4, | |
| "black_concrete" int4, | |
| "lilac" int4, | |
| "dark_prismarine_stairs" int4, | |
| "light_blue_glazed_terracotta" int4, | |
| "glistering_melon_slice" int4, | |
| "rose_red" int4, | |
| "pink_bed" int4, | |
| "acacia_sapling" int4, | |
| "gray_wool" int4, | |
| "red_bed" int4, | |
| "green_stained_glass_pane" int4, | |
| "white_banner" int4, | |
| "blue_stained_glass" int4, | |
| "pink_banner" int4, | |
| "orange_wool" int4, | |
| "black_wool" int4, | |
| "creeper_head" int4, | |
| "tnt_minecart" int4, | |
| "red_sand" int4, | |
| "blue_terracotta" int4, | |
| "orange_stained_glass" int4, | |
| "lime_glazed_terracotta" int4, | |
| "nether_wart_block" int4, | |
| "cow_spawn_egg" int4, | |
| "blue_wool" int4, | |
| "black_glazed_terracotta" int4, | |
| "barrier" int4, | |
| "light_gray_dye" int4, | |
| "white_glazed_terracotta" int4, | |
| "green_banner" int4, | |
| "lime_dye" int4, | |
| "jukebox" int4, | |
| "gray_dye" int4, | |
| "black_concrete_powder" int4, | |
| "bedrock" int4, | |
| "cyan_terracotta" int4, | |
| "dead_fire_coral_block" int4, | |
| "dead_bubble_coral_block" int4, | |
| "brain_coral_block" int4, | |
| "fire_coral_block" int4, | |
| "red_carpet" int4, | |
| "yellow_wool" int4, | |
| "cyan_glazed_terracotta" int4, | |
| "lime_concrete" int4, | |
| "red_sandstone" int4, | |
| "prismarine_slab" int4, | |
| "allium" int4, | |
| "prismarine_brick_slab" int4, | |
| "furnace_minecart" int4, | |
| "chorus_plant" int4, | |
| "command_block" int4, | |
| "cod_bucket" int4, | |
| "dolphin_spawn_egg" int4, | |
| "chiseled_quartz_block" int4, | |
| "red_banner" int4, | |
| "light_gray_concrete_powder" int4, | |
| "tropical_fish_spawn_egg" int4, | |
| "prismarine_stairs" int4, | |
| "light_blue_terracotta" int4, | |
| "brown_wool" int4, | |
| "purple_dye" int4, | |
| "gray_concrete" int4, | |
| "orange_dye" int4, | |
| "pink_terracotta" int4, | |
| "gray_terracotta" int4, | |
| "orange_banner" int4, | |
| "brown_terracotta" int4, | |
| "podzol" int4, | |
| "green_carpet" int4, | |
| "birch_button" int4, | |
| "yellow_terracotta" int4, | |
| "dead_tube_coral_fan" int4, | |
| "stripped_birch_log" int4, | |
| "dandelion_yellow" int4, | |
| "squid_spawn_egg" int4, | |
| "enchanted_golden_apple" int4, | |
| "red_concrete" int4, | |
| "black_stained_glass_pane" int4, | |
| "brown_bed" int4, | |
| "pink_stained_glass" int4, | |
| "pink_wool" int4, | |
| "red_concrete_powder" int4, | |
| "cyan_wool" int4, | |
| "black_bed" int4, | |
| "coarse_dirt" int4, | |
| "scute" int4, | |
| "purple_stained_glass" int4, | |
| "lime_wool" int4, | |
| "purple_terracotta" int4, | |
| "dark_oak_button" int4, | |
| "light_gray_banner" int4, | |
| "yellow_stained_glass" int4, | |
| "green_wool" int4, | |
| "yellow_stained_glass_pane" int4, | |
| "blue_banner" int4, | |
| "magenta_carpet" int4, | |
| "black_carpet" int4, | |
| "magenta_stained_glass" int4, | |
| "jungle_sapling" int4, | |
| "dragon_head" int4, | |
| "brown_carpet" int4, | |
| "lime_banner" int4, | |
| "purple_banner" int4, | |
| "magenta_stained_glass_pane" int4, | |
| "blue_carpet" int4, | |
| "green_concrete" int4, | |
| "quartz_pillar" int4, | |
| "wither_skeleton_skull" int4, | |
| "purple_wool" int4, | |
| "oak_wood" int4, | |
| "dark_oak_pressure_plate" int4, | |
| "green_bed" int4, | |
| "cyan_carpet" int4, | |
| "orange_carpet" int4, | |
| "purple_carpet" int4, | |
| "acacia_trapdoor" int4, | |
| "magenta_dye" int4, | |
| "jungle_wood" int4, | |
| "red_stained_glass" int4, | |
| "stripped_jungle_wood" int4, | |
| "chipped_anvil" int4, | |
| "stripped_acacia_log" int4, | |
| "horn_coral_block" int4, | |
| "stripped_dark_oak_wood" int4, | |
| "cyan_banner" int4, | |
| "dead_brain_coral_fan" int4, | |
| "lime_stained_glass_pane" int4, | |
| "acacia_button" int4, | |
| "gray_stained_glass_pane" int4, | |
| "damaged_anvil" int4 | |
| ) | |
| ; | |
| -- ---------------------------- | |
| -- Table structure for T_player_stats_killed | |
| -- ---------------------------- | |
| DROP TABLE IF EXISTS "public"."T_player_stats_killed"; | |
| CREATE TABLE "public"."T_player_stats_killed" ( | |
| "id" int8 NOT NULL DEFAULT nextval('"T_player_stats_killed_id_seq"'::regclass), | |
| "uuid" char(32) COLLATE "pg_catalog"."default", | |
| "lastUpdate" int8, | |
| "cod" int4, | |
| "guardian" int4, | |
| "skeleton_horse" int4, | |
| "tropical_fish" int4, | |
| "parrot" int4, | |
| "elder_guardian" int4, | |
| "ender_dragon" int4, | |
| "zombie" int4, | |
| "evoker" int4, | |
| "zombie_pigman" int4, | |
| "vindicator" int4, | |
| "endermite" int4, | |
| "husk" int4, | |
| "rabbit" int4, | |
| "polar_bear" int4, | |
| "witch" int4, | |
| "spider" int4, | |
| "silverfish" int4, | |
| "zombie_villager" int4, | |
| "sheep" int4, | |
| "ghast" int4, | |
| "vex" int4, | |
| "slime" int4, | |
| "drowned" int4, | |
| "squid" int4, | |
| "wither_skeleton" int4, | |
| "villager" int4, | |
| "cave_spider" int4, | |
| "dolphin" int4, | |
| "shulker" int4, | |
| "skeleton" int4, | |
| "chicken" int4, | |
| "magma_cube" int4, | |
| "cow" int4, | |
| "ocelot" int4, | |
| "enderman" int4, | |
| "turtle" int4, | |
| "wolf" int4, | |
| "pig" int4, | |
| "creeper" int4, | |
| "stray" int4, | |
| "blaze" int4, | |
| "phantom" int4, | |
| "bat" int4, | |
| "snow_golem" int4, | |
| "mooshroom" int4, | |
| "pufferfish" int4, | |
| "horse" int4, | |
| "llama" int4, | |
| "donkey" int4, | |
| "salmon" int4, | |
| "iron_golem" int4, | |
| "wither" int4, | |
| "mule" int4, | |
| "giant" int4, | |
| "illusioner" int4 | |
| ) | |
| ; | |
| -- ---------------------------- | |
| -- Table structure for T_player_stats_killed_by | |
| -- ---------------------------- | |
| DROP TABLE IF EXISTS "public"."T_player_stats_killed_by"; | |
| CREATE TABLE "public"."T_player_stats_killed_by" ( | |
| "id" int8 NOT NULL DEFAULT nextval('"T_player_stats_killed_by_id_seq"'::regclass), | |
| "uuid" char(32) COLLATE "pg_catalog"."default", | |
| "lastUpdate" int8, | |
| "magma_cube" int4, | |
| "drowned" int4, | |
| "skeleton" int4, | |
| "vex" int4, | |
| "husk" int4, | |
| "zombie_pigman" int4, | |
| "wither_skeleton" int4, | |
| "creeper" int4, | |
| "villager" int4, | |
| "endermite" int4, | |
| "player" int4, | |
| "enderman" int4, | |
| "phantom" int4, | |
| "zombie" int4, | |
| "vindicator" int4, | |
| "slime" int4, | |
| "shulker" int4, | |
| "guardian" int4, | |
| "cave_spider" int4, | |
| "witch" int4, | |
| "spider" int4, | |
| "zombie_villager" int4, | |
| "ghast" int4, | |
| "blaze" int4, | |
| "llama" int4, | |
| "wolf" int4, | |
| "stray" int4, | |
| "elder_guardian" int4, | |
| "pufferfish" int4, | |
| "polar_bear" int4, | |
| "silverfish" int4, | |
| "ender_dragon" int4, | |
| "illusioner" int4 | |
| ) | |
| ; | |
| -- ---------------------------- | |
| -- Table structure for T_player_stats_mined | |
| -- ---------------------------- | |
| DROP TABLE IF EXISTS "public"."T_player_stats_mined"; | |
| CREATE TABLE "public"."T_player_stats_mined" ( | |
| "id" int8 NOT NULL DEFAULT nextval('"T_player_stats_mined_id_seq"'::regclass), | |
| "uuid" char(32) COLLATE "pg_catalog"."default", | |
| "lastUpdate" int8, | |
| "red_nether_bricks" int4, | |
| "granite" int4, | |
| "acacia_log" int4, | |
| "oak_pressure_plate" int4, | |
| "chorus_flower" int4, | |
| "magma_block" int4, | |
| "dark_oak_trapdoor" int4, | |
| "nether_brick_stairs" int4, | |
| "light_gray_concrete" int4, | |
| "tripwire" int4, | |
| "kelp_plant" int4, | |
| "torch" int4, | |
| "note_block" int4, | |
| "melon" int4, | |
| "white_stained_glass_pane" int4, | |
| "dead_bush" int4, | |
| "sugar_cane" int4, | |
| "white_terracotta" int4, | |
| "repeater" int4, | |
| "jukebox" int4, | |
| "grass" int4, | |
| "wall_sign" int4, | |
| "dark_prismarine" int4, | |
| "mossy_cobblestone" int4, | |
| "dark_oak_log" int4, | |
| "sea_lantern" int4, | |
| "end_stone" int4, | |
| "birch_fence_gate" int4, | |
| "dark_oak_fence" int4, | |
| "spruce_fence" int4, | |
| "redstone_wire" int4, | |
| "red_mushroom" int4, | |
| "white_concrete_powder" int4, | |
| "redstone_ore" int4, | |
| "andesite" int4, | |
| "vine" int4, | |
| "rail" int4, | |
| "bone_block" int4, | |
| "ender_chest" int4, | |
| "oak_slab" int4, | |
| "birch_stairs" int4, | |
| "redstone_block" int4, | |
| "glass_pane" int4, | |
| "red_sandstone_slab" int4, | |
| "soul_sand" int4, | |
| "dandelion" int4, | |
| "purpur_pillar" int4, | |
| "diorite" int4, | |
| "trapped_chest" int4, | |
| "cobblestone_wall" int4, | |
| "sunflower" int4, | |
| "gravel" int4, | |
| "cobweb" int4, | |
| "oak_button" int4, | |
| "stone_bricks" int4, | |
| "chipped_anvil" int4, | |
| "gold_ore" int4, | |
| "iron_trapdoor" int4, | |
| "stone_pressure_plate" int4, | |
| "oak_sapling" int4, | |
| "farmland" int4, | |
| "spruce_trapdoor" int4, | |
| "white_concrete" int4, | |
| "bubble_coral_fan" int4, | |
| "turtle_egg" int4, | |
| "iron_bars" int4, | |
| "spruce_slab" int4, | |
| "quartz_block" int4, | |
| "purpur_stairs" int4, | |
| "jungle_stairs" int4, | |
| "beacon" int4, | |
| "nether_quartz_ore" int4, | |
| "oak_planks" int4, | |
| "wall_torch" int4, | |
| "light_weighted_pressure_plate" int4, | |
| "fire_coral_fan" int4, | |
| "powered_rail" int4, | |
| "dark_oak_slab" int4, | |
| "sign" int4, | |
| "blue_ice" int4, | |
| "oak_log" int4, | |
| "dirt" int4, | |
| "dispenser" int4, | |
| "daylight_detector" int4, | |
| "yellow_wall_banner" int4, | |
| "quartz_stairs" int4, | |
| "dark_oak_leaves" int4, | |
| "ladder" int4, | |
| "lever" int4, | |
| "tube_coral_wall_fan" int4, | |
| "stone_button" int4, | |
| "brown_mushroom_block" int4, | |
| "birch_slab" int4, | |
| "spruce_leaves" int4, | |
| "hay_block" int4, | |
| "heavy_weighted_pressure_plate" int4, | |
| "detector_rail" int4, | |
| "gold_block" int4, | |
| "nether_brick_fence" int4, | |
| "bookshelf" int4, | |
| "wet_sponge" int4, | |
| "orange_glazed_terracotta" int4, | |
| "acacia_leaves" int4, | |
| "magenta_stained_glass" int4, | |
| "snow_block" int4, | |
| "oak_fence" int4, | |
| "stone_slab" int4, | |
| "prismarine_bricks" int4, | |
| "birch_planks" int4, | |
| "ice" int4, | |
| "grass_path" int4, | |
| "cracked_stone_bricks" int4, | |
| "mossy_stone_bricks" int4, | |
| "dark_oak_planks" int4, | |
| "jungle_leaves" int4, | |
| "carved_pumpkin" int4, | |
| "obsidian" int4, | |
| "yellow_carpet" int4, | |
| "jungle_log" int4, | |
| "purpur_slab" int4, | |
| "bubble_coral_block" int4, | |
| "tube_coral_block" int4, | |
| "hopper" int4, | |
| "sticky_piston" int4, | |
| "enchanting_table" int4, | |
| "oak_stairs" int4, | |
| "iron_block" int4, | |
| "piston_head" int4, | |
| "conduit" int4, | |
| "brown_mushroom" int4, | |
| "red_bed" int4, | |
| "glass" int4, | |
| "damaged_anvil" int4, | |
| "light_gray_stained_glass" int4, | |
| "wheat" int4, | |
| "stone_brick_stairs" int4, | |
| "oak_fence_gate" int4, | |
| "red_mushroom_block" int4, | |
| "piston" int4, | |
| "light_gray_stained_glass_pane" int4, | |
| "nether_bricks" int4, | |
| "jungle_planks" int4, | |
| "red_sandstone_stairs" int4, | |
| "kelp" int4, | |
| "snow" int4, | |
| "diamond_block" int4, | |
| "white_wool" int4, | |
| "light_gray_carpet" int4, | |
| "comparator" int4, | |
| "stone_brick_slab" int4, | |
| "observer" int4, | |
| "light_gray_concrete_powder" int4, | |
| "emerald_ore" int4, | |
| "sponge" int4, | |
| "dropper" int4, | |
| "white_carpet" int4, | |
| "spruce_log" int4, | |
| "birch_leaves" int4, | |
| "jungle_fence" int4, | |
| "mycelium" int4, | |
| "spruce_fence_gate" int4, | |
| "infested_stone" int4, | |
| "spruce_planks" int4, | |
| "jungle_slab" int4, | |
| "cobblestone_stairs" int4, | |
| "grass_block" int4, | |
| "glowstone" int4, | |
| "iron_ore" int4, | |
| "anvil" int4, | |
| "dark_oak_stairs" int4, | |
| "end_stone_bricks" int4, | |
| "chiseled_quartz_block" int4, | |
| "clay" int4, | |
| "poppy" int4, | |
| "chest" int4, | |
| "cobblestone" int4, | |
| "slime_block" int4, | |
| "prismarine" int4, | |
| "seagrass" int4, | |
| "birch_log" int4, | |
| "lapis_block" int4, | |
| "birch_trapdoor" int4, | |
| "activator_rail" int4, | |
| "stripped_oak_wood" int4, | |
| "purpur_block" int4, | |
| "acacia_fence" int4, | |
| "sand" int4, | |
| "tripwire_hook" int4, | |
| "netherrack" int4, | |
| "oak_leaves" int4, | |
| "emerald_block" int4, | |
| "redstone_lamp" int4, | |
| "diamond_ore" int4, | |
| "light_blue_glazed_terracotta" int4, | |
| "white_stained_glass" int4, | |
| "sandstone" int4, | |
| "oak_trapdoor" int4, | |
| "furnace" int4, | |
| "dark_oak_fence_gate" int4, | |
| "packed_ice" int4, | |
| "chorus_plant" int4, | |
| "stone" int4, | |
| "redstone_wall_torch" int4, | |
| "birch_pressure_plate" int4, | |
| "podzol" int4, | |
| "crafting_table" int4, | |
| "lapis_ore" int4, | |
| "lily_pad" int4, | |
| "spruce_stairs" int4, | |
| "cactus" int4, | |
| "redstone_torch" int4, | |
| "coal_ore" int4, | |
| "end_rod" int4, | |
| "terracotta" int4, | |
| "birch_fence" int4, | |
| "fire_coral_wall_fan" int4, | |
| "jungle_trapdoor" int4, | |
| "cut_sandstone" int4, | |
| "tube_coral_fan" int4, | |
| "bricks" int4, | |
| "jungle_wood" int4, | |
| "magenta_glazed_terracotta" int4, | |
| "purple_glazed_terracotta" int4, | |
| "horn_coral" int4, | |
| "cobblestone_slab" int4, | |
| "brain_coral_wall_fan" int4, | |
| "fire_coral_block" int4, | |
| "fire_coral" int4, | |
| "prismarine_slab" int4, | |
| "brain_coral_fan" int4, | |
| "dark_prismarine_slab" int4, | |
| "polished_diorite" int4, | |
| "tnt" int4, | |
| "prismarine_stairs" int4, | |
| "stripped_oak_log" int4, | |
| "polished_granite" int4, | |
| "bubble_coral" int4, | |
| "sea_pickle" int4, | |
| "white_wall_banner" int4, | |
| "cocoa" int4, | |
| "dark_prismarine_stairs" int4, | |
| "horn_coral_fan" int4, | |
| "coal_block" int4, | |
| "light_blue_stained_glass" int4, | |
| "pumpkin" int4, | |
| "blue_stained_glass" int4, | |
| "pumpkin_stem" int4, | |
| "prismarine_brick_stairs" int4, | |
| "light_blue_stained_glass_pane" int4, | |
| "horn_coral_wall_fan" int4, | |
| "potatoes" int4, | |
| "brain_coral" int4, | |
| "prismarine_brick_slab" int4, | |
| "sandstone_stairs" int4, | |
| "brain_coral_block" int4, | |
| "magenta_wool" int4, | |
| "horn_coral_block" int4, | |
| "tube_coral" int4, | |
| "carrots" int4, | |
| "chiseled_sandstone" int4, | |
| "acacia_stairs" int4, | |
| "white_tulip" int4, | |
| "bubble_coral_wall_fan" int4, | |
| "polished_andesite" int4, | |
| "blue_carpet" int4, | |
| "attached_melon_stem" int4, | |
| "pink_bed" int4, | |
| "potted_cactus" int4, | |
| "light_blue_carpet" int4, | |
| "chiseled_stone_bricks" int4, | |
| "azure_bluet" int4, | |
| "quartz_slab" int4, | |
| "purple_carpet" int4, | |
| "orange_bed" int4, | |
| "magenta_carpet" int4, | |
| "cyan_terracotta" int4, | |
| "melon_stem" int4, | |
| "nether_brick_slab" int4, | |
| "birch_sapling" int4, | |
| "orange_tulip" int4, | |
| "red_carpet" int4, | |
| "pink_carpet" int4, | |
| "jack_o_lantern" int4, | |
| "cake" int4, | |
| "lime_carpet" int4, | |
| "orange_carpet" int4, | |
| "light_blue_bed" int4, | |
| "quartz_pillar" int4, | |
| "yellow_bed" int4, | |
| "cyan_carpet" int4, | |
| "flower_pot" int4, | |
| "gray_carpet" int4, | |
| "black_terracotta" int4, | |
| "frosted_ice" int4, | |
| "light_gray_terracotta" int4, | |
| "purple_terracotta" int4, | |
| "dead_horn_coral_block" int4, | |
| "acacia_fence_gate" int4, | |
| "brown_wool" int4, | |
| "jungle_button" int4, | |
| "yellow_terracotta" int4, | |
| "light_blue_wool" int4, | |
| "black_stained_glass_pane" int4, | |
| "red_sandstone" int4, | |
| "green_wool" int4, | |
| "pink_glazed_terracotta" int4, | |
| "brown_carpet" int4, | |
| "spruce_button" int4, | |
| "black_stained_glass" int4, | |
| "dead_tube_coral_block" int4, | |
| "light_gray_glazed_terracotta" int4, | |
| "blue_terracotta" int4, | |
| "green_glazed_terracotta" int4, | |
| "gray_stained_glass_pane" int4, | |
| "dark_oak_pressure_plate" int4, | |
| "acacia_slab" int4, | |
| "black_glazed_terracotta" int4, | |
| "jungle_fence_gate" int4, | |
| "dead_brain_coral_block" int4, | |
| "white_bed" int4, | |
| "dark_oak_sapling" int4, | |
| "mossy_cobblestone_wall" int4, | |
| "black_banner" int4, | |
| "black_wall_banner" int4, | |
| "red_concrete_powder" int4, | |
| "red_concrete" int4, | |
| "yellow_glazed_terracotta" int4, | |
| "lime_wool" int4, | |
| "mushroom_stem" int4, | |
| "red_stained_glass" int4, | |
| "gray_glazed_terracotta" int4, | |
| "red_glazed_terracotta" int4, | |
| "dried_kelp_block" int4, | |
| "stripped_dark_oak_log" int4, | |
| "green_concrete" int4, | |
| "spawner" int4, | |
| "birch_button" int4, | |
| "fern" int4, | |
| "brewing_stand" int4, | |
| "orange_terracotta" int4, | |
| "blue_glazed_terracotta" int4, | |
| "stripped_birch_log" int4, | |
| "nether_wart_block" int4, | |
| "brick_stairs" int4, | |
| "infested_stone_bricks" int4, | |
| "spruce_wood" int4, | |
| "attached_pumpkin_stem" int4, | |
| "gray_stained_glass" int4, | |
| "acacia_planks" int4, | |
| "red_wool" int4, | |
| "oxeye_daisy" int4, | |
| "potted_dandelion" int4, | |
| "spruce_pressure_plate" int4, | |
| "pink_tulip" int4, | |
| "blue_orchid" int4, | |
| "sandstone_slab" int4, | |
| "allium" int4, | |
| "potted_allium" int4, | |
| "potted_oxeye_daisy" int4, | |
| "potted_blue_orchid" int4, | |
| "potted_red_mushroom" int4, | |
| "brown_bed" int4, | |
| "red_tulip" int4, | |
| "beetroots" int4, | |
| "spruce_sapling" int4, | |
| "potted_azure_bluet" int4, | |
| "yellow_wool" int4, | |
| "orange_wool" int4, | |
| "light_gray_wool" int4, | |
| "yellow_concrete_powder" int4, | |
| "brown_banner" int4, | |
| "gray_bed" int4, | |
| "yellow_concrete" int4, | |
| "dark_oak_wood" int4, | |
| "red_terracotta" int4, | |
| "pink_wall_banner" int4, | |
| "pink_banner" int4, | |
| "pink_terracotta" int4, | |
| "black_concrete_powder" int4, | |
| "white_glazed_terracotta" int4, | |
| "jungle_pressure_plate" int4, | |
| "black_concrete" int4, | |
| "brick_slab" int4, | |
| "nether_wart" int4, | |
| "light_gray_bed" int4, | |
| "black_bed" int4, | |
| "pink_wool" int4, | |
| "birch_wood" int4, | |
| "dead_horn_coral_fan" int4, | |
| "potted_poppy" int4, | |
| "magenta_banner" int4, | |
| "magenta_wall_banner" int4, | |
| "dead_brain_coral_fan" int4, | |
| "dead_bubble_coral_block" int4, | |
| "stripped_dark_oak_wood" int4, | |
| "white_banner" int4, | |
| "stripped_spruce_log" int4, | |
| "stripped_jungle_log" int4, | |
| "yellow_banner" int4, | |
| "brown_wall_banner" int4, | |
| "light_blue_wall_banner" int4, | |
| "cyan_glazed_terracotta" int4, | |
| "green_banner" int4, | |
| "oak_wood" int4, | |
| "brown_concrete" int4, | |
| "orange_concrete" int4, | |
| "lime_concrete" int4, | |
| "black_carpet" int4, | |
| "cauldron" int4, | |
| "gray_concrete" int4, | |
| "stripped_acacia_log" int4, | |
| "red_banner" int4, | |
| "green_carpet" int4, | |
| "green_stained_glass_pane" int4, | |
| "petrified_oak_slab" int4, | |
| "blue_bed" int4, | |
| "cyan_wall_banner" int4, | |
| "blue_wall_banner" int4, | |
| "red_wall_banner" int4, | |
| "orange_wall_banner" int4, | |
| "green_wall_banner" int4, | |
| "gray_wall_banner" int4, | |
| "lime_wall_banner" int4, | |
| "purple_wall_banner" int4, | |
| "light_gray_wall_banner" int4, | |
| "orange_banner" int4, | |
| "red_sand" int4, | |
| "lime_glazed_terracotta" int4, | |
| "purple_stained_glass" int4, | |
| "orange_stained_glass" int4, | |
| "light_blue_terracotta" int4, | |
| "acacia_sapling" int4, | |
| "blue_wool" int4, | |
| "infested_mossy_stone_bricks" int4, | |
| "lime_stained_glass" int4, | |
| "black_wool" int4, | |
| "jungle_sapling" int4, | |
| "dead_fire_coral_block" int4, | |
| "dead_tube_coral_fan" int4, | |
| "lime_stained_glass_pane" int4, | |
| "coarse_dirt" int4, | |
| "potted_red_tulip" int4, | |
| "pink_stained_glass_pane" int4, | |
| "tall_grass" int4, | |
| "structure_void" int4, | |
| "brown_glazed_terracotta" int4, | |
| "cyan_bed" int4, | |
| "light_gray_banner" int4, | |
| "blue_concrete" int4, | |
| "gray_wool" int4, | |
| "yellow_stained_glass_pane" int4, | |
| "pink_stained_glass" int4, | |
| "gray_terracotta" int4, | |
| "lime_bed" int4, | |
| "potted_brown_mushroom" int4, | |
| "green_stained_glass" int4, | |
| "brown_terracotta" int4, | |
| "potted_jungle_sapling" int4, | |
| "magenta_stained_glass_pane" int4, | |
| "red_stained_glass_pane" int4, | |
| "dead_bubble_coral_fan" int4, | |
| "dark_oak_button" int4, | |
| "dead_fire_coral_wall_fan" int4, | |
| "dead_fire_coral_fan" int4, | |
| "acacia_wood" int4, | |
| "potted_oak_sapling" int4, | |
| "potted_spruce_sapling" int4, | |
| "potted_orange_tulip" int4, | |
| "potted_acacia_sapling" int4, | |
| "potted_dark_oak_sapling" int4, | |
| "dead_brain_coral_wall_fan" int4, | |
| "magenta_bed" int4, | |
| "yellow_stained_glass" int4, | |
| "blue_banner" int4, | |
| "chiseled_red_sandstone" int4, | |
| "purple_stained_glass_pane" int4, | |
| "cyan_banner" int4, | |
| "light_blue_banner" int4, | |
| "purple_banner" int4, | |
| "purple_wool" int4, | |
| "cyan_wool" int4, | |
| "lime_banner" int4, | |
| "infested_cracked_stone_bricks" int4, | |
| "acacia_trapdoor" int4, | |
| "large_fern" int4, | |
| "lime_concrete_powder" int4, | |
| "gray_concrete_powder" int4, | |
| "lilac" int4, | |
| "pink_concrete_powder" int4, | |
| "stripped_jungle_wood" int4, | |
| "stripped_spruce_wood" int4, | |
| "green_terracotta" int4, | |
| "green_concrete_powder" int4, | |
| "potted_white_tulip" int4, | |
| "acacia_button" int4, | |
| "brown_stained_glass_pane" int4, | |
| "dead_horn_coral" int4, | |
| "dead_bubble_coral_wall_fan" int4 | |
| ) | |
| ; | |
| -- ---------------------------- | |
| -- Table structure for T_player_stats_picked_up | |
| -- ---------------------------- | |
| DROP TABLE IF EXISTS "public"."T_player_stats_picked_up"; | |
| CREATE TABLE "public"."T_player_stats_picked_up" ( | |
| "id" int8 NOT NULL DEFAULT nextval('"T_player_stats_picked_up_id_seq"'::regclass), | |
| "uuid" char(32) COLLATE "pg_catalog"."default", | |
| "lastUpdate" int8, | |
| "red_sandstone_stairs" int4, | |
| "lead" int4, | |
| "stone_slab" int4, | |
| "enchanted_book" int4, | |
| "music_disc_cat" int4, | |
| "string" int4, | |
| "orange_glazed_terracotta" int4, | |
| "pufferfish" int4, | |
| "diamond_leggings" int4, | |
| "hopper_minecart" int4, | |
| "diamond_ore" int4, | |
| "jukebox" int4, | |
| "acacia_log" int4, | |
| "purpur_pillar" int4, | |
| "end_crystal" int4, | |
| "golden_chestplate" int4, | |
| "gray_shulker_box" int4, | |
| "cauldron" int4, | |
| "stone_sword" int4, | |
| "end_rod" int4, | |
| "carved_pumpkin" int4, | |
| "glowstone" int4, | |
| "bookshelf" int4, | |
| "white_terracotta" int4, | |
| "blaze_rod" int4, | |
| "iron_bars" int4, | |
| "snowball" int4, | |
| "sponge" int4, | |
| "feather" int4, | |
| "cooked_beef" int4, | |
| "water_bucket" int4, | |
| "dark_oak_boat" int4, | |
| "flint" int4, | |
| "diamond_helmet" int4, | |
| "rabbit" int4, | |
| "birch_fence_gate" int4, | |
| "brown_mushroom_block" int4, | |
| "iron_hoe" int4, | |
| "lever" int4, | |
| "granite" int4, | |
| "golden_horse_armor" int4, | |
| "jack_o_lantern" int4, | |
| "light_gray_carpet" int4, | |
| "diamond_pickaxe" int4, | |
| "leather_leggings" int4, | |
| "redstone_lamp" int4, | |
| "dragon_head" int4, | |
| "purpur_block" int4, | |
| "heavy_weighted_pressure_plate" int4, | |
| "elytra" int4, | |
| "flint_and_steel" int4, | |
| "white_carpet" int4, | |
| "white_stained_glass" int4, | |
| "iron_shovel" int4, | |
| "glass_pane" int4, | |
| "poppy" int4, | |
| "spruce_slab" int4, | |
| "minecart" int4, | |
| "birch_sapling" int4, | |
| "piston" int4, | |
| "diamond_hoe" int4, | |
| "lime_shulker_box" int4, | |
| "stone" int4, | |
| "music_disc_mellohi" int4, | |
| "fire_charge" int4, | |
| "cyan_shulker_box" int4, | |
| "diamond_chestplate" int4, | |
| "purpur_slab" int4, | |
| "hay_block" int4, | |
| "totem_of_undying" int4, | |
| "mutton" int4, | |
| "rail" int4, | |
| "bone_block" int4, | |
| "emerald_ore" int4, | |
| "yellow_shulker_box" int4, | |
| "birch_leaves" int4, | |
| "clock" int4, | |
| "tripwire_hook" int4, | |
| "jungle_fence" int4, | |
| "purpur_stairs" int4, | |
| "lily_pad" int4, | |
| "paper" int4, | |
| "apple" int4, | |
| "oak_fence_gate" int4, | |
| "iron_ore" int4, | |
| "dark_oak_stairs" int4, | |
| "milk_bucket" int4, | |
| "light_gray_stained_glass" int4, | |
| "dragon_egg" int4, | |
| "leather_helmet" int4, | |
| "diamond_shovel" int4, | |
| "coal_ore" int4, | |
| "slime_ball" int4, | |
| "baked_potato" int4, | |
| "hopper" int4, | |
| "ender_chest" int4, | |
| "stone_brick_stairs" int4, | |
| "lapis_block" int4, | |
| "experience_bottle" int4, | |
| "comparator" int4, | |
| "bucket" int4, | |
| "light_weighted_pressure_plate" int4, | |
| "ender_eye" int4, | |
| "iron_pickaxe" int4, | |
| "tipped_arrow" int4, | |
| "acacia_fence" int4, | |
| "birch_trapdoor" int4, | |
| "spruce_stairs" int4, | |
| "diorite" int4, | |
| "vine" int4, | |
| "rotten_flesh" int4, | |
| "red_sandstone_slab" int4, | |
| "music_disc_ward" int4, | |
| "chorus_flower" int4, | |
| "music_disc_wait" int4, | |
| "obsidian" int4, | |
| "blaze_powder" int4, | |
| "cobblestone" int4, | |
| "enchanting_table" int4, | |
| "leather_chestplate" int4, | |
| "repeater" int4, | |
| "andesite" int4, | |
| "golden_leggings" int4, | |
| "beacon" int4, | |
| "potato" int4, | |
| "prismarine_bricks" int4, | |
| "dirt" int4, | |
| "name_tag" int4, | |
| "sign" int4, | |
| "glass" int4, | |
| "bone" int4, | |
| "bow" int4, | |
| "wheat_seeds" int4, | |
| "mossy_stone_bricks" int4, | |
| "prismarine" int4, | |
| "light_blue_shulker_box" int4, | |
| "melon" int4, | |
| "nether_brick_stairs" int4, | |
| "grass_block" int4, | |
| "diamond_block" int4, | |
| "jungle_slab" int4, | |
| "spectral_arrow" int4, | |
| "mossy_cobblestone" int4, | |
| "jungle_leaves" int4, | |
| "sugar" int4, | |
| "yellow_carpet" int4, | |
| "slime_block" int4, | |
| "bone_meal" int4, | |
| "golden_apple" int4, | |
| "emerald" int4, | |
| "netherrack" int4, | |
| "chorus_fruit" int4, | |
| "oak_leaves" int4, | |
| "splash_potion" int4, | |
| "ladder" int4, | |
| "brown_mushroom" int4, | |
| "packed_ice" int4, | |
| "shield" int4, | |
| "oak_trapdoor" int4, | |
| "mycelium" int4, | |
| "birch_fence" int4, | |
| "end_stone" int4, | |
| "note_block" int4, | |
| "cookie" int4, | |
| "music_disc_11" int4, | |
| "trident" int4, | |
| "light_gray_stained_glass_pane" int4, | |
| "stone_pressure_plate" int4, | |
| "red_shulker_box" int4, | |
| "pumpkin_pie" int4, | |
| "nether_bricks" int4, | |
| "black_banner" int4, | |
| "skeleton_skull" int4, | |
| "jungle_boat" int4, | |
| "golden_carrot" int4, | |
| "leather" int4, | |
| "music_disc_stal" int4, | |
| "ice" int4, | |
| "chainmail_chestplate" int4, | |
| "cobblestone_wall" int4, | |
| "gunpowder" int4, | |
| "cooked_mutton" int4, | |
| "rabbit_hide" int4, | |
| "iron_ingot" int4, | |
| "cooked_chicken" int4, | |
| "emerald_block" int4, | |
| "nether_quartz_ore" int4, | |
| "stone_brick_slab" int4, | |
| "quartz" int4, | |
| "dandelion" int4, | |
| "lava_bucket" int4, | |
| "spruce_door" int4, | |
| "pumpkin_seeds" int4, | |
| "white_concrete_powder" int4, | |
| "cactus_green" int4, | |
| "chainmail_leggings" int4, | |
| "terracotta" int4, | |
| "damaged_anvil" int4, | |
| "sunflower" int4, | |
| "seagrass" int4, | |
| "iron_chestplate" int4, | |
| "chainmail_boots" int4, | |
| "flower_pot" int4, | |
| "anvil" int4, | |
| "prismarine_shard" int4, | |
| "diamond_sword" int4, | |
| "oak_stairs" int4, | |
| "brewing_stand" int4, | |
| "golden_sword" int4, | |
| "red_nether_bricks" int4, | |
| "beetroot" int4, | |
| "gold_nugget" int4, | |
| "spruce_planks" int4, | |
| "written_book" int4, | |
| "melon_slice" int4, | |
| "coal_block" int4, | |
| "dark_oak_door" int4, | |
| "golden_helmet" int4, | |
| "music_disc_blocks" int4, | |
| "rabbit_foot" int4, | |
| "tropical_fish" int4, | |
| "iron_block" int4, | |
| "birch_log" int4, | |
| "magma_block" int4, | |
| "jungle_log" int4, | |
| "iron_door" int4, | |
| "birch_slab" int4, | |
| "acacia_leaves" int4, | |
| "light_gray_concrete_powder" int4, | |
| "chipped_anvil" int4, | |
| "glowstone_dust" int4, | |
| "dropper" int4, | |
| "ink_sac" int4, | |
| "fermented_spider_eye" int4, | |
| "trapped_chest" int4, | |
| "dark_oak_log" int4, | |
| "dispenser" int4, | |
| "writable_book" int4, | |
| "blue_ice" int4, | |
| "chainmail_helmet" int4, | |
| "bread" int4, | |
| "dark_oak_fence" int4, | |
| "spruce_leaves" int4, | |
| "crafting_table" int4, | |
| "bubble_coral_fan" int4, | |
| "nether_wart" int4, | |
| "conduit" int4, | |
| "red_bed" int4, | |
| "cracked_stone_bricks" int4, | |
| "beef" int4, | |
| "iron_nugget" int4, | |
| "quartz_stairs" int4, | |
| "chest" int4, | |
| "egg" int4, | |
| "sandstone" int4, | |
| "oak_door" int4, | |
| "spruce_fence" int4, | |
| "carrot" int4, | |
| "redstone" int4, | |
| "prismarine_crystals" int4, | |
| "tnt" int4, | |
| "cooked_cod" int4, | |
| "beetroot_seeds" int4, | |
| "shears" int4, | |
| "diamond_boots" int4, | |
| "sandstone_stairs" int4, | |
| "tube_coral_block" int4, | |
| "gold_ingot" int4, | |
| "white_shulker_box" int4, | |
| "white_wool" int4, | |
| "lapis_ore" int4, | |
| "red_mushroom_block" int4, | |
| "red_mushroom" int4, | |
| "filled_map" int4, | |
| "oak_log" int4, | |
| "golden_boots" int4, | |
| "birch_pressure_plate" int4, | |
| "stone_bricks" int4, | |
| "kelp" int4, | |
| "music_disc_far" int4, | |
| "cobweb" int4, | |
| "glass_bottle" int4, | |
| "iron_sword" int4, | |
| "white_stained_glass_pane" int4, | |
| "dark_oak_slab" int4, | |
| "daylight_detector" int4, | |
| "light_blue_glazed_terracotta" int4, | |
| "gravel" int4, | |
| "birch_stairs" int4, | |
| "spruce_sapling" int4, | |
| "spruce_log" int4, | |
| "sea_lantern" int4, | |
| "firework_rocket" int4, | |
| "stone_axe" int4, | |
| "redstone_ore" int4, | |
| "diamond_axe" int4, | |
| "oak_button" int4, | |
| "melon_seeds" int4, | |
| "pink_dye" int4, | |
| "ender_pearl" int4, | |
| "shulker_shell" int4, | |
| "music_disc_strad" int4, | |
| "wheat" int4, | |
| "redstone_block" int4, | |
| "iron_trapdoor" int4, | |
| "light_gray_shulker_box" int4, | |
| "turtle_egg" int4, | |
| "potion" int4, | |
| "nether_brick" int4, | |
| "iron_leggings" int4, | |
| "armor_stand" int4, | |
| "sticky_piston" int4, | |
| "pink_shulker_box" int4, | |
| "activator_rail" int4, | |
| "black_shulker_box" int4, | |
| "dark_oak_leaves" int4, | |
| "redstone_torch" int4, | |
| "furnace" int4, | |
| "iron_boots" int4, | |
| "stick" int4, | |
| "orange_shulker_box" int4, | |
| "oak_fence" int4, | |
| "torch" int4, | |
| "porkchop" int4, | |
| "snow_block" int4, | |
| "quartz_block" int4, | |
| "cactus" int4, | |
| "cod" int4, | |
| "nautilus_shell" int4, | |
| "magma_cream" int4, | |
| "chiseled_quartz_block" int4, | |
| "light_gray_dye" int4, | |
| "acacia_boat" int4, | |
| "green_shulker_box" int4, | |
| "lapis_lazuli" int4, | |
| "leather_boots" int4, | |
| "powered_rail" int4, | |
| "oak_planks" int4, | |
| "stone_hoe" int4, | |
| "ghast_tear" int4, | |
| "cooked_porkchop" int4, | |
| "music_disc_13" int4, | |
| "jungle_planks" int4, | |
| "oak_pressure_plate" int4, | |
| "poisonous_potato" int4, | |
| "sand" int4, | |
| "dead_bush" int4, | |
| "shulker_box" int4, | |
| "dark_prismarine" int4, | |
| "light_gray_concrete" int4, | |
| "spruce_fence_gate" int4, | |
| "spruce_boat" int4, | |
| "clay" int4, | |
| "diamond" int4, | |
| "white_concrete" int4, | |
| "oak_sapling" int4, | |
| "nether_star" int4, | |
| "end_stone_bricks" int4, | |
| "lingering_potion" int4, | |
| "fishing_rod" int4, | |
| "charcoal" int4, | |
| "chicken" int4, | |
| "cooked_rabbit" int4, | |
| "gold_block" int4, | |
| "diamond_horse_armor" int4, | |
| "dragon_breath" int4, | |
| "iron_axe" int4, | |
| "wooden_sword" int4, | |
| "item_frame" int4, | |
| "detector_rail" int4, | |
| "oak_boat" int4, | |
| "player_head" int4, | |
| "observer" int4, | |
| "blue_shulker_box" int4, | |
| "sugar_cane" int4, | |
| "phantom_membrane" int4, | |
| "dark_oak_sapling" int4, | |
| "stone_button" int4, | |
| "magenta_shulker_box" int4, | |
| "iron_horse_armor" int4, | |
| "dark_oak_planks" int4, | |
| "arrow" int4, | |
| "jungle_stairs" int4, | |
| "saddle" int4, | |
| "wet_sponge" int4, | |
| "salmon" int4, | |
| "birch_planks" int4, | |
| "mushroom_stew" int4, | |
| "cobblestone_stairs" int4, | |
| "wooden_hoe" int4, | |
| "heart_of_the_sea" int4, | |
| "stripped_oak_wood" int4, | |
| "acacia_sapling" int4, | |
| "soul_sand" int4, | |
| "music_disc_chirp" int4, | |
| "book" int4, | |
| "oak_slab" int4, | |
| "birch_boat" int4, | |
| "white_bed" int4, | |
| "gold_ore" int4, | |
| "dark_oak_fence_gate" int4, | |
| "spider_eye" int4, | |
| "music_disc_mall" int4, | |
| "iron_helmet" int4, | |
| "coal" int4, | |
| "purple_shulker_box" int4, | |
| "horn_coral_block" int4, | |
| "bubble_coral" int4, | |
| "horn_coral_fan" int4, | |
| "acacia_stairs" int4, | |
| "polished_andesite" int4, | |
| "magenta_glazed_terracotta" int4, | |
| "clay_ball" int4, | |
| "fire_coral" int4, | |
| "acacia_door" int4, | |
| "stone_shovel" int4, | |
| "light_blue_stained_glass" int4, | |
| "painting" int4, | |
| "prismarine_stairs" int4, | |
| "nether_brick_fence" int4, | |
| "white_tulip" int4, | |
| "cobblestone_slab" int4, | |
| "brown_shulker_box" int4, | |
| "lilac" int4, | |
| "popped_chorus_fruit" int4, | |
| "rabbit_stew" int4, | |
| "brick" int4, | |
| "magenta_wool" int4, | |
| "tube_coral" int4, | |
| "pink_tulip" int4, | |
| "glistering_melon_slice" int4, | |
| "prismarine_slab" int4, | |
| "prismarine_brick_slab" int4, | |
| "wooden_axe" int4, | |
| "birch_door" int4, | |
| "cooked_salmon" int4, | |
| "black_glazed_terracotta" int4, | |
| "jungle_wood" int4, | |
| "black_concrete_powder" int4, | |
| "bricks" int4, | |
| "jungle_trapdoor" int4, | |
| "snow" int4, | |
| "compass" int4, | |
| "cake" int4, | |
| "tube_coral_fan" int4, | |
| "stripped_oak_log" int4, | |
| "white_banner" int4, | |
| "prismarine_brick_stairs" int4, | |
| "purple_glazed_terracotta" int4, | |
| "polished_diorite" int4, | |
| "brain_coral_block" int4, | |
| "zombie_head" int4, | |
| "sea_pickle" int4, | |
| "blue_stained_glass" int4, | |
| "fire_coral_fan" int4, | |
| "horn_coral" int4, | |
| "polished_granite" int4, | |
| "light_blue_dye" int4, | |
| "brain_coral" int4, | |
| "chiseled_sandstone" int4, | |
| "dark_prismarine_slab" int4, | |
| "bubble_coral_block" int4, | |
| "firework_star" int4, | |
| "cocoa_beans" int4, | |
| "wooden_pickaxe" int4, | |
| "dark_prismarine_stairs" int4, | |
| "light_gray_wool" int4, | |
| "bowl" int4, | |
| "light_blue_stained_glass_pane" int4, | |
| "fire_coral_block" int4, | |
| "pumpkin" int4, | |
| "brain_coral_fan" int4, | |
| "jungle_door" int4, | |
| "pink_carpet" int4, | |
| "orange_bed" int4, | |
| "lime_carpet" int4, | |
| "cyan_terracotta" int4, | |
| "orange_carpet" int4, | |
| "purple_carpet" int4, | |
| "orange_tulip" int4, | |
| "azure_bluet" int4, | |
| "quartz_slab" int4, | |
| "cyan_carpet" int4, | |
| "quartz_pillar" int4, | |
| "light_blue_bed" int4, | |
| "blue_carpet" int4, | |
| "oxeye_daisy" int4, | |
| "yellow_bed" int4, | |
| "red_carpet" int4, | |
| "gray_carpet" int4, | |
| "pink_bed" int4, | |
| "chiseled_stone_bricks" int4, | |
| "nether_brick_slab" int4, | |
| "light_blue_carpet" int4, | |
| "acacia_fence_gate" int4, | |
| "dead_horn_coral_block" int4, | |
| "stone_pickaxe" int4, | |
| "black_terracotta" int4, | |
| "light_gray_terracotta" int4, | |
| "purple_terracotta" int4, | |
| "dark_oak_pressure_plate" int4, | |
| "dark_oak_trapdoor" int4, | |
| "beetroot_soup" int4, | |
| "brown_carpet" int4, | |
| "gray_stained_glass_pane" int4, | |
| "light_blue_wool" int4, | |
| "brown_wool" int4, | |
| "blue_terracotta" int4, | |
| "dead_brain_coral_block" int4, | |
| "spruce_button" int4, | |
| "black_stained_glass" int4, | |
| "jungle_fence_gate" int4, | |
| "yellow_terracotta" int4, | |
| "jungle_button" int4, | |
| "light_gray_glazed_terracotta" int4, | |
| "green_glazed_terracotta" int4, | |
| "dead_tube_coral_block" int4, | |
| "rose_bush" int4, | |
| "green_wool" int4, | |
| "black_stained_glass_pane" int4, | |
| "grass" int4, | |
| "pink_glazed_terracotta" int4, | |
| "cut_sandstone" int4, | |
| "red_sandstone" int4, | |
| "acacia_slab" int4, | |
| "red_wool" int4, | |
| "mossy_cobblestone_wall" int4, | |
| "spruce_trapdoor" int4, | |
| "black_wool" int4, | |
| "red_tulip" int4, | |
| "chest_minecart" int4, | |
| "red_concrete_powder" int4, | |
| "red_concrete" int4, | |
| "blue_glazed_terracotta" int4, | |
| "map" int4, | |
| "gray_glazed_terracotta" int4, | |
| "golden_pickaxe" int4, | |
| "mushroom_stem" int4, | |
| "red_glazed_terracotta" int4, | |
| "red_stained_glass" int4, | |
| "tnt_minecart" int4, | |
| "lime_wool" int4, | |
| "yellow_glazed_terracotta" int4, | |
| "dried_kelp_block" int4, | |
| "stripped_dark_oak_log" int4, | |
| "wooden_shovel" int4, | |
| "stripped_birch_log" int4, | |
| "gray_stained_glass" int4, | |
| "brick_stairs" int4, | |
| "orange_terracotta" int4, | |
| "tropical_fish_bucket" int4, | |
| "creeper_head" int4, | |
| "birch_button" int4, | |
| "green_concrete" int4, | |
| "scute" int4, | |
| "green_stained_glass_pane" int4, | |
| "pink_stained_glass" int4, | |
| "turtle_helmet" int4, | |
| "red_stained_glass_pane" int4, | |
| "nether_wart_block" int4, | |
| "pufferfish_bucket" int4, | |
| "acacia_planks" int4, | |
| "spruce_wood" int4, | |
| "red_terracotta" int4, | |
| "dried_kelp" int4, | |
| "brown_bed" int4, | |
| "spruce_pressure_plate" int4, | |
| "sandstone_slab" int4, | |
| "jungle_sapling" int4, | |
| "oak_wood" int4, | |
| "allium" int4, | |
| "blue_orchid" int4, | |
| "podzol" int4, | |
| "peony" int4, | |
| "gray_wool" int4, | |
| "yellow_wool" int4, | |
| "orange_wool" int4, | |
| "yellow_concrete_powder" int4, | |
| "orange_stained_glass" int4, | |
| "gray_bed" int4, | |
| "yellow_concrete" int4, | |
| "brown_banner" int4, | |
| "dark_oak_wood" int4, | |
| "pink_terracotta" int4, | |
| "brown_stained_glass" int4, | |
| "brick_slab" int4, | |
| "white_glazed_terracotta" int4, | |
| "jungle_pressure_plate" int4, | |
| "pink_banner" int4, | |
| "black_concrete" int4, | |
| "light_gray_bed" int4, | |
| "blue_wool" int4, | |
| "black_bed" int4, | |
| "birch_wood" int4, | |
| "pink_wool" int4, | |
| "dead_horn_coral_fan" int4, | |
| "golden_axe" int4, | |
| "magenta_banner" int4, | |
| "dead_brain_coral_fan" int4, | |
| "carrot_on_a_stick" int4, | |
| "dead_bubble_coral_block" int4, | |
| "golden_shovel" int4, | |
| "yellow_banner" int4, | |
| "stripped_spruce_log" int4, | |
| "fern" int4, | |
| "stripped_jungle_log" int4, | |
| "light_blue_banner" int4, | |
| "cyan_glazed_terracotta" int4, | |
| "green_banner" int4, | |
| "lime_concrete" int4, | |
| "brown_concrete" int4, | |
| "orange_concrete" int4, | |
| "green_carpet" int4, | |
| "cyan_wool" int4, | |
| "black_carpet" int4, | |
| "golden_hoe" int4, | |
| "magenta_carpet" int4, | |
| "gray_concrete" int4, | |
| "stripped_acacia_log" int4, | |
| "red_banner" int4, | |
| "rose_red" int4, | |
| "blue_bed" int4, | |
| "petrified_oak_slab" int4, | |
| "blue_banner" int4, | |
| "orange_banner" int4, | |
| "purple_banner" int4, | |
| "light_gray_banner" int4, | |
| "cyan_banner" int4, | |
| "lime_banner" int4, | |
| "gray_banner" int4, | |
| "dandelion_yellow" int4, | |
| "wither_skeleton_skull" int4, | |
| "purple_stained_glass" int4, | |
| "red_sand" int4, | |
| "lime_glazed_terracotta" int4, | |
| "light_blue_terracotta" int4, | |
| "barrier" int4, | |
| "cow_spawn_egg" int4, | |
| "lime_stained_glass" int4, | |
| "chorus_plant" int4, | |
| "dead_fire_coral_block" int4, | |
| "gray_dye" int4, | |
| "furnace_minecart" int4, | |
| "gray_terracotta" int4, | |
| "bedrock" int4, | |
| "dead_tube_coral_fan" int4, | |
| "pink_stained_glass_pane" int4, | |
| "magenta_stained_glass" int4, | |
| "cod_bucket" int4, | |
| "command_block" int4, | |
| "brown_glazed_terracotta" int4, | |
| "cyan_bed" int4, | |
| "spawner" int4, | |
| "grass_path" int4, | |
| "blue_concrete" int4, | |
| "dolphin_spawn_egg" int4, | |
| "green_terracotta" int4, | |
| "pink_concrete" int4, | |
| "orange_stained_glass_pane" int4, | |
| "green_stained_glass" int4, | |
| "tropical_fish_spawn_egg" int4, | |
| "yellow_stained_glass_pane" int4, | |
| "light_blue_concrete" int4, | |
| "lime_bed" int4, | |
| "purple_wool" int4, | |
| "orange_dye" int4, | |
| "magenta_dye" int4, | |
| "brown_terracotta" int4, | |
| "lime_stained_glass_pane" int4, | |
| "dead_bubble_coral_fan" int4, | |
| "dark_oak_button" int4, | |
| "dead_fire_coral_fan" int4, | |
| "yellow_stained_glass" int4, | |
| "acacia_wood" int4, | |
| "enchanted_golden_apple" int4, | |
| "squid_spawn_egg" int4, | |
| "lime_dye" int4, | |
| "magenta_bed" int4, | |
| "chiseled_red_sandstone" int4, | |
| "coarse_dirt" int4, | |
| "purple_stained_glass_pane" int4, | |
| "purple_dye" int4, | |
| "acacia_trapdoor" int4, | |
| "magenta_stained_glass_pane" int4, | |
| "lime_concrete_powder" int4, | |
| "gray_concrete_powder" int4, | |
| "green_bed" int4, | |
| "pink_concrete_powder" int4, | |
| "stripped_jungle_wood" int4, | |
| "acacia_button" int4, | |
| "stripped_spruce_wood" int4, | |
| "green_concrete_powder" int4, | |
| "salmon_bucket" int4, | |
| "stripped_dark_oak_wood" int4, | |
| "brown_stained_glass_pane" int4, | |
| "dead_horn_coral" int4 | |
| ) | |
| ; | |
| -- ---------------------------- | |
| -- Table structure for T_player_stats_used | |
| -- ---------------------------- | |
| DROP TABLE IF EXISTS "public"."T_player_stats_used"; | |
| CREATE TABLE "public"."T_player_stats_used" ( | |
| "id" int8 NOT NULL DEFAULT nextval('"T_player_stats_used_id_seq"'::regclass), | |
| "uuid" char(32) COLLATE "pg_catalog"."default", | |
| "lastUpdate" int8, | |
| "writable_book" int4, | |
| "dispenser" int4, | |
| "poppy" int4, | |
| "stone" int4, | |
| "quartz_stairs" int4, | |
| "rotten_flesh" int4, | |
| "soul_sand" int4, | |
| "snowball" int4, | |
| "spruce_boat" int4, | |
| "packed_ice" int4, | |
| "lava_bucket" int4, | |
| "quartz_block" int4, | |
| "dark_oak_leaves" int4, | |
| "bow" int4, | |
| "oak_sapling" int4, | |
| "cooked_cod" int4, | |
| "acacia_fence" int4, | |
| "damaged_anvil" int4, | |
| "chorus_fruit" int4, | |
| "prismarine" int4, | |
| "lily_pad" int4, | |
| "cactus" int4, | |
| "jungle_boat" int4, | |
| "golden_apple" int4, | |
| "acacia_leaves" int4, | |
| "birch_fence" int4, | |
| "birch_slab" int4, | |
| "oak_pressure_plate" int4, | |
| "diamond_sword" int4, | |
| "coal_block" int4, | |
| "poisonous_potato" int4, | |
| "oak_boat" int4, | |
| "oak_trapdoor" int4, | |
| "enchanting_table" int4, | |
| "carved_pumpkin" int4, | |
| "armor_stand" int4, | |
| "light_gray_carpet" int4, | |
| "torch" int4, | |
| "brewing_stand" int4, | |
| "nether_quartz_ore" int4, | |
| "cod_bucket" int4, | |
| "yellow_carpet" int4, | |
| "oak_fence_gate" int4, | |
| "music_disc_mellohi" int4, | |
| "sea_lantern" int4, | |
| "chipped_anvil" int4, | |
| "iron_block" int4, | |
| "trapped_chest" int4, | |
| "wheat_seeds" int4, | |
| "light_blue_shulker_box" int4, | |
| "birch_planks" int4, | |
| "cauldron" int4, | |
| "spruce_fence_gate" int4, | |
| "gold_ore" int4, | |
| "conduit" int4, | |
| "diamond_block" int4, | |
| "rail" int4, | |
| "white_bed" int4, | |
| "spruce_log" int4, | |
| "music_disc_strad" int4, | |
| "diamond_pickaxe" int4, | |
| "diamond_shovel" int4, | |
| "oak_button" int4, | |
| "tnt_minecart" int4, | |
| "spruce_sapling" int4, | |
| "potion" int4, | |
| "porkchop" int4, | |
| "cooked_porkchop" int4, | |
| "dandelion" int4, | |
| "light_gray_stained_glass_pane" int4, | |
| "melon" int4, | |
| "bone_block" int4, | |
| "nether_wart" int4, | |
| "mutton" int4, | |
| "orange_glazed_terracotta" int4, | |
| "music_disc_13" int4, | |
| "obsidian" int4, | |
| "item_frame" int4, | |
| "golden_sword" int4, | |
| "birch_trapdoor" int4, | |
| "written_book" int4, | |
| "blue_shulker_box" int4, | |
| "gold_block" int4, | |
| "skeleton_skull" int4, | |
| "ink_sac" int4, | |
| "end_rod" int4, | |
| "dropper" int4, | |
| "jungle_fence" int4, | |
| "oak_planks" int4, | |
| "sandstone" int4, | |
| "sugar_cane" int4, | |
| "diamond_axe" int4, | |
| "white_wool" int4, | |
| "mushroom_stew" int4, | |
| "lingering_potion" int4, | |
| "end_stone" int4, | |
| "sticky_piston" int4, | |
| "lever" int4, | |
| "daylight_detector" int4, | |
| "bread" int4, | |
| "sign" int4, | |
| "iron_door" int4, | |
| "cooked_rabbit" int4, | |
| "flint_and_steel" int4, | |
| "redstone" int4, | |
| "ender_chest" int4, | |
| "stone_hoe" int4, | |
| "cooked_chicken" int4, | |
| "dirt" int4, | |
| "prismarine_bricks" int4, | |
| "spruce_fence" int4, | |
| "iron_hoe" int4, | |
| "light_gray_stained_glass" int4, | |
| "minecart" int4, | |
| "cooked_beef" int4, | |
| "turtle_egg" int4, | |
| "beetroot_soup" int4, | |
| "pink_glazed_terracotta" int4, | |
| "snow_block" int4, | |
| "baked_potato" int4, | |
| "red_nether_bricks" int4, | |
| "birch_boat" int4, | |
| "brown_mushroom" int4, | |
| "music_disc_cat" int4, | |
| "spider_eye" int4, | |
| "piston" int4, | |
| "wooden_hoe" int4, | |
| "flower_pot" int4, | |
| "chicken" int4, | |
| "lapis_ore" int4, | |
| "detector_rail" int4, | |
| "stone_slab" int4, | |
| "stone_axe" int4, | |
| "end_crystal" int4, | |
| "pink_shulker_box" int4, | |
| "pumpkin_pie" int4, | |
| "birch_stairs" int4, | |
| "beetroot" int4, | |
| "music_disc_far" int4, | |
| "ladder" int4, | |
| "chest" int4, | |
| "white_shulker_box" int4, | |
| "grass_block" int4, | |
| "birch_sapling" int4, | |
| "orange_shulker_box" int4, | |
| "music_disc_chirp" int4, | |
| "music_disc_wait" int4, | |
| "stone_brick_stairs" int4, | |
| "music_disc_stal" int4, | |
| "rabbit_stew" int4, | |
| "snow" int4, | |
| "dark_oak_boat" int4, | |
| "furnace" int4, | |
| "egg" int4, | |
| "potato" int4, | |
| "magenta_shulker_box" int4, | |
| "emerald_ore" int4, | |
| "diorite" int4, | |
| "end_stone_bricks" int4, | |
| "spruce_door" int4, | |
| "powered_rail" int4, | |
| "purpur_pillar" int4, | |
| "oak_leaves" int4, | |
| "cookie" int4, | |
| "sand" int4, | |
| "purpur_stairs" int4, | |
| "blue_ice" int4, | |
| "pumpkin_seeds" int4, | |
| "stone_button" int4, | |
| "diamond_ore" int4, | |
| "fire_charge" int4, | |
| "wooden_sword" int4, | |
| "dark_oak_fence" int4, | |
| "white_stained_glass" int4, | |
| "ice" int4, | |
| "iron_bars" int4, | |
| "stone_sword" int4, | |
| "acacia_log" int4, | |
| "mycelium" int4, | |
| "netherrack" int4, | |
| "light_gray_shulker_box" int4, | |
| "anvil" int4, | |
| "chorus_flower" int4, | |
| "nether_brick_stairs" int4, | |
| "red_shulker_box" int4, | |
| "cyan_shulker_box" int4, | |
| "iron_axe" int4, | |
| "slime_block" int4, | |
| "totem_of_undying" int4, | |
| "melon_seeds" int4, | |
| "tripwire_hook" int4, | |
| "glowstone" int4, | |
| "beef" int4, | |
| "gray_glazed_terracotta" int4, | |
| "iron_trapdoor" int4, | |
| "observer" int4, | |
| "water_bucket" int4, | |
| "light_blue_glazed_terracotta" int4, | |
| "rabbit" int4, | |
| "yellow_shulker_box" int4, | |
| "salmon" int4, | |
| "mossy_cobblestone" int4, | |
| "comparator" int4, | |
| "oak_slab" int4, | |
| "crafting_table" int4, | |
| "cod" int4, | |
| "dark_oak_fence_gate" int4, | |
| "lime_shulker_box" int4, | |
| "cake" int4, | |
| "oak_log" int4, | |
| "ender_eye" int4, | |
| "sunflower" int4, | |
| "iron_pickaxe" int4, | |
| "purpur_slab" int4, | |
| "music_disc_blocks" int4, | |
| "cobblestone" int4, | |
| "glass_pane" int4, | |
| "brown_mushroom_block" int4, | |
| "jukebox" int4, | |
| "iron_shovel" int4, | |
| "diamond_hoe" int4, | |
| "white_concrete_powder" int4, | |
| "white_terracotta" int4, | |
| "iron_sword" int4, | |
| "player_head" int4, | |
| "nether_bricks" int4, | |
| "carrot" int4, | |
| "music_disc_11" int4, | |
| "milk_bucket" int4, | |
| "glass" int4, | |
| "coal_ore" int4, | |
| "hopper_minecart" int4, | |
| "stone_bricks" int4, | |
| "repeater" int4, | |
| "redstone_lamp" int4, | |
| "magma_block" int4, | |
| "hay_block" int4, | |
| "beetroot_seeds" int4, | |
| "dark_oak_stairs" int4, | |
| "birch_leaves" int4, | |
| "ender_pearl" int4, | |
| "redstone_block" int4, | |
| "black_banner" int4, | |
| "sponge" int4, | |
| "note_block" int4, | |
| "shears" int4, | |
| "redstone_torch" int4, | |
| "gray_shulker_box" int4, | |
| "firework_rocket" int4, | |
| "melon_slice" int4, | |
| "heavy_weighted_pressure_plate" int4, | |
| "birch_fence_gate" int4, | |
| "light_gray_concrete" int4, | |
| "string" int4, | |
| "gravel" int4, | |
| "andesite" int4, | |
| "chest_minecart" int4, | |
| "white_concrete" int4, | |
| "cobweb" int4, | |
| "experience_bottle" int4, | |
| "oak_fence" int4, | |
| "jungle_leaves" int4, | |
| "purpur_block" int4, | |
| "trident" int4, | |
| "tropical_fish" int4, | |
| "redstone_ore" int4, | |
| "oak_door" int4, | |
| "white_carpet" int4, | |
| "hopper" int4, | |
| "spruce_stairs" int4, | |
| "cobblestone_wall" int4, | |
| "shulker_box" int4, | |
| "oak_wood" int4, | |
| "granite" int4, | |
| "birch_door" int4, | |
| "stone_brick_slab" int4, | |
| "dark_oak_planks" int4, | |
| "bookshelf" int4, | |
| "golden_carrot" int4, | |
| "emerald_block" int4, | |
| "white_stained_glass_pane" int4, | |
| "stone_pressure_plate" int4, | |
| "cooked_mutton" int4, | |
| "acacia_boat" int4, | |
| "iron_ore" int4, | |
| "glass_bottle" int4, | |
| "black_shulker_box" int4, | |
| "beacon" int4, | |
| "terracotta" int4, | |
| "light_gray_concrete_powder" int4, | |
| "dark_oak_door" int4, | |
| "activator_rail" int4, | |
| "apple" int4, | |
| "map" int4, | |
| "green_shulker_box" int4, | |
| "fishing_rod" int4, | |
| "bucket" int4, | |
| "splash_potion" int4, | |
| "music_disc_ward" int4, | |
| "dark_prismarine_stairs" int4, | |
| "infested_stone" int4, | |
| "wooden_pickaxe" int4, | |
| "clay" int4, | |
| "chiseled_quartz_block" int4, | |
| "dead_bush" int4, | |
| "cooked_salmon" int4, | |
| "filled_map" int4, | |
| "horn_coral_fan" int4, | |
| "tube_coral_block" int4, | |
| "lead" int4, | |
| "spruce_trapdoor" int4, | |
| "bricks" int4, | |
| "stone_pickaxe" int4, | |
| "prismarine_stairs" int4, | |
| "barrier" int4, | |
| "pufferfish_bucket" int4, | |
| "bone_meal" int4, | |
| "brown_shulker_box" int4, | |
| "wooden_axe" int4, | |
| "oak_stairs" int4, | |
| "cobblestone_stairs" int4, | |
| "purple_glazed_terracotta" int4, | |
| "dark_prismarine_slab" int4, | |
| "red_mushroom" int4, | |
| "jungle_stairs" int4, | |
| "fire_coral_block" int4, | |
| "lapis_block" int4, | |
| "sea_pickle" int4, | |
| "spruce_slab" int4, | |
| "blue_stained_glass" int4, | |
| "polished_granite" int4, | |
| "bubble_coral_block" int4, | |
| "brain_coral_fan" int4, | |
| "jungle_trapdoor" int4, | |
| "polished_diorite" int4, | |
| "prismarine_slab" int4, | |
| "magenta_wool" int4, | |
| "prismarine_brick_slab" int4, | |
| "bubble_coral_fan" int4, | |
| "red_mushroom_block" int4, | |
| "fire_coral" int4, | |
| "dark_prismarine" int4, | |
| "light_blue_stained_glass_pane" int4, | |
| "carrot_on_a_stick" int4, | |
| "purple_shulker_box" int4, | |
| "prismarine_brick_stairs" int4, | |
| "fire_coral_fan" int4, | |
| "tropical_fish_bucket" int4, | |
| "stone_shovel" int4, | |
| "spruce_planks" int4, | |
| "wooden_shovel" int4, | |
| "light_blue_stained_glass" int4, | |
| "horn_coral_block" int4, | |
| "brain_coral_block" int4, | |
| "polished_andesite" int4, | |
| "cobblestone_slab" int4, | |
| "jungle_wood" int4, | |
| "painting" int4, | |
| "acacia_stairs" int4, | |
| "white_banner" int4, | |
| "magenta_glazed_terracotta" int4, | |
| "jack_o_lantern" int4, | |
| "birch_pressure_plate" int4, | |
| "azure_bluet" int4, | |
| "cyan_terracotta" int4, | |
| "quartz_pillar" int4, | |
| "quartz_slab" int4, | |
| "light_blue_bed" int4, | |
| "red_carpet" int4, | |
| "light_blue_carpet" int4, | |
| "gray_carpet" int4, | |
| "orange_tulip" int4, | |
| "gray_concrete" int4, | |
| "cyan_carpet" int4, | |
| "lime_carpet" int4, | |
| "birch_log" int4, | |
| "orange_bed" int4, | |
| "nether_brick_slab" int4, | |
| "pink_carpet" int4, | |
| "pumpkin" int4, | |
| "orange_carpet" int4, | |
| "magenta_carpet" int4, | |
| "chiseled_stone_bricks" int4, | |
| "blue_carpet" int4, | |
| "pink_bed" int4, | |
| "jungle_door" int4, | |
| "yellow_bed" int4, | |
| "purple_carpet" int4, | |
| "dead_horn_coral_block" int4, | |
| "tube_coral" int4, | |
| "seagrass" int4, | |
| "purple_terracotta" int4, | |
| "red_bed" int4, | |
| "bubble_coral" int4, | |
| "horn_coral" int4, | |
| "tube_coral_fan" int4, | |
| "brain_coral" int4, | |
| "yellow_terracotta" int4, | |
| "light_gray_terracotta" int4, | |
| "black_terracotta" int4, | |
| "acacia_door" int4, | |
| "acacia_fence_gate" int4, | |
| "nether_brick_fence" int4, | |
| "red_sandstone_slab" int4, | |
| "jungle_fence_gate" int4, | |
| "black_stained_glass_pane" int4, | |
| "dark_oak_slab" int4, | |
| "pink_wool" int4, | |
| "black_glazed_terracotta" int4, | |
| "dark_oak_trapdoor" int4, | |
| "red_sandstone" int4, | |
| "gray_stained_glass_pane" int4, | |
| "pufferfish" int4, | |
| "green_glazed_terracotta" int4, | |
| "light_gray_glazed_terracotta" int4, | |
| "spruce_button" int4, | |
| "sandstone_stairs" int4, | |
| "cracked_stone_bricks" int4, | |
| "vine" int4, | |
| "spruce_pressure_plate" int4, | |
| "kelp" int4, | |
| "red_sandstone_stairs" int4, | |
| "green_wool" int4, | |
| "brown_carpet" int4, | |
| "jungle_button" int4, | |
| "light_blue_wool" int4, | |
| "dark_oak_log" int4, | |
| "brown_wool" int4, | |
| "rose_bush" int4, | |
| "acacia_slab" int4, | |
| "black_stained_glass" int4, | |
| "dark_oak_pressure_plate" int4, | |
| "blue_wool" int4, | |
| "magenta_banner" int4, | |
| "gray_wool" int4, | |
| "dark_oak_button" int4, | |
| "dark_oak_sapling" int4, | |
| "mossy_cobblestone_wall" int4, | |
| "red_concrete" int4, | |
| "light_weighted_pressure_plate" int4, | |
| "red_concrete_powder" int4, | |
| "yellow_glazed_terracotta" int4, | |
| "red_stained_glass" int4, | |
| "lime_wool" int4, | |
| "mushroom_stem" int4, | |
| "sandstone_slab" int4, | |
| "blue_glazed_terracotta" int4, | |
| "music_disc_mall" int4, | |
| "red_glazed_terracotta" int4, | |
| "jungle_planks" int4, | |
| "dried_kelp_block" int4, | |
| "stripped_dark_oak_log" int4, | |
| "mossy_stone_bricks" int4, | |
| "zombie_head" int4, | |
| "nether_wart_block" int4, | |
| "creeper_head" int4, | |
| "furnace_minecart" int4, | |
| "birch_button" int4, | |
| "dried_kelp" int4, | |
| "cut_sandstone" int4, | |
| "black_wool" int4, | |
| "brick_stairs" int4, | |
| "orange_terracotta" int4, | |
| "green_concrete" int4, | |
| "red_wool" int4, | |
| "acacia_planks" int4, | |
| "spruce_wood" int4, | |
| "gray_stained_glass" int4, | |
| "cocoa_beans" int4, | |
| "jungle_sapling" int4, | |
| "chiseled_sandstone" int4, | |
| "lilac" int4, | |
| "jungle_log" int4, | |
| "podzol" int4, | |
| "spruce_leaves" int4, | |
| "white_tulip" int4, | |
| "red_tulip" int4, | |
| "brown_bed" int4, | |
| "pink_tulip" int4, | |
| "oxeye_daisy" int4, | |
| "yellow_wool" int4, | |
| "orange_wool" int4, | |
| "gray_bed" int4, | |
| "yellow_concrete" int4, | |
| "yellow_concrete_powder" int4, | |
| "light_gray_wool" int4, | |
| "brown_banner" int4, | |
| "dark_oak_wood" int4, | |
| "white_glazed_terracotta" int4, | |
| "stripped_oak_log" int4, | |
| "pink_terracotta" int4, | |
| "lime_stained_glass_pane" int4, | |
| "brick_slab" int4, | |
| "wet_sponge" int4, | |
| "red_stained_glass_pane" int4, | |
| "jungle_pressure_plate" int4, | |
| "black_concrete_powder" int4, | |
| "red_terracotta" int4, | |
| "black_concrete" int4, | |
| "brown_stained_glass" int4, | |
| "pink_banner" int4, | |
| "peony" int4, | |
| "birch_wood" int4, | |
| "black_bed" int4, | |
| "salmon_bucket" int4, | |
| "light_gray_bed" int4, | |
| "dead_horn_coral_fan" int4, | |
| "wither_skeleton_skull" int4, | |
| "dead_bubble_coral_block" int4, | |
| "dead_brain_coral_fan" int4, | |
| "dragon_egg" int4, | |
| "golden_axe" int4, | |
| "allium" int4, | |
| "red_banner" int4, | |
| "stripped_spruce_log" int4, | |
| "yellow_banner" int4, | |
| "light_blue_banner" int4, | |
| "blue_orchid" int4, | |
| "green_banner" int4, | |
| "cyan_glazed_terracotta" int4, | |
| "grass" int4, | |
| "orange_concrete" int4, | |
| "lime_concrete" int4, | |
| "green_carpet" int4, | |
| "orange_concrete_powder" int4, | |
| "brown_concrete" int4, | |
| "brown_concrete_powder" int4, | |
| "lime_concrete_powder" int4, | |
| "black_carpet" int4, | |
| "golden_pickaxe" int4, | |
| "cyan_banner" int4, | |
| "green_stained_glass_pane" int4, | |
| "blue_stained_glass_pane" int4, | |
| "green_stained_glass" int4, | |
| "blue_bed" int4, | |
| "petrified_oak_slab" int4, | |
| "green_bed" int4, | |
| "light_gray_banner" int4, | |
| "golden_hoe" int4, | |
| "purple_banner" int4, | |
| "orange_banner" int4, | |
| "stripped_oak_wood" int4, | |
| "lime_glazed_terracotta" int4, | |
| "purple_stained_glass" int4, | |
| "orange_stained_glass" int4, | |
| "bedrock" int4, | |
| "lime_stained_glass" int4, | |
| "chorus_plant" int4, | |
| "jungle_slab" int4, | |
| "dead_fire_coral_block" int4, | |
| "gray_terracotta" int4, | |
| "yellow_stained_glass" int4, | |
| "pink_stained_glass_pane" int4, | |
| "dragon_head" int4, | |
| "dead_brain_coral_block" int4, | |
| "acacia_sapling" int4, | |
| "dead_tube_coral_fan" int4, | |
| "lime_banner" int4, | |
| "dead_fire_coral_fan" int4, | |
| "drowned_spawn_egg" int4, | |
| "tnt" int4, | |
| "command_block" int4, | |
| "end_portal_frame" int4, | |
| "brown_glazed_terracotta" int4, | |
| "cyan_bed" int4, | |
| "spawner" int4, | |
| "dolphin_spawn_egg" int4, | |
| "cow_spawn_egg" int4, | |
| "grass_path" int4, | |
| "stripped_acacia_log" int4, | |
| "blue_concrete" int4, | |
| "blue_concrete_powder" int4, | |
| "golden_shovel" int4, | |
| "stripped_birch_log" int4, | |
| "yellow_stained_glass_pane" int4, | |
| "pink_stained_glass" int4, | |
| "tropical_fish_spawn_egg" int4, | |
| "magenta_stained_glass" int4, | |
| "repeating_command_block" int4, | |
| "lime_bed" int4, | |
| "red_sand" int4, | |
| "brown_terracotta" int4, | |
| "magenta_stained_glass_pane" int4, | |
| "dead_bubble_coral_fan" int4, | |
| "acacia_wood" int4, | |
| "squid_spawn_egg" int4, | |
| "green_concrete_powder" int4, | |
| "magenta_bed" int4, | |
| "blue_banner" int4, | |
| "chiseled_red_sandstone" int4, | |
| "acacia_trapdoor" int4, | |
| "enchanted_golden_apple" int4, | |
| "coarse_dirt" int4, | |
| "purple_stained_glass_pane" int4, | |
| "acacia_button" int4, | |
| "zombie_spawn_egg" int4, | |
| "cyan_wool" int4, | |
| "zombie_pigman_spawn_egg" int4, | |
| "purple_wool" int4, | |
| "llama_spawn_egg" int4, | |
| "stripped_jungle_log" int4, | |
| "gray_concrete_powder" int4, | |
| "orange_stained_glass_pane" int4, | |
| "fern" int4, | |
| "acacia_pressure_plate" int4, | |
| "pink_concrete_powder" int4, | |
| "light_blue_terracotta" int4, | |
| "green_terracotta" int4, | |
| "brown_stained_glass_pane" int4 | |
| ) | |
| ; | |
| -- ---------------------------- | |
| -- Primary Key structure for table T_player_stats_broken | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_broken" ADD CONSTRAINT "T_player_stats_broken_pkey" PRIMARY KEY ("id"); | |
| -- ---------------------------- | |
| -- Primary Key structure for table T_player_stats_crafted | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_crafted" ADD CONSTRAINT "T_player_stats_crafted_pkey" PRIMARY KEY ("id"); | |
| -- ---------------------------- | |
| -- Primary Key structure for table T_player_stats_custom | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_custom" ADD CONSTRAINT "T_player_stats_custom_pkey" PRIMARY KEY ("id"); | |
| -- ---------------------------- | |
| -- Primary Key structure for table T_player_stats_dropped | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_dropped" ADD CONSTRAINT "T_player_stats_dropped_pkey" PRIMARY KEY ("id"); | |
| -- ---------------------------- | |
| -- Primary Key structure for table T_player_stats_killed | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_killed" ADD CONSTRAINT "T_player_stats_killed_pkey" PRIMARY KEY ("id"); | |
| -- ---------------------------- | |
| -- Primary Key structure for table T_player_stats_killed_by | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_killed_by" ADD CONSTRAINT "T_player_stats_killed_by_pkey" PRIMARY KEY ("id"); | |
| -- ---------------------------- | |
| -- Primary Key structure for table T_player_stats_mined | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_mined" ADD CONSTRAINT "T_player_stats_mined_pkey" PRIMARY KEY ("id"); | |
| -- ---------------------------- | |
| -- Primary Key structure for table T_player_stats_picked_up | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_picked_up" ADD CONSTRAINT "T_player_stats_picked_up_pkey" PRIMARY KEY ("id"); | |
| -- ---------------------------- | |
| -- Primary Key structure for table T_player_stats_used | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_used" ADD CONSTRAINT "T_player_stats_used_pkey" PRIMARY KEY ("id"); | |
| -- ---------------------------- | |
| -- Foreign Keys structure for table T_player_stats_broken | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_broken" ADD CONSTRAINT "fk_T_player_stats_broken_T_player_info_1" FOREIGN KEY ("uuid") REFERENCES "public"."T_player_info" ("uuid") ON DELETE NO ACTION ON UPDATE NO ACTION; | |
| -- ---------------------------- | |
| -- Foreign Keys structure for table T_player_stats_crafted | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_crafted" ADD CONSTRAINT "fk_T_player_stats_crafted_T_player_info_1" FOREIGN KEY ("uuid") REFERENCES "public"."T_player_info" ("uuid") ON DELETE NO ACTION ON UPDATE NO ACTION; | |
| -- ---------------------------- | |
| -- Foreign Keys structure for table T_player_stats_custom | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_custom" ADD CONSTRAINT "fk_T_player_stats_custom_T_player_info_1" FOREIGN KEY ("uuid") REFERENCES "public"."T_player_info" ("uuid") ON DELETE NO ACTION ON UPDATE NO ACTION; | |
| -- ---------------------------- | |
| -- Foreign Keys structure for table T_player_stats_dropped | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_dropped" ADD CONSTRAINT "fk_T_player_stats_dropped_T_player_info_1" FOREIGN KEY ("uuid") REFERENCES "public"."T_player_info" ("uuid") ON DELETE NO ACTION ON UPDATE NO ACTION; | |
| -- ---------------------------- | |
| -- Foreign Keys structure for table T_player_stats_killed | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_killed" ADD CONSTRAINT "fk_T_player_stats_killed_T_player_info_1" FOREIGN KEY ("uuid") REFERENCES "public"."T_player_info" ("uuid") ON DELETE NO ACTION ON UPDATE NO ACTION; | |
| -- ---------------------------- | |
| -- Foreign Keys structure for table T_player_stats_killed_by | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_killed_by" ADD CONSTRAINT "fk_T_player_stats_killed_by_T_player_info_1" FOREIGN KEY ("uuid") REFERENCES "public"."T_player_info" ("uuid") ON DELETE NO ACTION ON UPDATE NO ACTION; | |
| -- ---------------------------- | |
| -- Foreign Keys structure for table T_player_stats_mined | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_mined" ADD CONSTRAINT "fk_T_player_stats_mined_T_player_info_1" FOREIGN KEY ("uuid") REFERENCES "public"."T_player_info" ("uuid") ON DELETE NO ACTION ON UPDATE NO ACTION; | |
| -- ---------------------------- | |
| -- Foreign Keys structure for table T_player_stats_picked_up | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_picked_up" ADD CONSTRAINT "fk_T_player_stats_picked_up_T_player_info_1" FOREIGN KEY ("uuid") REFERENCES "public"."T_player_info" ("uuid") ON DELETE NO ACTION ON UPDATE NO ACTION; | |
| -- ---------------------------- | |
| -- Foreign Keys structure for table T_player_stats_used | |
| -- ---------------------------- | |
| ALTER TABLE "public"."T_player_stats_used" ADD CONSTRAINT "fk_T_player_stats_used_T_player_info_1" FOREIGN KEY ("uuid") REFERENCES "public"."T_player_info" ("uuid") ON DELETE NO ACTION ON UPDATE NO ACTION; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment