Compalex

Database schema compare tool

tables views procedures functions indexes triggers  all changed

testsystem

207.180.237.85:3306/testsystem

roga_backup

207.180.237.85:3306/roga_backup

actioncodes 4

engine: InnoDB
collation: utf8_general_ci
  • actioncode_id int(10) unsigned
  • country_id int(10) unsigned
  • actioncode varchar(20)
  • validto date
Sample data (0 rows)

actioncodes 4

engine: InnoDB
collation: utf8_general_ci
  • actioncode_id int(10) unsigned
  • country_id int(10) unsigned
  • actioncode varchar(20)
  • validto date
Sample data (0 rows)

adminuser 12

engine: InnoDB
collation: utf8_general_ci
  • adminuser_id int(10) unsigned
  • country_id int(10) unsigned
  • greeting varchar(20)
  • name varchar(100)
  • loginname varchar(100)
  • passwd varchar(100)
  • email varchar(50)
  • logincount mediumint(8) unsigned
  • lastlogin datetime
  • created date
  • accesslevel int(10) unsigned
  • locked int(11)
Sample data (0 rows)

adminuser 12

engine: InnoDB
collation: utf8_general_ci
  • adminuser_id int(10) unsigned
  • country_id int(10) unsigned
  • greeting varchar(20)
  • name varchar(100)
  • loginname varchar(100)
  • passwd varchar(100)
  • email varchar(50)
  • logincount mediumint(8) unsigned
  • lastlogin datetime
  • created date
  • accesslevel int(10) unsigned
  • locked int(11)
Sample data (0 rows)

anrede 5

engine: MyISAM
collation: utf8_general_ci
  • id int(10)
  • language_id int(10)
  • iso_lang varchar(2)
  • male varchar(20)
  • female varchar(20)
Sample data (0 rows)

anrede 5

engine: MyISAM
collation: utf8_general_ci
  • id int(10)
  • language_id int(4)
  • iso_lang varchar(2)
  • male varchar(10)
  • female varchar(10)
Sample data (0 rows)

berater 9

engine: InnoDB
collation: utf8_general_ci
  • berater_id int(10) unsigned
  • country_id int(10)
  • name varchar(100)
  • loginname varchar(100)
  • passwd varchar(100)
  • email varchar(50)
  • lastlogin datetime
  • created date
  • locked int(10)
Sample data (0 rows)

berater 9

engine: InnoDB
collation: utf8_general_ci
  • berater_id int(10) unsigned
  • country_id int(10)
  • name varchar(100)
  • loginname varchar(100)
  • passwd varchar(100)
  • email varchar(50)
  • lastlogin datetime
  • created date
  • locked int(10)
Sample data (0 rows)

branches 6

engine: InnoDB
collation: utf8_general_ci
  • branch_id int(10) unsigned
  • lang_id int(10) unsigned
  • country_id int(10) unsigned
  • branchkey_id int(10) unsigned
  • name_local varchar(100)
  • locked int(10) unsigned
Sample data (0 rows)

branches 6

engine: InnoDB
collation: utf8_general_ci
  • branch_id int(10) unsigned
  • lang_id int(10) unsigned
  • country_id int(10) unsigned
  • branchkey_id int(10) unsigned
  • name_local varchar(100)
  • locked int(10) unsigned
Sample data (0 rows)

branchesoffirms 3

engine: InnoDB
collation: utf8_general_ci
  • branchesoffirm_id int(11)
  • branchkey_id int(10) unsigned
  • firm_id int(10) unsigned
Sample data (0 rows)

branchesoffirms 3

engine: InnoDB
collation: utf8_general_ci
  • branchesoffirm_id int(11)
  • branchkey_id int(10) unsigned
  • firm_id int(10) unsigned
Sample data (0 rows)

branchkey 2

engine: InnoDB
collation: utf8_general_ci
  • branchkey_id int(10) unsigned
  • branchname_int varchar(100)
Sample data (0 rows)

branchkey 2

