From 66df084203a217ab74a416064c459cc3420a648c Mon Sep 17 00:00:00 2001 From: alecpl 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) --- SQL/mysql.initial.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'SQL/mysql.initial.sql') diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index 14bbb968a..4cabb8132 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -144,4 +144,15 @@ CREATE TABLE `identities` ( ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; +-- Table structure for table `dictionary` + +CREATE TABLE `dictionary` ( + `user_id` int(10) UNSIGNED DEFAULT NULL, + `language` varchar(5) NOT NULL, + `data` longtext NOT NULL, + CONSTRAINT `user_id_fk_dictionary` FOREIGN KEY (`user_id`) + REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE, + UNIQUE `uniqueness` (`user_id`, `language`) +) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; + /*!40014 SET FOREIGN_KEY_CHECKS=1 */; -- cgit v1.2.3