--
--

-- Started on 2011-02-07 08:23:11

SET escape_string_warning = off;




--
-- TOC entry 1636 (class 1259 OID 16857)
-- Dependencies: 1918 3
-- Name: kockazat_tipus; Type: TABLE; Schema: public; Owner: mbt; Tablespace: 
--

CREATE TABLE kockazat_tipus (
    kockazat_tipus_kod serial NOT NULL,
    tipusnev character varying(50) NOT NULL,
    torles boolean DEFAULT false,
    c_userid character varying(20),
    c_date date,
    c_time character varying(10),
    m_userid character varying(20),
    m_date date,
    m_time character varying(10)
);


ALTER TABLE public.kockazat_tipus OWNER TO mbt;

--
-- TOC entry 1635 (class 1259 OID 16855)
-- Dependencies: 1636 3
-- Name: kockazat_tipus_kockazat_tipus_kod_seq; Type: SEQUENCE; Schema: public; Owner: mbt
--

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

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('kockazat_tipus', 'kockazat_tipus_kod'), 13, true);

--ALTER TABLE public.kockazat_tipus_kockazat_tipus_kod_seq OWNER TO mbt;

--
-- TOC entry 1924 (class 0 OID 0)
-- Dependencies: 1635
-- Name: kockazat_tipus_kockazat_tipus_kod_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mbt
--

-- ALTER SEQUENCE kockazat_tipus_kockazat_tipus_kod_seq OWNED BY kockazat_tipus.kockazat_tipus_kod;


--
-- TOC entry 1925 (class 0 OID 0)
-- Dependencies: 1635
-- Name: kockazat_tipus_kockazat_tipus_kod_seq; Type: SEQUENCE SET; Schema: public; Owner: mbt
--

-- SELECT pg_catalog.setval('kockazat_tipus_kockazat_tipus_kod_seq', 13, true);


--
-- TOC entry 1917 (class 2604 OID 16860)
-- Dependencies: 1635 1636 1636
-- Name: kockazat_tipus_kod; Type: DEFAULT; Schema: public; Owner: mbt
--

--ALTER TABLE kockazat_tipus ALTER COLUMN kockazat_tipus_kod SET DEFAULT nextval('kockazat_tipus_kockazat_tipus_kod_seq'::regclass);


--
-- TOC entry 1921 (class 0 OID 16857)
-- Dependencies: 1636
-- Data for Name: kockazat_tipus; Type: TABLE DATA; Schema: public; Owner: mbt
--

INSERT INTO kockazat_tipus (kockazat_tipus_kod, tipusnev, torles, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (1, 'Gép', true, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO kockazat_tipus (kockazat_tipus_kod, tipusnev, torles, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (2, 'Munkaeszköz', true, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO kockazat_tipus (kockazat_tipus_kod, tipusnev, torles, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (3, 'Munkakör', true, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO kockazat_tipus (kockazat_tipus_kod, tipusnev, torles, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (4, 'Munkahely', true, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO kockazat_tipus (kockazat_tipus_kod, tipusnev, torles, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (5, 'Veszélyes kémiai anyagok', true, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO kockazat_tipus (kockazat_tipus_kod, tipusnev, torles, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (6, 'Veszélyes biológiai anyagok', true, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO kockazat_tipus (kockazat_tipus_kod, tipusnev, torles, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (7, 'Hát-, derék- és deréktáji sérülések', true, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO kockazat_tipus (kockazat_tipus_kod, tipusnev, torles, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (8, 'Technológiai folyamatok', true, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO kockazat_tipus (kockazat_tipus_kod, tipusnev, torles, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (9, 'Technológiai rendszerek', true, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO kockazat_tipus (kockazat_tipus_kod, tipusnev, torles, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (10, 'Irányítás és szervezet', true, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO kockazat_tipus (kockazat_tipus_kod, tipusnev, torles, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (11, 'Dokumentáció', true, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO kockazat_tipus (kockazat_tipus_kod, tipusnev, torles, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (12, 'Egyéni védőfelszerelés', true, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO kockazat_tipus (kockazat_tipus_kod, tipusnev, torles, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (13, 'Biztonságtechnika', true, NULL, NULL, NULL, NULL, NULL, NULL);


--
-- TOC entry 1920 (class 2606 OID 16863)
-- Dependencies: 1636 1636
-- Name: pk_ktipkod; Type: CONSTRAINT; Schema: public; Owner: mbt; Tablespace: 
--

ALTER TABLE ONLY kockazat_tipus
    ADD CONSTRAINT kockazat_tipus_pk1 PRIMARY KEY (kockazat_tipus_kod);


-- Completed on 2011-02-07 08:23:11

--
--

