Hi all, Recently I started to design a database for a wiki using MySQL. Based on the 20mins tutorial, I have some changes for my wiki version. Instead of having 1 wiki, which it jumps straight to the FrontPage at start-up (or pagelist), I want a wiki farm where I can see a list of all wiki available. Here, I can add a new wiki, copy a wiki or remove an existing one. Upon visiting a wiki, it goes to the FrontPage of this wiki (or page list). Again inside this wiki, we can also add, edit, copy and delete a page. For the database design, I create 2 tables called Wiki & Page where Page table contains a wiki_id which is a foreign key of wiki id in Wiki Table. This will help distinguish which page in Page table belongs to which wiki. As you know, every wiki should only have unique page names, but 2 different wikis can have 2 same page names.
Wiki ------- id wikiname defaultpagename Page -------- id pagename data wiki_id (which is id in Wiki) This is my ideas how to construct my wiki system. However, I found it troublesome if I delete a wiki from Wiki table, this means I need to delete all the pages that belong to that wiki (delete rows from Page). Please advise if I'm on the right track for this database design or not. Your recommendations are all welcomed!
