[rt-users] DB Schema Question

Jim Meyer purp at wildbrain.com
Wed Jan 23 20:49:23 EST 2002


On Wed, 2002-01-23 at 12:56, Bruce Campbell wrote:
> 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 at wildbrain.com





More information about the rt-users mailing list