groupoffice-installed.sql

groupoffice

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`
--