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


1
2
3
4
5
6
7
8
9

CREATE TABLE opconditions (
        opconditionid           bigint unsigned         DEFAULT '0'     NOT NULL,
        operationid             bigint unsigned         DEFAULT '0'     NOT NULL,
        conditiontype           integer         DEFAULT '0'     NOT NULL,
        operator                integer         DEFAULT '0'     NOT NULL,
        value           varchar(255)            DEFAULT ''      NOT NULL,
        PRIMARY KEY (opconditionid)
) type=InnoDB;
CREATE INDEX opconditions_1 on opconditions (operationid);