Page 1 of 1
Table Creation Script
Posted: Mon Jul 11, 2005 1:46 am
by 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
Re: Table Creation Script
Posted: Mon Jul 11, 2005 1:58 am
by 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.
Re: Table Creation Script
Posted: Mon Jul 11, 2005 2:31 am
by 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
Re: Table Creation Script
Posted: Mon Jul 11, 2005 10:05 am
by 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