# SHOW TABLE STATUS generated from 5.1.32
import datetime

STATUS_DATABASES = [
    'information_schema',
    'employees',
    'mysql',
    'test'
]

INFORMATION_SCHEMA_TABLE_STATUS = [  
    (   'CHARACTER_SETS',
        'MEMORY',
        10L,
        'Fixed',
        None,
        384L,
        0L,
        16604160L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=43690',
        ''),
    (   'COLLATIONS',
        'MEMORY',
        10L,
        'Fixed',
        None,
        231L,
        0L,
        16704765L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=72628',
        ''),
    (   'COLLATION_CHARACTER_SET_APPLICABILITY',
        'MEMORY',
        10L,
        'Fixed',
        None,
        195L,
        0L,
        16691610L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=86037',
        ''),
    (   'COLUMNS',
        'MyISAM',
        10L,
        'Dynamic',
        None,
        0L,
        0L,
        281474976710655L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        None,
        'utf8_general_ci',
        None,
        'max_rows=4560',
        ''),
    (   'COLUMN_PRIVILEGES',
        'MEMORY',
        10L,
        'Fixed',
        None,
        2565L,
        0L,
        16757145L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=6540',
        ''),
    (   'ENGINES',
        'MEMORY',
        10L,
        'Fixed',
        None,
        490L,
        0L,
        16709000L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=34239',
        ''),
    (   'EVENTS',
        'MyISAM',
        10L,
        'Dynamic',
        None,
        0L,
        0L,
        281474976710655L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        None,
        'utf8_general_ci',
        None,
        'max_rows=618',
        ''),
    (   'FILES',
        'MEMORY',
        10L,
        'Fixed',
        None,
        2677L,
        0L,
        16758020L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=6267',
        ''),
    (   'GLOBAL_STATUS',
        'MEMORY',
        10L,
        'Fixed',
        None,
        3268L,
        0L,
        16755036L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=5133',
        ''),
    (   'GLOBAL_VARIABLES',
        'MEMORY',
        10L,
        'Fixed',
        None,
        3268L,
        0L,
        16755036L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=5133',
        ''),
    (   'KEY_COLUMN_USAGE',
        'MEMORY',
        10L,
        'Fixed',
        None,
        4637L,
        0L,
        16762755L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=3618',
        ''),
    (   'PARTITIONS',
        'MyISAM',
        10L,
        'Dynamic',
        None,
        0L,
        0L,
        281474976710655L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        None,
        'utf8_general_ci',
        None,
        'max_rows=5612',
        ''),
    (   'PLUGINS',
        'MyISAM',
        10L,
        'Dynamic',
        None,
        0L,
        0L,
        281474976710655L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        None,
        'utf8_general_ci',
        None,
        'max_rows=13025',
        ''),
    (   'PROCESSLIST',
        'MyISAM',
        10L,
        'Dynamic',
        None,
        0L,
        0L,
        281474976710655L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        None,
        'utf8_general_ci',
        None,
        'max_rows=23763',
        ''),
    (   'PROFILING',
        'MEMORY',
        10L,
        'Fixed',
        None,
        308L,
        0L,
        16562084L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=54471',
        ''),
    (   'REFERENTIAL_CONSTRAINTS',
        'MEMORY',
        10L,
        'Fixed',
        None,
        4814L,
        0L,
        16767162L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=3485',
        ''),
    (   'ROUTINES',
        'MyISAM',
        10L,
        'Dynamic',
        None,
        0L,
        0L,
        281474976710655L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        None,
        'utf8_general_ci',
        None,
        'max_rows=588',
        ''),
    (   'SCHEMATA',
        'MEMORY',
        10L,
        'Fixed',
        None,
        3464L,
        0L,
        16755368L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=4843',
        ''),
    (   'SCHEMA_PRIVILEGES',
        'MEMORY',
        10L,
        'Fixed',
        None,
        2179L,
        0L,
        16767405L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=7699',
        ''),
    (   'SESSION_STATUS',
        'MEMORY',
        10L,
        'Fixed',
        None,
        3268L,
        0L,
        16755036L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=5133',
        ''),
    (   'SESSION_VARIABLES',
        'MEMORY',
        10L,
        'Fixed',
        None,
        3268L,
        0L,
        16755036L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=5133',
        ''),
    (   'STATISTICS',
        'MEMORY',
        10L,
        'Fixed',
        None,
        2679L,
        0L,
        16770540L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=6262',
        ''),
    (   'TABLE_STATUS',
        'MEMORY',
        10L,
        'Fixed',
        None,
        3545L,
        0L,
        16760760L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=4732',
        ''),
    (   'TABLE_CONSTRAINTS',
        'MEMORY',
        10L,
        'Fixed',
        None,
        2504L,
        0L,
        16749256L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=6700',
        ''),
    (   'TABLE_PRIVILEGES',
        'MEMORY',
        10L,
        'Fixed',
        None,
        2372L,
        0L,
        16748692L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=7073',
        ''),
    (   'TRIGGERS',
        'MyISAM',
        10L,
        'Dynamic',
        None,
        0L,
        0L,
        281474976710655L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        None,
        'utf8_general_ci',
        None,
        'max_rows=569',
        ''),
    (   'USER_PRIVILEGES',
        'MEMORY',
        10L,
        'Fixed',
        None,
        1986L,
        0L,
        16759854L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        'max_rows=8447',
        ''),
    (   'VIEWS',
        'MyISAM',
        10L,
        'Dynamic',
        None,
        0L,
        0L,
        281474976710655L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        datetime.datetime(2009, 5, 4, 14, 44, 31),
        None,
        'utf8_general_ci',
        None,
        'max_rows=6932',
        '')
]

