Posted to tcl by colin at Wed Jan 09 23:50:29 GMT 2013view raw

  1. CREATE TABLE changes (
  2. id INT NOT NULL,
  3. cid INT NOT NULL,
  4. date INT NOT NULL,
  5. who TEXT NOT NULL,
  6. delta TEXT NOT NULL,
  7. PRIMARY KEY (id, cid),
  8. FOREIGN KEY (id) REFERENCES pages(id));
  9. CREATE TABLE changes_binary (
  10. id INT NOT NULL,
  11. cid INT NOT NULL,
  12. date INT NOT NULL,
  13. who TEXT NOT NULL,
  14. type TEXT,
  15. content BLOB NOT NULL,
  16. PRIMARY KEY (id, cid),
  17. FOREIGN KEY (id) REFERENCES pages(id));
  18. CREATE TABLE diffs (
  19. id INT NOT NULL,
  20. cid INT NOT NULL,
  21. did INT NOT NULL,
  22. fromline INT NOT NULL,
  23. toline INT NOT NULL,
  24. old TEXT NOT NULL,
  25. PRIMARY KEY (id, cid, did),
  26. FOREIGN KEY (id, cid) REFERENCES changes(id, cid));
  27. CREATE TABLE pages (
  28. id INT NOT NULL,
  29. name TEXT NOT NULL,
  30. date INT NOT NULL,
  31. who TEXT NOT NULL, type TEXT,
  32. PRIMARY KEY (id));
  33. CREATE TABLE pages_binary (
  34. id INT NOT NULL,
  35. content BLOB NOT NULL,
  36. PRIMARY KEY (id),
  37. FOREIGN KEY (id) REFERENCES pages(id));
  38. CREATE TABLE pages_content (
  39. id INT NOT NULL,
  40. content TEXT NOT NULL,
  41. PRIMARY KEY (id),
  42. FOREIGN KEY (id) REFERENCES pages(id));
  43. CREATE VIRTUAL TABLE pages_content_fts USING fts4(id,name,content);
  44. CREATE TABLE 'pages_content_fts_content'(docid INTEGER PRIMARY KEY, 'c0id', 'c1name', 'c2content');
  45. CREATE TABLE 'pages_content_fts_docsize'(docid INTEGER PRIMARY KEY, size BLOB);
  46. CREATE TABLE 'pages_content_fts_segdir'(level INTEGER,idx INTEGER,start_block INTEGER,leaves_end_block INTEGER,end_block INTEGER,root BLOB,PRIMARY KEY(level, idx));
  47. CREATE TABLE 'pages_content_fts_segments'(blockid INTEGER PRIMARY KEY, block BLOB);
  48. CREATE TABLE 'pages_content_fts_stat'(id INTEGER PRIMARY KEY, value BLOB);
  49. CREATE TABLE refs (
  50. fromid INT NOT NULL,
  51. toid INT NOT NULL,
  52. PRIMARY KEY (fromid, toid),
  53. FOREIGN KEY (fromid) references pages(id),
  54. FOREIGN KEY (toid) references pages(id));
  55. CREATE INDEX idx_pages_date ON pages(date);
  56. CREATE INDEX refs_toid_index ON refs (toid);