PHP & MySQL-Based Judging Management System

Projects Inventory

7 days ago

Download code _ PHP & MySQL-Based Judging Management System

Judging Management System using PHP and MySQL

Overview

The Judging Management System is a web-based application developed using PHP and MySQL. It provides an online and automated platform for managing and scoring event contests. This system is designed for organizations that host competitions, making the judging process easier and more efficient. It has a user-friendly interface and useful features for organizers, judges, and tabulators.

How the System Works

The Judging Management System helps in managing and calculating contest scores electronically. It allows event organizers and staff to register for free. Once registered, organizers can create multiple events, add contestants, assign judges, and set scoring criteria.

Judges can enter scores using a system-generated judge code. The system automatically calculates rankings, overall scores, and event placements. It also provides real-time score tracking and review options.

Key Features and Functionalities

For Organizers:

Create and manage events
Set up sub-events and customize settings
Add and manage contestants and judges
Define judging criteria
Manage score sheets
View live scores
Review contestant scores by judge
Deduct points if needed
Generate final and overall results
Review and edit organizer details
Add or edit tabulator users

For Tabulators:

View live scores
Review contestant scores by judge
Deduct points if needed
Generate final and overall results

For Judges:

Enter and update contestant scores
View overall scores and rankings

How to Install and Run the System

Requirements:

Install a local web server like XAMPP
Download the system’s source code

Installation Steps:

