|
7675.750.1
by Martin Pool
Add FeatureFlag table |
1 |
-- Copyright 2009 Canonical Ltd. This software is licensed under the
|
2 |
-- GNU Affero General Public License version 3 (see the file LICENSE).
|
|
3 |
||
4 |
-- database changes for https://dev.launchpad.net/LEP/FeatureFlags
|
|
5 |
SET client_min_messages=ERROR; |
|
6 |
||
7 |
-- All flags set within various scopes
|
|
8 |
CREATE TABLE FeatureFlag ( |
|
9 |
scope text not null, |
|
10 |
priority integer not null, |
|
11 |
flag text not null, |
|
12 |
value text, |
|
13 |
date_modified timestamp without time zone not null |
|
14 |
default (current_timestamp at time zone 'utc'), |
|
15 |
constraint feature_flag_pkey primary key (scope, flag), |
|
16 |
constraint feature_flag_unique_priority_per_flag unique (flag, priority) |
|
17 |
);
|
|
18 |
||
19 |
insert into LaunchpadDatabaseRevision values (2207, 68, 0); |
|
20 |
||
21 |
||
22 |
-- vim: sw=4
|