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
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
453
I removed all sign of MySQL, rebooted, did a clean reinstall. It reinstalled 5.6, But I've still got both the same problem - unable to connect to any of the specified MySQL hosts. And Hostname is still in red. I don't understand - this is a dedicated TV computer. Unless an update did this I don't know why there's a problem in the...
I removed all sign of MySQL, rebooted, did a clean reinstall. It reinstalled 5.6, But I've still got both the same problem -...
I've been using MediaPortal for 20 or so years. Last night it recorded perfectly. This arvo it doesn't - will run videos but not...
Replies
2
Views
1K
Top Bottom