-- -- PostgreSQL database dump -- -- Dumped from database version 9.1.1 -- Dumped by pg_dump version 9.1.4 -- Started on 2012-06-16 16:43:27 SET statement_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; -- -- TOC entry 209 (class 3079 OID 11644) -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -- CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; -- -- TOC entry 2273 (class 0 OID 0) -- Dependencies: 209 -- 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; -- -- TOC entry 161 (class 1259 OID 18370) -- Dependencies: 2021 2022 2023 2024 2025 5 -- Name: lime_answers; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_answers ( qid integer DEFAULT 0 NOT NULL, code character varying(5) DEFAULT ''::character varying NOT NULL, answer text NOT NULL, sortorder integer NOT NULL, assessment_value integer DEFAULT 0 NOT NULL, language character varying(20) DEFAULT 'en'::character varying NOT NULL, scale_id smallint DEFAULT 0 NOT NULL ); ALTER TABLE public.lime_answers OWNER TO umfragepiratenndsde; -- -- TOC entry 163 (class 1259 OID 18385) -- Dependencies: 2027 2028 2029 2030 2031 2032 5 -- Name: lime_assessments; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_assessments ( id integer NOT NULL, sid integer DEFAULT 0 NOT NULL, scope character varying(5) DEFAULT ''::character varying NOT NULL, gid integer DEFAULT 0 NOT NULL, name text NOT NULL, minimum character varying(50) DEFAULT ''::character varying NOT NULL, maximum character varying(50) DEFAULT ''::character varying NOT NULL, message text NOT NULL, language character varying(20) DEFAULT 'en'::bpchar NOT NULL ); ALTER TABLE public.lime_assessments OWNER TO umfragepiratenndsde; -- -- TOC entry 162 (class 1259 OID 18383) -- Dependencies: 5 163 -- Name: lime_assessments_id_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_assessments_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_assessments_id_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2274 (class 0 OID 0) -- Dependencies: 162 -- Name: lime_assessments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_assessments_id_seq OWNED BY lime_assessments.id; -- -- TOC entry 2275 (class 0 OID 0) -- Dependencies: 162 -- Name: lime_assessments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_assessments_id_seq', 1, false); -- -- TOC entry 165 (class 1259 OID 18402) -- Dependencies: 2034 2035 2036 2037 2038 2039 5 -- Name: lime_conditions; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_conditions ( cid integer NOT NULL, qid integer DEFAULT 0 NOT NULL, scenario integer DEFAULT 1 NOT NULL, cqid integer DEFAULT 0 NOT NULL, cfieldname character varying(50) DEFAULT ''::character varying NOT NULL, method character(5) DEFAULT ''::bpchar NOT NULL, value character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.lime_conditions OWNER TO umfragepiratenndsde; -- -- TOC entry 164 (class 1259 OID 18400) -- Dependencies: 5 165 -- Name: lime_conditions_cid_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_conditions_cid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_conditions_cid_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2276 (class 0 OID 0) -- Dependencies: 164 -- Name: lime_conditions_cid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_conditions_cid_seq OWNED BY lime_conditions.cid; -- -- TOC entry 2277 (class 0 OID 0) -- Dependencies: 164 -- Name: lime_conditions_cid_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_conditions_cid_seq', 1, false); -- -- TOC entry 166 (class 1259 OID 18414) -- Dependencies: 2040 2041 2042 2043 5 -- Name: lime_defaultvalues; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_defaultvalues ( qid integer DEFAULT 0 NOT NULL, scale_id integer DEFAULT 0 NOT NULL, sqid integer DEFAULT 0 NOT NULL, language character varying(20) NOT NULL, specialtype character varying(20) DEFAULT ''::character varying NOT NULL, defaultvalue text ); ALTER TABLE public.lime_defaultvalues OWNER TO umfragepiratenndsde; -- -- TOC entry 168 (class 1259 OID 18428) -- Dependencies: 2045 5 -- Name: lime_expression_errors; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_expression_errors ( id integer NOT NULL, errortime character varying(50) DEFAULT NULL::character varying, sid integer, gid integer, qid integer, gseq integer, qseq integer, type character varying(50), eqn text, prettyprint text ); ALTER TABLE public.lime_expression_errors OWNER TO umfragepiratenndsde; -- -- TOC entry 167 (class 1259 OID 18426) -- Dependencies: 5 168 -- Name: lime_expression_errors_id_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_expression_errors_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_expression_errors_id_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2278 (class 0 OID 0) -- Dependencies: 167 -- Name: lime_expression_errors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_expression_errors_id_seq OWNED BY lime_expression_errors.id; -- -- TOC entry 2279 (class 0 OID 0) -- Dependencies: 167 -- Name: lime_expression_errors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_expression_errors_id_seq', 1, false); -- -- TOC entry 208 (class 1259 OID 18742) -- Dependencies: 5 -- Name: lime_failed_login_attempts; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_failed_login_attempts ( id integer NOT NULL, ip character varying(37) NOT NULL, last_attempt character varying(20) NOT NULL, number_attempts integer NOT NULL ); ALTER TABLE public.lime_failed_login_attempts OWNER TO umfragepiratenndsde; -- -- TOC entry 207 (class 1259 OID 18740) -- Dependencies: 5 208 -- Name: lime_failed_login_attempts_id_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_failed_login_attempts_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_failed_login_attempts_id_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2280 (class 0 OID 0) -- Dependencies: 207 -- Name: lime_failed_login_attempts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_failed_login_attempts_id_seq OWNED BY lime_failed_login_attempts.id; -- -- TOC entry 2281 (class 0 OID 0) -- Dependencies: 207 -- Name: lime_failed_login_attempts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_failed_login_attempts_id_seq', 2, true); -- -- TOC entry 170 (class 1259 OID 18440) -- Dependencies: 2047 2048 2049 2050 2051 5 -- Name: lime_groups; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_groups ( gid integer NOT NULL, sid integer DEFAULT 0 NOT NULL, group_name character varying(100) DEFAULT ''::character varying NOT NULL, group_order integer DEFAULT 0 NOT NULL, description text, language character varying(20) DEFAULT 'en'::character varying NOT NULL, randomization_group character varying(20) DEFAULT ''::character varying NOT NULL, grelevance text ); ALTER TABLE public.lime_groups OWNER TO umfragepiratenndsde; -- -- TOC entry 169 (class 1259 OID 18438) -- Dependencies: 5 170 -- Name: lime_groups_gid_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_groups_gid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_groups_gid_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2282 (class 0 OID 0) -- Dependencies: 169 -- Name: lime_groups_gid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_groups_gid_seq OWNED BY lime_groups.gid; -- -- TOC entry 2283 (class 0 OID 0) -- Dependencies: 169 -- Name: lime_groups_gid_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_groups_gid_seq', 1, false); -- -- TOC entry 171 (class 1259 OID 18454) -- Dependencies: 2052 2053 2054 2055 5 -- Name: lime_labels; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_labels ( lid integer DEFAULT 0 NOT NULL, code character varying(5) DEFAULT ''::character varying NOT NULL, title text, sortorder integer NOT NULL, assessment_value integer DEFAULT 0 NOT NULL, language character varying(20) DEFAULT 'en'::character varying NOT NULL ); ALTER TABLE public.lime_labels OWNER TO umfragepiratenndsde; -- -- TOC entry 173 (class 1259 OID 18469) -- Dependencies: 2057 2058 5 -- Name: lime_labelsets; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_labelsets ( lid integer NOT NULL, label_name character varying(100) DEFAULT ''::character varying NOT NULL, languages character varying(200) DEFAULT 'en'::character varying ); ALTER TABLE public.lime_labelsets OWNER TO umfragepiratenndsde; -- -- TOC entry 172 (class 1259 OID 18467) -- Dependencies: 173 5 -- Name: lime_labelsets_lid_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_labelsets_lid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_labelsets_lid_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2284 (class 0 OID 0) -- Dependencies: 172 -- Name: lime_labelsets_lid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_labelsets_lid_seq OWNED BY lime_labelsets.lid; -- -- TOC entry 2285 (class 0 OID 0) -- Dependencies: 172 -- Name: lime_labelsets_lid_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_labelsets_lid_seq', 1, false); -- -- TOC entry 198 (class 1259 OID 18699) -- Dependencies: 5 -- Name: lime_participant_attribute; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_participant_attribute ( participant_id character varying(50) NOT NULL, attribute_id integer NOT NULL, value character varying(50) NOT NULL ); ALTER TABLE public.lime_participant_attribute OWNER TO umfragepiratenndsde; -- -- TOC entry 200 (class 1259 OID 18706) -- Dependencies: 5 -- Name: lime_participant_attribute_names; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_participant_attribute_names ( attribute_id integer NOT NULL, attribute_type character varying(4) NOT NULL, visible character varying(5) NOT NULL ); ALTER TABLE public.lime_participant_attribute_names OWNER TO umfragepiratenndsde; -- -- TOC entry 199 (class 1259 OID 18704) -- Dependencies: 5 200 -- Name: lime_participant_attribute_names_attribute_id_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_participant_attribute_names_attribute_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_participant_attribute_names_attribute_id_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2286 (class 0 OID 0) -- Dependencies: 199 -- Name: lime_participant_attribute_names_attribute_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_participant_attribute_names_attribute_id_seq OWNED BY lime_participant_attribute_names.attribute_id; -- -- TOC entry 2287 (class 0 OID 0) -- Dependencies: 199 -- Name: lime_participant_attribute_names_attribute_id_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_participant_attribute_names_attribute_id_seq', 1, false); -- -- TOC entry 201 (class 1259 OID 18712) -- Dependencies: 5 -- Name: lime_participant_attribute_names_lang; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_participant_attribute_names_lang ( id integer NOT NULL, attribute_id integer NOT NULL, attribute_name character varying(30) NOT NULL, lang character varying(20) NOT NULL ); ALTER TABLE public.lime_participant_attribute_names_lang OWNER TO umfragepiratenndsde; -- -- TOC entry 203 (class 1259 OID 18719) -- Dependencies: 5 -- Name: lime_participant_attribute_values; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_participant_attribute_values ( value_id integer NOT NULL, attribute_id integer NOT NULL, value character varying(20) NOT NULL ); ALTER TABLE public.lime_participant_attribute_values OWNER TO umfragepiratenndsde; -- -- TOC entry 202 (class 1259 OID 18717) -- Dependencies: 5 203 -- Name: lime_participant_attribute_values_value_id_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_participant_attribute_values_value_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_participant_attribute_values_value_id_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2288 (class 0 OID 0) -- Dependencies: 202 -- Name: lime_participant_attribute_values_value_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_participant_attribute_values_value_id_seq OWNED BY lime_participant_attribute_values.value_id; -- -- TOC entry 2289 (class 0 OID 0) -- Dependencies: 202 -- Name: lime_participant_attribute_values_value_id_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_participant_attribute_values_value_id_seq', 1, false); -- -- TOC entry 204 (class 1259 OID 18725) -- Dependencies: 5 -- Name: lime_participant_shares; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_participant_shares ( participant_id character varying(50) NOT NULL, share_uid integer NOT NULL, date_added timestamp without time zone NOT NULL, can_edit character varying(5) NOT NULL ); ALTER TABLE public.lime_participant_shares OWNER TO umfragepiratenndsde; -- -- TOC entry 197 (class 1259 OID 18690) -- Dependencies: 2150 2151 2152 2153 5 -- Name: lime_participants; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_participants ( participant_id character varying(50) NOT NULL, firstname character varying(40) DEFAULT NULL::character varying, lastname character varying(40) DEFAULT NULL::character varying, email character varying(80) DEFAULT NULL::character varying, language character varying(2) DEFAULT NULL::character varying, blacklisted character(1) NOT NULL, owner_uid integer NOT NULL ); ALTER TABLE public.lime_participants OWNER TO umfragepiratenndsde; -- -- TOC entry 175 (class 1259 OID 18479) -- Dependencies: 2060 5 -- Name: lime_question_attributes; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_question_attributes ( qaid integer NOT NULL, qid integer DEFAULT 0 NOT NULL, attribute character varying(50), value text, language character varying(20) ); ALTER TABLE public.lime_question_attributes OWNER TO umfragepiratenndsde; -- -- TOC entry 174 (class 1259 OID 18477) -- Dependencies: 5 175 -- Name: lime_question_attributes_qaid_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_question_attributes_qaid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_question_attributes_qaid_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2290 (class 0 OID 0) -- Dependencies: 174 -- Name: lime_question_attributes_qaid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_question_attributes_qaid_seq OWNED BY lime_question_attributes.qaid; -- -- TOC entry 2291 (class 0 OID 0) -- Dependencies: 174 -- Name: lime_question_attributes_qaid_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_question_attributes_qaid_seq', 1, false); -- -- TOC entry 183 (class 1259 OID 18524) -- Dependencies: 2069 2070 2071 2072 2073 2074 2075 2076 2077 5 -- Name: lime_questions; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_questions ( qid integer NOT NULL, parent_qid integer DEFAULT 0 NOT NULL, sid integer DEFAULT 0 NOT NULL, gid integer DEFAULT 0 NOT NULL, type character(1) DEFAULT 'T'::bpchar NOT NULL, title character varying(20) DEFAULT ''::character varying NOT NULL, question text NOT NULL, preg text, help text, other character(1) DEFAULT 'N'::bpchar NOT NULL, mandatory character(1), question_order integer NOT NULL, language character varying(20) DEFAULT 'en'::character varying NOT NULL, scale_id smallint DEFAULT 0 NOT NULL, same_default smallint DEFAULT 0 NOT NULL, relevance text ); ALTER TABLE public.lime_questions OWNER TO umfragepiratenndsde; -- -- TOC entry 182 (class 1259 OID 18522) -- Dependencies: 5 183 -- Name: lime_questions_qid_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_questions_qid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_questions_qid_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2292 (class 0 OID 0) -- Dependencies: 182 -- Name: lime_questions_qid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_questions_qid_seq OWNED BY lime_questions.qid; -- -- TOC entry 2293 (class 0 OID 0) -- Dependencies: 182 -- Name: lime_questions_qid_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_questions_qid_seq', 1, false); -- -- TOC entry 177 (class 1259 OID 18491) -- Dependencies: 2062 2063 5 -- Name: lime_quota; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_quota ( id integer NOT NULL, sid integer, name character varying(255), qlimit integer, action integer, active integer DEFAULT 1 NOT NULL, autoload_url integer DEFAULT 0 NOT NULL ); ALTER TABLE public.lime_quota OWNER TO umfragepiratenndsde; -- -- TOC entry 176 (class 1259 OID 18489) -- Dependencies: 177 5 -- Name: lime_quota_id_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_quota_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_quota_id_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2294 (class 0 OID 0) -- Dependencies: 176 -- Name: lime_quota_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_quota_id_seq OWNED BY lime_quota.id; -- -- TOC entry 2295 (class 0 OID 0) -- Dependencies: 176 -- Name: lime_quota_id_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_quota_id_seq', 1, false); -- -- TOC entry 179 (class 1259 OID 18501) -- Dependencies: 2065 2066 5 -- Name: lime_quota_languagesettings; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_quota_languagesettings ( quotals_id integer NOT NULL, quotals_quota_id integer DEFAULT 0 NOT NULL, quotals_language character varying(45) DEFAULT 'en'::character varying NOT NULL, quotals_name character varying(200), quotals_message text NOT NULL, quotals_url character varying(255), quotals_urldescrip character varying(255) ); ALTER TABLE public.lime_quota_languagesettings OWNER TO umfragepiratenndsde; -- -- TOC entry 178 (class 1259 OID 18499) -- Dependencies: 5 179 -- Name: lime_quota_languagesettings_quotals_id_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_quota_languagesettings_quotals_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_quota_languagesettings_quotals_id_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2296 (class 0 OID 0) -- Dependencies: 178 -- Name: lime_quota_languagesettings_quotals_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_quota_languagesettings_quotals_id_seq OWNED BY lime_quota_languagesettings.quotals_id; -- -- TOC entry 2297 (class 0 OID 0) -- Dependencies: 178 -- Name: lime_quota_languagesettings_quotals_id_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_quota_languagesettings_quotals_id_seq', 1, false); -- -- TOC entry 181 (class 1259 OID 18515) -- Dependencies: 5 -- Name: lime_quota_members; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_quota_members ( id integer NOT NULL, sid integer, qid integer, quota_id integer, code character varying(11) ); ALTER TABLE public.lime_quota_members OWNER TO umfragepiratenndsde; -- -- TOC entry 180 (class 1259 OID 18513) -- Dependencies: 5 181 -- Name: lime_quota_members_id_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_quota_members_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_quota_members_id_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2298 (class 0 OID 0) -- Dependencies: 180 -- Name: lime_quota_members_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_quota_members_id_seq OWNED BY lime_quota_members.id; -- -- TOC entry 2299 (class 0 OID 0) -- Dependencies: 180 -- Name: lime_quota_members_id_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_quota_members_id_seq', 1, false); -- -- TOC entry 185 (class 1259 OID 18544) -- Dependencies: 2079 2080 2081 5 -- Name: lime_saved_control; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_saved_control ( scid integer NOT NULL, sid integer DEFAULT 0 NOT NULL, srid integer DEFAULT 0 NOT NULL, identifier text, access_code text NOT NULL, email character varying(320) NOT NULL, ip text NOT NULL, saved_thisstep text NOT NULL, status character(1) DEFAULT ''::bpchar NOT NULL, saved_date timestamp without time zone NOT NULL, refurl text ); ALTER TABLE public.lime_saved_control OWNER TO umfragepiratenndsde; -- -- TOC entry 184 (class 1259 OID 18542) -- Dependencies: 185 5 -- Name: lime_saved_control_scid_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_saved_control_scid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_saved_control_scid_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2300 (class 0 OID 0) -- Dependencies: 184 -- Name: lime_saved_control_scid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_saved_control_scid_seq OWNED BY lime_saved_control.scid; -- -- TOC entry 2301 (class 0 OID 0) -- Dependencies: 184 -- Name: lime_saved_control_scid_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_saved_control_scid_seq', 1, false); -- -- TOC entry 186 (class 1259 OID 18556) -- Dependencies: 2082 2083 2084 5 -- Name: lime_sessions; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_sessions ( sesskey character varying(64) DEFAULT ''::character varying NOT NULL, expiry timestamp without time zone NOT NULL, expireref character varying(250) DEFAULT ''::character varying, created timestamp without time zone NOT NULL, modified timestamp without time zone NOT NULL, sessdata text DEFAULT ''::text ); ALTER TABLE public.lime_sessions OWNER TO umfragepiratenndsde; -- -- TOC entry 187 (class 1259 OID 18569) -- Dependencies: 2085 2086 5 -- Name: lime_settings_global; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_settings_global ( stg_name character varying(50) DEFAULT ''::character varying NOT NULL, stg_value character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.lime_settings_global OWNER TO umfragepiratenndsde; -- -- TOC entry 205 (class 1259 OID 18730) -- Dependencies: 5 -- Name: lime_survey_links; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_survey_links ( participant_id character varying(50) NOT NULL, token_id integer NOT NULL, survey_id integer NOT NULL, date_created date NOT NULL ); ALTER TABLE public.lime_survey_links OWNER TO umfragepiratenndsde; -- -- TOC entry 190 (class 1259 OID 18632) -- Dependencies: 2127 2128 2129 2130 2131 2132 2133 2134 5 -- Name: lime_survey_permissions; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_survey_permissions ( sid integer DEFAULT 0 NOT NULL, uid integer DEFAULT 0 NOT NULL, permission character varying(20) NOT NULL, create_p integer DEFAULT 0 NOT NULL, read_p integer DEFAULT 0 NOT NULL, update_p integer DEFAULT 0 NOT NULL, delete_p integer DEFAULT 0 NOT NULL, import_p integer DEFAULT 0 NOT NULL, export_p integer DEFAULT 0 NOT NULL ); ALTER TABLE public.lime_survey_permissions OWNER TO umfragepiratenndsde; -- -- TOC entry 188 (class 1259 OID 18576) -- Dependencies: 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 5 -- Name: lime_surveys; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_surveys ( sid integer NOT NULL, owner_id integer NOT NULL, admin character varying(50), active character(1) DEFAULT 'N'::bpchar NOT NULL, startdate timestamp without time zone, expires timestamp without time zone, adminemail character varying(320) NOT NULL, anonymized character(1) DEFAULT 'N'::bpchar NOT NULL, faxto character varying(20), format character(1), savetimings character(1) DEFAULT 'N'::bpchar, template character varying(100) DEFAULT 'default'::character varying, language character varying(50), additional_languages character varying(255), datestamp character(1) DEFAULT 'N'::bpchar, usecookie character(1) DEFAULT 'N'::bpchar, allowregister character(1) DEFAULT 'N'::bpchar, allowsave character(1) DEFAULT 'Y'::bpchar, printanswers character(1) DEFAULT 'N'::bpchar, autonumber_start integer DEFAULT 0, autoredirect character(1) DEFAULT 'N'::bpchar, showxquestions character(1) DEFAULT 'Y'::bpchar, showgroupinfo character(1) DEFAULT 'B'::bpchar, shownoanswer character(1) DEFAULT 'Y'::bpchar, showqnumcode character(1) DEFAULT 'X'::bpchar, showwelcome character(1) DEFAULT 'Y'::bpchar, allowprev character(1) DEFAULT 'Y'::bpchar, ipaddr character(1) DEFAULT 'N'::bpchar, refurl character(1) DEFAULT 'N'::bpchar, datecreated date, listpublic character(1) DEFAULT 'N'::bpchar, publicstatistics character(1) DEFAULT 'N'::bpchar, publicgraphs character(1) DEFAULT 'N'::bpchar, htmlemail character(1) DEFAULT 'N'::bpchar, tokenanswerspersistence character(1) DEFAULT 'N'::bpchar, assessments character(1) DEFAULT 'N'::bpchar, usecaptcha character(1) DEFAULT 'N'::bpchar, bouncetime bigint, bounceprocessing character(1) DEFAULT 'N'::bpchar, bounceaccounttype character(4), bounceaccounthost character(200), bounceaccountuser character(200), bounceaccountpass character(100), bounceaccountencryption character(3), usetokens character(1) DEFAULT 'N'::bpchar, bounce_email character varying(320) NOT NULL, attributedescriptions text, emailresponseto text, emailnotificationto text, tokenlength smallint DEFAULT 15::smallint, showprogress character(1) DEFAULT 'N'::bpchar, allowjumps character(1) DEFAULT 'N'::bpchar, navigationdelay smallint DEFAULT 0::smallint, nokeyboard character(1) DEFAULT 'N'::bpchar, alloweditaftercompletion character(1) DEFAULT 'N'::bpchar, googleanalyticsstyle character(1) DEFAULT NULL::bpchar, googleanalyticsapikey character varying(25) DEFAULT NULL::character varying ); ALTER TABLE public.lime_surveys OWNER TO umfragepiratenndsde; -- -- TOC entry 189 (class 1259 OID 18620) -- Dependencies: 2123 2124 2125 2126 5 -- Name: lime_surveys_languagesettings; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_surveys_languagesettings ( surveyls_survey_id integer DEFAULT 0 NOT NULL, surveyls_language character varying(45) DEFAULT 'en'::character varying NOT NULL, surveyls_title character varying(200) NOT NULL, surveyls_description text, surveyls_welcometext text, surveyls_url character varying(255), surveyls_urldescription character varying(255), surveyls_endtext text, surveyls_email_invite_subj character varying(255), surveyls_email_invite text, surveyls_email_remind_subj character varying(255), surveyls_email_remind text, surveyls_email_register_subj character varying(255), surveyls_email_register text, surveyls_email_confirm_subj character varying(255), surveyls_email_confirm text, surveyls_dateformat integer DEFAULT 1 NOT NULL, email_admin_notification_subj character varying(255), email_admin_notification text, email_admin_responses_subj character varying(255), email_admin_responses text, surveyls_numberformat integer DEFAULT 1 NOT NULL ); ALTER TABLE public.lime_surveys_languagesettings OWNER TO umfragepiratenndsde; -- -- TOC entry 206 (class 1259 OID 18735) -- Dependencies: 5 -- Name: lime_templates; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_templates ( folder character varying(255) NOT NULL, creator integer NOT NULL ); ALTER TABLE public.lime_templates OWNER TO umfragepiratenndsde; -- -- TOC entry 196 (class 1259 OID 18685) -- Dependencies: 5 -- Name: lime_templates_rights; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_templates_rights ( uid integer NOT NULL, folder character varying(255) NOT NULL, use integer NOT NULL ); ALTER TABLE public.lime_templates_rights OWNER TO umfragepiratenndsde; -- -- TOC entry 192 (class 1259 OID 18647) -- Dependencies: 5 -- Name: lime_user_groups; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_user_groups ( ugid integer NOT NULL, name character varying(20) NOT NULL, description text NOT NULL, owner_id integer NOT NULL ); ALTER TABLE public.lime_user_groups OWNER TO umfragepiratenndsde; -- -- TOC entry 191 (class 1259 OID 18645) -- Dependencies: 192 5 -- Name: lime_user_groups_ugid_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_user_groups_ugid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_user_groups_ugid_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2302 (class 0 OID 0) -- Dependencies: 191 -- Name: lime_user_groups_ugid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_user_groups_ugid_seq OWNED BY lime_user_groups.ugid; -- -- TOC entry 2303 (class 0 OID 0) -- Dependencies: 191 -- Name: lime_user_groups_ugid_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_user_groups_ugid_seq', 1, false); -- -- TOC entry 193 (class 1259 OID 18654) -- Dependencies: 5 -- Name: lime_user_in_groups; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_user_in_groups ( ugid integer NOT NULL, uid integer NOT NULL ); ALTER TABLE public.lime_user_in_groups OWNER TO umfragepiratenndsde; -- -- TOC entry 195 (class 1259 OID 18661) -- Dependencies: 2137 2138 2139 2140 2141 2142 2143 2144 2145 2146 2147 2148 2149 5 -- Name: lime_users; Type: TABLE; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE TABLE lime_users ( uid integer NOT NULL, users_name character varying(64) DEFAULT ''::character varying NOT NULL, password bytea NOT NULL, full_name character varying(50) NOT NULL, parent_id integer NOT NULL, lang character varying(20), email character varying(320) NOT NULL, create_survey integer DEFAULT 0 NOT NULL, create_user integer DEFAULT 0 NOT NULL, participant_panel integer DEFAULT 0 NOT NULL, delete_user integer DEFAULT 0 NOT NULL, superadmin integer DEFAULT 0 NOT NULL, configurator integer DEFAULT 0 NOT NULL, manage_template integer DEFAULT 0 NOT NULL, manage_label integer DEFAULT 0 NOT NULL, htmleditormode character(7) DEFAULT 'default'::bpchar, templateeditormode character(7) DEFAULT 'default'::bpchar, questionselectormode character(7) DEFAULT 'default'::bpchar, one_time_pw bytea, dateformat integer DEFAULT 1 NOT NULL ); ALTER TABLE public.lime_users OWNER TO umfragepiratenndsde; -- -- TOC entry 194 (class 1259 OID 18659) -- Dependencies: 195 5 -- Name: lime_users_uid_seq; Type: SEQUENCE; Schema: public; Owner: umfragepiratenndsde -- CREATE SEQUENCE lime_users_uid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.lime_users_uid_seq OWNER TO umfragepiratenndsde; -- -- TOC entry 2304 (class 0 OID 0) -- Dependencies: 194 -- Name: lime_users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: umfragepiratenndsde -- ALTER SEQUENCE lime_users_uid_seq OWNED BY lime_users.uid; -- -- TOC entry 2305 (class 0 OID 0) -- Dependencies: 194 -- Name: lime_users_uid_seq; Type: SEQUENCE SET; Schema: public; Owner: umfragepiratenndsde -- SELECT pg_catalog.setval('lime_users_uid_seq', 1, true); -- -- TOC entry 2026 (class 2604 OID 18388) -- Dependencies: 162 163 163 -- Name: id; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_assessments ALTER COLUMN id SET DEFAULT nextval('lime_assessments_id_seq'::regclass); -- -- TOC entry 2033 (class 2604 OID 18405) -- Dependencies: 164 165 165 -- Name: cid; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_conditions ALTER COLUMN cid SET DEFAULT nextval('lime_conditions_cid_seq'::regclass); -- -- TOC entry 2044 (class 2604 OID 18431) -- Dependencies: 168 167 168 -- Name: id; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_expression_errors ALTER COLUMN id SET DEFAULT nextval('lime_expression_errors_id_seq'::regclass); -- -- TOC entry 2156 (class 2604 OID 18745) -- Dependencies: 207 208 208 -- Name: id; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_failed_login_attempts ALTER COLUMN id SET DEFAULT nextval('lime_failed_login_attempts_id_seq'::regclass); -- -- TOC entry 2046 (class 2604 OID 18443) -- Dependencies: 170 169 170 -- Name: gid; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_groups ALTER COLUMN gid SET DEFAULT nextval('lime_groups_gid_seq'::regclass); -- -- TOC entry 2056 (class 2604 OID 18472) -- Dependencies: 173 172 173 -- Name: lid; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_labelsets ALTER COLUMN lid SET DEFAULT nextval('lime_labelsets_lid_seq'::regclass); -- -- TOC entry 2154 (class 2604 OID 18709) -- Dependencies: 200 199 200 -- Name: attribute_id; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_participant_attribute_names ALTER COLUMN attribute_id SET DEFAULT nextval('lime_participant_attribute_names_attribute_id_seq'::regclass); -- -- TOC entry 2155 (class 2604 OID 18722) -- Dependencies: 202 203 203 -- Name: value_id; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_participant_attribute_values ALTER COLUMN value_id SET DEFAULT nextval('lime_participant_attribute_values_value_id_seq'::regclass); -- -- TOC entry 2059 (class 2604 OID 18482) -- Dependencies: 174 175 175 -- Name: qaid; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_question_attributes ALTER COLUMN qaid SET DEFAULT nextval('lime_question_attributes_qaid_seq'::regclass); -- -- TOC entry 2068 (class 2604 OID 18527) -- Dependencies: 182 183 183 -- Name: qid; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_questions ALTER COLUMN qid SET DEFAULT nextval('lime_questions_qid_seq'::regclass); -- -- TOC entry 2061 (class 2604 OID 18494) -- Dependencies: 177 176 177 -- Name: id; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_quota ALTER COLUMN id SET DEFAULT nextval('lime_quota_id_seq'::regclass); -- -- TOC entry 2064 (class 2604 OID 18504) -- Dependencies: 179 178 179 -- Name: quotals_id; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_quota_languagesettings ALTER COLUMN quotals_id SET DEFAULT nextval('lime_quota_languagesettings_quotals_id_seq'::regclass); -- -- TOC entry 2067 (class 2604 OID 18518) -- Dependencies: 181 180 181 -- Name: id; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_quota_members ALTER COLUMN id SET DEFAULT nextval('lime_quota_members_id_seq'::regclass); -- -- TOC entry 2078 (class 2604 OID 18547) -- Dependencies: 185 184 185 -- Name: scid; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_saved_control ALTER COLUMN scid SET DEFAULT nextval('lime_saved_control_scid_seq'::regclass); -- -- TOC entry 2135 (class 2604 OID 18650) -- Dependencies: 191 192 192 -- Name: ugid; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_user_groups ALTER COLUMN ugid SET DEFAULT nextval('lime_user_groups_ugid_seq'::regclass); -- -- TOC entry 2136 (class 2604 OID 18664) -- Dependencies: 195 194 195 -- Name: uid; Type: DEFAULT; Schema: public; Owner: umfragepiratenndsde -- ALTER TABLE ONLY lime_users ALTER COLUMN uid SET DEFAULT nextval('lime_users_uid_seq'::regclass); -- -- TOC entry 2236 (class 0 OID 18370) -- Dependencies: 161 -- Data for Name: lime_answers; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_answers (qid, code, answer, sortorder, assessment_value, language, scale_id) FROM stdin; \. -- -- TOC entry 2237 (class 0 OID 18385) -- Dependencies: 163 -- Data for Name: lime_assessments; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_assessments (id, sid, scope, gid, name, minimum, maximum, message, language) FROM stdin; \. -- -- TOC entry 2238 (class 0 OID 18402) -- Dependencies: 165 -- Data for Name: lime_conditions; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_conditions (cid, qid, scenario, cqid, cfieldname, method, value) FROM stdin; \. -- -- TOC entry 2239 (class 0 OID 18414) -- Dependencies: 166 -- Data for Name: lime_defaultvalues; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_defaultvalues (qid, scale_id, sqid, language, specialtype, defaultvalue) FROM stdin; \. -- -- TOC entry 2240 (class 0 OID 18428) -- Dependencies: 168 -- Data for Name: lime_expression_errors; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_expression_errors (id, errortime, sid, gid, qid, gseq, qseq, type, eqn, prettyprint) FROM stdin; \. -- -- TOC entry 2267 (class 0 OID 18742) -- Dependencies: 208 -- Data for Name: lime_failed_login_attempts; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_failed_login_attempts (id, ip, last_attempt, number_attempts) FROM stdin; 2 192.168.1.11 2012-06-16 16:39:50 2 \. -- -- TOC entry 2241 (class 0 OID 18440) -- Dependencies: 170 -- Data for Name: lime_groups; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_groups (gid, sid, group_name, group_order, description, language, randomization_group, grelevance) FROM stdin; \. -- -- TOC entry 2242 (class 0 OID 18454) -- Dependencies: 171 -- Data for Name: lime_labels; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_labels (lid, code, title, sortorder, assessment_value, language) FROM stdin; \. -- -- TOC entry 2243 (class 0 OID 18469) -- Dependencies: 173 -- Data for Name: lime_labelsets; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_labelsets (lid, label_name, languages) FROM stdin; \. -- -- TOC entry 2260 (class 0 OID 18699) -- Dependencies: 198 -- Data for Name: lime_participant_attribute; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_participant_attribute (participant_id, attribute_id, value) FROM stdin; \. -- -- TOC entry 2261 (class 0 OID 18706) -- Dependencies: 200 -- Data for Name: lime_participant_attribute_names; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_participant_attribute_names (attribute_id, attribute_type, visible) FROM stdin; \. -- -- TOC entry 2262 (class 0 OID 18712) -- Dependencies: 201 -- Data for Name: lime_participant_attribute_names_lang; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_participant_attribute_names_lang (id, attribute_id, attribute_name, lang) FROM stdin; \. -- -- TOC entry 2263 (class 0 OID 18719) -- Dependencies: 203 -- Data for Name: lime_participant_attribute_values; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_participant_attribute_values (value_id, attribute_id, value) FROM stdin; \. -- -- TOC entry 2264 (class 0 OID 18725) -- Dependencies: 204 -- Data for Name: lime_participant_shares; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_participant_shares (participant_id, share_uid, date_added, can_edit) FROM stdin; \. -- -- TOC entry 2259 (class 0 OID 18690) -- Dependencies: 197 -- Data for Name: lime_participants; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_participants (participant_id, firstname, lastname, email, language, blacklisted, owner_uid) FROM stdin; \. -- -- TOC entry 2244 (class 0 OID 18479) -- Dependencies: 175 -- Data for Name: lime_question_attributes; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_question_attributes (qaid, qid, attribute, value, language) FROM stdin; \. -- -- TOC entry 2248 (class 0 OID 18524) -- Dependencies: 183 -- Data for Name: lime_questions; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_questions (qid, parent_qid, sid, gid, type, title, question, preg, help, other, mandatory, question_order, language, scale_id, same_default, relevance) FROM stdin; \. -- -- TOC entry 2245 (class 0 OID 18491) -- Dependencies: 177 -- Data for Name: lime_quota; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_quota (id, sid, name, qlimit, action, active, autoload_url) FROM stdin; \. -- -- TOC entry 2246 (class 0 OID 18501) -- Dependencies: 179 -- Data for Name: lime_quota_languagesettings; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_quota_languagesettings (quotals_id, quotals_quota_id, quotals_language, quotals_name, quotals_message, quotals_url, quotals_urldescrip) FROM stdin; \. -- -- TOC entry 2247 (class 0 OID 18515) -- Dependencies: 181 -- Data for Name: lime_quota_members; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_quota_members (id, sid, qid, quota_id, code) FROM stdin; \. -- -- TOC entry 2249 (class 0 OID 18544) -- Dependencies: 185 -- Data for Name: lime_saved_control; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_saved_control (scid, sid, srid, identifier, access_code, email, ip, saved_thisstep, status, saved_date, refurl) FROM stdin; \. -- -- TOC entry 2250 (class 0 OID 18556) -- Dependencies: 186 -- Data for Name: lime_sessions; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_sessions (sesskey, expiry, expireref, created, modified, sessdata) FROM stdin; \. -- -- TOC entry 2251 (class 0 OID 18569) -- Dependencies: 187 -- Data for Name: lime_settings_global; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_settings_global (stg_name, stg_value) FROM stdin; DBVersion 155.5 SessionName ls98461912613374144583 force_ssl showxquestions choose showgroupinfo choose showqnumcode choose updateavailable 0 updatelastcheck 2012-06-16 16:05:33 \. -- -- TOC entry 2265 (class 0 OID 18730) -- Dependencies: 205 -- Data for Name: lime_survey_links; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_survey_links (participant_id, token_id, survey_id, date_created) FROM stdin; \. -- -- TOC entry 2254 (class 0 OID 18632) -- Dependencies: 190 -- Data for Name: lime_survey_permissions; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_survey_permissions (sid, uid, permission, create_p, read_p, update_p, delete_p, import_p, export_p) FROM stdin; \. -- -- TOC entry 2252 (class 0 OID 18576) -- Dependencies: 188 -- Data for Name: lime_surveys; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_surveys (sid, owner_id, admin, active, startdate, expires, adminemail, anonymized, faxto, format, savetimings, template, language, additional_languages, datestamp, usecookie, allowregister, allowsave, printanswers, autonumber_start, autoredirect, showxquestions, showgroupinfo, shownoanswer, showqnumcode, showwelcome, allowprev, ipaddr, refurl, datecreated, listpublic, publicstatistics, publicgraphs, htmlemail, tokenanswerspersistence, assessments, usecaptcha, bouncetime, bounceprocessing, bounceaccounttype, bounceaccounthost, bounceaccountuser, bounceaccountpass, bounceaccountencryption, usetokens, bounce_email, attributedescriptions, emailresponseto, emailnotificationto, tokenlength, showprogress, allowjumps, navigationdelay, nokeyboard, alloweditaftercompletion, googleanalyticsstyle, googleanalyticsapikey) FROM stdin; \. -- -- TOC entry 2253 (class 0 OID 18620) -- Dependencies: 189 -- Data for Name: lime_surveys_languagesettings; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_surveys_languagesettings (surveyls_survey_id, surveyls_language, surveyls_title, surveyls_description, surveyls_welcometext, surveyls_url, surveyls_urldescription, surveyls_endtext, surveyls_email_invite_subj, surveyls_email_invite, surveyls_email_remind_subj, surveyls_email_remind, surveyls_email_register_subj, surveyls_email_register, surveyls_email_confirm_subj, surveyls_email_confirm, surveyls_dateformat, email_admin_notification_subj, email_admin_notification, email_admin_responses_subj, email_admin_responses, surveyls_numberformat) FROM stdin; \. -- -- TOC entry 2266 (class 0 OID 18735) -- Dependencies: 206 -- Data for Name: lime_templates; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_templates (folder, creator) FROM stdin; \. -- -- TOC entry 2258 (class 0 OID 18685) -- Dependencies: 196 -- Data for Name: lime_templates_rights; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_templates_rights (uid, folder, use) FROM stdin; \. -- -- TOC entry 2255 (class 0 OID 18647) -- Dependencies: 192 -- Data for Name: lime_user_groups; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_user_groups (ugid, name, description, owner_id) FROM stdin; \. -- -- TOC entry 2256 (class 0 OID 18654) -- Dependencies: 193 -- Data for Name: lime_user_in_groups; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_user_in_groups (ugid, uid) FROM stdin; \. -- -- TOC entry 2257 (class 0 OID 18661) -- Dependencies: 195 -- Data for Name: lime_users; Type: TABLE DATA; Schema: public; Owner: umfragepiratenndsde -- COPY lime_users (uid, users_name, password, full_name, parent_id, lang, email, create_survey, create_user, participant_panel, delete_user, superadmin, configurator, manage_template, manage_label, htmleditormode, templateeditormode, questionselectormode, one_time_pw, dateformat) FROM stdin; 1 admin \\x35653838343839386461323830343731353164306535366638646336323932373733363033643064366161626264643632613131656637323164313534326438 Your Name 0 en your-email@example.net 1 1 0 1 1 1 1 1 default default default \N 1 \. -- -- TOC entry 2158 (class 2606 OID 18382) -- Dependencies: 161 161 161 161 161 -- Name: lime_answers_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_answers ADD CONSTRAINT lime_answers_pkey PRIMARY KEY (qid, code, language, scale_id); -- -- TOC entry 2162 (class 2606 OID 18399) -- Dependencies: 163 163 163 -- Name: lime_assessments_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_assessments ADD CONSTRAINT lime_assessments_pkey PRIMARY KEY (id, language); -- -- TOC entry 2165 (class 2606 OID 18413) -- Dependencies: 165 165 -- Name: lime_conditions_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_conditions ADD CONSTRAINT lime_conditions_pkey PRIMARY KEY (cid); -- -- TOC entry 2167 (class 2606 OID 18425) -- Dependencies: 166 166 166 166 166 166 -- Name: lime_defaultvalues_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_defaultvalues ADD CONSTRAINT lime_defaultvalues_pkey PRIMARY KEY (qid, scale_id, language, specialtype, sqid); -- -- TOC entry 2169 (class 2606 OID 18437) -- Dependencies: 168 168 -- Name: lime_expression_errors_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_expression_errors ADD CONSTRAINT lime_expression_errors_pkey PRIMARY KEY (id); -- -- TOC entry 2235 (class 2606 OID 18747) -- Dependencies: 208 208 -- Name: lime_failed_login_attempts_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_failed_login_attempts ADD CONSTRAINT lime_failed_login_attempts_pkey PRIMARY KEY (id); -- -- TOC entry 2172 (class 2606 OID 18453) -- Dependencies: 170 170 170 -- Name: lime_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_groups ADD CONSTRAINT lime_groups_pkey PRIMARY KEY (gid, language); -- -- TOC entry 2175 (class 2606 OID 18465) -- Dependencies: 171 171 171 171 -- Name: lime_labels_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_labels ADD CONSTRAINT lime_labels_pkey PRIMARY KEY (lid, sortorder, language); -- -- TOC entry 2177 (class 2606 OID 18476) -- Dependencies: 173 173 -- Name: lime_labelsets_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_labelsets ADD CONSTRAINT lime_labelsets_pkey PRIMARY KEY (lid); -- -- TOC entry 2221 (class 2606 OID 18703) -- Dependencies: 198 198 198 -- Name: lime_participant_attribut_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_participant_attribute ADD CONSTRAINT lime_participant_attribut_pkey PRIMARY KEY (participant_id, attribute_id); -- -- TOC entry 2225 (class 2606 OID 18716) -- Dependencies: 201 201 201 -- Name: lime_participant_attribute_names_lang_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_participant_attribute_names_lang ADD CONSTRAINT lime_participant_attribute_names_lang_pkey PRIMARY KEY (attribute_id, lang); -- -- TOC entry 2223 (class 2606 OID 18711) -- Dependencies: 200 200 200 -- Name: lime_participant_attribute_names_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_participant_attribute_names ADD CONSTRAINT lime_participant_attribute_names_pkey PRIMARY KEY (attribute_id, attribute_type); -- -- TOC entry 2227 (class 2606 OID 18724) -- Dependencies: 203 203 -- Name: lime_participant_attribute_values_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_participant_attribute_values ADD CONSTRAINT lime_participant_attribute_values_pkey PRIMARY KEY (value_id); -- -- TOC entry 2229 (class 2606 OID 18729) -- Dependencies: 204 204 204 -- Name: lime_participant_shares_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_participant_shares ADD CONSTRAINT lime_participant_shares_pkey PRIMARY KEY (participant_id, share_uid); -- -- TOC entry 2219 (class 2606 OID 18698) -- Dependencies: 197 197 -- Name: lime_participants_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_participants ADD CONSTRAINT lime_participants_pkey PRIMARY KEY (participant_id); -- -- TOC entry 2179 (class 2606 OID 18488) -- Dependencies: 175 175 -- Name: lime_question_attributes_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_question_attributes ADD CONSTRAINT lime_question_attributes_pkey PRIMARY KEY (qaid); -- -- TOC entry 2191 (class 2606 OID 18541) -- Dependencies: 183 183 183 -- Name: lime_questions_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_questions ADD CONSTRAINT lime_questions_pkey PRIMARY KEY (qid, language); -- -- TOC entry 2186 (class 2606 OID 18511) -- Dependencies: 179 179 -- Name: lime_quota_languagesettings_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_quota_languagesettings ADD CONSTRAINT lime_quota_languagesettings_pkey PRIMARY KEY (quotals_id); -- -- TOC entry 2189 (class 2606 OID 18520) -- Dependencies: 181 181 -- Name: lime_quota_members_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_quota_members ADD CONSTRAINT lime_quota_members_pkey PRIMARY KEY (id); -- -- TOC entry 2183 (class 2606 OID 18498) -- Dependencies: 177 177 -- Name: lime_quota_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_quota ADD CONSTRAINT lime_quota_pkey PRIMARY KEY (id); -- -- TOC entry 2196 (class 2606 OID 18555) -- Dependencies: 185 185 -- Name: lime_saved_control_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_saved_control ADD CONSTRAINT lime_saved_control_pkey PRIMARY KEY (scid); -- -- TOC entry 2199 (class 2606 OID 18566) -- Dependencies: 186 186 -- Name: lime_sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_sessions ADD CONSTRAINT lime_sessions_pkey PRIMARY KEY (sesskey); -- -- TOC entry 2203 (class 2606 OID 18575) -- Dependencies: 187 187 -- Name: lime_settings_global_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_settings_global ADD CONSTRAINT lime_settings_global_pkey PRIMARY KEY (stg_name); -- -- TOC entry 2231 (class 2606 OID 18734) -- Dependencies: 205 205 205 205 -- Name: lime_survey_links_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_survey_links ADD CONSTRAINT lime_survey_links_pkey PRIMARY KEY (participant_id, token_id, survey_id); -- -- TOC entry 2209 (class 2606 OID 18644) -- Dependencies: 190 190 190 190 -- Name: lime_survey_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_survey_permissions ADD CONSTRAINT lime_survey_permissions_pkey PRIMARY KEY (sid, uid, permission); -- -- TOC entry 2207 (class 2606 OID 18631) -- Dependencies: 189 189 189 -- Name: lime_surveys_languagesettings_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_surveys_languagesettings ADD CONSTRAINT lime_surveys_languagesettings_pkey PRIMARY KEY (surveyls_survey_id, surveyls_language); -- -- TOC entry 2205 (class 2606 OID 18619) -- Dependencies: 188 188 -- Name: lime_surveys_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_surveys ADD CONSTRAINT lime_surveys_pkey PRIMARY KEY (sid); -- -- TOC entry 2233 (class 2606 OID 18739) -- Dependencies: 206 206 -- Name: lime_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_templates ADD CONSTRAINT lime_templates_pkey PRIMARY KEY (folder); -- -- TOC entry 2217 (class 2606 OID 18689) -- Dependencies: 196 196 196 -- Name: lime_templates_rights_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_templates_rights ADD CONSTRAINT lime_templates_rights_pkey PRIMARY KEY (uid, folder); -- -- TOC entry 2211 (class 2606 OID 18658) -- Dependencies: 193 193 193 -- Name: lime_user_in_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_user_in_groups ADD CONSTRAINT lime_user_in_groups_pkey PRIMARY KEY (ugid, uid); -- -- TOC entry 2213 (class 2606 OID 18682) -- Dependencies: 195 195 -- Name: lime_users_pkey; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_users ADD CONSTRAINT lime_users_pkey PRIMARY KEY (uid); -- -- TOC entry 2215 (class 2606 OID 18684) -- Dependencies: 195 195 -- Name: lime_users_users_name_key; Type: CONSTRAINT; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- ALTER TABLE ONLY lime_users ADD CONSTRAINT lime_users_users_name_key UNIQUE (users_name); -- -- TOC entry 2159 (class 1259 OID 18748) -- Dependencies: 163 -- Name: assessments_idx2; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX assessments_idx2 ON lime_assessments USING btree (sid); -- -- TOC entry 2160 (class 1259 OID 18749) -- Dependencies: 163 -- Name: assessments_idx3; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX assessments_idx3 ON lime_assessments USING btree (gid); -- -- TOC entry 2163 (class 1259 OID 18750) -- Dependencies: 165 -- Name: conditions_idx2; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX conditions_idx2 ON lime_conditions USING btree (qid); -- -- TOC entry 2170 (class 1259 OID 18751) -- Dependencies: 170 -- Name: groups_idx2; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX groups_idx2 ON lime_groups USING btree (sid); -- -- TOC entry 2173 (class 1259 OID 18466) -- Dependencies: 171 -- Name: lime_labels_ixcode_idx; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX lime_labels_ixcode_idx ON lime_labels USING btree (code); -- -- TOC entry 2187 (class 1259 OID 18521) -- Dependencies: 181 181 181 181 -- Name: lime_quota_members_ixcode_idx; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX lime_quota_members_ixcode_idx ON lime_quota_members USING btree (sid, qid, quota_id, code); -- -- TOC entry 2192 (class 1259 OID 18758) -- Dependencies: 183 -- Name: parent_qid_idx; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX parent_qid_idx ON lime_questions USING btree (parent_qid); -- -- TOC entry 2180 (class 1259 OID 18752) -- Dependencies: 175 -- Name: question_attributes_idx2; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX question_attributes_idx2 ON lime_question_attributes USING btree (qid); -- -- TOC entry 2181 (class 1259 OID 18753) -- Dependencies: 175 -- Name: question_attributes_idx3; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX question_attributes_idx3 ON lime_question_attributes USING btree (attribute); -- -- TOC entry 2193 (class 1259 OID 18754) -- Dependencies: 183 -- Name: questions_idx2; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX questions_idx2 ON lime_questions USING btree (sid); -- -- TOC entry 2194 (class 1259 OID 18755) -- Dependencies: 183 -- Name: questions_idx3; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX questions_idx3 ON lime_questions USING btree (gid); -- -- TOC entry 2184 (class 1259 OID 18756) -- Dependencies: 177 -- Name: quota_idx2; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX quota_idx2 ON lime_quota USING btree (sid); -- -- TOC entry 2197 (class 1259 OID 18757) -- Dependencies: 185 -- Name: saved_control_idx2; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX saved_control_idx2 ON lime_saved_control USING btree (sid); -- -- TOC entry 2200 (class 1259 OID 18568) -- Dependencies: 186 -- Name: sess_expireref; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX sess_expireref ON lime_sessions USING btree (expireref); -- -- TOC entry 2201 (class 1259 OID 18567) -- Dependencies: 186 -- Name: sess_expiry; Type: INDEX; Schema: public; Owner: umfragepiratenndsde; Tablespace: -- CREATE INDEX sess_expiry ON lime_sessions USING btree (expiry); -- -- TOC entry 2272 (class 0 OID 0) -- Dependencies: 5 -- 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; -- Completed on 2012-06-16 16:43:52 -- -- PostgreSQL database dump complete --