--
-- PostgreSQL database dump
--

-- Dumped from database version 10.6
-- Dumped by pg_dump version 10.6

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: limesurveyplayground; Type: SCHEMA; Schema: -; Owner: limesurveyplayground_admin
--

CREATE SCHEMA limesurveyplayground;


ALTER SCHEMA limesurveyplayground OWNER TO limesurveyplayground_admin;

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


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

CREATE EXTENSION IF NOT EXISTS adminpack WITH SCHEMA pg_catalog;


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

COMMENT ON EXTENSION adminpack IS 'administrative functions for PostgreSQL';


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

CREATE EXTENSION IF NOT EXISTS pg_stat_statements WITH SCHEMA public;


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

COMMENT ON EXTENSION pg_stat_statements IS 'track execution statistics of all SQL statements executed';


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

CREATE EXTENSION IF NOT EXISTS pgrowlocks WITH SCHEMA public;


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

COMMENT ON EXTENSION pgrowlocks IS 'show row-level locking information';


--
-- Name: function_args(character varying, character varying); Type: FUNCTION; Schema: public; Owner: advpg
--

CREATE FUNCTION public.function_args(funcname character varying, schema character varying, OUT pos integer, OUT direction character, OUT argname character varying, OUT datatype character varying) RETURNS SETOF record
    LANGUAGE plpgsql STABLE STRICT
    AS $$DECLARE
  rettype character varying;
  argtypes oidvector;
  allargtypes oid[];
  argmodes "char"[];
  argnames text[];
  mini integer;
  maxi integer;
BEGIN
  /* get object ID of function */
  SELECT INTO rettype, argtypes, allargtypes, argmodes, argnames
         CASE WHEN pg_proc.proretset THEN 'setof ' || pg_catalog.format_type(pg_proc.prorettype, NULL)
              ELSE pg_catalog.format_type(pg_proc.prorettype, NULL) END,
         pg_proc.proargtypes, pg_proc.proallargtypes, pg_proc.proargmodes, pg_proc.proargnames
    FROM pg_catalog.pg_proc
         JOIN pg_catalog.pg_namespace
         ON (pg_proc.pronamespace = pg_namespace.oid)
    WHERE pg_proc.prorettype <> 'pg_catalog.cstring'::pg_catalog.regtype
      AND (pg_proc.proargtypes[0] IS NULL
      OR   pg_proc.proargtypes[0] <> 'pg_catalog.cstring'::pg_catalog.regtype)
      AND NOT pg_proc.proisagg
      AND pg_proc.proname = funcname
      AND pg_namespace.nspname = schema
      AND pg_catalog.pg_function_is_visible(pg_proc.oid);

  /* bail out if not found */
  IF NOT FOUND THEN
    RETURN;
  END IF;

  /* return a row for the return value */
  pos := 0;
  direction := 'o'::char;
  argname := 'RETURN VALUE';
  datatype := rettype;
  RETURN NEXT;

  /* unfortunately allargtypes is NULL if there are no OUT parameters */
  IF allargtypes IS NULL THEN
    mini := array_lower(argtypes, 1); maxi := array_upper(argtypes, 1);
  ELSE
    mini := array_lower(allargtypes, 1); maxi := array_upper(allargtypes, 1);
  END IF;
  IF maxi < mini THEN RETURN; END IF;

  /* loop all the arguments */
  FOR i IN mini .. maxi LOOP
    pos := i - mini + 1;
    IF argnames IS NULL THEN
      argname := NULL;
    ELSE
      argname := argnames[pos];  -- always 1-based
    END IF;
    IF allargtypes IS NULL THEN
      direction := 'i'::char;
      datatype := pg_catalog.format_type(argtypes[i], NULL);
    ELSE
      direction := argmodes[i];
      datatype := pg_catalog.format_type(allargtypes[i], NULL);
    END IF;
    RETURN NEXT;
  END LOOP;

  RETURN;
END;$$;


ALTER FUNCTION public.function_args(funcname character varying, schema character varying, OUT pos integer, OUT direction character, OUT argname character varying, OUT datatype character varying) OWNER TO advpg;

--
-- Name: FUNCTION function_args(funcname character varying, schema character varying, OUT pos integer, OUT direction character, OUT argname character varying, OUT datatype character varying); Type: COMMENT; Schema: public; Owner: advpg
--

COMMENT ON FUNCTION public.function_args(funcname character varying, schema character varying, OUT pos integer, OUT direction character, OUT argname character varying, OUT datatype character varying) IS 'For a function name and schema, this procedure selects for each argument the following data:
- position in the argument list (0 for the return value)
- direction ''i'', ''o'', or ''b''
- name (NULL if not defined)
- data type';


--
-- Name: table_columns(character varying, character varying); Type: FUNCTION; Schema: public; Owner: advpg
--

CREATE FUNCTION public.table_columns(table_name character varying, schema_name character varying, OUT column_name character varying, OUT data_type character varying, OUT is_nullable boolean, OUT column_default character varying, OUT character_maximum_length integer, OUT numeric_precision integer, OUT numeric_scale integer, OUT primary_key_position integer) RETURNS SETOF record
    LANGUAGE sql STABLE STRICT
    AS $_$SELECT
  c.column_name, data_type, is_nullable='YES' as is_nullable,
  column_default, character_maximum_length,
  CASE WHEN 10=numeric_precision_radix
    THEN numeric_precision ELSE NULL END AS numeric_precision,
  CASE WHEN 10=numeric_precision_radix
    THEN numeric_scale ELSE NULL END AS numeric_scale,
  pk.ordinal_position AS primary_key_position
FROM (SELECT column_name, data_type, is_nullable, column_default,
             character_maximum_length, numeric_precision,
             numeric_precision_radix, numeric_scale, ordinal_position
      FROM information_schema.columns
      WHERE table_name=$1 AND table_schema=$2) AS c
  LEFT OUTER JOIN
     (SELECT kcu.column_name, kcu.ordinal_position
      FROM (SELECT table_name, table_schema, constraint_schema, constraint_name
            FROM information_schema.table_constraints
            WHERE constraint_type='PRIMARY KEY'
              AND table_name=$1 AND table_schema=$2) AS tc
        JOIN
           (SELECT table_name, table_schema, constraint_schema,
                   constraint_name, column_name, ordinal_position
            FROM information_schema.key_column_usage
            WHERE table_name=$1 AND table_schema=$2) AS kcu
        USING (table_name, table_schema, constraint_schema, constraint_name)) AS pk
  USING (column_name)
ORDER BY c.ordinal_position$_$;


ALTER FUNCTION public.table_columns(table_name character varying, schema_name character varying, OUT column_name character varying, OUT data_type character varying, OUT is_nullable boolean, OUT column_default character varying, OUT character_maximum_length integer, OUT numeric_precision integer, OUT numeric_scale integer, OUT primary_key_position integer) OWNER TO advpg;

--
-- Name: FUNCTION table_columns(table_name character varying, schema_name character varying, OUT column_name character varying, OUT data_type character varying, OUT is_nullable boolean, OUT column_default character varying, OUT character_maximum_length integer, OUT numeric_precision integer, OUT numeric_scale integer, OUT primary_key_position integer); Type: COMMENT; Schema: public; Owner: advpg
--

COMMENT ON FUNCTION public.table_columns(table_name character varying, schema_name character varying, OUT column_name character varying, OUT data_type character varying, OUT is_nullable boolean, OUT column_default character varying, OUT character_maximum_length integer, OUT numeric_precision integer, OUT numeric_scale integer, OUT primary_key_position integer) IS 'returns all columns for a table or view with their interesting properties';


SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: lime_answers; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_answers (
    qid integer NOT NULL,
    code character varying(5) 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 integer DEFAULT 0 NOT NULL
);


ALTER TABLE limesurveyplayground.lime_answers OWNER TO limesurveyplayground_admin;

--
-- Name: lime_assessments; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_assessments (
    id integer NOT NULL,
    sid integer DEFAULT 0 NOT NULL,
    scope character varying(5) NOT NULL,
    gid integer DEFAULT 0 NOT NULL,
    name text NOT NULL,
    minimum character varying(50) NOT NULL,
    maximum character varying(50) NOT NULL,
    message text NOT NULL,
    language character varying(20) DEFAULT 'en'::character varying NOT NULL
);


ALTER TABLE limesurveyplayground.lime_assessments OWNER TO limesurveyplayground_admin;

--
-- Name: lime_assessments_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_assessments_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_assessments_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_assessments_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_assessments_id_seq OWNED BY limesurveyplayground.lime_assessments.id;


--
-- Name: lime_asset_version; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_asset_version (
    id integer NOT NULL,
    path text NOT NULL,
    version integer NOT NULL
);


ALTER TABLE limesurveyplayground.lime_asset_version OWNER TO limesurveyplayground_admin;

--
-- Name: lime_asset_version_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_asset_version_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_asset_version_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_asset_version_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_asset_version_id_seq OWNED BY limesurveyplayground.lime_asset_version.id;


--
-- Name: lime_boxes; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_boxes (
    id integer NOT NULL,
    "position" integer,
    url text NOT NULL,
    title text NOT NULL,
    ico character varying(255),
    "desc" text NOT NULL,
    page text NOT NULL,
    usergroup integer NOT NULL
);


ALTER TABLE limesurveyplayground.lime_boxes OWNER TO limesurveyplayground_admin;

--
-- Name: lime_boxes_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_boxes_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_boxes_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_boxes_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_boxes_id_seq OWNED BY limesurveyplayground.lime_boxes.id;


--
-- Name: lime_conditions; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_conditions (
    cid integer NOT NULL,
    qid integer DEFAULT 0 NOT NULL,
    cqid integer DEFAULT 0 NOT NULL,
    cfieldname character varying(50) DEFAULT ''::character varying NOT NULL,
    method character varying(5) DEFAULT ''::character varying NOT NULL,
    value character varying(255) DEFAULT ''::character varying NOT NULL,
    scenario integer DEFAULT 1 NOT NULL
);


ALTER TABLE limesurveyplayground.lime_conditions OWNER TO limesurveyplayground_admin;

--
-- Name: lime_conditions_cid_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_conditions_cid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_conditions_cid_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_conditions_cid_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_conditions_cid_seq OWNED BY limesurveyplayground.lime_conditions.cid;


--
-- Name: lime_defaultvalues; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.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 limesurveyplayground.lime_defaultvalues OWNER TO limesurveyplayground_admin;

--
-- Name: lime_expression_errors; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_expression_errors (
    id integer NOT NULL,
    errortime character varying(50),
    sid integer,
    gid integer,
    qid integer,
    gseq integer,
    qseq integer,
    type character varying(50),
    eqn text,
    prettyprint text
);


ALTER TABLE limesurveyplayground.lime_expression_errors OWNER TO limesurveyplayground_admin;

--
-- Name: lime_expression_errors_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_expression_errors_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_expression_errors_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_expression_errors_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_expression_errors_id_seq OWNED BY limesurveyplayground.lime_expression_errors.id;


--
-- Name: lime_failed_login_attempts; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_failed_login_attempts (
    id integer NOT NULL,
    ip character varying(40) NOT NULL,
    last_attempt character varying(20) NOT NULL,
    number_attempts integer NOT NULL
);


