CREATE DATABASE `baza` DEFAULT CHARACTER SET latin2 COLLATE latin2_general_ci;
USE `baza`;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `tbl_bulletin`
--
CREATE TABLE `tbl_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=latin2 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `tbl_cache`
--
CREATE TABLE `tbl_cache` (
`cacheid` int(4) NOT NULL AUTO_INCREMENT,
`id` int(4) NOT NULL DEFAULT '0',
`value` text NOT NULL,
PRIMARY KEY (`cacheid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `tbl_config`
--
CREATE TABLE `tbl_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 DEFAULT CHARSET=latin2 AUTO_INCREMENT=53 ;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `tbl_filetypes`
--
CREATE TABLE `tbl_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=latin2 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `tbl_kplayversion`
--
CREATE TABLE `tbl_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=latin2;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `tbl_mhistory`
--
CREATE TABLE `tbl_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',
`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=latin2 AUTO_INCREMENT=383 ;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `tbl_playlist`
--
CREATE TABLE `tbl_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=latin2 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `tbl_playlist_list`
--
CREATE TABLE `tbl_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=latin2 AUTO_INCREMENT=12 ;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `tbl_search`
--
CREATE TABLE `tbl_search` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`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 '',
`free` varchar(255) NOT NULL DEFAULT '',
`comment` varchar(255) NOT NULL DEFAULT '',
`dirname` varchar(255) NOT NULL DEFAULT '0',
`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',
`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',
PRIMARY KEY (`id`),
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=26 ;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `tbl_session`
--
CREATE TABLE `tbl_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 DEFAULT CHARSET=latin2 AUTO_INCREMENT=1092396701 ;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `tbl_users`
--
CREATE TABLE `tbl_users` (
`u_name` varchar(32) NOT NULL DEFAULT '',
`u_pass` varchar(32) NOT NULL DEFAULT '',
`u_login` varchar(32) NOT NULL DEFAULT '',
`u_ip` varchar(16) NOT NULL DEFAULT '',
`u_comment` varchar(64) DEFAULT NULL,
`u_id` int(4) NOT NULL AUTO_INCREMENT,
`u_sessionkey` bigint(16) UNSIGNED DEFAULT '0',
`u_booted` tinyint(4) NOT NULL DEFAULT '0',
`u_status` tinyint(4) NOT NULL DEFAULT '0',
`u_time` bigint(16) 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',
`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 '25',
`searchrows` int(4) NOT NULL DEFAULT '25',
`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',
PRIMARY KEY (`u_id`),
UNIQUE KEY `u_login` (`u_login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=8 ;