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

CREATE TABLE `kp_config` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL DEFAULT '',
  `value` text NOT NULL,
  `vtype` int(2) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`,`key`),
  KEY `key` (`key`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_config`
--

INSERT INTO `kp_config` (`id`, `key`, `value`, `vtype`) VALUES (1,'windows','1',1),(2,'includeheaders','1',1),(3,'publicrssfeed','0',1),(4,'externalcss','',0),(5,'externaljavascript','',0),(6,'bundleconfigured','1',1),(7,'base_dir','/path/to/my/music/archive/',0),(8,'activenetworkhosts','0',1),(9,'default_language','0',2),(10,'streamlocation','',0),(11,'ajaxurl','',0),(12,'timeout','43200',2),(13,'homepage','http://www.kplaylist.net/&#63;ver=KVER&amp;build=KBUILD',0),(14,'showkeyteq','1',1),(15,'showupgrade','1',1),(16,'showstatistics','0',1),(17,'basedir_changed','0',1),(18,'reupdate','0',1);

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

CREATE TABLE `kp_iceradio` (
  `stationid` int(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL DEFAULT '',
  `playlistid` int(11) NOT NULL DEFAULT '0',
  `lactive` int(4) NOT NULL DEFAULT '0',
  `curseq` int(4) NOT NULL DEFAULT '0',
  `nextseq` int(4) NOT NULL DEFAULT '0',
  `pass` varchar(64) NOT NULL DEFAULT '',
  `loop` char(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`stationid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_iceradio`
--


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

CREATE TABLE `kp_network` (
  `nid` int(4) NOT NULL AUTO_INCREMENT,
  `enabled` char(1) NOT NULL DEFAULT '1',
  `url` text NOT NULL,
  `username` varchar(64) NOT NULL DEFAULT '0',
  `password` varchar(64) NOT NULL DEFAULT '0',
  PRIMARY KEY (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_network`
--


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

CREATE TABLE `kp_session` (
  `sessionid` bigint(16) NOT NULL AUTO_INCREMENT,
  `u_id` int(4) NOT NULL DEFAULT '0',
  `ip` int(4) NOT NULL DEFAULT '0',
  `login` int(4) NOT NULL DEFAULT '0',
  `refreshed` int(4) NOT NULL DEFAULT '0',
  `logout` int(4) NOT NULL DEFAULT '0',
  `sstatus` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sessionid`),
  KEY `u_id` (`u_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_session`
--

INSERT INTO `kp_session` (`sessionid`, `u_id`, `ip`, `login`, `refreshed`, `logout`, `sstatus`) VALUES (1,1,1917792904,1351432300,1351432300,0,0);

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


--
-- Table structure for table `kp_users`
--

CREATE TABLE `kp_users` (
  `u_name` varchar(64) NOT NULL DEFAULT '',
  `u_pass` varchar(32) NOT NULL DEFAULT '',
  `u_login` varchar(32) NOT NULL DEFAULT '',
  `u_comment` varchar(64) DEFAULT '',
  `u_id` int(4) NOT NULL AUTO_INCREMENT,
  `u_booted` tinyint(4) NOT NULL DEFAULT '0',
  `u_status` tinyint(4) NOT NULL DEFAULT '0',
  `u_access` tinyint(4) DEFAULT '1',
  `u_allowdownload` char(1) NOT NULL DEFAULT '1',
  `allowarchive` char(1) NOT NULL DEFAULT '1',
  `archivesize` int(4) NOT NULL DEFAULT '0',
  `extm3u` char(1) NOT NULL DEFAULT '1',
  `defplaylist` int(4) NOT NULL DEFAULT '0',
  `defshplaylist` int(4) NOT NULL DEFAULT '0',
  `defaultid3` char(1) NOT NULL DEFAULT '0',
  `defstationid` int(4) NOT NULL DEFAULT '0',
  `defaultsearch` int(1) NOT NULL DEFAULT '0',
  `partymode` char(1) NOT NULL DEFAULT '0',
  `theme` int(4) NOT NULL DEFAULT '1',
  `lockedtime` int(8) NOT NULL DEFAULT '0',
  `hotrows` int(4) NOT NULL DEFAULT '21',
  `searchrows` int(4) NOT NULL DEFAULT '21',
  `detailrows` int(4) NOT NULL DEFAULT '5',
  `lang` tinyint(4) NOT NULL DEFAULT '0',
  `udlrate` int(4) NOT NULL DEFAULT '0',
  `defgenre` int(4) NOT NULL DEFAULT '0',
  `archer` char(1) NOT NULL DEFAULT '0',
  `hitsas` tinyint(4) NOT NULL DEFAULT '0',
  `lameperm` char(1) NOT NULL DEFAULT '0',
  `lamerate` int(4) NOT NULL DEFAULT '0',
  `allowemail` char(1) NOT NULL DEFAULT '0',
  `email` varchar(128) NOT NULL DEFAULT '',
  `plinline` char(1) NOT NULL DEFAULT '1',
  `hotmode` int(4) NOT NULL DEFAULT '0',
  `created` int(4) NOT NULL DEFAULT '0',
  `laston` int(4) NOT NULL DEFAULT '0',
  `pltype` int(4) NOT NULL DEFAULT '1',
  `orsearch` char(1) NOT NULL DEFAULT '0',
  `textcut` int(2) NOT NULL DEFAULT '80',
  `dircolumn` int(2) NOT NULL DEFAULT '1',
  `streamengine` char(1) NOT NULL DEFAULT '1',
  `utemplate` char(1) NOT NULL DEFAULT '0',
  `homedir` varchar(255) NOT NULL DEFAULT '',
  `detailview` char(1) NOT NULL DEFAULT '0',
  `forcelamerate` int(4) NOT NULL DEFAULT '0',
  `network` char(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`u_id`),
  UNIQUE KEY `u_login` (`u_login`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kp_users`
--

INSERT INTO `kp_users` (`u_name`, `u_pass`, `u_login`, `u_comment`, `u_id`, `u_booted`, `u_status`, `u_access`, `u_allowdownload`, `allowarchive`, `archivesize`, `extm3u`, `defplaylist`, `defshplaylist`, `defaultid3`, `defstationid`, `defaultsearch`, `partymode`, `theme`, `lockedtime`, `hotrows`, `searchrows`, `detailrows`, `lang`, `udlrate`, `defgenre`, `archer`, `hitsas`, `lameperm`, `lamerate`, `allowemail`, `email`, `plinline`, `hotmode`, `created`, `laston`, `pltype`, `orsearch`, `textcut`, `dircolumn`, `streamengine`, `utemplate`, `homedir`, `detailview`, `forcelamerate`, `network`) VALUES ('vinhost','3e24b6f16e612925f7ee8cf660a7e876','vinhost','admin',1,0,0,0,'1','1',0,'1',0,0,'0',0,0,'0',1,0,21,21,5,0,0,0,'0',0,'0',0,'0','admin@streaming.vinhostmedia.com','1',0,1351432258,0,1,'0',80,1,'1','0','','0',0,'0');

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

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


