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-350bfdb5ea9b4f7e50746c50a46d8032cbc5a104.tar.gz verbly-350bfdb5ea9b4f7e50746c50a46d8032cbc5a104.tar.bz2 verbly-350bfdb5ea9b4f7e50746c50a46d8032cbc5a104.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, |