3LfTgtvJ

1CREATE TABLE IF NOT EXISTS users (
2    username TEXT PRIMARY KEY NOT NULL,
3    password TEXT NOT NULL
4);
5
6CREATE TABLE IF NOT EXISTS elections (
7    candidate TEXT NOT NULL,
8    election_date DATE NOT NULL DEFAULT CURRENT_DATE,
9    FOREIGN KEY (candidate) REFERENCES users(username)
10);
11
12CREATE TABLE IF NOT EXISTS user_votes (
13      voted_user TEXT NOT NULL UNIQUE REFERENCES elections(candidate),
14      user_who_voted TEXT NOT NULL REFERENCES users(username),
15      date_voted DATE NOT NULL DEFAULT CURRENT_DATE
16 );
17