ALTER TABLE limesurveyplayground.lime_failed_login_attempts OWNER TO limesurveyplayground_admin;

--
-- Name: lime_failed_login_attempts_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_failed_login_attempts_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_failed_login_attempts_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_failed_login_attempts_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_failed_login_attempts_id_seq OWNED BY limesurveyplayground.lime_failed_login_attempts.id;


--
-- Name: lime_groups; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.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 limesurveyplayground.lime_groups OWNER TO limesurveyplayground_admin;

--
-- Name: lime_groups_gid_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_groups_gid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_groups_gid_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_groups_gid_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_groups_gid_seq OWNED BY limesurveyplayground.lime_groups.gid;


--
-- Name: lime_labels; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_labels (
    id integer NOT NULL,
    lid integer DEFAULT 0 NOT NULL,
    code character varying(5) DEFAULT ''::character varying NOT NULL,
    title text,
    sortorder integer NOT NULL,
    language character varying(20) DEFAULT 'en'::character varying NOT NULL,
    assessment_value integer DEFAULT 0 NOT NULL
);


ALTER TABLE limesurveyplayground.lime_labels OWNER TO limesurveyplayground_admin;

--
-- Name: lime_labels_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_labels_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_labels_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_labels_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_labels_id_seq OWNED BY limesurveyplayground.lime_labels.id;


--
-- Name: lime_labelsets; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.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 limesurveyplayground.lime_labelsets OWNER TO limesurveyplayground_admin;

--
-- Name: lime_labelsets_lid_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_labelsets_lid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_labelsets_lid_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_labelsets_lid_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_labelsets_lid_seq OWNED BY limesurveyplayground.lime_labelsets.lid;


--
-- Name: lime_map_tutorial_users; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_map_tutorial_users (
    tid integer NOT NULL,
    uid integer NOT NULL,
    taken integer DEFAULT 1
);


ALTER TABLE limesurveyplayground.lime_map_tutorial_users OWNER TO limesurveyplayground_admin;

--
-- Name: lime_notifications; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_notifications (
    id integer NOT NULL,
    entity character varying(15) NOT NULL,
    entity_id integer NOT NULL,
    title character varying(255) NOT NULL,
    message text NOT NULL,
    status character varying(15) DEFAULT 'new'::character varying NOT NULL,
    importance integer DEFAULT 1 NOT NULL,
    display_class character varying(31) DEFAULT 'default'::character varying,
    hash character varying(64),
    created timestamp without time zone,
    first_read timestamp without time zone
);


ALTER TABLE limesurveyplayground.lime_notifications OWNER TO limesurveyplayground_admin;

--
-- Name: lime_notifications_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_notifications_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_notifications_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_notifications_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_notifications_id_seq OWNED BY limesurveyplayground.lime_notifications.id;


--
-- Name: lime_participant_attribute; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_participant_attribute (
    participant_id character varying(50) NOT NULL,
    attribute_id integer NOT NULL,
    value text NOT NULL
);


ALTER TABLE limesurveyplayground.lime_participant_attribute OWNER TO limesurveyplayground_admin;

--
-- Name: lime_participant_attribute_names; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_participant_attribute_names (
    attribute_id integer NOT NULL,
    attribute_type character varying(4) NOT NULL,
    defaultname character varying(255) NOT NULL,
    visible character varying(5) NOT NULL
);


ALTER TABLE limesurveyplayground.lime_participant_attribute_names OWNER TO limesurveyplayground_admin;

--
-- Name: lime_participant_attribute_names_attribute_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_participant_attribute_names_attribute_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_participant_attribute_names_attribute_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_participant_attribute_names_attribute_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_participant_attribute_names_attribute_id_seq OWNED BY limesurveyplayground.lime_participant_attribute_names.attribute_id;


--
-- Name: lime_participant_attribute_names_lang; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_participant_attribute_names_lang (
    attribute_id integer NOT NULL,
    attribute_name character varying(255) NOT NULL,
    lang character varying(20) NOT NULL
);


ALTER TABLE limesurveyplayground.lime_participant_attribute_names_lang OWNER TO limesurveyplayground_admin;

--
-- Name: lime_participant_attribute_values; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_participant_attribute_values (
    value_id integer NOT NULL,
    attribute_id integer NOT NULL,
    value text NOT NULL
);


ALTER TABLE limesurveyplayground.lime_participant_attribute_values OWNER TO limesurveyplayground_admin;

--
-- Name: lime_participant_attribute_values_value_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_participant_attribute_values_value_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_participant_attribute_values_value_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_participant_attribute_values_value_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_participant_attribute_values_value_id_seq OWNED BY limesurveyplayground.lime_participant_attribute_values.value_id;


--
-- Name: lime_participant_shares; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.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 limesurveyplayground.lime_participant_shares OWNER TO limesurveyplayground_admin;

--
-- Name: lime_participants; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_participants (
    participant_id character varying(50) NOT NULL,
    firstname character varying(150),
    lastname character varying(150),
    email text,
    language character varying(40),
    blacklisted character varying(1) NOT NULL,
    owner_uid integer NOT NULL,
    created_by integer NOT NULL,
    created timestamp without time zone,
    modified timestamp without time zone
);


ALTER TABLE limesurveyplayground.lime_participants OWNER TO limesurveyplayground_admin;

--
-- Name: lime_permissions; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_permissions (
    id integer NOT NULL,
    entity character varying(50) NOT NULL,
    entity_id integer NOT NULL,
    uid integer NOT NULL,
    permission character varying(100) 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 limesurveyplayground.lime_permissions OWNER TO limesurveyplayground_admin;

--
-- Name: lime_permissions_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_permissions_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_permissions_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_permissions_id_seq OWNED BY limesurveyplayground.lime_permissions.id;


--
-- Name: lime_plugin_settings; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_plugin_settings (
    id integer NOT NULL,
    plugin_id integer NOT NULL,
    model character varying(50),
    model_id integer,
    key character varying(50) NOT NULL,
    value text
);


ALTER TABLE limesurveyplayground.lime_plugin_settings OWNER TO limesurveyplayground_admin;

--
-- Name: lime_plugin_settings_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_plugin_settings_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_plugin_settings_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_plugin_settings_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_plugin_settings_id_seq OWNED BY limesurveyplayground.lime_plugin_settings.id;


--
-- Name: lime_plugins; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_plugins (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    active integer DEFAULT 0 NOT NULL,
    version character varying(32)
);


ALTER TABLE limesurveyplayground.lime_plugins OWNER TO limesurveyplayground_admin;

--
-- Name: lime_plugins_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_plugins_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_plugins_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_plugins_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_plugins_id_seq OWNED BY limesurveyplayground.lime_plugins.id;


--
-- Name: lime_question_attributes; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.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 limesurveyplayground.lime_question_attributes OWNER TO limesurveyplayground_admin;

--
-- Name: lime_question_attributes_qaid_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_question_attributes_qaid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_question_attributes_qaid_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_question_attributes_qaid_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_question_attributes_qaid_seq OWNED BY limesurveyplayground.lime_question_attributes.qaid;


--
-- Name: lime_questions; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.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 varying(1) DEFAULT 'T'::character varying NOT NULL,
    title character varying(20) DEFAULT ''::character varying NOT NULL,
    question text NOT NULL,
    preg text,
    help text,
    other character varying(1) DEFAULT 'N'::character varying NOT NULL,
    mandatory character varying(1),
    question_order integer NOT NULL,
    language character varying(20) DEFAULT 'en'::character varying NOT NULL,
    scale_id integer DEFAULT 0 NOT NULL,
    same_default integer DEFAULT 0 NOT NULL,
    relevance text,
    modulename character varying(255)
);


ALTER TABLE limesurveyplayground.lime_questions OWNER TO limesurveyplayground_admin;

--
-- Name: lime_questions_qid_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_questions_qid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_questions_qid_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_questions_qid_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_questions_qid_seq OWNED BY limesurveyplayground.lime_questions.qid;


--
-- Name: lime_quota; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.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 limesurveyplayground.lime_quota OWNER TO limesurveyplayground_admin;

--
-- Name: lime_quota_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_quota_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_quota_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_quota_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_quota_id_seq OWNED BY limesurveyplayground.lime_quota.id;


--
-- Name: lime_quota_languagesettings; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.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(255),
    quotals_message text NOT NULL,
    quotals_url character varying(255),
    quotals_urldescrip character varying(255)
);


ALTER TABLE limesurveyplayground.lime_quota_languagesettings OWNER TO limesurveyplayground_admin;

--
-- Name: lime_quota_languagesettings_quotals_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_quota_languagesettings_quotals_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_quota_languagesettings_quotals_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_quota_languagesettings_quotals_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_quota_languagesettings_quotals_id_seq OWNED BY limesurveyplayground.lime_quota_languagesettings.quotals_id;


--
-- Name: lime_quota_members; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_quota_members (
    id integer NOT NULL,
    sid integer,
    qid integer,
    quota_id integer,
    code character varying(11)
);


ALTER TABLE limesurveyplayground.lime_quota_members OWNER TO limesurveyplayground_admin;

--
-- Name: lime_quota_members_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_quota_members_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_quota_members_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_quota_members_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_quota_members_id_seq OWNED BY limesurveyplayground.lime_quota_members.id;


--
-- Name: lime_saved_control; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_saved_control (
    scid integer NOT NULL,
    sid integer DEFAULT 0 NOT NULL,
    srid integer DEFAULT 0 NOT NULL,
    identifier text NOT NULL,
    access_code text NOT NULL,
    email character varying(192),
    ip text NOT NULL,
    saved_thisstep text NOT NULL,
    status character varying(1) DEFAULT ''::character varying NOT NULL,
    saved_date timestamp without time zone NOT NULL,
    refurl text
);


ALTER TABLE limesurveyplayground.lime_saved_control OWNER TO limesurveyplayground_admin;

--
-- Name: lime_saved_control_scid_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_saved_control_scid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_saved_control_scid_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_saved_control_scid_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_saved_control_scid_seq OWNED BY limesurveyplayground.lime_saved_control.scid;


--
-- Name: lime_sessions; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_sessions (
    id character varying(32) NOT NULL,
    expire integer,
    data bytea
);


ALTER TABLE limesurveyplayground.lime_sessions OWNER TO limesurveyplayground_admin;

--
-- Name: lime_settings_global; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_settings_global (
    stg_name character varying(50) DEFAULT ''::character varying NOT NULL,
    stg_value text NOT NULL
);


ALTER TABLE limesurveyplayground.lime_settings_global OWNER TO limesurveyplayground_admin;

--
-- Name: lime_settings_user; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_settings_user (
    id integer NOT NULL,
    uid integer NOT NULL,
    entity character varying(15),
    entity_id character varying(31),
    stg_name character varying(63) NOT NULL,
    stg_value text
);


ALTER TABLE limesurveyplayground.lime_settings_user OWNER TO limesurveyplayground_admin;

--
-- Name: lime_settings_user_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_settings_user_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_settings_user_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_settings_user_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_settings_user_id_seq OWNED BY limesurveyplayground.lime_settings_user.id;


--
-- Name: lime_survey_links; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_survey_links (
    participant_id character varying(50) NOT NULL,
    token_id integer NOT NULL,
    survey_id integer NOT NULL,
    date_created timestamp without time zone,
    date_invited timestamp without time zone,
    date_completed timestamp without time zone
);


