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?

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

評比平均分數: -
In reply to Michael Wuttke

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

Martin Dougiamas發表於
Core developers的相片 Documentation writers的相片 Moodle HQ的相片 Particularly helpful Moodlers的相片 Plugin developers的相片 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

In reply to Martin Dougiamas

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

Michael Wuttke發表於

Hello Martin,

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

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