SET storage_engine=INNODB;
BEGIN;
CREATE TABLE `pr_rsakey` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `desc` varchar(255) NOT NULL,
    `data` longtext NOT NULL
)
;
CREATE TABLE `pr_application` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `name` varchar(255) NOT NULL,
    `key_id` integer NOT NULL,
    `accessToken_id` integer NULL
)
;
ALTER TABLE `pr_application` ADD CONSTRAINT key_id_refs_id_2d4a533b FOREIGN KEY (`key_id`) REFERENCES `pr_rsakey` (`id`);
CREATE TABLE `pr_token` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `name` varchar(255) NOT NULL,
    `description` varchar(2048) NULL,
    `app_id` integer NOT NULL
)
;
ALTER TABLE `pr_token` ADD CONSTRAINT app_id_refs_id_2b9c995e FOREIGN KEY (`app_id`) REFERENCES `pr_application` (`id`);
ALTER TABLE `pr_application` ADD CONSTRAINT accessToken_id_refs_id_6014d654 FOREIGN KEY (`accessToken_id`) REFERENCES `pr_token` (`id`);
CREATE TABLE `pr_role` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `app_id` integer NOT NULL,
    `name` varchar(255) NOT NULL
)
;
COMMIT;