From a7f67e01de1626b8cba850c325ccf12806d312c0 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Fri, 4 Aug 2006 06:58:44 +0000 Subject: - Patch #76681 by sammys: PostgreSQL support for install system. Woot! :) --- modules/profile/profile.install | 30 +++++++++++++++++++++++++++++- 1 file changed, 29 insertions(+), 1 deletion(-) (limited to 'modules/profile') 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 +} -- cgit v1.2.3