示例#1
0
function descriptors($prefix = "")
{
    require_once "lib/all_tables.php";
    $array = get_all_tables();
    $out = array();
    while (list($key, $val) = each($array)) {
        $out[$prefix . $key] = $val;
    }
    return $out;
}
示例#2
0
/*
 ocPortal
 Copyright (c) ocProducts, 2004-2012
 See text/EN/licence.txt for full licencing information.
 NOTE TO PROGRAMMERS:
   Do not edit this file. If you need to make changes, save your changed file to the appropriate *_custom folder
   **** If you ignore this advice, then your website upgrades (e.g. for bug fixes) will likely kill your changes ****
*/
/*
Used to generate a database schema in the form of SQL code that can be imported into MySQL Workbench

First run this, then run SQLEditor on the files created in uploads/website_specific.
*/
require_code('relations');
$all_tables = get_all_tables();
$tables_by = get_tables_by_addon();
foreach ($tables_by as $t => $ts) {
    $path = get_custom_file_base() . '/uploads/website_specific/ocportal_erd__' . $t . '.sql';
    $myfile = fopen($path, 'wt');
    $tables = array();
    foreach ($ts as $table) {
        if (!array_key_exists($table, $all_tables)) {
            continue;
        }
        // Not installed
        $tables[$table] = $all_tables[$table];
    }
    fwrite($myfile, get_innodb_table_sql($tables, $all_tables));
    fclose($myfile);
    fix_permissions($path);