· 4 years ago · Mar 26, 2021, 12:30 PM
1-- MySQL dump 10.18 Distrib 10.3.27-MariaDB, for debian-linux-gnu (x86_64)
2--
3-- Host: localhost Database: mobilicare_bdd
4-- ------------------------------------------------------
5-- Server version 10.3.27-MariaDB-0+deb10u1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8mb4 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `options`
20--
21
22DROP TABLE IF EXISTS `options`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `options` (
26 `id` int(12) NOT NULL AUTO_INCREMENT,
27 `transport_demand_id` int(12) NOT NULL,
28 `name` varchar(30) NOT NULL,
29 `creation_date` timestamp NOT NULL DEFAULT current_timestamp(),
30 PRIMARY KEY (`id`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Table structure for table `optionsnames`
36--
37
38DROP TABLE IF EXISTS `optionsnames`;
39/*!40101 SET @saved_cs_client = @@character_set_client */;
40/*!40101 SET character_set_client = utf8 */;
41CREATE TABLE `optionsnames` (
42 `id` int(12) NOT NULL AUTO_INCREMENT,
43 `name` varchar(120) NOT NULL,
44 `label` varchar(120) NOT NULL,
45 PRIMARY KEY (`id`)
46) ENGINE=InnoDB DEFAULT CHARSET=utf8;
47/*!40101 SET character_set_client = @saved_cs_client */;
48
49--
50-- Table structure for table `report`
51--
52
53DROP TABLE IF EXISTS `report`;
54/*!40101 SET @saved_cs_client = @@character_set_client */;
55/*!40101 SET character_set_client = utf8 */;
56CREATE TABLE `report` (
57 `id` int(12) NOT NULL AUTO_INCREMENT,
58 `user_id` int(12) NOT NULL,
59 `transport_demand_id` int(12) NOT NULL,
60 `reason_id` int(1) NOT NULL,
61 `comment` varchar(550) DEFAULT NULL,
62 `creation_date` timestamp NOT NULL DEFAULT current_timestamp(),
63 `is_resolved` int(1) DEFAULT 0,
64 PRIMARY KEY (`id`)
65) ENGINE=InnoDB DEFAULT CHARSET=utf8;
66/*!40101 SET character_set_client = @saved_cs_client */;
67
68--
69-- Table structure for table `services`
70--
71
72DROP TABLE IF EXISTS `services`;
73/*!40101 SET @saved_cs_client = @@character_set_client */;
74/*!40101 SET character_set_client = utf8 */;
75CREATE TABLE `services` (
76 `id` int(12) NOT NULL AUTO_INCREMENT,
77 `parent_id` int(12) DEFAULT NULL,
78 `email` varchar(60) NOT NULL,
79 `password` varchar(60) NOT NULL,
80 `activate` int(1) NOT NULL DEFAULT 0,
81 `service_name` varchar(150) DEFAULT NULL,
82 `etablissement_service` varchar(150) DEFAULT NULL,
83 `etablissement_type` int(11) DEFAULT NULL,
84 `phone` varchar(35) DEFAULT NULL,
85 `civility` int(11) DEFAULT NULL,
86 `name` varchar(120) DEFAULT NULL,
87 `firstname` varchar(120) DEFAULT NULL,
88 `address` varchar(450) DEFAULT NULL,
89 `postal_code` int(20) DEFAULT NULL,
90 `city` varchar(90) DEFAULT NULL,
91 `country` int(12) DEFAULT NULL,
92 `creation_date` timestamp NOT NULL DEFAULT current_timestamp(),
93 PRIMARY KEY (`id`)
94) ENGINE=InnoDB DEFAULT CHARSET=utf8;
95/*!40101 SET character_set_client = @saved_cs_client */;
96
97--
98-- Dumping data for table `services`
99--
100
101LOCK TABLES `services` WRITE;
102/*!40000 ALTER TABLE `services` DISABLE KEYS */;
103INSERT INTO `services` VALUES (1,NULL,'regulation@loudane.fr','S3N-vAy!m24',1,'Compte admin Loudane','LA SEYNE SUR MER',NULL,'',NULL,NULL,NULL,'',,'',1);
104/*!40000 ALTER TABLE `services` ENABLE KEYS */;
105UNLOCK TABLES;
106
107--
108-- Table structure for table `tokens`
109--
110
111DROP TABLE IF EXISTS `tokens`;
112/*!40101 SET @saved_cs_client = @@character_set_client */;
113/*!40101 SET character_set_client = utf8 */;
114CREATE TABLE `tokens` (
115 `id` int(12) NOT NULL AUTO_INCREMENT,
116 `type_id` int(1) NOT NULL,
117 `parent_id` int(12) NOT NULL,
118 `creation_date` timestamp NOT NULL DEFAULT current_timestamp(),
119 `validation_date` datetime NOT NULL,
120 `value` varchar(50) NOT NULL,
121 PRIMARY KEY (`id`)
122) ENGINE=InnoDB DEFAULT CHARSET=utf8;
123/*!40101 SET character_set_client = @saved_cs_client */;
124
125--
126-- Table structure for table `transportdemand`
127--
128
129DROP TABLE IF EXISTS `transportdemand`;
130/*!40101 SET @saved_cs_client = @@character_set_client */;
131/*!40101 SET character_set_client = utf8 */;
132CREATE TABLE `transportdemand` (
133 `id` int(12) NOT NULL AUTO_INCREMENT,
134 `service_id` int(12) NOT NULL,
135 `civility` int(1) NOT NULL,
136 `patient_name` varchar(60) NOT NULL,
137 `patient_firstname` varchar(60) NOT NULL,
138 `doctor` varchar(60) NOT NULL,
139 `operator` varchar(60) NOT NULL,
140 `address_from` varchar(60) NOT NULL,
141 `address_to` varchar(60) NOT NULL,
142 `transport_type` int(2) NOT NULL DEFAULT 0,
143 `transport_reason` int(2) NOT NULL DEFAULT 0,
144 `is_intern` int(1) NOT NULL DEFAULT 0,
145 `is_full_supported` int(1) NOT NULL DEFAULT 0,
146 `is_to_patient_home` int(1) NOT NULL DEFAULT 0,
147 `meeting_date` varchar(10) NOT NULL,
148 `meeting_hour` varchar(8) NOT NULL,
149 `is_immediate_transport` int(1) NOT NULL DEFAULT 0,
150 `activate` int(1) NOT NULL DEFAULT 1,
151 `status` int(1) NOT NULL DEFAULT 1,
152 `creation_date` timestamp NOT NULL DEFAULT current_timestamp(),
153 `transport_reccurence` int(1) DEFAULT 0,
154 `desease_name` varchar(550) DEFAULT NULL,
155 `meeting_date_return` varchar(10) DEFAULT NULL,
156 `meeting_hour_return` varchar(8) DEFAULT NULL,
157 PRIMARY KEY (`id`)
158) ENGINE=InnoDB DEFAULT CHARSET=utf8;
159/*!40101 SET character_set_client = @saved_cs_client */;
160
161--
162-- Table structure for table `transportdemandeproviders`
163--
164
165DROP TABLE IF EXISTS `transportdemandeproviders`;
166/*!40101 SET @saved_cs_client = @@character_set_client */;
167/*!40101 SET character_set_client = utf8 */;
168CREATE TABLE `transportdemandeproviders` (
169 `id` int(12) NOT NULL AUTO_INCREMENT,
170 `transport_demand_id` int(12) NOT NULL,
171 `provider_id` int(12) NOT NULL,
172 `creation_date` timestamp NOT NULL DEFAULT current_timestamp(),
173 PRIMARY KEY (`id`),
174 UNIQUE KEY `transport_demand_id` (`transport_demand_id`)
175) ENGINE=InnoDB DEFAULT CHARSET=utf8;
176/*!40101 SET character_set_client = @saved_cs_client */;
177
178--
179-- Table structure for table `transporters`
180--
181
182DROP TABLE IF EXISTS `transporters`;
183/*!40101 SET @saved_cs_client = @@character_set_client */;
184/*!40101 SET character_set_client = utf8 */;
185CREATE TABLE `transporters` (
186 `id` int(12) NOT NULL AUTO_INCREMENT,
187 `email` varchar(60) NOT NULL,
188 `password` varchar(60) NOT NULL,
189 `type` int(1) NOT NULL DEFAULT 1,
190 `status` int(1) NOT NULL DEFAULT 0,
191 `company_name` varchar(150) DEFAULT NULL,
192 `phone` varchar(35) DEFAULT NULL,
193 `address` varchar(450) DEFAULT NULL,
194 `postal_code` int(20) DEFAULT NULL,
195 `city` varchar(90) DEFAULT NULL,
196 `creation_date` timestamp NOT NULL DEFAULT current_timestamp(),
197 PRIMARY KEY (`id`)
198) ENGINE=InnoDB 1 DEFAULT CHARSET=utf8;
199/*!40101 SET character_set_client = @saved_cs_client */;
200
201--
202-- Table structure for table `transporters80`
203--
204
205DROP TABLE IF EXISTS `transporters80`;
206/*!40101 SET @saved_cs_client = @@character_set_client */;
207/*!40101 SET character_set_client = utf8 */;
208CREATE TABLE `transporters80` (
209 `id` int(12) NOT NULL AUTO_INCREMENT,
210 `agreement` varchar(50) NOT NULL,
211 `transporter_id` int(11) NOT NULL,
212 `creation_date` timestamp NOT NULL DEFAULT current_timestamp(),
213 PRIMARY KEY (`id`)
214) ENGINE=InnoDB DEFAULT CHARSET=utf8;
215/*!40101 SET character_set_client = @saved_cs_client */;
216
217--
218-- Table structure for table `transportersintern`
219--
220
221DROP TABLE IF EXISTS `transportersintern`;
222/*!40101 SET @saved_cs_client = @@character_set_client */;
223/*!40101 SET character_set_client = utf8 */;
224CREATE TABLE `transportersintern` (
225 `id` int(12) NOT NULL AUTO_INCREMENT,
226 `agreement` varchar(50) NOT NULL,
227 `transporter_id` int(11) NOT NULL,
228 `creation_date` timestamp NOT NULL DEFAULT current_timestamp(),
229 PRIMARY KEY (`id`)
230) ENGINE=InnoDB DEFAULT CHARSET=utf8;
231/*!40101 SET character_set_client = @saved_cs_client */;
232
233/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
234
235/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
236/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
237/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
238/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
239/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
240/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
241/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
242
243-- Dump completed on 2021-03-26 13:14:05