Difference between revisions of "DatabaseProtoTimeline"
From MythTV Official Wiki
(outdated) |
(add schema change revisions) |
||
Line 8: | Line 8: | ||
|''Schema'' | |''Schema'' | ||
|''Danger'' | |''Danger'' | ||
− | |||
|- | |- | ||
|0.16 | |0.16 | ||
|13 | |13 | ||
|1055 | |1055 | ||
+ | | | ||
|- | |- | ||
| | | | ||
| | | | ||
|... | |... | ||
+ | | | ||
|- | |- | ||
|0.17 | |0.17 | ||
|14 | |14 | ||
|1071 | |1071 | ||
+ | | | ||
|- | |- | ||
| | | | ||
| | | | ||
|... | |... | ||
+ | | | ||
|- | |- | ||
|0.18 | |0.18 | ||
|15 | |15 | ||
|1083 | |1083 | ||
+ | | | ||
|- | |- | ||
|r6284 | |r6284 | ||
|16 | |16 | ||
+ | | | ||
+ | | | ||
|- | |- | ||
|r6450 | |r6450 | ||
| | | | ||
|1084 | |1084 | ||
+ | | | ||
|- | |- | ||
|r6482 | |r6482 | ||
|17 | |17 | ||
+ | | | ||
+ | | | ||
|- | |- | ||
|r6495 | |r6495 | ||
| | | | ||
|1085 | |1085 | ||
+ | | | ||
|- | |- | ||
|r6657 | |r6657 | ||
| | | | ||
|1086 | |1086 | ||
+ | | | ||
|- | |- | ||
|r6739 | |r6739 | ||
|18 | |18 | ||
+ | | | ||
+ | | | ||
|- | |- | ||
|r6773 | |r6773 | ||
| | | | ||
|1087 | |1087 | ||
+ | | | ||
|- | |- | ||
|r6865 | |r6865 | ||
| | | | ||
|1088 | |1088 | ||
+ | | | ||
|- | |- | ||
|r6896 | |r6896 | ||
| | | | ||
− | |1089 | + | |1089 |
+ | | | ||
|- | |- | ||
|r6996 | |r6996 | ||
| | | | ||
|1090 | |1090 | ||
+ | | | ||
|- | |- | ||
|r7052 | |r7052 | ||
| | | | ||
|1091 | |1091 | ||
+ | | | ||
|- | |- | ||
|r7156 | |r7156 | ||
| | | | ||
|1092 | |1092 | ||
+ | | | ||
|- | |- | ||
|r7223 | |r7223 | ||
Line 117: | Line 136: | ||
|r7453 | |r7453 | ||
|19 | |19 | ||
+ | | | ||
+ | | | ||
|- | |- | ||
|r7659 | |r7659 | ||
Line 135: | Line 156: | ||
|r7739 | |r7739 | ||
|20 | |20 | ||
+ | | | ||
+ | | | ||
|- | |- | ||
|r7757 | |r7757 | ||
Line 158: | Line 181: | ||
|r7883 | |r7883 | ||
|22 | |22 | ||
+ | | | ||
+ | | | ||
|- | |- | ||
|r7928 | |r7928 | ||
Line 236: | Line 261: | ||
|r8553 | |r8553 | ||
|23 | |23 | ||
+ | | | ||
+ | | | ||
|- | |- | ||
|r8617 | |r8617 | ||
|24 | |24 | ||
+ | | | ||
+ | | | ||
|- | |- | ||
|r8628 | |r8628 | ||
|25 | |25 | ||
+ | | | ||
+ | | | ||
|- | |- | ||
|r8643 | |r8643 | ||
Line 256: | Line 287: | ||
|26 | |26 | ||
|1123 | |1123 | ||
+ | | | ||
|- | |- | ||
|r8948 | |r8948 | ||
Line 300: | Line 332: | ||
| | | | ||
|... | |... | ||
+ | | | ||
|- | |- | ||
|0.20 | |0.20 | ||
|30 | |30 | ||
|1158 | |1158 | ||
+ | | | ||
|- | |- | ||
| | | | ||
| | | | ||
|... | |... | ||
+ | | | ||
|- | |- | ||
|0.20.1 | |0.20.1 | ||
|31 | |31 | ||
|1160 | |1160 | ||
+ | | | ||
|- | |- | ||
|0.20.2 | |0.20.2 | ||
|31 | |31 | ||
|1160 | |1160 | ||
+ | | | ||
|- | |- | ||
| | | | ||
| | | | ||
|... | |... | ||
+ | | | ||
|- | |- | ||
− | | | + | |{{changeset|14477}} |
|36 | |36 | ||
|1199 | |1199 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|14679}} | ||
+ | | | ||
+ | |1200 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|14748}} | ||
+ | | | ||
+ | |1201 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|15146}} | ||
+ | | | ||
+ | |1202 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|15257}} | ||
+ | | | ||
+ | |1203 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|15272}} | ||
+ | | | ||
+ | |1204 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|15276}} | ||
+ | | | ||
+ | |1205 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|15437}} | ||
+ | | | ||
+ | |1207 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|15483}} | ||
+ | | | ||
+ | |1208 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|15730}} | ||
+ | | | ||
+ | |1209 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|15900}} | ||
+ | | | ||
+ | |1210 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|15930}} | ||
+ | | | ||
+ | |1211 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|16167}} | ||
+ | | | ||
+ | |1212 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|16408}} | ||
+ | | | ||
+ | |1213 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|16446}} | ||
+ | | | ||
+ | |1214 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|16747}} | ||
+ | | | ||
+ | |1215 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|16790}} | ||
+ | | | ||
+ | |1218 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|16825}} | ||
+ | | | ||
+ | |1219 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|17182}} | ||
+ | | | ||
+ | |1220 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|17381}} | ||
+ | | | ||
+ | |1221 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|17832}} | ||
+ | | | ||
+ | |1222 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|18089}} | ||
+ | | | ||
+ | |1223 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|19149}} | ||
+ | | | ||
+ | |1224 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|19219}} | ||
+ | | | ||
+ | |1225 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|19220}} | ||
+ | | | ||
+ | |1226 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|19439}} | ||
+ | | | ||
+ | |1227 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|19500}} | ||
+ | | | ||
+ | |1228 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|20029}} | ||
+ | | | ||
+ | |1229 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|20037}} | ||
+ | | | ||
+ | |1230 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|20048}} | ||
+ | | | ||
+ | |1231 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|20067}} | ||
+ | | | ||
+ | |1232 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|20503}} | ||
+ | | | ||
+ | |1233 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|20652}} | ||
+ | | | ||
+ | |1235 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|20771}} | ||
+ | | | ||
+ | |1236 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|20911}} | ||
+ | | | ||
+ | |1237 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|20980}} | ||
+ | | | ||
+ | |1238 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|21115}} | ||
+ | | | ||
+ | |1239 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|21179}} | ||
+ | | | ||
+ | |1240 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|21186}} | ||
+ | | | ||
+ | |1241 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|21225}} | ||
+ | | | ||
+ | |1242 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|21565}} | ||
+ | | | ||
+ | |1243 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|21627}} | ||
+ | | | ||
+ | |1244 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|22789}} | ||
+ | | | ||
+ | |1245 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|22790}} | ||
+ | | | ||
+ | |1246 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|22932}} | ||
+ | | | ||
+ | |1247 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|23044}} | ||
+ | | | ||
+ | |1248 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|23106}} | ||
+ | | | ||
+ | |1249 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|23112}} | ||
+ | | | ||
+ | |1250 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|23159}} | ||
+ | | | ||
+ | |1251 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|23202}} | ||
+ | | | ||
+ | |1252 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|23362}} | ||
+ | | | ||
+ | |1253 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|23364}} | ||
+ | | | ||
+ | |1254 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|24694}} | ||
+ | | | ||
+ | |1255 | ||
+ | | | ||
+ | |- | ||
+ | |{{changeset|24722}} | ||
+ | | | ||
+ | |1256 | ||
+ | | | ||
|} | |} |
Revision as of 01:53, 21 May 2010
Outdated: The information on this page may no longer be relevant to the current release of MythTV, 34.0. Please consider helping to update it. This page was last modified on 2010-05-21.
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 | |
r6284 | 16 | ||
r6450 | 1084 | ||
r6482 | 17 | ||
r6495 | 1085 | ||
r6657 | 1086 | ||
r6739 | 18 | ||
r6773 | 1087 | ||
r6865 | 1088 | ||
r6896 | 1089 | ||
r6996 | 1090 | ||
r7052 | 1091 | ||
r7156 | 1092 | ||
r7223 | 1093 | No | |
1094 | A little | ||
r7240 | 1095 | A little | |
r7249 | 1095 | No | |
r7251 | 1096 | No | |
r7266 | 1097 | Yes (dropped tables 0.16 used) | |
r7300 | 1098 | No | |
r7429 | 1099 | A little (changed a record rule) | |
r7453 | 19 | ||
r7659 | 1100 | No | |
r7669 | 1101 | No | |
r7697 | 1102 | No | |
r7739 | 20 | ||
r7757 | 1103 | No | |
r7787 | 1104 | No | |
r7826 | 21 | 1105 | No |
r7863 | 1106 | A little (changed AutoExpireMethod=None) | |
r7883 | 22 | ||
r7928 | 1107 | Probably (changed types in inuseprograms) | |
r7965 | 1108 | No | |
r8025 | 1109 | No | |
r8029 | 1110 | No | |
r8058 | 1111 | No | |
r8071 | 1112 | A little (dropped tables 0.13 used) | |
r8072 | 1113 | A little (changed DailyWakeup) | |
r8105 | 1114 | No | |
r8109 | 1115 | No | |
r8111 | 1116 | No | |
r8113 | 1117 | No | |
r8114 | 1118 | Yes (removed column from caprurecard) | |
r8218 | 1119 | No | |
r8255 | 1120 | No | |
r8408 | 1121 | No | |
r8553 | 23 | ||
r8617 | 24 | ||
r8628 | 25 | ||
r8643 | 1122 | A little (widens a column) | |
r8907 | 1123 | No | |
0.19 | 26 | 1123 | |
r8948 | 1124 | No | |
r9022 | 1125 | No | |
r9029 | 1126 | No | |
r9081 | 1127 | Yes (dropped old table and columns) | |
r9149 | 1128 | No | |
r9270 | 1129 | Yes (dropped table, moved cutlist,markup) | |
r9300 | 1130 | No | |
r9342 | 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 |