icon

Welcome to Schema Evolution Toolsuite

Database: ham_slashcode2

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 2000-08-29
Db latest release 2008-01-07
Db initial size 0
Db end size 85
Db evolution rate
11%
 
 
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
abusers 4 Details...hide/show 0 0 0 0
2%
 
 
abusers
accesslist 32 Details...hide/show 0 0 0 0
16%
 
 
accesslist
accesslog 35 Details...hide/show 0 0 0 1
20%
 
 
accesslog
authors_cache 22 0 0 0 0
11%
 
 
authors_cache
backup_blocks 9 0 0 0 0
4%
 
 
backup_blocks
blocks 22 Details...hide/show 0 0 0 0
12%
 
 
blocks
code_param 20 Details...hide/show 0 0 0 0
10%
 
 
code_param
commentmodes 5 0 0 0 0
2%
 
 
commentmodes
comments 48 Details...hide/show 4 1 0 0
68%
 
 
comments
comment_text 23 Details...hide/show 0 0 0 0
12%
 
 
comment_text
content_filters 15 Details...hide/show 0 0 0 0
8%
 
 
content_filters
discussions 28 0 0 0 0
14%
 
 
discussions
formkeys 27 Details...hide/show 0 0 0 0
14%
 
 
formkeys
menus 16 Details...hide/show 0 0 0 0
9%
 
 
menus
metamodlog 14 Details...hide/show 0 0 0 0
8%
 
 
metamodlog
misc_user_opts 14 0 0 0 0
7%
 
 
misc_user_opts
moderatorlog 36 Details...hide/show 4 0 0 0
52%
 
 
moderatorlog
pollanswers 20 Details...hide/show 0 0 0 0
11%
 
 
pollanswers
pollquestions 17 Details...hide/show 0 0 0 0
9%
 
 
pollquestions
pollvoters 11 Details...hide/show 0 0 0 0
6%
 
 
pollvoters
related_links 6 0 0 0 0
3%
 
 
related_links
sections 29 Details...hide/show 0 0 0 0
16%
 
 
sections
section_extras 24 0 0 0 0
12%
 
 
section_extras
section_topics 6 Details...hide/show 0 1 0 0
13%
 
 
section_topics
sessions 12 Details...hide/show 0 0 0 0
7%
 
 
sessions
site_info 11 Details...hide/show 0 0 0 0
6%
 
 
site_info
spamarmors 6 0 0 0 0
3%
 
 
spamarmors
stories 45 Details...hide/show 0 0 0 0
24%
 
 
stories
story_param 23 Details...hide/show 0 0 0 0
12%
 
 
story_param
story_text 12 0 0 0 0
6%
 
 
story_text
submissions 26 Details...hide/show 0 0 0 1
16%
 
 
submissions
templates 28 Details...hide/show 0 0 0 0
14%
 
 
templates
topics 34 Details...hide/show 0 0 0 0
18%
 
 
topics
tzcodes 16 Details...hide/show 0 0 0 0
8%
 
 
tzcodes
users 18 Details...hide/show 0 0 0 0
9%
 
 
users
users_acl 17 0 0 0 0
8%
 
 
users_acl
users_comments 20 Details...hide/show 0 0 0 0
13%
 
 
users_comments
users_count 16 0 0 0 0
8%
 
 
users_count
users_hits 2 0 0 0 0
1%
 
 
users_hits
users_index 39 Details...hide/show 4 0 0 0
53%
 
 
users_index
users_info 143 Details...hide/show 6 0 0 0
124%
 
 
users_info
users_param 27 Details...hide/show 0 0 0 0
14%
 
 
users_param
users_prefs 10 Details...hide/show 0 0 0 0
5%
 
 
users_prefs
vars 11 0 0 0 0
6%
 
 
vars
accesslog_admin 18 Details...hide/show 0 0 0 0
9%
 
 
accesslog_admin
classes 15 0 0 0 0
8%
 
 
classes
dbs 8 0 0 0 0
4%
 
 
dbs
dst 16 0 0 0 0
8%
 
 
dst
hooks 14 0 0 0 0
7%
 
 
hooks
modreasons 10 0 0 0 0
5%
 
 
modreasons
rss_raw 17 Details...hide/show 0 0 0 0
9%
 
 
rss_raw
sections_contained 12 Details...hide/show 0 0 0 0
6%
 
 
sections_contained
section_subsections 3 0 0 0 0
2%
 
 
section_subsections
slashd_status 12 0 0 0 0
6%
 
 
slashd_status
story_topics 10 0 0 0 0
5%
 
 
story_topics
string_param 8 0 0 0 0
4%
 
 
string_param
submission_param 4 Details...hide/show 0 0 0 0
2%
 
 
submission_param
topic_images 7 0 0 0 0
4%
 
 
topic_images
topic_image_sections 8 0 0 0 0
4%
 
 
topic_image_sections
soap_methods 9 0 0 0 0
4%
 
 
soap_methods
subsections 10 0 0 0 1
7%
 
 
subsections
badpasswords 10 0 0 0 0
5%
 
 
badpasswords
users_logtokens 11 Details...hide/show 0 0 0 0
6%
 
 
users_logtokens
accesslog_artcom 8 0 0 0 0
4%
 
 
accesslog_artcom
slashd_errnotes 6 0 0 0 0
3%
 
 
slashd_errnotes
open_proxies 9 0 0 0 0
4%
 
 
open_proxies
skins 40 6 0 0 0
69%
 
 
skins
skin_colors 21 0 0 0 0
10%
 
 
skin_colors
story_dirty 4 0 0 0 0
2%
 
 
story_dirty
story_topics_chosen 2 0 0 0 0
1%
 
 
story_topics_chosen
story_topics_rendered 1 0 0 0 0
0%
 
 
story_topics_rendered
topic_nexus 2 0 0 0 0
1%
 
 
topic_nexus
topic_nexus_dirty 1 0 0 0 0
0%
 
 
topic_nexus_dirty
topic_nexus_extras 7 0 0 0 0
4%
 
 
topic_nexus_extras
topic_parents 9 0 0 0 0
4%
 
 
topic_parents
topic_param 5 0 0 0 0
2%
 
 
topic_param
story_render_dirty 5 0 0 0 0
2%
 
 
story_render_dirty
remarks 10 6 0 0 0
54%
 
 
remarks
dbs_readerstatus 17 0 0 0 0
8%
 
 
dbs_readerstatus
dbs_readerstatus_queries 12 0 0 0 0
6%
 
 
dbs_readerstatus_queries
al2 5 0 0 0 0
2%
 
 
al2
al2_log 7 0 0 0 0
4%
 
 
al2_log
al2_log_comments 6 0 0 0 0
3%
 
 
al2_log_comments
al2_types 6 0 0 0 0
3%
 
 
al2_types
css 18 0 0 0 0
9%
 
 
css
css_type 13 0 0 0 0
6%
 
 
css_type
newstories 20 0 0 0 0
10%
 
 
newstories
storiestuff 15 0 0 0 0
8%
 
 
storiestuff
discussion_kinds 4 0 0 0 0
2%
 
 
discussion_kinds
signoff 7 0 0 0 0
4%
 
 
signoff
globjs 8 0 0 0 0
4%
 
 
globjs
globj_types 3 0 0 0 0
2%
 
 
globj_types
related_stories 11 Details...hide/show 0 0 0 0
6%
 
 
related_stories
urls 23 0 0 0 0
12%
 
 
urls
globj_urls 17 0 0 0 0
8%
 
 
globj_urls
globj_adminnotes 3 0 0 0 0
2%
 
 
globj_adminnotes
comment_log 6 0 0 0 0
3%
 
 
comment_log
clout_types 7 0 0 0 0
4%
 
 
clout_types
users_clout 5 0 0 0 0
2%
 
 
users_clout
file_queue 10 0 0 0 0
5%
 
 
file_queue
story_static_files 11 0 0 0 0
6%
 
 
story_static_files
categories 0 0 0 0 0
0%
 
 
categories
story_files 9 0 0 0 0
4%
 
 
story_files