Dynamic Creation MySQL Database (Not Table)

[MLT]

Is there a way using miva to create a mysql database? We have no issue creating tables dynamically but I'm stumped on creating the actual database.

Thanks,
-mike

[Kent Multer]

Have you tried MvQUERY?

[wmgilligan]

There is!

<MvQuery name="newTables" QUERY="{ 'CREATE TABLE `history` ( `firstName` VARCHAR(200) NOT NULL, `lastName` VARCHAR(250) NOT NULL, `company` VARCHAR(100) NOT NULL, ``Cost` DECIMAL(7,2) NOT NULL, acct` INT(11) PRIMARY KEY NOT NULL AUTO_INCREMENT ) ENGINE = InnoDB;' }">

And to alter one...
<MvQuery name="newTables" QUERY="{ 'ALTER TABLE `history` ADD INDEX (`lastName`), ADD INDEX (`company`), ADD FULLTEXT `lastComp` (`lastName`, `company`);' }">

[ILoveHostasaurus]

It would be very unusual for database creation to be possible via an application, since the credentials used for the database connection would never have that grant. You can of course issue a database create query if you've got an application with a user that has that grant.