Posted to tcl by jdc at Fri Feb 15 12:06:17 GMT 2013view raw

  1. CREATE TABLE pages (
  2. id INT NOT NULL,
  3. name TEXT NOT NULL,
  4. date INT NOT NULL,
  5. who TEXT NOT NULL,
  6. type TEXT,
  7. PRIMARY KEY (id));
  8. CREATE INDEX idx_pages_date ON pages(date)
  9.  
  10. CREATE TABLE pages_content (
  11. id INT NOT NULL,
  12. content TEXT NOT NULL,
  13. PRIMARY KEY (id),
  14. FOREIGN KEY (id) REFERENCES pages(id));
  15.  
  16. CREATE TABLE refs (
  17. fromid INT NOT NULL,
  18. toid INT NOT NULL,
  19. PRIMARY KEY (fromid, toid),
  20. FOREIGN KEY (fromid) references pages(id),
  21. FOREIGN KEY (toid) references pages(id));