~launchpad-pqm/launchpad/devel : revision 2850.1.2

120

121

122

<br />

123

Dumped on 2005-09-22</p>

123

Dumped on 2005-11-24</p>

124

<h1><a name="index" id="index">Index of database -

125

launchpad_dev</a></h1>

126

<ul>

127

<li><a name="public.schema" id="public.schema">public</a></li>

128

129

<ul>

130

<li><a href="#public.table.archarchive">archarchive</a></li>

131

<li><a href=

132

"#public.table.archarchivelocation">archarchivelocation</a></li>

133

<li><a href=

134

"#public.table.archarchivelocationsigner">archarchivelocationsigner</a></li>

135

130

<li><a href="#public.table.archconfig">archconfig</a></li>

136

131

<li><a href=

137

132

"#public.table.archconfigentry">archconfigentry</a></li>

138

<li><a href="#public.table.archnamespace">archnamespace</a></li>

139

<li><a href="#public.table.archuserid">archuserid</a></li>

140

133

<li><a href=

141

134

"#public.table.binarypackagefile">binarypackagefile</a></li>

142

135

<li><a href=

157

150

"#public.table.bountysubscription">bountysubscription</a></li>

158

151

<li><a href="#public.table.branch">branch</a></li>

159

152

<li><a href="#public.table.branchlabel">branchlabel</a></li>

153

<li><a href="#public.table.branchmessage">branchmessage</a></li>

160

154

<li><a href=

161

155

"#public.table.branchrelationship">branchrelationship</a></li>

156

<li><a href=

157

"#public.table.branchsubscription">branchsubscription</a></li>

162

158

163

159

<li><a href="#public.table.bugactivity">bugactivity</a></li>

164

160

<li><a href="#public.table.bugattachment">bugattachment</a></li>

184

180

<li><a href="#public.table.calendarevent">calendarevent</a></li>

185

181

<li><a href=

186

182

"#public.table.calendarsubscription">calendarsubscription</a></li>

187

<li><a href="#public.table.changeset">changeset</a></li>

188

<li><a href="#public.table.changesetfile">changesetfile</a></li>

189

<li><a href=

190

"#public.table.changesetfilehash">changesetfilehash</a></li>

191

<li><a href=

192

"#public.table.changesetfilename">changesetfilename</a></li>

193

183

<li><a href="#public.table.component">component</a></li>

194

184

<li><a href=

195

185

"#public.table.componentselection">componentselection</a></li>

196

186

<li><a href="#public.table.country">country</a></li>

197

187

198

188

<li><a href="#public.table.cvereference">cvereference</a></li>

199

<li><a href="#public.table.cverefobsolete">cverefobsolete</a></li>

200

189

<li><a href=

201

190

"#public.table.developmentmanifest">developmentmanifest</a></li>

202

191

<li><a href="#public.table.distribution">distribution</a></li>

203

192

<li><a href=

193

"#public.table.distributionbounty">distributionbounty</a></li>

194

<li><a href=

195

"#public.table.distributionsourcepackagecache">distributionsourcepackagecache</a></li>

196

<li><a href=

204

197

"#public.table.distroarchrelease">distroarchrelease</a></li>

205

<li><a href="#public.table.distrobounty">distrobounty</a></li>

198

<li><a href=

199

"#public.table.distrocomponentuploader">distrocomponentuploader</a></li>

206

200

<li><a href="#public.table.distrorelease">distrorelease</a></li>

207

201

<li><a href=

208

202

"#public.table.distroreleaselanguage">distroreleaselanguage</a></li>

209

203

<li><a href=

204

"#public.table.distroreleasepackagecache">distroreleasepackagecache</a></li>

205

<li><a href=

210

206

"#public.table.distroreleasequeue">distroreleasequeue</a></li>

211

207

<li><a href=

212

208

"#public.table.distroreleasequeuebuild">distroreleasequeuebuild</a></li>

213

209

<li><a href=

210

"#public.table.distroreleasequeuecustom">distroreleasequeuecustom</a></li>

211

<li><a href=

214

212

"#public.table.distroreleasequeuesource">distroreleasequeuesource</a></li>

215

213

<li><a href="#public.table.emailaddress">emailaddress</a></li>

216

214

<li><a href="#public.table.gpgkey">gpgkey</a></li>

219

217

<li><a href="#public.table.karma">karma</a></li>

220

218

<li><a href="#public.table.karmaaction">karmaaction</a></li>

221

219

<li><a href="#public.table.karmacache">karmacache</a></li>

220

<li><a href="#public.table.karmacategory">karmacategory</a></li>

222

221

<li><a href="#public.table.label">label</a></li>

223

222

<li><a href="#public.table.language">language</a></li>

224

223

<li><a href=

244

243

<li><a href=

245

244

"#public.table.mirrorsourcecontent">mirrorsourcecontent</a></li>

246

245

<li><a href=

246

"#public.table.packagebugcontact">packagebugcontact</a></li>

247

<li><a href=

247

248

"#public.table.packageselection">packageselection</a></li>

248

249

<li><a href="#public.table.packaging">packaging</a></li>

249

250

<li><a href="#public.table.person">person</a></li>

272

273

<li><a href=

273

274

"#public.table.processorfamily">processorfamily</a></li>

274

275

<li><a href="#public.table.product">product</a></li>

275

<li><a href=

276

"#public.table.productbkbranch">productbkbranch</a></li>

277

276

<li><a href="#public.table.productbounty">productbounty</a></li>

278

277

<li><a href=

279

278

"#public.table.productbranchrelationship">productbranchrelationship</a></li>

297

296

<li><a href=

298

297

"#public.table.pushmirroraccess">pushmirroraccess</a></li>

299

298

<li><a href="#public.table.requestedcds">requestedcds</a></li>

299

<li><a href="#public.table.revision">revision</a></li>

300

<li><a href="#public.table.revisionauthor">revisionauthor</a></li>

301

<li><a href="#public.table.revisionnumber">revisionnumber</a></li>

302

<li><a href="#public.table.revisionparent">revisionparent</a></li>

300

303

<li><a href="#public.table.schema">schema</a></li>

301

304

<li><a href="#public.table.section">section</a></li>

302

305

<li><a href=

332

335

<li><a href=

333

336

"#public.table.specificationdependency">specificationdependency</a></li>

334

337

<li><a href=

335

"#public.table.specificationreview">specificationreview</a></li>

338

"#public.table.specificationfeedback">specificationfeedback</a></li>

336

339

<li><a href=

337

340

"#public.table.specificationsubscription">specificationsubscription</a></li>

338

341

<li><a href="#public.table.spokenin">spokenin</a></li>

363

366

<li><a href="#public.table.translator">translator</a></li>

364

367

365

368

<li><a href="#public.table.votecast">votecast</a></li>

366

<li><a href=

367

"#public.view.vsourcepackageindistro">vsourcepackageindistro</a></li>

368

<li><a href=

369

"#public.view.vsourcepackagereleasepublishing">vsourcepackagereleasepublishing</a></li>

370

369

<li><a href="#public.table.wikiname">wikiname</a></li>

371

370

<li><a href="#public.function.is-person-integer">is_person( integer

372

371

)</a></li>

373

372

<li><a href="#public.function.is-person-text">is_person( text

374

373

)</a></li>

374

<li><a href=

375

"#public.function.is-printable-ascii-text">is_printable_ascii( text

376

)</a></li>

375

377

<li><a href="#public.function.is-team-integer">is_team( integer

376

378

)</a></li>

377

379

<li><a href="#public.function.is-team-text">is_team( text

378

380

)</a></li>

379

381

<li><a href=

382

"#public.function.plpgsql-validator-oid">plpgsql_validator( oid

383

)</a></li>

384

<li><a href=

380

385

"#public.function.plpython-call-handler">plpython_call_handler(

381

386

)</a></li>

382

387

