Add URL and SCM data to projects

[patchwork] / lib / sql / migration / 012-project-add-columns.sql

diff --git a/lib/sql/migration/012-project-add-columns.sql b/lib/sql/migration/012-project-add-columns.sql
new file mode 100644 (file)
index 0000000..d984ad2
--- /dev/null
+++ b/lib/sql/migration/012-project-add-columns.sql
@@ -0,0 +1,5 @@
+BEGIN;
+ALTER TABLE "patchwork_project" ADD COLUMN "web_url" varchar(2000);
+ALTER TABLE "patchwork_project" ADD COLUMN "scm_url" varchar(2000);
+ALTER TABLE "patchwork_project" ADD COLUMN "webscm_url" varchar(2000);
+COMMIT;