/** * @param AlterTable $table * @param mixed $data * * @return string */ protected function handleRenameColumn(AlterTable $table, $data) { return 'sp_rename ' . $this->wrap($table->getTableName()) . '.' . $this->wrap($data['from']) . ', ' . $this->wrap($data['column']->getName()) . ', COLUMN'; }
/** * @param AlterTable $column * @param mixed $data * * @return string */ protected function handleRenameColumn(AlterTable $table, $data) { $table_name = $table->getTableName(); $column_name = $data['from']; $new_name = $data['column']->getName(); $columns = $this->connection->schema()->getColumns($table_name, false, false); $column_type = isset($columns[$column_name]) ? $columns[$column_name]['type'] : 'integer'; return 'ALTER TABLE ' . $this->wrap($table_name) . ' CHANGE ' . $this->wrap($column_name) . ' ' . $this->wrap($new_name) . ' ' . $column_type; }
/** * @param AlterTable $table * @param mixed $data * * @return string */ protected function handleDropDefaultValue(AlterTable $table, $data) { return 'ALTER TABLE ' . $this->wrap($table->getTableName()) . ' ALTER COLUMN ' . $this->wrap($data) . ' DROP DEFAULT'; }
/** * @param AlterTable $table * @param mixed $data * * @return string */ protected function handleDropIndex(AlterTable $table, $data) { return 'DROP INDEX ' . $this->wrap($table->getTableName() . '_' . $data); }
/** * @param AlterTable $table * @param mixed $data * * @return string */ protected function handleDropDefaultValue(AlterTable $table, $data) { return 'ALTER TABLE ' . $this->wrap($table->getTableName()) . ' MODIFY ' . $this->wrap($data) . ' DEFAULT NULL'; }