Dwite links
From Compsci.ca Wiki
(Difference between revisions)
Hacker Dan (Talk | contribs) |
Hacker Dan (Talk | contribs) 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.
