-- @tag: ap_gl
-- @description: Hilfstabelle für automatische GL-Buchung nach Kreditorenbuchung
-- @depends: release_3_5_0
-- @ignore: 0
      CREATE TABLE ap_gl (
        ap_id                   integer,
        gl_id                   integer,
        itime                   TIMESTAMP      DEFAULT now(),
        mtime                   TIMESTAMP,
        PRIMARY KEY (ap_id, gl_id),
        FOREIGN KEY (ap_id)                    REFERENCES ap (id),
        FOREIGN KEY (gl_id)                    REFERENCES gl (id) ON DELETE CASCADE);