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