buda_users_contact_info_bak.sql

Create Table: CREATE TABLE `buda_users_contact_info_bak` (
  `object_id` int(11) NOT NULL DEFAULT '0',
  `alias` varchar(100) DEFAULT NULL,
  `street_address_1` varchar(100) DEFAULT NULL,
  `street_address_2` varchar(100) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `tel_work` varchar(50) DEFAULT NULL,
  `tel_home` varchar(50) DEFAULT NULL,
  `tel_cell` varchar(50) DEFAULT NULL,
  `tel_pager` varchar(50) DEFAULT NULL,
  `gender` char(1) DEFAULT NULL,
  `buda_id` varchar(20) DEFAULT NULL,
  `mail_status` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `edited_by` varchar(100) DEFAULT NULL,
  `edited_date` datetime DEFAULT NULL,
  `modification_id` varchar(50) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `additional_email` tinyint(4) DEFAULT '0',
  `yob` int(11) DEFAULT NULL,
  PRIMARY KEY (`object_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1