1DROP TABLE page_references;
2
3CREATE TABLE PAGE_REFERENCES
4(
5    PAGE_ID TEXT,
6    REFERENCE TEXT
7);
8
9CREATE UNIQUE INDEX PAGE_REFERENCES_IDX ON PAGE_REFERENCES (PAGE_ID,REFERENCE);
10CREATE INDEX PAGE_REFERENCES_IDX_SOURCE ON PAGE_REFERENCES (PAGE_ID);
11CREATE INDEX PAGE_REFERENCES_IDX_TARGET ON PAGE_REFERENCES (REFERENCE);
12