Problem: How to store following Data into a Database in a good, fast way.
Environment: Mysql->InnoDB


Data:
It´s some kind of layout....

Environment 	-> Content
			->Content
			->Content
				->Content
					[...]
		-> Content
		-> Content
			-> Content

Content is of various types.....like image, text, video, audio etc.
As Content is some layout they share some properties like Transparency, height, width etc.
But there are differences aswell of course, like Text, imageUrl, Video-Thumbnail etc.

So if i pack all possible propertiy fields into a table content, there might be a lot of null fields wich should be avoided afaik.

Additionally, each time the layout is saved, the old layout should be stored without loosing performance when selecting the current layout. (For this purpose i thought about Partitioning, with an "active" flasg and a version number on all Tables.)