--#
--# Copyright (c) 2006 rPath, Inc.
--#
--# This program is distributed under the terms of the Common Public License,
--# version 1.0. A copy of this license should have been distributed with this
--# source file in a file called LICENSE. If it is not present, the license
--# is always available at http://www.opensource.org/licenses/cpl.php.
--#

create database if not exists testdb character set latin1 collate latin1_bin;

use testdb ;

set autocommit=0;


SELECT default_character_set_name FROM INFORMATION_SCHEMA.SCHEMATA where schema_name= 'testdb';

set character set latin1;

       CREATE TEMPORARY TABLE ffFlavor(
            flavorId    INTEGER,
            base        VARCHAR(254),
            sense       INTEGER,
            flag        VARCHAR(254)
        ) DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;
       CREATE  INDEX ffFlavorBaseIdx on ffFlavor (flavorId,base);
       CREATE  INDEX ffFlavorSenseIdx on ffFlavor (flavorId,sense);

       CREATE TEMPORARY TABLE NewFiles(
            pathId      VARBINARY(16),
            versionId   INTEGER,
            fileId      VARBINARY(20),
            stream      MEDIUMBLOB,
            path        VARCHAR(767)
        ) DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;
       CREATE  INDEX NewFilesFileIdx on NewFiles (fileId);

       CREATE TEMPORARY TABLE NewRedirects(
            item        VARCHAR(767),
            branch      VARCHAR(767),
            flavor      VARCHAR(767)
        ) DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;

       CREATE TEMPORARY TABLE NeededFlavors(
            flavor      VARCHAR(767)
        ) DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;

       CREATE TEMPORARY TABLE gtl(
            idx         INTEGER PRIMARY KEY AUTO_INCREMENT,
            name        VARCHAR(254),
            version     VARCHAR(767),
            flavor      VARCHAR(767)
        ) DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;

       CREATE TEMPORARY TABLE gtlInst(
            idx         INTEGER PRIMARY KEY AUTO_INCREMENT,
            instanceId  INTEGER
        ) DEFAULT CHARACTER SET latin1 COLLATE latin1_bin ;
       CREATE  INDEX gtlInstInstanceIdx on gtlInst (instanceId, idx);

       CREATE TEMPORARY TABLE getFilesTbl(
            itemId      INTEGER PRIMARY KEY,
            fileId      VARBINARY(20)
        ) DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;

       CREATE TEMPORARY TABLE itf(
            item        VARCHAR(254),
            version     VARCHAR(767),
            fullVersion VARCHAR(767)
        ) DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;

       CREATE TEMPORARY TABLE gtvlTbl(
            item        VARCHAR(767),
            versionSpec VARCHAR(767),
            flavorId    INTEGER
        ) DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;
       CREATE  INDEX gtvlTblItemIdx on gtvlTbl (item);

       CREATE TEMPORARY TABLE
        hasTrovesTmp(
            row         INTEGER,
            item        VARCHAR(254),
            version     VARCHAR(767),
            flavor      VARCHAR(767)
        ) DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;
       CREATE  INDEX hasTrovesTmpIdx on hasTrovesTmp (item, version);

       CREATE TEMPORARY TABLE
        tmpInstances(
            instanceId    INTEGER
        ) DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;
       CREATE  INDEX tmpInstancesIdx on tmpInstances (instanceId);

       CREATE TEMPORARY TABLE
        tmpInstances2(
            instanceId    INTEGER
        ) DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;

       CREATE TEMPORARY TABLE
        gfvTable(
            idx         INTEGER PRIMARY KEY AUTO_INCREMENT,
            fileId      VARBINARY(20)
        ) DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;
       CREATE  INDEX gfvTableFileIdIdx on gfvTable (fileId);

       commit;