aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorHans de Graaff <hans@degraaff.org>2012-10-26 13:00:04 +0200
committerHans de Graaff <hans@degraaff.org>2012-10-26 13:00:04 +0200
commit7670cccf083e25676804c503582091a3eadb00cf (patch)
tree8aa8d9a6a760e2aa10c3d2f30df315f34c70ffc7 /data/gorg/schema.sql
parentInitial commit (diff)
downloadgorg-7670cccf083e25676804c503582091a3eadb00cf.tar.gz
gorg-7670cccf083e25676804c503582091a3eadb00cf.tar.bz2
gorg-7670cccf083e25676804c503582091a3eadb00cf.zip
Import distributed 0.6.4 release.0.6.4
Diffstat (limited to 'data/gorg/schema.sql')
-rw-r--r--data/gorg/schema.sql19
1 files changed, 19 insertions, 0 deletions
diff --git a/data/gorg/schema.sql b/data/gorg/schema.sql
new file mode 100644
index 0000000..3398c1f
--- /dev/null
+++ b/data/gorg/schema.sql
@@ -0,0 +1,19 @@
+drop table if exists files;
+create table files(
+ id int auto_increment primary key,
+ path varchar(255) unique,
+ lang varchar(5),
+ timestamp varchar(32),
+ size bigint,
+ txt mediumtext) CHARACTER SET utf8;
+create unique index files_path on files (path(255));
+create index files_lang on files (lang);
+create fulltext index files_txt on files (txt);
+
+drop table if exists savedsearches;
+create table savedsearches(
+ words tinytext,
+ bool char(1),
+ lang varchar(5),
+ result mediumblob);
+create index savedsearches_words on savedsearches(lang, words(200));