--------------------------------------------------
-- New tables for SU24 diffs
-- Created 20100705
--------------------------------------------------

CREATE TABLE IF NOT EXISTS `su24_diff_object` (
`event_id` BIGINT( 20 ) NOT NULL ,
`diff` CHAR( 1 ) NOT NULL ,
`flag` CHAR( 1 ) NOT NULL ,
PRIMARY KEY ( `event_id` , `diff` )
) ENGINE = innodb CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE IF NOT EXISTS `su24_diff_value` (
`event_id` BIGINT( 20 ) NOT NULL ,
`diff` CHAR( 1 ) NOT NULL ,
`field` VARCHAR( 10 ) NOT NULL ,
`low` VARCHAR( 40 ) NOT NULL ,
`high` VARCHAR( 40 ) NULL ,
PRIMARY KEY ( `event_id` , `diff` , `field` , `low` )
) ENGINE = innodb CHARACTER SET utf8 COLLATE utf8_general_ci;
