-- phpMyAdmin SQL Dump
-- version 3.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 13, 2011 at 03:58 AM
-- Server version: 5.1.30
-- PHP Version: 5.2.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `portal_abc`
--

-- --------------------------------------------------------

--
-- Table structure for table `collectionsite`
--

CREATE TABLE IF NOT EXISTS `collectionsite` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `sitename` varchar(255) NOT NULL,
  `sitecity` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `address2` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `time` text NOT NULL,
  `website` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `fax` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `collectionsite`
--


-- --------------------------------------------------------

--
-- Table structure for table `cprivatetest`
--

CREATE TABLE IF NOT EXISTS `cprivatetest` (
  `cpt_id` int(11) NOT NULL AUTO_INCREMENT,
  `pdfname` text NOT NULL,
  `pt_id` int(11) NOT NULL,
  PRIMARY KEY (`cpt_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cprivatetest`
--


-- --------------------------------------------------------

--
-- Table structure for table `devicetest`
--

CREATE TABLE IF NOT EXISTS `devicetest` (
  `dt_id` int(11) NOT NULL AUTO_INCREMENT,
  `td_id` int(11) NOT NULL,
  `test_name` varchar(255) NOT NULL,
  `test_shortname` varchar(255) NOT NULL,
  `orderby` int(11) NOT NULL,
  PRIMARY KEY (`dt_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `devicetest`
--


-- --------------------------------------------------------

--
-- Table structure for table `donoridentifiedby`
--

CREATE TABLE IF NOT EXISTS `donoridentifiedby` (
  `dib_id` int(11) NOT NULL AUTO_INCREMENT,
  `dib_name` text NOT NULL,
  `orderby` int(11) NOT NULL,
  `disable` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`dib_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `donoridentifiedby`
--

INSERT INTO `donoridentifiedby` (`dib_id`, `dib_name`, `orderby`, `disable`) VALUES
(1, 'Photo ID', 1, 0),
(2, 'Other', 2, 0);

-- --------------------------------------------------------

--
-- Table structure for table `drugtest`
--

CREATE TABLE IF NOT EXISTS `drugtest` (
  `dtest_id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `dob` varchar(255) NOT NULL,
  `ssn` varchar(255) NOT NULL,
  `donor_idenf` varchar(10) NOT NULL,
  `e_id` int(11) NOT NULL,
  `reason` varchar(255) NOT NULL,
  `collectiondate` varchar(255) NOT NULL,
  `collectiontime` varchar(255) NOT NULL,
  `collector` varchar(255) NOT NULL,
  `temperature` varchar(255) NOT NULL,
  `td_id` int(11) NOT NULL,
  `lot_no` varchar(255) NOT NULL,
  `expirationdate` varchar(255) NOT NULL,
  `result` varchar(255) NOT NULL,
  `remark` text NOT NULL,
  `csite` int(11) NOT NULL,
  `observed` varchar(10) NOT NULL,
  `testdate` varchar(255) NOT NULL,
  `test_name` text NOT NULL,
  `test_result` text NOT NULL,
  `phone` varchar(255) NOT NULL,
  `emailstatus` int(11) NOT NULL DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `isshow` tinyint(11) NOT NULL DEFAULT '0',
  `fax` varchar(255) NOT NULL,
  `faxstatus` tinyint(4) NOT NULL DEFAULT '0',
  `faxtransid` varchar(255) NOT NULL,
  `cperson` varchar(255) NOT NULL,
  `reciept_no` varchar(255) NOT NULL,
  PRIMARY KEY (`dtest_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `drugtest`
--


-- --------------------------------------------------------

--
-- Table structure for table `drugtestresult`
--

CREATE TABLE IF NOT EXISTS `drugtestresult` (
  `dtr_id` int(11) NOT NULL AUTO_INCREMENT,
  `dtest_id` int(11) NOT NULL,
  `td_id` int(11) NOT NULL,
  `test_name` text NOT NULL,
  `test_result` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`dtr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `drugtestresult`
--


-- --------------------------------------------------------

--
-- Table structure for table `drugtestr_docs`
--

CREATE TABLE IF NOT EXISTS `drugtestr_docs` (
  `docid` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) NOT NULL,
  `uploaded` varchar(255) NOT NULL,
  `test_id` int(11) NOT NULL,
  PRIMARY KEY (`docid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `drugtestr_docs`
--


-- --------------------------------------------------------

--
-- Table structure for table `employer`
--

CREATE TABLE IF NOT EXISTS `employer` (
  `e_id` int(11) NOT NULL AUTO_INCREMENT,
  `ename` varchar(255) NOT NULL,
  `estreet` varchar(255) NOT NULL,
  `ecity` varchar(255) NOT NULL,
  `estate` varchar(255) NOT NULL,
  `ecp_fname` varchar(255) NOT NULL,
  `ecp_lname` varchar(255) NOT NULL,
  `ephone` varchar(255) NOT NULL,
  `ecell` varchar(255) NOT NULL,
  `efax` varchar(255) NOT NULL,
  `eemail` varchar(255) NOT NULL,
  `efreqbill` varchar(255) NOT NULL,
  `epayvia` varchar(255) NOT NULL,
  `esendinvoicevia` varchar(255) NOT NULL,
  `eperftest` varchar(255) NOT NULL,
  `ehowtorecresults` varchar(255) NOT NULL,
  `epassword` varchar(255) NOT NULL,
  `esaleperson` varchar(255) NOT NULL,
  `enotes` text NOT NULL,
  `eadminnotes` text NOT NULL,
  `eperftest2` varchar(255) NOT NULL,
  `eperftest3` varchar(255) NOT NULL,
  `ezip` varchar(255) NOT NULL,
  PRIMARY KEY (`e_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `employer`
--


-- --------------------------------------------------------

--
-- Table structure for table `fields`
--

CREATE TABLE IF NOT EXISTS `fields` (
  `f_id` int(11) NOT NULL DEFAULT '0',
  `f_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `f_value` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`f_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fields`
--

INSERT INTO `fields` (`f_id`, `f_name`, `f_value`) VALUES
(0, 'patieninfo', '<p style="text-align: justify;">I understand and give my consent that test results reported by ANY LAB TEST NOW&reg; will be reported directly to me, in the manner I have chosen below. I understand that my test results will only be provided to other third parties upon my express consent. I further understand that it is my responsibility to consult my own medical doctor to interpretation, analysis, evaluation, and explanation of my test results. I understand that neither ANY LAB TEST NOW&reg; nor its ordering physician will analyze, evaluate, critique, review or otherwise interpret the results of said tests.</p>\r\n<p style="text-align: justify;">I agree that ANY LAB TEST NOW&reg;, its officers, shareholders, directors, employed physicians, or its other agent or employee shall not be liable for any claims including, but not limited to, any claim arising out of or related to, inaccurate, un-interpreted, misinterpreted or results not received and do hereby expressly forever release and discharge all claims, demands, injuries, damage, actions or causes of action.</p>\r\n<p style="text-align: justify;">I authorize ANY LAB TEST NOW to disclose my lab results, to the e-mail address I have indicated or/and an private online account. As stated in our Notice of Privacy Practice, I have the right to revoke or terminate this authorization by submitting a written request to the facility. This can be done in person or by mailing a request to the testing ANY LAB TEST NOW.</p>\r\n<p style="text-align: justify;">I understand that ANY LAB TEST NOW has no control over who may have access to the e-mail address or online account I have listed to receive my lab results. The information disclosed will no longer be protected by the requirements of the Privacy Rule and future disclosers not responsibility of ANY LAB TEST NOW.</p>');

-- --------------------------------------------------------

--
-- Table structure for table `freqbilling`
--

CREATE TABLE IF NOT EXISTS `freqbilling` (
  `fb_id` int(11) NOT NULL AUTO_INCREMENT,
  `fb_name` text NOT NULL,
  `orderby` int(11) NOT NULL,
  `disable` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`fb_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `freqbilling`
--

INSERT INTO `freqbilling` (`fb_id`, `fb_name`, `orderby`, `disable`) VALUES
(1, 'Monthly', 1, 0),
(2, 'Per Test', 2, 0);

-- --------------------------------------------------------

--
-- Table structure for table `lab`
--

CREATE TABLE IF NOT EXISTS `lab` (
  `lid` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `noofdays` int(11) NOT NULL,
  `orderby` int(11) NOT NULL,
  `disable` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`lid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `lab`
--

INSERT INTO `lab` (`lid`, `name`, `noofdays`, `orderby`, `disable`) VALUES
(1, 'Quest', 1, 1, 0),
(2, 'LabCorp', 1, 2, 0),
(3, 'Instant', 1, 3, 0),
(4, 'DNA', 1, 4, 0),
(5, 'Quest Tox', 1, 5, 0),
(6, 'ExperTox', 1, 6, 0),
(7, 'Alere', 1, 7, 0),
(8, 'Background', 1, 8, 0),
(9, 'Atherotech', 1, 9, 0),
(10, 'Other', 1, 10, 0);

-- --------------------------------------------------------

--
-- Table structure for table `lablocation`
--

CREATE TABLE IF NOT EXISTS `lablocation` (
  `ll_id` int(11) NOT NULL AUTO_INCREMENT,
  `ll_name` varchar(255) NOT NULL,
  `ll_address` varchar(255) NOT NULL,
  `ll_phone` varchar(255) NOT NULL,
  `ll_fax` varchar(255) NOT NULL,
  `ll_email` varchar(255) NOT NULL,
  `ll_website` varchar(255) NOT NULL,
  `ll_regarding` text NOT NULL,
  `ll_faxuname` varchar(255) NOT NULL,
  `ll_faxpass` varchar(255) NOT NULL,
  `ll_stationid` varchar(255) NOT NULL,
  `ll_regardingp` varchar(255) NOT NULL,
  `ll_noofdays` int(11) NOT NULL,
  PRIMARY KEY (`ll_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `lablocation`
--

INSERT INTO `lablocation` (`ll_id`, `ll_name`, `ll_address`, `ll_phone`, `ll_fax`, `ll_email`, `ll_website`, `ll_regarding`, `ll_faxuname`, `ll_faxpass`, `ll_stationid`, `ll_regardingp`, `ll_noofdays`) VALUES
(1, 'Lab Name', 'address', 'Phone', 'Fax', 'Email', 'website', 'Drug test report of:', 'Fax API username', 'Fax API username', 'Station ID', 'Lab test report of:', 0);

-- --------------------------------------------------------

--
-- Table structure for table `laborderfields`
--

CREATE TABLE IF NOT EXISTS `laborderfields` (
  `lof_id` int(11) NOT NULL AUTO_INCREMENT,
  `lof_name` text NOT NULL,
  PRIMARY KEY (`lof_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `laborderfields`
--

INSERT INTO `laborderfields` (`lof_id`, `lof_name`) VALUES
(1, 'QB'),
(2, 'Paid'),
(3, 'Portal'),
(4, 'MA');

-- --------------------------------------------------------

--
-- Table structure for table `mailfileds`
--

CREATE TABLE IF NOT EXISTS `mailfileds` (
  `mf_id` int(11) NOT NULL AUTO_INCREMENT,
  `mfsubject` text NOT NULL,
  `mfbody` text NOT NULL,
  `mffrom` text NOT NULL,
  `welcome` varchar(255) NOT NULL,
  `footer` text NOT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mailfileds`
--

INSERT INTO `mailfileds` (`mf_id`, `mfsubject`, `mfbody`, `mffrom`, `welcome`, `footer`) VALUES
(1, 'Test Results', 'Email body', 'From', 'Dear', 'Kind Regards');

-- --------------------------------------------------------

--
-- Table structure for table `mailfiledse`
--

CREATE TABLE IF NOT EXISTS `mailfiledse` (
  `mfe_id` int(11) NOT NULL AUTO_INCREMENT,
  `mfesubject` text NOT NULL,
  `mfebody` text NOT NULL,
  `mfefrom` text NOT NULL,
  `ewelcome` varchar(255) NOT NULL,
  `efooter` text NOT NULL,
  PRIMARY KEY (`mfe_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mailfiledse`
--

INSERT INTO `mailfiledse` (`mfe_id`, `mfesubject`, `mfebody`, `mfefrom`, `ewelcome`, `efooter`) VALUES
(1, 'Test Results', 'Email body', 'From', 'Dear', 'Kind Regards');

-- --------------------------------------------------------

--
-- Table structure for table `mailfiledsp`
--

CREATE TABLE IF NOT EXISTS `mailfiledsp` (
  `mfp_id` int(11) NOT NULL AUTO_INCREMENT,
  `mfpsubject` text NOT NULL,
  `mfpbody` text NOT NULL,
  `mfpfrom` text NOT NULL,
  `pwelcome` varchar(255) NOT NULL,
  `pfooter` text NOT NULL,
  PRIMARY KEY (`mfp_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mailfiledsp`
--

INSERT INTO `mailfiledsp` (`mfp_id`, `mfpsubject`, `mfpbody`, `mfpfrom`, `pwelcome`, `pfooter`) VALUES
(1, 'Test Results', 'Email body', 'From', 'Dear', 'Kind Regards');

-- --------------------------------------------------------

--
-- Table structure for table `payvia`
--

CREATE TABLE IF NOT EXISTS `payvia` (
  `pv_id` int(11) NOT NULL AUTO_INCREMENT,
  `pv_name` text NOT NULL,
  `orderby` int(11) NOT NULL,
  `disable` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pv_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `payvia`
--

INSERT INTO `payvia` (`pv_id`, `pv_name`, `orderby`, `disable`) VALUES
(1, 'Invoice', 1, 0),
(2, 'Credit Card', 2, 0);

-- --------------------------------------------------------

--
-- Table structure for table `physician`
--

CREATE TABLE IF NOT EXISTS `physician` (
  `ph_id` int(11) NOT NULL AUTO_INCREMENT,
  `ph_practice_name` varchar(255) NOT NULL,
  `ph_street` varchar(255) NOT NULL,
  `ph_city` varchar(255) NOT NULL,
  `ph_state` varchar(255) NOT NULL,
  `ph_zip` varchar(255) NOT NULL,
  `ph_contact_fname` varchar(255) NOT NULL,
  `ph_contact_lname` varchar(255) NOT NULL,
  `ph_physician` varchar(255) NOT NULL,
  `ph_phone` varchar(255) NOT NULL,
  `ph_cell` varchar(255) NOT NULL,
  `ph_fax` varchar(255) NOT NULL,
  `ph_email` varchar(255) NOT NULL,
  `ph_howtorecieve` varchar(255) NOT NULL,
  `ph_salesperson` varchar(255) NOT NULL,
  `ph_notes` text NOT NULL,
  `ph_adminnotes` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `defaultitem` int(11) NOT NULL,
  PRIMARY KEY (`ph_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `physician`
--


-- --------------------------------------------------------

--
-- Table structure for table `privatetest`
--

CREATE TABLE IF NOT EXISTS `privatetest` (
  `pt_id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(255) NOT NULL,
  `fname` varchar(255) NOT NULL,
  `lname` varchar(255) NOT NULL,
  `dob` varchar(255) NOT NULL,
  `houseno` varchar(255) NOT NULL,
  `street` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `zip` varchar(255) NOT NULL,
  `lab` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `fax` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `insurance` varchar(255) NOT NULL,
  `physician` varchar(255) NOT NULL,
  `faxphysician` varchar(255) NOT NULL,
  `semail` int(1) NOT NULL DEFAULT '0',
  `susmail` int(1) NOT NULL DEFAULT '0',
  `sfax` int(1) NOT NULL DEFAULT '0',
  `sonline` int(1) NOT NULL DEFAULT '0',
  `sphysician` int(1) NOT NULL DEFAULT '0',
  `wayreported` varchar(255) NOT NULL,
  `notes` text NOT NULL,
  `phonephysician` varchar(255) NOT NULL,
  `spickup` int(1) NOT NULL,
  `scall` int(1) NOT NULL,
  `csemail` tinyint(1) NOT NULL DEFAULT '0',
  `csusmail` tinyint(1) NOT NULL DEFAULT '0',
  `csfax` tinyint(1) NOT NULL DEFAULT '0',
  `csphysician` tinyint(1) NOT NULL DEFAULT '0',
  `cspickup` tinyint(1) NOT NULL DEFAULT '0',
  `cscall` tinyint(1) NOT NULL DEFAULT '0',
  `csonline` tinyint(4) NOT NULL DEFAULT '0',
  `isshow` tinyint(4) NOT NULL DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `unixtimestamp` int(11) NOT NULL,
  `noofdays` int(11) NOT NULL,
  `color` varchar(50) NOT NULL,
  `doccolor` varchar(50) NOT NULL,
  `snotes` tinyint(4) NOT NULL,
  `noads` tinyint(4) NOT NULL,
  `std` tinyint(4) NOT NULL,
  `reciept_no` varchar(255) NOT NULL,
  `hideblank` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pt_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `privatetest`
--


-- --------------------------------------------------------

--
-- Table structure for table `reasonoftest`
--

CREATE TABLE IF NOT EXISTS `reasonoftest` (
  `rot_id` int(11) NOT NULL AUTO_INCREMENT,
  `rot_name` text NOT NULL,
  `orderby` int(11) NOT NULL,
  `disable` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rot_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `reasonoftest`
--

INSERT INTO `reasonoftest` (`rot_id`, `rot_name`, `orderby`, `disable`) VALUES
(1, 'Pre-Employment', 1, 0),
(2, 'Random', 2, 0),
(3, 'Post-Accident', 3, 0),
(4, 'Private', 4, 0),
(5, 'Requested by probation officer', 5, 0),
(6, 'Court', 6, 0),
(7, 'Other', 7, 0);

-- --------------------------------------------------------

--
-- Table structure for table `receiveresults`
--

CREATE TABLE IF NOT EXISTS `receiveresults` (
  `rr_id` int(11) NOT NULL AUTO_INCREMENT,
  `rr_name` text NOT NULL,
  `orderby` int(11) NOT NULL,
  `disable` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rr_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `receiveresults`
--

INSERT INTO `receiveresults` (`rr_id`, `rr_name`, `orderby`, `disable`) VALUES
(1, 'Email', 1, 0),
(2, 'Fax', 2, 0),
(3, 'Usmail', 3, 0);

-- --------------------------------------------------------

--
-- Table structure for table `registration`
--

CREATE TABLE IF NOT EXISTS `registration` (
  `reg_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `password` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `access` int(11) NOT NULL DEFAULT '11',
  `prt` tinyint(4) NOT NULL DEFAULT '0',
  `prta` tinyint(4) NOT NULL DEFAULT '0',
  `prte` tinyint(4) NOT NULL DEFAULT '0',
  `prtd` tinyint(4) NOT NULL DEFAULT '0',
  `drt` tinyint(4) NOT NULL DEFAULT '0',
  `drta` tinyint(4) NOT NULL DEFAULT '0',
  `drte` tinyint(4) NOT NULL DEFAULT '0',
  `drtd` tinyint(4) NOT NULL DEFAULT '0',
  `emp` tinyint(4) NOT NULL DEFAULT '0',
  `empa` tinyint(4) NOT NULL DEFAULT '0',
  `empe` tinyint(4) NOT NULL DEFAULT '0',
  `empd` tinyint(4) NOT NULL DEFAULT '0',
  `usr` tinyint(4) NOT NULL DEFAULT '0',
  `usra` tinyint(4) NOT NULL DEFAULT '0',
  `usre` tinyint(4) NOT NULL DEFAULT '0',
  `usrd` tinyint(4) NOT NULL DEFAULT '0',
  `phy` tinyint(4) NOT NULL DEFAULT '0',
  `phya` tinyint(4) NOT NULL DEFAULT '0',
  `phye` tinyint(4) NOT NULL DEFAULT '0',
  `phyd` tinyint(4) NOT NULL DEFAULT '0',
  `dev` tinyint(4) NOT NULL DEFAULT '0',
  `deva` tinyint(4) NOT NULL DEFAULT '0',
  `deve` tinyint(4) NOT NULL DEFAULT '0',
  `devd` tinyint(4) NOT NULL DEFAULT '0',
  `det` tinyint(4) NOT NULL DEFAULT '0',
  `deta` tinyint(4) NOT NULL DEFAULT '0',
  `dete` tinyint(4) NOT NULL DEFAULT '0',
  `detd` tinyint(4) NOT NULL DEFAULT '0',
  `adf` tinyint(4) NOT NULL DEFAULT '0',
  `adfa` tinyint(4) NOT NULL DEFAULT '0',
  `adfe` tinyint(4) NOT NULL DEFAULT '0',
  `adfd` tinyint(4) NOT NULL DEFAULT '0',
  `emf` tinyint(4) NOT NULL DEFAULT '0',
  `emfa` tinyint(4) NOT NULL DEFAULT '0',
  `emfe` tinyint(4) NOT NULL DEFAULT '0',
  `emfd` tinyint(4) NOT NULL DEFAULT '0',
  `cos` tinyint(4) NOT NULL DEFAULT '0',
  `cosa` tinyint(4) NOT NULL DEFAULT '0',
  `cose` tinyint(4) NOT NULL DEFAULT '0',
  `cosd` tinyint(4) NOT NULL DEFAULT '0',
  `adm` tinyint(4) NOT NULL DEFAULT '0',
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`reg_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `registration`
--

INSERT INTO `registration` (`reg_id`, `username`, `password`, `access`, `prt`, `prta`, `prte`, `prtd`, `drt`, `drta`, `drte`, `drtd`, `emp`, `empa`, `empe`, `empd`, `usr`, `usra`, `usre`, `usrd`, `phy`, `phya`, `phye`, `phyd`, `dev`, `deva`, `deve`, `devd`, `det`, `deta`, `dete`, `detd`, `adf`, `adfa`, `adfe`, `adfd`, `emf`, `emfa`, `emfe`, `emfd`, `cos`, `cosa`, `cose`, `cosd`, `adm`, `timestamp`) VALUES
(1, 'admin', 'admin', 11, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `salesperson`
--

CREATE TABLE IF NOT EXISTS `salesperson` (
  `sp_id` int(11) NOT NULL AUTO_INCREMENT,
  `sp_name` text NOT NULL,
  `orderby` int(11) NOT NULL,
  `signature` text NOT NULL,
  `disable` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `salesperson`
--


-- --------------------------------------------------------

--
-- Table structure for table `sendinvoice`
--

CREATE TABLE IF NOT EXISTS `sendinvoice` (
  `siv_id` int(11) NOT NULL AUTO_INCREMENT,
  `siv_name` text NOT NULL,
  `orderby` int(11) NOT NULL,
  `disable` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`siv_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `sendinvoice`
--

INSERT INTO `sendinvoice` (`siv_id`, `siv_name`, `orderby`, `disable`) VALUES
(1, 'Usmail', 1, 0),
(2, 'Email', 2, 0),
(3, 'Fax', 3, 0);

-- --------------------------------------------------------

--
-- Table structure for table `state`
--

CREATE TABLE IF NOT EXISTS `state` (
  `state_id` int(11) NOT NULL AUTO_INCREMENT,
  `statename` varchar(255) NOT NULL,
  `selected` int(11) NOT NULL,
  PRIMARY KEY (`state_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;

--
-- Dumping data for table `state`
--

INSERT INTO `state` (`state_id`, `statename`, `selected`) VALUES
(2, 'Alabama', 0),
(3, 'Alaska', 0),
(4, 'Arizona', 0),
(5, 'Arkansas', 0),
(6, 'California', 0),
(7, 'Colorado', 0),
(8, 'Connecticut', 0),
(9, 'Delaware', 0),
(10, 'District Of Columbia', 0),
(11, 'Florida', 1),
(12, 'Georgia', 0),
(13, 'Hawaii', 0),
(14, 'Idaho', 0),
(15, 'Illinois', 0),
(16, 'Indiana', 0),
(17, 'Iowa', 0),
(18, 'Kansas', 0),
(19, 'Kentucky', 0),
(20, 'Louisiana', 0),
(21, 'Maine', 0),
(22, 'Maryland', 0),
(23, 'Massachusetts', 0),
(24, 'Michigan', 0),
(25, 'Minnesota', 0),
(26, 'Mississippi', 0),
(27, 'Missouri', 0),
(28, 'Montana', 0),
(29, 'Nebraska', 0),
(30, 'Nevada', 0),
(31, 'New Hampshire', 0),
(32, 'New Jersey', 0),
(33, 'New Mexico', 0),
(34, 'New York', 0),
(35, 'North Carolina', 0),
(36, 'North Dakota', 0),
(37, 'Ohio', 0),
(38, 'Oklahoma', 0),
(39, 'Oregon', 0),
(40, 'Pennsylvania', 0),
(41, 'Rhode Island', 0),
(42, 'South Carolina', 0),
(43, 'South Dakota', 0),
(44, 'Tennessee', 0),
(45, 'Texas', 0),
(46, 'Utah', 0),
(47, 'Vermont', 0),
(48, 'Virginia', 0),
(49, 'Washington', 0),
(50, 'West Virginia', 0),
(51, 'Wisconsin', 0),
(52, 'Wyoming', 0);

-- --------------------------------------------------------

--
-- Table structure for table `testingdevice`
--

CREATE TABLE IF NOT EXISTS `testingdevice` (
  `td_id` int(11) NOT NULL AUTO_INCREMENT,
  `td_name` varchar(255) NOT NULL,
  `td_sample` varchar(255) NOT NULL,
  `td_expdate` varchar(255) NOT NULL,
  `td_lotno` varchar(255) NOT NULL,
  `td_description` text NOT NULL,
  PRIMARY KEY (`td_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `testingdevice`
--


-- --------------------------------------------------------

--
-- Table structure for table `testr_docs`
--

CREATE TABLE IF NOT EXISTS `testr_docs` (
  `docid` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) NOT NULL,
  `uploaded` varchar(255) NOT NULL,
  `test_id` int(11) NOT NULL,
  `csemail` tinyint(1) NOT NULL DEFAULT '0',
  `csusmail` tinyint(1) NOT NULL DEFAULT '0',
  `csfax` tinyint(1) NOT NULL DEFAULT '0',
  `csphysician` tinyint(1) NOT NULL DEFAULT '0',
  `cspickup` tinyint(1) NOT NULL DEFAULT '0',
  `cscall` tinyint(1) NOT NULL DEFAULT '0',
  `csonline` tinyint(1) NOT NULL DEFAULT '0',
  `lid` int(11) NOT NULL,
  `faxtransid` varchar(255) NOT NULL,
  `td_noofdays` int(11) NOT NULL,
  `color` varchar(50) NOT NULL,
  `originalfile` varchar(255) NOT NULL,
  `faxptransid` varchar(255) NOT NULL,
  PRIMARY KEY (`docid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `testr_docs`
--


-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(20) NOT NULL,
  `last_name` varchar(40) NOT NULL,
  `email` varchar(80) NOT NULL,
  `pass` char(40) NOT NULL,
  `dob` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `cell` varchar(255) NOT NULL,
  `fax` varchar(255) NOT NULL,
  `cardno` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `verificationcode` varchar(255) NOT NULL,
  `user_level` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `active` char(32) DEFAULT NULL,
  `upprofile` int(11) NOT NULL DEFAULT '0',
  `registration_date` datetime NOT NULL,
  `lastlogin` varchar(255) NOT NULL,
  `houseno` varchar(255) NOT NULL,
  `street` varchar(255) NOT NULL DEFAULT '',
  `zip` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `email` (`email`),
  KEY `login` (`email`,`pass`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `users`
--