[Symfony2] Implementeren van custom membership en roleprovider (Opgelost)

CREATE TABLE Role
(
    Id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    Name VARCHAR(255) NOT NULL
)ENGINE=InnoDB;

CREATE TABLE User
(
    Id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    FK_RoleID INT NOT NULL,
    Firstname VARCHAR(50) NOT NULL,
    Lastname VARCHAR(50) NOT NULL,
    DayOfBirth DATETIME NOT NULL,
    Email VARCHAR(255) NOT NULL,    
    Password VARCHAR(50) NOT NULL,    
    CreatedOn TIMESTAMP NOT NULL DEFAULT NOW(),
    IP VARCHAR(50) NOT NULL,
    CONSTRAINT FOREIGN KEY (FK_RoleID) REFERENCES Role(Id) ON UPDATE CASCADE ON DELETE CASCADE
)ENGINE=InnoDB;

CREATE TABLE Role
(
    Id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    Name VARCHAR(255) NOT NULL
)ENGINE=InnoDB;
 
CREATE TABLE User
(
    Id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    FK_RoleID INT NOT NULL,
    Firstname VARCHAR(50) NOT NULL,
    Lastname VARCHAR(50) NOT NULL,
    DayOfBirth DATETIME NOT NULL,
    Email VARCHAR(255) NOT NULL,    
    Password VARCHAR(50) NOT NULL,    
    CreatedOn TIMESTAMP NOT NULL DEFAULT NOW(),
    IP VARCHAR(50) NOT NULL,
    CONSTRAINT FOREIGN KEY (FK_RoleID) REFERENCES Role(Id) ON UPDATE CASCADE ON DELETE CASCADE
)ENGINE=InnoDB;