Add pgsql sandbox

1 files changed, 35 insertions, 0 deletions

diff --git a/db/db.sql b/db/db.sql
new file mode 100644
index 0000000..3f27856
--- /dev/null
+++ b/db/db.sql
@@ -0,0 +1,35 @@
+CREATE DATABASE clog;
+
+\connect clog
+
+CREATE TABLE entries (
+    id BIGINT NOT NULL, -- PRIMARY KEY UUID
+    title CHARACTER VARYING NOT NULL,
+    body CHARACTER VARYING NOT NULL
+    -- created_at TIMESTAMP NOT NULL,
+    -- updated_at TIMESTAMP NOT NULL
+);
+
+
+INSERT INTO entries (
+    id,
+    title,
+    body
+)
+VALUES
+(
+    1,
+    'foo',
+    'bar'
+),
+(
+    2,
+    'baz',
+    'zoo'
+),
+(
+    3,
+    'xxx',
+    'yyy'
+);
+