dhis2-devs team mailing list archive

Thread
Date

Re: Stored procedure to remove the foreign key 'sourceid'

To: Hieu Dang Duy <hieu.hispvietnam@xxxxxxxxx>
From: Orvalho Augusto <orvaquim@xxxxxxxxx>
Date: Fri, 1 Jul 2011 12:40:03 +0200
Cc: DHIS Users <dhis-users@xxxxxxxxx>, Dhis2 <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <BANLkTikKNc4cweqQcdFYWHqu+pGpxO+COQ@mail.gmail.com>

This is nice!!!

But it would be good if add a parameter for to select the DHIS
database. Anyway for MySQL people they can understand where to
correct.

Thanks
Caveman


On 7/1/11, Hieu Dang Duy <hieu.hispvietnam@xxxxxxxxx> wrote:
> Hello all,
>
> I have written down a stored procedure to remove all of the foreign keys
> which is being referenced into Source (sourceid).
>
> Hope this useful for who still getting the trouble in source id reference.
>
> P.S: This is used for MySQL.
>
> --
> Good heath !
>

References

Stored procedure to remove the foreign key 'sourceid'
From: Hieu Dang Duy, 2011-07-01