text: -- Host: localhost
  -- Generation Time: Dec 14, 2018 at 05:24 PM
  -- Server version: 5.7.24
  -- PHP Version: 7.1.23
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  --
  -- Database: `employee`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `employees`
  --
  
  DROP TABLE IF EXISTS `employees`;
  CREATE TABLE `employees` (
    `ID` bigint(8) NOT NULL,
    `FirstName` varchar(255) DEFAULT NULL,
    `MiddleInitial` char(1) DEFAULT NULL,
    `LastName` varchar(50) NOT NULL,
    `DateOfBirth` date DEFAULT NULL,
    `DateOfEmployment` date DEFAULT NULL,
    `status` varchar(8) DEFAULT 'ACTIVE',
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `employees`
  --
  
  INSERT INTO `employees` (`ID`, `FirstName`, `MiddleInitial`, `LastName`, `DateOfBirth`, `DateOfEmployment`, `status`, `created_at`, `updated_at`) VALUES
  (1, 'Bruce', 'T', 'Boss', '1966-06-20', '2016-02-15', 'INACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (2, 'Jeff', 'T', 'Bosswell', '1969-06-20', '2014-02-15', 'INACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (3, 'Junita', 'C', 'Xiao', '1979-06-20', '2018-02-15', 'INACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (4, 'Wan', '', 'Pin', '1976-06-20', '2013-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (5, 'Tish', 'B', 'Kittens', '1978-06-20', '2014-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (6, 'Anastat', 'W', 'Volder', '1928-06-20', '2004-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (7, 'Patches', 'W', 'TheDogge', '1938-06-20', '2004-02-15', 'INACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (8, 'Trigger', 'P', 'Tester', '1928-06-20', '2004-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (9, 'TriggerUUI', 'W', 'Tester', '1928-06-20', '2004-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (10, 'NoTriggerUUI', 'W', 'TesterDogge', '1938-06-20', '2004-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (11, 'Smaller', 'P', 'Payloaded', '1998-06-20', '2018-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (12, 'Smallest', 'V', 'Payload', '1998-06-20', '2018-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (13, 'Jameson', 'V', 'Weller', '1968-06-20', '2018-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (15, 'Default', 'V', 'Active', '1968-06-20', '2018-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (17, 'Default', 'V', 'Active', '1968-06-20', '2018-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (18, 'Default', 'V', 'Active', '1968-06-20', '2018-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (19, 'Default', 'V', 'Active', '1968-06-20', '2018-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (20, 'Bigger', 'P', 'Digger', '1998-06-20', '2018-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (21, 'Thomas', 'F', 'Blige', '1998-06-20', '2018-02-15', 'INACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (22, 'Little', 'P', 'Big', '1998-06-20', '2018-02-15', 'INACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (23, '那个', 'P', '龙', '1998-06-20', '2018-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (24, '那个', 'P', '龙', '1998-06-20', '2018-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (25, 'NoTriggerUUI', 'W', 'TesterDogge', '1938-06-20', '2004-02-15', 'ACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51'),
  (26, 'NoTriggerUUI', 'W', 'TesterDogge', '1938-06-20', '2004-02-15', 'INACTIVE', '2018-12-14 17:14:51', '2018-12-14 17:14:51');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `employees`
  --
  ALTER TABLE `employees`
    ADD PRIMARY KEY (`ID`);
  ALTER TABLE `employees` ADD FULLTEXT KEY `SEARCH_EMPLOYEES` (`FirstName`,`MiddleInitial`,`LastName`,`status`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `employees`
  --
  ALTER TABLE `employees`
    MODIFY `ID` bigint(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
  COMMIT;
  
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `employees`
  --
  ALTER TABLE `employees`
    MODIFY `ID` bigint(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
  COMMIT;
  