Database - Arquisoft/voters_i1a GitHub Wiki

We are using HSQLDB. The SQL code to create the tables is the following:

CREATE TABLE Users ( ID INT, NAME VARCHAR(50), NIF VARCHAR(9), EMAIL VARCHAR(50), PASSWORD VARCHAR(200), POLLINGSTATIONCODE VARCHAR(20),

CONSTRAINT users_pk PRIMARY KEY(ID), CONSTRAINT users_unique UNIQUE(email) );

Inserted a user as example.

INSERT INTO USERS VALUES (1, 'John', '123456789', '[email protected]', 'johnrocks', '123');