engine: InnoDB
collation: utf8_general_ci
  • branchkey_id int(10) unsigned
  • branchname_int varchar(100)
Sample data (0 rows)

catalog 9

engine: InnoDB
collation: utf8_general_ci
  • catalog_id int(20)
  • firm_id int(20)
  • region_id int(10)
  • country_id int(10)
  • catalogpath varchar(20)
  • userlock int(2)
  • adminlocked int(2)
  • date date
  • releasedate date
Sample data (0 rows)

catalog 9

engine: InnoDB
collation: utf8_general_ci
  • catalog_id int(20)
  • firm_id int(20)
  • region_id int(10)
  • country_id int(10)
  • catalogpath varchar(20)
  • userlock int(2)
  • adminlocked int(2)
  • date date
  • releasedate date
Sample data (0 rows)

countries 29

engine: InnoDB
collation: utf8_general_ci
  • country_id int(10) unsigned
  • iso_country varchar(2)
  • countryname_local varchar(50)
  • countryname_en varchar(50)
  • baseprice4 float
  • baseprice8 float
  • exchange float
  • exchangedate date
  • currency varchar(10)
  • bankname varchar(50)
  • kto varchar(20)
  • blz varchar(20)
  • iban varchar(34)
  • swift varchar(11)
  • ktoname varchar(50)
  • ktostr varchar(30)
  • ktozusatz varchar(100)
  • ktoplz varchar(10)
  • ktoort varchar(30)
  • ktotel varchar(30)
  • ktofax varchar(30)
  • ktoweb varchar(50)
  • ktomail varchar(50)
  • taxno varchar(20)
  • taxid varchar(20)
  • hreg varchar(20)
  • domain varchar(255)
  • tax float(5,3)
  • steuername varchar(50)
Sample data (0 rows)

countries 29

engine: InnoDB
collation: utf8_general_ci
  • country_id int(10) unsigned
  • iso_country varchar(2)
  • countryname_local varchar(50)
  • countryname_en varchar(50)
  • baseprice4 float
  • baseprice8 float
  • exchange float
  • exchangedate date
  • currency varchar(10)
  • bankname varchar(50)
  • kto varchar(20)
  • blz varchar(20)
  • iban varchar(34)
  • swift varchar(11)
  • ktoname varchar(50)
  • ktostr varchar(30)
  • ktozusatz varchar(100)
  • ktoplz varchar(10)
  • ktoort varchar(30)
  • ktotel varchar(30)
  • ktofax varchar(30)
  • ktoweb varchar(50)
  • ktomail varchar(50)
  • taxno varchar(20)
  • taxid varchar(20)
  • hreg varchar(20)
  • domain varchar(255)
  • tax float(5,3)
  • steuername varchar(50)
Sample data (0 rows)

divisions 3

engine: InnoDB
collation: utf8_general_ci
  • division_id int(10) unsigned
  • description varchar(255)
  • firm_id int(20)
Sample data (0 rows)

divisions 3

engine: InnoDB
collation: utf8_general_ci
  • division_id int(10) unsigned
  • description varchar(255)
  • firm_id int(20)
Sample data (0 rows)

firm 52

engine: InnoDB
collation: utf8_general_ci
  • firm_id int(10) unsigned
  • cid varchar(38)
  • lang_id int(10) unsigned
  • country_id int(10) unsigned
  • division_id int(10) unsigned
  • region_id int(10) unsigned
  • partner_id int(11) unsigned
  • actioncode varchar(20)
  • greeting varchar(10)
  • firstname varchar(30)
  • lastname varchar(30)
  • customernumber varchar(20)
  • passwd varchar(32)
  • firmname varchar(255)
  • firmnamealias varchar(200)
  • founded varchar(20)
  • employees varchar(20)
  • turnover varchar(20)
  • certificates varchar(255)
  • international int(10) unsigned
  • payment int(10) unsigned
  • zipcode varchar(10)
  • town varchar(30)
  • adrext varchar(255)
  • street varchar(50)
  • postbox varchar(30)
  • phone1 varchar(30)
  • phone2 varchar(30)
  • phone3 varchar(30)
  • mobilephone varchar(30)
  • mailadmin varchar(50)
  • mailcontact varchar(50)
  • fax varchar(30)
  • web varchar(50)
  • vat varchar(20)
  • catalog varchar(20)
  • pict varchar(255)
  • viewCount int(11) unsigned
  • viewcountweb int(11)
  • maxbranchescount int(10) unsigned
  • yearFeeEuro decimal(5,2) unsigned
  • notice text
  • access int(10) unsigned
  • status int(10) unsigned
  • created datetime
  • paid date
  • paystop int(10) unsigned
  • logincount int(10)
  • lastlogin datetime
  • kw_chkd int(2)
  • ind_chkd int(2)
  • edt_pro_chkd int(2)
