Difference between revisions of "Keyword table"

From MythTV Official Wiki
Jump to: navigation, search
(Added to Category:DB Table)
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
{{Wrongtitle|keyword table}}
 
The '''keyword table''' contains a cache of search phrases that have been used to find shows using [[mythfrontend]].
 
The '''keyword table''' contains a cache of search phrases that have been used to find shows using [[mythfrontend]].
 +
== 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
 +
|-
 +
|| phrase      || varchar(128)    ||      || PRI ||        ||
 +
|-
 +
|| searchtype  || int(10) unsigned ||      || PRI || 3      ||
 +
|-
 +
|}
 +
 +
== Fields ==
 +
*'''phrase''' is the text that was searched for.
 +
**For the ''ADVANCED'' search type this field consists of 6 values separated by colons: ''TITLE'':''SUBTITLE'':''DESCRIPTION'':''PROGRAM TYPE'':''GENRE'':''STATION''
 +
*'''searchtype''' is the type of search that was performed.
 +
**''ADVANCED''=1, ''TITLE''=2, ''KEYWORD''=3, ''PEOPLE''=4,
 +
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Latest revision as of 21:30, 13 March 2007

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

The keyword table contains a cache of search phrases that have been used to find shows using mythfrontend.

Table Description

Field name Type Null Key Default Extras
phrase varchar(128) PRI
searchtype int(10) unsigned PRI 3

Fields

  • phrase is the text that was searched for.
    • For the ADVANCED search type this field consists of 6 values separated by colons: TITLE:SUBTITLE:DESCRIPTION:PROGRAM TYPE:GENRE:STATION
  • searchtype is the type of search that was performed.
    • ADVANCED=1, TITLE=2, KEYWORD=3, PEOPLE=4,