1CREATE TABLE "build2update" (
2  "buildid" bigint NOT NULL,
3  "updateid" bigint NOT NULL,
4  PRIMARY KEY ("buildid")
5);
6CREATE INDEX "build2update_updateid" on "build2update" ("updateid");
7
8CREATE TABLE "submission2ip" (
9  "submissionid" bigint NOT NULL UNIQUE,
10  "ip" character varying(255) DEFAULT '' NOT NULL,
11  PRIMARY KEY("submissionid")
12);
13
14CREATE TABLE "measurement" (
15  "id" serial NOT NULL,
16  "projectid" bigint NOT NULL,
17  "name" character varying(40) NOT NULL,
18  "testpage" smallint NOT NULL DEFAULT '0',
19  "summarypage" smallint NOT NULL DEFAULT '0',
20  PRIMARY KEY("id")
21);
22CREATE INDEX "measurement_projectid" on "measurement" ("projectid");
23CREATE INDEX "measurement_name" on "measurement" ("name");
24
25
26CREATE TABLE "feed" (
27  "id" serial NOT NULL,
28  "projectid" bigint NOT NULL,
29  "date" timestamp(0) DEFAULT '1980-01-01 00:00:00' NOT NULL,
30  "buildid" bigint NOT NULL DEFAULT '0',
31  "type" bigint NOT NULL DEFAULT '0',
32  "description" character varying(255) NOT NULL,
33  PRIMARY KEY ("id")
34);
35CREATE INDEX "feed_projectid" on "feed" ("projectid");
36CREATE INDEX "feed_date" on "feed" ("date");