php-event-calendar.sql

-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: May 15, 2015 at 02:57 AM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;

--
-- Database: `php-event-calendar`
--

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

--
-- Table structure for table `category_assigned`
--

CREATE TABLE IF NOT EXISTS `category_assigned` (
  `handle` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` smallint(5) unsigned NOT NULL,
  `event_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`handle`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `category_assigned`
--

INSERT INTO `category_assigned` (`category_id`, `event_id`) VALUES
(1, 1),
(2, 1),
(1, 2);

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

--
-- Table structure for table `category_types`
--

CREATE TABLE IF NOT EXISTS `category_types` (
  `category_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `category_types`
--

INSERT INTO `category_types` (`title`, `description`) VALUES
('10th Grade', 'stuff'),
('Staff', 'Staff'),
('Test 1', 'Test Category 1'),
('Test 2', 'Test Category 2'),
('Test 3', 'Test'),
('Test 5', 'Long Description Test: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');

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

--
-- Table structure for table `events`
--

CREATE TABLE IF NOT EXISTS `events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event ID',
  `title` varchar(255) NOT NULL COMMENT 'Event Title',
  `description` text COMMENT 'Event Description',
  `start` datetime NOT NULL COMMENT 'Event Start Time',
  `end` datetime NOT NULL COMMENT 'Event End Time',
  `created` datetime NOT NULL COMMENT 'Event Creation Time',
  `author` smallint(5) unsigned NOT NULL COMMENT 'Event Author User ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`title`, `description`, `start`, `end`, `created`, `author`) VALUES
('Test Event 1', 'Test', '2015-05-03 16:00:00', '2015-05-03 16:30:00', '2015-05-03 15:28:24', 1),
('Test Event 2', 'Test', '2015-05-09 00:00:00', '2015-05-10 00:00:00', '2015-05-08 13:54:21', 1);

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

--
-- Table structure for table `permissions`
--

CREATE TABLE IF NOT EXISTS `permissions` (
  `handle` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` smallint(5) unsigned NOT NULL,
  `id` int(10) unsigned DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `level` varchar(255) NOT NULL,
  `expire` datetime DEFAULT NULL,
  PRIMARY KEY (`handle`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` ( `user_id`, `id`, `type`, `level`, `expire`) VALUES
(1, NULL, 'USER', 'ADMIN', NULL),
(1, 1, 'CATEGORY', 'ADMIN', NULL),
(1, 1, 'EVENT', 'ADMIN', NULL);

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'User ID',
  `email` varchar(255) DEFAULT NULL COMMENT 'User Email',
  `firstName` varchar(255) DEFAULT NULL COMMENT 'User''s First Name',
  `lastName` varchar(255) DEFAULT NULL COMMENT 'User''s Last Name',
  `password` char(128) NOT NULL COMMENT 'User Password',
  `created` datetime COMMENT 'Date/Time User Is Created',
  `lastLogin` datetime DEFAULT NULL COMMENT 'User Last Loged In',
  `active` tinyint(1) NOT NULL COMMENT 'If the account is active',
  `expires` datetime DEFAULT NULL COMMENT 'When the account expires',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`email`, `firstName`, `lastName`, `password`, `created`, `lastLogin`, `active`, `expires`) VALUES
('admin@test.com', 'ADMIN', 'ADMIN', '$2y$10$PjLnekS72iDNSYBGdQSqJe6gWNfXQb.YM.d9fW85hp2xJSL2mhX8q', '2015-04-23 17:36:20', NULL, 1, NULL),
('test2@test.com', 'User2', 'uid=2', '$2y$10$zG8Dh/v9QgXgckdHrZ5gTeokkroz3pf9sssMl/9IfgZEFaDXrrluC', '2015-04-23 17:52:29', NULL, 1, NULL),
('test3@test.com', 'User', '3', '$2y$10$bSqqKYDMQbIo.PdzogcJF.HKaxprEso2sgQCLwj1jCV6AwrkpmKh.', '2015-05-13 22:46:16', NULL, 1, NULL),
('test4@test.com', 'User', '4', '$2y$10$C1vEfueHrmoyP8TV/BSr4es.TodDQwJBW/ey4mmIqN3HsrZY8Okd6', '2015-05-13 22:46:29', NULL, 1, NULL),
('test5@test.com', 'User', '5', '$2y$10$1n7Rw2tal4PcVDLB/Yb.bew34tSOMJeurjQF6p/eMXdL.t6ZBN6WW', '2015-05-13 22:46:42', NULL, 1, NULL),
('test6@test.com', 'User', '6', '$2y$10$d1Hpwl1qvL.vXRa7lkeQsOjLtEGeC9V2vMXiH68LgTPCsKZIdJG4K', '2015-05-13 22:49:26', NULL, 1, NULL);

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