From 79670b4c51ebbdd242b894a5f0678618054cc2ef Mon Sep 17 00:00:00 2001
From: zwlucas <lucas.oliveira1676@etec.sp.gov.br>
Date: Mon, 31 Mar 2025 23:34:04 -0300
Subject: create eletrocast-eleicoes

---
 database.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 database.sql

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
new file mode 100644
index 0000000..78b23cf
--- /dev/null
+++ b/database.sql
@@ -0,0 +1,11 @@
+CREATE TABLE votes (
+  id SERIAL PRIMARY KEY,
+  rm VARCHAR(5) NOT NULL,
+  name VARCHAR(100) NOT NULL,
+  cpf VARCHAR(11) NOT NULL,
+  option_voted VARCHAR(50),
+  voted_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
+  UNIQUE(rm, cpf)
+);
+
+CREATE INDEX idx_votes_rm_cpf ON votes(rm, cpf);
\ No newline at end of file
-- 
cgit v1.2.3

