From bddd9aeb6fdc95f8e40c002ca18dfb10eebb38d9 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Fri, 12 May 2006 08:50:22 +0000
Subject: - Patch #51506 by gordon: new feature: added auto-complete
 functionality to user profiles.

---
 database/database.4.0.mysql |  1 +
 database/database.4.1.mysql |  1 +
 database/database.pgsql     |  1 +
 database/updates.inc        | 14 ++++++++++++++
 4 files changed, 17 insertions(+)

(limited to 'database')

diff --git a/database/database.4.0.mysql b/database/database.4.0.mysql
index b4a4dcc4f..dfd96323c 100644
--- a/database/database.4.0.mysql
+++ b/database/database.4.0.mysql
@@ -475,6 +475,7 @@ CREATE TABLE profile_fields (
   required tinyint(1) DEFAULT '0' NOT NULL,
   register tinyint(1) DEFAULT '0' NOT NULL,
   visibility tinyint(1) DEFAULT '0' NOT NULL,
+  autocomplete tinyint(1) DEFAULT '0' NOT NULL,
   options text,
   KEY category (category),
   UNIQUE KEY name (name),
diff --git a/database/database.4.1.mysql b/database/database.4.1.mysql
index 52eebe6e3..8c2c3318f 100644
--- a/database/database.4.1.mysql
+++ b/database/database.4.1.mysql
@@ -506,6 +506,7 @@ CREATE TABLE profile_fields (
   required tinyint(1) DEFAULT '0' NOT NULL,
   register tinyint(1) DEFAULT '0' NOT NULL,
   visibility tinyint(1) DEFAULT '0' NOT NULL,
+  autocomplete tinyint(1) DEFAULT '0' NOT NULL,
   options text,
   KEY category (category),
   UNIQUE KEY name (name),
diff --git a/database/database.pgsql b/database/database.pgsql
index f68419255..c2449b591 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -482,6 +482,7 @@ CREATE TABLE profile_fields (
   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)
diff --git a/database/updates.inc b/database/updates.inc
index 658f7103d..ecb8384eb 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -1973,3 +1973,17 @@ function system_update_180() {
 
   return $ret;
 }
+
+function system_update_181() {
+  $ret = array();
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      $ret[] = update_sql("ALTER TABLE {profile_fields} ADD autocomplete TINYINT(1) NOT NULL AFTER visibility ;");
+      break;
+    case 'pgsql':
+      db_add_column($ret, 'profile_fields', 'autocomplete', 'smallint');
+      break;
+  }
+  return $ret;
+}
-- 
cgit v1.2.3