--
-- Data for Table `ext_contact_person`
--

INSERT INTO `ext_contact_person` (`id`, `date_create`, `date_update`, `id_person_create`, `deleted`, `username`, `password`, `email`, `is_admin`, `is_active`, `firstname`, `lastname`, `shortname`, `salutation`, `title`, `birthday`) VALUES
(1, 1246615200, 1264780312, 0, 0, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'demo@todoyu.com', 1, 1, 'Adam', 'Admin', 'ALAD', 'm', '', '0000-00-00');

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

--
-- Data for Table `ext_contact_company`
--

INSERT INTO `ext_contact_company` (`id`, `date_create`, `date_update`, `id_person_create`, `deleted`, `title`, `shortname`, `date_enter`, `is_internal`) VALUES
(1, 1264696524, 1269509610, 1, 0, 'snowflake productions GmbH ', 'sfp', 1259622000, 1);

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

--
-- Data for Table `ext_contact_mm_company_person`
--

INSERT INTO `ext_contact_mm_company_person` (`id`, `id_company`, `id_person`, `id_workaddress`, `id_jobtype`) VALUES
(1, 1, 1, 0, 0);

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

--
-- Data for Table `ext_contact_contactinfotype`
--

INSERT INTO `ext_contact_contactinfotype` (`id`, `date_create`, `date_update`, `id_person_create`, `deleted`, `category`, `key`, `title`, `is_public`) VALUES
(1, 0, 0, 0, 0, 1, 'email_business', 'LLL:contact.ext.contactinfo.type.email_business', 1),
(2, 0, 0, 0, 0, 2, 'tel_private', 'LLL:contact.ext.contactinfo.type.tel_private', 0),
(3, 0, 0, 0, 0, 2, 'tel_exchange', 'LLL:contact.ext.contactinfo.type.tel_exchange', 1),
(4, 0, 0, 0, 0, 2, 'tel_business', 'LLL:contact.ext.contactinfo.type.tel_business', 1),
(5, 0, 0, 0, 0, 1, 'email_private', 'LLL:contact.ext.contactinfo.type.email_private', 0),
(6, 0, 0, 0, 0, 2, 'mobile_business', 'LLL:contact.ext.contactinfo.type.mobile_business', 1),
(7, 0, 0, 0, 0, 2, 'fax_private', 'LLL:contact.ext.contactinfo.type.fax_private', 0),
(8, 0, 0, 0, 0, 2, 'fax_business', 'LLL:contact.ext.contactinfo.type.fax_business', 1),
(9, 0, 0, 0, 0, 2, 'mobile_private', 'LLL:contact.ext.contactinfo.type.mobile_private', 0),
(10, 0, 0, 0, 0, 2, 'fax_exchange', 'LLL:contact.ext.contactinfo.type.fax_exchange', 1),
(11, 0, 0, 0, 0, 3, 'website', 'LLL:contact.ext.contactinfo.type.website', 1),
(12, 0, 0, 0, 0, 3, 'skype', 'LLL:contact.ext.contactinfo.type.skype', 0);

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

--
-- Data for Table `system_role`
--

INSERT INTO `system_role` (`id`, `date_create`, `date_update`, `id_person_create`, `deleted`, `title`, `is_active`, `description`) VALUES
(1, 1264761659, 0, 1, 0, 'Customers', 1, 'Customers with todoyu access'),
(2, 1264762106, 0, 1, 0, 'Project Managers', 1, ''),
(3, 1264762153, 0, 1, 0, 'Staff', 1, 'Executive members of staff');

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

--
-- Data for Table `system_right`
--

