aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/001_AuthStore.sql
blob: 468567dcc2404b3e2b83243d4b7682baa190dd9b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
BEGIN TRANSACTION;

CREATE TABLE auth (
  UUID char(36) NOT NULL,
  passwordHash char(32) NOT NULL default '',
  passwordSalt char(32) NOT NULL default '',
  webLoginKey varchar(255) NOT NULL default '',
  accountType VARCHAR(32) NOT NULL DEFAULT 'UserAccount',
  PRIMARY KEY  (`UUID`)
);

CREATE TABLE tokens (
  UUID char(36) NOT NULL,
  token varchar(255) NOT NULL,
  validity datetime NOT NULL
);

COMMIT;