Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/thietkeweb2/ |
-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 09, 2022 at 06:54 PM
-- Server version: 10.1.39-MariaDB
-- PHP Version: 7.2.18
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `thietkeweb2`
--
-- --------------------------------------------------------
--
-- Table structure for table `tb_action_logs`
--
CREATE TABLE `tb_action_logs` (
`log_id` bigint(20) NOT NULL,
`company_id` int(11) DEFAULT NULL,
`log_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`method` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`log_url` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`log_data` text COLLATE utf8mb4_unicode_ci,
`user_post` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`log_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `tb_banner`
--
CREATE TABLE `tb_banner` (
`banner_id` int(11) NOT NULL,
`banner_title` varchar(200) DEFAULT NULL,
`banner_etitle` varchar(200) DEFAULT NULL,
`banner_img` text,
`banner_url` varchar(100) DEFAULT NULL,
`banner_target` varchar(20) DEFAULT NULL,
`banner_pos` tinyint(4) DEFAULT NULL,
`banner_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tb_banner`
--
INSERT INTO `tb_banner` (`banner_id`, `banner_title`, `banner_etitle`, `banner_img`, `banner_url`, `banner_target`, `banner_pos`, `banner_time`) VALUES
(1, 'Banner 1', 'Banner 1', '2021/11/banner_1637253900_6196830cc6197.png', 'https://thietkewebvumi.com', '_blank', 1, '2021-11-18 11:45:00'),
(2, 'Banner 2', 'Banner 2', '2021/11/banner_1637253952_619683401abdb.png', 'https://thietkewebvumi.com', '_blank', 3, '2021-11-18 11:45:52');
-- --------------------------------------------------------
--
-- Table structure for table `tb_block`
--
CREATE TABLE `tb_block` (
`block_id` int(11) NOT NULL,
`block_pos` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`block_x` int(11) DEFAULT NULL,
`block_y` int(11) DEFAULT NULL,
`block_title` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`block_etitle` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`block_url` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`block_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`block_detail` longtext COLLATE utf8mb4_unicode_ci,
`block_edetail` longtext COLLATE utf8mb4_unicode_ci,
`block_module` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_block`
--
INSERT INTO `tb_block` (`block_id`, `block_pos`, `block_x`, `block_y`, `block_title`, `block_etitle`, `block_url`, `block_type`, `block_detail`, `block_edetail`, `block_module`) VALUES
(1, '3', NULL, NULL, 'Upcoming Events', 'Upcoming Events', NULL, '1', ' <section id="section-events" aria-label="section" class="no-padding bg-color">\n <div class="container-fluid">\n <div class="row no-gutters align-items-center">\n <div class="col-lg-3 text-center text-light">\n <h3 class="padding40 no-margin">Upcoming Events</h3>\n </div>\n <div class="col-lg-9">\n <div id="training-carousel" class="owl-carousel owl-theme">\n <div class="item">\n <div class="mask s2">\n <div class="m-date">01 <span>Jan</span></div>\n <div class="cover">\n <div class="c-inner">\n <h3><i class="fa fa-circle-thin"></i><span>Attitude is Everything</span></h3>\n <p>Motivation is a reason for actions, willingness, and goals. Motivation is derived from the word motive, or a need that requires satisfaction.</p>\n <div class="spacer20"></div>\n <a href="event-single-1.html" class="btn-custom capsule">Event Details</a>\n </div>\n </div>\n <img src="layout/2021/images/services/1.jpg" alt="" class="img-responsive" />\n </div>\n </div>\n <div class="item">\n <div class="mask s2">\n <div class="m-date">12 <span>Jan</span></div>\n <div class="cover">\n <div class="c-inner">\n <h3><i class="fa fa-circle-thin"></i><span>The Winning Mindset</span></h3>\n <p>Motivation is a reason for actions, willingness, and goals. Motivation is derived from the word motive, or a need that requires satisfaction.</p>\n <div class="spacer20"></div>\n <a href="event-single-2.html" class="btn-custom capsule">Event Details</a>\n </div>\n </div>\n <img src="layout/2021/images/services/2.jpg" alt="" class="img-responsive" />\n </div>\n </div>\n <div class="item">\n <div class="mask s2">\n <div class="m-date">20 <span>Jan</span></div>\n <div class="cover">\n <div class="c-inner">\n <h3><i class="fa fa-circle-thin"></i><span>Sales Breaktrough</span></h3>\n <p>Motivation is a reason for actions, willingness, and goals. Motivation is derived from the word motive, or a need that requires satisfaction.</p>\n <div class="spacer20"></div>\n <a href="event-single-3.html" class="btn-custom capsule">Event Details</a>\n </div>\n </div>\n <img src="layout/2021/images/services/3.jpg" alt="" class="img-responsive" />\n </div>\n </div>\n <div class="item">\n <div class="mask s2">\n <div class="m-date">25 <span>Jan</span></div>\n <div class="cover">\n <div class="c-inner">\n <h3><i class="fa fa-circle-thin"></i><span>Effective Communication Skills</span></h3>\n <p>Motivation is a reason for actions, willingness, and goals. Motivation is derived from the word motive, or a need that requires satisfaction.</p>\n <div class="spacer20"></div>\n <a href="event-single-4.html" class="btn-custom capsule">Event Details</a>\n </div>\n </div>\n <img src="layout/2021/images/services/4.jpg" alt="" class="img-responsive" />\n </div>\n </div>\n <div class="item">\n <div class="mask s2">\n <div class="m-date">01 <span>Feb</span></div>\n <div class="cover">\n <div class="c-inner">\n <h3><i class="fa fa-circle-thin"></i><span>Be The Game Changer</span></h3>\n <p>Motivation is a reason for actions, willingness, and goals. Motivation is derived from the word motive, or a need that requires satisfaction.</p>\n <div class="spacer20"></div>\n <a href="event-single-5.html" class="btn-custom capsule">Event Details</a>\n </div>\n </div>\n <img src="layout/2021/images/services/5.jpg" alt="" class="img-responsive" />\n </div>\n </div>\n <div class="item">\n <div class="mask s2">\n <div class="m-date">10 <span>Feb</span></div>\n <div class="cover">\n <div class="c-inner">\n <h3><i class="fa fa-circle-thin"></i><span>I Can and I Will</span></h3>\n <p>Motivation is a reason for actions, willingness, and goals. Motivation is derived from the word motive, or a need that requires satisfaction.</p>\n <div class="spacer20"></div>\n <a href="event-single-6.html" class="btn-custom capsule">Event Details</a>\n </div>\n </div>\n <img src="layout/2021/images/services/6.jpg" alt="" class="img-responsive" />\n </div>\n </div>\n </div>\n </div>\n </div>\n </div>\n </section> ', '\n ', NULL),
(2, '1', NULL, NULL, 'About Us', 'About Us', NULL, '1', ' <section id="section-about" class="relative">\n <div class="container">\n <div class="row">\n <div class="col-md-4">\n <span class="p-title">About Us</span><br>\n <h2>\n Welcome to the<br>Next Level.\n </h2>\n <div class="small-border sm-left"></div>\n </div>\n <div class="col-md-4">\n <p>Consequat occaecat ullamco amet non eiusmod nostrud dolore irure incididunt est duis anim sunt officia. Fugiat velit proident aliquip nisi incididunt nostrud exercitation proident est nisi. Irure magna elit commodo anim ex veniam culpa eiusmod id nostrud sit cupidatat in veniam ad. Eiusmod consequat eu adipisicing minim anim aliquip cupidatat culpa excepteur quis. Occaecat sit eu exercitation irure Lorem incididunt nostrud.\n </p>\n </div>\n <div class="col-md-4">\n <blockquote>There are two types of people who will tell you that you cannot make a difference in this world: those who are afraid to try and those who are afraid you will succeed.<span class="by">- Ray Goforth</span>\n </blockquote>\n </div>\n </div>\n </div>\n </section> ', '<section id="section-about" class="relative">\n <div class="container">\n <div class="row">\n <div class="col-md-4">\n <span class="p-title">About Us</span><br>\n <h2>\n Welcome to the<br>Next Level.\n </h2>\n <div class="small-border sm-left"></div>\n </div>\n <div class="col-md-4">\n <p>Consequat occaecat ullamco amet non eiusmod nostrud dolore irure incididunt est duis anim sunt officia. Fugiat velit proident aliquip nisi incididunt nostrud exercitation proident est nisi. Irure magna elit commodo anim ex veniam culpa eiusmod id nostrud sit cupidatat in veniam ad. Eiusmod consequat eu adipisicing minim anim aliquip cupidatat culpa excepteur quis. Occaecat sit eu exercitation irure Lorem incididunt nostrud.\n </p>\n </div>\n <div class="col-md-4">\n <blockquote>There are two types of people who will tell you that you cannot make a difference in this world: those who are afraid to try and those who are afraid you will succeed.<span class="by">- Ray Goforth</span>\n </blockquote>\n </div>\n </div>\n </div>\n </section> ', NULL),
(3, '2', NULL, NULL, 'Our Services ', 'Our Services ', NULL, '1', ' <section id="section-services" class="no-top no-bottom" data-bgcolor="#e4e6e9" data-bgimage="url(layout/2021/images/background/bg-1.png) bottom #e4e6e9">\n <div class="container">\n <div class="row align-items-center">\n <div class="col-md-5 offset-md-7">\n <div class="pt80 pb80">\n <span class="p-title">What We Do</span><br>\n <h2>\n Our Services\n </h2>\n <ul class="nav nav-pills mb-3" id="pills-tab" role="tablist">\n <li class="nav-item">\n <a class="nav-link active" id="pills-home-tab" data-toggle="pill" href="#pills-home" role="tab" aria-controls="pills-home" aria-selected="true">Public Seminar</a>\n </li>\n <li class="nav-item">\n <a class="nav-link" id="pills-profile-tab" data-toggle="pill" href="#pills-profile" role="tab" aria-controls="pills-profile" aria-selected="false">In House Training</a>\n </li>\n <li class="nav-item">\n <a class="nav-link" id="pills-contact-tab" data-toggle="pill" href="#pills-contact" role="tab" aria-controls="pills-contact" aria-selected="false">Personal Coaching</a>\n </li>\n </ul>\n <div class="tab-content" id="pills-tabContent">\n <div class="tab-pane fade show active" id="pills-home" role="tabpanel" aria-labelledby="pills-home-tab">\n <p>Consequat occaecat ullamco amet non eiusmod nostrud dolore irure incididunt est duis anim sunt officia. Fugiat velit proident aliquip nisi incididunt nostrud exercitation proident est nisi. Irure magna elit commodo anim ex veniam culpa eiusmod id nostrud sit cupidatat in veniam ad. Eiusmod consequat eu adipisicing minim anim aliquip cupidatat culpa excepteur quis. Occaecat sit eu exercitation irure Lorem incididunt nostrud.</p>\n </div>\n <div class="tab-pane fade" id="pills-profile" role="tabpanel" aria-labelledby="pills-profile-tab">\n <p>Ad pariatur nostrud pariatur exercitation ipsum ipsum culpa mollit commodo mollit ex. Aute sunt incididunt amet commodo est sint nisi deserunt pariatur do. Aliquip ex eiusmod voluptate exercitation cillum id incididunt elit sunt. Qui minim sit magna Lorem id et dolore velit Lorem amet exercitation duis deserunt. Anim id labore elit adipisicing ut in id occaecat pariatur ut ullamco ea tempor duis.</p>\n </div>\n <div class="tab-pane fade" id="pills-contact" role="tabpanel" aria-labelledby="pills-contact-tab">\n <p>Est quis nulla laborum officia ad nisi ex nostrud culpa Lorem excepteur aliquip dolor aliqua irure ex. Nulla ut duis ipsum nisi elit fugiat commodo sunt reprehenderit laborum veniam eu veniam. Eiusmod minim exercitation fugiat irure ex labore incididunt do fugiat commodo aliquip sit id deserunt reprehenderit aliquip nostrud. Amet ex cupidatat excepteur aute veniam incididunt mollit cupidatat esse irure officia elit do ipsum ullamco Lorem.</p>\n </div>\n </div>\n </div>\n </div>\n </div>\n </div>\n <div class="image-container col-md-6 pull-right" data-bgimage="url(layout/2021/images/background/bg-3.jpg) center"></div>\n <div class="clearfix"></div>\n </section> ', '<section id="section-services" class="no-top no-bottom" data-bgcolor="#e4e6e9" data-bgimage="url(layout/2021/images/background/bg-1.png) bottom #e4e6e9">\n <div class="container">\n <div class="row align-items-center">\n <div class="col-md-5 offset-md-7">\n <div class="pt80 pb80">\n <span class="p-title">What We Do</span><br>\n <h2>\n Our Services\n </h2>\n <ul class="nav nav-pills mb-3" id="pills-tab" role="tablist">\n <li class="nav-item">\n <a class="nav-link active" id="pills-home-tab" data-toggle="pill" href="#pills-home" role="tab" aria-controls="pills-home" aria-selected="true">Public Seminar</a>\n </li>\n <li class="nav-item">\n <a class="nav-link" id="pills-profile-tab" data-toggle="pill" href="#pills-profile" role="tab" aria-controls="pills-profile" aria-selected="false">In House Training</a>\n </li>\n <li class="nav-item">\n <a class="nav-link" id="pills-contact-tab" data-toggle="pill" href="#pills-contact" role="tab" aria-controls="pills-contact" aria-selected="false">Personal Coaching</a>\n </li>\n </ul>\n <div class="tab-content" id="pills-tabContent">\n <div class="tab-pane fade show active" id="pills-home" role="tabpanel" aria-labelledby="pills-home-tab">\n <p>Consequat occaecat ullamco amet non eiusmod nostrud dolore irure incididunt est duis anim sunt officia. Fugiat velit proident aliquip nisi incididunt nostrud exercitation proident est nisi. Irure magna elit commodo anim ex veniam culpa eiusmod id nostrud sit cupidatat in veniam ad. Eiusmod consequat eu adipisicing minim anim aliquip cupidatat culpa excepteur quis. Occaecat sit eu exercitation irure Lorem incididunt nostrud.</p>\n </div>\n <div class="tab-pane fade" id="pills-profile" role="tabpanel" aria-labelledby="pills-profile-tab">\n <p>Ad pariatur nostrud pariatur exercitation ipsum ipsum culpa mollit commodo mollit ex. Aute sunt incididunt amet commodo est sint nisi deserunt pariatur do. Aliquip ex eiusmod voluptate exercitation cillum id incididunt elit sunt. Qui minim sit magna Lorem id et dolore velit Lorem amet exercitation duis deserunt. Anim id labore elit adipisicing ut in id occaecat pariatur ut ullamco ea tempor duis.</p>\n </div>\n <div class="tab-pane fade" id="pills-contact" role="tabpanel" aria-labelledby="pills-contact-tab">\n <p>Est quis nulla laborum officia ad nisi ex nostrud culpa Lorem excepteur aliquip dolor aliqua irure ex. Nulla ut duis ipsum nisi elit fugiat commodo sunt reprehenderit laborum veniam eu veniam. Eiusmod minim exercitation fugiat irure ex labore incididunt do fugiat commodo aliquip sit id deserunt reprehenderit aliquip nostrud. Amet ex cupidatat excepteur aute veniam incididunt mollit cupidatat esse irure officia elit do ipsum ullamco Lorem.</p>\n </div>\n </div>\n </div>\n </div>\n </div>\n </div>\n <div class="image-container col-md-6 pull-right" data-bgimage="url(layout/2021/images/background/bg-3.jpg) center"></div>\n <div class="clearfix"></div>\n </section> ', NULL),
(4, '4', NULL, NULL, 'Trainings', 'Trainings', NULL, '1', ' <section class="bg-color text-light pt40 pb40">\n <div class="container">\n <div class="row text-center">\n <div class="col-lg-2 col-md-3 col-sm-6 wow fadeInUp mb-sm-30" data-wow-delay="0s">\n <div class="de_count">\n <h3><span class="timer" data-to="600" data-speed="3000">0</span>+</h3>\n <h5 class="text-white-op-5">Trainings</h5>\n </div>\n </div>\n <div class="col-lg-2 col-md-3 col-sm-6 wow fadeInUp mb-sm-30" data-wow-delay=".25s">\n <div class="de_count">\n <h3><span class="timer" data-to="120" data-speed="3000">0</span>k</h3>\n <h5 class="text-white-op-5">Participants</h5>\n </div>\n </div>\n <div class="col-lg-2 col-md-3 col-sm-6 wow fadeInUp mb-sm-30" data-wow-delay=".4s">\n <div class="de_count">\n <h3><span class="timer" data-to="85" data-speed="3000">0</span></h3>\n <h5 class="text-white-op-5">Companies</h5>\n </div>\n </div>\n <div class="col-lg-2 col-md-3 col-sm-6 wow fadeInUp mb-sm-30" data-wow-delay=".6s">\n <div class="de_count">\n <h3><span class="timer" data-to="50" data-speed="3000">0</span>k</h3>\n <h5 class="text-white-op-5">Topics</h5>\n </div>\n </div>\n <div class="col-lg-2 col-md-3 col-sm-6 wow fadeInUp mb-sm-30" data-wow-delay=".8s">\n <div class="de_count">\n <h3><span class="timer" data-to="100" data-speed="3000">0</span>+</h3>\n <h5 class="text-white-op-5">Countries</h5>\n </div>\n </div>\n <div class="col-lg-2 col-md-3 col-sm-6 wow fadeInUp mb-sm-30" data-wow-delay="1s">\n <div class="de_count">\n <h3><span class="timer" data-to="20" data-speed="3000">0</span></h3>\n <h5 class="text-white-op-5">Speakers</h5>\n </div>\n </div>\n </div>\n </div>\n </section> ', '<section class="bg-color text-light pt40 pb40">\n <div class="container">\n <div class="row text-center">\n <div class="col-lg-2 col-md-3 col-sm-6 wow fadeInUp mb-sm-30" data-wow-delay="0s">\n <div class="de_count">\n <h3><span class="timer" data-to="600" data-speed="3000">0</span>+</h3>\n <h5 class="text-white-op-5">Trainings</h5>\n </div>\n </div>\n <div class="col-lg-2 col-md-3 col-sm-6 wow fadeInUp mb-sm-30" data-wow-delay=".25s">\n <div class="de_count">\n <h3><span class="timer" data-to="120" data-speed="3000">0</span>k</h3>\n <h5 class="text-white-op-5">Participants</h5>\n </div>\n </div>\n <div class="col-lg-2 col-md-3 col-sm-6 wow fadeInUp mb-sm-30" data-wow-delay=".4s">\n <div class="de_count">\n <h3><span class="timer" data-to="85" data-speed="3000">0</span></h3>\n <h5 class="text-white-op-5">Companies</h5>\n </div>\n </div>\n <div class="col-lg-2 col-md-3 col-sm-6 wow fadeInUp mb-sm-30" data-wow-delay=".6s">\n <div class="de_count">\n <h3><span class="timer" data-to="50" data-speed="3000">0</span>k</h3>\n <h5 class="text-white-op-5">Topics</h5>\n </div>\n </div>\n <div class="col-lg-2 col-md-3 col-sm-6 wow fadeInUp mb-sm-30" data-wow-delay=".8s">\n <div class="de_count">\n <h3><span class="timer" data-to="100" data-speed="3000">0</span>+</h3>\n <h5 class="text-white-op-5">Countries</h5>\n </div>\n </div>\n <div class="col-lg-2 col-md-3 col-sm-6 wow fadeInUp mb-sm-30" data-wow-delay="1s">\n <div class="de_count">\n <h3><span class="timer" data-to="20" data-speed="3000">0</span></h3>\n <h5 class="text-white-op-5">Speakers</h5>\n </div>\n </div>\n </div>\n </div>\n </section> ', NULL),
(5, '5', NULL, NULL, 'Our Method', 'Our Method', NULL, '1', ' <section id="section-methods">\n <div class="container">\n <div class="row">\n <div class="col-lg-12">\n <div class="text-center">\n <h2>Our Method</h2>\n <div class="small-border"></div>\n </div>\n </div>\n\n <div class="col-lg-4 col-md-6 mb30">\n <div class="f-box f-icon-left f-icon-rounded">\n <i class="fa fa-book id-color bg-color-op-1"></i>\n <div class="fb-text">\n <h4>Edutainment</h4>\n <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem.\n </p>\n </div>\n </div>\n </div>\n <div class="col-lg-4 col-md-6 mb30">\n <div class="f-box f-icon-left f-icon-rounded">\n <i class="fa fa-pencil id-color bg-color-op-1"></i>\n <div class="fb-text">\n <h4>Experential Learning</h4>\n <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem.\n </p>\n </div>\n </div>\n </div>\n <div class="col-lg-4 col-md-6 mb30">\n <div class="f-box f-icon-left f-icon-rounded">\n <i class="fa fa-search id-color bg-color-op-1"></i>\n <div class="fb-text">\n <h4>Self Discovery</h4>\n <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem.\n </p>\n </div>\n </div>\n </div>\n <div class="col-lg-4 col-md-6 mb30">\n <div class="f-box f-icon-left f-icon-rounded">\n <i class="fa fa-video-camera id-color bg-color-op-1"></i>\n <div class="fb-text">\n <h4>Inspirational Movie</h4>\n <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem.\n </p>\n </div>\n </div>\n </div>\n <div class="col-lg-4 col-md-6 mb30">\n <div class="f-box f-icon-left f-icon-rounded">\n <i class="fa fa-gears id-color bg-color-op-1"></i>\n <div class="fb-text">\n <h4>Simulation</h4>\n <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem.\n </p>\n </div>\n </div>\n </div>\n <div class="col-lg-4 col-md-6 mb30">\n <div class="f-box f-icon-left f-icon-rounded">\n <i class="fa fa-child id-color bg-color-op-1"></i>\n <div class="fb-text">\n <h4>Fun Games</h4>\n <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem.\n </p>\n </div>\n </div>\n </div>\n </div>\n </div>\n </section> ', '<section id="section-methods">\n <div class="container">\n <div class="row">\n <div class="col-lg-12">\n <div class="text-center">\n <h2>Our Method</h2>\n <div class="small-border"></div>\n </div>\n </div>\n\n <div class="col-lg-4 col-md-6 mb30">\n <div class="f-box f-icon-left f-icon-rounded">\n <i class="fa fa-book id-color bg-color-op-1"></i>\n <div class="fb-text">\n <h4>Edutainment</h4>\n <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem.\n </p>\n </div>\n </div>\n </div>\n <div class="col-lg-4 col-md-6 mb30">\n <div class="f-box f-icon-left f-icon-rounded">\n <i class="fa fa-pencil id-color bg-color-op-1"></i>\n <div class="fb-text">\n <h4>Experential Learning</h4>\n <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem.\n </p>\n </div>\n </div>\n </div>\n <div class="col-lg-4 col-md-6 mb30">\n <div class="f-box f-icon-left f-icon-rounded">\n <i class="fa fa-search id-color bg-color-op-1"></i>\n <div class="fb-text">\n <h4>Self Discovery</h4>\n <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem.\n </p>\n </div>\n </div>\n </div>\n <div class="col-lg-4 col-md-6 mb30">\n <div class="f-box f-icon-left f-icon-rounded">\n <i class="fa fa-video-camera id-color bg-color-op-1"></i>\n <div class="fb-text">\n <h4>Inspirational Movie</h4>\n <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem.\n </p>\n </div>\n </div>\n </div>\n <div class="col-lg-4 col-md-6 mb30">\n <div class="f-box f-icon-left f-icon-rounded">\n <i class="fa fa-gears id-color bg-color-op-1"></i>\n <div class="fb-text">\n <h4>Simulation</h4>\n <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem.\n </p>\n </div>\n </div>\n </div>\n <div class="col-lg-4 col-md-6 mb30">\n <div class="f-box f-icon-left f-icon-rounded">\n <i class="fa fa-child id-color bg-color-op-1"></i>\n <div class="fb-text">\n <h4>Fun Games</h4>\n <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem.\n </p>\n </div>\n </div>\n </div>\n </div>\n </div>\n </section> ', NULL);
INSERT INTO `tb_block` (`block_id`, `block_pos`, `block_x`, `block_y`, `block_title`, `block_etitle`, `block_url`, `block_type`, `block_detail`, `block_edetail`, `block_module`) VALUES
(6, '0', NULL, NULL, 'How It Works?', 'How It Works?', NULL, '1', ' <section id="section-how" data-bgcolor="#2A2E37" class="text-light">\n <div class="container">\n <div class="row">\n <div class="col-lg-12">\n <div class="text-center">\n <h2>Là m thế nà o nó hoạt động?</h2>\n <div class="small-border"></div>\n </div>\n </div>\n </div>\n </div>\n </section>\n <section aria-label="section" data-bgcolor="#E4E6E9" class="no-top relative">\n <div class="container">\n <div class="row">\n\n <div class="col-md-12 mt-70 relative">\n <div class="de_tab tab_steps">\n <ul class="de_nav owl-carousel owl-theme" id="de_nav_carousel">\n <li class="active wow zoomIn" data-wow-delay="0s"><span>Join</span>\n <div class="v-border"></div>\n </li>\n <li class="wow zoomIn" data-wow-delay=".4s"><span>Connect</span>\n <div class="v-border"></div>\n </li>\n <li class="wow zoomIn" data-wow-delay=".8s"><span>Explore</span>\n <div class="v-border"></div>\n </li>\n <li class="wow zoomIn" data-wow-delay="1.2s"><span>Grow</span>\n <div class="v-border"></div>\n </li>\n <li class="wow zoomIn" data-wow-delay="1.6s"><span>Success</span>\n <div class="v-border"></div>\n </li>\n </ul>\n\n <div class="de_tab_content" id="de_carousel_content">\n\n <div id="tab1">\n Laborum sint dolor veniam ea labore commodo sint esse tempor fugiat tempor deserunt in eu incididunt ullamco dolore mollit culpa pariatur culpa sunt aute cillum ea non non voluptate consequat occaecat enim quis dolore sed eu mollit laborum mollit commodo nisi adipisicing reprehenderit esse incididunt duis sint veniam nisi ut enim exercitation officia minim proident cupidatat esse officia in mollit id fugiat ut cupidatat occaecat nostrud qui esse quis et consectetur laborum ut eiusmod laboris in anim consequat eu reprehenderit dolore id officia non ex aute in minim dolor irure voluptate deserunt in ad eu aute ullamco nulla incididunt nisi laborum reprehenderit aute nulla ex aute laboris proident elit laborum officia voluptate do sit labore anim dolore sed deserunt adipisicing eiusmod labore commodo id reprehenderit id ea ut ullamco cillum quis reprehenderit ad ad ut.\n </div>\n\n <div id="tab2">\n Sunt minim est commodo pariatur consectetur nulla dolor deserunt excepteur non ex exercitation et ullamco et tempor dolor ut mollit dolore sed ut sed in do amet laboris elit id esse exercitation laborum aute adipisicing mollit incididunt nisi cillum consequat reprehenderit laboris veniam officia cillum sunt esse eiusmod ea voluptate officia in sit sunt mollit officia nulla cupidatat dolor est anim esse consectetur veniam aute quis ut consectetur irure officia elit reprehenderit aute duis in reprehenderit exercitation in fugiat cillum proident proident dolore irure esse laborum non ut commodo ut officia aliqua qui ullamco in ea consequat est cupidatat quis eiusmod sint fugiat dolor pariatur velit nulla fugiat dolor aliqua nisi consequat sunt in amet ad ad ex duis culpa do ut exercitation sunt nostrud excepteur proident sint quis et mollit aute culpa et exercitation proident aliqua ad eiusmod cupidatat est minim deserunt non cupidatat sit ut non duis magna ut aliqua dolore eu ut irure in laborum ut minim consectetur non sed nulla veniam labore in elit nostrud esse ut eu aliqua sunt occaecat est officia enim aute exercitation occaecat esse dolore dolore sit ad.\n </div>\n\n <div id="tab3">\n Aliqua cupidatat commodo laborum ut sed incididunt sunt sed veniam mollit labore eiusmod ullamco veniam consequat cupidatat sint dolore elit do proident est ut quis veniam reprehenderit duis duis in officia laborum in quis id et excepteur excepteur est pariatur dolore dolor reprehenderit sunt ullamco culpa mollit voluptate ut duis reprehenderit pariatur nulla aliquip veniam deserunt laborum adipisicing dolore do laborum et et labore aute occaecat mollit id labore aliquip duis et quis ut non aliquip culpa anim ut duis laboris adipisicing cupidatat ex est deserunt consequat ut in labore non nulla deserunt minim fugiat ut nostrud consectetur laborum elit eu culpa labore in dolor sit aliqua laborum in dolor enim eiusmod in sunt amet occaecat nisi eu laboris aliqua commodo nisi in aliquip tempor cillum eu velit irure et dolor est esse mollit tempor commodo voluptate ut ut reprehenderit eiusmod.\n </div>\n\n <div id="tab4">\n Lorem ipsum fugiat culpa dolore enim minim ullamco adipisicing ea ullamco pariatur ex et labore id in non laboris culpa amet consequat occaecat minim culpa mollit ullamco quis elit cupidatat sed in reprehenderit in duis eiusmod est exercitation dolore ex pariatur consequat occaecat ad mollit dolor ullamco in eiusmod sit ex minim officia magna sit esse consectetur eiusmod in dolore in occaecat sunt anim reprehenderit irure esse nisi in elit consequat consequat nostrud do amet culpa deserunt laborum sit eiusmod do consequat aliqua sit dolore nulla ut irure nostrud qui consectetur aliquip veniam sit anim dolor ad do tempor dolore dolore ullamco incididunt ad exercitation fugiat id ex reprehenderit eu proident est proident incididunt aliquip in nisi nulla nulla consequat dolore eiusmod dolor nisi consequat proident nisi enim dolor consequat ex excepteur labore anim velit proident irure sunt occaecat aliqua exercitation proident magna ut excepteur ad est ut dolor ullamco qui ut ad dolor enim eiusmod irure culpa mollit quis enim do sed excepteur exercitation dolor do dolore enim officia elit dolore aliquip velit fugiat do dolore ut labore ullamco dolore proident mollit ea exercitation labore non duis consequat sunt ut sed occaecat fugiat est sed fugiat in in anim incididunt veniam in aliquip voluptate mollit aliquip proident eiusmod sit nisi dolore ex anim et ut consequat elit aute sunt pariatur reprehenderit anim in cupidatat aute nostrud quis ea voluptate velit elit dolor nostrud excepteur deserunt commodo sunt aliquip cillum.\n </div>\n\n <div id="tab5">\n Elit laborum culpa id eiusmod laboris esse ad qui duis sint in enim in mollit aute culpa sit dolor ut magna sunt et sed veniam dolor minim voluptate duis eu id labore in elit veniam est pariatur dolor commodo eu officia enim deserunt fugiat do amet incididunt cupidatat proident reprehenderit dolor tempor nisi elit ea id esse esse consectetur enim laborum proident labore ullamco aute sed tempor laboris commodo sint aliqua est dolore deserunt esse ea commodo magna qui magna sit dolor eu officia dolore nulla eu magna ex commodo aute occaecat ea eu laborum aute laboris ad voluptate pariatur excepteur cupidatat incididunt sit in qui laboris deserunt velit cupidatat aliqua cupidatat magna veniam nulla amet tempor ad est quis aute pariatur id ea cupidatat exercitation qui pariatur eiusmod adipisicing minim dolore aute ullamco occaecat in anim do culpa est sit exercitation eiusmod quis ea velit sed eiusmod deserunt esse deserunt exercitation incididunt quis irure quis eiusmod cupidatat est commodo adipisicing laboris irure proident ut do in ad consequat exercitation dolore dolore ad irure excepteur aliqua deserunt irure nisi laboris.\n </div>\n\n </div>\n\n </div>\n </div>\n\n </div>\n </div>\n </section> ', '<section id="section-how" data-bgcolor="#2A2E37" class="text-light">\n <div class="container">\n <div class="row">\n <div class="col-lg-12">\n <div class="text-center">\n <h2>How It Works?</h2>\n <div class="small-border"></div>\n </div>\n </div>\n </div>\n </div>\n </section>\n <section aria-label="section" data-bgcolor="#E4E6E9" class="no-top relative">\n <div class="container">\n <div class="row">\n\n <div class="col-md-12 mt-70 relative">\n <div class="de_tab tab_steps">\n <ul class="de_nav owl-carousel owl-theme" id="de_nav_carousel">\n <li class="active wow zoomIn" data-wow-delay="0s"><span>Join</span>\n <div class="v-border"></div>\n </li>\n <li class="wow zoomIn" data-wow-delay=".4s"><span>Connect</span>\n <div class="v-border"></div>\n </li>\n <li class="wow zoomIn" data-wow-delay=".8s"><span>Explore</span>\n <div class="v-border"></div>\n </li>\n <li class="wow zoomIn" data-wow-delay="1.2s"><span>Grow</span>\n <div class="v-border"></div>\n </li>\n <li class="wow zoomIn" data-wow-delay="1.6s"><span>Success</span>\n <div class="v-border"></div>\n </li>\n </ul>\n\n <div class="de_tab_content" id="de_carousel_content">\n\n <div id="tab1">\n Laborum sint dolor veniam ea labore commodo sint esse tempor fugiat tempor deserunt in eu incididunt ullamco dolore mollit culpa pariatur culpa sunt aute cillum ea non non voluptate consequat occaecat enim quis dolore sed eu mollit laborum mollit commodo nisi adipisicing reprehenderit esse incididunt duis sint veniam nisi ut enim exercitation officia minim proident cupidatat esse officia in mollit id fugiat ut cupidatat occaecat nostrud qui esse quis et consectetur laborum ut eiusmod laboris in anim consequat eu reprehenderit dolore id officia non ex aute in minim dolor irure voluptate deserunt in ad eu aute ullamco nulla incididunt nisi laborum reprehenderit aute nulla ex aute laboris proident elit laborum officia voluptate do sit labore anim dolore sed deserunt adipisicing eiusmod labore commodo id reprehenderit id ea ut ullamco cillum quis reprehenderit ad ad ut.\n </div>\n\n <div id="tab2">\n Sunt minim est commodo pariatur consectetur nulla dolor deserunt excepteur non ex exercitation et ullamco et tempor dolor ut mollit dolore sed ut sed in do amet laboris elit id esse exercitation laborum aute adipisicing mollit incididunt nisi cillum consequat reprehenderit laboris veniam officia cillum sunt esse eiusmod ea voluptate officia in sit sunt mollit officia nulla cupidatat dolor est anim esse consectetur veniam aute quis ut consectetur irure officia elit reprehenderit aute duis in reprehenderit exercitation in fugiat cillum proident proident dolore irure esse laborum non ut commodo ut officia aliqua qui ullamco in ea consequat est cupidatat quis eiusmod sint fugiat dolor pariatur velit nulla fugiat dolor aliqua nisi consequat sunt in amet ad ad ex duis culpa do ut exercitation sunt nostrud excepteur proident sint quis et mollit aute culpa et exercitation proident aliqua ad eiusmod cupidatat est minim deserunt non cupidatat sit ut non duis magna ut aliqua dolore eu ut irure in laborum ut minim consectetur non sed nulla veniam labore in elit nostrud esse ut eu aliqua sunt occaecat est officia enim aute exercitation occaecat esse dolore dolore sit ad.\n </div>\n\n <div id="tab3">\n Aliqua cupidatat commodo laborum ut sed incididunt sunt sed veniam mollit labore eiusmod ullamco veniam consequat cupidatat sint dolore elit do proident est ut quis veniam reprehenderit duis duis in officia laborum in quis id et excepteur excepteur est pariatur dolore dolor reprehenderit sunt ullamco culpa mollit voluptate ut duis reprehenderit pariatur nulla aliquip veniam deserunt laborum adipisicing dolore do laborum et et labore aute occaecat mollit id labore aliquip duis et quis ut non aliquip culpa anim ut duis laboris adipisicing cupidatat ex est deserunt consequat ut in labore non nulla deserunt minim fugiat ut nostrud consectetur laborum elit eu culpa labore in dolor sit aliqua laborum in dolor enim eiusmod in sunt amet occaecat nisi eu laboris aliqua commodo nisi in aliquip tempor cillum eu velit irure et dolor est esse mollit tempor commodo voluptate ut ut reprehenderit eiusmod.\n </div>\n\n <div id="tab4">\n Lorem ipsum fugiat culpa dolore enim minim ullamco adipisicing ea ullamco pariatur ex et labore id in non laboris culpa amet consequat occaecat minim culpa mollit ullamco quis elit cupidatat sed in reprehenderit in duis eiusmod est exercitation dolore ex pariatur consequat occaecat ad mollit dolor ullamco in eiusmod sit ex minim officia magna sit esse consectetur eiusmod in dolore in occaecat sunt anim reprehenderit irure esse nisi in elit consequat consequat nostrud do amet culpa deserunt laborum sit eiusmod do consequat aliqua sit dolore nulla ut irure nostrud qui consectetur aliquip veniam sit anim dolor ad do tempor dolore dolore ullamco incididunt ad exercitation fugiat id ex reprehenderit eu proident est proident incididunt aliquip in nisi nulla nulla consequat dolore eiusmod dolor nisi consequat proident nisi enim dolor consequat ex excepteur labore anim velit proident irure sunt occaecat aliqua exercitation proident magna ut excepteur ad est ut dolor ullamco qui ut ad dolor enim eiusmod irure culpa mollit quis enim do sed excepteur exercitation dolor do dolore enim officia elit dolore aliquip velit fugiat do dolore ut labore ullamco dolore proident mollit ea exercitation labore non duis consequat sunt ut sed occaecat fugiat est sed fugiat in in anim incididunt veniam in aliquip voluptate mollit aliquip proident eiusmod sit nisi dolore ex anim et ut consequat elit aute sunt pariatur reprehenderit anim in cupidatat aute nostrud quis ea voluptate velit elit dolor nostrud excepteur deserunt commodo sunt aliquip cillum.\n </div>\n\n <div id="tab5">\n Elit laborum culpa id eiusmod laboris esse ad qui duis sint in enim in mollit aute culpa sit dolor ut magna sunt et sed veniam dolor minim voluptate duis eu id labore in elit veniam est pariatur dolor commodo eu officia enim deserunt fugiat do amet incididunt cupidatat proident reprehenderit dolor tempor nisi elit ea id esse esse consectetur enim laborum proident labore ullamco aute sed tempor laboris commodo sint aliqua est dolore deserunt esse ea commodo magna qui magna sit dolor eu officia dolore nulla eu magna ex commodo aute occaecat ea eu laborum aute laboris ad voluptate pariatur excepteur cupidatat incididunt sit in qui laboris deserunt velit cupidatat aliqua cupidatat magna veniam nulla amet tempor ad est quis aute pariatur id ea cupidatat exercitation qui pariatur eiusmod adipisicing minim dolore aute ullamco occaecat in anim do culpa est sit exercitation eiusmod quis ea velit sed eiusmod deserunt esse deserunt exercitation incididunt quis irure quis eiusmod cupidatat est commodo adipisicing laboris irure proident ut do in ad consequat exercitation dolore dolore ad irure excepteur aliqua deserunt irure nisi laboris.\n </div>\n\n </div>\n\n </div>\n </div>\n\n </div>\n </div>\n </section> ', NULL),
(7, '6', NULL, NULL, 'Liên hệ', 'Contact', NULL, '', '<div class="no-bottom no-top" id="content">\n <div id="top"></div>\n <!-- section begin -->\n <section id="section-home" aria-label="section" class="text-light" aria-label="section" data-bgimage="url(images/background/bg-subheader-3.jpg) top" data-stellar-background-ratio=".2" data>\n <div class="center-y relative text-center">\n <div class="container">\n <div class="row">\n <div class="col-md-12 text-center">\n <h1 class="mt30 wow fadeInUp" data-wow-delay=".6s">Contact Us</h1>\n </div>\n <div class="clearfix"></div>\n </div>\n </div>\n </div>\n </section>\n <!-- section close -->\n <section aria-label="section" data-bgimage="url(images/background/bg-1.png) bottom">\n <div class="container">\n <div class="row">\n <div class="col-md-4">\n <div class="sm-icon mb30 padding20 rounded bg-color-op-1">\n <i class="bg-color fa fa-map-marker"></i>\n <div class="si-inner">\n <h5>Office</h5>\n 08 W 36th St, New York\n </div>\n </div>\n </div>\n <div class="col-md-4">\n <div class="sm-icon mb30 padding20 rounded bg-color-op-1">\n <i class="bg-color fa fa-calendar-check-o"></i>\n <div class="si-inner">\n <h5>Phone</h5>\n 1 200 300 9000\n </div>\n </div>\n </div>\n <div class="col-md-4">\n <div class="sm-icon mb30 padding20 rounded bg-color-op-1">\n <i class="bg-color fa fa-users"></i>\n <div class="si-inner">\n <h5>Email</h5>\n <a href="contact@example.com">contact@motivatemplate.com</a>\n </div>\n </div>\n </div>\n <div class="spacer-single"></div>\n <div class="col-md-12">\n <div class="text-center mb30">\n <h4>We always here to help out whatever way we can.</h4>\n </div>\n <form name="contactForm" id='contact_form' class="form-default" method="post" action='email.php'>\n <div class="row">\n <div class="col-md-6">\n <div id='name_error' class='error'>Please enter your name.</div>\n <div>\n <input type='text' name='name' id='name' class="form-control" placeholder="Your Name">\n </div>\n\n <div id='email_error' class='error'>Please enter your valid E-mail ID.</div>\n <div>\n <input type='text' name='email' id='email' class="form-control" placeholder="Your Email">\n </div>\n\n <div id='phone_error' class='error'>Please enter your phone number.</div>\n <div>\n <input type='text' name='phone' id='phone' class="form-control" placeholder="Your Phone">\n </div>\n </div>\n <div class="col-md-6">\n <div id='message_error' class='error'>Please enter your message.</div>\n <div>\n <textarea name='message' id='message' class="form-control" placeholder="Additional Message"></textarea>\n </div>\n </div>\n\n <div class="col-md-12 text-center">\n <div id='submit'>\n <input type='submit' id='send_message' value='Submit' class="btn-custom">\n </div>\n <div id='mail_success' class='success'>Your message has been sent successfully.</div>\n <div id='mail_fail' class='error'>Sorry, error occured this time sending your message.</div>\n </div>\n </div>\n </form>\n </div>\n </div>\n </div>\n </section>\n </div>', '<div class="no-bottom no-top" id="content">\n <div id="top"></div>\n <!-- section begin -->\n <section id="section-home" aria-label="section" class="text-light" aria-label="section" data-bgimage="url(images/background/bg-subheader-3.jpg) top" data-stellar-background-ratio=".2" data>\n <div class="center-y relative text-center">\n <div class="container">\n <div class="row">\n <div class="col-md-12 text-center">\n <h1 class="mt30 wow fadeInUp" data-wow-delay=".6s">Contact Us</h1>\n </div>\n <div class="clearfix"></div>\n </div>\n </div>\n </div>\n </section>\n <!-- section close -->\n <section aria-label="section" data-bgimage="url(images/background/bg-1.png) bottom">\n <div class="container">\n <div class="row">\n <div class="col-md-4">\n <div class="sm-icon mb30 padding20 rounded bg-color-op-1">\n <i class="bg-color fa fa-map-marker"></i>\n <div class="si-inner">\n <h5>Office</h5>\n 08 W 36th St, New York\n </div>\n </div>\n </div>\n <div class="col-md-4">\n <div class="sm-icon mb30 padding20 rounded bg-color-op-1">\n <i class="bg-color fa fa-calendar-check-o"></i>\n <div class="si-inner">\n <h5>Phone</h5>\n 1 200 300 9000\n </div>\n </div>\n </div>\n <div class="col-md-4">\n <div class="sm-icon mb30 padding20 rounded bg-color-op-1">\n <i class="bg-color fa fa-users"></i>\n <div class="si-inner">\n <h5>Email</h5>\n <a href="contact@example.com">contact@motivatemplate.com</a>\n </div>\n </div>\n </div>\n <div class="spacer-single"></div>\n <div class="col-md-12">\n <div class="text-center mb30">\n <h4>We always here to help out whatever way we can.</h4>\n </div>\n <form name="contactForm" id='contact_form' class="form-default" method="post" action='email.php'>\n <div class="row">\n <div class="col-md-6">\n <div id='name_error' class='error'>Please enter your name.</div>\n <div>\n <input type='text' name='name' id='name' class="form-control" placeholder="Your Name">\n </div>\n\n <div id='email_error' class='error'>Please enter your valid E-mail ID.</div>\n <div>\n <input type='text' name='email' id='email' class="form-control" placeholder="Your Email">\n </div>\n\n <div id='phone_error' class='error'>Please enter your phone number.</div>\n <div>\n <input type='text' name='phone' id='phone' class="form-control" placeholder="Your Phone">\n </div>\n </div>\n <div class="col-md-6">\n <div id='message_error' class='error'>Please enter your message.</div>\n <div>\n <textarea name='message' id='message' class="form-control" placeholder="Additional Message"></textarea>\n </div>\n </div>\n\n <div class="col-md-12 text-center">\n <div id='submit'>\n <input type='submit' id='send_message' value='Submit' class="btn-custom">\n </div>\n <div id='mail_success' class='success'>Your message has been sent successfully.</div>\n <div id='mail_fail' class='error'>Sorry, error occured this time sending your message.</div>\n </div>\n </div>\n </form>\n </div>\n </div>\n </div>\n </section>\n </div>', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `tb_block_page`
--
CREATE TABLE `tb_block_page` (
`block_page_id` int(11) NOT NULL,
`block_id` int(11) DEFAULT NULL,
`menus_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_block_page`
--
INSERT INTO `tb_block_page` (`block_page_id`, `block_id`, `menus_id`) VALUES
(2, 2, 2),
(3, 3, 2),
(4, 1, 2),
(5, 4, 2),
(6, 5, 2),
(7, 7, 23),
(8, 6, 2),
(9, 6, 3),
(10, 6, 4),
(11, 6, 23);
-- --------------------------------------------------------
--
-- Table structure for table `tb_category_module`
--
CREATE TABLE `tb_category_module` (
`category_module_id` int(11) NOT NULL,
`category_module_vi` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`category_module_en` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`category_module_pos` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_category_module`
--
INSERT INTO `tb_category_module` (`category_module_id`, `category_module_vi`, `category_module_en`, `category_module_pos`) VALUES
(2, 'Tổng hợp', 'General', 1),
(3, 'Cá nhân', 'Profile', 2),
(4, 'Quản trị', 'Management', 3),
(5, 'Äà o tạo', 'Training', 4),
(6, 'Thá»i khóa biểu', 'Timetable', 6),
(7, 'Giao tiếp', 'Communication', 7),
(8, 'Tham khảo', 'Reference', 8),
(9, 'Lương bổng', 'Payroll', 9),
(10, 'Kế toán', 'Accounting', 11),
(11, 'Thống kê - Báo cáo', 'Report', 12),
(12, 'Tuyển sinh', 'Admission', 14),
(13, 'Hệ thống', 'System', 15),
(14, 'Khác', 'Other', 20);
-- --------------------------------------------------------
--
-- Table structure for table `tb_city`
--
CREATE TABLE `tb_city` (
`city_id` int(11) NOT NULL,
`country_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city_pos` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_city`
--
INSERT INTO `tb_city` (`city_id`, `country_name`, `city_name`, `city_pos`) VALUES
(1, 'Việt Nam', 'Quảng Ngãi', 2),
(2, 'Việt Nam', 'Thà nh phố Cần Thơ', 2),
(3, 'Việt Nam', 'Thà nh phố Äà Nẵng', 3),
(4, 'Việt Nam', 'Thà nh phố Hà Nội', 1),
(5, 'Việt Nam', 'Thà nh phố Hải Phòng', 5),
(6, 'Việt Nam', 'Thà nh phố Hồ Chà Minh', 0),
(7, 'Việt Nam', 'Tỉnh An Giang', 7),
(8, 'Việt Nam', 'Tỉnh Bà Rịa - Vũng Tà u', 8),
(9, 'Việt Nam', 'Tỉnh Bắc Giang', 9),
(10, 'Việt Nam', 'Tỉnh Bắc Kạn', 10),
(11, 'Việt Nam', 'Tỉnh Bạc Liêu', 11),
(12, 'Việt Nam', 'Tỉnh Bắc Ninh', 12),
(13, 'Việt Nam', 'Tỉnh Bến Tre', 13),
(14, 'Việt Nam', 'Tỉnh Bình Äịnh', 14),
(15, 'Việt Nam', 'Tỉnh Bình Dương', 15),
(16, 'Việt Nam', 'Tỉnh Bình Phước', 16),
(17, 'Việt Nam', 'Tỉnh Bình Thuáºn', 17),
(18, 'Việt Nam', 'Tỉnh Cà Mau', 18),
(19, 'Việt Nam', 'Tỉnh Cao Bằng', 19),
(20, 'Việt Nam', 'Tỉnh Äắk Lắk', 20),
(21, 'Việt Nam', 'Tỉnh Äắk Nông', 21),
(22, 'Việt Nam', 'Tỉnh Äiện Biên', 22),
(23, 'Việt Nam', 'Tỉnh Äồng Nai', 23),
(24, 'Việt Nam', 'Tỉnh Äồng Tháp', 24),
(25, 'Việt Nam', 'Tỉnh Gia Lai', 25),
(26, 'Việt Nam', 'Tỉnh Hà Giang', 26),
(27, 'Việt Nam', 'Tỉnh Hà Nam', 27),
(28, 'Việt Nam', 'Tỉnh Hà Tĩnh', 28),
(29, 'Việt Nam', 'Tỉnh Hải Dương', 29),
(30, 'Việt Nam', 'Tỉnh Háºu Giang', 30),
(31, 'Việt Nam', 'Tỉnh Hoà Bình', 31),
(32, 'Việt Nam', 'Tỉnh Hưng Yên', 32),
(33, 'Việt Nam', 'Tỉnh Khánh Hòa', 33),
(34, 'Việt Nam', 'Tỉnh Kiên Giang', 34),
(35, 'Việt Nam', 'Tỉnh Kon Tum', 35),
(36, 'Việt Nam', 'Tỉnh Lai Châu', 36),
(37, 'Việt Nam', 'Tỉnh Lâm Äồng', 37),
(38, 'Việt Nam', 'Tỉnh Lạng Sơn', 38),
(39, 'Việt Nam', 'Tỉnh Là o Cai', 39),
(40, 'Việt Nam', 'Tỉnh Long An', 40),
(41, 'Việt Nam', 'Tỉnh Nam Äịnh', 41),
(42, 'Việt Nam', 'Tỉnh Nghệ An', 42),
(43, 'Việt Nam', 'Tỉnh Ninh Bình', 43),
(44, 'Việt Nam', 'Tỉnh Ninh Thuáºn', 44),
(45, 'Việt Nam', 'Tỉnh Phú Thá»', 45),
(46, 'Việt Nam', 'Tỉnh Phú Yên', 46),
(47, 'Việt Nam', 'Tỉnh Quảng Bình', 47),
(48, 'Việt Nam', 'Tỉnh Quảng Nam', 48),
(49, 'Việt Nam', 'Tỉnh Quảng Ngãi', 49),
(50, 'Việt Nam', 'Tỉnh Quảng Ninh', 50),
(51, 'Việt Nam', 'Tỉnh Quảng Trị', 51),
(52, 'Việt Nam', 'Tỉnh Sóc Trăng', 52),
(53, 'Việt Nam', 'Tỉnh Sơn La', 53),
(54, 'Việt Nam', 'Tỉnh Tây Ninh', 54),
(55, 'Việt Nam', 'Tỉnh Thái Bình', 55),
(56, 'Việt Nam', 'Tỉnh Thái Nguyên', 56),
(57, 'Việt Nam', 'Tỉnh Thanh Hóa', 57),
(58, 'Việt Nam', 'Tỉnh Thừa Thiên Huế', 58),
(59, 'Việt Nam', 'Tỉnh Tiá»n Giang', 59),
(60, 'Việt Nam', 'Tỉnh Trà Vinh', 60),
(61, 'Việt Nam', 'Tỉnh Tuyên Quang', 61),
(62, 'Việt Nam', 'Tỉnh Vĩnh Long', 62),
(63, 'Việt Nam', 'Tỉnh Vĩnh Phúc', 63),
(64, 'Việt Nam', 'Tỉnh Yên Bái', 64);
-- --------------------------------------------------------
--
-- Table structure for table `tb_company`
--
CREATE TABLE `tb_company` (
`company_id` int(11) NOT NULL,
`company_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_ename` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_parentid` int(11) DEFAULT NULL,
`company_pos` float DEFAULT NULL,
`company_status` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_logo` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_address` text COLLATE utf8mb4_unicode_ci,
`company_email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_type` tinyint(4) DEFAULT NULL,
`company_grade_begin` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_des` text COLLATE utf8mb4_unicode_ci,
`company_edes` text COLLATE utf8mb4_unicode_ci,
`company_mst` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_sotaikhoan` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_nganhang` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_daidien` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_chucvu` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_company`
--
INSERT INTO `tb_company` (`company_id`, `company_name`, `company_ename`, `company_code`, `company_parentid`, `company_pos`, `company_status`, `company_logo`, `company_address`, `company_email`, `company_phone`, `company_type`, `company_grade_begin`, `company_des`, `company_edes`, `company_mst`, `company_sotaikhoan`, `company_nganhang`, `company_daidien`, `company_chucvu`) VALUES
(1, 'UKA', 'UKA', 'C2000', 13, 1.2, 'active', NULL, '', '', '', 3, 'mam-non', 'UKA', 'UKA', NULL, NULL, NULL, NULL, NULL),
(2, 'iSchool HÃ TÄ©nh', 'iSchool Ha Tinh', '239-hatinh', 14, 1.11, 'active', '2_1543384869', '', '', '', 1, 'thpt', 'iSchool HÃ TÄ©nh', 'iSchool HÃ TÄ©nh', NULL, NULL, NULL, NULL, NULL),
(5, 'iSchool Quy Nhơn', 'iSchool Quy Nhon', 'C1012', 14, 1.13, 'active', '5_1544671780', '', '', '', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 'iSCHOOL Nha Trang', 'iSCHOOL Nha Trang', 'C1013', 14, 1.14, 'active', '7_1560391831', '', '', '', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, 'iSCHOOL Ninh Thuáºn', 'iSCHOOL Ninh Thuan', '45-ninhthuan', 14, 1.12, 'active', '8_1543384889', '', '', '', 1, 'mam-non', 'iSCHOOL Ninh Thuáºn', 'iSCHOOL Ninh Thuáºn', NULL, NULL, NULL, NULL, NULL),
(9, 'UKA Bình Thạnh', 'UKA Binh Thanh', 'C2001', 1, 1.23, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13, 'KVV ANH VŨ', 'KVV ANH VŨ', 'KVVAV', 0, 1, 'active', '13_1636546426', '58 Ä‘Æ°á»ng SÆ° Vạn Hạnh, KDC Sao Mai, P.Bình Khánh, Tp. Long Xuyên, An Giang', 'info@kvvanhvu.vom', '0947973379', 1, '', 'CÔNG TY TNHH KVV ANH VŨ', 'CÔNG TY TNHH KVV ANH VŨ', '1602131643', '1016944259', 'Ngân hà ng Vietcombank CN An Giang', 'VÕ TRẦN THANH VŨ', 'Giám Äốc'),
(14, 'iSchool', 'iSchool', 'ischool-C1000', 13, 1.1, 'active', '14_1535084093', '', '', '', 3, 'mam-non', 'iSchool', 'iSchool', NULL, NULL, NULL, NULL, NULL),
(15, 'UKA Bà Rịa', 'UKA Ba Ria', 'C2002', 1, 1.22, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, 'iSCHOOL Nam Sà i Gòn', 'iSCHOOL Saigon South', 'saigon-C1014', 14, 1.15, 'active', '16_1560485605', '01 ÄÆ°á»ng số 5A, KDC Trung SÆ¡n, P.Bình HÆ°ng, H. Bình Chánh, TP. Hồ Chà Minh', 'contact@ischool.vn', '18006030', 1, NULL, 'TrÆ°á»ng quốc tế iSCHOOL Nam Sà i Gòn', 'ISCHOOL International School Saigon South', NULL, NULL, NULL, NULL, NULL),
(18, 'IEC', 'IEC', '2000', 13, 1.3, 'active', '18_1560391915', '', '', '', 3, 'mam-non', 'IEC', 'IEC', NULL, NULL, NULL, NULL, NULL),
(19, 'iSchool Rạch Giá', 'iSchool Rach Gia', 'C-2000-RachGia', 14, 1.16, 'active', NULL, '', '', '', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(20, 'IEC Quãng Ngãi', 'IEC Quang Ngai', '343-2222222', 18, 1.4, 'active', NULL, '', '', '', 1, NULL, 'IEC Quãng Ngãi', 'IEC Quang Ngai', NULL, NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `tb_company_module`
--
CREATE TABLE `tb_company_module` (
`company_module_id` int(11) NOT NULL,
`company_id` int(11) DEFAULT NULL,
`module_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_company_module`
--
INSERT INTO `tb_company_module` (`company_module_id`, `company_id`, `module_id`) VALUES
(541, 9, 14),
(542, 15, 14),
(543, 2, 14),
(544, 5, 14),
(545, 7, 14),
(546, 8, 14),
(547, 16, 14),
(548, 19, 14),
(557, 9, 18),
(558, 15, 18),
(559, 2, 18),
(560, 5, 18),
(561, 7, 18),
(562, 8, 18),
(563, 16, 18),
(564, 19, 18),
(565, 13, 9),
(566, 1, 9),
(567, 9, 9),
(568, 15, 9),
(569, 14, 9),
(570, 2, 9),
(571, 5, 9),
(572, 7, 9),
(573, 8, 9),
(574, 16, 9),
(575, 13, 10),
(576, 1, 10),
(577, 9, 10),
(578, 15, 10),
(579, 14, 10),
(580, 2, 10),
(581, 5, 10),
(582, 7, 10),
(583, 8, 10),
(584, 16, 10),
(585, 13, 6),
(586, 1, 6),
(587, 9, 6),
(588, 15, 6),
(589, 14, 6),
(590, 2, 6),
(591, 5, 6),
(592, 7, 6),
(593, 8, 6),
(594, 16, 6),
(595, 9, 19),
(596, 15, 19),
(597, 2, 19),
(598, 5, 19),
(599, 7, 19),
(600, 8, 19),
(601, 16, 19),
(602, 19, 19),
(603, 1, 20),
(604, 9, 20),
(605, 15, 20),
(606, 2, 20),
(607, 5, 20),
(608, 7, 20),
(609, 8, 20),
(610, 16, 20),
(611, 19, 20),
(612, 9, 7),
(613, 15, 7),
(614, 2, 7),
(615, 5, 7),
(616, 7, 7),
(617, 8, 7),
(618, 16, 7),
(619, 9, 3),
(620, 15, 3),
(621, 2, 3),
(622, 5, 3),
(623, 7, 3),
(624, 8, 3),
(625, 16, 3),
(626, 9, 12),
(627, 15, 12),
(628, 2, 12),
(629, 5, 12),
(630, 7, 12),
(631, 8, 12),
(632, 16, 12),
(633, 19, 12),
(634, 9, 2),
(635, 15, 2),
(636, 2, 2),
(637, 5, 2),
(638, 7, 2),
(639, 8, 2),
(640, 16, 2),
(641, 9, 15),
(642, 15, 15),
(643, 2, 15),
(644, 5, 15),
(645, 7, 15),
(646, 8, 15),
(647, 16, 15),
(648, 19, 15),
(649, 9, 17),
(650, 15, 17),
(651, 2, 17),
(652, 5, 17),
(653, 7, 17),
(654, 8, 17),
(655, 16, 17),
(656, 19, 17),
(657, 9, 16),
(658, 15, 16),
(659, 2, 16),
(660, 5, 16),
(661, 7, 16),
(662, 8, 16),
(663, 16, 16),
(664, 19, 16),
(665, 9, 13),
(666, 15, 13),
(667, 2, 13),
(668, 5, 13),
(669, 7, 13),
(670, 8, 13),
(671, 16, 13),
(672, 19, 13),
(673, 13, 4),
(674, 1, 4),
(675, 9, 4),
(676, 15, 4),
(677, 14, 4),
(678, 2, 4),
(679, 5, 4),
(680, 7, 4),
(681, 8, 4),
(682, 16, 4),
(683, 19, 4),
(684, 13, 8),
(685, 1, 8),
(686, 9, 8),
(687, 15, 8),
(688, 14, 8),
(689, 2, 8),
(690, 5, 8),
(691, 7, 8),
(692, 8, 8),
(693, 16, 8),
(694, 9, 11),
(695, 15, 11),
(696, 2, 11),
(697, 5, 11),
(698, 7, 11),
(699, 8, 11),
(700, 16, 11),
(701, 9, 21),
(702, 15, 21),
(703, 2, 21),
(704, 5, 21),
(705, 7, 21),
(706, 8, 21),
(707, 16, 21),
(708, 19, 21),
(718, 9, 22),
(719, 15, 22),
(720, 2, 22),
(721, 5, 22),
(722, 7, 22),
(723, 8, 22),
(724, 16, 22),
(725, 19, 22),
(726, 20, 22),
(735, 9, 5),
(736, 15, 5),
(737, 2, 5),
(738, 5, 5),
(739, 7, 5),
(740, 8, 5),
(741, 16, 5),
(742, 19, 5);
-- --------------------------------------------------------
--
-- Table structure for table `tb_country`
--
CREATE TABLE `tb_country` (
`country_id` int(11) NOT NULL,
`country_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`country_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`country_pos` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_country`
--
INSERT INTO `tb_country` (`country_id`, `country_name`, `country_code`, `country_pos`) VALUES
(1, 'à Căn Äình', 'AR', 1),
(2, 'Afghanistan', 'AF', 2),
(3, 'Ai cáºp', 'EG', 3),
(4, 'Albani', 'AL', 4),
(5, 'Algérie', 'DZ', 5),
(6, 'ÂÌn Äộ', 'IN', 6),
(7, 'Andorra', 'AD', 7),
(8, 'Angola', 'AO', 8),
(9, 'AnguillaAngola', 'AI', 9),
(10, 'Anh QuôÌc', 'GB', 10),
(11, 'ANTARCTICA', 'AQ', 11),
(12, 'Antille thuá»™c HÃ Lan', 'AN', 12),
(13, 'Ão', 'AT', 13),
(14, 'Armenia', 'AM', 14),
(15, 'Aruba', 'AW', 15),
(16, 'Azerbaijan', 'AZ', 16),
(17, 'Ba Lan', 'PL', 17),
(18, 'Bắc Triều Tiên hoặc Bắc Hà n', 'KP', 18),
(19, 'Bahamas', 'BS', 19),
(20, 'Bangladesh', 'BD', 20),
(21, 'Baranh', 'BH', 21),
(22, 'Barbados', 'BB', 22),
(23, 'Belarus', 'BY', 23),
(24, 'Belize', 'BZ', 24),
(25, 'Bénin', 'BJ', 25),
(26, 'Bhutan', 'BT', 26),
(27, 'Bỉ', 'BE', 27),
(28, 'BỠBiển Ngà ', 'CI', 28),
(29, 'Bồ Äà o Nha', 'PT', 29),
(30, 'Bolivia', 'BO', 30),
(31, 'Bosnia-Herzegovina', 'BA', 31),
(32, 'Botswana', 'BW', 32),
(33, 'BOUVET ISLAND', 'BV', 33),
(34, 'BRAZIL', 'BR', 34),
(35, 'BRITISH INDIAN OCEAN TERRITORY', 'IO', 35),
(36, 'Brunei', 'BN', 36),
(37, 'Bungary', 'BG', 37),
(38, 'Burundi', 'BI', 38),
(39, 'Các quôÌc gia thôÌng nhâÌt Micronesia', 'FM', 39),
(40, 'Các Tiểu vÆ°Æ¡ng quôÌc Ả rập ThôÌng nhâÌt', 'AE', 40),
(41, 'Cameroon', 'CM', 41),
(42, 'Campuchia', 'KH', 42),
(43, 'Cap Ve', 'CV', 43),
(44, 'Chà Lợi', 'CL', 44),
(45, 'Colombia', 'CO', 45),
(46, 'Comoros', 'KM', 46),
(47, 'Cộng hòa Czech', 'CZ', 47),
(48, 'Cộng hòa Dominica', 'DO', 48),
(49, 'Cộng hòa Thượng Volta', 'BF', 49),
(50, 'Cộng hòa trung phi', 'CF', 50),
(51, 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'CD', 51),
(52, 'Congo-Brazzaville', 'CG', 52),
(53, 'Costa Rica', 'CR', 53),
(54, 'Croatia', 'HR', 54),
(55, 'Cuba', 'CU', 55),
(56, 'ÄÃ i Loan', 'TW', 56),
(57, 'Äan Mạch', 'DK', 57),
(58, 'Äảo Christmas', 'CX', 58),
(59, 'Äảo Heard Và Äảo Mcdonald', 'HM', 59),
(60, 'Äảo Norfolk', 'NF', 60),
(61, 'Djibouti', 'DJ', 61),
(62, 'Dominica', 'DM', 62),
(63, 'Äức', 'DE', 63),
(64, 'Ecuador', 'EC', 64),
(65, 'EL Salvador', 'SV', 65),
(66, 'ENGLAND ISLANDS', 'AX', 66),
(67, 'Eritrea', 'ER', 67),
(68, 'Estonia', 'EE', 68),
(69, 'Ethiopia', 'ET', 69),
(70, 'Fiji', 'FJ', 70),
(71, 'Gabon', 'GA', 71),
(72, 'Gambia', 'GM', 72),
(73, 'Ghana', 'GH', 73),
(74, 'Gia Nã Äại', 'CA', 74),
(75, 'GIBRALTAR', 'GI', 75),
(76, 'GREENLAND', 'GL', 76),
(77, 'Grenada', 'GD', 77),
(78, 'Gruzia', 'GE', 78),
(79, 'GUADELOUPE', 'GP', 79),
(80, 'GUAM', 'GU', 80),
(81, 'Guatemala', 'GT', 81),
(82, 'Guinea', 'GN', 82),
(83, 'Guinea Bissau', 'GW', 83),
(84, 'Guinea XÃch Äạo', 'GQ', 84),
(85, 'Guyana', 'GY', 85),
(86, 'Guyane thuộc Pháp', 'GF', 86),
(87, 'HÃ Lan', 'NL', 87),
(88, 'Haiti', 'HT', 88),
(89, 'Hà n QuôÌc', 'KR', 89),
(90, 'Hoa Kỳ', 'US', 90),
(91, 'HOLY SEE (VATICAN CITY STATE)', 'VA', 91),
(92, 'Honduras', 'HN', 92),
(93, 'Hồng Kông', 'HK', 93),
(94, 'Hungary', 'HU', 94),
(95, 'Hy Lạp', 'GR', 95),
(96, 'Iceland', 'IS', 96),
(97, 'Indonesia', 'ID', 97),
(98, 'Iran', 'IR', 98),
(99, 'Iraq', 'IQ', 99),
(100, 'Ireland', 'IE', 100),
(101, 'Israel', 'IL', 101),
(102, 'Jamaica', 'JM', 102),
(103, 'Jordan', 'JO', 103),
(104, 'Kazakhstan', 'KZ', 104),
(105, 'Kenya', 'KE', 105),
(106, 'Kiribati', 'KI', 106),
(107, 'Kuwait', 'KW', 107),
(108, 'Kyrgyzstan', 'KG', 108),
(109, 'Lãnh thổ Palestin', 'PS', 109),
(110, 'Lảnh thổ phÃa nam của pháp', 'TF', 110),
(111, 'LÃ o', 'LA', 111),
(112, 'Latvia', 'LV', 112),
(113, 'Lebanon', 'LB', 113),
(114, 'Lesotho', 'LS', 114),
(115, 'Liberia', 'LR', 115),
(116, 'Libya', 'LY', 116),
(117, 'Liechtenstein', 'LI', 117),
(118, 'Liên bang Antigua và Barbuda', 'AG', 118),
(119, 'Liên Bang Nga', 'RU', 119),
(120, 'Lithuanian', 'LT', 120),
(121, 'Luxembourg', 'LU', 121),
(122, 'Macao', 'MO', 122),
(123, 'Macedonia', 'MK', 123),
(124, 'Madagascar', 'MG', 124),
(125, 'MALAWI', 'MW', 125),
(126, 'Malaysia', 'MY', 126),
(127, 'Maldives', 'MV', 127),
(128, 'MALI', 'ML', 128),
(129, 'Malta', 'MT', 129),
(130, 'Marshall Islands', 'MH', 130),
(131, 'Martinique', 'MQ', 131),
(132, 'Mauritania', 'MR', 132),
(133, 'Mauritius', 'MU', 133),
(134, 'Mayotte', 'YT', 134),
(135, 'Mexico', 'MX', 135),
(136, 'Moldova', 'MD', 136),
(137, 'Monaco', 'MC', 137),
(138, 'Mông Cổ', 'MN', 138),
(139, 'Montserrat', 'MS', 139),
(140, 'Morocco', 'MA', 140),
(141, 'Mozambique', 'MZ', 141),
(142, 'Myanmar', 'MM', 142),
(143, 'Na Uy', 'NO', 143),
(144, 'Nam Phi', 'ZA', 144),
(145, 'Namibia', 'NA', 145),
(146, 'Nauru', 'NR', 146),
(147, 'Nepal', 'NP', 147),
(148, 'New Caledonia', 'NC', 148),
(149, 'New Zealand', 'NZ', 149),
(150, 'Nhật Bản', 'JP', 150),
(151, 'Nicaragua', 'NI', 151),
(152, 'Niger', 'NE', 152),
(153, 'Nigeria', 'NG', 153),
(154, 'Niue', 'NU', 154),
(155, 'NORTHERN MARIANA ISLANDS', 'MP', 155),
(156, 'Oman', 'OM', 156),
(157, 'Pakistan', 'PK', 157),
(158, 'Palau', 'PW', 158),
(159, 'Panama', 'PA', 159),
(160, 'Papua New Guinea', 'PG', 160),
(161, 'Paraguay', 'PY', 161),
(162, 'Peru', 'PE', 162),
(163, 'Phần Lan', 'FI', 163),
(164, 'Pháp', 'FR', 164),
(165, 'Philippines', 'PH', 165),
(166, 'Pitcairn', 'PN', 166),
(167, 'Polynésie thuộc Pháp', 'PF', 167),
(168, 'Puerto Rico', 'PR', 168),
(169, 'Qatar', 'QA', 169),
(170, 'Quần đảo Bermuda', 'BM', 170),
(171, 'Quần đảo Cayman', 'KY', 171),
(172, 'Quần đảo Cocos (Keeling)', 'CC', 172),
(173, 'Quần đảo Cook', 'CK', 173),
(174, 'Quần đảo Falkland (MALVINAS)', 'FK', 174),
(175, 'Quần đảo Faroe', 'FO', 175),
(176, 'RÉUNION', 'RE', 176),
(177, 'Romania', 'RO', 177),
(178, 'Rwanda', 'RW', 178),
(179, 'SAINT HELENA', 'SH', 179),
(180, 'Saint Kitts và NevisS', 'KN', 180),
(181, 'Saint Lucia', 'LC', 181),
(182, 'SAINT PIERRE AND MIQUELON', 'PM', 182),
(183, 'Saint Vincent và the Grenadines', 'VC', 183),
(184, 'Samoa', 'WS', 184),
(185, 'Samoa thuộc Mỹ', 'AS', 185),
(186, 'San Marino', 'SM', 186),
(187, 'Sao Tome và Principe', 'ST', 187),
(188, 'Saudi Arabia', 'SA', 188),
(189, 'Senegal', 'SN', 189),
(190, 'SERBIA AND MONTENEGRO', 'CS', 190),
(191, 'Seychelles', 'SC', 191),
(192, 'Sierra Leone', 'SL', 192),
(193, 'Singapore', 'SG', 193),
(194, 'SÃp', 'CY', 194),
(195, 'Slovakia', 'SK', 195),
(196, 'Slovenia', 'SI', 196),
(197, 'Solomon Islands', 'SB', 197),
(198, 'Somalia', 'SO', 198),
(199, 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'GS', 199),
(200, 'Sri Lanka', 'LK', 200),
(201, 'Sudan', 'SD', 201),
(202, 'Suriname', 'SR', 202),
(203, 'SVALBARD AND JAN MAYEN', 'SJ', 203),
(204, 'Swaziland', 'SZ', 204),
(205, 'Syria', 'SY', 205),
(206, 'Tajikistan', 'TJ', 206),
(207, 'TANZANIA, UNITED REPUBLIC OF', 'TZ', 207),
(208, 'Tây Ban Nha', 'ES', 208),
(209, 'Tchad', 'TD', 209),
(210, 'Thái Lan', 'TH', 210),
(211, 'Thổ Nhĩ Kỳ', 'TR', 211),
(212, 'Thụy Äiển', 'SE', 212),
(213, 'Thụy Sỹ', 'CH', 213),
(214, 'TIMOR-LESTE', 'TL', 214),
(215, 'Togo', 'TG', 215),
(216, 'Tokelau', 'TK', 216),
(217, 'Tonga', 'TO', 217),
(218, 'Trinidad và Tobago', 'TT', 218),
(219, 'Trung Quốc', 'CN', 219),
(220, 'Tunisia', 'TN', 220),
(221, 'Turkmenistan', 'TM', 221),
(222, 'TURKS AND CAICOS ISLANDS', 'TC', 222),
(223, 'Tuvalu', 'TV', 223),
(224, 'Úc (Äại Lợi)', 'AU', 224),
(225, 'Uganda', 'UG', 225),
(226, 'Ukraine', 'UA', 226),
(227, 'UNITED STATES MINOR OUTLYING ISLANDS', 'UM', 227),
(228, 'Uruguay', 'UY', 228),
(229, 'Uzbekistan', 'UZ', 229),
(230, 'Vanuatu', 'VU', 230),
(231, 'Vatican', 'VA', 231),
(232, 'Venezuela', 'VE', 232),
(233, 'Việt Nam', 'VN', 0),
(234, 'Vietnam', '', 234),
(235, 'VIRGIN ISLANDS, BRITISH', 'VG', 235),
(236, 'VIRGIN ISLANDS, U.S.', 'VI', 236),
(237, 'WALLIS AND FUTUNA', 'WF', 237),
(238, 'WESTERN SAHARA', 'EH', 238),
(239, 'Ã', 'IT', 239),
(240, 'Yemen', 'YE', 240),
(241, 'Zambia', 'ZM', 241),
(242, 'Zimbabwe', 'ZW', 242);
-- --------------------------------------------------------
--
-- Table structure for table `tb_customer`
--
CREATE TABLE `tb_customer` (
`customer_id` int(11) NOT NULL,
`customer_fullname` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`customer_lastname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`customer_gender` tinyint(4) DEFAULT NULL,
`customer_company` text COLLATE utf8mb4_unicode_ci,
`customer_chucvu` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`customer_address` text COLLATE utf8mb4_unicode_ci,
`customer_email` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`customer_mobile` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`customer_sotaikhoan` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`customer_nganhang` text COLLATE utf8mb4_unicode_ci,
`customer_masothue` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`customer_status` tinyint(4) DEFAULT NULL,
`customer_order` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city_id` int(11) DEFAULT NULL,
`time_post` datetime DEFAULT NULL,
`user_post` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`time_update` datetime DEFAULT NULL,
`user_update` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_customer`
--
INSERT INTO `tb_customer` (`customer_id`, `customer_fullname`, `customer_lastname`, `customer_gender`, `customer_company`, `customer_chucvu`, `customer_address`, `customer_email`, `customer_mobile`, `customer_sotaikhoan`, `customer_nganhang`, `customer_masothue`, `customer_status`, `customer_order`, `city_id`, `time_post`, `user_post`, `time_update`, `user_update`) VALUES
(1, 'NGUYỄN Há»’ VÆ¯Æ NG', 'VÆ¯Æ NG', 1, 'CÔNG TY Cá»” PHẦN ÄẦU TƯ L.A.D', 'Giám đốc', 'D20 KDC PhÆ°á»›c Nguyên HÆ°ng, Nguyá»…n Hữu Thá», PhÆ°á»›c Kiển, Nhà Bè, TP.HCM', 'lad.jsc168@gmail.com', '0933144558', '0313474872', 'Sacombank', '0313474872', 1, '', 6, '2021-11-09 03:14:54', 'giacbn', '2021-11-09 15:54:11', 'giacbn'),
(2, 'NGUYỄN XUÂN ÃNH', 'Ãnh', 1, 'CÔNG TY TNHH THÆ¯Æ NG MẠI VÀ DỊCH VỤ XUÂN ANH BEAUTY', 'Giám đốc', '197/10 ÄÆ°á»ng Thống Nhất, PhÆ°á»ng 11, Quáºn Gò Vấp, TP. Hồ Chà Minh', 'xuananh.beauty@gmail.com', '0937775519', '', '', '0316568261', 1, 'anh2 xuazzn nguyezn4 ', 6, '2021-11-09 04:24:59', 'giacbn', '2021-11-09 04:24:59', 'giacbn');
-- --------------------------------------------------------
--
-- Table structure for table `tb_dantoc`
--
CREATE TABLE `tb_dantoc` (
`dantoc_id` int(11) NOT NULL,
`dantoc_vi` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`dantoc_en` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`dantoc_pos` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_dantoc`
--
INSERT INTO `tb_dantoc` (`dantoc_id`, `dantoc_vi`, `dantoc_en`, `dantoc_pos`) VALUES
(62, 'Ba-na', 'Ba-na', 2),
(63, 'Bố Y', 'Bố Y', 1),
(64, 'Brâu', 'Brâu', 3),
(65, 'Bru-Vân Kiá»u', 'Bru-Vân Kiá»u', 4),
(66, 'Cao Lan', 'Cao Lan', 5),
(67, 'Chăm', 'Chăm', 6),
(68, 'Chơ-ro', 'Chơ-ro', 7),
(69, 'Chu-ru', 'Chu-ru', 8),
(70, 'Chứt', 'Chứt', 9),
(71, 'Co', 'Co', 10),
(72, 'Cá» lao', 'Cá» lao', 11),
(73, 'CÆ¡-ho', 'CÆ¡-ho', 12),
(74, 'Cống', 'Cống', 13),
(75, 'CÆ¡-tu', 'CÆ¡-tu', 14),
(76, 'Dao', 'Dao', 15),
(77, 'Dáy', 'Dáy', 16),
(78, 'Ê-đê', 'Ê-đê', 17),
(79, 'Gia Rai', 'Gia Rai', 18),
(80, 'Giáy', 'Giáy', 19),
(81, 'Gié-Triêng', 'Gié-Triêng', 20),
(82, 'Hà Nhì', 'Hà Nhì', 21),
(83, 'Hmông', 'Hmông', 22),
(84, 'Hoa', 'Hoa', 23),
(85, 'Hrê', 'Hrê', 24),
(86, 'Khác', 'Khác', 25),
(87, 'Kháng', 'Kháng', 26),
(88, 'Khơ Me', 'Khơ Me', 27),
(89, 'Khơmú', 'Khơmú', 28),
(90, 'Kinh', 'Kinh', 0),
(91, 'La Ha', 'La Ha', 30),
(92, 'La Hủ', 'La Hủ', 31),
(93, 'La-chÃ', 'La-chÃ', 32),
(94, 'LÃ o', 'LÃ o', 33),
(95, 'LôLô', 'LôLô', 34),
(96, 'Lá»±', 'Lá»±', 35),
(97, 'Mạ', 'Mạ', 36),
(98, 'Mảng', 'Mảng', 37),
(99, 'Mnông', 'Mnông', 38),
(100, 'MÆ°á»ng', 'MÆ°á»ng', 39),
(101, 'Ngái', 'Ngái', 40),
(102, 'Ngạn', 'Ngạn', 41),
(103, 'Nùng', 'Nùng', 42),
(104, 'Æ -Ä‘u', 'Æ -Ä‘u', 43),
(105, 'Pà Thẻn', 'Pà Thẻn', 44),
(106, 'Phù Lá', 'Phù Lá', 45),
(107, 'Pu Piéo', 'Pu Piéo', 46),
(108, 'Ra-glay', 'Ra-glay', 47),
(109, 'Rơ-măm', 'Rơ-măm', 48),
(110, 'Sán Cháy', 'Sán Cháy', 49),
(111, 'Sán Dìu', 'Sán Dìu', 50),
(112, 'Si La', 'Si La', 51),
(113, 'Ta-ôi', 'Ta-ôi', 52),
(114, 'TÃ y', 'TÃ y', 53),
(115, 'Thái', 'Thái', 54),
(116, 'Thổ', 'Thổ', 55),
(117, 'Xinh-mun', 'Xinh-mun', 56),
(118, 'Xơ-đăng', 'Xơ-đăng', 57),
(119, 'X'tiêng', 'X'tiêng', 58);
-- --------------------------------------------------------
--
-- Table structure for table `tb_dienchinhsach`
--
CREATE TABLE `tb_dienchinhsach` (
`dienchinhsach_id` int(11) NOT NULL,
`dienchinhsach_vi` tinytext COLLATE utf8mb4_unicode_ci,
`dienchinhsach_en` tinytext COLLATE utf8mb4_unicode_ci,
`dienchinhsach_pos` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_dienchinhsach`
--
INSERT INTO `tb_dienchinhsach` (`dienchinhsach_id`, `dienchinhsach_vi`, `dienchinhsach_en`, `dienchinhsach_pos`) VALUES
(1, 'NgÆ°á»i dân tá»™c thiểu số Việt Nam', 'NgÆ°á»i dân tá»™c thiểu số Việt Nam', 1),
(2, 'Công nhân ưu tú', 'Công nhân ưu tú', 2),
(3, 'Thương binh, bệnh binh', 'Thương binh, bệnh binh', 3),
(4, 'Con liệt sĩ', 'Con liệt sĩ', 4),
(5, 'Gia đình nghèo', 'Gia đình nghèo', 6),
(6, 'Không', 'None', 0);
-- --------------------------------------------------------
--
-- Table structure for table `tb_district`
--
CREATE TABLE `tb_district` (
`district_id` int(11) NOT NULL,
`city_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`district_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`district_pos` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `tb_hopdong`
--
CREATE TABLE `tb_hopdong` (
`hopdong_id` int(11) NOT NULL,
`hopdong_code` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`customer_id` int(11) DEFAULT NULL,
`service_cat` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`service_id` int(11) DEFAULT NULL,
`service_event_id` int(11) DEFAULT NULL,
`hopdong_ngayin` date DEFAULT NULL,
`hopdong_ngayky` date DEFAULT NULL,
`hopdong_folder` text COLLATE utf8mb4_unicode_ci,
`hopdong_file` text COLLATE utf8mb4_unicode_ci,
`hopdong_status` tinyint(4) DEFAULT NULL,
`time_post` datetime DEFAULT NULL,
`user_post` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`time_update` datetime DEFAULT NULL,
`user_update` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `tb_hopdong_tpl`
--
CREATE TABLE `tb_hopdong_tpl` (
`hopdong_tpl_id` int(11) NOT NULL,
`hopdong_tpl_name` text COLLATE utf8mb4_unicode_ci,
`hopdong_tpl_path` text COLLATE utf8mb4_unicode_ci,
`user_post` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`service_cat` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_hopdong_tpl`
--
INSERT INTO `tb_hopdong_tpl` (`hopdong_tpl_id`, `hopdong_tpl_name`, `hopdong_tpl_path`, `user_post`, `service_cat`) VALUES
(2, 'Hosting_hop-dong-cung-cap-hosting-tpl.docx', 'upload/logos/Hosting_hop-dong-cung-cap-hosting-tpl.docx', 'giacbn', 'Hosting');
-- --------------------------------------------------------
--
-- Table structure for table `tb_language`
--
CREATE TABLE `tb_language` (
`language_id` int(11) NOT NULL,
`language_key` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`language_vi` text COLLATE utf8mb4_unicode_ci,
`language_en` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_language`
--
INSERT INTO `tb_language` (`language_id`, `language_key`, `language_vi`, `language_en`) VALUES
(21, 'bat-buoc', 'Bắt buộc', 'Obligatory'),
(22, 'tu-chon', 'Tá»± chá»n', 'Elective'),
(23, 'duoc-tu-chon', 'Äược tá»± chá»n', 'Can elective'),
(24, 'nhom-khoa-hoc-va-xa-hoi', 'Nhóm khoa há»c và xã há»™i', 'Scientific and social'),
(25, 'nhom-khoa-hoc-tu-nhien', 'Nhóm khoa há»c tá»± nhiên', 'Group of natural sciences'),
(26, 'nhom-cong-nghe-va-nghe-thuat', 'Nhóm công nghệ và nghệ thuáºt', 'Technology and art'),
(27, 'vi-tri', 'Vị trÃ', 'Position '),
(28, 'luu-lai', 'Lưu lại', 'Save'),
(29, 'huy-bo', 'Hủy bá»', 'Cancel'),
(30, 'yeu-cau', 'Yêu cầu', 'Required'),
(31, 'bo-giao-duc', 'Bộ giáo dục', 'Curriculum '),
(32, 'khac', 'Khác', 'Other'),
(33, 'can-bo-nhan-vien', 'Cán bộ - Nhân viên', 'Staff -Teacher'),
(34, 'ho-ten', 'HỠvà tên', 'Fullname'),
(35, 'gioi-tinh', 'Giá»›i tÃnh', 'Gender'),
(36, 'chuc-vu', 'Vị trà - Chức vụ', 'Function'),
(37, 'ngay-vao-lam-viec', 'Ngà y bắt đầu là m việc', 'Date start work'),
(38, 'ngay-sinh', 'Ngà y sinh', 'Birthday'),
(39, 'noi-sinh', 'NÆ¡i sinh', 'Birth place'),
(40, 'dia-chi', 'Äịa chỉ', 'Address'),
(41, 'dan-toc', 'Dân tộc', 'Ethnic'),
(42, 'dien-thoai-di-dong', 'Ät di Ä‘á»™ng', 'Mobile'),
(43, 'cmnd', 'Chứng minh nhân dân', 'Identification'),
(44, 'trinh-do-hoc-van', 'Trình Ä‘á»™ há»c vấn', 'Diploma'),
(45, 'tinh-trang-hon-nhan', 'Tình trạng hôn nhân', 'Marry status'),
(46, 'email-ca-nhan', 'Email cá nhân', 'Email's personal'),
(47, 'quoc-tich', 'Quốc tịch', 'Quốc tịch'),
(48, 'viet-nam', 'Việt Nam', 'Vietnam'),
(49, 'nuoc-ngoai', 'Nước ngoà i', 'Foreign'),
(50, 'nam', 'Nam', 'Male'),
(51, 'nu', 'Nữ', 'Female'),
(52, 'thpt', 'Trung há»c phổ thông', 'High school'),
(53, 'trung-cap', 'Trung cấp', 'Intermediate'),
(54, 'cao-dang', 'Cao Äẳng', 'College'),
(55, 'dai-hoc', 'Äại há»c', 'University'),
(56, 'thac-si', 'Thạc sĩ', 'Master'),
(57, 'tien-si', 'Tiến sĩ', 'Doctor'),
(58, 'doc-than', 'Äá»™c thân', 'Single'),
(59, 'da-xay-dung-gia-dinh', 'Äã kết hôn', 'Married'),
(60, 'mon-co-the-day', 'Môn có thể dạy', 'Subject can teach'),
(61, 'to-bo-mon', 'Tổ bộ môn', 'Organization Department'),
(62, 'cap-nhat-thong-so', 'Thông số', 'Parameter'),
(63, 'ten-thong-so', 'Tên thông số', 'Param name'),
(64, 'ten-thong-so-tieng-anh', 'Tên thông số tiếng Anh', 'Param English Name'),
(65, 'key-thong-so', 'Key thông số', 'param key'),
(66, 'loai-thong-so', 'Loại thông số', 'Param type'),
(67, 'cong-ty', 'Công ty', 'Company'),
(68, 'thong-so-giao-vien', 'Thông số giáo viên', 'Staff parameter'),
(69, 'chon-thong-so', 'Chá»n thông số', 'Choose a staff parameter'),
(70, 'tim-cbnv', 'Tìm giáo viên - cbnv', 'Staff research'),
(71, 'tinh-trang', 'Công tác', 'Status'),
(72, 'tim', 'Tìm', 'Search'),
(73, 'tat-ca', 'Tất cả', 'All'),
(74, 'dang-cong-tac', 'Äang công tác', 'Work on'),
(75, 'nghi-cong-tac', 'Äã nghỉ', 'Work off'),
(76, 'cap-nhat-to-bo-mon', 'Cáºp nháºt tổ bá»™ môn', 'Update group staff'),
(77, 'ten-to-bo-mon', 'Tên tổ bộ môn', 'Staffgroup name'),
(78, 'ten-to-bo-mon-tieng-anh', 'Tên tổ bộ môn tiếng Anh', 'Staffgroup name English'),
(79, 'tham-gia-giang-day', 'Tham gia giảng dạy', 'Subjects department type'),
(80, 'van-phong', 'Văn phòng', 'Office'),
(81, 'truong-nhom', 'Trưởng nhóm', 'Group leader'),
(82, 'hinh-anh', 'Hình ảnh', 'Image'),
(83, 'them-moi', 'Thêm mới', 'Add New'),
(84, 'xoa', 'Xóa', 'Delete'),
(85, 'ngay-ap-dung', 'Ngà y áp dụng', 'Active date'),
(86, 'ly-do', 'Lý do', 'Note'),
(87, 'nguoi-nhap', 'NgÆ°á»i nháºp', 'User post'),
(88, 'thong-so-truong', 'Thông số trÆ°á»ng', 'Company parameter'),
(118, 'cap-nhat-vi-tri', 'Cáºp nháºt vị trÃ', 'Update pos'),
(119, 'sua', 'Sá»a', 'Edit'),
(120, 'giao-su', 'Giáo sư', 'Master'),
(121, 'anh-phai-vuong', 'Ảnh vuông, dung lượng < 1MB', 'Photo must be square, capacity is less than 1MB'),
(122, 'email-cong-ty', 'Email công ty', 'Company email'),
(123, 'da-doi', 'Äã đổi', 'Changed'),
(124, 'cap-nhat-nghi-cong-tac', 'Nghỉ công tác', 'Quit job'),
(125, 'cap-nhat-tro-lai-cong-tac', 'Trở lại công tác', 'Back job'),
(126, 'cap-nhat-cap-quyen', 'Cấp quyá»n', 'Grant rule'),
(127, 'them-mot', 'Thêm một', 'Add one record'),
(128, 'import-danh-sach-giao-vien', 'Import danh sách giáo viên', 'Import list staff'),
(129, 'chon-file-excel', 'Chá»n file EXCEL để tải lên', 'Choose upload a excel file '),
(130, 'file-excel-mau', 'Tải file excel mẫu', 'Excel file example'),
(131, 'da-nghi', 'Äã nghỉ', 'Quit job'),
(132, 'ngay-nghi', 'Ngà y nghỉ', 'Date out off'),
(133, 'ly-do-nghi', 'Lý do nghỉ', 'Note/Reason'),
(134, 'ngay-tro-lai', 'Ngà y trở lại', 'Date back job'),
(135, 'ly-do-tro-lai', 'Lý do trở lại', 'Note/Reason'),
(136, 'cac-su-kien-da-cap-nhat', 'Các sá»± kiện đã cáºp nháºt', 'Events updated'),
(137, 'loai', 'Loại', 'Type'),
(138, 'ngay', 'Ngà y', 'Date'),
(139, 'user-nhap', 'User nháºp', 'User post'),
(140, 'research', 'Tra cứu', 'Research'),
(141, 'update', 'Cáºp nháºt', 'Update'),
(142, 'management', 'Quản lý', 'Management'),
(143, 'report', 'Báo cáo', 'Report'),
(144, 'quan-ly-gv-cbnv', 'Quản lý giáo viên-cbnv', 'Staff managerment'),
(145, 'cap-quyen', 'Cấp quyá»n', 'Add rule'),
(146, 'cap-nhat-chuc-vu', 'Cáºp nháºt chức vụ', 'Staff's Functions'),
(147, 'ten-mon-hoc', 'Tên môn', 'Subject name'),
(148, 'cap-nhat-phong-hoc', 'Cáºp nháºt phòng há»c', 'Update class room'),
(149, 'ten-phong-hoc', 'Tên phòng há»c', 'Room name'),
(150, 'ten-phong-hoc-tieng-anh', 'Tên phòng há»c tiếng Anh', 'Room name english'),
(151, 'loai-phong-hoc', 'Loại phòng há»c', 'Room type'),
(152, 'so-cho-ngoi', 'Số chỗ ngồi', 'Number of'),
(153, 'ghi-chu', 'Ghi chú', 'Note'),
(154, 'phong-hoc', 'Phòng há»c', 'Classroom'),
(155, 'cap-nhat-khoi-lop', 'Cáºp nháºt khối lá»›p', 'Grade update'),
(156, 'ten-khoi', 'Tên khối', 'Grade name'),
(157, 'loai-khoi', 'Loại khối', 'Grade type'),
(158, 'cap-khoi', 'Khối', 'Level'),
(159, 'hoc-ky', 'Há»c kỳ', 'Term'),
(160, 'ten-lop', 'Tên lớp', 'Class name'),
(161, 'khoi-lop', 'Khối lớp', 'Grade'),
(162, 'cach-diem-danh', 'Cách điểm danh', 'Attendance type'),
(163, 'ca-ngay-khi-nghi', 'Chỉ tÃnh cả ngà y khi nghỉ', 'full day'),
(164, 'nghi-nua-buoi', 'Có thể nghỉ ná»a buổi', 'haft day'),
(165, 'giao-vien-chu-nhiem', 'Giáo viên chủ nhiệm', 'Homeroom teacher'),
(166, 'cap-nhat-lop-hoc', 'Cáºp nháºt lá»›p há»c', 'Update class'),
(167, 'mam-non', 'Mầm non', 'Kindergarten'),
(168, 'tieu-hoc', 'Tiểu há»c', 'Primary school'),
(169, 'thcs', 'Trung há»c cÆ¡ sở', 'Junior high school'),
(170, 'chon-cap-hoc', 'Chá»n cấp há»c', 'Choose classes'),
(171, 'huong-dan-pcgd', 'Cần xếp lại TKB khi có thay đổi phân công giảng dạy', 'Click on the check mark'),
(172, 'phonghoc-ngay', 'Phòng há»c/Ngà y', 'Room/Date'),
(173, 'buoi-sang', 'Sáng', 'Morning'),
(174, 'buoi-chieu', 'Chiá»u', 'Afternnoon'),
(175, 'buoi-toi', 'Tối', 'Night'),
(176, 'chon-lop', 'Chá»n lá»›p', 'Choose a class'),
(177, 'don-gia', 'ÄÆ¡n giá', 'Price'),
(178, 'tiet', 'Tiết', 'Lesson'),
(179, 'thoi-gian-tu', 'Thá»i gian từ', 'Time from'),
(180, 'den', 'Äến', 'To'),
(181, 'loai-tiet', 'Loại tiết', 'Lesson type'),
(182, 'dang-boi', 'Äăng bởi', 'Post by'),
(183, 'chon-mon-hoc', 'Chá»n môn há»c', 'Choose a subject'),
(184, 'chua-sap-phong-hoc', 'ChÆ°a sắp phòng há»c', 'No main classroom'),
(185, 'thu', 'Thứ', 'Day of week'),
(186, 'buoi', 'Buổi', 'Session'),
(187, 'lop', 'Lá»›p', 'Class'),
(188, 'chon-khoi', 'Chá»n khối', 'Choose grade'),
(189, 'chon-ngay-ap-dung', 'Chá»n ngà y áp dụng', 'Day apply'),
(190, 'ap-dung', 'Ãp dụng', 'Apply'),
(191, 'tong-so-lop', 'Tổng số lớp', 'Total class'),
(192, 'xoa-tkb', 'Xóa TKB', 'Delete timetable'),
(193, 'danh-sach-chuc-nang', 'Danh sách chức năng', 'list modules'),
(194, 'tiet-thu', 'Tiết/thứ', 'Lesson/weekday'),
(195, 'tkb-lop', 'Thá»i khóa biểu lá»›p', 'Timetable class'),
(196, 'theo-lop', 'Theo lá»›p', 'By class'),
(197, 'theo-giao-vien', 'Theo giáo viên', 'By teacher'),
(198, 'so-tiet-tuan', 'Số tiết/tuần', 'Lesson/week'),
(199, 'xep-tu-dong', 'Xếp tự động', 'Auto make timetable'),
(200, 'ten-cong-ty', 'Tên cơ sở', 'Campus name'),
(201, 'ten-cong-ty-tieng-anh', 'Tên tiếng Anh', 'Campus English name'),
(202, 'ten-cong-ty-day-du', 'Tên cơ sở đầy đủ', 'Campus fullname'),
(203, 'them-cong-ty', 'Thêm cơ sở', 'Add campus'),
(204, 'ten-cong-ty-day-du-tieng-anh', 'Tên cơ sở đầy đủ tiếng Anh', 'Campus English fullname'),
(205, 'la-co-so-con-cua', 'Là cơ sở con của', 'Sub campus of'),
(206, 'loai-co-so', 'Loại cơ sở', 'Campus type'),
(207, 'thong-tin-co-ban', 'Thông tin cơ bản', 'Basic information'),
(208, 'mam-non-va-pho-thong', 'Mầm non đến Phổ thông', 'Preschool to High School'),
(209, 'dai-hoc-va-sau-dai-hoc', 'Äại há»c & sau đại há»c', 'University & graduate'),
(210, 'trang-thai', 'Trang thái', 'Status'),
(211, 'dang-hoat-dong', 'Äang hoạt Ä‘á»™ng', 'Active'),
(212, 'dang-xay-dung', 'Äang xây dá»±ng', 'Pending'),
(213, 'thong-tin-khac', 'Thông tin khác', 'Other infomation'),
(214, 'them-co-so', 'Thêm cơ sở', 'Add new'),
(215, 'quan-tri', 'Quản trị viên', 'Administrator'),
(216, 'ton-giao', 'Tôn giáo', 'Religion'),
(217, 'nam-hoc', 'Khóa há»c', 'Learn Year'),
(218, 'ten-nam-hoc', 'Tên khóa há»c', 'Learn Year Name'),
(219, 'ngay-bat-dau', 'Ngà y bắt đầu', 'Begin day'),
(220, 'ngay-ket-thuc', 'Ngà y kết thúc', 'End day'),
(221, 'cap-nhat', 'Cáºp nháºt', 'Update'),
(222, 'tra-cuu', 'Tra cứu', 'Research'),
(223, 'quan-ly', 'Quản lý', 'Management'),
(224, 'bao-cao', 'Báo cáo', 'Report'),
(225, 'cai-dat', 'Cà i đặt', 'Setting'),
(226, 'don-vi', 'ÄÆ¡n vị', 'Campus'),
(227, 'ngon-ngu', 'Ngôn ngữ', 'Language'),
(228, 'chuc-nang', 'Chức năng', 'Modules'),
(229, 'quoc-gia', 'Quốc gia', 'Country'),
(230, 'dong-y-cap-nhat', 'Äồng ý cáºp nháºt', 'Agree update'),
(231, 'tinh-thanh', 'Tỉnh - Thà nh', 'Province city'),
(232, 'du-lieu-goc', 'Dữ liệu gốc', 'Master data'),
(233, 'cap-hoc', 'Cấp', 'Level'),
(234, 'cap-nhat-hoc-ky', 'Cáºp nháºt há»c kỳ', 'Term update'),
(235, 'ten-hoc-ky', 'Tên há»c kỳ', 'Term name'),
(236, 'ngay-khoa-so-diem', 'Ngà y khóa sổ điểm', 'Update Score Finish'),
(237, 'ten-mon-hoc-tieng-anh', 'Tên môn há»c tiếng Anh', 'Subject English'),
(238, 'loai-mon-hoc', 'Loại môn há»c', 'Subject type'),
(239, 'ten-mon-hoc-viet-tat', 'Tên môn há»c viết tắt', 'Subjects abbreviated'),
(240, 'cap-nhat-mon-hoc', 'Cáºp nháºt môn há»c', 'Update Subject'),
(241, 'nhom-loai-mon-hoc', 'Nhóm môn há»c', 'Subject category'),
(242, 'cap-bat-dau', 'Cấp bắt đầu', 'Begin grade'),
(243, 'tinh-diem', 'TÃnh Ä‘iểm', 'Score type'),
(244, 'he-so', 'Hệ số', 'Score const'),
(245, 'diem', 'Äiểm', 'Write score'),
(246, 'danh-gia', 'Äánh giá', 'Comment'),
(247, 'cap-nhat-lop', 'Cáºp nháºt lá»›p', 'Class update'),
(248, 'gvcn', 'Giáo viên chủ nhiệm', 'Homeroom teacher'),
(249, 'giam-thi', 'Giám thị', 'Supervisory'),
(250, 'tim-hocsinh', 'Tìm há»c sinh', 'Student filter'),
(251, 'diem-danh', 'Äiểm danh', 'Attendance'),
(252, 'khen-thuong', 'Khen thưởng', 'Laudatory'),
(253, 'ky-luat', 'Ká»· luáºt', 'Discipline'),
(254, 'chuyen-lop', 'Chuyển lớp', 'Change class'),
(255, 'chuyen-truong', 'Chuyển trÆ°á»ng', 'Change school'),
(256, 'tiep-nhan-chuyen-truong', 'Tiếp nháºn Chuyển trÆ°á»ng', 'Receive Transfer School'),
(257, 'bao-luu', 'Bảo lưu', 'Reserve'),
(258, 'nghi-hoc', 'Thôi há»c', 'Leave school'),
(259, 'tro-lai-hoc', 'Trở lại há»c', 'Back to school'),
(260, 'ngay-nhap-hoc', 'Ngà y nháºp há»c', 'Day admission'),
(261, 'suc-khoe-dinh-duong', 'Sức khá»e dinh dưỡng', 'Nutrition health'),
(262, 'xuat-du-lieu', 'Xuất dữ liệu', 'Export'),
(263, 'sap-xep', 'Sắp xếp', 'Sort'),
(264, 'tinh_thanh', 'Tỉnh thà nh', 'City'),
(265, 'nghe-nghiep', 'NghỠnghiệp', 'Job'),
(266, 'vi-pham-hs', 'Vi phạm', 'Violating'),
(267, 'khen-thuong-hs', 'Danh mục Khen thưởng', 'laudatory'),
(268, 'can-bo-lop', 'Cán bộ lớp', 'Student job'),
(269, 'dien-chinh-sach', 'Diện chÃnh sách', 'Policy area'),
(270, 'dang-doan', 'Äảng Ä‘oà n', 'Party unions'),
(271, 'tinh-trang-hoc', 'Tình trạng há»c', 'Status'),
(272, 'ho-ten-tieng-anh', 'HỠtên tiếng Anh', 'English full name'),
(273, 'nam-nhap-hoc', 'Năm nháºp há»c', 'Admission year'),
(274, 'thong-tin-chung', 'Thông tin chung', 'General information'),
(275, 'thong-tin-ca-nhan', 'Thông tin cá nhân', 'Profile'),
(276, 'family', 'Gia đình', 'Family'),
(277, 'thoi-hoc', 'Thôi há»c', 'Quit studying'),
(278, 'tac-vu', 'Tác vụ', 'Action'),
(279, 'ghi-chu-diem-danh', 'Chỉ cáºp nháºt khi há»c sinh nghỉ, <code>mặc định là há»c sinh có há»c nếu không cáºp nháºt.</code>', 'Only update when a student is absent, <code> defaults to student learning if not updated. </code>'),
(280, 'loai-diem-danh', 'Loại điểm danh', 'Kind of attendance'),
(281, 'thoi-gian', 'Thá»i gian', 'Time'),
(282, 'hinh-thuc-thong-bao', 'Cách thông báo', 'How to notify'),
(283, 'loai-khen-thuong', 'Hình thức khen thưởng', 'Form of reward'),
(284, 'noi-dung', 'Ná»™i dung', 'Content'),
(285, 'van-phong-cong-ty', 'Văn phòng công ty', 'Head office'),
(286, 'danh-sach', 'Danh sách', 'List'),
(287, 'confirm-xoa', 'Bạn có chắc muốn xóa?', 'Are you sure you want to delete?'),
(288, 'da-xoa', 'Äã xóa dữ liệu', 'Data deleted'),
(289, 'lop-chuyen-den', 'Lớp chuyển đến', 'Class moved on'),
(290, 'chuyen-truong-trong', 'Chuyển trÆ°á»ng trong hệ thống', 'School transfer in the system'),
(291, 'chuyen-truong-ngoai', 'Chuyển trÆ°á»ng ngoà i hệ thống', 'Transfer outside the system'),
(292, 'truong-chuyen-den', 'TrÆ°á»ng chuyển đến', 'School moved to'),
(293, 'danh-muc-mon-hoc', 'Danh mục môn há»c', 'Subject category'),
(294, 'ly-do-thoi-hoc', 'Lý do thôi há»c', 'The reason for quitting school'),
(295, 'mien-giam-mon-hoc', 'Miá»…n giảm môn há»c', 'Subject exemption and reduction'),
(296, 'doi-tuong-mien-giam-mon-hoc', 'Äối tượng miá»…n giảm môn há»c', 'Subjects exempted from subjects'),
(297, 'bmi', 'BMI <a href="https://vi.wikipedia.org/wiki/Ch%E1%BB%89_s%E1%BB%91_kh%E1%BB%91i_c%C6%A1_th%E1%BB%83">?</a>', 'BMI <a href="https://vi.wikipedia.org/wiki/Ch%E1%BB%89_s%E1%BB%91_kh%E1%BB%91i_c%C6%A1_th%E1%BB%83">?</a>'),
(298, 'cong-viec', 'Công việc', 'Job type'),
(299, 'ten-cong-viec', 'Tên công việc', 'Job name'),
(300, 'noi-lam-viec', 'Nơi là m việc', 'Job place'),
(301, 'muc-thu-nhap', 'Mức thu nháºp', 'Income'),
(302, 'nam-sinh', 'Năm sinh', 'Birthyear'),
(303, 'dien-thoai-nha', 'Äiện thoại nhà ', 'Homephone'),
(304, 'chon-moi-quan-he', 'Chá»n mối quan hệ', 'Select the relationship'),
(305, 'nguoi-dang-co-the-xoa', 'Chỉ ngÆ°á»i đăng má»›i có thể xóa!', 'Only the poster can delete!'),
(306, 'la-phu-huynh-cua', 'Là phụ huynh của', 'As a parent of'),
(307, 'them-con', 'Thêm con', 'Add student'),
(308, 'tim-hoc-sinh', 'Tìm há»c sinh', 'Search Student'),
(309, 'gia-dinh', 'Gia đình', 'Family'),
(310, 'tim-phuhuynh', 'Tìm phụ huynh', 'Search parent'),
(311, 'quan-ly-phu-hunh', 'Quản lý phụ huynh', 'Parent management'),
(312, 'chua-cap-nhat-hoc-sinh', 'Chưa thêm con', 'Not add any student'),
(313, 'da-cap-nhat-hoc-sinh', 'Äã thêm con', 'Added student'),
(314, 'phu-huynh', 'Phụ huynh', 'Parent'),
(315, 'anh-em', 'Anh em', 'Brothers'),
(316, 'them-phu-huynh', 'Thêm phụ huynh', 'Add parent'),
(317, 'tim-phu-huynh', 'Tìm phụ huynh', 'Search parent'),
(318, 'chuong-trinh-dac-thu', 'Chương trình đặc thù', 'Specific program'),
(319, 'si-so', 'Sỉ số', 'students in class'),
(320, 'danh-muc-chuc-nang', 'Danh mục chức năng', 'Category module'),
(321, 'bang-dieu-khien', 'Bảng Ä‘iá»u khiển', 'Dashboard');
-- --------------------------------------------------------
--
-- Table structure for table `tb_loging`
--
CREATE TABLE `tb_loging` (
`login_id` int(11) NOT NULL,
`user_id` int(11) DEFAULT NULL,
`session_data` text COLLATE utf8mb4_unicode_ci,
`time_login` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `tb_menus`
--
CREATE TABLE `tb_menus` (
`menus_id` int(11) NOT NULL,
`menus_parentid` int(11) DEFAULT NULL,
`menus_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`menus_ename` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`menus_icon` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`menus_img` text COLLATE utf8mb4_unicode_ci,
`menus_pos` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`menus_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'normal',
`menus_url` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_menus`
--
INSERT INTO `tb_menus` (`menus_id`, `menus_parentid`, `menus_name`, `menus_ename`, `menus_icon`, `menus_img`, `menus_pos`, `user_id`, `menus_type`, `menus_url`) VALUES
(2, 0, 'Trang chủ', 'Home', '', '2_1640787396', '1', 2, 'page', 'http://localhost/thietkeweb2/'),
(3, 2, 'Trang chủ 1', 'Home 1', '', NULL, '1.1', 2, 'page', ''),
(4, 2, 'Trang chủ 2', 'Home 2', '', NULL, '1.2', 2, 'page', ''),
(5, 0, 'Giới thiệu', 'About us', '', NULL, '2', 2, 'normal', NULL),
(6, 0, 'Mẫu website', 'Website Demo', '', NULL, '3', 2, 'normal', NULL),
(7, 0, 'Hosting', 'Hosting', '', NULL, '4', 2, 'normal', NULL),
(8, 0, 'Dịch vụ', 'Service', '', NULL, '5', 2, 'normal', NULL),
(9, 7, 'Bảng giá hosting', 'Hosting price list', '', NULL, '4.1', 2, 'normal', NULL),
(10, 7, 'Host chất lượng cao', 'High quality hosting', '', NULL, '4.2', 2, 'normal', NULL),
(11, 7, 'Super Host', 'Super Host', '', NULL, '4.3', 2, 'normal', NULL),
(12, 7, 'Các gói web Hosting', 'Web Hosting Packages', '', NULL, '4.4', 2, 'normal', NULL),
(13, 8, 'Quảng cáo Facebook', 'Facebook Ads', '', NULL, '5.1', 2, 'normal', NULL),
(14, 8, 'Quảng cáo Google Adword', 'Google Adwords Advertising', '', NULL, '5.2', 2, 'normal', NULL),
(15, 8, 'Quảng cáo Zalo', 'Zalo advertising ', '', NULL, '5.3', 2, 'normal', NULL),
(16, 8, 'Thiết kế Website', 'Website design', '', NULL, '5.4', 2, 'normal', NULL),
(17, 8, 'SEO Từ Khóa', 'SEO Keywords', '', NULL, '5.5', 2, 'normal', NULL),
(18, 8, 'Email Marketing', 'Email Marketing', '', NULL, '5.6', 2, 'normal', NULL),
(19, 8, 'Video Marketing', 'Video Marketing', '', NULL, '5.7', 2, 'normal', NULL),
(20, 0, 'Bảng giá', 'Price list', '', NULL, '6', 2, 'normal', NULL),
(21, 0, 'Tin tức', 'News', '', NULL, '7', 2, 'normal', NULL),
(22, 0, 'Kiến thức', 'Knowledge', '', NULL, '8', 2, 'normal', NULL),
(23, 0, 'Liên hệ', 'Contact', '', NULL, '9', 2, 'page', 'http://localhost/thietkeweb2/?act=contact'),
(25, 9, 'Host 1', 'Host 1', '', NULL, '4.1.1', 2, 'normal', ''),
(26, 9, 'Host 2', 'Host 2', '', NULL, '4.1.2', 2, 'normal', '');
-- --------------------------------------------------------
--
-- Table structure for table `tb_menus_pages`
--
CREATE TABLE `tb_menus_pages` (
`id` bigint(20) NOT NULL,
`menus_id` int(11) NOT NULL,
`pages_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_menus_pages`
--
INSERT INTO `tb_menus_pages` (`id`, `menus_id`, `pages_id`) VALUES
(62, 8, 1),
(63, 16, 1),
(69, 7, 2),
(70, 11, 2),
(71, 8, 2),
(72, 16, 2),
(73, 17, 2),
(74, 7, 4),
(75, 9, 4),
(76, 25, 4);
-- --------------------------------------------------------
--
-- Table structure for table `tb_module`
--
CREATE TABLE `tb_module` (
`module_id` int(11) NOT NULL,
`module_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`module_ename` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`module_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`module_cat` int(11) DEFAULT NULL,
`module_url` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`module_location` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`module_icon` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`module_image` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`module_time` datetime DEFAULT NULL,
`module_status` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`module_pos` int(11) DEFAULT NULL,
`module_des` text COLLATE utf8mb4_unicode_ci,
`module_edes` text COLLATE utf8mb4_unicode_ci,
`module_guide` longtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_module`
--
INSERT INTO `tb_module` (`module_id`, `module_name`, `module_ename`, `module_type`, `module_cat`, `module_url`, `module_location`, `module_icon`, `module_image`, `module_time`, `module_status`, `module_pos`, `module_des`, `module_edes`, `module_guide`) VALUES
(1, 'Cà i đặt website', 'Settings', '', 1, 'act=admin&code=settings', '', '', '', '2021-11-17 00:00:00', 'active', 1, 'Cà i đặt website', 'Customer', ''),
(2, 'Quản lý công ty', 'Legal information', '', 8, 'act=management&code=company', '', '', '', '2021-11-10 00:00:00', 'active', 4, 'Quản lý công ty', 'Legal information', ''),
(3, 'Quản lý menu', 'Menu Manager', '', 4, 'act=admin&code=menus', '', '', '', '2021-12-28 00:00:00', 'active', 2, 'Quản lý menu', 'Menu Manager', ''),
(4, 'Quản lý bà i viết', 'Manage Posts', '', 3, 'act=admin&code=posts', '', '', '', '2021-12-31 00:00:00', 'active', 5, 'Quản lý bà i viết', 'Manage Posts', ''),
(5, 'Quản lý trang chủ', 'Homepage manager', NULL, 1, 'act=admin&code=homepage', '', '', '', '2021-11-17 00:00:00', 'active', 3, 'Quản lý trang chủ', 'Homepage manager', ''),
(6, 'Quản lý trang', 'Page manager', NULL, 3, 'act=admin&code=pages', '', '', '', '2021-12-31 00:00:00', 'active', 10, 'Quản lý trang', 'Page manager', ''),
(7, 'Quản lý banner', 'Banner manager', NULL, 1, 'act=admin&code=banner', '', '', '', '2022-01-10 00:00:00', 'active', 3, 'Quản lý banner', 'Banner manager', ''),
(8, 'Quản lý block', 'Blocks manager', NULL, 1, 'act=admin&code=block', '', '', '', '2022-01-10 00:00:00', 'active', 4, 'Quản lý các block', 'Blocks manager', '');
-- --------------------------------------------------------
--
-- Table structure for table `tb_module_category`
--
CREATE TABLE `tb_module_category` (
`module_category_id` int(11) NOT NULL,
`module_category_parentid` int(11) DEFAULT NULL,
`module_category_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`module_category_ename` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`module_category_icon` text COLLATE utf8mb4_unicode_ci,
`module_category_img` text COLLATE utf8mb4_unicode_ci,
`module_category_pos` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_module_category`
--
INSERT INTO `tb_module_category` (`module_category_id`, `module_category_parentid`, `module_category_name`, `module_category_ename`, `module_category_icon`, `module_category_img`, `module_category_pos`, `user_id`) VALUES
(1, 0, 'Cà i đặt', 'Settings', '<i class="fas fa-search-location"></i>', NULL, 1, 0),
(3, 0, 'Bà i viết', 'Pages', '<i class="fas fa-file-contract"></i>', NULL, 3, 0),
(4, 0, 'Menu', 'Menu', '<i class="fab fa-servicestack"></i>', NULL, 2, 0),
(5, 0, 'Form', 'Form', '<i class="fas fa-file-invoice"></i>', NULL, 4, 0),
(6, 0, 'Gá»i email', 'Email', '<i class="far fa-envelope"></i>', NULL, 5, 0),
(7, 0, 'Users', 'Users', '<i class="fas fa-users"></i>', NULL, 6, 0),
(8, 0, 'Công ty', 'Company', '<i class="fas fa-building"></i>', NULL, 7, 0);
-- --------------------------------------------------------
--
-- Table structure for table `tb_nghenghiep`
--
CREATE TABLE `tb_nghenghiep` (
`nghenghiep_id` int(11) NOT NULL,
`nghenghiep_vi` tinytext COLLATE utf8mb4_unicode_ci,
`nghenghiep_en` tinytext COLLATE utf8mb4_unicode_ci,
`nghenghiep_pos` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_nghenghiep`
--
INSERT INTO `tb_nghenghiep` (`nghenghiep_id`, `nghenghiep_vi`, `nghenghiep_en`, `nghenghiep_pos`) VALUES
(1, 'Khác', 'Khác', 0),
(2, 'Sản xuất / Xuất nháºp khẩu', 'Sản xuất / Xuất nháºp khẩu', 1),
(3, 'Xây dựng ( thợ hồ, kỹ sư xây dựng)', 'Xây dựng ( thợ hồ, kỹ sư xây dựng)', 3),
(4, 'Viễn Thông (bưu điện,...)', 'Viễn Thông (bưu điện,...)', 4),
(5, 'Tiếp thị / Marketing', 'Tiếp thị / Marketing', 5),
(6, 'Thá»i vụ / Hợp Äồng (tá»± do)', 'Thá»i vụ / Hợp Äồng (tá»± do)', 5),
(7, 'Quảng cáo / Khuyến mãi / Ngoại Giao', 'Quảng cáo / Khuyến mãi / Ngoại Giao', 7),
(8, 'Nhân sá»± / Hà nh chÃnh ( cnvc nhà nÆ°á»›c)', 'Nhân sá»± / Hà nh chÃnh ( cnvc nhà nÆ°á»›c)', 8),
(9, 'Pháp lý (luáºt sÆ° , quan tòa...)', 'Pháp lý (luáºt sÆ° , quan tòa...)', 9);
-- --------------------------------------------------------
--
-- Table structure for table `tb_options`
--
CREATE TABLE `tb_options` (
`option_id` bigint(20) UNSIGNED NOT NULL,
`option_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`option_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`autoload` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_options`
--
INSERT INTO `tb_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES
(1, 'siteurl', 'http://localhost/thietkeweb2', 'yes'),
(2, 'home', 'http://localhost/wordpress', 'yes'),
(3, 'blogname', 'Adimi - Công ty thiết kế website cao cấp, chuyên nghiệp', 'yes'),
(4, 'blogdescription', 'Adimi là công ty thiết kế website chuyên vá» thị trÆ°á»ng cao cấp. Ngoà i ra chúng tôi còn thá»±c hiện láºp trình phần má»m, IOS/Android và dịch vụ SEO', 'yes'),
(5, 'users_can_register', '0', 'yes'),
(6, 'admin_email', 'xxxgiacxxx@gmail.com', 'yes'),
(7, 'start_of_week', '1', 'yes'),
(8, 'logo_website', '2021/11/logo_1637150436_6194eee434f17.png', 'yes'),
(9, 'keyword_homepage', 'cao cấp, chuyên nghiệp', 'yes'),
(10, 'google_analytics', '', 'yes'),
(11, 'facebook_messenger', '', 'yes'),
(12, 'phone_homepage', '0947973379', 'yes'),
(13, 'website_address', '', 'yes'),
(14, 'mailserver_url', 'mail.example.com', 'yes'),
(15, 'mailserver_login', 'login@example.com', 'yes'),
(16, 'mailserver_pass', 'password', 'yes'),
(17, 'mailserver_port', '110', 'yes'),
(18, 'website_email', 'info@kvvanhvu.com', 'yes'),
(19, 'email_newsletter', 'info@kvvanhvu.com', 'yes'),
(20, 'header_block', '<div id="topbar" class="text-white bg-color topbar-noborder">\n <div class="container">\n <div class="topbar-left sm-hide">\n <span class="topbar-widget tb-social ">\n <a href="#"><i class="fa fa-facebook"></i></a>\n <a href="#"><i class="fa fa-twitter"></i></a>\n <a href="#"><i class="fa fa-instagram"></i></a>\n </span>\n </div>\n <div class="topbar-right">\n <span class="topbar-widget"><a href="#">Privacy policy</a></span>\n <span class="topbar-widget"><a href="#">Request Quote</a></span>\n <span class="topbar-widget"><a href="#">FAQ</a></span>\n </div>\n <div class="clearfix"></div>\n </div>\n </div>', 'yes'),
(21, 'footer_block', '<footer>\n <div class="container">\n <div class="row">\n <div class="col-lg-4">\n <div class="widget">\n <a href="index.html"><img alt="" class="img-fluid mb20" src="images/logo-light.png"></a>\n <address class="s1">\n <span><i class="id-color fa fa-map-marker fa-lg"></i>Số 58 ÄÆ°á»ng SÆ° Vạn Hạnh, Khóm Bình Khánh 7, PhÆ°á»ng Bình Khánh, Thà nh phố Long Xuyên, Tỉnh An Giang\n</span>\n <span><i class="id-color fa fa-phone fa-lg"></i>1 200 300 9000</span>\n <span><i class="id-color fa fa-envelope-o fa-lg"></i><a href="mailto:contact@example.com">contact@motivatemplate.com</a></span>\n <span><i class="id-color fa fa-file-pdf-o fa-lg"></i><a href="#">Download Brochure</a></span>\n </address>\n </div>\n </div>\n <div class="col-md-4">\n <h5 class="id-color mb20">Upcoming Events</h5>\n <ul class="ul-style-2">\n <li><a href="event-single-1.html">Attitude is Everything</a></li>\n <li><a href="event-single-2.html">The Winning Mindset</a></li>\n <li><a href="event-single-3.html">Sales Breakthrough</a></li>\n <li><a href="event-single-4.html">Effective Communication Skills</a></li>\n <li><a href="event-single-5.html">Be The Game Changer</a></li>\n <li><a href="event-single-6.html">I Can and I Will</a></li>\n </ul>\n </div>\n <div class="col-lg-4">\n <div class="widget">\n <h5 class="id-color">Newsletter</h5>\n <p>Signup for our newsletter to get the latest news, updates and special offers in your inbox.</p>\n \n <div class="col text-center">\n <input class="form-control" id="email_subscribe" name="email_subscribe" placeholder="enter your email" type="text"> <a href="#" id="btn-submit"><i class="fa fa-long-arrow-right"></i></a>\n <div class="clearfix"></div>\n </div>\n \n <div class="spacer-10"></div>\n <small class="text-white-op-5">Your email is safe with us. We don't spam.</small>\n </div>\n </div>\n </div>\n </div>\n <div class="subfooter">\n <div class="container">\n <div class="row">\n <div class="col-md-12">\n <div class="de-flex">\n <div class="de-flex-col">\n © Copyright 2021 - Motiva by Designesia\n </div>\n <div class="de-flex-col">\n <div class="social-icons">\n <a href="#"><i class="fa fa-facebook fa-lg"></i></a>\n <a href="#"><i class="fa fa-twitter fa-lg"></i></a>\n <a href="#"><i class="fa fa-instagram fa-lg"></i></a>\n <a href="#"><i class="fa fa-spotify fa-lg"></i></a>\n <a href="#"><i class="fa fa-youtube fa-lg"></i></a>\n </div>\n </div>\n </div>\n </div>\n </div>\n </div>\n </div>\n</footer>', 'yes'),
(22, 'posts_per_page', '10', 'yes'),
(23, 'icon_website', '2021/11/fav_1637168856_619536d8d8ee0.png', 'yes'),
(24, 'time_format', 'g:i a', 'yes'),
(25, 'share_image_website', '2021/11/share_image_1637152398_6194f68e2da70.png', 'yes'),
(26, 'comment_moderation', '0', 'yes'),
(27, 'moderation_notify', '1', 'yes'),
(28, 'permalink_structure', '/%year%/%monthnum%/%day%/%postname%/', 'yes'),
(29, 'rewrite_rules', 'a:79:{s:11:\"^wp-json/?$\";s:22:\"index.php?rest_route=/\";s:14:\"^wp-json/(.*)?\";s:33:\"index.php?rest_route=/$matches[1]\";s:21:\"^index.php/wp-json/?$\";s:22:\"index.php?rest_route=/\";s:24:\"^index.php/wp-json/(.*)?\";s:33:\"index.php?rest_route=/$matches[1]\";s:17:\"^wp-sitemap\\.xml$\";s:23:\"index.php?sitemap=index\";s:17:\"^wp-sitemap\\.xsl$\";s:36:\"index.php?sitemap-stylesheet=sitemap\";s:23:\"^wp-sitemap-index\\.xsl$\";s:34:\"index.php?sitemap-stylesheet=index\";s:48:\"^wp-sitemap-([a-z]+?)-([a-z\\d_-]+?)-(\\d+?)\\.xml$\";s:75:\"index.php?sitemap=$matches[1]&sitemap-subtype=$matches[2]&paged=$matches[3]\";s:34:\"^wp-sitemap-([a-z]+?)-(\\d+?)\\.xml$\";s:47:\"index.php?sitemap=$matches[1]&paged=$matches[2]\";s:48:\".*wp-(atom|rdf|rss|rss2|feed|commentsrss2)\\.php$\";s:18:\"index.php?feed=old\";s:20:\".*wp-app\\.php(/.*)?$\";s:19:\"index.php?error=403\";s:18:\".*wp-register.php$\";s:23:\"index.php?register=true\";s:32:\"feed/(feed|rdf|rss|rss2|atom)/?$\";s:27:\"index.php?&feed=$matches[1]\";s:27:\"(feed|rdf|rss|rss2|atom)/?$\";s:27:\"index.php?&feed=$matches[1]\";s:8:\"embed/?$\";s:21:\"index.php?&embed=true\";s:20:\"page/?([0-9]{1,})/?$\";s:28:\"index.php?&paged=$matches[1]\";s:41:\"comments/feed/(feed|rdf|rss|rss2|atom)/?$\";s:42:\"index.php?&feed=$matches[1]&withcomments=1\";s:36:\"comments/(feed|rdf|rss|rss2|atom)/?$\";s:42:\"index.php?&feed=$matches[1]&withcomments=1\";s:17:\"comments/embed/?$\";s:21:\"index.php?&embed=true\";s:44:\"search/(.+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:40:\"index.php?s=$matches[1]&feed=$matches[2]\";s:39:\"search/(.+)/(feed|rdf|rss|rss2|atom)/?$\";s:40:\"index.php?s=$matches[1]&feed=$matches[2]\";s:20:\"search/(.+)/embed/?$\";s:34:\"index.php?s=$matches[1]&embed=true\";s:32:\"search/(.+)/page/?([0-9]{1,})/?$\";s:41:\"index.php?s=$matches[1]&paged=$matches[2]\";s:14:\"search/(.+)/?$\";s:23:\"index.php?s=$matches[1]\";s:47:\"author/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:50:\"index.php?author_name=$matches[1]&feed=$matches[2]\";s:42:\"author/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:50:\"index.php?author_name=$matches[1]&feed=$matches[2]\";s:23:\"author/([^/]+)/embed/?$\";s:44:\"index.php?author_name=$matches[1]&embed=true\";s:35:\"author/([^/]+)/page/?([0-9]{1,})/?$\";s:51:\"index.php?author_name=$matches[1]&paged=$matches[2]\";s:17:\"author/([^/]+)/?$\";s:33:\"index.php?author_name=$matches[1]\";s:69:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/feed/(feed|rdf|rss|rss2|atom)/?$\";s:80:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed=$matches[4]\";s:64:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/(feed|rdf|rss|rss2|atom)/?$\";s:80:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed=$matches[4]\";s:45:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/embed/?$\";s:74:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&embed=true\";s:57:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/page/?([0-9]{1,})/?$\";s:81:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&paged=$matches[4]\";s:39:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/?$\";s:63:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]\";s:56:\"([0-9]{4})/([0-9]{1,2})/feed/(feed|rdf|rss|rss2|atom)/?$\";s:64:\"index.php?year=$matches[1]&monthnum=$matches[2]&feed=$matches[3]\";s:51:\"([0-9]{4})/([0-9]{1,2})/(feed|rdf|rss|rss2|atom)/?$\";s:64:\"index.php?year=$matches[1]&monthnum=$matches[2]&feed=$matches[3]\";s:32:\"([0-9]{4})/([0-9]{1,2})/embed/?$\";s:58:\"index.php?year=$matches[1]&monthnum=$matches[2]&embed=true\";s:44:\"([0-9]{4})/([0-9]{1,2})/page/?([0-9]{1,})/?$\";s:65:\"index.php?year=$matches[1]&monthnum=$matches[2]&paged=$matches[3]\";s:26:\"([0-9]{4})/([0-9]{1,2})/?$\";s:47:\"index.php?year=$matches[1]&monthnum=$matches[2]\";s:43:\"([0-9]{4})/feed/(feed|rdf|rss|rss2|atom)/?$\";s:43:\"index.php?year=$matches[1]&feed=$matches[2]\";s:38:\"([0-9]{4})/(feed|rdf|rss|rss2|atom)/?$\";s:43:\"index.php?year=$matches[1]&feed=$matches[2]\";s:19:\"([0-9]{4})/embed/?$\";s:37:\"index.php?year=$matches[1]&embed=true\";s:31:\"([0-9]{4})/page/?([0-9]{1,})/?$\";s:44:\"index.php?year=$matches[1]&paged=$matches[2]\";s:13:\"([0-9]{4})/?$\";s:26:\"index.php?year=$matches[1]\";s:58:\"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/?$\";s:32:\"index.php?attachment=$matches[1]\";s:68:\"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/trackback/?$\";s:37:\"index.php?attachment=$matches[1]&tb=1\";s:88:\"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:83:\"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:83:\"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/comment-page-([0-9]{1,})/?$\";s:50:\"index.php?attachment=$matches[1]&cpage=$matches[2]\";s:64:\"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/embed/?$\";s:43:\"index.php?attachment=$matches[1]&embed=true\";s:53:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/([^/]+)/embed/?$\";s:91:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&name=$matches[4]&embed=true\";s:57:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/([^/]+)/trackback/?$\";s:85:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&name=$matches[4]&tb=1\";s:77:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:97:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&name=$matches[4]&feed=$matches[5]\";s:72:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:97:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&name=$matches[4]&feed=$matches[5]\";s:65:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/([^/]+)/page/?([0-9]{1,})/?$\";s:98:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&name=$matches[4]&paged=$matches[5]\";s:72:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/([^/]+)/comment-page-([0-9]{1,})/?$\";s:98:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&name=$matches[4]&cpage=$matches[5]\";s:61:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/([^/]+)(?:/([0-9]+))?/?$\";s:97:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&name=$matches[4]&page=$matches[5]\";s:47:\"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/([^/]+)/?$\";s:32:\"index.php?attachment=$matches[1]\";s:57:\"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/([^/]+)/trackback/?$\";s:37:\"index.php?attachment=$matches[1]&tb=1\";s:77:\"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:72:\"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:72:\"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/([^/]+)/comment-page-([0-9]{1,})/?$\";s:50:\"index.php?attachment=$matches[1]&cpage=$matches[2]\";s:53:\"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/([^/]+)/embed/?$\";s:43:\"index.php?attachment=$matches[1]&embed=true\";s:64:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/comment-page-([0-9]{1,})/?$\";s:81:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&cpage=$matches[4]\";s:51:\"([0-9]{4})/([0-9]{1,2})/comment-page-([0-9]{1,})/?$\";s:65:\"index.php?year=$matches[1]&monthnum=$matches[2]&cpage=$matches[3]\";s:38:\"([0-9]{4})/comment-page-([0-9]{1,})/?$\";s:44:\"index.php?year=$matches[1]&cpage=$matches[2]\";s:27:\".?.+?/attachment/([^/]+)/?$\";s:32:\"index.php?attachment=$matches[1]\";s:37:\".?.+?/attachment/([^/]+)/trackback/?$\";s:37:\"index.php?attachment=$matches[1]&tb=1\";s:57:\".?.+?/attachment/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:52:\".?.+?/attachment/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:52:\".?.+?/attachment/([^/]+)/comment-page-([0-9]{1,})/?$\";s:50:\"index.php?attachment=$matches[1]&cpage=$matches[2]\";s:33:\".?.+?/attachment/([^/]+)/embed/?$\";s:43:\"index.php?attachment=$matches[1]&embed=true\";s:16:\"(.?.+?)/embed/?$\";s:41:\"index.php?pagename=$matches[1]&embed=true\";s:20:\"(.?.+?)/trackback/?$\";s:35:\"index.php?pagename=$matches[1]&tb=1\";s:40:\"(.?.+?)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:47:\"index.php?pagename=$matches[1]&feed=$matches[2]\";s:35:\"(.?.+?)/(feed|rdf|rss|rss2|atom)/?$\";s:47:\"index.php?pagename=$matches[1]&feed=$matches[2]\";s:28:\"(.?.+?)/page/?([0-9]{1,})/?$\";s:48:\"index.php?pagename=$matches[1]&paged=$matches[2]\";s:35:\"(.?.+?)/comment-page-([0-9]{1,})/?$\";s:48:\"index.php?pagename=$matches[1]&cpage=$matches[2]\";s:24:\"(.?.+?)(?:/([0-9]+))?/?$\";s:47:\"index.php?pagename=$matches[1]&page=$matches[2]\";}', 'yes'),
(30, 'map_api_key', '', 'yes'),
(31, 'map_latitude', '', 'yes'),
(32, 'map_longitude', '', ''),
(33, 'active_plugins', 'a:0:{}', 'yes'),
(34, 'category_base', '', 'yes'),
(35, 'ping_sites', 'http://rpc.pingomatic.com/', 'yes'),
(36, 'comment_max_links', '2', 'yes'),
(37, 'show_banner', 'no', 'yes'),
(38, 'show_en', 'yes', 'yes'),
(39, 'recently_edited', '', 'no'),
(40, 'template', 'twentytwentyone', 'yes'),
(41, 'stylesheet', 'twentytwentyone', 'yes'),
(42, 'comment_registration', '0', 'yes'),
(43, 'html_type', 'text/html', 'yes'),
(44, 'use_trackback', '0', 'yes'),
(45, 'default_role', 'subscriber', 'yes'),
(46, 'db_version', '49752', 'yes'),
(47, 'uploads_use_yearmonth_folders', '1', 'yes'),
(48, 'upload_path', '', 'yes'),
(49, 'blog_public', '1', 'yes'),
(50, 'default_link_category', '2', 'yes'),
(51, 'show_on_front', 'posts', 'yes'),
(52, 'tag_base', '', 'yes'),
(53, 'show_avatars', '1', 'yes'),
(54, 'avatar_rating', 'G', 'yes'),
(55, 'upload_url_path', '', 'yes'),
(56, 'thumbnail_size_w', '150', 'yes'),
(57, 'thumbnail_size_h', '150', 'yes'),
(58, 'thumbnail_crop', '1', 'yes'),
(59, 'medium_size_w', '300', 'yes'),
(60, 'medium_size_h', '300', 'yes'),
(61, 'avatar_default', 'mystery', 'yes'),
(62, 'large_size_w', '1024', 'yes'),
(63, 'large_size_h', '1024', 'yes'),
(64, 'image_default_link_type', 'none', 'yes'),
(65, 'image_default_size', '', 'yes'),
(66, 'image_default_align', '', 'yes'),
(67, 'close_comments_for_old_posts', '0', 'yes'),
(68, 'close_comments_days_old', '14', 'yes'),
(69, 'thread_comments', '1', 'yes'),
(70, 'thread_comments_depth', '5', 'yes'),
(71, 'page_comments', '0', 'yes'),
(72, 'comments_per_page', '50', 'yes'),
(73, 'default_comments_page', 'newest', 'yes'),
(74, 'comment_order', 'asc', 'yes'),
(75, 'sticky_posts', 'a:0:{}', 'yes'),
(76, 'widget_categories', 'a:0:{}', 'yes'),
(77, 'widget_text', 'a:0:{}', 'yes'),
(78, 'widget_rss', 'a:0:{}', 'yes'),
(79, 'uninstall_plugins', 'a:0:{}', 'no'),
(80, 'timezone_string', '', 'yes'),
(81, 'page_for_posts', '0', 'yes'),
(82, 'page_on_front', '0', 'yes'),
(83, 'default_post_format', '0', 'yes'),
(84, 'link_manager_enabled', '0', 'yes'),
(85, 'finished_splitting_shared_terms', '1', 'yes'),
(86, 'site_icon', '0', 'yes'),
(87, 'medium_large_size_w', '768', 'yes'),
(88, 'medium_large_size_h', '0', 'yes'),
(89, 'wp_page_for_privacy_policy', '3', 'yes'),
(90, 'show_comments_cookies_opt_in', '1', 'yes'),
(91, 'admin_email_lifespan', '1652631486', 'yes'),
(92, 'disallowed_keys', '', 'no'),
(93, 'comment_previously_approved', '1', 'yes'),
(94, 'auto_plugin_theme_update_emails', 'a:0:{}', 'no'),
(95, 'auto_update_core_dev', 'enabled', 'yes'),
(96, 'auto_update_core_minor', 'enabled', 'yes'),
(97, 'auto_update_core_major', 'enabled', 'yes'),
(98, 'wp_force_deactivated_plugins', 'a:0:{}', 'yes'),
(99, 'initial_db_version', '49752', 'yes'),
(100, 'wp_user_roles', 'a:5:{s:13:\"administrator\";a:2:{s:4:\"name\";s:13:\"Administrator\";s:12:\"capabilities\";a:61:{s:13:\"switch_themes\";b:1;s:11:\"edit_themes\";b:1;s:16:\"activate_plugins\";b:1;s:12:\"edit_plugins\";b:1;s:10:\"edit_users\";b:1;s:10:\"edit_files\";b:1;s:14:\"manage_options\";b:1;s:17:\"moderate_comments\";b:1;s:17:\"manage_categories\";b:1;s:12:\"manage_links\";b:1;s:12:\"upload_files\";b:1;s:6:\"import\";b:1;s:15:\"unfiltered_html\";b:1;s:10:\"edit_posts\";b:1;s:17:\"edit_others_posts\";b:1;s:20:\"edit_published_posts\";b:1;s:13:\"publish_posts\";b:1;s:10:\"edit_pages\";b:1;s:4:\"read\";b:1;s:8:\"level_10\";b:1;s:7:\"level_9\";b:1;s:7:\"level_8\";b:1;s:7:\"level_7\";b:1;s:7:\"level_6\";b:1;s:7:\"level_5\";b:1;s:7:\"level_4\";b:1;s:7:\"level_3\";b:1;s:7:\"level_2\";b:1;s:7:\"level_1\";b:1;s:7:\"level_0\";b:1;s:17:\"edit_others_pages\";b:1;s:20:\"edit_published_pages\";b:1;s:13:\"publish_pages\";b:1;s:12:\"delete_pages\";b:1;s:19:\"delete_others_pages\";b:1;s:22:\"delete_published_pages\";b:1;s:12:\"delete_posts\";b:1;s:19:\"delete_others_posts\";b:1;s:22:\"delete_published_posts\";b:1;s:20:\"delete_private_posts\";b:1;s:18:\"edit_private_posts\";b:1;s:18:\"read_private_posts\";b:1;s:20:\"delete_private_pages\";b:1;s:18:\"edit_private_pages\";b:1;s:18:\"read_private_pages\";b:1;s:12:\"delete_users\";b:1;s:12:\"create_users\";b:1;s:17:\"unfiltered_upload\";b:1;s:14:\"edit_dashboard\";b:1;s:14:\"update_plugins\";b:1;s:14:\"delete_plugins\";b:1;s:15:\"install_plugins\";b:1;s:13:\"update_themes\";b:1;s:14:\"install_themes\";b:1;s:11:\"update_core\";b:1;s:10:\"list_users\";b:1;s:12:\"remove_users\";b:1;s:13:\"promote_users\";b:1;s:18:\"edit_theme_options\";b:1;s:13:\"delete_themes\";b:1;s:6:\"export\";b:1;}}s:6:\"editor\";a:2:{s:4:\"name\";s:6:\"Editor\";s:12:\"capabilities\";a:34:{s:17:\"moderate_comments\";b:1;s:17:\"manage_categories\";b:1;s:12:\"manage_links\";b:1;s:12:\"upload_files\";b:1;s:15:\"unfiltered_html\";b:1;s:10:\"edit_posts\";b:1;s:17:\"edit_others_posts\";b:1;s:20:\"edit_published_posts\";b:1;s:13:\"publish_posts\";b:1;s:10:\"edit_pages\";b:1;s:4:\"read\";b:1;s:7:\"level_7\";b:1;s:7:\"level_6\";b:1;s:7:\"level_5\";b:1;s:7:\"level_4\";b:1;s:7:\"level_3\";b:1;s:7:\"level_2\";b:1;s:7:\"level_1\";b:1;s:7:\"level_0\";b:1;s:17:\"edit_others_pages\";b:1;s:20:\"edit_published_pages\";b:1;s:13:\"publish_pages\";b:1;s:12:\"delete_pages\";b:1;s:19:\"delete_others_pages\";b:1;s:22:\"delete_published_pages\";b:1;s:12:\"delete_posts\";b:1;s:19:\"delete_others_posts\";b:1;s:22:\"delete_published_posts\";b:1;s:20:\"delete_private_posts\";b:1;s:18:\"edit_private_posts\";b:1;s:18:\"read_private_posts\";b:1;s:20:\"delete_private_pages\";b:1;s:18:\"edit_private_pages\";b:1;s:18:\"read_private_pages\";b:1;}}s:6:\"author\";a:2:{s:4:\"name\";s:6:\"Author\";s:12:\"capabilities\";a:10:{s:12:\"upload_files\";b:1;s:10:\"edit_posts\";b:1;s:20:\"edit_published_posts\";b:1;s:13:\"publish_posts\";b:1;s:4:\"read\";b:1;s:7:\"level_2\";b:1;s:7:\"level_1\";b:1;s:7:\"level_0\";b:1;s:12:\"delete_posts\";b:1;s:22:\"delete_published_posts\";b:1;}}s:11:\"contributor\";a:2:{s:4:\"name\";s:11:\"Contributor\";s:12:\"capabilities\";a:5:{s:10:\"edit_posts\";b:1;s:4:\"read\";b:1;s:7:\"level_1\";b:1;s:7:\"level_0\";b:1;s:12:\"delete_posts\";b:1;}}s:10:\"subscriber\";a:2:{s:4:\"name\";s:10:\"Subscriber\";s:12:\"capabilities\";a:2:{s:4:\"read\";b:1;s:7:\"level_0\";b:1;}}}', 'yes'),
(101, 'fresh_site', '1', 'yes'),
(102, 'WPLANG', 'vi', 'yes'),
(103, 'widget_block', 'a:6:{i:2;a:1:{s:7:\"content\";s:19:\"<!-- wp:search /-->\";}i:3;a:1:{s:7:\"content\";s:159:\"<!-- wp:group --><div class=\"wp-block-group\"><!-- wp:heading --><h2>Bà i viết mới</h2><!-- /wp:heading --><!-- wp:latest-posts /--></div><!-- /wp:group -->\";}i:4;a:1:{s:7:\"content\";s:236:\"<!-- wp:group --><div class=\"wp-block-group\"><!-- wp:heading --><h2>Phản hồi gần đây</h2><!-- /wp:heading --><!-- wp:latest-comments {\"displayAvatar\":false,\"displayDate\":false,\"displayExcerpt\":false} /--></div><!-- /wp:group -->\";}i:5;a:1:{s:7:\"content\";s:148:\"<!-- wp:group --><div class=\"wp-block-group\"><!-- wp:heading --><h2>Lưu trữ</h2><!-- /wp:heading --><!-- wp:archives /--></div><!-- /wp:group -->\";}i:6;a:1:{s:7:\"content\";s:153:\"<!-- wp:group --><div class=\"wp-block-group\"><!-- wp:heading --><h2>Chuyên mục</h2><!-- /wp:heading --><!-- wp:categories /--></div><!-- /wp:group -->\";}s:12:\"_multiwidget\";i:1;}', 'yes'),
(104, 'sidebars_widgets', 'a:4:{s:19:\"wp_inactive_widgets\";a:0:{}s:9:\"sidebar-1\";a:3:{i:0;s:7:\"block-2\";i:1;s:7:\"block-3\";i:2;s:7:\"block-4\";}s:9:\"sidebar-2\";a:2:{i:0;s:7:\"block-5\";i:1;s:7:\"block-6\";}s:13:\"array_version\";i:3;}', 'yes'),
(105, 'cron', 'a:7:{i:1637083097;a:1:{s:34:\"wp_privacy_delete_old_export_files\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1637122697;a:4:{s:18:\"wp_https_detection\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1637165896;a:2:{s:30:\"wp_site_health_scheduled_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"weekly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:604800;}}s:32:\"recovery_mode_clean_expired_keys\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1637165907;a:1:{s:19:\"wp_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1637165908;a:1:{s:25:\"delete_expired_transients\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1637165910;a:1:{s:30:\"wp_scheduled_auto_draft_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}s:7:\"version\";i:2;}', 'yes'),
(106, 'widget_pages', 'a:1:{s:12:\"_multiwidget\";i:1;}', 'yes'),
(107, 'widget_calendar', 'a:1:{s:12:\"_multiwidget\";i:1;}', 'yes'),
(108, 'widget_archives', 'a:1:{s:12:\"_multiwidget\";i:1;}', 'yes'),
(109, 'widget_media_audio', 'a:1:{s:12:\"_multiwidget\";i:1;}', 'yes'),
(110, 'widget_media_image', 'a:1:{s:12:\"_multiwidget\";i:1;}', 'yes'),
(111, 'widget_media_gallery', 'a:1:{s:12:\"_multiwidget\";i:1;}', 'yes'),
(112, 'widget_media_video', 'a:1:{s:12:\"_multiwidget\";i:1;}', 'yes'),
(113, 'widget_meta', 'a:1:{s:12:\"_multiwidget\";i:1;}', 'yes'),
(114, 'widget_search', 'a:1:{s:12:\"_multiwidget\";i:1;}', 'yes'),
(115, 'widget_tag_cloud', 'a:1:{s:12:\"_multiwidget\";i:1;}', 'yes'),
(116, 'widget_nav_menu', 'a:1:{s:12:\"_multiwidget\";i:1;}', 'yes'),
(117, 'widget_custom_html', 'a:1:{s:12:\"_multiwidget\";i:1;}', 'yes'),
(119, 'recovery_keys', 'a:0:{}', 'yes'),
(120, 'theme_mods_twentytwentyone', 'a:1:{s:18:\"custom_css_post_id\";i:-1;}', 'yes'),
(122, 'https_detection_errors', 'a:1:{s:23:\"ssl_verification_failed\";a:1:{i:0;s:36:\"Xác thực SSL không thà nh công.\";}}', 'yes'),
(126, '_site_transient_timeout_theme_roots', '1637081301', 'no'),
(127, '_site_transient_theme_roots', 'a:3:{s:14:\"twentynineteen\";s:7:\"/themes\";s:12:\"twentytwenty\";s:7:\"/themes\";s:15:\"twentytwentyone\";s:7:\"/themes\";}', 'no'),
(129, '_site_transient_update_core', 'O:8:\"stdClass\":4:{s:7:\"updates\";a:1:{i:0;O:8:\"stdClass\":10:{s:8:\"response\";s:6:\"latest\";s:8:\"download\";s:62:\"https://downloads.wordpress.org/release/vi/wordpress-5.8.2.zip\";s:6:\"locale\";s:2:\"vi\";s:8:\"packages\";O:8:\"stdClass\":5:{s:4:\"full\";s:62:\"https://downloads.wordpress.org/release/vi/wordpress-5.8.2.zip\";s:10:\"no_content\";s:0:\"\";s:11:\"new_bundled\";s:0:\"\";s:7:\"partial\";s:0:\"\";s:8:\"rollback\";s:0:\"\";}s:7:\"current\";s:5:\"5.8.2\";s:7:\"version\";s:5:\"5.8.2\";s:11:\"php_version\";s:6:\"5.6.20\";s:13:\"mysql_version\";s:3:\"5.0\";s:11:\"new_bundled\";s:3:\"5.6\";s:15:\"partial_version\";s:0:\"\";}}s:12:\"last_checked\";i:1637079505;s:15:\"version_checked\";s:5:\"5.8.2\";s:12:\"translations\";a:0:{}}', 'no'),
(130, '_site_transient_update_themes', 'O:8:\"stdClass\":5:{s:12:\"last_checked\";i:1637079506;s:7:\"checked\";a:3:{s:14:\"twentynineteen\";s:3:\"2.1\";s:12:\"twentytwenty\";s:3:\"1.8\";s:15:\"twentytwentyone\";s:3:\"1.4\";}s:8:\"response\";a:0:{}s:9:\"no_update\";a:3:{s:14:\"twentynineteen\";a:6:{s:5:\"theme\";s:14:\"twentynineteen\";s:11:\"new_version\";s:3:\"2.1\";s:3:\"url\";s:44:\"https://wordpress.org/themes/twentynineteen/\";s:7:\"package\";s:60:\"https://downloads.wordpress.org/theme/twentynineteen.2.1.zip\";s:8:\"requires\";s:5:\"4.9.6\";s:12:\"requires_php\";s:5:\"5.2.4\";}s:12:\"twentytwenty\";a:6:{s:5:\"theme\";s:12:\"twentytwenty\";s:11:\"new_version\";s:3:\"1.8\";s:3:\"url\";s:42:\"https://wordpress.org/themes/twentytwenty/\";s:7:\"package\";s:58:\"https://downloads.wordpress.org/theme/twentytwenty.1.8.zip\";s:8:\"requires\";s:3:\"4.7\";s:12:\"requires_php\";s:5:\"5.2.4\";}s:15:\"twentytwentyone\";a:6:{s:5:\"theme\";s:15:\"twentytwentyone\";s:11:\"new_version\";s:3:\"1.4\";s:3:\"url\";s:45:\"https://wordpress.org/themes/twentytwentyone/\";s:7:\"package\";s:61:\"https://downloads.wordpress.org/theme/twentytwentyone.1.4.zip\";s:8:\"requires\";s:3:\"5.3\";s:12:\"requires_php\";s:3:\"5.6\";}}s:12:\"translations\";a:0:{}}', 'no'),
(131, 'website_address_en', '', 'no'),
(141, 'blogdescription_en', '', 'no'),
(152, 'blogname_en', 'Adimi - Công ty thiết kế website cao cấp, chuyên nghiệp', 'yes'),
(153, 'page_keyword', 'thietkewebsite,thietkewebvumi', 'yes');
-- --------------------------------------------------------
--
-- Table structure for table `tb_pages`
--
CREATE TABLE `tb_pages` (
`id` bigint(10) NOT NULL,
`key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'page',
`last_changed` int(10) DEFAULT '25',
`type_page` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
`ftitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`etitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
`fetitle` varchar(220) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`path_img` text COLLATE utf8mb4_unicode_ci,
`img` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`redirect` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`target` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '_blank',
`intro` text COLLATE utf8mb4_unicode_ci,
`eintro` text COLLATE utf8mb4_unicode_ci,
`body` text COLLATE utf8mb4_unicode_ci,
`ebody` text COLLATE utf8mb4_unicode_ci,
`tags` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`hit` bigint(10) DEFAULT '0',
`time` int(11) DEFAULT NULL,
`pos` tinyint(4) DEFAULT NULL,
`status` tinyint(4) DEFAULT NULL,
`noibat` tinyint(4) DEFAULT NULL,
`allow_comment` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_pages`
--
INSERT INTO `tb_pages` (`id`, `key`, `last_changed`, `type_page`, `title`, `ftitle`, `etitle`, `fetitle`, `path_img`, `img`, `redirect`, `target`, `intro`, `eintro`, `body`, `ebody`, `tags`, `hit`, `time`, `pos`, `status`, `noibat`, `allow_comment`) VALUES
(1, 'page', 25, NULL, 'WEBSITE VIỆT CUNG CẤP DỊCH VỤ THIẾT KẾ WEBSITE CHUYÊN NGHIỆP ÄEM ÄẾN GIẢI PHÃP KINH DOANH HIỆU QUẢ', NULL, 'WEBSITE VIỆT CUNG CẤP DỊCH VỤ THIẾT KẾ WEBSITE CHUYÊN NGHIỆP ÄEM ÄẾN GIẢI PHÃP KINH DOANH HIỆU QUẢ', NULL, NULL, NULL, NULL, '_blank', 'WEBSITE VIỆT Tá»° TIN MANG ÄẾN CHO QUà KHÃCH HÀNG DỊCH VỤ THIẾT KẾ WEBSITE CHUẨN SEO UY TÃN, CHẤT LƯỢNG Tá»T NHẤT', 'WEBSITE VIỆT Tá»° TIN MANG ÄẾN CHO QUà KHÃCH HÀNG DỊCH VỤ THIẾT KẾ WEBSITE CHUẨN SEO UY TÃN, CHẤT LƯỢNG Tá»T NHẤT', '<div class="section-content relative">\n \n<div class="row" id="row-434544292">\n\n <div id="col-932823101" class="col small-12 large-12">\n <div class="col-inner">\n \n \n<p dir="ltr">Không chỉ thiết kế 1 website Ä‘Æ¡n giản là xong, Ä‘iá»u quan \ntrá»ng là là m sao để website đó thu hút được khách&nbsp;hà ng. Giúp khách hà ng \nÄ‘Æ°a ra quyết định mua hà ng hay sá» dụng dịch vụ của bạn hay không. Vì \nváºy, website má»›i tháºt sá»± trở thà nh công cụ đắc lá»±c há»— trợ cho công việc \nkinh doanh của doanh nghiệp bạn. Äây là sá»± khác biệt mà &nbsp;<a href="https://websiteviet.vn/" data-wpel-link="internal"><strong>Website Việt</strong></a>&nbsp;mang lại.</p>\n<p dir="ltr">Bạn Ä‘ang <strong>cần thiết kế website đẹp</strong>? Bạn Ä‘ang quan tâm là vá» dịch vụ <a href="https://websiteviet.vn/thiet-ke-website/" data-wpel-link="internal"><strong>thiết kế website giá rẻ</strong></a>\n của chúng tôi? Hay bạn Ä‘ang cân nhắc liệu bạn có tháºt sá»± cần má»™t \nwebsite để phục vụ cho công việc kinh doanh của bạn? DÆ°á»›i đây là những \nthông tin mà bạn có thể tham khảo:</p>\n </div>\n </div>\n\n \n</div>\n </div>', '', 'thietkeweb,thietkeweb2', 0, 1641621338, 1, 0, 0, NULL),
(2, 'page', 25, NULL, 'WEBSITE VIỆT CUNG CẤP DỊCH VỤ THIẾT KẾ WEBSITE CHUYÊN NGHIỆP ÄEM ÄẾN GIẢI PHÃP KINH DOANH HIỆU QUẢ', NULL, 'WEBSITE VIỆT CUNG CẤP DỊCH VỤ THIẾT KẾ WEBSITE CHUYÊN NGHIỆP ÄEM ÄẾN GIẢI PHÃP KINH DOANH HIỆU QUẢ', NULL, 'upload/pages/2022/01/website-viet-cung-ca_1641622862_61d92d4e5c10a.png', 'website-viet-cung-ca_1641622862_61d92d4e5c10a.png', NULL, '_blank', 'WEBSITE VIỆT Tá»° TIN MANG ÄẾN CHO QUà KHÃCH HÀNG DỊCH VỤ THIẾT KẾ WEBSITE CHUẨN SEO UY TÃN, CHẤT LƯỢNG Tá»T NHẤT', 'WEBSITE VIỆT Tá»° TIN MANG ÄẾN CHO QUà KHÃCH HÀNG DỊCH VỤ THIẾT KẾ WEBSITE CHUẨN SEO UY TÃN, CHẤT LƯỢNG Tá»T NHẤT', '<div class="section-content relative">\n \n<div class="row" id="row-434544292">\n\n <div id="col-932823101" class="col small-12 large-12">\n <div class="col-inner">\n \n \n<p dir="ltr">Không chỉ thiết kế 1 website Ä‘Æ¡n giản là xong, Ä‘iá»u quan \ntrá»ng là là m sao để website đó thu hút được khách&nbsp;hà ng. Giúp khách hà ng \nÄ‘Æ°a ra quyết định mua hà ng hay sá» dụng dịch vụ của bạn hay không. Vì \nváºy, website má»›i tháºt sá»± trở thà nh công cụ đắc lá»±c há»— trợ cho công việc \nkinh doanh của doanh nghiệp bạn. Äây là sá»± khác biệt mà &nbsp;<a href="https://websiteviet.vn/" data-wpel-link="internal"><strong>Website Việt</strong></a>&nbsp;mang lại.</p>\n<p dir="ltr">Bạn Ä‘ang <strong>cần thiết kế website đẹp</strong>? Bạn Ä‘ang quan tâm là vá» dịch vụ <a href="https://websiteviet.vn/thiet-ke-website/" data-wpel-link="internal"><strong>thiết kế website giá rẻ</strong></a>\n của chúng tôi? Hay bạn Ä‘ang cân nhắc liệu bạn có tháºt sá»± cần má»™t \nwebsite để phục vụ cho công việc kinh doanh của bạn? DÆ°á»›i đây là những \nthông tin mà bạn có thể tham khảo:</p>\n </div>\n </div>\n\n \n</div>\n </div>', '<p><img src="upload/editor/2022/01/1641634634_61d95b4a97eeb.png"><br></p><p>Không chỉ thiết kế 1 website Ä‘Æ¡n giản là xong, Ä‘iá»u quan \ntrá»ng là là m sao để website đó thu hút được khách&nbsp;hà ng. Giúp khách hà ng \nÄ‘Æ°a ra quyết định mua hà ng hay sá» dụng dịch vụ của bạn hay không. Vì \nváºy, website má»›i tháºt sá»± trở thà nh công cụ đắc lá»±c há»— trợ cho công việc \nkinh doanh của doanh nghiệp bạn. Äây là sá»± khác biệt mà &nbsp;<a href="https://websiteviet.vn/" data-wpel-link="internal"><strong>Website Việt</strong></a>&nbsp;mang lại.</p><p>Bạn Ä‘ang <strong>cần thiết kế website đẹp</strong>? Bạn Ä‘ang quan tâm là vá» dịch vụ <a href="https://websiteviet.vn/thiet-ke-website/" data-wpel-link="internal"><strong>thiết kế website giá rẻ</strong></a>\n của chúng tôi? Hay bạn Ä‘ang cân nhắc liệu bạn có tháºt sá»± cần má»™t \nwebsite để phục vụ cho công việc kinh doanh của bạn? DÆ°á»›i đây là những \nthông tin mà bạn có thể tham khảo:</p>', 'thietkeweb,thietkeweb2', 0, 1641621359, 1, 0, 0, NULL),
(4, 'page', 25, NULL, '35435', NULL, '345345', NULL, 'upload/pages/2022/01/35435_1641707114_61da766a082cb.png', '35435_1641707114_61da766a082cb.png', NULL, '_blank', '423r 23r 23', 'r32 r23 r23r 23r', '<p>23r 23r 23r 23r<br></p>', '<p>23r 23r 23r 32r <br></p>', '234', 0, 1641707113, 2, 0, 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `tb_param`
--
CREATE TABLE `tb_param` (
`param_id` int(11) NOT NULL,
`company_id` int(11) DEFAULT NULL,
`param_key` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`param_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`param_ename` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`param_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`param_pos` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_param`
--
INSERT INTO `tb_param` (`param_id`, `company_id`, `param_key`, `param_name`, `param_ename`, `param_type`, `param_pos`) VALUES
(1, 2, 'chuc-vu', 'Chức vụ', 'Job/Function', 'staff', 100),
(2, 2, 'ngay-nam-hoc-moi', 'Ngà y bắt đầu năm há»c má»›i', 'New academic year', 'company', 200),
(3, 2, 'loai-hop-dong', 'Loại hợp đồng', 'Type of contract', 'staff', 101),
(4, 2, 'ngay-hoc-ky-2', 'Ngà y bắt đầu há»c kỳ 2', 'Ngà y bắt đầu há»c kỳ 2', 'company', 201),
(5, 2, 'dinh-muc-gio-day', 'Äịnh mức giá» dạy', 'Lesson month', 'staff', 102),
(6, 2, 'sobuoihoc', 'Số buổi há»c', 'Number of lesson', 'company', 300),
(7, 2, 'songayhoctrongtuan', 'Số ngà y há»c trong tuần', 'Number of days in a week', 'company', 302);
-- --------------------------------------------------------
--
-- Table structure for table `tb_param_data`
--
CREATE TABLE `tb_param_data` (
`param_data_id` int(11) NOT NULL,
`staff_id` int(11) DEFAULT NULL,
`company_id` int(11) DEFAULT NULL,
`param_date` date DEFAULT NULL,
`param_key` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`param_data` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`param_note` text COLLATE utf8mb4_unicode_ci,
`update_time` datetime DEFAULT NULL,
`update_by` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_param_data`
--
INSERT INTO `tb_param_data` (`param_data_id`, `staff_id`, `company_id`, `param_date`, `param_key`, `param_data`, `param_note`, `update_time`, `update_by`) VALUES
(4, 2, 2, '2018-10-01', 'loai-hop-dong', 'co-huu', 'Äổi ngà y áp dụng', '2018-10-15 09:56:37', 'giacbn'),
(5, 2, 2, '2018-10-02', 'loai-hop-dong', 'thinh-giang', 'Äổi ngà y áp dụng', '2018-10-15 11:00:47', 'giacbn'),
(8, 18, 2, '2018-10-01', 'chuc-vu', '11', '', '2018-10-15 11:28:28', 'giacbn'),
(9, 2, 2, '2018-10-01', 'chuc-vu', '12', 'Äổi ngà y áp dụng', '2018-10-18 13:55:38', 'giacbn'),
(10, 2, 2, '2018-10-01', 'loai-hop-dong', 'co-huu', 'Äổi ngà y áp dụng', '2018-10-18 13:57:31', 'giacbn'),
(11, 19, 2, '2018-11-29', 'chuc-vu', '13', 'Create staff account', '2018-11-29 16:46:52', 'giacbn'),
(12, 20, 2, '2018-12-03', 'chuc-vu', '13', 'Create staff account', '2018-12-03 11:00:53', 'giacbn'),
(14, 2, 2, '2018-12-01', 'chuc-vu', '11', 'Äổi ngà y áp dụng', '2018-12-14 10:01:46', 'giacbn'),
(15, 317, 2, '2018-12-01', 'loai-hop-dong', 'co-huu', '', '2018-12-14 10:05:59', 'giacbn'),
(16, 317, 2, '2018-12-01', 'chuc-vu', '13', '', '2018-12-14 10:06:16', 'giacbn'),
(17, 318, 2, '2018-12-01', 'chuc-vu', '12', '', '2018-12-14 10:06:49', 'giacbn'),
(19, 318, 2, '2018-12-01', 'dinh-muc-gio-day', '12', '', '2018-12-14 10:24:45', 'giacbn'),
(20, 0, 2, '2018-07-01', 'ngay-nam-hoc-moi', '2018-07-01', 'Ngà y bắt đầu năm há»c má»›i', '2018-12-14 11:14:02', 'giacbn'),
(26, 0, 2, '2018-07-01', 'ngay-hoc-ky-2', '2019-01-01', 'Ngà y bắt đầu há»c kỳ 2', '2018-12-14 11:29:09', 'giacbn'),
(29, 0, 2, '2018-05-01', 'sobuoihoc', '2', 'Số buổi há»c', '2019-05-31 09:16:37', 'giacbn'),
(30, 0, 2, '2018-05-01', 'songayhoctrongtuan', '5', 'Số ngà y há»c trong tuần', '2019-05-31 09:35:53', 'giacbn'),
(32, 395, 14, '2019-06-03', 'chuc-vu', '15', 'Create staff account', '2019-06-03 15:06:44', 'giacbn'),
(34, 396, 2, '2020-01-10', 'chuc-vu', '13', 'Create staff account', '2020-01-10 14:47:37', 'giacbn'),
(35, 397, 2, '2020-01-10', 'chuc-vu', '13', 'Create staff account', '2020-01-10 16:00:49', 'giacbn'),
(36, 398, 2, '2020-01-10', 'chuc-vu', '13', 'Create staff account', '2020-01-10 16:18:10', 'giacbn');
-- --------------------------------------------------------
--
-- Table structure for table `tb_qrcode`
--
CREATE TABLE `tb_qrcode` (
`qrcode_id` int(11) NOT NULL,
`user_id` int(11) DEFAULT NULL,
`qrcode_key` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`qrcode_code` tinytext COLLATE utf8mb4_unicode_ci,
`time_post` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_qrcode`
--
INSERT INTO `tb_qrcode` (`qrcode_id`, `user_id`, `qrcode_key`, `qrcode_code`, `time_post`) VALUES
(2, 414, 'mh0uzGBK', '1cb8e4', 1575258615),
(3, 426, 'p1CRdc7T', '142613', 1575259110),
(4, 429, 'cP1chb2t', 'f5b226', 1575259203),
(5, 817, 'Nss9zmEN', '8376b8', 1575447409),
(6, 1230, 't2lYLX5i', '2bfc691e', 1575528377),
(7, 1027, 'RCeq4YW6', '2b39d906', 1575605549),
(8, 821, 'Ri4PgI5s', '2323e2', 1575606638),
(9, 1218, 'DKIG0Dks', 'b2de4a54', 1575617889),
(10, 1231, 'HNOP8Gzh', '9b445fdd', 1575622780),
(11, 1232, 'p3x4LFx3', 'cc6cb5cc', 1575626059),
(12, 1233, 'wHSB1hFd', '24929b7d', 1575860926),
(13, 1238, 'W96vIrIs', '28d25fd1', 1575865644),
(14, 1208, 'iKuPdhVS', '5a1f4d1c', 1575875094),
(15, 824, 'ANbH6inp', '58cf47', 1594430779),
(16, 1234, '8A2G67XA', '6cc83baa', 1607398632);
-- --------------------------------------------------------
--
-- Table structure for table `tb_service`
--
CREATE TABLE `tb_service` (
`service_id` int(11) NOT NULL,
`customer_id` int(11) DEFAULT NULL,
`service_cat` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`service_title` text COLLATE utf8mb4_unicode_ci,
`time_post` datetime DEFAULT NULL,
`user_post` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_service`
--
INSERT INTO `tb_service` (`service_id`, `customer_id`, `service_cat`, `service_title`, `time_post`, `user_post`) VALUES
(1, 1, 'Hosting', 'Hosting gói 3 – Windows (Dung lượng 6 GB, Băng thông không giá»›i hạn, địa chỉ email không giá»›i hạn, tà i khoản FTP không giá»›i hạn, 06 data SQL) theo tên miá»n lad-corp.com', '2021-11-09 08:56:41', 'giacbn'),
(2, 2, 'TKW', 'Thiết kế website beauty.vn', '2021-11-10 01:54:41', 'giacbn');
-- --------------------------------------------------------
--
-- Table structure for table `tb_service_event`
--
CREATE TABLE `tb_service_event` (
`service_event_id` int(11) NOT NULL,
`service_id` int(11) DEFAULT NULL,
`service_event_donvitinh` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`service_event_soluong` int(11) DEFAULT NULL,
`service_event_dongia` int(11) DEFAULT NULL,
`service_event_tax` int(11) DEFAULT NULL,
`service_event_discount` int(11) DEFAULT NULL,
`service_event_begin` date DEFAULT NULL,
`service_event_end` date DEFAULT NULL,
`time_post` datetime DEFAULT NULL,
`user_post` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_service_event`
--
INSERT INTO `tb_service_event` (`service_event_id`, `service_id`, `service_event_donvitinh`, `service_event_soluong`, `service_event_dongia`, `service_event_tax`, `service_event_discount`, `service_event_begin`, `service_event_end`, `time_post`, `user_post`) VALUES
(1, 1, 'thang', 24, 152000, 10, 10, '2021-11-30', '2023-11-30', '2021-11-10 01:33:17', 'giacbn'),
(2, 1, 'thang', 24, 162000, 10, 10, '2023-12-01', '2025-12-01', '2021-11-10 01:46:24', 'giacbn'),
(4, 2, 'khac', 1, 2000000, 10, 0, '2021-11-01', '1970-01-01', '2021-11-10 01:57:48', 'giacbn');
-- --------------------------------------------------------
--
-- Table structure for table `tb_staff`
--
CREATE TABLE `tb_staff` (
`staff_id` int(11) NOT NULL,
`company_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`staff_fullname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_lastname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_email365` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_gender` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_birthday` date DEFAULT NULL,
`staff_address` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_dantoc` tinyint(4) DEFAULT NULL,
`staff_mobile` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_cmnd` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_trinhdohocvan` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_marry` tinyint(4) DEFAULT NULL,
`staff_joindate` date DEFAULT NULL,
`staff_function` int(11) DEFAULT NULL,
`staff_group` int(11) DEFAULT NULL,
`staff_order` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_status` tinyint(4) DEFAULT NULL,
`staff_subject` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_hopdong` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_staff`
--
INSERT INTO `tb_staff` (`staff_id`, `company_id`, `user_id`, `staff_fullname`, `staff_lastname`, `staff_email`, `staff_email365`, `staff_gender`, `staff_birthday`, `staff_address`, `staff_dantoc`, `staff_mobile`, `staff_cmnd`, `staff_trinhdohocvan`, `staff_marry`, `staff_joindate`, `staff_function`, `staff_group`, `staff_order`, `staff_status`, `staff_subject`, `staff_hopdong`) VALUES
(2, 13, 2, 'Bùi Ngá»c Giác', NULL, 'giacbn@ischool.vn', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11, NULL, NULL, NULL, NULL, 'co-huu'),
(317, 2, 334, 'Nguyễn Văn An', 'An', '', 'annv.rachgia@ischool.edu.vn', '1', '1981-04-03', '', 1, '0979813093', '', 'thpt', 1, '2019-03-06', 13, 1, 'an vazn nguyezn4 ', 0, '13@', 'co-huu'),
(318, 2, 335, 'Võ Hoà ng Anh', 'Anh', '', 'anhvh.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '0995607498', '', 'thpt', 1, '2018-12-04', 12, 1, 'anh hoang1 vo4 ', 0, '15@19@', NULL),
(319, 2, 336, 'Hoà ng Thị Kim Anh', 'Anh', '', 'anhhtk.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '099999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'anh kim thi5 hoang1 ', 0, '6@', NULL),
(320, 2, 337, 'Nguyễn Thị Kim Anh', 'Anh', '', 'anhntk.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '099999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'anh kim thi5 nguyezn4 ', 0, '15@', NULL),
(321, 2, 338, 'Nguyễn Thị Mộng Cầm', 'Cầm', '', 'camntm.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '099999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'cazzm1 mozng5 thi5 nguyezn4 ', 0, '4@12@29@', NULL),
(322, 2, 339, 'Võ Ngá»c CÆ°á»ng', 'CÆ°á»ng', '', 'cuongvn.rachgia@ischool.edu.vn', '1', '2018-12-04', '', 1, '099999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'cuzozzng2 ngoc5 vo4 ', 0, '4@5@3@6@7@8@9@10@11@13@14@15@', NULL),
(323, 2, 340, 'Huỳnh Ngá»c Diệu', 'Diệu', '', 'dieuhn.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '099999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'diezu5 ngoc5 huynh1 ', 0, '9@20@33@', NULL),
(324, 2, 341, 'Lê Thị Thùy Dung', 'Dung', '', 'dungltt.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '0999999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'dung thuy1 thi5 lez ', 0, '7@24@29@', NULL),
(325, 2, 342, 'Bùi Nguyễn Thùy Dương', 'Dương', '', 'duongbnt.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'duzozzng thuy1 nguyezn4 bui1 ', 0, NULL, NULL),
(326, 2, 343, 'Nguyá»…n Lê Anh Äức', 'Äức', '', 'ducnla.rachgia@ischool.edu.vn', '1', '2018-12-04', '', 1, '099999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'dzuzc2 anh lez nguyezn4 ', 0, '13@26@40@', NULL),
(327, 2, 344, 'Nguyá»…n ChÃn Em', 'Em', '', 'emnc.rachgia@ischool.edu.vn', '1', '2018-12-04', '', 1, '099999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'em chin2 nguyezn4 ', 0, '5@16@30@', NULL),
(328, 2, 345, 'Trần Thị Kiên Giang', 'Giang', '', 'giangttk.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '099999999', '', 'dai-hoc', 1, '2018-12-04', NULL, 1, 'giang kiezn thi5 trazzn1 ', 0, '3@17@31@', NULL),
(329, 2, 346, 'Tạ Hữu Hải', 'Hải', '', 'haith.rachgia@ischool.edu.vn', '1', '2018-12-04', '', 1, '099999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'hai3 huzu4 ta5 ', 0, '7@18@19@', NULL),
(330, 2, 347, 'Trương Anh Hằng', 'Hằng', '', 'hangta.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'hazng1 anh truzozzng ', 0, NULL, NULL),
(331, 2, 348, 'Phạm Thị Diệu Hiá»n', 'Hiá»n', '', 'hienptd.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'hiezn1 diezu5 thi5 pham5 ', 0, NULL, NULL),
(332, 2, 349, 'Phan Thị Thanh Hiá»n', 'Hiá»n', '', 'hienptt.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '09999999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'hiezn1 thanh thi5 phan ', 0, '19@20@', NULL),
(333, 2, 350, 'Hà Thị Thu Hiá»n', 'Hiá»n', '', 'hienhtt.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'hiezn1 thu thi5 ha1 ', 0, NULL, NULL),
(334, 2, 351, 'Bùi Thị Hoa', 'Hoa', '', 'hoabt.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'hoa thi5 bui1 ', 0, NULL, NULL),
(335, 2, 352, 'Phan Thị Hóa', 'Hóa', '', 'hoapt.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '0999999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'hoa2 thi5 phan ', 0, '5@16@30@', NULL),
(336, 2, 353, 'Danh Thị Huệ', 'Huệ', '', 'huedt.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'huez5 thi5 danh ', 0, NULL, NULL),
(337, 2, 354, 'Phạm Thị Huyá»n', 'Huyá»n', '', 'huyenpt.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'huyezn1 thi5 pham5 ', 0, NULL, NULL),
(338, 2, 355, 'Thị Thu Huyá»n', 'Huyá»n', '', 'huyentt.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'huyezn1 thu thi5 ', 0, NULL, NULL),
(339, 2, 356, 'Dương Nhựt Huỳnh', 'Huỳnh', '', 'huynhdn.rachgia@ischool.edu.vn', '1', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'huynh1 nhuzt5 duzozzng ', 0, NULL, NULL),
(340, 2, 357, 'Lê Nguyên Hương', 'Hương', '', 'huongln.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'huzozzng nguyezn lez ', 0, NULL, NULL),
(341, 2, 358, 'Trần Thị Hương', 'Hương', '', 'huongtt.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'huzozzng thi5 trazzn1 ', 0, NULL, NULL),
(342, 2, 359, 'Nguyễn Thanh Khiết', 'Khiết', '', 'khietnt.rachgia@ischool.edu.vn', '1', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'khiezt2 thanh nguyezn4 ', 0, NULL, NULL),
(343, 2, 360, 'Tạ Minh Khương', 'Khương', '', 'khuongtm.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'khuzozzng minh ta5 ', 0, NULL, NULL),
(344, 2, 361, 'Nguyễn Thị Là i', 'Là i', '', 'laint.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '0999999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'lai1 thi5 nguyezn4 ', 0, '17@18@', NULL),
(345, 2, 362, 'Lê Thanh Lan', 'Lan', '', 'lanlt.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '0999999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'lan thanh lez ', 0, '5@', NULL),
(346, 2, 363, 'Phan Thị Ngá»c Lẳm', 'Lẳm', '', 'lamptn.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'lazm3 ngoc5 thi5 phan ', 0, NULL, NULL),
(347, 2, 364, 'Trần Thị Diệu Linh', 'Linh', '', 'linhttd.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'linh diezu5 thi5 trazzn1 ', 0, NULL, NULL),
(348, 2, 365, 'Lê Dũ Linh', 'Linh', '', 'linhld.rachgia@ischool.edu.vn', '1', '2018-12-04', '', 1, '09999999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'linh du4 lez ', 0, '20@', NULL),
(349, 2, 366, 'Huỳnh Thúy Loan', 'Loan', '', 'loanht.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'loan thuy2 huynh1 ', 0, NULL, NULL),
(350, 2, 367, 'Huỳnh Minh Luân', 'Luân', '', 'luanhm.rachgia@ischool.edu.vn', '1', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'luazzn minh huynh1 ', 0, NULL, NULL),
(351, 2, 368, 'Thị Ly', 'Ly', '', 'lyt.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'ly thi5 ', 0, NULL, NULL),
(352, 2, 369, 'Nguyễn Trúc Ly', 'Ly', '', 'lynt1.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '09999999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'ly truc2 nguyezn4 ', 0, '14@', NULL),
(353, 2, 370, 'Jade Malle', 'Malle', '', 'jadem.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'malle jade ', 0, NULL, NULL),
(354, 2, 371, 'Mathew Morgan', 'Morgan', '', 'mathewm.rachgia@ischool.edu.vn', '1', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'morgan mathew ', 0, NULL, NULL),
(355, 2, 372, 'Tô Diễm My', 'My', '', 'mytd1.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'my diezm4 toz ', 0, NULL, NULL),
(356, 2, 373, 'Nguyễn Thị Kim Ngân', 'Ngân', '', 'nganntk.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'ngazzn kim thi5 nguyezn4 ', 0, NULL, NULL),
(357, 2, 374, 'TrÆ°Æ¡ng Thị Kim Ngá»c', 'Ngá»c', '', 'ngocttk.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '0999999999', '', 'thpt', 2, '2018-12-04', NULL, 1, 'ngoc5 kim thi5 truzozzng ', 0, '5@20@30@', NULL),
(358, 2, 375, 'Phan Văn Nhiên', 'Nhiên', '', 'nhienpv.rachgia@ischool.edu.vn', '1', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'nhiezn vazn phan ', 0, NULL, NULL),
(359, 2, 376, 'Nguyá»…n Thị Ngá»c Nhung', 'Nhung', '', 'nhungntn.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'nhung ngoc5 thi5 nguyezn4 ', 0, NULL, NULL),
(360, 2, 377, 'Phạm Nhựt', 'Nhựt', '', 'nhutp.rachgia@ischool.edu.vn', '1', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'nhuzt5 pham5 ', 0, NULL, NULL),
(361, 2, 378, 'Trương Như Phượng', 'Phượng', '', 'phuongtn1.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'phuzozzng5 nhuz truzozzng ', 0, NULL, NULL),
(362, 2, 379, 'Thị Phượng', 'Phượng', '', 'phuongt.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'phuzozzng5 thi5 ', 0, NULL, NULL),
(363, 2, 380, 'Nguyễn Thị Thúy Phượng', 'Phượng', '', 'phuongntt.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'phuzozzng5 thuy2 thi5 nguyezn4 ', 0, NULL, NULL),
(364, 2, 381, 'Danh PhÆ°Æ¡ng_83', 'PhÆ°Æ¡ng_83', '', 'phuongd.rachgia@ischool.edu.vn', '1', '2018-12-04', '', 1, '09999999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'phuzozzng_83 danh ', 0, '8@9@', NULL),
(365, 2, 382, 'Äá»— VÆ°Æ¡ng Quốc', 'Quốc', '', 'quocdv.rachgia@ischool.edu.vn', '1', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'quozc1 vuzozzng dzoz4 ', 0, NULL, NULL),
(366, 2, 383, 'Lâm Ngá»c Quyá»n', 'Quyá»n', '', 'quyenln.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'quyezn1 ngoc5 lazzm ', 0, NULL, NULL),
(367, 2, 384, 'Tôn Kim Quyên', 'Quyên', '', 'quyentk.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'quyezn kim tozn ', 0, NULL, NULL),
(368, 2, 385, 'Trần Thị Ngá»c SÆ°Æ¡ng', 'SÆ°Æ¡ng', '', 'suongttn.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'suzozzng ngoc5 thi5 trazzn1 ', 0, NULL, NULL),
(369, 2, 386, 'Phạm Minh Tâm', 'Tâm', '', 'tampt.rachgia@ischool.edu.vn', '1', '2018-12-04', '', 1, '09999999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'tazzm minh pham5 ', 0, '16@', NULL),
(370, 2, 387, 'Huỳnh Thị Thanh', 'Thanh', '', 'thanhht.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'thanh thi5 huynh1 ', 0, NULL, NULL),
(371, 2, 388, 'Äoà n PhÆ°Æ¡ng Thảo', 'Thảo', '', 'thaodp.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'thao3 phuzozzng dzoan1 ', 0, NULL, NULL),
(372, 2, 389, 'Vũ Thị Thắm', 'Thắm', '', 'thamvt.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'thazm2 thi5 vu4 ', 0, NULL, NULL),
(373, 2, 390, 'Nguyễn Thị Thoa', 'Thoa', '', 'thoant.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'thoa thi5 nguyezn4 ', 0, NULL, NULL),
(374, 2, 391, 'Lê Thị Mỹ Thơ', 'Thơ', '', 'tholtm.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'thozz my4 thi5 lez ', 0, NULL, NULL),
(375, 2, 392, 'Nguyễn Thị Cẩm Thúy', 'Thúy', '', 'thuyntc.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'thuy2 cazzm3 thi5 nguyezn4 ', 0, NULL, NULL),
(376, 2, 393, 'Trần Hồng Thủy', 'Thủy', '', 'thuyth.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'thuy3 hozng2 trazzn1 ', 0, NULL, NULL),
(377, 2, 394, 'Lê Anh Thư', 'Thư', '', 'thula.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'thuz anh lez ', 0, NULL, NULL),
(378, 2, 395, 'Trương Hoà ng Quốc Tiến', 'Tiến', '', 'tienthq.rachgia@ischool.edu.vn', '1', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'tiezn2 quozc1 hoang1 truzozzng ', 0, NULL, NULL),
(379, 2, 396, 'Hồ Thị Trà Tiên', 'Tiên', '', 'tienhtt.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'tiezn tra1 thi5 hoz2 ', 0, NULL, NULL),
(380, 2, 397, 'Huỳnh Thị Má»™ng Tiá»n', 'Tiá»n', '', 'tienhtm.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'tiezn1 mozng5 thi5 huynh1 ', 0, NULL, NULL),
(381, 2, 398, 'LÆ° Thị Äà i Trang', 'Trang', '', 'trangltd.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '099999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'trang dzai1 thi5 luz ', 0, '12@', NULL),
(382, 2, 399, 'Kim Trần Bảo Trân', 'Trân', '', 'tranktb.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'trazzn bao3 trazzn1 kim ', 0, NULL, NULL),
(383, 2, 400, 'Lý Kiá»u Trinh', 'Trinh', '', 'trinhlt.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'trinh kiezu1 ly2 ', 0, NULL, NULL),
(384, 2, 401, 'Phan Thị Ngá»c Tú', 'Tú', '', 'tuptn.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'tu2 ngoc5 thi5 phan ', 0, NULL, NULL),
(385, 2, 402, 'Hồ Thanh Tùng', 'Tùng', '', 'tunght.rachgia@ischool.edu.vn', '1', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'tung1 thanh hoz2 ', 0, NULL, NULL),
(386, 2, 403, 'Äá»— Thị Kim Tuyến', 'Tuyến', '', 'tuyendtk1.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'tuyezn2 kim thi5 dzoz4 ', 0, NULL, NULL),
(387, 2, 404, 'Nguyá»…n Thiện TÆ°á»ng', 'TÆ°á»ng', '', 'tuongnt.rachgia@ischool.edu.vn', '1', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'tuzozzng2 thiezn5 nguyezn4 ', 0, NULL, NULL),
(388, 2, 405, 'Nguyễn Thị Hải Vân', 'Vân', '', 'vannth.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'vazzn hai3 thi5 nguyezn4 ', 0, NULL, NULL),
(389, 2, 406, 'Nguyễn Thị Lan Vi', 'Vi', '', 'vintl.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'vi lan thi5 nguyezn4 ', 0, NULL, NULL),
(390, 2, 407, 'Nguyễn Thị Yến Vi', 'Vi', '', 'vinty.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'vi yezn2 thi5 nguyezn4 ', 0, NULL, NULL),
(391, 2, 408, 'Äinh Cẩm Vy', 'Vy', '', 'vydc.rachgia@ischool.edu.vn', '2', '2018-12-04', '', 1, '0999999999', '', 'thpt', 1, '2018-12-04', NULL, 1, 'vy cazzm3 dzinh ', 0, '15@', NULL),
(392, 2, 409, 'Nguyễn Thị Thảo Vy', 'Vy', '', 'vyntt.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'vy thao3 thi5 nguyezn4 ', 0, NULL, NULL),
(393, 2, 410, 'Hà nh Triá»u Vy', 'Vy', '', 'vyht.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'vy triezu1 hanh1 ', 0, NULL, NULL),
(394, 2, 411, 'Trần Ngá»c Hải Yến', 'Yến', '', 'yentnh.rachgia@ischool.edu.vn', '2', '2018-12-04', NULL, NULL, NULL, NULL, NULL, NULL, '2018-12-04', NULL, NULL, 'yezn2 hai3 ngoc5 trazzn1 ', 0, NULL, NULL),
(395, 14, 412, 'Nguyen Thi Cam', 'Cam', 'camnt@nhg.vn', 'camnt@nhg.vn', '1', '2019-12-12', '', 1, '0999999999999', '', 'thpt', 1, '2019-12-12', 15, 0, 'cam thi nguyen ', 0, NULL, NULL),
(396, 2, 1242, 'Phạm Thị Tú Anh', 'Anh', 'anhttt.rachga@gmail.com', 'anhpttt.rachgia@ischool.edu.vn', '2', '1970-01-01', '', 1, '0995607498', '', 'dai-hoc', 1, '2019-12-12', 13, 2, 'anh tu2 thi5 pham5 ', 0, '20@', NULL),
(397, 2, 1243, 'Nguyễn Văn Nguyên', 'Nguyên', 'nguyennv.rachgia@ischool.edu.vn', 'nguyennv.rachgia@ischool.edu.vn', '1', '1981-12-12', '', 1, '099999999', '', 'dai-hoc', 1, '2019-12-12', 13, 2, 'nguyezn vazn nguyezn4 ', 0, '6@19@', NULL),
(398, 2, 1244, 'Lê Hoà ng Sang', 'Sang', 'sanglh.rachgia@ischool.edu.vn', 'sanglh.rachgia@ischool.edu.vn', '1', '1979-12-12', '', 1, '099999999', '', 'thpt', 1, '2019-12-12', 13, 2, 'sang hoang1 lez ', 0, '7@10@', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `tb_staffgroup`
--
CREATE TABLE `tb_staffgroup` (
`staffgroup_id` int(11) NOT NULL,
`company_id` int(11) DEFAULT NULL,
`staffgroup_cat` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staffgroup_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staffgroup_ename` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staffgroup_pos` int(11) DEFAULT NULL,
`staff_id_leader` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_staffgroup`
--
INSERT INTO `tb_staffgroup` (`staffgroup_id`, `company_id`, `staffgroup_cat`, `staffgroup_name`, `staffgroup_ename`, `staffgroup_pos`, `staff_id_leader`) VALUES
(1, 2, '2', 'Ban Giám Hiệu', 'Pincipal', 1, 15),
(2, 2, '1', 'Nhóm Toán - Tin', 'Math - IT Group', 4, 16),
(3, 2, '1', 'Tổ Văn - Sá» - Äịa', 'Group 2', 3, 12);
-- --------------------------------------------------------
--
-- Table structure for table `tb_staff_event`
--
CREATE TABLE `tb_staff_event` (
`staff_event_id` int(11) NOT NULL,
`company_id` int(11) DEFAULT NULL,
`staff_id` int(11) DEFAULT NULL,
`user_post` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_event_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_event_date` date DEFAULT NULL,
`staff_event_note` text COLLATE utf8mb4_unicode_ci,
`time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_staff_event`
--
INSERT INTO `tb_staff_event` (`staff_event_id`, `company_id`, `staff_id`, `user_post`, `staff_event_type`, `staff_event_date`, `staff_event_note`, `time`) VALUES
(10, 2, 319, 'giacbn', 'quit_job', '2018-01-12', 'Ly do ca nhan', 1543974883),
(15, 2, 317, 'giacbn', 'quit_job', '2018-12-04', 'Ban viec nha', 1543976791),
(17, 2, 318, 'giacbn', 'quit_job', '2018-04-10', 'Ban viec gia dinh', 1543996786),
(18, 2, 318, 'giacbn', 'back_job', '2018-04-11', 'Xong viec gia dinh', 1543996894),
(19, 2, 317, 'giacbn', 'back_job', '2018-12-12', 'trở lại ct', 1548737377),
(20, 2, 319, 'giacbn', 'back_job', '2019-01-01', 'trở lại', 1548742723);
-- --------------------------------------------------------
--
-- Table structure for table `tb_staff_function`
--
CREATE TABLE `tb_staff_function` (
`staff_function_id` int(11) NOT NULL,
`company_id` int(11) DEFAULT NULL,
`user_type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_function_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_function_ename` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_function_parentid` int(11) DEFAULT NULL,
`staff_function_pos` float DEFAULT NULL,
`staff_function_status` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_staff_function`
--
INSERT INTO `tb_staff_function` (`staff_function_id`, `company_id`, `user_type`, `staff_function_name`, `staff_function_ename`, `staff_function_parentid`, `staff_function_pos`, `staff_function_status`) VALUES
(1, 13, NULL, 'Chủ tịch', 'Principal', 0, 1, 'active'),
(2, 13, NULL, 'Tổng giám đốc', 'Principal Vipe', 1, 1.1, 'active'),
(3, 13, NULL, 'Phó tổng giám đốc', 'IT', 2, 1.11, 'active'),
(7, 14, NULL, 'Giám đốc Ä‘iá»u hà nh', 'Managing Director', 0, 1, 'active'),
(8, 14, NULL, 'Phó giám đốc Ä‘iá»u hà nh', 'Deputy CEO', 7, 1.1, 'active'),
(9, 14, NULL, 'Chuyên viên IT', 'IT', 8, 1.11, 'active'),
(10, 2, 'cbnv', 'Hiệu trưởng', 'Pricipal', 0, 1, 'active'),
(11, 2, 'cbnv', 'Phó hiệu trưởng', 'Vice Pricipal', 10, 1.1, 'active'),
(12, 2, 'cbnv', 'Nhân viên IT', 'IT Staff', 11, 1.11, 'active'),
(13, 2, 'cbnv', 'Giáo viên', 'Teacher', 11, 1.12, 'active'),
(14, 2, 'cbnv', 'Tuyển sinh', 'enroll', 11, 1.13, 'active'),
(15, 14, NULL, 'Truyá»n thông - tiếp thị', 'Marketing', 8, 1.13, 'active'),
(16, 2, 'student_k12', 'Lớp trưởng', 'Lớp trưởng', 0, 1, 'active'),
(17, 2, 'student_k12', 'Lá»›p phó há»c táºp', 'Lá»›p phó há»c táºp', 0, 2, 'active'),
(18, 2, 'student_k12', 'Lớp phó lao động', 'Lớp phó lao động', 0, 3, 'active'),
(19, 2, 'student_k12', 'Lớp phó văn thể', 'Lớp phó văn thể', 0, 5, 'active');
-- --------------------------------------------------------
--
-- Table structure for table `tb_staff_subject`
--
CREATE TABLE `tb_staff_subject` (
`staff_subject_id` int(11) NOT NULL,
`staff_id` int(11) DEFAULT NULL,
`subject_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_staff_subject`
--
INSERT INTO `tb_staff_subject` (`staff_subject_id`, `staff_id`, `subject_id`) VALUES
(17, 18, 4),
(18, 18, 8),
(19, 18, 10),
(20, 18, 12),
(21, 18, 16),
(142, 17, 4),
(143, 17, 5),
(144, 17, 12),
(145, 17, 16),
(146, 17, 18),
(150, 20, 4),
(151, 20, 5),
(152, 20, 6),
(156, 19, 5),
(157, 19, 6),
(158, 19, 16),
(159, 241, 5),
(184, 322, 4),
(185, 322, 5),
(186, 322, 3),
(187, 322, 6),
(188, 322, 7),
(189, 322, 8),
(190, 322, 9),
(191, 322, 10),
(192, 322, 11),
(193, 322, 13),
(194, 322, 14),
(195, 322, 15),
(196, 323, 9),
(197, 323, 20),
(198, 323, 33),
(199, 326, 13),
(200, 326, 26),
(201, 326, 40),
(205, 327, 5),
(206, 327, 16),
(207, 327, 30),
(209, 324, 7),
(210, 324, 24),
(211, 324, 29),
(215, 357, 5),
(216, 357, 20),
(217, 357, 30),
(225, 328, 3),
(226, 328, 17),
(227, 328, 31),
(229, 335, 5),
(230, 335, 16),
(231, 335, 30),
(247, 321, 4),
(248, 321, 12),
(249, 321, 29),
(278, 329, 7),
(279, 329, 18),
(280, 329, 19),
(281, 332, 19),
(282, 332, 20),
(284, 317, 13),
(285, 318, 15),
(286, 318, 19),
(287, 319, 6),
(288, 320, 15),
(289, 396, 20),
(290, 345, 5),
(293, 364, 8),
(294, 364, 9),
(295, 381, 12),
(296, 352, 14),
(298, 397, 6),
(299, 397, 19),
(300, 398, 7),
(301, 398, 10),
(302, 344, 17),
(303, 344, 18),
(304, 369, 16),
(305, 391, 15),
(306, 348, 20);
-- --------------------------------------------------------
--
-- Table structure for table `tb_tongiao`
--
CREATE TABLE `tb_tongiao` (
`tongiao_id` int(11) NOT NULL,
`tongiao_vi` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`tongiao_en` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`tongiao_pos` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_tongiao`
--
INSERT INTO `tb_tongiao` (`tongiao_id`, `tongiao_vi`, `tongiao_en`, `tongiao_pos`) VALUES
(1, 'Không', 'None', 1),
(2, 'Pháºt giáo', 'Buddhism', 2),
(3, 'Thiên chúa', 'Dominical', 3),
(4, 'Ba Ha'i', 'Ba Ha'i', 33),
(5, 'Bá»u sÆ¡n Kỳ HÆ°Æ¡ng', 'Bá»u sÆ¡n Kỳ HÆ°Æ¡ng', 34),
(6, 'Cao ÄÃ i', 'Cao ÄÃ i', 35),
(7, 'Công giáo', 'Công giáo', 36),
(8, 'Hồi giáo', 'Hồi giáo', 37),
(9, 'Minh Lý đạo', 'Minh Lý đạo', 38),
(10, 'Minh sư đạo', 'Minh sư đạo', 39),
(11, 'Pháºt giáo Hòa Hảo', 'Pháºt giáo Hòa Hảo', 40),
(12, 'Tin LÃ nh', 'Tin LÃ nh', 41),
(13, 'Tôn giáo khác', 'Tôn giáo khác', 99),
(14, 'Tịnh Ä‘á»™ cÆ° sÄ© Pháºt há»™i Việt Nam', 'Tịnh Ä‘á»™ cÆ° sÄ© Pháºt há»™i Việt Nam', 42),
(15, 'Äạo tứ ân hiếu nghÄ©a', 'Äạo tứ ân hiếu nghÄ©a', 43);
-- --------------------------------------------------------
--
-- Table structure for table `tb_tuyendung_city`
--
CREATE TABLE `tb_tuyendung_city` (
`ID_city` int(11) NOT NULL,
`city_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`code` double DEFAULT NULL,
`percent` float(3,1) DEFAULT NULL,
`pos` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tb_tuyendung_city`
--
INSERT INTO `tb_tuyendung_city` (`ID_city`, `city_name`, `code`, `percent`, `pos`, `status`) VALUES
(87, 'Bà Rịa Vũng Tà u', 64, 0.0, '1', 1),
(92, 'Bến Tre', 75, 0.0, '1', 1),
(93, 'Bình Dương', 650, 0.0, '1', 1),
(96, 'Bình Äịnh', 56, 0.0, '2', 1),
(97, 'CÃ Mau', 780, 0.0, '1', 1),
(99, 'TP Cần Thơ', 710, 0.0, '5', 1),
(100, 'TP Äà Nẵng', 511, 0.0, '4', 1),
(103, 'Äồng Nai', 61, 0.0, '1', 1),
(108, ' TP HÃ Ná»™i', 4, 0.0, '3', 1),
(111, 'TP Hải Phòng', 31, 0.0, '3', 1),
(114, ' TP Hồ Chà Minh', 8, 0.0, '1', 1),
(116, 'Khánh Hòa', 58, 0.0, '13', 1),
(121, 'Äà Lạt - Lâm Äồng', 63, 0.0, '1', 1),
(122, 'Long An', 72, 0.0, '15', 1),
(136, 'Tây Ninh', 66, 0.0, '16', 1),
(140, 'Thừa Thiên Huế', 54, 0.0, '19', 1),
(141, 'Tiá»n Giang', 73, 0.0, '20', 1),
(147, 'Quảng Ninh', 33, 0.0, '21', 1),
(149, 'Quảng Nam', 510, 0.0, '0', 1),
(150, 'An Giang', 76, 0.0, '1', 1),
(151, 'Bình Thuáºn', 62, 0.0, '2', 1),
(152, 'Bắc Giang', 240, 0.0, '2', 1),
(153, 'Bắc Cạn', 281, 0.0, '2', 1),
(154, 'Bạc Liêu', 781, 0.0, '1', 1),
(155, 'Bắc Ninh', 241, 0.0, '2', 1),
(156, 'Bình Phước', 651, 0.0, '2', 1),
(157, 'Cao Bằng', 26, 0.0, '3', 1),
(158, 'Cần ThÆ¡ - Háºu Giang', 71, 0.0, '1', 1),
(159, 'Äắc Lắc - Äắc Nông', 50, 0.0, '2', 1),
(160, 'Äồng Tháp', 67, 0.0, '1', 1),
(161, 'Gia Lai', 59, 0.0, '0', 1),
(162, 'HÃ Giang', 19, 0.0, '0', 1),
(163, 'HÃ Nam', 351, 0.0, '0', 1),
(164, 'Hà Tây', 34, 0.0, '0', 1),
(165, 'HÃ TÄ©nh', 39, 0.0, '0', 1),
(166, 'Hải Dương', 320, 0.0, '0', 1),
(167, 'Hòa Bình', 18, 0.0, '0', 1),
(168, 'Hưng Yên', 321, 0.0, '0', 1),
(169, 'Kiên Giang', 77, 0.0, '0', 1),
(170, 'Kom-Tum', 60, 0.0, '0', 1),
(171, 'Lai Châu - Äiện Biên', 23, 0.0, '0', 1),
(172, 'Lạng Sơn', 25, 0.0, '0', 1),
(173, 'Lao Cai', 20, 0.0, '0', 1),
(174, 'Nam Äịnh', 350, 0.0, '0', 1),
(175, 'Nghệ An', 38, 0.0, '0', 1),
(176, 'Ninh Bình', 30, 0.0, '0', 1),
(177, 'Ninh Thuáºn', 68, 0.0, '0', 1),
(178, 'Phú Thá»', 210, 0.0, '0', 1),
(179, 'Phú Yên', 57, 0.0, '0', 1),
(180, 'Quảng Bình', 52, 0.0, '0', 1),
(181, 'Quảng Ngãi', 55, 0.0, '0', 1),
(182, 'Quảng Trị', 53, 0.0, '0', 1),
(183, 'Sóc Trăng', 79, 0.0, '0', 1),
(184, 'SÆ¡n La', 22, 0.0, '0', 1),
(185, 'Thái Bình', 36, 0.0, '0', 1),
(186, 'Thái Nguyên', 280, 0.0, '0', 1),
(187, 'Thanh Hóa', 37, 0.0, '0', 1),
(188, 'Trà Vinh', 74, 0.0, '0', 1),
(189, 'Tuyên Quang', 27, 0.0, '0', 1),
(190, 'VÄ©nh Long', 70, 0.0, '0', 1),
(191, 'Vĩnh Phúc', 211, 0.0, '0', 1),
(192, 'Yên Bái', 29, 0.0, '0', 1),
(194, 'Toà n quốc', 99, 0.0, '0', 1);
-- --------------------------------------------------------
--
-- Table structure for table `tb_user`
--
CREATE TABLE `tb_user` (
`user_id` int(11) NOT NULL,
`user_key` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_password_default` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_password_hash` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_image` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_last_login` datetime DEFAULT NULL,
`user_ip` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_rule` longtext COLLATE utf8mb4_unicode_ci,
`user_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tb_user`
--
INSERT INTO `tb_user` (`user_id`, `user_key`, `user_password_default`, `user_password_hash`, `user_image`, `user_type`, `user_last_login`, `user_ip`, `user_rule`, `user_status`) VALUES
(2, 'giacbn', NULL, '$2y$12$kgThj8G1z1IW4Pgw.5G2o.p4M/N0z623Ce973ZMHzh/Om.cdfFBoW', NULL, 'cbnv', '2022-01-09 11:13:37', '127.0.0.1', '', NULL);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `tb_action_logs`
--
ALTER TABLE `tb_action_logs`
ADD PRIMARY KEY (`log_id`);
--
-- Indexes for table `tb_banner`
--
ALTER TABLE `tb_banner`
ADD PRIMARY KEY (`banner_id`);
--
-- Indexes for table `tb_block`
--
ALTER TABLE `tb_block`
ADD PRIMARY KEY (`block_id`);
--
-- Indexes for table `tb_block_page`
--
ALTER TABLE `tb_block_page`
ADD PRIMARY KEY (`block_page_id`);
--
-- Indexes for table `tb_category_module`
--
ALTER TABLE `tb_category_module`
ADD PRIMARY KEY (`category_module_id`);
--
-- Indexes for table `tb_city`
--
ALTER TABLE `tb_city`
ADD PRIMARY KEY (`city_id`);
--
-- Indexes for table `tb_company`
--
ALTER TABLE `tb_company`
ADD PRIMARY KEY (`company_id`);
--
-- Indexes for table `tb_company_module`
--
ALTER TABLE `tb_company_module`
ADD PRIMARY KEY (`company_module_id`);
--
-- Indexes for table `tb_country`
--
ALTER TABLE `tb_country`
ADD PRIMARY KEY (`country_id`);
--
-- Indexes for table `tb_customer`
--
ALTER TABLE `tb_customer`
ADD PRIMARY KEY (`customer_id`);
--
-- Indexes for table `tb_dantoc`
--
ALTER TABLE `tb_dantoc`
ADD PRIMARY KEY (`dantoc_id`);
--
-- Indexes for table `tb_dienchinhsach`
--
ALTER TABLE `tb_dienchinhsach`
ADD PRIMARY KEY (`dienchinhsach_id`);
--
-- Indexes for table `tb_district`
--
ALTER TABLE `tb_district`
ADD PRIMARY KEY (`district_id`);
--
-- Indexes for table `tb_hopdong`
--
ALTER TABLE `tb_hopdong`
ADD PRIMARY KEY (`hopdong_id`);
--
-- Indexes for table `tb_hopdong_tpl`
--
ALTER TABLE `tb_hopdong_tpl`
ADD PRIMARY KEY (`hopdong_tpl_id`);
--
-- Indexes for table `tb_language`
--
ALTER TABLE `tb_language`
ADD PRIMARY KEY (`language_id`);
--
-- Indexes for table `tb_loging`
--
ALTER TABLE `tb_loging`
ADD PRIMARY KEY (`login_id`);
--
-- Indexes for table `tb_menus`
--
ALTER TABLE `tb_menus`
ADD PRIMARY KEY (`menus_id`);
--
-- Indexes for table `tb_menus_pages`
--
ALTER TABLE `tb_menus_pages`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_module`
--
ALTER TABLE `tb_module`
ADD PRIMARY KEY (`module_id`);
--
-- Indexes for table `tb_module_category`
--
ALTER TABLE `tb_module_category`
ADD PRIMARY KEY (`module_category_id`);
--
-- Indexes for table `tb_nghenghiep`
--
ALTER TABLE `tb_nghenghiep`
ADD PRIMARY KEY (`nghenghiep_id`);
--
-- Indexes for table `tb_options`
--
ALTER TABLE `tb_options`
ADD PRIMARY KEY (`option_id`),
ADD UNIQUE KEY `option_name` (`option_name`),
ADD KEY `autoload` (`autoload`);
--
-- Indexes for table `tb_pages`
--
ALTER TABLE `tb_pages`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_param`
--
ALTER TABLE `tb_param`
ADD PRIMARY KEY (`param_id`);
--
-- Indexes for table `tb_param_data`
--
ALTER TABLE `tb_param_data`
ADD PRIMARY KEY (`param_data_id`);
--
-- Indexes for table `tb_qrcode`
--
ALTER TABLE `tb_qrcode`
ADD PRIMARY KEY (`qrcode_id`);
--
-- Indexes for table `tb_service`
--
ALTER TABLE `tb_service`
ADD PRIMARY KEY (`service_id`);
--
-- Indexes for table `tb_service_event`
--
ALTER TABLE `tb_service_event`
ADD PRIMARY KEY (`service_event_id`);
--
-- Indexes for table `tb_staff`
--
ALTER TABLE `tb_staff`
ADD PRIMARY KEY (`staff_id`);
--
-- Indexes for table `tb_staffgroup`
--
ALTER TABLE `tb_staffgroup`
ADD PRIMARY KEY (`staffgroup_id`);
--
-- Indexes for table `tb_staff_event`
--
ALTER TABLE `tb_staff_event`
ADD PRIMARY KEY (`staff_event_id`);
--
-- Indexes for table `tb_staff_function`
--
ALTER TABLE `tb_staff_function`
ADD PRIMARY KEY (`staff_function_id`);
--
-- Indexes for table `tb_staff_subject`
--
ALTER TABLE `tb_staff_subject`
ADD PRIMARY KEY (`staff_subject_id`);
--
-- Indexes for table `tb_tongiao`
--
ALTER TABLE `tb_tongiao`
ADD PRIMARY KEY (`tongiao_id`);
--
-- Indexes for table `tb_tuyendung_city`
--
ALTER TABLE `tb_tuyendung_city`
ADD PRIMARY KEY (`ID_city`),
ADD KEY `ID_city` (`ID_city`),
ADD KEY `ID_city_2` (`ID_city`),
ADD KEY `ID_city_3` (`ID_city`),
ADD KEY `ID_city_4` (`ID_city`),
ADD KEY `ID_city_5` (`ID_city`),
ADD KEY `ID_city_6` (`ID_city`);
--
-- Indexes for table `tb_user`
--
ALTER TABLE `tb_user`
ADD PRIMARY KEY (`user_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `tb_action_logs`
--
ALTER TABLE `tb_action_logs`
MODIFY `log_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tb_banner`
--
ALTER TABLE `tb_banner`
MODIFY `banner_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tb_block`
--
ALTER TABLE `tb_block`
MODIFY `block_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `tb_block_page`
--
ALTER TABLE `tb_block_page`
MODIFY `block_page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `tb_category_module`
--
ALTER TABLE `tb_category_module`
MODIFY `category_module_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `tb_city`
--
ALTER TABLE `tb_city`
MODIFY `city_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;
--
-- AUTO_INCREMENT for table `tb_company`
--
ALTER TABLE `tb_company`
MODIFY `company_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `tb_company_module`
--
ALTER TABLE `tb_company_module`
MODIFY `company_module_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=743;
--
-- AUTO_INCREMENT for table `tb_country`
--
ALTER TABLE `tb_country`
MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=243;
--
-- AUTO_INCREMENT for table `tb_customer`
--
ALTER TABLE `tb_customer`
MODIFY `customer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tb_dantoc`
--
ALTER TABLE `tb_dantoc`
MODIFY `dantoc_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=120;
--
-- AUTO_INCREMENT for table `tb_dienchinhsach`
--
ALTER TABLE `tb_dienchinhsach`
MODIFY `dienchinhsach_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `tb_district`
--
ALTER TABLE `tb_district`
MODIFY `district_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tb_hopdong`
--
ALTER TABLE `tb_hopdong`
MODIFY `hopdong_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tb_hopdong_tpl`
--
ALTER TABLE `tb_hopdong_tpl`
MODIFY `hopdong_tpl_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tb_language`
--
ALTER TABLE `tb_language`
MODIFY `language_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=322;
--
-- AUTO_INCREMENT for table `tb_loging`
--
ALTER TABLE `tb_loging`
MODIFY `login_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tb_menus`
--
ALTER TABLE `tb_menus`
MODIFY `menus_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT for table `tb_menus_pages`
--
ALTER TABLE `tb_menus_pages`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;
--
-- AUTO_INCREMENT for table `tb_module`
--
ALTER TABLE `tb_module`
MODIFY `module_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `tb_module_category`
--
ALTER TABLE `tb_module_category`
MODIFY `module_category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `tb_nghenghiep`
--
ALTER TABLE `tb_nghenghiep`
MODIFY `nghenghiep_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `tb_options`
--
ALTER TABLE `tb_options`
MODIFY `option_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=154;
--
-- AUTO_INCREMENT for table `tb_pages`
--
ALTER TABLE `tb_pages`
MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tb_param`
--
ALTER TABLE `tb_param`
MODIFY `param_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `tb_param_data`
--
ALTER TABLE `tb_param_data`
MODIFY `param_data_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
--
-- AUTO_INCREMENT for table `tb_qrcode`
--
ALTER TABLE `tb_qrcode`
MODIFY `qrcode_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `tb_service`
--
ALTER TABLE `tb_service`
MODIFY `service_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tb_service_event`
--
ALTER TABLE `tb_service_event`
MODIFY `service_event_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tb_staff`
--
ALTER TABLE `tb_staff`
MODIFY `staff_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=399;
--
-- AUTO_INCREMENT for table `tb_staffgroup`
--
ALTER TABLE `tb_staffgroup`
MODIFY `staffgroup_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tb_staff_event`
--
ALTER TABLE `tb_staff_event`
MODIFY `staff_event_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `tb_staff_function`
--
ALTER TABLE `tb_staff_function`
MODIFY `staff_function_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `tb_staff_subject`
--
ALTER TABLE `tb_staff_subject`
MODIFY `staff_subject_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=307;
--
-- AUTO_INCREMENT for table `tb_tongiao`
--
ALTER TABLE `tb_tongiao`
MODIFY `tongiao_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `tb_tuyendung_city`
--
ALTER TABLE `tb_tuyendung_city`
MODIFY `ID_city` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=195;
--
-- AUTO_INCREMENT for table `tb_user`
--
ALTER TABLE `tb_user`
MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;