Create multiple tables using one query
<p>I have a function building DB and creating tables if they don't exist, but it only works with one table. I have tried using "/", space and also ";" to separate the create table scripts, but none of them worked. Can you help me?
Here is my function:</p>

<pre><code>private function buildDB() {

        $sql = &lt;&lt;&lt;MySQL_QUERY
            CREATE TABLE IF NOT EXISTS projects(
                id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
                title VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_czech_ci,
                slug VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_czech_ci,
                text LONGTEXT CHARACTER SET utf8 COLLATE utf8_czech_ci,
                gallery LONGTEXT CHARACTER SET utf8 COLLATE utf8_czech_ci,
                date timestamp NOT NULL DEFAULT current_timestamp
            );
            CREATE TABLE IF NOT EXISTS admins(
                id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
                name VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT 'admin',
                password VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT '21232f297a57a5a743894a0e4a801fc3'
            )
MySQL_QUERY;

        return mysql_query($sql);

    }
</code></pre>