--
-- Host: localhost    Database: news
-- ------------------------------------------------------


--
-- 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,
  `color_title` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '000000',
  `image_url` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
  `image_url2` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
  `image_url3` 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,
  `end_date` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `status` enum('draft','active','hidden') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `users` text COLLATE utf8_unicode_ci NOT NULL,
  `push` tinyint(1) NOT NULL DEFAULT '0',
  `creation_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=379 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `blog_posts` VALUES (1,202,'test333','000000','/3ac0f2d23d0c9301971c4bd60964d356.jpg','','','<p>In a&nbsp;<a href=\"http://theinterviewguys.com/objective-for-resume/\" target=\"_blank\">previous article we tackled Resume Objectives</a>&nbsp;and what they are and who should use them (head over to take a look and see if this is the best choice for you).</p>\n\n<p>Generally speaking,&nbsp;<strong>people who were just entering the work force, perhaps lacked experience in their fields, or were in the middle of a massive career change benefited most by using an objective statement</strong>.</p>\n','<h2>Understanding the Resume Summary Statement</h2>\n\n<p>So what exactly is a resume summary statement?</p>\n\n<p>A resume summary statement is similar to an objective statement in that it is a quick way for a job seeker to catch a hiring manager&rsquo;s attention by summarizing critical information at the top of your resume in an easy to read format.</p>\n\n<p><strong><em>Before we go any further, I want to stop you right now. A &ldquo;<a href=\"http://theinterviewguys.com/objective-for-resume/\" target=\"_blank\">Resume Objective</a>&rdquo; and &ldquo;Resume Summary Statement&rdquo; are NOT interchangeable. They are, in fact, two very different things and should&nbsp;not&nbsp;be confused.</em></strong></p>\n\n<p>Resume statements essentially are just<strong>&nbsp;a few short</strong>,&nbsp;<strong>well worded</strong>,&nbsp;<strong>well targeted sentences that summarize your skills and experiences</strong>.</p>\n\n<p>Sometimes called &ldquo;Qualification Summaries&rdquo; or even just &ldquo;Competencies,&rdquo; these two or three sentences can, when done right, give you a real advantage in the hiring game.</p>\n\n<p><strong><em>I don&rsquo;t get it. I&rsquo;m already qualified to do the job. What&rsquo;s the point? Can&rsquo;t they just read my resume and get that information themselves?</em></strong></p>\n\n<p>Absolutely.But remember, hiring managers are often going through dozens, if not hundreds of resumes per available job, so anything that can make their job easier is a good thing.</p>\n','2016-12-07 13:27:56','0000-00-00 00:00:00','active','2',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,213,'test5','','/de55f2759b5540e1e928087e39d289b2.jpg','','','<p>test</p>\n','<p>test</p>\n','2016-12-15 09:26:37','0000-00-00 00:00:00','draft','202',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,213,'test6','','/213d69374a23f098398cf9ecf14b08cf.jpg','','','<p>test</p>\n','<p>test</p>\n','2016-12-15 09:27:40','0000-00-00 00:00:00','draft','2,202',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(6,0,'test8','','/a2cd4052b89e19d473ac2695ede05bca.jpg','','','<p>test</p>\n','<p>test</p>\n','2016-12-15 09:39:09','0000-00-00 00:00:00','active','2',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(7,213,'test9','','/ee56a6b1096a8d865e11e938325ff344.jpg','','','<p>test</p>\n','<p>test</p>\n','2016-12-15 09:48:54','0000-00-00 00:00:00','active','2',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(8,1,'test10','','/e0f87a107be1a5c2a8662e080e3be010.jpg','','','<p>test</p>\n','<p>test</p>\n','2016-12-16 09:22:41','0000-00-00 00:00:00','draft','145,159',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,202,'test manager','FFEE4D','/1c00b079e679a3912bf43f82976d2ec8.jpg','','','<p>test</p>\n','<p>test</p>\n','2016-12-16 15:00:00','0000-00-00 00:00:00','draft','0',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(335,214,'test','FF0808','','','','<p>test</p>\n','','2016-12-30 19:00:00','0000-00-00 00:00:00','active','2',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(336,214,'Hier steht ein Titel','FFFFFF','/ff2da9a4b8d351ae3c520562c17e254a.jpg','','','<p>text</p>\n','','2017-01-03 16:55:00','0000-00-00 00:00:00','active','0',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(337,214,'Täter richtet sich selbst – Polizist kämpft um sein Leben','118929','/d94e306924bd7625cd78c9a313766b11.jpg','/8df4820edc933873818c276caf4ddfd8.jpg','','<p>Der Mann, der im Ausserhodischen zwei Polizisten anschoss, ist tot. Einer der Verletzten schwebt in Lebensgefahr.</p>\n','<p><strong>Die Schiesserei:</strong>&nbsp;Am Morgen kurz nach 9 Uhr kam es in Rehetobel im Kanton Appenzell Ausserrhoden zu einer Schiesserei. Bei einer Hausdurchsuchung wegen des Verdachts auf eine Indoor-Hanfanlage hatte sich der Verd&auml;chtige zun&auml;chst kooperativ gezeigt. Als die Polizisten mit dem 33-J&auml;hrigen darauf dessen rund einen Kilometer von seinem Wohnhaus gelegenen Schopf aufsuchten, gelangte er dort an eine Waffe und schoss auf die Beamten. Ein Polizist erlitt einen Herzsteckschuss und k&auml;mpft derzeit um sein Leben. Der zweite verletzte Polizist erlitt Beinverletzungen. Anschliessend gelang dem T&auml;ter die Flucht.</p>\n','2017-01-04 13:56:00','2017-03-23 06:00:00','active','2',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(338,214,'Test Philippe','','/ac35912f91acb85740bda0134e59d26d.jpeg','','','<p>safasfaf</p>\n','<p>afsaf</p>\n','0000-00-00 00:00:00','0000-00-00 00:00:00','draft','0',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(340,214,'zczxc','','','','','<p>zczc</p>\n','<p>zxczxc</p>\n','0000-00-00 00:00:00','0000-00-00 00:00:00','draft','0',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(343,214,'Was auch immer?','FFFFFF','/p>','','','<p>Eine weitere Meldung &uuml;ber das gleiche Thema.</p>\n','','0000-00-00 00:00:00','0000-00-00 00:00:00','draft','6',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(345,202,'Apero ','000000','/5def73fae5592f3393f83eef374278f2.png','','','<p>Hello team!</p>\n','','2017-10-03 22:00:00','2017-10-03 22:00:00','active','193,201,238,242,295,333',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(347,226,'Digital Real Estate Summit','000000','/baf1c49328c28a58fa1ec36ccc0e833c.png','','','<p><strong>Dienstag, 28. Februar 2017, 11.30 &ndash; 18.30 h,&nbsp;</strong><br />\n<strong>Campussaal, Fachhochschule Nordwestschweiz, Brugg-Windisch</strong></p>\n\n<p>Eine Veranstaltung von Digital Real Estate by pom+</p>\n','<h3>REAL ESTATE WIRD DIGITAL</h3>\n\n<p>Unsere Welt wird digital.<strong>&nbsp;</strong>&Uuml;berall und immer schneller. Ob Wirtschaft, Politik oder Freizeit &ndash; wir m&uuml;ssen auf den digitalen Zug aufspringen, um erfolgreich zu bleiben. Auch die Immobilienwirtschaft ist in hohem Masse gefordert. Als Querschnittsbranche entlang dem Lebenszyklus von Immobilien muss sie die Potenziale der Digitalisierung nutzen und langfristige Strategien entwickeln. Digital Real Estate ist der Schl&uuml;ssel zu dieser Welt. pom+ hat die Instrumente, um die T&uuml;ren dorthin weit zu &ouml;ffnen.</p>\n','2017-02-21 21:00:00','0000-00-00 00:00:00','active','151',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(349,226,'Besichtigungen Limmat Terrassen','000000','/c7d39a1e394c5cf041d1ea96ef2a241a.jpg','/d52f700d1dbb2cf3641629050c2f10df.jpg','/5a8628a061f70258c5115318d80d386b.jpg','<p>Die Besichtigungstermine f&uuml;r die Limmat Terrassen stehen fest: Kommen sie vorbei und lassen sie sich &uuml;berraschen!</p>\n','<p>Gerne zeigen wir ihnen die neuen Wohnungen an den folgenden Daten:</p>\n\n<p>&nbsp;</p>\n\n<p><strong>Montag, 6.3.2017, von 18 - 20 Uhr</strong></p>\n\n<p><strong>Mittwoch, 8.3.2017, von 17 - 19 Uhr</strong></p>\n\n<p>&nbsp;</p>\n\n<p>Kommen sie f&uuml;r eine unverbindliche Wohnungsbesichtigung vorbei und entdecken sie ihr neues Zuhause!</p>\n\n<p>Die Besichtigungen ben&ouml;tigen keine Voranmeldung.</p>\n\n<p>Freundliche Gr&uuml;sse,</p>\n\n<p>ihre Verwaltung der Limmat Terrassen</p>\n','2017-02-22 15:00:00','0000-00-00 00:00:00','active','151',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(351,233,'Das schönste Fest, dass Zürich je gesehen hat','FF6617','/07a7b17d89fd7e3e8d913053f11d9682.jpg','','','<p>Noch nie hat Z&uuml;rich ein soo sch&ouml;nes Fest gesehen, wie die Pr&auml;sentation des neuen Bahnhofs Liestal. Als Partnerstadt fand in der Europaalle diese Woche die Pr&auml;sentation des neuen Bahnhofes statt.</p>\n\n<p>Lesen Sie mehr dazu hier.</p>\n\n<p><a href=\"https://www.sbb.ch/sbb-konzern/medien/medienmitteilungen.newsdetail.2015-11-0611_1.html\">https://www.sbb.ch/sbb-konzern/medien/medienmitteilungen.newsdetail.2015-11-0611_1.html</a></p>\n','<p>Unterschied zwischen Inhaltsbeschriebnung und Inhalt?</p>\n\n<p>&quot;Noch nie hat Z&uuml;rich ein soo sch&ouml;nes Fest gesehen, wie die Pr&auml;sentation des neuen Bahnhofs Liestal. Als Partnerstadt fand in der Europaalle diese Woche die Pr&auml;sentation des neuen Bahnhofes statt.</p>\n\n<p>Lesen Sie mehr dazu hier.&quot;&nbsp;</p>\n\n<p>&nbsp;</p>\n','0000-00-00 00:00:00','0000-00-00 00:00:00','active','314,315',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(352,202,'Nice bike','49FF3D','/8eec22ad1bcc91aa1dba9c30108a46dc.png','/3027667e7bd33188297dd206be2b338f.png','/4611b82be09adf36bd403bc9dd84a8ab.png','<p>I want to ride my bicycle</p>\n','<p>Bicycle bicycle bicycle<br />\nI want to ride my bicycle bicycle bicycle<br />\nI want to ride my bicycle<br />\nI want to ride my bike<br />\nI want to ride my bicycle<br />\nI want to ride it where I like</p>\n\n<p>You say black I say white<br />\nYou say bark I say bite<br />\nYou say shark I say hey man<br />\nJaws was never my scene<br />\nAnd I don&#39;t like Star Wars</p>\n\n<p>You say Rolls I say Royce<br />\nYou say God give me a choice<br />\nYou say Lord I say Christ<br />\nI don&#39;t believe in Peter Pan<br />\nFrankenstein or Superman<br />\nAll I wanna do is</p>\n\n<p>Bicycle bicycle bicycle<br />\nI want to ride my bicycle bicycle bicycle<br />\nI want to ride my bicycle<br />\nI want to ride my bike<br />\nI want to ride my bicycle<br />\nI want to ride my bicycle races are coming your way</p>\n\n<p>So forget all your duties oh yeah<br />\nFat bottomed girls they&#39;ll be riding today<br />\nSo look out for those beauties oh yeah</p>\n\n<p>On your&hellip;</p>\n','2017-03-15 21:05:00','2017-03-16 16:00:00','active','2',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(353,202,'An awesome blog','FF43F8','/bd7014531dc7d57b33164c8c9a81fee4.jpg','','','<p>Nice picture</p>\n\n<p>Read this: <a href=\"http://scilogs.spektrum.de/klimalounge/rekordjahr-2016-die-wichtigsten-daten-und-grafiken-die-jeder-kennen-sollte/\">Review of climate 2016</a></p>\n','<p>Das Jahr 2016 war global das w&auml;rmste Jahr seit Beginn der Aufzeichnungen im 19. Jahrhundert. Darin stimmen s&auml;mtliche Datens&auml;tze der Oberfl&auml;chentemperaturen &uuml;berein. Das gilt &uuml;brigens ebenso in allen Satellitendaten f&uuml;r die Temperaturen der Troposph&auml;re. Die globale Erw&auml;rmung schreitet also immer weiter voran &ndash; wer sich Hoffnungen auf eine Verlangsamung gemacht hat, ist Wunschdenken erlegen. Drei Rekordjahre in Folge (2014, 2015 und 2016) hat es noch nie gegeben.&nbsp; Laut NASA hat unser Planet 16 seiner 17 w&auml;rmsten Jahre seit 2001 erlebt. (Die einzige Ausnahme unter den Top 17 ist 1998 &ndash; der bislang gr&ouml;&szlig;te kurzfristige Ausrei&szlig;er dank eines Rekord-El-Ni&ntilde;o im tropischen Pazifik.) Auch 2016 hat durch El Ni&ntilde;o einen zus&auml;tzlichen Push nach oben bekommen &ndash; nach verschiedenen Absch&auml;tzungen zwischen 0,12 &deg;C und 0,17 &deg;C. Der allergr&ouml;&szlig;te Teil der W&auml;rmeanomalie ist also eine Folge des vom Menschen verursachten langfristigen Erw&auml;rmungstrends. Auch ohne El Ni&ntilde;o h&auml;tten 2015 und 2016 Rekorde gesetzt.</p>\n','2017-08-24 22:00:00','2017-08-25 22:00:00','active','2,6',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(358,202,'Testing publishing and ending date','595959','/46774c76c702ec2bf93f7cfc96245863.jpg','','','<p>See me from 11.40 until 13.30 on the 14.3.17.</p>\n','<p>See me from 11.40 until 13.30 on the 14.3.17.</p>\n\n<p>&nbsp;</p>\n\n<p>PLEASE WORK THIS TIME!</p>\n','2017-03-14 15:40:00','2017-03-14 17:30:00','active','2',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(359,214,'testing without specifying publishing and ending date','00FF00','','','','<p>you can read me because the author didn&#39;t specify a publishing/ending date</p>\n','','0000-00-00 00:00:00','0000-00-00 00:00:00','active','2',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(360,1,'WS today','FFFFFF','/a79532cceecb5ed18806e0ddf6e51d29.jpg','','','<p>Preview</p>\n','<p>read more</p>\n','0000-00-00 00:00:00','0000-00-00 00:00:00','active','2,3,4,17,101,314,315',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(361,1,'sdadsa','000000','/23f9c5e492db4157943ade0a952aafc7.jpg','','','<p>sadad<img alt=\"\" height=\"1200\" src=\"/ckfinder/userfiles/images/fun-649463.jpg\" width=\"1358\" /></p>\n','<p>sadasd</p>\n','0000-00-00 00:00:00','0000-00-00 00:00:00','draft','0',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(362,214,'Einladung zum Quartierfest','000000','/904c71e13e11b8527d567e01472f895f.jpg','','','<p>Einladung zum ersten Quartierfest auf dem Limmat-Areal</p>\n','<p>Herzliche Einladung zum ersten Quartierfest auf dem Limmat-Areal!</p>\n\n<p>Der Abend bietet neben Speis &amp; Trank die Gelegenheit, das im Entstehen begriffene neue St&uuml;ck Limmatstadt und seine Akteurinnen und Akteure kennenzulernen.<br />\nAb 19 Uhr werden sich Betriebe, Institutionen und Initiativen vom Limmat-Areal und aus den Gemeinden Schlieren, Dietikon und Glanzenberg in Kurzpr&auml;sentationen vorstellen.<br />\nF&uuml;rs leibliche Wohl sorgt das Hiltl Catering.</p>\n\n<p>Bis am Freitag!</p>\n\n<p>&nbsp;</p>\n','2017-10-08 22:00:00','2017-12-29 23:00:00','active','10,334',0,'0000-00-00 00:00:00','2017-10-09 12:52:50'),(363,1,'erewterwt','000000','/ccb97ec49c7dcd92bd861eb0694239a8.png','','','<p>erwtr</p>\n','<p>etret</p>\n','2017-03-23 14:53:00','2017-03-23 14:54:00','draft','4,7,11',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(366,214,'Super News','000000','','','','<p>Krass aber wahr ...</p>\n','<p>... der G&uuml;nther ist da.</p>\n','0000-00-00 00:00:00','0000-00-00 00:00:00','active','248',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(367,214,'Jingle Bells','000000','','','','<p>Jingle Bells</p>\n','<p>Jingle Bells</p>\n','0000-00-00 00:00:00','0000-00-00 00:00:00','active','248',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(368,1,'test','000000','/88758617c3653d024a4a8e683e4cd0e3.jpg','','','<p>test</p>\n','<p>test</p>\n','2017-04-10 15:15:53','2025-01-01 05:00:00','draft','11',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(369,1,'test','000000','/69db894d2eb721e1f0ffa00ba1e7b815.jpg','','','<p>test</p>\n','<p>test</p>\n','2017-04-10 15:16:50','2025-01-01 05:00:00','draft','8,12',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(370,202,'Let me see...','000000','/b48f5b29cfb00717bc26934a3b95927d.png','/73a5a9adf2d975417981206b4ed89a55.png','','<p>this is a test to see if I can delete images and if publishing date works..!</p>\n','<p>please work! Where do my bad feelings come from?!?</p>\n','2017-04-11 07:05:00','2017-04-11 08:00:00','active','2',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(371,1,'testing','000000','/3293ad2b878075f6c252be9fddcb52fe.jpg','','','<p>xxczxc</p>\n','<p>czxc</p>\n','2017-04-10 08:52:10','2017-04-11 09:30:00','active','2,6,90,92,101,163,176,252,276,314,315',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(372,234,'Willkommen im Sentmatt','118896','/96aedd8f80e6343688f03202a3874b51.jpg','','','<p>Endlich ist es soweit ...</p>\n','<p>... das Halter Team w&uuml;nscht Ihnen einen guten Start in Ihrem neuen Heim.</p>\n','2017-04-12 06:09:04','0000-00-00 00:00:00','active','19',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(373,1,'sdasda','000000','','','','<p>asdasd</p>\n','<p>asdasd</p>\n','2017-04-13 08:38:21','0000-00-00 00:00:00','draft','0',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(374,202,'Test publication date','000000','/9277e5da667a3fbadb276998c393cc15.PNG','','','<p>read me from 13.35 until 14.20</p>\n\n<p>13.4.2017</p>\n','','2017-04-13 11:35:00','2017-04-13 12:20:00','active','2',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(375,233,'a new day','000000','/f765c6707e91487b279e12617c94f074.png','','','<p>test</p>\n','<p>test</p>\n','2017-11-13 23:00:00','2017-11-13 23:00:00','active','4,7,10',1,'0000-00-00 00:00:00','2017-11-14 12:48:36'),(376,236,'Willkommen im Sentmatt','118896','/127350ca93e32024d3697e8e16fe4297.jpg','','','<p>Endlich ist es soweit ...</p>\n','<p>... das Halter Team w&uuml;nscht Ihnen einen guten Start in Ihrem neuen Heim.</p>\n','2017-04-19 13:42:12','0000-00-00 00:00:00','active','19',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(377,202,'saSasaS','000000','','','','<p>AsaS</p>\n','<p>asas</p>\n','2017-10-04 08:43:46','0000-00-00 00:00:00','active','333',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(378,1,'jghfgffghd','000000','','','','<p>gdfsgfds</p>\n','<p>gdsfgfdfs</p>\n','2017-12-11 23:00:00','2017-12-30 23:00:00','draft','0',0,'2017-12-13 08:56:44','2017-12-13 08:57:08');

--
-- 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 AUTO_INCREMENT=1112 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `blog_posts_users` VALUES (7,333,2),(12,4,202),(13,5,2),(14,5,202),(15,6,2),(16,7,2),(21,2,1),(22,8,145),(23,8,159),(375,10,2),(737,339,6),(740,343,6),(743,344,2),(760,347,151),(896,348,151),(899,350,2),(903,349,151),(904,334,6),(905,11,6),(906,11,314),(907,11,315),(919,354,2),(921,355,2),(922,337,2),(924,356,6),(925,357,6),(927,358,2),(935,352,2),(942,365,2),(943,366,248),(945,367,248),(949,363,4),(950,363,7),(951,363,11),(958,368,11),(959,369,8),(960,369,12),(962,370,2),(968,335,2),(971,359,2),(1020,371,2),(1021,371,6),(1022,371,90),(1023,371,92),(1024,371,101),(1025,371,163),(1026,371,176),(1027,371,252),(1028,371,276),(1029,371,314),(1030,371,315),(1031,372,19),(1036,374,2),(1040,376,19),(1047,360,2),(1048,360,3),(1049,360,4),(1050,360,17),(1051,360,101),(1052,360,314),(1053,360,315),(1068,1,2),(1081,351,314),(1082,351,315),(1096,353,2),(1097,353,6),(1098,345,193),(1099,345,201),(1100,345,238),(1101,345,242),(1102,345,295),(1103,345,333),(1104,377,333),(1107,362,10),(1108,362,334),(1109,375,4),(1110,375,7),(1111,375,10);

--
-- 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',
  `color_title` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '000000',
  `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`
--

INSERT INTO `blog_themes` VALUES (1,1,'Blog Creatingweb','','F2F2F2','/6cded0697c47c135370d7e3c01cd1cbc.png','Libre Baskerville'),(2,208,'Neuigkeiten','000000','FFFFFF','','Libre Baskerville'),(3,8,'Blog','','','',''),(8,8,'Blog','','','',''),(202,202,'News','000000','FFFFFF','','Dosis'),(206,206,'Blog','','','',''),(208,208,'Blog','FFFFFF','FFFFFF','/e8220df5a714db4eb38e08bfa630582f.png','Arial'),(212,212,'Blog','','','',''),(213,213,'Vulcano News','000000','FFFFFF','/1df771a28fd1a07b88ed5061d736d243.jpg','Arial'),(215,215,'Blog','000000','000000','/cba172eea3303e2e6a5e686a2dd10b18.jpg','Arial'),(229,229,'Blog','','','',''),(230,230,'Blog','','','',''),(232,232,'creatingweb','','','',''),(233,233,'','FFFFFF','FFFFFF','','Libre Baskerville'),(234,234,'','000000','FFFFFF','','Arial'),(235,235,'BKW','000000','','',''),(236,236,'Halter AG','000000','','',''),(237,237,'test1','000000','','','');

--
-- 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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `external_id` (`external_id`)
) ENGINE=InnoDB AUTO_INCREMENT=342 DEFAULT CHARSET=utf8;

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

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

--
-- 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`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

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

