Welcome to Schema Evolution Toolsuite
Database: gur_coppermine
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
2007-03-18 |
2009-08-03 |
21 |
22 |
|
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 |
CPG_albums |
1 |
|
0 |
0 |
0 |
0 |
|
CPG_albums |
CPG_banned |
23 |
|
0 |
0 |
0 |
0 |
|
CPG_banned |
CPG_bridge |
9 |
|
0 |
0 |
0 |
0 |
|
CPG_bridge |
CPG_categories |
10 |
|
0 |
0 |
0 |
0 |
|
CPG_categories |
CPG_comments |
21 |
|
0 |
0 |
0 |
0 |
|
CPG_comments |
CPG_config |
13 |
|
0 |
0 |
0 |
0 |
|
CPG_config |
CPG_dict |
4 |
|
0 |
0 |
0 |
0 |
|
CPG_dict |
CPG_ecards |
10 |
|
0 |
0 |
0 |
0 |
|
CPG_ecards |
CPG_exif |
12 |
|
0 |
0 |
0 |
0 |
|
CPG_exif |
CPG_favpics |
4 |
|
0 |
0 |
0 |
0 |
|
CPG_favpics |
CPG_filetypes |
6 |
Details...
Column: mime
-
from: char
to: varchar
|
0 |
0 |
0 |
0 |
|
CPG_filetypes |
CPG_hit_stats |
13 |
|
0 |
0 |
0 |
0 |
|
CPG_hit_stats |
CPG_pictures |
37 |
|
0 |
0 |
0 |
1 |
|
CPG_pictures |
CPG_plugins |
32 |
|
0 |
0 |
0 |
0 |
|
CPG_plugins |
CPG_sessions |
8 |
Details...
Column: session_id
-
from: varchar
to: char
|
0 |
0 |
0 |
0 |
|
CPG_sessions |
CPG_temp_data |
7 |
|
0 |
0 |
0 |
0 |
|
CPG_temp_data |
CPG_temp_messages |
7 |
|
0 |
0 |
0 |
0 |
|
CPG_temp_messages |
CPG_usergroups |
24 |
|
0 |
0 |
0 |
0 |
|
CPG_usergroups |
CPG_users |
29 |
|
0 |
0 |
0 |
0 |
|
CPG_users |
CPG_votes |
20 |
|
0 |
0 |
0 |
0 |
|
CPG_votes |
CPG_vote_stats |
12 |
|
0 |
0 |
0 |
0 |
|
CPG_vote_stats |
CPG_categorymap |
11 |
|
0 |
0 |
0 |
0 |
|
CPG_categorymap |
CPG_languages |
11 |
|
0 |
0 |
0 |
0 |
|
CPG_languages |