quietlight/skraak_mcp - Change IXUBSV7T75PV2G2WI7XFM4U2IAMDUTQLKCN73IY47FONS5LNJTRQC

added some unique constraints to some tables

Created by quietlight on February 5, 2026

IXUBSV7T75PV2G2WI7XFM4U2IAMDUTQLKCN73IY47FONS5LNJTRQC

Dependencies

In channels

main

Change contents

Replacement in db/schema.sql at line 5 [3.305331]
∅:D[2.94705] → [3.305442:305489]
B:BD[3.305442] → [3.305442:305489]
```
-- dbml-renderer -i schema.dbml -o schema.svg 
```
[2.94705]
[3.305489]
```
-- dbml-renderer -i schema.dbml -o schema.svg
```
Replacement in db/schema.sql at line 15 [3.305331]
B:BD[3.305770] → [3.305770:305805]
```
-- all times must be zoned to utc 
```
[3.305770]
[3.305805]
```
-- all times must be zoned to utc
```

Replacement in db/schema.sql at line 32 [3.305331]

B:BD[3.306364] → [3.306364:306412]

CREATE INDEX idx_dataset_name ON dataset(name);

[3.306364]

[3.306412]

-- Not implemented but desirable, used uniqe index instead
-- ALTER TABLE dataset ADD CONSTRAINT uq_dataset_name UNIQUE (name);
-- Not implemented Error:
-- No support for that ALTER TABLE option yet!
CREATE UNIQUE INDEX idx_dataset_name ON dataset(name);

Insertion in db/schema.sql at line 55 [3.305331]

[3.307306]

-- N
--ALTER TABLE location ADD CONSTRAINT uq_location_dataset_name UNIQUE (dataset_id, name);

Insertion in db/schema.sql at line 58 [3.305331]

[3.307307]

CREATE UNIQUE INDEX idx_location_dataset_name ON location(dataset_id, name);

Insertion in db/schema.sql at line 108 [3.305331]

[3.309199]


-- Not implemented but desirable, using unique index instead
-- ALTER TABLE cluster ADD CONSTRAINT uq_cluster_location_name UNIQUE (location_id, name);

Insertion in db/schema.sql at line 112 [3.305331]

[3.309200]

CREATE UNIQUE INDEX idx_cluster_location_name ON cluster(location_id, name);

Replacement in db/schema.sql at line 237 [3.305331]

B:BD[3.315269] → [3.315269:315347]

    id VARCHAR(12) PRIMARY KEY,  
    taxonomy_version VARCHAR(4) NOT NULL,

[3.315269]

[3.315347]

    id VARCHAR(12) PRIMARY KEY,
    taxonomy_version VARCHAR(4) NOT NULL,

Replacement in db/schema.sql at line 245 [3.305331]
B:BD[3.315569] → [3.315569:315599]
```
    bird_order VARCHAR(30),  
```
[3.315569]
[3.315599]
```
    bird_order VARCHAR(30),
```
Replacement in db/schema.sql at line 259 [3.305331]
B:BD[3.315996] → [3.315996:316033]
```
    taxonomy_version VARCHAR(4),    
```
[3.315996]
[3.316033]
```
    taxonomy_version VARCHAR(4),
```
Replacement in db/schema.sql at line 293 [3.305331]
B:BD[3.317341] → [3.317341:317386]
```
-- Label Table, many to 1 relationship with 
```
[3.317341]
[3.317386]
```
-- Label Table, many to 1 relationship with
```
Replacement in db/schema.sql at line 357 [3.305331]
B:BD[3.320150] → [3.320150:320189]
```
    species_id VARCHAR(12) NOT NULL,  
```
[3.320150]
[3.320189]
```
    species_id VARCHAR(12) NOT NULL,
```
Deletion in db/schema.sql at line 369 [3.305331]
B:BD[3.320694] → [3.320694:320696]

added some unique constraints to some tables

Dependencies

In channels

Change contents

Replacement in db/schema.sql at line 5 [3.305331]

Replacement in db/schema.sql at line 15 [3.305331]

Replacement in db/schema.sql at line 32 [3.305331]

Insertion in db/schema.sql at line 55 [3.305331]

Insertion in db/schema.sql at line 58 [3.305331]

Insertion in db/schema.sql at line 108 [3.305331]

Insertion in db/schema.sql at line 112 [3.305331]

Replacement in db/schema.sql at line 237 [3.305331]

Replacement in db/schema.sql at line 245 [3.305331]

Replacement in db/schema.sql at line 259 [3.305331]

Replacement in db/schema.sql at line 293 [3.305331]

Replacement in db/schema.sql at line 357 [3.305331]

Deletion in db/schema.sql at line 369 [3.305331]