diff options
| author | Simo Sorce <idra@samba.org> | 2012-10-26 12:51:42 +0000 |
|---|---|---|
| committer | Jeremy Kerr <jk@ozlabs.org> | 2012-11-15 14:35:59 +0800 |
| commit | c30c03312041c24c39b6a986882aae6189096c2f (patch) | |
| tree | a8259779a17e29bd3e132fb2f3b51aaa7dbcefc0 /lib/sql/migration/012-project-add-columns.sql | |
| parent | 2894c4aeec566cb678a331f44f3d981c09c7d90c (diff) | |
| download | patchwork-c30c03312041c24c39b6a986882aae6189096c2f.tar patchwork-c30c03312041c24c39b6a986882aae6189096c2f.tar.gz | |
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>
Diffstat (limited to 'lib/sql/migration/012-project-add-columns.sql')
| -rw-r--r-- | lib/sql/migration/012-project-add-columns.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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; |