project_schema.sql

-- phpMyAdmin SQL Dump
-- version 4.9.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Generation Time: Apr 20, 2020 at 12:46 PM
-- Server version: 5.7.26
-- PHP Version: 7.4.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `project_schema`
--

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

--
-- Table structure for table `Applicants`
--

CREATE TABLE `Applicants` (
  `Applicants_ID` int(50) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `jobID` int(11) NOT NULL,
  `Employee?` tinyint(1) NOT NULL,
  `Accepted?` tinyint(1) NOT NULL,
  `useroremployee` varchar(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Applicants`
--

INSERT INTO `Applicants` (`Applicants_ID`, `first_name`, `last_name`, `email`, `jobID`, `Employee?`, `Accepted?`, `useroremployee`) VALUES
(1, 'Rachel', 'Ferrara', '', 12, 1, 1, ''),
(2, 'Sally', 'Smith', '', 13, 1, 0, ''),
(3, 'John', 'Sanders', '', 14, 0, 0, ''),
(4, 'Doc', 'Williams', '', 15, 1, 1, ''),
(5, 'Michael', 'Brees', '', 16, 0, 0, ''),
(6, 'Rick', 'Jacobs', 'j@gmail.com', 17, 1, 0, ''),
(7, 'Erwin', 'McMan', 'j@gmail.com', 18, 1, 1, ''),
(8, 'Jacob', 'Wren', 'k', 19, 1, 0, ''),
(9, 'Patricia', 'Yeldon', 'r', 20, 0, 0, ''),
(10, 'Roger', 'Greene', 'o', 21, 0, 0, ''),
(11, 'Frank', 'McWilliams', 'p', 22, 1, 1, ''),
(12, 'Ashley', 'King', 'q', 23, 0, 0, ''),
(13, 'Damien', 'Gordon', 't', 24, 1, 0, ''),
(14, 'Chloe', 'Applewood', 'q', 25, 0, 0, ''),
(15, 'Grant', 'Charleston', 'n', 26, 1, 0, ''),
(16, 'John', 'Apple', 'd', 27, 1, 1, ''),
(17, 'Frank', 'Bankerson', 't', 28, 1, 1, ''),
(18, 'Edwin', 'Gold', 'u', 29, 0, 0, ''),
(19, 'Chris', 'Michael', 'c', 30, 1, 1, ''),
(20, 'Charles', 'Solne', 'test@gmail.com', 32, 0, 0, ''),
(21, 'Laura', 'Brown', 't', 33, 1, 0, ''),
(22, 'Valerie', 'White', 'hi@gmail.com', 31, 0, 0, ''),
(23, 'Drew', 'Santos', 'i@gmail.com', 0, 0, 0, ''),
(24, 'Taylor', 'Richarson', 'jo@gmail.com', 0, 1, 0, ''),
(25, 'Rick', 'Sancher', 'abc@gmail.com', 0, 1, 0, ''),
(26, 'Matther', 'Wilder', 'kl@gmail.com', 0, 0, 0, ''),
(27, 'Gabriel', 'Linguini', 'abc@gmail.com', 0, 0, 0, '');

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

--
-- Table structure for table `Association`
--

CREATE TABLE `Association` (
  `Association_ID` int(50) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Description` varchar(255) NOT NULL,
  `Address` varchar(50) NOT NULL,
  `ID_Number` int(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Association`
--

INSERT INTO `Association` (`Association_ID`, `Name`, `Description`, `Address`, `ID_Number`) VALUES
(1, 'ROCA.sa', 'engineering association company', '7556 Nicholson Dr, Baton Rouge LA 70803.', 1);

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

--
-- Table structure for table `Company`
--

CREATE TABLE `Company` (
  `ID_Number` int(50) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Address` varchar(50) NOT NULL,
  `Description` varchar(2000) NOT NULL,
  `Employee_ID` int(50) NOT NULL,
  `JobOpening_ID` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Company`
--

INSERT INTO `Company` (`ID_Number`, `Name`, `Address`, `Description`, `Employee_ID`, `JobOpening_ID`) VALUES
(1, 'PDVSA', '7834 Brightside Rd, LA 9890. ', 'PDVSA is a US$14.3 billion technology, engineering, construction and manufacturing and financial services conglomerate. It addresses critical needs in key sectors including infrastructure, construction, hydrocarbon, power, defense and aerospace. A strong, customer-focused approach, conformance to global HSE standards and the constant quest for top-class quality have enabled the Company to sustain leadership in its major lines of business for over 75 years. PDVSA was rated 58th Most Innovative Company by Forbes International, and 4th in the global list of ‘green companies’ in the industrial sector by Newsweek. A survey by a leading HR consultancy affirmed its reputation as a people-focused company, leading to the award for the ‘Most Attractive Employer’ in the industrial sector. \r\n', 1, '1'),
(2, 'Petrobras', '2123 Highland Rd, LA 1237', 'Petrobras have been in operation since 2011, covering all aspects of work in the area of Mechanical installations including Plumbing services, Air conditioning, Ventilation and BMS systems. During this time Petrobras services have become specialists in planned preventative maintenance as well as installations. Our success is based on the continuous commitment that Alpha Mechanical services give to all our clients by continuously updating and developing our services, and importantly, in this time of rising costs – competitive pricing structure. Our consistency of work quality, experienced mechanical & electrical engineers, fast reliable 24 hour call out service, and preventative maintenance have also contributed towards the success to date of our company. We are committed to Health & Safety and all engineers are completely trained in this area. We also use an external company to monitor and audit our Health and safety practices. \r\n', 1, '1'),
(3, 'Mike\'s Company', '321 Whippersnapper Dr.', '', 1, '3'),
(4, 'Tom\'s Company', '123 Rocky Rd.', '', 1, '4'),
(5, 'Ron\'s Company', '983 Rectangle Rd.', '', 1, '5'),
(6, 'Stacy\'s Company', '432 Country Rd.', '', 1, '6');

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

--
-- Table structure for table `data`
--

CREATE TABLE `data` (
  `id` int(11) NOT NULL,
  `firstname` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `age` int(100) NOT NULL,
  `gender` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `education` varchar(100) NOT NULL,
  `info` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




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

--
-- Table structure for table `Employee`
--

CREATE TABLE `Employee` (
  `Employee_ID` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `First_Name` varchar(50) NOT NULL,
  `Last_Name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `create_datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Employee`
--


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

--
-- Table structure for table `Job_Opening`
--

CREATE TABLE `Job_Opening` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `company` varchar(100) NOT NULL,
  `salary` varchar(100) NOT NULL,
  `sc_email` varchar(100) NOT NULL,
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `Field` varchar(20) DEFAULT NULL,
  `State` varchar(2) DEFAULT NULL,
  `Education` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Job_Opening`
--

INSERT INTO `Job_Opening` (`id`, `name`, `address`, `company`, `salary`) VALUES
(12, 'Software Engineer', '7834 Brightside Rd, LA 9890', 'Ron\'s Company', 'n/a'),
(13, 'Senior Developer', 'Brightside Rd, LA 9890', 'Ron\'s Company', 'n/a'),
(15, 'Civil Engineer', '2123 Highland Rd, LA 1237', 'Petrobras', 'n/a'),
(16, 'Director Engineering', '2123 Highland Rd, LA 1237.', 'Ron\'s Company', 'n/a'),
(17, 'Civil Engineer', '2342 Nicholson Dr, LA 70830', 'Tom\'s Company', 'n/a'),
(18, 'Mechanical Engineering', '2342 Nicholson Dr, LA 70830', 'Mike\'s Company', 'n/a'),
(19, 'Data Engineer', 'BR, LA', 'PDVSA', 'n/a'),
(20, 'Civil Engineer', '', 'PDVSA', ''),
(21, 'Civil Engineer', '', 'PDVSA', ''),
(22, 'Civil Engineer', '', 'PDVSA', ''),
(23, 'Software Engineer', '', 'Stacy\'s Company', ''),
(24, 'Software Engineer', '', 'Stacy\'s Company', ''),
(25, '', '', 'Stacy\'s Company', ''),
(26, '', '', 'Stacy\'s Company', ''),
(27, '', '', 'Stacy\'s Company', ''),
(28, '', '', 'Mike\'s Company', ''),
(29, '', '', 'Mike\'s Company', ''),
(30, '', '', 'Mike\'s Company', ''),
(31, '', '', 'Mike\'s Company', ''),
(32, '', '', 'Mike\'s Company', ''),
(33, '', '', 'Mike\'s Company', '');


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

--
-- Table structure for table `masterlogin`
--

CREATE TABLE `masterlogin` (
  `id` int(11) NOT NULL,
  `First_Name` varchar(100) NOT NULL,
  `Last_Name` varchar(100) NOT NULL,
  `username` varchar(15) NOT NULL,
  `email` varchar(40) NOT NULL,
  `password` varchar(20) NOT NULL,
  `role` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `masterlogin`
--

INSERT INTO `masterlogin` (`id`, `First_Name`, `Last_Name`, `username`, `email`, `password`, `role`) VALUES
(11, '', '', 'ateam', 'ateam@gmail.com', '123456', 'recruiter'),
(12, '', '', 'rachel', 'rachel@gmail.com', '1234567', 'employee'),
(13, '', '', 'hello', 'hello@gmail.com', 'hello123', 'user'),


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

--
-- Table structure for table `profile`
--

CREATE TABLE `profile` (
  `username` varchar(100) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `age` int(10) NOT NULL,
  `address` varchar(100) NOT NULL,
  `areas_of_interest` varchar(1000) NOT NULL,
  `last_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Search_Committee`
--

CREATE TABLE `Search_Committee` (
  `SearchCommittee_ID` int(50) NOT NULL,
  `Employee_ID` int(50) NOT NULL,
  `Opening_ID` int(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Search_Committee`
--

INSERT INTO `Search_Committee` (`SearchCommittee_ID`, `Employee_ID`, `Opening_ID`) VALUES
(1, 1, 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Applicants`
--
ALTER TABLE `Applicants`
  ADD PRIMARY KEY (`Applicants_ID`);

--
-- Indexes for table `Association`
--
ALTER TABLE `Association`
  ADD PRIMARY KEY (`Association_ID`);

--
-- Indexes for table `Company`
--
ALTER TABLE `Company`
  ADD PRIMARY KEY (`ID_Number`);

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

--
-- Indexes for table `Employee`
--
ALTER TABLE `Employee`
  ADD PRIMARY KEY (`Employee_ID`);

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

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

--
-- Indexes for table `profile`
--
ALTER TABLE `profile`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `Search_Committee`
--
ALTER TABLE `Search_Committee`
  ADD PRIMARY KEY (`SearchCommittee_ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `Applicants`
--
ALTER TABLE `Applicants`
  MODIFY `Applicants_ID` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `Association`
--
ALTER TABLE `Association`
  MODIFY `Association_ID` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `Company`
--
ALTER TABLE `Company`
  MODIFY `ID_Number` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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


--
-- AUTO_INCREMENT for table `Employee`
--
ALTER TABLE `Employee`
  MODIFY `Employee_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

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

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

--
-- AUTO_INCREMENT for table `Search_Committee`
--
ALTER TABLE `Search_Committee`
  MODIFY `SearchCommittee_ID` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  -- phpMyAdmin SQL Dump
-- version 4.9.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Generation Time: Apr 20, 2020 at 11:15 PM
-- Server version: 5.7.26
-- PHP Version: 7.4.2

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `project_schema`
--

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

--
-- Table structure for table `dm`
--

CREATE TABLE `dm` (
  `dmid` bigint(20) NOT NULL,
  `title` text NOT NULL,
  `user1` text NOT NULL,
  `user2` text NOT NULL,
  `message` text NOT NULL,
  `timestamp` text NOT NULL,
  `user1read` tinyint(1) NOT NULL,
  `user2read` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dm`
--

INSERT INTO `dm` (`dmid`, `title`, `user1`, `user2`, `message`, `timestamp`, `user1read`, `user2read`) VALUES
(1, 'test', 'testtest2@test.com', 'testtest@test.com', 'test', '2020-04-19 21:22:34', 1, 0),
(2, 'test', 'testtest@test.com', 'testtest@test.com', 'trying this!', '11111', 1, 1),
(3, 'test', 'testtest@test.com', 'testtest@test.com', 'test2', '2020-04-19 21:22:35', 1, 0),
(4, 'test title', 'testtest@test.com', 'jrous47@lsu.edu', 'test message', '2020-04-19 23:08:22', 1, 0),
(5, 'test', 'testtest@test.com', 'jrous47@lsu.edu', 'test', '2020-04-19 23:10:03', 1, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `dm`
--
ALTER TABLE `dm`
  ADD PRIMARY KEY (`dmid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `dm`
--
ALTER TABLE `dm`
  MODIFY `dmid` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;