Open XAMPP Control Panel and start Apache and MySQL.
Extract the downloaded source code file.
Copy the extracted folder and paste it into the htdocs directory of XAMPP.
Open PHPMyAdmin in your browser (e.g., http://localhost/phpmyadmin).
Create a new database named jms_db.
Import the provided jms_db.sql file from the db folder.
Open the system in your browser (e.g., http://localhost/php-jms/).

index PHP

<!DOCTYPE html>
<html lang="en">
  
  <?php
  include('header2.php');
  ?>

  <body>
    
    
    <!-- Navbar
    ================================================== -->
    <div class="navbar navbar-inverse navbar-fixed-top">
      <div class="navbar-inner">
        <div class="container">
 
               <a href="#" data-toggle="modal" data-target="#about-modal" class="brand"> <font size="2"style="color: white;">ABOUT</font></a> 
 
        </div>
      </div>
    </div>
    
    
<header class="jumbotron subhead" id="overview">
  <div class="container">
    <h1>Judging Management System</h1>
    <p class="lead">Ready to serve you...</p>
  </div>
</header>




    <div class="container">
    
      
      
    <!-- About EJS Modal -->
    <div class="modal fade" id="about-modal" tabindex="-1" role="dialog" aria-labelledby="Login" aria-hidden="true">
            <div class="modal-dialog modal-sm">

                <div class="modal-content">
                    <div class="modal-header">
                        <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                        <h4 class="modal-title" id="Login">About Judging Management System</h4>
                    </div>
                    <div class="modal-body">
                    
                    <table align="center">
                    
                  
                    
                    <tr>
                    <td>&nbsp;</td>
                    </tr>
                    
                    <tr>
                    <td align="right">Original Developer:</td>
                    <td><strong> Emilio B. Magtolis Jr.</strong> - Software and Web Developer</td>
                    </tr>
      
                    
                    <tr>
                    <td>&nbsp;</td>
                    </tr>
                    
                    <tr>
                    <td align="right">Email:</td>
                    <td><strong> emiloimagtolis@gmail.com</strong></td>
                    </tr>
                    
                    <tr>
                    <td>&nbsp;</td>
                    </tr>
                    
                    <tr>
                    <td align="right">Mobile Number:</td>
                    <td><strong> +639303546547</strong></td>
                    </tr>
                    
                    <tr>
                    <td>&nbsp;</td>
                    </tr>
                    
                    <tr>
                    <td align="right">Website:</td>
                    <td><a href="https://www.bee4ten.ml" target="_blank"><strong> www.bee4ten.ml</strong></a></td>
                    </tr>
        
                    </table>
                    
           
                    <br />
                    <p>This is project source code copy is a modified copy and modified by other developer. The modified copy is available @ <a href="https://sourcecodester.com">sourcecodester.com</a>.</p>

                        <hr />
                        <p class="text-center text-muted"><button class="btn btn-default" data-dismiss="modal" aria-hidden="true"><strong>Close</strong></button></p>

                    </div>
                </div>
            </div>
        </div>
        <!-- END About EJS Modal -->
        
        
              
   <form method="POST" action="login.php" >
 <br />  
 <table cellpadding="10" cellspacing="0" border="0" align="center">
 <thead>
 <th align="center" style="background-color: #6A8CAF; text-indent: 7px; color: white; "><h4>USER LOGIN</h4></th>
 </thead>
 
 <tr style="background-color: #b0c7de;">
 
 <td>
 
 
  <h5><i class="icon-user"></i>  USERNAME:</h5>
  <input style="font-size: large; height: 35px !important; text-indent: 7px !important;" class="form-control btn-block" type="text" name="username" placeholder="Username" required="true" autofocus="true" />
 
 <h5><i class="icon-lock"></i>  PASSWORD:</h5>
  <input style="font-size: large; height: 35px !important; text-indent: 7px !important;" class="form-control btn-block" type="password"  name="password" placeholder="Password" required="true" autofocus="true" />
<br /><br />
 
  <button style="width: 160px !important;" type="submit" class="btn btn-primary pull-right"><i class="icon-ok"></i> <strong>LOGIN</strong></button>
  <strong>Register <a href="create_account.php">here &raquo;</a></strong> &nbsp;&nbsp;&nbsp; 
  
 </td>
 </tr>
 
 
 </table>
 
 

   </form>
 
 
    
            </div>
 
   


    <!-- Footer
    ================================================== -->
    <footer class="footer">
      <div class="container">
      
        <font size="2" class="pull-left"><strong>Judging Management System &COPY; <?= date("Y") ?>  </strong></font> <br />
        
      </div>
    </footer>


    <!-- Le javascript
    ================================================== -->
    <!-- Placed at the end of the document so the pages load faster -->
 
    <script src="assets/js/jquery.js"></script>
    <script src="assets/js/bootstrap-transition.js"></script>
    <script src="assets/js/bootstrap-alert.js"></script>
    <script src="assets/js/bootstrap-modal.js"></script>
    <script src="assets/js/bootstrap-dropdown.js"></script>
    <script src="assets/js/bootstrap-scrollspy.js"></script>
    <script src="assets/js/bootstrap-tab.js"></script>
    <script src="assets/js/bootstrap-tooltip.js"></script>
    <script src="assets/js/bootstrap-popover.js"></script>
    <script src="assets/js/bootstrap-button.js"></script>
    <script src="assets/js/bootstrap-collapse.js"></script>
    <script src="assets/js/bootstrap-carousel.js"></script>
    <script src="assets/js/bootstrap-typeahead.js"></script>
    <script src="assets/js/bootstrap-affix.js"></script>
    <script src="assets/js/holder/holder.js"></script>
    <script src="assets/js/google-code-prettify/prettify.js"></script>
    <script src="assets/js/application.js"></script>
    
  </body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

<!DOCTYPE html>

<?php

include('header2.php');

<body>

<!-- Navbar

================================================== -->

<a href="#" data-toggle="modal" data-target="#about-modal" class="brand"> <font size="2"style="color: white;">ABOUT</font></a>

</div>

<h1>Judging Management System</h1>

<p class="lead">Ready to serve you...</p>

</div>

</header>

<h4 class="modal-title" id="Login">About Judging Management System</h4>

</div>

<tr>

</tr>

<tr>

<td align="right">Original Developer:</td>

<td><strong> Emilio B. Magtolis Jr.</strong> - Software and Web Developer</td>

</tr>

<tr>

</tr>

<tr>

<td align="right">Email:</td>

<td><strong> emiloimagtolis@gmail.com</strong></td>

</tr>

<tr>

</tr>

<tr>

<td align="right">Mobile Number:</td>

</tr>

<tr>

</tr>

<tr>

<td align="right">Website:</td>

</tr>

</table>

<br />

<p>This is project source code copy is a modified copy and modified by other developer. The modified copy is available @ <a href="https://sourcecodester.com">sourcecodester.com</a>.</p>

<hr />

<p class="text-center text-muted"><button class="btn btn-default" data-dismiss="modal" aria-hidden="true"><strong>Close</strong></button></p>

</div>

<br />

<thead>

<th align="center" style="background-color: #6A8CAF; text-indent: 7px; color: white; "><h4>USER LOGIN</h4></th>

</thead>

<td>

<h5><i class="icon-user"></i> USERNAME:</h5>

<h5><i class="icon-lock"></i> PASSWORD:</h5>

<button style="width: 160px !important;" type="submit" class="btn btn-primary pull-right"><i class="icon-ok"></i> <strong>LOGIN</strong></button>

<strong>Register <a href="create_account.php">here »</a></strong>    

</td>

</tr>

</table>

</form>

</div>

<!-- Footer

================================================== -->

<font size="2" class="pull-left"><strong>Judging Management System &COPY; <?= date("Y") ?> </strong></font> <br />

</div>

</footer>

<!-- Le javascript

================================================== -->

</body>

</html>

login PHP

<?php
		include('dbcon.php');
		session_start();
		$username = $_POST['username'];
		$password = $_POST['password'];
		/* student */
			$query = $conn->query("SELECT * FROM organizer WHERE username='$username' AND password='$password'");
			$row = $query->fetch();
			$num_row = $query->rowcount();
		if( $num_row > 0 ) { 
		  
	 if($row['access']=="Organizer")
     {
        $_SESSION['useraccess']="Organizer";
        $_SESSION['id']=$row['organizer_id'];
        
        ?>	<script>window.location = 'selection.php';</script><?php
        	
     }
     else
     {
        
        $_SESSION['useraccess']="Tabulator";
        $_SESSION['id']=$row['org_id'];
        $_SESSION['userid']=$row['organizer_id'];
        
        ?>	<script>window.location = 'score_sheets.php';</script><?php
        	
     }
        
		}else{ 
			?>	<script>
              alert('Username and Password did not Match');
			  window.location = 'index.php';
			    </script><?php	
		}	
				
		?>

<?php

include('dbcon.php');

session_start();

$username = $_POST['username'];

$password = $_POST['password'];

/* student */

$query = $conn->query("SELECT * FROM organizer WHERE username='$username' AND password='$password'");

$row = $query->fetch();

$num_row = $query->rowcount();

if( $num_row > 0 ) {

if($row['access']=="Organizer")

{

$_SESSION['useraccess']="Organizer";

$_SESSION['id']=$row['organizer_id'];

?> <script>window.location = 'selection.php';</script><?php

}

else

{

$_SESSION['useraccess']="Tabulator";

$_SESSION['id']=$row['org_id'];

$_SESSION['userid']=$row['organizer_id'];

?> <script>window.location = 'score_sheets.php';</script><?php

}

}else{

?> <script>

alert('Username and Password did not Match');

window.location = 'index.php';

</script><?php

}

jms_db SQL

-- phpMyAdmin SQL Dump
-- version 5.1.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 02, 2022 at 06:34 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: `jms_db`
--

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

--
-- Table structure for table `contestants`
--

CREATE TABLE `contestants` (
  `contestant_id` int(11) NOT NULL,
  `fullname` text NOT NULL,
  `subevent_id` int(11) NOT NULL,
  `contestant_ctr` int(11) NOT NULL,
  `status` text NOT NULL,
  `txt_code` text NOT NULL,
  `rand_code` int(15) NOT NULL,
  `txtPollScore` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contestants`
--

INSERT INTO `contestants` (`contestant_id`, `fullname`, `subevent_id`, `contestant_ctr`, `status`, `txt_code`, `rand_code`, `txtPollScore`) VALUES
(5, 'Contestant 101', 2, 1, 'finish', '', 829106, 0),
(6, 'Contestant 102', 2, 2, 'finish', '', 314095, 0),
(7, 'Contestant 103', 2, 3, 'finish', '', 8021723, 0),
(8, 'Contestant 104', 2, 4, 'finish', '', 8021724, 0),
(9, 'Contestant 105', 2, 5, 'finish', '', 8021725, 0),
(10, 'Contestant 106', 2, 6, 'finish', '', 8021726, 0);

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

--
-- Table structure for table `criteria`
--

CREATE TABLE `criteria` (
  `criteria_id` int(11) NOT NULL,
  `subevent_id` int(11) NOT NULL,
  `criteria` text NOT NULL,
  `percentage` int(11) NOT NULL,
  `criteria_ctr` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `criteria`
--

INSERT INTO `criteria` (`criteria_id`, `subevent_id`, `criteria`, `percentage`, `criteria_ctr`) VALUES
(3, 2, 'Criteria 101', 10, 1),
(4, 2, 'Criteria 102', 30, 2),
(5, 2, 'Criteria 103', 20, 3),
(6, 2, 'Criteria 104', 40, 4);

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

--
-- Table structure for table `judges`
--

CREATE TABLE `judges` (
  `judge_id` int(11) NOT NULL,
  `subevent_id` int(11) NOT NULL,
  `judge_ctr` int(11) NOT NULL,
  `fullname` text NOT NULL,
  `code` varchar(6) NOT NULL,
  `jtype` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `judges`
--

INSERT INTO `judges` (`judge_id`, `subevent_id`, `judge_ctr`, `fullname`, `code`, `jtype`) VALUES
(4, 2, 1, 'Judge 101', 'zwr37i', ''),
(5, 2, 2, 'Judge 102', 'yy6aaj', ''),
(6, 2, 3, 'Judge 103', 'hx1ixu', ''),
(7, 2, 4, 'Judge 104', 'pzrun4', '');

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

--
-- Table structure for table `main_event`
--

CREATE TABLE `main_event` (
  `mainevent_id` int(11) NOT NULL,
  `event_name` text NOT NULL,
  `status` text NOT NULL,
  `organizer_id` int(11) NOT NULL,
  `sy` varchar(9) NOT NULL,
  `date_start` text NOT NULL,
  `date_end` text NOT NULL,
  `place` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `main_event`
--

INSERT INTO `main_event` (`mainevent_id`, `event_name`, `status`, `organizer_id`, `sy`, `date_start`, `date_end`, `place`) VALUES
(2, 'Sample Event Only', 'activated', 21, '2022-2023', '2022-12-01', '2022-12-05', 'Sample Venue only');

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

--
-- Table structure for table `messagein`
--

CREATE TABLE `messagein` (
  `Id` int(11) NOT NULL,
  `SendTime` varchar(10) DEFAULT NULL,
  `ReceiveTime` varchar(10) DEFAULT NULL,
  `MessageFrom` bigint(12) DEFAULT NULL,
  `MessageTo` varchar(10) DEFAULT NULL,
  `SMSC` varchar(10) DEFAULT NULL,
  `MessageText` varchar(4) DEFAULT NULL,
  `MessageType` varchar(10) DEFAULT NULL,
  `MessagePDU` varchar(10) DEFAULT NULL,
  `Gateway` varchar(10) DEFAULT NULL,
  `UserId` varchar(10) DEFAULT NULL,
  `sendStatus` varchar(25) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `messagelog`
--

CREATE TABLE `messagelog` (
  `Id` int(11) NOT NULL,
  `SendTime` datetime DEFAULT NULL,
  `ReceiveTime` datetime DEFAULT NULL,
  `StatusCode` int(11) DEFAULT NULL,
  `StatusText` varchar(80) DEFAULT NULL,
  `MessageTo` varchar(80) DEFAULT NULL,
  `MessageFrom` varchar(80) DEFAULT NULL,
  `MessageText` text DEFAULT NULL,
  `MessageType` varchar(80) DEFAULT NULL,
  `MessageId` varchar(80) DEFAULT NULL,
  `ErrorCode` varchar(80) DEFAULT NULL,
  `ErrorText` varchar(80) DEFAULT NULL,
  `Gateway` varchar(80) DEFAULT NULL,
  `MessageParts` int(11) DEFAULT NULL,
  `MessagePDU` text DEFAULT NULL,
  `Connector` varchar(80) DEFAULT NULL,
  `UserId` varchar(80) DEFAULT NULL,
  `UserInfo` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `messageout`
--

CREATE TABLE `messageout` (
  `Id` int(11) NOT NULL,
  `MessageTo` varchar(80) DEFAULT NULL,
  `MessageFrom` varchar(80) DEFAULT NULL,
  `MessageText` text DEFAULT NULL,
  `MessageType` varchar(80) DEFAULT NULL,
  `Gateway` varchar(80) DEFAULT NULL,
  `UserId` varchar(80) DEFAULT NULL,
  `UserInfo` text DEFAULT NULL,
  `Priority` int(11) DEFAULT NULL,
  `Scheduled` datetime DEFAULT NULL,
  `ValidityPeriod` int(11) DEFAULT NULL,
  `IsSent` tinyint(1) NOT NULL DEFAULT 0,
  `IsRead` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `organizer`
--

CREATE TABLE `organizer` (
  `organizer_id` int(11) NOT NULL,
  `fname` text NOT NULL,
  `mname` text NOT NULL,
  `lname` text NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `email` varchar(50) NOT NULL,
  `pnum` varchar(15) NOT NULL,
  `access` varchar(25) NOT NULL,
  `org_id` varchar(12) NOT NULL,
  `status` varchar(12) NOT NULL,
  `company_name` varchar(55) NOT NULL,
  `company_address` varchar(55) NOT NULL,
  `company_logo` varchar(55) NOT NULL,
  `company_telephone` varchar(55) NOT NULL,
  `company_email` varchar(55) NOT NULL,
  `company_website` varchar(55) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `organizer`
--

INSERT INTO `organizer` (`organizer_id`, `fname`, `mname`, `lname`, `username`, `password`, `email`, `pnum`, `access`, `org_id`, `status`, `company_name`, `company_address`, `company_logo`, `company_telephone`, `company_email`, `company_website`) VALUES
(21, 'Mark', 'D', 'Cooper', 'mcooper', 'mcooper123', 'mcooper@mail.com', '0912354879', 'Organizer', '', 'offline', 'Sample Company 101', 'Sample Address 123', '70493-lorem-ipsum.jpg', '+12356489', 'sample@testmail.com', 'N/A'),
(22, 'judge 1', 'j', 'judge', 'judge101', 'judge101', '', '', 'Organizer', '', 'offline', '', '', '', '', '', ''),
(23, 'Samantha', 'S', 'Lou', 'sam', 'sam123', '', '', 'Tabulator', '21', 'offline', '', '', '', '', '', '');

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

--
-- Table structure for table `rank_system`
--

CREATE TABLE `rank_system` (
  `rs_id` int(11) NOT NULL,
  `subevent_id` varchar(12) NOT NULL,
  `contestant_id` varchar(12) NOT NULL,
  `total_rank` decimal(3,1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rank_system`
--

INSERT INTO `rank_system` (`rs_id`, `subevent_id`, `contestant_id`, `total_rank`) VALUES
(1, '2', '5', '9.0'),
(2, '2', '6', '6.0'),
(3, '2', '7', '10.0'),
(4, '2', '8', '7.0'),
(5, '2', '9', '7.0'),
(6, '2', '10', '3.0');

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

--
-- Table structure for table `sub_event`
--

CREATE TABLE `sub_event` (
  `subevent_id` int(11) NOT NULL,
  `mainevent_id` int(11) NOT NULL,
  `organizer_id` int(11) NOT NULL,
  `event_name` text NOT NULL,
  `status` text NOT NULL,
  `eventdate` text NOT NULL,
  `eventtime` text NOT NULL,
  `place` text NOT NULL,
  `txtpoll_status` text NOT NULL,
  `view` varchar(15) NOT NULL,
  `txtpollview` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sub_event`
--

INSERT INTO `sub_event` (`subevent_id`, `mainevent_id`, `organizer_id`, `event_name`, `status`, `eventdate`, `eventtime`, `place`, `txtpoll_status`, `view`, `txtpollview`) VALUES
(2, 2, 21, 'Test Sub Event', 'activated', '2022-12-02', '11:00', 'Sample Sub Event', 'active', 'activated', 'active');

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

--
-- Table structure for table `sub_results`
--

CREATE TABLE `sub_results` (
  `subresult_id` int(11) NOT NULL,
  `subevent_id` int(11) NOT NULL,
  `mainevent_id` int(11) NOT NULL,
  `contestant_id` int(11) NOT NULL,
  `judge_id` int(11) NOT NULL,
  `total_score` decimal(11,1) NOT NULL,
  `deduction` int(11) NOT NULL,
  `criteria_ctr1` decimal(11,1) NOT NULL,
  `criteria_ctr2` decimal(11,1) NOT NULL,
  `criteria_ctr3` decimal(11,1) NOT NULL,
  `criteria_ctr4` decimal(11,1) NOT NULL,
  `criteria_ctr5` decimal(11,1) NOT NULL,
  `criteria_ctr6` decimal(11,1) NOT NULL,
  `criteria_ctr7` decimal(11,1) NOT NULL,
  `criteria_ctr8` decimal(11,1) NOT NULL,
  `criteria_ctr9` decimal(11,1) NOT NULL,
  `criteria_ctr10` decimal(11,1) NOT NULL,
  `comments` text NOT NULL,
  `rank` varchar(11) NOT NULL,
  `judge_rank_stat` varchar(15) NOT NULL,
  `place_title` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sub_results`
--

INSERT INTO `sub_results` (`subresult_id`, `subevent_id`, `mainevent_id`, `contestant_id`, `judge_id`, `total_score`, `deduction`, `criteria_ctr1`, `criteria_ctr2`, `criteria_ctr3`, `criteria_ctr4`, `criteria_ctr5`, `criteria_ctr6`, `criteria_ctr7`, `criteria_ctr8`, `criteria_ctr9`, `criteria_ctr10`, `comments`, `rank`, `judge_rank_stat`, `place_title`) VALUES
(1, 2, 2, 5, 4, '76.0', 0, '10.0', '8.5', '18.5', '39.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', 'Sample Comment', '6', '', '5th'),
(2, 2, 2, 6, 4, '89.5', 0, '8.5', '27.0', '17.5', '36.5', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', 'test', '5', '', '2nd'),
(3, 2, 2, 7, 4, '93.5', 0, '9.0', '29.5', '18.0', '37.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '4', '', '6th'),
(4, 2, 2, 8, 4, '97.5', 0, '10.0', '28.5', '19.5', '39.5', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', 'Sample', '2', '', '3rd'),
(5, 2, 2, 9, 4, '95.0', 0, '9.5', '29.0', '18.0', '38.5', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '3', '', '4th'),
(6, 2, 2, 10, 4, '99.0', 0, '9.5', '29.5', '20.0', '40.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '1', '', '1st'),
(7, 2, 2, 5, 5, '95.0', 0, '10.0', '29.0', '16.5', '39.5', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '3', '', '5th'),
(8, 2, 2, 6, 5, '96.0', 0, '10.0', '29.0', '18.5', '38.5', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '1', '', '2nd'),
(9, 2, 2, 7, 5, '84.5', 0, '9.5', '28.0', '8.0', '39.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '6', '', '6th'),
(10, 2, 2, 8, 5, '94.0', 0, '9.0', '28.0', '19.0', '38.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '5', '', '3rd'),
(11, 2, 2, 9, 5, '94.5', 0, '8.0', '28.0', '19.5', '39.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '4', '', '4th'),
(12, 2, 2, 10, 5, '95.5', 0, '9.5', '29.0', '17.5', '39.5', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '2', '', '1st');

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

--
-- Table structure for table `textpoll`
--

CREATE TABLE `textpoll` (
  `textpoll_id` int(11) NOT NULL,
  `contestant_id` varchar(12) NOT NULL,
  `text_vote` int(11) NOT NULL,
  `subevent_id` varchar(12) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `contestants`
--
ALTER TABLE `contestants`
  ADD PRIMARY KEY (`contestant_id`);

--
-- Indexes for table `criteria`
--
ALTER TABLE `criteria`
  ADD PRIMARY KEY (`criteria_id`);

--
-- Indexes for table `judges`
--
ALTER TABLE `judges`
  ADD PRIMARY KEY (`judge_id`);

--
-- Indexes for table `main_event`
--
ALTER TABLE `main_event`
  ADD PRIMARY KEY (`mainevent_id`);

--
-- Indexes for table `messagein`
--
ALTER TABLE `messagein`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `messagelog`
--
ALTER TABLE `messagelog`
  ADD PRIMARY KEY (`Id`),
  ADD KEY `IDX_MessageId` (`MessageId`,`SendTime`);

--
-- Indexes for table `messageout`
--
ALTER TABLE `messageout`
  ADD PRIMARY KEY (`Id`),
  ADD KEY `IDX_IsRead` (`IsRead`);

--
-- Indexes for table `organizer`
--
ALTER TABLE `organizer`
  ADD PRIMARY KEY (`organizer_id`);

--
-- Indexes for table `rank_system`
--
ALTER TABLE `rank_system`
  ADD PRIMARY KEY (`rs_id`);

--
-- Indexes for table `sub_event`
--
ALTER TABLE `sub_event`
  ADD PRIMARY KEY (`subevent_id`);

--
-- Indexes for table `sub_results`
--
ALTER TABLE `sub_results`
  ADD PRIMARY KEY (`subresult_id`);

--
-- Indexes for table `textpoll`
--
ALTER TABLE `textpoll`
  ADD PRIMARY KEY (`textpoll_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `contestants`
--
ALTER TABLE `contestants`
  MODIFY `contestant_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

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

--
-- AUTO_INCREMENT for table `judges`
--
ALTER TABLE `judges`
  MODIFY `judge_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

--
-- AUTO_INCREMENT for table `messagein`
--
ALTER TABLE `messagein`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messagelog`
--
ALTER TABLE `messagelog`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messageout`
--
ALTER TABLE `messageout`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `organizer`
--
ALTER TABLE `organizer`
  MODIFY `organizer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

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

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

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

--
-- AUTO_INCREMENT for table `textpoll`
--
ALTER TABLE `textpoll`
  MODIFY `textpoll_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

418

419

420

421

422

423

424

425

426

427

428

429

430

431

432

433

434

435

436

437

438

439

440

441

442

443

444

445

446

447

448

449

450

451

452

453

454

455

456

457

458

459

460

461

462

463

464

465

466

467

468

469

470

471

472

473

474

475

476

477

478

479

480

481

482

483

484

485

486

487

488

489

490

491

-- phpMyAdmin SQL Dump

-- version 5.1.3

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

-- Host: 127.0.0.1

-- Generation Time: Dec 02, 2022 at 06:34 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: `jms_db`

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

-- Table structure for table `contestants`

CREATE TABLE `contestants` (

`contestant_id` int(11) NOT NULL,

`fullname` text NOT NULL,

`subevent_id` int(11) NOT NULL,

`contestant_ctr` int(11) NOT NULL,

`status` text NOT NULL,

`txt_code` text NOT NULL,

`rand_code` int(15) NOT NULL,

`txtPollScore` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `contestants`

INSERT INTO `contestants` (`contestant_id`, `fullname`, `subevent_id`, `contestant_ctr`, `status`, `txt_code`, `rand_code`, `txtPollScore`) VALUES

(5, 'Contestant 101', 2, 1, 'finish', '', 829106, 0),

(6, 'Contestant 102', 2, 2, 'finish', '', 314095, 0),

(7, 'Contestant 103', 2, 3, 'finish', '', 8021723, 0),

(8, 'Contestant 104', 2, 4, 'finish', '', 8021724, 0),

(9, 'Contestant 105', 2, 5, 'finish', '', 8021725, 0),

(10, 'Contestant 106', 2, 6, 'finish', '', 8021726, 0);

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

-- Table structure for table `criteria`

CREATE TABLE `criteria` (

`criteria_id` int(11) NOT NULL,

`subevent_id` int(11) NOT NULL,

`criteria` text NOT NULL,

`percentage` int(11) NOT NULL,

`criteria_ctr` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `criteria`

INSERT INTO `criteria` (`criteria_id`, `subevent_id`, `criteria`, `percentage`, `criteria_ctr`) VALUES

(3, 2, 'Criteria 101', 10, 1),

(4, 2, 'Criteria 102', 30, 2),

(5, 2, 'Criteria 103', 20, 3),

(6, 2, 'Criteria 104', 40, 4);

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

-- Table structure for table `judges`

CREATE TABLE `judges` (

`judge_id` int(11) NOT NULL,

`subevent_id` int(11) NOT NULL,

`judge_ctr` int(11) NOT NULL,

`fullname` text NOT NULL,

`code` varchar(6) NOT NULL,

`jtype` varchar(25) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `judges`

INSERT INTO `judges` (`judge_id`, `subevent_id`, `judge_ctr`, `fullname`, `code`, `jtype`) VALUES

(4, 2, 1, 'Judge 101', 'zwr37i', ''),

(5, 2, 2, 'Judge 102', 'yy6aaj', ''),

(6, 2, 3, 'Judge 103', 'hx1ixu', ''),

(7, 2, 4, 'Judge 104', 'pzrun4', '');

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

-- Table structure for table `main_event`

CREATE TABLE `main_event` (

`mainevent_id` int(11) NOT NULL,

`event_name` text NOT NULL,

`status` text NOT NULL,

`organizer_id` int(11) NOT NULL,

`sy` varchar(9) NOT NULL,

`date_start` text NOT NULL,

`date_end` text NOT NULL,

`place` text NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `main_event`

INSERT INTO `main_event` (`mainevent_id`, `event_name`, `status`, `organizer_id`, `sy`, `date_start`, `date_end`, `place`) VALUES

(2, 'Sample Event Only', 'activated', 21, '2022-2023', '2022-12-01', '2022-12-05', 'Sample Venue only');

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

-- Table structure for table `messagein`

CREATE TABLE `messagein` (

`Id` int(11) NOT NULL,

`SendTime` varchar(10) DEFAULT NULL,

`ReceiveTime` varchar(10) DEFAULT NULL,

`MessageFrom` bigint(12) DEFAULT NULL,

`MessageTo` varchar(10) DEFAULT NULL,

`SMSC` varchar(10) DEFAULT NULL,

`MessageText` varchar(4) DEFAULT NULL,

`MessageType` varchar(10) DEFAULT NULL,

`MessagePDU` varchar(10) DEFAULT NULL,

`Gateway` varchar(10) DEFAULT NULL,

`UserId` varchar(10) DEFAULT NULL,

`sendStatus` varchar(25) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

-- Table structure for table `messagelog`

CREATE TABLE `messagelog` (

`Id` int(11) NOT NULL,

`SendTime` datetime DEFAULT NULL,

`ReceiveTime` datetime DEFAULT NULL,

`StatusCode` int(11) DEFAULT NULL,

`StatusText` varchar(80) DEFAULT NULL,

`MessageTo` varchar(80) DEFAULT NULL,

`MessageFrom` varchar(80) DEFAULT NULL,

`MessageText` text DEFAULT NULL,

`MessageType` varchar(80) DEFAULT NULL,

`MessageId` varchar(80) DEFAULT NULL,

`ErrorCode` varchar(80) DEFAULT NULL,

`ErrorText` varchar(80) DEFAULT NULL,

`Gateway` varchar(80) DEFAULT NULL,

`MessageParts` int(11) DEFAULT NULL,

`MessagePDU` text DEFAULT NULL,

`Connector` varchar(80) DEFAULT NULL,

`UserId` varchar(80) DEFAULT NULL,

`UserInfo` text DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

-- Table structure for table `messageout`

CREATE TABLE `messageout` (

`Id` int(11) NOT NULL,

`MessageTo` varchar(80) DEFAULT NULL,

`MessageFrom` varchar(80) DEFAULT NULL,

`MessageText` text DEFAULT NULL,

`MessageType` varchar(80) DEFAULT NULL,

`Gateway` varchar(80) DEFAULT NULL,

`UserId` varchar(80) DEFAULT NULL,

`UserInfo` text DEFAULT NULL,

`Priority` int(11) DEFAULT NULL,

`Scheduled` datetime DEFAULT NULL,

`ValidityPeriod` int(11) DEFAULT NULL,

`IsSent` tinyint(1) NOT NULL DEFAULT 0,

`IsRead` tinyint(1) NOT NULL DEFAULT 0

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

-- Table structure for table `organizer`

CREATE TABLE `organizer` (

`organizer_id` int(11) NOT NULL,

`fname` text NOT NULL,

`mname` text NOT NULL,

`lname` text NOT NULL,

`username` text NOT NULL,

`password` text NOT NULL,

`email` varchar(50) NOT NULL,

`pnum` varchar(15) NOT NULL,

`access` varchar(25) NOT NULL,

`org_id` varchar(12) NOT NULL,

`status` varchar(12) NOT NULL,

`company_name` varchar(55) NOT NULL,

`company_address` varchar(55) NOT NULL,

`company_logo` varchar(55) NOT NULL,

`company_telephone` varchar(55) NOT NULL,

`company_email` varchar(55) NOT NULL,

`company_website` varchar(55) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `organizer`

INSERT INTO `organizer` (`organizer_id`, `fname`, `mname`, `lname`, `username`, `password`, `email`, `pnum`, `access`, `org_id`, `status`, `company_name`, `company_address`, `company_logo`, `company_telephone`, `company_email`, `company_website`) VALUES

(21, 'Mark', 'D', 'Cooper', 'mcooper', 'mcooper123', 'mcooper@mail.com', '0912354879', 'Organizer', '', 'offline', 'Sample Company 101', 'Sample Address 123', '70493-lorem-ipsum.jpg', '+12356489', 'sample@testmail.com', 'N/A'),

(22, 'judge 1', 'j', 'judge', 'judge101', 'judge101', '', '', 'Organizer', '', 'offline', '', '', '', '', '', ''),

(23, 'Samantha', 'S', 'Lou', 'sam', 'sam123', '', '', 'Tabulator', '21', 'offline', '', '', '', '', '', '');

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

-- Table structure for table `rank_system`

CREATE TABLE `rank_system` (

`rs_id` int(11) NOT NULL,

`subevent_id` varchar(12) NOT NULL,

`contestant_id` varchar(12) NOT NULL,

`total_rank` decimal(3,1) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `rank_system`

INSERT INTO `rank_system` (`rs_id`, `subevent_id`, `contestant_id`, `total_rank`) VALUES

(1, '2', '5', '9.0'),

(2, '2', '6', '6.0'),

(3, '2', '7', '10.0'),

(4, '2', '8', '7.0'),

(5, '2', '9', '7.0'),

(6, '2', '10', '3.0');

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

-- Table structure for table `sub_event`

CREATE TABLE `sub_event` (

`subevent_id` int(11) NOT NULL,

`mainevent_id` int(11) NOT NULL,

`organizer_id` int(11) NOT NULL,

`event_name` text NOT NULL,

`status` text NOT NULL,

`eventdate` text NOT NULL,

`eventtime` text NOT NULL,

`place` text NOT NULL,

`txtpoll_status` text NOT NULL,

`view` varchar(15) NOT NULL,

`txtpollview` varchar(15) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `sub_event`

INSERT INTO `sub_event` (`subevent_id`, `mainevent_id`, `organizer_id`, `event_name`, `status`, `eventdate`, `eventtime`, `place`, `txtpoll_status`, `view`, `txtpollview`) VALUES

(2, 2, 21, 'Test Sub Event', 'activated', '2022-12-02', '11:00', 'Sample Sub Event', 'active', 'activated', 'active');

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

-- Table structure for table `sub_results`

CREATE TABLE `sub_results` (

`subresult_id` int(11) NOT NULL,

`subevent_id` int(11) NOT NULL,

`mainevent_id` int(11) NOT NULL,

`contestant_id` int(11) NOT NULL,

`judge_id` int(11) NOT NULL,

`total_score` decimal(11,1) NOT NULL,

`deduction` int(11) NOT NULL,

`criteria_ctr1` decimal(11,1) NOT NULL,

`criteria_ctr2` decimal(11,1) NOT NULL,

`criteria_ctr3` decimal(11,1) NOT NULL,

`criteria_ctr4` decimal(11,1) NOT NULL,

`criteria_ctr5` decimal(11,1) NOT NULL,

`criteria_ctr6` decimal(11,1) NOT NULL,

`criteria_ctr7` decimal(11,1) NOT NULL,

`criteria_ctr8` decimal(11,1) NOT NULL,

`criteria_ctr9` decimal(11,1) NOT NULL,

`criteria_ctr10` decimal(11,1) NOT NULL,

`comments` text NOT NULL,

`rank` varchar(11) NOT NULL,

`judge_rank_stat` varchar(15) NOT NULL,

`place_title` varchar(25) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `sub_results`

INSERT INTO `sub_results` (`subresult_id`, `subevent_id`, `mainevent_id`, `contestant_id`, `judge_id`, `total_score`, `deduction`, `criteria_ctr1`, `criteria_ctr2`, `criteria_ctr3`, `criteria_ctr4`, `criteria_ctr5`, `criteria_ctr6`, `criteria_ctr7`, `criteria_ctr8`, `criteria_ctr9`, `criteria_ctr10`, `comments`, `rank`, `judge_rank_stat`, `place_title`) VALUES

(1, 2, 2, 5, 4, '76.0', 0, '10.0', '8.5', '18.5', '39.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', 'Sample Comment', '6', '', '5th'),

(2, 2, 2, 6, 4, '89.5', 0, '8.5', '27.0', '17.5', '36.5', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', 'test', '5', '', '2nd'),

(3, 2, 2, 7, 4, '93.5', 0, '9.0', '29.5', '18.0', '37.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '4', '', '6th'),

(4, 2, 2, 8, 4, '97.5', 0, '10.0', '28.5', '19.5', '39.5', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', 'Sample', '2', '', '3rd'),

(5, 2, 2, 9, 4, '95.0', 0, '9.5', '29.0', '18.0', '38.5', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '3', '', '4th'),

(6, 2, 2, 10, 4, '99.0', 0, '9.5', '29.5', '20.0', '40.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '1', '', '1st'),

(7, 2, 2, 5, 5, '95.0', 0, '10.0', '29.0', '16.5', '39.5', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '3', '', '5th'),

(8, 2, 2, 6, 5, '96.0', 0, '10.0', '29.0', '18.5', '38.5', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '1', '', '2nd'),

(9, 2, 2, 7, 5, '84.5', 0, '9.5', '28.0', '8.0', '39.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '6', '', '6th'),

(10, 2, 2, 8, 5, '94.0', 0, '9.0', '28.0', '19.0', '38.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '5', '', '3rd'),

(11, 2, 2, 9, 5, '94.5', 0, '8.0', '28.0', '19.5', '39.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '4', '', '4th'),

(12, 2, 2, 10, 5, '95.5', 0, '9.5', '29.0', '17.5', '39.5', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '', '2', '', '1st');

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

-- Table structure for table `textpoll`

CREATE TABLE `textpoll` (

`textpoll_id` int(11) NOT NULL,

`contestant_id` varchar(12) NOT NULL,

`text_vote` int(11) NOT NULL,

`subevent_id` varchar(12) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Indexes for dumped tables

-- Indexes for table `contestants`

ALTER TABLE `contestants`

ADD PRIMARY KEY (`contestant_id`);

-- Indexes for table `criteria`

ALTER TABLE `criteria`

ADD PRIMARY KEY (`criteria_id`);

-- Indexes for table `judges`

ALTER TABLE `judges`

ADD PRIMARY KEY (`judge_id`);

-- Indexes for table `main_event`

ALTER TABLE `main_event`

ADD PRIMARY KEY (`mainevent_id`);

-- Indexes for table `messagein`

ALTER TABLE `messagein`

ADD PRIMARY KEY (`Id`);

-- Indexes for table `messagelog`

ALTER TABLE `messagelog`

ADD PRIMARY KEY (`Id`),

ADD KEY `IDX_MessageId` (`MessageId`,`SendTime`);

-- Indexes for table `messageout`

ALTER TABLE `messageout`

ADD PRIMARY KEY (`Id`),

ADD KEY `IDX_IsRead` (`IsRead`);

-- Indexes for table `organizer`

ALTER TABLE `organizer`

ADD PRIMARY KEY (`organizer_id`);

-- Indexes for table `rank_system`

ALTER TABLE `rank_system`

ADD PRIMARY KEY (`rs_id`);

-- Indexes for table `sub_event`

ALTER TABLE `sub_event`

ADD PRIMARY KEY (`subevent_id`);

-- Indexes for table `sub_results`

ALTER TABLE `sub_results`

ADD PRIMARY KEY (`subresult_id`);

-- Indexes for table `textpoll`

ALTER TABLE `textpoll`

ADD PRIMARY KEY (`textpoll_id`);

-- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table `contestants`

ALTER TABLE `contestants`

MODIFY `contestant_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

-- AUTO_INCREMENT for table `criteria`

ALTER TABLE `criteria`

MODIFY `criteria_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

-- AUTO_INCREMENT for table `judges`

ALTER TABLE `judges`

MODIFY `judge_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

-- AUTO_INCREMENT for table `main_event`

ALTER TABLE `main_event`

MODIFY `mainevent_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

-- AUTO_INCREMENT for table `messagein`

ALTER TABLE `messagein`

MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;

-- AUTO_INCREMENT for table `messagelog`

ALTER TABLE `messagelog`

MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;

-- AUTO_INCREMENT for table `messageout`

ALTER TABLE `messageout`

MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;

-- AUTO_INCREMENT for table `organizer`

ALTER TABLE `organizer`

MODIFY `organizer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

-- AUTO_INCREMENT for table `rank_system`

ALTER TABLE `rank_system`

MODIFY `rs_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

-- AUTO_INCREMENT for table `sub_event`

ALTER TABLE `sub_event`

MODIFY `subevent_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

-- AUTO_INCREMENT for table `sub_results`

ALTER TABLE `sub_results`

MODIFY `subresult_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

-- AUTO_INCREMENT for table `textpoll`

ALTER TABLE `textpoll`

MODIFY `textpoll_id` int(11) NOT NULL AUTO_INCREMENT;

COMMIT;

Download code _ PHP & MySQL-Based Judging Management System

Judging Management System using PHP and MySQL

Overview

How the System Works

Key Features and Functionalities

For Organizers:

For Tabulators:

For Judges:

How to Install and Run the System

Requirements:

Installation Steps:

index PHP

login PHP

jms_db SQL

Related Posts: