[drupal-devel] [feature] Database Table Creation Script

[danielc]

Issue status update for http://drupal.org/node/20530

 Project:      Drupal
 Version:      cvs
 Component:    base system
 Category:     feature requests
 Priority:     normal
 Assigned to:  Anonymous
 Reported by:  danielc
 Updated by:   danielc
 Status:       patch

Nate:


> it worked fine.


Good.


> add a way to specify which sites to create tables for


Simple.  Temporarily those directories out of /drupal/sites.  Though
that would cause problems for live sites.


> The easiest way of doing this might be to just change the error
> handling if a table creation fails. Instead of stopping, it could
> just ignore the error and continue.


An interesting thought.




danielc



Previous comments:
------------------------------------------------------------------------

April 14, 2005 - 19:27 : danielc

Attachment: http://drupal.org/files/issues/create.php.v1.txt (11.43 KB)

Attached is a PHP script that creates all of the database tables for all
sites in /drupal/sites/*.


It works with CVS checkouts of either HEAD or the DRUPAL-4-6 branch as
of 2005-04-14 19:00 UTC.


Until it gets added to CVS, you can use it by saving the latest version
of the file from this page, rename it "create.php" and put it in the
"/drupal/database" directory.  Then either execute it from the command
line or point your web browser to it.  For exact usage instructions,
read the documentation inside the script.




------------------------------------------------------------------------

April 17, 2005 - 13:21 : nkurz

Thanks Daniel!


I got it, used it, and it worked fine.  Documentation and instructions
were very clear.  I had to modify a bit because I had already created
the set of tables for my 'default' site,  so at first it failed because
the 'access' table already existed.  I got around this by just putting
in a hardcoded test for 'if ($site == 'default') {continue;}, but
obviously this isn't a general solution.


It would probably be good (if you are interested in making this more
generally useful) to add a way to specify which sites to create tables
for, or alternatively which sites to ignore creating tables for.  I'm
guessing that many people (like me) are going to want something like
this when the add a new site, and not only when there are setting up a
new system.  The easiest way of doing this might be to just change the
error handling if a table creation fails.  Instead of stopping, it
could just ignore the error and continue.


--nate