[ZODB-Dev] RelStorage - what tables and indexes should be present?

Stephan Richter srichter at cosmos.phy.tufts.edu
Tue Feb 1 09:42:22 EST 2011


On Tuesday, February 01, 2011, Chris Withers wrote:
> I also note that while the ones with lots of tables have this schema for 
> object_state:
> 
> CREATE TABLE `object_state` (
>    `zoid` bigint(20) NOT NULL,
>    `tid` bigint(20) NOT NULL,
>    `state` longblob,
>    PRIMARY KEY (`zoid`)
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1$$
> 
> ...the one with only two tables has this schema:
> 
> CREATE TABLE `object_state` (
>    `zoid` bigint(20) NOT NULL,
>    `tid` bigint(20) NOT NULL,
>    `state` longblob,
>    PRIMARY KEY (`zoid`)
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1$$

Did you paste correctly? They seem identical to me.

Regards,
Stephan
-- 
Entrepreneur and Software Geek
Google me. "Zope Stephan Richter"


More information about the ZODB-Dev mailing list