From 10c5e95a2fce173d4c13d6df4d9e15d9bb8437f6 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Tue, 18 May 2004 18:41:46 +0000
Subject: - Made it possible for anonymous users to leave their name, e-mail
 address   and the URL of their homepage.  Patch by Pablo.

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

(limited to 'database')

diff --git a/database/database.mysql b/database/database.mysql
index 6d900b653..74e550018 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -185,6 +185,9 @@ CREATE TABLE comments (
   status tinyint(3) unsigned NOT NULL default '0',
   thread varchar(255) NOT NULL,
   users longtext,
+  name varchar(60) default NULL,
+  mail varchar(64) default NULL,
+  homepage varchar(255) default NULL,
   PRIMARY KEY  (cid),
   KEY lid (nid)
 ) TYPE=MyISAM;
diff --git a/database/database.pgsql b/database/database.pgsql
index a3d8a686b..35331592e 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -185,6 +185,9 @@ CREATE TABLE comments (
   status smallint  NOT NULL default '0',
   thread varchar(255) default '',
   users text default '',
+  name varchar(60) default NULL,
+  mail varchar(64) default NULL,
+  url varchar(255) default NULL,
   PRIMARY KEY  (cid)
 );
 CREATE INDEX comments_nid_idx ON comments(nid);
diff --git a/database/updates.inc b/database/updates.inc
index 454127a15..3f604d6fc 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -57,7 +57,8 @@ $sql_updates = array(
   "2004-04-15" => "update_83",
   "2004-04-21" => "update_84",
   "2004-04-27" => "update_85",
-  "2004-05-10" => "update_86"
+  "2004-05-10" => "update_86",
+  "2004-05-18" => "update_87"
 );
 
 function update_32() {
@@ -1084,6 +1085,14 @@ function update_86() {
   return $ret;
 }
 
+function update_87() {
+  $ret = array();
+  $ret[] = update_sql("ALTER TABLE {comments} ADD name varchar(60) DEFAULT NULL");
+  $ret[] = update_sql("ALTER TABLE {comments} ADD mail varchar(64) DEFAULT NULL");
+  $ret[] = update_sql("ALTER TABLE {comments} ADD homepage varchar(255) DEFAULT NULL");
+  return $ret;
+}
+
 function update_sql($sql) {
   $edit = $_POST["edit"];
   $result = db_query($sql);
-- 
cgit v1.2.3