Difference between revisions of "Favorites table"

Latest revision as of 20:58, 22 February 2014

Note: The correct title of this article is favorites table. It appears incorrectly here due to technical restrictions.

The favourites table contains a list of user defined favorite channels which may be displayed in the EPG.

16:17, 22 February 2014 (UTC)I think this table is obsolete as of MythTV-0.27 and replaced by channelgroupnames table.

Field name	Type	Null	Key	Default	Extras
favid	int(11) unsigned	NO	PRI	NULL	auto_increment
userid	int(11) unsigned	NO		0
chanid	int(11) unsigned	NO		0	REFERENCES channel(chanid)

@@ Line 1: / Line 1: @@
-The '''favourites table''' can contain a list of favourite channels which may be displayed in the [[EPG]].
+{{Wrongtitle|favorites table}}
-[[Category:DB Table]]
+The '''favourites table''' contains a list of user defined favorite channels which may be displayed in the [[EPG]].
+:17, 22 February 2014 (UTC)I think this table is obsolete as of MythTV-0.27 and replaced by [[channelgroupnames table]].
+== Table Description ==
+{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
+|- style="background: lightsteelblue"
+!  Field name !! Type             !! Null !! Key !! Default !! Extras
+|-
+|| favid  || int(11) unsigned || NO   || PRI || NULL    || auto_increment
+|-
+|| userid || int(11) unsigned || NO   ||     || 0       ||
+|-
+|| chanid || int(11) unsigned || NO   ||     || 0       || REFERENCES [[channel table|channel]](chanid)
+|-
+|}
+== Fields ==
+*'''favid''' is a unique identifier for the entries in the table.
+*'''chanid''' relates to the ''chanid'' field of the [[channel table]].
+[[Category:Unused DB Table]]