MySQL DB-Manual for tables (1 Viewer)

Commifreak

New Member
July 28, 2009
4
0
Home Country
Germany Germany
MediaPortal Version: 1.1.0RC1

Exists a short manual for the record and schedule table of MediaPortal MySQL DB Layout? I dont found anything.

Thanks
 

Commifreak

New Member
July 28, 2009
4
0
Home Country
Germany Germany
AW: MySQL DB-Manual for tables

Hm, Ok.

Should the record and schedule table be filled when record a simple movie? Or only record/schedule?

I want to write a simple php-script which add a recording, and i dont know which tables of these 2 are used for this.
 

riksmith

Portal Pro
April 18, 2009
1,856
322
Home Country
Netherlands Netherlands
The schedule entry is used to schedule a recording, so that should be filled. MP will create the recording entry when it starts recording.
 

Commifreak

New Member
July 28, 2009
4
0
Home Country
Germany Germany
AW: MySQL DB-Manual for tables

Hello again,

I hope you can answer this question: What values are valid in these fields?

  • scheduleType
  • maxAirings
  • priority
  • directory (path to *.ts?)
  • quality
  • keepMethod
  • keepDate
  • recommendedCard (Number of card listed in 'card'?)
  • series

Thanks a lot!
 

Users who are viewing this thread


Write your reply...

Similar threads

Hi, I didn't have SQL problems but just wanted to agree that on my Win7 system, a clean install of 1.36 TV server x86 does not work since it won't start the TV server configuration. Installing 1.33 first and upgrading to1.36 fixed the problem. Eggert
Hi, I didn't have SQL problems but just wanted to agree that on my Win7 system, a clean install of 1.36 TV server x86 does not...
Hi, went from a 1.29 install (working, reinstalled for other reasons) on a fairly fresh and fully updated Windows 10 system for a...
Replies
26
Views
5K
I did a check of MP 1.36 x64 on Win11 and I can confirm, that the TV server correctly detects running MediaPortal.exe process.
I did a check of MP 1.36 x64 on Win11 and I can confirm, that the TV server correctly detects running MediaPortal.exe process.
Hi, I am using MP in a client-only setup including DVB-S card for over 10 years now. And regularily scheduling records waking up...
Replies
9
Views
1K
To be fair the normal uninstall is usually more than sufficient. I regularly uninstall and reinstall MP 1 as part of the testing process and only very rarely have I needed to use the manual procedure posted by @CyberSimian to overcome the error you ran into. I also believe there is a procedure to repair the MySQL install in the event...
To be fair the normal uninstall is usually more than sufficient. I regularly uninstall and reinstall MP 1 as part of the testing...
I am trying to install Mediaportal with TV Server. I tried many versions, including current x64 and new prerelease x86, and...
Replies
3
Views
2K
Please help, It would be a great help to me just to know if people are still getting tvlisting from gracenote.com. When zap2it stopped I switched to gracenote and it has been working but a few days ago it is not working. It connects and seems to go through the process updating overair tvlistings but is not working to give me a...
Please help, It would be a great help to me just to know if people are still getting tvlisting from gracenote.com. When zap2it...
Please help, It would be a great help to me just to know if people are still getting tvlisting from gracenote.com. When zap2it...
Replies
0
Views
117
Well, I had already recognized your problem, but I still wanted to point out the basic connections once again. Unfortunately, I don't have a fundamentally different solution for you, but with this approach you should achieve your goal. ;) The idea of first setting the current genre colors with the defines is certainly a good one, as...
Well, I had already recognized your problem, but I still wanted to point out the basic connections once again. Unfortunately, I...
Good afternoon, Does anyone know a way of referencing the genre colour of the currently selected item in the TV Guide. We are all...
Replies
4
Views
455
Top Bottom