1-- keeps the title of pages for easy selection 2CREATE TABLE titles ( 3 pid NOT NULL, 4 title NOT NULL, 5 PRIMARY KEY(pid) 6); 7 8-- fill with page names 9INSERT INTO titles SELECT DISTINCT pid, pid FROM schema_assignments; 10