Dwite links

From Compsci.ca Wiki

(Difference between revisions)
Jump to: navigation, search

Revision as of 10:59, 14 May 2006

Contents

Structure

  • id - int(11), key, auto_increment
  • url - varchar(255)
  • name - varchar(255)
  • cat_id - int(11)

id

The id key.

url

The url, incuding http://, of the link.

name

The name to display of the link.

cat_id

The catagory the link is in. Curently this is hardcoded in the view but should be moved to the data base as a new table called cats.

Notes

  • cat_id needs to be updated with a new table corposnding to it called cats.
  • the view should be updated to corspond to this chage if it is made.
  • curently the only links in the data base are the working ones form the old dwite site + a compsci.ca link.
Personal tools