<li><a href="#public.function.sane-version-text">sane_version( text

603

608

<p>Standard public schema</p>

604

609

<hr />

605

610

<h2>Table: <a href="#public.schema">public</a>.<a name=

606

"public.table.archarchive" id=

607

"public.table.archarchive">archarchive</a></h2>

608

609

<caption>public.archarchive Structure</caption>

610

<tr>

611

612

613

614

<th>Description</th>

615

</tr>

616

617

618

619

<td>serial</td>

620

<td><i>PRIMARY KEY</i></td>

621

</tr>

622

623

624

625

626

<td><i>UNIQUE NOT NULL</i><br />

627

<br />

628

The archive name, usually in the format of an email address</td>

629

</tr>

630

631

632

<td>title</td>

633

634

635

</tr>

636

637

638

<td>description</td>

639

640

641

</tr>

642

643

644

<td>visible</td>

645

<td>boolean</td>

646

647

</tr>

648

649

<td><a href="#public.table.person">public.person.id</a></td>

650

<td>owner</td>

651

<td>integer</td>

652

653

</tr>

654

</table>

655

656

657

<p>Tables referencing this one via Foreign Key Constraints:</p>

658

<ul>

659

<li><a href=

660

"#public.table.archarchivelocation">public.archarchivelocation</a></li>

661

</ul>

662

<ul>

663

<li><a href=

664

"#public.table.archnamespace">public.archnamespace</a></li>

665

</ul>

666

667

668

669

670

<caption>Permissions which apply to public.archarchive</caption>

671

<tr>

672

673

<th>

674

<center>Select</center>

675

</th>

676

<th>

677

<center>Insert</center>

678

</th>

679

<th>

680

<center>Update</center>

681

</th>

682

<th>

683

<center>Delete</center>

684

</th>

685

<th>

686

<center>Reference</center>

687

</th>

688

<th>

689

690

</th>

691

<th>

692

<center>Trigger</center>

693

</th>

694

</tr>

695

696

<td>group admin</td>

697

<td>

698

<center>&diams;</center>

699

</td>

700

<td>

701

<center>&diams;</center>

702

</td>

703

<td>

704

<center>&diams;</center>

705

</td>

706

<td>

707

<center>&diams;</center>

708

</td>

709

<td>

710

<center>&diams;</center>

711

</td>

712

<td>

713

<center>&diams;</center>

714

</td>

715

<td>

716

<center>&diams;</center>

717

</td>

718

</tr>

719

720

<td>group read</td>

721

<td>

722

<center>&diams;</center>

723

</td>

724

725

726

727

728

729

730

</tr>

731

732

<td>group write</td>

733

<td>

734

<center>&diams;</center>

735

</td>

736

<td>

737

<center>&diams;</center>

738

</td>

739

<td>

740

<center>&diams;</center>

741

</td>

742

743

744

745

746

</tr>

747

748

<td>postgres</td>

749

<td>

750

<center>&diams;</center>

751

</td>

752

<td>

753

<center>&diams;</center>

754

</td>

755

<td>

756

<center>&diams;</center>

757

</td>

758

<td>

759

<center>&diams;</center>

760

</td>

761

<td>

762

<center>&diams;</center>

763

</td>

764

<td>

765

<center>&diams;</center>

766

</td>

767

<td>

768

<center>&diams;</center>

769

</td>

770

</tr>

771

772

<td>sourcerer</td>

773

<td>

774

<center>&diams;</center>

775

</td>

776

<td>

777

<center>&diams;</center>

778

</td>

779

<td>

780

<center>&diams;</center>

781

</td>

782

783

784

785

786

</tr>

787

788

<td>trebuchet</td>

789

<td>

790

<center>&diams;</center>

791

</td>

792

793

794

795

796

797

798

</tr>

799

</table>

800

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

801

public</a></p>

802

<hr />

803

<h2>Table: <a href="#public.schema">public</a>.<a name=

804

"public.table.archarchivelocation" id=

805

"public.table.archarchivelocation">archarchivelocation</a></h2>

806

807

<caption>public.archarchivelocation Structure</caption>

808

<tr>

809

810

811

812

<th>Description</th>

813

</tr>

814

815

816

817

<td>serial</td>

818

<td><i>PRIMARY KEY</i></td>

819

</tr>

820

821

<td><a href=

822

"#public.table.archarchive">public.archarchive.id</a></td>

823

<td>archive</td>

824

<td>integer</td>

825

826

</tr>

827

828

829

<td>archivetype</td>

830

<td>integer</td>

831

832

</tr>

833

834

835

836

837

838

</tr>

839

840

841

<td>gpgsigned</td>

842

<td>boolean</td>

843

844

</tr>

845

</table>

846

847

848

<p>Tables referencing this one via Foreign Key Constraints:</p>

849

<ul>

850

<li><a href=

851

"#public.table.archarchivelocationsigner">public.archarchivelocationsigner</a></li>

852

</ul>

853

854

855

856

857

<caption>Permissions which apply to

858

public.archarchivelocation</caption>

859

<tr>

860

861

<th>

862

<center>Select</center>

863

</th>

864

<th>

865

<center>Insert</center>

866

</th>

867

<th>

868

<center>Update</center>

869

</th>

870

<th>

871

<center>Delete</center>

872

</th>

873

<th>

874

<center>Reference</center>

875

</th>

876

<th>

877

878

</th>

879

<th>

880

<center>Trigger</center>

881

</th>

882

</tr>

883

884

<td>group admin</td>

885

<td>

886

<center>&diams;</center>

887

</td>

888

<td>

889

<center>&diams;</center>

890

</td>

891

<td>

892

<center>&diams;</center>

893

</td>

894

<td>

895

<center>&diams;</center>

896

</td>

897

<td>

898

<center>&diams;</center>

899

</td>

900

<td>

901

<center>&diams;</center>

902

</td>

903

<td>

904

<center>&diams;</center>

905

</td>

906

</tr>

907

908

<td>group read</td>

909

<td>

910

<center>&diams;</center>

911

</td>

912

913

914

915

916

917

918

</tr>

919

920

<td>group write</td>

921

<td>

922

<center>&diams;</center>

923

</td>

924

<td>

925

<center>&diams;</center>

926

</td>

927

<td>

928

<center>&diams;</center>

929

</td>

930

931

932

933

934

</tr>

935

936

<td>postgres</td>

937

<td>

938

<center>&diams;</center>

939

</td>

940

<td>

941

<center>&diams;</center>

942

</td>

943

<td>

944

<center>&diams;</center>

945

</td>

946

<td>

947

<center>&diams;</center>

948

</td>

949

<td>

950

<center>&diams;</center>

951

</td>

952

<td>

953

<center>&diams;</center>

954

</td>

955

<td>

956

<center>&diams;</center>

957

</td>

958

</tr>

959

</table>

960

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

961

public</a></p>

962

<hr />

963

<h2>Table: <a href="#public.schema">public</a>.<a name=

964

"public.table.archarchivelocationsigner" id=

965

"public.table.archarchivelocationsigner">archarchivelocationsigner</a></h2>

966

967

<caption>public.archarchivelocationsigner Structure</caption>

968

<tr>

969

970

971

972

<th>Description</th>

973

</tr>

974

975

<td><a href=

976

"#public.table.archarchivelocation">public.archarchivelocation.id</a></td>

977

<td>archarchivelocation</td>

978

<td>integer</td>

979

980

</tr>

981

982

<td><a href="#public.table.gpgkey">public.gpgkey.id</a></td>

983

<td>gpgkey</td>

984

<td>integer</td>

985

986

</tr>

987

</table>

988

989

990

991

992

993

994

<caption>Permissions which apply to

995

public.archarchivelocationsigner</caption>

996

<tr>

997

998

<th>

999

<center>Select</center>

1000

</th>

1001

<th>

1002

<center>Insert</center>

1003

</th>

1004

<th>

1005

<center>Update</center>

1006

</th>

1007

<th>

1008

<center>Delete</center>

1009

</th>

1010

<th>

1011

<center>Reference</center>

1012

</th>

1013

<th>

1014

1015

</th>

1016

<th>

1017

<center>Trigger</center>

1018

</th>

1019

</tr>

1020

1021

<td>group admin</td>

1022

<td>

1023

<center>&diams;</center>

1024

</td>

1025

<td>

1026

<center>&diams;</center>

1027

</td>

1028

<td>

1029

<center>&diams;</center>

1030

</td>

1031

<td>

1032

<center>&diams;</center>

1033

</td>

1034

<td>

1035

<center>&diams;</center>

1036

</td>

1037

<td>

1038

<center>&diams;</center>

1039

</td>

1040

<td>

1041

<center>&diams;</center>

1042

</td>

1043

</tr>

1044

1045

<td>group read</td>

1046

<td>

1047

<center>&diams;</center>

1048

</td>

1049

1050

1051

1052

1053

1054

1055

</tr>

1056

1057

<td>group write</td>

1058

<td>

1059

<center>&diams;</center>

1060

</td>

1061

<td>

1062

<center>&diams;</center>

1063

</td>

1064

<td>

1065

<center>&diams;</center>

1066

</td>

1067

1068

1069

1070

1071

</tr>

1072

1073

<td>postgres</td>

1074

<td>

1075

<center>&diams;</center>

1076

</td>

1077

<td>

1078

<center>&diams;</center>

1079

</td>

1080

<td>

1081

<center>&diams;</center>

1082

</td>

1083

<td>

1084

<center>&diams;</center>

1085

</td>

1086

<td>

1087

<center>&diams;</center>

1088

</td>

1089

<td>

1090

<center>&diams;</center>

1091

</td>

1092

<td>

1093

<center>&diams;</center>

1094

</td>

1095

</tr>

1096

</table>

1097

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

1098

public</a></p>

1099

<hr />

1100

<h2>Table: <a href="#public.schema">public</a>.<a name=

1101

611

"public.table.archconfig" id=

1102

612

"public.table.archconfig">archconfig</a></h2>

1103

613

1287

797

1288

798

</tr>

1289

799

1290

<td><a href="#public.table.branch">public.branch.id</a> <a href=

1291

"#public.table.changeset">public.changeset.branch#1</a></td>

800

<td><a href="#public.table.branch">public.branch.id</a></td>

1292

801

<td>branch</td>

1293

802

<td>integer</td>

1294

803

1295

804

</tr>

1296

805

1297

<td><a href=

1298

"#public.table.changeset">public.changeset.id#1</a></td>

806

1299

807

<td>changeset</td>

1300

808

<td>integer</td>

1301

809

1414

922

public</a></p>

1415

923

<hr />

1416

924

<h2>Table: <a href="#public.schema">public</a>.<a name=

1417

"public.table.archnamespace" id=

1418

"public.table.archnamespace">archnamespace</a></h2>

1419

1420

<caption>public.archnamespace Structure</caption>

1421

<tr>

1422

1423

1424

1425

<th>Description</th>

1426

</tr>

1427

1428

1429

1430

<td>serial</td>

1431

<td><i>PRIMARY KEY</i></td>

1432

</tr>

1433

1434

<td><a href=

1435

"#public.table.archarchive">public.archarchive.id</a></td>

1436

<td>archarchive</td>

1437

<td>integer</td>

1438

1439

</tr>

1440

1441

1442

<td>category</td>

1443

1444

1445

</tr>

1446

1447

1448

<td>branch</td>

1449

1450

1451

</tr>

1452

1453

1454

<td>version</td>

1455

1456

1457

</tr>

1458

1459

1460

<td>visible</td>

1461

<td>boolean</td>

1462

1463

</tr>

1464

</table>

1465

1466

1467

<p>Tables referencing this one via Foreign Key Constraints:</p>

1468

<ul>

1469

<li><a href="#public.table.branch">public.branch</a></li>

1470

</ul>

1471

1472

1473

1474

1475

<caption>Permissions which apply to public.archnamespace</caption>

1476

<tr>

1477

1478

<th>

1479

<center>Select</center>

1480

</th>

1481

<th>

1482

<center>Insert</center>

1483

</th>

1484

<th>

1485

<center>Update</center>

1486

</th>

1487

<th>

1488

<center>Delete</center>

1489

</th>

1490

<th>

1491

<center>Reference</center>

1492

</th>

1493

<th>

1494

1495

</th>

1496

<th>

1497

<center>Trigger</center>

1498

</th>

1499

</tr>

1500

1501

<td>group admin</td>

1502

<td>

1503

<center>&diams;</center>

1504

</td>

1505

<td>

1506

<center>&diams;</center>

1507

</td>

1508

<td>

1509

<center>&diams;</center>

1510

</td>

1511

<td>

1512

<center>&diams;</center>

1513

</td>

1514

<td>

1515

<center>&diams;</center>

1516

</td>

1517

<td>

1518

<center>&diams;</center>

1519

</td>

1520

<td>

1521

<center>&diams;</center>

1522

</td>

1523

</tr>

1524

1525

<td>group read</td>

1526

<td>

1527

<center>&diams;</center>

1528

</td>

1529

1530

1531

1532

1533

1534

1535

</tr>

1536

1537

<td>group write</td>

1538

<td>

1539

<center>&diams;</center>

1540

</td>

1541

<td>

1542

<center>&diams;</center>

1543

</td>

1544

<td>

1545

<center>&diams;</center>

1546

</td>

1547

1548

1549

1550

1551

</tr>

1552

1553

<td>importd</td>

1554

<td>

1555

<center>&diams;</center>

1556

</td>

1557

<td>

1558

<center>&diams;</center>

1559

</td>

1560

<td>

1561

<center>&diams;</center>

1562

</td>

1563

<td>

1564

<center>&diams;</center>

1565

</td>

1566

1567

1568

1569

</tr>

1570

1571

<td>postgres</td>

1572

<td>

1573

<center>&diams;</center>

1574

</td>

1575

<td>

1576

<center>&diams;</center>

1577

</td>

1578

<td>

1579

<center>&diams;</center>

1580

</td>

1581

<td>

1582

<center>&diams;</center>

1583

</td>

1584

<td>

1585

<center>&diams;</center>

1586

</td>

1587

<td>

1588

<center>&diams;</center>

1589

</td>

1590

<td>

1591

<center>&diams;</center>

1592

</td>

1593

</tr>

1594

1595

<td>sourcerer</td>

1596

<td>

1597

<center>&diams;</center>

1598

</td>

1599

<td>

1600

<center>&diams;</center>

1601

</td>

1602

<td>

1603

<center>&diams;</center>

1604

</td>

1605

1606

1607

1608

1609

</tr>

1610

1611

<td>trebuchet</td>

1612

<td>

1613

<center>&diams;</center>

1614

</td>

1615

1616

1617

1618

1619

1620

1621

</tr>

1622

</table>

1623

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

1624

public</a></p>

1625

<hr />

1626

<h2>Table: <a href="#public.schema">public</a>.<a name=

1627

"public.table.archuserid" id=

1628

"public.table.archuserid">archuserid</a></h2>

1629

1630

<caption>public.archuserid Structure</caption>

1631

<tr>

1632

1633

1634

1635

<th>Description</th>

1636

</tr>

1637

1638

1639

1640

<td>serial</td>

1641

<td><i>PRIMARY KEY</i></td>

1642

</tr>

1643

1644

<td><a href="#public.table.person">public.person.id</a></td>

1645

<td>person</td>

1646

<td>integer</td>

1647

1648

</tr>

1649

1650

1651

<td>archuserid</td>

1652

1653

<td><i>UNIQUE NOT NULL</i></td>

1654

</tr>

1655

</table>

1656

1657

1658

<p>Tables referencing this one via Foreign Key Constraints:</p>

1659

<ul>

1660

<li><a href="#public.table.changeset">public.changeset</a></li>

1661

</ul>

1662

1663

1664

1665

1666

<caption>Permissions which apply to public.archuserid</caption>

1667

<tr>

1668

1669

<th>

1670

<center>Select</center>

1671

</th>

1672

<th>

1673

<center>Insert</center>

1674

</th>

1675

<th>

1676

<center>Update</center>

1677

</th>

1678

<th>

1679

<center>Delete</center>

1680

</th>

1681

<th>

1682

<center>Reference</center>

1683

</th>

1684

<th>

1685

1686

</th>

1687

<th>

1688

<center>Trigger</center>

1689

</th>

1690

</tr>

1691

1692

<td>group admin</td>

1693

<td>

1694

<center>&diams;</center>

1695

</td>

1696

<td>

1697

<center>&diams;</center>

1698

</td>

1699

<td>

1700

<center>&diams;</center>

1701

</td>

1702

<td>

1703

<center>&diams;</center>

1704

</td>

1705

<td>

1706

<center>&diams;</center>

1707

</td>

1708

<td>

1709

<center>&diams;</center>

1710

</td>

1711

<td>

1712

<center>&diams;</center>

1713

</td>

1714

</tr>

1715

1716

<td>group read</td>

1717

<td>

1718

<center>&diams;</center>

1719

</td>

1720

1721

1722

1723

1724

1725

1726

</tr>

1727

1728

<td>group write</td>

1729

<td>

1730

<center>&diams;</center>

1731

</td>

1732

<td>

1733

<center>&diams;</center>

1734

</td>

1735

<td>

1736

<center>&diams;</center>

1737

</td>

1738

<td>

1739

<center>&diams;</center>

1740

</td>

1741

1742

1743

1744

</tr>

1745

1746

<td>postgres</td>

1747

<td>

1748

<center>&diams;</center>

1749

</td>

1750

<td>

1751

<center>&diams;</center>

1752

</td>

1753

<td>

1754

<center>&diams;</center>

1755

</td>

1756

<td>

1757

<center>&diams;</center>

1758

</td>

1759

<td>

1760

<center>&diams;</center>

1761

</td>

1762

<td>

1763

<center>&diams;</center>

1764

</td>

1765

<td>

1766

<center>&diams;</center>

1767

</td>

1768

</tr>

1769

</table>

1770

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

1771

public</a></p>

1772

<hr />

1773

<h2>Table: <a href="#public.schema">public</a>.<a name=

1774

925

"public.table.binarypackagefile" id=

1775

926

"public.table.binarypackagefile">binarypackagefile</a></h2>

1776

927

<p>BinaryPackageFile: A soyuz <-> librarian link table. This

1940

1091

<center>&diams;</center>

1941

1092

</td>

1942

1093

</tr>

1094

1095

<td>uploader</td>

1096

<td>

1097

<center>&diams;</center>

1098

</td>

1099

<td>

1100

<center>&diams;</center>

1101

</td>

1102

1103

1104

1105

1106

1107

</tr>

1943

1108

</table>

1944

1109

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

1945

1110

public</a></p>

2262

1427

</ul>

2263

1428

<ul>

2264

1429

<li><a href=

1430

"#public.table.distroreleasepackagecache">public.distroreleasepackagecache</a></li>

1431

</ul>

1432

<ul>

1433

<li><a href=

2265

1434

"#public.table.packageselection">public.packageselection</a></li>

2266

1435

</ul>

2267

1436

<ul>

2387

1556

<center>&diams;</center>

2388

1557

</td>

2389

1558

</tr>

1559

1560

<td>queued</td>

1561

<td>

1562

<center>&diams;</center>

1563

</td>

1564

1565

1566

1567

1568

1569

1570

</tr>

1571

1572

<td>statistician</td>

1573

<td>

1574

<center>&diams;</center>

1575

</td>

1576

1577

1578

1579

1580

1581

1582

</tr>

1583

1584

<td>targetnamecacheupdater</td>

1585

<td>

1586

<center>&diams;</center>

1587

</td>

1588

1589

1590

1591

1592

1593

1594

</tr>

1595

1596

<td>uploader</td>

1597

<td>

1598

<center>&diams;</center>

1599

</td>

1600

<td>

1601

<center>&diams;</center>

1602

</td>

1603

1604

1605

1606

1607

1608

</tr>

2390

1609

</table>

2391

1610

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

2392

1611

public</a></p>

2686

1905

<center>&diams;</center>

2687

1906

</td>

2688

1907

</tr>

1908

1909

<td>statistician</td>

1910

<td>

1911

<center>&diams;</center>

1912

</td>

1913

1914

1915

1916

1917

1918

1919

</tr>

1920

1921

<td>uploader</td>

1922

<td>

1923

<center>&diams;</center>

1924

</td>

1925

1926

1927

1928

1929

1930

1931

</tr>

2689

1932

</table>

2690

1933

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

2691

1934

public</a></p>

3203

2446

"#public.table.binarypackagename">public.binarypackagename.id</a></td>

3204

2447

<td>binarypackagename</td>

3205

2448

<td>integer</td>

3206

<td><i>UNIQUE#1 NOT NULL</i><br />

2449

<td><i>UNIQUE#1 UNIQUE#2 NOT NULL</i><br />

3207

2450

<br />

3208

2451

A reference to the name of the binary package</td>

3209

2452

</tr>

3236

2479

<td><a href="#public.table.build">public.build.id</a></td>

3237

2480

<td>build</td>

3238

2481

<td>integer</td>

3239

<td><i>UNIQUE#1 NOT NULL</i><br />

2482

<td><i>UNIQUE#1 UNIQUE#2 NOT NULL</i><br />

3240

2483

<br />

3241

2484

The build in which this binarypackage was produced</td>

3242

2485

</tr>

3388

2631

<td>tsvector</td>

3389

2632

3390

2633

</tr>

2634

2635

2636

<td>datecreated</td>

2637

<td>timestamp without time zone</td>

2638

<td><i>NOT NULL DEFAULT timezone('UTC'::text,

2639

('now'::text)::timestamp(6) with time zone)</i></td>

2640

</tr>

3391

2641

</table>

3392

2642

3393

2643

3399

2649

</tr>

3400

2650

3401

2651

<td>valid_version</td>

3402

<td>CHECK (valid_debian_version("version"))</td>

2652

<td>CHECK (valid_debian_version(version))</td>

3403

2653

</tr>

3404

2654

</table>

3405

2655

3534

2784

<center>&diams;</center>

3535

2785

</td>

3536

2786

</tr>

2787

2788

<td>queued</td>

2789

<td>

2790

<center>&diams;</center>

2791

</td>

2792

2793

2794

2795

2796

2797

2798

</tr>

2799

2800

<td>statistician</td>

2801

<td>

2802

<center>&diams;</center>

2803

</td>

2804

2805

2806

2807

2808

2809

2810

</tr>

2811

2812

<td>uploader</td>

2813

<td>

2814

<center>&diams;</center>

2815

</td>

2816

<td>

2817

<center>&diams;</center>

2818

</td>

2819

2820

2821

2822

2823

2824

</tr>

3537

2825

</table>

3538

2826

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

3539

2827

public</a></p>

3671

2959

</ul>

3672

2960

<ul>

3673

2961

<li><a href=

3674

"#public.table.distrobounty">public.distrobounty</a></li>

2962

"#public.table.distributionbounty">public.distributionbounty</a></li>

3675

2963

</ul>

3676

2964

<ul>

3677

2965

<li><a href=

4091

3379

<th>Description</th>

4092

3380

</tr>

4093

3381

4094

3382

<td><a href=

3383

"#public.table.revisionnumber">public.revisionnumber.branch#1</a></td>

4095

3384

4096

3385

<td>serial</td>

4097

3386

<td><i>PRIMARY KEY</i></td>

4098

3387

</tr>

4099

3388

4100

<td><a href=

4101

"#public.table.archnamespace">public.archnamespace.id</a></td>

4102

<td>archnamespace</td>

4103

<td>integer</td>

4104

4105

</tr>

4106

4107

3389

4108

3390

<td>title</td>

4109

3391

4110

3392

4111

3393

</tr>

3394

3395

3396

<td>summary</td>

3397

3398

3399

</tr>

4112

3400

4113

4114

<td>description</td>

4115

4116

4117

</tr>

4118

4119

3401

<td><a href="#public.table.person">public.person.id</a></td>

4120

3402

<td>owner</td>

4121

3403

<td>integer</td>

4122

3404

4123

3405

</tr>

4124

3406

4125

3407

<td><a href="#public.table.product">public.product.id</a></td>

4126

3408

<td>product</td>

4127

3409

<td>integer</td>

4128

3410

4129

3411

</tr>

3412

3413

<td><a href="#public.table.person">public.person.id</a></td>

3414

<td>author</td>

3415

<td>integer</td>

3416

3417

</tr>

3418

3419

3420

3421

3422

3423

</tr>

3424

3425

3426

<td>branch_product_name</td>

3427

3428

3429

</tr>

3430

3431

3432

<td>product_locked</td>

3433

<td>boolean</td>

3434

<td><i>NOT NULL DEFAULT false</i></td>

3435

</tr>

3436

3437

3438

3439

3440

3441

</tr>

3442

3443

3444

<td>branch_home_page</td>

3445

3446

3447

</tr>

3448

3449

3450

<td>home_page_locked</td>

3451

<td>boolean</td>

3452

<td><i>DEFAULT false</i></td>

3453

</tr>

3454

3455

3456

3457

3458

3459

</tr>

3460

3461

3462

<td>whiteboard</td>

3463

3464

3465

</tr>

3466

3467

3468

<td>lifecycle_status</td>

3469

<td>integer</td>

3470

<td><i>NOT NULL DEFAULT 1</i></td>

3471

</tr>

3472

3473

<td><a href="#public.table.branch">public.branch.id</a></td>

3474

<td>landing_target</td>

3475

<td>integer</td>

3476

3477

</tr>

3478

3479

3480

<td>current_delta_url</td>

3481

3482

3483

</tr>

3484

3485

3486

<td>current_conflicts_url</td>

3487

3488

3489

</tr>

3490

3491

3492

<td>current_diff_adds</td>

3493

<td>integer</td>

3494

3495

</tr>

3496

3497

3498

<td>current_diff_deletes</td>

3499

<td>integer</td>

3500

3501

</tr>

3502

3503

3504

<td>stats_updated</td>

3505

<td>timestamp without time zone</td>

3506

3507

</tr>

3508

3509

3510

<td>current_activity</td>

3511

<td>integer</td>

3512

3513

</tr>

3514

3515

3516

<td>last_mirrored</td>

3517

<td>timestamp without time zone</td>

3518

3519

</tr>

3520

3521

3522

<td>last_mirror_attempt</td>

3523

<td>timestamp without time zone</td>

3524

3525

</tr>

3526

3527

3528

<td>mirror_failures</td>

3529

<td>integer</td>

3530

3531

</tr>

3532

3533

3534

<td>pull_disabled</td>

3535

<td>boolean</td>

3536

<td><i>NOT NULL DEFAULT false</i></td>

3537

</tr>

3538

3539

3540

<td>cache_url</td>

3541

3542

3543

</tr>

3544

3545

<td><a href=

3546

"#public.table.revisionnumber">public.revisionnumber.id#1</a>

3547

<a href=

3548

"#public.table.revisionnumber">public.revisionnumber.id</a></td>

3549

<td>started_at</td>

3550

<td>integer</td>

3551

3552

</tr>

4130

3553

</table>

4131

3554

3555

3556

3557

<caption>public.branch Constraints</caption>

3558

<tr>

3559

3560

<th>Constraint</th>

3561

</tr>

3562

3563

<td>valid_branch_home_page</td>

3564

<td>CHECK (valid_absolute_url(branch_home_page))</td>

3565

</tr>

3566

3567

<td>valid_cache_url</td>

3568

<td>CHECK (valid_absolute_url(cache_url))</td>

3569

</tr>

3570

3571

<td>valid_current_conflicts_url</td>

3572

<td>CHECK (valid_absolute_url(current_conflicts_url))</td>

3573

</tr>

3574

3575

<td>valid_current_delta_url</td>

3576

<td>CHECK (valid_absolute_url(current_delta_url))</td>

3577

</tr>

3578

3579

<td>valid_home_page</td>

3580

<td>CHECK (valid_absolute_url(home_page))</td>

3581

</tr>

3582

3583

<td>valid_name</td>

3584

<td>CHECK (valid_branch_name(name))</td>

3585

</tr>

3586

3587

<td>valid_url</td>

3588

<td>CHECK (valid_absolute_url(url))</td>

3589

</tr>

3590

</table>

4132

3591

4133

3592

<p>Tables referencing this one via Foreign Key Constraints:</p>

4134

3593

<ul>

4136

3595

"#public.table.archconfigentry">public.archconfigentry</a></li>

4137

3596

</ul>

4138

3597

<ul>

3598

<li><a href="#public.table.branch">public.branch</a></li>

3599

</ul>

3600

<ul>

4139

3601

<li><a href="#public.table.branchlabel">public.branchlabel</a></li>

4140

3602

</ul>

4141

3603

<ul>

4142

3604

<li><a href=

3605

"#public.table.branchmessage">public.branchmessage</a></li>

3606

</ul>

3607

<ul>

3608

<li><a href=

4143

3609

"#public.table.branchrelationship">public.branchrelationship</a></li>

4144

3610

</ul>

4145

3611

<ul>

4146

<li><a href="#public.table.changeset">public.changeset</a></li>

3612

<li><a href=

3613

"#public.table.branchsubscription">public.branchsubscription</a></li>

4147

3614

</ul>

4148

3615

<ul>

4149

3616

<li><a href=

4157

3624

<li><a href=

4158

3625

"#public.table.productseries">public.productseries</a></li>

4159

3626

</ul>

3627

<ul>

3628

<li><a href=

3629

"#public.table.revisionnumber">public.revisionnumber</a></li>

3630

</ul>

4160

3631

4161

3632

4162

3633

4239

3710

4240

3711

</tr>

4241

3712

3713

<td>importd</td>

3714

<td>

3715

<center>&diams;</center>

3716

</td>

3717

<td>

3718

<center>&diams;</center>

3719

</td>

3720

<td>

3721

<center>&diams;</center>

3722

</td>

3723

3724

3725

3726

3727

</tr>

3728

3729

<td>launchpad</td>

3730

<td>

3731

<center>&diams;</center>

3732

</td>

3733

<td>

3734

<center>&diams;</center>

3735

</td>

3736

<td>

3737

<center>&diams;</center>

3738

</td>

3739

3740

3741

3742

3743

</tr>

3744

4242

3745

<td>postgres</td>

4243

3746

<td>

4244

3747

<center>&diams;</center>

4437

3940

public</a></p>

4438

3941

<hr />

4439

3942

<h2>Table: <a href="#public.schema">public</a>.<a name=

3943

"public.table.branchmessage" id=

3944

"public.table.branchmessage">branchmessage</a></h2>

3945

3946

<caption>public.branchmessage Structure</caption>

3947

<tr>

3948

3949

3950

3951

<th>Description</th>

3952

</tr>

3953

3954

3955

3956

<td>serial</td>

3957

<td><i>PRIMARY KEY</i></td>

3958

</tr>

3959

3960

<td><a href="#public.table.branch">public.branch.id</a></td>

3961

<td>branch</td>

3962

<td>integer</td>

3963

3964

</tr>

3965

3966

<td><a href="#public.table.message">public.message.id</a></td>

3967

<td>message</td>

3968

<td>integer</td>

3969

3970

</tr>

3971

</table>

3972

3973

3974

3975

3976

3977

3978

<caption>Permissions which apply to public.branchmessage</caption>

3979

<tr>

3980

3981

<th>

3982

<center>Select</center>

3983

</th>

3984

<th>

3985

<center>Insert</center>

3986

</th>

3987

<th>

3988

<center>Update</center>

3989

</th>

3990

<th>

3991

<center>Delete</center>

3992

</th>

3993

<th>

3994

<center>Reference</center>

3995

</th>

3996

<th>

3997

3998

</th>

3999

<th>

4000

<center>Trigger</center>

4001

</th>

4002

</tr>

4003

4004

<td>group admin</td>

4005

<td>

4006

<center>&diams;</center>

4007

</td>

4008

<td>

4009

<center>&diams;</center>

4010

</td>

4011

<td>

4012

<center>&diams;</center>

4013

</td>

4014

<td>

4015

<center>&diams;</center>

4016

</td>

4017

<td>

4018

<center>&diams;</center>

4019

</td>

4020

<td>

4021

<center>&diams;</center>

4022

</td>

4023

<td>

4024

<center>&diams;</center>

4025

</td>

4026

</tr>

4027

4028

<td>group read</td>

4029

<td>

4030

<center>&diams;</center>

4031

</td>

4032

4033

4034

4035

4036

4037

4038

</tr>

4039

4040

<td>launchpad</td>

4041

<td>

4042

<center>&diams;</center>

4043

</td>

4044

<td>

4045

<center>&diams;</center>

4046

</td>

4047

4048

4049

4050

4051

4052

</tr>

4053

4054

<td>postgres</td>

4055

<td>

4056

<center>&diams;</center>

4057

</td>

4058

<td>

4059

<center>&diams;</center>

4060

</td>

4061

<td>

4062

<center>&diams;</center>

4063

</td>

4064

<td>

4065

<center>&diams;</center>

4066

</td>

4067

<td>

4068

<center>&diams;</center>

4069

</td>

4070

<td>

4071

<center>&diams;</center>

4072

</td>

4073

<td>

4074

<center>&diams;</center>

4075

</td>

4076

</tr>

4077

</table>

4078

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

4079

public</a></p>

4080

<hr />

4081

<h2>Table: <a href="#public.schema">public</a>.<a name=

4440

4082

"public.table.branchrelationship" id=

4441

4083

"public.table.branchrelationship">branchrelationship</a></h2>

4442

4084

4586

4228

public</a></p>

4587

4229

<hr />

4588

4230

<h2>Table: <a href="#public.schema">public</a>.<a name=

4231

"public.table.branchsubscription" id=

4232

"public.table.branchsubscription">branchsubscription</a></h2>

4233

4234

<caption>public.branchsubscription Structure</caption>

4235

<tr>

4236

4237

4238

4239

<th>Description</th>

4240

</tr>

4241

4242

4243

4244

<td>serial</td>

4245

<td><i>PRIMARY KEY</i></td>

4246

</tr>

4247

4248

<td><a href="#public.table.person">public.person.id</a></td>

4249

<td>person</td>

4250

<td>integer</td>

4251

4252

</tr>

4253

4254

<td><a href="#public.table.branch">public.branch.id</a></td>

4255

<td>branch</td>

4256

<td>integer</td>

4257

4258

</tr>

4259

</table>

4260

4261

4262

4263

4264

4265

4266

<caption>Permissions which apply to

4267

public.branchsubscription</caption>

4268

<tr>

4269

4270

<th>

4271

<center>Select</center>

4272

</th>

4273

<th>

4274

<center>Insert</center>

4275

</th>

4276

<th>

4277

<center>Update</center>

4278

</th>

4279

<th>

4280

<center>Delete</center>

4281

</th>

4282

<th>

4283

<center>Reference</center>

4284

</th>

4285

<th>

4286

4287

</th>

4288

<th>

4289

<center>Trigger</center>

4290

</th>

4291

</tr>

4292

4293

<td>group admin</td>

4294

<td>

4295

<center>&diams;</center>

4296

</td>

4297

<td>

4298

<center>&diams;</center>

4299

</td>

4300

<td>

4301

<center>&diams;</center>

4302

</td>

4303

<td>

4304

<center>&diams;</center>

4305

</td>

4306

<td>

4307

<center>&diams;</center>

4308

</td>

4309

<td>

4310

<center>&diams;</center>

4311

</td>

4312

<td>

4313

<center>&diams;</center>

4314

</td>

4315

</tr>

4316

4317

<td>group read</td>

4318

<td>

4319

<center>&diams;</center>

4320

</td>

4321

4322

4323

4324

4325

4326

4327

</tr>

4328

4329

<td>launchpad</td>

4330

<td>

4331

<center>&diams;</center>

4332

</td>

4333

<td>

4334

<center>&diams;</center>

4335

</td>

4336

<td>

4337

<center>&diams;</center>

4338

</td>

4339

<td>

4340

<center>&diams;</center>

4341

</td>

4342

4343

4344

4345

</tr>

4346

4347

<td>postgres</td>

4348

<td>

4349

<center>&diams;</center>

4350

</td>

4351

<td>

4352

<center>&diams;</center>

4353

</td>

4354

<td>

4355

<center>&diams;</center>

4356

</td>

4357

<td>

4358

<center>&diams;</center>

4359

</td>

4360

<td>

4361

<center>&diams;</center>

4362

</td>

4363

<td>

4364

<center>&diams;</center>

4365

</td>

4366

<td>

4367

<center>&diams;</center>

4368

</td>

4369

</tr>

4370

</table>

4371

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

4372

public</a></p>

4373

<hr />

4374

<h2>Table: <a href="#public.schema">public</a>.<a name=

4589

4375

"public.table.bug" id="public.table.bug">bug</a></h2>

4590

4376

<p>A software bug that requires fixing. This particular bug may be

4591

4377

linked to one or more products or source packages to identify the

4787

4573

</ul>

4788

4574

<ul>

4789

4575

<li><a href=

4790

"#public.table.cverefobsolete">public.cverefobsolete</a></li>

4791

</ul>

4792

<ul>

4793

<li><a href=

4794

4576

"#public.table.specificationbug">public.specificationbug</a></li>

4795

4577

</ul>

4796

4578

<ul>

5354

5136

5355

5137

</tr>

5356

5138

5357

<td>group write</td>

5139

<td>launchpad</td>

5358

5140

<td>

5359

5141

<center>&diams;</center>

5360

5142

</td>

6674

6456

6675

6457

<td>priority</td>

6676

6458

<td>integer</td>

6677

6459

6678

6460

<br />

6679

6461

The importance of fixing this bug.</td>

6680

6462

</tr>

6759

6541

<td>tsvector</td>

6760

6542

6761

6543

</tr>

6544

6545

6546

<td>targetnamecache</td>

6547

6548

6549

<br />

6550

A cached value of the target name of this bugtask, to make it

6551

easier to sort and search on the target name.</td>

6552

</tr>

6762

6553

</table>

6763

6554

6764

6555

6882

6673

<center>&diams;</center>

6883

6674

</td>

6884

6675

</tr>

6676

6677

<td>targetnamecacheupdater</td>

6678

<td>

6679

<center>&diams;</center>

6680

</td>

6681

6682

<td>

6683

<center>&diams;</center>

6684

</td>

6685

6686

6687

6688

6689

</tr>

6885

6690

</table>

6886

6691

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

6887

6692

public</a></p>

7525

7330

<center>&diams;</center>

7526

7331

</td>

7527

7332

</tr>

7333

7334

<td>queued</td>

7335

<td>

7336

<center>&diams;</center>

7337

</td>

7338

7339

7340

7341

7342

7343

7344

</tr>

7345

7346

<td>statistician</td>

7347

<td>

7348

<center>&diams;</center>

7349

</td>

7350

7351

7352

7353

7354

7355

7356

</tr>

7357

7358

<td>uploader</td>

7359

<td>

7360

<center>&diams;</center>

7361

</td>

7362

<td>

7363

<center>&diams;</center>

7364

</td>

7365

7366

7367

7368

7369

7370

</tr>

7528

7371

</table>

7529

7372

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

7530

7373

public</a></p>

7531

7374

<hr />

7532

7375

<h2>Table: <a href="#public.schema">public</a>.<a name=

7533

7376

"public.table.builder" id="public.table.builder">builder</a></h2>

7377

<p>Builder: This table stores the build-slave registry and status

7378

information as: name, url, trusted, builderok, builderaction,

7379

failnotes.</p>

7534

7380

7535

7381

<caption>public.builder Structure</caption>

7536

7382

<tr>

7622

7468

on a given host so this url includes the port number to use. The

7623

7469

default port number for a build slave is 8221</td>

7624

7470

</tr>

7471

7472

7473

<td>manual</td>

7474

<td>boolean</td>

7475

<td><i>DEFAULT false</i><br />

7476

<br />

7477

Whether or not builder was manual mode, i.e., collect any result

7478

from the it, but do not dispach anything to it automatically.</td>

7479

</tr>

7625

7480

</table>

7626

7481

7627

7482

8495

8350

public</a></p>

8496

8351

<hr />

8497

8352

<h2>Table: <a href="#public.schema">public</a>.<a name=

8498

"public.table.changeset" id=

8499

"public.table.changeset">changeset</a></h2>

8500

8501

<caption>public.changeset Structure</caption>

8502

<tr>

8503

8504

8505

8506

<th>Description</th>

8507

</tr>

8508

8509

8510

8511

<td>serial</td>

8512

<td><i>UNIQUE#2 UNIQUE#1 PRIMARY KEY</i></td>

8513

</tr>

8514

8515

<td><a href="#public.table.branch">public.branch.id</a></td>

8516

<td>branch</td>

8517

<td>integer</td>

8518

<td><i>UNIQUE#2 UNIQUE#1 NOT NULL</i></td>

8519

</tr>

8520

8521

8522

<td>datecreated</td>

8523

<td>timestamp without time zone</td>

8524

<td><i>NOT NULL DEFAULT timezone('UTC'::text,

8525

('now'::text)::timestamp(6) with time zone)</i></td>

8526

</tr>

8527

8528

8529

8530

8531

8532

</tr>

8533

8534

8535

<td>logmessage</td>

8536

8537

8538

</tr>

8539

8540

<td><a href=

8541

"#public.table.archuserid">public.archuserid.id</a></td>

8542

<td>archid</td>

8543

<td>integer</td>

8544

8545

</tr>

8546

8547

<td><a href="#public.table.gpgkey">public.gpgkey.id</a></td>

8548

<td>gpgkey</td>

8549

<td>integer</td>

8550

8551

</tr>

8552

</table>

8553

8554

8555

<p>Tables referencing this one via Foreign Key Constraints:</p>

8556

<ul>

8557

<li><a href=

8558

"#public.table.archconfigentry">public.archconfigentry</a></li>

8559

</ul>

8560

<ul>

8561

<li><a href=

8562

"#public.table.changesetfile">public.changesetfile</a></li>

8563

</ul>

8564

<ul>

8565

<li><a href=

8566

"#public.table.manifestentry">public.manifestentry</a></li>

8567

</ul>

8568

8569

8570

8571

8572

<caption>Permissions which apply to public.changeset</caption>

8573

<tr>

8574

8575

<th>

8576

<center>Select</center>

8577

</th>

8578

<th>

8579

<center>Insert</center>

8580

</th>

8581

<th>

8582

<center>Update</center>

8583

</th>

8584

<th>

8585

<center>Delete</center>

8586

</th>

8587

<th>

8588

<center>Reference</center>

8589

</th>

8590

<th>

8591

8592

</th>

8593

<th>

8594

<center>Trigger</center>

8595

</th>

8596

</tr>

8597

8598

<td>group admin</td>

8599

<td>

8600

<center>&diams;</center>

8601

</td>

8602

<td>

8603

<center>&diams;</center>

8604

</td>

8605

<td>

8606

<center>&diams;</center>

8607

</td>

8608

<td>

8609

<center>&diams;</center>

8610

</td>

8611

<td>

8612

<center>&diams;</center>

8613

</td>

8614

<td>

8615

<center>&diams;</center>

8616

</td>

8617

<td>

8618

<center>&diams;</center>

8619

</td>

8620

</tr>

8621

8622

<td>group read</td>

8623

<td>

8624

<center>&diams;</center>

8625

</td>

8626

8627

8628

8629

8630

8631

8632

</tr>

8633

8634

<td>group write</td>

8635

<td>

8636

<center>&diams;</center>

8637

</td>

8638

<td>

8639

<center>&diams;</center>

8640

</td>

8641

<td>

8642

<center>&diams;</center>

8643

</td>

8644

8645

8646

8647

8648

</tr>

8649

8650

<td>postgres</td>

8651

<td>

8652

<center>&diams;</center>

8653

</td>

8654

<td>

8655

<center>&diams;</center>

8656

</td>

8657

<td>

8658

<center>&diams;</center>

8659

</td>

8660

<td>

8661

<center>&diams;</center>

8662

</td>

8663

<td>

8664

<center>&diams;</center>

8665

</td>

8666

<td>

8667

<center>&diams;</center>

8668

</td>

8669

<td>

8670

<center>&diams;</center>

8671

</td>

8672

</tr>

8673

8674

<td>sourcerer</td>

8675

<td>

8676

<center>&diams;</center>

8677

</td>

8678

<td>

8679

<center>&diams;</center>

8680

</td>

8681

<td>

8682

<center>&diams;</center>

8683

</td>

8684

8685

8686

8687

8688

</tr>

8689

8690

<td>trebuchet</td>

8691

<td>

8692

<center>&diams;</center>

8693

</td>

8694

8695

8696

8697

8698

8699

8700

</tr>

8701

</table>

8702

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

8703

public</a></p>

8704

<hr />

8705

<h2>Table: <a href="#public.schema">public</a>.<a name=

8706

"public.table.changesetfile" id=

8707

"public.table.changesetfile">changesetfile</a></h2>

8708

8709

<caption>public.changesetfile Structure</caption>

8710

<tr>

8711

8712

8713

8714

<th>Description</th>

8715

</tr>

8716

8717

8718

8719

<td>serial</td>

8720

<td><i>PRIMARY KEY</i></td>

8721

</tr>

8722

8723

<td><a href="#public.table.changeset">public.changeset.id</a></td>

8724

<td>changeset</td>

8725

<td>integer</td>

8726

<td><i>UNIQUE#1 NOT NULL</i></td>

8727

</tr>

8728

8729

<td><a href=

8730

"#public.table.changesetfilename">public.changesetfilename.id</a></td>

8731

<td>changesetfilename</td>

8732

<td>integer</td>

8733

<td><i>UNIQUE#1 NOT NULL</i></td>

8734

</tr>

8735

8736

8737

<td>filecontents</td>

8738

<td>bytea</td>

8739

8740

</tr>

8741

8742

8743

<td>filesize</td>

8744

<td>integer</td>

8745

8746

</tr>

8747

</table>

8748

8749

8750

<p>Tables referencing this one via Foreign Key Constraints:</p>

8751

<ul>

8752

<li><a href=

8753

"#public.table.changesetfilehash">public.changesetfilehash</a></li>

8754

</ul>

8755

8756

8757

8758

8759

<caption>Permissions which apply to public.changesetfile</caption>

8760

<tr>

8761

8762

<th>

8763

<center>Select</center>

8764

</th>

8765

<th>

8766

<center>Insert</center>

8767

</th>

8768

<th>

8769

<center>Update</center>

8770

</th>

8771

<th>

8772

<center>Delete</center>

8773

</th>

8774

<th>

8775

<center>Reference</center>

8776

</th>

8777

<th>

8778

8779

</th>

8780

<th>

8781

<center>Trigger</center>

8782

</th>

8783

</tr>

8784

8785

<td>group admin</td>

8786

<td>

8787

<center>&diams;</center>

8788

</td>

8789

<td>

8790

<center>&diams;</center>

8791

</td>

8792

<td>

8793

<center>&diams;</center>

8794

</td>

8795

<td>

8796

<center>&diams;</center>

8797

</td>

8798

<td>

8799

<center>&diams;</center>

8800

</td>

8801

<td>

8802

<center>&diams;</center>

8803

</td>

8804

<td>

8805

<center>&diams;</center>

8806

</td>

8807

</tr>

8808

8809

<td>group read</td>

8810

<td>

8811

<center>&diams;</center>

8812

</td>

8813

8814

8815

8816

8817

8818

8819

</tr>

8820

8821

<td>group write</td>

8822

<td>

8823

<center>&diams;</center>

8824

</td>

8825

<td>

8826

<center>&diams;</center>

8827

</td>

8828

<td>

8829

<center>&diams;</center>

8830

</td>

8831

8832

8833

8834

8835

</tr>

8836

8837

<td>postgres</td>

8838

<td>

8839

<center>&diams;</center>

8840

</td>

8841

<td>

8842

<center>&diams;</center>

8843

</td>

8844

<td>

8845

<center>&diams;</center>

8846

</td>

8847

<td>

8848

<center>&diams;</center>

8849

</td>

8850

<td>

8851

<center>&diams;</center>

8852

</td>

8853

<td>

8854

<center>&diams;</center>

8855

</td>

8856

<td>

8857

<center>&diams;</center>

8858

</td>

8859

</tr>

8860

</table>

8861

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

8862

public</a></p>

8863

<hr />

8864

<h2>Table: <a href="#public.schema">public</a>.<a name=

8865

"public.table.changesetfilehash" id=

8866

"public.table.changesetfilehash">changesetfilehash</a></h2>

8867

8868

<caption>public.changesetfilehash Structure</caption>

8869

<tr>

8870

8871

8872

8873

<th>Description</th>

8874

</tr>

8875

8876

8877

8878

<td>serial</td>

8879

<td><i>PRIMARY KEY</i></td>

8880

</tr>

8881

8882

<td><a href=

8883

"#public.table.changesetfile">public.changesetfile.id</a></td>

8884

<td>changesetfile</td>

8885

<td>integer</td>

8886

<td><i>UNIQUE#1 NOT NULL</i></td>

8887

</tr>

8888

8889

8890

<td>hashalg</td>

8891

<td>integer</td>

8892

<td><i>UNIQUE#1 NOT NULL</i></td>

8893

</tr>

8894

8895

8896

8897

<td>bytea</td>

8898

8899

</tr>

8900

</table>

8901

8902

8903

8904

8905

8906

8907

<caption>Permissions which apply to

8908

public.changesetfilehash</caption>

8909

<tr>

8910

8911

<th>

8912

<center>Select</center>

8913

</th>

8914

<th>

8915

<center>Insert</center>

8916

</th>

8917

<th>

8918

<center>Update</center>

8919

</th>

8920

<th>

8921

<center>Delete</center>

8922

</th>

8923

<th>

8924

<center>Reference</center>

8925

</th>

8926

<th>

8927

8928

</th>

8929

<th>

8930

<center>Trigger</center>

8931

</th>

8932

</tr>

8933

8934

<td>group admin</td>

8935

<td>

8936

<center>&diams;</center>

8937

</td>

8938

<td>

8939

<center>&diams;</center>

8940

</td>

8941

<td>

8942

<center>&diams;</center>

8943

</td>

8944

<td>

8945

<center>&diams;</center>

8946

</td>

8947

<td>

8948

<center>&diams;</center>

8949

</td>

8950

<td>

8951

<center>&diams;</center>

8952

</td>

8953

<td>

8954

<center>&diams;</center>

8955

</td>

8956

</tr>

8957

8958

<td>group read</td>

8959

<td>

8960

<center>&diams;</center>

8961

</td>

8962

8963

8964

8965

8966

8967

8968

</tr>

8969

8970

<td>group write</td>

8971

<td>

8972

<center>&diams;</center>

8973

</td>

8974

<td>

8975

<center>&diams;</center>

8976

</td>

8977

<td>

8978

<center>&diams;</center>

8979

</td>

8980

8981

8982

8983

8984

</tr>

8985

8986

<td>postgres</td>

8987

<td>

8988

<center>&diams;</center>

8989

</td>

8990

<td>

8991

<center>&diams;</center>

8992

</td>

8993

<td>

8994

<center>&diams;</center>

8995

</td>

8996

<td>

8997

<center>&diams;</center>

8998

</td>

8999

<td>

9000

<center>&diams;</center>

9001

</td>

9002

<td>

9003

<center>&diams;</center>

9004

</td>

9005

<td>

9006

<center>&diams;</center>

9007

</td>

9008

</tr>

9009

</table>

9010

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

9011

public</a></p>

9012

<hr />

9013

<h2>Table: <a href="#public.schema">public</a>.<a name=

9014

"public.table.changesetfilename" id=

9015

"public.table.changesetfilename">changesetfilename</a></h2>

9016

9017

<caption>public.changesetfilename Structure</caption>

9018

<tr>

9019

9020

9021

9022

<th>Description</th>

9023

</tr>

9024

9025

9026

9027

<td>serial</td>

9028

<td><i>PRIMARY KEY</i></td>

9029

</tr>

9030

9031

9032

<td>filename</td>

9033

9034

<td><i>UNIQUE NOT NULL</i></td>

9035

</tr>

9036

</table>

9037

9038

9039

<p>Tables referencing this one via Foreign Key Constraints:</p>

9040

<ul>

9041

<li><a href=

9042

"#public.table.changesetfile">public.changesetfile</a></li>

9043

</ul>

9044

9045

9046

9047

9048

<caption>Permissions which apply to

9049

public.changesetfilename</caption>

9050

<tr>

9051

9052

<th>

9053

<center>Select</center>

9054

</th>

9055

<th>

9056

<center>Insert</center>

9057

</th>

9058

<th>

9059

<center>Update</center>

9060

</th>

9061

<th>

9062

<center>Delete</center>

9063

</th>

9064

<th>

9065

<center>Reference</center>

9066

</th>

9067

<th>

9068

9069

</th>

9070

<th>

9071

<center>Trigger</center>

9072

</th>

9073

</tr>

9074

9075

<td>group admin</td>

9076

<td>

9077

<center>&diams;</center>

9078

</td>

9079

<td>

9080

<center>&diams;</center>

9081

</td>

9082

<td>

9083

<center>&diams;</center>

9084

</td>

9085

<td>

9086

<center>&diams;</center>

9087

</td>

9088

<td>

9089

<center>&diams;</center>

9090

</td>

9091

<td>

9092

<center>&diams;</center>

9093

</td>

9094

<td>

9095

<center>&diams;</center>

9096

</td>

9097

</tr>

9098

9099

<td>group read</td>

9100

<td>

9101

<center>&diams;</center>

9102

</td>

9103

9104

9105

9106

9107

9108

9109

</tr>

9110

9111

<td>group write</td>

9112

<td>

9113

<center>&diams;</center>

9114

</td>

9115

<td>

9116

<center>&diams;</center>

9117

</td>

9118

<td>

9119

<center>&diams;</center>

9120

</td>

9121

9122

9123

9124

9125

</tr>

9126

9127

<td>postgres</td>

9128

<td>

9129

<center>&diams;</center>

9130

</td>

9131

<td>

9132

<center>&diams;</center>

9133

</td>

9134

<td>

9135

<center>&diams;</center>

9136

</td>

9137

<td>

9138

<center>&diams;</center>

9139

</td>

9140

<td>

9141

<center>&diams;</center>

9142

</td>

9143

<td>

9144

<center>&diams;</center>

9145

</td>

9146

<td>

9147

<center>&diams;</center>

9148

</td>

9149

</tr>

9150

</table>

9151

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

9152

public</a></p>

9153

<hr />

9154

<h2>Table: <a href="#public.schema">public</a>.<a name=

9155

8353

"public.table.component" id=

9156

8354

"public.table.component">component</a></h2>

9157

8355

9200

8398

</ul>

9201

8399

<ul>

9202

8400

<li><a href=

8401

"#public.table.distrocomponentuploader">public.distrocomponentuploader</a></li>

8402

</ul>

8403

<ul>

8404

<li><a href=

9203

8405

"#public.table.mirrorcontent">public.mirrorcontent</a></li>

9204

8406

</ul>

9205

8407

<ul>

9339

8541

<center>&diams;</center>

9340

8542

</td>

9341

8543

</tr>

8544

8545

<td>queued</td>

8546

<td>

8547

<center>&diams;</center>

8548

</td>

8549

8550

8551

8552

8553

8554

8555

</tr>

8556

8557

<td>uploader</td>

8558

<td>

8559

<center>&diams;</center>

8560

</td>

8561

8562

8563

8564

8565

8566

8567

</tr>

9342

8568

</table>

9343

8569

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

9344

8570

public</a></p>

9482

8708

<center>&diams;</center>

9483

8709

</td>

9484

8710

</tr>

8711

8712

<td>uploader</td>

8713

<td>

8714

<center>&diams;</center>

8715

</td>

8716

8717

8718

8719

8720

8721

8722

</tr>

9485

8723

</table>

9486

8724

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

9487

8725

public</a></p>

9543

8781

<li><a href="#public.table.person">public.person</a></li>

9544

8782

</ul>

9545

8783

<ul>

8784

<li><a href=

8785

"#public.table.shippingrequest">public.shippingrequest</a></li>

8786

</ul>

8787

<ul>

9546

8788

<li><a href="#public.table.spokenin">public.spokenin</a></li>

9547

8789

</ul>

9548

8790

9650

8892

<center>&diams;</center>

9651

8893

</td>

9652

8894

</tr>

8895

8896

<td>shipit</td>

8897

<td>

8898

<center>&diams;</center>

8899

</td>

8900

8901

8902

8903

8904

8905

8906

</tr>

9653

8907

</table>

9654

8908

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

9655

8909

public</a></p>

9775

9029

</th>

9776

9030

</tr>

9777

9031

9032

9033

<td>

9034

<center>&diams;</center>

9035

</td>

9036

<td>

9037

<center>&diams;</center>

9038

</td>

9039

<td>

9040

<center>&diams;</center>

9041

</td>

9042

9043

9044

9045

9046

</tr>

9047

9778

9048

<td>group admin</td>

9779

9049

<td>

9780

9050

<center>&diams;</center>

9798

9068

<center>&diams;</center>

9799

9069

</td>

9800

9070

</tr>

9801

9071

9802

9072

<td>group read</td>

9803

9073

<td>

9804

9074

<center>&diams;</center>

9810

9080

9811

9081

9812

9082

</tr>

9083

9084

<td>launchpad</td>

9085

<td>

9086

<center>&diams;</center>

9087

</td>

9088

<td>

9089

<center>&diams;</center>

9090

</td>

9091

<td>

9092

<center>&diams;</center>

9093

</td>

9094

9095

9096

9097

9098

</tr>

9813

9099

9814

<td>group write</td>

9815

<td>

9816

<center>&diams;</center>

9817

</td>

9818

<td>

9819

<center>&diams;</center>

9820

</td>

9821

<td>

9822

<center>&diams;</center>

9823

</td>

9824

9825

9826

9827

9828

</tr>

9829

9830

9100

<td>postgres</td>

9831

9101

<td>

9832

9102

<center>&diams;</center>

9946

9216

</th>

9947

9217

</tr>

9948

9218

9949

<td>group admin</td>

9950

<td>

9951

<center>&diams;</center>

9952

</td>

9953

<td>

9954

<center>&diams;</center>

9955

</td>

9956

<td>

9957

<center>&diams;</center>

9958

</td>

9959

<td>

9960

<center>&diams;</center>

9961

</td>

9962

<td>

9963

<center>&diams;</center>

9964

</td>

9965

<td>

9966

<center>&diams;</center>

9967

</td>

9968

<td>

9969

<center>&diams;</center>

9970

</td>

9971

</tr>

9972

9973

<td>group read</td>

9974

<td>

9975

<center>&diams;</center>

9976

</td>

9977

9978

9979

9980

9981

9982

9983

</tr>

9984

9985

<td>group write</td>

9986

<td>

9987

<center>&diams;</center>

9988

</td>

9989

<td>

9990

<center>&diams;</center>

9991

</td>

9992

<td>

9993

<center>&diams;</center>

9994

</td>

9995

<td>

9996

<center>&diams;</center>

9997

</td>

9998

9999

10000

10001

</tr>

10002

10003

<td>postgres</td>

10004

<td>

10005

<center>&diams;</center>

10006

</td>

10007

<td>

10008

<center>&diams;</center>

10009

</td>

10010

<td>

10011

<center>&diams;</center>

10012

</td>

10013

<td>

10014

<center>&diams;</center>

10015

</td>

10016

<td>

10017

<center>&diams;</center>

10018

</td>

10019

<td>

10020

<center>&diams;</center>

10021

</td>

10022

<td>

10023

<center>&diams;</center>

10024

</td>

10025

</tr>

10026

</table>

10027

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

10028

public</a></p>

10029

<hr />

10030

<h2>Table: <a href="#public.schema">public</a>.<a name=

10031

"public.table.cverefobsolete" id=

10032

"public.table.cverefobsolete">cverefobsolete</a></h2>

10033

<p>OBSOLETE: THIS TABLE IS PARKED AND WILL BE DELETED IN FAVOUR OF

10034

THE NEW CVE TABLE. This table stores CVE references for bugs. CVE

10035

is a way of tracking security problems across multiple vendor

10036

products.</p>

10037

10038

<caption>public.cverefobsolete Structure</caption>

10039

<tr>

10040

10041

10042

10043

<th>Description</th>

10044

</tr>

10045

10046

10047

10048

<td>serial</td>

10049

<td><i>PRIMARY KEY</i></td>

10050

</tr>

10051

10052

<td><a href="#public.table.bug">public.bug.id</a></td>

10053

10054

<td>integer</td>

10055

10056

</tr>

10057

10058

10059

<td>cveref</td>

10060

10061

10062

<br />

10063

This is the actual CVE number assigned to this specific

10064

problem.</td>

10065

</tr>

10066

10067

10068

<td>title</td>

10069

10070

10071

</tr>

10072

10073

10074

<td>datecreated</td>

10075

<td>timestamp without time zone</td>

10076

<td><i>DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6)

