Index: C:/Documents and Settings/gehren/My Documents/workspace/neurovation/sites/all/modules/profile_privacy/profile_privacy.install =================================================================== --- C:/Documents and Settings/gehren/My Documents/workspace/neurovation/sites/all/modules/profile_privacy/profile_privacy.install (revision 19819) +++ C:/Documents and Settings/gehren/My Documents/workspace/neurovation/sites/all/modules/profile_privacy/profile_privacy.install (working copy) @@ -21,6 +21,14 @@ KEY uid (uid), KEY fid (fid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); + + db_query("CREATE TABLE {profile_privacy_user_setting} ( + setting int unsigned default '0', + uid int unsigned default '0', + value tinyint DEFAULT '0' NOT NULL, + KEY uid (uid), + KEY fid (setting) + ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); break; case 'pgsql': @@ -34,9 +42,18 @@ db_query("CREATE TABLE {profile_privacy_values} ( fid int_unsigned default '0', uid int_unsigned default '0', + private int default '0' )"); db_query("CREATE INDEX {profile_privacy_values}_uid_idx ON {profile_privacy_values} (uid)"); db_query("CREATE INDEX {profile_privacy_values}_fid_idx ON {profile_privacy_values} (fid)"); + + db_query("CREATE TABLE {profile_privacy_user_setting} ( + setting int_unsigned default '0', + uid int_unsigned default '0', + value int_unsigend default '0' + )"); + db_query("CREATE INDEX {profile_privacy_values}_uid_idx ON {profile_privacy_values} (uid)"); + db_query("CREATE INDEX {profile_privacy_values}_fid_idx ON {profile_privacy_values} (fid)"); break; } profile_privacy_legacy_update(); @@ -48,6 +65,7 @@ function profile_privacy_uninstall() { db_query('DROP TABLE {profile_privacy_fields}'); db_query('DROP TABLE {profile_privacy_values}'); + db_query('DROP TABLE {profile_privacy_user_setting}'); } /**