ALTER TABLE limesurveyplayground.lime_survey_links OWNER TO limesurveyplayground_admin;

--
-- Name: lime_survey_url_parameters; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_survey_url_parameters (
    id integer NOT NULL,
    sid integer NOT NULL,
    parameter character varying(50) NOT NULL,
    targetqid integer,
    targetsqid integer
);


ALTER TABLE limesurveyplayground.lime_survey_url_parameters OWNER TO limesurveyplayground_admin;

--
-- Name: lime_survey_url_parameters_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_survey_url_parameters_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_survey_url_parameters_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_survey_url_parameters_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_survey_url_parameters_id_seq OWNED BY limesurveyplayground.lime_survey_url_parameters.id;


--
-- Name: lime_surveymenu; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_surveymenu (
    id integer NOT NULL,
    parent_id integer,
    survey_id integer,
    user_id integer,
    name character varying(128),
    ordering integer DEFAULT 0,
    level integer DEFAULT 0,
    title character varying(168) DEFAULT ''::character varying NOT NULL,
    "position" character varying(192) DEFAULT 'side'::character varying NOT NULL,
    description text,
    showincollapse integer DEFAULT 0,
    active integer DEFAULT 0 NOT NULL,
    changed_at timestamp without time zone,
    changed_by integer DEFAULT 0 NOT NULL,
    created_at timestamp without time zone,
    created_by integer DEFAULT 0 NOT NULL
);


ALTER TABLE limesurveyplayground.lime_surveymenu OWNER TO limesurveyplayground_admin;

--
-- Name: lime_surveymenu_entries; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_surveymenu_entries (
    id integer NOT NULL,
    menu_id integer,
    user_id integer,
    ordering integer DEFAULT 0,
    name character varying(168) DEFAULT ''::character varying,
    title character varying(168) DEFAULT ''::character varying NOT NULL,
    menu_title character varying(168) DEFAULT ''::character varying NOT NULL,
    menu_description text,
    menu_icon character varying(192) DEFAULT ''::character varying NOT NULL,
    menu_icon_type character varying(192) DEFAULT ''::character varying NOT NULL,
    menu_class character varying(192) DEFAULT ''::character varying NOT NULL,
    menu_link character varying(192) DEFAULT ''::character varying NOT NULL,
    action character varying(192) DEFAULT ''::character varying NOT NULL,
    template character varying(192) DEFAULT ''::character varying NOT NULL,
    partial character varying(192) DEFAULT ''::character varying NOT NULL,
    classes character varying(192) DEFAULT ''::character varying NOT NULL,
    permission character varying(192) DEFAULT ''::character varying NOT NULL,
    permission_grade character varying(192),
    data text,
    getdatamethod character varying(192) DEFAULT ''::character varying NOT NULL,
    language character varying(32) DEFAULT 'en-GB'::character varying NOT NULL,
    showincollapse integer DEFAULT 0,
    active integer DEFAULT 0 NOT NULL,
    changed_at timestamp without time zone,
    changed_by integer DEFAULT 0 NOT NULL,
    created_at timestamp without time zone,
    created_by integer DEFAULT 0 NOT NULL
);


ALTER TABLE limesurveyplayground.lime_surveymenu_entries OWNER TO limesurveyplayground_admin;

--
-- Name: lime_surveymenu_entries_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_surveymenu_entries_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_surveymenu_entries_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_surveymenu_entries_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_surveymenu_entries_id_seq OWNED BY limesurveyplayground.lime_surveymenu_entries.id;


--
-- Name: lime_surveymenu_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_surveymenu_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_surveymenu_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_surveymenu_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_surveymenu_id_seq OWNED BY limesurveyplayground.lime_surveymenu.id;


--
-- Name: lime_surveys; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_surveys (
    sid integer NOT NULL,
    owner_id integer NOT NULL,
    gsid integer DEFAULT 1,
    admin character varying(50),
    active character varying(1) DEFAULT 'N'::character varying NOT NULL,
    expires timestamp without time zone,
    startdate timestamp without time zone,
    adminemail character varying(254),
    anonymized character varying(1) DEFAULT 'N'::character varying NOT NULL,
    faxto character varying(20),
    format character varying(1),
    savetimings character varying(1) DEFAULT 'N'::character varying NOT NULL,
    template character varying(100) DEFAULT 'default'::character varying,
    language character varying(50),
    additional_languages character varying(255),
    datestamp character varying(1) DEFAULT 'N'::character varying NOT NULL,
    usecookie character varying(1) DEFAULT 'N'::character varying NOT NULL,
    allowregister character varying(1) DEFAULT 'N'::character varying NOT NULL,
    allowsave character varying(1) DEFAULT 'Y'::character varying NOT NULL,
    autonumber_start integer DEFAULT 0 NOT NULL,
    autoredirect character varying(1) DEFAULT 'N'::character varying NOT NULL,
    allowprev character varying(1) DEFAULT 'N'::character varying NOT NULL,
    printanswers character varying(1) DEFAULT 'N'::character varying NOT NULL,
    ipaddr character varying(1) DEFAULT 'N'::character varying NOT NULL,
    refurl character varying(1) DEFAULT 'N'::character varying NOT NULL,
    datecreated timestamp without time zone,
    showsurveypolicynotice integer DEFAULT 0,
    publicstatistics character varying(1) DEFAULT 'N'::character varying NOT NULL,
    publicgraphs character varying(1) DEFAULT 'N'::character varying NOT NULL,
    listpublic character varying(1) DEFAULT 'N'::character varying NOT NULL,
    htmlemail character varying(1) DEFAULT 'N'::character varying NOT NULL,
    sendconfirmation character varying(1) DEFAULT 'Y'::character varying NOT NULL,
    tokenanswerspersistence character varying(1) DEFAULT 'N'::character varying NOT NULL,
    assessments character varying(1) DEFAULT 'N'::character varying NOT NULL,
    usecaptcha character varying(1) DEFAULT 'N'::character varying NOT NULL,
    usetokens character varying(1) DEFAULT 'N'::character varying NOT NULL,
    bounce_email character varying(254),
    attributedescriptions text,
    emailresponseto text,
    emailnotificationto text,
    tokenlength integer DEFAULT 15 NOT NULL,
    showxquestions character varying(1) DEFAULT 'Y'::character varying,
    showgroupinfo character varying(1) DEFAULT 'B'::character varying,
    shownoanswer character varying(1) DEFAULT 'Y'::character varying,
    showqnumcode character varying(1) DEFAULT 'X'::character varying,
    bouncetime integer,
    bounceprocessing character varying(1) DEFAULT 'N'::character varying,
    bounceaccounttype character varying(4),
    bounceaccounthost character varying(200),
    bounceaccountpass character varying(100),
    bounceaccountencryption character varying(3),
    bounceaccountuser character varying(200),
    showwelcome character varying(1) DEFAULT 'Y'::character varying,
    showprogress character varying(1) DEFAULT 'Y'::character varying,
    questionindex integer DEFAULT 0 NOT NULL,
    navigationdelay integer DEFAULT 0 NOT NULL,
    nokeyboard character varying(1) DEFAULT 'N'::character varying,
    alloweditaftercompletion character varying(1) DEFAULT 'N'::character varying,
    googleanalyticsstyle character varying(1),
    googleanalyticsapikey character varying(25)
);


ALTER TABLE limesurveyplayground.lime_surveys OWNER TO limesurveyplayground_admin;

--
-- Name: lime_surveys_groups; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_surveys_groups (
    gsid integer NOT NULL,
    name character varying(45) NOT NULL,
    title character varying(100),
    template character varying(128) DEFAULT 'default'::character varying,
    description text,
    sortorder integer NOT NULL,
    owner_uid integer,
    parent_id integer,
    created timestamp without time zone,
    modified timestamp without time zone,
    created_by integer NOT NULL
);


ALTER TABLE limesurveyplayground.lime_surveys_groups OWNER TO limesurveyplayground_admin;

--
-- Name: lime_surveys_groups_gsid_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_surveys_groups_gsid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_surveys_groups_gsid_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_surveys_groups_gsid_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_surveys_groups_gsid_seq OWNED BY limesurveyplayground.lime_surveys_groups.gsid;


--
-- Name: lime_surveys_languagesettings; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_surveys_languagesettings (
    surveyls_survey_id integer 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_endtext text,
    surveyls_policy_notice text,
    surveyls_policy_error text,
    surveyls_policy_notice_label character varying(192),
    surveyls_url text,
    surveyls_urldescription character varying(255),
    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,
    surveyls_attributecaptions text,
    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 0 NOT NULL,
    attachments text
);


ALTER TABLE limesurveyplayground.lime_surveys_languagesettings OWNER TO limesurveyplayground_admin;

--
-- Name: lime_template_configuration; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_template_configuration (
    id integer NOT NULL,
    template_name character varying(150) NOT NULL,
    sid integer,
    gsid integer,
    uid integer,
    files_css text,
    files_js text,
    files_print_css text,
    options text,
    cssframework_name character varying(45),
    cssframework_css text,
    cssframework_js text,
    packages_to_load text,
    packages_ltr text,
    packages_rtl text
);


ALTER TABLE limesurveyplayground.lime_template_configuration OWNER TO limesurveyplayground_admin;

--
-- Name: lime_template_configuration_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_template_configuration_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_template_configuration_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_template_configuration_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_template_configuration_id_seq OWNED BY limesurveyplayground.lime_template_configuration.id;


--
-- Name: lime_templates; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_templates (
    id integer NOT NULL,
    name character varying(150) NOT NULL,
    folder character varying(45),
    title character varying(100) NOT NULL,
    creation_date timestamp without time zone,
    author character varying(150),
    author_email character varying(255),
    author_url character varying(255),
    copyright text,
    license text,
    version character varying(45),
    api_version character varying(45) NOT NULL,
    view_folder character varying(45) NOT NULL,
    files_folder character varying(45) NOT NULL,
    description text,
    last_update timestamp without time zone,
    owner_id integer,
    extends character varying(150)
);


ALTER TABLE limesurveyplayground.lime_templates OWNER TO limesurveyplayground_admin;

--
-- Name: lime_templates_id_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_templates_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_templates_id_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_templates_id_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_templates_id_seq OWNED BY limesurveyplayground.lime_templates.id;


--
-- Name: lime_tutorial_entries; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_tutorial_entries (
    teid integer NOT NULL,
    ordering integer,
    title text,
    content text,
    settings text
);


ALTER TABLE limesurveyplayground.lime_tutorial_entries OWNER TO limesurveyplayground_admin;

--
-- Name: lime_tutorial_entries_teid_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_tutorial_entries_teid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_tutorial_entries_teid_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_tutorial_entries_teid_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_tutorial_entries_teid_seq OWNED BY limesurveyplayground.lime_tutorial_entries.teid;


--
-- Name: lime_tutorial_entry_relation; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_tutorial_entry_relation (
    teid integer NOT NULL,
    tid integer NOT NULL,
    uid integer,
    sid integer
);


ALTER TABLE limesurveyplayground.lime_tutorial_entry_relation OWNER TO limesurveyplayground_admin;

