| | |
|---|
| | | data text NOT NULL, |
|---|
| | | CONSTRAINT dictionary_user_id_language_key UNIQUE (user_id, "language") |
|---|
| | | ); |
|---|
| | | |
|---|
| | | -- |
|---|
| | | -- Sequence "searches_ids" |
|---|
| | | -- Name: searches_ids; Type: SEQUENCE; Schema: public; Owner: postgres |
|---|
| | | -- |
|---|
| | | |
|---|
| | | CREATE SEQUENCE search_ids |
|---|
| | | INCREMENT BY 1 |
|---|
| | | NO MAXVALUE |
|---|
| | | NO MINVALUE |
|---|
| | | CACHE 1; |
|---|
| | | |
|---|
| | | -- |
|---|
| | | -- Table "searches" |
|---|
| | | -- Name: searches; Type: TABLE; Schema: public; Owner: postgres |
|---|
| | | -- |
|---|
| | | |
|---|
| | | CREATE TABLE searches ( |
|---|
| | | search_id integer DEFAULT nextval('search_ids'::text) PRIMARY KEY, |
|---|
| | | user_id integer NOT NULL |
|---|
| | | REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE, |
|---|
| | | "type" smallint DEFAULT 0 NOT NULL, |
|---|
| | | name varchar(128) NOT NULL, |
|---|
| | | data text NOT NULL, |
|---|
| | | CONSTRAINT searches_user_id_key UNIQUE (user_id, "type", name) |
|---|
| | | ); |
|---|
