- id serial NOT NULL ,
- Name varchar(120) NOT NULL ,
- Password varchar(40) ,
- Comments TEXT ,
- Signature TEXT ,
- EmailAddress varchar(120) ,
- FreeformContactInfo TEXT ,
- Organization varchar(200) ,
- Privileged integer ,
- RealName varchar(120) ,
- Nickname varchar(16) ,
- Lang varchar(16) ,
- EmailEncoding varchar(16) ,
- WebEncoding varchar(16) ,
- ExternalContactInfoId varchar(100) ,
- ContactInfoSystem varchar(30) ,
- ExternalAuthId varchar(100) ,
- AuthSystem varchar(30) ,
- Gecos varchar(16) ,
- HomePhone varchar(30) ,
- WorkPhone varchar(30) ,
- MobilePhone varchar(30) ,
- PagerPhone varchar(30) ,
- Address1 varchar(200) ,
- Address2 varchar(200) ,
- City varchar(100) ,
- State varchar(100) ,
- Zip varchar(16) ,
- Country varchar(50) ,
- Creator integer ,
- Created timestamp ,
- LastUpdatedBy integer ,
- LastUpdated timestamp ,
- Disabled int2 NOT NULL DEFAULT 0 ,
+ id INTEGER DEFAULT nextval('users_id_seq'),
+ Name varchar(200) NOT NULL ,
+ Password varchar(40) NULL ,
+ Comments text NULL ,
+ Signature text NULL ,
+ EmailAddress varchar(120) NULL ,
+ FreeformContactInfo text NULL ,
+ Organization varchar(200) NULL ,
+ RealName varchar(120) NULL ,
+ NickName varchar(16) NULL ,
+ Lang varchar(16) NULL ,
+ EmailEncoding varchar(16) NULL ,
+ WebEncoding varchar(16) NULL ,
+ ExternalContactInfoId varchar(100) NULL ,
+ ContactInfoSystem varchar(30) NULL ,
+ ExternalAuthId varchar(100) NULL ,
+ AuthSystem varchar(30) NULL ,
+ Gecos varchar(16) NULL ,
+ HomePhone varchar(30) NULL ,
+ WorkPhone varchar(30) NULL ,
+ MobilePhone varchar(30) NULL ,
+ PagerPhone varchar(30) NULL ,
+ Address1 varchar(200) NULL ,
+ Address2 varchar(200) NULL ,
+ City varchar(100) NULL ,
+ State varchar(100) NULL ,
+ Zip varchar(16) NULL ,
+ Country varchar(50) NULL ,
+ Timezone varchar(50) NULL ,
+ PGPKey text NULL,
+
+ Creator integer NOT NULL DEFAULT 0 ,
+ Created TIMESTAMP NULL ,
+ LastUpdatedBy integer NOT NULL DEFAULT 0 ,
+ LastUpdated TIMESTAMP NULL ,