Re: database setup

[Dan Bachelder]

oh.. i dont think so... but maybe... I just went ahead and implemented it in
my peer classes... but i need to be able to change status fields instead of
doing a hard delete sometimes...

----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 02, 2001 10:50 AM
Subject: RE: database setup


> Sorry I meant specifying what to do on deletes and updates, for example
> cascade updates.
>
> -----Original Message-----
> From: Dan Bachelder [mailto:[EMAIL PROTECTED]]
> Sent: 02 November 2001 15:45
> To: Turbine Users List
> Subject: Re: database setup
>
>
> sure is:
>
>     <table name="CONTACT_PROJECT">
>         <column name="PROJECT_ID" required="true" primaryKey="true"
> type="INTEGER"/>
>         <column name="CONTACT_ID" required="true" primaryKey="true"
> type="INTEGER"/>
>
>         <foreign-key foreignTable="PROJECT">
>           <reference local="PROJECT_ID" foreign="PROJECT_ID"/>
>         </foreign-key>
>         <foreign-key foreignTable="CONTACT">
>           <reference local="CONTACT_ID" foreign="CONTACT_ID"/>
>         </foreign-key>
>     </table>
>
>     <table name="PROJECT">
>         <column name="PROJECT_ID" required="true" primaryKey="true"
> type="INTEGER"/>
>     </table>
>
>     <table name="CONTACT">
>         <column name="CONTACT_ID" required="true" primaryKey="true"
> type="INTEGER"/>                </table>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, November 02, 2001 10:41 AM
> Subject: database setup
>
>
> > Hi,
> >
> > Is it possible to specify referential integrity rules for foreign keys
in
> > the project xml schema?
> >
> > Paul
> >
> > --
> > To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
> >
> >
>
>
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
> --
> To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
>
>


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>