Problems with removing a view.
Query "DROP TABLE IF EXISTS view_members" doesn't work with views, "DROP VIEW" needed.
And param "DEFINER=book@localhost" is not needed.
class Migration1355231072 extends AbstractMigration
{
protected $up = array(
'DROP TABLE IF EXISTS view_members',
);
protected $down = array(
'DROP TABLE IF EXISTS view_members',
'CREATE ALGORITHM=UNDEFINED DEFINER=book@localhost SQL SECURITY DEFINER VIEW view_members AS select members.id AS id,concat_ws(' ',members.surname,members.name,members.secondname,concat('(',members.login,')')) AS name,members.is_active AS is_active,members.is_deleted AS is_deleted from members',
);
protected $rev = 1355231072;
}
Problems with removing a view.
Query "DROP TABLE IF EXISTS
view_members" doesn't work with views, "DROP VIEW" needed.And param "DEFINER=
book@localhost" is not needed.class Migration1355231072 extends AbstractMigration
{
protected $up = array(
'DROP TABLE IF EXISTS
view_members',);
protected $down = array(
'DROP TABLE IF EXISTS
view_members','CREATE ALGORITHM=UNDEFINED DEFINER=
book@localhostSQL SECURITY DEFINER VIEWview_membersAS selectmembers.idASid,concat_ws(' ',members.surname,members.name,members.secondname,concat('(',members.login,')')) ASname,members.is_activeASis_active,members.is_deletedASis_deletedfrommembers',);
protected $rev = 1355231072;
}