[dev] Do we need database scripts?

[Chuck Hagenbuch]

Quoting Rich Lafferty <rich@horde.org>:

> That I'm encountering much difficulty documenting the
> database-creation steps of Horde suggests to me that 
> there's something missing.
> 
> What shall we do? Right now, the bits in scripts/db/
> are written for developers. :-) I like having scripts available, but I
> think we need more duplication -- instead of separate files for auth
> and prefs and so on, I'd like to provide scripts that do everything
> for a particular database -- i.e., a "mysql-create.sql" and a
> "pgsql-create.sql" and so on, instead of "prefs.sql" and friends.
> 
> Does that seem like a good approach? 

Alright, this is slightly more work-intensive, but:

What about every app that uses SQL includes scripts for the table creation that
a generic Horde tool can use to create those tables? We're not going to write
ourselves phpMyAdmin, but something to manage tables could be really useful...

We could even pretty easily have it handle db-specific scripts/exceptions.

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
"What was and what may be, lie, like children whose faces we cannot see, in the
arms of silence. All we ever have is here, now." - Ursula K. Le Guin