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


1
2
3
4
5
6
7
8
9
10
11

-- TODO Populate data from sysmaps_links

CREATE TABLE sysmaps_link_triggers (
        linktriggerid           bigint unsigned         DEFAULT '0'     NOT NULL,
        linkid          bigint unsigned         DEFAULT '0'     NOT NULL,
        triggerid               bigint unsigned         DEFAULT '0'     NOT NULL,
        drawtype                integer         DEFAULT '0'     NOT NULL,
        color           varchar(6)              DEFAULT '000000'        NOT NULL,
        PRIMARY KEY (linktriggerid)
) type=InnoDB;
CREATE UNIQUE INDEX sysmaps_link_triggers_1 on sysmaps_link_triggers (linkid,triggerid);