Changeset 84d06ed in github

Timestamp:

Sep 19, 2007 2:55:05 AM (6 years ago)

Author:

thomascube <thomas@…>

Branches:

master, HEAD, courier-fix, dev-browser-capabilities, pdo, release-0.6, release-0.7, release-0.8

Children:

aca3d25

Parents:

4d0413d

Message:

IPv6 Compatability

Location:

SQL

Files:

• mssql.initial.sql (modified) (1 diff)
• mysql.initial.sql (modified) (1 diff)
• mysql.update-0.1a.sql (modified) (1 diff)
• mysql.update.sql (modified) (1 diff)
• mysql5.initial.sql (modified) (1 diff)
• postgres.initial.sql (modified) (1 diff)
• sqlite.initial.sql (modified) (1 diff)

SQL/mssql.initial.sql

@@ -59 +59 @@
         [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]

SQL/mysql.initial.sql

@@ -74 +74 @@
   `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`)

SQL/mysql.update-0.1a.sql

@@ -3 +3 @@
 
 
-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;
 

SQL/mysql.update.sql

@@ -13 +13 @@
   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`

SQL/mysql5.initial.sql

@@ -13 +13 @@
  `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`)

SQL/postgres.initial.sql

@@ -37 +37 @@
     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
 );

SQL/sqlite.initial.sql

@@ -94 +94 @@
   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
 );