1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146
<?php
namespace MatthiasWeb\RealMediaLibrary\general;
use MatthiasWeb\RealMediaLibrary\base;
defined( 'ABSPATH' ) or die( 'No script kiddies please!' );
class Activator extends base\Base {
public function activate() {
}
public function deactivate() {
}
public function install($errorlevel = false, $installThisCallable = null) {
global $wpdb;
require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
$charset_collate = $wpdb->get_charset_collate();
if ($errorlevel === false) {
$show_errors = $wpdb->show_errors(false);
$suppress_errors = $wpdb->suppress_errors(false);
$errorLevel = error_reporting();
error_reporting(0);
}
if ($installThisCallable === null) {
$table_name = $this->getTableName();
$sql = "CREATE TABLE $table_name (
id mediumint(9) NOT NULL AUTO_INCREMENT,
parent mediumint(9) DEFAULT '-1' NOT NULL,
name tinytext NOT NULL,
slug text DEFAULT '' NOT NULL,
absolute text DEFAULT '' NOT NULL,
owner bigint(20) NOT NULL,
ord mediumint(10) DEFAULT 0 NOT NULL,
contentCustomOrder tinyint(1) DEFAULT 0 NOT NULL,
type varchar(10) DEFAULT '0' NOT NULL,
restrictions varchar(255) DEFAULT '' NOT NULL,
cnt mediumint(10) DEFAULT NULL,
importId bigint(20) DEFAULT NULL,
UNIQUE KEY id (id)
) $charset_collate;";
dbDelta( $sql );
if ($errorlevel) {
$wpdb->print_error();
}
$table_name = $this->getTableName("posts");
$sql = "CREATE TABLE $table_name (
attachment bigint(20) NOT NULL,
fid mediumint(9) NOT NULL DEFAULT '-1',
isShortcut bigint(20) NOT NULL DEFAULT 0,
nr bigint(20),
oldCustomNr bigint(20) DEFAULT NULL,
importData text,
KEY rmljoin (attachment,fid),
UNIQUE KEY rmlorder (attachment,isShortcut)
) $charset_collate;";
dbDelta( $sql );
if ($errorlevel) {
$wpdb->print_error();
}
$table_name = $this->getTableName("meta");
$sql = "CREATE TABLE $table_name (
`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`realmedialibrary_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`meta_key` varchar(255) DEFAULT NULL,
`meta_value` longtext,
PRIMARY KEY (meta_id),
KEY realmedialibrary_id (realmedialibrary_id),
KEY meta_key (meta_key)
) $charset_collate;";
dbDelta( $sql );
if ($errorlevel) {
$wpdb->print_error();
}
$table_name = $this->getTableName("debug");
$sql = "CREATE TABLE $table_name (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`text` text,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) $charset_collate;";
dbDelta( $sql );
if ($errorlevel) {
$wpdb->print_error();
}
}else{
call_user_func($installThisCallable);
}
if ($errorlevel === false) {
$wpdb->show_errors($show_errors);
$wpdb->suppress_errors($suppress_errors);
error_reporting($errorLevel);
}
if ($installThisCallable === null) {
$installed = get_option(RML_OPT_PREFIX . '_db_version');
update_option(RML_OPT_PREFIX . '_db_version', RML_VERSION);
do_action("RML/Migration", $installed, RML_VERSION);
}
}
}