[rt-users] DB Schema Question

Jim Meyer purp at wildbrain.com
Tue Jan 22 16:24:19 EST 2002


Hello!

I was poking through the database schema the other day and noticed in
the users table that neither the "id" or "name" fields are required to
be unique, even though RT::User::Create() requires this. Also, it would
seem that "id" could be of type "serial" as well. 

Are these design choices? I'm guessing that they are and have to do with
schema compatibility over several database types (e.g. MySQL,
PostgreSQL, etc.)

Thanks!

--j
-- 
Jim Meyer, Geek At Large                              purp at wildbrain.com





More information about the rt-users mailing list