hi Robert,
you're right, my fault...
some typo corrections for the roles.
gj.
second version, the first one has some typo errors
gj.
On 2010-09-23 12:39.MD, Gjergj Sheldija wrote:
hi,
i'm attaching some sample user roles, hope it help.
it comprises those roles :
Nurse_Registration
Nurse_Midwife
Nurse_Surgery
Head_Nurse_Department
Pharmacy_Department
Obstetrics_Gynecology
Doctor_Surgery
Doctor_Department
Doctor_Lab
Doctor_Imaging
Pharmacy_Hospital
Tech_Hospital
Blood_Bank
Head_Department
Head_HR
Head_Surgery
Head_Nurse_Surgery
Head_Nurse_Surgery+Pharmacy
Head_Nurse_Department+Pharmacy
Nurse_General
Lab_Technicial_Department
Pharmacy_Imaging
Lab_Technician
Head_Nurse_Lab+Pharmacy
Information_Office
Billing
Sterilisation
Secretary
Archive
Med_Depot_Hospital
Head_Medical_Commission
Legal_Doctor
Supervisor
Medical_Consultant
Care2x_Technician
please remember that uses need to be attached to a department
to be able to access that department
gj.
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- --------------------------------------------------------
--
-- Table structure for table `care_user_roles`
--
CREATE TABLE IF NOT EXISTS `care_user_roles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`role_name` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT 'no_name',
`permission` text COLLATE latin1_general_ci,
`history` text COLLATE latin1_general_ci,
`modify_id` varchar(35) COLLATE latin1_general_ci NOT NULL,
`modify_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
`create_id` varchar(35) COLLATE latin1_general_ci NOT NULL,
`create_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
ROW_FORMAT=DYNAMIC COMMENT='InnoDB free: 7168 kB' AUTO_INCREMENT=104 ;
--
-- Dumping data for table `care_user_roles`
--
INSERT INTO `care_user_roles` (`id`, `role_name`, `permission`, `history`,
`modify_id`, `modify_time`, `create_id`, `create_time`) VALUES
(60, 'Nurse_Registration', '_a_1_admissionwrite _a_2_admissionread
_a_1_nursingstationallwrite _a_2_nursingstationallread
_a_1_nursingdutyplanwrite _a_2_nursingdutyplanread _a_2_opnursedutyplanread
_a_2_medocsread _a_2_doctorsdutyplanread _a_2_timestampallread
_a_2_dutyplanallread ', 'Created by admin on 2007-10-31 18:28:51', 'admin',
'2008-07-25 09:39:29', 'admin', '2007-10-31 18:28:28'),
(61, 'Nurse_Midwife', '_a_1_admissionwrite _a_2_admissionread
_a_1_nursingstationallwrite _a_2_nursingstationallread
_a_1_nursingdutyplanwrite _a_2_nursingdutyplanread _a_3_diagnosticsrequest
_a_2_labresultsread _a_1_opdoctorallwrite _a_2_opnurseallwrite
_a_3_opnurseallread _a_2_opnursedutyplanread _a_2_radioread _a_2_medocsread
_a_2_doctorsdutyplanread _a_2_photoread _a_2_timestampallread
_a_2_dutyplanallread ', 'Created by admin on 2007-10-31 18:29:59', 'admin',
'2008-07-26 09:23:14', 'admin', '2007-10-31 18:29:36'),
(62, 'Nurse_Surgery', '_a_2_admissionread _a_1_nursingstationallwrite
_a_2_nursingdutyplanread _a_3_diagnosticsrequest _a_2_labresultsread
_a_2_opnurseallwrite _a_3_opnurseallread _a_2_opnursedutyplanread
_a_2_radioread _a_2_medocsread _a_2_doctorsdutyplanread _a_2_timestampallread
_a_2_dutyplanallread ', 'Created by admin on 2007-10-31 18:31:11', 'admin',
'2008-07-24 18:50:03', 'admin', '2007-10-31 18:30:48'),
(64, 'Head_Nurse_Department', '_a_2_admissionread _a_1_nursingstationallwrite
_a_1_nursingdutyplanwrite _a_3_diagnosticsrequest _a_2_labresultsread
_a_2_radioread _a_1_medocswrite _a_2_medocsread _a_1_doctorsdutyplanwrite
_a_2_photoread _a_2_timestampallread _a_2_dutyplanallread ', 'Created by admin
on 2007-10-31 18:33:57', 'admin', '2008-07-24 18:53:24', 'admin', '2007-10-31
18:33:34'),
(66, 'Pharmacy_Department', '_a_1_nursingstationallwrite
_a_2_nursingstationallread _a_3_pharmaorder _a_4_pharmaread ', 'Created by
admin on 2007-10-31 18:36:54', 'admin', '2008-01-21 15:10:12', 'admin',
'2007-10-31 18:36:31'),
(67, 'Obstetrics_Gynecology', '_a_2_admissionread _a_1_nursingstationallwrite
_a_2_nursingdutyplanread _a_1_diagnosticsresultwrite
_a_2_diagnosticsreceptionwrite _a_1_labresultswrite _a_1_opdoctorallwrite
_a_2_opnursedutyplanread _a_1_radiowrite _a_2_radioread _a_1_medocswrite
_a_3_pharmaorder _a_4_pharmaread _a_2_doctorsdutyplanread _a_1_photowrite
_a_2_timestampallread _a_2_dutyplanallread ', 'Created by admin on 2007-10-31
18:47:36', 'admin', '2008-07-25 09:46:26', 'admin', '2007-10-31 18:47:13'),
(68, 'Doctor_Surgery', '_a_2_admissionread _a_1_nursingstationallwrite
_a_2_nursingdutyplanread _a_1_diagnosticsresultwrite
_a_2_diagnosticsreceptionwrite _a_2_labresultsread _a_1_opdoctorallwrite
_a_2_opnurseallwrite _a_3_opnurseallread _a_2_opnursedutyplanread
_a_1_radiowrite _a_1_medocswrite _a_3_pharmaorder _a_4_pharmaread
_a_2_doctorsdutyplanread _a_1_photowrite _a_2_photoread _a_2_timestampallread
_a_2_dutyplanallread ', 'Created by admin on 2007-10-31 18:49:04', 'admin',
'2008-07-25 09:45:46', 'admin', '2007-10-31 18:48:41'),
(69, 'Doctor_Department', '_a_2_admissionread _a_1_nursingstationallwrite
_a_2_nursingdutyplanread _a_1_diagnosticsresultwrite
_a_2_diagnosticsreceptionwrite _a_2_labresultsread _a_1_radiowrite
_a_1_medocswrite _a_3_pharmaorder _a_4_pharmaread _a_2_doctorsdutyplanread
_a_1_photowrite _a_2_timestampallread _a_2_dutyplanallread ', 'Created by admin
on 2007-10-31 18:50:00', 'admin', '2008-07-24 18:56:00', 'admin', '2007-10-31
18:49:37'),
(70, 'Doctor_Lab', '_a_2_admissionread _a_1_nursingdutyplanwrite
_a_1_diagnosticsresultwrite _a_2_diagnosticsreceptionwrite _a_1_laball
_a_1_labresultswrite _a_1_medocswrite _a_1_doctorsdutyplanwrite
_a_2_doctorsdutyplanread _a_1_photowrite _a_2_photoread _a_2_timestampallread
_a_2_dutyplanallread ', 'Created by admin on 2007-10-31 18:52:59', 'admin',
'2008-07-24 18:55:36', 'admin', '2007-10-31 18:52:36'),
(71, 'Doctor_Imaging', '_a_2_admissionread _a_1_diagnosticsresultwrite
_a_2_diagnosticsreceptionwrite _a_1_radiowrite _a_1_medocswrite
_a_2_doctorsdutyplanread _a_1_photowrite _a_2_timestampallread
_a_2_dutyplanallread ', 'Created by admin on 2007-10-31 18:54:48', 'admin',
'2008-07-24 18:55:23', 'admin', '2007-10-31 18:54:25'),
(72, 'Pharmacy_Hospital', '_a_1_pharmadbadmin _a_2_pharmareception
_a_3_pharmaorder _a_4_pharmaread _a_3_meddepotorder _a_1_techreception
_a_2_timestampallread _a_2_dutyplanallread ', 'Created by admin on 2007-10-31
18:55:48', 'admin', '2007-12-14 11:40:16', 'admin', '2007-10-31 18:55:25'),
(73, 'Tech_Hospital', '_a_1_techreception ', 'Created by admin on 2007-10-31
18:56:45', 'admin', '2007-11-25 13:14:35', 'admin', '2007-10-31 18:56:22'),
(74, 'Blood_Bank', '_a_1_admissionwrite _a_1_diagnosticsresultwrite
_a_1_labresultswrite _a_2_labresultsread _a_1_medocswrite _a_2_medocsread
_a_3_pharmaorder _a_2_doctorsdutyplanread _a_1_techreception
_a_2_timestampallread _a_2_dutyplanallread ', 'Created by admin on 2007-10-31
18:57:55', 'admin', '2007-11-25 12:39:09', 'admin', '2007-10-31 18:57:32'),
(75, 'Head_Department', '_a_2_admissionread _a_1_nursingstationallwrite
_a_1_nursingdutyplanwrite _a_1_diagnosticsresultwrite
_a_2_diagnosticsreceptionwrite _a_1_labresultswrite _a_1_radiowrite
_a_1_medocswrite _a_3_pharmaorder _a_1_doctorsdutyplanwrite _a_1_photowrite
_a_1_timestampallwrite _a_1_dutyplanallwrite ', 'Created by admin on
2007-10-31 18:59:23', 'admin', '2008-07-24 18:58:42', 'admin', '2007-10-31
18:59:00'),
(76, 'Head_HR', '_a_1_admissionwrite _a_1_timestampallwrite
_a_2_timestampallread _a_1_dutyplanallwrite _a_2_dutyplanallread ', 'Created by
admin on 2007-10-31 19:00:06', 'admin', '2008-04-10 10:27:08', 'admin',
'2007-10-31 18:59:43'),
(77, 'Head_Surgery', '_a_2_admissionread _a_1_nursingstationallwrite
_a_1_nursingdutyplanwrite _a_1_diagnosticsresultwrite _a_1_labresultswrite
_a_1_opdoctorallwrite _a_1_opnursedutyplanwrite _a_1_radiowrite _a_2_radioread
_a_1_medocswrite _a_3_pharmaorder _a_4_pharmaread _a_1_doctorsdutyplanwrite
_a_1_photowrite _a_1_timestampallwrite _a_1_dutyplanallwrite ', 'Created by
admin on 2007-11-01 14:19:44', 'admin', '2008-07-25 09:46:59', 'admin',
'2007-11-01 14:19:21'),
(78, 'Head_Nurse_Surgery', '_a_2_admissionread _a_1_nursingstationallwrite
_a_1_nursingdutyplanwrite _a_3_diagnosticsrequest _a_2_labresultsread
_a_2_opnurseallwrite _a_1_opnursedutyplanwrite _a_2_radioread _a_1_medocswrite
_a_1_doctorsdutyplanwrite _a_2_photoread _a_2_timestampallread
_a_2_dutyplanallread ', 'Created by admin on 2007-11-01 14:24:56', 'admin',
'2008-07-24 18:52:51', 'admin', '2007-11-01 14:24:33'),
(79, 'Head_Nurse_Surgery+Pharmacy', '_a_2_admissionread
_a_1_nursingstationallwrite _a_1_nursingdutyplanwrite _a_3_diagnosticsrequest
_a_2_labresultsread _a_2_opnurseallwrite _a_1_opnursedutyplanwrite
_a_2_radioread _a_1_medocswrite _a_3_pharmaorder _a_1_doctorsdutyplanwrite
_a_2_photoread _a_2_timestampallread _a_2_dutyplanallread ', 'Created by admin
on 2007-11-05 21:41:27', 'admin', '2008-07-24 18:53:05', 'admin', '2007-11-05
21:41:04'),
(80, 'Head_Nurse_Department+Pharmacy', '_a_2_admissionread
_a_1_nursingstationallwrite _a_1_nursingdutyplanwrite _a_3_diagnosticsrequest
_a_2_labresultsread _a_2_radioread _a_1_medocswrite _a_2_medocsread
_a_3_pharmaorder _a_4_pharmaread _a_1_doctorsdutyplanwrite
_a_2_doctorsdutyplanread _a_2_photoread _a_2_timestampallread
_a_2_dutyplanallread ', 'Created by admin on 2007-11-05 21:42:33', 'admin',
'2008-07-24 18:53:37', 'admin', '2007-11-05 21:42:10'),
(81, 'Nurse_General', '_a_2_admissionread _a_1_nursingstationallwrite
_a_2_nursingdutyplanread _a_3_diagnosticsrequest _a_2_labresultsread
_a_2_medocsread _a_2_doctorsdutyplanread _a_2_timestampallread
_a_2_dutyplanallread ', 'Created by admin on 2007-12-20 10:53:02', 'admin',
'2008-07-24 18:49:48', 'admin', '2007-12-20 10:52:39'),
(82, 'Lab_Technicial_Department', '_a_1_nursingstationallwrite
_a_2_nursingstationallread _a_1_nursingdutyplanwrite _a_2_nursingdutyplanread
_a_3_diagnosticsrequest _a_2_labresultsread _a_2_radioread _a_2_medocsread ',
'Created by admin on 2007-11-25 13:00:26', 'admin', '2008-02-14 11:45:23',
'admin', '2007-11-25 13:00:03'),
(83, 'Pharmacy_Imaging', '_a_1_admissionwrite _a_1_radiowrite _a_3_pharmaorder
_a_2_doctorsdutyplanread _a_1_photowrite _a_2_photoread _a_2_timestampallread
_a_2_dutyplanallread ', 'Created by admin on 2007-11-25 13:03:56', 'admin',
'2007-11-25 13:03:33', 'admin', '2007-11-25 13:03:33'),
(84, 'Lab_Technician', '_a_2_admissionread _a_2_nursingdutyplanread
_a_1_labresultswrite _a_1_medocswrite _a_2_doctorsdutyplanread
_a_1_techreception _a_2_timestampallread _a_2_dutyplanallread ', 'Created by
admin on 2007-11-25 13:05:59', 'admin', '2008-07-24 18:54:54', 'admin',
'2007-11-25 13:05:36'),
(85, 'Head_Nurse_Lab+Pharmacy', '_a_2_admissionread _a_2_nursingstationallread
_a_1_nursingdutyplanwrite _a_1_labresultswrite _a_1_medocswrite
_a_3_pharmaorder _a_1_doctorsdutyplanwrite _a_2_photoread _a_2_timestampallread
_a_2_dutyplanallread ', 'Created by admin on 2007-11-25 13:06:51', 'admin',
'2008-07-24 18:52:24', 'admin', '2007-11-25 13:06:28'),
(86, 'Information_Office', '_a_2_admissionread _a_2_nursingstationallread
_a_2_nursingdutyplanread _a_2_opnursedutyplanread _a_2_medocsread
_a_2_doctorsdutyplanread _a_2_timestampallread _a_2_dutyplanallread ', 'Created
by admin on 2007-11-25 13:16:00', 'admin', '2008-07-24 18:51:25', 'admin',
'2007-11-25 13:15:37'),
(87, 'Billing', '_a_1_admissionwrite _a_2_admissionread
_a_2_nursingstationallread _a_1_billallwrite ', 'Created by admin on
2007-11-25 13:21:18', 'admin', '2007-11-25 13:20:55', 'admin', '2007-11-25
13:20:55'),
(88, 'Sterilisation', '_a_3_pharmaorder _a_1_techreception ', 'Created by admin
on 2007-11-25 13:22:31', 'admin', '2007-11-25 13:22:34', 'admin', '2007-11-25
13:22:08'),
(89, 'Secretary', '_a_2_admissionread _a_2_nursingstationallread
_a_2_nursingdutyplanread _a_2_opnursedutyplanread _a_2_medocsread
_a_2_doctorsdutyplanread _a_2_photoread _a_2_timestampallread
_a_2_dutyplanallread _a_1_newsallwrite _a_2_newscafewrite
_a_2_newsallmoderatedwrite _a_1_teldirwrite ', 'Created by admin on
2007-11-25 13:23:56', 'admin', '2008-07-24 18:56:30', 'admin', '2007-11-25
13:23:33'),
(90, 'Archive', '_a_2_admissionread _a_2_nursingstationallread
_a_2_nursingdutyplanread _a_2_opnursedutyplanread _a_2_medocsread
_a_2_doctorsdutyplanread _a_2_timestampallread _a_2_dutyplanallread ', 'Created
by admin on 2007-11-25 13:24:42', 'admin', '2008-07-24 18:52:00', 'admin',
'2007-11-25 13:24:19'),
(91, 'Med_Depot_Hospital', '_a_1_meddepotdbadmin _a_2_meddepotreception
_a_3_meddepotorder _a_4_meddepotread ', 'Created by admin on 2007-11-25
13:25:45', 'admin', '2007-12-13 21:04:43', 'admin', '2007-11-25 13:25:22'),
(92, 'Head_Medical_Commission', '_a_2_admissionread _a_1_nursingstationallwrite
_a_2_nursingstationallread _a_1_nursingdutyplanwrite _a_2_nursingdutyplanread
_a_1_diagnosticsresultwrite _a_2_diagnosticsreceptionwrite
_a_3_diagnosticsrequest _a_1_laball _a_1_labresultswrite _a_2_labresultsread
_a_1_opdoctorallwrite _a_2_opnurseallwrite _a_3_opnurseallread
_a_1_opnursedutyplanwrite _a_2_opnursedutyplanread _a_1_radiowrite
_a_2_radioread _a_1_medocswrite _a_2_medocsread _a_3_pharmaorder
_a_4_pharmaread _a_1_doctorsdutyplanwrite _a_2_doctorsdutyplanread
_a_1_photowrite _a_2_photoread _a_1_timestampallwrite _a_2_timestampallread
_a_1_dutyplanallwrite _a_2_dutyplanallread ', 'Created by admin on 2008-01-15
18:19:17', 'admin', '2008-07-25 09:45:20', 'admin', '2008-01-15 18:18:54'),
(94, 'Legal_Doctor', '_a_2_admissionread _a_1_nursingstationallwrite
_a_2_nursingstationallread _a_1_nursingdutyplanwrite _a_2_nursingdutyplanread
_a_1_diagnosticsresultwrite _a_3_diagnosticsresultread
_a_2_diagnosticsreceptionwrite _a_3_diagnosticsrequest _a_1_labresultswrite
_a_2_labresultsread _a_1_opdoctorallwrite _a_2_opnurseallwrite
_a_3_opnurseallread _a_1_opnursedutyplanwrite _a_2_opnursedutyplanread
_a_1_radiowrite _a_2_radioread _a_1_medocswrite _a_2_medocsread
_a_1_doctorsdutyplanwrite _a_2_doctorsdutyplanread _a_1_teldirwrite ', 'Created
by admin on 2008-01-28 08:22:23', 'admin', '2008-07-24 18:55:10', 'admin',
'2008-01-28 08:22:00'),
(96, 'Supervisor', '_a_0_all ', 'Created by admin on 2008-02-10 11:26:43',
'admin', '2008-02-10 11:26:20', 'admin', '2008-02-10 11:26:20'),
(102, 'Medical_Consultant', '_a_0_all ', 'Created by admin on 2008-08-25
03:27:55', 'admin', '2008-08-25 03:27:32', 'admin', '2008-08-25 03:27:32'),
(103, 'Care2x_Technician', '_a_1_admissionwrite _a_2_admissionread
_a_1_nursingstationallwrite _a_2_nursingstationallread
_a_1_nursingdutyplanwrite _a_2_nursingdutyplanread _a_1_diagnosticsresultwrite
_a_3_diagnosticsresultread _a_2_diagnosticsreceptionwrite
_a_3_diagnosticsrequest _a_1_opdoctorallwrite _a_2_opnurseallwrite
_a_3_opnurseallread _a_1_opnursedutyplanwrite _a_2_opnursedutyplanread
_a_1_radiowrite _a_2_radioread _a_1_medocswrite _a_2_medocsread ', 'Created by
admin on 2008-08-25 03:34:15', 'admin', '2008-08-25 03:33:52', 'admin',
'2008-08-25 03:33:52');
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers
