Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2007
    Location
    Auckland New Zealand
    Posts
    120

    Wiki Pedia Table Setup

    I want to build a wikipedia type information system,
    http://en.wikipedia.org/wiki/Main_Page Like this but with a much more limited information set.
    Im not sure how I should build the tables around the data for:

    The Main Content - Are these Subdivided portions linked through foreign keys?
    Images - Movie Files etc - Should I build a separate table for these types of items (varchar link to file), or can I store the information as blob or something directly into the record

    Field Data type Description
    TopicID Int PK Primary Identifier
    Parent_TopicID Int FK Link to Parent Category
    Topic Varchar(120) Name of Topic
    Information varchar(unlimited????)

    would appreciate any thoughts on the matter, and Im using SQL server 2005 for any data types.

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    why do this at all? there are so many free wiki packages out there already. why not just use one of them?

  3. #3
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    Quote Originally Posted by jezemine
    why not just use one of them?
    Another way of putting this: what do you need that the existing packages don't offer?

  4. #4
    Join Date
    Aug 2007
    Location
    Auckland New Zealand
    Posts
    120
    Whats a Good example?, I already have an extensive CMS that I want to add another facet of information too,

    I cant' afford a commercial option and don't want the typically external links that come with the free editions of software.
    Im not sure what features are offered by existing systems?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •