[Phpgroupware-cvs] CVS: cdb/setup default_records.inc.php,NONE,1.1

[Brian Morel <address@hidden>]

Update of /cvsroot/phpgroupware/cdb/setup
In directory subversions:/tmp/cvs-serv10045

Added Files:
        default_records.inc.php 
Log Message:
default data for the database

--- NEW FILE ---
<?php

$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (1,'Business Phone')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (2,'Business Phone2')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (3,'Business Pager')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (4,'Business Fax')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (5,'Home Phone')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (6,'Home Phone2')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (7,'Home Pager')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (8,'Home Fax')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (9,'Other Phone')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (10,'Other Pager')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (11,'Other Fax')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (12,'Call Back')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (13,'Car Phone')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (14,'ISDN')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (15,'Mobile Phone')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (16,'Primary Phone')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (17,'Radio Phone')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (18,'Telex')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (19,'TTY/TDD Phone')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (20,'Family Phone')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (21,'Vacation Home Phone')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (22,'School Phone')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_phone_cat 
(phone_category_id, phone_category_name) VALUES (23,'Answering Service')");

$this->oProc->query("INSERT INTO phpgw_cdb_contact_followup (followup_id, 
followup_name, followup_color) VALUES (1,'Follow Up', 'FF2222')"); //red
$this->oProc->query("INSERT INTO phpgw_cdb_contact_followup (followup_id, 
followup_name, followup_color) VALUES (2,'For Your Information', '6699cc')"); 
//blue
$this->oProc->query("INSERT INTO phpgw_cdb_contact_followup (followup_id, 
followup_name, followup_color) VALUES (3,'Review', '83d8a4')"); //green
$this->oProc->query("INSERT INTO phpgw_cdb_contact_followup (followup_id, 
followup_name, followup_color) VALUES (4,'Call', 'cccc99')"); //gold
$this->oProc->query("INSERT INTO phpgw_cdb_contact_followup (followup_id, 
followup_name, followup_color) VALUES (5,'Arrange Meeting', 'CC99CC')"); 
//purple
$this->oProc->query("INSERT INTO phpgw_cdb_contact_followup (followup_id, 
followup_name, followup_color) VALUES (6,'Send E-mail', 'FF9966')"); //orange
$this->oProc->query("INSERT INTO phpgw_cdb_contact_followup (followup_id, 
followup_name, followup_color) VALUES (7,'Send Letter', 'FFFF33')"); //yellow

$this->oProc->query("INSERT INTO phpgw_cdb_contact_addr_cat 
(address_category_id, address_category_name) VALUES (1,'Business Address')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_addr_cat 
(address_category_id, address_category_name) VALUES (2,'Home Address')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_addr_cat 
(address_category_id, address_category_name) VALUES (3,'Other Address')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_addr_cat 
(address_category_id, address_category_name) VALUES (4,'Family Address')");
$this->oProc->query("INSERT INTO phpgw_cdb_contact_addr_cat 
(address_category_id, address_category_name) VALUES (5,'Vacation Home 
Address')");