-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
executable file
·155 lines (132 loc) · 4.7 KB
/
ext_tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
#
# Table structure for table 'tx_dmnorm_domain_model_work'
#
CREATE TABLE tx_dmnorm_domain_model_gndwork (
firstcomposer int(11) unsigned DEFAULT '0' NOT NULL,
gnd_id varchar(255) DEFAULT '' NOT NULL,
generic_title varchar(255) DEFAULT '' NOT NULL,
individual_title varchar(255) DEFAULT '' NOT NULL,
date_of_production date DEFAULT NULL,
geographic_area_code varchar(255) DEFAULT '' NOT NULL,
opus_no varchar(255) DEFAULT '' NOT NULL,
index_no varchar(255) DEFAULT '' NOT NULL,
tonality varchar(255) DEFAULT '' NOT NULL,
title_no varchar(255) DEFAULT '' NOT NULL,
title_instrument varchar(255) DEFAULT '' NOT NULL,
alt_titles text,
language varchar(255) DEFAULT '' NOT NULL,
instrument_ids varchar(255) DEFAULT '' NOT NULL,
alt_instrument_names varchar(255) DEFAULT '' NOT NULL,
genre_ids varchar(255) DEFAULT '' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
full_title varchar(255) DEFAULT '' NOT NULL,
intertextual_entity int(11) unsigned DEFAULT '0',
super_work int(11) unsigned DEFAULT '0',
instruments int(11) unsigned DEFAULT '0' NOT NULL,
gnd_genres int(11) unsigned DEFAULT '0' NOT NULL,
medium_of_performance int(11) unsigned DEFAULT '0',
main_instrumentation int(11) unsigned DEFAULT '0'
);
#
# Table structure for table 'tx_dmnorm_domain_model_person'
#
CREATE TABLE tx_dmnorm_domain_model_gndperson (
gnd_id varchar(255) DEFAULT '' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
date_of_birth date DEFAULT NULL,
date_of_death date DEFAULT NULL,
geographic_area_code varchar(255) DEFAULT '' NOT NULL,
gender varchar(255) DEFAULT '' NOT NULL,
works int(11) unsigned DEFAULT '0' NOT NULL,
place_of_birth int(11) unsigned DEFAULT '0',
place_of_death int(11) unsigned DEFAULT '0',
place_of_activity int(11) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_dmnorm_domain_model_gndinstrument'
#
CREATE TABLE tx_dmnorm_domain_model_gndinstrument (
name varchar(255) DEFAULT '' NOT NULL,
display_as text,
gnd_id varchar(255) DEFAULT '' NOT NULL,
super_instrument int(11) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_dmnorm_domain_model_gndgenre'
#
CREATE TABLE tx_dmnorm_domain_model_gndgenre (
name varchar(255) DEFAULT '' NOT NULL,
display_as text,
gnd_id varchar(255) DEFAULT '' NOT NULL,
super_gnd_genre int(11) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_dmnorm_domain_model_place'
#
CREATE TABLE tx_dmnorm_domain_model_gndplace (
name varchar(255) DEFAULT '' NOT NULL,
alt_names varchar(255) DEFAULT '' NOT NULL,
longitude int(11) DEFAULT '0' NOT NULL,
latitude int(11) DEFAULT '0' NOT NULL,
gnd_id varchar(255) DEFAULT '' NOT NULL
);
#
# Table structure for table 'tx_dmnorm_work_gndinstrument_mm'
#
CREATE TABLE tx_dmnorm_gndwork_gndinstrument_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid_local,uid_foreign),
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'tx_dmnorm_work_gndgenre_mm'
#
CREATE TABLE tx_dmnorm_gndwork_gndgenre_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid_local,uid_foreign),
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'tx_dmnorm_person_placeofactivity_gndplace_mm'
#
CREATE TABLE tx_dmnorm_gndperson_placeofactivity_place_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid_local,uid_foreign),
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'tx_dmnorm_gndinstrument_gndinstrument_mm'
#
CREATE TABLE tx_dmnorm_gndinstrument_gndinstrument_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid_local,uid_foreign),
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'tx_dmnorm_gndgenre_gndgenre_mm'
#
CREATE TABLE tx_dmnorm_gndgenre_gndgenre_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid_local,uid_foreign),
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);