-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `network_theraphy_new`
--

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `uuid` binary(16) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` longtext,
  `authorized` tinyint(4) DEFAULT NULL,
  `info` longtext,
  `source` tinyint(4) DEFAULT NULL,
  `fname` varchar(255) DEFAULT NULL,
  `mname` varchar(255) DEFAULT NULL,
  `lname` varchar(255) DEFAULT NULL,
  `suffix` varchar(255) DEFAULT NULL,
  `federaltaxid` varchar(255) DEFAULT NULL,
  `federaldrugid` varchar(255) DEFAULT NULL,
  `upin` varchar(255) DEFAULT NULL,
  `facility` varchar(255) DEFAULT NULL,
  `facility_id` int(11) NOT NULL DEFAULT '0',
  `see_auth` int(11) NOT NULL DEFAULT '1',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `npi` varchar(15) DEFAULT NULL,
  `title` varchar(30) DEFAULT NULL,
  `specialty` varchar(255) DEFAULT NULL,
  `billname` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `email_direct` varchar(255) NOT NULL DEFAULT '',
  `url` varchar(255) DEFAULT NULL,
  `assistant` varchar(255) DEFAULT NULL,
  `organization` varchar(255) DEFAULT NULL,
  `valedictory` varchar(255) DEFAULT NULL,
  `street` varchar(60) DEFAULT NULL,
  `streetb` varchar(60) DEFAULT NULL,
  `city` varchar(30) DEFAULT NULL,
  `state` varchar(30) DEFAULT NULL,
  `zip` varchar(20) DEFAULT NULL,
  `street2` varchar(60) DEFAULT NULL,
  `streetb2` varchar(60) DEFAULT NULL,
  `city2` varchar(30) DEFAULT NULL,
  `state2` varchar(30) DEFAULT NULL,
  `zip2` varchar(20) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `fax` varchar(30) DEFAULT NULL,
  `phonew1` varchar(30) DEFAULT NULL,
  `phonew2` varchar(30) DEFAULT NULL,
  `phonecell` varchar(30) DEFAULT NULL,
  `notes` text,
  `cal_ui` tinyint(4) NOT NULL DEFAULT '1',
  `taxonomy` varchar(30) NOT NULL DEFAULT '207Q00000X',
  `calendar` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 = appears in calendar',
  `abook_type` varchar(31) NOT NULL DEFAULT '',
  `default_warehouse` varchar(31) NOT NULL DEFAULT '',
  `irnpool` varchar(31) NOT NULL DEFAULT '',
  `state_license_number` varchar(25) DEFAULT NULL,
  `weno_prov_id` varchar(15) DEFAULT NULL,
  `newcrop_user_role` varchar(30) DEFAULT NULL,
  `cpoe` tinyint(1) DEFAULT NULL,
  `physician_type` varchar(50) DEFAULT NULL,
  `main_menu_role` varchar(50) NOT NULL DEFAULT 'standard',
  `patient_menu_role` varchar(50) NOT NULL DEFAULT 'standard',
  `portal_user` tinyint(1) NOT NULL DEFAULT '0',
  `supervisor_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `users` (`id`, `uuid`, `username`, `password`, `authorized`, `info`, `source`, `fname`, `mname`, `lname`, `suffix`, `federaltaxid`, `federaldrugid`, `upin`, `facility`, `facility_id`, `see_auth`, `active`, `npi`, `title`, `specialty`, `billname`, `email`, `email_direct`, `url`, `assistant`, `organization`, `valedictory`, `street`, `streetb`, `city`, `state`, `zip`, `street2`, `streetb2`, `city2`, `state2`, `zip2`, `phone`, `fax`, `phonew1`, `phonew2`, `phonecell`, `notes`, `cal_ui`, `taxonomy`, `calendar`, `abook_type`, `default_warehouse`, `irnpool`, `state_license_number`, `weno_prov_id`, `newcrop_user_role`, `cpoe`, `physician_type`, `main_menu_role`, `patient_menu_role`, `portal_user`, `supervisor_id`) VALUES
