Inventory.dump

--
-- 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;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: auth_group; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE auth_group (
    id integer NOT NULL,
    name character varying(80) NOT NULL
);


ALTER TABLE public.auth_group OWNER TO postgres;

--
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE auth_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_group_id_seq OWNER TO postgres;

--
-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE auth_group_id_seq OWNED BY auth_group.id;


--
-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE auth_group_permissions (
    id integer NOT NULL,
    group_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_group_permissions OWNER TO postgres;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE auth_group_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_group_permissions_id_seq OWNER TO postgres;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE auth_group_permissions_id_seq OWNED BY auth_group_permissions.id;


--
-- Name: auth_permission; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE auth_permission (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    content_type_id integer NOT NULL,
    codename character varying(100) NOT NULL
);


ALTER TABLE public.auth_permission OWNER TO postgres;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE auth_permission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_permission_id_seq OWNER TO postgres;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE auth_permission_id_seq OWNED BY auth_permission.id;


--
-- Name: auth_user; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE auth_user (
    id integer NOT NULL,
    password character varying(128) NOT NULL,
    last_login timestamp with time zone NOT NULL,
    is_superuser boolean NOT NULL,
    username character varying(30) NOT NULL,
    first_name character varying(30) NOT NULL,
    last_name character varying(30) NOT NULL,
    email character varying(75) NOT NULL,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    date_joined timestamp with time zone NOT NULL
);


ALTER TABLE public.auth_user OWNER TO postgres;

--
-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE auth_user_groups (
    id integer NOT NULL,
    user_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.auth_user_groups OWNER TO postgres;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE auth_user_groups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_user_groups_id_seq OWNER TO postgres;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE auth_user_groups_id_seq OWNED BY auth_user_groups.id;


--
-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE auth_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_user_id_seq OWNER TO postgres;

--
-- Name: auth_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE auth_user_id_seq OWNED BY auth_user.id;


--
-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE auth_user_user_permissions (
    id integer NOT NULL,
    user_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_user_user_permissions OWNER TO postgres;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE auth_user_user_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_user_user_permissions_id_seq OWNER TO postgres;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE auth_user_user_permissions_id_seq OWNED BY auth_user_user_permissions.id;


--
-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE django_admin_log (
    id integer NOT NULL,
    action_time timestamp with time zone NOT NULL,
    user_id integer NOT NULL,
    content_type_id integer,
    object_id text,
    object_repr character varying(200) NOT NULL,
    action_flag smallint NOT NULL,
    change_message text NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE public.django_admin_log OWNER TO postgres;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE django_admin_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.django_admin_log_id_seq OWNER TO postgres;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE django_admin_log_id_seq OWNED BY django_admin_log.id;


--
-- Name: django_content_type; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE django_content_type (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    app_label character varying(100) NOT NULL,
    model character varying(100) NOT NULL
);


ALTER TABLE public.django_content_type OWNER TO postgres;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE django_content_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.django_content_type_id_seq OWNER TO postgres;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE django_content_type_id_seq OWNED BY django_content_type.id;


--
-- Name: django_session; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE django_session (
    session_key character varying(40) NOT NULL,
    session_data text NOT NULL,
    expire_date timestamp with time zone NOT NULL
);


ALTER TABLE public.django_session OWNER TO postgres;

--
-- Name: sales_record_sale; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE sales_record_sale (
    id integer NOT NULL,
    product character varying(50) NOT NULL,
    "time" timestamp with time zone NOT NULL
);


ALTER TABLE public.sales_record_sale OWNER TO postgres;

--
-- Name: sales_record_sale_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE sales_record_sale_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sales_record_sale_id_seq OWNER TO postgres;

--
-- Name: sales_record_sale_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE sales_record_sale_id_seq OWNED BY sales_record_sale.id;


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_group ALTER COLUMN id SET DEFAULT nextval('auth_group_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('auth_group_permissions_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_permission ALTER COLUMN id SET DEFAULT nextval('auth_permission_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user ALTER COLUMN id SET DEFAULT nextval('auth_user_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_groups ALTER COLUMN id SET DEFAULT nextval('auth_user_groups_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('auth_user_user_permissions_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY django_admin_log ALTER COLUMN id SET DEFAULT nextval('django_admin_log_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY django_content_type ALTER COLUMN id SET DEFAULT nextval('django_content_type_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY sales_record_sale ALTER COLUMN id SET DEFAULT nextval('sales_record_sale_id_seq'::regclass);


--
-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY auth_group (id, name) FROM stdin;
\.


--
-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('auth_group_id_seq', 1, false);


--
-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY auth_group_permissions (id, group_id, permission_id) FROM stdin;
\.


--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('auth_group_permissions_id_seq', 1, false);


--
-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY auth_permission (id, name, content_type_id, codename) FROM stdin;
1	Can add log entry	1	add_logentry
2	Can change log entry	1	change_logentry
3	Can delete log entry	1	delete_logentry
4	Can add permission	2	add_permission
5	Can change permission	2	change_permission
6	Can delete permission	2	delete_permission
7	Can add group	3	add_group
8	Can change group	3	change_group
9	Can delete group	3	delete_group
10	Can add user	4	add_user
11	Can change user	4	change_user
12	Can delete user	4	delete_user
13	Can add content type	5	add_contenttype
14	Can change content type	5	change_contenttype
15	Can delete content type	5	delete_contenttype
16	Can add session	6	add_session
17	Can change session	6	change_session
18	Can delete session	6	delete_session
19	Can add sale	7	add_sale
20	Can change sale	7	change_sale
21	Can delete sale	7	delete_sale
\.


--
-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('auth_permission_id_seq', 21, true);


--
-- Data for Name: auth_user; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) FROM stdin;
1	pbkdf2_sha256$12000$1GMI0WLMn4LV$Q1Ug0MFW+IXYJtfUJLZSXjg2m+ODDmPvzWtcgnxwNUI=	2014-07-04 04:28:16.557614+00	t	pi			blawson@princeton.edu	t	t	2014-07-04 04:28:16.557614+00
\.


--
-- Data for Name: auth_user_groups; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY auth_user_groups (id, user_id, group_id) FROM stdin;
\.


--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('auth_user_groups_id_seq', 1, false);


--
-- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('auth_user_id_seq', 1, true);


--
-- Data for Name: auth_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY auth_user_user_permissions (id, user_id, permission_id) FROM stdin;
\.


--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('auth_user_user_permissions_id_seq', 1, false);


--
-- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY django_admin_log (id, action_time, user_id, content_type_id, object_id, object_repr, action_flag, change_message) FROM stdin;
\.


--
-- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('django_admin_log_id_seq', 1, false);


--
-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY django_content_type (id, name, app_label, model) FROM stdin;
1	log entry	admin	logentry
2	permission	auth	permission
3	group	auth	group
4	user	auth	user
5	content type	contenttypes	contenttype
6	session	sessions	session
7	sale	sales_record	sale
\.


--
-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('django_content_type_id_seq', 7, true);


--
-- Data for Name: django_session; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY django_session (session_key, session_data, expire_date) FROM stdin;
\.


--
-- Data for Name: sales_record_sale; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sales_record_sale (id, product, "time") FROM stdin;
239	water	2014-07-04 07:52:54.033151+00
240	water	2014-07-04 07:52:54.033151+00
241	water	2014-07-04 07:52:54.033151+00
242	water	2014-07-04 07:52:54.033151+00
243	water	2014-07-04 08:03:52.197708+00
244	water	2014-07-04 08:03:52.197708+00
245	water	2014-07-04 08:03:52.197708+00
246	water	2014-07-04 08:03:52.197708+00
247	water	2014-07-04 08:06:02.636489+00
248	water	2014-07-04 08:06:22.692691+00
249	water	2014-07-04 08:06:22.692691+00
250	water	2014-07-04 08:06:39.491932+00
251	water	2014-07-04 08:06:39.491932+00
252	water	2014-07-04 08:06:39.491932+00
253	water	2014-07-04 08:06:39.491932+00
254	water	2014-07-04 08:06:39.491932+00
255	water	2014-07-04 08:06:39.491932+00
256	water	2014-07-04 08:06:39.491932+00
257	water	2014-07-04 08:06:39.491932+00
258	water	2014-07-04 08:06:39.491932+00
259	water	2014-07-04 08:06:40.122742+00
260	water	2014-07-04 08:06:40.122742+00
261	water	2014-07-04 08:06:40.122742+00
262	water	2014-07-04 08:06:40.122742+00
263	water	2014-07-04 08:08:16.302698+00
264	water	2014-07-04 08:09:20.225157+00
265	water	2014-07-04 08:09:20.225157+00
266	water	2014-07-04 08:09:34.022675+00
267	water	2014-07-04 08:09:34.022675+00
268	water	2014-07-04 08:09:41.522727+00
269	water	2014-07-04 08:09:41.522727+00
270	water	2014-07-04 08:10:16.85269+00
271	water	2014-07-04 08:10:44.171449+00
272	water	2014-07-04 08:10:53.250102+00
273	water	2014-07-04 08:10:55.309683+00
274	water	2014-07-04 08:11:08.411418+00
275	water	2014-07-04 08:11:21.302688+00
276	water	2014-07-04 08:12:46.429343+00
277	water	2014-07-04 08:12:52.031559+00
278	water	2014-07-04 08:13:09.69646+00
279	water	2014-07-04 08:13:20.792702+00
280	water	2014-07-04 08:13:20.792702+00
281	water	2014-07-04 08:13:27.082678+00
282	water	2014-07-04 08:13:29.270189+00
283	water	2014-07-04 08:13:50.372701+00
284	water	2014-07-04 08:13:51.120254+00
285	water	2014-07-04 08:14:14.142687+00
286	water	2014-07-04 08:15:08.682761+00
287	water	2014-07-04 08:15:28.638757+00
288	water	2014-07-04 08:15:57.800719+00
289	water	2014-07-04 08:15:57.800719+00
290	water	2014-07-04 08:17:02.032543+00
291	water	2014-07-04 08:18:11.521622+00
292	water	2014-07-04 08:18:11.521622+00
293	water	2014-07-04 08:18:11.521622+00
294	water	2014-07-04 08:18:11.521622+00
295	water	2014-07-04 08:18:37.16269+00
296	water	2014-07-04 08:20:03.60268+00
297	water	2014-07-04 08:22:10.282086+00
298	water	2014-07-04 08:22:10.282086+00
299	water	2014-07-04 08:26:59.900084+00
300	water	2014-07-04 08:26:59.900084+00
301	water	2014-07-04 08:26:59.900084+00
302	water	2014-07-04 08:27:45.260077+00
303	water	2014-07-04 08:27:45.260077+00
304	water	2014-07-04 08:29:11.107638+00
305	water	2014-07-04 08:29:31.260219+00
306	water	2014-07-04 08:30:14.360712+00
307	water	2014-07-04 08:30:34.992767+00
308	water	2014-07-04 08:31:03.641737+00
309	water	2014-07-04 08:31:20.087911+00
310	water	2014-07-04 08:31:43.102698+00
311	water	2014-07-04 08:31:46.526881+00
312	water	2014-07-04 08:31:46.526881+00
313	water	2014-07-04 08:32:00.69146+00
314	water	2014-07-04 08:32:37.174063+00
315	water	2014-07-04 08:32:37.174063+00
316	water	2014-07-04 08:34:45.748527+00
317	water	2014-07-04 08:36:06.117758+00
318	water	2014-07-04 08:37:00.702686+00
319	water	2014-07-04 08:37:13.762689+00
320	water	2014-07-04 08:37:21.202672+00
321	water	2014-07-04 08:38:43.980005+00
322	water	2014-07-04 08:38:45.922802+00
323	water	2014-07-04 08:40:02.756961+00
324	water	2014-07-04 08:40:02.756961+00
325	water	2014-07-04 08:40:42.840787+00
326	water	2014-07-04 08:42:00.977481+00
327	water	2014-07-04 08:42:00.977481+00
328	water	2014-07-04 08:43:15.776317+00
329	water	2014-07-04 08:43:21.252696+00
330	water	2014-07-04 08:43:58.022701+00
331	water	2014-07-04 08:44:28.520059+00
332	water	2014-07-04 08:44:32.042691+00
333	water	2014-07-04 08:47:05.262693+00
334	water	2014-07-04 08:47:07.170042+00
335	water	2014-07-04 08:47:08.240856+00
336	water	2014-07-04 08:47:08.240856+00
337	water	2014-07-04 08:49:09.851912+00
338	water	2014-07-04 08:49:16.852692+00
339	water	2014-07-04 08:49:33.552732+00
340	water	2014-07-04 08:49:34.842693+00
341	water	2014-07-04 08:50:58.222697+00
342	water	2014-07-04 08:54:19.227369+00
343	water	2014-07-04 08:55:00.452691+00
344	water	2014-07-04 08:55:00.452691+00
345	water	2014-07-04 08:55:51.38136+00
346	water	2014-07-04 08:58:06.982699+00
347	water	2014-07-04 08:58:07.792796+00
348	water	2014-07-04 08:58:09.59141+00
349	water	2014-07-04 08:58:09.59141+00
350	water	2014-07-04 08:58:14.300926+00
351	water	2014-07-04 08:58:15.051367+00
352	water	2014-07-04 08:58:18.492696+00
353	water	2014-07-04 08:58:18.492696+00
354	water	2014-07-04 08:58:21.832695+00
355	water	2014-07-04 08:58:32.282707+00
356	water	2014-07-04 08:58:32.282707+00
357	water	2014-07-04 08:58:32.282707+00
358	water	2014-07-04 09:00:24.249159+00
359	water	2014-07-04 09:00:36.152698+00
360	water	2014-07-04 09:01:05.538902+00
361	water	2014-07-04 09:02:26.07854+00
362	water	2014-07-04 09:02:26.07854+00
363	water	2014-07-04 09:05:07.282702+00
364	water	2014-07-04 09:06:03.142718+00
365	water	2014-07-04 09:06:03.142718+00
366	water	2014-07-04 09:06:06.692697+00
367	water	2014-07-04 09:06:06.692697+00
368	water	2014-07-04 09:06:44.179408+00
369	water	2014-07-04 09:06:45.292712+00
370	water	2014-07-04 09:08:43.731042+00
371	water	2014-07-04 09:08:57.100603+00
372	water	2014-07-04 09:10:50.040912+00
373	water	2014-07-04 09:11:00.592695+00
374	water	2014-07-04 09:11:38.68705+00
375	water	2014-07-04 09:12:52.36274+00
376	water	2014-07-04 09:12:59.157842+00
377	water	2014-07-04 09:13:15.551009+00
378	water	2014-07-04 09:13:30.792523+00
379	water	2014-07-04 09:13:33.452699+00
380	water	2014-07-04 09:13:33.452699+00
381	water	2014-07-04 09:14:03.699385+00
382	water	2014-07-04 09:14:18.207315+00
383	water	2014-07-04 09:14:38.767599+00
384	water	2014-07-04 09:14:41.488855+00
385	water	2014-07-04 09:15:27.442729+00
386	water	2014-07-04 09:15:29.952709+00
387	water	2014-07-04 09:15:40.64762+00
388	water	2014-07-04 09:15:40.64762+00
389	water	2014-07-04 09:15:50.206929+00
390	water	2014-07-04 09:15:54.391514+00
391	water	2014-07-04 09:16:21.911277+00
392	water	2014-07-04 09:16:34.867375+00
393	water	2014-07-04 09:16:38.2827+00
394	water	2014-07-04 09:17:02.310898+00
395	water	2014-07-04 09:17:23.701699+00
396	water	2014-07-04 09:17:42.607026+00
397	water	2014-07-04 09:17:59.632699+00
398	water	2014-07-04 09:19:08.099968+00
399	water	2014-07-04 09:19:45.452724+00
400	water	2014-07-04 09:19:45.452724+00
401	water	2014-07-04 09:19:58.4927+00
402	water	2014-07-04 09:20:10.321967+00
403	water	2014-07-04 09:20:18.702688+00
404	water	2014-07-04 09:20:33.938666+00
405	water	2014-07-04 09:20:45.152684+00
406	water	2014-07-04 09:20:52.212737+00
407	water	2014-07-04 09:21:11.082693+00
408	water	2014-07-04 09:21:36.281545+00
409	water	2014-07-04 09:22:04.28275+00
410	water	2014-07-04 09:22:17.452677+00
411	water	2014-07-04 09:22:31.702696+00
412	water	2014-07-04 09:22:52.689297+00
413	water	2014-07-04 09:23:03.027951+00
414	water	2014-07-04 09:23:12.730283+00
415	water	2014-07-04 09:23:12.730283+00
416	water	2014-07-04 09:23:12.730283+00
417	water	2014-07-04 09:23:12.730283+00
418	water	2014-07-04 09:23:23.608491+00
419	water	2014-07-04 09:23:23.608491+00
420	water	2014-07-04 09:23:23.608491+00
421	water	2014-07-04 09:23:25.122498+00
422	water	2014-07-04 09:23:26.375223+00
423	water	2014-07-04 09:23:32.142699+00
424	water	2014-07-04 09:23:43.04254+00
425	water	2014-07-04 09:23:50.44269+00
426	water	2014-07-04 09:23:56.446289+00
427	water	2014-07-04 09:24:11.187999+00
428	water	2014-07-04 09:24:26.498946+00
429	water	2014-07-04 09:24:26.498946+00
430	water	2014-07-04 09:24:26.498946+00
431	water	2014-07-04 09:24:26.498946+00
432	water	2014-07-04 09:24:52.749523+00
433	water	2014-07-04 09:25:33.937209+00
434	water	2014-07-04 09:25:58.932741+00
435	water	2014-07-04 09:25:58.932741+00
436	water	2014-07-04 09:25:58.932741+00
437	water	2014-07-04 09:25:58.932741+00
438	water	2014-07-04 09:26:25.972707+00
439	water	2014-07-04 09:26:25.972707+00
440	water	2014-07-04 09:26:42.541842+00
441	water	2014-07-04 09:27:46.086741+00
442	water	2014-07-04 09:28:28.471559+00
443	water	2014-07-04 09:28:30.506655+00
444	water	2014-07-04 09:28:36.97738+00
445	water	2014-07-04 09:28:55.682683+00
446	water	2014-07-04 09:29:11.212699+00
447	water	2014-07-04 09:29:17.591078+00
448	water	2014-07-04 09:29:17.591078+00
449	water	2014-07-04 09:29:19.331934+00
450	water	2014-07-04 09:29:19.331934+00
451	water	2014-07-04 09:29:28.602768+00
452	water	2014-07-04 09:30:02.962702+00
453	water	2014-07-04 09:30:06.909267+00
454	water	2014-07-04 09:30:10.262703+00
455	water	2014-07-04 09:30:16.220492+00
456	water	2014-07-04 09:30:16.220492+00
457	water	2014-07-04 09:30:32.582673+00
458	water	2014-07-04 09:30:56.299403+00
459	water	2014-07-04 09:30:56.299403+00
460	water	2014-07-04 09:31:32.6902+00
461	water	2014-07-04 09:32:01.602823+00
462	water	2014-07-04 09:32:10.690347+00
463	water	2014-07-04 09:32:43.822228+00
464	water	2014-07-04 09:32:55.190603+00
465	water	2014-07-04 09:33:04.712681+00
466	water	2014-07-04 09:33:20.028614+00
467	water	2014-07-04 09:34:12.91102+00
468	water	2014-07-04 09:34:18.618229+00
469	water	2014-07-04 09:34:18.618229+00
470	water	2014-07-04 09:34:38.368353+00
471	water	2014-07-04 09:34:44.642545+00
472	water	2014-07-04 09:34:50.046664+00
473	water	2014-07-04 09:34:50.046664+00
474	water	2014-07-04 09:35:01.099601+00
475	water	2014-07-04 09:35:08.980892+00
476	water	2014-07-04 09:35:09.7327+00
477	water	2014-07-04 09:35:09.7327+00
478	water	2014-07-04 09:35:15.300265+00
479	water	2014-07-04 09:35:15.300265+00
480	water	2014-07-04 09:35:36.822675+00
481	water	2014-07-04 09:35:36.822675+00
482	water	2014-07-04 09:36:17.746216+00
483	water	2014-07-04 09:36:18.862689+00
484	water	2014-07-04 09:36:44.132691+00
485	water	2014-07-04 09:36:55.646761+00
486	water	2014-07-04 09:37:04.092698+00
487	water	2014-07-04 09:37:11.227743+00
488	water	2014-07-04 09:37:11.227743+00
489	water	2014-07-04 09:37:15.3027+00
490	water	2014-07-04 09:38:11.612765+00
491	water	2014-07-04 09:38:11.612765+00
492	water	2014-07-04 09:38:13.141824+00
493	water	2014-07-04 09:39:08.669157+00
494	water	2014-07-04 09:39:14.299902+00
495	water	2014-07-04 09:39:25.898818+00
496	water	2014-07-04 09:39:48.628843+00
497	water	2014-07-04 09:40:00.282689+00
498	water	2014-07-04 09:40:27.936269+00
499	water	2014-07-04 09:40:43.199106+00
500	water	2014-07-04 09:40:59.928151+00
501	water	2014-07-04 09:41:27.423808+00
502	water	2014-07-04 09:41:28.898388+00
503	water	2014-07-04 09:41:59.017333+00
504	water	2014-07-04 09:42:04.542741+00
505	water	2014-07-04 09:42:53.251196+00
506	water	2014-07-04 09:43:29.680149+00
507	water	2014-07-04 09:43:35.36269+00
508	water	2014-07-04 09:44:28.82269+00
509	water	2014-07-04 09:44:34.701494+00
510	water	2014-07-04 09:47:23.970827+00
511	water	2014-07-04 09:47:23.970827+00
512	water	2014-07-04 09:47:26.092714+00
513	water	2014-07-04 09:47:26.092714+00
514	water	2014-07-04 09:48:40.312817+00
515	water	2014-07-04 09:48:41.459811+00
516	water	2014-07-04 09:48:47.288457+00
517	water	2014-07-04 09:48:55.342691+00
518	water	2014-07-04 09:49:06.552737+00
519	water	2014-07-04 09:49:20.019452+00
520	water	2014-07-04 09:49:33.140332+00
521	water	2014-07-04 09:50:08.539615+00
522	water	2014-07-04 09:50:40.999728+00
523	water	2014-07-04 09:50:40.999728+00
524	water	2014-07-04 09:50:42.5927+00
525	water	2014-07-04 09:50:42.5927+00
526	water	2014-07-04 09:50:50.942685+00
527	water	2014-07-04 09:50:59.868795+00
528	water	2014-07-04 09:50:59.868795+00
529	water	2014-07-04 09:51:17.652767+00
530	water	2014-07-04 09:51:26.532706+00
531	water	2014-07-04 09:51:37.336709+00
532	water	2014-07-04 09:51:43.661204+00
533	water	2014-07-04 09:51:46.446415+00
534	water	2014-07-04 09:51:54.982707+00
535	water	2014-07-04 09:51:59.662222+00
536	water	2014-07-04 09:52:50.381049+00
537	water	2014-07-04 09:52:50.381049+00
538	water	2014-07-04 09:54:49.132697+00
539	water	2014-07-04 09:54:49.132697+00
540	water	2014-07-04 09:54:49.132697+00
541	water	2014-07-04 09:54:49.132697+00
542	water	2014-07-04 09:55:13.682695+00
543	water	2014-07-04 09:55:36.351999+00
544	water	2014-07-04 09:55:36.351999+00
545	water	2014-07-04 09:55:37.180426+00
546	water	2014-07-04 09:55:37.180426+00
547	water	2014-07-04 09:55:37.180426+00
548	water	2014-07-04 09:55:39.769784+00
549	water	2014-07-04 09:56:27.738256+00
550	water	2014-07-04 09:56:27.738256+00
551	water	2014-07-04 09:56:27.738256+00
552	water	2014-07-04 09:56:27.738256+00
553	water	2014-07-04 09:56:37.606391+00
554	water	2014-07-04 09:57:07.210096+00
555	water	2014-07-04 09:57:29.887753+00
556	water	2014-07-04 09:57:29.887753+00
557	water	2014-07-04 09:57:37.988177+00
558	water	2014-07-04 09:57:37.988177+00
559	water	2014-07-04 09:57:37.988177+00
560	water	2014-07-04 09:58:46.751013+00
561	water	2014-07-04 09:58:47.602719+00
562	water	2014-07-04 09:58:47.602719+00
563	water	2014-07-04 09:58:48.708056+00
564	water	2014-07-04 09:58:48.708056+00
565	water	2014-07-04 09:58:50.972701+00
566	water	2014-07-04 09:58:51.832682+00
567	water	2014-07-04 09:58:51.832682+00
568	water	2014-07-04 09:58:51.832682+00
569	water	2014-07-04 09:59:09.766752+00
570	water	2014-07-04 09:59:11.592783+00
571	water	2014-07-04 09:59:12.998883+00
572	water	2014-07-04 09:59:42.192691+00
573	water	2014-07-04 09:59:47.522695+00
574	water	2014-07-04 10:00:10.282754+00
575	water	2014-07-04 10:00:18.268879+00
576	water	2014-07-04 10:00:24.346844+00
577	water	2014-07-04 10:00:28.018658+00
578	water	2014-07-04 10:00:35.826828+00
579	water	2014-07-04 10:01:00.641766+00
580	water	2014-07-04 10:01:02.597693+00
581	water	2014-07-04 10:01:02.597693+00
582	water	2014-07-04 10:01:14.330352+00
583	water	2014-07-04 10:01:14.330352+00
584	water	2014-07-04 10:01:20.181025+00
585	water	2014-07-04 10:01:20.181025+00
586	water	2014-07-04 10:01:20.181025+00
587	water	2014-07-04 10:01:20.181025+00
588	water	2014-07-04 10:01:20.181025+00
589	water	2014-07-04 10:01:20.181025+00
590	water	2014-07-04 10:01:25.997173+00
591	water	2014-07-04 10:01:25.997173+00
592	water	2014-07-04 10:01:25.997173+00
593	water	2014-07-04 10:02:35.060487+00
594	water	2014-07-04 10:02:35.060487+00
595	water	2014-07-04 10:02:39.671919+00
596	water	2014-07-04 10:02:39.671919+00
597	water	2014-07-04 10:02:39.671919+00
598	water	2014-07-04 10:02:43.411706+00
599	water	2014-07-04 10:03:01.862715+00
600	water	2014-07-04 10:03:08.152792+00
601	water	2014-07-04 10:03:11.269501+00
602	water	2014-07-04 10:03:18.37249+00
603	water	2014-07-04 10:03:43.990283+00
604	water	2014-07-04 10:03:55.059343+00
605	water	2014-07-04 10:04:04.792698+00
606	water	2014-07-04 10:04:34.231367+00
607	water	2014-07-04 10:04:34.231367+00
608	water	2014-07-04 10:04:37.621127+00
609	water	2014-07-04 10:04:38.939184+00
610	water	2014-07-04 10:04:45.7605+00
611	water	2014-07-04 10:04:45.7605+00
612	water	2014-07-04 10:04:53.632686+00
613	water	2014-07-04 10:04:55.388916+00
614	water	2014-07-04 10:04:55.388916+00
615	water	2014-07-04 10:05:02.802079+00
616	water	2014-07-04 10:05:31.189047+00
617	water	2014-07-04 10:05:45.74269+00
618	water	2014-07-04 10:05:57.322681+00
619	water	2014-07-04 10:06:01.758639+00
620	water	2014-07-04 10:06:08.690027+00
621	water	2014-07-04 10:06:19.96662+00
622	water	2014-07-04 10:06:38.502678+00
623	water	2014-07-04 10:07:04.642684+00
624	water	2014-07-04 10:07:04.642684+00
625	water	2014-07-04 10:07:18.262673+00
626	water	2014-07-04 10:07:51.391097+00
627	water	2014-07-04 10:07:51.391097+00
628	water	2014-07-04 10:08:17.29927+00
629	water	2014-07-04 10:08:17.29927+00
630	water	2014-07-04 10:08:17.29927+00
631	water	2014-07-04 10:08:48.872745+00
632	water	2014-07-04 10:08:48.872745+00
633	water	2014-07-04 10:08:48.872745+00
634	water	2014-07-04 10:08:53.662573+00
635	water	2014-07-04 10:08:55.187126+00
636	water	2014-07-04 10:08:55.187126+00
637	water	2014-07-04 10:09:02.822488+00
638	water	2014-07-04 10:09:30.202013+00
639	water	2014-07-04 10:09:46.202704+00
640	water	2014-07-04 10:09:57.062713+00
641	water	2014-07-04 10:10:02.372696+00
642	water	2014-07-04 10:10:13.352691+00
643	water	2014-07-04 10:10:13.917431+00
644	water	2014-07-04 10:10:27.052713+00
645	water	2014-07-04 10:10:28.652698+00
646	water	2014-07-04 10:10:36.251621+00
647	water	2014-07-04 10:10:54.2173+00
648	water	2014-07-04 10:11:04.559626+00
649	water	2014-07-04 10:11:28.462698+00
650	water	2014-07-04 10:11:41.876793+00
651	water	2014-07-04 10:12:12.052693+00
652	water	2014-07-04 10:12:12.052693+00
653	water	2014-07-04 10:12:18.559869+00
654	water	2014-07-04 10:12:23.191435+00
655	water	2014-07-04 10:12:23.191435+00
656	water	2014-07-04 10:12:23.763609+00
657	water	2014-07-04 10:12:34.65785+00
658	water	2014-07-04 10:13:32.232119+00
659	water	2014-07-04 10:13:39.742691+00
660	water	2014-07-04 10:13:39.742691+00
661	water	2014-07-04 10:13:39.742691+00
662	water	2014-07-04 10:13:41.582697+00
663	water	2014-07-04 10:13:51.008877+00
664	water	2014-07-04 10:14:05.290499+00
665	water	2014-07-04 10:14:22.031299+00
666	water	2014-07-04 10:14:53.268883+00
667	water	2014-07-04 10:15:02.772725+00
668	water	2014-07-04 10:15:02.772725+00
669	water	2014-07-04 10:15:15.152696+00
670	water	2014-07-04 10:15:15.152696+00
671	water	2014-07-04 10:15:15.152696+00
672	water	2014-07-04 10:15:17.132688+00
673	water	2014-07-04 10:15:43.559427+00
674	water	2014-07-04 10:15:50.339156+00
675	water	2014-07-04 10:15:58.152695+00
676	water	2014-07-04 10:16:15.470564+00
677	water	2014-07-04 10:16:25.072695+00
678	water	2014-07-04 10:16:25.072695+00
679	water	2014-07-04 10:16:25.072695+00
680	water	2014-07-04 10:16:25.072695+00
681	water	2014-07-04 10:16:25.072695+00
682	water	2014-07-04 10:16:25.072695+00
683	water	2014-07-04 10:16:31.318465+00
684	water	2014-07-04 10:16:31.318465+00
685	water	2014-07-04 10:16:31.318465+00
686	water	2014-07-04 10:16:31.318465+00
687	water	2014-07-04 10:16:31.318465+00
688	water	2014-07-04 10:16:31.318465+00
689	water	2014-07-04 10:17:03.011671+00
690	water	2014-07-04 10:17:06.742688+00
691	water	2014-07-04 10:17:06.742688+00
692	water	2014-07-04 10:17:08.1918+00
693	water	2014-07-04 10:17:08.1918+00
694	water	2014-07-04 10:17:20.717878+00
695	water	2014-07-04 10:17:22.552701+00
696	water	2014-07-04 10:17:29.389876+00
697	water	2014-07-04 10:17:43.150706+00
698	water	2014-07-04 10:17:43.150706+00
699	water	2014-07-04 10:17:47.251793+00
700	water	2014-07-04 10:17:47.251793+00
701	water	2014-07-04 10:17:47.251793+00
702	water	2014-07-04 10:17:56.832693+00
703	water	2014-07-04 10:17:56.832693+00
704	water	2014-07-04 10:18:00.392678+00
705	water	2014-07-04 10:18:03.397316+00
706	water	2014-07-04 10:18:06.051541+00
707	water	2014-07-04 10:18:12.417195+00
708	water	2014-07-04 10:18:23.160949+00
709	water	2014-07-04 10:18:30.580412+00
710	water	2014-07-04 10:18:32.767937+00
711	water	2014-07-04 10:18:41.801341+00
712	water	2014-07-04 10:18:41.801341+00
713	water	2014-07-04 10:18:44.957765+00
714	water	2014-07-04 10:18:44.957765+00
715	water	2014-07-04 10:18:54.398719+00
716	water	2014-07-04 10:18:54.398719+00
717	water	2014-07-04 10:18:57.451685+00
718	water	2014-07-04 10:18:57.451685+00
719	water	2014-07-04 10:19:20.782705+00
720	water	2014-07-04 10:19:31.532816+00
721	water	2014-07-04 10:19:37.141706+00
722	water	2014-07-04 10:19:37.84268+00
723	water	2014-07-04 10:19:37.84268+00
724	water	2014-07-04 10:19:51.988446+00
725	water	2014-07-04 10:19:53.512691+00
726	water	2014-07-04 10:20:12.870681+00
727	water	2014-07-04 10:20:23.441524+00
728	water	2014-07-04 10:20:23.441524+00
729	water	2014-07-04 10:20:34.017516+00
730	water	2014-07-04 10:20:38.737715+00
731	water	2014-07-04 10:20:54.022678+00
732	water	2014-07-04 10:20:57.359538+00
733	water	2014-07-04 10:20:57.359538+00
734	water	2014-07-04 10:21:00.811131+00
735	water	2014-07-04 10:21:07.702499+00
736	water	2014-07-04 10:21:07.702499+00
737	water	2014-07-04 10:21:22.370084+00
738	water	2014-07-04 10:21:34.2627+00
739	water	2014-07-04 10:21:41.232423+00
740	water	2014-07-04 10:21:53.702693+00
741	water	2014-07-04 10:22:04.350122+00
742	water	2014-07-04 10:22:15.099272+00
743	water	2014-07-04 10:22:15.099272+00
744	water	2014-07-04 10:22:26.172699+00
745	water	2014-07-04 10:22:26.562774+00
746	water	2014-07-04 10:22:26.562774+00
747	water	2014-07-04 10:22:27.28034+00
748	water	2014-07-04 10:22:49.53276+00
749	water	2014-07-04 10:22:50.859699+00
750	water	2014-07-04 10:22:50.859699+00
751	water	2014-07-04 10:22:53.682682+00
752	water	2014-07-04 10:23:16.10689+00
753	water	2014-07-04 10:23:37.972701+00
754	water	2014-07-04 10:23:39.092721+00
755	water	2014-07-04 10:23:42.572707+00
756	water	2014-07-04 10:23:42.572707+00
757	water	2014-07-04 10:23:42.572707+00
758	water	2014-07-04 10:23:42.572707+00
759	water	2014-07-04 10:23:44.242721+00
760	water	2014-07-04 10:23:44.242721+00
761	water	2014-07-04 10:24:01.662116+00
762	water	2014-07-04 10:24:06.04704+00
763	water	2014-07-04 10:24:12.039415+00
764	water	2014-07-04 10:24:12.039415+00
765	water	2014-07-04 10:24:33.852687+00
766	water	2014-07-04 10:24:40.586514+00
767	water	2014-07-04 10:24:40.586514+00
768	water	2014-07-04 10:24:52.242709+00
769	water	2014-07-04 10:24:52.242709+00
770	water	2014-07-04 10:24:55.182674+00
771	water	2014-07-04 10:24:59.628323+00
772	water	2014-07-04 10:24:59.628323+00
773	water	2014-07-04 10:25:03.432686+00
774	water	2014-07-04 10:25:26.990264+00
775	water	2014-07-04 10:25:26.990264+00
776	water	2014-07-04 10:25:32.772696+00
777	water	2014-07-04 10:25:32.772696+00
778	water	2014-07-04 10:26:01.972849+00
779	water	2014-07-04 10:26:01.972849+00
780	water	2014-07-04 10:26:01.972849+00
781	water	2014-07-04 10:26:24.272693+00
782	water	2014-07-04 10:26:32.349574+00
783	water	2014-07-04 10:26:41.992699+00
784	water	2014-07-04 10:26:41.992699+00
785	water	2014-07-04 10:26:43.962719+00
786	water	2014-07-04 10:27:04.602815+00
787	water	2014-07-04 10:27:04.602815+00
788	water	2014-07-04 10:27:06.402792+00
789	water	2014-07-04 10:27:10.559377+00
790	water	2014-07-04 10:27:13.5527+00
791	water	2014-07-04 10:27:20.458648+00
792	water	2014-07-04 10:27:26.132802+00
793	water	2014-07-04 10:27:45.742784+00
794	water	2014-07-04 10:28:10.072694+00
795	water	2014-07-04 10:28:10.072694+00
796	water	2014-07-04 10:28:23.655394+00
797	water	2014-07-04 10:28:23.655394+00
798	water	2014-07-04 10:28:41.210534+00
799	water	2014-07-04 10:28:41.210534+00
800	water	2014-07-04 10:28:45.278401+00
801	water	2014-07-04 10:28:52.840661+00
802	water	2014-07-04 10:29:17.458638+00
803	water	2014-07-04 10:29:19.852732+00
804	water	2014-07-04 10:29:33.671766+00
805	water	2014-07-04 10:29:34.908187+00
806	water	2014-07-04 10:29:46.140908+00
807	water	2014-07-04 10:29:51.912695+00
808	water	2014-07-04 10:30:00.042099+00
809	water	2014-07-04 10:30:00.042099+00
810	water	2014-07-04 10:30:06.785866+00
811	water	2014-07-04 10:30:06.785866+00
812	water	2014-07-04 10:30:11.952678+00
813	water	2014-07-04 10:30:11.952678+00
814	water	2014-07-04 10:30:29.772816+00
815	water	2014-07-04 10:30:31.422682+00
816	water	2014-07-04 10:30:35.882503+00
817	water	2014-07-04 10:30:40.082699+00
818	water	2014-07-04 10:30:58.112681+00
819	water	2014-07-04 10:30:59.069141+00
820	water	2014-07-04 10:31:08.306135+00
821	water	2014-07-04 10:31:15.622707+00
822	water	2014-07-04 10:31:15.622707+00
823	water	2014-07-04 10:31:15.622707+00
824	water	2014-07-04 10:31:22.689899+00
825	water	2014-07-04 10:31:34.819099+00
826	water	2014-07-04 10:31:42.982779+00
827	water	2014-07-04 10:31:52.340807+00
828	water	2014-07-04 10:31:58.632736+00
829	water	2014-07-04 10:31:59.19822+00
830	water	2014-07-04 10:32:03.032757+00
831	water	2014-07-04 10:32:03.032757+00
832	water	2014-07-04 10:32:23.332677+00
833	water	2014-07-04 10:32:42.432734+00
834	water	2014-07-04 10:33:02.412688+00
835	water	2014-07-04 10:33:02.412688+00
836	water	2014-07-04 10:33:16.910642+00
837	water	2014-07-04 10:33:16.910642+00
838	water	2014-07-04 10:33:31.092692+00
839	water	2014-07-04 10:33:31.092692+00
840	water	2014-07-04 10:33:36.531782+00
841	water	2014-07-04 10:33:36.531782+00
842	water	2014-07-04 10:33:43.408046+00
843	water	2014-07-04 10:33:43.408046+00
844	water	2014-07-04 10:33:49.859002+00
845	water	2014-07-04 10:33:51.077582+00
846	water	2014-07-04 10:33:51.077582+00
847	water	2014-07-04 10:33:54.201612+00
848	water	2014-07-04 10:34:11.411274+00
849	water	2014-07-04 10:34:24.818525+00
850	water	2014-07-04 10:34:30.262685+00
851	water	2014-07-04 10:34:39.047725+00
852	water	2014-07-04 10:36:06.356615+00
853	water	2014-07-04 10:36:29.364714+00
854	water	2014-07-04 10:36:36.842678+00
855	water	2014-07-04 10:36:37.898243+00
856	water	2014-07-04 10:36:37.898243+00
857	water	2014-07-04 10:36:56.470246+00
858	water	2014-07-04 10:36:56.470246+00
859	water	2014-07-04 10:37:11.00935+00
860	water	2014-07-04 10:37:12.181062+00
861	water	2014-07-04 10:37:20.189979+00
862	water	2014-07-04 10:37:28.071156+00
863	water	2014-07-04 10:37:39.1027+00
864	water	2014-07-04 10:37:46.257257+00
865	water	2014-07-04 10:37:51.462699+00
866	water	2014-07-04 10:37:56.358238+00
867	water	2014-07-04 10:37:58.69979+00
868	water	2014-07-04 10:38:08.339688+00
869	water	2014-07-04 10:38:08.339688+00
870	water	2014-07-04 10:38:09.332694+00
871	water	2014-07-04 10:38:14.828935+00
872	water	2014-07-04 10:38:14.828935+00
873	water	2014-07-04 10:38:18.188364+00
874	water	2014-07-04 10:38:21.497295+00
875	water	2014-07-04 10:38:24.2627+00
876	water	2014-07-04 10:38:24.2627+00
877	water	2014-07-04 10:38:34.679145+00
878	water	2014-07-04 10:38:43.18253+00
879	water	2014-07-04 10:38:43.18253+00
880	water	2014-07-04 10:38:54.921101+00
881	water	2014-07-04 10:38:57.469046+00
882	water	2014-07-04 10:39:04.898333+00
883	water	2014-07-04 10:39:05.462699+00
884	water	2014-07-04 10:39:11.362729+00
885	water	2014-07-04 10:39:14.87275+00
886	water	2014-07-04 10:39:27.582681+00
887	water	2014-07-04 10:39:27.582681+00
888	water	2014-07-04 10:39:28.366345+00
889	water	2014-07-04 10:39:39.502685+00
890	water	2014-07-04 10:39:40.522697+00
891	water	2014-07-04 10:39:53.079856+00
892	water	2014-07-04 10:40:12.016895+00
893	water	2014-07-04 10:40:19.47671+00
894	water	2014-07-04 10:40:19.47671+00
895	water	2014-07-04 10:40:26.79269+00
896	water	2014-07-04 10:40:38.912695+00
897	water	2014-07-04 10:40:48.732683+00
898	water	2014-07-04 10:40:48.732683+00
899	water	2014-07-04 10:40:56.277373+00
900	water	2014-07-04 10:41:02.642712+00
901	water	2014-07-04 10:41:05.142704+00
902	water	2014-07-04 10:41:11.549495+00
903	water	2014-07-04 10:41:20.922694+00
904	water	2014-07-04 10:41:28.982707+00
905	water	2014-07-04 10:41:39.797742+00
906	water	2014-07-04 10:41:54.422721+00
907	water	2014-07-04 10:42:03.211546+00
908	water	2014-07-04 10:42:07.341066+00
909	water	2014-07-04 10:42:16.919697+00
910	water	2014-07-04 10:42:25.202699+00
911	water	2014-07-04 10:42:25.202699+00
912	water	2014-07-04 10:42:32.850745+00
913	water	2014-07-04 10:42:40.782683+00
914	water	2014-07-04 10:43:03.699452+00
915	water	2014-07-04 10:43:06.732544+00
916	water	2014-07-04 10:43:10.682686+00
917	water	2014-07-04 10:43:16.54922+00
918	water	2014-07-04 10:43:29.38814+00
919	water	2014-07-04 10:43:35.838961+00
920	water	2014-07-04 10:43:42.537142+00
921	water	2014-07-04 10:43:45.562735+00
922	water	2014-07-04 10:43:58.391252+00
923	water	2014-07-04 10:44:08.818035+00
924	water	2014-07-04 10:44:08.818035+00
925	water	2014-07-04 10:44:21.658426+00
926	water	2014-07-04 10:44:28.892553+00
927	water	2014-07-04 10:44:37.042685+00
928	water	2014-07-04 10:44:45.642715+00
929	water	2014-07-04 10:44:54.269507+00
930	water	2014-07-04 10:44:58.850433+00
931	water	2014-07-04 10:45:03.55031+00
932	water	2014-07-04 10:45:16.367266+00
933	water	2014-07-04 10:45:16.367266+00
934	water	2014-07-04 10:45:16.367266+00
935	water	2014-07-04 10:45:16.367266+00
936	water	2014-07-04 10:45:24.740539+00
937	water	2014-07-04 10:45:35.602696+00
938	water	2014-07-04 10:45:47.490312+00
939	water	2014-07-04 10:46:02.812688+00
940	water	2014-07-04 10:46:15.119062+00
941	water	2014-07-04 10:46:26.262704+00
942	water	2014-07-04 10:46:26.262704+00
943	water	2014-07-04 10:46:45.341359+00
944	water	2014-07-04 10:48:32.419699+00
945	water	2014-07-04 10:48:32.419699+00
946	water	2014-07-04 10:48:32.419699+00
947	water	2014-07-04 10:48:47.891423+00
948	water	2014-07-04 10:48:47.891423+00
949	water	2014-07-04 10:48:47.891423+00
950	water	2014-07-04 10:48:47.891423+00
951	water	2014-07-04 10:49:32.548792+00
952	water	2014-07-04 10:49:33.961187+00
953	water	2014-07-04 10:49:33.961187+00
954	water	2014-07-04 10:49:46.490824+00
955	water	2014-07-04 10:49:54.812734+00
956	water	2014-07-04 10:50:03.491632+00
957	water	2014-07-04 10:50:10.88268+00
958	water	2014-07-04 10:50:10.88268+00
959	water	2014-07-04 10:50:16.422701+00
960	water	2014-07-04 10:50:16.422701+00
961	water	2014-07-04 10:50:30.602692+00
962	water	2014-07-04 10:50:36.896424+00
963	water	2014-07-04 10:50:36.896424+00
964	water	2014-07-04 10:50:45.782744+00
965	water	2014-07-04 10:50:57.382685+00
966	water	2014-07-04 10:51:04.659681+00
967	water	2014-07-04 10:51:06.112813+00
968	water	2014-07-04 10:51:16.802694+00
969	water	2014-07-04 10:51:21.241699+00
970	water	2014-07-04 10:51:42.151052+00
971	water	2014-07-04 10:52:04.242806+00
972	water	2014-07-04 10:52:04.242806+00
973	water	2014-07-04 10:52:15.777343+00
974	water	2014-07-04 10:52:27.348155+00
975	water	2014-07-04 10:52:27.348155+00
976	water	2014-07-04 10:52:42.588421+00
977	water	2014-07-04 10:52:42.588421+00
978	water	2014-07-04 10:52:54.094063+00
979	water	2014-07-04 10:53:04.75087+00
980	water	2014-07-04 10:53:04.75087+00
981	water	2014-07-04 10:53:11.842674+00
982	water	2014-07-04 10:53:14.569227+00
983	water	2014-07-04 10:53:14.569227+00
984	water	2014-07-04 10:53:39.596903+00
985	water	2014-07-04 10:53:49.099201+00
986	water	2014-07-04 10:53:56.690573+00
987	water	2014-07-04 10:54:06.518723+00
988	water	2014-07-04 10:54:06.518723+00
989	water	2014-07-04 10:54:06.518723+00
990	water	2014-07-04 10:54:06.518723+00
991	water	2014-07-04 10:54:06.878627+00
992	water	2014-07-04 10:54:26.172683+00
993	water	2014-07-04 10:54:47.652691+00
994	water	2014-07-04 10:55:15.212702+00
995	water	2014-07-04 10:55:45.740147+00
996	water	2014-07-04 10:55:45.740147+00
997	water	2014-07-04 10:55:45.740147+00
998	water	2014-07-04 10:55:45.740147+00
999	water	2014-07-04 10:55:49.660629+00
1000	water	2014-07-04 10:55:49.660629+00
1001	water	2014-07-04 10:55:49.660629+00
1002	water	2014-07-04 10:55:50.407613+00
1003	water	2014-07-04 10:55:50.407613+00
1004	water	2014-07-04 10:55:53.872678+00
1005	water	2014-07-04 10:56:02.102703+00
1006	water	2014-07-04 10:56:09.362738+00
1007	water	2014-07-04 10:56:22.499149+00
1008	water	2014-07-04 10:56:22.499149+00
1009	water	2014-07-04 10:56:28.929622+00
1010	water	2014-07-04 10:56:29.692546+00
1011	water	2014-07-04 10:56:29.692546+00
1012	water	2014-07-04 10:56:36.86047+00
1013	water	2014-07-04 10:56:51.262696+00
1014	water	2014-07-04 10:56:54.572726+00
1015	water	2014-07-04 10:57:18.502752+00
1016	water	2014-07-04 10:57:19.558204+00
1017	water	2014-07-04 10:57:19.558204+00
1018	water	2014-07-04 10:57:25.282706+00
1019	water	2014-07-04 10:57:25.282706+00
1020	water	2014-07-04 10:57:30.422693+00
1021	water	2014-07-04 10:57:41.057669+00
1022	water	2014-07-04 10:57:42.352671+00
1023	water	2014-07-04 10:57:48.317085+00
1024	water	2014-07-04 10:57:54.48272+00
1025	water	2014-07-04 10:58:05.312704+00
1026	water	2014-07-04 10:58:15.139159+00
1027	water	2014-07-04 10:58:23.962737+00
1028	water	2014-07-04 10:58:32.702722+00
1029	water	2014-07-04 10:58:58.767136+00
1030	water	2014-07-04 11:00:12.998791+00
1031	water	2014-07-04 11:00:25.650384+00
1032	water	2014-07-04 11:00:35.772699+00
1033	water	2014-07-04 11:00:50.51016+00
1034	water	2014-07-04 11:00:53.759791+00
1035	water	2014-07-04 11:01:08.572523+00
1036	water	2014-07-04 11:01:08.572523+00
1037	water	2014-07-04 11:01:08.572523+00
1038	water	2014-07-04 11:01:18.292681+00
1039	water	2014-07-04 11:01:18.292681+00
1040	water	2014-07-04 11:01:18.292681+00
1041	water	2014-07-04 11:01:18.292681+00
1042	water	2014-07-04 11:01:18.292681+00
1043	water	2014-07-04 11:01:18.292681+00
1044	water	2014-07-04 11:01:29.986963+00
1045	water	2014-07-04 11:02:10.906626+00
1046	water	2014-07-04 11:02:14.398731+00
1047	water	2014-07-04 11:02:22.668091+00
1048	water	2014-07-04 11:02:28.259079+00
1049	water	2014-07-04 11:02:28.259079+00
1050	water	2014-07-04 11:02:28.259079+00
1051	water	2014-07-04 11:02:28.259079+00
1052	water	2014-07-04 11:02:28.259079+00
1053	water	2014-07-04 11:02:28.259079+00
1054	water	2014-07-04 11:02:28.259079+00
1055	water	2014-07-04 11:02:28.259079+00
1056	water	2014-07-04 11:02:28.259079+00
1057	water	2014-07-04 11:02:30.012532+00
1058	water	2014-07-04 11:02:30.012532+00
1059	water	2014-07-04 11:02:30.012532+00
1060	water	2014-07-04 11:02:30.012532+00
1061	water	2014-07-04 11:02:30.012532+00
1062	water	2014-07-04 11:02:43.509387+00
1063	water	2014-07-04 11:02:45.352683+00
1064	water	2014-07-04 11:02:45.352683+00
1065	water	2014-07-04 11:02:59.132702+00
1066	water	2014-07-04 11:03:05.138778+00
1067	water	2014-07-04 11:03:17.117393+00
1068	water	2014-07-04 11:03:19.35074+00
1069	water	2014-07-04 11:03:19.35074+00
1070	water	2014-07-04 11:03:19.35074+00
1071	water	2014-07-04 11:03:35.727788+00
1072	water	2014-07-04 11:03:37.790996+00
1073	water	2014-07-04 11:03:53.057527+00
1074	water	2014-07-04 11:03:53.057527+00
1075	water	2014-07-04 11:04:05.917655+00
1076	water	2014-07-04 11:04:13.1397+00
1077	water	2014-07-04 11:04:13.1397+00
1078	water	2014-07-04 11:04:26.032696+00
1079	water	2014-07-04 11:04:26.032696+00
1080	water	2014-07-04 11:04:50.552785+00
1081	water	2014-07-04 11:04:50.552785+00
1082	water	2014-07-04 11:04:58.370277+00
1083	water	2014-07-04 11:04:58.370277+00
1084	water	2014-07-04 11:05:47.092699+00
1085	water	2014-07-04 11:05:47.092699+00
1086	water	2014-07-04 11:05:56.727687+00
1087	water	2014-07-04 11:06:25.342736+00
1088	water	2014-07-04 11:06:25.342736+00
1089	water	2014-07-04 11:07:59.552694+00
1090	water	2014-07-04 11:07:59.552694+00
1091	water	2014-07-04 11:08:11.672129+00
1092	water	2014-07-04 11:08:33.6227+00
1093	water	2014-07-04 11:08:33.6227+00
1094	water	2014-07-04 11:08:34.642709+00
1095	water	2014-07-04 11:08:34.642709+00
1096	water	2014-07-04 11:08:34.642709+00
1097	water	2014-07-04 11:08:34.642709+00
1098	water	2014-07-04 11:08:54.812686+00
1099	water	2014-07-04 11:09:06.011942+00
1100	water	2014-07-04 11:09:19.012673+00
1101	water	2014-07-04 11:09:22.242109+00
1102	water	2014-07-04 11:09:22.242109+00
1103	water	2014-07-04 11:09:27.631009+00
1104	water	2014-07-04 11:09:45.072688+00
1105	water	2014-07-04 11:10:28.162724+00
1106	water	2014-07-04 11:10:28.162724+00
1107	water	2014-07-04 11:10:28.162724+00
1108	water	2014-07-04 11:10:28.162724+00
1109	water	2014-07-04 11:10:30.441075+00
1110	water	2014-07-04 11:10:30.441075+00
1111	water	2014-07-04 11:10:31.152707+00
1112	water	2014-07-04 11:10:31.152707+00
1113	water	2014-07-04 11:11:35.822688+00
1114	water	2014-07-04 11:11:35.822688+00
1115	water	2014-07-04 11:14:48.362697+00
1116	water	2014-07-04 11:15:22.560271+00
1117	water	2014-07-04 11:15:30.212701+00
1118	water	2014-07-04 11:16:01.708439+00
1119	water	2014-07-04 11:17:25.460038+00
1120	water	2014-07-04 11:17:25.460038+00
1121	water	2014-07-04 11:17:25.460038+00
1122	water	2014-07-04 11:17:37.086976+00
1123	water	2014-07-04 11:19:54.371455+00
1124	water	2014-07-04 11:19:54.371455+00
1125	water	2014-07-04 11:19:54.371455+00
1126	water	2014-07-04 11:19:54.371455+00
1127	water	2014-07-04 11:19:54.371455+00
1128	water	2014-07-04 11:20:03.872692+00
1129	water	2014-07-04 11:21:21.620735+00
1130	water	2014-07-04 11:21:21.620735+00
1131	water	2014-07-04 11:21:21.620735+00
1132	water	2014-07-04 11:21:21.620735+00
1133	water	2014-07-04 11:21:21.620735+00
1134	water	2014-07-04 11:22:19.142698+00
1135	water	2014-07-04 11:22:19.142698+00
1136	water	2014-07-04 11:22:19.142698+00
1137	water	2014-07-04 11:22:51.962763+00
1138	water	2014-07-04 11:22:51.962763+00
1139	water	2014-07-04 11:23:18.970543+00
1140	water	2014-07-04 11:24:59.238434+00
1141	water	2014-07-04 11:24:59.238434+00
1142	water	2014-07-04 11:24:59.238434+00
1143	water	2014-07-04 11:24:59.238434+00
1144	water	2014-07-04 11:24:59.238434+00
1145	water	2014-07-04 11:24:59.238434+00
1146	water	2014-07-04 11:24:59.238434+00
1147	water	2014-07-04 11:24:59.238434+00
1148	water	2014-07-04 11:24:59.238434+00
1149	water	2014-07-04 11:26:03.207208+00
1150	water	2014-07-04 11:26:03.207208+00
1151	water	2014-07-04 11:26:03.207208+00
1152	water	2014-07-04 11:26:03.207208+00
1153	water	2014-07-04 11:26:03.207208+00
1154	water	2014-07-04 11:26:12.880204+00
1155	water	2014-07-04 11:26:12.880204+00
1156	water	2014-07-04 11:26:12.880204+00
1157	water	2014-07-04 11:30:40.356838+00
1158	water	2014-07-04 11:30:41.867771+00
1159	water	2014-07-04 11:31:35.040553+00
1160	water	2014-07-04 11:31:35.040553+00
1161	water	2014-07-04 11:33:23.922763+00
1162	water	2014-07-04 11:33:23.922763+00
1163	water	2014-07-04 11:33:23.922763+00
1164	water	2014-07-04 11:33:23.922763+00
1165	water	2014-07-04 11:33:23.922763+00
1166	water	2014-07-04 11:35:40.662673+00
1167	water	2014-07-04 11:37:00.837755+00
1168	water	2014-07-04 11:37:00.837755+00
1169	water	2014-07-04 11:37:06.682687+00
1170	water	2014-07-04 11:37:06.682687+00
1171	water	2014-07-04 11:37:06.682687+00
1172	water	2014-07-04 11:37:06.682687+00
1173	water	2014-07-04 11:37:23.056492+00
1174	water	2014-07-04 11:37:23.056492+00
1175	water	2014-07-04 11:37:23.056492+00
1176	water	2014-07-04 11:37:40.704864+00
1177	water	2014-07-04 11:37:40.704864+00
1178	water	2014-07-04 11:39:58.310416+00
1179	water	2014-07-04 11:40:41.880176+00
1180	water	2014-07-04 11:40:57.506718+00
1181	water	2014-07-04 11:41:57.492692+00
1182	water	2014-07-04 11:42:06.081623+00
1183	water	2014-07-04 11:42:17.509334+00
1184	water	2014-07-04 11:42:17.868537+00
1185	water	2014-07-04 11:43:08.086939+00
1186	water	2014-07-04 11:43:08.086939+00
1187	water	2014-07-04 11:43:08.086939+00
1188	water	2014-07-04 11:43:08.086939+00
1189	water	2014-07-04 11:43:22.080522+00
1190	water	2014-07-04 11:43:22.080522+00
1191	water	2014-07-04 11:43:35.627803+00
1192	water	2014-07-04 11:43:57.528623+00
1193	water	2014-07-04 11:43:57.528623+00
1194	water	2014-07-04 11:43:57.528623+00
1195	water	2014-07-04 11:43:57.528623+00
1196	water	2014-07-04 11:44:46.902708+00
1197	water	2014-07-04 11:44:46.902708+00
1198	water	2014-07-04 11:44:46.902708+00
1199	water	2014-07-04 11:44:46.902708+00
1200	water	2014-07-04 11:44:46.902708+00
1201	water	2014-07-04 11:45:47.9427+00
1202	water	2014-07-04 11:45:52.351863+00
1203	water	2014-07-04 11:45:52.351863+00
1204	water	2014-07-04 11:45:52.351863+00
1205	water	2014-07-04 11:45:52.351863+00
1206	water	2014-07-04 11:45:52.351863+00
1207	water	2014-07-04 11:46:02.412677+00
1208	water	2014-07-04 11:46:02.412677+00
1209	water	2014-07-04 11:46:02.412677+00
1210	water	2014-07-04 11:46:02.412677+00
1211	water	2014-07-04 11:46:51.562568+00
1212	water	2014-07-04 11:46:51.562568+00
1213	water	2014-07-04 11:46:51.562568+00
1214	water	2014-07-04 11:47:13.450113+00
1215	water	2014-07-04 11:47:13.450113+00
1216	water	2014-07-04 11:47:13.450113+00
1217	water	2014-07-04 11:47:13.450113+00
1218	water	2014-07-04 11:47:13.450113+00
1219	water	2014-07-04 11:47:15.096926+00
1220	water	2014-07-04 11:47:15.096926+00
1221	water	2014-07-04 11:47:15.096926+00
1222	water	2014-07-04 11:47:21.559131+00
1223	water	2014-07-04 11:47:21.559131+00
1224	water	2014-07-04 11:47:41.702693+00
1225	water	2014-07-04 11:47:41.702693+00
1226	water	2014-07-04 11:47:41.702693+00
1227	water	2014-07-04 11:47:41.702693+00
1228	water	2014-07-04 11:47:54.820659+00
1229	water	2014-07-04 11:47:54.820659+00
1230	water	2014-07-04 11:48:30.649471+00
1231	water	2014-07-04 11:48:30.649471+00
1232	water	2014-07-04 11:48:30.649471+00
1233	water	2014-07-04 11:49:17.79054+00
1234	water	2014-07-04 11:49:17.79054+00
1235	water	2014-07-04 11:49:17.79054+00
1236	water	2014-07-04 11:50:12.592705+00
1237	water	2014-07-04 11:50:12.592705+00
1238	water	2014-07-04 11:50:12.592705+00
1239	water	2014-07-04 11:50:12.592705+00
1240	water	2014-07-04 11:50:12.592705+00
1241	water	2014-07-04 11:50:12.592705+00
1242	water	2014-07-04 11:53:12.222694+00
1243	water	2014-07-04 11:53:12.222694+00
1244	water	2014-07-04 11:53:12.222694+00
1245	water	2014-07-04 11:53:12.222694+00
1246	water	2014-07-04 11:53:12.222694+00
1247	water	2014-07-04 11:53:12.222694+00
1248	water	2014-07-04 11:53:12.222694+00
1249	water	2014-07-04 11:53:12.222694+00
1250	water	2014-07-04 11:53:12.222694+00
1251	water	2014-07-04 11:53:46.231699+00
1252	water	2014-07-04 11:53:46.231699+00
1253	water	2014-07-04 11:53:46.231699+00
1254	water	2014-07-04 11:53:46.231699+00
1255	water	2014-07-04 11:53:46.231699+00
1256	water	2014-07-04 11:53:46.231699+00
1257	water	2014-07-04 11:55:14.942076+00
1258	water	2014-07-04 11:55:14.942076+00
1259	water	2014-07-04 11:55:18.782099+00
\.


--
-- Name: sales_record_sale_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('sales_record_sale_id_seq', 1274, true);


--
-- Name: auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY auth_group
    ADD CONSTRAINT auth_group_name_key UNIQUE (name);


--
-- Name: auth_group_permissions_group_id_permission_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_permission_id_key UNIQUE (group_id, permission_id);


--
-- Name: auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- Name: auth_permission_content_type_id_codename_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_codename_key UNIQUE (content_type_id, codename);


--
-- Name: auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups_user_id_group_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_group_id_key UNIQUE (user_id, group_id);


--
-- Name: auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY auth_user
    ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions_user_id_permission_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_permission_id_key UNIQUE (user_id, permission_id);


--
-- Name: auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY auth_user
    ADD CONSTRAINT auth_user_username_key UNIQUE (username);


--
-- Name: django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);


--
-- Name: django_content_type_app_label_model_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY django_content_type
    ADD CONSTRAINT django_content_type_app_label_model_key UNIQUE (app_label, model);


--
-- Name: django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- Name: django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY django_session
    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);


--
-- Name: sales_record_sale_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY sales_record_sale
    ADD CONSTRAINT sales_record_sale_pkey PRIMARY KEY (id);


--
-- Name: auth_group_name_like; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX auth_group_name_like ON auth_group USING btree (name varchar_pattern_ops);


--
-- Name: auth_group_permissions_group_id; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX auth_group_permissions_group_id ON auth_group_permissions USING btree (group_id);


--
-- Name: auth_group_permissions_permission_id; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX auth_group_permissions_permission_id ON auth_group_permissions USING btree (permission_id);


--
-- Name: auth_permission_content_type_id; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX auth_permission_content_type_id ON auth_permission USING btree (content_type_id);


--
-- Name: auth_user_groups_group_id; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX auth_user_groups_group_id ON auth_user_groups USING btree (group_id);


--
-- Name: auth_user_groups_user_id; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX auth_user_groups_user_id ON auth_user_groups USING btree (user_id);


--
-- Name: auth_user_user_permissions_permission_id; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX auth_user_user_permissions_permission_id ON auth_user_user_permissions USING btree (permission_id);


--
-- Name: auth_user_user_permissions_user_id; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX auth_user_user_permissions_user_id ON auth_user_user_permissions USING btree (user_id);


--
-- Name: auth_user_username_like; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX auth_user_username_like ON auth_user USING btree (username varchar_pattern_ops);


--
-- Name: django_admin_log_content_type_id; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX django_admin_log_content_type_id ON django_admin_log USING btree (content_type_id);


--
-- Name: django_admin_log_user_id; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX django_admin_log_user_id ON django_admin_log USING btree (user_id);


--
-- Name: django_session_expire_date; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX django_session_expire_date ON django_session USING btree (expire_date);


--
-- Name: django_session_session_key_like; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX django_session_session_key_like ON django_session USING btree (session_key varchar_pattern_ops);


--
-- Name: auth_group_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_group_id_fkey FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: content_type_id_refs_id_93d2d1f8; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT content_type_id_refs_id_93d2d1f8 FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: content_type_id_refs_id_d043b34a; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT content_type_id_refs_id_d043b34a FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: group_id_refs_id_f4b32aac; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT group_id_refs_id_f4b32aac FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: user_id_refs_id_40c41112; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT user_id_refs_id_40c41112 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: user_id_refs_id_4dc23c39; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT user_id_refs_id_4dc23c39 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: user_id_refs_id_c0d12874; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT user_id_refs_id_c0d12874 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--