CREATE TABLE IF NOT EXISTS #__staff (

	`id` smallint(5) unsigned NOT NULL auto_increment,

  	`name` varchar(255) NOT NULL,
  			
  	`alias` varchar(255) NOT NULL,
  			
  	`dept_id` tinyint(4) unsigned NOT NULL default '0',
  			
  	`title` varchar(255) default NULL,
  			
  	`bio` text,
  			
  	`image_file_name` varchar(255) default NULL,
  			
  	`ordering` tinyint(4) unsigned NOT NULL default '0',
  			
  	`published` tinyint(1) NOT NULL default '1',
  			
  	`phone1` varchar(25) default NULL,
  			
  	`ext1` varchar(10) default NULL,
  			
  	`phone2` varchar(25) default NULL,
  		
  	`ext2` varchar(10) default NULL,
  			
  	`email` varchar(50) default NULL,
  			
  	`address1` varchar(100) default NULL,
  			
  	`address2` varchar(100) default NULL,
  			
  	`address3` varchar(100) default NULL,
  			
  	`address4` varchar(100) default NULL,
  			
  	PRIMARY KEY  (`id`),
  			
  	KEY `department` (`dept_id`),
  			
  	KEY `ordering` (`published`,`ordering`),
  			
  	KEY `staff_alias` (`alias`)

) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS #__staff_departments (

  `id` tinyint(4) unsigned NOT NULL auto_increment,
  			
  `name` varchar(255) NOT NULL,
  			
  `alias` varchar(255) NOT NULL,
  			
  `description` text,
  			
  `footer_text` text,
  		
  `ordering` tinyint(4) unsigned NOT NULL default '0',
  			
  `published` tinyint(1) unsigned NOT NULL default '1',
  
  PRIMARY KEY  (`id`),
  
  KEY `ordering` (`ordering`),
  
  KEY `name` (`name`),
  						
  KEY `dept_alias` (`alias`) 

  ) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS #__staff_settings (

  `id` tinyint(1) unsigned NOT NULL auto_increment,
  			
  `page_title` varchar(255) NOT NULL,
  			
  `staff_image_pos` varchar(10) NOT NULL default 'left',
  			
  `staff_image_pos_alt` tinyint(1) unsigned NOT NULL default '0',
  
  `view_all` varchar(25) NOT NULL default 'default',
  			
  `view_staff` varchar(25) NOT NULL default 'default',
  			
  `view_department` varchar(25) NOT NULL default 'default',
  			
  `view_list` varchar(25) NOT NULL default 'default',
  			
  `header_text` text,
  			
  `job_text1` text,
  			
  `job_text2` text,
  			
  `job_text3` text,
  			
  `staff_image_path` varchar(255) default NULL,
  			
  `staff_image_default` varchar(255) default NULL,
  		
  `staff_title_default` varchar(255) default NULL,
  			
  `staff_bio_default` text,
  			
  `show_dept_footer` tinyint(1) unsigned NOT NULL default '1',
  			
  `show_dept_footer_text1` tinyint(1) unsigned NOT NULL default '1',
  			
  `show_dept_footer_text2` tinyint(1) unsigned NOT NULL default '1',
  			
  `show_dept_footer_text3` tinyint(1) unsigned NOT NULL default '1',
  			
  `show_com_check` tinyint(1) unsigned NOT NULL default '1',
  			
  `show_todo` tinyint(1) unsigned NOT NULL default '1',

  `auto_alias` tinyint(1) unsigned NOT NULL default '1',
  
  `use_custom_colors` tinyint(1) unsigned NOT NULL default '0',
  			
  `custom_colors` text,
  			
  `list_use_image` tinyint(1) unsigned NOT NULL default '1',
  			
  `version` varchar(15) default NULL,
  			
  `last_checked` varchar(10) default NULL,
  			
  `check_version` tinyint(1) unsigned NOT NULL default '1',
  			
  `check_version_frequency` tinyint(4) unsigned NOT NULL default '1',
  			
  `view_admin_bio` smallint(5) unsigned NOT NULL default '250',
  			
  `cl_phone1` varchar(30) default NULL,
  			
  `cl_phone2` varchar(30) default NULL,
  			
  `cl_phone_ext` varchar(30) default NULL,
  			
  `cl_read_contact` varchar(30) default NULL,
  			
  `cl_email` varchar(30) default NULL,
  			
  `cl_address1` varchar(30) default NULL,
  			
  `cl_address2` varchar(30) default NULL,
  			
  `cl_address3` varchar(30) default NULL,
  			
  `cl_address4` varchar(30) default NULL,
  			
  `linkable_staff_name` tinyint(1) unsigned NOT NULL default '1',
  			
  `linkable_contact_details` tinyint(1) unsigned NOT NULL default '1',
  			
  `linkable_department` tinyint(1) unsigned NOT NULL default '1',
  			
  `th_staff_image` varchar(30) default NULL,

  `th_staff_name` varchar(30) default NULL,
  
  `th_staff_title` varchar(30) default NULL,
  
  `th_staff_bio` varchar(30) default NULL,
  
  `use_js_contact` tinyint(1) unsigned NOT NULL default '1',
  
  `use_js_corners` tinyint(1) unsigned NOT NULL default '1',
  
  `use_js_frontend` tinyint(1) unsigned NOT NULL default '1',
  
  `title_in_bio` tinyint(1) unsigned NOT NULL default '0',
  
  `acl` text COMMENT 'NOT IMPLEMENTED',
  
  `use_auto_readmore_bio` tinyint(1) unsigned NOT NULL default '1' COMMENT 'NOT IMPLEMENTED',
  
  `auto_readmore_length` varchar(5) NOT NULL COMMENT 'NOT IMPLEMENTED',
  
  PRIMARY KEY  (`id`),
  						
  KEY `auto_alias` (`auto_alias`)

) TYPE=MyISAM;