touchup database structure

diff --git a/config/db/diogenes.sql b/config/db/diogenes.sql
index 70c6571..6b5fd4c 100644 (file)
--- a/config/db/diogenes.sql
+++ b/config/db/diogenes.sql
@@ -113,11 +113,9 @@ CREATE TABLE `diogenes_plugin` (
   `plugin` varchar(32) NOT NULL default '',
   `barrel` varchar(16) NOT NULL default '',
   `page` int(10) unsigned NOT NULL default '0',
-  `pos` int(10) unsigned NOT NULL default '0',
   `params` text NOT NULL,
   `status` int(1) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`plugin`,`barrel`,`page`),
-  KEY `pos` (`pos`)
+  PRIMARY KEY  (`plugin`,`barrel`,`page`)
 ) TYPE=MyISAM;
 
 -- --------------------------------------------------------
@@ -139,4 +137,4 @@ CREATE TABLE `diogenes_site` (
 -- Set the database format version
 --
 
-INSERT INTO `diogenes_option` SET name='dbversion', value='0.9.16+0.9.17pre21';
+INSERT INTO `diogenes_option` SET name='dbversion', value='0.9.20';

diff --git a/config/updatedb.php b/config/updatedb.php
index 2e9a4a2..56c4803 100755 (executable)
--- a/config/updatedb.php
+++ b/config/updatedb.php
@@ -13,7 +13,7 @@ require_once("diogenes/diogenes.database-creator.inc.php");
 class DiogenesDbInit extends DiogenesDatabaseCreator
 {
   /** database versions history */
-  var $versions = array("0.9.9.3", "0.9.10", "0.9.12", "0.9.15", "0.9.16", "0.9.16+0.9.17pre15", "0.9.16+0.9.17pre19", "0.9.16+0.9.17pre21", "0.9.18+0.9.19pre2");
+  var $versions = array("0.9.9.3", "0.9.10", "0.9.12", "0.9.15", "0.9.16", "0.9.16+0.9.17pre15", "0.9.16+0.9.17pre19", "0.9.16+0.9.17pre21", "0.9.20");
 
   /**
    * Upgrades the database from one version to the next
@@ -214,7 +214,7 @@ class DiogenesDbInit extends DiogenesDatabaseCreator
       $this->dbh->query("INSERT INTO diogenes_logactions VALUES (16, 'page_plugins', 'the page plugins were modified');");
       break;
 
-    case "0.9.18+0.9.19pre2":
+    case "0.9.20":
       $this->info(" - adding 'status' field to 'diogenes_plugin' table");
       $this->dbh->query("ALTER TABLE `diogenes_plugin` ADD `status` INT( 1 ) UNSIGNED NOT NULL default '0'");
       $this->dbh->query("update diogenes_plugin set status=0 where page=0");