"Fossies" - the Fresh Open Source Software Archive

Member "cells-2.3.6/idm/role/migrations/sqlite3/0.1.sql" (15 Sep 2021, 326 Bytes) of package /linux/misc/pydio-cells-2.3.6.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_roles (
    3     uuid            VARCHAR(255) NOT NULL,
    4     label           VARCHAR(500) NOT NULL,
    5     team_role       TINYINT(1),
    6     group_role      TINYINT(1),
    7     user_role       TINYINT(1),
    8     last_updated    INT,
    9     auto_applies    VARCHAR(500),
   10     UNIQUE (uuid)
   11 );
   12 
   13 -- +migrate Down
   14 DROP TABLE idm_roles;