diff options
Diffstat (limited to 'database')
-rw-r--r-- | database/database.mysql | 1 | ||||
-rw-r--r-- | database/database.pgsql | 1 | ||||
-rw-r--r-- | database/updates.inc | 9 |
3 files changed, 10 insertions, 1 deletions
diff --git a/database/database.mysql b/database/database.mysql index 9c1efea8c..17d182cdb 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -26,6 +26,7 @@ CREATE TABLE accesslog ( url varchar(255) default NULL, hostname varchar(128) default NULL, uid int(10) unsigned default '0', + timer int(10) unsigned NOT NULL default '0', timestamp int(11) unsigned NOT NULL default '0', KEY accesslog_timestamp (timestamp), PRIMARY KEY (aid) diff --git a/database/database.pgsql b/database/database.pgsql index b0e36f019..d1dc213a5 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -25,6 +25,7 @@ CREATE TABLE accesslog ( url varchar(255) default NULL, hostname varchar(128) default NULL, uid integer default '0', + timer integer NOT NULL default '0', timestamp integer NOT NULL default '0', PRIMARY KEY (aid) ); diff --git a/database/updates.inc b/database/updates.inc index b39ca7c6c..24f9a51dd 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -114,7 +114,8 @@ $sql_updates = array( "2005-05-06" => "update_135", "2005-05-08" => "update_136", "2005-05-09" => "update_137", - "2005-05-10" => "update_138" + "2005-05-10" => "update_138", + "2005-05-11" => "update_139" ); function update_32() { @@ -2482,6 +2483,12 @@ function update_138() { return $ret; } +function update_139() { + $ret = array(); + $ret[] = update_sql("ALTER TABLE {accesslog} ADD timer int(10) unsigned NOT NULL default '0'"); + return $ret; +} + function update_sql($sql) { $edit = $_POST["edit"]; $result = db_query($sql); |