"Fossies" - the Fresh Open Source Software Archive

Member "cells-3.0.0/idm/user/migrations/sqlite3/0.1.sql" (25 Oct 2021, 429 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_user_attributes (
    3     uuid         VARCHAR(128) NOT NULL,
    4     name       VARCHAR(255) NOT NULL,
    5     value      TEXT,
    6 
    7     PRIMARY KEY (uuid, name)
    8 );
    9 
   10 CREATE TABLE IF NOT EXISTS idm_user_roles (
   11     uuid         VARCHAR(128) NOT NULL,
   12     role       VARCHAR(255) NOT NULL,
   13 
   14     PRIMARY KEY (uuid, role)
   15 );
   16 
   17 -- +migrate Down
   18 DROP TABLE idm_user_attributes;
   19 DROP TABLE idm_user_roles;