-- phpMyAdmin SQL Dump
-- version 5.1.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 27, 2022 at 09:17 AM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 8.1.5

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

--
-- Database: `mces_db`
--

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

--
-- Table structure for table `class_list`
--

CREATE TABLE `class_list` (
  `id` int(30) NOT NULL,
  `name` text NOT NULL,
  `description` text NOT NULL,
  `fee` float(12,2) NOT NULL DEFAULT 0.00,
  `image_path` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0 = Inactive,\r\n1 = Active',
  `delete_flag` tinyint(1) NOT NULL DEFAULT 0,
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  `date_updated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `class_list`
--

INSERT INTO `class_list` (`id`, `name`, `description`, `fee`, `image_path`, `status`, `delete_flag`, `date_created`, `date_updated`) VALUES
(1, 'Voice Lesson', '&lt;p style=&quot;margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding: 0px;&quot;&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec in nunc et enim aliquam convallis ac venenatis leo. Pellentesque elementum sapien dui, in ultricies elit fringilla sit amet. Nam consectetur nisi vel dolor tempor egestas. Praesent a eleifend orci. Maecenas congue metus sit amet lacus scelerisque, sit amet iaculis urna blandit. Curabitur ut mi nisl. Nulla sollicitudin quis purus efficitur semper. Suspendisse tempor nisl at felis fringilla, molestie efficitur odio imperdiet. Phasellus ligula nisi, fermentum nec finibus sit amet, tincidunt congue sem. Phasellus in congue est. Fusce quis dolor iaculis, consectetur nisi et, condimentum justo. Maecenas auctor, felis id placerat tristique, lorem nisl maximus justo, sit amet dapibus lacus lorem quis quam. Pellentesque ullamcorper velit tincidunt interdum ultrices. Cras at sapien eget ligula consequat faucibus. Aliquam at ultrices odio.&lt;/p&gt;&lt;p style=&quot;margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding: 0px;&quot;&gt;Suspendisse laoreet ut neque hendrerit posuere. Vestibulum at eros molestie, malesuada purus sed, ornare lorem. Nam ipsum ex, semper at ligula sit amet, molestie maximus nisi. Nam mi nunc, venenatis et varius id, consectetur at neque. Ut eu congue ante. Ut sollicitudin venenatis ex a condimentum. Phasellus vel porttitor lacus. Vivamus viverra, metus vitae efficitur lobortis, ex mi rutrum urna, vitae egestas ipsum ligula vitae elit. Suspendisse potenti. Maecenas gravida lacus nisl, ut scelerisque mauris laoreet et.&lt;/p&gt;', 1500.00, 'uploads/classes//mic.jpg?v=1653618189', 1, 0, '2022-05-27 10:23:09', '2022-05-27 11:34:28'),
(2, 'Guitar Lesson', '&lt;p style=&quot;margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding: 0px;&quot;&gt;Vivamus a semper metus. Nunc non ex vel libero molestie lacinia ac vel sapien. Curabitur convallis cursus risus, at cursus lorem interdum ac. Donec a ex sed velit fermentum dapibus. Proin volutpat diam quis rutrum consectetur. Aliquam erat volutpat. Etiam massa velit, tincidunt sit amet purus sed, viverra rhoncus enim. Sed pulvinar tincidunt lectus, at pulvinar ex feugiat et. Aenean feugiat finibus nisi in egestas.&lt;/p&gt;&lt;p style=&quot;margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding: 0px;&quot;&gt;Aliquam imperdiet, tortor a pellentesque faucibus, est neque efficitur nisi, a dapibus erat turpis ac turpis. Curabitur risus dui, ornare eget pellentesque eu, lobortis sed massa. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Integer lobortis arcu eu fringilla accumsan. Quisque ornare neque ac enim finibus pellentesque. Sed tincidunt magna quis elementum vulputate. Aenean nulla urna, molestie vel varius et, maximus et quam. Aliquam sed justo lacinia turpis porta scelerisque. Aliquam quis luctus odio, non imperdiet lacus. Nam nulla magna, auctor a feugiat a, cursus vel orci. Sed tristique diam ex, sit amet mattis turpis interdum faucibus. Sed vel est pretium, ullamcorper nunc in, ullamcorper massa. Etiam mollis eget orci sed maximus. Morbi ac quam ultricies ipsum accumsan elementum.&lt;/p&gt;', 1200.00, 'uploads/classes//guitar.jpg?v=1653618285', 1, 0, '2022-05-27 10:24:45', '2022-05-27 11:34:07'),
(3, 'Piano Lesson', '&lt;p style=&quot;margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding: 0px;&quot;&gt;Etiam vitae maximus enim. Curabitur tempor nisi vitae varius laoreet. Quisque lobortis nisl placerat placerat dapibus. Proin eget magna luctus enim convallis porttitor in eget orci. Duis vehicula ante ac lorem imperdiet varius. Nulla ut mauris a neque convallis rhoncus eu id justo. Pellentesque eu ante scelerisque, imperdiet ex aliquet, vehicula augue. Sed sit amet lectus non justo euismod rhoncus vel in libero. Integer arcu lacus, faucibus quis diam sit amet, rutrum tempor augue.&lt;/p&gt;&lt;p style=&quot;margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding: 0px;&quot;&gt;Quisque mattis at urna ut elementum. Mauris viverra elit felis, id ullamcorper purus posuere eget. Nam rhoncus urna mauris, id venenatis mi maximus vitae. Duis diam elit, tristique sit amet arcu ut, placerat scelerisque neque. Maecenas laoreet, quam in condimentum bibendum, augue augue euismod sapien, vitae pulvinar enim lacus at sem. Vivamus a tortor ligula. Phasellus mauris ipsum, tempor vitae magna in, ornare egestas sem. Aenean laoreet eros eu lacinia viverra.&lt;/p&gt;', 1500.00, 'uploads/classes//piano.jpg?v=1653618313', 1, 0, '2022-05-27 10:25:13', '2022-05-27 11:34:19'),
(4, 'Drum Lesson', '&lt;p style=&quot;margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding: 0px;&quot;&gt;Nulla mi eros, mollis id odio ac, dignissim scelerisque leo. Integer diam quam, vehicula sit amet ultrices quis, feugiat eget ipsum. Suspendisse eget volutpat ex. Praesent id molestie neque, non dictum tellus. Proin quis sapien in mi sagittis elementum quis non augue. Nam gravida dictum quam, ut ultrices ex mattis vel. Ut erat diam, euismod non urna eu, varius vulputate arcu. Cras consequat turpis orci, et semper dolor faucibus nec. Fusce nec maximus odio, quis rutrum augue. Nulla non pretium tortor. Vestibulum quis luctus diam, at tincidunt tellus. Quisque vitae vulputate urna, ac gravida felis. Maecenas non tristique justo, ac gravida mi.&lt;/p&gt;&lt;p style=&quot;margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding: 0px;&quot;&gt;Donec porta tellus velit, ac malesuada ligula gravida id. Phasellus pretium congue sapien, a pretium lacus placerat at. Nunc quis erat elementum, consequat ante ac, ullamcorper velit. Sed pharetra felis risus, in accumsan justo molestie in. Aenean eu felis urna. Donec venenatis ex quis lectus efficitur, sed semper enim egestas. Phasellus tincidunt consequat neque id sagittis. Nunc interdum sollicitudin sem quis pellentesque. Duis blandit lacinia hendrerit. Praesent eget nisi efficitur ex tempus sodales sed eu ipsum. Suspendisse potenti.&lt;/p&gt;', 1200.00, 'uploads/classes//drums.jpg?v=1653618334', 1, 0, '2022-05-27 10:25:34', '2022-05-27 11:33:53');

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

--
-- Table structure for table `enroll_list`
--

CREATE TABLE `enroll_list` (
  `id` int(30) NOT NULL,
  `class_id` int(30) NOT NULL,
  `firstname` text NOT NULL,
  `middlename` text DEFAULT NULL,
  `lastname` text NOT NULL,
  `gender` varchar(100) NOT NULL,
  `dob` date NOT NULL,
  `contact` text NOT NULL,
  `email` text DEFAULT NULL,
  `address` text NOT NULL,
  `guardian_name` text DEFAULT NULL,
  `guardian_contact` text DEFAULT NULL,
  `relation` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 = pending,\r\n1 = Confirmed,\r\n2= Cancelled',
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  `date_updated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `enroll_list`
--

INSERT INTO `enroll_list` (`id`, `class_id`, `firstname`, `middlename`, `lastname`, `gender`, `dob`, `contact`, `email`, `address`, `guardian_name`, `guardian_contact`, `relation`, `status`, `date_created`, `date_updated`) VALUES
(4, 4, 'Catherine', 'T', 'Casas', 'Female', '2010-06-23', '09123654789', 'ccasa@gmail.com', '1628 Rebecca Street, Arlington Heights, IL 60004', 'Will Casas', '0965488798', 'Father', 1, '2022-05-27 13:32:57', '2022-05-27 14:58:48'),
(5, 4, 'Joesph', 'V', 'Gonzales', 'Male', '1997-10-14', '0965478123', 'jgonzales@sample.com', '1291 Stockert Hollow Road, Everett, WA 98204', '', '', '', 1, '2022-05-27 13:39:10', '2022-05-27 14:11:37');

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

--
-- Table structure for table `inquiry_list`
--

CREATE TABLE `inquiry_list` (
  `id` int(30) NOT NULL,
  `fullname` text NOT NULL,
  `contact` text NOT NULL,
  `email` text DEFAULT NULL,
  `subject` text NOT NULL,
  `message` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  `date_updated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `inquiry_list`
--

INSERT INTO `inquiry_list` (`id`, `fullname`, `contact`, `email`, `subject`, `message`, `status`, `date_created`, `date_updated`) VALUES
(2, 'Mark Cooper', '09123456789', 'mcooper@sample.com', 'Sample Inquiry', 'This is a sample inquiry only', 1, '2022-05-26 14:13:47', '2022-05-26 14:14:12'),
(5, 'Samantha Jane miller', '09456654444', 'sam23@gmail.com', 'Sample Query Only', 'This is my sample message about my query.', 1, '2022-05-26 16:19:05', '2022-05-26 16:20:32');

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

--
-- Table structure for table `instructor_list`
--

CREATE TABLE `instructor_list` (
  `id` int(30) NOT NULL,
  `firstname` text NOT NULL,
  `middlename` text DEFAULT NULL,
  `lastname` text NOT NULL,
  `instructor_for` text NOT NULL,
  `short_description` text NOT NULL,
  `image_path` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `delete_flag` tinyint(1) NOT NULL DEFAULT 0,
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  `date_updated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `instructor_list`
--

INSERT INTO `instructor_list` (`id`, `firstname`, `middlename`, `lastname`, `instructor_for`, `short_description`, `image_path`, `status`, `delete_flag`, `date_created`, `date_updated`) VALUES
(1, 'Samantha', 'C', 'Miller', 'Voice, Guitar, Piano', 'Curabitur gravida interdum urna, eget aliquet velit accumsan eu. Donec pharetra dapibus mollis. Nulla id massa at velit mollis condimentum sed pulvinar nibh. Nulla sit amet consectetur ex, et molestie sem. Suspendisse luctus, justo at feugiat tristique, lacus elit luctus orci, sit amet dictum nisi massa eget diam.', 'uploads/instructors//avatar_2.png?v=1653619308', 1, 0, '2022-05-27 10:41:48', '2022-05-27 10:41:48'),
(2, 'John', '', 'Smith', 'Guitar and Drums', 'Nam efficitur nec urna a mollis. Vivamus posuere vestibulum urna, in aliquet mauris tempus quis. Mauris quis justo malesuada, luctus dui vitae, molestie leo. Vestibulum scelerisque rhoncus ex, vel facilisis lacus aliquet quis. Donec vel rutrum orci, a accumsan ante. Integer id suscipit nulla. Pellentesque id massa mauris.', 'uploads/instructors//avatar5.png?v=1653619375', 1, 0, '2022-05-27 10:42:55', '2022-05-27 10:42:55'),
(3, 'Becky ', 'M', 'Dixon', 'Voice', 'Integer tristique libero mattis leo vulputate, ac pretium lacus ultrices. Nullam a neque justo. Curabitur ac tristique urna. Proin egestas augue a lacus mollis tristique. Maecenas tristique sapien quis nunc molestie, nec tincidunt ligula tristique. Nullam maximus mattis pharetra. Suspendisse luctus, tellus consequat egestas placerat, felis tortor consectetur nisl, a feugiat mi diam eget justo. Suspendisse nisi massa, euismod nec egestas nec, dapibus ut arcu. Donec tempus ex nec sollicitudin scelerisque.', 'uploads/instructors//ava.jpg?v=1653619474', 1, 0, '2022-05-27 10:44:34', '2022-05-27 10:44:34'),
(4, 'Louis', 'J', 'Brown', 'Drums and Guitar', 'Nullam egestas ex vel diam placerat, sit amet laoreet odio faucibus. Quisque rutrum ex vitae sapien porttitor, eget tristique est pulvinar. Interdum et malesuada fames ac ante ipsum primis in faucibus.', 'uploads/instructors//avatar_.png?v=1653619522', 1, 0, '2022-05-27 10:45:22', '2022-05-27 10:45:22');

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

--
-- Table structure for table `system_info`
--

CREATE TABLE `system_info` (
  `id` int(30) NOT NULL,
  `meta_field` text NOT NULL,
  `meta_value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `system_info`
--

INSERT INTO `system_info` (`id`, `meta_field`, `meta_value`) VALUES
(1, 'name', 'Music Class Registration Site'),
(6, 'short_name', 'MCRS - PHP'),
(11, 'logo', 'uploads/logo.png?v=1653617529'),
(13, 'user_avatar', 'uploads/user_avatar.jpg'),
(14, 'cover', 'uploads/cover.png?v=1653617534'),
(17, 'phone', '456-987-1231'),
(18, 'mobile', '09123456987 / 094563212222 '),
(19, 'email', 'info@musicschool.com'),
(20, 'address', 'Here St, Down There City, Anywhere Here, 2306');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(50) NOT NULL,
  `firstname` varchar(250) NOT NULL,
  `middlename` text DEFAULT NULL,
  `lastname` varchar(250) NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `avatar` text DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `type` tinyint(1) NOT NULL DEFAULT 0,
  `date_added` datetime NOT NULL DEFAULT current_timestamp(),
  `date_updated` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='2';

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

INSERT INTO `users` (`id`, `firstname`, `middlename`, `lastname`, `username`, `password`, `avatar`, `last_login`, `type`, `date_added`, `date_updated`) VALUES
(1, 'Adminstrator', '', 'Admin', 'admin', '0192023a7bbd73250516f069df18b500', 'uploads/avatars/1.png?v=1649834664', NULL, 1, '2021-01-20 14:02:37', '2022-05-16 14:17:49'),
(7, 'John', 'D', 'Smith', 'jsmith', '1254737c076cf867dc53d60a0364f38e', NULL, NULL, 2, '2022-05-26 11:04:16', '2022-05-26 11:04:16');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `enroll_list`
--
ALTER TABLE `enroll_list`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_id` (`class_id`);

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for table `system_info`
--
ALTER TABLE `system_info`
  MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `enroll_list`
--
ALTER TABLE `enroll_list`
  ADD CONSTRAINT `class_id_fk_el` FOREIGN KEY (`class_id`) REFERENCES `class_list` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
COMMIT;
