-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 22, 2015 at 09:07 PM
-- Server version: 5.5.8
-- PHP Version: 5.4.33

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `kanchkura`
--

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

--
-- Table structure for table `acos`
--

CREATE TABLE IF NOT EXISTS `acos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) DEFAULT NULL,
  `model` varchar(255) CHARACTER SET latin1 DEFAULT '',
  `foreign_key` int(10) unsigned DEFAULT NULL,
  `alias` varchar(255) CHARACTER SET latin1 DEFAULT '',
  `lft` int(10) DEFAULT NULL,
  `rght` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=205 ;

--
-- Dumping data for table `acos`
--

INSERT INTO `acos` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES
(1, NULL, NULL, NULL, 'controllers', 1, 408),
(2, 1, NULL, NULL, 'Afiliations', 2, 13),
(3, 2, NULL, NULL, 'admin_index', 3, 4),
(4, 2, NULL, NULL, 'admin_add', 5, 6),
(5, 2, NULL, NULL, 'admin_edit', 7, 8),
(6, 2, NULL, NULL, 'admin_delete', 9, 10),
(7, 2, NULL, NULL, 'removespace', 11, 12),
(8, 1, NULL, NULL, 'Applicantinformations', 14, 25),
(9, 8, NULL, NULL, 'add', 15, 16),
(10, 8, NULL, NULL, 'admin_index', 17, 18),
(11, 8, NULL, NULL, 'admin_view', 19, 20),
(12, 8, NULL, NULL, 'admin_delete', 21, 22),
(13, 8, NULL, NULL, 'removespace', 23, 24),
(14, 1, NULL, NULL, 'Banners', 26, 37),
(15, 14, NULL, NULL, 'admin_index', 27, 28),
(16, 14, NULL, NULL, 'admin_add', 29, 30),
(17, 14, NULL, NULL, 'admin_edit', 31, 32),
(18, 14, NULL, NULL, 'admin_delete', 33, 34),
(19, 14, NULL, NULL, 'removespace', 35, 36),
(20, 1, NULL, NULL, 'Careers', 38, 53),
(21, 20, NULL, NULL, 'index', 39, 40),
(22, 20, NULL, NULL, 'view', 41, 42),
(23, 20, NULL, NULL, 'admin_index', 43, 44),
(24, 20, NULL, NULL, 'admin_add', 45, 46),
(25, 20, NULL, NULL, 'admin_edit', 47, 48),
(26, 20, NULL, NULL, 'admin_delete', 49, 50),
(27, 20, NULL, NULL, 'removespace', 51, 52),
(28, 1, NULL, NULL, 'Categories', 54, 65),
(29, 28, NULL, NULL, 'admin_index', 55, 56),
(30, 28, NULL, NULL, 'admin_add', 57, 58),
(31, 28, NULL, NULL, 'admin_edit', 59, 60),
(32, 28, NULL, NULL, 'admin_delete', 61, 62),
(33, 28, NULL, NULL, 'removespace', 63, 64),
(34, 1, NULL, NULL, 'Contacts', 66, 77),
(35, 34, NULL, NULL, 'contactinfo', 67, 68),
(36, 34, NULL, NULL, 'savecontactinfo', 69, 70),
(37, 34, NULL, NULL, 'admin_index', 71, 72),
(38, 34, NULL, NULL, 'admin_delete', 73, 74),
(39, 34, NULL, NULL, 'removespace', 75, 76),
(40, 1, NULL, NULL, 'Contents', 78, 89),
(41, 40, NULL, NULL, 'admin_index', 79, 80),
(42, 40, NULL, NULL, 'admin_add', 81, 82),
(43, 40, NULL, NULL, 'admin_edit', 83, 84),
(44, 40, NULL, NULL, 'admin_delete', 85, 86),
(45, 40, NULL, NULL, 'removespace', 87, 88),
(46, 1, NULL, NULL, 'Courses', 90, 107),
(47, 46, NULL, NULL, 'index', 91, 92),
(48, 46, NULL, NULL, 'view', 93, 94),
(49, 46, NULL, NULL, 'admin_index', 95, 96),
(50, 46, NULL, NULL, 'admin_updateneworder', 97, 98),
(51, 46, NULL, NULL, 'admin_add', 99, 100),
(52, 46, NULL, NULL, 'admin_edit', 101, 102),
(53, 46, NULL, NULL, 'admin_delete', 103, 104),
(54, 46, NULL, NULL, 'removespace', 105, 106),
(55, 1, NULL, NULL, 'Downloads', 108, 135),
(56, 55, NULL, NULL, 'index', 109, 110),
(57, 55, NULL, NULL, 'download', 111, 112),
(58, 55, NULL, NULL, 'admin_index', 113, 114),
(59, 55, NULL, NULL, 'admin_add', 115, 116),
(60, 55, NULL, NULL, 'admin_lecindex', 117, 118),
(61, 55, NULL, NULL, 'admin_lecadd', 119, 120),
(62, 55, NULL, NULL, 'admin_updateneworder', 121, 122),
(63, 55, NULL, NULL, 'admin_delete', 123, 124),
(64, 55, NULL, NULL, 'admin_lecdelete', 125, 126),
(65, 55, NULL, NULL, 'removespace', 127, 128),
(66, 1, NULL, NULL, 'Faculties', 136, 153),
(67, 66, NULL, NULL, 'index', 137, 138),
(68, 66, NULL, NULL, 'view', 139, 140),
(69, 66, NULL, NULL, 'admin_updateneworder', 141, 142),
(70, 66, NULL, NULL, 'admin_index', 143, 144),
(71, 66, NULL, NULL, 'admin_add', 145, 146),
(72, 66, NULL, NULL, 'admin_edit', 147, 148),
(73, 66, NULL, NULL, 'admin_delete', 149, 150),
(74, 66, NULL, NULL, 'removespace', 151, 152),
(75, 1, NULL, NULL, 'Generalsettings', 154, 163),
(76, 75, NULL, NULL, 'admin_index', 155, 156),
(77, 75, NULL, NULL, 'admin_add', 157, 158),
(78, 75, NULL, NULL, 'admin_edit', 159, 160),
(79, 75, NULL, NULL, 'removespace', 161, 162),
(80, 1, NULL, NULL, 'Groups', 164, 175),
(81, 80, NULL, NULL, 'admin_index', 165, 166),
(82, 80, NULL, NULL, 'admin_add', 167, 168),
(83, 80, NULL, NULL, 'admin_edit', 169, 170),
(84, 80, NULL, NULL, 'admin_delete', 171, 172),
(85, 80, NULL, NULL, 'removespace', 173, 174),
(86, 1, NULL, NULL, 'Homes', 176, 193),
(87, 86, NULL, NULL, 'addsubscriberemail', 177, 178),
(88, 86, NULL, NULL, 'index', 179, 180),
(89, 86, NULL, NULL, 'getNotice', 181, 182),
(90, 86, NULL, NULL, 'getCourse', 183, 184),
(91, 86, NULL, NULL, 'admin_index', 185, 186),
(92, 86, NULL, NULL, 'removespace', 187, 188),
(93, 1, NULL, NULL, 'News', 194, 211),
(94, 93, NULL, NULL, 'index', 195, 196),
(95, 93, NULL, NULL, 'view', 197, 198),
(96, 93, NULL, NULL, 'admin_index', 199, 200),
(97, 93, NULL, NULL, 'admin_updateneworder', 201, 202),
(98, 93, NULL, NULL, 'admin_add', 203, 204),
(99, 93, NULL, NULL, 'admin_edit', 205, 206),
(100, 93, NULL, NULL, 'admin_delete', 207, 208),
(101, 93, NULL, NULL, 'removespace', 209, 210),
(102, 1, NULL, NULL, 'Notices', 212, 231),
(103, 102, NULL, NULL, 'index', 213, 214),
(104, 102, NULL, NULL, 'view', 215, 216),
(105, 102, NULL, NULL, 'download', 217, 218),
(106, 102, NULL, NULL, 'admin_index', 219, 220),
(107, 102, NULL, NULL, 'admin_updateneworder', 221, 222),
(108, 102, NULL, NULL, 'admin_add', 223, 224),
(109, 102, NULL, NULL, 'admin_edit', 225, 226),
(110, 102, NULL, NULL, 'admin_delete', 227, 228),
(111, 102, NULL, NULL, 'removespace', 229, 230),
(112, 1, NULL, NULL, 'Pages', 232, 237),
(113, 112, NULL, NULL, 'index', 233, 234),
(114, 112, NULL, NULL, 'removespace', 235, 236),
(115, 1, NULL, NULL, 'Payments', 238, 251),
(116, 115, NULL, NULL, 'admin_index', 239, 240),
(117, 115, NULL, NULL, 'admin_view', 241, 242),
(118, 115, NULL, NULL, 'admin_add', 243, 244),
(119, 115, NULL, NULL, 'admin_edit', 245, 246),
(120, 115, NULL, NULL, 'admin_delete', 247, 248),
(121, 115, NULL, NULL, 'removespace', 249, 250),
(122, 1, NULL, NULL, 'PhotoCategories', 252, 261),
(123, 122, NULL, NULL, 'admin_index', 253, 254),
(124, 122, NULL, NULL, 'admin_add', 255, 256),
(125, 122, NULL, NULL, 'admin_delete', 257, 258),
(126, 122, NULL, NULL, 'removespace', 259, 260),
(127, 1, NULL, NULL, 'PhotoGalleries', 262, 279),
(128, 127, NULL, NULL, 'index', 263, 264),
(129, 127, NULL, NULL, 'view', 265, 266),
(130, 127, NULL, NULL, 'admin_index', 267, 268),
(131, 127, NULL, NULL, 'admin_add', 269, 270),
(132, 127, NULL, NULL, 'admin_edit', 271, 272),
(133, 127, NULL, NULL, 'admin_activeinactive', 273, 274),
(134, 127, NULL, NULL, 'admin_delete', 275, 276),
(135, 127, NULL, NULL, 'removespace', 277, 278),
(136, 1, NULL, NULL, 'Results', 280, 291),
(137, 136, NULL, NULL, 'admin_index', 281, 282),
(138, 136, NULL, NULL, 'admin_add', 283, 284),
(139, 136, NULL, NULL, 'admin_edit', 285, 286),
(140, 136, NULL, NULL, 'admin_delete', 287, 288),
(141, 136, NULL, NULL, 'removespace', 289, 290),
(142, 1, NULL, NULL, 'Studentinformations', 292, 309),
(143, 142, NULL, NULL, 'logout', 293, 294),
(144, 142, NULL, NULL, 'view', 295, 296),
(145, 142, NULL, NULL, 'admin_index', 297, 298),
(146, 142, NULL, NULL, 'admin_view', 299, 300),
(147, 142, NULL, NULL, 'admin_edit', 301, 302),
(148, 142, NULL, NULL, 'admin_delete', 303, 304),
(149, 142, NULL, NULL, 'removespace', 305, 306),
(150, 1, NULL, NULL, 'Users', 310, 329),
(151, 150, NULL, NULL, 'setACL', 311, 312),
(152, 150, NULL, NULL, 'admin_logout', 313, 314),
(153, 150, NULL, NULL, 'admin_login', 315, 316),
(154, 150, NULL, NULL, 'admin_index', 317, 318),
(155, 150, NULL, NULL, 'admin_add', 319, 320),
(156, 150, NULL, NULL, 'admin_edit', 321, 322),
(157, 150, NULL, NULL, 'admin_delete', 323, 324),
(158, 150, NULL, NULL, 'admin_studentadd', 325, 326),
(159, 150, NULL, NULL, 'removespace', 327, 328),
(160, 1, NULL, NULL, 'AclExtras', 330, 331),
(161, 1, NULL, NULL, 'Messages', 332, 347),
(162, 161, NULL, NULL, 'view', 333, 334),
(163, 161, NULL, NULL, 'admin_index', 335, 336),
(164, 161, NULL, NULL, 'admin_updateneworder', 337, 338),
(165, 161, NULL, NULL, 'admin_add', 339, 340),
(166, 161, NULL, NULL, 'admin_edit', 341, 342),
(167, 161, NULL, NULL, 'admin_delete', 343, 344),
(168, 161, NULL, NULL, 'removespace', 345, 346),
(169, 1, NULL, NULL, 'Departments', 348, 359),
(170, 169, NULL, NULL, 'admin_index', 349, 350),
(171, 169, NULL, NULL, 'admin_add', 351, 352),
(172, 169, NULL, NULL, 'admin_edit', 353, 354),
(173, 169, NULL, NULL, 'admin_delete', 355, 356),
(174, 169, NULL, NULL, 'removespace', 357, 358),
(175, 1, NULL, NULL, 'Employes', 360, 375),
(176, 175, NULL, NULL, 'index', 361, 362),
(177, 175, NULL, NULL, 'admin_updateneworder', 363, 364),
(178, 175, NULL, NULL, 'admin_index', 365, 366),
(179, 175, NULL, NULL, 'admin_add', 367, 368),
(180, 175, NULL, NULL, 'admin_edit', 369, 370),
(181, 175, NULL, NULL, 'admin_delete', 371, 372),
(182, 175, NULL, NULL, 'removespace', 373, 374),
(183, 86, NULL, NULL, 'getDepartment', 189, 190),
(184, 86, NULL, NULL, 'getMessage', 191, 192),
(185, 1, NULL, NULL, 'Libraries', 376, 391),
(186, 185, NULL, NULL, 'index', 377, 378),
(187, 185, NULL, NULL, 'admin_updateneworder', 379, 380),
(188, 185, NULL, NULL, 'admin_index', 381, 382),
(189, 185, NULL, NULL, 'admin_add', 383, 384),
(190, 185, NULL, NULL, 'admin_edit', 385, 386),
(191, 185, NULL, NULL, 'admin_delete', 387, 388),
(192, 185, NULL, NULL, 'removespace', 389, 390),
(193, 1, NULL, NULL, 'Managements', 392, 407),
(194, 193, NULL, NULL, 'index', 393, 394),
(195, 193, NULL, NULL, 'admin_updateneworder', 395, 396),
(196, 193, NULL, NULL, 'admin_index', 397, 398),
(197, 193, NULL, NULL, 'admin_add', 399, 400),
(198, 193, NULL, NULL, 'admin_edit', 401, 402),
(199, 193, NULL, NULL, 'admin_delete', 403, 404),
(200, 193, NULL, NULL, 'removespace', 405, 406),
(201, 142, NULL, NULL, 'index', 307, 308),
(202, 55, NULL, NULL, 'admin_attindex', 129, 130),
(203, 55, NULL, NULL, 'admin_attadd', 131, 132),
(204, 55, NULL, NULL, 'admin_attdelete', 133, 134);

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

--
-- Table structure for table `afiliations`
--

CREATE TABLE IF NOT EXISTS `afiliations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `imagename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `isactive` tinyint(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `afiliations`
--


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

--
-- Table structure for table `applicanteducations`
--

CREATE TABLE IF NOT EXISTS `applicanteducations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `applicantinformation_id` int(11) NOT NULL,
  `nameofexam` varchar(255) NOT NULL,
  `result` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `institution_name` varchar(150) NOT NULL,
  `board` varchar(255) NOT NULL,
  `passingyear` varchar(50) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `applicanteducations`
