[Neo-report] r1970 gregory - /trunk/neo/storage/database/mysqldb.py

[nobody at svn.erp5.org]

Author: gregory
Date: Fri Mar 26 17:20:09 2010
New Revision: 1970

Log:
Use LONGBLOB column type for object values.

BLOB is 2^16 bytes
MEDIUMBLOB is 2^24 bytes
LONGBLOB is 2^32 bytes

Choose LONGBLOB to store bigger objects.

Modified:
    trunk/neo/storage/database/mysqldb.py

Modified: trunk/neo/storage/database/mysqldb.py
==============================================================================
--- trunk/neo/storage/database/mysqldb.py [iso-8859-1] (original)
+++ trunk/neo/storage/database/mysqldb.py [iso-8859-1] Fri Mar 26 17:20:09 2010
@@ -159,7 +159,7 @@
                  serial BIGINT UNSIGNED NOT NULL,
                  compression TINYINT UNSIGNED NOT NULL,
                  checksum INT UNSIGNED NOT NULL,
-                 value MEDIUMBLOB NOT NULL,
+                 value LONGBLOB NOT NULL,
                  PRIMARY KEY (oid, serial)
              ) ENGINE = InnoDB""")
 
@@ -179,7 +179,7 @@
                  serial BIGINT UNSIGNED NOT NULL,
                  compression TINYINT UNSIGNED NOT NULL,
                  checksum INT UNSIGNED NOT NULL,
-                 value MEDIUMBLOB NOT NULL
+                 value LONGBLOB NOT NULL
              ) ENGINE = InnoDB""")
 
     def getConfiguration(self, key):