-- http://www.phpmyadmin.net
--




--
-- Database: `edesk_db`
--

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

--
-- Table structure for table `articles`
--

CREATE TABLE IF NOT EXISTS `articles` (
  `art_id` int(11) NOT NULL AUTO_INCREMENT,
  `art_alias` varchar(100) NOT NULL,
  `art_title` varchar(200) NOT NULL,
  `page_title` varchar(100) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `full_text` text NOT NULL,
  `created_by` varchar(20) NOT NULL,
  `date_created` date NOT NULL,
  `date_modified` date NOT NULL,
  `read_times` int(11) NOT NULL,
  `likes` int(11) NOT NULL,
  `serial` int(11) NOT NULL,
  `default_to_cat` enum('yes','no') NOT NULL DEFAULT 'no' COMMENT 'default articles will be automatically displayed to its category hence event',
  `notification` enum('yes','no') NOT NULL DEFAULT 'no',
  `status` enum('publish','unpublish') NOT NULL DEFAULT 'publish',
  PRIMARY KEY (`art_id`),
  UNIQUE KEY `art_alias` (`art_alias`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Dumping data for table `articles`
--

INSERT INTO `articles` (`art_id`, `art_alias`, `art_title`, `page_title`, `cat_id`, `full_text`, `created_by`, `date_created`, `date_modified`, `read_times`, `likes`, `serial`, `default_to_cat`, `notification`, `status`) VALUES
(2, 'intro-cloud-computing', 'Introduction to Cloud Computing', 'Introduction to Cloud Computing', 6, '<p>Wireless  nodes in an ad-hoc network are free to move about at will. As such, the  topology of the network, which is typically multi-hop, is highly  dynamic, changing randomly at unpredictable intervals in unpredictable  ways. Because of wireless radio propagation effects, such as  interference, links may be either bidirectional or unidirectional.</p>', '', '2012-11-13', '2012-11-13', 0, 0, 1, 'yes', 'no', 'publish'),
(3, 'key-topics-cloud-computing', 'Key Topics of Cloud Computing', 'Key Topics of Cloud Computing', 6, '<p>The following topics will be discussed at the seminar.</p>\n<ul>\n<li>Key topic 1</li>\n<li>Key topic 2</li>\n<li>Key topic 3</li>\n<li>key topic 4</li>\n</ul>', '', '2012-11-13', '2012-11-13', 0, 0, 2, 'no', 'no', 'publish'),
(4, 'cloud-computing-attendees', 'Who Can Attend?', 'Who Can Attend?', 6, '<p>The following type of attendees will have greater benefit at the seminar.</p>\n<ul>\n<li>Lorem ipsum dolor sit amet</li>\n<li>Lorem ipsum dolor sit amet</li>\n<li>Lorem ipsum dolor sit amet</li>\n<li>Lorem ipsum dolor sit amet</li>\n<li>Lorem ipsum dolor sit amet</li>\n<li>Lorem ipsum dolor sit amet</li>\n<li>Lorem ipsum dolor sit amet</li>\n</ul>', '', '2012-11-13', '2012-11-13', 0, 0, 3, 'no', 'no', 'publish'),
(5, 'sub-background', 'SUB  Background', 'SUB Background', 7, '<p>The Souther is the pathway.At the southern,We provide pathway to global success through quality education since 2003.Souther has fully accredited courses,which are recognized internationall and provide students wih pathways to quality universities in Australia,UK,USA and other selected international universities.</p>', '', '2012-11-14', '2014-09-06', 0, 0, 1, 'yes', 'no', 'publish'),
(6, 'Impact Initiative', 'UN Academic Impact Initiative', 'UN Academic Impact Initiative', -1, '<p>Southern University Bangladesh has accepted an invitation from the United Nations to become a charter Member of the United nations Academic Impact initiative.In doing so,Southern University is affirming basic principles to which SOuthern University Bagladesh are committed.</p>', '', '2012-11-14', '2014-09-06', 0, 0, 2, 'no', 'yes', 'publish'),
(7, 'scope-of-the-university', 'Scope of The University', 'Scope of The University', 7, '<p>Sothern University Bangladesh is an independent University exercising powers and authority to provide education and confer higher degrees in all branches of Shari`ah, Humanities, Social Sciences, Business Studies and Modern Sciences including Computer Science &amp; IT, Environmental Sciences, Aqua-culture, Computer &amp; ELectrical Engineering, Media &amp; Information Science etc. This will include under graduate Programs and Post-Graduate Degree programs .</p>', '', '2012-11-14', '2014-09-07', 0, 0, 3, 'no', 'no', 'publish'),
(8, 'laboratory-facilities', 'Laboratory Facilities', 'Laboratory Facilities', -1, '<p>Modern laboratory facilities are needed in the science and engineering departments to make education &amp; training effective.Keeping this in view,Southern University has developed eight modern Pharmacy laborations in which 22 practical courses are conducted.</p>', '', '2012-11-14', '2014-09-06', 0, 0, 4, 'no', 'no', 'publish'),
(9, 'Scholarship-and-Financial-Assistance', 'Scholarship and Financial Assistance', 'Scholarship and Financial Assistance', -1, '<p>Southern University scholarships are based solely on a student''s high schools/college or transfer academic record.Students are required to hav a 3.2 college grade point average. Scholarships ar reneable each year provided the recipent maintains a 3.2 gpa each academic year.</p>', '', '2012-11-14', '2014-09-06', 0, 0, 5, 'no', 'yes', 'publish'),
(10, 'ugc-ranking-and-baete-accrd', 'UGC Ranking', 'UGC Ranking ', 7, '<p>sothern has alos a UGC ranking university</p>', '', '2012-11-14', '2014-09-07', 0, 0, 6, 'no', 'yes', 'publish'),
(11, 'ad-hoc-overview', 'Brief Overview', 'Brief Overview of Ad hoc Networks', 8, '<p><img src=\\"images/ad-hoc-overview1.jpg\\" alt=\\"\\" /></p>\n<p>Recent  advances in portable computing and wireless technologies are opening up  exciting possibilities for the future of wireless mobile networking. A  mobile ad hoc network (MANET) is an autonomous system of mobile hosts  connected by wireless links. Mobile networks can be classified into  infrastructure networks and mobile ad hoc networks according to their  dependence on fixed infrastructures. In an infrastructure mobile  network, mobile nodes have wired access points (or base stations) within  their transmission range.<br /> The access points compose the backbone for an infrastructure network.  In contrast, mobile ad hoc networks are autonomously self-organized  networks without infrastructure support. In a mobile ad hoc network,  nodes move arbitrarily, therefore the network may experiences rapid and  unpredictable topology changes. Additionally, because nodes in a mobile  ad hoc network normally have limited transmission ranges, some nodes  cannot communicate directly with each other. Hence, routing paths in  mobile ad hoc networks potentially contain multiple hops, and every node  in mobile ad hoc networks has the responsibility to act as a router.Mobile  ad hoc networks originated from the DARPA Packet Radio Network (PRNet)  and SURAN project. Being independent on pre-established infrastructure,  mobile ad hoc networks have advantages such as rapid and ease of  deployment, improved flexibility and reduced costs.</p>', '', '2012-11-14', '2012-11-14', 0, 0, 1, 'yes', 'no', 'publish'),
(12, 'Challenges-in-Routing-and-Multicasting', 'Challenges in Routing and Multicasting', 'Challenges in Routing and Multicasting', 8, '<p>Routes in ad hoc networks are multihop because of the limited  propagation range of wireless nodes. Since nodes in the network move  freely and randomly, routes often get disconnected. Routing protocols  are thus responsible for maintaining and reconstructing the routes in a  timely manner as well as establishing the robust routes. Furthermore,  routing protocols are required to perform all the above tasks without  generating excessive control message overhead. Control packets must be  utilized efficiently to deliver data packets, and be generated only when  necessary. Reducing the control overhead can make the routing protocol  efficient in bandwidth and energy consumption. Multipoint  communications have emerged as one of the most researched areas in the  field of networking. As the technology and popularity of Internet grow,  applications, such as online gaming, video conferencing, that require  multicast support are become more widespread. In a typical ad hoc  environment, network hosts work in groups to carry out a given task.  Therefore, multicast plays an important role in ad hoc networks. As we  can see, providing efficient multicasting over MANET faces many  challenges, including dynamic group establishment and constant update of  delivery path due to node movement. Multicast protocols used in static  networks like Distance Vector Multicast Routing Protocol (DVMRP),  Multicast Open Shortest Path First (MOSPF), and Core Based Tree (CBT) do  not perform well in wireless ad hoc networks because multicast tree  structures are fragile and must be readjusted as connectivity changes.  Hence, the tree structures used in static networks must be modified, or a  different topology between members (i.e., mesh) need to be deployed for  efficient multicasting in wireless mobile ad hoc networks [1].  Undoubtedly, multicast communication is an efficient means of supporting  group oriented applications. This is especially true in MANETs where  nodes are energy-and bandwidth limited. In these resources constrained  environments, reliable point &ndash;to-point protocols can get prohibitively  expensive. The Convergence of multiple requests to a single node  typically causes intolerable congestion, violating the time constraints  of a critical mission, and may drain the node&rsquo;s battery, cutting short  the network&rsquo;s lifetime. Despite the fact that reliable multicasting is  vital to the success of mission critical applications in MANETs.</p>', '', '2012-11-14', '2012-11-14', 0, 0, 2, 'no', 'no', 'publish'),
(13, 'Dynamic-Topologies', 'Dynamic Topologies', 'Dynamic Topologies', 8, '<p>Wireless  nodes in an ad-hoc network are free to move about at will. As such, the  topology of the network, which is typically multi-hop, is highly  dynamic, changing randomly at unpredictable intervals in unpredictable  ways. Because of wireless radio propagation effects, such as  interference, links may be either bidirectional or unidirectional.</p>', '', '2012-11-14', '2012-11-14', 0, 0, 3, 'no', 'no', 'publish'),
(14, 'energy-constrained-operation', 'Energy-constrained Operation', 'Energy-constrained operation', 8, '<p>Wireless  networks will typically operate on laptop computers, hand-held computers  and other battery-powered devices. As such, ad-hoc routing protocols  must be designed with the conservation of the device&rsquo;s energy in mind.  There is a conflict between the requirements that nodes in an ad-hoc  network must be willing to offer their services for forwarding packets  for other nodes, versus the desirability from an energy conservation  perspective that nodes sleep when they are not actively being used.</p>', '', '2012-11-14', '2012-11-14', 0, 0, 4, 'no', 'no', 'publish'),
(15, 'zero-configurations-ad-hoc', 'Zero Configurations', 'Zero Configurations', 8, '<p>Another  desirable property of ad-hoc networks is that they should require little  or no administrative overhead for their operation. It is desirable that  when a group of Wireless nodes come together, they can negotiate all  the relevant networking parameters automatically without manual  intervention. In IP-enabled ad-hoc networks, the most important  parameter is a node&rsquo;s Internet Protocol (IP) address. This issue of  assigning unique IP addresses to nodes in an ad-hoc network is another  area of substantial research. Traditional wired networks typically use a  centralized solution to the problem in the form of the Dynamic Host  Configuration Protocol (DHCP). Given the lack of a central  administrative body in an ad-hoc network, a distributed approach is  required. It is likely the solution will involve nodes selecting their  IP address at random, and using some means, such as examining Address  Resolution Protocol (ARP) traffic from other nodes, to prevent or  resolve issues where collisions have occurred.</p>', '', '2012-11-14', '2012-11-14', 0, 0, 5, 'no', 'no', 'publish'),
(16, 'ssd-overview', 'SSD Overview', 'SSD Overview', 9, '<p>The  explosion of flash memory technology has dramatically increased storage  capacity and decreased the cost of non-volatile semiconductor memory.  The technology has fueled the proliferation of USB flash drives and is  now poised to replace magnetic hard disks in some applications. A solid  state drive (SSD) is a non-volatile memory system that emulates a  magnetic hard disk drive (HDD). SSDs do not contain any moving parts,  however, and depend on flash memory chips to store data.<br /> <img src=\\"images/Third_Generation_Solid_State_Drives_.jpg\\" alt=\\"\\" />With  proper design, an SSD is able to provide high data transfer rates, low  access time, improved tolerance to shock and vibration, and reduced  power consumption. For some applications, the improved performance and  durability outweigh the higher cost of an SSD relative to an HDD.</p>\n<p>Using  flash memory as a hard disk replacement is not without challenges. The  nano-scale of the memory cell is pushing the limits of semiconductor  physics. Extremely thin insulating glass layers are necessary for proper  operation of the memory cells. These layers are subjected to stressful  temperatures and voltages, and their insulating properties deteriorate  over time. Quite simply, flash memory can wear out. Fortunately, the  wear-out physics are well understood and data management strategies are  used to compensate for the limited lifetime of flash memory.</p>', '', '2012-11-14', '2012-11-14', 0, 0, 1, 'yes', 'no', 'publish'),
(17, 'floating-gate-flash-memory-cells', 'Floating Gate Flash Memory Cells', 'Floating Gate Flash Memory Cells', 9, '<p>SSDs  mainly depend on flash memory chips to store data. &nbsp;The name \\"flash\\"  was suggested because the process of erasing the memory contents  reminded him of the flash of a camera. Flash memory chips store data in a  large array of floating gate metal&ndash;oxide&ndash;semiconductor (MOS)  transistors. Silicon wafers are manufactured with microscopic transistor  dimension, now approaching 40 nanometers. In this flash memory thin  insulating glass layers are necessary for proper operation of the memory  cells. These layers are subjected to stressful temperatures and  voltages, and their insulating properties deteriorate over time. Quite  simply, flash memory can wear out.<strong></strong>A  floating gate memory cell is a type of metal-oxide-semiconductor  field-effect transistor (MOSFET). Silicon forms the base layer, or  substrate, of the transistor array. Areas of the silicon are masked off  and infused with different types of impurities in a process called  doping. Impurities are carefully added to adjust the electrical  properties of the silicon. Some impurities, for example phosphorous,  create an excess of electrons in the silicon lattice. Other impurities,  for example boron, create an absence of electrons in the lattice. The  impurity levels and the proximity of the doped regions are set out in a  lithographic manufacturing process. In addition to doped silicon  regions, layers of insulating silicon dioxide glass (SiO2) and  conducting layers of polycrystalline silicon and aluminum are deposited  to complete the MOSFET structure.</p>', '', '2012-11-14', '2012-11-14', 0, 0, 2, 'no', 'no', 'publish'),
(18, 'nand-ssd', 'NAND - Flash Memory Array Archietechture', 'NAND - Flash Memory Array Archietechture', 9, '<p>NAND  flash memory chips arrange the memory cells in a logical &ldquo;not-and&rdquo;  (NAND) configuration. This arrangement strings together all of the cells  for a common input / output (I/O) bit across all memory pages. <br /> Because  of this arrangement, it is not possible to directly access individual  data bytes within a memory page. The flash memory controller must read  an entire page of memory from the device. Also, an entire page must  usually be programmed at once, although some devices permit partial page  programming. That makes NAND flash unsuitable for most random  byte-access memory applications.The  flash memory controller may additionally divide the 2048 bytes per page  into four sectors of 512 bytes, a typical size for HDDs. But the NAND  flash memory unsuitable for most random byte-access memory applications.<br /> NAND  flash memory is more densely packed on the silicon due to the space  saved by reducing the number of I/O bit lines and ground connections.  NAND flash memory has a lower cost per bit than NOR flash memory. NAND  flash memory is more suitable for data file storage where random  byte-access is not essential. NAND flash memory cells are more  susceptible to disturbances from reading and programming neighboring  pages due to the high density of memory cells on the silicon wafer.<br /> Another  different type of arrangement combines cells into a &ldquo;not-or&rdquo; (NOR)  logic configuration. NOR flash memory allows each memory cell to be  individually addressed and is suitable for random byte-access memory  application.<br /> To  understand how wear leveling is performed on memory within the SSD  flash drive, it is important to understand the architecture layout of  the NAND flash. An SSD is made up of many individual NAND flash chips.  Each individual NAND flash chip is made up of an array of blocks. Within  each block is an array of memory cells called pages (or sectors).Pages  are typically about 512 bytes, but can be as large as 2048 bytes. Each  page incorporates additional overhead bytes to handle such things as ECC  and indexing.</p>', '', '2012-11-14', '2012-11-14', 0, 0, 3, 'no', 'no', 'publish'),
(22, 're:-proposal-for-the-software-development-project', 'Re: Proposal for the Software Development Project', 'Re: Proposal for the Software Development Project', 2, '<p>The department is asking for the Proposal for the Software Development Project of the 2nd semester which must be submitted properly on or before 10th february, 2013 to the respective supervisor. Please collect the format from your class captain and start working immediately.</p>', 'c091216', '2012-11-22', '2012-11-22', 0, 0, 0, 'no', 'no', 'publish'),
(23, 'intro-lte-opt', 'Introduction to LTE', 'Introduction to LTE', 10, '<p><em>LTE (Long Term Evolution)</em> is a wireless <a href="http://compnetworking.about.com/cs/dsl/g/bldef_broadband.htm">broadband</a> technology designed to support roaming Internet access via cell phones  and handheld devices. Because LTE offers significant improvements over  older cellular communication standards, some refer to it as a <em>4G</em> (fourth generation) technology along with <a href="http://compnetworking.about.com/od/wirelessinternet/g/bldef_wimax.htm">WiMax</a>.</p>\n<p><img src="images/lte.jpg" alt="LTE" />With its architecture based on <a href="http://compnetworking.about.com/od/networkprotocolsip/g/ip_protocol.htm">Internet Protocol (IP)</a> unlike many other cellular Internet protocols, Long Term Evolution supports browsing Web sites, <a href="http://compnetworking.about.com/cs/voicefaxoverip/g/bldef_voip.htm">VoIP</a> and other IP-based services well. LTE can theoretically support downloads at 300 <a href="http://compnetworking.about.com/od/speedtests/g/kbps-mbps-gbps-network-bit-rates.htm">Megabits per second (Mbps)</a> or more based on experimental trials. However, the actual <a href="http://compnetworking.about.com/od/speedtests/g/bldef_bandwidth.htm">network bandwidth</a> available to an individual LTE subscriber sharing the service provider''s network with other customers is significantly less.</p>\n<p>Long Term Evolution service is only available in limited geographic  areas, but telecommunications providers have been actively expanding  their LTE services.</p>', '', '2012-12-21', '2014-09-06', 0, 0, 1, 'yes', 'no', 'publish'),
(24, 'lte-history', 'History of LTE Implementation', 'History of LTE Implementation', 10, '<p>The world''s first publicly available LTE service was launched by <a title="TeliaSonera" href="http://en.wikipedia.org/wiki/TeliaSonera">TeliaSonera</a> in <a title="Oslo" href="http://en.wikipedia.org/wiki/Oslo">Oslo</a> and <a title="Stockholm" href="http://en.wikipedia.org/wiki/Stockholm">Stockholm</a> on 14 December 2009<sup><a href="http://en.wikipedia.org/wiki/LTE_%28telecommunication%29#cite_note-3"></a></sup> LTE is the natural upgrade path for both carriers with GSM/UMTS networks and for <a title="CDMA" href="http://en.wikipedia.org/wiki/CDMA">CDMA</a> holdouts such as <a title="Verizon Wireless" href="http://en.wikipedia.org/wiki/Verizon_Wireless">Verizon Wireless</a>, who launched the first large-scale LTE network in North America in 2010, and <a title="Au (mobile phone company)" href="http://en.wikipedia.org/wiki/Au_%28mobile_phone_company%29">au by KDDI</a> in Japan have announced they will migrate to LTE. LTE is, therefore,  anticipated to become the first truly global mobile phone standard,  although the use of different <a title="LTE frequency bands" href="http://en.wikipedia.org/wiki/LTE_frequency_bands">frequency bands</a> in different countries will mean that only multi-band phones will be able to use LTE in all countries where it is supported.</p>\n<p>Although marketed as a <a title="4G" href="http://en.wikipedia.org/wiki/4G">4G</a> wireless service, LTE as specified in the 3GPP Release 8 and 9 document  series does not satisfy the technical requirements the 3GPP consortium  has adopted for its new standard generation, and which were originally  set forth by the <a title="ITU-R" href="http://en.wikipedia.org/wiki/ITU-R">ITU-R</a> organization in its <a title="IMT-Advanced" href="http://en.wikipedia.org/wiki/IMT-Advanced">IMT-Advanced</a> specification. However due to marketing pressures and the significant advancements that <a title="WIMAX" href="http://en.wikipedia.org/wiki/WIMAX">WIMAX</a>, <a title="HSPA+" href="http://en.wikipedia.org/wiki/HSPA%2B">HSPA+</a> and LTE bring to the original 3G technologies, ITU later decided that  LTE together with the aforementioned technologies can be called 4G  technologies. The <a title="LTE Advanced" href="http://en.wikipedia.org/wiki/LTE_Advanced">LTE Advanced</a> standard formally satisfies the <a title="ITU-R" href="http://en.wikipedia.org/wiki/ITU-R">ITU-R</a> requirements to be considered <a title="IMT-Advanced" href="http://en.wikipedia.org/wiki/IMT-Advanced">IMT-Advanced</a>.<sup><a href="http://en.wikipedia.org/wiki/LTE_%28telecommunication%29#cite_note-7"></a></sup> And to differentiate <a title="LTE-Advanced" href="http://en.wikipedia.org/wiki/LTE-Advanced">LTE-Advanced</a> and <a title="Wimax-Advanced (page does not exist)" href="http://en.wikipedia.org/w/index.php?title=Wimax-Advanced&amp;action=edit&amp;redlink=1">Wimax-Advanced</a> from current 4G technologies, ITU has defined them as "True 4G".</p>', '', '2012-12-21', '2014-09-06', 0, 0, 2, 'no', 'no', 'publish'),
(25, 'lte-voice-calls', 'Voice Calls with LTE', 'Voice Calls with LTE', 10, '<p>The LTE standard only supports packet switching with its all-IP network. Voice calls in GSM, UMTS and CDMA2000 are <a title="Circuit switching" href="http://en.wikipedia.org/wiki/Circuit_switching">circuit switched</a>, so with the adoption of LTE, carriers will have to re-engineer their voice call network.Three different approaches sprang up:</p>\n<p><img src="images/400px-LTE-CSFB-E-UTRAN-UTRAN-GERAN-Interfaces.svg_.png" alt="" /></p>\n<ul>\n<li>VoLTE (Voice Over LTE): This approach is based on the <a title="IP Multimedia Subsystem" href="http://en.wikipedia.org/wiki/IP_Multimedia_Subsystem">IP Multimedia Subsystem</a> (IMS) network, with specific profiles for control and media planes of  voice service on LTE defined by GSMA in PRD IR.92. This approach results  in the voice service (control and media planes) being delivered as data  flows within the LTE data bearer. This means that there is no  dependency on (or ultimately, requirement for) the legacy Circuit Switch  voice network to be maintained.</li>\n</ul>\n<ul>\n<li>CSFB (Circuit Switched Fallback): In this approach, LTE just  provides data services, and when a voice call is to be initiated or  received, it will fall back to the CS domain. When using this solution,  operators just need to upgrade the MSC instead of deploying the IMS, and  therefore, can provide services quickly. However, the disadvantage is  longer call setup delay.</li>\n</ul>\n<ul>\n<li>SVLTE (Simultaneous Voice and LTE): In this approach, the handset  works simultaneously in the LTE and CS modes, with the LTE mode  providing data services and the CS mode providing the voice service.  This is a solution solely based on the handset, which does not have  special requirements on the network and does not require the deployment  of IMS either. The disadvantage of this solution is that the phone can  become expensive with high power consumption.</li>\n</ul>', '', '2012-12-21', '2014-09-06', 0, 0, 3, 'no', 'no', 'publish'),
(27, 'no.2', 'No.2', 'No.2', 2, '<p>No.2 noticesssssss</p>', 'c091216', '2013-01-18', '2013-01-18', 0, 0, 0, 'no', 'no', 'publish'),
(28, 'no.3', 'No.3', 'No.3', 2, '<p>Next thing.......................</p>', 'c091216', '2013-01-18', '2013-01-18', 0, 0, 0, 'no', 'no', 'publish'),
(29, 'no.4-;', 'no.4 ;', 'no.4 ;', 2, '<p>This is nonsence</p>', 'c091216', '2013-01-18', '2013-01-18', 0, 0, 0, 'no', 'no', 'publish'),
(30, 'advance-network', 'Advance network', 'Advance network', 11, '<p>A network is conceptual framework.</p>', '888-38-10', '2014-09-09', '2014-09-09', 0, 0, 0, 'no', 'no', 'publish');

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

--
-- Table structure for table `blogs`
--

CREATE TABLE IF NOT EXISTS `blogs` (
  `blog_id` int(11) NOT NULL AUTO_INCREMENT,
  `blog_title` varchar(200) NOT NULL,
  `blog_intro` text NOT NULL,
  `blog_details` text NOT NULL,
  `blog_icon` varchar(50) NOT NULL,
  `posted_by` varchar(20) NOT NULL,
  `blogger_type` enum('student','teacher') NOT NULL,
  `post_date` datetime NOT NULL,
  `read_times` int(11) NOT NULL,
  `likes` int(11) NOT NULL,
  `status` enum('featured','publish','unpublish') NOT NULL DEFAULT 'publish',
  PRIMARY KEY (`blog_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`blog_id`, `blog_title`, `blog_intro`, `blog_details`, `blog_icon`, `posted_by`, `blogger_type`, `post_date`, `read_times`, `likes`, `status`) VALUES
(1, 'U.S. Embassy-Dhaka', '', '<p>Ambassador Mozena talks to journalists at Dinajpur Press Club during his  trip to Dinajpur on November 10.  Ambasssador Mozena said that  constructive dialogue among political  parties is urgently needed to  come to a consensus. Regarding Dr. Yunus,  he said &ldquo;With taking  responsibility, I am telling you that the Grameen  Bank is a good  organization with its policies. I visited different  places of the  country and my experience is the same. The way village  women are  working is only because of Dr. Yunus. The whole world has seen  this.&rdquo;  Regarding Jamaat-e-Islami, Ambassador Mozena said that he and  the U.S.  government believe that everybody has the right to express  their  opinions. However, violence should not take place.</p>', 'us-embassy-icon.jpg', '888-39-06', 'student', '2012-11-12 12:29:39', 12, 0, 'publish'),
(2, 'The power of science friction', '', '<p>Have you ever had the impression that heavy items of furniture start  to take root &ndash; that after years standing in the same place, they&rsquo;re  harder to slide to a new position? Do your best wine glasses, after  standing many months unused in the cabinet, seem slightly stuck to the  shelf? Has the fine sand in the kids&rsquo; play tray set into a lump?</p>\n<p>If  so, you&rsquo;re not just imagining it. The friction between two surfaces in  contact with each other does slowly increase over time. But why? A paper  by two materials scientists at the University of Wisconsin in Madison,  USA, suggests that the surfaces could actually be <a href=\\"http://prl.aps.org/abstract/PRL/v109/i18/e186102\\">slowly chemically bonding together</a>.</p>\n<p>There are already several other explanations for this so-called  &ldquo;frictional ageing&rdquo; effect. One is simply that two surfaces get squashed  closer together. But a curious thing about friction is that the  frictional force opposing sliding doesn&rsquo;t depend on the area of the  contacting surfaces. You&rsquo;d expect the opposite to be the case: more  contact should create more friction. But in fact two surfaces in  apparent contact are mostly not touching at all, because little bumps  and irregularities, called asperities, prop them apart. That&rsquo;s true even  for apparently smooth surfaces like glass, which are still rough at the  microscopic scale. It&rsquo;s only the contacts between these asperities that  cause friction.</p>\n<p>If two surfaces are pushed more firmly together,  the asperities can get deformed and flattened so that more of the  surfaces touch one another, and the friction then gets stronger. This  sort of squashing and increased contact can also happen over time  without any extra pressure, because the materials slowly sag, a process  called creep that occurs for most materials.</p>\n<p>Another cause of  frictional ageing is that water vapour can condense into liquid in all  the tiny crevices at the interface. Even if air is not humid enough for  water droplets to form on a flat surface, they can condense in very  small gaps, a phenomenon called capillary condensation. The surface  tension of the water then holds the surfaces in place and increases  friction. This effect may make powders clump together and resist  flowing, because there are lots of small gaps between grains where water  can condense.</p>\n<p>Yet these effects can&rsquo;t explain all kinds of frictional ageing. For example, last year <a href=\\"http://www.nature.com/nature/journal/v480/n7376/full/nature10589.html\\">a team of US researchers showed</a> that it can happen between two surfaces of silicon dioxide (silica,  which is basically sand or window glass), even when the pressure pushing  them together is too low to induce creep. They figured that the  surfaces must be gradually adhering because of the formation of chemical  bonds between them.</p>', 'science-friction-icon.jpg', '888-39-06', 'student', '2012-11-22 14:04:11', 5, 0, 'publish'),
(3, 'Model View Controller Explained', '', '<p>Model view controller (MVC) is a very useful and popular design pattern.  If you&rsquo;re writing software, you should know it. Unfortunately it&rsquo;s also  one of the hardest to truly understand. In this article I will provide  what I think is the simplest explanation of MVC, and why you should use  it.</p>\n<h4>What is Model View Controller (MVC)?</h4>\n<p>In a typical application you will find these three fundamental parts:</p>\n<ul>\n<li>Data (Model)</li>\n<li>An interface to view and modify the data (View)</li>\n<li>Operations that can be performed on the data (Controller)</li>\n</ul>\n<p><img src=\\"/edesk/images/mvc-fig.jpg\\" alt=\\"\\" width=\\"405\\" height=\\"232\\" /></p>\n<p>The MVC pattern, in a nutshell, is this:</p>\n<ol>\n<li>The <strong>model</strong> represents the data, and does nothing else. The model does NOT depend on the controller or the view.</li>\n<li>The <strong>view</strong> displays the model data, and sends user actions (e.g. button clicks) to the controller. The view can: <ol>\n<li>be independent of both the model and the controller; or</li>\n<li>actually <em>be</em> the controller, and therefor depend on the model.</li>\n</ol> </li>\n<li>The <strong>controller</strong> provides model data to the view, and  interprets user actions such as button clicks. The controller depends  on the view and the model. In some cases, the controller and the view  are the same object.</li>\n</ol>\n<h4>What is the advantage of MVC?</h4>\n<p>Unnecessary complexity is the devil of software development.  Complexity leads to software that is buggy, and expensive to maintain.  The easiest way to make code overly complex is to put dependencies  everywhere. Conversely, removing unnecessary dependencies makes  delightful code that is less buggy and easier to maintain because it is <strong>reusable without modification</strong>. You can happily reuse old, stable code without introducing new bugs into it.</p>\n<p>The primary advantage of the MVC design pattern is this:</p>\n<blockquote>\n<p><strong>MVC makes model classes reusable without modification.</strong></p>\n</blockquote>\n<p>The purpose of the controller is to remove the view dependency from  the model. By removing the view dependency from the model, the model  code becomes delightful.</p>\n<p>Why is the model code so delightful? Let&rsquo;s continue with the address  book application example. The project manager approaches the developer  and says &ldquo;<em>We love the contact list window, but we need a second  window that displays all the contacts by their photos only. The photos  should be in a table layout, with five photos per row</em>.&rdquo;</p>\n<p>If the application uses MVC, this task is pretty straight forward.  Currently there are three classes: Person, PersonListController, and  PersonListView. Two classes need to be created: PersonPhotoGridView and&nbsp;  PersonPhotoGridController. The Person class remains the same, and is  easily plugged into the two different views. How delightful.</p>', 'mvc-icon.jpg', '888-38-05', 'student', '2012-11-18 13:09:12', 30, 0, 'publish'),
(4, 'The Windows-versus-Linux server face-off', '', '<p>Linux certainly has  established itself as a prominent server OS these days, pushing Unix  into the background. But the open source OS shares the stage with  commercial software giant Microsoft, which remains a dominant player  with Windows Server.</p>\r\n<img src=\\"/edesk/images/Windows-vs.-Linux1_.jpg\\" alt=\\"\\" width=\\"351\\" height=\\"145\\" />\r\n<p><strong>[ The</strong> <strong><strong><strong>InfoWorld</strong> <a href=\\"http://www.infoworld.com/article/08/02/25/09TC-windows-server-2008_1.html?source=fssr\\">Test Center rates Windows Server 2008</a>. | Why <a href=\\"http://www.infoworld.com/article/08/06/09/Linux_beats_Windows_2008_powersaving_measures_1.html?source=fssr\\">Linux is greener</a> than Windows Server. | Has <a href=\\"http://www.infoworld.com/article/08/09/24/39NF-linux-killing-solaris_1.html?source=fssr\\">Linux killed OpenSolaris</a>? ]</strong></strong></p>\r\n<p>A  lot of Linux usage is in Web server applications, but it\\''s become  increasingly common in mission-critical applications, Weiss notes. But  \\"I don\\''t have an indicator that says Linux is chewing up the market for  Windows,\\" he adds.</p>\r\n<p>Other forms of Unix  continue to fade away in what is becoming a two-OS choice for IT. \\"The  key here is that really Linux and Windows are moving away from the pack  here and it\\''s becoming a two-horse race,\\" says Jim Zemlin, executive  director of the Linux Foundation.</p>\r\n<p><strong>Both Linux and Windows Server see datacenter growth<br /> </strong>Regarding  migration of current workloads, 43 percent of respondents in a Gartner  survey at a Linux-oriented conference anticipated migrating mostly from  Unix to Linux, 13 percent said they would migrate mostly from Windows to  Linux, and only 4 percent said they would switch off Linux to go to  Windows. Twenty-one percent had no plans to migrate workloads.</p>\r\n<p>Gartner  expects IT organizations to shift their focus to more-complex Linux  deployments and continue a trend of migration from Unix. Gartner found  that 52 percent of respondents anticipate that the total workload of  their Linux server environment will increase moderately in 2008; another  25 percent said there would be a substantial increase. Only 5 percent  anticipated moderate decrease, while 4 percent expected a substantial  decrease in Linux workloads for this year. Respondents were three times  more likely to migrate workloads from Unix to Linux than from Windows to  Linux.</p>\r\n<p>Although Linux growth is strong, so  is that of Windows Server, according to Gartner\\''s research. Linux was  ranked by 39 percent of respondents as the OS expected to have the most  growth in their datacenters during the next five years. Windows was a  close second, ranked as the OS with the most growth potential by 35  percent of respondents at the Linux-oriented conference.</p>\r\n<p>Based  on Gartner\\''s annual estimates for worldwide server shipment revenues,  both Windows Server and Linux will increase. Windows Server sales will  move from about $20 billion last year to roughly $22 billion in 2012;  Linux will grow from about $9 billion last year to $12 billion in three  years. But because Linux is often provided at no cost (with vendors  making revenues from support contracts and other services), those  numbers may not be comparable.</p>', 'win-v-linux-icon.jpg', '888-38-05', 'student', '2012-11-18 13:17:04', 242, 0, 'publish'),
(6, 'Introduction to n-Tier Architecture', '', '<h2><a name=\\"two-tier\\">What is two-tier architecture?</a></h2>\r\n<p>The two-tier architecture is refers to client/ server architectures as  well, the term client/ server was first used in the 1980s in reference  to personal computers (PCs) on a network. The actual client/ server  model started gaining acceptance in the late 1980s, and later it was  adapted to World Wide Web <span>programming</span>.</p>\r\n<p><img src=\\"images/2-Tier1.jpg\\" alt=\\"2-Tier1.jpg\\" /></p>\r\n<p>According to the modern days use of two-tier architecture the user  interfaces (or with ASP.NET, all web pages) runs on the client and the  database is stored on the server. The actual application logic can run  on either the client or the server. So in this case the user interfaces  are directly access the database. Those can also be non-interface  processing engines, which provide solutions to other remote/ local  systems. In either case, today the two-tier model is not as reputed as  the three-tier model. The advantage of the two-tier design is its  simplicity, but the simplicity comes with the cost of scalability. The  newer three-tier architecture, which is more famous, introduces a middle  tier for the application logic.</p>\r\n<h2><a name=\\"three-tier\\">What is three-tier architecture?</a></h2>\r\n<p>The three tier software architecture (also known as three layer  architectures) emerged in the 1990s to overcome the limitations of the  two tier architecture. This architecture has aggressively customized and  adopted by modern day system designer to web systems.</p>\r\n<p>Three-tier is a client-server architecture in which the user  interface, functional process logic, data storage and data access are  developed and maintained as independent modules, some time on separate  platforms. The term \\"<em>three-tier</em>\\" or \\"<em>three-layer</em>\\", as  well as the concept of multi-tier architectures (often refers to as  three-tier architecture), seems to have originated within Rational  Software.</p>\r\n<p><img src=\\"images/3-Tier3.jpg\\" alt=\\"3-Tier3.jpg\\" /></p>\r\n<p>The 3-Tier architecture has the following three tiers.</p>\r\n<ol>\r\n<li><strong>Presentation Tier or Web Server</strong>: User Interface, displaying/ accepting data/ input to/ from the user </li>\r\n<li><strong>Application Logic/ Business Logic/ Transaction Tier or Application Server</strong>:  Data validation, acceptability check before being added to the database  and all other business/ application specific operations </li>\r\n<li><strong>Data Tier or Database server</strong>: Simple reading and writing method to database or any other storage, connection, command, stored procedures etc </li>\r\n</ol>', 'blico-58603515.jpg', '888-39-06', 'student', '2012-12-13 13:09:43', 17, 0, 'publish'),
(7, 'Introducing Service Oriented Architechture (SOA)', '', '<p>A service-<span>oriented</span> architecture is  essentially a collection of services. These services communicate with  each other. The communication can involve either simple data passing or  it could involve two or more services coordinating some activity. Some  means of connecting services to each other is needed. The .Net technology introduces the SOA by mean of web services.</p>\r\n<p>The SOA can be used as the concept to connect multiple systems to  provide services. It has it\\''s great share in the future of the IT world.</p>\r\n<p><img src=\\"images/SOA.jpg\\" alt=\\"SOA.jpg\\" /></p>\r\n<p>According to the imaginary diagram above, we can see how the Service <span>Oriented</span> Architecture is being used to provide a set of centralized services to  the citizens of a country. The citizens are given a unique identifying  card, where that card carries all personal information of each citizen.  Each service centers such as shopping complex, hospital, station, and  factory are equipped with a computer system where that system is  connected to a central server, which is responsible of providing service  to a city. As an example when a customer enter the shopping complex the  regional computer system report it to the central server and obtain  information about the customer before providing access to the premises.  The system welcomes the customer. The customer finished the shopping and  then by the time he leaves the shopping complex, he will be asked to go  through a billing process, where the regional computer system will  manage the process. The payment will be automatically handled with the  input details obtain from the customer identifying card.</p>\r\n<p>The regional system will report to the city (computer system of the  city) while the city will report to the country (computer system of the  country).</p>', 'blico-21922912.jpg', '888-38-05', 'student', '2012-12-13 13:46:20', 43, 0, 'publish');

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

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

CREATE TABLE IF NOT EXISTS `categories` (
  `cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(100) NOT NULL,
  `cat_alias` varchar(100) NOT NULL,
  `page_title` varchar(100) NOT NULL,
  `privilege` enum('admin','student','teacher','alumni') NOT NULL DEFAULT 'admin' COMMENT 'this data will tell who will get access to articles under this category',
  `status` enum('publish','unpublish') NOT NULL DEFAULT 'publish',
  PRIMARY KEY (`cat_id`),
  UNIQUE KEY `category_alias` (`cat_alias`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

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

INSERT INTO `categories` (`cat_id`, `cat_name`, `cat_alias`, `page_title`, `privilege`, `status`) VALUES
(1, 'Admission Information', 'admission-info', 'Admission Information', 'admin', 'publish'),
(2, 'Students Articles', 'students-articles', 'Students Articles', 'student', 'publish'),
(3, 'General Articles', 'general-articles', 'General Articles', 'admin', 'publish'),
(6, 'Cloud Computing', 'cloud-computing', 'Cloud Computing', 'admin', 'publish'),
(7, 'About SUB', 'about-sub', 'About SUB', 'admin', 'publish'),
(8, 'Ad hoc Networks', 'ad-hoc-networks', 'Ad hoc Networks', 'admin', 'publish'),
(9, 'Third Generation Solid State Drives', 'Third-Generation-Solid-State-Drives', 'Third Generation Solid State Drives', 'admin', 'publish'),
(10, 'Network Optimization with LTE', 'lte-network-optimization', 'Network Optimization with LTE', 'admin', 'publish'),
(11, 'about broadband technology', 'broadband', 'broadband technology', 'student', 'publish');

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

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `cmnt_id` int(11) NOT NULL AUTO_INCREMENT,
  `blog_id` int(11) NOT NULL,
  `cmnt_by` varchar(20) NOT NULL,
  `cmnt_text` text NOT NULL,
  `cmnt_date` datetime NOT NULL,
  `status` enum('publish','unpublish') NOT NULL DEFAULT 'publish',
  PRIMARY KEY (`cmnt_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`cmnt_id`, `blog_id`, `cmnt_by`, `cmnt_text`, `cmnt_date`, `status`) VALUES
(1, 7, 'c091216', 'Outstanding article... Thanks.. I have been waiting for something like this from long time. It now helps my research on SOA. Thanks Again. Carry on.', '2013-01-02 23:43:52', 'publish'),
(2, 7, 'c091216', 'If you have ideas other than this on SOA, please share me here. I am doing my research on this topic, so it helps me a lot. ', '2013-01-03 00:06:28', 'publish'),
(5, 7, 'c091216', 'this is nothing :p ', '2013-01-18 15:17:51', 'publish'),
(6, 7, 'c091216', 'hhhhhhhhhhhhhhhh', '2013-01-22 03:41:14', 'publish'),
(7, 3, 'c091212', 'pppppppppp', '2014-09-06 13:07:46', 'publish'),
(8, 6, '888-39-06', 'Wow great', '2014-09-06 15:13:22', 'publish');

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

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

CREATE TABLE IF NOT EXISTS `courses` (
  `course_code` varchar(10) NOT NULL,
  `course_title` varchar(50) NOT NULL,
  `credit_hours` float NOT NULL,
  `contact_hours` float NOT NULL,
  `preq_course` varchar(10) NOT NULL COMMENT 'Prerequisite Course Code',
  `department_id` int(11) NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active' COMMENT 'This field shows if this course is currently offered or not',
  PRIMARY KEY (`course_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `courses` (`course_code`, `course_title`, `credit_hours`, `contact_hours`, `preq_course`, `department_id`, `status`) VALUES
('BBA-1234', 'Management', 2, 3, '', -1, 'active'),
('CSE-1022', 'Structured Programming Lab', 1.5, 1.5, '', 2, 'active'),
('CSE-1024', 'Computer Fundamentals Lab', 1.5, 1.5, '', 2, 'active'),
('CSIT-1021', 'Structured Programming', 3, 3, '', 2, 'active'),
('CSIT-1023', 'Computer Fundamentals', 3, 3, '', 2, 'active'),
('CSIT-2021', 'Data Structures', 3, 3, '', 2, 'active'),
('CSIT-2023', 'Object Oriented Programming [C++]', 3, 3, '', 2, 'active'),
('CSIT3200', 'Broadband', 3, 3, '', 2, 'active'),
('EEE-1027', 'Basic Electronics [Electronics I]', 3, 3, '', 2, 'active'),
('EEE-2027', 'Digital Logic Design', 3, 3, '', 2, 'active'),
('MAT-1011', 'Elementary Mathmatics [Math I]', 3, 3, '', 2, 'active'),
('PHY-1025', 'Elementary Physics [Physics I]', 3, 3, '', 2, 'active');

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

--
-- Table structure for table `course_materials`
--

CREATE TABLE IF NOT EXISTS `course_materials` (
  `cm_id` int(11) NOT NULL AUTO_INCREMENT,
  `cm_title` varchar(100) NOT NULL,
  `cm_type` enum('file','article') NOT NULL DEFAULT 'article',
  `cm_details` text NOT NULL,
  `file_link` varchar(100) NOT NULL,
  `importance` enum('high','normal') NOT NULL DEFAULT 'normal',
  `course_code` varchar(20) NOT NULL,
  `posted_by` varchar(20) NOT NULL,
  `user_type` enum('student','teacher') NOT NULL DEFAULT 'student',
  `date_posted` date NOT NULL,
  `date_expires` date NOT NULL,
  PRIMARY KEY (`cm_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `course_materials`
--

INSERT INTO `course_materials` (`cm_id`, `cm_title`, `cm_type`, `cm_details`, `file_link`, `importance`, `course_code`, `posted_by`, `user_type`, `date_posted`, `date_expires`) VALUES
(3, 'Project Requirements', 'file', '', 'Project Module.doc', 'normal', 'CSE-1021', '888-38-05', 'student', '2012-12-02', '0000-00-00'),
(5, 'The Birth and history of C Programming Language', 'article', '<p>The C language shook the computer world. Its impact should not be underestimated, because it fundamentally changed the way programming was approached and thought about. The creation of C was a direct result of the need for a structured, efficient, highlevel language that could replace assembly code when creating systems programs. As you probably know, when a computer language is designed, trade-offs are often made, such as the following:</p>\n<ul>\n<li>Ease-of-use versus power</li>\n<li>Safety versus efficiency</li>\n<li>Rigidity versus extensibility</li>\n</ul>\n<p>Prior to C, programmers usually had to choose between languages that optimized one set of traits or the other. For example, although FORTRAN could be used to write fairly efficient programs for scientific applications, it was not very good for systems code. And while BASIC was easy to learn, it wasn\\''t very powerful, and its lack of structure made its usefulness questionable for large programs. Assembly language can be used to produce highly efficient programs, but it is not easy to learn or use effectively. Further, debugging assembly code can be quite difficult.</p>\n<p>Another compounding problem was that early computer languages such as BASIC, COBOL, and FORTRAN were not designed around structured principles. Instead, they relied upon the GOTO as a primary means of program control. As a result, programs written using these languages tended to produce \\"spaghetti code\\"&mdash;a mass of tangled jumps and conditional branches that make a program virtually impossible to understand. While languages like Pascal are structured, they were not designed for efficiency, and failed to include certain features necessary to make them applicable to a wide range of programs. (Specifically, given the standard dialects of Pascal available at the time, it was not practical to consider using Pascal for systems-level code.)</p>\n<p>So, just prior to the invention of C, no one language had reconciled the conflicting attributes that had dogged earlier efforts. Yet the need for such a language was pressing. By the early 1970s, the computer revolution was beginning to take hold, and the demand for software was rapidly outpacing programmers\\'' ability to produce it. A great deal of effort was being expended in academic circles in an attempt to create a better computer language. But, and perhaps most importantly, a secondary force was beginning to be felt. Computer hardware was finally becoming common enough that a critical mass was being reached. No longer were computers kept behind locked doors. For the first time, programmers were gaining virtually unlimited access to their machines. This allowed the <br />freedom to experiment. It also allowed programmers to begin to create their own tools. On the eve of C\\''s creation, the stage was set for a quantum leap forward in computer languages.</p>\n<p>Invented and first implemented by Dennis Ritchie on a DEC PDP-11 running the UNIX operating system, C was the result of a development process that started with an older language called BCPL, developed by Martin Richards. BCPL influenced a language called B, invented by Ken Thompson, which led to the development of C in the 1970s. For many years, the de facto standard for C was the one supplied with the UNIX operating system and described in <em>The C Programming Language </em>by Brian Kernighan and Dennis Ritchie (Prentice-Hall, 1978). C was formally standardized in December <br />1989, when the American National Standards Institute (ANSI) standard for C was adopted.</p>\n<p>The creation of C is considered by many to have marked the beginning of the modern age of computer languages. It successfully synthesized the conflicting attributes that had so troubled earlier languages. The result was a powerful, efficient, structured language that was relatively easy to learn. It also included one other, nearly intangible aspect: it was a <em>programmer\\''s </em>language. Prior to the invention of C, computer languages were generally designed either as academic exercises or by bureaucratic committees. C is different. It was designed, implemented, and developed by real, working programmers, reflecting the way that they approached the job of programming. Its features were honed, tested, thought about, and rethought by the people who actually used the language. The <br />result was a language that programmers liked to use. Indeed, C quickly attracted many followers who had a near-religious zeal for it. As such, it found wide and rapid acceptance in the programmer community. In short, C is a language designed by and for programmers.</p>', '', 'normal', 'CSE-1021', '888-38-05', 'student', '2012-12-03', '0000-00-00'),
(6, 'The for statement in C', 'article', '<p>There are plenty of different ways to write a program for a particular task. Let\\''s try a variation on the temperature converter.</p>\n<pre>   #include &lt;stdio.h&gt;\n\n   /* print Fahrenheit-Celsius table */\n   main()\n   {\n       int fahr;\n\n       for (fahr = 0; fahr &lt;= 300; fahr = fahr + 20)\n           printf(\\"%3d %6.1f\\\\n\\", fahr, (5.0/9.0)*(fahr-32));\n   }\n</pre>\n<p>This produces the same answers, but it certainly looks different. One major change is the elimination of most of the variables; only <tt>fahr</tt> remains, and we have made it an <tt>int</tt>. The lower and upper limits and the step size appear only as constants in the <tt>for</tt> statement, itself a new construction, and the expression that computes the Celsius temperature now appears as the third argument of <tt>printf</tt> instead of a separate assignment statement.</p>\n<p>This last change is an instance of a general rule - in any context where it is permissible to use the value of some type, you can use a more complicated expression of that type. Since the third argument of <tt>printf</tt> must be a floating-point value to match the <tt>%6.1f</tt>, any floating-point expression can occur here.</p>\n<p>The <tt>for</tt> statement is a loop, a generalization of the <tt>while</tt>. If you compare it to the earlier <tt>while</tt>, its operation should be clear. Within the parentheses, there are three parts, separated by semicolons. The first part, the initialization</p>\n<pre>   fahr = 0\n</pre>\n<p>is done once, before the loop proper is entered. The second part is the test or condition that controls the loop:</p>\n<pre>   fahr &lt;= 300\n</pre>\n<p>This condition is evaluated; if it is true, the body of the loop (here a single <tt>ptintf</tt>) is executed. Then the increment step</p>\n<pre>   fahr = fahr + 20\n</pre>\n<p>is executed, and the condition re-evaluated. The loop terminates if the condition has become false. As with the <tt>while</tt>, the body of the loop can be a single statement or a group of statements enclosed in braces. The initialization, condition and increment can be any expressions.</p>\n<p>The choice between <tt>while</tt> and <tt>for</tt> is arbitrary, based on which seems clearer. The <tt>for</tt> is usually appropriate for loops in which the initialization and increment are single statements and logically related, since it is more compact than <tt>while</tt> and it keeps the loop control statements together in one place.</p>', '', 'normal', 'CSE-1021', '888-38-05', 'student', '2012-12-03', '0000-00-00'),
(7, 'What is the difference between an Interface and an Abstract class?', 'article', '<p>There are quite a big difference between an <em>interface </em>and an <em>abstract class</em>, even though both look similar.</p>\n<ul>\n<li>Interface definition begins with a keyword interface so it is of type interface </li>\n<li>Abstract classes are declared with the abstract keyword so it is of type class </li>\n<li>Interface has no implementation, but they have to be implemented. </li>\n<li>Abstract class&rsquo;s methods can have implementations and they have to be extended. </li>\n<li>Interfaces can only have method declaration (implicitly public and abstract) and fields (implicitly public static) </li>\n<li>Abstract class&rsquo;s methods can&rsquo;t have implementation only when declared abstract. </li>\n<li>Interface can inherit more than one interfaces </li>\n<li>Abstract class can implement more than one interfaces, but can inherit only one class </li>\n<li>Abstract class must override all abstract method and may override virtual methods </li>\n<li>Interface can be used when the implementation is changing </li>\n<li>Abstract class can be used to provide some default behavior for a base class. </li>\n<li>Interface makes implementation interchangeable </li>\n<li>Interface increase security by hiding the implementation </li>\n<li>Abstract class can be used when implementing framework </li>\n<li>Abstract classes are an excellent way to create planned inheritance  hierarchies and also to use as non-leaf classes in class hierarchies. </li>\n</ul>\n<p>Abstract classes let you define some behaviors; they force your  subclasses to provide others. For example, if you have an application  framework, an abstract class can be used to provide the default  implementation of the services and all mandatory modules such as event  logging and message handling etc. This approach allows the developers to  develop the application within the guided help provided by the  framework.</p>\n<p>However, in practice when you come across with some  application-specific functionality that only your application can  perform, such as startup and shutdown tasks etc. The abstract base class  can declare virtual shutdown and startup methods. The base class knows  that it needs those methods, but an abstract class lets your class admit  that it doesn\\''t know how to perform those actions; it only knows that  it must initiate the actions. When it is time to start up, the abstract  class can call the startup method. When the base class calls this  method, it can execute the method defined by the child class.</p>', '', 'normal', 'CSE-1021', '888-38-05', 'student', '2012-12-13', '0000-00-00'),
(8, 'What is Polymorphisms?', 'article', '<h2><a name=\\"Polymorphism\\"></a></h2>\n<p>Polymorphisms is a generic term that means \\''many shapes\\''. More precisely <em>Polymorphisms </em>means the ability to request that the same operations be performed by a wide range of different types of things.</p>\n<p>At times, I used to think that understanding <span>Object</span> <span>Oriented</span> <span>Programming</span> concepts have made it difficult since they have grouped under four main  concepts, while each concept is closely related with one another. Hence  one has to be extremely careful to correctly understand each concept  separately, while understanding the way each related with other  concepts.</p>\n<p>In <em>OOP </em>the <em>polymorphisms </em>is achieved by using many different techniques named method overloading, operator overloading and method overriding,</p>', '', 'normal', 'CSE-2023', '888-38-05', 'student', '2012-12-13', '0000-00-00'),
(9, 'Object and Class Concept in OOP', 'article', '<h2><a name=\\"Object\\">What is an <span>Object</span>?</a></h2>\n<p>An <span>object</span> can be considered a \\"<em>thing</em>\\" that can perform a set of <strong>related </strong>activities. The set of activities that the <span>object</span> performs defines the <span>object</span>\\''s behavior. For example, the hand can grip something or a <em>Student </em>(<em><span>object</span></em>) can give the name or address.</p>\n<p>In pure <em>OOP </em>terms an <span>object</span> is an instance of a class.</p>\n<h2><a name=\\"Class\\">What is a Class?</a></h2>\n<p><img src=\\"images/class.gif\\" alt=\\"\\" /></p>\n<p>A <em>class </em>is simply a representation of a type of <em><span>object</span></em>. It is the blueprint/ plan/ template that describe the details of an <em><span>object</span></em>. A class is the blueprint from which the individual <span>object</span>s are created. <em>Class </em>is composed of three things: a name, attributes, and operations.</p>\n<pre id=\\"pre0\\" style=\\"margin-top: 0pt;\\"><span>public</span> <span>class</span> Student\n{<br />     //class body<br />&nbsp;}\n</pre>\n<p>According to the sample given below we can say that the <em>student </em><span>object</span>, named <em><span>object</span>Student</em>, has created out of the <em>Student </em>class.</p>\n<pre id=\\"pre1\\" style=\\"margin-top: 0pt;\\">Student <span>object</span>Student = <span>new</span> Student();\n</pre>\n<p>In real world, you\\''ll often find many individual <span>object</span>s  all of the same kind. As an example, there may be thousands of other  bicycles in existence, all of the same make and model. Each bicycle has  built from the same blueprint. In <span>object</span>-<span>oriented</span> terms, we say that the bicycle is an instance of the class of <span>object</span>s known as bicycles.</p>\n<p>In the software world, though you may not have realized it, you have already used classes. For example, the <em>TextBox </em>control, you always used, is made out of the <em>TextBox </em>class, which defines its appearance and capabilities. Each time you drag a <em>TextBox </em>control, you are actually creating a new instance of the <em>TextBox </em>class.</p>\n<h2><a name=\\"identify\\">How to identify and design a Class?</a></h2>\n<p>This is an art; each designer uses different techniques to identify classes. However according to <span>Object</span> <span>Oriented</span> Design Principles, there are five principles that you must follow when design a class,</p>\n<ul>\n<li>SRP - The Single Responsibility Principle - <br />A class should have one, and only one, reason to change. </li>\n<li>OCP - The Open Closed Principle - <br />You should be able to extend a classes behavior, without modifying it. </li>\n<li>LSP - The Liskov Substitution Principle- <br />Derived classes must be substitutable for their base classes. </li>\n<li>DIP - The Dependency Inversion Principle- <br />Depend on abstractions, not on concretions. </li>\n<li>ISP - The Interface Segregation Principle- <br />Make fine grained interfaces that are client specific. </li>\n</ul>\n<p>For more information on design principles, please refer to <a title=\\"What Is Object-Oriented Design?\\" href=\\"http://www.objectmentor.com/omSolutions/oops_what.html\\"><span>Object</span> Mentor</a>.</p>\n<p>Additionally to identify a class correctly, you need to identify the  full list of leaf level functions/ operations of the system (granular  level use cases of the system). Then you can proceed to group each  function to form classes (classes will group same types of functions/  operations). However a well defined class must be a meaningful grouping  of a set of functions and should support the re-usability while  increasing expandability/ maintainability of the overall system.</p>\n<p>In software world the concept of dividing and conquering is always  recommended, if you start analyzing a full system at the start, you will  find it harder to manage. So the better approach is to identify the  module of the system first and then dig deep in to each module  separately to seek out classes.</p>\n<p>A software system may consist of many classes. But in any case, when  you have many, it needs to be managed. Think of a big organization, with  its work force exceeding several thousand employees (let&rsquo;s take one  employee as a one class). In order to manage such a work force, you need  to have proper management policies in place. Same technique can be  applies to manage classes of your software system as well. In order to  manage the classes of a software system, and to reduce the complexity,  the system designers use several techniques, which can be grouped under  four main concepts named Encapsulation, Abstraction, Inheritance, and <em>Polymorphism</em>. These concepts are the four main gods of <em>OOP </em>world and in software term, they are called four main <span>Object</span> <span>Oriented</span> <span>Programming</span> (<em>OOP</em>) Concepts.</p>', '', 'normal', 'CSE-2023', '888-38-05', 'student', '2012-12-13', '0000-00-00'),
(10, 'Broadband', 'file', '', 'ims_eng (1).doc', 'normal', 'CSIT3200', '888-38-10', 'student', '2014-09-07', '0000-00-00');

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

--
-- Table structure for table `course_registration`
--

CREATE TABLE IF NOT EXISTS `course_registration` (
  `course_code` varchar(20) NOT NULL,
  `student_id` varchar(20) NOT NULL,
  PRIMARY KEY (`course_code`,`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_registration`
--

INSERT INTO `course_registration` (`course_code`, `student_id`) VALUES
('CSE-1021', '888-38-01'),
('CSE-1021', '888-38-05'),
('CSE-1021', 'c091201'),
('CSE-1021', 'c091216'),
('CSE-1022', '888-38-01'),
('CSE-1022', '888-38-05'),
('CSE-1022', '888-39-06'),
('CSE-1022', 'c091201'),
('CSE-1022', 'c091216'),
('CSE-1023', '888-38-01'),
('CSE-1023', '888-38-05'),
('CSE-1023', 'c091201'),
('CSE-1023', 'c091216'),
('CSE-1024', '888-38-01'),
('CSE-1024', '888-38-05'),
('CSE-1024', '888-39-06'),
('CSE-1024', 'c091201'),
('CSE-1024', 'c091216'),
('CSE-2021', '888-38-01'),
('CSE-2023', 'c091216'),
('CSIT-1021', '888-38-05'),
('CSIT-2021', '888-38-10'),
('CSIT-2023', '888-38-10'),
('CSIT3200', '888-38-10'),
('EEE-1027', 'c091201'),
('EEE-1027', 'c091216'),
('EEE-2027', '888-39-06'),
('MAT-1011', '888-39-06'),
('MAT-1011', 'c091201'),
('PHY-1025', '888-39-06'),
('PHY-1025', 'c091201');

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

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

CREATE TABLE IF NOT EXISTS `departments` (
  `department_id` int(11) NOT NULL AUTO_INCREMENT,
  `department_code` varchar(10) NOT NULL,
  `department_name` varchar(100) NOT NULL,
  `cat_id` int(11) NOT NULL COMMENT 'article of this category will be the articles of this department',
  PRIMARY KEY (`department_id`),
  UNIQUE KEY `department_code` (`department_code`,`department_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

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

INSERT INTO `departments` (`department_id`, `department_code`, `department_name`, `cat_id`) VALUES
(2, 'CSIT', 'Bachelor Compurter Science & IT', 0),
(3, 'BBA', 'Bachelor of Business Administration', 0),
(4, 'LLB', 'Bachelor of Law', 0),
(5, 'BPHARM', 'Bachelor of Pharmacy', 0),
(6, 'ELL', 'Bachelor of Arts in English', 0),
(7, 'EEE', 'Bachelor of Elerctrical & Electronics Eng', 0),
(8, 'MSCSIT', 'Master of Science in Computer Science & IT', 0);

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

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

CREATE TABLE IF NOT EXISTS `downloads` (
  `dl_id` int(11) NOT NULL AUTO_INCREMENT,
  `dl_title` varchar(200) NOT NULL,
  `dl_filename` varchar(100) NOT NULL,
  `date_posted` date NOT NULL,
  `status` enum('publish','unpublish') NOT NULL DEFAULT 'publish',
  PRIMARY KEY (`dl_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

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

INSERT INTO `downloads` (`dl_id`, `dl_title`, `dl_filename`, `date_posted`, `status`) VALUES
(4, 'e-desk database', 'edesk_db.sql', '0000-00-00', 'publish'),
(5, 'article', 'ims_eng.doc', '0000-00-00', 'publish');

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

--
-- Table structure for table `events`
--

CREATE TABLE IF NOT EXISTS `events` (
  `event_id` int(11) NOT NULL AUTO_INCREMENT,
  `event_type` enum('seminar','workshop','training','conference') NOT NULL DEFAULT 'seminar',
  `event_title` varchar(100) NOT NULL,
  `short_intro` text NOT NULL,
  `event_icon` varchar(100) NOT NULL,
  `department_id` int(11) NOT NULL,
  `event_date` date NOT NULL,
  `event_venue` varchar(100) NOT NULL DEFAULT 'Coming Soon...',
  `reg_required` enum('yes','no') NOT NULL DEFAULT 'yes',
  `capacity` int(11) NOT NULL,
  `reg_starts` date NOT NULL,
  `reg_deadline` date NOT NULL,
  `cat_id` int(11) NOT NULL COMMENT 'article of this category will be the articles of this event',
  `status` enum('active','expired','cancelled','pending') NOT NULL DEFAULT 'pending',
  PRIMARY KEY (`event_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`event_id`, `event_type`, `event_title`, `short_intro`, `event_icon`, `department_id`, `event_date`, `event_venue`, `reg_required`, `capacity`, `reg_starts`, `reg_deadline`, `cat_id`, `status`) VALUES
(1, 'seminar', 'ITIL Version 3 Foundation', 'IT Service Management (ITSM) derives enormous benefits from a best practice approach. Because ITSM is driven both by technology and the huge range of organisational environments in which it operates, it is in a state of constant evolution. Best practice, based on expert advice and input from ITIL users is both current and practical, combining the latest thinking with sound, common sense guidance.', '0', 2, '2012-12-13', 'SUB Campus', 'no', 0, '0000-00-00', '0000-00-00', 0, 'expired'),
(2, 'seminar', 'Ad-hoc Network', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec mol bibendum nunc rte. Lorem ipsum dolor sit amet,consectetuer ewr adipiscing e. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec mol bibendum nunc rte. Lorem ipsum dolor sit amet,consectetuer ewr adipiscing e. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec mol bibendum nunc rte. Lorem ipsum dolor sit amet,consectetuer ewr adipiscing e.', '0', 2, '2013-02-01', 'Coming Soon...', 'no', 0, '0000-00-00', '0000-00-00', 8, 'active'),
(3, 'workshop', 'Cloud Computing - the new generation in networking', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec mol bibendum nunc rte. Lorem ipsum dolor sit amet,consectetuer ewr adipiscing e. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec mol bibendum nunc rte. Lorem ipsum dolor sit amet,consectetuer ewr adipiscing e. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec mol bibendum nunc rte. Lorem ipsum dolor sit amet,consectetuer ewr adipiscing e.', '0', 2, '2014-03-23', 'Coming Soon...', 'yes', 50, '2014-01-01', '2014-03-10', 6, 'active'),
(4, 'seminar', 'Enhancing LAN Using Cryptography and Other Modules', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec mol bibendum nunc rte. Lorem ipsum dolor sit amet,consectetuer ewr adipiscing e. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec mol bibendum nunc rte. Lorem ipsum dolor sit amet,consectetuer ewr adipiscing e. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec mol bibendum nunc rte. Lorem ipsum dolor sit amet,consectetuer ewr adipiscing e.', '0', 2, '2013-02-20', 'Coming Soon...', 'no', 0, '0000-00-00', '0000-00-00', 0, 'active'),
(5, 'workshop', 'Yii PHP Framework in Web Application', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec mol bibendum nunc rte. Lorem ipsum dolor sit amet,consectetuer ewr adipiscing e. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec mol bibendum nunc rte. Lorem ipsum dolor sit amet,consectetuer ewr adipiscing e. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec mol bibendum nunc rte. Lorem ipsum dolor sit amet,consectetuer ewr adipiscing e.', '0', 2, '2013-01-20', 'Coming Soon...', 'yes', 0, '2012-12-01', '2013-01-01', 0, 'active'),
(6, 'seminar', 'Third Generation Solid State Drives', 'The explosion of flash memory technology has dramatically increased storage capacity and decreased the cost of non-volatile semiconductor memory. The technology has fueled the proliferation of USB flash drives and is now poised to replace magnetic hard disks in some applications. A solid state drive (SSD) is a non-volatile memory system that emulates a magnetic hard disk drive (HDD). SSDs do not contain any moving parts, however, and depend on flash memory chips to store data.', '0', 2, '2014-04-17', 'Coming Soon...', 'yes', 50, '2014-01-10', '2014-04-10', 9, 'active'),
(7, 'conference', '4G+ Network Optimization with LTE', 'LTE (Long Term Evolution) is a wireless broadband technology designed to support roaming Internet access via cell phones and handheld devices. Because LTE offers significant improvements over older cellular communication standards, some refer to it as a 4G (fourth generation) technology along with WiMax.', '', 2, '2014-06-15', 'Engineers Institution, Chittagong', 'yes', 200, '2014-01-01', '2014-05-01', 10, 'active'),
(8, 'workshop', 'broadband technology', 'it is presentation about broadband technology', '', 2, '2014-09-11', 'SUB campus', 'yes', 10, '2014-09-09', '2014-09-10', 0, 'active');

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

--
-- Table structure for table `event_registration`
--

CREATE TABLE IF NOT EXISTS `event_registration` (
  `event_id` int(11) NOT NULL,
  `student_id` varchar(20) NOT NULL,
  `reg_date` date NOT NULL,
  `reg_status` enum('pending','registered','rejected') NOT NULL DEFAULT 'pending',
  PRIMARY KEY (`event_id`,`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `event_registration`
--

INSERT INTO `event_registration` (`event_id`, `student_id`, `reg_date`, `reg_status`) VALUES
(7, 'c091201', '2013-01-22', 'pending'),
(7, 'c091216', '2013-01-22', 'pending'),
(8, '888-38-05', '2014-09-07', 'registered');

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

--
-- Table structure for table `forum_questions`
--

CREATE TABLE IF NOT EXISTS `forum_questions` (
  `ques_id` int(11) NOT NULL AUTO_INCREMENT,
  `ques_title` varchar(200) NOT NULL,
  `ques_details` text NOT NULL,
  `keywords` varchar(500) NOT NULL,
  `posted_by` varchar(20) NOT NULL,
  `post_date` datetime NOT NULL,
  `status` enum('publish','unpublish','solved') NOT NULL DEFAULT 'publish',
  PRIMARY KEY (`ques_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `forum_questions`
--

INSERT INTO `forum_questions` (`ques_id`, `ques_title`, `ques_details`, `keywords`, `posted_by`, `post_date`, `status`) VALUES
(1, 'How to Run Turbo C++ In Full-Screen on Windows 7 / Vista', '<p>Hi All,</p>\r\n<p>I am a newbie in C++ Programming. I have Windows 7 installed on my  PC. Can anyone tell me exactly how could I be able to run Turbo C++ in  full screen mode??</p>\r\n<p>Thanks in advance for your help.</p>\r\n<p>&nbsp;</p>', 'Dos in Windows 7, Turbo C++ Full Screen in Windows 7', '888-38-05', '2012-12-18 12:05:41', 'publish'),
(2, 'NTLDR is Compressed Bootup Error', '<p><span><span style=\\"font-family: Verdana,Arial,Helvetica,sans-serif; font-size: x-small;\\"> I performed  a system recovery but now my computer won\\''t start up. The message on  the black screen says: NTLDR is compressed, Press CTRL+ALT+DEL. I do  that but it doesn\\''t start...it brings me back to the same screen and  instructions over and over...help please!</span></span></p>', 'ntldr compressed, bootup error, windows problem', '888-38-05', '2012-12-18 13:22:32', 'publish'),
(3, 'Status 0xc000014c, Windows Failed to Load Because the System Registry File is Missing or Corrupt Error', '<p>Hi friends,</p>\n<p><span>We  have a Dell Dimension C521. We are unable to do a start up. We keep  going to the start up with pick a mode. We have done the F8 key, start  in safe mode, even tried to download Vista again and get \\"Status  0xc000014c, Windows failed to load because the system registry file is  missing or corrupt.<br /> Windows boot manager<br /> System recovery<br /> File: C:\\\\Windows\\\\System32\\\\config\\\\system</span></p>\n<p>We do not have the start up or recovery disk. We had  moved and figure it was left or more possibly lost in the move. Can you  help us? We contacted Dell and it is going to cost approx. $100.00 to  150.00. We are quite beginer computer user, so simplified terms would be  appreciated. We have our fingers crossed and hope you don\\''t come back  and say it is fried.</p>\n<p>Thanks.</p>', 'Status Error, 0xc000014c, system registry error', '888-39-06', '2012-12-18 13:26:45', 'publish'),
(4, 'Outlook Express "The Message Could Not Be Deleted" Error', '<p>Hi All,</p>\r\n<p><span><span style=\\"font-family: Verdana,Arial,Helvetica,sans-serif; font-size: x-small;\\">Sometimes  when I try to delete an email message (a received message) I get the  following wording \\"The message could not be deleted.\\" </span></span></p>\r\n<p><span><span style=\\"font-family: Verdana,Arial,Helvetica,sans-serif; font-size: x-small;\\">What do I do to  solve this problem? I use Outlook Express.</span></span></p>\r\n<p><span><span style=\\"font-family: Verdana,Arial,Helvetica,sans-serif; font-size: x-small;\\">Thanks in advance</span></span></p>', 'outlook error, message deletion errror in outlook', '888-38-05', '2012-12-18 13:28:36', 'publish'),
(5, 'Windows Cannot Find csrsc.exe Error Message', '<p><span><span style=\\"font-family: Verdana,Arial,Helvetica,sans-serif; font-size: x-small;\\">When I start  my PC I get an error like <strong>windows cannot find csrsc.exe</strong>. I want to remove this error. HOW? PLS HELP ME.</span></span></p>', 'csrsc.exe error, windows startup error', '888-39-06', '2012-12-18 13:56:17', 'publish'),
(7, '1.Ludbina''s', '<p>rrrrrrrrrrrrrrrr</p>\n<p>rrrrrrrrrrrrrrrrrrrrrrrrrr</p>\n<p>rrrrrrrrrrrrrrrrrrr ??????????????</p>', '', '888-39-06', '2013-01-22 14:28:10', 'publish');

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

--
-- Table structure for table `forum_rating`
--

CREATE TABLE IF NOT EXISTS `forum_rating` (
  `rep_id` int(11) NOT NULL,
  `rated_by` varchar(20) NOT NULL,
  `rating` int(11) NOT NULL,
  PRIMARY KEY (`rep_id`,`rated_by`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `forum_rating`
--

INSERT INTO `forum_rating` (`rep_id`, `rated_by`, `rating`) VALUES
(1, 'c091201', 3),
(3, 'c091216', 1),
(4, 'c091216', 1),
(7, 'c091216', 2),
(9, 'c091216', 1),
(10, 'c091216', 1),
(11, 'c091216', 1),
(13, '888-38-05', 2),
(12, '', 2),
(14, '888-38-10', 2);

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

--
-- Table structure for table `forum_replies`
--

CREATE TABLE IF NOT EXISTS `forum_replies` (
  `rep_id` int(11) NOT NULL AUTO_INCREMENT,
  `ques_id` int(11) NOT NULL,
  `rep_details` text NOT NULL,
  `best_reply` enum('yes','no') NOT NULL DEFAULT 'yes',
  `replied_by` varchar(20) NOT NULL,
  `date_replied` datetime NOT NULL,
  PRIMARY KEY (`rep_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `forum_replies`
--

INSERT INTO `forum_replies` (`rep_id`, `ques_id`, `rep_details`, `best_reply`, `replied_by`, `date_replied`) VALUES
(9, 4, '<p>This is nothing............</p>', 'yes', 'c091216', '2013-01-18 15:17:06'),
(8, 5, '<p>thisis not okkkk</p>', 'yes', 'c091216', '2013-01-16 19:56:56'),
(10, 3, '<p>ffffffffffffffffffffffffffffffff</p>', 'yes', 'c091216', '2013-01-21 16:34:30'),
(11, 5, '<p>ggggggggggggg</p>', 'yes', 'c091216', '2013-01-22 03:39:59'),
(12, 1, '<p>gud</p>', 'yes', '888-38-01', '2014-09-06 15:29:44'),
(13, 7, '<p>lol :)</p>', 'yes', '888-38-05', '2014-09-06 15:32:15'),
(14, 4, '<p>use google search</p>', 'yes', '888-38-10', '2014-09-07 15:08:22');

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

--
-- Table structure for table `menus`
--

CREATE TABLE IF NOT EXISTS `menus` (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_alias` varchar(100) NOT NULL,
  `menu_name` varchar(100) NOT NULL,
  `serial` int(11) NOT NULL,
  `menu_type` enum('internal','external','alias') NOT NULL DEFAULT 'alias',
  `cat_id` int(11) NOT NULL,
  `menu_url` varchar(100) NOT NULL,
  `page_title` varchar(200) NOT NULL,
  `status` enum('publish','unpublish') NOT NULL DEFAULT 'publish',
  PRIMARY KEY (`menu_id`),
  UNIQUE KEY `menu_alias` (`menu_alias`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`menu_id`, `menu_alias`, `menu_name`, `serial`, `menu_type`, `cat_id`, `menu_url`, `page_title`, `status`) VALUES
(11, 'home', 'E-DESK HOME', 0, 'alias', 0, '', 'Welcome to IIUC E-Desk :: a complete student web portal', 'publish'),
(13, 'edesk-blog', 'E-DESK BLOG', 2, 'alias', 0, '?mod=blog', 'E-Desk Education Blog :: Express your ideas with fellows', 'publish'),
(14, 'edesk-forum', 'E-DESK FORUM', 3, 'alias', 0, '?mod=forum', 'E-Desk Forum :: Get help from your fellows', 'publish'),
(15, 'about-sub', 'ABOUT SUB', 4, 'internal', 7, '', 'About SUB', 'publish'),
(16, 'downloads', 'DOWNLOADS', 5, 'alias', 7, '?mod=downloads', 'Page Title', 'publish');

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

--
-- Table structure for table `sections`
--

CREATE TABLE IF NOT EXISTS `sections` (
  `section_id` int(11) NOT NULL AUTO_INCREMENT,
  `section_name` varchar(20) NOT NULL,
  `semester_id` int(11) NOT NULL,
  `class_captain` varchar(15) NOT NULL COMMENT 'this is the student id of the class captain',
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` (`section_id`, `section_name`, `semester_id`, `class_captain`) VALUES
(1, 'Male 1A', 1, 'c091216'),
(2, 'Female 2A', 1, '888-38-05'),
(3, 'Male 2A', 2, ''),
(4, 'Female 2A', 2, '888-38-05'),
(5, 'Female 1A', 5, ''),
(6, 'Female3A', 4, '888-38-10');

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

--
-- Table structure for table `section_articles`
--

CREATE TABLE IF NOT EXISTS `section_articles` (
  `section_id` int(11) NOT NULL,
  `art_id` int(11) NOT NULL,
  `notification` enum('yes','no') NOT NULL DEFAULT 'no',
  `expire_date` datetime NOT NULL,
  PRIMARY KEY (`section_id`,`art_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `section_articles`
--

INSERT INTO `section_articles` (`section_id`, `art_id`, `notification`, `expire_date`) VALUES
(1, 22, 'yes', '2013-02-10 00:00:00'),
(1, 26, 'yes', '0000-00-00 00:00:00'),
(1, 27, 'yes', '0000-00-00 00:00:00'),
(1, 28, 'yes', '0000-00-00 00:00:00'),
(1, 29, 'yes', '0000-00-00 00:00:00'),
(6, 30, 'yes', '0000-00-00 00:00:00');

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

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

CREATE TABLE IF NOT EXISTS `semesters` (
  `semester_id` int(11) NOT NULL AUTO_INCREMENT,
  `department_id` int(11) NOT NULL,
  `semester_name` varchar(10) NOT NULL,
  PRIMARY KEY (`semester_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

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

INSERT INTO `semesters` (`semester_id`, `department_id`, `semester_name`) VALUES
(1, 2, 'CSIT2ND'),
(2, 3, 'CSIT4TH'),
(3, 2, 'CSIT1ST'),
(4, 2, 'CSIT3RD'),
(5, 3, 'BBA 2ND'),
(6, 3, 'BBA 1ST'),
(7, 3, 'BBA 3RD');

