--
--

-- Started on 2010-06-10 09:51:44 Közép-európai nyári idő





--
-- TOC entry 1247 (class 1259 OID 33444)
-- Dependencies: 4
-- Name: gep_csoport; Type: TABLE; Schema: public; Owner: mbt; Tablespace: 
--

CREATE TABLE gep_csoport (
    gep_csoport_kod serial NOT NULL,
    nev character varying(40),
    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.gep_csoport OWNER TO mbt;

--
-- TOC entry 1612 (class 0 OID 0)
-- Dependencies: 1246
-- Name: gep_csoport_gep_csoport_kod_seq; Type: SEQUENCE SET; Schema: public; Owner: mbt
--

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('gep_csoport', 'gep_csoport_kod'), 6, true);


--
-- TOC entry 1610 (class 0 OID 33444)
-- Dependencies: 1247
-- Data for Name: gep_csoport; Type: TABLE DATA; Schema: public; Owner: mbt
--

INSERT INTO gep_csoport (gep_csoport_kod, nev, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (6, 'Mezőgazdasági', 'admin', '2010-06-10', '9:41:10', NULL, NULL, NULL);
INSERT INTO gep_csoport (gep_csoport_kod, nev, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (1, 'Fémipar', 'admin
', '2010-06-10', '9:41:10', NULL, NULL, NULL);
INSERT INTO gep_csoport (gep_csoport_kod, nev, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (2, 'Faipar', 'admin
', '2010-06-10', '9:41:10', NULL, NULL, NULL);
INSERT INTO gep_csoport (gep_csoport_kod, nev, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (3, 'Emelőgép', 'admin
', '2010-06-10', '9:41:10', NULL, NULL, NULL);
INSERT INTO gep_csoport (gep_csoport_kod, nev, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (4, 'Hegesztő', 'admin
', '2010-06-10', '9:41:10', NULL, NULL, NULL);
INSERT INTO gep_csoport (gep_csoport_kod, nev, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (5, 'Targonca', 'admin
', '2010-06-10', '9:41:10', NULL, NULL, NULL);


--
-- TOC entry 1609 (class 2606 OID 33448)
-- Dependencies: 1247 1247
-- Name: pk_cskod; Type: CONSTRAINT; Schema: public; Owner: mbt; Tablespace: 
--

ALTER TABLE ONLY gep_csoport
    ADD CONSTRAINT gep_csoport_pk1 PRIMARY KEY (gep_csoport_kod);


-- Completed on 2010-06-10 09:51:44 Közép-európai nyári idő

--
--

