--
--

-- Started on 2012-11-07 20:35:20





--
-- TOC entry 324 (class 1259 OID 30910)
-- Dependencies: 2277 5
-- Name: mbt_user; Type: TABLE; Schema: public; Owner: mbt; Tablespace: 
--

CREATE TABLE mbt_user (
    user_kod serial NOT NULL,
    felhasznalo character varying(20) NOT NULL,
    jelszo character varying(20) NOT NULL,
    nev character varying(80) NOT NULL,
    datum date,
    superuser boolean NOT NULL,
    partner_kod integer,
    telephely_kod integer,
    login boolean,
    u_partner boolean,
    u_dolgozo boolean,
    u_munkaeszkoz boolean,
    u_szabvany boolean,
    u_jogszabaly boolean,
    u_feor boolean,
    u_teaor boolean,
    u_alairas boolean,
    u_tulajdonos boolean,
    u_gepvizsgalat boolean,
    u_baleset boolean,
    u_kockazat boolean,
    u_import boolean,
    u_mbtimport boolean,
    u_backup boolean,
    u_vegyi boolean,
    u_csere boolean,
    u_karbantartas boolean,
    u_hulladek boolean,
    u_stempli boolean,
    stempli_nev character varying(50),
    alairas_nev character varying(50),
    alairas_beosztas character varying(40),
    o_ommfkod 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.mbt_user OWNER TO mbt;

--
-- TOC entry 323 (class 1259 OID 30908)
-- Dependencies: 324 5
-- Name: mbt_user_user_kod_seq; Type: SEQUENCE; Schema: public; Owner: mbt
--

--
-- TOC entry 2283 (class 0 OID 0)
-- Dependencies: 323
-- Name: mbt_user_user_kod_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mbt
--


--
-- TOC entry 2284 (class 0 OID 0)
-- Dependencies: 323
-- Name: mbt_user_user_kod_seq; Type: SEQUENCE SET; Schema: public; Owner: mbt
--

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


--
-- TOC entry 2276 (class 2604 OID 30913)
-- Dependencies: 324 323 324
-- Name: user_kod; Type: DEFAULT; Schema: public; Owner: mbt
--

--
-- TOC entry 2280 (class 0 OID 30910)
-- Dependencies: 324
-- Data for Name: mbt_user; Type: TABLE DATA; Schema: public; Owner: mbt
--

INSERT INTO mbt_user (user_kod, felhasznalo, jelszo, nev, datum, superuser, partner_kod, telephely_kod, login, u_partner, u_dolgozo, u_munkaeszkoz, u_szabvany, u_jogszabaly, u_feor, u_teaor, u_alairas, u_tulajdonos, u_gepvizsgalat, u_baleset, u_kockazat, u_import, u_mbtimport, u_backup, u_vegyi, u_csere, u_karbantartas, u_hulladek, u_stempli, stempli_nev, alairas_nev, alairas_beosztas, o_ommfkod, c_userid, c_date, c_time, m_userid, m_date, m_time) VALUES (1, 'admin', 'admin', 'Admin', '2012-11-07', true, 175, 1, false, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true,true, '', NULL, NULL, false, NULL, NULL, NULL, NULL, NULL, NULL);

--
-- TOC entry 2279 (class 2606 OID 30916)
-- Dependencies: 324 324
-- Name: mbt_user_pk1; Type: CONSTRAINT; Schema: public; Owner: mbt; Tablespace: 
--

ALTER TABLE ONLY mbt_user
    ADD CONSTRAINT mbt_user_pk1 PRIMARY KEY (user_kod);


-- Completed on 2012-11-07 20:35:20

--
--

