-- 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`;