recreate 'trunk' from 'branches/diogenes-0.9.19'

[diogenes.git] / config / db / diogenes.sql

diff --git a/config/db/diogenes.sql b/config/db/diogenes.sql
index 6b5fd4c..dad6e88 100644 (file)
--- a/config/db/diogenes.sql
+++ b/config/db/diogenes.sql
@@ -113,9 +113,10 @@ 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`)
+  PRIMARY KEY  (`plugin`,`barrel`,`page`),
+  KEY `pos` (`pos`)
 ) TYPE=MyISAM;
 
 -- --------------------------------------------------------
@@ -137,4 +138,4 @@ CREATE TABLE `diogenes_site` (
 -- Set the database format version
 --
 
-INSERT INTO `diogenes_option` SET name='dbversion', value='0.9.20';
+INSERT INTO `diogenes_option` SET name='dbversion', value='0.9.16+0.9.17pre21';