(1, NULL, 'admin', 'NoLongerUsed', 1, NULL, NULL, 'admin', NULL, 'Administrator', NULL, NULL, NULL, NULL, 'NP Psychiatry Services', 3, 1, 1, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, '207Q00000X', 1, '', '', '', NULL, 'yes', '', NULL, NULL, 'standard', 'standard', 0, 0),
(2, NULL, 'phimail-service', 'NoLogin', 0, NULL, NULL, NULL, NULL, 'phiMail Gateway', NULL, NULL, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '207Q00000X', 0, '', '', '', NULL, NULL, NULL, NULL, NULL, 'standard', 'standard', 0, 0),
(3, NULL, 'portal-user', 'NoLogin', 0, NULL, NULL, NULL, NULL, 'Patient Portal User', NULL, NULL, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '207Q00000X', 0, '', '', '', NULL, NULL, NULL, NULL, NULL, 'standard', 'standard', 0, 0),
(4, NULL, 'provider', 'NoLongerUsed', 1, '', NULL, 'Ryan', '', 'Rifkin', NULL, '', '', '', 'NP Psychiatry Services', 3, 1, 0, '', NULL, '', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '207Q00000X', 1, '', '', '', '', '', '', NULL, '', 'standard', 'standard', 1, 0),
(5, NULL, 'reception', 'NoLongerUsed', 0, '', NULL, 'Sarah', '', 'Jessica', NULL, '', '', '', 'NP Psychiatry Services', 3, 1, 0, '', NULL, '', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '207Q00000X', 0, '', '', '', '', '', '', NULL, '', 'standard', 'standard', 0, 0),
(6, NULL, 'billing', 'NoLongerUsed', 0, '', NULL, 'Aubrey', '', 'Allen', NULL, '', '', '', 'NP Psychiatry Services', 3, 1, 0, '', NULL, '', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '207Q00000X', 0, '', '', '', '', '', '', NULL, '', 'standard', 'standard', 0, 0),
(7, NULL, 'office management', 'NoLongerUsed', 0, '', NULL, 'Siobhan', '', 'Ebert', NULL, '', '', '', 'NP Psychiatry Services', 3, 1, 0, '', NULL, '', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '207Q00000X', 0, '', '', '', '', '', '', NULL, '', 'standard', 'standard', 0, 0),
(8, NULL, 'Ryan Rifkin', 'NoLongerUsed', 1, '', NULL, 'Ryan', '', 'Rifkin', NULL, '', 'MR4476102', '', 'NP Psychiatry Services', 3, 1, 1, '1992157911', NULL, '', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '207Q00000X', 1, '', '', '', '', '', '', NULL, '', 'standard', 'standard', 0, 0),
(9, NULL, 'Sarah Jessica Katigbak', 'NoLongerUsed', 0, '', NULL, 'Sarah', '', 'Jessica Katigbak', NULL, '', '', '', 'NP Psychiatry Services', 3, 1, 1, '', NULL, '', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '207Q00000X', 0, '', '', '', '', '', '', NULL, '', 'standard', 'standard', 0, 0),
(10, NULL, 'Aubrey Allen', 'NoLongerUsed', 0, '', NULL, 'Aubrey', '', 'Allen', NULL, '', '', '', 'NP Psychiatry Services', 3, 1, 1, '', NULL, '', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '207Q00000X', 0, '', '', '', '', '', '', NULL, '', 'standard', 'standard', 0, 0),
(11, NULL, 'Siobhan Ebert', 'NoLongerUsed', 0, '', NULL, 'Siobhan', '', 'Ebert', NULL, '', '', '', 'NP Psychiatry Services', 3, 1, 1, '', NULL, '', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '207Q00000X', 0, '', '', '', '', '', '', NULL, '', 'standard', 'standard', 0, 0),
(12, NULL, 'judaline', 'NoLongerUsed', 1, '', NULL, 'judaline', '', 'judaline', NULL, '', '', '', 'NP Psychiatry Services', 3, 1, 1, '', NULL, '', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '207Q00000X', 1, '', '', '', '', '', '', NULL, '', 'standard', 'standard', 1, 0);
COMMIT;

