A PG-Dump of geonode notification_noticetype table

noticetypes.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.3.15
-- Dumped by pg_dump version 9.5.1

-- Started on 2018-02-21 20:48:10 CET

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 307 (class 1259 OID 109981)
-- Name: notification_noticetype; Type: TABLE; Schema: public; Owner: geonode
--

CREATE TABLE notification_noticetype (
    id integer NOT NULL,
    label character varying(40) NOT NULL,
    display character varying(50) NOT NULL,
    description character varying(100) NOT NULL,
    "default" integer NOT NULL
);


ALTER TABLE notification_noticetype OWNER TO geonode;

--
-- TOC entry 306 (class 1259 OID 109979)
-- Name: notification_noticetype_id_seq; Type: SEQUENCE; Schema: public; Owner: geonode
--

CREATE SEQUENCE notification_noticetype_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE notification_noticetype_id_seq OWNER TO geonode;

--
-- TOC entry 2372 (class 0 OID 0)
-- Dependencies: 306
-- Name: notification_noticetype_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: geonode
--

ALTER SEQUENCE notification_noticetype_id_seq OWNED BY notification_noticetype.id;


--
-- TOC entry 2256 (class 2604 OID 109984)
-- Name: id; Type: DEFAULT; Schema: public; Owner: geonode
--

ALTER TABLE ONLY notification_noticetype ALTER COLUMN id SET DEFAULT nextval('notification_noticetype_id_seq'::regclass);


--
-- TOC entry 2367 (class 0 OID 109981)
-- Dependencies: 307
-- Data for Name: notification_noticetype; Type: TABLE DATA; Schema: public; Owner: geonode
--

COPY notification_noticetype (id, label, display, description, "default") FROM stdin;
1	user_follow	User following you	Another user has started following you	2
2	account_approve	User requested access	A new user has requested access to the site	2
3	account_active	Account activated	This account is now active and can log in the site	2
4	request_download_resourcebase	Request to download a resource	A request for downloading a resource was sent	2
5	layer_created	Layer Created	A Layer was created	2
6	layer_updated	Layer Updated	A Layer was updated	2
7	layer_deleted	Layer Deleted	A Layer was deleted	2
8	layer_comment	Comment on Layer	A layer was commented on	2
9	layer_rated	Rating for Layer	A rating was given to a layer	2
10	map_created	Map Created	A Map was created	2
11	map_updated	Map Updated	A Map was updated	2
12	map_deleted	Map Deleted	A Map was deleted	2
13	map_comment	Comment on Map	A map was commented on	2
14	map_rated	Rating for Map	A rating was given to a map	2
15	document_created	Document Created	A Document was created	2
16	document_updated	Document Updated	A Document was updated	2
17	document_deleted	Document Deleted	A Document was deleted	2
18	document_comment	Comment on Document	A Document was commented on	2
19	document_rated	Document for Map	A rating was given to a document	2
\.


--
-- TOC entry 2373 (class 0 OID 0)
-- Dependencies: 306
-- Name: notification_noticetype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: geonode
--

SELECT pg_catalog.setval('notification_noticetype_id_seq', 19, true);


--
-- TOC entry 2258 (class 2606 OID 109986)
-- Name: notification_noticetype_pkey; Type: CONSTRAINT; Schema: public; Owner: geonode
--

ALTER TABLE ONLY notification_noticetype
    ADD CONSTRAINT notification_noticetype_pkey PRIMARY KEY (id);


-- Completed on 2018-02-21 20:48:14 CET

--
-- PostgreSQL database dump complete
--