-- 
-- Table structure for table `my_tc_absence`
-- 

DROP TABLE IF EXISTS `my_tc_absence`;
CREATE TABLE `my_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`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `my_tc_absence`
-- 

INSERT INTO `my_tc_absence` VALUES ('.', 'present', '', 'present', '000000', 'FFFFFF', 0, 1, 0, '');

-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_absence_group`
-- 

DROP TABLE IF EXISTS `my_tc_absence_group`;
CREATE TABLE `my_tc_absence_group` (
  `id` int(11) NOT NULL auto_increment,
  `absence` char(1) default NULL,
  `group` varchar(40) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_allowance`
-- 

DROP TABLE IF EXISTS `my_tc_allowance`;
CREATE TABLE `my_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`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_announcements`
-- 

DROP TABLE IF EXISTS `my_tc_announcements`;
CREATE TABLE `my_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`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_config`
-- 

DROP TABLE IF EXISTS `my_tc_config`;
CREATE TABLE `my_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`)
) TYPE=MyISAM AUTO_INCREMENT=55;

-- 
-- Dumping data for table `my_tc_config`
-- 

INSERT INTO `my_tc_config` VALUES('1', 'defgroupfilter', 'All');
INSERT INTO `my_tc_config` VALUES('2', 'defregion', 'default');
INSERT INTO `my_tc_config` VALUES('3', 'appSubTitle', 'Version 3.3.001');
INSERT INTO `my_tc_config` VALUES('4', 'appFooterCpy', 'Copyright © 2010 by <a href="http://www.lewe.com" class="copyright" target="_blank">Lewe.com</a>.');
INSERT INTO `my_tc_config` VALUES('5', 'repeatHeaderCount', '10');
INSERT INTO `my_tc_config` VALUES('6', 'todayBorderColor', 'FFCC00');
INSERT INTO `my_tc_config` VALUES('7', 'todayBorderSize', '2');
INSERT INTO `my_tc_config` VALUES('8', 'pastDayColor', '');
INSERT INTO `my_tc_config` VALUES('9', 'avatarWidth', '100');
INSERT INTO `my_tc_config` VALUES('10', 'avatarHeight', '140');
INSERT INTO `my_tc_config` VALUES('11', 'cookieLifetime', '80000');
INSERT INTO `my_tc_config` VALUES('12', 'pwdLength', '6');
INSERT INTO `my_tc_config` VALUES('13', 'badLogins', '0');
INSERT INTO `my_tc_config` VALUES('14', 'gracePeriod', '30');
INSERT INTO `my_tc_config` VALUES('15', 'mailFrom', 'TeamCal Pro 3.3');
INSERT INTO `my_tc_config` VALUES('16', 'mailReply', 'tcpro@myserver.com');
INSERT INTO `my_tc_config` VALUES('17', 'userCustom1', 'Custom 1');
INSERT INTO `my_tc_config` VALUES('18', 'userCustom2', 'Custom 2');
INSERT INTO `my_tc_config` VALUES('19', 'userCustom3', 'Custom 3');
INSERT INTO `my_tc_config` VALUES('20', 'userCustom4', 'Custom 4');
INSERT INTO `my_tc_config` VALUES('21', 'userCustom5', 'Custom 5');
INSERT INTO `my_tc_config` VALUES('22', 'repeatHeadersAfter', '6');
INSERT INTO `my_tc_config` VALUES('23', 'repeatUsernamesAfter', '5');
INSERT INTO `my_tc_config` VALUES('24', 'showMonths', '1');
INSERT INTO `my_tc_config` VALUES('25', 'firstDayOfWeek', '1');
INSERT INTO `my_tc_config` VALUES('26', 'showLanguage', '1');
INSERT INTO `my_tc_config` VALUES('27', 'showGroup', '1');
INSERT INTO `my_tc_config` VALUES('28', 'showRegion', '1');
INSERT INTO `my_tc_config` VALUES('29', 'showToday', '1');
INSERT INTO `my_tc_config` VALUES('30', 'showStart', '1');
INSERT INTO `my_tc_config` VALUES('31', 'showWeekNumbers', '1');
INSERT INTO `my_tc_config` VALUES('32', 'includeRemainder', '1');
INSERT INTO `my_tc_config` VALUES('33', 'includeRemainderTotal', '1');
INSERT INTO `my_tc_config` VALUES('34', 'includeTotals', '1');
INSERT INTO `my_tc_config` VALUES('35', 'showRemainder', '0');
INSERT INTO `my_tc_config` VALUES('36', 'includeSummary', '1');
INSERT INTO `my_tc_config` VALUES('37', 'showSummary', '0');
INSERT INTO `my_tc_config` VALUES('38', 'showUserIcons', '1');
INSERT INTO `my_tc_config` VALUES('39', 'showAvatars', '1');
INSERT INTO `my_tc_config` VALUES('40', 'debugHide', '1');
INSERT INTO `my_tc_config` VALUES('41', 'publicMode', 'view');
INSERT INTO `my_tc_config` VALUES('42', 'registeredMode', 'view');
INSERT INTO `my_tc_config` VALUES('43', 'pwdStrength', '1');
INSERT INTO `my_tc_config` VALUES('44', 'allowRegistration', '1');
INSERT INTO `my_tc_config` VALUES('45', 'emailConfirmation', '1');
INSERT INTO `my_tc_config` VALUES('46', 'adminApproval', '1');
INSERT INTO `my_tc_config` VALUES('47', 'timeZone', 'America/Montreal');
INSERT INTO `my_tc_config` VALUES('48', 'emailNotifications', '1');
INSERT INTO `my_tc_config` VALUES('49', 'theme', 'tcpro');
INSERT INTO `my_tc_config` VALUES('50', 'allowUserTheme', '1');
INSERT INTO `my_tc_config` VALUES('51', 'hideManagers', '0');
INSERT INTO `my_tc_config` VALUES('52', 'hideDaynotes', '1');
INSERT INTO `my_tc_config` VALUES('53', 'defperiodfrom', '2010-01-01');
INSERT INTO `my_tc_config` VALUES('54', 'defperiodto', '2010-12-31');

