MySql 2f Database Schema

From MythTV

Here is the database schema for the CVS version of MythTV dated 5/16/2004 16:44pm

Contents 1 Database 1.1 capturecard 1.2 cardinput 1.3 channel 1.4 codecparams 1.5 conflictresolutionany 1.6 conflictresolutionoverride 1.7 conflictresolutionsingle 1.8 credits 1.9 dvb_channel 1.10 dvb_pids 1.11 dvb_sat 1.12 dvb_signal_quality 1.13 dvdinput 1.14 dvdtranscode 1.15 favorites 1.16 gallerymetadata 1.17 gamemetadata 1.18 housekeeping 1.19 jumppoints 1.20 keybindings 1.21 keyword 1.22 mamemetadata 1.23 mamesettings 1.24 musicmetadata 1.25 musicplaylist 1.26 musicsmartplaylist 1.27 mythlog 1.28 neskeyword 1.29 nestitle 1.30 newssites 1.31 oldprogram 1.32 oldrecorded 1.33 people 1.34 profilegroups 1.35 program 1.36 programgenres 1.37 programrating 1.38 recgrouppassword 1.39 record 1.40 recorded 1.41 recordedmarkup 1.42 recordingprofiles 1.43 recordoverride 1.44 settings 1.45 snessettings 1.46 transcoding 1.47 videocategory 1.48 videogenre 1.49 videometadata 1.50 videometadatacountry 1.51 videometadatagenre 1.52 videosource 1.53 videotypes 1.54 websites 2 Database 2.1 capturecard 2.2 cardinput 2.3 channel 2.4 codecparams 2.5 conflictresolutionany 2.6 conflictresolutionoverride 2.7 conflictresolutionsingle 2.8 credits 2.9 dvb_channel 2.10 dvb_pids 2.11 dvb_sat 2.12 dvb_signal_quality 2.13 dvdinput 2.14 dvdtranscode 2.15 favorites 2.16 gallerymetadata 2.17 gamemetadata 2.18 housekeeping 2.19 jumppoints 2.20 keybindings 2.21 keyword 2.22 mamemetadata 2.23 mamesettings 2.24 musicmetadata 2.25 musicplaylist 2.26 musicsmartplaylist 2.27 mythlog 2.28 neskeyword 2.29 nestitle 2.30 newssites 2.31 oldprogram 2.32 oldrecorded 2.33 people 2.34 profilegroups 2.35 program 2.36 programgenres 2.37 programrating 2.38 recgrouppassword 2.39 record 2.40 recorded 2.41 recordedmarkup 2.42 recordingprofiles 2.43 recordoverride 2.44 settings 2.45 snessettings 2.46 transcoding 2.47 videocategory 2.48 videogenre 2.49 videometadata 2.50 videometadatacountry 2.51 videometadatagenre 2.52 videosource 2.53 videotypes 2.54 websites

Database

capturecard

Field	Type	NULL	Default
cardid	int(10)	No
videodevice	varchar(128)	Yes	NULL
audiodevice	varchar(128)	Yes	NULL
vbidevice	varchar(128)	Yes	NULL
cardtype	varchar(32)	Yes	V4L
defaultinput	varchar(32)	Yes	Television
audioratelimit	int(11)	Yes	NULL
hostname	varchar(255)	Yes	NULL
dvb_swfilter	int(11)	Yes	0
dvb_recordts	int(11)	Yes	0
dvb_sat_type	int(11)	No	0
dvb_wait_for_seqstart	int(11)	No	1
dvb_dmx_buf_size	int(11)	No	8192
dvb_pkt_buf_size	int(11)	No	8192
skipbtaudio	tinyint(1)	Yes	0
dvb_on_demand	tinyint(4)	No	0

cardinput

Field	Type	NULL	Default
cardinputid	int(10)	No
cardid	int(10)	No	0
sourceid	int(10)	No	0
inputname	varchar(32)	No
externalcommand	varchar(128)	Yes	NULL
preference	int(11)	Yes	NULL
shareable	char(1)	Yes	N
tunechan	varchar(5)	No
startchan	varchar(5)	No

channel

Field	Type	NULL	Default
chanid	int(10)	No	0
channum	varchar(5)	No
freqid	varchar(5)	No
sourceid	int(10)	Yes	NULL
callsign	varchar(20)	No
name	varchar(64)	No
icon	varchar(255)	No	none
finetune	int(11)	Yes	NULL
videofilters	varchar(255)	No
xmltvid	varchar(64)	No
recpriority	int(10)	No	0
contrast	int(11)	Yes	32768
brightness	int(11)	Yes	32768
colour	int(11)	Yes	32768
hue	int(11)	Yes	32768
tvformat	varchar(10)	No	Default
commfree	tinyint(4)	No	0
visible	tinyint(1)	No	1
outputfilters	varchar(255)	No

codecparams

Field	Type	NULL	Default
profile	int(10)	No	0
name	varchar(128)	No
value	varchar(128)	Yes	NULL

conflictresolutionany

Field	Type	NULL	Default
prefertitle	varchar(128)	No
disliketitle	varchar(128)	No

conflictresolutionoverride

