From c30c03312041c24c39b6a986882aae6189096c2f Mon Sep 17 00:00:00 2001
From: Simo Sorce <idra@samba.org>
Date: Fri, 26 Oct 2012 12:51:42 +0000
Subject: Add URL and SCM data to projects

This allows us to display friendly links to the project website,
web SCM UI and SCM URL.

For example for the patchwork project these could be set to:
web_url: http://jk.ozlabs.org/projects/patchwork/
scm_url: git://ozlabs.org/home/jk/git/patchwork
webscm_url: http://git.ozlabs.org/?p=patchwork;a=tree

Requires a DB schema upgrade

Signed-off-by: Simo Sorce <idra@samba.org>
Signed-off-by: Jeremy Kerr <jk@ozlabs.org>
---
 lib/sql/migration/012-project-add-columns.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 lib/sql/migration/012-project-add-columns.sql

(limited to '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
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;
-- 
cgit v1.2.3