--

INSERT INTO `applicanteducations` (`id`, `applicantinformation_id`, `nameofexam`, `result`, `subject`, `institution_name`, `board`, `passingyear`, `created`, `modified`) VALUES
(1, 1, 'Secondary or Equivalent', '3.88', 'Science', 'Dig', 'Dhaka', '2015', '2015-05-09 15:13:46', '2015-05-09 15:13:46'),
(2, 1, 'Higher Secondary or Equivalent', '4.5', 'Science', 'Dug', 'Dhaka', '2015', '2015-05-09 15:13:46', '2015-05-09 15:13:46');

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

--
-- Table structure for table `applicantinformations`
--

CREATE TABLE IF NOT EXISTS `applicantinformations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `studentname` varchar(255) DEFAULT NULL,
  `session` varchar(120) DEFAULT NULL,
  `batchno` varchar(120) DEFAULT NULL,
  `fathername` varchar(255) DEFAULT NULL,
  `mothername` varchar(255) DEFAULT NULL,
  `currentaddress` text,
  `permanentaddress` text,
  `dateofbirth` varchar(255) DEFAULT NULL,
  `religion` varchar(255) DEFAULT NULL,
  `nationality` varchar(255) DEFAULT NULL,
  `nationalid` varchar(255) DEFAULT NULL,
  `mobileno` varchar(40) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `phone` varchar(40) DEFAULT NULL,
  `parentmobileno` varchar(40) DEFAULT NULL,
  `parentoccupation` varchar(255) DEFAULT NULL,
  `bloodgroup` varchar(20) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `programname` varchar(255) DEFAULT NULL,
  `created` date NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `applicantinformations`
--

INSERT INTO `applicantinformations` (`id`, `studentname`, `session`, `batchno`, `fathername`, `mothername`, `currentaddress`, `permanentaddress`, `dateofbirth`, `religion`, `nationality`, `nationalid`, `mobileno`, `email`, `phone`, `parentmobileno`, `parentoccupation`, `bloodgroup`, `image`, `programname`, `created`, `modified`) VALUES
(1, 'Md. Nannu Mia', NULL, NULL, 'Mr. x', 'Mrs. y', 'Current Address', 'Permanent Address', '18-02-1986', 'Islam', 'Bng', '23654524653264', '324324324324', 'belal@uysys.com', '234234234', '535345345345', 'Business', 'a+', 'files/photo/1431184424_3129.jpg', 'Textile Bsc', '2015-05-09', '2015-05-09 15:13:46');

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

--
-- Table structure for table `aros`
--

CREATE TABLE IF NOT EXISTS `aros` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) DEFAULT NULL,
  `model` varchar(255) CHARACTER SET latin1 DEFAULT '',
  `foreign_key` int(10) unsigned DEFAULT NULL,
  `alias` varchar(255) CHARACTER SET latin1 DEFAULT '',
  `lft` int(10) DEFAULT NULL,
  `rght` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `aros`
--

INSERT INTO `aros` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES
(1, NULL, 'Group', 1, '', 1, 4),
(2, NULL, 'Group', 2, '', 5, 6),
(3, NULL, 'Group', 3, '', 7, 8),
(4, NULL, 'Group', 4, '', 9, 10),
(5, 1, 'User', 1, '', 2, 3);

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

--
-- Table structure for table `aros_acos`
--

CREATE TABLE IF NOT EXISTS `aros_acos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aro_id` int(10) unsigned NOT NULL,
  `aco_id` int(10) unsigned NOT NULL,
  `_create` char(2) CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `_read` char(2) CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `_update` char(2) CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `_delete` char(2) CHARACTER SET latin1 NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `aros_acos`
--

INSERT INTO `aros_acos` (`id`, `aro_id`, `aco_id`, `_create`, `_read`, `_update`, `_delete`) VALUES
(1, 1, 1, '1', '1', '1', '1'),
(2, 2, 1, '-1', '-1', '-1', '-1'),
(3, 2, 150, '1', '1', '1', '1'),
(4, 3, 1, '-1', '-1', '-1', '-1'),
(5, 3, 150, '1', '1', '1', '1'),
(6, 4, 1, '-1', '-1', '-1', '-1'),
(7, 4, 150, '1', '1', '1', '1');

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

--
-- Table structure for table `banners`
--

CREATE TABLE IF NOT EXISTS `banners` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `stitle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `isactive` tinyint(2) DEFAULT '1',
  `isdel` tinyint(2) DEFAULT NULL,
  `created` date DEFAULT NULL,
  `createdby` bigint(20) DEFAULT NULL,
  `modified` date DEFAULT NULL,
  `modifiedby` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `title`, `stitle`, `filename`, `isactive`, `isdel`, `created`, `createdby`, `modified`, `modifiedby`) VALUES
