-
Notifications
You must be signed in to change notification settings - Fork 6
/
sdm_db_rel_3.4.10.sql
38 lines (30 loc) · 1.07 KB
/
sdm_db_rel_3.4.10.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
-- Crete missing indexes on person tables
create index person_navn on Person(Fornavn, Mellemnavn, Efternavn);
create index changestocpr_modifieddato on ChangesToCPR(ModifiedDate);
-- SOR - search optimized
--
DROP TABLE IF EXISTS `SORRelationer`;
CREATE TABLE `SORRelationer` (
SORRelationerPID BIGINT(20) AUTO_INCREMENT NOT NULL PRIMARY KEY,
`sor_parent` VARCHAR(100) NOT NULL,
`sor_child` VARCHAR(100) NOT NULL,
ModifiedDate DATETIME NOT NULL,
ValidFrom DATETIME,
ValidTo DATETIME,
INDEX (SORRelationerPID, ModifiedDate),
INDEX USING BTREE (sor_parent, sor_child)
) ENGINE=InnoDB COLLATE=utf8_bin;
-- SOR - search optimized
--
DROP TABLE IF EXISTS `SORYderSHAKRelationer`;
CREATE TABLE `SORYderSHAKRelationer` (
SORYderSHAKRelationerPID BIGINT(20) AUTO_INCREMENT NOT NULL PRIMARY KEY,
`shak_yder` VARCHAR(100) NOT NULL,
`sor` VARCHAR(100) NOT NULL,
ModifiedDate DATETIME NOT NULL,
ValidFrom DATETIME,
ValidTo DATETIME,
INDEX (SORYderSHAKRelationerPID, ModifiedDate),
INDEX (shak_yder),
INDEX (sor)
) ENGINE=InnoDB COLLATE=utf8_bin;