Index: nodequeue.install
===================================================================
RCS file: /cvs/drupal-contrib/contributions/modules/nodequeue/nodequeue.install,v
retrieving revision 1.3.2.10.2.8
diff -u -p -r1.3.2.10.2.8 nodequeue.install
--- nodequeue.install	31 Aug 2007 17:44:42 -0000	1.3.2.10.2.8
+++ nodequeue.install	10 Oct 2007 06:05:25 -0000
@@ -17,7 +17,8 @@ function nodequeue_install() {
           show_in_ui int(1) default '1',
           show_in_tab int(1) default '1',
           show_in_links int(1) default '1',
-          reference varchar(255) default '0'
+          reference varchar(255) default '0',
+          reverse tinyint
         ) /*!40100 DEFAULT CHARACTER SET utf8 */");
 
         db_query("CREATE TABLE if not exists {nodequeue_roles} (
@@ -69,7 +70,8 @@ function nodequeue_install() {
           show_in_ui integer default '1',
           show_in_tab integer default '1',
           link varchar(255),
-          link_remove varchar(255)
+          link_remove varchar(255),
+          reverse smallint
         )");
 
         db_query("CREATE TABLE {nodequeue_roles} (
@@ -226,6 +228,14 @@ function nodequeue_update_5202() {
 
 function nodequeue_update_5203() {
   $ret = array();
-  db_add_column($ret, 'nodequeue_queue', 'reverse', 'int(1)');
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      $ret[] = update_sql("ALTER TABLE {nodequeue_nodes} ADD COLUMN timestamp int DEFAULT '0' NOT NULL");
+      break;
+    case 'pgsql':
+      db_add_column($ret, 'nodequeue_queue', 'reverse', 'smallint');
+      break;
+  }
   return $ret;
 }