school_main_18052013_1.sql

/*
SQLyog Enterprise - MySQL GUI v6.13
MySQL - 5.0.67 : Database - school
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `school`;

USE `school`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `left_menu` */

DROP TABLE IF EXISTS `left_menu`;

CREATE TABLE `left_menu` (
  `id` int(10) NOT NULL auto_increment,
  `left_menu_name` varchar(200) default NULL,
  `left_menu1_id` varchar(100) default NULL,
  `file_name` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Data for the table `left_menu` */

insert  into `left_menu`(`id`,`left_menu_name`,`left_menu1_id`,`file_name`) values (1,'Student Info',NULL,NULL),(2,'Exam Info',NULL,NULL),(3,'Student Fee Info',NULL,NULL),(4,'Course Info',NULL,NULL),(5,'Class Routine',NULL,NULL);

/*Table structure for table `main_menu` */

DROP TABLE IF EXISTS `main_menu`;

CREATE TABLE `main_menu` (
  `id` int(10) NOT NULL auto_increment,
  `main_name` varchar(100) default NULL,
  `flag` varchar(10) default NULL,
  `order_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;

/*Data for the table `main_menu` */

insert  into `main_menu`(`id`,`main_name`,`flag`,`order_id`) values (1,'Home','st',1),(2,'Administration',NULL,8),(3,'View','st',2),(5,'Accounting',NULL,6),(6,'Option','st',3),(8,'Student Fee',NULL,4),(9,'Teachers Info',NULL,7),(10,'Menu Permission',NULL,9),(11,'Fee','st',4),(12,'Exam & Result','st',5),(13,'Dashboard','ref_home',NULL),(14,'Home','tc',1),(15,'View','tc',5),(16,'Option','tc',10),(17,'Home','lib',1),(18,'View','lib',5),(19,'Setting','lib',10),(20,'Home',NULL,NULL),(21,'Home','ac',1),(22,'Make Fee','ac',5),(23,'Home',NULL,NULL),(24,'Administration',NULL,NULL),(25,'Home','ex',1),(26,'Option','ex',5),(27,'Home','ad',1),(28,'Accademic Setting','ad',5),(29,'Employment Setting','ad',10),(30,'SMS','ad',15),(31,'Notice Setting','ad',20),(32,'View','ad',25),(33,'Help','ad',30),(34,'Home','tr',1),(35,'View','tr',5),(36,'Setting','tr',10),(37,'Check Fee','ac',10),(38,'Make Voucher','ac',15),(39,'Collect Fee','ac',20),(40,'Amendment Fee','ac',25),(41,'View','ac',30),(42,'Result Processing','ex',10),(43,'Promotion','ex',15),(44,'Home','tt',NULL),(45,'View','tt',NULL),(46,'Time-Table','ad',9);

/*Table structure for table `std_attendence_info` */

DROP TABLE IF EXISTS `std_attendence_info`;

CREATE TABLE `std_attendence_info` (
  `id` int(10) NOT NULL auto_increment,
  `stu_id` int(10) default NULL,
  `class_id` int(10) default NULL,
  `section` varchar(5) default NULL,
  `total_attend` int(10) default NULL,
  `total_absent` int(10) default NULL,
  `total_open_day` int(10) default NULL,
  `month` date default NULL,
  `branch_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `std_attendence_info` */

insert  into `std_attendence_info`(`id`,`stu_id`,`class_id`,`section`,`total_attend`,`total_absent`,`total_open_day`,`month`,`branch_id`) values (1,2013111,1,'A',15,5,20,'2013-03-01',1),(2,11,2,'A',27,0,27,'2013-01-01',1);

/*Table structure for table `std_book_list` */

DROP TABLE IF EXISTS `std_book_list`;

CREATE TABLE `std_book_list` (
  `id` int(10) NOT NULL auto_increment,
  `class_id` int(10) default NULL,
  `book_title` varchar(200) default NULL,
  `book_author` varchar(200) default NULL,
  `isbn` varchar(100) default NULL,
  `branch_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `std_book_list` */

insert  into `std_book_list`(`id`,`class_id`,`book_title`,`book_author`,`isbn`,`branch_id`) values (1,1,'history','fgfgf','121',1);

/*Table structure for table `std_branch` */

DROP TABLE IF EXISTS `std_branch`;

CREATE TABLE `std_branch` (
  `id` int(10) NOT NULL auto_increment,
  `branch_name` varchar(100) default NULL,
  `address` varchar(150) default NULL,
  `phone` varchar(25) default NULL,
  `mobile` varchar(25) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Data for the table `std_branch` */

insert  into `std_branch`(`id`,`branch_name`,`address`,`phone`,`mobile`) values (1,'branch1','dhaka,banani','1212121','266313131'),(2,'branch2','dhaka,mirpur','5646464','6876464'),(3,'branch3',NULL,NULL,NULL),(4,'branch4',NULL,NULL,NULL),(5,'branch5',NULL,NULL,NULL),(6,'branch6',NULL,NULL,NULL),(7,'branch7',NULL,NULL,NULL);

/*Table structure for table `std_class_config` */

DROP TABLE IF EXISTS `std_class_config`;

CREATE TABLE `std_class_config` (
  `id` int(100) NOT NULL auto_increment,
  `class_name` varchar(200) default NULL,
  `no_of_student` varchar(100) default NULL,
  `remarks` varchar(200) default NULL,
  `total_CT` varchar(50) default NULL,
  `total_st` varchar(50) default NULL,
  `branch_id` int(10) default NULL,
  `daily_class` int(10) default NULL,
  `class_start_time` varchar(10) default NULL,
  `exam_fee` int(10) default '0',
  `developement_fee` int(10) default '0',
  `monthly_fee` int(10) default '0',
  `hostel_fee` int(10) default '0',
  `tution_fee` int(10) default '0',
  `leb_fee` int(10) default '0',
  `section_system` varchar(10) default NULL,
  `class_order` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

/*Data for the table `std_class_config` */

insert  into `std_class_config`(`id`,`class_name`,`no_of_student`,`remarks`,`total_CT`,`total_st`,`branch_id`,`daily_class`,`class_start_time`,`exam_fee`,`developement_fee`,`monthly_fee`,`hostel_fee`,`tution_fee`,`leb_fee`,`section_system`,`class_order`) values (1,'Class-1','200',NULL,NULL,NULL,1,4,'8:30',0,0,0,0,0,0,'E',1),(2,'Class-2','200',NULL,NULL,NULL,1,4,'8:30',0,0,0,0,0,0,'E',2),(3,'Class-3','200',NULL,NULL,NULL,1,8,'8:30',0,0,0,0,0,0,'E',3),(4,'Class-4','200',NULL,NULL,NULL,1,6,'8:30',0,0,0,0,0,0,'E',4),(5,'class-5','100',NULL,NULL,NULL,1,8,'8:30',0,0,0,0,0,0,'E',5),(6,'class-6','200',NULL,NULL,NULL,1,8,'8:30',0,0,0,0,0,0,'E',NULL),(7,'class-6','200',NULL,NULL,NULL,1,8,'8:30',0,0,0,0,0,0,'E',NULL),(9,'Class-7','100',NULL,NULL,NULL,1,8,'10:30',0,0,0,0,0,0,'E',NULL),(10,'8','200',NULL,NULL,NULL,1,8,'8:30',0,0,0,0,0,0,'E',NULL);

/*Table structure for table `std_class_exam` */

DROP TABLE IF EXISTS `std_class_exam`;

CREATE TABLE `std_class_exam` (
  `id` int(100) NOT NULL auto_increment,
  `class_id` int(100) default NULL,
  `class_name` varchar(100) default NULL,
  `class_sec` varchar(50) default NULL,
  `stu_id` varchar(50) default NULL,
  `stu_name` varchar(100) default NULL,
  `exam_id` int(100) default NULL,
  `exam_name` varchar(100) default NULL,
  `sub_id` int(100) default NULL,
  `subject` varchar(100) default NULL,
  `exam_date` varchar(100) default NULL,
  `exam_num` double default NULL,
  `year` varchar(100) default NULL,
  `period` int(10) default NULL,
  `branch_id` int(10) default NULL,
  `branch_name` varchar(50) default NULL,
  `group_id` int(10) default NULL,
  `group_name` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `std_class_exam` */

/*Table structure for table `std_class_exam_arc` */

DROP TABLE IF EXISTS `std_class_exam_arc`;

CREATE TABLE `std_class_exam_arc` (
  `id` int(100) NOT NULL auto_increment,
  `class_id` int(100) default NULL,
  `class_name` varchar(100) default NULL,
  `class_sec` varchar(50) default NULL,
  `stu_id` int(100) default NULL,
  `stu_name` varchar(100) default NULL,
  `exam_id` int(100) default NULL,
  `exam_name` varchar(100) default NULL,
  `sub_id` int(100) default NULL,
  `subject` varchar(100) default NULL,
  `exam_date` varchar(100) default NULL,
  `exam_num` double default NULL,
  `year` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `std_class_exam_arc` */

/*Table structure for table `std_class_exam_mark_setting` */

DROP TABLE IF EXISTS `std_class_exam_mark_setting`;

CREATE TABLE `std_class_exam_mark_setting` (
  `id` int(10) NOT NULL auto_increment,
  `class_id` int(10) default NULL,
  `class_sec` varchar(50) default NULL,
  `stu_id` varchar(50) default NULL,
  `sub_id` int(10) default NULL,
  `subjective_mark` decimal(10,2) default NULL,
  `objective_mark` decimal(10,2) default NULL,
  `ct_mark` decimal(10,2) default NULL,
  `total_mark` decimal(10,2) default NULL,
  `grade` varchar(5) default NULL,
  `point` decimal(10,2) default NULL,
  `year` varchar(10) default NULL,
  `period` int(10) default NULL,
  `branch_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Data for the table `std_class_exam_mark_setting` */

insert  into `std_class_exam_mark_setting`(`id`,`class_id`,`class_sec`,`stu_id`,`sub_id`,`subjective_mark`,`objective_mark`,`ct_mark`,`total_mark`,`grade`,`point`,`year`,`period`,`branch_id`) values (1,1,'A','2013111',101,'35.00','46.00','0.00','77.14','A','4.50','2013',3,1),(2,1,'A','2013111',103,'35.00','40.00','10.00','80.95','A+','5.00','2013',3,1),(3,1,'A','1',101,'40.00','12.00','45.00','92.38','A+','5.00','2013',1,1),(4,1,'A','2',101,'20.00','23.00','23.00','62.86','B','3.25','2013',1,1),(5,1,'A','123131',101,'10.00','2.00','1.00','12.38','F','0.00','2013',1,1),(6,1,'A','1212',101,'45.00','32.00','7.00','80.00','A+','5.00','2013',1,1),(7,1,'A','2013111',101,'45.00','25.00','9.00','75.24','A','4.50','2013',1,1);

/*Table structure for table `std_class_info` */

DROP TABLE IF EXISTS `std_class_info`;

CREATE TABLE `std_class_info` (
  `id` int(100) NOT NULL auto_increment,
  `class_id` int(100) default NULL,
  `class_name` varchar(100) default NULL,
  `class_sec` varchar(100) default NULL,
  `stu_id` varchar(50) default NULL,
  `stu_name` varchar(100) default NULL,
  `class_roll` int(100) default NULL,
  `total_open_day` int(50) default NULL,
  `total_atten` int(50) default NULL,
  `total_leave` int(20) default NULL,
  `total_abs` int(10) default NULL,
  `stuts` varchar(100) default NULL,
  `remarks` varchar(500) default NULL,
  `year` varchar(50) default NULL,
  `result` varchar(50) default NULL,
  `final_marks` varchar(50) default NULL,
  `branch_id` int(10) NOT NULL,
  `ovr_roll` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `std_class_info` */

insert  into `std_class_info`(`id`,`class_id`,`class_name`,`class_sec`,`stu_id`,`stu_name`,`class_roll`,`total_open_day`,`total_atten`,`total_leave`,`total_abs`,`stuts`,`remarks`,`year`,`result`,`final_marks`,`branch_id`,`ovr_roll`) values (2,1,'Class-1','B','2013122','Test',1,NULL,NULL,NULL,NULL,NULL,NULL,'2013',NULL,NULL,1,2);

/*Table structure for table `std_class_info_arc` */

DROP TABLE IF EXISTS `std_class_info_arc`;

CREATE TABLE `std_class_info_arc` (
  `id` int(100) NOT NULL auto_increment,
  `class_id` int(100) default NULL,
  `class_name` varchar(100) default NULL,
  `class_sec` varchar(100) default NULL,
  `stu_id` int(100) default NULL,
  `stu_name` varchar(100) default NULL,
  `class_roll` int(100) default NULL,
  `total_open_day` int(50) default NULL,
  `total_atten` int(50) default NULL,
  `total_leave` int(20) default NULL,
  `total_abs` int(10) default NULL,
  `stuts` varchar(100) default NULL,
  `remarks` varchar(500) default NULL,
  `year` varchar(50) default NULL,
  `result` varchar(50) default NULL,
  `final_marks` varchar(50) default NULL,
  `branch_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `std_class_info_arc` */

/*Table structure for table `std_class_period` */

DROP TABLE IF EXISTS `std_class_period`;

CREATE TABLE `std_class_period` (
  `period_id` int(11) NOT NULL auto_increment,
  `period` varchar(255) collate utf8_unicode_ci default NULL,
  `start_time` time default NULL,
  `end_time` time default NULL,
  `entry_date` date default NULL,
  `break_flag` int(11) NOT NULL default '0',
  `branch_id` varchar(255) collate utf8_unicode_ci default NULL,
  `flag` int(11) NOT NULL default '1',
  PRIMARY KEY  (`period_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `std_class_period` */

insert  into `std_class_period`(`period_id`,`period`,`start_time`,`end_time`,`entry_date`,`break_flag`,`branch_id`,`flag`) values (1,'1st','08:30:00','09:15:00','2013-03-11',0,'1',1),(2,'2nd','09:20:00','10:00:00','2013-03-12',0,'1',1),(3,'3rd','10:10:00','10:40:00','2013-03-12',0,'1',1),(4,'Tiffin','10:40:00','11:10:00','2013-03-12',1,'1',1),(5,'4th','11:10:00','11:40:00','2013-03-12',0,'1',1),(6,'5th','11:20:00','12:00:00','2013-03-12',0,'1',1),(7,'6th','12:10:00','12:40:00','2013-03-12',0,'1',1),(8,'7th','12:45:00','13:15:00','2013-03-12',0,'1',1),(9,'8th','13:25:00','14:00:00','2013-03-12',0,'1',1),(10,'9th','14:05:00','14:40:00','2013-03-12',0,'1',1),(11,'bangla','08:30:00','09:15:00','2013-05-06',0,'1',1);

/*Table structure for table `std_class_routine` */

DROP TABLE IF EXISTS `std_class_routine`;

CREATE TABLE `std_class_routine` (
  `id` int(4) NOT NULL auto_increment,
  `period` varchar(10) default NULL,
  `day_sat` varchar(50) default NULL,
  `day_sun` varchar(50) default NULL,
  `day_mon` varchar(50) default NULL,
  `day_tue` varchar(50) default NULL,
  `day_wed` varchar(50) default NULL,
  `day_thus` varchar(50) default NULL,
  `class_id` int(3) default NULL,
  `sec_id` int(3) default NULL,
  `class_time` varchar(20) default NULL,
  `Class_name` varchar(50) default NULL,
  `sec_name` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `std_class_routine` */

/*Table structure for table `std_class_routine_2` */

DROP TABLE IF EXISTS `std_class_routine_2`;

CREATE TABLE `std_class_routine_2` (
  `id` int(4) NOT NULL auto_increment,
  `period` varchar(10) default NULL,
  `day_sat` varchar(50) default NULL,
  `day_sun` varchar(50) default NULL,
  `day_mon` varchar(50) default NULL,
  `day_tue` varchar(50) default NULL,
  `day_wed` varchar(50) default NULL,
  `day_thus` varchar(50) default NULL,
  `class_id` int(3) default NULL,
  `sec_id` int(3) default NULL,
  `class_time` time default NULL,
  `Class_name` varchar(50) default NULL,
  `sec_name` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `std_class_routine_2` */

/*Table structure for table `std_class_routine_new` */

DROP TABLE IF EXISTS `std_class_routine_new`;

CREATE TABLE `std_class_routine_new` (
  `id` int(11) NOT NULL auto_increment,
  `day` int(11) NOT NULL,
  `period_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `teacher_id` int(11) default '0',
  `subject_id` int(11) default '0',
  `break_flag` int(11) NOT NULL default '0',
  `branch_id` varchar(100) collate utf8_unicode_ci NOT NULL,
  `active_flag` int(11) NOT NULL default '1',
  `entry_date` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=595 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `std_class_routine_new` */

insert  into `std_class_routine_new`(`id`,`day`,`period_id`,`class_id`,`section_id`,`teacher_id`,`subject_id`,`break_flag`,`branch_id`,`active_flag`,`entry_date`) values (1,1,1,1,1,2,1,0,'1',1,'2013-03-14'),(2,1,2,1,1,1,1,0,'1',1,'2013-03-14'),(3,1,3,1,1,1,3,0,'1',1,'2013-03-14'),(4,1,4,1,1,0,0,1,'1',1,'2013-03-14'),(5,1,5,1,1,2,1,0,'1',1,'2013-03-14'),(6,1,6,1,1,0,0,0,'1',1,'2013-03-14'),(7,1,7,1,1,0,0,0,'1',1,'2013-03-14'),(8,1,8,1,1,0,0,0,'1',1,'2013-03-14'),(9,1,9,1,1,0,0,0,'1',1,'2013-03-14'),(10,1,10,1,1,0,0,0,'1',1,'2013-03-14'),(11,1,1,1,2,1,3,0,'1',1,'2013-03-14'),(12,1,2,1,2,3,0,0,'1',1,'2013-03-14'),(13,1,3,1,2,0,0,0,'1',1,'2013-03-14'),(14,1,4,1,2,0,0,1,'1',1,'2013-03-14'),(15,1,5,1,2,1,1,0,'1',1,'2013-03-14'),(16,1,6,1,2,0,0,0,'1',1,'2013-03-14'),(17,1,7,1,2,0,0,0,'1',1,'2013-03-14'),(18,1,8,1,2,0,0,0,'1',1,'2013-03-14'),(19,1,9,1,2,0,0,0,'1',1,'2013-03-14'),(20,1,10,1,2,0,0,0,'1',1,'2013-03-14'),(21,1,1,2,3,0,0,0,'1',1,'2013-03-14'),(22,1,2,2,3,0,0,0,'1',1,'2013-03-14'),(23,1,3,2,3,0,0,0,'1',1,'2013-03-14'),(24,1,4,2,3,0,0,1,'1',1,'2013-03-14'),(25,1,5,2,3,0,0,0,'1',1,'2013-03-14'),(26,1,6,2,3,0,0,0,'1',1,'2013-03-14'),(27,1,7,2,3,0,0,0,'1',1,'2013-03-14'),(28,1,8,2,3,0,0,0,'1',1,'2013-03-14'),(29,1,9,2,3,0,0,0,'1',1,'2013-03-14'),(30,1,10,2,3,0,0,0,'1',1,'2013-03-14'),(31,1,1,2,4,0,0,0,'1',1,'2013-03-14'),(32,1,2,2,4,0,0,0,'1',1,'2013-03-14'),(33,1,3,2,4,0,0,0,'1',1,'2013-03-14'),(34,1,4,2,4,0,0,1,'1',1,'2013-03-14'),(35,1,5,2,4,0,0,0,'1',1,'2013-03-14'),(36,1,6,2,4,0,0,0,'1',1,'2013-03-14'),(37,1,7,2,4,0,0,0,'1',1,'2013-03-14'),(38,1,8,2,4,0,0,0,'1',1,'2013-03-14'),(39,1,9,2,4,0,0,0,'1',1,'2013-03-14'),(40,1,10,2,4,0,0,0,'1',1,'2013-03-14'),(41,1,1,3,5,0,0,0,'1',1,'2013-03-14'),(42,1,2,3,5,0,0,0,'1',1,'2013-03-14'),(43,1,3,3,5,0,0,0,'1',1,'2013-03-14'),(44,1,4,3,5,0,0,1,'1',1,'2013-03-14'),(45,1,5,3,5,0,0,0,'1',1,'2013-03-14'),(46,1,6,3,5,0,0,0,'1',1,'2013-03-14'),(47,1,7,3,5,0,0,0,'1',1,'2013-03-14'),(48,1,8,3,5,0,0,0,'1',1,'2013-03-14'),(49,1,9,3,5,0,0,0,'1',1,'2013-03-14'),(50,1,10,3,5,0,0,0,'1',1,'2013-03-14'),(51,2,1,1,1,0,0,0,'1',1,'2013-03-14'),(52,2,2,1,1,0,0,0,'1',1,'2013-03-14'),(53,2,3,1,1,0,0,0,'1',1,'2013-03-14'),(54,2,4,1,1,0,0,1,'1',1,'2013-03-14'),(55,2,5,1,1,0,0,0,'1',1,'2013-03-14'),(56,2,6,1,1,0,0,0,'1',1,'2013-03-14'),(57,2,7,1,1,0,0,0,'1',1,'2013-03-14'),(58,2,8,1,1,0,0,0,'1',1,'2013-03-14'),(59,2,9,1,1,0,0,0,'1',1,'2013-03-14'),(60,2,10,1,1,0,0,0,'1',1,'2013-03-14'),(61,2,1,1,2,0,0,0,'1',1,'2013-03-14'),(62,2,2,1,2,0,0,0,'1',1,'2013-03-14'),(63,2,3,1,2,0,0,0,'1',1,'2013-03-14'),(64,2,4,1,2,0,0,1,'1',1,'2013-03-14'),(65,2,5,1,2,0,0,0,'1',1,'2013-03-14'),(66,2,6,1,2,0,0,0,'1',1,'2013-03-14'),(67,2,7,1,2,0,0,0,'1',1,'2013-03-14'),(68,2,8,1,2,0,0,0,'1',1,'2013-03-14'),(69,2,9,1,2,0,0,0,'1',1,'2013-03-14'),(70,2,10,1,2,0,0,0,'1',1,'2013-03-14'),(71,2,1,2,3,0,0,0,'1',1,'2013-03-14'),(72,2,2,2,3,0,0,0,'1',1,'2013-03-14'),(73,2,3,2,3,0,0,0,'1',1,'2013-03-14'),(74,2,4,2,3,0,0,1,'1',1,'2013-03-14'),(75,2,5,2,3,0,0,0,'1',1,'2013-03-14'),(76,2,6,2,3,0,0,0,'1',1,'2013-03-14'),(77,2,7,2,3,0,0,0,'1',1,'2013-03-14'),(78,2,8,2,3,0,0,0,'1',1,'2013-03-14'),(79,2,9,2,3,0,0,0,'1',1,'2013-03-14'),(80,2,10,2,3,0,0,0,'1',1,'2013-03-14'),(81,2,1,2,4,0,0,0,'1',1,'2013-03-14'),(82,2,2,2,4,0,0,0,'1',1,'2013-03-14'),(83,2,3,2,4,0,0,0,'1',1,'2013-03-14'),(84,2,4,2,4,0,0,1,'1',1,'2013-03-14'),(85,2,5,2,4,0,0,0,'1',1,'2013-03-14'),(86,2,6,2,4,0,0,0,'1',1,'2013-03-14'),(87,2,7,2,4,0,0,0,'1',1,'2013-03-14'),(88,2,8,2,4,0,0,0,'1',1,'2013-03-14'),(89,2,9,2,4,0,0,0,'1',1,'2013-03-14'),(90,2,10,2,4,0,0,0,'1',1,'2013-03-14'),(91,2,1,3,5,0,0,0,'1',1,'2013-03-14'),(92,2,2,3,5,0,0,0,'1',1,'2013-03-14'),(93,2,3,3,5,0,0,0,'1',1,'2013-03-14'),(94,2,4,3,5,0,0,1,'1',1,'2013-03-14'),(95,2,5,3,5,0,0,0,'1',1,'2013-03-14'),(96,2,6,3,5,0,0,0,'1',1,'2013-03-14'),(97,2,7,3,5,0,0,0,'1',1,'2013-03-14'),(98,2,8,3,5,0,0,0,'1',1,'2013-03-14'),(99,2,9,3,5,0,0,0,'1',1,'2013-03-14'),(100,2,10,3,5,0,0,0,'1',1,'2013-03-14'),(101,3,1,1,1,0,0,0,'1',1,'2013-03-14'),(102,3,2,1,1,0,0,0,'1',1,'2013-03-14'),(103,3,3,1,1,0,0,0,'1',1,'2013-03-14'),(104,3,4,1,1,0,0,1,'1',1,'2013-03-14'),(105,3,5,1,1,0,0,0,'1',1,'2013-03-14'),(106,3,6,1,1,0,0,0,'1',1,'2013-03-14'),(107,3,7,1,1,0,0,0,'1',1,'2013-03-14'),(108,3,8,1,1,0,0,0,'1',1,'2013-03-14'),(109,3,9,1,1,0,0,0,'1',1,'2013-03-14'),(110,3,10,1,1,0,0,0,'1',1,'2013-03-14'),(111,3,1,1,2,0,0,0,'1',1,'2013-03-14'),(112,3,2,1,2,0,0,0,'1',1,'2013-03-14'),(113,3,3,1,2,0,0,0,'1',1,'2013-03-14'),(114,3,4,1,2,0,0,1,'1',1,'2013-03-14'),(115,3,5,1,2,0,0,0,'1',1,'2013-03-14'),(116,3,6,1,2,0,0,0,'1',1,'2013-03-14'),(117,3,7,1,2,0,0,0,'1',1,'2013-03-14'),(118,3,8,1,2,0,0,0,'1',1,'2013-03-14'),(119,3,9,1,2,0,0,0,'1',1,'2013-03-14'),(120,3,10,1,2,0,0,0,'1',1,'2013-03-14'),(121,3,1,2,3,0,0,0,'1',1,'2013-03-14'),(122,3,2,2,3,0,0,0,'1',1,'2013-03-14'),(123,3,3,2,3,0,0,0,'1',1,'2013-03-14'),(124,3,4,2,3,0,0,1,'1',1,'2013-03-14'),(125,3,5,2,3,0,0,0,'1',1,'2013-03-14'),(126,3,6,2,3,0,0,0,'1',1,'2013-03-14'),(127,3,7,2,3,0,0,0,'1',1,'2013-03-14'),(128,3,8,2,3,0,0,0,'1',1,'2013-03-14'),(129,3,9,2,3,0,0,0,'1',1,'2013-03-14'),(130,3,10,2,3,0,0,0,'1',1,'2013-03-14'),(131,3,1,2,4,0,0,0,'1',1,'2013-03-14'),(132,3,2,2,4,0,0,0,'1',1,'2013-03-14'),(133,3,3,2,4,0,0,0,'1',1,'2013-03-14'),(134,3,4,2,4,0,0,1,'1',1,'2013-03-14'),(135,3,5,2,4,0,0,0,'1',1,'2013-03-14'),(136,3,6,2,4,0,0,0,'1',1,'2013-03-14'),(137,3,7,2,4,0,0,0,'1',1,'2013-03-14'),(138,3,8,2,4,0,0,0,'1',1,'2013-03-14'),(139,3,9,2,4,0,0,0,'1',1,'2013-03-14'),(140,3,10,2,4,0,0,0,'1',1,'2013-03-14'),(141,3,1,3,5,0,0,0,'1',1,'2013-03-14'),(142,3,2,3,5,0,0,0,'1',1,'2013-03-14'),(143,3,3,3,5,0,0,0,'1',1,'2013-03-14'),(144,3,4,3,5,0,0,1,'1',1,'2013-03-14'),(145,3,5,3,5,0,0,0,'1',1,'2013-03-14'),(146,3,6,3,5,0,0,0,'1',1,'2013-03-14'),(147,3,7,3,5,0,0,0,'1',1,'2013-03-14'),(148,3,8,3,5,0,0,0,'1',1,'2013-03-14'),(149,3,9,3,5,0,0,0,'1',1,'2013-03-14'),(150,3,10,3,5,0,0,0,'1',1,'2013-03-14'),(151,4,1,1,1,0,0,0,'1',1,'2013-03-14'),(152,4,2,1,1,0,0,0,'1',1,'2013-03-14'),(153,4,3,1,1,0,0,0,'1',1,'2013-03-14'),(154,4,4,1,1,0,0,1,'1',1,'2013-03-14'),(155,4,5,1,1,0,0,0,'1',1,'2013-03-14'),(156,4,6,1,1,0,0,0,'1',1,'2013-03-14'),(157,4,7,1,1,0,0,0,'1',1,'2013-03-14'),(158,4,8,1,1,0,0,0,'1',1,'2013-03-14'),(159,4,9,1,1,0,0,0,'1',1,'2013-03-14'),(160,4,10,1,1,0,0,0,'1',1,'2013-03-14'),(161,4,1,1,2,0,0,0,'1',1,'2013-03-14'),(162,4,2,1,2,0,0,0,'1',1,'2013-03-14'),(163,4,3,1,2,0,0,0,'1',1,'2013-03-14'),(164,4,4,1,2,0,0,1,'1',1,'2013-03-14'),(165,4,5,1,2,0,0,0,'1',1,'2013-03-14'),(166,4,6,1,2,0,0,0,'1',1,'2013-03-14'),(167,4,7,1,2,0,0,0,'1',1,'2013-03-14'),(168,4,8,1,2,0,0,0,'1',1,'2013-03-14'),(169,4,9,1,2,0,0,0,'1',1,'2013-03-14'),(170,4,10,1,2,0,0,0,'1',1,'2013-03-14'),(171,4,1,2,3,0,0,0,'1',1,'2013-03-14'),(172,4,2,2,3,0,0,0,'1',1,'2013-03-14'),(173,4,3,2,3,0,0,0,'1',1,'2013-03-14'),(174,4,4,2,3,0,0,1,'1',1,'2013-03-14'),(175,4,5,2,3,0,0,0,'1',1,'2013-03-14'),(176,4,6,2,3,0,0,0,'1',1,'2013-03-14'),(177,4,7,2,3,0,0,0,'1',1,'2013-03-14'),(178,4,8,2,3,0,0,0,'1',1,'2013-03-14'),(179,4,9,2,3,0,0,0,'1',1,'2013-03-14'),(180,4,10,2,3,0,0,0,'1',1,'2013-03-14'),(181,4,1,2,4,0,0,0,'1',1,'2013-03-14'),(182,4,2,2,4,0,0,0,'1',1,'2013-03-14'),(183,4,3,2,4,0,0,0,'1',1,'2013-03-14'),(184,4,4,2,4,0,0,1,'1',1,'2013-03-14'),(185,4,5,2,4,0,0,0,'1',1,'2013-03-14'),(186,4,6,2,4,0,0,0,'1',1,'2013-03-14'),(187,4,7,2,4,0,0,0,'1',1,'2013-03-14'),(188,4,8,2,4,0,0,0,'1',1,'2013-03-14'),(189,4,9,2,4,0,0,0,'1',1,'2013-03-14'),(190,4,10,2,4,0,0,0,'1',1,'2013-03-14'),(191,4,1,3,5,0,0,0,'1',1,'2013-03-14'),(192,4,2,3,5,0,0,0,'1',1,'2013-03-14'),(193,4,3,3,5,0,0,0,'1',1,'2013-03-14'),(194,4,4,3,5,0,0,1,'1',1,'2013-03-14'),(195,4,5,3,5,0,0,0,'1',1,'2013-03-14'),(196,4,6,3,5,0,0,0,'1',1,'2013-03-14'),(197,4,7,3,5,0,0,0,'1',1,'2013-03-14'),(198,4,8,3,5,0,0,0,'1',1,'2013-03-14'),(199,4,9,3,5,0,0,0,'1',1,'2013-03-14'),(200,4,10,3,5,0,0,0,'1',1,'2013-03-14'),(201,5,1,1,1,0,0,0,'1',1,'2013-03-14'),(202,5,2,1,1,0,0,0,'1',1,'2013-03-14'),(203,5,3,1,1,0,0,0,'1',1,'2013-03-14'),(204,5,4,1,1,0,0,1,'1',1,'2013-03-14'),(205,5,5,1,1,0,0,0,'1',1,'2013-03-14'),(206,5,6,1,1,0,0,0,'1',1,'2013-03-14'),(207,5,7,1,1,0,0,0,'1',1,'2013-03-14'),(208,5,8,1,1,0,0,0,'1',1,'2013-03-14'),(209,5,9,1,1,0,0,0,'1',1,'2013-03-14'),(210,5,10,1,1,0,0,0,'1',1,'2013-03-14'),(211,5,1,1,2,0,0,0,'1',1,'2013-03-14'),(212,5,2,1,2,0,0,0,'1',1,'2013-03-14'),(213,5,3,1,2,0,0,0,'1',1,'2013-03-14'),(214,5,4,1,2,0,0,1,'1',1,'2013-03-14'),(215,5,5,1,2,0,0,0,'1',1,'2013-03-14'),(216,5,6,1,2,0,0,0,'1',1,'2013-03-14'),(217,5,7,1,2,0,0,0,'1',1,'2013-03-14'),(218,5,8,1,2,0,0,0,'1',1,'2013-03-14'),(219,5,9,1,2,0,0,0,'1',1,'2013-03-14'),(220,5,10,1,2,0,0,0,'1',1,'2013-03-14'),(221,5,1,2,3,0,0,0,'1',1,'2013-03-14'),(222,5,2,2,3,0,0,0,'1',1,'2013-03-14'),(223,5,3,2,3,0,0,0,'1',1,'2013-03-14'),(224,5,4,2,3,0,0,1,'1',1,'2013-03-14'),(225,5,5,2,3,0,0,0,'1',1,'2013-03-14'),(226,5,6,2,3,0,0,0,'1',1,'2013-03-14'),(227,5,7,2,3,0,0,0,'1',1,'2013-03-14'),(228,5,8,2,3,0,0,0,'1',1,'2013-03-14'),(229,5,9,2,3,0,0,0,'1',1,'2013-03-14'),(230,5,10,2,3,0,0,0,'1',1,'2013-03-14'),(231,5,1,2,4,0,0,0,'1',1,'2013-03-14'),(232,5,2,2,4,0,0,0,'1',1,'2013-03-14'),(233,5,3,2,4,0,0,0,'1',1,'2013-03-14'),(234,5,4,2,4,0,0,1,'1',1,'2013-03-14'),(235,5,5,2,4,0,0,0,'1',1,'2013-03-14'),(236,5,6,2,4,0,0,0,'1',1,'2013-03-14'),(237,5,7,2,4,0,0,0,'1',1,'2013-03-14'),(238,5,8,2,4,0,0,0,'1',1,'2013-03-14'),(239,5,9,2,4,0,0,0,'1',1,'2013-03-14'),(240,5,10,2,4,0,0,0,'1',1,'2013-03-14'),(241,5,1,3,5,0,0,0,'1',1,'2013-03-14'),(242,5,2,3,5,0,0,0,'1',1,'2013-03-14'),(243,5,3,3,5,0,0,0,'1',1,'2013-03-14'),(244,5,4,3,5,0,0,1,'1',1,'2013-03-14'),(245,5,5,3,5,0,0,0,'1',1,'2013-03-14'),(246,5,6,3,5,0,0,0,'1',1,'2013-03-14'),(247,5,7,3,5,0,0,0,'1',1,'2013-03-14'),(248,5,8,3,5,0,0,0,'1',1,'2013-03-14'),(249,5,9,3,5,0,0,0,'1',1,'2013-03-14'),(250,5,10,3,5,0,0,0,'1',1,'2013-03-14'),(251,6,1,1,1,0,0,0,'1',1,'2013-03-14'),(252,6,2,1,1,0,0,0,'1',1,'2013-03-14'),(253,6,3,1,1,0,0,0,'1',1,'2013-03-14'),(254,6,4,1,1,0,0,1,'1',1,'2013-03-14'),(255,6,5,1,1,0,0,0,'1',1,'2013-03-14'),(256,6,6,1,1,0,0,0,'1',1,'2013-03-14'),(257,6,7,1,1,0,0,0,'1',1,'2013-03-14'),(258,6,8,1,1,0,0,0,'1',1,'2013-03-14'),(259,6,9,1,1,0,0,0,'1',1,'2013-03-14'),(260,6,10,1,1,0,0,0,'1',1,'2013-03-14'),(261,6,1,1,2,0,0,0,'1',1,'2013-03-14'),(262,6,2,1,2,0,0,0,'1',1,'2013-03-14'),(263,6,3,1,2,0,0,0,'1',1,'2013-03-14'),(264,6,4,1,2,0,0,1,'1',1,'2013-03-14'),(265,6,5,1,2,0,0,0,'1',1,'2013-03-14'),(266,6,6,1,2,0,0,0,'1',1,'2013-03-14'),(267,6,7,1,2,0,0,0,'1',1,'2013-03-14'),(268,6,8,1,2,0,0,0,'1',1,'2013-03-14'),(269,6,9,1,2,0,0,0,'1',1,'2013-03-14'),(270,6,10,1,2,0,0,0,'1',1,'2013-03-14'),(271,6,1,2,3,0,0,0,'1',1,'2013-03-14'),(272,6,2,2,3,0,0,0,'1',1,'2013-03-14'),(273,6,3,2,3,0,0,0,'1',1,'2013-03-14'),(274,6,4,2,3,0,0,1,'1',1,'2013-03-14'),(275,6,5,2,3,0,0,0,'1',1,'2013-03-14'),(276,6,6,2,3,0,0,0,'1',1,'2013-03-14'),(277,6,7,2,3,0,0,0,'1',1,'2013-03-14'),(278,6,8,2,3,0,0,0,'1',1,'2013-03-14'),(279,6,9,2,3,0,0,0,'1',1,'2013-03-14'),(280,6,10,2,3,0,0,0,'1',1,'2013-03-14'),(281,6,1,2,4,0,0,0,'1',1,'2013-03-14'),(282,6,2,2,4,0,0,0,'1',1,'2013-03-14'),(283,6,3,2,4,0,0,0,'1',1,'2013-03-14'),(284,6,4,2,4,0,0,1,'1',1,'2013-03-14'),(285,6,5,2,4,0,0,0,'1',1,'2013-03-14'),(286,6,6,2,4,0,0,0,'1',1,'2013-03-14'),(287,6,7,2,4,0,0,0,'1',1,'2013-03-14'),(288,6,8,2,4,1,4,0,'1',1,'2013-03-14'),(289,6,9,2,4,0,0,0,'1',1,'2013-03-14'),(290,6,10,2,4,0,0,0,'1',1,'2013-03-14'),(291,6,1,3,5,0,0,0,'1',1,'2013-03-14'),(292,6,2,3,5,0,0,0,'1',1,'2013-03-14'),(293,6,3,3,5,0,0,0,'1',1,'2013-03-14'),(294,6,4,3,5,0,0,1,'1',1,'2013-03-14'),(295,6,5,3,5,0,0,0,'1',1,'2013-03-14'),(296,6,6,3,5,0,0,0,'1',1,'2013-03-14'),(297,6,7,3,5,0,0,0,'1',1,'2013-03-14'),(298,6,8,3,5,0,0,0,'1',1,'2013-03-14'),(299,6,9,3,5,0,0,0,'1',1,'2013-03-14'),(300,6,10,3,5,0,0,0,'1',1,'2013-03-14'),(301,1,1,5,7,0,0,0,'1',1,'2013-03-17'),(302,1,2,5,7,0,0,0,'1',1,'2013-03-17'),(303,1,3,5,7,0,0,0,'1',1,'2013-03-17'),(304,1,4,5,7,0,0,1,'1',1,'2013-03-17'),(305,1,5,5,7,0,0,0,'1',1,'2013-03-17'),(306,1,6,5,7,0,0,0,'1',1,'2013-03-17'),(307,1,7,5,7,0,0,0,'1',1,'2013-03-17'),(308,1,8,5,7,0,0,0,'1',1,'2013-03-17'),(309,1,9,5,7,0,0,0,'1',1,'2013-03-17'),(310,1,10,5,7,0,0,0,'1',1,'2013-03-17'),(311,1,1,5,8,0,0,0,'1',1,'2013-03-17'),(312,1,2,5,8,2,11,0,'1',1,'2013-03-17'),(313,1,3,5,8,0,0,0,'1',1,'2013-03-17'),(314,1,4,5,8,0,0,1,'1',1,'2013-03-17'),(315,1,5,5,8,0,0,0,'1',1,'2013-03-17'),(316,1,6,5,8,0,0,0,'1',1,'2013-03-17'),(317,1,7,5,8,0,0,0,'1',1,'2013-03-17'),(318,1,8,5,8,0,0,0,'1',1,'2013-03-17'),(319,1,9,5,8,0,0,0,'1',1,'2013-03-17'),(320,1,10,5,8,0,0,0,'1',1,'2013-03-17'),(321,2,1,5,7,0,0,0,'1',1,'2013-03-17'),(322,2,2,5,7,0,0,0,'1',1,'2013-03-17'),(323,2,3,5,7,0,0,0,'1',1,'2013-03-17'),(324,2,4,5,7,0,0,1,'1',1,'2013-03-17'),(325,2,5,5,7,0,0,0,'1',1,'2013-03-17'),(326,2,6,5,7,0,0,0,'1',1,'2013-03-17'),(327,2,7,5,7,0,0,0,'1',1,'2013-03-17'),(328,2,8,5,7,0,0,0,'1',1,'2013-03-17'),(329,2,9,5,7,0,0,0,'1',1,'2013-03-17'),(330,2,10,5,7,0,0,0,'1',1,'2013-03-17'),(331,2,1,5,8,0,0,0,'1',1,'2013-03-17'),(332,2,2,5,8,0,0,0,'1',1,'2013-03-17'),(333,2,3,5,8,0,0,0,'1',1,'2013-03-17'),(334,2,4,5,8,0,0,1,'1',1,'2013-03-17'),(335,2,5,5,8,0,0,0,'1',1,'2013-03-17'),(336,2,6,5,8,0,0,0,'1',1,'2013-03-17'),(337,2,7,5,8,0,0,0,'1',1,'2013-03-17'),(338,2,8,5,8,0,0,0,'1',1,'2013-03-17'),(339,2,9,5,8,0,0,0,'1',1,'2013-03-17'),(340,2,10,5,8,0,0,0,'1',1,'2013-03-17'),(341,3,1,5,7,0,0,0,'1',1,'2013-03-17'),(342,3,2,5,7,0,0,0,'1',1,'2013-03-17'),(343,3,3,5,7,0,0,0,'1',1,'2013-03-17'),(344,3,4,5,7,0,0,1,'1',1,'2013-03-17'),(345,3,5,5,7,0,0,0,'1',1,'2013-03-17'),(346,3,6,5,7,0,0,0,'1',1,'2013-03-17'),(347,3,7,5,7,0,0,0,'1',1,'2013-03-17'),(348,3,8,5,7,0,0,0,'1',1,'2013-03-17'),(349,3,9,5,7,0,0,0,'1',1,'2013-03-17'),(350,3,10,5,7,0,0,0,'1',1,'2013-03-17'),(351,3,1,5,8,0,0,0,'1',1,'2013-03-17'),(352,3,2,5,8,0,0,0,'1',1,'2013-03-17'),(353,3,3,5,8,0,0,0,'1',1,'2013-03-17'),(354,3,4,5,8,0,0,1,'1',1,'2013-03-17'),(355,3,5,5,8,0,0,0,'1',1,'2013-03-17'),(356,3,6,5,8,0,0,0,'1',1,'2013-03-17'),(357,3,7,5,8,0,0,0,'1',1,'2013-03-17'),(358,3,8,5,8,0,0,0,'1',1,'2013-03-17'),(359,3,9,5,8,0,0,0,'1',1,'2013-03-17'),(360,3,10,5,8,0,0,0,'1',1,'2013-03-17'),(361,4,1,5,7,0,0,0,'1',1,'2013-03-17'),(362,4,2,5,7,0,0,0,'1',1,'2013-03-17'),(363,4,3,5,7,0,0,0,'1',1,'2013-03-17'),(364,4,4,5,7,0,0,1,'1',1,'2013-03-17'),(365,4,5,5,7,0,0,0,'1',1,'2013-03-17'),(366,4,6,5,7,0,0,0,'1',1,'2013-03-17'),(367,4,7,5,7,0,0,0,'1',1,'2013-03-17'),(368,4,8,5,7,0,0,0,'1',1,'2013-03-17'),(369,4,9,5,7,0,0,0,'1',1,'2013-03-17'),(370,4,10,5,7,0,0,0,'1',1,'2013-03-17'),(371,4,1,5,8,0,0,0,'1',1,'2013-03-17'),(372,4,2,5,8,0,0,0,'1',1,'2013-03-17'),(373,4,3,5,8,0,0,0,'1',1,'2013-03-17'),(374,4,4,5,8,0,0,1,'1',1,'2013-03-17'),(375,4,5,5,8,0,0,0,'1',1,'2013-03-17'),(376,4,6,5,8,0,0,0,'1',1,'2013-03-17'),(377,4,7,5,8,0,0,0,'1',1,'2013-03-17'),(378,4,8,5,8,0,0,0,'1',1,'2013-03-17'),(379,4,9,5,8,0,0,0,'1',1,'2013-03-17'),(380,4,10,5,8,0,0,0,'1',1,'2013-03-17'),(381,5,1,5,7,0,0,0,'1',1,'2013-03-17'),(382,5,2,5,7,0,0,0,'1',1,'2013-03-17'),(383,5,3,5,7,0,0,0,'1',1,'2013-03-17'),(384,5,4,5,7,0,0,1,'1',1,'2013-03-17'),(385,5,5,5,7,0,0,0,'1',1,'2013-03-17'),(386,5,6,5,7,0,0,0,'1',1,'2013-03-17'),(387,5,7,5,7,0,0,0,'1',1,'2013-03-17'),(388,5,8,5,7,0,0,0,'1',1,'2013-03-17'),(389,5,9,5,7,0,0,0,'1',1,'2013-03-17'),(390,5,10,5,7,0,0,0,'1',1,'2013-03-17'),(391,5,1,5,8,0,0,0,'1',1,'2013-03-17'),(392,5,2,5,8,0,0,0,'1',1,'2013-03-17'),(393,5,3,5,8,0,0,0,'1',1,'2013-03-17'),(394,5,4,5,8,0,0,1,'1',1,'2013-03-17'),(395,5,5,5,8,0,0,0,'1',1,'2013-03-17'),(396,5,6,5,8,0,0,0,'1',1,'2013-03-17'),(397,5,7,5,8,0,0,0,'1',1,'2013-03-17'),(398,5,8,5,8,0,0,0,'1',1,'2013-03-17'),(399,5,9,5,8,0,0,0,'1',1,'2013-03-17'),(400,5,10,5,8,0,0,0,'1',1,'2013-03-17'),(401,6,1,5,7,0,0,0,'1',1,'2013-03-17'),(402,6,2,5,7,0,0,0,'1',1,'2013-03-17'),(403,6,3,5,7,0,0,0,'1',1,'2013-03-17'),(404,6,4,5,7,0,0,1,'1',1,'2013-03-17'),(405,6,5,5,7,0,0,0,'1',1,'2013-03-17'),(406,6,6,5,7,0,0,0,'1',1,'2013-03-17'),(407,6,7,5,7,0,0,0,'1',1,'2013-03-17'),(408,6,8,5,7,0,0,0,'1',1,'2013-03-17'),(409,6,9,5,7,0,0,0,'1',1,'2013-03-17'),(410,6,10,5,7,0,0,0,'1',1,'2013-03-17'),(411,6,1,5,8,0,0,0,'1',1,'2013-03-17'),(412,6,2,5,8,0,0,0,'1',1,'2013-03-17'),(413,6,3,5,8,0,0,0,'1',1,'2013-03-17'),(414,6,4,5,8,0,0,1,'1',1,'2013-03-17'),(415,6,5,5,8,0,0,0,'1',1,'2013-03-17'),(416,6,6,5,8,0,0,0,'1',1,'2013-03-17'),(417,6,7,5,8,0,0,0,'1',1,'2013-03-17'),(418,6,8,5,8,0,0,0,'1',1,'2013-03-17'),(419,6,9,5,8,0,0,0,'1',1,'2013-03-17'),(420,6,10,5,8,0,0,0,'1',1,'2013-03-17'),(421,1,1,4,9,0,0,0,'1',1,'2013-03-28'),(422,1,2,4,9,0,0,0,'1',1,'2013-03-28'),(423,1,3,4,9,0,0,0,'1',1,'2013-03-28'),(424,1,4,4,9,0,0,1,'1',1,'2013-03-28'),(425,1,5,4,9,0,0,0,'1',1,'2013-03-28'),(426,1,6,4,9,0,0,0,'1',1,'2013-03-28'),(427,1,7,4,9,0,0,0,'1',1,'2013-03-28'),(428,1,8,4,9,0,0,0,'1',1,'2013-03-28'),(429,1,9,4,9,0,0,0,'1',1,'2013-03-28'),(430,1,10,4,9,0,0,0,'1',1,'2013-03-28'),(431,2,1,4,9,0,0,0,'1',1,'2013-03-28'),(432,2,2,4,9,0,0,0,'1',1,'2013-03-28'),(433,2,3,4,9,0,0,0,'1',1,'2013-03-28'),(434,2,4,4,9,0,0,1,'1',1,'2013-03-28'),(435,2,5,4,9,0,0,0,'1',1,'2013-03-28'),(436,2,6,4,9,0,0,0,'1',1,'2013-03-28'),(437,2,7,4,9,0,0,0,'1',1,'2013-03-28'),(438,2,8,4,9,0,0,0,'1',1,'2013-03-28'),(439,2,9,4,9,0,0,0,'1',1,'2013-03-28'),(440,2,10,4,9,0,0,0,'1',1,'2013-03-28'),(441,3,1,4,9,0,0,0,'1',1,'2013-03-28'),(442,3,2,4,9,0,0,0,'1',1,'2013-03-28'),(443,3,3,4,9,0,0,0,'1',1,'2013-03-28'),(444,3,4,4,9,0,0,1,'1',1,'2013-03-28'),(445,3,5,4,9,0,0,0,'1',1,'2013-03-28'),(446,3,6,4,9,0,0,0,'1',1,'2013-03-28'),(447,3,7,4,9,0,0,0,'1',1,'2013-03-28'),(448,3,8,4,9,0,0,0,'1',1,'2013-03-28'),(449,3,9,4,9,0,0,0,'1',1,'2013-03-28'),(450,3,10,4,9,0,0,0,'1',1,'2013-03-28'),(451,4,1,4,9,0,0,0,'1',1,'2013-03-28'),(452,4,2,4,9,0,0,0,'1',1,'2013-03-28'),(453,4,3,4,9,0,0,0,'1',1,'2013-03-28'),(454,4,4,4,9,0,0,1,'1',1,'2013-03-28'),(455,4,5,4,9,0,0,0,'1',1,'2013-03-28'),(456,4,6,4,9,0,0,0,'1',1,'2013-03-28'),(457,4,7,4,9,0,0,0,'1',1,'2013-03-28'),(458,4,8,4,9,0,0,0,'1',1,'2013-03-28'),(459,4,9,4,9,0,0,0,'1',1,'2013-03-28'),(460,4,10,4,9,0,0,0,'1',1,'2013-03-28'),(461,5,1,4,9,0,0,0,'1',1,'2013-03-28'),(462,5,2,4,9,0,0,0,'1',1,'2013-03-28'),(463,5,3,4,9,0,0,0,'1',1,'2013-03-28'),(464,5,4,4,9,0,0,1,'1',1,'2013-03-28'),(465,5,5,4,9,0,0,0,'1',1,'2013-03-28'),(466,5,6,4,9,0,0,0,'1',1,'2013-03-28'),(467,5,7,4,9,0,0,0,'1',1,'2013-03-28'),(468,5,8,4,9,0,0,0,'1',1,'2013-03-28'),(469,5,9,4,9,0,0,0,'1',1,'2013-03-28'),(470,5,10,4,9,0,0,0,'1',1,'2013-03-28'),(471,6,1,4,9,0,0,0,'1',1,'2013-03-28'),(472,6,2,4,9,0,0,0,'1',1,'2013-03-28'),(473,6,3,4,9,0,0,0,'1',1,'2013-03-28'),(474,6,4,4,9,0,0,1,'1',1,'2013-03-28'),(475,6,5,4,9,0,0,0,'1',1,'2013-03-28'),(476,6,6,4,9,0,0,0,'1',1,'2013-03-28'),(477,6,7,4,9,0,0,0,'1',1,'2013-03-28'),(478,6,8,4,9,0,0,0,'1',1,'2013-03-28'),(479,6,9,4,9,0,0,0,'1',1,'2013-03-28'),(480,6,10,4,9,0,0,0,'1',1,'2013-03-28'),(481,1,11,1,2,0,0,0,'1',1,'2013-05-08'),(482,1,11,1,1,0,0,0,'1',1,'2013-05-08'),(483,1,11,2,4,0,0,0,'1',1,'2013-05-08'),(484,1,11,2,3,0,0,0,'1',1,'2013-05-08'),(485,1,11,3,5,0,0,0,'1',1,'2013-05-08'),(486,1,11,4,9,0,0,0,'1',1,'2013-05-08'),(487,1,11,5,7,0,0,0,'1',1,'2013-05-08'),(488,1,11,5,8,0,0,0,'1',1,'2013-05-08'),(489,2,11,1,2,0,0,0,'1',1,'2013-05-08'),(490,2,11,1,1,0,0,0,'1',1,'2013-05-08'),(491,2,11,2,4,0,0,0,'1',1,'2013-05-08'),(492,2,11,2,3,0,0,0,'1',1,'2013-05-08'),(493,2,11,3,5,0,0,0,'1',1,'2013-05-08'),(494,2,11,4,9,0,0,0,'1',1,'2013-05-08'),(495,2,11,5,7,0,0,0,'1',1,'2013-05-08'),(496,2,11,5,8,0,0,0,'1',1,'2013-05-08'),(497,3,11,1,2,0,0,0,'1',1,'2013-05-08'),(498,3,11,1,1,0,0,0,'1',1,'2013-05-08'),(499,3,11,2,4,0,0,0,'1',1,'2013-05-08'),(500,3,11,2,3,0,0,0,'1',1,'2013-05-08'),(501,3,11,3,5,0,0,0,'1',1,'2013-05-08'),(502,3,11,4,9,0,0,0,'1',1,'2013-05-08'),(503,3,11,5,7,0,0,0,'1',1,'2013-05-08'),(504,3,11,5,8,0,0,0,'1',1,'2013-05-08'),(505,4,11,1,2,0,0,0,'1',1,'2013-05-08'),(506,4,11,1,1,0,0,0,'1',1,'2013-05-08'),(507,4,11,2,4,0,0,0,'1',1,'2013-05-08'),(508,4,11,2,3,0,0,0,'1',1,'2013-05-08'),(509,4,11,3,5,0,0,0,'1',1,'2013-05-08'),(510,4,11,4,9,0,0,0,'1',1,'2013-05-08'),(511,4,11,5,7,0,0,0,'1',1,'2013-05-08'),(512,4,11,5,8,0,0,0,'1',1,'2013-05-08'),(513,5,11,1,2,0,0,0,'1',1,'2013-05-08'),(514,5,11,1,1,0,0,0,'1',1,'2013-05-08'),(515,5,11,2,4,0,0,0,'1',1,'2013-05-08'),(516,5,11,2,3,0,0,0,'1',1,'2013-05-08'),(517,5,11,3,5,0,0,0,'1',1,'2013-05-08'),(518,5,11,4,9,0,0,0,'1',1,'2013-05-08'),(519,5,11,5,7,0,0,0,'1',1,'2013-05-08'),(520,5,11,5,8,0,0,0,'1',1,'2013-05-08'),(521,6,11,1,2,0,0,0,'1',1,'2013-05-08'),(522,6,11,1,1,0,0,0,'1',1,'2013-05-08'),(523,6,11,2,4,0,0,0,'1',1,'2013-05-08'),(524,6,11,2,3,0,0,0,'1',1,'2013-05-08'),(525,6,11,3,5,0,0,0,'1',1,'2013-05-08'),(526,6,11,4,9,0,0,0,'1',1,'2013-05-08'),(527,6,11,5,7,0,0,0,'1',1,'2013-05-08'),(528,6,11,5,8,0,0,0,'1',1,'2013-05-08'),(529,1,1,1,10,0,0,0,'1',1,'2013-05-12'),(530,1,11,1,10,0,0,0,'1',1,'2013-05-12'),(531,1,2,1,10,0,0,0,'1',1,'2013-05-12'),(532,1,3,1,10,0,0,0,'1',1,'2013-05-12'),(533,1,4,1,10,0,0,1,'1',1,'2013-05-12'),(534,1,5,1,10,0,0,0,'1',1,'2013-05-12'),(535,1,6,1,10,0,0,0,'1',1,'2013-05-12'),(536,1,7,1,10,0,0,0,'1',1,'2013-05-12'),(537,1,8,1,10,0,0,0,'1',1,'2013-05-12'),(538,1,9,1,10,0,0,0,'1',1,'2013-05-12'),(539,1,10,1,10,0,0,0,'1',1,'2013-05-12'),(540,2,1,1,10,0,0,0,'1',1,'2013-05-12'),(541,2,11,1,10,0,0,0,'1',1,'2013-05-12'),(542,2,2,1,10,0,0,0,'1',1,'2013-05-12'),(543,2,3,1,10,0,0,0,'1',1,'2013-05-12'),(544,2,4,1,10,0,0,1,'1',1,'2013-05-12'),(545,2,5,1,10,0,0,0,'1',1,'2013-05-12'),(546,2,6,1,10,0,0,0,'1',1,'2013-05-12'),(547,2,7,1,10,0,0,0,'1',1,'2013-05-12'),(548,2,8,1,10,0,0,0,'1',1,'2013-05-12'),(549,2,9,1,10,0,0,0,'1',1,'2013-05-12'),(550,2,10,1,10,0,0,0,'1',1,'2013-05-12'),(551,3,1,1,10,0,0,0,'1',1,'2013-05-12'),(552,3,11,1,10,0,0,0,'1',1,'2013-05-12'),(553,3,2,1,10,0,0,0,'1',1,'2013-05-12'),(554,3,3,1,10,0,0,0,'1',1,'2013-05-12'),(555,3,4,1,10,0,0,1,'1',1,'2013-05-12'),(556,3,5,1,10,0,0,0,'1',1,'2013-05-12'),(557,3,6,1,10,0,0,0,'1',1,'2013-05-12'),(558,3,7,1,10,0,0,0,'1',1,'2013-05-12'),(559,3,8,1,10,0,0,0,'1',1,'2013-05-12'),(560,3,9,1,10,0,0,0,'1',1,'2013-05-12'),(561,3,10,1,10,0,0,0,'1',1,'2013-05-12'),(562,4,1,1,10,0,0,0,'1',1,'2013-05-12'),(563,4,11,1,10,0,0,0,'1',1,'2013-05-12'),(564,4,2,1,10,0,0,0,'1',1,'2013-05-12'),(565,4,3,1,10,0,0,0,'1',1,'2013-05-12'),(566,4,4,1,10,0,0,1,'1',1,'2013-05-12'),(567,4,5,1,10,0,0,0,'1',1,'2013-05-12'),(568,4,6,1,10,0,0,0,'1',1,'2013-05-12'),(569,4,7,1,10,0,0,0,'1',1,'2013-05-12'),(570,4,8,1,10,0,0,0,'1',1,'2013-05-12'),(571,4,9,1,10,0,0,0,'1',1,'2013-05-12'),(572,4,10,1,10,0,0,0,'1',1,'2013-05-12'),(573,5,1,1,10,0,0,0,'1',1,'2013-05-12'),(574,5,11,1,10,0,0,0,'1',1,'2013-05-12'),(575,5,2,1,10,0,0,0,'1',1,'2013-05-12'),(576,5,3,1,10,0,0,0,'1',1,'2013-05-12'),(577,5,4,1,10,0,0,1,'1',1,'2013-05-12'),(578,5,5,1,10,0,0,0,'1',1,'2013-05-12'),(579,5,6,1,10,0,0,0,'1',1,'2013-05-12'),(580,5,7,1,10,0,0,0,'1',1,'2013-05-12'),(581,5,8,1,10,0,0,0,'1',1,'2013-05-12'),(582,5,9,1,10,0,0,0,'1',1,'2013-05-12'),(583,5,10,1,10,0,0,0,'1',1,'2013-05-12'),(584,6,1,1,10,0,0,0,'1',1,'2013-05-12'),(585,6,11,1,10,0,0,0,'1',1,'2013-05-12'),(586,6,2,1,10,0,0,0,'1',1,'2013-05-12'),(587,6,3,1,10,0,0,0,'1',1,'2013-05-12'),(588,6,4,1,10,0,0,1,'1',1,'2013-05-12'),(589,6,5,1,10,0,0,0,'1',1,'2013-05-12'),(590,6,6,1,10,0,0,0,'1',1,'2013-05-12'),(591,6,7,1,10,0,0,0,'1',1,'2013-05-12'),(592,6,8,1,10,0,0,0,'1',1,'2013-05-12'),(593,6,9,1,10,0,0,0,'1',1,'2013-05-12'),(594,6,10,1,10,0,0,0,'1',1,'2013-05-12');

/*Table structure for table `std_class_routine_test` */

DROP TABLE IF EXISTS `std_class_routine_test`;

CREATE TABLE `std_class_routine_test` (
  `id` int(4) NOT NULL auto_increment,
  `period` varchar(10) default NULL,
  `day_sat` varchar(50) default NULL,
  `day_sun` varchar(50) default NULL,
  `day_mon` varchar(50) default NULL,
  `day_tue` varchar(50) default NULL,
  `day_wed` varchar(50) default NULL,
  `day_thus` varchar(50) default NULL,
  `class_id` int(3) default NULL,
  `sec_id` int(3) default NULL,
  `class_time` time default NULL,
  `Class_name` varchar(50) default NULL,
  `sec_name` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

/*Data for the table `std_class_routine_test` */

/*Table structure for table `std_class_section_config` */

DROP TABLE IF EXISTS `std_class_section_config`;

CREATE TABLE `std_class_section_config` (
  `id` int(10) NOT NULL auto_increment,
  `section_name` varchar(10) default NULL,
  `class_id` int(10) default NULL,
  `class_name` varchar(20) default NULL,
  `class_teacher_id` int(10) default NULL,
  `class_teacher_name` varchar(100) default NULL,
  `subject_id` int(10) default NULL,
  `subject_name` varchar(50) default NULL,
  `no_of_student` int(10) default NULL,
  `branch_id` int(10) default NULL,
  `group_id` int(10) default NULL,
  `section_system` varchar(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

/*Data for the table `std_class_section_config` */

insert  into `std_class_section_config`(`id`,`section_name`,`class_id`,`class_name`,`class_teacher_id`,`class_teacher_name`,`subject_id`,`subject_name`,`no_of_student`,`branch_id`,`group_id`,`section_system`) values (1,'A',1,'Class-1',0,'Bithi',1,'Bangla',100,1,NULL,'E'),(2,'B',1,'Class-1',2,'meherun',3,'Math',100,1,NULL,'E'),(3,'A',2,'Class-2',1,'Bithi',5,'english',100,1,NULL,'E'),(4,'B',2,'Class-2',4,'pankoj',6,'Math',100,1,NULL,'E'),(5,'A',3,'Class-3',5,'Dulal',7,'Bangla',100,1,NULL,'E'),(7,'A',5,'class-5',1,'khokon',10,'bangla',40,1,NULL,'E'),(8,'B',5,'class-5',2,'Fahim',11,'english',60,1,NULL,'E'),(9,'A',4,'Class-4',3,'Abdul Mojid',14,'Math',200,1,NULL,'E'),(10,'C',1,'Class-1',2,'Fahim',3,'Math',50,1,NULL,'E');

/*Table structure for table `std_class_student_info` */

DROP TABLE IF EXISTS `std_class_student_info`;

CREATE TABLE `std_class_student_info` (
  `id` int(100) NOT NULL auto_increment,
  `class_id` int(100) default NULL,
  `sec_id` int(10) default NULL,
  `class_name` varchar(100) default NULL,
  `class_sec` varchar(100) default NULL,
  `stu_id` varchar(50) default NULL,
  `stu_name` varchar(100) default NULL,
  `class_roll` int(100) default NULL,
  `total_open_day` int(50) default NULL,
  `total_atten` int(50) default NULL,
  `total_leave` int(20) default NULL,
  `total_abs` int(10) default NULL,
  `stuts` varchar(100) default NULL,
  `remarks` varchar(500) default NULL,
  `year` varchar(50) default NULL,
  `result` varchar(50) default NULL,
  `final_marks` varchar(50) default NULL,
  `branch_id` int(10) default NULL,
  `branch_name` varchar(50) default NULL,
  `group_id` int(10) default NULL,
  `group_name` varchar(50) default NULL,
  `ovr_roll` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `std_class_student_info` */

insert  into `std_class_student_info`(`id`,`class_id`,`sec_id`,`class_name`,`class_sec`,`stu_id`,`stu_name`,`class_roll`,`total_open_day`,`total_atten`,`total_leave`,`total_abs`,`stuts`,`remarks`,`year`,`result`,`final_marks`,`branch_id`,`branch_name`,`group_id`,`group_name`,`ovr_roll`) values (2,1,2,'Class-1','B','2013122','Test',1,NULL,NULL,NULL,NULL,'Admitted',NULL,'2013',NULL,NULL,1,NULL,NULL,NULL,2);

/*Table structure for table `std_exam_config` */

DROP TABLE IF EXISTS `std_exam_config`;

CREATE TABLE `std_exam_config` (
  `id` int(100) NOT NULL auto_increment,
  `exam_name` varchar(100) default NULL,
  `period` varchar(100) default NULL,
  `Prefix` varchar(10) default NULL,
  `branch_id` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

/*Data for the table `std_exam_config` */

insert  into `std_exam_config`(`id`,`exam_name`,`period`,`Prefix`,`branch_id`) values (1,'CT1','1','C',1),(2,'CT2','1','C',1),(4,'CT3','1','C',1),(5,'ST1','1','S',1),(6,'ST2','1','S',1),(7,'ST3','1','S',1),(8,'Term1','1','T',1),(9,'Term2','2','T',1),(10,'CT1','2','C',1),(11,'CT2','2','C',1),(12,'CT3','2','C',1),(13,'ST3','2','S',1),(14,'ST2','2','S',1),(15,'ST1','2','S',1),(16,'CT1','2','C',1),(17,'CT1','3','C',1),(18,'CT2','3','C',1),(19,'CT3','3','C',1),(20,'ST1','3','S',1),(21,'ST2','3','S',1),(22,'ST3','3','S',1),(23,'Term3','3','T',1);

/*Table structure for table `std_exam_config_new` */

DROP TABLE IF EXISTS `std_exam_config_new`;

CREATE TABLE `std_exam_config_new` (
  `id` int(11) NOT NULL auto_increment,
  `academic_year` int(11) NOT NULL,
  `exam_name` varchar(255) collate utf8_unicode_ci NOT NULL,
  `period_ids` varchar(255) collate utf8_unicode_ci NOT NULL,
  `entry_date` date NOT NULL,
  `flag` int(2) NOT NULL default '1',
  `branch_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `std_exam_config_new` */

insert  into `std_exam_config_new`(`id`,`academic_year`,`exam_name`,`period_ids`,`entry_date`,`flag`,`branch_id`) values (1,2013,'1st Term','-1,1,2,3,-1','2013-03-31',1,1),(2,2013,'2nd Term','-1,1,2,3,-1','2013-03-31',1,1),(3,2013,'Final','-1,4,5,6,-1','2013-03-31',1,1);

/*Table structure for table `std_exam_period` */

DROP TABLE IF EXISTS `std_exam_period`;

CREATE TABLE `std_exam_period` (
  `id` int(11) NOT NULL auto_increment,
  `period` varchar(255) collate utf8_unicode_ci NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `flag` int(2) NOT NULL default '1',
  `entry_date` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `std_exam_period` */

insert  into `std_exam_period`(`id`,`period`,`start_time`,`end_time`,`flag`,`entry_date`) values (1,'1st Exam','07:00:00','09:30:00',1,'2013-03-31'),(2,'2nd Exam','10:00:00','12:30:00',1,'2013-03-31'),(3,'3rd Exam','14:00:00','16:30:00',1,'2013-03-31'),(4,'1st Exam','07:00:00','10:00:00',1,'2013-03-31'),(5,'2nd Exam','10:30:00','01:30:00',1,'2013-03-31'),(6,'3rd Exam','14:15:00','17:15:00',1,'2013-03-31'),(7,'4th exam','19:00:00','21:00:00',1,'2013-05-12');

/*Table structure for table `std_exam_routine_new` */

DROP TABLE IF EXISTS `std_exam_routine_new`;

CREATE TABLE `std_exam_routine_new` (
  `id` int(11) NOT NULL auto_increment,
  `academic_year` int(11) NOT NULL,
  `exam_name_id` int(11) NOT NULL,
  `exam_date` date NOT NULL,
  `exam_period_id` int(11) NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL default '0',
  `subject_id` int(11) NOT NULL,
  `entry_date` date NOT NULL,
  `branch_id` int(11) NOT NULL,
  `flag` int(2) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `std_exam_routine_new` */

insert  into `std_exam_routine_new`(`id`,`academic_year`,`exam_name_id`,`exam_date`,`exam_period_id`,`start_time`,`end_time`,`class_id`,`section_id`,`subject_id`,`entry_date`,`branch_id`,`flag`) values (1,2013,1,'2013-04-09',1,'07:00:00','09:30:00',1,0,1,'2013-04-09',1,1),(2,2013,1,'2013-04-09',2,'10:00:00','12:30:00',1,0,3,'2013-04-09',1,1),(3,2013,1,'2013-05-03',1,'07:00:00','09:30:00',2,0,4,'2013-05-03',1,1),(4,2013,1,'2013-05-03',2,'10:00:00','12:30:00',2,0,5,'2013-05-03',1,1),(5,2013,1,'2013-05-12',1,'07:00:00','09:30:00',5,0,15,'2013-05-12',1,1);

/*Table structure for table `std_exam_schedule` */

DROP TABLE IF EXISTS `std_exam_schedule`;

CREATE TABLE `std_exam_schedule` (
  `id` int(10) NOT NULL auto_increment,
  `class_id` int(100) default NULL,
  `class_name` varchar(100) default NULL,
  `exam_id` int(10) default NULL,
  `exam_name` varchar(100) default NULL,
  `period` int(10) default NULL,
  `subject_id` int(10) default NULL,
  `subject_name` varchar(100) default NULL,
  `exam_date` varchar(100) default NULL,
  `exam_start_time` varchar(100) default NULL,
  `exam_end_time` varchar(100) default NULL,
  `duration` varchar(100) default NULL,
  `mark` float default NULL,
  `section_id` int(10) default NULL,
  `group_id` int(10) default NULL,
  `branch_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

/*Data for the table `std_exam_schedule` */

insert  into `std_exam_schedule`(`id`,`class_id`,`class_name`,`exam_id`,`exam_name`,`period`,`subject_id`,`subject_name`,`exam_date`,`exam_start_time`,`exam_end_time`,`duration`,`mark`,`section_id`,`group_id`,`branch_id`) values (1,1,'class-1',8,'term-1',1,1,'Bangla','10-6-2011','9:00AM','12PM','3',100,NULL,NULL,NULL),(2,1,'class-1',NULL,'term-1',1,2,'Bangla Language','12-12-2012','8:00AM','10:0','3',70,0,NULL,1),(4,2,'class-2',NULL,'CT2',2,4,'English Literature','24-05-2012','8:00AM','11:0','3',NULL,NULL,NULL,1),(5,1,'class-1',NULL,'CT1',1,2,'Bangla Language','25-05-2012','8:00AM','11:0','3',NULL,NULL,NULL,1),(6,1,'class-1',NULL,'SP1',1,1,'General Math','26-05-2012','9:00AM','11:00','3',NULL,NULL,NULL,1);

/*Table structure for table `std_fee_collection` */

DROP TABLE IF EXISTS `std_fee_collection`;

CREATE TABLE `std_fee_collection` (
  `id` int(10) NOT NULL auto_increment,
  `std_id` varchar(20) default NULL,
  `std_name` varchar(70) default NULL,
  `class_id` int(10) default NULL,
  `class_name` varchar(30) default NULL,
  `section` varchar(5) default NULL,
  `class_roll` int(10) default NULL,
  `amount` decimal(10,2) default NULL,
  `month` varchar(20) default NULL,
  `pay_date` date default NULL,
  `status` varchar(20) default NULL,
  `branch_id` int(10) default NULL,
  `month_date` date default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `std_fee_collection` */

insert  into `std_fee_collection`(`id`,`std_id`,`std_name`,`class_id`,`class_name`,`section`,`class_roll`,`amount`,`month`,`pay_date`,`status`,`branch_id`,`month_date`) values (1,'2013111','Hasan',1,'Class-1','A',1,'130.00','Mar-2013','0000-00-00','paid',1,'2013-03-01'),(2,'2013122','Test',1,'Class-1','B',1,'130.00','Mar-2013','0000-00-00','due',1,'2013-03-01');

/*Table structure for table `std_fee_details` */

DROP TABLE IF EXISTS `std_fee_details`;

CREATE TABLE `std_fee_details` (
  `id` int(30) NOT NULL auto_increment,
  `class_id` int(30) NOT NULL,
  `section_id` int(10) NOT NULL,
  `class_name` varchar(30) NOT NULL,
  `std_id` varchar(50) NOT NULL,
  `roll` int(10) NOT NULL,
  `std_name` varchar(30) NOT NULL,
  `fee_head_name` varchar(30) NOT NULL,
  `category` varchar(30) NOT NULL,
  `amount` int(20) NOT NULL,
  `month` varchar(20) NOT NULL,
  `payment_date` date NOT NULL,
  `group_id` int(10) NOT NULL,
  `branch_id` int(10) NOT NULL,
  `generation_status` varchar(20) NOT NULL,
  `checker_status` varchar(20) NOT NULL,
  `collection_status` varchar(20) NOT NULL,
  `month_date` date default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

/*Data for the table `std_fee_details` */

insert  into `std_fee_details`(`id`,`class_id`,`section_id`,`class_name`,`std_id`,`roll`,`std_name`,`fee_head_name`,`category`,`amount`,`month`,`payment_date`,`group_id`,`branch_id`,`generation_status`,`checker_status`,`collection_status`,`month_date`) values (16,1,2,'Class-1','2013122',1,'Test','Exam','fixed',40,'Mar-2013','2013-04-04',0,1,'initiate','checked','unpaid','2013-03-01'),(15,1,2,'Class-1','2013122',1,'Test','Transport','fixed',40,'Mar-2013','2013-04-04',0,1,'initiate','checked','unpaid','2013-03-01'),(14,1,2,'Class-1','2013122',1,'Test','Admission','fixed',50,'Mar-2013','2013-04-04',0,1,'initiate','checked','unpaid','2013-03-01'),(13,1,1,'Class-1','2013111',1,'Hasan','Exam','fixed',40,'Mar-2013','2013-04-04',0,1,'initiate','checked','paid','2013-03-01'),(12,1,1,'Class-1','2013111',1,'Hasan','Transport','fixed',40,'Mar-2013','2013-04-04',0,1,'initiate','checked','paid','2013-03-01'),(11,1,1,'Class-1','2013111',1,'Hasan','Admission','fixed',50,'Mar-2013','2013-04-04',0,1,'initiate','checked','paid','2013-03-01');

/*Table structure for table `std_fee_details_bak` */

DROP TABLE IF EXISTS `std_fee_details_bak`;

CREATE TABLE `std_fee_details_bak` (
  `id` int(100) NOT NULL auto_increment,
  `class_id` int(10) default NULL,
  `class_name` varchar(100) default NULL,
  `section_id` int(100) default NULL,
  `std_id` int(10) default NULL,
  `roll` int(10) default NULL,
  `std_name` varchar(100) default NULL,
  `tution_fee` int(100) default NULL,
  `hostel_fee` int(100) default NULL,
  `exam_fee` int(100) default NULL,
  `Miscellanies` int(100) default NULL,
  `due_amnt` int(100) default NULL,
  `date` varchar(100) default NULL,
  `paymeny_status` int(100) default NULL,
  `group_id` int(10) default NULL,
  `branch_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

/*Data for the table `std_fee_details_bak` */

/*Table structure for table `std_fee_info` */

DROP TABLE IF EXISTS `std_fee_info`;

CREATE TABLE `std_fee_info` (
  `id` int(10) NOT NULL auto_increment,
  `std_id` varchar(50) default NULL,
  `voucher_id` varchar(20) default NULL,
  `fee_head` varchar(160) default NULL,
  `fee_amount` float default NULL,
  `date` date default NULL,
  `class_id` int(10) default NULL,
  `sec_id` int(10) default NULL,
  `branch_id` int(10) default NULL,
  `fee_type` varchar(20) default NULL,
  `std_roll` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `std_fee_info` */

/*Table structure for table `std_final_result_after_process` */

DROP TABLE IF EXISTS `std_final_result_after_process`;

CREATE TABLE `std_final_result_after_process` (
  `id` int(10) NOT NULL auto_increment,
  `stu_id` varchar(30) default NULL,
  `class_id` int(10) default NULL,
  `class_sec` varchar(5) default NULL,
  `prev_sec_roll` int(10) default NULL,
  `prev_class_roll` int(10) default NULL,
  `new_sec_roll` int(10) default NULL,
  `new_class_roll` int(10) default NULL,
  `period` int(10) default NULL,
  `cgpa` decimal(10,2) default NULL,
  `grade` varchar(3) default NULL,
  `year` varchar(10) default NULL,
  `branch_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `std_final_result_after_process` */

insert  into `std_final_result_after_process`(`id`,`stu_id`,`class_id`,`class_sec`,`prev_sec_roll`,`prev_class_roll`,`new_sec_roll`,`new_class_roll`,`period`,`cgpa`,`grade`,`year`,`branch_id`) values (1,'2013111',1,'A',1,1,1,1,1,'2.25','C','2013',1);

/*Table structure for table `std_mark_promo` */

DROP TABLE IF EXISTS `std_mark_promo`;

CREATE TABLE `std_mark_promo` (
  `id` int(100) NOT NULL auto_increment,
  `pre_class` int(10) default NULL,
  `pre_stu_id` varchar(50) default NULL,
  `total_point` decimal(5,2) default NULL,
  `pre_class_sec_roll` varchar(20) default NULL,
  `new_class_roll` varchar(20) default NULL,
  `pre_year` varchar(5) default NULL,
  `new_year` varchar(5) default NULL,
  `pre_section` varchar(5) default NULL,
  `total_mark` decimal(10,2) default NULL,
  `grade` varchar(5) default NULL,
  `cgpa` decimal(5,2) default NULL,
  `termid` int(3) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `std_mark_promo` */

/*Table structure for table `std_profile` */

DROP TABLE IF EXISTS `std_profile`;

CREATE TABLE `std_profile` (
  `id` int(100) NOT NULL auto_increment,
  `stu_id` varchar(100) default NULL,
  `name` varchar(160) default NULL,
  `father_name` varchar(160) default NULL,
  `mother_name` varchar(160) default NULL,
  `pre_address` text,
  `par_address` text,
  `home_phone` varchar(50) default NULL,
  `emer_name1` varchar(100) default NULL,
  `emer_mobile1` varchar(50) default NULL,
  `emer_name2` varchar(100) default NULL,
  `emer_mobile2` varchar(50) default NULL,
  `mail_add` varchar(100) default NULL,
  `sex` varchar(50) default NULL,
  `age` varchar(100) default NULL,
  `adm_date` varchar(100) default NULL,
  `dob` date default NULL,
  `adm_class` varchar(100) default NULL,
  `adm_class_roll` varchar(100) default NULL,
  `adm_group` varchar(50) default NULL,
  `section` varchar(20) default NULL,
  `father_income` varchar(50) default NULL,
  `mother_income` varchar(50) default NULL,
  `father_profession` varchar(200) default NULL,
  `mother_profession` varchar(200) default NULL,
  `father_qualification` varchar(200) default NULL,
  `mother_qualification` varchar(200) default NULL,
  `father_work_phone` varchar(50) default NULL,
  `mother_work_phone` varchar(50) default NULL,
  `admission_fee` varchar(100) default NULL,
  `priv_schoole_name` varchar(200) default NULL,
  `priv_school_add` varchar(100) default NULL,
  `priv_school_class` varchar(100) default NULL,
  `priv_school_class_roll` varchar(20) default NULL,
  `priv_school_remarks` varchar(300) default NULL,
  `priv_school_result` varchar(20) default NULL,
  `present_class` varchar(50) default NULL,
  `present_class_roll` varchar(50) default NULL,
  `st_status` varchar(50) default NULL,
  `branch_id` int(11) default NULL,
  `ovr_roll` int(10) default NULL,
  `religion` varchar(40) default NULL,
  `nationality` varchar(50) default NULL,
  `quota` varchar(30) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `std_profile` */

insert  into `std_profile`(`id`,`stu_id`,`name`,`father_name`,`mother_name`,`pre_address`,`par_address`,`home_phone`,`emer_name1`,`emer_mobile1`,`emer_name2`,`emer_mobile2`,`mail_add`,`sex`,`age`,`adm_date`,`dob`,`adm_class`,`adm_class_roll`,`adm_group`,`section`,`father_income`,`mother_income`,`father_profession`,`mother_profession`,`father_qualification`,`mother_qualification`,`father_work_phone`,`mother_work_phone`,`admission_fee`,`priv_schoole_name`,`priv_school_add`,`priv_school_class`,`priv_school_class_roll`,`priv_school_remarks`,`priv_school_result`,`present_class`,`present_class_roll`,`st_status`,`branch_id`,`ovr_roll`,`religion`,`nationality`,`quota`) values (1,'2013111','Hasan','Halim','Helina','dhaka','','','','','','','','Male','10','2013-03-16','1988-07-14','1','1','','A','232323','131313','Business','Housewife','custom','custom','131313131','213131313','custom','abc','dhaka','1','1','custom','1','Class-1','custom','available',1,1,NULL,NULL,NULL),(2,'2013122','Test','abal','fdafas','dhaka','','','','','','','','Male','10','2013-03-10','1988-10-10','1','1','','B','2121212','13131','fadfa','fad','custom','custom','1211231313','131333','custom','abc','daldajfa','1','1','custom','1','Class-1','custom','available',1,2,NULL,NULL,NULL);

/*Table structure for table `std_subject_config` */

DROP TABLE IF EXISTS `std_subject_config`;

CREATE TABLE `std_subject_config` (
  `id` int(100) NOT NULL auto_increment,
  `class_id` int(10) default NULL,
  `subject_code` varchar(10) default NULL,
  `subject_name` varchar(100) default NULL,
  `sub_mark` int(10) default '0',
  `ct_mark` int(10) default '0',
  `ob_mark` int(10) default '0',
  `practical_mark` int(10) default '0',
  `st_mark` int(10) default '0',
  `final_mark` int(10) default '0',
  `branch_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

/*Data for the table `std_subject_config` */

insert  into `std_subject_config`(`id`,`class_id`,`subject_code`,`subject_name`,`sub_mark`,`ct_mark`,`ob_mark`,`practical_mark`,`st_mark`,`final_mark`,`branch_id`) values (1,1,'101','Bangla',60,20,0,0,25,105,1),(9,3,'303','Math',50,50,0,0,20,120,1),(3,1,'103','Math',50,30,0,0,20,100,1),(4,2,'Bangla','201',50,30,0,0,20,100,1),(5,2,'202','english',50,30,0,0,20,100,1),(6,2,'203','Math',50,30,0,0,20,100,1),(7,3,'301','Bangla',50,30,0,0,20,100,1),(8,3,'302','English',50,30,0,0,20,100,1),(10,5,'501','bangla',50,30,0,0,20,100,1),(11,5,'502','english',50,20,0,0,10,80,1),(12,4,'401','Bangla',50,30,0,0,20,100,1),(13,4,'402','English',50,30,0,0,20,100,1),(14,4,'403','Math',60,20,0,0,20,100,1),(15,5,'203','marketting',50,10,0,0,50,110,1);

/*Table structure for table `std_tc_info` */

DROP TABLE IF EXISTS `std_tc_info`;

CREATE TABLE `std_tc_info` (
  `id` int(10) NOT NULL auto_increment,
  `std_id` varchar(20) NOT NULL,
  `class_id` int(10) default NULL,
  `section` varchar(10) default NULL,
  `class_roll` int(10) default NULL,
  `tc_date` date default NULL,
  `reason` varchar(150) default NULL,
  `remarks` varchar(150) default NULL,
  `branch_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `std_tc_info` */

/*Table structure for table `std_teacher` */

DROP TABLE IF EXISTS `std_teacher`;

CREATE TABLE `std_teacher` (
  `id` int(10) NOT NULL auto_increment,
  `teacher_name` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `std_teacher` */

/*Table structure for table `std_teacher_info` */

DROP TABLE IF EXISTS `std_teacher_info`;

CREATE TABLE `std_teacher_info` (
  `id` int(10) NOT NULL auto_increment,
  `teacher_name` varchar(100) default NULL,
  `Telephone` varchar(50) default NULL,
  `mobile` varchar(50) default NULL,
  `email` varchar(50) default NULL,
  `Last_education` varchar(500) default NULL,
  `married` varchar(10) default NULL,
  `sex` varchar(10) default NULL,
  `picture` varchar(100) default NULL,
  `subject` varchar(100) default NULL,
  `group` varchar(30) default NULL,
  `job_experience` varchar(500) default NULL,
  `branch_id` int(10) default NULL,
  `teacher_code` varchar(20) NOT NULL,
  `nationality` varchar(30) NOT NULL,
  `birth_date` date NOT NULL,
  `age` int(5) NOT NULL,
  `other_add` varchar(100) NOT NULL,
  `present_add` varchar(100) NOT NULL,
  `permenent_add` varchar(100) NOT NULL,
  `present_status` varchar(30) NOT NULL,
  `basic` decimal(10,2) NOT NULL,
  `medical` decimal(10,2) default NULL,
  `house_rent` decimal(10,2) default NULL,
  `others` decimal(10,2) default NULL,
  `joining_date` date default NULL,
  `teacher_short_name` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

/*Data for the table `std_teacher_info` */

insert  into `std_teacher_info`(`id`,`teacher_name`,`Telephone`,`mobile`,`email`,`Last_education`,`married`,`sex`,`picture`,`subject`,`group`,`job_experience`,`branch_id`,`teacher_code`,`nationality`,`birth_date`,`age`,`other_add`,`present_add`,`permenent_add`,`present_status`,`basic`,`medical`,`house_rent`,`others`,`joining_date`,`teacher_short_name`) values (1,'khokon','31313131313','2132131431313','adfda@yahoo.com','fad','Single','Male',NULL,'Hibru','science','2 yrs',1,'KS','Bangladeshi','1985-10-10',25,'','afd','fad','Teacher','0.00',NULL,NULL,NULL,'2013-02-25','KS'),(2,'Fahim','416416416','13413131313','afda@yahoo.com','fadfa','Married','Male',NULL,'Urdu','adf','2 yrs',1,'FH','Bangladeshi','1986-12-10',26,'','fad','fads','teacher','0.00',NULL,NULL,NULL,'2013-03-10','FM'),(3,'Abdul Mojid','147','741','abdul.mojid@gmail.com','-','Married','Male',NULL,'-','-','-',1,'852','Bangladeshi','1982-12-31',30,'','-','-','Junior','0.00',NULL,NULL,NULL,'2013-01-01','MJD');

/*Table structure for table `std_voucher_summery` */

DROP TABLE IF EXISTS `std_voucher_summery`;

CREATE TABLE `std_voucher_summery` (
  `id` int(10) NOT NULL auto_increment,
  `voucher_id` bigint(15) default NULL,
  `std_id` varchar(50) default NULL,
  `class_id` int(10) default NULL,
  `month` varchar(30) default NULL,
  `year` varchar(15) default NULL,
  `total_amnt` float default NULL,
  `payment_stat` varchar(20) default 'DUE',
  `payment_date` date default NULL,
  `branch_id` int(10) default NULL,
  `month_date` date default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `std_voucher_summery` */

insert  into `std_voucher_summery`(`id`,`voucher_id`,`std_id`,`class_id`,`month`,`year`,`total_amnt`,`payment_stat`,`payment_date`,`branch_id`,`month_date`) values (1,201304040139424,'2013111',1,'Mar-2013','2013',130,'paid','2013-04-04',1,'2013-03-01'),(2,20130404013942,'2013122',1,'Mar-2013','2013',130,'due','2013-04-04',1,'2013-03-01');

/*Table structure for table `sub_menu1` */

DROP TABLE IF EXISTS `sub_menu1`;

CREATE TABLE `sub_menu1` (
  `id` int(10) NOT NULL auto_increment,
  `sub_menu1_name` varchar(100) default NULL,
  `main_menu_id` varchar(100) default NULL,
  `file_name` varchar(100) default NULL,
  `order_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;

/*Data for the table `sub_menu1` */

insert  into `sub_menu1`(`id`,`sub_menu1_name`,`main_menu_id`,`file_name`,`order_id`) values (1,'Course Info','3','view_course_info',NULL),(2,'Exam Info','','exam_information',NULL),(3,'Class Routine','3','class_routine_for_student',NULL),(4,'Student Profile','3','student_information',NULL),(5,'Student Fee Info','3','view_class_fee',NULL),(6,'Teacher\'s Routine','','teacher_routine_new',NULL),(9,'New Student','1','std_admission_form',NULL),(10,'Academic Activities',NULL,NULL,NULL),(11,'Make Fee','22','std_fee_generator_form',NULL),(12,'Employements','24',NULL,NULL),(13,'Teachers Details','15','teacher_information',NULL),(14,'Teacher Routine','15','class_routine_for_teacher',NULL),(15,'Student Attendance','15','student_attendence_entry',NULL),(91,'Generated Voucher List','38','generated_voucher_list',NULL),(17,'Generate Routine','24','routine_create',NULL),(18,'Add New Teacher','24','teacher_add_form',NULL),(19,'Create Syllabus','9',NULL,NULL),(20,'Notice Setting','24',NULL,NULL),(22,'Result Info','12','result_making_form',NULL),(23,'SMS Notification','24','sms_notification_send_form',NULL),(24,'Registration List','1',NULL,NULL),(25,'Classwise Student Info','3','class_wise_student_info',NULL),(26,'Student Attendance Info','3','student_attendence_entry',NULL),(27,'Parents Info','3','parents_info',NULL),(65,'Book List','3','book_list',NULL),(30,'Notice Board','6','notice_board',NULL),(31,'Create Student Account','6','create_student_account_form',NULL),(32,'Student TC','6','student_tc_form',NULL),(33,'Scholarship ','11','scholarship_info',NULL),(34,'Transport Fee','11','transport_fee',NULL),(35,'Hostel Fee','11','hostel_fee',NULL),(36,'Fee Details','11','view_class_fee',NULL),(37,'Exam Routine','12','view_exam_routine',NULL),(38,'Subject Info','15','view_course_info',NULL),(39,'Classwise Notification','16',NULL,NULL),(40,'Parents Detail','15','parents_info',NULL),(41,'Holiday Info','15','holiday_info',NULL),(42,'Leave Info','15','leave_info',NULL),(43,'Teacher Attendance Info','16','teacher_attendance_entry',NULL),(44,'Leave Request','16',NULL,NULL),(45,'Add New Section','28','section_config',20),(46,'Setting class information','28','class_config',10),(47,'Add New Fee','28','add_student_fee',100),(48,'Subject configure','28','subject_config',30),(49,'Setting class fee','28','class_fee_config',110),(96,'Teacher List','29','teacher_list_form',10),(51,'Grade Configure','28','grade_setting',60),(52,'Teacher Routine','46','teacher_routine_new',50),(53,'Exam schedule setting','46','exam_schedule_config_new',90),(54,'Exam configure','46','exam_config_new',80),(55,'Add New Teacher','29','teacher_add_form',1),(56,'Add New employee','29','new_employee_form',20),(57,'Result SMS Send','30','result_sms_sender_html_form',NULL),(58,'Fee SMS Send','30','fee_sms_sender_html_form',NULL),(61,'Employee List','29','employee_list',30),(59,'Add New Notice','31','new_notice_add',NULL),(60,'Notice Log','31','notice_log',NULL),(63,'Employee Leave Requests',NULL,NULL,NULL),(64,'Teacher Leave Request',NULL,NULL,NULL),(66,'Subject Syllabus',NULL,NULL,NULL),(67,'Teacher Classes','','teacher_classes',NULL),(69,'Book Setting','28','book_add',120),(70,'Teacher List','32','teacher_list_form',NULL),(71,'Employee List','32','employee_list_form',NULL),(72,'Notice SMS Send','30','notice_sms_sender_html_form',NULL),(73,'Setting Class Period','46','setting_class_period',40),(75,'Admission List','1','admission_student_list',NULL),(76,'Checking Fee','37','payment_check',NULL),(77,'Generate Voucher','38','make_voucher_form',NULL),(78,'Fee Collect','39','fee_collection_form',NULL),(79,'Fee Amendment','40','fee_amendment_form',NULL),(80,'Class ways fees','41','class_way_total_fee',NULL),(81,'Student way fee','41','student_way_total_fee',NULL),(82,'Fee Collection Report','41','fee_collection_report',NULL),(83,'Setting Exam Period','46','setting_exam_period',70),(84,'Accademic Calendar','46','accademic_calendar',130),(85,'Result Processing','42','result_process_form',NULL),(86,'Promotion','43','promotion_form',NULL),(87,'Manual Exam Mark Setting','26','exam_mark_setting',NULL),(88,'Excel File Mark Setting','26','excel_mark_setting',NULL),(89,'Generate Excel Mark','26','generate_excel_form',NULL),(90,'Studentwise Marks','26','student_wise_marks',NULL),(92,'Fee Checked List','37','fee_checked_list',NULL),(93,'Fee SMS Notification','41','fee_sms_sender_html_form',NULL),(94,'Result SMS Notification','26','result_sms_sender_html_form',NULL),(95,'Accademic Calendar','3','accademic_calendar',NULL),(97,'Fee Collection List','39','fee_collection_report',NULL),(98,'Class Routine','45','class_routine_for_student',1),(99,' 	Teacher Routine','45','class_routine_for_teacher',5),(100,'Accademic Calendar','45','accademic_calendar',10);

/*Table structure for table `sub_menu2` */

DROP TABLE IF EXISTS `sub_menu2`;

CREATE TABLE `sub_menu2` (
  `id` int(10) NOT NULL auto_increment,
  `sub_menu2_name` varchar(100) default NULL,
  `sub_menu1_id` varchar(200) default NULL,
  `file_name` varchar(200) default NULL,
  `order_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

/*Data for the table `sub_menu2` */

insert  into `sub_menu2`(`id`,`sub_menu2_name`,`sub_menu1_id`,`file_name`,`order_id`) values (12,'Add New Teacher','29','teacher_add_form',NULL),(13,'Add New employee','29','new_employee_form',NULL),(14,'Subject configure','28','subject_config',NULL),(15,'Exam schedule setting','28','exam_schedule_config',NULL),(16,'Class routine','28','class_routine',NULL),(17,'Setting class information','28','class_config',NULL),(18,'Exam configure','28','exam_config',NULL),(20,'Teachers class result','13',NULL,NULL),(22,'Add New Section','28','section_config',NULL),(23,'Teachers Routine','28','teacher_routine',NULL),(24,'Group setting','28','group_config',NULL),(25,'Setting class fee','28','class_fee_config',NULL),(27,'Add New Fee','28','add_student_fee',NULL),(28,'View Class Fee','28','view_class_fee',NULL),(32,'Manual Exam Mark Setting','16','exam_mark_setting',NULL),(33,'Excel File Mark Setting','16','excel_mark_setting',NULL),(34,'Generate Excel Mark','16','generate_excel_form',NULL),(35,'Text Notice','20',NULL,NULL),(36,'File Notice','20',NULL,NULL),(37,'Grade Configure','28','grade_setting',NULL),(38,'Result Processing','16','result_process_form',NULL),(40,'Promotion','16','promotion_form',NULL),(42,'Subjectwise Marks','16','subjectwise_mark_form',NULL),(43,'Email Notification','39','email_notification_ui_form',NULL),(44,'SMS Notification','39','sms_notification_form',NULL),(47,'Studentwise Marks','16','student_wise_marks',NULL),(48,'Accademic Calendar','10','accademic_calendar',NULL);

/*Table structure for table `tbl_acc_calendar` */

DROP TABLE IF EXISTS `tbl_acc_calendar`;

CREATE TABLE `tbl_acc_calendar` (
  `id` int(10) NOT NULL auto_increment,
  `date` date default NULL,
  `day_name` varchar(20) default NULL,
  `evtn_name` text,
  `flag` int(2) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=366 DEFAULT CHARSET=latin1;

/*Data for the table `tbl_acc_calendar` */

insert  into `tbl_acc_calendar`(`id`,`date`,`day_name`,`evtn_name`,`flag`) values (1,'2013-01-01','Tue',' ',0),(2,'2013-01-02','Wed','',0),(3,'2013-01-03','Thu',' ',0),(4,'2013-01-04','Fri','Weekend',1),(5,'2013-01-05','Sat',' ',0),(6,'2013-01-06','Sun',' ',0),(7,'2013-01-07','Mon','',0),(8,'2013-01-08','Tue','dfa',1),(9,'2013-01-09','Wed',' ',0),(10,'2013-01-10','Thu',' ',0),(11,'2013-01-11','Fri','Weekend',1),(12,'2013-01-12','Sat',' ',0),(13,'2013-01-13','Sun',' ',0),(14,'2013-01-14','Mon','',0),(15,'2013-01-15','Tue','',0),(16,'2013-01-16','Wed','',0),(17,'2013-01-17','Thu',' ',0),(18,'2013-01-18','Fri','Weekend',1),(19,'2013-01-19','Sat',' ',0),(20,'2013-01-20','Sun','',0),(21,'2013-01-21','Mon',' ',0),(22,'2013-01-22','Tue','',0),(23,'2013-01-23','Wed',' ',0),(24,'2013-01-24','Thu',' ',0),(25,'2013-01-25','Fri','Weekend',1),(26,'2013-01-26','Sat',' ',0),(27,'2013-01-27','Sun',' ',0),(28,'2013-01-28','Mon',' ',0),(29,'2013-01-29','Tue',' ',0),(30,'2013-01-30','Wed',' ',0),(31,'2013-01-31','Thu',' ',0),(32,'2013-02-01','Fri','Weekend',1),(33,'2013-02-02','Sat',' ',0),(34,'2013-02-03','Sun',' ',0),(35,'2013-02-04','Mon',' ',0),(36,'2013-02-05','Tue',' ',0),(37,'2013-02-06','Wed',' ',0),(38,'2013-02-07','Thu',' ',0),(39,'2013-02-08','Fri','Weekend',1),(40,'2013-02-09','Sat',' ',0),(41,'2013-02-10','Sun',' ',0),(42,'2013-02-11','Mon',' ',0),(43,'2013-02-12','Tue','',0),(44,'2013-02-13','Wed',' ',0),(45,'2013-02-14','Thu','',0),(46,'2013-02-15','Fri','Weekend',1),(47,'2013-02-16','Sat',' ',0),(48,'2013-02-17','Sun',' ',0),(49,'2013-02-18','Mon',' ',0),(50,'2013-02-19','Tue',' ',0),(51,'2013-02-20','Wed',' ',0),(52,'2013-02-21','Thu','Internation Mother Language Day',1),(53,'2013-02-22','Fri','Weekend',1),(54,'2013-02-23','Sat',' ',0),(55,'2013-02-24','Sun',' ',0),(56,'2013-02-25','Mon',' ',0),(57,'2013-02-26','Tue',' ',0),(58,'2013-02-27','Wed',' ',0),(59,'2013-02-28','Thu',' ',0),(60,'2013-03-01','Fri','Weekend',1),(61,'2013-03-02','Sat',' ',0),(62,'2013-03-03','Sun',' ',0),(63,'2013-03-04','Mon',' ',0),(64,'2013-03-05','Tue',' ',0),(65,'2013-03-06','Wed',' ',0),(66,'2013-03-07','Thu',' ',0),(67,'2013-03-08','Fri','Weekend',1),(68,'2013-03-09','Sat',' ',0),(69,'2013-03-10','Sun',' ',0),(70,'2013-03-11','Mon',' ',0),(71,'2013-03-12','Tue',' ',0),(72,'2013-03-13','Wed',' ',0),(73,'2013-03-14','Thu',' ',0),(74,'2013-03-15','Fri','Weekend',1),(75,'2013-03-16','Sat',' ',0),(76,'2013-03-17','Sun',' ',0),(77,'2013-03-18','Mon',' ',0),(78,'2013-03-19','Tue',' ',0),(79,'2013-03-20','Wed',' ',0),(80,'2013-03-21','Thu',' ',0),(81,'2013-03-22','Fri','Weekend',1),(82,'2013-03-23','Sat',' ',0),(83,'2013-03-24','Sun',' ',0),(84,'2013-03-25','Mon',' ',0),(85,'2013-03-26','Tue','Independent Day',1),(86,'2013-03-27','Wed',' ',0),(87,'2013-03-28','Thu',' ',0),(88,'2013-03-29','Fri','Weekend',1),(89,'2013-03-30','Sat',' ',0),(90,'2013-03-31','Sun',' ',0),(91,'2013-04-01','Mon',' ',0),(92,'2013-04-02','Tue',' ',0),(93,'2013-04-03','Wed',' ',0),(94,'2013-04-04','Thu',' ',0),(95,'2013-04-05','Fri','Weekend',1),(96,'2013-04-06','Sat',' ',0),(97,'2013-04-07','Sun',' ',0),(98,'2013-04-08','Mon',' ',0),(99,'2013-04-09','Tue',' ',0),(100,'2013-04-10','Wed',' ',0),(101,'2013-04-11','Thu',' ',0),(102,'2013-04-12','Fri','Weekend',1),(103,'2013-04-13','Sat','1st Bosonto',1),(104,'2013-04-14','Sun','Bangla Noboborso',1),(105,'2013-04-15','Mon',' ',0),(106,'2013-04-16','Tue',' ',0),(107,'2013-04-17','Wed',' ',0),(108,'2013-04-18','Thu',' ',0),(109,'2013-04-19','Fri','Weekend',1),(110,'2013-04-20','Sat',' ',0),(111,'2013-04-21','Sun',' ',0),(112,'2013-04-22','Mon',' ',0),(113,'2013-04-23','Tue',' ',0),(114,'2013-04-24','Wed',' ',0),(115,'2013-04-25','Thu',' ',0),(116,'2013-04-26','Fri','Weekend',1),(117,'2013-04-27','Sat',' ',0),(118,'2013-04-28','Sun',' ',0),(119,'2013-04-29','Mon',' ',0),(120,'2013-04-30','Tue',' ',0),(121,'2013-05-01','Wed','Labour Day',1),(122,'2013-05-02','Thu',' ',0),(123,'2013-05-03','Fri','Weekend',1),(124,'2013-05-04','Sat',' ',0),(125,'2013-05-05','Sun',' ',0),(126,'2013-05-06','Mon',' ',0),(127,'2013-05-07','Tue',' ',0),(128,'2013-05-08','Wed',' ',0),(129,'2013-05-09','Thu',' ',0),(130,'2013-05-10','Fri','Weekend',1),(131,'2013-05-11','Sat',' ',0),(132,'2013-05-12','Sun',' ',0),(133,'2013-05-13','Mon',' ',0),(134,'2013-05-14','Tue',' ',0),(135,'2013-05-15','Wed',' ',0),(136,'2013-05-16','Thu',' ',0),(137,'2013-05-17','Fri','Weekend',1),(138,'2013-05-18','Sat',' ',0),(139,'2013-05-19','Sun',' ',0),(140,'2013-05-20','Mon',' ',0),(141,'2013-05-21','Tue',' ',0),(142,'2013-05-22','Wed',' ',0),(143,'2013-05-23','Thu',' ',0),(144,'2013-05-24','Fri','Weekend',1),(145,'2013-05-25','Sat',' ',0),(146,'2013-05-26','Sun',' ',0),(147,'2013-05-27','Mon',' ',0),(148,'2013-05-28','Tue',' ',0),(149,'2013-05-29','Wed',' ',0),(150,'2013-05-30','Thu',' ',0),(151,'2013-05-31','Fri','Weekend',1),(152,'2013-06-01','Sat',' ',0),(153,'2013-06-02','Sun',' ',0),(154,'2013-06-03','Mon',' ',0),(155,'2013-06-04','Tue',' ',0),(156,'2013-06-05','Wed',' ',0),(157,'2013-06-06','Thu',' ',0),(158,'2013-06-07','Fri','Weekend',1),(159,'2013-06-08','Sat',' ',0),(160,'2013-06-09','Sun',' ',0),(161,'2013-06-10','Mon',' ',0),(162,'2013-06-11','Tue',' ',0),(163,'2013-06-12','Wed',' ',0),(164,'2013-06-13','Thu',' ',0),(165,'2013-06-14','Fri','Weekend',1),(166,'2013-06-15','Sat',' ',0),(167,'2013-06-16','Sun',' ',0),(168,'2013-06-17','Mon',' ',0),(169,'2013-06-18','Tue',' ',0),(170,'2013-06-19','Wed',' ',0),(171,'2013-06-20','Thu',' ',0),(172,'2013-06-21','Fri','Weekend',1),(173,'2013-06-22','Sat',' ',0),(174,'2013-06-23','Sun',' ',0),(175,'2013-06-24','Mon',' ',0),(176,'2013-06-25','Tue',' ',0),(177,'2013-06-26','Wed',' ',0),(178,'2013-06-27','Thu',' ',0),(179,'2013-06-28','Fri','Weekend',1),(180,'2013-06-29','Sat',' ',0),(181,'2013-06-30','Sun',' ',0),(182,'2013-07-01','Mon',' ',0),(183,'2013-07-02','Tue',' ',0),(184,'2013-07-03','Wed',' ',0),(185,'2013-07-04','Thu',' ',0),(186,'2013-07-05','Fri','Weekend',1),(187,'2013-07-06','Sat',' ',0),(188,'2013-07-07','Sun',' ',0),(189,'2013-07-08','Mon',' ',0),(190,'2013-07-09','Tue',' ',0),(191,'2013-07-10','Wed',' ',0),(192,'2013-07-11','Thu',' ',0),(193,'2013-07-12','Fri','Weekend',1),(194,'2013-07-13','Sat',' ',0),(195,'2013-07-14','Sun',' ',0),(196,'2013-07-15','Mon',' ',0),(197,'2013-07-16','Tue',' ',0),(198,'2013-07-17','Wed',' ',0),(199,'2013-07-18','Thu',' ',0),(200,'2013-07-19','Fri','Weekend',1),(201,'2013-07-20','Sat',' ',0),(202,'2013-07-21','Sun',' ',0),(203,'2013-07-22','Mon',' ',0),(204,'2013-07-23','Tue',' ',0),(205,'2013-07-24','Wed',' ',0),(206,'2013-07-25','Thu',' ',0),(207,'2013-07-26','Fri','Weekend',1),(208,'2013-07-27','Sat',' ',0),(209,'2013-07-28','Sun',' ',0),(210,'2013-07-29','Mon',' ',0),(211,'2013-07-30','Tue',' ',0),(212,'2013-07-31','Wed',' ',0),(213,'2013-08-01','Thu',' ',0),(214,'2013-08-02','Fri','Weekend',1),(215,'2013-08-03','Sat',' ',0),(216,'2013-08-04','Sun',' ',0),(217,'2013-08-05','Mon',' ',0),(218,'2013-08-06','Tue',' ',0),(219,'2013-08-07','Wed',' ',0),(220,'2013-08-08','Thu',' ',0),(221,'2013-08-09','Fri','Weekend',1),(222,'2013-08-10','Sat',' ',0),(223,'2013-08-11','Sun',' ',0),(224,'2013-08-12','Mon',' ',0),(225,'2013-08-13','Tue',' ',0),(226,'2013-08-14','Wed',' ',0),(227,'2013-08-15','Thu',' ',0),(228,'2013-08-16','Fri','Weekend',1),(229,'2013-08-17','Sat',' ',0),(230,'2013-08-18','Sun',' ',0),(231,'2013-08-19','Mon',' ',0),(232,'2013-08-20','Tue',' ',0),(233,'2013-08-21','Wed',' ',0),(234,'2013-08-22','Thu',' ',0),(235,'2013-08-23','Fri','Weekend',1),(236,'2013-08-24','Sat',' ',0),(237,'2013-08-25','Sun',' ',0),(238,'2013-08-26','Mon',' ',0),(239,'2013-08-27','Tue',' ',0),(240,'2013-08-28','Wed',' ',0),(241,'2013-08-29','Thu',' ',0),(242,'2013-08-30','Fri','Weekend',1),(243,'2013-08-31','Sat',' ',0),(244,'2013-09-01','Sun',' ',0),(245,'2013-09-02','Mon',' ',0),(246,'2013-09-03','Tue',' ',0),(247,'2013-09-04','Wed',' ',0),(248,'2013-09-05','Thu',' ',0),(249,'2013-09-06','Fri','Weekend',1),(250,'2013-09-07','Sat',' ',0),(251,'2013-09-08','Sun',' ',0),(252,'2013-09-09','Mon',' ',0),(253,'2013-09-10','Tue',' ',0),(254,'2013-09-11','Wed',' ',0),(255,'2013-09-12','Thu',' ',0),(256,'2013-09-13','Fri','Weekend',1),(257,'2013-09-14','Sat',' ',0),(258,'2013-09-15','Sun',' ',0),(259,'2013-09-16','Mon',' ',0),(260,'2013-09-17','Tue',' ',0),(261,'2013-09-18','Wed',' ',0),(262,'2013-09-19','Thu',' ',0),(263,'2013-09-20','Fri','Weekend',1),(264,'2013-09-21','Sat',' ',0),(265,'2013-09-22','Sun',' ',0),(266,'2013-09-23','Mon',' ',0),(267,'2013-09-24','Tue',' ',0),(268,'2013-09-25','Wed',' ',0),(269,'2013-09-26','Thu',' ',0),(270,'2013-09-27','Fri','Weekend',1),(271,'2013-09-28','Sat',' ',0),(272,'2013-09-29','Sun',' ',0),(273,'2013-09-30','Mon',' ',0),(274,'2013-10-01','Tue',' ',0),(275,'2013-10-02','Wed',' ',0),(276,'2013-10-03','Thu',' ',0),(277,'2013-10-04','Fri','Weekend',1),(278,'2013-10-05','Sat',' ',0),(279,'2013-10-06','Sun',' ',0),(280,'2013-10-07','Mon',' ',0),(281,'2013-10-08','Tue',' ',0),(282,'2013-10-09','Wed',' ',0),(283,'2013-10-10','Thu','',0),(284,'2013-10-11','Fri','Weekend',1),(285,'2013-10-12','Sat',' ',0),(286,'2013-10-13','Sun',' ',0),(287,'2013-10-14','Mon',' ',0),(288,'2013-10-15','Tue',' ',0),(289,'2013-10-16','Wed',' ',0),(290,'2013-10-17','Thu',' ',0),(291,'2013-10-18','Fri','Weekend',1),(292,'2013-10-19','Sat',' ',0),(293,'2013-10-20','Sun',' ',0),(294,'2013-10-21','Mon',' ',0),(295,'2013-10-22','Tue',' ',0),(296,'2013-10-23','Wed',' ',0),(297,'2013-10-24','Thu',' ',0),(298,'2013-10-25','Fri','Weekend',1),(299,'2013-10-26','Sat',' ',0),(300,'2013-10-27','Sun',' ',0),(301,'2013-10-28','Mon',' ',0),(302,'2013-10-29','Tue',' ',0),(303,'2013-10-30','Wed',' ',0),(304,'2013-10-31','Thu',' ',0),(305,'2013-11-01','Fri','Weekend',1),(306,'2013-11-02','Sat',' ',0),(307,'2013-11-03','Sun',' ',0),(308,'2013-11-04','Mon',' ',0),(309,'2013-11-05','Tue',' ',0),(310,'2013-11-06','Wed',' ',0),(311,'2013-11-07','Thu',' ',0),(312,'2013-11-08','Fri','Weekend',1),(313,'2013-11-09','Sat',' ',0),(314,'2013-11-10','Sun',' ',0),(315,'2013-11-11','Mon',' ',0),(316,'2013-11-12','Tue',' ',0),(317,'2013-11-13','Wed',' ',0),(318,'2013-11-14','Thu',' ',0),(319,'2013-11-15','Fri','Weekend',1),(320,'2013-11-16','Sat',' ',0),(321,'2013-11-17','Sun',' ',0),(322,'2013-11-18','Mon',' ',0),(323,'2013-11-19','Tue',' ',0),(324,'2013-11-20','Wed',' ',0),(325,'2013-11-21','Thu',' ',0),(326,'2013-11-22','Fri','Weekend',1),(327,'2013-11-23','Sat',' ',0),(328,'2013-11-24','Sun',' ',0),(329,'2013-11-25','Mon',' ',0),(330,'2013-11-26','Tue',' ',0),(331,'2013-11-27','Wed',' ',0),(332,'2013-11-28','Thu',' ',0),(333,'2013-11-29','Fri','Weekend',1),(334,'2013-11-30','Sat',' ',0),(335,'2013-12-01','Sun',' ',0),(336,'2013-12-02','Mon',' ',0),(337,'2013-12-03','Tue',' ',0),(338,'2013-12-04','Wed',' ',0),(339,'2013-12-05','Thu',' ',0),(340,'2013-12-06','Fri','Weekend',1),(341,'2013-12-07','Sat',' ',0),(342,'2013-12-08','Sun',' ',0),(343,'2013-12-09','Mon',' ',0),(344,'2013-12-10','Tue',' ',0),(345,'2013-12-11','Wed',' ',0),(346,'2013-12-12','Thu',' ',0),(347,'2013-12-13','Fri','Weekend',1),(348,'2013-12-14','Sat',' ',0),(349,'2013-12-15','Sun',' ',0),(350,'2013-12-16','Mon','Victory Day',1),(351,'2013-12-17','Tue',' ',0),(352,'2013-12-18','Wed',' ',0),(353,'2013-12-19','Thu',' ',0),(354,'2013-12-20','Fri','Weekend',1),(355,'2013-12-21','Sat',' ',0),(356,'2013-12-22','Sun',' ',0),(357,'2013-12-23','Mon',' ',0),(358,'2013-12-24','Tue',' ',0),(359,'2013-12-25','Wed',' ',0),(360,'2013-12-26','Thu',' ',0),(361,'2013-12-27','Fri','Weekend',1),(362,'2013-12-28','Sat',' ',0),(363,'2013-12-29','Sun',' ',0),(364,'2013-12-30','Mon',' ',0),(365,'2013-12-31','Tue',' ',0);

/*Table structure for table `tbl_class_exam_mark_distribution` */

DROP TABLE IF EXISTS `tbl_class_exam_mark_distribution`;

CREATE TABLE `tbl_class_exam_mark_distribution` (
  `id` int(10) NOT NULL auto_increment,
  `class_id` int(10) default NULL,
  `OB_total` decimal(10,2) default NULL,
  `SB_total` decimal(10,2) default NULL,
  `CT_total` decimal(10,2) default NULL,
  `branch_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `tbl_class_exam_mark_distribution` */

/*Table structure for table `tbl_class_fee_info` */

DROP TABLE IF EXISTS `tbl_class_fee_info`;

CREATE TABLE `tbl_class_fee_info` (
  `id` int(20) NOT NULL auto_increment,
  `class_id` int(20) NOT NULL,
  `fee_head_id` int(10) NOT NULL,
  `amount` int(20) default NULL,
  `branch_id` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=82 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

/*Data for the table `tbl_class_fee_info` */

insert  into `tbl_class_fee_info`(`id`,`class_id`,`fee_head_id`,`amount`,`branch_id`) values (1,1,1,50,1),(2,2,1,100,1),(3,3,1,0,1),(4,4,1,0,1),(5,1,2,40,1),(6,2,2,200,1),(7,3,2,0,1),(8,4,2,0,1),(9,1,3,40,1),(10,2,3,0,1),(11,3,3,0,1),(12,4,3,0,1),(13,1,4,30,1),(14,2,4,0,1),(15,3,4,0,1),(16,4,4,0,1),(17,1,5,20,1),(18,2,5,0,1),(19,3,5,0,1),(20,4,5,0,1),(21,1,6,0,1),(22,2,6,0,1),(23,3,6,0,1),(24,4,6,0,1),(25,5,1,300,1),(26,5,2,0,1),(27,5,3,100,1),(28,5,4,0,1),(29,5,5,0,1),(30,5,6,0,1),(31,1,7,0,1),(32,2,7,0,1),(33,3,7,0,1),(34,4,7,0,1),(35,5,7,500,1),(73,1,8,10,1),(37,2,8,0,1),(38,3,8,0,1),(39,4,8,0,1),(40,5,8,0,1),(41,6,1,0,1),(42,6,2,0,1),(43,6,3,0,1),(44,6,4,0,1),(45,6,5,0,1),(46,6,6,0,1),(48,6,8,0,1),(49,7,1,0,1),(50,7,2,0,1),(51,7,3,0,1),(52,7,4,0,1),(53,7,5,0,1),(54,7,6,0,1),(55,7,7,0,1),(56,7,8,0,1),(57,8,1,0,1),(58,8,2,0,1),(59,8,3,0,1),(60,8,4,0,1),(61,8,5,0,1),(62,8,6,0,1),(63,8,7,0,1),(64,8,8,0,1),(65,9,1,0,1),(66,9,2,0,1),(67,9,3,0,1),(68,9,4,0,1),(69,9,5,0,1),(70,9,6,0,1),(71,9,7,0,1),(72,9,8,0,1),(74,10,1,0,1),(75,10,2,0,1),(76,10,3,0,1),(77,10,4,0,1),(78,10,5,0,1),(79,10,6,0,1),(80,10,7,0,1),(81,10,8,0,1);

/*Table structure for table `tbl_class_feehead` */

DROP TABLE IF EXISTS `tbl_class_feehead`;

CREATE TABLE `tbl_class_feehead` (
  `id` int(20) NOT NULL auto_increment,
  `fee_head` varchar(25) collate latin1_general_ci NOT NULL,
  `category` varchar(25) collate latin1_general_ci default NULL,
  `branch_id` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

/*Data for the table `tbl_class_feehead` */

insert  into `tbl_class_feehead`(`id`,`fee_head`,`category`,`branch_id`) values (1,'Admission','Fixed',1),(2,'Transport','Fixed',1),(3,'Exam','Fixed',1),(4,'Hostel','Fixed',1),(5,'Tifin','Fixed',1),(6,'library','Fixed',1),(7,'Tution ','Fixed',1),(8,'ertr','Fixed',1);

/*Table structure for table `tbl_destination` */

DROP TABLE IF EXISTS `tbl_destination`;

CREATE TABLE `tbl_destination` (
  `id` int(10) NOT NULL auto_increment,
  `destination` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

/*Data for the table `tbl_destination` */

insert  into `tbl_destination`(`id`,`destination`) values (1,'Dhaka'),(2,'Rajshahi'),(3,'Chittagong'),(4,'Khulna'),(5,'Jessore'),(6,'Khulna'),(7,'Rangpur'),(8,'Pabna');

/*Table structure for table `tbl_emp_salary_sturcture` */

DROP TABLE IF EXISTS `tbl_emp_salary_sturcture`;

CREATE TABLE `tbl_emp_salary_sturcture` (
  `empid` bigint(14) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `category` varchar(40) NOT NULL,
  `basic` decimal(10,2) NOT NULL,
  `medical` decimal(10,2) default NULL,
  `house_rent` decimal(10,2) default NULL,
  `others` decimal(10,2) default NULL,
  `branchid` int(10) NOT NULL,
  `update_date` date default NULL,
  `join_date` date default NULL,
  `address` varchar(80) default NULL,
  `mobileno` varchar(20) default NULL,
  PRIMARY KEY  (`empid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `tbl_emp_salary_sturcture` */

insert  into `tbl_emp_salary_sturcture`(`empid`,`name`,`category`,`basic`,`medical`,`house_rent`,`others`,`branchid`,`update_date`,`join_date`,`address`,`mobileno`) values (1,'hkkhkhkhk','Employee','4500.00','500.00','1200.00','120.00',1,'2013-03-15','2013-03-15','Dhaka','13165416416441'),(2,'Halima','Employee','2500.00','400.00','1000.00','100.00',1,'2013-03-15','2013-03-15','Dhaka','1313131313');

/*Table structure for table `tbl_grade_setting` */

DROP TABLE IF EXISTS `tbl_grade_setting`;

CREATE TABLE `tbl_grade_setting` (
  `id` int(10) NOT NULL auto_increment,
  `grade` varchar(5) default NULL,
  `mark_start` int(10) default NULL,
  `mark_end` int(10) default NULL,
  `point` decimal(10,2) default NULL,
  `branchid` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

/*Data for the table `tbl_grade_setting` */

insert  into `tbl_grade_setting`(`id`,`grade`,`mark_start`,`mark_end`,`point`,`branchid`) values (1,'A+',80,100,'5.00',1),(2,'A',75,79,'4.50',1),(3,'A-',70,74,'4.00',1),(4,'B+',65,69,'3.50',1),(5,'B',60,64,'3.25',1),(6,'B-',55,59,'3.00',1),(7,'C+',50,54,'2.50',1),(8,'C',45,49,'2.25',1),(9,'C-',40,44,'2.00',1),(10,'D',35,39,'1.00',1),(11,'F',0,34,'0.00',1);

/*Table structure for table `tbl_menu_group` */

DROP TABLE IF EXISTS `tbl_menu_group`;

CREATE TABLE `tbl_menu_group` (
  `id` int(10) NOT NULL auto_increment,
  `user_type` varchar(40) default NULL,
  `user_name` varchar(30) default NULL,
  `user_pass` varchar(30) default NULL,
  `main_menu_id` text,
  `sub_menu1` text,
  `sub_menu2` text,
  `branch_id` text,
  `class_id` text,
  `subject_id` text,
  `others` text,
  `regdate` date default NULL,
  `reg_expire_date` date default NULL,
  `access_permission` varchar(50) default NULL,
  `module_permission` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `tbl_menu_group` */

insert  into `tbl_menu_group`(`id`,`user_type`,`user_name`,`user_pass`,`main_menu_id`,`sub_menu1`,`sub_menu2`,`branch_id`,`class_id`,`subject_id`,`others`,`regdate`,`reg_expire_date`,`access_permission`,`module_permission`) values (1,'user','school','school321','1,2,3,4,5,6,9,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,37,38,39,40,41,44,45,46','1,2,3,4,5,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100','4,5,6,8,9,10,13,14,15,16,17,19,22,23,24,25,26,27,28,30,31,32,33,34,35,36,37,38,39,40,41,43,44,45,46,47,48','1,2,3,4,5','1,2,3,11','1,2,3,4,5,6,7',NULL,'2012-08-14','2014-12-05','on','1,2,3,4,5,6,8'),(2,'siteadmin','admin','123456','1,2,3,4,5,6,7','1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18','4,5,6,8,9,10,13,14,15,16,17,19,22,23,24,25,26,27,28,30,31','1,2,3,4,5','1,2,3,11','1,2,3,4,5,6,7',NULL,'2012-08-14','2014-11-19','on','1,2,3,4,6'),(3,'user','alamin','alamin','1,2,3,4,5,6,9,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,37,38,39,40,41,44,45','1,2,3,4,5,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100','4,5,6,8,9,10,13,14,15,16,17,19,22,23,24,25,26,27,28,30,31,32,33,34,35,36,37,38,39,40,41,43,44,45,46,47,48','1,2,3,4,5',NULL,NULL,NULL,'2012-08-14','2014-12-05','on','1,2,3,4,5,6,8'),(4,NULL,'afza','afza',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2013-05-14','2013-05-24',NULL,NULL);

/*Table structure for table `tbl_modules` */

DROP TABLE IF EXISTS `tbl_modules`;

CREATE TABLE `tbl_modules` (
  `id` int(10) NOT NULL auto_increment,
  `folder_name` varchar(100) NOT NULL,
  `module_name` varchar(100) NOT NULL,
  `order_id` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Data for the table `tbl_modules` */

insert  into `tbl_modules`(`id`,`folder_name`,`module_name`,`order_id`) values (1,'student','student',1),(2,'teacher','teacher',2),(3,'accounts','accounts',3),(4,'exam','exam',4),(5,'admin','admin',8),(6,'transport','transport',5),(7,'library','library',6);

/*Table structure for table `tbl_notices` */

DROP TABLE IF EXISTS `tbl_notices`;

CREATE TABLE `tbl_notices` (
  `id` int(10) NOT NULL auto_increment,
  `title` varchar(150) default NULL,
  `notice_date` date default NULL,
  `url` varchar(150) default NULL,
  `branch_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

/*Data for the table `tbl_notices` */

insert  into `tbl_notices`(`id`,`title`,`notice_date`,`url`,`branch_id`) values (1,'Test','2013-03-10','purer2_5418_01_en13-126686.gif',1),(2,'Holiday Notice','2013-03-10','semicon_2013.jpg',1),(3,'Janina','2013-03-15','Penguins.jpg',1);

/*Table structure for table `tbl_scholarship_info` */

DROP TABLE IF EXISTS `tbl_scholarship_info`;

CREATE TABLE `tbl_scholarship_info` (
  `id` int(10) NOT NULL auto_increment,
  `class_id` int(10) default NULL,
  `scholarship_name` varchar(100) default NULL,
  `sponsored_by` varchar(100) default NULL,
  `amount` decimal(10,2) default NULL,
  `branch_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `tbl_scholarship_info` */

insert  into `tbl_scholarship_info`(`id`,`class_id`,`scholarship_name`,`sponsored_by`,`amount`,`branch_id`) values (1,1,'DBBL Scholarship','Dutch Bangla Bank','1200.00',1);

/*Table structure for table `tbl_sources` */

DROP TABLE IF EXISTS `tbl_sources`;

CREATE TABLE `tbl_sources` (
  `id` int(10) NOT NULL auto_increment,
  `source` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

/*Data for the table `tbl_sources` */

insert  into `tbl_sources`(`id`,`source`) values (1,'Dhaka'),(2,'Rajshahi'),(3,'Khulna'),(4,'Jessore'),(5,'Pabna'),(6,'Chittagong'),(7,'Cox-Bazar'),(8,'Rangpur');

/*Table structure for table `tbl_std_pictures` */

DROP TABLE IF EXISTS `tbl_std_pictures`;

CREATE TABLE `tbl_std_pictures` (
  `id` int(10) NOT NULL auto_increment,
  `stid` varchar(50) default NULL,
  `pic_name` varchar(120) default NULL,
  `status` int(1) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `tbl_std_pictures` */

/*Table structure for table `tbl_teacher_attendance_info` */

DROP TABLE IF EXISTS `tbl_teacher_attendance_info`;

CREATE TABLE `tbl_teacher_attendance_info` (
  `id` int(10) NOT NULL auto_increment,
  `teacher_id` int(10) default NULL,
  `month` date default NULL,
  `total_open` int(10) default NULL,
  `total_attend` int(10) default NULL,
  `total_absent` int(10) default NULL,
  `branch_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `tbl_teacher_attendance_info` */

insert  into `tbl_teacher_attendance_info`(`id`,`teacher_id`,`month`,`total_open`,`total_attend`,`total_absent`,`branch_id`) values (1,1,'2013-03-01',20,12,8,1);

/*Table structure for table `user_info` */

DROP TABLE IF EXISTS `user_info`;

CREATE TABLE `user_info` (
  `id` int(20) NOT NULL auto_increment,
  `username` varchar(150) default NULL,
  `pass` varchar(100) default NULL,
  `user_type` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `user_info` */

insert  into `user_info`(`id`,`username`,`pass`,`user_type`) values (1,'Admin','Admin','Admin');

/*Table structure for table `web_menu` */

DROP TABLE IF EXISTS `web_menu`;

CREATE TABLE `web_menu` (
  `menu_id` int(10) unsigned NOT NULL auto_increment,
  `menu_name` varchar(80) NOT NULL,
  `menu_content` varchar(80) NOT NULL,
  `sub_menu` varchar(10) default NULL,
  `order_id` int(11) NOT NULL,
  `user_type` varchar(200) NOT NULL,
  PRIMARY KEY  (`menu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

/*Data for the table `web_menu` */

insert  into `web_menu`(`menu_id`,`menu_name`,`menu_content`,`sub_menu`,`order_id`,`user_type`) values (1,'Home','index','yes',1,'globle'),(2,'About Us','about','yes',2,'globle'),(3,'Curriculum','curriculum','yes',3,'globle'),(4,'Order Forms','extra','',4,'globle'),(5,'Facilities','facilities','',5,'globle'),(12,'Admission','admission','yes',6,'globle'),(13,'Gallery','gallery',NULL,7,'globle'),(14,'News','news',NULL,8,'globle'),(15,'Careers','careers',NULL,9,'globle'),(16,'Contact Us','visit',NULL,10,'globle'),(17,'Profile','profile',NULL,11,'user'),(18,'Result Info','result_info',NULL,12,'user'),(19,'Notice','notice',NULL,13,'user'),(20,'Remarks','remarks',NULL,14,'user'),(21,'Achievement ','achievement ',NULL,15,'user'),(22,'History','history',NULL,16,'user'),(23,'Payment Info','payment_info',NULL,17,'user'),(24,'Due Amount','due_amount',NULL,18,'user');

/*Table structure for table `web_std_pictures` */

DROP TABLE IF EXISTS `web_std_pictures`;

CREATE TABLE `web_std_pictures` (
  `id` int(10) NOT NULL auto_increment,
  `stid` varchar(30) default NULL,
  `pic_name` varchar(120) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `web_std_pictures` */

/*Table structure for table `web_std_profile` */

DROP TABLE IF EXISTS `web_std_profile`;

CREATE TABLE `web_std_profile` (
  `id` int(100) NOT NULL auto_increment,
  `stu_id` varchar(100) default NULL,
  `password` varchar(50) default NULL,
  `name` varchar(160) default NULL,
  `father_name` varchar(160) default NULL,
  `mother_name` varchar(160) default NULL,
  `pre_address` text,
  `par_address` text,
  `home_phone` varchar(50) default NULL,
  `emer_name1` varchar(100) default NULL,
  `emer_mobile1` varchar(50) default NULL,
  `emer_name2` varchar(100) default NULL,
  `emer_mobile2` varchar(50) default NULL,
  `mail_add` varchar(100) default NULL,
  `sex` varchar(50) default NULL,
  `religion` varchar(200) default NULL,
  `nationality` varchar(200) default NULL,
  `age` varchar(100) default NULL,
  `adm_date` varchar(100) default NULL,
  `dob` date default NULL,
  `adm_class` varchar(100) default NULL,
  `adm_class_roll` varchar(100) default NULL,
  `adm_group` varchar(50) default NULL,
  `section` varchar(20) default NULL,
  `father_income` varchar(50) default NULL,
  `mother_income` varchar(50) default NULL,
  `father_profession` varchar(200) default NULL,
  `mother_profession` varchar(200) default NULL,
  `father_qualification` varchar(200) default NULL,
  `mother_qualification` varchar(200) default NULL,
  `father_work_phone` varchar(50) default NULL,
  `mother_work_phone` varchar(50) default NULL,
  `admission_fee` varchar(100) default NULL,
  `priv_schoole_name` varchar(200) default NULL,
  `priv_school_add` varchar(100) default NULL,
  `priv_school_class` varchar(100) default NULL,
  `priv_school_class_roll` varchar(20) default NULL,
  `priv_school_remarks` varchar(300) default NULL,
  `priv_school_result` varchar(20) default NULL,
  `present_class` varchar(50) default NULL,
  `present_class_roll` varchar(50) default NULL,
  `st_status` varchar(50) default NULL,
  `branch_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

/*Data for the table `web_std_profile` */

insert  into `web_std_profile`(`id`,`stu_id`,`password`,`name`,`father_name`,`mother_name`,`pre_address`,`par_address`,`home_phone`,`emer_name1`,`emer_mobile1`,`emer_name2`,`emer_mobile2`,`mail_add`,`sex`,`religion`,`nationality`,`age`,`adm_date`,`dob`,`adm_class`,`adm_class_roll`,`adm_group`,`section`,`father_income`,`mother_income`,`father_profession`,`mother_profession`,`father_qualification`,`mother_qualification`,`father_work_phone`,`mother_work_phone`,`admission_fee`,`priv_schoole_name`,`priv_school_add`,`priv_school_class`,`priv_school_class_roll`,`priv_school_remarks`,`priv_school_result`,`present_class`,`present_class_roll`,`st_status`,`branch_id`) values (1,'201311','201311A10','Shahin','Hamid','fadf',NULL,'','45441','test','131131313','tetst','31313131','test@yahoo.com','Male',NULL,NULL,'10','2013-03-12','1985-10-10','Class-1',NULL,'','A','132131','512','dbusiness','fads',NULL,NULL,'231132','1212',NULL,'fadf','fad','1','1',NULL,'1',NULL,NULL,NULL,1),(2,'201311','201311B11','Mahin','fdaf','fdafa',NULL,'','44165416','teat','121213211','adffads','31313131313','teat@yaahooc.om','Male',NULL,NULL,'11','2013-03-10','1986-12-10','Class-1',NULL,'0','B','1231','531313','afd','fda',NULL,NULL,'4641313','4646',NULL,'fda','adfsa','1','1',NULL,'1',NULL,NULL,NULL,1),(3,'201312','201312B11','Faisal','fadsf','fadfds',NULL,'','321121','tafda','415411415454','fdafa','2313131','fda@yahoo.com','Male',NULL,NULL,'11','2013-03-12','1987-11-11','Class-1',NULL,'0','B','5241142','64416416','fads','fads',NULL,NULL,'364131','313131',NULL,'fdas','afdafds','1','1',NULL,'1',NULL,NULL,NULL,1),(4,'2013111','2013111A10','Shahin','teat','ffasdfa',NULL,'','54121212','test','131313133','testse','13165416464','test@yahoo.com','Male',NULL,NULL,'10','2013-03-12','1986-10-10','Class-1',NULL,'','A','13131','163446','fdafa','fdsa',NULL,NULL,'2121212','454545',NULL,'fadf','fadfda','1','1',NULL,'1',NULL,NULL,NULL,1),(5,'2013122','2013122B11','Faruk','fadfa','fadfa',NULL,'','1321212','fdafads','4165466','fadfas','63546464','afdasf@yahoo.com','Male',NULL,NULL,'11','2013-03-12','1986-11-10','Class-1',NULL,'0','B','646464','312323','fadf','fadfas',NULL,NULL,'32323','322323',NULL,'fdaf','fads','1','1',NULL,'1',NULL,NULL,NULL,1),(6,'2013123','2013123B11','Jahid','fdafa','fadfa',NULL,'','13136646','adfas','14143131313','fdafdasf','131313331','fdadfa@yahoo.com','Male',NULL,NULL,'11','2013-03-12','1987-10-11','Class-1',NULL,'0','B','13131','13131641','fda','fadfadf',NULL,NULL,'2326565979','6464614614',NULL,'fadfa','fdafa','1','1',NULL,'1',NULL,NULL,NULL,1),(7,'2013114','2013114A12','Sujan','fdad','fdaafa',NULL,'','1313131313','tesat','12314564545','tetaes','16464646946','fafd@yahoo.com','Male',NULL,NULL,'12','2013-03-02','1985-10-10','Class-1',NULL,'0','A','12121212','21121212','fdfads','fadsf',NULL,NULL,'212121','152121212',NULL,'fdadfas','fadsfas','1','1',NULL,'1',NULL,NULL,NULL,1),(8,'2013115','2013115A12','Hasan','fafa','dafasf',NULL,'','13131313','teate','132131313','test','1321545','test@yahoo.com','Male',NULL,NULL,'12','2013-03-12','1985-10-10','Class-1',NULL,'0','A','132131313','1313','fdafa','fdafas',NULL,NULL,'213111313','13323',NULL,'fadfas','fasfdas','1','1',NULL,'1',NULL,NULL,NULL,1),(9,'2013126','2013126B12','Ahsan','fadfa','fafda',NULL,'','122122','teat','1313131','teata','143646541641','fdafs@yahoo.com','Male',NULL,NULL,'12','2013-03-12','1986-12-11','Class-1',NULL,'0','B','1213213','2121212','fadsf','fadfa',NULL,NULL,'1231212','121212',NULL,'fadfa','fadfdas','1','1',NULL,'1',NULL,NULL,NULL,1),(10,'2013127','2013127B11','Tanin','dfafa','fdadf',NULL,'','12122','dafadsf','31313113','fadfas','212155512','fadfas@gmail.com','Male',NULL,NULL,'11','2013-02-11','1987-01-12','Class-1',NULL,'0','B','13131','3323','fads','fdas',NULL,NULL,'131313','121212',NULL,'fadfas','fdas','1','1',NULL,'2',NULL,NULL,NULL,1),(11,'2013118','2013118A11','Himel','fadfas','fadsfass',NULL,'','213233','dfafas','1313131313','fadfas','1251354551212','fadsf@yahoo.com','Male',NULL,NULL,'11','2013-03-12','1987-10-11','Class-1',NULL,'0','A','1131312','2133123','fda','fdafa',NULL,NULL,'322133','21212122',NULL,'fadfas','fads','1','1',NULL,'1',NULL,NULL,NULL,1),(12,'2013119','2013119A11','Urmi','topu','nima',NULL,'','321121','urmi','1313131','urmi','13131313','urmi@yahoo.com','Female',NULL,NULL,'11','2013-03-12','1985-02-10','Class-1',NULL,'0','A','1313131','1212113','business','housewife',NULL,NULL,'121212','31321212',NULL,'abc','dhaka','1','1',NULL,'1',NULL,NULL,NULL,1),(13,'20131110','20131110A11','Urmi','topu','nima',NULL,'','321121','urmi','1313131','urmi','13131313','urmi@yahoo.com','Female',NULL,NULL,'11','2013-03-12','1985-02-10','Class-1',NULL,'0','A','1313131','1212113','business','housewife',NULL,NULL,'121212','31321212',NULL,'abc','dhaka','1','1',NULL,'1',NULL,NULL,NULL,1),(14,'20135711','20135711A7','brinto','dulal','',NULL,'','245245425425','','','','','','Male',NULL,NULL,'7','2013-03-02','2001-01-03','class-5',NULL,'','A','','','','',NULL,NULL,'23434','',NULL,'','','','',NULL,'',NULL,NULL,NULL,1),(15,'20131112','20131112A7','tomal','','',NULL,'','','','','','','','Male',NULL,NULL,'7','2013-02-09','2007-04-18','Class-1',NULL,'','A','','','','',NULL,NULL,'326254363','',NULL,'','','','',NULL,'',NULL,NULL,NULL,1),(16,'2013111','2013111A10','Hasan','Halim','Helina',NULL,'','131313131','','','','','','Male',NULL,NULL,'10','2013-03-16','1988-07-14','Class-1',NULL,'','A','232323','131313','Business','Housewife',NULL,NULL,'131313131','213131313',NULL,'abc','dhaka','1','1',NULL,'1',NULL,NULL,NULL,1),(17,'2013122','2013122B10','Test','abal','fdafas',NULL,'','131313131331','','','','','','Male',NULL,NULL,'10','2013-03-10','1988-10-10','Class-1',NULL,'','B','2121212','13131','fadfa','fad',NULL,NULL,'1211231313','131333',NULL,'abc','daldajfa','1','1',NULL,'1',NULL,NULL,NULL,1);

/*Table structure for table `web_sub_menu1` */

DROP TABLE IF EXISTS `web_sub_menu1`;

CREATE TABLE `web_sub_menu1` (
  `sub_menu_id` int(11) NOT NULL auto_increment,
  `sub_menu_name` varchar(80) NOT NULL,
  `main_menu_id` int(11) NOT NULL,
  `sub_menu_content` varchar(80) NOT NULL,
  `sub1_sub_menu` varchar(10) NOT NULL,
  `_show` int(1) NOT NULL,
  PRIMARY KEY  (`sub_menu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

/*Data for the table `web_sub_menu1` */

insert  into `web_sub_menu1`(`sub_menu_id`,`sub_menu_name`,`main_menu_id`,`sub_menu_content`,`sub1_sub_menu`,`_show`) values (1,'Principal\'s Message',2,'principal_message','yes',1),(2,'Mission and Vision',2,'mission_vision','yes',1),(13,'Why US',2,'why_us','',1),(14,'School Policies',2,'school_policies','',1),(16,'Our Team',2,'our_team','',1),(17,'Head of Junior School',2,'head_junior_school','',1),(22,'Head of Middle School',2,'head_middle_school','',1),(23,'Head of Senior School',2,'head_senior_school','',1),(24,'Head of Arabic Department',2,'head_arabic_department','',1),(25,'AIS Mothers\' Group',2,'ais_mothers_group','',0),(26,'Early Learning Center (ELC)',3,'early_learning_center','',1),(27,'Junior School Curriculum',3,'junior_school_curriculum','',1),(28,'Middle School Curriculum',3,'middle_school_curriculum','',1),(29,'Senior School Curriculum',3,'senior_school_curriculum','',1),(30,'SHIP Program',3,'ship_program','',1),(31,'Performing Arts',3,'performing_arts','',1),(32,'French at AIS',3,'french_ais','',0),(33,'Camps and Excursions',3,'camps_excursions','',1),(34,'ESL Support Program at AIS',3,'esl_support_program','',0),(35,'Canteen',4,'canteen','',1),(36,'Stationery List',4,'stationery_list','',1),(37,'Uniform Order Forms',4,'uniform_order_forms','',1),(38,'Outdoor Areas',5,'outdoor_areas','',1),(39,'Computer Lab',5,'computer_lab','',1),(40,'Science Labs',5,'science_labs','',1),(41,'Music Room',5,'music_room','',1),(42,'Conference Room',5,'conference_room','',1),(43,'Swimming Pool',5,'swimming_pool','',1),(44,'Gymnasium',5,'gymnasium','',1),(45,'Library',5,'library','',1),(46,'Medical Clinic',5,'medical_clinic','',1),(47,'Transportation',5,'transportation','',1),(48,'Enrollment procedures and process',12,'enrollment_procedures_process','',1),(49,'Download forms',12,'download_forms','',1),(50,'Photos Album',13,'gallery','',1),(51,'Video Album',13,'gallery','',1),(52,'Photo Archive',13,'gallery','',1),(53,'Events Calender- 2012- 2013',14,'events_calende','',1),(54,'NEWSLETTER PRAISE',14,'newsletter_praise','',1),(55,'Celebrates National Day',14,'celebrates_national_day','',1),(56,'welcomes the new staff',14,'welcomes_new_staff','',1),(57,'Indoor Soccer Academy',14,'indoor_soccer_academy','',1),(58,'FLASH MOB',14,'flash_mob','',1),(59,'Code of conduct',15,'careers','',1),(60,'Apply Online',15,'apply_online','',1),(61,'Current Opening',15,'current_opening','',1),(62,' Contact Us',16,'visit','',1),(63,'Location map',16,'location_map','',1);

/*Table structure for table `web_sub_menu2` */

DROP TABLE IF EXISTS `web_sub_menu2`;

CREATE TABLE `web_sub_menu2` (
  `sub_menu2_id` int(10) unsigned NOT NULL auto_increment,
  `menu_name2` varchar(80) default NULL,
  `sub_menu1_id` int(11) NOT NULL,
  `menu_content` varchar(80) default NULL,
  PRIMARY KEY  (`sub_menu2_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `web_sub_menu2` */

/*Table structure for table `web_user_acl` */

DROP TABLE IF EXISTS `web_user_acl`;

CREATE TABLE `web_user_acl` (
  `user_id` int(10) unsigned NOT NULL auto_increment,
  `user_name` varchar(80) default NULL,
  `full_name` varchar(80) NOT NULL,
  `password` varchar(80) default NULL,
  `user_type` varchar(40) default NULL,
  `user_group_id` int(10) default NULL,
  `created_by` varchar(80) NOT NULL,
  `user_create_time` varchar(80) default NULL,
  `main_menu` varchar(80) default NULL,
  `sub_menu1` varchar(80) default NULL,
  `sub_menu2` varchar(80) default NULL,
  `pos_id` int(10) default NULL,
  `member_id` int(10) default NULL,
  `founder_id` int(10) default NULL,
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `user_name` (`user_name`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

/*Data for the table `web_user_acl` */

insert  into `web_user_acl`(`user_id`,`user_name`,`full_name`,`password`,`user_type`,`user_group_id`,`created_by`,`user_create_time`,`main_menu`,`sub_menu1`,`sub_menu2`,`pos_id`,`member_id`,`founder_id`) values (32,'admin','','admin','admin',2,'',NULL,NULL,NULL,NULL,2,NULL,NULL);

/*Table structure for table `web_user_info` */

DROP TABLE IF EXISTS `web_user_info`;

CREATE TABLE `web_user_info` (
  `user_id` int(10) unsigned NOT NULL auto_increment,
  `user_name` varchar(80) default NULL,
  `full_name` varchar(80) NOT NULL,
  `password` varchar(80) default NULL,
  `user_type` varchar(40) default NULL,
  `created_by` varchar(80) NOT NULL,
  `user_create_time` varchar(80) default NULL,
  `main_menu` varchar(80) default NULL,
  `sub_menu1` varchar(80) default NULL,
  `sub_menu2` varchar(80) default NULL,
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `user_name` (`user_name`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

/*Data for the table `web_user_info` */

insert  into `web_user_info`(`user_id`,`user_name`,`full_name`,`password`,`user_type`,`created_by`,`user_create_time`,`main_menu`,`sub_menu1`,`sub_menu2`) values (1,'Admin','','admin@bn','super','admin','00:00:02','1,2,3,4,5,6','1,2,3,4,5,6,7,8,9,10',''),(2,'robi','','abc','client','admin',NULL,'1,4,5,6','3,6,7,8,9',NULL),(10,'kjk','ui','jk','Admin','Admin','09:29:48','1,6','1,2,3,4,5,6,7,8,9,10',NULL),(11,'nmnm','mnm','m','Normal user','Admin','20110911095827','1,2,3',NULL,NULL);

/*Table structure for table `web_user_log` */

DROP TABLE IF EXISTS `web_user_log`;

CREATE TABLE `web_user_log` (
  `serial_no` int(10) unsigned NOT NULL auto_increment,
  `user_name` varchar(80) NOT NULL,
  `user_id` int(11) NOT NULL,
  `login_time` varchar(80) NOT NULL,
  `login_ip` varchar(40) NOT NULL,
  `session_id` varchar(160) NOT NULL,
  `logout_time` varchar(80) default NULL,
  PRIMARY KEY  (`serial_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `web_user_log` */

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;