-- Workstation links for routing operations (productionrules module)

CREATE TABLE llx_productionrules_routing_wc (
    rowid          integer AUTO_INCREMENT PRIMARY KEY,
    fk_routing     integer NOT NULL,
    fk_workstation integer NOT NULL
) ENGINE=innodb;

ALTER TABLE llx_productionrules_routing_wc ADD UNIQUE INDEX uq_prouting_wc (fk_routing, fk_workstation);
ALTER TABLE llx_productionrules_routing_wc ADD INDEX idx_proutingwc_workstation (fk_workstation);
