1	CREATE TABLE modules (
     2	    module          VARCHAR(256),
     3	    modversion      VARCHAR(24),
     4	    normmodversion  VARCHAR(24),
     5	    dist            VARCHAR(256),
     6	    distversion     VARCHAR(24)
     7	) ENGINE = 'InnoDB';
     8	CREATE        INDEX modules_distdistversion on modules(dist, distversion);
     9	
    10	CREATE TABLE dists (
    11	    dist        VARCHAR(256),
    12	    distversion VARCHAR(24),
    13	    file        VARCHAR(256)
    14	) ENGINE = 'InnoDB';
    15	
    16	CREATE TABLE passes (
    17	    dist            VARCHAR(256),
    18	    distversion     VARCHAR(24),
    19	    normdistversion VARCHAR(24),
    20	    perl            VARCHAR(8),
    21	    osname          VARCHAR(16)
    22	) ENGINE = 'InnoDB';
    23	
    24	CREATE        INDEX pass_normdistversion ON passes(normdistversion);
    25	CREATE        INDEX pass_dist            ON passes(dist);
    26	CREATE        INDEX pass_distversion     ON passes(distversion);
    27	CREATE        INDEX pass_perl            ON passes(perl);
    28	CREATE        INDEX pass_osname          ON passes(osname);
    29	
    30	CREATE UNIQUE INDEX passes_uniq_dist_distversion_perl_osname ON passes (dist, distversion, perl, osname);
    31	
    32	CREATE UNIQUE INDEX dists_idx ON dists(dist, distversion);
    33	CREATE UNIQUE INDEX modules_idx ON modules(module, modversion, dist, distversion);
    34	CREATE UNIQUE INDEX files_idx ON dists(file);