-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 01, 2026 at 05:46 AM
-- Server version: 8.0.30
-- PHP Version: 8.1.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `rtl_new`
--

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

--
-- Table structure for table `activation_codes`
--

CREATE TABLE `activation_codes` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `used` tinyint(1) NOT NULL DEFAULT '0',
  `expire` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `address_models`
--

CREATE TABLE `address_models` (
  `id` bigint UNSIGNED NOT NULL,
  `home_id` int UNSIGNED NOT NULL,
  `gmail` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `yahoo` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ins` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tel` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `answers`
--

CREATE TABLE `answers` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `archives`
--

CREATE TABLE `archives` (
  `id` bigint NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `model` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `item_id` bigint NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `barnamehs`
--

CREATE TABLE `barnamehs` (
  `id` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `classnumber` bigint UNSIGNED NOT NULL,
  `filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `block_class_users`
--

CREATE TABLE `block_class_users` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `online_class_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `original_filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `like` int NOT NULL DEFAULT '0',
  `view` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `challenges`
--

CREATE TABLE `challenges` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `role` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `clas`
--

CREATE TABLE `clas` (
  `id` bigint UNSIGNED NOT NULL,
  `magta` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `reshte` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `paye` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `classnamber` bigint UNSIGNED NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clas`
--

INSERT INTO `clas` (`id`, `magta`, `reshte`, `paye`, `classnamber`, `description`, `created_at`, `updated_at`) VALUES
(1, 'ابتدایی', 'بدون رشته', 'دهم', 1, NULL, '2026-05-30', '2026-05-30'),
(3, 'ابتدایی', 'بدون رشته', 'دهم', 1, NULL, '2026-05-30', '2026-05-30'),
(4, 'ابتدایی', 'بدون رشته', 'دهم', 2, NULL, '2026-05-30', '2026-05-30'),
(5, '', '', 'یازدهم', 112, NULL, '1405-03-09', '1405-03-09');

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `matlab_id` int UNSIGNED NOT NULL,
  `status` int UNSIGNED NOT NULL DEFAULT '0',
  `body` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `comment_moshavers`
--

CREATE TABLE `comment_moshavers` (
  `id` bigint NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `moshavers_id` bigint UNSIGNED NOT NULL,
  `comment` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci,
  `commentme` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci,
  `created_at` date NOT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `c_disciplines`
--

CREATE TABLE `c_disciplines` (
  `id` bigint UNSIGNED NOT NULL,
  `mark` decimal(8,2) UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `c_karnamehs`
--

CREATE TABLE `c_karnamehs` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_karnameh` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `dars_id` bigint UNSIGNED NOT NULL,
  `item_id` bigint UNSIGNED NOT NULL,
  `percent` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `c_marks`
--

CREATE TABLE `c_marks` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `classid` bigint UNSIGNED NOT NULL,
  `dars` bigint UNSIGNED NOT NULL,
  `namedars` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payeclass` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `max` int NOT NULL DEFAULT '20',
  `exam_id` bigint DEFAULT NULL,
  `tamrin_id` bigint DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `c_marks`
--

INSERT INTO `c_marks` (`id`, `name`, `user_id`, `classid`, `dars`, `namedars`, `payeclass`, `max`, `exam_id`, `tamrin_id`, `created_at`, `updated_at`) VALUES
(1, '1', 324358, 1, 3, '1', 'دهم', 20, NULL, NULL, '1405-03-09', '1405-03-09');

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

--
-- Table structure for table `c_tags`
--

CREATE TABLE `c_tags` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `place` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `daftars`
--

CREATE TABLE `daftars` (
  `id` int NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `teacher_id` int UNSIGNED NOT NULL,
  `dars_id` int UNSIGNED NOT NULL,
  `class_id` int UNSIGNED NOT NULL,
  `date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `porsesh` int DEFAULT NULL,
  `mosharecat` int DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daftars`
--

INSERT INTO `daftars` (`id`, `user_id`, `teacher_id`, `dars_id`, `class_id`, `date`, `porsesh`, `mosharecat`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 327362, 324358, 4, 2, '1405/03/05', 2, NULL, '2026-05-30 19:23:06', '2026-05-30 19:23:06', '0000-00-00 00:00:00');

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

--
-- Table structure for table `dars`
--

CREATE TABLE `dars` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `reshte` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `paye` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `vahed` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `file` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort` int NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dars`
--

INSERT INTO `dars` (`id`, `name`, `reshte`, `paye`, `vahed`, `created_at`, `updated_at`, `file`, `sort`) VALUES
(3, '1', 'بدون رشته', 'دهم', 1, '2026-05-30 14:57:52', '2026-05-30 14:57:52', NULL, 1),
(4, '2', 'بدون رشته', 'دهم', 1, '2026-05-30 14:58:01', '2026-05-30 14:58:01', NULL, 1),
(5, '3', 'بدون رشته', 'یازدهم', 1, '2026-05-30 14:58:10', '2026-05-30 14:58:10', NULL, 1);

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

--
-- Table structure for table `days`
--

CREATE TABLE `days` (
  `id` bigint NOT NULL,
  `name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `updated_at` date NOT NULL,
  `created_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `days`
--

INSERT INTO `days` (`id`, `name`, `updated_at`, `created_at`) VALUES
(1, 'شنبه', '0000-00-00', '0000-00-00'),
(2, 'یکشنبه', '0000-00-00', '0000-00-00'),
(3, 'دوشنبه', '0000-00-00', '0000-00-00'),
(4, 'سه شنبه', '0000-00-00', '0000-00-00'),
(5, 'چهارشنبه', '0000-00-00', '0000-00-00'),
(6, 'پنجشنبه', '0000-00-00', '0000-00-00'),
(7, 'جمعه', '2021-10-01', '2021-10-01');

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

--
-- Table structure for table `disciplines`
--

CREATE TABLE `disciplines` (
  `id` int UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `disciplines_id` bigint UNSIGNED NOT NULL,
  `mark` decimal(8,2) UNSIGNED NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `class` int DEFAULT NULL,
  `paye` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `date` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `dumps`
--

CREATE TABLE `dumps` (
  `id` int UNSIGNED NOT NULL,
  `file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `prefix` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `encrypted` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `exam_answerss`
--

CREATE TABLE `exam_answerss` (
  `id` bigint UNSIGNED NOT NULL,
  `question_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `option_id` bigint UNSIGNED DEFAULT NULL,
  `correct` bigint UNSIGNED DEFAULT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `deleted_at` date NOT NULL,
  `filename` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `mime` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `original_filename` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci,
  `mark` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `exam_classes`
--

CREATE TABLE `exam_classes` (
  `id` bigint UNSIGNED NOT NULL,
  `exam_id` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `dars_id` bigint UNSIGNED NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date DEFAULT NULL,
  `sort` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `exam_classes`
--

INSERT INTO `exam_classes` (`id`, `exam_id`, `class_id`, `dars_id`, `created_at`, `updated_at`, `sort`) VALUES
(1, 1, 1, 3, '2026-05-31', '2026-05-31', NULL);

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

--
-- Table structure for table `exam_histories`
--

CREATE TABLE `exam_histories` (
  `id` bigint UNSIGNED NOT NULL,
  `exam_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `start_at` varchar(50) NOT NULL,
  `finish_at` varchar(50) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `exam_marks`
--

CREATE TABLE `exam_marks` (
  `id` bigint UNSIGNED NOT NULL,
  `exam_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `mark` decimal(10,2) NOT NULL,
  `dars_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'کل',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `exam_questions`
--

CREATE TABLE `exam_questions` (
  `id` bigint UNSIGNED NOT NULL,
  `exam_id` bigint UNSIGNED NOT NULL,
  `dars_id` int DEFAULT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `original_filename` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `mime` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci,
  `mark` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `sort` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `exam_questions`
--

INSERT INTO `exam_questions` (`id`, `exam_id`, `dars_id`, `title`, `image`, `file`, `original_filename`, `mime`, `description`, `mark`, `created_at`, `updated_at`, `deleted_at`, `sort`) VALUES
(1, 1, NULL, 'سوال شماره 1', NULL, NULL, NULL, NULL, NULL, '0', '2026-05-31 06:20:46', '2026-05-31 06:20:46', NULL, NULL);

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

--
-- Table structure for table `exam_randoms`
--

CREATE TABLE `exam_randoms` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `exam_id` int NOT NULL,
  `question` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `farhang_tuition_configs`
--

CREATE TABLE `farhang_tuition_configs` (
  `id` bigint UNSIGNED NOT NULL,
  `price` bigint NOT NULL,
  `prepayment` bigint NOT NULL,
  `installments_count` bigint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `farhang_tuition_configs`
--

INSERT INTO `farhang_tuition_configs` (`id`, `price`, `prepayment`, `installments_count`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 330000000, 100000000, 6, NULL, '2024-09-21 11:00:58', NULL);

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

--
-- Table structure for table `farhang_tuition_installments`
--

CREATE TABLE `farhang_tuition_installments` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `installments_types_id` bigint UNSIGNED NOT NULL,
  `price` bigint DEFAULT NULL,
  `discount` bigint NOT NULL DEFAULT '0',
  `final_price` bigint DEFAULT NULL,
  `paid` bigint NOT NULL DEFAULT '0',
  `remaining` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `sms` tinyint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `farhang_tuition_installments_types`
--

CREATE TABLE `farhang_tuition_installments_types` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dead_line` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `farhang_tuition_payments`
--

CREATE TABLE `farhang_tuition_payments` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `created_by` bigint UNSIGNED NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` bigint NOT NULL,
  `verified` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `file_moshavers`
--

CREATE TABLE `file_moshavers` (
  `id` bigint NOT NULL,
  `paye` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `title` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `filename` varchar(40) NOT NULL,
  `original_filename` varchar(40) NOT NULL,
  `mime` varchar(40) NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `films`
--

CREATE TABLE `films` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED DEFAULT NULL,
  `auther` tinyint UNSIGNED NOT NULL,
  `chapter` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `bakhsh` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `price` bigint UNSIGNED NOT NULL DEFAULT '0',
  `downloadcount` bigint NOT NULL DEFAULT '0',
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dars` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `original_filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `archive` tinyint DEFAULT '0',
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `film_download`
--

CREATE TABLE `film_download` (
  `id` bigint UNSIGNED NOT NULL,
  `film_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `numberdown` int NOT NULL,
  `payment` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `film_sections`
--

CREATE TABLE `film_sections` (
  `id` bigint NOT NULL,
  `section` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `section_id` int NOT NULL DEFAULT '0',
  `bakhsh` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `film_sections`
--

INSERT INTO `film_sections` (`id`, `section`, `section_id`, `bakhsh`, `created_at`, `updated_at`) VALUES
(1, 'تست فیلم', 0, NULL, '2023-11-25', '2023-11-25');

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

--
-- Table structure for table `finanaces`
--

CREATE TABLE `finanaces` (
  `id` int UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `total` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `paid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remaining` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `fines`
--

CREATE TABLE `fines` (
  `id` int UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `library_id` bigint UNSIGNED NOT NULL,
  `day` int NOT NULL DEFAULT '0' COMMENT 'تعداد روز تاخیر کرده در برگشت',
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'وضعیت جریمه',
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `finish_exams`
--

CREATE TABLE `finish_exams` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `exam_id` int NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `first_messages`
--

CREATE TABLE `first_messages` (
  `id` bigint NOT NULL,
  `receiver` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `message` text CHARACTER SET utf8mb3 COLLATE utf8mb3_polish_ci NOT NULL,
  `modal` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `first_messages`
--

INSERT INTO `first_messages` (`id`, `receiver`, `message`, `modal`, `created_at`, `updated_at`, `deleted_at`) VALUES
(6, 'دانش آموز', '<p>این یک متن آزمایشی می باشد.</p>', 0, '2021-04-23 18:16:59', '2021-04-23 18:16:59', NULL),
(7, 'دانش آموز', '<p>این یک متن آزمایشی می باشد.</p>', 0, '2021-04-23 18:17:07', '2021-04-23 18:17:07', NULL),
(8, 'دانش آموز', '<p>این یک متن آزمایشی می باشد.</p>', 0, '2021-04-23 18:17:23', '2021-04-23 18:17:23', NULL),
(9, 'دانش آموز', '<p>این یک متن آزمایشی می باشد.</p>', 0, '2021-04-23 18:17:54', '2021-04-23 18:17:54', NULL);

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

--
-- Table structure for table `forms`
--

CREATE TABLE `forms` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `class_id` bigint NOT NULL,
  `dars_id` bigint DEFAULT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `form_questions`
--

CREATE TABLE `form_questions` (
  `id` int UNSIGNED NOT NULL,
  `form_id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text',
  `order` int NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `form_responses`
--

CREATE TABLE `form_responses` (
  `id` int UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `form_id` bigint UNSIGNED NOT NULL,
  `form_question_id` bigint UNSIGNED NOT NULL,
  `value` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `gateways`
--

CREATE TABLE `gateways` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('online','offline') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'online',
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `default` tinyint NOT NULL DEFAULT '0',
  `active` tinyint NOT NULL DEFAULT '0',
  `wallet` tinyint NOT NULL DEFAULT '0',
  `limit_cost` int NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gateways`
--

INSERT INTO `gateways` (`id`, `name`, `slug`, `type`, `image`, `config`, `default`, `active`, `wallet`, `limit_cost`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'زرین پال', 'Zarinpal', 'online', 'zarinpal.png', '{\"merchant\":\"19422cd0-ee04-4c84-80d6-0f191fff8355\"}', 1, 1, 0, 0, NULL, '2020-10-05 23:38:59', '2026-05-30 16:05:12');

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

--
-- Table structure for table `hamayeshes`
--

CREATE TABLE `hamayeshes` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `manager` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `permission` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `context` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `items` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `hamayesh_memebers`
--

CREATE TABLE `hamayesh_memebers` (
  `id` bigint UNSIGNED NOT NULL,
  `hamayesh_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `homes`
--

CREATE TABLE `homes` (
  `id` int UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `little_body` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `place` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `homes`
--

INSERT INTO `homes` (`id`, `user_id`, `title`, `little_body`, `body`, `place`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL, NULL, 'سخن مدیر', '2020-09-30 00:00:00', '0000-00-00 00:00:00'),
(53, 1, NULL, NULL, NULL, 'درباره', '2020-09-30 00:00:00', '2020-09-30 00:00:00');

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

--
-- Table structure for table `home_images`
--

CREATE TABLE `home_images` (
  `id` int UNSIGNED NOT NULL,
  `matlab_id` int UNSIGNED NOT NULL,
  `mime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `resize_image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `job` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jtamrin_files`
--

CREATE TABLE `jtamrin_files` (
  `id` int NOT NULL,
  `filename` varchar(191) NOT NULL,
  `mime` varchar(191) NOT NULL,
  `original_filename` varchar(191) NOT NULL,
  `jtamrin_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `j_tamrins`
--

CREATE TABLE `j_tamrins` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `teacher_id` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `tamrin_id` bigint UNSIGNED NOT NULL,
  `namedars` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mark` int DEFAULT NULL,
  `filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `daraje` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `karnameh_admins`
--

CREATE TABLE `karnameh_admins` (
  `id` int NOT NULL,
  `dars_id` int NOT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci NOT NULL,
  `count` int NOT NULL,
  `mark` int NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `user_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `libraries`
--

CREATE TABLE `libraries` (
  `id` bigint UNSIGNED NOT NULL,
  `issue` bigint NOT NULL COMMENT 'شماره کتاب',
  `count` bigint NOT NULL COMMENT 'تعداد کتاب',
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'نام کتاب',
  `author` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'نام نویسنده',
  `Publisher` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'نام ناشر',
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `libraries`
--

INSERT INTO `libraries` (`id`, `issue`, `count`, `name`, `author`, `Publisher`, `created_at`, `updated_at`) VALUES
(1, 1232, 3, 'test', 'author', 'publisher', '1405-03-09', '1405-03-09');

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

--
-- Table structure for table `log_activities`
--

CREATE TABLE `log_activities` (
  `id` int UNSIGNED NOT NULL,
  `subject` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `method` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `agent` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `log_finanaces`
--

CREATE TABLE `log_finanaces` (
  `id` int UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `price` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('online','fish') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'online',
  `filename` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `original_filename` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `verify` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci NOT NULL,
  `cheque_number` int DEFAULT NULL,
  `cheque_date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `mail_models`
--

CREATE TABLE `mail_models` (
  `id` bigint UNSIGNED NOT NULL,
  `subject` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `date` datetime NOT NULL,
  `time` int NOT NULL,
  `like` int NOT NULL,
  `view` int NOT NULL,
  `status` int NOT NULL,
  `mime` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `original_filename` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `filename` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `main_karnameh_schools`
--

CREATE TABLE `main_karnameh_schools` (
  `id` int UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `dars_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `mostamar_aval` double(8,2) DEFAULT NULL,
  `nobat_aval` double(8,2) DEFAULT NULL,
  `mostamar_dovom` double(8,2) DEFAULT NULL,
  `nobat_dovom` double(8,2) DEFAULT NULL,
  `final_aval` double(8,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `main_pagees`
--

CREATE TABLE `main_pagees` (
  `id` bigint UNSIGNED NOT NULL,
  `body` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `site` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `main_pagees`
--

INSERT INTO `main_pagees` (`id`, `body`, `name`, `site`, `created_at`, `updated_at`) VALUES
(1, NULL, 'school', 'myschool.com', NULL, '1402-07-08 11:38:08'),
(2, NULL, 'سازمان سنجش', 'https://www.sanjesh.org/fa-IR/sanjesh/1/page/%D8%B5%D9%81%D8%AD%D9%87-%D8%A7%D8%B5%D9%84%DB%8C', '1402-07-08 11:34:04', '1402-07-08 11:34:04'),
(3, NULL, 'کتابخانه ملی', 'https://www.nlai.ir/', '1402-07-08 11:34:29', '1402-07-08 11:34:29'),
(4, NULL, 'وب سایت مجتمع مدارس', 'www.chamranschool.com', '1402-07-08 11:38:08', '1402-07-08 11:38:08');

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

--
-- Table structure for table `main_pages`
--

CREATE TABLE `main_pages` (
  `id` bigint UNSIGNED NOT NULL,
  `phone` bigint NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `day` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `time` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `main_pages`
--

INSERT INTO `main_pages` (`id`, `phone`, `email`, `day`, `time`, `created_at`, `updated_at`) VALUES
(1, 613738143, 'saeedhd6@gmail.com', 'از شنبه تا چهارشنبه', 'از 8 صبح الی 14', NULL, '1402-07-08 11:39:17');

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

--
-- Table structure for table `manager_home_works`
--

CREATE TABLE `manager_home_works` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `manager_home_work_responses`
--

CREATE TABLE `manager_home_work_responses` (
  `id` int UNSIGNED NOT NULL,
  `manager_home_work_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `mark_items`
--

CREATE TABLE `mark_items` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `mark` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_id` bigint UNSIGNED NOT NULL,
  `coddars` int NOT NULL,
  `codclass` int NOT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mark_items`
--

INSERT INTO `mark_items` (`id`, `user_id`, `mark`, `item_id`, `coddars`, `codclass`, `created_at`, `updated_at`) VALUES
(1, 326361, '19.93', 1, 3, 1, '1405-03-09', '1405-03-09'),
(2, 325360, '12', 1, 3, 1, '1405-03-09', '1405-03-09'),
(3, 324359, '20', 1, 3, 1, '1405-03-09', '1405-03-09');

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

--
-- Table structure for table `meeting_users`
--

CREATE TABLE `meeting_users` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `meeting_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `meet_requests`
--

CREATE TABLE `meet_requests` (
  `id` int UNSIGNED NOT NULL,
  `date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pend','accept','reject') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pend',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `message_reseivers`
--

CREATE TABLE `message_reseivers` (
  `id` bigint UNSIGNED NOT NULL,
  `mail_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `author` bigint UNSIGNED NOT NULL,
  `important` tinyint(1) NOT NULL DEFAULT '0',
  `time` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2017_02_29_002740_create_users', 1),
(2, '2017_06_07_155707_create_activation_codes_table', 1),
(3, '2019_02_29_011441_create_dars', 1),
(4, '2019_06_10_142027_create_payes_table', 1),
(5, '2019_06_19_210551_create_mail_models_table', 1),
(6, '2019_06_19_210812_create_message_reseivers_table', 1),
(7, '2019_08_02_134634_create_clas', 1),
(8, '2019_08_02_134635_create_c_marks', 1),
(9, '2019_08_02_134635_create_r_karnamehs_table', 1),
(10, '2019_08_02_134636_create_c_karnamehs_table', 1),
(11, '2019_08_02_140046_create_s_karnamehs_table', 1),
(12, '2019_08_06_160352_create_s_mkarnamehs_table', 1),
(13, '2019_08_19_100056_create_teacher_programes_table', 1),
(14, '2019_10_03_201324_create_homes_table', 1),
(15, '2019_10_03_201352_create_home_images_table', 1),
(16, '2019_10_03_201414_create_tags_table', 1),
(17, '2019_10_03_201432_create_comments_table', 1),
(18, '2019_10_03_201452_create_p_comments_table', 1),
(19, '2019_11_01_074936_create_jobs_table', 1),
(20, '2019_11_15_073336_create_portfolio_details_table', 1),
(21, '2019_11_15_111745_create_c_tags_table', 1),
(22, '2019_11_20_105910_create_r_tamas_table', 1),
(23, '2019_11_25_220022_create_films_table', 1),
(24, '2019_11_27_083802_create_c_disciplines_table', 1),
(25, '2019_11_27_093725_create_disciplines_table', 1),
(26, '2019_12_13_164059_create_main_pages_table', 1),
(27, '2019_12_13_183025_create_main_pagees_table', 1),
(28, '2020_02_29_010444_create_barnamehs', 1),
(29, '2020_02_29_010545_create_mark_items_table', 1),
(30, '2020_02_29_010546_create_total_marks_table', 1),
(31, '2020_02_29_010709_create_film_download', 1),
(32, '2020_02_29_010805_create_tamrins', 1),
(33, '2020_02_29_010824_create_j_tamrins', 1),
(34, '2020_02_29_010910_create_parents', 1),
(35, '2020_02_29_010946_create_students', 1),
(36, '2020_02_29_011040_create_teachers', 1),
(37, '2020_03_07_192125_address_models', 1),
(38, '2020_03_11_095905_create_questions_table', 1),
(39, '2020_03_11_112636_create_blogs_table', 1),
(40, '2020_03_11_132856_create_challenges_table', 1),
(41, '2020_03_11_132946_create_answers_table', 1),
(42, '2020_03_11_133001_create_p_answers_table', 1),
(43, '2020_03_17_101819_create_roles_table', 1),
(44, '2020_03_17_103855_create_libraries_table', 1),
(45, '2020_03_17_104034_create_trusts_table', 1),
(46, '2020_03_17_104055_create_reservations_table', 1),
(47, '2020_03_17_104127_create_fines_table', 1),
(48, '2020_03_23_123419_create_pre_registrations_table', 1),
(49, '2020_03_23_191137_create_roll_calls_table', 1),
(50, '2020_05_24_111909_create_pasokh_teachers_table', 1),
(60, '2020_06_08_124514_create_tuitions_table', 3),
(61, '2020_06_08_124607_create_pay_tuitions_table', 3),
(92, '2020_06_14_140500_create_examss_table', 5),
(93, '2020_06_14_140639_create_exam_questions_table', 5),
(94, '2020_06_14_140640_create_options_table', 5),
(95, '2020_06_14_140641_create_finanaces_table', 6),
(96, '2020_06_14_140642_create_log_finanaces_table', 6),
(97, '2020_06_14_140650_create_selection_items_table', 7),
(100, '2020_06_14_140653_create_selection_members_table', 7),
(101, '2020_06_14_140651_create_selections_table', 8),
(102, '2020_06_14_140655_create_gateways_table', 9),
(103, '2020_06_14_140656_create_payments_table', 10),
(109, '2016_01_04_173148_create_admin_tables', 11),
(110, '2018_08_08_100000_create_telescope_entries_table', 11),
(111, '2019_02_20_000001_add_dumps_table', 11),
(112, '2020_06_14_140648_create_hamayeshes_table', 11),
(113, '2020_06_14_140649_create_hamayesh_memebers_table', 11),
(114, '2017_02_29_002741_create_log_activities_table', 12),
(117, '2017_02_29_002740_selection_options_table\r\n', 1),
(122, '2020_06_14_140643_create_option_images_table', 13),
(123, '2020_06_14_140645_create_onlinelists_table', 14),
(124, '2020_06_14_140501_create_patterns_table', 15),
(125, '2020_06_14_140502_create_pattern_memeber_blocks_table', 15),
(126, '2020_06_14_140503_create_pattern_items_table', 15),
(127, '2020_06_14_140504_create_pattern_item_answers_table', 15),
(128, '2020_06_14_140507_create_pattern_statuses_table', 15),
(129, '2023_12_23_221129_create_forms_table', 16),
(130, '2023_12_29_120313_template_selections', 17),
(131, '2023_12_29_121255_template_answare', 18),
(132, '2023_12_29_121410_template_answare_options', 19),
(133, '2023_12_29_120955_template_selection_questions', 20),
(134, '2023_12_29_123256_new_selections', 21),
(135, '2023_12_29_123514_new_selection_teachers', 22),
(136, '2023_12_29_132106_create_new_selection_responses_table', 23),
(137, '2024_01_18_172111_create_main_karnameh_schools_table', 24),
(138, '2024_02_23_200101_create_terms_table', 25),
(139, '2024_03_02_204335_create_manager_home_works_table', 26),
(140, '2024_03_02_204444_create_manager_home_work_responses_table', 27),
(141, '2024_03_02_204539_create_meet_requests_table', 28),
(142, '2024_03_03_200421_create_slide_classes_table', 29);

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

--
-- Table structure for table `moshavers`
--

CREATE TABLE `moshavers` (
  `id` bigint UNSIGNED NOT NULL,
  `paye` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `title` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci,
  `start` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `member` varchar(11) DEFAULT '2',
  `record` varchar(11) DEFAULT NULL,
  `server` varchar(11) DEFAULT NULL,
  `online` varchar(20) NOT NULL DEFAULT '0',
  `created_at` date NOT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `moshaver_sabts`
--

CREATE TABLE `moshaver_sabts` (
  `id` bigint NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `teacher_id` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `text` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `date` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `myexams`
--

CREATE TABLE `myexams` (
  `id` bigint UNSIGNED NOT NULL,
  `author` bigint UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `date_start` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `expire` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `time` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `archive` tinyint DEFAULT '0',
  `mark_status` tinyint NOT NULL DEFAULT '0',
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `countquestions` int DEFAULT NULL,
  `texprie` time DEFAULT '23:59:59',
  `start` time DEFAULT '00:00:00',
  `filename` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `mime` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `original_filename` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'type = 0 آزمون تستی\r\ntype = 1 آزمون تشریحی',
  `general` int NOT NULL DEFAULT '0' COMMENT 'اگر ۱ شد آزمون جامع هستش',
  `number_dars` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `random` int NOT NULL DEFAULT '0' COMMENT 'آیا سوالات رندوم باشد یا خیر'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `myexams`
--

INSERT INTO `myexams` (`id`, `author`, `title`, `status`, `date_start`, `expire`, `time`, `archive`, `mark_status`, `created_at`, `updated_at`, `deleted_at`, `countquestions`, `texprie`, `start`, `filename`, `mime`, `original_filename`, `type`, `general`, `number_dars`, `random`) VALUES
(1, 1, 'w', 0, '1405/03/10', '1405/03/10', '20', 0, 0, '1405-03-10', '2026-05-31', NULL, 1, '23:59:00', '00:00:00', NULL, NULL, NULL, 1, 0, '1', 0);

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

--
-- Table structure for table `new_selections`
--

CREATE TABLE `new_selections` (
  `id` int UNSIGNED NOT NULL,
  `template_selection_id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `new_selections`
--

INSERT INTO `new_selections` (`id`, `template_selection_id`, `title`, `description`, `start_date`, `end_date`, `required`, `created_at`, `updated_at`) VALUES
(1, 1, 'test', 'test', '1402-03-24', '1402-03-28', 1, '2023-12-29 09:06:51', '2023-12-29 09:06:51');

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

--
-- Table structure for table `new_selection_responses`
--

CREATE TABLE `new_selection_responses` (
  `id` int UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `new_selection_id` bigint UNSIGNED NOT NULL,
  `template_selection_question_id` bigint UNSIGNED NOT NULL,
  `template_answare_option_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `new_selection_responses`
--

INSERT INTO `new_selection_responses` (`id`, `user_id`, `new_selection_id`, `template_selection_question_id`, `template_answare_option_id`, `created_at`, `updated_at`) VALUES
(1, 74076, 1, 1, 1, '2023-12-29 10:25:05', '2023-12-29 10:25:05'),
(2, 74076, 1, 2, 2, '2023-12-29 10:25:05', '2023-12-29 10:25:05'),
(3, 74076, 1, 4, 1, '2023-12-29 10:25:05', '2023-12-29 10:25:05');

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

--
-- Table structure for table `new_selection_teachers`
--

CREATE TABLE `new_selection_teachers` (
  `id` int UNSIGNED NOT NULL,
  `new_selection_id` bigint UNSIGNED NOT NULL,
  `teacher_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `new_selection_teachers`
--

INSERT INTO `new_selection_teachers` (`id`, `new_selection_id`, `teacher_id`, `created_at`, `updated_at`) VALUES
(1, 1, 5, '2023-12-29 09:06:51', '2023-12-29 09:06:51'),
(2, 1, 10, '2023-12-29 09:06:51', '2023-12-29 09:06:51');

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

--
-- Table structure for table `onlinelists`
--

CREATE TABLE `onlinelists` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `role` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` int NOT NULL DEFAULT '1',
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `onlinelists`
--

INSERT INTO `onlinelists` (`id`, `user_id`, `class_id`, `role`, `version`, `date`, `time`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'moderator', 1, '1405-03-10', '09:24:40', NULL, '2026-05-31 05:54:40', '2026-05-31 05:54:40'),
(2, 1, 1, 'moderator', 1, '1405-03-10', '09:24:41', NULL, '2026-05-31 05:54:41', '2026-05-31 05:54:41'),
(3, 1, 1, 'moderator', 1, '1405-03-10', '09:24:41', NULL, '2026-05-31 05:54:41', '2026-05-31 05:54:41'),
(4, 1, 1, 'moderator', 1, '1405-03-10', '09:24:42', NULL, '2026-05-31 05:54:42', '2026-05-31 05:54:42'),
(5, 1, 1, 'moderator', 1, '1405-03-10', '09:24:43', NULL, '2026-05-31 05:54:43', '2026-05-31 05:54:43'),
(6, 1, 1, 'moderator', 1, '1405-03-10', '09:24:44', NULL, '2026-05-31 05:54:44', '2026-05-31 05:54:44'),
(7, 1, 1, 'moderator', 1, '1405-03-10', '09:24:45', NULL, '2026-05-31 05:54:45', '2026-05-31 05:54:45'),
(8, 1, 1, 'moderator', 1, '1405-03-10', '09:24:46', NULL, '2026-05-31 05:54:46', '2026-05-31 05:54:46'),
(9, 1, 1, 'moderator', 1, '1405-03-10', '09:24:48', NULL, '2026-05-31 05:54:48', '2026-05-31 05:54:48'),
(10, 1, 1, 'moderator', 1, '1405-03-10', '09:24:49', NULL, '2026-05-31 05:54:49', '2026-05-31 05:54:49'),
(11, 1, 1, 'moderator', 1, '1405-03-10', '09:24:50', NULL, '2026-05-31 05:54:50', '2026-05-31 05:54:50'),
(12, 1, 1, 'moderator', 1, '1405-03-10', '09:24:51', NULL, '2026-05-31 05:54:51', '2026-05-31 05:54:51'),
(13, 1, 1, 'moderator', 1, '1405-03-10', '09:24:52', NULL, '2026-05-31 05:54:52', '2026-05-31 05:54:52'),
(14, 1, 1, 'moderator', 1, '1405-03-10', '09:24:53', NULL, '2026-05-31 05:54:53', '2026-05-31 05:54:53'),
(15, 1, 1, 'moderator', 1, '1405-03-10', '09:24:54', NULL, '2026-05-31 05:54:54', '2026-05-31 05:54:54'),
(16, 1, 1, 'moderator', 1, '1405-03-10', '09:24:56', NULL, '2026-05-31 05:54:56', '2026-05-31 05:54:56'),
(17, 1, 1, 'moderator', 1, '1405-03-10', '09:24:57', NULL, '2026-05-31 05:54:57', '2026-05-31 05:54:57'),
(18, 1, 1, 'moderator', 1, '1405-03-10', '09:24:58', NULL, '2026-05-31 05:54:58', '2026-05-31 05:54:58'),
(19, 1, 1, 'moderator', 1, '1405-03-10', '09:24:59', NULL, '2026-05-31 05:54:59', '2026-05-31 05:54:59'),
(20, 1, 1, 'moderator', 1, '1405-03-10', '09:25:00', NULL, '2026-05-31 05:55:00', '2026-05-31 05:55:00'),
(21, 1, 1, 'moderator', 1, '1405-03-10', '09:25:03', NULL, '2026-05-31 05:55:03', '2026-05-31 05:55:03'),
(22, 1, 1, 'moderator', 1, '1405-03-10', '09:25:04', NULL, '2026-05-31 05:55:04', '2026-05-31 05:55:04'),
(23, 1, 1, 'moderator', 1, '1405-03-10', '09:25:05', NULL, '2026-05-31 05:55:05', '2026-05-31 05:55:05'),
(24, 1, 1, 'moderator', 1, '1405-03-10', '09:25:06', NULL, '2026-05-31 05:55:06', '2026-05-31 05:55:06'),
(25, 1, 1, 'moderator', 1, '1405-03-10', '09:25:07', NULL, '2026-05-31 05:55:07', '2026-05-31 05:55:07'),
(26, 1, 1, 'moderator', 1, '1405-03-10', '09:25:08', NULL, '2026-05-31 05:55:08', '2026-05-31 05:55:08'),
(27, 1, 1, 'moderator', 1, '1405-03-10', '09:25:09', NULL, '2026-05-31 05:55:09', '2026-05-31 05:55:09'),
(28, 1, 1, 'moderator', 1, '1405-03-10', '09:25:11', NULL, '2026-05-31 05:55:11', '2026-05-31 05:55:11'),
(29, 1, 1, 'moderator', 1, '1405-03-10', '09:25:12', NULL, '2026-05-31 05:55:12', '2026-05-31 05:55:12'),
(30, 1, 1, 'moderator', 1, '1405-03-10', '09:25:13', NULL, '2026-05-31 05:55:13', '2026-05-31 05:55:13'),
(31, 1, 1, 'moderator', 1, '1405-03-10', '09:25:14', NULL, '2026-05-31 05:55:14', '2026-05-31 05:55:14'),
(32, 1, 1, 'moderator', 1, '1405-03-10', '09:25:15', NULL, '2026-05-31 05:55:15', '2026-05-31 05:55:15'),
(33, 1, 1, 'moderator', 1, '1405-03-10', '09:25:16', NULL, '2026-05-31 05:55:16', '2026-05-31 05:55:16'),
(34, 1, 1, 'moderator', 1, '1405-03-10', '09:25:17', NULL, '2026-05-31 05:55:17', '2026-05-31 05:55:17'),
(35, 1, 1, 'moderator', 1, '1405-03-10', '09:25:18', NULL, '2026-05-31 05:55:18', '2026-05-31 05:55:18'),
(36, 1, 1, 'moderator', 1, '1405-03-10', '09:25:19', NULL, '2026-05-31 05:55:19', '2026-05-31 05:55:19'),
(37, 1, 1, 'moderator', 1, '1405-03-10', '09:25:20', NULL, '2026-05-31 05:55:20', '2026-05-31 05:55:20'),
(38, 1, 1, 'moderator', 1, '1405-03-10', '09:25:21', NULL, '2026-05-31 05:55:21', '2026-05-31 05:55:21'),
(39, 1, 1, 'moderator', 1, '1405-03-10', '09:25:22', NULL, '2026-05-31 05:55:22', '2026-05-31 05:55:22'),
(40, 1, 1, 'moderator', 1, '1405-03-10', '09:25:23', NULL, '2026-05-31 05:55:23', '2026-05-31 05:55:23'),
(41, 1, 1, 'moderator', 1, '1405-03-10', '09:25:29', NULL, '2026-05-31 05:55:29', '2026-05-31 05:55:29'),
(42, 1, 1, 'moderator', 1, '1405-03-10', '09:25:30', NULL, '2026-05-31 05:55:30', '2026-05-31 05:55:30'),
(43, 1, 1, 'moderator', 1, '1405-03-10', '09:25:32', NULL, '2026-05-31 05:55:32', '2026-05-31 05:55:32'),
(44, 1, 1, 'moderator', 1, '1405-03-10', '09:25:33', NULL, '2026-05-31 05:55:33', '2026-05-31 05:55:33'),
(45, 1, 11, 'moderator', 1, '1405-03-10', '09:29:44', NULL, '2026-05-31 05:59:44', '2026-05-31 05:59:44'),
(46, 1, 6722806, 'moderator', 1, '1405-03-10', '09:35:02', NULL, '2026-05-31 06:05:02', '2026-05-31 06:05:02');

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

--
-- Table structure for table `online_classes`
--

CREATE TABLE `online_classes` (
  `id` bigint UNSIGNED NOT NULL,
  `author` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dars` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `enddate` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `start` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `end` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `member` int NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `original_filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `record` tinyint(1) NOT NULL DEFAULT '1',
  `server` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `day_id` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `online_classes`
--

INSERT INTO `online_classes` (`id`, `author`, `class_id`, `title`, `dars`, `date`, `enddate`, `start`, `end`, `member`, `status`, `description`, `original_filename`, `filename`, `mime`, `record`, `server`, `day_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 324358, 1, 'تستی', '1', '1405-03-10', '1405/03/25', '00:00', '23:59', 20, 1, NULL, NULL, NULL, NULL, 1, '1', 1, '2026-05-31 05:57:16', '2026-05-31 05:54:33', '2026-05-31 05:57:16'),
(2, 324358, 10, 'تستی', '1', '1405-03-10', '1405/03/25', '00:00', '23:59', 20, 1, NULL, NULL, NULL, NULL, 1, '1', 1, '2026-05-31 05:57:16', '2026-05-31 05:54:33', '2026-05-31 05:57:16'),
(3, 324358, 1, 'تست است', '1', '1405-03-10', '1405/03/10', '00:00', '23:59', 20, 1, NULL, NULL, NULL, NULL, 0, '1', 1, '2026-05-31 05:57:16', '2026-05-31 05:58:40', '2026-05-31 05:58:40'),
(4, 324358, 1, 'تست است', '1', '1405-03-10', '1405/03/10', '00:00', '23:59', 20, 1, NULL, NULL, NULL, NULL, 0, '1', 1, '2026-05-31 05:57:16', '2026-05-31 05:58:53', '2026-05-31 05:58:53'),
(5, 324358, 1, 'تست است', '1', '1405-03-10', '1405/03/10', '00:00', '23:59', 20, 1, NULL, NULL, NULL, NULL, 0, '1', 1, '2026-05-31 05:57:16', '2026-05-31 05:59:11', '2026-05-31 05:59:11'),
(6, 324358, 1, 'تست است', '1', '1405-03-10', '1405/03/10', '00:00', '23:59', 20, 1, NULL, NULL, NULL, NULL, 0, '1', 1, '2026-05-31 05:57:16', '2026-05-31 05:59:14', '2026-05-31 05:59:14'),
(7, 324358, 1, 'تست است', '1', '1405-03-10', '1405/03/10', '00:00', '23:59', 20, 1, NULL, NULL, NULL, NULL, 0, '1', 1, '2026-05-31 05:57:16', '2026-05-31 05:59:16', '2026-05-31 05:59:16'),
(8, 324358, 1, 'تست است', '1', '1405-03-10', '1405/03/10', '00:00', '23:59', 20, 1, NULL, NULL, NULL, NULL, 0, '1', 1, '2026-05-31 05:57:16', '2026-05-31 05:59:19', '2026-05-31 05:59:19'),
(9, 324358, 1, 'تست است', '1', '1405-03-10', '1405/03/10', '00:00', '23:59', 20, 1, NULL, NULL, NULL, NULL, 0, '1', 1, '2026-05-31 05:57:16', '2026-05-31 05:59:21', '2026-05-31 05:59:21'),
(10, 324358, 1, 'تست است', '1', '1405-03-10', '1405/03/10', '00:00', '23:59', 20, 1, NULL, NULL, NULL, NULL, 0, '1', 1, '2026-05-31 05:57:16', '2026-05-31 05:59:22', '2026-05-31 05:59:22'),
(11, 324358, 1, 'تست است', '1', '1405-03-10', '1405/03/10', '00:00', '23:59', 20, 1, NULL, NULL, NULL, NULL, 0, '1', 1, '2026-05-31 05:57:16', '2026-05-31 05:59:33', '2026-05-31 05:59:33'),
(6722806, 324358, 1, 'تستیه', '1', '1405-03-10', '1405/03/18', '00:00', '23:59', 3, 1, NULL, NULL, NULL, NULL, 0, 'sky', 1, NULL, '2026-05-31 06:04:57', '2026-05-31 06:04:57');

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

--
-- Table structure for table `options`
--

CREATE TABLE `options` (
  `id` bigint UNSIGNED NOT NULL,
  `question_id` bigint UNSIGNED NOT NULL,
  `1` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `2` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `3` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `4` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `correct` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `option_images`
--

CREATE TABLE `option_images` (
  `id` int UNSIGNED NOT NULL,
  `question_id` bigint UNSIGNED NOT NULL,
  `option_id` bigint UNSIGNED NOT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `parents`
--

CREATE TABLE `parents` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `student_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `parents`
--

INSERT INTO `parents` (`id`, `user_id`, `student_id`, `created_at`, `updated_at`) VALUES
(1, 325359, 324359, '2026-05-30 14:59:53', '2026-05-30 14:59:53'),
(2, 326360, 325360, '2026-05-30 15:00:22', '2026-05-30 15:00:22'),
(3, 327361, 326361, '2026-05-30 15:00:40', '2026-05-30 15:00:40'),
(4, 328362, 327362, '2026-05-30 15:00:57', '2026-05-30 15:00:57'),
(5, 329363, 328363, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 330364, 329364, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 331365, 330365, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 332366, 331366, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

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

--
-- Table structure for table `pasokh_teachers`
--

CREATE TABLE `pasokh_teachers` (
  `id` bigint UNSIGNED NOT NULL,
  `tamrin_id` bigint UNSIGNED NOT NULL,
  `teacher_id` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `patterns`
--

CREATE TABLE `patterns` (
  `id` bigint UNSIGNED NOT NULL,
  `author` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_from` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_to` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_id` int NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pattern_items`
--

CREATE TABLE `pattern_items` (
  `id` bigint UNSIGNED NOT NULL,
  `pattern_id` bigint UNSIGNED NOT NULL,
  `dars_id` bigint UNSIGNED DEFAULT NULL,
  `day_id` bigint UNSIGNED DEFAULT NULL,
  `time` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'time give minutes',
  `status` int DEFAULT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pattern_item_answers`
--

CREATE TABLE `pattern_item_answers` (
  `id` bigint UNSIGNED NOT NULL,
  `pattern_item_id` bigint UNSIGNED DEFAULT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `time` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'time give minutes',
  `status` int DEFAULT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dars_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pattern_memeber_blocks`
--

CREATE TABLE `pattern_memeber_blocks` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `pattern_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pattern_statuses`
--

CREATE TABLE `pattern_statuses` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pattern_statuses`
--

INSERT INTO `pattern_statuses` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'مطالعه', NULL, NULL),
(2, 'پیش مطالعه', NULL, NULL),
(3, 'حل تمرین تستی', NULL, NULL),
(4, 'حل تمرین تشریحی', NULL, NULL);

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

--
-- Table structure for table `payes`
--

CREATE TABLE `payes` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payes`
--

INSERT INTO `payes` (`id`, `name`, `created_at`, `updated_at`) VALUES
(2, 'دهم', '2023-09-11 07:57:38', '2023-09-11 07:57:38'),
(3, 'یازدهم', '2023-09-11 07:57:46', '2023-09-11 07:57:46'),
(4, 'دوازدهم', '2023-09-11 07:57:59', '2023-09-11 07:57:59'),
(5, 'دوازدهم تجربی', '2023-10-30 07:45:05', '2023-10-30 07:45:05');

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `amount` bigint NOT NULL DEFAULT '0',
  `gateway_id` bigint UNSIGNED DEFAULT NULL,
  `token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `trans_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_get` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('online','discount','wallet','local') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('success','failed','waiting','local','cancel') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'waiting',
  `ip` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`id`, `user_id`, `amount`, `gateway_id`, `token`, `date`, `trans_id`, `id_get`, `type`, `status`, `ip`, `deleted_at`, `created_at`, `updated_at`, `description`) VALUES
(1, 327362, 3000, 1, '59uYpjC2afbivmW9O7vCUujApn0m5khfdxV2kNX5KtRtC17ttj', '1780153021', NULL, NULL, 'online', 'waiting', '127.0.0.1', NULL, '2026-05-30 15:57:01', '2026-05-30 15:57:01', NULL),
(2, 327362, 3000, 1, 'a72V6oLKCm5INeI54yjMg68Rh21JqhH9rkFSmTsjjco9baOX35', '1780153339', NULL, NULL, 'online', 'waiting', '127.0.0.1', NULL, '2026-05-30 16:02:19', '2026-05-30 16:02:19', NULL),
(3, 327362, 3000, 1, 'oNKn14HY4qzcBOl2R0P2k350ZerbYs8f05H6Bbv0AETsA1a1ig', '1780153375', NULL, NULL, 'online', 'waiting', '127.0.0.1', NULL, '2026-05-30 16:02:55', '2026-05-30 16:02:55', 'خطا در ارتباط با زرین پال'),
(4, 327362, 3000, 1, 'd6GyxosME3blB3L1RYUJYfaBYmCwUk0bQGR6vsdfAOWsCETuPP', '1780153393', NULL, NULL, 'online', 'waiting', '127.0.0.1', NULL, '2026-05-30 16:03:13', '2026-05-30 16:03:13', NULL),
(5, 327362, 3000, 1, '1qmlWsfnlLtRhwz2c9c5EzpbHG4wbDot8ir8oARN6nffAnbfmI', '1780153402', NULL, NULL, 'online', 'waiting', '127.0.0.1', NULL, '2026-05-30 16:03:22', '2026-05-30 16:03:23', 'خطا در ارتباط با زرین پال'),
(6, 327362, 3000, 1, 'ltIdaCVRMcoQc7gYz1kXRPvcwBaVbPw0zALz2YNCeKt7dYZZzL', '1780153517', NULL, NULL, 'online', 'waiting', '127.0.0.1', NULL, '2026-05-30 16:05:17', '2026-05-30 16:05:17', 'خطا در ارتباط با زرین پال'),
(7, 326361, 3000, 1, 'jlPgKNbLL8tO9Dz8zaWGSUdAa1jIqy7nXBHoTdI9F0pSmrfI2b', '1780153575', NULL, NULL, 'online', 'waiting', '127.0.0.1', NULL, '2026-05-30 16:06:15', '2026-05-30 16:06:15', 'خطا در ارتباط با زرین پال'),
(8, 326361, 3000, 1, 'LEXZ49Qm0isPJAAsxeekyVp4cBzDlVcPTrvK6L61TX3IinfdY7', '1780154364', NULL, NULL, 'online', 'waiting', '127.0.0.1', NULL, '2026-05-30 16:19:24', '2026-05-30 16:19:24', 'خطا در ارتباط با زرین پال'),
(9, 326361, 3000, 1, 'R3RrW343bsgvOyGzAGurIucnMiF6zt8nhUHQbOvzBso8Vv0WBO', '1780154742', NULL, NULL, 'online', 'waiting', '127.0.0.1', NULL, '2026-05-30 16:25:42', '2026-05-30 16:25:43', 'خطا در ارتباط با زرین پال'),
(10, 326361, 3000, 1, 'RSdblJPKJPdEvaRKeL0FcXeQJTaKdJ6T9shTY2wMmQt7d5WfUq', '1780155537', NULL, NULL, 'online', 'waiting', '127.0.0.1', NULL, '2026-05-30 15:38:57', '2026-05-30 15:38:59', 'خطا در ارتباط با زرین پال'),
(11, 327362, 3000, 1, 'ieBoBXS09K6R3jNPWvfQrjSL2DDFQouvLotid0rHxnxD1NRXvA', '1780155825', NULL, NULL, 'online', 'waiting', '127.0.0.1', NULL, '2026-05-30 15:43:45', '2026-05-30 15:43:50', 'خطا در ارتباط با زرین پال'),
(12, 326361, 3000, 1, 'Wy7KoVlBtgDUKB0dyuC2uqZs9jC87o8hjPFWpLkLJ7L7pte8lM', '1780155845', NULL, NULL, 'online', 'waiting', '127.0.0.1', NULL, '2026-05-30 15:44:05', '2026-05-30 15:44:06', 'خطا در ارتباط با زرین پال');

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

--
-- Table structure for table `pay_tuitions`
--

CREATE TABLE `pay_tuitions` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `tuition_id` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `price` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `label` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `label`, `created_at`, `updated_at`) VALUES
(9, 'create-homepage', 'دسترسی به ایجاد مطالب صفحه اول سایت', '2019-07-28', '2019-07-28'),
(10, 'view-delete-homepage', 'دسترسی به نمایش و حذف مطالب صفحه اول سایت', '2019-07-28', '2019-07-28'),
(11, 'excle', 'دسترسی به بارگذاری اکسل', '2019-07-28', '2019-07-28'),
(12, 'create-member', 'دسترسی به ایجاد و ویرایش اعضای سایت', '2019-07-28', '2019-07-28'),
(13, 'view-member', 'دسترسی به مشاهده  اعضای سایت', '2019-07-28', '2019-07-28'),
(14, 'manage-classes', 'دسترسی به مدیریت کلاس ها', '2019-07-28', '2019-07-28'),
(15, 'manage-doros', 'دسترسی به مدیریت دروس', '2019-07-28', '2019-07-28'),
(16, 'manage-classprograme', 'دسترسی به مدیرت برنامه های درسی', '2019-07-28', '2019-07-28'),
(17, 'manage-examprograme', 'دسترسی به مدیرت برنامه های امتحان', '2019-07-28', '2019-07-28'),
(18, 'manage-Comparisonchart', 'دسترسی به نمودارهای مقایسه ای', '2019-07-28', '2019-07-28'),
(19, 'manage-developmentchart', 'دسترسی به نمودار های پیشرفت', '2019-07-28', '2019-07-28'),
(20, 'manage-secret', 'دسترسی به قسمت سطح دسترسی', '2019-07-29', '2019-07-29'),
(21, 'manage-webdesignner', 'طراح سایت', '2019-07-29', '2019-07-29'),
(22, 'karnameh', 'کارنامه ها', '2019-08-26', '2019-08-26'),
(23, 'message', 'اجازه پیامک', '2019-12-06', '2019-12-06'),
(26, 'pre-registration', 'پیش ثبت نام ها', '2020-04-02', '2020-04-02'),
(27, 'RTamas', 'درخواست همکاری', '2020-04-02', '2020-04-02'),
(28, 'rollcall', 'حضور غیاب', '2020-04-02', '2020-04-02'),
(29, 'discipline-list', 'لیست انضباط', '2020-04-02', '2020-04-02'),
(30, 'discipline-manage', 'تولید و مدیریت موارد انضباطی', '2020-04-02', '2020-04-02'),
(31, 'discipline-sabt', 'ثبت و مشاهده موارد انضباطی', '2020-04-02', '2020-04-02'),
(32, 'library', 'کتابخانه', '2020-04-02', '2020-04-02'),
(33, 'exam', 'مدیریت آزمون ها', '0000-00-00', '0000-00-00'),
(34, 'moshaver', 'مشاور', '0000-00-00', '0000-00-00'),
(35, 'message', 'مدیریت پیام ها', '0000-00-00', '0000-00-00'),
(36, 'finance', 'مالی', '0000-00-00', '0000-00-00'),
(37, 'selection', 'انتخابات و نظر سنجی', '0000-00-00', '0000-00-00'),
(38, 'online', 'کلاس آنلاین', '0000-00-00', '0000-00-00');

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `role_id` int UNSIGNED NOT NULL,
  `permission_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`role_id`, `permission_id`) VALUES
(5, 1),
(5, 2),
(1, 3),
(7, 9),
(7, 10),
(9, 15),
(9, 14),
(10, 17),
(10, 16),
(11, 18),
(11, 19),
(8, 13),
(8, 12),
(8, 11),
(6, 20),
(6, 19),
(6, 18),
(6, 17),
(6, 16),
(6, 15),
(6, 14),
(6, 13),
(6, 12),
(6, 11),
(6, 10),
(6, 9),
(12, 21),
(13, 22),
(6, 22),
(12, 21),
(14, 23),
(15, 24),
(16, 25),
(6, 21),
(6, 25),
(6, 26),
(6, 24),
(6, 23),
(6, 22),
(17, 31),
(17, 30),
(17, 24),
(18, 28),
(19, 27),
(20, 26),
(21, 31),
(21, 29),
(21, 30),
(22, 32),
(23, 28),
(23, 29),
(23, 30),
(23, 31),
(23, 23),
(23, 22),
(23, 21),
(23, 20),
(23, 19),
(23, 10),
(23, 11),
(23, 12),
(23, 13),
(23, 14),
(23, 15),
(23, 16),
(23, 17),
(23, 18),
(23, 9),
(23, 32),
(23, 27),
(23, 26),
(24, 33),
(23, 33),
(25, 34),
(23, 34),
(26, 35),
(23, 35),
(27, 36),
(23, 36),
(28, 37),
(23, 37),
(29, 38),
(23, 38);

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

--
-- Table structure for table `portfolio_details`
--

CREATE TABLE `portfolio_details` (
  `id` bigint UNSIGNED NOT NULL,
  `home_id` int UNSIGNED NOT NULL,
  `tag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `Customer` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pre_registrations`
--

CREATE TABLE `pre_registrations` (
  `id` bigint UNSIGNED NOT NULL,
  `f_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `l_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `Fname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `paye` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `codemeli` int NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `p_answers`
--

CREATE TABLE `p_answers` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `answer_id` bigint UNSIGNED NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `p_comments`
--

CREATE TABLE `p_comments` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `matlab_id` int UNSIGNED NOT NULL,
  `comment_id` int UNSIGNED NOT NULL,
  `status` int UNSIGNED NOT NULL DEFAULT '0',
  `body` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `questions`
--

CREATE TABLE `questions` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `auther` tinyint UNSIGNED NOT NULL,
  `chapter` int UNSIGNED NOT NULL,
  `price` bigint UNSIGNED NOT NULL,
  `downloadcount` int NOT NULL DEFAULT '0',
  `paye` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dars` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reservations`
--

CREATE TABLE `reservations` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `library_id` bigint UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int NOT NULL,
  `name` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `label` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `label`, `created_at`, `updated_at`) VALUES
(7, 'manage-homepage', 'مدیر صفحه اول سایت', '2019-07-28', '2019-07-28'),
(8, 'manage-member', 'مدیریت اعضای سایت', '2019-07-28', '2019-07-28'),
(9, 'manage-school', 'مدیریت مدرسه', '2019-07-28', '2019-07-28'),
(11, 'manage-charts', 'مدیریت نمودارها', '2019-07-28', '2019-07-28'),
(12, 'طراح سایت', 'web', '0000-00-00', '0000-00-00'),
(13, 'karnameh-manage', 'مدیریت کارنامه', '2019-08-26', '2019-08-26'),
(18, 'rollcall', 'حضور و غیاب', '2020-04-02', '2020-04-02'),
(21, 'discipline', 'موارد انضباطی', '2020-04-02', '2020-04-02'),
(22, 'library', 'کتابخانه', '2020-04-02', '2020-04-02'),
(23, 'manage-master', 'مدیر ارشدـدسترسی کامل', '2020-04-02', '2020-04-02'),
(24, 'exam', 'مدیریت آزمون ها', '0000-00-00', '0000-00-00'),
(25, 'moshaver', 'مشاور', '0000-00-00', '0000-00-00'),
(26, 'message', 'مدیریت پیام ها', '0000-00-00', '0000-00-00'),
(27, 'finance', 'مدیر مالی', '0000-00-00', '0000-00-00'),
(28, 'selection', 'انتخابات و نظر سنجی', '0000-00-00', '0000-00-00'),
(29, 'online', 'کلاس آنلاین', '0000-00-00', '0000-00-00');

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

--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `role_id` int NOT NULL,
  `user_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` (`role_id`, `user_id`) VALUES
(8, 49),
(9, 49),
(11, 4110),
(6, 31),
(7, 1010),
(8, 1010),
(9, 1010),
(10, 1010),
(6, 1007),
(7, 2),
(24, 519534),
(8, 3),
(23, 9018),
(23, 9019),
(7, 9020),
(8, 9020),
(9, 9020),
(23, 296348),
(23, 296349),
(23, 404469),
(23, 404468),
(23, 1),
(11, 324355),
(13, 324355),
(25, 324355);

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

--
-- Table structure for table `roll_calls`
--

CREATE TABLE `roll_calls` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `author` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roll_calls`
--

INSERT INTO `roll_calls` (`id`, `user_id`, `author`, `class_id`, `created_at`, `updated_at`) VALUES
(1, 326361, 324358, 1, '2026-05-30', '1405-03-09'),
(2, 326361, 324358, 1, '2026-05-30', '1405-03-09');

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

--
-- Table structure for table `roll_call_moshavers`
--

CREATE TABLE `roll_call_moshavers` (
  `id` bigint NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `moshavers_id` bigint UNSIGNED NOT NULL,
  `created_at` int NOT NULL,
  `updated_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `r_karnamehs`
--

CREATE TABLE `r_karnamehs` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `r_tamas`
--

CREATE TABLE `r_tamas` (
  `id` bigint UNSIGNED NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `place` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` bigint NOT NULL,
  `status` int NOT NULL DEFAULT '0',
  `date` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `selectionss`
--

CREATE TABLE `selectionss` (
  `id` bigint UNSIGNED NOT NULL,
  `selection_items_id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `manager` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `class` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `user` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `permission` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `winner` int NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `selection_items`
--

CREATE TABLE `selection_items` (
  `id` bigint UNSIGNED NOT NULL,
  `group` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `selection_items`
--

INSERT INTO `selection_items` (`id`, `group`, `name`, `created_at`, `updated_at`) VALUES
(1, 'انجمن', 'انجمن', NULL, NULL),
(3, 'نظر سنجی', 'نظرسنجی', NULL, NULL);

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

--
-- Table structure for table `selection_members`
--

CREATE TABLE `selection_members` (
  `id` bigint UNSIGNED NOT NULL,
  `selection_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `selection_optionss`
--

CREATE TABLE `selection_optionss` (
  `id` bigint UNSIGNED NOT NULL,
  `selection_id` bigint UNSIGNED NOT NULL,
  `selection_items_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `value` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `id` int NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `type_mark` tinyint(1) NOT NULL DEFAULT '0',
  `logo` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `BBB_SECURITY_SALT` varchar(100) DEFAULT NULL,
  `BBB_SERVER_BASE_URL` varchar(100) DEFAULT NULL,
  `BBB_SECURITY_SALT_2` text,
  `BBB_SERVER_BASE_URL_2` text,
  `sky` varchar(100) DEFAULT NULL,
  `finance_status` tinyint(1) NOT NULL DEFAULT '0',
  `finance_deadline` varchar(30) DEFAULT NULL,
  `student` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `students` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `parent` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `parents` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `teacher` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `teachers` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `paye` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT 'پایه',
  `admin` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `school` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `mark1` int NOT NULL DEFAULT '17',
  `mark2` int NOT NULL DEFAULT '15',
  `mark3` int NOT NULL DEFAULT '12',
  `created_at` int NOT NULL,
  `updated_at` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `name`, `type_mark`, `logo`, `BBB_SECURITY_SALT`, `BBB_SERVER_BASE_URL`, `BBB_SECURITY_SALT_2`, `BBB_SERVER_BASE_URL_2`, `sky`, `finance_status`, `finance_deadline`, `student`, `students`, `parent`, `parents`, `teacher`, `teachers`, `paye`, `admin`, `school`, `mark1`, `mark2`, `mark3`, `created_at`, `updated_at`) VALUES
(1, 'دبیرستان پسرانه دانشگاه دوره دوم', 1, '1699434146ارم خالی.png', 'wqPY0GjMmnN1NAVEIuigt5e3qECUm53aYs8lia22IuQ', 'https://class114.tehranwebinar.ir/bigbluebutton/', NULL, NULL, 'apikey-20253287-4-a77f375220e338a54fb3873bbdf9e2c0', 1, '1400/02/01', 'دانش آموز', 'دانش آموزان', 'ولی', 'اولیا', 'مدرس', 'مدرسان', 'پایه', 'ادمین', 'دبیرستان پسرانه دانشگاه (دوره', 17, 15, 12, 0, 2026);

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

--
-- Table structure for table `slide_classes`
--

CREATE TABLE `slide_classes` (
  `id` int UNSIGNED NOT NULL,
  `teacher_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `dars_id` bigint UNSIGNED NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `day_id` bigint UNSIGNED NOT NULL,
  `time` time NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `classid` bigint UNSIGNED NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `students`
--

INSERT INTO `students` (`id`, `user_id`, `classid`, `address`, `description`, `created_at`, `updated_at`) VALUES
(1, 324359, 1, NULL, NULL, '2026-05-30 14:59:53', '2026-05-30 14:59:53'),
(2, 325360, 1, NULL, NULL, '2026-05-30 15:00:22', '2026-05-30 15:00:22'),
(3, 326361, 1, NULL, NULL, '2026-05-30 15:00:40', '2026-05-30 15:00:40'),
(4, 327362, 2, NULL, NULL, '2026-05-30 15:00:57', '2026-05-30 15:00:57'),
(5, 328363, 112, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 329364, 112, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 330365, 112, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 331366, 112, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

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

--
-- Table structure for table `s_karnamehs`
--

CREATE TABLE `s_karnamehs` (
  `id` bigint UNSIGNED NOT NULL,
  `mark` int NOT NULL,
  `karnameh_id` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `dars_id` bigint UNSIGNED NOT NULL,
  `teacher_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `s_mkarnamehs`
--

CREATE TABLE `s_mkarnamehs` (
  `id` bigint UNSIGNED NOT NULL,
  `karnameh_id` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `dars_id` bigint UNSIGNED NOT NULL,
  `teacher_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `mark` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint UNSIGNED NOT NULL,
  `place` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `matlab_id` int NOT NULL,
  `tag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tagvim_s`
--

CREATE TABLE `tagvim_s` (
  `id` bigint NOT NULL,
  `day` int NOT NULL,
  `time` int NOT NULL,
  `class_id` int NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `dars_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tagvim_ts`
--

CREATE TABLE `tagvim_ts` (
  `id` bigint NOT NULL,
  `class_id` int NOT NULL,
  `dars_id` int NOT NULL,
  `day` int NOT NULL,
  `time` int NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `user_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tamrins`
--

CREATE TABLE `tamrins` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `dars` bigint UNSIGNED DEFAULT NULL,
  `class_id` bigint UNSIGNED DEFAULT NULL,
  `filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `original_filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pfilename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `poriginal_filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pmime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `expire` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `time` time DEFAULT NULL,
  `archive` tinyint DEFAULT '0',
  `mark_status` tinyint DEFAULT NULL,
  `mark` int DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tamrins`
--

INSERT INTO `tamrins` (`id`, `title`, `description`, `user_id`, `dars`, `class_id`, `filename`, `mime`, `original_filename`, `pfilename`, `poriginal_filename`, `pmime`, `status`, `expire`, `time`, `archive`, `mark_status`, `mark`, `created_at`, `updated_at`) VALUES
(1, '2', '<p>2</p>', 324357, 1, 100, '1712747492.jpg', 'image/jpeg', '1697004599567.jpg', NULL, NULL, NULL, 0, '1403/01/29', '12:00:00', 0, 0, 20, '1403-01-22', '1403-01-22');

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

--
-- Table structure for table `teachers`
--

CREATE TABLE `teachers` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `dars` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time1` int DEFAULT NULL,
  `time2` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `description` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exam_text` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci,
  `class_link` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `teachers`
--

INSERT INTO `teachers` (`id`, `user_id`, `class_id`, `dars`, `time1`, `time2`, `created_at`, `updated_at`, `description`, `exam_text`, `class_link`) VALUES
(4, 324358, 1, '3', NULL, NULL, '2026-05-30 14:58:19', '2026-05-30 14:58:19', NULL, NULL, NULL),
(5, 324358, 2, '3', NULL, NULL, '2026-05-30 14:58:33', '2026-05-30 14:58:33', NULL, NULL, NULL),
(6, 324358, 2, '4', NULL, NULL, '2026-05-30 14:58:33', '2026-05-30 14:58:33', NULL, NULL, NULL),
(7, 324358, 2, '5', NULL, NULL, '2026-05-30 14:58:33', '2026-05-30 14:58:33', NULL, NULL, NULL);

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

--
-- Table structure for table `teacher_present_dates`
--

CREATE TABLE `teacher_present_dates` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `class_id` bigint UNSIGNED NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `teacher_present_dates`
--

INSERT INTO `teacher_present_dates` (`id`, `user_id`, `class_id`, `created_at`, `updated_at`) VALUES
(1, 324358, 1, '2026-05-30 00:00:00', '2026-05-30 18:31:03');

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

--
-- Table structure for table `teacher_programes`
--

CREATE TABLE `teacher_programes` (
  `id` bigint UNSIGNED NOT NULL,
  `teacher_id` bigint UNSIGNED NOT NULL,
  `day` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `telescope_monitoring`
--

CREATE TABLE `telescope_monitoring` (
  `tag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `template_answare`
--

CREATE TABLE `template_answare` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `template_answare`
--

INSERT INTO `template_answare` (`id`, `title`, `description`, `created_at`, `updated_at`) VALUES
(1, 'ds', 'dsd', '2023-12-29 08:43:54', '2023-12-29 08:43:54');

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

--
-- Table structure for table `template_answare_options`
--

CREATE TABLE `template_answare_options` (
  `id` int UNSIGNED NOT NULL,
  `template_answare_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mark` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `template_answare_options`
--

INSERT INTO `template_answare_options` (`id`, `template_answare_id`, `name`, `mark`, `created_at`, `updated_at`) VALUES
(1, 1, 'محمد', '1', '2023-12-29 08:45:56', '2023-12-29 08:45:56'),
(2, 1, 'e`', '11', '2023-12-29 08:46:04', '2023-12-29 08:46:04');

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

--
-- Table structure for table `template_selections`
--

CREATE TABLE `template_selections` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `template_selections`
--

INSERT INTO `template_selections` (`id`, `title`, `description`, `created_at`, `updated_at`) VALUES
(1, 'test', 't', '2023-12-29 08:39:32', '2023-12-29 08:39:32');

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

--
-- Table structure for table `template_selection_questions`
--

CREATE TABLE `template_selection_questions` (
  `id` int UNSIGNED NOT NULL,
  `template_answare_id` bigint UNSIGNED NOT NULL,
  `template_selection_id` bigint UNSIGNED NOT NULL,
  `body` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `template_selection_questions`
--

INSERT INTO `template_selection_questions` (`id`, `template_answare_id`, `template_selection_id`, `body`, `sort`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'سوال 1', '2', '2023-12-29 08:59:20', '2023-12-29 08:59:20'),
(2, 1, 1, 'سوال 2', '2', '2023-12-29 08:59:20', '2023-12-29 08:59:20'),
(3, 1, 1, 'سوال 2', '2', '2023-12-29 08:59:20', '2023-12-29 08:59:20'),
(4, 1, 1, 'سوال 2', '2', '2023-12-29 08:59:20', '2023-12-29 08:59:20');

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

--
-- Table structure for table `terms`
--

CREATE TABLE `terms` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `terms`
--

INSERT INTO `terms` (`id`, `name`, `label`, `created_at`, `updated_at`) VALUES
(2, 'جدید', 'school_saeed', '2024-02-23 16:43:39', '2024-02-23 16:43:39');

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

--
-- Table structure for table `times`
--

CREATE TABLE `times` (
  `id` bigint NOT NULL,
  `start` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `end` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `times`
--

INSERT INTO `times` (`id`, `start`, `end`, `created_at`, `updated_at`, `name`) VALUES
(1, '7:30', '9', '2023-09-20', '2023-10-08', 'زنگ اول'),
(2, '9:10', '10', '2023-09-20', '2023-09-20', 'زنگ دوم'),
(3, '10:20', '11:10', '2023-09-20', '2023-09-20', 'زنگ سوم'),
(4, '11:30', '12:20', '2023-09-20', '2023-09-20', 'زنگ چهارم');

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

--
-- Table structure for table `total_marks`
--

CREATE TABLE `total_marks` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `coddars` bigint UNSIGNED NOT NULL,
  `codclass` bigint UNSIGNED NOT NULL,
  `totalmark` int NOT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `total_marks`
--

INSERT INTO `total_marks` (`id`, `user_id`, `coddars`, `codclass`, `totalmark`, `created_at`, `updated_at`) VALUES
(1, 326361, 3, 1, 20, '1405-03-09', '1405-03-09'),
(2, 325360, 3, 1, 12, '1405-03-09', '1405-03-09'),
(3, 324359, 3, 1, 20, '1405-03-09', '1405-03-09');

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

--
-- Table structure for table `trusts`
--

CREATE TABLE `trusts` (
  `id` int UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `library_id` bigint UNSIGNED NOT NULL,
  `active` bigint NOT NULL DEFAULT '1' COMMENT 'در دست یوز هست یا تحویل داده؟',
  `count` int NOT NULL COMMENT 'چند بار تمدید کرده',
  `expire` date NOT NULL COMMENT 'تاریخ اتمام فرصت',
  `back` date NOT NULL COMMENT 'تاریخی که کتاب را برگشت داد',
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trusts`
--

INSERT INTO `trusts` (`id`, `user_id`, `library_id`, `active`, `count`, `expire`, `back`, `created_at`, `updated_at`) VALUES
(1, 280310, 2, 1, 0, '1402-07-30', '0000-00-00', '1402-07-16', '1402-07-16');

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

--
-- Table structure for table `tuitions`
--

CREATE TABLE `tuitions` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_id` int NOT NULL,
  `expire` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `codemeli` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NOT NULL,
  `shomarande` bigint DEFAULT NULL,
  `f_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `l_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sex` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paye` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `class` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `sabttime` datetime DEFAULT NULL,
  `mobile` bigint DEFAULT NULL,
  `mobile_father` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `mobile_mother` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password_show` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `level` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int DEFAULT NULL,
  `role` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `original_filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resizeimage` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expire_token` datetime DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `codemeli`, `shomarande`, `f_name`, `l_name`, `fname`, `sex`, `paye`, `class`, `birthday`, `sabttime`, `mobile`, `mobile_father`, `mobile_mother`, `email`, `password`, `password_show`, `level`, `status`, `role`, `mime`, `original_filename`, `resizeimage`, `filename`, `remember_token`, `expire_token`, `created_at`, `updated_at`) VALUES
(1, '1234567890', NULL, 'مدیر', 'سامانه', 'علی', NULL, '', '', NULL, NULL, 9919226131, NULL, NULL, 'saeedhd6@gmail.com', '$2a$12$DHSlN07gSbGgJQnSzFXxgOhZg.ehm830CfIoP1XBzsGgWW3N0QADG', NULL, 'admin', 1, 'مدیر', 'image/png', 'video-img (1).png', '1780208551video-img (1).png', 'php2C61.tmp.png', '9kJFqfpjCcYNWvBKnpMLsAVDB5WJY9LcScKTPuSA011kCBpwX5WH6nVkXlZE', '2026-05-31 10:07:53', NULL, '2026-05-31'),
(324358, '1234567899', NULL, 'محمد', 'مهدوی', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '$2y$10$EpkzCeg7DX3wd9ou3WBRq.pIlDgDhBOGQ72ki.i0a8QcKRJZY4VPq', NULL, NULL, 1, 'معلم', NULL, NULL, NULL, NULL, NULL, '2026-05-30 19:46:36', '2026-05-30', '2026-05-30'),
(324359, '1234566543', NULL, '1234566543', '1234566543', NULL, 'دختر', 'دهم', '1', NULL, '2026-05-30 18:29:52', NULL, NULL, NULL, NULL, '$2y$10$fWjhItPEr9Azd3vNWHQ/8eHwGras5vXSxwa8VzkZnwPwisXJoOTNe', NULL, NULL, 1, 'دانش آموز', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-30', '2026-05-30'),
(325359, '11234566543', NULL, '1234566543', '1234566543', NULL, NULL, 'دهم', '1', NULL, '2026-05-30 18:29:53', NULL, NULL, NULL, NULL, '$2y$10$Kx8af6wtckg/6vypB/cTUuEzeh9PYItinumT5VqzGvT5DvA2QXVJS', NULL, NULL, 1, 'اولیا', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-30', '2026-05-30'),
(325360, '1234566542', NULL, '1234566542', '1234566542', NULL, 'دختر', 'دهم', '1', NULL, '2026-05-30 18:30:22', NULL, NULL, NULL, NULL, '$2y$10$OoLXPkm2k1Ww9xYO.NrQreNdeMIIdtDjVC3Dd.u/C/zQu2NdIy0by', NULL, NULL, 1, 'دانش آموز', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-30', '2026-05-30'),
(326360, '11234566542', NULL, '1234566542', '1234566542', NULL, NULL, 'دهم', '1', NULL, '2026-05-30 18:30:22', NULL, NULL, NULL, NULL, '$2y$10$7Ohwj0n9EiOmb0ViKtNSnectD7UitsuJsDSv20EfO96pdpkcK8dMy', NULL, NULL, 1, 'اولیا', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-30', '2026-05-30'),
(326361, '1234566541', NULL, '1234566541', '1234566541', NULL, 'دختر', 'دهم', '1', NULL, '2026-05-30 18:30:40', NULL, NULL, NULL, NULL, '$2y$10$Cclyb6kk4/AYin1pNYt31uQ4YMQXOq/mkgCckMXsBhhfwjLOX/waK', NULL, NULL, 1, 'دانش آموز', NULL, NULL, NULL, NULL, NULL, '2026-05-30 19:31:38', '2026-05-30', '2026-05-30'),
(327361, '11234566541', NULL, '1234566541', '1234566541', NULL, NULL, 'دهم', '1', NULL, '2026-05-30 18:30:40', NULL, NULL, NULL, NULL, '$2y$10$VVmWuI9n4T.ZXC2mBOgeredfnReSiaCWVgcxqG26NNwdJKqX7k23q', NULL, NULL, 1, 'اولیا', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-30', '2026-05-30'),
(327362, '1234566540', NULL, '1234566540', '1234566540', NULL, 'دختر', 'دهم', '2', NULL, '2026-05-30 18:30:57', NULL, NULL, NULL, NULL, '$2y$10$mreSpOXc8D4xATwci1AJV.DXQ6AO04dcJosklP2iuC9RA3I5B0vpG', NULL, NULL, 1, 'دانش آموز', 'image/png', 'logo-white (1).png', '1780154903logo-white (1).png', 'php94E6.tmp.png', NULL, '2026-05-30 19:28:38', '2026-05-30', '2026-05-30'),
(328362, '11234566540', NULL, '1234566541', '1234566540', NULL, NULL, 'دهم', '2', NULL, '2026-05-30 18:30:57', NULL, NULL, NULL, NULL, '$2y$10$O5IJoLDwhrYmKnoPtDLX3eArdNMmFxWImmI3hB.y7tvAhGzoNq6XO', NULL, NULL, 1, 'اولیا', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-30', '2026-05-30'),
(328363, '1620983672', NULL, 'محمد', 'حسینی', 'ابراهیم', '1', 'یازدهم', '112', NULL, NULL, NULL, NULL, NULL, '', '$2y$10$FoQpMBjyoeDQQlJk2feIA.16WNShIC4jKMBAv0qqZROwcQA1x7F.y', NULL, '', 1, 'دانش آموز', NULL, NULL, NULL, NULL, NULL, NULL, '1405-03-09', '1405-03-09'),
(329363, '11620983672', NULL, 'ابراهیم', 'حسینی', NULL, NULL, 'یازدهم', '112', NULL, NULL, NULL, NULL, NULL, NULL, '$2y$10$h2.0CgDGu/peSDs0T8ueie5JYt5FbxTmcZi7H4TZVrcgg5ztC7LI2', NULL, NULL, 1, 'اولیا', NULL, NULL, NULL, NULL, NULL, NULL, '1405-03-09', '1405-03-09'),
(329364, '1620983671', NULL, 'محمد', 'حسینی', 'ابراهیم', '1', 'یازدهم', '112', NULL, NULL, NULL, NULL, NULL, '', '$2y$10$4Bysm5WhpmdJSULw3Q/O6uqNlb5ZwCwX9IMbhHkSq0hunz5Elo55m', NULL, '', 1, 'دانش آموز', NULL, NULL, NULL, NULL, NULL, NULL, '1405-03-09', '1405-03-09'),
(330364, '11620983671', NULL, 'ابراهیم', 'حسینی', NULL, NULL, 'یازدهم', '112', NULL, NULL, NULL, NULL, NULL, NULL, '$2y$10$7L6ziKejtBhEEr.DESbhHOjLDIpOFSuBM99hUGRRirBN7yGnHZOw.', NULL, NULL, 1, 'اولیا', NULL, NULL, NULL, NULL, NULL, NULL, '1405-03-09', '1405-03-09'),
(330365, '1620983670', NULL, 'محمد', 'حسینی', 'ابراهیم', '1', 'یازدهم', '112', NULL, NULL, NULL, NULL, NULL, '', '$2y$10$HxHXqYK42LnJqfkQhYG8uOUJMKT3Lc4XVQxZP9GSD2icF/UVAFOzK', NULL, '', 1, 'دانش آموز', NULL, NULL, NULL, NULL, NULL, NULL, '1405-03-09', '1405-03-09'),
(331365, '11620983670', NULL, 'ابراهیم', 'حسینی', NULL, NULL, 'یازدهم', '112', NULL, NULL, NULL, NULL, NULL, NULL, '$2y$10$vwZP4RPSLvAXq7mb5eQC7.72FjZpIRy2KwTdw4OCfZv6xJEpLDBX.', NULL, NULL, 1, 'اولیا', NULL, NULL, NULL, NULL, NULL, NULL, '1405-03-09', '1405-03-09'),
(331366, '1620983679', NULL, 'محمد', 'حسینی', 'ابراهیم', '1', 'یازدهم', '112', NULL, NULL, NULL, NULL, NULL, '', '$2y$10$/sa4gqOgKJPCjK8NcLbndOF4JYusvLbrpGCpd6xs3z6xVNhCRPR2m', NULL, '', 1, 'دانش آموز', NULL, NULL, NULL, NULL, NULL, NULL, '1405-03-09', '1405-03-09'),
(332366, '11620983679', NULL, 'ابراهیم', 'حسینی', NULL, NULL, 'یازدهم', '112', NULL, NULL, NULL, NULL, NULL, NULL, '$2y$10$h4EXMCDVZ7CkAbJ6Jb.qe.VWTGjpSMSVHhOwP4F5N0fW2k7j0uhWu', NULL, NULL, 1, 'اولیا', NULL, NULL, NULL, NULL, NULL, NULL, '1405-03-09', '1405-03-09');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activation_codes`
--
ALTER TABLE `activation_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `activation_codes_user_id_foreign` (`user_id`);

--
-- Indexes for table `address_models`
--
ALTER TABLE `address_models`
  ADD PRIMARY KEY (`id`),
  ADD KEY `address_models_home_id_foreign` (`home_id`);

--
-- Indexes for table `answers`
--
ALTER TABLE `answers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `answers_user_id_foreign` (`user_id`);

--
-- Indexes for table `archives`
--
ALTER TABLE `archives`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

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

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

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

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

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

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

--
-- Indexes for table `comment_moshavers`
--
ALTER TABLE `comment_moshavers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `moshavers_id` (`moshavers_id`);

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

--
-- Indexes for table `c_karnamehs`
--
ALTER TABLE `c_karnamehs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `c_karnamehs_id_karnameh_foreign` (`id_karnameh`),
  ADD KEY `c_karnamehs_dars_id_foreign` (`dars_id`),
  ADD KEY `c_karnamehs_item_id_foreign` (`item_id`);

--
-- Indexes for table `c_marks`
--
ALTER TABLE `c_marks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `c_marks_user_id_foreign` (`user_id`),
  ADD KEY `c_marks_dars_id_foreign` (`dars`);

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

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

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

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

--
-- Indexes for table `disciplines`
--
ALTER TABLE `disciplines`
  ADD PRIMARY KEY (`id`),
  ADD KEY `disciplines_user_id_foreign` (`user_id`),
  ADD KEY `disciplines_disciplines_id_foreign` (`disciplines_id`);

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

--
-- Indexes for table `exam_answerss`
--
ALTER TABLE `exam_answerss`
  ADD PRIMARY KEY (`id`),
  ADD KEY `question_id` (`question_id`),
  ADD KEY `user_id` (`user_id`);

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

--
-- Indexes for table `exam_histories`
--
ALTER TABLE `exam_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `exam_id` (`exam_id`),
  ADD KEY `user_id` (`user_id`);

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

--
-- Indexes for table `exam_questions`
--
ALTER TABLE `exam_questions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `exam_questions_exam_id_foreign` (`exam_id`);

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

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

--
-- Indexes for table `farhang_tuition_installments`
--
ALTER TABLE `farhang_tuition_installments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `farhang_tuition_installments_installments_types_id_foreign` (`installments_types_id`);

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

--
-- Indexes for table `farhang_tuition_payments`
--
ALTER TABLE `farhang_tuition_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `farhang_tuition_payments_user_id_foreign` (`user_id`),
  ADD KEY `farhang_tuition_payments_created_by_foreign` (`created_by`);

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

--
-- Indexes for table `films`
--
ALTER TABLE `films`
  ADD PRIMARY KEY (`id`),
  ADD KEY `films_class_id_foreign` (`class_id`),
  ADD KEY `films_user_id_foreign` (`user_id`);

--
-- Indexes for table `film_download`
--
ALTER TABLE `film_download`
  ADD PRIMARY KEY (`id`),
  ADD KEY `film_download_film_id_foreign` (`film_id`),
  ADD KEY `film_download_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `finanaces`
--
ALTER TABLE `finanaces`
  ADD PRIMARY KEY (`id`),
  ADD KEY `finanaces_user_id_foreign` (`user_id`);

--
-- Indexes for table `fines`
--
ALTER TABLE `fines`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fines_user_id_foreign` (`user_id`),
  ADD KEY `fines_library_id_foreign` (`library_id`);

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

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

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

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

--
-- Indexes for table `form_responses`
--
ALTER TABLE `form_responses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `form_responses_user_id_foreign` (`user_id`);

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

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

--
-- Indexes for table `hamayesh_memebers`
--
ALTER TABLE `hamayesh_memebers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hamayesh_memebers_hamayesh_id_foreign` (`hamayesh_id`),
  ADD KEY `hamayesh_memebers_user_id_foreign` (`user_id`);

--
-- Indexes for table `homes`
--
ALTER TABLE `homes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `homes_user_id_foreign` (`user_id`);

--
-- Indexes for table `home_images`
--
ALTER TABLE `home_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `home_images_matlab_id_foreign` (`matlab_id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `j_tamrins`
--
ALTER TABLE `j_tamrins`
  ADD PRIMARY KEY (`id`),
  ADD KEY `j_tamrins_user_id_foreign` (`user_id`),
  ADD KEY `j_tamrins_teacher_id_foreign` (`teacher_id`),
  ADD KEY `j_tamrins_tamrin_id_foreign` (`tamrin_id`);

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

--
-- Indexes for table `libraries`
--
ALTER TABLE `libraries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `libraries_issue_unique` (`issue`);

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

--
-- Indexes for table `log_finanaces`
--
ALTER TABLE `log_finanaces`
  ADD PRIMARY KEY (`id`),
  ADD KEY `log_finanaces_user_id_foreign` (`user_id`);

--
-- Indexes for table `mail_models`
--
ALTER TABLE `mail_models`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mail_models_user_id_foreign` (`user_id`);

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

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

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

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

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

--
-- Indexes for table `mark_items`
--
ALTER TABLE `mark_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mark_items_user_id_foreign` (`user_id`),
  ADD KEY `mark_items_item_id_foreign` (`item_id`);

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

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

--
-- Indexes for table `message_reseivers`
--
ALTER TABLE `message_reseivers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `message_reseivers_mail_id_foreign` (`mail_id`),
  ADD KEY `message_reseivers_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `moshavers`
--
ALTER TABLE `moshavers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

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

--
-- Indexes for table `myexams`
--
ALTER TABLE `myexams`
  ADD PRIMARY KEY (`id`),
  ADD KEY `myexams_author_foreign` (`author`);

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

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

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

--
-- Indexes for table `onlinelists`
--
ALTER TABLE `onlinelists`
  ADD PRIMARY KEY (`id`),
  ADD KEY `onlinelists_user_id_foreign` (`user_id`),
  ADD KEY `onlinelists_class_id_foreign` (`class_id`);

--
-- Indexes for table `online_classes`
--
ALTER TABLE `online_classes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `online_classes_author_foreign` (`author`);

--
-- Indexes for table `options`
--
ALTER TABLE `options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `options_question_id_foreign` (`question_id`);

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

--
-- Indexes for table `parents`
--
ALTER TABLE `parents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parents_user_id_foreign` (`user_id`),
  ADD KEY `parents_student_id_foreign` (`student_id`);

--
-- Indexes for table `pasokh_teachers`
--
ALTER TABLE `pasokh_teachers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pasokh_teachers_tamrin_id_foreign` (`tamrin_id`),
  ADD KEY `pasokh_teachers_teacher_id_foreign` (`teacher_id`);

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

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

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

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

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

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

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payments_user_id_foreign` (`user_id`),
  ADD KEY `payments_gateway_id_foreign` (`gateway_id`);

--
-- Indexes for table `pay_tuitions`
--
ALTER TABLE `pay_tuitions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pay_tuitions_user_id_foreign` (`user_id`),
  ADD KEY `pay_tuitions_tuitions_id_foreign` (`tuition_id`),
  ADD KEY `pay_tuitions_class_id_foreign` (`class_id`);

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

--
-- Indexes for table `portfolio_details`
--
ALTER TABLE `portfolio_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `portfolio_details_home_id_foreign` (`home_id`);

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

--
-- Indexes for table `p_answers`
--
ALTER TABLE `p_answers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `p_answers_user_id_foreign` (`user_id`),
  ADD KEY `p_answers_answer_id_foreign` (`answer_id`);

--
-- Indexes for table `p_comments`
--
ALTER TABLE `p_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `p_comments_comment_id_foreign` (`comment_id`);

--
-- Indexes for table `questions`
--
ALTER TABLE `questions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `questions_user_id_foreign` (`user_id`);

--
-- Indexes for table `reservations`
--
ALTER TABLE `reservations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reservations_user_id_foreign` (`user_id`),
  ADD KEY `reservations_library_id_foreign` (`library_id`);

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

--
-- Indexes for table `roll_calls`
--
ALTER TABLE `roll_calls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `roll_calls_user_id_foreign` (`user_id`),
  ADD KEY `roll_calls_class_id_foreign` (`class_id`);

--
-- Indexes for table `roll_call_moshavers`
--
ALTER TABLE `roll_call_moshavers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `moshavers_id` (`moshavers_id`);

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

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

--
-- Indexes for table `selectionss`
--
ALTER TABLE `selectionss`
  ADD PRIMARY KEY (`id`),
  ADD KEY `selectionss_selection_items_id_foreign` (`selection_items_id`);

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

--
-- Indexes for table `selection_members`
--
ALTER TABLE `selection_members`
  ADD PRIMARY KEY (`id`),
  ADD KEY `selection_members_user_id_foreign` (`user_id`),
  ADD KEY `selection_members_selection_id_foreign` (`selection_id`);

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

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

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

--
-- Indexes for table `students`
--
ALTER TABLE `students`
  ADD PRIMARY KEY (`id`),
  ADD KEY `students_user_id_foreign` (`user_id`);

--
-- Indexes for table `s_karnamehs`
--
ALTER TABLE `s_karnamehs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `s_karnamehs_karnameh_id_foreign` (`karnameh_id`),
  ADD KEY `s_karnamehs_class_id_foreign` (`class_id`),
  ADD KEY `s_karnamehs_dars_id_foreign` (`dars_id`),
  ADD KEY `s_karnamehs_teacher_id_foreign` (`teacher_id`),
  ADD KEY `s_karnamehs_user_id_foreign` (`user_id`);

--
-- Indexes for table `s_mkarnamehs`
--
ALTER TABLE `s_mkarnamehs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `s_mkarnamehs_karnameh_id_foreign` (`karnameh_id`),
  ADD KEY `s_mkarnamehs_class_id_foreign` (`class_id`),
  ADD KEY `s_mkarnamehs_dars_id_foreign` (`dars_id`),
  ADD KEY `s_mkarnamehs_teacher_id_foreign` (`teacher_id`),
  ADD KEY `s_mkarnamehs_user_id_foreign` (`user_id`);

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

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

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

--
-- Indexes for table `tamrins`
--
ALTER TABLE `tamrins`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tamrins_user_id_foreign` (`user_id`),
  ADD KEY `tamrins_dars_foreign` (`dars`);

--
-- Indexes for table `teachers`
--
ALTER TABLE `teachers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `teachers_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `teacher_programes`
--
ALTER TABLE `teacher_programes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `teacher_programes_teacher_id_foreign` (`teacher_id`);

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

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

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

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

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

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

--
-- Indexes for table `total_marks`
--
ALTER TABLE `total_marks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `total_marks_user_id_foreign` (`user_id`),
  ADD KEY `total_marks_coddars_foreign` (`coddars`);

--
-- Indexes for table `trusts`
--
ALTER TABLE `trusts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `trusts_user_id_foreign` (`user_id`),
  ADD KEY `trusts_library_id_foreign` (`library_id`);

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_codemeli_unique` (`codemeli`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activation_codes`
--
ALTER TABLE `activation_codes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `address_models`
--
ALTER TABLE `address_models`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `answers`
--
ALTER TABLE `answers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `archives`
--
ALTER TABLE `archives`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `barnamehs`
--
ALTER TABLE `barnamehs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `block_class_users`
--
ALTER TABLE `block_class_users`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `challenges`
--
ALTER TABLE `challenges`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `clas`
--
ALTER TABLE `clas`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `comment_moshavers`
--
ALTER TABLE `comment_moshavers`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `c_disciplines`
--
ALTER TABLE `c_disciplines`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `c_karnamehs`
--
ALTER TABLE `c_karnamehs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `c_marks`
--
ALTER TABLE `c_marks`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `c_tags`
--
ALTER TABLE `c_tags`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `daftars`
--
ALTER TABLE `daftars`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `dars`
--
ALTER TABLE `dars`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `days`
--
ALTER TABLE `days`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `disciplines`
--
ALTER TABLE `disciplines`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dumps`
--
ALTER TABLE `dumps`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `exam_answerss`
--
ALTER TABLE `exam_answerss`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `exam_classes`
--
ALTER TABLE `exam_classes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `exam_histories`
--
ALTER TABLE `exam_histories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `exam_marks`
--
ALTER TABLE `exam_marks`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `exam_questions`
--
ALTER TABLE `exam_questions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `exam_randoms`
--
ALTER TABLE `exam_randoms`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `farhang_tuition_configs`
--
ALTER TABLE `farhang_tuition_configs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `farhang_tuition_installments`
--
ALTER TABLE `farhang_tuition_installments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `farhang_tuition_installments_types`
--
ALTER TABLE `farhang_tuition_installments_types`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `farhang_tuition_payments`
--
ALTER TABLE `farhang_tuition_payments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `file_moshavers`
--
ALTER TABLE `file_moshavers`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `films`
--
ALTER TABLE `films`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `film_download`
--
ALTER TABLE `film_download`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `film_sections`
--
ALTER TABLE `film_sections`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `finanaces`
--
ALTER TABLE `finanaces`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fines`
--
ALTER TABLE `fines`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `finish_exams`
--
ALTER TABLE `finish_exams`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `first_messages`
--
ALTER TABLE `first_messages`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `forms`
--
ALTER TABLE `forms`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `form_questions`
--
ALTER TABLE `form_questions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `form_responses`
--
ALTER TABLE `form_responses`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gateways`
--
ALTER TABLE `gateways`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `hamayeshes`
--
ALTER TABLE `hamayeshes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hamayesh_memebers`
--
ALTER TABLE `hamayesh_memebers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `homes`
--
ALTER TABLE `homes`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

--
-- AUTO_INCREMENT for table `home_images`
--
ALTER TABLE `home_images`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jtamrin_files`
--
ALTER TABLE `jtamrin_files`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `j_tamrins`
--
ALTER TABLE `j_tamrins`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `karnameh_admins`
--
ALTER TABLE `karnameh_admins`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `libraries`
--
ALTER TABLE `libraries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `log_activities`
--
ALTER TABLE `log_activities`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `log_finanaces`
--
ALTER TABLE `log_finanaces`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mail_models`
--
ALTER TABLE `mail_models`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `main_karnameh_schools`
--
ALTER TABLE `main_karnameh_schools`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `main_pagees`
--
ALTER TABLE `main_pagees`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `main_pages`
--
ALTER TABLE `main_pages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `manager_home_works`
--
ALTER TABLE `manager_home_works`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `manager_home_work_responses`
--
ALTER TABLE `manager_home_work_responses`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `mark_items`
--
ALTER TABLE `mark_items`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `meeting_users`
--
ALTER TABLE `meeting_users`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meet_requests`
--
ALTER TABLE `meet_requests`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `message_reseivers`
--
ALTER TABLE `message_reseivers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=143;

--
-- AUTO_INCREMENT for table `moshavers`
--
ALTER TABLE `moshavers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `moshaver_sabts`
--
ALTER TABLE `moshaver_sabts`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `myexams`
--
ALTER TABLE `myexams`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `new_selections`
--
ALTER TABLE `new_selections`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `new_selection_responses`
--
ALTER TABLE `new_selection_responses`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `new_selection_teachers`
--
ALTER TABLE `new_selection_teachers`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `onlinelists`
--
ALTER TABLE `onlinelists`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `online_classes`
--
ALTER TABLE `online_classes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6722807;

--
-- AUTO_INCREMENT for table `options`
--
ALTER TABLE `options`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `option_images`
--
ALTER TABLE `option_images`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `parents`
--
ALTER TABLE `parents`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `pasokh_teachers`
--
ALTER TABLE `pasokh_teachers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `patterns`
--
ALTER TABLE `patterns`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pattern_items`
--
ALTER TABLE `pattern_items`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pattern_item_answers`
--
ALTER TABLE `pattern_item_answers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pattern_memeber_blocks`
--
ALTER TABLE `pattern_memeber_blocks`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pattern_statuses`
--
ALTER TABLE `pattern_statuses`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `payes`
--
ALTER TABLE `payes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `pay_tuitions`
--
ALTER TABLE `pay_tuitions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `portfolio_details`
--
ALTER TABLE `portfolio_details`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pre_registrations`
--
ALTER TABLE `pre_registrations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `p_answers`
--
ALTER TABLE `p_answers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `p_comments`
--
ALTER TABLE `p_comments`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `questions`
--
ALTER TABLE `questions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reservations`
--
ALTER TABLE `reservations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `roll_calls`
--
ALTER TABLE `roll_calls`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `roll_call_moshavers`
--
ALTER TABLE `roll_call_moshavers`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `r_karnamehs`
--
ALTER TABLE `r_karnamehs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `r_tamas`
--
ALTER TABLE `r_tamas`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `selectionss`
--
ALTER TABLE `selectionss`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `selection_members`
--
ALTER TABLE `selection_members`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `selection_optionss`
--
ALTER TABLE `selection_optionss`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `setting`
--
ALTER TABLE `setting`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `slide_classes`
--
ALTER TABLE `slide_classes`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `students`
--
ALTER TABLE `students`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `s_karnamehs`
--
ALTER TABLE `s_karnamehs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `s_mkarnamehs`
--
ALTER TABLE `s_mkarnamehs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tags`
--
ALTER TABLE `tags`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tagvim_s`
--
ALTER TABLE `tagvim_s`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tagvim_ts`
--
ALTER TABLE `tagvim_ts`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tamrins`
--
ALTER TABLE `tamrins`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `teachers`
--
ALTER TABLE `teachers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `teacher_present_dates`
--
ALTER TABLE `teacher_present_dates`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `teacher_programes`
--
ALTER TABLE `teacher_programes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `template_answare`
--
ALTER TABLE `template_answare`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `template_answare_options`
--
ALTER TABLE `template_answare_options`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `template_selections`
--
ALTER TABLE `template_selections`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `template_selection_questions`
--
ALTER TABLE `template_selection_questions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `terms`
--
ALTER TABLE `terms`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `times`
--
ALTER TABLE `times`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `total_marks`
--
ALTER TABLE `total_marks`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `trusts`
--
ALTER TABLE `trusts`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tuitions`
--
ALTER TABLE `tuitions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=332367;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `form_responses`
--
ALTER TABLE `form_responses`
  ADD CONSTRAINT `form_responses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `hamayesh_memebers`
--
ALTER TABLE `hamayesh_memebers`
  ADD CONSTRAINT `hamayesh_memebers_hamayesh_id_foreign` FOREIGN KEY (`hamayesh_id`) REFERENCES `hamayeshes` (`id`),
  ADD CONSTRAINT `hamayesh_memebers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `onlinelists`
--
ALTER TABLE `onlinelists`
  ADD CONSTRAINT `onlinelists_class_id_foreign` FOREIGN KEY (`class_id`) REFERENCES `online_classes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `onlinelists_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `online_classes`
--
ALTER TABLE `online_classes`
  ADD CONSTRAINT `online_classes_author_foreign` FOREIGN KEY (`author`) REFERENCES `users` (`id`) ON DELETE 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 */;