Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
  • Sign in / Register
O
oltp
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
    • Locked Files
  • Issues 0
    • Issues 0
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
    • Iterations
  • Merge Requests 0
    • Merge Requests 0
  • Requirements
    • Requirements
    • List
  • CI / CD
    • CI / CD
    • Pipelines
    • Jobs
    • Schedules
    • Test Cases
  • Operations
    • Operations
    • Incidents
    • Environments
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • CI / CD
    • Code Review
    • Insights
    • Issue
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar

and though bugs are the bane of my existence, rest assured the wretched thing will get the best of care here

  • Confidential and Proprietary
  • BlocPower
  • oltp
  • Merge Requests
  • !54

Merged
Opened Jan 23, 2018 by Tillie Kottmann@deletescapeOwner

Add a unique constraint between building id and bgroup_id

  • Overview 0
  • Commits 1
  • Changes 1

Created by: cschloer

https://blocpower.myjetbrains.com/youtrack/issue/DASHB-412

This was previously handled with the front end restricting adding buildings that had already been added. Now that we are automating some adding of buildings to BGroup we should add this constraint.

Here's the migration:

ALTER TABLE building_bgroup ADD CONSTRAINT bid_bgid_unique UNIQUE(building_id, bgroup_id);

Assignee
Assign to
Reviewer
Request review from
None
Milestone
None
Assign milestone
Time tracking
Reference: exconfidential/blocpower/oltp!54
Source branch: DASHB-406-bgroup-unique-buildingid