2023-05-05 12:10:11.702 CEST [4481] [inconnu] galileo limesurvey5 4481 2023-05-05 12:10:11 CESTLOG: durée : 4.319 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_settings_global'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:10:11.709 CEST [4481] [inconnu] galileo limesurvey5 4481 2023-05-05 12:10:11 CESTLOG: durée : 3.200 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_settings_global'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:10:12.003 CEST [4481] [inconnu] galileo limesurvey5 4481 2023-05-05 12:10:12 CESTLOG: durée : 3.803 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_surveys'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:10:12.144 CEST [4481] [inconnu] galileo limesurvey5 4481 2023-05-05 12:10:12 CESTLOG: durée : 48.416 ms, instruction : UPDATE "lime_notifications" SET "id"=1, "entity"='user', "entity_id"=1, "title"='SSL n’est pas forcé', "message"=' Attention : veuillez activer le chiffrement SSL dans les paramètres généraux/sécurité après avoir correctement configuré le SSL sur votre serveur.', "status"='new', "importance"=1, "display_class"='default', "hash"='2a58cdd3f0024cceb4eab22785afef2d2d8e5bf193dbc96e42cef44d397005df', "created"='2022-10-13 00:28:40.653549', "first_read"='2022-10-12 22:28:50' WHERE "lime_notifications"."id"=1
2023-05-05 12:10:17.604 CEST [4488] [inconnu] galileo limesurvey5 4488 2023-05-05 12:10:17 CESTLOG: durée : 2.861 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_surveys_groups'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:10:17.607 CEST [4488] [inconnu] galileo limesurvey5 4488 2023-05-05 12:10:17 CESTLOG: durée : 2.799 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_surveys_groups'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:10:17.675 CEST [4488] [inconnu] galileo limesurvey5 4488 2023-05-05 12:10:17 CESTLOG: durée : 2.728 ms, instruction : SELECT "template"."id" AS "t1_c0", "template"."name" AS "t1_c1", "template"."folder" AS "t1_c2", "template"."title" AS "t1_c3", "template"."creation_date" AS "t1_c4", "template"."author" AS "t1_c5", "template"."author_email" AS "t1_c6", "template"."author_url" AS "t1_c7", "template"."copyright" AS "t1_c8", "template"."license" AS "t1_c9", "template"."version" AS "t1_c10", "template"."api_version" AS "t1_c11", "template"."view_folder" AS "t1_c12", "template"."files_folder" AS "t1_c13", "template"."description" AS "t1_c14", "template"."last_update" AS "t1_c15", "template"."owner_id" AS "t1_c16", "template"."extends" AS "t1_c17" FROM "lime_templates" "template" WHERE ("template"."name"='bootswatch')
2023-05-05 12:10:17.720 CEST [4488] [inconnu] galileo limesurvey5 4488 2023-05-05 12:10:17 CESTLOG: durée : 9.112 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_surveys_languagesettings'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:10:17.730 CEST [4488] [inconnu] galileo limesurvey5 4488 2023-05-05 12:10:17 CESTLOG: durée : 2.405 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_surveys_languagesettings'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:10:17.747 CEST [4488] [inconnu] galileo limesurvey5 4488 2023-05-05 12:10:17 CESTLOG: durée : 2.014 ms, instruction : SELECT "t"."sid" AS "t0_c0", "t"."owner_id" AS "t0_c1", "t"."gsid" AS "t0_c2", "t"."admin" AS "t0_c3", "t"."active" AS "t0_c4", "t"."expires" AS "t0_c5", "t"."startdate" AS "t0_c6", "t"."adminemail" AS "t0_c7", "t"."anonymized" AS "t0_c8", "t"."faxto" AS "t0_c9", "t"."format" AS "t0_c10", "t"."savetimings" AS "t0_c11", "t"."template" AS "t0_c12", "t"."language" AS "t0_c13", "t"."additional_languages" AS "t0_c14", "t"."datestamp" AS "t0_c15", "t"."usecookie" AS "t0_c16", "t"."allowregister" AS "t0_c17", "t"."allowsave" AS "t0_c18", "t"."autonumber_start" AS "t0_c19", "t"."autoredirect" AS "t0_c20", "t"."allowprev" AS "t0_c21", "t"."printanswers" AS "t0_c22", "t"."ipaddr" AS "t0_c23", "t"."ipanonymize" AS "t0_c24", "t"."refurl" AS "t0_c25", "t"."datecreated" AS "t0_c26", "t"."showsurveypolicynotice" AS "t0_c27", "t"."publicstatistics" AS "t0_c28", "t"."publicgraphs" AS "t0_c29", "t"."listpublic" AS "t0_c30", "t"."htmlemail" AS "t0_c31", "t"."sendconfirmation" AS "t0_c32", "t"."tokenanswerspersistence" AS "t0_c33", "t"."assessments" AS "t0_c34", "t"."usecaptcha" AS "t0_c35", "t"."usetokens" AS "t0_c36", "t"."bounce_email" AS "t0_c37", "t"."attributedescriptions" AS "t0_c38", "t"."emailresponseto" AS "t0_c39", "t"."emailnotificationto" AS "t0_c40", "t"."tokenlength" AS "t0_c41", "t"."showxquestions" AS "t0_c42", "t"."showgroupinfo" AS "t0_c43", "t"."shownoanswer" AS "t0_c44", "t"."showqnumcode" AS "t0_c45", "t"."bouncetime" AS "t0_c46", "t"."bounceprocessing" AS "t0_c47", "t"."bounceaccounttype" AS "t0_c48", "t"."bounceaccounthost" AS "t0_c49", "t"."bounceaccountpass" AS "t0_c50", "t"."bounceaccountencryption" AS "t0_c51", "t"."bounceaccountuser" AS "t0_c52", "t"."showwelcome" AS "t0_c53", "t"."showprogress" AS "t0_c54", "t"."questionindex" AS "t0_c55", "t"."navigationdelay" AS "t0_c56", "t"."nokeyboard" AS "t0_c57", "t"."alloweditaftercompletion" AS "t0_c58", "t"."googleanalyticsstyle" AS "t0_c59", "t"."googleanalyticsapikey" AS "t0_c60", "t"."tokenencryptionoptions" AS "t0_c61", "correct_relation_defaultlanguage"."surveyls_survey_id" AS "t1_c0", "correct_relation_defaultlanguage"."surveyls_language" AS "t1_c1", "correct_relation_defaultlanguage"."surveyls_title" AS "t1_c2", "correct_relation_defaultlanguage"."surveyls_description" AS "t1_c3", "correct_relation_defaultlanguage"."surveyls_welcometext" AS "t1_c4", "correct_relation_defaultlanguage"."surveyls_endtext" AS "t1_c5", "correct_relation_defaultlanguage"."surveyls_policy_notice" AS "t1_c6", "correct_relation_defaultlanguage"."surveyls_policy_error" AS "t1_c7", "correct_relation_defaultlanguage"."surveyls_policy_notice_label" AS "t1_c8", "correct_relation_defaultlanguage"."surveyls_url" AS "t1_c9", "correct_relation_defaultlanguage"."surveyls_urldescription" AS "t1_c10", "correct_relation_defaultlanguage"."surveyls_email_invite_subj" AS "t1_c11", "correct_relation_defaultlanguage"."surveyls_email_invite" AS "t1_c12", "correct_relation_defaultlanguage"."surveyls_email_remind_subj" AS "t1_c13", "correct_relation_defaultlanguage"."surveyls_email_remind" AS "t1_c14", "correct_relation_defaultlanguage"."surveyls_email_register_subj" AS "t1_c15", "correct_relation_defaultlanguage"."surveyls_email_register" AS "t1_c16", "correct_relation_defaultlanguage"."surveyls_email_confirm_subj" AS "t1_c17", "correct_relation_defaultlanguage"."surveyls_email_confirm" AS "t1_c18", "correct_relation_defaultlanguage"."surveyls_dateformat" AS "t1_c19", "correct_relation_defaultlanguage"."surveyls_attributecaptions" AS "t1_c20", "correct_relation_defaultlanguage"."email_admin_notification_subj" AS "t1_c21", "correct_relation_defaultlanguage"."email_admin_notification" AS "t1_c22", "correct_relation_defaultlanguage"."email_admin_responses_subj" AS "t1_c23", "correct_relation_defaultlanguage"."email_admin_responses" AS "t1_c24", "correct_relation_defaultlanguage"."surveyls_numberformat" AS "t1_c25", "correct_relation_defaultlanguage"."attachments" AS "t1_c26", "owner"."uid" AS "t2_c0", "owner"."users_name" AS "t2_c1", "owner"."password" AS "t2_c2", "owner"."full_name" AS "t2_c3", "owner"."parent_id" AS "t2_c4", "owner"."lang" AS "t2_c5", "owner"."email" AS "t2_c6", "owner"."htmleditormode" AS "t2_c7", "owner"."templateeditormode" AS "t2_c8", "owner"."questionselectormode" AS "t2_c9", "owner"."one_time_pw" AS "t2_c10", "owner"."dateformat" AS "t2_c11", "owner"."last_login" AS "t2_c12", "owner"."created" AS "t2_c13", "owner"."modified" AS "t2_c14", "owner"."validation_key" AS "t2_c15", "owner"."validation_key_expiration" AS "t2_c16", "owner"."last_forgot_email_password" AS "t2_c17", "surveygroup"."gsid" AS "t3_c0", "surveygroup"."name" AS "t3_c1", "surveygroup"."title" AS "t3_c2", "surveygroup"."template" AS "t3_c3", "surveygroup"."description" AS "t3_c4", "surveygroup"."sortorder" AS "t3_c5", "surveygroup"."owner_id" AS "t3_c6", "surveygroup"."parent_id" AS "t3_c7", "surveygroup"."alwaysavailable" AS "t3_c8", "surveygroup"."created" AS "t3_c9", "surveygroup"."modified" AS "t3_c10", "surveygroup"."created_by" AS "t3_c11" FROM "lime_surveys" "t" LEFT OUTER JOIN "lime_surveys_languagesettings" "correct_relation_defaultlanguage" ON ("correct_relation_defaultlanguage"."surveyls_language"="t"."language") AND ("correct_relation_defaultlanguage"."surveyls_survey_id"="t"."sid") LEFT OUTER JOIN "lime_users" "owner" ON ("t"."owner_id"="owner"."uid") LEFT OUTER JOIN "lime_surveys_groups" "surveygroup" ON ("t"."gsid"="surveygroup"."gsid") ORDER BY t.datecreated desc LIMIT 10
2023-05-05 12:14:34.278 CEST [4759] [inconnu] galileo LimeSurveyInternet 4759 2023-05-05 12:14:34 CESTFATAL: la base de données « LimeSurveyInternet » n'existe pas
2023-05-05 12:14:41.880 CEST [4775] [inconnu] galileo LimeSurveyInternet 4775 2023-05-05 12:14:41 CESTFATAL: la base de données « LimeSurveyInternet » n'existe pas
2023-05-05 12:14:43.026 CEST [4776] [inconnu] galileo galileo 4776 2023-05-05 12:14:43 CESTLOG: durée : 1135.900 ms, instruction : CREATE DATABASE "LimeSurveyInternet" ENCODING 'UTF8'
2023-05-05 12:14:47.770 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 82.464 ms, instruction : CREATE TABLE "lime_answers" (
"aid" serial NOT NULL PRIMARY KEY,
"qid" integer NOT NULL,
"code" character varying (5) NOT NULL,
"sortorder" integer NOT NULL,
"assessment_value" integer NOT NULL DEFAULT 0,
"scale_id" integer NOT NULL DEFAULT 0
)
2023-05-05 12:14:47.785 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 6.941 ms, instruction : CREATE UNIQUE INDEX "lime_answers_idx" ON "lime_answers" ("qid", "code", "scale_id")
2023-05-05 12:14:47.793 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 3.991 ms, instruction : CREATE INDEX "lime_answers_idx2" ON "lime_answers" ("sortorder")
2023-05-05 12:14:47.806 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 7.423 ms, instruction : CREATE TABLE "lime_answer_l10ns" (
"id" serial NOT NULL PRIMARY KEY,
"aid" integer NOT NULL,
"answer" text NOT NULL,
"language" character varying (20) NOT NULL
)
2023-05-05 12:14:47.814 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 4.573 ms, instruction : CREATE UNIQUE INDEX "lime_answer_l10ns_idx" ON "lime_answer_l10ns" ("aid", "language")
2023-05-05 12:14:47.827 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 11.580 ms, instruction : 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)
)
2023-05-05 12:14:47.843 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 4.130 ms, instruction : CREATE INDEX "lime_assessments_idx2" ON "lime_assessments" ("sid")
2023-05-05 12:14:47.858 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 4.017 ms, instruction : CREATE INDEX "lime_assessments_idx3" ON "lime_assessments" ("gid")
2023-05-05 12:14:47.873 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 9.044 ms, instruction : CREATE TABLE "lime_boxes" (
"id" serial NOT NULL PRIMARY KEY,
"position" integer NULL ,
"url" text NOT NULL ,
"title" text NOT NULL ,
"buttontext" character varying (255) NULL ,
"ico" character varying (255) NULL ,
"desc" text NOT NULL ,
"page" text NOT NULL ,
"usergroup" integer NOT NULL
)
2023-05-05 12:14:47.943 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 5.053 ms, instruction : 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
)
2023-05-05 12:14:47.948 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 3.200 ms, instruction : CREATE INDEX "lime_conditions_idx" ON "lime_conditions" ("qid")
2023-05-05 12:14:47.954 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 3.957 ms, instruction : CREATE INDEX "lime_conditions_idx3" ON "lime_conditions" ("cqid")
2023-05-05 12:14:47.960 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 4.994 ms, instruction : CREATE TABLE "lime_defaultvalues" (
"dvid" serial NOT NULL PRIMARY KEY,
"qid" integer NOT NULL default '0',
"scale_id" integer NOT NULL default '0',
"sqid" integer NOT NULL default '0',
"specialtype" character varying (20) NOT NULL default ''
)
2023-05-05 12:14:47.963 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 2.964 ms, instruction : CREATE INDEX "lime_idx1_defaultvalue" ON "lime_defaultvalues" ("qid", "scale_id", "sqid", "specialtype")
2023-05-05 12:14:47.972 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 7.771 ms, instruction : CREATE TABLE "lime_defaultvalue_l10ns" (
"id" serial NOT NULL PRIMARY KEY,
"dvid" integer NOT NULL default '0',
"language" character varying (20) NOT NULL,
"defaultvalue" text
)
2023-05-05 12:14:47.975 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 3.249 ms, instruction : CREATE INDEX "lime_idx1_defaultvalue_ls" ON "lime_defaultvalue_l10ns" ("dvid", "language")
2023-05-05 12:14:47.985 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 8.881 ms, instruction : 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
)
2023-05-05 12:14:47.991 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:47 CESTLOG: durée : 5.440 ms, instruction : 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,
"is_frontend" boolean NOT NULL
)
2023-05-05 12:14:48.042 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 49.461 ms, instruction : CREATE TABLE "lime_groups" (
"gid" serial NOT NULL PRIMARY KEY,
"sid" integer NOT NULL default '0',
"group_order" integer NOT NULL default '0',
"randomization_group" character varying (20) NOT NULL default '',
"grelevance" text NULL
)
2023-05-05 12:14:48.047 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.996 ms, instruction : CREATE INDEX "lime_idx1_groups" ON "lime_groups" ("sid")
2023-05-05 12:14:48.057 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 9.676 ms, instruction : CREATE TABLE "lime_group_l10ns" (
"id" serial NOT NULL PRIMARY KEY,
"gid" integer NOT NULL,
"group_name" text NOT NULL,
"description" text,
"language" character varying (20) NOT NULL
)
2023-05-05 12:14:48.061 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.041 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_group_ls" ON "lime_group_l10ns" ("gid", "language")
2023-05-05 12:14:48.066 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.926 ms, instruction : CREATE TABLE "lime_labels" (
"id" serial NOT NULL PRIMARY KEY,
"lid" integer NOT NULL DEFAULT 0,
"code" character varying (20) NOT NULL default '',
"sortorder" integer NOT NULL,
"assessment_value" integer NOT NULL default '0'
)
2023-05-05 12:14:48.072 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.866 ms, instruction : CREATE INDEX "lime_idx1_labels" ON "lime_labels" ("code")
2023-05-05 12:14:48.075 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.611 ms, instruction : CREATE INDEX "lime_idx2_labels" ON "lime_labels" ("sortorder")
2023-05-05 12:14:48.078 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.497 ms, instruction : CREATE INDEX "lime_idx4_labels" ON "lime_labels" ("lid", "sortorder")
2023-05-05 12:14:48.084 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 5.849 ms, instruction : CREATE UNIQUE INDEX "lime_idx5_labels" ON "lime_labels" ("lid", "code")
2023-05-05 12:14:48.093 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 8.296 ms, instruction : CREATE TABLE "lime_label_l10ns" (
"id" serial NOT NULL PRIMARY KEY,
"label_id" integer NOT NULL,
"title" text,
"language" character varying (20) NOT NULL DEFAULT 'en'
)
2023-05-05 12:14:48.100 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 5.897 ms, instruction : CREATE TABLE "lime_labelsets" (
"lid" serial NOT NULL PRIMARY KEY,
"label_name" character varying (100) NOT NULL DEFAULT '',
"languages" character varying (255) NOT NULL
)
2023-05-05 12:14:48.108 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 7.836 ms, instruction : 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
)
2023-05-05 12:14:48.112 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.659 ms, instruction : CREATE INDEX "lime_notifications_pk" ON "lime_notifications" ("entity", "entity_id", "status")
2023-05-05 12:14:48.115 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.086 ms, instruction : CREATE INDEX "lime_idx1_notifications" ON "lime_notifications" ("hash")
2023-05-05 12:14:48.121 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.413 ms, instruction : CREATE TABLE "lime_participants" (
"participant_id" character varying (50) NOT NULL,
"firstname" text NULL,
"lastname" text 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
)
2023-05-05 12:14:48.125 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.240 ms, instruction : ALTER TABLE "lime_participants" ADD CONSTRAINT "lime_participant_pk" PRIMARY KEY ("participant_id" )
2023-05-05 12:14:48.128 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.636 ms, instruction : CREATE INDEX "lime_idx3_participants" ON "lime_participants" ("language")
2023-05-05 12:14:48.134 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 6.199 ms, instruction : CREATE TABLE "lime_participant_attribute" (
"participant_id" character varying (50) NOT NULL,
"attribute_id" integer NOT NULL,
"value" text NOT NULL
)
2023-05-05 12:14:48.138 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.991 ms, instruction : ALTER TABLE "lime_participant_attribute" ADD CONSTRAINT "lime_participant_attribute_pk" PRIMARY KEY ("participant_id", "attribute_id" )
2023-05-05 12:14:48.142 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.487 ms, instruction : ALTER TABLE "lime_participant_attribute_names_lang" ADD CONSTRAINT "lime_participant_attribute_names_lang_pk" PRIMARY KEY ("attribute_id", "lang" )
2023-05-05 12:14:48.147 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.138 ms, instruction : 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,
"encrypted" character varying (5) NOT NULL,
"core_attribute" character varying (5) NOT NULL,
CONSTRAINT lime_participant_attribute_names_composite_pkey PRIMARY KEY (attribute_id, attribute_type)
)
2023-05-05 12:14:48.153 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 5.369 ms, instruction : CREATE INDEX "lime_idx_participant_attribute_names" ON "lime_participant_attribute_names" ("attribute_id", "attribute_type")
2023-05-05 12:14:48.167 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 8.971 ms, instruction : CREATE TABLE "lime_participant_attribute_values" (
"value_id" serial NOT NULL PRIMARY KEY,
"attribute_id" integer NOT NULL,
"value" text NOT NULL
)
2023-05-05 12:14:48.174 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.649 ms, instruction : ALTER TABLE "lime_participant_shares" ADD CONSTRAINT "lime_participant_shares_pk" PRIMARY KEY ("participant_id", "share_uid" )
2023-05-05 12:14:48.179 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.560 ms, instruction : 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
)
2023-05-05 12:14:48.185 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 5.508 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_permissions" ON "lime_permissions" ("entity_id", "entity", "permission", "uid")
2023-05-05 12:14:48.195 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 8.018 ms, instruction : CREATE TABLE "lime_permissiontemplates" (
"ptid" serial NOT NULL PRIMARY KEY,
"name" character varying (127) NOT NULL,
"description" text NULL,
"renewed_last" timestamp NULL,
"created_at" timestamp NOT NULL,
"created_by" int NOT NULL
)
2023-05-05 12:14:48.201 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 5.509 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_name" ON "lime_permissiontemplates" ("name")
2023-05-05 12:14:48.209 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 7.428 ms, instruction : CREATE TABLE "lime_plugins" (
"id" serial NOT NULL PRIMARY KEY,
"name" character varying (50) NOT NULL,
"plugin_type" character varying (6) default 'user',
"active" integer NOT NULL default 0,
"priority" integer NOT NULL default 0,
"version" character varying (32) NULL,
"load_error" integer default 0,
"load_error_message" text
)
2023-05-05 12:14:48.218 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 7.988 ms, instruction : 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
)
2023-05-05 12:14:48.226 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 8.243 ms, instruction : CREATE TABLE "lime_questions" (
"qid" serial NOT NULL PRIMARY KEY,
"parent_qid" integer NOT NULL default '0',
"sid" integer NOT NULL default '0',
"gid" integer NOT NULL default '0',
"type" character varying (30) NOT NULL default 'T',
"title" character varying (20) NOT NULL default '',
"preg" text,
"other" character varying (1) NOT NULL default 'N',
"mandatory" character varying (1) NULL,
"encrypted" character varying (1) NULL default 'N',
"question_order" integer NOT NULL,
"scale_id" integer NOT NULL default '0',
"same_default" integer NOT NULL default '0',
"relevance" text,
"question_theme_name" character varying (150) NULL,
"modulename" character varying (255) NULL,
"same_script" integer NOT NULL default '0'
)
2023-05-05 12:14:48.230 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.650 ms, instruction : CREATE INDEX "lime_idx1_questions" ON "lime_questions" ("sid")
2023-05-05 12:14:48.233 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.097 ms, instruction : CREATE INDEX "lime_idx2_questions" ON "lime_questions" ("gid")
2023-05-05 12:14:48.237 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.347 ms, instruction : CREATE INDEX "lime_idx3_questions" ON "lime_questions" ("type")
2023-05-05 12:14:48.241 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.934 ms, instruction : CREATE INDEX "lime_idx4_questions" ON "lime_questions" ("title")
2023-05-05 12:14:48.245 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.135 ms, instruction : CREATE INDEX "lime_idx5_questions" ON "lime_questions" ("parent_qid")
2023-05-05 12:14:48.265 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 17.462 ms, instruction : CREATE TABLE "lime_question_l10ns" (
"id" serial NOT NULL PRIMARY KEY,
"qid" integer NOT NULL,
"question" text NOT NULL,
"help" text,
"script" text NULL default NULL,
"language" character varying (20) NOT NULL
)
2023-05-05 12:14:48.272 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.554 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_question_ls" ON "lime_question_l10ns" ("qid", "language")
2023-05-05 12:14:48.282 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 9.224 ms, instruction : 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
)
2023-05-05 12:14:48.286 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.544 ms, instruction : CREATE INDEX "lime_idx1_question_attributes" ON "lime_question_attributes" ("qid")
2023-05-05 12:14:48.292 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 5.474 ms, instruction : CREATE INDEX "lime_idx2_question_attributes" ON "lime_question_attributes" ("attribute")
2023-05-05 12:14:48.297 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.812 ms, instruction : 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'
)
2023-05-05 12:14:48.301 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.674 ms, instruction : CREATE INDEX "lime_idx1_quota" ON "lime_quota" ("sid")
2023-05-05 12:14:48.309 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 7.550 ms, instruction : 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)
)
2023-05-05 12:14:48.314 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.023 ms, instruction : 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
)
2023-05-05 12:14:48.318 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.910 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_quota_members" ON "lime_quota_members" ("sid", "qid", "quota_id", "code")
2023-05-05 12:14:48.327 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 7.611 ms, instruction : 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
)
2023-05-05 12:14:48.330 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.414 ms, instruction : CREATE INDEX "lime_idx1_saved_control" ON "lime_saved_control" ("sid")
2023-05-05 12:14:48.333 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.233 ms, instruction : CREATE INDEX "lime_idx2_saved_control" ON "lime_saved_control" ("srid")
2023-05-05 12:14:48.337 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.577 ms, instruction : CREATE TABLE "lime_sessions" (
"id" character varying (32) NOT NULL,
"expire" integer NULL,
"data" bytea
)
2023-05-05 12:14:48.341 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.570 ms, instruction : ALTER TABLE "lime_sessions" ADD CONSTRAINT "lime_sessions_pk" PRIMARY KEY ("id" )
2023-05-05 12:14:48.344 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.418 ms, instruction : CREATE INDEX "sess_expire" ON "lime_sessions" ("expire")
2023-05-05 12:14:48.348 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.363 ms, instruction : CREATE TABLE "lime_settings_global" (
"stg_name" character varying (50) NOT NULL default '',
"stg_value" text NOT NULL
)
2023-05-05 12:14:48.351 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.798 ms, instruction : ALTER TABLE "lime_settings_global" ADD CONSTRAINT "lime_settings_global_pk" PRIMARY KEY ("stg_name" )
2023-05-05 12:14:48.360 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 6.613 ms, instruction : 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
)
2023-05-05 12:14:48.364 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.198 ms, instruction : CREATE INDEX "lime_idx1_settings_user" ON "lime_settings_user" ("uid")
2023-05-05 12:14:48.368 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.185 ms, instruction : CREATE INDEX "lime_idx2_settings_user" ON "lime_settings_user" ("entity")
2023-05-05 12:14:48.372 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.677 ms, instruction : CREATE INDEX "lime_idx3_settings_user" ON "lime_settings_user" ("entity_id")
2023-05-05 12:14:48.375 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.870 ms, instruction : CREATE INDEX "lime_idx4_settings_user" ON "lime_settings_user" ("stg_name")
2023-05-05 12:14:48.386 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 9.792 ms, instruction : 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'
)
2023-05-05 12:14:48.389 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.727 ms, instruction : CREATE UNIQUE INDEX "lime_surveymenu_name" ON "lime_surveymenu" ("name")
2023-05-05 12:14:48.392 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.480 ms, instruction : CREATE INDEX "lime_idx2_surveymenu" ON "lime_surveymenu" ("title")
2023-05-05 12:14:48.406 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 11.082 ms, instruction : 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'
)
2023-05-05 12:14:48.409 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.781 ms, instruction : CREATE INDEX "lime_idx1_surveymenu_entries" ON "lime_surveymenu_entries" ("menu_id")
2023-05-05 12:14:48.414 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.152 ms, instruction : CREATE INDEX "lime_idx5_surveymenu_entries" ON "lime_surveymenu_entries" ("menu_title")
2023-05-05 12:14:48.422 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 6.780 ms, instruction : CREATE UNIQUE INDEX "lime_surveymenu_entries_name" ON "lime_surveymenu_entries" ("name")
2023-05-05 12:14:48.442 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.520 ms, instruction : 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, '10', 'surveypermissions', 'Edit survey permissions', 'Survey permissions', 'Edit permissions for this survey', 'ri-lock-password-line', 'remix', '', 'surveyPermissions/index', '', '', '', '', 'surveysecurity', 'read', '{"render": { "link": {"data": {"surveyid": ["survey","sid"]}}}}', '', 'en-GB', '1', '2023-05-05 10:14:48', '0', '2023-05-05 10:14:48', '0', '0')
2023-05-05 12:14:48.461 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.042 ms, instruction : 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', 'ri-play-fill', 'remix', '', 'surveyAdministration/activate', '', '', '', '', 'surveyactivation', 'update', '{"render": {"isActive": false, "link": {"data": {"iSurveyID": ["survey","sid"]}}}}', '', 'en-GB', '1', '2023-05-05 10:14:48', '0', '2023-05-05 10:14:48', '0', '1')
2023-05-05 12:14:48.478 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 7.920 ms, instruction : 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',
"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" text 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',
"ipanonymize" character varying (1) NOT NULL default 'N',
"refurl" character varying (1) NOT NULL default 'N',
"datecreated" timestamp,
"showsurveypolicynotice" integer 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 'Y',
"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" text NULL,
"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,
"tokenencryptionoptions" text NULL
)
2023-05-05 12:14:48.482 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.020 ms, instruction : ALTER TABLE "lime_surveys" ADD CONSTRAINT "lime_surveys_pk" PRIMARY KEY ("sid" )
2023-05-05 12:14:48.487 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.304 ms, instruction : CREATE INDEX "lime_idx1_surveys" ON "lime_surveys" ("owner_id")
2023-05-05 12:14:48.491 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.752 ms, instruction : CREATE INDEX "lime_idx2_surveys" ON "lime_surveys" ("gsid")
2023-05-05 12:14:48.505 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 13.587 ms, instruction : 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_id" integer NULL,
"parent_id" integer NULL,
"alwaysavailable" boolean NULL,
"created" timestamp NULL,
"modified" timestamp NULL,
"created_by" integer NOT NULL
)
2023-05-05 12:14:48.508 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.838 ms, instruction : CREATE INDEX "lime_idx1_surveys_groups" ON "lime_surveys_groups" ("name")
2023-05-05 12:14:48.512 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.974 ms, instruction : CREATE INDEX "lime_idx2_surveys_groups" ON "lime_surveys_groups" ("title")
2023-05-05 12:14:48.522 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 8.484 ms, instruction : CREATE TABLE "lime_surveys_groupsettings" (
"gsid" integer NOT NULL,
"owner_id" integer NULL DEFAULT NULL,
"admin" character varying (50) NULL DEFAULT NULL,
"adminemail" character varying (254) NULL DEFAULT NULL,
"anonymized" character varying (1) NOT NULL DEFAULT 'N',
"format" character varying (1) NULL DEFAULT NULL,
"savetimings" character varying (1) NOT NULL DEFAULT 'N',
"template" character varying (100) NULL DEFAULT 'default',
"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 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',
"ipanonymize" character varying (1) NOT NULL DEFAULT 'N',
"refurl" character varying (1) NOT NULL DEFAULT 'N',
"showsurveypolicynotice" integer NULL 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 'Y',
"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',
"bounce_email" character varying (254) NULL DEFAULT NULL,
"attributedescriptions" text NULL,
"emailresponseto" text NULL,
"emailnotificationto" text NULL,
"tokenlength" integer NULL DEFAULT '15',
"showxquestions" character varying (1) NULL DEFAULT 'Y',
"showgroupinfo" character varying (1) NULL DEFAULT 'B',
"shownoanswer" character varying (1) NULL DEFAULT 'Y',
"showqnumcode" character varying (1) NULL DEFAULT 'X',
"showwelcome" character varying (1) NULL DEFAULT 'Y',
"showprogress" character varying (1) NULL DEFAULT 'Y',
"questionindex" integer NULL DEFAULT '0',
"navigationdelay" integer NULL DEFAULT '0',
"nokeyboard" character varying (1) NULL DEFAULT 'N',
"alloweditaftercompletion" character varying (1) NULL DEFAULT 'N'
)
2023-05-05 12:14:48.527 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.586 ms, instruction : ALTER TABLE "lime_surveys_groupsettings" ADD CONSTRAINT "lime_surveys_groupsettings_pk" PRIMARY KEY ("gsid" )
2023-05-05 12:14:48.542 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 7.433 ms, instruction : 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,
"surveyls_alias" character varying (100) 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" integer NOT NULL DEFAULT 0,
"attachments" text NULL
)
2023-05-05 12:14:48.546 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.804 ms, instruction : ALTER TABLE "lime_surveys_languagesettings" ADD CONSTRAINT "lime_surveys_languagesettings_pk" PRIMARY KEY ("surveyls_survey_id", "surveyls_language" )
2023-05-05 12:14:48.551 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.857 ms, instruction : CREATE INDEX "lime_idx1_surveys_languagesettings" ON "lime_surveys_languagesettings" ("surveyls_title")
2023-05-05 12:14:48.558 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.054 ms, instruction : ALTER TABLE "lime_survey_links" ADD CONSTRAINT "lime_survey_links_pk" PRIMARY KEY ("participant_id", "token_id", "survey_id" )
2023-05-05 12:14:48.563 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.898 ms, instruction : 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
)
2023-05-05 12:14:48.573 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 8.932 ms, instruction : 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
)
2023-05-05 12:14:48.576 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.551 ms, instruction : CREATE INDEX "lime_idx1_templates" ON "lime_templates" ("name")
2023-05-05 12:14:48.579 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.486 ms, instruction : CREATE INDEX "lime_idx2_templates" ON "lime_templates" ("title")
2023-05-05 12:14:48.584 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.218 ms, instruction : CREATE INDEX "lime_idx3_templates" ON "lime_templates" ("owner_id")
2023-05-05 12:14:48.587 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.058 ms, instruction : CREATE INDEX "lime_idx4_templates" ON "lime_templates" ("extends")
2023-05-05 12:14:48.599 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 9.067 ms, instruction : 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
)
2023-05-05 12:14:48.603 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.927 ms, instruction : CREATE INDEX "lime_idx1_template_configuration" ON "lime_template_configuration" ("template_name")
2023-05-05 12:14:48.609 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.742 ms, instruction : CREATE INDEX "lime_idx2_template_configuration" ON "lime_template_configuration" ("sid")
2023-05-05 12:14:48.615 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 5.103 ms, instruction : CREATE INDEX "lime_idx3_template_configuration" ON "lime_template_configuration" ("gsid")
2023-05-05 12:14:48.625 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 6.248 ms, instruction : CREATE INDEX "lime_idx4_template_configuration" ON "lime_template_configuration" ("uid")
2023-05-05 12:14:48.643 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 12.692 ms, instruction : CREATE TABLE "lime_question_themes" (
"id" serial NOT NULL PRIMARY KEY,
"name" character varying (150) NOT NULL,
"visible" character varying (1) NULL,
"xml_path" character varying (255) NULL,
"image_path" character varying (255) 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,
"description" text,
"last_update" timestamp NULL,
"owner_id" integer NULL,
"theme_type" character varying (150) ,
"question_type" character varying (150) NOT NULL,
"core_theme" boolean,
"extends" character varying (150) NULL,
"group" character varying (150) ,
"settings" text
)
2023-05-05 12:14:48.647 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.037 ms, instruction : CREATE INDEX "lime_idx1_question_themes" ON "lime_question_themes" ("name")
2023-05-05 12:14:48.682 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 8.085 ms, instruction : 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" integer DEFAULT 0,
"settings" text,
"permission" character varying (128) NOT NULL,
"permission_grade" character varying (128) NOT NULL
)
2023-05-05 12:14:48.686 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.952 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_tutorials" ON "lime_tutorials" ("name")
2023-05-05 12:14:48.692 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.620 ms, instruction : ALTER TABLE "lime_map_tutorial_users" ADD CONSTRAINT "lime_map_tutorial_users_pk" PRIMARY KEY ("uid", "tid" )
2023-05-05 12:14:48.696 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.716 ms, instruction : ALTER TABLE "lime_tutorial_entry_relation" ADD CONSTRAINT "lime_tutorial_entry_relation_pk" PRIMARY KEY ("teid", "tid" )
2023-05-05 12:14:48.700 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.901 ms, instruction : CREATE INDEX "lime_idx1_tutorial_entry_relation" ON "lime_tutorial_entry_relation" ("uid")
2023-05-05 12:14:48.707 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 6.189 ms, instruction : CREATE INDEX "lime_idx2_tutorial_entry_relation" ON "lime_tutorial_entry_relation" ("sid")
2023-05-05 12:14:48.724 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 14.995 ms, instruction : CREATE TABLE "lime_tutorial_entries" (
"teid" serial NOT NULL PRIMARY KEY,
"ordering" integer,
"title" text,
"content" text,
"settings" text
)
2023-05-05 12:14:48.727 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.414 ms, instruction : CREATE TABLE "lime_user_in_groups" (
"ugid" integer NOT NULL,
"uid" integer NOT NULL
)
2023-05-05 12:14:48.735 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 7.415 ms, instruction : ALTER TABLE "lime_user_in_groups" ADD CONSTRAINT "lime_user_in_groups_pk" PRIMARY KEY ("ugid", "uid" )
2023-05-05 12:14:48.742 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.619 ms, instruction : ALTER TABLE "lime_user_in_permissionrole" ADD CONSTRAINT "lime_user_in_permissionrole_pk" PRIMARY KEY ("ptid", "uid" )
2023-05-05 12:14:48.753 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 10.290 ms, instruction : 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,
"last_login" timestamp NULL,
"created" timestamp,
"modified" timestamp,
"validation_key" character varying (38) ,
"validation_key_expiration" timestamp,
"last_forgot_email_password" timestamp,
"expires" timestamp
)
2023-05-05 12:14:48.757 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 3.036 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_users" ON "lime_users" ("users_name")
2023-05-05 12:14:48.760 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.683 ms, instruction : CREATE INDEX "lime_idx2_users" ON "lime_users" ("email")
2023-05-05 12:14:48.770 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 8.393 ms, instruction : 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
)
2023-05-05 12:14:48.773 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 2.821 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_user_groups" ON "lime_user_groups" ("name")
2023-05-05 12:14:48.781 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 7.278 ms, instruction : CREATE TABLE "lime_asset_version" (
"id" serial NOT NULL PRIMARY KEY,
"path" text NOT NULL,
"version" integer NOT NULL
)
2023-05-05 12:14:48.792 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 10.234 ms, instruction : CREATE TABLE "lime_archived_table_settings" (
"id" serial NOT NULL PRIMARY KEY,
"survey_id" int NOT NULL,
"user_id" int NOT NULL,
"tbl_name" character varying (255) NOT NULL,
"tbl_type" character varying (10) NOT NULL,
"created" timestamp NOT NULL,
"properties" text NOT NULL,
"attributes" text NULL
)
2023-05-05 12:14:48.800 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 7.937 ms, instruction : CREATE TABLE "lime_source_message" (
"id" serial NOT NULL PRIMARY KEY,
"category" character varying (35) ,
"message" text
)
2023-05-05 12:14:48.805 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.426 ms, instruction : CREATE TABLE "lime_message" (
"id" integer NOT NULL,
"language" character varying (50) NOT NULL default '',
"translation" text
)
2023-05-05 12:14:48.810 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.088 ms, instruction : ALTER TABLE "lime_message" ADD CONSTRAINT "lime_message_pk" PRIMARY KEY ("id", "language" )
2023-05-05 12:14:48.828 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 7.012 ms, instruction : CREATE TABLE "lime_failed_emails" (
"id" serial NOT NULL PRIMARY KEY,
"surveyid" integer NOT NULL,
"responseid" integer NOT NULL,
"email_type" character varying (200) NOT NULL,
"recipient" character varying (320) NOT NULL,
"language" character varying (20) NOT NULL DEFAULT 'en',
"error_message" text,
"created" timestamp NOT NULL,
"status" character varying (20) NULL DEFAULT 'SEND FAILED',
"updated" timestamp NULL,
"resend_vars" text NOT NULL
)
2023-05-05 12:14:48.833 CEST [4785] [inconnu] galileo LimeSurveyInternet 4785 2023-05-05 12:14:48 CESTLOG: durée : 4.514 ms, instruction : COMMIT
2023-05-05 12:15:17.495 CEST [4815] [inconnu] galileo LimeSurveyInternet 4815 2023-05-05 12:15:17 CESTLOG: durée : 5.150 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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
2023-05-05 12:15:17.501 CEST [4815] [inconnu] galileo LimeSurveyInternet 4815 2023-05-05 12:15:17 CESTLOG: durée : 3.504 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_users'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:15:17.935 CEST [4815] [inconnu] galileo LimeSurveyInternet 4815 2023-05-05 12:15:17 CESTLOG: durée : 3.391 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_settings_global'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:15:17.944 CEST [4815] [inconnu] galileo LimeSurveyInternet 4815 2023-05-05 12:15:17 CESTLOG: durée : 2.008 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_plugins'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:15:17.967 CEST [4815] [inconnu] galileo LimeSurveyInternet 4815 2023-05-05 12:15:17 CESTLOG: durée : 9.860 ms, instruction : INSERT INTO "lime_users" ("users_name", "htmleditormode", "templateeditormode", "questionselectormode", "dateformat", "password", "full_name", "parent_id", "email", "created", "lang") VALUES ('admin', 'default', 'default', 'default', 1, '$2y$10$u1sHFOZbIM53r7SBAxczluTbeEhbJwk3zBDf47gtHXWFhaWrwxQES', 'Admin V6', 0, 'your-email@example.net', NOW(), 'fr')
2023-05-05 12:15:17.983 CEST [4815] [inconnu] galileo LimeSurveyInternet 4815 2023-05-05 12:15:17 CESTLOG: durée : 3.527 ms, instruction : INSERT INTO "lime_permissions" ("create_p", "read_p", "update_p", "delete_p", "import_p", "export_p", "entity_id", "entity", "uid", "permission") VALUES (0, 1, 0, 0, 0, 0, 0, 'global', 1, 'superadmin')
2023-05-05 12:15:17.990 CEST [4814] [inconnu] galileo LimeSurveyInternet 4814 2023-05-05 12:15:17 CESTLOG: durée : 4.672 ms, instruction : INSERT INTO "lime_settings_global" ("stg_name", "stg_value") VALUES ('SessionName', 'CFFVWCZMQNRGEQLAJJXEMQKDPJWMHTVVUAKFSPBQWDQZAIFPEPJMPRWHDMRNTXGP')
2023-05-05 12:15:17.996 CEST [4814] [inconnu] galileo LimeSurveyInternet 4814 2023-05-05 12:15:17 CESTLOG: durée : 4.457 ms, instruction : INSERT INTO "lime_settings_global" ("stg_name", "stg_value") VALUES ('sitename', 'LimeSurvey V6')
2023-05-05 12:15:18.000 CEST [4814] [inconnu] galileo LimeSurveyInternet 4814 2023-05-05 12:15:17 CESTLOG: durée : 3.859 ms, instruction : INSERT INTO "lime_settings_global" ("stg_name", "stg_value") VALUES ('siteadminname', 'Admin V6')
2023-05-05 12:15:18.007 CEST [4814] [inconnu] galileo LimeSurveyInternet 4814 2023-05-05 12:15:18 CESTLOG: durée : 5.685 ms, instruction : INSERT INTO "lime_settings_global" ("stg_name", "stg_value") VALUES ('siteadminemail', 'your-email@example.net')
2023-05-05 12:15:18.011 CEST [4814] [inconnu] galileo LimeSurveyInternet 4814 2023-05-05 12:15:18 CESTLOG: durée : 3.808 ms, instruction : INSERT INTO "lime_settings_global" ("stg_name", "stg_value") VALUES ('siteadminbounce', 'your-email@example.net')
2023-05-05 12:15:18.015 CEST [4814] [inconnu] galileo LimeSurveyInternet 4814 2023-05-05 12:15:18 CESTLOG: durée : 3.520 ms, instruction : INSERT INTO "lime_settings_global" ("stg_name", "stg_value") VALUES ('defaultlang', 'fr')
2023-05-05 12:15:18.021 CEST [4814] [inconnu] galileo LimeSurveyInternet 4814 2023-05-05 12:15:18 CESTLOG: durée : 5.085 ms, instruction : UPDATE "lime_surveys_groupsettings" SET "admin"='Admin V6' WHERE gsid=0
2023-05-05 12:15:18.030 CEST [4814] [inconnu] galileo LimeSurveyInternet 4814 2023-05-05 12:15:18 CESTLOG: durée : 8.125 ms, instruction : UPDATE "lime_surveys_groupsettings" SET "adminemail"='your-email@example.net' WHERE gsid=0
2023-05-05 12:15:22.673 CEST [4822] [inconnu] galileo LimeSurveyInternet 4822 2023-05-05 12:15:22 CESTLOG: durée : 3.929 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_settings_global'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:15:22.677 CEST [4822] [inconnu] galileo LimeSurveyInternet 4822 2023-05-05 12:15:22 CESTLOG: durée : 3.412 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_settings_global'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:15:22.761 CEST [4822] [inconnu] galileo LimeSurveyInternet 4822 2023-05-05 12:15:22 CESTLOG: durée : 2.065 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_asset_version'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:15:22.832 CEST [4822] [inconnu] galileo LimeSurveyInternet 4822 2023-05-05 12:15:22 CESTLOG: durée : 3.734 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_surveys'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:15:22.836 CEST [4822] [inconnu] galileo LimeSurveyInternet 4822 2023-05-05 12:15:22 CESTLOG: durée : 2.159 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_surveys'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:15:22.879 CEST [4823] [inconnu] galileo LimeSurveyInternet 4823 2023-05-05 12:15:22 CESTLOG: durée : 2.960 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_plugins'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:15:22.887 CEST [4823] [inconnu] galileo LimeSurveyInternet 4823 2023-05-05 12:15:22 CESTLOG: durée : 7.199 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_plugins'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:15:31.158 CEST [4832] [inconnu] galileo LimeSurveyInternet 4832 2023-05-05 12:15:31 CESTLOG: durée : 3.063 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_failed_login_attempts'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:15:31.162 CEST [4832] [inconnu] galileo LimeSurveyInternet 4832 2023-05-05 12:15:31 CESTLOG: durée : 3.087 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_failed_login_attempts'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:15:31.302 CEST [4832] [inconnu] galileo LimeSurveyInternet 4832 2023-05-05 12:15:31 CESTLOG: durée : 2.375 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_users'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:15:31.457 CEST [4832] [inconnu] galileo LimeSurveyInternet 4832 2023-05-05 12:15:31 CESTLOG: durée : 2.124 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_permissions'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:15:31.488 CEST [4832] [inconnu] galileo LimeSurveyInternet 4832 2023-05-05 12:15:31 CESTLOG: durée : 5.710 ms, instruction : UPDATE "lime_plugins" SET "version"='1.1.0' WHERE id='2'
2023-05-05 12:15:31.502 CEST [4832] [inconnu] galileo LimeSurveyInternet 4832 2023-05-05 12:15:31 CESTLOG: durée : 4.469 ms, instruction : UPDATE "lime_plugins" SET "version"='1.0.4' WHERE id='10'
2023-05-05 12:15:31.515 CEST [4832] [inconnu] galileo LimeSurveyInternet 4832 2023-05-05 12:15:31 CESTLOG: durée : 6.238 ms, instruction : UPDATE "lime_plugins" SET "version"='1.0.1' WHERE id='11'
2023-05-05 12:15:31.523 CEST [4832] [inconnu] galileo LimeSurveyInternet 4832 2023-05-05 12:15:31 CESTLOG: durée : 3.724 ms, instruction : UPDATE "lime_plugins" SET "version"='1.0.1' WHERE id='12'
2023-05-05 12:15:31.529 CEST [4832] [inconnu] galileo LimeSurveyInternet 4832 2023-05-05 12:15:31 CESTLOG: durée : 4.489 ms, instruction : UPDATE "lime_plugins" SET "version"='1.0.1' WHERE id='13'
2023-05-05 12:15:31.536 CEST [4832] [inconnu] galileo LimeSurveyInternet 4832 2023-05-05 12:15:31 CESTLOG: durée : 4.049 ms, instruction : UPDATE "lime_plugins" SET "version"='1.0.2' WHERE id='14'
2023-05-05 12:15:31.550 CEST [4832] [inconnu] galileo LimeSurveyInternet 4832 2023-05-05 12:15:31 CESTLOG: durée : 5.003 ms, instruction : UPDATE "lime_users" SET "uid"=1, "users_name"='admin', "password"='$2y$10$u1sHFOZbIM53r7SBAxczluTbeEhbJwk3zBDf47gtHXWFhaWrwxQES', "full_name"='Admin V6', "parent_id"=0, "email"='your-email@example.net', "htmleditormode"='default', "templateeditormode"='default', "questionselectormode"='default', "one_time_pw"=NULL, "dateformat"=1, "last_login"='2023-05-05 10:15:31', "created"='2023-05-05 12:15:17.958026', "modified"=NOW(), "validation_key"=NULL, "validation_key_expiration"=NULL, "last_forgot_email_password"=NULL, "expires"=NULL, "lang"='fr' WHERE "lime_users"."uid"=1
2023-05-05 12:15:31.596 CEST [4832] [inconnu] galileo LimeSurveyInternet 4832 2023-05-05 12:15:31 CESTLOG: durée : 2.105 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_failed_emails'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:15:31.648 CEST [4832] [inconnu] galileo LimeSurveyInternet 4832 2023-05-05 12:15:31 CESTLOG: durée : 8.475 ms, instruction : SELECT "t"."id" AS "t0_c0", "t"."surveyid" AS "t0_c1", "t"."responseid" AS "t0_c2", "t"."email_type" AS "t0_c3", "t"."recipient" AS "t0_c4", "t"."language" AS "t0_c5", "t"."error_message" AS "t0_c6", "t"."created" AS "t0_c7", "t"."status" AS "t0_c8", "t"."updated" AS "t0_c9", "t"."resend_vars" AS "t0_c10", "survey"."sid" AS "t1_c0", "survey"."owner_id" AS "t1_c1", "survey"."gsid" AS "t1_c2", "survey"."admin" AS "t1_c3", "survey"."active" AS "t1_c4", "survey"."expires" AS "t1_c5", "survey"."startdate" AS "t1_c6", "survey"."adminemail" AS "t1_c7", "survey"."anonymized" AS "t1_c8", "survey"."format" AS "t1_c9", "survey"."savetimings" AS "t1_c10", "survey"."template" AS "t1_c11", "survey"."language" AS "t1_c12", "survey"."additional_languages" AS "t1_c13", "survey"."datestamp" AS "t1_c14", "survey"."usecookie" AS "t1_c15", "survey"."allowregister" AS "t1_c16", "survey"."allowsave" AS "t1_c17", "survey"."autonumber_start" AS "t1_c18", "survey"."autoredirect" AS "t1_c19", "survey"."allowprev" AS "t1_c20", "survey"."printanswers" AS "t1_c21", "survey"."ipaddr" AS "t1_c22", "survey"."ipanonymize" AS "t1_c23", "survey"."refurl" AS "t1_c24", "survey"."datecreated" AS "t1_c25", "survey"."showsurveypolicynotice" AS "t1_c26", "survey"."publicstatistics" AS "t1_c27", "survey"."publicgraphs" AS "t1_c28", "survey"."listpublic" AS "t1_c29", "survey"."htmlemail" AS "t1_c30", "survey"."sendconfirmation" AS "t1_c31", "survey"."tokenanswerspersistence" AS "t1_c32", "survey"."assessments" AS "t1_c33", "survey"."usecaptcha" AS "t1_c34", "survey"."usetokens" AS "t1_c35", "survey"."bounce_email" AS "t1_c36", "survey"."attributedescriptions" AS "t1_c37", "survey"."emailresponseto" AS "t1_c38", "survey"."emailnotificationto" AS "t1_c39", "survey"."tokenlength" AS "t1_c40", "survey"."showxquestions" AS "t1_c41", "survey"."showgroupinfo" AS "t1_c42", "survey"."shownoanswer" AS "t1_c43", "survey"."showqnumcode" AS "t1_c44", "survey"."bouncetime" AS "t1_c45", "survey"."bounceprocessing" AS "t1_c46", "survey"."bounceaccounttype" AS "t1_c47", "survey"."bounceaccounthost" AS "t1_c48", "survey"."bounceaccountpass" AS "t1_c49", "survey"."bounceaccountencryption" AS "t1_c50", "survey"."bounceaccountuser" AS "t1_c51", "survey"."showwelcome" AS "t1_c52", "survey"."showprogress" AS "t1_c53", "survey"."questionindex" AS "t1_c54", "survey"."navigationdelay" AS "t1_c55", "survey"."nokeyboard" AS "t1_c56", "survey"."alloweditaftercompletion" AS "t1_c57", "survey"."googleanalyticsstyle" AS "t1_c58", "survey"."googleanalyticsapikey" AS "t1_c59", "survey"."tokenencryptionoptions" AS "t1_c60" FROM "lime_failed_emails" "t" LEFT OUTER JOIN "lime_surveys" "survey" ON ("survey"."sid"="t"."surveyid") WHERE (owner_id = 1 AND status != 'SEND SUCCESS')
2023-05-05 12:15:31.701 CEST [4833] [inconnu] galileo LimeSurveyInternet 4833 2023-05-05 12:15:31 CESTLOG: durée : 4.252 ms, instruction : INSERT INTO "lime_plugin_settings" ("plugin_id", "model", "model_id", "key", "value") VALUES (1, NULL, NULL, 'next_extension_update_check', '"2023-05-06 10:15:31"')
2023-05-05 12:15:31.716 CEST [4833] [inconnu] galileo LimeSurveyInternet 4833 2023-05-05 12:15:31 CESTLOG: durée : 6.086 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_boxes'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:15:31.721 CEST [4833] [inconnu] galileo LimeSurveyInternet 4833 2023-05-05 12:15:31 CESTLOG: durée : 3.691 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_boxes'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:15:31.759 CEST [4833] [inconnu] galileo LimeSurveyInternet 4833 2023-05-05 12:15:31 CESTLOG: durée : 2.337 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_notifications'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:15:31.768 CEST [4833] [inconnu] galileo LimeSurveyInternet 4833 2023-05-05 12:15:31 CESTLOG: durée : 4.380 ms, instruction : INSERT INTO "lime_notifications" ("status", "importance", "display_class", "entity", "entity_id", "title", "message", "created", "first_read", "hash") VALUES ('new', 3, 'default', 'user', 1, 'SSL n’est pas forcé', ' Attention : veuillez activer le chiffrement SSL dans les paramètres généraux/sécurité après avoir correctement configuré le SSL sur votre serveur.', NOW(), NULL, 'e38e0f2d00818b502d750c6dbf5434075fce0aa74b3f4a2a37b13d9986117873')
2023-05-05 12:15:32.519 CEST [4833] [inconnu] galileo LimeSurveyInternet 4833 2023-05-05 12:15:32 CESTLOG: durée : 2.125 ms, instruction : INSERT INTO "lime_settings_global" ("stg_name", "stg_value") VALUES ('AssetsVersion', '30331')
2023-05-05 12:15:39.050 CEST [4850] [inconnu] galileo LimeSurveyInternet 4850 2023-05-05 12:15:39 CESTLOG: durée : 2.232 ms, instruction : UPDATE "lime_notifications" SET "id"=1, "entity"='user', "entity_id"=1, "title"='SSL n’est pas forcé', "message"=' Attention : veuillez activer le chiffrement SSL dans les paramètres généraux/sécurité après avoir correctement configuré le SSL sur votre serveur.', "status"='read', "importance"=3, "display_class"='default', "hash"='e38e0f2d00818b502d750c6dbf5434075fce0aa74b3f4a2a37b13d9986117873', "created"='2023-05-05 12:15:31.764497', "first_read"='2023-05-05 10:15:39' WHERE "lime_notifications"."id"=1
2023-05-05 12:17:04.146 CEST [4940] [inconnu] galileo LimeSurveyInternet 4940 2023-05-05 12:17:04 CESTLOG: durée : 4.130 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_settings_global'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:17:04.151 CEST [4940] [inconnu] galileo LimeSurveyInternet 4940 2023-05-05 12:17:04 CESTLOG: durée : 2.738 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_settings_global'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:17:04.404 CEST [4940] [inconnu] galileo LimeSurveyInternet 4940 2023-05-05 12:17:04 CESTLOG: durée : 3.835 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_surveys'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:17:04.476 CEST [4941] [inconnu] galileo LimeSurveyInternet 4941 2023-05-05 12:17:04 CESTLOG: durée : 3.802 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_plugins'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:17:04.480 CEST [4941] [inconnu] galileo LimeSurveyInternet 4941 2023-05-05 12:17:04 CESTLOG: durée : 3.156 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_plugins'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:17:12.088 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 45.967 ms, instruction : COMMIT
2023-05-05 12:17:12.094 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTERREUR: la colonne « buttontext » de la relation « lime_boxes » existe déjà
2023-05-05 12:17:12.094 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTINSTRUCTION : ALTER TABLE "lime_boxes" ADD COLUMN "buttontext" character varying (255)
2023-05-05 12:17:12.104 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction
2023-05-05 12:17:12.104 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTINSTRUCTION : UPDATE "lime_boxes" SET "desc"='Create a new survey from scratch. Or simply copy or import an existing survey.', "buttontext"='Create survey' WHERE title = 'Create survey' AND page = 'welcome'
2023-05-05 12:17:12.119 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 12.790 ms, instruction : SELECT table_name, table_schema FROM information_schema.tables
WHERE table_schema='public' AND table_type='BASE TABLE'
2023-05-05 12:17:12.132 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 11.782 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_answers'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:17:12.135 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 2.530 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_answers'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:17:12.155 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 2.128 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_boxes'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:17:12.171 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 2.389 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_defaultvalues'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:17:12.198 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 5.849 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_groups'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:17:12.241 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 2.791 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_participant_attribute_names_lang'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:17:12.346 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 2.042 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_surveymenu_entries'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:17:12.354 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 3.883 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_surveys'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:17:12.364 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 2.104 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_surveys_groups'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:17:12.369 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 3.011 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_surveys_groupsettings'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 12:17:12.378 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 2.631 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_surveys_languagesettings'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:17:12.400 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 3.235 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_template_configuration'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:17:12.408 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 2.210 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_question_themes'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:17:12.450 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 2.697 ms, instruction : SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
attrelid=(
SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_user_in_permissionrole' AND relnamespace=(
SELECT oid FROM pg_catalog.pg_namespace WHERE nspname='public'
)
)
AND attnum IN (1, 2)
2023-05-05 12:17:12.480 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 2.045 ms, instruction : SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_message'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 12:17:12.490 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 9.373 ms, instruction : SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
attrelid=(
SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_message' AND relnamespace=(
SELECT oid FROM pg_catalog.pg_namespace WHERE nspname='public'
)
)
AND attnum IN (1, 2)
2023-05-05 12:17:12.497 CEST [4949] [inconnu] galileo LimeSurveyInternet 4949 2023-05-05 12:17:12 CESTLOG: durée : 5.807 ms, instruction : SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS 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_failed_emails'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum