CREATE UNIQUE INDEX fairway_marks_bcnlat_distinct_rows
    ON waterway.fairway_marks_bcnlat
    ((CAST((validity, last_found, geom,
            datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
            scamin, picrep, txtdsc, sordat, sorind,
            0, colour, colpat, condtn, bcnshp, catlam
        ) AS waterway.fairway_marks_bcnlat)
    ));

CREATE UNIQUE INDEX fairway_marks_boycar_distinct_rows
    ON waterway.fairway_marks_boycar
    ((CAST((validity, last_found, geom,
            datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
            scamin, picrep, txtdsc, sordat, sorind,
            0, colour, colpat, conrad, marsys, boyshp, catcam
        ) AS waterway.fairway_marks_boycar)
    ));

CREATE UNIQUE INDEX fairway_marks_boylat_distinct_rows
    ON waterway.fairway_marks_boylat
    ((CAST((validity, last_found, geom,
            datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
            scamin, picrep, txtdsc, sordat, sorind,
            0, colour, colpat, conrad, marsys, boyshp, catlam
        ) AS waterway.fairway_marks_boylat)
    ));


CREATE UNIQUE INDEX fairway_marks_boysaw_distinct_rows
    ON waterway.fairway_marks_boysaw
    ((CAST((validity, last_found, geom,
            datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
            scamin, picrep, txtdsc, sordat, sorind,
            0, colour, colpat, conrad, marsys, boyshp
        ) AS waterway.fairway_marks_boysaw)
    ));

CREATE UNIQUE INDEX fairway_marks_boyspp_distinct_rows
    ON waterway.fairway_marks_boyspp
    ((CAST((validity, last_found, geom,
            datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
            scamin, picrep, txtdsc, sordat, sorind,
            0, colour, colpat, conrad, marsys, boyshp, catspm
        ) AS waterway.fairway_marks_boyspp)
    ));

CREATE UNIQUE INDEX fairway_marks_daymar_distinct_rows
    ON waterway.fairway_marks_daymar
    ((CAST((validity, last_found, geom,
            datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
            scamin, picrep, txtdsc, sordat, sorind,
            0, colour, colpat, condtn, topshp, orient
        ) AS waterway.fairway_marks_daymar)
    ));

CREATE UNIQUE INDEX fairway_marks_lights_distinct_rows
    ON waterway.fairway_marks_lights
    ((CAST((validity, last_found, geom,
            datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
            scamin, picrep, txtdsc, sordat, sorind,
            0, colour, condtn, orient, catlit, exclit, litchr, litvis,
            mltylt, sectr1, sectr2, siggrp, sigper, sigseq, status
        ) AS waterway.fairway_marks_lights)
    ));

CREATE UNIQUE INDEX fairway_marks_rtpbcn_distinct_rows
    ON waterway.fairway_marks_rtpbcn
    ((CAST((validity, last_found, geom,
            datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
            scamin, picrep, txtdsc, sordat, sorind,
            0, condtn, siggrp, catrtb, radwal
        ) AS waterway.fairway_marks_rtpbcn)
    ));

CREATE UNIQUE INDEX fairway_marks_topmar_distinct_rows
    ON waterway.fairway_marks_topmar
    ((CAST((validity, last_found, geom,
            datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
            scamin, picrep, txtdsc, sordat, sorind,
            0, colour, colpat, condtn, topshp
        ) AS waterway.fairway_marks_topmar)
    ));

CREATE UNIQUE INDEX fairway_marks_notmrk_distinct_rows
    ON waterway.fairway_marks_notmrk
    ((CAST((validity, last_found, geom,
            datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
            scamin, picrep, txtdsc, sordat, sorind,
            0, condtn, marsys, orient, status, addmrk, catnmk,
            disipd, disipu, disbk1, disbk2, fnctnm, bnkwtw
        ) AS waterway.fairway_marks_notmrk)
    ));