create_function_doublequote.php

<?php

class CreateFunctionDoublequote extends Migration
{
    public function up()
    {
        $query = <<<EOD
        CREATE FUNCTION `DOUBLEQUOTE`(`val` TEXT) RETURNS TEXT CHARSET latin1 NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER RETURN CONCAT('"', REPLACE(val, '"', '\"'), '"')
        EOD;
        DB::unprepared($query);
    }

    public function down()
    {
        DB::unprepared('DROP FUNCTION IF EXISTS DOUBLEQUOTE');
    }
}