[Phpwiki-talk] Separating create and destroy SQL

[Dan F. <dfr...@cs...>]

Folks,

A user of mine accidentally blew away his Wiki, and was sad. Long story, 
but suffice it to say that

mysql -u user -D db -p password < mysql.sql

doesn't apply mysql.sql to the "db" database, it applies it to the 
"password" database!!

There are, of course, several safeguards one could take (e.g., don't 
have a database called "password"). However, another safeguard would be 
to separate the DROP statements and CREATE statements. Then he would've 
just applied the CREATE statements, it wouldn't have worked, and he'd 
have been puzzled but not sad.

Thus, he submitted the attached files for phpwiki/schemas. I hope you 
will take these changes. If you do, then also

cd phpwiki/schemas
rm minisql.sql mysql.sql psql.sql sqlite.sql
cvs rm minisql.sql mysql.sql psql.sql sqlite.sql
cvs commit minisql.sql mysql.sql psql.sql sqlite.sql

Dan