widenColumn

MySQL.php

<?php
	// MySQL::widenColumn

	// Original Function
	public function widenColumn($type, $column, $datatype) {
		$table = $type;
		$type = $datatype;
		$table = $this->esc($table);
		$column = $this->esc($column);
		$newtype = array_key_exists($type, $this->typeno_sqltype) ? $this->typeno_sqltype[$type] : '';
		$changecolumnSQL = "ALTER TABLE $table CHANGE $column $column $newtype ";
		$this->adapter->exec($changecolumnSQL);
	}

	// Make space
	public function widenColumn( $type, $column, $datatype )
	{
		$table = $type;
		$type  = $datatype;

		$table  = $this->esc($table);
		$column = $this->esc($column);

		$newtype = array_key_exists($type, $this->typeno_sqltype) ? $this->typeno_sqltype[$type] : '';

		$sql = "ALTER TABLE $table CHANGE $column $column $newtype ";
		
		$this->adapter->exec($sql);
	}

	// Reduce variable confusion
	public function widenColumn( $table, $column, $datatype )
	{
		$table  = $this->esc($table);
		$column = $this->esc($column);

		$newtype = array_key_exists($datatype, $this->typeno_sqltype) ? $this->typeno_sqltype[$datatype] : '';

		$sql = "ALTER TABLE $table CHANGE $column $column $newtype ";

		$this->adapter->exec($sql);
	}

	// 80 Char limit
	public function widenColumn( $table, $column, $datatype )
	{
		$table  = $this->esc($table);
		$column = $this->esc($column);

		$newtype = '';
		if ( !array_key_exists($datatype, $this->typeno_sqltype) ) {
			$newtype = $this->typeno_sqltype[$datatype];
		}

		$sql = "ALTER TABLE"
				. $table
				. "CHANGE"
				. ' '.$column
				. ' '.$column
				. ' '.$newtype
				.' ';

		$this->adapter->exec($sql);
	}

	// Further collapse variables
	public function widenColumn( $table, $column, $datatype )
	{
		$table  = $this->esc($table);
		$column = $this->esc($column);

		$newtype = '';
		if ( !array_key_exists($datatype, $this->typeno_sqltype) ) {
			$newtype = $this->typeno_sqltype[$datatype];
		}

		$sql = "ALTER TABLE"
			. $table
			. "CHANGE"
			. ' '.$column
			. ' '.$column
			. ' '.$newtype
			.' ';

		$this->adapter->exec($sql);
	}

	// You know what? If there's no type, there's no change!
	public function widenColumn( $table, $column, $datatype )
	{
		if ( !array_key_exists($datatype, $this->typeno_sqltype) ) {
			return;
		}

		$table  = $this->esc($table);
		$column = $this->esc($column);

		$sql = "ALTER TABLE"
			. $table
			. "CHANGE"
			. ' '.$column
			. ' '.$column
			. ' '.$this->typeno_sqltype[$datatype]
			.' ';

		$this->adapter->exec($sql);
	}

	// Collapse last variable
	public function widenColumn( $table, $column, $datatype )
	{
		if ( !array_key_exists($datatype, $this->typeno_sqltype) ) return;

		$table  = $this->esc($table);
		$column = $this->esc($column);

		$this->adapter->exec(
			"ALTER TABLE $table CHANGE $column"
			. " $column " . $this->typeno_sqltype[$datatype]
		);
	}

	// Actually, isset is shorter and more accurate (returns false on a null value)
	public function widenColumn( $table, $column, $datatype )
	{
		if ( !isset($this->typeno_sqltype[$datatype]) ) return;

		$table  = $this->esc($table);
		$column = $this->esc($column);

		$this->adapter->exec(
			"ALTER TABLE $table CHANGE $column"
			. " $column " . $this->typeno_sqltype[$datatype]
		);
	}