   ADD KEY `idx_crack_info_2` (`cracker_id`);
 
 --
+-- Indexes for table `download`
+--
+ALTER TABLE `download`
+  ADD PRIMARY KEY (`file_type`,`name`,`os`,`arch`,`processor`,`brand`);
+
+--
 -- Indexes for table `generator`
 --
 ALTER TABLE `generator`

  `rate_cpu` double UNSIGNED DEFAULT NULL,
  `rate_gpu` double UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- RELATIONS FOR TABLE `algorithm`:
--

-- --------------------------------------------------------


  `id` tinyint(3) UNSIGNED NOT NULL,
  `name` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT 'os_arch_processor[_brand]'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

