Difference between revisions of "DatabaseProtoTimeline"

From MythTV Official Wiki
Jump to: navigation, search
(add schema change revisions)
 
Line 1: Line 1:
−
{{outdated}}
 
 
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.
 
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.
  
Line 34: Line 33:
 
|
 
|
 
|-
 
|-
−
|r6284
+
|{{changeset|6284}}
 
|16
 
|16
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|r6450
+
|{{changeset|6450}}
 
|
 
|
 
|1084
 
|1084
 
|
 
|
 
|-
 
|-
−
|r6482
+
|{{changeset|6482}}
 
|17
 
|17
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|r6495
+
|{{changeset|6495}}
 
|
 
|
 
|1085
 
|1085
 
|
 
|
 
|-
 
|-
−
|r6657
+
|{{changeset|6657}}
 
|
 
|
 
|1086
 
|1086
 
|
 
|
 
|-
 
|-
−
|r6739
+
|{{changeset|6739}}
 
|18
 
|18
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|r6773
+
|{{changeset|6773}}
 
|
 
|
 
|1087
 
|1087
 
|
 
|
 
|-
 
|-
−
|r6865
+
|{{changeset|6865}}
 
|
 
|
 
|1088
 
|1088
 
|
 
|
 
|-
 
|-
−
|r6896
+
|{{changeset|6896}}
 
|
 
|
 
|1089
 
|1089
 
|  
 
|  
 
|-
 
|-
−
|r6996
+
|{{changeset|6996}}
 
|
 
|
 
|1090
 
|1090
 
|
 
|
 
|-
 
|-
−
|r7052
+
|{{changeset|7052}}
 
|
 
|
 
|1091
 
|1091
 
|
 
|
 
|-
 
|-
−
|r7156
+
|{{changeset|7156}}
 
|
 
|
 
|1092
 
|1092
 
|
 
|
 
|-
 
|-
−
|r7223
+
|{{changeset|7223}}
 
|
 
|
 
|1093
 
|1093
Line 104: Line 103:
 
|A little
 
|A little
 
|-
 
|-
−
|r7240
+
|{{changeset|7240}}
 
|
 
|
 
|1095
 
|1095
 
|A little
 
|A little
 
|-
 
|-
−
|r7249
+
|{{changeset|7249}}
 
|
 
|
 
|1095
 
|1095
 
|No
 
|No
 
|-
 
|-
−
|r7251
+
|{{changeset|7251}}
 
|
 
|
 
|1096
 
|1096
 
|No
 
|No
 
|-
 
|-
−
|r7266
+
|{{changeset|7266}}
 
|
 
|
 
|1097
 
|1097
 
|Yes (dropped tables 0.16 used)
 
|Yes (dropped tables 0.16 used)
 
|-
 
|-
−
|r7300
+
|{{changeset|7300}}
 
|
 
|
 
|1098
 
|1098
 
|No
 
|No
 
|-
 
|-
−
|r7429
+
|{{changeset|7429}}
 
|
 
|
 
|1099
 
|1099
 
|A little (changed a record rule)
 
|A little (changed a record rule)
 
|-
 
|-
−
|r7453
+
|{{changeset|7453}}
 
|19
 
|19
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|r7659
+
|{{changeset|7659}}
 
|
 
|
 
|1100
 
|1100
 
|No
 
|No
 
|-
 
|-
−
|r7669
+
|{{changeset|7669}}
 
|
 
|
 
|1101
 
|1101
 
|No
 
|No
 
|-
 
|-
−
|r7697
+
|{{changeset|7697}}
 
|
 
|
 
|1102
 
|1102
 
|No
 
|No
 
|-
 
|-
−
|r7739
+
|{{changeset|7739}}
 
|20
 
|20
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|r7757
+
|{{changeset|7757}}
 
|
 
|
 
|1103
 
|1103
 
|No
 
|No
 
|-
 
|-
−
|r7787
+
|{{changeset|7787}}
 
|
 
|
 
|1104
 
|1104
 
|No
 
|No
 
|-
 
|-
−
|r7826
+
|{{changeset|7826}}
 
|21
 
|21
 
|1105
 
|1105
 
|No
 
|No
 
|-
 
|-
−
|r7863
+
|{{changeset|7863}}
 
|
 
|
 
|1106
 
|1106
 
|A little (changed AutoExpireMethod=None)
 
|A little (changed AutoExpireMethod=None)
 
|-
 
|-
−
|r7883
+
|{{changeset|7883}}
 
|22
 
|22
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|r7928
+
|{{changeset|7928}}
 
|
 
|
 
|1107
 
|1107
 
|Probably (changed types in inuseprograms)
 
|Probably (changed types in inuseprograms)
 
|-
 
|-
−
|r7965
+
|{{changeset|7965}}
 
|
 
|
 
|1108
 
