From 350bfdb5ea9b4f7e50746c50a46d8032cbc5a104 Mon Sep 17 00:00:00 2001
From: Kelly Rauchenberger <fefferburbia@gmail.com>
Date: Wed, 8 Nov 2017 14:53:26 -0500
Subject: Created database versioning system

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
---
 generator/schema.sql | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'generator/schema.sql')

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 @@
+CREATE TABLE `version` (
+  `major` INTEGER NOT NULL,
+  `minor` INTEGER NOT NULL
+);
+
 CREATE TABLE `notions` (
   `notion_id` INTEGER PRIMARY KEY,
   `part_of_speech` SMALLINT NOT NULL,
-- 
cgit 1.4.1