- Patch #76681 by sammys: PostgreSQL support for install system. Woot! :)

1 files changed, 29 insertions, 1 deletions

diff --git a/modules/profile/profile.install b/modules/profile/profile.install
index 2aa4e46cb..555c0f109 100644
--- a/modules/profile/profile.install
+++ b/modules/profile/profile.install
@@ -31,5 +31,33 @@ function profile_install() {
         KEY uid (uid),
         KEY fid (fid)
       ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
+    case 'pgsql':
+      db_query("CREATE TABLE {profile_fields} (
+        fid serial,
+        title varchar(255) default NULL,
+        name varchar(128) default NULL,
+        explanation TEXT default NULL,
+        category varchar(255) default NULL,
+        page varchar(255) default NULL,
+        type varchar(128) default NULL,
+        weight smallint DEFAULT '0' NOT NULL,
+        required smallint DEFAULT '0' NOT NULL,
+        register smallint DEFAULT '0' NOT NULL,
+        visibility smallint DEFAULT '0' NOT NULL,
+        autocomplete smallint DEFAULT '0' NOT NULL,
+        options text,
+        UNIQUE (name),
+        PRIMARY KEY (fid)
+      )");
+      db_query("CREATE INDEX {profile_fields}_category_idx ON {profile_fields} (category)");
+
+      db_query("CREATE TABLE {profile_values} (
+        fid uint default '0',
+        uid uint default '0',
+        value text
+      )");
+      db_query("CREATE INDEX {profile_values}_uid_idx ON {profile_values} (uid)");
+      db_query("CREATE INDEX {profile_values}_fid_idx ON {profile_values} (fid)");
+      break;
   }
-}
\ No newline at end of file
+}