icon

Welcome to Schema Evolution Toolsuite

Database: ham_tikiwiki

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 2008-07-10
Db latest release 2009-06-05
Db initial size 215
Db end size 0
Db evolution rate
7%
 
 
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
galaxia_activities 0 0 0 0 0
0%
 
 
galaxia_activities
galaxia_activity_roles 11 0 0 0 0
6%
 
 
galaxia_activity_roles
galaxia_instances 12 0 0 0 0
6%
 
 
galaxia_instances
galaxia_instance_activities 8 0 0 0 0
4%
 
 
galaxia_instance_activities
galaxia_instance_comments 9 0 0 0 0
4%
 
 
galaxia_instance_comments
galaxia_processes 17 0 0 0 0
8%
 
 
galaxia_processes
galaxia_roles 5 0 0 0 0
2%
 
 
galaxia_roles
galaxia_transitions 6 0 0 0 0
3%
 
 
galaxia_transitions
galaxia_user_roles 4 0 0 0 0
2%
 
 
galaxia_user_roles
galaxia_workitems 9 0 0 0 0
4%
 
 
galaxia_workitems
messu_archive 21 0 0 0 0
10%
 
 
messu_archive
messu_messages 0 0 0 0 0
0%
 
 
messu_messages
messu_sent 0 0 0 0 0
0%
 
 
messu_sent
sessions 19 0 0 0 0
10%
 
 
sessions
tiki_actionlog 13 0 0 0 0
6%
 
 
tiki_actionlog
tiki_actionlog_conf 9 0 0 0 0
4%
 
 
tiki_actionlog_conf
tiki_actionlog_params 7 0 0 0 0
4%
 
 
tiki_actionlog_params
tiki_articles 35 0 0 0 0
18%
 
 
tiki_articles
tiki_article_types 50 0 0 0 0
25%
 
 
tiki_article_types
tiki_banners 51 0 0 0 0
26%
 
 
tiki_banners
tiki_banning 40 0 0 0 0
20%
 
 
tiki_banning
tiki_banning_sections 13 0 0 0 0
6%
 
 
tiki_banning_sections
tiki_blogs 20 0 0 0 0
10%
 
 
tiki_blogs
tiki_blog_activity 17 0 0 0 0
8%
 
 
tiki_blog_activity
tiki_blog_posts 11 0 0 0 0
6%
 
 
tiki_blog_posts
tiki_blog_posts_images 12 0 0 0 0
6%
 
 
tiki_blog_posts_images
tiki_calendars 20 0 0 0 0
10%
 
 
tiki_calendars
tiki_calendar_categories 13 0 0 0 0
6%
 
 
tiki_calendar_categories
tiki_calendar_items 16 0 0 0 0
8%
 
 
tiki_calendar_items
tiki_calendar_locations 15 0 0 0 0
8%
 
 
tiki_calendar_locations
tiki_calendar_options 5 0 0 0 0
2%
 
 
tiki_calendar_options
tiki_calendar_roles 6 0 0 0 0
3%
 
 
tiki_calendar_roles
tiki_categories 8 0 0 0 0
4%
 
 
tiki_categories
tiki_categorized_objects 6 0 0 0 0
3%
 
 
tiki_categorized_objects
tiki_category_objects 1 0 0 0 0
0%
 
 
tiki_category_objects
tiki_category_sites 2 0 0 0 0
1%
 
 
tiki_category_sites
tiki_charts 20 0 0 0 0
10%
 
 
tiki_charts
tiki_charts_rankings 24 0 0 0 0
12%
 
 
tiki_charts_rankings
tiki_charts_votes 6 0 0 0 0
3%
 
 
tiki_charts_votes
tiki_chart_items 9 0 0 0 0
4%
 
 
tiki_chart_items
tiki_chat_channels 15 0 0 0 0
8%
 
 
tiki_chat_channels
tiki_chat_messages 11 0 0 0 0
6%
 
 
tiki_chat_messages
tiki_chat_users 4 0 0 0 0
2%
 
 
tiki_chat_users
tiki_comments 26 0 0 0 0
13%
 
 
tiki_comments
tiki_content 26 0 0 0 0
13%
 
 
tiki_content
tiki_content_templates 7 0 0 0 0
4%
 
 
tiki_content_templates
tiki_content_templates_sections 4 0 0 0 0
2%
 
 
tiki_content_templates_sections
tiki_contributions 5 0 0 0 0
2%
 
 
tiki_contributions
tiki_contributions_assigned 3 0 0 0 0
2%
 
 
tiki_contributions_assigned
tiki_cookies 4 0 0 0 0
2%
 
 
tiki_cookies
tiki_copyrights 9 0 0 0 0
4%
 
 
tiki_copyrights
tiki_directory_categories 18 0 0 0 0
9%
 
 
tiki_directory_categories
tiki_directory_search 11 0 0 0 0
6%
 
 
tiki_directory_search
tiki_directory_sites 11 0 0 0 0
6%
 
 
tiki_directory_sites
tiki_download 17 0 0 0 0
8%
 
 
tiki_download
tiki_drawings 13 0 0 0 0
6%
 
 
tiki_drawings
tiki_dsn 8 0 0 0 0
4%
 
 
tiki_dsn
tiki_dynamic_variables 3 0 0 0 0
2%
 
 
tiki_dynamic_variables
tiki_events 8 0 0 0 0
4%
 
 
tiki_events
tiki_extwiki 9 0 0 0 0
4%
 
 
tiki_extwiki
tiki_faqs 10 0 0 0 0
5%
 
 
tiki_faqs
tiki_faq_questions 10 0 0 0 0
5%
 
 
tiki_faq_questions
tiki_featured_links 9 0 0 0 0
4%
 
 
tiki_featured_links
tiki_files 26 0 0 0 1
15%
 
 
tiki_files
tiki_file_galleries 45 0 0 0 0
22%
 
 
tiki_file_galleries
tiki_file_handlers 39 0 0 0 0
20%
 
 
tiki_file_handlers
tiki_forums 59 0 0 0 0
30%
 
 
tiki_forums
tiki_forums_queue 71 0 0 0 0
36%
 
 
tiki_forums_queue
tiki_forums_reported 14 0 0 0 0
7%
 
 
tiki_forums_reported
tiki_forum_attachments 13 0 0 0 0
6%
 
 
tiki_forum_attachments
tiki_forum_reads 11 0 0 0 0
6%
 
 
tiki_forum_reads
tiki_freetagged_objects 6 0 0 0 0
3%
 
 
tiki_freetagged_objects
tiki_freetags 6 0 0 0 0
3%
 
 
tiki_freetags
tiki_friends 6 0 0 0 0
3%
 
 
tiki_friends
tiki_friendship_requests 5 0 0 0 0
2%
 
 
tiki_friendship_requests
tiki_galleries 33 0 0 0 0
16%
 
 
tiki_galleries
tiki_galleries_scales 30 0 0 0 0
15%
 
 
tiki_galleries_scales
tiki_games 6 0 0 0 0
3%
 
 
tiki_games
tiki_group_inclusion 6 0 0 0 0
3%
 
 
tiki_group_inclusion
tiki_history 14 0 0 0 0
7%
 
 
tiki_history
tiki_hotwords 14 0 0 0 0
7%
 
 
tiki_hotwords
tiki_html_pages 7 0 0 0 0
4%
 
 
tiki_html_pages
tiki_html_pages_dynamic_zones 3 0 0 0 0
2%
 
 
tiki_html_pages_dynamic_zones
tiki_images 14 0 0 0 0
7%
 
 
tiki_images
tiki_images_data 17 0 0 0 0
8%
 
 
tiki_images_data
tiki_integrator_reps 18 0 0 0 0
9%
 
 
tiki_integrator_reps
tiki_integrator_rules 15 0 0 0 0
8%
 
 
tiki_integrator_rules
tiki_language 13 0 0 0 0
6%
 
 
tiki_language
tiki_languages 3 0 0 0 0
2%
 
 
tiki_languages
tiki_links 5 0 0 0 0
2%
 
 
tiki_links
tiki_link_cache 7 0 0 0 0
4%
 
 
tiki_link_cache
tiki_live_support_events 9 0 0 0 0
4%
 
 
tiki_live_support_events
tiki_live_support_messages 15 0 0 0 0
8%
 
 
tiki_live_support_messages
tiki_live_support_message_comments 10 0 0 0 0
5%
 
 
tiki_live_support_message_comments
tiki_live_support_modules 6 0 0 0 0
3%
 
 
tiki_live_support_modules
tiki_live_support_operators 13 0 0 0 0
6%
 
 
tiki_live_support_operators
tiki_live_support_requests 21 0 0 0 0
10%
 
 
tiki_live_support_requests
tiki_logs 21 0 0 0 0
10%
 
 
tiki_logs
tiki_mailin_accounts 24 0 0 0 0
12%
 
 
tiki_mailin_accounts
tiki_mail_events 20 0 0 0 0
10%
 
 
tiki_mail_events
tiki_menus 11 0 0 0 0
6%
 
 
tiki_menus
tiki_menu_languages 6 0 0 0 0
3%
 
 
tiki_menu_languages
tiki_menu_options 11 Details...hide/show 0 0 0 0
6%
 
 
tiki_menu_options
tiki_minical_events 21 0 0 0 0
10%
 
 
tiki_minical_events
tiki_minical_topics 15 0 0 0 0
8%
 
 
tiki_minical_topics
tiki_minichat 13 0 0 0 0
6%
 
 
tiki_minichat
tiki_modules 16 0 0 0 0
8%
 
 
tiki_modules
tiki_mypage 0 0 0 0 0
0%
 
 
tiki_mypage
tiki_mypagewin 0 0 0 0 0
0%
 
 
tiki_mypagewin
tiki_mypage_types 0 0 0 0 0
0%
 
 
tiki_mypage_types
tiki_mypage_types_components 0 0 0 0 0
0%
 
 
tiki_mypage_types_components
tiki_newsletters 112 0 0 0 0
56%
 
 
tiki_newsletters
tiki_newsletter_groups 15 0 0 0 0
8%
 
 
tiki_newsletter_groups
tiki_newsletter_included 3 0 0 0 0
2%
 
 
tiki_newsletter_included
tiki_newsletter_subscriptions 7 0 0 0 0
4%
 
 
tiki_newsletter_subscriptions
tiki_newsreader_marks 11 0 0 0 0
6%
 
 
tiki_newsreader_marks
tiki_newsreader_servers 6 0 0 0 0
3%
 
 
tiki_newsreader_servers
tiki_objects 15 0 0 0 0
8%
 
 
tiki_objects
tiki_object_ratings 11 0 0 0 0
6%
 
 
tiki_object_ratings
tiki_pages 27 0 0 0 0
14%
 
 
tiki_pages
tiki_pages_changes 26 0 0 0 0
13%
 
 
tiki_pages_changes
tiki_pages_translation_bits 7 0 0 0 0
4%
 
 
tiki_pages_translation_bits
tiki_pageviews 8 0 0 0 0
4%
 
 
tiki_pageviews
tiki_page_drafts 8 0 0 0 0
4%
 
 
tiki_page_drafts
tiki_page_footnotes 3 0 0 0 0
2%
 
 
tiki_page_footnotes
tiki_polls 11 0 0 0 0
6%
 
 
tiki_polls
tiki_poll_objects 5 0 0 0 0
2%
 
 
tiki_poll_objects
tiki_poll_options 4 0 0 0 0
2%
 
 
tiki_poll_options
tiki_preferences 7 0 0 0 0
4%
 
 
tiki_preferences
tiki_private_messages 8 0 0 0 0
4%
 
 
tiki_private_messages
tiki_programmed_content 10 0 0 0 0
5%
 
 
tiki_programmed_content
tiki_quizzes 39 0 0 0 0
20%
 
 
tiki_quizzes
tiki_quiz_questions 41 0 0 0 0
20%
 
 
tiki_quiz_questions
tiki_quiz_question_options 8 0 0 0 0
4%
 
 
tiki_quiz_question_options
tiki_quiz_results 9 0 0 0 0
4%
 
 
tiki_quiz_results
tiki_quiz_stats 7 0 0 0 0
4%
 
 
tiki_quiz_stats
tiki_quiz_stats_sum 8 0 0 0 0
4%
 
 
tiki_quiz_stats_sum
tiki_received_articles 29 0 0 0 0
14%
 
 
tiki_received_articles
tiki_received_pages 32 0 0 0 0
16%
 
 
tiki_received_pages
tiki_referer_stats 18 0 0 0 0
9%
 
 
tiki_referer_stats
tiki_registration_fields 9 0 0 0 0
4%
 
 
tiki_registration_fields
tiki_related_categories 8 0 0 0 0
4%
 
 
tiki_related_categories
tiki_rss_feeds 7 0 0 0 0
4%
 
 
tiki_rss_feeds
tiki_rss_modules 8 0 0 0 0
4%
 
 
tiki_rss_modules
tiki_score 12 0 0 0 0
6%
 
 
tiki_score
tiki_searchindex 8 0 0 0 0
4%
 
 
tiki_searchindex
tiki_searchsyllable 8 0 0 0 0
4%
 
 
tiki_searchsyllable
tiki_searchwords 3 0 0 0 0
2%
 
 
tiki_searchwords
tiki_search_stats 4 0 0 0 0
2%
 
 
tiki_search_stats
tiki_secdb 6 0 0 0 0
3%
 
 
tiki_secdb
tiki_semaphores 8 0 0 0 0
4%
 
 
tiki_semaphores
tiki_sent_newsletters 11 0 0 0 0
6%
 
 
tiki_sent_newsletters
tiki_sent_newsletters_errors 9 0 0 0 0
4%
 
 
tiki_sent_newsletters_errors
tiki_sessions 8 0 0 0 0
4%
 
 
tiki_sessions
tiki_sheets 8 0 0 0 0
4%
 
 
tiki_sheets
tiki_sheet_layout 8 0 0 0 0
4%
 
 
tiki_sheet_layout
tiki_sheet_values 11 0 0 0 0
6%
 
 
tiki_sheet_values
tiki_shoutbox 14 0 0 0 0
7%
 
 
tiki_shoutbox
tiki_shoutbox_words 7 0 0 0 0
4%
 
 
tiki_shoutbox_words
tiki_stats 6 0 0 0 0
3%
 
 
tiki_stats
tiki_structures 11 0 0 0 0
6%
 
 
tiki_structures
tiki_structure_versions 7 0 0 0 0
4%
 
 
tiki_structure_versions
tiki_submissions 35 0 0 0 0
18%
 
 
tiki_submissions
tiki_suggested_faq_questions 37 0 0 0 0
18%
 
 
tiki_suggested_faq_questions
tiki_surveys 11 0 0 0 0
6%
 
 
tiki_surveys
tiki_survey_questions 17 0 0 0 0
8%
 
 
tiki_survey_questions
tiki_survey_question_options 18 0 0 0 0
9%
 
 
tiki_survey_question_options
tiki_tags 15 0 0 0 0
8%
 
 
tiki_tags
tiki_theme_control_categs 13 0 0 0 0
6%
 
 
tiki_theme_control_categs
tiki_theme_control_objects 4 0 0 0 0
2%
 
 
tiki_theme_control_objects
tiki_theme_control_sections 4 0 0 0 0
2%
 
 
tiki_theme_control_sections
tiki_topics 10 0 0 0 0
5%
 
 
tiki_topics
tiki_trackers 21 0 0 0 0
10%
 
 
tiki_trackers
tiki_tracker_fields 28 Details...hide/show 0 0 0 0
14%
 
 
tiki_tracker_fields
tiki_tracker_items 22 0 0 0 0
11%
 
 
tiki_tracker_items
tiki_tracker_item_attachments 14 0 0 0 0
7%
 
 
tiki_tracker_item_attachments
tiki_tracker_item_comments 13 0 0 0 0
6%
 
 
tiki_tracker_item_comments
tiki_tracker_item_fields 8 0 0 0 0
4%
 
 
tiki_tracker_item_fields
tiki_tracker_options 5 0 0 0 0
2%
 
 
tiki_tracker_options
tiki_translated_objects 7 0 0 0 0
4%
 
 
tiki_translated_objects
tiki_untranslated 5 0 0 0 0
2%
 
 
tiki_untranslated
tiki_userfiles 14 0 0 0 0
7%
 
 
tiki_userfiles
tiki_userpoints 12 0 0 0 0
6%
 
 
tiki_userpoints
tiki_users 5 0 0 0 0
2%
 
 
tiki_users
tiki_users_score 6 0 0 0 0
3%
 
 
tiki_users_score
tiki_user_answers 8 0 0 0 0
4%
 
 
tiki_user_answers
tiki_user_answers_uploads 7 0 0 0 0
4%
 
 
tiki_user_answers_uploads
tiki_user_assigned_modules 13 0 0 0 0
6%
 
 
tiki_user_assigned_modules
tiki_user_bookmarks_folders 6 0 0 0 0
3%
 
 
tiki_user_bookmarks_folders
tiki_user_bookmarks_urls 5 0 0 0 0
2%
 
 
tiki_user_bookmarks_urls
tiki_user_mail_accounts 19 0 0 0 0
10%
 
 
tiki_user_mail_accounts
tiki_user_menus 18 0 0 0 0
9%
 
 
tiki_user_menus
tiki_user_modules 8 0 0 0 0
4%
 
 
tiki_user_modules
tiki_user_notes 8 0 0 0 0
4%
 
 
tiki_user_notes
tiki_user_postings 11 0 0 0 0
6%
 
 
tiki_user_postings
tiki_user_preferences 6 0 0 0 0
3%
 
 
tiki_user_preferences
tiki_user_quizzes 9 0 0 0 0
4%
 
 
tiki_user_quizzes
tiki_user_taken_quizzes 6 0 0 0 0
3%
 
 
tiki_user_taken_quizzes
tiki_user_tasks 11 0 0 0 0
6%
 
 
tiki_user_tasks
tiki_user_tasks_history 18 0 0 0 0
9%
 
 
tiki_user_tasks_history
tiki_user_votings 20 0 0 0 0
10%
 
 
tiki_user_votings
tiki_user_watches 11 0 0 0 0
6%
 
 
tiki_user_watches
tiki_webmail_contacts 10 0 0 0 0
5%
 
 
tiki_webmail_contacts
tiki_webmail_contacts_ext 8 0 0 0 0
4%
 
 
tiki_webmail_contacts_ext
tiki_webmail_contacts_fields 7 0 0 0 0
4%
 
 
tiki_webmail_contacts_fields
tiki_webmail_contacts_groups 7 0 0 0 0
4%
 
 
tiki_webmail_contacts_groups
tiki_webmail_messages 9 0 0 0 0
4%
 
 
tiki_webmail_messages
tiki_wiki_attachments 16 0 0 0 0
8%
 
 
tiki_wiki_attachments
tiki_zones 12 0 0 0 0
6%
 
 
tiki_zones
users_grouppermissions 4 0 0 0 0
2%
 
 
users_grouppermissions
users_groups 14 0 0 0 0
7%
 
 
users_groups
users_objectpermissions 15 0 0 0 0
8%
 
 
users_objectpermissions
users_permissions 8 0 0 0 0
4%
 
 
users_permissions
users_usergroups 8 0 0 0 0
4%
 
 
users_usergroups
users_users 25 0 0 0 0
12%
 
 
users_users
tiki_profile_symbols 32 0 0 0 0
16%
 
 
tiki_profile_symbols
tiki_feature 21 0 0 0 0
10%
 
 
tiki_feature
tiki_schema 16 0 0 0 0
8%
 
 
tiki_schema
tiki_semantic_tokens 5 0 0 0 0
2%
 
 
tiki_semantic_tokens
tiki_webservice 8 0 0 0 0
4%
 
 
tiki_webservice
tiki_webservice_template 9 0 0 0 0
4%
 
 
tiki_webservice_template
tiki_groupalert 10 0 0 0 0
5%
 
 
tiki_groupalert
tiki_poll_votes 9 0 0 0 0
4%
 
 
tiki_poll_votes
tiki_calendar_recurrence 31 0 0 0 0
16%
 
 
tiki_calendar_recurrence
tiki_sent_newsletters_files 30 0 0 0 0
15%
 
 
tiki_sent_newsletters_files
tiki_group_watches 11 0 0 0 0
6%
 
 
tiki_group_watches
tiki_sefurl_regex_out 13 0 0 0 0
6%
 
 
tiki_sefurl_regex_out
tiki_plugin_security 14 0 0 0 0
7%
 
 
tiki_plugin_security