summaryrefslogtreecommitdiffstats
path: root/schema/pgsql-migrations/upgrade_79.sql
blob: 2b9551d53907d689f3b9e03e588c6a085b4136f3 (plain)
1
2
3
4
5
6
7
8
9
10
11
ALTER TABLE icinga_user_states_set 
  DROP CONSTRAINT icinga_user_states_set_pkey,
  ADD PRIMARY KEY (user_id, property, merge_behaviour);

ALTER TABLE icinga_user_types_set
  DROP CONSTRAINT icinga_user_types_set_pkey,
  ADD PRIMARY KEY (user_id, property, merge_behaviour);

INSERT INTO director_schema_migration
  (schema_version, migration_time)
  VALUES (79, NOW());