Revision fbe4a666
Added by Andreas Müller over 12 years ago
cdmlib-persistence/src/test/resources/dbscripts/001_cdm.ddl | ||
---|---|---|
3183 | 3183 |
primary key (id, REV) |
3184 | 3184 |
); |
3185 | 3185 |
|
3186 |
create table PolytomousKeyNode_LanguageString ( |
|
3187 |
PolytomousKeyNode_id integer not null, |
|
3188 |
modifyingtext_id integer not null, |
|
3189 |
modifyingtext_mapkey_id integer not null, |
|
3190 |
primary key (PolytomousKeyNode_id, modifyingtext_mapkey_id), |
|
3191 |
unique (modifyingtext_id) |
|
3192 |
) |
|
3193 |
|
|
3194 |
create table PolytomousKeyNode_LanguageString_AUD ( |
|
3195 |
REV integer not null, |
|
3196 |
revtype tinyint, |
|
3197 |
PolytomousKeyNode_id integer not null, |
|
3198 |
modifyingtext_id integer not null, |
|
3199 |
modifyingtext_mapkey_id integer not null, |
|
3200 |
primary key (REV, PolytomousKeyNode_id, modifyingtext_id, modifyingtext_mapkey_id) |
|
3201 |
) |
|
3202 |
|
|
3186 | 3203 |
create table PolytomousKeyNode_PolytomousKeyNode_AUD( |
3187 | 3204 |
id integer not null, |
3188 | 3205 |
REV integer not null, |
... | ... | |
7414 | 7431 |
foreign key (grantedauthorities_id) |
7415 | 7432 |
references GrantedAuthorityImpl; |
7416 | 7433 |
|
7434 |
alter table PolytomousKeyNode_LanguageString |
|
7435 |
add constraint FK5574E12EF05D08D4 |
|
7436 |
foreign key (modifyingtext_id) |
|
7437 |
references LanguageString; |
|
7438 |
|
|
7439 |
alter table PolytomousKeyNode_LanguageString |
|
7440 |
add constraint FK5574E12EF135C42B |
|
7441 |
foreign key (PolytomousKeyNode_id) |
|
7442 |
references PolytomousKeyNode; |
|
7443 |
|
|
7444 |
alter table PolytomousKeyNode_LanguageString |
|
7445 |
add constraint FK5574E12E9682414B |
|
7446 |
foreign key (modifyingtext_mapkey_id) |
|
7447 |
references DefinedTermBase; |
|
7448 |
|
|
7449 |
|
|
7417 | 7450 |
alter table PolytomousKey_NamedArea |
7418 | 7451 |
add constraint FK1C727CFF3FF8E7B2 |
7419 | 7452 |
foreign key (geographicalscope_id) |
Also available in: Unified diff
remove PolytomousKeyNode_LanguageString from cdm.ddl for tests