Subversion Repositories oidplus

Compare Revisions

Regard whitespace Rev 238 → Rev 239

/trunk/setup/struct_empty.sql.php
19,17 → 19,30
 
$prefix = isset($_REQUEST['prefix']) ? $_REQUEST['prefix'] : '';
$database = isset($_REQUEST['database']) ? $_REQUEST['database'] : '';
$slang = isset($_REQUEST['slang']) ? $_REQUEST['slang'] : 'mysql';
 
define('MYSQL_SYNTAX', false);
if (($slang != 'mysql') && ($slang != 'pgsql') && ($slang != 'mssql')) die('Unknown slang');
 
$cont = trim(file_get_contents(__DIR__.'/sql/struct.sql'))."\n\n".
trim(file_get_contents(__DIR__.'/sql/wellknown_country.sql'))."\n\n".
trim(file_get_contents(__DIR__.'/sql/wellknown_other.sql'))."\n\n";
$cont = trim(file_get_contents(__DIR__.'/sql/struct_'.$slang.'.sql'))."\n\n".
trim(file_get_contents(__DIR__.'/sql/wellknown_country_'.$slang.'.sql'))."\n\n".
trim(file_get_contents(__DIR__.'/sql/wellknown_other_'.$slang.'.sql'))."\n\n";
 
$table_names = array('objects', 'asn1id', 'iri', 'ra', 'config', 'log', 'log_user', 'log_object');
foreach ($table_names as $table) {
$cont = str_replace('`'.$table.'`', MYSQL_SYNTAX ? '`'.$prefix.$table.'`' : $prefix.$table, $cont);
if ($slang == 'mysql') {
$cont = str_replace('`'.$table.'`', '`'.$prefix.$table.'`', $cont);
}
if ($slang == 'pgsql') {
$cont = str_replace('"'.$table.'"', '"'.$prefix.$table.'"', $cont);
$cont = str_replace('"index_'.$table, '"index_'.$prefix.$table, $cont);
}
if ($slang == 'mssql') {
$cont = str_replace('['.$table.']', '['.$prefix.$table.']', $cont);
$cont = str_replace('dbo.'.$table, 'dbo.'.$prefix.$table, $cont);
$cont = str_replace('PK_'.$table, 'PK_'.$prefix.$table, $cont);
$cont = str_replace('DF__'.$table, 'DF__'.$prefix.$table, $cont);
}
}
 
if (php_sapi_name() != 'cli') {
header('Content-Type:text/sql');
37,12 → 50,17
}
 
if (!empty($database)) {
if (MYSQL_SYNTAX) {
if ($slang == 'mysql') {
echo "CREATE DATABASE IF NOT EXISTS `$database`;\n\n";
echo "USE `$database`;\n\n";
} else {
echo "CREATE DATABASE IF NOT EXISTS $database;\n\n";
echo "USE $database;\n\n";
}
if ($slang == 'pgsql') {
echo "-- CREATE DATABASE $database;\n\n";
echo "-- \connect $database;\n\n";
}
if ($slang == 'mssql') {
echo "USE [$database]\n\n";
echo "GO\n\n";
}
}
echo $cont;