VIEWS

[litvinchuk]

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; }