Details
-
Type:
Sub-task
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 2.0
-
Fix Version/s: 2.0
-
Component/s: Wiki (2.x)
-
Labels:None
-
Affected Branches:MOODLE_20_STABLE
-
Fixed Branches:MOODLE_20_STABLE
Description
http://potato.lsi.upc.edu/projects/wiki20/browser/mod/wiki/db/install.xml
==wiki==
wikicourse - move this flag to wiki course format plugin
filetemplate - the handling of files changed completely, was this considered? might be text field instead
migrated - migrated from what tables? The old content should be moved to some new tables I guess and this flag could be there - David Mudrak has similar problems in Workshop, maybe both could use the same approach to make things easier to understand
==wiki_subwikis==
missing foreign keys info
==wiki_pages==
userid - COMMENT="Edition author" ? it is the person who created the page, right?
version - this should link wiki_versions->id, the human readable version is there, right?
missign foreign keys info
==wiki_versions==
subwikiid - why do we need it there? it links to wiki_pages which already contains this info, right?
format - wrong name, should be "contentformat"
why is there no "change summary" field like in mediawiki?
again foreign keys
==wiki_links==
is just a cache parsed from the latest version of each page, right?
subwikiid - why is it duplicated again, each page knows subwikiid
STATEMENTS section must be replaced by new code in db/install.php
== wiki ==
these 3 fields (wikicourse, filetemplate and migrated) have been removed from this table.
== wiki_subwikis ==
FKs added.
== wiki_pages ==
userid is the author of the last version, not the creator.
version is the version number. currentversionid is a FK to wiki_version.
FKs added
== wiki_versions ==
"change summary" could be a nice feature. I'll comment it to ludo.
format changed to contentformat
FKs added.
subwikiid removed
== wiki_links ==
yes, it contains the links of the last version of a page.
In this case, subwikiid is very usefull to get info about the links of a whole wiki without joining with wiki_pages
== Statements Section=
deleted. We will use install.php in future