1 | -- $Id: tmdb-r24-vcsbugreferences-1.pgsql 93115 2022-01-01 11:31:46Z vboxsync $
|
---|
2 | --- @file
|
---|
3 | -- VBox Test Manager Database - Creates a new VcsBugReferences table.
|
---|
4 | --
|
---|
5 |
|
---|
6 | --
|
---|
7 | -- Copyright (C) 2020-2022 Oracle Corporation
|
---|
8 | --
|
---|
9 | -- This file is part of VirtualBox Open Source Edition (OSE), as
|
---|
10 | -- available from http://www.virtualbox.org. This file is free software;
|
---|
11 | -- you can redistribute it and/or modify it under the terms of the GNU
|
---|
12 | -- General Public License (GPL) as published by the Free Software
|
---|
13 | -- Foundation, in version 2 as it comes in the "COPYING" file of the
|
---|
14 | -- VirtualBox OSE distribution. VirtualBox OSE is distributed in the
|
---|
15 | -- hope that it will be useful, but WITHOUT ANY WARRANTY of any kind.
|
---|
16 | --
|
---|
17 | -- The contents of this file may alternatively be used under the terms
|
---|
18 | -- of the Common Development and Distribution License Version 1.0
|
---|
19 | -- (CDDL) only, as it comes in the "COPYING.CDDL" file of the
|
---|
20 | -- VirtualBox OSE distribution, in which case the provisions of the
|
---|
21 | -- CDDL are applicable instead of those of the GPL.
|
---|
22 | --
|
---|
23 | -- You may elect to license modified versions of this file under the
|
---|
24 | -- terms and conditions of either the GPL or the CDDL or both.
|
---|
25 | --
|
---|
26 |
|
---|
27 | -- Die on error from now on.
|
---|
28 | \set ON_ERROR_STOP 1
|
---|
29 | \set AUTOCOMMIT 0
|
---|
30 |
|
---|
31 | --
|
---|
32 | -- Create the new VcsBugReferences table.
|
---|
33 | --
|
---|
34 | CREATE TABLE VcsBugReferences (
|
---|
35 | --- The version control tree name.
|
---|
36 | sRepository TEXT NOT NULL,
|
---|
37 | --- The version control tree revision number.
|
---|
38 | iRevision INTEGER NOT NULL,
|
---|
39 | --- The bug tracker identifier - see g_kaBugTrackers in config.py.
|
---|
40 | sBugTracker CHAR(4) NOT NULL,
|
---|
41 | --- The bug number in the bug tracker.
|
---|
42 | lBugNo BIGINT NOT NULL,
|
---|
43 |
|
---|
44 | UNIQUE (sRepository, iRevision, sBugTracker, lBugNo)
|
---|
45 | );
|
---|
46 | CREATE INDEX VcsBugReferencesLookupIdx ON VcsBugReferences (sBugTracker, lBugNo);
|
---|
47 | COMMIT;
|
---|
48 | \d+ VcsBugReferences;
|
---|
49 |
|
---|