2 ALTER TABLE patchwork_project ADD COLUMN use_tags boolean default true;
4 CREATE TABLE "patchwork_tag" (
5 "id" serial NOT NULL PRIMARY KEY,
6 "name" varchar(20) NOT NULL,
7 "pattern" varchar(50) NOT NULL,
8 "abbrev" varchar(2) NOT NULL UNIQUE
11 CREATE TABLE "patchwork_patchtag" (
12 "id" serial NOT NULL PRIMARY KEY,
13 "patch_id" integer NOT NULL,
14 "tag_id" integer NOT NULL REFERENCES "patchwork_tag" ("id"),
15 "count" integer NOT NULL,
16 UNIQUE ("patch_id", "tag_id")