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 )