 CREATE TABLE IF NOT EXISTS `api_controller` (
 `ID` int(11) NOT NULL,
   `description` varchar(100) NOT NULL
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `event`
+--
+
+CREATE TABLE IF NOT EXISTS `event` (
+`ID` int(11) NOT NULL,
+  `event_type_ID` int(11) NOT NULL,
+  `description` varchar(50) NOT NULL
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
+
+--
+-- Dumping data for table `event`
+--
+
+INSERT INTO `event` (`ID`, `event_type_ID`, `description`) VALUES
+(1, 1, 'Battle of the Bands'),
+(2, 1, 'Debate'),
+(3, 1, 'Siniratura'),
+(4, 1, 'That''s My Bae'),
+(5, 1, 'REO Showoff'),
+(6, 1, 'JPIAN Idol'),
+(7, 1, 'Kalokalike'),
+(8, 1, 'CineJPIA'),
+(9, 2, 'Cup 1 – Basic Accounting'),
+(10, 2, 'Cup 2 – Financial Accounting and Reporting'),
+(11, 2, 'Cup 3 – Advanced Financial Accounting and Reportin'),
+(12, 2, 'Cup 4 – Management Accounting and Control'),
+(13, 2, 'Cup 5 – Auditing'),
+(14, 2, 'Cup 6 – Regulatory Framework for Business Transact'),
+(15, 2, 'Cup 7 – Taxation Case Study');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `event_type`
+--
+
+CREATE TABLE IF NOT EXISTS `event_type` (
+`ID` int(11) NOT NULL,
+  `description` varchar(20) NOT NULL
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
+
+--
+-- Dumping data for table `event_type`
+--
+
+INSERT INTO `event_type` (`ID`, `description`) VALUES
+(1, 'Non-Academic'),
+(2, 'Academic');
 
 -- --------------------------------------------------------
 

  `description` varchar(50) NOT NULL,
  `parent_ID` int(11) NOT NULL,
  `link` text NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

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


-- AUTO_INCREMENT for table `api_controller`
--
ALTER TABLE `api_controller`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `event`
--
ALTER TABLE `event`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `event_type`
--
ALTER TABLE `event_type`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `group_access_control_list`
--
ALTER TABLE `group_access_control_list`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `local_chapter`
--
ALTER TABLE `local_chapter`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `local_chapter_group`
--
ALTER TABLE `local_chapter_group`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `local_chapter_position`
--
ALTER TABLE `local_chapter_position`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `module`
--
ALTER TABLE `module`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `module_api_controller`
--
ALTER TABLE `module_api_controller`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- Constraints for dumped tables
--
