--
-- Host: localhost    Database: vinhostm_kpla882
-- ------------------------------------------------------


--
-- Table structure for table `kp_archive`
--

CREATE TABLE `kp_archive` (
  `aid` int(4) NOT NULL AUTO_INCREMENT,
  `uid` int(4) NOT NULL DEFAULT '0',
  `utime` bigint(8) NOT NULL DEFAULT '0',
  `fpath` mediumblob NOT NULL,
  PRIMARY KEY (`aid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_archive`
--


--
-- Table structure for table `kp_bulletin`
--

CREATE TABLE `kp_bulletin` (
  `bid` int(4) NOT NULL AUTO_INCREMENT,
  `u_id` int(4) NOT NULL DEFAULT '0',
  `utime` int(4) NOT NULL DEFAULT '0',
  `publish` int(4) NOT NULL DEFAULT '0',
  `mesg` text NOT NULL,
  PRIMARY KEY (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_bulletin`
--


--
-- Table structure for table `kp_cache`
--

CREATE TABLE `kp_cache` (
  `cacheid` int(4) NOT NULL AUTO_INCREMENT,
  `id` int(4) NOT NULL DEFAULT '0',
  `value` text NOT NULL,
  PRIMARY KEY (`cacheid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_cache`
--

INSERT INTO `kp_cache` (`cacheid`, `id`, `value`) VALUES (1,10,''),(2,20,'');

--
-- Table structure for table `kp_filetypes`
--

CREATE TABLE `kp_filetypes` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `extension` varchar(32) NOT NULL DEFAULT '',
  `mime` varchar(128) NOT NULL DEFAULT '',
  `m3u` char(1) NOT NULL DEFAULT '',
  `getid` int(4) NOT NULL DEFAULT '0',
  `search` char(1) NOT NULL DEFAULT '1',
  `logaccess` char(1) NOT NULL DEFAULT '1',
  `enabled` char(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_filetypes`
--


--
-- Table structure for table `kp_kplayversion`
--

CREATE TABLE `kp_kplayversion` (
  `app_ver` varchar(6) NOT NULL DEFAULT '',
  `app_build` varchar(6) NOT NULL DEFAULT '',
  `app_finstall` int(4) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_kplayversion`
--

INSERT INTO `kp_kplayversion` (`app_ver`, `app_build`, `app_finstall`) VALUES ('1.8','502',1351432258);

--
-- Table structure for table `kp_message`
--

CREATE TABLE `kp_message` (
  `meid` int(4) NOT NULL AUTO_INCREMENT,
  `uid` int(4) NOT NULL DEFAULT '0',
  `utime` bigint(8) NOT NULL DEFAULT '0',
  `message` text NOT NULL,
  PRIMARY KEY (`meid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_message`
--


--
-- Table structure for table `kp_mhistory`
--

CREATE TABLE `kp_mhistory` (
  `h_id` int(4) NOT NULL AUTO_INCREMENT,
  `u_id` int(4) NOT NULL DEFAULT '0',
  `s_id` int(4) NOT NULL DEFAULT '0',
  `tid` tinyint(4) NOT NULL DEFAULT '0',
  `utime` int(4) NOT NULL DEFAULT '0',
  `dwritten` int(4) NOT NULL DEFAULT '0',
  `dpercent` int(4) NOT NULL DEFAULT '0',
  `cpercent` int(4) NOT NULL DEFAULT '0',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `mid` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`h_id`),
  KEY `s_id` (`s_id`),
  KEY `u_id` (`u_id`),
  KEY `utime` (`utime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_mhistory`
--


--
-- Table structure for table `kp_playlist`
--

CREATE TABLE `kp_playlist` (
  `u_id` int(4) NOT NULL DEFAULT '0',
  `name` varchar(32) NOT NULL DEFAULT '',
  `public` char(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `listid` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`listid`),
  UNIQUE KEY `u_login` (`u_id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_playlist`
--


--
-- Table structure for table `kp_playlist_list`
--

CREATE TABLE `kp_playlist_list` (
  `listid` int(11) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(4) NOT NULL DEFAULT '0',
  `seq` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `listid` (`listid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_playlist_list`
--


--
-- Table structure for table `kp_search`
--

CREATE TABLE `kp_search` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `xid` int(11) NOT NULL DEFAULT '0',
  `f_stat` int(4) NOT NULL DEFAULT '0',
  `track` int(4) NOT NULL DEFAULT '0',
  `year` int(4) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `comment` varchar(255) NOT NULL DEFAULT '',
  `dirname` varchar(255) NOT NULL DEFAULT '',
  `free` varchar(255) NOT NULL DEFAULT '',
  `fpath` mediumblob NOT NULL,
  `fname` tinyblob NOT NULL,
  `album` varchar(255) NOT NULL DEFAULT '',
  `artist` varchar(255) NOT NULL DEFAULT '',
  `md5` varchar(32) NOT NULL DEFAULT '',
  `hits` int(4) NOT NULL DEFAULT '0',
  `mtime` int(4) NOT NULL DEFAULT '0',
  `ltime` int(4) NOT NULL DEFAULT '0',
  `date` int(4) NOT NULL DEFAULT '0',
  `fsize` int(4) NOT NULL DEFAULT '0',
  `genre` int(4) NOT NULL DEFAULT '255',
  `bitrate` int(4) NOT NULL DEFAULT '0',
  `ratemode` tinyint(4) DEFAULT '0',
  `lengths` int(4) NOT NULL DEFAULT '0',
  `drive` tinyint(4) DEFAULT '0',
  `ftypeid` int(4) NOT NULL DEFAULT '-1',
  `id3image` char(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `xid` (`xid`),
  KEY `dirname` (`dirname`),
  KEY `free` (`free`),
  KEY `artist` (`artist`),
  KEY `album` (`album`),
  KEY `title` (`title`),
  KEY `fsize` (`fsize`),
  KEY `date` (`date`),
  KEY `f_stat` (`f_stat`),
  KEY `drive` (`drive`),
  KEY `ftypeid` (`ftypeid`),
  KEY `fname` (`fname`(255)),
  KEY `fpath` (`fpath`(255))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_search`
--


--
-- Table structure for table `kp_templist`
--

CREATE TABLE `kp_templist` (
  `rid` int(4) NOT NULL AUTO_INCREMENT,
  `uid` int(4) NOT NULL DEFAULT '0',
  `sid` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_templist`
--


--
-- Dumping events for database 'vinhostm_kpla882'
--

--
-- Dumping routines for database 'vinhostm_kpla882'
--


