OwlCyberSecurity - MANAGER
Edit File: Videos.php
<?php namespace PrestoPlayer\Database; use PrestoPlayer\Database\Table; class Videos { protected $table; protected $version = 4; protected $name = 'presto_player_videos'; public function __construct( Table $table ) { $this->table = $table; } public function getName() { global $wpdb; return $wpdb->prefix . $this->name; } /** * Add videos table * This is used for global video analytics * * @return void */ public function install() { return $this->table->create( $this->name, ' id bigint(20) unsigned NOT NULL auto_increment, title varchar(255) NOT NULL, type varchar(155) NOT NULL, external_id varchar(155) NULL, attachment_id bigint(20) unsigned NULL, post_id bigint(20) NULL, src varchar(255) NULL, created_by bigint(20) unsigned NULL, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP(), updated_at TIMESTAMP NOT NULL, deleted_at TIMESTAMP NULL, PRIMARY KEY (id), KEY external_id (external_id), KEY attachment_id (attachment_id), KEY created_at (created_at), KEY updated_at (updated_at) ', $this->version ); } /** * Uninstall tables * * @return void */ public function uninstall() { $this->table->drop( $this->getName() ); } public function exists() { return $this->table->exists( $this->name ); } }