Field	Type	NULL	Default
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
endtime	timestamp(14)	Yes	NULL

conflictresolutionsingle

Field	Type	NULL	Default
preferchanid	int(10)	No	0
preferstarttime	timestamp(14)	Yes	NULL
preferendtime	timestamp(14)	Yes	NULL
dislikechanid	int(10)	No	0
dislikestarttime	timestamp(14)	Yes	NULL
dislikeendtime	timestamp(14)	Yes	NULL

credits

Field	Type	NULL	Default
person	mediumint(8)	No	0
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
role	set('actor', 'director', 'producer', 'executive_producer', 'writer', 'guest_star', 'host', 'adapter', 'presenter', 'commentator', 'guest')||No

dvb_channel

Field	Type	NULL	Default
chanid	smallint(6)	No	0
serviceid	smallint(6)	Yes	NULL
networkid	smallint(6)	Yes	NULL
providerid	smallint(6)	Yes	NULL
transportid	smallint(6)	Yes	NULL
frequency	int(11)	Yes	NULL
inversion	char(1)	Yes	NULL
symbolrate	int(11)	Yes	NULL
fec	varchar(10)	Yes	NULL
polarity	char(1)	Yes	NULL
satid	smallint(6)	Yes	NULL
modulation	varchar(10)	Yes	NULL
bandwidth	char(1)	Yes	NULL
lp_code_rate	varchar(10)	Yes	NULL
transmission_mode	char(1)	Yes	NULL
guard_interval	varchar(10)	Yes	NULL
hierarchy	char(1)	Yes	NULL
pmtcache	blob	Yes	NULL

dvb_pids

Field	Type	NULL	Default
chanid	smallint(6)	No	0
pid	smallint(6)	No	0
type	char(1)	No	o
lang	char(3)	No

dvb_sat

Field	Type	NULL	Default
satid	smallint(6)	No
cardid	int(11)	Yes	NULL
pos	float	Yes	NULL
name	varchar(128)	Yes	NULL
diseqc_type	smallint(6)	Yes	0
diseqc_port	smallint(6)	Yes	0
diseqc_pos	smallint(6)	Yes	0
lnb_lof_switch	int(11)	Yes	11700000
lnb_lof_hi	int(11)	Yes	10600000
lnb_lof_lo	int(11)	Yes	9750000

dvb_signal_quality

Field	Type	NULL	Default
id	int(10)	No
sampletime	timestamp(14)	Yes	NULL
cardid	int(10)	No	0
fe_snr	int(10)	No	0
fe_ss	int(10)	No	0
fe_ber	int(10)	No	0
fe_unc	int(10)	No	0
myth_cont	int(10)	No	0
myth_over	int(10)	No	0
myth_pkts	int(10)	No	0

dvdinput

Field	Type	NULL	Default
intid	int(10)	No	0
hsize	int(10)	Yes	NULL
vsize	int(10)	Yes	NULL
ar_num	int(10)	Yes	NULL
ar_denom	int(10)	Yes	NULL
fr_code	int(10)	Yes	NULL
letterbox	tinyint(1)	Yes	NULL
v_format	varchar(16)	Yes	NULL

dvdtranscode

Field	Type	NULL	Default
intid	int(11)	No
input	int(10)	Yes	NULL
name	varchar(128)	No
sync_mode	int(10)	Yes	NULL
use_yv12	tinyint(1)	Yes	NULL
cliptop	int(11)	Yes	NULL
clipbottom	int(11)	Yes	NULL
clipleft	int(11)	Yes	NULL
clipright	int(11)	Yes	NULL
f_resize_h	int(11)	Yes	NULL
f_resize_w	int(11)	Yes	NULL
hq_resize_h	int(11)	Yes	NULL
hq_resize_w	int(11)	Yes	NULL
grow_h	int(11)	Yes	NULL
grow_w	int(11)	Yes	NULL
clip2top	int(11)	Yes	NULL
clip2bottom	int(11)	Yes	NULL
clip2left	int(11)	Yes	NULL
clip2right	int(11)	Yes	NULL
codec	varchar(128)	No
codec_param	varchar(128)	Yes	NULL
bitrate	int(11)	Yes	NULL
a_sample_r	int(11)	Yes	NULL
a_bitrate	int(11)	Yes	NULL
two_pass	tinyint(1)	Yes	NULL

favorites

Field	Type	NULL	Default
favid	int(11)	No
userid	int(11)	No	0
chanid	int(11)	No	0

gallerymetadata

Field	Type	NULL	Default
image	varchar(255)	No
angle	int(11)	No	0

gamemetadata

Field	Type	NULL	Default
system	varchar(128)	No
romname	varchar(128)	No
gamename	varchar(128)	No
genre	varchar(128)	No
year	int(10)	No	0
favorite	tinyint(1)	Yes	NULL

housekeeping

Field	Type	NULL	Default
tag	varchar(64)	No
lastrun	datetime	Yes	NULL

jumppoints

Field	Type	NULL	Default
destination	varchar(128)	No
description	varchar(255)	Yes	NULL
keylist	varchar(32)	Yes	NULL
hostname	varchar(255)	No

keybindings

