summaryrefslogtreecommitdiffstats
path: root/abs/core-testing/linhes-scripts/update_schema_021_to_022.sh
blob: fc39f448432da62c5f6d6bd4a591937f93fb3c80 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
#!/bin/bash

mysql mythconverg <<EOF
update gameplayers set commandline = '/usr/bin/sdlmame -rp /myth/games/xmame/roms %s' where commandline = '/usr/game/mame -rp /myth/games/xmame/roms %s';
update settings set data = '/myth/video_stuff/coverart' where value = 'VideoArtworkDir';
update settings set data = '/myth/video_stuff/fanart' where value = 'mythvideo.fanartDir';
update settings set data = '/myth/video_stuff/screenshots' where value = 'mythvideo.screenshotDir';
update settings set data = '/myth/video_stuff/banners' where value = 'mythvideo.bannerDir';
update settings set data = '/myth/video_stuff/trailers' where value = 'mythvideo.TrailersDir';
update settings set data = '1' where value = 'mythvideo.TrailersRandomEnabled';
update settings set data = '1' where value = 'mythvideo.EnableAlternatePlayer';
update settings set data = '/myth/video_stuff/screenshots' where value = 'ScreenShotPath';
update settings set data = '/myth/games/screenshots' where value = 'mythgame.screenshotdir';
update settings set data = '/myth/games/fanart' where value = 'mythgame.fanartdir';
update settings set data = '/myth/games/boxart' where value = 'mythgame.boxartdir';
update settings set data = '3' where value = 'OverrideExitMenu';
update settings set data = 'sudo sv start mythbackend' where value = 'BackendStartCommand';
update settings set data = 'sudo sv stop mythbackend' where value = 'BackendStopCommand';
EOF