daily pastebin goal
69%
SHARE
TWEET

Untitled

a guest Jun 13th, 2018 50 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SET storage_engine=INNODB;
  2. BEGIN;
  3. CREATE TABLE `pr_rsakey` (
  4.     `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
  5.     `desc` varchar(255) NOT NULL,
  6.     `data` longtext NOT NULL
  7. )
  8. ;
  9. CREATE TABLE `pr_application` (
  10.     `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
  11.     `name` varchar(255) NOT NULL,
  12.     `key_id` integer NOT NULL,
  13.     `accessToken_id` integer NULL
  14. )
  15. ;
  16. ALTER TABLE `pr_application` ADD CONSTRAINT key_id_refs_id_2d4a533b FOREIGN KEY (`key_id`) REFERENCES `pr_rsakey` (`id`);
  17. CREATE TABLE `pr_token` (
  18.     `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
  19.     `name` varchar(255) NOT NULL,
  20.     `description` varchar(2048) NULL,
  21.     `app_id` integer NOT NULL
  22. )
  23. ;
  24. ALTER TABLE `pr_token` ADD CONSTRAINT app_id_refs_id_2b9c995e FOREIGN KEY (`app_id`) REFERENCES `pr_application` (`id`);
  25. ALTER TABLE `pr_application` ADD CONSTRAINT accessToken_id_refs_id_6014d654 FOREIGN KEY (`accessToken_id`) REFERENCES `pr_token` (`id`);
  26. CREATE TABLE `pr_role` (
  27.     `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
  28.     `app_id` integer NOT NULL,
  29.     `name` varchar(255) NOT NULL
  30. )
  31. ;
  32. COMMIT;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top