SQLite format 3@ .4               V  %Z~'';tableonline_id_banonline_id_banCREATE TABLE online_id_ban ( online_id INTEGER UNSIGNED NOT NULL UNIQUE, -- Online id from STK addons database for banning starting_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- Starting time of this banning entry to be effective expired_days REAL NULL DEFAULT NULL, -- Days for this banning to be expired, use NULL for a permanent ban reason TEXT NOT NULL DEFAULT '', -- Banned reason shown in user stk menu, can be empty description TEXT NOT NULL DEFAULT '', -- Private description for server admin trigger_count INTEGER UNSIGNED NOT NULL DEFAULT 0, -- Number of banning triggered by this ban entry last_trigger TIMESTAMP NULL DEFAULT NULL -- Latest time this banning entry was triggered );[tableipv6_banipv6_banCREATE TABLE ipv6_ban ( ipv6_cidr TEXT NOT NULL UNIQUE, -- IPv6 CIDR range for banning (for example 2001::/64), use /128 for a specific ip starting_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- Starting time of this banning entry to be effective expired_days REAL NULL DEFAULT NULL, -- Days for this banning to be expired, use NULL for a permanent ban reason TEXT NOT NULL DEFAULT '', -- Banned reason shown in user stk menu, can be empty description TEXT NOT NULL DEFAULT '', -- Private description for server admin trigger_count INTEGER UNSIGNED NOT NULL DEFAULT 0, -- Number of banning triggered by this ban entry last_trigger TIMESTAMP NULL DEFAULT NULL -- Latest time this banning entry was triggered )/Cindexsqlite_autoindex_ipv6_ban_1ipv6_banEetableip_banip_banCREATE TABLE ip_ban ( ip_start INTEGER UNSIGNED NOT NULL UNIQUE, -- Starting of ip decimal for banning (inclusive) ip_end INTEGER UNSIGNED NOT NULL UNIQUE, -- Ending of ip decimal for banning (inclusive) starting_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- Starting time of this banning entry to be effective expired_days REAL NULL DEFAULT NULL, -- Days for this banning to be expired, use NULL for a permanent ban reason TEXT NOT NULL DEFAULT '', -- Banned reason shown in user stk menu, can be empty description TEXT NOT NULL DEFAULT '', -- Private description for server admin trigger_count INTEGER UNSIGNED NOT NULL DEFAULT 0, -- Number of banning triggered by this ban entry last_trigger TIMESTAMP NULL DEFAULT NULL -- Latest time this banning entry was triggered )+?indexsqlite_autoindex_ip_ban_2ip_ban+?indexsqlite_autoindex_ip_ban_1ip_ban    j %%stableipv6_mappingipv6_mappingCREATE TABLE ipv6_mapping ( ip_start INTEGER UNSIGNED NOT NULL PRIMARY KEY UNIQUE, -- IP decimal (upper 64bit) start ip_end INTEGER UNSIGNED NOT NULL UNIQUE, -- IP decimal (upper 64bit) end latitude REAL NOT NULL, -- Latitude of this IP range longitude REAL NOT NULL, -- Longitude of this IP range country_code TEXT NOT NULL -- 2-letter country code )7 K%indexsqlite_autoindex_ipv6_mapping_2ipv6_mapping7 K%indexsqlite_autoindex_ipv6_mapping_1ipv6_mapping3 G!indexsqlite_autoindex_ip_mapping_2ip_mapping  !!Stableip_mappingip_mapping CREATE TABLE ip_mapping ( ip_start INTEGER UNSIGNED NOT NULL PRIMARY KEY UNIQUE, -- IP decimal start ip_end INTEGER UNSIGNED NOT NULL UNIQUE, -- IP decimal end latitude REAL NOT NULL, -- Latitude of this IP range longitude REAL NOT NULL, -- Longitude of this IP range country_code TEXT NOT NULL -- 2-letter country code ) WITHOUT ROWID"))tableplayer_reportsplayer_reports CREATE TABLE player_reports ( server_uid TEXT NOT NULL, -- Report from which server unique id (config filename) reporter_ip INTEGER UNSIGNED NOT NULL, -- IP decimal of player who reports reporter_ipv6 TEXT NOT NULL DEFAULT '', -- IPv6 (if exists) in string of player who reports (only needed for IPv6 server) reporter_online_id INTEGER UNSIGNED NOT NULL, -- Online id of player who reports, 0 for offline player reporter_username TEXT NOT NULL, -- Player name who reports reported_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- Time of reporting info TEXT NOT NULL, -- Report info by reporter reporting_ip INTEGER UNSIGNED NOT NULL, -- IP decimal of player being reported reporting_ipv6 TEXT NOT NULL DEFAULT '', -- IPv6 (if exists) in string of player who reports (only needed for IPv6 server) reporting_online_id INTEGER UNSIGNED NOT NULL, -- Online id of player being reported, 0 for offline player reporting_username TEXT NOT NULL -- Player name being reported )9M'indexsqlite_autoindex_online_id_ban_1online_id_ban