/**
* Expand session id column to varchar(256) to accommodate expanded size possible in PHP 7.1
* Force ascii character set to prevent key length issues.
*
* @return bool
*/
public function apply_sess_id()
{
$migrate = new Tables();
$migrate->useTable('session');
$migrate->alterColumn('session', 'sess_id', "varchar(256) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT ''");
return $migrate->executeQueue(true);
}
/**
* Execute synchronization to transform current schema to target
*
* @param bool $force true to force updates even if this is a 'GET' request
*
* @return bool true if no errors, false if errors encountered
*/
public function synchronizeSchema($force = true)
{
$this->tableHandler = new Tables();
// start fresh
$this->getSynchronizeDDL();
return $this->tableHandler->executeQueue($force);
}
/**
* @return bool
*/
public function apply_online_ip()
{
$migrate = new Tables();
$migrate->useTable('online');
$migrate->alterColumn('online', 'online_ip', "varchar(45) NOT NULL DEFAULT ''");
return $migrate->executeQueue(true);
}
