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

START TRANSACTION;



--
-- Database: `ledger_db`
--

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

--
-- Table structure for table `addtoregister_tb`
--

CREATE TABLE `addtoregister_tb` (
  `userid` int(225) NOT NULL,
  `type` varchar(225) NOT NULL,
  `typename` varchar(225) NOT NULL,
  `product` varchar(225) NOT NULL,
  `qty` int(225) NOT NULL,
  `department` varchar(30) NOT NULL,
  `purchasedate` date NOT NULL,
  `renewdate` date NOT NULL,
  `description` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `addtoregister_tb`
--

INSERT INTO `addtoregister_tb` (`userid`, `type`, `typename`, `product`, `qty`, `department`, `purchasedate`, `renewdate`, `description`) VALUES
(1, 'LICENCES', 'OS', 'windows 10', 5, '', '2024-02-02', '2024-02-06', 'good'),
(2, 'WARRANTY', 'Laptop', 'HP', 10, 'Question Bank', '2024-02-04', '2024-04-03', 'well'),
(3, 'SERVICE/AMC', 'Mobile Recharge', 'Jio', 10, '', '2024-02-02', '2024-03-01', 'gcfghj'),
(4, 'SERVER', 'Domain', 'hoster', 5, '', '2024-02-03', '2024-02-25', 'good'),
(5, 'WARRANTY', 'AC', 'LG', 10, '', '2024-02-03', '2024-02-07', 'juhiujy'),
(6, 'LICENCES', 'Anti Virus', 'njkghfc', 6, '', '2024-02-04', '2024-02-17', 'hjmgfgdf'),
(7, 'WARRANTY', 'AC', 'lg', 9, '', '2024-01-29', '2024-02-10', 'ljhgg'),
(8, 'SERVER', 'Domain', 'godady', 5, '', '2024-02-06', '2024-02-15', 'kjhgfchgkj'),
(9, 'LICENCES', 'OS', 'njhghj', 5, '', '2024-01-30', '2024-02-15', 'kjbhjkl'),
(10, 'LICENCES', 'OS', 'sacdf', 5, '', '2024-02-04', '2024-02-15', 'hgfs'),
(11, 'WARRANTY', 'Printer', 'hpp', 2, '', '2024-02-21', '2024-02-29', 'hbgvjhk'),
(12, 'LICENCES', 'MS Office', 'safdf', 2, '', '2024-03-15', '2024-03-21', 'safdg'),
(13, 'WARRANTY', 'Laptop', 'jhgfgf', 2, '', '2024-02-14', '2024-03-21', 'jhjgcfhgj'),
(14, 'SERVER', 'Server', 'hbgvgch', 6, '', '2024-03-02', '2024-04-27', 'hbghv'),
(15, 'SERVER', 'Server', 'Nowhwere', 2, '', '2024-03-08', '2024-03-21', 'safdfd'),
(16, 'LICENCES', 'Anti Virus', 'firewall', 5, '', '2024-03-14', '2024-03-31', 'me'),
(17, 'LICENCES', 'MS Office', 'fdf', 3, '', '2024-03-05', '2024-03-20', 'fhjyjyr'),
(18, 'LICENCES', 'MS Office', 'fdf', 3, '', '2024-03-05', '2024-03-20', 'fhjyjyr'),
(23, 'WARRANTY', 'Laptop', 'jvh', 3, '', '2024-03-15', '2024-05-02', 'wert'),
(24, 'SERVER', 'SMS', 'njkbhj', 1, '', '2024-03-09', '2024-03-29', 'nljhkg'),
(25, 'SERVER', 'SMS', 'njkbhj', 1, '', '2024-03-09', '2024-03-29', 'nljhkg'),
(26, 'SERVER', 'SMS', 'njkbhj', 1, '', '2024-03-09', '2024-03-29', 'nljhkg'),
(27, 'LICENCES', 'MS Office', 'dsd', 3, '', '2024-03-07', '2024-04-23', 'ergrg'),
(28, 'SERVICE/AMC', 'Rat Poisoning', 'sedfg', 3, '', '2024-03-15', '2024-03-14', 'addsfdfgc'),
(29, 'SERVICE/AMC', 'Mobile Recharge', 'fcgh', 3, '', '2024-02-28', '2024-04-05', 'njjhv hj'),
(30, 'LICENCES', 'OS', '', 0, '', '0000-00-00', '0000-00-00', ''),
(31, 'SERVICE/AMC', 'Mobile Recharge', 'nj', 2, '', '2024-03-21', '2024-03-29', 'efwww'),
(32, 'LICENCES', 'OS', 'sdfd', 3, '', '2024-03-07', '2024-03-30', 'ewfr'),
(33, 'LICENCES', 'MS Office', 'kjhghn', 10, '', '2024-03-07', '2024-03-30', 'nnkbhvh'),
(34, 'SERVICE/AMC', 'Mobile Recharge', 'nkhjh', 2, '', '2024-03-23', '2024-03-30', 'nbjmjnm,'),
(35, 'LICENCES', 'Anti Virus', 'njkhjhn', 9, '', '2024-03-05', '2024-04-30', 'kjhjgjhj'),
(36, 'SERVER', 'Server', '', 0, '', '0000-00-00', '0000-00-00', ''),
(37, 'LICENCES', 'Anti Virus', 'rsdtfy', 5, '', '2024-03-14', '2024-03-21', 'jhghjgj'),
(38, 'WARRANTY', 'Laptop', 'sadf', 3, '', '2024-03-05', '2024-03-30', 'egrgtrwe'),
(40, 'LICENCES', 'MS Office', 'sdfg', 4, '', '2024-03-06', '2024-03-31', 'jkhgfghj'),
(41, 'LICENCES', 'Anti Virus', 'dfgh', 3, '', '2024-03-01', '2024-03-14', 'wdefr'),
(42, 'LICENCES', 'Adobe', 'sdf', 5, '', '2024-03-12', '2024-03-28', 'vghgfcgh'),
(43, 'LICENCES', 'Adobe', 'fghjgh', 4, '', '2024-03-12', '2024-04-07', 'dfjghgjk'),
(44, 'WARRANTY', 'MFV', 'jkhgfhj', 4, '', '2024-02-29', '2024-04-07', 'kjhghjk'),
(45, 'LICENCES', 'Adobe', 'jhfhghjk', 5, '', '2024-03-02', '2024-06-13', 'qns'),
(46, 'LICENCES', 'Adobe', 'MSoft', 5, '', '2024-03-20', '2024-03-30', 'hgghj'),
(47, 'WARRANTY', 'Scanner', 'HP', 5, 'Question Bank', '2024-03-27', '2024-04-07', 'me'),
(48, 'WARRANTY', 'WIFI', 'HP ', 10, '', '2024-03-20', '2024-04-02', 'mine'),
(49, 'SERVER', 'Email', 'gmail', 10, '', '2024-03-20', '2024-04-06', 'ghjklgui'),
(50, 'LICENCES', 'Adobe', 'devine', 5, 'Question Bank', '2024-04-10', '2024-06-30', 'me'),
(51, 'LICENCES', 'Adobe', 'chatgpt', 4, 'Question Bank', '2024-04-04', '2024-05-01', 'all'),
(52, 'SERVER', 'Server', 'godady', 2, 'IT-Admin', '2024-04-02', '2024-04-23', 'sss'),
(53, 'LICENCES', 'Adobe', 'fdgh', 5, 'Multi Media', '2024-03-31', '2024-04-17', 'gfhjkk'),
(54, 'WARRANTY', 'Printer', 'hp', 3, 'Question Bank', '2024-04-01', '2024-04-29', 'deed'),
(55, 'WARRANTY', 'System/Computer', 'hp', 5, 'IT-Admin', '2024-04-01', '2024-04-25', 'me'),
(56, 'WARRANTY', 'Laptop', 'hp', 5, 'IT-Admin', '2024-04-05', '2024-04-25', 'me'),
(57, 'WARRANTY', 'AC', 'lg', 5, 'Question Bank', '2024-04-05', '2024-04-15', 'mine'),
(58, 'SERVICE/AMC', 'Mobile Recharge', 'jio', 6, 'Multi Media', '2024-04-06', '2024-04-16', 'mmmm'),
(59, 'LICENCES', 'OS', 'gui', 6, 'CADD', '2024-04-13', '2024-04-17', 'njhui'),
(68, 'LICENCES', 'OS', 'njl', 1, 'IT-Admin', '2024-04-06', '2024-04-11', 'done'),
(69, 'LICENCES', 'OS', 'sc', 4, 'CADD', '2024-04-05', '2024-04-25', 'ngrgml'),
(70, 'LICENCES', 'Adobe', 'fcg', 8, 'Multi Media', '2024-04-05', '2024-04-25', 'njn;lk'),
(71, 'SERVER', 'Email', 'gmail', 5000, 'CADD', '2024-04-05', '2024-04-25', 'it-team'),
(72, 'LICENCES', 'Anti Virus', 'bih;op', 2, 'Accounts', '2024-04-15', '2024-05-01', 'me'),
(73, 'WARRANTY', 'AC', 'ftfu', 5, 'Accounts', '2024-04-15', '2024-04-30', 'bkhl;'),
(74, 'SERVICE/AMC', 'Mobile Recharge', 'jio', 10, 'DTP', '2024-04-16', '2024-04-30', 'mine'),
(75, 'LICENCES', 'Anti Virus', 'fire', 50, 'DTP', '2024-04-18', '2024-04-30', 'its me'),
(76, 'WARRANTY', 'Laptop', 'dell', 10, 'Sales and Store', '2024-04-16', '2024-04-24', 'gyusgusi'),
(77, 'WARRANTY', 'AC', 'votas', 10, 'Sales and Store', '2024-04-15', '2024-04-25', 'sdfghjk'),
(78, 'SERVER', 'Storage', 'hjjk', 12, 'Solid Works', '2024-04-16', '2024-04-24', 'nsjcanlks'),
(79, 'LICENCES', 'MS Office', 'hj', 10, 'Solid Works', '2024-04-16', '2024-05-09', 'vf;io'),
(80, 'LICENCES', 'OS', 'ms', 5, 'DTP', '2024-04-18', '2024-05-10', 'bhbk'),
(81, 'LICENCES', 'OS', 'ghh', 7, 'Accounts', '2024-04-22', '2024-05-03', 'blk'),
(82, 'LICENCES', 'AnyDesk', 'hhio', 5, 'IT Admin', '2024-09-04', '2024-09-19', 'it');

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

--
-- Table structure for table `alotted_tb`
--

CREATE TABLE `alotted_tb` (
  `userid` int(225) NOT NULL,
  `refid` int(225) NOT NULL,
  `typename` varchar(225) NOT NULL,
  `product` varchar(225) NOT NULL,
  `alocattedto` varchar(225) NOT NULL,
  `qty` int(225) NOT NULL,
  `alocatteddate` date NOT NULL,
  `remarks` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `alotted_tb`
--

INSERT INTO `alotted_tb` (`userid`, `refid`, `typename`, `product`, `alocattedto`, `qty`, `alocatteddate`, `remarks`) VALUES
(1, 1, 'OS', 'windows 10', 'Qn', 2, '2024-02-04', 'good'),
(2, 1, 'OS', 'windows 10', 'Qn', 2, '2024-02-04', 'good'),
(3, 5, 'Laptop', 'HP', 'store', 5, '2024-02-05', 'good'),
(4, 5, 'Laptop', 'HP', 'store', 5, '2024-02-05', 'good'),
(5, 6, 'AC', 'LG', 'tyrt', 1, '2024-02-03', 'lkhugyj'),
(6, 11, 'Domain', 'hoster', 'jbgvfcf', 2, '2024-02-08', 'jhgjfjgh'),
(7, 1, 'OS', 'njhghj', 'gcfvhbj', 23, '2024-03-15', 'njhkgjfghj'),
(8, 7, 'Printer', 'hpp', 'kjhbhmb', 6, '2024-03-16', 'jhgvjkhjk'),
(9, 1, 'OS', 'sacdf', 'bhjgkbk', 5, '2024-03-30', 'njhgkhjl'),
(10, 1, 'OS', 'sacdf', 'bhjgkbk', 5, '2024-03-30', 'njhgkhjl'),
(11, 1, 'OS', 'sacdf', 'bhjgkbk', 5, '2024-03-30', 'njhgkhjl'),
(12, 1, 'OS', 'sacdf', 'bhjgkbk', 5, '2024-03-30', 'njhgkhjl'),
(13, 0, 'undefined', 'undefined', 'undefined', 0, '0000-00-00', 'undefined'),
(14, 0, 'undefined', 'undefined', 'undefined', 0, '0000-00-00', 'undefined'),
(15, 5, 'Laptop', 'HP', 'njhgvjk', 3, '2024-03-17', 'jhgfcjgujln'),
(16, 6, 'AC', 'lg', 'dsas', 4, '2024-03-22', 'savdgrgwqwqq'),
(17, 12, 'Storage', 'undefined', 'svcsfasfsdsd', 3, '2024-03-22', 'asfdgfhgd'),
(18, 12, 'Storage', 'undefined', 'svcsfasfsdsd', 3, '2024-03-22', 'asfdgfhgd'),
(19, 8, 'Scanner', 'undefined', 'mnljhghcgj', 5, '2024-03-30', 'nljhgfhgk'),
(20, 3, 'Anti Virus', 'njkghfc', 'njkhjghj', 3, '2024-03-15', 'jhghhjk'),
(21, 3, 'Anti Virus', 'njkghfc', 'njkhjghj', 3, '2024-03-15', 'jhghhjk'),
(22, 3, 'Anti Virus', 'njkghfc', 'njkhjghj', 3, '2024-03-15', 'jhghhjk'),
(23, 5, 'Laptop', 'HP', 'nbjvhjbk', 4, '2024-03-21', 'njhgfjghjk'),
(24, 6, 'AC', 'LG', 'n kn', 2, '2024-03-14', 'jnjnjni'),
(25, 2, 'MS Office', 'fdf', 'qns', 4, '2024-04-11', 'good'),
(26, 2, 'MS Office', 'dsd', 'ghdg', 3, '2024-04-03', 'hfgfjg'),
(27, 1, 'OS', 'njhghj', 'ery', 7, '2024-04-05', 'good'),
(28, 18, 'Adobe', 'fghjgh', 'gh', 1, '2024-04-05', 'good'),
(29, 10, 'WIFI', 'HP ', 'dgd', 1, '2024-04-06', 'gdfgdf'),
(30, 18, 'Adobe', 'MSoft', 'ghjk', 5, '2024-04-05', 'bad'),
(31, 3, 'Anti Virus', 'njkghfc', '', 0, '0000-00-00', ''),
(32, 3, 'Anti Virus', 'firewall', 'gygi', 2, '2024-04-01', 'edge'),
(33, 2, 'MS Office', 'dsd', '', 0, '0000-00-00', ''),
(34, 5, 'Laptop', 'HP', 'ds', 5, '2024-04-06', 'egege'),
(35, 1, 'OS', 'windows 10', '', 0, '0000-00-00', ''),
(36, 3, 'Anti Virus', 'firewall', 'ss', 2, '2024-04-06', 'fegerr'),
(37, 14, 'Email', 'gmail', 'cadd', 5, '2024-04-10', 'goods'),
(38, 19, 'AnyDesk', 'hhio', 'Qn', 3, '2024-09-10', 'good'),
(39, 19, 'AnyDesk', 'hhio', 'mm', 2, '2024-09-05', 'good');

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

--
-- Table structure for table `department_tb`
--

CREATE TABLE `department_tb` (
  `dept_id` int(30) NOT NULL,
  `dept_name` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `department_tb`
--

  INSERT INTO `department_tb` (`dept_id`, `dept_name`) VALUES
  (1, 'IT ADMIN'),
  (2, 'MULTI MEDIA'),
  (3, 'CADD'),
  (4, 'QUESTION BANK'),
  (5, 'ACCOUNTS'),
  (6, 'DTP'),
  (7, 'SALES AND STORE'),
  (8, 'SOLID WORKS');

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

--
-- Table structure for table `maintenance_tb`
--

CREATE TABLE `maintenance_tb` (
  `mid` int(50) NOT NULL,
  `product` varchar(100) NOT NULL,
  `serviceby` varchar(100) NOT NULL,
  `date` date NOT NULL,
  `remark` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `maintenance_tb`
--

INSERT INTO `maintenance_tb` (`mid`, `product`, `serviceby`, `date`, `remark`) VALUES
(1, 'HP', 'Tata', '2024-02-05', 'good');

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

--
-- Table structure for table `renewdate_tb`
--

CREATE TABLE `renewdate_tb` (
  `userid` int(225) NOT NULL,
  `typename` varchar(225) NOT NULL,
  `product` varchar(225) NOT NULL,
  `renewaldate` date NOT NULL,
  `renewaldone` date NOT NULL,
  `amount` int(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `renewdate_tb`
--

INSERT INTO `renewdate_tb` (`userid`, `typename`, `product`, `renewaldate`, `renewaldone`, `amount`) VALUES
(1, 'OS', 'windows 10', '2024-02-05', '2024-02-04', 30),
(2, 'Laptop', 'HP', '2024-02-09', '2024-02-08', 2000),
(3, 'Anti Virus', 'njkghfc', '2024-02-16', '2024-02-28', 2300),
(4, 'OS', 'windows 10', '2024-02-05', '2024-03-15', 6),
(5, 'AnyDesk', 'hhio', '2024-09-18', '2024-09-19', 1000),
(6, 'Laptop', 'HP', '2024-04-01', '2024-12-04', 1111),
(7, 'Laptop', 'HP', '2024-04-01', '2024-12-12', 1111),
(8, '', 'jhgfgf', '2024-03-20', '0000-00-00', 2222),
(9, 'AnyDesk', 'hhio', '2024-09-18', '2024-09-20', 1111),
(10, 'OS', 'windows 10', '2024-02-05', '2024-09-10', 2222),
(11, 'Anti Virus', 'njkhjhn', '2024-04-29', '2024-09-04', 1111),
(12, 'OS', 'sacdf', '2024-02-14', '2024-09-04', 3333),
(13, 'AC', 'LG', '2024-02-06', '2024-09-04', 3333);

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

--
-- Table structure for table `typename_tb`
--

CREATE TABLE `typename_tb` (
  `slno` int(11) NOT NULL,
  `type_id` int(100) NOT NULL,
  `typename` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `typename_tb`
--

INSERT INTO `typename_tb` (`slno`, `type_id`, `typename`) VALUES
(1, 1, 'OS'),
(2, 1, 'MS Office'),
(3, 1, 'Anti Virus'),
(4, 2, 'System/Computer'),
(5, 2, 'Laptop'),
(6, 2, 'AC'),
(7, 2, 'Printer'),
(8, 2, 'Scanner'),
(9, 2, 'MFV'),
(10, 2, 'WIFI'),
(11, 3, 'Domain'),
(12, 3, 'Storage'),
(13, 3, 'SMS'),
(14, 3, 'Email'),
(15, 4, 'Mobile Recharge'),
(16, 4, 'Rat Poisoning'),
(17, 3, 'Server'),
(18, 1, 'Adobe'),
(19, 1, 'AnyDesk'),
(20, 1, 'PowerBI'),
(21, 1, 'Zoom'),
(22, 1, 'Flip pdf'),
(23, 1, 'Kaspersky');

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

--
-- Table structure for table `type_tb`
--

CREATE TABLE `type_tb` (
  `id` int(100) NOT NULL,
  `type` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `type_tb`
--

INSERT INTO `type_tb` (`id`, `type`) VALUES
(1, 'LICENCES'),
(2, 'WARRANTY'),
(3, 'SERVER'),
(4, 'SERVICE/AMC');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `addtoregister_tb`
--
ALTER TABLE `addtoregister_tb`
  ADD PRIMARY KEY (`userid`);

--
-- Indexes for table `alotted_tb`
--
ALTER TABLE `alotted_tb`
  ADD PRIMARY KEY (`userid`);

--
-- Indexes for table `department_tb`
--
ALTER TABLE `department_tb`
  ADD PRIMARY KEY (`dept_id`);

--
-- Indexes for table `maintenance_tb`
--
ALTER TABLE `maintenance_tb`
  ADD PRIMARY KEY (`mid`);

--
-- Indexes for table `renewdate_tb`
--
ALTER TABLE `renewdate_tb`
  ADD PRIMARY KEY (`userid`);

--
-- Indexes for table `typename_tb`
--
ALTER TABLE `typename_tb`
  ADD PRIMARY KEY (`slno`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `addtoregister_tb`
--
ALTER TABLE `addtoregister_tb`
  MODIFY `userid` int(225) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- AUTO_INCREMENT for table `alotted_tb`
--
ALTER TABLE `alotted_tb`
  MODIFY `userid` int(225) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `department_tb`
--
ALTER TABLE `department_tb`
  MODIFY `dept_id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

--
-- AUTO_INCREMENT for table `renewdate_tb`
--
ALTER TABLE `renewdate_tb`
  MODIFY `userid` int(225) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `typename_tb`
--
ALTER TABLE `typename_tb`
  MODIFY `slno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `type_tb`
--
ALTER TABLE `type_tb`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