10077

with time zone)</i></td>

10078

</tr>

10079

10080

<td><a href="#public.table.person">public.person.id</a></td>

10081

<td>owner</td>

10082

<td>integer</td>

10083

10084

<br />

10085

This refers to the person who created the entry.</td>

10086

</tr>

10087

10088

10089

<td>cvestate</td>

10090

<td>integer</td>

10091

<td><i>NOT NULL DEFAULT 1</i><br />

10092

<br />

10093

This is a dbschema enum which tells us the state (CVE or CAN) of

10094

the CVE problem report. It is defined in dbschema.CVEState</td>

10095

</tr>

10096

</table>

10097

10098

10099

10100

<caption>public.cverefobsolete Constraints</caption>

10101

<tr>

10102

10103

<th>Constraint</th>

10104

</tr>

10105

10106

<td>valid_cve</td>

10107

<td>CHECK (valid_cve(cveref))</td>

10108

</tr>

10109

</table>

10110

10111

10112

10113

10114

10115

<caption>Permissions which apply to public.cverefobsolete</caption>

10116

<tr>

10117

10118

<th>

10119

<center>Select</center>

10120

</th>

10121

<th>

10122

<center>Insert</center>

10123

</th>

10124

<th>

10125

<center>Update</center>

10126

</th>

10127

<th>

10128

<center>Delete</center>

10129

</th>

10130

<th>

10131

<center>Reference</center>

10132

</th>

10133

<th>

10134

10135

</th>

10136

<th>

10137

<center>Trigger</center>

10138

</th>

10139

</tr>

10140

10141

<td>group admin</td>

10142

<td>

10143

<center>&diams;</center>

10144

</td>

10145

<td>

10146

<center>&diams;</center>

10147

</td>

10148

<td>

10149

<center>&diams;</center>

10150

</td>

10151

<td>

10152

<center>&diams;</center>

10153

</td>

10154

<td>

10155

<center>&diams;</center>

10156

</td>

10157

<td>

10158

<center>&diams;</center>

10159

</td>

10160

<td>

10161

<center>&diams;</center>

10162

</td>

10163

</tr>

10164

10165

<td>group read</td>

10166

<td>

10167

<center>&diams;</center>

10168

</td>

10169

10170

10171

10172

10173

10174

10175

</tr>

10176

10177

<td>group write</td>

10178

<td>

10179

<center>&diams;</center>

10180

</td>

10181

10182

<td>

10183

<center>&diams;</center>

10184

</td>

10185

10186

10187

10188

10189

</tr>

10190

9219

9220

<td>

9221

<center>&diams;</center>

9222

</td>

9223

<td>

9224

<center>&diams;</center>

9225

</td>

9226

<td>

9227

<center>&diams;</center>

9228

</td>

9229

<td>

9230

<center>&diams;</center>

9231

</td>

9232

9233

9234

9235

</tr>

9236

9237

<td>group admin</td>

9238

<td>

9239

<center>&diams;</center>

9240

</td>

9241

<td>

9242

<center>&diams;</center>

9243

</td>

9244

<td>

9245

<center>&diams;</center>

9246

</td>

9247

<td>

9248

<center>&diams;</center>

9249

</td>

9250

<td>

9251

<center>&diams;</center>

9252

</td>

9253

<td>

9254

<center>&diams;</center>

9255

</td>

9256

<td>

9257

<center>&diams;</center>

9258

</td>

9259

</tr>

9260

9261

<td>group read</td>

9262

<td>

9263

<center>&diams;</center>

9264

</td>

9265

9266

9267

9268

9269

9270

9271

</tr>

9272

9273

<td>launchpad</td>

9274

<td>

9275

<center>&diams;</center>

9276

</td>

9277

<td>

9278

<center>&diams;</center>

9279

</td>

9280

9281

9282

9283

9284

9285

</tr>

9286

10191

9287

<td>postgres</td>

10192

9288

<td>

10193

9289

<center>&diams;</center>

10521

9617

completely closed (only designated translators can make any changes

10522

9618

at all).</td>

10523

9619

</tr>

9620

9621

9622

<td>uploadsender</td>

9623

9624

9625

<br />

9626

The email address (and name) of the default sender used by the

9627

upload processor. If NULL, we fall back to the default sender in

9628

the launchpad config.</td>

9629

</tr>

9630

9631

9632

<td>uploadadmin</td>

9633

9634

9635

<br />

9636

The email address (and name) of the default recipient used by the

9637

upload processor. This is essentially the upload admin for the

9638

distribution. If NULL, we fall back to the default recipient in the

9639

launchpad config.</td>

9640

</tr>

9641

9642

<td><a href="#public.table.person">public.person.id</a></td>

9643

<td>bugcontact</td>

9644

<td>integer</td>

9645

9646

<br />

9647

Person who will be automatically subscribed to every bug targeted

9648

to this distribution.</td>

9649

</tr>

10524

9650

</table>

10525

9651

10526

9652

10542

9668

</ul>

10543

9669

<ul>

10544

9670

<li><a href=

10545

"#public.table.distrobounty">public.distrobounty</a></li>

9671

"#public.table.distributionbounty">public.distributionbounty</a></li>

9672

</ul>

9673

<ul>

9674

<li><a href=

9675

"#public.table.distributionsourcepackagecache">public.distributionsourcepackagecache</a></li>

9676

</ul>

9677

<ul>

9678

<li><a href=

9679

"#public.table.distrocomponentuploader">public.distrocomponentuploader</a></li>

10546

9680

</ul>

10547

9681

<ul>

10548

9682

<li><a href=

10560

9694

</ul>

10561

9695

<ul>

10562

9696

<li><a href=

9697

"#public.table.packagebugcontact">public.packagebugcontact</a></li>

9698

</ul>

9699

<ul>

9700

<li><a href=

10563

9701

"#public.table.specification">public.specification</a></li>

10564

9702

</ul>

10565

9703

<ul>

10609

9747

10610

9748

</tr>

10611

9749

9750

9751

<td>

9752

<center>&diams;</center>

9753

</td>

9754

9755

9756

9757

9758

9759

9760

</tr>

9761

10612

9762

<td>group admin</td>

10613

9763

<td>

10614

9764

<center>&diams;</center>

10632

9782

<center>&diams;</center>

10633

9783

</td>

10634

9784

</tr>

10635

9785

10636

9786

<td>group read</td>

10637

9787

<td>

10638

9788

<center>&diams;</center>

10644

9794

10645

9795

10646

9796

</tr>

10647

9797

10648

9798

<td>group write</td>

10649

9799

<td>

10650

9800

<center>&diams;</center>

10660

9810

10661

9811

10662

9812

</tr>

10663

9813

10664

9814

<td>poexport</td>

10665

9815

<td>

10666

9816

<center>&diams;</center>

10672

9822

10673

9823

10674

9824

</tr>

9825

9826

<td>postgres</td>

9827

<td>

9828

<center>&diams;</center>

9829

</td>

9830

<td>

9831

<center>&diams;</center>

9832

</td>

9833

<td>

9834

<center>&diams;</center>

9835

</td>

9836

<td>

9837

<center>&diams;</center>

9838

</td>

9839

<td>

9840

<center>&diams;</center>

9841

</td>

9842

<td>

9843

<center>&diams;</center>

9844

</td>

9845

<td>

9846

<center>&diams;</center>

9847

</td>

9848

</tr>

10675

9849

10676

