Hacker Dan at 11:01, 14 May 2006

2006-05-14T11:01:02Z

← Older revision		Revision as of 11:01, 14 May 2006
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.

Hacker Dan at 10:59, 14 May 2006

2006-05-14T10:59:46Z

New page

==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 [[dwite_cats|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.

Dwite links - Revision history

Hacker Dan at 11:01, 14 May 2006

Hacker Dan at 10:59, 14 May 2006