-- phpMyAdmin SQL Dump
-- version 4.8.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 19, 2018 at 08:10 AM
-- Server version: 10.1.32-MariaDB
-- PHP Version: 7.2.5

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

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

--
-- Table structure for table `tblassigneditems`
--

CREATE TABLE `tblassigneditems` (
  `AssignedID` int(11) NOT NULL,
  `Barcode` varchar(90) NOT NULL,
  `Description` varchar(90) NOT NULL,
  `AssignedQuantity` int(11) NOT NULL,
  `AssignedOnhandQty` int(11) NOT NULL,
  `Parts` varchar(90) NOT NULL,
  `LocationID` int(11) NOT NULL,
  `CompSetID` int(11) NOT NULL,
  `STATUS` varchar(90) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblassigneditems`
--

INSERT INTO `tblassigneditems` (`AssignedID`, `Barcode`, `Description`, `AssignedQuantity`, `AssignedOnhandQty`, `Parts`, `LocationID`, `CompSetID`, `STATUS`) VALUES
(3, '4801010105107', 'Chalk Blue', 1, 1, 'None', 4, 1, ''),
(4, '4801010105107', 'Chalk Blue', 1, 1, 'None', 3, 1, '');

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

--
-- Table structure for table `tblbrand`
--

CREATE TABLE `tblbrand` (
  `BrandID` int(11) NOT NULL,
  `Brand` varchar(90) NOT NULL,
  `Description` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblbrand`
--

INSERT INTO `tblbrand` (`BrandID`, `Brand`, `Description`) VALUES
(1, 'None', 'None'),
(2, 'Samsung', 'Samsung'),
(3, 'Logitech', 'Logitech');

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

--
-- Table structure for table `tblcompset`
--

CREATE TABLE `tblcompset` (
  `CompSetID` int(11) NOT NULL,
  `ComputerSet` varchar(90) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblcompset`
--

INSERT INTO `tblcompset` (`CompSetID`, `ComputerSet`) VALUES
(1, 'None'),
(2, 'Computer 1'),
(3, 'Computer 2'),
(4, 'Computer 3');

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

--
-- Table structure for table `tbldamage`
--

CREATE TABLE `tbldamage` (
  `DamageId` int(11) NOT NULL,
  `Barcode` varchar(90) NOT NULL,
  `Description` varchar(90) NOT NULL,
  `DamagedQuantity` int(11) NOT NULL,
  `AssignedArea` varchar(90) NOT NULL,
  `DateDamaged` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tblitems`
--

CREATE TABLE `tblitems` (
  `ItemID` int(11) NOT NULL,
  `Barcode` varchar(125) NOT NULL,
  `BrandID` int(11) NOT NULL,
  `Description` varchar(255) NOT NULL,
  `PartsID` int(11) NOT NULL,
  `RecievedDate` date NOT NULL,
  `Quantity` int(11) NOT NULL,
  `OnhandQty` int(11) NOT NULL,
  `Price` double NOT NULL,
  `Status` varchar(30) NOT NULL,
  `Remarks` varchar(30) NOT NULL,
  `Supplier` varchar(90) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblitems`
--

INSERT INTO `tblitems` (`ItemID`, `Barcode`, `BrandID`, `Description`, `PartsID`, `RecievedDate`, `Quantity`, `OnhandQty`, `Price`, `Status`, `Remarks`, `Supplier`) VALUES
(1, '4801010105107', 1, 'Chalk Blue', 1, '2018-08-19', 4, 2, 300, 'Good', '', 'Jake');

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

--
-- Table structure for table `tblitemsummary`
--

CREATE TABLE `tblitemsummary` (
  `ID` int(11) NOT NULL,
  `ItemID` int(11) NOT NULL,
  `Barcode` varchar(90) NOT NULL,
  `Description` varchar(90) NOT NULL,
  `RecievedQuantity` int(11) NOT NULL,
  `Price` double NOT NULL,
  `TotalPrice` double NOT NULL,
  `DateRecieved` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblitemsummary`
--

INSERT INTO `tblitemsummary` (`ID`, `ItemID`, `Barcode`, `Description`, `RecievedQuantity`, `Price`, `TotalPrice`, `DateRecieved`) VALUES
(1, 1, '4801010105107', 'Chalk Blue', 4, 300, 1200, '2018-08-19');

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

--
-- Table structure for table `tbllocation`
--

CREATE TABLE `tbllocation` (
  `LocationID` int(11) NOT NULL,
  `Location` varchar(90) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbllocation`
--

INSERT INTO `tbllocation` (`LocationID`, `Location`) VALUES
(1, 'None'),
(2, 'ComLabA'),
(3, 'Lab3'),
(4, 'Lab1'),
(5, 'Lab2'),
(6, 'Lab4');

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

--
-- Table structure for table `tbllost`
--

CREATE TABLE `tbllost` (
  `LostId` int(11) NOT NULL,
  `AssignedID` int(11) NOT NULL,
  `Barcode` varchar(90) NOT NULL,
  `Description` varchar(90) NOT NULL,
  `LostQuantity` int(11) NOT NULL,
  `AsignedArea` varchar(90) NOT NULL,
  `DateLost` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tblmaintenance`
--

CREATE TABLE `tblmaintenance` (
  `MaintenanceId` int(11) NOT NULL,
  `AssignedID` int(11) NOT NULL,
  `Barcode` varchar(90) NOT NULL,
  `Description` varchar(90) NOT NULL,
  `MaintenanceQuantity` int(11) NOT NULL,
  `AssignedArea` varchar(90) NOT NULL,
  `DateRepair` date NOT NULL,
  `MSTATUS` varchar(90) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tblparts`
--

CREATE TABLE `tblparts` (
  `PartsID` int(11) NOT NULL,
  `Parts` varchar(90) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblparts`
--

INSERT INTO `tblparts` (`PartsID`, `Parts`) VALUES
(1, 'None'),
(2, 'Keyboard'),
(3, 'Monitor'),
(4, 'RAM'),
(7, 'Hardisk Drive');

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

--
-- Table structure for table `tblsupplier`
--

CREATE TABLE `tblsupplier` (
  `SupplierId` int(11) NOT NULL,
  `Supplier` varchar(90) NOT NULL,
  `Company` varchar(90) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblsupplier`
--

INSERT INTO `tblsupplier` (`SupplierId`, `Supplier`, `Company`) VALUES
(1, 'Jake', 'Chalk Company');

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

--
-- Table structure for table `tbltransfer`
--

CREATE TABLE `tbltransfer` (
  `TransferID` int(11) NOT NULL,
  `AssignedID` int(11) NOT NULL,
  `Barcode` varchar(90) NOT NULL,
  `Item` varchar(90) NOT NULL,
  `TransferedQuantity` int(11) NOT NULL,
  `Parts` varchar(30) NOT NULL,
  `LocationFROM` varchar(90) NOT NULL,
  `LocationTO` varchar(90) NOT NULL,
  `PCFrom` varchar(30) NOT NULL,
  `PCTo` varchar(30) NOT NULL,
  `TransferDate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbluseraccounts`
--

CREATE TABLE `tbluseraccounts` (
  `UserID` int(11) NOT NULL,
  `Fullname` varchar(30) NOT NULL,
  `Username` varchar(30) NOT NULL,
  `Pass` varchar(90) NOT NULL,
  `Role` varchar(30) NOT NULL,
  `Status` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbluseraccounts`
--

INSERT INTO `tbluseraccounts` (`UserID`, `Fullname`, `Username`, `Pass`, `Role`, `Status`) VALUES
(1, 'Janno Palacios', 'admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', 'Administrator', 'Active'),
(2, 'James Yap', 'staff', '6ccb4b7c39a6e77f76ecfa935a855c6c46ad5611', 'Staff', 'Active'),
(3, 'sadas', 'a', '86f7e437faa5a7fce15d1ddcb9eaeaea377667b8', 'Staff', 'Active');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tblassigneditems`
--
ALTER TABLE `tblassigneditems`
  ADD PRIMARY KEY (`AssignedID`);

--
-- Indexes for table `tblbrand`
--
ALTER TABLE `tblbrand`
  ADD PRIMARY KEY (`BrandID`);

--
-- Indexes for table `tblcompset`
--
ALTER TABLE `tblcompset`
  ADD PRIMARY KEY (`CompSetID`);

--
-- Indexes for table `tbldamage`
--
ALTER TABLE `tbldamage`
  ADD PRIMARY KEY (`DamageId`);

--
-- Indexes for table `tblitems`
--
ALTER TABLE `tblitems`
  ADD PRIMARY KEY (`ItemID`);

--
-- Indexes for table `tblitemsummary`
--
ALTER TABLE `tblitemsummary`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tbllocation`
--
ALTER TABLE `tbllocation`
  ADD PRIMARY KEY (`LocationID`);

--
-- Indexes for table `tbllost`
--
ALTER TABLE `tbllost`
  ADD PRIMARY KEY (`LostId`);

--
-- Indexes for table `tblmaintenance`
--
ALTER TABLE `tblmaintenance`
  ADD PRIMARY KEY (`MaintenanceId`);

--
-- Indexes for table `tblparts`
--
ALTER TABLE `tblparts`
  ADD PRIMARY KEY (`PartsID`);

--
-- Indexes for table `tblsupplier`
--
ALTER TABLE `tblsupplier`
  ADD PRIMARY KEY (`SupplierId`);

--
-- Indexes for table `tbltransfer`
--
ALTER TABLE `tbltransfer`
  ADD PRIMARY KEY (`TransferID`);

--
-- Indexes for table `tbluseraccounts`
--
ALTER TABLE `tbluseraccounts`
  ADD PRIMARY KEY (`UserID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tblassigneditems`
--
ALTER TABLE `tblassigneditems`
  MODIFY `AssignedID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tblbrand`
--
ALTER TABLE `tblbrand`
  MODIFY `BrandID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tblcompset`
--
ALTER TABLE `tblcompset`
  MODIFY `CompSetID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tbldamage`
--
ALTER TABLE `tbldamage`
  MODIFY `DamageId` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `tbllocation`
--
ALTER TABLE `tbllocation`
  MODIFY `LocationID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tbllost`
--
ALTER TABLE `tbllost`
  MODIFY `LostId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblmaintenance`
--
ALTER TABLE `tblmaintenance`
  MODIFY `MaintenanceId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblparts`
--
ALTER TABLE `tblparts`
  MODIFY `PartsID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

--
-- AUTO_INCREMENT for table `tbltransfer`
--
ALTER TABLE `tbltransfer`
  MODIFY `TransferID` int(11) NOT NULL AUTO_INCREMENT;

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