From ec38850402e10ca9ef43a9dbebceafbae2c387c7 Mon Sep 17 00:00:00 2001 From: "vincent@cubedesigners.com" Date: Tue, 19 Sep 2023 13:29:55 +0000 Subject: [PATCH] wait #6260 @0.25 --- inc/commons/class.common.core.php | 14 +++----------- 1 file changed, 3 insertions(+), 11 deletions(-) diff --git a/inc/commons/class.common.core.php b/inc/commons/class.common.core.php index 459e3f675..f3d7b3093 100644 --- a/inc/commons/class.common.core.php +++ b/inc/commons/class.common.core.php @@ -327,7 +327,7 @@ class commonCore extends cubeCore // . // Table documents $db->documents->document_id('integer', 0, false); - $db->documents->region('varchar', 2, false,'"UE"'); + $db->documents->region('varchar', 2, false, '"UE"'); $db->documents->file('varchar', 256, false); $db->documents->proprietaire('integer', 0, false); $db->documents->pages('integer', 0, false); @@ -514,20 +514,12 @@ class commonCore extends cubeCore $db->bourbon_suggestions->suggestion('text', 0, false); $db->bourbon_suggestions->page('varchar', 256, false); - $db->ysl_survey->fluidbook_id('integer', 0, false); - $db->ysl_survey->page('integer', 0, false); - $db->ysl_survey->date('integer', 0, false); - $db->ysl_survey->rating('integer', 0, false); - $db->ysl_survey->rating('integer', 0, false); - $db->ysl_survey->suggestions('text', 0, false); - $db->ysl_survey->country('varchar', 64, false); - $db->ysl_survey->function('varchar', 256, false); - $db->ysl_survey->primary('pk_ysl_survey', 'date'); - $dbi = new CubeDbStruct($this->con); $dbi->synchronize($db); + $this->views->createView('ysl_survey', 'SELECT * FROM fluidbook_toolbox.ysl_survey'); + $this->views->createView('e2_u', 'SELECT id AS utilisateur_id, enabled, email, password, api_token, e1_ws_password AS ws_password, firstname AS prenom, lastname AS nom, phone AS telephone,e1_mobile AS mobile,e1_fax as fax, locale AS lang, e1_ws_settings AS ws_settings, e1_settings AS settings, e1_ws_rights AS ws_rights, e1_ws_domains AS ws_domains, e1_ws_count AS ws_count, e1_login AS login,e1_grade AS grade,e1_resetpassword AS reset_password, JSON_VALUE(address,"$.address") AS adresse, -- 2.39.5