[Phpgroupware-cvs] CVS: cdb/doc cdb.sql,1.10,1.11

[Brian Morel <address@hidden>]

Update of /cvsroot/phpgroupware/cdb/doc
In directory subversions:/tmp/cvs-serv5019

Modified Files:
        cdb.sql 
Log Message:
fixed to match table definitions in setup

Index: cdb.sql
===================================================================
RCS file: /cvsroot/phpgroupware/cdb/doc/cdb.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -r1.10 -r1.11
*** cdb.sql     17 Feb 2002 05:11:47 -0000      1.10
--- cdb.sql     20 Feb 2002 22:11:57 -0000      1.11
***************
*** 98,102 ****
  # Have patience, and all will be good.
  #
! #INSERT INTO applications (app_name, app_title, app_enabled, app_order, 
app_tables, app_version) VALUES 
('cdb','cdb-devel',1,31,'cdb_category,cdb_category_link,cdb_contact_address,cdb_contact_address_category,cdb_contact_client,cdb_contact_flag,cdb_contact_flag_link,cdb_contact_followup,cdb_contact_internet,cdb_contact_main,cdb_contact_meta,cdb_entity_notes,cdb_contact_organization,cdb_contact_personal,cdb_contact_phone,cdb_contact_phone_category,cdb_language,cdb_organization,cdb_organization_client,cdb_organization_location,cdb_organization_meta,cdb_entity_notes',1.5);
  
  #
--- 98,102 ----
  # Have patience, and all will be good.
  #
! #INSERT INTO applications (app_name, app_title, app_enabled, app_order, 
app_tables, app_version) VALUES 
('cdb','cdb-devel',1,31,'phpgw_cdb_category,phpgw_cdb_category_link,phpgw_cdb_contact_addr,phpgw_cdb_contact_addr_cat,phpgw_cdb_contact_client,phpgw_cdb_contact_flag,phpgw_cdb_contact_flag_link,phpgw_cdb_contact_followup,phpgw_cdb_contact_internet,phpgw_cdb_contact_main,phpgw_cdb_entity_meta,phpgw_cdb_entity_notes,phpgw_cdb_contact_org,phpgw_cdb_contact_personal,phpgw_cdb_contact_phone,phpgw_cdb_contact_phone_cat,phpgw_cdb_language,phpgw_cdb_org,phpgw_cdb_org_client,phpgw_cdb_org_location,phpgw_entity_id',1.5);
  
  #
***************
*** 107,138 ****
  #
  
! #DROP TABLE IF EXISTS cdb_contact_main;
! #DROP TABLE IF EXISTS cdb_contact_personal;
! #DROP TABLE IF EXISTS cdb_contact_db;
! #DROP TABLE IF EXISTS cdb_contact_meta;
! #DROP TABLE IF EXISTS cdb_contact_client;
! #DROP TABLE IF EXISTS cdb_entity_notes;
! #DROP TABLE IF EXISTS cdb_contact_internet;
! #DROP TABLE IF EXISTS cdb_contact_phone;
! #DROP TABLE IF EXISTS cdb_contact_phone_category;
! #DROP TABLE IF EXISTS cdb_contact_address;
! #DROP TABLE IF EXISTS cdb_contact_organization;
! #DROP TABLE IF EXISTS cdb_contact_address_category;
! #DROP TABLE IF EXISTS cdb_category;
! #DROP TABLE IF EXISTS cdb_category_link;
! #DROP TABLE IF EXISTS cdb_language;
! #DROP TABLE IF EXISTS cdb_contact_flag;
! #DROP TABLE IF EXISTS cdb_contact_flag_link;
! #DROP TABLE IF EXISTS cdb_contact_followup;
! #DROP TABLE IF EXISTS cdb_organization;
! #DROP TABLE IF EXISTS cdb_organization_client;
! #DROP TABLE IF EXISTS cdb_organization_db;
! #DROP TABLE IF EXISTS cdb_organization_meta;
! #DROP TABLE IF EXISTS cdb_organization_location;
  
  #
  # Table structure for table 'entity_id'
  #
