 -- --------------------------------------------------------
 
 --
+-- Table structure for table `department`
+--
+
+CREATE TABLE IF NOT EXISTS `department` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `valid` int(1) NOT NULL,
+  `name` varchar(255) NOT NULL,
+  `description` varchar(255) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
+
+--
+-- Dumping data for table `department`
+--
+
+INSERT INTO `department` (`id`, `valid`, `name`, `description`) VALUES
+(1, 1, 'Pre School', 'Pre School Department'),
+(2, 1, 'Elementary', 'Elementary Department'),
+(3, 1, 'High School', 'High School Department'),
+(4, 1, 'SPED', 'SPED Department');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `section`
+--
+
+CREATE TABLE IF NOT EXISTS `section` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `valid` int(255) NOT NULL,
+  `name` varchar(255) NOT NULL,
+  `description` varchar(255) NOT NULL,
+  `department_id` int(11) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
+
+--
+-- Dumping data for table `section`
+--
+
+INSERT INTO `section` (`id`, `valid`, `name`, `description`, `department_id`) VALUES
+(1, 1, 'Makigisig', 'Matatalinong mga bata ng paaralan', 1),
+(2, 0, 'Malakas', 'AT MAGANDA', 1),
+(3, 0, 'Mga Pogi Kami', 'Yow YO w yow', 1),
+(4, 0, 'Testing Testing Lang', 'Yow Yow Test', 1);
+
+-- --------------------------------------------------------
+
+--
 -- Table structure for table `users`
 --
 

  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `FullName` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

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

INSERT INTO `users` (`id`, `username`, `password`, `FullName`) VALUES
(1, 'andrewemo', 'password', 'Alejandro A. Alain III'),
(2, 'juls', 'password', 'Julius DC Mendoza'),
(3, 'joe', 'password1', 'Joan Alain'),
(4, 'a', 'b', 'c'),
(5, 'joe2', 'password', 'katnis Everdeen'),
(6, 'w', 'e', 'r'),
(7, 'w', 'e', 'r'),
(8, 'andrewemo11', 'eqr', 'qwerqewrqw'),
(9, 'andrewemo', 'password', ''),
(10, 'anika', 'password', 'joannaeeasdfasdf'),
(11, 'andrewemo', 'password', ''),
(12, 'andrewemo', 'password', ''),
(13, 'andrewemo', 'password', ''),
(14, 'andrewemo', 'password', ''),
(15, 'andrewemo', 'password', ''),
(16, 'afdafd', 'adsfasf', 'adfafsdafsd'),
(17, 'werdemo', 'password', 'Andrew Alain III');

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

-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 04, 2014 at 07:09 AM
-- Server version: 5.6.12-log
-- PHP Version: 5.4.12

