-- ---------------------------------------------------------------------- -- MySQL Migration Toolkit -- SQL Create Script -- ---------------------------------------------------------------------- SET FOREIGN_KEY_CHECKS = 0; CREATE DATABASE IF NOT EXISTS `jasperdata` CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `jasperdata`; -- ------------------------------------- -- Tables DROP TABLE IF EXISTS `jasperdata`.`jaspertable`; CREATE TABLE `jasperdata`.`jaspertable` ( `Id` INT(10) unsigned NOT NULL AUTO_INCREMENT, `Name` VARCHAR(45) NOT NULL, `Data` INT(10) unsigned NOT NULL, PRIMARY KEY (`Id`) ) ENGINE = INNODB; SET FOREIGN_KEY_CHECKS = 1; -- ---------------------------------------------------------------------- -- EOF