diff options
author | Kelly Rauchenberger <fefferburbia@gmail.com> | 2017-11-08 14:53:26 -0500 |
---|---|---|
committer | Kelly Rauchenberger <fefferburbia@gmail.com> | 2017-11-08 14:53:26 -0500 |
commit | 350bfdb5ea9b4f7e50746c50a46d8032cbc5a104 (patch) | |
tree | e339d118669f85de1afb858828a7affd0b47c745 /generator/schema.sql | |
parent | b92db337bf7cbe2ea0564be6c63c336d2bcd4567 (diff) | |
download | verbly-d1.0.tar.gz verbly-d1.0.tar.bz2 verbly-d1.0.zip |
Created database versioning system d1.0
Also added an ANALYZE statement to the end of the datafile generation process. This generates information that allows sqlite to sometimes come up with a better query plan, and in many cases can significant speed up queries. This constitutes a minor database update, but because this is the first version that uses the database versioning system, older versions are essentially incompatible. refs #2
Diffstat (limited to 'generator/schema.sql')
-rw-r--r-- | generator/schema.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/generator/schema.sql b/generator/schema.sql index c0f2bcb..d97c06e 100644 --- a/generator/schema.sql +++ b/generator/schema.sql | |||
@@ -1,3 +1,8 @@ | |||
1 | CREATE TABLE `version` ( | ||
2 | `major` INTEGER NOT NULL, | ||
3 | `minor` INTEGER NOT NULL | ||
4 | ); | ||
5 | |||
1 | CREATE TABLE `notions` ( | 6 | CREATE TABLE `notions` ( |
2 | `notion_id` INTEGER PRIMARY KEY, | 7 | `notion_id` INTEGER PRIMARY KEY, |
3 | `part_of_speech` SMALLINT NOT NULL, | 8 | `part_of_speech` SMALLINT NOT NULL, |