// --------------------------------------------------------------------------
//
// Table Dictionary for EPG Daemon and related Plugins
//
// --------------------------------------------------------------------------
// See the README file for copyright information and how to reach the author
// --------------------------------------------------------------------------

// ----------------------------------------------------------------
// Table Events
// ----------------------------------------------------------------

Table events
{
   EVENTID              ""                                                   eventid              UBigInt      0 Primary,
   CHANNELID            ""                                                   channelid            Ascii       50 Primary,

   MASTERID             ""                                                   masterid             UInt         0 Autoinc,
   USEID                ""                                                   useid                UInt         0 Data,

   SOURCE               ""                                                   source               Ascii       10 Meta,
   FILEREF              ""                                                   fileref              Ascii      100 Meta,
   INSSP                ""                                                   inssp                Int         10 Meta,
   UPDSP                ""                                                   updsp                Int         10 Meta,
   UPDFLG               ""                                                   updflg               Ascii        1 Meta,
   DELFLG               ""                                                   delflg               Ascii        1 Meta,

   TABLEID              ""                                                   tableid              Int          2 Data,
   VERSION              ""                                                   version              Int          3 Data,
   TITLE                ""                                                   title                Ascii      200 Data,
   COMPTITLE            ""                                                   comptitle            Ascii      200 Data,
   SHORTTEXT            ""                                                   shorttext            Ascii      300 Data,
   COMPSHORTTEXT        ""                                                   compshorttext        Ascii      300 Data,
   LONGDESCRIPTION      ""                                                   longdescription      MText    25000 Data,
   COMPLONGDESCRIPTION  ""                                                   complongdescription  MText    25000 Data filter epgd|httpd|epg2vdr,
   STARTTIME            ""                                                   starttime            Int         10 Data,
   DURATION             ""                                                   duration             Int          5 Data,
   PARENTALRATING       ""                                                   parentalrating       Int          2 Data,
   VPS                  ""                                                   vps                  Int         10 Data,
   CONTENTS             "Genre code like table 28 of ETSI EN 300 468"        contents             ASCII      100 Data filter epgd|httpd|epg2vdr,
   SHORTDESCRIPTION     ""                                                   shortdescription     MText     3000 Data,
   ACTOR                ""                                                   actor                MText     5000 Data,
   AUDIO                ""                                                   audio                Ascii       50 Data,
   CATEGORY             ""                                                   category             Ascii       50 Data,
   COUNTRY              ""                                                   country              Ascii       50 Data,
   DIRECTOR             ""                                                   director             Text      1000 Data,
   COMMENTATOR          ""                                                   commentator          Ascii      200 Data,
   FLAGS                ""                                                   flags                Ascii      100 Data,
   GENRE                ""                                                   genre                Ascii      100 Data,
   MUSIC                ""                                                   music                Ascii      250 Data,
   PRODUCER             ""                                                   producer             Text      1000 Data,
   SCREENPLAY           ""                                                   screenplay           Ascii      500 Data,
   SHORTREVIEW          ""                                                   shortreview          Ascii      500 Data,
   TIPP                 ""                                                   tipp                 Ascii      250 Data,
   TOPIC                ""                                                   topic                Ascii     1000 Data,
   YEAR                 ""                                                   year                 Ascii       10 Data,
   RATING               ""                                                   rating               Ascii      250 Data,
   NUMRATING            ""                                                   numrating            Int          2 Data filter epgd|httpd|epg2vdr,
   TXTRATING            ""                                                   txtrating            Ascii      100 Data,
   MOVIEID              ""                                                   movieid              Ascii       20 Data,
   MODERATOR            ""                                                   moderator            Ascii      250 Data,
   OTHER                ""                                                   other                Text      2000 Data,
   GUEST                ""                                                   guest                Text      1000 Data,
   CAMERA               ""                                                   camera               Text      1000 Data,
   EXTEPNUM             ""                                                   extepnum             Int          4 Data,
   IMAGECOUNT           ""                                                   imagecount           Int          2 Data,

   EPISODECOMPNAME      ""                                                   episodecompname      Ascii      100 Data filter epgd|httpd|epg2vdr,
   EPISODECOMPSHORTNAME ""                                                   episodecompshortname Ascii      100 Data filter epgd|httpd|epg2vdr,
   EPISODECOMPPARTNAME  ""                                                   episodecomppartname  Ascii      200 Data filter epgd|httpd|epg2vdr,
   EPISODELANG          ""                                                   episodelang          Ascii       10 Data filter epgd|httpd|epg2vdr,

   SCRSERIESID          ""                                                   scrseriesid          Int          0 Data,
   SCRSERIESEPISODE     ""                                                   scrseriesepisode     Int          0 Data,
   SCRMOVIEID           ""                                                   scrmovieid           Int          0 Data,
   SCRSP                ""                                                   scrsp                Int          0 Data,
}

// ----------------------------------------------------------------
// Indices for Events
// ----------------------------------------------------------------

Index events
{
   comptitle            ""  COMPTITLE,
   source               ""  SOURCE,
   filerefsource        ""  FILEREF SOURCE,
   channelid            ""  CHANNELID,
   useid                ""  USEID,
   useidchannelid       ""  USEID CHANNELID,
   updflgupdsp          ""  UPDFLG UPDSP,
   sourcechannelid      ""  SOURCE CHANNELID,
   scrsp                ""  SCRSP,
   sourceupdsp          ""  SOURCE UPDSP,
   scrseriesid          ""  SCRSERIESID,
   channelidstarttime   ""  CHANNELID STARTTIME,
}