EMPLOYEES_TABLE_STATUS = [   
    (   'departments',
        'InnoDB',
        10L,
        'Compact',
        9L,
        1820L,
        16384L,
        0L,
        16384L,
        38797312L,
        None,
        datetime.datetime(2009, 5, 4, 0, 34, 27),
        None,
        None,
        'latin1_swedish_ci',
        None,
        '',
        ''),
    (   'dept_emp',
        'InnoDB',
        10L,
        'Compact',
        332289L,
        36L,
        12075008L,
        0L,
        10518528L,
        38797312L,
        None,
        datetime.datetime(2009, 5, 4, 0, 34, 27),
        None,
        None,
        'latin1_swedish_ci',
        None,
        '',
        ''),
    (   'dept_manager',
        'InnoDB',
        10L,
        'Compact',
        24L,
        682L,
        16384L,
        0L,
        32768L,
        38797312L,
        None,
        datetime.datetime(2009, 5, 4, 0, 34, 27),
        None,
        None,
        'latin1_swedish_ci',
        None,
        '',
        ''),
    (   'employees',
        'InnoDB',
        10L,
        'Compact',
        299366L,
        50L,
        15220736L,
        0L,
        0L,
        38797312L,
        None,
        datetime.datetime(2009, 5, 4, 0, 34, 27),
        None,
        None,
        'latin1_swedish_ci',
        None,
        '',
        ''),
    (   'salaries',
        'InnoDB',
        10L,
        'Compact',
        2844513L,
        35L,
        100270080L,
        0L,
        36241408L,
        38797312L,
        None,
        datetime.datetime(2009, 5, 4, 0, 34, 27),
        None,
        None,
        'latin1_swedish_ci',
        None,
        '',
        ''),
    (   'titles',
        'InnoDB',
        10L,
        'Compact',
        443951L,
        46L,
        20512768L,
        0L,
        11059200L,
        38797312L,
        None,
        datetime.datetime(2009, 5, 4, 0, 34, 27),
        None,
        None,
        'latin1_swedish_ci',
        None,
        '',
        '')
]

