Hi All
I'm planning to make some changes to CGI::Wiki with Dom's help, mostly to the database structure.
Currently, the primary key is the name of the entry. This means the name is stored in all 4 tables (de-normalised), and not always with the same column name in each table (name vs node)
We are proposing to add a numeric id field to node. We will then replace name in content and node in metadata with node_id, the id of the node.
Oh, and then we'll do a database upgrade script, to take people from the current de-normalised form to the normalised form.
Finally, we're going to add a version table to the database, much like with Ruby On Rails. That will make future upgrades easiler, since the upgrade script will be able to tell what version you currently have
Nick
On Thu, 16 Feb 2006, Nick Burch wrote:
I'm planning to make some changes to CGI::Wiki with Dom's help, mostly to the database structure.
I've now finished these, and they can be found in the current SVN version. All the tests pass, but do shout if anything has been broken by it.
Next up, I'm planning to add moderation flags. I was going to add a column to node indicating if new versions need to be moderated, and to content to indicate if that version has been moderated.
(The idea is to move Oxford OpenGuides style moderation into CGI::Wiki from playing with the metadata, and make it more flexible so only commonly spammed entries need protection)
Nick