-- MariaDB dump 10.19  Distrib 10.5.21-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: hive
-- ------------------------------------------------------
-- Server version	10.5.21-MariaDB-0+deb11u1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `hive`
--

/*!40000 DROP DATABASE IF EXISTS `hive`*/;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `hive` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

USE `hive`;

--
-- Table structure for table `00_aaa`
--

DROP TABLE IF EXISTS `00_aaa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `00_aaa` (
  `message` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `00_aaa`
--

LOCK TABLES `00_aaa` WRITE;
/*!40000 ALTER TABLE `00_aaa` DISABLE KEYS */;
/*!40000 ALTER TABLE `00_aaa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `00_cdr`
--

DROP TABLE IF EXISTS `00_cdr`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `00_cdr` (
  `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `clid` varchar(80) NOT NULL DEFAULT '',
  `src` varchar(80) NOT NULL DEFAULT '',
  `dst` varchar(80) NOT NULL DEFAULT '',
  `dcontext` varchar(80) NOT NULL DEFAULT '',
  `channel` varchar(80) NOT NULL DEFAULT '',
  `dstchannel` varchar(80) NOT NULL DEFAULT '',
  `lastapp` varchar(80) NOT NULL DEFAULT '',
  `lastdata` varchar(80) NOT NULL DEFAULT '',
  `duration` int(11) NOT NULL DEFAULT 0,
  `billsec` int(11) NOT NULL DEFAULT 0,
  `disposition` varchar(45) NOT NULL DEFAULT '',
  `amaflags` int(11) NOT NULL DEFAULT 0,
  `accountcode` varchar(20) NOT NULL DEFAULT '',
  `uniqueid` varchar(32) NOT NULL DEFAULT '',
  `userfield` varchar(255) NOT NULL DEFAULT '',
  KEY `calldate` (`calldate`),
  KEY `dst` (`dst`),
  KEY `accountcode` (`accountcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `00_cdr`
--

LOCK TABLES `00_cdr` WRITE;
/*!40000 ALTER TABLE `00_cdr` DISABLE KEYS */;
/*!40000 ALTER TABLE `00_cdr` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `00_cel`
--

DROP TABLE IF EXISTS `00_cel`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `00_cel` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `eventtype` varchar(30) NOT NULL,
  `eventtime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `userdeftype` varchar(255) NOT NULL,
  `cid_name` varchar(80) NOT NULL,
  `cid_num` varchar(80) NOT NULL,
  `cid_ani` varchar(80) NOT NULL,
  `cid_rdnis` varchar(80) NOT NULL,
  `cid_dnid` varchar(80) NOT NULL,
  `exten` varchar(80) NOT NULL,
  `context` varchar(80) NOT NULL,
  `channame` varchar(80) NOT NULL,
  `appname` varchar(80) NOT NULL,
  `appdata` varchar(80) NOT NULL,
  `amaflags` int(11) NOT NULL,
  `accountcode` varchar(20) NOT NULL,
  `peeraccount` varchar(20) NOT NULL,
  `uniqueid` varchar(150) NOT NULL,
  `linkedid` varchar(150) NOT NULL,
  `userfield` varchar(255) NOT NULL,
  `peer` varchar(80) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `00_cel`
--

LOCK TABLES `00_cel` WRITE;
/*!40000 ALTER TABLE `00_cel` DISABLE KEYS */;
/*!40000 ALTER TABLE `00_cel` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `VW_collab_contact_data__all`
--

DROP TABLE IF EXISTS `VW_collab_contact_data__all`;
/*!50001 DROP VIEW IF EXISTS `VW_collab_contact_data__all`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_collab_contact_data__all` AS SELECT
 1 AS `id`,
  1 AS `lastname`,
  1 AS `firstname`,
  1 AS `username`,
  1 AS `mail`,
  1 AS `login`,
  1 AS `phone`,
  1 AS `avatar`,
  1 AS `status`,
  1 AS `type` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_collab_event_data__get`
--

DROP TABLE IF EXISTS `VW_collab_event_data__get`;
/*!50001 DROP VIEW IF EXISTS `VW_collab_event_data__get`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_collab_event_data__get` AS SELECT
 1 AS `id`,
  1 AS `user`,
  1 AS `title`,
  1 AS `begin`,
  1 AS `end`,
  1 AS `description`,
  1 AS `type`,
  1 AS `recurring`,
  1 AS `avatar`,
  1 AS `lastname`,
  1 AS `firstname`,
  1 AS `ressource_id`,
  1 AS `address` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0005_member_data__search`
--

DROP TABLE IF EXISTS `VW_job0005_member_data__search`;
/*!50001 DROP VIEW IF EXISTS `VW_job0005_member_data__search`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0005_member_data__search` AS SELECT
 1 AS `id`,
  1 AS `birth`,
  1 AS `reference`,
  1 AS `group_id`,
  1 AS `ref_group`,
  1 AS `firstname`,
  1 AS `lastname`,
  1 AS `status`,
  1 AS `create_by` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0005_request_data__download`
--

DROP TABLE IF EXISTS `VW_job0005_request_data__download`;
/*!50001 DROP VIEW IF EXISTS `VW_job0005_request_data__download`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0005_request_data__download` AS SELECT
 1 AS `id`,
  1 AS `name`,
  1 AS `type`,
  1 AS `group_id`,
  1 AS `status`,
  1 AS `ref_family`,
  1 AS `ref_type`,
  1 AS `group_name`,
  1 AS `ref_status`,
  1 AS `ref_reject`,
  1 AS `member_names`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_location`,
  1 AS `member_birth`,
  1 AS `owner_lastname`,
  1 AS `owner_firstname`,
  1 AS `owner_id`,
  1 AS `update_at`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0005_request_data__load`
--

DROP TABLE IF EXISTS `VW_job0005_request_data__load`;
/*!50001 DROP VIEW IF EXISTS `VW_job0005_request_data__load`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0005_request_data__load` AS SELECT
 1 AS `id`,
  1 AS `reference`,
  1 AS `type`,
  1 AS `status`,
  1 AS `facility`,
  1 AS `family`,
  1 AS `asked_amount`,
  1 AS `asked_payment_method`,
  1 AS `asked_comment`,
  1 AS `payment_emergency`,
  1 AS `cla1_at`,
  1 AS `cla2_at`,
  1 AS `advisor_opinion`,
  1 AS `advisor_comment`,
  1 AS `committee_id`,
  1 AS `reject`,
  1 AS `reject_comment`,
  1 AS `facility_enter`,
  1 AS `note`,
  1 AS `note_2`,
  1 AS `other`,
  1 AS `help_name`,
  1 AS `help_income`,
  1 AS `family_solidarity_amount`,
  1 AS `family_solidarity_status`,
  1 AS `update_at`,
  1 AS `ref_status`,
  1 AS `status_comment`,
  1 AS `member_id`,
  1 AS `member_cv`,
  1 AS `member_story`,
  1 AS `member_project`,
  1 AS `group_id`,
  1 AS `recommendation`,
  1 AS `ref_type`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_street_address`,
  1 AS `member_city`,
  1 AS `member_postcode`,
  1 AS `owner_id`,
  1 AS `manager_id`,
  1 AS `owner_phone`,
  1 AS `owner_mail`,
  1 AS `owner_fax`,
  1 AS `owner_lastname`,
  1 AS `manager_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_firstname`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0005_request_data__pv`
--

DROP TABLE IF EXISTS `VW_job0005_request_data__pv`;
/*!50001 DROP VIEW IF EXISTS `VW_job0005_request_data__pv`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0005_request_data__pv` AS SELECT
 1 AS `committee_id`,
  1 AS `status`,
  1 AS `id`,
  1 AS `ref_facility`,
  1 AS `family`,
  1 AS `facility`,
  1 AS `reference`,
  1 AS `member_id`,
  1 AS `member_birth`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_postcode`,
  1 AS `member_city`,
  1 AS `ref_family`,
  1 AS `ref_type`,
  1 AS `ref_status`,
  1 AS `ref_reject`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0005_request_data__search`
--

DROP TABLE IF EXISTS `VW_job0005_request_data__search`;
/*!50001 DROP VIEW IF EXISTS `VW_job0005_request_data__search`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0005_request_data__search` AS SELECT
 1 AS `allocated_amount`,
  1 AS `payed_amount`,
  1 AS `id`,
  1 AS `name`,
  1 AS `type`,
  1 AS `family`,
  1 AS `status`,
  1 AS `group_id`,
  1 AS `ref_type`,
  1 AS `ref_family`,
  1 AS `ref_status`,
  1 AS `create_at`,
  1 AS `update_at`,
  1 AS `group_name`,
  1 AS `member_id`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `owner_avatar`,
  1 AS `manager_avatar`,
  1 AS `owner_lastname`,
  1 AS `manager_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_firstname`,
  1 AS `owner_id`,
  1 AS `manager_id`,
  1 AS `committee_id`,
  1 AS `member_project` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0011_member_data__search`
--

DROP TABLE IF EXISTS `VW_job0011_member_data__search`;
/*!50001 DROP VIEW IF EXISTS `VW_job0011_member_data__search`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0011_member_data__search` AS SELECT
 1 AS `id`,
  1 AS `birth`,
  1 AS `reference`,
  1 AS `firstname`,
  1 AS `lastname`,
  1 AS `civility`,
  1 AS `status`,
  1 AS `create_by`,
  1 AS `msa`,
  1 AS `caf` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0011_request_data__download`
--

DROP TABLE IF EXISTS `VW_job0011_request_data__download`;
/*!50001 DROP VIEW IF EXISTS `VW_job0011_request_data__download`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0011_request_data__download` AS SELECT
 1 AS `id`,
  1 AS `name`,
  1 AS `type`,
  1 AS `family`,
  1 AS `group_id`,
  1 AS `status`,
  1 AS `ref_family`,
  1 AS `ref_type`,
  1 AS `group_name`,
  1 AS `ref_status`,
  1 AS `ref_reject`,
  1 AS `member_names`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_location`,
  1 AS `member_birth`,
  1 AS `owner_names`,
  1 AS `member_project`,
  1 AS `advisor_comment`,
  1 AS `asked_amount`,
  1 AS `owner_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_lastname`,
  1 AS `manager_firstname`,
  1 AS `owner_id`,
  1 AS `update_at`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0011_request_data__history`
--

DROP TABLE IF EXISTS `VW_job0011_request_data__history`;
/*!50001 DROP VIEW IF EXISTS `VW_job0011_request_data__history`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0011_request_data__history` AS SELECT
 1 AS `id`,
  1 AS `allocated_amount`,
  1 AS `payed_amount`,
  1 AS `third_party_payer`,
  1 AS `name`,
  1 AS `type`,
  1 AS `family`,
  1 AS `status`,
  1 AS `group_id`,
  1 AS `ref_type`,
  1 AS `ref_family`,
  1 AS `ref_status`,
  1 AS `create_at`,
  1 AS `update_at`,
  1 AS `group_name`,
  1 AS `member_id`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_birth`,
  1 AS `member_street_address`,
  1 AS `member_city_new`,
  1 AS `owner_avatar`,
  1 AS `manager_avatar`,
  1 AS `owner_lastname`,
  1 AS `manager_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_firstname`,
  1 AS `owner_id`,
  1 AS `manager_id`,
  1 AS `committee_id`,
  1 AS `member_project` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0011_request_data__load`
--

DROP TABLE IF EXISTS `VW_job0011_request_data__load`;
/*!50001 DROP VIEW IF EXISTS `VW_job0011_request_data__load`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0011_request_data__load` AS SELECT
 1 AS `id`,
  1 AS `reference`,
  1 AS `type`,
  1 AS `status`,
  1 AS `facility`,
  1 AS `family`,
  1 AS `asked_amount`,
  1 AS `asked_payment_method`,
  1 AS `asked_comment`,
  1 AS `payment_emergency`,
  1 AS `cla1_at`,
  1 AS `cla2_at`,
  1 AS `advisor_opinion`,
  1 AS `advisor_comment`,
  1 AS `committee_id`,
  1 AS `reject`,
  1 AS `reject_comment`,
  1 AS `facility_enter`,
  1 AS `note`,
  1 AS `note_2`,
  1 AS `other`,
  1 AS `help_name`,
  1 AS `help_income`,
  1 AS `family_solidarity_amount`,
  1 AS `family_solidarity_status`,
  1 AS `update_at`,
  1 AS `ref_status`,
  1 AS `status_comment`,
  1 AS `member_id`,
  1 AS `member_cv`,
  1 AS `member_story`,
  1 AS `member_project`,
  1 AS `group_id`,
  1 AS `recommendation`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_street_address`,
  1 AS `member_city`,
  1 AS `member_postcode`,
  1 AS `owner_id`,
  1 AS `manager_id`,
  1 AS `owner_phone`,
  1 AS `owner_mail`,
  1 AS `owner_lastname`,
  1 AS `manager_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_firstname`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0011_request_data__pv`
--

DROP TABLE IF EXISTS `VW_job0011_request_data__pv`;
/*!50001 DROP VIEW IF EXISTS `VW_job0011_request_data__pv`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0011_request_data__pv` AS SELECT
 1 AS `committee_id`,
  1 AS `status`,
  1 AS `id`,
  1 AS `ref_facility`,
  1 AS `family`,
  1 AS `facility`,
  1 AS `reference`,
  1 AS `member_id`,
  1 AS `asked_amount`,
  1 AS `member_project`,
  1 AS `advisor_comment`,
  1 AS `recommendation`,
  1 AS `ref_group`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_birth`,
  1 AS `member_postcode`,
  1 AS `member_city`,
  1 AS `ref_family`,
  1 AS `ref_type`,
  1 AS `ref_status`,
  1 AS `ref_reject`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0011_request_data__search`
--

DROP TABLE IF EXISTS `VW_job0011_request_data__search`;
/*!50001 DROP VIEW IF EXISTS `VW_job0011_request_data__search`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0011_request_data__search` AS SELECT
 1 AS `id`,
  1 AS `allocated_amount`,
  1 AS `payed_amount`,
  1 AS `third_party_payer`,
  1 AS `name`,
  1 AS `type`,
  1 AS `family`,
  1 AS `status`,
  1 AS `group_id`,
  1 AS `ref_type`,
  1 AS `ref_family`,
  1 AS `ref_status`,
  1 AS `create_at`,
  1 AS `update_at`,
  1 AS `group_name`,
  1 AS `member_id`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_birth`,
  1 AS `member_street_address`,
  1 AS `member_city`,
  1 AS `member_postcode`,
  1 AS `member_city_new`,
  1 AS `owner_avatar`,
  1 AS `manager_avatar`,
  1 AS `owner_lastname`,
  1 AS `manager_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_firstname`,
  1 AS `owner_id`,
  1 AS `manager_id`,
  1 AS `committee_id`,
  1 AS `member_project` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0011_request_data__template`
--

DROP TABLE IF EXISTS `VW_job0011_request_data__template`;
/*!50001 DROP VIEW IF EXISTS `VW_job0011_request_data__template`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0011_request_data__template` AS SELECT
 1 AS `id`,
  1 AS `name`,
  1 AS `our_reference`,
  1 AS `type`,
  1 AS `group_id`,
  1 AS `status`,
  1 AS `ref_family`,
  1 AS `ref_type`,
  1 AS `group_name`,
  1 AS `group_mail`,
  1 AS `ref_status`,
  1 AS `ref_reject`,
  1 AS `reject_description`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_location`,
  1 AS `member_birth`,
  1 AS `member_civility`,
  1 AS `owner_lastname`,
  1 AS `owner_firstname`,
  1 AS `owner_id`,
  1 AS `update_at`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0012_member_data__search`
--

DROP TABLE IF EXISTS `VW_job0012_member_data__search`;
/*!50001 DROP VIEW IF EXISTS `VW_job0012_member_data__search`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0012_member_data__search` AS SELECT
 1 AS `id`,
  1 AS `birth`,
  1 AS `reference`,
  1 AS `firstname`,
  1 AS `lastname`,
  1 AS `civility`,
  1 AS `street_address`,
  1 AS `city_new`,
  1 AS `status`,
  1 AS `create_by`,
  1 AS `msa`,
  1 AS `caf` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0012_request_data__download`
--

DROP TABLE IF EXISTS `VW_job0012_request_data__download`;
/*!50001 DROP VIEW IF EXISTS `VW_job0012_request_data__download`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0012_request_data__download` AS SELECT
 1 AS `id`,
  1 AS `name`,
  1 AS `type`,
  1 AS `family`,
  1 AS `group_id`,
  1 AS `status`,
  1 AS `ref_family`,
  1 AS `ref_type`,
  1 AS `group_name`,
  1 AS `ref_status`,
  1 AS `ref_reject`,
  1 AS `member_names`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_birth`,
  1 AS `member_street_address`,
  1 AS `member_city_new`,
  1 AS `owner_names`,
  1 AS `member_project`,
  1 AS `advisor_comment`,
  1 AS `asked_amount`,
  1 AS `owner_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_lastname`,
  1 AS `manager_firstname`,
  1 AS `owner_id`,
  1 AS `update_at`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0012_request_data__download2`
--

DROP TABLE IF EXISTS `VW_job0012_request_data__download2`;
/*!50001 DROP VIEW IF EXISTS `VW_job0012_request_data__download2`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0012_request_data__download2` AS SELECT
 1 AS `id`,
  1 AS `name`,
  1 AS `type`,
  1 AS `group_id`,
  1 AS `status`,
  1 AS `ref_family`,
  1 AS `ref_type`,
  1 AS `group_name`,
  1 AS `ref_status`,
  1 AS `ref_reject`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_location`,
  1 AS `member_birth`,
  1 AS `owner_lastname`,
  1 AS `owner_firstname`,
  1 AS `update_at`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0012_request_data__history`
--

DROP TABLE IF EXISTS `VW_job0012_request_data__history`;
/*!50001 DROP VIEW IF EXISTS `VW_job0012_request_data__history`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0012_request_data__history` AS SELECT
 1 AS `id`,
  1 AS `allocated_amount`,
  1 AS `payed_amount`,
  1 AS `third_party_payer`,
  1 AS `name`,
  1 AS `type`,
  1 AS `family`,
  1 AS `status`,
  1 AS `group_id`,
  1 AS `ref_type`,
  1 AS `ref_family`,
  1 AS `ref_status`,
  1 AS `create_at`,
  1 AS `update_at`,
  1 AS `group_name`,
  1 AS `member_id`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_civility`,
  1 AS `member_birth`,
  1 AS `member_street_address`,
  1 AS `member_city_new`,
  1 AS `owner_avatar`,
  1 AS `manager_avatar`,
  1 AS `owner_lastname`,
  1 AS `manager_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_firstname`,
  1 AS `owner_id`,
  1 AS `manager_id`,
  1 AS `committee_id`,
  1 AS `member_project` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0012_request_data__load`
--

DROP TABLE IF EXISTS `VW_job0012_request_data__load`;
/*!50001 DROP VIEW IF EXISTS `VW_job0012_request_data__load`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0012_request_data__load` AS SELECT
 1 AS `id`,
  1 AS `reference`,
  1 AS `type`,
  1 AS `status`,
  1 AS `facility`,
  1 AS `family`,
  1 AS `energy_customer`,
  1 AS `energy_contrat`,
  1 AS `energy_check`,
  1 AS `switch_1`,
  1 AS `switch_2`,
  1 AS `switch_3`,
  1 AS `switch_4`,
  1 AS `switch_5`,
  1 AS `select_1`,
  1 AS `select_2`,
  1 AS `date_1`,
  1 AS `energy_protected`,
  1 AS `asked_amount`,
  1 AS `asked_payment_method`,
  1 AS `asked_comment`,
  1 AS `payment_emergency`,
  1 AS `cla1_at`,
  1 AS `cla2_at`,
  1 AS `advisor_opinion`,
  1 AS `advisor_comment`,
  1 AS `committee_id`,
  1 AS `reject`,
  1 AS `reject_comment`,
  1 AS `facility_enter`,
  1 AS `note`,
  1 AS `note_2`,
  1 AS `note_3`,
  1 AS `document_comment`,
  1 AS `other`,
  1 AS `help_name`,
  1 AS `help_income`,
  1 AS `family_solidarity_amount`,
  1 AS `family_solidarity_status`,
  1 AS `update_at`,
  1 AS `ref_status`,
  1 AS `status_comment`,
  1 AS `member_id`,
  1 AS `member_cv`,
  1 AS `member_story`,
  1 AS `member_project`,
  1 AS `group_id`,
  1 AS `recommendation`,
  1 AS `ref_type`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_street_address`,
  1 AS `member_city`,
  1 AS `member_postcode`,
  1 AS `owner_id`,
  1 AS `manager_id`,
  1 AS `owner_phone`,
  1 AS `owner_mail`,
  1 AS `owner_lastname`,
  1 AS `manager_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_firstname`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0012_request_data__pv`
--

DROP TABLE IF EXISTS `VW_job0012_request_data__pv`;
/*!50001 DROP VIEW IF EXISTS `VW_job0012_request_data__pv`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0012_request_data__pv` AS SELECT
 1 AS `committee_id`,
  1 AS `status`,
  1 AS `id`,
  1 AS `ref_facility`,
  1 AS `family`,
  1 AS `facility`,
  1 AS `reference`,
  1 AS `member_id`,
  1 AS `member_birth`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_postcode`,
  1 AS `member_city`,
  1 AS `ref_family`,
  1 AS `ref_type`,
  1 AS `ref_status`,
  1 AS `ref_reject`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0012_request_data__pv2`
--

DROP TABLE IF EXISTS `VW_job0012_request_data__pv2`;
/*!50001 DROP VIEW IF EXISTS `VW_job0012_request_data__pv2`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0012_request_data__pv2` AS SELECT
 1 AS `committee_id`,
  1 AS `status`,
  1 AS `id`,
  1 AS `ref_facility`,
  1 AS `family`,
  1 AS `facility`,
  1 AS `reference`,
  1 AS `member_id`,
  1 AS `member_birth`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_zip`,
  1 AS `member_town`,
  1 AS `member_postcode`,
  1 AS `member_city`,
  1 AS `ref_family`,
  1 AS `ref_type`,
  1 AS `ref_status`,
  1 AS `ref_reject`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0012_request_data__search`
--

DROP TABLE IF EXISTS `VW_job0012_request_data__search`;
/*!50001 DROP VIEW IF EXISTS `VW_job0012_request_data__search`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0012_request_data__search` AS SELECT
 1 AS `id`,
  1 AS `start`,
  1 AS `allocated_amount`,
  1 AS `payed_amount`,
  1 AS `third_party_payer`,
  1 AS `name`,
  1 AS `type`,
  1 AS `family`,
  1 AS `status`,
  1 AS `group_id`,
  1 AS `ref_type`,
  1 AS `ref_family`,
  1 AS `ref_facility`,
  1 AS `ref_status`,
  1 AS `select_2`,
  1 AS `create_at`,
  1 AS `update_at`,
  1 AS `group_name`,
  1 AS `member_id`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_civility`,
  1 AS `member_birth`,
  1 AS `member_street_address`,
  1 AS `member_city_new`,
  1 AS `owner_avatar`,
  1 AS `manager_avatar`,
  1 AS `owner_lastname`,
  1 AS `manager_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_firstname`,
  1 AS `owner_id`,
  1 AS `manager_id`,
  1 AS `committee_id`,
  1 AS `member_project` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0012_request_data__template`
--

DROP TABLE IF EXISTS `VW_job0012_request_data__template`;
/*!50001 DROP VIEW IF EXISTS `VW_job0012_request_data__template`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0012_request_data__template` AS SELECT
 1 AS `id`,
  1 AS `allocated_amount`,
  1 AS `payed_amount`,
  1 AS `third_party_payer`,
  1 AS `name`,
  1 AS `type`,
  1 AS `family`,
  1 AS `status`,
  1 AS `group_id`,
  1 AS `reject_comment`,
  1 AS `reject_description`,
  1 AS `ref_reject`,
  1 AS `ref_type`,
  1 AS `ref_family`,
  1 AS `ref_status`,
  1 AS `create_at`,
  1 AS `update_at`,
  1 AS `group_name`,
  1 AS `group_mail`,
  1 AS `member_id`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_civility`,
  1 AS `member_birth`,
  1 AS `member_street_address`,
  1 AS `member_city_new`,
  1 AS `owner_avatar`,
  1 AS `manager_avatar`,
  1 AS `owner_lastname`,
  1 AS `manager_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_firstname`,
  1 AS `owner_id`,
  1 AS `manager_id`,
  1 AS `committee_id`,
  1 AS `member_project` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0013_member_data__search`
--

DROP TABLE IF EXISTS `VW_job0013_member_data__search`;
/*!50001 DROP VIEW IF EXISTS `VW_job0013_member_data__search`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0013_member_data__search` AS SELECT
 1 AS `id`,
  1 AS `birth`,
  1 AS `reference`,
  1 AS `phone`,
  1 AS `mail`,
  1 AS `login`,
  1 AS `firstname`,
  1 AS `lastname`,
  1 AS `civility`,
  1 AS `street_address`,
  1 AS `city_new`,
  1 AS `status`,
  1 AS `create_by`,
  1 AS `msa`,
  1 AS `caf`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0013_request_data__download`
--

DROP TABLE IF EXISTS `VW_job0013_request_data__download`;
/*!50001 DROP VIEW IF EXISTS `VW_job0013_request_data__download`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0013_request_data__download` AS SELECT
 1 AS `id`,
  1 AS `name`,
  1 AS `type`,
  1 AS `family`,
  1 AS `group_id`,
  1 AS `status`,
  1 AS `ref_family`,
  1 AS `ref_type`,
  1 AS `group_name`,
  1 AS `ref_status`,
  1 AS `ref_reject`,
  1 AS `member_names`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_birth`,
  1 AS `member_street_address`,
  1 AS `member_city_new`,
  1 AS `owner_names`,
  1 AS `member_project`,
  1 AS `advisor_comment`,
  1 AS `asked_amount`,
  1 AS `owner_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_lastname`,
  1 AS `manager_firstname`,
  1 AS `owner_id`,
  1 AS `update_at`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0013_request_data__download2`
--

DROP TABLE IF EXISTS `VW_job0013_request_data__download2`;
/*!50001 DROP VIEW IF EXISTS `VW_job0013_request_data__download2`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0013_request_data__download2` AS SELECT
 1 AS `id`,
  1 AS `name`,
  1 AS `type`,
  1 AS `group_id`,
  1 AS `status`,
  1 AS `ref_family`,
  1 AS `ref_type`,
  1 AS `group_name`,
  1 AS `ref_status`,
  1 AS `ref_reject`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_location`,
  1 AS `member_birth`,
  1 AS `owner_lastname`,
  1 AS `owner_firstname`,
  1 AS `update_at`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0013_request_data__history`
--

DROP TABLE IF EXISTS `VW_job0013_request_data__history`;
/*!50001 DROP VIEW IF EXISTS `VW_job0013_request_data__history`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0013_request_data__history` AS SELECT
 1 AS `id`,
  1 AS `allocated_amount`,
  1 AS `payed_amount`,
  1 AS `third_party_payer`,
  1 AS `name`,
  1 AS `type`,
  1 AS `family`,
  1 AS `status`,
  1 AS `group_id`,
  1 AS `ref_type`,
  1 AS `ref_family`,
  1 AS `ref_facility`,
  1 AS `ref_status`,
  1 AS `create_at`,
  1 AS `update_at`,
  1 AS `group_name`,
  1 AS `member_id`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_civility`,
  1 AS `member_birth`,
  1 AS `member_street_address`,
  1 AS `member_city_new`,
  1 AS `owner_avatar`,
  1 AS `manager_avatar`,
  1 AS `owner_lastname`,
  1 AS `manager_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_firstname`,
  1 AS `owner_id`,
  1 AS `manager_id`,
  1 AS `committee_id`,
  1 AS `member_project` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0013_request_data__load`
--

DROP TABLE IF EXISTS `VW_job0013_request_data__load`;
/*!50001 DROP VIEW IF EXISTS `VW_job0013_request_data__load`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0013_request_data__load` AS SELECT
 1 AS `id`,
  1 AS `reference`,
  1 AS `our_reference`,
  1 AS `family`,
  1 AS `type`,
  1 AS `group_id`,
  1 AS `owner_id`,
  1 AS `manager_id`,
  1 AS `member_id`,
  1 AS `committee_id`,
  1 AS `asked_amount`,
  1 AS `asked_payment_method`,
  1 AS `asked_to_method`,
  1 AS `asked_comment`,
  1 AS `asked_street_address`,
  1 AS `asked_city_new`,
  1 AS `asked_name`,
  1 AS `payment_emergency`,
  1 AS `cla1_at`,
  1 AS `cla2_at`,
  1 AS `chairman_control`,
  1 AS `facility`,
  1 AS `facility_enter`,
  1 AS `family_solidarity_amount`,
  1 AS `family_solidarity_status`,
  1 AS `help_name`,
  1 AS `help_income`,
  1 AS `member_cv`,
  1 AS `member_story`,
  1 AS `member_project`,
  1 AS `advisor_opinion`,
  1 AS `advisor_comment`,
  1 AS `reject`,
  1 AS `reject_comment`,
  1 AS `other`,
  1 AS `note`,
  1 AS `note_2`,
  1 AS `document_comment`,
  1 AS `recommendation`,
  1 AS `distribute`,
  1 AS `monthly`,
  1 AS `status`,
  1 AS `create_at`,
  1 AS `create_by`,
  1 AS `update_at`,
  1 AS `update_by`,
  1 AS `ref_status`,
  1 AS `status_comment`,
  1 AS `ref_type`,
  1 AS `ref_family`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_street_address`,
  1 AS `member_city_new`,
  1 AS `owner_phone`,
  1 AS `owner_mail`,
  1 AS `owner_fax`,
  1 AS `owner_lastname`,
  1 AS `manager_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_firstname` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0013_request_data__pv`
--

DROP TABLE IF EXISTS `VW_job0013_request_data__pv`;
/*!50001 DROP VIEW IF EXISTS `VW_job0013_request_data__pv`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0013_request_data__pv` AS SELECT
 1 AS `committee_id`,
  1 AS `status`,
  1 AS `id`,
  1 AS `ref_facility`,
  1 AS `family`,
  1 AS `facility`,
  1 AS `reference`,
  1 AS `member_id`,
  1 AS `ref_group`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_postcode`,
  1 AS `member_city`,
  1 AS `ref_family`,
  1 AS `ref_type`,
  1 AS `ref_status`,
  1 AS `ref_reject`,
  1 AS `create_at` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0013_request_data__search`
--

DROP TABLE IF EXISTS `VW_job0013_request_data__search`;
/*!50001 DROP VIEW IF EXISTS `VW_job0013_request_data__search`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0013_request_data__search` AS SELECT
 1 AS `id`,
  1 AS `allocated_amount`,
  1 AS `payed_amount`,
  1 AS `third_party_payer`,
  1 AS `name`,
  1 AS `type`,
  1 AS `family`,
  1 AS `status`,
  1 AS `group_id`,
  1 AS `ref_type`,
  1 AS `ref_family`,
  1 AS `ref_facility`,
  1 AS `ref_status`,
  1 AS `create_at`,
  1 AS `update_at`,
  1 AS `group_name`,
  1 AS `member_id`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_civility`,
  1 AS `member_birth`,
  1 AS `member_street_address`,
  1 AS `member_city_new`,
  1 AS `owner_avatar`,
  1 AS `manager_avatar`,
  1 AS `owner_lastname`,
  1 AS `manager_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_firstname`,
  1 AS `owner_id`,
  1 AS `manager_id`,
  1 AS `committee_id`,
  1 AS `member_project` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0013_request_data__template`
--

DROP TABLE IF EXISTS `VW_job0013_request_data__template`;
/*!50001 DROP VIEW IF EXISTS `VW_job0013_request_data__template`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `VW_job0013_request_data__template` AS SELECT
 1 AS `id`,
  1 AS `allocated_amount`,
  1 AS `payed_amount`,
  1 AS `third_party_payer`,
  1 AS `name`,
  1 AS `type`,
  1 AS `family`,
  1 AS `status`,
  1 AS `group_id`,
  1 AS `reject_comment`,
  1 AS `reject_description`,
  1 AS `ref_reject`,
  1 AS `ref_type`,
  1 AS `ref_family`,
  1 AS `ref_status`,
  1 AS `create_at`,
  1 AS `update_at`,
  1 AS `group_name`,
  1 AS `group_mail`,
  1 AS `member_id`,
  1 AS `member_lastname`,
  1 AS `member_firstname`,
  1 AS `member_civility`,
  1 AS `member_birth`,
  1 AS `member_street_address`,
  1 AS `member_city_new`,
  1 AS `owner_avatar`,
  1 AS `manager_avatar`,
  1 AS `owner_lastname`,
  1 AS `manager_lastname`,
  1 AS `owner_firstname`,
  1 AS `manager_firstname`,
  1 AS `owner_id`,
  1 AS `manager_id`,
  1 AS `committee_id`,
  1 AS `member_project` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `VW_job0014_request_data__load`
--

DROP TABLE IF EXISTS `VW_job0014_request_data__load`;
