--
-- PostgreSQL database dump
--

-- Dumped from database version 9.0.4
-- Dumped by pg_dump version 9.0.4
-- Started on 2011-07-13 14:18:14 CEST

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;

--
-- TOC entry 2213 (class 0 OID 0)
-- Dependencies: 1751
-- Name: controlled_vocabulary_id_seq; Type: SEQUENCE SET; Schema: public; Owner: cramakri
--

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


--
-- TOC entry 2214 (class 0 OID 0)
-- Dependencies: 1752
-- Name: cvte_id_seq; Type: SEQUENCE SET; Schema: public; Owner: cramakri
--

SELECT pg_catalog.setval('cvte_id_seq', 40, true);


--
-- TOC entry 2215 (class 0 OID 0)
-- Dependencies: 1773
-- Name: data_set_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: cramakri
--

SELECT pg_catalog.setval('data_set_type_id_seq', 9, true);


--
-- TOC entry 2216 (class 0 OID 0)
-- Dependencies: 1783
-- Name: dstpt_id_seq; Type: SEQUENCE SET; Schema: public; Owner: cramakri
--

SELECT pg_catalog.setval('dstpt_id_seq', 35, true);


--
-- TOC entry 2217 (class 0 OID 0)
-- Dependencies: 1759
-- Name: etpt_id_seq; Type: SEQUENCE SET; Schema: public; Owner: cramakri
--

SELECT pg_catalog.setval('etpt_id_seq', 9, true);


--
-- TOC entry 2218 (class 0 OID 0)
-- Dependencies: 1765
-- Name: experiment_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: cramakri
--

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


--
-- TOC entry 2219 (class 0 OID 0)
-- Dependencies: 1769
-- Name: material_id_seq; Type: SEQUENCE SET; Schema: public; Owner: cramakri
--

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


--
-- TOC entry 2220 (class 0 OID 0)
-- Dependencies: 1770
-- Name: material_property_id_seq; Type: SEQUENCE SET; Schema: public; Owner: cramakri
--

SELECT pg_catalog.setval('material_property_id_seq', 27, true);


--
-- TOC entry 2221 (class 0 OID 0)
-- Dependencies: 1771
-- Name: material_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: cramakri
--

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


--
-- TOC entry 2222 (class 0 OID 0)
-- Dependencies: 1772
-- Name: mtpt_id_seq; Type: SEQUENCE SET; Schema: public; Owner: cramakri
--

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


--
-- TOC entry 2223 (class 0 OID 0)
-- Dependencies: 1776
-- Name: property_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: cramakri
--

SELECT pg_catalog.setval('property_type_id_seq', 23, true);


--
-- TOC entry 2200 (class 0 OID 574065)
-- Dependencies: 1707
-- Data for Name: controlled_vocabularies; Type: TABLE DATA; Schema: public; Owner: cramakri
--

COPY controlled_vocabularies (id, code, description, registration_timestamp, pers_id_registerer, is_managed_internally, is_internal_namespace, dbin_id, modification_timestamp, is_chosen_from_list, source_uri) FROM stdin;
1	STORAGE_FORMAT	The on-disk storage format of a data set	2011-07-07 17:48:22.649816+02	1	t	t	1	2011-07-07 17:48:22.649816+02	t	\N
2	GROWTH_MEDIA	Growth media for B. Subtilis.	2011-06-01 14:21:40.40244+02	2	f	f	1	2011-06-01 14:21:40.415+02	t	\N
3	TEMPERATURE	Temperature the experiment was conducted under	2011-06-01 14:22:36.240178+02	2	f	f	1	2011-06-01 14:22:36.241+02	t	\N
4	CONTAINER	Container in which the experiment was performed.	2011-06-01 14:23:09.455946+02	2	f	f	1	2011-06-01 14:23:09.458+02	t	\N
5	TECHNOLOGY	Technologies used in BaSynthec	2011-06-01 14:32:54.940133+02	2	f	f	1	2011-06-01 14:32:54.941+02	t	\N
6	DEVICE	Devices used to produce measurements.	2011-06-01 14:33:26.888983+02	2	f	f	1	2011-06-01 14:33:26.89+02	t	\N
7	TIMEPOINT_TYPE	Timepoint Type	2011-06-01 14:59:35.528305+02	2	f	f	1	2011-06-01 14:59:35.529+02	t	\N
8	CELL_LOCATION	Cell Location	2011-06-01 14:59:51.638904+02	2	f	f	1	2011-06-01 14:59:51.639+02	t	\N
9	VALUE_TYPE	Value Type	2011-06-01 15:07:15.850051+02	2	f	f	1	2011-06-01 15:07:15.85+02	t	\N
11	SCALE	Scale	2011-06-01 15:08:55.973041+02	2	f	f	1	2011-06-01 15:08:55.973+02	t	\N
10	VALUE_UNIT	Value Unit	2011-06-01 15:07:40.656819+02	2	f	f	1	2011-06-07 11:06:21.669+02	t	\N
\.