Sample data (0 rows)

firm 54

engine: InnoDB
collation: utf8_general_ci
  • firm_id int(10) unsigned
  • cid varchar(38)
  • lang_id int(10) unsigned
  • country_id int(10) unsigned
  • division_id int(10) unsigned
  • region_id int(10) unsigned
  • berater_id int(11) unsigned
  • actioncode varchar(20)
  • greeting varchar(10)
  • firstname varchar(30)
  • lastname varchar(30)
  • customernumber varchar(20)
  • passwd varchar(32)
  • firmname varchar(255)
  • firmnamealias varchar(200)
  • founded varchar(20)
  • employees varchar(20)
  • turnover varchar(20)
  • certificates varchar(255)
  • international int(10) unsigned
  • payment int(10) unsigned
  • zipcode varchar(10)
  • town varchar(30)
  • adrext varchar(255)
  • street varchar(50)
  • postbox varchar(30)
  • phone1 varchar(30)
  • phone2 varchar(30)
  • phone3 varchar(30)
  • mobilephone varchar(30)
  • mailadmin varchar(50)
  • mailcontact varchar(50)
  • fax varchar(30)
  • web varchar(50)
  • vat varchar(20)
  • catalog varchar(20)
  • pict varchar(255)
  • viewCount int(11) unsigned
  • viewcountweb int(11)
  • maxbranchescount int(10) unsigned
  • yearFeeEuro decimal(5,2) unsigned
  • notice text
  • access int(10) unsigned
  • status int(10) unsigned
  • created datetime
  • paid date
  • paystop int(10) unsigned
  • logincount int(10)
  • lastlogin datetime
  • kw_chkd int(2)
  • ind_chkd int(2)
  • edt_pro_chkd int(2)
  • date_chkd date
  • state_chkd int(2)
Sample data (0 rows)

firmdescription 6

engine: InnoDB
collation: utf8_general_ci
  • firmdescription_id int(10) unsigned
  • firm_id int(10) unsigned
  • keywords_local text
  • keywords_en text
  • description_local text
  • description_en text
Sample data (0 rows)

firmdescription 6

engine: InnoDB
collation: utf8_general_ci
  • firmdescription_id int(10) unsigned
  • firm_id int(10) unsigned
  • keywords_local text
  • keywords_en text
  • description_local text
  • description_en text
Sample data (0 rows)

groupkey 3

engine: InnoDB
collation: utf8_general_ci
  • groupkey_id int(10) unsigned
  • name_int varchar(255)
  • locked int(10) unsigned
Sample data (0 rows)

groupkey 3

engine: InnoDB
collation: utf8_general_ci
  • groupkey_id int(10) unsigned
  • name_int varchar(255)
  • locked int(10) unsigned
Sample data (0 rows)

groups 6

engine: InnoDB
collation: utf8_general_ci
  • group_id int(10) unsigned
  • groupkey_id int(10) unsigned
  • country_id int(10) unsigned
  • lang_id int(10) unsigned
  • name_nat varchar(255)
  • locked int(10) unsigned
Sample data (0 rows)

groups 6

engine: InnoDB
collation: utf8_general_ci
  • group_id int(10) unsigned
  • groupkey_id int(10) unsigned
  • country_id int(10) unsigned
  • lang_id int(10) unsigned
  • name_nat varchar(255)
  • locked int(10) unsigned
