summaryrefslogtreecommitdiff
path: root/database
diff options
context:
space:
mode:
Diffstat (limited to 'database')
-rw-r--r--database/database.mysql4
-rw-r--r--database/database.pgsql5
-rw-r--r--database/updates.inc26
3 files changed, 32 insertions, 3 deletions
diff --git a/database/database.mysql b/database/database.mysql
index 9f2ef285f..0be5db11f 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -20,13 +20,15 @@ CREATE TABLE access (
--
CREATE TABLE accesslog (
+ aid tinyint(10) NOT NULL auto_increment,
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',
timestamp int(11) unsigned NOT NULL default '0',
- KEY accesslog_timestamp (timestamp)
+ KEY accesslog_timestamp (timestamp),
+ PRIMARY KEY (aid)
) TYPE=MyISAM;
--
diff --git a/database/database.pgsql b/database/database.pgsql
index 92ba88c67..df50d5d84 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -18,12 +18,15 @@ CREATE TABLE access (
--
CREATE TABLE accesslog (
+ aid SERIAL,
+ mask varchar(255) NOT NULL default '',
title varchar(255) default NULL,
path varchar(255) default NULL,
url varchar(255) default NULL,
hostname varchar(128) default NULL,
uid integer default '0',
- timestamp integer NOT NULL default '0'
+ timestamp integer NOT NULL default '0',
+ PRIMARY KEY (aid)
);
CREATE INDEX accesslog_timestamp_idx ON accesslog (timestamp);
diff --git a/database/updates.inc b/database/updates.inc
index c5881f8d3..a0b1097e9 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -88,7 +88,8 @@ $sql_updates = array(
"2004-10-18" => "update_109",
"2004-10-31: first update since Drupal 4.5.0 release" => "update_110",
"2004-11-07" => "update_111",
- "2004-11-15" => "update_112"
+ "2004-11-15" => "update_112",
+ "2004-11-28" => "update_113"
);
function update_32() {
@@ -1991,6 +1992,29 @@ function update_112() {
return $ret;
}
+function update_113() {
+ $ret = array();
+
+ if ($GLOBALS['db_type'] == 'mysql') {
+ $ret[] = update_sql('DROP TABLE {accesslog}');
+ $ret[] = update_sql("CREATE TABLE {accesslog} (
+ aid tinyint(10) NOT NULL auto_increment,
+ 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',
+ timestamp int(11) unsigned NOT NULL default '0',
+ KEY accesslog_timestamp (timestamp),
+ PRIMARY KEY (aid))");
+ }
+
+ // Flush the menu cache:
+ cache_clear_all('menu:', TRUE);
+
+ return $ret;
+}
+
function update_sql($sql) {
$edit = $_POST["edit"];
$result = db_query($sql);