--
-- Name: lime_tutorials; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_tutorials (
    tid integer NOT NULL,
    name character varying(128),
    title character varying(192),
    icon character varying(64),
    description text,
    active integer DEFAULT 0,
    settings text,
    permission character varying(128) NOT NULL,
    permission_grade character varying(128) NOT NULL
);


ALTER TABLE limesurveyplayground.lime_tutorials OWNER TO limesurveyplayground_admin;

--
-- Name: lime_tutorials_tid_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_tutorials_tid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_tutorials_tid_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_tutorials_tid_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_tutorials_tid_seq OWNED BY limesurveyplayground.lime_tutorials.tid;


--
-- Name: lime_user_groups; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_user_groups (
    ugid integer NOT NULL,
    name character varying(20) NOT NULL,
    description text NOT NULL,
    owner_id integer NOT NULL
);


ALTER TABLE limesurveyplayground.lime_user_groups OWNER TO limesurveyplayground_admin;

--
-- Name: lime_user_groups_ugid_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_user_groups_ugid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_user_groups_ugid_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_user_groups_ugid_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_user_groups_ugid_seq OWNED BY limesurveyplayground.lime_user_groups.ugid;


--
-- Name: lime_user_in_groups; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_user_in_groups (
    ugid integer NOT NULL,
    uid integer NOT NULL
);


ALTER TABLE limesurveyplayground.lime_user_in_groups OWNER TO limesurveyplayground_admin;

--
-- Name: lime_users; Type: TABLE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE TABLE limesurveyplayground.lime_users (
    uid integer NOT NULL,
    users_name character varying(64) DEFAULT ''::character varying NOT NULL,
    password text NOT NULL,
    full_name character varying(50) NOT NULL,
    parent_id integer NOT NULL,
    lang character varying(20),
    email character varying(192),
    htmleditormode character varying(7) DEFAULT 'default'::character varying,
    templateeditormode character varying(7) DEFAULT 'default'::character varying NOT NULL,
    questionselectormode character varying(7) DEFAULT 'default'::character varying NOT NULL,
    one_time_pw text,
    dateformat integer DEFAULT 1 NOT NULL,
    created timestamp without time zone,
    modified timestamp without time zone
);


ALTER TABLE limesurveyplayground.lime_users OWNER TO limesurveyplayground_admin;

--
-- Name: lime_users_uid_seq; Type: SEQUENCE; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE SEQUENCE limesurveyplayground.lime_users_uid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE limesurveyplayground.lime_users_uid_seq OWNER TO limesurveyplayground_admin;

--
-- Name: lime_users_uid_seq; Type: SEQUENCE OWNED BY; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER SEQUENCE limesurveyplayground.lime_users_uid_seq OWNED BY limesurveyplayground.lime_users.uid;


--
-- Name: lime_assessments id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_assessments ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_assessments_id_seq'::regclass);


--
-- Name: lime_asset_version id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_asset_version ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_asset_version_id_seq'::regclass);


--
-- Name: lime_boxes id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_boxes ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_boxes_id_seq'::regclass);


--
-- Name: lime_conditions cid; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_conditions ALTER COLUMN cid SET DEFAULT nextval('limesurveyplayground.lime_conditions_cid_seq'::regclass);


--
-- Name: lime_expression_errors id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_expression_errors ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_expression_errors_id_seq'::regclass);


--
-- Name: lime_failed_login_attempts id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_failed_login_attempts ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_failed_login_attempts_id_seq'::regclass);


--
-- Name: lime_groups gid; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_groups ALTER COLUMN gid SET DEFAULT nextval('limesurveyplayground.lime_groups_gid_seq'::regclass);


--
-- Name: lime_labels id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_labels ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_labels_id_seq'::regclass);


--
-- Name: lime_labelsets lid; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_labelsets ALTER COLUMN lid SET DEFAULT nextval('limesurveyplayground.lime_labelsets_lid_seq'::regclass);


--
-- Name: lime_notifications id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_notifications ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_notifications_id_seq'::regclass);


--
-- Name: lime_participant_attribute_names attribute_id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_participant_attribute_names ALTER COLUMN attribute_id SET DEFAULT nextval('limesurveyplayground.lime_participant_attribute_names_attribute_id_seq'::regclass);


--
-- Name: lime_participant_attribute_values value_id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_participant_attribute_values ALTER COLUMN value_id SET DEFAULT nextval('limesurveyplayground.lime_participant_attribute_values_value_id_seq'::regclass);


--
-- Name: lime_permissions id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_permissions ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_permissions_id_seq'::regclass);


--
-- Name: lime_plugin_settings id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_plugin_settings ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_plugin_settings_id_seq'::regclass);


--
-- Name: lime_plugins id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_plugins ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_plugins_id_seq'::regclass);


--
-- Name: lime_question_attributes qaid; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_question_attributes ALTER COLUMN qaid SET DEFAULT nextval('limesurveyplayground.lime_question_attributes_qaid_seq'::regclass);


--
-- Name: lime_questions qid; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_questions ALTER COLUMN qid SET DEFAULT nextval('limesurveyplayground.lime_questions_qid_seq'::regclass);


--
-- Name: lime_quota id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_quota ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_quota_id_seq'::regclass);


--
-- Name: lime_quota_languagesettings quotals_id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_quota_languagesettings ALTER COLUMN quotals_id SET DEFAULT nextval('limesurveyplayground.lime_quota_languagesettings_quotals_id_seq'::regclass);


--
-- Name: lime_quota_members id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_quota_members ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_quota_members_id_seq'::regclass);


--
-- Name: lime_saved_control scid; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_saved_control ALTER COLUMN scid SET DEFAULT nextval('limesurveyplayground.lime_saved_control_scid_seq'::regclass);


--
-- Name: lime_settings_user id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_settings_user ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_settings_user_id_seq'::regclass);


--
-- Name: lime_survey_url_parameters id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_survey_url_parameters ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_survey_url_parameters_id_seq'::regclass);


--
-- Name: lime_surveymenu id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_surveymenu ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_surveymenu_id_seq'::regclass);


--
-- Name: lime_surveymenu_entries id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_surveymenu_entries ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_surveymenu_entries_id_seq'::regclass);


--
-- Name: lime_surveys_groups gsid; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_surveys_groups ALTER COLUMN gsid SET DEFAULT nextval('limesurveyplayground.lime_surveys_groups_gsid_seq'::regclass);


--
-- Name: lime_template_configuration id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_template_configuration ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_template_configuration_id_seq'::regclass);


--
-- Name: lime_templates id; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_templates ALTER COLUMN id SET DEFAULT nextval('limesurveyplayground.lime_templates_id_seq'::regclass);


--
-- Name: lime_tutorial_entries teid; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_tutorial_entries ALTER COLUMN teid SET DEFAULT nextval('limesurveyplayground.lime_tutorial_entries_teid_seq'::regclass);


--
-- Name: lime_tutorials tid; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_tutorials ALTER COLUMN tid SET DEFAULT nextval('limesurveyplayground.lime_tutorials_tid_seq'::regclass);


--
-- Name: lime_user_groups ugid; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_user_groups ALTER COLUMN ugid SET DEFAULT nextval('limesurveyplayground.lime_user_groups_ugid_seq'::regclass);


--
-- Name: lime_users uid; Type: DEFAULT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_users ALTER COLUMN uid SET DEFAULT nextval('limesurveyplayground.lime_users_uid_seq'::regclass);


--
-- Data for Name: lime_answers; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_answers (qid, code, answer, sortorder, assessment_value, language, scale_id) FROM stdin;
\.


--
-- Data for Name: lime_assessments; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_assessments (id, sid, scope, gid, name, minimum, maximum, message, language) FROM stdin;
\.


--
-- Data for Name: lime_asset_version; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_asset_version (id, path, version) FROM stdin;
\.


--
-- Data for Name: lime_boxes; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_boxes (id, "position", url, title, ico, "desc", page, usergroup) FROM stdin;
1	1	admin/survey/sa/newsurvey	Create survey	icon-add	Create a new survey	welcome	-2
2	2	admin/survey/sa/listsurveys	List surveys	icon-list	List available surveys	welcome	-1
3	3	admin/globalsettings	Global settings	icon-settings	Edit global settings	welcome	-2
4	4	admin/update	ComfortUpdate	icon-shield	Stay safe and up to date	welcome	-2
5	5	https://www.limesurvey.org/limestore	LimeStore	fa fa-cart-plus	LimeSurvey extension marketplace	welcome	-2
6	6	admin/themeoptions	Themes	icon-templates	Themes	welcome	-2
\.


--
-- Data for Name: lime_conditions; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_conditions (cid, qid, cqid, cfieldname, method, value, scenario) FROM stdin;
\.


--
-- Data for Name: lime_defaultvalues; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_defaultvalues (qid, scale_id, sqid, language, specialtype, defaultvalue) FROM stdin;
\.


--
-- Data for Name: lime_expression_errors; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_expression_errors (id, errortime, sid, gid, qid, gseq, qseq, type, eqn, prettyprint) FROM stdin;
\.


--
-- Data for Name: lime_failed_login_attempts; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_failed_login_attempts (id, ip, last_attempt, number_attempts) FROM stdin;
\.


--
-- Data for Name: lime_groups; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_groups (gid, sid, group_name, group_order, description, language, randomization_group, grelevance) FROM stdin;
\.


--
-- Data for Name: lime_labels; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_labels (id, lid, code, title, sortorder, language, assessment_value) FROM stdin;
\.


--
-- Data for Name: lime_labelsets; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_labelsets (lid, label_name, languages) FROM stdin;
\.


--
-- Data for Name: lime_map_tutorial_users; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_map_tutorial_users (tid, uid, taken) FROM stdin;
\.


--
-- Data for Name: lime_notifications; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_notifications (id, entity, entity_id, title, message, status, importance, display_class, hash, created, first_read) FROM stdin;
\.


--
-- Data for Name: lime_participant_attribute; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_participant_attribute (participant_id, attribute_id, value) FROM stdin;
\.


--
-- Data for Name: lime_participant_attribute_names; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_participant_attribute_names (attribute_id, attribute_type, defaultname, visible) FROM stdin;
\.


--
-- Data for Name: lime_participant_attribute_names_lang; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_participant_attribute_names_lang (attribute_id, attribute_name, lang) FROM stdin;
\.


--
-- Data for Name: lime_participant_attribute_values; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_participant_attribute_values (value_id, attribute_id, value) FROM stdin;
\.


--
-- Data for Name: lime_participant_shares; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_participant_shares (participant_id, share_uid, date_added, can_edit) FROM stdin;
\.


--
-- Data for Name: lime_participants; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_participants (participant_id, firstname, lastname, email, language, blacklisted, owner_uid, created_by, created, modified) FROM stdin;
\.


--
-- Data for Name: lime_permissions; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_permissions (id, entity, entity_id, uid, permission, create_p, read_p, update_p, delete_p, import_p, export_p) FROM stdin;
\.


--
-- Data for Name: lime_plugin_settings; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_plugin_settings (id, plugin_id, model, model_id, key, value) FROM stdin;
\.


--
-- Data for Name: lime_plugins; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_plugins (id, name, active, version) FROM stdin;
\.


--
-- Data for Name: lime_question_attributes; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_question_attributes (qaid, qid, attribute, value, language) FROM stdin;
\.


