-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `library`
--

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

--
-- Table structure for table `masterlist`
--

CREATE TABLE `masterlist` (
  `ID` int(12) NOT NULL,
  `Location` varchar(15) NOT NULL,
  `Category` varchar(25) NOT NULL,
  `Account_No` int(10) NOT NULL,
  `Call_No` varchar(10) NOT NULL,
  `Title` varchar(100) NOT NULL,
  `Author` varchar(50) NOT NULL,
  `Publisher` varchar(50) NOT NULL,
  `Year` year(4) NOT NULL,
  `Copy` int(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `masterlist`
--

INSERT INTO `masterlist` (`ID`, `Location`, `Category`, `Account_No`, `Call_No`, `Title`, `Author`, `Publisher`, `Year`, `Copy`) VALUES
(1, 'ComSci.', 'Cir', 17430, '004.67 V13', 'Routing and switching essentials:lab manual', '[s.n]', 'test', 0000, 7),
(2, 'ComSci.', 'Cir', 13581, '004.67 V13', 'Accessing the WAN: CCNA exploration companion guid', 'Vachon, Bob', 'Singapore: Pearson Educational South Asia', 2023, 4),
(3, 'ComSci.', 'Cir', 13583, '004.6 G79r', 'Routing protocols and concepts: CCNA exploration c', 'Graziani, Rick', 'Singapore: Pearson Educational South Asia', 2023, 5);

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

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `ID` int(12) NOT NULL,
  `Name` varchar(25) NOT NULL,
  `ID_No` int(10) NOT NULL,
  `ID_Type` varchar(10) NOT NULL,
  `Address` varchar(50) NOT NULL,
  `Contact_No` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`ID`, `Name`, `ID_No`, `ID_Type`, `Address`, `Contact_No`) VALUES
(1, 'bianca2', 220, 'Teacher', '', 0);

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

--
-- Table structure for table `not_returned`
--

CREATE TABLE `not_returned` (
  `ID` int(9) NOT NULL,
  `Date_borrow` date NOT NULL,
  `Copy` text NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Location` varchar(15) NOT NULL,
  `Category` varchar(15) NOT NULL,
  `Account_No` varchar(15) NOT NULL,
  `Call_No` varchar(15) NOT NULL,
  `Title` varchar(50) NOT NULL,
  `Author` varchar(50) NOT NULL,
  `Publisher` varchar(50) NOT NULL,
  `Year` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `returned`
--

CREATE TABLE `returned` (
  `ID` int(11) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Date_Return` varchar(255) NOT NULL,
  `Copies` int(9) NOT NULL,
  `Location` varchar(15) NOT NULL,
  `Account_No` int(15) NOT NULL,
  `Title` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `returned`
--

INSERT INTO `returned` (`ID`, `Name`, `Date_Return`, `Copies`, `Location`, `Account_No`, `Title`) VALUES
(6, 'tabstabilog', 'January 05 2023 09:50:01 PM', 1, 'ComSci.', 17430, 'Routing and switching essentials:lab manual'),
(7, 'bianca vivar', 'January 05 2023 09:51:29 PM', 5, 'ComSci.', 17430, 'Routing and switching essentials:lab manual'),
(8, 'bianca vivar', 'January 05 2023 09:52:28 PM', 5, 'ComSci.', 17430, 'Routing and switching essentials:lab manual');

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `masterlist`
--
ALTER TABLE `masterlist`
  MODIFY `ID` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `members`
--
ALTER TABLE `members`
  MODIFY `ID` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `not_returned`
--
ALTER TABLE `not_returned`
  MODIFY `ID` int(9) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `returned`
--
ALTER TABLE `returned`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