<td>postgres</td>

10677

<td>

10678

<center>&diams;</center>

10679

</td>

10680

<td>

10681

<center>&diams;</center>

10682

</td>

10683

<td>

10684

<center>&diams;</center>

10685

</td>

10686

<td>

10687

<center>&diams;</center>

10688

</td>

10689

<td>

10690

<center>&diams;</center>

10691

</td>

10692

<td>

10693

<center>&diams;</center>

10694

</td>

10695

<td>

10696

<center>&diams;</center>

10697

</td>

9850

<td>queued</td>

9851

<td>

9852

<center>&diams;</center>

9853

</td>

9854

9855

9856

9857

9858

9859

10698

9860

</tr>

10699

9861

10700

9862

<td>sourcerer</td>

10721

9883

10722

9884

</tr>

10723

9885

9886

<td>targetnamecacheupdater</td>

9887

<td>

9888

<center>&diams;</center>

9889

</td>

9890

9891

9892

9893

9894

9895

9896

</tr>

9897

9898

<td>tickettracker</td>

9899

<td>

9900

<center>&diams;</center>

9901

</td>

9902

9903

9904

9905

9906

9907

9908

</tr>

9909

10724

9910

<td>trebuchet</td>

10725

9911

<td>

10726

9912

<center>&diams;</center>

10732

9918

10733

9919

10734

9920

</tr>

9921

9922

<td>uploader</td>

9923

<td>

9924

<center>&diams;</center>

9925

</td>

9926

9927

9928

9929

9930

9931

9932

</tr>

9933

</table>

9934

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

9935

public</a></p>

9936

<hr />

9937

<h2>Table: <a href="#public.schema">public</a>.<a name=

9938

"public.table.distributionbounty" id=

9939

"public.table.distributionbounty">distributionbounty</a></h2>

9940

<p>This table records a simple link between a bounty and a

9941

distribution. This bounty will be listed on the distribution web

9942

page, and the distribution will be mentioned on the bounty web

9943

page.</p>

9944

9945

<caption>public.distributionbounty Structure</caption>

9946

<tr>

9947

9948

9949

9950

<th>Description</th>

9951

</tr>

9952

9953

9954

9955

<td>serial</td>

9956

<td><i>PRIMARY KEY</i></td>

9957

</tr>

9958

9959

<td><a href="#public.table.bounty">public.bounty.id</a></td>

9960

<td>bounty</td>

9961

<td>integer</td>

9962

<td><i>UNIQUE#1 NOT NULL</i></td>

9963

</tr>

9964

9965

<td><a href=

9966

"#public.table.distribution">public.distribution.id</a></td>

9967

<td>distribution</td>

9968

<td>integer</td>

9969

<td><i>UNIQUE#1 NOT NULL</i></td>

9970

</tr>

9971

</table>

9972

9973

9974

9975

9976

9977

9978

<caption>Permissions which apply to

9979

public.distributionbounty</caption>

9980

<tr>

9981

9982

<th>

9983

<center>Select</center>

9984

</th>

9985

<th>

9986

<center>Insert</center>

9987

</th>

9988

<th>

9989

<center>Update</center>

9990

</th>

9991

<th>

9992

<center>Delete</center>

9993

</th>

9994

<th>

9995

<center>Reference</center>

9996

</th>

9997

<th>

9998

9999

</th>

10000

<th>

10001

<center>Trigger</center>

10002

</th>

10003

</tr>

10004

10005

<td>group admin</td>

10006

<td>

10007

<center>&diams;</center>

10008

</td>

10009

<td>

10010

<center>&diams;</center>

10011

</td>

10012

<td>

10013

<center>&diams;</center>

10014

</td>

10015

<td>

10016

<center>&diams;</center>

10017

</td>

10018

<td>

10019

<center>&diams;</center>

10020

</td>

10021

<td>

10022

<center>&diams;</center>

10023

</td>

10024

<td>

10025

<center>&diams;</center>

10026

</td>

10027

</tr>

10028

10029

<td>group read</td>

10030

<td>

10031

<center>&diams;</center>

10032

</td>

10033

10034

10035

10036

10037

10038

10039

</tr>

10040

10041

<td>launchpad</td>

10042

<td>

10043

<center>&diams;</center>

10044

</td>

10045

<td>

10046

<center>&diams;</center>

10047

</td>

10048

<td>

10049

<center>&diams;</center>

10050

</td>

10051

10052

10053

10054

10055

</tr>

10056

10057

<td>postgres</td>

10058

<td>

10059

<center>&diams;</center>

10060

</td>

10061

<td>

10062

<center>&diams;</center>

10063

</td>

10064

<td>

10065

<center>&diams;</center>

10066

</td>

10067

<td>

10068

<center>&diams;</center>

10069

</td>

10070

<td>

10071

<center>&diams;</center>

10072

</td>

10073

<td>

10074

<center>&diams;</center>

10075

</td>

10076

<td>

10077

<center>&diams;</center>

10078

</td>

10079

</tr>

10080

</table>

10081

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

10082

public</a></p>

10083

<hr />

10084

<h2>Table: <a href="#public.schema">public</a>.<a name=

10085

"public.table.distributionsourcepackagecache" id=

10086

"public.table.distributionsourcepackagecache">distributionsourcepackagecache</a></h2>

10087

<p>A cache of the text associated with binary and source packages

10088

in the distribution. This table allows for fast queries to find a

10089

source packagename that matches a given text.</p>

10090

10091

<caption>public.distributionsourcepackagecache Structure</caption>

10092

<tr>

10093

10094

10095

10096

<th>Description</th>

10097

</tr>

10098

10099

10100

10101

<td>serial</td>

10102

<td><i>PRIMARY KEY</i></td>

10103

</tr>

10104

10105

<td><a href=

10106

"#public.table.distribution">public.distribution.id</a></td>

10107

<td>distribution</td>

10108

<td>integer</td>

10109

<td><i>UNIQUE#1 NOT NULL</i><br />

10110

<br />

10111

The distribution in which we are checking.</td>

10112

</tr>

10113

10114

<td><a href=

10115

"#public.table.sourcepackagename">public.sourcepackagename.id</a></td>

10116

<td>sourcepackagename</td>

10117

<td>integer</td>

10118

<td><i>UNIQUE#1 NOT NULL</i><br />

10119

<br />

10120

The source package name for which we are caching details.</td>

10121

</tr>

10122

10123

10124

10125

10126

10127

<br />

10128

The source package name itself. This is just a copy of the value of

10129

sourcepackagename.name. We have it here so it can be part of the

10130

full text index.</td>

10131

</tr>

10132

10133

10134

<td>binpkgnames</td>

10135

10136

10137

<br />

10138

The binary package names of binary packages generated from these

10139

source packages across all architectures.</td>

10140

</tr>

10141

10142

10143

<td>binpkgsummaries</td>

10144

10145

10146

<br />

10147

The aggregated summaries of all the binary packages generated from

10148

these source packages in this distribution.</td>

10149

</tr>

10150

10151

10152

<td>binpkgdescriptions</td>

10153

10154

10155

<br />

10156

The aggregated description of all the binary packages generated

10157

from these source packages in this distribution.</td>

10158

</tr>

10159

10160

10161

10162

<td>tsvector</td>

10163

10164

</tr>

10165

</table>

10166

10167

10168

10169

10170

10171

10172

<caption>Permissions which apply to

10173

public.distributionsourcepackagecache</caption>

10174

<tr>

10175

10176

<th>

10177

<center>Select</center>

10178

</th>

10179

<th>

10180

<center>Insert</center>

10181

</th>

10182

<th>

10183

<center>Update</center>

10184

</th>

10185

<th>

10186

<center>Delete</center>

10187

</th>

10188

<th>

10189

<center>Reference</center>

10190

</th>

10191

<th>

10192

10193

</th>

10194

<th>

10195

<center>Trigger</center>

10196

</th>

10197

</tr>

10198

10199

<td>group admin</td>

10200

<td>

10201

<center>&diams;</center>

10202

</td>

10203

<td>

10204

<center>&diams;</center>

10205

</td>

10206

<td>

10207

<center>&diams;</center>

10208

</td>

10209

<td>

10210

<center>&diams;</center>

10211

</td>

10212

<td>

10213

<center>&diams;</center>

10214

</td>

10215

<td>

10216

<center>&diams;</center>

10217

</td>

10218

<td>

10219

<center>&diams;</center>

10220

</td>

10221

</tr>

10222

10223

<td>group read</td>

10224

<td>

10225

<center>&diams;</center>

10226

</td>

10227

10228

10229

10230

10231

10232

10233

</tr>

10234

10235

<td>launchpad</td>

10236

<td>

10237

<center>&diams;</center>

10238

</td>

10239

10240

10241

10242

10243

10244

10245

</tr>

10246

10247

<td>postgres</td>

10248

<td>

10249

<center>&diams;</center>

10250

</td>

10251

<td>

10252

<center>&diams;</center>

10253

</td>

10254

<td>

10255

<center>&diams;</center>

10256

</td>

10257

<td>

10258

<center>&diams;</center>

10259

</td>

10260

<td>

10261

<center>&diams;</center>

10262

</td>

10263

<td>

10264

<center>&diams;</center>

10265

</td>

10266

<td>

10267

<center>&diams;</center>

10268

</td>

10269

</tr>

10270

10271

<td>statistician</td>

10272

<td>

10273

<center>&diams;</center>

10274

</td>

10275

<td>

10276

<center>&diams;</center>

10277

</td>

10278

<td>

10279

<center>&diams;</center>

10280

</td>

10281

<td>

10282

<center>&diams;</center>

10283

</td>

10284

10285

10286

10287

</tr>

10735

10288

</table>

10736

10289

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

10737

10290

public</a></p>

10794

10347

<td>integer</td>

10795

10348

10796

10349

</tr>

10350

10351

10352

<td>official</td>

10353

<td>boolean</td>

10354

10355

<br />

10356

Whether or not this architecture or "port" is an official release.

10357

If it is not official then you may not be able to install it or get

10358

all the packages for it.</td>

10359

</tr>

10360

10361

10362

<td>package_count</td>

10363

<td>integer</td>

10364

10365

<br />

10366

A cache of the number of binary packages published in this distro

10367

arch release. The count only includes packages published in the

10368

release pocket.</td>

10369

</tr>

10797

10370

</table>

10798

10371

10799

10372

10803

10376

</ul>

10804

10377

<ul>

10805

10378

<li><a href=

10379

"#public.table.distrorelease">public.distrorelease</a></li>

10380

</ul>

10381

<ul>

10382

<li><a href=

10806

10383

"#public.table.mirrorcontent">public.mirrorcontent</a></li>

10807

10384

</ul>

10808

10385

<ul>

10933

10510

<center>&diams;</center>

10934

10511

</td>

10935

10512

</tr>

10513

10514

<td>queued</td>

10515

<td>

10516

<center>&diams;</center>

10517

</td>

10518

10519

10520

10521

10522

10523

10524

</tr>

10525

10526

<td>statistician</td>

10527

<td>

10528

<center>&diams;</center>

10529

</td>

10530

10531

<td>

10532

<center>&diams;</center>

10533

</td>

10534

10535

10536

10537

10538

</tr>

10539

10540

<td>uploader</td>

10541

<td>

10542

<center>&diams;</center>

10543

</td>

10544

10545

10546

10547

10548

10549

10550

</tr>

10936

10551

</table>

10937

10552

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

10938

10553

public</a></p>

10939

10554

<hr />

10940

10555

<h2>Table: <a href="#public.schema">public</a>.<a name=

10941

"public.table.distrobounty" id=

10942

"public.table.distrobounty">distrobounty</a></h2>

10943

<p>This table records a simple link between a bounty and a

10944

distribution. This bounty will be listed on the distribution web

10945

page, and the distribution will be mentioned on the bounty web

10946

page.</p>

10556

"public.table.distrocomponentuploader" id=

10557

"public.table.distrocomponentuploader">distrocomponentuploader</a></h2>

10558

<p>DistroComponentUploader: A record of who can upload what to

10559

where. Distributions are permitted to have multiple components.

10560

Those components are often subject to different uploader

10561

constraints. This table represents those variable constraints by

10562

linking a team to a distribution,component tuple.</p>

10947

10563

10948

<caption>public.distrobounty Structure</caption>

10564

<caption>public.distrocomponentuploader Structure</caption>

10949

10565

<tr>

10950

10566

10951

10567

10959

10575

<td><i>PRIMARY KEY</i></td>

10960

10576

</tr>

10961

10577

10962

<td><a href="#public.table.bounty">public.bounty.id</a></td>

10963

<td>bounty</td>

10964

<td>integer</td>

10965

<td><i>UNIQUE#1 NOT NULL</i></td>

10966

</tr>

10967

10968

10578

<td><a href=

10969

10579

"#public.table.distribution">public.distribution.id</a></td>

10970

10580

<td>distribution</td>

10971

10581

<td>integer</td>

10972

<td><i>UNIQUE#1 NOT NULL</i></td>

10582

<td><i>UNIQUE#1 NOT NULL</i><br />

10583

<br />

10584

The distribution to which this upload permission applies.</td>

10585

</tr>

10586

10587

<td><a href="#public.table.component">public.component.id</a></td>

10588

<td>component</td>

10589

<td>integer</td>

10590

<td><i>UNIQUE#1 NOT NULL</i><br />

10591

<br />

10592

The component to which this upload permission applies.</td>

10593

</tr>

10594

10595

<td><a href="#public.table.person">public.person.id</a></td>

10596

<td>uploader</td>

10597

<td>integer</td>

10598

10599

<br />

10600

The uploader(s) permitted to upload to the given component in the

10601

given distribution. This is commonly a team but may be a single

10602

person in the case of a simple distribution.</td>

10973

10603

</tr>

10974

10604

</table>

10975

10605

10978

10608

10979

10609

10980

10610

10981

<caption>Permissions which apply to public.distrobounty</caption>

10611

<caption>Permissions which apply to

10612

public.distrocomponentuploader</caption>

10982

10613

<tr>

10983

10614

10984

10615

<th>

11040

10671

11041

10672

</tr>

11042

10673

11043

<td>launchpad</td>

10674

<td>group write</td>

11044

10675

<td>

11045

10676

<center>&diams;</center>

11046

10677

</td>

11079

10710

<center>&diams;</center>

11080

10711

</td>

11081

10712

</tr>

10713

10714

<td>uploader</td>

10715

<td>

10716

<center>&diams;</center>

10717

</td>

10718

10719

10720

10721

10722

10723

10724

</tr>

11082

10725

</table>

11083

10726

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

11084

10727

public</a></p>

11150

10793

would be "5.4"</td>

11151

10794

</tr>

11152

10795

11153

<td><a href="#public.table.schema">public.schema.id</a></td>

11154

<td>components</td>

11155

<td>integer</td>

11156

11157

<br />

11158

The components which are considered valid within this

11159

distrorelease.</td>

11160

</tr>

11161

11162

<td><a href="#public.table.schema">public.schema.id</a></td>

11163

<td>sections</td>

11164

<td>integer</td>

11165

11166

<br />

11167

The sections which are considered valid within this

11168

distrorelease.</td>

11169

</tr>

11170

11171

10796

11172

10797

<td>releasestatus</td>

11173

10798

<td>integer</td>

11251

10876

total number of translation messages in this distro release, as per

11252

10877

IRosettaStats.</td>

11253

10878

</tr>

10879

10880

<td><a href=

10881

"#public.table.distroarchrelease">public.distroarchrelease.id</a></td>

10882

<td>nominatedarchindep</td>

10883

<td>integer</td>

10884

10885

<br />

10886

This is the DistroArchRelease nominated to build architecture

10887

independent packages within this DistroRelase, it is mandatory for

10888

buildable distroreleases, i.e., Auto Build System will avoid to

10889

create build jobs for a DistroRelease with no nominatedarchindep,

10890

but the database model allow us to do it (for non-buildable

10891

DistroReleases). See further info in NominatedArchIndep

10892

specification.</td>

10893

</tr>

10894

10895

10896

<td>changeslist</td>

10897

10898

10899

<br />

10900

The email address (name name) of the changes announcement list for

10901

this distrorelease. If NULL, no announcement mail will be

10902

sent.</td>

10903

</tr>

10904

10905

10906

<td>binarycount</td>

10907

<td>integer</td>

10908

10909

<br />

10910

A cache of the number of distinct binary package names published in

10911

this distro release.</td>

10912

</tr>

10913

10914

10915

<td>sourcecount</td>

10916

<td>integer</td>

10917

10918

<br />

10919

A cache of the number of distinct source package names published in

10920

this distro release.</td>

10921

</tr>

11254

10922

</table>

11255

10923

11256

10924

11266

10934

</tr>

11267

10935

11268

10936

<td>valid_version</td>

11269

<td>CHECK (sane_version("version"))</td>

10937

<td>CHECK (sane_version(version))</td>

11270

10938

</tr>

11271

10939

</table>

11272

10940

11296

10964

</ul>

11297

10965

<ul>

11298

10966

<li><a href=

10967

"#public.table.distroreleasepackagecache">public.distroreleasepackagecache</a></li>

10968

</ul>

10969

<ul>

10970

<li><a href=

11299

10971

"#public.table.distroreleasequeue">public.distroreleasequeue</a></li>

11300

10972

</ul>

11301

10973

<ul>

11460

11132

</td>

11461

11133

</tr>

11462

11134

11135

<td>queued</td>

11136

<td>

11137

<center>&diams;</center>

11138

</td>

11139

11140

11141

11142

11143

11144

11145

</tr>

11146

11463

11147

<td>sourcerer</td>

11464

11148

<td>

11465

11149

<center>&diams;</center>

11471

11155

11472

11156

11473

11157

</tr>

11474

11158

11475

11159

<td>statistician</td>

11476

11160

<td>

11477

11161

<center>&diams;</center>

11485

11169

11486

11170

11487

11171

</tr>

11172

11173

<td>targetnamecacheupdater</td>

11174

<td>

11175

<center>&diams;</center>

11176

</td>

11177

11178

11179

11180

11181

11182

11183

</tr>

11488

11184

11489

11185

<td>trebuchet</td>

11490

11186

<td>

11497

11193

11498

11194

11499

11195

</tr>

11196

11197

<td>uploader</td>

11198

<td>

11199

<center>&diams;</center>

11200

</td>

11201

11202

<td>

11203

<center>&diams;</center>

11204

</td>

11205

11206

11207

11208

11209

</tr>

11500

11210

</table>

11501

11211

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

11502

11212

public</a></p>

11525

11235

"#public.table.distrorelease">public.distrorelease.id</a></td>

11526

11236

<td>distrorelease</td>

11527

11237

<td>integer</td>

11528

11238

<td><i>UNIQUE#1</i></td>

11529

11239

</tr>

11530

11240

11531

11241

<td><a href="#public.table.language">public.language.id</a></td>

11532

11242

<td>language</td>

11533

11243

<td>integer</td>

11534

11244

<td><i>UNIQUE#1</i></td>

11535

11245

</tr>

11536

11246

11537

11247

11695

11405

<td>

11696

11406

<center>&diams;</center>

11697

11407

</td>

11698

11408

<td>

11409

<center>&diams;</center>

11410

</td>

11411

11412

11413

11414

</tr>

11415

</table>

11416

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

11417

public</a></p>

11418

<hr />

11419

<h2>Table: <a href="#public.schema">public</a>.<a name=

11420

"public.table.distroreleasepackagecache" id=

11421

"public.table.distroreleasepackagecache">distroreleasepackagecache</a></h2>

11422

<p>A cache of the text associated with binary packages in the

11423

distrorelease. This table allows for fast queries to find a binary

11424

packagename that matches a given text.</p>

11425

11426

<caption>public.distroreleasepackagecache Structure</caption>

11427

<tr>

11428

11429

11430

11431

<th>Description</th>

11432

</tr>

11433

11434

11435

11436

<td>serial</td>

11437

<td><i>PRIMARY KEY</i></td>

11438

</tr>

11439

11440

<td><a href=

11441

"#public.table.distrorelease">public.distrorelease.id</a></td>

11442

<td>distrorelease</td>

11443

<td>integer</td>

11444

<td><i>UNIQUE#1 NOT NULL</i><br />

11445

<br />

11446

The distrorelease in which we are checking.</td>

11447

</tr>

11448

11449

<td><a href=

11450

"#public.table.binarypackagename">public.binarypackagename.id</a></td>

11451

<td>binarypackagename</td>

11452

<td>integer</td>

11453

<td><i>UNIQUE#1 NOT NULL</i><br />

11454

<br />

11455

The binary package name for which we are caching details.</td>

11456

</tr>

11457

11458

11459

11460

11461

11462

<br />

11463

The binary package name itself. This is just a copy of the value of

11464

binarypackagename.name. We have it here so it can be part of the

11465

full text index.</td>

11466

</tr>

11467

11468

11469

<td>summary</td>

11470

11471

11472

<br />

11473

A single summary for one of the binary packages of this name in

11474

this distrorelease. We could potentially have binary packages in

11475

different architectures with the same name and different summaries,

11476

so this is a way of collapsing to one arbitrarily-chosen one, for

11477

display purposes. The chances of actually having different

11478

summaries and descriptions is pretty small. It could happen,

11479

though, because of the way package superseding works when a package

11480

does not build on a specific architecture.</td>

11481

</tr>

11482

11483

11484

<td>description</td>

11485

11486

11487

</tr>

11488

11489

11490

<td>summaries</td>

11491

11492

11493

<br />

11494

The aggregated summaries of all the binary packages with this name

11495

in this distrorelease.</td>

11496

</tr>

11497

11498

11499

<td>descriptions</td>

11500

11501

11502

<br />

11503

The aggregated description of all the binary packages with this

11504

name in this distrorelease.</td>

11505

</tr>

11506

11507

11508

11509

<td>tsvector</td>

11510

11511

</tr>

11512

</table>

11513

11514

11515

11516

11517

11518

11519

<caption>Permissions which apply to

11520

public.distroreleasepackagecache</caption>

11521

<tr>

11522

11523

<th>

11524

<center>Select</center>

11525

</th>

11526

<th>

11527

<center>Insert</center>

11528

</th>

11529

<th>

11530

<center>Update</center>

11531

</th>

11532

<th>

11533

<center>Delete</center>

11534

</th>

11535

<th>

11536

<center>Reference</center>

11537

</th>

11538

<th>

11539

11540

</th>

11541

<th>

11542

<center>Trigger</center>

11543

</th>

11544

</tr>

11545

11546

<td>group admin</td>

11547

<td>

11548

<center>&diams;</center>

11549

</td>

11550

<td>

11551

<center>&diams;</center>

11552

</td>

11553

<td>

11554

<center>&diams;</center>

11555

</td>

11556

<td>

11557

<center>&diams;</center>

11558

</td>

11559

<td>

11560

<center>&diams;</center>

11561

</td>

11562

<td>

11563

<center>&diams;</center>

11564

</td>

11565

<td>

11566

<center>&diams;</center>

11567

</td>

11568

</tr>

11569

11570

<td>group read</td>

11571

<td>

11572

<center>&diams;</center>

11573

</td>

11574

11575

11576

11577

11578

11579

11580

</tr>

11581

11582

<td>launchpad</td>

11583

<td>

11584

<center>&diams;</center>

11585

</td>

11586

11587

11588

11589

11590

11591

11592

</tr>

11593

11594

<td>postgres</td>

11595

<td>

11596

<center>&diams;</center>

11597

</td>

11598

<td>

11599

<center>&diams;</center>

11600

</td>

11601

<td>

11602

<center>&diams;</center>

11603

</td>

11604

<td>

11605

<center>&diams;</center>

11606

</td>

11607

<td>

11608

<center>&diams;</center>

11609

</td>

11610

<td>

11611

<center>&diams;</center>

11612

</td>

11613

<td>

11614

<center>&diams;</center>

11615

</td>

11616

</tr>

11617

11618

<td>statistician</td>

11619

<td>

11620

<center>&diams;</center>

11621

</td>

11622

<td>

11623

<center>&diams;</center>

11624

</td>

11625

<td>

11626

<center>&diams;</center>

11627

</td>

11628

<td>

11629

<center>&diams;</center>

11630

</td>

11699

11631

11700

11632

11701

11633

11741

11673

11742

11674

<br />

11743

11675

This integer field refers to the DistroRelease to which this upload

11744

is targetted</td>

11676

is targeted</td>

11677

</tr>

11678

11679

11680

<td>pocket</td>

11681

<td>integer</td>

11682

11683

<br />

11684

This is the pocket the upload is targeted at.</td>

11745

11685

</tr>

11746

11686

</table>

11747

11687

11753

11693

</ul>

11754

11694

<ul>

11755

11695

<li><a href=

11696

"#public.table.distroreleasequeuecustom">public.distroreleasequeuecustom</a></li>

11697

</ul>

11698

<ul>

11699

<li><a href=

11756

11700

"#public.table.distroreleasequeuesource">public.distroreleasequeuesource</a></li>

11757

11701

</ul>

11758

11702

11861

11805

<center>&diams;</center>

11862

11806

</td>

11863

11807

</tr>

11808

11809

<td>queued</td>

11810

<td>

11811

<center>&diams;</center>

11812

</td>

11813

11814

<td>

11815

<center>&diams;</center>

11816

</td>

11817

11818

11819

11820

11821

</tr>

11822

11823

