2023-05-05 17:08:32.044 CEST [23925] 23925 2023-05-05 17:08:32 CESTLOG: démarrage de PostgreSQL 13.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit
2023-05-05 17:08:32.049 CEST [23925] 23925 2023-05-05 17:08:32 CESTLOG: en écoute sur IPv4, adresse « 0.0.0.0 », port 5432
2023-05-05 17:08:32.049 CEST [23925] 23925 2023-05-05 17:08:32 CESTLOG: en écoute sur IPv6, adresse « :: », port 5432
2023-05-05 17:08:32.053 CEST [23925] 23925 2023-05-05 17:08:32 CESTLOG: écoute sur la socket Unix « /var/run/postgresql/.s.PGSQL.5432 »
2023-05-05 17:08:32.057 CEST [23925] 23925 2023-05-05 17:08:32 CESTLOG: écoute sur la socket Unix « /tmp/.s.PGSQL.5432 »
2023-05-05 17:08:34.372 CEST [23931] 23931 2023-05-05 17:08:34 CESTLOG: le système de bases de données a été arrêté à 2023-05-05 17:08:31 CEST
2023-05-05 17:08:34.612 CEST [23925] 23925 2023-05-05 17:08:34 CESTLOG: le système de bases de données est prêt pour accepter les connexions
2023-05-05 17:09:23.722 CEST [23993] [inconnu] galileo limesurveyV3 23993 2023-05-05 17:09:23 CESTFATAL: la base de données « limesurveyV3 » n'existe pas
2023-05-05 17:09:23.728 CEST [23994] [inconnu] galileo limesurveyV3 23994 2023-05-05 17:09:23 CESTFATAL: la base de données « limesurveyV3 » n'existe pas
2023-05-05 17:09:29.111 CEST [24002] [inconnu] galileo galileo 24002 2023-05-05 17:09:29 CESTLOG: durée : 782.859 ms, instruction : CREATE DATABASE "limesurveyV3" ENCODING 'UTF8'
2023-05-05 17:09:33.396 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 9.528 ms, instruction : CREATE TABLE "lime_answers" (
"qid" integer NOT NULL,
"code" character varying (5) NOT NULL,
"answer" text NOT NULL,
"sortorder" integer NOT NULL,
"assessment_value" integer NOT NULL DEFAULT 0,
"language" character varying (20) NOT NULL DEFAULT 'en',
"scale_id" integer NOT NULL DEFAULT 0
)
2023-05-05 17:09:33.400 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.029 ms, instruction : ALTER TABLE "lime_answers" ADD CONSTRAINT "lime_answers_pk" PRIMARY KEY ("qid", "code", "language", "scale_id" )
2023-05-05 17:09:33.404 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.891 ms, instruction : CREATE INDEX "lime_answers_idx2" ON "lime_answers" ("sortorder")
2023-05-05 17:09:33.412 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 7.806 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 17:09:33.415 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.615 ms, instruction : CREATE INDEX "lime_assessments_idx2" ON "lime_assessments" ("sid")
2023-05-05 17:09:33.420 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.546 ms, instruction : CREATE INDEX "lime_assessments_idx3" ON "lime_assessments" ("gid")
2023-05-05 17:09:33.428 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 6.998 ms, instruction : CREATE TABLE "lime_boxes" (
"id" serial NOT NULL PRIMARY KEY,
"position" integer NULL ,
"url" text NOT NULL ,
"title" text NOT NULL ,
"ico" character varying (255) NULL ,
"desc" text NOT NULL ,
"page" text NOT NULL ,
"usergroup" integer NOT NULL
)
2023-05-05 17:09:33.438 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.861 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 17:09:33.442 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.108 ms, instruction : CREATE INDEX "lime_conditions_idx" ON "lime_conditions" ("qid")
2023-05-05 17:09:33.445 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.571 ms, instruction : CREATE INDEX "lime_conditions_idx3" ON "lime_conditions" ("cqid")
2023-05-05 17:09:33.449 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.626 ms, instruction : CREATE TABLE "lime_defaultvalues" (
"qid" integer NOT NULL default '0',
"scale_id" integer NOT NULL default '0',
"sqid" integer NOT NULL default '0',
"language" character varying (20) NOT NULL,
"specialtype" character varying (20) NOT NULL default '',
"defaultvalue" text
)
2023-05-05 17:09:33.454 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.607 ms, instruction : ALTER TABLE "lime_defaultvalues" ADD CONSTRAINT "lime_defaultvalues_pk" PRIMARY KEY ("qid", "specialtype", "language", "scale_id", "sqid" )
2023-05-05 17:09:33.462 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 6.580 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 17:09:33.466 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.111 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
)
2023-05-05 17:09:33.475 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 7.737 ms, instruction : CREATE TABLE "lime_groups" (
"gid" serial,
"sid" integer NOT NULL default '0',
"group_name" character varying (100) NOT NULL default '',
"group_order" integer NOT NULL default '0',
"description" text,
"language" character varying (20) default 'en' NOT NULL,
"randomization_group" character varying (20) NOT NULL default '',
"grelevance" text NULL,
CONSTRAINT lime_groups_composite_pkey PRIMARY KEY (gid, language)
)
2023-05-05 17:09:33.478 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.529 ms, instruction : CREATE INDEX "lime_idx1_groups" ON "lime_groups" ("sid")
2023-05-05 17:09:33.482 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.918 ms, instruction : CREATE INDEX "lime_idx2_groups" ON "lime_groups" ("group_name")
2023-05-05 17:09:33.486 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.644 ms, instruction : CREATE INDEX "lime_idx3_groups" ON "lime_groups" ("language")
2023-05-05 17:09:33.496 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 8.710 ms, instruction : CREATE TABLE "lime_labels" (
"id" serial NOT NULL PRIMARY KEY,
"lid" integer NOT NULL DEFAULT 0,
"code" character varying (5) NOT NULL default '',
"title" text,
"sortorder" integer NOT NULL,
"language" character varying (20) NOT NULL DEFAULT 'en',
"assessment_value" integer NOT NULL default '0'
)
2023-05-05 17:09:33.503 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 6.846 ms, instruction : CREATE INDEX "lime_idx1_labels" ON "lime_labels" ("code")
2023-05-05 17:09:33.507 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.799 ms, instruction : CREATE INDEX "lime_idx2_labels" ON "lime_labels" ("sortorder")
2023-05-05 17:09:33.510 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.484 ms, instruction : CREATE INDEX "lime_idx3_labels" ON "lime_labels" ("language")
2023-05-05 17:09:33.514 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.902 ms, instruction : CREATE INDEX "lime_idx4_labels" ON "lime_labels" ("lid", "sortorder", "language")
2023-05-05 17:09:33.520 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 5.223 ms, instruction : CREATE TABLE "lime_labelsets" (
"lid" serial NOT NULL PRIMARY KEY,
"label_name" character varying (100) NOT NULL DEFAULT '',
"languages" character varying (200) DEFAULT 'en'
)
2023-05-05 17:09:33.529 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 8.231 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 17:09:33.533 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.360 ms, instruction : CREATE INDEX "lime_notifications_pk" ON "lime_notifications" ("entity", "entity_id", "status")
2023-05-05 17:09:33.536 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.891 ms, instruction : CREATE INDEX "lime_idx1_notifications" ON "lime_notifications" ("hash")
2023-05-05 17:09:33.541 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.221 ms, instruction : CREATE TABLE "lime_participants" (
"participant_id" character varying (50) NOT NULL,
"firstname" character varying (150) NULL,
"lastname" character varying (150) NULL,
"email" text,
"language" character varying (40) NULL,
"blacklisted" character varying (1) NOT NULL,
"owner_uid" integer NOT NULL,
"created_by" integer NOT NULL,
"created" timestamp,
"modified" timestamp
)
2023-05-05 17:09:33.546 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.825 ms, instruction : ALTER TABLE "lime_participants" ADD CONSTRAINT "lime_participant_pk" PRIMARY KEY ("participant_id" )
2023-05-05 17:09:33.550 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.818 ms, instruction : CREATE INDEX "lime_idx1_participants" ON "lime_participants" ("firstname")
2023-05-05 17:09:33.555 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.799 ms, instruction : CREATE INDEX "lime_idx2_participants" ON "lime_participants" ("lastname")
2023-05-05 17:09:33.559 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.916 ms, instruction : CREATE INDEX "lime_idx3_participants" ON "lime_participants" ("language")
2023-05-05 17:09:33.563 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.848 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 17:09:33.568 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.430 ms, instruction : ALTER TABLE "lime_participant_attribute" ADD CONSTRAINT "lime_participant_attribute_pk" PRIMARY KEY ("participant_id", "attribute_id" )
2023-05-05 17:09:33.574 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.796 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 17:09:33.579 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.633 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,
CONSTRAINT lime_participant_attribute_names_composite_pkey PRIMARY KEY (attribute_id, attribute_type)
)
2023-05-05 17:09:33.583 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.469 ms, instruction : CREATE INDEX "lime_idx_participant_attribute_names" ON "lime_participant_attribute_names" ("attribute_id", "attribute_type")
2023-05-05 17:09:33.593 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 8.416 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 17:09:33.597 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.839 ms, instruction : ALTER TABLE "lime_participant_shares" ADD CONSTRAINT "lime_participant_shares_pk" PRIMARY KEY ("participant_id", "share_uid" )
2023-05-05 17:09:33.604 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 5.799 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 17:09:33.609 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.594 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_permissions" ON "lime_permissions" ("entity_id", "entity", "permission", "uid")
2023-05-05 17:09:33.614 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.003 ms, instruction : CREATE TABLE "lime_plugins" (
"id" serial NOT NULL PRIMARY KEY,
"name" character varying (50) NOT NULL,
"active" integer NOT NULL default 0,
"version" character varying (32) NULL
)
2023-05-05 17:09:33.623 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 8.294 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 17:09:33.650 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 25.455 ms, instruction : CREATE TABLE "lime_questions" (
"qid" serial,
"parent_qid" integer NOT NULL default '0',
"sid" integer NOT NULL default '0',
"gid" integer NOT NULL default '0',
"type" character varying (1) NOT NULL default 'T',
"title" character varying (20) NOT NULL default '',
"question" text NOT NULL,
"preg" text,
"help" text,
"other" character varying (1) NOT NULL default 'N',
"mandatory" character varying (1) NULL,
"question_order" integer NOT NULL,
"language" character varying (20) default 'en' NOT NULL,
"scale_id" integer NOT NULL default '0',
"same_default" integer NOT NULL default '0',
"relevance" text,
"modulename" character varying (255) NULL,
CONSTRAINT lime_questions_composite_pkey PRIMARY KEY (qid, language)
)
2023-05-05 17:09:33.654 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.499 ms, instruction : CREATE INDEX "lime_idx1_questions" ON "lime_questions" ("sid")
2023-05-05 17:09:33.659 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.091 ms, instruction : CREATE INDEX "lime_idx2_questions" ON "lime_questions" ("gid")
2023-05-05 17:09:33.663 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.289 ms, instruction : CREATE INDEX "lime_idx3_questions" ON "lime_questions" ("type")
2023-05-05 17:09:33.667 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.819 ms, instruction : CREATE INDEX "lime_idx4_questions" ON "lime_questions" ("title")
2023-05-05 17:09:33.672 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.097 ms, instruction : CREATE INDEX "lime_idx5_questions" ON "lime_questions" ("parent_qid")
2023-05-05 17:09:33.688 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 9.585 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 17:09:33.693 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.888 ms, instruction : CREATE INDEX "lime_idx1_question_attributes" ON "lime_question_attributes" ("qid")
2023-05-05 17:09:33.696 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.635 ms, instruction : CREATE INDEX "lime_idx2_question_attributes" ON "lime_question_attributes" ("attribute")
2023-05-05 17:09:33.704 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 6.990 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 17:09:33.708 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.873 ms, instruction : CREATE INDEX "lime_idx1_quota" ON "lime_quota" ("sid")
2023-05-05 17:09:33.716 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 7.081 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 17:09:33.721 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.620 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 17:09:33.726 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.308 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_quota_members" ON "lime_quota_members" ("sid", "qid", "quota_id", "code")
2023-05-05 17:09:33.737 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 10.637 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 17:09:33.741 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.591 ms, instruction : CREATE INDEX "lime_idx1_saved_control" ON "lime_saved_control" ("sid")
2023-05-05 17:09:33.744 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.949 ms, instruction : CREATE INDEX "lime_idx2_saved_control" ON "lime_saved_control" ("srid")
2023-05-05 17:09:33.749 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.050 ms, instruction : CREATE TABLE "lime_sessions" (
"id" character varying (32) NOT NULL,
"expire" integer NULL,
"data" bytea
)
2023-05-05 17:09:33.752 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.968 ms, instruction : ALTER TABLE "lime_sessions" ADD CONSTRAINT "lime_sessions_pk" PRIMARY KEY ("id" )
2023-05-05 17:09:33.759 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 6.112 ms, instruction : CREATE TABLE "lime_settings_global" (
"stg_name" character varying (50) NOT NULL default '',
"stg_value" text NOT NULL
)
2023-05-05 17:09:33.763 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.101 ms, instruction : ALTER TABLE "lime_settings_global" ADD CONSTRAINT "lime_settings_global_pk" PRIMARY KEY ("stg_name" )
2023-05-05 17:09:33.772 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 8.930 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 17:09:33.776 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.178 ms, instruction : CREATE INDEX "lime_idx1_settings_user" ON "lime_settings_user" ("uid")
2023-05-05 17:09:33.779 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.813 ms, instruction : CREATE INDEX "lime_idx2_settings_user" ON "lime_settings_user" ("entity")
2023-05-05 17:09:33.783 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.055 ms, instruction : CREATE INDEX "lime_idx3_settings_user" ON "lime_settings_user" ("entity_id")
2023-05-05 17:09:33.787 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.088 ms, instruction : CREATE INDEX "lime_idx4_settings_user" ON "lime_settings_user" ("stg_name")
2023-05-05 17:09:33.797 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 9.862 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 17:09:33.804 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 5.225 ms, instruction : CREATE UNIQUE INDEX "lime_surveymenu_name" ON "lime_surveymenu" ("name")
2023-05-05 17:09:33.807 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.688 ms, instruction : CREATE INDEX "lime_idx2_surveymenu" ON "lime_surveymenu" ("title")
2023-05-05 17:09:33.821 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 10.879 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 17:09:33.824 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.172 ms, instruction : CREATE INDEX "lime_idx1_surveymenu_entries" ON "lime_surveymenu_entries" ("menu_id")
2023-05-05 17:09:33.828 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.992 ms, instruction : CREATE INDEX "lime_idx5_surveymenu_entries" ON "lime_surveymenu_entries" ("menu_title")
2023-05-05 17:09:33.832 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.047 ms, instruction : CREATE UNIQUE INDEX "lime_surveymenu_entries_name" ON "lime_surveymenu_entries" ("name")
2023-05-05 17:09:33.888 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 9.884 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',
"faxto" character varying (20) NULL,
"format" character varying (1) NULL,
"savetimings" character varying (1) NOT NULL default 'N',
"template" character varying (100) default 'default',
"language" character varying (50) NULL,
"additional_languages" character varying (255) NULL,
"datestamp" character varying (1) NOT NULL default 'N',
"usecookie" character varying (1) NOT NULL default 'N',
"allowregister" character varying (1) NOT NULL default 'N',
"allowsave" character varying (1) NOT NULL default 'Y',
"autonumber_start" integer NOT NULL default '0',
"autoredirect" character varying (1) NOT NULL default 'N',
"allowprev" character varying (1) NOT NULL default 'N',
"printanswers" character varying (1) NOT NULL default 'N',
"ipaddr" character varying (1) NOT NULL default 'N',
"refurl" character varying (1) NOT NULL default 'N',
"datecreated" timestamp,
"showsurveypolicynotice" 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 'N',
"sendconfirmation" character varying (1) NOT NULL default 'Y',
"tokenanswerspersistence" character varying (1) NOT NULL default 'N',
"assessments" character varying (1) NOT NULL default 'N',
"usecaptcha" character varying (1) NOT NULL default 'N',
"usetokens" character varying (1) NOT NULL default 'N',
"bounce_email" character varying (254) NULL,
"attributedescriptions" text,
"emailresponseto" text NULL,
"emailnotificationto" text NULL,
"tokenlength" integer NOT NULL default '15',
"showxquestions" character varying (1) default 'Y',
"showgroupinfo" character varying (1) default 'B',
"shownoanswer" character varying (1) default 'Y',
"showqnumcode" character varying (1) default 'X',
"bouncetime" integer,
"bounceprocessing" character varying (1) default 'N',
"bounceaccounttype" character varying (4) ,
"bounceaccounthost" character varying (200) ,
"bounceaccountpass" character varying (100) ,
"bounceaccountencryption" character varying (3) ,
"bounceaccountuser" character varying (200) ,
"showwelcome" character varying (1) default 'Y',
"showprogress" character varying (1) default 'Y',
"questionindex" integer default '0' NOT NULL,
"navigationdelay" integer NOT NULL default '0',
"nokeyboard" character varying (1) default 'N',
"alloweditaftercompletion" character varying (1) default 'N',
"googleanalyticsstyle" character varying (1) NULL,
"googleanalyticsapikey" character varying (25) NULL
)
2023-05-05 17:09:33.897 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.456 ms, instruction : ALTER TABLE "lime_surveys" ADD CONSTRAINT "lime_surveys_pk" PRIMARY KEY ("sid" )
2023-05-05 17:09:33.901 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.156 ms, instruction : CREATE INDEX "lime_idx1_surveys" ON "lime_surveys" ("owner_id")
2023-05-05 17:09:33.905 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.424 ms, instruction : CREATE INDEX "lime_idx2_surveys" ON "lime_surveys" ("gsid")
2023-05-05 17:09:33.915 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 9.178 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,
"created" timestamp NULL,
"modified" timestamp NULL,
"created_by" integer NOT NULL
)
2023-05-05 17:09:33.919 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.223 ms, instruction : CREATE INDEX "lime_idx1_surveys_groups" ON "lime_surveys_groups" ("name")
2023-05-05 17:09:33.923 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.031 ms, instruction : CREATE INDEX "lime_idx2_surveys_groups" ON "lime_surveys_groups" ("title")
2023-05-05 17:09:33.929 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.624 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,
"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 17:09:33.934 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.323 ms, instruction : ALTER TABLE "lime_surveys_languagesettings" ADD CONSTRAINT "lime_surveys_languagesettings_pk" PRIMARY KEY ("surveyls_survey_id", "surveyls_language" )
2023-05-05 17:09:33.938 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.120 ms, instruction : CREATE INDEX "lime_idx1_surveys_languagesettings" ON "lime_surveys_languagesettings" ("surveyls_title")
2023-05-05 17:09:33.944 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.572 ms, instruction : ALTER TABLE "lime_survey_links" ADD CONSTRAINT "lime_survey_links_pk" PRIMARY KEY ("participant_id", "token_id", "survey_id" )
2023-05-05 17:09:33.949 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.841 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 17:09:33.960 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 9.716 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 17:09:33.965 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.238 ms, instruction : CREATE INDEX "lime_idx1_templates" ON "lime_templates" ("name")
2023-05-05 17:09:33.968 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.882 ms, instruction : CREATE INDEX "lime_idx2_templates" ON "lime_templates" ("title")
2023-05-05 17:09:33.972 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 3.198 ms, instruction : CREATE INDEX "lime_idx3_templates" ON "lime_templates" ("owner_id")
2023-05-05 17:09:33.975 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.793 ms, instruction : CREATE INDEX "lime_idx4_templates" ON "lime_templates" ("extends")
2023-05-05 17:09:33.987 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 8.519 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 17:09:33.990 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.772 ms, instruction : CREATE INDEX "lime_idx1_template_configuration" ON "lime_template_configuration" ("template_name")
2023-05-05 17:09:33.995 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 4.103 ms, instruction : CREATE INDEX "lime_idx2_template_configuration" ON "lime_template_configuration" ("sid")
2023-05-05 17:09:33.998 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:33 CESTLOG: durée : 2.872 ms, instruction : CREATE INDEX "lime_idx3_template_configuration" ON "lime_template_configuration" ("gsid")
2023-05-05 17:09:34.004 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 4.811 ms, instruction : CREATE INDEX "lime_idx4_template_configuration" ON "lime_template_configuration" ("uid")
2023-05-05 17:09:34.016 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 8.420 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 17:09:34.020 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 3.266 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_tutorials" ON "lime_tutorials" ("name")
2023-05-05 17:09:34.025 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 3.190 ms, instruction : ALTER TABLE "lime_map_tutorial_users" ADD CONSTRAINT "lime_map_tutorial_users_pk" PRIMARY KEY ("uid", "tid" )
2023-05-05 17:09:34.030 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 2.773 ms, instruction : ALTER TABLE "lime_tutorial_entry_relation" ADD CONSTRAINT "lime_tutorial_entry_relation_pk" PRIMARY KEY ("teid", "tid" )
2023-05-05 17:09:34.033 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 2.812 ms, instruction : CREATE INDEX "lime_idx1_tutorial_entry_relation" ON "lime_tutorial_entry_relation" ("uid")
2023-05-05 17:09:34.047 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 2.832 ms, instruction : CREATE INDEX "lime_idx2_tutorial_entry_relation" ON "lime_tutorial_entry_relation" ("sid")
2023-05-05 17:09:34.057 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 8.877 ms, instruction : CREATE TABLE "lime_tutorial_entries" (
"teid" serial NOT NULL PRIMARY KEY,
"ordering" integer,
"title" text,
"content" text,
"settings" text
)
2023-05-05 17:09:34.062 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 3.643 ms, instruction : ALTER TABLE "lime_user_in_groups" ADD CONSTRAINT "lime_user_in_groups_pk" PRIMARY KEY ("ugid", "uid" )
2023-05-05 17:09:34.071 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 8.766 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,
"created" timestamp,
"modified" timestamp
)
2023-05-05 17:09:34.075 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 3.053 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_users" ON "lime_users" ("users_name")
2023-05-05 17:09:34.079 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 3.043 ms, instruction : CREATE INDEX "lime_idx2_users" ON "lime_users" ("email")
2023-05-05 17:09:34.087 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 7.800 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 17:09:34.092 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 3.731 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_user_groups" ON "lime_user_groups" ("name")
2023-05-05 17:09:34.100 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 7.837 ms, instruction : CREATE TABLE "lime_asset_version" (
"id" serial NOT NULL PRIMARY KEY,
"path" text NOT NULL,
"version" integer NOT NULL
)
2023-05-05 17:09:34.110 CEST [24008] [inconnu] galileo limesurveyV3 24008 2023-05-05 17:09:34 CESTLOG: durée : 8.487 ms, instruction : COMMIT
2023-05-05 17:09:51.330 CEST [24026] [inconnu] galileo limesurveyV3 24026 2023-05-05 17:09:51 CESTLOG: durée : 5.618 ms, instruction : SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(d.adbin,d.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 17:09:51.335 CEST [24026] [inconnu] galileo limesurveyV3 24026 2023-05-05 17:09:51 CESTLOG: durée : 3.458 ms, instruction : SELECT conname, consrc, contype, indkey FROM (
SELECT
conname,
CASE WHEN contype='f' THEN
pg_catalog.pg_get_constraintdef(oid)
ELSE
'CHECK (' || pg_get_expr(conbin, conrelid) || ')'
END 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_users'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:09:51.508 CEST [24026] [inconnu] galileo limesurveyV3 24026 2023-05-05 17:09:51 CESTLOG: durée : 2.518 ms, instruction : SELECT conname, consrc, contype, indkey FROM (
SELECT
conname,
CASE WHEN contype='f' THEN
pg_catalog.pg_get_constraintdef(oid)
ELSE
'CHECK (' || pg_get_expr(conbin, conrelid) || ')'
END 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 17:09:51.528 CEST [24026] [inconnu] galileo limesurveyV3 24026 2023-05-05 17:09:51 CESTLOG: durée : 2.041 ms, instruction : SELECT conname, consrc, contype, indkey FROM (
SELECT
conname,
CASE WHEN contype='f' THEN
pg_catalog.pg_get_constraintdef(oid)
ELSE
'CHECK (' || pg_get_expr(conbin, conrelid) || ')'
END 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_permissions'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:09:54.230 CEST [24030] [inconnu] galileo limesurveyV3 24030 2023-05-05 17:09:54 CESTLOG: durée : 13.663 ms, instruction : SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(d.adbin,d.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 17:09:54.234 CEST [24030] [inconnu] galileo limesurveyV3 24030 2023-05-05 17:09:54 CESTLOG: durée : 3.361 ms, instruction : SELECT conname, consrc, contype, indkey FROM (
SELECT
conname,
CASE WHEN contype='f' THEN
pg_catalog.pg_get_constraintdef(oid)
ELSE
'CHECK (' || pg_get_expr(conbin, conrelid) || ')'
END 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 17:09:54.243 CEST [24030] [inconnu] galileo limesurveyV3 24030 2023-05-05 17:09:54 CESTLOG: durée : 4.232 ms, instruction : SELECT * FROM "lime_settings_global" "t"
2023-05-05 17:09:54.251 CEST [24030] [inconnu] galileo limesurveyV3 24030 2023-05-05 17:09:54 CESTLOG: durée : 2.814 ms, instruction : SELECT conname, consrc, contype, indkey FROM (
SELECT
conname,
CASE WHEN contype='f' THEN
pg_catalog.pg_get_constraintdef(oid)
ELSE
'CHECK (' || pg_get_expr(conbin, conrelid) || ')'
END 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_asset_version'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:09:54.312 CEST [24030] [inconnu] galileo limesurveyV3 24030 2023-05-05 17:09:54 CESTLOG: durée : 4.586 ms, instruction : SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(d.adbin,d.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 17:09:54.316 CEST [24030] [inconnu] galileo limesurveyV3 24030 2023-05-05 17:09:54 CESTLOG: durée : 2.492 ms, instruction : SELECT conname, consrc, contype, indkey FROM (
SELECT
conname,
CASE WHEN contype='f' THEN
pg_catalog.pg_get_constraintdef(oid)
ELSE
'CHECK (' || pg_get_expr(conbin, conrelid) || ')'
END 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'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:09:54.360 CEST [24031] [inconnu] galileo limesurveyV3 24031 2023-05-05 17:09:54 CESTLOG: durée : 3.763 ms, instruction : SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(d.adbin,d.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 17:09:54.365 CEST [24031] [inconnu] galileo limesurveyV3 24031 2023-05-05 17:09:54 CESTLOG: durée : 4.079 ms, instruction : SELECT conname, consrc, contype, indkey FROM (
SELECT
conname,
CASE WHEN contype='f' THEN
pg_catalog.pg_get_constraintdef(oid)
ELSE
'CHECK (' || pg_get_expr(conbin, conrelid) || ')'
END 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_plugins'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:09:54.395 CEST [24031] [inconnu] galileo limesurveyV3 24031 2023-05-05 17:09:54 CESTLOG: durée : 9.078 ms, instruction : INSERT INTO "lime_plugins" ("active", "name") VALUES (1, 'Authdb')
2023-05-05 17:10:05.323 CEST [24056] [inconnu] galileo limesurveyV3 24056 2023-05-05 17:10:05 CESTLOG: durée : 3.479 ms, instruction : SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(d.adbin,d.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 17:10:05.327 CEST [24056] [inconnu] galileo limesurveyV3 24056 2023-05-05 17:10:05 CESTLOG: durée : 3.623 ms, instruction : SELECT conname, consrc, contype, indkey FROM (
SELECT
conname,
CASE WHEN contype='f' THEN
pg_catalog.pg_get_constraintdef(oid)
ELSE
'CHECK (' || pg_get_expr(conbin, conrelid) || ')'
END 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_failed_login_attempts'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:10:05.344 CEST [24056] [inconnu] galileo limesurveyV3 24056 2023-05-05 17:10:05 CESTLOG: durée : 2.294 ms, instruction : SELECT conname, consrc, contype, indkey FROM (
SELECT
conname,
CASE WHEN contype='f' THEN
pg_catalog.pg_get_constraintdef(oid)
ELSE
'CHECK (' || pg_get_expr(conbin, conrelid) || ')'
END 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_users'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:10:05.500 CEST [24056] [inconnu] galileo limesurveyV3 24056 2023-05-05 17:10:05 CESTLOG: durée : 5.059 ms, instruction : SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=1
2023-05-05 17:10:05.560 CEST [24057] [inconnu] galileo limesurveyV3 24057 2023-05-05 17:10:05 CESTLOG: durée : 13.189 ms, instruction : SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(d.adbin,d.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_templates'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 17:10:05.569 CEST [24057] [inconnu] galileo limesurveyV3 24057 2023-05-05 17:10:05 CESTLOG: durée : 8.076 ms, instruction : SELECT conname, consrc, contype, indkey FROM (
SELECT
conname,
CASE WHEN contype='f' THEN
pg_catalog.pg_get_constraintdef(oid)
ELSE
'CHECK (' || pg_get_expr(conbin, conrelid) || ')'
END 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_templates'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:10:05.573 CEST [24057] [inconnu] galileo limesurveyV3 24057 2023-05-05 17:10:05 CESTLOG: durée : 3.495 ms, instruction : SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
attrelid=(
SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_templates' AND relnamespace=(
SELECT oid FROM pg_catalog.pg_namespace WHERE nspname='public'
)
)
AND attnum IN (1)
2023-05-05 17:10:05.584 CEST [24057] [inconnu] galileo limesurveyV3 24057 2023-05-05 17:10:05 CESTLOG: durée : 6.479 ms, instruction : SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(d.adbin,d.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 17:10:05.602 CEST [24057] [inconnu] galileo limesurveyV3 24057 2023-05-05 17:10:05 CESTLOG: durée : 10.298 ms, instruction : SELECT conname, consrc, contype, indkey FROM (
SELECT
conname,
CASE WHEN contype='f' THEN
pg_catalog.pg_get_constraintdef(oid)
ELSE
'CHECK (' || pg_get_expr(conbin, conrelid) || ')'
END 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_boxes'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:10:05.670 CEST [24057] [inconnu] galileo limesurveyV3 24057 2023-05-05 17:10:05 CESTLOG: durée : 42.100 ms, instruction : SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(d.adbin,d.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_notifications'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 17:10:05.675 CEST [24057] [inconnu] galileo limesurveyV3 24057 2023-05-05 17:10:05 CESTLOG: durée : 3.511 ms, instruction : SELECT conname, consrc, contype, indkey FROM (
SELECT
conname,
CASE WHEN contype='f' THEN
pg_catalog.pg_get_constraintdef(oid)
ELSE
'CHECK (' || pg_get_expr(conbin, conrelid) || ')'
END 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_notifications'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:10:05.684 CEST [24057] [inconnu] galileo limesurveyV3 24057 2023-05-05 17:10:05 CESTLOG: durée : 5.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, '2a58cdd3f0024cceb4eab22785afef2d2d8e5bf193dbc96e42cef44d397005df')
2023-05-05 17:10:06.186 CEST [24057] [inconnu] galileo limesurveyV3 24057 2023-05-05 17:10:06 CESTLOG: durée : 2.149 ms, instruction : SELECT conname, consrc, contype, indkey FROM (
SELECT
conname,
CASE WHEN contype='f' THEN
pg_catalog.pg_get_constraintdef(oid)
ELSE
'CHECK (' || pg_get_expr(conbin, conrelid) || ')'
END 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_tutorials'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:10:11.347 CEST [24064] [inconnu] galileo limesurveyV3 24064 2023-05-05 17:10:11 CESTLOG: durée : 23.524 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"='2a58cdd3f0024cceb4eab22785afef2d2d8e5bf193dbc96e42cef44d397005df', "created"='2023-05-05 17:10:05.67888', "first_read"='2023-05-05 15:10:11' WHERE "lime_notifications"."id"=1
2023-05-05 17:10:14.514 CEST [24070] [inconnu] galileo limesurveyV3 24070 2023-05-05 17:10:14 CESTLOG: durée : 6.321 ms, instruction : SELECT * FROM "lime_settings_global" "t"
2023-05-05 17:12:26.246 CEST [24213] [inconnu] galileo limesurveyV3 24213 2023-05-05 17:12:26 CESTLOG: durée : 4.602 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 17:12:26.252 CEST [24213] [inconnu] galileo limesurveyV3 24213 2023-05-05 17:12:26 CESTLOG: durée : 4.690 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 17:12:26.438 CEST [24213] [inconnu] galileo limesurveyV3 24213 2023-05-05 17:12:26 CESTLOG: durée : 3.649 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 17:12:26.442 CEST [24213] [inconnu] galileo limesurveyV3 24213 2023-05-05 17:12:26 CESTLOG: durée : 2.060 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 17:12:26.495 CEST [24214] [inconnu] galileo limesurveyV3 24214 2023-05-05 17:12:26 CESTLOG: durée : 3.380 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 17:12:26.499 CEST [24214] [inconnu] galileo limesurveyV3 24214 2023-05-05 17:12:26 CESTLOG: durée : 3.012 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 17:12:32.716 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 74.501 ms, instruction : COMMIT
2023-05-05 17:12:32.725 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 7.281 ms, instruction : SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' and table_name like 'lime_tokens%'
2023-05-05 17:12:32.731 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 2.189 ms, instruction : COMMIT
2023-05-05 17:12:32.742 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 2.591 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_question_l10ns'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 17:12:32.753 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 9.899 ms, instruction : CREATE TABLE "lime_question_l10ns" (
"id" serial NOT NULL PRIMARY KEY,
"qid" integer NOT NULL,
"question" text NOT NULL,
"help" text,
"language" character varying (20) NOT NULL
)
2023-05-05 17:12:32.758 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 4.919 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_question_l10ns" ON "lime_question_l10ns" ("qid", "language")
2023-05-05 17:12:32.777 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 9.262 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,
"question_order" integer NOT NULL,
"scale_id" integer NOT NULL default '0',
"same_default" integer NOT NULL default '0',
"relevance" text,
"modulename" character varying (255) NULL
)
2023-05-05 17:12:32.783 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 3.147 ms, instruction : DROP TABLE "lime_questions_update400"
2023-05-05 17:12:32.787 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 2.693 ms, instruction : CREATE INDEX "lime_idx1_questions" ON "lime_questions" ("sid")
2023-05-05 17:12:32.792 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 3.515 ms, instruction : CREATE INDEX "lime_idx2_questions" ON "lime_questions" ("gid")
2023-05-05 17:12:32.796 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 2.520 ms, instruction : CREATE INDEX "lime_idx3_questions" ON "lime_questions" ("type")
2023-05-05 17:12:32.800 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 2.714 ms, instruction : CREATE INDEX "lime_idx4_questions" ON "lime_questions" ("title")
2023-05-05 17:12:32.804 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 3.004 ms, instruction : CREATE INDEX "lime_idx5_questions" ON "lime_questions" ("parent_qid")
2023-05-05 17:12:32.815 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 8.755 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 17:12:32.818 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 2.611 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_group_l10ns" ON "lime_group_l10ns" ("gid", "language")
2023-05-05 17:12:32.835 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 8.801 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 17:12:32.844 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 3.539 ms, instruction : CREATE INDEX "lime_idx1_groups" ON "lime_groups" ("sid")
2023-05-05 17:12:32.855 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 8.939 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 17:12:32.860 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 4.561 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_answer_l10ns" ON "lime_answer_l10ns" ("aid", "language")
2023-05-05 17:12:32.869 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 5.921 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 17:12:32.873 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 2.713 ms, instruction : CREATE INDEX "answer_update400_idx_10" ON "lime_answers_update400" ("qid", "code", "scale_id")
2023-05-05 17:12:32.882 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 2.991 ms, instruction : CREATE UNIQUE INDEX "lime_answers_idx" ON "lime_answers" ("qid", "code", "scale_id")
2023-05-05 17:12:32.886 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 2.584 ms, instruction : CREATE INDEX "lime_answers_idx2" ON "lime_answers" ("sortorder")
2023-05-05 17:12:32.897 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 4.811 ms, instruction : CREATE TABLE "lime_labels" (
"id" serial NOT NULL PRIMARY KEY,
"lid" integer NOT NULL,
"code" character varying (5) NOT NULL,
"sortorder" integer NOT NULL,
"assessment_value" integer NOT NULL DEFAULT 0
)
2023-05-05 17:12:32.907 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 7.044 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 17:12:32.911 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 3.123 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_label_l10ns" ON "lime_label_l10ns" ("label_id", "language")
2023-05-05 17:12:32.915 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 2.026 ms, instruction : DROP TABLE "lime_labels_update400"
2023-05-05 17:12:32.933 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 6.455 ms, instruction : COMMIT
2023-05-05 17:12:32.941 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 5.278 ms, instruction : ALTER TABLE "lime_plugins" ADD COLUMN "load_error_message" text
2023-05-05 17:12:32.946 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 3.329 ms, instruction : COMMIT
2023-05-05 17:12:32.957 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 3.738 ms, instruction : SELECT table_name, table_schema FROM information_schema.tables
WHERE table_schema='public' AND table_type='BASE TABLE'
2023-05-05 17:12:32.968 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 8.547 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',
"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 'N',
"sendconfirmation" character varying (1) NOT NULL DEFAULT 'Y',
"tokenanswerspersistence" character varying (1) NOT NULL DEFAULT 'N',
"assessments" character varying (1) NOT NULL DEFAULT 'N',
"usecaptcha" character varying (1) NOT NULL DEFAULT 'N',
"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 17:12:32.971 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 2.873 ms, instruction : ALTER TABLE "lime_surveys_groupsettings" ADD CONSTRAINT "PK_surveys_groupsettings_IJESXO1V8BFG" PRIMARY KEY ("gsid" )
2023-05-05 17:12:32.976 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 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_surveys_groupsettings'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 17:12:32.980 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 2.707 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_groupsettings'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:32.988 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:32 CESTLOG: durée : 2.073 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_templates'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.032 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 7.913 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 17:12:33.036 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 3.000 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_defaultvalue_l10ns" ON "lime_defaultvalue_l10ns" ("dvid", "language")
2023-05-05 17:12:33.040 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.795 ms, instruction : CREATE INDEX "defaultvalues_update407_idx_10" ON "lime_defaultvalues_update407" ("qid", "scale_id", "sqid", "specialtype", "language")
2023-05-05 17:12:33.047 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 5.039 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 17:12:33.051 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.555 ms, instruction : CREATE INDEX "lime_idx1_defaultvalue" ON "lime_defaultvalues" ("qid", "scale_id", "sqid", "specialtype")
2023-05-05 17:12:33.150 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.138 ms, instruction : COMMIT
2023-05-05 17:12:33.172 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 8.388 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 17:12:33.175 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.992 ms, instruction : CREATE UNIQUE INDEX "lime_idx1_name" ON "lime_permissiontemplates" ("name")
2023-05-05 17:12:33.181 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 3.937 ms, instruction : ALTER TABLE "lime_user_in_permissionrole" ADD CONSTRAINT "lime_user_in_permissionrole_pk" PRIMARY KEY ("ptid", "uid" )
2023-05-05 17:12:33.185 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.576 ms, instruction : COMMIT
2023-05-05 17:12:33.197 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 8.171 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 17:12:33.201 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 3.267 ms, instruction : CREATE INDEX "lime_idx1_question_themes" ON "lime_question_themes" ("name")
2023-05-05 17:12:33.241 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.326 ms, instruction : COMMIT
2023-05-05 17:12:33.293 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.386 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_surveymenu_entries'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 17:12:33.296 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.323 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 17:12:33.356 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 5.075 ms, instruction : SELECT 'SELECT SETVAL(' ||
quote_literal(quote_ident(PGT.schemaname) || '.' || quote_ident(S.relname)) ||
', COALESCE(MAX(' ||quote_ident(C.attname)|| '), 1) ) FROM ' ||
quote_ident(PGT.schemaname)|| '.'||quote_ident(T.relname)|| ';'
FROM pg_class AS S,
pg_depend AS D,
pg_class AS T,
pg_attribute AS C,
pg_tables AS PGT
WHERE S.relkind = 'S'
AND S.oid = D.objid
AND D.refobjid = T.oid
AND D.refobjid = C.attrelid
AND D.refobjsubid = C.attnum
AND T.relname = PGT.tablename AND PGT.tablename= 'lime_questions' ORDER BY S.relname;
2023-05-05 17:12:33.362 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 4.277 ms, instruction : SELECT 'SELECT SETVAL(' ||
quote_literal(quote_ident(PGT.schemaname) || '.' || quote_ident(S.relname)) ||
', COALESCE(MAX(' ||quote_ident(C.attname)|| '), 1) ) FROM ' ||
quote_ident(PGT.schemaname)|| '.'||quote_ident(T.relname)|| ';'
FROM pg_class AS S,
pg_depend AS D,
pg_class AS T,
pg_attribute AS C,
pg_tables AS PGT
WHERE S.relkind = 'S'
AND S.oid = D.objid
AND D.refobjid = T.oid
AND D.refobjid = C.attrelid
AND D.refobjsubid = C.attnum
AND T.relname = PGT.tablename AND PGT.tablename= 'lime_groups' ORDER BY S.relname;
2023-05-05 17:12:33.368 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 4.022 ms, instruction : SELECT 'SELECT SETVAL(' ||
quote_literal(quote_ident(PGT.schemaname) || '.' || quote_ident(S.relname)) ||
', COALESCE(MAX(' ||quote_ident(C.attname)|| '), 1) ) FROM ' ||
quote_ident(PGT.schemaname)|| '.'||quote_ident(T.relname)|| ';'
FROM pg_class AS S,
pg_depend AS D,
pg_class AS T,
pg_attribute AS C,
pg_tables AS PGT
WHERE S.relkind = 'S'
AND S.oid = D.objid
AND D.refobjid = T.oid
AND D.refobjid = C.attrelid
AND D.refobjsubid = C.attnum
AND T.relname = PGT.tablename AND PGT.tablename= 'lime_answers' ORDER BY S.relname;
2023-05-05 17:12:33.373 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 3.874 ms, instruction : SELECT 'SELECT SETVAL(' ||
quote_literal(quote_ident(PGT.schemaname) || '.' || quote_ident(S.relname)) ||
', COALESCE(MAX(' ||quote_ident(C.attname)|| '), 1) ) FROM ' ||
quote_ident(PGT.schemaname)|| '.'||quote_ident(T.relname)|| ';'
FROM pg_class AS S,
pg_depend AS D,
pg_class AS T,
pg_attribute AS C,
pg_tables AS PGT
WHERE S.relkind = 'S'
AND S.oid = D.objid
AND D.refobjid = T.oid
AND D.refobjid = C.attrelid
AND D.refobjsubid = C.attnum
AND T.relname = PGT.tablename AND PGT.tablename= 'lime_labels' ORDER BY S.relname;
2023-05-05 17:12:33.377 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 4.001 ms, instruction : SELECT SETVAL('public.lime_labels_id_seq1', COALESCE(MAX(id), 1) ) FROM public.lime_labels;
2023-05-05 17:12:33.384 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 5.601 ms, instruction : SELECT 'SELECT SETVAL(' ||
quote_literal(quote_ident(PGT.schemaname) || '.' || quote_ident(S.relname)) ||
', COALESCE(MAX(' ||quote_ident(C.attname)|| '), 1) ) FROM ' ||
quote_ident(PGT.schemaname)|| '.'||quote_ident(T.relname)|| ';'
FROM pg_class AS S,
pg_depend AS D,
pg_class AS T,
pg_attribute AS C,
pg_tables AS PGT
WHERE S.relkind = 'S'
AND S.oid = D.objid
AND D.refobjid = T.oid
AND D.refobjid = C.attrelid
AND D.refobjsubid = C.attnum
AND T.relname = PGT.tablename AND PGT.tablename= 'lime_defaultvalues' ORDER BY S.relname;
2023-05-05 17:12:33.390 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.432 ms, instruction : CREATE INDEX "sess_expire" ON "lime_sessions" ("expire")
2023-05-05 17:12:33.403 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.026 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 17:12:33.425 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 7.377 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
)
2023-05-05 17:12:33.464 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.267 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_archived_table_settings'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.510 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.756 ms, instruction : CREATE UNIQUE INDEX "lime_idx5_labels" ON "lime_labels" ("lid", "code")
2023-05-05 17:12:33.551 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.717 ms, instruction : COMMIT
2023-05-05 17:12:33.602 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 6.451 ms, instruction : CREATE TABLE "lime_source_message" (
"id" serial NOT NULL PRIMARY KEY,
"category" character varying (35) ,
"message" text
)
2023-05-05 17:12:33.606 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 3.614 ms, instruction : CREATE TABLE "lime_message" (
"id" integer NOT NULL,
"language" character varying (50) NOT NULL default '',
"translation" text
)
2023-05-05 17:12:33.611 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 4.703 ms, instruction : ALTER TABLE "lime_message" ADD CONSTRAINT "lime_message_pk" PRIMARY KEY ("id", "language" )
2023-05-05 17:12:33.615 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.102 ms, instruction : COMMIT
2023-05-05 17:12:33.625 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTERREUR: la colonne « language » est dans une clé primaire
2023-05-05 17:12:33.625 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTINSTRUCTION : ALTER TABLE lime_message ALTER COLUMN language DROP NOT NULL
2023-05-05 17:12:33.665 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 8.875 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 17:12:33.702 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTERREUR: la table « lime_failed_email » n'existe pas
2023-05-05 17:12:33.702 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTINSTRUCTION : DROP TABLE "lime_failed_email"
2023-05-05 17:12:33.711 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 7.987 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 17:12:33.717 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.187 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 17:12:33.762 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.774 ms, instruction : CREATE INDEX "lime_idx1_quota_id" ON "lime_quota_languagesettings" ("quotals_quota_id")
2023-05-05 17:12:33.765 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.611 ms, instruction : CREATE INDEX "lime_idx2_quota_id" ON "lime_quota_members" ("quota_id")
2023-05-05 17:12:33.772 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.348 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_assessments'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.778 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.356 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 17:12:33.784 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.365 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_conditions'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.789 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.227 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 17:12:33.793 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.021 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_expression_errors'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'))
ORDER BY a.attnum
2023-05-05 17:12:33.796 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 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_expression_errors'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.802 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.222 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 17:12:33.807 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.084 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_labelsets'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.814 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.196 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 17:12:33.819 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.034 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_participants'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.825 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.710 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'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.830 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.237 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 17:12:33.835 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.036 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'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.841 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.151 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_values'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.848 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.190 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_shares'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.858 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.044 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_plugin_settings'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.864 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.171 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 17:12:33.869 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.200 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_attributes'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.875 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.368 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_quota'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.880 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.061 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_quota_languagesettings'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.886 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.302 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_quota_members'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.892 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.016 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_saved_control'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.902 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.113 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 17:12:33.925 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 3.992 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 17:12:33.929 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.325 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 17:12:33.940 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.179 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 17:12:33.946 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.102 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_survey_links'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.961 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.071 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 17:12:33.976 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.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_tutorial_entry_relation'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.982 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.043 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_tutorial_entries'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.987 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.270 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_user_in_groups'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:33.993 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:33 CESTLOG: durée : 2.492 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 17:12:34.002 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:34 CESTLOG: durée : 2.012 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 17:12:34.013 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:34 CESTLOG: durée : 2.173 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_questions'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:34.033 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:34 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_answers'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:34.044 CEST [24221] [inconnu] galileo limesurveyV3 24221 2023-05-05 17:12:34 CESTLOG: durée : 3.478 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_label_l10ns'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:34.062 CEST [24224] [inconnu] galileo limesurveyV3 24224 2023-05-05 17:12:34 CESTLOG: durée : 5.128 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 17:12:34.066 CEST [24224] [inconnu] galileo limesurveyV3 24224 2023-05-05 17:12:34 CESTLOG: durée : 3.563 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 17:12:34.072 CEST [24224] [inconnu] galileo limesurveyV3 24224 2023-05-05 17:12:34 CESTLOG: durée : 4.138 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 17:12:34.075 CEST [24224] [inconnu] galileo limesurveyV3 24224 2023-05-05 17:12:34 CESTLOG: durée : 2.080 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 17:12:34.082 CEST [24224] [inconnu] galileo limesurveyV3 24224 2023-05-05 17:12:34 CESTLOG: durée : 2.370 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_templates'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public'))
2023-05-05 17:12:34.106 CEST [24224] [inconnu] galileo limesurveyV3 24224 2023-05-05 17:12:34 CESTLOG: durée : 2.243 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 17:12:42.297 CEST [24233] [inconnu] galileo limesurveyV3 24233 2023-05-05 17:12:42 CESTLOG: durée : 5.521 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 17:12:42.302 CEST [24233] [inconnu] galileo limesurveyV3 24233 2023-05-05 17:12:42 CESTLOG: durée : 3.211 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 17:12:42.365 CEST [24233] [inconnu] galileo limesurveyV3 24233 2023-05-05 17:12:42 CESTLOG: durée : 5.325 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 17:12:42.404 CEST [24234] [inconnu] galileo limesurveyV3 24234 2023-05-05 17:12:42 CESTLOG: durée : 5.830 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 17:12:42.408 CEST [24234] [inconnu] galileo limesurveyV3 24234 2023-05-05 17:12:42 CESTLOG: durée : 2.600 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 17:12:53.482 CEST [24245] [inconnu] galileo limesurveyV3 24245 2023-05-05 17:12:53 CESTLOG: durée : 2.568 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 17:12:53.488 CEST [24245] [inconnu] galileo limesurveyV3 24245 2023-05-05 17:12:53 CESTLOG: durée : 5.070 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 17:12:53.657 CEST [24246] [inconnu] galileo limesurveyV3 24246 2023-05-05 17:12:53 CESTLOG: durée : 3.124 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 17:12:53.667 CEST [24246] [inconnu] galileo limesurveyV3 24246 2023-05-05 17:12:53 CESTLOG: durée : 9.623 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 17:12:54.168 CEST [24246] [inconnu] galileo limesurveyV3 24246 2023-05-05 17:12:54 CESTLOG: durée : 2.570 ms, instruction : UPDATE "lime_settings_global" SET "stg_name"='AssetsVersion', "stg_value"='30334' WHERE "lime_settings_global"."stg_name"='AssetsVersion'
2023-05-05 17:12:58.727 CEST [24261] [inconnu] galileo limesurveyV3 24261 2023-05-05 17:12:58 CESTLOG: durée : 25.247 ms, instruction : UPDATE "lime_notifications" SET "id"=3, "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 17:12:53.693137', "first_read"='2023-05-05 15:12:58' WHERE "lime_notifications"."id"=3