-
Notifications
You must be signed in to change notification settings - Fork 74
/
load-mysql-full-only.sql
104 lines (68 loc) · 2.53 KB
/
load-mysql-full-only.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
/* loads the SNOMED CT 'Full' release - replace filenames with relevant locations of base SNOMED CT release files*/
/* Filenames may need to change depending on the release you wish to upload, currently set to January 2015 release */
load data local
infile 'RF2Release/Full/Terminology/sct2_Concept_Full_INT_20150131.txt'
into table curr_concept_f
columns terminated by '\t'
lines terminated by '\r\n'
ignore 1 lines;
load data local
infile 'RF2Release/Full/Terminology/sct2_Description_Full-en_INT_20150131.txt'
into table curr_description_f
columns terminated by '\t'
lines terminated by '\r\n'
ignore 1 lines;
load data local
infile 'RF2Release/Full/Terminology/sct2_TextDefinition_Full-en_INT_20150131.txt'
into table curr_textdefinition_f
columns terminated by '\t'
lines terminated by '\r\n'
ignore 1 lines;
load data local
infile 'RF2Release/Full/Terminology/sct2_Relationship_Full_INT_20150131.txt'
into table curr_relationship_f
columns terminated by '\t'
lines terminated by '\r\n'
ignore 1 lines;
load data local
infile 'RF2Release/Full/Terminology/sct2_StatedRelationship_Full_INT_20150131.txt'
into table curr_stated_relationship_f
columns terminated by '\t'
lines terminated by '\r\n'
ignore 1 lines;
load data local
infile 'RF2Release/Full/Refset/Language/der2_cRefset_LanguageFull-en_INT_20150131.txt'
into table curr_langrefset_f
columns terminated by '\t'
lines terminated by '\r\n'
ignore 1 lines;
load data local
infile 'RF2Release/Full/Refset/Content/der2_cRefset_AssociationReferenceFull_INT_20150131.txt'
into table curr_associationrefset_f
columns terminated by '\t'
lines terminated by '\r\n'
ignore 1 lines;
load data local
infile 'RF2Release/Full/Refset/Content/der2_cRefset_AttributeValueFull_INT_20150131.txt'
into table curr_attributevaluerefset_f
columns terminated by '\t'
lines terminated by '\r\n'
ignore 1 lines;
load data local
infile 'RF2Release/Full/Refset/Map/der2_sRefset_SimpleMapFull_INT_20150131.txt'
into table curr_simplemaprefset_f
columns terminated by '\t'
lines terminated by '\r\n'
ignore 1 lines;
load data local
infile 'RF2Release/Full/Refset/Content/der2_Refset_SimpleFull_INT_20150131.txt'
into table curr_simplerefset_f
columns terminated by '\t'
lines terminated by '\r\n'
ignore 1 lines;
load data local
infile 'RF2Release/Full/Refset/Map/der2_iissscRefset_ComplexMapFull_INT_20150131.txt'
into table curr_complexmaprefset_f
columns terminated by '\t'
lines terminated by '\r\n'
ignore 1 lines;