INSERT INTO `acl_items` VALUES (5, 0, 'Module write: addressbook');INSERT INTO `acl_items` VALUES (6, 0, 'Module read: calendar');INSERT INTO `acl_items` VALUES (7, 0, 'Module write: calendar');INSERT INTO `acl_items` VALUES (8, 0, 'Module read: email');INSERT INTO `acl_items` VALUES (9, 0, 'Module write: email');INSERT INTO `acl_items` VALUES (10, 0, 'Module read: filesystem');INSERT INTO `acl_items` VALUES (11, 0, 'Module write: filesystem');INSERT INTO `acl_items` VALUES (12, 0, 'Module read: groups');INSERT INTO `acl_items` VALUES (13, 0, 'Module write: groups');INSERT INTO `acl_items` VALUES (14, 0, 'Module read: projects');INSERT INTO `acl_items` VALUES (15, 0, 'Module write: projects');INSERT INTO `acl_items` VALUES (16, 0, 'Module read: summary');INSERT INTO `acl_items` VALUES (17, 0, 'Module write: summary');INSERT INTO `acl_items` VALUES (18, 0, 'Module read: users');INSERT INTO `acl_items` VALUES (19, 0, 'Module write: users');INSERT INTO `acl_items` VALUES (20, 0, 'Module read: todos');INSERT INTO `acl_items` VALUES (21, 0, 'Module write: todos');INSERT INTO `acl_items` VALUES (22, 0, 'Module read: notes');INSERT INTO `acl_items` VALUES (23, 0, 'Module write: notes');INSERT INTO `acl_items` VALUES (24, 1, 'calendar read: Administrator, Group-Office');INSERT INTO `acl_items` VALUES (25, 1, 'calendar write: Administrator, Group-Office');-- ---------------------------------------------------------- -- Tabel structuur voor tabel `cal_calendars`-- DROP TABLE IF EXISTS `cal_calendars`;CREATE TABLE `cal_calendars` (  `id` int(11) NOT NULL default '0',  `group_id` int(11) NOT NULL default '1',  `user_id` int(11) NOT NULL default '0',  `acl_read` int(11) NOT NULL default '0',  `acl_write` int(11) NOT NULL default '0',  `name` varchar(100) NOT NULL default '',  `start_hour` tinyint(4) NOT NULL default '0',  `end_hour` tinyint(4) NOT NULL default '0',  `background` varchar(6) NOT NULL default 'FFFFCC',  `time_interval` int(11) NOT NULL default '1800',  PRIMARY KEY  (`id`),  KEY `group_id` (`group_id`)) TYPE=MyISAM;-- -- Gegevens worden uitgevoerd voor tabel `cal_calendars`-- INSERT INTO `cal_calendars` VALUES (1, 1, 1, 24, 25, 'Administrator, Group-Office', 7, 20, 'FFFFCC', 1800);-- ---------------------------------------------------------- -- Tabel structuur voor tabel `cal_events`-- DROP TABLE IF EXISTS `cal_events`;CREATE TABLE `cal_events` (  `id` int(11) NOT NULL default '0',  `event_id` int(11) NOT NULL default '0',  `user_id` int(11) NOT NULL default '0',  `permissions` tinyint(4) NOT NULL default '0',  `acl_read` int(11) NOT NULL default '0',  `acl_write` int(11) NOT NULL default '0',  `start_time` int(11) NOT NULL default '0',  `end_time` int(11) NOT NULL default '0',  `all_day_event` enum('0','1') NOT NULL default '0',  `link_id` int(11) NOT NULL default '0',  `name` varchar(100) NOT NULL default '',  `description` text NOT NULL,  `location` varchar(100) NOT NULL default '',  `background` varchar(7) NOT NULL default '',  `repeat_type` enum('0','1','2','3','4','5') NOT NULL default '0',  `repeat_forever` enum('0','1') NOT NULL default '0',  `repeat_every` tinyint(4) NOT NULL default '0',  `repeat_end_time` int(11) NOT NULL default '0',  `mon` enum('0','1') NOT NULL default '0',  `tue` enum('0','1') NOT NULL default '0',  `wed` enum('0','1') NOT NULL default '0',  `thu` enum('0','1') NOT NULL default '0',  `fri` enum('0','1') NOT NULL default '0',  `sat` enum('0','1') NOT NULL default '0',  `sun` enum('0','1') NOT NULL default '0',  `month_time` enum('0','1','2','3','4','5') NOT NULL default '0',  `reminder` int(11) NOT NULL default '0',  `ctime` int(11) NOT NULL default '0',  `mtime` int(11) NOT NULL default '0',  `todo` enum('0','1') NOT NULL default '0',  `completion_time` int(11) NOT NULL default '0',  `status_id` tinyint(4) NOT NULL default '0',  `custom_fields` text NOT NULL,  PRIMARY KEY  (`id`),  KEY `start_time` (`start_time`),  KEY `end_time` (`end_time`),  KEY `repeat_end_time` (`repeat_end_time`),  KEY `acl_read` (`acl_read`),  KEY `acl_write` (`acl_write`),  KEY `todo` (`todo`),  KEY `event_id` (`event_id`),  KEY `link_id` (`link_id`)) TYPE=MyISAM;-- -- Gegevens worden uitgevoerd voor tabel `cal_events`-- -- ---------------------------------------------------------- -- Tabel structuur voor tabel `cal_events_calendars`-- DROP TABLE IF EXISTS `cal_events_calendars`;CREATE TABLE `cal_events_calendars` (  `calendar_id` int(11) NOT NULL default '0',  `event_id` int(11) NOT NULL default '0',  `sid` char(32) NOT NULL default '',  KEY `calendar_id` (`calendar_id`,`event_id`)) TYPE=MyISAM;-- -- Gegevens worden uitgevoerd voor tabel `cal_events_calendars`-- -- ---------------------------------------------------------- -- Tabel structuur voor tabel `cal_exceptions`-- DROP TABLE IF EXISTS `cal_exceptions`;CREATE TABLE `cal_exceptions` (  `id` int(11) NOT NULL default '0',  `event_id` int(11) NOT NULL default '0',  `time` int(11) NOT NULL default '0',  PRIMARY KEY  (`id`),  KEY `event_id` (`event_id`)) TYPE=MyISAM;-- -- Gegevens worden uitgevoerd voor tabel `cal_exceptions`-- -- ---------------------------------------------------------- -- Tabel structuur voor tabel `cal_group_admins`-- DROP TABLE IF EXISTS `cal_group_admins`;CREATE TABLE `cal_group_admins` (  `group_id` int(11) NOT NULL default '0',  `user_id` int(11) NOT NULL default '0',  PRIMARY KEY  (`group_id`,`user_id`)) TYPE=MyISAM;-- -- Gegevens worden uitgevoerd voor tabel `cal_group_admins`-- -- ---------------------------------------------------------- -- Tabel structuur voor tabel `cal_groups`-- DROP TABLE IF EXISTS `cal_groups`;CREATE TABLE `cal_groups` (  `id` int(11) NOT NULL default '0',  `name` varchar(100) NOT NULL default '',  `custom_fields` text NOT NULL,  `acl_write` int(11) NOT NULL default '0',  PRIMARY KEY  (`id`)) TYPE=MyISAM;-- -- Gegevens worden uitgevoerd voor tabel `cal_groups`-- -- ---------------------------------------------------------- -- Tabel structuur voor tabel `cal_holidays`-- DROP TABLE IF EXISTS `cal_holidays`;CREATE TABLE `cal_holidays` (  `id` int(11) NOT NULL default '0',  `user_id` int(11) NOT NULL default '0',  `calendar_id` int(11) NOT NULL default '0',  `date` int(10) NOT NULL default '0',  `name` varchar(100) NOT NULL default '',  `region` varchar(4) NOT NULL default '',  PRIMARY KEY  (`id`)) TYPE=MyISAM;-- -- Gegevens worden uitgevoerd voor tabel `cal_holidays`-- INSERT INTO `cal_holidays` VALUES (1, 1, 1, 1136070000, 'Nieuwjaar', 'nl');INSERT INTO `cal_holidays` VALUES (2, 1, 1, 1139871600, 'Valentijnsdag', 'nl');INSERT INTO `cal_holidays` VALUES (3, 1, 1, 1144965600, 'Goede vrijdag', 'nl');INSERT INTO `cal_holidays` VALUES (4, 1, 1, 1145138400, '1e Paasdag', 'nl');INSERT INTO `cal_holidays` VALUES (5, 1, 1, 1145224800, '2e Paasdag', 'nl');INSERT INTO `cal_holidays` VALUES (6, 1, 1, 1146348000, 'Koninginnedag', 'nl');INSERT INTO `cal_holidays` VALUES (7, 1, 1, 1146780000, 'Bevrijdingsdag', 'nl');INSERT INTO `cal_holidays` VALUES (8, 1, 1, 1148508000, 'Hemelvaartsdag', 'nl');INSERT INTO `cal_holidays` VALUES (9, 1, 1, 1149372000, '1e pinksterdag', 'nl');INSERT INTO `cal_holidays` VALUES (10, 1, 1, 1149458400, '2e pinksterdag', 'nl');INSERT INTO `cal_holidays` VALUES (11, 1, 1, 1159912800, 'Wereld dierendag', 'nl');INSERT INTO `cal_holidays` VALUES (12, 1, 1, 1163199600, 'Sint Maarten', 'nl');INSERT INTO `cal_holidays` VALUES (13, 1, 1, 1167001200, '1e kerstdag', 'nl');INSERT INTO `cal_holidays` VALUES (14, 1, 1, 1167087600, '2e kerstdag', 'nl');INSERT INTO `cal_holidays` VALUES (15, 1, 1, 1167519600, 'Oudjaarsavond', 'nl');-- ---------------------------------------------------------- -- Tabel structuur voor tabel `cal_participants`-- DROP TABLE IF EXISTS `cal_participants`;CREATE TABLE `cal_participants` (  `id` int(11) NOT NULL default '0',  `event_id` int(11) NOT NULL default '0',  `name` varchar(50) NOT NULL default '',  `email` varchar(100) NOT NULL default '',  `user_id` int(11) NOT NULL default '0',  `status` enum('0','1','2') NOT NULL default '0',  PRIMARY KEY  (`id`)) TYPE=MyISAM;-- -- Gegevens worden uitgevoerd voor tabel `cal_participants`-- -- ---------------------------------------------------------- -- Tabel structuur voor tabel `cal_reminders`-- DROP TABLE IF EXISTS `cal_reminders`;CREATE TABLE `cal_reminders` (  `user_id` int(11) NOT NULL default '0',  `event_id` int(11) NOT NULL default '0',  `remind_time` int(11) NOT NULL default '0',  `occurence_time` int(11) NOT NULL default '0',  `email_sent` enum('0','1') NOT NULL default '0',  KEY `user_id` (`user_id`),  KEY `remind_time` (`remind_time`),  KEY `email_sent` (`email_sent`)) TYPE=MyISAM;-- -- Gegevens worden uitgevoerd voor tabel `cal_reminders`-- -- ---------------------------------------------------------- -- Tabel structuur voor tabel `cal_settings`-- DROP TABLE IF EXISTS `cal_settings`;CREATE TABLE `cal_settings` (  `user_id` int(11) NOT NULL default '0',  `default_cal_id` int(11) NOT NULL default '0',  `default_view_id` int(11) NOT NULL default '0',  `show_days` tinyint(4) NOT NULL default '0',  `merged_view` enum('0','1') NOT NULL default '0',  `sort_field` varchar(20) NOT NULL default '',  `sort_order` varchar(4) NOT NULL default '',  `reminder` int(11) NOT NULL default '0',  `refresh_rate` varchar(5) NOT NULL default '',  `permissions` tinyint(4) NOT NULL default '0',  `show_todos` enum('0','1') NOT NULL default '0',  `weekview` enum('5','7') NOT NULL default '7',  `show_completed` enum('0','1') NOT NULL default '0',  `view_type` enum('grid','list') NOT NULL default 'grid',  PRIMARY KEY  (`user_id`)) TYPE=MyISAM;-- -- Gegevens worden uitgevoerd voor tabel `cal_settings`-- INSERT INTO `cal_settings` VALUES (1, 1, 0, 0, '0', '', '', 0, '', 0, '0', '7', '0', 'grid');-- ---------------------------------------------------------- -- Tabel structuur voor tabel `cal_statuses`-- DROP TABLE IF EXISTS `cal_statuses`;CREATE TABLE `cal_statuses` (  `id` int(11) NOT NULL default '0',  `type` varchar(20) NOT NULL default '',  `name` varchar(50) NOT NULL default '',  PRIMARY KEY  (`id`),  KEY `type` (`type`)) TYPE=MyISAM;-- -- Gegevens worden uitgevoerd voor tabel `cal_statuses`-- INSERT INTO `cal_statuses` VALUES (1, 'VEVENT', 'NEEDS-ACTION');INSERT INTO `cal_statuses` VALUES (2, 'VEVENT', 'ACCEPTED');INSERT INTO `cal_statuses` VALUES (3, 'VEVENT', 'DECLINED');INSERT INTO `cal_statuses` VALUES (4, 'VEVENT', 'TENTATIVE');INSERT INTO `cal_statuses` VALUES (5, 'VEVENT', 'DELEGATED');INSERT INTO `cal_statuses` VALUES (6, 'VTODO', 'NEEDS-ACTION');INSERT INTO `cal_statuses` VALUES (7, 'VTODO', 'ACCEPTED');INSERT INTO `cal_statuses` VALUES (8, 'VTODO', 'DECLINED');INSERT INTO `cal_statuses` VALUES (9, 'VTODO', 'TENTATIVE');INSERT INTO `cal_statuses` VALUES (10, 'VTODO', 'DELEGATED');INSERT INTO `cal_statuses` VALUES (11, 'VTODO', 'COMPLETED');INSERT INTO `cal_statuses` VALUES (12, 'VTODO', 'IN-PROCESS');-- ---------------------------------------------------------- -- Tabel structuur voor tabel `cal_subscribed`-- DROP TABLE IF EXISTS `cal_subscribed`;CREATE TABLE `cal_subscribed` (  `calendar_id` int(11) NOT NULL default '0',  `user_id` int(11) NOT NULL default '0',  `standard` enum('0','1') NOT NULL default '0') TYPE=MyISAM;-- -- Gegevens worden uitgevoerd voor tabel `cal_subscribed`-- -- ---------------------------------------------------------- -- Tabel structuur voor tabel `cal_views`-- DROP TABLE IF EXISTS `cal_views`;CREATE TABLE `cal_views` (  `id` int(11) NOT NULL default '0',  `user_id` int(11) NOT NULL default '0',  `name` varchar(50) NOT NULL default '',  `start_hour` tinyint(4) NOT NULL default '0',  `end_hour` tinyint(4) NOT NULL default '0',  `event_colors_override` enum('0','1') NOT NULL default '0',  `time_interval` int(11) NOT NULL default '1800',  `acl_read` int(11) NOT NULL default '0',  `acl_write` int(11) NOT NULL default '0',  PRIMARY KEY  (`id`),  KEY `user_id` (`user_id`)) TYPE=MyISAM;-- -- Gegevens worden uitgevoerd voor tabel `cal_views`-- -- ---------------------------------------------------------- -- Tabel structuur voor tabel `cal_views_calendars`-- DROP TABLE IF EXISTS `cal_views_calendars`;CREATE TABLE `cal_views_calendars` (  `view_id` int(11) NOT NULL default '0',  `calendar_id` int(11) NOT NULL default '0',  `background` char(6) NOT NULL default 'CCFFCC',  PRIMARY KEY  (`view_id`,`calendar_id`)) TYPE=MyISAM;-- -- Gegevens worden uitgevoerd voor tabel `cal_views_calendars`-- -- ---------------------------------------------------------- -- Tabel structuur voor tabel `countries`--