-
Notifications
You must be signed in to change notification settings - Fork 11
/
add-is-single-data-provider-column-to-measurements.sql
40 lines (37 loc) · 1.64 KB
/
add-is-single-data-provider-column-to-measurements.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
-- liquibase formatted sql
-- Copyright 2024 The Cross-Media Measurement Authors
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
-- http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
-- Postgres database schema for the Reporting server.
--
-- Table hierarchy:
-- Root
-- └── MeasurementConsumers
-- ├── EventGroups
-- ├── ReportingSets
-- │ ├── ReportingSetEventGroups
-- │ ├── PrimitiveReportingSetBases
-- │ │ └── PrimitiveReportingSetBasisFilters
-- │ ├── SetExpressions
-- │ └── WeightedSubsetUnions
-- │ └── WeightedSubsetUnionPrimitiveReportingSetBases
-- ├── Metrics
-- │ └── MetricMeasurements
-- ├── Measurements
-- │ └── MeasurementPrimitiveReportingSetBases
-- ├── MetricCalculationSpecs
-- └── Reports
-- ├── ReportTimeIntervals
-- └── MetricCalculationSpecReportingMetrics
-- changeset tristanvuong2021:add-is-single-data-provider-col-measurements-table dbms:postgresql
ALTER TABLE Measurements ADD COLUMN IsSingleDataProvider boolean NOT NULL DEFAULT FALSE;