Hi,
I created simple entity with two properties: code and name.
public class Country extends BaseUuidEntity implements Updatable, Creatable {
@NotNull
@Column(name = "CODE", nullable = false, unique = true, length = 2)
protected java.lang.String code;
@NotNull
@Column(name = "NAME", nullable = false, unique = true)
protected java.lang.String name;
...
}
Studio generated sql scripts for mssql like this:
INIT:
create table APP_COUNTRY (
primary key nonclustered (ID)
)^
create unique index IDX_APP_COUNTRY_UNIQ_NAME on APP_COUNTRY (NAME) ^
create unique index IDX_APP_COUNTRY_UNIQ_CODE on APP_COUNTRY (CODE) ^
UPDATE:
create table APP_COUNTRY (
primary key nonclustered (ID)
);
create unique index IDX_APP_COUNTRY_UNIQ_NAME on APP_COUNTRY (NAME);
create unique index IDX_APP_COUNTRY_UNIQ_CODE on APP_COUNTRY (CODE);
First problem:
Studio not genereted columns for properties: code and name in sql scripts
Second problem:
updateDb throws exception: Incorrect syntax near ‘)’. on sql query:
create table APP_COUNTRY (
primary key nonclustered (ID)
);
Regards
Marcin