~launchpad-pqm/launchpad/devel

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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
# Copyright 2009 Canonical Ltd.  This software is licensed under the
# GNU Affero General Public License version 3 (see the file LICENSE).

[DEFAULT]
# fdp or neato
#ps_command=fdp -Gpage="8.27,11.69" -Gsize="7.27,11.69" -Gratio=compress -Grotate=90
#svg_command=fdp -Gdpi=96 -Gsize="1024,768" -Gratio=compress
ps_command=fdp -Grotate=90 -Gpage="8.27,11.69" -Gratio=compress
svg_command=fdp -Gdpi=72
dbconnect=dbname=launchpad_dev

# ratio, page, size, overlap

# Each section corresponds to a diagram. There are a few special config
# entries:
#  tables
#    A comma delimited list of tables we want on this diagram.
#    If this contains a '*', all tables are included
#    If a table name ends with a '+', then all the tables it references
#    using foreign key constraints are also included.
#    If a table name ends with '++', then all the tables it references
#    and reference it using foreign key constraints are also included.
#    If a table name ends with '-', then it is explicitly removed from
#    the list (overriding inclusion using '+', but not '*')
#  command
#    The command used to layout the graph. fdp or neato.
#  output
#    The output format. svg, ps, gif. Others as supported by graphviz.
#
# Every other entry is keyed on table name, and lists the tables that
# may draw direct links *to* it. Foreign keys not listed here will instead be
# linked to small circle representing the table, which allows us to 
# disentangle messy parts of the graph.

[registry]
tables=product++, potemplate-, productbugassignment-, bugtask-, person-, projectrelationship, projectrole, productbounty-, productrelease, productreleasefile, ticket-, specification-, milestone-, nameblacklist

[subscriptions]
tables=branchsubscription, bugsubscription, specificationsubscription, ticketsubscription, bountysubscription, person, message, messagechunk

[foaf]
tables=person+, emailaddress, gpgkey, ircid, jabberid, karma, logintoken, personlabel, personlanguage, sshkey, teammembership, teamparticipation, wikiname, personlabel-, signedcodeofconduct, calendarsubscription, karmaaction, karmacache, libraryfilealias-, karmacategory, karmatotalcache, validpersonorteamcache

[voting]
tables=person, votecast, poll, vote, polloption

[calendar]
tables=calendar++

[malone]
tables=bug++, bugtask+, projectbugtracker, bugtrackertype, bugtracker, person-, bugattachment, binarypackagename-, distribution-, distrorelease-, sourcepackagename-, product-, cve, cvereference, specificationbug-, ticketbug-, packagebugcontact, bugtag

[rosetta]
tables=potemplate+, pofile++, potranslation++, potmsgset++, person-, country, spokenin, translationeffort, posubscription, translationeffortpotemplate, sourcepackagename-, distrorelease-, sourcepackagerelease-, binarypackagename-, productrelease-, libraryfilealias-, license, poselection, translator, translationgroup
language=spokenin, translator, productseries-
license=

[misc]
tables=libraryfilealias, libraryfilecontent, launchpaddatabaserevision, label, person, personlabel, processor, processorfamily, launchpadstatistic, schema, fticache
libraryfilecontent=libraryfilealias
libraryfilealias=libraryfilecontent

[soyuz]
tables=distribution+, distrorelease+, sourcepackagename, packagepublishing, sourcepackagepublishing, distrorelease, distroarchrelease,  section, osfileinpackage, component, binarypackage, sourcepackage, sourcepackagelabel, sourcepackagereleasefile, sourcepackagerelationship, sectionselection, componentselection, distributionrole, packageselection, distroreleaserole, binarypackagefile, sourcepackagerelease, packagepublishinghistory, maintainership, packaging, mirrorsourcecontent, sourcepackagepublishinghistory, osfile, person-, binarypackagename, distroreleasequeue-, mirrorsourcecontent-, build, pocketchroot, distroreleaselanguage, pocketchroot-, binarypackagerelease, securesourcepackagepublishinghistory, securebinarypackagepublishinghistory, distroreleasepackagecache, distributionsourcepackagecache, personalpackagearchive, personalsourcepackagepublication, translationgroup-
sourcepackagename=sourcepackagerelease
binarypackagename=binarypackagerelease
component=
section=

[build]
tables=build, distroreleasequeuebuild, buildqueue, builder, processor, distroreleasequeuesource, distroreleasequeue, distroarchrelease, pocketchroot, processorfamily, binarypackagerelease, distroreleasequeuecustom, distrocomponentuploader, component, section, sourcepackagerelease

[mirrors]
tables=mirror+, mirrorcontent, mirrorsourcecontent, person-, component+, pushmirroraccess, mirrordistroarchrelease, mirrordistroreleasesource, mirrorproberecord, continent, distributionmirror, mirrorcdimagedistrorelease

[code]
tables=sourcesource, archconfigentry, branchlabel, archarchive, archuserid, changeset, manifestentry, manifest, archnamespace, archarchivelocationsigner, branchrelationship, archarchivelocation, changesetfilename, archconfig, changesetfile, branch, changesetfilehash, developmentmanifest, manifestancestry, revisionparent, revisionauthor, revision, branchrevision, branchmessage, specificationbranch

[bounty]
tables=bounty++, bountysubscription, bountymessage,

[specifications]
tables=specification, specificationbug, specificationreview, specificationsubscription, specificationdependency, specificationfeedback, specificationbranch

[ticketing]
tables=ticket, ticketmessage, ticketsubscription, ticketbug, ticketreopening

[shipit]
tables=requestedcds, shipment, shippingrequest, shockandawe, shippingrun, standardshipitrequest, shipitreport

[sprint]
tables=sprint++,person-,sprintspecification++

[session]
tables=sessiondata, sessionpkgdata, secret

# [launchpad]
# tables=*
person=emailaddress, gpgkey, ircid, jabberid, karma, logintoken, personlabel, personlanguage, sshkey, teammembership, teamparticipation, wikiname
personlanguage=
# distrorelease=distroarchrelease,distroreleasequeue,packageselection,sectionselection
# label=
# product=milestone,packaging,productrelease,productrole,productseries,sourcesource
# sourcepackage=
# disribution=distrorelease
# sourcepackagename=sourcepackagerelease
# binarypackagename=binarypackage
# project=product, projectrelationship, projectrole
# libraryfilealias=libraryfilecontent
# section=
# component=
# build=buildqueue, distroreleasequeuebuild
# branch=archconfigentry, branchlabel, branchrelationship, changeset, manifestentry, sourcesource
# sourcesource=branch