diff options
| author | Christian Weiske <cweiske@cweiske.de> | 2011-05-04 08:02:33 +0200 |
|---|---|---|
| committer | Christian Weiske <cweiske@cweiske.de> | 2011-05-04 08:02:33 +0200 |
| commit | dda05f5cc7e1d984564e5154f6ceda762c2224a3 (patch) | |
| tree | e72e5b7df28d99e39300cb77eadca414ab9f66cd | |
| parent | 69e58d8632198cf3eb39317d9382007731a10141 (diff) | |
| download | semanticscuttle-dda05f5cc7e1d984564e5154f6ceda762c2224a3.tar.gz semanticscuttle-dda05f5cc7e1d984564e5154f6ceda762c2224a3.tar.bz2 | |
SQL schema version table to ease future database upgrades
| -rw-r--r-- | data/schema/6.sql | 4 | ||||
| -rw-r--r-- | data/tables.sql | 8 | ||||
| -rw-r--r-- | doc/ChangeLog | 1 | ||||
| -rw-r--r-- | doc/UPGRADE.txt | 11 |
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. |