diff options
author | alecpl <alec@alec.pl> | 2011-09-06 16:35:14 +0000 |
---|---|---|
committer | alecpl <alec@alec.pl> | 2011-09-06 16:35:14 +0000 |
commit | f8e48df71540b268ceac058d32b8ee848fc2ab6b (patch) | |
tree | d2e8ea19086014e8a89f761a9444e72d84145164 /SQL/postgres.initial.sql | |
parent | 66df084203a217ab74a416064c459cc3420a648c (diff) |
- Merge devel-saved_search branch (Addressbook Saved Searches)
Diffstat (limited to 'SQL/postgres.initial.sql')
-rw-r--r-- | SQL/postgres.initial.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/SQL/postgres.initial.sql b/SQL/postgres.initial.sql index c801a773c..01221c4e3 100644 --- a/SQL/postgres.initial.sql +++ b/SQL/postgres.initial.sql @@ -238,3 +238,29 @@ CREATE TABLE dictionary ( 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) +); |