github.com/voedger/voedger@v0.0.0-20240520144910-273e84102129/pkg/state/sql_example_syspkg/system.vsql (about)

     1  -- Copyright (c) 2020-present unTill Pro, Ltd.
     2  
     3  -- note: this schema is for tests only. Voedger sys package uses copy of this schema
     4  
     5  ABSTRACT TABLE CRecord();
     6  ABSTRACT TABLE WRecord();
     7  ABSTRACT TABLE ORecord();
     8  ABSTRACT TABLE CDoc INHERITS CRecord();
     9  ABSTRACT TABLE ODoc INHERITS ORecord();
    10  ABSTRACT TABLE WDoc INHERITS WRecord();
    11  ABSTRACT TABLE Singleton INHERITS CDoc();
    12  ABSTRACT WORKSPACE Workspace ();
    13  ALTERABLE WORKSPACE Profile();
    14  
    15  TYPE Raw(
    16      Body   varchar(65535)
    17  );
    18  
    19  EXTENSION ENGINE BUILTIN (
    20  
    21      STORAGE Record(
    22          GET         SCOPE(COMMANDS, QUERIES, PROJECTORS),
    23          GETBATCH    SCOPE(COMMANDS, QUERIES, PROJECTORS),
    24          INSERT      SCOPE(COMMANDS),
    25          UPDATE      SCOPE(COMMANDS)
    26      ) ENTITY RECORD; -- used to validate projector state/intents declaration
    27  
    28  
    29      STORAGE View(
    30          GET         SCOPE(COMMANDS, QUERIES, PROJECTORS),
    31          GETBATCH    SCOPE(COMMANDS, QUERIES, PROJECTORS),
    32          READ        SCOPE(QUERIES, PROJECTORS),
    33          INSERT      SCOPE(PROJECTORS),
    34          UPDATE      SCOPE(PROJECTORS)
    35      ) ENTITY VIEW;
    36  
    37      STORAGE WLog(
    38          GET     SCOPE(COMMANDS, QUERIES, PROJECTORS),
    39          READ    SCOPE(QUERIES, PROJECTORS)
    40      );
    41  
    42      STORAGE PLog(
    43          GET     SCOPE(COMMANDS, QUERIES, PROJECTORS),
    44          READ    SCOPE(QUERIES, PROJECTORS)
    45      );
    46  
    47      STORAGE AppSecret(
    48          GET SCOPE(COMMANDS, QUERIES, PROJECTORS)
    49      );
    50  
    51      STORAGE Subject(
    52          GET SCOPE(COMMANDS, QUERIES)
    53      );
    54  
    55      STORAGE Http (
    56          READ SCOPE(QUERIES, PROJECTORS)
    57      );
    58  
    59      STORAGE SendMail(
    60          INSERT SCOPE(PROJECTORS)
    61      );
    62  
    63      STORAGE CmdResult(
    64          INSERT SCOPE(COMMANDS)
    65      );
    66  
    67  )