<td>uploader</td>

11824

<td>

11825

<center>&diams;</center>

11826

</td>

11827

<td>

11828

<center>&diams;</center>

11829

</td>

11830

11831

11832

11833

11834

11835

</tr>

11864

11836

</table>

11865

11837

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

11866

11838

public</a></p>

12012

11984

<center>&diams;</center>

12013

11985

</td>

12014

11986

</tr>

11987

11988

<td>queued</td>

11989

<td>

11990

<center>&diams;</center>

11991

</td>

11992

11993

11994

11995

11996

11997

11998

</tr>

11999

12000

<td>uploader</td>

12001

<td>

12002

<center>&diams;</center>

12003

</td>

12004

<td>

12005

<center>&diams;</center>

12006

</td>

12007

12008

12009

12010

12011

12012

</tr>

12013

</table>

12014

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

12015

public</a></p>

12016

<hr />

12017

<h2>Table: <a href="#public.schema">public</a>.<a name=

12018

"public.table.distroreleasequeuecustom" id=

12019

"public.table.distroreleasequeuecustom">distroreleasequeuecustom</a></h2>

12020

<p>An upload queue custom format upload. This table stores

12021

information pertaining to the custom upload formats in an

12022

in-progress package upload.</p>

12023

12024

<caption>public.distroreleasequeuecustom Structure</caption>

12025

<tr>

12026

12027

12028

12029

<th>Description</th>

12030

</tr>

12031

12032

12033

12034

<td>serial</td>

12035

<td><i>PRIMARY KEY</i></td>

12036

</tr>

12037

12038

<td><a href=

12039

"#public.table.distroreleasequeue">public.distroreleasequeue.id</a></td>

12040

<td>distroreleasequeue</td>

12041

<td>integer</td>

12042

12043

<br />

12044

The queue item this refers to.</td>

12045

</tr>

12046

12047

12048

<td>customformat</td>

12049

<td>integer</td>

12050

12051

<br />

12052

The format of this particular custom uploaded file.</td>

12053

</tr>

12054

12055

<td><a href=

12056

"#public.table.libraryfilealias">public.libraryfilealias.id</a></td>

12057

<td>libraryfilealias</td>

12058

<td>integer</td>

12059

12060

<br />

12061

The actual file as a librarian alias.</td>

12062

</tr>

12063

</table>

12064

12065

12066

12067

12068

12069

12070

<caption>Permissions which apply to

12071

public.distroreleasequeuecustom</caption>

12072

<tr>

12073

12074

<th>

12075

<center>Select</center>

12076

</th>

12077

<th>

12078

<center>Insert</center>

12079

</th>

12080

<th>

12081

<center>Update</center>

12082

</th>

12083

<th>

12084

<center>Delete</center>

12085

</th>

12086

<th>

12087

<center>Reference</center>

12088

</th>

12089

<th>

12090

12091

</th>

12092

<th>

12093

<center>Trigger</center>

12094

</th>

12095

</tr>

12096

12097

<td>group admin</td>

12098

<td>

12099

<center>&diams;</center>

12100

</td>

12101

<td>

12102

<center>&diams;</center>

12103

</td>

12104

<td>

12105

<center>&diams;</center>

12106

</td>

12107

<td>

12108

<center>&diams;</center>

12109

</td>

12110

<td>

12111

<center>&diams;</center>

12112

</td>

12113

<td>

12114

<center>&diams;</center>

12115

</td>

12116

<td>

12117

<center>&diams;</center>

12118

</td>

12119

</tr>

12120

12121

<td>group read</td>

12122

<td>

12123

<center>&diams;</center>

12124

</td>

12125

12126

12127

12128

12129

12130

12131

</tr>

12132

12133

<td>group write</td>

12134

<td>

12135

<center>&diams;</center>

12136

</td>

12137

<td>

12138

<center>&diams;</center>

12139

</td>

12140

<td>

12141

<center>&diams;</center>

12142

</td>

12143

12144

12145

12146

12147

</tr>

12148

12149

<td>postgres</td>

12150

<td>

12151

<center>&diams;</center>

12152

</td>

12153

<td>

12154

<center>&diams;</center>

12155

</td>

12156

<td>

12157

<center>&diams;</center>

12158

</td>

12159

<td>

12160

<center>&diams;</center>

12161

</td>

12162

<td>

12163

<center>&diams;</center>

12164

</td>

12165

<td>

12166

<center>&diams;</center>

12167

</td>

12168

<td>

12169

<center>&diams;</center>

12170

</td>

12171

</tr>

12172

12173

<td>queued</td>

12174

<td>

12175

<center>&diams;</center>

12176

</td>

12177

12178

12179

12180

12181

12182

12183

</tr>

12184

12185

<td>uploader</td>

12186

<td>

12187

<center>&diams;</center>

12188

</td>

12189

<td>

12190

<center>&diams;</center>

12191

</td>

12192

12193

12194

12195

12196

12197

</tr>

12015

12198

</table>

12016

12199

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

12017

12200

public</a></p>

12165

12348

<center>&diams;</center>

12166

12349

</td>

12167

12350

</tr>

12351

12352

<td>queued</td>

12353

<td>

12354

<center>&diams;</center>

12355

</td>

12356

12357

12358

12359

12360

12361

12362

</tr>

12363

12364

<td>uploader</td>

12365

<td>

12366

<center>&diams;</center>

12367

</td>

12368

<td>

12369

<center>&diams;</center>

12370

</td>

12371

12372

12373

12374

12375

12376

</tr>

12168

12377

</table>

12169

12378

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

12170

12379

public</a></p>

12292

12501

12293

12502

</tr>

12294

12503

12504

<td>karma</td>

12505

<td>

12506

<center>&diams;</center>

12507

</td>

12508

12509

12510

12511

12512

12513

12514

</tr>

12515

12295

12516

<td>launchpad</td>

12296

12517

<td>

12297

12518

<center>&diams;</center>

12309

12530

12310

12531

12311

12532

</tr>

12312

12533

12313

12534

<td>poexport</td>

12314

12535

<td>

12315

12536

<center>&diams;</center>

12321

12542

12322

12543

12323

12544

</tr>

12324

12545

12325

12546

<td>postgres</td>

12326

12547

<td>

12327

12548

<center>&diams;</center>

12345

12566

<center>&diams;</center>

12346

12567

</td>

12347

12568

</tr>

12569

12570

<td>tickettracker</td>

12571

<td>

12572

<center>&diams;</center>

12573

</td>

12574

12575

12576

12577

12578

12579

12580

</tr>

12581

12582

<td>uploader</td>

12583

<td>

12584

<center>&diams;</center>

12585

</td>

12586

<td>

12587

<center>&diams;</center>

12588

</td>

12589

12590

12591

12592

12593

12594

</tr>

12348

12595

</table>

12349

12596

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

12350

12597

public</a></p>

12416

12663

Size of the key in bits, as reported by GPG. We may refuse to deal

12417

12664

with keysizes < 768 bits in the future.</td>

12418

12665

</tr>

12666

12667

12668

<td>can_encrypt</td>

12669

<td>boolean</td>

12670

<td><i>NOT NULL DEFAULT false</i><br />

12671

<br />

12672

Whether the key has been validated for use in encryption (as

12673

opposed to just signing)</td>

12674

</tr>

12419

12675

</table>

12420

12676

12421

12677

12437

12693

12438

12694

<p>Tables referencing this one via Foreign Key Constraints:</p>

12439

12695

<ul>

12440

<li><a href=

12441

"#public.table.archarchivelocationsigner">public.archarchivelocationsigner</a></li>

12442

</ul>

12443

<ul>

12444

12696

<li><a href="#public.table.build">public.build</a></li>

12445

12697

</ul>

12446

12698

<ul>

12447

<li><a href="#public.table.changeset">public.changeset</a></li>

12699

<li><a href="#public.table.revision">public.revision</a></li>

12448

12700

</ul>

12449

12701

<ul>

12450

12702

<li><a href=

12561

12813

<center>&diams;</center>

12562

12814

</td>

12563

12815

</tr>

12816

12817

<td>uploader</td>

12818

<td>

12819

<center>&diams;</center>

12820

</td>

12821

<td>

12822

<center>&diams;</center>

12823

</td>

12824

12825

12826

12827

12828

12829

</tr>

12564

12830

</table>

12565

12831

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

12566

12832

public</a></p>

13045

13311

<td><i>PRIMARY KEY</i></td>

13046

13312

</tr>

13047

13313

13048

13049

13050

<td>integer</td>

13051

<td><i>UNIQUE NOT NULL</i><br />

13052

<br />

13053

The unique name of this action.</td>

13054

</tr>

13055

13056

13314

<td><a href=

13315

"#public.table.karmacategory">public.karmacategory.id</a></td>

13057

13316

<td>category</td>

13058

13317

<td>integer</td>

13059

13318

13060

13319

<br />

13061

13320

A dbschema value used to group actions together.</td>

13062

13321

</tr>

13063

13322

13064

13323

13065

13324

<td>points</td>

13066

13325

<td>integer</td>

13068

13327

<br />

13069

13328

The number of points this action is worth of.</td>

13070

13329

</tr>

13330

13331

13332

13333

13334

<td><i>UNIQUE NOT NULL</i><br />

13335

<br />

13336

The unique name of this action.</td>

13337

</tr>

13338

13339

13340

<td>title</td>

13341

13342

13343

</tr>

13344

13345

13346

<td>summary</td>

13347

13348

13349

</tr>

13071

13350

</table>

13072

13351

13073

13352

13310

13589

13311

13590

</tr>

13312

13591

13313

<td>group write</td>

13314

<td>

13315

<center>&diams;</center>

13316

</td>

13317

13318

13319

13320

13321

13322

13323

</tr>

13324

13325

<td>karma</td>

13326

<td>

13327

<center>&diams;</center>

13328

</td>

13329

<td>

13330

<center>&diams;</center>

13331

</td>

13332

<td>

13333

<center>&diams;</center>

13334

</td>

13335

<td>

13336

<center>&diams;</center>

13337

</td>

13592

<td>karma</td>

13593

<td>

13594

<center>&diams;</center>

13595

</td>

13596

<td>

13597

<center>&diams;</center>

13598

</td>

13599

<td>

13600

<center>&diams;</center>

13601

</td>

13602

<td>

13603

<center>&diams;</center>

13604

</td>

13605

13606

13607

13608

</tr>

13609

13610

<td>launchpad</td>

13611

<td>

13612

<center>&diams;</center>

13613

</td>

13614

<td>

13615

<center>&diams;</center>

13616

</td>

13617

<td>

13618

<center>&diams;</center>

13619

</td>

13620

<td>

13621

<center>&diams;</center>

13622

</td>

13623

13624

13625

13626

</tr>

13627

13628

<td>postgres</td>

13629

<td>

13630

<center>&diams;</center>

13631

</td>

13632

<td>

13633

<center>&diams;</center>

13634

</td>

13635

<td>

13636

<center>&diams;</center>

13637

</td>

13638

<td>

13639

<center>&diams;</center>

13640

</td>

13641

<td>

13642

<center>&diams;</center>

13643

</td>

13644

<td>

13645

<center>&diams;</center>

13646

</td>

13647

<td>

13648

<center>&diams;</center>

13649

</td>

13650

</tr>

13651

</table>

13652

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

13653

public</a></p>

13654

<hr />

13655

<h2>Table: <a href="#public.schema">public</a>.<a name=

13656

"public.table.karmacategory" id=

13657

"public.table.karmacategory">karmacategory</a></h2>

13658

<p>A category of karma. This allows us to present an overall

13659

picture of the different areas where a user has been active.</p>

13660

13661

<caption>public.karmacategory Structure</caption>

13662

<tr>

13663

13664

13665

13666

<th>Description</th>

13667

</tr>

13668

13669

13670

13671

<td>serial</td>

13672

<td><i>PRIMARY KEY</i></td>

13673

</tr>

13674

13675

13676

13677

13678

13679

</tr>

13680

13681

13682

<td>title</td>

13683

13684

13685

</tr>

13686

13687

13688

<td>summary</td>

13689

13690

13691

</tr>

13692

</table>

13693

13694

13695

<p>Tables referencing this one via Foreign Key Constraints:</p>

13696

<ul>

13697

<li><a href="#public.table.karmaaction">public.karmaaction</a></li>

13698

</ul>

13699

13700

13701

13702

13703

<caption>Permissions which apply to public.karmacategory</caption>

13704

<tr>

13705

13706

<th>

13707

<center>Select</center>

13708

</th>

13709

<th>

13710

<center>Insert</center>

13711

</th>

13712

<th>

13713

<center>Update</center>

13714

</th>

13715

<th>

13716

<center>Delete</center>

13717

</th>

13718

<th>

13719

<center>Reference</center>

13720

</th>

13721

<th>

13722

13723

</th>

13724

<th>

13725

<center>Trigger</center>

13726

</th>

13727

</tr>

13728

13729

<td>group admin</td>

13730

<td>

13731

<center>&diams;</center>

13732

</td>

13733

<td>

13734

<center>&diams;</center>

13735

</td>

13736

<td>

13737

<center>&diams;</center>

13738

</td>

13739

<td>

13740

<center>&diams;</center>

13741

</td>

13742

<td>

13743

<center>&diams;</center>

13744

</td>

13745

<td>

13746

<center>&diams;</center>

13747

</td>

13748

<td>

13749

<center>&diams;</center>

13750

</td>

13751

</tr>

13752

13753

<td>group read</td>

13754

<td>

13755

<center>&diams;</center>

13756

</td>

13757

13758

13759

13760

13761

13762

13763

</tr>

13764

13765

<td>karma</td>

13766

<td>

13767

<center>&diams;</center>

13768

</td>

13769

13770

13771

13772

13773

13774

13775

</tr>

13776

13777

<td>launchpad</td>

13778

<td>

13779

<center>&diams;</center>

13780

</td>

13781

13782

13783

13338

13784

13339

13785

13340

13786

13552

13998

<h2>Table: <a href="#public.schema">public</a>.<a name=

13553

13999

"public.table.language" id=

13554

14000

"public.table.language">language</a></h2>

14001

<p>A human language.</p>

13555

14002

13556

14003

<caption>public.language Structure</caption>

13557

14004

<tr>

13570

14017

13571

14018

13572

14019

13573

<td><i>UNIQUE NOT NULL</i></td>

14020

<td><i>UNIQUE NOT NULL</i><br />

14021

<br />

14022

The ISO 639 code for this language</td>

13574

14023

</tr>

13575

14024

13576

14025

13577

14026

<td>englishname</td>

13578

14027

13579

14028

14029

<br />

14030

The english name for this language</td>

13580

14031

</tr>

13581

14032

13582

14033

13583

14034

<td>nativename</td>

13584

14035

13585

14036

14037

<br />

14038

The name of this language in the language itself</td>

13586

14039

</tr>

13587

14040

13588

14041

13589

14042

<td>pluralforms</td>

13590

14043

<td>integer</td>

13591

14044

14045

<br />

14046

The number of plural forms this language has</td>

13592

14047

</tr>

13593

14048

13594

14049

13595

14050

<td>pluralexpression</td>

13596

14051

13597

14052

14053

<br />

14054

The plural expression for this language, as used by gettext</td>

13598

14055

</tr>

13599

14056

13600

14057

13601

14058

<td>visible</td>

13602

14059

<td>boolean</td>

13603

14060

14061

<br />

14062

Whether this language should usually be visible or not</td>

14063

</tr>

14064

14065

14066

<td>direction</td>

14067

<td>integer</td>

14068

14069

<br />

14070

The direction that text is written in this language</td>

13604

14071

</tr>

13605

14072

</table>

13606

14073

13856

14323

</th>

13857

14324

</tr>

13858

14325

14326

<td>PUBLIC</td>

14327

<td>

14328

<center>&diams;</center>

14329

</td>

14330

14331

14332

14333

14334

14335

14336

</tr>

14337

13859

14338

<td>group admin</td>

13860

14339

<td>

13861

14340

<center>&diams;</center>

13879

14358

<center>&diams;</center>

13880

14359

</td>

13881

14360

</tr>

13882

14361

13883

14362

<td>group read</td>

13884

14363

<td>

13885

14364

<center>&diams;</center>

13891

14370

13892

14371

13893

14372

</tr>

13894

14373

13895

14374

<td>group write</td>

13896

14375

<td>

13897

14376

<center>&diams;</center>

13907

14386

13908

14387

13909

14388

</tr>

13910

14389

13911

14390

<td>postgres</td>

13912

14391

<td>

13913

14392

<center>&diams;</center>

13940

14419

"public.table.launchpadstatistic">launchpadstatistic</a></h2>

13941

14420

<p>A store of system-wide statistics or other integer values, keyed

13942

14421

by names. The names are unique and the values can be any integer.

13943

Each field has a place to store the timestampt when it was last

14422

Each field has a place to store the timestamp when it was last

13944

14423

updated, so it is possible to know how far out of date any given

13945

14424

statistic is.</p>

13946

14425

14092

14571

<td>

14093

14572

<center>&diams;</center>

14094

14573

</td>

14095

14574

<td>

14575

<center>&diams;</center>

14576

</td>

14096

14577

14097

14578

14098

14579

14152

14633

<td>timestamp without time zone</td>

14153

14634

14154

14635

</tr>

14636

14637

14638

<td>last_accessed</td>

14639

<td>timestamp without time zone</td>

14640

14641

</tr>

14155

14642

</table>

14156

14643

14157

14644

14168

14655

<li><a href="#public.table.build">public.build</a></li>

14169

14656

</ul>

14170

14657

<ul>

14658

<li><a href=

14659

"#public.table.distroreleasequeuecustom">public.distroreleasequeuecustom</a></li>

14660

</ul>

14661

<ul>

14171

14662

<li><a href="#public.table.message">public.message</a></li>

14172

14663

</ul>

14173

14664

<ul>

14192

14683

"#public.table.productreleasefile">public.productreleasefile</a></li>

14193

14684

</ul>

14194

14685

<ul>

14686

<li><a href="#public.table.shippingrun">public.shippingrun</a></li>

14687

</ul>

14688

<ul>

14195

14689

<li><a href=

14196

14690

"#public.table.sourcepackagereleasefile">public.sourcepackagereleasefile</a></li>

14197

14691

</ul>

14356

14850

</td>

14357

14851

</tr>

14358

14852

14853

<td>queued</td>

14854

<td>

14855

<center>&diams;</center>

14856

</td>

14857

14858

14859

14860

14861

14862

14863

</tr>

14864

14865

<td>shipit</td>

14866

<td>

14867

<center>&diams;</center>

14868

</td>

14869

<td>

14870

<center>&diams;</center>

14871

</td>

14872

14873

14874

14875

14876

14877

</tr>

14878

14359

14879

<td>sourcerer</td>

14360

14880

<td>

14361

14881

<center>&diams;</center>

14367

14887

14368

14888

14369

14889

</tr>

14890

14891

<td>uploader</td>

14892

<td>

14893

<center>&diams;</center>

14894

</td>

14895

<td>

14896

<center>&diams;</center>

14897

</td>

14898

14899

14900

14901

14902

14903

</tr>

14370

14904

</table>

14371

14905

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

14372

14906

public</a></p>

14425

14959

<br />

14426

14960

The SHA1 sum of the file's contents</td>

14427

14961

</tr>

14962

14963

14964

<td>deleted</td>

14965

<td>boolean</td>

14966

<td><i>NOT NULL DEFAULT false</i></td>

14967

</tr>

14428

14968

</table>

14429

14969

14430

14970

14594

15134

</td>

14595

15135

</tr>

14596

15136

15137

<td>shipit</td>

15138

<td>

15139

<center>&diams;</center>

15140

</td>

15141

<td>

15142

<center>&diams;</center>

15143

</td>

15144

15145

15146

15147

15148

15149

</tr>

15150

14597

15151

<td>sourcerer</td>

14598

15152

<td>

14599

15153

<center>&diams;</center>

14605

15159

14606

15160

14607

15161

</tr>

15162

15163

<td>uploader</td>

15164

<td>

15165

<center>&diams;</center>

15166

</td>

15167

<td>

15168

<center>&diams;</center>

15169

</td>

15170

15171

15172

15173

15174

15175

</tr>

14608

15176

</table>

14609

15177

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

14610

15178

public</a></p>

15540

16108

<td><i>PRIMARY KEY</i></td>

15541

16109

</tr>

15542

16110

15543

<td><a href="#public.table.manifest">public.manifest.id#2</a></td>

16111

<td><a href="#public.table.manifest">public.manifest.id</a>

16112

<a href="#public.table.manifestentry">public.manifestentry.manifest#1</a></td>

15544

16113

<td>manifest</td>

15545

16114

<td>integer</td>

15546

16115

<td><i>UNIQUE#2 UNIQUE#1 NOT NULL</i></td>

15552

16121

<td><i>UNIQUE#1 NOT NULL</i></td>

15553

16122

</tr>

15554

16123

15555

<td><a href="#public.table.branch">public.branch.id</a> <a href=

15556

"#public.table.changeset">public.changeset.branch#1</a></td>

16124

<td><a href="#public.table.branch">public.branch.id</a></td>

15557

16125

<td>branch</td>

15558

16126

<td>integer</td>

15559

16127

15560

16128

</tr>

15561

16129

15562

<td><a href="#public.table.changeset">public.changeset.id</a>

15563

<a href="#public.table.changeset">public.changeset.id#1</a></td>

16130

<td><a href="#public.table.revision">public.revision.id</a></td>

15564

16131

<td>changeset</td>

15565

16132

<td>integer</td>

15566

16133

15578

16145

15579

16146

</tr>

15580

16147

15581

<td><a href=

15582

"#public.table.manifestentry">public.manifestentry.sequence#2</a></td>

15583

<td>patchon</td>

15584

<td>integer</td>

15585

15586

</tr>

15587

15588

16148

15589

16149

<td>dirname</td>

15590

16150

15591

16151

15592

16152

</tr>

15593

16153

15594

16154

15595

16155

15596

16156

<td>integer</td>

15597

16157

<td><i>UNIQUE#2</i></td>

15598

16158

</tr>

16159

16160

<td><a href=

16161

"#public.table.manifestentry">public.manifestentry.sequence#1</a></td>

16162

<td>parent</td>

16163

<td>integer</td>

16164

16165

</tr>

15599

16166

</table>

15600

16167

15601

16168

15610

16177

<td>CHECK (("sequence" > 0))</td>

15611

16178

</tr>

15612

16179

15613

15614

<td>CHECK ((patchon <> "sequence"))</td>

16180

<td>manifestentry_parent_paradox</td>

16181

<td>CHECK ((parent <> "sequence"))</td>

15615

16182

</tr>

15616

16183

</table>

15617

16184

15851

16418

</ul>

15852

16419

<ul>

15853

16420

<li><a href=

16421

"#public.table.branchmessage">public.branchmessage</a></li>

16422

</ul>

16423

<ul>

16424

<li><a href=

15854

16425

"#public.table.bugattachment">public.bugattachment</a></li>

15855

16426

</ul>

15856

16427

<ul>

16887

17458

public</a></p>

16888

17459

<hr />

16889

17460

<h2>Table: <a href="#public.schema">public</a>.<a name=

17461

"public.table.packagebugcontact" id=

17462

"public.table.packagebugcontact">packagebugcontact</a></h2>

17463

<p>Defines the bug contact for a given sourcepackage in a given

17464

distribution. The bug contact will be automatically subscribed to

17465

every bug filed on this sourcepackage in this distribution.</p>

17466

17467

<caption>public.packagebugcontact Structure</caption>

17468

<tr>

17469

17470

17471

17472

<th>Description</th>

17473

</tr>

17474

17475

<td><a href=

17476

"#public.table.distribution">public.distribution.id</a></td>

17477

<td>distribution</td>

17478

<td>integer</td>

17479

<td><i>UNIQUE#1 NOT NULL</i></td>

17480

</tr>

17481

17482

<td><a href=

17483

"#public.table.sourcepackagename">public.sourcepackagename.id</a></td>

17484

<td>sourcepackagename</td>

17485

<td>integer</td>

17486

<td><i>UNIQUE#1 NOT NULL</i></td>

17487

</tr>

17488

17489

<td><a href="#public.table.person">public.person.id</a></td>

17490

<td>bugcontact</td>

17491

<td>integer</td>

17492

<td><i>UNIQUE#1 NOT NULL</i></td>

17493

</tr>

17494

</table>

17495

17496

17497

17498

17499

17500

17501

<caption>Permissions which apply to

17502

public.packagebugcontact</caption>

17503

<tr>

17504

17505

<th>

17506

<center>Select</center>

17507

</th>

17508

<th>

17509

<center>Insert</center>

17510

</th>

17511

<th>

17512

<center>Update</center>

17513

</th>

17514

<th>

17515

<center>Delete</center>

17516

</th>

17517

<th>

17518

<center>Reference</center>

17519

</th>

17520

<th>

17521

17522

</th>

17523

<th>

17524

<center>Trigger</center>

17525

</th>

17526

</tr>

17527

17528

<td>group admin</td>

17529

<td>

17530

<center>&diams;</center>

17531

</td>

17532

<td>

17533

<center>&diams;</center>

17534

</td>

17535

<td>

17536

<center>&diams;</center>

17537

</td>

17538

<td>

17539

<center>&diams;</center>

17540

</td>

17541

