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