--
-- TOC entry 2201 (class 0 OID 574076)
-- Dependencies: 1708 2200
-- Data for Name: controlled_vocabulary_terms; Type: TABLE DATA; Schema: public; Owner: cramakri
--

COPY controlled_vocabulary_terms (id, code, registration_timestamp, covo_id, pers_id_registerer, label, description, ordinal, is_official) FROM stdin;
1	PROPRIETARY	2011-07-07 17:48:22.649816+02	1	1	\N	\N	1	t
2	BDS_DIRECTORY	2011-07-07 17:48:22.649816+02	1	1	\N	\N	2	t
3	MALATE	2011-06-01 14:21:40.40244+02	2	2	\N	\N	1	t
4	GLUCOSE	2011-06-01 14:21:40.40244+02	2	2	\N	\N	2	t
5	20	2011-06-01 14:22:36.240178+02	3	2	\N	\N	1	t
6	30	2011-06-01 14:22:36.240178+02	3	2	\N	\N	2	t
7	40	2011-06-01 14:22:36.240178+02	3	2	\N	\N	3	t
8	FLASK	2011-06-01 14:23:09.455946+02	4	2	\N	\N	1	t
9	METABOLOMICS	2011-06-01 14:32:54.940133+02	5	2	\N	\N	1	t
10	PHYSIOLOGY	2011-06-01 14:32:54.940133+02	5	2	\N	\N	2	t
11	PROTEOMICS	2011-06-01 14:32:54.940133+02	5	2	\N	\N	3	t
12	TRANSCRIPTOMICS	2011-06-01 14:32:54.940133+02	5	2	\N	\N	4	t
13	ORBITRAP	2011-06-01 14:33:26.888983+02	2	2	\N	\N	1	t
14	EX	2011-06-01 14:59:35.528305+02	7	2	\N	\N	1	t
15	IN	2011-06-01 14:59:35.528305+02	7	2	\N	\N	2	t
16	SI	2011-06-01 14:59:35.528305+02	7	2	\N	\N	3	t
17	CE	2011-06-01 14:59:51.638904+02	8	2	\N	\N	1	t
18	ES	2011-06-01 14:59:51.638904+02	8	2	\N	\N	2	t
19	ME	2011-06-01 14:59:51.638904+02	8	2	\N	\N	3	t
20	CY	2011-06-01 14:59:51.638904+02	8	2	\N	\N	4	t
21	NC	2011-06-01 14:59:51.638904+02	8	2	\N	\N	5	t
22	VALUE	2011-06-01 15:07:15.850051+02	9	2	\N	\N	1	t
23	MEAN	2011-06-01 15:07:15.850051+02	9	2	\N	\N	2	t
24	MEDIAN	2011-06-01 15:07:15.850051+02	9	2	\N	\N	3	t
25	STD	2011-06-01 15:07:15.850051+02	9	2	\N	\N	4	t
26	VAR	2011-06-01 15:07:15.850051+02	9	2	\N	\N	5	t
27	ERROR	2011-06-01 15:07:15.850051+02	9	2	\N	\N	6	t
28	IQR	2011-06-01 15:07:15.850051+02	9	2	\N	\N	7	t
29	MM	2011-06-01 15:07:40.656819+02	10	2	\N	\N	1	t
30	UM	2011-06-01 15:07:40.656819+02	10	2	\N	\N	2	t
34	LIN	2011-06-01 15:08:55.973041+02	11	2	\N	\N	1	t
35	LOG2	2011-06-01 15:08:55.973041+02	11	2	\N	\N	2	t
36	LOG10	2011-06-01 15:08:55.973041+02	11	2	\N	\N	3	t
37	LN	2011-06-01 15:08:55.973041+02	11	2	\N	\N	4	t
31	RATIOT1	2011-06-01 15:07:40.656819+02	10	2	\N	\N	4	t
33	RATIOCS	2011-06-01 15:08:14.224243+02	10	2	\N	\N	5	t
38	PERCENT	2011-06-07 09:25:59.284385+02	10	2	\N	\N	3	t
39	AU	2011-06-07 09:26:07.523864+02	10	2	\N	\N	6	t
40	DIMENSIONLESS	2011-06-07 11:06:21.616952+02	10	2	\N	\N	7	t
\.


