diff options
| author | ckonstanski <kostcarl@isu.edu> | 2026-07-27 20:27:17 -0600 |
|---|---|---|
| committer | ckonstanski <kostcarl@isu.edu> | 2026-07-27 20:27:17 -0600 |
| commit | 85fdf5db522a3e3e841fef4c3dd5ff3a570739ca (patch) | |
| tree | fbaa0f9060956c0d67b8fc7fef58030ef64c55b0 /sql | |
| parent | 7a902d7dec9e0ea2a35610bebac2e217340deb40 (diff) | |
stuff
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 |