-- MySQL dump 10.13  Distrib 8.4.11, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: marthoma_kalolsavam
-- ------------------------------------------------------
-- Server version	8.4.11

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `auth_group`
--

DROP TABLE IF EXISTS `auth_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `auth_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_group`
--

LOCK TABLES `auth_group` WRITE;
/*!40000 ALTER TABLE `auth_group` DISABLE KEYS */;
INSERT INTO `auth_group` VALUES (1,'School User');
/*!40000 ALTER TABLE `auth_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `auth_group_permissions`
--

DROP TABLE IF EXISTS `auth_group_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `auth_group_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_group_permissions`
--

LOCK TABLES `auth_group_permissions` WRITE;
/*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `auth_permission`
--

DROP TABLE IF EXISTS `auth_permission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `auth_permission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_type_id` int NOT NULL,
  `codename` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_permission`
--

LOCK TABLES `auth_permission` WRITE;
/*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */;
INSERT INTO `auth_permission` VALUES (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can view log entry',1,'view_logentry'),(5,'Can add permission',3,'add_permission'),(6,'Can change permission',3,'change_permission'),(7,'Can delete permission',3,'delete_permission'),(8,'Can view permission',3,'view_permission'),(9,'Can add group',2,'add_group'),(10,'Can change group',2,'change_group'),(11,'Can delete group',2,'delete_group'),(12,'Can view group',2,'view_group'),(13,'Can add user',4,'add_user'),(14,'Can change user',4,'change_user'),(15,'Can delete user',4,'delete_user'),(16,'Can view user',4,'view_user'),(17,'Can add content type',5,'add_contenttype'),(18,'Can change content type',5,'change_contenttype'),(19,'Can delete content type',5,'delete_contenttype'),(20,'Can view content type',5,'view_contenttype'),(21,'Can add session',6,'add_session'),(22,'Can change session',6,'change_session'),(23,'Can delete session',6,'delete_session'),(24,'Can view session',6,'view_session'),(25,'Can add academic year',7,'add_academicyear'),(26,'Can change academic year',7,'change_academicyear'),(27,'Can delete academic year',7,'delete_academicyear'),(28,'Can view academic year',7,'view_academicyear'),(29,'Can add item',10,'add_item'),(30,'Can change item',10,'change_item'),(31,'Can delete item',10,'delete_item'),(32,'Can view item',10,'view_item'),(33,'Can add participant',11,'add_participant'),(34,'Can change participant',11,'change_participant'),(35,'Can delete participant',11,'delete_participant'),(36,'Can view participant',11,'view_participant'),(37,'Can add school',16,'add_school'),(38,'Can change school',16,'change_school'),(39,'Can delete school',16,'delete_school'),(40,'Can view school',16,'view_school'),(41,'Can add system setting',19,'add_systemsetting'),(42,'Can change system setting',19,'change_systemsetting'),(43,'Can delete system setting',19,'delete_systemsetting'),(44,'Can view system setting',19,'view_systemsetting'),(45,'Can add group entry',8,'add_groupentry'),(46,'Can change group entry',8,'change_groupentry'),(47,'Can delete group entry',8,'delete_groupentry'),(48,'Can view group entry',8,'view_groupentry'),(49,'Can add point rule',14,'add_pointrule'),(50,'Can change point rule',14,'change_pointrule'),(51,'Can delete point rule',14,'delete_pointrule'),(52,'Can view point rule',14,'view_pointrule'),(53,'Can add result',15,'add_result'),(54,'Can change result',15,'change_result'),(55,'Can delete result',15,'delete_result'),(56,'Can view result',15,'view_result'),(57,'Can add participant point',13,'add_participantpoint'),(58,'Can change participant point',13,'change_participantpoint'),(59,'Can delete participant point',13,'delete_participantpoint'),(60,'Can view participant point',13,'view_participantpoint'),(61,'Can add school point',17,'add_schoolpoint'),(62,'Can change school point',17,'change_schoolpoint'),(63,'Can delete school point',17,'delete_schoolpoint'),(64,'Can view school point',17,'view_schoolpoint'),(65,'Can add stage mark',18,'add_stagemark'),(66,'Can change stage mark',18,'change_stagemark'),(67,'Can delete stage mark',18,'delete_stagemark'),(68,'Can view stage mark',18,'view_stagemark'),(69,'Can add group member',9,'add_groupmember'),(70,'Can change group member',9,'change_groupmember'),(71,'Can delete group member',9,'delete_groupmember'),(72,'Can view group member',9,'view_groupmember'),(73,'Can add participant item',12,'add_participantitem'),(74,'Can change participant item',12,'change_participantitem'),(75,'Can delete participant item',12,'delete_participantitem'),(76,'Can view participant item',12,'view_participantitem');
/*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `auth_user`
--

DROP TABLE IF EXISTS `auth_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `auth_user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `password` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_user`
--

