From dda05f5cc7e1d984564e5154f6ceda762c2224a3 Mon Sep 17 00:00:00 2001 From: Christian Weiske Date: Wed, 4 May 2011 08:02:33 +0200 Subject: SQL schema version table to ease future database upgrades --- data/schema/6.sql | 4 ++++ data/tables.sql | 8 +++++++- 2 files changed, 11 insertions(+), 1 deletion(-) create mode 100644 data/schema/6.sql (limited to 'data') 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'); -- cgit v1.2.3