public function __construct()
{
$table = new DBTable();
$table->column('key')->string(255)->index()->primary();
$table->column('value')->longtext();
parent::__construct($table);
}
public function __construct()
{
$table = new DBTable();
$table->column('id')->integer()->primary()->increment();
$table->column('name')->string(255);
parent::__construct();
}
public function __construct()
{
$table = new DBTable('source_cloudflare');
$table->column('id')->bigint()->primary()->increment();
$table->column('source_id')->integer()->index();
$table->column('cloudflare_identifier')->string(36)->index();
parent::__construct($table);
}
public function __construct()
{
// Defines the table we are using
$table = new DBTable();
$table->column('id')->integer()->primary()->increment();
$table->column('name')->string(255);
$table->column('date')->datetime()->index();
parent::__construct($table);
// If we want any default values that is not required for the users to set we add them here.
// We can always overwrite them later by doing $company->date = [NEW-VALUE]
$this->date = \Pecee\Date::ToDateTime();
$this->metadata = new ModelCompanyData();
}
public function __construct()
{
$table = new DBTable();
$table->column('id')->bigint()->primary()->increment();
$table->column('organisation_id')->bigint()->index();
$table->column('amount')->float()->index();
$table->column('currency')->string(40)->nullable();
$table->column('transaction_id')->string()->nullable()->index();
$table->column('period_start')->date()->index();
$table->column('period_end')->date()->index();
$table->column('payment_date')->datetime()->index();
parent::__construct($table);
$this->amount = 0;
$this->payment_date = Date::toDateTime();
}
public function __construct()
{
$table = new DBTable();
$table->column('name')->string(255)->primary();
$table->column('path')->string(40)->index();
$table->column('host')->string(50)->index();
$table->column('capacity_free_gb')->integer();
$table->column('capacity_max_gb')->integer();
$table->column('capacity_limit')->integer();
$table->column('active')->bool()->index();
parent::__construct($table);
$this->active = true;
}
public function __construct()
{
$table = new DBTable();
$table->column('id')->bigint()->primary()->increment();
$table->column('user_id')->bigint()->index();
$table->column('email')->string(255)->index();
$table->column('organisation_id')->bigint()->index();
$table->column('role')->string(255);
$table->column('created')->datetime()->index();
parent::__construct($table);
$this->created = Date::toDateTime();
}
public function __construct()
{
$table = new DBTable();
$table->column('id')->integer()->primary()->increment();
$table->column('source_id')->bigint()->index();
$table->column('key')->string()->index();
$table->column('value')->text()->nullable();
parent::__construct($table);
}
public function __construct()
{
$table = new DBTable();
$table->column('id')->integer()->primary()->increment();
$table->column('user_id')->bigint()->index();
$table->column('organisation_id')->bigint()->index();
$table->column('role')->string(255)->index();
parent::__construct($table);
}
public function __construct()
{
$table = new DBTable();
$table->column('id')->bigint()->primary()->increment();
$table->column('user_id')->bigint()->index();
$table->column('organisation_id')->bigint()->index();
$table->column('invoice_id')->integer()->index();
$table->column('path')->string(300);
$table->column('due_date')->date()->index();
$table->column('amount_total')->integer()->index();
$table->column('payed')->bool()->index();
$table->column('created')->datetime()->index();
parent::__construct($table);
if (ModelUser::current()->isLoggedIn()) {
$this->user_id = ModelUser::current()->id;
}
$this->created = Date::toDateTime();
}
public function __construct()
{
$table = new DBTable();
$table->column('id')->bigint()->primary()->increment();
$table->column('name')->string(255)->index();
$table->column('api_token')->string(40)->index();
$table->column('stripe_identifier_id')->string(40)->nullable();
$table->column('discount_percentage')->float()->nullable();
$table->column('free_amount')->float()->nullable();
$table->column('fixed_plan_amount')->float()->nullable();
$table->column('included_master_images')->integer()->nullable();
$table->column('included_bandwidth_mb')->integer()->nullable();
$table->column('disabled')->bool()->index();
$table->column('deleted')->bool()->index();
parent::__construct($table);
$this->api_token = Guid::create();
$this->free_amount = 10;
$this->disabled = false;
$this->deleted = false;
}
public function __construct()
{
$table = new DBTable();
$table->column('id')->bigint()->increment()->primary();
$table->column('source_id')->bigint()->index();
$table->column('cdn')->string(255)->index();
$table->column('name')->string(300)->index();
$table->column('original_name')->string(300)->index();
$table->column('path')->string(500)->index();
$table->column('mime')->string(255)->index();
$table->column('size')->integer()->index();
$table->column('identifier')->string(32)->index();
$table->column('last_activity')->datetime()->nullable()->index();
$table->column('created')->datetime()->index();
parent::__construct($table);
$this->created = Date::toDateTime();
}
public function __construct()
{
$table = new DBTable('source');
$table->column('id')->bigint()->primary()->increment();
$table->column('organisation_id')->integer()->index();
$table->column('name')->string(255);
$table->column('type')->string(255)->index();
$table->column('subdomain')->string(255)->index();
$table->column('require_ssl')->bool();
$table->column('error_image_url')->string(400);
$table->column('error_image_parameters')->text();
$table->column('missing_image_url')->string(400);
$table->column('missing_image_parameters')->text();
$table->column('default_parameters')->text();
$table->column('last_activity')->datetime()->index();
parent::__construct($table);
$this->cloudflareIds = array();
$this->last_activity = Date::toDateTime();
}
public function __construct()
{
$table = new DBTable('activity');
$table->column('id')->bigint()->increment()->primary();
$table->column('source_id')->bigint()->index();
$table->column('thumbnail_id')->bigint()->nullable()->index();
$table->column('path')->string(400);
$table->column('method')->string(30);
$table->column('agent')->string()->nullable();
$table->column('referer')->string()->nullable();
$table->column('ip')->string()->index();
/**
* NOTE: identifier is the file's unique id - based on the "path" column.
* It is used as a faster way to determinate if a path has been accessed multiple times,
* when calculating statistics - and might speed up things when inserting instead of
* creating an index to the path column.
**/
$table->column('identifier')->string(36)->index();
$table->column('filesize')->integer()->nullable()->index();
$table->column('master')->bool()->index();
$table->column('created')->datetime()->index();
parent::__construct($table);
$this->created = Date::toDateTime();
}
