DatabaseProtoTimeline

From MythTV Official Wiki
Revision as of 03:42, 27 September 2007 by NigelPearson (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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
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
...
trunk 36 1199