Statistics Generator

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	2003-10-03
Db latest release	2007-11-05
Db initial size	9
Db end size	19
Db evolution rate	10%

Table Name	Colomns evolution	Colomns data type changes	Index changes	Table evolution rate	Table Name
be_groups	4	Details... Column: TSconfig from: blob to: text Column: allowed_languages from: tinyblob to: varchar Column: tables_select from: blob to: text Column: custom_options from: blob to: text Column: tables_modify from: blob to: text Column: non_exclude_fields from: blob to: text Column: explicit_allowdeny from: blob to: text Column: groupMods from: tinyblob to: text Column: pagetypes_select from: tinyblob to: varchar Column: subgroup from: tinyblob to: varchar	0	4%	be_groups
be_sessions	33	Details... Column: ses_data from: blob to: longtext	0	17%	be_sessions
be_users	40	Details... Column: usergroup_cached_list from: tinytext to: varchar Column: uc from: blob to: text Column: usergroup from: tinyblob to: varchar Column: TSconfig from: blob to: text Column: lang from: char to: varchar Column: allowed_languages from: tinyblob to: varchar Column: userMods from: tinyblob to: varchar	0	21%	be_users
cache_hash	34	Details... Column: content from: mediumblob to: mediumtext	0	17%	cache_hash
sys_be_shortcuts	11	Details... Column: description from: tinytext to: varchar Column: module_name from: tinytext to: varchar	0	6%	sys_be_shortcuts
sys_filemounts	13		0	6%	sys_filemounts
sys_history	13	Details... Column: history_data from: mediumblob to: mediumtext Column: fieldlist from: blob to: text Column: history_files from: mediumblob to: mediumtext	1	9%	sys_history
sys_lockedrecords	12		0	6%	sys_lockedrecords
sys_log	17	Details... Column: log_data from: tinyblob to: varchar Column: details from: tinytext to: varchar	0	9%	sys_log
cache_imagesizes	20	Details... Column: filename from: tinytext to: varchar	0	10%	cache_imagesizes
pages	35	Details... Column: TSconfig from: blob to: text Column: title from: tinytext to: varchar	2	22%	pages
sys_language	30		0	15%	sys_language
sys_preview	9		0	4%	sys_preview
sys_refindex	16	Details... Column: deleted from: int to: tinyint Column: flexpointer from: tinytext to: varchar	0	8%	sys_refindex
sys_workspace	31	Details... Column: file_mountpoints from: tinytext to: varchar Column: adminusers from: tinytext to: varchar Column: description from: tinytext to: varchar Column: db_mountpoints from: tinytext to: varchar	0	16%	sys_workspace
sys_refindex_rel	23		0	12%	sys_refindex_rel
sys_refindex_res	3		0	2%	sys_refindex_res
sys_refindex_words	5		0	2%	sys_refindex_words
cache_extensions	22		0	11%	cache_extensions

Welcome to Schema Evolution Toolsuite

Database: gur_typo3