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

START TRANSACTION;



--
-- Database: `monumen8_bellringing`
--
CREATE DATABASE IF NOT EXISTS `monumen8_bellringing` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `monumen8_bellringing`;

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

--
-- Table structure for table `administration`
--

CREATE TABLE `administration` (
  `start_dt` date NOT NULL,
  `end_dt` date NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `administration`
--

INSERT INTO `administration` (`start_dt`, `end_dt`, `project_id`) VALUES
('2023-11-24', '2023-12-24', 1);

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

--
-- Table structure for table `administrators`
--

CREATE TABLE `administrators` (
  `listing_order` int(1) NOT NULL,
  `title` varchar(50) NOT NULL,
  `fname` varchar(50) DEFAULT NULL,
  `lname` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `phone` varchar(12) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `administrators`
--

INSERT INTO `administrators` (`listing_order`, `title`, `fname`, `lname`, `email`, `phone`) VALUES
(1, 'Manager', 'Jeff', 'Baker', 'wjeffreybaker@gmail.com', '860-989-8881'),
(2, 'Asst. Manager', 'Mark', 'Zeiger', 'mark.zeiger@gmail.com', '719-494-7718'),
(3, 'Store Manager - King Soopers', NULL, NULL, NULL, NULL),
(4, 'Store Manager - Walmart', NULL, NULL, NULL, NULL);

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

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

CREATE TABLE `locations` (
  `id` smallint(11) NOT NULL,
  `location_name` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`id`, `location_name`) VALUES
(100, 'Walmart East Dr'),
(300, 'King Soopers'),
(200, 'Walmart West Dr');

--
-- Triggers `ringers`
--
DROP TRIGGER IF EXISTS `delete_from_schedule_after_ringer`;
DELIMITER $$
DELIMITER ;

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

--
-- Table structure for table `ringing_days`
--

CREATE TABLE `ringing_days` (
  `active_ringing_day` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ringing_days`
--

INSERT INTO `ringing_days` (`active_ringing_day`) VALUES
('2025-11-28'),
('2025-11-29'),
('2025-11-30'),
('2025-12-03'),
('2025-12-06'),
('2025-12-07'),
('2025-12-10'),
('2025-12-13'),
('2025-12-14'),
('2025-12-17'),
('2025-12-20'),
('2025-12-21'),
('2025-12-23'),
('2025-12-24');

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

--
-- Table structure for table `schedule`
--

CREATE TABLE `schedule` (
  `dt` date NOT NULL,
  `slot` smallint(6) NOT NULL,
  `ringer` smallint(11) NOT NULL,
  `location` smallint(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `schedule`
--

INSERT INTO `schedule` (`dt`, `slot`, `ringer`, `location`) VALUES
('2025-12-03', 50, 467, 200),
('2025-12-03', 100, 468, 200),
('2025-12-03', 200, 411, 200),
('2025-12-03', 300, 469, 200),
('2025-12-03', 400, 470, 200),
('2025-12-03', 500, 471, 200),
('2025-12-03', 600, 472, 200),
('2025-12-03', 700, 473, 200),
('2025-12-03', 800, 474, 200),
('2025-12-10', 50, 475, 200),
('2025-12-10', 100, 476, 200),
('2025-12-10', 200, 477, 200),
('2025-12-10', 300, 478, 200),
('2025-12-10', 400, 478, 200),
('2025-12-10', 500, 479, 200),
('2025-12-10', 600, 480, 200),
('2025-12-10', 700, 481, 200),
('2025-12-10', 800, 482, 200),
('2025-12-17', 50, 483, 200),
('2025-12-17', 100, 470, 200),
('2025-12-17', 200, 484, 200),
('2025-12-17', 300, 433, 200),
('2025-12-17', 400, 411, 200),
('2025-12-17', 500, 486, 200),
('2025-12-17', 600, 487, 200),
('2025-12-17', 700, 481, 200),
('2025-12-17', 800, 474, 200),
('2025-12-21', 800, 420, 300),
('2025-12-21', 700, 420, 300),
('2025-12-21', 600, 420, 300),
('2025-12-21', 500, 420, 300),
('2025-12-21', 400, 420, 300),
('2025-12-21', 300, 420, 300),
('2025-12-21', 200, 420, 300),
('2025-12-21', 100, 420, 300),
('2025-12-21', 50, 420, 300),
('2025-11-28', 900, 408, 200),
('2025-11-29', 900, 408, 200),
('2025-11-30', 900, 408, 200),
('2025-12-03', 900, 408, 200),
('2025-12-06', 900, 408, 200),
('2025-12-07', 900, 408, 200),
('2025-12-10', 900, 408, 200),
('2025-12-13', 900, 409, 200),
('2025-12-14', 900, 409, 200),
('2025-12-17', 900, 408, 200),
('2025-12-20', 900, 408, 200),
('2025-12-21', 900, 408, 200),
('2025-12-23', 900, 408, 200),
('2025-12-24', 700, 409, 200),
('2025-12-24', 800, 409, 300),
('2025-12-24', 900, 439, 300),
('2025-12-24', 800, 409, 200),
('2025-12-24', 800, 409, 100),
('2025-12-24', 900, 439, 100),
('2025-12-24', 900, 408, 200),
('2025-12-24', 700, 409, 100),
('2025-12-24', 400, 435, 100),
('2025-12-14', 800, 420, 300),
('2025-12-14', 700, 420, 300),
('2025-12-14', 600, 420, 300),
('2025-12-14', 500, 420, 300),
('2025-12-14', 400, 420, 300),
('2025-12-14', 300, 420, 300),
('2025-12-14', 200, 420, 300),
('2025-12-14', 100, 420, 300),
('2025-12-14', 50, 420, 300),
('2025-11-30', 800, 420, 300),
('2025-11-30', 700, 420, 300),
('2025-11-30', 600, 420, 300),
('2025-11-30', 500, 420, 300),
('2025-11-30', 400, 420, 300),
('2025-11-30', 300, 420, 300),
('2025-11-30', 200, 420, 300),
('2025-11-30', 100, 420, 300),
('2025-11-30', 50, 420, 300),
('2025-12-07', 800, 419, 300),
('2025-12-07', 700, 419, 300),
('2025-12-07', 600, 419, 300),
('2025-12-07', 500, 419, 300),
('2025-12-07', 400, 419, 300),
('2025-12-07', 300, 419, 300),
('2025-12-07', 200, 419, 300),
('2025-12-07', 100, 419, 300),
('2025-12-07', 50, 419, 300),
('2025-12-07', 900, 422, 300),
('2025-11-30', 700, 423, 200),
('2025-12-03', 700, 423, 300),
('2025-12-06', 700, 423, 300),
('2025-12-07', 700, 423, 200),
('2025-12-10', 700, 409, 300),
('2025-12-13', 700, 423, 300),
('2025-12-14', 700, 409, 200),
('2025-12-17', 700, 423, 300),
('2025-12-20', 700, 423, 300),
('2025-12-21', 700, 423, 200),
('2025-12-23', 700, 423, 300),
('2025-12-23', 500, 452, 200),
('2025-12-06', 300, 425, 300),
('2025-12-10', 300, 425, 300),
('2025-12-20', 300, 425, 300),
('2025-11-29', 300, 425, 300),
('2025-11-28', 200, 426, 200),
('2025-11-28', 300, 426, 200),
('2025-12-24', 200, 490, 200),
('2025-12-24', 300, 491, 200),
('2025-11-29', 200, 426, 200),
('2025-11-30', 200, 426, 200),
('2025-11-30', 300, 426, 200),
('2025-12-23', 700, 426, 200),
('2025-12-20', 200, 426, 200),
('2025-12-21', 200, 426, 200),
('2025-11-28', 300, 427, 100),
('2025-11-28', 200, 427, 100),
('2025-11-29', 200, 427, 100),
('2025-11-30', 300, 427, 100),
('2025-11-30', 200, 427, 100),
('2025-12-20', 200, 427, 100),
('2025-12-21', 200, 427, 100),
('2025-12-17', 700, 428, 100),
('2025-12-17', 800, 428, 100),
('2025-12-17', 900, 428, 100),
('2025-12-20', 800, 428, 100),
('2025-12-20', 700, 428, 100),
('2025-11-28', 700, 428, 100),
('2025-11-28', 800, 428, 100),
('2025-11-28', 900, 428, 100),
('2025-11-28', 200, 447, 300),
('2025-12-06', 600, 429, 300),
('2025-12-13', 100, 429, 300),
('2025-12-20', 100, 429, 300),
('2025-12-23', 600, 429, 300),
('2025-12-03', 700, 428, 100),
('2025-12-03', 800, 428, 100),
('2025-12-03', 900, 428, 100),
('2025-11-29', 300, 404, 200),
('2025-12-10', 100, 431, 300),
('2025-12-20', 400, 493, 100),
('2025-12-17', 200, 432, 300),
('2025-12-10', 200, 432, 300),
('2025-12-03', 200, 432, 300),
('2025-11-28', 400, 436, 100),
('2025-11-28', 500, 436, 100),
('2025-11-29', 400, 436, 100),
('2025-11-29', 500, 436, 100),
('2025-12-03', 50, 436, 100),
('2025-12-03', 100, 436, 100),
('2025-12-10', 50, 436, 100),
('2025-12-10', 100, 436, 100),
('2025-12-17', 50, 436, 100),
('2025-12-17', 100, 436, 100),
('2025-12-23', 50, 436, 100),
('2025-12-23', 100, 436, 100),
('2025-11-28', 100, 437, 300),
('2025-12-03', 100, 437, 300),
('2025-12-06', 500, 494, 100),
('2025-12-07', 100, 499, 100),
('2025-12-10', 400, 438, 100),
('2025-12-10', 500, 438, 100),
('2025-12-14', 400, 409, 100),
('2025-12-14', 500, 409, 100),
('2025-12-17', 400, 438, 100),
('2025-12-17', 500, 438, 100),
('2025-12-21', 400, 438, 100),
('2025-12-21', 500, 438, 100),
('2025-12-23', 600, 438, 200),
('2025-12-23', 300, 464, 100),
('2025-12-07', 800, 439, 100),
('2025-12-07', 900, 439, 100),
('2025-12-10', 800, 439, 100),
('2025-12-10', 900, 439, 100),
('2025-12-14', 800, 409, 100),
('2025-12-14', 900, 409, 100),
('2025-12-21', 800, 439, 100),
('2025-12-21', 900, 439, 100),
('2025-11-28', 400, 440, 200),
('2025-11-28', 500, 440, 200),
('2025-11-29', 400, 440, 200),
('2025-11-29', 500, 440, 200),
('2025-12-10', 200, 441, 100),
('2025-12-17', 200, 441, 100),
('2025-12-23', 200, 441, 100),
('2025-12-24', 50, 488, 200),
('2025-12-24', 100, 489, 200),
('2025-12-24', 400, 433, 200),
('2025-12-06', 200, 492, 200),
('2025-11-29', 600, 492, 200),
('2025-12-24', 200, 426, 100),
('2025-12-24', 300, 426, 100),
('2025-11-30', 900, 443, 300),
('2025-12-14', 900, 446, 300),
('2025-12-21', 900, 443, 300),
('2025-11-28', 100, 443, 200),
('2025-12-23', 800, 444, 100),
('2025-12-03', 600, 444, 100),
('2025-12-17', 600, 444, 100),
('2025-11-28', 100, 445, 100),
('2025-11-29', 100, 445, 100),
('2025-11-30', 100, 445, 100),
('2025-12-06', 100, 445, 100),
('2025-12-17', 800, 424, 300),
('2025-12-10', 50, 445, 300),
('2025-12-13', 100, 409, 200),
('2025-12-14', 100, 409, 100),
('2025-12-20', 300, 446, 200),
('2025-12-21', 400, 446, 200),
('2025-11-28', 300, 447, 300),
('2025-11-29', 100, 447, 300),
('2025-11-29', 200, 447, 300),
('2025-11-30', 50, 447, 200),
('2025-11-30', 100, 447, 200),
('2025-12-03', 400, 447, 300),
('2025-12-03', 500, 447, 300),
('2025-12-07', 100, 447, 200),
('2025-12-07', 200, 447, 200),
('2025-12-10', 400, 447, 300),
('2025-12-10', 500, 447, 300),
('2025-12-13', 200, 447, 300),
('2025-12-13', 300, 447, 300),
('2025-12-14', 50, 409, 200),
('2025-12-14', 100, 409, 200),
('2025-12-17', 300, 447, 300),
('2025-12-17', 400, 447, 300),
('2025-12-20', 400, 447, 300),
('2025-12-20', 500, 447, 300),
('2025-12-21', 50, 447, 200),
('2025-12-21', 100, 447, 200),
('2025-12-23', 50, 447, 300),
('2025-12-23', 100, 447, 300),
('2025-12-24', 50, 430, 300),
('2025-12-24', 100, 430, 300),
('2025-11-28', 600, 434, 300),
('2025-12-03', 600, 434, 300),
('2025-12-10', 600, 409, 300),
('2025-12-17', 600, 434, 300),
('2025-12-06', 50, 448, 300),
('2025-12-10', 800, 409, 300),
('2025-12-13', 100, 409, 100),
('2025-12-23', 800, 448, 300),
('2025-12-10', 600, 449, 100),
('2025-12-17', 300, 449, 100),
('2025-11-29', 50, 450, 200),
('2025-11-29', 100, 450, 200),
('2025-11-28', 400, 450, 300),
('2025-11-28', 500, 450, 300),
('2025-11-29', 400, 450, 300),
('2025-11-29', 500, 450, 300),
('2025-11-30', 400, 450, 100),
('2025-11-30', 500, 450, 100),
('2025-12-03', 200, 450, 100),
('2025-12-03', 300, 450, 100),
('2025-12-07', 200, 450, 100),
('2025-12-07', 300, 450, 100),
('2025-12-07', 700, 450, 100),
('2025-12-10', 300, 450, 100),
('2025-12-06', 50, 450, 100),
('2025-12-13', 400, 450, 300),
('2025-12-13', 500, 450, 300),
('2025-12-20', 50, 450, 100),
('2025-12-20', 100, 450, 100),
('2025-12-21', 50, 450, 100),
('2025-12-21', 100, 450, 100),
('2025-12-21', 600, 450, 100),
('2025-12-21', 700, 450, 100),
('2025-12-06', 800, 450, 100),
('2025-12-24', 100, 450, 100),
('2025-12-24', 50, 450, 100),
('2025-12-23', 200, 450, 300),
('2025-12-23', 300, 450, 300),
('2025-12-23', 50, 497, 200),
('2025-12-17', 50, 450, 300),
('2025-12-14', 300, 409, 100),
('2025-12-14', 200, 409, 100),
('2025-12-10', 700, 450, 100),
('2025-11-28', 50, 450, 100),
('2025-12-23', 600, 450, 100),
('2025-12-23', 700, 450, 100),
('2025-11-28', 800, 451, 300),
('2025-12-17', 500, 451, 300),
('2025-12-06', 500, 451, 300),
('2025-12-13', 600, 451, 300),
('2025-12-23', 400, 434, 300),
('2025-11-30', 600, 451, 100),
('2025-11-29', 600, 451, 300),
('2025-12-03', 400, 451, 100),
('2025-12-07', 600, 451, 100),
('2025-12-21', 500, 451, 200),
('2025-11-28', 50, 453, 300),
('2025-12-06', 300, 455, 200),
('2025-12-07', 400, 455, 200),
('2025-12-13', 200, 409, 200),
('2025-12-14', 200, 409, 200),
('2025-12-06', 300, 452, 100),
('2025-12-07', 400, 452, 100),
('2025-12-13', 200, 409, 100),
('2025-12-14', 300, 409, 200),
('2025-12-20', 900, 428, 100),
('2025-12-13', 700, 409, 100),
('2025-12-13', 800, 409, 100),
('2025-12-13', 900, 409, 100),
('2025-12-03', 800, 424, 300),
('2025-12-03', 900, 424, 300),
('2025-11-30', 700, 424, 100),
('2025-12-06', 800, 424, 300),
('2025-12-06', 900, 424, 300),
('2025-12-20', 800, 424, 300),
('2025-12-20', 900, 424, 300),
('2025-12-24', 500, 424, 100),
('2025-11-30', 900, 449, 100),
('2025-11-29', 900, 449, 100),
('2025-12-13', 300, 409, 200),
('2025-12-13', 400, 409, 200),
('2025-12-20', 400, 456, 200),
('2025-12-20', 500, 456, 200),
('2025-11-29', 600, 457, 100),
('2025-12-03', 500, 457, 100),
('2025-12-06', 600, 457, 100),
('2025-12-13', 500, 409, 200),
('2025-12-20', 600, 457, 200),
('2025-12-23', 900, 404, 300),
('2025-12-07', 300, 458, 200),
('2025-12-13', 50, 409, 200),
('2025-12-14', 400, 409, 200),
('2025-11-28', 900, 451, 300),
('2025-11-29', 900, 451, 300),
('2025-12-10', 900, 451, 300),
('2025-12-06', 900, 459, 100),
('2025-12-23', 900, 459, 100),
('2025-12-03', 300, 465, 300),
('2025-12-17', 900, 459, 300),
('2025-12-13', 600, 409, 100),
('2025-11-28', 700, 460, 300),
('2025-11-28', 700, 423, 200),
('2025-11-29', 700, 423, 200),
('2025-12-13', 50, 409, 100),
('2025-12-13', 300, 409, 100),
('2025-12-13', 400, 409, 100),
('2025-12-13', 500, 409, 100),
('2025-12-13', 600, 409, 200),
('2025-12-13', 700, 409, 200),
('2025-12-13', 800, 409, 200),
('2025-12-14', 50, 409, 100),
('2025-12-14', 600, 409, 100),
('2025-12-14', 700, 409, 100),
('2025-12-14', 500, 409, 200),
('2025-12-14', 600, 409, 200),
('2025-12-14', 800, 409, 200),
('2025-11-30', 500, 455, 200),
('2025-11-30', 600, 452, 200),
('2025-11-28', 600, 424, 100),
('2025-11-30', 400, 442, 200),
('2025-12-07', 500, 442, 200),
('2025-12-12', 600, 409, 300),
('2025-11-30', 800, 464, 100),
('2025-11-29', 800, 424, 300),
('2025-11-28', 600, 430, 200),
('2025-12-06', 400, 465, 300),
('2025-12-06', 100, 466, 200),
('2025-12-20', 100, 466, 200),
('2025-12-23', 100, 466, 200),
('2025-12-21', 300, 466, 200),
('2025-11-29', 700, 430, 100),
('2025-11-29', 800, 430, 100),
('2025-12-20', 700, 492, 200),
('2025-12-20', 800, 492, 200),
('2025-11-29', 50, 494, 100),
('2025-11-28', 50, 462, 200),
('2025-11-30', 800, 462, 200),
('2025-11-29', 800, 494, 200),
('2025-12-23', 500, 457, 300),
('2025-11-29', 700, 463, 300),
('2025-11-28', 800, 452, 200),
('2025-11-29', 300, 426, 100),
('2025-11-30', 50, 430, 100),
('2025-12-07', 600, 424, 200),
('2025-12-13', 800, 424, 300),
('2025-12-06', 600, 497, 200),
('2025-12-07', 500, 497, 100),
('2025-12-20', 600, 497, 100),
('2025-12-07', 50, 445, 100),
('2025-12-06', 200, 499, 300),
('2025-12-20', 300, 499, 100),
('2025-12-21', 600, 499, 200),
('2025-12-24', 400, 499, 300),
('2025-12-13', 50, 450, 300),
('2025-12-03', 50, 430, 300),
('2025-12-20', 50, 500, 300),
('2025-12-24', 600, 500, 300),
('2025-12-06', 400, 424, 200),
('2025-12-06', 400, 423, 100),
('2025-12-06', 200, 430, 100),
('2025-12-13', 900, 424, 300),
('2025-12-06', 700, 430, 100),
('2025-12-06', 100, 499, 300),
('2025-12-07', 800, 423, 200),
('2025-12-06', 500, 423, 200),
('2025-12-23', 800, 424, 200),
('2025-12-07', 50, 430, 200),
('2025-12-21', 800, 424, 200),
('2025-12-20', 500, 493, 100),
('2025-12-21', 300, 493, 100),
('2025-12-17', 100, 450, 300),
('2025-12-20', 200, 498, 300),
('2025-12-23', 400, 464, 100),
('2025-12-23', 500, 464, 100),
('2025-12-24', 600, 439, 100),
('2025-12-24', 700, 409, 300),
('2025-12-24', 500, 501, 200),
('2025-12-24', 600, 501, 200),
('2025-12-20', 50, 501, 200),
('2025-12-24', 200, 448, 300),
('2025-12-20', 600, 462, 300),
('2025-12-23', 200, 462, 200),
('2025-12-24', 300, 462, 300),
('2025-12-23', 400, 455, 200),
('2025-12-24', 500, 499, 300),
('2025-12-23', 300, 435, 200);

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

--
-- Table structure for table `swaps`
--

CREATE TABLE `swaps` (
  `swapId` int(10) UNSIGNED NOT NULL,
  `requesterId` smallint(11) UNSIGNED NOT NULL,
  `requesterSlotId` smallint(11) UNSIGNED NOT NULL,
  `requesterLocationId` smallint(11) UNSIGNED NOT NULL,
  `requesterDate` date NOT NULL,
  `requesteeId` smallint(11) UNSIGNED NOT NULL,
  `requesteeSlotId` smallint(11) UNSIGNED NOT NULL,
  `requesteeLocationId` smallint(11) UNSIGNED NOT NULL,
  `requesteeDate` date NOT NULL,
  `swapStatus` enum('A','D','N') NOT NULL DEFAULT 'N' COMMENT 'A=Accepted, D=declined, N=No status '
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `swaps`
--

INSERT INTO `swaps` (`swapId`, `requesterId`, `requesterSlotId`, `requesterLocationId`, `requesterDate`, `requesteeId`, `requesteeSlotId`, `requesteeLocationId`, `requesteeDate`, `swapStatus`) VALUES
(1, 60, 800, 300, '2019-12-16', 124, 900, 300, '2019-12-16', 'N'),
(2, 60, 800, 300, '2019-12-16', 124, 900, 300, '2019-12-16', 'N'),
(3, 60, 800, 300, '2019-12-16', 124, 900, 300, '2019-12-16', 'N');

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

--
-- Table structure for table `timeslots`
--

CREATE TABLE `timeslots` (
  `id` smallint(11) NOT NULL,
  `time` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `timeslots`
--

INSERT INTO `timeslots` (`id`, `time`) VALUES
(100, '10 AM to 11 AM'),
(200, '11 AM to 12 Noon'),
(300, '12 Noon to 1 PM'),
(400, '1 PM to 2 PM'),
(500, '2 PM to 3 PM'),
(600, '3 PM to 4 PM'),
(700, '4 PM to 5 PM'),
(800, '5 PM to 6 PM'),
(900, '6 PM $$ Pickup'),
(50, '9 AM to 10 AM');

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

--
-- Stand-in structure for view `v_individual_schedule`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_individual_schedule`;
CREATE TABLE `v_individual_schedule` (
`Date` date
,`Day` varchar(9)
,`Name` varchar(51)
,`Time` varchar(30)
,`Location` varchar(20)
,`ringer` smallint(11)
);

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

--
-- Stand-in structure for view `v_schedule`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_schedule`;

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

--
-- Stand-in structure for view `v_schedule_with_phone`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_schedule_with_phone`;

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

--
-- Stand-in structure for view `v_schedule_with_phone_administrator`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_schedule_with_phone_administrator`;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `administration`
--
ALTER TABLE `administration`
  ADD PRIMARY KEY (`project_id`);

--
-- Indexes for table `administrators`
--
ALTER TABLE `administrators`
  ADD UNIQUE KEY `listing_order` (`listing_order`);

--
-- Indexes for table `locations`
--
ALTER TABLE `locations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `location` (`location_name`);

--
-- Indexes for table `ringing_days`
--
ALTER TABLE `ringing_days`
  ADD UNIQUE KEY `idx_active_ringing_day` (`active_ringing_day`);

--
-- Indexes for table `schedule`
--
ALTER TABLE `schedule`
  ADD UNIQUE KEY `Unique Index` (`dt`,`slot`,`location`);

--
-- Indexes for table `swaps`
--
ALTER TABLE `swaps`
  ADD PRIMARY KEY (`swapId`);

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

--
-- AUTO_INCREMENT for table `swaps`
--
ALTER TABLE `swaps`
  MODIFY `swapId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

--
-- Structure for view `v_individual_schedule`
--

DROP VIEW IF EXISTS `v_individual_schedule`;

DROP VIEW IF EXISTS `v_schedule`;

DROP VIEW IF EXISTS `v_schedule_with_phone`;

DROP VIEW IF EXISTS `v_schedule_with_phone_administrator`;
COMMIT;

