diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/tables/resume.contactinfo.sql | 1 | ||||
| -rw-r--r-- | sql/views/resume.contactinfo_v.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/tables/resume.contactinfo.sql b/sql/tables/resume.contactinfo.sql index 8523270..7a89fb7 100644 --- a/sql/tables/resume.contactinfo.sql +++ b/sql/tables/resume.contactinfo.sql @@ -8,5 +8,6 @@ create table resume.contactinfo ( state_id bigint not null references resume.states(id), phone character varying(255) not null, email character varying(255) not null, + url character varying(255) not null, visastatus_id bigint not null references resume.visastatus(id) ); diff --git a/sql/views/resume.contactinfo_v.sql b/sql/views/resume.contactinfo_v.sql index 4c4eb79..65f992b 100644 --- a/sql/views/resume.contactinfo_v.sql +++ b/sql/views/resume.contactinfo_v.sql @@ -10,6 +10,7 @@ select c.id, s.abbr as state_abbr, c.phone, c.email, + c.url, c.visastatus_id, v.status as visastatus from resume.contactinfo c |