Index: modules/nodevote/nodevote.install =================================================================== RCS file: /cvs/drupal-contrib/contributions/modules/nodevote/nodevote.install,v retrieving revision 1.1 diff -u -r1.1 nodevote.install --- modules/nodevote/nodevote.install 18 Apr 2006 03:34:07 -0000 1.1 +++ modules/nodevote/nodevote.install 16 Aug 2006 06:17:09 -0000 @@ -29,7 +29,18 @@ } break; - case 'pgsql': + case 'pgsql': + $query = db_query("CREATE TABLE {nodevote} ( + uid int NOT NULL default '0', + nid int NOT NULL default '0', + vote int NOT NULL default '0', + PRIMARY KEY (uid, nid) + )"); + if ($query) { + $created = TRUE; + } + db_query("CREATE INDEX {nodevote}_node_id_idx ON {nodevote} (nid)"); + db_query("CREATE INDEX {nodevote}_user_id_idx ON {nodevote} (uid)"); break; default: