| | |
|---|
| | | mail_host varchar(128) DEFAULT '' NOT NULL, |
|---|
| | | alias varchar(128) DEFAULT '' NOT NULL, |
|---|
| | | created timestamp with time zone DEFAULT now() NOT NULL, |
|---|
| | | last_login timestamp with time zone DEFAULT now() NOT NULL, |
|---|
| | | last_login timestamp with time zone DEFAULT NULL, |
|---|
| | | "language" varchar(5), |
|---|
| | | preferences text DEFAULT ''::text NOT NULL |
|---|
| | | ); |
|---|
| | |
|---|
| | | identity_id integer DEFAULT nextval('identity_ids'::text) PRIMARY KEY, |
|---|
| | | user_id integer NOT NULL |
|---|
| | | REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE, |
|---|
| | | changed timestamp with time zone DEFAULT now() NOT NULL, |
|---|
| | | del smallint DEFAULT 0 NOT NULL, |
|---|
| | | standard smallint DEFAULT 0 NOT NULL, |
|---|
| | | name varchar(128) NOT NULL, |
|---|