(4, 'কাঁচকুড়া বিশ্ববিদ্যালয় কলেজ', '', 'files/banner/1432061636_2835.jpg', 1, NULL, '2015-05-19', 1, '2015-05-19', NULL),
(2, 'কাঁচকুড়া বিশ্ববিদ্যালয় কলেজ', '', 'files/banner/1432061341_3588.jpg', 1, NULL, '2015-05-19', 1, '2015-05-19', NULL);

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

--
-- Table structure for table `careers`
--

CREATE TABLE IF NOT EXISTS `careers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `noofvacancy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `education` text COLLATE utf8_unicode_ci,
  `experience` text COLLATE utf8_unicode_ci,
  `salary` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `attach_file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` int(11) NOT NULL,
  `deadline` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `created` date NOT NULL,
  `modified` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `careers`
--

INSERT INTO `careers` (`id`, `title`, `noofvacancy`, `description`, `education`, `experience`, `salary`, `address`, `attach_file`, `isactive`, `deadline`, `created`, `modified`) VALUES
(3, 'Senior Lecturer at Textile Engineering Department.', '2', '<div class="jr_text_d" style="font-size: 12px;">\r\n<ul>\r\n<li>Involves hands-on expert level knowledge with ASP.NET MVC</li>\r\n<li>Requires a must knowledge on C#, JavaScript, JQuery and OOP</li>\r\n<li>Having depth knowledge in WEB API and AngularJS architecture, services, directives etc is preferable</li>\r\n<li>Strong Knowledge in Twitter bootstrap</li>\r\n<li>Requires day-to-day communication with foreign clients</li>\r\n<li>Track, monitor and report on projects</li>\r\n</ul>\r\n</div>', '<p>&nbsp;B.Sc in Computer Science/ CSE/ Any other related discipline from any reputed university. &nbsp;</p>', '<div class="exp_text_d" style="font-size: 12px;">\r\n<ul>\r\n<li>2 to 3 year(s)</li>\r\n<li>The applicants should have experience in the following area(s):<br />IT System Management, Database Administrator (DBA), Mobile apps developer, Programmer/Software Engineer, Web Developer/Web Designer</li>\r\n<li>The applicants should have experience in the following business area(s):<br />Buying House, Computer Hardware/Network Companies, Engineering Firms, Embassies/Foreign Consulate, Garments, Garments Accessories, Group of Companies, IT Enabled Service, ISP, Multinational Companies</li>\r\n</ul>\r\n</div>', 'Negotiable', '<p>&nbsp;Heights (2nd floor), 2/3, Iqbal Road, Block-A, Mirpur Road, Mohammadpur, Dhaka -1207.&nbsp;</p>', '', 1, '1433030400', '2015-05-09', '2015-05-16'),
(2, 'First Job', '2', '<div class="jr_text_d" style="font-size: 12px;">\r\n<ul>\r\n<li>Involves hands-on expert level knowledge with ASP.NET MVC</li>\r\n<li>Requires a must knowledge on C#, JavaScript, JQuery and OOP</li>\r\n<li>Having depth knowledge in WEB API and AngularJS architecture, services, directives etc is preferable</li>\r\n<li>Strong Knowledge in Twitter bootstrap</li>\r\n<li>Requires day-to-day communication with foreign clients</li>\r\n<li>Track, monitor and report on projects</li>\r\n</ul>\r\n</div>', '<p>&nbsp;B.Sc in Computer Science/ CSE/ Any other related discipline from any reputed university. &nbsp;</p>', '<div class="exp_text_d" style="font-size: 12px;">\r\n<ul>\r\n<li>2 to 3 year(s)</li>\r\n<li>The applicants should have experience in the following area(s):<br />IT System Management, Database Administrator (DBA), Mobile apps developer, Programmer/Software Engineer, Web Developer/Web Designer</li>\r\n<li>The applicants should have experience in the following business area(s):<br />Buying House, Computer Hardware/Network Companies, Engineering Firms, Embassies/Foreign Consulate, Garments, Garments Accessories, Group of Companies, IT Enabled Service, ISP, Multinational Companies</li>\r\n</ul>\r\n</div>', 'Negotiable', '<p>&nbsp;Heights (2nd floor), 2/3, Iqbal Road, Block-A, Mirpur Road, Mohammadpur, Dhaka -1207.&nbsp;</p>', 'files/career/1431167454_7183.jpg', 1, '1433030400', '2015-05-09', '2015-05-09');

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

