--
-- Host: localhost    Database: carsoftCRm
-- ------------------------------------------------------


--
-- Table structure for table `aclRole`
--

CREATE TABLE `aclRole` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nazwa` varchar(255) DEFAULT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `opis` text,
  `visible` enum('0','1') DEFAULT '0',
  `pozycja` int(10) DEFAULT NULL,
  `acl` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `aclRole`
--

INSERT INTO `aclRole` VALUES (10,'root',NULL,NULL,'0',NULL,'a:10:{s:10:\"zgloszenia\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";s:1:\"1\";}}s:7:\"aclRole\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";s:1:\"1\";}}s:6:\"admins\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";s:1:\"1\";}}s:6:\"uslugi\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";s:1:\"1\";}}s:7:\"klienci\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";s:1:\"1\";}}s:16:\"statusZgloszenia\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";s:1:\"1\";}}s:4:\"news\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";s:1:\"1\";}}s:3:\"txt\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";s:1:\"1\";}}s:5:\"start\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";i:1;}}s:6:\"logout\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";i:1;}}}'),(12,'test',NULL,NULL,'0',NULL,'a:8:{s:10:\"zgloszenia\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";s:1:\"1\";}}s:7:\"aclRole\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";s:1:\"1\";}}s:6:\"admins\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";s:1:\"1\";}}s:6:\"uslugi\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";s:1:\"1\";}}s:7:\"klienci\";a:1:{s:7:\"actions\";a:1:{s:9:\"adminOnly\";s:1:\"1\";}}s:16:\"statusZgloszenia\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";s:1:\"1\";}}s:5:\"start\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";i:1;}}s:6:\"logout\";a:1:{s:7:\"actions\";a:1:{s:3:\"all\";i:1;}}}');

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) DEFAULT NULL,
  `pass` varchar(255) DEFAULT NULL,
  `nazwa` varchar(45) DEFAULT NULL,
  `chmod` int(10) DEFAULT NULL,
  `skill` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` VALUES (1,'402c7744b117563235334647ca7ebf8efc5a6713','c3542d37b0f4b712702b07b1c59106410408232a','cermit',10,'1,2'),(2,'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3','test',12,'1');

--
-- Table structure for table `klienci_pl`
--

CREATE TABLE `klienci_pl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazwa` varchar(255) DEFAULT NULL,
  `shortNazwa` varchar(45) DEFAULT NULL,
  `opis` text,
  `pozycja` int(11) DEFAULT NULL,
  `adminId` int(11) DEFAULT NULL,
  `dataDodania` datetime DEFAULT NULL,
  `nip` varchar(45) DEFAULT NULL,
  `regon` varchar(45) DEFAULT NULL,
  `ulica` varchar(45) DEFAULT NULL,
  `numerUl` varchar(45) DEFAULT NULL,
  `kod` varchar(45) DEFAULT NULL,
  `miasto` varchar(45) DEFAULT NULL,
  `tel` varchar(45) DEFAULT NULL,
  `mail` varchar(45) DEFAULT NULL,
  `login` varchar(45) DEFAULT NULL,
  `pass` varchar(255) DEFAULT NULL,
  `cennik` text,
  `visible` enum('0','1') DEFAULT '1',
  `resetPass` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `klienci_pl`
--