// ----------------------------------------------------------------
// Table Components
// ----------------------------------------------------------------

Table components
{
   EVENTID              ""  eventid              UBigInt      0 Primary,
   CHANNELID            ""  channelid            Ascii       50 Primary,
   STREAM               ""  stream               Int          3 Primary,
   TYPE                 ""  type                 Int          3 Primary,
   LANG                 ""  lang                 Ascii        8 Primary,
   DESCRIPTION          ""  description          Ascii      100 Primary,
   INSSP                ""  inssp                Int          0 Meta,
   UPDSP                ""  updsp                Int          0 Meta,
}

// ----------------------------------------------------------------
// Table FileRef
// ----------------------------------------------------------------

Table fileref
{
   NAME                 ""  name                 Ascii      100 Primary,
   SOURCE               ""  source               Ascii       10 Primary,
   INSSP                ""  inssp                Int          0 Meta,
   UPDSP                ""  updsp                Int          0 Meta,
   EXTERNALID           ""  extid                Ascii       10 Data,
   FILEREF              ""  fileref              Ascii      100 Data,
   TAG                  ""  tag                  Ascii      100 Data,
}

// ----------------------------------------------------------------
// Indices for FileRefs
// ----------------------------------------------------------------

Index filerefs
{
   SourceFileref        ""  SOURCE FILEREF,
   Fileref              ""  FILEREF,
}

// ----------------------------------------------------------------
// Table ImageRefs
// ----------------------------------------------------------------

Table imagerefs
{
   EVENTID              ""  eventid              UBigInt      0 Primary,
   LFN                  ""  lfn                  Int          0 Primary,
   INSSP                ""  inssp                Int          0 Meta,
   UPDSP                ""  updsp                Int          0 Meta,
   SOURCE               ""  source               Ascii       10 Meta,
   FILEREF              ""  fileref              Ascii      100 Data,
   IMGNAME              ""  imagename            Ascii      100 Data,
}

// ----------------------------------------------------------------
// Indices for ImageRefs
// ----------------------------------------------------------------

Index imagerefs
{
   lfn                  ""  LFN,
   name                 ""  IMGNAME,
}

// ----------------------------------------------------------------
// Table Images
// ----------------------------------------------------------------

Table images
{
   IMGNAME              ""  imagename            Ascii      100 Primary,
   INSSP                ""  inssp                Int          0 Meta,
   UPDSP                ""  updsp                Int          0 Meta,
   IMAGE                ""  image                Mlob    512000 Data,
}

// ----------------------------------------------------------------
// Table Episodes
// ----------------------------------------------------------------

Table episodes
{
   COMPNAME             ""  compname             Ascii      100 Primary,
   COMPPARTNAME         ""  comppartname         Ascii      200 Primary,
   LANG                 ""  lang                 Ascii       10 Primary,

   INSSP                ""  inssp                Int          0 Meta,
   UPDSP                ""  updsp                Int          0 Meta,

   LINK                 ""  link                 Int          0 Data,
   SHORTNAME            ""  shortname            Ascii      100 Data,
   COMPSHORTNAME        ""  compshortname        Ascii      100 Data,
   EPISODENAME          ""  episodename          Ascii      100 Data,
   PARTNAME             ""  partname             Ascii      300 Data,
   SEASON               ""  season               Int          0 Data,
   PART                 ""  part                 Int          0 Data,
   PARTS                ""  parts                Int          0 Data,
   NUMBER               ""  number               Int          0 Data,
   EXTRACOL1            ""  extracol1            Ascii      250 Data,
   EXTRACOL2            ""  extracol2            Ascii      250 Data,
   EXTRACOL3            ""  extracol3            Ascii      250 Data,
   COMMENT              ""  comment              Ascii      250 Data,
}

// ----------------------------------------------------------------
// Indices for Episodes
// ----------------------------------------------------------------

Index episodes
{
   updsp                ""  UPDSP,
}

// ----------------------------------------------------------------
// Table ChannelMap
// ----------------------------------------------------------------

Table channelmap
{
   EXTERNALID           ""  extid                Ascii       10 Primary,
   CHANNELID            ""  channelid            Ascii       50 Primary,
   SOURCE               ""  source               Ascii       20 Primary,

   ORDER                ""  ord                  Int          0 Data,
   VISIBLE              ""  visible              Int          0 Data,
   CHANNELNAME          ""  channelname          Ascii      100 Data,
   VPS                  ""  vps                  Int          0 Data,
   FORMAT               ""  format               Ascii       50 Data,
   UNKNOWNATVDR         ""  unknownatvdr         UInt         1 Data,
   MERGE                ""  merge                Int          0 Data,
   MERGESP              ""  mergesp              Int          0 Data,
   INSSP                ""  inssp                Int          0 Meta,
   UPDSP                ""  updsp                Int          0 Meta,
   UPDFLG               ""  updflg               Ascii        1 Meta,
}

// ----------------------------------------------------------------
// Indices for ChannelMap
// ----------------------------------------------------------------

Index channelmap
{
   sourceExtid          ""  SOURCE EXTERNALID,
   source               ""  SOURCE,
   updflg               ""  UPDFLG,
   sourcechannelid      ""  SOURCE CHANNELID,
   mergesp              ""  MERGESP,
   channelid            ""  CHANNELID,
}

// ----------------------------------------------------------------
// Table Vdrs
// ----------------------------------------------------------------