<td>

17542

<center>&diams;</center>

17543

</td>

17544

<td>

17545

<center>&diams;</center>

17546

</td>

17547

<td>

17548

<center>&diams;</center>

17549

</td>

17550

</tr>

17551

17552

<td>group read</td>

17553

<td>

17554

<center>&diams;</center>

17555

</td>

17556

17557

17558

17559

17560

17561

17562

</tr>

17563

17564

<td>launchpad</td>

17565

<td>

17566

<center>&diams;</center>

17567

</td>

17568

<td>

17569

<center>&diams;</center>

17570

</td>

17571

<td>

17572

<center>&diams;</center>

17573

</td>

17574

<td>

17575

<center>&diams;</center>

17576

</td>

17577

17578

17579

17580

</tr>

17581

17582

<td>postgres</td>

17583

<td>

17584

<center>&diams;</center>

17585

</td>

17586

<td>

17587

<center>&diams;</center>

17588

</td>

17589

<td>

17590

<center>&diams;</center>

17591

</td>

17592

<td>

17593

<center>&diams;</center>

17594

</td>

17595

<td>

17596

<center>&diams;</center>

17597

</td>

17598

<td>

17599

<center>&diams;</center>

17600

</td>

17601

<td>

17602

<center>&diams;</center>

17603

</td>

17604

</tr>

17605

</table>

17606

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

17607

public</a></p>

17608

<hr />

17609

<h2>Table: <a href="#public.schema">public</a>.<a name=

16890

17610

"public.table.packageselection" id=

16891

17611

"public.table.packageselection">packageselection</a></h2>

16892

17612

17557

18277

17558

18278

<p>Tables referencing this one via Foreign Key Constraints:</p>

17559

18279

<ul>

17560

<li><a href="#public.table.archarchive">public.archarchive</a></li>

17561

</ul>

17562

<ul>

17563

18280

<li><a href="#public.table.archconfig">public.archconfig</a></li>

17564

18281

</ul>

17565

18282

<ul>

17566

<li><a href="#public.table.archuserid">public.archuserid</a></li>

17567

</ul>

17568

<ul>

17569

18283

<li><a href="#public.table.bounty">public.bounty</a></li>

17570

18284

</ul>

17571

18285

<ul>

17576

18290

<li><a href="#public.table.branch">public.branch</a></li>

17577

18291

</ul>

17578

18292

<ul>

18293

<li><a href=

18294

"#public.table.branchsubscription">public.branchsubscription</a></li>

18295

</ul>

18296

<ul>

17579

18297

<li><a href="#public.table.bug">public.bug</a></li>

17580

18298

</ul>

17581

18299

<ul>

17608

18326

</ul>

17609

18327

<ul>

17610

18328

<li><a href=

17611

"#public.table.cverefobsolete">public.cverefobsolete</a></li>

17612

</ul>

17613

<ul>

17614

<li><a href=

17615

18329

"#public.table.developmentmanifest">public.developmentmanifest</a></li>

17616

18330

</ul>

17617

18331

<ul>

17624

18338

</ul>

17625

18339

<ul>

17626

18340

<li><a href=

18341

"#public.table.distrocomponentuploader">public.distrocomponentuploader</a></li>

18342

</ul>

18343

<ul>

18344

<li><a href=

17627

18345

"#public.table.distrorelease">public.distrorelease</a></li>

17628

18346

</ul>

17629

18347

<ul>

17659

18377

<li><a href="#public.table.mirror">public.mirror</a></li>

17660

18378

</ul>

17661

18379

<ul>

18380

<li><a href=

18381

"#public.table.packagebugcontact">public.packagebugcontact</a></li>

18382

</ul>

18383

<ul>

17662

18384

<li><a href="#public.table.packaging">public.packaging</a></li>

17663

18385

</ul>

17664

18386

<ul>

17710

18432

"#public.table.pushmirroraccess">public.pushmirroraccess</a></li>

17711

18433

</ul>

17712

18434

<ul>

18435

<li><a href="#public.table.revision">public.revision</a></li>

18436

</ul>

18437

<ul>

17713

18438

<li><a href="#public.table.schema">public.schema</a></li>

17714

18439

</ul>

17715

18440

<ul>

17730

18455

</ul>

17731

18456

<ul>

17732

18457

<li><a href=

17733

"#public.table.specificationreview">public.specificationreview</a></li>

18458

"#public.table.specificationfeedback">public.specificationfeedback</a></li>

17734

18459

</ul>

17735

18460

<ul>

17736

18461

<li><a href=

17929

18654

</td>

17930

18655

</tr>

17931

18656

18657

<td>shipit</td>

18658

<td>

18659

<center>&diams;</center>

18660

</td>

18661

18662

18663

18664

18665

18666

18667

</tr>

18668

17932

18669

<td>statistician</td>

17933

18670

<td>

17934

18671

<center>&diams;</center>

17940

18677

17941

18678

17942

18679

</tr>

18680

18681

<td>tickettracker</td>

18682

<td>

18683

<center>&diams;</center>

18684

</td>

18685

18686

18687

18688

18689

18690

18691

</tr>

18692

18693

<td>uploader</td>

18694

<td>

18695

<center>&diams;</center>

18696

</td>

18697

<td>

18698

<center>&diams;</center>

18699

</td>

18700

18701

18702

18703

18704

18705

</tr>

17943

18706

</table>

17944

18707

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

17945

18708

public</a></p>

19836

20599

</tr>

19837

20600

19838

20601

19839

<td>shortname</td>

20602

<td>title</td>

19840

20603

19841

20604

<td><i>UNIQUE#2 NOT NULL</i><br />

19842

20605

<br />

19843

A short name for this option.</td>

20606

A short title for this option.</td>

19844

20607

</tr>

19845

20608

19846

20609

20265

21028

20266

21029

</tr>

20267

21030

21031

<td>poexport</td>

21032

<td>

21033

<center>&diams;</center>

21034

</td>

21035

21036

21037

21038

21039

21040

21041

</tr>

21042

20268

21043

<td>postgres</td>

20269

21044

<td>

20270

21045

<center>&diams;</center>

21864

22639

21865

22640

</tr>

21866

22641

22642

<td>poexport</td>

22643

<td>

22644

<center>&diams;</center>

22645

</td>

22646

22647

22648

22649

22650

22651

22652

</tr>

22653

21867

22654

<td>postgres</td>

21868

22655

<td>

21869

22656

<center>&diams;</center>

21887

22674

<center>&diams;</center>

21888

22675

</td>

21889

22676

</tr>

21890

22677

21891

22678

<td>statistician</td>

21892

22679

<td>

21893

22680

<center>&diams;</center>

22226

23013

<center>&diams;</center>

22227

23014

</td>

22228

23015

</tr>

23016

23017

<td>uploader</td>

23018

<td>

23019

<center>&diams;</center>

23020

</td>

23021

23022

23023

23024

23025

23026

23027

</tr>

22229

23028

</table>

22230

23029

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

22231

23030

public</a></p>

22409

23208

<center>&diams;</center>

22410

23209

</td>

22411

23210

</tr>

23211

23212

<td>uploader</td>

23213

<td>

23214

<center>&diams;</center>

23215

</td>

23216

23217

23218

23219

23220

23221

23222

</tr>

22412

23223

</table>

22413

23224

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

22414

23225

public</a></p>

22681

23492

bug tracker. This is useful to help indicate whether or not people

22682

23493

are likely to pick up on bugs registered in Malone.</td>

22683

23494

</tr>

23495

23496

<td><a href="#public.table.person">public.person.id</a></td>

23497

<td>bugcontact</td>

23498

<td>integer</td>

23499

23500

<br />

23501

Person who will be automatically subscribed to bugs targetted to

23502

this product</td>

23503

</tr>

22684

23504

</table>

22685

23505

22686

23506

22708

23528

</ul>

22709

23529

<ul>

22710

23530

<li><a href=

22711

"#public.table.productbkbranch">public.productbkbranch</a></li>

22712

</ul>

22713

<ul>

22714

<li><a href=

22715

23531

"#public.table.productbounty">public.productbounty</a></li>

22716

23532

</ul>

22717

23533

<ul>

22871

23687

22872

23688

</tr>

22873

23689

23690

<td>targetnamecacheupdater</td>

23691

<td>

23692

<center>&diams;</center>

23693

</td>

23694

23695

23696

23697

23698

23699

23700

</tr>

23701

23702

<td>tickettracker</td>

23703

<td>

23704

<center>&diams;</center>

23705

</td>

23706

23707

23708

23709

23710

23711

23712

</tr>

23713

22874

23714

<td>trebuchet</td>

22875

23715

<td>

22876

23716

<center>&diams;</center>

22887

23727

public</a></p>

22888

23728

<hr />

22889

23729

<h2>Table: <a href="#public.schema">public</a>.<a name=

22890

"public.table.productbkbranch" id=

22891

"public.table.productbkbranch">productbkbranch</a></h2>

22892

22893

<caption>public.productbkbranch Structure</caption>

22894

<tr>

22895

22896

22897

22898

<th>Description</th>

22899

</tr>

22900

22901

22902

22903

<td>serial</td>

22904

<td><i>PRIMARY KEY</i></td>

22905

</tr>

22906

22907

<td><a href="#public.table.product">public.product.id</a></td>

22908

<td>product</td>

22909

<td>integer</td>

22910

22911

</tr>

22912

22913

22914

<td>locationurl</td>

22915

22916

22917

</tr>

22918

22919

22920

<td>weburl</td>

22921

22922

22923

</tr>

22924

</table>

22925

22926

22927

22928

22929

22930

22931

<caption>Permissions which apply to

22932

public.productbkbranch</caption>

22933

<tr>

22934

22935

<th>

22936

<center>Select</center>

22937

</th>

22938

<th>

22939

<center>Insert</center>

22940

</th>

22941

<th>

22942

<center>Update</center>

22943

</th>

22944

<th>

22945

<center>Delete</center>

22946

</th>

22947

<th>

22948

<center>Reference</center>

22949

</th>

22950

<th>

22951

22952

</th>

22953

<th>

22954

<center>Trigger</center>

22955

</th>

22956

</tr>

22957

22958

<td>group admin</td>

22959

<td>

22960

<center>&diams;</center>

22961

</td>

22962

<td>

22963

<center>&diams;</center>

22964

</td>

22965

<td>

22966

<center>&diams;</center>

22967

</td>

22968

<td>

22969

<center>&diams;</center>

22970

</td>

22971

<td>

22972

<center>&diams;</center>

22973

</td>

22974

<td>

22975

<center>&diams;</center>

22976

</td>

22977

<td>

22978

<center>&diams;</center>

22979

</td>

22980

</tr>

22981

22982

<td>group read</td>

22983

<td>

22984

<center>&diams;</center>

22985

</td>

22986

22987

22988

22989

22990

22991

22992

</tr>

22993

22994

<td>group write</td>

22995

<td>

22996

<center>&diams;</center>

22997

</td>

22998

<td>

22999

<center>&diams;</center>

23000

</td>

23001

<td>

23002

<center>&diams;</center>

23003

</td>

23004

23005

23006

23007

23008

</tr>

23009

23010

<td>postgres</td>

23011

<td>

23012

<center>&diams;</center>

23013

</td>

23014

<td>

23015

<center>&diams;</center>

23016

</td>

23017

<td>

23018

<center>&diams;</center>

23019

</td>

23020

<td>

23021

<center>&diams;</center>

23022

</td>

23023

<td>

23024

<center>&diams;</center>

23025

</td>

23026

<td>

23027

<center>&diams;</center>

23028

</td>

23029

<td>

23030

<center>&diams;</center>

23031

</td>

23032

</tr>

23033

</table>

23034

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

23035

public</a></p>

23036

<hr />

23037

<h2>Table: <a href="#public.schema">public</a>.<a name=

23038

23730

"public.table.productbounty" id=

23039

23731

"public.table.productbounty">productbounty</a></h2>

23040

23732

<p>This table records a simple link between a bounty and a product.

23655

24347

23656

24348

<td>version</td>

23657

24349

23658

24350

<td><i>UNIQUE#1 NOT NULL</i><br />

23659

24351

<br />

23660

24352

This is a text field containing the version string for this

23661

24353

release, such as '1.2.4' or '2.0.38' or '7.4.3'.</td>

23706

24398

"#public.table.productseries">public.productseries.id</a></td>

23707

24399

<td>productseries</td>

23708

24400

<td>integer</td>

23709

24401

<td><i>UNIQUE#1 NOT NULL</i><br />

23710

24402

<br />

23711

24403

A pointer to the Product Series this release forms part of. Using a

23712

24404

Product Series allows us to distinguish between releases on stable

23737

24429

</tr>

23738

24430

23739

24431

<td>valid_version</td>

23740

<td>CHECK (sane_version("version"))</td>

24432

<td>CHECK (sane_version(version))</td>

23741

24433

</tr>

23742

24434

</table>

23743

24435

25681

26373

, binarypackagename.name AS binarypackagename

25682

26374

, binarypackagerelease.summary AS binarypackagesummary

25683

26375

, binarypackagerelease.description AS binarypackagedescription

25684

, binarypackagerelease."version" AS binarypackageversion

26376

, binarypackagerelease.version AS binarypackageversion

25685

26377

, build.id AS build

25686

26378

, build.datebuilt

25687

26379

, sourcepackagerelease.id AS sourcepackagerelease

25688

, sourcepackagerelease."version" AS sourcepackagereleaseversion

26380

, sourcepackagerelease.version AS sourcepackagereleaseversion

25689

26381

, sourcepackagename.name AS sourcepackagename

25690

26382

, binarypackagepublishing.pocket

25691

26383

, binarypackagerelease.fti AS binarypackagefti

25780

26472

</th>

25781

26473

</tr>

25782

26474

26475

<td>fiera</td>

26476

<td>

26477

<center>&diams;</center>

26478

</td>

26479

26480

26481

26482

26483

26484

26485

</tr>

26486

25783

26487

<td>group admin</td>

25784

26488

<td>

25785

26489

<center>&diams;</center>

25803

26507

<center>&diams;</center>

25804

26508

</td>

25805

26509

</tr>

25806

26510

25807

26511

<td>group read</td>

25808

26512

<td>

25809

26513

<center>&diams;</center>

25815

26519

25816

26520

25817

26521

</tr>

25818

26522

25819

26523

<td>group write</td>

25820

26524

<td>

25821

26525

<center>&diams;</center>

25831

26535

25832

26536

25833

26537

</tr>

25834

26538

25835

26539

<td>postgres</td>

25836

26540

<td>

25837

26541

<center>&diams;</center>

26010

26714

<h2>Table: <a href="#public.schema">public</a>.<a name=

26011

26715

"public.table.requestedcds" id=

26012

26716

"public.table.requestedcds">requestedcds</a></h2>

26717

<p>The requested CDs of a Shipping Request.</p>

26013

26718

26014

26719

<caption>public.requestedcds Structure</caption>

26015

26720

<tr>

26029

26734

"#public.table.shippingrequest">public.shippingrequest.id</a></td>

26030

26735

<td>request</td>

26031

26736

<td>integer</td>

26032

26737

26738

<br />

26739

The request itself.</td>

26033

26740

</tr>

26034

26741

26035

26742

26036

26743

<td>quantity</td>

26037

26744

<td>integer</td>

26038

26745

26746

<br />

26747

The number of CDs.</td>

26039

26748

</tr>

26040

26749

26041

26750

26042

26751

<td>flavour</td>

26043

26752

<td>integer</td>

26044

26753

26754

<br />

26755

The flavour of the distrorelease (e.g. EdUbuntu).</td>

26045

26756

</tr>

26046

26757

26047

26758

26048

26759

<td>distrorelease</td>

26049

26760

<td>integer</td>

26050

26761

26762

<br />

26763

The distrorelease of the CDs (e.g. Ubuntu Breezy).</td>

26051

26764

</tr>

26052

26765

26053

26766

26054

26767

<td>architecture</td>

26055

26768

<td>integer</td>

26056

26769

26770

<br />

26771

The architecture the CDs are meant to be installed on (e.g.

26772

x86).</td>

26057

26773

</tr>

26058

26774

26059

26775

26060

26776

<td>quantityapproved</td>

26061

26777

<td>integer</td>

26062

26778

26779

<br />

26780

The number of CDs that were approved for shipping, in case the

26781

request was approved.</td>

26063

26782

</tr>

26064

26783

</table>

26065

26784

26185

26904

<center>&diams;</center>

26186

26905

</td>

26187

26906

</tr>

26907

26908

<td>shipit</td>

26909

<td>

26910

<center>&diams;</center>

26911

</td>

26912

26913

26914

26915

26916

26917

26918

</tr>

26919

</table>

26920

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

26921

public</a></p>

26922

<hr />

26923

<h2>Table: <a href="#public.schema">public</a>.<a name=

26924

"public.table.revision" id=

26925

"public.table.revision">revision</a></h2>

26926

26927

<caption>public.revision Structure</caption>

26928

<tr>

26929

26930

26931

26932

<th>Description</th>

26933

</tr>

26934

26935

26936

26937

<td>serial</td>

26938

<td><i>PRIMARY KEY</i></td>

26939

</tr>

26940

26941

26942

<td>date_created</td>

26943

<td>timestamp without time zone</td>

26944

<td><i>NOT NULL DEFAULT timezone('UTC'::text,

26945

('now'::text)::timestamp(6) with time zone)</i></td>

26946

</tr>

26947

26948

26949

26950

26951

26952

</tr>

26953

26954

<td><a href=

26955

"#public.table.revisionauthor">public.revisionauthor.id</a></td>

26956

<td>revision_author</td>

26957

<td>integer</td>

26958

26959

</tr>

26960

26961

<td><a href="#public.table.gpgkey">public.gpgkey.id</a></td>

26962

<td>gpgkey</td>

26963

<td>integer</td>

26964

26965

</tr>

26966

26967

<td><a href="#public.table.person">public.person.id</a></td>

26968

<td>owner</td>

26969

<td>integer</td>

26970

26971

</tr>

26972

26973

26974

<td>revision_id</td>

26975

26976

<td><i>UNIQUE NOT NULL</i></td>

26977

</tr>

26978

26979

26980

<td>revision_date</td>

26981

<td>timestamp without time zone</td>

26982

26983

</tr>

26984

</table>

26985

26986

26987

<p>Tables referencing this one via Foreign Key Constraints:</p>

26988

<ul>

26989

<li><a href=

26990

"#public.table.manifestentry">public.manifestentry</a></li>

26991

</ul>

26992

<ul>

26993

<li><a href=

26994

"#public.table.revisionnumber">public.revisionnumber</a></li>

26995

</ul>

26996

<ul>

26997

<li><a href=

26998

"#public.table.revisionparent">public.revisionparent</a></li>

26999

</ul>

27000

27001

27002

27003

27004

<caption>Permissions which apply to public.revision</caption>

27005

<tr>

27006

27007

<th>

27008

<center>Select</center>

27009

</th>

27010

<th>

27011

<center>Insert</center>

27012

</th>

27013

<th>

27014

<center>Update</center>

27015

</th>

27016

<th>

27017

<center>Delete</center>

27018

</th>

27019

<th>

27020

<center>Reference</center>

27021

</th>

27022

<th>

27023

27024

</th>

27025

<th>

27026

<center>Trigger</center>

27027

</th>

27028

</tr>

27029

27030

<td>group admin</td>

27031

<td>

27032

<center>&diams;</center>

27033

</td>

27034

<td>

27035

<center>&diams;</center>

27036

</td>

27037

<td>

27038

<center>&diams;</center>

27039

</td>

27040

<td>

27041

<center>&diams;</center>

27042

</td>

27043

<td>

27044

<center>&diams;</center>

27045

</td>

27046

<td>

27047

<center>&diams;</center>

27048

</td>

27049

<td>

27050

<center>&diams;</center>

27051

</td>

27052

</tr>

27053

27054

<td>group read</td>

27055

<td>

27056

<center>&diams;</center>

27057

</td>

27058

27059

27060

27061

27062

27063

27064

</tr>

27065

27066

<td>importd</td>

27067

<td>

27068

<center>&diams;</center>

27069

</td>

27070

<td>

27071

<center>&diams;</center>

27072

</td>

27073

27074

27075

27076

27077

27078

</tr>

27079

27080

<td>launchpad</td>

27081

<td>

27082

<center>&diams;</center>

27083

</td>

27084

27085

<td>

27086

<center>&diams;</center>

27087

</td>

27088

27089

27090

27091

27092

</tr>

27093

27094

<td>postgres</td>

27095

<td>

27096

<center>&diams;</center>

27097

</td>

27098

<td>

27099

<center>&diams;</center>

27100

</td>

27101

<td>

27102

<center>&diams;</center>

27103

</td>

27104

<td>

27105

<center>&diams;</center>

27106

</td>

27107

<td>

27108

<center>&diams;</center>

27109

</td>

27110

<td>

27111

<center>&diams;</center>

27112

</td>

27113

<td>

27114

<center>&diams;</center>

27115

</td>

27116

</tr>

27117

27118

<td>sourcerer</td>

27119

<td>

27120

<center>&diams;</center>

27121

</td>

27122

<td>

27123

<center>&diams;</center>

27124

</td>

27125

<td>

27126

<center>&diams;</center>

27127

</td>

27128

27129

27130

27131

27132

</tr>

27133

27134

<td>trebuchet</td>

27135

<td>

27136

<center>&diams;</center>

27137

</td>

27138

27139

27140

27141

27142

27143

27144

</tr>

27145

</table>

27146

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

27147

public</a></p>

27148

<hr />

27149

<h2>Table: <a href="#public.schema">public</a>.<a name=

27150

"public.table.revisionauthor" id=

27151

"public.table.revisionauthor">revisionauthor</a></h2>

27152

27153

<caption>public.revisionauthor Structure</caption>

27154

<tr>

27155

27156

27157

27158

<th>Description</th>

27159

</tr>

27160

27161

27162

27163

<td>serial</td>

27164

<td><i>PRIMARY KEY</i></td>

27165

</tr>

27166

27167

27168

27169

27170

<td><i>UNIQUE NOT NULL</i></td>

27171

</tr>

27172

</table>

27173

27174

27175

<p>Tables referencing this one via Foreign Key Constraints:</p>

27176

<ul>

27177

<li><a href="#public.table.revision">public.revision</a></li>

27178

</ul>

27179

27180

27181

27182

27183

<caption>Permissions which apply to public.revisionauthor</caption>

27184

<tr>

27185

27186

<th>

27187

<center>Select</center>

27188

</th>

27189

<th>

27190

<center>Insert</center>

27191

</th>

27192

<th>

27193

<center>Update</center>

27194

</th>

27195

<th>

27196

<center>Delete</center>

27197

</th>

27198

<th>

27199

<center>Reference</center>

27200

</th>

27201

<th>

27202

27203

</th>

27204

<th>

27205

<center>Trigger</center>

27206

</th>

27207

</tr>

27208

27209

<td>group admin</td>

27210

<td>

27211

<center>&diams;</center>

27212

</td>

27213

<td>

27214

<center>&diams;</center>

27215

</td>

27216

<td>

27217

<center>&diams;</center>

27218

</td>

27219

<td>

27220

<center>&diams;</center>

27221

</td>

27222

<td>

27223

<center>&diams;</center>

27224

</td>

27225

<td>

27226

<center>&diams;</center>

27227

</td>

27228

<td>

27229

<center>&diams;</center>

27230

</td>

27231

</tr>

27232

27233

<td>group read</td>

27234

<td>

27235

<center>&diams;</center>

27236

</td>

27237

27238

27239

27240

27241

27242

27243

</tr>

27244

27245

<td>importd</td>

27246

<td>

27247

<center>&diams;</center>

27248

</td>

27249

<td>

27250

<center>&diams;</center>

27251

</td>

27252

27253

27254

27255

27256

27257

</tr>

27258

27259

<td>launchpad</td>

27260

<td>

27261

<center>&diams;</center>

27262

</td>

27263

27264

27265

27266

27267

27268

27269

</tr>

27270

27271

<td>postgres</td>

27272

<td>

27273

<center>&diams;</center>

27274

</td>

27275

<td>

27276

<center>&diams;</center>

27277

</td>

27278

<td>

27279

<center>&diams;</center>

27280

</td>

27281

<td>

27282

<center>&diams;</center>

27283

</td>

27284

<td>

27285

<center>&diams;</center>

27286

</td>

27287

<td>

27288

<center>&diams;</center>

27289

</td>

27290

<td>

27291

<center>&diams;</center>

27292

</td>

27293

</tr>

27294

</table>

27295

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

27296

public</a></p>

27297

<hr />

27298

<h2>Table: <a href="#public.schema">public</a>.<a name=

27299

"public.table.revisionnumber" id=

27300

"public.table.revisionnumber">revisionnumber</a></h2>

27301

27302

<caption>public.revisionnumber Structure</caption>

27303

<tr>

27304

27305

27306

27307

<th>Description</th>

27308

</tr>

27309

27310

27311

27312

<td>serial</td>

27313

<td><i>UNIQUE#2 PRIMARY KEY</i></td>

27314

</tr>

27315

27316

27317

<td>sequence</td>

27318

<td>integer</td>

27319

<td><i>UNIQUE#1 NOT NULL</i></td>

27320

</tr>

27321

27322

<td><a href="#public.table.branch">public.branch.id</a></td>

