Dwite links

From Compsci.ca Wiki

(Difference between revisions)
Jump to: navigation, search
m
 
Line 21: Line 21:
* the view should be updated to corspond to this chage if it is made.
* 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.
* curently the only links in the data base are the working ones form the old dwite site + a compsci.ca link.
 +
* Pleas do not dump this data base, it was a pain to get all the links in.

Latest revision as of 11:01, 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.
  • Pleas do not dump this data base, it was a pain to get all the links in.
Personal tools