- Merge devel-saved_search branch (Addressbook Saved Searches)

git-svn-id: https://svn.roundcube.net/trunk@5182 208e9e7b-5314-0410-a742-e7e81cd9613c

1 files changed, 26 insertions, 0 deletions

diff --git a/roundcubemail/SQL/postgres.initial.sql b/roundcubemail/SQL/postgres.initial.sql
index c801a773c..01221c4e3 100644
--- a/roundcubemail/SQL/postgres.initial.sql
+++ b/roundcubemail/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)
+);