1 DROP TABLE IF EXISTS proxy;
2 CREATE TABLE proxy (id serial NOT NULL,
3 voter_id INTEGER NOT NULL,
4 proxy_id INTEGER NOT NULL,
5 granted timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
6 granted_by int NOT NULL,
7 revoked timestamp NULL DEFAULT NULL,
8 revoked_by int NULL DEFAULT NULL,
10 CREATE INDEX proxy_voter ON proxy (voter_id);
11 CREATE INDEX proxy_proxy ON proxy (proxy_id);