initial commit

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
+);