-- phpMyAdmin SQL Dump
-- version 3.4.10.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 30, 2013 at 11:55 AM
-- Server version: 5.5.29
-- PHP Version: 5.3.10-1ubuntu3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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: `eduweb_db`
--

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

--
-- Table structure for table `report_card_sections`
--

CREATE TABLE IF NOT EXISTS `report_card_sections` (
  `id_report_card_sections` int(11) NOT NULL AUTO_INCREMENT,
  `fk_schools` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` longtext,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0=inactive, 1=active',
  PRIMARY KEY (`id_report_card_sections`),
  KEY `report_card_sections_fk_schools` (`fk_schools`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `report_card_sections`
--

INSERT INTO `report_card_sections` (`id_report_card_sections`, `fk_schools`, `title`, `description`, `status`) VALUES
(11, 3, 'Term A3', 'Term A2 description', 1);
(12, 3, 'Term A4', 'Term A4 description', 1);
(13, 3, 'Term A5', 'Term A5 description', 1);
(14, 3, 'Term A6', 'Term A6 description', 1);
(15, 3, 'Term A7', 'Term A7 description', 1);
(16, 3, 'Term A8', 'Term A8 description', 1);
(17, 3, 'Term A9', 'Term A9 description', 1);
(18, 3, 'Term A10', 'Term A10 description', 1);
(19, 3, 'Term A11', 'Term A11 description', 1);
(20, 3, 'Term A12', 'Term A12 description', 1);
--
-- Constraints for dumped tables
--

--
-- Constraints for table `report_card_sections`
--
ALTER TABLE `report_card_sections`
  ADD CONSTRAINT `report_card_sections_ibfk_1` FOREIGN KEY (`fk_schools`) REFERENCES `schools` (`id_schools`) ON DELETE CASCADE ON UPDATE CASCADE;

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