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)