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 [PRIMARY] 1

  • actioncode_id (1)

actioncodes [PRIMARY] 1

  • actioncode_id (1)

actioncodes [actioncode] 1

  • actioncode (1)

actioncodes [actioncode] 1

  • actioncode (1)

actioncodes [country_id] 1

  • country_id (1)

actioncodes [country_id] 1

  • country_id (1)

adminuser [PRIMARY] 1

  • adminuser_id (1)

adminuser [PRIMARY] 1

  • adminuser_id (1)

adminuser [country_id] 1

  • country_id (1)

adminuser [country_id] 1

  • country_id (1)

anrede [PRIMARY] 1

  • id (1)

anrede [PRIMARY] 1

  • id (1)

berater [PRIMARY] 1

  • berater_id (1)

berater [PRIMARY] 1

  • berater_id (1)

branches [PRIMARY] 1

  • branch_id (1)

branches [PRIMARY] 1

  • branch_id (1)

branches [branchkey_id] 1

  • branchkey_id (1)

branches [branchkey_id] 1

  • branchkey_id (1)

branches [country_id] 1

  • country_id (1)

branches [country_id] 1

  • country_id (1)

branches [lang_id] 1

  • lang_id (1)

branches [lang_id] 1

  • lang_id (1)

branches [locked] 1

  • locked (1)

branches [locked] 1

  • locked (1)

branchesoffirms [PRIMARY] 1

  • branchesoffirm_id (1)

branchesoffirms [PRIMARY] 1

  • branchesoffirm_id (1)

branchesoffirms [branchesoffirms_ibfk_1] 1

  • firm_id (1)

branchesoffirms [branchesoffirms_ibfk_1] 1

  • firm_id (1)

branchesoffirms [branchkey_id] 1

  • branchkey_id (1)

branchesoffirms [branchkey_id] 1

  • branchkey_id (1)

branchkey [PRIMARY] 1

  • branchkey_id (1)

branchkey [PRIMARY] 1

  • branchkey_id (1)

catalog [PRIMARY] 0

catalog [PRIMARY] 1

  • catalog_id (1)

countries [PRIMARY] 1

  • country_id (1)

countries [PRIMARY] 1

  • country_id (1)

divisions [PRIMARY] 1

  • division_id (1)

divisions [PRIMARY] 1

  • division_id (1)

firm [PRIMARY] 1

  • firm_id (1)

firm [PRIMARY] 1

  • firm_id (1)

firm [access] 1

  • access (1)

firm [access] 1

  • access (1)

firm [country_id] 1

  • country_id (1)

firm [country_id] 1

  • country_id (1)

firm [customernumber] 1

  • customernumber (1)

firm [customernumber] 1

  • customernumber (1)

firm [division_id] 1

  • division_id (1)

firm [division_id] 1

  • division_id (1)

firm [firm_location] 2

  • zipcode (1)
  • town (2)

firm [firm_location] 2

  • zipcode (1)
  • town (2)

firm [international] 1

  • international (1)

firm [international] 1

  • international (1)

firm [lang_id] 1

  • lang_id (1)

firm [lang_id] 1

  • lang_id (1)

firm [region_id] 1

  • region_id (1)

firm [region_id] 1

  • region_id (1)

firmdescription [PRIMARY] 1

  • firmdescription_id (1)

firmdescription [PRIMARY] 1

  • firmdescription_id (1)

firmdescription [firm_id] 1

  • firm_id (1)

firmdescription [firm_id] 1

  • firm_id (1)

groupkey [PRIMARY] 1

  • groupkey_id (1)

groupkey [PRIMARY] 1

  • groupkey_id (1)

groups [PRIMARY] 1

  • group_id (1)

groups [PRIMARY] 1

  • group_id (1)

groups [groupkey_id] 1

  • groupkey_id (1)

groups [groupkey_id] 1

  • groupkey_id (1)

lang [PRIMARY] 1

  • lang_id (1)

lang [PRIMARY] 1

  • lang_id (1)

lang [country_id] 1

  • country_id (1)

lang [country_id] 1

  • country_id (1)

lang [language_id] 1

  • language_id (1)

lang [language_id] 1

  • language_id (1)

languages [PRIMARY] 1

  • language_id (1)

languages [PRIMARY] 1

  • language_id (1)

offers [PRIMARY] 1

  • offer_id (1)

offers [PRIMARY] 1

  • offer_id (1)

offers [adminlocked] 1

  • adminlocked (1)

offers [adminlocked] 1

  • adminlocked (1)

offers [created] 1

  • created (1)

offers [created] 1

  • created (1)

offers [del] 1

  • del (1)

offers [del] 1

  • del (1)

offers [deldate] 1

  • deldate (1)

offers [deldate] 1

  • deldate (1)

offers [international] 1

  • international (1)

offers [international] 1

  • international (1)

offers [offers_firms] 1

  • firm_id (1)

offers [offers_firms] 1

  • firm_id (1)

offers [section] 1

  • section (1)

offers [section] 1

  • section (1)

offers [subgroupkey_id] 1

  • subgroupkey_id (1)

offers [subgroupkey_id] 1

  • subgroupkey_id (1)

offers [userlocked] 1

  • userlocked (1)

offers [userlocked] 1

  • userlocked (1)

rechnung [PRIMARY] 1

  • rechn_id (1)

rechnung [PRIMARY] 1

  • rechn_id (1)

rechnung_bez [PRIMARY] 1

  • id (1)

rechnung_bez [PRIMARY] 1

  • id (1)

regions [PRIMARY] 1

  • region_id (1)

regions [PRIMARY] 1

  • region_id (1)

regions [country_id] 1

  • country_id (1)

regions [country_id] 1

  • country_id (1)

statisticip [PRIMARY] 1

  • statip_id (1)

statisticip [PRIMARY] 1

  • statip_id (1)

statistics [PRIMARY] 1

  • stat_id (1)

statistics [PRIMARY] 1

  • stat_id (1)

subgroupkey [PRIMARY] 1

  • subgroupkey_id (1)

subgroupkey [PRIMARY] 1

  • subgroupkey_id (1)

subgroupkey [groupkey_id] 1

  • groupkey_id (1)

subgroupkey [groupkey_id] 1

  • groupkey_id (1)

subgroups [PRIMARY] 1

  • subgroup_id (1)

subgroups [PRIMARY] 1

  • subgroup_id (1)

subgroups [country_id] 1

  • country_id (1)

subgroups [country_id] 1

  • country_id (1)

subgroups [lang_id] 1

  • lang_id (1)

subgroups [lang_id] 1

  • lang_id (1)

subgroups [subgroupkey_id] 1

  • subgroupkey_id (1)

subgroups [subgroupkey_id] 1

  • subgroupkey_id (1)

test [PRIMARY] 1

  • id (1)

test [PRIMARY] 1

  • id (1)

userlog [PRIMARY] 1

  • userlog_id (1)

userlog [PRIMARY] 1

  • userlog_id (1)

viewcount [PRIMARY] 1

  • counter_id (1)

viewcount [PRIMARY] 1

  • counter_id (1)

viewcountip [PRIMARY] 1

  • counterip_id (1)

viewcountip [PRIMARY] 1

  • counterip_id (1)