--
-- Table structure for table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `isdel` tinyint(3) NOT NULL DEFAULT '0',
  `isactive` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `title`, `created`, `modified`, `isdel`, `isactive`) VALUES
(1, 'এইচএসসি(১ম বর্ষ)', '2015-05-20 19:11:41', '2015-05-20 19:11:41', 0, 1),
(2, 'এইচএসসি(২য় বর্ষ)', '2015-05-20 19:11:56', '2015-05-20 19:11:56', 0, 1),
(3, 'অনার্স (১ম বর্ষ)', '2015-05-20 19:12:10', '2015-05-20 19:12:10', 0, 1),
(4, 'অনার্স (২য় বর্ষ)', '2015-05-20 19:12:22', '2015-05-20 19:12:22', 0, 1),
(5, 'অনার্স (৩য় বর্ষ)', '2015-05-20 19:12:36', '2015-05-20 19:12:36', 0, 1),
(6, 'অনার্স (৪র্থ বর্ষ)', '2015-05-20 19:12:58', '2015-05-20 19:12:58', 0, 1),
(7, 'ডিগ্রি (১ম বর্ষ)', '2015-05-20 19:13:18', '2015-05-20 19:13:18', 0, 1),
(8, 'ডিগ্রি (২য় বর্ষ)', '2015-05-20 19:13:32', '2015-05-20 19:13:32', 0, 1),
(9, 'ডিগ্রি (৩য় বর্ষ)', '2015-05-20 19:13:44', '2015-05-20 19:13:44', 0, 1),
(10, 'ডিগ্রি (৪র্থ বর্ষ)', '2015-05-20 19:13:58', '2015-05-20 19:13:58', 0, 1);

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

--
-- Table structure for table `category_departments`
--

CREATE TABLE IF NOT EXISTS `category_departments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `department_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

--
-- Dumping data for table `category_departments`
--

INSERT INTO `category_departments` (`id`, `category_id`, `department_id`) VALUES
(1, 1, 1),
(2, 1, 2),
(3, 2, 1),
(4, 2, 2),
(5, 3, 1),
(6, 3, 2);

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

--
-- Table structure for table `contacts`
--

CREATE TABLE IF NOT EXISTS `contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `isactive` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `name`, `email`, `message`, `isactive`) VALUES
(2, 'Himel', 'himelbdf@gmail.com', 'Hi, This is Himel.', 1),
(3, 'Md. Belal Uddin', 'belal_duet@yahoo.com', 'test message', 1);

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

--
-- Table structure for table `contents`
--

CREATE TABLE IF NOT EXISTS `contents` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `pagename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pagenamebn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pagebody` blob,
  `pagealias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `isactive` tinyint(4) DEFAULT '1',
  `isdel` tinyint(4) DEFAULT '0',
  `created` date DEFAULT NULL,
  `createdby` bigint(20) DEFAULT NULL,
  `modified` date NOT NULL,
  `modifiedby` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;

--
-- Dumping data for table `contents`
--

INSERT INTO `contents` (`id`, `pagename`, `pagenamebn`, `pagebody`, `pagealias`, `meta_title`, `meta_keywords`, `meta_description`, `isactive`, `isdel`, `created`, `createdby`, `modified`, `modifiedby`) VALUES
(2, 'Infrastructure', 'ভৌত অবকাঠামো', 0x3c703e4865726520616c6c206f6620746865204247494654207465616368657273206c69737420776974682074686569722064657461696c732e20796f752063616e20766973697420746865207061676520746f206b6e6f772061626f7574206f75722074656163686572207175616c6974792e207468616e6b20796f752e266e6273703b3c2f703e0d0a, 'infrastructure', NULL, NULL, NULL, 1, 0, '2015-04-28', NULL, '2015-05-18', NULL),
(9, 'Admission Information ', 'ভর্তি তথ্য', 0x3c703e266e6273703b3c2f703e0d0a0d0a3c703e3c7370616e207374796c653d22746578742d7472616e73666f726d3a7570706572636173653b20666f6e742d7765696768743a626f6c643b20666f6e742d73697a653a313270783b223e4f7264696e616e63653c2f7370616e3e3c6272202f3e0d0a54686520446567726565206f6620446f63746f72206f66205068696c6f736f706879202868657265696e61667465722063616c6c6564207468652050682e442e2064656772656529207368616c6c20626520617761726465642062792074686520556e697665727369747920696e207265636f676e6974696f6e206f6620746865207375636365737366756c20636f6d706c6574696f6e20627920612063616e646964617465206f6620612070726f6772616d206f6620616476616e63656420737475647920616e6420726573656172636820616e6420616363657074616e6365206279207468652041636164656d696320436f756e63696c206f662074686520746865736973207375626d6974746564206279207468652063616e646964617465206166746572206120706572696f64206f66206174206c656173742074776f207965617273206f6620726567697374726174696f6e2061742074686520556e697665727369747920666f72207468652050682e442e206465677265652e3c6272202f3e0d0a3c6272202f3e0d0a5468652052756c657320726567617264696e672061646d697373696f6e20746f2074686520636f7572736573206f66207374756469657320616e64207265736561726368206c656164696e6720746f207468652050682e442e206465677265652c20746865207375626d697373696f6e206f6620746865207468657369732c20616e6420697473206578616d696e6174696f6e2c207368616c6c206265207072657363726962656420627920726567756c6174696f6e7320746f20626520656e6163746564206279207468652041636164656d696320436f756e63696c20616e64207468652053796e6469636174652e3c2f703e0d0a, 'admission-information ', NULL, NULL, NULL, 1, 0, '2015-04-30', NULL, '2015-05-03', NULL),
(1, 'About Institute', 'প্রতিষ্ঠানের ইতিহাস',  , 'about-us', NULL, NULL, NULL, 1, 0, '2015-04-27', NULL, '2015-05-20', NULL);

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

