aboutsummaryrefslogtreecommitdiff
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
parent69e58d8632198cf3eb39317d9382007731a10141 (diff)
downloadsemanticscuttle-dda05f5cc7e1d984564e5154f6ceda762c2224a3.tar.gz
semanticscuttle-dda05f5cc7e1d984564e5154f6ceda762c2224a3.tar.bz2
SQL schema version table to ease future database upgrades
-rw-r--r--data/schema/6.sql4
-rw-r--r--data/tables.sql8
-rw-r--r--doc/ChangeLog1
-rw-r--r--doc/UPGRADE.txt11
4 files changed, 23 insertions, 1 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');
diff --git a/data/tables.sql b/data/tables.sql
index c61c2f5..7a9c5bd 100644
--- a/data/tables.sql
+++ b/data/tables.sql
@@ -182,4 +182,10 @@ CREATE TABLE `sc_votes` (
UNIQUE KEY `bid_2` (`bId`,`uId`),
KEY `bid` (`bId`),
KEY `uid` (`uId`)
-) CHARACTER SET utf8 COLLATE utf8_general_ci ; \ No newline at end of file
+) CHARACTER SET utf8 COLLATE utf8_general_ci ;
+
+
+CREATE TABLE `sc_version` (
+ `schema_version` int(11) NOT NULL
+) DEFAULT CHARSET=utf8;
+INSERT INTO `sc_version` (`schema_version`) VALUES ('6');
diff --git a/doc/ChangeLog b/doc/ChangeLog
index d9b6f57..a54e71e 100644
--- a/doc/ChangeLog
+++ b/doc/ChangeLog
@@ -16,6 +16,7 @@ ChangeLog for SemantiScuttle
- Fix privacy issue when fetching tags of several users
- Only URLs with an allowed protocol may be added to the database
- Support HTTPS connections when $root is not configured
+- SQL schema version table to ease future database upgrades
0.97.2 - 2011-02-17
diff --git a/doc/UPGRADE.txt b/doc/UPGRADE.txt
index c4470f9..3be6654 100644
--- a/doc/UPGRADE.txt
+++ b/doc/UPGRADE.txt
@@ -2,6 +2,17 @@ Upgrading SemanticScuttle from a previous version
=================================================
+From version 0.97 to 0.98
+-------------------------
+Database updates: Apply data/schema/6.sql or do the following:
+
+ CREATE TABLE `sc_version` (
+ `schema_version` int(11) NOT NULL
+ ) DEFAULT CHARSET=utf8;
+
+ INSERT INTO `sc_version` (`schema_version`) VALUES ('6');
+
+
From version 0.96 to 0.97
-------------------------
No database changes necessary.