Field	Type	NULL	Default
context	varchar(32)	No
action	varchar(32)	No
description	varchar(255)	Yes	NULL
keylist	varchar(32)	Yes	NULL
hostname	varchar(255)	No

keyword

Field	Type	NULL	Default
phrase	varchar(128)	No

mamemetadata

Field	Type	NULL	Default
romname	varchar(128)	No
manu	varchar(128)	No
cloneof	varchar(128)	No
romof	varchar(128)	No
driver	varchar(128)	No
cpu1	varchar(128)	No
cpu2	varchar(128)	No
cpu3	varchar(128)	No
cpu4	varchar(128)	No
sound1	varchar(128)	No
sound2	varchar(128)	No
sound3	varchar(128)	No
sound4	varchar(128)	No
players	int(10)	No	0
buttons	int(10)	No	0
image_searched	tinyint(1)	No	0
rom_path	varchar(255)	No

mamesettings

Field	Type	NULL	Default
romname	varchar(128)	No
usedefault	tinyint(1)	No	0
fullscreen	tinyint(2)	No	0
scanlines	tinyint(1)	No	0
extra_artwork	tinyint(1)	No	0
autoframeskip	tinyint(1)	No	0
autocolordepth	tinyint(1)	No	0
rotleft	tinyint(1)	No	0
rotright	tinyint(1)	No	0
flipx	tinyint(1)	No	0
flipy	tinyint(1)	No	0
scale	tinyint(3)	No	0
antialias	tinyint(1)	No	0
translucency	tinyint(1)	No	0
beam	float	No	0
flicker	float	No	0
vectorres	int(11)	No	0
analogjoy	tinyint(1)	No	0
mouse	tinyint(1)	No	0
winkeys	tinyint(1)	No	0
grabmouse	tinyint(1)	No	0
joytype	tinyint(3)	No	0
sound	tinyint(1)	No	0
samples	tinyint(1)	No	0
fakesound	tinyint(1)	No	0
volume	tinyint(4)	No	0
cheat	tinyint(1)	No	0
extraoption	varchar(128)	No

musicmetadata

Field	Type	NULL	Default
intid	int(10)	No
artist	varchar(128)	No
album	varchar(128)	No
title	varchar(128)	No
genre	varchar(128)	No
year	int(10)	No	0
tracknum	int(10)	No	0
length	int(10)	No	0
filename	text	No
rating	int(10)	No	5
lastplay	timestamp(14)	Yes	NULL
playcount	int(10)	No	0

musicplaylist

Field	Type	NULL	Default
playlistid	int(10)	No
name	varchar(128)	No
hostname	varchar(255)	Yes	NULL
songlist	text	No

musicsmartplaylist

Field	Type	NULL	Default
playlistid	int(10)	No
name	varchar(128)	No
hostname	varchar(255)	Yes	NULL
songlist	text	No

mythlog

Field	Type	NULL	Default
logid	int(10)	No
module	varchar(32)	No
priority	int(11)	No	0
acknowledged	tinyint(1)	Yes	0
logdate	datetime	Yes	NULL
host	varchar(128)	Yes	NULL
message	varchar(255)	No
details	text	Yes	NULL

neskeyword

Field	Type	NULL	Default
keyword	varchar(8)	Yes	NULL
value	varchar(80)	Yes	NULL

nestitle

Field	Type	NULL	Default
id	int(11)	Yes	NULL
description	varchar(160)	Yes	NULL
designer	int(11)	Yes	NULL
publisher	int(11)	Yes	NULL
releasedate	year(4)	Yes	NULL
screenshot	int(11)	Yes	NULL
keywords	varchar(40)	Yes	NULL

newssites

Field	Type	NULL	Default
name	varchar(100)	No
category	varchar(255)	No
url	varchar(255)	No
ico	varchar(255)	Yes	NULL
updated	int(10)	Yes	NULL

oldprogram

Field	Type	NULL	Default
oldtitle	varchar(128)	No
airdate	timestamp(14)	Yes	NULL

oldrecorded

Field	Type	NULL	Default
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
endtime	timestamp(14)	Yes	NULL
title	varchar(128)	No
subtitle	varchar(128)	No
description	text	No
category	varchar(64)	No
seriesid	varchar(12)	No
programid	varchar(12)	No

people

Field	Type	NULL	Default
person	mediumint(8)	No
name	char(128)	No

profilegroups

Field	Type	NULL	Default
id	int(10)	No
name	varchar(128)	Yes	NULL
cardtype	varchar(32)	No	V4L
is_default	int(1)	Yes	0
hostname	varchar(255)	Yes	NULL

program

Field	Type	NULL	Default
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
endtime	timestamp(14)	Yes	NULL
title	varchar(128)	No
subtitle	varchar(128)	No
description	text	No
category	varchar(64)	No
category_type	varchar(64)	No
airdate	year(4)	No	0000
stars	float	No	0
previouslyshown	tinyint(4)	No	0
title_pronounce	varchar(128)	No
stereo	tinyint(1)	Yes	NULL
subtitled	tinyint(1)	Yes	NULL
hdtv	tinyint(1)	Yes	NULL
closecaptioned	tinyint(1)	Yes	NULL
partnumber	int(11)	Yes	NULL
parttotal	int(11)	Yes	NULL
seriesid	varchar(12)	No
originalairdate	date	Yes	NULL
showtype	varchar(30)	No
colorcode	varchar(20)	No
syndicatedepisodenumber	varchar(20)	No
programid	varchar(12)	No

