/****************************************************************************
 * Schema upgrade - DML script
 * 
 * This script copies any required data for tables that are being
 * recreated (where changes cannot be made in-place)
 * 
 * Run this after the first schema upgrade script, but before the second
 *
 * Database:         jcr
 * DBMS:             postgres7
 *****************************************************************************/

/*===========================================================================
 * DML to copy column values from SystemUser to tmp_SystemUser
 * 
 * NOTE: This may not be correct - you should check this VERY carefully
 *===========================================================================*/
INSERT INTO SystemUser (systemId, username, name, isSuperuser, password, email)
    SELECT systemId, username, name, isSuperuser, password, email
    FROM tmp_SystemUser;