diff options
| author | Sylvain Rochet <gradator@gradator.net> | 2016-10-09 20:31:24 +0300 |
|---|---|---|
| committer | Sylvain Rochet <gradator@gradator.net> | 2016-10-09 20:47:42 +0300 |
| commit | 492b181d5123bd8a47339c9bdfc9cae3e1b3319c (patch) | |
| tree | 9087272e406338111b4eac8888ac989911c1a582 /SQL | |
| parent | 4936159f31fe64f1fc55f26d32d441237843872e (diff) | |
SQL, upgrade: increase session table ip field size for IPv6 addresses
Commit 84d06edb06 introduced IPv6 support on SQL session table but
failed at providing upgrade SQL scripts, this commit fixes it.
Fixes: 84d06edb06 ("IPv6 Compatability")
Signed-off-by: Sylvain Rochet <gradator@gradator.net>
Diffstat (limited to 'SQL')
| -rw-r--r-- | SQL/mssql/2016100900.sql | 2 | ||||
| -rw-r--r-- | SQL/mysql/2016100900.sql | 1 | ||||
| -rw-r--r-- | SQL/oracle/2016100900.sql | 1 | ||||
| -rw-r--r-- | SQL/postgres/2016100900.sql | 1 |
4 files changed, 5 insertions, 0 deletions
diff --git a/SQL/mssql/2016100900.sql b/SQL/mssql/2016100900.sql new file mode 100644 index 000000000..38b359a48 --- /dev/null +++ b/SQL/mssql/2016100900.sql @@ -0,0 +1,2 @@ +ALTER TABLE [dbo].[session] ALTER COLUMN [ip] [varchar] (40) COLLATE Latin1_General_CI_AI NOT NULL +GO diff --git a/SQL/mysql/2016100900.sql b/SQL/mysql/2016100900.sql new file mode 100644 index 000000000..ea096e9f9 --- /dev/null +++ b/SQL/mysql/2016100900.sql @@ -0,0 +1 @@ +ALTER TABLE `session` MODIFY `ip` varchar(40) NOT NULL; diff --git a/SQL/oracle/2016100900.sql b/SQL/oracle/2016100900.sql new file mode 100644 index 000000000..e92e7eb91 --- /dev/null +++ b/SQL/oracle/2016100900.sql @@ -0,0 +1 @@ +ALTER TABLE session MODIFY ip varchar(41) NOT NULL; diff --git a/SQL/postgres/2016100900.sql b/SQL/postgres/2016100900.sql new file mode 100644 index 000000000..8eb7eedac --- /dev/null +++ b/SQL/postgres/2016100900.sql @@ -0,0 +1 @@ +ALTER TABLE session ALTER COLUMN ip TYPE character varying(41); |