From a7a6e965979f7c46c2511a33cb601172573f3c84 Mon Sep 17 00:00:00 2001 From: zwlucas Date: Tue, 1 Apr 2025 14:30:52 -0300 Subject: removed cpf --- database.sql | 10 ++++------ 1 file changed, 4 insertions(+), 6 deletions(-) (limited to 'database.sql') diff --git a/database.sql b/database.sql index 78b23cf..226fa2f 100644 --- a/database.sql +++ b/database.sql @@ -1,11 +1,9 @@ CREATE TABLE votes ( - id SERIAL PRIMARY KEY, - rm VARCHAR(5) NOT NULL, + rm VARCHAR(5) PRIMARY KEY, name VARCHAR(100) NOT NULL, - cpf VARCHAR(11) NOT NULL, - option_voted VARCHAR(50), + option VARCHAR(50), voted_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), - UNIQUE(rm, cpf) + UNIQUE(rm, name) ); -CREATE INDEX idx_votes_rm_cpf ON votes(rm, cpf); \ No newline at end of file +CREATE INDEX idx_votes_rm_name ON votes(rm, name); \ No newline at end of file -- cgit v1.2.3