 --
 ALTER TABLE `media`
   ADD PRIMARY KEY (`m_id`),
-  ADD KEY `cate_id` (`cate_id`);
+  ADD KEY `cate_id` (`cate_id`),
+  ADD KEY `album_id` (`album_id`);
 
 --
 -- Indexes for table `media_singer`

-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 07, 2017 at 08:29 PM
-- Server version: 10.1.21-MariaDB
-- PHP Version: 5.6.30


-- Constraints for table `media`
--
ALTER TABLE `media`
  ADD CONSTRAINT `media_ibfk_1` FOREIGN KEY (`cate_id`) REFERENCES `category` (`cate_id`),
  ADD CONSTRAINT `media_ibfk_2` FOREIGN KEY (`album_id`) REFERENCES `album` (`album_id`);

--
-- Constraints for table `media_singer`
