From 865419e2224bfd654af0a943a43febd4523f8dee Mon Sep 17 00:00:00 2001
From: alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c>
Date: Tue, 6 Sep 2011 13:39:45 +0000
Subject: - Merge devel-spellcheck branch:   - Added spellchecker exceptions
 dictionary (shared or per-user)   - Added possibility to ignore words
 containing caps, numbers, symbols (spellcheck_ignore_* options)

git-svn-id: https://svn.roundcube.net/trunk@5181 208e9e7b-5314-0410-a742-e7e81cd9613c
---
 roundcubemail/SQL/postgres.update.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'roundcubemail/SQL/postgres.update.sql')

diff --git a/roundcubemail/SQL/postgres.update.sql b/roundcubemail/SQL/postgres.update.sql
index 94513c53f..0a2ed99dd 100644
--- a/roundcubemail/SQL/postgres.update.sql
+++ b/roundcubemail/SQL/postgres.update.sql
@@ -100,3 +100,13 @@ CREATE INDEX contactgroupmembers_contact_id_idx ON contactgroupmembers (contact_
 
 TRUNCATE messages;
 TRUNCATE cache;
+
+-- Updates from version 0.6-stable
+
+CREATE TABLE dictionary (
+    user_id integer DEFAULT NULL
+        REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
+   "language" varchar(5) NOT NULL,
+    data text NOT NULL,
+    CONSTRAINT dictionary_user_id_language_key UNIQUE (user_id, "language")
+);
-- 
cgit v1.2.3

