Donate Share

PHP Gift Registry

Tracker: Bugs

5 drop tables before creating them - ID: 1020588
Last Update: Comment added ( generalpf )

In create-phpgiftregdb.sql, you should do a "DROP TABLE
foo;" before the "CREATE TABLE foo;" so you don't get
an error if it already exists.

This allows one to quickly reset the database to the
pristine state. This is dangerous, but if someone is
running this script, I think this is what they expect
to happen.

Also, I'd prefer a shorter name to this file... ;)


James E. Pace ( jepace ) - 2004-09-01 17:36

5

Closed

Wont Fix

Nobody/Anonymous

None

None

Public


Comment ( 1 )




Date: 2004-09-03 17:03
Sender: generalpfProject Admin

Logged In: YES
user_id=1044557

The idea is that you wouldn't be running the script if the
database already exists. Upgrades are performed by separate
upgrade scripts.

If you wanted a "pristine state", drop the DB then recreate it.


Log in to comment.

Attached File

No Files Currently Attached

Changes ( 3 )

Field Old Value Date By
status_id Open 2004-09-03 17:03 generalpf
resolution_id None 2004-09-03 17:03 generalpf
close_date - 2004-09-03 17:03 generalpf