--
-- Table structure for table `courses`
--

CREATE TABLE IF NOT EXISTS `courses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `course_type` tinyint(3) NOT NULL DEFAULT '0',
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `attach_file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` int(11) NOT NULL,
  `created` date NOT NULL,
  `modified` date NOT NULL,
  `order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (`id`, `title`, `course_type`, `description`, `attach_file`, `isactive`, `created`, `modified`, `order`) VALUES
(1, 'Textile Science & Engineering (4Years) ', 1, '<h2><span style="color:#008080;"><strong><span style="font-size:16px;">Semester y semester plan</span></strong></span></h2>\r\n\r\n<p>BGIFT is a insitute they able to plan semester for students to easy learn and follow Bangladesh Technical Board curriculam. We&#39;re very carefull to imporve students skill and we know how to make semester to easy learning.&nbsp;</p>\r\n\r\n<p><strong>To know our syllabus on Textile science and Engineering pls see below downoad link and download the files and see easy. Thanks for visit us.</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n', 'files/course/1431461406_5261.jpg', 1, '2015-04-27', '2015-05-12', 0),
(2, 'Garments Design & Pattern Making (Bsc)', 1, '<h2><span style="color: rgb(0, 128, 128);"><strong><span style="font-size: 16px;">Semester y semester plan</span></strong></span></h2>\r\n\r\n<p style="line-height: 20.7999992370605px;">BGIFT is a insitute they able to plan semester for students to easy learn and follow Bangladesh Technical Board curriculam. We&#39;re very carefull to imporve students skill and we know how to make semester to easy learning.&nbsp;</p>\r\n\r\n<p style="line-height: 20.7999992370605px;"><strong>To know our syllabus on Garments Design and Pattern Making&nbsp;pls see below downoad link and download the files and see easy. Thanks for visit us.</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n', 'files/course/1431461445_9693.jpg', 1, '2015-04-27', '2015-05-16', 0),
(3, 'Fashion Merchandising(1 Year)', 1, '<h2><span style="color: rgb(0, 128, 128);"><strong><span style="font-size: 16px;">Semester y semester plan</span></strong></span></h2>\r\n\r\n<p style="line-height: 20.7999992370605px;">BGIFT is a insitute they able to plan semester for students to easy learn and follow Bangladesh Technical Board curriculam. We&#39;re very carefull to imporve students skill and we know how to make semester to easy learning.&nbsp;</p>\r\n\r\n<p style="line-height: 20.7999992370605px;"><strong>To know our syllabus on Fashion Merchandising pls see below downoad link and download the files and see easy. Thanks for visit us.</strong></p>\r\n', 'files/course/1431496657_2106.jpg', 1, '2015-04-27', '2015-05-13', 0),
(4, 'Certificate Course in CAD', 2, '<h2><span style="color: rgb(0, 128, 128);"><strong><span style="font-size: 16px;">Semester y semester plan</span></strong></span></h2>\r\n\r\n<p style="line-height: 20.7999992370605px;">BGIFT is a insitute they able to plan semester for students to easy learn and follow Bangladesh Technical Board curriculam. We&#39;re very carefull to imporve students skill and we know how to make semester to easy learning.&nbsp;</p>\r\n\r\n<p style="line-height: 20.7999992370605px;"><strong>To know our syllabus on Certificate course in CAD&nbsp;pls see below downoad link and download the files and see easy. Thanks for visit us.</strong></p>\r\n', 'files/course/1431461121_9328.jpg', 1, '2015-04-27', '2015-05-12', 0),
(5, 'Certificate Course in Apparel Merchandising', 2, '<h2><span style="color: rgb(0, 128, 128);"><strong><span style="font-size: 16px;">Semester y semester plan</span></strong></span></h2>\r\n\r\n<p style="line-height: 20.7999992370605px;">BGIFT is a insitute they able to plan semester for students to easy learn and follow Bangladesh Technical Board curriculam. We&#39;re very carefull to imporve students skill and we know how to make semester to easy learning.&nbsp;</p>\r\n\r\n<p style="line-height: 20.7999992370605px;"><strong>To know our syllabus on Textile science and Engineering pls see below downoad link and download the files and see easy. Thanks for visit us.</strong></p>\r\n\r\n<p style="line-height: 20.7999992370605px;">&nbsp;</p>\r\n', 'files/course/1431461477_8252.jpg', 1, '2015-04-27', '2015-05-12', 0),
(6, 'Certificate Course in Pattern Making', 2, '<h2><span style="color: rgb(0, 128, 128);"><strong><span style="font-size: 16px;">Semester y semester plan</span></strong></span></h2>\r\n\r\n<p style="line-height: 20.7999992370605px;">BGIFT is a insitute they able to plan semester for students to easy learn and follow Bangladesh Technical Board curriculam. We&#39;re very carefull to imporve students skill and we know how to make semester to easy learning.&nbsp;</p>\r\n\r\n<p style="line-height: 20.7999992370605px;"><strong>To know our syllabus on Textile science and Engineering pls see below downoad link and download the files and see easy. Thanks for visit us.</strong></p>\r\n', 'files/course/1431461521_4860.jpg', 1, '2015-04-27', '2015-05-12', 0),
(7, 'Garments banding business 1 year', 1, '<h2><span style="color: rgb(0, 128, 128);"><strong><span style="font-size: 16px;">Semester y semester plan</span></strong></span></h2>\r\n\r\n<p style="line-height: 20.7999992370605px;">BGIFT is a insitute they able to plan semester for students to easy learn and follow Bangladesh Technical Board curriculam. We&#39;re very carefull to imporve students skill and we know how to make semester to easy learning.&nbsp;</p>\r\n\r\n<p style="line-height: 20.7999992370605px;"><strong>To know our syllabus on Textile science and Engineering pls see below downoad link and download the files and see easy. Thanks for visit us.</strong></p>\r\n', 'files/course/1431465874_4641.jpg', 1, '2015-05-12', '2015-05-12', 0);

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

--
-- Table structure for table `departments`
--

