diff options
| author | Dries Buytaert <dries@buytaert.net> | 2004-08-03 09:27:00 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2004-08-03 09:27:00 +0000 |
| commit | 0582a304fd0463689857bb07fcc4fffb2f372b3a (patch) | |
| tree | 61c99ecd86ba5e1cf0397777e4101b19b0c2f241 /database | |
| parent | a7a5f51c7e73a2d3cf2d90af3494d5f019c33db4 (diff) | |
| download | brdo-0582a304fd0463689857bb07fcc4fffb2f372b3a.tar.gz brdo-0582a304fd0463689857bb07fcc4fffb2f372b3a.tar.bz2 | |
- Patch by Jeremy: statistics module improvements.
Diffstat (limited to 'database')
| -rw-r--r-- | database/database.mysql | 3 | ||||
| -rw-r--r-- | database/database.pgsql | 3 | ||||
| -rw-r--r-- | database/updates.inc | 11 |
3 files changed, 14 insertions, 3 deletions
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); |