DROP TABLE IF EXISTS `znu_music`;
CREATE TABLE `znu_music` (
  `id` int(10) NOT NULL,
  `ijrochi` varchar(100) NOT NULL,
  `nomi` varchar(100) NOT NULL,
  `izoh` varchar(150) NOT NULL,
  `albom` varchar(50) NOT NULL,
  `yil` int(10) NOT NULL,
  `bitrate` int(100) NOT NULL,
  `duration` int(100) NOT NULL,
  `sam` int(100) NOT NULL,
  `path` varchar(100) NOT NULL,
  `coverpath` varchar(100) NOT NULL,
  `time` int(10) NOT NULL DEFAULT '0',
  `view` int(10) NOT NULL DEFAULT '0',
  `size` int(10) NOT NULL DEFAULT '0',
  `user_id` int(10) NOT NULL DEFAULT '0',
  `download` int(10) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `znu_music`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `znu_music`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;
COMMIT;