LOCK TABLES `auth_user` WRITE;
/*!40000 ALTER TABLE `auth_user` DISABLE KEYS */;
INSERT INTO `auth_user` VALUES (1,'pbkdf2_sha256$1200000$c8vp5jsQwUktdwr7u2we3h$DnZSt8pHHiEN89Wy/a0OzZtVltmjA8jB893wKlNLMkw=','2026-09-16 08:35:52.465149',1,'arunbmathews','','','arunbmathews@gmail.com',1,1,'2026-09-15 17:36:30.697357'),(2,'pbkdf2_sha256$1200000$Zzvvl95shDDnXfapJqMPet$BOx1mHUxydupDDkxg6rnTYDEIku1YlqLdLT4D5syeTc=','2026-09-16 09:16:57.652318',1,'arunbmathews1','','','arunbmathews@gmail.com',1,1,'2026-09-16 05:22:47.152779'),(3,'pbkdf2_sha256$1200000$uiKrSFhlMRrOccmh95Nd7J$9n3cUCo1vb5ezJcJ2k2eT3DMf3poxkGPJXvRS9gH40Y=','2026-09-16 08:27:19.521674',0,'03045','','','',0,1,'2026-09-16 05:59:04.881950'),(4,'pbkdf2_sha256$1200000$tQKDbjj9BN14fK1q7GGRwF$sV/4h3mc7QhohJoIB2ayFDr+EsVYsndmAmnem8QCeLg=',NULL,0,'04057','','','',0,1,'2026-09-16 05:59:29.638579'),(5,'pbkdf2_sha256$1200000$hEaTYicH8b3b9qhFupFD9x$fWkVizwJklCfwzHVgOz/NWiaJ4pOKoPQ3hI4mT4zrnM=',NULL,0,'111','','','',0,1,'2026-09-16 06:00:07.593375');
/*!40000 ALTER TABLE `auth_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `auth_user_groups`
--

DROP TABLE IF EXISTS `auth_user_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `auth_user_groups` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `group_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
  KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`),
  CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_user_groups`
--

LOCK TABLES `auth_user_groups` WRITE;
/*!40000 ALTER TABLE `auth_user_groups` DISABLE KEYS */;
INSERT INTO `auth_user_groups` VALUES (1,3,1),(2,4,1),(3,5,1);
/*!40000 ALTER TABLE `auth_user_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `auth_user_user_permissions`
--

DROP TABLE IF EXISTS `auth_user_user_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `auth_user_user_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
  KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_user_user_permissions`
--

LOCK TABLES `auth_user_user_permissions` WRITE;
/*!40000 ALTER TABLE `auth_user_user_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_user_user_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `django_admin_log`
--

DROP TABLE IF EXISTS `django_admin_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `django_admin_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext COLLATE utf8mb4_unicode_ci,
  `object_repr` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_flag` smallint unsigned NOT NULL,
  `change_message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_type_id` int DEFAULT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`),
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `django_admin_log_chk_1` CHECK ((`action_flag` >= 0))
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `django_admin_log`
--

LOCK TABLES `django_admin_log` WRITE;
/*!40000 ALTER TABLE `django_admin_log` DISABLE KEYS */;
INSERT INTO `django_admin_log` VALUES (1,'2026-09-16 08:06:18.693062','1','201 - Prasangam _ UP',1,'[{\"added\": {}}]',10,1),(2,'2026-09-16 08:06:49.935358','2','202 - Prasangam _ Eng_UP',1,'[{\"added\": {}}]',10,1),(3,'2026-09-16 08:06:58.766690','1','201 - Prasangam _ Mal_UP',2,'[{\"changed\": {\"fields\": [\"Name\"]}}]',10,1),(4,'2026-09-16 08:07:16.280872','1','201 - Prasangam _ Mal_UP',2,'[]',10,1),(5,'2026-09-16 08:07:37.562047','3','203 - Prasangam _ Hin_UP',1,'[{\"added\": {}}]',10,1),(6,'2026-09-16 08:08:00.137541','4','204 - Prasangam _ Tamil_UP',1,'[{\"added\": {}}]',10,1),(7,'2026-09-16 08:09:23.790651','5','205 - Prasangam _ Kannada_UP',1,'[{\"added\": {}}]',10,1),(8,'2026-09-16 08:10:00.241005','6','206 - Padyam Chollal _Mal_UP',1,'[{\"added\": {}}]',10,1),(9,'2026-09-16 08:10:21.687626','7','207 - Padyam Chollal _Eng_UP',1,'[{\"added\": {}}]',10,1),(10,'2026-09-16 08:13:04.911956','8','208 - Padyam Chollal _Arab_UP',1,'[{\"added\": {}}]',10,1),(11,'2026-09-16 08:13:24.746201','9','209 - Padyam Chollal _Urdu_UP',1,'[{\"added\": {}}]',10,1),(12,'2026-09-16 08:13:54.642637','10','210 - Padyam Chollal _Hindi_UP',1,'[{\"added\": {}}]',10,1),(13,'2026-09-16 08:14:11.450880','11','211 - Padyam Chollal _Tamil_UP',1,'[{\"added\": {}}]',10,1),(14,'2026-09-16 08:14:35.341957','12','212 - Padyam Chollal _Kannada_UP',1,'[{\"added\": {}}]',10,1),(15,'2026-09-16 08:36:28.519237','13','213 - Quiz(Urdu)_UP',1,'[{\"added\": {}}]',10,1),(16,'2026-09-16 08:37:23.357515','14','214 - AKSHARA_SHLOKAN_UP',1,'[{\"added\": {}}]',10,1),(17,'2026-09-16 08:37:53.469298','15','215 - LALITHA GANAM_UP',1,'[{\"added\": {}}]',10,1),(18,'2026-09-16 08:38:19.037596','16','216 - SHASTREEYA SANGEETHAM_UP',1,'[{\"added\": {}}]',10,1),(19,'2026-09-16 08:38:45.950977','17','217 - MAPPILAPPATTU_UP',1,'[{\"added\": {}}]',10,1),(20,'2026-09-16 08:39:09.398532','18','218 - NADODI NRITHAM_UP',1,'[{\"added\": {}}]',10,1),(21,'2026-09-16 08:43:10.907336','19','219 - Chithra Rachana - Pencil',1,'[{\"added\": {}}]',10,1),(22,'2026-09-16 08:43:38.437697','20','315 - Chithra Rachana - Jalachayam',1,'[{\"added\": {}}]',10,1),(23,'2026-09-16 08:43:55.768860','21','316 - Bharathanatyam',1,'[{\"added\": {}}]',10,1),(24,'2026-09-16 08:44:11.997203','22','317 - Mohiniyattam',1,'[{\"added\": {}}]',10,1),(25,'2026-09-16 08:44:47.408766','23','318 - Kuchuppudi',1,'[{\"added\": {}}]',10,1),(26,'2026-09-16 08:45:06.175936','24','319 - Mono Act',1,'[{\"added\": {}}]',10,1),(27,'2026-09-16 08:45:25.477644','25','320 - Kathaprasangam',1,'[{\"added\": {}}]',10,1),(28,'2026-09-16 08:45:48.389342','26','321 - Ottanthullal',1,'[{\"added\": {}}]',10,1),(29,'2026-09-16 08:46:04.589681','27','322 - Katharachana - Malayalam',1,'[{\"added\": {}}]',10,1),(30,'2026-09-16 08:46:24.714049','28','323 - Kavitharachana - Malayalam',1,'[{\"added\": {}}]',10,1),(31,'2026-09-16 08:46:43.603085','29','324 - Katharachana - Hindi',1,'[{\"added\": {}}]',10,1),(32,'2026-09-16 08:47:03.868028','30','331 - Urdu kavitha Rachana',1,'[{\"added\": {}}]',10,1),(33,'2026-09-16 08:52:56.221535','31','332 - Urdu Quiz',1,'[{\"added\": {}}]',10,1),(34,'2026-09-16 08:53:55.734954','1','301 - Prasangam _ Mal_UP',2,'[{\"changed\": {\"fields\": [\"Code\"]}}]',10,1),(35,'2026-09-16 08:54:16.592749','2','302 - Prasangam _ Eng_UP',2,'[{\"changed\": {\"fields\": [\"Code\"]}}]',10,1),(36,'2026-09-16 08:54:30.403129','3','303 - Prasangam _ Hin_UP',2,'[{\"changed\": {\"fields\": [\"Code\"]}}]',10,1),(37,'2026-09-16 08:55:50.988776','6','304 - Padyam Chollal _Mal_UP',2,'[{\"changed\": {\"fields\": [\"Code\"]}}]',10,1),(38,'2026-09-16 08:56:03.533046','5','205 - Prasangam _ Kannada_UP',3,'',10,1),(39,'2026-09-16 08:56:03.533079','4','204 - Prasangam _ Tamil_UP',3,'',10,1),(40,'2026-09-16 08:56:21.716547','7','305 - Padyam Chollal _Eng_UP',2,'[{\"changed\": {\"fields\": [\"Code\"]}}]',10,1),(41,'2026-09-16 08:56:37.703398','8','306 - Padyam Chollal _Arab_UP',2,'[{\"changed\": {\"fields\": [\"Code\"]}}]',10,1),(42,'2026-09-16 08:57:20.137459','9','307 - Padyam Chollal _Urdu_UP',2,'[{\"changed\": {\"fields\": [\"Code\"]}}]',10,1),(43,'2026-09-16 08:57:48.225239','10','308 - Padyam Chollal _Hindi_UP',2,'[{\"changed\": {\"fields\": [\"Code\"]}}]',10,1),(44,'2026-09-16 08:58:13.340762','13','213 - Quiz(Urdu)_UP',3,'',10,1),(45,'2026-09-16 08:58:13.340803','12','212 - Padyam Chollal _Kannada_UP',3,'',10,1),(46,'2026-09-16 08:58:13.340822','11','211 - Padyam Chollal _Tamil_UP',3,'',10,1),(47,'2026-09-16 08:58:31.376621','14','309 - AKSHARA_SHLOKAN_UP',2,'[{\"changed\": {\"fields\": [\"Code\"]}}]',10,1),(48,'2026-09-16 08:58:46.381526','15','310 - LALITHA GANAM_UP',2,'[{\"changed\": {\"fields\": [\"Code\"]}}]',10,1),(49,'2026-09-16 09:00:25.833406','16','311 - SHASTREEYA SANGEETHAM_UP',2,'[{\"changed\": {\"fields\": [\"Code\"]}}]',10,1),(50,'2026-09-16 09:00:42.475763','17','312 - MAPPILAPPATTU_UP',2,'[{\"changed\": {\"fields\": [\"Code\"]}}]',10,1),(51,'2026-09-16 09:00:55.868224','18','313 - NADODI NRITHAM_UP',2,'[{\"changed\": {\"fields\": [\"Code\"]}}]',10,1),(52,'2026-09-16 09:01:11.531091','19','314 - Chithra Rachana - Pencil',2,'[{\"changed\": {\"fields\": [\"Code\"]}}]',10,1),(53,'2026-09-16 09:02:14.676121','32','334 - Prasangam - Tamil',1,'[{\"added\": {}}]',10,1),(54,'2026-09-16 09:02:33.578910','33','335 - Prasangam - Kannada',1,'[{\"added\": {}}]',10,1),(55,'2026-09-16 09:02:57.919482','34','336 - Padyamchollal - Tamil',1,'[{\"added\": {}}]',10,1),(56,'2026-09-16 09:03:16.190245','35','337 - Padyamchollal - Kannada',1,'[{\"added\": {}}]',10,1);
/*!40000 ALTER TABLE `django_admin_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `django_content_type`
--

DROP TABLE IF EXISTS `django_content_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `django_content_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `django_content_type`
--

LOCK TABLES `django_content_type` WRITE;
/*!40000 ALTER TABLE `django_content_type` DISABLE KEYS */;
INSERT INTO `django_content_type` VALUES (1,'admin','logentry'),(2,'auth','group'),(3,'auth','permission'),(4,'auth','user'),(5,'contenttypes','contenttype'),(7,'kaotsavam','academicyear'),(8,'kaotsavam','groupentry'),(9,'kaotsavam','groupmember'),(10,'kaotsavam','item'),(11,'kaotsavam','participant'),(12,'kaotsavam','participantitem'),(13,'kaotsavam','participantpoint'),(14,'kaotsavam','pointrule'),(15,'kaotsavam','result'),(16,'kaotsavam','school'),(17,'kaotsavam','schoolpoint'),(18,'kaotsavam','stagemark'),(19,'kaotsavam','systemsetting'),(6,'sessions','session');
/*!40000 ALTER TABLE `django_content_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `django_migrations`
--

DROP TABLE IF EXISTS `django_migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `django_migrations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `app` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `django_migrations`
--

LOCK TABLES `django_migrations` WRITE;
/*!40000 ALTER TABLE `django_migrations` DISABLE KEYS */;
INSERT INTO `django_migrations` VALUES (1,'contenttypes','0001_initial','2026-09-15 17:35:25.282010'),(2,'auth','0001_initial','2026-09-15 17:35:25.824689'),(3,'admin','0001_initial','2026-09-15 17:35:25.964691'),(4,'admin','0002_logentry_remove_auto_add','2026-09-15 17:35:25.973688'),(5,'admin','0003_logentry_add_action_flag_choices','2026-09-15 17:35:25.988953'),(6,'contenttypes','0002_remove_content_type_name','2026-09-15 17:35:26.107643'),(7,'auth','0002_alter_permission_name_max_length','2026-09-15 17:35:26.173050'),(8,'auth','0003_alter_user_email_max_length','2026-09-15 17:35:26.197982'),(9,'auth','0004_alter_user_username_opts','2026-09-15 17:35:26.209677'),(10,'auth','0005_alter_user_last_login_null','2026-09-15 17:35:26.274444'),(11,'auth','0006_require_contenttypes_0002','2026-09-15 17:35:26.277128'),(12,'auth','0007_alter_validators_add_error_messages','2026-09-15 17:35:26.286103'),(13,'auth','0008_alter_user_username_max_length','2026-09-15 17:35:26.379817'),(14,'auth','0009_alter_user_last_name_max_length','2026-09-15 17:35:26.446094'),(15,'auth','0010_alter_group_name_max_length','2026-09-15 17:35:26.463913'),(16,'auth','0011_update_proxy_permissions','2026-09-15 17:35:26.476890'),(17,'auth','0012_alter_user_first_name_max_length','2026-09-15 17:35:26.556032'),(18,'kaotsavam','0001_initial','2026-09-15 17:35:28.145353'),(19,'sessions','0001_initial','2026-09-15 17:35:28.198163');
/*!40000 ALTER TABLE `django_migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `django_session`
--

DROP TABLE IF EXISTS `django_session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `django_session` (
  `session_key` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `session_data` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`session_key`),
  KEY `django_session_expire_date_a5c62663` (`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `django_session`
--

LOCK TABLES `django_session` WRITE;
/*!40000 ALTER TABLE `django_session` DISABLE KEYS */;
INSERT INTO `django_session` VALUES ('smcxoltoj2ivj69mce4s4ngibh39orte','.eJxVjMsOgjAQAP9lz6Zplz4oR-9-A9nuFouaklA4Gf_dkHDQ68xk3jDSvpVxb3kdZ4EBEC6_LBE_cz2EPKjeF8VL3dY5qSNRp23qtkh-Xc_2b1CoFRjAOh80J9tz9E532CGh7oMYw9Zki5MJ1oiNwjrqQNgldhOJ81OKxhPC5wuvbjb9:1x6llB:GJ-Vzs2r8ucHFqhKqdejVwbk-9GQaCYKDW8YS9yLBFs','2026-09-30 09:16:57.657433');
/*!40000 ALTER TABLE `django_session` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaotsavam_academicyear`
--

DROP TABLE IF EXISTS `kaotsavam_academicyear`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kaotsavam_academicyear` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaotsavam_academicyear`
--

LOCK TABLES `kaotsavam_academicyear` WRITE;
/*!40000 ALTER TABLE `kaotsavam_academicyear` DISABLE KEYS */;
INSERT INTO `kaotsavam_academicyear` VALUES (1,'2024-25',1);
/*!40000 ALTER TABLE `kaotsavam_academicyear` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaotsavam_groupentry`
--

DROP TABLE IF EXISTS `kaotsavam_groupentry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kaotsavam_groupentry` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `confirmed` tinyint(1) NOT NULL,
  `item_id` bigint NOT NULL,
  `captain_id` bigint NOT NULL,
  `school_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `one_group_entry_per_school_item` (`school_id`,`item_id`),
  KEY `kaotsavam_groupentry_item_id_448cc7bf_fk_kaotsavam_item_id` (`item_id`),
  KEY `kaotsavam_groupentry_captain_id_4c32ac09_fk_kaotsavam` (`captain_id`),
  CONSTRAINT `kaotsavam_groupentry_captain_id_4c32ac09_fk_kaotsavam` FOREIGN KEY (`captain_id`) REFERENCES `kaotsavam_participant` (`id`),
  CONSTRAINT `kaotsavam_groupentry_item_id_448cc7bf_fk_kaotsavam_item_id` FOREIGN KEY (`item_id`) REFERENCES `kaotsavam_item` (`id`),
  CONSTRAINT `kaotsavam_groupentry_school_id_9d692b0a_fk_kaotsavam_school_id` FOREIGN KEY (`school_id`) REFERENCES `kaotsavam_school` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaotsavam_groupentry`
--

LOCK TABLES `kaotsavam_groupentry` WRITE;
/*!40000 ALTER TABLE `kaotsavam_groupentry` DISABLE KEYS */;
/*!40000 ALTER TABLE `kaotsavam_groupentry` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaotsavam_groupmember`
--

DROP TABLE IF EXISTS `kaotsavam_groupmember`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kaotsavam_groupmember` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `entry_id` bigint NOT NULL,
  `participant_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_group_member` (`entry_id`,`participant_id`),
  KEY `kaotsavam_groupmembe_participant_id_cd04c9af_fk_kaotsavam` (`participant_id`),
  CONSTRAINT `kaotsavam_groupmembe_entry_id_85627d68_fk_kaotsavam` FOREIGN KEY (`entry_id`) REFERENCES `kaotsavam_groupentry` (`id`),
  CONSTRAINT `kaotsavam_groupmembe_participant_id_cd04c9af_fk_kaotsavam` FOREIGN KEY (`participant_id`) REFERENCES `kaotsavam_participant` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaotsavam_groupmember`
--

LOCK TABLES `kaotsavam_groupmember` WRITE;
/*!40000 ALTER TABLE `kaotsavam_groupmember` DISABLE KEYS */;
/*!40000 ALTER TABLE `kaotsavam_groupmember` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaotsavam_item`
--

DROP TABLE IF EXISTS `kaotsavam_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kaotsavam_item` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `code` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `section` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sex` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `participation_type` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `min_participants` int unsigned NOT NULL,
  `max_participants` int unsigned NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`),
  CONSTRAINT `kaotsavam_item_chk_1` CHECK ((`min_participants` >= 0)),
  CONSTRAINT `kaotsavam_item_chk_2` CHECK ((`max_participants` >= 0))
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaotsavam_item`
--

LOCK TABLES `kaotsavam_item` WRITE;
/*!40000 ALTER TABLE `kaotsavam_item` DISABLE KEYS */;
INSERT INTO `kaotsavam_item` VALUES (1,'301','Prasangam _ Mal_UP','UP','X','I',1,1,1),(2,'302','Prasangam _ Eng_UP','UP','X','I',1,1,1),(3,'303','Prasangam _ Hin_UP','UP','X','I',1,1,1),(6,'304','Padyam Chollal _Mal_UP','UP','X','I',1,1,1),(7,'305','Padyam Chollal _Eng_UP','UP','X','I',1,1,1),(8,'306','Padyam Chollal _Arab_UP','UP','X','I',1,1,1),(9,'307','Padyam Chollal _Urdu_UP','UP','X','I',1,1,1),(10,'308','Padyam Chollal _Hindi_UP','UP','X','I',1,1,1),(14,'309','AKSHARA_SHLOKAN_UP','UP','X','I',1,1,1),(15,'310','LALITHA GANAM_UP','UP','X','I',1,1,1),(16,'311','SHASTREEYA SANGEETHAM_UP','UP','X','I',1,1,1),(17,'312','MAPPILAPPATTU_UP','UP','X','I',1,1,1),(18,'313','NADODI NRITHAM_UP','UP','X','I',1,1,1),(19,'314','Chithra Rachana - Pencil','UP','X','I',1,1,1),(20,'315','Chithra Rachana - Jalachayam','UP','X','I',1,1,1),(21,'316','Bharathanatyam','UP','X','I',1,1,1),(22,'317','Mohiniyattam','UP','X','I',1,1,1),(23,'318','Kuchuppudi','UP','X','I',1,1,1),(24,'319','Mono Act','UP','X','I',1,1,1),(25,'320','Kathaprasangam','UP','X','I',1,1,1),(26,'321','Ottanthullal','UP','X','I',1,1,1),(27,'322','Katharachana - Malayalam','UP','X','I',1,1,1),(28,'323','Kavitharachana - Malayalam','UP','X','I',1,1,1),(29,'324','Katharachana - Hindi','UP','X','I',1,1,1),(30,'331','Urdu kavitha Rachana','UP','X','I',1,1,1),(31,'332','Urdu Quiz','UP','X','I',1,1,1),(32,'334','Prasangam - Tamil','UP','X','I',1,1,1),(33,'335','Prasangam - Kannada','UP','X','I',1,1,1),(34,'336','Padyamchollal - Tamil','UP','X','I',1,1,1),(35,'337','Padyamchollal - Kannada','UP','X','I',1,1,1);
/*!40000 ALTER TABLE `kaotsavam_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaotsavam_participant`
--

DROP TABLE IF EXISTS `kaotsavam_participant`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kaotsavam_participant` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `admission_no` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sex` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `age` int unsigned NOT NULL,
  `section` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `chest_no` int unsigned DEFAULT NULL,
  `school_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_school_admission` (`school_id`,`admission_no`),
  CONSTRAINT `kaotsavam_participant_school_id_40dce9fe_fk_kaotsavam_school_id` FOREIGN KEY (`school_id`) REFERENCES `kaotsavam_school` (`id`),
  CONSTRAINT `kaotsavam_participant_chk_1` CHECK ((`age` >= 0)),
  CONSTRAINT `kaotsavam_participant_chk_2` CHECK ((`chest_no` >= 0))
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaotsavam_participant`
--

LOCK TABLES `kaotsavam_participant` WRITE;
/*!40000 ALTER TABLE `kaotsavam_participant` DISABLE KEYS */;
INSERT INTO `kaotsavam_participant` VALUES (1,'121','Jijo Y','M',12,'UP','7',NULL,2),(2,'44','Ancy D','F',12,'UP','7B',NULL,2),(3,'55','Jijo P','M',15,'HS','10c',NULL,2),(4,'545','Vaishakh K','M',14,'HS','9',NULL,2);
/*!40000 ALTER TABLE `kaotsavam_participant` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaotsavam_participantitem`
--

DROP TABLE IF EXISTS `kaotsavam_participantitem`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kaotsavam_participantitem` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `item_id` bigint NOT NULL,
  `participant_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_participant_item` (`participant_id`,`item_id`),
  KEY `kaotsavam_participantitem_item_id_e089b74a_fk_kaotsavam_item_id` (`item_id`),
  CONSTRAINT `kaotsavam_participan_participant_id_3ce078ea_fk_kaotsavam` FOREIGN KEY (`participant_id`) REFERENCES `kaotsavam_participant` (`id`),
  CONSTRAINT `kaotsavam_participantitem_item_id_e089b74a_fk_kaotsavam_item_id` FOREIGN KEY (`item_id`) REFERENCES `kaotsavam_item` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaotsavam_participantitem`
--

LOCK TABLES `kaotsavam_participantitem` WRITE;
/*!40000 ALTER TABLE `kaotsavam_participantitem` DISABLE KEYS */;
INSERT INTO `kaotsavam_participantitem` VALUES (5,7,1),(6,8,1),(1,1,2),(2,2,2),(3,3,2);
/*!40000 ALTER TABLE `kaotsavam_participantitem` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaotsavam_participantpoint`
--

DROP TABLE IF EXISTS `kaotsavam_participantpoint`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kaotsavam_participantpoint` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `points` int unsigned NOT NULL,
  `participant_id` bigint NOT NULL,
  `result_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `kaotsavam_participan_participant_id_96958b4b_fk_kaotsavam` (`participant_id`),
  KEY `kaotsavam_participan_result_id_e8e85902_fk_kaotsavam` (`result_id`),
  CONSTRAINT `kaotsavam_participan_participant_id_96958b4b_fk_kaotsavam` FOREIGN KEY (`participant_id`) REFERENCES `kaotsavam_participant` (`id`),
  CONSTRAINT `kaotsavam_participan_result_id_e8e85902_fk_kaotsavam` FOREIGN KEY (`result_id`) REFERENCES `kaotsavam_result` (`id`),
  CONSTRAINT `kaotsavam_participantpoint_chk_1` CHECK ((`points` >= 0))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaotsavam_participantpoint`
--

LOCK TABLES `kaotsavam_participantpoint` WRITE;
/*!40000 ALTER TABLE `kaotsavam_participantpoint` DISABLE KEYS */;
/*!40000 ALTER TABLE `kaotsavam_participantpoint` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaotsavam_pointrule`
--

DROP TABLE IF EXISTS `kaotsavam_pointrule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kaotsavam_pointrule` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `first` int unsigned NOT NULL,
  `second` int unsigned NOT NULL,
  `third` int unsigned NOT NULL,
  `item_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `item_id` (`item_id`),
  CONSTRAINT `kaotsavam_pointrule_item_id_70a346c0_fk_kaotsavam_item_id` FOREIGN KEY (`item_id`) REFERENCES `kaotsavam_item` (`id`),
  CONSTRAINT `kaotsavam_pointrule_chk_1` CHECK ((`first` >= 0)),
  CONSTRAINT `kaotsavam_pointrule_chk_2` CHECK ((`second` >= 0)),
  CONSTRAINT `kaotsavam_pointrule_chk_3` CHECK ((`third` >= 0))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaotsavam_pointrule`
--

LOCK TABLES `kaotsavam_pointrule` WRITE;
/*!40000 ALTER TABLE `kaotsavam_pointrule` DISABLE KEYS */;
/*!40000 ALTER TABLE `kaotsavam_pointrule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaotsavam_result`
--

DROP TABLE IF EXISTS `kaotsavam_result`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kaotsavam_result` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `mark1` decimal(8,2) NOT NULL,
  `mark2` decimal(8,2) NOT NULL,
  `mark3` decimal(8,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `position` int unsigned DEFAULT NULL,
  `place` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `confirmed` tinyint(1) NOT NULL,
  `published` tinyint(1) NOT NULL,
  `group_entry_id` bigint DEFAULT NULL,
  `item_id` bigint NOT NULL,
  `participant_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `kaotsavam_result_group_entry_id_00837a8c_fk_kaotsavam` (`group_entry_id`),
  KEY `kaotsavam_result_item_id_a3d0ea67_fk_kaotsavam_item_id` (`item_id`),
  KEY `kaotsavam_result_participant_id_6d4cb322_fk_kaotsavam` (`participant_id`),
  CONSTRAINT `kaotsavam_result_group_entry_id_00837a8c_fk_kaotsavam` FOREIGN KEY (`group_entry_id`) REFERENCES `kaotsavam_groupentry` (`id`),
  CONSTRAINT `kaotsavam_result_item_id_a3d0ea67_fk_kaotsavam_item_id` FOREIGN KEY (`item_id`) REFERENCES `kaotsavam_item` (`id`),
  CONSTRAINT `kaotsavam_result_participant_id_6d4cb322_fk_kaotsavam` FOREIGN KEY (`participant_id`) REFERENCES `kaotsavam_participant` (`id`),
  CONSTRAINT `kaotsavam_result_chk_1` CHECK ((`position` >= 0))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaotsavam_result`
--

LOCK TABLES `kaotsavam_result` WRITE;
/*!40000 ALTER TABLE `kaotsavam_result` DISABLE KEYS */;
/*!40000 ALTER TABLE `kaotsavam_result` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaotsavam_school`
--

DROP TABLE IF EXISTS `kaotsavam_school`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kaotsavam_school` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `school_type` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
  `principal_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hm_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `escort1_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `escort1_mobile` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `escort2_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `escort2_mobile` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `confirmed` tinyint(1) NOT NULL,
  `confirmed_at` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaotsavam_school`
--

LOCK TABLES `kaotsavam_school` WRITE;
/*!40000 ALTER TABLE `kaotsavam_school` DISABLE KEYS */;
INSERT INTO `kaotsavam_school` VALUES (1,'MTHSS Venmony','04057','HSS','MTHSS Venmony','','','Sheeba Oommen','Saji Alex','Dr Arun B Mathew','','','',0,NULL),(2,'MTHSS Pathanamthitta','03045','HSS','MTHSS Pathanamthitta','','','','','','','','',0,NULL),(3,'MTHSS Valakom','111','HS','MTHSS Valakom','','','','','','','','',0,NULL),(4,'MTHSS Channapetta','112','HS','MTHSS Channapetta','','','','','','','','',0,NULL);
/*!40000 ALTER TABLE `kaotsavam_school` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaotsavam_schoolpoint`
--

DROP TABLE IF EXISTS `kaotsavam_schoolpoint`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kaotsavam_schoolpoint` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `points` int unsigned NOT NULL,
  `result_id` bigint NOT NULL,
  `school_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `kaotsavam_schoolpoint_result_id_1e772ee8_fk_kaotsavam_result_id` (`result_id`),
  KEY `kaotsavam_schoolpoint_school_id_b7ff0737_fk_kaotsavam_school_id` (`school_id`),
  CONSTRAINT `kaotsavam_schoolpoint_result_id_1e772ee8_fk_kaotsavam_result_id` FOREIGN KEY (`result_id`) REFERENCES `kaotsavam_result` (`id`),
  CONSTRAINT `kaotsavam_schoolpoint_school_id_b7ff0737_fk_kaotsavam_school_id` FOREIGN KEY (`school_id`) REFERENCES `kaotsavam_school` (`id`),
  CONSTRAINT `kaotsavam_schoolpoint_chk_1` CHECK ((`points` >= 0))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaotsavam_schoolpoint`
--

LOCK TABLES `kaotsavam_schoolpoint` WRITE;
/*!40000 ALTER TABLE `kaotsavam_schoolpoint` DISABLE KEYS */;
/*!40000 ALTER TABLE `kaotsavam_schoolpoint` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaotsavam_stagemark`
--

DROP TABLE IF EXISTS `kaotsavam_stagemark`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kaotsavam_stagemark` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `judge1` decimal(8,2) NOT NULL,
  `judge2` decimal(8,2) NOT NULL,
  `judge3` decimal(8,2) NOT NULL,
  `total` decimal(8,2) NOT NULL,
  `place` int unsigned DEFAULT NULL,
  `remark` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  `group_entry_id` bigint DEFAULT NULL,
  `item_id` bigint NOT NULL,
  `participant_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `kaotsavam_stagemark_group_entry_id_bc72c593_fk_kaotsavam` (`group_entry_id`),
  KEY `kaotsavam_stagemark_item_id_421d9334_fk_kaotsavam_item_id` (`item_id`),
  KEY `kaotsavam_stagemark_participant_id_1310adb8_fk_kaotsavam` (`participant_id`),
  CONSTRAINT `kaotsavam_stagemark_group_entry_id_bc72c593_fk_kaotsavam` FOREIGN KEY (`group_entry_id`) REFERENCES `kaotsavam_groupentry` (`id`),
  CONSTRAINT `kaotsavam_stagemark_item_id_421d9334_fk_kaotsavam_item_id` FOREIGN KEY (`item_id`) REFERENCES `kaotsavam_item` (`id`),
  CONSTRAINT `kaotsavam_stagemark_participant_id_1310adb8_fk_kaotsavam` FOREIGN KEY (`participant_id`) REFERENCES `kaotsavam_participant` (`id`),
  CONSTRAINT `kaotsavam_stagemark_chk_1` CHECK ((`place` >= 0))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaotsavam_stagemark`
--

LOCK TABLES `kaotsavam_stagemark` WRITE;
/*!40000 ALTER TABLE `kaotsavam_stagemark` DISABLE KEYS */;
/*!40000 ALTER TABLE `kaotsavam_stagemark` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaotsavam_systemsetting`
--

DROP TABLE IF EXISTS `kaotsavam_systemsetting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kaotsavam_systemsetting` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `key` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaotsavam_systemsetting`
--

LOCK TABLES `kaotsavam_systemsetting` WRITE;
/*!40000 ALTER TABLE `kaotsavam_systemsetting` DISABLE KEYS */;
INSERT INTO `kaotsavam_systemsetting` VALUES (1,'individual_per_student','3'),(2,'group_per_student','5');
/*!40000 ALTER TABLE `kaotsavam_systemsetting` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'marthoma_kalolsavam'
--

--
-- Dumping routines for database 'marthoma_kalolsavam'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-09-16 14:55:16