diff options
| author | Dries Buytaert <dries@buytaert.net> | 2004-09-19 13:28:11 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2004-09-19 13:28:11 +0000 |
| commit | 6dbd0bcfb4c79853ca1402d9f85a325853b01411 (patch) | |
| tree | 6cc1058b101a67015b722e0affb29a21b5d729d6 /database | |
| parent | 0ca171f2a9e802c150b30390bad218208458d33a (diff) | |
| download | brdo-6dbd0bcfb4c79853ca1402d9f85a325853b01411.tar.gz brdo-6dbd0bcfb4c79853ca1402d9f85a325853b01411.tar.bz2 | |
- Patch #6500 by Mathias with help from Steven: made it possible to add fields to the registration form. This feature used to exist.
Diffstat (limited to 'database')
| -rw-r--r-- | database/database.mysql | 1 | ||||
| -rw-r--r-- | database/database.pgsql | 1 | ||||
| -rw-r--r-- | database/updates.inc | 15 |
3 files changed, 16 insertions, 1 deletions
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); |