/** Datei: plugins/agents/config/schema/v1.0.0.php **/
<?php
return array (
  'agents' => 
  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)',
      'phone' => 'VARCHAR(30)',
      'voice' => 'VARCHAR(255)',
    ),
    'primary' => 
    array (
      0 => 'id',
    ),
    'indexes' => 
    array (
    ),
    'engine' => 'InnoDB',
    'charset' => 'utf8mb3',
  ),
  'agents_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',
  ),
  'agents_processing' => 
  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',
      'status' => 'TINYINT(1) DEFAULT \'0\'',
      'type' => 'TINYINT(1) NOT NULL',
      'description' => 'TEXT',
    ),
    'primary' => 
    array (
      0 => 'id',
    ),
    'indexes' => 
    array (
      'origin_id' => 
      array (
        0 => 'origin_id',
      ),
    ),
    'engine' => 'InnoDB',
    'charset' => 'utf8mb3',
  ),
  'agents_processing_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',
  ),
  'agents_tools' => 
  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',
      'status' => 'TINYINT(1) DEFAULT \'0\'',
      'type' => 'TINYINT(1) NOT NULL',
      'description' => 'TEXT',
    ),
    'primary' => 
    array (
      0 => 'id',
    ),
    'indexes' => 
    array (
      'origin_id' => 
      array (
        0 => 'origin_id',
      ),
    ),
    'engine' => 'InnoDB',
    'charset' => 'utf8mb3',
  ),
  'agents_tools_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',
  ),
);