! CREATE TABLE cdb_entity_id (
    entity_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    contact_id int(11) unsigned DEFAULT '0',
--- 107,138 ----
  #
  
! #DROP TABLE IF EXISTS phpgw_cdb_contact_main;
! #DROP TABLE IF EXISTS phpgw_cdb_contact_personal;
! #DROP TABLE IF EXISTS phpgw_cdb_contact_db;
! #DROP TABLE IF EXISTS phpgw_cdb_contact_meta;
! #DROP TABLE IF EXISTS phpgw_cdb_contact_client;
! #DROP TABLE IF EXISTS phpgw_cdb_entity_notes;
! #DROP TABLE IF EXISTS phpgw_cdb_contact_internet;
! #DROP TABLE IF EXISTS phpgw_cdb_contact_phone;
! #DROP TABLE IF EXISTS phpgw_cdb_contact_phone_cat;
! #DROP TABLE IF EXISTS phpgw_cdb_contact_add;
! #DROP TABLE IF EXISTS phpgw_cdb_contact_org;
! #DROP TABLE IF EXISTS phpgw_cdb_contact_addr_cat;
! #DROP TABLE IF EXISTS phpgw_cdb_category;
! #DROP TABLE IF EXISTS phpgw_cdb_category_link;
! #DROP TABLE IF EXISTS phpgw_cdb_language;
! #DROP TABLE IF EXISTS phpgw_cdb_contact_flag;
! #DROP TABLE IF EXISTS phpgw_cdb_contact_flag_link;
! #DROP TABLE IF EXISTS phpgw_cdb_contact_followup;
! #DROP TABLE IF EXISTS phpgw_cdb_org;
! #DROP TABLE IF EXISTS phpgw_cdb_org_client;
! #DROP TABLE IF EXISTS phpgw_cdb_org_db;
! #DROP TABLE IF EXISTS phpgw_cdb_org_meta;
! #DROP TABLE IF EXISTS phpgw_cdb_org_location;
  
  #
  # Table structure for table 'entity_id'
  #
! CREATE TABLE phpgw_cdb_entity_id (
    entity_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    contact_id int(11) unsigned DEFAULT '0',
***************
*** 146,150 ****
  # Table structure for table 'contact_main'
  #
! CREATE TABLE cdb_contact_main (
    contact_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    main_organization_location_selector int(11) unsigned DEFAULT '0' NOT NULL,
--- 146,150 ----
  # Table structure for table 'contact_main'
  #
! CREATE TABLE phpgw_cdb_contact_main (
    contact_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    main_organization_location_selector int(11) unsigned DEFAULT '0' NOT NULL,
***************
*** 175,179 ****
  # Table structure for table 'contact_phone'
  #
! CREATE TABLE cdb_contact_phone (
    contact_phone_id int(11) unsigned DEFAULT '0' NOT NULL,
    entity_id int(11) unsigned DEFAULT '0' NOT NULL,
--- 175,179 ----
  # Table structure for table 'contact_phone'
  #
! CREATE TABLE phpgw_cdb_contact_phone (
    contact_phone_id int(11) unsigned DEFAULT '0' NOT NULL,
    entity_id int(11) unsigned DEFAULT '0' NOT NULL,
***************
*** 192,196 ****
  # below is College Telephone number.
  #
! CREATE TABLE cdb_contact_phone_category (
    phone_category_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    phone_category_name char(20) NOT NULL,
--- 192,196 ----
  # below is College Telephone number.
  #
! CREATE TABLE phpgw_cdb_contact_phone_cat (
    phone_category_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    phone_category_name char(20) NOT NULL,
***************
*** 203,229 ****
  #
  
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (1,'Business Phone');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (2,'Business Phone2');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (3,'Business Pager');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (4,'Business Fax');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (5,'Home Phone');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (6,'Home Phone2');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (7,'Home Pager');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (8,'Home Fax');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (9,'Other Phone');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (10,'Other Pager');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (11,'Other Fax');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (12,'Call Back');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (13,'Car Phone');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (14,'ISDN');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (15,'Mobile Phone');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (16,'Primary Phone');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (17,'Radio Phone');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (18,'Telex');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (19,'TTY/TDD Phone');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (20,'Family Phone');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (21,'Vacation Home Phone');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (22,'School Phone');
! INSERT INTO cdb_contact_phone_category (phone_category_id, 
phone_category_name) VALUES (23,'Answering Service');
  
  #
--- 203,229 ----
  #
  
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (1,'Business Phone');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (2,'Business Phone2');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (3,'Business Pager');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (4,'Business Fax');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (5,'Home Phone');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (6,'Home Phone2');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (7,'Home Pager');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (8,'Home Fax');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (9,'Other Phone');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (10,'Other Pager');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (11,'Other Fax');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (12,'Call Back');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (13,'Car Phone');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (14,'ISDN');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (15,'Mobile Phone');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (16,'Primary Phone');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (17,'Radio Phone');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (18,'Telex');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (19,'TTY/TDD Phone');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (20,'Family Phone');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (21,'Vacation Home Phone');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (22,'School Phone');
! INSERT INTO phpgw_cdb_contact_phone_cat (phone_category_id, 
phone_category_name) VALUES (23,'Answering Service');
  
  #
***************
*** 234,238 ****
  # save input time and errors.
  #
! CREATE TABLE cdb_organization (
    organization_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    organization_name varchar(100) NOT NULL,
--- 234,238 ----
  # save input time and errors.
  #
! CREATE TABLE phpgw_cdb_org (
    organization_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    organization_name varchar(100) NOT NULL,
***************
*** 250,254 ****
  # NOTE: location can be location or department
  #
! CREATE TABLE cdb_organization_location (
    location_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    organization_id int(11) unsigned NOT NULL,
--- 250,254 ----
  # NOTE: location can be location or department
  #
! CREATE TABLE phpgw_cdb_org_location (
    location_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    organization_id int(11) unsigned NOT NULL,
***************
*** 269,273 ****
  # own set of info.
  #
! CREATE TABLE cdb_organization_client (
    organization_id int(11) unsigned DEFAULT '0' NOT NULL,
    account text,
--- 269,273 ----
  # own set of info.
  #
! CREATE TABLE phpgw_cdb_org_client (
    organization_id int(11) unsigned DEFAULT '0' NOT NULL,
    account text,
***************
*** 283,287 ****
  # the other tables optimized. 
  #
! CREATE TABLE cdb_entity_notes (
    entity_id int(11) unsigned DEFAULT '0' NOT NULL,
    note text,
--- 283,287 ----
  # the other tables optimized. 
  #
! CREATE TABLE phpgw_cdb_entity_notes (
    entity_id int(11) unsigned DEFAULT '0' NOT NULL,
    note text,
***************
*** 299,303 ****
  # assistant's name and department and such.
  #
! CREATE TABLE cdb_contact_organization (
    organization_link_id int(11) unsigned DEFAULT '0' NOT NULL,
    organization_location_id int(11) unsigned DEFAULT '0' NOT NULL,
--- 299,303 ----
  # assistant's name and department and such.
  #
! CREATE TABLE phpgw_cdb_contact_org (
    organization_link_id int(11) unsigned DEFAULT '0' NOT NULL,
    organization_location_id int(11) unsigned DEFAULT '0' NOT NULL,
***************
*** 318,322 ****
  # of info.
  #
! CREATE TABLE cdb_contact_client (
    contact_id int(11) unsigned DEFAULT '0' NOT NULL,
    account text,
--- 318,322 ----
  # of info.
  #
! CREATE TABLE phpgw_cdb_contact_client (
    contact_id int(11) unsigned DEFAULT '0' NOT NULL,
    account text,
***************
*** 331,335 ****
  # Contact's personal information
  #'
! CREATE TABLE cdb_contact_personal (
    contact_id int(11) unsigned DEFAULT '0' NOT NULL,
    birthday int(11),
--- 331,335 ----
  # Contact's personal information
  #'
! CREATE TABLE phpgw_cdb_contact_personal (
    contact_id int(11) unsigned DEFAULT '0' NOT NULL,
    birthday int(11),
***************
*** 349,353 ****
  # compatibility and international contacts.
  #
! CREATE TABLE cdb_language (
    language_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    language_name char(40) NOT NULL,
--- 349,353 ----
  # compatibility and international contacts.
  #
! CREATE TABLE phpgw_cdb_language (
    language_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    language_name char(40) NOT NULL,
***************
*** 367,371 ****
  # Table structure for table 'category'
  #
! CREATE TABLE cdb_category (
    category_id int(11) unsigned DEFAULT '0' NOT NULL,
    name char(40) NOT NULL,
--- 367,371 ----
  # Table structure for table 'category'
  #
! CREATE TABLE phpgw_cdb_category (
    category_id int(11) unsigned DEFAULT '0' NOT NULL,
    name char(40) NOT NULL,
***************
*** 377,381 ****
  # Table structure for table 'category'
  #
! CREATE TABLE cdb_category_link (
    category_link_id int(11) unsigned DEFAULT '0' NOT NULL,
    category_id int(11) unsigned DEFAULT '0' NOT NULL,
--- 377,381 ----
  # Table structure for table 'category'
  #
! CREATE TABLE phpgw_cdb_category_link (
    category_link_id int(11) unsigned DEFAULT '0' NOT NULL,
    category_id int(11) unsigned DEFAULT '0' NOT NULL,
***************
*** 391,395 ****
  # Table structure for table 'entity_meta'
  #
! CREATE TABLE cdb_entity_meta (
    entity_id int(11) unsigned DEFAULT '0' NOT NULL,
    status ENUM("active","pending","deleted") DEFAULT 'pending' NOT NULL,
--- 391,395 ----
  # Table structure for table 'entity_meta'
  #
! CREATE TABLE phpgw_cdb_entity_meta (
    entity_id int(11) unsigned DEFAULT '0' NOT NULL,
    status ENUM("active","pending","deleted") DEFAULT 'pending' NOT NULL,
***************
*** 416,420 ****
  # with the color of the flag.
  #
! CREATE TABLE cdb_contact_flag (
    flag_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    user_id int(11) DEFAULT '0' NOT NULL,
--- 416,420 ----
  # with the color of the flag.
  #
! CREATE TABLE phpgw_cdb_contact_flag (
    flag_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    user_id int(11) DEFAULT '0' NOT NULL,
***************
*** 425,429 ****
  );
  
! CREATE TABLE cdb_contact_flag_link (
    flag_link_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    user_id int(11) DEFAULT '0' NOT NULL,
--- 425,429 ----
  );
  
! CREATE TABLE phpgw_cdb_contact_flag_link (
    flag_link_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    user_id int(11) DEFAULT '0' NOT NULL,
***************
*** 440,444 ****
  # be a marker next to their name in the color specified.
  #
! CREATE TABLE cdb_contact_followup (
    followup_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    followup_name char(20),
--- 440,444 ----
  # be a marker next to their name in the color specified.
  #
! CREATE TABLE phpgw_cdb_contact_followup (
    followup_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    followup_name char(20),
***************
*** 451,461 ****
  #
  
! INSERT INTO cdb_contact_followup (followup_id, followup_name, followup_color) 
VALUES (1,'Follow Up', 'FF2222'); #red
! INSERT INTO cdb_contact_followup (followup_id, followup_name, followup_color) 
VALUES (2,'For Your Information', '6699cc'); #blue
! INSERT INTO cdb_contact_followup (followup_id, followup_name, followup_color) 
VALUES (3,'Review', '83d8a4'); #green
! INSERT INTO cdb_contact_followup (followup_id, followup_name, followup_color) 
VALUES (4,'Call', 'cccc99'); #gold
! INSERT INTO cdb_contact_followup (followup_id, followup_name, followup_color) 
VALUES (5,'Arrange Meeting', 'CC99CC'); #purple
! INSERT INTO cdb_contact_followup (followup_id, followup_name, followup_color) 
VALUES (6,'Send E-mail', 'FF9966'); #orange
! INSERT INTO cdb_contact_followup (followup_id, followup_name, followup_color) 
VALUES (7,'Send Letter', 'FFFF33'); #yellow
  
  
--- 451,461 ----
  #
  
! INSERT INTO phpgw_cdb_contact_followup (followup_id, followup_name, 
followup_color) VALUES (1,'Follow Up', 'FF2222'); #red
! INSERT INTO phpgw_cdb_contact_followup (followup_id, followup_name, 
followup_color) VALUES (2,'For Your Information', '6699cc'); #blue
! INSERT INTO phpgw_cdb_contact_followup (followup_id, followup_name, 
followup_color) VALUES (3,'Review', '83d8a4'); #green
! INSERT INTO phpgw_cdb_contact_followup (followup_id, followup_name, 
followup_color) VALUES (4,'Call', 'cccc99'); #gold
! INSERT INTO phpgw_cdb_contact_followup (followup_id, followup_name, 
followup_color) VALUES (5,'Arrange Meeting', 'CC99CC'); #purple
! INSERT INTO phpgw_cdb_contact_followup (followup_id, followup_name, 
followup_color) VALUES (6,'Send E-mail', 'FF9966'); #orange
! INSERT INTO phpgw_cdb_contact_followup (followup_id, followup_name, 
followup_color) VALUES (7,'Send Letter', 'FFFF33'); #yellow
  
  
***************
*** 463,467 ****
  # Table structure for table 'contact_internet'
  #
! CREATE TABLE cdb_contact_internet (
    contact_id int(11) unsigned DEFAULT '0' NOT NULL,
    email_home char(50),
--- 463,467 ----
  # Table structure for table 'contact_internet'
  #
! CREATE TABLE phpgw_cdb_contact_internet (
    contact_id int(11) unsigned DEFAULT '0' NOT NULL,
    email_home char(50),
***************
*** 487,491 ****
  # For example, Business, Vacation, Family, etc.
  #
! CREATE TABLE cdb_contact_address_category (
    address_category_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    address_category_name char(20) NOT NULL,
--- 487,491 ----
  # For example, Business, Vacation, Family, etc.
  #
! CREATE TABLE phpgw_cdb_contact_addr_cat (
    address_category_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    address_category_name char(20) NOT NULL,
***************
*** 498,511 ****
  #
  
! INSERT INTO cdb_contact_address_category (address_category_id, 
address_category_name) VALUES (1,'Business Address');
! INSERT INTO cdb_contact_address_category (address_category_id, 
address_category_name) VALUES (2,'Home Address');
! INSERT INTO cdb_contact_address_category (address_category_id, 
address_category_name) VALUES (3,'Other Address');
! INSERT INTO cdb_contact_address_category (address_category_id, 
address_category_name) VALUES (4,'Family Address');
! INSERT INTO cdb_contact_address_category (address_category_id, 
address_category_name) VALUES (5,'Vacation Home Address');
  
  #
  # Table structure for table 'contact_address'
  #
! CREATE TABLE cdb_contact_address (
    contact_address_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    entity_id int(11) unsigned DEFAULT '0' NOT NULL,
--- 498,511 ----
  #
  
! INSERT INTO phpgw_cdb_contact_addr_cat (address_category_id, 
address_category_name) VALUES (1,'Business Address');
! INSERT INTO phpgw_cdb_contact_addr_cat (address_category_id, 
address_category_name) VALUES (2,'Home Address');
! INSERT INTO phpgw_cdb_contact_addr_cat (address_category_id, 
address_category_name) VALUES (3,'Other Address');
! INSERT INTO phpgw_cdb_contact_addr_cat (address_category_id, 
address_category_name) VALUES (4,'Family Address');
! INSERT INTO phpgw_cdb_contact_addr_cat (address_category_id, 
address_category_name) VALUES (5,'Vacation Home Address');
  
  #
  # Table structure for table 'contact_address'
  #
! CREATE TABLE phpgw_cdb_contact_addr (
    contact_address_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    entity_id int(11) unsigned DEFAULT '0' NOT NULL,