Hacker Dan at 11:06, 14 May 2006

2006-05-14T11:06:54Z

← Older revision		Revision as of 11:06, 14 May 2006
Line 24:		Line 24:
	===long_desc===		===long_desc===
	A long description of the contest for the contests about page. HTML is curently striped out in the view for saftey reasons.		A long description of the contest for the contests about page. HTML is curently striped out in the view for saftey reasons.
		+
		+	==Used By==
		+	This table id is used in [[dwite_participants\|participants]].

	==Notes==		==Notes==

Hacker Dan at 10:48, 14 May 2006

2006-05-14T10:48:54Z

New page

==Structure==
* '''id''' - int(11), key, auto_increment
* '''name''' - varchar(255)
* '''desc''' - text
* '''start_date''' - int(255)
* '''type_id''' - int(11)
* '''long_desc''' - text

===id===
The key id.

===name===
The name of the contest.

===desc===
A short description of the contest that is displayed on the main page. HTML is curently striped out in the view for staftey reasons.

===start_date===
A time stamp of when the contest will start. Is there a better way of combding a date and time then a unix time stamp? If so we should probly chage this. Also we may whont to add an end_date col if the contest are going to be of difrent lengths. Tho the end_date could be dealt with by the back end.

===type_id===
This respesents the type of contest, as in what type of teams the contest is open to. See the [[dwite_type|type]] table and main [[DWITE_DB|data base]] for more information. -1 is for all types.

===long_desc===
A long description of the contest for the contests about page. HTML is curently striped out in the view for saftey reasons.

==Notes==
* More columes will most like have to be added to this table.
* start_date could be updated with somthing better then a unix time stamp if posiable.
* end_date could be added for more dyanickness and control of the back end.

Dwite contests - Revision history

Hacker Dan at 11:06, 14 May 2006

Hacker Dan at 10:48, 14 May 2006