--
-- PostgreSQL database dump
--

-- Started on 2010-11-14 21:48:19

SET client_encoding = 'SQL_ASCII';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = "Settings", pg_catalog;

ALTER TABLE ONLY "Settings".akses_cheque DROP CONSTRAINT pk_noseri;
ALTER TABLE ONLY "Settings".print_nota DROP CONSTRAINT pk_no_fakprint;
ALTER TABLE ONLY "Settings".akses_edit_jual DROP CONSTRAINT pk_no_fak_edit;
ALTER TABLE ONLY "Settings".akses_retur_jual DROP CONSTRAINT pk_akses_no_fakrj;
ALTER TABLE ONLY "Settings".akses_koreksi_stock DROP CONSTRAINT pk_akses_no_fak_koreksi_stock;
ALTER TABLE ONLY "Settings".akses_piutang DROP CONSTRAINT pk_akses_no_fak;
DROP TABLE "Settings".setting;
DROP TABLE "Settings".print_nota;
DROP TABLE "Settings".jurnal_transaksi;
DROP TABLE "Settings".info_usaha;
DROP TABLE "Settings".akses_retur_jual;
DROP TABLE "Settings".akses_piutang;
DROP TABLE "Settings".akses_koreksi_stock;
DROP TABLE "Settings".akses_edit_jual;
DROP TABLE "Settings".akses_cheque;
DROP SCHEMA "Settings";
--
-- TOC entry 12 (class 2615 OID 3228251)
-- Name: Settings; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA "Settings";


ALTER SCHEMA "Settings" OWNER TO postgres;

--
-- TOC entry 1888 (class 0 OID 0)
-- Dependencies: 12
-- Name: SCHEMA "Settings"; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA "Settings" IS 'Untuk mencatat info usaha dan setting';


SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 1534 (class 1259 OID 3228634)
-- Dependencies: 12
-- Name: akses_cheque; Type: TABLE; Schema: Settings; Owner: henry; Tablespace: 
--

CREATE TABLE akses_cheque (
    no_seri text NOT NULL,
    info1 text,
    info2 text
);


ALTER TABLE "Settings".akses_cheque OWNER TO henry;

SET default_with_oids = true;

--
-- TOC entry 1535 (class 1259 OID 3228639)
-- Dependencies: 12
-- Name: akses_edit_jual; Type: TABLE; Schema: Settings; Owner: postgres; Tablespace: 
--

CREATE TABLE akses_edit_jual (
    no_faktur text NOT NULL,
    status_edit text,
    status_print text,
    info1 text
);


ALTER TABLE "Settings".akses_edit_jual OWNER TO postgres;

SET default_with_oids = false;

--
-- TOC entry 1536 (class 1259 OID 3228644)
-- Dependencies: 12
-- Name: akses_koreksi_stock; Type: TABLE; Schema: Settings; Owner: henry; Tablespace: 
--

CREATE TABLE akses_koreksi_stock (
    no_faktur text NOT NULL,
    info1 text,
    info2 text
);


ALTER TABLE "Settings".akses_koreksi_stock OWNER TO henry;

--
-- TOC entry 1537 (class 1259 OID 3228649)
-- Dependencies: 12
-- Name: akses_piutang; Type: TABLE; Schema: Settings; Owner: henry; Tablespace: 
--

CREATE TABLE akses_piutang (
    no_faktur text NOT NULL,
    info1 text,
    info2 text
);


ALTER TABLE "Settings".akses_piutang OWNER TO henry;

--
-- TOC entry 1538 (class 1259 OID 3228654)
-- Dependencies: 12
-- Name: akses_retur_jual; Type: TABLE; Schema: Settings; Owner: henry; Tablespace: 
--

CREATE TABLE akses_retur_jual (
    no_faktur text NOT NULL,
    info1 text,
    info2 text
);


ALTER TABLE "Settings".akses_retur_jual OWNER TO henry;

