adding automatic schema migration mechanism

[motion.git] / sql / schema.sql

diff --git a/schema.sql b/sql/schema.sql
old mode 100644 (file)
new mode 100755 (executable)
similarity index 88%
rename from schema.sql
rename to sql/schema.sql
index ed0d876..116e76f
--- a/schema.sql
+++ b/sql/schema.sql
@@ -24,3 +24,7 @@ CREATE TABLE vote (motion_id INTEGER NOT NULL,
                  result vote_type NOT NULL,
                  entered timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                  PRIMARY KEY(motion_id, voter_id));
+
+DROP TABLE IF EXISTS schema_version;
+CREATE TABLE schema_version (version INTEGER NOT NULL);
+INSERT INTO schema_version(version) VALUES(1);