INSERT INTO `klienci_pl` VALUES (1,'PPHU Simex','Simex',NULL,1,NULL,'2017-02-20 18:14:41','nip','regon','ulica','12','42-200','Częstochowa','8768768','karol@halaba.pl','karol@halaba.pl','','a:3:{i:1;s:2:\"30\";i:2;s:2:\"10\";i:3;s:1:\"7\";}','1',NULL),(2,'dwa','2',NULL,2,1,'2017-02-20 18:16:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL),(3,'kolejna firma','krótka',NULL,3,1,'2017-02-27 19:03:43','666','666','666','666','666','666','6666','6666@o2.pl','666','9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684','a:3:{i:1;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";}','1',NULL),(4,'test','test',NULL,4,1,'2017-03-01 20:13:36','','','','','','','','karol@halaba.pl','test','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3','a:3:{i:1;s:2:\"10\";i:2;s:2:\"20\";i:3;s:2:\"30\";}','1','680b59e0af1d70738f0b1dab8cc404a894ab626d'),(5,'klient test-a','krótka',NULL,5,2,'2017-03-22 19:09:20','nipp','regon','ulica','12','42-200','czestochowa','77987','karol@halaba.pl','test2','109f4b3c50d7b0df729d299bc6f8e9ef9066971f','a:3:{i:1;s:2:\"10\";i:2;s:2:\"10\";i:3;s:2:\"10\";}','1',NULL);

--
-- Table structure for table `news_pl`
--

CREATE TABLE `news_pl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazwa` varchar(255) DEFAULT NULL,
  `shortNazwa` varchar(45) DEFAULT NULL,
  `opis` text,
  `pozycja` int(11) DEFAULT NULL,
  `data` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `news_pl`
--

INSERT INTO `news_pl` VALUES (1,'News 1',NULL,'<p>Kilka sł&oacute;w opisu</p>',1,NULL);

--
-- Table structure for table `statusZgloszen_pl`
--

CREATE TABLE `statusZgloszen_pl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazwa` varchar(255) DEFAULT NULL,
  `opis` text,
  `pozycja` int(11) DEFAULT NULL,
  `color` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `statusZgloszen_pl`
--

INSERT INTO `statusZgloszen_pl` VALUES (1,'Nowe  Zgłoszenie',NULL,1,'#09fa07'),(2,'Zgłoszenie otwarte',NULL,2,'#ffb400'),(3,'Zgłoszenie zamknięte',NULL,3,'#737373');

--
-- Table structure for table `txt_pl`
--

CREATE TABLE `txt_pl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazwa` varchar(255) DEFAULT NULL,
  `shortNazwa` varchar(45) DEFAULT NULL,
  `opis` text,
  `pozycja` int(11) DEFAULT NULL,
  `data` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `txt_pl`
--


--
-- Table structure for table `uslugi_pl`
--

CREATE TABLE `uslugi_pl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazwa` varchar(255) DEFAULT NULL,
  `shortNazwa` varchar(45) DEFAULT NULL,
  `opis` text,
  `pozycja` int(11) DEFAULT NULL,
  `color` varchar(45) DEFAULT NULL,
  `cena` float(8,2) DEFAULT '0.00',
  `punktyZaKlienta` float(8,2) DEFAULT '0.00',
  `punktyZaUsluge` float(8,2) DEFAULT '0.00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `uslugi_pl`
--

INSERT INTO `uslugi_pl` VALUES (1,'Usunięcie DPF-a','DPF-',NULL,1,'#06fb1b',500.00,1.40,5.00),(2,'Modyfikacja','MOD',NULL,2,'#ffaf00',100.00,10.00,20.00),(3,'Blue','BLU+',NULL,3,'#00fbff',200.00,5.00,5.00);

--
-- Table structure for table `zgloszenia`
--

CREATE TABLE `zgloszenia` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazwa` varchar(255) DEFAULT NULL,
  `pozycja` int(11) DEFAULT NULL,
  `color` varchar(45) DEFAULT NULL,
  `cena` float(8,2) DEFAULT '0.00',
  `punktyZaKlienta` float(8,2) DEFAULT '0.00',
  `punktyZaUsluge` float(8,2) DEFAULT '0.00',
  `userId` int(11) DEFAULT NULL,
  `opiekunId` int(11) DEFAULT NULL,
  `uslugi` text,
  `data` datetime DEFAULT NULL,
  `autoMarka` text,
  `autoModel` varchar(45) DEFAULT NULL,
  `autoPojemnosc` varchar(45) DEFAULT NULL,
  `autoMoc` varchar(45) DEFAULT NULL,
  `autoId` varchar(45) DEFAULT NULL,
  `autoEcu` varchar(45) DEFAULT NULL,
  `autoSkrzynia` varchar(45) DEFAULT NULL,
  `lastStatus` int(11) DEFAULT '1',
  `mechanikId` int(10) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zgloszenia`
--

INSERT INTO `zgloszenia` VALUES (45,NULL,NULL,NULL,NULL,NULL,NULL,4,1,NULL,'2017-03-10 20:23:24','audi','a6','2800','174','scz','333','auto',2,1),(46,NULL,NULL,NULL,NULL,NULL,NULL,4,1,NULL,'2017-03-13 20:25:57','audi','a6','2800','174','scz','333','auto',2,1),(49,NULL,NULL,NULL,170.00,11.40,25.00,4,1,NULL,'2017-03-13 20:27:29','audi','a6','2800','174','scz','333','auto',2,1),(50,NULL,NULL,NULL,510.00,1.40,5.00,4,1,NULL,'2017-03-13 20:27:48','audi','a6','2800','174','scz','333','auto',1,0),(53,NULL,NULL,NULL,230.00,5.00,5.00,4,1,NULL,'2017-03-13 20:29:32','audi','a6','2800','127','scz','333','auto',1,0),(54,NULL,NULL,NULL,860.00,16.40,30.00,4,1,NULL,'2017-03-13 20:32:16','audi','a6','2800','127','scz','333','manual',1,0),(55,NULL,NULL,NULL,630.00,11.40,25.00,4,1,NULL,'2017-03-13 22:09:42','ural','m-67','700','45','scz x349','self','auto',2,0),(58,NULL,NULL,NULL,230.00,5.00,5.00,4,1,NULL,'2017-03-13 22:53:36','audi','a6','2800','127','scz','333','auto',1,0),(62,NULL,NULL,NULL,860.00,16.40,30.00,4,1,NULL,'2017-03-13 22:58:37','audi','a6','2800','174','scz x349','333','manual',1,1),(63,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n','n','n','n','n','n','auto',3,1),(65,NULL,NULL,NULL,860.00,16.40,30.00,4,1,NULL,'2017-03-20 23:52:19','ural','m67','700','45','scz x349','brak','auto',3,1),(66,NULL,NULL,NULL,NULL,NULL,NULL,4,1,NULL,'2017-03-21 21:54:55','suma Ural','m-67','700','45','scz','brak','auto',2,1),(67,NULL,NULL,NULL,514.00,1.40,5.00,5,2,NULL,'2017-03-22 19:25:24','pojazd test2','yy','yy','yy','yy','yy','auto',3,1),(68,NULL,NULL,NULL,630.00,11.40,25.00,4,1,NULL,'2017-03-22 20:21:27','test','test','test','test','test','test','auto',2,1),(69,NULL,NULL,NULL,620.00,11.40,25.00,5,2,NULL,'2017-03-22 20:23:15','test','test','test','test','test','test','auto',2,1);

--
-- Table structure for table `zgloszeniaDetails`
--

CREATE TABLE `zgloszeniaDetails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazwa` varchar(255) DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `zgloszenieId` int(11) DEFAULT NULL,
  `cena` float(8,2) DEFAULT '0.00',
  `punktyZaKlienta` float(8,2) DEFAULT '0.00',
  `punktyZaUsluge` float(8,2) DEFAULT '0.00',
  `uslugaId` int(11) DEFAULT NULL,
  `msgType` varchar(45) DEFAULT NULL,
  `cenaUslugi` float(8,2) DEFAULT '0.00',
  `cenaKlient` float(8,2) DEFAULT '0.00',
  `cenaZgloszenia` float(8,2) DEFAULT '0.00',
  `visible` enum('0','1') DEFAULT '1',
  `done` enum('0','1') DEFAULT '0',
  `doneAdmin` int(10) DEFAULT '0',
  `adminId` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zgloszeniaDetails`
--

INSERT INTO `zgloszeniaDetails` VALUES (28,NULL,NULL,45,230.00,5.00,5.00,3,NULL,0.00,0.00,0.00,'1','0',0,0),(29,NULL,NULL,46,510.00,1.40,5.00,1,NULL,0.00,0.00,0.00,'1','0',0,0),(32,NULL,NULL,49,510.00,1.40,5.00,1,NULL,0.00,0.00,0.00,'1','1',1,0),(33,NULL,NULL,50,510.00,1.40,5.00,1,NULL,0.00,0.00,0.00,'1','0',0,0),(36,NULL,NULL,53,230.00,5.00,5.00,3,NULL,0.00,0.00,0.00,'1','0',0,0),(37,NULL,NULL,54,510.00,1.40,5.00,1,NULL,0.00,0.00,0.00,'1','0',0,0),(38,NULL,NULL,54,120.00,10.00,20.00,2,NULL,0.00,0.00,0.00,'1','0',0,0),(39,NULL,NULL,54,230.00,5.00,5.00,3,NULL,0.00,0.00,0.00,'1','0',0,0),(40,NULL,NULL,55,510.00,1.40,5.00,1,NULL,0.00,0.00,0.00,'1','0',0,0),(41,NULL,NULL,55,120.00,10.00,20.00,2,NULL,0.00,0.00,0.00,'1','0',0,0),(44,NULL,NULL,58,230.00,5.00,5.00,3,NULL,0.00,0.00,0.00,'1','0',0,0),(52,NULL,NULL,62,510.00,1.40,5.00,1,NULL,0.00,0.00,0.00,'1','0',0,0),(53,NULL,NULL,62,120.00,10.00,20.00,2,NULL,0.00,0.00,0.00,'1','0',0,0),(54,NULL,NULL,62,230.00,5.00,5.00,3,NULL,0.00,0.00,0.00,'1','0',0,0),(55,NULL,NULL,65,510.00,1.40,5.00,1,NULL,500.00,10.00,0.00,'1','1',1,0),(56,NULL,NULL,65,230.00,5.00,5.00,3,NULL,200.00,30.00,0.00,'1','1',1,0),(57,'Modyfikacja',NULL,66,120.00,10.00,20.00,2,NULL,100.00,20.00,4.00,'1','0',0,0),(60,'Usunięcie DPF-a',NULL,66,510.00,1.40,5.00,1,NULL,500.00,10.00,5.00,'0','0',0,1),(61,'Modyfikacja',NULL,65,120.00,10.00,20.00,2,NULL,100.00,20.00,0.00,'1','1',1,1),(62,'Usunięcie DPF-a',NULL,67,510.00,1.40,5.00,1,NULL,500.00,10.00,4.00,'1','1',1,0),(63,'Modyfikacja',NULL,49,120.00,10.00,20.00,2,NULL,100.00,20.00,50.00,'1','1',1,1),(64,'Usunięcie DPF-a',NULL,68,510.00,1.40,5.00,1,NULL,500.00,10.00,0.00,'1','1',1,0),(65,'Modyfikacja',NULL,68,120.00,10.00,20.00,2,NULL,100.00,20.00,0.00,'1','1',1,0),(66,'Blue',NULL,68,230.00,5.00,5.00,3,NULL,200.00,30.00,0.00,'1','0',0,0),(67,'Usunięcie DPF-a',NULL,69,510.00,1.40,5.00,1,NULL,500.00,10.00,0.00,'1','1',1,0),(68,'Modyfikacja',NULL,69,110.00,10.00,20.00,2,NULL,100.00,10.00,0.00,'1','1',1,0),(69,'Blue',NULL,69,210.00,5.00,5.00,3,NULL,200.00,10.00,0.00,'1','0',0,0);

--
-- Table structure for table `zgloszeniaStatus`
--

CREATE TABLE `zgloszeniaStatus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazwa` varchar(255) DEFAULT NULL,
  `opis` text,
  `pozycja` int(11) DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `adminId` int(10) DEFAULT NULL,
  `data` datetime DEFAULT NULL,
  `zgloszenieId` int(11) DEFAULT NULL,
  `public` enum('0','1') DEFAULT '0',
  `file` varchar(255) DEFAULT NULL,
  `dir` varchar(255) DEFAULT NULL,
  `orgFileName` varchar(255) DEFAULT NULL,
  `msgType` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zgloszeniaStatus`
--

INSERT INTO `zgloszeniaStatus` VALUES (1,'Nie zalogowany',NULL,NULL,4,NULL,'2017-03-13 18:50:08',37,'0',NULL,NULL,NULL,NULL),(2,'Nowe zgłoszenie dodane do systemu',NULL,NULL,4,NULL,'2017-03-13 18:55:44',38,'0',NULL,NULL,NULL,NULL),(3,'Nowe zgłoszenie dodane do systemu',NULL,NULL,4,NULL,'2017-03-13 20:23:24',45,'1',NULL,NULL,NULL,NULL),(4,'Nowe zgłoszenie dodane do systemu',NULL,NULL,4,NULL,'2017-03-13 20:25:57',46,'1',NULL,NULL,NULL,NULL),(5,'Nowe zgłoszenie dodane do systemu',NULL,NULL,4,NULL,'2017-03-13 20:27:29',49,'1',NULL,NULL,NULL,NULL),(6,'Nowe zgłoszenie dodane do systemu',NULL,NULL,4,NULL,'2017-03-13 20:27:48',50,'1',NULL,NULL,NULL,NULL),(7,'Nowe zgłoszenie dodane do systemu',NULL,NULL,4,NULL,'2017-03-13 20:29:32',53,'1','7bb347419477d383e586bd89645af5e6d514f326.jpeg',NULL,NULL,NULL),(8,'Nowe zgłoszenie dodane do systemu',NULL,NULL,4,NULL,'2017-03-13 20:32:16',54,'1','b4ba5a867658105f79221cac56bd4fd6cae3faac.jpg','f437aecb3d5f3f9a5f0fab335ff8144d',NULL,NULL),(9,'Nowe zgłoszenie dodane do systemu','test opis',NULL,4,NULL,'2017-03-13 22:09:42',55,'1',NULL,NULL,NULL,NULL),(10,'Nowe zgłoszenie dodane do systemu','uuuuu',NULL,4,NULL,'2017-03-13 22:53:36',58,'1','0f8b462567150f7dcb9a786f1786179f43de9807.jpg','770565010185bdbfe4f68ef771ae121b',NULL,'new'),(11,'Nowe zgłoszenie dodane do systemu','dodatkowy opis',NULL,4,NULL,'2017-03-13 22:58:37',62,'1','f518d483034daa6ec5bb12c470ff5bc0ace449d4.jpg','7b3dac7e5814ef16b11ba505bc63319c','altek.jpg','new'),(12,NULL,'message',NULL,4,NULL,'2017-03-20 19:21:15',62,'1',NULL,NULL,NULL,'user'),(13,NULL,'cześć z plikiem',NULL,4,NULL,'2017-03-20 19:25:13',62,'1','a39b895841184793381415834e14b9afbb731c76.jpg','f388086d4c6fcc61b544f5eb75049d7c','workshopcrew.jpg','user'),(14,NULL,'zmiana danych pojazdu',NULL,NULL,NULL,'2017-03-20 22:36:49',62,'1',NULL,NULL,NULL,NULL),(15,NULL,'zmiana danych pojazdu',NULL,NULL,1,'2017-03-20 22:39:11',62,'1',NULL,NULL,NULL,NULL),(16,NULL,'Zmiana danych pojazdu',NULL,NULL,1,'2017-03-20 22:45:08',62,'1',NULL,NULL,NULL,NULL),(17,NULL,NULL,NULL,NULL,1,'2017-03-20 22:49:25',NULL,'1',NULL,NULL,NULL,'admin'),(18,NULL,'cześć 2',NULL,NULL,1,'2017-03-20 22:54:15',62,'1',NULL,NULL,NULL,'admin'),(20,NULL,'wiadomość wewnętrzna',NULL,NULL,1,'2017-03-20 23:03:55',62,'0',NULL,NULL,NULL,'local'),(21,NULL,'hhh',NULL,NULL,1,'2017-03-20 23:23:18',62,'0',NULL,NULL,NULL,'local'),(22,NULL,'test',NULL,NULL,1,'2017-03-20 23:26:53',62,'0',NULL,NULL,NULL,'local'),(23,NULL,'test',NULL,NULL,1,'2017-03-20 23:34:04',62,'0','b35c38bdc92a9dd11a4bb5e52581d3e770e73857.jpeg',NULL,NULL,'local'),(24,NULL,'czesc',NULL,NULL,1,'2017-03-20 23:39:50',62,'0','2183f813663ab39290b6e86c82a0c2beae46e2a6.jpg','7b3dac7e5814ef16b11ba505bc63319c','.','local'),(25,NULL,'hhhh',NULL,NULL,1,'2017-03-20 23:41:38',62,'0','e225641e7efed9b2de18b09aaa7a8f35c97d1826.bmp','7b3dac7e5814ef16b11ba505bc63319c','cccp.bmp.jpg','local'),(26,NULL,'Zmiana danych pojazdu',NULL,NULL,1,'2017-03-20 23:44:20',62,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(27,'Nowe zgłoszenie dodane do systemu','opis pojazdu',NULL,4,NULL,'2017-03-20 23:52:19',65,'1','587a042942f989481d481f656161f16f8924bfc6.jpg','52d7b35e5ad0ab0e152446dd8c3640f0','x_9d900ab0.jpg','new'),(28,NULL,'Zmieniła się wycena usług\n\n',NULL,NULL,1,'2017-03-21 21:48:13',65,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(29,NULL,'Zmieniła się ilość zamówionych usług\n\nZmieniła się wycena usług\n\n',NULL,NULL,1,'2017-03-21 21:48:34',65,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(30,NULL,'Zmieniła się ilość zamówionych usług<br>Zmieniła się wycena usług<br>',NULL,NULL,1,'2017-03-21 21:50:04',65,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(31,'Nowe zgłoszenie dodane do systemu','jakiś opis',NULL,4,NULL,'2017-03-21 21:54:55',66,'1',NULL,NULL,NULL,'new'),(32,NULL,'Zmieniła się ilość zamówionych usług<br>',NULL,NULL,1,'2017-03-21 21:56:18',66,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(33,NULL,'Zmieniła się ilość zamówionych usług<br>',NULL,NULL,1,'2017-03-21 21:59:05',66,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(34,NULL,'Zmieniła się ilość zamówionych usług<br>Zmieniła się wycena usług<br>',NULL,NULL,1,'2017-03-21 21:59:21',66,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(35,NULL,'Zmieniła się ilość zamówionych usług<br>',NULL,NULL,1,'2017-03-21 22:02:52',66,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(36,NULL,'Zmieniła się ilość zamówionych usług<br>',NULL,NULL,1,'2017-03-21 22:04:32',66,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(37,NULL,'Zmieniła się ilość zamówionych usług<br>Zmieniła się wycena usług<br>',NULL,NULL,1,'2017-03-21 22:05:16',66,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(38,NULL,'Zmieniła się ilość zamówionych usług<br>',NULL,NULL,1,'2017-03-21 22:05:44',66,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(39,NULL,'Zmieniła się ilość zamówionych usług<br>',NULL,NULL,1,'2017-03-21 22:06:51',66,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(40,NULL,NULL,NULL,NULL,1,'2017-03-21 22:10:44',66,'1',NULL,NULL,NULL,'admin'),(41,NULL,'coś podobnego',NULL,NULL,1,'2017-03-21 22:22:13',66,'1',NULL,NULL,NULL,'admin'),(42,NULL,'Zmieniła się ilość zamówionych usług<br>',NULL,NULL,1,'2017-03-21 23:07:57',66,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(43,NULL,'Zmieniła się wycena usług<br>',NULL,NULL,1,'2017-03-21 23:09:40',66,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(44,NULL,'Zmieniła się wycena usług<br>',NULL,NULL,1,'2017-03-22 18:28:52',65,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(45,NULL,'Zmiana statusu zgłoszenia',NULL,NULL,1,'2017-03-22 18:28:52',65,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(46,NULL,'Zmiana statusu zgłoszenia',NULL,NULL,1,'2017-03-22 18:29:57',65,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(47,NULL,'Zmiana statusu zgłoszenia Array',NULL,NULL,1,'2017-03-22 18:33:03',65,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(48,NULL,'Zmiana statusu zgłoszenia Zgłoszenie zamknięte',NULL,NULL,1,'2017-03-22 18:33:32',65,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(49,NULL,'nie zgadzam sie',NULL,4,NULL,'2017-03-22 18:40:44',65,'1',NULL,NULL,NULL,'user'),(50,NULL,'dlaczego nie ?',NULL,NULL,1,'2017-03-22 18:41:39',65,'1',NULL,NULL,NULL,'admin'),(51,NULL,'nie',NULL,4,NULL,'2017-03-22 18:43:42',65,'1',NULL,NULL,NULL,'user'),(52,NULL,'Zmiana statusu zgłoszenia: Zgłoszenie zamknięte',NULL,NULL,1,'2017-03-22 18:44:28',65,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(53,NULL,'Zmiana statusu zgłoszenia: ',NULL,4,NULL,'2017-03-22 18:44:47',65,'1',NULL,NULL,NULL,'user'),(54,NULL,'otwieram\r\n',NULL,4,NULL,'2017-03-22 18:44:47',65,'1',NULL,NULL,NULL,'user'),(55,NULL,'Zmiana statusu zgłoszenia: Zgłoszenie zamknięte',NULL,NULL,1,'2017-03-22 18:45:50',65,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(56,NULL,'Zmiana statusu zgłoszenia: Zgłoszenie otwarte',NULL,4,NULL,'2017-03-22 18:46:08',65,'1',NULL,NULL,NULL,'user'),(57,NULL,'nie\r\n',NULL,4,NULL,'2017-03-22 18:46:08',65,'1',NULL,NULL,NULL,'user'),(58,NULL,'Zmiana statusu zgłoszenia: Zgłoszenie zamknięte',NULL,NULL,1,'2017-03-22 18:46:45',65,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(59,NULL,'Zmieniła się ilość zamówionych usług<br>',NULL,NULL,1,'2017-03-22 18:47:13',65,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(60,NULL,'Zmiana danych pojazdu',NULL,NULL,1,'2017-03-22 18:53:11',63,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(61,NULL,'Zmiana statusu zgłoszenia: Zgłoszenie zamknięte',NULL,NULL,1,'2017-03-22 18:53:11',63,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(62,'Nowe zgłoszenie dodane do systemu','yyyy',NULL,5,NULL,'2017-03-22 19:25:24',67,'1',NULL,NULL,NULL,'new'),(63,NULL,'Zmiana statusu zgłoszenia: Zgłoszenie otwarte',NULL,NULL,1,'2017-03-22 19:26:32',67,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(64,NULL,'Zmieniła się wycena usług<br>',NULL,NULL,1,'2017-03-22 19:27:54',67,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(65,NULL,'Zmiana statusu zgłoszenia: Zgłoszenie zamknięte',NULL,NULL,1,'2017-03-22 19:27:54',67,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(66,NULL,'Zmiana statusu zgłoszenia: Zgłoszenie otwarte',NULL,NULL,1,'2017-03-22 19:37:36',46,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(67,NULL,'Zmieniła się wycena usług<br>',NULL,NULL,1,'2017-03-22 19:58:22',65,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(68,NULL,'Zmiana statusu zgłoszenia: Zgłoszenie otwarte',NULL,NULL,1,'2017-03-22 19:59:25',49,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(69,NULL,'Zmieniła się ilość zamówionych usług<br>',NULL,NULL,1,'2017-03-22 20:00:17',49,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(70,'Nowe zgłoszenie dodane do systemu','test',NULL,4,NULL,'2017-03-22 20:21:27',68,'1',NULL,NULL,NULL,'new'),(71,NULL,'Zmiana statusu zgłoszenia: Zgłoszenie otwarte',NULL,NULL,1,'2017-03-22 20:22:16',68,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL),(72,'Nowe zgłoszenie dodane do systemu','test',NULL,5,NULL,'2017-03-22 20:23:15',69,'1',NULL,NULL,NULL,'new'),(73,NULL,'Zmiana statusu zgłoszenia: Zgłoszenie otwarte',NULL,NULL,1,'2017-03-22 20:24:40',69,'1',NULL,'f388086d4c6fcc61b544f5eb75049d7c','.',NULL);


