summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--database/database.mysql10
-rw-r--r--database/database.pgsql10
-rw-r--r--database/updates.inc15
3 files changed, 34 insertions, 1 deletions
diff --git a/database/database.mysql b/database/database.mysql
index 7e8478852..767ea08e2 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -263,6 +263,16 @@ CREATE TABLE filters (
) TYPE=MyISAM;
--
+-- Table structure for table 'flood'
+--
+
+CREATE TABLE flood (
+ event varchar(64) NOT NULL default '',
+ hostname varchar(128) NOT NULL default '',
+ timestamp int(11) NOT NULL default '0'
+) TYPE=MyISAM;
+
+--
-- Table structure for table 'forum'
--
diff --git a/database/database.pgsql b/database/database.pgsql
index d5f11c30c..1ebd958d5 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -264,6 +264,16 @@ CREATE TABLE filters (
CREATE INDEX filters_module_idx ON filters(module);
--
+-- Table structure for table 'flood'
+--
+
+CREATE TABLE flood (
+ event varchar(64) NOT NULL default '',
+ hostname varchar(128) NOT NULL default '',
+ timestamp int(11) NOT NULL default '0'
+);
+
+--
-- Table structure for table 'forum'
--
diff --git a/database/updates.inc b/database/updates.inc
index ed9f1a95e..c5881f8d3 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -87,7 +87,8 @@ $sql_updates = array(
"2004-10-16" => "update_108",
"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-07" => "update_111",
+ "2004-11-15" => "update_112"
);
function update_32() {
@@ -1978,6 +1979,18 @@ function update_111() {
return $ret;
}
+function update_112() {
+ $ret = array();
+
+ $ret[] = update_sql("CREATE TABLE flood (
+ event varchar(64) NOT NULL default '',
+ hostname varchar(128) NOT NULL default '',
+ timestamp int(11) NOT NULL default '0'
+ );");
+
+ return $ret;
+}
+
function update_sql($sql) {
$edit = $_POST["edit"];
$result = db_query($sql);