| packagename/admin/schema_inc.php contain adodb syntax for creating the packages database, this doc describes the syntax.
|
| [http://phplens.com/lens/adodb/docs-datadict.htm|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^ |
| + |
| +{code src=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 ); |
| + } |
| +{/code} |