text: /* If table already exists delete it */
  DROP TABLE IF EXISTS parties;
  DROP TABLE IF EXISTS candidates;
  DROP TABLE IF EXISTS voters;
  DROP TABLE IF EXISTS votes;
  /* Parties table creation*/
  CREATE TABLE parties (
      id INTEGER PRIMARY KEY,
      name VARCHAR(50) NOT NULL,
      description TEXT
  );
  /* Votes table creation*/
  CREATE TABLE votes (
      id INTEGER PRIMARY KEY,
      voter_id INTEGER UNSIGNED NOT NULL,
      candidate_id INTEGER UNSIGNED NOT NULL,
      created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
      CONSTRAINT uc_voter UNIQUE (voter_id),
      CONSTRAINT fk_voter FOREIGN KEY (voter_id) REFERENCES voters(id) ON DELETE CASCADE,
      CONSTRAINT fk_candidate FOREIGN KEY (candidate_id) REFERENCES candidates(id) ON DELETE CASCADE
  );
  /* Candidates table creation*/
  CREATE TABLE candidates (
      id INTEGER PRIMARY KEY,
      first_name VARCHAR(30) NOT NULL,
      last_name VARCHAR(30) NOT NULL,
      party_id INTEGER UNSIGNED,
      industry_connected BOOLEAN NOT NULL,
      CONSTRAINT fk_party FOREIGN KEY (party_id) REFERENCES parties(id) ON DELETE
      SET NULL
  );
  /* Voters table creation*/
  CREATE TABLE voters (
      id INTEGER PRIMARY KEY,
      first_name VARCHAR(30) NOT NULL,
      last_name VARCHAR(30) NOT NULL,
      email VARCHAR(50) NOT NULL,
      created_at DATETIME DEFAULT CURRENT_TIMESTAMP
  );