DatabaseProtoTimeline

From MythTV Official Wiki
Jump to: navigation, search

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