|
|
|
@(قريبا)@ @( قريبا )@ @( قريبا )@ |
|
-- phpMyAdmin SQL Dump
-- version 2.6.0-rc1
-- http://www.phpmyadmin.net
--
-- المزود: localhost
-- أنشئ في: 18 يناير 2005 الساعة 05:35
-- إصدارة المزود: 4.0.20
-- PHP إصدارة: 4.3.8
--
-- قاعدة البيانات: `myschool`
--
-- --------------------------------------------------------
--
-- بنية الجدول `school_absence`
--
CREATE TABLE `school_absence` (
`absence_id` int(10) unsigned NOT NULL auto_increment,
`student_id` int(10) NOT NULL default '0',
`absence_insert_date` int(20) NOT NULL default '0',
PRIMARY KEY (`absence_id`)
) TYPE=MyISAM AUTO_INCREMENT=134 ;
--
-- إرجاع أو إستيراد بيانات الجدول `school_absence`
--
INSERT INTO `school_absence` VALUES (119, 8, 1104537600);
INSERT INTO `school_absence` VALUES (23, 8, 1104314400);
INSERT INTO `school_absence` VALUES (122, 3, 1104624000);
INSERT INTO `school_absence` VALUES (115, 6, 1104094800);
INSERT INTO `school_absence` VALUES (117, 1, 1104537600);
INSERT INTO `school_absence` VALUES (120, 6, 1104537600);
INSERT INTO `school_absence` VALUES (116, 6, 1104181200);
INSERT INTO `school_absence` VALUES (110, 3, 1102204800);
INSERT INTO `school_absence` VALUES (118, 3, 1104537600);
INSERT INTO `school_absence` VALUES (123, 9, 1104624000);
INSERT INTO `school_absence` VALUES (106, 6, 1103932800);
INSERT INTO `school_absence` VALUES (121, 9, 1104537600);
INSERT INTO `school_absence` VALUES (124, 10, 1104019200);
INSERT INTO `school_absence` VALUES (128, 3, 1105228800);
INSERT INTO `school_absence` VALUES (126, 6, 1104710400);
INSERT INTO `school_absence` VALUES (129, 6, 1105228800);
INSERT INTO `school_absence` VALUES (130, 8, 1105228800);
INSERT INTO `school_absence` VALUES (131, 3, 1105315200);
INSERT INTO `school_absence` VALUES (132, 6, 1105315200);
INSERT INTO `school_absence` VALUES (133, 9, 1105315200);
-- --------------------------------------------------------
--
-- بنية الجدول `school_book`
--
CREATE TABLE `school_book` (
`book_id` int(10) unsigned NOT NULL auto_increment,
`book_name` varchar(50) NOT NULL default '',
PRIMARY KEY (`book_id`)
) TYPE=MyISAM AUTO_INCREMENT=46 ;
--
-- إرجاع أو إستيراد بيانات الجدول `school_book`
--
INSERT INTO `school_book` VALUES (1, 'القراءة');
INSERT INTO `school_book` VALUES (2, 'الاملاء');
INSERT INTO `school_book` VALUES (3, 'القران الكريم');
INSERT INTO `school_book` VALUES (4, 'التجويد');
INSERT INTO `school_book` VALUES (5, 'التعبير');
INSERT INTO `school_book` VALUES (6, 'النحو');
INSERT INTO `school_book` VALUES (7, 'الادب');
INSERT INTO `school_book` VALUES (8, 'القواعد');
INSERT INTO `school_book` VALUES (9, 'الرياضيات');
INSERT INTO `school_book` VALUES (10, 'الفيزياء');
INSERT INTO `school_book` VALUES (11, 'الكيمياء');
INSERT INTO `school_book` VALUES (12, 'الفنيه');
INSERT INTO `school_book` VALUES (13, 'الرياضه');
INSERT INTO `school_book` VALUES (14, 'الحاسب الالي');
INSERT INTO `school_book` VALUES (15, 'التوحيد');
INSERT INTO `school_book` VALUES (16, 'الحديث الشريف');
INSERT INTO `school_book` VALUES (17, 'الفقه');
INSERT INTO `school_book` VALUES (18, 'البلاغة والنقد');
INSERT INTO `school_book` VALUES (19, 'التاريخ');
INSERT INTO `school_book` VALUES (20, 'الجغرافيا');
INSERT INTO `school_book` VALUES (21, 'علم النفس');
INSERT INTO `school_book` VALUES (22, 'علم الاجتماع');
INSERT INTO `school_book` VALUES (23, 'علم الارض');
INSERT INTO `school_book` VALUES (24, 'الاحياء');
INSERT INTO `school_book` VALUES (25, 'اللغه الانجليزيه');
INSERT INTO `school_book` VALUES (26, 'المكتبه والبحث');
INSERT INTO `school_book` VALUES (27, 'الخط');
INSERT INTO `school_book` VALUES (28, 'تفسير');
INSERT INTO `school_book` VALUES (31, 'العلوم');
-- --------------------------------------------------------
--
-- بنية الجدول `school_book_teacher`
--
CREATE TABLE `school_book_teacher` (
`book_teacher_id` int(10) unsigned NOT NULL auto_increment,
`book_id` int(10) NOT NULL default '0',
`teacher_id` int(10) NOT NULL default '0',
PRIMARY KEY (`book_teacher_id`)
) TYPE=MyISAM AUTO_INCREMENT=74 ;
--
-- إرجاع أو إستيراد بيانات الجدول `school_book_teacher`
--
INSERT INTO `school_book_teacher` VALUES (64, 31, 37);
INSERT INTO `school_book_teacher` VALUES (63, 28, 36);
INSERT INTO `school_book_teacher` VALUES (62, 27, 35);
INSERT INTO `school_book_teacher` VALUES (61, 26, 34);
INSERT INTO `school_book_teacher` VALUES (60, 25, 33);
INSERT INTO `school_book_teacher` VALUES (59, 24, 32);
INSERT INTO `school_book_teacher` VALUES (58, 23, 31);
INSERT INTO `school_book_teacher` VALUES (57, 22, 30);
INSERT INTO `school_book_teacher` VALUES (56, 21, 29);
INSERT INTO `school_book_teacher` VALUES (55, 20, 28);
INSERT INTO `school_book_teacher` VALUES (54, 19, 27);
INSERT INTO `school_book_teacher` VALUES (53, 18, 26);
INSERT INTO `school_book_teacher` VALUES (52, 17, 25);
INSERT INTO `school_book_teacher` VALUES (51, 16, 24);
INSERT INTO `school_book_teacher` VALUES (50, 15, 23);
INSERT INTO `school_book_teacher` VALUES (49, 14, 22);
INSERT INTO `school_book_teacher` VALUES (48, 13, 21);
INSERT INTO `school_book_teacher` VALUES (47, 12, 20);
INSERT INTO `school_book_teacher` VALUES (46, 11, 19);
INSERT INTO `school_book_teacher` VALUES (45, 10, 18);
INSERT INTO `school_book_teacher` VALUES (44, 9, 17);
INSERT INTO `school_book_teacher` VALUES (43, 8, 16);
INSERT INTO `school_book_teacher` VALUES (42, 7, 15);
INSERT INTO `school_book_teacher` VALUES (41, 6, 14);
INSERT INTO `school_book_teacher` VALUES (40, 5, 13);
INSERT INTO `school_book_teacher` VALUES (39, 4, 11);
INSERT INTO `school_book_teacher` VALUES (38, 3, 12);
INSERT INTO `school_book_teacher` VALUES (37, 2, 8);
INSERT INTO `school_book_teacher` VALUES (36, 1, 9);
INSERT INTO `school_book_teacher` VALUES (66, 2, 9);
-- --------------------------------------------------------
--
-- بنية الجدول `school_book_tiers`
--
CREATE TABLE `school_book_tiers` (
`book_tiers_id` int(10) unsigned NOT NULL auto_increment,
`book_id` int(10) NOT NULL default '0',
`tiers_id` int(10) NOT NULL default '0',
PRIMARY KEY (`book_tiers_id`)
) TYPE=MyISAM AUTO_INCREMENT=467 ;
--
-- إرجاع أو إستيراد بيانات الجدول `school_book_tiers`
--
INSERT INTO `school_book_tiers` VALUES (244, 3, 12);
INSERT INTO `school_book_tiers` VALUES (218, 1, 4);
INSERT INTO `school_book_tiers` VALUES (220, 1, 6);
INSERT INTO `school_book_tiers` VALUES (250, 5, 9);
INSERT INTO `school_book_tiers` VALUES (233, 3, 1);
INSERT INTO `school_book_tiers` VALUES (232, 2, 9);
INSERT INTO `school_book_tiers` VALUES (252, 5, 11);
INSERT INTO `school_book_tiers` VALUES (231, 2, 8);
INSERT INTO `school_book_tiers` VALUES (243, 3, 11);
INSERT INTO `school_book_tiers` VALUES (242, 3, 10);
INSERT INTO `school_book_tiers` VALUES (241, 3, 9);
INSERT INTO `school_book_tiers` VALUES (256, 6, 9);
INSERT INTO `school_book_tiers` VALUES (249, 5, 8);
INSERT INTO `school_book_tiers` VALUES (240, 3, 8);
INSERT INTO `school_book_tiers` VALUES (230, 2, 7);
INSERT INTO `school_book_tiers` VALUES (248, 5, 7);
INSERT INTO `school_book_tiers` VALUES (255, 6, 8);
INSERT INTO `school_book_tiers` VALUES (254, 6, 7);
INSERT INTO `school_book_tiers` VALUES (223, 1, 9);
INSERT INTO `school_book_tiers` VALUES (226, 2, 3);
INSERT INTO `school_book_tiers` VALUES (229, 2, 6);
INSERT INTO `school_book_tiers` VALUES (247, 4, 9);
INSERT INTO `school_book_tiers` VALUES (216, 1, 2);
INSERT INTO `school_book_tiers` VALUES (246, 4, 8);
INSERT INTO `school_book_tiers` VALUES (217, 1, 3);
INSERT INTO `school_book_tiers` VALUES (239, 3, 7);
INSERT INTO `school_book_tiers` VALUES (209, 28, 7);
INSERT INTO `school_book_tiers` VALUES (210, 28, 8);
INSERT INTO `school_book_tiers` VALUES (245, 4, 7);
INSERT INTO `school_book_tiers` VALUES (253, 5, 12);
INSERT INTO `school_book_tiers` VALUES (219, 1, 5);
INSERT INTO `school_book_tiers` VALUES (251, 5, 10);
INSERT INTO `school_book_tiers` VALUES (238, 3, 6);
INSERT INTO `school_book_tiers` VALUES (222, 1, 8);
INSERT INTO `school_book_tiers` VALUES (211, 28, 9);
INSERT INTO `school_book_tiers` VALUES (221, 1, 7);
INSERT INTO `school_book_tiers` VALUES (237, 3, 5);
INSERT INTO `school_book_tiers` VALUES (225, 2, 2);
INSERT INTO `school_book_tiers` VALUES (212, 31, 7);
INSERT INTO `school_book_tiers` VALUES (213, 31, 8);
INSERT INTO `school_book_tiers` VALUES (214, 31, 9);
INSERT INTO `school_book_tiers` VALUES (228, 2, 5);
INSERT INTO `school_book_tiers` VALUES (224, 2, 1);
INSERT INTO `school_book_tiers` VALUES (236, 3, 4);
INSERT INTO `school_book_tiers` VALUES (235, 3, 3);
INSERT INTO `school_book_tiers` VALUES (215, 1, 1);
INSERT INTO `school_book_tiers` VALUES (234, 3, 2);
INSERT INTO `school_book_tiers` VALUES (227, 2, 4);
INSERT INTO `school_book_tiers` VALUES (257, 6, 10);
INSERT INTO `school_book_tiers` VALUES (258, 6, 11);
INSERT INTO `school_book_tiers` VALUES (259, 6, 12);
INSERT INTO `school_book_tiers` VALUES (260, 7, 7);
INSERT INTO `school_book_tiers` VALUES (261, 7, 8);
INSERT INTO `school_book_tiers` VALUES (262, 7, 9);
INSERT INTO `school_book_tiers` VALUES (263, 7, 10);
INSERT INTO `school_book_tiers` VALUES (264, 7, 11);
INSERT INTO `school_book_tiers` VALUES (265, 7, 12);
INSERT INTO `school_book_tiers` VALUES (266, 8, 7);
INSERT INTO `school_book_tiers` VALUES (267, 8, 8);
INSERT INTO `school_book_tiers` VALUES (268, 8, 9);
INSERT INTO `school_book_tiers` VALUES (269, 8, 10);
INSERT INTO `school_book_tiers` VALUES (270, 8, 11);
INSERT INTO `school_book_tiers` VALUES (271, 8, 12);
INSERT INTO `school_book_tiers` VALUES (272, 9, 1);
INSERT INTO `school_book_tiers` VALUES (273, 9, 2);
INSERT INTO `school_book_tiers` VALUES (274, 9, 3);
INSERT IN |
الصفحة الرئيسية 
البوابة 
اليومية 
س .و .ج 
ابحـث 
التسجيل 
دخول 
