| Server IP : 45.94.215.241 / Your IP : 216.73.216.243 Web Server : Apache/2.4.66 (Ubuntu) System : Linux srv2937474766 7.0.0-28-generic #28-Ubuntu SMP PREEMPT_DYNAMIC Sun Jun 21 01:01:36 UTC 2026 x86_64 User : www-data ( 33) PHP Version : 8.5.4 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/final/ |
Upload File : |
/*M!999999\- enable the sandbox mode */
-- MariaDB dump 10.19 Distrib 10.11.14-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: nikooacademy_lms_db
-- ------------------------------------------------------
-- Server version 10.11.14-MariaDB-0ubuntu0.24.04.1
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `buyers`
--
DROP TABLE IF EXISTS `buyers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `buyers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`firstname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`lastname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`tel` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`mobile` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`operator_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `buyers`
--
LOCK TABLES `buyers` WRITE;
/*!40000 ALTER TABLE `buyers` DISABLE KEYS */;
/*!40000 ALTER TABLE `buyers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `certificates`
--
DROP TABLE IF EXISTS `certificates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `certificates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` char(100) DEFAULT NULL,
`course_id` int(11) DEFAULT NULL,
`student_id` int(11) DEFAULT NULL,
`issue_date` char(10) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_key_certificates_student_id_course_id` (`course_id`,`student_id`),
KEY `unique_key_certificates_uid` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `certificates`
--
LOCK TABLES `certificates` WRITE;
/*!40000 ALTER TABLE `certificates` DISABLE KEYS */;
INSERT INTO `certificates` VALUES
(1,'0f04fbfa-faed-11ec-92cd-000c297e5bdb',1014,166,'2022-06-30'),
(3,'eaeca007-faf5-11ec-92cd-000c297e5bdb',1002,141,'2022-05-02'),
(4,'eaeca6f4-faf5-11ec-92cd-000c297e5bdb',1002,147,'2022-05-02'),
(5,'fdfeb5fa-faf5-11ec-92cd-000c297e5bdb',1002,149,'2022-05-02'),
(6,'f30cde5f-fb00-11ec-92cd-000c297e5bdb',1012,165,'2022-05-02'),
(7,'e7d15cc7-0106-11ed-92cd-000c297e5bdb',1017,141,'2022-07-11'),
(8,'055688cd-0b32-11ed-aba2-000c297e5bdb',1016,169,'2022-07-11'),
(9,'0a72100f-0b32-11ed-aba2-000c297e5bdb',1016,171,'2022-07-11'),
(11,'09f9f9f2-4ca6-11ed-a3ec-040300000000',1026,183,'2022-08-04'),
(12,'546da152-4ca8-11ed-a3ec-040300000000',1031,169,'2021-08-06'),
(13,'5ad8c8d1-4ca8-11ed-a3ec-040300000000',1031,170,'2021-08-06'),
(14,'5fd8ebb2-4ca8-11ed-a3ec-040300000000',1032,169,'2021-09-22'),
(15,'655f544d-4ca8-11ed-a3ec-040300000000',1032,170,'2021-09-22'),
(16,'b81f199a-e113-11ed-9434-040300000000',1013,157,'2022-12-15'),
(17,'d1a6b4cd-e415-11ed-9434-040300000000',1003,134,'2022-01-31'),
(18,'d5a44ffd-e41f-11ed-9434-040300000000',1020,134,'2022-12-01'),
(30,'5f401cec-e509-11ed-9434-040300000000',1016,173,'2023-04-27'),
(31,'540f5c1c-1e34-11ee-9dd6-040300000000',1044,141,'2023-07-09'),
(32,'daa2f818-2b18-11ee-b7d7-040300000000',1046,200,'2023-07-25'),
(33,'30ec0cbe-717c-11ee-a271-040300000000',1047,201,'2023-10-23'),
(34,'30ed382a-717c-11ee-a271-040300000000',1047,203,'2023-10-23'),
(35,'4c41268b-d91e-11ee-b9c0-040300000000',1048,203,'2024-03-03'),
(36,'4c425322-d91e-11ee-b9c0-040300000000',1048,204,'2024-03-03'),
(37,'328d2c4b-eac7-11ee-af6a-040300000000',1019,178,'2024-03-25'),
(38,'d349fab0-90a0-11ef-b3fd-005056884f1d',1052,198,'2024-10-22'),
(39,'d34a6617-90a0-11ef-b3fd-005056884f1d',1052,199,'2024-10-22'),
(40,'d34a9235-90a0-11ef-b3fd-005056884f1d',1052,200,'2024-10-22');
/*!40000 ALTER TABLE `certificates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `courses`
--
DROP TABLE IF EXISTS `courses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `courses` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`category_id` int(11) DEFAULT NULL,
`teacher_id` int(11) DEFAULT NULL,
`title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`tuition_fee` int(11) DEFAULT NULL,
`tuition_fee_session` int(11) DEFAULT NULL,
`discount_rate` int(255) DEFAULT 0,
`start_date` char(10) DEFAULT NULL,
`finish_date` char(10) DEFAULT NULL,
`course_duration` int(10) DEFAULT NULL,
`session_no` int(11) DEFAULT NULL,
`teacher_tuition_share` int(11) DEFAULT 30,
`course_owner_tuition_share` int(11) DEFAULT NULL,
`certificate_tuition_share` int(11) DEFAULT NULL,
`academy_tuition_share` int(11) DEFAULT NULL,
`moodle_course_id` int(11) DEFAULT NULL,
`course_status` int(11) DEFAULT 1 COMMENT '1 = active | 0 = inactive',
PRIMARY KEY (`id`),
KEY `category_id` (`category_id`),
KEY `teacher_id` (`teacher_id`),
CONSTRAINT `courses_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `courses_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `courses_ibfk_2` FOREIGN KEY (`teacher_id`) REFERENCES `teachers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1057 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `courses`
--
LOCK TABLES `courses` WRITE;
/*!40000 ALTER TABLE `courses` DISABLE KEYS */;
INSERT INTO `courses` VALUES
(1002,12,10,'Python مقدماتی - کد دوره:1002',20000000,2000000,100,'1400-11-10','',40,10,30,6,NULL,NULL,6,0),
(1003,10,10,'SQL Statement (With MySQL) - کد دوره:1003',30000000,3000000,100,'1400-11-01','',40,10,30,4,NULL,NULL,4,1),
(1012,12,10,'Python مقدماتی - کد دوره:1012',24000000,0,0,'1400-12-18','',30,10,0,0,0,100,17,0),
(1013,12,10,'Python مقدماتی - کد دوره:1013',24000000,2000000,100,'1401-01-07','',30,10,20,20,27,NULL,18,1),
(1014,12,10,'Python مقدماتی - کد دوره:1014',24000000,0,0,'1401-01-15','',30,10,20,20,27,NULL,19,1),
(1015,12,10,'Python مقدماتی - کد دوره:1015',24000000,0,0,'','',30,10,20,20,27,NULL,20,1),
(1016,12,10,'Python مقدماتی - کد دوره:1016',24000000,0,100,'1401-01-26','',30,10,20,20,27,NULL,21,1),
(1017,37,10,'Python پیشرفته - کد دوره:1017',30000000,0,100,'','',30,10,20,20,27,NULL,23,1),
(1019,10,10,'SQL Statement (With MySQL) - کد دوره:1019',15000000,0,100,'1401-03-03','',15,5,20,20,27,NULL,25,1),
(1020,12,10,'Python مقدماتی - کد دوره:1020',24000000,2000000,0,'1401-03-17','',30,10,0,0,0,100,26,1),
(1024,63,10,'Python مقدماتی - کد دوره:1024',24000000,0,100,'1401-03-28','',30,10,20,20,27,NULL,29,1),
(1025,63,10,'Python مقدماتی - کد دوره:1025',24000000,0,100,'1401-03-29','',30,10,20,20,27,NULL,30,1),
(1026,12,10,'Python مقدماتی - کد دوره:1026',24000000,0,100,'1401-04-10','',30,10,20,20,0,NULL,31,1),
(1029,69,10,'لینوکس مقدماتی - کد دوره:1029',0,0,0,'','',0,0,0,0,0,NULL,34,1),
(1031,71,10,'Scratch مقدماتی - کد دوره:1031',0,0,0,'','',0,0,0,0,0,NULL,43,1),
(1032,72,10,'Scratch پیشرفته - کد دوره:1032',0,0,0,'','',0,0,0,0,0,NULL,44,1),
(1037,12,10,'Python مقدماتی - کد دوره:1037',24000000,0,100,'1401-11-13','',30,10,20,20,27,NULL,41,1),
(1038,73,10,'Oracle Database Administration Workshop I - کد دوره:1038',50000000,0,100,'','',40,10,25,25,25,NULL,42,1),
(1044,10,10,'SQL Statement مقدماتی - کد دوره:1044',15000000,3000000,100,'1402-03-21','',15,5,20,20,27,NULL,49,1),
(1046,67,10,'طراحی وب مقدماتی - کد دوره:1046',20000000,0,0,'1401-01-29','1402-01-29',20,10,0,0,27,NULL,NULL,1),
(1047,12,10,'SQL Statement مقدماتی - کد دوره:1047',24000000,2000000,100,'1402-05-22','1402-06-21',30,10,20,20,27,NULL,51,1),
(1048,12,10,'Python مقدماتی - کد دوره:1048',24000000,2000000,100,'1402-08-22','',30,10,20,20,27,NULL,52,1),
(1052,12,10,'Python مقدماتی - کد دوره:1052',24000000,0,100,'1403-02-17','',30,10,20,20,27,NULL,55,1),
(1056,12,10,'Python مقدماتی - کد دوره:1056',0,0,0,'1404-09-01','1404-10-30',20,10,0,0,0,NULL,60,1);
/*!40000 ALTER TABLE `courses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `courses_categories`
--
DROP TABLE IF EXISTS `courses_categories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `courses_categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`title_en` varchar(100) DEFAULT NULL,
`parent_id` int(11) DEFAULT NULL,
`tuition_fee` int(11) DEFAULT NULL,
`tuition_fee_session` int(11) DEFAULT NULL,
`course_duration` int(11) DEFAULT NULL,
`teacher_tuition_share` int(11) DEFAULT NULL,
`course_owner_tuition_share` int(11) DEFAULT NULL,
`certificate_tuition_share` int(11) DEFAULT NULL,
`academy_tuition_share` int(11) DEFAULT NULL,
`session_no` int(11) DEFAULT NULL,
`moodle_shortname_pattern` varchar(100) DEFAULT NULL,
`moodle_category_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `courses_categories`
--
LOCK TABLES `courses_categories` WRITE;
/*!40000 ALTER TABLE `courses_categories` DISABLE KEYS */;
INSERT INTO `courses_categories` VALUES
(2,'برنامه نویسی',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2),
(3,'C++ مقدماتی','C++ Programming (Basic)',2,21000000,1500000,30,20,20,27,33,10,'c++_basic',3),
(4,'شبکه',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4),
(6,'امنیت',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6),
(7,'دیتابیس',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7),
(9,'سایر',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,9),
(10,'SQL Statement مقدماتی','SQL Statement (Basic)',7,15000000,3000000,15,20,20,27,33,5,'sql_statement_basic',10),
(12,'Python مقدماتی','Python Programming (Basic)',2,24000000,2000000,30,20,20,27,33,10,'python_basic',12),
(36,'C++ پیشرفته','C++ Programming (Advanced)',2,27000000,2000000,30,20,20,27,33,10,'c++_advanced',36),
(37,'Python پیشرفته','Python Programming (Advanced)',2,30000000,3000000,30,20,20,27,33,10,'python_advanced',37),
(38,'مفاهیم فناوری اطلاعات',NULL,9,10000000,0,4,20,20,27,33,5,'IT_Basics',38),
(39,'ویژه کودکان (پیش دبستانی تا دوم ابتدایی)',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,39),
(40,'ویژه کودکان (سوم تا ششم ابتدایی)',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,40),
(41,'ویژه کودکان (متوسطه)',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,41),
(42,'Scratch Junior 1',NULL,39,NULL,NULL,NULL,30,30,27,13,NULL,'scratch_junior_1',42),
(43,'Scratch Junior 2',NULL,39,NULL,NULL,NULL,30,30,27,13,NULL,'scratch_junior_2',43),
(44,'Scratch Junior',NULL,40,NULL,NULL,NULL,30,30,27,13,NULL,'scratch_junior_1',44),
(45,'Scratch مقدماتی',NULL,40,5000000,NULL,10,30,30,27,13,10,'scratch_basic',45),
(46,'Scratch پیشرفته',NULL,40,5000000,NULL,10,30,30,27,13,10,'scratch_advanced',46),
(47,'Scratch حرفه ای',NULL,40,5000000,NULL,10,30,30,27,13,10,'scratch_professional',47),
(48,'LEGO 1',NULL,40,NULL,NULL,NULL,30,30,27,13,NULL,NULL,48),
(49,'LEGO 2',NULL,40,NULL,NULL,NULL,30,30,27,13,NULL,NULL,49),
(50,'روباتیک مقدماتی',NULL,40,NULL,NULL,NULL,30,30,27,13,NULL,NULL,50),
(51,'Python 1',NULL,41,8000000,NULL,15,30,30,27,13,10,'python_1',51),
(52,'Python 2',NULL,41,8000000,NULL,15,30,30,27,13,10,'python_2',52),
(53,'Python 3',NULL,41,8000000,NULL,15,30,30,27,13,10,'python_3',53),
(54,'Python 4',NULL,41,8000000,NULL,15,30,30,27,13,10,'python_4',54),
(55,'طراحی مقدماتی',NULL,41,NULL,NULL,NULL,30,30,27,13,NULL,'design_basic',55),
(56,'طراحی پیشرفته',NULL,41,NULL,NULL,NULL,30,30,27,13,NULL,'design_advanced',56),
(57,'طراحی حرفه ای ۱',NULL,41,NULL,NULL,NULL,30,30,27,13,NULL,'design_professional_1',57),
(58,'طراحی حرفه ای ۲',NULL,41,NULL,NULL,NULL,30,30,27,13,NULL,'design_professional_2',58),
(59,'روباتیک پیشرفته',NULL,41,NULL,NULL,NULL,30,30,27,13,NULL,NULL,59),
(60,'روباتیک حرفه ای',NULL,41,NULL,NULL,NULL,30,30,27,13,NULL,NULL,60),
(61,'طراحی وب 1',NULL,41,NULL,NULL,NULL,30,30,27,13,NULL,'web_design_1',61),
(62,'طراحی وب 2',NULL,41,NULL,NULL,NULL,30,30,27,13,NULL,'web_design_2',62),
(63,'هوش مصنوعی مقدماتی',NULL,41,NULL,NULL,NULL,30,30,27,13,NULL,'AI_basic',63),
(64,'پردازش تصویر مقدماتی',NULL,41,NULL,NULL,NULL,30,30,27,13,NULL,'image_processing_basic',64),
(65,'ASP.net مقدماتی',NULL,2,20000000,NULL,18,20,20,27,33,12,'aspnet_basic',65),
(66,'ASP.net پیشرفته',NULL,2,20000000,NULL,18,20,20,27,33,12,'aspnet_advanced',66),
(67,'طراحی وب مقدماتی','Web Design (Basic)',9,20000000,0,20,0,0,27,NULL,10,'Web_Design_Basic',67),
(68,'سیستم عامل',NULL,0,0,0,0,0,0,0,NULL,0,'',68),
(69,'لینوکس مقدماتی',NULL,68,0,0,0,0,0,0,NULL,0,'',69),
(70,'مربیگری','Coaching',0,0,0,0,0,0,0,NULL,0,'',71),
(71,'Scratch مقدماتی','Coaching: Scratch (Basic)',70,0,0,0,0,0,0,NULL,0,'',72),
(72,'Scratch پیشرفته','Coaching: Scratch (Advanced)',70,0,0,0,0,0,0,NULL,0,'',73),
(73,'Oracle Database Administration Workshop I',NULL,7,50000000,0,40,25,25,25,NULL,10,'Oracle_WI',70),
(74,'مبانی مدیریت پروژه',NULL,9,50000000,0,30,100,0,0,NULL,10,'Project_Management',74);
/*!40000 ALTER TABLE `courses_categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `courses_sessions`
--
DROP TABLE IF EXISTS `courses_sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `courses_sessions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`course_id` int(11) DEFAULT NULL,
`room_id` int(11) DEFAULT NULL,
`class_date` char(10) DEFAULT NULL,
`class_start_time` char(8) DEFAULT NULL,
`class_duration` int(11) DEFAULT NULL,
`comment` text DEFAULT NULL,
`class_status` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `courses_sessions_ibfk_1` (`course_id`),
KEY `courses_sessions_ibfk_2` (`room_id`),
CONSTRAINT `courses_sessions_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `courses_sessions_ibfk_2` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=458 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_persian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `courses_sessions`
--
LOCK TABLES `courses_sessions` WRITE;
/*!40000 ALTER TABLE `courses_sessions` DISABLE KEYS */;
INSERT INTO `courses_sessions` VALUES
(73,1012,NULL,'1400-12-21','14:00',119,NULL,3),
(74,1012,NULL,'1400-12-25','14:00',126,NULL,4),
(75,1012,NULL,'1400-12-28','14:00',54,NULL,0),
(76,1012,NULL,'1401-01-03','14:00',108,NULL,1),
(77,1012,NULL,'1401-01-08','14:00',80,NULL,2),
(78,1012,NULL,'1401-01-15','14:00',63,NULL,3),
(79,1012,NULL,'1401-01-22','14:00',120,NULL,4),
(80,1012,NULL,'1401-01-24','14:00',84,NULL,0),
(81,1012,NULL,'1401-01-28','14:00',94,NULL,1),
(89,1002,NULL,'1400-11-09','19:00',60,NULL,4),
(90,1002,NULL,'1400-11-16','19:00',60,NULL,0),
(91,1002,NULL,'1400-11-25','19:00',60,NULL,1),
(92,1002,NULL,'1400-12-02','19:00',60,NULL,2),
(93,1002,NULL,'1400-12-09','19:00',60,NULL,3),
(94,1002,NULL,'1400-12-16','19:00',60,NULL,4),
(95,1002,NULL,'1400-12-25','19:00',60,NULL,0),
(96,1002,NULL,'1400-12-27','19:00',60,NULL,1),
(97,1002,NULL,'1401-01-01','19:00',60,NULL,2),
(98,1002,NULL,'1401-01-01','19:00',60,NULL,3),
(99,1002,NULL,'1401-01-02','19:00',60,NULL,4),
(100,1002,NULL,'1401-01-04','19:00',60,NULL,0),
(300,1017,NULL,'1401-02-26','18:30',90,'',0),
(301,1017,NULL,'1401-03-02','18:30',90,'',1),
(302,1017,NULL,'1401-03-09','18:30',90,'',2),
(303,1017,NULL,'1401-03-16','18:30',90,'',3),
(304,1017,NULL,'1401-03-23','18:30',90,'',4),
(305,1017,NULL,'1401-03-30','18:30',90,'',0),
(306,1017,NULL,'1401-04-06','18:30',90,'',1),
(307,1017,NULL,'1401-04-13','18:30',90,'',2),
(308,1017,NULL,'1401-04-20','18:30',90,'',3),
(309,1017,NULL,'1401-04-27','18:30',90,'',4),
(320,1012,NULL,'1400-12-05','14:00',90,'',0),
(321,1012,NULL,'1400-12-07','14:00',90,'',1),
(322,1012,NULL,'1400-12-10','14:00',90,'',2),
(323,1019,NULL,'1401-03-03','16:00',60,'',3),
(324,1019,NULL,'1401-03-10','16:00',60,'',4),
(325,1019,NULL,'1401-03-17','16:00',60,'',0),
(326,1019,NULL,'1401-03-24','16:00',60,'',1),
(328,1016,NULL,'1401-02-01','08:30',90,'',3),
(329,1016,NULL,'1401-02-08','08:30',90,'',4),
(330,1016,NULL,'1401-02-15','08:30',90,'',0),
(331,1016,NULL,'1401-02-29','08:30',90,'',1),
(332,1016,NULL,'1401-03-02','08:30',90,'',2),
(333,1016,NULL,'1401-03-05','08:30',90,'',3),
(334,1016,NULL,'1401-03-12','08:00',90,'',4),
(339,1019,NULL,'1401-03-28','16:00',60,'',NULL),
(340,1016,NULL,'1401-03-23','08:00',60,'',NULL),
(341,1016,NULL,'1401-03-30','08:00',60,'',NULL),
(342,1016,NULL,'1401-04-06','08:00',60,'',NULL),
(343,1016,NULL,'1401-04-13','08:00',60,'',NULL),
(344,1016,NULL,'1401-04-20','08:00',60,'',NULL),
(345,1016,NULL,'1401-03-26','08:30',60,'',NULL),
(346,1016,NULL,'1401-04-02','08:30',60,'',NULL),
(347,1016,NULL,'1401-04-09','08:30',60,'',NULL),
(348,1016,NULL,'1401-04-16','08:30',60,'',NULL),
(349,1016,NULL,'1401-04-23','08:30',60,'',NULL),
(350,1016,NULL,'1401-04-30','08:30',60,'',NULL),
(351,1016,NULL,'1401-05-06','08:30',60,'',NULL),
(352,1016,NULL,'1401-05-13','08:30',60,'',NULL),
(353,1016,NULL,'1401-05-20','08:30',60,'',NULL),
(354,1016,NULL,'1401-05-27','08:30',60,'',NULL),
(365,1020,NULL,'1401-03-28','21:00',90,'',NULL),
(366,1020,NULL,'1401-04-04','21:00',90,'',NULL),
(367,1020,NULL,'1401-04-11','21:00',90,'',NULL),
(368,1020,NULL,'1401-04-18','21:00',90,'',NULL),
(369,1020,NULL,'1401-04-25','21:00',90,'',NULL),
(370,1020,NULL,'1401-05-01','21:00',90,'',NULL),
(371,1020,NULL,'1401-05-08','21:00',90,'',NULL),
(372,1020,NULL,'1401-05-15','21:00',90,'',NULL),
(373,1020,NULL,'1401-05-22','21:00',90,'',NULL),
(374,1020,NULL,'1401-05-29','21:00',90,'',NULL),
(375,1019,NULL,'1401-04-04','16:00',60,'',NULL),
(376,1019,NULL,'1401-04-11','16:00',60,'',NULL),
(377,1019,NULL,'1401-04-18','16:00',60,'',NULL),
(378,1019,NULL,'1401-04-25','16:00',60,'',NULL),
(379,1019,NULL,'1401-05-01','16:00',60,'',NULL),
(380,1017,NULL,'1401-05-03','18:30',90,'',NULL),
(381,1017,NULL,'1401-05-10','18:30',90,'',NULL),
(382,1017,NULL,'1401-05-17','18:30',90,'',NULL),
(383,1017,NULL,'1401-05-24','18:30',90,'',NULL),
(384,1017,NULL,'1401-05-31','18:30',90,'',NULL),
(385,1017,NULL,'1401-06-07','18:30',90,'',NULL),
(386,1017,NULL,'1401-06-14','18:30',90,'',NULL),
(387,1017,NULL,'1401-06-21','18:30',90,'',NULL),
(388,1017,NULL,'1401-06-28','18:30',90,'',NULL),
(389,1017,NULL,'1401-07-04','18:30',90,'',NULL),
(390,1024,NULL,'1401-03-28','08:30',120,'',NULL),
(391,1024,NULL,'1401-04-04','08:30',120,'',NULL),
(392,1024,NULL,'1401-04-11','08:30',120,'',NULL),
(393,1024,NULL,'1401-04-18','08:30',120,'',NULL),
(394,1024,NULL,'1401-04-25','08:30',120,'',NULL),
(395,1024,NULL,'1401-05-01','08:30',120,'',NULL),
(396,1024,NULL,'1401-05-08','08:30',120,'',NULL),
(397,1024,NULL,'1401-05-15','08:30',120,'',NULL),
(398,1024,NULL,'1401-05-22','08:30',120,'',NULL),
(399,1024,NULL,'1401-05-29','08:30',120,'',NULL),
(400,1025,NULL,'1401-03-29','21:00',90,'',NULL),
(401,1025,NULL,'1401-04-05','21:00',90,'',NULL),
(402,1025,NULL,'1401-04-12','21:00',90,'',NULL),
(403,1025,NULL,'1401-04-19','21:00',90,'',NULL),
(404,1025,NULL,'1401-04-26','21:00',90,'',NULL),
(405,1025,NULL,'1401-05-02','21:00',90,'',NULL),
(406,1025,NULL,'1401-05-09','21:00',90,'',NULL),
(407,1025,NULL,'1401-05-16','21:00',90,'',NULL),
(408,1025,NULL,'1401-05-23','21:00',90,'',NULL),
(409,1025,NULL,'1401-05-30','21:00',90,'',NULL),
(411,1014,NULL,'1401-01-16','14:00',120,NULL,NULL),
(412,1014,NULL,'1401-02-31','14:00',120,NULL,NULL),
(413,1014,NULL,'1401-03-10','14:00',120,NULL,NULL),
(414,1014,NULL,'1401-03-11','14:00',120,NULL,NULL),
(415,1014,NULL,'1401-03-17','14:00',120,NULL,NULL),
(416,1014,NULL,'1401-03-23','14:00',120,NULL,NULL),
(418,1014,NULL,'1401-04-02','10:00',120,'',NULL),
(419,1014,NULL,'1401-04-09','10:00',120,'',NULL),
(420,1014,NULL,'1401-04-16','10:00',120,'',NULL),
(421,1014,NULL,'1401-04-23','10:00',120,'',NULL),
(422,1014,NULL,'1401-04-30','10:00',120,'',NULL),
(423,1014,NULL,'1401-03-30','10:00',120,'',NULL),
(424,1014,NULL,'1401-04-06','10:00',120,'',NULL),
(425,1014,NULL,'1401-04-13','10:00',120,'',NULL),
(426,1014,NULL,'1401-04-20','10:00',120,'',NULL),
(427,1014,NULL,'1401-04-27','10:00',120,'',NULL),
(428,1013,NULL,'1401-03-30','16:00',120,'',NULL),
(429,1013,NULL,'1401-04-06','16:00',120,'',NULL),
(430,1013,NULL,'1401-04-13','16:00',120,'',NULL),
(431,1013,NULL,'1401-04-20','16:00',120,'',NULL),
(432,1013,NULL,'1401-04-27','16:00',120,'',NULL),
(433,1013,NULL,'1401-05-03','16:00',120,'',NULL),
(434,1013,NULL,'1401-05-10','16:00',120,'',NULL),
(435,1013,NULL,'1401-05-17','16:00',120,'',NULL),
(436,1013,NULL,'1401-05-24','16:00',120,'',NULL),
(437,1013,NULL,'1401-05-31','16:00',120,'',NULL),
(438,1013,NULL,'1401-04-01','16:00',120,'',NULL),
(439,1013,NULL,'1401-04-08','16:00',120,'',NULL),
(440,1013,NULL,'1401-04-15','16:00',120,'',NULL),
(441,1013,NULL,'1401-04-22','16:00',120,'',NULL),
(442,1013,NULL,'1401-04-29','16:00',120,'',NULL),
(443,1013,NULL,'1401-05-05','16:00',120,'',NULL),
(444,1013,NULL,'1401-05-12','16:00',120,'',NULL),
(445,1013,NULL,'1401-05-19','16:00',120,'',NULL),
(446,1013,NULL,'1401-05-26','16:00',120,'',NULL),
(447,1013,NULL,'1401-06-02','16:00',120,'',NULL),
(448,1013,NULL,'1401-02-03','17:00',120,'',NULL),
(449,1013,NULL,'1401-02-10','17:00',120,'',NULL),
(450,1013,NULL,'1401-02-17','17:00',120,'',NULL),
(451,1013,NULL,'1401-02-24','17:00',120,'',NULL),
(452,1013,NULL,'1401-02-31','17:00',120,'',NULL),
(453,1013,NULL,'1401-03-07','17:00',120,'',NULL),
(454,1013,NULL,'1401-03-14','17:00',120,'',NULL),
(455,1013,NULL,'1401-03-21','17:00',120,'',NULL),
(456,1013,NULL,'1401-03-28','17:00',120,'',NULL),
(457,1013,NULL,'1401-04-04','17:00',120,'',NULL);
/*!40000 ALTER TABLE `courses_sessions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `courses_students`
--
DROP TABLE IF EXISTS `courses_students`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `courses_students` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`course_id` int(11) DEFAULT NULL,
`student_id` int(11) DEFAULT NULL,
`discount_rate` int(11) DEFAULT 0,
`inactive` tinyint(1) DEFAULT 0,
`is_certified_fa` tinyint(1) DEFAULT 0,
`is_certified_en` int(11) DEFAULT 0,
`moodle_enrolment_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `course_id` (`course_id`),
KEY `student_id` (`student_id`),
CONSTRAINT `courses_students_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `courses_students_ibfk_2` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `courses_students`
--
LOCK TABLES `courses_students` WRITE;
/*!40000 ALTER TABLE `courses_students` DISABLE KEYS */;
INSERT INTO `courses_students` VALUES
(4,1002,141,0,0,1,1,10010),
(5,1002,149,0,0,1,1,10011),
(6,1002,147,0,0,1,1,10012),
(8,1003,134,0,0,0,0,10004),
(16,1012,165,0,0,1,1,10027),
(17,1013,157,0,0,0,0,0),
(18,1014,166,0,0,0,0,0),
(19,1015,167,0,0,0,0,0),
(21,1016,169,0,0,0,0,0),
(22,1016,171,0,0,0,0,0),
(23,1017,141,0,0,0,0,0),
(24,1017,149,0,0,0,0,0),
(25,1017,147,0,0,0,0,0),
(28,1016,173,0,0,0,0,0),
(29,1019,178,0,0,0,0,0),
(31,1020,134,0,0,0,0,0),
(35,1024,158,0,0,0,0,0),
(36,1025,182,0,0,0,0,0),
(37,1026,183,0,0,0,0,0),
(40,1029,166,0,0,0,0,0),
(42,1031,169,0,0,0,0,0),
(43,1031,170,0,0,0,0,0),
(44,1032,169,0,0,0,0,0),
(45,1032,170,0,0,0,0,0),
(52,1037,194,0,0,0,0,0),
(53,1038,194,0,0,0,0,0),
(58,1044,141,0,0,0,0,0),
(60,1046,200,0,0,0,0,NULL),
(61,1047,201,0,0,0,0,0),
(62,1047,203,0,0,0,0,NULL),
(64,1048,203,0,0,0,0,0),
(65,1048,204,0,0,0,0,0),
(68,1052,198,0,0,0,0,0),
(69,1052,199,0,0,0,0,0),
(70,1052,200,0,0,0,0,0),
(76,1056,213,0,0,0,0,0);
/*!40000 ALTER TABLE `courses_students` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `courses_students_payments`
--
DROP TABLE IF EXISTS `courses_students_payments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `courses_students_payments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`course_student_id` int(11) DEFAULT NULL,
`payment_date` char(10) DEFAULT NULL,
`payment_amount` int(11) DEFAULT NULL,
`payment_method` tinyint(1) DEFAULT NULL COMMENT '1 = Card Transfer, 2 = PG , 3 = Pos , 4 = Cash',
`payment_description` text DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_persian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `courses_students_payments`
--
LOCK TABLES `courses_students_payments` WRITE;
/*!40000 ALTER TABLE `courses_students_payments` DISABLE KEYS */;
INSERT INTO `courses_students_payments` VALUES
(5,16,'1401-01-29',24000000,1,'واريز به: 147-880-4592705-1\r\n24,000,000 ريال\r\n1401/1/29\r\n15:31 \r\nشرح: انتقال از اينترنت 115 سپه از ک 6273811162221920 ش م 021808975109 ش پ 262283'),
(6,31,'1401-03-28',25000000,1,''),
(7,34,'1401-04-05',25000000,1,''),
(8,33,'1401-04-05',25000000,1,'');
/*!40000 ALTER TABLE `courses_students_payments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `goods`
--
DROP TABLE IF EXISTS `goods`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `goods` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`number` int(11) NOT NULL,
`price_one_buy` int(11) NOT NULL,
`price_one_sell` int(11) DEFAULT NULL,
`good_service` tinyint(1) DEFAULT NULL,
`unit` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`is_old` int(1) DEFAULT 0,
`serial_no` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=598 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `goods`
--
LOCK TABLES `goods` WRITE;
/*!40000 ALTER TABLE `goods` DISABLE KEYS */;
/*!40000 ALTER TABLE `goods` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `goods_log`
--
DROP TABLE IF EXISTS `goods_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `goods_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`transaction_type` enum('اضافه شدن کالای جدید به انبار','افزایش موجودی','صدور فاکتور','ویرایش کالا در فاکتور','حذف کالا از فاکتور') DEFAULT NULL,
`invoice_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`good_id` int(11) NOT NULL,
`number` int(11) DEFAULT NULL,
`price_one_buy` int(11) DEFAULT NULL,
`price_one_sell` int(11) DEFAULT NULL,
`invoice_no_buy` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`buyer_id` int(11) DEFAULT NULL,
`buyer_invoice_id` int(11) DEFAULT NULL,
`comment` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `good_id` (`good_id`),
CONSTRAINT `goods_log_ibfk_1` FOREIGN KEY (`good_id`) REFERENCES `goods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=958 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `goods_log`
--
LOCK TABLES `goods_log` WRITE;
/*!40000 ALTER TABLE `goods_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `goods_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `invoices`
--
DROP TABLE IF EXISTS `invoices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoices` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`is_student` tinyint(1) DEFAULT 1,
`buyer_id` int(11) DEFAULT NULL,
`date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`time` varchar(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`off` int(11) DEFAULT NULL,
`payment_status` tinyint(1) DEFAULT NULL,
`payment_description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `student_id` (`buyer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `invoices`
--
LOCK TABLES `invoices` WRITE;
/*!40000 ALTER TABLE `invoices` DISABLE KEYS */;
INSERT INTO `invoices` VALUES
(1,1,1,'1394-02-26','16:00:10',NULL,NULL,NULL),
(2,1,15,'1394-04-12','17:36:04',NULL,NULL,NULL),
(3,1,48,'1394-04-14','22:45:19',NULL,NULL,NULL),
(4,1,49,'1394-04-14','22:49:31',NULL,NULL,NULL),
(5,1,47,'1394-04-10','22:51:42',NULL,NULL,NULL),
(6,1,46,'1394-04-10','23:05:16',NULL,NULL,NULL),
(7,1,42,'1394-04-01','23:41:01',NULL,NULL,NULL),
(8,1,41,'1394-04-01','23:44:23',NULL,NULL,NULL),
(9,1,40,'1394-04-10','00:05:17',NULL,NULL,NULL),
(10,1,36,'1394-03-31','00:51:42',NULL,NULL,NULL),
(11,1,34,'1394-04-14','01:01:34',NULL,NULL,NULL),
(12,1,32,'1394-03-25','01:49:07',NULL,NULL,NULL),
(13,1,28,'1393-12-17','17:02:56',NULL,NULL,NULL),
(14,1,27,'1394-02-06','17:23:25',NULL,NULL,NULL),
(15,1,24,'1393-12-11','18:03:05',NULL,NULL,NULL),
(16,1,23,'1394-03-18','18:11:45',NULL,NULL,NULL),
(17,1,22,'1394-01-23','17:00:51',NULL,NULL,NULL),
(18,1,18,'1393-11-11','17:51:40',NULL,NULL,NULL),
(19,1,17,'1394-03-04','15:12:21',NULL,NULL,NULL),
(20,1,16,'1393-02-18','15:23:49',NULL,NULL,NULL),
(21,1,9,'1394-02-16','18:17:16',NULL,NULL,NULL),
(22,1,8,'1394-02-16','18:19:00',NULL,NULL,NULL),
(23,1,5,'1394-02-23','19:40:25',NULL,NULL,NULL),
(24,1,6,'1394-02-23','19:45:52',NULL,NULL,NULL),
(25,1,7,'1394-02-30','19:48:12',NULL,NULL,NULL),
(26,1,14,'1394-03-30','19:51:25',NULL,NULL,NULL),
(27,1,10,'1394-03-06','20:01:06',NULL,NULL,NULL),
(28,1,50,'1394-04-24','10:37:19',NULL,NULL,NULL),
(29,1,3,'1394-04-07','11:25:31',NULL,NULL,NULL),
(30,1,13,'1394-04-07','11:30:27',NULL,NULL,NULL),
(31,0,1,'1394-05-01','18:11:10',NULL,NULL,NULL),
(32,0,2,'1394-05-05','16:17:35',NULL,NULL,NULL),
(33,1,11,'1394-05-05','16:55:28',NULL,NULL,NULL),
(34,1,60,'1394-05-14','12:51:40',NULL,NULL,NULL),
(35,1,65,'1394-05-19','20:53:46',NULL,NULL,NULL),
(36,1,33,'1394-05-21','18:53:14',NULL,NULL,NULL),
(37,1,59,'1394-05-21','19:34:48',NULL,NULL,NULL),
(38,1,53,'1394-05-21','19:36:11',NULL,NULL,NULL),
(39,1,31,'1394-05-25','15:11:18',NULL,NULL,NULL),
(40,0,3,'1394-05-19','13:47:58',NULL,NULL,NULL),
(41,1,35,'1394-06-15','11:37:10',NULL,NULL,NULL),
(42,0,2,'1394-06-18','19:35:55',NULL,NULL,NULL),
(43,1,66,'1394-06-22','16:25:27',NULL,NULL,NULL),
(44,1,71,'1394-06-29','11:22:18',NULL,NULL,NULL),
(45,1,0,'1394-06-29','19:35:28',NULL,NULL,NULL),
(46,1,56,'1394-06-30','17:34:51',NULL,NULL,NULL),
(47,0,1,'1394-07-12','18:00:23',NULL,NULL,NULL),
(48,1,73,'1394-07-26','18:19:47',NULL,NULL,NULL),
(49,1,74,'1394-08-04','19:16:21',NULL,NULL,NULL),
(50,1,31,'1394-08-17','15:18:40',NULL,NULL,NULL),
(51,1,74,'1394-08-18','19:14:05',NULL,NULL,NULL),
(52,1,80,'1394-08-19','18:04:32',NULL,NULL,NULL),
(53,1,2,'1394-08-19','19:59:11',NULL,NULL,NULL),
(54,1,84,'1394-08-20','20:45:31',NULL,NULL,NULL),
(55,0,4,'1394-08-23','14:13:09',NULL,NULL,NULL),
(56,1,83,'1394-08-26','15:48:16',NULL,NULL,NULL),
(57,1,86,'1394-08-27','20:17:59',NULL,NULL,NULL),
(58,1,87,'1394-09-01','16:57:29',NULL,NULL,NULL);
/*!40000 ALTER TABLE `invoices` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `invoices_goods`
--
DROP TABLE IF EXISTS `invoices_goods`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoices_goods` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`good_id` int(11) DEFAULT NULL,
`invoice_id` int(11) DEFAULT NULL,
`number` int(11) DEFAULT NULL,
`date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`time` varchar(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`price` int(11) DEFAULT NULL,
`is_gift` tinyint(1) DEFAULT 0,
PRIMARY KEY (`id`),
KEY `good_id` (`good_id`),
KEY `invoice_id` (`invoice_id`),
CONSTRAINT `invoices_goods_ibfk_1` FOREIGN KEY (`good_id`) REFERENCES `goods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `invoices_goods_ibfk_3` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=266 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `invoices_goods`
--
LOCK TABLES `invoices_goods` WRITE;
/*!40000 ALTER TABLE `invoices_goods` DISABLE KEYS */;
/*!40000 ALTER TABLE `invoices_goods` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Temporary table structure for view `invoices_goods_view`
--
DROP TABLE IF EXISTS `invoices_goods_view`;
/*!50001 DROP VIEW IF EXISTS `invoices_goods_view`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8mb4;
/*!50001 CREATE VIEW `invoices_goods_view` AS SELECT
1 AS `buyer_id`,
1 AS `buyer_firstname`,
1 AS `buyer_lastname`,
1 AS `invoice_date`,
1 AS `good_id`,
1 AS `good_name`,
1 AS `good_number`,
1 AS `good_price`,
1 AS `total_price`,
1 AS `good_is_gift` */;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `messages`
--
DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`message_server_id` bigint(20) DEFAULT NULL,
`message_source` char(13) DEFAULT NULL,
`message_destination` char(12) DEFAULT NULL,
`message_date_time` char(20) DEFAULT NULL,
`message_body` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`message_status_code` varchar(4) DEFAULT NULL,
`message_status_description` text DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `messages`
--
LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
INSERT INTO `messages` VALUES
(1,10090944545,NULL,NULL,NULL,NULL,NULL,'Send Successfully'),
(37,0,'9820003346000','989126907530','','masoud nikoofar عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(38,0,'9820003346000','989126907530','','مسعود نیکوفر عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(39,0,'9820003346000','989186762635','','زهره محبیان عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(40,0,'9820003346000','989398101900','','نسترن بختیاری عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(41,0,'9820003346000','989394846879','','هما قنبری ایلخچی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(42,0,'9820003346000','989125271376','','محسن عبدالرضائی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(43,0,'9820003346000','989121231231','','عباس عباسی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(44,0,'9820003346000','989121231231','','عباس عباسی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(45,0,'9820003346000','989121394318','','سید محسن ذوالفقاری عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(46,0,'9820003346000','989375583675','','امیر کهن سالی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(47,0,'9820003346000','989123534536','','سینا روح عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(48,0,'9820003346000','989122705760','','Nima Sayad عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(49,0,'9820003346000','989125412331','','رويا اقبال زاده عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(50,0,'9820003346000','989189117147','','حنانه شبستانی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(51,0,'9820003346000','989126907530','','x x عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(52,0,'9820003346000','989353108064','','مهدی محمدی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(53,0,'9820003346000','989123962763','','هادی هوشنگی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(54,0,'9820003346000','989124957870','','فهیمه عسگری عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(55,0,'9820003346000','989304808868','1401-07-24 14:53:06','حمید گلشاهی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\n','',''),
(56,0,'9820003346000','989129308868','','حمیدرضا گلشاهی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(57,0,'9820003346000','989126482972','','علی منصور عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(58,0,'9820003346000','989124905486','','نیلوفر هندیجانی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(59,0,'9820003346000','989124379588','','محمدعلی اکبری عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(60,0,'9820003346000','989117898245','','vahid rezaei عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(61,0,'9820003346000','989127978434','','vahid vahid عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(62,0,'9820003346000','989352676260','','غزاله عبدالهی نژاد عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(63,0,'9820003346000','989102001375','','محمد جلالی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(64,0,'9820003346000','989352522809','','فاطمه قلی پور اصل عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(65,0,'9820003346000','989333804030','','مهتاب بشیری عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(66,0,'9820003346000','989128309568','','محمد علی ترکمان اسدی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(67,0,'9820003346000','989183141547','','محمد جواد ترکمان اسدی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(68,0,'9820003346000','989102141592','','شیرین حجی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(69,0,'9820003346000','989123449189','','علی مسرور عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(70,0,'9820003346000','989912066170','','سارینا سیستانی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(71,0,'9820003346000','989101367356','','محمدحسن سیامک عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(72,0,'9820003346000','989123378552','','محمد بیرزابیگی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(73,0,'9820003346000','989126596756','','محمد رحمانی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(74,0,'9820003346000','989193232976','','بهشته فضلی خانی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','',''),
(75,0,'9820003346000','989211288732','','مبارکه فضلی خانی عزیز به آکادمی هوش مصنوعی نیکو خوش آمدید\nهمکاران ما در اسرع وقت با شما تماس خواهند گرفت\nاز اعتماد و صبر شما سپاسگذاریم','','');
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `messages_status`
--
DROP TABLE IF EXISTS `messages_status`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `messages_status` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`status_code` varchar(4) DEFAULT NULL,
`status_type` text DEFAULT NULL,
`status_description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `messages_status`
--
LOCK TABLES `messages_status` WRITE;
/*!40000 ALTER TABLE `messages_status` DISABLE KEYS */;
INSERT INTO `messages_status` VALUES
(1,'E1','Security HTTP Header Not Set','نام کاربری و یا کلمه عبور وارد نشده است '),
(2,'E2','All Parameters Is Require ','ورود تمامی پارامترها الزامیست '),
(3,'E3','Entered Parameters Most be as String ','پرامتر ورودی باید از نوع رشته باشد '),
(4,'E4','Access Forbidden ','دسترسی غیر مجاز به سیستم '),
(5,'E5 ','Authentication Failed ','نام کاربری و یا کلمه عبور صحیح نیست '),
(6,'E107','Request Size Out Of Range ','تعداد گیرندگان مشخص شده بیش از 250 گیرنده میباشد '),
(7,'E223','Source Number not valid ','شماره اختصاصی وارد شده نا معتبر است '),
(8,'E211','Message Long Out Of Range','طول متن پیام بیش از حد مجاز است '),
(9,'E6','Not Enough Credit','اعتبار برای ارسال کافی نیست '),
(10,'E7','No New Message','پیام ورودی جدید خوانده نشده ای وجود ندارد '),
(11,'E8','ID Not Correct','شناسه وارد شده پیام جهت دریافت وضعیت نا معتبر است '),
(12,'E305','Message ID is not Valid ','شناسه وارد شده پیام جهت دریافت وضعیت وجو ندارد '),
(13,'E65','Message Id Is Require ','مقدار دهی شناسه پیام الزامیست '),
(14,'E66','srcNumber Is Require ','مقدار دهی شماره اختصاصی مورد نظر الزامیست '),
(15,'E43','Recipient Number is not Valid ','شماره گیرنده نا معتبر است '),
(16,'E766','Message Body is Empty ','متن پیام خالیست '),
(17,'E999','','شماره منقضی شده است '),
(18,'E998','','پکیج منقضی شده است '),
(19,'E303','','هیچ شماره گیرنده صحیحی وارد نشده '),
(20,'E132','','متن وارد شده شامل کلمات حساس است '),
(21,'E800','','لیست سیاه '),
(22,'X001','Client Error','اتصال به وب سرویس با مشکل مواجه شد'),
(23,'X002',NULL,NULL),
(24,'X003','Send Error','خطا در ارسال پیامک');
/*!40000 ALTER TABLE `messages_status` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `other_costs`
--
DROP TABLE IF EXISTS `other_costs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `other_costs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`amount` int(11) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `other_costs`
--
LOCK TABLES `other_costs` WRITE;
/*!40000 ALTER TABLE `other_costs` DISABLE KEYS */;
INSERT INTO `other_costs` VALUES
(12,'خرید پلاگین المنتور برای طراحی سایت','1400-09-23',1490000,2),
(13,'دامنه anaconda.ac.ir برای ۵ سال','1400-09-24',360000,2),
(14,'دفتر اسناد رسمی (تعهدنامه مجوز آموزشگاه)','1400-09-27',2400000,2),
(15,'دامنه nikoo-academy.ir برای ۵ سال','1400-09-30',480000,2),
(16,'دامنه nikoo-academy.com برای ۱ سال','1400-09-30',3836800,2),
(17,'دامنه nikooai.ir برای ۵ سال','1400-10-02',480000,2),
(18,'هزینه سرور - ابر آروان','1400-10-12',1000000,2),
(19,'هزینه سرور - ابر آروان','1400-10-26',500000,2),
(20,'هزینه سرور - ابر آروان','1400-11-01',1000000,2),
(21,'هزینه سرور - ابر آروان','1400-11-04',500000,2),
(22,'هزینه سرور - ابر آروان','1400-11-09',1000000,2),
(23,'هزینه سرور - ابر آروان','1400-11-16',5000000,2),
(24,'دامنه nikanai.ir و nikan-ai.ir برای ۵ سال','1400-12-02',960000,2),
(25,'هزینه سرور - ابر آروان','1400-12-03',5000000,2),
(26,'ساخت مهر ','1400-12-07',1400000,2),
(27,'افتتاح حساب','1400-12-07',1000000,2),
(28,'رهن ساختمان','1400-12-01',750000000,2),
(29,'هزینه بنگاه','1400-12-01',40000000,2),
(30,'هزینه ثبت شرکت','1400-12-11',24000000,2),
(31,'میز و صندلی','1400-12-13',185000000,2),
(32,'سینک ظرفشویی+کابینت+وانت','1400-12-14',21000000,2),
(33,'نظافت دفتر','1400-12-14',2500000,2),
(34,'لامپ','1400-12-15',6200000,2),
(35,'لامپ','1400-12-15',3000000,3),
(36,'برق کار','1400-12-15',4000000,2),
(37,'وانت+نصب (میز و صندلی)','1400-12-18',6000000,2),
(38,'لامپ و پریز+وانت سینک','1400-12-22',1500000,3),
(39,'شیر ظرفشویی+لوله کش','1400-12-23',6500000,3),
(40,'هزینه سرور - ابر آروان','1401-01-01',3000000,2),
(41,'هزینه سرور - ابر آروان','1401-01-15',4000000,2),
(42,'اجاره دفتر','1401-01-15',40000000,2),
(43,'هزینه سرور - ابر آروان ','1401-01-31',3000000,2),
(44,'هزینه سرور - ابر آروان','1401-02-14',3000000,2),
(45,'سوپرمارکت','1401-02-26',5000000,2),
(46,'سوپرمارکت','1401-02-28',500000,2),
(47,'هزینه سرور - ابر آروان ','1401-02-28',5000000,2),
(48,'قبض','1401-03-03',217000,2),
(49,'سوپرمارکت','1401-03-03',880000,2),
(50,'اجاره','1401-03-16',40000000,2),
(51,'هزینه سرور - ابر آروان ','1401-03-18',5000000,2),
(52,'اینترنت (سیم کارت ایرانسل)','1401-03-18',1103300,2),
(53,'ADSL','1401-03-29',1471500,2),
(54,'هزینه سرور - ابر آروان ','1401-04-01',5000000,2),
(55,'هزینه های دفتر (توری+سیفون+آینه+...)','1401-04-03',5000000,4),
(56,'مبلمان اداری+وانت','1401-04-05',31300000,2),
(57,'رهن ساختمان','1400-12-01',750000000,4),
(58,'اجاره','1401-04-15',40000000,2),
(59,'هزینه سرور - ابر آروان ','1401-04-18',5000000,2),
(60,'ADSL','1401-05-01',654000,2),
(61,'سوپرمارکت','1401-05-02',1700000,2),
(62,'هزینه سرور - ابر آروان ','1401-05-04',5000000,2),
(63,'دوربین مداربسته','1401-05-04',45000000,2),
(64,'ADSL','1401-06-01',650000,2),
(65,'هزینه سرور - Parspack','1401-05-27',2000000,2),
(66,'هزینه سرور - Parspack','1401-05-20',1000000,2),
(67,'شارژ ساختمان دفتر','1401-06-02',243500,2);
/*!40000 ALTER TABLE `other_costs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `people`
--
DROP TABLE IF EXISTS `people`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `people` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`job_position` int(1) NOT NULL,
`mobile` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`user` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`pass` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`level` tinyint(1) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1=disable, 0=enable',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `people`
--
LOCK TABLES `people` WRITE;
/*!40000 ALTER TABLE `people` DISABLE KEYS */;
/*!40000 ALTER TABLE `people` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `people_base_wage`
--
DROP TABLE IF EXISTS `people_base_wage`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `people_base_wage` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) DEFAULT NULL,
`start_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`end_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`base_wage` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `people_base_wage`
--
LOCK TABLES `people_base_wage` WRITE;
/*!40000 ALTER TABLE `people_base_wage` DISABLE KEYS */;
INSERT INTO `people_base_wage` VALUES
(1,3,'0000-01-01','1393-01-01',20000),
(2,3,'1394-01-01','1395-01-01',30000),
(3,3,'1395-01-01','1396-01-01',40000),
(4,3,'1396-01-01','1397-01-01',30000);
/*!40000 ALTER TABLE `people_base_wage` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `people_payments`
--
DROP TABLE IF EXISTS `people_payments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `people_payments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) NOT NULL,
`month` varchar(7) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`payment_info` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`payment_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`payment_type` tinyint(1) DEFAULT NULL,
`comment` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `people_payments`
--
LOCK TABLES `people_payments` WRITE;
/*!40000 ALTER TABLE `people_payments` DISABLE KEYS */;
INSERT INTO `people_payments` VALUES
(1,3,'1394-06','792529','1394-06-29',2,''),
(2,3,'1394-07','921932','1394-07-28',2,''),
(3,3,'1394-08','92658','1394-08-27',2,'');
/*!40000 ALTER TABLE `people_payments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `people_rollcall`
--
DROP TABLE IF EXISTS `people_rollcall`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `people_rollcall` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) DEFAULT NULL,
`date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`enter_time` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`exit_time` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `people_rollcall`
--
LOCK TABLES `people_rollcall` WRITE;
/*!40000 ALTER TABLE `people_rollcall` DISABLE KEYS */;
INSERT INTO `people_rollcall` VALUES
(3,3,'1394-05-12','10:00','21:00'),
(4,3,'1394-05-07','09:00','20:00'),
(5,3,'1394-05-11','10:00','20:00'),
(36,3,'1394-04-03','10:00','20:00'),
(37,3,'1394-04-07','10:00','20:00'),
(38,3,'1394-04-08','10:00','20:00'),
(39,3,'1394-04-10','09:00','20:00'),
(40,3,'1394-04-14','10:00','20:00'),
(41,3,'1394-04-15','10:00','20:00'),
(44,3,'1394-01-30','10:00','20:00'),
(45,3,'1394-01-31','10:00','20:00'),
(46,3,'1394-02-02','10:00','20:00'),
(47,3,'1394-02-06','10:00','20:00'),
(48,3,'1394-02-07','10:00','20:00'),
(49,3,'1394-02-09','10:00','20:00'),
(50,3,'1394-02-13','10:00','20:00'),
(51,3,'1394-02-14','10:00','20:00'),
(52,3,'1394-02-16','10:00','20:00'),
(53,3,'1394-02-20','10:00','20:00'),
(54,3,'1394-02-23','10:00','20:00'),
(55,3,'1394-02-27','10:00','20:00'),
(56,3,'1394-02-28','10:00','20:00'),
(57,3,'1394-02-30','10:00','20:00'),
(58,3,'1394-02-21','10:00','20:00'),
(59,3,'1394-03-03','10:00','20:00'),
(60,3,'1394-03-04','10:00','20:00'),
(61,3,'1394-03-06','10:00','20:00'),
(62,3,'1394-03-10','10:00','20:00'),
(63,3,'1394-03-11','10:00','20:00'),
(64,3,'1394-03-17','10:00','20:00'),
(65,3,'1394-03-18','10:00','20:00'),
(66,3,'1394-03-20','10:00','20:00'),
(67,3,'1394-03-24','10:00','20:00'),
(68,3,'1394-03-25','10:00','20:00'),
(69,3,'1394-03-27','10:00','20:00'),
(71,3,'1394-04-01','10:00','20:00'),
(72,3,'1394-04-21','10:00','20:00'),
(73,3,'1394-04-22','10:00','20:00'),
(74,3,'1394-04-24','09:00','20:00'),
(75,3,'1394-04-29','10:00','20:00'),
(76,3,'1394-04-31','09:00','20:00'),
(77,3,'1394-05-14','9:00','21:00'),
(78,3,'1394-05-05','10:00','21:00'),
(80,3,'1394-05-18','10:00','20:00'),
(82,3,'1394-05-19','10:00','21:00'),
(83,3,'1394-05-21','9:00','21:00'),
(84,3,'1394-05-25','10:00','20:30'),
(85,3,'1394-05-26','10:00','21:00'),
(86,3,'1394-05-28','9:00','20:00'),
(87,3,'1394-05-04','10:00','20:00'),
(88,3,'1394-06-01','10:00','20:00'),
(89,3,'1394-06-02','10:00','21:00'),
(90,3,'1394-06-03','13:00','19:00'),
(91,3,'1394-06-04','10:00','21:00'),
(92,3,'1394-06-09','10:00','21:00'),
(93,3,'1394-06-08','10:00','20:00'),
(94,3,'1394-06-15','10:00','20:15'),
(95,3,'1394-06-11','9:30','21:00'),
(96,3,'1394-06-16','12:30','21:00'),
(97,3,'1394-06-18','9:30','21:45'),
(98,3,'1394-06-23','10:00','21:00'),
(99,3,'1394-06-22','10:00','20:15'),
(100,3,'1394-06-29','10:00','20:15'),
(101,3,'1394-06-30','10:00','20:15'),
(102,3,'1394-06-25','9:30','21:00'),
(103,3,'1394-07-01','10:00','20:30'),
(104,3,'1394-07-05','14:00','20:00'),
(105,3,'1394-07-14','10:00','20:00'),
(107,3,'1394-07-07','10:00','20:00'),
(108,3,'1394-07-08','10:00','20:00'),
(109,3,'1394-07-12','14:00','20:00'),
(110,3,'1394-07-15','10:00','20:15'),
(111,3,'1394-07-19','14:30','20:00'),
(112,3,'1394-07-22','13:45','21:00'),
(113,3,'1394-07-21','10:00','20:00'),
(114,3,'1394-07-26','14:45','20:00'),
(115,3,'1394-07-28','10:00','20:00'),
(116,3,'1394-07-29','10:00','20:00'),
(117,3,'1394-08-03','14:45','20:00'),
(118,3,'1394-08-05','10:00','21:00'),
(119,3,'1394-08-06','11:30','20:15'),
(122,3,'1394-08-12','9:00','21:00'),
(123,3,'1394-08-13','12:15','20:00'),
(124,3,'1394-08-17','14:45','20:00'),
(129,3,'1394-08-10','14:45','20:00'),
(132,3,'1394-08-19','10:00','20:00'),
(133,3,'1394-08-20','11:00','20:00'),
(134,3,'1394-08-24','14:45','20:00'),
(135,3,'1394-08-26','10:00','21:15'),
(140,3,'1394-08-27','13:30','21:00'),
(141,3,'1394-09-01','14:30','20:15'),
(142,3,'1394-09-03','14:00','21:15'),
(143,3,'1394-09-04','10:00','21:45'),
(144,3,'1394-09-10','10:00','20:30'),
(145,3,'1394-09-15','14:30','20:30'),
(146,3,'1394-09-08','14:30','20:00');
/*!40000 ALTER TABLE `people_rollcall` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rooms`
--
DROP TABLE IF EXISTS `rooms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `rooms` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `rooms`
--
LOCK TABLES `rooms` WRITE;
/*!40000 ALTER TABLE `rooms` DISABLE KEYS */;
INSERT INTO `rooms` VALUES
(1,'اتاق 1'),
(2,'آنلاین');
/*!40000 ALTER TABLE `rooms` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `semesters`
--
DROP TABLE IF EXISTS `semesters`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `semesters` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`is_current` tinyint(1) DEFAULT NULL,
`start_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`finish_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `semesters`
--
LOCK TABLES `semesters` WRITE;
/*!40000 ALTER TABLE `semesters` DISABLE KEYS */;
INSERT INTO `semesters` VALUES
(1,'ترم جدید',NULL,'','');
/*!40000 ALTER TABLE `semesters` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
`status` tinyint(4) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `settings`
--
LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES
(0);
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `students`
--
DROP TABLE IF EXISTS `students`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `students` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`firstname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`lastname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`firstname_en` varchar(100) DEFAULT NULL,
`lastname_en` varchar(100) DEFAULT NULL,
`sex` char(1) DEFAULT NULL,
`national_code` char(10) DEFAULT NULL,
`tel` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`mobile` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`reg_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`job` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`education` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`birth_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`IT_history` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`operator_id` int(11) unsigned zerofill DEFAULT NULL,
`inactive` tinyint(1) DEFAULT 0,
`moodle_user_id` int(11) DEFAULT NULL,
`user` varchar(100) DEFAULT NULL,
`pass` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=214 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `students`
--
LOCK TABLES `students` WRITE;
/*!40000 ALTER TABLE `students` DISABLE KEYS */;
INSERT INTO `students` VALUES
(134,'سعید','میرزائی','Saeed','Mirzaei','m','','','09123337718','خیابان وزرا کوچه هفتم (بهمن کشاورز) پلاک 13 طبقه اول واحد 4\r\n\r\nآدرس: تهران، ميدان تجريش، خ دربند، خ اسدالهي (باغ شاطر)، میدان باغ شاطر، خ حسيني، خ رهبر جنوبي ، پلاك ٨، زنگ ٢\r\nکد پستی: 1973835711\r\nتلفن همراه: 09123337718','info@northstarbusiness.ir','','مدرس دانشگاه-کارآفرین','دکتری','1357-03-22','HTML, java script, Css',00000000100,0,10018,'09123337718','1b22dbe6a250b3afbe128c137fb61f83'),
(141,'سعید','اشتاد','Saeed','Eshtad','m','','','09126276625','','saeed.eshtad@gmail.com','','','','','متقاضی شرکت در کلاس آنلاین برنامه نویسی پایتون هستم. با تشکر',00000000100,0,10023,'09126276625','c16f939418362b2e734418b1b5001d5a'),
(147,'امین','ترنجیان ','Amin','Toranjian','m','3873962020','','09188082040','','amin.toranjian@gmail.com','','','','','',00000000100,0,10026,'09188082040','cbb0ca25a486e642c3fd3adc94557127'),
(149,'حامد','کلهری','Hamed','Kalhori','m','3875580321','','09183114663','','ha.kalhori@gmail.com','','','','','',00000000100,0,10025,'09183114663','60a61459abf673f194512e768048b4ab'),
(157,'محمد طه','مصطفوی','Mohammad Taha','Mostafavi','m','3861774755','','09029757023','','tahabehfar@gmail.com','','','','1386-10-06','',00000000100,0,10033,'09029757023','43d1eab2e2ef7cd2a3eb084ac2083af3'),
(158,'پگاه','مقیمی','Pegah','Moghimi','f','3875448537','','09188198299','','pegaahmoghimi@gmail.com','','','','','',00000000100,0,10034,'09188198299','348ce520a113d509e83f2d90e5fc5c8f'),
(165,'زهره','محبیان','Zohreh','Mohebian','f','0520615107','','09186762635','','mehrabanbanoo13@gmail.com','','','','','',00000000100,0,10039,'09186762635','0b13534b5b3be57441886e82a1953efc'),
(166,'نسترن','بختیاری','Nastaran','Bakhtiari','f','3875501950','','09398101900','همدان، سی متری شکریه','Bakhtiyari_87@yahoo.com','','دانشجو','PhD','1366','ندارم',00000000100,0,10042,'09398101900','79554eb05be7d09665d4b84e852d5f22'),
(167,'هما ','قنبری ایلخچی','Homa','Ghanbari Ilchi','f','1700187503','02636648768','09394846879','','homaaghanbarii@gmail.com','','','','1379-03-03','',00000000100,0,10043,'09394846879','0c6f8421158aebe9b81539964fb15827'),
(169,'مهتاب','عابدیان','Mahtab','Abedian',NULL,NULL,'08138251744','09915612426','خ بین النهرین کوچه بختیاری _ساختمان عمران','abedianmahtab@gmail.com','','','مهندسی کامپیوتر- گرایش نرم افزار- دانشگاه پیام نور','1373-11-19','مدرک icdl2/1\r\n\r\n\r\nمدرس نرم افزار اسکرچ و اسکرچ جونیور از سال 1400 تا کنون مشاوره تحصیلی در آموزشگاه قلم چی به مدت ۳ سال\r\nمشاوره تحصیلی پدر آموزشگاه گزینه دو به مدت یک سال\r\n',00000000001,0,10041,'09915612426','956147b08f2b4c5b2626f7035658743d'),
(170,'پریسا','زورپیکر','Parisa','Zoorpeykar',NULL,NULL,'','09185736876','','','','','','','',00000000001,0,10055,'09185736876','a4e8cea6d2cf52a36c523b076650ea93'),
(171,'هاجر','عابدی','Hajar','Abedi',NULL,NULL,'','09186712295','','bahar_7810@yahoo.com','','','','','',00000000001,0,10045,'09186712295','b3f78dc590eed3e41add3dc16302c0a4'),
(173,'لیلا','صفری','Leila','Safari','f',NULL,'','09038563031','کرمانشاه، صحنه، شهرک امام رضا، میدان اول ، خیابان شکوفه۲ \r\n','leilisafari1074@gmail.com','','دانشجو','دانشجوی کارشناسی ارشد','1374-10-10','۰۹۰۳۸۵۶۳۰۳۱',00000000001,0,10040,'09038563031','0fc8c4a4b54ab68796978474d6fecd06'),
(178,'سید محسن','ذوالفقاری','Seyyed Mohsen','Zolfaghari','m','0082157261','','09121394318','','zolfaghari.official@gmail.com','','دانشجو','کارشناسی ارشد ','1365-04-23','خیر',00000000100,0,10050,'09121394318','2ec417941ffd267078329e27dd4756d1'),
(182,'رويا','اقبال زاده ','Roya','Eghbalzadeh','f','4284347421','09125412331','09125412331','تهران ميرداماد ميدان محسنی خ وزيری پور کوچه پيام پلاک 14 واحد 1','eghbalzadehroya@gmail.com','','کارمند','فوق لیسانس اقتصاد ','1359-04-04','',00000000100,0,10054,'09125412331','acce0c6c655c550f070da7c6d30d02e5'),
(183,'حنانه','شبستانی','Hannaneh','Shabestani','f','3861833077','08138269281','09189117147','همدان - شیرسنگی','johnh1544@gmail.com','','دانش آموز','نهم','1387-06-02','python - HTML',00000000100,0,10057,'09189117147','42c51f643c5d954c4aadcfb053557bc3'),
(194,'غزاله','عبدالهی نژاد',NULL,NULL,'f','0321906454','','09352676260','','ghazale.abdollahi@gmail.com','','','','1363-09-04','',00000000100,0,10067,'09352676260','d31595804016d1ecd453a01afba5348c'),
(198,'محمد علی','ترکمان اسدی','Mohammad Ali','Torkaman','m','3875644182','02144276672','09128309568','تهران، جلال آل احمد، خیابان ابراهیمی، ک ستایش 1، پلاک 51، واحد 2','ali.torkaman@live.com','','دانشجو','کارشناسی ارشد','1365-06-15','',00000000100,0,10071,'09128309568','e732ffba56cec65ccd8df9a8f70cd543'),
(199,'محمد جواد','ترکمان اسدی','Mohammad Javad','Torkaman','m','3875644190','02144036560','09183141547','','mj.torkamanasadi@yahoo.com','','','','','',00000000100,0,10072,'09183141547','594662d13e7d98a12035c4b30e980fda'),
(200,'علی','باب الحوائجی','Ali','Babalhavaeji','m',NULL,'','09122066973','','','1402-05-03','','','','',00000000001,0,10076,'09122066973','956f7aba29cac576affca50513d38f89'),
(201,'شیرین','حجی','Shirin','Hadji','f','0150415087','','09102141592','','shirin.haji82@gmail.com','','','','1382-04-18','',00000000100,0,10073,'09102141592','c91009c8f031c7cf658d5b777c501f53'),
(203,'سارینا','سیستانی','Sarina','Sistani','f','1272275361','','09912066170','','Sarina.sis22@gmail.com','','','','','',00000000100,0,10074,'09912066170','73b377cfd5807347c710a295775aa27e'),
(204,'محمدحسن','سیامک','Mohammadhasan','Siamak','m','0372187412','','09101367356','','m.h.siamak96@gmail.com','','','','1375-06-07','',00000000100,0,10077,'09101367356','cc0fdfa7cdb7c5cc7dc720d9bd3e0ba7'),
(213,'سارا','سعیدی فررامی',NULL,NULL,'f','0451651545','02182333147','09123233254','جرذن، خیابان صبا، پلاک ۳۸','Sarasaeidi1984@gmail.com','','کارمند','ارشد مدیریت دولتی- مالی','1363-02-13','',00000000100,0,10085,NULL,NULL);
/*!40000 ALTER TABLE `students` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `students_courses`
--
DROP TABLE IF EXISTS `students_courses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `students_courses` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`student_id` int(11) DEFAULT NULL,
`course_id` int(11) DEFAULT NULL,
`teacher_id` int(11) DEFAULT NULL,
`reg_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`inactive` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `student_id` (`student_id`),
KEY `course_id` (`course_id`),
KEY `teacher_id` (`teacher_id`),
CONSTRAINT `students_courses_ibfk_1` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `students_courses_ibfk_2` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `students_courses_ibfk_3` FOREIGN KEY (`teacher_id`) REFERENCES `teachers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `students_courses`
--
LOCK TABLES `students_courses` WRITE;
/*!40000 ALTER TABLE `students_courses` DISABLE KEYS */;
/*!40000 ALTER TABLE `students_courses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `students_courses_registrations`
--
DROP TABLE IF EXISTS `students_courses_registrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `students_courses_registrations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`student_course_id` int(11) DEFAULT NULL,
`semester_id` int(11) DEFAULT NULL,
`date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`tuition_fee` int(11) DEFAULT NULL,
`tuition_fee_per_session` int(11) NOT NULL,
`tuition_fee_off_percent` int(11) DEFAULT 0,
`teacher_share` int(11) DEFAULT 50,
`comment` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `semester_id` (`semester_id`),
KEY `student_course_id` (`student_course_id`),
CONSTRAINT `students_courses_registrations_ibfk_1` FOREIGN KEY (`semester_id`) REFERENCES `semesters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `students_courses_registrations_ibfk_2` FOREIGN KEY (`student_course_id`) REFERENCES `students_courses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=238 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `students_courses_registrations`
--
LOCK TABLES `students_courses_registrations` WRITE;
/*!40000 ALTER TABLE `students_courses_registrations` DISABLE KEYS */;
/*!40000 ALTER TABLE `students_courses_registrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `students_courses_registrations_payments`
--
DROP TABLE IF EXISTS `students_courses_registrations_payments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `students_courses_registrations_payments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`student_course_registration_id` int(11) DEFAULT NULL,
`payment_amount` int(11) DEFAULT NULL,
`payment_method` int(1) DEFAULT NULL,
`session_numbers` int(11) DEFAULT NULL,
`date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`comment` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `student_course_registration_id` (`student_course_registration_id`),
CONSTRAINT `students_courses_registrations_payments_ibfk_1` FOREIGN KEY (`student_course_registration_id`) REFERENCES `students_courses_registrations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=318 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `students_courses_registrations_payments`
--
LOCK TABLES `students_courses_registrations_payments` WRITE;
/*!40000 ALTER TABLE `students_courses_registrations_payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `students_courses_registrations_payments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `students_courses_schedules`
--
DROP TABLE IF EXISTS `students_courses_schedules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `students_courses_schedules` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`student_course_registration_id` int(11) DEFAULT NULL,
`room_id` int(11) DEFAULT NULL,
`class_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`class_start_time` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`class_duration` int(11) DEFAULT NULL,
`comment` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`class_status` tinyint(1) DEFAULT 0 COMMENT '\r\n0=normal\r\n1=hazer\r\n2=ghayeb\r\n3=cancle',
PRIMARY KEY (`id`),
KEY `room_id` (`room_id`),
KEY `student_course_registration_id` (`student_course_registration_id`),
CONSTRAINT `students_courses_schedules_ibfk_1` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `students_courses_schedules_ibfk_2` FOREIGN KEY (`student_course_registration_id`) REFERENCES `students_courses_registrations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2149 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `students_courses_schedules`
--
LOCK TABLES `students_courses_schedules` WRITE;
/*!40000 ALTER TABLE `students_courses_schedules` DISABLE KEYS */;
/*!40000 ALTER TABLE `students_courses_schedules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Temporary table structure for view `students_courses_schedules_view`
--
DROP TABLE IF EXISTS `students_courses_schedules_view`;
/*!50001 DROP VIEW IF EXISTS `students_courses_schedules_view`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8mb4;
/*!50001 CREATE VIEW `students_courses_schedules_view` AS SELECT
1 AS `course_category_id`,
1 AS `course_id`,
1 AS `course_title`,
1 AS `teacher_id`,
1 AS `teacher_fullname`,
1 AS `class_date`,
1 AS `class_start_time`,
1 AS `class_duration`,
1 AS `class_status` */;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `students_courses_teachers_share`
--
DROP TABLE IF EXISTS `students_courses_teachers_share`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `students_courses_teachers_share` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`student_course_id` int(11) DEFAULT NULL,
`start_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`end_date` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`teacher_share` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `student_course_id` (`student_course_id`),
CONSTRAINT `students_courses_teachers_share_ibfk_1` FOREIGN KEY (`student_course_id`) REFERENCES `students_courses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `students_courses_teachers_share`
--
LOCK TABLES `students_courses_teachers_share` WRITE;
/*!40000 ALTER TABLE `students_courses_teachers_share` DISABLE KEYS */;
/*!40000 ALTER TABLE `students_courses_teachers_share` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `students_courses_teachers_share2`
--
DROP TABLE IF EXISTS `students_courses_teachers_share2`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `students_courses_teachers_share2` (
`id` int(11) NOT NULL DEFAULT 0,
`student_course_id` int(11) DEFAULT NULL,
`start_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`end_date` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`teacher_share` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `students_courses_teachers_share2`
--
LOCK TABLES `students_courses_teachers_share2` WRITE;
/*!40000 ALTER TABLE `students_courses_teachers_share2` DISABLE KEYS */;
INSERT INTO `students_courses_teachers_share2` VALUES
(1,25,'0000-00-00','9999-99-99',50),
(2,26,'0000-00-00','9999-99-99',50),
(3,24,'0000-00-00','9999-99-99',70),
(4,23,'0000-00-00','9999-99-99',50),
(5,30,'0000-00-00','9999-99-99',50),
(6,21,'0000-00-00','9999-99-99',50),
(7,11,'0000-00-00','9999-99-99',50),
(8,33,'0000-00-00','9999-99-99',50),
(9,1,'0000-00-00','9999-99-99',50),
(10,2,'0000-00-00','9999-99-99',50),
(11,34,'0000-00-00','9999-99-99',50),
(12,20,'0000-00-00','9999-99-99',50),
(13,12,'0000-00-00','9999-99-99',50),
(14,32,'0000-00-00','9999-99-99',50),
(15,27,'0000-00-00','9999-99-99',50),
(16,14,'0000-00-00','9999-99-99',50),
(17,28,'0000-00-00','9999-99-99',50),
(18,19,'0000-00-00','9999-99-99',50),
(19,18,'0000-00-00','9999-99-99',50),
(21,10,'0000-00-00','9999-99-99',50),
(22,6,'0000-00-00','9999-99-99',50),
(23,13,'0000-00-00','9999-99-99',50),
(24,29,'0000-00-00','9999-99-99',50),
(26,16,'0000-00-00','9999-99-99',50),
(27,35,'0000-00-00','9999-99-99',50),
(28,36,'0000-00-00','9999-99-99',60),
(29,15,'0000-00-00','9999-99-99',50),
(30,5,'0000-00-00','9999-99-99',50),
(31,31,'0000-00-00','9999-99-99',50),
(33,4,'0000-00-00','9999-99-99',50),
(34,7,'0000-00-00','9999-99-99',50),
(35,37,'0000-00-00','9999-99-99',50),
(36,38,'0000-00-00','9999-99-99',50),
(37,8,'0000-00-00','9999-99-99',50),
(38,39,'0000-00-00','9999-99-99',100),
(41,40,'0000-00-00','9999-99-99',50),
(42,41,'0000-00-00','9999-99-99',50),
(43,42,'0000-00-00','9999-99-99',50),
(44,43,'0000-00-00','9999-99-99',50),
(45,44,'0000-00-00','9999-99-99',100),
(46,45,'0000-00-00','9999-99-99',100),
(47,46,'0000-00-00','9999-99-99',50),
(49,47,'0000-00-00','9999-99-99',50),
(52,3,'0000-00-00','9999-99-99',50),
(60,48,'0000-00-00','9999-99-99',50),
(61,49,'0000-00-00','9999-99-99',50),
(63,50,'0000-00-00','9999-99-99',50),
(64,22,'0000-00-00','9999-99-99',50),
(66,52,'0000-00-00','9999-99-99',50),
(68,53,'0000-00-00','9999-99-99',50),
(69,54,'0000-00-00','9999-99-99',50),
(70,55,'0000-00-00','9999-99-99',50),
(73,56,'0000-00-00','9999-99-99',50),
(75,57,'0000-00-00','9999-99-99',50),
(82,51,'0000-00-00','9999-99-99',60),
(87,9,'0000-00-00','9999-99-99',50),
(89,58,'0000-00-00','9999-99-99',50),
(90,59,'0000-00-00','1394-05-31',100),
(91,60,'0000-00-00','9999-99-99',50),
(92,61,'0000-00-00','1394-05-31',100),
(93,63,'0000-00-00','9999-99-99',50),
(94,64,'0000-00-00','9999-99-99',60),
(95,65,'0000-00-00','9999-99-99',60),
(96,66,'0000-00-00','9999-99-99',60),
(97,67,'0000-00-00','9999-99-99',60),
(98,68,'0000-00-00','1394-05-31',100),
(99,69,'0000-00-00','9999-99-99',60),
(100,70,'0000-00-00','9999-99-99',50),
(101,71,'0000-00-00','9999-99-99',60),
(102,73,'0000-00-00','9999-99-99',50),
(103,74,'0000-00-00','9999-99-99',60),
(104,72,'0000-00-00','9999-99-99',60),
(105,76,'0000-00-00','9999-99-99',50),
(106,75,'0000-00-00','9999-99-99',50),
(107,78,'0000-00-00','9999-99-99',50),
(109,80,'0000-00-00','9999-99-99',60),
(110,81,'0000-00-00','9999-99-99',60),
(111,59,'1394-06-01','9999-99-99',60),
(128,68,'1394-06-01','9999-99-99',60),
(129,61,'1394-06-01','9999-99-99',60),
(130,84,'0000-00-00','9999-99-99',0),
(131,82,'0000-00-00','9999-99-99',50),
(132,83,'0000-00-00','9999-99-99',60),
(133,65,'1394-07-06','',60),
(134,85,'0000-00-00','9999-99-99',50),
(135,69,'','',0),
(136,86,'1394-07-20','9999-99-99',60),
(137,87,'0000-00-00','9999-99-99',50),
(138,88,'0000-00-00','9999-99-99',60),
(139,88,'','',0),
(140,88,'','',0);
/*!40000 ALTER TABLE `students_courses_teachers_share2` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `students_courses_teachers_share_back`
--
DROP TABLE IF EXISTS `students_courses_teachers_share_back`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `students_courses_teachers_share_back` (
`id` int(11) NOT NULL DEFAULT 0,
`student_course_id` int(11) DEFAULT NULL,
`start_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`end_date` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`teacher_share` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `students_courses_teachers_share_back`
--
LOCK TABLES `students_courses_teachers_share_back` WRITE;
/*!40000 ALTER TABLE `students_courses_teachers_share_back` DISABLE KEYS */;
INSERT INTO `students_courses_teachers_share_back` VALUES
(1,25,'0000-00-00','9999-99-99',50),
(2,26,'0000-00-00','9999-99-99',50),
(3,24,'0000-00-00','9999-99-99',70),
(4,23,'0000-00-00','9999-99-99',50),
(5,30,'0000-00-00','9999-99-99',50),
(6,21,'0000-00-00','9999-99-99',50),
(7,11,'0000-00-00','9999-99-99',50),
(8,33,'0000-00-00','9999-99-99',50),
(9,1,'0000-00-00','9999-99-99',50),
(10,2,'0000-00-00','9999-99-99',50),
(11,34,'0000-00-00','9999-99-99',50),
(12,20,'0000-00-00','9999-99-99',50),
(13,12,'0000-00-00','9999-99-99',50),
(14,32,'0000-00-00','9999-99-99',50),
(15,27,'0000-00-00','9999-99-99',50),
(16,14,'0000-00-00','9999-99-99',50),
(17,28,'0000-00-00','9999-99-99',50),
(18,19,'0000-00-00','9999-99-99',50),
(19,18,'0000-00-00','9999-99-99',50),
(20,18,'0000-00-00','9999-99-99',50),
(21,10,'0000-00-00','9999-99-99',50),
(22,6,'0000-00-00','9999-99-99',50),
(23,13,'0000-00-00','9999-99-99',50),
(24,29,'0000-00-00','9999-99-99',50),
(25,13,'0000-00-00','9999-99-99',50),
(26,16,'0000-00-00','9999-99-99',50),
(27,35,'0000-00-00','9999-99-99',50),
(28,36,'0000-00-00','9999-99-99',60),
(29,15,'0000-00-00','9999-99-99',50),
(30,5,'0000-00-00','9999-99-99',50),
(31,31,'0000-00-00','9999-99-99',50),
(32,25,'0000-00-00','9999-99-99',50),
(33,4,'0000-00-00','9999-99-99',50),
(34,7,'0000-00-00','9999-99-99',50),
(35,37,'0000-00-00','9999-99-99',50),
(36,38,'0000-00-00','9999-99-99',50),
(37,8,'0000-00-00','9999-99-99',50),
(38,39,'0000-00-00','9999-99-99',100),
(39,11,'0000-00-00','9999-99-99',50),
(40,14,'0000-00-00','9999-99-99',50),
(41,40,'0000-00-00','9999-99-99',50),
(42,41,'0000-00-00','9999-99-99',50),
(43,42,'0000-00-00','9999-99-99',50),
(44,43,'0000-00-00','9999-99-99',50),
(45,44,'0000-00-00','9999-99-99',100),
(46,45,'0000-00-00','9999-99-99',100),
(47,46,'0000-00-00','9999-99-99',50),
(48,21,'0000-00-00','9999-99-99',50),
(49,47,'0000-00-00','9999-99-99',50),
(50,4,'0000-00-00','9999-99-99',50),
(51,7,'0000-00-00','9999-99-99',50),
(52,3,'0000-00-00','9999-99-99',50),
(53,3,'0000-00-00','9999-99-99',50),
(54,5,'0000-00-00','9999-99-99',50),
(55,20,'0000-00-00','9999-99-99',50),
(56,10,'0000-00-00','9999-99-99',50),
(57,15,'0000-00-00','9999-99-99',50),
(58,19,'0000-00-00','9999-99-99',50),
(59,6,'0000-00-00','9999-99-99',50),
(60,48,'0000-00-00','9999-99-99',50),
(61,49,'0000-00-00','9999-99-99',50),
(62,29,'0000-00-00','9999-99-99',50),
(63,50,'0000-00-00','9999-99-99',50),
(64,22,'0000-00-00','9999-99-99',50),
(65,22,'0000-00-00','9999-99-99',50),
(66,52,'0000-00-00','9999-99-99',50),
(67,12,'0000-00-00','9999-99-99',50),
(68,53,'0000-00-00','9999-99-99',50),
(69,54,'0000-00-00','9999-99-99',50),
(70,55,'0000-00-00','9999-99-99',50),
(71,26,'0000-00-00','9999-99-99',50),
(72,36,'0000-00-00','9999-99-99',60),
(73,56,'0000-00-00','9999-99-99',50),
(74,31,'0000-00-00','9999-99-99',50),
(75,57,'0000-00-00','9999-99-99',50),
(76,28,'0000-00-00','9999-99-99',50),
(77,29,'0000-00-00','9999-99-99',50),
(78,31,'0000-00-00','9999-99-99',50),
(79,27,'0000-00-00','9999-99-99',50),
(80,47,'0000-00-00','9999-99-99',50),
(81,32,'0000-00-00','9999-99-99',50),
(82,51,'0000-00-00','9999-99-99',60),
(83,43,'0000-00-00','9999-99-99',50),
(84,55,'0000-00-00','9999-99-99',50),
(85,8,'0000-00-00','9999-99-99',50),
(86,32,'0000-00-00','9999-99-99',50),
(87,9,'0000-00-00','9999-99-99',50),
(88,9,'0000-00-00','9999-99-99',50),
(89,58,'0000-00-00','9999-99-99',50),
(90,59,'0000-00-00','1394-05-31',100),
(91,60,'0000-00-00','9999-99-99',50),
(92,61,'0000-00-00','1394-05-31',100),
(93,63,'0000-00-00','9999-99-99',50),
(94,64,'0000-00-00','9999-99-99',60),
(95,65,'0000-00-00','9999-99-99',60),
(96,66,'0000-00-00','9999-99-99',60),
(97,67,'0000-00-00','9999-99-99',60),
(98,68,'0000-00-00','1394-05-31',100),
(99,69,'0000-00-00','9999-99-99',60),
(100,70,'0000-00-00','9999-99-99',50),
(101,71,'0000-00-00','9999-99-99',60),
(102,73,'0000-00-00','9999-99-99',50),
(103,74,'0000-00-00','9999-99-99',60),
(104,72,'0000-00-00','9999-99-99',60),
(105,76,'0000-00-00','9999-99-99',50),
(106,75,'0000-00-00','9999-99-99',50),
(107,78,'0000-00-00','9999-99-99',50),
(108,64,'0000-00-00','9999-99-99',60),
(109,80,'0000-00-00','9999-99-99',60),
(110,81,'0000-00-00','9999-99-99',60),
(111,59,'1394-06-01','9999-99-99',60),
(128,68,'1394-06-01','9999-99-99',60),
(129,61,'1394-06-01','9999-99-99',60);
/*!40000 ALTER TABLE `students_courses_teachers_share_back` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Temporary table structure for view `students_goods_view`
--
DROP TABLE IF EXISTS `students_goods_view`;
/*!50001 DROP VIEW IF EXISTS `students_goods_view`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8mb4;
/*!50001 CREATE VIEW `students_goods_view` AS SELECT
1 AS `student_id`,
1 AS `student_firstname`,
1 AS `student_lastname`,
1 AS `invoice_date`,
1 AS `good_id`,
1 AS `good_name`,
1 AS `good_number`,
1 AS `good_price`,
1 AS `total_price`,
1 AS `good_is_gift` */;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `students_login_log`
--
DROP TABLE IF EXISTS `students_login_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `students_login_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`student_id` int(11) NOT NULL,
`date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`time` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_students_login_log_user_id` (`student_id`),
CONSTRAINT `FK_students_login_log_user_id` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `students_login_log`
--
LOCK TABLES `students_login_log` WRITE;
/*!40000 ALTER TABLE `students_login_log` DISABLE KEYS */;
INSERT INTO `students_login_log` VALUES
(1,157,'1401-04-12','14:47:44'),
(2,157,'1401-04-12','14:49:02'),
(3,157,'1401-04-12','14:49:04'),
(4,157,'1401-04-12','15:02:24'),
(5,157,'1401-04-12','15:04:03'),
(6,134,'1402-04-11','20:20:59'),
(7,141,'1402-04-15','17:44:45'),
(8,141,'1402-04-15','17:44:55'),
(9,134,'1402-04-16','12:46:27'),
(10,134,'1402-04-16','12:50:39'),
(11,134,'1402-04-16','12:54:38'),
(12,134,'1402-04-16','12:55:27'),
(13,134,'1402-04-16','12:56:13'),
(14,141,'1402-04-17','16:23:02'),
(15,141,'1402-04-17','17:21:43'),
(16,141,'1402-04-20','14:14:45'),
(17,201,'1402-05-24','11:06:08'),
(18,141,'1402-05-27','21:01:05'),
(19,203,'1402-05-28','16:55:28'),
(20,141,'1402-05-28','16:56:21'),
(21,141,'1402-09-11','12:14:53'),
(22,141,'1402-09-11','12:22:19'),
(23,141,'1402-09-11','12:22:21'),
(24,141,'1402-09-11','12:22:23'),
(25,141,'1402-09-11','16:24:41'),
(26,141,'1402-09-11','16:45:51'),
(27,141,'1402-09-11','16:48:32'),
(28,141,'1402-09-11','16:50:17'),
(29,141,'1402-09-12','14:54:41'),
(30,141,'1402-10-13','16:27:48'),
(31,141,'1402-10-13','16:39:25'),
(32,203,'1402-10-13','18:54:33'),
(33,141,'1402-10-14','13:44:31'),
(34,178,'1403-01-06','20:41:39'),
(35,178,'1403-01-06','20:41:52'),
(36,203,'1403-01-11','19:12:47'),
(37,141,'1403-01-11','19:13:03'),
(38,141,'1403-01-11','19:13:20'),
(39,141,'1403-01-30','17:18:53'),
(40,141,'1403-02-26','19:41:17'),
(41,141,'1403-03-07','23:58:59'),
(42,141,'1403-03-08','00:03:47'),
(43,141,'1403-03-08','00:10:35'),
(44,141,'1403-04-21','11:04:56'),
(45,141,'1403-04-24','19:42:13'),
(46,141,'1403-04-24','20:39:08'),
(47,141,'1403-04-27','20:37:32'),
(48,141,'1403-05-05','17:16:52'),
(49,200,'1403-08-01','21:44:01'),
(50,198,'1403-08-04','17:51:48'),
(51,199,'1403-08-05','12:03:41'),
(52,199,'1403-08-15','11:51:54'),
(53,199,'1403-08-15','13:34:40'),
(54,141,'1403-08-30','00:25:10'),
(55,141,'1403-08-30','00:28:00'),
(56,141,'1403-10-01','23:58:43'),
(57,141,'1403-11-01','12:38:49'),
(58,141,'1403-12-30','14:43:51'),
(59,141,'1403-12-30','17:50:10');
/*!40000 ALTER TABLE `students_login_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `teachers`
--
DROP TABLE IF EXISTS `teachers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teachers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`firstname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`lastname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`tel` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`mobile` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`reg_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`job` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`education` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`birth_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`IT_history` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`account_info` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`operator_id` int(11) DEFAULT NULL,
`cooperate_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`teacher_tuition_share` int(11) DEFAULT 30,
`moodle_user_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `teachers`
--
LOCK TABLES `teachers` WRITE;
/*!40000 ALTER TABLE `teachers` DISABLE KEYS */;
INSERT INTO `teachers` VALUES
(10,'مسعود','نیکوفر','','09122736253','همدان','masoud.nikoofar@gmail.com','','مشاور','فوق لیسانس سخت افزار','1365-11-19','بیش از 10 سال','اقتصاد نوین',1,'1400-10-12',30,10014),
(11,'سیدمرتضی','دزفولیان','','09186129765','','morteza@gmail.com','','','','','','',1,'',30,10022),
(12,'مهتاب','عابدیان','08138251744','09915612426','خ بین النهرین کوچه بختیاری _ساختمان عمران','abedianmahtab@gmail.com','','','مهندسی کامپیوتر- گرایش نرم افزار- دانشگاه پیام نور','1373-11-19','مدرک icdl2/1\r\n\r\n\r\nمدرس نرم افزار اسکرچ و اسکرچ جونیور از سال 1400 تا کنون مشاوره تحصیلی در آموزشگاه قلم چی به مدت ۳ سال\r\nمشاوره تحصیلی پدر آموزشگاه گزینه دو به مدت یک سال\r\n','6037997542206835\r\nIR15017000000022514765804\r\nحساب: 0225147658004 بانک ملی',1,'',30,10041),
(13,'پریسا','زورپیکر','','09185736876','','','','','','','','',1,'',30,10055),
(14,'هاجر','عابدی','','09186712295','','bahar_7810@yahoo.com','','','','','','',1,'',30,10045),
(15,'داوود','فدایی','','09366098455','تهران','','','شبکه','','','','',1,'',30,NULL),
(16,'الناز','گیو','08138243483','09183131769','میدان بیمه،بلوار اسلامیان،۱۸متری فجر،مجتمع الماس،واحد۱۰','elnaz.giv.eg@gmail.com','','کارشناس فناوری مدرسه غیردولتی','مهندسی IT','1368-03-28','','',1,'',30,10044),
(17,'لیلا','صفری','','09038563031','کرمانشاه، صحنه، شهرک امام رضا، میدان اول ، خیابان شکوفه۲ \r\n','leilisafari1074@gmail.com','','دانشجو','دانشجوی کارشناسی ارشد','1374-10-10','۰۹۰۳۸۵۶۳۰۳۱','5859831186515846\r\nIR15018000008737585124\r\nبانک تجارت',1,'',30,10040),
(18,'حسین','صمدیان','','','','','','','','','','',1,'',30,NULL);
/*!40000 ALTER TABLE `teachers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `teachers_courses`
--
DROP TABLE IF EXISTS `teachers_courses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teachers_courses` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`teacher_id` int(11) DEFAULT NULL,
`course_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `teacher_id` (`teacher_id`),
KEY `course_id` (`course_id`),
CONSTRAINT `teachers_courses_ibfk_1` FOREIGN KEY (`teacher_id`) REFERENCES `teachers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `teachers_courses_ibfk_2` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `teachers_courses`
--
LOCK TABLES `teachers_courses` WRITE;
/*!40000 ALTER TABLE `teachers_courses` DISABLE KEYS */;
/*!40000 ALTER TABLE `teachers_courses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `teachers_payments`
--
DROP TABLE IF EXISTS `teachers_payments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teachers_payments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`teacher_id` int(11) NOT NULL,
`semester_id` int(11) DEFAULT NULL,
`class_date_month` varchar(7) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`payment_info` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`payment_date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`payment_type` tinyint(1) DEFAULT NULL,
`comment` text CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `teachers_payments`
--
LOCK TABLES `teachers_payments` WRITE;
/*!40000 ALTER TABLE `teachers_payments` DISABLE KEYS */;
INSERT INTO `teachers_payments` VALUES
(1,3,2,'1394-04','141921','1394-04-29',2,''),
(2,3,2,'1394-05','57674','1394-05-25',2,''),
(3,2,2,'1394-05','962799','1394-05-26',2,''),
(4,9,2,'1394-05','97674','1394-05-26',2,''),
(5,4,2,'1394-05','305635','1394-05-26',2,''),
(6,5,2,'1394-05','53570','1394-06-02',2,'مبلغ 900000 ریال بابت کلاس درناز و دلناز پازری به حقوق مرداد ماه اضافه شد. شماره پیگیری رسید قبلی 808930 مبلغ 2200000 ریال'),
(7,6,2,'1394-05','448780','1394-05-28',2,''),
(8,8,2,'1394-05','','1394-05-28',1,''),
(9,6,2,'1394-06','','1394-06-28',1,''),
(10,8,2,'1394-06','668753','1394-06-28',2,'یک جلسه بابت کلاس هنگامه مشهدی در تاریخ 94/5/28 به مبلغ فوق اضافه شده است. مبلغ پرداخت شده 3150000 ریال میباشد.'),
(11,3,2,'1394-06','58690','1394-06-29',2,''),
(12,4,2,'1394-06','131703','1394-06-29',2,''),
(13,2,2,'1394-06','667100','1394-06-29',2,'یک جلسه آقای احمدیان در مرداد ماه به مبلغ شهریور اضافه شده است.مبلغ پرداختی 3900000 ریال میباشد.'),
(14,9,2,'1394-06','292809','1394-06-29',2,'مبلغ 750000 ریال بابت 6 جلسه کلاس تمبک از مبلغ شهریور ماه کم شده است. مبلغ پرداختی 1950000 ریال میباشد. 5/26 جلسه اول به اضافه پنج جلسه در شهریور'),
(15,5,2,'1394-06','541758','1394-06-29',2,''),
(16,2,3,'1394-07','515792','1394-07-27',2,''),
(17,4,3,'1394-07','945887','1394-07-27',2,''),
(18,5,3,'1394-07','87789','1394-07-27',2,''),
(19,9,3,'1394-07','212733','1394-07-27',2,'مبلغ واریز شده 157500 تومان است که 12500 تومان بابت یک جلسه تمبک کسر شده و مبلغ 20000 تومان بابت جزوه هارمونیکا به این مبلغ اضافه شده است.'),
(20,6,3,'1394-07','316776','1394-07-27',2,''),
(21,8,3,'1394-07','597552','1394-07-27',2,''),
(22,9,3,'1394-08','536684','1394-08-25',2,'مبلغ 40000 تومان بابت جزوه گیتار اضافه شده است.مبلغ پرداختی 430000 تومان میباشد.'),
(23,6,3,'1394-08','294719','1394-08-27',2,'25000 تومان بابت ماه قبل اضافه میگردد.مبلغ 175000 تومان واریز شد.'),
(24,4,3,'1394-08','937719','1394-08-17',2,''),
(25,2,3,'1394-08','368749','1394-08-25',2,''),
(26,3,3,'1394-08','694551','1394-08-25',2,''),
(27,9,3,'1394-09','','',0,'2 جلسه شهریه آبان تمبک معادل 25000 تومان کسر شود. مبلغ 20000 تومان بابت جزوه گیتار اضافه شود'),
(28,5,3,'1394-08','264787','1394-09-03',2,''),
(29,8,3,'1394-08','32536','1394-08-27',2,'');
/*!40000 ALTER TABLE `teachers_payments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fullname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`user` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`pass` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`level` tinyint(4) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(1,'Administrator','admin','c4ca4238a0b923820dcc509a6f75849b',1),
(2,'مسعود نیکوفر','masoud','15d3e3dfcd4151d8258978ebcb801d5a',1),
(3,'محمدرضا نیکوفر','',NULL,0),
(4,'مریم نیکوفر',NULL,NULL,0),
(100,'کاربر وب سایت','website','c4ca4238a0b923820dcc509a6f75849b',1),
(104,'Mohammad Jalali','mohammad','c4ca4238a0b923820dcc509a6f75849b',1);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users_login_log`
--
DROP TABLE IF EXISTS `users_login_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users_login_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`date` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`time` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci DEFAULT NULL,
`ip_address` varchar(15) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_users_login_log_user_id` (`user_id`),
CONSTRAINT `FK_users_login_log_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=502 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_login_log`
--
LOCK TABLES `users_login_log` WRITE;
/*!40000 ALTER TABLE `users_login_log` DISABLE KEYS */;
INSERT INTO `users_login_log` VALUES
(331,1,'1400-10-12','16:22:43',NULL),
(332,1,'1400-10-12','22:50:44',NULL),
(333,1,'1400-10-13','16:37:39',NULL),
(334,1,'1400-10-20','00:13:46',NULL),
(335,1,'1400-10-22','18:47:28',NULL),
(336,1,'1400-10-24','11:15:07',NULL),
(337,1,'1400-10-28','16:20:58',NULL),
(338,1,'1400-11-02','22:09:19',NULL),
(339,1,'1400-11-02','22:49:14',NULL),
(340,1,'1400-11-17','10:04:05',NULL),
(341,1,'1400-11-17','17:45:52',NULL),
(342,1,'1400-11-26','21:47:09',NULL),
(343,1,'1400-11-28','22:33:51',NULL),
(344,1,'1400-11-30','22:35:03',NULL),
(345,1,'1400-12-01','00:14:12',NULL),
(346,1,'1400-12-01','00:14:12',NULL),
(347,1,'1400-12-07','19:11:24',NULL),
(348,1,'1400-12-08','22:52:09',NULL),
(349,1,'1400-12-11','23:38:17',NULL),
(350,1,'1400-12-12','21:57:55',NULL),
(351,1,'1400-12-15','13:09:59',NULL),
(352,1,'1400-12-18','19:09:51',NULL),
(353,1,'1400-12-20','11:43:49',NULL),
(354,1,'1400-12-22','00:16:39',NULL),
(355,1,'1400-12-24','09:59:30',NULL),
(356,1,'1400-12-25','23:02:24',NULL),
(357,1,'1401-01-02','10:21:15',NULL),
(358,1,'1401-01-05','15:13:43',NULL),
(359,1,'1401-01-10','22:05:29',NULL),
(360,1,'1401-01-12','14:27:57',NULL),
(361,1,'1401-01-18','11:39:50',NULL),
(362,1,'1401-01-21','11:01:25',NULL),
(363,1,'1401-01-23','00:04:50',NULL),
(364,1,'1401-01-27','21:46:10',NULL),
(365,1,'1401-01-28','00:58:48',NULL),
(366,1,'1401-02-02','23:30:58',NULL),
(367,1,'1401-02-03','02:43:28',NULL),
(368,1,'1401-02-06','15:09:52',NULL),
(369,1,'1401-02-07','00:39:43',NULL),
(370,1,'1401-02-10','21:13:00',NULL),
(371,1,'1401-02-11','11:52:02',NULL),
(372,1,'1401-02-12','19:39:30',NULL),
(373,1,'1401-02-16','19:31:30',NULL),
(374,1,'1401-02-18','08:59:02',NULL),
(375,1,'1401-02-24','17:09:19',NULL),
(376,1,'1401-02-24','18:05:26',NULL),
(377,1,'1401-02-25','14:42:47',NULL),
(378,1,'1401-02-26','21:47:50',NULL),
(379,1,'1401-02-29','07:11:23',NULL),
(380,1,'1401-02-30','23:58:37',NULL),
(381,1,'1401-02-31','21:51:55',NULL),
(382,1,'1401-03-01','16:00:28',NULL),
(383,1,'1401-03-09','20:07:23',NULL),
(384,1,'1401-03-12','08:00:51',NULL),
(385,1,'1401-03-12','16:58:58',NULL),
(386,1,'1401-03-25','19:00:59',NULL),
(387,1,'1401-03-27','18:37:53',NULL),
(388,1,'1401-03-27','18:49:02',NULL),
(389,1,'1401-03-31','08:00:18',NULL),
(390,1,'1401-04-06','08:53:55',NULL),
(391,1,'1401-04-11','13:10:55',NULL),
(392,1,'1401-04-14','00:36:19',NULL),
(393,1,'1401-04-14','11:01:50',NULL),
(394,1,'1401-04-16','22:10:54',NULL),
(395,1,'1401-04-17','13:12:18',NULL),
(396,1,'1401-05-01','15:50:25',NULL),
(397,1,'1401-05-03','10:37:49',NULL),
(398,1,'1401-05-06','00:06:40',NULL),
(399,1,'1401-05-15','09:05:09',NULL),
(400,1,'1401-05-22','17:03:10',NULL),
(401,1,'1401-05-23','14:51:27',NULL),
(402,1,'1401-05-31','13:31:28',NULL),
(403,1,'1401-06-02','12:31:04',NULL),
(404,1,'1401-06-20','18:33:51',NULL),
(405,1,'1401-07-11','20:01:51',NULL),
(406,1,'1401-07-16','10:07:09',NULL),
(407,1,'1401-07-18','07:41:47',NULL),
(408,1,'1401-07-23','20:02:22',NULL),
(409,1,'1401-07-25','15:31:21',NULL),
(410,1,'1401-08-20','09:31:12',NULL),
(411,1,'1401-08-23','23:24:26',NULL),
(412,1,'1401-08-24','15:51:51',NULL),
(413,1,'1401-08-24','16:18:51',NULL),
(414,1,'1401-09-13','18:51:33',NULL),
(415,1,'1401-09-19','23:31:49',NULL),
(416,1,'1401-09-20','17:27:07',NULL),
(417,1,'1401-10-06','09:24:35',NULL),
(418,1,'1401-10-07','08:40:01',NULL),
(419,1,'1401-10-10','14:26:25',NULL),
(420,1,'1401-11-13','20:55:49',NULL),
(421,1,'1401-11-30','23:23:08',NULL),
(422,1,'1401-12-28','00:07:42',NULL),
(423,104,'1401-12-28','00:20:01',NULL),
(424,1,'1402-02-06','15:16:46',NULL),
(425,1,'1402-02-06','15:22:08',NULL),
(426,1,'1402-02-09','16:46:55',NULL),
(427,1,'1402-02-17','16:19:06',NULL),
(428,1,'1402-02-17','22:20:07',NULL),
(429,1,'1402-03-02','11:17:20',NULL),
(430,1,'1402-03-10','15:50:30',NULL),
(431,1,'1402-03-11','20:14:06',NULL),
(432,1,'1402-03-21','14:43:37',NULL),
(433,1,'1402-04-04','14:22:41',NULL),
(434,1,'1402-04-05','19:16:02',NULL),
(435,1,'1402-04-08','23:24:52',NULL),
(436,1,'1402-04-28','15:36:49',NULL),
(437,1,'1402-05-03','21:55:50',NULL),
(438,1,'1402-05-07','20:10:03',NULL),
(439,1,'1402-05-22','15:20:10',NULL),
(440,1,'1402-05-25','18:51:41',NULL),
(441,1,'1402-05-27','20:49:02',NULL),
(442,1,'1402-06-01','13:16:43',NULL),
(443,1,'1402-06-13','00:04:54',NULL),
(444,1,'1402-06-27','16:16:17',NULL),
(445,1,'1402-07-03','13:16:09',NULL),
(446,1,'1402-07-03','14:38:27',NULL),
(447,1,'1402-07-24','11:12:55',NULL),
(448,1,'1402-08-01','11:42:49',NULL),
(449,1,'1402-08-02','19:12:15',NULL),
(450,1,'1402-08-09','20:22:00',NULL),
(451,1,'1402-08-22','17:03:49',NULL),
(452,1,'1402-08-22','20:01:30',NULL),
(453,1,'1402-08-22','23:57:25',NULL),
(454,1,'1402-08-23','13:36:56',NULL),
(455,1,'1402-08-24','22:05:37',NULL),
(456,1,'1402-09-04','15:02:32',NULL),
(457,1,'1402-09-07','11:36:14',NULL),
(458,1,'1402-09-11','14:47:04',NULL),
(459,1,'1402-09-13','21:09:05',NULL),
(460,1,'1402-09-14','08:58:38',NULL),
(461,1,'1402-09-24','15:25:32',NULL),
(462,1,'1402-10-13','11:02:26',NULL),
(463,1,'1402-10-14','13:41:21',NULL),
(464,1,'1402-10-24','00:31:09',NULL),
(465,1,'1402-11-23','16:41:12',NULL),
(466,1,'1402-11-23','16:41:14',NULL),
(467,1,'1402-12-13','08:53:36',NULL),
(468,1,'1403-01-02','12:27:34',NULL),
(469,1,'1403-01-06','20:15:39',NULL),
(470,1,'1403-01-08','20:24:43',NULL),
(471,1,'1403-01-30','15:41:24',NULL),
(472,1,'1403-01-30','17:14:45',NULL),
(473,1,'1403-02-17','10:48:17',NULL),
(474,1,'1403-02-26','19:40:34',NULL),
(475,1,'1403-03-07','16:54:06',NULL),
(476,1,'1403-03-21','09:36:38',NULL),
(477,1,'1403-04-16','11:46:32',NULL),
(478,1,'1403-04-18','09:49:51',NULL),
(479,1,'1403-04-19','14:50:04',NULL),
(480,1,'1403-04-21','08:57:57',NULL),
(481,1,'1403-04-25','19:42:25',NULL),
(482,1,'1403-05-01','20:42:13',NULL),
(483,1,'1403-05-03','16:06:40',NULL),
(484,1,'1403-05-29','11:20:15',NULL),
(485,1,'1403-07-12','12:57:45',NULL),
(486,1,'1403-08-01','21:39:31',NULL),
(487,1,'1403-08-30','00:23:51',NULL),
(488,1,'1403-10-23','21:53:50',NULL),
(489,1,'1403-11-01','12:30:59',NULL),
(490,1,'1403-12-05','10:27:56',NULL),
(491,1,'1403-12-06','10:12:34',NULL),
(492,1,'1403-12-30','12:43:51',NULL),
(493,1,'1404-01-16','17:31:21',NULL),
(494,1,'1404-01-17','19:54:35',NULL),
(495,1,'1404-01-20','17:14:58',NULL),
(496,1,'1404-04-11','08:29:34',NULL),
(497,1,'1404-04-17','08:45:11',NULL),
(498,1,'1404-09-05','16:15:05',NULL),
(499,1,'1404-10-14','17:22:46',NULL),
(500,1,'1404-10-14','17:44:04',NULL),
(501,1,'1404-10-16','16:19:05',NULL);
/*!40000 ALTER TABLE `users_login_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Final view structure for view `invoices_goods_view`
--
/*!50001 DROP VIEW IF EXISTS `invoices_goods_view`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = cp850 */;
/*!50001 SET character_set_results = cp850 */;
/*!50001 SET collation_connection = cp850_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `invoices_goods_view` AS select `a`.`buyer_id` AS `buyer_id`,if(`a`.`is_student` = 1,`c`.`firstname`,convert(`e`.`firstname` using utf8mb3)) AS `buyer_firstname`,if(`a`.`is_student` = 1,`c`.`lastname`,convert(`e`.`lastname` using utf8mb3)) AS `buyer_lastname`,`a`.`date` AS `invoice_date`,`b`.`good_id` AS `good_id`,`d`.`name` AS `good_name`,`b`.`number` AS `good_number`,`b`.`price` AS `good_price`,`b`.`price` * `b`.`number` AS `total_price`,`b`.`is_gift` AS `good_is_gift` from ((((`invoices` `a` join `invoices_goods` `b` on(`a`.`id` = `b`.`invoice_id`)) join `goods` `d` on(`b`.`good_id` = `d`.`id`)) left join `students` `c` on(`c`.`id` = `a`.`buyer_id`)) left join `buyers` `e` on(`e`.`id` = `a`.`buyer_id`)) */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
--
-- Final view structure for view `students_courses_schedules_view`
--
/*!50001 DROP VIEW IF EXISTS `students_courses_schedules_view`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = latin1 */;
/*!50001 SET character_set_results = latin1 */;
/*!50001 SET collation_connection = latin1_swedish_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `students_courses_schedules_view` AS select `a`.`category_id` AS `course_category_id`,`a`.`id` AS `course_id`,`a`.`title` AS `course_title`,`a`.`teacher_id` AS `teacher_id`,concat(`b`.`firstname`,' ',`b`.`lastname`) AS `teacher_fullname`,`c`.`class_date` AS `class_date`,`c`.`class_start_time` AS `class_start_time`,`c`.`class_duration` AS `class_duration`,`c`.`class_status` AS `class_status` from ((`courses` `a` join `teachers` `b`) join `courses_sessions` `c`) where `a`.`id` = `c`.`course_id` and `a`.`teacher_id` = `b`.`id` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
--
-- Final view structure for view `students_goods_view`
--
/*!50001 DROP VIEW IF EXISTS `students_goods_view`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = cp850 */;
/*!50001 SET character_set_results = cp850 */;
/*!50001 SET collation_connection = cp850_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `students_goods_view` AS select `a`.`buyer_id` AS `student_id`,`c`.`firstname` AS `student_firstname`,`c`.`lastname` AS `student_lastname`,`a`.`date` AS `invoice_date`,`b`.`good_id` AS `good_id`,`d`.`name` AS `good_name`,`b`.`number` AS `good_number`,`b`.`price` AS `good_price`,`b`.`price` * `b`.`number` AS `total_price`,`b`.`is_gift` AS `good_is_gift` from (((`invoices` `a` join `invoices_goods` `b`) join `students` `c`) join `goods` `d`) where `a`.`id` = `b`.`invoice_id` and `b`.`good_id` = `d`.`id` and `a`.`buyer_id` = `c`.`id` and `a`.`is_student` = 1 */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2026-05-17 14:56:44