| | |
| | | -- RoundCube Webmail initial database structure |
| | | -- Roundcube Webmail initial database structure |
| | | |
| | | -- |
| | | -- Sequence "user_ids" |
| | |
| | | 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, |