From 6dbd0bcfb4c79853ca1402d9f85a325853b01411 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sun, 19 Sep 2004 13:28:11 +0000
Subject: - Patch #6500 by Mathias with help from Steven: made it possible to
 add fields to the registration form.  This feature used to exist.

---
 database/database.mysql |  1 +
 database/database.pgsql |  1 +
 database/updates.inc    | 15 ++++++++++++++-
 3 files changed, 16 insertions(+), 1 deletion(-)

(limited to 'database')

diff --git a/database/database.mysql b/database/database.mysql
index 014b63c99..0c716b190 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -448,6 +448,7 @@ CREATE TABLE profile_fields (
   type varchar(128) default NULL,
   weight tinyint(1) DEFAULT '0' NOT NULL,
   required tinyint(1) DEFAULT '0' NOT NULL,
+  register tinyint(1) DEFAULT '0' NOT NULL,
   visibility tinyint(1) DEFAULT '0' NOT NULL,
   options text,
   KEY category (category),
diff --git a/database/database.pgsql b/database/database.pgsql
index 375281dfa..43015661a 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -455,6 +455,7 @@ CREATE TABLE profile_fields (
   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,
   overview smallint DEFAULT '0' NOT NULL,
   options text,
diff --git a/database/updates.inc b/database/updates.inc
index 2435492c9..a012e6095 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -82,7 +82,8 @@ $sql_updates = array(
   "2004-08-17" => "update_103",
   "2004-08-19" => "update_104",
   "2004-09-14" => "update_105",
-  "2004-09-15" => "update_106"
+  "2004-09-15" => "update_106",
+  "2004-09-17" => "update_107"
 );
 
 function update_32() {
@@ -1812,6 +1813,18 @@ function update_106() {
   return $ret;
 }
 
+function update_107() {
+  $ret = array();
+  if ($GLOBALS['db_type'] == 'mysql') {
+    $ret[] = update_sql('ALTER TABLE {profile_fields} ADD register TINYINT(1) DEFAULT 0 NOT NULL AFTER required');
+  }
+  else if ($GLOBALS['db_type'] == 'pgsql') {
+    $ret[] = update_sql('ALTER TABLE {profile_fields} ADD register smallint');
+  }
+
+  return $ret;
+}
+
 function update_sql($sql) {
   $edit = $_POST["edit"];
   $result = db_query($sql);
-- 
cgit v1.2.3