--
-- PostgreSQL database dump
--

-- Dumped from database version 9.3.1
-- Dumped by pg_dump version 9.3.0
-- Started on 2013-10-25 16:01:16

SET statement_timeout = 0;
SET lock_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;

--
-- TOC entry 215 (class 1259 OID 359233)
-- Name: job; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE job (
    jobid integer DEFAULT nextval('jobseq'::regclass) NOT NULL,
    name character varying(50) NOT NULL,
    classname character varying(50) NOT NULL,
    timeoutseconds integer,
    enabled boolean NOT NULL,
    nextrun timestamp without time zone,
    running boolean NOT NULL,
    daymask integer,
    timeofdayseconds integer,
    dayofmonth integer,
    nextrunforce boolean NOT NULL
);


ALTER TABLE public.job OWNER TO postgres;

--
-- TOC entry 3361 (class 0 OID 359233)
-- Dependencies: 215
-- Data for Name: job; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY job (jobid, name, classname, timeoutseconds, enabled, nextrun, running, daymask, timeofdayseconds, dayofmonth, nextrunforce) FROM stdin;
20	Ach Upload Checker	AchUploadCheckerJob	\N	f	2012-11-18 13:00:00	f	127	46800	\N	f
17	Theft & Lien Report Sender	NvsReportSenderJob	\N	t	2013-10-25 00:00:00	f	\N	0	1	f
3	Mail Sender	MailSenderJob	60	t	2013-10-24 19:23:30.763	f	127	\N	\N	f
12	ACH Activity Report Sender	AchActivityReportSenderJob	\N	t	2013-10-25 12:00:00	f	127	43200	\N	f
13	Support Ticket Synchronizer	SupportTicketSynchronizerJob	\N	t	2013-10-25 00:00:00	f	127	0	\N	f
14	Subscription Controller	SubscriptionControllerJob	\N	t	2013-10-25 01:00:00	f	127	3600	\N	f
19	Database Cleanup	DatabaseCleanupJob	\N	t	2013-10-25 00:30:00	f	127	1800	\N	f
2	Payment Processor	PaymentProcessorJob	300	t	2013-10-16 11:39:12.243	f	127	\N	\N	f
9	Contract Status Watcher	ContractStatusWatcherJob	3600	t	2013-10-24 20:03:46.037	f	127	\N	\N	f
18	Digital Signature Controller	DigiSignControllerJob	3600	t	2013-10-24 20:03:46.08	f	127	\N	\N	f
16	Arkona GL/Accounting Processor	ArkonaAccountingProcessorJob	3600	t	2013-10-24 20:03:46.053	f	127	\N	\N	f
2	Payment Processor	PaymentProcessorJob	300	t	2013-10-16 11:34:12.243	f	127	\N	\N	f
2	Payment Processor	PaymentProcessorJob	300	t	2013-10-16 11:39:12.243	f	127	\N	\N	f
5	Financial Activity Receiver	FinancialActivityReceiverJob	3600	t	2013-10-19 02:03:45.96	f	127	\N	\N	f
7	Payment Overdue Watcher	PaymentOverdueWatcherJob	3600	t	2013-10-19 02:03:46.007	f	127	\N	\N	f
6	Report Generator	ReportGeneratorJob	\N	t	2013-10-25 06:00:00	f	127	21600	\N	f
1	Invoice Generator	InvoiceGeneratorJob	300	t	2013-10-16 14:29:12.227	f	127	\N	\N	f
8	User Status Watcher	UserStatusWatcherJob	300	t	2013-10-16 15:14:12.267	f	127	\N	\N	f
11	ACH Processor	AchProcessorJob	300	t	2013-09-27 01:49:12.287	f	127	\N	\N	f
4	Dashboard Updater	DashboardUpdaterJob	3600	t	2013-10-19 02:03:45.947	f	127	\N	\N	f
\.


--
-- TOC entry 3251 (class 2606 OID 359238)
-- Name: pk_job; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY job
    ADD CONSTRAINT pk_job PRIMARY KEY (jobid);


-- Completed on 2013-10-25 16:01:42

--
-- PostgreSQL database dump complete
--