Sample data (0 rows)

lang 3

engine: InnoDB
collation: utf8_general_ci
  • lang_id int(10) unsigned
  • language_id int(10) unsigned
  • country_id int(10) unsigned
Sample data (0 rows)

lang 3

engine: InnoDB
collation: utf8_general_ci
  • lang_id int(10) unsigned
  • language_id int(10) unsigned
  • country_id int(10) unsigned
Sample data (0 rows)

languages 4

engine: InnoDB
collation: utf8_general_ci
  • language_id int(10) unsigned
  • iso_lang varchar(2)
  • langname_local varchar(50)
  • langname_en varchar(50)
Sample data (0 rows)

languages 4

engine: InnoDB
collation: utf8_general_ci
  • language_id int(10) unsigned
  • iso_lang varchar(2)
  • langname_local varchar(50)
  • langname_en varchar(50)
Sample data (0 rows)

offers 26

engine: InnoDB
collation: utf8_general_ci
  • offer_id int(10) unsigned
  • firm_id int(10) unsigned
  • region_id int(5)
  • country_id int(5)
  • title varchar(255)
  • titlealias varchar(255)
  • title_int varchar(255)
  • title_intalias varchar(255)
  • description text
  • description_int text
  • subgroupkey_id int(10) unsigned
  • groupkey_id int(10)
  • pict varchar(255)
  • section char(1)
  • national int(2)
  • international int(10) unsigned
  • userlocked int(10) unsigned
  • adminlocked int(10) unsigned
  • created datetime
  • changed datetime
  • status int(10) unsigned
  • countfound int(10) unsigned
  • countviewed int(10) unsigned
  • admintxt text
  • del int(10) unsigned
  • deldate datetime
Sample data (0 rows)

offers 26

engine: InnoDB
collation: utf8_general_ci
  • offer_id int(10) unsigned
  • firm_id int(10) unsigned
  • region_id int(5)
  • country_id int(5)
  • title varchar(255)
  • titlealias varchar(255)
  • title_int varchar(255)
  • title_intalias varchar(255)
  • description text
  • description_int text
  • subgroupkey_id int(10) unsigned
  • groupkey_id int(10)
  • pict varchar(255)
  • section char(1)
  • national int(2)
  • international int(10) unsigned
  • userlocked int(10) unsigned
  • adminlocked int(10) unsigned
  • created datetime
  • changed datetime
  • status int(10) unsigned
  • countfound int(10) unsigned
  • countviewed int(10) unsigned
  • admintxt text
  • del int(10) unsigned
  • deldate datetime
Sample data (0 rows)

rechnung 7

engine: MyISAM
collation: utf8_general_ci
  • rechn_id int(10) unsigned
  • country_id int(11)
  • name varchar(20)
  • nr int(11)
  • created timestamp
  • firm_id int(10)
  • url varchar(250)
Sample data (0 rows)

rechnung 7

engine: MyISAM
collation: utf8_general_ci
  • rechn_id int(10) unsigned
  • country_id int(11)
  • name varchar(20)
  • nr int(11)
  • created timestamp
  • firm_id int(10)
  • url varchar(250)
Sample data (0 rows)

rechnung_bez 8

engine: InnoDB
collation: utf8_general_ci
  • id int(10)
  • cnr varchar(15)
  • cnr_bez varchar(15)
  • country_id int(10)
  • datum datetime
  • rech_betrag varchar(15)
  • rech_nr varchar(20)
  • status int(11)
Sample data (0 rows)

rechnung_bez 8

engine: InnoDB
collation: utf8_general_ci
  • id int(10)
  • cnr varchar(15)
  • cnr_bez varchar(15)
  • country_id int(10)
  • datum datetime
  • rech_betrag varchar(15)
  • rech_nr varchar(20)
  • status int(11)
Sample data (0 rows)

regions 6

