diff options
Diffstat (limited to 'database/database.pgsql')
| -rw-r--r-- | database/database.pgsql | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/database/database.pgsql b/database/database.pgsql index 6278a766a..7883dd06c 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -531,12 +531,24 @@ CREATE INDEX permission_rid_idx ON permission(rid); CREATE TABLE poll ( nid integer NOT NULL default '0', runtime integer NOT NULL default '0', - polled text NOT NULL default '', active integer NOT NULL default '0', PRIMARY KEY (nid) ); -- +-- Table structure for poll_votes +-- + +CREATE TABLE poll_votes ( + nid int(10) NOT NULL, + uid int(10) NOT NULL, + hostname varchar(128) NOT NULL +); +CREATE INDEX poll_voter_nid_idx ON poll_votes (nid); +CREATE INDEX poll_votes_uid_idx ON poll_votes (uid); +CREATE INDEX poll_votes_hostname_idx ON poll_votes (hostname); + +-- -- Table structure for poll_choices -- |