DatabaseProtoTimeline

As developers improve MythTV, the database used by it keeps changing. Running newer frontends against an older database can cause problems, because the newer frontend currently upgrades the database schema automatically. This can cause problems for the old versions of the frontend and backend.

To try any work out the risk of doing this, I started to prepare a table. It isn't finished, but documents some of the dangerous schema upgrades:

Version	Backend Protocol	Schema	Danger
0.16	13	1055
		...
0.17	14	1071
		...
0.18	15	1083
[6284]	16
[6450]		1084
[6482]	17
[6495]		1085
[6657]		1086
[6739]	18
[6773]		1087
[6865]		1088
[6896]		1089
[6996]		1090
[7052]		1091
[7156]		1092
[7223]		1093	No
		1094	A little
[7240]		1095	A little
[7249]		1095	No
[7251]		1096	No
[7266]		1097	Yes (dropped tables 0.16 used)
[7300]		1098	No
[7429]		1099	A little (changed a record rule)
[7453]	19
[7659]		1100	No
[7669]		1101	No
[7697]		1102	No
[7739]	20
[7757]		1103	No
[7787]		1104	No
[7826]	21	1105	No
[7863]		1106	A little (changed AutoExpireMethod=None)
[7883]	22
[7928]		1107	Probably (changed types in inuseprograms)
[7965]		1108	No
[8025]		1109	No
[8029]		1110	No
[8058]		1111	No
[8071]		1112	A little (dropped tables 0.13 used)
[8072]		1113	A little (changed DailyWakeup)
[8105]		1114	No
[8109]		1115	No
[8111]		1116	No
[8113]		1117	No
[8114]		1118	Yes (removed column from caprurecard)
[8218]		1119	No
[8255]		1120	No
[8408]		1121	No
[8553]	23
[8617]	24
[8628]	25
[8643]		1122	A little (widens a column)
[8907]		1123	No
0.19	26	1123
[8948]		1124	No
[9022]		1125	No
[9029]		1126	No
[9081]		1127	Yes (dropped old table and columns)
[9149]		1128	No
[9270]		1129	Yes (dropped table, moved cutlist,markup)
[9300]		1130	No
[9342]		1131	No
		...
0.20	30	1158
		...
0.20.1	31	1160
0.20.2	31	1160
		...
[14477]	36	1199
[14679]		1200
[14748]		1201
[15146]		1202
[15257]		1203
[15272]		1204
[15276]		1205
[15437]		1207
[15483]		1208
[15730]		1209
[15900]		1210
[15930]		1211
[16167]		1212
[16408]		1213
[16446]		1214
[16747]		1215
[16790]		1218
[16825]		1219
[17182]		1220
[17381]		1221
[17832]		1222
[18089]		1223
[19149]		1224
[19219]		1225
[19220]		1226
[19439]		1227
[19500]		1228
[20029]		1229
[20037]		1230
[20048]		1231
[20067]		1232
[20503]		1233
[20652]		1235
[20771]		1236
[20911]		1237
[20980]		1238
[21115]		1239
[21179]		1240
[21186]		1241
[21225]		1242
[21565]		1243
[21627]		1244
[22789]		1245
[22790]		1246
[22932]		1247
[23044]		1248
[23106]		1249
[23112]		1250
[23159]		1251
[23202]		1252
[23362]		1253
[23364]		1254
[24694]		1255
[24722]		1256
[24819]		1257
[24840]		1258
[24869]		1259