nav_finder(2).sql

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: `nav_finder`
--

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

--
-- Table structure for table `buildings`
--

CREATE TABLE `buildings` (
  `id` int(11) NOT NULL,
  `names` varchar(40) NOT NULL,
  `coordinates` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `buildings`
--

INSERT INTO `buildings` (`id`, `names`, `coordinates`) VALUES
(1, 'Engineering & Computing Building', '52.4053° N, 1.4997° W');

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

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

CREATE TABLE `rooms` (
  `id` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `description` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `rooms` (`id`, `name`, `description`) VALUES
(1, 'ECG-01', ''),
(2, 'ECG-02', ''),
(3, 'ECG-03', ''),
(4, 'ECG-04', ''),
(5, 'ECG-06', ''),
(6, 'ECG-08', ''),
(7, 'ECG-09', ''),
(8, 'ECG-12', 'Theta Room'),
(9, 'ECG-13', ''),
(10, 'ECG-14', ''),
(11, 'ECG-18', ''),
(12, 'ECG-19', ''),
(13, 'ECG-21', ''),
(14, 'ECG-22a', ''),
(15, 'ECG-22', 'Professional Support Staff'),
(16, 'ECG-24', 'Weston Lecture Theatre'),
(17, 'ECG-26', 'Wolfson Lecture Theatre'),
(18, 'ECG-27', 'Wolfson Lecture Theatre'),
(19, 'ECG-29', 'Baby Changing Room'),
(20, 'ECG-30b', ''),
(21, 'ECG-31a', ''),
(22, 'ECG-32', ''),
(23, 'ECG-34', 'CLIB - Center for Low Impact B'),
(24, 'ECG-35', 'Eletronic Projects'),
(25, 'ECG-36', 'ECDL Test Centre'),
(26, 'EC1-01', ''),
(27, 'EC1-02', ''),
(28, 'EC1-03', ''),
(29, 'EC1-05', ''),
(30, 'EC1-07', ''),
(31, 'EC1-08', ''),
(32, 'EC1-11', ''),
(33, 'EC1-12', ''),
(34, 'EC1-13', 'Cisco Systems'),
(35, 'EC1-14', 'Ethical Hacking'),
(36, 'EC1-17', ''),
(37, 'EC1-18', ''),
(38, 'EC1-20', ''),
(39, 'EC1-21', ''),
(40, 'EC1-22', ''),
(41, 'EC1-23', ''),
(42, 'EC1-24', ''),
(43, 'EC1-25', 'EC Futures'),
(44, 'EC1-27', 'Planet Earth'),
(45, 'EC1-28', 'Planet Venus'),
(46, 'EC1-29', 'Event Room(Bookable) or Quiet '),
(47, 'EC1-20', 'No student access'),
(48, 'EC1-32', ''),
(49, 'EC1-34', ''),
(50, 'EC1-35', ''),
(51, 'EC2-01', ''),
(52, 'EC2-02', ''),
(53, 'EC2-03', ''),
(54, 'EC2-04', 'Electronics Laboratory'),
(55, 'EC2-06', ''),
(56, 'EC2-08', ''),
(57, 'EC2-09', ''),
(58, 'EC2-12', ''),
(59, 'EC2-13', ''),
(60, 'EC2-14', ''),
(61, 'EC2-17', ''),
(62, 'EC2-18', ''),
(63, 'EC2-20', ''),
(64, 'EC2-21', 'PhD Study Room'),
(65, 'EC2-24', 'Planet Mercury'),
(66, 'EC2-25', 'Planet Mercury');

--
-- Indexes for dumped tables
--

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `buildings`
--
ALTER TABLE `buildings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `rooms`
--
ALTER TABLE `rooms`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;
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 */;