migration-test.sql

-- phpMyAdmin SQL Dump
-- version 3.5.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 14, 2014 at 01:28 PM
-- Server version: 5.5.29
-- PHP Version: 5.4.10

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `unifiedpush`
--

-- --------------------------------------------------------

--
-- Table structure for table `AndroidVariant`
--

CREATE TABLE `AndroidVariant` (
  `googleKey` varchar(255) NOT NULL,
  `projectNumber` varchar(255) DEFAULT NULL,
  `id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `APPLICATION_DEFAULT_ROLES`
--

CREATE TABLE `APPLICATION_DEFAULT_ROLES` (
  `APPLICATION_ID` varchar(36) NOT NULL,
  `ROLE_ID` varchar(36) NOT NULL,
  UNIQUE KEY `UK_8aelwnibji49avxsrtuf6xjow` (`ROLE_ID`),
  KEY `FK_maylts7klwqw2h8m2b5joytky` (`APPLICATION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `APPLICATION_DEFAULT_ROLES`
--

INSERT INTO `APPLICATION_DEFAULT_ROLES` (`APPLICATION_ID`, `ROLE_ID`) VALUES
  ('1061ee1a-f54a-4669-91ad-6851a1ef5769', '227b9dce-1a75-4685-a5c1-4f5b8be99e45'),
  ('1061ee1a-f54a-4669-91ad-6851a1ef5769', 'd20d5387-ebfa-408d-838a-bdddc8b5f2af'),
  ('72eba17c-a2cb-401c-b996-bb13707d0c3c', '1b1ec2fd-fdd3-4c85-ba93-4708c80f2bb7'),
  ('72eba17c-a2cb-401c-b996-bb13707d0c3c', '9ca707d0-0e6c-4c72-98bb-5c9f4f649a8c');

-- --------------------------------------------------------

--
-- Table structure for table `ChromePackagedAppVariant`
--

CREATE TABLE `ChromePackagedAppVariant` (
  `clientId` varchar(255) NOT NULL,
  `clientSecret` varchar(255) NOT NULL,
  `refreshToken` varchar(255) NOT NULL,
  `id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `CLIENT`
--

CREATE TABLE `CLIENT` (
  `DTYPE` varchar(31) NOT NULL,
  `ID` varchar(36) NOT NULL,
  `ALLOWED_CLAIMS_MASK` bigint(20) DEFAULT NULL,
  `ENABLED` bit(1) DEFAULT NULL,
  `FULL_SCOPE_ALLOWED` bit(1) DEFAULT NULL,
  `NAME` varchar(255) DEFAULT NULL,
  `NOT_BEFORE` int(11) DEFAULT NULL,
  `PUBLIC_CLIENT` bit(1) DEFAULT NULL,
  `SECRET` varchar(255) DEFAULT NULL,
  `DIRECT_GRANTS_ONLY` bit(1) DEFAULT NULL,
  `BASE_URL` varchar(255) DEFAULT NULL,
  `BEARER_ONLY` bit(1) DEFAULT NULL,
  `MANAGEMENT_URL` varchar(255) DEFAULT NULL,
  `SURROGATE_AUTH_REQUIRED` bit(1) DEFAULT NULL,
  `REALM_ID` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `UK_b71cjlbenv945rb6gcon438at` (`REALM_ID`,`NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CLIENT`
--

INSERT INTO `CLIENT` (`DTYPE`, `ID`, `ALLOWED_CLAIMS_MASK`, `ENABLED`, `FULL_SCOPE_ALLOWED`, `NAME`, `NOT_BEFORE`, `PUBLIC_CLIENT`, `SECRET`, `DIRECT_GRANTS_ONLY`, `BASE_URL`, `BEARER_ONLY`, `MANAGEMENT_URL`, `SURROGATE_AUTH_REQUIRED`, `REALM_ID`) VALUES
  ('ApplicationEntity', '1061ee1a-f54a-4669-91ad-6851a1ef5769', 1023, '
', '\0', 'account', 0, '\0', '3205affa-8c66-46e1-8c62-7153f222aa70', NULL, '/auth/realms/master/account', '\0', NULL, '\0', 'master'),
  ('ApplicationEntity', '18936366-97b7-4677-a46b-1b81fe843487', 1023, '
', '
', 'aerogear-realm', 0, '\0', '8289c25f-9765-460d-87d3-0d96fae19996', NULL, NULL, '
', NULL, '\0', 'master'),
  ('ApplicationEntity', '26d03b62-6285-4ccb-adc8-453114a27b31', 1023, '
', '
', 'unified-push-server-js', 0, '
', '135857ba-4037-48e2-a48a-d7e1e3a43ac2', NULL, '/ag-push', '\0', NULL, '\0', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('ApplicationEntity', '65f76c94-391a-4233-8a95-19b1795a5ad9', 1023, '
', '
', 'unified-push-server', 0, '\0', 'c00cc8d8-bbce-434e-b0d0-19aec04d1799', NULL, NULL, '
', NULL, '\0', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('ApplicationEntity', '72eba17c-a2cb-401c-b996-bb13707d0c3c', 1023, '
', '\0', 'account', 0, '\0', '0c981ca6-a35b-4f0d-90ab-48a91e558890', NULL, '/auth/realms/aerogear/account', '\0', NULL, '\0', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('ApplicationEntity', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', 1023, '
', '\0', 'realm-management', 0, '\0', '5d96a583-911e-4697-b015-d0988bed60dc', NULL, NULL, '
', NULL, '\0', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('ApplicationEntity', 'd81cdfcf-2d2f-4d52-9ed9-32d43c40b17e', 1023, '
', '\0', 'security-admin-console', 0, '
', '03695c4d-80c3-4ece-a286-c2ac8b7487eb', NULL, '/auth/admin/master/console/index.html', '\0', NULL, '\0', 'master'),
  ('ApplicationEntity', 'e156f8ee-7423-4448-8045-8d9a3b031331', 1023, '
', '\0', 'security-admin-console', 0, '
', 'cc102c3e-2ec1-464c-81ea-67b063e681c4', NULL, '/auth/admin/aerogear/console/index.html', '\0', NULL, '\0', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('ApplicationEntity', 'f3630462-128e-413c-a1c7-571d78ff4b21', 1023, '
', '
', 'master-realm', 0, '\0', '2f679471-f891-408e-b13b-57adf4fc5ca7', NULL, NULL, '
', NULL, '\0', 'master');

-- --------------------------------------------------------

--
-- Table structure for table `CLIENT_SESSION`
--

CREATE TABLE `CLIENT_SESSION` (
  `ID` varchar(36) NOT NULL,
  `ACTION` int(11) DEFAULT NULL,
  `CLIENT_ID` varchar(36) DEFAULT NULL,
  `REDIRECT_URI` varchar(255) DEFAULT NULL,
  `STATE` varchar(255) DEFAULT NULL,
  `TIMESTAMP` int(11) DEFAULT NULL,
  `SESSION_ID` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_b4ao2vcvat6ukau74wbwtfqo1` (`SESSION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `CLIENT_SESSION_ROLE`
--

CREATE TABLE `CLIENT_SESSION_ROLE` (
  `ROLE_ID` varchar(255) NOT NULL,
  `CLIENT_SESSION` varchar(36) NOT NULL,
  PRIMARY KEY (`CLIENT_SESSION`,`ROLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `COMPOSITE_ROLE`
--

CREATE TABLE `COMPOSITE_ROLE` (
  `COMPOSITE` varchar(36) NOT NULL,
  `CHILD_ROLE` varchar(36) NOT NULL,
  KEY `FK_gr7thllb9lu8q4vqa4524jjy8` (`CHILD_ROLE`),
  KEY `FK_a63wvekftu8jo1pnj81e7mce2` (`COMPOSITE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COMPOSITE_ROLE`
--

INSERT INTO `COMPOSITE_ROLE` (`COMPOSITE`, `CHILD_ROLE`) VALUES
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', '2cc4e146-d97a-43d2-b457-980a8aea754c'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', '3c0e7af4-fb67-46b5-a826-959598b6dda7'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', '411b4ed5-9a00-421e-bc38-5b3c2f58cf86'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', '78027b8e-6394-441c-b2be-455878716ca2'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', '8fb4a451-bfcb-4b69-8d60-c855f85c51fc'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', 'a4164071-133f-447b-95d1-5dab18833bd2'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', 'b6c381ea-6c7d-4707-bee1-6dfbade430a1'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', 'bb6e3b7c-c013-4050-914b-38953711518f'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', 'c126738e-aad5-4ef3-ac72-f1755db52ba4'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', 'd67dacdf-2c79-4315-bfd5-273222e47961'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', 'e0e1497f-0c7c-4dbc-bf38-66df50b5ca7e'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', 'cecd9206-7153-4239-8908-a57be306c910'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', '5912a360-310f-4c17-b76a-7d2cd6f09041'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', 'ad432908-ddce-4a80-ba80-a123d2cd8684'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', 'ed2f8324-f8d6-4153-a39d-0ecf3ef54118'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', 'eb581aa5-9d2a-4a06-aace-f322c3581497'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', '5dcd270c-8f11-4b9d-9cdc-7b2279eda297'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', 'a8744041-0292-4445-ae7c-0711972b314d'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', '328b86d0-d530-41ce-98f0-85583a2ed947'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', '73c8123c-e3d9-4367-a664-01769e7c37b6'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', 'ef184c50-c6be-4f85-b494-ca28a3efa1da'),
  ('5ec819bb-6cee-4d8d-b1cd-f60f29afd1af', 'eb1888f7-749e-461f-9205-e4c301954373'),
  ('5ec819bb-6cee-4d8d-b1cd-f60f29afd1af', '52186c94-8e3c-4fa7-ad8c-4fe44681b636'),
  ('5ec819bb-6cee-4d8d-b1cd-f60f29afd1af', 'a6ca4a45-b5d7-48ce-992e-53651b2e8211'),
  ('5ec819bb-6cee-4d8d-b1cd-f60f29afd1af', '14f2bdb1-f60b-4f84-8871-76fa6ac46618'),
  ('5ec819bb-6cee-4d8d-b1cd-f60f29afd1af', '05686de9-408c-4f42-909e-dd2e7c3a2473'),
  ('5ec819bb-6cee-4d8d-b1cd-f60f29afd1af', 'f221afd2-83ed-4e24-b13e-61a261bc85df'),
  ('5ec819bb-6cee-4d8d-b1cd-f60f29afd1af', '1ad50712-da02-4464-bdfe-89bc9de9a407'),
  ('5ec819bb-6cee-4d8d-b1cd-f60f29afd1af', '08068fb7-d9fe-4548-8e1a-dd7704f7dc06'),
  ('5ec819bb-6cee-4d8d-b1cd-f60f29afd1af', '69f73883-5a05-4754-b324-ee9d01ecbb88'),
  ('5ec819bb-6cee-4d8d-b1cd-f60f29afd1af', '8f78994c-25bc-4546-8c19-98f7804e30d9');

-- --------------------------------------------------------

--
-- Table structure for table `CREDENTIAL`
--

CREATE TABLE `CREDENTIAL` (
  `ID` varchar(36) NOT NULL,
  `DEVICE` varchar(255) DEFAULT NULL,
  `HASH_ITERATIONS` int(11) DEFAULT NULL,
  `SALT` tinyblob,
  `TYPE` varchar(255) DEFAULT NULL,
  `VALUE` varchar(255) DEFAULT NULL,
  `USER_ID` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_pfyr0glasqyl0dei3kl69r6v0` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CREDENTIAL`
--

INSERT INTO `CREDENTIAL` (`ID`, `DEVICE`, `HASH_ITERATIONS`, `SALT`, `TYPE`, `VALUE`, `USER_ID`) VALUES
  ('a3f1c696-e211-424c-af66-99a372775a21', NULL, 1, 0xaa9ddef82e692ede5ef2d504905fa6ec, 'password', 'wW9MDvI8QsqSVeJutr7tsfLr5zU4IjjXjGypsoU4n77S0VAWTMuGd5p20l8TIJgpI7iavbA2VdT3tcYbT03vbQ==', '732bc092-6ca3-461c-ba79-93a8d969f316');

-- --------------------------------------------------------

--
-- Table structure for table `EVENT_ENTITY`
--

CREATE TABLE `EVENT_ENTITY` (
  `ID` varchar(36) NOT NULL,
  `CLIENT_ID` varchar(255) DEFAULT NULL,
  `DETAILS_JSON` varchar(2550) DEFAULT NULL,
  `ERROR` varchar(255) DEFAULT NULL,
  `IP_ADDRESS` varchar(255) DEFAULT NULL,
  `REALM_ID` varchar(255) DEFAULT NULL,
  `SESSION_ID` varchar(255) DEFAULT NULL,
  `TIME` bigint(20) DEFAULT NULL,
  `TYPE` varchar(255) DEFAULT NULL,
  `USER_ID` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `FED_PROVIDERS`
--

CREATE TABLE `FED_PROVIDERS` (
  `REALM_ID` varchar(36) NOT NULL,
  `userFederationProviders_ID` varchar(36) NOT NULL,
  UNIQUE KEY `UK_dccirjlipu1478vqc89did88c` (`userFederationProviders_ID`),
  KEY `FK_213lyq09fkxq8k8ny8dy3737t` (`REALM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `Installation`
--

CREATE TABLE `Installation` (
  `id` varchar(255) NOT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `deviceToken` varchar(4096) DEFAULT NULL,
  `deviceType` varchar(255) DEFAULT NULL,
  `enabled` bit(1) NOT NULL,
  `operatingSystem` varchar(255) DEFAULT NULL,
  `osVersion` varchar(255) DEFAULT NULL,
  `platform` varchar(255) DEFAULT NULL,
  `variantID` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_se07q3nt9pb7v949p4ia77uvc` (`variantID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Installation`
--

INSERT INTO `Installation` (`id`, `alias`, `deviceToken`, `deviceType`, `enabled`, `operatingSystem`, `osVersion`, `platform`, `variantID`) VALUES
  ('2ace4893-c01c-460c-a31b-240e1774efaa', 'someUsername or email adress...', 'http://someTokenString3.com', 'iPad', '
', 'iOS', '6.1.2', 'simplePush', 'd390e0b4-a636-4823-a121-2116f8ea55e9'),
  ('7bf73dea-1144-4476-b4b5-f30e354d3859', 'someUsername or email adress...', 'http://someTokenString.com', 'iPad', '
', 'iOS', '6.1.2', 'simplePush', 'd390e0b4-a636-4823-a121-2116f8ea55e9');

-- --------------------------------------------------------

--
-- Table structure for table `Installation_categories`
--

CREATE TABLE `Installation_categories` (
  `Installation_id` varchar(255) NOT NULL,
  `categories` varchar(255) DEFAULT NULL,
  KEY `FK_7jk4ols9cel7xo5bi10yk1gvl` (`Installation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Installation_categories`
--

INSERT INTO `Installation_categories` (`Installation_id`, `categories`) VALUES
  ('2ace4893-c01c-460c-a31b-240e1774efaa', 'super'),
  ('2ace4893-c01c-460c-a31b-240e1774efaa', 'football'),
  ('2ace4893-c01c-460c-a31b-240e1774efaa', 'sport'),
  ('7bf73dea-1144-4476-b4b5-f30e354d3859', 'football'),
  ('7bf73dea-1144-4476-b4b5-f30e354d3859', 'sport'),
  ('7bf73dea-1144-4476-b4b5-f30e354d3859', 'bla');

-- --------------------------------------------------------

--
-- Table structure for table `iOSVariant`
--

CREATE TABLE `iOSVariant` (
  `certificate` longblob NOT NULL,
  `passphrase` varchar(255) NOT NULL,
  `production` bit(1) NOT NULL,
  `id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `KEYCLOAK_ROLE`
--

CREATE TABLE `KEYCLOAK_ROLE` (
  `id` varchar(36) NOT NULL,
  `APP_REALM_CONSTRAINT` varchar(36) DEFAULT NULL,
  `APPLICATION_ROLE` bit(1) DEFAULT NULL,
  `DESCRIPTION` varchar(255) DEFAULT NULL,
  `NAME` varchar(255) DEFAULT NULL,
  `REALM_ID` varchar(255) DEFAULT NULL,
  `APPLICATION` varchar(36) DEFAULT NULL,
  `REALM` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_j3rwuvd56ontgsuhogm184ww2` (`NAME`,`APP_REALM_CONSTRAINT`),
  KEY `FK_pimo5le2c0ral09fl8cm9wfw9` (`APPLICATION`),
  KEY `FK_6vyqfe4cn4wlq8r6kt5vdsj5c` (`REALM`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `KEYCLOAK_ROLE`
--

INSERT INTO `KEYCLOAK_ROLE` (`id`, `APP_REALM_CONSTRAINT`, `APPLICATION_ROLE`, `DESCRIPTION`, `NAME`, `REALM_ID`, `APPLICATION`, `REALM`) VALUES
  ('05686de9-408c-4f42-909e-dd2e7c3a2473', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', '
', NULL, 'view-events', '5ab8a5e3-1931-423b-910f-b888e732b480', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', NULL),
  ('08068fb7-d9fe-4548-8e1a-dd7704f7dc06', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', '
', NULL, 'manage-applications', '5ab8a5e3-1931-423b-910f-b888e732b480', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', NULL),
  ('14f2bdb1-f60b-4f84-8871-76fa6ac46618', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', '
', NULL, 'view-clients', '5ab8a5e3-1931-423b-910f-b888e732b480', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', NULL),
  ('1ad50712-da02-4464-bdfe-89bc9de9a407', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', '
', NULL, 'manage-users', '5ab8a5e3-1931-423b-910f-b888e732b480', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', NULL),
  ('1b1ec2fd-fdd3-4c85-ba93-4708c80f2bb7', '72eba17c-a2cb-401c-b996-bb13707d0c3c', '
', NULL, 'view-profile', '5ab8a5e3-1931-423b-910f-b888e732b480', '72eba17c-a2cb-401c-b996-bb13707d0c3c', NULL),
  ('227b9dce-1a75-4685-a5c1-4f5b8be99e45', '1061ee1a-f54a-4669-91ad-6851a1ef5769', '
', NULL, 'manage-account', 'master', '1061ee1a-f54a-4669-91ad-6851a1ef5769', NULL),
  ('2cc4e146-d97a-43d2-b457-980a8aea754c', 'f3630462-128e-413c-a1c7-571d78ff4b21', '
', NULL, 'manage-users', 'master', 'f3630462-128e-413c-a1c7-571d78ff4b21', NULL),
  ('328b86d0-d530-41ce-98f0-85583a2ed947', '18936366-97b7-4677-a46b-1b81fe843487', '
', NULL, 'manage-applications', 'master', '18936366-97b7-4677-a46b-1b81fe843487', NULL),
  ('3c0e7af4-fb67-46b5-a826-959598b6dda7', 'f3630462-128e-413c-a1c7-571d78ff4b21', '
', NULL, 'manage-events', 'master', 'f3630462-128e-413c-a1c7-571d78ff4b21', NULL),
  ('411b4ed5-9a00-421e-bc38-5b3c2f58cf86', 'f3630462-128e-413c-a1c7-571d78ff4b21', '
', NULL, 'manage-clients', 'master', 'f3630462-128e-413c-a1c7-571d78ff4b21', NULL),
  ('52186c94-8e3c-4fa7-ad8c-4fe44681b636', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', '
', NULL, 'view-users', '5ab8a5e3-1931-423b-910f-b888e732b480', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', NULL),
  ('5912a360-310f-4c17-b76a-7d2cd6f09041', '18936366-97b7-4677-a46b-1b81fe843487', '
', NULL, 'view-users', 'master', '18936366-97b7-4677-a46b-1b81fe843487', NULL),
  ('5dcd270c-8f11-4b9d-9cdc-7b2279eda297', '18936366-97b7-4677-a46b-1b81fe843487', '
', NULL, 'manage-realm', 'master', '18936366-97b7-4677-a46b-1b81fe843487', NULL),
  ('5ec819bb-6cee-4d8d-b1cd-f60f29afd1af', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', '
', NULL, 'realm-admin', '5ab8a5e3-1931-423b-910f-b888e732b480', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', NULL),
  ('69f73883-5a05-4754-b324-ee9d01ecbb88', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', '
', NULL, 'manage-clients', '5ab8a5e3-1931-423b-910f-b888e732b480', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', NULL),
  ('73c8123c-e3d9-4367-a664-01769e7c37b6', '18936366-97b7-4677-a46b-1b81fe843487', '
', NULL, 'manage-clients', 'master', '18936366-97b7-4677-a46b-1b81fe843487', NULL),
  ('78027b8e-6394-441c-b2be-455878716ca2', 'f3630462-128e-413c-a1c7-571d78ff4b21', '
', NULL, 'manage-applications', 'master', 'f3630462-128e-413c-a1c7-571d78ff4b21', NULL),
  ('8f78994c-25bc-4546-8c19-98f7804e30d9', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', '
', NULL, 'manage-events', '5ab8a5e3-1931-423b-910f-b888e732b480', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', NULL),
  ('8fb4a451-bfcb-4b69-8d60-c855f85c51fc', 'f3630462-128e-413c-a1c7-571d78ff4b21', '
', NULL, 'view-realm', 'master', 'f3630462-128e-413c-a1c7-571d78ff4b21', NULL),
  ('9ca707d0-0e6c-4c72-98bb-5c9f4f649a8c', '72eba17c-a2cb-401c-b996-bb13707d0c3c', '
', NULL, 'manage-account', '5ab8a5e3-1931-423b-910f-b888e732b480', '72eba17c-a2cb-401c-b996-bb13707d0c3c', NULL),
  ('a4164071-133f-447b-95d1-5dab18833bd2', 'master', '\0', NULL, 'create-realm', 'master', NULL, 'master'),
  ('a6ca4a45-b5d7-48ce-992e-53651b2e8211', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', '
', NULL, 'view-applications', '5ab8a5e3-1931-423b-910f-b888e732b480', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', NULL),
  ('a8744041-0292-4445-ae7c-0711972b314d', '18936366-97b7-4677-a46b-1b81fe843487', '
', NULL, 'manage-users', 'master', '18936366-97b7-4677-a46b-1b81fe843487', NULL),
  ('ad432908-ddce-4a80-ba80-a123d2cd8684', '18936366-97b7-4677-a46b-1b81fe843487', '
', NULL, 'view-applications', 'master', '18936366-97b7-4677-a46b-1b81fe843487', NULL),
  ('b6c381ea-6c7d-4707-bee1-6dfbade430a1', 'f3630462-128e-413c-a1c7-571d78ff4b21', '
', NULL, 'view-users', 'master', 'f3630462-128e-413c-a1c7-571d78ff4b21', NULL),
  ('bb6e3b7c-c013-4050-914b-38953711518f', 'f3630462-128e-413c-a1c7-571d78ff4b21', '
', NULL, 'view-applications', 'master', 'f3630462-128e-413c-a1c7-571d78ff4b21', NULL),
  ('c126738e-aad5-4ef3-ac72-f1755db52ba4', 'f3630462-128e-413c-a1c7-571d78ff4b21', '
', NULL, 'manage-realm', 'master', 'f3630462-128e-413c-a1c7-571d78ff4b21', NULL),
  ('cecd9206-7153-4239-8908-a57be306c910', '18936366-97b7-4677-a46b-1b81fe843487', '
', NULL, 'view-realm', 'master', '18936366-97b7-4677-a46b-1b81fe843487', NULL),
  ('d20d5387-ebfa-408d-838a-bdddc8b5f2af', '1061ee1a-f54a-4669-91ad-6851a1ef5769', '
', NULL, 'view-profile', 'master', '1061ee1a-f54a-4669-91ad-6851a1ef5769', NULL),
  ('d67dacdf-2c79-4315-bfd5-273222e47961', 'f3630462-128e-413c-a1c7-571d78ff4b21', '
', NULL, 'view-clients', 'master', 'f3630462-128e-413c-a1c7-571d78ff4b21', NULL),
  ('e0e1497f-0c7c-4dbc-bf38-66df50b5ca7e', 'f3630462-128e-413c-a1c7-571d78ff4b21', '
', NULL, 'view-events', 'master', 'f3630462-128e-413c-a1c7-571d78ff4b21', NULL),
  ('eb1888f7-749e-461f-9205-e4c301954373', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', '
', NULL, 'view-realm', '5ab8a5e3-1931-423b-910f-b888e732b480', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', NULL),
  ('eb581aa5-9d2a-4a06-aace-f322c3581497', '18936366-97b7-4677-a46b-1b81fe843487', '
', NULL, 'view-events', 'master', '18936366-97b7-4677-a46b-1b81fe843487', NULL),
  ('ed2f8324-f8d6-4153-a39d-0ecf3ef54118', '18936366-97b7-4677-a46b-1b81fe843487', '
', NULL, 'view-clients', 'master', '18936366-97b7-4677-a46b-1b81fe843487', NULL),
  ('ef184c50-c6be-4f85-b494-ca28a3efa1da', '18936366-97b7-4677-a46b-1b81fe843487', '
', NULL, 'manage-events', 'master', '18936366-97b7-4677-a46b-1b81fe843487', NULL),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', 'master', '\0', NULL, 'admin', 'master', NULL, 'master'),
  ('f221afd2-83ed-4e24-b13e-61a261bc85df', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', '
', NULL, 'manage-realm', '5ab8a5e3-1931-423b-910f-b888e732b480', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121', NULL),
  ('f6ff7509-237c-4198-be12-787f43c29b6a', '5ab8a5e3-1931-423b-910f-b888e732b480', '\0', 'Administrator privileges', 'admin', '5ab8a5e3-1931-423b-910f-b888e732b480', NULL, '5ab8a5e3-1931-423b-910f-b888e732b480');

-- --------------------------------------------------------

--
-- Table structure for table `PushApplication`
--

CREATE TABLE `PushApplication` (
  `id` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `developer` varchar(255) DEFAULT NULL,
  `masterSecret` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `pushApplicationID` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PushApplication`
--

INSERT INTO `PushApplication` (`id`, `description`, `developer`, `masterSecret`, `name`, `pushApplicationID`) VALUES
  ('4ac59286-0cb0-4290-95fb-b917f88892f2', NULL, 'admin', '573856c2-359d-4a16-8020-7b3c8ea37f11', 'Test', '1833f396-f5d4-45a6-a00a-900d10ed7fc8');

-- --------------------------------------------------------

--
-- Table structure for table `PushMessageInformation`
--

CREATE TABLE `PushMessageInformation` (
  `id` varchar(255) NOT NULL,
  `clientIdentifier` varchar(255) DEFAULT NULL,
  `ipAddress` varchar(255) DEFAULT NULL,
  `pushApplicationId` varchar(255) NOT NULL,
  `rawJsonMessage` varchar(4500) DEFAULT NULL,
  `submitDate` datetime DEFAULT NULL,
  `totalReceivers` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `REALM`
--

CREATE TABLE `REALM` (
  `ID` varchar(36) NOT NULL,
  `ACCESS_CODE_LIFESPAN` int(11) DEFAULT NULL,
  `USER_ACTION_LIFESPAN` int(11) DEFAULT NULL,
  `ACCESS_TOKEN_LIFESPAN` int(11) DEFAULT NULL,
  `ACCOUNT_THEME` varchar(255) DEFAULT NULL,
  `ADMIN_THEME` varchar(255) DEFAULT NULL,
  `EMAIL_THEME` varchar(255) DEFAULT NULL,
  `ENABLED` bit(1) DEFAULT NULL,
  `EVENTS_ENABLED` bit(1) DEFAULT NULL,
  `EVENTS_EXPIRATION` bigint(20) DEFAULT NULL,
  `LOGIN_THEME` varchar(255) DEFAULT NULL,
  `NAME` varchar(255) DEFAULT NULL,
  `NOT_BEFORE` int(11) DEFAULT NULL,
  `PASSWORD_CRED_GRANT_ALLOWED` bit(1) DEFAULT NULL,
  `PASSWORD_POLICY` varchar(255) DEFAULT NULL,
  `PRIVATE_KEY` varchar(2048) DEFAULT NULL,
  `PUBLIC_KEY` varchar(2048) DEFAULT NULL,
  `REGISTRATION_ALLOWED` bit(1) DEFAULT NULL,
  `REMEMBER_ME` bit(1) DEFAULT NULL,
  `RESET_PASSWORD_ALLOWED` bit(1) DEFAULT NULL,
  `SOCIAL` bit(1) DEFAULT NULL,
  `SSL_REQUIRED` varchar(255) DEFAULT NULL,
  `SSO_IDLE_TIMEOUT` int(11) DEFAULT NULL,
  `SSO_MAX_LIFESPAN` int(11) DEFAULT NULL,
  `UPDATE_PROFILE_ON_SOC_LOGIN` bit(1) DEFAULT NULL,
  `VERIFY_EMAIL` bit(1) DEFAULT NULL,
  `MASTER_ADMIN_APP` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `UK_orvsdmla56612eaefiq6wl5oi` (`NAME`),
  KEY `FK_rsaf444kk6qrkms7n56aiwq5y` (`MASTER_ADMIN_APP`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `REALM`
--

INSERT INTO `REALM` (`ID`, `ACCESS_CODE_LIFESPAN`, `USER_ACTION_LIFESPAN`, `ACCESS_TOKEN_LIFESPAN`, `ACCOUNT_THEME`, `ADMIN_THEME`, `EMAIL_THEME`, `ENABLED`, `EVENTS_ENABLED`, `EVENTS_EXPIRATION`, `LOGIN_THEME`, `NAME`, `NOT_BEFORE`, `PASSWORD_CRED_GRANT_ALLOWED`, `PASSWORD_POLICY`, `PRIVATE_KEY`, `PUBLIC_KEY`, `REGISTRATION_ALLOWED`, `REMEMBER_ME`, `RESET_PASSWORD_ALLOWED`, `SOCIAL`, `SSL_REQUIRED`, `SSO_IDLE_TIMEOUT`, `SSO_MAX_LIFESPAN`, `UPDATE_PROFILE_ON_SOC_LOGIN`, `VERIFY_EMAIL`, `MASTER_ADMIN_APP`) VALUES
  ('5ab8a5e3-1931-423b-910f-b888e732b480', 60, 300, 60, 'aerogear', 'aerogear', NULL, '
', '\0', 0, 'aerogear', 'aerogear', 0, '\0', NULL, 'MIICXAIBAAKBgQCBZmNb/3GFQGtTcv7juZ0ls+yrjgSEKIL/c+dJrgDqt+dD4kLwuNcJ+q23bU9Y9Wot9RDLiUe9gTK7+KNtSigmzt8Q+ViYsFtCmInbSPQ86U05Xxv5AVPHrCId1zXkt+A3VA2Q5kuQmGe/1bs0OP3y4KgGypmrVAMGWURXplOGpwIDAQABAoGADOMknCH5rVq4FayLRCTVSM79kCxpuLvMKCLj8wuYXcgJCVK8dfsCt6S2rmD9mQ+ADqmsjYjTk0UNx3jA1f6ftvCS14pCXBZ7IAhRys81H3M+uE/cz5mpevWJo4sMSzwPVHPcgiInVc7SdA7sbCqQNjMJBJHg2pEiKE7tkgvTp4ECQQDjsUj+VkIlkwW57PwChRIkvD6X5h2+O2ZYfpqxAZP32eJWg4S793Zn/GdeNk+ktnu1c+V22KBIwfHz8C/iR0tnAkEAkXzE6tCDTOHKSRtHVI6ExGcbs5g+3dxixvddeC8giGLgBhdTA1LjT9NdvzyakYTRSmBZON7fljo83odNKvAiwQJBANTZuWPRnTpk63h4msl8Po7KzzTOsMVR4AYgLFoGIJ4VOCop/l59IlppMPR4jxFqadEhy8PDFGuPqrCguxKsFUcCQB4Buuene/1GcJ9lde/VuUJ89bS0CPtfciwRZwDbz3zxz7zR4LhFx0Z2lNZVnJe46iXJ+30EUt88QcOv6lWZ08ECQF8muSwm5QjV9vmUZQLhuqWnu8SFO+g3w9/mRgn7/SUhzEHLfeK27PDR0YnqmwyRqIPV7JLldxGPoCJ96j+im5Q=', 'MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCBZmNb/3GFQGtTcv7juZ0ls+yrjgSEKIL/c+dJrgDqt+dD4kLwuNcJ+q23bU9Y9Wot9RDLiUe9gTK7+KNtSigmzt8Q+ViYsFtCmInbSPQ86U05Xxv5AVPHrCId1zXkt+A3VA2Q5kuQmGe/1bs0OP3y4KgGypmrVAMGWURXplOGpwIDAQAB', '\0', '\0', '\0', '\0', 'EXTERNAL', 600, 36000, '\0', '\0', '18936366-97b7-4677-a46b-1b81fe843487'),
  ('master', 60, 300, 60, NULL, NULL, NULL, '
', '\0', 0, NULL, 'master', 0, '\0', NULL, 'MIICWwIBAAKBgQCpDkR1uWLYDmrDKYbVgDQxJ+0LU3U6dGfx1EOLnCoz0i3VDHnUsBp8/LMheApsg+SrOVmzLOusjerqizKq8opKLjP5mAHdoSvhuAnxYIcAHcM9c2Ibw9mG48B1YqhR9ooHDZfxjLNaHIceojHs0WZKW2VviqkbSQCym3PFNfFUFwIDAQABAoGAXVP3D1as7sHmxp8iRLNmHM0B3ALS8NZam/Km52frFHivvLIKgBRISz/mVE/E0Wtuzef3USc3ZCdkzN7TtfP3y14IvH3BjHUFVpGUloB5gW8RxVBcVkcrm/QR03/QVePgEqVs1EPFGRfK13D25ru46sSKn87RfxBZxIfK2gdnd0ECQQDaPj4Qb4vIqRGOP0vfvNia38xYAI7dm9n2nuq2imyEkFjIT1R15/4Fw6bUSFMeEVRJfcK4sLy1TeP7rtNTH9EPAkEAxk2RJHf0OtKaHL/5yBztScAd91b5h43kZv2oGISm82tFV1D6tf0cM/G/qrcjbqvj456t6e784/WuQ0ebSpg8eQJARE523m4LMiK4e+0TslNI+DBTpLeH/5RoA+h5TejFTjhfkVJC/SQ/PU6fSJHace66ksXpzCSE67oVQRDW042BwQJAY822NvyIVvKXzdBxDl5ArtWaP1nuzGKFibAwYeahf/GFPKTtCZsSDrKlHG5/zruEPpMmRI6biL+lrQblCW4FQQJAdWlrfUlNbbonVOtF8yh5OCflKrJbg60Fg4XVExAcmz5LqFXZiTD7VprYm2z5NNMuSg+S3ICWrrwWXTZBYr5Q+w==', 'MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCpDkR1uWLYDmrDKYbVgDQxJ+0LU3U6dGfx1EOLnCoz0i3VDHnUsBp8/LMheApsg+SrOVmzLOusjerqizKq8opKLjP5mAHdoSvhuAnxYIcAHcM9c2Ibw9mG48B1YqhR9ooHDZfxjLNaHIceojHs0WZKW2VviqkbSQCym3PFNfFUFwIDAQAB', '\0', '\0', '\0', '\0', 'EXTERNAL', 300, 36000, '\0', '\0', 'f3630462-128e-413c-a1c7-571d78ff4b21');

-- --------------------------------------------------------

--
-- Table structure for table `REALM_APPLICATION`
--

CREATE TABLE `REALM_APPLICATION` (
  `APPLICATION_ID` varchar(36) NOT NULL,
  `REALM_ID` varchar(36) NOT NULL,
  UNIQUE KEY `UK_l5qga3rfme47335jy8jxyxh3i` (`REALM_ID`),
  KEY `FK_71s3p0diuxawwqqsa528uby2q` (`APPLICATION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `REALM_APPLICATION`
--

INSERT INTO `REALM_APPLICATION` (`APPLICATION_ID`, `REALM_ID`) VALUES
  ('5ab8a5e3-1931-423b-910f-b888e732b480', '26d03b62-6285-4ccb-adc8-453114a27b31'),
  ('5ab8a5e3-1931-423b-910f-b888e732b480', '65f76c94-391a-4233-8a95-19b1795a5ad9'),
  ('5ab8a5e3-1931-423b-910f-b888e732b480', '72eba17c-a2cb-401c-b996-bb13707d0c3c'),
  ('5ab8a5e3-1931-423b-910f-b888e732b480', 'a5415c14-bdb9-4afc-8a6c-1534c8c4c121'),
  ('5ab8a5e3-1931-423b-910f-b888e732b480', 'e156f8ee-7423-4448-8045-8d9a3b031331'),
  ('master', '1061ee1a-f54a-4669-91ad-6851a1ef5769'),
  ('master', '18936366-97b7-4677-a46b-1b81fe843487'),
  ('master', 'd81cdfcf-2d2f-4d52-9ed9-32d43c40b17e'),
  ('master', 'f3630462-128e-413c-a1c7-571d78ff4b21');

-- --------------------------------------------------------

--
-- Table structure for table `REALM_ATTRIBUTE`
--

CREATE TABLE `REALM_ATTRIBUTE` (
  `NAME` varchar(255) NOT NULL,
  `VALUE` varchar(255) DEFAULT NULL,
  `REALM_ID` varchar(36) NOT NULL,
  PRIMARY KEY (`NAME`,`REALM_ID`),
  KEY `FK_8shxd6l3e9atqukacxgpffptw` (`REALM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `REALM_ATTRIBUTE`
--

INSERT INTO `REALM_ATTRIBUTE` (`NAME`, `VALUE`, `REALM_ID`) VALUES
  ('bruteForceProtected', 'false', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('bruteForceProtected', 'false', 'master'),
  ('failureFactor', '30', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('failureFactor', '30', 'master'),
  ('maxDeltaTimeSeconds', '43200', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('maxDeltaTimeSeconds', '43200', 'master'),
  ('maxFailureWaitSeconds', '900', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('maxFailureWaitSeconds', '900', 'master'),
  ('minimumQuickLoginWaitSeconds', '60', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('minimumQuickLoginWaitSeconds', '60', 'master'),
  ('quickLoginCheckMilliSeconds', '1000', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('quickLoginCheckMilliSeconds', '1000', 'master'),
  ('waitIncrementSeconds', '60', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('waitIncrementSeconds', '60', 'master'),
  ('_browser_header.contentSecurityPolicy', 'frame-src ''self''', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('_browser_header.contentSecurityPolicy', 'frame-src ''self''', 'master'),
  ('_browser_header.xFrameOptions', 'SAMEORIGIN', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('_browser_header.xFrameOptions', 'SAMEORIGIN', 'master');

-- --------------------------------------------------------

--
-- Table structure for table `REALM_DEFAULT_ROLES`
--

CREATE TABLE `REALM_DEFAULT_ROLES` (
  `REALM_ID` varchar(36) NOT NULL,
  `ROLE_ID` varchar(36) NOT NULL,
  UNIQUE KEY `UK_h4wpd7w4hsoolni3h0sw7btje` (`ROLE_ID`),
  KEY `FK_evudb1ppw84oxfax2drs03icc` (`REALM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `REALM_EVENTS_LISTENERS`
--

CREATE TABLE `REALM_EVENTS_LISTENERS` (
  `REALM_ID` varchar(36) NOT NULL,
  `VALUE` varchar(255) DEFAULT NULL,
  KEY `FK_h846o4h0w8epx5nxev9f5y69j` (`REALM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `REALM_REQUIRED_CREDENTIAL`
--

CREATE TABLE `REALM_REQUIRED_CREDENTIAL` (
  `TYPE` varchar(255) NOT NULL,
  `FORM_LABEL` varchar(255) DEFAULT NULL,
  `INPUT` bit(1) DEFAULT NULL,
  `SECRET` bit(1) DEFAULT NULL,
  `REALM_ID` varchar(36) NOT NULL,
  PRIMARY KEY (`REALM_ID`,`TYPE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `REALM_REQUIRED_CREDENTIAL`
--

INSERT INTO `REALM_REQUIRED_CREDENTIAL` (`TYPE`, `FORM_LABEL`, `INPUT`, `SECRET`, `REALM_ID`) VALUES
  ('password', 'password', '
', '
', '5ab8a5e3-1931-423b-910f-b888e732b480'),
  ('password', 'password', '
', '
', 'master');

-- --------------------------------------------------------

--
-- Table structure for table `REALM_SMTP_CONFIG`
--

CREATE TABLE `REALM_SMTP_CONFIG` (
  `REALM_ID` varchar(36) NOT NULL,
  `VALUE` varchar(255) DEFAULT NULL,
  `NAME` varchar(255) NOT NULL,
  PRIMARY KEY (`REALM_ID`,`NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `REALM_SOCIAL_CONFIG`
--

CREATE TABLE `REALM_SOCIAL_CONFIG` (
  `REALM_ID` varchar(36) NOT NULL,
  `VALUE` varchar(255) DEFAULT NULL,
  `NAME` varchar(255) NOT NULL,
  PRIMARY KEY (`REALM_ID`,`NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `REDIRECT_URIS`
--

CREATE TABLE `REDIRECT_URIS` (
  `CLIENT_ID` varchar(36) NOT NULL,
  `VALUE` varchar(255) DEFAULT NULL,
  KEY `FK_1burs8pb4ouj97h5wuppahv9f` (`CLIENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `REDIRECT_URIS`
--

INSERT INTO `REDIRECT_URIS` (`CLIENT_ID`, `VALUE`) VALUES
  ('1061ee1a-f54a-4669-91ad-6851a1ef5769', '/auth/realms/master/account/*'),
  ('d81cdfcf-2d2f-4d52-9ed9-32d43c40b17e', '/auth/admin/master/console/*'),
  ('72eba17c-a2cb-401c-b996-bb13707d0c3c', '/auth/realms/aerogear/account/*'),
  ('e156f8ee-7423-4448-8045-8d9a3b031331', '/auth/admin/aerogear/console/*'),
  ('26d03b62-6285-4ccb-adc8-453114a27b31', '/ag-push/*');

-- --------------------------------------------------------

--
-- Table structure for table `SCOPE_MAPPING`
--

CREATE TABLE `SCOPE_MAPPING` (
  `ROLE_ID` varchar(36) NOT NULL,
  `CLIENT_ID` varchar(36) NOT NULL,
  PRIMARY KEY (`CLIENT_ID`,`ROLE_ID`),
  KEY `FK_p3rh9grku11kqfrs4fltt7rnq` (`ROLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `SCOPE_MAPPING`
--

INSERT INTO `SCOPE_MAPPING` (`ROLE_ID`, `CLIENT_ID`) VALUES
  ('5ec819bb-6cee-4d8d-b1cd-f60f29afd1af', 'e156f8ee-7423-4448-8045-8d9a3b031331'),
  ('efc6c0da-725c-4e6e-9cd5-17744d9f4bb6', 'd81cdfcf-2d2f-4d52-9ed9-32d43c40b17e');

-- --------------------------------------------------------

--
-- Table structure for table `SimplePushVariant`
--

CREATE TABLE `SimplePushVariant` (
  `id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `SimplePushVariant`
--

INSERT INTO `SimplePushVariant` (`id`) VALUES
  ('c241ba2b-edc0-4585-8d98-aeff4665d930');

-- --------------------------------------------------------

--
-- Table structure for table `USERNAME_LOGIN_FAILURE`
--

CREATE TABLE `USERNAME_LOGIN_FAILURE` (
  `REALM_ID` varchar(36) NOT NULL,
  `USERNAME` varchar(200) NOT NULL,
  `FAILED_LOGIN_NOT_BEFORE` int(11) DEFAULT NULL,
  `LAST_FAILURE` bigint(20) DEFAULT NULL,
  `LAST_IP_FAILURE` varchar(255) DEFAULT NULL,
  `NUM_FAILURES` int(11) DEFAULT NULL,
  PRIMARY KEY (`REALM_ID`,`USERNAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `USER_ATTRIBUTE`
--

CREATE TABLE `USER_ATTRIBUTE` (
  `NAME` varchar(255) NOT NULL,
  `VALUE` varchar(255) DEFAULT NULL,
  `USER_ID` varchar(36) NOT NULL,
  PRIMARY KEY (`NAME`,`USER_ID`),
  KEY `FK_5hrm2vlf9ql5fu043kqepovbr` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `USER_ENTITY`
--

CREATE TABLE `USER_ENTITY` (
  `ID` varchar(36) NOT NULL,
  `EMAIL` varchar(255) DEFAULT NULL,
  `EMAIL_CONSTRAINT` varchar(255) DEFAULT NULL,
  `EMAIL_VERIFIED` bit(1) DEFAULT NULL,
  `ENABLED` bit(1) DEFAULT NULL,
  `federation_link` varchar(255) DEFAULT NULL,
  `FIRST_NAME` varchar(255) DEFAULT NULL,
  `LAST_NAME` varchar(255) DEFAULT NULL,
  `REALM_ID` varchar(255) DEFAULT NULL,
  `TOTP` bit(1) DEFAULT NULL,
  `USERNAME` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `UK_ru8tt6t700s9v50bu18ws5ha6` (`REALM_ID`,`USERNAME`),
  UNIQUE KEY `UK_dykn684sl8up1crfei6eckhd7` (`REALM_ID`,`EMAIL_CONSTRAINT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `USER_ENTITY`
--

INSERT INTO `USER_ENTITY` (`ID`, `EMAIL`, `EMAIL_CONSTRAINT`, `EMAIL_VERIFIED`, `ENABLED`, `federation_link`, `FIRST_NAME`, `LAST_NAME`, `REALM_ID`, `TOTP`, `USERNAME`) VALUES
  ('732bc092-6ca3-461c-ba79-93a8d969f316', NULL, '37d7a6f6-53ee-4e14-b5dd-81ceeb54de9a', '\0', '
', NULL, NULL, NULL, '5ab8a5e3-1931-423b-910f-b888e732b480', '\0', 'admin');

-- --------------------------------------------------------

--
-- Table structure for table `USER_FEDERATION_CONFIG`
--

CREATE TABLE `USER_FEDERATION_CONFIG` (
  `USER_FEDERATION_PROVIDER_ID` varchar(36) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`USER_FEDERATION_PROVIDER_ID`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `USER_FEDERATION_PROVIDER`
--

CREATE TABLE `USER_FEDERATION_PROVIDER` (
  `ID` varchar(36) NOT NULL,
  `CHANGED_SYNC_PERIOD` int(11) DEFAULT NULL,
  `DISPLAY_NAME` varchar(255) DEFAULT NULL,
  `FULL_SYNC_PERIOD` int(11) DEFAULT NULL,
  `LAST_SYNC` int(11) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `PROVIDER_NAME` varchar(255) DEFAULT NULL,
  `REALM_ID` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_1fj32f6ptolw2qy60cd8n01e8` (`REALM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `USER_REQUIRED_ACTION`
--

CREATE TABLE `USER_REQUIRED_ACTION` (
  `ACTION` int(11) NOT NULL,
  `USER_ID` varchar(36) NOT NULL,
  PRIMARY KEY (`ACTION`,`USER_ID`),
  KEY `FK_6qj3w1jw9cvafhe19bwsiuvmd` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `USER_ROLE_MAPPING`
--

CREATE TABLE `USER_ROLE_MAPPING` (
  `ROLE_ID` varchar(255) NOT NULL,
  `USER_ID` varchar(36) NOT NULL,
  PRIMARY KEY (`ROLE_ID`,`USER_ID`),
  KEY `FK_c4fqv34p1mbylloxang7b1q3l` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `USER_ROLE_MAPPING`
--

INSERT INTO `USER_ROLE_MAPPING` (`ROLE_ID`, `USER_ID`) VALUES
  ('5ec819bb-6cee-4d8d-b1cd-f60f29afd1af', '732bc092-6ca3-461c-ba79-93a8d969f316'),
  ('9ca707d0-0e6c-4c72-98bb-5c9f4f649a8c', '732bc092-6ca3-461c-ba79-93a8d969f316'),
  ('f6ff7509-237c-4198-be12-787f43c29b6a', '732bc092-6ca3-461c-ba79-93a8d969f316');

-- --------------------------------------------------------

--
-- Table structure for table `USER_SESSION`
--

CREATE TABLE `USER_SESSION` (
  `ID` varchar(36) NOT NULL,
  `AUTH_METHOD` varchar(255) DEFAULT NULL,
  `IP_ADDRESS` varchar(255) DEFAULT NULL,
  `LAST_SESSION_REFRESH` int(11) DEFAULT NULL,
  `LOGIN_USERNAME` varchar(255) DEFAULT NULL,
  `REALM_ID` varchar(255) DEFAULT NULL,
  `REMEMBER_ME` bit(1) DEFAULT NULL,
  `STARTED` int(11) DEFAULT NULL,
  `USER_ID` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `USER_SOCIAL_LINK`
--

CREATE TABLE `USER_SOCIAL_LINK` (
  `SOCIAL_PROVIDER` varchar(255) NOT NULL,
  `REALM_ID` varchar(255) DEFAULT NULL,
  `SOCIAL_USER_ID` varchar(255) DEFAULT NULL,
  `SOCIAL_USERNAME` varchar(255) DEFAULT NULL,
  `USER_ID` varchar(36) NOT NULL,
  PRIMARY KEY (`SOCIAL_PROVIDER`,`USER_ID`),
  KEY `FK_68cjys5uwm55uy823y75xg4om` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `Variant`
--

CREATE TABLE `Variant` (
  `VARIANT_TYPE` varchar(31) NOT NULL,
  `id` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `developer` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `secret` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `variantID` varchar(255) DEFAULT NULL,
  `variants_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_jlpkx1qkcjaps25wqhp4nkfel` (`variantID`),
  KEY `FK_7vjqh1lbqvlh4ni98qnh8hxkr` (`variants_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Variant`
--

INSERT INTO `Variant` (`VARIANT_TYPE`, `id`, `description`, `developer`, `name`, `secret`, `type`, `variantID`, `variants_id`) VALUES
  ('simplePush', 'c241ba2b-edc0-4585-8d98-aeff4665d930', NULL, 'admin', 'Simple', 'afbbfafe-03eb-4b89-9348-761b4b318e32', 2, 'd390e0b4-a636-4823-a121-2116f8ea55e9', '4ac59286-0cb0-4290-95fb-b917f88892f2');

-- --------------------------------------------------------

--
-- Table structure for table `VariantMetricInformation`
--

CREATE TABLE `VariantMetricInformation` (
  `id` varchar(255) NOT NULL,
  `deliveryStatus` bit(1) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `receivers` bigint(20) NOT NULL,
  `variantID` varchar(255) NOT NULL,
  `variantInformations_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_ci9sa3eevtel9l172w9b0musj` (`variantInformations_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `WEB_ORIGINS`
--

CREATE TABLE `WEB_ORIGINS` (
  `CLIENT_ID` varchar(36) NOT NULL,
  `VALUE` varchar(255) DEFAULT NULL,
  KEY `FK_lojpho213xcx4wnkog82ssrfy` (`CLIENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `AndroidVariant`
--
ALTER TABLE `AndroidVariant`
ADD CONSTRAINT `FK_abna7p5c0p8ju2pf4ucqv5cby` FOREIGN KEY (`id`) REFERENCES `Variant` (`id`);

--
-- Constraints for table `APPLICATION_DEFAULT_ROLES`
--
ALTER TABLE `APPLICATION_DEFAULT_ROLES`
ADD CONSTRAINT `FK_maylts7klwqw2h8m2b5joytky` FOREIGN KEY (`APPLICATION_ID`) REFERENCES `CLIENT` (`ID`),
ADD CONSTRAINT `FK_8aelwnibji49avxsrtuf6xjow` FOREIGN KEY (`ROLE_ID`) REFERENCES `KEYCLOAK_ROLE` (`id`);

--
-- Constraints for table `ChromePackagedAppVariant`
--
ALTER TABLE `ChromePackagedAppVariant`
ADD CONSTRAINT `FK_craam2a14eghbd6ohlnbbe7bq` FOREIGN KEY (`id`) REFERENCES `Variant` (`id`);

--
-- Constraints for table `CLIENT`
--
ALTER TABLE `CLIENT`
ADD CONSTRAINT `FK_p56ctinxxb9gsk57fo49f9tac` FOREIGN KEY (`REALM_ID`) REFERENCES `REALM` (`ID`);

--
-- Constraints for table `CLIENT_SESSION`
--
ALTER TABLE `CLIENT_SESSION`
ADD CONSTRAINT `FK_b4ao2vcvat6ukau74wbwtfqo1` FOREIGN KEY (`SESSION_ID`) REFERENCES `USER_SESSION` (`ID`);

--
-- Constraints for table `CLIENT_SESSION_ROLE`
--
ALTER TABLE `CLIENT_SESSION_ROLE`
ADD CONSTRAINT `FK_11b7sgqw18i532811v7o2dv76` FOREIGN KEY (`CLIENT_SESSION`) REFERENCES `CLIENT_SESSION` (`ID`);

--
-- Constraints for table `COMPOSITE_ROLE`
--
ALTER TABLE `COMPOSITE_ROLE`
ADD CONSTRAINT `FK_a63wvekftu8jo1pnj81e7mce2` FOREIGN KEY (`COMPOSITE`) REFERENCES `KEYCLOAK_ROLE` (`id`),
ADD CONSTRAINT `FK_gr7thllb9lu8q4vqa4524jjy8` FOREIGN KEY (`CHILD_ROLE`) REFERENCES `KEYCLOAK_ROLE` (`id`);

--
-- Constraints for table `CREDENTIAL`
--
ALTER TABLE `CREDENTIAL`
ADD CONSTRAINT `FK_pfyr0glasqyl0dei3kl69r6v0` FOREIGN KEY (`USER_ID`) REFERENCES `USER_ENTITY` (`ID`);

--
-- Constraints for table `FED_PROVIDERS`
--
ALTER TABLE `FED_PROVIDERS`
ADD CONSTRAINT `FK_213lyq09fkxq8k8ny8dy3737t` FOREIGN KEY (`REALM_ID`) REFERENCES `REALM` (`ID`),
ADD CONSTRAINT `FK_dccirjlipu1478vqc89did88c` FOREIGN KEY (`userFederationProviders_ID`) REFERENCES `USER_FEDERATION_PROVIDER` (`ID`);

--
-- Constraints for table `Installation`
--
ALTER TABLE `Installation`
ADD CONSTRAINT `FK_se07q3nt9pb7v949p4ia77uvc` FOREIGN KEY (`variantID`) REFERENCES `Variant` (`variantID`);

--
-- Constraints for table `Installation_categories`
--
ALTER TABLE `Installation_categories`
ADD CONSTRAINT `FK_7jk4ols9cel7xo5bi10yk1gvl` FOREIGN KEY (`Installation_id`) REFERENCES `Installation` (`id`);

--
-- Constraints for table `iOSVariant`
--
ALTER TABLE `iOSVariant`
ADD CONSTRAINT `FK_a7ndfcxa9m4wt4m2x2mxajr56` FOREIGN KEY (`id`) REFERENCES `Variant` (`id`);

--
-- Constraints for table `KEYCLOAK_ROLE`
--
ALTER TABLE `KEYCLOAK_ROLE`
ADD CONSTRAINT `FK_6vyqfe4cn4wlq8r6kt5vdsj5c` FOREIGN KEY (`REALM`) REFERENCES `REALM` (`ID`),
ADD CONSTRAINT `FK_pimo5le2c0ral09fl8cm9wfw9` FOREIGN KEY (`APPLICATION`) REFERENCES `CLIENT` (`ID`);

--
-- Constraints for table `REALM`
--
ALTER TABLE `REALM`
ADD CONSTRAINT `FK_rsaf444kk6qrkms7n56aiwq5y` FOREIGN KEY (`MASTER_ADMIN_APP`) REFERENCES `CLIENT` (`ID`);

--
-- Constraints for table `REALM_APPLICATION`
--
ALTER TABLE `REALM_APPLICATION`
ADD CONSTRAINT `FK_71s3p0diuxawwqqsa528uby2q` FOREIGN KEY (`APPLICATION_ID`) REFERENCES `REALM` (`ID`),
ADD CONSTRAINT `FK_l5qga3rfme47335jy8jxyxh3i` FOREIGN KEY (`REALM_ID`) REFERENCES `CLIENT` (`ID`);

--
-- Constraints for table `REALM_ATTRIBUTE`
--
ALTER TABLE `REALM_ATTRIBUTE`
ADD CONSTRAINT `FK_8shxd6l3e9atqukacxgpffptw` FOREIGN KEY (`REALM_ID`) REFERENCES `REALM` (`ID`);

--
-- Constraints for table `REALM_DEFAULT_ROLES`
--
ALTER TABLE `REALM_DEFAULT_ROLES`
ADD CONSTRAINT `FK_evudb1ppw84oxfax2drs03icc` FOREIGN KEY (`REALM_ID`) REFERENCES `REALM` (`ID`),
ADD CONSTRAINT `FK_h4wpd7w4hsoolni3h0sw7btje` FOREIGN KEY (`ROLE_ID`) REFERENCES `KEYCLOAK_ROLE` (`id`);

--
-- Constraints for table `REALM_EVENTS_LISTENERS`
--
ALTER TABLE `REALM_EVENTS_LISTENERS`
ADD CONSTRAINT `FK_h846o4h0w8epx5nxev9f5y69j` FOREIGN KEY (`REALM_ID`) REFERENCES `REALM` (`ID`);

--
-- Constraints for table `REALM_REQUIRED_CREDENTIAL`
--
ALTER TABLE `REALM_REQUIRED_CREDENTIAL`
ADD CONSTRAINT `FK_5hg65lybevavkqfki3kponh9v` FOREIGN KEY (`REALM_ID`) REFERENCES `REALM` (`ID`);

--
-- Constraints for table `REALM_SMTP_CONFIG`
--
ALTER TABLE `REALM_SMTP_CONFIG`
ADD CONSTRAINT `FK_70ej8xdxgxd0b9hh6180irr0o` FOREIGN KEY (`REALM_ID`) REFERENCES `REALM` (`ID`);

--
-- Constraints for table `REALM_SOCIAL_CONFIG`
--
ALTER TABLE `REALM_SOCIAL_CONFIG`
ADD CONSTRAINT `FK_sv5i3c2ti7g0g922fge683sov` FOREIGN KEY (`REALM_ID`) REFERENCES `REALM` (`ID`);

--
-- Constraints for table `REDIRECT_URIS`
--
ALTER TABLE `REDIRECT_URIS`
ADD CONSTRAINT `FK_1burs8pb4ouj97h5wuppahv9f` FOREIGN KEY (`CLIENT_ID`) REFERENCES `CLIENT` (`ID`);

--
-- Constraints for table `SCOPE_MAPPING`
--
ALTER TABLE `SCOPE_MAPPING`
ADD CONSTRAINT `FK_ouse064plmlr732lxjcn1q5f1` FOREIGN KEY (`CLIENT_ID`) REFERENCES `CLIENT` (`ID`),
ADD CONSTRAINT `FK_p3rh9grku11kqfrs4fltt7rnq` FOREIGN KEY (`ROLE_ID`) REFERENCES `KEYCLOAK_ROLE` (`id`);

--
-- Constraints for table `SimplePushVariant`
--
ALTER TABLE `SimplePushVariant`
ADD CONSTRAINT `FK_hombuwogx5wv7hnup407gnwpg` FOREIGN KEY (`id`) REFERENCES `Variant` (`id`);

--
-- Constraints for table `USER_ATTRIBUTE`
--
ALTER TABLE `USER_ATTRIBUTE`
ADD CONSTRAINT `FK_5hrm2vlf9ql5fu043kqepovbr` FOREIGN KEY (`USER_ID`) REFERENCES `USER_ENTITY` (`ID`);

--
-- Constraints for table `USER_FEDERATION_CONFIG`
--
ALTER TABLE `USER_FEDERATION_CONFIG`
ADD CONSTRAINT `FK_t13hpu1j94r2ebpekr39x5eu5` FOREIGN KEY (`USER_FEDERATION_PROVIDER_ID`) REFERENCES `USER_FEDERATION_PROVIDER` (`ID`);

--
-- Constraints for table `USER_FEDERATION_PROVIDER`
--
ALTER TABLE `USER_FEDERATION_PROVIDER`
ADD CONSTRAINT `FK_1fj32f6ptolw2qy60cd8n01e8` FOREIGN KEY (`REALM_ID`) REFERENCES `REALM` (`ID`);

--
-- Constraints for table `USER_REQUIRED_ACTION`
--
ALTER TABLE `USER_REQUIRED_ACTION`
ADD CONSTRAINT `FK_6qj3w1jw9cvafhe19bwsiuvmd` FOREIGN KEY (`USER_ID`) REFERENCES `USER_ENTITY` (`ID`);

--
-- Constraints for table `USER_ROLE_MAPPING`
--
ALTER TABLE `USER_ROLE_MAPPING`
ADD CONSTRAINT `FK_c4fqv34p1mbylloxang7b1q3l` FOREIGN KEY (`USER_ID`) REFERENCES `USER_ENTITY` (`ID`);

--
-- Constraints for table `USER_SOCIAL_LINK`
--
ALTER TABLE `USER_SOCIAL_LINK`
ADD CONSTRAINT `FK_68cjys5uwm55uy823y75xg4om` FOREIGN KEY (`USER_ID`) REFERENCES `USER_ENTITY` (`ID`);

--
-- Constraints for table `Variant`
--
ALTER TABLE `Variant`
ADD CONSTRAINT `FK_7vjqh1lbqvlh4ni98qnh8hxkr` FOREIGN KEY (`variants_id`) REFERENCES `PushApplication` (`id`);

--
-- Constraints for table `VariantMetricInformation`
--
ALTER TABLE `VariantMetricInformation`
ADD CONSTRAINT `FK_ci9sa3eevtel9l172w9b0musj` FOREIGN KEY (`variantInformations_id`) REFERENCES `PushMessageInformation` (`id`);

--
-- Constraints for table `WEB_ORIGINS`
--
ALTER TABLE `WEB_ORIGINS`
ADD CONSTRAINT `FK_lojpho213xcx4wnkog82ssrfy` FOREIGN KEY (`CLIENT_ID`) REFERENCES `CLIENT` (`ID`);