/*
 Navicat Premium Dump SQL

 Source Server         : BuyerKiosk Production
 Source Server Type    : MariaDB
 Source Server Version : 100526 (10.5.26-MariaDB-log)
 Source Host           : localhost:3306
 Source Schema         : kiosk_ou20913

 Target Server Type    : MariaDB
 Target Server Version : 100526 (10.5.26-MariaDB-log)
 File Encoding         : 65001

 Date: 29/04/2025 15:15:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for customers
-- ----------------------------
DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
  `customerID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `dateAdded` timestamp NOT NULL DEFAULT current_timestamp(),
  `firstName` varchar(50) NOT NULL,
  `lastName` varchar(50) NOT NULL,
  `email` varchar(50) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(50) NOT NULL,
  `state` varchar(2) NOT NULL,
  `zipcode` varchar(5) NOT NULL,
  `phone` varchar(10) NOT NULL,
  `onSMS` tinyint(1) unsigned DEFAULT 0,
  `onEmail` tinyint(1) unsigned DEFAULT 0,
  `driversLicense` varchar(50) DEFAULT NULL,
  `referralCode` varchar(10) NOT NULL DEFAULT '000000',
  `addedToSMS` timestamp NULL DEFAULT NULL,
  `addedToEmail` timestamp NULL DEFAULT NULL,
  `driversLicenseDOB` date DEFAULT NULL,
  `driversLicenseExpiration` date DEFAULT NULL,
  PRIMARY KEY (`customerID`),
  KEY `dl` (`driversLicense`)
) ENGINE=InnoDB AUTO_INCREMENT=31830 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;