INSERT INTO `clients_categories` VALUES (6,NULL,NULL,40,NULL,'Test','jsdlñasldfañs fñkañfs ñas ñfkañ fkñ asf','/1ff6e2b84bedbf9996f3730592ab90a3.png',0,0,NULL,NULL),(7,NULL,NULL,40,NULL,'dsfsfsd','sefsdfsdfsf','werwr',0,0,NULL,NULL),(8,NULL,NULL,3,NULL,'Personal Manuals','','/13d55ee80c426279b9c890f8529928fc.jpeg',0,0,NULL,NULL),(9,NULL,NULL,3,NULL,'Contracts','','/48abc549d364d1e551096dd721906777.jpg',0,0,NULL,NULL),(10,NULL,NULL,64,NULL,'Vertrag','','/bfb86b0182c172735f0c8e10d436c80d.jpg',0,0,NULL,NULL),(12,NULL,NULL,113,NULL,'Vertrag','','/b29f74b03d0527cf44bc6f590a980f53.jpg',0,0,NULL,NULL),(14,NULL,NULL,113,NULL,'Rechnung','','/df6592b3de829b149f73789bab1c431c.jpg',0,0,NULL,NULL),(15,NULL,NULL,64,NULL,'Rechnung','','/fb207032d345ad3bfdfd4c4c2659d960.jpg',0,0,NULL,NULL),(18,NULL,NULL,151,NULL,'Vertrag','','/8b58c047314263e787c945302feff5f1.jpg',0,0,NULL,NULL),(19,NULL,NULL,117,NULL,'Vertrag','','/48da8b10d0cc9cd378ce7c01525b372c.jpg',0,0,NULL,NULL),(20,NULL,NULL,179,NULL,'Vertrag','','/aed7a6b7f8abafc064b5b83564498b2c.jpg',0,0,NULL,NULL),(22,NULL,NULL,248,NULL,'Baufeld H','','/d8e47a9150a371560e36d777b0f6f43c.png',0,0,NULL,NULL),(26,NULL,NULL,261,NULL,'Invoice','','',0,1,NULL,NULL),(30,NULL,NULL,167,NULL,'Invoice','','',0,1,NULL,NULL),(33,NULL,NULL,214,NULL,'Invoice','','',0,1,NULL,NULL),(34,NULL,NULL,31,NULL,'Invoice','','',0,1,NULL,NULL),(36,NULL,NULL,272,NULL,'Sentmatt','','/f7e2b7988b440a77b2a0f5f13d19b4bb.png',0,0,NULL,NULL),(37,NULL,NULL,306,NULL,'Sentmatt','','/512f7a7ca7817013f0bb837119ca5985.png',0,0,NULL,NULL);

