      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

CREATE TABLE IF NOT EXISTS videos
  (
     id           INT auto_increment,
     file         VARCHAR(100) NOT NULL,
     creationdate DATE NOT NULL,
     user         INT,
     public       BOOLEAN,
     active       BOOLEAN,
     CONSTRAINT badvideosprimarykey PRIMARY KEY (id),
     CONSTRAINT badvideosusersforeignkey FOREIGN KEY (user) REFERENCES users (id) ON UPDATE CASCADE ON DELETE CASCADE
  );

CREATE TABLE IF NOT EXISTS resources

     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
