-- 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, 'webmaster@example.com');INSERT INTO `acl_items` VALUES (4, 0, 'Module read: addressbook');