      id           INT auto_increment,
      file         VARCHAR(100),
      creationdate DATE,
-     user         INT,
+     userID        INT,
      type         ENUM('subtitles', "transcription", "signal-language", "additional-audio"),
      CONSTRAINT badresourcesprimarykey PRIMARY KEY (id),
-     CONSTRAINT badresourcesusersforeignkey FOREIGN KEY (user) REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE
+     CONSTRAINT badresourcesusersforeignkey FOREIGN KEY (userID) REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE
   );
 
 CREATE TABLE IF NOT EXISTS comments

DROP DATABASE IF EXISTS webplayer;

CREATE DATABASE webplayer;

CREATE TABLE IF NOT EXISTS users
  (
     id           INT auto_increment,
     username     VARCHAR(20) NOT NULL,
     password     VARCHAR(256),
     creationdate DATE NOT NULL,
     active       BOOLEAN NOT NULL,
     CONSTRAINT badusersprimarykey PRIMARY KEY (id)

     id            INT auto_increment,
     creationdate  DATE,
     parentcomment INT,
     userID         INT,
     video         INT,
     CONSTRAINT badcommentprimarykey PRIMARY KEY (id),
     CONSTRAINT badcommentsusersforeignkey FOREIGN KEY (userID) REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE,
     CONSTRAINT badcommentscommentsforeignkey FOREIGN KEY (userID) REFERENCES comments (id) ON UPDATE CASCADE ON DELETE CASCADE,
     CONSTRAINT badcommentsvideosforeignkey FOREIGN KEY (userID) REFERENCES videos (id) ON UPDATE CASCADE ON DELETE CASCADE
  );

CREATE TABLE IF NOT EXISTS tags
