"Fossies" - the Fresh Open Source Software Archive

Member "cells-2.3.6/idm/workspace/migrations/sqlite3/0.1.sql" (15 Sep 2021, 506 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_workspaces (
    3     uuid VARCHAR(128) NOT NULL,
    4     label VARCHAR(500) NOT NULL,
    5     description VARCHAR(1000) NULL,
    6     attributes VARCHAR (2000),
    7     slug VARCHAR(500) NOT NULL,
    8     scope   TINYINT,
    9     last_updated INT,
   10 
   11     PRIMARY KEY (uuid),
   12     UNIQUE (slug)
   13 );
   14 CREATE INDEX IF NOT EXISTS idx_workspaces_label ON idm_workspaces (label);
   15 CREATE INDEX IF NOT EXISTS idx_workspaces_scope ON idm_workspaces (scope);
   16 
   17 -- +migrate Down
   18 DROP TABLE idm_workspaces;