programgenres

Field	Type	NULL	Default
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
relevance	char(1)	No
genre	char(30)	Yes	NULL

programrating

Field	Type	NULL	Default
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
system	char(8)	No
rating	char(8)	No

recgrouppassword

Field	Type	NULL	Default
recgroup	varchar(32)	No
password	varchar(10)	No

record

Field	Type	NULL	Default
recordid	int(10)	No
type	int(10)	No	0
chanid	int(10)	Yes	NULL
starttime	time	No	00:00:00
startdate	date	No	0000-00-00
endtime	time	No	00:00:00
enddate	date	No	0000-00-00
title	varchar(128)	No
subtitle	varchar(128)	No
description	text	No
category	varchar(64)	No
profile	varchar(128)	No	Default
recpriority	int(10)	No	0
autoexpire	int(11)	No	0
maxepisodes	int(11)	No	0
maxnewest	int(11)	No	0
startoffset	int(11)	No	0
endoffset	int(11)	No	0
recgroup	varchar(32)	No	Default
dupmethod	int(11)	No	6
dupin	int(11)	No	15
station	varchar(20)	No
seriesid	varchar(12)	No
programid	varchar(12)	No

recorded

Field	Type	NULL	Default
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
endtime	timestamp(14)	Yes	NULL
title	varchar(128)	No
subtitle	varchar(128)	No
description	text	No
category	varchar(64)	No
hostname	varchar(255)	No
bookmark	varchar(128)	Yes	NULL
editing	int(10)	No	0
cutlist	text	Yes	NULL
autoexpire	int(11)	No	0
commflagged	int(10)	No	0
recgroup	varchar(32)	No	Default
recordid	int(11)	Yes	NULL
seriesid	varchar(12)	No
programid	varchar(12)	No

recordedmarkup

Field	Type	NULL	Default
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
mark	bigint(20)	No	0
offset	varchar(32)	Yes	NULL
type	int(11)	No	0

recordingprofiles

Field	Type	NULL	Default
id	int(10)	No
name	varchar(128)	Yes	NULL
videocodec	varchar(128)	Yes	NULL
audiocodec	varchar(128)	Yes	NULL
profilegroup	int(10)	No	0

recordoverride

Field	Type	NULL	Default
recordid	int(10)	No	0
type	int(10)	No	0
chanid	int(10)	Yes	NULL
starttime	timestamp(14)	Yes	NULL
endtime	timestamp(14)	Yes	NULL
title	varchar(128)	Yes	NULL
subtitle	varchar(128)	Yes	NULL
description	text	Yes	NULL
station	varchar(20)	No

settings

Field	Type	NULL	Default
value	varchar(128)	No
data	text	Yes	NULL
hostname	varchar(255)	Yes	NULL

snessettings

Field	Type	NULL	Default
romname	varchar(128)	No
usedefault	tinyint(1)	No	0
transparency	tinyint(1)	No	0
sixteen	tinyint(1)	No	0
hires	tinyint(1)	No	0
interpolate	tinyint(3)	No	0
nomodeswitch	tinyint(1)	No	0
fullscreen	tinyint(1)	No	0
stretch	tinyint(1)	No	0
nosound	tinyint(1)	No	0
soundskip	tinyint(4)	No	0
stereo	tinyint(1)	No	0
soundquality	tinyint(3)	No	0
envx	tinyint(1)	No	0
threadsound	tinyint(1)	No	0
syncsound	tinyint(1)	No	0
interpolatedsound	tinyint(1)	No	0
buffersize	int(10)	No	0
nosamplecaching	tinyint(1)	No	0
altsampledecode	tinyint(1)	No	0
noecho	tinyint(1)	No	0
nomastervolume	tinyint(1)	No	0
nojoy	tinyint(1)	No	0
interleaved	tinyint(1)	No	0
altinterleaved	tinyint(1)	No	0
hirom	tinyint(1)	No	0
lowrom	tinyint(1)	No	0
header	tinyint(1)	No	0
noheader	tinyint(1)	No	0
pal	tinyint(1)	No	0
ntsc	tinyint(1)	No	0
layering	tinyint(1)	No	0
nohdma	tinyint(1)	No	0
nospeedhacks	tinyint(1)	No	0
nowindows	tinyint(1)	No	0
extraoption	varchar(128)	No

transcoding

Field	Type	NULL	Default
chanid	int(10)	Yes	NULL
starttime	timestamp(14)	Yes	NULL
status	int(11)	Yes	NULL
hostname	varchar(255)	Yes	NULL

videocategory

Field	Type	NULL	Default
intid	int(10)	No
category	varchar(128)	No

videogenre

Field	Type	NULL	Default
intid	int(10)	No
genre	varchar(128)	No

videometadata

