CREATE TABLE gd_user
(
  id               dintkey,
  name             dusername,
  passw            dpassword,                              
  ingroup          dinteger DEFAULT 1 NOT NULL,
  fullname         dtext180,                  
  description      dtext180,                  
  ibname           dusername,               
  ibpassword       dpassword,                
  contactkey       dintkey,                    
  externalkey      dforeignkey,               
  disabled         dboolean DEFAULT 0 NOT NULL,
  lockedout        dboolean DEFAULT 0,         
  mustchange       dboolean DEFAULT 0,        
  cantchangepassw  dboolean DEFAULT 1,      
  passwneverexp    dboolean DEFAULT 1,       
  expdate          ddate,                     
  workstart        dtime,                      
  workend          dtime,                     
  allowaudit       dallowaudit,              
                                              
  editiondate      deditiondate,
  editorkey        dforeignkey,

  icon             dinteger,                   
  reserved         dinteger,                  

  CHECK (((workstart IS NULL) AND (workend IS NULL)) OR (workstart < workend)),
  CHECK (ingroup <> 0)
);