-- $Id: ulog_copy,v 1.1 2005/04/19 21:58:25 bhockney Exp $
--
-- Move ulog data from old database to new database
--
BEGIN;
  CREATE TABLE $ULOG_DB.$ULOG_TABLE AS SELECT * FROM $ULOG_OLD_DB.$ULOG_OLD_TABLE;
  ALTER TABLE $ULOG_DB.$ULOG_TABLE ADD UNIQUE INDEX id (id);
  ALTER TABLE $ULOG_DB.$ULOG_TABLE CHANGE COLUMN id id int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  GRANT INSERT ON $ULOG_DB.$ULOG_TABLE TO $USER;
COMMIT;