--
-- Data for Name: lime_questions; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_questions (qid, parent_qid, sid, gid, type, title, question, preg, help, other, mandatory, question_order, language, scale_id, same_default, relevance, modulename) FROM stdin;
\.


--
-- Data for Name: lime_quota; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_quota (id, sid, name, qlimit, action, active, autoload_url) FROM stdin;
\.


--
-- Data for Name: lime_quota_languagesettings; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_quota_languagesettings (quotals_id, quotals_quota_id, quotals_language, quotals_name, quotals_message, quotals_url, quotals_urldescrip) FROM stdin;
\.


--
-- Data for Name: lime_quota_members; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_quota_members (id, sid, qid, quota_id, code) FROM stdin;
\.


--
-- Data for Name: lime_saved_control; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_saved_control (scid, sid, srid, identifier, access_code, email, ip, saved_thisstep, status, saved_date, refurl) FROM stdin;
\.


--
-- Data for Name: lime_sessions; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_sessions (id, expire, data) FROM stdin;
\.


--
-- Data for Name: lime_settings_global; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_settings_global (stg_name, stg_value) FROM stdin;
DBVersion	356
\.


--
-- Data for Name: lime_settings_user; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_settings_user (id, uid, entity, entity_id, stg_name, stg_value) FROM stdin;
\.


--
-- Data for Name: lime_survey_links; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_survey_links (participant_id, token_id, survey_id, date_created, date_invited, date_completed) FROM stdin;
\.


--
-- Data for Name: lime_survey_url_parameters; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_survey_url_parameters (id, sid, parameter, targetqid, targetsqid) FROM stdin;
\.


--
-- Data for Name: lime_surveymenu; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_surveymenu (id, parent_id, survey_id, user_id, name, ordering, level, title, "position", description, showincollapse, active, changed_at, changed_by, created_at, created_by) FROM stdin;
1	\N	\N	\N	settings	1	0	Survey settings	side	Survey settings	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
2	\N	\N	\N	mainmenu	2	0	Survey menu	side	Main survey menu	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
3	\N	\N	\N	quickmenu	3	0	Quick menu	collapsed	Quick menu	0	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
\.


--
-- Data for Name: lime_surveymenu_entries; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_surveymenu_entries (id, menu_id, user_id, ordering, name, title, menu_title, menu_description, menu_icon, menu_icon_type, menu_class, menu_link, action, template, partial, classes, permission, permission_grade, data, getdatamethod, language, showincollapse, active, changed_at, changed_by, created_at, created_by) FROM stdin;
1	1	\N	1	overview	Survey overview	Overview	Open the general survey overview	list	fontawesome		admin/survey/sa/view							{"render": { "link": {"data": {"surveyid": ["survey","sid"]}}}}		en-GB	0	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
2	1	\N	2	generalsettings	General survey settings	General settings	Open general survey settings	gears	fontawesome			updatesurveylocalesettings_generalsettings	editLocalSettings_main_view	/admin/survey/subview/accordion/_generaloptions_panel		surveysettings	read	\N	_generalTabEditSurvey	en-GB	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
3	1	\N	3	surveytexts	Survey text elements	Text elements	Survey text elements	file-text-o	fontawesome			updatesurveylocalesettings	editLocalSettings_main_view	/admin/survey/subview/tab_edit_view		surveylocale	read	\N	_getTextEditData	en-GB	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
4	1	\N	4	datasecurity	Data policy settings	Data policy settings	Edit data policy settings	shield	fontawesome			updatesurveylocalesettings	editLocalSettings_main_view	/admin/survey/subview/tab_edit_view_datasecurity		surveylocale	read	\N	_getDataSecurityEditData	en-GB	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
5	1	\N	5	theme_options	Theme options	Theme options	Edit theme options for this survey	paint-brush	fontawesome		admin/themeoptions/sa/updatesurvey					surveysettings	update	{"render": {"link": { "pjaxed": true, "data": {"surveyid": ["survey","sid"], "gsid":["survey","gsid"]}}}}		en-GB	0	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
6	1	\N	6	presentation	Presentation & navigation settings	Presentation	Edit presentation and navigation settings	eye-slash	fontawesome			updatesurveylocalesettings	editLocalSettings_main_view	/admin/survey/subview/accordion/_presentation_panel		surveylocale	read	\N	_tabPresentationNavigation	en-GB	0	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
7	1	\N	7	tokens	Survey participant settings	Participant settings	Set additional options for survey participants	users	fontawesome			updatesurveylocalesettings	editLocalSettings_main_view	/admin/survey/subview/accordion/_tokens_panel		surveylocale	read	\N	_tabTokens	en-GB	0	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
8	1	\N	8	notification	Notification and data management settings	Notifications & data	Edit settings for notification and data management	feed	fontawesome			updatesurveylocalesettings	editLocalSettings_main_view	/admin/survey/subview/accordion/_notification_panel		surveylocale	read	\N	_tabNotificationDataManagement	en-GB	0	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
9	1	\N	9	publication	Publication & access control settings	Publication & access	Edit settings for publication and access control	key	fontawesome			updatesurveylocalesettings	editLocalSettings_main_view	/admin/survey/subview/accordion/_publication_panel		surveylocale	read	\N	_tabPublicationAccess	en-GB	0	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
10	2	\N	1	listQuestions	List questions	List questions	List questions	list	fontawesome		admin/survey/sa/listquestions					surveycontent	read	{"render": { "link": {"data": {"surveyid": ["survey","sid"]}}}}		en-GB	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
11	2	\N	2	listQuestionGroups	List question groups	List question groups	List question groups	th-list	fontawesome		admin/survey/sa/listquestiongroups					surveycontent	read	{"render": { "link": {"data": {"surveyid": ["survey","sid"]}}}}		en-GB	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
12	2	\N	3	reorder	Reorder questions/question groups	Reorder questions/question groups	Reorder questions/question groups	icon-organize	iconclass		admin/survey/sa/organize/					surveycontent	update	{"render": {"isActive": false, "link": {"data": {"surveyid": ["survey","sid"]}}}}		en-GB	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
13	2	\N	4	responses	Responses	Responses	Responses	icon-browse	iconclass		admin/responses/sa/browse/					responses	read	{"render": {"isActive": true, "link": {"data": {"surveyid": ["survey", "sid"]}}}}		en-GB	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
14	2	\N	5	participants	Survey participants	Survey participants	Go to survey participant and token settings	user	fontawesome		admin/tokens/sa/index/					surveysettings	update	{"render": { "link": {"data": {"surveyid": ["survey","sid"]}}}}		en-GB	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
15	2	\N	6	statistics	Statistics	Statistics	Statistics	bar-chart	fontawesome		admin/statistics/sa/index/					statistics	read	{"render": {"isActive": true, "link": {"data": {"surveyid": ["survey", "sid"]}}}}		en-GB	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
16	2	\N	7	quotas	Edit quotas	Quotas	Edit quotas for this survey.	tasks	fontawesome		admin/quotas/sa/index/					quotas	read	{"render": { "link": {"data": {"surveyid": ["survey","sid"]}}}}		en-GB	0	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
17	2	\N	8	assessments	Edit assessments	Assessments	Edit and look at the assessements for this survey.	comment-o	fontawesome		admin/assessments/sa/index/					assessments	read	{"render": { "link": {"data": {"surveyid": ["survey","sid"]}}}}		en-GB	0	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
18	2	\N	9	surveypermissions	Edit survey permissions	Survey permissions	Edit permissions for this survey	lock	fontawesome		admin/surveypermission/sa/view/					surveysecurity	read	{"render": { "link": {"data": {"surveyid": ["survey","sid"]}}}}		en-GB	0	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
19	2	\N	10	emailtemplates	Email templates	Email templates	Edit the templates for invitation, reminder and registration emails	envelope-square	fontawesome		admin/emailtemplates/sa/index/					surveylocale	read	{"render": { "link": {"data": {"surveyid": ["survey","sid"]}}}}		en-GB	0	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
20	2	\N	11	panelintegration	Edit survey panel integration	Panel integration	Define panel integrations for your survey	link	fontawesome			updatesurveylocalesettings	editLocalSettings_main_view	/admin/survey/subview/accordion/_integration_panel		surveylocale	read	{"render": {"link": { "pjaxed": false}}}	_tabPanelIntegration	en-GB	0	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
21	2	\N	12	resources	Add/edit resources (files/images) for this survey	Resources	Add/edit resources (files/images) for this survey	file	fontawesome			updatesurveylocalesettings	editLocalSettings_main_view	/admin/survey/subview/accordion/_resources_panel		surveylocale	read	\N	_tabResourceManagement	en-GB	0	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
22	2	\N	13	plugins	Simple plugin settings	Simple plugins	Edit simple plugin settings	plug	fontawesome			updatesurveylocalesettings	editLocalSettings_main_view	/admin/survey/subview/accordion/_plugins_panel		surveysettings	read	{"render": {"link": {"data": {"surveyid": ["survey","sid"]}}}}	_pluginTabSurvey	en-GB	0	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
23	3	\N	1	activateSurvey	Activate survey	Activate survey	Activate survey	play	fontawesome		admin/survey/sa/activate					surveyactivation	update	{"render": {"isActive": false, "link": {"data": {"surveyid": ["survey","sid"]}}}}		en-GB	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
24	3	\N	2	deactivateSurvey	Stop this survey	Stop this survey	Stop this survey	stop	fontawesome		admin/survey/sa/deactivate					surveyactivation	update	{"render": {"isActive": true, "link": {"data": {"surveyid": ["survey","sid"]}}}}		en-GB	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
25	3	\N	3	testSurvey	Go to survey	Go to survey	Go to survey	cog	fontawesome		survey/index/							{"render": {"link": {"external": true, "data": {"sid": ["survey","sid"], "newtest": "Y", "lang": ["survey","language"]}}}}		en-GB	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
26	3	\N	4	surveyLogicFile	Survey logic file	Survey logic file	Survey logic file	sitemap	fontawesome		admin/expressions/sa/survey_logic_file/					surveycontent	read	{"render": { "link": {"data": {"sid": ["survey","sid"]}}}}		en-GB	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
27	3	\N	5	cpdb	Central participant database	Central participant database	Central participant database	users	fontawesome		admin/participants/sa/displayParticipants					tokens	read	{"render": {"link": {}}}		en-GB	1	1	2019-04-18 15:41:55	0	2019-04-18 15:41:55	0
\.


--
-- Data for Name: lime_surveys; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_surveys (sid, owner_id, gsid, admin, active, expires, startdate, adminemail, anonymized, faxto, format, savetimings, template, language, additional_languages, datestamp, usecookie, allowregister, allowsave, autonumber_start, autoredirect, allowprev, printanswers, ipaddr, refurl, datecreated, showsurveypolicynotice, publicstatistics, publicgraphs, listpublic, htmlemail, sendconfirmation, tokenanswerspersistence, assessments, usecaptcha, usetokens, bounce_email, attributedescriptions, emailresponseto, emailnotificationto, tokenlength, showxquestions, showgroupinfo, shownoanswer, showqnumcode, bouncetime, bounceprocessing, bounceaccounttype, bounceaccounthost, bounceaccountpass, bounceaccountencryption, bounceaccountuser, showwelcome, showprogress, questionindex, navigationdelay, nokeyboard, alloweditaftercompletion, googleanalyticsstyle, googleanalyticsapikey) FROM stdin;
\.