27323

<td>branch</td>

27324

<td>integer</td>

27325

<td><i>UNIQUE#2 UNIQUE#1 NOT NULL</i></td>

27326

</tr>

27327

27328

<td><a href="#public.table.revision">public.revision.id</a></td>

27329

<td>revision</td>

27330

<td>integer</td>

27331

<td><i>UNIQUE#1 NOT NULL</i></td>

27332

</tr>

27333

</table>

27334

27335

27336

<p>Tables referencing this one via Foreign Key Constraints:</p>

27337

<ul>

27338

<li><a href="#public.table.branch">public.branch</a></li>

27339

</ul>

27340

27341

27342

27343

27344

<caption>Permissions which apply to public.revisionnumber</caption>

27345

<tr>

27346

27347

<th>

27348

<center>Select</center>

27349

</th>

27350

<th>

27351

<center>Insert</center>

27352

</th>

27353

<th>

27354

<center>Update</center>

27355

</th>

27356

<th>

27357

<center>Delete</center>

27358

</th>

27359

<th>

27360

<center>Reference</center>

27361

</th>

27362

<th>

27363

27364

</th>

27365

<th>

27366

<center>Trigger</center>

27367

</th>

27368

</tr>

27369

27370

<td>group admin</td>

27371

<td>

27372

<center>&diams;</center>

27373

</td>

27374

<td>

27375

<center>&diams;</center>

27376

</td>

27377

<td>

27378

<center>&diams;</center>

27379

</td>

27380

<td>

27381

<center>&diams;</center>

27382

</td>

27383

<td>

27384

<center>&diams;</center>

27385

</td>

27386

<td>

27387

<center>&diams;</center>

27388

</td>

27389

<td>

27390

<center>&diams;</center>

27391

</td>

27392

</tr>

27393

27394

<td>group read</td>

27395

<td>

27396

<center>&diams;</center>

27397

</td>

27398

27399

27400

27401

27402

27403

27404

</tr>

27405

27406

<td>importd</td>

27407

<td>

27408

<center>&diams;</center>

27409

</td>

27410

<td>

27411

<center>&diams;</center>

27412

</td>

27413

27414

27415

27416

27417

27418

</tr>

27419

27420

<td>launchpad</td>

27421

<td>

27422

<center>&diams;</center>

27423

</td>

27424

27425

27426

27427

27428

27429

27430

</tr>

27431

27432

<td>postgres</td>

27433

<td>

27434

<center>&diams;</center>

27435

</td>

27436

<td>

27437

<center>&diams;</center>

27438

</td>

27439

<td>

27440

<center>&diams;</center>

27441

</td>

27442

<td>

27443

<center>&diams;</center>

27444

</td>

27445

<td>

27446

<center>&diams;</center>

27447

</td>

27448

<td>

27449

<center>&diams;</center>

27450

</td>

27451

<td>

27452

<center>&diams;</center>

27453

</td>

27454

</tr>

27455

</table>

27456

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

27457

public</a></p>

27458

<hr />

27459

<h2>Table: <a href="#public.schema">public</a>.<a name=

27460

"public.table.revisionparent" id=

27461

"public.table.revisionparent">revisionparent</a></h2>

27462

27463

<caption>public.revisionparent Structure</caption>

27464

<tr>

27465

27466

27467

27468

<th>Description</th>

27469

</tr>

27470

27471

27472

27473

<td>serial</td>

27474

<td><i>PRIMARY KEY</i></td>

27475

</tr>

27476

27477

27478

<td>sequence</td>

27479

<td>integer</td>

27480

27481

</tr>

27482

27483

<td><a href="#public.table.revision">public.revision.id</a></td>

27484

<td>revision</td>

27485

<td>integer</td>

27486

<td><i>UNIQUE#1 NOT NULL</i></td>

27487

</tr>

27488

27489

27490

<td>parent_id</td>

27491

27492

<td><i>UNIQUE#1 NOT NULL</i></td>

27493

</tr>

27494

</table>

27495

27496

27497

27498

27499

27500

27501

<caption>Permissions which apply to public.revisionparent</caption>

27502

<tr>

27503

27504

<th>

27505

<center>Select</center>

27506

</th>

27507

<th>

27508

<center>Insert</center>

27509

</th>

27510

<th>

27511

<center>Update</center>

27512

</th>

27513

<th>

27514

<center>Delete</center>

27515

</th>

27516

<th>

27517

<center>Reference</center>

27518

</th>

27519

<th>

27520

27521

</th>

27522

<th>

27523

<center>Trigger</center>

27524

</th>

27525

</tr>

27526

27527

<td>group admin</td>

27528

<td>

27529

<center>&diams;</center>

27530

</td>

27531

<td>

27532

<center>&diams;</center>

27533

</td>

27534

<td>

27535

<center>&diams;</center>

27536

</td>

27537

<td>

27538

<center>&diams;</center>

27539

</td>

27540

<td>

27541

<center>&diams;</center>

27542

</td>

27543

<td>

27544

<center>&diams;</center>

27545

</td>

27546

<td>

27547

<center>&diams;</center>

27548

</td>

27549

</tr>

27550

27551

<td>group read</td>

27552

<td>

27553

<center>&diams;</center>

27554

</td>

27555

27556

27557

27558

27559

27560

27561

</tr>

27562

27563

<td>importd</td>

27564

<td>

27565

<center>&diams;</center>

27566

</td>

27567

<td>

27568

<center>&diams;</center>

27569

</td>

27570

27571

27572

27573

27574

27575

</tr>

27576

27577

<td>launchpad</td>

27578

<td>

27579

<center>&diams;</center>

27580

</td>

27581

27582

27583

27584

27585

27586

27587

</tr>

27588

27589

<td>postgres</td>

27590

<td>

27591

<center>&diams;</center>

27592

</td>

27593

<td>

27594

<center>&diams;</center>

27595

</td>

27596

<td>

27597

<center>&diams;</center>

27598

</td>

27599

<td>

27600

<center>&diams;</center>

27601

</td>

27602

<td>

27603

<center>&diams;</center>

27604

</td>

27605

<td>

27606

<center>&diams;</center>

27607

</td>

27608

<td>

27609

<center>&diams;</center>

27610

</td>

27611

</tr>

26188

27612

</table>

26189

27613

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

26190

27614

public</a></p>

26252

27676

26253

27677

<p>Tables referencing this one via Foreign Key Constraints:</p>

26254

27678

<ul>

26255

<li><a href=

26256

"#public.table.distrorelease">public.distrorelease</a></li>

26257

</ul>

26258

<ul>

26259

27679

<li><a href="#public.table.label">public.label</a></li>

26260

27680

</ul>

26261

27681

<ul>

26451

27871

</th>

26452

27872

</tr>

26453

27873

27874

<td>fiera</td>

27875

<td>

27876

<center>&diams;</center>

27877

</td>

27878

27879

27880

27881

27882

27883

27884

</tr>

27885

26454

27886

<td>group admin</td>

26455

27887

<td>

26456

27888

<center>&diams;</center>

26474

27906

<center>&diams;</center>

26475

27907

</td>

26476

27908

</tr>

26477

27909

26478

27910

<td>group read</td>

26479

27911

<td>

26480

27912

<center>&diams;</center>

26486

27918

26487

27919

26488

27920

</tr>

26489

27921

26490

27922

<td>group write</td>

26491

27923

<td>

26492

27924

<center>&diams;</center>

26502

27934

26503

27935

26504

27936

</tr>

26505

27937

26506

27938

<td>postgres</td>

26507

27939

<td>

26508

27940

<center>&diams;</center>

26526

27958

<center>&diams;</center>

26527

27959

</td>

26528

27960

</tr>

27961

27962

<td>queued</td>

27963

<td>

27964

<center>&diams;</center>

27965

</td>

27966

27967

27968

27969

27970

27971

27972

</tr>

27973

27974

<td>uploader</td>

27975

<td>

27976

<center>&diams;</center>

27977

</td>

27978

27979

27980

27981

27982

27983

27984

</tr>

26529

27985

</table>

26530

27986

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

26531

27987

public</a></p>

26669

28125

<center>&diams;</center>

26670

28126

</td>

26671

28127

</tr>

28128

28129

<td>uploader</td>

28130

<td>

28131

<center>&diams;</center>

28132

</td>

28133

28134

28135

28136

28137

28138

28139

</tr>

26672

28140

</table>

26673

28141

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

26674

28142

public</a></p>

27008

28476

<center>&diams;</center>

27009

28477

</td>

27010

28478

</tr>

28479

28480

<td>queued</td>

28481

<td>

28482

<center>&diams;</center>

28483

</td>

28484

<td>

28485

<center>&diams;</center>

28486

</td>

28487

28488

28489

28490

28491

28492

</tr>

27011

28493

</table>

27012

28494

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

27013

28495

public</a></p>

27337

28819

<center>&diams;</center>

27338

28820

</td>

27339

28821

</tr>

28822

28823

<td>queued</td>

28824

<td>

28825

<center>&diams;</center>

28826

</td>

28827

<td>

28828

<center>&diams;</center>

28829

</td>

28830

28831

28832

28833

28834

28835

</tr>

27340

28836

</table>

27341

28837

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

27342

28838

public</a></p>

27344

28840

<h2>Table: <a href="#public.schema">public</a>.<a name=

27345

28841

"public.table.shipment" id=

27346

28842

"public.table.shipment">shipment</a></h2>

28843

<p>A shipment is the link between a ShippingRequest and a

28844

ShippingRun. When a Shipment is created for a ShippingRequest, it

28845

gets locked and can't be changed anymore.</p>

27347

28846

27348

28847

<caption>public.shipment Structure</caption>

27349

28848

<tr>

27362

28861

27363

28862

<td>logintoken</td>

27364

28863

27365

<td><i>UNIQUE</i></td>

28864

<td><i>UNIQUE NOT NULL</i><br />

28865

<br />

28866

A unique token used to identify users that come back after

28867

receiving CDs as part of an shock and awe campaign.</td>

27366

28868

</tr>

27367

28869

27368

28870

<td><a href=

28871

"#public.table.shippingrun">public.shippingrun.id</a></td>

27369

28872

<td>shippingrun</td>

27370

28873

<td>integer</td>

27371

28874

28875

<br />

28876

The shippingrun to which this shipment belongs.</td>

27372

28877

</tr>

27373

28878

27374

28879

27375

28880

<td>dateshipped</td>

27376

28881

<td>timestamp without time zone</td>

27377

28882

28883

<br />

28884

The date when this shipment was shipped by the shipping

28885

company.</td>

27378

28886

</tr>

27379

28887

27380

28888

27381

28889

<td>shippingservice</td>

27382

28890

<td>integer</td>

27383

28891

28892

<br />

28893

The shipping service used for this shipment.</td>

27384

28894

</tr>

27385

28895

27386

28896

27387

28897

<td>trackingcode</td>

27388

28898

27389

28899

28900

<br />

28901

A code used to track the shipment after it's shipped.</td>

28902

</tr>

28903

28904

<td><a href=

28905

"#public.table.shippingrequest">public.shippingrequest.id</a></td>

28906

<td>request</td>

28907

<td>integer</td>

28908

<td><i>UNIQUE</i><br />

28909

<br />

28910

A link to the ShippingRequest table.</td>

27390

28911

</tr>

27391

28912

</table>

27392

28913

27393

28914

27394

<p>Tables referencing this one via Foreign Key Constraints:</p>

27395

<ul>

27396

<li><a href=

27397

"#public.table.shippingrequest">public.shippingrequest</a></li>

27398

</ul>

27399

28915

27400

28916

27401

28917

27501

29017

<center>&diams;</center>

27502

29018

</td>

27503

29019

</tr>

29020

29021

<td>shipit</td>

29022

<td>

29023

<center>&diams;</center>

29024

</td>

29025

<td>

29026

<center>&diams;</center>

29027

</td>

29028

29029

29030

29031

29032

29033

</tr>

27504

29034

</table>

27505

29035

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

27506

29036

public</a></p>

27508

29038

<h2>Table: <a href="#public.schema">public</a>.<a name=

27509

29039

"public.table.shippingrequest" id=

27510

29040

"public.table.shippingrequest">shippingrequest</a></h2>

29041

<p>A shipping request made through ShipIt.</p>

27511

29042

27512

29043

<caption>public.shippingrequest Structure</caption>

27513

29044

<tr>

27526

29057

<td><a href="#public.table.person">public.person.id</a></td>

27527

29058

<td>recipient</td>

27528

29059

<td>integer</td>

27529

29060

29061

<br />

29062

The person who requested.</td>

27530

29063

</tr>

27531

29064

27532

<td><a href="#public.table.shipment">public.shipment.id</a></td>

27533

<td>shipment</td>

27534

<td>integer</td>

27535

27536

</tr>

27537

27538

29065

<td><a href="#public.table.person">public.person.id</a></td>

27539

29066

<td>whoapproved</td>

27540

29067

<td>integer</td>

27541

29068

29069

<br />

29070

The person who approved this.</td>

27542

29071

</tr>

27543

29072

27544

29073

27545

29074

<td>cancelled</td>

27546

29075

<td>boolean</td>

27547

<td><i>NOT NULL DEFAULT false</i></td>

29076

<td><i>NOT NULL DEFAULT false</i><br />

29077

<br />

29078

Is this request cancelled?</td>

27548

29079

</tr>

27549

29080

27550

29081

<td><a href="#public.table.person">public.person.id</a></td>

27551

29082

<td>whocancelled</td>

27552

29083

<td>integer</td>

27553

29084

29085

<br />

29086

The person who cancelled this.</td>

27554

29087

</tr>

27555

29088

27556

29089

27557

29090

<td>daterequested</td>

27558

29091

<td>timestamp without time zone</td>

27559

29092

29093

<br />

29094

The date this request was made.</td>

27560

29095

</tr>

27561

29096

27562

29097

27563

29098

<td>approved</td>

27564

29099

<td>boolean</td>

27565

29100

29101

<br />

29102

Is this request approved? A value of NULL means it's pending

29103

approval.</td>

27566

29104

</tr>

27567

27568

29105

29106

<td><a href=

29107

"#public.table.shockandawe">public.shockandawe.id</a></td>

27569

29108

<td>shockandawe</td>

27570

29109

<td>integer</td>

27571

29110

29111

<br />

29112

The Shock and Awe program that generated this request, in case this

29113

is part of a SA program.</td>

27572

29114

</tr>

27573

29115

27574

29116

27575

29117

<td>reason</td>

27576

29118

27577

29119

29120

<br />

29121

A comment from the requester explaining why he want the CDs.</td>

27578

29122

</tr>

27579

29123

27580

29124

27581

29125

<td>highpriority</td>

27582

29126

<td>boolean</td>

27583

<td><i>NOT NULL DEFAULT false</i></td>

29127

<td><i>NOT NULL DEFAULT false</i><br />

29128

<br />

29129

Is this a high priority request?</td>

29130

</tr>

29131

29132

29133

<td>recipientdisplayname</td>

29134

29135

29136

<br />

29137

Used as the recipient's name when a request is made by a ShipIt

29138

admin in behalf of someone else</td>

29139

</tr>

29140

29141

29142

<td>addressline1</td>

29143

29144

29145

<br />

29146

The address (first line) to which this request should be

29147

shipped.</td>

29148

</tr>

29149

29150

29151

<td>addressline2</td>

29152

29153

29154

<br />

29155

The address (second line) to which this request should be

29156

shipped.</td>

29157

</tr>

29158

29159

29160

<td>organization</td>

29161

29162

29163

<br />

29164

The organization requesting the CDs.</td>

29165

</tr>

29166

29167

29168

29169

29170

29171

<br />

29172

The city to which this request should be shipped.</td>

29173

</tr>

29174

29175

29176

<td>province</td>

29177

29178

29179

<br />

29180

The province to which this request should be shipped.</td>

29181

</tr>

29182

29183

<td><a href="#public.table.country">public.country.id</a></td>

29184

<td>country</td>

29185

<td>integer</td>

29186

29187

<br />

29188

The country to which this request should be shipped.</td>

29189

</tr>

29190

29191

29192

<td>postcode</td>

29193

29194

29195

<br />

29196

The postcode to which this request should be shipped.</td>

29197

</tr>

29198

29199

29200

<td>phone</td>

29201

29202

29203

<br />

29204

The phone number of the requester.</td>

29205

</tr>

29206

29207

29208

29209

<td>tsvector</td>

29210

27584

29211

</tr>

27585

29212

</table>

27586

29213

27595

29222

<td>is_person</td>

27596

29223

<td>CHECK (is_person(recipient))</td>

27597

29224

</tr>

29225

29226

<td>printable_addresses</td>

29227

<td>CHECK (is_printable_ascii((((((((COALESCE(recipientdisplayname,

29228

''::text) || COALESCE(addressline1, ''::text)) ||

29229

COALESCE(addressline2, ''::text)) || COALESCE(organization,

29230

''::text)) || COALESCE(city, ''::text)) || COALESCE(province,

29231

''::text)) || COALESCE(postcode, ''::text)) || COALESCE(phone,

29232

''::text))))</td>

29233

</tr>

27598

29234

</table>

27599

29235

27600

29236

<p>Tables referencing this one via Foreign Key Constraints:</p>

27602

29238

<li><a href=

27603

29239

"#public.table.requestedcds">public.requestedcds</a></li>

27604

29240

</ul>

29241

<ul>

29242

<li><a href="#public.table.shipment">public.shipment</a></li>

29243

</ul>

27605

29244

27606

29245

27607

29246

27708

29347

<center>&diams;</center>

27709

29348

</td>

27710

29349

</tr>

29350

29351

<td>shipit</td>

29352

<td>

29353

<center>&diams;</center>

29354

</td>

29355

29356

<td>

29357

<center>&diams;</center>

29358

</td>

29359

29360

29361

29362

29363

</tr>

27711

29364

</table>

27712

29365

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

27713

29366

public</a></p>

27715

29368

<h2>Table: <a href="#public.schema">public</a>.<a name=

27716

29369

"public.table.shippingrun" id=

27717

29370

"public.table.shippingrun">shippingrun</a></h2>

29371

<p>A shipping run is a set of shipments that are sent to the

29372

shipping company in the same date.</p>

27718

29373

27719

29374

<caption>public.shippingrun Structure</caption>

27720

29375

<tr>

27733

29388

27734

29389

<td>datecreated</td>

27735

29390

<td>timestamp without time zone</td>

27736

29391

29392

<br />

29393

The date this shipping run was created.</td>

29394

</tr>

29395

29396

29397

<td>sentforshipping</td>

29398

<td>boolean</td>

29399

<td><i>NOT NULL DEFAULT false</i><br />

29400

<br />

29401

The exported file was sent to the shipping company already?</td>

29402

</tr>

29403

29404

<td><a href=

29405

"#public.table.libraryfilealias">public.libraryfilealias.id</a></td>

29406

<td>csvfile</td>

29407

<td>integer</td>

29408

<td><i>UNIQUE</i><br />

29409

<br />

29410

A csv file with all requests of this shipping run, to be sent to

29411

the shipping company.</td>

27737

29412

</tr>

27738

29413

</table>

27739

29414

27740

29415

29416

<p>Tables referencing this one via Foreign Key Constraints:</p>

29417

<ul>

29418

<li><a href="#public.table.shipment">public.shipment</a></li>

29419

</ul>

27741

29420

27742

29421

27743

29422

27843

29522

<center>&diams;</center>

27844

29523

</td>

27845

29524

</tr>

29525

29526

<td>shipit</td>

29527

<td>

29528

<center>&diams;</center>

29529

</td>

29530

<td>

29531

<center>&diams;</center>

29532

</td>

29533

<td>

29534

<center>&diams;</center>

29535

</td>

29536

29537

29538

29539

29540

</tr>

27846

29541

</table>

27847

29542

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

27848

29543

public</a></p>

27892

29587

</table>

27893

29588

27894

29589

29590

<p>Tables referencing this one via Foreign Key Constraints:</p>

29591

<ul>

29592

<li><a href=

29593

"#public.table.shippingrequest">public.shippingrequest</a></li>

29594

</ul>

27895

29595

27896

29596

27897

29597

28468

30168

</ul>

28469

30169

<ul>

28470

30170

<li><a href=

30171

"#public.table.distributionsourcepackagecache">public.distributionsourcepackagecache</a></li>

30172

</ul>

30173

<ul>

30174

<li><a href=

28471

30175

"#public.table.maintainership">public.maintainership</a></li>

28472

30176

</ul>

28473

30177

<ul>

28474

30178

<li><a href=

30179

"#public.table.packagebugcontact">public.packagebugcontact</a></li>

30180

</ul>

30181

<ul>

30182

<li><a href=

28475

30183

"#public.table.packageselection">public.packageselection</a></li>

28476

30184

</ul>

28477

30185

<ul>

28606

30314

</td>

28607

30315

</tr>

28608

30316

30317

<td>queued</td>

30318

<td>

30319

<center>&diams;</center>

30320

</td>

30321

30322

30323

30324

30325

30326

30327

</tr>

30328

28609

30329

<td>sourcerer</td>

28610

30330

<td>

28611

30331

<center>&diams;</center>

28617

30337

28618

30338

28619

30339

</tr>

30340

30341

<td>statistician</td>

30342

<td>

30343

<center>&diams;</center>

30344

</td>

30345

30346

30347

30348

30349

30350

30351

</tr>

30352

30353

<td>targetnamecacheupdater</td>

30354

<td>

30355

<center>&diams;</center>

30356

</td>

30357

30358

30359

30360

30361

30362

30363

</tr>

30364

30365

<td>tickettracker</td>

30366

<td>

30367

<center>&diams;</center>

30368

</td>

30369

30370

30371

30372

30373

30374

30375

</tr>

28620

30376

28621

30377

<td>trebuchet</td>

28622

30378

<td>

28629

30385

28630

30386

28631

30387

</tr>

30388

30389

<td>uploader</td>

30390

<td>

30391

<center>&diams;</center>

30392

</td>

30393

<td>

30394

<center>&diams;</center>

30395

</td>

30396

30397

30398

30399

30400

30401

</tr>

28632

30402

</table>

28633

30403

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

28634

30404

public</a></p>

28937

30707

28938

30708

</tr>

28939

30709

30710

<td>statistician</td>

30711

<td>

30712

<center>&diams;</center>

30713

</td>

30714

30715

30716

30717

30718

30719

30720

</tr>

30721

28940

30722

<td>trebuchet</td>

28941

30723

<td>

28942

30724

<center>&diams;</center>

28948

30730

28949

30731

28950

30732

</tr>

30733

30734

<td>uploader</td>

30735

<td>

30736

<center>&diams;</center>

30737

</td>

30738

30739

30740

30741

30742

30743

30744

</tr>

28951

30745

</table>

28952

30746

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

28953

30747

public</a></p>

29649

31443

</tr>

29650

31444

29651

31445

<td>valid_version</td>

29652

<td>CHECK (valid_debian_version("version"))</td>

31446

<td>CHECK (valid_debian_version(version))</td>

29653

31447

</tr>

29654

31448

</table>

29655

31449

29796

31590

</td>

29797

31591

</tr>

29798

31592

31593

<td>queued</td>

31594

<td>

31595

<center>&diams;</center>

31596

</td>

31597

31598

31599

31600

31601

31602

31603

</tr>

31604

29799

31605

<td>sourcerer</td>

29800

31606

<td>

29801

31607

<center>&diams;</center>

29809

31615

29810

31616

29811

31617

</tr>

31618

31619

<td>statistician</td>

31620

<td>

31621

<center>&diams;</center>

31622

</td>

31623

31624

31625

31626

31627

31628

31629

</tr>

29812

31630

29813

31631

<td>trebuchet</td>

29814

31632

<td>

29821

31639

29822

31640

29823

31641

</tr>

31642

31643

<td>uploader</td>

31644

<td>

31645

<center>&diams;</center>

31646

</td>

31647

<td>

31648

<center>&diams;</center>

31649

</td>

31650

31651

31652

31653

31654

31655

</tr>

29824

31656

</table>

29825

31657

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

29826

31658

public</a></p>

30021

31853

30022

31854

30023

31855

</tr>

31856

31857

<td>uploader</td>

31858

<td>

31859

<center>&diams;</center>

31860

</td>

31861

<td>

31862

<center>&diams;</center>

31863

</td>

31864

31865

31866

31867

31868

31869

</tr>

30024

31870

</table>

30025

31871

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

30026

31872

public</a></p>

30185

32031

30186

32032

<td>priority</td>

30187

32033

<td>integer</td>

30188

32034

<td><i>NOT NULL DEFAULT 5</i><br />

30189

32035

<br />

30190

32036

An enum that gives the implementation priority (low, medium, high,

30191

32037

emergency) of the feature defined in this specification.</td>

30194

32040

30195

32041

<td>specurl</td>

30196

32042

30197

<td><i>UNIQUE NOT NULL</i><br />

32043

<td><i>UNIQUE</i><br />

30198

32044

<br />

30199

32045

The URL where the specification itself can be found. This is

30200

32046

usually a wiki page somewhere.</td>

30210

32056

message or status flags that have meaning to the project, not

30211

32057

Launchpad. This whiteboard is just the place for it.</td>

30212

32058

</tr>

32059

32060

<td><a href=

32061

"#public.table.specification">public.specification.id</a></td>

32062