Table vdrs
{
   UUID                 ""  uuid                 Ascii       40 Primary,

   INSSP                ""  inssp                Int          0 Meta,
   UPDSP                ""  updsp                Int          0 Meta,

   NAME                 ""  name                 Ascii      100 Data,
   VERSION              ""  version              Ascii      100 Data,
   DBAPI                ""  dbapi                UInt         0 Data,
   LASTUPDATE           ""  lastupd              Int          0 Data,
   NEXTUPDATE           ""  nextupd              Int          0 Data,
   LASTMERGE            ""  lastmerge            Int          0 Data,
   STATE                ""  state                Ascii       20 Data,
   MASTER               ""  master               Ascii        1 Data,
   IP                   ""  ip                   Ascii       20 Data,
   MAC                  ""  mac                  Ascii       18 Data,
   PID                  ""  pid                  UInt         0 Data filter epgd|httpd|epg2vdr,
   SVDRP                ""  svdrp                UInt         0 Data filter epgd|httpd|epg2vdr,
   OSD2WEBP             ""  osd2webp             UInt         0 Data,
   TUNERCOUNT           ""  tunercount           UInt         0 Data filter epgd|httpd|epg2vdr,

   SHAREINWEB           ""  shareinweb           UInt         1 Data,
   USECOMMONRECFOLDER   ""  usecommonrecfolder   UInt         1 Data,

   VIDEODIR             ""  videodir             Ascii      300 Data,
   VIDEOTOTAL           ""  videototal           UInt         0 Data,
   VIDEOFREE            ""  videofree            UInt         0 Data,
}

// ----------------------------------------------------------------
// Indices for Vdrs
// ----------------------------------------------------------------

Index vdrs
{
   state                ""  STATE,
}

// ----------------------------------------------------------------
// Table Users
// ----------------------------------------------------------------

Table users
{
   USER                 ""                           user      Ascii   40 Primary,

   INSSP                ""                           inssp     Int      0 Meta,
   UPDSP                ""                           updsp     Int      0 Meta,

   PASSWD               ""                           passwd    Ascii  100 Data,
   ACTIVE               ""                           active    Int      1 Data,
   RIGHTS               ""                           rights    UInt     0 Data,
}

// ----------------------------------------------------------------
// Table Parameters
// ----------------------------------------------------------------

Table parameters
{
   OWNER                ""                                     owner    Ascii     40 Primary,
   NAME                 ""                                     name     Ascii     40 Primary,
   INSSP                ""                                     inssp    Int        0 Meta,
   UPDSP                ""                                     updsp    Int        0 Meta,
   VALUE                ""                                     value    Ascii    500 Data,
}

// ----------------------------------------------------------------
// Table Analyse
// ----------------------------------------------------------------

Table analyse
{
   CHANNELID            ""  channelid            Ascii       50 Primary,
   VDRMASTERID          ""  vdr_masterid         UInt         0 Data,
   VDREVENTID           ""  vdr_eventid          UBigInt      0 Primary,
   VDRSTARTTIME         ""  vdr_starttime        Int         10 Data,
   VDRDURATION          ""  vdr_duration         Int          5 Data,
   VDRTITLE             ""  vdr_title            Ascii      200 Data,
   VDRSHORTTEXT         ""  vdr_shorttext        Ascii      300 Data,
   EXTMASTERID          ""  ext_masterid         UInt         0 Data,
   EXTEVENTID           ""  ext_eventid          UBigInt       0 Data,
   EXTSTARTTIME         ""  ext_starttime        Int         10 Data,
   EXTDURATION          ""  ext_duration         Int          5 Data,
   EXTTITLE             ""  ext_title            Ascii      200 Data,
   EXTSHORTTEXT         ""  ext_shorttext        Ascii      300 Data,
   EXTEPISODE           ""  ext_episode          Ascii        1 Data,
   EXTMERGE             ""  ext_merge            Int         11 Data,
   EXIIMAGES            ""  ext_images           Ascii        1 Data,
   LVMIN                ""  lvmin                Int          3 Data,
   RANK                 ""  rank                 Int          5 Data,
}

// ----------------------------------------------------------------
// Indices for Analyse
// ----------------------------------------------------------------

Index analyse
{
   vdr_masterid         ""  VDRMASTERID,
}

// ----------------------------------------------------------------
// Table Snapshot
// ----------------------------------------------------------------

Table snapshot
{
   CHANNELID            ""  channelid            Ascii       50 Data,
   SOURCE               ""  source               Ascii       10 Data,
   VDRMASTERID          ""  masterid             UInt         0 Data,
   EVENTID              ""  eventid              UBigInt      0 Data,
   USEID                ""  useid                UInt         0 Data,
   STARTTIME            ""  starttime            Int         10 Data,
   DURATION             ""  duration             Int          5 Data,
   TITLE                ""  title                Ascii      200 Data,
   COMPTITLE            ""  comptitle            Ascii      200 Data,
   SHORTTEXT            ""  shorttext            Ascii      300 Data,
   COMPSHORTTEXT        ""  compshorttext        Ascii      300 Data,
   UPDSP                ""  updsp                Int         10 Data,
   EPISODE              ""  episode              Ascii        1 Data,
   MERGE                ""  merge                Int          0 Data,
   IMAGES               ""  images               Ascii        1 Data,
}

// ----------------------------------------------------------------
// Indices for Snapshot
// ----------------------------------------------------------------

Index snapshot
{
   channelid            ""  CHANNELID,
   starttimeSource      ""  STARTTIME SOURCE,
}

// ----------------------------------------------------------------
// Table UseEvents
// ----------------------------------------------------------------

