--
--

-- Started on 2012-04-30 21:48:15





--
-- TOC entry 288 (class 1259 OID 20043)
-- Dependencies: 5
-- Name: karbantartas_minta; Type: TABLE; Schema: public; Owner: mbt; Tablespace: 
--

CREATE TABLE karbantartas_minta (
    karbantartas_minta_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.karbantartas_minta OWNER TO mbt;

--
-- TOC entry 287 (class 1259 OID 20041)
-- Dependencies: 5 288
-- Name: karbantartas_minta_karbantartas_minta_kod_seq; Type: SEQUENCE; Schema: public; Owner: mbt
--

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


--ALTER TABLE public.karbantartas_minta_karbantartas_minta_kod_seq OWNER TO mbt;

--
-- TOC entry 2196 (class 0 OID 0)
-- Dependencies: 287
-- Name: karbantartas_minta_karbantartas_minta_kod_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mbt
--

--ALTER SEQUENCE karbantartas_minta_karbantartas_minta_kod_seq OWNED BY karbantartas_minta.karbantartas_minta_kod;


--
-- TOC entry 2197 (class 0 OID 0)
-- Dependencies: 287
-- Name: karbantartas_minta_karbantartas_minta_kod_seq; Type: SEQUENCE SET; Schema: public; Owner: mbt
--

SELECT pg_catalog.setval('karbantartas_minta_karbantartas_minta_kod_seq', 2, true);


--
-- TOC entry 2189 (class 2604 OID 20046)
-- Dependencies: 288 287 288
-- Name: karbantartas_minta_kod; Type: DEFAULT; Schema: public; Owner: mbt
--

--ALTER TABLE karbantartas_minta ALTER COLUMN karbantartas_minta_kod SET DEFAULT nextval('karbantartas_minta_karbantartas_minta_kod_seq'::regclass);


--
-- TOC entry 2193 (class 0 OID 20043)
-- Dependencies: 288
-- Data for Name: karbantartas_minta; Type: TABLE DATA; Schema: public; Owner: mbt
--

INSERT INTO karbantartas_minta VALUES (1, 'Kőtörő', 'admin', '2012-04-30', '17:00:04', 'admin', '2012-04-30', '21:46:06');


--
-- TOC entry 2192 (class 2606 OID 20048)
-- Dependencies: 288 288
-- Name: karbantartas_minta_pk1; Type: CONSTRAINT; Schema: public; Owner: mbt; Tablespace: 
--

ALTER TABLE ONLY karbantartas_minta
    ADD CONSTRAINT karbantartas_minta_pk1 PRIMARY KEY (karbantartas_minta_kod);


--
-- TOC entry 2190 (class 1259 OID 20049)
-- Dependencies: 288
-- Name: karbantartas_minta_id1; Type: INDEX; Schema: public; Owner: mbt; Tablespace: 
--

CREATE INDEX karbantartas_minta_id1 ON karbantartas_minta USING btree (nev);


-- Completed on 2012-04-30 21:48:15

--
--

