aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSteve Clay <steve@mrclay.org>2013-08-28 15:55:27 -0700
committerSteve Clay <steve@mrclay.org>2013-08-28 15:55:27 -0700
commit7a1095d2e97b4365ddad3a9a109e41fdbc683bf2 (patch)
tree6d19e0a96eba21b30777057157b9e5e54299448c
parent392e8e691066c7a7ca9ef82c24f30ef235e1df93 (diff)
parent3247464f3be9ee7e731adaaec9d53c9d3088b8fa (diff)
downloadelgg-7a1095d2e97b4365ddad3a9a109e41fdbc683bf2.tar.gz
elgg-7a1095d2e97b4365ddad3a9a109e41fdbc683bf2.tar.bz2
Merge pull request #5552 from jeabakker/#251-ipv6-system-log-table
Store IPv6 addresses losslessly in system_log
-rw-r--r--engine/lib/upgrades/2013052900-1.8.15-ipv6_in_syslog-f5c2cc0196e9e731.php12
-rw-r--r--engine/schema/mysql.sql2
-rw-r--r--version.php2
3 files changed, 14 insertions, 2 deletions
diff --git a/engine/lib/upgrades/2013052900-1.8.15-ipv6_in_syslog-f5c2cc0196e9e731.php b/engine/lib/upgrades/2013052900-1.8.15-ipv6_in_syslog-f5c2cc0196e9e731.php
new file mode 100644
index 000000000..d333a6cd2
--- /dev/null
+++ b/engine/lib/upgrades/2013052900-1.8.15-ipv6_in_syslog-f5c2cc0196e9e731.php
@@ -0,0 +1,12 @@
+<?php
+/**
+ * Elgg 1.8.15 upgrade 2013052900
+ * ipv6_in_syslog
+ *
+ * Upgrade the ip column in system_log to be able to store ipv6 addresses
+ */
+
+$db_prefix = elgg_get_config('dbprefix');
+$q = "ALTER TABLE {$db_prefix}system_log MODIFY COLUMN ip_address varchar(46) NOT NULL";
+
+update_data($q); \ No newline at end of file
diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index 6c6e9db89..4714b71bb 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -361,7 +361,7 @@ CREATE TABLE `prefix_system_log` (
`access_id` int(11) NOT NULL,
`enabled` enum('yes','no') NOT NULL DEFAULT 'yes',
`time_created` int(11) NOT NULL,
- `ip_address` varchar(15) NOT NULL,
+ `ip_address` varchar(46) NOT NULL,
PRIMARY KEY (`id`),
KEY `object_id` (`object_id`),
KEY `object_class` (`object_class`),
diff --git a/version.php b/version.php
index f21ea074a..a94bf9d31 100644
--- a/version.php
+++ b/version.php
@@ -11,7 +11,7 @@
// YYYYMMDD = Elgg Date
// XX = Interim incrementer
-$version = 2013051700;
+$version = 2013052900;
// Human-friendly version name
$release = '1.8.16';