CREATE TABLE deptdir_dept (
  dept_id int(10) unsigned NOT NULL auto_increment,
  dept_name varchar(30) default NULL,
  dept_manager varchar(30) default NULL,
  dept_shortdesc varchar(30) default NULL,
  dept_desctop text,
  dept_descleft text,
  dept_desctoptitle varchar(30) default NULL,
  dept_desclefttitle varchar(30) default NULL,
  dept_imageurl varchar(250) default NULL,
  dept_imagetext varchar(100) default NULL,
  dept_phone varchar(20) default NULL,
  dept_email varchar(250) default NULL,
  dept_created int(10) unsigned default '0',
  dept_updated int(10) unsigned default '0',
  dept_order int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (dept_id)
) TYPE=MyISAM;
CREATE TABLE deptdir_person (
  person_id int(10) unsigned NOT NULL auto_increment,
  person_name varchar(50) default NULL,
  person_title varchar(30) default NULL,
  person_phone varchar(20) default NULL,
  person_email varchar(100) default NULL,
  person_imageurl varchar(250) default NULL,
  person_imagetext varchar(100) default NULL,
  person_details text,
  person_dept int(10) default '0',
  person_created int(10) unsigned default '0',
  person_updated int(10) unsigned default '0',
  person_order int(10) unsigned NOT NULL default '0',
  person_show int(10) unsigned NOT NULL default '0',
  person_showemail tinyint(3) unsigned NOT NULL default '0',
  person_showphone tinyint(3) unsigned NOT NULL default '0',
  person_showimage tinyint(3) unsigned NOT NULL default '0',
  person_showdetails tinyint(3) unsigned NOT NULL default '0',  
  person_bigpic varchar(100) default NULL,
  PRIMARY KEY  (person_id)
) TYPE=MyISAM;