summaryrefslogtreecommitdiff
path: root/data/schema
diff options
context:
space:
mode:
authorChristian Weiske <cweiske@cweiske.de>2011-05-04 08:02:33 +0200
committerChristian Weiske <cweiske@cweiske.de>2011-05-04 08:02:33 +0200
commitdda05f5cc7e1d984564e5154f6ceda762c2224a3 (patch)
treee72e5b7df28d99e39300cb77eadca414ab9f66cd /data/schema
parent69e58d8632198cf3eb39317d9382007731a10141 (diff)
downloadsemanticscuttle-dda05f5cc7e1d984564e5154f6ceda762c2224a3.tar.gz
semanticscuttle-dda05f5cc7e1d984564e5154f6ceda762c2224a3.tar.bz2
SQL schema version table to ease future database upgrades
Diffstat (limited to 'data/schema')
-rw-r--r--data/schema/6.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/data/schema/6.sql b/data/schema/6.sql
new file mode 100644
index 0000000..4ae7cb9
--- /dev/null
+++ b/data/schema/6.sql
@@ -0,0 +1,4 @@
+CREATE TABLE `sc_version` (
+ `schema_version` int(11) NOT NULL
+) DEFAULT CHARSET=utf8;
+INSERT INTO `sc_version` (`schema_version`) VALUES ('6');