diff options
| author | jonessouza <47584042+jonessouza@users.noreply.github.com> | 2025-06-13 23:27:39 +0000 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-06-13 23:27:39 +0000 |
| commit | 7a487e2d01e5839d128321db77b9c50911da7923 (patch) | |
| tree | f7935efc8932e175133b2dd758c1cd1618341eef | |
| parent | ca414b97d5d142fcbdf67491c517faf0fe248293 (diff) | |
| download | boca-7a487e2d01e5839d128321db77b9c50911da7923.tar.gz boca-7a487e2d01e5839d128321db77b9c50911da7923.zip | |
Fix campo logip flog.php
O campo "loipg" com tamanho (20) não tem espaço suficiente para armazenar um IP do tipo ipv6.
Solução:
ALTER TABLE logtable
ALTER COLUMN logip TYPE VARCHAR(160);
| -rw-r--r-- | src/flog.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/flog.php b/src/flog.php index ca168f0..ea6805d 100644 --- a/src/flog.php +++ b/src/flog.php @@ -31,7 +31,7 @@ CREATE TABLE \"logtable\" ( \"contestnumber\" int4 NOT NULL, -- (id do concurso) \"sitenumber\" int4 NOT NULL, -- (id do site local) \"loguser\" int4, -- (usuario envolvido com o log) - \"logip\" varchar(20) NOT NULL, -- (numero do site do usuario envolvido) + \"logip\" varchar(160) NOT NULL, -- (numero do site do usuario envolvido) \"logdate\" int4 NOT NULL, -- (dia/hora da criacao deste registro) \"logtype\" varchar(20) NOT NULL, -- (tipo de registro: error, warn, info, debug) \"logdata\" text NOT NULL, -- (descricao do registro) |