Table Creation Script

[sagarkale]

Hi,

I was wondering if there is any script to generate table creation php file? I am refereing to the file /Install/schemas/schema.php. It would be great to generate this type of file than everytime manually update.

Thanx in advance.

Regards,

Sagar

[Ted]

Not totally sure what you mean.  To generate schema.php, I use the generatedump.php script that is in the svn repository.  I then modify it with some search/replace.  Takes about 5-10 min total.

[sagarkale]

Thanx for the reply Wishy,

I think u got it right. I have a system I work on & updating its install program is always trouble because I have to keep track of changes in chema. I saw schema in CMS & thought if you guys use any script to generate this file.

Please let me know if such script exists?

Regards,

Sagar

[Ted]

Here is the script I use.  It's nothing fancy.  Just dumps all of the tables in the databse...

http://svn.cmsmadesimple.org/cms/trunk/generatedump.php