--
-- Host: localhost    Database: emergency
-- ------------------------------------------------------


--
-- Table structure for table `blog_posts`
--

CREATE TABLE `blog_posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author_id` int(11) NOT NULL,
  `title` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
  `image_url` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
  `content_brief` text COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `publish_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` enum('draft','active','hidden') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `users` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `blog_posts`
--


--
-- Table structure for table `blog_posts_users`
--

CREATE TABLE `blog_posts_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `blog_post_id` int(11) NOT NULL,
  `client_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `blog_posts_users`
--


--
-- Table structure for table `blog_themes`
--

CREATE TABLE `blog_themes` (
  `id` int(11) NOT NULL,
  `admin_id` int(11) NOT NULL,
  `title` varchar(150) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Blog',
  `background` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `logo` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `font` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `blog_themes`
--


--
-- Table structure for table `business_partners`
--

CREATE TABLE `business_partners` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `bp_id` int(11) NOT NULL,
  `building_name` varchar(255) NOT NULL,
  `street` varchar(255) NOT NULL,
  `number` int(11) NOT NULL,
  `zip` int(11) NOT NULL,
  `city` varchar(255) NOT NULL,
  `country` int(11) NOT NULL,
  `color` varchar(10) NOT NULL,
  `call_action` tinyint(1) NOT NULL DEFAULT '1',
  `enable_phones` tinyint(1) NOT NULL DEFAULT '1',
  `lang` varchar(10) NOT NULL DEFAULT 'en',
  `enable_button` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `BP_unique` (`bp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `business_partners`
--


--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `external_id` varchar(255) NOT NULL,
  `name` varchar(256) NOT NULL,
  `surname` varchar(512) NOT NULL,
  `businesspartnerid` varchar(50) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `phone_number` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `external_id` (`external_id`)
) ENGINE=InnoDB AUTO_INCREMENT=339 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` VALUES (2,'660','Luka','Hoffmann','19810206',NULL,NULL),(3,'890','Jorge','Sánchez','A12345678',NULL,NULL),(4,'936','Lea','Baumann','29762910',NULL,NULL),(5,'1258','Emma','Schulz','41374398',NULL,NULL),(6,'453','Ben','Mueller','12345678',NULL,NULL),(7,'591','Finn','Schulz','17322030',NULL,NULL),(8,'1281','Mia','Wagner','42203790',NULL,NULL),(9,'913','Lenna','Brunner','28933518',NULL,NULL),(10,'476','Louis','Schmidt','13175070',NULL,NULL),(11,'499','Paul','Schneider','14004462',NULL,NULL),(12,'568','Leon','Weber','16492638',NULL,NULL),(13,'798','Lenna','Huber','24786558',NULL,NULL),(14,'1120','Jonas','Mueller','36398046',NULL,NULL),(15,'545','Jonas','Meyer','15663246',NULL,NULL),(16,'706','Mia','Meier','21468990',NULL,NULL),(17,'1143','Leon','Schmidt','37227438',NULL,NULL),(18,'844','Emilie','Schneider','26445342',NULL,NULL),(19,'1005','Marie','Moser','32251086',NULL,NULL),(20,'729','Hannah','Schmid','22298382',NULL,NULL),(21,'752','Emilia','Keller','23127774',NULL,NULL),(22,'1166','Finn','Schneider','38056830',NULL,NULL),(23,'775','Anna','Weber','23957166',NULL,NULL),(24,'1051','Louis','Becker','33909870',NULL,NULL),(25,'1097','Lukas','Brunner','35568654',NULL,NULL),(26,'1212','Elias','Meyer','39715614',NULL,NULL),(27,'1327','Emilia','Hoffmann','43862574',NULL,NULL),(28,'1074','Paul','Hoffmann','34739262',NULL,NULL),(29,'683','Emma','Mueller','20639598',NULL,NULL),(30,'982','Sophia','Frei','31421694',NULL,NULL),(31,'1028','Ben','Wagner','33080478',NULL,NULL),(32,'1235','Luka','Weber','40545006',NULL,NULL),(33,'1350','Anna','Brunner','44691966',NULL,NULL),(35,'1189','Noah','Fischer','38886222',NULL,NULL),(36,'821','Lea','Meyer','25615950',NULL,NULL),(37,'1304','Hannah','Becker','43033182',NULL,NULL),(38,'522','Lukas','Fischer','14833854',NULL,NULL),(39,'637','Elias','Becker','18980814',NULL,NULL),(40,'614','Noah','Wagner','18151422',NULL,NULL),(42,'14','nombre','apellidos','3232121',NULL,NULL),(47,'1110000','jorge','sanchez','01222245',NULL,NULL),(55,'1039','Carlos','Fernandez','000000',NULL,NULL),(64,'896','Mickey','Mouse','9879979797',NULL,NULL),(90,'954','Test','Test','234234234',NULL,NULL),(92,'894','Test','test 2','gasfgafg',NULL,NULL),(93,'901','Samuel','Test','1111111',NULL,NULL),(99,'959','Demo User','User','0',NULL,NULL),(101,'965','testguest','testguest','testguest',NULL,NULL),(104,'955','Jorge','Sanchez','1222222',NULL,NULL),(105,'948','gasfgf','gafsgafg','fgasfgag',NULL,NULL),(107,'969','Marge','Simpson','234234234',NULL,NULL),(108,'971','gas','gagfafg','gafgagag',NULL,NULL),(111,'964','Gast','lindaufiber','0',NULL,NULL),(113,'989','LF Standard','Abo','12345679',NULL,NULL),(114,'992','Peter','Schmidt','2',NULL,NULL),(115,'993','Ehrat Test','Martin Test','-',NULL,NULL),(116,'1038','LF Standard','Abo','12345679',NULL,NULL),(117,'1021','Fam. Muster','User','000000',NULL,NULL),(118,'1999','Jorg','dd','ddd',NULL,NULL),(129,'255','5245245','5245245','00000',NULL,NULL),(145,'897','Donald','Duck','asafsafaf',NULL,NULL),(151,'968','Demo User','Limmat','123123123123',NULL,NULL),(158,'958','demo','demo','1',NULL,NULL),(159,'1054','Alex','Strupler','000000',NULL,NULL),(160,'1058','Test-Z','Test-Z','000000',NULL,NULL),(163,'1067','test.2','test2','000000',NULL,NULL),(167,'1032','Jorge','Sanchez2','lindaufiberX',NULL,NULL),(168,'1069','Lukas','Etzweiler','000000',NULL,NULL),(169,'1070','Stefan','Gübeli','000000',NULL,NULL),(176,'1041','testN','testN','564575',NULL,NULL),(179,'1047','Fam.','Muster','000000',NULL,NULL),(190,'1056','Susi','Fröhlich','000000',NULL,NULL),(191,'1045','Stadtwerk','Labor (LF Test)','000000',NULL,NULL),(193,'1062','Krishna','Mubi','000000',NULL,NULL),(195,'1061','LukasTEST230816','EtzweilerTEST230816','000000',NULL,NULL),(201,'1063','Mubi','Krishan','000000',NULL,NULL),(204,'1066','Hans SBB','Muster SBB','000000',NULL,NULL),(210,'1050','Daniel','Brüngger','000000',NULL,NULL),(214,'rrrr','rrr','rrrr','rrr',NULL,NULL),(216,'1092','xczxczc','asadasd','000000',NULL,NULL),(221,'1099','Fam. ','Muster','0',NULL,NULL),(222,'1100','Test service','service','000000',NULL,NULL),(223,'1101','Adeline','Bennett','9585215421',NULL,NULL),(224,'899','Carlos','Fernandez','01234',NULL,NULL),(227,'1065','Albert','RutkowskiTEST190816','000000',NULL,NULL),(229,'1073','Demo','digitalSTROM','000000',NULL,NULL),(238,'1134','Mubi','Krishan','0',NULL,NULL),(242,'1135','Mubi','Krishan','0',NULL,NULL),(246,'1136','Diego ','Lopez Demo','000000',NULL,NULL),(248,'1094','ArthurTEST160928','HuberTEST160928','000000',NULL,NULL),(252,'256','test','test','0',NULL,NULL),(253,'1087','Albert','Rutkowski','000000',NULL,NULL),(255,'1111','Dominic','Schranz','000000',NULL,NULL),(257,'1112','Dominic','Schranz','000000',NULL,NULL),(259,'1113','Dominic','Schranz','000000',NULL,NULL),(261,'1088','A','R','000000',NULL,NULL),(263,'1089','Gaste','lindaufiber','123456789',NULL,NULL),(264,'1090','Test','Arthur','000000',NULL,NULL),(265,'1071','Test','Arthur','000000',NULL,NULL),(266,'1142','smartsoft','Test','000000',NULL,NULL),(268,'1133','Fam. Muster','User S','000000',NULL,NULL),(269,'1149','Fam. ','Muster','000000',NULL,NULL),(271,'1146','Chuck','Norris','000000',NULL,NULL),(272,'1144','Interessent','Sentmatt','0',NULL,NULL),(276,'22225','testing','test','0',NULL,NULL),(281,'1152','Olivia','Meier','0',NULL,NULL),(288,'1176','Interessent','Vulcano','0',NULL,NULL),(295,'1177','Mubi','Krishan','1165',NULL,NULL),(306,'1240','Interessent','Grossmatte','0',NULL,NULL),(307,'1242','Lars','Leuenberger','0',NULL,NULL),(309,'1244','Interessent','BKW','0',NULL,NULL),(311,'1247','Interessent','SWP','0',NULL,NULL),(313,'1096','Albert','RutkowskiTEST171116','0',NULL,NULL),(314,'767','test','test','12345678',NULL,NULL),(315,'88','testapi','testapi','12345678',NULL,NULL),(327,'1','2','3','4','','654654654654654'),(331,'asdadadad','Test','Rechout','21213123112',NULL,NULL),(332,'66666666666','Test','Jorge','1123123',NULL,NULL),(335,'1186','asdf-development','asdf-development','1159',NULL,NULL),(338,'1224','Javis','JP2','1159',NULL,NULL);

--
-- Table structure for table `clients_categories`
--

CREATE TABLE `clients_categories` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) unsigned DEFAULT NULL,
  `cat_id` varchar(150) DEFAULT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `category_name` varchar(255) NOT NULL,
  `short_desc` text NOT NULL,
  `image` varchar(200) NOT NULL,
  `order` int(11) NOT NULL,
  `isinvoice` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `client_id` (`client_id`),
  CONSTRAINT `clients_categories_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `clients_categories` (`id`),
  CONSTRAINT `clients_categories_ibfk_2` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `clients_categories`
--


--
-- Table structure for table `clients_docs`
--

CREATE TABLE `clients_docs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `category_id` int(11) unsigned DEFAULT NULL,
  `doc_id` varchar(150) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `description` text NOT NULL,
  `last_update` date NOT NULL,
  `version` text NOT NULL,
  `issuer` varchar(50) NOT NULL,
  `image` varchar(200) NOT NULL,
  `order` int(11) NOT NULL,
  `link` varchar(200) NOT NULL,
  `doc` varchar(512) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  KEY `category_id_2` (`category_id`),
  KEY `client_id` (`client_id`),
  CONSTRAINT `clients_docs_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
  CONSTRAINT `clients_docs_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `clients_categories` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `clients_docs`
--


--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `country` varchar(255) NOT NULL,
  `code_2` varchar(2) NOT NULL,
  `code_3` varchar(3) NOT NULL,
  `number` int(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `countries`
--


--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `iso` varchar(5) NOT NULL,
  `locale` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `languages`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `version` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (11);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `place` text NOT NULL,
  `push` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `notifications_clients`
--

CREATE TABLE `notifications_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `notification_id` bigint(20) unsigned NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `push_sent` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `notification_id_2` (`notification_id`,`client_id`),
  KEY `notification_id` (`notification_id`),
  KEY `client_id` (`client_id`),
  CONSTRAINT `notifications_clients_ibfk_1` FOREIGN KEY (`notification_id`) REFERENCES `notifications` (`id`),
  CONSTRAINT `notifications_clients_ibfk_2` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `notifications_clients`
--


--
-- Table structure for table `numbers`
--

CREATE TABLE `numbers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `icon` text COLLATE utf8_unicode_ci NOT NULL,
  `number` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `document` text COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `author_id` int(11) NOT NULL,
  `users` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `numbers`
--

INSERT INTO `numbers` VALUES (2,'Ambulanz','/fbe0d8db5120868bb77bc2d22bbeea9e.png','144','/ca75acd2242a58f9d7eb1610c86b9f75.pdf',0,1,'6'),(3,'Polizei','/4f268c082ff4d27916a32725f00f9731.png','117','',2,214,'6,151,314,315'),(4,'REGA','/1d625c94aa5cf141e41ed90cbc03e03b.png','1414','',6,214,'6,151'),(6,'Feuerwehr','/e75d89c9a5cb63ed59cacafb87db0c15.png','118','',3,214,'6,151,314,315'),(7,'Strassenzustand','/1177c5dd9ef15c3109196971e3a0bdd5.png','163','',8,214,'6,151'),(8,'Vergiftungsnotfälle','/5e108388e67d52314f05093649d44d99.png','145','',5,214,'6,151,314,315'),(9,'Pannenhilfe','/5ddc40b919a9803c793b2542400498e2.png','140','',7,214,'6,151,314,315'),(10,'Internationale Notrufnummer','/d1e3c764a53dbd9aacecb7ab794c1521.png','112','',1,214,'151,314,315'),(14,'Internationaler Nortruf','/4ea6fd5dab337a670989b3d430916f7c.png','112','',0,214,'6,101'),(15,'Ambulanz','/8ebd26de6a9bcce640a059fb604fbb7c.png','144','',4,1,'101,151'),(16,'Hauspikett','/1066852b9b3ea43916261ba38f639861.png','044 448 20 80','',9,214,'6'),(17,'test','/5891d51f725ceba8a4dd8b75afff436a.jpg','43546','',0,1,'0'),(18,'Emergency Dev','/169d2a2205bc22b83ef9e20ede9c68fc.png','968968968','/fdc1b2e529dbd4d44be52eafeb0c5301.pdf',0,1,'0');

--
-- Table structure for table `numbers_users`
--

CREATE TABLE `numbers_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `number_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=307 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `numbers_users`
--

INSERT INTO `numbers_users` VALUES (41,11,6),(42,11,314),(43,11,315),(44,5,6),(45,5,314),(46,5,315),(54,12,6),(202,13,6),(205,16,6),(216,3,6),(217,3,151),(218,3,314),(219,3,315),(220,6,6),(221,6,151),(222,6,314),(223,6,315),(226,8,6),(227,8,151),(228,8,314),(229,8,315),(230,4,6),(231,4,151),(232,9,6),(233,9,151),(234,9,314),(235,9,315),(236,7,6),(237,7,151),(287,10,151),(288,10,314),(289,10,315),(298,14,6),(299,14,101),(304,2,6),(305,15,101),(306,15,151);

--
-- Table structure for table `parameters`
--

CREATE TABLE `parameters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `value` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `parameters`
--

INSERT INTO `parameters` VALUES (1,'test','testing','abc test'),(3,'msp_login','docman.livingservices','Login of the service in MSP'),(4,'msp_password','changeme','');

--
-- Table structure for table `repo_categories`
--

CREATE TABLE `repo_categories` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) unsigned DEFAULT NULL,
  `cat_id` varchar(150) DEFAULT NULL,
  `category_name` varchar(255) NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `short_desc` text NOT NULL,
  `image` varchar(200) NOT NULL,
  `order` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  CONSTRAINT `repo_categories_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `repo_categories` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `repo_categories`
--


--
-- Table structure for table `repo_docs`
--

CREATE TABLE `repo_docs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(11) unsigned DEFAULT NULL,
  `doc_id` varchar(150) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `description` text NOT NULL,
  `last_update` date NOT NULL,
  `version` text NOT NULL,
  `issuer` varchar(50) NOT NULL,
  `image` varchar(200) NOT NULL,
  `order` int(11) NOT NULL,
  `link` varchar(200) NOT NULL,
  `doc` varchar(512) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  KEY `category_id_2` (`category_id`),
  CONSTRAINT `repo_docs_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `repo_categories` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `repo_docs`
--


--
-- Table structure for table `repo_docs_clients`
--

CREATE TABLE `repo_docs_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `repo_doc_id` int(10) unsigned NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `repo_doc_id` (`repo_doc_id`),
  KEY `client_id` (`client_id`),
  CONSTRAINT `repo_docs_clients_ibfk_1` FOREIGN KEY (`repo_doc_id`) REFERENCES `repo_docs` (`id`),
  CONSTRAINT `repo_docs_clients_ibfk_2` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `repo_docs_clients`
--



