Difference between revisions of "Keyword table"
From MythTV Official Wiki
(One intermediate revision 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" | |
− | {| border=1 style="background:# | + | ! Field name !! Type !! Null !! Key !! Default !! Extras |
− | !Field | ||
|- | |- | ||
|| phrase || varchar(128) || || PRI || || | || 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
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,