-- http://www.phpmyadmin.net
--




--
-- Database: `tateho5_homeassistant`
--

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

--
-- Table structure for table `userinfo`
--

CREATE TABLE IF NOT EXISTS `userinfo` (
  `UserID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `LastName` char(30) NOT NULL,
  `FirstName` char(20) NOT NULL,
  `MiddleName` char(20) NOT NULL,
  `NickName` char(20) NOT NULL,
  `AddressLine1` char(40) NOT NULL,
  `AddressLine2` char(40) NOT NULL,
  `City` char(25) NOT NULL,
  `State` char(2) NOT NULL,
  `ZipCode` char(5) NOT NULL,
  `PrimaryPhoneNumber` char(14) NOT NULL,
  `SecondaryPhoneNumber` char(14) NOT NULL,
  `UserEmail` char(30) NOT NULL,
  `CreationDateTime` datetime NOT NULL,
  `GroupID` int(10) unsigned NOT NULL,
  `UserType` int(10) unsigned NOT NULL,
  `UserName` char(15) NOT NULL,
  `UserPassword` char(15) NOT NULL,
  `AccountActive` tinyint(1) unsigned NOT NULL COMMENT 'Used to Enable or Disable User Accounts',
  `UserPrivilage` int(10) unsigned NOT NULL,
  `AutomaticLogIn` tinyint(1) unsigned NOT NULL COMMENT 'Flag Indicates if an autolog on as a user is allowed.',
  `AccountStartDate` date NOT NULL,
  `AccountExpiresDate` date NOT NULL,
  PRIMARY KEY (`UserID`),
  KEY `GroupID` (`GroupID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;

--
-- Dumping data for table `userinfo`
--

INSERT INTO `userinfo` (`UserID`, `LastName`, `FirstName`, `MiddleName`, `NickName`, `AddressLine1`, `AddressLine2`, `City`, `State`, `ZipCode`, `PrimaryPhoneNumber`, `SecondaryPhoneNumber`, `UserEmail`, `CreationDateTime`, `GroupID`, `UserType`, `UserName`, `UserPassword`, `AccountActive`, `UserPrivilage`, `AutomaticLogIn`, `AccountStartDate`, `AccountExpiresDate`) VALUES
(5, 'Gruodis', 'Ruth', '', 'Roo', '', '', '', '', '', '', '', '', '2013-10-09 00:00:00', 5, 100, 'U5', 'P5', 1, 1, 1, '0000-00-00', '0000-00-00'),
(8, 'DeShong', 'Jennifer', '', 'Jenny', '', '', '', '', '', '', '', '', '2013-10-09 00:00:00', 8, 100, 'U8', 'P8', 1, 1, 1, '0000-00-00', '0000-00-00'),
(11, 'DeShong', 'Bruce', '', 'Bruce', '', '', '', '', '', '', '', '', '2013-10-09 00:00:00', 28, 300, 'Admin', 'Admin', 1, 1, 1, '0000-00-00', '0000-00-00'),
(15, 'DeShong', 'Christian', '', 'CDog', '', '', '', '', '', '', '', '', '2013-10-09 00:00:00', 28, 400, 'SuperAdmin', 'SuperAdmin', 1, 1, 1, '0000-00-00', '0000-00-00'),
(17, 'DeShong', 'Denise', '', 'Denise', '', '', '', '', '', '', '', '', '2013-10-09 00:00:00', 28, 200, 'Monitor', 'Monitor', 1, 1, 1, '0000-00-00', '0000-00-00'),
(28, 'DeShong', 'John', 'Robert', 'Bob', '', '', '', '', '', '', '', '', '2013-10-09 00:00:00', 28, 100, 'User', 'User', 1, 1, 1, '0000-00-00', '0000-00-00'),
(29, 'Cochran', 'Clark', '', 'Clarkie', '', '', '', '', '', '', '', '', '2013-10-09 00:00:00', 28, 500, 'Provider', 'Provider', 1, 1, 0, '0000-00-00', '0000-00-00');

