my own indieAuth provider!
indiko.dunkirk.sh/docs
indieauth
oauth2-server
1PRAGMA foreign_keys = OFF;
2
3CREATE TABLE users_new (
4 id INTEGER PRIMARY KEY AUTOINCREMENT,
5 username TEXT NOT NULL UNIQUE,
6 name TEXT NOT NULL,
7 email TEXT,
8 photo TEXT,
9 url TEXT,
10 status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'suspended', 'inactive')),
11 role TEXT NOT NULL DEFAULT 'user',
12 tier TEXT NOT NULL DEFAULT 'developer' CHECK(tier IN ('admin', 'developer', 'user')),
13 is_admin INTEGER NOT NULL DEFAULT 0,
14 created_at INTEGER NOT NULL DEFAULT (strftime('%s','now'))
15);
16
17INSERT INTO users_new (id, username, name, email, photo, url, status, role, tier, is_admin, created_at)
18SELECT
19 id,
20 username,
21 name,
22 email,
23 photo,
24 url,
25 status,
26 role,
27 CASE WHEN is_admin = 1 THEN 'admin' ELSE 'developer' END,
28 is_admin,
29 created_at
30FROM users;
31
32DROP TABLE users;
33
34ALTER TABLE users_new RENAME TO users;
35
36PRAGMA foreign_keys = ON;