--- /opt/build/drupalmods47/evaluation/advpoll/advpoll.install	2006-10-31 14:05:24.000000000 +0800
+++ advpoll.install	2007-01-02 00:21:20.207403134 +0800
@@ -38,6 +38,37 @@
         ) ENGINE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */");
 
       break;
+    case 'pgsql':
+      db_query("CREATE TABLE {advpoll} (
+          nid integer NOT NULL,
+          quorum integer NOT NULL DEFAULT '0',
+          mode varchar(32) NOT NULL,
+          uselist boolean DEFAULT false,
+          active boolean DEFAULT true,
+          runtime integer NOT NULL DEFAULT '0',
+          maxchoices integer NOT NULL DEFAULT '0',
+          algorithm varchar(100),
+          showvotes boolean,
+          startdate integer,
+          PRIMARY KEY (nid)
+      )");
+
+      db_query("CREATE SEQUENCE {votingapi_cache}_seq;");
+
+      db_query("CREATE TABLE {advpoll_electoral_list} ( 
+          nid integer NOT NULL,
+          uid integer NOT NULL,
+          PRIMARY KEY (nid, uid)   
+      )");
+
+      db_query("CREATE TABLE {advpoll_choices} (
+          nid integer NOT NULL,
+          label text NOT NULL,
+          vote_offset smallint DEFAULT NULL,
+          PRIMARY KEY (nid, vote_offset)
+      )");
+      db_query("CREATE INDEX {advpoll_choices}_vote_offset_idx ON {advpoll_choices} (vote_offset)");
+      break;
   }
 }