An identity column should be an primary key
---
Key: DDLUTILS-47
URL: http://issues.apache.org/jira/browse/DDLUTILS-47
Project: DdlUtils
Type: Bug
Environment: Tested on Hsql and Derby
Reporter: Juliano Julio
Assigned
[
http://issues.apache.org/jira/browse/DDLUTILS-47?page=comments#action_12357612
]
Juliano Julio commented on DDLUTILS-47:
---
Without primary keys, there is no foreign keys, so the FOREIGN KEY statment
always return an error...
An identity column
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
[ 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
[
http://issues.apache.org/jira/browse/DDLUTILS-47?page=comments#action_12357622
]
Juliano Julio commented on DDLUTILS-47:
---
Exactly! That is the point! If I setPrimaryKey(true) and setAutoincrement(true)
this suppose to generate:
create table