groupoffice-installed.sql

groupoffice

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl1-Debian-1ubuntu1.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generatie Tijd: 09 Mar 2006 om 08:52
-- Server versie: 4.0.24
-- PHP Versie: 5.0.5-2ubuntu1.1
-- 
-- Database: `go215`
-- 

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

-- 
-- Tabel structuur voor tabel `ab_addressbooks`
-- 

DROP TABLE IF EXISTS `ab_addressbooks`;
CREATE TABLE `ab_addressbooks` (
  `id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `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 `ab_addressbooks`
-- 


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

-- 
-- Tabel structuur voor tabel `ab_companies`
-- 

DROP TABLE IF EXISTS `ab_companies`;
CREATE TABLE `ab_companies` (
  `id` int(11) NOT NULL default '0',
  `link_id` int(11) default NULL,
  `user_id` int(11) NOT NULL default '0',
  `addressbook_id` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `address` varchar(100) NOT NULL default '',
  `address_no` varchar(10) NOT NULL default '',
  `zip` varchar(10) NOT NULL default '',
  `city` varchar(50) NOT NULL default '',
  `state` varchar(50) NOT NULL default '',
  `country` varchar(50) NOT NULL default '',
  `post_address` varchar(100) NOT NULL default '',
  `post_address_no` varchar(10) NOT NULL default '',
  `post_city` varchar(50) NOT NULL default '',
  `post_state` varchar(50) NOT NULL default '',
  `post_country` varchar(50) NOT NULL default '',
  `post_zip` varchar(10) NOT NULL default '',
  `phone` varchar(20) NOT NULL default '',
  `fax` varchar(20) NOT NULL default '',
  `email` varchar(75) NOT NULL default '',
  `homepage` varchar(100) NOT NULL default '',
  `bank_no` varchar(20) NOT NULL default '',
  `vat_no` varchar(30) NOT NULL default '',
  `ctime` int(11) NOT NULL default '0',
  `mtime` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `addressbook_id` (`addressbook_id`),
  KEY `addressbook_id_2` (`addressbook_id`),
  KEY `link_id` (`link_id`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `ab_companies`
-- 


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

-- 
-- Tabel structuur voor tabel `ab_contacts`
-- 

DROP TABLE IF EXISTS `ab_contacts`;
CREATE TABLE `ab_contacts` (
  `id` int(11) NOT NULL default '0',
  `link_id` int(11) default NULL,
  `user_id` int(11) NOT NULL default '0',
  `addressbook_id` int(11) NOT NULL default '0',
  `source_id` int(11) NOT NULL default '0',
  `group_id` int(11) NOT NULL default '0',
  `first_name` varchar(50) NOT NULL default '',
  `middle_name` varchar(50) NOT NULL default '',
  `last_name` varchar(50) NOT NULL default '',
  `initials` varchar(10) NOT NULL default '',
  `title` varchar(10) NOT NULL default '',
  `sex` enum('M','F') NOT NULL default 'M',
  `birthday` date NOT NULL default '0000-00-00',
  `email` varchar(100) NOT NULL default '',
  `email2` varchar(100) NOT NULL default '',
  `email3` varchar(100) NOT NULL default '',
  `company_id` int(11) NOT NULL default '0',
  `department` varchar(50) NOT NULL default '',
  `function` varchar(50) NOT NULL default '',
  `home_phone` varchar(20) NOT NULL default '',
  `work_phone` varchar(20) NOT NULL default '',
  `fax` varchar(20) NOT NULL default '',
  `work_fax` varchar(20) NOT NULL default '',
  `cellular` varchar(20) NOT NULL default '',
  `country` varchar(50) NOT NULL default '',
  `state` varchar(50) NOT NULL default '',
  `city` varchar(50) NOT NULL default '',
  `zip` varchar(10) NOT NULL default '',
  `address` varchar(100) NOT NULL default '',
  `address_no` varchar(10) NOT NULL default '',
  `comment` varchar(50) NOT NULL default '',
  `color` varchar(6) NOT NULL default '',
  `sid` varchar(32) NOT NULL default '',
  `ctime` int(11) NOT NULL default '0',
  `mtime` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `user_id` (`addressbook_id`),
  KEY `link_id` (`link_id`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `ab_contacts`
-- 


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

-- 
-- Tabel structuur voor tabel `ab_custom_company_fields`
-- 

DROP TABLE IF EXISTS `ab_custom_company_fields`;
CREATE TABLE `ab_custom_company_fields` (
  `id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `ab_custom_company_fields`
-- 


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

-- 
-- Tabel structuur voor tabel `ab_custom_company_fields_cats`
-- 

DROP TABLE IF EXISTS `ab_custom_company_fields_cats`;
CREATE TABLE `ab_custom_company_fields_cats` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `acl_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `ab_custom_company_fields_cats`
-- 


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

-- 
-- Tabel structuur voor tabel `ab_custom_company_fields_sort`
-- 

DROP TABLE IF EXISTS `ab_custom_company_fields_sort`;
CREATE TABLE `ab_custom_company_fields_sort` (
  `catagory_id` int(11) NOT NULL default '0',
  `field` varchar(50) NOT NULL default '',
  `size` tinyint(4) NOT NULL default '0',
  `sort_index` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`field`),
  KEY `catagory_id` (`catagory_id`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `ab_custom_company_fields_sort`
-- 


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

-- 
-- Tabel structuur voor tabel `ab_custom_contact_fields`
-- 

DROP TABLE IF EXISTS `ab_custom_contact_fields`;
CREATE TABLE `ab_custom_contact_fields` (
  `id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `ab_custom_contact_fields`
-- 


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

-- 
-- Tabel structuur voor tabel `ab_custom_contact_fields_cats`
-- 

DROP TABLE IF EXISTS `ab_custom_contact_fields_cats`;
CREATE TABLE `ab_custom_contact_fields_cats` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `acl_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `ab_custom_contact_fields_cats`
-- 


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

-- 
-- Tabel structuur voor tabel `ab_custom_contact_fields_sort`
-- 

DROP TABLE IF EXISTS `ab_custom_contact_fields_sort`;
CREATE TABLE `ab_custom_contact_fields_sort` (
  `catagory_id` int(11) NOT NULL default '0',
  `field` varchar(50) NOT NULL default '',
  `size` tinyint(4) NOT NULL default '0',
  `sort_index` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`field`),
  KEY `sort_index` (`sort_index`),
  KEY `catagory_id` (`catagory_id`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `ab_custom_contact_fields_sort`
-- 


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

-- 
-- Tabel structuur voor tabel `ab_groups`
-- 

DROP TABLE IF EXISTS `ab_groups`;
CREATE TABLE `ab_groups` (
  `id` int(11) NOT NULL default '0',
  `addressbook_id` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`),
  KEY `user_id` (`addressbook_id`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `ab_groups`
-- 


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

-- 
-- Tabel structuur voor tabel `ab_settings`
-- 

DROP TABLE IF EXISTS `ab_settings`;
CREATE TABLE `ab_settings` (
  `user_id` int(11) NOT NULL default '0',
  `search_type` varchar(10) NOT NULL default '',
  `search_contacts_field` varchar(30) NOT NULL default '',
  `search_companies_field` varchar(30) NOT NULL default '',
  `search_users_field` varchar(30) NOT NULL default '',
  `search_addressbook_id` int(11) NOT NULL default '0',
  `addressbook_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `ab_settings`
-- 


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

-- 
-- Tabel structuur voor tabel `ab_subscribed`
-- 

DROP TABLE IF EXISTS `ab_subscribed`;
CREATE TABLE `ab_subscribed` (
  `user_id` int(11) NOT NULL default '0',
  `addressbook_id` int(11) NOT NULL default '0',
  `standard` enum('0','1') NOT NULL default '0',
  KEY `user_id` (`user_id`,`addressbook_id`,`standard`),
  KEY `addressbook_id` (`addressbook_id`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `ab_subscribed`
-- 


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

-- 
-- Tabel structuur voor tabel `acl`
-- 

DROP TABLE IF EXISTS `acl`;
CREATE TABLE `acl` (
  `acl_id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `group_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`acl_id`,`user_id`,`group_id`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `acl`
-- 

INSERT INTO `acl` VALUES (1, 0, 1);
INSERT INTO `acl` VALUES (2, 0, 1);
INSERT INTO `acl` VALUES (3, 0, 1);
INSERT INTO `acl` VALUES (3, 0, 2);
INSERT INTO `acl` VALUES (4, 0, 1);
INSERT INTO `acl` VALUES (4, 1, 0);
INSERT INTO `acl` VALUES (5, 0, 1);
INSERT INTO `acl` VALUES (5, 1, 0);
INSERT INTO `acl` VALUES (6, 0, 1);
INSERT INTO `acl` VALUES (6, 1, 0);
INSERT INTO `acl` VALUES (7, 0, 1);
INSERT INTO `acl` VALUES (7, 1, 0);
INSERT INTO `acl` VALUES (8, 0, 1);
INSERT INTO `acl` VALUES (8, 1, 0);
INSERT INTO `acl` VALUES (9, 0, 1);
INSERT INTO `acl` VALUES (9, 1, 0);
INSERT INTO `acl` VALUES (10, 0, 1);
INSERT INTO `acl` VALUES (10, 1, 0);
INSERT INTO `acl` VALUES (11, 0, 1);
INSERT INTO `acl` VALUES (11, 1, 0);
INSERT INTO `acl` VALUES (12, 0, 1);
INSERT INTO `acl` VALUES (12, 1, 0);
INSERT INTO `acl` VALUES (13, 0, 1);
INSERT INTO `acl` VALUES (13, 1, 0);
INSERT INTO `acl` VALUES (14, 0, 1);
INSERT INTO `acl` VALUES (14, 1, 0);
INSERT INTO `acl` VALUES (15, 0, 1);
INSERT INTO `acl` VALUES (15, 1, 0);
INSERT INTO `acl` VALUES (16, 0, 1);
INSERT INTO `acl` VALUES (16, 1, 0);
INSERT INTO `acl` VALUES (17, 0, 1);
INSERT INTO `acl` VALUES (17, 1, 0);
INSERT INTO `acl` VALUES (18, 0, 1);
INSERT INTO `acl` VALUES (18, 1, 0);
INSERT INTO `acl` VALUES (19, 0, 1);
INSERT INTO `acl` VALUES (19, 1, 0);
INSERT INTO `acl` VALUES (20, 0, 1);
INSERT INTO `acl` VALUES (20, 1, 0);
INSERT INTO `acl` VALUES (21, 0, 1);
INSERT INTO `acl` VALUES (21, 1, 0);
INSERT INTO `acl` VALUES (22, 0, 1);
INSERT INTO `acl` VALUES (22, 1, 0);
INSERT INTO `acl` VALUES (23, 0, 1);
INSERT INTO `acl` VALUES (23, 1, 0);
INSERT INTO `acl` VALUES (24, 0, 1);
INSERT INTO `acl` VALUES (25, 0, 1);
INSERT INTO `acl` VALUES (25, 1, 0);

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

-- 
-- Tabel structuur voor tabel `acl_items`
-- 

DROP TABLE IF EXISTS `acl_items`;
CREATE TABLE `acl_items` (
  `id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `description` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `acl_items`
-- 

INSERT INTO `acl_items` VALUES (1, 0, 'Module read: modules');
INSERT INTO `acl_items` VALUES (2, 0, 'Module write: modules');
INSERT INTO `acl_items` VALUES (3, 1, '[e-mail]');
INSERT INTO `acl_items` VALUES (4, 0, 'Module read: addressbook');