Upgrade from 1.9.19 to 2.3.1 - The old wikie tables are important?

Upgrade from 1.9.19 to 2.3.1 - The old wikie tables are important?

by Michael Wuttke -
Number of replies: 2

Hello,

 

I've installed a clean 2.3.1 system and updated a test system from 1.9.19 to 2.3.1 based on mysql. By making a diff of both database-schemata and playing around with schemasync I noticed a number of inconsistencies between the tables.

The upgraded system wich comes originally form version 1.4.x or 1.5.x has the following tables wich are not included in the new clean 2.3.1 install:

 

attendance_roll,
pma_bookmark, pma_column_info pma_designer_coords pma_history pma_pdf_pages pma_relation pma_table_coords pma_table_info,
unittest_course_modules, unittest_grade_categories, unittest_grade_categories_history , unittest_grade_grades, unittest_grade_grades_history,
mdl_wiki_entries_old, mdl_wiki_locks_old, mdl_wiki_pages_old

Do I need these tables anymore or can I drop them, especially the last three wiki-tables, wich are copies of three new ones in my opinion?

Thanks for any help or hint,

michael

Average of ratings: -
In reply to Michael Wuttke

Re: Upgrade from 1.9.19 to 2.3.1 - The old wikie tables are important?

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers

HI Michael,

Nice to see such an old site getting upgraded!

I am quite sure these are all old and can be dropped.  The pma ones were created by the phpmyadmin plugin at some point, the unittest ones are from some old unit testing code, and the wiki ones are just backups from the Wiki upgrade.

Cheers!
Martin

Average of ratings: -
In reply to Martin Dougiamas

Re: Upgrade from 1.9.19 to 2.3.1 - The old wikie tables are important?

by Michael Wuttke -

Hello Martin,

thank you for your quick answer. I had already thought something like that but was not sure. wink

Than I will delete them.

The last thing: Is there a way to add the table-comments automatically for those tables, which still have not a comment after the upgrade - as described here? I want to avoid to fix it by hand.

Thanks & Greetings,

michael

Average of ratings: -