seating_plan.sql

-- phpMyAdmin SQL Dump
-- version 4.5.4.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 09, 2016 at 06:33 AM
-- Server version: 10.1.11-MariaDB-log
-- PHP Version: 7.0.3

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

--
-- Database: `seating_plan`
--

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

--
-- Table structure for table `arrangements`
--

CREATE TABLE `arrangements` (
  `id` int(11) NOT NULL,
  `exam_id` int(11) NOT NULL,
  `room_st_ids` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `exams`
--

CREATE TABLE `exams` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `shift` varchar(32) NOT NULL,
  `time` text NOT NULL,
  `pg_sub_ids` text NOT NULL,
  `room_ids` text NOT NULL,
  `arrangement_data` blob NOT NULL,
  `master` blob NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exams`
--

INSERT INTO `exams` (`id`, `date`, `shift`, `time`, `pg_sub_ids`, `room_ids`, `arrangement_data`, `master`, `status`) VALUES
(19, '2016-02-22', 'First', '10:30AM - 12:30AM', '1:MA101 3:CS303 12:EC635 10:CS633 11:EC675 9:CS699 20:EC675 22:EC635 24:CS673 18:CS633 16:CS661 25:EC663 ', '', 0x613a31353a7b693a303b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2236223b733a383a22636f6c6f756d6e73223b733a313a2238223b733a373a22726f6f6d5f6e6f223b733a363a22494c20313031223b733a343a2264617461223b613a363a7b693a313b613a383a7b693a313b733a31303a2231352f4943532f303031223b693a323b733a31303a2231332f4943532f303032223b693a333b733a31303a2231352f4943532f303037223b693a343b733a31303a2231332f4943532f303038223b693a353b733a31303a2231352f4943532f303134223b693a363b733a31303a2231332f4943532f303134223b693a373b733a31303a2231352f4943532f303230223b693a383b733a31303a2231332f4943532f303230223b7d693a323b613a383a7b693a313b733a31303a2231352f4943532f303032223b693a323b733a31303a2231332f4943532f303033223b693a333b733a31303a2231352f4943532f303038223b693a343b733a31303a2231332f4943532f303039223b693a353b733a31303a2231352f4943532f303135223b693a363b733a31303a2231332f4943532f303135223b693a373b733a31303a2231352f4943532f303232223b693a383b733a31303a2231332f4943532f303231223b7d693a333b613a383a7b693a313b733a31303a2231352f4943532f303033223b693a323b733a31303a2231332f4943532f303034223b693a333b733a31303a2231352f4943532f303039223b693a343b733a31303a2231332f4943532f303130223b693a353b733a31303a2231352f4943532f303136223b693a363b733a31303a2231332f4943532f303136223b693a373b733a31303a2231352f4943532f303233223b693a383b733a31303a2231332f4943532f303232223b7d693a343b613a383a7b693a313b733a31303a2231352f4943532f303034223b693a323b733a31303a2231332f4943532f303035223b693a333b733a31303a2231352f4943532f303130223b693a343b733a31303a2231332f4943532f303131223b693a353b733a31303a2231352f4943532f303137223b693a363b733a31303a2231332f4943532f303137223b693a373b733a31303a2231352f4943532f303234223b693a383b733a31303a2231332f4943532f303233223b7d693a353b613a383a7b693a313b733a31303a2231352f4943532f303035223b693a323b733a31303a2231332f4943532f303036223b693a333b733a31303a2231352f4943532f303132223b693a343b733a31303a2231332f4943532f303132223b693a353b733a31303a2231352f4943532f303138223b693a363b733a31303a2231332f4943532f303138223b693a373b733a31303a2231352f4943532f303235223b693a383b733a31303a2231332f4943532f303234223b7d693a363b613a383a7b693a313b733a31303a2231352f4943532f303036223b693a323b733a31303a2231332f4943532f303037223b693a333b733a31303a2231352f4943532f303133223b693a343b733a31303a2231332f4943532f303133223b693a353b733a31303a2231352f4943532f303139223b693a363b733a31303a2231332f4943532f303139223b693a373b733a31303a2231352f4943532f303236223b693a383b733a31303a2231332f4943532f303236223b7d7d733a31323a226f64645f7375626a65637473223b613a313a7b693a303b733a353a224d41313031223b7d733a31333a226576656e5f7375626a65637473223b613a313a7b693a303b733a353a224353333033223b7d7d693a313b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2236223b733a383a22636f6c6f756d6e73223b733a313a2238223b733a373a22726f6f6d5f6e6f223b733a363a22494c20313032223b733a343a2264617461223b613a363a7b693a313b613a383a7b693a313b733a31303a2231352f4943532f303237223b693a323b733a31303a2231332f4943532f303237223b693a333b733a31303a2231352f4943532f303333223b693a343b733a31303a2231332f4943532f303334223b693a353b733a31303a2231352f4943532f303339223b693a363b733a31303a2231332f4943532f303431223b693a373b733a31303a2231352f4943532f303435223b693a383b733a31303a2231332f4943532f303437223b7d693a323b613a383a7b693a313b733a31303a2231352f4943532f303238223b693a323b733a31303a2231332f4943532f303238223b693a333b733a31303a2231352f4943532f303334223b693a343b733a31303a2231332f4943532f303335223b693a353b733a31303a2231352f4943532f303430223b693a363b733a31303a2231332f4943532f303432223b693a373b733a31303a2231352f4943532f303436223b693a383b733a31303a2231332f4943532f303438223b7d693a333b613a383a7b693a313b733a31303a2231352f4943532f303239223b693a323b733a31303a2231332f4943532f303330223b693a333b733a31303a2231352f4943532f303335223b693a343b733a31303a2231332f4943532f303336223b693a353b733a31303a2231352f4943532f303431223b693a363b733a31303a2231332f4943532f303433223b693a373b733a31303a2231352f4943532f303437223b693a383b733a31303a2231332f4943532f303439223b7d693a343b613a383a7b693a313b733a31303a2231352f4943532f303330223b693a323b733a31303a2231332f4943532f303331223b693a333b733a31303a2231352f4943532f303336223b693a343b733a31303a2231332f4943532f303337223b693a353b733a31303a2231352f4943532f303432223b693a363b733a31303a2231332f4943532f303434223b693a373b733a31303a2231352f4943532f303438223b693a383b733a31303a2231332f4943532f303530223b7d693a353b613a383a7b693a313b733a31303a2231352f4943532f303331223b693a323b733a31303a2231332f4943532f303332223b693a333b733a31303a2231352f4943532f303337223b693a343b733a31303a2231332f4943532f303338223b693a353b733a31303a2231352f4943532f303433223b693a363b733a31303a2231332f4943532f303435223b693a373b733a31303a2231352f4943532f303439223b693a383b733a31303a2231332f4943532f303531223b7d693a363b613a383a7b693a313b733a31303a2231352f4943532f303332223b693a323b733a31303a2231332f4943532f303333223b693a333b733a31303a2231352f4943532f303338223b693a343b733a31303a2231332f4943532f303430223b693a353b733a31303a2231352f4943532f303434223b693a363b733a31303a2231332f4943532f303436223b693a373b733a31303a2231352f4943532f303530223b693a383b733a31303a2231332f4943532f303532223b7d7d733a31323a226f64645f7375626a65637473223b613a313a7b693a303b733a353a224d41313031223b7d733a31333a226576656e5f7375626a65637473223b613a313a7b693a303b733a353a224353333033223b7d7d693a323b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2236223b733a383a22636f6c6f756d6e73223b733a323a223130223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323030223b733a343a2264617461223b613a363a7b693a313b613a31303a7b693a313b733a31303a2231352f4943532f303531223b693a323b733a31303a2231332f4943532f303533223b693a333b733a31303a2231352f4943532f303537223b693a343b733a31303a2231332f4943532f303539223b693a353b733a31303a2231352f4943532f303633223b693a363b733a31323a22522031322f4943532f303033223b693a373b733a31303a2231352f4943532f303639223b693a383b733a31313a2231312f4945432f30303220223b693a393b733a31303a2231312f4943532f303032223b693a31303b733a31313a2231312f4945432f30313920223b7d693a323b613a31303a7b693a313b733a31303a2231352f4943532f303532223b693a323b733a31303a2231332f4943532f303534223b693a333b733a31303a2231352f4943532f303538223b693a343b733a31303a2231332f4943532f303632223b693a353b733a31303a2231352f4943532f303634223b693a363b733a31323a22522031322f4943532f303234223b693a373b733a31303a2231352f4943532f303730223b693a383b733a31303a2231312f4945432f303036223b693a393b733a31313a2231312f4943532f30303320223b693a31303b733a31313a2231312f4945432f30323120223b7d693a333b613a31303a7b693a313b733a31303a2231352f4943532f303533223b693a323b733a31303a2231332f4943532f303535223b693a333b733a31303a2231352f4943532f303539223b693a343b733a31303a2231332f4963732f303634223b693a353b733a31303a2231352f4943532f303635223b693a363b733a31323a22522031322f4943532f303334223b693a373b733a31303a2231352f4943532f303731223b693a383b733a31303a2231312f4945432f303037223b693a393b733a31313a2231312f4943532f30303620223b693a31303b733a31313a2231312f4945432f30323420223b7d693a343b613a31303a7b693a313b733a31303a2231352f4943532f303534223b693a323b733a31303a2231332f4943532f303536223b693a333b733a31303a2231352f4943532f303630223b693a343b733a31303a2231332f4943532f303635223b693a353b733a31303a2231352f4943532f303636223b693a363b733a31323a22522031322f4943532f303435223b693a373b733a31303a2231352f4943532f303732223b693a383b733a31303a2231312f4945432f303134223b693a393b733a31313a2231312f4943532f30303820223b693a31303b733a31313a2231312f4945432f30323520223b7d693a353b613a31303a7b693a313b733a31303a2231352f4943532f303535223b693a323b733a31303a2231332f4943532f303537223b693a333b733a31303a2231352f4943532f303631223b693a343b733a31303a2231332f4943532f303636223b693a353b733a31303a2231352f4943532f303637223b693a363b733a31323a22522031322f4943532f303538223b693a373b733a31303a2231352f4943532f303733223b693a383b733a31313a2231312f4945432f30313620223b693a393b733a31313a2231312f4943532f30313220223b693a31303b733a31313a2231312f4945432f30323820223b7d693a363b613a31303a7b693a313b733a31303a2231352f4943532f303536223b693a323b733a31303a2231332f4943532f303538223b693a333b733a31303a2231352f4943532f303632223b693a343b733a31303a2231332f4943532f303637223b693a353b733a31303a2231352f4943532f303638223b693a363b733a31313a2231312f4945432f30303120223b693a373b733a31313a2231312f4943532f30303120223b693a383b733a31303a2231312f4945432f303137223b693a393b733a31303a2231312f4943532f303133223b693a31303b733a31313a2231312f4945432f30323920223b7d7d733a31323a226f64645f7375626a65637473223b613a323a7b693a303b733a353a224d41313031223b693a313b733a353a224353363333223b7d733a31333a226576656e5f7375626a65637473223b613a323a7b693a303b733a353a224353333033223b693a313b733a353a224543363335223b7d7d693a333b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2235223b733a383a22636f6c6f756d6e73223b733a313a2238223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323031223b733a343a2264617461223b613a353a7b693a313b613a383a7b693a313b733a31303a2231312f4945432f303330223b693a323b733a31303a2231312f4943532f303134223b693a333b733a31313a2231312f4945432f30343220223b693a343b733a31313a2231312f4943532f30323020223b693a353b733a31303a2231312f4945432f303536223b693a363b733a31313a2231312f4943532f30333420223b693a373b733a31313a2231312f4945432f30373120223b693a383b733a31313a2231312f4943532f30343220223b7d693a323b613a383a7b693a313b733a31303a2231312f4945432f303333223b693a323b733a31313a2231312f4943532f30313520223b693a333b733a31313a2231312f4945432f30343320223b693a343b733a31313a2231312f4943532f30323320223b693a353b733a31313a2231312f4945432f30353720223b693a363b733a31313a2231312f4943532f30333520223b693a373b733a31313a2231312f4945432f30373220223b693a383b733a31313a2231312f4943532f30343320223b7d693a333b613a383a7b693a313b733a31313a2231312f4945432f30333420223b693a323b733a31313a2231312f4943532f30313720223b693a333b733a31313a2231312f4945432f30343420223b693a343b733a31313a2231312f4943532f30323620223b693a353b733a31313a2231312f4945432f30353820223b693a363b733a31313a2231312f4943532f30333820223b693a373b733a31313a2231312f4945432f30373820223b693a383b733a31313a2231312f4943532f30343420223b7d693a343b613a383a7b693a313b733a31313a2231312f4945432f30333920223b693a323b733a31303a2231312f4943532f303138223b693a333b733a31313a2231312f4945432f30343520223b693a343b733a31313a2231312f4943532f30333120223b693a353b733a31313a2231312f4945432f30363720223b693a363b733a31313a2231312f4943532f30343020223b693a373b733a31313a2231312f4945432f30373920223b693a383b733a31303a2231312f4943532f303435223b7d693a353b613a383a7b693a313b733a31313a2231312f4945432f30343020223b693a323b733a31303a2231312f4943532f303139223b693a333b733a31303a2231312f4945432f303436223b693a343b733a31313a2231312f4943532f30333220223b693a353b733a31313a2231312f4945432f30363920223b693a363b733a31313a2231312f4943532f30343120223b693a373b733a31313a2231312f4945432f30383020223b693a383b733a31313a2231312f4943532f30343820223b7d7d733a31323a226f64645f7375626a65637473223b613a313a7b693a303b733a353a224543363335223b7d733a31333a226576656e5f7375626a65637473223b613a313a7b693a303b733a353a224353363333223b7d7d693a343b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2236223b733a383a22636f6c6f756d6e73223b733a323a223135223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323032223b733a343a2264617461223b613a363a7b693a313b613a31353a7b693a313b733a31313a2231312f4945432f30383120223b693a323b733a31313a2231312f4943532f30343920223b693a333b733a31303a2231312f4945432f313031223b693a343b733a31313a2231312f4943532f30363120223b693a353b733a31313a2231312f4945432f31313320223b693a363b733a31303a2231312f4943532f303639223b693a373b733a31323a22522031302f4945432f303339223b693a383b733a31313a2231312f4943532f30373920223b693a393b733a31313a2231312f4945432f30313220223b693a31303b733a31313a2231312f4943532f30383720223b693a31313b733a31313a2231312f4945432f30353120223b693a31323b733a31313a2231312f4943532f30393820223b693a31333b733a31313a2231312f4945432f30363620223b693a31343b733a31303a2231312f4943532f313037223b693a31353b733a31313a2231312f4945432f30383320223b7d693a323b613a31353a7b693a313b733a31303a2231312f4945432f303832223b693a323b733a31313a2231312f4943532f30353220223b693a333b733a31313a2231312f4945432f31303320223b693a343b733a31313a2231312f4943532f30363220223b693a353b733a31313a2231312f4945432f31313920223b693a363b733a31313a2231312f4943532f30373020223b693a373b733a31323a22522031302f4945432f303533223b693a383b733a31313a2231312f4943532f30383020223b693a393b733a31313a2231312f4945432f30333620223b693a31303b733a31303a2231312f4943532f303838223b693a31313b733a31313a2231312f4945432f30353920223b693a31323b733a31313a2231312f4943532f30393920223b693a31333b733a31313a2231312f4945432f30363820223b693a31343b733a31313a2231312f4943532f31303820223b693a31353b733a31313a2231312f4945432f30383420223b7d693a333b613a31353a7b693a313b733a31313a2231312f4945432f30393120223b693a323b733a31313a2231312f4943532f30353320223b693a333b733a31313a2231312f4945432f31303420223b693a343b733a31313a2231312f4943532f30363420223b693a353b733a31313a2231312f4945432f31323120223b693a363b733a31303a2231312f4943532f303731223b693a373b733a31323a22522031302f4945432f303631223b693a383b733a31303a2231312f4943532f303831223b693a393b733a31313a2231312f4945432f30333720223b693a31303b733a31313a2231312f4943532f30393120223b693a31313b733a31313a2231312f4945432f30363020223b693a31323b733a31313a2231312f4943532f31303020223b693a31333b733a31313a2231312f4945432f30373020223b693a31343b733a31313a2231312f4943532f31313320223b693a31353b733a31313a2231312f4945432f30383820223b7d693a343b613a31353a7b693a313b733a31313a2231312f4945432f30393420223b693a323b733a31303a2231312f4943532f303534223b693a333b733a31303a2231312f4945432f313037223b693a343b733a31313a2231312f4943532f30363520223b693a353b733a31313a2231312f4945432f31323220223b693a363b733a31313a2231312f4943532f30373520223b693a373b733a31303a2231312f4945432f303038223b693a383b733a31313a2231312f4943532f30383320223b693a393b733a31313a2231312f4945432f30343820223b693a31303b733a31303a2231312f4943532f303932223b693a31313b733a31313a2231312f4945432f30363220223b693a31323b733a31313a2231312f4943532f31303220223b693a31333b733a31313a2231312f4945432f30373320223b693a31343b733a31313a2231312f4943532f31313820223b693a31353b733a31313a2231312f4945432f30393220223b7d693a353b613a31353a7b693a313b733a31313a2231312f4945432f30393920223b693a323b733a31313a2231312f4943532f30353720223b693a333b733a31313a2231312f4945432f31303920223b693a343b733a31313a2231312f4943532f30363720223b693a353b733a31303a2231312f4945432f313233223b693a363b733a31313a2231312f4943532f30373720223b693a373b733a31313a2231312f4945432f30313020223b693a383b733a31313a2231312f4943532f30383420223b693a393b733a31313a2231312f4945432f30343920223b693a31303b733a31313a2231312f4943532f30393320223b693a31313b733a31313a2231312f4945432f30363420223b693a31323b733a31313a2231312f4943532f31303320223b693a31333b733a31313a2231312f4945432f30373420223b693a31343b733a31313a2231312f4943532f31323020223b693a31353b733a31313a2231312f4945432f30393620223b7d693a363b613a31353a7b693a313b733a31313a2231312f4945432f31303020223b693a323b733a31303a2231312f4943532f303539223b693a333b733a31313a2231312f4945432f31313120223b693a343b733a31313a2231312f4943532f30363820223b693a353b733a31313a2231312f4945432f31323620223b693a363b733a31313a2231312f4943532f30373820223b693a373b733a31313a2231312f4945432f30313120223b693a383b733a31313a2231312f4943532f30383620223b693a393b733a31313a2231312f4945432f30353020223b693a31303b733a31313a2231312f4943532f30393720223b693a31313b733a31313a2231312f4945432f30363520223b693a31323b733a31313a2231312f4943532f31303420223b693a31333b733a31313a2231312f4945432f30373720223b693a31343b733a31313a2231312f4943532f31323120223b693a31353b733a31303a2231312f4945432f313035223b7d7d733a31323a226f64645f7375626a65637473223b613a323a7b693a303b733a353a224543363335223b693a313b733a353a224543363735223b7d733a31333a226576656e5f7375626a65637473223b613a313a7b693a303b733a353a224353363333223b7d7d693a353b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2235223b733a383a22636f6c6f756d6e73223b733a313a2238223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323033223b733a343a2264617461223b613a353a7b693a313b613a383a7b693a313b733a31313a2231312f4943532f31323220223b693a323b733a31313a2231312f4945432f31303620223b693a333b733a31323a22522031302f4943532f303631223b693a343b733a31313a2231312f4943532f30323520223b693a353b733a31303a2231342f5049542f313330223b693a363b733a31313a2231312f4943532f30393020223b693a373b733a31303a2231342f5049542f313335223b693a383b733a31313a2231312f4943532f31313420223b7d693a323b613a383a7b693a313b733a31303a2231312f4943532f313233223b693a323b733a31313a2231312f4945432f31303820223b693a333b733a31303a2231342f5049542f313236223b693a343b733a31313a2231312f4943532f30323720223b693a353b733a31303a2231342f5049542f313331223b693a363b733a31303a2231312f4943532f303934223b693a373b733a31303a2231342f5049542f303031223b693a383b733a31313a2231312f4943532f31313620223b7d693a333b613a383a7b693a313b733a31323a22522031302f4943532f303134223b693a323b733a31313a2231312f4945432f31313020223b693a333b733a31303a2231342f5049542f313237223b693a343b733a31313a2231312f4943532f30333020223b693a353b733a31303a2231342f5049542f313332223b693a363b733a31303a2231312f4943532f303935223b693a373b733a31303a2231342f5049542f303032223b693a383b733a31303a2231312f4943532f313137223b7d693a343b613a383a7b693a313b733a31323a22522031302f4943532f303139223b693a323b733a31313a2231312f4945432f31313620223b693a333b733a31303a2231342f5049542f313238223b693a343b733a31303a2231312f4943532f303535223b693a353b733a31303a2231342f5049542f313333223b693a363b733a31313a2231312f4943532f30393620223b693a373b733a31303a2231342f5049542f303033223b693a383b733a31323a22522031302f4943532f303734223b7d693a353b613a383a7b693a313b733a31323a22522031302f4943532f303333223b693a323b733a31313a2231312f4945432f31323420223b693a333b733a31303a2231342f5049542f313239223b693a343b733a31313a2231312f4943532f30353620223b693a353b733a31303a2231342f5049542f313334223b693a363b733a31313a2231312f4943532f31313020223b693a373b733a31303a2231342f5049542f303034223b693a383b733a31313a2231312f4945432f30303420223b7d7d733a31323a226f64645f7375626a65637473223b613a333a7b693a303b733a353a224353363333223b693a313b733a353a224543363335223b693a323b733a353a224353363733223b7d733a31333a226576656e5f7375626a65637473223b613a323a7b693a303b733a353a224543363735223b693a313b733a353a224353363939223b7d7d693a363b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2235223b733a383a22636f6c6f756d6e73223b733a313a2238223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323034223b733a343a2264617461223b613a353a7b693a313b613a383a7b693a313b733a31313a2231312f4945432f30323020223b693a323b733a31303a2231342f5049542f313031223b693a333b733a31313a2231312f4945432f30363120223b693a343b733a31303a2231342f5049542f313036223b693a353b733a31303a2231342f5049542f303039223b693a363b733a31303a2231342f5049542f313131223b693a373b733a31303a2231342f5049542f303134223b693a383b733a31303a2231342f5049542f303738223b7d693a323b613a383a7b693a313b733a31313a2231312f4945432f30323220223b693a323b733a31303a2231342f5049542f313032223b693a333b733a31303a2231342f5049542f303035223b693a343b733a31303a2231342f5049542f313037223b693a353b733a31303a2231342f5049542f303130223b693a363b733a31303a2231342f5049542f313132223b693a373b733a31303a2231342f5049542f303135223b693a383b733a31303a2231342f5049542f303739223b7d693a333b613a383a7b693a313b733a31313a2231312f4945432f30333120223b693a323b733a31303a2231342f5049542f313033223b693a333b733a31303a2231342f5049542f303036223b693a343b733a31303a2231342f5049542f313038223b693a353b733a31303a2231342f5049542f303131223b693a363b733a31303a2231342f5049542f313133223b693a373b733a31303a2231342f5049542f303136223b693a383b733a31303a2231342f5049542f303830223b7d693a343b613a383a7b693a313b733a31313a2231312f4945432f30343120223b693a323b733a31303a2231342f5049542f313034223b693a333b733a31303a2231342f5049542f303037223b693a343b733a31303a2231342f5049542f313039223b693a353b733a31303a2231342f5049542f303132223b693a363b733a31303a2231342f5049542f303736223b693a373b733a31303a2231342f5049542f303531223b693a383b733a31303a2231342f5049542f303831223b7d693a353b613a383a7b693a313b733a31303a2231312f4945432f303532223b693a323b733a31303a2231342f5049542f313035223b693a333b733a31303a2231342f5049542f303038223b693a343b733a31303a2231342f5049542f313130223b693a353b733a31303a2231342f5049542f303133223b693a363b733a31303a2231342f5049542f303737223b693a373b733a31303a2231342f5049542f303532223b693a383b733a31303a2231342f5049542f303832223b7d7d733a31323a226f64645f7375626a65637473223b613a333a7b693a303b733a353a224353363939223b693a313b733a353a224353363733223b693a323b733a353a224353363631223b7d733a31333a226576656e5f7375626a65637473223b613a323a7b693a303b733a353a224543363735223b693a313b733a353a224353363333223b7d7d693a373b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2235223b733a383a22636f6c6f756d6e73223b733a313a2238223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323035223b733a343a2264617461223b613a353a7b693a313b613a383a7b693a313b733a31303a2231342f5049542f303833223b693a323b733a31303a2231342f5049542f303533223b693a333b733a31303a2231342f5049542f303838223b693a343b733a31303a2231342f5049542f303239223b693a353b733a353a22454d505459223b693a363b733a31303a2231342f5049542f303334223b693a373b733a353a22454d505459223b693a383b733a353a22454d505459223b7d693a323b613a383a7b693a313b733a31303a2231342f5049542f303834223b693a323b733a31303a2231342f5049542f303534223b693a333b733a31303a2231342f5049542f303839223b693a343b733a31303a2231342f5049542f303330223b693a353b733a353a22454d505459223b693a363b733a31303a2231342f5049542f303335223b693a373b733a353a22454d505459223b693a383b733a353a22454d505459223b7d693a333b613a383a7b693a313b733a31303a2231342f5049542f303835223b693a323b733a31303a2231342f5049542f303236223b693a333b733a353a22454d505459223b693a343b733a31303a2231342f5049542f303331223b693a353b733a353a22454d505459223b693a363b733a353a22454d505459223b693a373b733a353a22454d505459223b693a383b733a353a22454d505459223b7d693a343b613a383a7b693a313b733a31303a2231342f5049542f303836223b693a323b733a31303a2231342f5049542f303237223b693a333b733a353a22454d505459223b693a343b733a31303a2231342f5049542f303332223b693a353b733a353a22454d505459223b693a363b733a353a22454d505459223b693a373b733a353a22454d505459223b693a383b733a353a22454d505459223b7d693a353b613a383a7b693a313b733a31303a2231342f5049542f303837223b693a323b733a31303a2231342f5049542f303238223b693a333b733a353a22454d505459223b693a343b733a31303a2231342f5049542f303333223b693a353b733a353a22454d505459223b693a363b733a353a22454d505459223b693a373b733a353a22454d505459223b693a383b733a353a22454d505459223b7d7d733a31323a226f64645f7375626a65637473223b613a313a7b693a303b733a353a224353363333223b7d733a31333a226576656e5f7375626a65637473223b613a323a7b693a303b733a353a224353363631223b693a313b733a353a224543363633223b7d7d693a383b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2235223b733a383a22636f6c6f756d6e73223b733a313a2238223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323036223b733a343a2264617461223b613a353a7b693a313b613a383a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b693a363b733a353a22454d505459223b693a373b733a353a22454d505459223b693a383b733a353a22454d505459223b7d693a323b613a383a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b693a363b733a353a22454d505459223b693a373b733a353a22454d505459223b693a383b733a353a22454d505459223b7d693a333b613a383a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b693a363b733a353a22454d505459223b693a373b733a353a22454d505459223b693a383b733a353a22454d505459223b7d693a343b613a383a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b693a363b733a353a22454d505459223b693a373b733a353a22454d505459223b693a383b733a353a22454d505459223b7d693a353b613a383a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b693a363b733a353a22454d505459223b693a373b733a353a22454d505459223b693a383b733a353a22454d505459223b7d7d733a31323a226f64645f7375626a65637473223b613a303a7b7d733a31333a226576656e5f7375626a65637473223b613a303a7b7d7d693a393b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2235223b733a383a22636f6c6f756d6e73223b733a313a2235223b733a373a22726f6f6d5f6e6f223b733a363a22495420323031223b733a343a2264617461223b613a353a7b693a313b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a323b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a333b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a343b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a353b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d7d733a31323a226f64645f7375626a65637473223b613a303a7b7d733a31333a226576656e5f7375626a65637473223b613a303a7b7d7d693a31303b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2235223b733a383a22636f6c6f756d6e73223b733a313a2235223b733a373a22726f6f6d5f6e6f223b733a363a22495420323032223b733a343a2264617461223b613a353a7b693a313b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a323b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a333b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a343b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a353b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d7d733a31323a226f64645f7375626a65637473223b613a303a7b7d733a31333a226576656e5f7375626a65637473223b613a303a7b7d7d693a31313b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2235223b733a383a22636f6c6f756d6e73223b733a313a2235223b733a373a22726f6f6d5f6e6f223b733a363a22495420323033223b733a343a2264617461223b613a353a7b693a313b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a323b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a333b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a343b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a353b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d7d733a31323a226f64645f7375626a65637473223b613a303a7b7d733a31333a226576656e5f7375626a65637473223b613a303a7b7d7d693a31323b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2235223b733a383a22636f6c6f756d6e73223b733a313a2235223b733a373a22726f6f6d5f6e6f223b733a363a22495420323034223b733a343a2264617461223b613a353a7b693a313b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a323b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a333b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a343b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a353b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d7d733a31323a226f64645f7375626a65637473223b613a303a7b7d733a31333a226576656e5f7375626a65637473223b613a303a7b7d7d693a31333b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2235223b733a383a22636f6c6f756d6e73223b733a313a2235223b733a373a22726f6f6d5f6e6f223b733a363a22495020313031223b733a343a2264617461223b613a353a7b693a313b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a323b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a333b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a343b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a353b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d7d733a31323a226f64645f7375626a65637473223b613a303a7b7d733a31333a226576656e5f7375626a65637473223b613a303a7b7d7d693a31343b4f3a343a22726f6f6d223a363a7b733a343a22726f7773223b733a313a2235223b733a383a22636f6c6f756d6e73223b733a313a2235223b733a373a22726f6f6d5f6e6f223b733a363a22495020313032223b733a343a2264617461223b613a353a7b693a313b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a323b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a333b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a343b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d693a353b613a353a7b693a313b733a353a22454d505459223b693a323b733a353a22454d505459223b693a333b733a353a22454d505459223b693a343b733a353a22454d505459223b693a353b733a353a22454d505459223b7d7d733a31323a226f64645f7375626a65637473223b613a303a7b7d733a31333a226576656e5f7375626a65637473223b613a303a7b7d7d7d, 0x613a32363a7b693a303b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231352f4943532f303031223b733a333a226d6178223b733a31303a2231352f4943532f303236223b733a373a22726f6f6d5f6e6f223b733a363a22494c20313031223b733a333a22737562223b733a353a224d41313031223b733a31323a226e756d5f73747564656e7473223b693a32343b7d693a313b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231352f4943532f303237223b733a333a226d6178223b733a31303a2231352f4943532f303530223b733a373a22726f6f6d5f6e6f223b733a363a22494c20313032223b733a333a22737562223b733a353a224d41313031223b733a31323a226e756d5f73747564656e7473223b693a32343b7d693a323b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231352f4943532f303531223b733a333a226d6178223b733a31303a2231352f4943532f303733223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323030223b733a333a22737562223b733a353a224d41313031223b733a31323a226e756d5f73747564656e7473223b693a32333b7d693a333b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231332f4943532f303032223b733a333a226d6178223b733a31303a2231332f4943532f303236223b733a373a22726f6f6d5f6e6f223b733a363a22494c20313031223b733a333a22737562223b733a353a224353333033223b733a31323a226e756d5f73747564656e7473223b693a32343b7d693a343b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231332f4943532f303237223b733a333a226d6178223b733a31303a2231332f4943532f303532223b733a373a22726f6f6d5f6e6f223b733a363a22494c20313032223b733a333a22737562223b733a353a224353333033223b733a31323a226e756d5f73747564656e7473223b693a32343b7d693a353b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231332f4943532f303533223b733a333a226d6178223b733a31323a22522031322f4943532f303538223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323030223b733a333a22737562223b733a353a224353333033223b733a31323a226e756d5f73747564656e7473223b693a31373b7d693a363b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31313a2231312f4945432f30303120223b733a333a226d6178223b733a31313a2231312f4945432f30323920223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323030223b733a333a22737562223b733a353a224543363335223b733a31323a226e756d5f73747564656e7473223b693a31333b7d693a373b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231312f4945432f303330223b733a333a226d6178223b733a31313a2231312f4945432f30383020223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323031223b733a333a22737562223b733a353a224543363335223b733a31323a226e756d5f73747564656e7473223b693a32303b7d693a383b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31313a2231312f4945432f30383120223b733a333a226d6178223b733a31323a22522031302f4945432f303631223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323032223b733a333a22737562223b733a353a224543363335223b733a31323a226e756d5f73747564656e7473223b693a32313b7d693a393b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31313a2231312f4943532f30303120223b733a333a226d6178223b733a31303a2231312f4943532f303133223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323030223b733a333a22737562223b733a353a224353363333223b733a31323a226e756d5f73747564656e7473223b693a373b7d693a31303b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231312f4943532f303134223b733a333a226d6178223b733a31313a2231312f4943532f30343820223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323031223b733a333a22737562223b733a353a224353363333223b733a31323a226e756d5f73747564656e7473223b693a32303b7d693a31313b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31313a2231312f4943532f30343920223b733a333a226d6178223b733a31313a2231312f4943532f31323120223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323032223b733a333a22737562223b733a353a224353363333223b733a31323a226e756d5f73747564656e7473223b693a34323b7d693a31323b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31313a2231312f4943532f31323220223b733a333a226d6178223b733a31323a22522031302f4943532f303631223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323033223b733a333a22737562223b733a353a224353363333223b733a31323a226e756d5f73747564656e7473223b693a363b7d693a31333b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231312f4945432f303038223b733a333a226d6178223b733a31303a2231312f4945432f313035223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323032223b733a333a22737562223b733a353a224543363735223b733a31323a226e756d5f73747564656e7473223b693a32373b7d693a31343b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31313a2231312f4945432f31303620223b733a333a226d6178223b733a31313a2231312f4945432f31323420223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323033223b733a333a22737562223b733a353a224543363735223b733a31323a226e756d5f73747564656e7473223b693a353b7d693a31353b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31313a2231312f4943532f30323520223b733a333a226d6178223b733a31313a2231312f4945432f30303420223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323033223b733a333a22737562223b733a353a224353363939223b733a31323a226e756d5f73747564656e7473223b693a31353b7d693a31363b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31313a2231312f4945432f30323020223b733a333a226d6178223b733a31313a2231312f4945432f30363120223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323034223b733a333a22737562223b733a353a224353363939223b733a31323a226e756d5f73747564656e7473223b693a363b7d693a31373b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231342f5049542f313031223b733a333a226d6178223b733a31303a2231342f5049542f313133223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323034223b733a333a22737562223b733a353a224543363735223b733a31323a226e756d5f73747564656e7473223b693a31333b7d693a31383b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231342f5049542f313236223b733a333a226d6178223b733a31303a2231342f5049542f313335223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323033223b733a333a22737562223b733a353a224543363335223b733a31323a226e756d5f73747564656e7473223b693a31303b7d693a31393b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231342f5049542f303031223b733a333a226d6178223b733a31303a2231342f5049542f303034223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323033223b733a333a22737562223b733a353a224353363733223b733a31323a226e756d5f73747564656e7473223b693a343b7d693a32303b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231342f5049542f303035223b733a333a226d6178223b733a31303a2231342f5049542f303136223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323034223b733a333a22737562223b733a353a224353363733223b733a31323a226e756d5f73747564656e7473223b693a31323b7d693a32313b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231342f5049542f303736223b733a333a226d6178223b733a31303a2231342f5049542f303832223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323034223b733a333a22737562223b733a353a224353363333223b733a31323a226e756d5f73747564656e7473223b693a373b7d693a32323b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231342f5049542f303833223b733a333a226d6178223b733a31303a2231342f5049542f303839223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323035223b733a333a22737562223b733a353a224353363333223b733a31323a226e756d5f73747564656e7473223b693a373b7d693a32333b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231342f5049542f303531223b733a333a226d6178223b733a31303a2231342f5049542f303532223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323034223b733a333a22737562223b733a353a224353363631223b733a31323a226e756d5f73747564656e7473223b693a323b7d693a32343b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231342f5049542f303533223b733a333a226d6178223b733a31303a2231342f5049542f303534223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323035223b733a333a22737562223b733a353a224353363631223b733a31323a226e756d5f73747564656e7473223b693a323b7d693a32353b4f3a31343a224d61737465725f456c656d656e74223a353a7b733a333a226d696e223b733a31303a2231342f5049542f303236223b733a333a226d6178223b733a31303a2231342f5049542f303335223b733a373a22726f6f6d5f6e6f223b733a363a22494c20323035223b733a333a22737562223b733a353a224543363633223b733a31323a226e756d5f73747564656e7473223b693a31303b7d7d, 1);

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

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `action` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` (`id`, `user_id`, `date`, `time`, `action`) VALUES
(1, 1, '2016-01-21', '16:47:55', 'Created room number - IP 101'),
(2, 1, '2016-01-21', '16:48:06', 'Created room number - IP 102'),
(3, 1, '2016-01-21', '16:48:17', 'Created room number - IP 201'),
(4, 1, '2016-01-21', '16:52:42', '::1 - Deleted room IP 101 (1)'),
(5, 1, '2016-01-21', '16:52:43', '::1 - Deleted room IP 102 (2)'),
(6, 1, '2016-01-21', '16:52:44', '::1 - Deleted room IP 201 (3)'),
(7, 1, '2016-01-21', '17:04:30', 'Created exam -  () -'),
(8, 1, '2016-02-01', '13:08:18', '::1 - Logged in. (Mozilla/5.0 (Windows NT 6.1; WOW64; rv:43.0) Gecko/20100101 Firefox/43.0 ) '),
(9, 1, '2016-02-02', '10:43:34', '::1 - Logged in. (Mozilla/5.0 (Windows NT 6.1; WOW64; rv:43.0) Gecko/20100101 Firefox/43.0 ) '),
(10, 1, '2016-02-09', '11:41:39', '::1 - Logged in. (Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.103 Safari/537.36 ) ');

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

--
-- Table structure for table `program_details`
--

CREATE TABLE `program_details` (
  `id` int(30) NOT NULL,
  `program` varchar(70) NOT NULL,
  `branch` varchar(60) NOT NULL,
  `semester` int(20) NOT NULL,
  `subjects` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `program_details`
--

INSERT INTO `program_details` (`id`, `program`, `branch`, `semester`, `subjects`) VALUES
(1, 'Dual Degree Program', 'CSE', 1, 'CY101 MA101  CS101 EC101 BS101 ES101 EN101'),
(2, 'Dual Degree Program', 'CSE', 3, 'MA201 EC201 CS201 CS203 CS205 CS207'),
(3, 'Dual Degree Program', 'CSE', 5, 'CS301 CS303 CS305 CS307 CS309 CS311'),
(4, 'Dual Degree Program', 'CSE', 7, 'SS401 CS401 CS403 CS405 MB501 MB507 EC451'),
(5, 'Dual Degree Program', 'ECE', 1, 'CY101 MA101  CS101 EC101 BS101 ES101 EN101'),
(6, 'Dual Degree Program', 'ECE', 3, 'MA201 EC201 EC203 EC205 CS205 EC207'),
(7, 'Dual Degree Program', 'ECE', 5, 'EC301 EC303 EC305 EC307 CS309 CS311'),
(8, 'Dual Degree Program', 'ECE', 7, 'SS401 EC401 EC403 EC405 EC445 MB501 MB507'),
(9, 'Dual Degree Program', 'ISR', 9, 'CS661 CS699 CS663 CS669'),
(10, 'Dual Degree Program', 'SE', 9, 'CS631 CS633 CS641 CS655'),
(11, 'Dual Degree Program', 'VLSI Design', 9, 'EC633 EC675 EC667 EC679'),
(12, 'Dual Degree Program', 'Wireless Comm & Network', 9, 'EC631 EC635 EC641 EC647'),
(13, 'Dual Degree Program', 'CS ', 9, 'CS695 CS673 CS675 CS655'),
(14, 'Dual Degree Program', 'EMB', 9, 'EC661 EC663 EC657 EC669'),
(15, 'M.Tech 2 Year', 'ISR', 1, 'CS521 CS523 CS527 CS525 SO513'),
(16, 'M.Tech 2 Year', 'ISR', 3, 'CS661 CS699 CS663 CS669'),
(17, 'M.Tech 2 Year', 'SE', 1, 'CS521 CS523 CS527 CS525 SO513'),
(18, 'M.Tech 2 Year', 'SE', 3, 'CS631 CS633 CS641 CS655'),
(19, 'M.Tech 2 Year', 'VLSI Design', 1, 'EC535 CS523 CS527 EC531 SO513'),
(20, 'M.Tech 2 Year', 'VLSI Design', 3, 'EC633 EC675 EC667 EC679'),
(21, 'M.Tech 2 Year', 'Wireless Comm & Network', 1, 'EC535 CS523 CS527 EC531 SO513'),
(22, 'M.Tech 2 Year', 'Wireless Comm & Network', 3, 'EC631 EC635 EC641 EC647'),
(23, 'M.Tech 2 Year', 'CS ', 1, 'CS521 CS523 CS527 CS525 SO513'),
(24, 'M.Tech 2 Year', 'CS ', 3, 'CS695 CS673 CS675 CS655'),
(25, 'M.Tech 2 Year', 'EMB', 3, 'EC661 EC663 EC657 EC669');

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

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `id` int(11) NOT NULL,
  `room_no` varchar(40) NOT NULL,
  `rows` int(11) NOT NULL,
  `columns` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` (`id`, `room_no`, `rows`, `columns`) VALUES
(4, 'IL 101', 6, 8),
(5, 'IL 102', 6, 8),
(6, 'IL 200', 6, 10),
(7, 'IL 201', 5, 8),
(8, 'IL 202', 6, 15),
(9, 'IL 203', 5, 8),
(10, 'IL 204', 5, 8),
(11, 'IL 205', 5, 8),
(12, 'IL 206', 5, 8),
(13, 'IT 201', 5, 5),
(14, 'IT 202', 5, 5),
(15, 'IT 203', 5, 5),
(16, 'IT 204', 5, 5),
(17, 'IP 101', 5, 5),
(18, 'IP 102', 5, 5);

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

--
-- Table structure for table `student_details`
--

CREATE TABLE `student_details` (
  `id` int(11) NOT NULL,
  `roll_no` varchar(30) NOT NULL,
  `program_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_details`
--

INSERT INTO `student_details` (`id`, `roll_no`, `program_id`) VALUES
(1, '11/ICS/001 ', 10),
(2, '11/ICS/002', 10),
(3, '11/ICS/003 ', 10),
(4, '11/ICS/006 ', 10),
(5, '11/ICS/008 ', 10),
(6, '11/ICS/012 ', 10),
(7, '11/ICS/013', 10),
(8, '11/ICS/014', 10),
(9, '11/ICS/015 ', 10),
(10, '11/ICS/017 ', 10),
(11, '11/ICS/018', 10),
(12, '11/ICS/019', 10),
(13, '11/ICS/020 ', 10),
(14, '11/ICS/023 ', 10),
(15, '11/ICS/025 ', 9),
(16, '11/ICS/026 ', 10),
(17, '11/ICS/027 ', 9),
(18, '11/ICS/030 ', 9),
(19, '11/ICS/031 ', 10),
(20, '11/ICS/032 ', 10),
(21, '11/ICS/034 ', 10),
(22, '11/ICS/035 ', 10),
(23, '11/ICS/038 ', 10),
(24, '11/ICS/040 ', 10),
(25, '11/ICS/041 ', 10),
(26, '11/ICS/042 ', 10),
(27, '11/ICS/043 ', 10),
(28, '11/ICS/044 ', 10),
(29, '11/ICS/045', 10),
(30, '11/ICS/048 ', 10),
(31, '11/ICS/049 ', 10),
(32, '11/ICS/052 ', 10),
(33, '11/ICS/053 ', 10),
(34, '11/ICS/054', 10),
(35, '11/ICS/055', 9),
(36, '11/ICS/056 ', 9),
(37, '11/ICS/057 ', 10),
(38, '11/ICS/059', 10),
(39, '11/ICS/061 ', 10),
(40, '11/ICS/062 ', 10),
(41, '11/ICS/064 ', 10),
(42, '11/ICS/065 ', 10),
(43, '11/ICS/067 ', 10),
(44, '11/ICS/068 ', 10),
(45, '11/ICS/069', 10),
(46, '11/ICS/070 ', 10),
(47, '11/ICS/071', 10),
(48, '11/ICS/075 ', 10),
(49, '11/ICS/077 ', 10),
(50, '11/ICS/078 ', 10),
(51, '11/ICS/079 ', 10),
(52, '11/ICS/080 ', 10),
(53, '11/ICS/081', 10),
(54, '11/ICS/083 ', 10),
(55, '11/ICS/084 ', 10),
(56, '11/ICS/086 ', 10),
(57, '11/ICS/087 ', 10),
(58, '11/ICS/088', 10),
(59, '11/ICS/090 ', 9),
(60, '11/ICS/091 ', 10),
(61, '11/ICS/092', 10),
(62, '11/ICS/093 ', 10),
(63, '11/ICS/094', 9),
(64, '11/ICS/095', 9),
(65, '11/ICS/096 ', 9),
(66, '11/ICS/097 ', 10),
(67, '11/ICS/098 ', 10),
(68, '11/ICS/099 ', 10),
(69, '11/ICS/100 ', 10),
(70, '11/ICS/102 ', 10),
(71, '11/ICS/103 ', 10),
(72, '11/ICS/104 ', 10),
(73, '11/ICS/107', 10),
(74, '11/ICS/108 ', 10),
(75, '11/ICS/110 ', 9),
(76, '11/ICS/113 ', 10),
(77, '11/ICS/114 ', 9),
(78, '11/ICS/116 ', 9),
(79, '11/ICS/117', 9),
(80, '11/ICS/118 ', 10),
(81, '11/ICS/120 ', 10),
(82, '11/ICS/121 ', 10),
(83, '11/ICS/122 ', 10),
(84, '11/ICS/123', 10),
(85, 'R 10/ICS/014', 10),
(86, 'R 10/ICS/019', 10),
(87, 'R 10/ICS/033', 10),
(88, 'R 10/ICS/061', 10),
(89, 'R 10/ICS/074', 9),
(90, '11/IEC/001 ', 12),
(91, '11/IEC/002 ', 12),
(92, '11/IEC/004 ', 9),
(93, '11/IEC/006', 12),
(94, '11/IEC/007', 12),
(95, '11/IEC/008', 11),
(96, '11/IEC/010 ', 11),
(97, '11/IEC/011 ', 11),
(98, '11/IEC/012 ', 11),
(99, '11/IEC/014', 12),
(100, '11/IEC/016 ', 12),
(101, '11/IEC/017', 12),
(102, '11/IEC/019 ', 12),
(103, '11/IEC/020 ', 9),
(104, '11/IEC/021 ', 12),
(105, '11/IEC/022 ', 9),
(106, '11/IEC/024 ', 12),
(107, '11/IEC/025 ', 12),
(108, '11/IEC/028 ', 12),
(109, '11/IEC/029 ', 12),
(110, '11/IEC/030', 12),
(111, '11/IEC/031 ', 9),
(112, '11/IEC/033', 12),
(113, '11/IEC/034 ', 12),
(114, '11/IEC/036 ', 11),
(115, '11/IEC/037 ', 11),
(116, '11/IEC/039 ', 12),
(117, '11/IEC/040 ', 12),
(118, '11/IEC/041 ', 9),
(119, '11/IEC/042 ', 12),
(120, '11/IEC/043 ', 12),
(121, '11/IEC/044 ', 12),
(122, '11/IEC/045 ', 12),
(123, '11/IEC/046', 12),
(124, '11/IEC/048 ', 11),
(125, '11/IEC/049 ', 11),
(126, '11/IEC/050 ', 11),
(127, '11/IEC/051 ', 11),
(128, '11/IEC/052', 9),
(129, '11/IEC/056', 12),
(130, '11/IEC/057 ', 12),
(131, '11/IEC/058 ', 12),
(132, '11/IEC/059 ', 11),
(133, '11/IEC/060 ', 11),
(134, '11/IEC/061 ', 9),
(135, '11/IEC/062 ', 11),
(136, '11/IEC/064 ', 11),
(137, '11/IEC/065 ', 11),
(138, '11/IEC/066 ', 11),
(139, '11/IEC/067 ', 12),
(140, '11/IEC/068 ', 11),
(141, '11/IEC/069 ', 12),
(142, '11/IEC/070 ', 11),
(143, '11/IEC/071 ', 12),
(144, '11/IEC/072 ', 12),
(145, '11/IEC/073 ', 11),
(146, '11/IEC/074 ', 11),
(147, '11/IEC/077 ', 11),
(148, '11/IEC/078 ', 12),
(149, '11/IEC/079 ', 12),
(150, '11/IEC/080 ', 12),
(151, '11/IEC/081 ', 12),
(152, '11/IEC/082', 12),
(153, '11/IEC/083 ', 11),
(154, '11/IEC/084 ', 11),
(155, '11/IEC/088 ', 11),
(156, '11/IEC/091 ', 12),
(157, '11/IEC/092 ', 11),
(158, '11/IEC/094 ', 12),
(159, '11/IEC/096 ', 11),
(160, '11/IEC/099 ', 12),
(161, '11/IEC/100 ', 12),
(162, '11/IEC/101', 12),
(163, '11/IEC/103 ', 12),
(164, '11/IEC/104 ', 12),
(165, '11/IEC/105', 11),
(166, '11/IEC/106 ', 11),
(167, '11/IEC/107', 12),
(168, '11/IEC/108 ', 11),
(169, '11/IEC/109 ', 12),
(170, '11/IEC/110 ', 11),
(171, '11/IEC/111 ', 12),
(172, '11/IEC/113 ', 12),
(173, '11/IEC/116 ', 11),
(174, '11/IEC/119 ', 12),
(175, '11/IEC/121 ', 12),
(176, '11/IEC/122 ', 12),
(177, '11/IEC/123', 12),
(178, '11/IEC/124 ', 11),
(179, '11/IEC/126 ', 12),
(180, 'R 10/IEC/039', 12),
(181, 'R 10/IEC/053', 12),
(182, 'R 10/IEC/061', 12),
(183, '12/ICS/001', 4),
(184, '12/ICS/002', 4),
(185, '12/ICS/003', 4),
(186, '12/ICS/004', 4),
(187, '12/ICS/005', 4),
(188, '12/ICS/006', 4),
(189, '12/ICS/007', 4),
(190, '12/ICS/008', 4),
(191, '12/ICS/009', 4),
(192, '12/ICS/010', 4),
(193, '12/ICS/011', 4),
(194, '12/ICS/012', 4),
(195, '12/ICS/013', 4),
(196, '12/ICS/014', 4),
(197, '12/ICS/015', 4),
(198, '12/ICS/016', 4),
(199, '12/ICS/017', 4),
(200, '12/ICS/018', 4),
(201, '12/ICS/019', 4),
(202, '12/ICS/020', 4),
(203, '12/ICS/021', 4),
(204, '12/ICS/022', 4),
(205, '12/ICS/023', 4),
(206, '12/ICS/024', 4),
(207, '12/ICS/025', 4),
(208, '12/ICS/026', 4),
(209, '12/ICS/027', 4),
(210, '12/ICS/028', 4),
(211, '12/ICS/029', 4),
(212, '12/ICS/030', 4),
(213, '12/ICS/031', 4),
(214, '12/ICS/032', 4),
(215, '12/ICS/033', 4),
(216, '12/ICS/034', 4),
(217, '12/ICS/035', 4),
(218, '12/ICS/036', 4),
(219, '12/ICS/037', 4),
(220, '12/ICS/038', 4),
(221, '12/ICS/039', 4),
(222, '12/ICS/040', 4),
(223, '12/ICS/041', 4),
(224, '12/ICS/042', 4),
(225, '12/ICS/043', 4),
(226, '12/ICS/045', 4),
(227, '12/ICS/046', 4),
(228, '12/ICS/047', 4),
(229, '12/ICS/048', 4),
(230, '12/ICS/049', 4),
(231, '12/ICS/050', 4),
(232, '12/ICS/051', 4),
(233, '12/ICS/052', 4),
(234, '12/ICS/053', 4),
(235, '12//ICS/054', 4),
(236, '12/ICS/055', 4),
(237, '12/ICS/057', 4),
(238, '12/ICS/058', 4),
(239, '12/ICS/059', 4),
(240, '12/ICS/060', 4),
(241, '12/ICS/061', 4),
(242, '12/ICS/062', 4),
(243, '12/ICS/063', 4),
(244, '12/ICS/064', 4),
(245, '12/ICS/065', 4),
(246, '12/ICS/066', 4),
(247, '12/ICS/067', 4),
(248, '12/ICS/068', 4),
(249, '12/ICS/069', 4),
(250, '12/ICS/070', 4),
(251, 'R11/ICS/073', 4),
(252, 'R11/ICS/085', 4),
(253, '12/IEC/001', 8),
(254, '12/IEC/002', 8),
(255, '12/IEC/004', 8),
(256, '12/IEC/006', 8),
(257, '12/IEC/007', 8),
(258, '12/IEC/008', 8),
(259, '12/IEC/009', 8),
(260, '12/IEC/010', 8),
(261, '12/IEC/011', 8),
(262, '12/IEC/012', 8),
(263, '12/IEC/013', 8),
(264, '12/IEC/014', 8),
(265, '12/IEC/015', 8),
(266, '12/IEC/016', 8),
(267, '12/IEC/017', 8),
(268, '12/IEC/018', 8),
(269, '12/IEC/020', 8),
(270, '12/IEC/021', 8),
(271, '12/IEC/022', 8),
(272, '12/IEC/023', 8),
(273, '12/IEC/024', 8),
(274, '12/IEC/026', 8),
(275, '12/IEC/027', 8),
(276, '12/IEC/028', 8),
(277, '12/IEC/029', 8),
(278, '12/IEC/030', 8),
(279, '12/IEC/031', 8),
(280, '12/IEC/032', 8),
(281, '12/IEC/033', 8),
(282, '12/IEC/034', 8),
(283, '12/IEC/035', 8),
(284, '12/IEC/036', 8),
(285, '12/IEC/037', 8),
(286, '12/IEC/038', 8),
(287, '12/IEC/041', 8),
(288, '12/IEC/043', 8),
(289, '12/IEC/044', 8),
(290, '12/IEC/045', 8),
(291, '12/IEC/046', 8),
(292, '12/IEC/047', 8),
(293, '12/IEC/048', 8),
(294, '12/IEC/049', 8),
(295, '12/IEC/051', 8),
(296, '12/IEC/053', 8),
(297, '12/IEC/054', 8),
(298, '12/IEC/055', 8),
(299, '12/IEC/056', 8),
(300, '12/IEC/059', 8),
(301, '12/IEC/060', 8),
(302, '12/IEC/061', 8),
(303, '12/IEC/062', 8),
(304, '12/IEC/064', 8),
(305, '12/IEC/065', 8),
(306, '12/IEC/066', 8),
(307, '12/IEC/067', 8),
(308, '12/IEC/068', 8),
(309, '12/IEC/069', 8),
(310, '12/IEC/072', 8),
(311, 'R11/IEC/003', 8),
(312, 'R11/IEC/063', 8),
(313, '13/ICS/002', 3),
(314, '13/ICS/003', 3),
(315, '13/ICS/004', 3),
(316, '13/ICS/005', 3),
(317, '13/ICS/006', 3),
(318, '13/ICS/007', 3),
(319, '13/ICS/008', 3),
(320, '13/ICS/009', 3),
(321, '13/ICS/010', 3),
(322, '13/ICS/011', 3),
(323, '13/ICS/012', 3),
(324, '13/ICS/013', 3),
(325, '13/ICS/014', 3),
(326, '13/ICS/015', 3),
(327, '13/ICS/016', 3),
(328, '13/ICS/017', 3),
(329, '13/ICS/018', 3),
(330, '13/ICS/019', 3),
(331, '13/ICS/020', 3),
(332, '13/ICS/021', 3),
(333, '13/ICS/022', 3),
(334, '13/ICS/023', 3),
(335, '13/ICS/024', 3),
(336, '13/ICS/026', 3),
(337, '13/ICS/027', 3),
(338, '13/ICS/028', 3),
(339, '13/ICS/030', 3),
(340, '13/ICS/031', 3),
(341, '13/ICS/032', 3),
(342, '13/ICS/033', 3),
(343, '13/ICS/034', 3),
(344, '13/ICS/035', 3),
(345, '13/ICS/036', 3),
(346, '13/ICS/037', 3),
(347, '13/ICS/038', 3),
(348, '13/ICS/040', 3),
(349, '13/ICS/041', 3),
(350, '13/ICS/042', 3),
(351, '13/ICS/043', 3),
(352, '13/ICS/044', 3),
(353, '13/ICS/045', 3),
(354, '13/ICS/046', 3),
(355, '13/ICS/047', 3),
(356, '13/ICS/048', 3),
(357, '13/ICS/049', 3),
(358, '13/ICS/050', 3),
(359, '13/ICS/051', 3),
(360, '13/ICS/052', 3),
(361, '13/ICS/053', 3),
(362, '13/ICS/054', 3),
(363, '13/ICS/055', 3),
(364, '13/ICS/056', 3),
(365, '13/ICS/057', 3),
(366, '13/ICS/058', 3),
(367, '13/ICS/059', 3),
(368, '13/ICS/062', 3),
(369, '13/Ics/064', 3),
(370, '13/ICS/065', 3),
(371, '13/ICS/066', 3),
(372, '13/ICS/067', 3),
(373, 'R 12/ICS/003', 3),
(374, 'R 12/ICS/024', 3),
(375, 'R 12/ICS/034', 3),
(376, 'R 12/ICS/045', 3),
(377, 'R 12/ICS/058', 3),
(378, '13/IEC/001', 7),
(379, '13/IEC/002', 7),
(380, '13/IEC/003', 7),
(381, '13/IEC/004', 7),
(382, '13/IEC/005', 7),
(383, '13/IEC/006', 7),
(384, '13/IEC/007', 7),
(385, '13/IEC/008', 7),
(386, '13/IEC/009', 7),
(387, '13/IEC/010', 7),
(388, '13/IEC/011', 7),
(389, '13/IEC/013', 7),
(390, '13/IEC/014', 7),
(391, '13/IEC/015', 7),
(392, '13/IEC/016', 7),
(393, '13/IEC/018', 7),
(394, '13/IEC/019', 7),
(395, '13/IEC/020', 7),
(396, '13/IEC/021', 7),
(397, '13/IEC/022', 7),
(398, '13/IEC/023', 7),
(399, '13/IEC/025', 7),
(400, '13/IEC/026', 7),
(401, '13/IEC/027', 7),
(402, '13/IEC/028', 7),
(403, '13/IEC/029', 7),
(404, '13/IEC/032', 7),
(405, '13/IEC/033', 7),
(406, '13/IEC/034', 7),
(407, '13/IEC/037', 7),
(408, '13/IEC/040', 7),
(409, '13/IEC/041', 7),
(410, '13/IEC/042', 7),
(411, '13/IEC/043', 7),
(412, '13/IEC/045', 7),
(413, '13/IEC/047', 7),
(414, '13/IEC/048', 7),
(415, '13/IEC/049', 7),
(416, '13/IEC/050', 7),
(417, '13/IEC/051', 7),
(418, '13/IEC/054', 7),
(419, '13/IEC/055', 7),
(420, '13/IEC/056', 7),
(421, '13/IEC/058', 7),
(422, '13/IEC/059', 7),
(423, '13/IEC/060', 7),
(424, '13/IEC/061', 7),
(425, '13/IEC/062', 7),
(426, '13/IEC/063', 7),
(427, 'R 12/IEC/072', 7),
(428, '14/ICS/001', 2),
(429, '14/ICS/002', 2),
(430, '14/ICS/003', 2),
(431, '14/ICS/004', 2),
(432, '14/ICS/005', 2),
(433, '14/ICS/006', 2),
(434, '14/ICS/007', 2),
(435, '14/ICS/009', 2),
(436, '14/ICS/010', 2),
(437, '14/ICS/011', 2),
(438, '14/ICS/012', 2),
(439, '14/ICS/013', 2),
(440, '14/ICS/014', 2),
(441, '14/ICS/016', 2),
(442, '14/ICS/017', 2),
(443, '14/ICS/018', 2),
(444, '14/ICS/020', 2),
(445, '14/ICS/021', 2),
(446, '14/ICS/022', 2),
(447, '14/ICS/023', 2),
(448, '14/ICS/024', 2),
(449, '14/ICS/025', 2),
(450, '14/ICS/027', 2),
(451, '14/ICS/028', 2),
(452, '14/ICS/029', 2),
(453, '14/ICS/030', 2),
(454, '14/ICS/031', 2),
(455, '14/ICS/032', 2),
(456, '14/ICS/033', 2),
(457, '14/ICS/034', 2),
(458, '14/ICS/035', 2),
(459, '14/ICS/036', 2),
(460, '14/ICS/037', 2),
(461, '14/ICS/038', 2),
(462, '14/ICS/039', 2),
(463, '14/ICS/041', 2),
(464, '14/ICS/042', 2),
(465, '14/ICS/043', 2),
(466, '14/ICS/044', 2),
(467, '14/ICS/045', 2),
(468, '14/ICS/047', 2),
(469, '14/ICS/048', 2),
(470, '14/ICS/049', 2),
(471, '14/ICS/050', 2),
(472, '14/ICS/051', 2),
(473, '14/ICS/052', 2),
(474, '14/ICS/053', 2),
(475, '14/ICS/055', 2),
(476, '14/ICS/056', 2),
(477, '14/ICS/057', 2),
(478, '14/ICS/058', 2),
(479, '14/ICS/059', 2),
(480, '14/ICS/060', 2),
(481, '14/ICS/061', 2),
(482, '14/ICS/062', 2),
(483, '14/ICS/064', 2),
(484, '14/ICS/065', 2),
(485, '14/ICS/066', 2),
(486, '14/ICS/067', 2),
(487, '14/ICS/068', 2),
(488, '14/ICS/069', 2),
(489, '14/ICS/070', 2),
(490, '14/ICS/071', 2),
(491, 'R13/ICS/029', 2),
(492, 'R13/ICS/063', 2),
(493, '14/IEC/001', 6),
(494, '14/IEC/002', 6),
(495, '14/IEC/003', 6),
(496, '14/IEC/004', 6),
(497, '14/IEC/005', 6),
(498, '14/IEC/006', 6),
(499, '14/IEC/007', 6),
(500, '14/IEC/008', 6),
(501, '14/IEC/009', 6),
(502, '14/IEC/010', 6),
(503, '14/IEC/011', 6),
(504, '14/IEC/012', 6),
(505, '14/IEC/014', 6),
(506, '14/IEC/015', 6),
(507, '14/IEC/017', 6),
(508, '14/IEC/018', 6),
(509, '14/IEC/019', 6),
(510, '14/IEC/020', 6),
(511, '14/IEC/021', 6),
(512, '14/IEC/022', 6),
(513, '14/IEC/023', 6),
(514, '14/IEC/024', 6),
(515, '14/IEC/025', 6),
(516, '14/IEC/026', 6),
(517, '14/IEC/027', 6),
(518, '14/IEC/029', 6),
(519, '14/IEC/030', 6),
(520, '14/IEC/032', 6),
(521, '14/IEC/033', 6),
(522, '14/IEC/034', 6),
(523, '14/IEC/036', 6),
(524, '14/IEC/037', 6),
(525, '14/IEC/038', 6),
(526, '14/IEC/039', 6),
(527, '14/IEC/040', 6),
(528, '14/IEC/041', 6),
(529, '14/IEC/042', 6),
(530, '14/IEC/043', 6),
(531, '14/IEC/044', 6),
(532, '14/IEC/045', 6),
(533, '14/IEC/047', 6),
(534, '14/IEC/048', 6),
(535, '14/IEC/049', 6),
(536, '14/IEC/050', 6),
(537, '14/IEC/052', 6),
(538, '14/IEC/053', 6),
(539, '14/IEC/054', 6),
(540, '14/IEC/056', 6),
(541, '14/IEC/058', 6),
(542, '14/IEC/060', 6),
(543, '14/IEC/062', 6),
(544, '14/IEC/063', 6),
(545, '14/IEC/064', 6),
(546, '14/IEC/065', 6),
(547, '14/IEC/066', 6),
(548, '14/IEC/068', 6),
(549, '15/LEC/001', 6),
(550, '15/LEC/002', 6),
(551, '15/LEC/003', 6),
(552, 'R13/IEC/036', 6),
(553, 'R 13/IEC/038', 6),
(554, 'R 13/IEC/052', 6),
(555, 'R 13/IEC/053', 6),
(556, 'R13/IEC/057', 6),
(557, '15/ICS/001', 1),
(558, '15/ICS/002', 1),
(559, '15/ICS/003', 1),
(560, '15/ICS/004', 1),
(561, '15/ICS/005', 1),
(562, '15/ICS/006', 1),
(563, '15/ICS/007', 1),
(564, '15/ICS/008', 1),
(565, '15/ICS/009', 1),
(566, '15/ICS/010', 1),
(567, '15/ICS/012', 1),
(568, '15/ICS/013', 1),
(569, '15/ICS/014', 1),
(570, '15/ICS/015', 1),
(571, '15/ICS/016', 1),
(572, '15/ICS/017', 1),
(573, '15/ICS/018', 1),
(574, '15/ICS/019', 1),
(575, '15/ICS/020', 1),
(576, '15/ICS/022', 1),
(577, '15/ICS/023', 1),
(578, '15/ICS/024', 1),
(579, '15/ICS/025', 1),
(580, '15/ICS/026', 1),
(581, '15/ICS/027', 1),
(582, '15/ICS/028', 1),
(583, '15/ICS/029', 1),
(584, '15/ICS/030', 1),
(585, '15/ICS/031', 1),
(586, '15/ICS/032', 1),
(587, '15/ICS/033', 1),
(588, '15/ICS/034', 1),
(589, '15/ICS/035', 1),
(590, '15/ICS/036', 1),
(591, '15/ICS/037', 1),
(592, '15/ICS/038', 1),
(593, '15/ICS/039', 1),
(594, '15/ICS/040', 1),
(595, '15/ICS/041', 1),
(596, '15/ICS/042', 1),
(597, '15/ICS/043', 1),
(598, '15/ICS/044', 1),
(599, '15/ICS/045', 1),
(600, '15/ICS/046', 1),
(601, '15/ICS/047', 1),
(602, '15/ICS/048', 1),
(603, '15/ICS/049', 1),
(604, '15/ICS/050', 1),
(605, '15/ICS/051', 1),
(606, '15/ICS/052', 1),
(607, '15/ICS/053', 1),
(608, '15/ICS/054', 1),
(609, '15/ICS/055', 1),
(610, '15/ICS/056', 1),
(611, '15/ICS/057', 1),
(612, '15/ICS/058', 1),
(613, '15/ICS/059', 1),
(614, '15/ICS/060', 1),
(615, '15/ICS/061', 1),
(616, '15/ICS/062', 1),
(617, '15/ICS/063', 1),
(618, '15/ICS/064', 1),
(619, '15/ICS/065', 1),
(620, '15/ICS/066', 1),
(621, '15/ICS/067', 1),
(622, '15/ICS/068', 1),
(623, '15/ICS/069', 1),
(624, '15/ICS/070', 1),
(625, '15/ICS/071', 1),
(626, '15/ICS/072', 1),
(627, '15/ICS/073', 1),
(628, '15/IEC/001', 5),
(629, '15/IEC/004', 5),
(630, '15/IEC/007', 5),
(631, '15/IEC/008', 5),
(632, '15/IEC/009', 5),
(633, '15/IEC/010', 5),
(634, '15/IEC/011', 5),
(635, '15/IEC/013', 5),
(636, '15/IEC/015', 5),
(637, '15/IEC/016', 5),
(638, '15/IEC/017', 5),
(639, '15/IEC/018', 5),
(640, '15/IEC/019', 5),
(641, '15/IEC/020', 5),
(642, '15/IEC/021', 5),
(643, '15/IEC/023', 5),
(644, '15/IEC/024', 5),
(645, '15/IEC/025', 5),
(646, '15/IEC/028', 5),
(647, '15/IEC/032', 5),
(648, '15/IEC/035', 5),
(649, '15/IEC/036', 5),
(650, '15/IEC/037', 5),
(651, '15/IEC/039', 5),
(652, '15/IEC/040', 5),
(653, '15/IEC/041', 5),
(654, '15/IEC/042', 5),
(655, '15/IEC/043', 5),
(656, '15/IEC/044', 5),
(657, '15/IEC/045', 5),
(658, '15/IEC/046', 5),
(659, '15/IEC/047', 5),
(660, '15/IEC/048', 5),
(661, '15/IEC/052', 5),
(662, '15/IEC/053', 5),
(663, '15/IEC/054', 5),
(664, '15/IEC/055', 5),
(665, '15/IEC/056', 5),
(666, '15/IEC/059', 5),
(667, '15/IEC/061', 5),
(668, '15/IEC/062', 5),
(669, '15/IEC/063', 5),
(670, '15/IEC/064', 5),
(671, '15/IEC/065', 5),
(672, '15/IEC/067', 5),
(673, '15/IEC/068', 5),
(674, '15/IEC/069', 5),
(675, '15/IEC/070', 5),
(676, '15/IEC/071', 5),
(677, '15/IEC/072', 5),
(678, '15/IEC/073', 5),
(679, '15/IEC/074', 5),
(680, '15/IEC/075', 5),
(681, '15/IEC/076', 5),
(682, '15/IEC/077', 5),
(683, '15/IEC/078', 5),
(684, 'R14/IEC/016', 5),
(685, '14/PIT/001', 24),
(686, '14/PIT/002', 24),
(687, '14/PIT/003', 24),
(688, '14/PIT/004', 24),
(689, '14/PIT/005', 24),
(690, '14/PIT/006', 24),
(691, '14/PIT/007', 24),
(692, '14/PIT/008', 24),
(693, '14/PIT/009', 24),
(694, '14/PIT/010', 24),
(695, '14/PIT/011', 24),
(696, '14/PIT/012', 24),
(697, '14/PIT/013', 24),
(698, '14/PIT/014', 24),
(699, '14/PIT/015', 24),
(700, '14/PIT/016', 24),
(701, '14/PIT/026', 25),
(702, '14/PIT/027', 25),
(703, '14/PIT/028', 25),
(704, '14/PIT/029', 25),
(705, '14/PIT/030', 25),
(706, '14/PIT/031', 25),
(707, '14/PIT/032', 25),
(708, '14/PIT/033', 25),
(709, '14/PIT/034', 25),
(710, '14/PIT/035', 25),
(711, '14/PIT/051', 16),
(712, '14/PIT/052', 16),
(713, '14/PIT/053', 16),
(714, '14/PIT/054', 16),
(715, '14/PIT/076', 18),
(716, '14/PIT/077', 18),
(717, '14/PIT/078', 18),
(718, '14/PIT/079', 18),
(719, '14/PIT/080', 18),
(720, '14/PIT/081', 18),
(721, '14/PIT/082', 18),
(722, '14/PIT/083', 18),
(723, '14/PIT/084', 18),
(724, '14/PIT/085', 18),
(725, '14/PIT/086', 18),
(726, '14/PIT/087', 18),
(727, '14/PIT/088', 18),
(728, '14/PIT/089', 18),
(729, '14/PIT/101', 20),
(730, '14/PIT/102', 20),
(731, '14/PIT/103', 20),
(732, '14/PIT/104', 20),
(733, '14/PIT/105', 20),
(734, '14/PIT/106', 20),
(735, '14/PIT/107', 20),
(736, '14/PIT/108', 20),
(737, '14/PIT/109', 20),
(738, '14/PIT/110', 20),
(739, '14/PIT/111', 20),
(740, '14/PIT/112', 20),
(741, '14/PIT/113', 20),
(742, '14/PIT/126', 22),
(743, '14/PIT/127', 22),
(744, '14/PIT/128', 22),
(745, '14/PIT/129', 22),
(746, '14/PIT/130', 22),
(747, '14/PIT/131', 22),
(748, '14/PIT/132', 22),
(749, '14/PIT/133', 22),
(750, '14/PIT/134', 22),
(751, '14/PIT/135', 22),
(752, '15/PIT/001', 23),
(753, '15/PIT/002', 23),
(754, '15/PIT/003', 23),
(755, '15/PIT/004', 23),
(756, '15/PIT/005', 23),
(757, '15/PIT/006', 23),
(758, '15/PIT/007', 23),
(759, '15/PIT/008', 23),
(760, '15/PIT/009', 23),
(761, '15/PIT/010', 23),
(762, '15/PIT/011', 23),
(763, '15/PIT/012', 23),
(764, '15/PIT/013', 23),
(765, '15/PIT/014', 23),
(766, '15/PIT/015', 23),
(767, '15/PIT/016', 23),
(768, '15/PIT/021', 17),
(769, '15/PIT/022', 17),
(770, '15/PIT/041', 19),
(771, '15/PIT/042', 19),
(772, '15/PIT/043', 19),
(773, '15/PIT/044', 19),
(774, '15/PIT/045', 19),
(775, '15/PIT/046', 19),
(776, '15/PIT/047', 19),
(777, '15/PIT/048', 19),
(778, '15/PIT/061', 21),
(779, '15/PIT/062', 21),
(780, '15/PIT/063', 21),
(781, '15/PIT/064', 21),
(782, '15/PIT/065', 21),
(783, '15/PIT/066', 21),
(784, '15/PIT/067', 21);

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

--
-- Table structure for table `update_info`
--

CREATE TABLE `update_info` (
  `version` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `update_info`
--

INSERT INTO `update_info` (`version`) VALUES
(1);

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

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

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL,
  `username` varchar(25) NOT NULL,
  `password` varchar(200) NOT NULL,
  `type` varchar(40) NOT NULL,
  `email` varchar(50) NOT NULL,
  `active` int(11) NOT NULL DEFAULT '0',
  `profile_picture` varchar(50) NOT NULL DEFAULT 'resources/images/default-user.png',
  `full_name` varchar(40) NOT NULL,
  `roll_number` varchar(10) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  `confirmation_link` varchar(36) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `users` (`user_id`, `username`, `password`, `type`, `email`, `active`, `profile_picture`, `full_name`, `roll_number`, `phone_number`, `confirmation_link`) VALUES
(1, 'varun', '$2a$08$Zu3VrELhRcG42tOXzulIL.U0vKKcv6PYGUaRS/rNR6CPfPOOVxzcK', 'superadmin', 'varun.10@live.com', 1, 'resources/images/default-user.png', 'Varun Garg', '13/ICS/057', '', 'bad7011d94999d05699bc26cedb326da6dc1'),
(10, 'rishabh', '$2a$08$wWu/iFbMDCKfOaeuI3PP0.maG2PwgFuopvkMxtIVX1d6nzaWXZObW', 'superadmin', 'r@r.r', 1, 'resources/images/default-user.png', 'rishabh', '', '', '5f6bb0c422cd4788ae2f95982e29b89819cc');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `arrangements`
--
ALTER TABLE `arrangements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `exams`
--
ALTER TABLE `exams`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `logs`
--
ALTER TABLE `logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `program_details`
--
ALTER TABLE `program_details`
  MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT for table `rooms`
--
ALTER TABLE `rooms`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `student_details`
--
ALTER TABLE `student_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=785;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
/*!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 */;