summaryrefslogtreecommitdiff
path: root/contrib/upgrade-xxv-db.sql
diff options
context:
space:
mode:
authorAndreas Brachold <vdr07@deltab.de>2007-11-24 11:43:17 +0000
committerAndreas Brachold <vdr07@deltab.de>2007-11-24 11:43:17 +0000
commit5af860a848a78b176e44bba36ff2baa5dec4067c (patch)
treee5f8bc602456cb9377441aef077e875092b6c027 /contrib/upgrade-xxv-db.sql
parent41d4bc0a078aea859ef274c250d5fc301fa162cb (diff)
downloadxxv-5af860a848a78b176e44bba36ff2baa5dec4067c.tar.gz
xxv-5af860a848a78b176e44bba36ff2baa5dec4067c.tar.bz2
* Table VERSION must dropped by update
Diffstat (limited to 'contrib/upgrade-xxv-db.sql')
-rw-r--r--contrib/upgrade-xxv-db.sql11
1 files changed, 10 insertions, 1 deletions
diff --git a/contrib/upgrade-xxv-db.sql b/contrib/upgrade-xxv-db.sql
index cbfd939..af58b6a 100644
--- a/contrib/upgrade-xxv-db.sql
+++ b/contrib/upgrade-xxv-db.sql
@@ -143,6 +143,15 @@ CREATE TABLE `USER` (
`MaxPriority` tinyint(2) default '0',
PRIMARY KEY (`Id`)
);
+
+--
+-- Table structure for table `VERSION`
+--
+
+DROP TABLE IF EXISTS `VERSION`;
+CREATE TABLE `VERSION` (
+ `Version` tinyint(4) NOT NULL default '0'
+);
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
@@ -150,4 +159,4 @@ CREATE TABLE `USER` (
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2007-11-17 17:21:22
+-- Dump completed on 2007-11-24 11:40:15