-- phpMyAdmin SQL Dump
-- version 5.1.1deb3+bionic1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Nov 10, 2022 at 03:08 AM
-- Server version: 10.1.48-MariaDB-0ubuntu0.18.04.1
-- PHP Version: 7.4.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

--
-- Database: `nor20702_booking`
--

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

--
-- Table structure for table `pricelevel`
--

CREATE TABLE `pricelevel` (
  `id` int(11) NOT NULL,
  `level` varchar(20) NOT NULL,
  `factor` decimal(10,6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `pricelevel`
--

INSERT INTO `pricelevel` (`id`, `level`, `factor`) VALUES
(1, '0', '1.000000'),
(2, '5', '1.052632'),
(3, '10', '1.111111'),
(4, '15', '1.176470'),
(5, '20', '1.250000'),
(6, '25', '1.333300');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `pricelevel`
--
ALTER TABLE `pricelevel`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `pricelevel`
--
ALTER TABLE `pricelevel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

ALTER TABLE `user` ADD `pricelevelid` INT NOT NULL DEFAULT '1' AFTER `postcode`;


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

--
-- Table structure for table `account_wastetype`
--

CREATE TABLE `account_wastetype` (
  `id` int(11) NOT NULL,
  `name` varchar(64) NOT NULL,
  `list_order` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `account_wastetype`
--

INSERT INTO `account_wastetype` (`id`, `name`, `list_order`) VALUES
(1, 'Clean Concrete', 1),
(2, 'Clean Inert', 2),
(3, 'Dirty Inert', 3),
(4, 'Green Waste', 4),
(5, 'Metal Only', 5),
(6, 'Mixed Waste', 6);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `account_wastetype`
--
ALTER TABLE `account_wastetype`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `account_wastetype`
--
ALTER TABLE `account_wastetype`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;



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

--
-- Table structure for table `account_wastetype_pricing`
--

CREATE TABLE `account_wastetype_pricing` (
  `id` int(11) NOT NULL,
  `wastetypeid` int(64) NOT NULL,
  `minweight` int(11) NOT NULL,
  `maxweight` int(11) NOT NULL,
  `pricebelow` decimal(10,2) NOT NULL,
  `price` decimal(10,4) NOT NULL,
  `list_order` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `account_wastetype_pricing`
--

INSERT INTO `account_wastetype_pricing` (`id`, `wastetypeid`, `minweight`, `maxweight`, `pricebelow`, `price`, `list_order`) VALUES
(1, 1, 0, 99999, '0.00', '0.0550', 1),
(2, 2, 0, 99999, '0.00', '0.0220', 2),
(3, 3, 0, 99999, '0.00', '0.0330', 3),
(4, 4, 0, 99999, '0.00', '0.0660', 4),
(5, 5, 0, 99999, '0.00', '0.0000', 5),
(6, 6, 0, 350, '0.00', '0.1650', 6),
(8, 6, 350, 650, '57.75', '0.0330', 7),
(9, 6, 650, 99999, '69.55', '0.0110', 8);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `account_wastetype_pricing`
--
ALTER TABLE `account_wastetype_pricing`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `account_wastetype_pricing`
--
ALTER TABLE `account_wastetype_pricing`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;





--
-- Table structure for table `dump`
--

CREATE TABLE `dump` (
  `id` int(11) NOT NULL,
  `name` varchar(256) NOT NULL,
  `list_order` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dump`
--

INSERT INTO `dump` (`id`, `name`, `list_order`) VALUES
(1, 'Barron', 1),
(2, 'CRC Portsmith', 2),
(3, 'Medalfield', 3),
(4, 'Northern Sands', 4),
(5, 'Norhire', 5);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `dump`
--
ALTER TABLE `dump`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `dump`
--
ALTER TABLE `dump`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

ALTER TABLE `skip` ADD `loadfactor` DECIMAL(10,4) NOT NULL DEFAULT '1' AFTER `weighting`;

--
-- Table structure for table `truckcost`
--

CREATE TABLE `truckcost` (
  `id` int(11) NOT NULL,
  `name` varchar(256) NOT NULL,
  `cost` int(11) NOT NULL,
  `list_order` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `truckcost`
--

INSERT INTO `truckcost` (`id`, `name`, `cost`, `list_order`) VALUES
(1, 'Single Drive Skip', 210, 1),
(2, 'Boogie Drive Skip', 285, 2),
(3, 'Twin Steer Hook', 410, 3);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `truckcost`
--
ALTER TABLE `truckcost`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `truckcost`
--
ALTER TABLE `truckcost`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;


ALTER TABLE `job` ADD `dumpdate` DATE NOT NULL DEFAULT '0000-00-00' AFTER `pudate`;

ALTER TABLE `job` ADD `wastetypeid` INT NOT NULL DEFAULT '0' AFTER `skipid`, ADD `weight` INT NOT NULL DEFAULT '0' AFTER `wastetypeid`, ADD `dumpid` INT NOT NULL DEFAULT '0' AFTER `weight`, ADD `weighbridgedocket` VARCHAR(128) NULL DEFAULT NULL AFTER `dumpid`;



COMMIT;