From 5af860a848a78b176e44bba36ff2baa5dec4067c Mon Sep 17 00:00:00 2001 From: Andreas Brachold Date: Sat, 24 Nov 2007 11:43:17 +0000 Subject: * Table VERSION must dropped by update --- Makefile | 2 +- contrib/upgrade-xxv-db.sql | 11 ++++++++++- 2 files changed, 11 insertions(+), 2 deletions(-) diff --git a/Makefile b/Makefile index 3aa1599..4230392 100644 --- a/Makefile +++ b/Makefile @@ -55,7 +55,7 @@ updateversion: DBTABLES = $(shell cat ./contrib/update-xxv | grep tables= | cut -d '=' -f 2 | sed -e s/\'//g;) updatesql: @echo Please type the DB-Password for root: - @mysqldump -p -n -d --add-drop-table --compatible=mysql40,no_table_options -p -u root xxv $(DBTABLES) -r ./contrib/upgrade-xxv-db.sql + @mysqldump -p -n -d --add-drop-table --compatible=mysql40,no_table_options -p -u root xxv $(DBTABLES) VERSION -r ./contrib/upgrade-xxv-db.sql setpermission: @find $(TMPDIR)/$(ARCHIVE) -type d -exec chmod 755 {} \; 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 -- cgit v1.2.3