-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_daynotes`
-- 

DROP TABLE IF EXISTS `my_tc_daynotes`;
CREATE TABLE `my_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`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_groups`
-- 

DROP TABLE IF EXISTS `my_tc_groups`;
CREATE TABLE `my_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`)
) TYPE=MyISAM;


-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_holidays`
-- 

DROP TABLE IF EXISTS `my_tc_holidays`;
CREATE TABLE `my_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`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `my_tc_holidays`
-- 

INSERT INTO `my_tc_holidays` VALUES ('1', 'wend', '1', 'Weekend Day', '000000', 'FFFFCC', 0);
INSERT INTO `my_tc_holidays` VALUES ('0', 'busi', '0', 'Business Day', '000000', 'FFFFFF', 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_log`
-- 

DROP TABLE IF EXISTS `my_tc_log`;
CREATE TABLE `my_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`)
) TYPE=MyISAM AUTO_INCREMENT=1;


-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_months`
-- 

DROP TABLE IF EXISTS `my_tc_months`;
CREATE TABLE `my_tc_months` (
  `yearmonth` varchar(6) NOT NULL default '',
  `template` varchar(31) default NULL,
  `region` varchar(40) NOT NULL default 'default',
  PRIMARY KEY  (`yearmonth`,`region`)
) TYPE=MyISAM;


-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_regions`
-- 

DROP TABLE IF EXISTS `my_tc_regions`;
CREATE TABLE `my_tc_regions` (
  `regionname` varchar(40) NOT NULL default '',
  `description` varchar(100) default NULL,
  `options` smallint(6) default '0',
  PRIMARY KEY  (`regionname`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `my_tc_regions`
-- 

INSERT INTO `my_tc_regions` VALUES ('default', 'Default Region', 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_templates`
-- 

DROP TABLE IF EXISTS `my_tc_templates`;
CREATE TABLE `my_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`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_user_announcement`
-- 

DROP TABLE IF EXISTS `my_tc_user_announcement`;
CREATE TABLE `my_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`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_user_group`
-- 

DROP TABLE IF EXISTS `my_tc_user_group`;
CREATE TABLE `my_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`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_user_options`
-- 

DROP TABLE IF EXISTS `my_tc_user_options`;
CREATE TABLE `my_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`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

-- 
-- Dumping data for table `my_tc_user_options`
-- 

INSERT INTO `my_tc_user_options` VALUES (1, 'admin', 'owngroupsonly', 'no');
INSERT INTO `my_tc_user_options` VALUES (2, 'admin', 'showbirthday', 'no');
INSERT INTO `my_tc_user_options` VALUES (3, 'admin', 'ignoreage', 'no');
INSERT INTO `my_tc_user_options` VALUES (4, 'admin', 'language', 'english');
INSERT INTO `my_tc_user_options` VALUES (5, 'admin', 'defgroup', 'default');
INSERT INTO `my_tc_user_options` VALUES (6, 'admin', 'notifybirthday', 'yes');
INSERT INTO `my_tc_user_options` VALUES (7, 'admin', 'deftheme', 'default');

-- --------------------------------------------------------

-- 
-- Table structure for table `my_tc_users`
-- 

DROP TABLE IF EXISTS `my_tc_users`;
CREATE TABLE `my_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`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `my_tc_users`
-- 

INSERT INTO `my_tc_users` VALUES ('admin', 's77dWZwOIYXss', '', 'Admin', '', 'Administrator', 'none', '', '', 'webmaster@yourserver.com', 63, 'All', 0, 4, '', 0, 0, '', '2006-10-06 20:01:18', '0000-00-00', '', '2008-08-10 15:18:59', '', '', '', '', '', '', '');