Project

General

Profile

« Previous | Next » 

Revision fbe4a666

Added by Andreas Müller over 12 years ago

remove PolytomousKeyNode_LanguageString from cdm.ddl for tests

View differences:

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