You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Xavier TROUSSICOT (JIRA)" <ji...@apache.org> on 2005/10/11 14:18:06 UTC

[jira] Created: (DDLUTILS-26) MySQL drop foreign key

MySQL drop foreign key
----------------------

         Key: DDLUTILS-26
         URL: http://issues.apache.org/jira/browse/DDLUTILS-26
     Project: DdlUtils
        Type: Bug
    Reporter: Xavier TROUSSICOT
 Assigned to: Thomas Dudziak 


The writeExternalForeignKeyDropStmt method needs to be overriden in MySqlBuilder class :

    protected void writeExternalForeignKeyDropStmt(Table table, ForeignKey foreignKey) throws IOException
    {
        writeTableAlterStmt(table);
        print("DROP FOREIGN KEY ");
        printIdentifier(foreignKey.getName() == null ? getConstraintName(null, table, "FK", getForeignKeyName(foreignKey)) : foreignKey.getName());
        printEndOfStatement();
    }

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Resolved: (DDLUTILS-26) MySQL drop foreign key

Posted by "Martin van den Bemt (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/DDLUTILS-26?page=all ]
     
Martin van den Bemt resolved DDLUTILS-26:
-----------------------------------------

    Resolution: Fixed

Your fix (with some changes) is in svn now. 
Mysql integration is currently being tested, so if you hit some issues, please let us know.

> MySQL drop foreign key
> ----------------------
>
>          Key: DDLUTILS-26
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-26
>      Project: DdlUtils
>         Type: Bug
>     Reporter: Xavier TROUSSICOT
>     Assignee: Thomas Dudziak

>
> The writeExternalForeignKeyDropStmt method needs to be overriden in MySqlBuilder class :
>     protected void writeExternalForeignKeyDropStmt(Table table, ForeignKey foreignKey) throws IOException
>     {
>         writeTableAlterStmt(table);
>         print("DROP FOREIGN KEY ");
>         printIdentifier(foreignKey.getName() == null ? getConstraintName(null, table, "FK", getForeignKeyName(foreignKey)) : foreignKey.getName());
>         printEndOfStatement();
>     }

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Updated: (DDLUTILS-26) MySQL drop foreign key

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/DDLUTILS-26?page=all ]

Thomas Dudziak updated DDLUTILS-26:
-----------------------------------

    Component: Core - MySql

> MySQL drop foreign key
> ----------------------
>
>          Key: DDLUTILS-26
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-26
>      Project: DdlUtils
>         Type: Bug

>   Components: Core - MySql
>     Reporter: Xavier TROUSSICOT
>     Assignee: Thomas Dudziak

>
> The writeExternalForeignKeyDropStmt method needs to be overriden in MySqlBuilder class :
>     protected void writeExternalForeignKeyDropStmt(Table table, ForeignKey foreignKey) throws IOException
>     {
>         writeTableAlterStmt(table);
>         print("DROP FOREIGN KEY ");
>         printIdentifier(foreignKey.getName() == null ? getConstraintName(null, table, "FK", getForeignKeyName(foreignKey)) : foreignKey.getName());
>         printEndOfStatement();
>     }

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira