-- sql queries For Group Permissions 
-- 1 -- app_label : Clinic Groups
--إدارة المستخدمين 

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1001 ,"Management","المجموعات","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1001,"view_group","عرض المجموعات ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1001,"add_users_to_group","  تعديل مستخدمين المجموعة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1001,"change_permissions","  تعديل الصلاحيات   ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1001,"add_group","إضافة المجموعات ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1001,"change_group","تعديل المجموعات ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1001,"delete_group","حذف المجموعات ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1002 , "Management","المستخدمين","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1002,"view_user","عرض المستخدمين ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1002,"add_user","إضافة المستخدمين ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1002,"change_user","تعديل المستخدمين ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1002,"reset_password","إعادة ضبط كلمة السر  ");

-- البيانات الرئيسية 
-- 2 -- app_label : Management
INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1003,"Management","العيادات","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1003,"view_clinics","عرض العيادات ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1003,"view_branchLocations","عرض مناطق التغطية ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1003,"add_branch","إضافة فرع جديد  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1003,"change_branch","تعديل بيانات فرع ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1003,"delete_branch"," حذف فرع حالي");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1004 ,"Management","التخصصات الطبية","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1004,"view_clinictypes"," عرض التخصصات الطبية");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1004,"view_complainttypes"," عرض شكوي المرضي");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1005 ,"Management"," الجنسيات","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1005,"view_nationalities","عرض الجنسيات ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1005,"add_nationality","إضافة ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1005,"change_nationality","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1005,"delete_nationality","حذف  ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1006 ,"Management"," المناطق","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1006,"view_locations","عرض المناطق ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1006,"add_location","إضافة منطقة ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1006,"change_location","تعديل منطقة ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1006,"delete_location","حذف منطقة ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1007 ,"Management"," طرق التعرف","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1007,"view_foundways","عرض طرق التعرف ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1007,"add_foundway","إضافة طريقة تعرف ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1007,"change_foundway","تعديل طريقة تعرف ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1007,"delete_foundway","حذف طريقة تعرف ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1008 ,"Management"," شكوي المرضي","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1008,"view_complaints","عرض   ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1008,"add_complaint","إضافة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1008,"change_complaint","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1008,"delete_complaint","حذف  ");

-- الوسائل الإعلامية
INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1009 ,"Management"," البرامج التليفزيونية","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1009,"view_tvPrograms","عرض");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1009,"add_tvPrograms","إضافة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1009,"change_tvPrograms","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1009,"delete_tvPrograms","حذف  ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1010 ,"Management","  قنوات التلفزيون","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1010,"view_tvChannels","عرض    ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1010,"add_tvChannels","إضافة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1010,"change_tvChannels","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1010,"delete_tvChannels","حذف  ");

-- المعاملات المالية
INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1011 ,"Management","فئات بنود المصروفات","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1011,"view_expenseCategories","عرض فئات بنود المصروفات ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1011,"add_expenseCategories","إضافة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1011,"change_expenseCategories","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1011,"delete_expenseCategories","حذف  ");


