[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_herald.herald_ruleapplied (
   2    ruleID int unsigned not null,
   3    phid varchar(64) binary not null,
   4    PRIMARY KEY(ruleID, phid)
   5  ) ENGINE=InnoDB;
   6  
   7  ALTER TABLE {$NAMESPACE}_herald.herald_rule add repetitionPolicy int unsigned;