[dev] Database creation

[Jon Parise]

On Wed, Mar 21, 2001 at 05:11:57PM -0600, Brent J. Nordquist wrote:

> (1)  The same SQL won't work with every database vendor, will it?  (Looks
> they'll work with PostgreSQL and MySQL as they are, but there are issues
> like FKs, constraints, etc. with Oracle/Sybase... not to mention line
> termination.)  If not, should there be separate ones by vendor, as in 2.2,
> or perhaps auto-generated from a template and script?

I think they SQL contained therein is generic, but I may be wrong.
 
> (2)  Shouldn't at least these tables be under horde/scripts/db rather than
> imp/scripts/db?

That makes sense.
 
> (3)  Is the intent to also provide a script for creating the enclosing
> database and user, as we did with 2.2?  And documentation...

I don't have any such plans, personally, but it's probably a good
idea.
 
> I want to set up SQL-based preferences for the first time, and I'd be
> willing to fill in these pieces for HEAD if the above sounds right.
 
Neat. =)

-- 
Jon Parise (jon@csh.rit.edu)  .  Rochester Inst. of Technology
http://www.csh.rit.edu/~jon/  :  Computer Science House Member