--
-- PostgreSQL database dump
--

SET client_encoding = 'LATIN1';
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = true;

--
-- Name: user; Type: TABLE; Schema: public; Owner: root; Tablespace: 
--

CREATE TABLE "group" (
    id integer DEFAULT 0 NOT NULL,
    name character varying(128) NOT NULL,
    created timestamp without time zone NOT NULL,
    members text,
    enable boolean DEFAULT false NOT NULL
);


ALTER TABLE public."user" OWNER TO root;

--
-- PostgreSQL database dump complete
 

--
-- Name: jobs; Type: TABLE; Schema: public; Owner: root; Tablespace: 
--

CREATE TABLE jobs (
    name character varying(64) NOT NULL,
    "owner" integer NOT NULL,
    date_submitted timestamp without time zone,
    time_start timestamp without time zone,
    time_stop timestamp without time zone,
    id bigint,
    status character varying(24),
    description text,
    project_id bigint,
    job_id bigint,
    group_id bigint
);


ALTER TABLE public.jobs OWNER TO root;

#
# Dumping data for table `jobs`
#

--
-- Name: user; Type: TABLE; Schema: public; Owner: root; Tablespace: 
--

CREATE TABLE "user" (
    name character varying(32) NOT NULL,
    uid bigint,
    gid bigint,
    "password" character varying(32) NOT NULL,
    homediruri character varying(255),
    resultsdiruri character varying(255),
    emailaddress character varying(255),
    enabled boolean DEFAULT true NOT NULL,
    date_added timestamp without time zone,
    debug boolean DEFAULT false,
    "location" bigint DEFAULT 1,
    file_motion boolean DEFAULT false
);


ALTER TABLE public."user" OWNER TO root;