From a7a6e965979f7c46c2511a33cb601172573f3c84 Mon Sep 17 00:00:00 2001
From: zwlucas <lucas.oliveira1676@etec.sp.gov.br>
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

