From 85fdf5db522a3e3e841fef4c3dd5ff3a570739ca Mon Sep 17 00:00:00 2001 From: ckonstanski Date: Mon, 27 Jul 2026 20:27:17 -0600 Subject: stuff --- sql/tables/resume.contactinfo.sql | 1 + sql/views/resume.contactinfo_v.sql | 1 + 2 files changed, 2 insertions(+) (limited to 'sql') 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 -- cgit v1.3