--- unitag.install	2008-01-15 00:59:58.000000000 -0500
+++ unitag.install_pgsql	2008-06-07 21:25:42.000000000 -0400
@@ -9,12 +9,10 @@ function unitag_install() {
     case 'pgsql':
       db_query("CREATE TABLE {unitag} (
         utid serial CHECK (utid > 0),
-        nid int unsigned NOT NULL default 0,
-        vid int unsigned NOT NULL default 0,
+        nid int NOT NULL default 0,
+        vid int NOT NULL default 0,
         name varchar(255) NOT NULL default '',
-        PRIMARY KEY (utid),
-        KEY nid (nid),
-        KEY name (name)
+        PRIMARY KEY (utid)
       )");
       db_query("CREATE INDEX {unitag}_nid_idx ON {unitag} (nid)");
       db_query("CREATE INDEX {unitag}_name_idx ON {unitag} (name)");