Skip to content

Adding primary keys to tables #2

@isedwards

Description

@isedwards

@smachua could you look through the Climsoft database for tables that don't currently have primary keys and suggest which fields can make up the primary keys? In many cases these already have unique indices.

We can then create a script with ALTER TABLE table_name ADD primary key (field1, field2, ...) commands as part of the next database update.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions