From 40441e01b6e73a0a1d7f06377b3607f151aed65b Mon Sep 17 00:00:00 2001
From: Michael McVady <femtonaut@gmail.com>
Date: Thu, 23 Sep 2021 00:22:10 -0500
Subject: Add pgsql sandbox

---
 db/db.sql | 35 +++++++++++++++++++++++++++++++++++
 1 file changed, 35 insertions(+)
 create mode 100644 db/db.sql

(limited to 'db/db.sql')

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'
+);
+
-- 
cgit v1.2.3

