--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: mcompany; Type: TABLE; Schema: public; Owner: kmkale; Tablespace: 
--

CREATE TABLE mcompany (
    companyid bigint DEFAULT next_id() NOT NULL,
    companycode character varying(10) NOT NULL,
    companyname character varying(100) NOT NULL,
    companyshortname character varying(15) NOT NULL,
    sortorder smallint DEFAULT 9999 NOT NULL,
    status smallint DEFAULT 1 NOT NULL,
    version integer DEFAULT 0 NOT NULL,
    createdbyid bigint DEFAULT (-1) NOT NULL,
    createdon timestamp without time zone DEFAULT ('now'::text)::date NOT NULL,
    modifiedbyid bigint DEFAULT (-1) NOT NULL,
    modifiedon timestamp without time zone DEFAULT ('now'::text)::date NOT NULL,
    clientid bigint DEFAULT (-1) NOT NULL,
    CONSTRAINT ckmcompany_status CHECK ((status = ANY (ARRAY[0, 1, 2, 3, 4, 5])))
);


ALTER TABLE public.mcompany OWNER TO youtilitydba;

--
-- Data for Name: mcompany; Type: TABLE DATA; Schema: public; Owner: kmkale
--

COPY mcompany (companyid, companycode, companyname, companyshortname, sortorder, status, version, createdbyid, createdon, modifiedbyid, modifiedon, clientid) FROM stdin;
-1	none	none123	none	1	1	1	-1	2012-03-23 13:13:25	-1	2012-03-23 13:13:25	-1
\.

COPY mcompany (companyid, companycode, companyname, companyshortname, sortorder, status, version, createdbyid, createdon, modifiedbyid, modifiedon, clientid) FROM stdin;
1	youtility	youtility	Youtility	1	1	1	-1	2012-03-23 13:13:25	-1	2012-03-23 13:14:11	-1
\.


--
-- Name: UK_companycode_clientid; Type: CONSTRAINT; Schema: public; Owner: kmkale; Tablespace: 
--

ALTER TABLE ONLY mcompany
    ADD CONSTRAINT "UK_companycode_clientid" UNIQUE (companycode, clientid);


--
-- Name: UK_companyname_clientid; Type: CONSTRAINT; Schema: public; Owner: kmkale; Tablespace: 
--

ALTER TABLE ONLY mcompany
    ADD CONSTRAINT "UK_companyname_clientid" UNIQUE (companyname, clientid);


--
-- Name: UK_companyshortname_clientid; Type: CONSTRAINT; Schema: public; Owner: kmkale; Tablespace: 
--

ALTER TABLE ONLY mcompany
    ADD CONSTRAINT "UK_companyshortname_clientid" UNIQUE (companyshortname, clientid);


--
-- Name: pkmcompany_companyid; Type: CONSTRAINT; Schema: public; Owner: kmkale; Tablespace: 
--

ALTER TABLE ONLY mcompany
    ADD CONSTRAINT pkmcompany_companyid PRIMARY KEY (companyid);


--
-- PostgreSQL database dump complete
--