--
-- 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`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8;

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

INSERT INTO `clients_docs` VALUES (3,40,6,NULL,'zxczxc',NULL,'zxczxc','0000-00-00','q2','sadasd','/ce1da160cdd7ca29a549b5745475f473.png',0,'zxzcx','/6d47b52e95343045b247c40a9b724c00.pdf',NULL,NULL),(5,3,8,NULL,'Oven Siemens',NULL,'','0000-00-00','','','/fbbc88cdc302a873a42602598b5f374e.png',0,'','/4b3f4f3bd58f0c0c76c7eeaaba47767e.pdf',NULL,NULL),(6,3,9,NULL,'Contract',NULL,'','0000-00-00','','','/dad0eca21ea2f165e725517f73e21411.jpg',0,'','/d0403f7de3b275b4cbc4a1607e990501.pdf',NULL,NULL),(7,64,10,NULL,'Prof. Contract',NULL,'','0000-00-00','','','/3f8cb4ff60b2604592d1348d036ba919.jpg',0,'','/f3538b8d5c402a930afd74a5970d8631.pdf',NULL,NULL),(10,113,12,NULL,'Servicevertrag',NULL,'','0000-00-00','','','/8db29b338d583f8a0c90ea19c5d028d1.jpg',0,'','/fd470efe4a27289c39b837f9b4744c0a.pdf',NULL,NULL),(12,113,14,NULL,'Dezember 2015',NULL,'','0000-00-00','','','/7a6fd2711589d82764cc2b4541125180.png',0,'','/361e90b014b64a0023059b3bddb525e4.pdf',NULL,NULL),(13,64,15,NULL,'Dezember 2015',NULL,'','0000-00-00','','','/ec513f2957914e5850b5efe718200818.png',0,'','/2583c10ab360c570953ae40a0c2c27a4.pdf',NULL,NULL),(16,47,NULL,NULL,'prueba',NULL,'','0000-00-00','','','/820db231bd63ffd216c09e89fd97afed.png',0,'','/0a2e23320e8779b003833020ddeee7fb.pdf',NULL,NULL),(18,3,NULL,NULL,'gggg',NULL,'','0000-00-00','','','/a46589931c1b59b6acf0b9292853f898.png',0,'','/3eddb1fc9bb088778f91e6369ce7a1ba.png',NULL,NULL),(20,151,18,NULL,'Servicevertrag',NULL,'','0000-00-00','','','/55623a0cf172b1edd5e2cd1a66e90561.jpg',0,'','/73ede2f5cd43f096134a2fd93d87bb32.pdf',NULL,NULL),(21,117,19,NULL,'Servicevertrag',NULL,'','0000-00-00','','','/ab6c7566c2182bb5f975eced4ddadc28.jpg',0,'','/8ae8b7de073adb0621ebb0abf861490f.pdf',NULL,NULL),(22,179,20,NULL,'Servicevertrag',NULL,'','0000-00-00','','','/247075e274fc859b241da1be6faa82fd.jpg',0,'','/03eac8126d211fa6b1c8c06c3b0b3667.pdf',NULL,NULL),(24,248,22,NULL,'Projektbeschrieb Haus H',NULL,'Wohnungspläne','0000-00-00','','','/d17e5ef084c87b52382f920a6195be29.png',0,'','/0649e499352abd95fad13b78b1898003.pdf',NULL,NULL),(25,248,22,NULL,'Kurzbaubeschrieb',NULL,'','0000-00-00','','','/b95f6f1eb637c9de87df4ffaeaa65a75.png',0,'','/d5ccc39fa36d191810db8e42a380c75a.pdf',NULL,NULL),(26,248,22,NULL,'Wohnungstyp B',NULL,'','0000-00-00','','','/492be6a7da098857eb5b52d4328080bf.png',0,'','/4c3b2a7c92b885fb54da3334973f852e.pdf',NULL,NULL),(27,248,22,NULL,'Wohnungstyp H',NULL,'','0000-00-00','','','/c965231a32c70ffc5a50180df370c6f8.png',0,'','/545dab4c025221a0033fc5a1cc8483b2.pdf',NULL,NULL),(28,248,22,NULL,'Factsheet Baufeld H',NULL,'','0000-00-00','','','/e09e7584a3eceaa4d88c753fca5c1a07.png',0,'','/acb23ae58cf213c0016a973611200f72.pdf',NULL,NULL),(50,261,26,NULL,'invoice10-15-2016-055517',NULL,'','0000-00-00','','','',0,'','/ddf6e515a5831285623c5bb2ede052ee.pdf',NULL,NULL),(51,261,26,NULL,'invoice10-15-2016-061207',NULL,'','0000-00-00','','','',0,'','/e78650a7de719b3119cc5700e7e21458.pdf',NULL,NULL),(52,261,26,NULL,'invoice10-17-2016-010105',NULL,'','0000-00-00','','','',0,'','/cbf402ec1b618201b4807d37938d47bd.pdf',NULL,NULL),(54,167,30,NULL,'invoice10-18-2016-024033',NULL,'','0000-00-00','','','',0,'','/1a3eac53fb674c80bf46f3e48281ece1.png',NULL,NULL),(59,214,33,NULL,'invoice10-18-2016-063923',NULL,'','0000-00-00','','','',0,'','/a07889affe1c1840fd595d0b00653623.pdf',NULL,NULL),(60,214,33,NULL,'invoice10-19-2016-081735',NULL,'','0000-00-00','','','',0,'','/0f79aeeecc330878e04d60a785fdec05.pdf',NULL,NULL),(61,214,33,NULL,'invoice10-20-2016',NULL,'invoice10-20-2016...','0000-00-00','','','',0,'','/225eb0ff31a65414e236804ffdda7c0b.pdf',NULL,NULL),(62,167,30,NULL,'invoice10-20-2016',NULL,'invoice10-20-2016...','0000-00-00','','','',0,'','/0f27448e5f1b66d167c56341487f1cee.png',NULL,NULL),(63,214,33,NULL,'Test Invoices.pdf',NULL,'invoice10-20-2016...','0000-00-00','','','',0,'','/2ebcbd3847866ccd58b0ef78b9a93ff9.pdf',NULL,NULL),(64,214,33,NULL,'Test Invoices',NULL,'invoice10-20-2016...','0000-00-00','','','',0,'','/09cebef172549488bfe627b912e39a83.pdf',NULL,NULL),(65,167,30,NULL,'serviceaggregator',NULL,'invoice10-20-2016...','0000-00-00','','','',0,'','/2a7c8a666410b130a830a9a90974238e.png',NULL,NULL),(67,272,36,NULL,'Projektbeschrieb',NULL,'','0000-00-00','','','/48a09d4d340a474def2ff4b2230f2ddf.png',0,'','/b508c068612a3c2aa598cf86c3240b46.pdf',NULL,NULL),(69,272,36,NULL,'2SOL',NULL,'','0000-00-00','','','/8c7e963bcf4c80cf9f6fd6ac27d9da5a.png',0,'','/f6c8ddaa075253424351db8d85f9dba0.pdf',NULL,NULL),(70,272,36,NULL,'digitalSTROM',NULL,'','0000-00-00','','','/dec40a8246f0010d9973b7db1fbdc57c.png',0,'','/4b5d90fdee9592a4facfb8c1f40675b3.pdf',NULL,NULL),(71,272,36,NULL,'Glasfaser',NULL,'','0000-00-00','','','/82b34f78644f07bbb7a8d1389766cd7b.png',0,'','/c5e4ce8756c2c278825fc93cca241cfa.pdf',NULL,NULL),(72,272,36,NULL,'Ausbau',NULL,'','0000-00-00','','','/c50b856de68e81f2bf8834903e4aa16b.png',0,'','/e24b56b755e2ed6037df83c513263f3d.pdf',NULL,NULL),(73,272,36,NULL,'Umgebung',NULL,'','0000-00-00','','','/84a466b6559000aa2e302a5c36b722bd.png',0,'','/4c72d27f485e737ff89edbf6c4ce61be.pdf',NULL,NULL),(74,272,36,NULL,'Preisliste',NULL,'','0000-00-00','','','/8b60c8a43addb2c16a2949a70367652c.png',0,'','/730651393ce29f9c578543a236ab48df.pdf',NULL,NULL),(76,306,37,NULL,'2SOL',NULL,'','0000-00-00','','','/ff328d5c6907b1913bf79c7d2699b414.png',0,'','/87ac77f1fa65bf0085245b0769d14f98.pdf',NULL,NULL),(77,306,37,NULL,'digitalSTROM',NULL,'','0000-00-00','','','/0c2d9fcfab14558eebc70179a0162293.png',0,'','/6226051ffaf14a6219acf99c3089fb71.pdf',NULL,NULL),(78,306,37,NULL,'Glasfaser',NULL,'','0000-00-00','','','/9547f6a31270fcac812c2d93579829de.png',0,'','/3ca6abfd5f22351aafbe674c05ec54b3.pdf',NULL,NULL),(79,306,37,NULL,'Ausbau',NULL,'','0000-00-00','','','/3babaa521e15f608a094f3d227fef894.png',0,'','/1c176e5a0ecea003344160bfb98cfda2.pdf',NULL,NULL),(80,261,26,NULL,'testdoc',NULL,'test','0000-00-00','','','',0,'','/10f300c4e9101cdf47b65848c48152b7.pdf',NULL,NULL),(81,261,26,NULL,'testfnl',NULL,'testing','0000-00-00','','','',0,'','/9d0d77bdf979f86cc8b1b1666065ab78.pdf',NULL,NULL),(82,214,NULL,'321','test developer test',1,'test dev','0000-00-00','','','',0,'','/c2490659fb562392645a779d94888054.pdf','2016-11-28 10:21:11','2016-11-28 10:26:09');

--
-- 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 (17);

--
-- 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 AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

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

INSERT INTO `notifications` VALUES (3,NULL,'0000-00-00 00:00:00','2015-09-24','20:00:00','General Meeting Real State AG','Vivamus non lacus arcu. Praesent tincidunt lacus id vulputate tempus. Duis ac velit gravida, dapibus nisl in, accumsan eros. Vestibulum nec elit pulvinar, dignissim neque nec, lacinia libero. Aliquam risus nisi, imperdiet ut sodales sit amet, cursus vitae ipsum. Proin sit amet turpis at ligula blandit blandit non eu tortor.','Real State AG Main Office\nFührmattstrasse 12\n8567 Dietikon\n',1,NULL,NULL),(6,NULL,'0000-00-00 00:00:00','2016-06-04','09:00:00','Flea market','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum non lacus id velit finibus finibus in sit amet massa. Suspendisse lacinia at quam sed elementum. Donec sit amet justo dictum, placerat urna eget, molestie arcu. Suspendisse ipsum dolor, convallis non velit ut, semper bibendum tortor.','Bahnhofstrasse 12, Main Building',1,NULL,NULL),(7,1,'0000-00-00 00:00:00','2015-09-19','14:00:00','Quarter Festival \"Every Year\"','Morbi auctor commodo tincidunt. Sed dictum sem ex, ac mattis nibh lacinia ut. Vivamus dignissim a ligula non cursus. Aliquam semper nunc ut magna sollicitudin facilisis.','Opera House',1,NULL,'2016-11-29 11:51:21'),(8,NULL,'0000-00-00 00:00:00','2015-10-10','18:00:00','Neighborhood Meeting','Donec suscipit cursus fermentum. Aliquam at maximus purus. Interdum et malesuada fames ac ante ipsum primis in faucibus. Mauris maximus interdum posuere. Nam a leo et urna fringilla interdum. Sed vel nisl nulla. Nam magna augue, vulputate eget aliquet quis, lacinia eget risus. ','Community Space',1,NULL,NULL),(9,NULL,'0000-00-00 00:00:00','2015-11-14','12:00:00','Concert','Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Ut vel magna aliquam, convallis quam sit amet, tincidunt nisi. Nulla dolor velit, sagittis vel tincidunt vitae, viverra sit amet odio. Aliquam sit amet magna eros. Suspendisse vehicula lorem eu ex sollicitudin, eget ultricies lorem finibus. In rhoncus velit mi, eget suscipit odio bibendum in.','City Concert Hall (Schlieren)',1,NULL,NULL),(10,NULL,'0000-00-00 00:00:00','2015-12-12','22:00:00','The Swingin\' Jazz Circus','Maecenas id egestas lectus. Morbi ex mauris, efficitur ac mollis et, tincidunt sed ex. Praesent dignissim eleifend augue eu ultrices. Nam ultrices luctus molestie. Nulla vehicula tellus eget justo ullamcorper dapibus. ','Salzhaus',1,NULL,NULL),(11,NULL,'0000-00-00 00:00:00','2016-08-01','18:00:00','1. August Fest','kflajlfjalfljafl al jflkajlfksal fljalk sfjla','Elfenhof',1,NULL,NULL),(12,NULL,'0000-00-00 00:00:00','2016-04-29','00:00:00','General Meeting Real State AG','Vivamus non lacus arcu. Praesent tincidunt lacus id vulputate tempus. Duis ac velit gravida, dapibus nisl in, accumsan eros. Vestibulum nec elit pulvinar, dignissim neque nec, lacinia libero. Aliquam risus nisi, imperdiet ut sodales sit amet, cursus vitae ipsum. Proin sit amet turpis at ligula blandit blandit non eu tortor.','Real State AG Main Office\nFührmattstrasse 12',0,NULL,NULL),(13,NULL,'0000-00-00 00:00:00','2016-05-31','00:00:00','Demo CS','akjdlajdlkjaldlka','Schlieren',1,NULL,NULL),(14,NULL,'0000-00-00 00:00:00','2016-09-10','08:00:00','Fassadenreinigung Süd','','Elfen-Tower',0,NULL,NULL),(15,NULL,'0000-00-00 00:00:00','2016-09-12','11:00:00','Kochen mit Kids','','Gemeinschaftsraum',1,NULL,NULL),(16,NULL,'0000-00-00 00:00:00','2016-09-27','08:00:00','Sondermüll','','Elfen-Tower',0,NULL,NULL),(17,NULL,'0000-00-00 00:00:00','2016-07-30','00:00:00','Test ','sdfasdas','Tet ',1,NULL,NULL),(18,NULL,'0000-00-00 00:00:00','2016-07-30','00:00:00','Test URL','http://www.google.es','ksjlfalfjl af',1,NULL,NULL),(19,NULL,'0000-00-00 00:00:00','2016-08-25','00:00:00','Sommerfest Vulcano ','Ab 18:00 mit Grill, Live Musik, Spiel und Spass','Aula Vulcano',0,NULL,NULL),(20,NULL,'0000-00-00 00:00:00','2017-06-01','14:00:00','Besichtigung Musterwohnung','Erleben Sie das innovative Vulcano Wohnkonzept in unserer Musterwohnung. Inklusive Apéro riche und anschliessendem Quartier-Rundgang.','Vulcano',0,NULL,NULL),(21,NULL,'0000-00-00 00:00:00','2017-06-23','17:00:00','Besichtigung Musterwohnung','Erleben Sie das innovative Vulcano Wohnkonzept in unserer Musterwohnung. Inklusive Apéro riche und anschliessendem Quartier-Rundgang.','Vulcano',0,NULL,NULL),(22,NULL,'0000-00-00 00:00:00','2017-07-10','18:00:00','Vulcano Summer Party','Summer Party mit Besichtigung der Musterwohnung, Quartier-Rundgang, Surprise Live-Konzert  und Gartengrill.','Vulcano',0,NULL,NULL),(23,NULL,'0000-00-00 00:00:00','2016-12-01','00:00:00','Welcome','Welcome to Sentmatt','Sentmatt',0,NULL,NULL),(24,NULL,'0000-00-00 00:00:00','2016-11-11','00:00:00','Eine Push ... ','... kommt selten alleine','',1,NULL,NULL),(25,NULL,'0000-00-00 00:00:00','2016-11-14','00:00:00','test2','test2','',1,NULL,NULL),(26,NULL,'0000-00-00 00:00:00','2016-11-14','00:00:00','hallo','hallo','',1,NULL,NULL),(27,1,'0000-00-00 00:00:00','2016-11-28','00:00:00','test developers','test purpose only','test',0,'2016-11-29 10:00:03','2016-11-29 10:00:03');

--
-- 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`)
) ENGINE=InnoDB AUTO_INCREMENT=161 DEFAULT CHARSET=utf8;

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