Field	Type	NULL	Default
intid	int(10)	No
title	varchar(128)	No
director	varchar(128)	No
plot	text	Yes	NULL
rating	varchar(128)	No
inetref	varchar(32)	No
year	int(10)	No	0
userrating	float	No	0
length	int(10)	No	0
showlevel	int(10)	No	0
filename	text	No
coverfile	text	No
childid	int(11)	No	-1
browse	tinyint(1)	No	1
playcommand	varchar(255)	Yes	NULL
category	int(10)	No	0

videometadatacountry

Field	Type	NULL	Default
idvideo	int(10)	No	0
idcountry	int(10)	No	0

videometadatagenre

Field	Type	NULL	Default
idvideo	int(10)	No	0
idgenre	int(10)	No	0

videosource

Field	Type	NULL	Default
sourceid	int(10)	No
name	varchar(128)	No
xmltvgrabber	varchar(128)	Yes	NULL
userid	varchar(128)	No
freqtable	varchar(16)	No	default
lineupid	varchar(64)	Yes	NULL
password	varchar(64)	Yes	NULL

videotypes

Field	Type	NULL	Default
intid	int(10)	No
extension	varchar(128)	No
playcommand	varchar(255)	No
f_ignore	tinyint(1)	Yes	NULL
use_default	tinyint(1)	Yes	NULL

websites

Field	Type	NULL	Default
grp	varchar(255)	No
dsc	varchar(255)	Yes	NULL
url	varchar(255)	No
updated	int(10)	Yes	NULL

Here is the database schema for the CVS version of MythTV dated 5/16/2004 16:44pm

[Note: with the kind consent of Kevin Kuphal, who did all the heavy duty original keying, this page is being replaced by the pages at User Manual/[[Technical Details Appendix]]/Database Schemata, please make any necessary/desired changes there. But no, we *don't* object to hit-and-run typo corrections; that's how I got started.  :-)]

Database

capturecard

Field	Type	NULL	Default
cardid	int(10)	No
videodevice	varchar(128)	Yes	NULL
audiodevice	varchar(128)	Yes	NULL
vbidevice	varchar(128)	Yes	NULL
cardtype	varchar(32)	Yes	V4L
defaultinput	varchar(32)	Yes	Television
audioratelimit	int(11)	Yes	NULL
hostname	varchar(255)	Yes	NULL
dvb_swfilter	int(11)	Yes	0
dvb_recordts	int(11)	Yes	0
dvb_sat_type	int(11)	No	0
dvb_wait_for_seqstart	int(11)	No	1
dvb_dmx_buf_size	int(11)	No	8192
dvb_pkt_buf_size	int(11)	No	8192
skipbtaudio	tinyint(1)	Yes	0
dvb_on_demand	tinyint(4)	No	0

cardinput

Field	Type	NULL	Default
cardinputid	int(10)	No
cardid	int(10)	No	0
sourceid	int(10)	No	0
inputname	varchar(32)	No
externalcommand	varchar(128)	Yes	NULL
preference	int(11)	Yes	NULL
shareable	char(1)	Yes	N
tunechan	varchar(5)	No
startchan	varchar(5)	No

channel

Field	Type	NULL	Default
chanid	int(10)	No	0
channum	varchar(5)	No
freqid	varchar(5)	No
sourceid	int(10)	Yes	NULL
callsign	varchar(20)	No
name	varchar(64)	No
icon	varchar(255)	No	none
finetune	int(11)	Yes	NULL
videofilters	varchar(255)	No
xmltvid	varchar(64)	No
recpriority	int(10)	No	0
contrast	int(11)	Yes	32768
brightness	int(11)	Yes	32768
colour	int(11)	Yes	32768
hue	int(11)	Yes	32768
tvformat	varchar(10)	No	Default
commfree	tinyint(4)	No	0
visible	tinyint(1)	No	1
outputfilters	varchar(255)	No

codecparams

Field	Type	NULL	Default
profile	int(10)	No	0
name	varchar(128)	No
value	varchar(128)	Yes	NULL

conflictresolutionany

Field	Type	NULL	Default
prefertitle	varchar(128)	No
disliketitle	varchar(128)	No

conflictresolutionoverride

Field	Type	NULL	Default
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
endtime	timestamp(14)	Yes	NULL

conflictresolutionsingle

Field	Type	NULL	Default
preferchanid	int(10)	No	0
preferstarttime	timestamp(14)	Yes	NULL
preferendtime	timestamp(14)	Yes	NULL
dislikechanid	int(10)	No	0
dislikestarttime	timestamp(14)	Yes	NULL
dislikeendtime	timestamp(14)	Yes	NULL

credits

Field	Type	NULL	Default
person	mediumint(8)	No	0
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
role	set('actor', 'director', 'producer', 'executive_producer', 'writer', 'guest_star', 'host', 'adapter', 'presenter', 'commentator', 'guest')||No

dvb_channel

