[Rt-devel] schema thought

Dirk Pape pape-rt at inf.fu-berlin.de
Tue Jul 10 16:13:53 EDT 2007


Hello,

--Am 10. Juli 2007 17:57:59 +0100 schrieb Nicholas Clark <nick at ccl4.org>:

> Is it safe to make it not null?
>
> Or do some versions of mysql get upset for no logical reason in this case?

I just looke into my rt3 db (mysql innodb) and find Groups.Instance being 
varchar(64), too.

There are some records having Instance = NULL, mostly the "Pseudogroups for 
internal use" and some "UserDefined" groups from the old days.

So it seems make it NOT NULL is not safe.

Regards,
Dirk.

-- 
Dr. Dirk Pape (eAS - Projektleitung Campus Management)
Freie Universitaet Berlin
Grunewaldstr. 34a, 12165 Berlin
Tel. +49 (30) 838 75143, Fax. +49 (30) 838 54654



More information about the Rt-devel mailing list