CREATE TABLE `customers` (
  `customer_id` int(10) unsigned NOT NULL auto_increment,
  `fname` varchar(35) NOT NULL default '',
  `mname` varchar(35) default NULL,
  `lname` varchar(35) default NULL,
  `company` varchar(40) default NULL,
  `title` varchar(30) default NULL,
  `address1` varchar(60) NOT NULL default '',
  `address2` varchar(60) default NULL,
  `address3` varchar(60) default NULL,
  `city` varchar(50) NOT NULL default '',
  `state_province` varchar(50) default NULL,
  `country` varchar(50) NOT NULL default '',
  `postal_code` varchar(30) NOT NULL default '',
  `phone` varchar(25) default NULL,
  `fax` varchar(25) default NULL,
  PRIMARY KEY  (`customer_id`)
) TYPE=MyISAM

CREATE TABLE `tbl_users` (
  `iUserID` mediumint(8) unsigned NOT NULL auto_increment,
  `sFName` varchar(35) NOT NULL default '',
  `sMName` varchar(35) default NULL,
  `sLName` varchar(35) NOT NULL default '',
  `sAddr1` varchar(40) NOT NULL default '',
  `sAddr2` varchar(35) default NULL,
  `sCity` varchar(35) NOT NULL default '',
  `sState` varchar(35) NOT NULL default '',
  `sPCode` varchar(35) NOT NULL default '',
  `cCountryCode` char(2) NOT NULL default '',
  `sPhone` varchar(30) NOT NULL default '',
  `sEmail` varchar(80) NOT NULL default '',
  `sPassword` varchar(60) NOT NULL default '',
  `sQ1` varchar(60) default NULL,
  `sQ2` varchar(60) default NULL,
  `sQ3` varchar(60) default NULL,
  `sAccessPeriod` tinyint(4) NOT NULL default '0',
  `dtInserted` timestamp(14) NOT NULL,
  `dtUpdated` datetime default NULL,
  PRIMARY KEY  (`iUserID`),
  UNIQUE KEY `iUserID` (`iUserID`)
) TYPE=MyISAM