Re: [Cobalt-developers] autotested_mark table student_id too short

[Russell B. <bo...@dc...>]

On Thu, 20 Oct 2005, Harri J=E4rvi wrote:

> the  student_id field in autotested_mark table is currently set to 7 wh=
ereas
> every other table has VARCHAR(200) for it. 7 is not long enough for a s=
tudent
> id.
>
> student_id           CHAR(7)              NOT NULL,

Sorry, that's a mistake and should probably be VARCHAR(200).  At Warwick=20
our student ID numbers are *always* seven digits.  We've tried to remove=20
as much of the Warwick specific things like this as possible but we do=20
miss them sometimes!


Russ