001_AuthStore.sql 410 B

123456789101112131415161718
  1. BEGIN TRANSACTION;
  2. CREATE TABLE auth (
  3. UUID char(36) NOT NULL,
  4. passwordHash char(32) NOT NULL default '',
  5. passwordSalt char(32) NOT NULL default '',
  6. webLoginKey varchar(255) NOT NULL default '',
  7. accountType VARCHAR(32) NOT NULL DEFAULT 'UserAccount',
  8. PRIMARY KEY (`UUID`)
  9. );
  10. CREATE TABLE tokens (
  11. UUID char(36) NOT NULL,
  12. token varchar(255) NOT NULL,
  13. validity datetime NOT NULL
  14. );
  15. COMMIT;