engine: InnoDB
collation: utf8_general_ci
  • region_id int(10) unsigned
  • country_id int(10) unsigned
  • name_local varchar(100)
  • symbol varchar(10)
  • tax float(5,3)
  • steuername varchar(50)
Sample data (0 rows)

regions 6

engine: InnoDB
collation: utf8_general_ci
  • region_id int(10) unsigned
  • country_id int(10) unsigned
  • name_local varchar(100)
  • symbol varchar(10)
  • tax float(5,3)
  • steuername varchar(50)
Sample data (0 rows)

statisticip 4

engine: MyISAM
collation: utf8_general_ci
  • statip_id int(11)
  • ip varchar(15)
  • firmid int(11)
  • last int(11)
Sample data (0 rows)

statisticip 4

engine: MyISAM
collation: utf8_general_ci
  • statip_id int(11)
  • ip varchar(15)
  • firmid int(11)
  • last int(11)
Sample data (0 rows)

statistics 4

engine: MyISAM
collation: utf8_general_ci
  • stat_id int(11)
  • country_id int(11)
  • count int(11)
  • date date
Sample data (0 rows)

statistics 4

engine: MyISAM
collation: utf8_general_ci
  • stat_id int(11)
  • country_id int(11)
  • count int(11)
  • date date
Sample data (0 rows)

subgroupkey 4

engine: InnoDB
collation: utf8_general_ci
  • subgroupkey_id int(10) unsigned
  • groupkey_id int(10) unsigned
  • name_int varchar(255)
  • locked int(10) unsigned
Sample data (0 rows)

subgroupkey 4

engine: InnoDB
collation: utf8_general_ci
  • subgroupkey_id int(10) unsigned
  • groupkey_id int(10) unsigned
  • name_int varchar(255)
  • locked int(10) unsigned
Sample data (0 rows)

subgroups 6

engine: InnoDB
collation: utf8_general_ci
  • subgroup_id int(10) unsigned
  • subgroupkey_id int(10) unsigned
  • country_id int(10) unsigned
  • lang_id int(10) unsigned
  • name_nat varchar(255)
  • locked int(10) unsigned
Sample data (0 rows)

subgroups 6

engine: InnoDB
collation: utf8_general_ci
  • subgroup_id int(10) unsigned
  • subgroupkey_id int(10) unsigned
  • country_id int(10) unsigned
  • lang_id int(10) unsigned
  • name_nat varchar(255)
  • locked int(10) unsigned
Sample data (0 rows)

test 5

engine: MyISAM
collation: utf8_general_ci
  • id bigint(12)
  • suchtext varchar(50)
  • date timestamp
  • ipadresse varchar(15)
  • country int(11)
Sample data (0 rows)

test 5

engine: MyISAM
collation: utf8_general_ci
  • id bigint(12)
  • suchtext varchar(50)
  • date timestamp
  • ipadresse varchar(15)
  • country int(11)
Sample data (0 rows)

userlog 5

engine: InnoDB
collation: utf8_general_ci
  • userlog_id int(10) unsigned
  • sourceuser varchar(20)
  • targetuser varchar(20)
  • time timestamp
  • action varchar(255)
Sample data (0 rows)

userlog 5

engine: InnoDB
collation: utf8_general_ci
  • userlog_id int(10) unsigned
  • sourceuser varchar(20)
  • targetuser varchar(20)
  • time timestamp
  • action varchar(255)
Sample data (0 rows)

viewcount 3

engine: MyISAM
collation: utf8_general_ci
  • counter_id int(11)
  • country_id int(11)
  • counter int(11)
Sample data (0 rows)

viewcount 3

engine: MyISAM
collation: utf8_general_ci
  • counter_id int(11)
  • country_id int(11)
  • counter int(11)
Sample data (0 rows)

viewcountip 3

engine: MyISAM
collation: utf8_general_ci
  • counterip_id int(11)
  • ip varchar(15)
  • last int(11)
Sample data (0 rows)

viewcountip 3

engine: MyISAM
collation: utf8_general_ci
  • counterip_id int(11)
  • ip varchar(15)
  • last int(11)
Sample data (0 rows)