X-Git-Url: https://code.wpia.club/?p=motion.git;a=blobdiff_plain;f=sql%2Fschema.sql;fp=sql%2Fschema.sql;h=56055bc15bb434a91f88f21886b30c2918911765;hp=c3967a45391b9230a60f436d8508e064ef7ebdfc;hb=b9f855a5b19ecb33304d1bab0f85d180c39cfc7e;hpb=af789e48c59de94f6c835582afbf8698905ae4ff diff --git a/sql/schema.sql b/sql/schema.sql index c3967a4..56055bc 100644 --- a/sql/schema.sql +++ b/sql/schema.sql @@ -22,6 +22,7 @@ CREATE TABLE motion (id serial NOT NULL, CREATE UNIQUE INDEX motion_ident ON motion (identifier); DROP TABLE IF EXISTS vote; +DROP TABLE IF EXISTS voteresult; DROP TYPE IF EXISTS "vote_type"; CREATE TYPE "vote_type" AS ENUM ('yes', 'no', 'abstain'); CREATE TABLE vote (motion_id INTEGER NOT NULL,