Index: modules/nodequeue/nodequeue.install =================================================================== RCS file: /cvs/drupal-contrib/contributions/modules/nodequeue/nodequeue.install,v retrieving revision 1.3.2.8 diff -u -p -r1.3.2.8 nodequeue.install --- modules/nodequeue/nodequeue.install 19 Jun 2007 20:13:37 -0000 1.3.2.8 +++ modules/nodequeue/nodequeue.install 19 Jun 2007 20:21:50 -0000 @@ -40,30 +40,30 @@ function nodequeue_install() { case 'pgsql': db_query("CREATE TABLE {nodequeue_queue} ( - qid integer unsigned NOT NULL PRIMARY KEY, + qid integer NOT NULL PRIMARY KEY, title varchar(255) NOT NULL, - size integer unsigned default '0', + size integer default '0', link varchar(255), link_remove varchar(255) )"); db_query("CREATE TABLE {nodequeue_roles} ( - qid integer unsigned NOT NULL, - rid integer unsigned + qid integer NOT NULL, + rid integer )"); db_query("CREATE INDEX {nodequeue_roles}_qid_idx ON {nodequeue_roles} (qid)"); db_query("CREATE INDEX {nodequeue_roles}_rid_idx ON {nodequeue_roles} (rid)"); db_query("CREATE TABLE {nodequeue_types} ( - qid integer unsigned NOT NULL, + qid integer NOT NULL, type varchar(255) )"); db_query("CREATE INDEX {nodequeue_types}_qid_idx ON {nodequeue_types} (qid)"); db_query("CREATE TABLE {nodequeue_nodes} ( - qid integer unsigned NOT NULL, - nid integer unsigned, - position integer unsigned + qid integer NOT NULL, + nid integer, + position integer )"); db_query("CREATE INDEX {nodequeue_nodes}_qid_idx ON {nodequeue_nodes} (qid, position)"); db_query("CREATE INDEX {nodequeue_nodes}_nid_idx ON {nodequeue_nodes} (nid)"); @@ -82,11 +82,17 @@ function nodequeue_install() { } function nodequeue_uninstall() { - // Note: pgsql versions of these necessary? - db_query("DROP TABLE IF EXISTS {nodequeue_queue}"); - db_query("DROP TABLE IF EXISTS {nodequeue_roles}"); - db_query("DROP TABLE IF EXISTS {nodequeue_types}"); - db_query("DROP TABLE IF EXISTS {nodequeue_nodes}"); + $tables = array( + 'nodequeue_queue', + 'nodequeue_roles', + 'nodequeue_types', + 'nodequeue_nodes', + ); + foreach ($tables as $table) { + if (db_table_exists($table)) { + db_query("DROP TABLE {$table}"); + } + } } function nodequeue_update_1() {