public function __construct($file)
{
parent::__construct($file);
$this->set_name('orbis_products');
$this->set_db_version('1.0.0');
$this->plugin_include('includes/post.php');
$this->plugin_include('includes/product-template.php');
$this->plugin_include('includes/template.php');
}
public function __construct($file)
{
parent::__construct($file);
$this->set_name('orbis_twitter');
$this->set_db_version('1.0.0');
// Admin
if (is_admin()) {
$this->admin = new Orbis_Twitter_Admin($this);
}
}
public function install()
{
orbis_install_table('orbis_subscriptions', '
id BIGINT(16) UNSIGNED NOT NULL AUTO_INCREMENT,
company_id BIGINT(16) UNSIGNED DEFAULT NULL,
type_id BIGINT(16) UNSIGNED DEFAULT NULL,
domain_name_id BIGINT(32) UNSIGNED DEFAULT NULL,
post_id BIGINT(20) UNSIGNED DEFAULT NULL,
name VARCHAR(128) NOT NULL,
activation_date DATETIME NOT NULL,
expiration_date DATETIME NOT NULL,
cancel_date DATETIME DEFAULT NULL,
update_date DATETIME DEFAULT NULL,
license_key VARCHAR(32) DEFAULT NULL,
license_key_md5 VARCHAR(32) DEFAULT NULL,
email VARCHAR(64) DEFAULT NULL,
sent_notifications TINYINT(2) DEFAULT 0,
PRIMARY KEY (id),
UNIQUE KEY license_key (license_key),
UNIQUE KEY license_key_md5 (license_key_md5),
UNIQUE KEY post_id (post_id),
KEY company_id (company_id),
KEY type_id (type_id),
KEY domain_name_id (domain_name_id)
');
orbis_install_table('orbis_subscription_products', '
id BIGINT(16) UNSIGNED NOT NULL AUTO_INCREMENT,
post_id BIGINT(20) UNSIGNED DEFAULT NULL,
name VARCHAR(64) NOT NULL,
price FLOAT NOT NULL,
cost_price FLOAT NULL,
notes TEXT NULL,
legacy_id BIGINT(16) UNSIGNED NULL,
`type_default` BOOLEAN NOT NULL DEFAULT FALSE,
twinfield_article VARCHAR(8) NOT NULL,
auto_renew BOOLEAN NOT NULL DEFAULT TRUE,
deprecated BOOLEAN NOT NULL DEFAULT FALSE,
`interval` VARCHAR(1) NOT NULL DEFAULT "Y",
PRIMARY KEY (id)
');
orbis_install_table('orbis_subscriptions_invoices', '
id BIGINT(16) UNSIGNED NOT NULL AUTO_INCREMENT,
subscription_id BIGINT(16) UNSIGNED NOT NULL,
invoice_number VARCHAR(8) NOT NULL,
start_date DATETIME DEFAULT NULL,
end_date DATETIME DEFAULT NULL,
user_id BIGINT(20) UNSIGNED DEFAULT NULL,
create_date DATETIME DEFAULT NULL,
PRIMARY KEY (id)
');
parent::install();
}
public function __construct($file)
{
parent::__construct($file);
$this->set_name('orbis_snom');
$this->set_db_version('1.0.0');
// Actions
add_action('wp_enqueue_scripts', array($this, 'enqueue_scripts'));
add_action('wp_footer', array($this, 'footer'));
// Admin
if (is_admin()) {
$this->admin = new Orbis_Snom_Admin($this);
}
}
public function install()
{
// Tables
orbis_install_table('orbis_activities', '
id BIGINT(16) UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(128) NOT NULL,
description TEXT NOT NULL,
term_id BIGINT(20) UNSIGNED DEFAULT NULL,
PRIMARY KEY (id)
');
orbis_install_table('orbis_timesheets', "\n\t\t\tid BIGINT(16) UNSIGNED NOT NULL AUTO_INCREMENT,\n\t\t\tcreated TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,\n\t\t\tuser_id BIGINT(20) UNSIGNED DEFAULT NULL,\n\t\t\tcompany_id BIGINT(16) UNSIGNED DEFAULT NULL,\n\t\t\tproject_id BIGINT(16) UNSIGNED DEFAULT NULL,\n\t\t\tsubscription_id BIGINT(16) UNSIGNED DEFAULT NULL,\n\t\t\tactivity_id BIGINT(16) UNSIGNED DEFAULT NULL,\n\t\t\tdescription TEXT NOT NULL,\n\t\t\t`date` DATE NOT NULL DEFAULT '0000-00-00',\n\t\t\tnumber_seconds INT(16) UNSIGNED NOT NULL DEFAULT 0,\n\t\t\tPRIMARY KEY (id),\n\t\t\tKEY user_id (user_id),\n\t\t\tKEY company_id (company_id),\n\t\t\tKEY project_id (project_id),\n\t\t\tKEY subscription_id (subscription_id),\n\t\t\tKEY activity_id (activity_id)\n\t\t");
parent::install();
}
public function install()
{
// Tables
orbis_install_table('orbis_tasks', '
id BIGINT(16) UNSIGNED NOT NULL AUTO_INCREMENT,
post_id BIGINT(20) UNSIGNED DEFAULT NULL,
project_id BIGINT(16) UNSIGNED DEFAULT NULL,
assignee_id BIGINT(20) UNSIGNED DEFAULT NULL,
task TEXT,
due_at DATETIME DEFAULT NULL,
completed BOOLEAN NOT NULL DEFAULT FALSE,
PRIMARY KEY (id)
');
parent::install();
}
public function install()
{
orbis_keychain_setup_roles();
parent::install();
}
public function install()
{
parent::install();
}
public function __construct($file)
{
parent::__construct($file);
$this->plugin_include('includes/post.php');
}
