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));
INSERT INTO "oauth_scopes" VALUES(0,NULL,'supportedscope1',NULL);
INSERT INTO "oauth_scopes" VALUES(0,NULL,'supportedscope2',NULL);
INSERT INTO "oauth_scopes" VALUES(0,NULL,'supportedscope3',NULL);
INSERT INTO "oauth_scopes" VALUES(1,NULL,'defaultscope2',NULL);
INSERT INTO "oauth_scopes" VALUES(1,NULL,'defaultscope1',NULL);
COMMIT;
