-- MySQL dump 10.17  Distrib 10.3.17-MariaDB, for Linux (x86_64)
--
-- Host: mysql    Database: restore
-- ------------------------------------------------------
-- Server version	10.4.11-MariaDB-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `egw_pm_projects`
--

DROP TABLE IF EXISTS `egw_pm_projects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `egw_pm_projects` (
  `pm_id` int(11) NOT NULL AUTO_INCREMENT,
  `pm_number` varchar(64) NOT NULL,
  `pm_title` varchar(255) NOT NULL,
  `pm_description` text DEFAULT NULL,
  `pm_creator` int(11) NOT NULL,
  `pm_created` bigint(20) NOT NULL,
  `pm_modifier` int(11) DEFAULT NULL,
  `pm_modified` bigint(20) DEFAULT NULL,
  `pm_planned_start` bigint(20) DEFAULT NULL,
  `pm_planned_end` bigint(20) DEFAULT NULL,
  `pm_real_start` bigint(20) DEFAULT NULL,
  `pm_real_end` bigint(20) DEFAULT NULL,
  `cat_id` int(11) DEFAULT 0,
  `pm_access` varchar(7) DEFAULT 'public',
  `pm_priority` smallint(6) DEFAULT 1,
  `pm_status` varchar(9) DEFAULT 'active',
  `pm_completion` smallint(6) DEFAULT 0,
  `pm_used_time` int(11) DEFAULT NULL,
  `pm_planned_time` int(11) DEFAULT NULL,
  `pm_replanned_time` int(11) DEFAULT NULL,
  `pm_used_budget` decimal(20,2) DEFAULT NULL,
  `pm_planned_budget` decimal(20,2) DEFAULT NULL,
  `pm_overwrite` int(11) DEFAULT 0,
  `pm_accounting_type` varchar(10) DEFAULT 'times',
  PRIMARY KEY (`pm_id`),
  UNIQUE KEY `egw_pm_projects_number` (`pm_number`),
  KEY `egw_pm_projects_title` (`pm_title`)
) ENGINE=InnoDB AUTO_INCREMENT=1574 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `egw_pm_projects`
--

LOCK TABLES `egw_pm_projects` WRITE;
/*!40000 ALTER TABLE `egw_pm_projects` DISABLE KEYS */;
INSERT INTO `egw_pm_projects` VALUES (1,'P-2014-0001','Project P-2014-0001: test',NULL,6,1413826017,6,1422554267,1412114400,1527843840,1412114400,1527843840,NULL,'public',1,'active',73,3867,2640,0,2133.33,1000.00,1032,'pricelist'),(2,'P-2014-0001/0001','Project P-2014-0001/0001',NULL,6,1413826037,6,1413826210,1412114400,1414710000,1467324000,1479213660,NULL,'public',1,'active',28,120,960,0,0.00,0.00,1184,'pricelist'),(3,'P-2014-0001/0002','Project P-2014-0001/0002','some testing ...',6,1413826052,6,1425570017,1413756000,1416252600,1428357600,1472220900,NULL,'public',1,'active',0,780,0,0,0.00,NULL,1187,'pricelist'),(4,'P-2014-0002','Project P-2014-0002',NULL,6,1413826070,6,1463649902,1412114400,1473433200,1412028000,1419912000,110,'public',1,'active',12,45539,60377,0,0.00,0.00,132416,'times'),(6,'P-2014-0002/0001','Project P-2014-0002/0001',NULL,6,1413826110,6,1462542137,1412114400,1414974600,1413514800,1415332800,110,'public',1,'active',20,30240,797,NULL,NULL,NULL,132583,'times'),(7,'P-2014-0002/0002','Project P-2014-0002/0002','some testing ...',6,1413826126,6,1462542137,1413757800,1416695400,NULL,NULL,110,'public',1,'active',0,NULL,48960,NULL,NULL,NULL,1187,'times'),(8,'P-2014-0001/0003','Project P-2014-0001/0003',NULL,6,1415012948,6,1423575862,1415001600,1476723060,1415001600,1476723060,NULL,'public',1,'active',100,1105,720,0,0.00,NULL,1024,'pricelist'),(9,'P-2014-0002/0003','Project P-2014-0002/0003: test',NULL,6,1416334132,6,1452763408,1414355400,1471619700,1414355400,1471619700,NULL,'public',1,'active',100,4800,NULL,NULL,0.00,NULL,1124,'times'),(10,'P-2015-0001','Project P-2015-0001',NULL,6,1422552918,6,1462542137,1312539666,1423664580,1312539666,1423664580,110,'public',1,'active',30,570,0,0,NULL,NULL,1024,'times'),(11,'P-2015-0002','Project P-2015-0002','some testing ...',9,1422979955,9,1422979955,1443477600,NULL,1443477600,NULL,NULL,'public',1,'active',0,0,0,0,NULL,NULL,1024,'status'),(12,'P-2015-0003','Project P-2015-0003',NULL,6,1423665116,6,1473339153,1417647600,1511800980,1423609200,1511800980,NULL,'public',1,'active',100,495,0,0,40.00,0.00,1024,'pricelist'),(13,'P-2015-0004','Project P-2015-0004: test',NULL,6,1428936847,6,1428936885,1524658680,1524665880,1524658680,1524665880,NULL,'public',1,'archive',100,120,NULL,NULL,0.00,NULL,1024,'status'),(14,'P-2015-0005','Project P-2015-0005',NULL,7,1434466804,7,1434466804,1434319200,1438084038,1434319200,1438084038,NULL,'public',1,'template',100,0,0,0,NULL,NULL,1024,'status'),(15,'P-2015-0006','Project P-2015-0006','some testing ...',7,1434466891,7,1434466891,1436738400,1438084140,1436738400,NULL,NULL,'public',1,'active',90,0,0,0,NULL,NULL,1024,'status'),(18,'V-2016-0001','Project V-2016-0001',NULL,6,1437671060,6,1469018225,1464732000,1467324000,NULL,NULL,NULL,'public',1,'template',10,0,960,0,0.00,0.00,1184,'status'),(21,'P-2015-0007','Project P-2015-0007: test',NULL,6,1437671170,6,1469780931,1469656800,1484060040,1476715560,1484060040,110,'public',1,'active',67,420,960,0,0.00,0.00,132096,'status'),(24,'P-2016-0001','Project P-2016-0001',NULL,6,1453370280,6,1453370484,NULL,NULL,NULL,NULL,NULL,'public',1,'active',40,NULL,NULL,NULL,NULL,NULL,1025,'pricelist'),(26,'P-2016-0002','Project P-2016-0002',NULL,6,1461230341,6,1461844330,1461535200,1461794400,1461708000,1572367620,NULL,'public',1,'active',50,0,1440,0,0.00,0.00,1184,'times'),(33,'P-2016-0003','Project P-2016-0003: test',NULL,6,1461853067,6,1463671833,1461794400,NULL,NULL,NULL,110,'public',1,'active',0,NULL,4800,NULL,NULL,NULL,132130,'times'),(36,'P-2016-0004','Project P-2016-0004',NULL,6,1465476297,6,1465476297,1465336800,1465398000,NULL,NULL,NULL,'public',1,'active',0,0,480,0,0.00,0.00,1024,'status'),(39,'P-2016-0005','Project P-2016-0005','some testing ...',6,1467021730,6,1467021730,1467007560,1476722252,1467007560,1476722252,NULL,'public',1,'active',100,510,0,0,0.00,0.00,1024,'times'),(42,'P-2016-0005/0001','Project P-2016-0005/0001',NULL,6,1467021797,6,1467021797,1467014700,1472205120,1467014700,1472205120,NULL,'public',1,'active',100,210,0,0,0.00,0.00,1024,'times'),(45,'P-2016-0005/0002','Project P-2016-0005/0002: test',NULL,6,1467021837,6,1467021837,1467014760,1476722252,1467014760,1476722252,NULL,'public',1,'active',100,60,0,0,0.00,0.00,1024,'times'),(52,'P-2016-0006','Project P-2016-0006',NULL,6,1469018018,6,1469018018,1467376380,1470002400,1472137920,1472141520,NULL,'public',1,'active',100,60,NULL,NULL,0.00,NULL,1184,'status'),(56,'V-2016-0002','Project V-2016-0002',NULL,6,1469018109,6,1469018201,1464818400,1464991140,1464732000,1467324000,NULL,'public',1,'template',10,0,960,0,0.00,0.00,1344,'status'),(96,'P-2014-0001/0001/0001','Project P-2014-0001/0001/0001',NULL,6,1469193399,6,1469193399,1467410400,1467990000,1467324000,1470002400,NULL,'public',1,'active',10,0,960,0,0.00,0.00,1344,'status'),(104,'P-2016-0007','Project P-2016-0007',NULL,5,1474031842,5,1474031842,1464732000,1467324000,1476722580,1476729780,NULL,'public',1,'active',40,120,960,0,0.00,0.00,1184,'status'),(108,'P-2016-0008','Project P-2016-0008',NULL,5,1474032047,5,1474032047,1474032000,1476710400,NULL,NULL,NULL,'public',1,'active',10,0,960,0,0.00,0.00,1184,'status'),(112,'P-2016-0009','Project P-2016-0009',NULL,5,1474032154,6,1515678562,1475272800,1477954800,1476977400,1476999000,NULL,'public',1,'template',55,360,960,0,0.00,0.00,1184,'status'),(114,'P-2016-0010','Project P-2016-0010',NULL,6,1474992557,6,1515678562,1472680800,1475272800,NULL,NULL,NULL,'public',1,'template',10,0,960,0,0.00,0.00,1184,'status'),(118,'P-2016-0011','Project P-2016-0011',NULL,6,1474992685,6,1474992685,1474215000,1476977400,1474128600,1476807060,NULL,'public',1,'active',78,300,960,0,0.00,0.00,1344,'status'),(126,'Halli-Galli','Project Halli-Galli',NULL,6,1475057601,6,1487002138,1484175600,1484175600,1484052840,1484262000,138,'public',1,'active',100,120,960,0,0.00,0.00,132514,'times'),(131,'P-2016-0012','Project P-2016-0012','some testing ...',7,1481737954,7,1481737954,1434319200,1438084038,NULL,1438084038,NULL,'public',1,'active',100,0,0,0,0.00,0.00,1024,'status'),(139,'P-2016-0013','Project P-2016-0013','some testing ...',7,1482170177,7,1482170177,1434319200,1438084038,NULL,1438084038,NULL,'public',1,'active',100,0,0,0,0.00,0.00,1024,'status'),(141,'P-2017-0001','Project P-2017-0001: test',NULL,76,1484928193,76,1492602458,1487286000,1487286000,1487286000,1487286000,NULL,'public',1,'active',3,1440,0,0,0.00,0.00,1508,'status'),(145,'P-2017-0001/0001','Project P-2017-0001/0001: test',NULL,76,1484928418,76,1487274045,1483398000,1483570800,1484925333,NULL,NULL,'public',1,'active',0,NULL,NULL,NULL,NULL,NULL,1184,'status'),(153,'P-2017-0002','Project P-2017-0002: test',NULL,18,1485185368,6,1515678562,1485185401,NULL,1485185401,NULL,NULL,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'status'),(161,'P-2017-0003','Project P-2017-0003: test',NULL,6,1485945992,101,1487273005,NULL,NULL,NULL,NULL,NULL,'public',1,'active',0,NULL,NULL,NULL,NULL,NULL,1024,'status'),(165,'PTX-2019-0004','Project PTX-2019-0004: test',NULL,101,1492603134,6,1574692876,NULL,NULL,NULL,NULL,1378,'public',1,'active',0,NULL,NULL,NULL,NULL,NULL,132096,'status'),(171,'P-2017-0005','Project P-2017-0005','some testing ...',6,1494560486,6,1494560499,1511823600,1511958619,NULL,1511958619,NULL,'public',1,'active',100,0,0,0,0.00,0.00,1024,'status'),(174,'P-2017-0006','Project P-2017-0006',NULL,6,1494560522,6,1494560522,1505858400,1510009200,NULL,NULL,NULL,'public',1,'active',0,0,60,0,0.00,0.00,1024,'status'),(177,'P-2017-0007','Project P-2017-0007: test',NULL,6,1494560550,6,1516031620,NULL,NULL,1515625200,1515711600,NULL,'public',1,'active',0,0,0,0,NULL,NULL,1344,'times'),(183,'P-2017-0008','Project P-2017-0008','some testing ...',6,1496324365,6,1496324365,1512514800,NULL,NULL,NULL,NULL,'public',1,'active',0,0,0,0,0.00,0.00,66566,'status'),(186,'P-2017-0009','Project P-2017-0009',NULL,6,1496324365,6,1496324365,1504389600,NULL,NULL,NULL,NULL,'public',1,'active',0,0,0,0,0.00,0.00,66566,'status'),(189,'P-2017-0010','Project P-2017-0010: test',NULL,6,1496324365,6,1496324365,NULL,NULL,NULL,NULL,NULL,'public',1,'active',0,0,0,0,NULL,NULL,66566,'status'),(195,'P-2017-0011','Project P-2017-0011','some testing ...',5,1498877826,6,1512384176,1504389600,1511800740,1511797080,1511800740,1091,'public',1,'active',100,90,0,0,0.00,0.00,132096,'times'),(198,'469','Project 469',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(201,'485','Project 485: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(204,'920','Project 920',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(207,'8067301','Project 8067301','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(210,'8097300','Project 8097300',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(213,'11717610','Project 11717610: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(216,'11767611','Project 11767611',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(219,'12047702','Project 12047702','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(222,'15167911','Project 15167911',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(225,'17048211','Project 17048211: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(228,'18458406','Project 18458406',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(231,'18728411','Project 18728411','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(234,'21388707','Project 21388707',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(237,'21568710','Project 21568710: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(240,'25109006','Project 25109006',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(243,'25669104','Project 25669104','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(246,'26079110','Project 26079110',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(249,'26759207','Project 26759207: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(252,'27029210','Project 27029210',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(255,'27389303','Project 27389303','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(258,'27529304','Project 27529304',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(261,'27639305','Project 27639305: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(264,'28229401','Project 28229401',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(267,'28579406','Project 28579406','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(270,'28779408','Project 28779408',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(273,'28969411','Project 28969411: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(276,'29209503','Project 29209503',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(279,'29729508','Project 29729508','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(282,'29769509','Project 29769509',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(285,'30069602','Project 30069602: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(288,'30249604','Project 30249604',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(291,'30829610','Project 30829610','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(294,'31409703','Project 31409703',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(297,'31779707','Project 31779707: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(300,'31789707','Project 31789707',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(303,'31809707','Project 31809707','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(306,'32489712','Project 32489712',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(309,'32559801','Project 32559801: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(312,'32579801','Project 32579801',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(315,'32659802','Project 32659802','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(318,'33219803','Project 33219803',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(321,'33489804','Project 33489804: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(324,'33509804','Project 33509804',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(327,'33519804','Project 33519804','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(330,'33529804','Project 33529804',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(333,'34379809','Project 34379809: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(336,'34559810','Project 34559810',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(339,'34569811','Project 34569811','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(342,'34659811','Project 34659811',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(345,'34789812','Project 34789812: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(348,'34929901','Project 34929901',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(351,'35819908','Project 35819908','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(354,'36059909','Project 36059909',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(357,'36600001','Project 36600001: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(360,'37240006','Project 37240006',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(363,'37640008','Project 37640008','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(366,'37790009','Project 37790009',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(369,'37800010','Project 37800010: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(372,'37930011','Project 37930011',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(375,'37950011','Project 37950011','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(378,'38200101','Project 38200101',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(381,'38210101','Project 38210101: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(384,'38340103','Project 38340103',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(387,'38610104','Project 38610104','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(390,'38640105','Project 38640105',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(393,'38650105','Project 38650105: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(396,'38710106','Project 38710106',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(399,'38950107','Project 38950107','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(402,'39070108','Project 39070108',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(405,'39190109','Project 39190109: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(408,'39480111','Project 39480111',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(411,'39510112','Project 39510112','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(414,'39770201','Project 39770201',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(417,'40030203','Project 40030203: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(420,'40080204','Project 40080204',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(423,'40150204','Project 40150204','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(426,'40200204','Project 40200204',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(429,'40250205','Project 40250205: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(432,'40290205','Project 40290205',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(435,'40470206','Project 40470206','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(438,'40560206','Project 40560206',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(441,'40840208','Project 40840208: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(444,'40860208','Project 40860208',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(447,'40870208','Project 40870208','some testing ...',5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(450,'41100210','Project 41100210',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(453,'41110210','Project 41110210: test',NULL,5,1498877826,6,1515678562,NULL,NULL,NULL,NULL,0,'public',1,'template',0,NULL,NULL,NULL,NULL,NULL,1024,'times'),(458,'P-2017-0012','Project P-2017-0012',NULL,6,1512654133,6,1515678562,1464732000,1467324000,NULL,NULL,NULL,'public',1,'template',10,0,960,0,0.00,0.00,1184,'status'),(464,'P-2017-0013','Project P-2017-0013',NULL,6,1513010035,6,1513010035,1464732000,1467324000,NULL,NULL,NULL,'public',1,'active',10,0,960,0,0.00,0.00,1184,'status'),(467,'P-2017-0014','Project P-2017-0014','some testing ...',6,1513010175,6,1513010175,1464732000,1467324000,NULL,NULL,NULL,'public',1,'active',10,0,960,0,0.00,0.00,1184,'status'),(473,'P-2017-0015','Project P-2017-0015: test',NULL,6,1513336759,6,1513336759,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,0,0,0,NULL,NULL,1024,'status'),(479,'P-2018-0001','Project P-2018-0001','some testing ...',6,1515675387,6,1515675387,1464732000,1467324000,NULL,NULL,NULL,'public',1,'active',10,0,960,0,0.00,0.00,1184,'status'),(482,'P-2018-0002','Project P-2018-0002',NULL,6,1515678644,6,1515678644,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,0,0,0,NULL,NULL,1024,'times'),(486,'P-2018-0003','Project P-2018-0003',NULL,5,1516031672,5,1516031792,1524495056,1524666060,1515625200,1515711600,NULL,'public',1,'active',90,120,NULL,NULL,0.00,NULL,1344,'times'),(492,'P-2018-0004','Project P-2018-0004',NULL,6,1516287859,6,1516287859,1464732000,1467324000,1524662400,1524666000,NULL,'public',1,'active',40,60,960,0,0.00,0.00,1184,'status'),(495,'__Vorlage__','Project __Vorlage__','some testing ...',6,1516288189,6,1516288354,1514761200,NULL,NULL,NULL,NULL,'public',1,'template',0,0,0,0,0.00,0.00,1024,'times'),(498,'P-2018-0005','Project P-2018-0005',NULL,6,1516288521,6,1516288521,1514761200,NULL,NULL,NULL,NULL,'public',1,'active',0,0,0,0,0.00,0.00,1024,'times'),(502,'P-2018-0006','Project P-2018-0006',NULL,6,1517235039,6,1517235039,1464732000,1467324000,NULL,NULL,NULL,'public',1,'active',0,NULL,NULL,NULL,NULL,NULL,1184,'status'),(505,'P-2018-0007','Project P-2018-0007: test',NULL,6,1517235174,6,1517235174,1514761200,NULL,NULL,NULL,NULL,'public',1,'active',0,0,0,0,0.00,0.00,1024,'times'),(510,'P-2018-0008','Project P-2018-0008',NULL,6,1520270563,6,1559576393,1523438400,1569502800,1523438400,1559575908,NULL,'public',1,'active',82,240,1320,0,0.00,0.00,1024,'times'),(515,'P-2018-0009','Project P-2018-0009','some testing ...',6,1539102730,5,1565272485,NULL,NULL,NULL,NULL,1378,'public',1,'archive',0,NULL,NULL,NULL,NULL,NULL,132096,'status'),(519,'P-2019-01','Project P-2019-01','some testing ...',6,1549630840,6,1549630868,1549494000,1553608282,NULL,1553608282,NULL,'private',1,'active',100,0,0,0,0.00,0.00,1024,'status'),(591,'P-2019-0001','Project P-2019-0001','some testing ...',251,1564484602,251,1564484602,NULL,NULL,NULL,NULL,1408,'public',1,'active',NULL,0,0,0,NULL,NULL,132096,'status'),(611,'P-2019-0002','Project P-2019-0002','some testing ...',193,1565799397,193,1565799397,NULL,NULL,NULL,NULL,1378,'public',1,'active',0,NULL,NULL,NULL,NULL,NULL,132096,'status'),(621,'P-2019-0002/0001','Project P-2019-0002/0001: test',NULL,193,1565799422,193,1565799422,NULL,NULL,NULL,NULL,1378,'public',1,'active',NULL,NULL,NULL,NULL,NULL,NULL,132096,'status'),(651,'P-2019-0003','Project P-2019-0003','some testing ...',22,1565860579,22,1565860579,NULL,NULL,NULL,NULL,1378,'public',1,'active',0,NULL,NULL,NULL,NULL,NULL,132096,'status'),(661,'P-2019-0003/0001','Project P-2019-0003/0001: test',NULL,22,1565860600,22,1565860600,NULL,NULL,NULL,NULL,1378,'public',1,'active',NULL,NULL,NULL,NULL,NULL,NULL,132096,'status'),(681,'P-2019-0004','Project P-2019-0004: test',NULL,40,1565860923,40,1565860923,NULL,NULL,NULL,NULL,1378,'public',1,'active',NULL,0,0,0,NULL,NULL,132096,'status'),(711,'P-2019-0005/0001','Project P-2019-0005/0001','some testing ...',26,1565861318,26,1565861320,NULL,NULL,NULL,NULL,160,'public',1,'active',0,NULL,NULL,NULL,NULL,NULL,132096,'status'),(741,'P-2018-0008/0001','Project P-2018-0008/0001: test',NULL,5,1567504435,5,1567504435,1569333600,1569502800,NULL,NULL,138,'public',1,'active',0,0,360,0,NULL,NULL,132096,'times'),(751,'P-2018-0008/0001/0001','Project P-2018-0008/0001/0001','some testing ...',5,1567504951,5,1567504951,1569333600,NULL,NULL,NULL,138,'public',1,'active',NULL,0,0,0,NULL,NULL,132096,'times'),(791,'P-2019-0013','Project P-2019-0013','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,0,0,0,NULL,NULL,66566,'status'),(801,'P-2019-0014','Project P-2019-0014: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,1,1,1,NULL,NULL,66566,'status'),(811,'P-2019-0015','Project P-2019-0015','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,2,2,2,NULL,NULL,66566,'status'),(821,'P-2019-0016','Project P-2019-0016: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,3,3,3,NULL,NULL,66566,'status'),(831,'P-2019-0017','Project P-2019-0017','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,4,4,4,NULL,NULL,66566,'status'),(841,'P-2019-0018','Project P-2019-0018: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,5,5,5,NULL,NULL,66566,'status'),(851,'P-2019-0019','Project P-2019-0019','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,6,6,6,NULL,NULL,66566,'status'),(861,'P-2019-0020','Project P-2019-0020: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,7,7,7,NULL,NULL,66566,'status'),(871,'P-2019-0021','Project P-2019-0021','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,8,8,8,NULL,NULL,66566,'status'),(881,'P-2019-0022','Project P-2019-0022: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,9,9,9,NULL,NULL,66566,'status'),(891,'P-2019-0023','Project P-2019-0023','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,10,10,10,NULL,NULL,66566,'status'),(901,'P-2019-0024','Project P-2019-0024: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,11,11,11,NULL,NULL,66566,'status'),(911,'P-2019-0025','Project P-2019-0025','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,12,12,12,NULL,NULL,66566,'status'),(921,'P-2019-0026','Project P-2019-0026: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,13,13,13,NULL,NULL,66566,'status'),(931,'P-2019-0027','Project P-2019-0027','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,14,14,14,NULL,NULL,66566,'status'),(941,'P-2019-0028','Project P-2019-0028: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,15,15,15,NULL,NULL,66566,'status'),(951,'P-2019-0029','Project P-2019-0029','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,16,16,16,NULL,NULL,66566,'status'),(961,'P-2019-0030','Project P-2019-0030: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,17,17,17,NULL,NULL,66566,'status'),(971,'P-2019-0031','Project P-2019-0031','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,18,18,18,NULL,NULL,66566,'status'),(981,'P-2019-0032','Project P-2019-0032: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,19,19,19,NULL,NULL,66566,'status'),(991,'P-2019-0033','Project P-2019-0033','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,20,20,20,NULL,NULL,66566,'status'),(1001,'P-2019-0034','Project P-2019-0034: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,21,21,21,NULL,NULL,66566,'status'),(1011,'P-2019-0035','Project P-2019-0035','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,22,22,22,NULL,NULL,66566,'status'),(1021,'P-2019-0036','Project P-2019-0036: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,23,23,23,NULL,NULL,66566,'status'),(1031,'P-2019-0037','Project P-2019-0037','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,24,24,24,NULL,NULL,66566,'status'),(1041,'P-2019-0038','Project P-2019-0038: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,25,25,25,NULL,NULL,66566,'status'),(1051,'P-2019-0039','Project P-2019-0039','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,26,26,26,NULL,NULL,66566,'status'),(1061,'P-2019-0040','Project P-2019-0040: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,27,27,27,NULL,NULL,66566,'status'),(1071,'P-2019-0041','Project P-2019-0041','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,28,28,28,NULL,NULL,66566,'status'),(1081,'P-2019-0042','Project P-2019-0042: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,29,29,29,NULL,NULL,66566,'status'),(1091,'P-2019-0043','Project P-2019-0043','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,30,30,30,NULL,NULL,66566,'status'),(1101,'P-2019-0044','Project P-2019-0044: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,31,31,31,NULL,NULL,66566,'status'),(1111,'P-2019-0045','Project P-2019-0045','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,32,32,32,NULL,NULL,66566,'status'),(1121,'P-2019-0046','Project P-2019-0046: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,33,33,33,NULL,NULL,66566,'status'),(1131,'P-2019-0047','Project P-2019-0047','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,34,34,34,NULL,NULL,66566,'status'),(1141,'P-2019-0048','Project P-2019-0048: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,35,35,35,NULL,NULL,66566,'status'),(1151,'P-2019-0049','Project P-2019-0049','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,36,36,36,NULL,NULL,66566,'status'),(1161,'P-2019-0050','Project P-2019-0050: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,37,37,37,NULL,NULL,66566,'status'),(1171,'P-2019-0051','Project P-2019-0051','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,38,38,38,NULL,NULL,66566,'status'),(1181,'P-2019-0052','Project P-2019-0052: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,39,39,39,NULL,NULL,66566,'status'),(1191,'P-2019-0053','Project P-2019-0053','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,40,40,40,NULL,NULL,66566,'status'),(1201,'P-2019-0054','Project P-2019-0054: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,41,41,41,NULL,NULL,66566,'status'),(1211,'P-2019-0055','Project P-2019-0055','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,42,42,42,NULL,NULL,66566,'status'),(1221,'P-2019-0056','Project P-2019-0056: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,43,43,43,NULL,NULL,66566,'status'),(1231,'P-2019-0057','Project P-2019-0057','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,44,44,44,NULL,NULL,66566,'status'),(1241,'P-2019-0058','Project P-2019-0058: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,45,45,45,NULL,NULL,66566,'status'),(1251,'P-2019-0059','Project P-2019-0059','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,46,46,46,NULL,NULL,66566,'status'),(1261,'P-2019-0060','Project P-2019-0060: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,47,47,47,NULL,NULL,66566,'status'),(1271,'P-2019-0061','Project P-2019-0061','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,48,48,48,NULL,NULL,66566,'status'),(1281,'P-2019-0062','Project P-2019-0062: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,49,49,49,NULL,NULL,66566,'status'),(1291,'P-2019-0063','Project P-2019-0063','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,50,50,50,NULL,NULL,66566,'status'),(1301,'P-2019-0064','Project P-2019-0064: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,51,51,51,NULL,NULL,66566,'status'),(1311,'P-2019-0065','Project P-2019-0065','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,52,52,52,NULL,NULL,66566,'status'),(1321,'P-2019-0066','Project P-2019-0066: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,53,53,53,NULL,NULL,66566,'status'),(1331,'P-2019-0067','Project P-2019-0067','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,54,54,54,NULL,NULL,66566,'status'),(1341,'P-2019-0068','Project P-2019-0068: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,55,55,55,NULL,NULL,66566,'status'),(1351,'P-2019-0069','Project P-2019-0069','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,56,56,56,NULL,NULL,66566,'status'),(1361,'P-2019-0070','Project P-2019-0070: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,57,57,57,NULL,NULL,66566,'status'),(1371,'P-2019-0071','Project P-2019-0071','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,58,58,58,NULL,NULL,66566,'status'),(1381,'P-2019-0072','Project P-2019-0072: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,59,59,59,NULL,NULL,66566,'status'),(1391,'P-2019-0073','Project P-2019-0073','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,60,60,60,NULL,NULL,66566,'status'),(1401,'P-2019-0074','Project P-2019-0074: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,61,61,61,NULL,NULL,66566,'status'),(1411,'P-2019-0075','Project P-2019-0075','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,62,62,62,NULL,NULL,66566,'status'),(1421,'P-2019-0076','Project P-2019-0076: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,63,63,63,NULL,NULL,66566,'status'),(1431,'P-2019-0077','Project P-2019-0077','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,64,64,64,NULL,NULL,66566,'status'),(1441,'P-2019-0078','Project P-2019-0078: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,65,65,65,NULL,NULL,66566,'status'),(1451,'P-2019-0079','Project P-2019-0079','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,66,66,66,NULL,NULL,66566,'status'),(1461,'P-2019-0080','Project P-2019-0080: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,67,67,67,NULL,NULL,66566,'status'),(1471,'P-2019-0081','Project P-2019-0081','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,68,68,68,NULL,NULL,66566,'status'),(1481,'P-2019-0082','Project P-2019-0082: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,69,69,69,NULL,NULL,66566,'status'),(1491,'P-2019-0083','Project P-2019-0083','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,70,70,70,NULL,NULL,66566,'status'),(1501,'P-2019-0084','Project P-2019-0084: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,71,71,71,NULL,NULL,66566,'status'),(1511,'P-2019-0085','Project P-2019-0085','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,72,72,72,NULL,NULL,66566,'status'),(1521,'P-2019-0086','Project P-2019-0086: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,73,73,73,NULL,NULL,66566,'status'),(1531,'P-2019-0087','Project P-2019-0087','some testing ...',18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,74,74,74,NULL,NULL,66566,'status'),(1541,'P-2019-0088','Project P-2019-0088: test',NULL,18,1574444813,18,1574444813,NULL,NULL,NULL,NULL,NULL,'public',1,'active',NULL,75,75,75,NULL,NULL,66566,'status'),(1551,'P-2019-02','Project P-2019-02','some testing ...',6,1576075866,6,1576075866,NULL,NULL,NULL,NULL,1378,'public',1,'active',100,2850,2850,2850,NULL,NULL,132096,'times'),(1561,'P-2019-03','Project P-2019-03: test',NULL,6,1576075976,6,1576075976,NULL,NULL,NULL,NULL,1378,'public',1,'active',0,NULL,NULL,NULL,NULL,NULL,132096,'times'),(1571,'P-2019-04','Project P-2019-04','some testing ...',6,1576076149,6,1576076149,NULL,NULL,NULL,NULL,1378,'public',1,'active',NULL,0,0,0,NULL,NULL,132096,'times');
/*!40000 ALTER TABLE `egw_pm_projects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `egw_pm_members`
--