--
-- Data for Name: lime_surveys_groups; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_surveys_groups (gsid, name, title, template, description, sortorder, owner_uid, parent_id, created, modified, created_by) FROM stdin;
1	default	Default	\N	Default survey group	0	1	\N	2019-04-18 15:41:55	2019-04-18 15:41:55	1
\.


--
-- Data for Name: lime_surveys_languagesettings; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_surveys_languagesettings (surveyls_survey_id, surveyls_language, surveyls_title, surveyls_description, surveyls_welcometext, surveyls_endtext, surveyls_policy_notice, surveyls_policy_error, surveyls_policy_notice_label, surveyls_url, surveyls_urldescription, 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, surveyls_attributecaptions, email_admin_notification_subj, email_admin_notification, email_admin_responses_subj, email_admin_responses, surveyls_numberformat, attachments) FROM stdin;
\.


--
-- Data for Name: lime_template_configuration; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_template_configuration (id, template_name, sid, gsid, uid, files_css, files_js, files_print_css, options, cssframework_name, cssframework_css, cssframework_js, packages_to_load, packages_ltr, packages_rtl) FROM stdin;
1	vanilla	\N	\N	\N	{"add":["css/ajaxify.css","css/theme.css","css/custom.css"]}	{"add":["scripts/theme.js","scripts/ajaxify.js","scripts/custom.js"]}	{"add":["css/print_theme.css"]}	{"ajaxmode":"on","brandlogo":"on","container":"on", "hideprivacyinfo": "off", "brandlogofile":"./files/logo.png","font":"noto"}	bootstrap	{}		{"add":["pjax","font-noto","moment"]}	\N	\N
2	fruity	\N	\N	\N	{"add":["css/ajaxify.css","css/animate.css","css/variations/sea_green.css","css/theme.css","css/custom.css"]}	{"add":["scripts/theme.js","scripts/ajaxify.js","scripts/custom.js"]}	{"add":["css/print_theme.css"]}	{"ajaxmode":"on","brandlogo":"on","brandlogofile":"./files/logo.png","container":"on","backgroundimage":"off","backgroundimagefile":null,"animatebody":"off","bodyanimation":"fadeInRight","bodyanimationduration":"500","animatequestion":"off","questionanimation":"flipInX","questionanimationduration":"500","animatealert":"off","alertanimation":"shake","alertanimationduration":"500","font":"noto","bodybackgroundcolor":"#ffffff","fontcolor":"#444444","questionbackgroundcolor":"#ffffff","questionborder":"on","questioncontainershadow":"on","checkicon":"f00c","animatecheckbox":"on","checkboxanimation":"rubberBand","checkboxanimationduration":"500","animateradio":"on","radioanimation":"zoomIn","radioanimationduration":"500","zebrastriping":"off","stickymatrixheaders":"off","greyoutselected":"off","hideprivacyinfo":"off","crosshover":"off","showpopups":"1"}	bootstrap	{}		{"add":["pjax","font-noto","moment"]}	\N	\N
3	bootswatch	\N	\N	\N	{"add":["css/ajaxify.css","css/theme.css","css/custom.css"]}	{"add":["scripts/theme.js","scripts/ajaxify.js","scripts/custom.js"]}	{"add":["css/print_theme.css"]}	{"ajaxmode":"on","brandlogo":"on","container":"on","brandlogofile":"./files/logo.png"}	bootstrap	{"replace":[["css/bootstrap.css","css/variations/flatly.min.css"]]}		{"add":["pjax","font-noto","moment"]}	\N	\N
\.


--
-- Data for Name: lime_templates; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_templates (id, name, folder, title, creation_date, author, author_email, author_url, copyright, license, version, api_version, view_folder, files_folder, description, last_update, owner_id, extends) FROM stdin;
1	vanilla	vanilla	Vanilla Theme	2019-04-18 15:41:55	Louis Gac	louis.gac@limesurvey.org	https://www.limesurvey.org/	Copyright (C) 2007-2017 The LimeSurvey Project Team\\r\\nAll rights reserved.	License: GNU/GPL License v2 or later, see LICENSE.php\\r\\n\\r\\nLimeSurvey is free software. This version may have been modified pursuant to the GNU General Public License, and as distributed it includes or is derivative of works licensed under the GNU General Public License or other free or open source software licenses. See COPYRIGHT.php for copyright notices and details.	3.0	3.0	views	files	<strong>LimeSurvey Bootstrap Vanilla Survey Theme</strong><br>A clean and simple base that can be used by developers to create their own Bootstrap based theme.	\N	1	
2	fruity	fruity	Fruity Theme	2019-04-18 15:41:55	Louis Gac	louis.gac@limesurvey.org	https://www.limesurvey.org/	Copyright (C) 2007-2017 The LimeSurvey Project Team\\r\\nAll rights reserved.	License: GNU/GPL License v2 or later, see LICENSE.php\\r\\n\\r\\nLimeSurvey is free software. This version may have been modified pursuant to the GNU General Public License, and as distributed it includes or is derivative of works licensed under the GNU General Public License or other free or open source software licenses. See COPYRIGHT.php for copyright notices and details.	3.0	3.0	views	files	<strong>LimeSurvey Fruity Theme</strong><br>A fruity theme for a flexible use. This theme offers monochromes variations and many options for easy customizations.	\N	1	vanilla
3	bootswatch	bootswatch	Bootswatch Theme	2019-04-18 15:41:55	Louis Gac	louis.gac@limesurvey.org	https://www.limesurvey.org/	Copyright (C) 2007-2017 The LimeSurvey Project Team\\r\\nAll rights reserved.	License: GNU/GPL License v2 or later, see LICENSE.php\\r\\n\\r\\nLimeSurvey is free software. This version may have been modified pursuant to the GNU General Public License, and as distributed it includes or is derivative of works licensed under the GNU General Public License or other free or open source software licenses. See COPYRIGHT.php for copyright notices and details.	3.0	3.0	views	files	<strong>LimeSurvey Bootwatch Theme</strong><br>Based on BootsWatch Themes: <a href="https://bootswatch.com/3/"">Visit BootsWatch page</a> 	\N	1	vanilla
\.


--
-- Data for Name: lime_tutorial_entries; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_tutorial_entries (teid, ordering, title, content, settings) FROM stdin;
\.


--
-- Data for Name: lime_tutorial_entry_relation; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_tutorial_entry_relation (teid, tid, uid, sid) FROM stdin;
\.


--
-- Data for Name: lime_tutorials; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_tutorials (tid, name, title, icon, description, active, settings, permission, permission_grade) FROM stdin;
\.


--
-- Data for Name: lime_user_groups; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_user_groups (ugid, name, description, owner_id) FROM stdin;
\.


--
-- Data for Name: lime_user_in_groups; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_user_in_groups (ugid, uid) FROM stdin;
\.


--
-- Data for Name: lime_users; Type: TABLE DATA; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

COPY limesurveyplayground.lime_users (uid, users_name, password, full_name, parent_id, lang, email, htmleditormode, templateeditormode, questionselectormode, one_time_pw, dateformat, created, modified) FROM stdin;
\.


--
-- Name: lime_assessments_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_assessments_id_seq', 1, false);


--
-- Name: lime_asset_version_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_asset_version_id_seq', 1, false);


--
-- Name: lime_boxes_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_boxes_id_seq', 6, true);


--
-- Name: lime_conditions_cid_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_conditions_cid_seq', 1, false);


--
-- Name: lime_expression_errors_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_expression_errors_id_seq', 1, false);


--
-- Name: lime_failed_login_attempts_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_failed_login_attempts_id_seq', 1, false);


--
-- Name: lime_groups_gid_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_groups_gid_seq', 1, false);


--
-- Name: lime_labels_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_labels_id_seq', 1, false);


--
-- Name: lime_labelsets_lid_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_labelsets_lid_seq', 1, false);


--
-- Name: lime_notifications_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_notifications_id_seq', 1, false);


--
-- Name: lime_participant_attribute_names_attribute_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_participant_attribute_names_attribute_id_seq', 1, false);


--
-- Name: lime_participant_attribute_values_value_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_participant_attribute_values_value_id_seq', 1, false);


--
-- Name: lime_permissions_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_permissions_id_seq', 1, false);


--
-- Name: lime_plugin_settings_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_plugin_settings_id_seq', 1, false);


--
-- Name: lime_plugins_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_plugins_id_seq', 1, false);


--
-- Name: lime_question_attributes_qaid_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_question_attributes_qaid_seq', 1, false);


--
-- Name: lime_questions_qid_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_questions_qid_seq', 1, false);


--
-- Name: lime_quota_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_quota_id_seq', 1, false);


--
-- Name: lime_quota_languagesettings_quotals_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_quota_languagesettings_quotals_id_seq', 1, false);


--
-- Name: lime_quota_members_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_quota_members_id_seq', 1, false);


--
-- Name: lime_saved_control_scid_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_saved_control_scid_seq', 1, false);


--
-- Name: lime_settings_user_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_settings_user_id_seq', 1, false);


--
-- Name: lime_survey_url_parameters_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_survey_url_parameters_id_seq', 1, false);


--
-- Name: lime_surveymenu_entries_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_surveymenu_entries_id_seq', 27, true);


--
-- Name: lime_surveymenu_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_surveymenu_id_seq', 1, false);


--
-- Name: lime_surveys_groups_gsid_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_surveys_groups_gsid_seq', 1, true);


--
-- Name: lime_template_configuration_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_template_configuration_id_seq', 3, true);


--
-- Name: lime_templates_id_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_templates_id_seq', 3, true);


--
-- Name: lime_tutorial_entries_teid_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_tutorial_entries_teid_seq', 1, false);


--
-- Name: lime_tutorials_tid_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_tutorials_tid_seq', 1, false);


--
-- Name: lime_user_groups_ugid_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_user_groups_ugid_seq', 1, false);


--
-- Name: lime_users_uid_seq; Type: SEQUENCE SET; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

SELECT pg_catalog.setval('limesurveyplayground.lime_users_uid_seq', 1, false);


--
-- Name: lime_answers lime_answers_pk; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_answers
    ADD CONSTRAINT lime_answers_pk PRIMARY KEY (qid, code, language, scale_id);


--
-- Name: lime_assessments lime_assessments_composite_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_assessments
    ADD CONSTRAINT lime_assessments_composite_pkey PRIMARY KEY (id, language);


--
-- Name: lime_asset_version lime_asset_version_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_asset_version
    ADD CONSTRAINT lime_asset_version_pkey PRIMARY KEY (id);


--
-- Name: lime_boxes lime_boxes_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_boxes
    ADD CONSTRAINT lime_boxes_pkey PRIMARY KEY (id);


--
-- Name: lime_conditions lime_conditions_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_conditions
    ADD CONSTRAINT lime_conditions_pkey PRIMARY KEY (cid);


--
-- Name: lime_defaultvalues lime_defaultvalues_pk; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_defaultvalues
    ADD CONSTRAINT lime_defaultvalues_pk PRIMARY KEY (qid, specialtype, language, scale_id, sqid);


