text: CREATE TABLE IF NOT EXISTS `profiles` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `display_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `registered_on` datetime NOT NULL,
    `last_login` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  CREATE TABLE IF NOT EXISTS `profiles_groups` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  CREATE TABLE IF NOT EXISTS `profiles_groups_rights` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `profile_id` int(11) NOT NULL,
    `group_id` int(11) NOT NULL,
    `starts_on` datetime DEFAULT NULL,
    `expires_on` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `profile_id__group__id__expires_on` (`profile_id`,`group_id`,`expires_on`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  CREATE TABLE IF NOT EXISTS `profiles_sessions` (
    `session_id` varchar(255) CHARACTER SET utf8 NOT NULL,
    `profile_id` int(11) NOT NULL,
    `secret_key` varchar(255) DEFAULT NULL,
    `date` datetime NOT NULL,
    PRIMARY KEY (`session_id`,`profile_id`),
    KEY `fk_profiles_sessions_profiles1` (`profile_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  CREATE TABLE IF NOT EXISTS `profiles_settings` (
    `profile_id` int(11) NOT NULL,
    `name` varchar(255) CHARACTER SET utf8 NOT NULL,
    `value` text NOT NULL,
    PRIMARY KEY (`name`,`profile_id`),
    KEY `fk_profiles_settings_profiles1` (`profile_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  