diff options
Diffstat (limited to 'lib/sql/migration/015-add-patch-tags.sql')
-rw-r--r-- | lib/sql/migration/015-add-patch-tags.sql | 19 |
1 files changed, 0 insertions, 19 deletions
diff --git a/lib/sql/migration/015-add-patch-tags.sql b/lib/sql/migration/015-add-patch-tags.sql deleted file mode 100644 index bdf7330..0000000 --- a/lib/sql/migration/015-add-patch-tags.sql +++ /dev/null @@ -1,19 +0,0 @@ -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; |