Great scheme indeed. The only thing I'd like to suggest is to have numbers (ID) as primary keys everywhere. Currently he "questiontemplates" tbl has only varchar. Will have to look further, though :-).

Also,  if some custom solution will require additional tables, the "native" tables should be kept (for the sake of compatibility). This is what I'm doing now, btw.
Do you think there can be a universal/recommended way for adding these custom tables?

As to object structure, well, I probably can participate, but don't feel myself familiar enough with PHPSurveyor yet to *start* this.

On 5/10/07, Carsten Schmitz <> wrote:

In response to the thread about v2.0 lately and a conversation I had
with Thibault this evening I thought it would be a good idea to show off
the db design I did for v2.0 some time ago. (At that time i had already
planned the language feature that is now in v1.0.) Alot of things are
still missing but its a start.

You can find this scheme in the subversion repository too.. Its made
with mySQL Workbench Designer.

As said.. its not complete but I will work on it in the next few days.

My question is if anybody would like to lay out the object structure
needed ?
That person would not be alone. We would be discussing regularly about
it and so make the best out of it.

Anyone interested?



This email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
PHPSurveyor-Developers mailing list