#
# Create a MySQL Look-up Contact Type Table.  2007-05  http://kimbriggs.com/
#
# Table can hold over 65,000 contact types
# Describes the different kinds of entries in a Contacts table
# Add and/or subtract lines in insert statement to match requirements
#


drop table if exists contact_type;


create table contact_type
(
contact_type_id   smallint       unsigned not null auto_increment comment 'PK: Unique contact type ID',
contact_type      varchar(32)    not null	comment 'Contact type (donor, volunteer, business, etc.)',
contact_type_abbr varchar(8)     comment 'Optional abbreviation for contact type',

primary key (contact_type_id)
);


insert into lu_contact_type
(contact_type_id, contact_type)
values
(NULL, 'OTHER'),
(NULL, 'donor'),
(NULL, 'sponsor'),
(NULL, 'volunteer'),
(NULL, 'attendee'),
(NULL, 'committee_member'),
(NULL, 'business'),
(NULL, 'professional'),
(NULL, 'press'),
(NULL, 'corporate'),
(NULL, 'foundation'),
(NULL, 'government'),
(NULL, 'subscriber'),
(NULL, 'employee'),
(NULL, 'partner'),
(NULL, 'board_member')
;