/** Datei: plugins/events/config/schema/v1.0.0.php **/
<?php
return array (
  'events' => 
  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\'',
      'title' => 'VARCHAR(255)',
    ),
    'primary' => 
    array (
      0 => 'id',
    ),
    'indexes' => 
    array (
    ),
    'engine' => 'InnoDB',
    'charset' => 'utf8mb3',
  ),
  'events_bookings' => 
  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\'',
      'firstname' => 'VARCHAR(255)',
      'lastname' => 'VARCHAR(255)',
      'email' => 'VARCHAR(255)',
      'birthdate' => 'DATE',
      'ticket_id' => 'INT',
      'voucher_id' => 'VARCHAR(6)',
      'date_checkin' => 'DATETIME',
    ),
    'primary' => 
    array (
      0 => 'id',
    ),
    'indexes' => 
    array (
      'events_sales_uindex' => 
      array (
        0 => 'firstname',
        1 => 'lastname',
        2 => 'email',
        3 => 'voucher_id',
        4 => 'ticket_id',
      ),
    ),
    'engine' => 'InnoDB',
    'charset' => 'utf8mb3',
  ),
  'events_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',
  ),
  'events_tickets' => 
  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\'',
      'date_start' => 'DATETIME',
      'date_end' => 'DATETIME',
      'origin_id' => 'INT',
      'status' => 'TINYINT(1) DEFAULT \'0\'',
      'title' => 'VARCHAR(255) NOT NULL',
      'restriction' => 'TINYINT(1) DEFAULT \'0\'',
    ),
    'primary' => 
    array (
      0 => 'id',
    ),
    'indexes' => 
    array (
    ),
    'engine' => 'InnoDB',
    'charset' => 'utf8mb3',
  ),
  'events_tickets_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',
  ),
  'events_vouchers' => 
  array (
    'columns' => 
    array (
      'uuid' => 'VARCHAR(6) NOT NULL',
      'date_create' => 'DATETIME DEFAULT_GENERATED DEFAULT \'CURRENT_TIMESTAMP\'',
      'date_edit' => 'DATETIME DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP DEFAULT \'CURRENT_TIMESTAMP\'',
      'date_use' => 'DATETIME',
      'type' => 'TINYINT(1) DEFAULT \'0\'',
      'identifier' => 'VARCHAR(255)',
      'ticket_ids' => 'LONGTEXT',
    ),
    'primary' => 
    array (
      0 => 'uuid',
    ),
    'indexes' => 
    array (
    ),
    'engine' => 'InnoDB',
    'charset' => 'utf8mb3',
  ),
);