-- MySQL Script generated by MySQL Workbench
-- 03/02/15 04:39:05
-- Model: New Model    Version: 1.0
-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Table `constT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `constT` ;

CREATE TABLE IF NOT EXISTS `constT` (
  `id` VARCHAR(255) BINARY NOT NULL,
  `comment` VARCHAR(255) NOT NULL DEFAULT '',
  `valueString` VARCHAR(255) NULL,
  `valueInt` INT NULL,
  `valueFloat` DOUBLE NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB;


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

-- -----------------------------------------------------
-- Data for table `constT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `constT` (`id`, `comment`, `valueString`, `valueInt`, `valueFloat`) VALUES ('search.server.version', 'used in search - \"5.5\" forces to use 5.5 friendly code', '5.5', NULL, NULL);
INSERT INTO `constT` (`id`, `comment`, `valueString`, `valueInt`, `valueFloat`) VALUES ('search.limit.criteria.empty', DEFAULT, NULL, 10, NULL);
INSERT INTO `constT` (`id`, `comment`, `valueString`, `valueInt`, `valueFloat`) VALUES ('search.limit.criteria.notempty', DEFAULT, NULL, 500, NULL);

COMMIT;