--
-- Name: lime_expression_errors lime_expression_errors_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_expression_errors
    ADD CONSTRAINT lime_expression_errors_pkey PRIMARY KEY (id);


--
-- Name: lime_failed_login_attempts lime_failed_login_attempts_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_failed_login_attempts
    ADD CONSTRAINT lime_failed_login_attempts_pkey PRIMARY KEY (id);


--
-- Name: lime_groups lime_groups_composite_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_groups
    ADD CONSTRAINT lime_groups_composite_pkey PRIMARY KEY (gid, language);


--
-- Name: lime_labels lime_labels_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_labels
    ADD CONSTRAINT lime_labels_pkey PRIMARY KEY (id);


--
-- Name: lime_labelsets lime_labelsets_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_labelsets
    ADD CONSTRAINT lime_labelsets_pkey PRIMARY KEY (lid);


--
-- Name: lime_map_tutorial_users lime_map_tutorial_users_pk; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_map_tutorial_users
    ADD CONSTRAINT lime_map_tutorial_users_pk PRIMARY KEY (uid, tid);


--
-- Name: lime_notifications lime_notifications_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_notifications
    ADD CONSTRAINT lime_notifications_pkey PRIMARY KEY (id);


--
-- Name: lime_participant_attribute_names lime_participant_attribute_names_composite_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_participant_attribute_names
    ADD CONSTRAINT lime_participant_attribute_names_composite_pkey PRIMARY KEY (attribute_id, attribute_type);


--
-- Name: lime_participant_attribute_names_lang lime_participant_attribute_names_lang_pk; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_participant_attribute_names_lang
    ADD CONSTRAINT lime_participant_attribute_names_lang_pk PRIMARY KEY (attribute_id, lang);


--
-- Name: lime_participant_attribute lime_participant_attribute_pk; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_participant_attribute
    ADD CONSTRAINT lime_participant_attribute_pk PRIMARY KEY (participant_id, attribute_id);


--
-- Name: lime_participant_attribute_values lime_participant_attribute_values_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_participant_attribute_values
    ADD CONSTRAINT lime_participant_attribute_values_pkey PRIMARY KEY (value_id);


--
-- Name: lime_participants lime_participant_pk; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_participants
    ADD CONSTRAINT lime_participant_pk PRIMARY KEY (participant_id);


--
-- Name: lime_participant_shares lime_participant_shares_pk; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_participant_shares
    ADD CONSTRAINT lime_participant_shares_pk PRIMARY KEY (participant_id, share_uid);


--
-- Name: lime_permissions lime_permissions_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_permissions
    ADD CONSTRAINT lime_permissions_pkey PRIMARY KEY (id);


--
-- Name: lime_plugin_settings lime_plugin_settings_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_plugin_settings
    ADD CONSTRAINT lime_plugin_settings_pkey PRIMARY KEY (id);


--
-- Name: lime_plugins lime_plugins_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_plugins
    ADD CONSTRAINT lime_plugins_pkey PRIMARY KEY (id);


--
-- Name: lime_question_attributes lime_question_attributes_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_question_attributes
    ADD CONSTRAINT lime_question_attributes_pkey PRIMARY KEY (qaid);


--
-- Name: lime_questions lime_questions_composite_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_questions
    ADD CONSTRAINT lime_questions_composite_pkey PRIMARY KEY (qid, language);


--
-- Name: lime_quota_languagesettings lime_quota_languagesettings_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_quota_languagesettings
    ADD CONSTRAINT lime_quota_languagesettings_pkey PRIMARY KEY (quotals_id);


--
-- Name: lime_quota_members lime_quota_members_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_quota_members
    ADD CONSTRAINT lime_quota_members_pkey PRIMARY KEY (id);


--
-- Name: lime_quota lime_quota_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_quota
    ADD CONSTRAINT lime_quota_pkey PRIMARY KEY (id);


--
-- Name: lime_saved_control lime_saved_control_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_saved_control
    ADD CONSTRAINT lime_saved_control_pkey PRIMARY KEY (scid);


--
-- Name: lime_sessions lime_sessions_pk; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_sessions
    ADD CONSTRAINT lime_sessions_pk PRIMARY KEY (id);


--
-- Name: lime_settings_global lime_settings_global_pk; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_settings_global
    ADD CONSTRAINT lime_settings_global_pk PRIMARY KEY (stg_name);


--
-- Name: lime_settings_user lime_settings_user_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_settings_user
    ADD CONSTRAINT lime_settings_user_pkey PRIMARY KEY (id);


--
-- Name: lime_survey_links lime_survey_links_pk; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_survey_links
    ADD CONSTRAINT lime_survey_links_pk PRIMARY KEY (participant_id, token_id, survey_id);


--
-- Name: lime_survey_url_parameters lime_survey_url_parameters_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_survey_url_parameters
    ADD CONSTRAINT lime_survey_url_parameters_pkey PRIMARY KEY (id);


--
-- Name: lime_surveymenu_entries lime_surveymenu_entries_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_surveymenu_entries
    ADD CONSTRAINT lime_surveymenu_entries_pkey PRIMARY KEY (id);


--
-- Name: lime_surveymenu lime_surveymenu_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_surveymenu
    ADD CONSTRAINT lime_surveymenu_pkey PRIMARY KEY (id);


--
-- Name: lime_surveys_groups lime_surveys_groups_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_surveys_groups
    ADD CONSTRAINT lime_surveys_groups_pkey PRIMARY KEY (gsid);


--
-- Name: lime_surveys_languagesettings lime_surveys_languagesettings_pk; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_surveys_languagesettings
    ADD CONSTRAINT lime_surveys_languagesettings_pk PRIMARY KEY (surveyls_survey_id, surveyls_language);


--
-- Name: lime_surveys lime_surveys_pk; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_surveys
    ADD CONSTRAINT lime_surveys_pk PRIMARY KEY (sid);


--
-- Name: lime_template_configuration lime_template_configuration_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_template_configuration
    ADD CONSTRAINT lime_template_configuration_pkey PRIMARY KEY (id);


--
-- Name: lime_templates lime_templates_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_templates
    ADD CONSTRAINT lime_templates_pkey PRIMARY KEY (id);


--
-- Name: lime_tutorial_entries lime_tutorial_entries_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_tutorial_entries
    ADD CONSTRAINT lime_tutorial_entries_pkey PRIMARY KEY (teid);


--
-- Name: lime_tutorial_entry_relation lime_tutorial_entry_relation_pk; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_tutorial_entry_relation
    ADD CONSTRAINT lime_tutorial_entry_relation_pk PRIMARY KEY (teid, tid);


--
-- Name: lime_tutorials lime_tutorials_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_tutorials
    ADD CONSTRAINT lime_tutorials_pkey PRIMARY KEY (tid);


--
-- Name: lime_user_groups lime_user_groups_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_user_groups
    ADD CONSTRAINT lime_user_groups_pkey PRIMARY KEY (ugid);


--
-- Name: lime_user_in_groups lime_user_in_groups_pk; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_user_in_groups
    ADD CONSTRAINT lime_user_in_groups_pk PRIMARY KEY (ugid, uid);


--
-- Name: lime_users lime_users_pkey; Type: CONSTRAINT; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

ALTER TABLE ONLY limesurveyplayground.lime_users
    ADD CONSTRAINT lime_users_pkey PRIMARY KEY (uid);


--
-- Name: lime_answers_idx2; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_answers_idx2 ON limesurveyplayground.lime_answers USING btree (sortorder);


--
-- Name: lime_assessments_idx2; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_assessments_idx2 ON limesurveyplayground.lime_assessments USING btree (sid);


--
-- Name: lime_assessments_idx3; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_assessments_idx3 ON limesurveyplayground.lime_assessments USING btree (gid);


--
-- Name: lime_conditions_idx; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_conditions_idx ON limesurveyplayground.lime_conditions USING btree (qid);


--
-- Name: lime_conditions_idx3; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_conditions_idx3 ON limesurveyplayground.lime_conditions USING btree (cqid);


--
-- Name: lime_idx1_groups; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_groups ON limesurveyplayground.lime_groups USING btree (sid);


--
-- Name: lime_idx1_labels; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_labels ON limesurveyplayground.lime_labels USING btree (code);


--
-- Name: lime_idx1_notifications; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_notifications ON limesurveyplayground.lime_notifications USING btree (hash);


--
-- Name: lime_idx1_participants; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_participants ON limesurveyplayground.lime_participants USING btree (firstname);


--
-- Name: lime_idx1_permissions; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE UNIQUE INDEX lime_idx1_permissions ON limesurveyplayground.lime_permissions USING btree (entity_id, entity, permission, uid);


--
-- Name: lime_idx1_question_attributes; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_question_attributes ON limesurveyplayground.lime_question_attributes USING btree (qid);


--
-- Name: lime_idx1_questions; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_questions ON limesurveyplayground.lime_questions USING btree (sid);


--
-- Name: lime_idx1_quota; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_quota ON limesurveyplayground.lime_quota USING btree (sid);


--
-- Name: lime_idx1_quota_members; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE UNIQUE INDEX lime_idx1_quota_members ON limesurveyplayground.lime_quota_members USING btree (sid, qid, quota_id, code);


--
-- Name: lime_idx1_saved_control; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_saved_control ON limesurveyplayground.lime_saved_control USING btree (sid);


--
-- Name: lime_idx1_settings_user; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_settings_user ON limesurveyplayground.lime_settings_user USING btree (uid);


--
-- Name: lime_idx1_surveymenu_entries; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_surveymenu_entries ON limesurveyplayground.lime_surveymenu_entries USING btree (menu_id);


--
-- Name: lime_idx1_surveys; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_surveys ON limesurveyplayground.lime_surveys USING btree (owner_id);


--
-- Name: lime_idx1_surveys_groups; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_surveys_groups ON limesurveyplayground.lime_surveys_groups USING btree (name);


--
-- Name: lime_idx1_surveys_languagesettings; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_surveys_languagesettings ON limesurveyplayground.lime_surveys_languagesettings USING btree (surveyls_title);


--
-- Name: lime_idx1_template_configuration; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_template_configuration ON limesurveyplayground.lime_template_configuration USING btree (template_name);


--
-- Name: lime_idx1_templates; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_templates ON limesurveyplayground.lime_templates USING btree (name);


--
-- Name: lime_idx1_tutorial_entry_relation; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx1_tutorial_entry_relation ON limesurveyplayground.lime_tutorial_entry_relation USING btree (uid);


--
-- Name: lime_idx1_tutorials; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE UNIQUE INDEX lime_idx1_tutorials ON limesurveyplayground.lime_tutorials USING btree (name);


--
-- Name: lime_idx1_user_groups; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE UNIQUE INDEX lime_idx1_user_groups ON limesurveyplayground.lime_user_groups USING btree (name);


--
-- Name: lime_idx1_users; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE UNIQUE INDEX lime_idx1_users ON limesurveyplayground.lime_users USING btree (users_name);


--
-- Name: lime_idx2_groups; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx2_groups ON limesurveyplayground.lime_groups USING btree (group_name);


--
-- Name: lime_idx2_labels; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx2_labels ON limesurveyplayground.lime_labels USING btree (sortorder);


--
-- Name: lime_idx2_participants; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx2_participants ON limesurveyplayground.lime_participants USING btree (lastname);


