commit 3ca51c4a7fd8de5ce8f806a66df43bbde9f48b1d Author: Karsten Loesing <karsten.loesing@gmx.net> Date: Thu Mar 22 15:23:08 2012 +0100 Remove now unused database schema parts. --- db/tordir.sql | 21 --------------------- 1 files changed, 0 insertions(+), 21 deletions(-) diff --git a/db/tordir.sql b/db/tordir.sql index e1ca324..e7c33f9 100644 --- a/db/tordir.sql +++ b/db/tordir.sql @@ -18,22 +18,10 @@ CREATE TABLE descriptor ( platform CHARACTER VARYING(256), published TIMESTAMP WITHOUT TIME ZONE NOT NULL, uptime BIGINT, - extrainfo CHARACTER(40), rawdesc BYTEA NOT NULL, CONSTRAINT descriptor_pkey PRIMARY KEY (descriptor) ); --- TABLE extrainfo --- Contains all of the extra-info descriptors published by the routers. -CREATE TABLE extrainfo ( - extrainfo CHARACTER(40) NOT NULL, - nickname CHARACTER VARYING(19) NOT NULL, - fingerprint CHARACTER(40) NOT NULL, - published TIMESTAMP WITHOUT TIME ZONE NOT NULL, - rawdesc BYTEA NOT NULL, - CONSTRAINT extrainfo_pkey PRIMARY KEY (extrainfo) -); - -- Contains bandwidth histories reported by relays in extra-info -- descriptors. Each row contains the reported bandwidth in 15-minute -- intervals for each relay and date. @@ -146,15 +134,6 @@ CREATE TABLE consensus ( CONSTRAINT consensus_pkey PRIMARY KEY (validafter) ); --- TABLE vote --- Contains all of the votes published by the directories -CREATE TABLE vote ( - validafter TIMESTAMP WITHOUT TIME ZONE NOT NULL, - dirsource CHARACTER(40) NOT NULL, - rawdesc BYTEA NOT NULL, - CONSTRAINT vote_pkey PRIMARY KEY (validafter, dirsource) -); - -- TABLE connbidirect -- Contain conn-bi-direct stats strings CREATE TABLE connbidirect (