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="[email protected]">[email protected]</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="[email protected]">[email protected]</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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', 'yes'), (16, 'mailserver_pass', 'password', 'yes'), (17, 'mailserver_port', '110', 'yes'), (18, 'website_email', '[email protected]', 'yes'), (19, 'email_newsletter', '[email protected]', '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:[email protected]">[email protected]</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, '[email protected]', 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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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ệ', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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ơ', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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ư', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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ú', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '', '[email protected]', '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', '[email protected]', '[email protected]', '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', '[email protected]', '[email protected]', '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', '[email protected]', '[email protected]', '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', '[email protected]', '[email protected]', '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 */;