--
-- TOC entry 2208 (class 0 OID 574259)
-- Dependencies: 1733
-- Data for Name: data_set_types; Type: TABLE DATA; Schema: public; Owner: cramakri
--

COPY data_set_types (id, code, description, dbin_id, modification_timestamp, main_ds_pattern, main_ds_path, is_container) FROM stdin;
1	UNKNOWN	Unknown	1	2011-07-07 17:48:22.649816+02	\N	\N	f
2	RAW	Raw data	1	2011-06-01 14:35:43.248544+02	\N	\N	f
7	EXCEL_ORIGINAL	Excel data	1	2011-07-07 14:24:59.205768+02	\N	\N	f
8	TSV_EXPORT	An export of the data containing one strain per file.	1	2011-07-07 14:25:32.331964+02	\N	\N	f
9	TSV_MULTISTRAIN_EXPORT	An export of the data containing multiple strains per file.	1	2011-07-07 14:26:06.13375+02	\N	\N	f
5	TRANSCRIPTOMICS	Transcriptomics data	1	2011-06-07 09:43:30.916419+02	\N	\N	t
3	METABOLITE_INTENSITIES	Metabolite intensities	1	2011-06-01 15:09:15.822214+02	\N	\N	t
4	OD600	Growth profiles	1	2011-06-07 09:40:07.551324+02	\N	\N	t
6	PROTEIN_QUANTIFICATIONS	Protein quantifications	1	2011-06-07 09:44:55.591374+02	\N	\N	t
\.


--
-- TOC entry 2206 (class 0 OID 574243)
-- Dependencies: 1731
-- Data for Name: material_types; Type: TABLE DATA; Schema: public; Owner: cramakri
--

COPY material_types (id, code, description, dbin_id, modification_timestamp) FROM stdin;
1	STRAIN	Strain	1	2011-06-01 14:48:39.161056+02
\.


--
-- TOC entry 2209 (class 0 OID 574282)
-- Dependencies: 1736 2200 2206
-- Data for Name: property_types; Type: TABLE DATA; Schema: public; Owner: cramakri
--

COPY property_types (id, code, description, label, daty_id, registration_timestamp, pers_id_registerer, covo_id, is_managed_internally, is_internal_namespace, dbin_id, maty_prop_id, schema, transformation) FROM stdin;
1	DESCRIPTION	A Description	Description	1	2011-07-07 17:48:22.649816+02	1	\N	f	f	1	\N	\N	\N
2	MEDIUM	The growth medium for the experiment	Medium	7	2011-06-01 14:23:50.820065+02	2	2	f	f	1	\N	\N	\N
4	CONTAINER	The type of container in which the experiment was carried out.	Container	7	2011-06-01 14:24:40.461839+02	2	4	f	f	1	\N	\N	\N
5	CONTAINER_VOLUME	The volume of the container.	Container Volume	1	2011-06-01 14:25:42.437944+02	2	\N	f	f	1	\N	\N	\N
6	MISC_GROWTH_CONDITIONS	Miscellaneous growth conditions.	Growth Conditions	2	2011-06-01 14:26:20.93953+02	2	\N	f	f	1	\N	\N	\N
7	SHAKER_RPM	The RPMs of the shaker used to prepare the experiment.	Shaker RPM	3	2011-06-01 14:26:51.368174+02	2	\N	f	f	1	\N	\N	\N
8	COMMENTS	Miscellaneous comments.	Comments	2	2011-06-01 14:27:17.239486+02	2	\N	f	f	1	\N	\N	\N
9	TECHNOLOGY	The technology used for a measurement.	Technology	7	2011-06-01 14:34:38.569805+02	2	5	f	f	1	\N	\N	\N
10	DEVICE	The device used for a measurement. 	Device	7	2011-06-01 14:35:02.06542+02	2	6	f	f	1	\N	\N	\N
11	OPERATOR	The operator of a device.	Operator	1	2011-06-01 14:35:20.308799+02	2	\N	f	f	1	\N	\N	\N
12	STRAIN_NAME	The name of the strain.	Name	1	2011-06-01 14:49:27.382572+02	2	\N	f	f	1	\N	\N	\N
13	STRAIN	The strain of B. Subtilis.	Strain	8	2011-06-01 14:52:49.555029+02	2	\N	f	f	1	1	\N	\N
14	TIMEPOINT_TYPE	Timepoint Type	Timepoint Type	7	2011-06-01 15:10:26.249761+02	2	7	f	f	1	\N	\N	\N
15	CELL_LOCATION	Cell Location	Cell Location	7	2011-06-01 15:10:41.349422+02	2	8	f	f	1	\N	\N	\N
16	VALUE_TYPE	Value Type	Value Type	7	2011-06-01 15:11:00.652368+02	2	9	f	f	1	\N	\N	\N
17	VALUE_UNIT	Value Unit	Value Unit	7	2011-06-01 15:11:20.926301+02	2	10	f	f	1	\N	\N	\N
18	SCALE	Scale	Scale	7	2011-06-01 15:11:36.989897+02	2	11	f	f	1	\N	\N	\N
19	TEMPERATURE	The temperature under which the experiment was carried out.	Temperature	4	2011-06-15 09:55:42.66193+02	2	\N	f	f	1	\N	\N	\N
20	STRAIN_NAMES	Strain Names	Strain Names	1	2011-06-29 15:53:03.26604+02	2	\N	f	f	1	\N	\N	\N
21	REFERENCE_STRAIN	Reference Strain	Reference Strain	8	2011-06-29 15:53:42.397136+02	2	\N	f	f	1	1	\N	\N
22	EXPERIMENT_DATE	Experiment Date	Experiment Date	6	2011-06-29 15:54:09.331516+02	2	\N	f	f	1	\N	\N	\N
23	DATA_TYPE	Data Type	Data Type	1	2011-07-11 14:51:57.899818+02	2	\N	f	f	1	\N	\N	\N
\.


