-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 03, 2019 at 12:43 AM
-- Server version: 10.1.38-MariaDB-0+deb9u1
-- PHP Version: 7.0.33-0+deb9u3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `holydays`
--

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

--
-- Table structure for table `calendar`
--

CREATE TABLE `calendar` (
  `calindex` int(2) NOT NULL,
  `calname` varchar(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `calendar`
--

INSERT INTO `calendar` (`calindex`, `calname`) VALUES
(1, 'Hammer'),
(2, 'Midwinter'),
(3, 'Alturiak'),
(4, 'Ches'),
(5, 'Tarsakh'),
(6, 'Greengrass'),
(7, 'Mirtul'),
(8, 'Kythorn'),
(9, 'Flamerule'),
(10, 'Midsummer'),
(11, 'Eleasis'),
(12, 'Eleint'),
(13, 'Highharvestide'),
(14, 'Marpenoth'),
(15, 'Uktar'),
(16, 'The Feast of the Moon'),
(17, 'Nightal'),
(18, 'Shieldmeet'),
(19, 'Full Moon'),
(20, 'New Moon');

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

--
-- Table structure for table `deity`
--

CREATE TABLE `deity` (
  `deityindex` int(3) NOT NULL,
  `deityname` varchar(50) NOT NULL DEFAULT '',
  `panindex` int(2) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Listing of Deities in the Forgotten Realms';

--
-- Dumping data for table `deity`
--

INSERT INTO `deity` (`deityindex`, `deityname`, `panindex`) VALUES
(1, 'Eldath', 0),
(2, 'Helm', 0),
(3, 'Lathander', 0),
(4, 'Mielikki', 0),
(5, 'Tymora', 0),
(6, 'Tyr', 0),
(7, 'Finder Wyvernspur', 0),
(8, 'Garagos', 0),
(9, 'Gargauth', 0),
(10, 'Gwaeron Windstrom', 0),
(11, 'Hoar', 0),
(12, 'Jergal', 0),
(13, 'Karsus', 0),
(14, 'Lurue', 0),
(15, 'Nobanion', 0),
(16, 'Red Knight', 0),
(17, 'Savras', 0),
(18, 'Sharess', 0),
(19, 'Shiallia', 0),
(20, 'Siamorphe', 0),
(21, 'Ulutiu', 0),
(22, 'Uthgar', 0),
(23, 'Valkur', 0),
(24, 'Velsharoon', 0),
(25, 'Eshowdow', 2),
(26, 'Sseth', 2),
(27, 'Ubtao', 2),
(28, 'Anhur', 1),
(29, 'Geb', 1),
(30, 'Gilgeam', 1),
(31, 'Hathor', 1),
(32, 'Horus-Re', 1),
(33, 'Isis', 1),
(34, 'Nephthys', 1),
(35, 'Osiris', 1),
(36, 'Sebek', 1),
(37, 'Set', 1),
(38, 'Thoth', 1),
(39, 'Tiamat', 1),
(40, 'Azuth', 0),
(41, 'Bane', 0),
(42, 'Chauntea', 0),
(43, 'Cyric', 0),
(44, 'Eilistraee', 6),
(45, 'Gond', 0),
(46, 'Helm', 0),
(47, 'Ilmater', 0),
(48, 'Kelemvor', 0),
(49, 'Kossuth', 0),
(50, 'Lolth', 6),
(51, 'Malar', 0),
(52, 'Mask', 0),
(53, 'Mystra', 0),
(54, 'Oghma', 0),
(55, 'Selune', 0),
(56, 'Shar', 0),
(57, 'Shaundakul', 0),
(58, 'Silvanus', 0),
(59, 'Sune', 0),
(60, 'Talos', 0),
(61, 'Tempus', 0),
(62, 'Torm', 0),
(63, 'Umberlee', 0),
(64, 'Waukeen', 0),
(65, 'Ghaunadaur', 6),
(66, 'Kiaransalee', 6),
(67, 'Selvetarm', 6),
(68, 'Vhaeraun', 6),
(69, 'Abbathor', 5),
(70, 'Berronar Truesilver', 5),
(71, 'Clangeddin Silverbeard', 5),
(72, 'Deep Duerra', 5),
(73, 'Dugmaren Brightmantle', 5),
(74, 'Dumathoin', 5),
(75, 'Gorm Gulthyn', 5),
(76, 'Haela Brightaxe', 5),
(77, 'Laduguer', 5),
(78, 'Marthammor Duin', 5),
(79, 'Moradin', 5),
(80, 'Sharindlar', 5),
(81, 'Thard Harr', 5),
(82, 'Vergadain', 5),
(83, 'Aerdrie Faenya', 4),
(84, 'Angharradh', 4),
(85, 'Corellon Larethian', 4),
(86, 'Deep Sashelas', 4),
(87, 'Erevan Illesere', 4),
(88, 'Fenmarel Mestarine', 4),
(89, 'Hanali Celanil', 4),
(90, 'Khalreshaar', 4),
(91, 'Labelas Enoreth', 4),
(92, 'Rillifane Rallathil', 4),
(93, 'Sehanine Moonbow', 4),
(94, 'Shevarash', 4),
(95, 'Solonor Thelandira', 4),
(96, 'Baervan Wildwanderer', 7),
(97, 'Baravar Cloakshadow', 7),
(98, 'Callarduran Smoothhands', 7),
(99, 'Flandal Steelskin', 7),
(100, 'Gaerdal Ironhand', 7),
(101, 'Garl Glittergold', 7),
(102, 'Nebelun', 7),
(103, 'Segojan Earthcaller', 7),
(104, 'Urdlen', 7),
(105, 'Arvoreen', 8),
(106, 'Brandobaris', 8),
(107, 'Cyrrollalee', 8),
(108, 'Sheela Peryroyl', 8),
(109, 'Urogalan', 8),
(110, 'Yondalla', 8),
(111, 'Ishtar', 1),
(112, 'Ramman', 1),
(113, 'Enlil', 1),
(114, 'Marduk', 1),
(115, 'Nanna-Sin', 1),
(116, 'Utu', 1),
(117, 'Assuran', 1),
(118, 'Tchazzar', 1),
(119, 'Annam', 3),
(120, 'Baphomet', 3),
(121, 'Diirinka', 3),
(122, 'Great Mother', 3),
(123, 'Grolantor', 3),
(124, 'Hiatea', 3),
(125, 'Hlal', 3),
(126, 'Hruggek', 3),
(127, 'Iallanis', 3),
(128, 'Ilsensine', 3),
(129, 'Kurtulmak', 3),
(130, 'Laogzed', 3),
(131, 'Maglubiyet', 3),
(132, 'Memnor', 3),
(133, 'Chronepsis', 3),
(134, 'Orcus', 3),
(135, 'Pazrael', 3),
(136, 'Sekolah', 3),
(137, 'Skoraeus Stonebones', 3),
(138, 'Stronmaus', 3),
(139, 'Surtr', 3),
(140, 'Tapann', 3),
(141, 'Task', 3),
(142, 'Thrym', 3),
(143, 'Vaprak', 3),
(144, 'Bahamut', 3),
(145, 'Khurgorbaeyag', 3),
(146, 'Shekinester', 3),
(147, 'Skerritt', 3),
(148, 'Yeenoghu', 3),
(149, 'Bahgtru', 9),
(150, 'Gruumsh', 9),
(151, 'Ilneval', 9),
(152, 'Luthic', 9),
(153, 'Shargaas', 9),
(154, 'Yurtrus', 9),
(155, 'Akadi', 0),
(156, 'Auril', 0),
(157, 'Beshaba', 0),
(158, 'Deneir', 0),
(159, 'Grumbar', 0),
(160, 'Liira', 0),
(161, 'Loviatar', 0),
(162, 'Lurne', 0),
(163, 'Milil', 0),
(164, 'Valkur', 0);

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

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `dayindex` int(3) NOT NULL,
  `daydeity` int(3) NOT NULL DEFAULT '0',
  `daytitle` varchar(60) NOT NULL DEFAULT '',
  `dayday` int(2) NOT NULL DEFAULT '0',
  `daymonth` int(2) NOT NULL DEFAULT '0',
  `daysource` varchar(60) NOT NULL DEFAULT '',
  `daypage` int(3) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `event`
--

INSERT INTO `event` (`dayindex`, `daydeity`, `daytitle`, `dayday`, `daymonth`, `daysource`, `daypage`) VALUES
(1, 7, '', 20, 14, 'P&P2E', 16),
(2, 9, 'The Unveiling', 0, 2, 'P&P2E', 24),
(3, 9, 'The Binding', 0, 16, 'P&P2E', 24),
(4, 66, 'The Graverending', 0, 2, 'DD2E', 26),
(5, 82, 'Coin Festival', 0, 6, 'DD2E', 109),
(6, 85, '', 0, 18, 'DD2E', 123),
(7, 101, 'Communion of Laughter', 13, 1, 'DD2E', 186),
(8, 101, 'Communion of Laughter', 13, 3, 'DD2E', 186),
(9, 101, 'Communion of Laughter', 13, 4, 'DD2E', 186),
(10, 101, 'Communion of Laughter', 13, 5, 'DD2E', 186),
(11, 101, 'Communion of Laughter', 13, 7, 'DD2E', 186),
(12, 101, 'Communion of Laughter', 13, 8, 'DD2E', 186),
(13, 101, 'Communion of Laughter', 13, 9, 'DD2E', 186),
(14, 101, 'Communion of Laughter', 13, 11, 'DD2E', 186),
(15, 101, 'Communion of Laughter', 13, 12, 'DD2E', 186),
(16, 101, 'Communion of Laughter', 13, 14, 'DD2E', 186),
(17, 101, 'Communion of Laughter', 13, 15, 'DD2E', 186),
(18, 101, 'Communion of Laughter', 13, 17, 'DD2E', 186),
(111, 110, 'Safeday', 5, 1, 'DD2E', 221),
(112, 110, 'Safeday', 15, 1, 'DD2E', 221),
(113, 110, 'Safeday', 25, 1, 'DD2E', 221),
(114, 110, 'Safeday', 5, 3, 'DD2E', 221),
(115, 110, 'Safeday', 15, 3, 'DD2E', 221),
(116, 110, 'Safeday', 25, 3, 'DD2E', 221),
(117, 110, 'Safeday', 5, 4, 'DD2E', 221),
(118, 110, 'Safeday', 15, 4, 'DD2E', 221),
(119, 110, 'Safeday', 25, 4, 'DD2E', 221),
(120, 110, 'Safeday', 5, 5, 'DD2E', 221),
(121, 110, 'Safeday', 15, 5, 'DD2E', 221),
(122, 110, 'Safeday', 25, 5, 'DD2E', 221),
(123, 110, 'Safeday', 5, 7, 'DD2E', 221),
(124, 110, 'Safeday', 15, 7, 'DD2E', 221),
(125, 110, 'Safeday', 25, 7, 'DD2E', 221),
(126, 110, 'Safeday', 5, 8, 'DD2E', 221),
(127, 110, 'Safeday', 15, 8, 'DD2E', 221),
(128, 110, 'Safeday', 25, 8, 'DD2E', 221),
(129, 110, 'Safeday', 5, 9, 'DD2E', 221),
(130, 110, 'Safeday', 15, 9, 'DD2E', 221),
(131, 110, 'Safeday', 25, 9, 'DD2E', 221),
(132, 110, 'Safeday', 5, 11, 'DD2E', 221),
(133, 110, 'Safeday', 15, 11, 'DD2E', 221),
(134, 110, 'Safeday', 25, 11, 'DD2E', 221),
(135, 110, 'Safeday', 5, 12, 'DD2E', 221),
(136, 110, 'Safeday', 15, 12, 'DD2E', 221),
(137, 110, 'Safeday', 25, 12, 'DD2E', 221),
(138, 110, 'Safeday', 5, 14, 'DD2E', 221),
(139, 110, 'Safeday', 15, 14, 'DD2E', 221),
(140, 110, 'Safeday', 25, 14, 'DD2E', 221),
(141, 110, 'Safeday', 5, 15, 'DD2E', 221),
(142, 110, 'Safeday', 15, 15, 'DD2E', 221),
(143, 110, 'Safeday', 25, 15, 'DD2E', 221),
(144, 110, 'Safeday', 5, 17, 'DD2E', 221),
(145, 110, 'Safeday', 15, 17, 'DD2E', 221),
(146, 110, 'Safeday', 25, 17, 'DD2E', 221),
(147, 45, 'Ippensheir', 1, 7, 'F&P3E', 25),
(148, 45, 'Ippensheir', 2, 7, 'F&P3E', 25),
(149, 45, 'Ippensheir', 3, 7, 'F&P3E', 25),
(150, 45, 'Ippensheir', 4, 7, 'F&P3E', 25),
(151, 45, 'Ippensheir', 5, 7, 'F&P3E', 25),
(152, 45, 'Ippensheir', 6, 7, 'F&P3E', 25),
(153, 45, 'Ippensheir', 7, 7, 'F&P3E', 25),
(154, 45, 'Ippensheir', 8, 7, 'F&P3E', 25),
(155, 45, 'Ippensheir', 9, 7, 'F&P3E', 25),
(156, 45, 'Ippensheir', 10, 7, 'F&P3E', 25),
(157, 45, 'Ippensheir', 11, 7, 'F&P3E', 25),
(158, 45, 'Ippensheir', 12, 7, 'F&P3E', 25),
(159, 46, 'Ceremony of Honor to Helm', 0, 18, 'F&P3E', 28),
(160, 48, 'Deeds of the Dead', 0, 18, 'F&P3E', 33),
(161, 48, 'Deeds of the Dead', 0, 16, 'F&P3E', 33),
(162, 3, 'Song of Dawn', 0, 10, 'F&P3E', 38),
(163, 3, 'Song of Dawn', 19, 4, 'F&P3E', 38),
(164, 3, 'Song of Dawn', 21, 12, 'F&P3E', 38),
(165, 51, 'Feast of Stags', 0, 13, 'F&P3E', 43),
(166, 4, 'Four Feasts', 19, 4, 'F&P3E', 48),
(167, 4, 'Four Feasts', 20, 8, 'F&P3E', 48),
(168, 4, 'Four Feasts', 21, 12, 'F&P3E', 48),
(169, 4, 'Four Feasts', 20, 17, 'F&P3E', 48),
(170, 4, '', 0, 6, 'F&P3E', 48),
(171, 4, '', 0, 10, 'F&P3E', 48),
(172, 4, '', 0, 18, 'F&P3E', 48),
(173, 53, '', 15, 14, 'F&P3E', 50),
(174, 54, '', 0, 10, 'F&P3E', 53),
(175, 54, '', 0, 10, 'F&P3E', 53),
(176, 55, 'The Conjuring of the Second Moon', 0, 18, 'F&P3E', 55),
(177, 56, 'Rising of the Dark', 0, 16, 'F&P3E', 58),
(178, 57, 'Windride', 15, 5, 'F&P3E', 61),
(179, 58, '', 0, 6, 'F&P3E', 63),
(180, 58, '', 0, 10, 'F&P3E', 63),
(181, 58, '', 0, 13, 'F&P3E', 63),
(182, 59, '', 0, 6, 'F&P3E', 66),
(183, 59, '', 0, 10, 'F&P3E', 66),
(184, 60, '', 0, 2, 'F&P3E', 68),
(185, 60, '', 0, 6, 'F&P3E', 68),
(186, 60, '', 0, 10, 'F&P3E', 68),
(187, 60, '', 0, 13, 'F&P3E', 68),
(188, 61, '', 0, 16, 'F&P3E', 71),
(189, 62, 'Divine Death', 13, 11, 'F&P3E', 74),
(190, 62, 'True Ressurrection', 15, 14, 'F&P3E', 74),
(191, 62, '', 0, 18, 'F&P3E', 74),
(192, 5, '', 0, 10, 'FRCS', 253),
(193, 5, 'Starfall', 23, 14, 'FRCS', 253),
(194, 6, 'Seeing Justice', 1, 1, 'F&P3E', 80),
(195, 6, 'The Maiming', 13, 1, 'F&P3E', 80),
(196, 6, 'The Blinding', 22, 1, 'F&P3E', 80),
(197, 6, 'Seeing Justice', 1, 3, 'F&P3E', 80),
(198, 6, 'The Maiming', 13, 3, 'F&P3E', 80),
(199, 6, 'The Blinding', 22, 3, 'F&P3E', 80),
(200, 6, 'Seeing Justice', 1, 4, 'F&P3E', 80),
(201, 6, 'The Maiming', 13, 4, 'F&P3E', 80),
(202, 6, 'The Blinding', 22, 4, 'F&P3E', 80),
(203, 6, 'Seeing Justice', 1, 5, 'F&P3E', 80),
(204, 6, 'The Maiming', 13, 5, 'F&P3E', 80),
(205, 6, 'The Blinding', 22, 5, 'F&P3E', 80),
(206, 6, 'Seeing Justice', 1, 7, 'F&P3E', 80),
(207, 6, 'The Maiming', 13, 7, 'F&P3E', 80),
(208, 6, 'The Blinding', 22, 7, 'F&P3E', 80),
(209, 6, 'Seeing Justice', 1, 8, 'F&P3E', 80),
(210, 6, 'The Maiming', 13, 8, 'F&P3E', 80),
(211, 6, 'The Blinding', 22, 8, 'F&P3E', 80),
(212, 6, 'Seeing Justice', 1, 9, 'F&P3E', 80),
(213, 6, 'The Maiming', 13, 9, 'F&P3E', 80),
(214, 6, 'The Blinding', 22, 9, 'F&P3E', 80),
(215, 6, 'Seeing Justice', 1, 11, 'F&P3E', 80),
(216, 6, 'The Maiming', 13, 11, 'F&P3E', 80),
(217, 6, 'The Blinding', 22, 11, 'F&P3E', 80),
(218, 6, 'Seeing Justice', 1, 12, 'F&P3E', 80),
(219, 6, 'The Maiming', 13, 12, 'F&P3E', 80),
(220, 6, 'The Blinding', 22, 12, 'F&P3E', 80),
(221, 6, 'Seeing Justice', 1, 14, 'F&P3E', 80),
(222, 6, 'The Maiming', 13, 14, 'F&P3E', 80),
(223, 6, 'The Blinding', 22, 14, 'F&P3E', 80),
(224, 6, 'Seeing Justice', 1, 15, 'F&P3E', 80),
(225, 6, 'The Maiming', 13, 15, 'F&P3E', 80),
(226, 6, 'The Blinding', 22, 15, 'F&P3E', 80),
(227, 6, 'Seeing Justice', 1, 17, 'F&P3E', 80),
(228, 6, 'The Maiming', 13, 17, 'F&P3E', 80),
(229, 6, 'The Blinding', 22, 17, 'F&P3E', 80),
(230, 22, '', 19, 4, 'F&P3E', 84),
(231, 22, '', 20, 8, 'F&P3E', 84),
(232, 22, '', 21, 12, 'F&P3E', 84),
(233, 22, '', 20, 17, 'F&P3E', 84),
(234, 64, 'Cold Counting Comfort', 15, 1, 'F&P3E', 87),
(235, 64, 'Great Weave', 20, 3, 'F&P3E', 87),
(236, 64, 'High Coin', 30, 4, 'F&P3E', 87),
(237, 64, 'Spheres', 10, 5, 'F&P3E', 87),
(238, 64, 'Sammardach', 12, 7, 'F&P3E', 87),
(239, 64, 'Brightbuckle', 21, 8, 'F&P3E', 87),
(240, 64, 'Sornyn', 3, 9, 'F&P3E', 87),
(241, 64, 'Sornyn', 4, 9, 'F&P3E', 87),
(242, 64, 'Sornyn', 5, 9, 'F&P3E', 87),
(243, 64, 'Huldark', 17, 11, 'F&P3E', 87),
(244, 64, 'Spryndalstar', 7, 12, 'F&P3E', 87),
(245, 64, 'Marthoon', 1, 14, 'F&P3E', 87),
(246, 64, 'Tehennteahan', 10, 15, 'F&P3E', 87),
(247, 64, 'Orbar', 25, 17, 'F&P3E', 87),
(248, 155, '', 0, 10, 'F&P3E', 90),
(249, 156, '', 0, 2, 'F&P3E', 91),
(250, 157, '', 0, 10, 'F&P3E', 92),
(251, 157, '', 0, 18, 'F&P3E', 92),
(252, 158, '', 3, 4, 'F&P3E', 92),
(253, 1, 'Greening', 0, 6, 'F&P3E', 93),
(254, 7, '', 20, 14, 'F&P3E', 94),
(255, 9, 'Unveiling', 0, 2, 'F&P3E', 95),
(256, 9, 'Binding', 30, 15, 'F&P3E', 96),
(257, 159, '', 0, 2, 'F&P3E', 96),
(258, 10, 'Four Feasts', 19, 4, 'F&P3E', 97),
(259, 10, 'Four Feasts', 20, 8, 'F&P3E', 97),
(260, 10, 'Four Feasts', 21, 12, 'F&P3E', 97),
(261, 10, 'Four Feasts', 20, 17, 'F&P3E', 97),
(262, 10, '', 0, 6, 'F&P3E', 97),
(263, 10, '', 0, 10, 'F&P3E', 97),
(264, 10, '', 0, 18, 'F&P3E', 97),
(265, 11, 'Penultimate Thunder', 11, 12, 'F&P3E', 98),
(266, 11, 'Impending Doom', 11, 14, 'F&P3E', 98),
(267, 12, 'Night of Another Year', 30, 17, 'F&P3E', 99),
(268, 161, 'Rite of Pain and Purity', 0, 2, 'F&P3E', 100),
(269, 161, 'Rite of Pain and Purity', 0, 6, 'F&P3E', 100),
(270, 161, 'Rite of Pain and Purity', 0, 10, 'F&P3E', 100),
(271, 161, 'Rite of Pain and Purity', 0, 13, 'F&P3E', 100),
(272, 161, 'Rites of Candle', 12, 1, 'F&P3E', 100),
(273, 161, 'Rites of Candle', 12, 3, 'F&P3E', 100),
(274, 161, 'Rites of Candle', 12, 4, 'F&P3E', 100),
(275, 161, 'Rites of Candle', 12, 5, 'F&P3E', 100),
(276, 161, 'Rites of Candle', 12, 7, 'F&P3E', 100),
(277, 161, 'Rites of Candle', 12, 8, 'F&P3E', 100),
(278, 161, 'Rites of Candle', 12, 9, 'F&P3E', 100),
(279, 161, 'Rites of Candle', 12, 11, 'F&P3E', 100),
(280, 161, 'Rites of Candle', 12, 12, 'F&P3E', 100),
(281, 161, 'Rites of Candle', 12, 14, 'F&P3E', 100),
(282, 161, 'Rites of Candle', 12, 15, 'F&P3E', 100),
(283, 161, 'Rites of Candle', 12, 17, 'F&P3E', 100),
(284, 162, '', 30, 9, 'F&P3E', 101),
(285, 162, '', 0, 16, 'F&P3E', 101),
(286, 163, 'Call to the Flowers', 0, 6, 'F&P3E', 102),
(287, 163, 'Grand Revel', 0, 10, 'F&P3E', 102),
(288, 15, 'Festival of Pride', 1, 4, 'F&P3E', 103),
(289, 15, 'Festival of Pride', 2, 4, 'F&P3E', 103),
(290, 15, 'Festival of Pride', 3, 4, 'F&P3E', 103),
(291, 15, 'Festival of Pride', 4, 4, 'F&P3E', 103),
(292, 15, 'Festival of Pride', 5, 4, 'F&P3E', 103),
(293, 15, 'Festival of Pride', 6, 4, 'F&P3E', 103),
(294, 15, 'Festival of Pride', 7, 4, 'F&P3E', 103),
(295, 15, 'Festival of Pride', 8, 4, 'F&P3E', 103),
(296, 15, 'Festival of Pride', 9, 4, 'F&P3E', 103),
(297, 15, 'Festival of Pride', 10, 4, 'F&P3E', 103),
(298, 15, 'Newborn Celebration', 21, 8, 'F&P3E', 103),
(299, 15, 'Newborn Celebration', 22, 8, 'F&P3E', 103),
(300, 15, 'Newborn Celebration', 23, 8, 'F&P3E', 103),
(301, 15, 'Newborn Celebration', 24, 8, 'F&P3E', 103),
(302, 15, 'Newborn Celebration', 25, 8, 'F&P3E', 103),
(303, 15, 'Newborn Celebration', 26, 8, 'F&P3E', 103),
(304, 15, 'Newborn Celebration', 27, 8, 'F&P3E', 103),
(305, 15, 'Newborn Celebration', 28, 8, 'F&P3E', 103),
(306, 15, 'Newborn Celebration', 29, 8, 'F&P3E', 103),
(307, 15, 'Newborn Celebration', 30, 8, 'F&P3E', 103),
(308, 16, '', 0, 16, 'F&P3E', 104),
(309, 16, 'Retreat', 0, 2, 'F&P3E', 104),
(310, 16, 'Queen\'s Gambit', 1, 5, 'F&P3E', 104),
(311, 17, '', 0, 16, 'F&P3E', 104),
(312, 18, '', 30, 9, 'F&P3E', 105),
(313, 19, '', 0, 2, 'F&P3E', 105),
(314, 19, '', 0, 6, 'F&P3E', 105),
(315, 19, '', 0, 10, 'F&P3E', 105),
(316, 19, '', 0, 13, 'F&P3E', 105),
(317, 19, '', 0, 16, 'F&P3E', 105),
(318, 66, 'The Graverending', 30, 1, 'F&P3E', 112),
(319, 68, 'Masked Lord\'s Embrace', 0, 2, 'F&P3E', 114),
(320, 70, '', 0, 2, 'F&P3E', 116),
(321, 70, '', 0, 10, 'F&P3E', 116),
(322, 72, 'The Rallying', 30, 1, 'F&P3E', 117),
(323, 72, 'The Melding', 5, 7, 'F&P3E', 117),
(324, 73, '', 0, 6, 'F&P3E', 118),
(325, 73, '', 0, 13, 'F&P3E', 118),
(326, 75, '', 0, 6, 'F&P3E', 119),
(327, 75, '', 0, 13, 'F&P3E', 119),
(328, 75, '', 0, 2, 'F&P3E', 119),
(329, 75, '', 0, 10, 'F&P3E', 119),
(330, 76, 'Time of Spawning', 0, 6, 'F&P3E', 120),
(331, 76, 'Commemoration of the Fallen', 0, 16, 'F&P3E', 120),
(332, 79, '', 1, 1, 'F&P3E', 122),
(333, 80, '', 0, 6, 'F&P3E', 122),
(334, 80, '', 0, 10, 'F&P3E', 122),
(335, 83, 'The Dance of Swirling Winds', 19, 4, 'F&P3E', 124),
(336, 83, 'The Dance of Swirling Winds', 21, 12, 'F&P3E', 124),
(337, 84, 'The Melding of the Three', 0, 18, 'F&P3E', 125),
(338, 89, 'Secrets of the Heart', 0, 19, 'F&P3E', 128),
(339, 93, 'Mystic Rites of the Luminous Cloud', 0, 16, 'F&P3E', 130),
(340, 94, '', 0, 2, 'F&P3E', 131),
(341, 95, '', 0, 18, 'F&P3E', 131),
(342, 97, 'The Cloaking', 0, 20, 'F&P3E', 133),
(343, 98, 'Festival of the Ruby', 0, 10, 'F&P3E', 134),
(344, 98, 'Festival of the Star', 0, 2, 'F&P3E', 134),
(345, 99, 'High Forge', 0, 10, 'F&P3E', 134),
(346, 101, 'The Communion of Laughter', 13, 1, 'F&P3E', 135),
(347, 101, 'The Communion of Laughter', 13, 3, 'F&P3E', 135),
(348, 101, 'The Communion of Laughter', 13, 4, 'F&P3E', 135),
(349, 101, 'The Communion of Laughter', 13, 5, 'F&P3E', 135),
(350, 101, 'The Communion of Laughter', 13, 7, 'F&P3E', 135),
(351, 101, 'The Communion of Laughter', 13, 8, 'F&P3E', 135),
(352, 101, 'The Communion of Laughter', 13, 9, 'F&P3E', 135),
(353, 101, 'The Communion of Laughter', 13, 11, 'F&P3E', 135),
(354, 101, 'The Communion of Laughter', 13, 12, 'F&P3E', 135),
(355, 101, 'The Communion of Laughter', 13, 14, 'F&P3E', 135),
(356, 101, 'The Communion of Laughter', 13, 15, 'F&P3E', 135),
(357, 101, 'The Communion of Laughter', 13, 17, 'F&P3E', 135),
(358, 103, '', 19, 4, 'F&P3E', 136),
(359, 103, '', 20, 8, 'F&P3E', 136),
(360, 103, '', 21, 12, 'F&P3E', 136),
(361, 103, '', 20, 17, 'F&P3E', 136),
(362, 104, '', 0, 2, 'F&P3E', 137),
(363, 105, 'Ceremony of Remembrance', 0, 16, 'F&P3E', 137),
(364, 109, 'Earthrisings', 0, 19, 'F&P3E', 140),
(365, 28, 'Sharpening of the Sword', 0, 6, 'F&P3E', 142),
(366, 28, 'Remebrance Ritual', 0, 13, 'F&P3E', 142),
(367, 29, 'Unwrapping', 1, 7, 'F&P3E', 142),
(368, 29, 'Day of Drawing Down', 30, 17, 'F&P3E', 142),
(369, 31, 'Birthing', 1, 8, 'F&P3E', 143),
(370, 31, 'Celebration of the Moon', 30, 9, 'F&P3E', 143),
(371, 32, '', 0, 10, 'F&P3E', 144),
(372, 33, '', 0, 6, 'F&P3E', 144),
(373, 33, '', 0, 13, 'F&P3E', 144),
(374, 34, 'Feast of the Silver Coin', 0, 16, 'F&P3E', 145),
(375, 35, '', 0, 13, 'F&P3E', 146),
(376, 35, '', 0, 2, 'F&P3E', 146),
(377, 38, 'Ceremony of Introspection', 20, 8, 'F&P3E', 148),
(378, 38, 'Ceremony of Introspection', 20, 17, 'F&P3E', 148),
(379, 149, 'Festival of Strength', 0, 19, 'F&P3E', 148),
(380, 150, '', 0, 20, 'F&P3E', 149),
(381, 151, '', 0, 6, 'F&P3E', 150),
(382, 152, '', 0, 20, 'F&P3E', 150),
(383, 152, '', 0, 16, 'F&P3E', 150),
(384, 153, 'Chant in the Abiding Darkness', 0, 20, 'F&P3E', 151),
(385, 154, 'Ceremony of Contagion', 0, 10, 'F&P3E', 151),
(386, 154, 'The Putrescent Death', 30, 1, 'F&P3E', 151);

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

--
-- Table structure for table `pantheon`
--

CREATE TABLE `pantheon` (
  `panindex` int(2) NOT NULL DEFAULT '0',
  `panname` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pantheon`
--

INSERT INTO `pantheon` (`panindex`, `panname`) VALUES
(0, 'Faerun'),
(1, 'Mulhorand & Unther'),
(2, 'Chult'),
(3, 'Monster'),
(4, 'Elf'),
(5, 'Dwarf'),
(6, 'Drow'),
(7, 'Gnome'),
(8, 'Halfling'),
(9, 'Orc');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `calendar`
--
ALTER TABLE `calendar`
  ADD PRIMARY KEY (`calindex`);

--
-- Indexes for table `deity`
--
ALTER TABLE `deity`
  ADD PRIMARY KEY (`deityindex`),
  ADD KEY `name` (`deityname`),
  ADD KEY `pantheon` (`panindex`);

--
-- Indexes for table `event`
--
ALTER TABLE `event`
  ADD PRIMARY KEY (`dayindex`);

--
-- Indexes for table `pantheon`
--
ALTER TABLE `pantheon`
  ADD PRIMARY KEY (`panindex`),
  ADD KEY `name` (`panname`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `calendar`
--
ALTER TABLE `calendar`
  MODIFY `calindex` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `deity`
--
ALTER TABLE `deity`
  MODIFY `deityindex` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=165;

--
-- AUTO_INCREMENT for table `event`
--
ALTER TABLE `event`
  MODIFY `dayindex` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=387;
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 */;
