Schema tutorial - bitweaver

packagename/admin/schema_inc.php contain adodb syntax for creating the packages database, this doc describes the syntax.
adodbsyntax

If anyone is interested, there is experimental code in /install/migrate_database.php which will try and convert a connect database to AdoDB DataDict syntax - the same used in schema_inc.php.

Not sure if the people at AdoDB would find it useful - but anyone converting a database schema by hand will definitely find it valuable.

Stephan aka wolff_borg


<?php
    // iterate through source tables
    foreach($tables_src as $table) {
...
        $schema = $gDb_src->MetaColumns( $table, false, true );
        $t = "";
        $first = true;
        foreach(array_keys($schema) as $col) {
            $t .= (!$first) ? ",\n" : "";
            $x = $schema[$col];
            $t .= $x->name . " ";
            switch($x->type) {
                case "int":
                    $i = abs(( ( (int)$x->max_length ^ 2) - 1 ));
                    $i = ($i == 5) ? 4 : $i;
                    $i = ($i == 0) ? 1 : $i;
                    $t .= "I" . $i;
                    break;

                case "varchar":
                case "char":
                    $t .= "C(" . $x->max_length . ")";
                    break;

                case "datetime":
                    $t .= "T";
                    break;

                case "longblob":
                case "text":
                    $t .= "X";
                    break;

                default:
                    die($x->type);
            }
            $default = (!$x->binary) ? $x->has_default : false;
            $t .= " " . ( ($x->unsigned) ? "UNSIGNED" : "" ) . " "
                 . ( ($x->not_null) ? "NOTNULL" : "" ) . " "
                 . ( ($x->auto_increment) ? "AUTO" : "" ) . " "
                . ( ($x->primary_key) ? "PRIMARY" : "" ) . " "
                . ( ($default) ? "DEFAULT ". $x->default_value : "" );
            $table_schema[$table] = $t;
            $first = false;
        }
        $indices[$table] = $gDb_src->MetaIndexes( $table, false, false );
    }
?>