Multiple version webpages database design ideas

Associate
Joined
6 Jan 2006
Posts
1,025
Location
Midlands
I have been given the task of design a content managed website with multiple version of each page.

Each page will have an english version and french version and the user can select between the two with links.

Each version is created by the user manually using FCKeditor, so no auto translation is involved.

I need help to figure out the best way to manage/store the pages in a database.

Do i just need two tables, one to store the page general info i.e. title and reference IDs to the french and english versions on another table which has the webpage content.

Any better solutions?
 
Back
Top Bottom