From 9f0a5c274edf77946cdb9a6c56051e2dbe87beab Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Tue, 5 Jun 2018 16:22:12 +0100
Subject: [PATCH] lib/postgres/link.sql

---
 lib/postgres/link.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 lib/postgres/link.sql

diff --git a/lib/postgres/link.sql b/lib/postgres/link.sql
new file mode 100644
index 00000000..0feeafd1
--- /dev/null
+++ b/lib/postgres/link.sql
@@ -0,0 +1,10 @@
+DROP TABLE IF EXISTS link;
+CREATE TABLE IF NOT EXISTS link (
+  link VARCHAR(500) PRIMARY KEY,
+  title VARCHAR(250) NOT NULL,
+  laius VARCHAR(250) NOT NULL,
+  created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+  enable BOOLEAN DEFAULT 'f'
+);
+
+CREATE INDEX IF NOT EXISTS link_created ON link USING btree (created);
-- 
2.47.3