upgrades/dbpatches/1.6/mysql/patch/node_cksum.sql


1
2
3
4
5
6
7
8
9
10
11

drop table node_cksum;

CREATE TABLE node_cksum (
        nodeid          integer         DEFAULT '0'     NOT NULL,
        tablename               varchar(64)             DEFAULT ''      NOT NULL,
        recordid                bigint unsigned         DEFAULT '0'     NOT NULL,
        cksumtype               integer         DEFAULT '0'     NOT NULL,
        cksum           text            DEFAULT ''      NOT NULL,
        sync            char(128)               DEFAULT ''      NOT NULL
) type=InnoDB;
CREATE INDEX node_cksum_cksum_1 on node_cksum (nodeid,tablename,recordid,cksumtype);