--
-- TOC entry 2210 (class 0 OID 574345)
-- Dependencies: 1743 2208 2209
-- Data for Name: data_set_type_property_types; Type: TABLE DATA; Schema: public; Owner: cramakri
--

COPY data_set_type_property_types (id, dsty_id, prty_id, is_mandatory, is_managed_internally, pers_id_registerer, registration_timestamp, ordinal, section, script_id) FROM stdin;
1	2	9	t	f	2	2011-06-01 14:44:56.126417+02	2	\N	\N
2	2	10	f	f	2	2011-06-01 14:45:10.671022+02	3	\N	\N
3	2	11	f	f	2	2011-06-01 14:45:20.412582+02	4	\N	\N
4	2	13	t	f	2	2011-06-01 14:55:14.000965+02	1	\N	\N
5	3	13	f	f	2	2011-06-01 15:09:45.526152+02	1	\N	\N
11	4	13	f	f	2	2011-06-07 09:41:19.577666+02	1	\N	\N
17	5	13	f	f	2	2011-06-07 09:45:57.381638+02	1	\N	\N
23	6	13	f	f	2	2011-06-07 10:26:20.876194+02	1	\N	\N
12	4	14	f	f	2	2011-06-07 09:41:39.189056+02	3	\N	\N
13	4	15	f	f	2	2011-06-07 09:42:00.464051+02	4	\N	\N
14	4	16	f	f	2	2011-06-07 09:42:14.906524+02	5	\N	\N
15	4	17	f	f	2	2011-06-07 09:42:30.293596+02	6	\N	\N
16	4	18	f	f	2	2011-06-07 09:42:36.606913+02	7	\N	\N
29	4	20	f	f	2	2011-06-29 15:56:25.578782+02	2	\N	\N
24	6	14	f	f	2	2011-06-07 10:26:37.439939+02	3	\N	\N
25	6	15	f	f	2	2011-06-07 10:27:03.19151+02	4	\N	\N
27	6	17	f	f	2	2011-06-07 10:27:23.191867+02	6	\N	\N
28	6	18	f	f	2	2011-06-07 10:27:33.149813+02	7	\N	\N
30	6	20	f	f	2	2011-06-29 15:56:36.804424+02	2	\N	\N
18	5	14	f	f	2	2011-06-07 09:46:07.477336+02	3	\N	\N
19	5	15	f	f	2	2011-06-07 09:46:23.775868+02	4	\N	\N
20	5	16	f	f	2	2011-06-07 09:46:34.150697+02	5	\N	\N
21	5	17	f	f	2	2011-06-07 09:46:42.908173+02	6	\N	\N
22	5	18	f	f	2	2011-06-07 09:46:49.641018+02	7	\N	\N
31	5	20	f	f	2	2011-06-29 15:56:49.612258+02	2	\N	\N
32	6	21	f	f	2	2011-06-29 15:59:14.016583+02	8	\N	\N
6	3	14	f	f	2	2011-06-01 15:11:51.457314+02	3	\N	\N
7	3	15	f	f	2	2011-06-01 15:12:06.094358+02	4	\N	\N
8	3	16	f	f	2	2011-06-01 15:12:17.388726+02	5	\N	\N
9	3	17	f	f	2	2011-06-01 15:12:25.79652+02	6	\N	\N
10	3	18	f	f	2	2011-06-01 15:12:35.809392+02	7	\N	\N
26	3	20	f	f	2	2011-06-29 15:55:28.052352+02	2	\N	\N
33	7	23	f	f	2	2011-07-11 14:52:15.733339+02	1	\N	\N
34	8	23	f	f	2	2011-07-11 14:52:25.133573+02	1	\N	\N
35	9	23	f	f	2	2011-07-11 14:52:33.108668+02	1	\N	\N
\.


