mirror of
https://github.com/appwrite/appwrite.git
synced 2026-05-26 13:51:13 +00:00
Jake Barnby
00565ea471
Address review feedback on PR #12194: - Pivot CTAs to pure descriptors (id/label/action/params). Drop the server-side execution layer: Action interface, registry, the databases.indexes.create CTA action, the params validator, the /v1/insights/:id/ctas/:id/executions endpoint, the InsightCTAExecution model, the INSIGHT_CTA_* errors, and the corresponding events. The console invokes the existing public API directly with the descriptor's action + params. - Restore Databases\Indexes\Action.php to its pre-CTA shape and inline the index-create body back into Create.php (the createIndex helper was added solely for CTA reuse). - Move insights collection from project DB to platform DB and add a parent reports collection alongside it. Insights carry projectId / projectInternalId for tenant scoping and an optional reportId for grouping. List endpoints filter by projectInternalId; Get/Update/ Delete also enforce project ownership before touching the document. - New Reports module with full CRUD (Create/Get/XList/Update/Delete), Report response model, Reports query validator, REPORT_NOT_FOUND / REPORT_ALREADY_EXISTS errors, reports.read / reports.write scopes, and reports.* event tree. Delete cascades to child insights. - Update.php now mutates the loaded document via setAttribute (instead of passing a partial new Document), reuses CTAsValidator (instead of the looser ArrayList<JSON> + isset check), and rejects duplicate CTA ids. - Create.php enforces unique CTA ids during normalization. - CTAsValidator gained a configurable maxCount (default 16) so the Create path matches the Update path and the DB column size, and oversized payloads return a clean 400. - Validator\Queries\Insights adds status and reportId to ALLOWED_ATTRIBUTES so dismissal / report workflows are filterable. - Realtime channel parser guards $parts[1] for both insights and reports event names. Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
2758 lines
93 KiB
PHP
2758 lines
93 KiB
PHP
<?php
|
|
|
|
use Utopia\Database\Database;
|
|
use Utopia\Database\Helpers\ID;
|
|
|
|
return [
|
|
'databases' => [
|
|
'$collection' => ID::custom(Database::METADATA),
|
|
'$id' => ID::custom('databases'),
|
|
'name' => 'Databases',
|
|
'attributes' => [
|
|
[
|
|
'$id' => ID::custom('name'),
|
|
'type' => Database::VAR_STRING,
|
|
'size' => 256,
|
|
'required' => true,
|
|
'signed' => true,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('enabled'),
|
|
'type' => Database::VAR_BOOLEAN,
|
|
'signed' => true,
|
|
'size' => 0,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'default' => true,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('search'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('originalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('type'),
|
|
'type' => Database::VAR_STRING,
|
|
'size' => 128,
|
|
'required' => false,
|
|
'default' => 'tablesdb',
|
|
'signed' => true,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('database'),
|
|
'type' => Database::VAR_STRING,
|
|
'size' => 2000,
|
|
'required' => false,
|
|
'signed' => true,
|
|
'array' => false,
|
|
'filters' => [],
|
|
]
|
|
],
|
|
'indexes' => [
|
|
[
|
|
'$id' => ID::custom('_fulltext_search'),
|
|
'type' => Database::INDEX_FULLTEXT,
|
|
'attributes' => ['search'],
|
|
'lengths' => [],
|
|
'orders' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_name'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['name'],
|
|
'lengths' => [256],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
],
|
|
],
|
|
|
|
'attributes' => [
|
|
'$collection' => ID::custom(Database::METADATA),
|
|
'$id' => ID::custom('attributes'),
|
|
'name' => 'Attributes',
|
|
'attributes' => [
|
|
[
|
|
'$id' => ID::custom('databaseInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('databaseId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => false,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('collectionInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('collectionId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('key'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('type'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 256,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('status'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('error'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 2048,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('size'),
|
|
'type' => Database::VAR_INTEGER,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('required'),
|
|
'type' => Database::VAR_BOOLEAN,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('default'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['casting'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('signed'),
|
|
'type' => Database::VAR_BOOLEAN,
|
|
'size' => 0,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('array'),
|
|
'type' => Database::VAR_BOOLEAN,
|
|
'size' => 0,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('format'),
|
|
'type' => Database::VAR_STRING,
|
|
'size' => 64,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('formatOptions'),
|
|
'type' => Database::VAR_STRING,
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => new stdClass(),
|
|
'array' => false,
|
|
'filters' => ['json', 'range', 'enum'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('filters'),
|
|
'type' => Database::VAR_STRING,
|
|
'size' => 64,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => true,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('options'),
|
|
'type' => Database::VAR_STRING,
|
|
'size' => 16384,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['json'],
|
|
],
|
|
],
|
|
'indexes' => [
|
|
[
|
|
'$id' => ID::custom('_key_db_collection'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['databaseInternalId', 'collectionInternalId'],
|
|
'lengths' => [Database::LENGTH_KEY, Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC, Database::ORDER_ASC],
|
|
],
|
|
],
|
|
],
|
|
|
|
'indexes' => [
|
|
'$collection' => ID::custom(Database::METADATA),
|
|
'$id' => ID::custom('indexes'),
|
|
'name' => 'Indexes',
|
|
'attributes' => [
|
|
[
|
|
'$id' => ID::custom('databaseInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('databaseId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => false,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('collectionInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('collectionId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('key'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('type'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('status'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('error'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 2048,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('attributes'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => true,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('lengths'),
|
|
'type' => Database::VAR_INTEGER,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => true,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('orders'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 4,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => true,
|
|
'filters' => [],
|
|
],
|
|
],
|
|
'indexes' => [
|
|
[
|
|
'$id' => ID::custom('_key_db_collection'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['databaseInternalId', 'collectionInternalId'],
|
|
'lengths' => [Database::LENGTH_KEY, Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC, Database::ORDER_ASC],
|
|
],
|
|
],
|
|
],
|
|
|
|
'functions' => [
|
|
'$collection' => ID::custom(Database::METADATA),
|
|
'$id' => ID::custom('functions'),
|
|
'name' => 'Functions',
|
|
'attributes' => [
|
|
[
|
|
'$id' => ID::custom('execute'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 128,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => true,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('name'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 2048,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('enabled'),
|
|
'type' => Database::VAR_BOOLEAN,
|
|
'signed' => true,
|
|
'size' => 0,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => true,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('live'),
|
|
'type' => Database::VAR_BOOLEAN,
|
|
'signed' => true,
|
|
'size' => 0,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => true,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('installationId'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('installationInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerRepositoryId'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('repositoryId'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('repositoryInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerBranch'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerRootDirectory'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerSilentMode'),
|
|
'type' => Database::VAR_BOOLEAN,
|
|
'signed' => true,
|
|
'size' => 0,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'default' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('logging'),
|
|
'type' => Database::VAR_BOOLEAN,
|
|
'signed' => true,
|
|
'size' => 0,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => true,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('runtime'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 2048,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('deploymentRetention'),
|
|
'type' => Database::VAR_INTEGER,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => 0,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('deploymentInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('deploymentId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('deploymentCreatedAt'),
|
|
'type' => Database::VAR_DATETIME,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['datetime'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('latestDeploymentId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('latestDeploymentInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('latestDeploymentCreatedAt'),
|
|
'type' => Database::VAR_DATETIME,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['datetime'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('latestDeploymentStatus'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => '',
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('vars'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['subQueryVariables'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('varsProject'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['subQueryProjectVariables'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('events'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 256,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => true,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('scheduleInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('scheduleId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('schedule'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 128,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('timeout'),
|
|
'type' => Database::VAR_INTEGER,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('search'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('version'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 8,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => 'v5',
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('entrypoint'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('commands'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
// At the moment, always empty (no runtime supports it yet)
|
|
'array' => false,
|
|
'$id' => ID::custom('startCommand'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 20000,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('specification'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 128,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => APP_COMPUTE_SPECIFICATION_DEFAULT,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('buildSpecification'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 128,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => APP_COMPUTE_SPECIFICATION_DEFAULT,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('runtimeSpecification'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 128,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => APP_COMPUTE_SPECIFICATION_DEFAULT,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('scopes'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => [],
|
|
'array' => true,
|
|
'filters' => [],
|
|
],
|
|
],
|
|
'indexes' => [
|
|
[
|
|
'$id' => ID::custom('_key_search'),
|
|
'type' => Database::INDEX_FULLTEXT,
|
|
'attributes' => ['search'],
|
|
'lengths' => [],
|
|
'orders' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_name'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['name'],
|
|
'lengths' => [256],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_enabled'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['enabled'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_installationId'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['installationId'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_installationInternalId'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['installationInternalId'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_providerRepositoryId'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['providerRepositoryId'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_repositoryId'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['repositoryId'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_repositoryInternalId'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['repositoryInternalId'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_runtime'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['runtime'],
|
|
'lengths' => [64],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_deploymentId'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['deploymentId'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
]
|
|
],
|
|
],
|
|
|
|
'sites' => [
|
|
'$collection' => ID::custom(Database::METADATA),
|
|
'$id' => ID::custom('sites'),
|
|
'name' => 'Sites',
|
|
'attributes' => [
|
|
[
|
|
'$id' => ID::custom('name'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 2048,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('enabled'),
|
|
'type' => Database::VAR_BOOLEAN,
|
|
'signed' => true,
|
|
'size' => 0,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => true,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('live'),
|
|
'type' => Database::VAR_BOOLEAN,
|
|
'signed' => true,
|
|
'size' => 0,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => true,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('installationId'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('installationInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerRepositoryId'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('repositoryId'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('repositoryInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerBranch'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerRootDirectory'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerSilentMode'),
|
|
'type' => Database::VAR_BOOLEAN,
|
|
'signed' => true,
|
|
'size' => 0,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'default' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('logging'),
|
|
'type' => Database::VAR_BOOLEAN,
|
|
'signed' => true,
|
|
'size' => 0,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => true,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('framework'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 2048,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('outputDirectory'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('buildCommand'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('installCommand'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('startCommand'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 20000,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('fallbackFile'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('deploymentRetention'),
|
|
'type' => Database::VAR_INTEGER,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => 0,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('deploymentInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('deploymentId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('deploymentCreatedAt'),
|
|
'type' => Database::VAR_DATETIME,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['datetime'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('deploymentScreenshotLight'), // File ID from 'screenshots' Console bucket
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 32,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('deploymentScreenshotDark'), // File ID from 'screenshots' Console bucket
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 32,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('latestDeploymentId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('latestDeploymentInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('latestDeploymentCreatedAt'),
|
|
'type' => Database::VAR_DATETIME,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['datetime'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('latestDeploymentStatus'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => '',
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('vars'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['subQueryVariables'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('varsProject'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['subQueryProjectVariables'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('timeout'),
|
|
'type' => Database::VAR_INTEGER,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('search'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('specification'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 128,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => APP_COMPUTE_SPECIFICATION_DEFAULT,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('buildSpecification'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 128,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => APP_COMPUTE_SPECIFICATION_DEFAULT,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('runtimeSpecification'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 128,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => APP_COMPUTE_SPECIFICATION_DEFAULT,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('buildRuntime'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 2048,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => '',
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('adapter'), // ssr or static; named this way as it's a term in SSR frameworks
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => '',
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
],
|
|
'indexes' => [
|
|
[
|
|
'$id' => ID::custom('_key_search'),
|
|
'type' => Database::INDEX_FULLTEXT,
|
|
'attributes' => ['search'],
|
|
'lengths' => [],
|
|
'orders' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_name'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['name'],
|
|
'lengths' => [256],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_enabled'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['enabled'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_installationId'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['installationId'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_installationInternalId'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['installationInternalId'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_providerRepositoryId'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['providerRepositoryId'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_repositoryId'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['repositoryId'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_repositoryInternalId'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['repositoryInternalId'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_framework'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['framework'],
|
|
'lengths' => [64],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_deploymentId'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['deploymentId'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
]
|
|
],
|
|
],
|
|
|
|
'deployments' => [
|
|
'$collection' => ID::custom(Database::METADATA),
|
|
'$id' => ID::custom('deployments'),
|
|
'name' => 'Deployments',
|
|
'attributes' => [
|
|
[
|
|
'$id' => ID::custom('resourceInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('resourceId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('resourceType'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('entrypoint'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 2048,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('buildCommands'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('startCommand'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 20000,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('buildOutput'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('sourcePath'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('type'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 2048,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('installationId'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('installationInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerRepositoryId'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('repositoryId'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('repositoryInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerRepositoryName'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerRepositoryOwner'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerRepositoryUrl'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerCommitHash'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerCommitAuthorUrl'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerCommitAuthor'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerCommitMessage'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerCommitUrl'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerBranch'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerBranchUrl'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerRootDirectory'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => Database::LENGTH_KEY,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('providerCommentId'),
|
|
'type' => Database::VAR_STRING,
|
|
'signed' => true,
|
|
'size' => 2048,
|
|
'format' => '',
|
|
'filters' => [],
|
|
'required' => false,
|
|
'array' => false,
|
|
],
|
|
[
|
|
'$id' => ID::custom('sourceSize'),
|
|
'type' => Database::VAR_INTEGER,
|
|
'format' => '',
|
|
'size' => 8,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('sourceMetadata'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384, // https://tools.ietf.org/html/rfc4288#section-4.2
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['json'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('sourceChunksTotal'),
|
|
'type' => Database::VAR_INTEGER,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('sourceChunksUploaded'),
|
|
'type' => Database::VAR_INTEGER,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('activate'),
|
|
'type' => Database::VAR_BOOLEAN,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => false,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('screenshotLight'), // File ID from 'screenshots' Console bucket
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 32,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('screenshotDark'), // File ID from 'screenshots' Console bucket
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 32,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('buildStartedAt'),
|
|
'type' => Database::VAR_DATETIME,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['datetime'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('buildEndedAt'),
|
|
'type' => Database::VAR_DATETIME,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['datetime'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('buildDuration'),
|
|
'type' => Database::VAR_INTEGER,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('buildSize'),
|
|
'type' => Database::VAR_INTEGER,
|
|
'format' => '',
|
|
'size' => 8,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('totalSize'),
|
|
'type' => Database::VAR_INTEGER,
|
|
'format' => '',
|
|
'size' => 8,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('status'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => 'waiting',
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('buildPath'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => '',
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('buildLogs'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 1000000,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => '',
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('adapter'), // ssr or static; named this way as it's a term in SSR frameworks
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => '',
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('fallbackFile'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
]
|
|
],
|
|
'indexes' => [
|
|
[
|
|
'$id' => ID::custom('_key_resource'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['resourceId'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_resource_type'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['resourceType'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_sourceSize'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['sourceSize'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_buildSize'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['buildSize'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_totalSize'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['totalSize'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_buildDuration'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['buildDuration'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_activate'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['activate'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_type'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['type'],
|
|
'lengths' => [32],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_status'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['status'],
|
|
'lengths' => [16],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_resourceId_resourceType'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['resourceId', 'resourceType'],
|
|
'lengths' => [],
|
|
'orders' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_resource_internal_id'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['resourceInternalId'],
|
|
'lengths' => [],
|
|
'orders' => [],
|
|
],
|
|
],
|
|
],
|
|
|
|
'executions' => [
|
|
'$collection' => ID::custom(Database::METADATA),
|
|
'$id' => ID::custom('executions'),
|
|
'name' => 'Executions',
|
|
'attributes' => [
|
|
[
|
|
'$id' => ID::custom('resourceInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('resourceId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('resourceType'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('deploymentInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('deploymentId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('trigger'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 128,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('status'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 128,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('duration'),
|
|
'type' => Database::VAR_FLOAT,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('errors'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => APP_FUNCTION_ERROR_LENGTH_LIMIT,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('logs'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => APP_FUNCTION_LOG_LENGTH_LIMIT,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('requestMethod'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 128,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'array' => false,
|
|
'$id' => ID::custom('requestPath'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 2048,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('requestHeaders'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['json'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('responseStatusCode'),
|
|
'type' => Database::VAR_INTEGER,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('responseHeaders'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['json'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('scheduledAt'),
|
|
'type' => Database::VAR_DATETIME,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['datetime'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('scheduleInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('scheduleId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
],
|
|
'indexes' => [
|
|
[
|
|
'$id' => ID::custom('_key_resource'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['resourceInternalId', 'resourceType', 'resourceId'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_trigger'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['trigger'],
|
|
'lengths' => [32],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_status'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['status'],
|
|
'lengths' => [32],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_requestMethod'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['requestMethod'],
|
|
'lengths' => [128],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_requestPath'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['requestPath'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_deployment'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['deploymentId'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_responseStatusCode'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['responseStatusCode'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_duration'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['duration'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_resourceType'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['resourceType'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
],
|
|
],
|
|
|
|
'variables' => [
|
|
'$collection' => Database::METADATA,
|
|
'$id' => 'variables',
|
|
'name' => 'variables',
|
|
'attributes' => [
|
|
[
|
|
'$id' => ID::custom('resourceType'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 100,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('resourceInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('resourceId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => 'key',
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => 'value',
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 8192,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['encrypt']
|
|
],
|
|
[
|
|
'$id' => ID::custom('secret'),
|
|
'type' => Database::VAR_BOOLEAN,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => false,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('search'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
],
|
|
'indexes' => [
|
|
[
|
|
'$id' => '_key_resourceInternalId',
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['resourceInternalId'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [],
|
|
],
|
|
[
|
|
'$id' => '_key_resourceType',
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['resourceType'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => '_key_resourceId_resourceType',
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['resourceId', 'resourceType'],
|
|
'lengths' => [Database::LENGTH_KEY, 100],
|
|
'orders' => [Database::ORDER_ASC, Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => '_key_uniqueKey',
|
|
'type' => Database::INDEX_UNIQUE,
|
|
'attributes' => ['resourceId', 'key', 'resourceType'],
|
|
'lengths' => [Database::LENGTH_KEY, Database::LENGTH_KEY, 100],
|
|
'orders' => [Database::ORDER_ASC, Database::ORDER_ASC, Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => '_key_key',
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['key'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_fulltext_search'),
|
|
'type' => Database::INDEX_FULLTEXT,
|
|
'attributes' => ['search'],
|
|
'lengths' => [],
|
|
'orders' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_key_resource_internal_id_resource_type'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['resourceInternalId', 'resourceType'],
|
|
'lengths' => [],
|
|
'orders' => [],
|
|
],
|
|
],
|
|
],
|
|
|
|
'migrations' => [
|
|
'$collection' => ID::custom(Database::METADATA),
|
|
'$id' => ID::custom('migrations'),
|
|
'name' => 'Migrations',
|
|
'attributes' => [
|
|
[
|
|
'$id' => ID::custom('status'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('stage'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('source'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 8192, // reduce size
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('destination'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false, // make true after patch script
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('credentials'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 65536,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => [],
|
|
'array' => false,
|
|
'filters' => ['json', 'encrypt'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('options'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 65536,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => [],
|
|
'array' => false,
|
|
'filters' => ['json'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('resources'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => [],
|
|
'array' => true,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('statusCounters'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 3000,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['json'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('resourceData'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 131070,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['json'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('errors'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 1_000_000,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => true,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('search'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 16384,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('resourceId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('resourceType'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
],
|
|
'indexes' => [
|
|
[
|
|
'$id' => '_key_status',
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['status'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => '_key_stage',
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['stage'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => '_key_source',
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['source'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => '_key_resource_id',
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['resourceId'],
|
|
'lengths' => [Database::LENGTH_KEY],
|
|
'orders' => [Database::ORDER_DESC],
|
|
],
|
|
[
|
|
'$id' => ID::custom('_fulltext_search'),
|
|
'type' => Database::INDEX_FULLTEXT,
|
|
'attributes' => ['search'],
|
|
'lengths' => [],
|
|
'orders' => [],
|
|
]
|
|
],
|
|
],
|
|
|
|
'resourceTokens' => [
|
|
'$collection' => ID::custom(Database::METADATA),
|
|
'$id' => ID::custom('resourceTokens'),
|
|
'name' => 'Resource Tokens',
|
|
'attributes' => [
|
|
[
|
|
'$id' => ID::custom('resourceId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('resourceInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('resourceType'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 100,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('secret'),
|
|
'type' => Database::VAR_STRING,
|
|
'format' => '',
|
|
'size' => 512,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['encrypt'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('expire'),
|
|
'type' => Database::VAR_DATETIME,
|
|
'format' => '',
|
|
'size' => 255,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['datetime'],
|
|
],
|
|
[
|
|
'$id' => ID::custom('accessedAt'),
|
|
'type' => Database::VAR_DATETIME,
|
|
'format' => '',
|
|
'size' => 0,
|
|
'signed' => false,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['datetime'],
|
|
],
|
|
],
|
|
'indexes' => [
|
|
[
|
|
'$id' => '_key_expiry_date',
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['expire'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_ASC],
|
|
],
|
|
[
|
|
'$id' => '_key_accessedAt',
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['accessedAt'],
|
|
'lengths' => [],
|
|
'orders' => [],
|
|
],
|
|
[
|
|
'$id' => '_key_resourceInternalId_resourceType',
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['resourceInternalId', 'resourceType'],
|
|
'lengths' => [],
|
|
'orders' => [],
|
|
],
|
|
],
|
|
],
|
|
|
|
'transactions' => [
|
|
'$collection' => ID::custom(Database::METADATA),
|
|
'$id' => ID::custom('transactions'),
|
|
'name' => 'Transactions',
|
|
'attributes' => [
|
|
[
|
|
'$id' => ID::custom('status'),
|
|
'type' => Database::VAR_STRING,
|
|
'size' => 16, // pending | committing | committed | failed
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => 'pending',
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('operations'),
|
|
'type' => Database::VAR_INTEGER,
|
|
'size' => 0,
|
|
'signed' => false,
|
|
'required' => true,
|
|
'default' => 0,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('expiresAt'),
|
|
'type' => Database::VAR_DATETIME,
|
|
'size' => 0,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['datetime'],
|
|
],
|
|
],
|
|
'indexes' => [
|
|
[
|
|
'$id' => ID::custom('_key_expiresAt'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['expiresAt'],
|
|
'lengths' => [],
|
|
'orders' => [Database::ORDER_DESC],
|
|
],
|
|
],
|
|
],
|
|
|
|
'transactionLogs' => [
|
|
'$collection' => ID::custom(Database::METADATA),
|
|
'$id' => ID::custom('transactionLogs'),
|
|
'name' => 'Transaction Logs',
|
|
'attributes' => [
|
|
[
|
|
'$id' => ID::custom('transactionInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('databaseInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('collectionInternalId'),
|
|
'type' => Database::VAR_STRING,
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('documentId'),
|
|
'type' => Database::VAR_STRING,
|
|
'size' => Database::LENGTH_KEY,
|
|
'signed' => true,
|
|
'required' => false,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('action'),
|
|
'type' => Database::VAR_STRING,
|
|
'size' => 32, // create | update | upsert | increment | decrement | delete | bulkCreate | bulkUpdate | bulkUpsert | bulkDelete
|
|
'signed' => true,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => [],
|
|
],
|
|
[
|
|
'$id' => ID::custom('data'),
|
|
'type' => Database::VAR_STRING,
|
|
'size' => 5_000_000, // Allow large payloads for bulk operations
|
|
'signed' => false,
|
|
'required' => true,
|
|
'default' => null,
|
|
'array' => false,
|
|
'filters' => ['json'],
|
|
],
|
|
],
|
|
'indexes' => [
|
|
[
|
|
'$id' => ID::custom('_key_transaction'),
|
|
'type' => Database::INDEX_KEY,
|
|
'attributes' => ['transactionInternalId'],
|
|
'lengths' => [],
|
|
'orders' => [],
|
|
],
|
|
],
|
|
],
|
|
];
|