<td>superseded_by</td>

32063

<td>integer</td>

32064

32065

<br />

32066

The specification which replaced this specification.</td>

32067

</tr>

32068

32069

32070

<td>needs_discussion</td>

32071

<td>boolean</td>

32072

<td><i>NOT NULL DEFAULT true</i><br />

32073

<br />

32074

Whether or not this specification requires further discussion at

32075

this sprint. This is used as part of the scheduling algorithm.</td>

32076

</tr>

32077

32078

32079

<td>direction_approved</td>

32080

<td>boolean</td>

32081

<td><i>NOT NULL DEFAULT false</i></td>

32082

</tr>

32083

32084

32085

32086

<td>integer</td>

32087

32088

</tr>

32089

32090

32091

<td>delivery</td>

32092

<td>integer</td>

32093

32094

</tr>

30213

32095

</table>

30214

32096

30215

32097

30234

32116

NULL)))</td>

30235

32117

</tr>

30236

32118

32119

<td>specification_not_self_superseding</td>

32120

<td>CHECK ((superseded_by <> id))</td>

32121

</tr>

32122

30237

32123

<td>valid_name</td>

30238

32124

<td>CHECK (valid_name(name))</td>

30239

32125

</tr>

30240

32126

30241

32127

<td>valid_url</td>

30242

32128

<td>CHECK (valid_absolute_url(specurl))</td>

30243

32129

</tr>

30246

32132

<p>Tables referencing this one via Foreign Key Constraints:</p>

30247

32133

<ul>

30248

32134

<li><a href=

32135

"#public.table.specification">public.specification</a></li>

32136

</ul>

32137

<ul>

32138

<li><a href=

30249

32139

"#public.table.specificationbug">public.specificationbug</a></li>

30250

32140

</ul>

30251

32141

<ul>

30254

32144

</ul>

30255

32145

<ul>

30256

32146

<li><a href=

30257

"#public.table.specificationreview">public.specificationreview</a></li>

32147

"#public.table.specificationfeedback">public.specificationfeedback</a></li>

30258

32148

</ul>

30259

32149

<ul>

30260

32150

<li><a href=

30683

32573

public</a></p>

30684

32574

<hr />

30685

32575

<h2>Table: <a href="#public.schema">public</a>.<a name=

30686

"public.table.specificationreview" id=

30687

"public.table.specificationreview">specificationreview</a></h2>

32576

"public.table.specificationfeedback" id=

32577

"public.table.specificationfeedback">specificationfeedback</a></h2>

30688

32578

<p>A table representing a review request of a specification, from

30689

32579

one user to another, with an optional message.</p>

30690

32580

30691

<caption>public.specificationreview Structure</caption>

32581

<caption>public.specificationfeedback Structure</caption>

30692

32582

<tr>

30693

32583

30694

32584

30718

32608

</tr>

30719

32609

30720

32610

<td><a href="#public.table.person">public.person.id</a></td>

30721

<td>requestor</td>

32611

<td>requester</td>

30722

32612

<td>integer</td>

30723

32613

<td><i>UNIQUE#1 NOT NULL</i><br />

30724

32614

<br />

30725

32615

The person who made the request.</td>

30726

32616

</tr>

30730

32620

30731

32621

30732

32622

<br />

30733

An optional text message for the reviewer, from the requestor.</td>

32623

An optional text message for the reviewer, from the requester.</td>

30734

32624

</tr>

30735

32625

</table>

30736

32626

30740

32630

30741

32631

30742

32632

<caption>Permissions which apply to

30743

public.specificationreview</caption>

32633

public.specificationfeedback</caption>

30744

32634

<tr>

30745

32635

30746

32636

<th>

31561

33451

<td>integer</td>

31562

33452

<td><i>UNIQUE#1 NOT NULL</i></td>

31563

33453

</tr>

33454

33455

33456

<td>status</td>

33457

<td>integer</td>

33458

<td><i>NOT NULL DEFAULT 30</i><br />

33459

<br />

33460

Whether or not the spec has been approved on the agenda for this

33461

sprint.</td>

33462

</tr>

33463

33464

33465

<td>whiteboard</td>

33466

33467

33468

<br />

33469

A place to store comments specifically related to this spec being

33470

on the agenda of this meeting.</td>

33471

</tr>

31564

33472

</table>

31565

33473

31566

33474

31638

33546

<td>

31639

33547

<center>&diams;</center>

31640

33548

</td>

31641

33549

<td>

33550

<center>&diams;</center>

33551

</td>

31642

33552

<td>

31643

33553

<center>&diams;</center>

31644

33554

</td>

32339

34249

<center>&diams;</center>

32340

34250

</td>

32341

34251

</tr>

34252

34253

<td>uploader</td>

34254

<td>

34255

<center>&diams;</center>

34256

</td>

34257

<td>

34258

<center>&diams;</center>

34259

</td>

34260

34261

34262

34263

34264

34265

</tr>

32342

34266

</table>

32343

34267

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

32344

34268

public</a></p>

32464

34388

<td><i>NOT NULL DEFAULT timezone('UTC'::text,

32465

34389

('now'::text)::timestamp(6) with time zone)</i><br />

32466

34390

<br />

32467

The date we last saw a comment from the requestor (owner).</td>

34391

The date we last saw a comment from the requester (owner).</td>

32468

34392

</tr>

32469

34393

32470

34394

32474

34398

<br />

32475

34399

The date we "confirmed" or "accepted" this support request. It is

32476

34400

usually set to the date of the first response by someone other than

32477

the requestor. This allows us to track the time between first

34401

the requester. This allows us to track the time between first

32478

34402

request and first response.</td>

32479

34403

</tr>

32480

34404

32494

34418

32495

34419

<br />

32496

34420

The date we last saw a comment from somebody other than the

32497

requestor.</td>

34421

requester.</td>

32498

34422

</tr>

32499

34423

32500

34424

32503

34427

32504

34428

<br />

32505

34429

The date this ticket was last "answered", in the sense of receiving

32506

a comment from someone other than the requestor that they

34430

a comment from someone other than the requester that they

32507

34431

considered sufficient to close the ticket.</td>

32508

34432

</tr>

32509

34433

32512

34436

<td>timestamp without time zone</td>

32513

34437

32514

34438

<br />

32515

The date the requestor marked this ticket CLOSED.</td>

34439

The date the requester marked this ticket CLOSED.</td>

32516

34440

</tr>

32517

34441

32518

34442

32674

34598

<center>&diams;</center>

32675

34599

</td>

32676

34600

</tr>

34601

34602

<td>tickettracker</td>

34603

<td>

34604

<center>&diams;</center>

34605

</td>

34606

34607

34608

34609

34610

34611

34612

</tr>

32677

34613

</table>

32678

34614

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

32679

34615

public</a></p>

33778

35714

33779

35715

</tr>

33780

35716

35717

<td>poattach</td>

35718

<td>

35719

<center>&diams;</center>

35720

</td>

35721

35722

35723

35724

35725

35726

35727

</tr>

35728

33781

35729

<td>poexport</td>

33782

35730

<td>

33783

35731

<center>&diams;</center>

33789

35737

33790

35738

33791

35739

</tr>

33792

35740

33793

35741

<td>poimport</td>

33794

35742

<td>

33795

35743

<center>&diams;</center>

33801

35749

33802

35750

33803

35751

</tr>

33804

35752

33805

35753

<td>postgres</td>

33806

35754

<td>

33807

35755

<center>&diams;</center>

33974

35922

33975

35923

</tr>

33976

35924

35925

<td>poattach</td>

35926

<td>

35927

<center>&diams;</center>

35928

</td>

35929

35930

35931

35932

35933

35934

35935

</tr>

35936

33977

35937

<td>poexport</td>

33978

35938

<td>

33979

35939

<center>&diams;</center>

33985

35945

33986

35946

33987

35947

</tr>

33988

35948

33989

35949

<td>poimport</td>

33990

35950

<td>

33991

35951

<center>&diams;</center>

33997

35957

33998

35958

33999

35959

</tr>

34000

35960

34001

35961

<td>postgres</td>

34002

35962

<td>

34003

35963

<center>&diams;</center>

34358

36318

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

34359

36319

public</a></p>

34360

36320

<hr />

34361

<h2>View: <a href="#public.schema">public</a>.<a name=

34362

"public.view.vsourcepackageindistro" id=

34363

"public.view.vsourcepackageindistro">vsourcepackageindistro</a></h2>

34364

<p>This view allows us to answer the question: what source packages

34365

have releases in a certain distribution. This is an interesting

34366

case of where a view can actually solve a problem that SQLObject

34367

can't -- there is no way of doing this query (that I see at least)

34368

in regular sqlos because there is no DISTINCT and no way to filter

34369

things without iterating in Python (which generates N queries and

34370

we don't want to go down that route).</p>

34371

34372

<caption>public.vsourcepackageindistro Structure</caption>

34373

<tr>

34374

34375

34376

34377

<th>Description</th>

34378

</tr>

34379

34380

34381

34382

<td>integer</td>

34383

34384

</tr>

34385

34386

34387

<td>manifest</td>

34388

<td>integer</td>

34389

34390

</tr>

34391

34392

34393

<td>format</td>

34394

<td>integer</td>

34395

34396

</tr>

34397

34398

34399

<td>sourcepackagename</td>

34400

<td>integer</td>

34401

34402

</tr>

34403

34404

34405

34406

34407

34408

</tr>

34409

34410

34411

<td>distrorelease</td>

34412

<td>integer</td>

34413

34414

</tr>

34415

34416

34417

<td>distribution</td>

34418

<td>integer</td>

34419

34420

</tr>

34421

34422

34423

<td>status</td>

34424

<td>integer</td>

34425

34426

</tr>

34427

34428

34429

<td>pocket</td>

34430

<td>integer</td>

34431

34432

</tr>

34433

</table>

34434

34435

34436

34437

<pre>

34438

SELECT sourcepackagerelease.id

34439

, sourcepackagerelease.manifest

34440

, sourcepackagerelease.format

34441

, sourcepackagerelease.sourcepackagename

34442

, sourcepackagename.name

34443

, sourcepackagepublishing.distrorelease

34444

, distrorelease.distribution

34445

, sourcepackagepublishing.status

34446

, sourcepackagepublishing.pocket

34447

FROM (

34448

(

34449

(sourcepackagepublishing

34450

JOIN sourcepackagerelease

34451

ON (

34452

(sourcepackagepublishing.sourcepackagerelease = sourcepackagerelease.id)

34453

)

34454

)

34455

JOIN distrorelease

34456

ON (

34457

(sourcepackagepublishing.distrorelease = distrorelease.id)

34458

)

34459

)

34460

JOIN sourcepackagename

34461

ON (

34462

(sourcepackagerelease.sourcepackagename = sourcepackagename.id)

34463

)

34464

);

34465

</pre>

34466

34467

34468

34469

<caption>Permissions which apply to

34470

public.vsourcepackageindistro</caption>

34471

<tr>

34472

34473

<th>

34474

<center>Select</center>

34475

</th>

34476

<th>

34477

<center>Insert</center>

34478

</th>

34479

<th>

34480

<center>Update</center>

34481

</th>

34482

<th>

34483

<center>Delete</center>

34484

</th>

34485

<th>

34486

<center>Reference</center>

34487

</th>

34488

<th>

34489

34490

</th>

34491

<th>

34492

<center>Trigger</center>

34493

</th>

34494

</tr>

34495

34496

<td>group admin</td>

34497

<td>

34498

<center>&diams;</center>

34499

</td>

34500

<td>

34501

<center>&diams;</center>

34502

</td>

34503

<td>

34504

<center>&diams;</center>

34505

</td>

34506

<td>

34507

<center>&diams;</center>

34508

</td>

34509

<td>

34510

<center>&diams;</center>

34511

</td>

34512

<td>

34513

<center>&diams;</center>

34514

</td>

34515

<td>

34516

<center>&diams;</center>

34517

</td>

34518

</tr>

34519

34520

<td>group read</td>

34521

<td>

34522

<center>&diams;</center>

34523

</td>

34524

34525

34526

34527

34528

34529

34530

</tr>

34531

34532

<td>group write</td>

34533

<td>

34534

<center>&diams;</center>

34535

</td>

34536

34537

34538

34539

34540

34541

34542

</tr>

34543

34544

<td>postgres</td>

34545

<td>

34546

<center>&diams;</center>

34547

</td>

34548

<td>

34549

<center>&diams;</center>

34550

</td>

34551

<td>

34552

<center>&diams;</center>

34553

</td>

34554

<td>

34555

<center>&diams;</center>

34556

</td>

34557

<td>

34558

<center>&diams;</center>

34559

</td>

34560

<td>

34561

<center>&diams;</center>

34562

</td>

34563

<td>

34564

<center>&diams;</center>

34565

</td>

34566

</tr>

34567

34568

<td>sourcerer</td>

34569

<td>

34570

<center>&diams;</center>

34571

</td>

34572

34573

34574

34575

34576

34577

34578

</tr>

34579

</table>

34580

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

34581

public</a></p>

34582

<hr />

34583

<h2>View: <a href="#public.schema">public</a>.<a name=

34584

"public.view.vsourcepackagereleasepublishing" id=

34585

"public.view.vsourcepackagereleasepublishing">vsourcepackagereleasepublishing</a></h2>

34586

<p>This view simplifies a lot of queries relating to publishing and

34587

is for use as a replacement for SourcePackageRelease (I actually

34588

intend to move it to a subclass of SourcePackageRelease, because

34589

using a View in place of a real table is bizarre).</p>

34590

34591

<caption>public.vsourcepackagereleasepublishing Structure</caption>

34592

<tr>

34593

34594

34595

34596

<th>Description</th>

34597

</tr>

34598

34599

34600

34601

<td>integer</td>

34602

34603

</tr>

34604

34605

34606

34607

34608

34609

</tr>

34610

34611

34612

<td>maintainer</td>

34613

<td>integer</td>

34614

34615

</tr>

34616

34617

34618

<td>publishingstatus</td>

34619

<td>integer</td>

34620

34621

</tr>

34622

34623

34624

<td>datepublished</td>

34625

<td>timestamp without time zone</td>

34626

34627

</tr>

34628

34629

34630

<td>distrorelease</td>

34631

<td>integer</td>

34632

34633

</tr>

34634

34635

34636

<td>componentname</td>

34637

34638

34639

</tr>

34640

34641

34642

<td>architecturehintlist</td>

34643

34644

34645

</tr>

34646

34647

34648

<td>version</td>

34649

34650

34651

</tr>

34652

34653

34654

<td>creator</td>

34655

<td>integer</td>

34656

34657

</tr>

34658

34659

34660

<td>format</td>

34661

<td>integer</td>

34662

34663

</tr>

34664

34665

34666

<td>manifest</td>

34667

<td>integer</td>

34668

34669

</tr>

34670

34671

34672

<td>section</td>

34673

<td>integer</td>

34674

34675

</tr>

34676

34677

34678

<td>component</td>

34679

<td>integer</td>

34680

34681

</tr>

34682

34683

34684

<td>changelog</td>

34685

34686

34687

</tr>

34688

34689

34690

<td>builddepends</td>

34691

34692

34693

</tr>

34694

34695

34696

<td>builddependsindep</td>

34697

34698

34699

</tr>

34700

34701

34702

<td>urgency</td>

34703

<td>integer</td>

34704

34705

</tr>

34706

34707

34708

<td>dateuploaded</td>

34709

<td>timestamp without time zone</td>

34710

34711

</tr>

34712

34713

34714

34715

34716

34717

</tr>

34718

34719

34720

<td>dscsigningkey</td>

34721

<td>integer</td>

34722

34723

</tr>

34724

34725

34726

<td>uploaddistrorelease</td>

34727

<td>integer</td>

34728

34729

</tr>

34730

34731

34732

<td>sourcepackagename</td>

34733

<td>integer</td>

34734

34735

</tr>

34736

</table>

34737

34738

34739

34740

<pre>

34741

SELECT DISTINCT sourcepackagerelease.id

34742

, sourcepackagename.name

34743

, maintainership.maintainer

34744

, sourcepackagepublishing.status AS publishingstatus

34745

, sourcepackagepublishing.datepublished

34746

, sourcepackagepublishing.distrorelease

34747

, component.name AS componentname

34748

, sourcepackagerelease.architecturehintlist

34749

, sourcepackagerelease."version"

34750

, sourcepackagerelease.creator

34751

, sourcepackagerelease.format

34752

, sourcepackagerelease.manifest

34753

, sourcepackagerelease.section

34754

, sourcepackagerelease.component

34755

, sourcepackagerelease.changelog

34756

, sourcepackagerelease.builddepends

34757

, sourcepackagerelease.builddependsindep

34758

, sourcepackagerelease.urgency

34759

, sourcepackagerelease.dateuploaded

34760

, sourcepackagerelease.dsc

34761

, sourcepackagerelease.dscsigningkey

34762

, sourcepackagerelease.uploaddistrorelease

34763

, sourcepackagerelease.sourcepackagename

34764

FROM (

34765

(

34766

(

34767

(

34768

(sourcepackagepublishing

34769

JOIN sourcepackagerelease

34770

ON (

34771

(sourcepackagepublishing.sourcepackagerelease = sourcepackagerelease.id)

34772

)

34773

)

34774

JOIN sourcepackagename

34775

ON (

34776

(sourcepackagerelease.sourcepackagename = sourcepackagename.id)

34777

)

34778

)

34779

JOIN distrorelease

34780

ON (

34781

(sourcepackagepublishing.distrorelease = distrorelease.id)

34782

)

34783

)

34784

JOIN component

34785

ON (

34786

(sourcepackagepublishing.component = component.id)

34787

)

34788

)

34789

LEFT JOIN maintainership

34790

ON (

34791

(

34792

(sourcepackagerelease.sourcepackagename = maintainership.sourcepackagename)

34793

AND (distrorelease.distribution = maintainership.distribution)

34794

)

34795

)

34796

)

34797

ORDER BY sourcepackagerelease.id

34798

, sourcepackagename.name

34799

, maintainership.maintainer

34800

, sourcepackagepublishing.status

34801

, sourcepackagepublishing.datepublished

34802

, sourcepackagepublishing.distrorelease

34803

, component.name

34804

, sourcepackagerelease.architecturehintlist

34805

, sourcepackagerelease."version"

34806

, sourcepackagerelease.creator

34807

, sourcepackagerelease.format

34808

, sourcepackagerelease.manifest

34809

, sourcepackagerelease.section

34810

, sourcepackagerelease.component

34811

, sourcepackagerelease.changelog

34812

, sourcepackagerelease.builddepends

34813

, sourcepackagerelease.builddependsindep

34814

, sourcepackagerelease.urgency

34815

, sourcepackagerelease.dateuploaded

34816

, sourcepackagerelease.dsc

34817

, sourcepackagerelease.dscsigningkey

34818

, sourcepackagerelease.uploaddistrorelease

34819

, sourcepackagerelease.sourcepackagename;

34820

</pre>

34821

34822

34823

34824

<caption>Permissions which apply to

34825

public.vsourcepackagereleasepublishing</caption>

34826

<tr>

34827

34828

<th>

34829

<center>Select</center>

34830

</th>

34831

<th>

34832

<center>Insert</center>

34833

</th>

34834

<th>

34835

<center>Update</center>

34836

</th>

34837

<th>

34838

<center>Delete</center>

34839

</th>

34840

<th>

34841

<center>Reference</center>

34842

</th>

34843

<th>

34844

34845

</th>

34846

<th>

34847

<center>Trigger</center>

34848

</th>

34849

</tr>

34850

34851

<td>group admin</td>

34852

<td>

34853

<center>&diams;</center>

34854

</td>

34855

<td>

34856

<center>&diams;</center>

34857

</td>

34858

<td>

34859

<center>&diams;</center>

34860

</td>

34861

<td>

34862

<center>&diams;</center>

34863

</td>

34864

<td>

34865

<center>&diams;</center>

34866

</td>

34867

<td>

34868

<center>&diams;</center>

34869

</td>

34870

<td>

34871

<center>&diams;</center>

34872

</td>

34873

</tr>

34874

34875

<td>group read</td>

34876

<td>

34877

<center>&diams;</center>

34878

</td>

34879

34880

34881

34882

34883

34884

34885

</tr>

34886

34887

<td>group write</td>

34888

<td>

34889

<center>&diams;</center>

34890

</td>

34891

34892

34893

34894

34895

34896

34897

</tr>

34898

34899

<td>postgres</td>

34900

<td>

34901

<center>&diams;</center>

34902

</td>

34903

<td>

34904

<center>&diams;</center>

34905

</td>

34906

<td>

34907

<center>&diams;</center>

34908

</td>

34909

<td>

34910

<center>&diams;</center>

34911

</td>

34912

<td>

34913

<center>&diams;</center>

34914

</td>

34915

<td>

34916

<center>&diams;</center>

34917

</td>

34918

<td>

34919

<center>&diams;</center>

34920

</td>

34921

</tr>

34922

</table>

34923

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

34924

public</a></p>

34925

<hr />

34926

36321

<h2>Table: <a href="#public.schema">public</a>.<a name=

34927

36322

"public.table.wikiname" id=

34928

36323

"public.table.wikiname">wikiname</a></h2>

35086

36481

<center>&diams;</center>

35087

36482

</td>

35088

36483

</tr>

36484

36485

<td>uploader</td>

36486

<td>

36487

<center>&diams;</center>

36488

</td>

36489

<td>

36490

<center>&diams;</center>

36491

</td>

36492

36493

36494

36495

36496

36497

</tr>

35089

36498

</table>

35090

36499

<p><a href="#index">Index</a> - <a href="#public.schema">Schema

35091

36500

public</a></p>

35113

36522

</pre>

35114

36523

<hr />

35115

36524

<h2>Function: <a href="#public.schema">public</a>.<a name=

36525

"public.function.is-printable-ascii-text" id=

36526

"public.function.is-printable-ascii-text">is_printable_ascii( text

36527

)</a></h2>

36528

<h3>Returns: boolean</h3>

36529

<h3>Language: PLPYTHONU</h3>

36530

<p>True if the string is pure printable US-ASCII</p>

36531

<pre>

36532

import re, string

36533

try:

36534

text = args[0].decode("ASCII")

36535

except UnicodeError:

36536

return False

36537

if re.search(r"^[%s]*$" % re.escape(string.printable), text) is None:

36538

return False

36539

return True

36540

</pre>

36541

<hr />

36542

<h2>Function: <a href="#public.schema">public</a>.<a name=

35116

36543

"public.function.is-team-integer" id=

35117

36544

"public.function.is-team-integer">is_team( integer )</a></h2>

35118

36545

<h3>Returns: boolean</h3>

35133

36560

</pre>

35134

36561

<hr />

35135

36562

<h2>Function: <a href="#public.schema">public</a>.<a name=

36563

"public.function.plpgsql-validator-oid" id=

36564

"public.function.plpgsql-validator-oid">plpgsql_validator( oid

36565

)</a></h2>

36566

<h3>Returns: void</h3>

36567

<h3>Language: C</h3>

36568

<pre>

36569

plpgsql_validator

36570

</pre>

36571

<hr />

36572

<h2>Function: <a href="#public.schema">public</a>.<a name=

35136

36573

"public.function.plpython-call-handler" id=

35137

36574

"public.function.plpython-call-handler">plpython_call_handler(

35138

36575

)</a></h2>

35200

36637

<pre>

35201

36638

import re

35202

36639

name = args[0]

35203

pat = r"^(?i)[a-z0-9][a-z0-9\+\.\-\@]+$"

36640

pat = r"^(?i)[a-z0-9][a-z0-9\+\.\-\@_]+$"

35204

36641

if re.match(pat, name):

35205

36642

return 1

35206

36643

return 0

35250

36687

import re

35251

36688

m = re.search("""^(?ix)

35252

36689

([0-9]+:)?

35253

([0-9][a-z0-9+:.~-]*?)

36690

([0-9a-z][a-z0-9+:.~-]*?)

35254

36691

(-[a-z0-9+.~]+)?

35255

36692

$""", args[0])

35256

36693

if m is None:

35805

37242

query = args[0].decode('utf8').lower()

35806

37243

## plpy.debug('1 query is %s' % repr(query))

35807

37244

35808

# Convert &, |, ! and : symbols to whitespace since they have

37245

# Convert &, |, !, : and \ symbols to whitespace since they have

35809

37246

# special meaning to tsearch2

35810

query = re.sub(r"[\&\|\!\:]+", " ", query)

37247

query = re.sub(r"[\&\|\!\:\\]+", " ", query)

35811

37248

## plpy.debug('2 query is %s' % repr(query))

35812

37249

35813

37250

# Convert AND, OR and NOT to tsearch2 punctuation

35967

37404

query = args[0].decode('utf8').lower()

35968

37405

## plpy.debug('1 query is %s' % repr(query))

35969

37406

35970

# Convert &, |, ! and : symbols to whitespace since they have

37407

# Convert &, |, !, : and \ symbols to whitespace since they have

35971

37408

# special meaning to tsearch2

35972

query = re.sub(r"[\&\|\!\:]+", " ", query)

37409

query = re.sub(r"[\&\|\!\:\\]+", " ", query)

35973

37410

## plpy.debug('2 query is %s' % repr(query))

35974

37411

35975

37412

# Convert AND, OR and NOT to tsearch2 punctuation