text: /*All User's are stored in APP_USER table*/
  create table APP_USER (
     id BIGINT NOT NULL AUTO_INCREMENT,
     sso_id VARCHAR(30) NOT NULL,
     password VARCHAR(100) NOT NULL,
     first_name VARCHAR(30) NOT NULL,
     last_name  VARCHAR(30) NOT NULL,
     email VARCHAR(30) NOT NULL,
     state VARCHAR(30) NOT NULL,
     PRIMARY KEY (id),
     UNIQUE (sso_id)
  );
  
  /* USER_PROFILE table contains all possible roles */
  create table USER_PROFILE(
     id BIGINT NOT NULL AUTO_INCREMENT,
     type VARCHAR(30) NOT NULL,
     PRIMARY KEY (id),
     UNIQUE (type)
  );
  
  /* JOIN TABLE for MANY-TO-MANY relationship*/
  CREATE TABLE APP_USER_USER_PROFILE (
      user_id BIGINT NOT NULL,
      user_profile_id BIGINT NOT NULL,
      PRIMARY KEY (user_id, user_profile_id),
      CONSTRAINT FK_APP_USER FOREIGN KEY (user_id) REFERENCES APP_USER (id),
      CONSTRAINT FK_USER_PROFILE FOREIGN KEY (user_profile_id) REFERENCES USER_PROFILE (id)
  );
  
  /* Populate USER_PROFILE Table */
  INSERT INTO USER_PROFILE(type)
  VALUES ('USER');
  
  INSERT INTO USER_PROFILE(type)
  VALUES ('ADMIN');
  
  INSERT INTO USER_PROFILE(type)
  VALUES ('DBA');
  
  /* Populate APP_USER Table */
  INSERT INTO APP_USER(sso_id, password, first_name, last_name, email, state)
  VALUES ('yiibai','123456', 'Yiibai','Watcher','admin@yiibai.com', 'Active');
  
  INSERT INTO APP_USER(sso_id, password, first_name, last_name, email, state)
  VALUES ('danny','123456', 'Danny','Theys','danny@xyz.com', 'Active');
  
  INSERT INTO APP_USER(sso_id, password, first_name, last_name, email, state)
  VALUES ('sam','123456', 'Sam','Smith','samy@xyz.com', 'Active');
  
  INSERT INTO APP_USER(sso_id, password, first_name, last_name, email, state)
  VALUES ('nicole','123456', 'Nicole','warner','nicloe@xyz.com', 'Active');
  
  INSERT INTO APP_USER(sso_id, password, first_name, last_name, email, state)
  VALUES ('kenny','123456', 'Kenny','Roger','kenny@xyz.com', 'Active');
  
  /* Populate JOIN Table */
  INSERT INTO APP_USER_USER_PROFILE (user_id, user_profile_id)
    SELECT user.id, profile.id FROM app_user user, user_profile profile
    where user.sso_id='bill' and profile.type='USER';
  
  INSERT INTO APP_USER_USER_PROFILE (user_id, user_profile_id)
    SELECT user.id, profile.id FROM app_user user, user_profile profile
    where user.sso_id='danny' and profile.type='USER';
  
  INSERT INTO APP_USER_USER_PROFILE (user_id, user_profile_id)
    SELECT user.id, profile.id FROM app_user user, user_profile profile
    where user.sso_id='sam' and profile.type='ADMIN';
  
  INSERT INTO APP_USER_USER_PROFILE (user_id, user_profile_id)
    SELECT user.id, profile.id FROM app_user user, user_profile profile
    where user.sso_id='nicole' and profile.type='DBA';
  
  INSERT INTO APP_USER_USER_PROFILE (user_id, user_profile_id)
    SELECT user.id, profile.id FROM app_user user, user_profile profile
    where user.sso_id='kenny' and profile.type='ADMIN';
  
  INSERT INTO APP_USER_USER_PROFILE (user_id, user_profile_id)
    SELECT user.id, profile.id FROM app_user user, user_profile profile
    where user.sso_id='kenny' and profile.type='DBA';