Field	Type	NULL	Default
chanid	smallint(6)	No	0
serviceid	smallint(6)	Yes	NULL
networkid	smallint(6)	Yes	NULL
providerid	smallint(6)	Yes	NULL
transportid	smallint(6)	Yes	NULL
frequency	int(11)	Yes	NULL
inversion	char(1)	Yes	NULL
symbolrate	int(11)	Yes	NULL
fec	varchar(10)	Yes	NULL
polarity	char(1)	Yes	NULL
satid	smallint(6)	Yes	NULL
modulation	varchar(10)	Yes	NULL
bandwidth	char(1)	Yes	NULL
lp_code_rate	varchar(10)	Yes	NULL
transmission_mode	char(1)	Yes	NULL
guard_interval	varchar(10)	Yes	NULL
hierarchy	char(1)	Yes	NULL
pmtcache	blob	Yes	NULL

dvb_pids

Field	Type	NULL	Default
chanid	smallint(6)	No	0
pid	smallint(6)	No	0
type	char(1)	No	o
lang	char(3)	No

dvb_sat

Field	Type	NULL	Default
satid	smallint(6)	No
cardid	int(11)	Yes	NULL
pos	float	Yes	NULL
name	varchar(128)	Yes	NULL
diseqc_type	smallint(6)	Yes	0
diseqc_port	smallint(6)	Yes	0
diseqc_pos	smallint(6)	Yes	0
lnb_lof_switch	int(11)	Yes	11700000
lnb_lof_hi	int(11)	Yes	10600000
lnb_lof_lo	int(11)	Yes	9750000

dvb_signal_quality

Field	Type	NULL	Default
id	int(10)	No
sampletime	timestamp(14)	Yes	NULL
cardid	int(10)	No	0
fe_snr	int(10)	No	0
fe_ss	int(10)	No	0
fe_ber	int(10)	No	0
fe_unc	int(10)	No	0
myth_cont	int(10)	No	0
myth_over	int(10)	No	0
myth_pkts	int(10)	No	0

dvdinput

Field	Type	NULL	Default
intid	int(10)	No	0
hsize	int(10)	Yes	NULL
vsize	int(10)	Yes	NULL
ar_num	int(10)	Yes	NULL
ar_denom	int(10)	Yes	NULL
fr_code	int(10)	Yes	NULL
letterbox	tinyint(1)	Yes	NULL
v_format	varchar(16)	Yes	NULL

dvdtranscode

Field	Type	NULL	Default
intid	int(11)	No
input	int(10)	Yes	NULL
name	varchar(128)	No
sync_mode	int(10)	Yes	NULL
use_yv12	tinyint(1)	Yes	NULL
cliptop	int(11)	Yes	NULL
clipbottom	int(11)	Yes	NULL
clipleft	int(11)	Yes	NULL
clipright	int(11)	Yes	NULL
f_resize_h	int(11)	Yes	NULL
f_resize_w	int(11)	Yes	NULL
hq_resize_h	int(11)	Yes	NULL
hq_resize_w	int(11)	Yes	NULL
grow_h	int(11)	Yes	NULL
grow_w	int(11)	Yes	NULL
clip2top	int(11)	Yes	NULL
clip2bottom	int(11)	Yes	NULL
clip2left	int(11)	Yes	NULL
clip2right	int(11)	Yes	NULL
codec	varchar(128)	No
codec_param	varchar(128)	Yes	NULL
bitrate	int(11)	Yes	NULL
a_sample_r	int(11)	Yes	NULL
a_bitrate	int(11)	Yes	NULL
two_pass	tinyint(1)	Yes	NULL

favorites

Field	Type	NULL	Default
favid	int(11)	No
userid	int(11)	No	0
chanid	int(11)	No	0

gallerymetadata

Field	Type	NULL	Default
image	varchar(255)	No
angle	int(11)	No	0

gamemetadata

Field	Type	NULL	Default
system	varchar(128)	No
romname	varchar(128)	No
gamename	varchar(128)	No
genre	varchar(128)	No
year	int(10)	No	0
favorite	tinyint(1)	Yes	NULL

housekeeping

Field	Type	NULL	Default
tag	varchar(64)	No
lastrun	datetime	Yes	NULL

jumppoints

Field	Type	NULL	Default
destination	varchar(128)	No
description	varchar(255)	Yes	NULL
keylist	varchar(32)	Yes	NULL
hostname	varchar(255)	No

keybindings

Field	Type	NULL	Default
context	varchar(32)	No
action	varchar(32)	No
description	varchar(255)	Yes	NULL
keylist	varchar(32)	Yes	NULL
hostname	varchar(255)	No

keyword

Field	Type	NULL	Default
phrase	varchar(128)	No

mamemetadata

Field	Type	NULL	Default
romname	varchar(128)	No
manu	varchar(128)	No
cloneof	varchar(128)	No
romof	varchar(128)	No
driver	varchar(128)	No
cpu1	varchar(128)	No
cpu2	varchar(128)	No
cpu3	varchar(128)	No
cpu4	varchar(128)	No
sound1	varchar(128)	No
sound2	varchar(128)	No
sound3	varchar(128)	No
sound4	varchar(128)	No
players	int(10)	No	0
buttons	int(10)	No	0
image_searched	tinyint(1)	No	0
rom_path	varchar(255)	No

mamesettings

