<?php
/**************************************************************************
   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.

   @Authors:	Ryan Thompson(hide@address.com)
***************************************************************************/

$table_name = 'o_contacts';

$fields['address_id'] = array('type'=>'INT', 'size'=>'15', 'null'=>'NOT NULL', 'key'=>'PRIMARY KEY','extra'=>'AUTO_INCREMENT');
$fields['user_id'] = array('type'=>'INT', 'size'=>'6', 'key'=>'INDEX');
$fields['title'] = array('type'=>'ENUM', 'size'=>'\'\',\'Mr.\',\'Mrs.\',\'Ms.\',\'Miss\',\'Dr.\',\'Prof.\'');
$fields['firstname'] = array('type'=>'VARCHAR', 'size'=>'20');
$fields['lastname'] = array('type'=>'VARCHAR', 'size'=>'50');
$fields['middlename'] = array('type'=>'VARCHAR', 'size'=>'20');
$fields['suffix'] = array('type'=>'CHAR', 'size'=>'10');
$fields['birthday'] = array('type'=>'DATE');
$fields['job_title'] = array('type'=>'VARCHAR', 'size'=>'255');
$fields['address1'] = array('type'=>'VARCHAR', 'size'=>'255');
$fields['address2'] = array('type'=>'VARCHAR', 'size'=>'255');
$fields['city'] = array('type'=>'VARCHAR', 'size'=>'255');
$fields['province'] = array('type'=>'VARCHAR', 'size'=>'255');
$fields['country'] = array('type'=>'INT', 'size'=>'3');
$fields['postal_code'] = array('type'=>'CHAR', 'size'=>'10');
$fields['phone'] = array('type'=>'CHAR', 'size'=>'20');
$fields['cell'] = array('type'=>'CHAR', 'size'=>'20');
$fields['fax'] = array('type'=>'CHAR', 'size'=>'20');
$fields['email'] = array('type'=>'VARCHAR', 'size'=>'255');
$fields['company'] = array('type'=>'VARCHAR', 'size'=>'255');
$fields['department'] = array('type'=>'VARCHAR', 'size'=>'255');
$fields['website'] = array('type'=>'VARCHAR', 'size'=>'255');
$fields['notes'] = array('type'=>'TEXT');