2019-04-19 08:25:47.848 CEST,,,15408,,5cb969eb.3c30,1,,2019-04-19 08:25:47 CEST,,0,LOG,00000,"ending log output to stderr",,"Future log output will go to log destination ""csvlog"".",,,,,,,"" 2019-04-19 08:25:47.851 CEST,,,15414,,5cb969eb.3c36,1,,2019-04-19 08:25:47 CEST,,0,LOG,00000,"database system was shut down at 2019-04-19 08:25:47 CEST",,,,,,,,,"" 2019-04-19 08:25:47.854 CEST,,,15408,,5cb969eb.3c30,2,,2019-04-19 08:25:47 CEST,,0,LOG,00000,"database system is ready to accept connections",,,,,,,,,"" 2019-04-19 08:25:54.913 CEST,,,15438,"[local]",5cb969f2.3c4e,1,"",2019-04-19 08:25:54 CEST,,0,LOG,00000,"connection received: host=[local]",,,,,,,,,"" 2019-04-19 08:25:54.914 CEST,"advpg","template1",15438,"[local]",5cb969f2.3c4e,2,"authentication",2019-04-19 08:25:54 CEST,3/1,0,LOG,00000,"connection authorized: user=advpg database=template1",,,,,,,,,"" 2019-04-19 08:25:54.917 CEST,"advpg","template1",15438,"[local]",5cb969f2.3c4e,3,"idle",2019-04-19 08:25:54 CEST,3/2,0,LOG,00000,"statement: CREATE EXTENSION adminpack",,,,,,,,,"psql" 2019-04-19 08:25:54.925 CEST,"advpg","template1",15438,"[local]",5cb969f2.3c4e,4,"idle",2019-04-19 08:25:54 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.012 user=advpg database=template1 host=[local]",,,,,,,,,"psql" 2019-04-19 08:25:54.929 CEST,,,15441,"[local]",5cb969f2.3c51,1,"",2019-04-19 08:25:54 CEST,,0,LOG,00000,"connection received: host=[local]",,,,,,,,,"" 2019-04-19 08:25:54.930 CEST,"advpg","postgres",15441,"[local]",5cb969f2.3c51,2,"authentication",2019-04-19 08:25:54 CEST,3/3,0,LOG,00000,"connection authorized: user=advpg database=postgres",,,,,,,,,"" 2019-04-19 08:25:54.934 CEST,"advpg","postgres",15441,"[local]",5cb969f2.3c51,3,"idle",2019-04-19 08:25:54 CEST,3/4,0,LOG,00000,"statement: CREATE EXTENSION adminpack",,,,,,,,,"psql" 2019-04-19 08:25:54.938 CEST,"advpg","postgres",15441,"[local]",5cb969f2.3c51,4,"idle",2019-04-19 08:25:54 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.008 user=advpg database=postgres host=[local]",,,,,,,,,"psql" 2019-04-19 08:25:54.943 CEST,,,15444,"[local]",5cb969f2.3c54,1,"",2019-04-19 08:25:54 CEST,,0,LOG,00000,"connection received: host=[local]",,,,,,,,,"" 2019-04-19 08:25:54.944 CEST,"advpg","template1",15444,"[local]",5cb969f2.3c54,2,"authentication",2019-04-19 08:25:54 CEST,3/5,0,LOG,00000,"connection authorized: user=advpg database=template1",,,,,,,,,"" 2019-04-19 08:25:54.945 CEST,"advpg","template1",15444,"[local]",5cb969f2.3c54,3,"idle",2019-04-19 08:25:54 CEST,3/6,0,LOG,00000,"statement: CREATE EXTENSION pgrowlocks SCHEMA public",,,,,,,,,"psql" 2019-04-19 08:25:54.951 CEST,"advpg","template1",15444,"[local]",5cb969f2.3c54,4,"idle",2019-04-19 08:25:54 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.007 user=advpg database=template1 host=[local]",,,,,,,,,"psql" 2019-04-19 08:25:54.956 CEST,,,15447,"[local]",5cb969f2.3c57,1,"",2019-04-19 08:25:54 CEST,,0,LOG,00000,"connection received: host=[local]",,,,,,,,,"" 2019-04-19 08:25:54.956 CEST,"advpg","template1",15447,"[local]",5cb969f2.3c57,2,"authentication",2019-04-19 08:25:54 CEST,3/7,0,LOG,00000,"connection authorized: user=advpg database=template1",,,,,,,,,"" 2019-04-19 08:25:54.958 CEST,"advpg","template1",15447,"[local]",5cb969f2.3c57,3,"idle",2019-04-19 08:25:54 CEST,3/8,0,LOG,00000,"statement: CREATE OR REPLACE FUNCTION public.table_columns( IN table_name character varying, IN 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 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$$ LANGUAGE SQL STABLE STRICT SECURITY INVOKER;",,,,,,,,,"psql" 2019-04-19 08:25:54.965 CEST,"advpg","template1",15447,"[local]",5cb969f2.3c57,4,"idle",2019-04-19 08:25:54 CEST,3/9,0,LOG,00000,"statement: COMMENT ON FUNCTION public.table_columns(character varying, character varying) IS $$returns all columns for a table or view with their interesting properties$$;",,,,,,,,,"psql" 2019-04-19 08:25:54.966 CEST,"advpg","template1",15447,"[local]",5cb969f2.3c57,5,"idle",2019-04-19 08:25:54 CEST,3/10,0,LOG,00000,"statement: CREATE OR REPLACE FUNCTION public.function_args( IN funcname character varying, IN schema character varying, OUT pos integer, OUT direction character, OUT argname character varying, OUT datatype character varying) RETURNS SETOF RECORD 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;$$ LANGUAGE plpgsql STABLE STRICT SECURITY INVOKER;",,,,,,,,,"psql" 2019-04-19 08:25:54.968 CEST,"advpg","template1",15447,"[local]",5cb969f2.3c57,6,"idle",2019-04-19 08:25:54 CEST,3/11,0,LOG,00000,"statement: COMMENT ON FUNCTION public.function_args(character varying, 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$$;",,,,,,,,,"psql" 2019-04-19 08:25:54.969 CEST,"advpg","template1",15447,"[local]",5cb969f2.3c57,7,"idle",2019-04-19 08:25:54 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.013 user=advpg database=template1 host=[local]",,,,,,,,,"psql" 2019-04-19 08:25:54.974 CEST,,,15450,"[local]",5cb969f2.3c5a,1,"",2019-04-19 08:25:54 CEST,,0,LOG,00000,"connection received: host=[local]",,,,,,,,,"" 2019-04-19 08:25:54.975 CEST,"advpg","template1",15450,"[local]",5cb969f2.3c5a,2,"authentication",2019-04-19 08:25:54 CEST,3/12,0,LOG,00000,"connection authorized: user=advpg database=template1",,,,,,,,,"" 2019-04-19 08:25:54.976 CEST,"advpg","template1",15450,"[local]",5cb969f2.3c5a,3,"idle",2019-04-19 08:25:54 CEST,3/13,0,LOG,00000,"statement: CREATE EXTENSION pg_stat_statements SCHEMA public",,,,,,,,,"psql" 2019-04-19 08:25:54.985 CEST,"advpg","template1",15450,"[local]",5cb969f2.3c5a,4,"idle",2019-04-19 08:25:54 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.010 user=advpg database=template1 host=[local]",,,,,,,,,"psql" 2019-04-19 08:25:54.990 CEST,,,15453,"[local]",5cb969f2.3c5d,1,"",2019-04-19 08:25:54 CEST,,0,LOG,00000,"connection received: host=[local]",,,,,,,,,"" 2019-04-19 08:25:54.991 CEST,"advpg","postgres",15453,"[local]",5cb969f2.3c5d,2,"authentication",2019-04-19 08:25:54 CEST,3/14,0,LOG,00000,"connection authorized: user=advpg database=postgres",,,,,,,,,"" 2019-04-19 08:25:54.992 CEST,"advpg","postgres",15453,"[local]",5cb969f2.3c5d,3,"idle",2019-04-19 08:25:54 CEST,3/15,0,LOG,00000,"statement: CREATE EXTENSION pg_stat_statements SCHEMA public",,,,,,,,,"psql" 2019-04-19 08:25:54.998 CEST,"advpg","postgres",15453,"[local]",5cb969f2.3c5d,4,"idle",2019-04-19 08:25:54 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.008 user=advpg database=postgres host=[local]",,,,,,,,,"psql" 2019-04-19 08:25:55.003 CEST,,,15456,"[local]",5cb969f3.3c60,1,"",2019-04-19 08:25:55 CEST,,0,LOG,00000,"connection received: host=[local]",,,,,,,,,"" 2019-04-19 08:25:55.004 CEST,"advpg","template1",15456,"[local]",5cb969f3.3c60,2,"authentication",2019-04-19 08:25:55 CEST,3/16,0,LOG,00000,"connection authorized: user=advpg database=template1",,,,,,,,,"" 2019-04-19 08:25:55.005 CEST,"advpg","template1",15456,"[local]",5cb969f3.3c60,3,"idle",2019-04-19 08:25:55 CEST,3/17,0,LOG,00000,"statement: REVOKE CREATE ON SCHEMA PUBLIC FROM PUBLIC",,,,,,,,,"psql" 2019-04-19 08:25:55.006 CEST,"advpg","template1",15456,"[local]",5cb969f3.3c60,4,"idle",2019-04-19 08:25:55 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.002 user=advpg database=template1 host=[local]",,,,,,,,,"psql" 2019-04-19 08:26:29.346 CEST,,,15545,"[local]",5cb96a15.3cb9,1,"",2019-04-19 08:26:29 CEST,,0,LOG,00000,"connection received: host=[local]",,,,,,,,,"" 2019-04-19 08:26:29.347 CEST,"advpg","postgres",15545,"[local]",5cb96a15.3cb9,2,"authentication",2019-04-19 08:26:29 CEST,3/18,0,LOG,00000,"connection authorized: user=advpg database=postgres",,,,,,,,,"" 2019-04-19 08:26:30.113 CEST,,,15548,"[local]",5cb96a16.3cbc,1,"",2019-04-19 08:26:30 CEST,,0,LOG,00000,"connection received: host=[local]",,,,,,,,,"" 2019-04-19 08:26:30.113 CEST,"advpg","template1",15548,"[local]",5cb96a16.3cbc,2,"authentication",2019-04-19 08:26:30 CEST,4/1,0,LOG,00000,"connection authorized: user=advpg database=template1",,,,,,,,,"" 2019-04-19 08:26:30.114 CEST,"advpg","postgres",15545,"[local]",5cb96a15.3cb9,3,"idle",2019-04-19 08:26:29 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.767 user=advpg database=postgres host=[local]",,,,,,,,,"psql" 2019-04-19 08:26:30.117 CEST,"advpg","template1",15548,"[local]",5cb96a16.3cbc,3,"idle",2019-04-19 08:26:30 CEST,4/2,0,LOG,00000,"statement: create role limesurveyplayground_admin nosuperuser nocreatedb nocreaterole login password 'abclimesurveyplaygroundcba' valid until 'infinity';",,,,,,,,,"psql" 2019-04-19 08:26:30.121 CEST,"advpg","template1",15548,"[local]",5cb96a16.3cbc,4,"idle",2019-04-19 08:26:30 CEST,4/3,0,LOG,00000,"statement: create role limesurveyplayground_user nosuperuser nocreatedb nocreaterole login password 'abclimesurveyplaygroundcba' valid until 'infinity';",,,,,,,,,"psql" 2019-04-19 08:26:30.126 CEST,"advpg","template1",15548,"[local]",5cb96a16.3cbc,5,"idle",2019-04-19 08:26:30 CEST,4/4,0,LOG,00000,"statement: create role limesurveyplayground_users nosuperuser nocreatedb nocreaterole nologin;",,,,,,,,,"psql" 2019-04-19 08:26:30.128 CEST,"advpg","template1",15548,"[local]",5cb96a16.3cbc,6,"idle",2019-04-19 08:26:30 CEST,4/5,0,LOG,00000,"statement: grant limesurveyplayground_users to limesurveyplayground_admin, limesurveyplayground_user;",,,,,,,,,"psql" 2019-04-19 08:26:30.131 CEST,"advpg","template1",15548,"[local]",5cb96a16.3cbc,7,"idle",2019-04-19 08:26:30 CEST,4/6,0,LOG,00000,"statement: create database limesurveyplayground owner advpg CONNECTION LIMIT -1;",,,,,,,,,"psql" 2019-04-19 08:26:30.132 CEST,,,15415,,5cb969eb.3c37,1,,2019-04-19 08:25:47 CEST,,0,LOG,00000,"checkpoint starting: immediate force wait flush-all",,,,,,,,,"" 2019-04-19 08:26:30.148 CEST,,,15415,,5cb969eb.3c37,2,,2019-04-19 08:25:47 CEST,,0,LOG,00000,"checkpoint complete: wrote 137 buffers (0.8%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.001 s, total=0.015 s; sync files=89, longest=0.001 s, average=0.000 s; distance=603 kB, estimate=603 kB",,,,,,,,,"" 2019-04-19 08:26:30.258 CEST,,,15415,,5cb969eb.3c37,3,,2019-04-19 08:25:47 CEST,,0,LOG,00000,"checkpoint starting: immediate force wait",,,,,,,,,"" 2019-04-19 08:26:30.263 CEST,,,15415,,5cb969eb.3c37,4,,2019-04-19 08:25:47 CEST,,0,LOG,00000,"checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.000 s, total=0.005 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=543 kB",,,,,,,,,"" 2019-04-19 08:26:30.360 CEST,,,15550,"[local]",5cb96a16.3cbe,1,"",2019-04-19 08:26:30 CEST,,0,LOG,00000,"connection received: host=[local]",,,,,,,,,"" 2019-04-19 08:26:30.361 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,2,"authentication",2019-04-19 08:26:30 CEST,3/19,0,LOG,00000,"connection authorized: user=advpg database=limesurveyplayground",,,,,,,,,"" 2019-04-19 08:26:30.362 CEST,"advpg","template1",15548,"[local]",5cb96a16.3cbc,8,"idle",2019-04-19 08:26:30 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.249 user=advpg database=template1 host=[local]",,,,,,,,,"psql" 2019-04-19 08:26:30.364 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,3,"idle",2019-04-19 08:26:30 CEST,3/20,0,LOG,00000,"statement: ALTER DEFAULT PRIVILEGES FOR ROLE limesurveyplayground_users REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC;",,,,,,,,,"psql" 2019-04-19 08:26:30.367 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,4,"idle",2019-04-19 08:26:30 CEST,3/21,0,LOG,00000,"statement: ALTER DEFAULT PRIVILEGES FOR ROLE limesurveyplayground_admin REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC;",,,,,,,,,"psql" 2019-04-19 08:26:30.370 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,5,"idle",2019-04-19 08:26:30 CEST,3/22,0,LOG,00000,"statement: ALTER DEFAULT PRIVILEGES FOR ROLE limesurveyplayground_user REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC;",,,,,,,,,"psql" 2019-04-19 08:26:30.373 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,6,"idle",2019-04-19 08:26:30 CEST,3/23,0,LOG,00000,"statement: ALTER DEFAULT PRIVILEGES FOR ROLE limesurveyplayground_admin GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO limesurveyplayground_user;",,,,,,,,,"psql" 2019-04-19 08:26:30.376 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,7,"idle",2019-04-19 08:26:30 CEST,3/24,0,LOG,00000,"statement: ALTER DEFAULT PRIVILEGES FOR ROLE limesurveyplayground_admin GRANT SELECT, UPDATE ON SEQUENCES TO limesurveyplayground_user;",,,,,,,,,"psql" 2019-04-19 08:26:30.378 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,8,"idle",2019-04-19 08:26:30 CEST,3/25,0,LOG,00000,"statement: ALTER DEFAULT PRIVILEGES FOR ROLE limesurveyplayground_admin GRANT EXECUTE ON FUNCTIONS TO limesurveyplayground_user;",,,,,,,,,"psql" 2019-04-19 08:26:30.381 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,9,"idle",2019-04-19 08:26:30 CEST,3/26,0,LOG,00000,"statement: ALTER DEFAULT PRIVILEGES FOR ROLE limesurveyplayground_admin GRANT USAGE ON SCHEMAS TO limesurveyplayground_user;",,,,,,,,,"psql" 2019-04-19 08:26:30.383 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,10,"idle",2019-04-19 08:26:30 CEST,3/27,0,LOG,00000,"statement: grant create on database limesurveyplayground to limesurveyplayground_admin;",,,,,,,,,"psql" 2019-04-19 08:26:30.385 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,11,"idle",2019-04-19 08:26:30 CEST,3/28,0,LOG,00000,"statement: grant create, usage on schema public to limesurveyplayground_admin;",,,,,,,,,"psql" 2019-04-19 08:26:30.387 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,12,"idle",2019-04-19 08:26:30 CEST,3/29,0,LOG,00000,"statement: grant usage on schema public to limesurveyplayground_user;",,,,,,,,,"psql" 2019-04-19 08:26:30.388 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,13,"idle",2019-04-19 08:26:30 CEST,3/30,0,LOG,00000,"statement: revoke usage, create on schema public from public;",,,,,,,,,"psql" 2019-04-19 08:26:30.390 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,14,"idle",2019-04-19 08:26:30 CEST,3/31,0,LOG,00000,"statement: create schema limesurveyplayground authorization limesurveyplayground_admin;",,,,,,,,,"psql" 2019-04-19 08:26:30.392 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,15,"idle",2019-04-19 08:26:30 CEST,3/32,0,LOG,00000,"statement: grant usage on schema limesurveyplayground to limesurveyplayground_user;",,,,,,,,,"psql" 2019-04-19 08:26:30.393 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,16,"idle",2019-04-19 08:26:30 CEST,3/33,0,LOG,00000,"statement: alter role limesurveyplayground_admin set search_path = limesurveyplayground, public;",,,,,,,,,"psql" 2019-04-19 08:26:30.395 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,17,"idle",2019-04-19 08:26:30 CEST,3/34,0,LOG,00000,"statement: alter role limesurveyplayground_user set search_path = limesurveyplayground, public;",,,,,,,,,"psql" 2019-04-19 08:26:30.398 CEST,,,15551,"[local]",5cb96a16.3cbf,1,"",2019-04-19 08:26:30 CEST,,0,LOG,00000,"connection received: host=[local]",,,,,,,,,"" 2019-04-19 08:26:30.399 CEST,"limesurveyplayground_admin","limesurveyplayground",15551,"[local]",5cb96a16.3cbf,2,"authentication",2019-04-19 08:26:30 CEST,4/7,0,LOG,00000,"connection authorized: user=limesurveyplayground_admin database=limesurveyplayground",,,,,,,,,"" 2019-04-19 08:26:30.400 CEST,"advpg","limesurveyplayground",15550,"[local]",5cb96a16.3cbe,18,"idle",2019-04-19 08:26:30 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.039 user=advpg database=limesurveyplayground host=[local]",,,,,,,,,"psql" 2019-04-19 08:26:32.263 CEST,"limesurveyplayground_admin","limesurveyplayground",15551,"[local]",5cb96a16.3cbf,3,"idle",2019-04-19 08:26:30 CEST,,0,LOG,00000,"disconnection: session time: 0:00:01.865 user=limesurveyplayground_admin database=limesurveyplayground host=[local]",,,,,,,,,"psql" 2019-04-19 08:27:36.842 CEST,,,15408,,5cb969eb.3c30,3,,2019-04-19 08:25:47 CEST,,0,LOG,00000,"received SIGHUP, reloading configuration files",,,,,,,,,"" 2019-04-19 08:27:36.842 CEST,,,15408,,5cb969eb.3c30,4,,2019-04-19 08:25:47 CEST,,0,LOG,00000,"parameter ""log_min_messages"" changed to ""error""",,,,,,,,,"" 2019-04-19 08:27:36.842 CEST,,,15408,,5cb969eb.3c30,5,,2019-04-19 08:25:47 CEST,,0,LOG,00000,"parameter ""log_min_error_statement"" changed to ""error""",,,,,,,,,"" 2019-04-19 08:27:36.842 CEST,,,15408,,5cb969eb.3c30,6,,2019-04-19 08:25:47 CEST,,0,LOG,00000,"parameter ""log_min_duration_statement"" changed to ""0""",,,,,,,,,"" 2019-04-19 08:31:30.846 CEST,,,15415,,5cb969eb.3c37,5,,2019-04-19 08:25:47 CEST,,0,LOG,00000,"checkpoint starting: time",,,,,,,,,"" 2019-04-19 08:31:32.763 CEST,,,15415,,5cb969eb.3c37,6,,2019-04-19 08:25:47 CEST,,0,LOG,00000,"checkpoint complete: wrote 19 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.904 s, sync=0.002 s, total=1.916 s; sync files=16, longest=0.002 s, average=0.000 s; distance=14 kB, estimate=490 kB",,,,,,,,,"" 2019-04-19 08:32:01.753 CEST,,,16386,"10.153.99.8:35738",5cb96b61.4002,1,"",2019-04-19 08:32:01 CEST,,0,LOG,00000,"connection received: host=10.153.99.8 port=35738",,,,,,,,,"" 2019-04-19 08:32:01.759 CEST,"limesurveyplayground_admin","limesurveyplayground",16386,"10.153.99.8:35738",5cb96b61.4002,2,"authentication",2019-04-19 08:32:01 CEST,3/67,0,LOG,00000,"connection authorized: user=limesurveyplayground_admin database=limesurveyplayground SSL enabled (protocol=TLSv1.2, cipher=ECDHE-RSA-AES256-GCM-SHA384, compression=off)",,,,,,,,,"" 2019-04-19 08:32:01.761 CEST,"limesurveyplayground_admin","limesurveyplayground",16386,"10.153.99.8:35738",5cb96b61.4002,3,"idle",2019-04-19 08:32:01 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.007 user=limesurveyplayground_admin database=limesurveyplayground host=10.153.99.8 port=35738",,,,,,,,,"" 2019-04-19 08:32:01.762 CEST,,,16387,"10.153.99.8:35740",5cb96b61.4003,1,"",2019-04-19 08:32:01 CEST,,0,LOG,00000,"connection received: host=10.153.99.8 port=35740",,,,,,,,,"" 2019-04-19 08:32:01.767 CEST,"limesurveyplayground_admin","limesurveyplayground",16387,"10.153.99.8:35740",5cb96b61.4003,2,"authentication",2019-04-19 08:32:01 CEST,3/68,0,LOG,00000,"connection authorized: user=limesurveyplayground_admin database=limesurveyplayground SSL enabled (protocol=TLSv1.2, cipher=ECDHE-RSA-AES256-GCM-SHA384, compression=off)",,,,,,,,,"" 2019-04-19 08:32:01.768 CEST,"limesurveyplayground_admin","limesurveyplayground",16387,"10.153.99.8:35740",5cb96b61.4003,3,"idle",2019-04-19 08:32:01 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.006 user=limesurveyplayground_admin database=limesurveyplayground host=10.153.99.8 port=35740",,,,,,,,,"" 2019-04-19 08:32:01.770 CEST,,,16388,"10.153.99.8:35742",5cb96b61.4004,1,"",2019-04-19 08:32:01 CEST,,0,LOG,00000,"connection received: host=10.153.99.8 port=35742",,,,,,,,,"" 2019-04-19 08:32:01.776 CEST,"limesurveyplayground_admin","limesurveyplayground",16388,"10.153.99.8:35742",5cb96b61.4004,2,"authentication",2019-04-19 08:32:01 CEST,3/69,0,LOG,00000,"connection authorized: user=limesurveyplayground_admin database=limesurveyplayground SSL enabled (protocol=TLSv1.2, cipher=ECDHE-RSA-AES256-GCM-SHA384, compression=off)",,,,,,,,,"" 2019-04-19 08:32:01.784 CEST,"limesurveyplayground_admin","limesurveyplayground",16388,"10.153.99.8:35742",5cb96b61.4004,3,"SELECT",2019-04-19 08:32:01 CEST,3/70,0,ERROR,42P01,"relation ""lime_users"" does not exist",,,,,,"SELECT * FROM ""lime_users""",15,,"" 2019-04-19 08:32:01.789 CEST,"limesurveyplayground_admin","limesurveyplayground",16388,"10.153.99.8:35742",5cb96b61.4004,4,"idle",2019-04-19 08:32:01 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.018 user=limesurveyplayground_admin database=limesurveyplayground host=10.153.99.8 port=35742",,,,,,,,,"" 2019-04-19 08:32:07.968 CEST,,,16402,"10.153.99.8:35744",5cb96b67.4012,1,"",2019-04-19 08:32:07 CEST,,0,LOG,00000,"connection received: host=10.153.99.8 port=35744",,,,,,,,,"" 2019-04-19 08:32:07.973 CEST,"limesurveyplayground_admin","limesurveyplayground",16402,"10.153.99.8:35744",5cb96b67.4012,2,"authentication",2019-04-19 08:32:07 CEST,3/71,0,LOG,00000,"connection authorized: user=limesurveyplayground_admin database=limesurveyplayground SSL enabled (protocol=TLSv1.2, cipher=ECDHE-RSA-AES256-GCM-SHA384, compression=off)",,,,,,,,,"" 2019-04-19 08:32:07.975 CEST,"limesurveyplayground_admin","limesurveyplayground",16402,"10.153.99.8:35744",5cb96b67.4012,3,"idle",2019-04-19 08:32:07 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.007 user=limesurveyplayground_admin database=limesurveyplayground host=10.153.99.8 port=35744",,,,,,,,,"" 2019-04-19 08:32:07.976 CEST,,,16403,"10.153.99.8:35746",5cb96b67.4013,1,"",2019-04-19 08:32:07 CEST,,0,LOG,00000,"connection received: host=10.153.99.8 port=35746",,,,,,,,,"" 2019-04-19 08:32:07.982 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,2,"authentication",2019-04-19 08:32:07 CEST,3/72,0,LOG,00000,"connection authorized: user=limesurveyplayground_admin database=limesurveyplayground SSL enabled (protocol=TLSv1.2, cipher=ECDHE-RSA-AES256-GCM-SHA384, compression=off)",,,,,,,,,"" 2019-04-19 08:32:07.997 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,3,"BEGIN",2019-04-19 08:32:07 CEST,3/73,0,LOG,00000,"duration: 0.152 ms statement: BEGIN",,,,,,,,,"" 2019-04-19 08:32:07.999 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,4,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,0,LOG,00000,"statement: CREATE TABLE ""lime_answers"" ( ""qid"" integer NOT NULL, ""code"" character varying (5) NOT NULL, ""answer"" text NOT NULL, ""sortorder"" integer NOT NULL, ""assessment_value"" integer NOT NULL DEFAULT 0, ""language"" character varying (20) NOT NULL DEFAULT 'en', ""scale_id"" integer NOT NULL DEFAULT 0 )",,,,,,,,,"" 2019-04-19 08:32:08.005 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,5,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 6.275 ms",,,,,,,,,"" 2019-04-19 08:32:08.005 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,6,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: ALTER TABLE ""lime_answers"" ADD CONSTRAINT ""lime_answers_pk"" PRIMARY KEY (""qid"", ""code"", ""language"", ""scale_id"" )",,,,,,,,,"" 2019-04-19 08:32:08.008 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,7,"ALTER TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 3.041 ms",,,,,,,,,"" 2019-04-19 08:32:08.009 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,8,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_answers_idx2"" ON ""lime_answers"" (""sortorder"")",,,,,,,,,"" 2019-04-19 08:32:08.011 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,9,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.246 ms",,,,,,,,,"" 2019-04-19 08:32:08.012 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,10,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_assessments"" ( ""id"" serial, ""sid"" integer NOT NULL DEFAULT 0, ""scope"" character varying (5) NOT NULL, ""gid"" integer NOT NULL DEFAULT 0, ""name"" text NOT NULL, ""minimum"" character varying (50) NOT NULL, ""maximum"" character varying (50) NOT NULL, ""message"" text NOT NULL, ""language"" character varying (20) NOT NULL DEFAULT 'en', CONSTRAINT lime_assessments_composite_pkey PRIMARY KEY (id, language) )",,,,,,,,,"" 2019-04-19 08:32:08.018 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,11,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 5.867 ms",,,,,,,,,"" 2019-04-19 08:32:08.018 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,12,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_assessments_idx2"" ON ""lime_assessments"" (""sid"")",,,,,,,,,"" 2019-04-19 08:32:08.020 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,13,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.916 ms",,,,,,,,,"" 2019-04-19 08:32:08.021 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,14,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_assessments_idx3"" ON ""lime_assessments"" (""gid"")",,,,,,,,,"" 2019-04-19 08:32:08.022 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,15,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.578 ms",,,,,,,,,"" 2019-04-19 08:32:08.023 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,16,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_boxes"" ( ""id"" serial NOT NULL PRIMARY KEY, ""position"" integer NULL , ""url"" text NOT NULL , ""title"" text NOT NULL , ""ico"" character varying (255) NULL , ""desc"" text NOT NULL , ""page"" text NOT NULL , ""usergroup"" integer NOT NULL )",,,,,,,,,"" 2019-04-19 08:32:08.028 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,17,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 5.200 ms",,,,,,,,,"" 2019-04-19 08:32:08.032 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,18,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.403 ms statement: INSERT INTO ""lime_boxes"" (""position"", ""url"", ""title"", ""ico"", ""desc"", ""page"", ""usergroup"") VALUES ('1', 'admin/survey/sa/newsurvey', 'Create survey', 'icon-add', 'Create a new survey', 'welcome', '-2')",,,,,,,,,"" 2019-04-19 08:32:08.033 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,19,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.084 ms statement: INSERT INTO ""lime_boxes"" (""position"", ""url"", ""title"", ""ico"", ""desc"", ""page"", ""usergroup"") VALUES ('2', 'admin/survey/sa/listsurveys', 'List surveys', 'icon-list', 'List available surveys', 'welcome', '-1')",,,,,,,,,"" 2019-04-19 08:32:08.033 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,20,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.081 ms statement: INSERT INTO ""lime_boxes"" (""position"", ""url"", ""title"", ""ico"", ""desc"", ""page"", ""usergroup"") VALUES ('3', 'admin/globalsettings', 'Global settings', 'icon-settings', 'Edit global settings', 'welcome', '-2')",,,,,,,,,"" 2019-04-19 08:32:08.034 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,21,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.080 ms statement: INSERT INTO ""lime_boxes"" (""position"", ""url"", ""title"", ""ico"", ""desc"", ""page"", ""usergroup"") VALUES ('4', 'admin/update', 'ComfortUpdate', 'icon-shield', 'Stay safe and up to date', 'welcome', '-2')",,,,,,,,,"" 2019-04-19 08:32:08.035 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,22,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.079 ms statement: INSERT INTO ""lime_boxes"" (""position"", ""url"", ""title"", ""ico"", ""desc"", ""page"", ""usergroup"") VALUES ('5', 'https://www.limesurvey.org/limestore', 'LimeStore', 'fa fa-cart-plus', 'LimeSurvey extension marketplace', 'welcome', '-2')",,,,,,,,,"" 2019-04-19 08:32:08.035 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,23,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.078 ms statement: INSERT INTO ""lime_boxes"" (""position"", ""url"", ""title"", ""ico"", ""desc"", ""page"", ""usergroup"") VALUES ('6', 'admin/themeoptions', 'Themes', 'icon-templates', 'Themes', 'welcome', '-2')",,,,,,,,,"" 2019-04-19 08:32:08.036 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,24,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_conditions"" ( ""cid"" serial NOT NULL PRIMARY KEY, ""qid"" integer NOT NULL default '0', ""cqid"" integer NOT NULL default '0', ""cfieldname"" character varying (50) NOT NULL default '', ""method"" character varying (5) NOT NULL default '', ""value"" character varying (255) NOT NULL default '', ""scenario"" integer NOT NULL default 1 )",,,,,,,,,"" 2019-04-19 08:32:08.039 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,25,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 3.578 ms",,,,,,,,,"" 2019-04-19 08:32:08.040 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,26,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_conditions_idx"" ON ""lime_conditions"" (""qid"")",,,,,,,,,"" 2019-04-19 08:32:08.042 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,27,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.002 ms",,,,,,,,,"" 2019-04-19 08:32:08.042 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,28,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_conditions_idx3"" ON ""lime_conditions"" (""cqid"")",,,,,,,,,"" 2019-04-19 08:32:08.045 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,29,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.223 ms",,,,,,,,,"" 2019-04-19 08:32:08.045 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,30,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_defaultvalues"" ( ""qid"" integer NOT NULL default '0', ""scale_id"" integer NOT NULL default '0', ""sqid"" integer NOT NULL default '0', ""language"" character varying (20) NOT NULL, ""specialtype"" character varying (20) NOT NULL default '', ""defaultvalue"" text )",,,,,,,,,"" 2019-04-19 08:32:08.048 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,31,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.770 ms",,,,,,,,,"" 2019-04-19 08:32:08.049 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,32,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: ALTER TABLE ""lime_defaultvalues"" ADD CONSTRAINT ""lime_defaultvalues_pk"" PRIMARY KEY (""qid"", ""specialtype"", ""language"", ""scale_id"", ""sqid"" )",,,,,,,,,"" 2019-04-19 08:32:08.051 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,33,"ALTER TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.171 ms",,,,,,,,,"" 2019-04-19 08:32:08.051 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,34,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_expression_errors"" ( ""id"" serial NOT NULL PRIMARY KEY, ""errortime"" character varying (50) NULL, ""sid"" integer NULL, ""gid"" integer NULL, ""qid"" integer NULL, ""gseq"" integer NULL, ""qseq"" integer NULL, ""type"" character varying (50) , ""eqn"" text, ""prettyprint"" text )",,,,,,,,,"" 2019-04-19 08:32:08.057 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,35,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 5.328 ms",,,,,,,,,"" 2019-04-19 08:32:08.057 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,36,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_failed_login_attempts"" ( ""id"" serial NOT NULL PRIMARY KEY, ""ip"" character varying (40) NOT NULL, ""last_attempt"" character varying (20) NOT NULL, ""number_attempts"" integer NOT NULL )",,,,,,,,,"" 2019-04-19 08:32:08.061 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,37,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 3.671 ms",,,,,,,,,"" 2019-04-19 08:32:08.062 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,38,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_groups"" ( ""gid"" serial, ""sid"" integer NOT NULL default '0', ""group_name"" character varying (100) NOT NULL default '', ""group_order"" integer NOT NULL default '0', ""description"" text, ""language"" character varying (20) default 'en' NOT NULL, ""randomization_group"" character varying (20) NOT NULL default '', ""grelevance"" text NULL, CONSTRAINT lime_groups_composite_pkey PRIMARY KEY (gid, language) )",,,,,,,,,"" 2019-04-19 08:32:08.067 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,39,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 5.515 ms",,,,,,,,,"" 2019-04-19 08:32:08.068 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,40,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_groups"" ON ""lime_groups"" (""sid"")",,,,,,,,,"" 2019-04-19 08:32:08.069 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,41,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.851 ms",,,,,,,,,"" 2019-04-19 08:32:08.070 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,42,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx2_groups"" ON ""lime_groups"" (""group_name"")",,,,,,,,,"" 2019-04-19 08:32:08.072 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,43,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.079 ms",,,,,,,,,"" 2019-04-19 08:32:08.073 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,44,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx3_groups"" ON ""lime_groups"" (""language"")",,,,,,,,,"" 2019-04-19 08:32:08.075 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,45,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.231 ms",,,,,,,,,"" 2019-04-19 08:32:08.075 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,46,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_labels"" ( ""id"" serial NOT NULL PRIMARY KEY, ""lid"" integer NOT NULL DEFAULT 0, ""code"" character varying (5) NOT NULL default '', ""title"" text, ""sortorder"" integer NOT NULL, ""language"" character varying (20) NOT NULL DEFAULT 'en', ""assessment_value"" integer NOT NULL default '0' )",,,,,,,,,"" 2019-04-19 08:32:08.081 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,47,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 5.207 ms",,,,,,,,,"" 2019-04-19 08:32:08.081 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,48,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_labels"" ON ""lime_labels"" (""code"")",,,,,,,,,"" 2019-04-19 08:32:08.083 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,49,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.053 ms",,,,,,,,,"" 2019-04-19 08:32:08.084 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,50,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx2_labels"" ON ""lime_labels"" (""sortorder"")",,,,,,,,,"" 2019-04-19 08:32:08.085 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,51,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.834 ms",,,,,,,,,"" 2019-04-19 08:32:08.086 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,52,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx3_labels"" ON ""lime_labels"" (""language"")",,,,,,,,,"" 2019-04-19 08:32:08.088 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,53,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.941 ms",,,,,,,,,"" 2019-04-19 08:32:08.088 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,54,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx4_labels"" ON ""lime_labels"" (""lid"", ""sortorder"", ""language"")",,,,,,,,,"" 2019-04-19 08:32:08.091 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,55,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.099 ms",,,,,,,,,"" 2019-04-19 08:32:08.091 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,56,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_labelsets"" ( ""lid"" serial NOT NULL PRIMARY KEY, ""label_name"" character varying (100) NOT NULL DEFAULT '', ""languages"" character varying (200) DEFAULT 'en' )",,,,,,,,,"" 2019-04-19 08:32:08.094 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,57,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.795 ms",,,,,,,,,"" 2019-04-19 08:32:08.095 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,58,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_notifications"" ( ""id"" serial NOT NULL PRIMARY KEY, ""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) NOT NULL DEFAULT 'new' , ""importance"" integer NOT NULL DEFAULT 1, ""display_class"" character varying (31) DEFAULT 'default' , ""hash"" character varying (64) , ""created"" timestamp, ""first_read"" timestamp )",,,,,,,,,"" 2019-04-19 08:32:08.099 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,59,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 4.970 ms",,,,,,,,,"" 2019-04-19 08:32:08.100 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,60,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_notifications_pk"" ON ""lime_notifications"" (""entity"", ""entity_id"", ""status"")",,,,,,,,,"" 2019-04-19 08:32:08.102 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,61,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.705 ms",,,,,,,,,"" 2019-04-19 08:32:08.102 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,62,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_notifications"" ON ""lime_notifications"" (""hash"")",,,,,,,,,"" 2019-04-19 08:32:08.104 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,63,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.699 ms",,,,,,,,,"" 2019-04-19 08:32:08.105 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,64,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_participants"" ( ""participant_id"" character varying (50) NOT NULL, ""firstname"" character varying (150) NULL, ""lastname"" character varying (150) NULL, ""email"" text, ""language"" character varying (40) NULL, ""blacklisted"" character varying (1) NOT NULL, ""owner_uid"" integer NOT NULL, ""created_by"" integer NOT NULL, ""created"" timestamp, ""modified"" timestamp )",,,,,,,,,"" 2019-04-19 08:32:08.107 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,65,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.221 ms",,,,,,,,,"" 2019-04-19 08:32:08.107 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,66,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: ALTER TABLE ""lime_participants"" ADD CONSTRAINT ""lime_participant_pk"" PRIMARY KEY (""participant_id"" )",,,,,,,,,"" 2019-04-19 08:32:08.109 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,67,"ALTER TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.950 ms",,,,,,,,,"" 2019-04-19 08:32:08.110 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,68,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_participants"" ON ""lime_participants"" (""firstname"")",,,,,,,,,"" 2019-04-19 08:32:08.112 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,69,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.847 ms",,,,,,,,,"" 2019-04-19 08:32:08.112 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,70,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx2_participants"" ON ""lime_participants"" (""lastname"")",,,,,,,,,"" 2019-04-19 08:32:08.114 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,71,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.741 ms",,,,,,,,,"" 2019-04-19 08:32:08.114 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,72,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx3_participants"" ON ""lime_participants"" (""language"")",,,,,,,,,"" 2019-04-19 08:32:08.116 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,73,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.669 ms",,,,,,,,,"" 2019-04-19 08:32:08.117 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,74,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_participant_attribute"" ( ""participant_id"" character varying (50) NOT NULL, ""attribute_id"" integer NOT NULL, ""value"" text NOT NULL )",,,,,,,,,"" 2019-04-19 08:32:08.119 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,75,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.720 ms",,,,,,,,,"" 2019-04-19 08:32:08.120 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,76,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: ALTER TABLE ""lime_participant_attribute"" ADD CONSTRAINT ""lime_participant_attribute_pk"" PRIMARY KEY (""participant_id"", ""attribute_id"" )",,,,,,,,,"" 2019-04-19 08:32:08.122 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,77,"ALTER TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.239 ms",,,,,,,,,"" 2019-04-19 08:32:08.123 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,78,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_participant_attribute_names_lang"" ( ""attribute_id"" integer NOT NULL, ""attribute_name"" character varying (255) NOT NULL, ""lang"" character varying (20) NOT NULL )",,,,,,,,,"" 2019-04-19 08:32:08.123 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,79,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.379 ms",,,,,,,,,"" 2019-04-19 08:32:08.123 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,80,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: ALTER TABLE ""lime_participant_attribute_names_lang"" ADD CONSTRAINT ""lime_participant_attribute_names_lang_pk"" PRIMARY KEY (""attribute_id"", ""lang"" )",,,,,,,,,"" 2019-04-19 08:32:08.125 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,81,"ALTER TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.639 ms",,,,,,,,,"" 2019-04-19 08:32:08.126 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,82,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_participant_attribute_names"" ( ""attribute_id"" serial, ""attribute_type"" character varying (4) NOT NULL, ""defaultname"" character varying (255) NOT NULL, ""visible"" character varying (5) NOT NULL, CONSTRAINT lime_participant_attribute_names_composite_pkey PRIMARY KEY (attribute_id, attribute_type) )",,,,,,,,,"" 2019-04-19 08:32:08.129 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,83,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 3.057 ms",,,,,,,,,"" 2019-04-19 08:32:08.129 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,84,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx_participant_attribute_names"" ON ""lime_participant_attribute_names"" (""attribute_id"", ""attribute_type"")",,,,,,,,,"" 2019-04-19 08:32:08.131 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,85,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.017 ms",,,,,,,,,"" 2019-04-19 08:32:08.132 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,86,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_participant_attribute_values"" ( ""value_id"" serial NOT NULL PRIMARY KEY, ""attribute_id"" integer NOT NULL, ""value"" text NOT NULL )",,,,,,,,,"" 2019-04-19 08:32:08.137 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,87,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 5.264 ms",,,,,,,,,"" 2019-04-19 08:32:08.137 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,88,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_participant_shares"" ( ""participant_id"" character varying (50) NOT NULL, ""share_uid"" integer NOT NULL, ""date_added"" timestamp NOT NULL, ""can_edit"" character varying (5) NOT NULL )",,,,,,,,,"" 2019-04-19 08:32:08.138 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,89,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.390 ms",,,,,,,,,"" 2019-04-19 08:32:08.138 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,90,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: ALTER TABLE ""lime_participant_shares"" ADD CONSTRAINT ""lime_participant_shares_pk"" PRIMARY KEY (""participant_id"", ""share_uid"" )",,,,,,,,,"" 2019-04-19 08:32:08.141 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,91,"ALTER TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.346 ms",,,,,,,,,"" 2019-04-19 08:32:08.141 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,92,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_permissions"" ( ""id"" serial NOT NULL PRIMARY KEY, ""entity"" character varying (50) NOT NULL, ""entity_id"" integer NOT NULL, ""uid"" integer NOT NULL, ""permission"" character varying (100) NOT NULL, ""create_p"" integer NOT NULL default 0, ""read_p"" integer NOT NULL default 0, ""update_p"" integer NOT NULL default 0, ""delete_p"" integer NOT NULL default 0, ""import_p"" integer NOT NULL default 0, ""export_p"" integer NOT NULL default 0 )",,,,,,,,,"" 2019-04-19 08:32:08.145 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,93,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 3.473 ms",,,,,,,,,"" 2019-04-19 08:32:08.145 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,94,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE UNIQUE INDEX ""lime_idx1_permissions"" ON ""lime_permissions"" (""entity_id"", ""entity"", ""permission"", ""uid"")",,,,,,,,,"" 2019-04-19 08:32:08.147 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,95,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.035 ms",,,,,,,,,"" 2019-04-19 08:32:08.148 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,96,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_plugins"" ( ""id"" serial NOT NULL PRIMARY KEY, ""name"" character varying (50) NOT NULL, ""active"" int NOT NULL default 0, ""version"" character varying (32) NULL )",,,,,,,,,"" 2019-04-19 08:32:08.151 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,97,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 3.079 ms",,,,,,,,,"" 2019-04-19 08:32:08.151 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,98,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_plugin_settings"" ( ""id"" serial NOT NULL PRIMARY KEY, ""plugin_id"" integer NOT NULL, ""model"" character varying (50) NULL, ""model_id"" integer NULL, ""key"" character varying (50) NOT NULL, ""value"" text NULL )",,,,,,,,,"" 2019-04-19 08:32:08.156 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,99,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 4.953 ms",,,,,,,,,"" 2019-04-19 08:32:08.157 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,100,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_questions"" ( ""qid"" serial, ""parent_qid"" integer NOT NULL default '0', ""sid"" integer NOT NULL default '0', ""gid"" integer NOT NULL default '0', ""type"" character varying (1) NOT NULL default 'T', ""title"" character varying (20) NOT NULL default '', ""question"" text NOT NULL, ""preg"" text, ""help"" text, ""other"" character varying (1) NOT NULL default 'N', ""mandatory"" character varying (1) NULL, ""question_order"" integer NOT NULL, ""language"" character varying (20) default 'en' NOT NULL, ""scale_id"" integer NOT NULL default '0', ""same_default"" integer NOT NULL default '0', ""relevance"" text, ""modulename"" character varying (255) NULL, CONSTRAINT lime_questions_composite_pkey PRIMARY KEY (qid, language) )",,,,,,,,,"" 2019-04-19 08:32:08.163 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,101,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 5.677 ms",,,,,,,,,"" 2019-04-19 08:32:08.163 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,102,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_questions"" ON ""lime_questions"" (""sid"")",,,,,,,,,"" 2019-04-19 08:32:08.165 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,103,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.888 ms",,,,,,,,,"" 2019-04-19 08:32:08.166 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,104,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx2_questions"" ON ""lime_questions"" (""gid"")",,,,,,,,,"" 2019-04-19 08:32:08.168 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,105,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.868 ms",,,,,,,,,"" 2019-04-19 08:32:08.168 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,106,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx3_questions"" ON ""lime_questions"" (""type"")",,,,,,,,,"" 2019-04-19 08:32:08.170 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,107,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.811 ms",,,,,,,,,"" 2019-04-19 08:32:08.170 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,108,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx4_questions"" ON ""lime_questions"" (""title"")",,,,,,,,,"" 2019-04-19 08:32:08.172 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,109,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.746 ms",,,,,,,,,"" 2019-04-19 08:32:08.173 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,110,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx5_questions"" ON ""lime_questions"" (""parent_qid"")",,,,,,,,,"" 2019-04-19 08:32:08.175 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,111,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.186 ms",,,,,,,,,"" 2019-04-19 08:32:08.175 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,112,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_question_attributes"" ( ""qaid"" serial NOT NULL PRIMARY KEY, ""qid"" integer NOT NULL default '0', ""attribute"" character varying (50) NULL, ""value"" text NULL, ""language"" character varying (20) NULL )",,,,,,,,,"" 2019-04-19 08:32:08.180 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,113,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 4.890 ms",,,,,,,,,"" 2019-04-19 08:32:08.181 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,114,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_question_attributes"" ON ""lime_question_attributes"" (""qid"")",,,,,,,,,"" 2019-04-19 08:32:08.183 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,115,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.689 ms",,,,,,,,,"" 2019-04-19 08:32:08.183 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,116,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx2_question_attributes"" ON ""lime_question_attributes"" (""attribute"")",,,,,,,,,"" 2019-04-19 08:32:08.185 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,117,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.055 ms",,,,,,,,,"" 2019-04-19 08:32:08.186 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,118,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_quota"" ( ""id"" serial NOT NULL PRIMARY KEY, ""sid"" integer NULL, ""name"" character varying (255) NULL, ""qlimit"" integer NULL, ""action"" integer NULL, ""active"" integer NOT NULL default '1', ""autoload_url"" integer NOT NULL default '0' )",,,,,,,,,"" 2019-04-19 08:32:08.189 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,119,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 3.222 ms",,,,,,,,,"" 2019-04-19 08:32:08.190 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,120,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_quota"" ON ""lime_quota"" (""sid"")",,,,,,,,,"" 2019-04-19 08:32:08.192 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,121,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.790 ms",,,,,,,,,"" 2019-04-19 08:32:08.192 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,122,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_quota_languagesettings"" ( ""quotals_id"" serial NOT NULL PRIMARY KEY, ""quotals_quota_id"" integer NOT NULL default '0', ""quotals_language"" character varying (45) NOT NULL default 'en', ""quotals_name"" character varying (255) NULL, ""quotals_message"" text NOT NULL, ""quotals_url"" character varying (255) , ""quotals_urldescrip"" character varying (255) )",,,,,,,,,"" 2019-04-19 08:32:08.198 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,123,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 5.758 ms",,,,,,,,,"" 2019-04-19 08:32:08.199 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,124,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_quota_members"" ( ""id"" serial NOT NULL PRIMARY KEY, ""sid"" integer NULL, ""qid"" integer NULL, ""quota_id"" integer NULL, ""code"" character varying (11) NULL )",,,,,,,,,"" 2019-04-19 08:32:08.202 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,125,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 3.111 ms",,,,,,,,,"" 2019-04-19 08:32:08.202 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,126,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE UNIQUE INDEX ""lime_idx1_quota_members"" ON ""lime_quota_members"" (""sid"", ""qid"", ""quota_id"", ""code"")",,,,,,,,,"" 2019-04-19 08:32:08.204 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,127,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.019 ms",,,,,,,,,"" 2019-04-19 08:32:08.205 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,128,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_saved_control"" ( ""scid"" serial NOT NULL PRIMARY KEY, ""sid"" integer NOT NULL default '0', ""srid"" integer NOT NULL default '0', ""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) NOT NULL default '', ""saved_date"" timestamp NOT NULL, ""refurl"" text )",,,,,,,,,"" 2019-04-19 08:32:08.210 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,129,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 4.742 ms",,,,,,,,,"" 2019-04-19 08:32:08.210 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,130,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_saved_control"" ON ""lime_saved_control"" (""sid"")",,,,,,,,,"" 2019-04-19 08:32:08.213 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,131,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.326 ms",,,,,,,,,"" 2019-04-19 08:32:08.213 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,132,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx2_saved_control"" ON ""lime_saved_control"" (""srid"")",,,,,,,,,"" 2019-04-19 08:32:08.215 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,133,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.076 ms",,,,,,,,,"" 2019-04-19 08:32:08.216 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,134,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_sessions"" ( ""id"" character varying (32) NOT NULL, ""expire"" integer NULL, ""data"" bytea )",,,,,,,,,"" 2019-04-19 08:32:08.218 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,135,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.645 ms",,,,,,,,,"" 2019-04-19 08:32:08.219 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,136,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: ALTER TABLE ""lime_sessions"" ADD CONSTRAINT ""lime_sessions_pk"" PRIMARY KEY (""id"" )",,,,,,,,,"" 2019-04-19 08:32:08.221 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,137,"ALTER TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.005 ms",,,,,,,,,"" 2019-04-19 08:32:08.221 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,138,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_settings_global"" ( ""stg_name"" character varying (50) NOT NULL default '', ""stg_value"" text NOT NULL )",,,,,,,,,"" 2019-04-19 08:32:08.224 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,139,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.699 ms",,,,,,,,,"" 2019-04-19 08:32:08.225 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,140,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: ALTER TABLE ""lime_settings_global"" ADD CONSTRAINT ""lime_settings_global_pk"" PRIMARY KEY (""stg_name"" )",,,,,,,,,"" 2019-04-19 08:32:08.227 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,141,"ALTER TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.954 ms",,,,,,,,,"" 2019-04-19 08:32:08.227 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,142,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_settings_user"" ( ""id"" serial NOT NULL PRIMARY KEY, ""uid"" integer NOT NULL, ""entity"" character varying (15) NULL, ""entity_id"" character varying (31) NULL, ""stg_name"" character varying (63) NOT NULL, ""stg_value"" TEXT NULL )",,,,,,,,,"" 2019-04-19 08:32:08.232 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,143,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 4.683 ms",,,,,,,,,"" 2019-04-19 08:32:08.232 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,144,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_settings_user"" ON ""lime_settings_user"" (""uid"")",,,,,,,,,"" 2019-04-19 08:32:08.234 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,145,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.948 ms",,,,,,,,,"" 2019-04-19 08:32:08.235 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,146,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx2_settings_user"" ON ""lime_settings_user"" (""entity"")",,,,,,,,,"" 2019-04-19 08:32:08.236 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,147,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.590 ms",,,,,,,,,"" 2019-04-19 08:32:08.237 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,148,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx3_settings_user"" ON ""lime_settings_user"" (""entity_id"")",,,,,,,,,"" 2019-04-19 08:32:08.239 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,149,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.629 ms",,,,,,,,,"" 2019-04-19 08:32:08.239 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,150,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx4_settings_user"" ON ""lime_settings_user"" (""stg_name"")",,,,,,,,,"" 2019-04-19 08:32:08.241 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,151,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.673 ms",,,,,,,,,"" 2019-04-19 08:32:08.241 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,152,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_surveymenu"" ( ""id"" serial NOT NULL PRIMARY KEY, ""parent_id"" integer NULL, ""survey_id"" integer NULL, ""user_id"" integer NULL, ""name"" character varying (128) , ""ordering"" integer NULL DEFAULT '0', ""level"" integer NULL DEFAULT '0', ""title"" character varying (168) NOT NULL DEFAULT '', ""position"" character varying (192) NOT NULL DEFAULT 'side', ""description"" text , ""showincollapse"" integer DEFAULT 0, ""active"" integer NOT NULL DEFAULT '0', ""changed_at"" timestamp, ""changed_by"" integer NOT NULL DEFAULT '0', ""created_at"" timestamp, ""created_by"" integer NOT NULL DEFAULT '0' )",,,,,,,,,"" 2019-04-19 08:32:08.247 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,153,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 5.704 ms",,,,,,,,,"" 2019-04-19 08:32:08.248 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,154,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE UNIQUE INDEX ""lime_surveymenu_name"" ON ""lime_surveymenu"" (""name"")",,,,,,,,,"" 2019-04-19 08:32:08.250 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,155,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.835 ms",,,,,,,,,"" 2019-04-19 08:32:08.250 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,156,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx2_surveymenu"" ON ""lime_surveymenu"" (""title"")",,,,,,,,,"" 2019-04-19 08:32:08.252 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,157,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.755 ms",,,,,,,,,"" 2019-04-19 08:32:08.253 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,158,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.372 ms statement: INSERT INTO ""lime_surveymenu"" (""id"", ""parent_id"", ""survey_id"", ""user_id"", ""ordering"", ""level"", ""name"", ""title"", ""position"", ""description"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('1', NULL, NULL, NULL, '1', '0', 'settings', 'Survey settings', 'side', 'Survey settings', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.254 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,159,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.118 ms statement: INSERT INTO ""lime_surveymenu"" (""id"", ""parent_id"", ""survey_id"", ""user_id"", ""ordering"", ""level"", ""name"", ""title"", ""position"", ""description"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('2', NULL, NULL, NULL, '2', '0', 'mainmenu', 'Survey menu', 'side', 'Main survey menu', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.254 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,160,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.099 ms statement: INSERT INTO ""lime_surveymenu"" (""id"", ""parent_id"", ""survey_id"", ""user_id"", ""ordering"", ""level"", ""name"", ""title"", ""position"", ""description"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('3', NULL, NULL, NULL, '3', '0', 'quickmenu', 'Quick menu', 'collapsed', 'Quick menu', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '0')",,,,,,,,,"" 2019-04-19 08:32:08.255 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,161,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_surveymenu_entries"" ( ""id"" serial NOT NULL PRIMARY KEY, ""menu_id"" integer NULL, ""user_id"" integer NULL, ""ordering"" integer DEFAULT '0', ""name"" character varying (168) DEFAULT '', ""title"" character varying (168) NOT NULL DEFAULT '', ""menu_title"" character varying (168) NOT NULL DEFAULT '', ""menu_description"" text , ""menu_icon"" character varying (192) NOT NULL DEFAULT '', ""menu_icon_type"" character varying (192) NOT NULL DEFAULT '', ""menu_class"" character varying (192) NOT NULL DEFAULT '', ""menu_link"" character varying (192) NOT NULL DEFAULT '', ""action"" character varying (192) NOT NULL DEFAULT '', ""template"" character varying (192) NOT NULL DEFAULT '', ""partial"" character varying (192) NOT NULL DEFAULT '', ""classes"" character varying (192) NOT NULL DEFAULT '', ""permission"" character varying (192) NOT NULL DEFAULT '', ""permission_grade"" character varying (192) NULL, ""data"" text , ""getdatamethod"" character varying (192) NOT NULL DEFAULT '', ""language"" character varying (32) NOT NULL DEFAULT 'en-GB', ""showincollapse"" integer DEFAULT 0, ""active"" integer NOT NULL DEFAULT '0', ""changed_at"" timestamp NULL, ""changed_by"" integer NOT NULL DEFAULT '0', ""created_at"" timestamp NULL, ""created_by"" integer NOT NULL DEFAULT '0' )",,,,,,,,,"" 2019-04-19 08:32:08.262 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,162,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 6.535 ms",,,,,,,,,"" 2019-04-19 08:32:08.262 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,163,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_surveymenu_entries"" ON ""lime_surveymenu_entries"" (""menu_id"")",,,,,,,,,"" 2019-04-19 08:32:08.264 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,164,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.193 ms",,,,,,,,,"" 2019-04-19 08:32:08.265 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,165,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx5_surveymenu_entries"" ON ""lime_surveymenu_entries"" (""menu_title"")",,,,,,,,,"" 2019-04-19 08:32:08.267 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,166,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.351 ms",,,,,,,,,"" 2019-04-19 08:32:08.268 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,167,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE UNIQUE INDEX ""lime_surveymenu_entries_name"" ON ""lime_surveymenu_entries"" (""name"")",,,,,,,,,"" 2019-04-19 08:32:08.270 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,168,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.852 ms",,,,,,,,,"" 2019-04-19 08:32:08.272 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,169,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.444 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('1', NULL, '1', 'overview', 'Survey overview', 'Overview', 'Open the general survey overview', 'list', 'fontawesome', '', 'admin/survey/sa/view', '', '', '', '', '', '', '{""render"": { ""link"": {""data"": {""surveyid"": [""survey"",""sid""]}}}}', '', 'en-GB', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '0')",,,,,,,,,"" 2019-04-19 08:32:08.272 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,170,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.162 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('1', NULL, '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', NULL, '_generalTabEditSurvey', 'en-GB', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.273 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,171,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.152 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('1', NULL, '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', NULL, '_getTextEditData', 'en-GB', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.274 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,172,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.150 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('1', NULL, '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', NULL, '_getDataSecurityEditData', 'en-GB', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.275 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,173,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.161 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('1', NULL, '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', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '0')",,,,,,,,,"" 2019-04-19 08:32:08.275 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,174,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.148 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('1', NULL, '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', NULL, '_tabPresentationNavigation', 'en-GB', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '0')",,,,,,,,,"" 2019-04-19 08:32:08.276 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,175,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.148 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('1', NULL, '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', NULL, '_tabTokens', 'en-GB', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '0')",,,,,,,,,"" 2019-04-19 08:32:08.277 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,176,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.154 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('1', NULL, '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', NULL, '_tabNotificationDataManagement', 'en-GB', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '0')",,,,,,,,,"" 2019-04-19 08:32:08.278 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,177,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.149 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('1', NULL, '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', NULL, '_tabPublicationAccess', 'en-GB', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '0')",,,,,,,,,"" 2019-04-19 08:32:08.278 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,178,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.146 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('2', NULL, '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', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.279 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,179,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.149 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('2', NULL, '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', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.280 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,180,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.146 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('2', NULL, '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', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.281 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,181,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.146 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('2', NULL, '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', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.281 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,182,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.162 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('2', NULL, '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', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.282 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,183,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.145 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('2', NULL, '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', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.283 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,184,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.144 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('2', NULL, '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', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '0')",,,,,,,,,"" 2019-04-19 08:32:08.284 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,185,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.145 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('2', NULL, '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', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '0')",,,,,,,,,"" 2019-04-19 08:32:08.284 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,186,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.158 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('2', NULL, '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', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '0')",,,,,,,,,"" 2019-04-19 08:32:08.285 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,187,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.145 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('2', NULL, '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', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '0')",,,,,,,,,"" 2019-04-19 08:32:08.286 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,188,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.146 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('2', NULL, '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', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '0')",,,,,,,,,"" 2019-04-19 08:32:08.287 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,189,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.149 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('2', NULL, '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', NULL, '_tabResourceManagement', 'en-GB', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '0')",,,,,,,,,"" 2019-04-19 08:32:08.287 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,190,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.145 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('2', NULL, '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', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '0')",,,,,,,,,"" 2019-04-19 08:32:08.288 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,191,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.144 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('3', NULL, '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', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.289 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,192,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.268 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('3', NULL, '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', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.290 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,193,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.145 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('3', NULL, '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', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.290 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,194,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.145 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('3', NULL, '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', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.291 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,195,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.149 ms statement: INSERT INTO ""lime_surveymenu_entries"" (""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"", ""active"", ""changed_at"", ""changed_by"", ""created_at"", ""created_by"", ""showincollapse"") VALUES ('3', NULL, '5', 'cpdb', 'Central participant database', 'Central participant database', 'Central participant database', 'users', 'fontawesome', '', 'admin/participants/sa/displayParticipants', '', '', '', '', 'tokens', 'read', '{""render"": {""link"": {}}}', '', 'en-GB', '1', '2019-04-19 08:31:54', '0', '2019-04-19 08:31:54', '0', '1')",,,,,,,,,"" 2019-04-19 08:32:08.292 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,196,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_surveys"" ( ""sid"" integer NOT NULL, ""owner_id"" integer NOT NULL, ""gsid"" integer default '1', ""admin"" character varying (50) NULL, ""active"" character varying (1) NOT NULL default 'N', ""expires"" timestamp NULL, ""startdate"" timestamp NULL, ""adminemail"" character varying (254) NULL, ""anonymized"" character varying (1) NOT NULL default 'N', ""faxto"" character varying (20) NULL, ""format"" character varying (1) NULL, ""savetimings"" character varying (1) NOT NULL default 'N', ""template"" character varying (100) default 'default', ""language"" character varying (50) NULL, ""additional_languages"" character varying (255) NULL, ""datestamp"" character varying (1) NOT NULL default 'N', ""usecookie"" character varying (1) NOT NULL default 'N', ""allowregister"" character varying (1) NOT NULL default 'N', ""allowsave"" character varying (1) NOT NULL default 'Y', ""autonumber_start"" integer NOT NULL default '0', ""autoredirect"" character varying (1) NOT NULL default 'N', ""allowprev"" character varying (1) NOT NULL default 'N', ""printanswers"" character varying (1) NOT NULL default 'N', ""ipaddr"" character varying (1) NOT NULL default 'N', ""refurl"" character varying (1) NOT NULL default 'N', ""datecreated"" timestamp, ""showsurveypolicynotice"" int DEFAULT 0, ""publicstatistics"" character varying (1) NOT NULL default 'N', ""publicgraphs"" character varying (1) NOT NULL default 'N', ""listpublic"" character varying (1) NOT NULL default 'N', ""htmlemail"" character varying (1) NOT NULL default 'N', ""sendconfirmation"" character varying (1) NOT NULL default 'Y', ""tokenanswerspersistence"" character varying (1) NOT NULL default 'N', ""assessments"" character varying (1) NOT NULL default 'N', ""usecaptcha"" character varying (1) NOT NULL default 'N', ""usetokens"" character varying (1) NOT NULL default 'N', ""bounce_email"" character varying (254) NULL, ""attributedescriptions"" text, ""emailresponseto"" text NULL, ""emailnotificationto"" text NULL, ""tokenlength"" integer NOT NULL default '15', ""showxquestions"" character varying (1) default 'Y', ""showgroupinfo"" character varying (1) default 'B', ""shownoanswer"" character varying (1) default 'Y', ""showqnumcode"" character varying (1) default 'X', ""bouncetime"" integer, ""bounceprocessing"" character varying (1) default 'N', ""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', ""showprogress"" character varying (1) default 'Y', ""questionindex"" integer default '0' NOT NULL, ""navigationdelay"" integer NOT NULL default '0', ""nokeyboard"" character varying (1) default 'N', ""alloweditaftercompletion"" character varying (1) default 'N', ""googleanalyticsstyle"" character varying (1) NULL, ""googleanalyticsapikey"" character varying (25) NULL )",,,,,,,,,"" 2019-04-19 08:32:08.299 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,197,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 7.340 ms",,,,,,,,,"" 2019-04-19 08:32:08.300 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,198,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: ALTER TABLE ""lime_surveys"" ADD CONSTRAINT ""lime_surveys_pk"" PRIMARY KEY (""sid"" )",,,,,,,,,"" 2019-04-19 08:32:08.302 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,199,"ALTER TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.847 ms",,,,,,,,,"" 2019-04-19 08:32:08.302 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,200,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_surveys"" ON ""lime_surveys"" (""owner_id"")",,,,,,,,,"" 2019-04-19 08:32:08.304 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,201,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.739 ms",,,,,,,,,"" 2019-04-19 08:32:08.305 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,202,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx2_surveys"" ON ""lime_surveys"" (""gsid"")",,,,,,,,,"" 2019-04-19 08:32:08.306 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,203,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.947 ms",,,,,,,,,"" 2019-04-19 08:32:08.307 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,204,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_surveys_groups"" ( ""gsid"" serial NOT NULL PRIMARY KEY, ""name"" character varying (45) NOT NULL, ""title"" character varying (100) NULL, ""template"" character varying (128) DEFAULT 'default', ""description"" text , ""sortorder"" integer NOT NULL, ""owner_uid"" integer NULL, ""parent_id"" integer NULL, ""created"" timestamp NULL, ""modified"" timestamp NULL, ""created_by"" integer NOT NULL )",,,,,,,,,"" 2019-04-19 08:32:08.312 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,205,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 5.057 ms",,,,,,,,,"" 2019-04-19 08:32:08.313 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,206,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_surveys_groups"" ON ""lime_surveys_groups"" (""name"")",,,,,,,,,"" 2019-04-19 08:32:08.315 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,207,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.894 ms",,,,,,,,,"" 2019-04-19 08:32:08.315 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,208,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx2_surveys_groups"" ON ""lime_surveys_groups"" (""title"")",,,,,,,,,"" 2019-04-19 08:32:08.317 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,209,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.144 ms",,,,,,,,,"" 2019-04-19 08:32:08.318 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,210,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.324 ms statement: INSERT INTO ""lime_surveys_groups"" (""name"", ""title"", ""template"", ""description"", ""sortorder"", ""owner_uid"", ""parent_id"", ""created"", ""modified"", ""created_by"") VALUES ('default', 'Default', NULL, 'Default survey group', '0', '1', NULL, '2019-04-19 08:31:54', '2019-04-19 08:31:54', '1')",,,,,,,,,"" 2019-04-19 08:32:08.319 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,211,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_surveys_languagesettings"" ( ""surveyls_survey_id"" integer NOT NULL, ""surveyls_language"" character varying (45) NOT NULL DEFAULT 'en', ""surveyls_title"" character varying (200) NOT NULL, ""surveyls_description"" TEXT NULL, ""surveyls_welcometext"" TEXT NULL, ""surveyls_endtext"" TEXT NULL, ""surveyls_policy_notice"" TEXT NULL, ""surveyls_policy_error"" TEXT NULL, ""surveyls_policy_notice_label"" character varying (192) NULL, ""surveyls_url"" TEXT NULL, ""surveyls_urldescription"" character varying (255) NULL, ""surveyls_email_invite_subj"" character varying (255) NULL, ""surveyls_email_invite"" TEXT NULL, ""surveyls_email_remind_subj"" character varying (255) NULL, ""surveyls_email_remind"" TEXT NULL, ""surveyls_email_register_subj"" character varying (255) NULL, ""surveyls_email_register"" TEXT NULL, ""surveyls_email_confirm_subj"" character varying (255) NULL, ""surveyls_email_confirm"" TEXT NULL, ""surveyls_dateformat"" integer NOT NULL DEFAULT 1, ""surveyls_attributecaptions"" TEXT NULL, ""email_admin_notification_subj"" character varying (255) NULL, ""email_admin_notification"" TEXT NULL, ""email_admin_responses_subj"" character varying (255) NULL, ""email_admin_responses"" TEXT NULL, ""surveyls_numberformat"" INT NOT NULL DEFAULT 0, ""attachments"" text NULL )",,,,,,,,,"" 2019-04-19 08:32:08.323 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,212,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 3.550 ms",,,,,,,,,"" 2019-04-19 08:32:08.323 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,213,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: ALTER TABLE ""lime_surveys_languagesettings"" ADD CONSTRAINT ""lime_surveys_languagesettings_pk"" PRIMARY KEY (""surveyls_survey_id"", ""surveyls_language"" )",,,,,,,,,"" 2019-04-19 08:32:08.326 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,214,"ALTER TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.422 ms",,,,,,,,,"" 2019-04-19 08:32:08.326 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,215,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_surveys_languagesettings"" ON ""lime_surveys_languagesettings"" (""surveyls_title"")",,,,,,,,,"" 2019-04-19 08:32:08.328 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,216,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.746 ms",,,,,,,,,"" 2019-04-19 08:32:08.328 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,217,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_survey_links"" ( ""participant_id"" character varying (50) NOT NULL, ""token_id"" integer NOT NULL, ""survey_id"" integer NOT NULL, ""date_created"" timestamp, ""date_invited"" timestamp, ""date_completed"" timestamp )",,,,,,,,,"" 2019-04-19 08:32:08.329 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,218,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.560 ms",,,,,,,,,"" 2019-04-19 08:32:08.330 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,219,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: ALTER TABLE ""lime_survey_links"" ADD CONSTRAINT ""lime_survey_links_pk"" PRIMARY KEY (""participant_id"", ""token_id"", ""survey_id"" )",,,,,,,,,"" 2019-04-19 08:32:08.331 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,220,"ALTER TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.901 ms",,,,,,,,,"" 2019-04-19 08:32:08.332 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,221,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_survey_url_parameters"" ( ""id"" serial NOT NULL PRIMARY KEY, ""sid"" integer NOT NULL, ""parameter"" character varying (50) NOT NULL, ""targetqid"" integer NULL, ""targetsqid"" integer NULL )",,,,,,,,,"" 2019-04-19 08:32:08.335 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,222,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.794 ms",,,,,,,,,"" 2019-04-19 08:32:08.335 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,223,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_templates"" ( ""id"" serial NOT NULL PRIMARY KEY, ""name"" character varying (150) NOT NULL, ""folder"" character varying (45) NULL, ""title"" character varying (100) NOT NULL, ""creation_date"" timestamp NULL, ""author"" character varying (150) NULL, ""author_email"" character varying (255) NULL, ""author_url"" character varying (255) NULL, ""copyright"" text , ""license"" text , ""version"" character varying (45) NULL, ""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 NULL, ""owner_id"" integer NULL, ""extends"" character varying (150) NULL )",,,,,,,,,"" 2019-04-19 08:32:08.341 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,224,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 5.386 ms",,,,,,,,,"" 2019-04-19 08:32:08.341 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,225,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_templates"" ON ""lime_templates"" (""name"")",,,,,,,,,"" 2019-04-19 08:32:08.344 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,226,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.311 ms",,,,,,,,,"" 2019-04-19 08:32:08.344 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,227,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx2_templates"" ON ""lime_templates"" (""title"")",,,,,,,,,"" 2019-04-19 08:32:08.346 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,228,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.984 ms",,,,,,,,,"" 2019-04-19 08:32:08.347 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,229,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx3_templates"" ON ""lime_templates"" (""owner_id"")",,,,,,,,,"" 2019-04-19 08:32:08.349 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,230,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.695 ms",,,,,,,,,"" 2019-04-19 08:32:08.349 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,231,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx4_templates"" ON ""lime_templates"" (""extends"")",,,,,,,,,"" 2019-04-19 08:32:08.351 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,232,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.723 ms",,,,,,,,,"" 2019-04-19 08:32:08.352 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,233,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.454 ms statement: INSERT INTO ""lime_templates"" (""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"") VALUES ('vanilla', 'vanilla', 'Vanilla Theme', '2019-04-19 08:31:54', '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', 'LimeSurvey Bootstrap Vanilla Survey Theme
A clean and simple base that can be used by developers to create their own Bootstrap based theme.', NULL, '1', '')",,,,,,,,,"" 2019-04-19 08:32:08.353 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,234,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.155 ms statement: INSERT INTO ""lime_templates"" (""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"") VALUES ('fruity', 'fruity', 'Fruity Theme', '2019-04-19 08:31:54', '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', 'LimeSurvey Fruity Theme
A fruity theme for a flexible use. This theme offers monochromes variations and many options for easy customizations.', NULL, '1', 'vanilla')",,,,,,,,,"" 2019-04-19 08:32:08.353 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,235,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.133 ms statement: INSERT INTO ""lime_templates"" (""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"") VALUES ('bootswatch', 'bootswatch', 'Bootswatch Theme', '2019-04-19 08:31:54', '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', 'LimeSurvey Bootwatch Theme
Based on BootsWatch Themes: Visit BootsWatch page ', NULL, '1', 'vanilla')",,,,,,,,,"" 2019-04-19 08:32:08.354 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,236,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_template_configuration"" ( ""id"" serial NOT NULL PRIMARY KEY, ""template_name"" character varying (150) NOT NULL, ""sid"" integer NULL, ""gsid"" integer NULL, ""uid"" integer NULL, ""files_css"" text, ""files_js"" text, ""files_print_css"" text, ""options"" text , ""cssframework_name"" character varying (45) NULL, ""cssframework_css"" text, ""cssframework_js"" text, ""packages_to_load"" text, ""packages_ltr"" text, ""packages_rtl"" text )",,,,,,,,,"" 2019-04-19 08:32:08.359 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,237,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 5.431 ms",,,,,,,,,"" 2019-04-19 08:32:08.360 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,238,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_template_configuration"" ON ""lime_template_configuration"" (""template_name"")",,,,,,,,,"" 2019-04-19 08:32:08.362 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,239,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.782 ms",,,,,,,,,"" 2019-04-19 08:32:08.362 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,240,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx2_template_configuration"" ON ""lime_template_configuration"" (""sid"")",,,,,,,,,"" 2019-04-19 08:32:08.364 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,241,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.933 ms",,,,,,,,,"" 2019-04-19 08:32:08.365 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,242,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx3_template_configuration"" ON ""lime_template_configuration"" (""gsid"")",,,,,,,,,"" 2019-04-19 08:32:08.366 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,243,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.769 ms",,,,,,,,,"" 2019-04-19 08:32:08.367 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,244,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx4_template_configuration"" ON ""lime_template_configuration"" (""uid"")",,,,,,,,,"" 2019-04-19 08:32:08.369 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,245,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.036 ms",,,,,,,,,"" 2019-04-19 08:32:08.370 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,246,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.447 ms statement: INSERT INTO ""lime_template_configuration"" (""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"") VALUES ('vanilla', NULL, NULL, NULL, '{""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""]}', NULL, NULL)",,,,,,,,,"" 2019-04-19 08:32:08.371 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,247,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.132 ms statement: INSERT INTO ""lime_template_configuration"" (""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"") VALUES ('fruity', NULL, NULL, NULL, '{""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""]}', NULL, NULL)",,,,,,,,,"" 2019-04-19 08:32:08.371 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,248,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.113 ms statement: INSERT INTO ""lime_template_configuration"" (""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"") VALUES ('bootswatch', NULL, NULL, NULL, '{""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""]}', NULL, NULL)",,,,,,,,,"" 2019-04-19 08:32:08.372 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,249,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_tutorials"" ( ""tid"" serial NOT NULL PRIMARY KEY, ""name"" character varying (128) , ""title"" character varying (192) , ""icon"" character varying (64) , ""description"" text, ""active"" int DEFAULT 0, ""settings"" text, ""permission"" character varying (128) NOT NULL, ""permission_grade"" character varying (128) NOT NULL )",,,,,,,,,"" 2019-04-19 08:32:08.377 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,250,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 4.929 ms",,,,,,,,,"" 2019-04-19 08:32:08.378 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,251,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE UNIQUE INDEX ""lime_idx1_tutorials"" ON ""lime_tutorials"" (""name"")",,,,,,,,,"" 2019-04-19 08:32:08.379 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,252,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.847 ms",,,,,,,,,"" 2019-04-19 08:32:08.380 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,253,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_map_tutorial_users"" ( ""tid"" int NOT NULL, ""uid"" int NOT NULL, ""taken"" int DEFAULT 1 )",,,,,,,,,"" 2019-04-19 08:32:08.381 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,254,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.481 ms",,,,,,,,,"" 2019-04-19 08:32:08.381 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,255,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: ALTER TABLE ""lime_map_tutorial_users"" ADD CONSTRAINT ""lime_map_tutorial_users_pk"" PRIMARY KEY (""uid"", ""tid"" )",,,,,,,,,"" 2019-04-19 08:32:08.383 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,256,"ALTER TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.169 ms",,,,,,,,,"" 2019-04-19 08:32:08.384 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,257,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_tutorial_entry_relation"" ( ""teid"" int NOT NULL, ""tid"" int NOT NULL, ""uid"" int NULL, ""sid"" int NULL )",,,,,,,,,"" 2019-04-19 08:32:08.384 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,258,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.407 ms",,,,,,,,,"" 2019-04-19 08:32:08.385 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,259,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: ALTER TABLE ""lime_tutorial_entry_relation"" ADD CONSTRAINT ""lime_tutorial_entry_relation_pk"" PRIMARY KEY (""teid"", ""tid"" )",,,,,,,,,"" 2019-04-19 08:32:08.386 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,260,"ALTER TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.624 ms",,,,,,,,,"" 2019-04-19 08:32:08.387 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,261,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx1_tutorial_entry_relation"" ON ""lime_tutorial_entry_relation"" (""uid"")",,,,,,,,,"" 2019-04-19 08:32:08.389 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,262,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.937 ms",,,,,,,,,"" 2019-04-19 08:32:08.389 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,263,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx2_tutorial_entry_relation"" ON ""lime_tutorial_entry_relation"" (""sid"")",,,,,,,,,"" 2019-04-19 08:32:08.391 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,264,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.712 ms",,,,,,,,,"" 2019-04-19 08:32:08.391 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,265,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_tutorial_entries"" ( ""teid"" serial NOT NULL PRIMARY KEY, ""ordering"" int, ""title"" text, ""content"" text, ""settings"" text )",,,,,,,,,"" 2019-04-19 08:32:08.399 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,266,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 7.201 ms",,,,,,,,,"" 2019-04-19 08:32:08.399 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,267,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_user_in_groups"" ( ""ugid"" integer NOT NULL, ""uid"" integer NOT NULL )",,,,,,,,,"" 2019-04-19 08:32:08.400 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,268,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.492 ms",,,,,,,,,"" 2019-04-19 08:32:08.400 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,269,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: ALTER TABLE ""lime_user_in_groups"" ADD CONSTRAINT ""lime_user_in_groups_pk"" PRIMARY KEY (""ugid"", ""uid"" )",,,,,,,,,"" 2019-04-19 08:32:08.402 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,270,"ALTER TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.031 ms",,,,,,,,,"" 2019-04-19 08:32:08.403 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,271,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_users"" ( ""uid"" serial NOT NULL PRIMARY KEY, ""users_name"" character varying (64) NOT NULL default '', ""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', ""templateeditormode"" character varying (7) NOT NULL default 'default', ""questionselectormode"" character varying (7) NOT NULL default 'default', ""one_time_pw"" text, ""dateformat"" integer NOT NULL DEFAULT 1, ""created"" timestamp, ""modified"" timestamp )",,,,,,,,,"" 2019-04-19 08:32:08.408 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,272,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 4.917 ms",,,,,,,,,"" 2019-04-19 08:32:08.409 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,273,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE UNIQUE INDEX ""lime_idx1_users"" ON ""lime_users"" (""users_name"")",,,,,,,,,"" 2019-04-19 08:32:08.410 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,274,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.804 ms",,,,,,,,,"" 2019-04-19 08:32:08.411 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,275,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE INDEX ""lime_idx2_users"" ON ""lime_users"" (""email"")",,,,,,,,,"" 2019-04-19 08:32:08.413 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,276,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 1.820 ms",,,,,,,,,"" 2019-04-19 08:32:08.413 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,277,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_user_groups"" ( ""ugid"" serial NOT NULL PRIMARY KEY, ""name"" character varying (20) NOT NULL, ""description"" TEXT NOT NULL, ""owner_id"" integer NOT NULL )",,,,,,,,,"" 2019-04-19 08:32:08.418 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,278,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 4.673 ms",,,,,,,,,"" 2019-04-19 08:32:08.419 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,279,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE UNIQUE INDEX ""lime_idx1_user_groups"" ON ""lime_user_groups"" (""name"")",,,,,,,,,"" 2019-04-19 08:32:08.421 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,280,"CREATE INDEX",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 2.073 ms",,,,,,,,,"" 2019-04-19 08:32:08.421 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,281,"idle in transaction",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"statement: CREATE TABLE ""lime_asset_version"" ( ""id"" serial NOT NULL PRIMARY KEY, ""path"" text NOT NULL, ""version"" integer NOT NULL )",,,,,,,,,"" 2019-04-19 08:32:08.426 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,282,"CREATE TABLE",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 4.934 ms",,,,,,,,,"" 2019-04-19 08:32:08.427 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,283,"INSERT",2019-04-19 08:32:07 CEST,3/73,586,LOG,00000,"duration: 0.234 ms statement: INSERT INTO ""lime_settings_global"" (""stg_name"", ""stg_value"") VALUES ('DBVersion', '356')",,,,,,,,,"" 2019-04-19 08:32:08.429 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,284,"COMMIT",2019-04-19 08:32:07 CEST,3/0,0,LOG,00000,"duration: 1.999 ms statement: COMMIT",,,,,,,,,"" 2019-04-19 08:32:08.430 CEST,"limesurveyplayground_admin","limesurveyplayground",16403,"10.153.99.8:35746",5cb96b67.4013,285,"idle",2019-04-19 08:32:07 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.454 user=limesurveyplayground_admin database=limesurveyplayground host=10.153.99.8 port=35746",,,,,,,,,"" 2019-04-19 08:32:36.489 CEST,,,16466,"10.153.99.8:35748",5cb96b84.4052,1,"",2019-04-19 08:32:36 CEST,,0,LOG,00000,"connection received: host=10.153.99.8 port=35748",,,,,,,,,"" 2019-04-19 08:32:36.495 CEST,"limesurveyplayground_admin","limesurveyplayground",16466,"10.153.99.8:35748",5cb96b84.4052,2,"authentication",2019-04-19 08:32:36 CEST,3/91,0,LOG,00000,"connection authorized: user=limesurveyplayground_admin database=limesurveyplayground SSL enabled (protocol=TLSv1.2, cipher=ECDHE-RSA-AES256-GCM-SHA384, compression=off)",,,,,,,,,"" 2019-04-19 08:32:36.499 CEST,"limesurveyplayground_admin","limesurveyplayground",16466,"10.153.99.8:35748",5cb96b84.4052,3,"SET",2019-04-19 08:32:36 CEST,3/0,0,LOG,00000,"duration: 0.144 ms statement: SET NAMES 'utf8'",,,,,,,,,"" 2019-04-19 08:32:36.505 CEST,"limesurveyplayground_admin","limesurveyplayground",16466,"10.153.99.8:35748",5cb96b84.4052,4,"SELECT",2019-04-19 08:32:36 CEST,3/0,0,LOG,00000,"duration: 2.983 ms statement: SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_users' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum",,,,,,,,,"" 2019-04-19 08:32:36.506 CEST,"limesurveyplayground_admin","limesurveyplayground",16466,"10.153.99.8:35748",5cb96b84.4052,5,"idle",2019-04-19 08:32:36 CEST,,0,LOG,00000,"disconnection: session time: 0:00:00.017 user=limesurveyplayground_admin database=limesurveyplayground host=10.153.99.8 port=35748",,,,,,,,,""