bootstrap.php

<?php

// Load the SQL Schema if the database is empty

$db_host = (getenv('DATABASE_HOST') ? getenv('DATABASE_HOST') : 'localhost');
$db_name = (getenv('DATABASE_NAME') ? getenv('DATABASE_NAME') : 'roundcube');
$db_user = (getenv('DATABASE_USER') ? getenv('DATABASE_USER') : 'roundcube');
$db_pass = (getenv('DATABASE_PASS') ? getenv('DATABASE_PASS') : '');

$dsn = "mysql:host=$db_host;dbname=$db_name";
$db = new PDO($dsn, $db_user, $db_pass);
$res = $db->query("SELECT count(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='$db_name'")->fetch(PDO::FETCH_NUM);

if ($res[0] == 0) {
    print "Loading schema...";
    $sql = file_get_contents('/var/www/html/SQL/mysql.initial.sql');
    $qr = $db->exec($sql);
    print "$qr";
} else {
    print "Database exists.";
}
?>