Single-sign-on and self-serve account management. https://netsyms.biz/apps/accounthub
Você não pode selecionar mais de 25 tópicos Os tópicos devem começar com uma letra ou um número, podem incluir traços ('-') e podem ter até 35 caracteres.

1234567891011121314151617181920212223242526272829303132333435
  1. /*
  2. * This Source Code Form is subject to the terms of the Mozilla Public
  3. * License, v. 2.0. If a copy of the MPL was not distributed with this
  4. * file, You can obtain one at http://mozilla.org/MPL/2.0/.
  5. */
  6. CREATE TABLE IF NOT EXISTS `userkeys` (
  7. `uid` INT(11) NOT NULL,
  8. `key` VARCHAR(100) NOT NULL,
  9. `created` DATETIME NULL DEFAULT NULL,
  10. `typeid` INT(11) NOT NULL,
  11. PRIMARY KEY (`uid`),
  12. INDEX `fk_userkeys_userkeytypes1_idx` (`typeid` ASC),
  13. CONSTRAINT `fk_userkeys_accounts1`
  14. FOREIGN KEY (`uid`)
  15. REFERENCES `accounthub`.`accounts` (`uid`)
  16. ON DELETE NO ACTION
  17. ON UPDATE NO ACTION,
  18. CONSTRAINT `fk_userkeys_userkeytypes1`
  19. FOREIGN KEY (`typeid`)
  20. REFERENCES `accounthub`.`userkeytypes` (`typeid`)
  21. ON DELETE NO ACTION
  22. ON UPDATE NO ACTION)
  23. ENGINE = InnoDB
  24. DEFAULT CHARACTER SET = utf8;
  25. CREATE TABLE IF NOT EXISTS `userkeytypes` (
  26. `typeid` INT(11) NOT NULL,
  27. `typename` VARCHAR(45) NOT NULL,
  28. PRIMARY KEY (`typeid`, `typename`))
  29. ENGINE = InnoDB
  30. DEFAULT CHARACTER SET = utf8;
  31. INSERT INTO `userkeytypes` (`typeid`, `typename`) VALUES (1, 'RSSAtomFeed');
  32. INSERT INTO `userkeytypes` (`typeid`, `typename`) VALUES (2, 'Other');