web_assignment_db.sql

-- phpMyAdmin SQL Dump
-- version 5.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 29, 2021 at 11:00 PM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.4.2

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;

--
-- Database: `web_assignment_db`
--

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

--
-- Table structure for table `artist_tbl`
--

CREATE TABLE `artist_tbl` (
  `aid` int(11) NOT NULL,
  `aname` varchar(50) NOT NULL,
  `adob` date NOT NULL,
  `aemail` varchar(50) NOT NULL,
  `amobile` varchar(13) NOT NULL,
  `aheight` varchar(20) NOT NULL,
  `aage_group` varchar(20) NOT NULL,
  `aclass` int(11) NOT NULL,
  `astatus` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `artist_tbl`
--

INSERT INTO `artist_tbl` (`aid`, `aname`, `adob`, `aemail`, `amobile`, `aheight`, `aage_group`, `aclass`, `astatus`) VALUES
(1, 'Artsit Test', '1983-02-02', 'artisttest@gmail.com', '56464645654', '1m37inches', 'Young', 1, 1),
(2, 'Artist test2', '1994-03-09', 'test2@gmail.com', '324324324', '1m67inches', 'Young', 1, 1);

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

--
-- Table structure for table `attendence_tbl`
--

CREATE TABLE `attendence_tbl` (
  `attid` int(11) NOT NULL,
  `attdate` date NOT NULL,
  `attvalue` varchar(10) NOT NULL,
  `attartistid` int(11) NOT NULL,
  `attclassid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `attendence_tbl`
--

INSERT INTO `attendence_tbl` (`attid`, `attdate`, `attvalue`, `attartistid`, `attclassid`) VALUES
(1, '2021-03-26', 'Present', 1, 1),
(2, '2021-03-26', 'Present', 2, 1),
(3, '2021-03-28', 'Present', 1, 1),
(4, '2021-03-28', 'Absent', 2, 1),
(5, '2021-03-29', 'Present', 1, 1),
(6, '2021-03-29', 'Absent', 2, 1);

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

--
-- Table structure for table `class_tbl`
--

CREATE TABLE `class_tbl` (
  `cid` int(11) NOT NULL,
  `cname` varchar(50) NOT NULL,
  `cartist_allowed` int(11) NOT NULL,
  `cdance_type` varchar(30) NOT NULL,
  `cstatus` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `class_tbl`
--

INSERT INTO `class_tbl` (`cid`, `cname`, `cartist_allowed`, `cdance_type`, `cstatus`) VALUES
(1, 'Class A', 2, 'Ballroom', 1);

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

--
-- Table structure for table `dance_category_tbl`
--

CREATE TABLE `dance_category_tbl` (
  `did` int(11) NOT NULL,
  `dname` varchar(30) NOT NULL,
  `dstatus` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dance_category_tbl`
--

INSERT INTO `dance_category_tbl` (`did`, `dname`, `dstatus`) VALUES
(1, 'Zumba', 1),
(2, 'Ballroom', 1),
(3, 'Private Dance', 1),
(4, 'Wedding Dance', 1),
(5, 'Ballet', 1),
(6, 'Chinese dance', 1),
(7, 'Jazz', 1),
(8, 'Hip-hop', 1);

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

--
-- Table structure for table `injury_tbl`
--

CREATE TABLE `injury_tbl` (
  `injid` int(11) NOT NULL,
  `injname` varchar(50) NOT NULL,
  `injstatus` varchar(50) NOT NULL,
  `injdate` date NOT NULL,
  `injartistid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `injury_tbl`
--

INSERT INTO `injury_tbl` (`injid`, `injname`, `injstatus`, `injdate`, `injartistid`) VALUES
(1, 'injury test', 'Recovered', '2021-03-08', 1);

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

--
-- Table structure for table `users_tbl`
--

CREATE TABLE `users_tbl` (
  `uid` int(11) NOT NULL,
  `uname` varchar(50) NOT NULL,
  `uemail` varchar(50) NOT NULL,
  `upassword` varchar(50) NOT NULL,
  `urole` varchar(20) NOT NULL,
  `ustatus` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users_tbl`
--

INSERT INTO `users_tbl` (`uid`, `uname`, `uemail`, `upassword`, `urole`, `ustatus`) VALUES
(1, 'Director Test', 'director@gmail.com', 'e80b5017098950fc58aad83c8c14978e', 'director', 1),
(2, 'Coach Test', 'coach@gmail.com', 'e80b5017098950fc58aad83c8c14978e', 'coach', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `artist_tbl`
--
ALTER TABLE `artist_tbl`
  ADD PRIMARY KEY (`aid`),
  ADD KEY `aclass` (`aclass`);

--
-- Indexes for table `attendence_tbl`
--
ALTER TABLE `attendence_tbl`
  ADD PRIMARY KEY (`attid`),
  ADD KEY `attclassid` (`attclassid`),
  ADD KEY `attartistid` (`attartistid`);

--
-- Indexes for table `class_tbl`
--
ALTER TABLE `class_tbl`
  ADD PRIMARY KEY (`cid`);

--
-- Indexes for table `dance_category_tbl`
--
ALTER TABLE `dance_category_tbl`
  ADD PRIMARY KEY (`did`);

--
-- Indexes for table `injury_tbl`
--
ALTER TABLE `injury_tbl`
  ADD PRIMARY KEY (`injid`),
  ADD KEY `injartistid` (`injartistid`);

--
-- Indexes for table `users_tbl`
--
ALTER TABLE `users_tbl`
  ADD PRIMARY KEY (`uid`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `attendence_tbl`
--
ALTER TABLE `attendence_tbl`
  MODIFY `attid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

--
-- AUTO_INCREMENT for table `dance_category_tbl`
--
ALTER TABLE `dance_category_tbl`
  MODIFY `did` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `artist_tbl`
--
ALTER TABLE `artist_tbl`
  ADD CONSTRAINT `artist_tbl_ibfk_1` FOREIGN KEY (`aclass`) REFERENCES `class_tbl` (`cid`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `attendence_tbl`
--
ALTER TABLE `attendence_tbl`
  ADD CONSTRAINT `attendence_tbl_ibfk_1` FOREIGN KEY (`attclassid`) REFERENCES `class_tbl` (`cid`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `attendence_tbl_ibfk_2` FOREIGN KEY (`attartistid`) REFERENCES `artist_tbl` (`aid`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `injury_tbl`
--
ALTER TABLE `injury_tbl`
  ADD CONSTRAINT `injury_tbl_ibfk_1` FOREIGN KEY (`injartistid`) REFERENCES `artist_tbl` (`aid`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

/*!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 */;