Todo List
This file implements upgrading of DB tables
Quam Plures - http://quamplures.net/ Released under GNU GPL License - http://quamplures.net/license.html
(c)2003-2009 by Francois PLANQUE - http://fplanque.net/
void convert_lang_to_locale( string $table, string $columnlang, string $columnID )
Converts languages in a given table into according locales
boolean db_add_col( $table, $col_name, $col_desc )
Add a column, if it does not already exist.
If it exists already, a "ALTER TABLE" statement will get executed instead.
void db_add_index( $table, $name, $def )
Add an INDEX. If another index with the same name already exists, it will get dropped before.
boolean db_cols_exist( string $table, array $col_names )
void db_drop_col( $table, $col_name )
Drops a column, if it exists.
boolean db_index_exists( $table, $index_name )
void set_upgrade_checkpoint( string $version )
Create a DB version checkpoint
This increments table.db_upgrade during an upgrade cycle. It starts matching table.db_version and end matching $app_db_version. If the upgrader crashes this value lets us pick up exactly where we left off :)
void upgrade_dbase_tables( )
Upgrade database tables
This is a process. Life is a process. Therefore this is life.