/** * 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); }