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

CREATE DATABASE IF NOT EXISTS `@(VDADB)` ;
USE `@(VDADB)`;

-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_userdirectory`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_userdirectory` (
  `id` BIGINT NOT NULL ,
  `directory_info` TEXT NOT NULL ,
  `dns_url` TEXT NULL ,
  `login_name` CHAR(255) NULL ,
  `login_password` CHAR(255) NULL ,
  `type` CHAR(20) NULL ,
  `version` BIGINT NOT NULL ,
  PRIMARY KEY (`id`) )
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_userdirectory_host`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_userdirectory_host` (
  `id` BIGINT NOT NULL ,
  `ud_id` BIGINT NULL ,
  `ip_or_dns` CHAR(255) NULL ,
  `port` INT NULL ,
  `certificate` BLOB NULL ,
  `sort` SMALLINT NULL ,
  `version` BIGINT NOT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX fk_t_userdirectory_host_t_userdirectory (`ud_id` ASC) ,
  CONSTRAINT `fk_t_userdirectory_host_t_userdirectory`
    FOREIGN KEY (`ud_id` )
    REFERENCES `@(VDADB)`.`t_userdirectory` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_desktopprovider`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_desktopprovider` (
  `id` BIGINT NOT NULL ,
  `name` CHAR(255) BINARY NOT NULL ,
  `type` CHAR(30) NOT NULL ,
  `description` CHAR(255) NULL ,
  `version` BIGINT NOT NULL ,
  PRIMARY KEY (`id`),
  UNIQUE INDEX unique_name (`name` ASC) )
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_amghgroup`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_amghgroup` (
  `id` BIGINT NOT NULL ,
  `name` CHAR(255) NULL ,
  `description` CHAR(255) NULL ,
  `version` BIGINT NOT NULL ,
  PRIMARY KEY (`id`) )
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_poolclient`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_poolclient` (
  `id` BIGINT NOT NULL ,
  `distinguished_name` CHAR(255) NOT NULL ,
  `ud_id` BIGINT NULL ,
  `amgh_group_id` BIGINT NULL ,
  `user_id` BIGINT NULL ,
  `preferred_desktop_id` BIGINT NULL ,
  `type` CHAR(30) NOT NULL ,
  `description` CHAR(255) NULL ,
  `filter_string` TEXT NULL ,
  `filter_string_type` CHAR(45) NULL ,
  `version` BIGINT NOT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX fk_poolclient_poolclient (`user_id` ASC) ,
  INDEX fk_poolclient_amghgroup (`amgh_group_id` ASC) ,
  INDEX fk_poolclient_userdirectory (`ud_id` ASC) ,
  UNIQUE INDEX distinguished_name (`distinguished_name` ASC) ,
  INDEX fk_t_poolclient_t_desktop (`preferred_desktop_id` ASC) ,
  INDEX type_index (`type` ASC) ,
  INDEX version_index (`version` ASC) ,
  CONSTRAINT `fk_poolclient_poolclient`
    FOREIGN KEY (`user_id` )
    REFERENCES `@(VDADB)`.`t_poolclient` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_poolclient_amghgroup`
    FOREIGN KEY (`amgh_group_id` )
    REFERENCES `@(VDADB)`.`t_amghgroup` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_poolclient_userdirectory`
    FOREIGN KEY (`ud_id` )
    REFERENCES `@(VDADB)`.`t_userdirectory` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_t_poolclient_t_desktop`
    FOREIGN KEY (`preferred_desktop_id` )
    REFERENCES `@(VDADB)`.`t_desktop` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_host`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_host` (
  `id` BIGINT NOT NULL ,
  `ip_or_dns` CHAR(255) NOT NULL ,
  `port` INT NULL ,
  `login_name` CHAR(50) NULL ,
  `login_password` CHAR(255) NULL ,
  `certificate` BLOB NULL ,
  `description` CHAR(255) NULL ,
  `optionals` TEXT NULL ,
  `type` CHAR(30) NOT NULL ,
  `version` BIGINT NOT NULL ,
  PRIMARY KEY (`id`) )
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_storage`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_storage` (
  `id` BIGINT NOT NULL ,
  `ip_or_dns` CHAR(255) NOT NULL ,
  `port` INT NULL ,
  `login_name` CHAR(50) NULL ,
  `login_password` CHAR(255) NULL ,
  `zfs_pool_name` CHAR(255) NULL ,
  `certificate` BLOB NULL ,
  `description` CHAR(255) NULL ,
  `type` CHAR(45) NULL ,
  `optionals` TEXT NULL ,
  `version` BIGINT NOT NULL ,
  PRIMARY KEY (`id`) )
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_desktop`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_desktop` (
  `id` BIGINT NOT NULL ,
  `name` CHAR(255) NULL ,
  `guest_name` CHAR(255) NULL ,
  `ip_or_dns` CHAR(255) NULL ,
  `port` INT NULL ,
  `type` CHAR(30) NOT NULL ,
  `external_id` CHAR(255) NOT NULL ,
  `pool_id` BIGINT NULL ,
  `pool_client_id` BIGINT NULL ,
  `assignment_type` CHAR(30) NULL ,
  `state` CHAR(30) NOT NULL ,
  `logoff_time` DATETIME NULL ,
  `suspend_time` DATETIME NULL ,
  `desktop_provider_id` BIGINT NULL ,
  `enabled` INT NULL DEFAULT 1 ,
  `description` CHAR(255) NULL ,
  `template_id` BIGINT NULL ,
  `operating_system` CHAR(255) NULL ,
  `optionals` TEXT NULL ,
  `host_id` BIGINT NULL ,
  `storage_id` BIGINT NULL ,
  `creation_date` DATETIME NULL ,
  `version` BIGINT NOT NULL ,
  `is_template` BOOL NULL ,
  PRIMARY KEY (`id`) ,
  INDEX fk_desktop_pool (`pool_id` ASC) ,
  INDEX fk_desktop_poolclient (`pool_client_id` ASC) ,
  INDEX fk_desktop_desktopprovider (`desktop_provider_id` ASC) ,
  UNIQUE INDEX external_provider_id (`external_id` ASC, `desktop_provider_id` ASC) ,
  INDEX fk_desktop_host (`host_id` ASC) ,
  INDEX fk_desktop_storage (`storage_id` ASC) ,
  INDEX fk_desktop_template (`template_id` ASC) ,
  INDEX type_index (`type` ASC) ,
  CONSTRAINT `fk_desktop_pool`
    FOREIGN KEY (`pool_id` )
    REFERENCES `@(VDADB)`.`t_pool` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_desktop_poolclient`
    FOREIGN KEY (`pool_client_id` )
    REFERENCES `@(VDADB)`.`t_poolclient` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_desktop_desktopprovider`
    FOREIGN KEY (`desktop_provider_id` )
    REFERENCES `@(VDADB)`.`t_desktopprovider` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_desktop_host`
    FOREIGN KEY (`host_id` )
    REFERENCES `@(VDADB)`.`t_host` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_desktop_storage`
    FOREIGN KEY (`storage_id` )
    REFERENCES `@(VDADB)`.`t_storage` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_desktop_template`
    FOREIGN KEY (`template_id` )
    REFERENCES `@(VDADB)`.`t_template` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_pool`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_pool` (
  `id` BIGINT NOT NULL ,
  `name` CHAR(255) BINARY NOT NULL ,
  `min_desktops` INT NULL ,
  `max_desktops` INT NULL ,
  `preferred_desktops` INT NULL ,
  `template_id_v31` BIGINT NULL ,
  `apply_sysprep` BOOLEAN NULL DEFAULT false ,
  `custom_spec` TEXT NULL ,
  `enable_auto_cloning` BOOLEAN NULL DEFAULT false ,
  `idle_timeout` INT NULL ,
  `max_age` INT NULL ,
  `max_clone_jobs` INT NULL ,
  `recycle_policy` CHAR(30) NOT NULL ,
  `vm_name_prefix` CHAR(20) NULL ,
  `type` CHAR(30) NULL ,
  `desktop_provider_id` BIGINT NULL ,
  `creation_time` DATETIME NULL ,
  `last_recycle_time` DATETIME NULL ,
  `power_state` CHAR(30) NOT NULL ,
  `disable_assignments` BOOLEAN NULL DEFAULT false ,
  `description` CHAR(255) NULL ,
  `state` CHAR(25) NULL ,
  `optionals` TEXT NULL ,
  `version` BIGINT NOT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX fk_pool_desktopprovider (`desktop_provider_id` ASC) ,
  UNIQUE INDEX unique_name (`name` ASC) ,
  INDEX fk_pool_template (`template_id_v31` ASC) ,
  CONSTRAINT `fk_pool_desktopprovider`
    FOREIGN KEY (`desktop_provider_id` )
    REFERENCES `@(VDADB)`.`t_desktopprovider` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_pool_desktop`
    FOREIGN KEY (`template_id_v31` )
    REFERENCES `@(VDADB)`.`t_template` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_host_has_desktopprovider`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_host_has_desktopprovider` (
  `host_id` BIGINT NOT NULL ,
  `desktop_provider_id` BIGINT NOT NULL ,
  PRIMARY KEY (`host_id`, `desktop_provider_id`) ,
  INDEX fk_desktopprovider_host (`host_id` ASC) ,
  INDEX fk_host_desktopprovider (`desktop_provider_id` ASC) ,
  CONSTRAINT `fk_desktopprovider_host`
    FOREIGN KEY (`host_id` )
    REFERENCES `@(VDADB)`.`t_host` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_host_desktopprovider`
    FOREIGN KEY (`desktop_provider_id` )
    REFERENCES `@(VDADB)`.`t_desktopprovider` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_storage_has_desktopprovider`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_storage_has_desktopprovider` (
  `storage_id` BIGINT NOT NULL ,
  `desktop_provider_id` BIGINT NOT NULL ,
  PRIMARY KEY (`storage_id`, `desktop_provider_id`) ,
  INDEX fk_desktopprovider_storage (`storage_id` ASC) ,
  INDEX fk_storage_desktopprovider (`desktop_provider_id` ASC) ,
  CONSTRAINT `fk_desktopprovider_storage`
    FOREIGN KEY (`storage_id` )
    REFERENCES `@(VDADB)`.`t_storage` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_storage_desktopprovider`
    FOREIGN KEY (`desktop_provider_id` )
    REFERENCES `@(VDADB)`.`t_desktopprovider` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_globalpreferences`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_globalpreferences` (
  `id` BIGINT NOT NULL ,
  `global_key` CHAR(255) NOT NULL ,
  `global_value` TEXT NULL ,
  `version` BIGINT NOT NULL ,
  PRIMARY KEY (`id`) ,
  UNIQUE INDEX global_key (`global_key` ASC) )
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_amghserver`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_amghserver` (
  `id` BIGINT NOT NULL ,
  `amgh_group_id` BIGINT NOT NULL ,
  `ip_adress` CHAR(30) NOT NULL ,
  `description` CHAR(255) NULL ,
  `version` BIGINT NOT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX fk_amghserver_amghgroup (`amgh_group_id` ASC) ,
  CONSTRAINT `fk_amghserver_amghgroup`
    FOREIGN KEY (`amgh_group_id` )
    REFERENCES `@(VDADB)`.`t_amghgroup` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_poolclient_has_pool`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_poolclient_has_pool` (
  `pool_client_id` BIGINT NOT NULL ,
  `pool_id` BIGINT NOT NULL ,
  PRIMARY KEY (`pool_client_id`, `pool_id`) ,
  INDEX fk_pool_poolclient (`pool_client_id` ASC) ,
  INDEX fk_poolclient_pool (`pool_id` ASC) ,
  CONSTRAINT `fk_pool_poolclient`
    FOREIGN KEY (`pool_client_id` )
    REFERENCES `@(VDADB)`.`t_poolclient` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_poolclient_pool`
    FOREIGN KEY (`pool_id` )
    REFERENCES `@(VDADB)`.`t_pool` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_poolresource`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_poolresource` (
  `id` BIGINT NOT NULL ,
  `pool_id` BIGINT NULL ,
  `resource_name` CHAR(255) NULL ,
  `resource_type` CHAR(255) NULL ,
  `resource_id` CHAR(255) NULL ,
  `computing_resource_id` BIGINT NULL ,
  `storage_resource_id` BIGINT NULL ,
  `type` CHAR(30) NOT NULL ,
  `version` BIGINT NOT NULL ,
  INDEX fk_t_pool_resources_t_pool (`pool_id` ASC) ,
  INDEX pool_id (`pool_id` ASC) ,
  PRIMARY KEY (`id`) ,
  INDEX fk_t_pool_resources_t_storage (`storage_resource_id` ASC) ,
  INDEX fk_t_pool_resources_t_host (`computing_resource_id` ASC) ,
  CONSTRAINT `fk_t_pool_resources_t_pool`
    FOREIGN KEY (`pool_id` )
    REFERENCES `@(VDADB)`.`t_pool` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_t_pool_resources_t_storage`
    FOREIGN KEY (`storage_resource_id` )
    REFERENCES `@(VDADB)`.`t_storage` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_t_pool_resources_t_host`
    FOREIGN KEY (`computing_resource_id` )
    REFERENCES `@(VDADB)`.`t_host` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_job`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_job` (
  `id` BIGINT NOT NULL AUTO_INCREMENT ,
  `type` CHAR(255) NULL ,
  `resource_lock` CHAR(255) NULL ,
  `jobdata` TEXT NULL ,
  `status` CHAR(45) NULL ,
  `submitter` CHAR(255) NULL ,
  `progress` INT NULL ,
  `progress_detail` CHAR(255) NULL ,
  `owner` CHAR(255) NULL ,
  `keepalive` DATETIME NULL ,
  `starttime` DATETIME NULL ,
  `endtime` DATETIME NULL ,
  `visibility` BOOLEAN NULL DEFAULT true ,
  `pool_id` BIGINT NULL ,
  `version` BIGINT NOT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX fk_t_job_t_pool (`pool_id` ASC) ,
  INDEX type_index (`type` ASC) ,
  INDEX status_index (`status` ASC) ,
  INDEX visibility_index (`visibility` ASC) ,
  INDEX owner_index (`owner` ASC))
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_template`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_template` (
  `id` BIGINT NOT NULL ,
  `name` CHAR(255) NULL ,
  `guest_name` CHAR(255) NULL ,
  `ip_or_dns` CHAR(255) NULL ,
  `port` INT NULL ,
  `type` CHAR(30) NOT NULL ,
  `external_id` CHAR(255) NOT NULL ,
  `pool_id` BIGINT NULL ,
  `state` CHAR(30) NULL ,
  `desktop_provider_id` BIGINT NULL ,
  `description` CHAR(255) NULL ,
  `operating_system` CHAR(255) NULL ,
  `optionals` TEXT NULL ,
  `volume_size` BIGINT NULL ,
  `creation_date` DATETIME NULL ,
  `host_id` BIGINT NULL ,
  `storage_id` BIGINT NULL ,
  `rev_template_id` BIGINT NULL ,
  `rev_master_id` BIGINT NULL ,
  `rev_parent_id` BIGINT NULL ,
  `version` BIGINT NOT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX `fk_template_pool` (`pool_id` ASC) ,
  INDEX `fk_template_desktopprovider` (`desktop_provider_id` ASC) ,
  INDEX `fk_template_host` (`host_id` ASC) ,
  INDEX `fk_template_storage` (`storage_id` ASC) ,
  UNIQUE INDEX external_provider_id (`external_id` ASC, `desktop_provider_id` ASC) ,
  INDEX `fk_template_template_id` (`rev_template_id` ASC) ,
  INDEX `fk_template_master_id` (`rev_master_id` ASC) ,
  INDEX `fk_template_parent_id` (`rev_parent_id` ASC) ,
  CONSTRAINT `fk_template_pool`
    FOREIGN KEY (`pool_id` )
    REFERENCES `@(VDADB)`.`t_pool` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_template_desktopprovider`
    FOREIGN KEY (`desktop_provider_id` )
    REFERENCES `@(VDADB)`.`t_desktopprovider` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_template_host`
    FOREIGN KEY (`host_id` )
    REFERENCES `@(VDADB)`.`t_host` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_template_storage`
    FOREIGN KEY (`storage_id` )
    REFERENCES `@(VDADB)`.`t_storage` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_template_template_id`
    FOREIGN KEY (`rev_template_id` )
    REFERENCES `@(VDADB)`.`t_template` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_template_master_id`
    FOREIGN KEY (`rev_master_id` )
    REFERENCES `@(VDADB)`.`t_template` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_template_parent_id`
    FOREIGN KEY (`rev_parent_id` )
    REFERENCES `@(VDADB)`.`t_template` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_vlan`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_vlan` (
  `id` BIGINT NOT NULL ,
  `subnet` CHAR(255) NOT NULL ,
  `name` CHAR(255) NULL,
  `version` BIGINT NOT NULL ,
  PRIMARY KEY (`id`),
  UNIQUE INDEX subnet_idx (`subnet` ASC))
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Table `@(VDADB)`.`t_sequence`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `@(VDADB)`.`t_sequence` (
  `seq_name` CHAR(50) NOT NULL ,
  `seq_count` DECIMAL(38,0) NULL DEFAULT NULL ,
  PRIMARY KEY (`seq_name`) )
ENGINE = @(VDADB.ENGINE);


-- -----------------------------------------------------
-- Data for table `@(VDADB)`.`t_sequence`
-- -----------------------------------------------------

SET AUTOCOMMIT=0;
INSERT INTO `t_sequence` (`seq_name`, `seq_count`) SELECT DISTINCT 'gen_desktop', 0 FROM (SELECT COUNT(*) FROM `t_sequence`) AS `seq` WHERE 'gen_desktop' NOT IN (SELECT `seq_name` FROM `t_sequence`);
INSERT INTO `t_sequence` (`seq_name`, `seq_count`) SELECT DISTINCT 'gen_template', 0 FROM (SELECT COUNT(*) FROM `t_sequence`) AS `seq` WHERE 'gen_template' NOT IN (SELECT `seq_name` FROM `t_sequence`);
INSERT INTO `t_sequence` (`seq_name`, `seq_count`) SELECT DISTINCT 'gen_desktopprovider', 0 FROM (SELECT COUNT(*) FROM `t_sequence`) AS `seq` WHERE 'gen_desktopprovider' NOT IN (SELECT `seq_name` FROM `t_sequence`);
INSERT INTO `t_sequence` (`seq_name`, `seq_count`) SELECT DISTINCT 'gen_host', 0 FROM (SELECT COUNT(*) FROM `t_sequence`) AS `seq` WHERE 'gen_host' NOT IN (SELECT `seq_name` FROM `t_sequence`);
INSERT INTO `t_sequence` (`seq_name`, `seq_count`) SELECT DISTINCT 'gen_pool', 0 FROM (SELECT COUNT(*) FROM `t_sequence`) AS `seq` WHERE 'gen_pool' NOT IN (SELECT `seq_name` FROM `t_sequence`);
INSERT INTO `t_sequence` (`seq_name`, `seq_count`) SELECT DISTINCT 'gen_poolclient', 0 FROM (SELECT COUNT(*) FROM `t_sequence`) AS `seq` WHERE 'gen_poolclient' NOT IN (SELECT `seq_name` FROM `t_sequence`);
INSERT INTO `t_sequence` (`seq_name`, `seq_count`) SELECT DISTINCT 'gen_resource', 0 FROM (SELECT COUNT(*) FROM `t_sequence`) AS `seq` WHERE 'gen_resource' NOT IN (SELECT `seq_name` FROM `t_sequence`);
INSERT INTO `t_sequence` (`seq_name`, `seq_count`) SELECT DISTINCT 'gen_storage', 0 FROM (SELECT COUNT(*) FROM `t_sequence`) AS `seq` WHERE 'gen_storage' NOT IN (SELECT `seq_name` FROM `t_sequence`);
INSERT INTO `t_sequence` (`seq_name`, `seq_count`) SELECT DISTINCT 'gen_userdirectory', 0 FROM (SELECT COUNT(*) FROM `t_sequence`) AS `seq` WHERE 'gen_userdirectory' NOT IN (SELECT `seq_name` FROM `t_sequence`);
INSERT INTO `t_sequence` (`seq_name`, `seq_count`) SELECT DISTINCT 'gen_userdirectory_host', 0 FROM (SELECT COUNT(*) FROM `t_sequence`) AS `seq` WHERE 'gen_userdirectory_host' NOT IN (SELECT `seq_name` FROM `t_sequence`);
INSERT INTO `t_sequence` (`seq_name`, `seq_count`) SELECT DISTINCT 'vda_instances_count', 0 FROM (SELECT COUNT(*) FROM `t_sequence`) AS `seq` WHERE 'vda_instances_count' NOT IN (SELECT `seq_name` FROM `t_sequence`);
INSERT INTO `t_sequence` (`seq_name`, `seq_count`) SELECT DISTINCT 'gen_property', 2 FROM (SELECT COUNT(*) FROM `t_sequence`) AS `seq` WHERE 'gen_property' NOT IN (SELECT `seq_name` FROM `t_sequence`);
INSERT INTO `t_sequence` (`seq_name`, `seq_count`) SELECT DISTINCT 'gen_vlan', 0 FROM (SELECT COUNT(*) FROM `t_sequence`) AS `seq` WHERE 'gen_vlan' NOT IN (SELECT `seq_name` FROM `t_sequence`);
COMMIT;


-- -----------------------------------------------------
-- Data for table `@(VDADB)`.`t_globalpreferences`
-- -----------------------------------------------------

SET AUTOCOMMIT=0;
INSERT INTO `t_globalpreferences` (`id`, `global_key`, `global_value`, `version`) SELECT DISTINCT '1', 'schema_version', '3.1', 1 FROM (SELECT COUNT(*) FROM `t_globalpreferences`) AS `pref` WHERE 'schema_version' NOT IN (SELECT `global_key` FROM `t_globalpreferences`);
INSERT INTO `t_globalpreferences` (`id`, `global_key`, `global_value`, `version`) SELECT DISTINCT '2', 't_job_mutex', '1', 1 FROM (SELECT COUNT(*) FROM `t_globalpreferences`) AS `pref` WHERE 't_job_mutex' NOT IN (SELECT `global_key` FROM `t_globalpreferences`);
COMMIT;


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