[Summary view] [Print] [Text view]

   1  --
   2  -- PostgreSQL database dump
   3  --
   4  
   5  SET client_encoding = 'LATIN1';
   6  SET check_function_bodies = false;
   7  SET client_min_messages = warning;
   8  
   9  --
  10  -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
  11  --
  12  
  13  COMMENT ON SCHEMA public IS 'Standard public schema';
  14  
  15  
  16  SET search_path = public, pg_catalog;
  17  
  18  SET default_tablespace = '';
  19  
  20  SET default_with_oids = true;
  21  
  22  --
  23  -- Name: groups; Type: TABLE; Schema: public; Owner: limph; Tablespace: 
  24  --
  25  
  26  CREATE TABLE groups (
  27      number smallint DEFAULT 0 NOT NULL,
  28      name character varying(30) NOT NULL,
  29      col smallint DEFAULT 0 NOT NULL,
  30      priority smallint DEFAULT 0 NOT NULL,
  31      collapse character varying(1) DEFAULT 0 NOT NULL
  32  );
  33  
  34  
  35  ALTER TABLE public.groups OWNER TO limph;
  36  
  37  --
  38  -- Name: history; Type: TABLE; Schema: public; Owner: limph; Tablespace: 
  39  --
  40  
  41  CREATE TABLE history (
  42      number integer DEFAULT 0 NOT NULL,
  43      hostname character varying(40) DEFAULT 0 NOT NULL,
  44      host integer DEFAULT 0 NOT NULL,
  45      "type" character varying(4) DEFAULT 'Up'::character varying NOT NULL,
  46      datetime timestamp without time zone NOT NULL
  47  );
  48  
  49  
  50  ALTER TABLE public.history OWNER TO limph;
  51  
  52  --
  53  -- Name: hosts; Type: TABLE; Schema: public; Owner: limph; Tablespace: 
  54  --
  55  
  56  CREATE TABLE hosts (
  57      number integer DEFAULT 0 NOT NULL,
  58      name character varying(40) NOT NULL,
  59      ip inet NOT NULL,
  60      hostgroup smallint DEFAULT 0 NOT NULL,
  61      status smallint DEFAULT 1 NOT NULL,
  62      enabled smallint DEFAULT 1 NOT NULL,
  63      timeout smallint DEFAULT 1 NOT NULL,
  64      "type" character varying(3) DEFAULT 'udp'::character varying NOT NULL,
  65      port smallint DEFAULT 0 NOT NULL,
  66      parent integer DEFAULT 0 NOT NULL,
  67      visible smallint DEFAULT 1 NOT NULL
  68  );
  69  
  70  
  71  ALTER TABLE public.hosts OWNER TO limph;
  72  
  73  --
  74  -- Name: layout; Type: TABLE; Schema: public; Owner: limph; Tablespace: 
  75  --
  76  
  77  CREATE TABLE layout (
  78      number smallint DEFAULT 0 NOT NULL,
  79      width smallint DEFAULT 0 NOT NULL
  80  );
  81  
  82  
  83  ALTER TABLE public.layout OWNER TO limph;
  84  
  85  SET default_with_oids = false;
  86  
  87  --
  88  -- Name: state; Type: TABLE; Schema: public; Owner: limph; Tablespace: 
  89  --
  90  
  91  CREATE TABLE state (
  92      number integer NOT NULL,
  93      hostname character varying NOT NULL,
  94      "type" character varying NOT NULL,
  95      data character varying NOT NULL,
  96      datetime timestamp without time zone NOT NULL,
  97      disk character varying NOT NULL
  98  );
  99  
 100  
 101  ALTER TABLE public.state OWNER TO limph;
 102  
 103  --
 104  -- Name: thresholds; Type: TABLE; Schema: public; Owner: limph; Tablespace: 
 105  --
 106  
 107  CREATE TABLE thresholds (
 108      number integer NOT NULL,
 109      hostname character varying NOT NULL,
 110      value character varying NOT NULL,
 111      "type" character varying NOT NULL,
 112      disk character varying NOT NULL
 113  );
 114  
 115  
 116  ALTER TABLE public.thresholds OWNER TO limph;
 117  
 118  SET default_with_oids = true;
 119  
 120  --
 121  -- Name: universal; Type: TABLE; Schema: public; Owner: limph; Tablespace: 
 122  --
 123  
 124  CREATE TABLE universal (
 125      "notify" character varying(1) DEFAULT 0 NOT NULL,
 126      address character varying(40) NOT NULL,
 127      version character varying(5) NOT NULL,
 128      "year" character varying(5) NOT NULL,
 129      autoupdateip character varying(1) DEFAULT 0 NOT NULL,
 130      textsize character varying(8) DEFAULT 'small'::character varying NOT NULL,
 131      tabletextsize character varying(8) DEFAULT 'x-small'::character varying NOT NULL
 132  );
 133  
 134  
 135  ALTER TABLE public.universal OWNER TO limph;
 136  
 137  --
 138  -- Name: users; Type: TABLE; Schema: public; Owner: limph; Tablespace: 
 139  --
 140  
 141  CREATE TABLE users (
 142      number integer DEFAULT 0 NOT NULL,
 143      id character varying(10) NOT NULL,
 144      pass character varying(30) NOT NULL,
 145      email character varying(40) NOT NULL,
 146      "admin" smallint DEFAULT 0 NOT NULL,
 147      "notify" smallint DEFAULT 1 NOT NULL,
 148      digest smallint DEFAULT 1 NOT NULL
 149  );
 150  
 151  
 152  ALTER TABLE public.users OWNER TO limph;
 153  
 154  --
 155  -- Data for Name: groups; Type: TABLE DATA; Schema: public; Owner: limph
 156  --
 157  
 158  COPY groups (number, name, col, priority, collapse) FROM stdin;
 159  \.
 160  
 161  
 162  --
 163  -- Data for Name: history; Type: TABLE DATA; Schema: public; Owner: limph
 164  --
 165  
 166  COPY history (number, hostname, host, "type", datetime) FROM stdin;
 167  \.
 168  
 169  
 170  --
 171  -- Data for Name: hosts; Type: TABLE DATA; Schema: public; Owner: limph
 172  --
 173  
 174  COPY hosts (number, name, ip, hostgroup, status, enabled, timeout, "type", port, parent, visible) FROM stdin;
 175  \.
 176  
 177  
 178  --
 179  -- Data for Name: layout; Type: TABLE DATA; Schema: public; Owner: limph
 180  --
 181  
 182  COPY layout (number, width) FROM stdin;
 183  1    5
 184  2    5
 185  3    5
 186  \.
 187  
 188  
 189  --
 190  -- Data for Name: state; Type: TABLE DATA; Schema: public; Owner: limph
 191  --
 192  
 193  COPY state (number, hostname, "type", data, datetime, disk) FROM stdin;
 194  \.
 195  
 196  
 197  --
 198  -- Data for Name: thresholds; Type: TABLE DATA; Schema: public; Owner: limph
 199  --
 200  
 201  COPY thresholds (number, hostname, value, "type", disk) FROM stdin;
 202  \.
 203  
 204  
 205  --
 206  -- Data for Name: universal; Type: TABLE DATA; Schema: public; Owner: limph
 207  --
 208  
 209  COPY universal ("notify", address, version, "year", autoupdateip, textsize, tabletextsize) FROM stdin;
 210  1    yourgroup@yourorg.org    1.9.1    2006    0    small    x-small
 211  \.
 212  
 213  
 214  --
 215  -- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: limph
 216  --
 217  
 218  COPY users (number, id, pass, email, "admin", "notify", digest) FROM stdin;
 219  1    admin    adpexzg3FUZAk    you@yourorg.tld    1    1    1
 220  \.
 221  
 222  
 223  --
 224  -- Name: groups.number; Type: CONSTRAINT; Schema: public; Owner: limph; Tablespace: 
 225  --
 226  
 227  ALTER TABLE ONLY groups
 228      ADD CONSTRAINT "groups.number" PRIMARY KEY (number);
 229  
 230  
 231  --
 232  -- Name: history.number; Type: CONSTRAINT; Schema: public; Owner: limph; Tablespace: 
 233  --
 234  
 235  ALTER TABLE ONLY history
 236      ADD CONSTRAINT "history.number" PRIMARY KEY (number);
 237  
 238  
 239  --
 240  -- Name: hosts.number; Type: CONSTRAINT; Schema: public; Owner: limph; Tablespace: 
 241  --
 242  
 243  ALTER TABLE ONLY hosts
 244      ADD CONSTRAINT "hosts.number" PRIMARY KEY (number);
 245  
 246  
 247  --
 248  -- Name: layout.number; Type: CONSTRAINT; Schema: public; Owner: limph; Tablespace: 
 249  --
 250  
 251  ALTER TABLE ONLY layout
 252      ADD CONSTRAINT "layout.number" PRIMARY KEY (number);
 253  
 254  
 255  --
 256  -- Name: state.number; Type: CONSTRAINT; Schema: public; Owner: limph; Tablespace: 
 257  --
 258  
 259  ALTER TABLE ONLY state
 260      ADD CONSTRAINT "state.number" PRIMARY KEY (number);
 261  
 262  
 263  --
 264  -- Name: thresholds.number; Type: CONSTRAINT; Schema: public; Owner: limph; Tablespace: 
 265  --
 266  
 267  ALTER TABLE ONLY thresholds
 268      ADD CONSTRAINT "thresholds.number" PRIMARY KEY (number);
 269  
 270  
 271  --
 272  -- Name: users.number; Type: CONSTRAINT; Schema: public; Owner: limph; Tablespace: 
 273  --
 274  
 275  ALTER TABLE ONLY users
 276      ADD CONSTRAINT "users.number" PRIMARY KEY (number);
 277  
 278  
 279  --
 280  -- Name: public; Type: ACL; Schema: -; Owner: postgres
 281  --
 282  
 283  REVOKE ALL ON SCHEMA public FROM PUBLIC;
 284  REVOKE ALL ON SCHEMA public FROM postgres;
 285  GRANT ALL ON SCHEMA public TO postgres;
 286  GRANT ALL ON SCHEMA public TO PUBLIC;
 287  
 288  
 289  --
 290  -- PostgreSQL database dump complete
 291  --
 292