 --
 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`

  `m_url` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--

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

