<?php
/* $Id$ */
namespace Mammut\DB\Sql\Dialect\Ddl;

(defined('MAMMUT') && (basename(__FILE__) != basename($_SERVER['PHP_SELF']))) or die('ACCESS DENIED');

use Mammut\DB\Table;
use Mammut\DB\View;
use Mammut\DB\Model\TableInfo;
use Mammut\DB\Model\ViewInfo;
use Mammut\DB\Sql\Dialect\iDialect;

/**
 * SQL DDL dialect helper class.
 *
 * This methods are needed to modify the structure itself and therefore
 * aren't needed very often. You can receive a DDL instace just by calling getDdl()
 * on a dialect object.
 *
 * @author Stefan Daurer <s.daurer@q-spot.org>
 * @package Mammut\DB\Dialect
 */
interface iDdlDialect extends iDialect {

	/**
	 * @param $param TableInfo
	 * @return string|array the SQL statement(s)
	 */
	public function getCreateTableSQL($param);

	/**
	 * 
	 * @param string|Table|TableInfo $oldName
	 * @param string|Table|TableInfo $newName
	 * @return string|array the SQL statement(s)
	 */
	public function getRenameTableSQL($oldName, $newName);

	/**
	 * 
	 * @return string|array the SQL statement(s)
	 */
	public function getAlterTableSQL($param);

	/**
	 * 
	 * @param string|Table|TableInfo $name
	 * @return string|array the SQL statement(s)
	 */
	public function getDropTableSQL($name);

	/**
	 * 
	 * @param $param ViewInfo
	 * @return string|array the SQL statement(s)
	 */
	public function getCreateViewSQL($param);

	/**
	 * 
	 * @param string|View|ViewInfo $name
	 * @return string|array the SQL statement(s)
	 */
	public function getDropViewSQL($name);

	/**
	 * 
	 * @return string|array the SQL statement(s)
	 */
	public function getDropColumnSQL($table, $column);
}