SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;


-- -----------------------------------------------------
-- Table `crash_on_drop_schema`.`table1`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `crash_on_drop_schema`.`table1` ;
CREATE SCHEMA IF NOT EXISTS `crash_on_drop_schema` DEFAULT CHARACTER SET utf8 ;
USE `crash_on_drop_schema` ;

CREATE  TABLE IF NOT EXISTS `crash_on_drop_schema`.`table1` (
  `id` INT(11) NOT NULL AUTO_INCREMENT ,
  `column1` VARCHAR(50) NOT NULL ,
  `column2` VARCHAR(50) NOT NULL ,
  `column3` VARCHAR(100) NOT NULL ,
  `column4` VARCHAR(255) NULL DEFAULT NULL ,
  `column5` ENUM('REGULAR','TEST') NULL DEFAULT 'REGULAR' ,
  PRIMARY KEY (`id`) )
ENGINE = MyISAM
AUTO_INCREMENT = 1125
DEFAULT CHARACTER SET = utf8;

CREATE UNIQUE INDEX `uc_mailingrelations` ON `crash_on_drop_schema`.`table1` (`column1` ASC, `column2` ASC, `column3` ASC) ;


-- -----------------------------------------------------
-- Table `crash_on_drop_schema`.`table2`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `crash_on_drop_schema`.`table2` ;

CREATE  TABLE IF NOT EXISTS `crash_on_drop_schema`.`table2` (
  `id` INT(11) NOT NULL AUTO_INCREMENT ,
  `column1` VARCHAR(50) NOT NULL ,
  `column2` VARCHAR(255) NOT NULL ,
  PRIMARY KEY (`id`) )
ENGINE = MyISAM
AUTO_INCREMENT = 13
DEFAULT CHARACTER SET = utf8;

CREATE UNIQUE INDEX `username_UNIQUE` ON `crash_on_drop_schema`.`table2` (`column1` ASC) ;


-- -----------------------------------------------------
-- Table `crash_on_drop_schema`.`table3`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `crash_on_drop_schema`.`table3` ;

CREATE  TABLE IF NOT EXISTS `crash_on_drop_schema`.`table3` (
  `id` INT(11) NOT NULL AUTO_INCREMENT ,
  `column1` VARCHAR(50) NOT NULL ,
  `column2` VARCHAR(50) NOT NULL ,
  `column3` VARCHAR(50) NOT NULL ,
  `column4` VARCHAR(50) NOT NULL ,
  `column5` DATE NOT NULL ,
  `column6` DATE NOT NULL ,
  `column7` VARCHAR(255) NULL DEFAULT NULL ,
  `column8` VARCHAR(255) NULL DEFAULT NULL ,
  `column9` VARCHAR(255) NULL DEFAULT NULL ,
  `column10` VARCHAR(255) NULL DEFAULT NULL ,
  `column11` VARCHAR(255) NULL DEFAULT NULL ,
  `column12` VARCHAR(255) NULL DEFAULT NULL ,
  `column13` VARCHAR(255) NULL DEFAULT NULL ,
  `column14` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
  `column15` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
  PRIMARY KEY (`id`) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `crash_on_drop_schema`.`table4`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `crash_on_drop_schema`.`table4` ;

CREATE  TABLE IF NOT EXISTS `crash_on_drop_schema`.`table4` (
  `id` INT(11) NOT NULL AUTO_INCREMENT ,
  `column1` INT(11) NOT NULL ,
  `column2` VARCHAR(50) NOT NULL ,
  `column3` VARCHAR(255) NOT NULL ,
  `column4` VARCHAR(255) NOT NULL ,
  `column5` VARCHAR(255) NOT NULL ,
  `column6` TINYINT(1) NULL DEFAULT '1' ,
  PRIMARY KEY (`id`) )
ENGINE = MyISAM
AUTO_INCREMENT = 41
DEFAULT CHARACTER SET = utf8;

CREATE UNIQUE INDEX `uc_pullmeasurementcredentials` ON `crash_on_drop_schema`.`table4` (`column1` ASC, `column2` ASC, `column3` ASC) ;


-- -----------------------------------------------------
-- Table `crash_on_drop_schema`.`table5`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `crash_on_drop_schema`.`table5` ;

CREATE  TABLE IF NOT EXISTS `crash_on_drop_schema`.`table5` (
  `id` INT(11) NOT NULL AUTO_INCREMENT ,
  `column1` INT(11) NOT NULL ,
  `column2` VARCHAR(50) NOT NULL ,
  `column3` VARCHAR(255) NOT NULL ,
  `column4` VARCHAR(255) NOT NULL ,
  `column5` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
  `column6` ENUM('EVERY_30_MINS','EVERY_6_HOURS','EVERY_22_HOURS') NOT NULL DEFAULT 'EVERY_30_MINS' ,
  `column7` TEXT NULL DEFAULT NULL ,
  PRIMARY KEY (`id`) )
ENGINE = MyISAM
AUTO_INCREMENT = 67
DEFAULT CHARACTER SET = utf8;

CREATE UNIQUE INDEX `uc_readstatus` ON `crash_on_drop_schema`.`table5` (`column1` ASC, `column2` ASC, `column4` ASC, `column6` ASC) ;


-- -----------------------------------------------------
-- Table `crash_on_drop_schema`.`table6`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `crash_on_drop_schema`.`table6` ;

CREATE  TABLE IF NOT EXISTS `crash_on_drop_schema`.`table6` (
  `id` INT(11) NOT NULL AUTO_INCREMENT ,
  `column1` TEXT NULL DEFAULT NULL ,
  `column2` TEXT NULL DEFAULT NULL ,
  `column3` ENUM('ACTIVE','CANCELLED_BY_USER','DONE','REQUEST_FAILED','SERVER_DIED','UNKNOWN') NOT NULL ,
  `column4` TEXT NULL DEFAULT NULL ,
  `column5` INT(11) NOT NULL DEFAULT '0' ,
  `column6` INT(11) NOT NULL DEFAULT '0' ,
  `column7` VARCHAR(255) NULL DEFAULT NULL ,
  `column8` VARCHAR(255) NOT NULL ,
  `column9` DATETIME NOT NULL ,
  `column10` DATETIME NOT NULL ,
  PRIMARY KEY (`id`) )
ENGINE = MyISAM
AUTO_INCREMENT = 3299
DEFAULT CHARACTER SET = utf8;



SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;