/** Datei: plugins/tenants/config/schema/v1.0.0.php **/
<?php
return array (
  'tenants' => 
  array (
    'columns' => 
    array (
      'id' => 'INT NOT NULL AUTO_INCREMENT',
      'date_create' => 'DATETIME DEFAULT_GENERATED DEFAULT \'CURRENT_TIMESTAMP\'',
      'date_edit' => 'DATETIME DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP DEFAULT \'CURRENT_TIMESTAMP\'',
      'status' => 'TINYINT(1) DEFAULT \'0\'',
      'name' => 'VARCHAR(255)',
      'domain' => 'VARCHAR(255)',
      'email' => 'VARCHAR(255)',
    ),
    'primary' => 
    array (
      0 => 'id',
    ),
    'indexes' => 
    array (
    ),
    'engine' => 'InnoDB',
    'charset' => 'utf8mb3',
  ),
  'tenants_meta' => 
  array (
    'columns' => 
    array (
      'id' => 'INT NOT NULL AUTO_INCREMENT',
      'date_create' => 'DATETIME DEFAULT_GENERATED DEFAULT \'CURRENT_TIMESTAMP\'',
      'date_edit' => 'DATETIME DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP DEFAULT \'CURRENT_TIMESTAMP\'',
      'origin_id' => 'INT NOT NULL',
      'meta_key' => 'VARCHAR(255) NOT NULL',
      'meta_value' => 'TEXT',
    ),
    'primary' => 
    array (
      0 => 'id',
    ),
    'indexes' => 
    array (
      'origin_id' => 
      array (
        0 => 'origin_id',
        1 => 'meta_key',
      ),
    ),
    'engine' => 'InnoDB',
    'charset' => 'utf8mb3',
  ),
  'tenants_systems' => 
  array (
    'columns' => 
    array (
      'id' => 'INT NOT NULL AUTO_INCREMENT',
      'date_create' => 'DATETIME DEFAULT_GENERATED DEFAULT \'CURRENT_TIMESTAMP\'',
      'date_edit' => 'DATETIME DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP DEFAULT \'CURRENT_TIMESTAMP\'',
      'status' => 'TINYINT(1) DEFAULT \'0\'',
      'tenant_id' => 'INT',
      'system_id' => 'INT',
      'db_name' => 'VARCHAR(20)',
      'db_status' => 'TINYINT(1) DEFAULT \'0\'',
    ),
    'primary' => 
    array (
      0 => 'id',
    ),
    'indexes' => 
    array (
      'tenants_systems_tenant_id_system_id_uindex' => 
      array (
        0 => 'tenant_id',
        1 => 'system_id',
      ),
    ),
    'engine' => 'InnoDB',
    'charset' => 'utf8mb3',
  ),
  'tenants_systems_users' => 
  array (
    'columns' => 
    array (
      'id' => 'INT NOT NULL AUTO_INCREMENT',
      'date_create' => 'DATETIME DEFAULT_GENERATED DEFAULT \'CURRENT_TIMESTAMP\'',
      'date_edit' => 'DATETIME DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP DEFAULT \'CURRENT_TIMESTAMP\'',
      'tenant_id' => 'INT',
      'system_id' => 'INT',
      'user_id' => 'INT',
      'hash' => 'VARCHAR(255)',
    ),
    'primary' => 
    array (
      0 => 'id',
    ),
    'indexes' => 
    array (
      'tenants_systems_users_system_id_tenant_id_hash_uindex' => 
      array (
        0 => 'system_id',
        1 => 'tenant_id',
        2 => 'hash',
      ),
      'tenants_systems_users_tenants_id_fk' => 
      array (
        0 => 'tenant_id',
      ),
    ),
    'engine' => 'InnoDB',
    'charset' => 'utf8mb3',
  ),
);