Table useevents
{
   CNTSOURCE               ""                                               cnt_source                    Ascii     10 Primary,
   CHANNELID               ""                                               cnt_channelid                 Ascii     50 Primary,
   CNTEVENTID              ""                                               cnt_eventid                   UBigInt    0 Primary|Meta,

   MASTERID                ""                                               cnt_masterid                  UInt       0 Data|Meta,
   USEID                   ""                                               cnt_useid                     UInt       0 Data,
// SOURCE                  ""                                               source                        Ascii     25 Data

   SUBSOURCE               ""                                               sub_source                    Ascii     10 Data|Meta,
   SUBEVENTID              ""                                               sub_eventid                   UBigInt    0 Data|Meta,
   UPDSP                   ""                                               all_updsp                     Int        0 Data,
   UPDFLG                  ""                                               cnt_updflg                    Ascii      1 Data|Meta,
   DELFLG                  ""                                               cnt_delflg                    Ascii      1 Data,
   FILEREF                 ""                                               cnt_fileref                   Ascii    100 Data,
   TABLEID                 ""                                               cnt_tableid                   Int        2 Data,
   VERSION                 ""                                               cnt_version                   Int        3 Data,
   TITLE                   ""                                               sub_title                     Ascii    200 Data,
   SHORTTEXT               ""                                               sub_shorttext                 Ascii    300 Data,
   COMPTITLE               ""                                               sub_comptitle                 Ascii    200 Data,
   COMPSHORTTEXT           ""                                               sub_compshorttext             Ascii    300 Data,
   GENRE                   ""                                               sub_genre                     Ascii    100 Data,
   COUNTRY                 ""                                               sub_country                   Ascii     50 Data,
   YEAR                    ""                                               sub_year                      Ascii     10 Data,
   STARTTIME               ""                                               cnt_starttime                 Int       10 Data,
   DURATION                ""                                               cnt_duration                  Int        5 Data,
   PARENTALRATING          ""                                               cnt_parentalrating            Int        2 Data,
   VPS                     ""                                               cnt_vps                       Int       10 Data,
   CONTENTS                "Genre code like table 28 of ETSI EN 300 468"    cnt_contents                  ASCII    100 Data,
   CATEGORY                ""                                               sub_category                  Ascii     50 Data,
   SHORTDESCRIPTION        ""                                               sub_shortdescription          MText   3000 Data,
   SHORTREVIEW             ""                                               sub_shortreview               Ascii    500 Data,
   TIPP                    ""                                               sub_tipp                      Ascii    250 Data,
   RATING                  ""                                               sub_rating                    Ascii    250 Data,
   NUMRATING               ""                                               sub_numrating                 Int        2 Data,
   TXTRATING               ""                                               sub_txtrating                 Ascii    100 Data,
   TOPIC                   ""                                               sub_topic                     Ascii   1000 Data,
   LONGDESCRIPTION         ""                                               sub_longdescription           MText  25000 Data,
   COMPLONGDESCRIPTION     ""                                               sub_complongdescription       MText  25000 Data,
   CNTLONGDESCRIPTION      ""                                               cnt_longdescription           MText  25000 Data,
   MODERATOR               ""                                               sub_moderator                 Ascii    250 Data,
   GUEST                   ""                                               sub_guest                     Text    1000 Data,
   ACTOR                   ""                                               sub_actor                     MText   5000 Data,
   PRODUCER                ""                                               sub_producer                  Text    1000 Data,
   OTHER                   ""                                               sub_other                     Text    2000 Data,
   DIRECTOR                ""                                               sub_director                  Text    1000 Data,
   COMMENTATOR            ""                                                sub_commentator               Ascii    200 Data,
   SCREENPLAY              ""                                               sub_screenplay                Ascii    500 Data,
   CAMERA                  ""                                               sub_camera                    Text    1000 Data,
   MUSIC                   ""                                               sub_music                     Ascii    250 Data,
   AUDIO                   ""                                               sub_audio                     Ascii     50 Data,
   FLAGS                   ""                                               sub_flags                     Ascii    100 Data,
   IMAGECOUNT              ""                                               sub_imagecount                Int        2 Data,

   SCRSERIESID             ""                                               sub_scrseriesid               Int        0 Data,
   SCRSERIESEPISODE        ""                                               sub_scrseriesepisode          Int        0 Data,
   SCRMOVIEID              ""                                               sub_scrmovieid                Int        0 Data,
   SCRSP                   ""                                               sub_scrsp                     Int        0 Data|Meta,

   EPISODECOMPNAME         ""                                               sub_episodecompname           Ascii    100 Data,
   EPISODECOMPSHORTNAME    ""                                               sub_episodecompshortname      Ascii    100 Data,
   EPISODECOMPPARTNAME     ""                                               sub_episodecomppartname       Ascii    200 Data,

   EPISODENAME             ""                                               epi_episodename               Ascii    100 Data,
   EPISODESHORTNAME        ""                                               epi_shortname                 Ascii    100 Data,
   EPISODEPARTNAME         ""                                               epi_partname                  Ascii    300 Data,
   EPISODELANG             ""                                               epi_lang                      Ascii     10 Data,
   EPISODEEXTRACOL1        ""                                               epi_extracol1                 Ascii    250 Data,
   EPISODEEXTRACOL2        ""                                               epi_extracol2                 Ascii    250 Data,
   EPISODEEXTRACOL3        ""                                               epi_extracol3                 Ascii    250 Data,
   EPISODESEASON           ""                                               epi_season                    Int        0 Data,
   EPISODEPART             ""                                               epi_part                      Int        0 Data,
   EPISODEPARTS            ""                                               epi_parts                     Int        0 Data,
   EPISODENUMBER           ""                                               epi_number                    Int        0 Data,
}

