Using a better normalized database about film-night HOT 4 CLOSED

I'm happy to make a films2 database, and effectively start the DB from scratch, but as you say, it's the data migration that is a lot of effort.

from film-night.

I made a pretty picture, mostly for my reference if I do end up doing this, and because I have work to do so I had to find something else to do instead.

from film-night.

Very nice. Perhaps worth including things like the current user id etc. We will still need this for logging in. Happy to give you an account on the pis with access to the DB if you like.

from film-night.

Ah, yeah, of course. I'd move all the user settings, etc. into the users table too, and possibly the film info that's currently put in selected_films by imdb.php into the films table. Was just mostly including the fields necessary for all the linking to work etc.
Sounds good - typical that I think to do this right at the point where I've got the most work I've had all term though... I'll look further into it at some point next week once I've got all these sheets out the way.

from film-night.