<?php
//its in a class because I already had the code that way and I din't feel like extracting it.
$migration = new Migrate();
$migration->printQueries();
class Migrate
{
public function printQueries()
{
$this->printAddProcedures();
$queries = array();
$queries = array_merge($queries, $this->getDropTriggers());
$queries = array_merge($queries, $this->getDropForeignKeys());
$queries = array_merge($queries, $this->getDropIndexes());
$queries = array_merge($queries, $this->getDropKeys());
$queries = array_merge($queries, $this->getDropPrimaryKeys());
$queries = array_merge($queries, $this->getChangeEngine());
$queries = array_merge($queries, $this->getChangeCharset());
$queries = array_merge($queries, $this->getAddColumns());
$queries = array_merge($queries, $this->getColumnChanges());
$queries = array_merge($queries, $this->getDropTables());
$queries = array_merge($queries, $this->getDropColumns());
$queries = array_merge($queries, $this->getAddPrimaryKeys());
$queries = array_merge($queries, $this->getAddIndexes());
$queries = array_merge($queries, $this->getAddForeignKeys());
foreach ($queries as $sql) {
print $sql . ";\n";
}
$this->printDropProcedures();
}
protected function printAddProcedures()
