Changeset b2b8b19 in github

Timestamp:

Sep 17, 2009 8:50:54 AM (4 years ago)

Author:

vbenincasa <vbenincasa@…>

Branches:

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

Children:

00a8338

Parents:

cbeea3d

Message:

• Change MySQL data type to avoid problems with big session vars

Location:

SQL

Files:

• mysql.initial.sql (modified) (1 diff)
• mysql.update.sql (modified) (2 diffs)

SQL/mysql.initial.sql

@@ -11 +11 @@
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `ip` varchar(40) NOT NULL,
- `vars` text NOT NULL,
+ `vars` mediumtext NOT NULL,
  PRIMARY KEY(`sess_id`),
  INDEX `changed_index` (`changed`)

SQL/mysql.update.sql

@@ -1 +1 @@
 -- RoundCube Webmail update script for MySQL databases
--- Updates from version 0.1-stable to 0.1.1
+-- Updates from version 0.1-stable to 0.3.1
 
 TRUNCATE TABLE `messages`;
@@ -52 +52 @@
 
 TRUNCATE `messages`;
+
+ALTER TABLE `session` 
+    CHANGE `vars` `vars` MEDIUMTEXT NOT NULL;