"Fossies" - the Fresh Open Source Software Archive

Member "cells-2.3.6/idm/meta/migrations/sqlite3/0.1.sql" (15 Sep 2021, 376 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_usr_meta (
    3     uuid            VARCHAR(255) NOT NULL,
    4     node_uuid       VARCHAR(255) NOT NULL,
    5     namespace       VARCHAR(255) NOT NULL,
    6     owner           VARCHAR(255),
    7     timestamp       INT(11),
    8     format          VARCHAR(50),
    9     data            BLOB,
   10     UNIQUE (uuid),
   11     UNIQUE (namespace,node_uuid,owner)
   12 );
   13 
   14 -- +migrate Down
   15 DROP TABLE idm_usr_meta;