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 "Juliano Julio (JIRA)" <ji...@apache.org> on 2005/11/14 20:54:27 UTC

[jira] Created: (DDLUTILS-48) Some columns may be UNIQUE

Some columns may be UNIQUE
--------------------------

         Key: DDLUTILS-48
         URL: http://issues.apache.org/jira/browse/DDLUTILS-48
     Project: DdlUtils
        Type: Improvement
    Reporter: Juliano Julio
 Assigned to: Thomas Dudziak 


Some columns must be assigned as unique, this statement is part of the ANSI SQL and a UNIQUE COLUMN MUST be NOT NULL too...

So we need a method setUnique(boolean) on Column class...

-- 
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-48) Some columns may be UNIQUE

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

    Resolution: Won't Fix

In DdlUtils, the unique constraint is modelled via a special unique index:

<table name="book">
    <column name="book_id"
            type="INTEGER"
            required="true"
            primaryKey="true"
            autoIncrement="true"/>
    <column name="isbn"
            type="VARCHAR"
            size="15"
            required="true"/>
    <unique name="book_isbn">
      <unique-column name="isbn"/>
    </index>
  </table>

> Some columns may be UNIQUE
> --------------------------
>
>          Key: DDLUTILS-48
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-48
>      Project: DdlUtils
>         Type: Improvement
>     Reporter: Juliano Julio
>     Assignee: Thomas Dudziak

>
> Some columns must be assigned as unique, this statement is part of the ANSI SQL and a UNIQUE COLUMN MUST be NOT NULL too...
> So we need a method setUnique(boolean) on Column class...

-- 
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] Commented: (DDLUTILS-48) Some columns may be UNIQUE

Posted by "Tormod Ă˜verlier (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DDLUTILS-48?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12650129#action_12650129 ] 

Tormod Ă˜verlier commented on DDLUTILS-48:
-----------------------------------------

Why is this a "Won't Fix" issue? It's a pretty important feature to us.

> Some columns may be UNIQUE
> --------------------------
>
>                 Key: DDLUTILS-48
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-48
>             Project: DdlUtils
>          Issue Type: Improvement
>            Reporter: Juliano Julio
>            Assignee: Thomas Dudziak
>
> Some columns must be assigned as unique, this statement is part of the ANSI SQL and a UNIQUE COLUMN MUST be NOT NULL too...
> So we need a method setUnique(boolean) on Column class...

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.