INSERT INTO `notifications_clients` VALUES (55,6,19,0),(56,6,24,0),(57,6,25,0),(58,6,47,0),(59,6,28,0),(60,6,31,1),(61,6,14,1),(62,6,17,1),(63,6,22,1),(64,6,26,0),(65,6,32,1),(66,6,5,1),(67,6,8,1),(68,6,37,1),(69,6,27,1),(70,6,6,1),(71,6,10,1),(72,6,42,1),(73,6,33,1),(75,6,35,1),(76,6,11,1),(77,6,38,1),(89,7,3,1),(91,8,3,1),(92,9,3,1),(93,10,3,1),(94,11,3,1),(95,11,55,1),(96,3,3,1),(97,3,24,1),(98,3,64,1),(99,11,64,1),(100,10,64,1),(101,9,64,1),(102,8,64,1),(103,7,64,1),(104,11,111,1),(105,6,111,1),(106,7,111,1),(107,3,111,1),(108,8,111,1),(109,9,111,1),(110,11,113,1),(114,16,117,0),(115,15,117,0),(116,14,117,0),(117,11,117,1),(125,8,117,1),(126,10,117,1),(127,17,117,1),(128,18,117,1),(130,16,179,0),(131,15,179,1),(132,16,201,0),(133,14,201,0),(134,22,221,0),(135,21,221,0),(136,20,221,0),(137,14,238,0),(138,16,238,0),(139,14,242,0),(140,16,242,0),(141,10,167,1),(142,21,117,0),(143,7,268,1),(144,8,268,1),(145,18,268,1),(146,17,268,1),(147,6,268,1),(148,22,288,0),(149,21,288,0),(150,20,288,0),(151,14,295,0),(152,16,295,0),(153,7,19,1),(154,23,281,0),(155,23,272,0),(156,16,299,0),(157,7,309,1),(158,24,307,1),(159,24,309,1),(160,25,309,1);

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