// ----------------------------------------------------------------
// Indices for UseEvents
// ----------------------------------------------------------------

Index useevents
{
   channelidstarttime       ""  CHANNELID STARTTIME,
   useid                    ""  USEID,
   channelidupdflgupdsp     ""  CHANNELID UPDFLG UPDSP,
   channelid                ""  CHANNELID,
   updflgstarttimeduration  ""  UPDSP STARTTIME DURATION,
}

// ----------------------------------------------------------------
// Table Recording List
// ----------------------------------------------------------------

Table recordinglist
{
   MD5PATH              ""            md5path          Ascii       40 Primary,
   STARTTIME            ""            starttime        UInt         0 Primary,
   OWNER                "uuid of vdr" owner            Ascii       40 Primary,

   INSSP                ""            inssp            Int         10 Meta,
   UPDSP                ""            updsp            Int         10 Meta,
   LASTIFOUPD           ""            lastifoupd       Int         10 Meta,

   VDRUUID              ""            vdruuid          Ascii       40 Data,
   PATH                 ""            path             Ascii     1000 Data,
   NAME                 ""            name             Ascii     1000 Data,
   FOLDER               ""            folder           Ascii     1000 Data,
   TITLE                ""            title            Ascii      200 Data,
   SHORTTEXT            ""            shorttext        Ascii      300 Data,
   LONGDESCRIPTION      ""            longdescription  MText    25000 Data,
   DURATION             ""            duration         UInt         0 Data,
   FSK                  ""            fsk              UInt         1 Data,

   EVENTID              "useid"       eventid          UInt         0 Data,
   CHANNELID            ""            channelid        Ascii       50 Data,
   CHANNELNAME          "just a copy" channelname      Ascii      100 Data,

   STATE                ""            state            Ascii        1 Data,
   INUSE                ""            inuse            UInt         1 Data,
   JOB                  ""            job              Ascii        1 Data,

   // enriched by 'external' data of events

   ACTOR                ""            actor           MText     5000 Data,
   AUDIO                ""            audio           Ascii       50 Data,
   CATEGORY             ""            category        Ascii       50 Data,
   COUNTRY              ""            country         Ascii       50 Data,
   DIRECTOR             ""            director        Text      1000 Data,
   FLAGS                ""            flags           Ascii      100 Data,
   GENRE                ""            genre           Ascii      100 Data,
   MUSIC                ""            music           Ascii      250 Data,
   PRODUCER             ""            producer        Text      1000 Data,
   SCREENPLAY           ""            screenplay      Ascii      500 Data,
   SHORTREVIEW          ""            shortreview     Ascii      500 Data,
   TIPP                 ""            tipp            Ascii      250 Data,
   TOPIC                ""            topic           Ascii     1000 Data,
   YEAR                 ""            year            Ascii       10 Data,
   RATING               ""            rating          Ascii      250 Data,
   NUMRATING            ""            numrating       Int          2 Data,
   TXTRATING            ""            txtrating       Ascii      100 Data,
   MODERATOR            ""            moderator       Ascii      250 Data,
   OTHER                ""            other           Text      2000 Data,
   GUEST                ""            guest           Text      1000 Data,
   CAMERA               ""            camera          Text      1000 Data,

   // episode reference

   EPISODECOMPNAME      ""            episodecompname      Ascii      100 Data filter epgd|httpd|epg2vdr,
   EPISODECOMPSHORTNAME ""            episodecompshortname Ascii      100 Data filter epgd|httpd|epg2vdr,
   EPISODECOMPPARTNAME  ""            episodecomppartname  Ascii      200 Data filter epgd|httpd|epg2vdr,
   EPISODELANG          ""            episodelang          Ascii       10 Data filter epgd|httpd|epg2vdr,

   // scraper fields
   // IDs found while scraping (reference to scraper tables), managed by epgd

   SCRSERIESID          ""            scrseriesid       UInt         0 Data,
   SCRSERIESEPISODE     ""            scrseriesepisode  UInt         0 Data,
   SCRMOVIEID           ""            scrmovieid        UInt         0 Data,

   // this fields are written by the scraper plugin,
   //    the id fields hold the user hint for scraping

   SCRINFOMOVIEID       ""            scrinfomovieid    UInt         0 Data,
   SCRINFOSERIESID      ""            scrinfoseriesid   UInt         0 Data,
   SCRINFOEPISODEID     ""            scrinfoepisodeid  UInt         0 Data,

   SCRNEW               ""            scrnew            UInt         0 Data,
   SCRSP                ""            scrsp             Int          0 Data,
}

// ----------------------------------------------------------------
// Table RecordingDirs
// ----------------------------------------------------------------

Table recordingdirs
{
   VDRUUID              ""  vdruuid              Ascii       40 Primary,
   DIRECTORY            ""  directory            Ascii      255 Primary,

   INSSP                ""  inssp                Int          0 Meta,
   UPDSP                ""  updsp                Int          0 Meta,
}

// ----------------------------------------------------------------
// Table Timers
// ----------------------------------------------------------------

