/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.6.22-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: schema01
-- ------------------------------------------------------
-- Server version	10.6.22-MariaDB-deb11

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `schema01`
--
DROP SCHEMA IF EXISTS `schema01`;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `schema01` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

USE `schema01`;

--
-- Table structure for table `PERSONS`
--

DROP TABLE IF EXISTS `PERSONS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `PERSONS` (
  `pers_id` varchar(16) NOT NULL,
  `pers_first_name` varchar(100) DEFAULT NULL,
  `pers_middle_name` varchar(100) DEFAULT NULL,
  `pers_last_name` varchar(100) DEFAULT NULL,
  `pers_external_id_type` varchar(50) DEFAULT NULL,
  `pers_external_id_number` varchar(50) DEFAULT NULL,
  `pers_date_of_birth` date DEFAULT NULL,
  `pers_created` datetime DEFAULT NULL,
  `pers_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`pers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `PERSONS`
--

LOCK TABLES `PERSONS` WRITE;
/*!40000 ALTER TABLE `PERSONS` DISABLE KEYS */;
INSERT INTO `PERSONS` VALUES ('be33445461','Eveline','Ilsa','Bettini','passport','FC921106875','2001-06-01','2020-08-02 14:36:25','2020-08-02 14:36:25'),('bu13117834','Mara',NULL,'Bump','passport','TB963625718','1975-03-15','2013-05-16 02:15:05','2013-05-16 02:15:05'),('bu67045183','Lorenza','Agace','Bushnell','other','542113016','1987-12-11','2023-02-06 16:29:50','2023-02-06 16:29:50'),('cl98793943','Nixie','Nicol','Clugston','government','821278968','2007-12-13','2017-06-28 05:18:46','2017-06-28 05:18:46'),('la61673088','Rafa','Rheta','Laduc','passport','437337274','2001-05-06','2019-08-01 14:49:38','2019-08-01 14:49:38'),('ro29141054','Alison','Norry','Rodinson','passport','175855118','1994-09-29','2018-01-02 23:48:18','2018-01-02 23:48:18'),('sc84895293','Nichol','Sal','Schram','driverslicense','962654716','1990-01-26','2018-05-10 11:09:52','2018-05-10 11:09:52'),('sw54303039','Sephira',NULL,'Swagerty','driverslicense','390125092','2002-02-06','2020-10-10 05:02:52','2020-10-10 05:02:52'),('ty64613232','Tamma','Nancy','Tylwalk','driverslicense','VI160438110','2001-06-01','2019-06-09 06:35:25','2019-06-09 06:35:25'),('wi86040599','Danny','Tomasine','Wineland','government','68607352','2004-11-20','2015-08-14 15:21:36','2015-08-14 15:21:36');
/*!40000 ALTER TABLE `PERSONS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `STAFF`
--

DROP TABLE IF EXISTS `STAFF`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `STAFF` (
  `staff_pers_id` varchar(10) DEFAULT NULL,
  `staff_job_title` varchar(100) DEFAULT NULL,
  `staff_last_day_employed` date DEFAULT NULL,
  `staff_created` datetime DEFAULT NULL,
  `staff_updated` datetime DEFAULT NULL,
  KEY `fk_staff_pers` (`staff_pers_id`),
  CONSTRAINT `fk_staff_pers` FOREIGN KEY (`staff_pers_id`) REFERENCES `PERSONS` (`pers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `STAFF`
--

LOCK TABLES `STAFF` WRITE;
/*!40000 ALTER TABLE `STAFF` DISABLE KEYS */;
INSERT INTO `STAFF` VALUES ('be33445461','driver','2999-01-01','2020-08-03 02:39:41','2020-08-03 02:39:41'),('be33445461','driver','2999-01-01','2020-08-03 08:30:58','2020-08-03 08:30:58'),('bu13117834','administrative','2999-01-01','2013-05-16 13:41:03','2013-05-16 13:41:03'),('bu67045183','mechanic','2999-01-01','2023-02-07 09:30:04','2023-02-07 09:30:04'),('cl98793943','janitor','2999-01-01','2017-06-28 16:57:16','2017-06-28 16:57:16'),('la61673088','driver','2999-01-01','2019-08-01 19:34:44','2019-08-01 19:34:44'),('ro29141054','cafeteria','2999-01-01','2018-01-03 17:51:04','2018-01-03 17:51:04'),('ro29141054','driver','2999-01-01','2018-01-03 13:47:43','2018-01-03 13:47:43'),('sc84895293','administrative','2999-01-01','2018-05-11 03:58:38','2018-05-11 03:58:38'),('sw54303039','administrative','2999-01-01','2020-10-11 08:08:20','2020-10-11 08:08:20'),('ty64613232','administrative','2999-01-01','2019-06-10 05:23:25','2019-06-10 05:23:25'),('wi86040599','administrative','2999-01-01','2015-08-15 18:00:04','2015-08-15 18:00:04');
/*!40000 ALTER TABLE `STAFF` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-05-15 12:09:52
