[mythtv] bug in 0-7-to-0-8.sql

[Larry Matter]

------=_20030110122805_77656
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Checked out from CVS about 30 minutes ago.

Starting on line 34 of 0-7-to-0-8.sql, the INSERT INTO statements try to
select from a column (profile) that hasn't been added yet (until about
line 65).

Since those columns are added and then initialized to 0 you could just
hardcode the value in the insert statement or move the INSERT INTOs to the
bottom of the file, which is what I did.

I've attached my version of the file which at least doesn't get complaints
from mysql (haven't finished configurning the rest of mythtv yet thought).

Larry



------=_20030110122805_77656
Content-Type: application/octet-stream; name="0-7-to-0-8.sql"
Content-Disposition: attachment; filename="0-7-to-0-8.sql"
Content-Transfer-Encoding: base64

VVNFIG15dGhjb252ZXJnOwoKQ1JFQVRFIFRBQkxFIElGIE5PVCBFWElTVFMgcmVjb3JkaW5ncHJv
ZmlsZXMKKAogICAgaWQgSU5UIFVOU0lHTkVEIEFVVE9fSU5DUkVNRU5UIE5PVCBOVUxMIFBSSU1B
UlkgS0VZLAogICAgbmFtZSBWQVJDSEFSKDEyOCksCiAgICB2aWRlb2NvZGVjIFZBUkNIQVIoMTI4
KSwKICAgIGF1ZGlvY29kZWMgVkFSQ0hBUigxMjgpLAogICAgVU5JUVVFKG5hbWUpCik7CkNSRUFU
RSBUQUJMRSBJRiBOT1QgRVhJU1RTIGNvZGVjcGFyYW1zCigKICAgIHByb2ZpbGUgSU5UIFVOU0lH
TkVEIE5PVCBOVUxMIFJFRkVSRU5DRVMgcmVjb3JkaW5ncHJvZmlsZXMoaWQpLAogICAgbmFtZSBW
QVJDSEFSKDEyOCkgTk9UIE5VTEwsCiAgICB2YWx1ZSBWQVJDSEFSKDEyOCksCiAgICBQUklNQVJZ
IEtFWSAocHJvZmlsZSwgbmFtZSkKKTsKCkNSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTIHJlY29y
ZAooCiAgICByZWNvcmRpZCBJTlQgVU5TSUdORUQgQVVUT19JTkNSRU1FTlQgTk9UIE5VTEwgUFJJ
TUFSWSBLRVksCiAgICB0eXBlIElOVCBVTlNJR05FRCBOT1QgTlVMTCwKICAgIGNoYW5pZCBJTlQg
VU5TSUdORUQgTlVMTCwKICAgIHN0YXJ0dGltZSBUSU1FIE5VTEwsCiAgICBzdGFydGRhdGUgREFU
RSBOVUxMLAogICAgZW5kdGltZSBUSU1FIE5VTEwsCiAgICBlbmRkYXRlIERBVEUgTlVMTCwKICAg
IHRpdGxlIFZBUkNIQVIoMTI4KSBOVUxMLAogICAgc3VidGl0bGUgVkFSQ0hBUigxMjgpIE5VTEws
CiAgICBkZXNjcmlwdGlvbiBURVhUIE5VTEwsCiAgICBwcm9maWxlIElOVCBVTlNJR05FRCBOT1Qg
TlVMTCBERUZBVUxUIDAKKTsKCkFMVEVSIFRBQkxFIHNldHRpbmdzIEFERCBDT0xVTU4gaG9zdG5h
bWUgVkFSQ0hBUigyNTUpIE5VTEw7CgpBTFRFUiBUQUJMRSBjYXB0dXJlY2FyZCBBREQgQ09MVU1O
IGhvc3RuYW1lIFZBUkNIQVIoMjU1KTsKQUxURVIgVEFCTEUgcmVjb3JkZWQgQUREIENPTFVNTiBo
b3N0bmFtZSBWQVJDSEFSKDI1NSk7CgpBTFRFUiBUQUJMRSBhbGxyZWNvcmQgQUREIENPTFVNTiBw
cm9maWxlIElOVCBVTlNJR05FRCBOT1QgTlVMTCBERUZBVUxUIDAgUkVGRVJFTkNFUyByZWNvcmRp
bmdwcm9maWxlcyhpZCk7CkFMVEVSIFRBQkxFIHNpbmdsZXJlY29yZCBBREQgQ09MVU1OIHByb2Zp
bGUgSU5UIFVOU0lHTkVEIE5PVCBOVUxMIERFRkFVTFQgMCBSRUZFUkVOQ0VTIHJlY29yZGluZ3By
b2ZpbGVzKGlkKTsKQUxURVIgVEFCTEUgdGltZXNsb3RyZWNvcmQgQUREIENPTFVNTiBwcm9maWxl
IElOVCBVTlNJR05FRCBOT1QgTlVMTCBERUZBVUxUIDAgUkVGRVJFTkNFUyByZWNvcmRpbmdwcm9m
aWxlcyhpZCk7CkFMVEVSIFRBQkxFIHZpZGVvc291cmNlIEFERCBDT0xVTU4geG1sdHZncmFiYmVy
IFZBUkNIQVIoMTI4KTsKClVQREFURSBhbGxyZWNvcmQgU0VUIHByb2ZpbGUgPSAwOwpVUERBVEUg
c2luZ2xlcmVjb3JkIFNFVCBwcm9maWxlID0gMDsKVVBEQVRFIHRpbWVzbG90cmVjb3JkIFNFVCBw
cm9maWxlID0gMDsKCklOU0VSVCBJTlRPIHJlY29yZAoodHlwZSxjaGFuaWQsc3RhcnR0aW1lLHN0
YXJ0ZGF0ZSxlbmR0aW1lLGVuZGRhdGUsdGl0bGUsc3VidGl0bGUsZGVzY3JpcHRpb24scHJvZmls
ZSkKU0VMRUNUIDEsIGNoYW5pZCwKU0VDX1RPX1RJTUUoVElNRV9UT19TRUMoc3RhcnR0aW1lKSks
IEZST01fREFZUyhUT19EQVlTKHN0YXJ0dGltZSkpLApTRUNfVE9fVElNRShUSU1FX1RPX1NFQyhl
bmR0aW1lKSksIEZST01fREFZUyhUT19EQVlTKGVuZHRpbWUpKSwKdGl0bGUsc3VidGl0bGUsZGVz
Y3JpcHRpb24scHJvZmlsZQpGUk9NIHNpbmdsZXJlY29yZDsKCklOU0VSVCBJTlRPIHJlY29yZAoo
dHlwZSxjaGFuaWQsc3RhcnR0aW1lLGVuZHRpbWUsdGl0bGUscHJvZmlsZSkKU0VMRUNUIDIsIGNo
YW5pZCwgc3RhcnR0aW1lLCBlbmR0aW1lLCB0aXRsZSwgcHJvZmlsZQpGUk9NIHRpbWVzbG90cmVj
b3JkOwoKSU5TRVJUIElOVE8gcmVjb3JkCih0eXBlLGNoYW5pZCx0aXRsZSxwcm9maWxlKQpTRUxF
Q1QgMywgY2hhbmlkLCB0aXRsZSwgcHJvZmlsZQpGUk9NIGFsbHJlY29yZApXSEVSRSBjaGFuaWQg
SVMgTk9UIE5VTEw7CgpJTlNFUlQgSU5UTyByZWNvcmQKKHR5cGUsY2hhbmlkLHRpdGxlLHByb2Zp
bGUpClNFTEVDVCA0LCBjaGFuaWQsIHRpdGxlLCBwcm9maWxlCkZST00gYWxscmVjb3JkCldIRVJF
IGNoYW5pZCBJUyBOVUxMOwoKSU5TRVJUIElOVE8gcmVjb3JkaW5ncHJvZmlsZXMgKG5hbWUpIFZB
TFVFUyAoJ0RlZmF1bHQnKTsKSU5TRVJUIElOVE8gcmVjb3JkaW5ncHJvZmlsZXMgKG5hbWUpIFZB
TFVFUyAoJ0xpdmUgVFYnKTsK

------=_20030110122805_77656--