PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE oauth_jwt (
    client_id VARCHAR(80) NOT NULL,
    subject VARCHAR(80),
    public_key VARCHAR(2000),
    CONSTRAINT client_id_pk PRIMARY KEY (client_id)
);
CREATE TABLE oauth_scopes (is_default TINYINT(1) DEFAULT NULL, type VARCHAR(255), scope VARCHAR(2000), client_id VARCHAR (80));
COMMIT;