|1108
 
|No
 
|No
 
|-
 
|-
−
|r8025
+
|{{changeset|8025}}
 
|
 
|
 
|1109
 
|1109
 
|No
 
|No
 
|-
 
|-
−
|r8029
+
|{{changeset|8029}}
 
|
 
|
 
|1110
 
|1110
 
|No
 
|No
 
|-
 
|-
−
|r8058
+
|{{changeset|8058}}
 
|
 
|
 
|1111
 
|1111
 
|No
 
|No
 
|-
 
|-
−
|r8071
+
|{{changeset|8071}}
 
|
 
|
 
|1112
 
|1112
 
|A little (dropped tables 0.13 used)
 
|A little (dropped tables 0.13 used)
 
|-
 
|-
−
|r8072
+
|{{changeset|8072}}
 
|
 
|
 
|1113
 
|1113
 
|A little (changed DailyWakeup)
 
|A little (changed DailyWakeup)
 
|-
 
|-
−
|r8105
+
|{{changeset|8105}}
 
|
 
|
 
|1114
 
|1114
 
|No
 
|No
 
|-
 
|-
−
|r8109
+
|{{changeset|8109}}
 
|
 
|
 
|1115
 
|1115
 
|No
 
|No
 
|-
 
|-
−
|r8111
+
|{{changeset|8111}}
 
|
 
|
 
|1116
 
|1116
 
|No
 
|No
 
|-
 
|-
−
|r8113
+
|{{changeset|8113}}
 
|
 
|
 
|1117
 
|1117
 
|No
 
|No
 
|-
 
|-
−
|r8114
+
|{{changeset|8114}}
 
|
 
|
 
|1118
 
|1118
 
|Yes (removed column from caprurecard)
 
|Yes (removed column from caprurecard)
 
|-
 
|-
−
|r8218
+
|{{changeset|8218}}
 
|
 
|
 
|1119
 
|1119
 
|No
 
|No
 
|-
 
|-
−
|r8255
+
|{{changeset|8255}}
 
|
 
|
 
|1120
 
|1120
 
|No
 
|No
 
|-
 
|-
−
|r8408
+
|{{changeset|8408}}
 
|
 
|
 
|1121
 
|1121
 
|No
 
|No
 
|-
 
|-
−
|r8553
+
|{{changeset|8553}}
 
|23
 
|23
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|r8617
+
|{{changeset|8617}}
 
|24
 
|24
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|r8628
+
|{{changeset|8628}}
 
|25
 
|25
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|r8643
+
|{{changeset|8643}}
 
|
 
|
 
|1122
 
|1122
 
|A little (widens a column)
 
|A little (widens a column)
 
|-
 
|-
−
|r8907
+
|{{changeset|8907}}
 
|
 
|
 
|1123
 
|1123
Line 289: Line 288:
 
|
 
|
 
|-
 
|-
−
|r8948
+
|{{changeset|8948}}
 
|
 
|
 
|1124
 
|1124
 
|No
 
|No
 
|-
 
|-
−
|r9022
+
|{{changeset|9022}}
 
|
 
|
 
|1125
 
|1125
 
|No
 
|No
 
|-
 
|-
−
|r9029
+
|{{changeset|9029}}
 
|
 
|
 
|1126
 
|1126
 
|No
 
|No
 
|-
 
|-
−
|r9081
+
|{{changeset|9081}}
 
|
 
|
 
|1127
 
|1127
 
|Yes (dropped old table and columns)
 
|Yes (dropped old table and columns)
 
|-
 
|-
−
|r9149
+
|{{changeset|9149}}
 
|
 
|
 
|1128
 
|1128
 
|No
 
|No
 
|-
 
|-
−
|r9270
+
|{{changeset|9270}}
 
|
 
|
 
|1129
 
|1129
 
|Yes (dropped table, moved cutlist,markup)
 
|Yes (dropped table, moved cutlist,markup)
 
|-
 
|-
−
|r9300
+
|{{changeset|9300}}
 
|
 
|
 
|1130
 
|1130
 
|No
 
|No
 
|-
 
|-
−
|r9342
+
|{{changeset|9342}}
 
|
 
|
 
|1131
 
|1131
Line 627: Line 626:
 
|
 
|
 
|1256
 
|1256
 +
|
 +
|-
 +
|{{changeset|24819}}
 +
|
 +
|1257
 +
|
 +
|-
 +
|{{changeset|24840}}
 +
|
 +
|1258
 +
|
 +
|-
 +
|{{changeset|24869}}
 +
|
 +
|1259
 
|
 
|
 
|}
 
|}
 +
 +
[[Category:Developer Documentation]]

Latest revision as of 18:58, 16 July 2010

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
Retrieved from "http://www.mythtv.org/wiki?title=DatabaseProtoTimeline&oldid=47011"