rendered paste bodymysql> select * from codecparams;
+---------+--------------------------+-----------+
| profile | name | value |
+---------+--------------------------+-----------+
| 19 | autotranscode | 1 |
| 19 | recordingtype | all |
| 7 | autotranscode | 1 |
| 7 | width | 640 |
| 7 | height | 480 |
| 7 | rtjpegquality | 170 |
| 7 | rtjpeglumafilter | 0 |
| 7 | rtjpegchromafilter | 0 |
| 7 | mpeg4bitrate | 2200 |
| 7 | mpeg4maxquality | 2 |
| 7 | mpeg4minquality | 15 |
| 7 | mpeg4qualdiff | 3 |
| 7 | mpeg4scalebitrate | 1 |
| 7 | mpeg4optionvhq | 0 |
| 7 | mpeg4option4mv | 0 |
| 7 | mpeg4optionidct | 0 |
| 7 | mpeg4optionime | 0 |
| 7 | hardwaremjpegquality | 100 |
| 7 | hardwaremjpeghdecimation | 4 |
| 7 | hardwaremjpegvdecimation | 4 |
| 7 | mpeg2streamtype | MPEG-2 PS |
| 7 | mpeg2aspectratio | 4:3 |
| 7 | mpeg2bitrate | 4500 |
| 7 | mpeg2maxbitrate | 6000 |
| 7 | samplerate | 32000 |
| 7 | mp3quality | 7 |
| 7 | volume | 90 |
| 7 | mpeg2audtype | Layer II |
| 7 | mpeg2audbitratel1 | 448 |
| 7 | mpeg2audbitratel2 | 384 |
| 7 | mpeg2audvolume | 90 |
| 17 | autotranscode | 1 |
| 17 | recordingtype | all |
| 21 | transcodelossless | 1 |
| 21 | transcoderesize | 0 |
| 21 | width | 480 |
| 21 | height | 480 |
| 21 | rtjpegquality | 170 |
| 21 | rtjpeglumafilter | 0 |
| 21 | rtjpegchromafilter | 0 |
| 21 | mpeg4bitrate | 2200 |
| 21 | mpeg4maxquality | 2 |
| 21 | mpeg4minquality | 15 |
| 21 | mpeg4qualdiff | 3 |
| 21 | mpeg4scalebitrate | 1 |
| 21 | mpeg4optionvhq | 0 |
| 21 | mpeg4option4mv | 0 |
| 21 | mpeg4optionidct | 0 |
| 21 | mpeg4optionime | 0 |
| 21 | hardwaremjpegquality | 100 |
| 21 | hardwaremjpeghdecimation | 4 |
| 21 | hardwaremjpegvdecimation | 4 |
| 21 | mpeg2streamtype | MPEG-2 PS |
| 21 | mpeg2aspectratio | 4:3 |
| 21 | mpeg2bitrate | 4500 |
| 21 | mpeg2maxbitrate | 6000 |
| 21 | samplerate | 32000 |
| 21 | mp3quality | 7 |
| 21 | volume | 90 |
| 21 | mpeg2audtype | Layer II |
| 21 | mpeg2audbitratel1 | 448 |
| 21 | mpeg2audbitratel2 | 384 |
| 21 | mpeg2audvolume | 90 |
| 22 | transcodelossless | 1 |
| 22 | transcoderesize | 0 |
| 22 | width | 480 |
| 22 | height | 480 |
| 22 | rtjpegquality | 170 |
| 22 | rtjpeglumafilter | 0 |
| 22 | rtjpegchromafilter | 0 |
| 22 | mpeg4bitrate | 2200 |
| 22 | mpeg4maxquality | 2 |
| 22 | mpeg4minquality | 15 |
| 22 | mpeg4qualdiff | 3 |
| 22 | mpeg4scalebitrate | 1 |
| 22 | mpeg4optionvhq | 0 |
| 22 | mpeg4option4mv | 0 |
| 22 | mpeg4optionidct | 0 |
| 22 | mpeg4optionime | 0 |
| 22 | hardwaremjpegquality | 100 |
| 22 | hardwaremjpeghdecimation | 4 |
| 22 | hardwaremjpegvdecimation | 4 |
| 22 | mpeg2streamtype | MPEG-2 PS |
| 22 | mpeg2aspectratio | 4:3 |
| 22 | mpeg2bitrate | 4500 |
| 22 | mpeg2maxbitrate | 6000 |
| 22 | samplerate | 32000 |
| 22 | mp3quality | 7 |
| 22 | volume | 90 |
| 22 | mpeg2audtype | Layer II |
| 22 | mpeg2audbitratel1 | 448 |
| 22 | mpeg2audbitratel2 | 384 |
| 22 | mpeg2audvolume | 90 |
| 20 | autotranscode | 1 |
| 20 | recordingtype | all |
| 18 | autotranscode | 1 |
| 18 | recordingtype | all |
| 5 | autotranscode | 1 |
| 5 | width | 640 |
| 5 | height | 480 |
| 5 | rtjpegquality | 170 |
| 5 | rtjpeglumafilter | 0 |
| 5 | rtjpegchromafilter | 0 |
| 5 | mpeg4bitrate | 2200 |
| 5 | mpeg4maxquality | 2 |
| 5 | mpeg4minquality | 15 |
| 5 | mpeg4qualdiff | 3 |
| 5 | mpeg4scalebitrate | 1 |
| 5 | mpeg4optionvhq | 0 |
| 5 | mpeg4option4mv | 0 |
| 5 | mpeg4optionidct | 0 |
| 5 | mpeg4optionime | 0 |
| 5 | hardwaremjpegquality | 100 |
| 5 | hardwaremjpeghdecimation | 4 |
| 5 | hardwaremjpegvdecimation | 4 |
| 5 | mpeg2streamtype | MPEG-2 PS |
| 5 | mpeg2aspectratio | 4:3 |
| 5 | mpeg2bitrate | 4500 |
| 5 | mpeg2maxbitrate | 6000 |
| 5 | samplerate | 32000 |
| 5 | mp3quality | 7 |
| 5 | volume | 90 |
| 5 | mpeg2audtype | Layer II |
| 5 | mpeg2audbitratel1 | 448 |
| 5 | mpeg2audbitratel2 | 384 |
| 5 | mpeg2audvolume | 90 |
| 6 | autotranscode | 1 |
| 6 | width | 640 |
| 6 | height | 480 |
| 6 | rtjpegquality | 170 |
| 6 | rtjpeglumafilter | 0 |
| 6 | rtjpegchromafilter | 0 |
| 6 | mpeg4bitrate | 2200 |
| 6 | mpeg4maxquality | 2 |
| 6 | mpeg4minquality | 15 |
| 6 | mpeg4qualdiff | 3 |
| 6 | mpeg4scalebitrate | 1 |
| 6 | mpeg4optionvhq | 0 |
| 6 | mpeg4option4mv | 0 |
| 6 | mpeg4optionidct | 0 |
| 6 | mpeg4optionime | 0 |
| 6 | hardwaremjpegquality | 100 |
| 6 | hardwaremjpeghdecimation | 4 |
| 6 | hardwaremjpegvdecimation | 4 |
| 6 | mpeg2streamtype | MPEG-2 PS |
| 6 | mpeg2aspectratio | 4:3 |
| 6 | mpeg2bitrate | 4500 |
| 6 | mpeg2maxbitrate | 6000 |
| 6 | samplerate | 32000 |
| 6 | mp3quality | 7 |
| 6 | volume | 90 |
| 6 | mpeg2audtype | Layer II |
| 6 | mpeg2audbitratel1 | 448 |
| 6 | mpeg2audbitratel2 | 384 |
| 6 | mpeg2audvolume | 90 |
| 8 | autotranscode | 1 |
| 8 | width | 640 |
| 8 | height | 480 |
| 8 | rtjpegquality | 170 |
| 8 | rtjpeglumafilter | 0 |
| 8 | rtjpegchromafilter | 0 |
| 8 | mpeg4bitrate | 2200 |
| 8 | mpeg4maxquality | 2 |
| 8 | mpeg4minquality | 15 |
| 8 | mpeg4qualdiff | 3 |
| 8 | mpeg4scalebitrate | 1 |
| 8 | mpeg4optionvhq | 0 |
| 8 | mpeg4option4mv | 0 |
| 8 | mpeg4optionidct | 0 |
| 8 | mpeg4optionime | 0 |
| 8 | hardwaremjpegquality | 100 |
| 8 | hardwaremjpeghdecimation | 4 |
| 8 | hardwaremjpegvdecimation | 4 |
| 8 | mpeg2streamtype | MPEG-2 PS |
| 8 | mpeg2aspectratio | 4:3 |
| 8 | mpeg2bitrate | 4500 |
| 8 | mpeg2maxbitrate | 6000 |
| 8 | samplerate | 32000 |
| 8 | mp3quality | 7 |
| 8 | volume | 90 |
| 8 | mpeg2audtype | Layer II |
| 8 | mpeg2audbitratel1 | 448 |
| 8 | mpeg2audbitratel2 | 384 |
| 8 | mpeg2audvolume | 90 |
| 27 | transcodelossless | 1 |
| 27 | transcoderesize | 0 |
| 27 | width | 480 |
| 27 | height | 480 |
| 27 | rtjpegquality | 170 |
| 27 | rtjpeglumafilter | 0 |
| 27 | rtjpegchromafilter | 0 |
| 27 | mpeg4bitrate | 2200 |
| 27 | mpeg4maxquality | 2 |
| 27 | mpeg4minquality | 15 |
| 27 | mpeg4qualdiff | 3 |
| 27 | mpeg4scalebitrate | 1 |
| 27 | mpeg4optionvhq | 0 |
| 27 | mpeg4option4mv | 0 |
| 27 | mpeg4optionidct | 0 |
| 27 | mpeg4optionime | 0 |
| 27 | hardwaremjpegquality | 100 |
| 27 | hardwaremjpeghdecimation | 4 |
| 27 | hardwaremjpegvdecimation | 4 |
| 27 | mpeg2streamtype | MPEG-2 PS |
| 27 | mpeg2aspectratio | 4:3 |
| 27 | mpeg2bitrate | 4500 |
| 27 | mpeg2maxbitrate | 6000 |
| 27 | samplerate | 32000 |
| 27 | mp3quality | 7 |
| 27 | volume | 90 |
| 27 | mpeg2audtype | Layer II |
| 27 | mpeg2audbitratel1 | 448 |
| 27 | mpeg2audbitratel2 | 384 |
| 27 | mpeg2audvolume | 90 |
| 28 | transcodelossless | 1 |
| 28 | transcoderesize | 0 |
| 28 | width | 480 |
| 28 | height | 480 |
| 28 | rtjpegquality | 170 |
| 28 | rtjpeglumafilter | 0 |
| 28 | rtjpegchromafilter | 0 |
| 28 | mpeg4bitrate | 2200 |
| 28 | mpeg4maxquality | 2 |
| 28 | mpeg4minquality | 15 |
| 28 | mpeg4qualdiff | 3 |
| 28 | mpeg4scalebitrate | 1 |
| 28 | mpeg4optionvhq | 0 |
| 28 | mpeg4option4mv | 0 |
| 28 | mpeg4optionidct | 0 |
| 28 | mpeg4optionime | 0 |
| 28 | hardwaremjpegquality | 100 |
| 28 | hardwaremjpeghdecimation | 4 |
| 28 | hardwaremjpegvdecimation | 4 |
| 28 | mpeg2streamtype | MPEG-2 PS |
| 28 | mpeg2aspectratio | 4:3 |
| 28 | mpeg2bitrate | 4500 |
| 28 | mpeg2maxbitrate | 6000 |
| 28 | samplerate | 32000 |
| 28 | mp3quality | 7 |
| 28 | volume | 90 |
| 28 | mpeg2audtype | Layer II |
| 28 | mpeg2audbitratel1 | 448 |
| 28 | mpeg2audbitratel2 | 384 |
| 28 | mpeg2audvolume | 90 |
| 29 | transcodelossless | 1 |
| 29 | transcoderesize | 0 |
| 29 | width | 480 |
| 29 | height | 480 |
| 29 | rtjpegquality | 170 |
| 29 | rtjpeglumafilter | 0 |
| 29 | rtjpegchromafilter | 0 |
| 29 | mpeg4bitrate | 2200 |
| 29 | mpeg4maxquality | 2 |
| 29 | mpeg4minquality | 15 |
| 29 | mpeg4qualdiff | 3 |
| 29 | mpeg4scalebitrate | 1 |
| 29 | mpeg4optionvhq | 0 |
| 29 | mpeg4option4mv | 0 |
| 29 | mpeg4optionidct | 0 |
| 29 | mpeg4optionime | 0 |
| 29 | hardwaremjpegquality | 100 |
| 29 | hardwaremjpeghdecimation | 4 |
| 29 | hardwaremjpegvdecimation | 4 |
| 29 | mpeg2streamtype | MPEG-2 PS |
| 29 | mpeg2aspectratio | 4:3 |
| 29 | mpeg2bitrate | 4500 |
| 29 | mpeg2maxbitrate | 6000 |
| 29 | samplerate | 32000 |
| 29 | mp3quality | 7 |
| 29 | volume | 90 |
| 29 | mpeg2audtype | Layer II |
| 29 | mpeg2audbitratel1 | 448 |
| 29 | mpeg2audbitratel2 | 384 |
| 29 | mpeg2audvolume | 90 |
+---------+--------------------------+-----------+
274 rows in set (0.00 sec)
mysql> select * from recordingprofiles;
+----+----------------+-------------------------+-------------------------+--------------+
| id | name | videocodec | audiocodec | profilegroup |
+----+----------------+-------------------------+-------------------------+--------------+
| 1 | Default | NULL | NULL | 1 |
| 2 | Live TV | NULL | NULL | 1 |
| 3 | High Quality | NULL | NULL | 1 |
| 4 | Low Quality | NULL | NULL | 1 |
| 5 | Default | MPEG-2 Hardware Encoder | MPEG-2 Hardware Encoder | 2 |
| 6 | Live TV | MPEG-2 Hardware Encoder | MPEG-2 Hardware Encoder | 2 |
| 7 | High Quality | MPEG-2 Hardware Encoder | MPEG-2 Hardware Encoder | 2 |
| 8 | Low Quality | MPEG-2 Hardware Encoder | MPEG-2 Hardware Encoder | 2 |
| 9 | Default | NULL | NULL | 3 |
| 10 | Live TV | NULL | NULL | 3 |
| 11 | High Quality | NULL | NULL | 3 |
| 12 | Low Quality | NULL | NULL | 3 |
| 13 | Default | NULL | NULL | 4 |
| 14 | Live TV | NULL | NULL | 4 |
| 15 | High Quality | NULL | NULL | 4 |
| 16 | Low Quality | NULL | NULL | 4 |
| 17 | Default | NULL | NULL | 5 |
| 18 | Live TV | NULL | NULL | 5 |
| 19 | High Quality | NULL | NULL | 5 |
| 20 | Low Quality | NULL | NULL | 5 |
| 21 | RTjpeg/MPEG4 | RTjpeg | MP3 | 6 |
| 22 | MPEG2 | RTjpeg | MP3 | 6 |
| 23 | Default | NULL | NULL | 8 |
| 24 | Live TV | NULL | NULL | 8 |
| 25 | High Quality | NULL | NULL | 8 |
| 26 | Low Quality | NULL | NULL | 8 |
| 27 | High Quality | RTjpeg | MP3 | 6 |
| 28 | Medium Quality | RTjpeg | MP3 | 6 |
| 29 | Low Quality | RTjpeg | MP3 | 6 |
| 30 | Default | NULL | NULL | 10 |
| 31 | Live TV | NULL | NULL | 10 |
| 32 | High Quality | NULL | NULL | 10 |
| 33 | Low Quality | NULL | NULL | 10 |
| 34 | Default | NULL | NULL | 11 |
| 35 | Live TV | NULL | NULL | 11 |
| 36 | High Quality | NULL | NULL | 11 |
| 37 | Low Quality | NULL | NULL | 11 |
| 38 | Default | NULL | NULL | 12 |
| 39 | Live TV | NULL | NULL | 12 |
| 40 | High Quality | NULL | NULL | 12 |
| 41 | Low Quality | NULL | NULL | 12 |
+----+----------------+-------------------------+-------------------------+--------------+
41 rows in set (0.00 sec)
mysql> select * from profilegroups;
+----+----------------------------------------------------------+-----------+------------+----------+
| id | name | cardtype | is_default | hostname |
+----+----------------------------------------------------------+-----------+------------+----------+
| 1 | Software Encoders (v4l based) | V4L | 1 | NULL |
| 2 | MPEG-2 Encoders (PVR-x50, PVR-500) | MPEG | 1 | NULL |
| 3 | Hardware MJPEG Encoders (Matrox G200-TV, Miro DC10, etc) | MJPEG | 1 | NULL |
| 4 | Hardware HDTV | HDTV | 1 | NULL |
| 5 | Hardware DVB Encoders | DVB | 1 | NULL |
| 6 | Transcoders | TRANSCODE | 1 | NULL |
| 7 | FireWire Input | FIREWIRE | 1 | NULL |
| 8 | USB Mpeg-4 Encoder (Plextor ConvertX, etc) | GO7007 | 1 | NULL |
| 9 | DBOX2 Input | DBOX2 | 1 | NULL |
| 10 | Freebox Input | Freebox | 1 | NULL |
| 11 | HDHomeRun Recorders | HDHOMERUN | 1 | NULL |
| 12 | CRC IP Recorders | CRC_IP | 1 | NULL |
+----+----------------------------------------------------------+-----------+------------+----------+
12 rows in set (0.00 sec)