From 0582a304fd0463689857bb07fcc4fffb2f372b3a Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Tue, 3 Aug 2004 09:27:00 +0000
Subject: - Patch by Jeremy: statistics module improvements.

---
 database/database.mysql |  3 ++-
 database/database.pgsql |  3 ++-
 database/updates.inc    | 11 ++++++++++-
 3 files changed, 14 insertions(+), 3 deletions(-)

(limited to 'database')

diff --git a/database/database.mysql b/database/database.mysql
index e8f9034f3..ccc917d24 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -21,7 +21,8 @@ CREATE TABLE access (
 --
 
 CREATE TABLE accesslog (
-  nid int(11) unsigned default '0',
+  title varchar(255) default NULL,
+  path varchar(255) default NULL,
   url varchar(255) default NULL,
   hostname varchar(128) default NULL,
   uid int(10) unsigned default '0',
diff --git a/database/database.pgsql b/database/database.pgsql
index 8fbf9ad24..758ab7bd6 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -19,7 +19,8 @@ CREATE TABLE access (
 --
 
 CREATE TABLE accesslog (
-  nid integer default '0',
+  title varchar(255) default NULL,
+  path varchar(255) default NULL,
   url varchar(255) default NULL,
   hostname varchar(128) default NULL,
   uid integer default '0',
diff --git a/database/updates.inc b/database/updates.inc
index 4b14a2510..1ab576a0c 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -66,7 +66,8 @@ $sql_updates = array(
   "2004-07-07" => "update_92",
   "2004-07-11" => "update_93",
   "2004-07-22" => "update_94",
-  "2004-07-30" => "update_95"
+  "2004-07-30" => "update_95",
+  "2004-08-04" => "update_96"
 );
 
 function update_32() {
@@ -1204,6 +1205,14 @@ function update_95() {
   return $ret;
 }
 
+function update_96() {
+  $ret = array();
+  $ret[] = update_sql('ALTER TABLE {accesslog} DROP nid');
+  $ret[] = update_sql('ALTER TABLE {accesslog} ADD title VARCHAR(255) DEFAULT NULL');
+  $ret[] = update_sql('ALTER TABLE {accesslog} ADD path VARCHAR(255) DEFAULT NULL');
+  return $ret;
+}
+
 function update_sql($sql) {
   $edit = $_POST["edit"];
   $result = db_query($sql);
-- 
cgit v1.2.3