"Fossies" - the Fresh Open Source Software Archive

Member "cells-2.3.6/data/meta/migrations/sqlite3/0.1.sql" (15 Sep 2021, 407 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 data_meta (
    3     node_id varchar(255) not null,
    4     namespace varchar(255) not null,
    5     author varchar(255),
    6     timestamp int(11),
    7     data blob,
    8     format varchar(255),
    9     unique(node_id, namespace)
   10 );
   11 
   12 CREATE INDEX data_meta_timestamp_idx ON data_meta(timestamp);
   13 CREATE INDEX data_meta_author_idx ON data_meta(author);
   14 
   15 -- +migrate Down
   16 DROP TABLE data_meta;