--
-- TOC entry 2202 (class 0 OID 574167)
-- Dependencies: 1721
-- Data for Name: experiment_types; Type: TABLE DATA; Schema: public; Owner: cramakri
--

COPY experiment_types (id, code, description, dbin_id, modification_timestamp) FROM stdin;
1	BASYNTHEC	The BaSynthec experiment type.	1	2011-06-01 14:08:24.183425+02
\.


--
-- TOC entry 2203 (class 0 OID 574174)
-- Dependencies: 1722 2202 2209
-- Data for Name: experiment_type_property_types; Type: TABLE DATA; Schema: public; Owner: cramakri
--

COPY experiment_type_property_types (id, exty_id, prty_id, is_mandatory, is_managed_internally, pers_id_registerer, registration_timestamp, ordinal, section, script_id) FROM stdin;
1	1	1	f	f	2	2011-06-01 14:11:11.407487+02	1	\N	\N
2	1	2	f	f	2	2011-06-01 14:30:06.812876+02	2	\N	\N
4	1	4	f	f	2	2011-06-01 14:30:23.277699+02	5	\N	\N
5	1	5	f	f	2	2011-06-01 14:30:28.637025+02	6	\N	\N
6	1	6	f	f	2	2011-06-01 14:30:43.373831+02	7	\N	\N
7	1	7	f	f	2	2011-06-01 14:30:54.766288+02	8	\N	\N
8	1	8	f	f	2	2011-06-01 14:31:02.906052+02	9	\N	\N
3	1	19	f	f	2	2011-06-15 10:01:30.732512+02	3	\N	\N
9	1	22	f	f	2	2011-06-29 15:59:28.462793+02	10	\N	\N
\.


--
-- TOC entry 2207 (class 0 OID 574250)
-- Dependencies: 1732 2206 2209
-- Data for Name: material_type_property_types; Type: TABLE DATA; Schema: public; Owner: cramakri
--

COPY material_type_property_types (id, maty_id, prty_id, is_mandatory, is_managed_internally, registration_timestamp, pers_id_registerer, ordinal, section, script_id) FROM stdin;
1	1	12	t	f	2011-06-01 14:50:16.872011+02	2	1	\N	\N
\.


--
-- TOC entry 2204 (class 0 OID 574227)
-- Dependencies: 1729 2206
-- Data for Name: materials; Type: TABLE DATA; Schema: public; Owner: cramakri
--

COPY materials (id, code, maty_id, pers_id_registerer, registration_timestamp, modification_timestamp, dbin_id) FROM stdin;
1	STRAIN1	1	2	2011-06-01 14:51:19.288314+02	2011-06-01 14:51:19.647+02	1
\.


--
-- TOC entry 2205 (class 0 OID 574235)
-- Dependencies: 1730 2201 2204 2204 2207
-- Data for Name: material_properties; Type: TABLE DATA; Schema: public; Owner: cramakri
--

COPY material_properties (id, mate_id, mtpt_id, value, registration_timestamp, modification_timestamp, pers_id_registerer, cvte_id, mate_prop_id) FROM stdin;
1	1	1	Strain 1	2011-06-01 14:51:19.288314+02	2011-06-01 14:51:19.65+02	2	\N	\N
\.


-- Completed on 2011-07-13 14:18:15 CEST

--
-- PostgreSQL database dump complete
--

