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

START TRANSACTION;



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

--
-- Table structure for table `sunotes`
--

CREATE TABLE `sunotes` (
  `id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `descrip` varchar(255) NOT NULL,
  `uploaded_by` varchar(255) NOT NULL,
  `uploaded_to` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `files` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `uploaded_on` varchar(225) NOT NULL DEFAULT current_timestamp(),
  `dept` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `uassign`
--

CREATE TABLE `uassign` (
  `id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `descrip` varchar(255) NOT NULL,
  `uploaded_by` varchar(255) NOT NULL,
  `uploaded_to` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `files` varchar(255) NOT NULL,
  `dept` varchar(255) NOT NULL,
  `year` varchar(255) NOT NULL,
  `sem` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `unotes`
--

CREATE TABLE `unotes` (
  `id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `descrip` varchar(255) NOT NULL,
  `uploaded_by` varchar(255) NOT NULL,
  `uploaded_to` varchar(255) NOT NULL,
  `files` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `dept` varchar(255) NOT NULL,
  `year` varchar(255) NOT NULL,
  `sem` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

--
-- AUTO_INCREMENT for table `sunotes`
--
ALTER TABLE `sunotes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `uassign`
--
ALTER TABLE `uassign`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `unotes`
--
ALTER TABLE `unotes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

