DatabaseProtoTimeline
From MythTV Official Wiki
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 |