From 69fe67df43cd17c47c03f3fe750d2478c3f2b8cc Mon Sep 17 00:00:00 2001
From: Kristian Lyngstol <kristian@bohemians.org>
Date: Wed, 18 May 2016 18:37:16 +0200
Subject: Add SQL for backlog stuff too (ops)

---
 build/schema.sql | 43 +++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 43 insertions(+)

(limited to 'build/schema.sql')

diff --git a/build/schema.sql b/build/schema.sql
index 4012eb3..a323d6b 100644
--- a/build/schema.sql
+++ b/build/schema.sql
@@ -144,6 +144,42 @@ ALTER TABLE linknets_linknet_seq OWNER TO nms;
 ALTER SEQUENCE linknets_linknet_seq OWNED BY linknets.linknet;
 
 
+--
+-- Name: oplog; Type: TABLE; Schema: public; Owner: nms; Tablespace: 
+--
+
+CREATE TABLE oplog (
+    id integer NOT NULL,
+    "time" timestamp with time zone DEFAULT now(),
+    systems character varying,
+    username character varying,
+    log text
+);
+
+
+ALTER TABLE oplog OWNER TO nms;
+
+--
+-- Name: oplog_id_seq; Type: SEQUENCE; Schema: public; Owner: nms
+--
+
+CREATE SEQUENCE oplog_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE oplog_id_seq OWNER TO nms;
+
+--
+-- Name: oplog_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nms
+--
+
+ALTER SEQUENCE oplog_id_seq OWNED BY oplog.id;
+
+
 --
 -- Name: ping; Type: TABLE; Schema: public; Owner: nms; Tablespace: 
 --
@@ -354,6 +390,13 @@ ALTER TABLE ONLY config ALTER COLUMN id SET DEFAULT nextval('config_id_seq'::reg
 ALTER TABLE ONLY linknets ALTER COLUMN linknet SET DEFAULT nextval('linknets_linknet_seq'::regclass);
 
 
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: nms
+--
+
+ALTER TABLE ONLY oplog ALTER COLUMN id SET DEFAULT nextval('oplog_id_seq'::regclass);
+
+
 --
 -- Name: id; Type: DEFAULT; Schema: public; Owner: nms
 --
-- 
cgit v1.2.3