CREATE TABLE IF NOT EXISTS `departments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `isdel` tinyint(3) NOT NULL DEFAULT '0',
  `isactive` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`id`, `title`, `created`, `modified`, `isdel`, `isactive`) VALUES
(1, 'বিজ্ঞান বিভাগ', '2015-05-22 16:41:39', '2015-05-22 16:41:39', 0, 1),
(2, 'কলা বিভাগ', '2015-05-22 16:43:28', '2015-05-22 16:43:28', 0, 1),
(3, 'বাণিজ্য বিভাগ', '2015-05-22 16:43:37', '2015-05-22 16:43:37', 0, 1);

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

--
-- Table structure for table `downloads`
--

CREATE TABLE IF NOT EXISTS `downloads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content_type` int(11) NOT NULL DEFAULT '0',
  `title` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `downloadfile` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `order` int(11) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `isactive` tinyint(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `downloads`
--


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

--
-- Table structure for table `employes`
--

CREATE TABLE IF NOT EXISTS `employes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` int(11) NOT NULL,
  `order` int(11) NOT NULL DEFAULT '0',
  `created` date NOT NULL,
  `modified` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `employes`
--


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

--
-- Table structure for table `faculties`
--

CREATE TABLE IF NOT EXISTS `faculties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `department_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `aboutme` text COLLATE utf8_unicode_ci NOT NULL,
  `education` text COLLATE utf8_unicode_ci,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` int(11) NOT NULL DEFAULT '0',
  `order` int(11) NOT NULL DEFAULT '0',
  `created` date NOT NULL,
  `modified` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `faculties`
--

INSERT INTO `faculties` (`id`, `department_id`, `name`, `aboutme`, `education`, `designation`, `subject`, `image`, `isactive`, `order`, `created`, `modified`) VALUES
(1, NULL, 'Nusrat Shimo', '<p>Hi, This is Nusrat shimo.&nbsp;displaying as a big picture and magnifier doesn&rsquo;t work. Same problem for all products. Another problem here is that, there is no shear button here under product picture.&nbsp;</p>', 'Bsc in AMT, MBA in AM', 'Assistant Teacher at BGIFT', NULL, 'files/photo/1431224322_5909.jpg', 1, 0, '2015-05-10', '2015-05-17'),
(2, NULL, 'Tasmim Akter', '<p>Hi,&nbsp;Hi, This is Tasmim Akter.&nbsp;displaying as a big picture and magnifier doesn&rsquo;t work. Same problem for all products. Another problem here is that, there is no shear button here under product picture.&nbsp;</p>\r\n<p>Hi,&nbsp;Hi, This is Tasmim Akter.&nbsp;displaying as a big picture and magnifier doesn&rsquo;t work. Same problem for all products. Another problem here is that, there is no shear button here under product picture.</p>', 'Bsc in AMT, MBA in AM', 'Senior Lecturer at BGIFT ', NULL, 'files/photo/1431224857_9477.jpg', 1, 0, '2015-05-10', '2015-05-17'),
(3, NULL, 'Hasan Khan', '<p>Hi,&nbsp;Hi, This is Tasmim Akter.&nbsp;displaying as a big picture and magnifier doesn&rsquo;t work. Same problem for all products. Another problem here is that, there is no shear button here under product picture.&nbsp;</p>\r\n<p>Hi,&nbsp;Hi, This is Tasmim Akter.&nbsp;displaying as a big picture and magnifier doesn&rsquo;t work. Same problem for all products. Another problem here is that, there is no shear button here under product picture.</p>', 'BSC Engineer, DUET', 'Lecturer', NULL, 'files/photo/1431890498_3637.jpg', 1, 0, '2015-05-17', '2015-05-17');

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

--
-- Table structure for table `generalsettings`
--

CREATE TABLE IF NOT EXISTS `generalsettings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sitename` varchar(255) DEFAULT NULL,
  `sitenamebng` varchar(255) DEFAULT NULL,
  `estd` varchar(80) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `mobileno` varchar(40) DEFAULT NULL,
  `phone` varchar(40) DEFAULT NULL,
  `fax` varchar(80) DEFAULT NULL,
  `address` text,
  `boardlogo` varchar(255) DEFAULT NULL,
  `language` tinyint(3) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `generalsettings`
--

INSERT INTO `generalsettings` (`id`, `sitename`, `sitenamebng`, `estd`, `logo`, `email`, `mobileno`, `phone`, `fax`, `address`, `boardlogo`, `language`, `created`, `modified`) VALUES
(1, 'KANCHKURA COLLEGE', 'কাঁচকুড়া বিশ্ববিদ্যালয় কলেজ', 'স্থাপিত-১৯৯২ খ্রি:', 'files/logo/1432058830_4238.jpg', 'info@kanchkuracollege.edu.bd', '01814091922', 'ফোন: ৮৯২০০১৫', '', 'কাঁচকুড়া, উত্তরখান, ঢাকা।', 'files/logo/1432058830_7652.png', 1, '2015-05-19 18:07:10', '2015-05-19 18:07:10');

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

--
-- Table structure for table `groups`
--

CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `created` date DEFAULT NULL,
  `modified` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`id`, `name`, `created`, `modified`) VALUES
(1, 'Administrators', '2015-05-19', '2015-05-19'),
(2, 'Teachers', '2015-05-19', '2015-05-19'),
(3, 'Clarks', '2015-05-19', '2015-05-19'),
(4, 'Students', '2015-05-19', '2015-05-19');

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

--
-- Table structure for table `libraries`
--

CREATE TABLE IF NOT EXISTS `libraries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `department_id` int(11) DEFAULT NULL,
  `name` varchar(400) COLLATE utf8_unicode_ci NOT NULL,
  `authorname` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sbnno` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `isactive` int(11) NOT NULL,
  `order` int(11) NOT NULL DEFAULT '0',
  `created` date NOT NULL,
  `modified` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `libraries`
--


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

--
-- Table structure for table `managements`
--

CREATE TABLE IF NOT EXISTS `managements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` int(11) NOT NULL,
  `order` int(11) NOT NULL DEFAULT '0',
  `created` date NOT NULL,
  `modified` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `managements`
--


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

--
-- Table structure for table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `attach_file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` int(11) NOT NULL,
  `created` date NOT NULL,
  `modified` date NOT NULL,
  `order` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`id`, `name`, `title`, `description`, `attach_file`, `isactive`, `created`, `modified`, `order`) VALUES