Field	Type	NULL	Default
romname	varchar(128)	No
usedefault	tinyint(1)	No	0
fullscreen	tinyint(2)	No	0
scanlines	tinyint(1)	No	0
extra_artwork	tinyint(1)	No	0
autoframeskip	tinyint(1)	No	0
autocolordepth	tinyint(1)	No	0
rotleft	tinyint(1)	No	0
rotright	tinyint(1)	No	0
flipx	tinyint(1)	No	0
flipy	tinyint(1)	No	0
scale	tinyint(3)	No	0
antialias	tinyint(1)	No	0
translucency	tinyint(1)	No	0
beam	float	No	0
flicker	float	No	0
vectorres	int(11)	No	0
analogjoy	tinyint(1)	No	0
mouse	tinyint(1)	No	0
winkeys	tinyint(1)	No	0
grabmouse	tinyint(1)	No	0
joytype	tinyint(3)	No	0
sound	tinyint(1)	No	0
samples	tinyint(1)	No	0
fakesound	tinyint(1)	No	0
volume	tinyint(4)	No	0
cheat	tinyint(1)	No	0
extraoption	varchar(128)	No

musicmetadata

Field	Type	NULL	Default
intid	int(10)	No
artist	varchar(128)	No
album	varchar(128)	No
title	varchar(128)	No
genre	varchar(128)	No
year	int(10)	No	0
tracknum	int(10)	No	0
length	int(10)	No	0
filename	text	No
rating	int(10)	No	5
lastplay	timestamp(14)	Yes	NULL
playcount	int(10)	No	0

musicplaylist

Field	Type	NULL	Default
playlistid	int(10)	No
name	varchar(128)	No
hostname	varchar(255)	Yes	NULL
songlist	text	No

musicsmartplaylist

Field	Type	NULL	Default
playlistid	int(10)	No
name	varchar(128)	No
hostname	varchar(255)	Yes	NULL
songlist	text	No

mythlog

Field	Type	NULL	Default
logid	int(10)	No
module	varchar(32)	No
priority	int(11)	No	0
acknowledged	tinyint(1)	Yes	0
logdate	datetime	Yes	NULL
host	varchar(128)	Yes	NULL
message	varchar(255)	No
details	text	Yes	NULL

neskeyword

Field	Type	NULL	Default
keyword	varchar(8)	Yes	NULL
value	varchar(80)	Yes	NULL

nestitle

Field	Type	NULL	Default
id	int(11)	Yes	NULL
description	varchar(160)	Yes	NULL
designer	int(11)	Yes	NULL
publisher	int(11)	Yes	NULL
releasedate	year(4)	Yes	NULL
screenshot	int(11)	Yes	NULL
keywords	varchar(40)	Yes	NULL

newssites

Field	Type	NULL	Default
name	varchar(100)	No
category	varchar(255)	No
url	varchar(255)	No
ico	varchar(255)	Yes	NULL
updated	int(10)	Yes	NULL

oldprogram

Field	Type	NULL	Default
oldtitle	varchar(128)	No
airdate	timestamp(14)	Yes	NULL

oldrecorded

Field	Type	NULL	Default
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
endtime	timestamp(14)	Yes	NULL
title	varchar(128)	No
subtitle	varchar(128)	No
description	text	No
category	varchar(64)	No
seriesid	varchar(12)	No
programid	varchar(12)	No

people

Field	Type	NULL	Default
person	mediumint(8)	No
name	char(128)	No

profilegroups

Field	Type	NULL	Default
id	int(10)	No
name	varchar(128)	Yes	NULL
cardtype	varchar(32)	No	V4L
is_default	int(1)	Yes	0
hostname	varchar(255)	Yes	NULL

program

Field	Type	NULL	Default
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
endtime	timestamp(14)	Yes	NULL
title	varchar(128)	No
subtitle	varchar(128)	No
description	text	No
category	varchar(64)	No
category_type	varchar(64)	No
airdate	year(4)	No	0000
stars	float	No	0
previouslyshown	tinyint(4)	No	0
title_pronounce	varchar(128)	No
stereo	tinyint(1)	Yes	NULL
subtitled	tinyint(1)	Yes	NULL
hdtv	tinyint(1)	Yes	NULL
closecaptioned	tinyint(1)	Yes	NULL
partnumber	int(11)	Yes	NULL
parttotal	int(11)	Yes	NULL
seriesid	varchar(12)	No
originalairdate	date	Yes	NULL
showtype	varchar(30)	No
colorcode	varchar(20)	No
syndicatedepisodenumber	varchar(20)	No
programid	varchar(12)	No

programgenres

Field	Type	NULL	Default
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
relevance	char(1)	No
genre	char(30)	Yes	NULL

programrating

Field	Type	NULL	Default
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
system	char(8)	No
rating	char(8)	No

recgrouppassword

Field	Type	NULL	Default
recgroup	varchar(32)	No
password	varchar(10)	No

record

