summaryrefslogtreecommitdiff
path: root/database
diff options
context:
space:
mode:
Diffstat (limited to 'database')
-rw-r--r--database/database.mysql1
-rw-r--r--database/database.pgsql1
-rw-r--r--database/updates.inc9
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);