| | |
| | | -- |
| | | |
| | | CREATE TABLE "session" ( |
| | | sess_id varchar(40) DEFAULT '' PRIMARY KEY, |
| | | sess_id varchar(128) DEFAULT '' PRIMARY KEY, |
| | | created timestamp with time zone DEFAULT now() NOT NULL, |
| | | changed timestamp with time zone DEFAULT now() NOT NULL, |
| | | ip varchar(41) NOT NULL, |
| | |
| | | REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE, |
| | | mailbox varchar(255) NOT NULL, |
| | | changed timestamp with time zone DEFAULT now() NOT NULL, |
| | | valid smallint NOT NULL DEFAULT 0, |
| | | data text NOT NULL, |
| | | PRIMARY KEY (user_id, mailbox) |
| | | ); |
| | |
| | | uid integer NOT NULL, |
| | | changed timestamp with time zone DEFAULT now() NOT NULL, |
| | | data text NOT NULL, |
| | | seen smallint NOT NULL DEFAULT 0, |
| | | deleted smallint NOT NULL DEFAULT 0, |
| | | answered smallint NOT NULL DEFAULT 0, |
| | | forwarded smallint NOT NULL DEFAULT 0, |
| | | flagged smallint NOT NULL DEFAULT 0, |
| | | mdnsent smallint NOT NULL DEFAULT 0, |
| | | flags integer NOT NULL DEFAULT 0, |
| | | PRIMARY KEY (user_id, mailbox, uid) |
| | | ); |
| | | |