DROP TABLE IF EXISTS `egw_pm_members`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `egw_pm_members` (
  `pm_id` int(11) NOT NULL,
  `member_uid` int(11) NOT NULL,
  `role_id` int(11) DEFAULT 0,
  `member_availibility` double DEFAULT 100,
  PRIMARY KEY (`pm_id`,`member_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `egw_pm_members`
--

LOCK TABLES `egw_pm_members` WRITE;
/*!40000 ALTER TABLE `egw_pm_members` DISABLE KEYS */;
INSERT INTO `egw_pm_members` VALUES (0,76,0,60),(1,6,4,100),(4,7,1,100),(6,6,2,100),(9,-2,1,100),(10,6,1,100),(10,9,NULL,100),(12,9,7,100),(12,16,7,100),(42,-1,4,100),(45,-2,4,100),(126,6,1,100),(141,76,3,100),(145,76,1,100),(161,76,4,100),(161,101,3,100),(165,76,4,20),(177,5,4,100),(177,6,1,100),(177,7,4,100),(486,5,4,100),(486,6,1,100),(486,7,4,100),(519,-2,4,100);
/*!40000 ALTER TABLE `egw_pm_members` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `egw_pm_roles`
--

DROP TABLE IF EXISTS `egw_pm_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `egw_pm_roles` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `pm_id` int(11) DEFAULT 0,
  `role_title` varchar(80) NOT NULL,
  `role_description` varchar(255) DEFAULT NULL,
  `role_acl` int(11) NOT NULL,
  PRIMARY KEY (`role_id`),
  KEY `egw_pm_roles_id` (`pm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `egw_pm_roles`
--

LOCK TABLES `egw_pm_roles` WRITE;
/*!40000 ALTER TABLE `egw_pm_roles` DISABLE KEYS */;
INSERT INTO `egw_pm_roles` VALUES (1,0,'Coordinator','full access',65535),(2,0,'Accounting','edit access, incl. editing budget and elements',199),(3,0,'Assistant','read access, incl. budget and adding elements',67),(4,0,'Projectmember','read access, no budget',3),(7,0,'External','Add timesheet only',256),(12,7,'A+B','a+B',1);
/*!40000 ALTER TABLE `egw_pm_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `egw_pm_extra`
--

DROP TABLE IF EXISTS `egw_pm_extra`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `egw_pm_extra` (
  `pm_id` int(11) NOT NULL,
  `pm_extra_name` varchar(40) NOT NULL,
  `pm_extra_value` text DEFAULT NULL,
  PRIMARY KEY (`pm_id`,`pm_extra_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `egw_pm_extra`
--

LOCK TABLES `egw_pm_extra` WRITE;
/*!40000 ALTER TABLE `egw_pm_extra` DISABLE KEYS */;
INSERT INTO `egw_pm_extra` VALUES (4,'select-account','6'),(6,'comments','hugentobler'),(9,'select-account','19'),(21,'salesoffer','offen'),(21,'staatsanwalt','9'),(141,'comments','comment123'),(141,'staatsanwalt','162'),(141,'tracker','8213'),(145,'comments','comment123'),(145,'staatsanwalt','162'),(145,'tracker','8213'),(177,'project_intern','123456789'),(486,'comments','dgsds'),(486,'project_intern','123456789');
/*!40000 ALTER TABLE `egw_pm_extra` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2019-12-14  8:11:06
