 DROP DATABASE IF EXISTS webplayer;
 
-CREATE DATABASE webplayer;
+CREATE DATABASE webplayer CHARACTER SET utf16 COLLATE utf16_general_ci;
+
+USE webplayer;
 
 CREATE TABLE IF NOT EXISTS users
   (
      id           INT auto_increment,
      username     VARCHAR(20) NOT NULL,
-     password     VARCHAR(256),
+     userPassword VARCHAR(256),
      creationdate DATE NOT NULL,
      active       BOOLEAN NOT NULL,
      CONSTRAINT badusersprimarykey PRIMARY KEY (id)

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

CREATE TABLE IF NOT EXISTS tags

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

CREATE TABLE IF NOT EXISTS resources
