"Fossies" - the Fresh Open Source Software Archive

Member "cells-3.0.0/idm/oauth/migrations/sqlite3/0.1.sql" (25 Oct 2021, 692 Bytes) of package /linux/misc/pydio-cells-3.0.0.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 -- +migrate Up
    2 CREATE TABLE IF NOT EXISTS idm_personal_tokens (
    3      uuid VARCHAR(36) NOT NULL PRIMARY KEY ,
    4      access_token VARCHAR(128) NOT NULL,
    5      pat_type INT,
    6      label VARCHAR(255),
    7      user_uuid VARCHAR(255) NOT NULL,
    8      user_login VARCHAR(255) NOT NULL,
    9      auto_refresh INT default 0,
   10      expire_at INT,
   11      created_at INT,
   12      created_by VARCHAR(128),
   13      updated_at INT,
   14      scopes LONGTEXT
   15 );
   16 
   17 CREATE UNIQUE INDEX pat_unique_access_token_key ON idm_personal_tokens (access_token);
   18 CREATE INDEX pat_user_uuid_key ON idm_personal_tokens(user_uuid);
   19 CREATE INDEX pat_user_login_key ON idm_personal_tokens(user_login);
   20 
   21 -- +migrate Down
   22 DROP TABLE idm_personal_tokens;