diff options
| author | Andreas Brachold <vdr07@deltab.de> | 2007-11-24 11:43:17 +0000 |
|---|---|---|
| committer | Andreas Brachold <vdr07@deltab.de> | 2007-11-24 11:43:17 +0000 |
| commit | 5af860a848a78b176e44bba36ff2baa5dec4067c (patch) | |
| tree | e5f8bc602456cb9377441aef077e875092b6c027 | |
| parent | 41d4bc0a078aea859ef274c250d5fc301fa162cb (diff) | |
| download | xxv-5af860a848a78b176e44bba36ff2baa5dec4067c.tar.gz xxv-5af860a848a78b176e44bba36ff2baa5dec4067c.tar.bz2 | |
* Table VERSION must dropped by update
| -rw-r--r-- | Makefile | 2 | ||||
| -rw-r--r-- | contrib/upgrade-xxv-db.sql | 11 |
2 files changed, 11 insertions, 2 deletions
@@ -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 |