diff options
| -rw-r--r-- | SQL/mssql.initial.sql | 2 | ||||
| -rw-r--r-- | SQL/mysql.initial.sql | 2 | ||||
| -rw-r--r-- | SQL/mysql.update-0.1a.sql | 2 | ||||
| -rw-r--r-- | SQL/mysql.update.sql | 2 | ||||
| -rw-r--r-- | SQL/mysql5.initial.sql | 2 | ||||
| -rw-r--r-- | SQL/postgres.initial.sql | 2 | ||||
| -rw-r--r-- | SQL/sqlite.initial.sql | 2 |
7 files changed, 8 insertions, 6 deletions
diff --git a/SQL/mssql.initial.sql b/SQL/mssql.initial.sql index 59916e81f..f3b5d5ca7 100644 --- a/SQL/mssql.initial.sql +++ b/SQL/mssql.initial.sql @@ -58,7 +58,7 @@ CREATE TABLE [dbo].[session] ( [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 4a92734d5..4bba84c6a 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -73,7 +73,7 @@ CREATE TABLE `session` ( `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 054814af5..60f22b3d6 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 27d45ebad..e904be278 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -12,6 +12,8 @@ ALTER TABLE `messages` 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 aeec961ad..79817691e 100644 --- a/SQL/mysql5.initial.sql +++ b/SQL/mysql5.initial.sql @@ -12,7 +12,7 @@ CREATE TABLE `session` ( `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 bf82b9b5d..356a579fc 100644 --- a/SQL/postgres.initial.sql +++ b/SQL/postgres.initial.sql @@ -36,7 +36,7 @@ CREATE TABLE "session" ( 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 fd2a22f77..4ae752983 100644 --- a/SQL/sqlite.initial.sql +++ b/SQL/sqlite.initial.sql @@ -93,7 +93,7 @@ CREATE TABLE session ( 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 ); |