Posted to tcl by jdc at Fri Feb 15 12:06:17 GMT 2013view raw
- 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 INDEX idx_pages_date ON pages(date)
- CREATE TABLE pages_content (
- id INT NOT NULL,
- content TEXT NOT NULL,
- PRIMARY KEY (id),
- FOREIGN KEY (id) REFERENCES pages(id));
- 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));