/*
 Navicat MySQL Data Transfer

 Source Server         : BuyerKiosk - Local
 Source Server Type    : MariaDB
 Source Server Version : 110502 (11.5.2-MariaDB)
 Source Host           : localhost:3306
 Source Schema         : kiosk_pc00

 Target Server Type    : MariaDB
 Target Server Version : 110502 (11.5.2-MariaDB)
 File Encoding         : 65001

 Date: 02/01/2025 11:58:59
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for safeConfiguration
-- ----------------------------
DROP TABLE IF EXISTS `safeConfiguration`;
CREATE TABLE `safeConfiguration` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timeStamp` datetime DEFAULT NULL,
  `userId` varchar(20) DEFAULT NULL,
  `lowPennies` int(11) DEFAULT NULL COMMENT 'Minimum penny rolls alert threshold',
  `criticalPennies` int(11) DEFAULT NULL COMMENT 'Critical penny rolls alert threshold',
  `penniesPerRoll` int(11) DEFAULT NULL COMMENT 'Number of pennies in one roll',
  `lowNickels` int(11) DEFAULT NULL COMMENT 'Minimum nickel rolls alert threshold',
  `criticalNickels` int(11) DEFAULT NULL COMMENT 'Critical nickel rolls alert threshold',
  `nickelsPerRoll` int(11) DEFAULT NULL COMMENT 'Number of nickels in one roll',
  `lowDimes` int(11) DEFAULT NULL COMMENT 'Minimum dime rolls alert threshold',
  `criticalDimes` int(11) DEFAULT NULL COMMENT 'Critical dime rolls alert threshold',
  `dimesPerRoll` int(11) DEFAULT NULL COMMENT 'Number of dimes in one roll',
  `lowQuarters` int(11) DEFAULT NULL COMMENT 'Minimum quarter rolls alert threshold',
  `criticalQuarters` int(11) DEFAULT NULL COMMENT 'Critical quarter rolls alert threshold',
  `quartersPerRoll` int(11) DEFAULT NULL COMMENT 'Number of quarters in one roll',
  `lowOnes` int(11) DEFAULT NULL COMMENT 'Minimum one dollar alert threshold',
  `criticalOnes` int(11) DEFAULT NULL COMMENT 'Critical one dollar alert threshold',
  `onesPerBundle` int(11) DEFAULT NULL COMMENT 'Number of ones in one bundle',
  `lowFives` int(11) DEFAULT NULL COMMENT 'Minimum five dollar alert threshold',
  `criticalFives` int(11) DEFAULT NULL COMMENT 'Critical five dollar alert threshold',
  `fivesPerBundle` int(11) DEFAULT NULL COMMENT 'Number of fives in one bundle',
  `lowTens` int(11) DEFAULT NULL COMMENT 'Minimum ten dollar alert threshold',
  `criticalTens` int(11) DEFAULT NULL COMMENT 'Critical ten dollar alert threshold',
  `tensPerBundle` int(11) DEFAULT NULL COMMENT 'Number of tens in one bundle',
  `lowTwenties` int(11) DEFAULT NULL COMMENT 'Minimum twenty dollar alert threshold',
  `criticalTwenties` int(11) DEFAULT NULL COMMENT 'Critical twenty dollar alert threshold',
  `twentiesPerBundle` int(11) DEFAULT NULL COMMENT 'Number of twenties in one bundle',
  `lowFifties` int(11) DEFAULT NULL COMMENT 'Minimum fifty dollar alert threshold',
  `criticalFifties` int(11) DEFAULT NULL COMMENT 'Critical fifty dollar alert threshold',
  `fiftiesPerBundle` int(11) DEFAULT NULL COMMENT 'Number of fifties in one bundle',
  `lowHundreds` int(11) DEFAULT NULL COMMENT 'Minimum hundred dollar alert threshold',
  `criticalHundreds` int(11) DEFAULT NULL COMMENT 'Critical hundred dollar alert threshold',
  `hundredsPerBundle` int(11) DEFAULT NULL COMMENT 'Number of hundreds in one bundle',
  `createdAt` timestamp NULL DEFAULT current_timestamp(),
  `updatedAt` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;
