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


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

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`m_id`, `m_title`, `album_id`, `cate_id`, `m_poster`, `m_lyric`, `m_type`, `m_created`, `m_url`) VALUES
(1, 'test', 1, 1, 'eeeeeeeeeeeeee', 'eeeeeeeeeeee', 1, '2017-03-08', 'gfdgfdgfgfd');

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

--
