icon

Welcome to Schema Evolution Toolsuite

Database: ham_dekiwiki

Here a description of the program and the functions provided, a brief explanation and escription of the different sections like in the prism layout

  • Table name: contains the name of the table
  • Column count evolution:report the evolution in terms of number of columns of the table; the columns are calculated as difference between the number of columns in the first and in the last revision
  • Columns data tyep changes: report the number of changes in the data type of each column; show the name of the column that changed type and the evolution of the type
  • Primary key changes: count the number of times the primary key of the table changed, in terms of columns added or deleted
  • Number roll back: number of roll back undergone by the table
Db first release 2007-07-23
Db latest release 2009-03-23
Db initial size 28
Db end size 35
Db evolution rate
8%
 
 
Table Name Colomns evolution Colomns data type changes Number of roll back Primary key changes Foreign key changes Index changes Table evolution rate Table Name
archive 4 0 0 0 0
2%
 
 
archive
attachments 31 0 0 0 0
16%
 
 
attachments
banips 18 0 0 0 0
9%
 
 
banips
bans 9 0 0 0 0
4%
 
 
bans
banusers 9 0 0 0 0
4%
 
 
banusers
brokenlinks 5 0 0 0 0
2%
 
 
brokenlinks
comments 14 0 0 0 0
7%
 
 
comments
config 15 0 0 0 0
8%
 
 
config
groups 9 0 0 0 0
4%
 
 
groups
group_grants 11 0 0 0 0
6%
 
 
group_grants
links 9 0 0 0 0
4%
 
 
links
linkscc 4 0 0 0 0
2%
 
 
linkscc
objectcache 5 0 0 0 0
2%
 
 
objectcache
old 17 0 0 0 0
8%
 
 
old
pages 37 0 0 0 0
18%
 
 
pages
querycache 27 0 0 0 0
14%
 
 
querycache
recentchanges 24 0 0 0 0
12%
 
 
recentchanges
requestlog 34 0 0 0 0
17%
 
 
requestlog
requeststats 24 0 0 0 0
12%
 
 
requeststats
restrictions 15 0 0 0 0
8%
 
 
restrictions
roles 12 0 0 0 0
6%
 
 
roles
services 14 0 0 0 0
7%
 
 
services
service_config 11 0 0 0 0
6%
 
 
service_config
service_prefs 6 0 0 0 0
3%
 
 
service_prefs
site_stats 11 0 0 0 0
6%
 
 
site_stats
tags 10 0 0 0 0
5%
 
 
tags
tag_map 6 0 0 0 0
3%
 
 
tag_map
transactions 14 0 0 0 0
7%
 
 
transactions
users 25 0 0 0 0
12%
 
 
users
user_grants 25 0 0 0 0
12%
 
 
user_grants
user_groups 6 0 0 0 0
3%
 
 
user_groups
user_registrations 12 0 0 0 0
6%
 
 
user_registrations
watchlist 12 0 0 0 0
6%
 
 
watchlist
resourcecontents 0 0 0 0 0
0%
 
 
resourcecontents
resourcefilemap 0 0 0 0 0
0%
 
 
resourcefilemap
resourcerevs 0 0 0 0 0
0%
 
 
resourcerevs
resources 0 0 0 0 0
0%
 
 
resources
logging 113 0 0 0 0
57%
 
 
logging