Table timers
{
   ID                   ""                                       id                   UInt         0 Primary|Autoinc,
   VDRUUID              ""                                       vdruuid              Ascii       40 Primary,

   INSSP                ""                                       inssp                Int          0 Meta,
   UPDSP                ""                                       updsp                Int          0 Meta,

   EVENTID              "useid"                                  eventid              UInt         0 Data,
   CHANNELID            ""                                       channelid            Ascii       50 Data,
   _STARTTIME           "pre filled start timer for trigger"     _starttime           Int         10 Data,

   SOURCE               "like  osd, webif, epgd"                 source               Ascii       40 Data,
   TYPE                 "'R'ecord, 'V'iew (umschalt)"            type                 Ascii        1 Data,
   STATE                "'D'eleted, 'R'unning, 'F'inished"       state                Ascii        1 Data default u,
   INFO                 "error reason if state is failed"        info                 Ascii      255 Data,
   ACTION               ""                                       action               Ascii        1 Data default a,
   TCCMAILCNT           ""                                       tccmailcnt           UInt         0 Data,
   WRNCOUNT             ""                                       wrncount             UInt         0 Data,
   RETRYS               ""                                       retrys               UInt         0 Data,

   NAMINGMODE           ""                                       namingmode           Int          0 Data,
   TEMPLATE             ""                                       template             Ascii      100 Data,
   ACTIVE               ""                                       active               UInt         0 Data,
   DAY                  ""                                       day                  Int         10 Data,
   WEEKDAYS             ""                                       weekdays             Int         10 Data,
   STARTTIME            ""                                       starttime            Int         10 Data,
   ENDTIME              ""                                       endtime              Int         10 Data,
   FILE                 ""                                       file                 Ascii      512 Data,
   DIRECTORY            ""                                       directory            Ascii      512 Data,

   PRIORITY             ""                                       priority             Int          0 Data,
   LIFETIME             ""                                       lifetime             Int          0 Data,
   VPS                  ""                                       vps                  Int          0 Data,
   CHILDLOCK            ""                                       childlock            Int          0 Data,
   AUX                  ""                                       aux                  Ascii     1000 Data,

   AUTOTIMERNAME        "Bezeichung des Suchtimers"              autotimername        Ascii      100 Data,
   AUTOTIMERID          "id of autotimer"                        autotimerid          UInt         0 Data,
   AUTOTIMERINSSP       ""                                       autotimerinssp       Int          0 Data,

   // just to update the done state by the plugin !!

   DONEID               "id of done entry"                       doneid               UInt         0 Data,
   EXPRESSION           ""                                       expression           Ascii      200 Data,
}

// ----------------------------------------------------------------
// Indices for Timers
// ----------------------------------------------------------------

Index timers
{
   eventidchannelidvdruuid   "" EVENTID CHANNELID VDRUUID,
   vdruuidstate              "" VDRUUID STATE
}

// ----------------------------------------------------------------
// Table
// ----------------------------------------------------------------

Table searchtimers
{
   ID                   ""                                                     id                   UInt         0 Primary|Autoinc,

   INSSP                ""                                                     inssp                Int          0 Meta,
   UPDSP                ""                                                     updsp                Int          0 Meta,

   CHANNELIDS           "comma separated list of channleids or empty"          channelids           Ascii      500 Data,
   CHEXCLUDE            ""                                                     chexclude            UInt         0 Data,
   CHFORMAT             "HD,SD"                                                chformat             Ascii       50 Data,

   NAME                 "Bezeichung des Suchtimers"                            name                 Ascii      100 Data,
   EXPRESSION           ""                                                     expression           Ascii      200 Data,
   EXPRESSION1          ""                                                     expression1          Ascii      200 Data,
   SEARCHMODE           "1 exact, 2 regexp, 3 like, 4 enthalten, .."           searchmode           UInt         0 Data,
   SEARCHFIELDS         "Bitmaske: 1 title, 2 shorttext, 4 - desc, .."         searchfields         UInt         0 Data,
   SEARCHFIELDS1        "Bitmaske: 0 off, 1 title, 2 shorttext, 4 - desc, .."  searchfields1        UInt         0 Data,

   CASESENSITIV         "0,1"                                                  casesensitiv         UInt         0 Data,

   REPEATFIELDS         "Bitmaske: 1 title, 2 shorttext, 4 - desc, .."         repeatfields         UInt         0 Data,

   // optional EPG Detail options

   EPISODENAME          ""                                                     episodename          Ascii      100 Data,
   SEASON               "e.g. '1-7'"                                           season               Ascii       10 Data,
   SEASONPART           "e.g. '20-'"                                           seasonpart           Ascii       10 Data,
   CATEGORY             "e.g. 'Spielfilm','Serie'"                             category             Ascii      150 Data,
   GENRE                "e.g. 'Krimi','Action'"                                genre                Ascii      150 Data,
   YEAR                 "e.g. '2010-2015'"                                     year                 Ascii       10 Data,
   TIPP                 ""                                                     tipp                 Ascii      250 Data,
   NOEPGMATCH           ""                                                     noepgmatch           Int          0 Data,

   // steering

   TYPE                 "'R'ecord, 'V'iew, 'S'earch"                           type                 Ascii        1 Data,
   STATE                "D - Deleted"                                          state                Ascii        1 Data,
   NAMINGMODE           ""                                                     namingmode           Int          0 Data,
   TEMPLATE             ""                                                     template             Ascii      100 Data,

   ACTIVE               "0,1"                                                  active               UInt         0 Data,
   SOURCE               "webif ,osd, ..."                                      source               Ascii       40 Data,
   HITS                 "stastic counter, just for info"                       hits                 UInt         0 Data,
   MODSP                "last user modification time"                          modsp                Int          0 Data,
   LASTRUN              "last execution of search timer"                       lastrun              Int          0 Data,
   VDRUUID              "empty or uuid of vdr"                                 vdruuid              Ascii       40 Data,

   // timer details

   WEEKDAYS             "bitmask like timers, 0 foy all"                       weekdays             Int          0 Data,
   NEXTDAYS             ""                                                     nextdays             UInt         0 Data,
   STARTTIME            "null for unlimited search"                            starttime            Int          0 Data,
   ENDTIME              "null for unlimited search"                            endtime              Int          0 Data,
   DIRECTORY            ""                                                     directory            Ascii      512 Data,
   PRIORITY             ""                                                     priority             Int          0 Data,
   LIFETIME             ""                                                     lifetime             Int          0 Data,
   VPS                  ""                                                     vps                  Int          0 Data,
   CHILDLOCK            ""                                                     childlock            Int          0 Data,
}