(1, 'মো. বেলাল উদ্দিন', 'অধ্যক্ষের বাণী', '<p>বর্তমান প্রতিযোগিতামূলক বিশ্বে স্বাধীন রাষ্ট্র হিসেবে মর্যাদার সাথে টিকে থাকতে আমাদের দেশের প্রয়োজন নৈতিক মূল্যবোধ সম্পন্ন সুশিক্ষিত নাগরিক। এ সুশিক্ষিত নাগরিক গড়ে তোলার জন্য ঢাকা মহানগরীর উত্তরখান থানা ও উত্তরখান ইউনিয়নের একমাত্র এমপিও ভ&rsquo;ক্ত কলেজ কাঁচকুড়া বিশ্ববিদ্যালয় কলেজ প্রতিষ্ঠালগ্ন থেকেই এ দায়িত্ব পালন করে আসছে।</p>\r\n<p>গণপ্রজাতন্ত্রী বাংলাদেশ সরকারের গর্ভনিং বডি, শিক্ষক এবং এলাকার সর্বস্তরের জনগনের সহায়তায় কলেজের ভৌত অবকাঠামো, একাডেমিক ও প্রশাসনিক কার্যক্রম উন্নয়নে চলছে কঠোর পরিশ্রম ও নিরন্তন চেষ্টা। বিগত বছরগুলোতে কলেজের উচ্চ মাধ্যমিক পরীক্ষা (অ+) সহ ও তক (পাস) পর্যায়ে ফলাফল অত্যন্ত সন্তোষজনক। ২০১২-২০১৩ শিক্ষাবর্ষে বিবিএ (অনার্স) হিসাববিজ্ঞান ও ব্যবস্থাপনা বিষয়ে জাতীয় বিশ্ববিদ্যলয়ের অধিভ&rsquo;ক্তি লাভ করেছে। কলেজে ৫ম তলা একটি একাডেমিক ভবন স্থাপিত হয়েছে এবং শিক্ষা মন্ত্রনালয়ের শিক্ষা প্রকৌশল অধিদপ্তর কর্তৃক ৮তলা ফাউন্ডেশনযুক্ত দ্বিতল ভবন নির্মানের কাজ চলছে। এ ভবনটির নির্মান শেষ হলে কলেজের ভৌত অবকাঠামোগত কোন সমস্যা থাকবে না। ফলে আরও কয়েকটি বিষয়ে স্নাতক (অনার্স) কোর্স এবং মাষ্টার্স কোর্স চালু করা সম্ভব হবে এবং এর মাধ্যমে অত্র বিশাল এলাকার শিক্ষার্থীদের বিশেষ করে নারী শিক্ষার্থীদের উচ্চ শিক্ষার পথ সুগম হবে। উত্তরখান ইউনিয়নের আমাইয়া এলাকায় কলেজের নামে ১.৭০ একর জমি চিরস্থায়ী বরাদ্দের প্রক্রিয়া অব্যাহত আছে। উল্লেখ্য যে উক্ত ১.৭০ একর জমি ২০ বছর যাবৎ কলেজ ব্যবহার করে আসছে। উক্ত জমিতে কলেজের একটি ছাত্রাবাস রয়েছে। এ কলেজটি খুব শিগ্রই একটি বৃহত্তম শিক্ষা প্রতিষ্ঠান হিসেবে প্রতিষ্ঠা লাভ করবে এমন প্রত্যশা এ এলাকার সর্বস্তরের জনগনের। মহান আল্লাহ্ আমাদের সহায় হউন।</p>', 'files/news/1432314689_7025.jpg', 1, '2015-05-22', '2015-05-22', 0);

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

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `attach_file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` int(11) NOT NULL,
  `posted_date` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `created` date NOT NULL,
  `modified` date NOT NULL,
  `order` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `title`, `description`, `attach_file`, `isactive`, `posted_date`, `created`, `modified`, `order`) VALUES
(1, '3 BGIFT students receive ‘Prof. Nasreen Khondaker memorial gold medal and scholarship’', '<p>The freshers&rsquo; reception for the 7th Batch Masters Students and the 3rd Batch first year honors students respectively of the Institute of Disaster Management &amp; Vulnerability Studies (IDMVS) of Dhaka University (DU) was held today (Tuesday) May 05, 2015 at the TSC auditorium of the university. Dhaka University Pro-Vice Chancellor (Academic) Prof. Dr. Nasreen Ahmad addressed the function as chief guest.</p>\r\n<p>Director of IDMVS Prof. Dr. Mahbuba Nasreen presided over the function while Dean of the Faculty of Social Science Prof. Farid Uddin Ahmed and Dean of the Faculty of Arts Prof. Dr. Md. Akhtaruzzaman addressed it as special guests.</p>\r\n<p>Dhaka University Pro-Vice Chancellor (Academic) Prof. Dr. Nasreen Ahmad urged the students of IDMVS to play pioneering role to create awareness among the people on various natural disasters including earthquake. She hoped that the IDMVS would play an effective role to produce skilled and trained manpower on disaster management. She also called upon the students to equip themselves with spirit of our Liberation War to ensure DU campus free from vitiated and wrong-headed people who harassed the women during Bangla New Year celebration program.<br /> ---------------</p>\r\n<p>&nbsp;(Md. Rafiqul Islam)<br /> Assistant Director<br /> Public Relations Office<br /> University of Dhaka</p>\r\n<div id="__if72ru4sdfsdfrkjahiuyi_once" style="display: none;">&nbsp;</div>\r\n<div id="__if72ru4sdfsdfruh7fewui_once" style="display: none;">&nbsp;</div>\r\n<div id="__hggasdgjhsagd_once" style="display: none;">&nbsp;</div>', '', 1, '1430179200', '2015-04-27', '2015-05-05', 1),
(2, 'Amesterdam element in the transition effect', '<p>coming soon....................</p>', '', 1, '1429660800', '2015-04-27', '2015-04-27', 3),
(3, 'Amesterdam element in the transition effect', '<p>coming soon....................</p>', '', 1, '1429920000', '2015-04-27', '2015-04-27', 2),
(4, 'Amesterdam element in the transition effect', '<p>coming soon....................</p>', '', 1, '1430006400', '2015-04-27', '2015-04-27', 4),
(5, 'Notice for all students', '<p>All are being requested to pay their dues</p>', 'files/news/1431466188_4276.docx', 1, '1431475200', '2015-05-12', '2015-05-12', 0);

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

--
-- Table structure for table `notices`
--

CREATE TABLE IF NOT EXISTS `notices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `attach_file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` int(11) NOT NULL,
  `posted_date` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `created` date NOT NULL,
  `modified` date NOT NULL,
  `order` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `notices`
--

INSERT INTO `notices` (`id`, `title`, `description`, `attach_file`, `isactive`, `posted_date`, `created`, `modified`, `order`) VALUES
(1, '20 BGIFT meritorious students get prizes', '<p>Fifteen meritorious students of the Department of Botany have been awarded prizes for their outstanding academic results in various examinations. Besides, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5 students of the same department have received prizes for their excellent performances in extra-curricular activities. Dhaka University Vice-Chancellor Prof. Dr. AAMS Arefin Siddique distributed prizes among the students as chief guest at the freshers&rsquo; reception and farewell program of the Department of Botany held today &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;27 April 2015 at the departmental auditorium. <br /> Chairman of the Department of Botany Prof. Dr. Moniruzzaman Khondker presided over the function while Treasurer Prof. Dr. Md. Kamal Uddin and Dean of the Faculty of Biological Sciences Prof. Dr. M. Imdadul Haque addressed it as special guests. <br /> Dhaka University Vice-Chancellor Prof. Dr. AAMS Arefin Siddique in his speech urged the students to make themselves as complete human being by using their merits properly. He said, students have to work hard for publishing and establishing the truth in the society. The VC recalled the historic contributions of DU students in our Liberation War. The students of this university always fight for establishing truth in the society, he mentioned. <br /> The recipients of prizes are Mahin Mohid, Nasima Akhter, Fateeha Noor, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Israt Jahan Bonna, Md. Ibrahim Khalil, Chandan Kumar Dash, Md. Hasan Shaikh , Sumiya Tabassum, Sumaiya Jannat, Masnun Homaira Maisha, Asif Ahmed Sami, Nur-E-Hafsa, Puja Pushpa Ghosh, Omar Faruq, Md. Onix Rahman, Md. Rokon-Uz-Zaman Khokon, Md. Atiq Mahbub and Marjana Chowdhury.<br /> Besides, Israt Jahan Bonna has been awarded &lsquo;Amena Meher Memorial Award&rsquo; and Badrun Nahar has received `National Professor A K M Nurul Islam Memorial Prize&rsquo; respectively. <br /> -------------<br /> (Md. Rafiqul Islam)<br /> Assistant Director<br /> Public Relations Office<br /> University of Dhaka</p>\r\n<div id="__if72ru4sdfsdfrkjahiuyi_once" style="display: none;">&nbsp;</div>\r\n<div id="__if72ru4sdfsdfruh7fewui_once" style="display: none;">&nbsp;</div>\r\n<div id="__hggasdgjhsagd_once" style="display: none;">&nbsp;</div>', '', 1, '1430179200', '2015-04-27', '2015-05-05', 1),
(2, 'Amesterdam element in the transition effect', '<p>coming soon....................</p>', '', 1, '1429660800', '2015-04-27', '2015-04-27', 3),
(3, 'Amesterdam element in the transition effect', '<p>coming soon....................</p>', '', 1, '1429920000', '2015-04-27', '2015-04-27', 2),
(4, 'Amesterdam element in the transition effect', '<p>coming soon....................</p>', '', 1, '1430006400', '2015-04-27', '2015-04-27', 4);

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

