PDA

View Full Version : Adding fields to database . . . structure codes ?


Pidea
08-24-2006, 03:11 PM
In includes/tables.php the database structure is defined in a kind of abbreviated SQL syntax:

Content visible to registered users only.


I'm trying to add some additional fields to the database but can't find a list of these. In particular I'm trying to work out what the code for an enumerated field would be. Are there any resources on-line ?

Ta

David
08-24-2006, 06:32 PM
I'll see what we could come up with.

Pidea
08-24-2006, 09:56 PM
Thanks David.

Boby
08-25-2006, 09:19 PM
This could be of great help ;)
ADOdb Data Dictionary Library (http://phplens.com/lens/adodb/docs-datadict.htm)

Just run through the installer again after adding more fields to the DB via tables.php file.

Boby

Pidea
08-25-2006, 10:28 PM
Excellent, thank you. That's exactly what I was looking for.

Now to get coding :)