summaryrefslogtreecommitdiff
path: root/sql/tables
diff options
context:
space:
mode:
Diffstat (limited to 'sql/tables')
-rw-r--r--sql/tables/resume.contactinfo.sql4
-rw-r--r--sql/tables/resume.job_skill.sql4
-rw-r--r--sql/tables/resume.resume.sql2
-rw-r--r--sql/tables/resume.resume_contactinfo.sql4
-rw-r--r--sql/tables/resume.resume_education.sql4
-rw-r--r--sql/tables/resume.resume_job.sql4
-rw-r--r--sql/tables/resume.resume_language.sql4
7 files changed, 13 insertions, 13 deletions
diff --git a/sql/tables/resume.contactinfo.sql b/sql/tables/resume.contactinfo.sql
index 47eb1c7..9290da0 100644
--- a/sql/tables/resume.contactinfo.sql
+++ b/sql/tables/resume.contactinfo.sql
@@ -4,8 +4,8 @@ create table resume.contactinfo (
id serial8 primary key,
address character varying(255) not null,
city character varying(255) not null,
- state_id int not null references resume.states(id),
+ state_id bigint not null references resume.states(id),
phone character varying(255) not null,
email character varying(255) not null,
- visastatus_id int not null references resume.visastatus(id)
+ visastatus_id bigint not null references resume.visastatus(id)
);
diff --git a/sql/tables/resume.job_skill.sql b/sql/tables/resume.job_skill.sql
index 3b16b53..0bf003d 100644
--- a/sql/tables/resume.job_skill.sql
+++ b/sql/tables/resume.job_skill.sql
@@ -2,6 +2,6 @@ drop table resume.job_skill cascade;
create table resume.job_skill (
id serial8 primary key,
- job_id int not null references resume.job(id),
- skill_id int not null references resume.skill(id)
+ job_id bigint not null references resume.job(id),
+ skill_id bigint not null references resume.skill(id)
);
diff --git a/sql/tables/resume.resume.sql b/sql/tables/resume.resume.sql
index dd34db1..f751a28 100644
--- a/sql/tables/resume.resume.sql
+++ b/sql/tables/resume.resume.sql
@@ -2,7 +2,7 @@ drop table resume.resume cascade;
create table resume.resume (
id serial8 primary key,
- user_id int not null references auth.users(id),
+ user_id bigint not null references auth.users(id),
name character varying(255) not null,
unique (user_id, name)
);
diff --git a/sql/tables/resume.resume_contactinfo.sql b/sql/tables/resume.resume_contactinfo.sql
index a51e33c..01f2f5f 100644
--- a/sql/tables/resume.resume_contactinfo.sql
+++ b/sql/tables/resume.resume_contactinfo.sql
@@ -2,6 +2,6 @@ drop table resume.resume_contactinfo cascade;
create table resume.resume_contactinfo (
id serial8 primary key,
- resume_id int not null references resume.resume(id),
- contactinfo_id int not null references resume.contactinfo(id)
+ resume_id bigint not null references resume.resume(id),
+ contactinfo_id bigint not null references resume.contactinfo(id)
);
diff --git a/sql/tables/resume.resume_education.sql b/sql/tables/resume.resume_education.sql
index 739169d..92bf58a 100644
--- a/sql/tables/resume.resume_education.sql
+++ b/sql/tables/resume.resume_education.sql
@@ -2,6 +2,6 @@ drop table resume.resume_education cascade;
create table resume.resume_education (
id serial8 primary key,
- resume_id int not null references resume.resume(id),
- education_id int not null references resume.education(id)
+ resume_id bigint not null references resume.resume(id),
+ education_id bigint not null references resume.education(id)
);
diff --git a/sql/tables/resume.resume_job.sql b/sql/tables/resume.resume_job.sql
index 4418242..42faec6 100644
--- a/sql/tables/resume.resume_job.sql
+++ b/sql/tables/resume.resume_job.sql
@@ -2,6 +2,6 @@ drop table resume.resume_job cascade;
create table resume.resume_job (
id serial8 primary key,
- resume_id int not null references resume.resume(id),
- job_id int not null references resume.job(id)
+ resume_id bigint not null references resume.resume(id),
+ job_id bigint not null references resume.job(id)
);
diff --git a/sql/tables/resume.resume_language.sql b/sql/tables/resume.resume_language.sql
index 15a63e3..1ca5d91 100644
--- a/sql/tables/resume.resume_language.sql
+++ b/sql/tables/resume.resume_language.sql
@@ -2,6 +2,6 @@ drop table resume.resume_language cascade;
create table resume.resume_language (
id serial8 primary key,
- resume_id int not null references resume.resume(id),
- language_id int not null references resume.language(id)
+ resume_id bigint not null references resume.resume(id),
+ language_id bigint not null references resume.language(id)
);