Re: [Jwma-devel] 0.9.7 release

[Leonard S. <sit...@uc...>]

On Friday 31 January 2003 4:48 pm, Dieter Wimberger wrote:
>
> First is it DBA or DBE? And if A, what does it mean (E I suppose is
> engineer?)?

DBA = DataBase Administrator.  That's what I call someone who understands 
databases and SQL.  I suppose a DBA wouldn't know as much as a DBE.  :-)  So 
I'm much less that a DBE (= Database Engineer).

> Alright, well, the only problem with this might be artefacts on deletion of
> dependend objects (example = MailIdentities). You can check this out by
> creating and deleting identities, and see whether something remains in the
> database or troubles occur (within Castor or jwma code).

I'll check that.

>
> I suppose it needs INNODB to add statements for FOREIGN KEYS and
> CONSTRAINTS. See the SQL code Thomas committed.

I'm continuing to use the INNODB type here.  INNODB is one of the types that 
provides ACID (reliable transactions) for MySQL.

Sure looks like MySQL doesn't support those features.  Here are some examples 
from the MySQL manual:

"The FOREIGN KEY syntax in MySQL exists only for compatibility with other SQL 
vendors' CREATE TABLE commands; it doesn't do anything. "

Perhaps Thomas had it in there expecting that it would do something in some 
future release of MySQL, and he had prepared the database for it.

-- 
==Leonard E. Sitongia           
  Visualization and Enabling Technologies / Scientific Computing Division
  National Center for Atmospheric Research
  P.O. Box 3000 Boulder CO 80307  USA
  sit...@uc...    voice: (303)497-2454   fax: (303)497-1829