--
--

-- Started on 2014-02-15 18:57:19





--
-- TOC entry 244 (class 1259 OID 17358)
-- Name: kockazat_pszminta; Type: TABLE; Schema: public; Owner: mbt; Tablespace: 
--

CREATE TABLE kockazat_pszminta (
    kockazat_pszminta_kod serial NOT NULL,
    nev character varying(100),
    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_pszminta OWNER TO mbt;



--
-- TOC entry 2366 (class 2604 OID 17361)
-- Name: kockazat_pszminta_kod; Type: DEFAULT; Schema: public; Owner: mbt
--

ALTER TABLE ONLY kockazat_pszminta ALTER COLUMN kockazat_pszminta_kod SET DEFAULT nextval('kockazat_pszminta_kockazat_pszminta_kod_seq'::regclass);


--
-- TOC entry 2371 (class 0 OID 17358)
-- Dependencies: 244
-- Data for Name: kockazat_pszminta; Type: TABLE DATA; Schema: public; Owner: mbt
--

INSERT INTO kockazat_pszminta VALUES (1, 'Pszichoszociális elemzés (teljes)', 'admin', '2014-02-15', '18:13:34', NULL, NULL, NULL);


--
-- TOC entry 2377 (class 0 OID 0)
-- Dependencies: 243
-- Name: kockazat_pszminta_kockazat_pszminta_kod_seq; Type: SEQUENCE SET; Schema: public; Owner: mbt
--

SELECT pg_catalog.setval('kockazat_pszminta_kockazat_pszminta_kod_seq', 2, false);


--
-- TOC entry 2369 (class 2606 OID 17363)
-- Name: kockazat_pszminta_pk1; Type: CONSTRAINT; Schema: public; Owner: mbt; Tablespace: 
--

ALTER TABLE ONLY kockazat_pszminta
    ADD CONSTRAINT kockazat_pszminta_pk1 PRIMARY KEY (kockazat_pszminta_kod);


--
-- TOC entry 2367 (class 1259 OID 17364)
-- Name: kockazat_pszminta_id1; Type: INDEX; Schema: public; Owner: mbt; Tablespace: 
--

CREATE INDEX kockazat_pszminta_id1 ON kockazat_pszminta USING btree (nev);


-- Completed on 2014-02-15 18:57:19

--
--

