-- MySQL dump 10.13 Distrib 5.6.25, for Win32 (x86) -- -- Host: localhost Database: tcpro -- ------------------------------------------------------ -- Server version 5.6.36 /*!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 utf8 */; /*!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 `tcp_tc_absence` -- DROP TABLE IF EXISTS `tcp_tc_absence`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_absence` ( `cfgsym` char(1) NOT NULL DEFAULT '', `cfgname` varchar(40) DEFAULT NULL, `dspsym` char(1) DEFAULT NULL, `dspname` varchar(40) DEFAULT NULL, `dspcolor` varchar(6) DEFAULT NULL, `dspbgcolor` varchar(6) DEFAULT NULL, `allowance` smallint(6) DEFAULT '0', `factor` float NOT NULL DEFAULT '1', `options` smallint(6) DEFAULT '0', `iconfile` varchar(100) DEFAULT NULL, PRIMARY KEY (`cfgsym`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_absence` -- LOCK TABLES `tcp_tc_absence` WRITE; /*!40000 ALTER TABLE `tcp_tc_absence` DISABLE KEYS */; INSERT INTO `tcp_tc_absence` VALUES ('.','present','','present','000000','FFFFFF',0,1,0,''),('U','a7105','U','Urlaub SM','UB','FF0000',0,0,6,''),('Z','a9620','Z','Zeitausgleich SM','ZA','FF9900',0,0,6,''),('K','a1993','K','Krankheit MO','KM','996600',0,0,4,''),('H','a7013','H','Heimarbeit SM','HM','009900',0,0,8,''); /*!40000 ALTER TABLE `tcp_tc_absence` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_absence_group` -- DROP TABLE IF EXISTS `tcp_tc_absence_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_absence_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `absence` char(1) DEFAULT NULL, `group` varchar(40) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_absence_group` -- LOCK TABLES `tcp_tc_absence_group` WRITE; /*!40000 ALTER TABLE `tcp_tc_absence_group` DISABLE KEYS */; INSERT INTO `tcp_tc_absence_group` VALUES (1,'.','DSSWien'),(2,'.','DSSLinz'),(3,'U','DSSLinz'),(4,'U','DSSWien'),(5,'Z','DSSLinz'),(6,'Z','DSSWien'),(7,'K','DSSLinz'),(8,'K','DSSWien'),(9,'H','DSSLinz'),(10,'H','DSSWien'); /*!40000 ALTER TABLE `tcp_tc_absence_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_allowance` -- DROP TABLE IF EXISTS `tcp_tc_allowance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_allowance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(40) DEFAULT NULL, `abssym` char(1) DEFAULT NULL, `lastyear` smallint(6) DEFAULT '0', `curryear` smallint(6) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_allowance` -- LOCK TABLES `tcp_tc_allowance` WRITE; /*!40000 ALTER TABLE `tcp_tc_allowance` DISABLE KEYS */; /*!40000 ALTER TABLE `tcp_tc_allowance` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_announcements` -- DROP TABLE IF EXISTS `tcp_tc_announcements`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_announcements` ( `id` int(11) NOT NULL AUTO_INCREMENT, `timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `text` text NOT NULL, `popup` tinyint(1) DEFAULT '0', `silent` tinyint(1) DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_announcements` -- LOCK TABLES `tcp_tc_announcements` WRITE; /*!40000 ALTER TABLE `tcp_tc_announcements` DISABLE KEYS */; INSERT INTO `tcp_tc_announcements` VALUES (1,'2010-06-24 05:35:39','Security Warning

You seem to have installed \r\n\r\nTeamCal Pro already. However, the installation.php file still exists. For security reasons you should delete it as soon as possible.

[TeamCal \r\n\r\nPro Installation]',1,0); /*!40000 ALTER TABLE `tcp_tc_announcements` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_config` -- DROP TABLE IF EXISTS `tcp_tc_config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_config` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(40) NOT NULL DEFAULT '', `value` varchar(160) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_config` -- LOCK TABLES `tcp_tc_config` WRITE; /*!40000 ALTER TABLE `tcp_tc_config` DISABLE KEYS */; INSERT INTO `tcp_tc_config` VALUES (1,'defgroupfilter','All'),(2,'defregion','default'),(3,'appSubTitle','Version 3.3.001'),(4,'appFooterCpy','Copyright &copy; 2010 by <a href="http://www.lewe.com" class="copyright" \r\n\r\ntarget="_blank">Lewe.com</a>.'),(5,'repeatHeaderCount','10'),(6,'todayBorderColor','FFCC00'),(7,'todayBorderSize','2'),(8,'pastDayColor',''),(9,'avatarWidth','100'),(10,'avatarHeight','140'),(11,'cookieLifetime','80000'),(12,'pwdLength','6'),(13,'badLogins','0'),(14,'gracePeriod','30'),(15,'mailFrom','TeamCal Pro 3.3'),(16,'mailReply','tcpro@myserver.com'),(17,'userCustom1','Custom 1'),(18,'userCustom2','Custom 2'),(19,'userCustom3','Custom 3'),(20,'userCustom4','Custom 4'),(21,'userCustom5','Custom 5'),(22,'repeatHeadersAfter','6'),(23,'repeatUsernamesAfter','5'),(24,'showMonths','1'),(25,'firstDayOfWeek','1'),(26,'showLanguage','1'),(27,'showGroup','1'),(28,'showRegion','1'),(29,'showToday','1'),(30,'showStart','1'),(31,'showWeekNumbers','1'),(32,'includeRemainder','1'),(33,'includeRemainderTotal','1'),(34,'includeTotals','1'),(35,'showRemainder','0'),(36,'includeSummary','1'),(37,'showSummary','0'),(38,'showUserIcons','1'),(39,'showAvatars','1'),(40,'debugHide','1'),(41,'publicMode','view'),(42,'registeredMode','view'),(43,'pwdStrength','1'),(44,'allowRegistration','1'),(45,'emailConfirmation','1'),(46,'adminApproval','1'),(47,'timeZone','America/Montreal'),(48,'emailNotifications','1'),(49,'theme','tcpro'),(50,'allowUserTheme','1'),(51,'hideManagers','0'),(52,'hideDaynotes','1'),(53,'defperiodfrom','2010-01-01'),(54,'defperiodto','2010-12-31'); /*!40000 ALTER TABLE `tcp_tc_config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_daynotes` -- DROP TABLE IF EXISTS `tcp_tc_daynotes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_daynotes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `yyyymmdd` varchar(8) DEFAULT NULL, `daynote` text, `username` varchar(40) NOT NULL DEFAULT 'all', `region` varchar(40) NOT NULL DEFAULT 'default', PRIMARY KEY (`id`), KEY `yyyymmdd` (`yyyymmdd`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_daynotes` -- LOCK TABLES `tcp_tc_daynotes` WRITE; /*!40000 ALTER TABLE `tcp_tc_daynotes` DISABLE KEYS */; /*!40000 ALTER TABLE `tcp_tc_daynotes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_groups` -- DROP TABLE IF EXISTS `tcp_tc_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_groups` ( `groupname` varchar(40) NOT NULL DEFAULT '', `description` varchar(100) DEFAULT NULL, `options` smallint(6) DEFAULT '0', `min_present` smallint(6) NOT NULL DEFAULT '1', `max_absent` smallint(6) NOT NULL DEFAULT '1', PRIMARY KEY (`groupname`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_groups` -- LOCK TABLES `tcp_tc_groups` WRITE; /*!40000 ALTER TABLE `tcp_tc_groups` DISABLE KEYS */; INSERT INTO `tcp_tc_groups` VALUES ('DSSWien','Desktop & Server Solutions \r\n\r\nWien',0,1,1),('DSSLinz','Desktop & Server Solutions Linz',0,1,1); /*!40000 ALTER TABLE `tcp_tc_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_holidays` -- DROP TABLE IF EXISTS `tcp_tc_holidays`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_holidays` ( `cfgsym` char(1) NOT NULL DEFAULT '', `cfgname` varchar(40) DEFAULT NULL, `dspsym` char(1) DEFAULT NULL, `dspname` varchar(40) DEFAULT NULL, `dspcolor` varchar(6) DEFAULT NULL, `dspbgcolor` varchar(6) DEFAULT NULL, `options` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`cfgsym`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_holidays` -- LOCK TABLES `tcp_tc_holidays` WRITE; /*!40000 ALTER TABLE `tcp_tc_holidays` DISABLE KEYS */; INSERT INTO `tcp_tc_holidays` VALUES ('1','wend','1','Wochenendtag','000000','FFFFCC',0),('0','busi','0','Arbeitstag','000000','FFFFFF',1); /*!40000 ALTER TABLE `tcp_tc_holidays` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_log` -- DROP TABLE IF EXISTS `tcp_tc_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(40) DEFAULT NULL, `timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `user` varchar(40) DEFAULT NULL, `event` text, PRIMARY KEY (`id`), KEY `idx_occured` (`timestamp`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_log` -- LOCK TABLES `tcp_tc_log` WRITE; /*!40000 ALTER TABLE `tcp_tc_log` DISABLE KEYS */; /*!40000 ALTER TABLE `tcp_tc_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_months` -- DROP TABLE IF EXISTS `tcp_tc_months`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_months` ( `yearmonth` varchar(6) NOT NULL DEFAULT '', `template` varchar(31) DEFAULT NULL, `region` varchar(40) NOT NULL DEFAULT 'default', PRIMARY KEY (`yearmonth`,`region`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_months` -- LOCK TABLES `tcp_tc_months` WRITE; /*!40000 ALTER TABLE `tcp_tc_months` DISABLE KEYS */; INSERT INTO `tcp_tc_months` VALUES ('201006','000011000001100000110000011000','default'),('201001','0110000011000001100000110000011','default'),('201002','0000011000001100000110000011','default'),('201003','0000011000001100000110000011000','default'),('201004','001100000110000011000001100000','default'),('201005','1100000110000011000001100000110','default'),('201007','0011000001100000110000011000001','default'),('201008','1000001100000110000011000001100','default'),('201009','000110000011000001100000110000','default'),('201010','0110000011000001100000110000011','default'),('201011','000001100000110000011000001100','default'),('201012','0001100000110000011000001100000','default'),('201109','001100000110000011000001100000','default'),('201110','1100000110000011000001100000110','default'),('201111','000011000001100000110000011000','default'),('201112','0011000001100000110000011000001','default'),('201201','1000001100000110000011000001100','default'),('201202','00011000001100000110000011000','default'),('201203','0011000001100000110000011000001','default'),('201204','100000110000011000001100000110','default'),('201205','0000110000011000001100000110000','default'),('201206','011000001100000110000011000001','default'),('201207','1000001100000110000011000001100','default'),('201208','0001100000110000011000001100000','default'),('201101','1100000110000011000001100000110','default'),('201102','0000110000011000001100000110','default'),('201103','0000110000011000001100000110000','default'),('201104','011000001100000110000011000001','default'),('201105','1000001100000110000011000001100','default'),('201106','000110000011000001100000110000','default'),('201107','0110000011000001100000110000011','default'),('201108','0000011000001100000110000011000','default'); /*!40000 ALTER TABLE `tcp_tc_months` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_regions` -- DROP TABLE IF EXISTS `tcp_tc_regions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_regions` ( `regionname` varchar(40) NOT NULL DEFAULT '', `description` varchar(100) DEFAULT NULL, `options` smallint(6) DEFAULT '0', PRIMARY KEY (`regionname`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_regions` -- LOCK TABLES `tcp_tc_regions` WRITE; /*!40000 ALTER TABLE `tcp_tc_regions` DISABLE KEYS */; INSERT INTO `tcp_tc_regions` VALUES ('default','Default Region',0),('Wien','SM Wien',0),('Linz','SM Linz',0); /*!40000 ALTER TABLE `tcp_tc_regions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_templates` -- DROP TABLE IF EXISTS `tcp_tc_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_templates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(40) DEFAULT NULL, `year` varchar(4) DEFAULT NULL, `month` char(2) DEFAULT NULL, `template` varchar(31) DEFAULT NULL, PRIMARY KEY (`id`), KEY `username` (`username`) ) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_templates` -- LOCK TABLES `tcp_tc_templates` WRITE; /*!40000 ALTER TABLE `tcp_tc_templates` DISABLE KEYS */; INSERT INTO `tcp_tc_templates` VALUES (1,'AT01235','2010','06','.................U..UUUUU..UUU'),(2,'AT01337','2010','06','..............................'),(3,'AT01235','2010','01','...............................'),(4,'AT01337','2010','01','...............................'),(5,'AT01235','2010','02','............................'),(6,'AT01337','2010','02','............................'),(7,'AT01235','2010','03','...............................'),(8,'AT01337','2010','03','...............................'),(9,'AT01235','2010','04','..............................'),(10,'AT01337','2010','04','..............................'),(11,'AT01235','2010','05','...............................'),(12,'AT01337','2010','05','...............................'),(13,'AT01235','2010','07','...............................'),(14,'AT01337','2010','07','...............................'),(15,'AT01235','2010','08','...............................'),(16,'AT01337','2010','08','...............................'),(17,'AT01235','2010','09','..............................'),(18,'AT01337','2010','09','..............................'),(19,'AT01235','2010','10','...............................'),(20,'AT01337','2010','10','...............................'),(21,'AT01235','2010','11','..............................'),(22,'AT01337','2010','11','..............................'),(23,'AT01235','2010','12','...............................'),(24,'AT01337','2010','12','...............................'),(25,'AT01235','2011','09','..............................'),(26,'AT01337','2011','09','..............................'),(27,'AT01235','2011','10','...............................'),(28,'AT01337','2011','10','...............................'),(29,'AT01235','2011','11','..............................'),(30,'AT01337','2011','11','..............................'),(31,'AT01235','2011','12','...............................'),(32,'AT01337','2011','12','...............................'),(33,'AT01235','2012','01','...............................'),(34,'AT01337','2012','01','...............................'),(35,'AT01235','2012','02','.............................'),(36,'AT01337','2012','02','.............................'),(37,'AT01235','2012','03','...............................'),(38,'AT01337','2012','03','...............................'),(39,'AT01235','2012','04','..............................'),(40,'AT01337','2012','04','..............................'),(41,'AT01235','2012','05','...............................'),(42,'AT01337','2012','05','...............................'),(43,'AT01235','2012','06','..............................'),(44,'AT01337','2012','06','..............................'),(45,'AT01235','2012','07','...............................'),(46,'AT01337','2012','07','...............................'),(47,'AT01235','2012','08','...............................'),(48,'AT01337','2012','08','...............................'),(49,'AT01235','2011','01','...............................'),(50,'AT01337','2011','01','...............................'),(51,'AT01235','2011','02','............................'),(52,'AT01337','2011','02','............................'),(53,'AT01235','2011','03','...............................'),(54,'AT01337','2011','03','...............................'),(55,'AT01235','2011','04','..............................'),(56,'AT01337','2011','04','..............................'),(57,'AT01235','2011','05','...............................'),(58,'AT01337','2011','05','...............................'),(59,'AT01235','2011','06','..............................'),(60,'AT01337','2011','06','..............................'),(61,'AT01235','2011','07','...............................'),(62,'AT01337','2011','07','...............................'),(63,'AT01235','2011','08','...............................'),(64,'AT01337','2011','08','...............................'); /*!40000 ALTER TABLE `tcp_tc_templates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_user_announcement` -- DROP TABLE IF EXISTS `tcp_tc_user_announcement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_user_announcement` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(40) DEFAULT NULL, `ats` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_user_announcement` -- LOCK TABLES `tcp_tc_user_announcement` WRITE; /*!40000 ALTER TABLE `tcp_tc_user_announcement` DISABLE KEYS */; /*!40000 ALTER TABLE `tcp_tc_user_announcement` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_user_group` -- DROP TABLE IF EXISTS `tcp_tc_user_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_user_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(40) DEFAULT NULL, `groupname` varchar(40) DEFAULT NULL, `type` tinytext, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_user_group` -- LOCK TABLES `tcp_tc_user_group` WRITE; /*!40000 ALTER TABLE `tcp_tc_user_group` DISABLE KEYS */; INSERT INTO `tcp_tc_user_group` VALUES (7,'AT01337','DSSWien','member'),(8,'AT01235','DSSWien','manager'); /*!40000 ALTER TABLE `tcp_tc_user_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_user_options` -- DROP TABLE IF EXISTS `tcp_tc_user_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_user_options` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(40) DEFAULT NULL, `option` varchar(40) DEFAULT NULL, `value` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_user_options` -- LOCK TABLES `tcp_tc_user_options` WRITE; /*!40000 ALTER TABLE `tcp_tc_user_options` DISABLE KEYS */; INSERT INTO `tcp_tc_user_options` VALUES (1,'admin','owngroupsonly','no'),(2,'admin','showbirthday','yes'),(3,'admin','ignoreage','no'),(4,'admin','language','deutsch'),(5,'admin','defgroup','default'),(6,'admin','notifybirthday','yes'),(7,'admin','deftheme','tcpro'),(8,'admin','defregion','default'),(9,'AT01337','owngroupsonly','no'),(10,'AT01337','showbirthday','yes'),(11,'AT01337','ignoreage','no'),(12,'AT01337','notifybirthday','yes'),(13,'AT01337','language','deutsch'),(14,'AT01337','defgroup','DSSWien'),(15,'AT01235','owngroupsonly','no'),(16,'AT01235','showbirthday','yes'),(17,'AT01235','ignoreage','no'),(18,'AT01235','notifybirthday','yes'),(19,'AT01235','language','deutsch'),(20,'AT01235','defgroup','DSSWien'),(21,'AT01235','defregion','Wien'),(22,'AT01235','deftheme','default'),(23,'AT01337','defregion','Wien'),(24,'AT01337','deftheme','default'); /*!40000 ALTER TABLE `tcp_tc_user_options` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tcp_tc_users` -- DROP TABLE IF EXISTS `tcp_tc_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tcp_tc_users` ( `username` varchar(40) NOT NULL DEFAULT '', `password` varchar(40) DEFAULT NULL, `firstname` varchar(80) DEFAULT NULL, `lastname` varchar(80) DEFAULT NULL, `title` varchar(80) DEFAULT NULL, `position` varchar(80) DEFAULT NULL, `group` varchar(50) DEFAULT NULL, `phone` varchar(50) DEFAULT NULL, `mobile` varchar(50) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `notify` tinyint(4) DEFAULT '0', `notify_group` varchar(50) DEFAULT NULL, `status` tinyint(4) DEFAULT '0', `usertype` tinyint(4) DEFAULT '0', `ut_group` varchar(50) DEFAULT NULL, `privileges` tinyint(4) NOT NULL DEFAULT '1', `bad_logins` int(11) DEFAULT '0', `bad_logins_start` varchar(15) DEFAULT NULL, `last_pw_change` datetime DEFAULT NULL, `birthday` date DEFAULT NULL, `idnumber` varchar(40) DEFAULT NULL, `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `custom1` varchar(80) NOT NULL DEFAULT '', `custom2` varchar(80) NOT NULL DEFAULT '', `custom3` varchar(80) NOT NULL DEFAULT '', `custom4` varchar(80) NOT NULL DEFAULT '', `custom5` varchar(80) NOT NULL DEFAULT '', `customFree` text NOT NULL, `customPopup` text NOT NULL, PRIMARY KEY (`username`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tcp_tc_users` -- LOCK TABLES `tcp_tc_users` WRITE; /*!40000 ALTER TABLE `tcp_tc_users` DISABLE KEYS */; INSERT INTO `tcp_tc_users` VALUES ('admin','s7EsEoondSM46','MAM','Admin','','Administrator','none','','','mam@heimam.at',0,'All',0,12,'',0,0,'','2010-06-24 05:01:15','1971-11-11','4711','2010-06-24 05:35:39','','','','','','',''),('AT01337','s7MuuIoROZfb2','Markus','Mascelli','Mag.','Systems Manager & Technical Consultant','','+43-1-60543-2737','+43-664-6180378','markus.mascelli@atosorigin.com',0,'',0,9,'',0,0,'','0000-00-00 00:00:00','1971-11-11','450168','0000-00-00 00:00:00','','','','','','',''),('AT01235','s7MuuIoROZfb2','Christian','Elmer','Ing.','Teamleader SM','','+43-1-60543-1017','+43-664-6180410','christian.elmer@atosorigin.com',0,'',0,27,'',0,0,'','0000-00-00 00:00:00','1972-05-25','450150','0000-00-00 00:00:00','','','','','','',''); /*!40000 ALTER TABLE `tcp_tc_users` 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 2024-02-01 2:00:11