blob: bdf733053940d1e2279e121ac1dbd43e8d7fb575 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
BEGIN;
ALTER TABLE patchwork_project ADD COLUMN use_tags boolean default true;
CREATE TABLE "patchwork_tag" (
"id" serial NOT NULL PRIMARY KEY,
"name" varchar(20) NOT NULL,
"pattern" varchar(50) NOT NULL,
"abbrev" varchar(2) NOT NULL UNIQUE
);
CREATE TABLE "patchwork_patchtag" (
"id" serial NOT NULL PRIMARY KEY,
"patch_id" integer NOT NULL,
"tag_id" integer NOT NULL REFERENCES "patchwork_tag" ("id"),
"count" integer NOT NULL,
UNIQUE ("patch_id", "tag_id")
);
COMMIT;
|