19,18 → 19,31 |
|
$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". |
trim(file_get_contents(__DIR__.'/sql/example.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". |
trim(file_get_contents(__DIR__.'/sql/example_'.$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'); |
38,12 → 51,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; |