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

START TRANSACTION;



--
-- Database: `db776493104`
--
CREATE DATABASE IF NOT EXISTS `db776493104` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `db776493104`;

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

--
-- Table structure for table `booking_table`
--

CREATE TABLE `booking_table` (
  `id` int(11) NOT NULL,
  `training` varchar(150) NOT NULL,
  `month` varchar(250) NOT NULL,
  `training_dates` date NOT NULL,
  `city` varchar(250) NOT NULL,
  `address` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `booking_table`
--

INSERT INTO `booking_table` (`id`, `training`, `month`, `training_dates`, `city`, `address`) VALUES
(7, 'Door supervisor training', 'January', '2019-03-01', 'Leeds', 'test  ');

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

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(11) NOT NULL,
  `service_key` varchar(500) COLLATE latin1_general_ci NOT NULL,
  `client_key` varchar(500) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `payment`
--

INSERT INTO `payment` (`id`, `service_key`, `client_key`) VALUES
(1, 'T_S_838c14e3-d256-4fcf-9f08-0d1625746de3', 'T_C_ad539957-ab3d-42c7-bc82-e43cf2e5de41');

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

--
-- Table structure for table `training`
--

CREATE TABLE `training` (
  `id` int(11) NOT NULL,
  `availability` varchar(100) NOT NULL,
  `month` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `training` varchar(150) NOT NULL,
  `training_dates` varchar(200) NOT NULL,
  `fees` varchar(100) NOT NULL,
  `address` varchar(300) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `delete_dates` date NOT NULL,
  `urls` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `training`
--
ALTER TABLE `training`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

