DB Schema Question

RT Users
1

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@wildbrain.com

2

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.

Urm, read http://www.mysql.com/doc/C/R/CREATE_TABLE.html lately ? id is
primary (uniq) key, and any NULLage you see there is to do auto_increment
properly. ‘name’ is also defined as a uniq key.

                         Bruce Campbell                            RIPE
               Systems/Network Engineer                             NCC
             www.ripe.net - PGP562C8B1B                      Operations
3

Urm, read http://www.mysql.com/doc/C/R/CREATE_TABLE.html lately ? id is
primary (uniq) key, and any NULLage you see there is to do auto_increment
properly. ‘name’ is also defined as a uniq key.

My bad. I should have specified that I was looking at a PostgreSQL
version; here’s what I see when I look:

rt2=# \d users
Table “users”
Attribute | Type |
Modifier
id | integer | not null default
nextval(‘“users_id_seq”’::text)
name | character varying(120) | not null
password | character varying(40) |
comments | text |
signature | text |
emailaddress | character varying(120) |
freeformcontactinfo | text |
organization | character varying(200) |
privileged | integer |
realname | character varying(120) |
nickname | character varying(16) |
lang | character varying(16) |
emailencoding | character varying(16) |
webencoding | character varying(16) |
externalcontactinfoid | character varying(100) |
contactinfosystem | character varying(30) |
externalauthid | character varying(100) |
authsystem | character varying(30) |
gecos | character varying(16) |
homephone | character varying(30) |
workphone | character varying(30) |
mobilephone | character varying(30) |
pagerphone | character varying(30) |
address1 | character varying(200) |
address2 | character varying(200) |
city | character varying(100) |
state | character varying(100) |
zip | character varying(16) |
country | character varying(50) |
creator | integer |
created | timestamp with time zone |
lastupdatedby | integer |
lastupdated | timestamp with time zone |
disabled | smallint | not null default 0
Indices: users1,
users2,
users3,
users4,
users_pkey

It’s got to be my ignorance showing. I’ll go R some FMs and see if I can
figure it out.

Thanks!

–j
Jim Meyer, Geek At Large purp@wildbrain.com

4

I haven’t been able to find documentation on RT’s email gateway - only
the web interface and commandline.

We would like to be able to issue remote commands to RT via old fashioned
email, so I’m very interested in this gateway.

Could someone point me in the right direction?

Thanks a lot, Sherry

Sherry M. Rogers University of California, Berkeley
System & Network Security phone (510)642-7157