diff options
author | Hans de Graaff <hans@degraaff.org> | 2012-10-26 13:00:04 +0200 |
---|---|---|
committer | Hans de Graaff <hans@degraaff.org> | 2012-10-26 13:00:04 +0200 |
commit | 7670cccf083e25676804c503582091a3eadb00cf (patch) | |
tree | 8aa8d9a6a760e2aa10c3d2f30df315f34c70ffc7 /data/gorg/schema.sql | |
parent | Initial commit (diff) | |
download | gorg-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.sql | 19 |
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)); |