This is an automated email from the ASF dual-hosted git repository. gstein pushed a commit to branch trunk in repository https://gitbox.apache.org/repos/asf/steve.git
commit 7fa4d1e1e091d2f92616f34e76ae329b9a1ba087 Author: Greg Stein <[email protected]> AuthorDate: Sun May 29 18:10:46 2022 -0500 add a CLOSED flag to the election metadata --- v3/schema.sql | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/v3/schema.sql b/v3/schema.sql index 2284871..73b12a9 100644 --- a/v3/schema.sql +++ b/v3/schema.sql @@ -36,7 +36,6 @@ CREATE TABLE METADATA ( /* Title of this election. */ title TEXT NOT NULL, - /* ### should we include a start/stop time? */ /* ### if we have monitors, they go here. */ /* ### maybe add an owner? */ @@ -47,7 +46,12 @@ CREATE TABLE METADATA ( /* If this Election has been opened for voting, then we store the OpenedKey here to avoid recomputing. 32 bytes. This will be NULL until the Election is opened. */ - opened_key BLOB + opened_key BLOB, + + /* Has this election been closed? NULL or 0 for not-closed (see + SALT and OPENED_KEY to determine if the election has been + opened). 1 for closed (implies it was opened). */ + closed INTEGER ) STRICT;
