Robot-Tank v6.2 can't login - Printable Version

Code:
-- phpMyAdmin SQL Dump

-- version 4.6.6deb5

-- https://www.phpmyadmin.net/

--

-- Host: localhost:3306

-- Generation Time: Oct 09, 2021 at 06:59 AM

-- Server version: 10.3.29-MariaDB-0+deb10u1

-- PHP Version: 7.3.29-1~deb10u1



SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

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: `robotank`

--



CREATE DATABASE robotank;

USE robotank

-- --------------------------------------------------------



--

-- Table structure for table `button_labels`

--



CREATE TABLE `button_labels` (

  `buttonID` int(11) NOT NULL,

  `label` text NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;



--

-- Dumping data for table `button_labels`

--



INSERT INTO `button_labels` (`buttonID`, `label`) VALUES

(1, 'Configure Ports'),

(2, 'Dosing Pumps'),

(3, 'Email'),

(4, 'Calibrate Probes'),

(5, 'System'),

(6, 'Customize'),

(7, 'Hardware'),

(8, 'Schedules'),

(9, 'System'),

(10, 'Set Clock'),

(11, 'Equipment Connected'),

(12, 'Temperature Sensors'),

(13, 'Analog Sensors'),

(14, 'DC Accessories'),

(15, 'Dosing Pumps'),

(16, 'Flow Meter'),

(17, 'Automatic Top Off'),

(18, 'Sensor Probes'),

(19, 'Energy Power Bar');



-- --------------------------------------------------------



--

-- Table structure for table `dateTimeSync`

--



CREATE TABLE `dateTimeSync` (

  `syncID` int(11) NOT NULL,

  `currentMillisOffset` varchar(22) NOT NULL,

  `currentMillisLastSync` varchar(22) NOT NULL,

  `UTCoffset` varchar(22) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



--

-- Dumping data for table `dateTimeSync`

--



INSERT INTO `dateTimeSync` (`syncID`, `currentMillisOffset`, `currentMillisLastSync`, `UTCoffset`) VALUES

(0, '85411', '1613543238313', '-25200000');



-- --------------------------------------------------------



--

-- Table structure for table `dosingPumps`

--



CREATE TABLE `dosingPumps` (

  `doseID` int(11) NOT NULL,

  `dosePinID` int(11) NOT NULL COMMENT 'connected to pinID in pinsAvailable',

  `doseName` varchar(55) NOT NULL DEFAULT 'Add Custom Name',

  `doseAmount` int(11) NOT NULL DEFAULT 10 COMMENT 'milliliters',

  `reservoirRemain` int(11) NOT NULL DEFAULT 250 COMMENT 'milliliters',

  `reservoirSize` int(11) NOT NULL DEFAULT 250 COMMENT 'milliliters',

  `dosePumpRate` int(11) NOT NULL DEFAULT 250 COMMENT 'ms/ml',

  `doseStirrer` int(11) NOT NULL DEFAULT 0,

  `calibrateAmount` int(11) NOT NULL DEFAULT 5 COMMENT 'milliliters',

  `reservoirColor` varchar(12) NOT NULL DEFAULT '#FF0000',

  `doseInterval` int(11) NOT NULL DEFAULT 1 COMMENT 'min delay between doses - minutes'

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



-- --------------------------------------------------------



--

-- Table structure for table `drivers`

--



CREATE TABLE `drivers` (

  `driverID` int(11) NOT NULL,

  `driverTypeID` tinyint(4) DEFAULT NULL,

  `driverName` text NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



--

-- Dumping data for table `drivers`

--



INSERT INTO `drivers` (`driverID`, `driverTypeID`, `driverName`) VALUES

(1, 0, 'Dummy'),

(2, 0, 'Raspberry Pi'),

(3, 1, 'PCA9685');



-- --------------------------------------------------------



--

-- Table structure for table `ds18b20`

--



CREATE TABLE `ds18b20` (

  `ds18b20ID` int(11) NOT NULL,

  `id` int(11) NOT NULL DEFAULT 0,

  `address` varchar(30) NOT NULL,

  `name` varchar(60) DEFAULT NULL,

  `plugged` tinyint(1) NOT NULL DEFAULT 0,

  `graphVisible` tinyint(1) NOT NULL DEFAULT 1,

  `graphRange` tinyint(4) NOT NULL DEFAULT 0,

  `graphAverage` smallint(6) NOT NULL DEFAULT 10,

  `min` float DEFAULT NULL,

  `max` float DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



-- --------------------------------------------------------



--

-- Table structure for table `errors`

--



CREATE TABLE `errors` (

  `errorID` int(11) NOT NULL,

  `errorSourceID` int(11) NOT NULL,

  `sensor` varchar(50) NOT NULL,

  `message` varchar(200) NOT NULL,

  `timestamp` timestamp NOT NULL DEFAULT current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



-- --------------------------------------------------------



--

-- Table structure for table `errorsSource`

--



CREATE TABLE `errorsSource` (

  `errorSourceID` int(11) NOT NULL,

  `source` varchar(50) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



--

-- Dumping data for table `errorsSource`

--



INSERT INTO `errorsSource` (`errorSourceID`, `source`) VALUES

(1, 'DS18B20 Sensors'),

(2, 'AC Outlet');



-- --------------------------------------------------------



--

-- Table structure for table `frontEndData`

--



CREATE TABLE `frontEndData` (

  `frontEndID` int(11) NOT NULL,

  `nextLightSchedule` varchar(18) NOT NULL,

  `currentLightSchedule` varchar(18) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



--

-- Dumping data for table `frontEndData`

--



INSERT INTO `frontEndData` (`frontEndID`, `nextLightSchedule`, `currentLightSchedule`) VALUES

(1, 'lightFri_0', 'lightSun_0');



-- --------------------------------------------------------



--

-- Table structure for table `i2cDevices`

--



CREATE TABLE `i2cDevices` (

  `i2cID` int(11) NOT NULL,

  `i2cDeviceTypeID` int(11) NOT NULL DEFAULT 0,

  `i2cDriverID` int(11) DEFAULT 1,

  `hexAddress` int(11) NOT NULL DEFAULT 0,

  `decAddress` int(11) NOT NULL,

  `plugged_DEL` tinyint(1) NOT NULL DEFAULT 1,

  `enabled` tinyint(1) NOT NULL DEFAULT 1,

  `new` tinyint(1) NOT NULL DEFAULT 1,

  `running` tinyint(1) NOT NULL DEFAULT 1

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



--

-- Dumping data for table `i2cDevices`

--



INSERT INTO `i2cDevices` (`i2cID`, `i2cDeviceTypeID`, `i2cDriverID`, `hexAddress`, `decAddress`, `plugged_DEL`, `enabled`, `new`, `running`) VALUES

(61, 0, 1, 0, 112, 0, 0, 0, 1),

(326, 2, 3, 0, 64, 1, 1, 0, 1);



-- --------------------------------------------------------



--

-- Table structure for table `i2cDeviceTypes`

--



CREATE TABLE `i2cDeviceTypes` (

  `i2cDeviceTypeID` int(11) NOT NULL,

  `type` varchar(30) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



--

-- Dumping data for table `i2cDeviceTypes`

--



INSERT INTO `i2cDeviceTypes` (`i2cDeviceTypeID`, `type`) VALUES

(0, 'not used'),

(1, 'pH'),

(2, 'PCA9685'),

(3, 'Conductivity'),

(4, 'ORP'),

(5, 'Dissolved Oxygen');



-- --------------------------------------------------------



--

-- Table structure for table `lightModeDetails`

--



CREATE TABLE `lightModeDetails` (

  `modeDetailsID` int(11) NOT NULL,

  `modeID` int(11) NOT NULL,

  `pinID` int(11) NOT NULL,

  `lightLevel` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



-- --------------------------------------------------------



--

-- Table structure for table `lightModes`

--



CREATE TABLE `lightModes` (

  `modeID` int(11) NOT NULL,

  `modeNumber` int(11) NOT NULL,

  `modeName` varchar(120) NOT NULL,

  `start` int(11) NOT NULL,

  `end` int(11) NOT NULL,

  `sun` tinyint(1) NOT NULL DEFAULT 1,

  `mon` tinyint(1) NOT NULL DEFAULT 1,

  `tue` tinyint(1) NOT NULL DEFAULT 1,

  `wed` tinyint(1) NOT NULL DEFAULT 1,

  `thu` tinyint(1) NOT NULL DEFAULT 1,

  `fri` tinyint(1) NOT NULL DEFAULT 1,

  `sat` tinyint(1) NOT NULL DEFAULT 1,

  `enabled` tinyint(1) NOT NULL DEFAULT 1

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



-- --------------------------------------------------------



--

-- Table structure for table `pinsAvailable`

--



CREATE TABLE `pinsAvailable` (

  `pinID` int(11) NOT NULL,

  `driverID` int(11) NOT NULL,

  `gpio` int(11) NOT NULL,

  `wiringpi` int(11) DEFAULT NULL,

  `assigned` varchar(5) NOT NULL DEFAULT 'No',

  `pinTypeID` int(11) DEFAULT NULL,

  `name` varchar(70) DEFAULT NULL,

  `portName` varchar(70) DEFAULT NULL,

  `iconID` int(11) DEFAULT NULL,

  `invert` tinyint(1) NOT NULL DEFAULT 0,

  `manual` tinyint(1) NOT NULL DEFAULT 0,

  `manualStatus` tinyint(1) NOT NULL DEFAULT 0

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



--

-- Dumping data for table `pinsAvailable`

--



INSERT INTO `pinsAvailable` (`pinID`, `driverID`, `gpio`, `wiringpi`, `assigned`, `pinTypeID`, `name`, `portName`, `iconID`, `invert`, `manual`, `manualStatus`) VALUES

(79, 2, 5, 21, 'No', 1, 'Power Bar 2 - Outlet 3', 'Power Bar 2 - Outlet 3', 0, 0, 0, 0),

(80, 2, 6, 22, 'No', 1, 'Power Bar 2 - Outlet 2', 'Power Bar 2 - Outlet 2', 0, 0, 0, 0),

(81, 2, 7, 11, 'No', 1, 'Power Bar 2 - Outlet 4', 'Power Bar 2 - Outlet 4', 0, 0, 0, 0),

(82, 2, 8, 10, 'No', 1, 'Power Bar 2 - Outlet 6', 'Power Bar 2 - Outlet 6', 0, 0, 0, 0),

(83, 2, 9, 13, 'No', 1, 'Power Bar 1 - Outlet 1', 'Power Bar 1 - Outlet 1', 0, 0, 0, 0),

(84, 2, 10, 12, 'No', 1, 'Power Bar 1 - Outlet 2', 'Power Bar 1 - Outlet 2', 0, 0, 0, 0),

(85, 2, 11, 14, 'No', 1, 'Power Bar 2 - Outlet 5', 'Power Bar 2 - Outlet 5', 0, 0, 0, 0),

(86, 2, 12, 26, 'No', 1, 'Power Bar 2 - Outlet 7', 'Power Bar 2 - Outlet 7', 0, 0, 0, 0),

(87, 2, 13, 23, 'No', 1, 'Power Bar 2 - Outlet 8', 'Power Bar 2 - Outlet 8', 0, 0, 0, 0),

(88, 2, 14, 15, 'No', 1, 'Power Bar 1 - Outlet 5', 'Power Bar 1 - Outlet 5', 0, 0, 0, 0),

(89, 2, 15, 16, 'No', 1, 'Power Bar 1 - Outlet 4', 'Power Bar 1 - Outlet 4', 0, 0, 0, 0),

(90, 2, 16, 27, 'No', 1, 'Power Bar 2 - Outlet 1', 'Power Bar 2 - Outlet 1', 0, 0, 0, 0),

(91, 2, 17, 0, 'No', 8, 'Sensor Port 1', 'Sensor Port 1', 0, 0, 0, 0),

(92, 2, 18, 1, 'No', NULL, NULL, 'NOT USED', 0, 0, 0, 0),

(93, 2, 19, 24, 'No', 8, 'Sensor Port 3', 'Sensor Port 3', 0, 0, 0, 0),

(94, 2, 20, 28, 'No', 8, 'Sensor Port 4', 'Sensor Port 4', 0, 0, 0, 0),

(95, 2, 21, 29, 'No', 8, 'Sensor Port 6', 'Sensor Port 6', 0, 0, 0, 0),

(96, 2, 22, 3, 'No', 1, 'Power Bar 1 - Outlet 3', 'Power Bar 1 - Outlet 3', 0, 0, 0, 0),

(97, 2, 23, 4, 'No', 1, 'Power Bar 1 - Outlet 6', 'Power Bar 1 - Outlet 6', 0, 0, 0, 0),

(98, 2, 24, 5, 'No', 1, 'Power Bar 1 - Outlet 7', 'Power Bar 1 - Outlet 7', 0, 0, 0, 0),

(99, 2, 25, 6, 'No', 1, 'Power Bar 1 - Outlet 8', 'Power Bar 1 - Outlet 8', 0, 0, 0, 0),

(100, 2, 26, 25, 'No', 8, 'Sensor Port 5', 'Sensor Port 5', 0, 0, 0, 0),

(101, 2, 27, 2, 'No', 8, 'Sensor Port 2', 'Sensor Port 2', 0, 0, 0, 0),

(103, 3, 0, 0, 'No', 11, 'PWM / Analog Port 1', 'PWM / Analog Port 1', 0, 0, 0, 0),

(104, 3, 1, 1, 'No', 11, 'PWM / Analog Port 2', 'PWM / Analog Port 2', 0, 0, 0, 0),

(105, 3, 2, 2, 'No', 11, 'PWM / Analog Port 3', 'PWM / Analog Port 3', 0, 0, 0, 0),

(106, 3, 3, 3, 'No', 11, 'PWM / Analog Port 4', 'PWM / Analog Port 4', 0, 0, 0, 0),

(107, 3, 4, 4, 'No', 11, 'PWM / Analog Port 5', 'PWM / Analog Port 5', 0, 0, 0, 0),

(108, 3, 5, 5, 'No', 11, 'PWM / Analog Port 6', 'PWM / Analog Port 6', 0, 0, 0, 0),

(109, 3, 6, 6, 'No', 11, 'PWM / Analog Port 7', 'PWM / Analog Port 7', 0, 0, 0, 0),

(110, 3, 7, 7, 'No', 11, 'PWM / Analog Port 8', 'PWM / Analog Port 8', 0, 0, 0, 0),

(111, 3, 8, 8, 'No', 13, 'Feeder Port', 'Feeder Port', 0, 0, 0, 0),

(112, 3, 9, 9, 'No', 2, 'DC Port 7', 'DC Port 7', 0, 0, 0, 0),

(113, 3, 10, 10, 'No', 2, 'DC Port 6', 'DC Port 6', 0, 0, 0, 0),

(114, 3, 11, 11, 'No', 2, 'DC Port 5', 'DC Port 5', 0, 0, 0, 0),

(115, 3, 12, 12, 'No', 2, 'DC Port 4', 'DC Port 4', 0, 0, 0, 0),

(116, 3, 13, 13, 'No', 2, 'DC Port 3', 'DC Port 3', 0, 0, 0, 0),

(117, 3, 14, 14, 'No', 2, 'DC Port 2', 'DC Port 2', 0, 0, 0, 0),

(118, 3, 15, 15, 'No', 2, 'DC Port 1', 'DC Port 1', 0, 0, 0, 0);



-- --------------------------------------------------------



--

-- Table structure for table `pinsType`

--



CREATE TABLE `pinsType` (

  `pinTypeID` int(11) NOT NULL,

  `pinTypeName` varchar(75) NOT NULL,

  `pinType` int(11) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;



--

-- Dumping data for table `pinsType`

--



INSERT INTO `pinsType` (`pinTypeID`, `pinTypeName`, `pinType`) VALUES

(1, 'AC Outlet', 0),

(2, 'DC Port', 0),

(3, 'pH Probe', 1),

(4, 'DHT22', 1),

(5, 'DS18B20', 1),

(6, 'Non-Contact Sensor', 1),

(7, 'Optical Sensor', 1),

(8, 'Float Switch', 1),

(9, 'Other Sensor', 1),

(10, 'Flow Meter', 1),

(11, 'Light', 0),

(12, 'Dosing Pump', 0),

(13, 'Auto Feeder', 0);



-- --------------------------------------------------------



--

-- Table structure for table `probes`

--



CREATE TABLE `probes` (

  `probeID` int(11) NOT NULL,

  `name` varchar(60) DEFAULT NULL,

  `address` int(11) NOT NULL,

  `plugged` tinyint(4) NOT NULL,

  `graphVisible` tinyint(4) NOT NULL DEFAULT 1,

  `graphRange` tinyint(4) NOT NULL DEFAULT 2,

  `graphAverage` smallint(6) NOT NULL DEFAULT 10,

  `min` float NOT NULL DEFAULT 0,

  `max` float NOT NULL DEFAULT 0,

  `buffer1` double NOT NULL DEFAULT 7,

  `buffer2` double NOT NULL DEFAULT 10,

  `cal1` double NOT NULL DEFAULT 7,

  `cal2` double NOT NULL DEFAULT 10,

  `calType` tinyint(4) NOT NULL DEFAULT 1

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



-- --------------------------------------------------------



--

-- Table structure for table `rules`

--



CREATE TABLE `rules` (

  `ruleID` int(11) NOT NULL,

  `ruleTypeID` int(11) NOT NULL,

  `ruleName` varchar(255) DEFAULT NULL,

  `email` tinyint(1) DEFAULT 0,

  `alert` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Dashboard Alerts',

  `enabled` tinyint(1) NOT NULL DEFAULT 1

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



-- --------------------------------------------------------



--

-- Table structure for table `rulesEquipment`

--



CREATE TABLE `rulesEquipment` (

  `rulesEquipmentID` int(11) NOT NULL,

  `ruleID` int(11) NOT NULL,

  `equipmentPinID` int(11) NOT NULL COMMENT 'pinID from pinsAvailable',

  `equipmentOffOn` tinyint(1) NOT NULL,

  `switchDelay` int(11) NOT NULL DEFAULT 0 COMMENT 'delay until device is switched',

  `nextDoseDelay` int(11) NOT NULL DEFAULT 0 COMMENT 'For Dosing Pumps - minutes',

  `equipIgnore` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'ignore equipment if schedule is running'

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



-- --------------------------------------------------------



--

-- Table structure for table `rulesSensors`

--



CREATE TABLE `rulesSensors` (

  `rulesSensorID` int(11) NOT NULL,

  `ruleID` int(11) NOT NULL,

  `sensorPinID` int(11) DEFAULT NULL COMMENT 'pinID from pinsAvailable',

  `sensorAddress` varchar(18) DEFAULT NULL,

  `sensorDataType` smallint(6) NOT NULL DEFAULT 0,

  `sensorValue` double NOT NULL,

  `lessGreater` smallint(1) NOT NULL,

  `stabilitySeconds` int(11) NOT NULL DEFAULT 1,

  `logic` smallint(6) NOT NULL DEFAULT 0 COMMENT 'None, AND, OR'

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



-- --------------------------------------------------------



--

-- Table structure for table `rulesType`

--



CREATE TABLE `rulesType` (

  `ruleTypeID` int(11) NOT NULL,

  `ruleType` varchar(50) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



--

-- Dumping data for table `rulesType`

--



INSERT INTO `rulesType` (`ruleTypeID`, `ruleType`) VALUES

(1, 'Schedule'),

(2, 'Sensor'),

(3, 'Manual');



-- --------------------------------------------------------



--

-- Table structure for table `schedules`

--



CREATE TABLE `schedules` (

  `scheduleID` int(11) NOT NULL,

  `scheduleTypeID` int(11) NOT NULL,

  `ruleID` int(11) DEFAULT NULL,

  `pinID` int(11) DEFAULT NULL,

  `offOn` tinyint(1) NOT NULL,

  `schName` varchar(120) NOT NULL,

  `start` int(11) NOT NULL,

  `end_DELETE` int(11) DEFAULT NULL,

  `sun` tinyint(1) NOT NULL DEFAULT 1,

  `mon` tinyint(1) NOT NULL DEFAULT 1,

  `tue` tinyint(1) NOT NULL DEFAULT 1,

  `wed` tinyint(1) NOT NULL DEFAULT 1,

  `thu` tinyint(1) NOT NULL DEFAULT 1,

  `fri` tinyint(1) NOT NULL DEFAULT 1,

  `sat` tinyint(1) NOT NULL DEFAULT 1,

  `repeatDays` smallint(6) NOT NULL DEFAULT 0,

  `disableMaint` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'disabled for maintenance',

  `enabled` int(11) NOT NULL DEFAULT 1,

  `schEmail` tinyint(4) NOT NULL DEFAULT 0,

  `schAlert` tinyint(4) NOT NULL DEFAULT 0,

  `dateCreated` date NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



-- --------------------------------------------------------



--

-- Table structure for table `scheduleType`

--



CREATE TABLE `scheduleType` (

  `scheduleTypeID` int(11) NOT NULL,

  `type` varchar(50) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



--

-- Dumping data for table `scheduleType`

--



INSERT INTO `scheduleType` (`scheduleTypeID`, `type`) VALUES

(1, 'AC Outlet'),

(2, 'DC Port'),

(3, 'Dosing'),

(4, 'Feeder'),

(5, 'Custom Rule'),

(6, 'Custom Mode');



-- --------------------------------------------------------



--

-- Table structure for table `systemSettings`

--



CREATE TABLE `systemSettings` (

  `systemSettingID` int(11) NOT NULL,

  `userID` int(11) NOT NULL,

  `boardTypeID` int(11) NOT NULL,

  `tempCorF` tinyint(1) NOT NULL DEFAULT 0,

  `timeFormat` double NOT NULL DEFAULT 1,

  `outletSortID` tinyint(4) NOT NULL DEFAULT 1,

  `dcSortID` tinyint(4) NOT NULL DEFAULT 1,

  `scheduleTabSelected` tinyint(4) NOT NULL DEFAULT 0,

  `scheduleSortID` smallint(6) NOT NULL DEFAULT 0,

  `scheduleSortOrder` tinyint(1) NOT NULL DEFAULT 0,

  `emailEnabled` tinyint(4) NOT NULL DEFAULT 0,

  `smtpServer` varchar(60) DEFAULT NULL,

  `smtpPort` smallint(6) DEFAULT NULL,

  `smtpUser` varchar(60) DEFAULT NULL,

  `smtpPass` varchar(75) DEFAULT NULL,

  `smtpProvider` smallint(6) NOT NULL DEFAULT 1,

  `autoUpdate` tinyint(4) NOT NULL DEFAULT 1,

  `version` float NOT NULL,

  `versionLatest` float NOT NULL,

  `updateRan` tinyint(4) NOT NULL DEFAULT 0,

  `supportID` int(11) DEFAULT 0

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



--

-- Dumping data for table `systemSettings`

--



INSERT INTO `systemSettings` (`systemSettingID`, `userID`, `boardTypeID`, `tempCorF`, `timeFormat`, `outletSortID`, `dcSortID`, `scheduleTabSelected`, `scheduleSortID`, `scheduleSortOrder`, `emailEnabled`, `smtpServer`, `smtpPort`, `smtpUser`, `smtpPass`, `smtpProvider`, `autoUpdate`, `version`, `versionLatest`, `updateRan`, `supportID`) VALUES

(1, 1, 1, 1, 1, 1, 1, 0, 2, 1, 0, 'smtp.office365.com', 587, '', '', 0, 0, 6, 6, 0, 0);



-- --------------------------------------------------------



--

-- Table structure for table `users`

--



CREATE TABLE `users` (

  `userID` int(11) NOT NULL,

  `username` varchar(50) NOT NULL,

  `password` varchar(255) NOT NULL,

  `adminEmail` varchar(80) DEFAULT NULL,

  `email1` varchar(80) DEFAULT NULL,

  `email2` varchar(80) DEFAULT 'NULL',

  `email2Enabled` tinyint(1) NOT NULL DEFAULT 0,

  `email3` varchar(80) DEFAULT 'NULL',

  `email3Enabled` tinyint(1) NOT NULL DEFAULT 0,

  `firstRun` tinyint(1) NOT NULL DEFAULT 0

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



--

-- Dumping data for table `users`

--



INSERT INTO `users` (`userID`, `username`, `password`, `adminEmail`, `email1`, `email2`, `email2Enabled`, `email3`, `email3Enabled`, `firstRun`) VALUES

(1, 'Robo-Tank', '$2y$10$prs2O2elGMJHCEIAgOCs.uvMJ9UObZc/HHtw/TJJ0/q59zbZOGy2C', '', '', '', 0, '', 0, 0);



-- --------------------------------------------------------



--

-- Table structure for table `widgets`

--



CREATE TABLE `widgets` (

  `id` int(11) NOT NULL,

  `widgetID` int(11) NOT NULL,

  `visible` tinyint(1) NOT NULL,

  `width` float NOT NULL,

  `height` float NOT NULL,

  `screenLocation` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



--

-- Dumping data for table `widgets`

--



INSERT INTO `widgets` (`id`, `widgetID`, `visible`, `width`, `height`, `screenLocation`) VALUES

(1, 0, 1, 1113.75, 454, 6),

(2, 1, 1, 1017, 339, 2),

(3, 2, 0, 660, 430, 5),

(4, 3, 1, 1240, 383, 4),

(5, 4, 1, 797, 287, 0),

(6, 5, 1, 302, 290, 1),

(7, 6, 1, 520, 294, 3),

(8, 7, 1, 0, 0, 10),

(9, 8, 0, 228, 310, 12),

(10, 9, 1, 1034, 229, 11),

(11, 10, 0, 1167, 1170, 7),

(12, 11, 1, 1050, 336, 9),

(13, 12, 0, 1426, 522, 13),

(14, 13, 1, 521, 227, 14),

(15, 14, 0, 300, 300, 8),

(16, 15, 0, 300, 300, 15),

(17, 16, 0, 300, 300, 16),

(18, 17, 1, 300, 300, 17);



--

-- Indexes for dumped tables

--



--

-- Indexes for table `button_labels`

--

ALTER TABLE `button_labels`

  ADD PRIMARY KEY (`buttonID`);



--

-- Indexes for table `dateTimeSync`

--

ALTER TABLE `dateTimeSync`

  ADD PRIMARY KEY (`syncID`);



--

-- Indexes for table `dosingPumps`

--

ALTER TABLE `dosingPumps`

  ADD PRIMARY KEY (`doseID`),

  ADD KEY `pinID` (`dosePinID`);



--

-- Indexes for table `drivers`

--

ALTER TABLE `drivers`

  ADD PRIMARY KEY (`driverID`);



--

-- Indexes for table `ds18b20`

--

ALTER TABLE `ds18b20`

  ADD PRIMARY KEY (`ds18b20ID`),

  ADD UNIQUE KEY `address` (`address`);



--

-- Indexes for table `errors`

--

ALTER TABLE `errors`

  ADD PRIMARY KEY (`errorID`),

  ADD KEY `errorSourceID` (`errorSourceID`);



--

-- Indexes for table `errorsSource`

--

ALTER TABLE `errorsSource`

  ADD PRIMARY KEY (`errorSourceID`);



--

-- Indexes for table `frontEndData`

--

ALTER TABLE `frontEndData`

  ADD PRIMARY KEY (`frontEndID`);



--

-- Indexes for table `i2cDevices`

--

ALTER TABLE `i2cDevices`

  ADD PRIMARY KEY (`i2cID`),

  ADD UNIQUE KEY `decAddress` (`decAddress`),

  ADD KEY `i2cDeviceTypeID` (`i2cDeviceTypeID`),

  ADD KEY `i2cDriverID` (`i2cDriverID`);



--

-- Indexes for table `i2cDeviceTypes`

--

ALTER TABLE `i2cDeviceTypes`

  ADD PRIMARY KEY (`i2cDeviceTypeID`);



--

-- Indexes for table `lightModeDetails`

--

ALTER TABLE `lightModeDetails`

  ADD PRIMARY KEY (`modeDetailsID`),

  ADD KEY `modeID` (`modeID`),

  ADD KEY `pinID` (`pinID`);



--

-- Indexes for table `lightModes`

--

ALTER TABLE `lightModes`

  ADD PRIMARY KEY (`modeID`);



--

-- Indexes for table `pinsAvailable`

--

ALTER TABLE `pinsAvailable`

  ADD PRIMARY KEY (`pinID`),

  ADD KEY `driverID` (`driverID`),

  ADD KEY `equipmentID` (`pinTypeID`);



--

-- Indexes for table `pinsType`

--

ALTER TABLE `pinsType`

  ADD PRIMARY KEY (`pinTypeID`);



--

-- Indexes for table `probes`

--

ALTER TABLE `probes`

  ADD PRIMARY KEY (`probeID`),

  ADD KEY `address` (`address`);



--

-- Indexes for table `rules`

--

ALTER TABLE `rules`

  ADD PRIMARY KEY (`ruleID`),

  ADD KEY `ruleTypeID` (`ruleTypeID`);



--

-- Indexes for table `rulesEquipment`

--

ALTER TABLE `rulesEquipment`

  ADD PRIMARY KEY (`rulesEquipmentID`),

  ADD KEY `ruleID` (`ruleID`),

  ADD KEY `equipmentPinID` (`equipmentPinID`);



--

-- Indexes for table `rulesSensors`

--

ALTER TABLE `rulesSensors`

  ADD PRIMARY KEY (`rulesSensorID`),

  ADD KEY `ruleID` (`ruleID`),

  ADD KEY `sensorPinID` (`sensorPinID`);



--

-- Indexes for table `rulesType`

--

ALTER TABLE `rulesType`

  ADD PRIMARY KEY (`ruleTypeID`);



--

-- Indexes for table `schedules`

--

ALTER TABLE `schedules`

  ADD PRIMARY KEY (`scheduleID`),

  ADD KEY `scheduleTypeID` (`scheduleTypeID`),

  ADD KEY `pinID` (`pinID`),

  ADD KEY `ruleID` (`ruleID`);



--

-- Indexes for table `scheduleType`

--

ALTER TABLE `scheduleType`

  ADD PRIMARY KEY (`scheduleTypeID`);



--

-- Indexes for table `systemSettings`

--

ALTER TABLE `systemSettings`

  ADD PRIMARY KEY (`systemSettingID`),

  ADD KEY `boardTypeID` (`boardTypeID`),

  ADD KEY `userID` (`userID`);



--

-- Indexes for table `users`

--

ALTER TABLE `users`

  ADD PRIMARY KEY (`userID`),

  ADD UNIQUE KEY `username` (`username`);



--

-- Indexes for table `widgets`

--

ALTER TABLE `widgets`

  ADD PRIMARY KEY (`id`);



--

-- AUTO_INCREMENT for dumped tables

--



--

-- AUTO_INCREMENT for table `button_labels`

--

ALTER TABLE `button_labels`

  MODIFY `buttonID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--

-- AUTO_INCREMENT for table `dateTimeSync`

--

ALTER TABLE `dateTimeSync`

  MODIFY `syncID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--

-- AUTO_INCREMENT for table `dosingPumps`

--

ALTER TABLE `dosingPumps`

  MODIFY `doseID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--

-- AUTO_INCREMENT for table `drivers`

--

ALTER TABLE `drivers`

  MODIFY `driverID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--

-- AUTO_INCREMENT for table `ds18b20`

--

ALTER TABLE `ds18b20`

  MODIFY `ds18b20ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=248;

--

-- AUTO_INCREMENT for table `errors`

--

ALTER TABLE `errors`

  MODIFY `errorID` int(11) NOT NULL AUTO_INCREMENT;

--

-- AUTO_INCREMENT for table `errorsSource`

--

ALTER TABLE `errorsSource`

  MODIFY `errorSourceID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--

-- AUTO_INCREMENT for table `frontEndData`

--

ALTER TABLE `frontEndData`

  MODIFY `frontEndID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--

-- AUTO_INCREMENT for table `i2cDevices`

--

ALTER TABLE `i2cDevices`

  MODIFY `i2cID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=376;

--

-- AUTO_INCREMENT for table `i2cDeviceTypes`

--

ALTER TABLE `i2cDeviceTypes`

  MODIFY `i2cDeviceTypeID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--

-- AUTO_INCREMENT for table `lightModeDetails`

--

ALTER TABLE `lightModeDetails`

  MODIFY `modeDetailsID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=647;

--

-- AUTO_INCREMENT for table `lightModes`

--

ALTER TABLE `lightModes`

  MODIFY `modeID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=116;

--

-- AUTO_INCREMENT for table `pinsAvailable`

--

ALTER TABLE `pinsAvailable`

  MODIFY `pinID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=377;

--

-- AUTO_INCREMENT for table `pinsType`

--

ALTER TABLE `pinsType`

  MODIFY `pinTypeID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--

-- AUTO_INCREMENT for table `probes`

--

ALTER TABLE `probes`

  MODIFY `probeID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--

-- AUTO_INCREMENT for table `rules`

--

ALTER TABLE `rules`

  MODIFY `ruleID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--

-- AUTO_INCREMENT for table `rulesEquipment`

--

ALTER TABLE `rulesEquipment`

  MODIFY `rulesEquipmentID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91;

--

-- AUTO_INCREMENT for table `rulesSensors`

--

ALTER TABLE `rulesSensors`

  MODIFY `rulesSensorID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--

-- AUTO_INCREMENT for table `rulesType`

--

ALTER TABLE `rulesType`

  MODIFY `ruleTypeID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--

-- AUTO_INCREMENT for table `schedules`

--

ALTER TABLE `schedules`

  MODIFY `scheduleID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;

--

-- AUTO_INCREMENT for table `scheduleType`

--

ALTER TABLE `scheduleType`

  MODIFY `scheduleTypeID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--

-- AUTO_INCREMENT for table `systemSettings`

--

ALTER TABLE `systemSettings`

  MODIFY `systemSettingID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--

-- AUTO_INCREMENT for table `users`

--

ALTER TABLE `users`

  MODIFY `userID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--

-- AUTO_INCREMENT for table `widgets`

--

ALTER TABLE `widgets`

  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--

-- Constraints for dumped tables

--



--

-- Constraints for table `dosingPumps`

--

ALTER TABLE `dosingPumps`

  ADD CONSTRAINT `dosingPumps_ibfk_1` FOREIGN KEY (`dosePinID`) REFERENCES `pinsAvailable` (`pinID`) ON DELETE CASCADE ON UPDATE CASCADE;



--

-- Constraints for table `errors`

--

ALTER TABLE `errors`

  ADD CONSTRAINT `errors_ibfk_1` FOREIGN KEY (`errorSourceID`) REFERENCES `errorsSource` (`errorSourceID`) ON DELETE CASCADE ON UPDATE CASCADE;



--

-- Constraints for table `i2cDevices`

--

ALTER TABLE `i2cDevices`

  ADD CONSTRAINT `i2cDevices_ibfk_1` FOREIGN KEY (`i2cDeviceTypeID`) REFERENCES `i2cDeviceTypes` (`i2cDeviceTypeID`) ON DELETE CASCADE ON UPDATE CASCADE,

  ADD CONSTRAINT `i2cDevices_ibfk_2` FOREIGN KEY (`i2cDriverID`) REFERENCES `drivers` (`driverID`) ON DELETE CASCADE ON UPDATE CASCADE;



--

-- Constraints for table `lightModeDetails`

--

ALTER TABLE `lightModeDetails`

  ADD CONSTRAINT `lightModeDetails_ibfk_1` FOREIGN KEY (`modeID`) REFERENCES `lightModes` (`modeID`) ON DELETE CASCADE ON UPDATE CASCADE,

  ADD CONSTRAINT `lightModeDetails_ibfk_2` FOREIGN KEY (`pinID`) REFERENCES `pinsAvailable` (`pinID`) ON DELETE NO ACTION ON UPDATE NO ACTION;



--

-- Constraints for table `pinsAvailable`

--

ALTER TABLE `pinsAvailable`

  ADD CONSTRAINT `pinsAvailable_ibfk_1` FOREIGN KEY (`driverID`) REFERENCES `drivers` (`driverID`) ON DELETE CASCADE ON UPDATE CASCADE,

  ADD CONSTRAINT `pinsAvailable_ibfk_2` FOREIGN KEY (`pinTypeID`) REFERENCES `pinsType` (`pinTypeID`);



--

-- Constraints for table `probes`

--

ALTER TABLE `probes`

  ADD CONSTRAINT `probes_ibfk_1` FOREIGN KEY (`address`) REFERENCES `i2cDevices` (`decAddress`) ON DELETE CASCADE ON UPDATE CASCADE;



--

-- Constraints for table `rules`

--

ALTER TABLE `rules`

  ADD CONSTRAINT `rules_ibfk_1` FOREIGN KEY (`ruleTypeID`) REFERENCES `rulesType` (`ruleTypeID`) ON DELETE CASCADE ON UPDATE CASCADE;



--

-- Constraints for table `rulesEquipment`

--

ALTER TABLE `rulesEquipment`

  ADD CONSTRAINT `rulesEquipment_ibfk_1` FOREIGN KEY (`equipmentPinID`) REFERENCES `pinsAvailable` (`pinID`) ON DELETE CASCADE ON UPDATE CASCADE,

  ADD CONSTRAINT `rulesEquipment_ibfk_2` FOREIGN KEY (`ruleID`) REFERENCES `rules` (`ruleID`) ON DELETE CASCADE ON UPDATE CASCADE;



--

-- Constraints for table `rulesSensors`

--

ALTER TABLE `rulesSensors`

  ADD CONSTRAINT `rulesSensors_ibfk_1` FOREIGN KEY (`ruleID`) REFERENCES `rules` (`ruleID`) ON DELETE CASCADE ON UPDATE CASCADE,

  ADD CONSTRAINT `rulesSensors_ibfk_2` FOREIGN KEY (`sensorPinID`) REFERENCES `pinsAvailable` (`pinID`) ON DELETE CASCADE ON UPDATE CASCADE;



--

-- Constraints for table `schedules`

--

ALTER TABLE `schedules`

  ADD CONSTRAINT `schedules_ibfk_1` FOREIGN KEY (`scheduleTypeID`) REFERENCES `scheduleType` (`scheduleTypeID`) ON DELETE CASCADE ON UPDATE CASCADE,

  ADD CONSTRAINT `schedules_ibfk_2` FOREIGN KEY (`pinID`) REFERENCES `pinsAvailable` (`pinID`) ON DELETE CASCADE ON UPDATE CASCADE,

  ADD CONSTRAINT `schedules_ibfk_3` FOREIGN KEY (`ruleID`) REFERENCES `rules` (`ruleID`) ON DELETE CASCADE ON UPDATE CASCADE;



--

-- Constraints for table `systemSettings`

--

ALTER TABLE `systemSettings`

  ADD CONSTRAINT `systemSettings_ibfk_2` FOREIGN KEY (`userID`) REFERENCES `users` (`userID`) ON DELETE CASCADE ON UPDATE CASCADE;



/*!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 */;