id : int(10) unsigned

user : varchar(255)

label : varchar(255)

query : text

col_name : varchar(64)

col_type : varchar(64)

col_length : text

col_collation : varchar(64)

col_isNull : tinyint(1)

col_extra : varchar(255)

col_default : text

id : int(5) unsigned

table_name : varchar(64)

column_name : varchar(64)

comment : varchar(255)

mimetype : varchar(255)

transformation : varchar(255)

transformation_options : varchar(255)

input_transformation : varchar(255)

input_transformation_options : varchar(255)

settings_data : text

id : int(5) unsigned

export_type : varchar(10)

template_name : varchar(64)

template_data : text

tables : text

id : bigint(20) unsigned

db : varchar(64)

table : varchar(64)

timevalue : timestamp

sqlquery : text

item_name : varchar(64)

item_type : varchar(64)

db_name : varchar(64)

table_name : varchar(64)

page_nr : int(10) unsigned

page_descr : varchar(50)

tables : text

master_table : varchar(64)

master_field : varchar(64)

foreign_db : varchar(64)

foreign_table : varchar(64)

foreign_field : varchar(64)

id : int(5) unsigned

db_name : varchar(64)

search_name : varchar(64)

search_data : text

table_name : varchar(64)

pdf_page_number : int(11)

x : float unsigned

y : float unsigned

table_name : varchar(64)

display_field : varchar(64)

db_name : varchar(64)

table_name : varchar(64)

prefs : text

last_update : timestamp

table_name : varchar(64)

version : int(10) unsigned

date_created : datetime

date_updated : datetime

schema_snapshot : text

schema_sql : text

data_sql : longtext

tracking : set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW')

tracking_active : int(1) unsigned

timevalue : timestamp

config_data : text

tab : varchar(64)

allowed : enum('Y','N')

usergroup : varchar(64)