diff options
| author | Steve Clay <steve@mrclay.org> | 2013-08-28 15:55:27 -0700 |
|---|---|---|
| committer | Steve Clay <steve@mrclay.org> | 2013-08-28 15:55:27 -0700 |
| commit | 7a1095d2e97b4365ddad3a9a109e41fdbc683bf2 (patch) | |
| tree | 6d19e0a96eba21b30777057157b9e5e54299448c /engine | |
| parent | 392e8e691066c7a7ca9ef82c24f30ef235e1df93 (diff) | |
| parent | 3247464f3be9ee7e731adaaec9d53c9d3088b8fa (diff) | |
| download | elgg-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
Diffstat (limited to 'engine')
| -rw-r--r-- | engine/lib/upgrades/2013052900-1.8.15-ipv6_in_syslog-f5c2cc0196e9e731.php | 12 | ||||
| -rw-r--r-- | engine/schema/mysql.sql | 2 |
2 files changed, 13 insertions, 1 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`), |