Field	Type	NULL	Default
recordid	int(10)	No
type	int(10)	No	0
chanid	int(10)	Yes	NULL
starttime	time	No	00:00:00
startdate	date	No	0000-00-00
endtime	time	No	00:00:00
enddate	date	No	0000-00-00
title	varchar(128)	No
subtitle	varchar(128)	No
description	text	No
category	varchar(64)	No
profile	varchar(128)	No	Default
recpriority	int(10)	No	0
autoexpire	int(11)	No	0
maxepisodes	int(11)	No	0
maxnewest	int(11)	No	0
startoffset	int(11)	No	0
endoffset	int(11)	No	0
recgroup	varchar(32)	No	Default
dupmethod	int(11)	No	6
dupin	int(11)	No	15
station	varchar(20)	No
seriesid	varchar(12)	No
programid	varchar(12)	No

recorded

Field	Type	NULL	Default
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
endtime	timestamp(14)	Yes	NULL
title	varchar(128)	No
subtitle	varchar(128)	No
description	text	No
category	varchar(64)	No
hostname	varchar(255)	No
bookmark	varchar(128)	Yes	NULL
editing	int(10)	No	0
cutlist	text	Yes	NULL
autoexpire	int(11)	No	0
commflagged	int(10)	No	0
recgroup	varchar(32)	No	Default
recordid	int(11)	Yes	NULL
seriesid	varchar(12)	No
programid	varchar(12)	No

recordedmarkup

Field	Type	NULL	Default
chanid	int(10)	No	0
starttime	timestamp(14)	Yes	NULL
mark	bigint(20)	No	0
offset	varchar(32)	Yes	NULL
type	int(11)	No	0

recordingprofiles

Field	Type	NULL	Default
id	int(10)	No
name	varchar(128)	Yes	NULL
videocodec	varchar(128)	Yes	NULL
audiocodec	varchar(128)	Yes	NULL
profilegroup	int(10)	No	0

recordoverride

Field	Type	NULL	Default
recordid	int(10)	No	0
type	int(10)	No	0
chanid	int(10)	Yes	NULL
starttime	timestamp(14)	Yes	NULL
endtime	timestamp(14)	Yes	NULL
title	varchar(128)	Yes	NULL
subtitle	varchar(128)	Yes	NULL
description	text	Yes	NULL
station	varchar(20)	No

settings

Field	Type	NULL	Default
value	varchar(128)	No
data	text	Yes	NULL
hostname	varchar(255)	Yes	NULL

snessettings

Field	Type	NULL	Default
romname	varchar(128)	No
usedefault	tinyint(1)	No	0
transparency	tinyint(1)	No	0
sixteen	tinyint(1)	No	0
hires	tinyint(1)	No	0
interpolate	tinyint(3)	No	0
nomodeswitch	tinyint(1)	No	0
fullscreen	tinyint(1)	No	0
stretch	tinyint(1)	No	0
nosound	tinyint(1)	No	0
soundskip	tinyint(4)	No	0
stereo	tinyint(1)	No	0
soundquality	tinyint(3)	No	0
envx	tinyint(1)	No	0
threadsound	tinyint(1)	No	0
syncsound	tinyint(1)	No	0
interpolatedsound	tinyint(1)	No	0
buffersize	int(10)	No	0
nosamplecaching	tinyint(1)	No	0
altsampledecode	tinyint(1)	No	0
noecho	tinyint(1)	No	0
nomastervolume	tinyint(1)	No	0
nojoy	tinyint(1)	No	0
interleaved	tinyint(1)	No	0
altinterleaved	tinyint(1)	No	0
hirom	tinyint(1)	No	0
lowrom	tinyint(1)	No	0
header	tinyint(1)	No	0
noheader	tinyint(1)	No	0
pal	tinyint(1)	No	0
ntsc	tinyint(1)	No	0
layering	tinyint(1)	No	0
nohdma	tinyint(1)	No	0
nospeedhacks	tinyint(1)	No	0
nowindows	tinyint(1)	No	0
extraoption	varchar(128)	No

transcoding

Field	Type	NULL	Default
chanid	int(10)	Yes	NULL
starttime	timestamp(14)	Yes	NULL
status	int(11)	Yes	NULL
hostname	varchar(255)	Yes	NULL

videocategory

Field	Type	NULL	Default
intid	int(10)	No
category	varchar(128)	No

videogenre

Field	Type	NULL	Default
intid	int(10)	No
genre	varchar(128)	No

videometadata

Field	Type	NULL	Default
intid	int(10)	No
title	varchar(128)	No
director	varchar(128)	No
plot	text	Yes	NULL
rating	varchar(128)	No
inetref	varchar(32)	No
year	int(10)	No	0
userrating	float	No	0
length	int(10)	No	0
showlevel	int(10)	No	0
filename	text	No
coverfile	text	No
childid	int(11)	No	-1
browse	tinyint(1)	No	1
playcommand	varchar(255)	Yes	NULL
category	int(10)	No	0

videometadatacountry

Field	Type	NULL	Default
idvideo	int(10)	No	0
idcountry	int(10)	No	0

videometadatagenre

Field	Type	NULL	Default
idvideo	int(10)	No	0
idgenre	int(10)	No	0

videosource

<

Field	Type	NULL	Default
sourceid	int(10)	No
name	varchar(128)	No
xmltvgrabber	varchar(128)	Yes	NULL
userid	varchar(128)	No
freqtable	varchar(16)	No	default
lineupid	varchar(64)	Yes	NULL
password	varchar(64)	Yes	NULL