From 69fe67df43cd17c47c03f3fe750d2478c3f2b8cc Mon Sep 17 00:00:00 2001 From: Kristian Lyngstol 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(+) 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