--
-- TOC entry 1539 (class 1259 OID 3228659)
-- Dependencies: 12
-- Name: info_usaha; Type: TABLE; Schema: Settings; Owner: postgres; Tablespace: 
--

CREATE TABLE info_usaha (
    nama text,
    data text
);


ALTER TABLE "Settings".info_usaha OWNER TO postgres;

SET default_with_oids = true;

--
-- TOC entry 1540 (class 1259 OID 3228664)
-- Dependencies: 12
-- Name: jurnal_transaksi; Type: TABLE; Schema: Settings; Owner: postgres; Tablespace: 
--

CREATE TABLE jurnal_transaksi (
    waktu timestamp without time zone,
    kode_transaksi text,
    data text
);


ALTER TABLE "Settings".jurnal_transaksi OWNER TO postgres;

SET default_with_oids = false;

--
-- TOC entry 1541 (class 1259 OID 3228669)
-- Dependencies: 12
-- Name: print_nota; Type: TABLE; Schema: Settings; Owner: henry; Tablespace: 
--

CREATE TABLE print_nota (
    no_faktur text NOT NULL,
    data text,
    info1 text,
    info2 text
);


ALTER TABLE "Settings".print_nota OWNER TO henry;

--
-- TOC entry 1542 (class 1259 OID 3228674)
-- Dependencies: 12
-- Name: setting; Type: TABLE; Schema: Settings; Owner: postgres; Tablespace: 
--

CREATE TABLE setting (
    nama text,
    data text
);


ALTER TABLE "Settings".setting OWNER TO postgres;

--
-- TOC entry 1881 (class 2606 OID 3228757)
-- Dependencies: 1537 1537
-- Name: pk_akses_no_fak; Type: CONSTRAINT; Schema: Settings; Owner: henry; Tablespace: 
--

ALTER TABLE ONLY akses_piutang
    ADD CONSTRAINT pk_akses_no_fak PRIMARY KEY (no_faktur);


--
-- TOC entry 1879 (class 2606 OID 3228759)
-- Dependencies: 1536 1536
-- Name: pk_akses_no_fak_koreksi_stock; Type: CONSTRAINT; Schema: Settings; Owner: henry; Tablespace: 
--

ALTER TABLE ONLY akses_koreksi_stock
    ADD CONSTRAINT pk_akses_no_fak_koreksi_stock PRIMARY KEY (no_faktur);


--
-- TOC entry 1883 (class 2606 OID 3228761)
-- Dependencies: 1538 1538
-- Name: pk_akses_no_fakrj; Type: CONSTRAINT; Schema: Settings; Owner: henry; Tablespace: 
--

ALTER TABLE ONLY akses_retur_jual
    ADD CONSTRAINT pk_akses_no_fakrj PRIMARY KEY (no_faktur);


--
-- TOC entry 1877 (class 2606 OID 3228763)
-- Dependencies: 1535 1535
-- Name: pk_no_fak_edit; Type: CONSTRAINT; Schema: Settings; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY akses_edit_jual
    ADD CONSTRAINT pk_no_fak_edit PRIMARY KEY (no_faktur);


--
-- TOC entry 1885 (class 2606 OID 3228765)
-- Dependencies: 1541 1541
-- Name: pk_no_fakprint; Type: CONSTRAINT; Schema: Settings; Owner: henry; Tablespace: 
--

ALTER TABLE ONLY print_nota
    ADD CONSTRAINT pk_no_fakprint PRIMARY KEY (no_faktur);


--
-- TOC entry 1875 (class 2606 OID 3228767)
-- Dependencies: 1534 1534
-- Name: pk_noseri; Type: CONSTRAINT; Schema: Settings; Owner: henry; Tablespace: 
--

ALTER TABLE ONLY akses_cheque
    ADD CONSTRAINT pk_noseri PRIMARY KEY (no_seri);


-- Completed on 2010-11-14 21:48:19

--
-- PostgreSQL database dump complete
--