CREATE TABLE `numbers` (
  `id` int(11) NOT NULL,
  `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,
  `author_id` int(11) NOT NULL,
  `users` longtext COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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


--
-- 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=6 DEFAULT CHARSET=utf8;

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

INSERT INTO `parameters` VALUES (1,'test','testing','abc test'),(3,'msp_login','news.dev','Login of the service in MSP'),(4,'msp_password','changeme',''),(5,'msp_server','https://msp-dev.streamnow.ch/','');

--
-- 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`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;

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

INSERT INTO `repo_categories` VALUES (1,NULL,NULL,'Grundlagen',NULL,'Aliquam maximus nisi sed nunc consequat mollis. Pellentesque commodo hendrerit mauris, et egestas turpis vehicula vitae. Fusce ut ornare nunc, vitae commodo velit. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.','/6ba92828e61d59db8d065856e403bda9.png',0,NULL,NULL),(18,NULL,NULL,'Extensions',NULL,'','/a3f9ed24e25a1e8c38c5ceeb62ec724a.png',0,NULL,NULL),(19,NULL,NULL,'User Guides',NULL,'','/b802e07e8d4318bbb3fdece0e7442186.png',0,NULL,NULL),(20,NULL,NULL,'Warranties',NULL,'','/4dd2482f254080e301aa1741d7779a1a.png',0,NULL,NULL),(21,NULL,NULL,'Stadtwerk Magazine Old',NULL,'','/b53805157305fc4cc7288c6d9277960e.jpg',0,NULL,NULL),(22,1,NULL,'Kaufvertrag',NULL,'','/4e0ae317da6f5684e08cdcc22312a69b.png',0,NULL,NULL),(23,1,NULL,'Vertragspläne',NULL,'','/88f512e764a283621ef8d36a4b4b3c7a.png',0,NULL,NULL),(24,1,NULL,'Käuferbaubeschrieb inkl. Beurteilungsnormen',NULL,'','/b230dc847c37fad55babf861c969aa21.png',0,NULL,NULL),(25,1,NULL,'Baubewilligungen',NULL,'','/83e68854364b2db9e0dfedbca161d5d1.png',0,NULL,NULL),(26,1,NULL,'Begründung Stockwerkeigentum Aufteilungspläne Wertquoten',NULL,'','/71ddb7a00f4d52db52095b48805ec54e.png',0,NULL,NULL),(27,1,NULL,'Benutzungs- und Verwaltungsreglement mit Tiefgarage',NULL,'','/1e8b4703edc1119918cca0da6b863e1f.png',0,NULL,NULL),(28,1,NULL,'Wärmeliefervertrag ERZ Zürich',NULL,'','/dd289afb1b200262cf476785b61365c0.png',0,NULL,NULL),(29,1,NULL,'Katasterplan Grundbuchanmeldung Begründung von Dienstbarkeiten',NULL,'','/23e5b1154902c38010ad0d2546617ab4.png',0,NULL,NULL),(30,1,NULL,'Küche',NULL,'','/c4942d9a9676cd4b14c3fb9e9fed30d6.png',0,NULL,NULL),(31,1,NULL,'Bad, Dusche und WC',NULL,'','/71e3c185f3a85791a5258ba04d7484aa.png',0,NULL,NULL),(32,1,NULL,'Waschmaschine und Tumbler',NULL,'','/35397749018f3e1252bcba9daa35da21.png',0,NULL,NULL),(33,1,NULL,'Elektroausbau\r\n',NULL,'','wss',0,NULL,NULL),(34,1,NULL,'Ankleide und Garderobe',NULL,'','/b352f2e9502995c07d633d3fabc845f0.png',0,NULL,NULL),(35,NULL,NULL,'Bedienungsanleitungen',NULL,'','/fa2a3d41ca29689d83de33d235598c23.png',0,NULL,NULL),(36,NULL,NULL,'Wohnen',NULL,'','/6b9d2a7782e3a1ccbd481f28d0cbc417.png',0,NULL,NULL),(37,NULL,NULL,'Der Lindauer',NULL,'','/96406ef3e94d68c4398e33f8de5d3340.png',0,NULL,NULL),(38,NULL,NULL,'Vermietungsunterlagen',NULL,'','/4f68f2b2c583facb8a4869443e9d8bde.png',0,NULL,NULL),(39,NULL,NULL,'Projekt',NULL,'','/20287e4fc977c2f22402069d50f20eb9.png',0,NULL,NULL),(42,NULL,'13123','Developer testing',1,'Please ignore it for now','/44c242b11b2e26729877c590d87b4202.png',0,'2016-11-28 06:40:59','2016-11-28 07:50:02'),(43,20,'Test','Test',1,'','/2b906591dc94bc6902b8369b01567e9c.png',0,'2016-11-28 09:02:30','2016-11-28 09:02:30');

--
-- 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`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8;

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

INSERT INTO `repo_docs` VALUES (5,22,NULL,'Musterkaufvertrag',NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent mollis sodales risus posuere iaculis. Curabitur at elit ullamcorper, dapibus magna vitae, auctor nisi. Aenean molestie eget purus quis facilisis. Suspendisse justo lacus, auctor vitae venenatis congue, elementum ac urna. Cras eget iaculis neque. Sed turpis libero, commodo aliquam tincidunt congue, sodales eu lacus. Aliquam auctor ligula nec ipsum scelerisque, non feugiat eros luctus. Pellentesque nec justo vel velit imperdiet tincidunt et sit amet eros. Sed in urna cursus, pretium nisl ac, egestas quam. Quisque sit amet augue semper, consequat neque id, fermentum lectus.','0000-00-00','9','Halter','/ed61747f493f7436dde4e08f301b9281.png',0,'','/6ca0bfc84aee14d12385c01f12824884.pdf',NULL,NULL),(6,23,NULL,'Vertragsplan',NULL,'','0000-00-00','','Halfin AG','/eaa07fcdbf48ed1ea3467335b33be7e5.jpg',0,'','/f1556b891f491eca465e1fdbfa1c22ad.pdf',NULL,NULL),(7,24,NULL,'Parkettnorm',NULL,'','0000-00-00','','','/9756cdcb47c51241659e76814eb10f61.jpg',0,'','/08438ec881b1f84f668381a662549f3a.pdf',NULL,NULL),(8,24,NULL,'Glasnorm',NULL,'','0000-00-00','','','/5d156d527942b80fee7efc316c1b1dea.png',0,'','/fa236e941b303139c01494a3fad2dcd4.pdf',NULL,NULL),(9,24,NULL,'Naturstein',NULL,'','0000-00-00','','','/ee52346cce2bbae1937dfffcb9a38457.png',0,'','/dd2c5413e6d4aa62db39e724d046a5af.pdf',NULL,NULL),(10,24,NULL,'BKP',NULL,'','0000-00-00','','','/09c21732fbcd5e3aba6e485ae1dfd12b.png',0,'','/b4ad3c2f202cd9a7ffc3c518cb5921f0.pdf',NULL,NULL),(11,34,NULL,'Garderobe',NULL,'','0000-00-00','','','/8eedd9fab24cd85c5f88c28f6b7a4e22.png',0,'','/3c1cec25e5210b93842a938aef7e10b3.pdf',NULL,NULL),(12,33,NULL,'Parkplatz',NULL,'','0000-00-00','','','/2a5230269cc43fe59c3da6d69dea3eb7.jpg',0,'','/2a803f32017c69733fc62b56058c4cee.pdf',NULL,NULL),(13,33,NULL,'EG',NULL,'','0000-00-00','','','/bbe2bcd96a9b0d832d75fe358d5e410e.jpg',0,'','/ef7d0ba798f12d05f5df300be71409cd.pdf',NULL,NULL),(14,32,NULL,'WM',NULL,'','0000-00-00','','','/169a1a43d884301de4376d9f07cbab63.jpg',0,'','/cb078f09a6b64592e9cdc195a338495e.pdf',NULL,NULL),(15,31,NULL,'Badewannen',NULL,'','0000-00-00','','','/fd720e201aebd8c8e5094836d5e84ce3.png',0,'','/2bc8eb219cbb77d5599777b127b7ab1e.pdf',NULL,NULL),(16,31,NULL,'CatalanoWC_Zero50',NULL,'','0000-00-00','','','/4bcdaf9ed97a27befe22f816223ddbff.png',0,'','/ee83dcead7f5b3c4a761a83b6e2784b8.pdf',NULL,NULL),(17,31,NULL,'Libero4000',NULL,'','0000-00-00','','','/4f5d885885578898beddb0db4674d94d.png',0,'','/5604637e5bb948f3313c8bac3ccbf379.pdf',NULL,NULL),(18,30,NULL,'Typ1_links',NULL,'','0000-00-00','','','/d72acd109074c0dc408bfde02505ed5b.png',0,'','/e696382265ff5ba753fca84575ee2531.pdf',NULL,NULL),(19,29,NULL,'01-Plan zu Dienstbarkeit.pdf',NULL,'','0000-00-00','','','/db175e8b7582b881cc1497291600ad66.png',0,'','/0510aad4dad28d5231e12dea29ce5a9b.pdf',NULL,NULL),(20,29,NULL,'03-Pläne zu Dienstbarkeiten.pdf',NULL,'','0000-00-00','','','/7b243f6b5861851f1de1e74bbc287c36.png',0,'','/3ad494b04fbb7730c8d009721dee43ae.pdf',NULL,NULL),(21,29,NULL,'5062_aktueller Grundbuckauszug Halfin.pdf',NULL,'','0000-00-00','','','/d8a551eb585ae2f61f34d506a7e95ecb.png',0,'','/efe741f924fd5d49bd44e6554c65e737.pdf',NULL,NULL),(22,29,NULL,'5062_VM_G_10_120418_Kasterplan_AU6349.pdf',NULL,'','0000-00-00','','','/73227c831effa56838578eb7ee1dceab.png',0,'','/4d324c6acd44163e8a0aa3887e86df7e.pdf',NULL,NULL),(23,25,NULL,'Änderungbew',NULL,'','0000-00-00','','','/c87b5c8cd4832e5fbfc55dd6806356fc.png',0,'','/3395a3163aba0220a409f9e1dac7495c.pdf',NULL,NULL),(24,25,NULL,'Baudirektion',NULL,'','0000-00-00','','','/3c43c3d3bda1449be4cbe28327dead2b.png',0,'','/735ea7bd9d6f13b48d32e5f9881f0b85.pdf',NULL,NULL),(25,28,NULL,'5062_Förrlibuck_131213_Wärmeliefervertrag_Entwurf.pdf',NULL,'','0000-00-00','','','/67e99667c7ff1c7572eb2d186ff3bf36.png',0,'','/9e75b435ed9208f5597386362cbcb579.pdf',NULL,NULL),(26,27,NULL,'5062_Förrlibuck_140116_Benutzungs_und Verwaltungsreglement.pdf',NULL,'','0000-00-00','','','/6cd11bae41a2be46f0cd439e8436e668.png',0,'','/e72e90548a3c79010c7da21a607c9def.pdf',NULL,NULL),(27,26,NULL,'5062_Förrlibuck_131212_Wertquotenberechnung.pdf',NULL,'','0000-00-00','','','/87154b43ab347684a9dd6db501637dd9.png',0,'','/acd9c9391af20812bbdcac738acbb4e7.pdf',NULL,NULL),(28,26,NULL,'5062_AR_X_09_12M01_550-01.pdf',NULL,'','0000-00-00','','','/e9a99597293ef449d866e2e294e74b03.png',0,'','/867921308d41c19ef21e3cf9095f33c2.pdf',NULL,NULL),(29,20,NULL,'Tesla Model S',NULL,'','0000-00-00','2.1','Tesla','/e00e27ec5ad7e87b0665559105ddde83.png',0,'','/8e28efe8b3498b95179c4252ffa5ec26.pdf',NULL,NULL),(33,18,'23','Web extension',1,'','0000-00-00','','','/46d66f01954abc9fcb9a6327bdc89a85.png',0,'','/7d39db6a5174e279b4d87468a152e706.pdf',NULL,'2016-11-28 13:27:42'),(34,19,NULL,'Coffee',NULL,'','0000-00-00','','Zanussi','/a2843ceaa8887847561064405c147d12.png',0,'','/59fe6a6657a346e6a931080ab686bb57.pdf',NULL,NULL),(35,21,NULL,'Jan-Mar 2015',NULL,'','0000-00-00','','','/7547ffc0050d610f6a1aacec6f087264.png',0,'','/f7de20acde07afbcd46302c530212800.pdf',NULL,NULL),(36,35,NULL,'Smart Home Merkblatt',NULL,'','0000-00-00','','','/feb9d71dd38819f76c78097baa15c653.png',0,'','/f204d08dbb2672c73beed2c515858c8f.pdf',NULL,NULL),(37,35,NULL,'dS Handbuch',NULL,'','0000-00-00','','','/7f44838cc19742a7ca4a3a9e8153a477.png',0,'','/f2eac84e4cbe88c80b2d9b1397e7f40d.pdf',NULL,NULL),(38,36,NULL,'Energiesparen im Haushalt',NULL,'','0000-00-00','','','/835fa7fcc71230f4e92a8bfb2cf4ce88.png',0,'','/81ed6686f98a0a58793e9f970a206906.pdf',NULL,NULL),(39,36,NULL,'Komfortabler Wohnen',NULL,'','0000-00-00','','','/daa7c3e1b8655d3b1cbd22d0fd189dd5.png',0,'','/f0115094e4244696e23572f6af077fbf.pdf',NULL,NULL),(41,35,NULL,'streamnow SMB',NULL,'','0000-00-00','2.5','','/1c2b900df309e965256085a85664e4f7.png',0,'','/a5380e4550b9f430df854b795c791e9b.pdf',NULL,NULL),(42,35,NULL,'IP Telefon',NULL,'','0000-00-00','','','/fc2a9f293083a8b1a6ff6d276fd7eca1.jpg',0,'','/79e6b1365b7c1e9dabce062443d5478c.pdf',NULL,NULL),(43,35,NULL,'Analog Telefonkonverter',NULL,'','0000-00-00','','','/d1df3fafbc0105f922fb2dba24084986.jpg',0,'','/60f8e71e447f180c059c67f5fe43c092.pdf',NULL,NULL),(44,35,NULL,'Anrufbeantworter',NULL,'','0000-00-00','','','/9a51db2a161cbe239bbbef2c8c2aa4c4.png',0,'','/dcc9d2688122cc90d47dea3beaa6efee.pdf',NULL,NULL),(45,37,NULL,'Nov. 2015',NULL,'','0000-00-00','','','/cbe91c5d92bcb76c28e107a1aab016b6.png',0,'','/22335be86bcb0549cb9cec325a451faf.pdf',NULL,NULL),(46,37,NULL,'Okt. 2015',NULL,'','0000-00-00','','','/8f7525077e26b7b9f6ce9cdcbe35e048.png',0,'','/cea570ab789c09c1bc0628916260de62.pdf',NULL,NULL),(47,NULL,NULL,'test without cate',NULL,'','0000-00-00','','','/e0cf670eae0a1f3a922efaf553b4fb50.jpg',0,'','/adb630374d7dc536d6fcea471ddf6c9b.jpg',NULL,NULL),(48,35,NULL,'LF Telefoniepreise 2016',NULL,'','0000-00-00','','','/5042d90065e46c2f861a7f5fd5186876.png',0,'','/9834a2182369f29dfedbcd0d5a62abaf.pdf',NULL,NULL),(49,37,NULL,'Dez. 2015',NULL,'','0000-00-00','','','/eb3eb09c7c55a45aea3ff57b79508c2e.png',0,'','/9e9ea58fa1c0656ea5532584c72c8a62.pdf',NULL,NULL),(50,37,NULL,'Jan. 2016',NULL,'','0000-00-00','','','/fce6b0764495dd166c2476eae3835789.png',0,'','/93ce57cb7a880909314ee36b478a4786.pdf',NULL,NULL),(51,35,NULL,'Zusammenbauanleitung',NULL,'Zusammenbauanleitung','0000-00-00','3.2','','/30be159fc3c537fc0740fe38dd662c03.png',0,'','/d556601b295737db54a84042e9967409.pdf',NULL,NULL),(52,35,NULL,'ISG Quick Guide',NULL,'','0000-00-00','7.6','','/a48868aa48e7021e6eb126d8c9c16d38.png',0,'','/6a0240c49e5a5bd5fd2441f87d0ea7ba.pdf',NULL,NULL),(53,37,NULL,'Feb. 2016',NULL,'','0000-00-00','','','/1492cb16c677e34d062fa8642d2b9e4e.png',0,'','/f5656b09c6c33e64b33df3bce4b77cb3.pdf',NULL,NULL),(54,37,NULL,'Mar. 2016',NULL,'','0000-00-00','','','/9aa7bb10ac9cc530eaea6205bc201a00.png',0,'','/215bc0357303faa544550fa341d6ba76.pdf',NULL,NULL),(55,37,NULL,'Apr. 2016',NULL,'','0000-00-00','','','/22087c0c0db025ed2ed3e67e986741b7.png',0,'','/80e1fd4894ebebedddb419fe9dff7cfc.pdf',NULL,NULL),(56,37,NULL,'Mai 2016',NULL,'','0000-00-00','','','/2f5eab64a5812aa1c5d7d6c75d3685c2.png',0,'','/11d071f2c44c3d9ecb35e1cc367869af.pdf',NULL,NULL),(57,37,NULL,'Juni 2016',NULL,'','0000-00-00','','','/d159537286c1be405e9bd3dd1358a93f.png',0,'','/0f4610a744a1e287b10625b8ff4f6e41.pdf',NULL,NULL),(58,37,NULL,'Juli 2016',NULL,'','0000-00-00','','','/5d228ed778dcd865aede87e42aea3560.png',0,'','/b2c80eb4788b696978e004ab59178d6f.pdf',NULL,NULL),(59,37,NULL,'Aug 2016',NULL,'','0000-00-00','','','/feb66554f12c5e9b50d2d77dbb816772.png',0,'','/f6ba4689f37d4d08e6eb40ec58803025.pdf',NULL,NULL),(60,38,NULL,'Grundriss 4-5 Zi',NULL,'Grundrisse Wohnung 4-5 Zi','0000-00-00','','','/facc3404800cafca276fbc9e2088904c.JPG',0,'','/bc1f6470db5e60e827a62ec0cda8dac2.pdf',NULL,NULL),(61,38,NULL,'Broschüre',NULL,'Broschüre ','0000-00-00','','','/86afd1295f9ad8073a4340b5bf8e99c3.jpg',0,'','/116e04bddec74e695de1ca879f1c20eb.pdf',NULL,NULL),(62,38,NULL,'Preisliste',NULL,'Preisliste','0000-00-00','','','/a53c3b55bc978645c95b8621602a4a52.JPG',0,'','/2239bc6e654458a9c575cf7456b569b7.pdf',NULL,NULL),(63,35,NULL,'Combi-Steamer V-Zug',NULL,'','0000-00-00','','','/98628ebfe8caddb17795dfb76606c453.JPG',0,'','/17afc035d808d93a939c8f5e3c5d9447.pdf',NULL,NULL),(64,1,NULL,'test 10Megas',NULL,'','0000-00-00','','','/e01f53477785fc0182a5ac66803d99cd.png',0,'','/3cbb3b03b887e9aa18fb494690588842.png',NULL,NULL),(65,39,NULL,'Baubeschrieb Sentmatt',NULL,'','0000-00-00','','','/605705abb3bfd53df9a7ba9206db48b6.png',0,'','/430806d414fb0411876832275ab16eb2.pdf',NULL,NULL),(66,NULL,NULL,'Sentmatt - Projektbeschrieb',NULL,'','0000-00-00','','','/0d690cc6d1dcd3a593659f008ba9a6c5.png',0,'','/a0265fb18f78ea828ed7f723056b3ba3.pdf',NULL,NULL),(67,NULL,NULL,'Sentmatt - Ausbaubeschrieb',NULL,'','0000-00-00','','','/12f5a921b8b68c403da84be322b869ce.png',0,'','/01e1d4b8283f354c2f5ef8de17cae6e1.pdf',NULL,NULL),(68,NULL,NULL,'Sentmatt - Preisliste',NULL,'','0000-00-00','','','/b8991348dab80ab3372eaa0018d85329.png',0,'','/8376f1d6661ec1a5ddc374b4e408e1a2.pdf',NULL,NULL),(69,NULL,NULL,'Infoflyer 2SOL',NULL,'','0000-00-00','','','/f1b3857543abb892e2b35c32cbb72b60.png',0,'','/1a475a0ebc48a98c8167d454798dabfd.pdf',NULL,NULL),(70,NULL,NULL,'Infoflyer Glasfaser',NULL,'','0000-00-00','','','/b3976954f210adde57c4adad0ee97f69.png',0,'','/3167711ce56ad369c5fecd717a390878.pdf',NULL,NULL),(71,NULL,NULL,'Infoflyer digitalSTROM',NULL,'','0000-00-00','','','/5b92336221886447889711e895839517.png',0,'','/39a2ef41190ada95a6e732e92786bae3.pdf',NULL,NULL),(72,NULL,NULL,'Sentmatt - Umgebung',NULL,'','0000-00-00','','','/4f8f9b021350dd80c6b8991a8b7c2515.png',0,'','/b9e0b42e047c93b32c6f2b105e238c19.pdf',NULL,NULL),(73,39,NULL,'Projektbeschrieb',NULL,'','0000-00-00','','','/06c6fd295c43278b135ce914d36a6078.png',0,'','/3e9419f3bd2f3ad942a57756aa6ad4b4.pdf',NULL,NULL),(74,39,NULL,'Ausbaubeschrieb',NULL,'','0000-00-00','','','/8c10e1fc1354dc1367f2b428f3411aab.png',0,'','/4e7975d5945d8b1fb71cdeb6c827c438.pdf',NULL,NULL),(75,39,NULL,'Preisliste',NULL,'','0000-00-00','','','/8149af170d929e3025eeedc0509e78f5.png',0,'','/8e2cd26a49284f163573db9adc92cb18.pdf',NULL,NULL),(76,20,NULL,'Testasdad',NULL,'','0000-00-00','','','/db9b40eb1afb03a8ffa463cee44791f4.jpeg',0,'','/c8c7051a9d8b4662593728d6e5c03b55.png',NULL,NULL),(77,20,NULL,'ets',NULL,'','0000-00-00','','','/26a155cf03fd3e5dbe0fbb79c1796009.jpeg',0,'','/51654c267bc21bf7a4dd0c82d5538579.png',NULL,NULL),(80,NULL,NULL,'testone',NULL,'testone','0000-00-00','','','',0,'','/dde8616624bbfca932b6f33957536127.pdf',NULL,NULL),(81,NULL,NULL,'sdfsdf',NULL,'','0000-00-00','','','',0,'','/e942bab1a1bfcf3a7c521bc97e58f183.png',NULL,NULL),(82,NULL,'213','devtest',1,'developers testing only','0000-00-00','','','',0,'','/b8fd3a5f7189317925c8dcc9fc56f856.pdf','2016-11-28 09:51:54','2016-11-28 09:55:16'),(83,42,'2112','sadasd',1,'','0000-00-00','','','',0,'','/13f719954b4b642e3efe8f5c327d711b.png','2016-11-28 13:28:48','2016-11-28 13:28:48'),(84,20,'2233','tete',1,'','0000-00-00','','','',0,'','/0350a210dabf54ab5952ce6cfef7b8c7.png','2016-11-29 07:07:27','2016-11-29 07:07:27');

--
-- 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`)
) ENGINE=InnoDB AUTO_INCREMENT=326 DEFAULT CHARSET=utf8;

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

