Schema and Table Structure Check

Time: {ts '2026-01-27 08:10:07'}

1. Available Databases

Found 76 databases:

Database Name
#rocksdb
#ucc.net-Test
Executive
GCC-DeV-E
GCC-DeV-E_log
GCC-UW-07-11-2021
GCC-Wing
GCCBWT
GCCBWT_log
GCCD_bak2
GCF
GCF-DeV
GCF-DeV_log
GCF_log
UCC.net-Blank
Vision
WRI
WRI-Dev
WRI-Dev_Admin
WRI-Dev_GCC
WRI-Dev_UCC
WRI_Admin
WRI_GCC
WRI_UCC
gcc
gcc-09-20-2020
gcc.net
gcc_backup032920
gcc_log
gccd2_logs
gccd2_users
gccd_bak
gccd_log_old
gccd_old
gcdm
gcdm_archive
gcdm_global
gcdm_log
gcr
gcs
gcs_bak
gcs_log
gcs_ren_old
global
information_schema
m_14
m_146
mysql
performance_schema
phpbb
phpmyadmin
uc_temp
ucc
ucc.net-00
ucc.net-00001
ucc.net-0001
ucc.net-01-20-2021
ucc.net-03-22-2021
ucc.net-1-17-2021
ucc.net-11-25-2020
ucc.net-12-22-2020
ucc.net-12-25-2020
ucc.net-12-25-2020-enginetest
ucc.net-BW
ucc.net-old-1
ucc.net.bak
ucc.net.fix
ucc.net2
ucc.netexold
ucc_log
ucc_old
ucc_older
uccd
uccd2
uccd_log
uccnet2

2. Check if 'global' database exists

Global database exists!

3. Check 'fed' table structure in global database

Fed table structure in global database:

FieldTypeNullKeyDefaultExtra
match_id bigint(20) NO MUL 0
id int(11) NO PRI auto_increment
fedtag tinyint(1) YES MUL 0
shortdetail varchar(50) YES
detail longtext YES
detail2 longtext YES 'Objective


Rules


'
webpage longtext YES
leader int(11) YES MUL
leader2 int(11) YES
leader3 int(11) YES
server tinyint(3) unsigned YES MUL
hit smallint(6) YES 0
war int(11) YES MUL
ally int(11) YES MUL
faction tinyint(3) unsigned YES MUL
name varchar(50) YES

'desc' column does NOT exist in global.fed table

4. Compare with main GCDM fed table

Fed table structure in main gcdm database:

FieldTypeNullKeyDefaultExtra
id int(11) NO PRI auto_increment
fedtag tinyint(1) YES MUL 0
shortdetail varchar(50) YES
detail longtext YES
detail2 longtext YES 'Objective


Rules


'
webpage longtext YES
leader int(11) YES MUL
leader2 int(11) YES
leader3 int(11) YES
server tinyint(3) unsigned YES MUL
hit smallint(6) YES 0
war int(11) YES MUL
ally int(11) YES MUL
faction tinyint(3) unsigned YES MUL
name varchar(50) YES

5. Check all tables in global database

Found 21 tables in global database:

Table Name

Error checking global database tables: Column [1] not found in query

The global database likely doesn't exist or isn't accessible.

6. Test Insert into global.fed

Test insert failed: Unknown column 'desc' in 'field list'

SQL State: 42S22

Detail:

7. Database Setup Commands

If the global database doesn't exist, you need to run:

-- Create the global database
CREATE DATABASE IF NOT EXISTS `global` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;

-- Import the global schema
-- Run the global.sql file to create all tables

View global.sql file