# TeamCal Pro MySQL Export
--
-- Table structure for `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(3) DEFAULT '0',
`factor` float NOT NULL DEFAULT '1',
`options` smallint(6) DEFAULT '0',
`iconfile` varchar(100) DEFAULT NULL,
PRIMARY KEY (`cfgsym`)
) ENGINE=MyISAM;
--
-- Dumping data for table `my_tc_absence`
--
INSERT INTO `my_tc_absence` VALUES('.', 'present', '', 'present', '000000', 'FFFFFF', '0', '1', '0', '');
INSERT INTO `my_tc_absence` VALUES('V', 'a4690', 'U', 'Vacation', '000000', 'FF0000', '20', '1', '3', 'family.png');
INSERT INTO `my_tc_absence` VALUES('S', 'a4168', 'S', 'Sick', '000000', 'FFB6C1', '24', '1', '65', 'virus.png');
INSERT INTO `my_tc_absence` VALUES('F', 'a7275', 'F', 'Day Off', '000000', '00FF00', '12', '1.5', '33', '');
INSERT INTO `my_tc_absence` VALUES('D', 'dutytrip', 'D', 'Duty Trip', '000000', 'FFB300', '20', '1', '1', 'wrench.png');
INSERT INTO `my_tc_absence` VALUES('H', 'a7977', 'H', 'Home Office', '000000', 'ADD8E6', '0', '1', '10', 'home.png');
INSERT INTO `my_tc_absence` VALUES('N', 'a9870', 'N', 'Not Present', '000000', 'C0C0C0', '0', '1', '0', 'x.png');
INSERT INTO `my_tc_absence` VALUES('T', 'training', 'T', 'Training', '000000', '6495ED', '10', '1', '0', 'book2.png');
INSERT INTO `my_tc_absence` VALUES('A', 'a8247', 'A', 'Tentative Absence', '000000', 'EFEFEF', '0', '1', '0', 'alarm.png');
-- --------------------------------------------------------
--
-- Table structure for `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`)
) ENGINE=MyISAM AUTO_INCREMENT=33;
--
-- Dumping data for table `my_tc_absence_group`
--
INSERT INTO `my_tc_absence_group` VALUES('1', 'F', 'Disney');
INSERT INTO `my_tc_absence_group` VALUES('2', 'F', 'Looney');
INSERT INTO `my_tc_absence_group` VALUES('3', 'F', 'Marvel');
INSERT INTO `my_tc_absence_group` VALUES('4', 'F', 'Pixar');
INSERT INTO `my_tc_absence_group` VALUES('5', 'D', 'Disney');
INSERT INTO `my_tc_absence_group` VALUES('6', 'D', 'Looney');
INSERT INTO `my_tc_absence_group` VALUES('7', 'D', 'Marvel');
INSERT INTO `my_tc_absence_group` VALUES('8', 'D', 'Pixar');
INSERT INTO `my_tc_absence_group` VALUES('9', 'H', 'Disney');
INSERT INTO `my_tc_absence_group` VALUES('10', 'H', 'Looney');
INSERT INTO `my_tc_absence_group` VALUES('11', 'H', 'Marvel');
INSERT INTO `my_tc_absence_group` VALUES('12', 'H', 'Pixar');
INSERT INTO `my_tc_absence_group` VALUES('13', 'N', 'Disney');
INSERT INTO `my_tc_absence_group` VALUES('14', 'N', 'Looney');
INSERT INTO `my_tc_absence_group` VALUES('15', 'N', 'Marvel');
INSERT INTO `my_tc_absence_group` VALUES('16', 'N', 'Pixar');
INSERT INTO `my_tc_absence_group` VALUES('17', 'S', 'Disney');
INSERT INTO `my_tc_absence_group` VALUES('18', 'S', 'Looney');
INSERT INTO `my_tc_absence_group` VALUES('19', 'S', 'Marvel');
INSERT INTO `my_tc_absence_group` VALUES('20', 'S', 'Pixar');
INSERT INTO `my_tc_absence_group` VALUES('21', 'A', 'Disney');
INSERT INTO `my_tc_absence_group` VALUES('22', 'A', 'Looney');
INSERT INTO `my_tc_absence_group` VALUES('23', 'A', 'Marvel');
INSERT INTO `my_tc_absence_group` VALUES('24', 'A', 'Pixar');
INSERT INTO `my_tc_absence_group` VALUES('25', 'T', 'Disney');
INSERT INTO `my_tc_absence_group` VALUES('26', 'T', 'Looney');
INSERT INTO `my_tc_absence_group` VALUES('27', 'T', 'Marvel');
INSERT INTO `my_tc_absence_group` VALUES('28', 'T', 'Pixar');
INSERT INTO `my_tc_absence_group` VALUES('29', 'V', 'Disney');
INSERT INTO `my_tc_absence_group` VALUES('30', 'V', 'Looney');
INSERT INTO `my_tc_absence_group` VALUES('31', 'V', 'Marvel');
INSERT INTO `my_tc_absence_group` VALUES('32', 'V', 'Pixar');
-- --------------------------------------------------------
--
-- Table structure for `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`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for `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`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for `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`)
) ENGINE=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 `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`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for `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`)
) ENGINE=MyISAM;
--
-- Dumping data for table `my_tc_groups`
--
INSERT INTO `my_tc_groups` VALUES('Disney', 'Disney Characters', '0', '2', '2');
INSERT INTO `my_tc_groups` VALUES('Looney', 'Looney Tunes Characters', '0', '2', '3');
INSERT INTO `my_tc_groups` VALUES('Marvel', 'Marvel Characters', '0', '1', '1');
INSERT INTO `my_tc_groups` VALUES('Pixar', 'Pixar Characters', '0', '1', '1');
-- --------------------------------------------------------
--
-- Table structure for `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`)
) ENGINE=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');
INSERT INTO `my_tc_holidays` VALUES('2', 'd7234', '2', 'Public Holiday', '000000', 'CCFFCC', '0');
INSERT INTO `my_tc_holidays` VALUES('3', 'd3202', '3', 'School Holiday', '000000', '00CC66', '0');
-- --------------------------------------------------------
--
-- Table structure for `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`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for `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`)
) ENGINE=MyISAM;
--
-- Dumping data for table `my_tc_months`
--
INSERT INTO `my_tc_months` VALUES('201005', '1100000110000011000001100000110', 'default');
INSERT INTO `my_tc_months` VALUES('201006', '000011000001100000110000011000', 'default');
INSERT INTO `my_tc_months` VALUES('201007', '0011000001100000110000011000001', 'default');
INSERT INTO `my_tc_months` VALUES('201008', '1000001100000110000011000001100', 'default');
INSERT INTO `my_tc_months` VALUES('201009', '000110000011000001100000110000', 'default');
INSERT INTO `my_tc_months` VALUES('201010', '0110000011000001100000110000011', 'default');
INSERT INTO `my_tc_months` VALUES('201011', '000001100000110000011000001100', 'default');
INSERT INTO `my_tc_months` VALUES('201012', '0001100000110000011000001100000', 'default');
INSERT INTO `my_tc_months` VALUES('201101', '1100000110000011000001100000110', 'default');
INSERT INTO `my_tc_months` VALUES('201102', '0000110000011000001100000110', 'default');
INSERT INTO `my_tc_months` VALUES('201103', '0000110000011000001100000110000', 'default');
INSERT INTO `my_tc_months` VALUES('201104', '011000001100000110000011000001', 'default');
INSERT INTO `my_tc_months` VALUES('201105', '1000001100000110000011000001100', 'default');
INSERT INTO `my_tc_months` VALUES('201106', '000110000011000001100000110000', 'default');
INSERT INTO `my_tc_months` VALUES('201107', '0110000011000001100000110000011', 'default');
INSERT INTO `my_tc_months` VALUES('201108', '0000011000001100000110000011000', 'default');
INSERT INTO `my_tc_months` VALUES('201109', '001100000110000011000001100000', 'default');
INSERT INTO `my_tc_months` VALUES('201110', '1100000110000011000001100000110', 'default');
INSERT INTO `my_tc_months` VALUES('201111', '000011000001100000110000011000', 'default');
INSERT INTO `my_tc_months` VALUES('201112', '0011000001100000110000011000001', 'default');
INSERT INTO `my_tc_months` VALUES('201201', '1000001100000110000011000001100', 'default');
INSERT INTO `my_tc_months` VALUES('201202', '00011000001100000110000011000', 'default');
INSERT INTO `my_tc_months` VALUES('201203', '0011000001100000110000011000001', 'default');
INSERT INTO `my_tc_months` VALUES('201204', '100000110000011000001100000110', 'default');
INSERT INTO `my_tc_months` VALUES('201205', '0000110000011000001100000110000', 'default');
INSERT INTO `my_tc_months` VALUES('201206', '011000001100000110000011000001', 'default');
INSERT INTO `my_tc_months` VALUES('201207', '1000001100000110000011000001100', 'default');
INSERT INTO `my_tc_months` VALUES('201208', '0001100000110000011000001100000', 'default');
INSERT INTO `my_tc_months` VALUES('201209', '110000011000001100000110000011', 'default');
INSERT INTO `my_tc_months` VALUES('201210', '0000011000001100000110000011000', 'default');
INSERT INTO `my_tc_months` VALUES('201211', '001100000110000011000001100000', 'default');
INSERT INTO `my_tc_months` VALUES('201212', '1100000110000011000001100000110', 'default');
INSERT INTO `my_tc_months` VALUES('201004', '001100000110000011000001100000', 'default');
-- --------------------------------------------------------
--
-- Table structure for `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`)
) ENGINE=MyISAM;
--
-- Dumping data for table `my_tc_regions`
--
INSERT INTO `my_tc_regions` VALUES('default', 'Default Region', '0');
INSERT INTO `my_tc_regions` VALUES('Canada', 'Canada Region', '0');
INSERT INTO `my_tc_regions` VALUES('Germany', 'Germany Region', '0');
-- --------------------------------------------------------
--
-- Table structure for `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`)
) ENGINE=MyISAM AUTO_INCREMENT=9;
--
-- Dumping data for table `my_tc_templates`
--
INSERT INTO `my_tc_templates` VALUES('1', 'ccarl', '2010', '04', '..............................');
INSERT INTO `my_tc_templates` VALUES('2', 'dduck', '2010', '04', '..............................');
INSERT INTO `my_tc_templates` VALUES('3', 'sgonzales', '2010', '04', '..............................');
INSERT INTO `my_tc_templates` VALUES('4', 'phead', '2010', '04', '..............................');
INSERT INTO `my_tc_templates` VALUES('5', 'blightyear', '2010', '04', '..............................');
INSERT INTO `my_tc_templates` VALUES('6', 'mmouse', '2010', '04', '..............................');
INSERT INTO `my_tc_templates` VALUES('7', 'mimouse', '2010', '04', '..............................');
INSERT INTO `my_tc_templates` VALUES('8', 'sman', '2010', '04', '..............................');
-- --------------------------------------------------------
--
-- Table structure for `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`)
) ENGINE=MyISAM;
--
-- Dumping data for table `my_tc_users`
--
INSERT INTO `my_tc_users` VALUES('blightyear', 's7MuuIoROZfb2', 'Buzz', 'Lightyear', 'Mr.', 'Hero', '', '+01/555 111 1115', '', 'blightyear@yourserver.com', '0', 'All', '0', '11', 'Pixar', '0', '0', '', '2004-08-14 18:01:14', '1970-05-20', '', '2008-09-03 16:06:34', '', '', '', '', '', '', '');
INSERT INTO `my_tc_users` VALUES('sman', 's7MuuIoROZfb2', '', 'Spiderman', 'Mr.', 'Hero', '', '', '', 'sman@yourserver.com', '0', '', '0', '27', '', '0', '0', '', '2005-02-25 22:00:08', '2005-03-01', '', '2009-09-01 17:47:54', '', '', '', '', '', '', '');
INSERT INTO `my_tc_users` VALUES('mimouse', 's7MuuIoROZfb2', 'Minnie', 'Mouse', 'Mrs.', 'Mouse', '', '+01/555 111 1112', '', 'mimouse@yourserver.com', '0', 'All', '0', '1', 'Disney', '0', '0', '', '2004-08-14 18:01:50', '1982-06-19', '', '2010-04-14 14:24:26', 'Very good', '222er', '3333', '4444', '5555', 'This is a sample comment. This is a sample comment. This is a sample comment. This is a sample comment. This is a sample comment.
Ans dsakdsfh sdk', 'This is a sample popup. This is a sample popup. This is a sample popup. This is a sample popup.
This is a sample popup. This is a sample popup.');
INSERT INTO `my_tc_users` VALUES('mmouse', 's7MuuIoROZfb2', 'Mickey', 'Mouse', 'Mr.', 'Mouses', '', '+01/555 111 1111', '', 'mmouse@yourserver.com', '0', 'All', '0', '11', 'Disney', '0', '0', '', '2004-08-14 18:01:32', '2006-10-17', '', '2010-04-14 13:41:55', '', '', '', '', '', '', '');
INSERT INTO `my_tc_users` VALUES('admin', 's77dWZwOIYXss', '', 'Admin', '', 'Administrator', '', '', '', 'webmaster@yourserver.com', '63', 'All', '0', '4', '', '0', '0', '', '2006-10-06 20:01:18', '0000-00-00', '', '2010-04-15 15:57:00', '', '', '', '', '', '', '');
INSERT INTO `my_tc_users` VALUES('phead', 's7MuuIoROZfb2', 'Potatoe', 'Head', 'Mr.', 'Potatoe', '', '', '', 'phead@yourserver.com', '0', '', '0', '9', '', '0', '0', '', '2006-09-03 21:01:44', '2001-09-20', '', '2008-09-11 21:08:31', '', '', '', '', '', '', 'I love potatoes. Cooked, baked, mashed, any way they come. Hmm, yummy!');
INSERT INTO `my_tc_users` VALUES('ccarl', 's7MuuIoROZfb2', 'Coyote', 'Carl', 'Mr.', 'Coyote', '', '', '', 'ccarl@yourserver.com', '0', '', '0', '11', '', '0', '0', '', '2006-09-04 01:01:50', '2007-04-06', '12345', '2009-10-06 18:32:50', '', '', '', '', '', '', '');
INSERT INTO `my_tc_users` VALUES('dduck', 's7MuuIoROZfb2', 'Donald', 'Duck', 'Mr.', 'Duck', '', '', '', 'dduck@yourserver.com', '0', '', '0', '9', '', '0', '0', '', '2006-09-04 01:01:57', '0000-00-00', '', '2010-04-14 13:42:50', '', '', '', '', '', '', '');
INSERT INTO `my_tc_users` VALUES('sgonzales', 's7MuuIoROZfb2', 'Speedy', 'Gonzales', 'Mr.', 'Mouse', '', '', '', 'sgonzales@yourserver.com', '0', '', '0', '9', '', '0', '0', '', '2006-09-04 21:01:14', '2000-02-01', '12345', '2006-09-24 15:52:35', '', '', '', '', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for `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`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for `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`)
) ENGINE=MyISAM AUTO_INCREMENT=9;
--
-- Dumping data for table `my_tc_user_group`
--
INSERT INTO `my_tc_user_group` VALUES('1', 'ccarl', 'Looney', 'manager');
INSERT INTO `my_tc_user_group` VALUES('2', 'mmouse', 'Disney', 'manager');
INSERT INTO `my_tc_user_group` VALUES('3', 'mimouse', 'Disney', 'member');
INSERT INTO `my_tc_user_group` VALUES('4', 'blightyear', 'Pixar', 'manager');
INSERT INTO `my_tc_user_group` VALUES('5', 'phead', 'Pixar', 'member');
INSERT INTO `my_tc_user_group` VALUES('6', 'sgonzales', 'Looney', 'member');
INSERT INTO `my_tc_user_group` VALUES('7', 'sman', 'Marvel', 'manager');
INSERT INTO `my_tc_user_group` VALUES('8', 'dduck', 'Disney', 'member');
-- --------------------------------------------------------
--
-- Table structure for `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`)
) ENGINE=MyISAM AUTO_INCREMENT=67;
--
-- Dumping data for table `my_tc_user_options`
--
INSERT INTO `my_tc_user_options` VALUES('1', 'blightyear', 'owngroupsonly', 'yes');
INSERT INTO `my_tc_user_options` VALUES('2', 'blightyear', 'showbirthday', 'yes');
INSERT INTO `my_tc_user_options` VALUES('3', 'blightyear', 'ignoreage', 'yes');
INSERT INTO `my_tc_user_options` VALUES('4', 'mmouse', 'owngroupsonly', 'yes');
INSERT INTO `my_tc_user_options` VALUES('5', 'mmouse', 'showbirthday', 'yes');
INSERT INTO `my_tc_user_options` VALUES('6', 'mmouse', 'ignoreage', 'yes');
INSERT INTO `my_tc_user_options` VALUES('7', 'sman', 'owngroupsonly', 'no');
INSERT INTO `my_tc_user_options` VALUES('8', 'sman', 'showbirthday', 'no');
INSERT INTO `my_tc_user_options` VALUES('9', 'sman', 'ignoreage', 'no');
INSERT INTO `my_tc_user_options` VALUES('10', 'admin', 'owngroupsonly', 'no');
INSERT INTO `my_tc_user_options` VALUES('11', 'admin', 'showbirthday', 'no');
INSERT INTO `my_tc_user_options` VALUES('12', 'admin', 'ignoreage', 'no');
INSERT INTO `my_tc_user_options` VALUES('13', 'mimouse', 'owngroupsonly', 'no');
INSERT INTO `my_tc_user_options` VALUES('14', 'mimouse', 'showbirthday', 'no');
INSERT INTO `my_tc_user_options` VALUES('15', 'mimouse', 'ignoreage', 'no');
INSERT INTO `my_tc_user_options` VALUES('16', 'mmouse', 'language', 'english');
INSERT INTO `my_tc_user_options` VALUES('17', 'mimouse', 'language', 'english');
INSERT INTO `my_tc_user_options` VALUES('18', 'mmouse', 'defgroup', 'Disney');
INSERT INTO `my_tc_user_options` VALUES('19', 'admin', 'language', 'english');
INSERT INTO `my_tc_user_options` VALUES('20', 'admin', 'defgroup', 'default');
INSERT INTO `my_tc_user_options` VALUES('21', 'sman', 'language', 'english');
INSERT INTO `my_tc_user_options` VALUES('22', 'sman', 'defgroup', 'All');
INSERT INTO `my_tc_user_options` VALUES('23', 'blightyear', 'language', 'english');
INSERT INTO `my_tc_user_options` VALUES('24', 'blightyear', 'defgroup', 'All');
INSERT INTO `my_tc_user_options` VALUES('25', 'mimouse', 'defgroup', 'default');
INSERT INTO `my_tc_user_options` VALUES('26', 'phead', 'owngroupsonly', 'no');
INSERT INTO `my_tc_user_options` VALUES('27', 'phead', 'showbirthday', 'yes');
INSERT INTO `my_tc_user_options` VALUES('28', 'phead', 'ignoreage', 'yes');
INSERT INTO `my_tc_user_options` VALUES('29', 'phead', 'language', 'deutsch');
INSERT INTO `my_tc_user_options` VALUES('30', 'phead', 'defgroup', 'All');
INSERT INTO `my_tc_user_options` VALUES('31', 'ccarl', 'ignoreage', 'no');
INSERT INTO `my_tc_user_options` VALUES('32', 'ccarl', 'showbirthday', 'no');
INSERT INTO `my_tc_user_options` VALUES('33', 'ccarl', 'owngroupsonly', 'no');
INSERT INTO `my_tc_user_options` VALUES('34', 'ccarl', 'language', 'english');
INSERT INTO `my_tc_user_options` VALUES('35', 'mmouse', 'deftheme', 'deviant');
INSERT INTO `my_tc_user_options` VALUES('36', 'dduck', 'owngroupsonly', 'no');
INSERT INTO `my_tc_user_options` VALUES('37', 'dduck', 'showbirthday', 'no');
INSERT INTO `my_tc_user_options` VALUES('38', 'dduck', 'ignoreage', 'no');
INSERT INTO `my_tc_user_options` VALUES('39', 'dduck', 'language', 'english');
INSERT INTO `my_tc_user_options` VALUES('40', 'dduck', 'defgroup', 'Allbygroup');
INSERT INTO `my_tc_user_options` VALUES('41', 'sgonzales', 'owngroupsonly', 'no');
INSERT INTO `my_tc_user_options` VALUES('42', 'sgonzales', 'showbirthday', 'yes');
INSERT INTO `my_tc_user_options` VALUES('43', 'sgonzales', 'ignoreage', 'no');
INSERT INTO `my_tc_user_options` VALUES('44', 'sgonzales', 'language', 'english');
INSERT INTO `my_tc_user_options` VALUES('45', 'sgonzales', 'defgroup', 'All');
INSERT INTO `my_tc_user_options` VALUES('46', 'ccarl', 'notifybirthday', 'yes');
INSERT INTO `my_tc_user_options` VALUES('47', 'sgonzales', 'notifybirthday', 'no');
INSERT INTO `my_tc_user_options` VALUES('48', 'phead', 'notifybirthday', 'no');
INSERT INTO `my_tc_user_options` VALUES('49', 'admin', 'notifybirthday', 'yes');
INSERT INTO `my_tc_user_options` VALUES('50', 'blightyear', 'notifybirthday', 'no');
INSERT INTO `my_tc_user_options` VALUES('51', 'dduck', 'notifybirthday', 'no');
INSERT INTO `my_tc_user_options` VALUES('52', 'mmouse', 'notifybirthday', 'yes');
INSERT INTO `my_tc_user_options` VALUES('53', 'sman', 'notifybirthday', 'no');
INSERT INTO `my_tc_user_options` VALUES('54', 'mimouse', 'notifybirthday', 'no');
INSERT INTO `my_tc_user_options` VALUES('55', 'ccarl', 'defgroup', 'Allbygroup');
INSERT INTO `my_tc_user_options` VALUES('56', 'ccarl', 'deftheme', 'deviant');
INSERT INTO `my_tc_user_options` VALUES('57', 'blightyear', 'deftheme', 'deviant');
INSERT INTO `my_tc_user_options` VALUES('58', 'admin', 'deftheme', 'default');
INSERT INTO `my_tc_user_options` VALUES('59', 'dduck', 'deftheme', 'default');
INSERT INTO `my_tc_user_options` VALUES('60', 'mimouse', 'deftheme', 'default');
INSERT INTO `my_tc_user_options` VALUES('61', 'phead', 'deftheme', 'default');
INSERT INTO `my_tc_user_options` VALUES('62', 'mimouse', 'defregion', 'default');
INSERT INTO `my_tc_user_options` VALUES('63', 'sman', 'deftheme', 'default');
INSERT INTO `my_tc_user_options` VALUES('64', 'ccarl', 'defregion', 'Canada');
INSERT INTO `my_tc_user_options` VALUES('65', 'mmouse', 'defregion', 'default');
INSERT INTO `my_tc_user_options` VALUES('66', 'phead', 'defregion', 'default');
-- --------------------------------------------------------