INSERT INTO `repo_docs_clients` VALUES (9,5,40),(10,6,40),(11,7,40),(12,8,40),(13,23,40),(14,24,40),(15,27,40),(16,28,40),(17,11,40),(18,12,40),(19,13,40),(20,14,40),(21,15,40),(22,16,40),(23,17,40),(24,18,40),(25,19,40),(26,20,40),(27,21,40),(28,22,40),(29,25,40),(30,26,40),(56,18,47),(62,5,31),(104,36,3),(105,37,3),(108,36,90),(109,37,90),(110,38,90),(111,39,90),(120,41,3),(122,41,111),(126,41,64),(131,41,113),(132,42,113),(133,42,111),(134,43,111),(135,44,111),(136,43,113),(137,44,113),(142,45,113),(143,45,64),(144,42,64),(145,43,64),(146,44,64),(147,46,113),(148,45,111),(149,46,111),(150,47,3),(151,48,111),(152,49,111),(153,50,111),(154,49,113),(155,50,113),(156,51,111),(157,48,113),(158,51,113),(161,41,55),(162,42,55),(163,43,55),(164,44,55),(165,48,55),(166,51,55),(167,52,111),(168,52,113),(169,36,151),(170,37,151),(171,39,151),(172,38,151),(173,36,117),(174,37,117),(175,38,117),(176,39,117),(177,53,113),(178,54,113),(179,55,113),(180,56,113),(181,53,111),(182,54,111),(183,55,111),(184,56,111),(185,36,179),(186,39,179),(187,38,179),(191,37,179),(192,38,193),(193,39,193),(194,36,193),(195,37,193),(196,38,201),(197,39,201),(198,37,201),(199,36,201),(200,57,113),(201,58,113),(202,59,113),(203,57,111),(204,58,111),(205,59,111),(211,45,210),(212,46,210),(213,49,210),(214,50,210),(215,53,210),(216,54,210),(217,55,210),(218,56,210),(219,57,210),(220,58,210),(221,59,210),(222,36,210),(223,37,210),(224,41,210),(225,42,210),(226,52,210),(227,43,210),(228,44,210),(229,48,210),(230,51,210),(231,63,179),(232,63,117),(233,63,201),(234,41,191),(235,42,191),(236,43,191),(237,44,191),(238,48,191),(239,51,191),(240,52,191),(241,45,191),(242,46,191),(243,49,191),(244,59,191),(245,58,191),(246,50,191),(247,53,191),(248,54,191),(249,55,191),(250,56,191),(251,57,191),(252,36,221),(253,37,221),(254,60,221),(255,61,221),(256,62,221),(257,63,221),(258,37,229),(259,36,229),(260,38,229),(261,39,229),(262,36,238),(263,37,238),(264,63,238),(265,38,238),(266,39,238),(267,36,242),(268,37,242),(269,63,242),(270,38,242),(271,39,242),(272,41,248),(273,63,248),(274,38,248),(275,39,248),(277,34,19),(278,66,271),(279,67,271),(280,68,271),(281,69,271),(282,70,271),(283,71,271),(284,72,271),(287,65,281),(294,73,281),(295,74,281),(296,75,281),(300,39,268),(301,38,268),(302,63,268),(303,41,268),(304,37,268),(305,36,268),(306,34,268),(307,16,268),(308,15,268),(309,14,268),(310,36,288),(311,37,288),(312,63,288),(313,60,288),(314,61,288),(315,62,288),(316,36,295),(317,37,295),(318,63,295),(319,38,295),(320,39,295),(323,6,299),(324,65,167),(325,33,6);


