Kouhei Sutou
null+****@clear*****
Sun May 17 16:48:31 JST 2015
Kouhei Sutou 2015-05-17 16:48:31 +0900 (Sun, 17 May 2015) New Revision: 2883c636c7740947797221e1d3d4c8c4a9f11998 https://github.com/droonga/wikipedia-search/commit/2883c636c7740947797221e1d3d4c8c4a9f11998 Message: Add schema for PGroonga and Mroonga Added files: config/sql/indexes.mroonga.sql config/sql/indexes.pg_bigm.sql config/sql/indexes.pgroonga.sql config/sql/schema.mroonga.sql config/sql/schema.pgroonga.sql Added: config/sql/indexes.mroonga.sql (+1 -0) 100644 =================================================================== --- /dev/null +++ config/sql/indexes.mroonga.sql 2015-05-17 16:48:31 +0900 (4cc6840) @@ -0,0 +1 @@ +ALTER TABLE wikipedia ADD FULLTEXT INDEX (title, text); Added: config/sql/indexes.pg_bigm.sql (+2 -0) 100644 =================================================================== --- /dev/null +++ config/sql/indexes.pg_bigm.sql 2015-05-17 16:48:31 +0900 (90d49f3) @@ -0,0 +1,2 @@ +CREATE INDEX wikipedia_index_pg_bigm ON wikipedia + USING gin (title gin_bigm_ops, text gin_bigm_ops); Added: config/sql/indexes.pgroonga.sql (+2 -0) 100644 =================================================================== --- /dev/null +++ config/sql/indexes.pgroonga.sql 2015-05-17 16:48:31 +0900 (8b973ba) @@ -0,0 +1,2 @@ +CREATE INDEX wikipedia_index_pgroonga ON wikipedia + USING pgroonga (title, text); Added: config/sql/schema.mroonga.sql (+6 -0) 100644 =================================================================== --- /dev/null +++ config/sql/schema.mroonga.sql 2015-05-17 16:48:31 +0900 (26b6209) @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS wikipedia; +CREATE TABLE wikipedia ( + id integer PRIMARY KEY, + title text, + text text +) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4; Added: config/sql/schema.pgroonga.sql (+6 -0) 100644 =================================================================== --- /dev/null +++ config/sql/schema.pgroonga.sql 2015-05-17 16:48:31 +0900 (fc7639c) @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS wikipedia; +CREATE TABLE wikipedia ( + id integer PRIMARY KEY, + title text, + text text +); -------------- next part -------------- HTML����������������������������...Download