#
# $Id: createDB.sql 2383 2006-10-03 16:39:06Z huter $
#
# Create the test databases for MySQL in order to run
# Unit tests for mysql.
#

DROP DATABASE IF EXISTS jdbc2xml_db1;
DROP DATABASE IF EXISTS jdbc2xml_db2;
DROP DATABASE IF EXISTS jdbc2xml_db3;
DROP DATABASE IF EXISTS jdbc2xml_db4;
DROP DATABASE IF EXISTS jdbc2xml_db5;
DROP DATABASE IF EXISTS jdbc2xml_db6;

CREATE DATABASE jdbc2xml_db1;
CREATE DATABASE jdbc2xml_db2;
CREATE DATABASE jdbc2xml_db3;
CREATE DATABASE jdbc2xml_db4;
CREATE DATABASE jdbc2xml_db5;
CREATE DATABASE jdbc2xml_db6;

GRANT ALL PRIVILEGES
  ON jdbc2xml_db1.*
  TO jdbc2xml@'localhost'
  IDENTIFIED BY 'lmx2cbdj!';

GRANT ALL PRIVILEGES
  ON jdbc2xml_db1.*
  TO jdbc2xml@'%'
  IDENTIFIED BY 'lmx2cbdj!';

GRANT ALL PRIVILEGES
  ON jdbc2xml_db2.*
  TO jdbc2xml@'localhost'
  IDENTIFIED BY 'lmx2cbdj!';

GRANT ALL PRIVILEGES
  ON jdbc2xml_db2.*
  TO jdbc2xml@'%'
  IDENTIFIED BY 'lmx2cbdj!';

GRANT ALL PRIVILEGES
  ON jdbc2xml_db3.*
  TO jdbc2xml@'localhost'
  IDENTIFIED BY 'lmx2cbdj!';

GRANT ALL PRIVILEGES
  ON jdbc2xml_db3.*
  TO jdbc2xml@'%'
  IDENTIFIED BY 'lmx2cbdj!';

GRANT ALL PRIVILEGES
  ON jdbc2xml_db4.*
  TO jdbc2xml@'localhost'
  IDENTIFIED BY 'lmx2cbdj!';

GRANT ALL PRIVILEGES
  ON jdbc2xml_db4.*
  TO jdbc2xml@'%'
  IDENTIFIED BY 'lmx2cbdj!';

GRANT ALL PRIVILEGES
  ON jdbc2xml_db5.*
  TO jdbc2xml@'localhost'
  IDENTIFIED BY 'lmx2cbdj!';

GRANT ALL PRIVILEGES
  ON jdbc2xml_db5.*
  TO jdbc2xml@'%'
  IDENTIFIED BY 'lmx2cbdj!';

GRANT ALL PRIVILEGES
  ON jdbc2xml_db6.*
  TO jdbc2xml@'localhost'
  IDENTIFIED BY 'lmx2cbdj!';

GRANT ALL PRIVILEGES
  ON jdbc2xml_db6.*
  TO jdbc2xml@'%'
  IDENTIFIED BY 'lmx2cbdj!';

FLUSH PRIVILEGES;

COMMIT;
