#!/usr/bin/perl

print "DROP DATABASE metastore;\nCREATE DATABASE metastore;\n";
my $create_table = 0;
my $alter_table = 0;
my $last = '';
while(<>) {
  $_ =~ s/CREATE DATABASE APP/CREATE DATABASE metastore/g;
  $_ =~ s/APP\./metastore./g;
  $_ =~ s/DESC VARCHAR/`DESC` VARCHAR/g;
  $_ =~ s/\sTYPE VARCHAR/ `TYPE` VARCHAR/g;
  $_ =~ s/ORDER INTEGER/`ORDER` INTEGER/g;
  $_ =~ s/CREATE UNIQUE INDEX metastore.(\S+) ON metastore.(\S+)/CREATE UNIQUE INDEX $1 ON $2/g;
  $_ =~ s/(.*CREATE DATABASE metastore.*)/$1\nuse metastore;/g;
  $_ =~ s/INSERT INTO metastore\.NUCLEUS_TABLES\(CLASS_NAME, TABLE_NAME, `TYPE`, OWNER, VERSION, INTERFACE_NAME\)/INSERT INTO metastore.NUCLEUS_TABLES(CLASS_NAME, TABLE_NAME, `TYPE`, OWNER, VERSION, INTERFACE_NAME)/g;
  $_ =~ s/INSERT INTO metastore\.DBS\(DB_ID, DESC, NAME, DB_LOCATION_URI\)/INSERT INTO metastore.DBS(DB_ID, `DESC`, NAME, DB_LOCATION_URI)/g;
  $create_table = 1 if($_ =~ m/^CREATE TABLE/);
  if($_ =~ m/^\);/ && $create_table == 1)
  {
    $_ =~ s/\);/) ENGINE=InnoDB DEFAULT CHARSET=latin1;/;
    $create_table = 0;
  }

  if($alter_table == 1) {
    $last .= $_;
    $alter_table = 0 if($_ =~ m/\);/);
  } elsif ($_ =~ m/^ALTER TABLE/) {
    $last .= $_;
    $alter_table = 1;
  } else {
    print $_;
  }
}

print $last;

