<?php

return array(

    /* CREATE TABLE */
    '
    CREATE TABLE IF NOT EXISTS users (
        `id` INT NOT NULL AUTO_INCREMENT,
        username VARCHAR(64) NULL,
        `password` VARCHAR(256) DEFAULT \'123456\',
        CONSTRAINT pk_id PRIMARY KEY (`id`)
    ) ENGINE=InnoDB
    ',

    /* DELETE */
    '
    DELETE LOW_PRIORITY
    FROM
        `test`.users
    WHERE
        `id`<3 AND (username="Dan" or username="Paul")',

    /* SELECT */
    '
    SELECT ALL MAX_STATEMENT_TIME = 10
        1 + 2 AS result,
        @idx,
        id,
        test.`users`.username AS `name`
    FROM
        `test`.users
        PARTITION (p1, p2)
    WHERE
        id > 0
    ORDER BY
        username DESC,
        id ASC
    LIMIT 3 OFFSET 2
    ',

    /* UPDATE */
    '
    UPDATE
        users
    SET
        username = "Dan"
    WHERE
        username = "Paul"
    LIMIT 1 OFFSET 2
    ',

    /* INSERT */
    '
    INSERT LOW_PRIORITY
    INTO
        users(`id`, `username`, `password`)
    VALUES
        (1, "Dan", "5d41402abc4b2a76b9719d911017c592"),
        (2, "Paul", "7d793037a0760186574b0282f2f435e7")
    '

);