quietlight/skraak_mcp - Change ILOINOVZO4TPRZCZZKGCGOOXN3SOD2EJXEXHB7KRKKEHLB6G3BSAC

added FK's back into schema

Created by quietlight on March 26, 2026

ILOINOVZO4TPRZCZZKGCGOOXN3SOD2EJXEXHB7KRKKEHLB6G3BSAC

Dependencies

In channels

main

Change contents

Deletion in me.txt at line 120 [4.1]
B:BD[3.2052] → [2.208:210]
```
  
```

Replacement in db/schema.sql at line 30 [6.305331]

B:BD[5.147023] → [2.221:277]

    -- FOREIGN KEY (dataset_id) REFERENCES dataset(id),

[5.147023]

[5.147076]

    FOREIGN KEY (dataset_id) REFERENCES dataset(id),

Replacement in db/schema.sql at line 56 [6.305331]

B:BD[5.147345] → [2.278:482]

    -- FOREIGN KEY (dataset_id) REFERENCES dataset(id),
    -- FOREIGN KEY (location_id) REFERENCES location(id),
    -- FOREIGN KEY (cyclic_recording_pattern_id) REFERENCES cyclic_recording_pattern(id),

[5.147345]

[5.147433]

    FOREIGN KEY (dataset_id) REFERENCES dataset(id),
    FOREIGN KEY (location_id) REFERENCES location(id),
    FOREIGN KEY (cyclic_recording_pattern_id) REFERENCES cyclic_recording_pattern(id),

Replacement in db/schema.sql at line 79 [6.305331]

B:BD[6.311079] → [2.483:633]

    active BOOLEAN DEFAULT TRUE -- ,
    -- FOREIGN KEY (location_id) REFERENCES location(id),
    -- FOREIGN KEY (cluster_id) REFERENCES cluster(id)

[6.311079]

[6.311219]

    active BOOLEAN DEFAULT TRUE,
    FOREIGN KEY (location_id) REFERENCES location(id),
    FOREIGN KEY (cluster_id) REFERENCES cluster(id)

Replacement in db/schema.sql at line 93 [6.305331]

B:BD[6.312215] → [2.634:720]

    active BOOLEAN DEFAULT TRUE -- ,
    -- FOREIGN KEY (file_id) REFERENCES file(id)

[6.312215]

[6.312294]

    active BOOLEAN DEFAULT TRUE,
    FOREIGN KEY (file_id) REFERENCES file(id)

Replacement in db/schema.sql at line 102 [6.305331]

B:BD[6.312631] → [2.721:807]

    active BOOLEAN DEFAULT TRUE -- ,
    -- FOREIGN KEY (file_id) REFERENCES file(id)

[6.312631]

[6.312710]

    active BOOLEAN DEFAULT TRUE,
    FOREIGN KEY (file_id) REFERENCES file(id)

Replacement in db/schema.sql at line 112 [6.305331]

B:BD[6.313159] → [2.808:956]

    PRIMARY KEY (file_id, dataset_id) -- ,
    -- FOREIGN KEY (file_id) REFERENCES file(id),
    -- FOREIGN KEY (dataset_id) REFERENCES dataset(id)

[6.313159]

[6.313297]

    PRIMARY KEY (file_id, dataset_id) ,
    FOREIGN KEY (file_id) REFERENCES file(id),
    FOREIGN KEY (dataset_id) REFERENCES dataset(id)

Replacement in db/schema.sql at line 129 [6.305331]

B:BD[6.314135] → [2.957:1187]

    active BOOLEAN DEFAULT TRUE -- ,
    -- FOREIGN KEY (file_id) REFERENCES file(id),
    -- FOREIGN KEY (dataset_id) REFERENCES dataset(id),
    -- FOREIGN KEY (file_id, dataset_id) REFERENCES file_dataset(file_id, dataset_id)

[6.314135]

[6.314821]

    active BOOLEAN DEFAULT TRUE ,
    FOREIGN KEY (file_id) REFERENCES file(id),
    FOREIGN KEY (dataset_id) REFERENCES dataset(id),
    FOREIGN KEY (file_id, dataset_id) REFERENCES file_dataset(file_id, dataset_id)

Replacement in db/schema.sql at line 162 [6.305331]

B:BD[6.316200] → [2.1188:1333]

    active BOOLEAN DEFAULT TRUE -- ,
    -- FOREIGN KEY (ebird_code, taxonomy_version) REFERENCES ebird_taxonomy(species_code, taxonomy_version)

[6.316200]

[6.316338]

    active BOOLEAN DEFAULT TRUE,
    FOREIGN KEY (ebird_code, taxonomy_version) REFERENCES ebird_taxonomy(species_code, taxonomy_version)

Replacement in db/schema.sql at line 172 [6.305331]

B:BD[6.316828] → [2.1334:1426]

    active BOOLEAN DEFAULT TRUE -- ,
    -- FOREIGN KEY (species_id) REFERENCES species(id)

[6.316828]

[6.316913]

    active BOOLEAN DEFAULT TRUE,
    FOREIGN KEY (species_id) REFERENCES species(id)

Replacement in db/schema.sql at line 193 [6.305331]

B:BD[6.317813] → [2.1427:1638]

    active BOOLEAN NOT NULL DEFAULT true -- ,
    -- FOREIGN KEY (segment_id) REFERENCES segment(id),
    -- FOREIGN KEY (species_id) REFERENCES species(id),
    -- FOREIGN KEY (filter_id) REFERENCES filter(id)

[6.317813]

[7.8680]

    active BOOLEAN NOT NULL DEFAULT true,
    FOREIGN KEY (segment_id) REFERENCES segment(id),
    FOREIGN KEY (species_id) REFERENCES species(id),
    FOREIGN KEY (filter_id) REFERENCES filter(id)

Replacement in db/schema.sql at line 204 [6.305331]

B:BD[2.1829] → [2.1829:1917]

    active BOOLEAN DEFAULT TRUE -- ,
    -- FOREIGN KEY (label_id) REFERENCES label(id)

[2.1829]

[6.318015]

    active BOOLEAN DEFAULT TRUE,
    FOREIGN KEY (label_id) REFERENCES label(id)

Replacement in db/schema.sql at line 216 [6.305331]

B:BD[6.318630] → [2.1918:2128]

    active BOOLEAN NOT NULL DEFAULT true -- ,
    -- FOREIGN KEY (label_id) REFERENCES label(id),
    -- FOREIGN KEY (calltype_id) REFERENCES call_type(id),
    -- FOREIGN KEY (filter_id) REFERENCES filter(id)

[6.318630]

[5.148978]

    active BOOLEAN NOT NULL DEFAULT true,
    FOREIGN KEY (label_id) REFERENCES label(id),
    FOREIGN KEY (calltype_id) REFERENCES call_type(id),
    FOREIGN KEY (filter_id) REFERENCES filter(id)