MYSQL_TABLE_STATUS = [   
    (   'columns_priv',
        'MyISAM',
        10L,
        'Fixed',
        0L,
        0L,
        0L,
        227994731135631359L,
        4096L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        None,
        'utf8_bin',
        None,
        '',
        'Column privileges'),
    (   'db',
        'MyISAM',
        10L,
        'Fixed',
        0L,
        0L,
        880L,
        123848989752688639L,
        5120L,
        880L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 32),
        datetime.datetime(2009, 3, 24, 18, 4, 7),
        datetime.datetime(2009, 3, 24, 18, 3, 35),
        'utf8_bin',
        None,
        '',
        'Database privileges'),
    (   'event',
        'MyISAM',
        10L,
        'Dynamic',
        0L,
        0L,
        0L,
        281474976710655L,
        2048L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 35),
        datetime.datetime(2009, 3, 24, 18, 3, 35),
        None,
        'utf8_general_ci',
        None,
        '',
        'Events'),
    (   'func',
        'MyISAM',
        10L,
        'Fixed',
        0L,
        0L,
        0L,
        162974011515469823L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        None,
        'utf8_bin',
        None,
        '',
        'User defined functions'),
    (   'general_log',
        'CSV',
        10L,
        'Dynamic',
        2L,
        0L,
        0L,
        0L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        '',
        'General log'),
    (   'help_category',
        'MyISAM',
        10L,
        'Fixed',
        37L,
        581L,
        21497L,
        163536961468891135L,
        3072L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        datetime.datetime(2009, 3, 24, 18, 3, 35),
        None,
        'utf8_general_ci',
        None,
        '',
        'help categories'),
    (   'help_keyword',
        'MyISAM',
        10L,
        'Fixed',
        450L,
        197L,
        88650L,
        55450570411999231L,
        16384L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        datetime.datetime(2009, 3, 24, 18, 3, 35),
        None,
        'utf8_general_ci',
        None,
        '',
        'help keywords'),
    (   'help_relation',
        'MyISAM',
        10L,
        'Fixed',
        986L,
        9L,
        8874L,
        2533274790395903L,
        16384L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        datetime.datetime(2009, 3, 24, 18, 3, 35),
        None,
        'utf8_general_ci',
        None,
        '',
        'keyword-topic relation'),
    (   'help_topic',
        'MyISAM',
        10L,
        'Dynamic',
        503L,
        817L,
        411064L,
        281474976710655L,
        20480L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        datetime.datetime(2009, 3, 24, 18, 3, 35),
        None,
        'utf8_general_ci',
        None,
        '',
        'help topics'),
    (   'host',
        'MyISAM',
        10L,
        'Fixed',
        0L,
        0L,
        0L,
        110056715893866495L,
        2048L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 32),
        datetime.datetime(2009, 3, 24, 18, 3, 32),
        None,
        'utf8_bin',
        None,
        '',
        'Host privileges;  Merged with database privileges'),
    (   'ndb_binlog_index',
        'MyISAM',
        10L,
        'Dynamic',
        0L,
        0L,
        0L,
        281474976710655L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 35),
        datetime.datetime(2009, 3, 24, 18, 3, 35),
        None,
        'latin1_swedish_ci',
        None,
        '',
        ''),
    (   'plugin',
        'MyISAM',
        10L,
        'Fixed',
        0L,
        0L,
        0L,
        162411061562048511L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        None,
        'utf8_bin',
        None,
        '',
        'MySQL plugins'),
    (   'proc',
        'MyISAM',
        10L,
        'Dynamic',
        0L,
        0L,
        0L,
        281474976710655L,
        2048L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 34),
        datetime.datetime(2009, 3, 24, 18, 3, 34),
        None,
        'utf8_general_ci',
        None,
        '',
        'Stored Procedures'),
    (   'procs_priv',
        'MyISAM',
        10L,
        'Fixed',
        0L,
        0L,
        0L,
        239253730204057599L,
        4096L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 34),
        datetime.datetime(2009, 3, 24, 18, 3, 34),
        None,
        'utf8_bin',
        None,
        '',
        'Procedure privileges'),
    (   'servers',
        'MyISAM',
        10L,
        'Fixed',
        0L,
        0L,
        0L,
        433752939111120895L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        None,
        'utf8_general_ci',
        None,
        '',
        'MySQL Foreign Servers table'),
    (   'slow_log',
        'CSV',
        10L,
        'Dynamic',
        2L,
        0L,
        0L,
        0L,
        0L,
        0L,
        None,
        None,
        None,
        None,
        'utf8_general_ci',
        None,
        '',
        'Slow log'),
    (   'tables_priv',
        'MyISAM',
        10L,
        'Fixed',
        0L,
        0L,
        0L,
        239535205180768255L,
        4096L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        None,
        'utf8_bin',
        None,
        '',
        'Table privileges'),
    (   'time_zone',
        'MyISAM',
        10L,
        'Fixed',
        0L,
        0L,
        0L,
        1970324836974591L,
        1024L,
        0L,
        1L,
        datetime.datetime(2009, 3, 24, 18, 3, 34),
        datetime.datetime(2009, 3, 24, 18, 3, 34),
        None,
        'utf8_general_ci',
        None,
        '',
        'Time zones'),
    (   'time_zone_leap_second',
        'MyISAM',
        10L,
        'Fixed',
        0L,
        0L,
        0L,
        3659174697238527L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 34),
        datetime.datetime(2009, 3, 24, 18, 3, 34),
        None,
        'utf8_general_ci',
        None,
        '',
        'Leap seconds information for time zones'),
    (   'time_zone_name',
        'MyISAM',
        10L,
        'Fixed',
        0L,
        0L,
        0L,
        55450570411999231L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        datetime.datetime(2009, 3, 24, 18, 3, 33),
        None,
        'utf8_general_ci',
        None,
        '',
        'Time zone names'),
    (   'time_zone_transition',
        'MyISAM',
        10L,
        'Fixed',
        0L,
        0L,
        0L,
        4785074604081151L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 34),
        datetime.datetime(2009, 3, 24, 18, 3, 34),
        None,
        'utf8_general_ci',
        None,
        '',
        'Time zone transitions'),
    (   'time_zone_transition_type',
        'MyISAM',
        10L,
        'Fixed',
        0L,
        0L,
        0L,
        10696049115004927L,
        1024L,
        0L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 34),
        datetime.datetime(2009, 3, 24, 18, 3, 34),
        None,
        'utf8_general_ci',
        None,
        '',
        'Time zone transition types'),
    (   'user',
        'MyISAM',
        10L,
        'Dynamic',
        2L,
        96L,
        440L,
        281474976710655L,
        2048L,
        248L,
        None,
        datetime.datetime(2009, 3, 24, 18, 3, 32),
        datetime.datetime(2009, 3, 24, 18, 4, 7),
        None,
        'utf8_bin',
        None,
        '',
        'Users and global privileges')
]
TEST_TABLE_STATUS = []
