The new picture data scheme for the site is in place.

Previously, there was no structure to how the pictures were stored. (By pictures, I mean the pictures used for the Tours, as well as the fallen flags and other pictures.) The picture data was scattered throughout three different tables with no correlation to each other.

Now, all the pictures are stored in a central database table, along with their description and orientation. All the pages go through a linking table to access the pictures, thus each feature will ultimately access the same picture record, albeit through different means. While this means more intensive code on the server (going through three or four tables to get to the picture instead of just one or two), it also means that adding pictures in the future will be a whole lot simpler by just adding it to the feature(s) it should be presented in.

We'll see how well it works out.