From 84d06edb06433c980dc7718188fcdd0799b08c09 Mon Sep 17 00:00:00 2001
From: thomascube <thomas@roundcube.net>
Date: Wed, 19 Sep 2007 02:55:05 -0400
Subject: [PATCH] IPv6 Compatability
---
SQL/mysql5.initial.sql | 2 +-
SQL/mysql.update-0.1a.sql | 2 +-
SQL/mysql.update.sql | 2 ++
SQL/postgres.initial.sql | 2 +-
SQL/mysql.initial.sql | 2 +-
SQL/sqlite.initial.sql | 2 +-
SQL/mssql.initial.sql | 2 +-
7 files changed, 8 insertions(+), 6 deletions(-)
diff --git a/SQL/mssql.initial.sql b/SQL/mssql.initial.sql
index 59916e8..f3b5d5c 100644
--- a/SQL/mssql.initial.sql
+++ b/SQL/mssql.initial.sql
@@ -58,7 +58,7 @@
[sess_id] [varchar] (32) COLLATE Latin1_General_CI_AI NOT NULL ,
[created] [datetime] NOT NULL ,
[changed] [datetime] NULL ,
- [ip] [varchar] (15) COLLATE Latin1_General_CI_AI NOT NULL ,
+ [ip] [varchar] (40) COLLATE Latin1_General_CI_AI NOT NULL ,
[vars] [text] COLLATE Latin1_General_CI_AI NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql
index 4a92734..4bba84c 100644
--- a/SQL/mysql.initial.sql
+++ b/SQL/mysql.initial.sql
@@ -73,7 +73,7 @@
`sess_id` varchar(40) NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`changed` datetime NOT NULL default '0000-00-00 00:00:00',
- `ip` VARCHAR(15) NOT NULL default '',
+ `ip` VARCHAR(40) NOT NULL default '',
`vars` text NOT NULL,
PRIMARY KEY (`sess_id`)
);
diff --git a/SQL/mysql.update-0.1a.sql b/SQL/mysql.update-0.1a.sql
index 054814a..60f22b3 100644
--- a/SQL/mysql.update-0.1a.sql
+++ b/SQL/mysql.update-0.1a.sql
@@ -2,7 +2,7 @@
-- Updates from version 0.1-20051007
-ALTER TABLE `session` ADD `ip` VARCHAR(15) NOT NULL AFTER changed;
+ALTER TABLE `session` ADD `ip` VARCHAR(40) NOT NULL AFTER changed;
ALTER TABLE `users` ADD `alias` VARCHAR(128) NOT NULL AFTER mail_host;
diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
index 27d45eb..e904be2 100644
--- a/SQL/mysql.update.sql
+++ b/SQL/mysql.update.sql
@@ -12,6 +12,8 @@
ALTER TABLE `identities`
ADD `html_signature` tinyint(1) default 0 NOT NULL;
+ALTER TABLE `session` CHANGE `ip` `ip` VARCHAR(40)
+
-- Uncomment these lines if you're using MySQL 4.1 or higher
-- ALTER TABLE `users`
-- DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci,
diff --git a/SQL/mysql5.initial.sql b/SQL/mysql5.initial.sql
index aeec961..7981769 100644
--- a/SQL/mysql5.initial.sql
+++ b/SQL/mysql5.initial.sql
@@ -12,7 +12,7 @@
`sess_id` varchar(40) NOT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `ip` varchar(15) NOT NULL,
+ `ip` varchar(40) NOT NULL,
`vars` text NOT NULL,
PRIMARY KEY(`sess_id`)
) TYPE=MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
diff --git a/SQL/postgres.initial.sql b/SQL/postgres.initial.sql
index bf82b9b..356a579 100644
--- a/SQL/postgres.initial.sql
+++ b/SQL/postgres.initial.sql
@@ -36,7 +36,7 @@
sess_id character varying(40) DEFAULT ''::character varying PRIMARY KEY,
created timestamp with time zone DEFAULT now() NOT NULL,
changed timestamp with time zone DEFAULT now() NOT NULL,
- ip character varying(16) NOT NULL,
+ ip character varying(41) NOT NULL,
vars text NOT NULL
);
diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql
index fd2a22f..4ae7529 100644
--- a/SQL/sqlite.initial.sql
+++ b/SQL/sqlite.initial.sql
@@ -93,7 +93,7 @@
sess_id varchar(40) NOT NULL PRIMARY KEY,
created datetime NOT NULL default '0000-00-00 00:00:00',
changed datetime NOT NULL default '0000-00-00 00:00:00',
- ip varchar(15) NOT NULL default '',
+ ip varchar(40) NOT NULL default '',
vars text NOT NULL
);
--
Gitblit v1.9.1