2 files changed, 39 insertions, 0 deletions
diff --git a/service-person/migrations/2021-10-22-182006_create_initial_tables/down.sql b/service-person/migrations/2021-10-22-182006_create_initial_tables/down.sql
new file mode 100644
index 0000000..d57d59a
--- /dev/null
+++ b/service-person/migrations/2021-10-22-182006_create_initial_tables/down.sql
@@ -0,0 +1,5 @@
+-- This file should undo anything in `up.sql`
+DROP TABLE persons;
+DROP TABLE address;
+DROP TABLE cities;
+DROP TABLE countries;
diff --git a/service-person/migrations/2021-10-22-182006_create_initial_tables/up.sql b/service-person/migrations/2021-10-22-182006_create_initial_tables/up.sql
new file mode 100644
index 0000000..24a214f
--- /dev/null
+++ b/service-person/migrations/2021-10-22-182006_create_initial_tables/up.sql
@@ -0,0 +1,34 @@
+-- Your SQL goes here
+
+CREATE TABLE countries (
+    id SERIAL PRIMARY KEY NOT NULL,
+    name VARCHAR NOT NULL
+);
+
+CREATE TABLE cities (
+    id SERIAL PRIMARY KEY NOT NULL,
+    name VARCHAR NOT NULL
+);
+
+CREATE TABLE streets (
+    id SERIAL PRIMARY KEY NOT NULL,
+    name VARCHAR NOT NULL
+);
+
+CREATE TABLE address (
+    id SERIAL PRIMARY KEY NOT NULL,
+
+    country_id INTEGER REFERENCES countries(id) NOT NULL,
+    city_id INTEGER REFERENCES cities(id) NOT NULL,
+    street_id INTEGER REFERENCES streets(id) NOT NULL,
+
+    addr_number INTEGER NOT NULL
+);
+
+CREATE TABLE persons (
+    id SERIAL PRIMARY KEY NOT NULL,
+    name VARCHAR NOT NULL,
+    age INTEGER NOT NULL,
+
+    address_id INTEGER REFERENCES address(id) NOT NULL
+);