diff options
Diffstat (limited to 'sql/tables')
27 files changed, 217 insertions, 0 deletions
diff --git a/sql/tables/auth.registrations.sql b/sql/tables/auth.registrations.sql new file mode 100644 index 0000000..91eb3a1 --- /dev/null +++ b/sql/tables/auth.registrations.sql @@ -0,0 +1,11 @@ +drop table auth.registrations cascade; + +create table auth.registrations ( + id serial8 primary key, + hash bytea not null, + first_name character varying(255) not null, + last_name character varying(255) not null, + email character varying(255) not null, + role_groups text, + created timestamp without time zone not null default now() +); diff --git a/sql/tables/auth.role_groups.sql b/sql/tables/auth.role_groups.sql new file mode 100644 index 0000000..8b6d225 --- /dev/null +++ b/sql/tables/auth.role_groups.sql @@ -0,0 +1,7 @@ +drop table auth.role_groups cascade; + +create table auth.role_groups ( + id serial8 primary key, + name character varying(255) not null, + description character varying(255) +); diff --git a/sql/tables/auth.role_groups_roles.sql b/sql/tables/auth.role_groups_roles.sql new file mode 100644 index 0000000..7ebab21 --- /dev/null +++ b/sql/tables/auth.role_groups_roles.sql @@ -0,0 +1,7 @@ +drop table auth.role_groups_roles cascade; + +create table auth.role_groups_roles ( + id serial8 primary key, + role_group_id bigint not null references auth.role_groups(id), + role_id bigint not null references auth.roles(id) +); diff --git a/sql/tables/auth.roles.sql b/sql/tables/auth.roles.sql new file mode 100644 index 0000000..f5873fe --- /dev/null +++ b/sql/tables/auth.roles.sql @@ -0,0 +1,7 @@ +drop table auth.roles cascade; + +create table auth.roles ( + id serial8 primary key, + name character varying(255) not null, + description character varying(255) +); diff --git a/sql/tables/auth.user_session_objects.sql b/sql/tables/auth.user_session_objects.sql new file mode 100644 index 0000000..aedfb42 --- /dev/null +++ b/sql/tables/auth.user_session_objects.sql @@ -0,0 +1,8 @@ +drop table auth.user_session_objects cascade; + +create table auth.user_session_objects ( + id serial8 primary key, + user_session_id bigint not null references auth.user_sessions(id), + session_key character varying(255), + serialization text +); diff --git a/sql/tables/auth.user_sessions.sql b/sql/tables/auth.user_sessions.sql new file mode 100644 index 0000000..2629d62 --- /dev/null +++ b/sql/tables/auth.user_sessions.sql @@ -0,0 +1,7 @@ +drop table auth.user_sessions cascade; + +create table auth.user_sessions ( + id serial8 primary key, + sessionid character varying(255) not null, + datetime bigint not null +); diff --git a/sql/tables/auth.users.sql b/sql/tables/auth.users.sql new file mode 100644 index 0000000..8eecf76 --- /dev/null +++ b/sql/tables/auth.users.sql @@ -0,0 +1,13 @@ +drop table auth.users cascade; + +create table auth.users ( + id serial8 primary key, + username character varying(255) not null, + pwd bytea, + first_name character varying(255) not null, + last_name character varying(255) not null, + email character varying(255) not null, + phone character varying(255), + active bool, + created timestamp without time zone not null default now() +); diff --git a/sql/tables/auth.users_role_groups.sql b/sql/tables/auth.users_role_groups.sql new file mode 100644 index 0000000..44cfe4a --- /dev/null +++ b/sql/tables/auth.users_role_groups.sql @@ -0,0 +1,7 @@ +drop table auth.users_role_groups cascade; + +create table auth.users_role_groups ( + id serial8 primary key, + user_id bigint not null references auth.users(id), + role_group_id bigint not null references auth.role_groups(id) +); diff --git a/sql/tables/auth.users_roles_append.sql b/sql/tables/auth.users_roles_append.sql new file mode 100644 index 0000000..f6603e6 --- /dev/null +++ b/sql/tables/auth.users_roles_append.sql @@ -0,0 +1,7 @@ +drop table auth.users_roles_append cascade; + +create table auth.users_roles_append ( + id serial8 primary key, + user_id bigint not null references auth.users(id), + role_id bigint not null references auth.roles(id) +); diff --git a/sql/tables/auth.users_roles_exclude.sql b/sql/tables/auth.users_roles_exclude.sql new file mode 100644 index 0000000..e47385e --- /dev/null +++ b/sql/tables/auth.users_roles_exclude.sql @@ -0,0 +1,7 @@ +drop table auth.users_roles_exclude cascade; + +create table auth.users_roles_exclude ( + id serial8 primary key, + user_id bigint not null references auth.users(id), + role_id bigint not null references auth.roles(id) +); diff --git a/sql/tables/contact.contact_us.sql b/sql/tables/contact.contact_us.sql new file mode 100644 index 0000000..0957e3c --- /dev/null +++ b/sql/tables/contact.contact_us.sql @@ -0,0 +1,6 @@ +drop table contact.contact_us cascade; + +create table contact.contact_us ( + id serial8 primary key, + content text +); diff --git a/sql/tables/contact.contact_us_posts.sql b/sql/tables/contact.contact_us_posts.sql new file mode 100644 index 0000000..5e208cb --- /dev/null +++ b/sql/tables/contact.contact_us_posts.sql @@ -0,0 +1,11 @@ +drop table contact.contact_us_posts cascade; + +create table contact.contact_us_posts ( + id serial8 primary key, + first_name character varying(255) not null, + last_name character varying(255) not null, + email character varying(255) not null, + phone character varying(255), + submitted timestamp without time zone not null default now(), + comments text +); diff --git a/sql/tables/contact.contact_us_posts_read.sql b/sql/tables/contact.contact_us_posts_read.sql new file mode 100644 index 0000000..80be27c --- /dev/null +++ b/sql/tables/contact.contact_us_posts_read.sql @@ -0,0 +1,7 @@ +drop table contact.contact_us_posts_read cascade; + +create table contact.contact_us_posts_read ( + id serial8 primary key, + contact_us_post_id bigint not null references contact.contact_us_posts(id), + user_id bigint not null references auth.users(id) +); diff --git a/sql/tables/general.about_us.sql b/sql/tables/general.about_us.sql new file mode 100644 index 0000000..b199daf --- /dev/null +++ b/sql/tables/general.about_us.sql @@ -0,0 +1,7 @@ +drop table general.about_us cascade; + +create table general.about_us ( + id serial8 primary key, + category character varying(255), + content text +); diff --git a/sql/tables/resume.contactinfo.sql b/sql/tables/resume.contactinfo.sql new file mode 100644 index 0000000..85bcd2c --- /dev/null +++ b/sql/tables/resume.contactinfo.sql @@ -0,0 +1,11 @@ +drop table resume.contactinfo cascade; + +create table resume.contactinfo ( + id serial8 primary key, + address character varying(255) not null, + city character varying(255) not null, + state int 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) +); diff --git a/sql/tables/resume.education.sql b/sql/tables/resume.education.sql new file mode 100644 index 0000000..638a50c --- /dev/null +++ b/sql/tables/resume.education.sql @@ -0,0 +1,12 @@ +drop table resume.education cascade; + +create table resume.education ( + id serial8 primary key, + school character varying(255) not null, + start_date timestamp without time zone not null default now(), + end_date timestamp without time zone not null default now(), + major character varying(255) not null, + minor character varying(255) not null, + degree character varying(255) not null, + progress character varying(255) not null +); diff --git a/sql/tables/resume.job.sql b/sql/tables/resume.job.sql new file mode 100644 index 0000000..6e1dc3d --- /dev/null +++ b/sql/tables/resume.job.sql @@ -0,0 +1,10 @@ +drop table resume.job cascade; + +create table resume.job ( + id serial8 primary key, + company character varying(255) not null, + location character varying(255) not null, + start_date timestamp without time zone not null default now(), + end_date timestamp without time zone not null default now(), + overview text +); diff --git a/sql/tables/resume.job_skill.sql b/sql/tables/resume.job_skill.sql new file mode 100644 index 0000000..3b16b53 --- /dev/null +++ b/sql/tables/resume.job_skill.sql @@ -0,0 +1,7 @@ +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) +); diff --git a/sql/tables/resume.language.sql b/sql/tables/resume.language.sql new file mode 100644 index 0000000..0f5c452 --- /dev/null +++ b/sql/tables/resume.language.sql @@ -0,0 +1,11 @@ +drop table resume.language cascade; + +create table resume.language ( + id serial8 primary key, + name character varying(255) not null, + understanding_listening character varying(2) not null, + understanding_reading character varying(2) not null, + speaking_interaction character varying(2) not null, + speaking_production character varying(2) not null, + writing character varying(2) not null +); diff --git a/sql/tables/resume.resume.sql b/sql/tables/resume.resume.sql new file mode 100644 index 0000000..2d3c8bf --- /dev/null +++ b/sql/tables/resume.resume.sql @@ -0,0 +1,7 @@ +drop table resume.resume cascade; + +create table resume.resume ( + id serial8 primary key, + user_id int not null references auth.users(id), + name character varying(255) not null +); diff --git a/sql/tables/resume.resume_contactinfo.sql b/sql/tables/resume.resume_contactinfo.sql new file mode 100644 index 0000000..a51e33c --- /dev/null +++ b/sql/tables/resume.resume_contactinfo.sql @@ -0,0 +1,7 @@ +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) +); diff --git a/sql/tables/resume.resume_education.sql b/sql/tables/resume.resume_education.sql new file mode 100644 index 0000000..739169d --- /dev/null +++ b/sql/tables/resume.resume_education.sql @@ -0,0 +1,7 @@ +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) +); diff --git a/sql/tables/resume.resume_job.sql b/sql/tables/resume.resume_job.sql new file mode 100644 index 0000000..4418242 --- /dev/null +++ b/sql/tables/resume.resume_job.sql @@ -0,0 +1,7 @@ +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) +); diff --git a/sql/tables/resume.resume_language.sql b/sql/tables/resume.resume_language.sql new file mode 100644 index 0000000..15a63e3 --- /dev/null +++ b/sql/tables/resume.resume_language.sql @@ -0,0 +1,7 @@ +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) +); diff --git a/sql/tables/resume.skill.sql b/sql/tables/resume.skill.sql new file mode 100644 index 0000000..5085cf1 --- /dev/null +++ b/sql/tables/resume.skill.sql @@ -0,0 +1,6 @@ +drop table resume.skill cascade; + +create table resume.skill ( + id serial8 primary key, + skill text not null +); diff --git a/sql/tables/resume.states.sql b/sql/tables/resume.states.sql new file mode 100644 index 0000000..b52cb57 --- /dev/null +++ b/sql/tables/resume.states.sql @@ -0,0 +1,7 @@ +drop table resume.states cascade; + +create table resume.states ( + id serial8 primary key, + state character varying(255) not null, + abbr character varying(2) not null +); diff --git a/sql/tables/resume.visastatus.sql b/sql/tables/resume.visastatus.sql new file mode 100644 index 0000000..5008972 --- /dev/null +++ b/sql/tables/resume.visastatus.sql @@ -0,0 +1,6 @@ +drop table resume.visastatus cascade; + +create table resume.visastatus ( + id serial8 primary key, + status character varying(255) not null +); |