// ----------------------------------------------------------------
// Table TimersDone
// ----------------------------------------------------------------

Table timersdone
{
   ID                   ""                                    id                   UInt         0 Primary|Autoinc,

   INSSP                ""                                    inssp                Int          0 Meta,
   UPDSP                ""                                    updsp                Int          0 Meta,

   SOURCE               ""                                    source               Ascii       40 Data,
   STATE                "Q requested, C created, R recorded, F Failed" state       Ascii        1 Data,

   TIMERID              "not filled completely in all cases yet"       timerid     UInt         0 Data,
   AUTOTIMERID          ""                                    autotimerid          UInt         0 Data,
   AUTOTIMERNAME        "Bezeichung des Suchtimers"           autotimername        Ascii      100 Data,

   // to compare

   TITLE                ""                                    title                Ascii      200 Data,
   COMPTITLE            ""                                    comptitle            Ascii      200 Data,
   SHORTTEXT            ""                                    shorttext            Ascii      300 Data,
   COMPSHORTTEXT        ""                                    compshorttext        Ascii      300 Data,
   LONGDESCRIPTION      ""                                    longdescription      MText    25000 Data,
   COMPLONGDESCRIPTION  ""                                    complongdescription  MText    25000 Data,

   EPISODECOMPNAME      ""                                    episodecompname      Ascii      100 Data filter epgd|httpd|epg2vdr,
   EPISODECOMPSHORTNAME ""                                    episodecompshortname Ascii      100 Data filter epgd|httpd|epg2vdr,
   EPISODECOMPPARTNAME  ""                                    episodecomppartname  Ascii      200 Data filter epgd|httpd|epg2vdr,
   EPISODELANG          ""                                    episodelang          Ascii       10 Data filter epgd|httpd|epg2vdr,
   EPISODESEASON        ""                                    episodeseason        Int          0 Data,
   EPISODEPART          ""                                    episodepart          Int          0 Data,

   // just for info

   CHANNELID            ""                                    channelid            Ascii       50 Data,
   CHANNELNAME          ""                                    channelname          Ascii      100 Data;
   EXPRESSION           "expression of autotimer"             expression           Ascii      200 Data,
   STARTTIME            ""                                    starttime            Int         10 Data,
   DURATION             ""                                    duration             Int          5 Data,
   AUX                  ""                                    aux                  Ascii      512 Data,
}

// ----------------------------------------------------------------
// Indices for TimersDone
// ----------------------------------------------------------------

Index TimersDone
{
   checkdoubles         ""  COMPTITLE, COMPSHORTTEXT
}

// ----------------------------------------------------------------
// Table Messages / Notifications
// ----------------------------------------------------------------

Table messages
{
   ID                   ""                                    id            UInt         0 Primary|Autoinc,

   INSSP                ""                                    inssp         Int          0 Meta,
   UPDSP                ""                                    updsp         Int          0 Meta,

   TYPE                 "Warning, Info, Error, Fatal"         type          Ascii        1 Data,
   TITLE                ""                                    title         Ascii      200 Data,
   STATE                "Read, New, Deleted"                  state         Ascii        1 Data,
   TEXT                 ""                                    text          MText    20000 Data,
}

// ----------------------------------------------------------------
// SCRAPER stuff
// ----------------------------------------------------------------
// ----------------------------------------------------------------
// Table Series
// ----------------------------------------------------------------

Table series
{
   SERIESID             ""  series_id            UInt         0 Primary,
   SERIESNAME           ""  series_name          Ascii      200 Data,
   SERIESLASTSCRAPED    ""  series_last_scraped  UInt         0 Data,
   SERIESLASTUPDATED    ""  series_last_updated  UInt         0 Data,
   SERIESOVERVIEW       ""  series_overview      Text     10000 Data,
   SERIESFIRSTAIRED     ""  series_firstaired    Ascii       50 Data,
   SERIESNETWORK        ""  series_network       Ascii      100 Data,
   SERIESIMDBID         ""  series_imdb_id       Ascii       20 Data,
   SERIESGENRE          ""  series_genre         Ascii      100 Data,
   SERIESRATING         ""  series_rating        Float       31 Data,
   SERIESSTATUS         ""  series_status        Ascii       50 Data,
}

// ----------------------------------------------------------------
// Indices for Series
// ----------------------------------------------------------------

Index series
{
   seriesname           ""  SERIESNAME,
}

// ----------------------------------------------------------------
// Table SeriesEpisode
// ----------------------------------------------------------------

Table series_episode
{
   EPISODEID            ""  episode_id           UInt         0 Primary,
   EPISODENUMBER        ""  episode_number       UInt         0 Data,
   SEASONNUMBER         ""  season_number        UInt         0 Data,
   EPISODENAME          ""  episode_name         Ascii      300 Data,
   EPISODEOVERVIEW      ""  episode_overview     Text     10000 Data,
   EPISODEFIRSTAIRED    ""  episode_firstaired   Ascii       20 Data,
   EPISODEGUESTSTARS    ""  episode_gueststars   Ascii     1000 Data,
   EPISODERATING        ""  episode_rating       Float       31 Data,
   EPISODELASTUPDATED   ""  episode_last_updated UInt         0 Data,
   SERIESID             ""  series_id            UInt         0 Data,
}