INSERT INTO `system_right` (`id`, `ext`, `right`, `id_role`) VALUES
(2, 119, 'task:track', 2),
(7, 101, 'general:use', 2),
(8, 119, 'task:editOwn', 2),
(10, 111, 'general:use', 3),
(11, 101, 'asset:seeAll', 2),
(13, 101, 'asset:delete', 2),
(14, 101, 'general:use', 3),
(17, 103, 'general:use', 3),
(18, 103, 'general:use', 2),
(19, 103, 'general:use', 1),
(28, 107, 'daytracks:timeExportAllPerson', 2),
(29, 111, 'general:use', 2),
(30, 111, 'general:use', 1),
(31, 126, 'settings:password', 2),
(33, 126, 'general:use', 3),
(34, 126, 'general:use', 1),
(35, 126, 'settings:password', 3),
(36, 126, 'general:use', 2),
(37, 126, 'settings:password', 1),
(50, 115, 'general:area', 3),
(51, 115, 'filtersets:save', 2),
(52, 115, 'general:area', 1),
(53, 115, 'general:area', 2),
(54, 115, 'general:use', 3),
(55, 115, 'general:use', 1),
(56, 115, 'general:use', 2),
(65, 101, 'asset:seeAll', 3),
(66, 101, 'general:use', 1),
(78, 107, 'daytracks:timeExportAllEmployer', 2),
(79, 107, 'daytracks:timeExport', 2),
(102, 113, 'statuschange:firstreminder', 3),
(103, 113, 'statuschange:invoiced', 3),
(104, 113, 'statussee:paid', 3),
(105, 113, 'statussee:canceled', 3),
(106, 113, 'statussee:depreciated', 3),
(107, 113, 'statussee:encashment', 3),
(108, 113, 'statussee:thirdreminder', 3),
(109, 113, 'statussee:finalreminder', 3),
(110, 113, 'statussee:secondreminder', 3),
(111, 113, 'statussee:firstreminder', 3),
(112, 115, 'filtersets:save', 1),
(113, 115, 'filtersets:save', 3),
(114, 115, 'filtersets:deleteAll', 2),
(115, 115, 'filtersets:deleteAll', 1),
(116, 115, 'filtersets:deleteAll', 3),
(117, 115, 'filtersets:hideAll', 2),
(118, 115, 'filtersets:hideAll', 1),
(119, 115, 'filtersets:hideAll', 3),
(120, 115, 'filtersets:renameAll', 2),
(121, 115, 'filtersets:renameAll', 1),
(122, 115, 'filtersets:renameAll', 3),
(123, 119, 'general:use', 2),
(142, 101, 'asset:delete', 3),
(190, 113, 'statussee:invoiced', 3),
(191, 113, 'statussee:approved', 3),
(192, 113, 'statussee:provisional', 3),
(193, 131, 'general:use', 2),
(194, 132, 'general:use', 2),
(196, 113, 'task:infos', 3),
(197, 113, 'task:icons', 3),
(198, 113, 'project:documents', 3),
(199, 113, 'project:infos', 3),
(200, 113, 'project:approvalroles', 3),
(201, 113, 'tab:invoices', 3),
(202, 113, 'tab:billing', 3),
(203, 113, 'general:area', 3),
(204, 113, 'general:use', 3),
(205, 113, 'statuschange:canceled', 3),
(206, 113, 'workflow:approve', 3),
(207, 113, 'workflow:reopen', 3),
(208, 113, 'workflow:download', 3),
(209, 132, 'general:use', 3),
(212, 119, 'task:editAllChargeable', 2),
(213, 119, 'task:editOwnChargeable', 2),
(287, 107, 'daytracks:timeExport', 3),
(288, 107, 'general:use', 2),
(289, 107, 'general:use', 3),
(320, 100, 'general:use', 2),
(321, 100, 'general:use', 1),
(322, 100, 'comment:seeAll', 2),
(323, 100, 'comment:editOwn', 2),
(324, 100, 'comment:editOwn', 1),
(325, 100, 'comment:editAll', 2),
(326, 100, 'comment:requestFeedback', 2),
(327, 100, 'comment:requestFeedback', 1),
(328, 100, 'comment:sendAsEmail', 2),
(329, 100, 'comment:sendAsEmail', 1),
(330, 100, 'comment:deleteOwn', 2),
(331, 100, 'comment:deleteOwn', 1),
(332, 100, 'comment:makePublic', 2),
(333, 100, 'comment:makePublic', 1),
(394, 118, 'general:allrecords', 3),
(395, 118, 'general:allrecords', 2),
(512, 119, 'general:use', 3),
(513, 119, 'task:track', 3),
(514, 119, 'task:editOwn', 3),
(587, 104, 'general:use', 3),
(588, 104, 'general:use', 2),
(589, 104, 'general:area', 3),
(590, 104, 'general:area', 2),
(591, 104, 'event:seeAll', 3),
(592, 104, 'event:seeAll', 2),
(593, 104, 'event:add', 3),
(594, 104, 'event:add', 2),
(595, 104, 'event:editAssigned', 3),
(596, 104, 'event:editAssigned', 2),
(597, 104, 'event:deleteAssigned', 3),
(598, 104, 'event:deleteAssigned', 2),
(599, 104, 'mailing:sendAsEmail', 3),
(600, 104, 'mailing:sendAsEmail', 2),
(601, 104, 'reminders:popup', 3),
(602, 104, 'reminders:popup', 2),
(603, 104, 'reminders:email', 3),
(604, 104, 'reminders:email', 2),
(605, 105, 'general:use', 3),
(606, 105, 'general:use', 2),
(607, 105, 'general:use', 1),
(608, 105, 'comment:seeAll', 3),
(609, 105, 'comment:seeAll', 2),
(610, 105, 'comment:editOwn', 3),
(611, 105, 'comment:editOwn', 2),
(612, 105, 'comment:requestFeedback', 3),
(613, 105, 'comment:requestFeedback', 2),
(614, 105, 'comment:requestFeedback', 1),
(615, 105, 'comment:sendAsEmail', 3),
(616, 105, 'comment:sendAsEmail', 2),
(617, 105, 'comment:sendAsEmail', 1),
(618, 105, 'comment:deleteOwn', 3),
(619, 105, 'comment:deleteOwn', 2),
(620, 105, 'comment:makePublic', 3),
(621, 105, 'comment:makePublic', 2),
(667, 106, 'general:use', 3),
(668, 106, 'general:use', 2),
(669, 106, 'general:use', 1),
(670, 106, 'general:profile', 3),
(671, 106, 'general:profile', 2),
(672, 106, 'general:profile', 1),
(673, 106, 'general:area', 3),
(674, 106, 'general:area', 2),
(675, 106, 'person:seeAllInternalPersons', 3),
(676, 106, 'person:seeAllInternalPersons', 2),
(677, 106, 'person:seeAllPersons', 3),
(678, 106, 'person:seeAllPersons', 2),
(679, 106, 'person:add', 3),
(680, 106, 'person:add', 2),
(681, 106, 'person:editAndDeleteAll', 3),
(682, 106, 'person:editAndDeleteAll', 2),
(683, 106, 'person:enableLogin', 2),
(684, 106, 'person:seeComment', 3),
(685, 106, 'person:seeComment', 2),
(686, 106, 'person:editComment', 3),
(687, 106, 'person:editComment', 2),
(688, 106, 'company:seeAllCompanies', 3),
(689, 106, 'company:seeAllCompanies', 2),
(690, 106, 'company:add', 3),
(691, 106, 'company:add', 2),
(692, 106, 'company:editOwn', 3),
(693, 106, 'company:editOwn', 2),
(694, 106, 'company:editAndDeleteAll', 2),
(695, 106, 'company:seeComment', 3),
(696, 106, 'company:seeComment', 2),
(697, 106, 'company:editComment', 3),
(698, 106, 'company:editComment', 2),
(699, 106, 'relation:seeAllContactinfotypes', 3),
(700, 106, 'relation:seeAllContactinfotypes', 2),
(701, 106, 'relation:seeHomeAddress', 3),
(702, 106, 'relation:seeHomeAddress', 2),
(703, 106, 'relation:seeBusinessAddress', 3),
(704, 106, 'relation:seeBusinessAddress', 2),
(705, 106, 'relation:seeBillingAddress', 3),
(706, 106, 'relation:seeBillingAddress', 2),
(707, 106, 'panelwidgets:staffSelector', 3),
(708, 106, 'panelwidgets:staffSelector', 2),
(709, 106, 'panelwidgets:export', 3),
(710, 106, 'panelwidgets:export', 2),
(711, 112, 'general:use', 3),
(712, 112, 'general:use', 2),
(713, 112, 'general:use', 1),
(714, 112, 'general:area', 3),
(715, 112, 'general:area', 2),
(716, 112, 'general:area', 1),
(717, 112, 'project:seeOwn', 3),
(718, 112, 'project:seeOwn', 2),
(719, 112, 'project:seeOwn', 1),
(720, 112, 'project:seeAll', 3),
(721, 112, 'project:seeAll', 2),
(722, 112, 'project:planning:see', 3),
(723, 112, 'project:planning:see', 2),
(724, 112, 'project:planning:see', 1),
(725, 112, 'project:progress:see', 3),
(726, 112, 'project:progress:see', 2),
(727, 112, 'project:progress:see', 1),
(728, 112, 'project:done:see', 3),
(729, 112, 'project:done:see', 2),
(730, 112, 'project:done:see', 1),
(731, 112, 'project:cleared:see', 3),
(732, 112, 'project:cleared:see', 2),
(733, 112, 'project:warranty:see', 3),
(734, 112, 'project:warranty:see', 2),
(735, 112, 'project:warranty:see', 1),
(736, 112, 'project:add', 3),
(737, 112, 'project:add', 2),
(738, 112, 'project:editAndDelete', 3),
(739, 112, 'project:editAndDelete', 2),
(740, 112, 'seetask:seeAll', 3),
(741, 112, 'seetask:seeAll', 2),
(742, 112, 'seetask:seeAll', 1),
(743, 112, 'seetask:planning:see', 3),
(744, 112, 'seetask:planning:see', 2),
(745, 112, 'seetask:planning:see', 1),
(746, 112, 'seetask:open:see', 3),
(747, 112, 'seetask:open:see', 2),
(748, 112, 'seetask:open:see', 1),
(749, 112, 'seetask:progress:see', 3),
(750, 112, 'seetask:progress:see', 2),
(751, 112, 'seetask:progress:see', 1),
(752, 112, 'seetask:confirm:see', 3),
(753, 112, 'seetask:confirm:see', 2),
(754, 112, 'seetask:confirm:see', 1),
(755, 112, 'seetask:done:see', 3),
(756, 112, 'seetask:done:see', 2),
(757, 112, 'seetask:done:see', 1),
(758, 112, 'seetask:accepted:see', 3),
(759, 112, 'seetask:accepted:see', 2),
(760, 112, 'seetask:accepted:see', 1),
(761, 112, 'seetask:rejected:see', 3),
(762, 112, 'seetask:rejected:see', 2),
(763, 112, 'seetask:rejected:see', 1),
(764, 112, 'seetask:cleared:see', 3),
(765, 112, 'seetask:cleared:see', 2),
(766, 112, 'seetask:cleared:see', 1),
(767, 112, 'addtask:addTaskInOwnProjects', 3),
(768, 112, 'addtask:addTaskInOwnProjects', 2),
(769, 112, 'addtask:addTaskInOwnProjects', 1),
(770, 112, 'addtask:addViaQuickCreateHeadlet', 3),
(771, 112, 'addtask:addViaQuickCreateHeadlet', 2),
(772, 112, 'addtask:addTaskInAllProjects', 3),
(773, 112, 'addtask:addTaskInAllProjects', 2),
(774, 112, 'addtask:addContainerInOwnProjects', 3),
(775, 112, 'addtask:addContainerInOwnProjects', 2),
(776, 112, 'addtask:addContainerInAllProjects', 3),
(777, 112, 'addtask:addContainerInAllProjects', 2),
(778, 112, 'addtask:planning:create', 3),
(779, 112, 'addtask:planning:create', 2),
(780, 112, 'addtask:open:create', 3),
(781, 112, 'addtask:open:create', 2),
(782, 112, 'addtask:progress:create', 3),
(783, 112, 'addtask:progress:create', 2),
(784, 112, 'addtask:confirm:create', 3),
(785, 112, 'addtask:confirm:create', 2),
(786, 112, 'addtask:done:create', 3),
(787, 112, 'addtask:done:create', 2),
(788, 112, 'addtask:accepted:create', 3),
(789, 112, 'addtask:accepted:create', 2),
(790, 112, 'addtask:rejected:create', 3),
(791, 112, 'addtask:rejected:create', 2),
(792, 112, 'addtask:cleared:create', 3),
(793, 112, 'addtask:cleared:create', 2),
(794, 112, 'edittask:editOwnTasks', 3),
(795, 112, 'edittask:editOwnTasks', 2),
(796, 112, 'edittask:editOwnTasks', 1),
(797, 112, 'edittask:editTaskInOwnProjects', 3),
(798, 112, 'edittask:editTaskInOwnProjects', 2),
(799, 112, 'edittask:editTaskInOwnProjects', 1),
(800, 112, 'edittask:editTaskInAllProjects', 3),
(801, 112, 'edittask:editTaskInAllProjects', 2),
(802, 112, 'edittask:editOwnContainers', 3),
(803, 112, 'edittask:editOwnContainers', 2),
(804, 112, 'edittask:editContainerInOwnProjects', 3),
(805, 112, 'edittask:editContainerInOwnProjects', 2),
(806, 112, 'edittask:editContainerInAllProjects', 3),
(807, 112, 'edittask:editContainerInAllProjects', 2),
(808, 112, 'edittask:planning:edit', 3),
(809, 112, 'edittask:planning:edit', 2),
(810, 112, 'edittask:open:edit', 3),
(811, 112, 'edittask:open:edit', 2),
(812, 112, 'edittask:progress:edit', 3),
(813, 112, 'edittask:progress:edit', 2),
(814, 112, 'edittask:confirm:edit', 3),
(815, 112, 'edittask:confirm:edit', 2),
(816, 112, 'edittask:done:edit', 3),
(817, 112, 'edittask:done:edit', 2),
(818, 112, 'edittask:accepted:edit', 3),
(819, 112, 'edittask:accepted:edit', 2),
(820, 112, 'edittask:rejected:edit', 3),
(821, 112, 'edittask:rejected:edit', 2),
(824, 112, 'edittaskdetail:editDateStart', 3),
(825, 112, 'edittaskdetail:editDateStart', 2),
(826, 112, 'edittaskdetail:editDateEnd', 3),
(827, 112, 'edittaskdetail:editDateEnd', 2),
(828, 112, 'edittaskdetail:editDeadline', 3),
(829, 112, 'edittaskdetail:editDeadline', 2),
(830, 112, 'edittaskdetail:editPersonAssigned', 3),
(831, 112, 'edittaskdetail:editPersonAssigned', 2),
(832, 112, 'edittaskdetail:editPersonOwner', 3),
(833, 112, 'edittaskdetail:editPersonOwner', 2),
(834, 112, 'edittaskdetail:editActivity', 3),
(835, 112, 'edittaskdetail:editActivity', 2),
(836, 112, 'edittaskdetail:editEstimatedWorkload', 3),
(837, 112, 'edittaskdetail:editEstimatedWorkload', 2),
(838, 112, 'edittaskdetail:editIsPublic', 3),
(839, 112, 'edittaskdetail:editIsPublic', 2),
(840, 112, 'edittaskdetail:planning:changefrom', 3),
(841, 112, 'edittaskdetail:planning:changefrom', 2),
(842, 112, 'edittaskdetail:open:changefrom', 3),
(843, 112, 'edittaskdetail:open:changefrom', 2),
(844, 112, 'edittaskdetail:progress:changefrom', 3),
(845, 112, 'edittaskdetail:progress:changefrom', 2),
(846, 112, 'edittaskdetail:confirm:changefrom', 3),
(847, 112, 'edittaskdetail:confirm:changefrom', 2),
(848, 112, 'edittaskdetail:confirm:changefrom', 1),
(849, 112, 'edittaskdetail:done:changefrom', 3),
(850, 112, 'edittaskdetail:done:changefrom', 2),
(851, 112, 'edittaskdetail:done:changefrom', 1),
(852, 112, 'edittaskdetail:accepted:changefrom', 3),
(853, 112, 'edittaskdetail:accepted:changefrom', 2),
(854, 112, 'edittaskdetail:rejected:changefrom', 3),
(855, 112, 'edittaskdetail:rejected:changefrom', 2),
(856, 112, 'edittaskdetail:planning:changeto', 3),
(857, 112, 'edittaskdetail:planning:changeto', 2),
(858, 112, 'edittaskdetail:open:changeto', 3),
(859, 112, 'edittaskdetail:open:changeto', 2),
(860, 112, 'edittaskdetail:progress:changeto', 3),
(861, 112, 'edittaskdetail:progress:changeto', 2),
(862, 112, 'edittaskdetail:confirm:changeto', 3),
(863, 112, 'edittaskdetail:confirm:changeto', 2),
(864, 112, 'edittaskdetail:done:changeto', 3),
(865, 112, 'edittaskdetail:done:changeto', 2),
(866, 112, 'edittaskdetail:accepted:changeto', 3),
(867, 112, 'edittaskdetail:accepted:changeto', 2),
(868, 112, 'edittaskdetail:accepted:changeto', 1),
(869, 112, 'edittaskdetail:rejected:changeto', 3),
(870, 112, 'edittaskdetail:rejected:changeto', 2),
(871, 112, 'edittaskdetail:rejected:changeto', 1),
(872, 112, 'edittaskdetail:cleared:changeto', 3),
(873, 112, 'edittaskdetail:cleared:changeto', 2),
(874, 112, 'deletetask:deleteOwnTasks', 3),
(875, 112, 'deletetask:deleteOwnTasks', 2),
(876, 112, 'deletetask:deleteTaskInOwnProjects', 3),
(877, 112, 'deletetask:deleteTaskInOwnProjects', 2),
(878, 112, 'deletetask:deleteTaskInAllProjects', 3),
(879, 112, 'deletetask:deleteTaskInAllProjects', 2),
(880, 112, 'deletetask:deleteOwnContainers', 3),
(881, 112, 'deletetask:deleteOwnContainers', 2),
(882, 112, 'deletetask:deleteContainerInOwnProjects', 3),
(883, 112, 'deletetask:deleteContainerInOwnProjects', 2),
(884, 112, 'deletetask:deleteContainerInAllProjects', 3),
(885, 112, 'deletetask:deleteContainerInAllProjects', 2),
(886, 112, 'export:taskcsv', 2),
(887, 112, 'export:projectcsv', 2),
(888, 112, 'seetask:waiting:see', 2),
(889, 112, 'seetask:waiting:see', 3),
(890, 112, 'addtask:waiting:create', 2),
(891, 112, 'addtask:waiting:create', 3),
(892, 112, 'edittask:waiting:edit', 2),
(893, 112, 'edittask:waiting:edit', 3),
(894, 112, 'edittaskdetail:waiting:changefrom', 2),
(895, 112, 'edittaskdetail:waiting:changefrom', 3),
(896, 112, 'edittaskdetail:waiting:changeto', 2),
(897, 112, 'edittaskdetail:waiting:changeto', 3);
