Fix up foreign key from videos to announcements
authorMatt S Trout <mst@shadowcat.co.uk>
Mon, 18 Jan 2010 01:19:33 +0000 (01:19 +0000)
committerMatt S Trout <mst@shadowcat.co.uk>
Mon, 18 Jan 2010 01:19:33 +0000 (01:19 +0000)
commit6c3eb3ebf271748e0fc86848f01137a1ce5f5f99
tree874ba05a78019016a1f8f489dafca9ed4f665884
parent0ab4fd2ebf0f9745b2a8eb1f8f53357eb7ce4690
Fix up foreign key from videos to announcements

All videos should be attached to an announcement from the same bucket,
so make the schema enforce that. One could probably argue that this means
that bucket_slug doesn't need to exist in the videos table but in my
opinion one would be dead wrong :) - the bucket is an integral part of the
video so while it's sort of duplication, it isn't denormalisation.
share/sql/idiotbox-1.0-sqlite.sql