xref: /template/strap/db/combo/update0018.sql (revision 82a60d039cd81033dc8147c27f0a50716b7a5301)

DROP TABLE page_references;

CREATE TABLE PAGE_REFERENCES
(
    PAGE_ID TEXT,
    REFERENCE TEXT
);

CREATE UNIQUE INDEX PAGE_REFERENCES_IDX ON PAGE_REFERENCES (PAGE_ID,REFERENCE);
CREATE INDEX PAGE_REFERENCES_IDX_SOURCE ON PAGE_REFERENCES (PAGE_ID);
CREATE INDEX PAGE_REFERENCES_IDX_TARGET ON PAGE_REFERENCES (REFERENCE);