-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `system_cid`
--

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

--
-- Table structure for table `admin_mqcais_monitoring_reports`
--

CREATE TABLE `admin_mqcais_monitoring_reports` (
  `id` int(11) NOT NULL,
  `report_id` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `no_of_schools_monitored_and_provided_ta` int(11) DEFAULT NULL,
  `activities_undertaken` text DEFAULT NULL,
  `findings` text DEFAULT NULL,
  `technical_assistance_provided` text DEFAULT NULL,
  `agreement` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `admin_mqcais_reports`
--

CREATE TABLE `admin_mqcais_reports` (
  `id` int(11) NOT NULL,
  `division` varchar(255) DEFAULT NULL,
  `section` varchar(255) DEFAULT NULL,
  `district` varchar(255) DEFAULT NULL,
  `month` varchar(255) DEFAULT NULL,
  `school_year` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `daily_accomplishments`
--

CREATE TABLE `daily_accomplishments` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `designation` varchar(255) NOT NULL,
  `username` varchar(100) NOT NULL,
  `no_of_shs_provided_ta` int(11) DEFAULT 0,
  `no_of_teachers_observed` int(11) DEFAULT 0,
  `no_of_teachers_provided_ta` int(11) NOT NULL,
  `date_added` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `daily_accomplishments`
--

INSERT INTO `daily_accomplishments` (`id`, `name`, `designation`, `username`, `no_of_shs_provided_ta`, `no_of_teachers_observed`, `no_of_teachers_provided_ta`, `date_added`) VALUES
(1, 'Herman A.  Catapang', 'EPS', 'hacatapang', 1, 3, 3, '2025-05-12'),
(2, 'Herman A.  Catapang', 'EPS', 'hacatapang', 2, 5, 10, '2025-05-13'),
(3, 'Generiego O. Javier', 'EPS', 'gjavier', 1, 2, 2, '2025-05-12'),
(4, 'Generiego O. Javier', 'EPS', 'gjavier', 1, 2, 5, '2025-05-09'),
(5, 'Juan G. Dela Cruz', 'PSDS', 'djuan', 1, 2, 5, '2025-05-09');

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

--
-- Table structure for table `mista_monitoring_reports`
--

CREATE TABLE `mista_monitoring_reports` (
  `id` int(11) NOT NULL,
  `plan_id` int(11) DEFAULT NULL,
  `dates` date DEFAULT NULL,
  `school` varchar(100) DEFAULT NULL,
  `name_of_school_head` varchar(100) DEFAULT NULL,
  `activities_undertaken` text DEFAULT NULL,
  `no_of_schools_monitored_and_provided_ta` varchar(50) DEFAULT NULL,
  `findings` text DEFAULT NULL,
  `technical_assistance_provided` text DEFAULT NULL,
  `agreement` text DEFAULT NULL,
  `school_head_signature` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mista_monitoring_reports`
--

INSERT INTO `mista_monitoring_reports` (`id`, `plan_id`, `dates`, `school`, `name_of_school_head`, `activities_undertaken`, `no_of_schools_monitored_and_provided_ta`, `findings`, `technical_assistance_provided`, `agreement`, `school_head_signature`) VALUES
(40, 1, '2025-05-12', 'Banaba West IS', 'Dr. Lanie Salazar', 'Serve as DESO', '2', '3 NON-READER', 'Provision of technical assistance', 'Intensify reading activities', '0'),
(41, 1, '2025-05-13', 'Malitam ES', 'Dr. Lanie Salazar', 'Classroom Observation', '1', '3 NON-READER', 'Provision of technical assistance', 'Intensify reading activities', '0'),
(42, 1, '2025-05-26', 'Banaba West IS', 'JLBJFOo', 'Classroom Observation', '1', '3 NON-READER', 'Provision of technical assistance', 'Intensify reading activities', '0'),
(45, 3, '2025-05-09', 'Malitam ES', 'Dr. Lanie Salazar', 'Checking DLL', '2', '3 NON-READER', 'Provision of technical assistance', 'Intensify reading activities', ''),
(46, 4, '2025-05-09', 'Malitam ES', 'Dr. Lanie Salazar', 'Classroom Observation', '2', '3 NON-READER', 'Provision of technical assistance', 'Intensify reading activities', ''),
(47, 4, '2025-05-30', 'Banaba West IS', 'Dr. Lanie Salazar', 'Classroom Observation', '0', 'n/a', 'n/a', 'n/a', '');

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

--
-- Table structure for table `mista_plans`
--

CREATE TABLE `mista_plans` (
  `id` int(11) NOT NULL,
  `username` varchar(100) DEFAULT NULL,
  `division` varchar(100) DEFAULT NULL,
  `section` varchar(100) DEFAULT NULL,
  `district` varchar(100) DEFAULT NULL,
  `month` varchar(50) DEFAULT NULL,
  `year` varchar(10) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` varchar(255) NOT NULL DEFAULT 'pending'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mista_plans`
--

INSERT INTO `mista_plans` (`id`, `username`, `division`, `section`, `district`, `month`, `year`, `created_at`, `status`) VALUES
(2, 'hacatapang', 'Batangas City', 'CID', 'Mathematics', 'May', '2025', '2025-05-08 07:40:15', 'draft'),
(3, 'gjavier', 'Batangas City', 'CID', 'Values', 'June', '2025', '2025-05-09 00:34:43', 'draft'),
(4, 'gjavier', 'Batangas City', 'CID', 'Values', 'May', '2025', '2025-05-09 01:59:38', 'draft'),
(5, 'djuan', 'Batangas City', 'CID', 'Mathematics', 'May', '2025', '2025-05-09 02:23:04', 'draft');

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

--
-- Table structure for table `mista_plan_activities`
--

CREATE TABLE `mista_plan_activities` (
  `id` int(11) NOT NULL,
  `plan_id` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `instructional_supervisory_and_monitoring_activity` varchar(255) DEFAULT NULL,
  `school` varchar(100) DEFAULT NULL,
  `school_head` varchar(100) DEFAULT NULL,
  `remarks` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mista_plan_activities`
--

INSERT INTO `mista_plan_activities` (`id`, `plan_id`, `date`, `instructional_supervisory_and_monitoring_activity`, `school`, `school_head`, `remarks`) VALUES
(5, 2, '2025-05-07', 'Checking DLL', 'Banaba West IS', 'Dr. Lanie Salazar', ''),
(6, 2, '2025-05-09', 'Classroom Observation', 'Banaba West IS', 'Dr. Lanie Salazar', ''),
(7, 3, '2025-06-02', 'Classroom Observation', 'Banaba West IS', 'Dr. Lanie Salazar', ''),
(8, 4, '2025-05-09', 'Checking DLL', 'Malitam ES', 'Dr. Lanie Salazar', ''),
(11, 5, '2025-05-09', 'Classroom Observation', 'Malitam ES', 'Dr. Lanie Salazar', 'Accomplished'),
(12, 5, '2025-05-30', 'Classroom Observation', 'Banaba West IS', 'Dr. Lanie Salazar', 'Not accomplished due to ');

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

--
-- Table structure for table `mista_reports`
--

CREATE TABLE `mista_reports` (
  `id` int(11) NOT NULL,
  `division` varchar(100) DEFAULT NULL,
  `section` varchar(100) DEFAULT NULL,
  `district` varchar(100) DEFAULT NULL,
  `month` varchar(20) DEFAULT NULL,
  `school_year` varchar(10) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mista_reports`
--

INSERT INTO `mista_reports` (`id`, `division`, `section`, `district`, `month`, `school_year`, `username`, `created_at`) VALUES
(1, 'Batangas City', 'CID', 'Mathematics', 'May', '2025', 'hacatapang', '2025-05-08 07:31:43'),
(3, 'Batangas City', 'CID', 'Values', 'May', '2025', 'gjavier', '2025-05-09 02:00:01'),
(4, 'Batangas City', 'CID', 'Mathematics', 'May', '2025', 'djuan', '2025-05-09 02:27:14');

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

--
-- Table structure for table `monthly_accomplishment_reports`
--

CREATE TABLE `monthly_accomplishment_reports` (
  `id` int(11) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `tracking_no` varchar(100) NOT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `date_added` date DEFAULT current_timestamp(),
  `file_path` varchar(500) DEFAULT NULL,
  `submitted_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `monthly_accomplishment_reports`
--

INSERT INTO `monthly_accomplishment_reports` (`id`, `fullname`, `username`, `tracking_no`, `designation`, `title`, `date_added`, `file_path`, `submitted_at`) VALUES
(1, 'Herman A.  Catapang', 'hacatapang', 'C510225D', 'EPS', 'Monthly Accomplishment Report', '2025-05-08', 'uploads/monthly_reports/1746689112_monthly_report_hacatapang_05_2025.pdf', '2025-05-08 07:25:12'),
(3, 'Generiego O. Javier', 'gjavier', 'C131144D', 'EPS', 'Monthly Accomplishment Report', '2025-05-09', 'uploads/monthly_reports/1746754959_monthly_report_gjavier_5_2025 (1).pdf', '2025-05-09 01:42:39'),
(4, 'Generiego O. Javier', 'gjavier', 'C763043D', 'EPS', 'Monthly Accomplishment Report', '2025-05-09', 'uploads/monthly_reports/1746755929_monthly_report_hacatapang_05_2025.pdf', '2025-05-09 01:58:49');

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

--
-- Table structure for table `mqcais_monitoring_reports`
--

CREATE TABLE `mqcais_monitoring_reports` (
  `id` int(11) NOT NULL,
  `report_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `no_of_schools_monitored_and_provided_ta` varchar(50) NOT NULL,
  `activities_undertaken` text NOT NULL,
  `findings` text DEFAULT NULL,
  `technical_assistance_provided` text DEFAULT NULL,
  `agreement` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mqcais_monitoring_reports`
--

INSERT INTO `mqcais_monitoring_reports` (`id`, `report_id`, `date`, `no_of_schools_monitored_and_provided_ta`, `activities_undertaken`, `findings`, `technical_assistance_provided`, `agreement`) VALUES
(107, 1, '2025-05-12', '2', 'Serve as DESO', '3 NON-READER', 'Provision of technical assistance', 'Intensify reading activities'),
(108, 1, '2025-05-13', '1', 'Classroom Observation', '3 NON-READER', 'Provision of technical assistance', 'Intensify reading activities'),
(109, 1, '2025-05-26', '1', 'Classroom Observation', '3 NON-READER', 'Provision of technical assistance', 'Intensify reading activities'),
(110, 2, '2025-05-09', '2', 'Checking DLL', '3 NON-READER', 'Provision of technical assistance', 'Intensify reading activities'),
(111, 3, '2025-05-09', '2', 'Classroom Observation', '3 NON-READER', 'Provision of technical assistance', 'Intensify reading activities'),
(112, 3, '2025-05-30', '0', 'Classroom Observation', 'n/a', 'n/a', 'n/a');

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

--
-- Table structure for table `mqcais_reports`
--

CREATE TABLE `mqcais_reports` (
  `id` int(11) NOT NULL,
  `division` varchar(100) NOT NULL,
  `section` varchar(100) NOT NULL,
  `district` varchar(100) NOT NULL,
  `month` varchar(20) NOT NULL,
  `school_year` varchar(20) NOT NULL,
  `username` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mqcais_reports`
--

INSERT INTO `mqcais_reports` (`id`, `division`, `section`, `district`, `month`, `school_year`, `username`, `created_at`) VALUES
(1, 'Batangas City', 'CID', 'Mathematics', 'May', '2025', 'hacatapang', '2025-05-08 07:44:42'),
(2, 'Batangas City', 'CID', 'Values', 'May', '2025', 'gjavier', '2025-05-09 02:00:30'),
(3, 'Batangas City', 'CID', 'Mathematics', 'May', '2025', 'djuan', '2025-05-09 02:28:33');

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

--
-- Table structure for table `schedule`
--

CREATE TABLE `schedule` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `activities` text NOT NULL,
  `other_activity` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `tracking_no` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `schedule`
--

INSERT INTO `schedule` (`id`, `name`, `username`, `type`, `activities`, `other_activity`, `location`, `date`, `tracking_no`, `created_at`) VALUES
(10, 'Juan G. Dela Cruz', 'djuan', '', 'Seminar on Basic Education Reform', '', 'Cebu City', '2025-05-09', '', '2025-05-09 02:10:12'),
(11, 'Juan G. Dela Cruz', 'djuan', '', 'Provision of TA', '', 'Paharang IS', '2025-05-12', '', '2025-05-09 02:11:26');

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

--
-- Table structure for table `submitted_mista_plans`
--

CREATE TABLE `submitted_mista_plans` (
  `id` int(11) NOT NULL,
  `fullname` varchar(150) NOT NULL,
  `username` varchar(100) NOT NULL,
  `tracking_no` varchar(50) NOT NULL,
  `designation` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `date_submitted` date NOT NULL,
  `file_path` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `submitted_mista_plans`
--

INSERT INTO `submitted_mista_plans` (`id`, `fullname`, `username`, `tracking_no`, `designation`, `title`, `date_submitted`, `file_path`) VALUES
(1, 'Herman A.  Catapang', 'hacatapang', 'C51818D', 'EPS', 'Monthly Instructional Supervisory and Technical Assistance Plan', '2025-05-08', 'uploads/mista_plan/1746689411_MISTA_Plan_1 (1).pdf'),
(2, 'Generiego O. Javier', 'gjavier', 'C408265D', 'EPS', 'Monthly Instructional Supervisory and Technical Assistance Plan', '2025-05-09', 'uploads/mista_plan/1746755015_MISTA_Plan_3.pdf'),
(3, 'Generiego O. Javier', 'gjavier', 'C254631D', 'EPS', 'Monthly Instructional Supervisory and Technical Assistance Plan', '2025-05-09', 'uploads/mista_plan/1746755946_MISTA_Plan_3.pdf');

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

--
-- Table structure for table `submitted_mista_reports`
--

CREATE TABLE `submitted_mista_reports` (
  `id` int(11) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `username` varchar(100) NOT NULL,
  `tracking_no` varchar(50) NOT NULL,
  `designation` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `date_submitted` date NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `submitted_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `submitted_mista_reports`
--

INSERT INTO `submitted_mista_reports` (`id`, `fullname`, `username`, `tracking_no`, `designation`, `title`, `date_submitted`, `file_path`, `submitted_at`) VALUES
(1, 'Generiego O. Javier', 'gjavier', 'C727525D', 'EPS', 'Monthly Instructional Supervisory and Technical Assistance Report', '2025-05-09', 'uploads/mista_report/1746755145_MISTAR_Report_11.pdf', '2025-05-09 01:45:45');

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

--
-- Table structure for table `submitted_mqcais_reports`
--

CREATE TABLE `submitted_mqcais_reports` (
  `id` int(11) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `username` varchar(100) NOT NULL,
  `tracking_no` varchar(50) NOT NULL,
  `designation` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `date_submitted` date NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `submitted_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `submitted_mqcais_reports`
--

INSERT INTO `submitted_mqcais_reports` (`id`, `fullname`, `username`, `tracking_no`, `designation`, `title`, `date_submitted`, `file_path`, `submitted_at`) VALUES
(1, 'Generiego O. Javier', 'gjavier', 'C624642D', 'EPS', 'Monthly/Quarterly Consolidated and Analyzed Instructional Supervisory Report', '2025-05-09', 'uploads/mqcais_report/1746755719_MQCAIS_Report_31.pdf', '2025-05-09 01:55:19'),
(2, 'Generiego O. Javier', 'gjavier', 'C61835D', 'EPS', 'Monthly/Quarterly Consolidated and Analyzed Instructional Supervisory Report', '2025-05-09', 'uploads/mqcais_report/1746756047_MQCAIS_Report_31.pdf', '2025-05-09 02:00:47');

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

--
-- Table structure for table `update_info`
--

CREATE TABLE `update_info` (
  `id` int(11) NOT NULL DEFAULT 0,
  `tracking_no` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `deped_email` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL,
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `update_info`
--

INSERT INTO `update_info` (`id`, `tracking_no`, `username`, `fullname`, `email`, `deped_email`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`) VALUES
(0, 'W659933X', 'ALDINVAN', 'ALDIN VAN ALI', 'aldinvan.ali@deped.gov.ph', 'vanalialdin@gmail.com', 'DONE', '0000-00-00', '2', 'Information update a', '2024-02-22'),
(0, 'W32676X', 'ALDINVAN', 'ALDIN VAN ALI', 'aldinvan.ali@deped.gov.ph', 'vanalialdin@gmail.com', 'DONE', '0000-00-00', '2', 'Information update a', '2024-02-22');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin_mqcais_monitoring_reports`
--
ALTER TABLE `admin_mqcais_monitoring_reports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admin_mqcais_monitoring_reports_ibfk_1` (`report_id`);

--
-- Indexes for table `admin_mqcais_reports`
--
ALTER TABLE `admin_mqcais_reports`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `daily_accomplishments`
--
ALTER TABLE `daily_accomplishments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mista_monitoring_reports`
--
ALTER TABLE `mista_monitoring_reports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `plan_id` (`plan_id`);

--
-- Indexes for table `mista_plans`
--
ALTER TABLE `mista_plans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mista_plan_activities`
--
ALTER TABLE `mista_plan_activities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `plan_id` (`plan_id`);

--
-- Indexes for table `mista_reports`
--
ALTER TABLE `mista_reports`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `monthly_accomplishment_reports`
--
ALTER TABLE `monthly_accomplishment_reports`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mqcais_monitoring_reports`
--
ALTER TABLE `mqcais_monitoring_reports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `report_id` (`report_id`);

--
-- Indexes for table `mqcais_reports`
--
ALTER TABLE `mqcais_reports`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `schedule`
--
ALTER TABLE `schedule`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `submitted_mista_plans`
--
ALTER TABLE `submitted_mista_plans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `submitted_mista_reports`
--
ALTER TABLE `submitted_mista_reports`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `submitted_mqcais_reports`
--
ALTER TABLE `submitted_mqcais_reports`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin_mqcais_monitoring_reports`
--
ALTER TABLE `admin_mqcais_monitoring_reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_mqcais_reports`
--
ALTER TABLE `admin_mqcais_reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `daily_accomplishments`
--
ALTER TABLE `daily_accomplishments`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `mista_monitoring_reports`
--
ALTER TABLE `mista_monitoring_reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `mista_plans`
--
ALTER TABLE `mista_plans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `mista_plan_activities`
--
ALTER TABLE `mista_plan_activities`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `mista_reports`
--
ALTER TABLE `mista_reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `monthly_accomplishment_reports`
--
ALTER TABLE `monthly_accomplishment_reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `mqcais_monitoring_reports`
--
ALTER TABLE `mqcais_monitoring_reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113;

--
-- AUTO_INCREMENT for table `mqcais_reports`
--
ALTER TABLE `mqcais_reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `schedule`
--
ALTER TABLE `schedule`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `submitted_mista_plans`
--
ALTER TABLE `submitted_mista_plans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `submitted_mista_reports`
--
ALTER TABLE `submitted_mista_reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `submitted_mqcais_reports`
--
ALTER TABLE `submitted_mqcais_reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `admin_mqcais_monitoring_reports`
--
ALTER TABLE `admin_mqcais_monitoring_reports`
  ADD CONSTRAINT `admin_mqcais_monitoring_reports_ibfk_1` FOREIGN KEY (`report_id`) REFERENCES `admin_mqcais_reports` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `mista_monitoring_reports`
--
ALTER TABLE `mista_monitoring_reports`
  ADD CONSTRAINT `mista_monitoring_reports_ibfk_1` FOREIGN KEY (`plan_id`) REFERENCES `mista_reports` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `mista_plan_activities`
--
ALTER TABLE `mista_plan_activities`
  ADD CONSTRAINT `mista_plan_activities_ibfk_1` FOREIGN KEY (`plan_id`) REFERENCES `mista_plans` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `mqcais_monitoring_reports`
--
ALTER TABLE `mqcais_monitoring_reports`
  ADD CONSTRAINT `mqcais_monitoring_reports_ibfk_1` FOREIGN KEY (`report_id`) REFERENCES `mqcais_reports` (`id`) ON DELETE CASCADE;
COMMIT;

