"Fossies" - the Fresh Open Source Software Archive

Member "cells-3.0.0/idm/workspace/migrations/mysql/0.1.sql" (25 Oct 2021, 397 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_workspaces (
    3     uuid VARCHAR(128) NOT NULL,
    4     label VARCHAR(500) NOT NULL,
    5     description VARCHAR(1000) NULL,
    6     attributes VARCHAR (2000) NULL,
    7     slug VARCHAR(500) NOT NULL,
    8     scope INT(1),
    9     last_updated INT,
   10 
   11     PRIMARY KEY (uuid),
   12     UNIQUE (slug),
   13     INDEX (label),
   14     INDEX (scope)
   15 );
   16 
   17 -- +migrate Down
   18 DROP TABLE idm_workspaces;