EmailCollection.php — Presto Player 4.2.1

presto-player / inc / Database / EmailCollection.php

presto-player / inc / Database Last commit date

EmailCollection.php

65 lines

1	<?php
2
3	namespace PrestoPlayer\Database;
4
5	use PrestoPlayer\Database\Table;
6
7	class EmailCollection {
8
9	protected $table;
10	protected $version = 1;
11	protected $name = 'presto_player_email_collection';
12
13	public function __construct( Table $table ) {
14	$this->table = $table;
15	}
16
17	public function getName() {
18	global $wpdb;
19	return $wpdb->prefix . $this->name;
20	}
21
22	/**
23	* Add videos table
24	* This is used for global video analytics
25	*
26	* @return void
27	*/
28	public function install() {
29	return $this->table->create(
30	$this->name,
31	'
32	id bigint(20) unsigned NOT NULL auto_increment,
33	enabled boolean DEFAULT 0 NOT NULL,
34	behavior varchar(155) NOT NULL,
35	percentage bigint(20) NULL,
36	allow_skip boolean DEFAULT 0 NOT NULL,
37	headline varchar(155) NOT NULL,
38	bottom_text varchar(155) NOT NULL,
39	button_text varchar(155) NOT NULL,
40	preset_id bigint(20) NULL,
41	border_radius bigint(20) NOT NULL,
42	email_provider varchar(155) NULL,
43	email_provider_list varchar(155) NULL,
44	email_provider_tag varchar(155) NULL,
45	created_by bigint(20) unsigned NULL,
46	created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP(),
47	updated_at TIMESTAMP NOT NULL,
48	deleted_at TIMESTAMP NULL,
49	PRIMARY KEY (id),
50	KEY preset_id (preset_id)
51	',
52	$this->version
53	);
54	}
55
56	/**
57	* Uninstall tables
58	*
59	* @return void
60	*/
61	public function uninstall() {
62	$this->table->drop( $this->getName() );
63	}
64	}
65