Posted to tcl by colin at Wed Jan 09 23:50:29 GMT 2013view raw
- CREATE TABLE changes (
- id INT NOT NULL,
- cid INT NOT NULL,
- date INT NOT NULL,
- who TEXT NOT NULL,
- delta TEXT NOT NULL,
- PRIMARY KEY (id, cid),
- FOREIGN KEY (id) REFERENCES pages(id));
- CREATE TABLE changes_binary (
- id INT NOT NULL,
- cid INT NOT NULL,
- date INT NOT NULL,
- who TEXT NOT NULL,
- type TEXT,
- content BLOB NOT NULL,
- PRIMARY KEY (id, cid),
- FOREIGN KEY (id) REFERENCES pages(id));
- CREATE TABLE diffs (
- id INT NOT NULL,
- cid INT NOT NULL,
- did INT NOT NULL,
- fromline INT NOT NULL,
- toline INT NOT NULL,
- old TEXT NOT NULL,
- PRIMARY KEY (id, cid, did),
- FOREIGN KEY (id, cid) REFERENCES changes(id, cid));
- CREATE TABLE pages (
- id INT NOT NULL,
- name TEXT NOT NULL,
- date INT NOT NULL,
- who TEXT NOT NULL, type TEXT,
- PRIMARY KEY (id));
- CREATE TABLE pages_binary (
- id INT NOT NULL,
- content BLOB NOT NULL,
- PRIMARY KEY (id),
- FOREIGN KEY (id) REFERENCES pages(id));
- CREATE TABLE pages_content (
- id INT NOT NULL,
- content TEXT NOT NULL,
- PRIMARY KEY (id),
- FOREIGN KEY (id) REFERENCES pages(id));
- CREATE VIRTUAL TABLE pages_content_fts USING fts4(id,name,content);
- CREATE TABLE 'pages_content_fts_content'(docid INTEGER PRIMARY KEY, 'c0id', 'c1name', 'c2content');
- CREATE TABLE 'pages_content_fts_docsize'(docid INTEGER PRIMARY KEY, size BLOB);
- 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));
- CREATE TABLE 'pages_content_fts_segments'(blockid INTEGER PRIMARY KEY, block BLOB);
- CREATE TABLE 'pages_content_fts_stat'(id INTEGER PRIMARY KEY, value BLOB);
- CREATE TABLE refs (
- fromid INT NOT NULL,
- toid INT NOT NULL,
- PRIMARY KEY (fromid, toid),
- FOREIGN KEY (fromid) references pages(id),
- FOREIGN KEY (toid) references pages(id));
- CREATE INDEX idx_pages_date ON pages(date);
- CREATE INDEX refs_toid_index ON refs (toid);