--
-- Name: lime_idx2_question_attributes; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx2_question_attributes ON limesurveyplayground.lime_question_attributes USING btree (attribute);


--
-- Name: lime_idx2_questions; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx2_questions ON limesurveyplayground.lime_questions USING btree (gid);


--
-- Name: lime_idx2_saved_control; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx2_saved_control ON limesurveyplayground.lime_saved_control USING btree (srid);


--
-- Name: lime_idx2_settings_user; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx2_settings_user ON limesurveyplayground.lime_settings_user USING btree (entity);


--
-- Name: lime_idx2_surveymenu; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx2_surveymenu ON limesurveyplayground.lime_surveymenu USING btree (title);


--
-- Name: lime_idx2_surveys; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx2_surveys ON limesurveyplayground.lime_surveys USING btree (gsid);


--
-- Name: lime_idx2_surveys_groups; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx2_surveys_groups ON limesurveyplayground.lime_surveys_groups USING btree (title);


--
-- Name: lime_idx2_template_configuration; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx2_template_configuration ON limesurveyplayground.lime_template_configuration USING btree (sid);


--
-- Name: lime_idx2_templates; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx2_templates ON limesurveyplayground.lime_templates USING btree (title);


--
-- Name: lime_idx2_tutorial_entry_relation; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx2_tutorial_entry_relation ON limesurveyplayground.lime_tutorial_entry_relation USING btree (sid);


--
-- Name: lime_idx2_users; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx2_users ON limesurveyplayground.lime_users USING btree (email);


--
-- Name: lime_idx3_groups; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx3_groups ON limesurveyplayground.lime_groups USING btree (language);


--
-- Name: lime_idx3_labels; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx3_labels ON limesurveyplayground.lime_labels USING btree (language);


--
-- Name: lime_idx3_participants; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx3_participants ON limesurveyplayground.lime_participants USING btree (language);


--
-- Name: lime_idx3_questions; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx3_questions ON limesurveyplayground.lime_questions USING btree (type);


--
-- Name: lime_idx3_settings_user; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx3_settings_user ON limesurveyplayground.lime_settings_user USING btree (entity_id);


--
-- Name: lime_idx3_template_configuration; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx3_template_configuration ON limesurveyplayground.lime_template_configuration USING btree (gsid);


--
-- Name: lime_idx3_templates; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx3_templates ON limesurveyplayground.lime_templates USING btree (owner_id);


--
-- Name: lime_idx4_labels; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx4_labels ON limesurveyplayground.lime_labels USING btree (lid, sortorder, language);


--
-- Name: lime_idx4_questions; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx4_questions ON limesurveyplayground.lime_questions USING btree (title);


--
-- Name: lime_idx4_settings_user; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx4_settings_user ON limesurveyplayground.lime_settings_user USING btree (stg_name);


--
-- Name: lime_idx4_template_configuration; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx4_template_configuration ON limesurveyplayground.lime_template_configuration USING btree (uid);


--
-- Name: lime_idx4_templates; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx4_templates ON limesurveyplayground.lime_templates USING btree (extends);


--
-- Name: lime_idx5_questions; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx5_questions ON limesurveyplayground.lime_questions USING btree (parent_qid);


--
-- Name: lime_idx5_surveymenu_entries; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx5_surveymenu_entries ON limesurveyplayground.lime_surveymenu_entries USING btree (menu_title);


--
-- Name: lime_idx_participant_attribute_names; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_idx_participant_attribute_names ON limesurveyplayground.lime_participant_attribute_names USING btree (attribute_id, attribute_type);


--
-- Name: lime_notifications_pk; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE INDEX lime_notifications_pk ON limesurveyplayground.lime_notifications USING btree (entity, entity_id, status);


--
-- Name: lime_surveymenu_entries_name; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE UNIQUE INDEX lime_surveymenu_entries_name ON limesurveyplayground.lime_surveymenu_entries USING btree (name);


--
-- Name: lime_surveymenu_name; Type: INDEX; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

CREATE UNIQUE INDEX lime_surveymenu_name ON limesurveyplayground.lime_surveymenu USING btree (name);


--
-- Name: SCHEMA limesurveyplayground; Type: ACL; Schema: -; Owner: limesurveyplayground_admin
--

GRANT USAGE ON SCHEMA limesurveyplayground TO limesurveyplayground_user;


--
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: advpg
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO limesurveyplayground_admin;
GRANT USAGE ON SCHEMA public TO limesurveyplayground_user;


--
-- Name: TABLE lime_answers; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_answers TO limesurveyplayground_user;


--
-- Name: TABLE lime_assessments; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_assessments TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_assessments_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_assessments_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_asset_version; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_asset_version TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_asset_version_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_asset_version_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_boxes; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_boxes TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_boxes_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_boxes_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_conditions; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_conditions TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_conditions_cid_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_conditions_cid_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_defaultvalues; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_defaultvalues TO limesurveyplayground_user;


--
-- Name: TABLE lime_expression_errors; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_expression_errors TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_expression_errors_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_expression_errors_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_failed_login_attempts; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_failed_login_attempts TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_failed_login_attempts_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_failed_login_attempts_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_groups; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_groups TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_groups_gid_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_groups_gid_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_labels; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_labels TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_labels_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_labels_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_labelsets; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_labelsets TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_labelsets_lid_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_labelsets_lid_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_map_tutorial_users; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_map_tutorial_users TO limesurveyplayground_user;


--
-- Name: TABLE lime_notifications; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_notifications TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_notifications_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_notifications_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_participant_attribute; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_participant_attribute TO limesurveyplayground_user;


--
-- Name: TABLE lime_participant_attribute_names; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_participant_attribute_names TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_participant_attribute_names_attribute_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_participant_attribute_names_attribute_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_participant_attribute_names_lang; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_participant_attribute_names_lang TO limesurveyplayground_user;


--
-- Name: TABLE lime_participant_attribute_values; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_participant_attribute_values TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_participant_attribute_values_value_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_participant_attribute_values_value_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_participant_shares; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_participant_shares TO limesurveyplayground_user;


--
-- Name: TABLE lime_participants; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_participants TO limesurveyplayground_user;


--
-- Name: TABLE lime_permissions; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_permissions TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_permissions_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_permissions_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_plugin_settings; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_plugin_settings TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_plugin_settings_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_plugin_settings_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_plugins; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_plugins TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_plugins_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_plugins_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_question_attributes; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_question_attributes TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_question_attributes_qaid_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_question_attributes_qaid_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_questions; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_questions TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_questions_qid_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_questions_qid_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_quota; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_quota TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_quota_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_quota_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_quota_languagesettings; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_quota_languagesettings TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_quota_languagesettings_quotals_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_quota_languagesettings_quotals_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_quota_members; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_quota_members TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_quota_members_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_quota_members_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_saved_control; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_saved_control TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_saved_control_scid_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_saved_control_scid_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_sessions; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_sessions TO limesurveyplayground_user;


--
-- Name: TABLE lime_settings_global; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_settings_global TO limesurveyplayground_user;


--
-- Name: TABLE lime_settings_user; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_settings_user TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_settings_user_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_settings_user_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_survey_links; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_survey_links TO limesurveyplayground_user;


--
-- Name: TABLE lime_survey_url_parameters; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_survey_url_parameters TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_survey_url_parameters_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_survey_url_parameters_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_surveymenu; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_surveymenu TO limesurveyplayground_user;


--
-- Name: TABLE lime_surveymenu_entries; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_surveymenu_entries TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_surveymenu_entries_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_surveymenu_entries_id_seq TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_surveymenu_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_surveymenu_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_surveys; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_surveys TO limesurveyplayground_user;


--
-- Name: TABLE lime_surveys_groups; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_surveys_groups TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_surveys_groups_gsid_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_surveys_groups_gsid_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_surveys_languagesettings; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_surveys_languagesettings TO limesurveyplayground_user;


--
-- Name: TABLE lime_template_configuration; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_template_configuration TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_template_configuration_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_template_configuration_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_templates; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_templates TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_templates_id_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_templates_id_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_tutorial_entries; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_tutorial_entries TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_tutorial_entries_teid_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_tutorial_entries_teid_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_tutorial_entry_relation; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_tutorial_entry_relation TO limesurveyplayground_user;


--
-- Name: TABLE lime_tutorials; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_tutorials TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_tutorials_tid_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_tutorials_tid_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_user_groups; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_user_groups TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_user_groups_ugid_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_user_groups_ugid_seq TO limesurveyplayground_user;


--
-- Name: TABLE lime_user_in_groups; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_user_in_groups TO limesurveyplayground_user;


--
-- Name: TABLE lime_users; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE limesurveyplayground.lime_users TO limesurveyplayground_user;


--
-- Name: SEQUENCE lime_users_uid_seq; Type: ACL; Schema: limesurveyplayground; Owner: limesurveyplayground_admin
--

GRANT SELECT,UPDATE ON SEQUENCE limesurveyplayground.lime_users_uid_seq TO limesurveyplayground_user;


--
-- Name: DEFAULT PRIVILEGES FOR SEQUENCES; Type: DEFAULT ACL; Schema: -; Owner: limesurveyplayground_admin
--

ALTER DEFAULT PRIVILEGES FOR ROLE limesurveyplayground_admin GRANT SELECT,UPDATE ON SEQUENCES  TO limesurveyplayground_user;


--
-- Name: DEFAULT PRIVILEGES FOR FUNCTIONS; Type: DEFAULT ACL; Schema: -; Owner: limesurveyplayground_users
--

ALTER DEFAULT PRIVILEGES FOR ROLE limesurveyplayground_users REVOKE ALL ON FUNCTIONS  FROM PUBLIC;


--
-- Name: DEFAULT PRIVILEGES FOR FUNCTIONS; Type: DEFAULT ACL; Schema: -; Owner: limesurveyplayground_admin
--

ALTER DEFAULT PRIVILEGES FOR ROLE limesurveyplayground_admin REVOKE ALL ON FUNCTIONS  FROM PUBLIC;
ALTER DEFAULT PRIVILEGES FOR ROLE limesurveyplayground_admin GRANT ALL ON FUNCTIONS  TO limesurveyplayground_user;


--
-- Name: DEFAULT PRIVILEGES FOR FUNCTIONS; Type: DEFAULT ACL; Schema: -; Owner: limesurveyplayground_user
--

ALTER DEFAULT PRIVILEGES FOR ROLE limesurveyplayground_user REVOKE ALL ON FUNCTIONS  FROM PUBLIC;


--
-- Name: DEFAULT PRIVILEGES FOR SCHEMAS; Type: DEFAULT ACL; Schema: -; Owner: limesurveyplayground_admin
--

ALTER DEFAULT PRIVILEGES FOR ROLE limesurveyplayground_admin GRANT USAGE ON SCHEMAS  TO limesurveyplayground_user;


--
-- Name: DEFAULT PRIVILEGES FOR TABLES; Type: DEFAULT ACL; Schema: -; Owner: limesurveyplayground_admin
--

ALTER DEFAULT PRIVILEGES FOR ROLE limesurveyplayground_admin GRANT SELECT,INSERT,DELETE,UPDATE ON TABLES  TO limesurveyplayground_user;


--
-- PostgreSQL database dump complete
--