event database

    CREATE TABLE IF NOT EXISTS userroles (
        roleID INT(11) NOT NULL AUTO_INCREMENT,
        roleName VARCHAR(255) NOT NULL,
        PRIMARY KEY (roleID)
    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
    INSERT INTO userRoles (roleName) VALUES('Administrator');
    INSERT INTO userRoles (roleName) VALUES('VIP');
    INSERT INTO userRoles (roleName) VALUES('Medlem');


    CREATE TABLE IF NOT EXISTS users (
        userID INT(11) NOT NULL AUTO_INCREMENT,
        username VARCHAR(255) NOT NULL,
        password VARCHAR(60) NOT NULL,
        name VARCHAR(255) NOT NULL,
        phone INT(8),
        skype VARCHAR(255),
        ROLE INT(11) NOT NULL,
        strike INT(1),
        banned bit NOT NULL DEFAULT 0,
        lastLogin DATETIME,
        PRIMARY KEY (userID),
        FOREIGN KEY(ROLE) REFERENCES userroles(roleID)
    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
    ALTER TABLE users ADD UNIQUE (username);
    INSERT INTO users (userID, username, password, ROLE, name) VALUES
    (1, 'admin', '$2y$11$dsZYNMVGll/eEGUsmIpTOuI/aLcn0KueHUpSq1KnqGaqYadpCwaiy', 1, 'Frederik');


    CREATE TABLE IF NOT EXISTS events (
        eventID INT(11) NOT NULL AUTO_INCREMENT,
        eventName VARCHAR(255) NOT NULL,
        maxParticipants INT NOT NULL,
        price INT,
        address VARCHAR(255) NOT NULL,
        timedate datetime NOT NULL,
        lastResponse datetime NOT NULL,
        description text,
        PRIMARY KEY (eventID)
    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

    CREATE TABLE IF NOT EXISTS activity (
        activityID INT(11) NOT NULL AUTO_INCREMENT,
        activityName VARCHAR(255) NOT NULL,
        maxParticipants INT NOT NULL,
        price INT,
        address VARCHAR(255) NOT NULL,
        timedate datetime NOT NULL,
        lastResponse datetime NOT NULL,
        description text,
        eventID INT,
        PRIMARY KEY (activityID),
        FOREIGN KEY(eventID) REFERENCES events(eventID)
    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


    CREATE TABLE IF NOT EXISTS eventCounter (
        countID INT(11) NOT NULL AUTO_INCREMENT,
        eventID INT,
        activityID INT,
        userID INT NOT NULL,
        comment VARCHAR(255),
        PRIMARY KEY (countID),
        FOREIGN KEY(eventID) REFERENCES events(eventID),
        FOREIGN KEY(activityID) REFERENCES activity(activityID),
        FOREIGN KEY(userID) REFERENCES users(userID)
    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;




// UPDATE IF ROW ELSE INSERT
SET @mycount = (SET IFNULL(COUNT(*),0) AS COUNT FROM eventcounter WHERE userID=1);
IF @mycount > 0 THEN
 UPDATE eventcounter SET activityID=1 WHERE userID=1 AND eventID=1;
ELSE
 INSERT INTO eventcounter (userID,eventID, activityID) VALUES=(1,1,1);
END IF;