--
-- supermarket insert SQL
--
BEGIN;

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

SET search_path = public, pg_catalog;

--
-- Name: customers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: daim
--

SELECT pg_catalog.setval('customers_id_seq', 10, true);


--
-- Name: goods_id_seq; Type: SEQUENCE SET; Schema: public; Owner: daim
--

SELECT pg_catalog.setval('goods_id_seq', 15, true);


--
-- Name: orders_id_seq; Type: SEQUENCE SET; Schema: public; Owner: daim
--

SELECT pg_catalog.setval('orders_id_seq', 100, true);


--
-- Data for Name: customers; Type: TABLE DATA; Schema: public; Owner: daim
--

COPY customers (id, name, email, phone, address) FROM stdin;
1	守屋一郎	moriya@foo.bar	03-1111-2222	東京都
2	山形二郎	yamaga@foo.bar	03-2222-3333	東京都
3	宮崎三郎	miyaz@foo.bar	048-333-4444	埼玉県
4	寺本四郎	tm@baz.bar	048-444-5555	埼玉県
5	前川五郎	maek@baz.bar	03-5555-6666	東京都
6	渡辺六朗	wat@baz.bar	03-6666-7777	東京都
7	神田七朗	kan@hoge.bar	03-7777-8888	東京都
8	細川八朗	hoso@hoge.bar	03-8888-9999	東京都
9	村上九朗	mura@foo.bar	043-111-2222	千葉県
10	紺野十兵衛	kon@foo.bar	043-222-3333	千葉県
\.


--
-- Data for Name: goods; Type: TABLE DATA; Schema: public; Owner: daim
--

COPY goods (id, name, price) FROM stdin;
1	メロンパン	98
2	牛乳	188
3	ロースハム	178
4	たまご	168
5	中華丼の具	548
6	はちみつ 200g	698
7	無添加ベーコン	298
8	バルサミコ酢	898
9	ごま油	798
10	スパゲティ	198
11	小玉すいか	598
12	さくらんぼ	798
13	しいたけ	298
14	南高梅	1480
15	アスパラガス	348
\.


--
-- Data for Name: orders; Type: TABLE DATA; Schema: public; Owner: daim
--

COPY orders (id, customer_id, goods_id, number, o_time) FROM stdin;
1	1	3	1	2012-01-07 04:05:06
2	3	9	1	2012-01-08 09:30:25
3	9	2	1	2012-01-08 09:31:40
4	4	6	10	2012-01-08 12:22:30
5	8	4	1	2012-01-09 10:25:30
6	10	10	1	2012-01-09 10:26:22
7	3	12	2	2012-01-10 08:28:21
8	4	1	20	2012-01-14 08:29:34
9	6	3	1	2012-01-19 11:28:10
10	6	8	1	2012-01-19 12:19:21
11	3	2	10	2012-01-23 16:22:05
12	3	9	1	2012-01-23 17:33:12
13	2	12	1	2012-01-25 18:12:02
14	5	10	1	2012-01-31 13:22:09
15	3	1	1	2012-02-01 07:23:11
16	7	6	2	2012-02-01 10:24:56
17	8	3	1	2012-02-01 11:13:33
18	2	9	1	2012-02-02 09:56:22
19	4	12	1	2012-02-02 14:15:46
20	1	15	8	2012-02-03 13:22:43
21	6	3	1	2012-02-05 04:05:06
22	5	9	1	2012-02-06 09:30:25
23	9	14	1	2012-02-08 09:31:40
24	2	7	10	2012-02-08 12:22:30
25	1	4	1	2012-02-09 10:25:30
26	8	13	1	2012-02-09 10:26:22
27	3	15	2	2012-02-10 08:28:21
28	4	9	20	2012-02-10 08:29:34
29	5	3	1	2012-02-12 11:28:10
30	6	8	1	2012-02-22 20:19:21
31	10	2	10	2012-02-23 16:22:05
32	3	5	1	2012-03-01 20:33:12
33	2	7	1	2012-03-01 15:12:02
34	5	11	1	2012-03-02 13:22:09
35	1	7	1	2012-03-02 14:23:11
36	6	15	2	2012-03-03 14:24:56
37	10	4	1	2012-03-04 07:13:33
38	4	2	1	2012-03-06 16:56:22
39	2	12	1	2012-03-07 14:15:46
40	1	15	5	2012-03-09 13:22:43
41	8	3	1	2012-03-10 04:05:06
42	6	9	1	2012-03-10 09:30:30
43	3	2	1	2012-03-11 21:31:40
44	4	6	10	2012-03-13 12:22:30
45	7	4	1	2012-03-15 10:23:30
46	8	5	1	2012-03-17 23:26:22
47	3	10	2	2012-03-18 08:28:21
48	4	1	20	2012-03-18 22:49:34
49	1	13	1	2012-03-19 11:28:10
50	5	8	1	2012-03-19 21:11:21
51	3	2	10	2012-03-20 16:22:27
52	8	9	1	2012-03-23 20:33:12
53	2	14	1	2012-03-24 18:12:02
54	5	10	1	2012-03-27 13:22:09
55	3	8	1	2012-03-28 14:23:11
56	1	9	2	2012-04-01 05:24:56
57	10	8	1	2012-04-01 15:13:33
58	4	3	1	2012-04-01 16:56:22
59	6	14	1	2012-04-02 14:15:46
60	2	10	1	2012-04-03 13:22:43
61	1	13	3	2012-04-08 04:05:06
62	3	4	1	2012-04-08 09:30:25
63	9	2	1	2012-04-08 09:31:40
64	7	6	10	2012-04-08 12:22:30
65	6	7	1	2012-04-09 01:25:30
66	8	11	1	2012-04-09 03:26:22
67	3	5	2	2012-04-10 08:24:21
68	4	1	20	2012-04-10 08:59:59
69	10	3	1	2012-04-19 13:28:10
70	2	4	2	2012-04-19 16:19:21
71	3	2	10	2012-04-23 17:11:05
72	4	9	1	2012-04-23 20:33:12
73	6	8	1	2012-04-25 15:27:02
74	5	10	1	2012-04-26 13:22:09
75	1	6	1	2012-04-26 18:23:11
76	3	15	2	2012-04-28 14:55:56
77	10	4	1	2012-05-01 15:13:33
78	4	8	1	2012-05-01 02:56:22
79	3	7	1	2012-05-02 06:15:46
80	6	11	1	2012-05-03 10:22:43
81	1	13	1	2012-05-08 20:05:06
82	3	1	1	2012-05-08 20:30:25
83	5	3	1	2012-05-08 23:31:40
84	4	7	10	2012-05-09 06:22:30
85	8	4	1	2012-05-09 09:19:30
86	10	9	1	2012-05-09 10:22:22
87	3	10	2	2012-05-10 13:28:21
88	4	3	20	2012-05-10 18:21:34
89	7	1	1	2012-05-11 17:15:10
90	6	8	1	2012-05-14 20:19:21
91	8	2	10	2012-05-14 16:22:05
92	3	9	1	2012-05-15 11:33:12
93	2	4	1	2012-05-15 12:12:02
94	5	10	1	2012-05-16 05:22:09
95	3	6	1	2012-05-17 23:23:11
96	5	8	2	2012-05-18 01:24:56
97	10	1	1	2012-05-20 15:13:33
98	9	14	1	2012-05-21 02:34:22
99	4	10	5	2012-05-21 14:15:46
100	1	5	1	2012-05-23 13:22:43
\.

COMMIT;
--
-- PostgreSQL database dump complete
--
