-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 01, 2023 at 02:16 PM
-- Server version: 10.6.14-MariaDB-cll-lve
-- PHP Version: 8.1.16

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
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: `galac350_PiratePete`
--

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

--
-- Table structure for table `bingo_calls`
--

CREATE TABLE `bingo_calls` (
  `callId` int(2) NOT NULL,
  `traditional` varchar(200) NOT NULL,
  `scifi` varchar(200) NOT NULL,
  `pirate` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bingo_calls`
--

INSERT INTO `bingo_calls` (`callId`, `traditional`, `scifi`, `pirate`) VALUES
(1, 'Kelly\'s eye', '', ''),
(2, 'One little duck', '', ''),
(3, 'Cup of tea', '', ''),
(4, 'Knock at the door', '', ''),
(5, 'Man alive', '', ''),
(6, 'Half a dozen', '', ''),
(7, 'Lucky number', '', ''),
(8, 'Garden gate', '', ''),
(9, 'Doctor\'s orders', '', ''),
(10, 'The PM\'s den', '', ''),
(11, 'Those lovely legs it\'s Legs eleven', '', ''),
(12, 'One dozen', '', ''),
(13, 'Unlucky for some', '', ''),
(14, 'It\'s Valentines day', '', ''),
(15, 'Young and keen', '', ''),
(16, 'Never been kissed / Sweet', '', ''),
(17, 'Dancing Queen', '', ''),
(18, 'Coming of age', '', ''),
(19, 'Goodbye teens!', '', ''),
(20, 'One score', '', ''),
(21, 'Key to the door', '', ''),
(22, 'Two little ducks', '', ''),
(23, 'Thee and me', '', ''),
(24, 'Two dozen', '', ''),
(25, 'Duck and dive', '', ''),
(26, 'Pick and mix', '', ''),
(27, 'Duck with a crutch', '', ''),
(28, 'In a state', '', ''),
(29, 'Rise and shine', '', ''),
(30, 'Dirty Gertie', '', ''),
(31, 'Get up and run', '', ''),
(32, 'Buckle my shoe', '', ''),
(33, 'Dirty Knee', '', ''),
(34, 'Ask for more', '', ''),
(35, 'Jump and jive', '', ''),
(36, 'Three dozen', '', ''),
(37, 'More than 11', '', ''),
(38, 'Christmas cake', '', ''),
(39, 'All the steps', '', ''),
(40, 'Life begins', '', ''),
(41, 'Time for fun', '', ''),
(42, 'Winnie the Pooh', '', ''),
(43, 'Down on your knees', '', ''),
(44, 'Droopy draws', '', ''),
(45, 'I can\'t believe my eyes', '', ''),
(46, 'Up to tricks', '', ''),
(47, 'Four and seven', '', ''),
(48, 'Four dozen', '', ''),
(49, 'PC', '', ''),
(50, 'It\'s a bullseye! / Half a century', '', ''),
(51, 'Tweak of the thumb', '', ''),
(52, 'Deck of cards / Weeks in a year', '', ''),
(53, 'Here comes Herbie! / Stuck in a tree', '', ''),
(54, 'Man at the door', '', ''),
(55, 'All the fives', '', ''),
(56, 'Was she worth it?', '', ''),
(57, 'Heinz varieties', '', ''),
(58, 'Make them wait', '', ''),
(59, 'The Brighton Line', '', ''),
(60, 'Grandma\'s getting frisky / Five dozen', '', ''),
(61, 'Bakers bun', '', ''),
(62, 'Tickety boo / Turn the screw', '', ''),
(63, 'Tickle me', '', ''),
(64, 'Red raw', '', ''),
(65, 'Six and five', '', ''),
(66, 'Clickety click', '', ''),
(67, 'Stairway to heaven', '', ''),
(68, 'Pick a mate / Saving grace', '', ''),
(69, 'Anyway up / Meal for 2', '', ''),
(70, 'Three score and 10', '', ''),
(71, 'Bang on the drum', '', ''),
(72, 'Six dozen', '', ''),
(73, 'Queen bee / Under the tree', '', ''),
(74, 'Hit the floor / Candy store', '', ''),
(75, 'Strive and strive', '', ''),
(76, 'Trombones', '', ''),
(77, 'Two crutches / Sunset strip', '', ''),
(78, '39 more steps', '', ''),
(79, 'One more time', '', ''),
(80, 'Top of the shop', '', '');

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

--
-- Table structure for table `bingo_cards`
--

CREATE TABLE `bingo_cards` (
  `cid` int(11) NOT NULL,
  `playerID` int(11) NOT NULL,
  `red` varchar(16) NOT NULL,
  `green` varchar(16) NOT NULL,
  `blue` varchar(16) NOT NULL,
  `yellow` varchar(16) NOT NULL,
  `gameID` int(11) NOT NULL,
  `requestDate` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `bingo_games`
--

CREATE TABLE `bingo_games` (
  `gid` int(11) NOT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `startTime` datetime NOT NULL DEFAULT '9999-12-31 00:00:00',
  `cardTotal` int(11) NOT NULL DEFAULT 0,
  `gameType` tinyint(1) NOT NULL DEFAULT 1,
  `type1Winner` varchar(150) DEFAULT NULL,
  `type2Winner` varchar(150) DEFAULT NULL,
  `type4Winner` varchar(150) DEFAULT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT 0,
  `numCalls` int(3) NOT NULL DEFAULT 0,
  `numbers` varchar(300) NOT NULL,
  `playerShouts` varchar(400) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `players`
--

CREATE TABLE `players` (
  `pid` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `sound` varchar(30) NOT NULL,
  `soundFile` varchar(30) NOT NULL,
  `sessionID` varchar(130) NOT NULL,
  `lastTime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sounds`
--

CREATE TABLE `sounds` (
  `sid` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `fileName` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `sounds`
--

INSERT INTO `sounds` (`sid`, `name`, `fileName`) VALUES
(1, 'Airhorn', 'airhorn'),
(2, 'Bingo', 'bingo');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bingo_calls`
--
ALTER TABLE `bingo_calls`
  ADD UNIQUE KEY `callId` (`callId`);

--
-- Indexes for table `bingo_cards`
--
ALTER TABLE `bingo_cards`
  ADD PRIMARY KEY (`cid`);

--
-- Indexes for table `bingo_games`
--
ALTER TABLE `bingo_games`
  ADD PRIMARY KEY (`gid`);

--
-- Indexes for table `players`
--
ALTER TABLE `players`
  ADD PRIMARY KEY (`pid`);

--
-- Indexes for table `sounds`
--
ALTER TABLE `sounds`
  ADD PRIMARY KEY (`sid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bingo_cards`
--
ALTER TABLE `bingo_cards`
  MODIFY `cid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;

--
-- AUTO_INCREMENT for table `bingo_games`
--
ALTER TABLE `bingo_games`
  MODIFY `gid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `players`
--
ALTER TABLE `players`
  MODIFY `pid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `sounds`
--
ALTER TABLE `sounds`
  MODIFY `sid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

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