--- subversion.install.orig	2006-06-24 13:55:09.000000000 +1000
+++ subversion.install	2006-06-24 14:10:29.000000000 +1000
@@ -85,6 +85,65 @@
       );
       break;
     case 'pgsql':
+      $ret[] = db_query("CREATE TABLE {subversion_accounts} (
+        uid int4 NOT NULL default '0',
+        name varchar(64) NOT NULL default '',
+        pass varchar(64) NOT NULL default '',
+        motivation text,
+        status int4 NOT NULL default '0',
+        PRIMARY KEY (name)
+      )");
+
+      $ret[] = db_query("CREATE TABLE {subversion_files} (
+        fid int4 NOT NULL default '0',
+        pid int4 NOT NULL default '0',
+        mid int4 NOT NULL default '0',
+        revision int4 NOT NULL default '0',
+        action varchar(64) NOT NULL default '',
+        file varchar(255) NOT NULL default '',
+        PRIMARY KEY (fid)
+      )");
+
+      $ret[] = db_query("CREATE TABLE {subversion_messages} (
+        mid int4 NOT NULL default '0',
+        rid int4 NOT NULL default '0',
+        pid int4 NOT NULL default '0',
+        uid int4 NOT NULL default '0',
+        user varchar(255) NOT NULL default '',
+        date int4 NOT NULL default '0',
+        revision int4 NOT NULL default '0',
+        message text NOT NULL,
+        PRIMARY KEY (mid)
+      )");
+
+      $ret[] = db_query("CREATE TABLE {subversion_project_maintainers} (
+        nid int4 NOT NULL default '0',
+        uid int4 NOT NULL default '0',
+        PRIMARY KEY  (nid,uid)
+      )");
+
+      $ret[] = db_query("CREATE TABLE {subversion_projects} (
+        nid int4 NOT NULL default '0',
+        rid int4 NOT NULL default '0',
+        last_revision int4 NOT NULL default '0',
+        trunk_path varchar(128) NOT NULL default '/trunk',
+        tag_path varchar(128) NOT NULL default '/tags',
+        branch_path varchar(128) NOT NULL default '/branches',
+        PRIMARY KEY  (nid)
+      )");
+
+      $ret[] = db_query("CREATE TABLE {subversion_repositories} (
+        rid integer NOT NULL default '0',
+        name varchar(255) NOT NULL default '',
+        root varchar(255) NOT NULL default '',
+        type int4 NOT NULL default '2',
+        diffurl varchar(255) NOT NULL default '',
+        newurl varchar(255) NOT NULL default '',
+        trackerurl varchar(255) NOT NULL default '',
+        method int2 NOT NULL default '0',
+        updated int4 NOT NULL default '0',
+        PRIMARY KEY (rid)
+      )");
       break;
   }