--
-- Table structure for table `payments`
--

CREATE TABLE IF NOT EXISTS `payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL DEFAULT '0',
  `semester_id` int(11) NOT NULL DEFAULT '0',
  `studentname` varchar(255) DEFAULT NULL,
  `stdid` varchar(255) DEFAULT NULL,
  `payment_title` varchar(255) DEFAULT NULL,
  `amount` int(11) NOT NULL DEFAULT '0',
  `created` date NOT NULL,
  `modified` date NOT NULL,
  `isactive` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`id`, `course_id`, `semester_id`, `studentname`, `stdid`, `payment_title`, `amount`, `created`, `modified`, `isactive`) VALUES
(1, 1, 1, 'Md. Belal', '34535343', 'Course Fee', 2000, '2015-05-09', '2015-05-09', 1),
(2, 1, 3, 'Md. Belal Uddin', '34535345', 'Course Fee, Admin', 2000, '2015-05-09', '2015-05-11', 1),
(3, 2, 4, 'Himel', '201-6281', 'Semester Fee', 25000, '2015-05-10', '2015-05-10', 1),
(4, 1, 1, 'Md. Belal', '34535343', 'Course Fee, Admin', 2000, '2015-05-11', '2015-05-11', 1);

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

--
-- Table structure for table `photo_categories`
--

CREATE TABLE IF NOT EXISTS `photo_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `category_image` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `isactive` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `photo_categories`
--

INSERT INTO `photo_categories` (`id`, `name`, `category_image`, `created`, `modified`, `isactive`) VALUES
(1, 'Independent Day', 'files/photo/1431193710_5172.jpg', '2015-05-09 17:48:30', '2015-05-09 17:48:30', 1),
(2, 'Weekly program at College', 'files/photo/1431225192_7088.jpg', '2015-05-10 02:33:12', '2015-05-10 02:33:12', 1),
(3, 'Weekly program at College', 'files/photo/1431225271_1265.jpg', '2015-05-10 02:34:31', '2015-05-10 02:34:31', 1),
(4, 'Picnic', 'files/photo/1432326545_7086.jpg', '2015-05-22 20:29:05', '2015-05-22 20:29:05', 1);

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

--
-- Table structure for table `photo_galleries`
--

CREATE TABLE IF NOT EXISTS `photo_galleries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `photo_category_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `imagename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `isactive` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `photo_galleries`
--


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

--
-- Table structure for table `results`
--

CREATE TABLE IF NOT EXISTS `results` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `studentinformtion_id` int(11) NOT NULL DEFAULT '0',
  `year` varchar(80) DEFAULT NULL,
  `examname` varchar(255) DEFAULT NULL,
  `cgpa` varchar(20) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `isactive` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `results`
--


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

--
-- Table structure for table `semesters`
--

CREATE TABLE IF NOT EXISTS `semesters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `isactive` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `semesters`
--

INSERT INTO `semesters` (`id`, `title`, `created`, `modified`, `isactive`) VALUES
(1, '1st Semester', '2015-05-09 20:06:36', '2015-05-09 20:06:39', 1),
(2, '2nd Semester', '2015-05-09 20:07:02', '2015-05-09 20:07:06', 1),
(3, '3rd Semester', '2015-05-09 20:06:36', '2015-05-09 20:06:39', 1),
(4, '4th Semester', '2015-05-09 20:07:02', '2015-05-09 20:07:06', 1),
(5, '5th Semester', '2015-05-09 20:06:36', '2015-05-09 20:06:39', 1),
(6, '6th Semester', '2015-05-09 20:07:02', '2015-05-09 20:07:06', 1),
(7, '7th Semester', '2015-05-09 20:06:36', '2015-05-09 20:06:39', 1),
(8, '8th Semester', '2015-05-09 20:07:02', '2015-05-09 20:07:06', 1),
(9, '1st Year', '2015-05-09 20:07:02', '2015-05-09 20:07:06', 1),
(10, '2nd Year', '2015-05-09 20:07:02', '2015-05-09 20:07:06', 1),
(11, '3rd Year', '2015-05-09 20:41:37', '2015-05-09 20:41:43', 1),
(12, '4th Year', '2015-05-09 20:41:58', '2015-05-09 20:42:01', 1),
(13, '1 Year Diploma', '2015-05-09 20:42:29', '2015-05-09 20:42:34', 1),
(14, '6 Month Certificate Course', '2015-05-09 20:42:29', '2015-05-09 20:42:34', 1),
(15, '3 months certificate course', '2015-05-09 20:42:29', '2015-05-09 20:42:34', 1);

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

--
-- Table structure for table `studentinformations`
--

CREATE TABLE IF NOT EXISTS `studentinformations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `studentid` varchar(120) DEFAULT NULL,
  `studentname` varchar(255) DEFAULT NULL,
  `session` varchar(120) DEFAULT NULL,
  `fathername` varchar(255) DEFAULT NULL,
  `mothername` varchar(255) DEFAULT NULL,
  `currentaddress` text,
  `permanentaddress` text,
  `dateofbirth` varchar(255) DEFAULT NULL,
  `religion` varchar(255) DEFAULT NULL,
  `nationality` varchar(255) DEFAULT NULL,
  `nationalid` varchar(255) DEFAULT NULL,
  `mobileno` varchar(40) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `phone` varchar(40) DEFAULT NULL,
  `parentmobileno` varchar(40) DEFAULT NULL,
  `parentoccupation` varchar(255) DEFAULT NULL,
  `bloodgroup` varchar(20) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `category_id` int(11) NOT NULL DEFAULT '0',
  `department_id` int(11) DEFAULT NULL,
  `status` tinyint(3) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `studentinformations`
--


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

--
-- Table structure for table `subscribers`
--

CREATE TABLE IF NOT EXISTS `subscribers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `semail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `subscribers`
--

INSERT INTO `subscribers` (`id`, `semail`, `isactive`) VALUES
(1, 'amsujon445@gmail.com', 1);

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` char(40) NOT NULL,
  `group_id` int(11) NOT NULL,
  `created` date DEFAULT NULL,
  `modified` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `users` (`id`, `name`, `username`, `password`, `group_id`, `created`, `modified`) VALUES
(1, 'Master Admin', 'belal18', '54e53b41ba5d8d7d6e8e77c20a3523caf8ee8161', 1, '2015-05-19', '2015-05-19');
