-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 22, 2026 at 03:59 PM
-- Server version: 10.11.15-MariaDB-cll-lve
-- PHP Version: 8.3.30

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: `player1_ck-app`
--

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

--
-- Table structure for table `history`
--

CREATE TABLE `history` (
  `record` int(3) NOT NULL,
  `date` varchar(50) NOT NULL,
  `location` varchar(50) NOT NULL,
  `machine` varchar(40) NOT NULL,
  `gross_sales` varchar(10) NOT NULL,
  `commission` varchar(10) NOT NULL,
  `Payout` int(2) DEFAULT NULL,
  `paid` varchar(1) NOT NULL,
  `coin_count` int(10) DEFAULT NULL,
  `prize_count` int(10) DEFAULT NULL,
  `credit` varchar(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `Name` varchar(50) NOT NULL,
  `Address 1` varchar(50) DEFAULT NULL,
  `Address 2` varchar(50) DEFAULT NULL,
  `City` varchar(50) NOT NULL,
  `State` varchar(2) NOT NULL,
  `ZIP` varchar(10) NOT NULL,
  `Contact` varchar(30) NOT NULL,
  `Email` varchar(50) NOT NULL,
  `Phone 1` varchar(15) DEFAULT NULL,
  `Phone 1 Type` enum('Cell','Home','Business','Other') DEFAULT NULL,
  `Phone 2` varchar(15) DEFAULT NULL,
  `Phone 2 Type` enum('Cell','Home','Business','Other') DEFAULT NULL,
  `Notes` varchar(100) DEFAULT NULL,
  `Machine 1` int(3) DEFAULT NULL,
  `Payout 1` tinyint(4) DEFAULT NULL,
  `Machine 1 Start Date` date DEFAULT NULL,
  `Machine 1 End Date` date DEFAULT NULL,
  `Machine 2` int(3) DEFAULT NULL,
  `Payout 2` tinyint(4) DEFAULT NULL,
  `Machine 2 Start Date` date DEFAULT NULL,
  `Machine 2 End Date` date DEFAULT NULL,
  `Machine 3` int(3) DEFAULT NULL,
  `Payout 3` tinyint(4) DEFAULT NULL,
  `Machine 3 Start Date` date DEFAULT NULL,
  `Machine 3 End Date` date DEFAULT NULL,
  `Machine 4` int(11) DEFAULT NULL,
  `Payout 4` tinyint(4) DEFAULT NULL,
  `Machine 4 Start Date` date DEFAULT NULL,
  `Machine 4 End Date` date DEFAULT NULL,
  `Machine 5` int(11) DEFAULT NULL,
  `Payout 5` tinyint(4) DEFAULT NULL,
  `Machine 5 Start Date` date DEFAULT NULL,
  `Machine 5 End Date` date DEFAULT NULL,
  `active` varchar(3) DEFAULT NULL,
  `agreement` varchar(1) DEFAULT NULL,
  `1099` varchar(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `machines`
--

CREATE TABLE `machines` (
  `Machine Name` varchar(50) NOT NULL,
  `Description` varchar(200) NOT NULL,
  `Location` varchar(100) NOT NULL,
  `Payout` smallint(2) NOT NULL,
  `purch_date` date NOT NULL,
  `purch_price` decimal(11,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
  `Record` mediumint(4) NOT NULL,
  `Date` date DEFAULT NULL,
  `Location` varchar(50) DEFAULT NULL,
  `Machine` varchar(5) DEFAULT NULL,
  `Note` varchar(200) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `percentages`
--

CREATE TABLE `percentages` (
  `percent` varchar(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `percentages`
--

INSERT INTO `percentages` (`percent`) VALUES
('-'),
('05%'),
('10%'),
('15%'),
('20%'),
('25%'),
('30%'),
('35%'),
('40%'),
('45%'),
('50%');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `history`
--
ALTER TABLE `history`
  ADD PRIMARY KEY (`record`);

--
-- Indexes for table `locations`
--
ALTER TABLE `locations`
  ADD PRIMARY KEY (`Name`);

--
-- Indexes for table `machines`
--
ALTER TABLE `machines`
  ADD PRIMARY KEY (`Machine Name`);

--
-- Indexes for table `notes`
--
ALTER TABLE `notes`
  ADD PRIMARY KEY (`Record`);

--
-- Indexes for table `percentages`
--
ALTER TABLE `percentages`
  ADD PRIMARY KEY (`percent`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `history`
--
ALTER TABLE `history`
  MODIFY `record` int(3) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notes`
--
ALTER TABLE `notes`
  MODIFY `Record` mediumint(4) NOT NULL AUTO_INCREMENT;
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 */;
