Student Management Basic Project
##Demo Screen
User signs up/ signs in with credentials User CRUD account, attendance,class,department,score,student,subject
-- Host: 127.0.0.1 Database: student_management
-- Server version 8.0.32
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
/!50503 SET NAMES utf8 /;
/!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 */;
activitiesDROP TABLE IF EXISTS activities;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE activities (
id int NOT NULL AUTO_INCREMENT,
creator int DEFAULT NULL,
name varchar(45) DEFAULT NULL,
description varchar(1045) DEFAULT NULL,
image varchar(1045) DEFAULT NULL,
location varchar(60) DEFAULT NULL,
num_of_volunteers int DEFAULT NULL,
max_of_volunteers int DEFAULT NULL,
from_at date DEFAULT NULL,
to_at date DEFAULT NULL,
status int DEFAULT '0',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
activitiesLOCK TABLES activities WRITE;
/*!40000 ALTER TABLE activities DISABLE KEYS /;
INSERT INTO activities VALUES (1,1,'Activity Test','Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32.','https://t3.ftcdn.net/jpg/00/72/98/56/360_F_72985661_LU1Xk0YQiPBwOuesuuJgwTn0NPlwP8ob.jpg','Hai Phong',0,50,'2023-12-02','2024-12-02',1,'2023-12-02 01:18:19','2023-12-02 01:18:19'),(2,3,'Activity Demo','Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32.','https://t3.ftcdn.net/jpg/00/72/98/56/360_F_72985661_LU1Xk0YQiPBwOuesuuJgwTn0NPlwP8ob.jpg','Hai Phong Demo',6,50,'2023-12-02','2024-12-02',0,'2023-12-02 03:33:07','2023-12-30 05:00:04'),(3,3,'Test','Test','http://localhost:3076/images/1e898d9c-1456-48f2-8075-44c092860967.png','Test',0,50,'2023-12-02','2024-12-02',0,'2023-12-30 03:27:15','2023-12-30 03:27:15'),(4,3,'DemoNew','DemoNew\nDemoNew\nDemoNew\nDemoNew','http://localhost:3076/images/5d6c278d-16ce-4b7f-8e3a-8e76b67ae514.jpeg','DemoNew',0,30,'2024-01-17','2024-01-31',0,'2024-01-02 17:29:03','2024-01-02 17:30:29'),(5,3,'DemoLai','DemoLai','http://localhost:3076/images/7afbd229-3090-4828-90ab-9a53e638357a.png','DemoLai',0,22,'2023-12-31','2024-01-12',0,'2024-01-03 17:24:14','2024-01-03 17:31:43');
/!40000 ALTER TABLE activities ENABLE KEYS */;
UNLOCK TABLES;
activity_applyDROP TABLE IF EXISTS activity_apply;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE activity_apply (
id int NOT NULL AUTO_INCREMENT,
user_id int DEFAULT NULL,
activity_id int DEFAULT NULL,
status int DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
activity_applyLOCK TABLES activity_apply WRITE;
/*!40000 ALTER TABLE activity_apply DISABLE KEYS /;
INSERT INTO activity_apply VALUES (1,5,2,3,'2023-12-20 08:52:17','2023-12-30 04:39:54'),(2,2,2,3,'2023-12-30 03:24:30','2023-12-30 05:00:24'),(3,2,3,0,'2023-12-30 03:30:14','2023-12-30 03:30:14'),(4,5,4,0,'2024-01-02 18:02:16','2024-01-02 18:02:16');
/!40000 ALTER TABLE activity_apply ENABLE KEYS */;
UNLOCK TABLES;
attendanceDROP TABLE IF EXISTS attendance;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE attendance (
id int NOT NULL AUTO_INCREMENT,
department_id int DEFAULT NULL,
class_id int DEFAULT NULL,
student_id int DEFAULT NULL,
subject_id int DEFAULT NULL,
number varchar(60) DEFAULT NULL,
active tinyint DEFAULT '1',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
attendanceLOCK TABLES attendance WRITE;
/*!40000 ALTER TABLE attendance DISABLE KEYS /;
INSERT INTO attendance VALUES (6,NULL,NULL,2,1,'10',1),(7,NULL,NULL,1,1,'15',1),(8,NULL,NULL,7,4,'20',1);
/!40000 ALTER TABLE attendance ENABLE KEYS */;
UNLOCK TABLES;
classDROP TABLE IF EXISTS class;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE class (
id int NOT NULL AUTO_INCREMENT,
department_id int DEFAULT NULL,
ma_lop_hoc varchar(1045) DEFAULT NULL,
name varchar(1045) DEFAULT NULL,
active tinyint DEFAULT '1',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
classLOCK TABLES class WRITE;
/*!40000 ALTER TABLE class DISABLE KEYS /;
INSERT INTO class VALUES (1,1,'15THUDPM','Tin học ứng dụng phần mềm',1),(2,1,'15MMT','Mạng máy tính',1),(3,1,'15TTKT','Tên lớp học 3 thay đổi',1),(4,3,'15TTKT','Tài chính kế toán',1),(5,2,'16KT23123','Kinh te chinh tri',1),(6,5,'217.LOPCC','Lớp luồng',1),(7,6,'23.TMUK32','Lop K32 - TMU',1);
/!40000 ALTER TABLE class ENABLE KEYS */;
UNLOCK TABLES;
common_codeDROP TABLE IF EXISTS common_code;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE common_code (
id int NOT NULL AUTO_INCREMENT,
type varchar(255) DEFAULT NULL,
value int DEFAULT NULL,
description varchar(1045) DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
common_codeLOCK TABLES common_code WRITE;
/*!40000 ALTER TABLE common_code DISABLE KEYS /;
INSERT INTO common_code VALUES (1,'StatusUser',0,'Hoạt động',NULL,NULL),(2,'StatusUser',1,'Không hoạt động',NULL,NULL),(3,'StatusOrganization',0,'Hoạt động',NULL,NULL),(4,'StatusOrganization',1,'Không hoạt động',NULL,NULL),(5,'StatusOrganizationRequest',0,'Phê duyệt',NULL,NULL),(6,'StatusOrganizationRequest',1,'Chưa phê duyệt',NULL,NULL),(7,'StatusOrganizationRequest',2,'Không phê duyệt',NULL,NULL),(8,'StatusVolunteerRequest',0,'Phê duyệt',NULL,NULL),(9,'StatusVolunteerRequest',1,'Chưa phê duyệt',NULL,NULL),(10,'StatusVolunteerRequest',2,'Không phê duyệt',NULL,NULL),(11,'StatusActivity',0,'Đang mở',NULL,NULL),(12,'StatusActivity',1,'Đã đóng',NULL,NULL),(13,'StatusActivityApply',0,'Đăng ký',NULL,NULL),(14,'StatusActivityApply',1,'Phê duyệt',NULL,NULL),(15,'StatusActivityApply',2,'Không phê duyệt',NULL,NULL),(16,'StatusActivityApply',3,'Đã tham gia',NULL,NULL),(17,'StatusActivityApply',4,'Không tham gia',NULL,NULL);
/!40000 ALTER TABLE common_code ENABLE KEYS */;
UNLOCK TABLES;
departmentDROP TABLE IF EXISTS department;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE department (
id int NOT NULL AUTO_INCREMENT,
ma_khoa varchar(1045) DEFAULT NULL,
name varchar(1045) DEFAULT NULL,
active tinyint DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
departmentLOCK TABLES department WRITE;
/*!40000 ALTER TABLE department DISABLE KEYS /;
INSERT INTO department VALUES (1,'15THC','Công nghệ thông tin',1),(2,'15QTKD','Kinh tế',1),(3,'15KEDIT','Khoa Edit 3',NULL),(5,'21.THC','Kiểm tra luồng',NULL),(6,'23.TMU52','Khoa hoc may tinh',NULL);
/!40000 ALTER TABLE department ENABLE KEYS */;
UNLOCK TABLES;
faqDROP TABLE IF EXISTS faq;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE faq (
id int NOT NULL AUTO_INCREMENT,
question varchar(1045) DEFAULT NULL,
answer varchar(1045) DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
faqLOCK TABLES faq WRITE;
/*!40000 ALTER TABLE faq DISABLE KEYS /;
INSERT INTO faq VALUES (1,'Faq Test','Faq Test','2023-12-16 04:32:29','2023-12-16 04:32:29'),(3,' const res = data.data',' const res = data.data','2023-12-27 18:48:43','2023-12-27 18:48:43'),(4,' const res = data.data123',' const res = data.data123','2023-12-27 18:49:23','2023-12-27 18:49:23'),(5,'TestXuongDong','TestXuongDong\nTestXuongDong','2024-01-02 15:56:59','2024-01-02 15:56:59'),(6,'test5','test5','2024-01-13 07:28:52','2024-01-13 07:28:52'),(7,'test6','test6','2024-01-13 07:28:57','2024-01-13 07:28:57'),(8,'test7','test7','2024-01-13 07:29:01','2024-01-13 07:29:01'),(9,'test8','test8','2024-01-13 07:29:06','2024-01-13 07:29:06'),(10,'test9','test9','2024-01-13 07:29:13','2024-01-13 07:29:13'),(11,'test10','test10','2024-01-13 07:29:19','2024-01-13 07:29:19'),(12,'test11','test11','2024-01-13 07:29:29','2024-01-13 07:29:29');
/!40000 ALTER TABLE faq ENABLE KEYS */;
UNLOCK TABLES;
feedbackDROP TABLE IF EXISTS feedback;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE feedback (
id int NOT NULL AUTO_INCREMENT,
user_id int DEFAULT NULL,
activity_id int DEFAULT NULL,
title varchar(45) DEFAULT NULL,
content varchar(1045) DEFAULT NULL,
rate int DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
feedbackLOCK TABLES feedback WRITE;
/*!40000 ALTER TABLE feedback DISABLE KEYS /;
INSERT INTO feedback VALUES (1,3,2,'oke','oke',NULL,NULL,NULL),(2,5,2,'Demo2','Demo2',5,'2024-01-03 17:37:35','2024-01-03 17:37:35');
/!40000 ALTER TABLE feedback ENABLE KEYS */;
UNLOCK TABLES;
organizationDROP TABLE IF EXISTS organization;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE organization (
id int NOT NULL AUTO_INCREMENT,
name varchar(45) DEFAULT NULL,
description varchar(1045) DEFAULT NULL,
location varchar(1045) DEFAULT NULL,
creator int DEFAULT NULL,
status int DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
organizationLOCK TABLES organization WRITE;
/*!40000 ALTER TABLE organization DISABLE KEYS /;
INSERT INTO organization VALUES (1,'Organization of user's test','Test','Test',1,0,'2023-12-01 13:09:57','2023-12-01 13:09:57'),(2,'Organization of user's demo','Demo','Demo',3,0,'2023-12-02 03:27:24','2023-12-02 03:27:24'),(4,'Demo123','Demo123','Demo123',5,0,'2023-12-18 02:39:48','2023-12-27 18:43:10'),(6,'spam21312','spam21312','spam21312',2,1,'2024-01-02 18:18:04','2024-01-02 18:18:04');
/!40000 ALTER TABLE organization ENABLE KEYS */;
UNLOCK TABLES;
organization_requestDROP TABLE IF EXISTS organization_request;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE organization_request (
id int NOT NULL AUTO_INCREMENT,
user_id int DEFAULT NULL,
organization_id int DEFAULT NULL,
status int DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
organization_requestLOCK TABLES organization_request WRITE;
/*!40000 ALTER TABLE organization_request DISABLE KEYS /;
INSERT INTO organization_request VALUES (1,1,1,2,'2023-12-01 13:18:13','2023-12-27 18:47:11'),(8,3,2,0,'2023-12-02 03:28:30','2023-12-21 03:48:26'),(9,2,5,1,'2024-01-02 18:16:49','2024-01-02 18:16:49');
/!40000 ALTER TABLE organization_request ENABLE KEYS */;
UNLOCK TABLES;
rolesDROP TABLE IF EXISTS roles;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE roles (
id int NOT NULL AUTO_INCREMENT,
name varchar(45) DEFAULT NULL,
slug varchar(45) DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
rolesLOCK TABLES roles WRITE;
/*!40000 ALTER TABLE roles DISABLE KEYS /;
INSERT INTO roles VALUES (1,'Tình nguyện viên','tinh-nguyen-vien',NULL,NULL),(2,'Tổ chức','to-chuc',NULL,NULL),(3,'Admin','admin',NULL,NULL);
/!40000 ALTER TABLE roles ENABLE KEYS */;
UNLOCK TABLES;
scoreDROP TABLE IF EXISTS score;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE score (
id int NOT NULL AUTO_INCREMENT,
department_id int DEFAULT NULL,
class_id int DEFAULT NULL,
student_id int DEFAULT NULL,
subject_id int DEFAULT NULL,
score int DEFAULT NULL,
active tinyint DEFAULT '1',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
scoreLOCK TABLES score WRITE;
/*!40000 ALTER TABLE score DISABLE KEYS /;
INSERT INTO score VALUES (1,1,1,1,1,10,1),(2,1,2,3,3,1,1),(3,5,6,7,4,10,1);
/!40000 ALTER TABLE score ENABLE KEYS */;
UNLOCK TABLES;
skill_activitiesDROP TABLE IF EXISTS skill_activities;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE skill_activities (
id int NOT NULL AUTO_INCREMENT,
skill_id int DEFAULT NULL,
activity_id int DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
skill_activitiesLOCK TABLES skill_activities WRITE;
/*!40000 ALTER TABLE skill_activities DISABLE KEYS /;
INSERT INTO skill_activities VALUES (1,1,3,'2023-12-30 03:27:15','2023-12-30 03:27:15'),(2,3,3,'2023-12-30 03:27:15','2023-12-30 03:27:15'),(3,4,3,'2023-12-30 03:27:15','2023-12-30 03:27:15'),(4,2,3,'2023-12-30 03:27:15','2023-12-30 03:27:15'),(5,1,4,'2024-01-02 17:29:03','2024-01-02 17:29:03'),(6,2,4,'2024-01-02 17:29:03','2024-01-02 17:29:03'),(7,1,5,'2024-01-03 17:24:14','2024-01-03 17:24:14'),(8,2,5,'2024-01-03 17:24:14','2024-01-03 17:24:14'),(10,3,5,'2024-01-03 17:31:15','2024-01-03 17:31:15');
/!40000 ALTER TABLE skill_activities ENABLE KEYS */;
UNLOCK TABLES;
skill_usersDROP TABLE IF EXISTS skill_users;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE skill_users (
id int NOT NULL AUTO_INCREMENT,
skill_id int DEFAULT NULL,
user_id int DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
skill_usersLOCK TABLES skill_users WRITE;
/*!40000 ALTER TABLE skill_users DISABLE KEYS /;
INSERT INTO skill_users VALUES (10,1,5,'2024-01-02 17:47:08','2024-01-02 17:47:08'),(11,2,5,'2024-01-02 17:47:08','2024-01-02 17:47:08'),(12,3,5,'2024-01-02 17:47:08','2024-01-02 17:47:08');
/!40000 ALTER TABLE skill_users ENABLE KEYS */;
UNLOCK TABLES;
skillsDROP TABLE IF EXISTS skills;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE skills (
id int NOT NULL AUTO_INCREMENT,
name varchar(45) DEFAULT NULL,
description varchar(1045) DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
skillsLOCK TABLES skills WRITE;
/*!40000 ALTER TABLE skills DISABLE KEYS /;
INSERT INTO skills VALUES (1,'Skill test','Skill test','2023-12-16 05:21:55','2023-12-16 05:21:55'),(2,'Test','Test','2023-12-21 03:34:32','2023-12-21 03:34:32'),(3,'Vcl','Vcl','2023-12-23 02:11:28','2023-12-23 02:11:28'),(4,'1232weqw','1232weqw','2023-12-27 18:49:54','2023-12-27 18:49:54');
/!40000 ALTER TABLE skills ENABLE KEYS */;
UNLOCK TABLES;
studentDROP TABLE IF EXISTS student;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE student (
id int NOT NULL AUTO_INCREMENT,
department_id int DEFAULT NULL,
class_id int DEFAULT NULL,
ma_sinh_vien varchar(1045) DEFAULT NULL,
name varchar(1045) DEFAULT NULL,
birthday varchar(1045) DEFAULT NULL,
active tinyint DEFAULT '1',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
studentLOCK TABLES student WRITE;
/*!40000 ALTER TABLE student DISABLE KEYS /;
INSERT INTO student VALUES (1,1,1,'HANU.1234','Nguyễn Văn A','1998-08-05T16:49:54.272Z',1),(2,2,3,'FPT.1233','Nguyễn Văn B','1998-08-05T16:49:54.272Z',1),(3,1,2,'15VVT','Thuan Edit','1998-08-05T16:49:54.272Z',1),(4,3,4,'16VVTHIP','Vu Van Thuan','1998-08-05T16:49:54.272Z',1),(6,3,4,NULL,'Lap trinh HTML',NULL,1),(7,5,6,'217.VVT','Vũ Văn Thuận Lớp','2023-07-05T14:18:52.922Z',1),(8,2,5,'HANU.1234 ','Nguyen Van A','2023-08-04T13:52:09.097Z',1);
/!40000 ALTER TABLE student ENABLE KEYS */;
UNLOCK TABLES;
subjectDROP TABLE IF EXISTS subject;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE subject (
id int unsigned NOT NULL AUTO_INCREMENT,
department_id int DEFAULT NULL,
class_id varchar(45) DEFAULT NULL,
student_id int DEFAULT NULL,
ma_mon_hoc varchar(1045) DEFAULT NULL,
name varchar(1045) DEFAULT NULL,
active tinyint DEFAULT '1',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
subjectLOCK TABLES subject WRITE;
/*!40000 ALTER TABLE subject DISABLE KEYS /;
INSERT INTO subject VALUES (1,5,'1',1,'CSDL.1','Cơ sở dữ liệu',1),(3,5,'1',3,'ADU213.2','Toan cao cap',1),(4,5,'6',7,'217.LTWEB','Lập trình ReactJS',1);
/!40000 ALTER TABLE subject ENABLE KEYS */;
UNLOCK TABLES;
userDROP TABLE IF EXISTS user;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE user (
id int NOT NULL AUTO_INCREMENT,
username varchar(1045) DEFAULT NULL,
password varchar(1045) DEFAULT NULL,
active tinyint DEFAULT '1',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
userLOCK TABLES user WRITE;
/*!40000 ALTER TABLE user DISABLE KEYS /;
INSERT INTO user VALUES (1,'admin','admin',1),(2,'test','test1',1),(4,'accountNew','accountNewEdit',1);
/!40000 ALTER TABLE user ENABLE KEYS */;
UNLOCK TABLES;
usersDROP TABLE IF EXISTS users;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE users (
id int NOT NULL AUTO_INCREMENT,
role_id int DEFAULT NULL,
organization_id int DEFAULT NULL,
username varchar(45) DEFAULT NULL,
password varchar(1045) DEFAULT NULL,
name varchar(45) DEFAULT NULL,
email varchar(255) DEFAULT NULL,
phone varchar(45) DEFAULT NULL,
gender int DEFAULT NULL,
avatar varchar(1045) DEFAULT NULL,
birthday timestamp NULL DEFAULT NULL,
address varchar(1045) DEFAULT NULL,
status int DEFAULT '0',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
usersLOCK TABLES users WRITE;
/*!40000 ALTER TABLE users DISABLE KEYS /;
INSERT INTO users VALUES (1,2,1,'test','testChange','Update Name Test V2','[email protected]','0987654321',1,'https://example.com/avatar.jpg','1990-01-01 00:00:00','123 Main Street',0,'2023-12-01 02:11:48','2023-12-20 03:36:56'),(2,3,NULL,'admin','admin','demo','[email protected]','0332628666',1,'http://localhost:3076/images/74bc5a61-4c56-48e2-a402-c021ed6dc2c9.png','1990-01-01 00:00:00','123 Main Street',0,'2023-12-01 02:40:26','2023-12-01 02:40:26'),(3,2,2,'demo','demo','demo','[email protected]','077777765',1,'https://example.com/avatar.jpg','1990-01-01 00:00:00','123 Main Street',0,'2023-12-02 03:25:47','2023-12-21 03:48:26'),(5,1,NULL,'test123','test123','test123','[email protected]','0123456789',0,'http://localhost:3076/images/53bdb60c-91c5-400e-8b02-85ef0d4cbbcc.png','2024-01-03 02:51:59','test123',0,'2023-12-16 02:52:03','2023-12-16 02:52:03'),(6,1,NULL,'demo123','demo123','demo123','[email protected]','02212255784',0,'https://xsgames.co/randomusers/avatar.php?g=pixel&key=10','2023-12-26 05:14:38','demo123',0,'2023-12-16 05:14:43','2023-12-16 05:14:43');
/!40000 ALTER TABLE users ENABLE KEYS */;
UNLOCK TABLES;
volunteer_requestDROP TABLE IF EXISTS volunteer_request;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE volunteer_request (
id int NOT NULL AUTO_INCREMENT,
user_id int DEFAULT NULL,
organization_id int DEFAULT NULL,
status int DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
volunteer_requestLOCK TABLES volunteer_request WRITE;
/*!40000 ALTER TABLE volunteer_request DISABLE KEYS /;
INSERT INTO volunteer_request VALUES (1,5,1,0,NULL,NULL),(2,6,3,0,NULL,NULL),(3,3,1,0,'2024-01-02 17:44:58','2024-01-02 17:44:58'),(4,5,0,1,'2024-01-02 17:45:25','2024-01-02 17:45:25'),(5,5,0,1,'2024-01-02 17:46:57','2024-01-02 17:46:57'),(6,5,0,1,'2024-01-02 17:47:08','2024-01-02 17:47:08');
/!40000 ALTER TABLE volunteer_request ENABLE KEYS /;
UNLOCK TABLES;
/!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 2024-03-21 21:00:28
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.