Dwite links

From Compsci.ca Wiki

Contents 1 Structure 1.1 id 1.2 url 1.3 name 1.4 cat_id 2 Notes

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.