// ----------------------------------------------------------------
// Indices for SeriesEpisode
// ----------------------------------------------------------------

Index series_episode
{
   series_id            ""  SERIESID,
}

// ----------------------------------------------------------------
// Table SeriesMedia
// ----------------------------------------------------------------

Table series_media
{
   SERIESID             ""  series_id            UInt         0 Primary,
   SEASONNUMBER         ""  season_number        UInt         0 Primary,
   EPISODEID            ""  episode_id           UInt         0 Primary,
   ACTORID              ""  actor_id             UInt         0 Primary,
   MEDIATYPE            ""  media_type           UInt         0 Primary,

   INSSP                ""  inssp                Int          0 Meta filter epgd|httpd|epg2vdr,
   UPDSP                ""  updsp                Int          0 Meta filter epgd|httpd|epg2vdr,

   MEDIAURL             ""  media_url            Ascii      100 Data,
   MEDIAWIDTH           ""  media_width          UInt         0 Data,
   MEDIAHEIGHT          ""  media_height         UInt         0 Data,
   MEDIARATING          ""  media_rating         Float       31 Data,
   MEDIACONTENT         ""  media_content        Mlob   1000000 Data,
}

// ----------------------------------------------------------------
// Indices for SeriesMedia
// ----------------------------------------------------------------

Index series_media
{
   series_id            ""  SERIESID,
   season_number        ""  SEASONNUMBER,
   episode_id           ""  EPISODEID,
   actor_id             ""  ACTORID,
}

// ----------------------------------------------------------------
// Table SeriesActor
// ----------------------------------------------------------------

Table series_actor
{
   ACTORID              ""  actor_id             UInt         0 Primary,
   ACTORNAME            ""  actor_name           Ascii      100 Data,
   ACTORROLE            ""  actor_role           Ascii      500 Data,
   SORTORDER            ""  actor_sortorder      UInt         0 Data,
}

// ----------------------------------------------------------------
// Indices for SeriesActor
// ----------------------------------------------------------------

Index series_actor
{
}

// ----------------------------------------------------------------
// Table Movie
// ----------------------------------------------------------------

Table movie
{
   MOVIEID              ""  movie_id             UInt         0 Primary,
   TITLE                ""  movie_title          Ascii      300 Data,
   ORIGINALTITLE        ""  movie_original_title Ascii      300 Data,
   TAGLINE              ""  movie_tagline        Ascii     1000 Data,
   OVERVIEW             ""  movie_overview       Text      5000 Data,
   ISADULT              ""  movie_adult          UInt         0 Data,
   COLLECTIONID         ""  movie_collection_id  UInt         0 Data,
   COLLECTIONNAME       ""  movie_collection_name Ascii     300 Data,
   BUDGET               ""  movie_budget         UInt         0 Data,
   REVENUE              ""  movie_revenue        UInt         0 Data,
   GENRES               ""  movie_genres         Ascii      500 Data,
   HOMEPAGE             ""  movie_homepage       Ascii      300 Data,
   RELEAASEDATE         ""  movie_release_date   Ascii       20 Data,
   RUNTIME              ""  movie_runtime        UInt         0 Data,
   POPULARITY           ""  movie_popularity     Float       31 Data,
   VOTEAVERAGE          ""  movie_vote_average   Float       31 Data,
}

// ----------------------------------------------------------------
// Indices for Movies
// ----------------------------------------------------------------

Index movie
{
   movie_id             ""  MOVIEID,
   movietitle           ""  TITLE,
}

// ----------------------------------------------------------------
// Table MovieActor
// ----------------------------------------------------------------

Table movie_actor
{
   ACTORID              ""  actor_id             UInt         0 Primary,
   ACTORNAME            ""  actor_name           Ascii      300 Data,
}

// ----------------------------------------------------------------
// Indices for MovieActor
// ----------------------------------------------------------------

Index movie_actor
{
   actor_id             ""  ACTORID,
}

// ----------------------------------------------------------------
// Table MovieActors
// ----------------------------------------------------------------

Table movie_actors
{
   MOVIEID              ""  movie_id             UInt         0 Primary,
   ACTORID              ""  actor_id             UInt         0 Primary,
   ROLE                 ""  actor_role           Ascii      300 Data,
}

// ----------------------------------------------------------------
// Indices for MovieActors
// ----------------------------------------------------------------

Index movie_actors
{
   movie_id             ""  MOVIEID,
   actor_id             ""  ACTORID,
}

// ----------------------------------------------------------------
// Table MovieMedia
// ----------------------------------------------------------------

Table movie_media
{
   MOVIEID              ""  movie_id             UInt         0 Primary,
   ACTORID              ""  actor_id             UInt         0 Primary,
   MEDIATYPE            ""  media_type           UInt         0 Primary,
   MEDIAURL             ""  media_url            Ascii      100 Data,
   MEDIAWIDTH           ""  media_width          UInt         0 Data,
   MEDIAHEIGHT          ""  media_height         UInt         0 Data,
   MEDIACONTENT         ""  media_content        Mlob   1000000 Data,
}

// ----------------------------------------------------------------
// Indices for MovieMedia
// ----------------------------------------------------------------

Index movie_media
{
   movie_id             ""  MOVIEID,
   actor_id             ""  ACTORID,
}