CREATE DATABASE  IF NOT EXISTS `vigyanadb` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `vigyanadb`;
--
-- Host: localhost    Database: vigyanadb
-- ------------------------------------------------------


--
-- Table structure for table `credit`
--

CREATE TABLE `credit` (
  `username` varchar(15) DEFAULT NULL,
  `creditDate` datetime DEFAULT NULL,
  `creditLimit` int(11) DEFAULT NULL,
  `refno` varchar(50) DEFAULT NULL,
  `creditcode` varchar(50) DEFAULT NULL,
  `data1` varchar(45) DEFAULT NULL,
  `data2` varchar(45) DEFAULT NULL,
  `data3` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `credit`
--

INSERT INTO `credit` VALUES ('f','2024-07-05 00:00:00',12,'','f0001','','',''),('f','2024-07-05 00:00:00',3,'','f0002','','',''),('f','2024-07-05 00:00:00',11,'','f0003','','',''),('f','2024-07-05 00:00:00',11,'','f0004','','',''),('f','2024-07-05 00:00:00',11,'','f0005','','',''),('f','2024-07-05 00:00:00',11,'','f0006','','',''),('f','2024-07-05 00:00:00',11,'','f0007','','',''),('f','2024-07-05 00:00:00',11,'','f0008','','',''),('f','2024-07-05 00:00:00',111,'','f0009','','',''),('f','2024-07-05 00:00:00',1,'','f0010','','',''),('f','2024-07-05 00:00:00',1,'','f0011','','',''),('f','2024-07-05 00:00:00',1,'','f0012','','',''),('f','2024-07-05 00:00:00',1,'','f0013','','',''),('f','2024-07-05 00:00:00',1,'','f0014','','',''),('f','2024-07-05 00:00:00',1,'','f0015','','',''),('f','2024-07-05 00:00:00',1,'','f0016','','',''),('f','2024-07-05 00:00:00',1,'','f0017','','',''),('f','2024-07-05 00:00:00',1,'','f0018','','',''),('f','2024-07-05 00:00:00',1,'','f0019','','',''),('f','2024-07-05 00:00:00',1,'','f0020','','',''),('f','2024-07-05 00:00:00',1,'','f0021','','',''),('f','2024-07-05 00:00:00',1,'','f0022','','',''),('f','2024-07-05 00:00:00',1,'','f0023','','',''),('f','2024-07-05 00:00:00',1,'','f0024','','',''),('f','2024-07-05 00:00:00',1,'','f0025','','',''),('b','2024-07-27 00:00:00',2,'abc','b0001','','',''),('c','2024-07-27 00:00:00',2,'xyz','c0001','','',''),('d','2024-07-27 00:00:00',5,'pqr','d0001','','',''),('d','2024-07-27 00:00:00',5,'rts','d0002','','',''),('e','2024-07-29 00:00:00',5,'rts','e0001','','',''),('e','2024-07-29 00:00:00',10,'sdf','e0002','','',''),('e','2024-07-30 00:00:00',50,'','e0003','','',''),('a','2024-08-28 00:00:00',10,'qty','a0001','','',''),('a','2024-09-24 00:00:00',10,'sdf','a0002','','',''),('a','2024-09-24 00:00:00',500,'tyh','a0003','','',''),('e','2025-05-07 00:00:00',5,'vbhvbh','e0004','','','');

--
-- Table structure for table `credithistory`
--

CREATE TABLE `credithistory` (
  `username` varchar(15) DEFAULT NULL,
  `useDate` datetime DEFAULT NULL,
  `creditcode` varchar(50) DEFAULT NULL,
  `data1` varchar(45) DEFAULT NULL,
  `data2` varchar(45) DEFAULT NULL,
  `data3` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `credithistory`
--

INSERT INTO `credithistory` VALUES ('b','2024-07-27 16:34:05','b0001','','',''),('c','2024-07-27 16:43:20','c0001','','',''),('d','2024-07-27 17:13:44','d0001','','',''),('d','2024-07-27 17:30:22','d0002','','',''),('d','2024-07-27 17:41:28','d0002','','',''),('d','2024-07-27 17:46:20','d0002','','',''),('d','2024-07-27 17:51:25','d0002','','',''),('e','2024-07-29 12:43:37','e0001','','',''),('e','2024-07-29 12:50:09','e0001','','',''),('e','2024-07-29 12:53:58','e0001','','',''),('e','2024-07-29 13:44:30','e0001','','',''),('e','2024-07-29 13:50:41','e0001','','',''),('e','2024-07-29 13:57:47','e0002','','',''),('e','2024-07-29 14:01:11','e0002','','',''),('e','2024-07-29 14:16:04','e0002','','',''),('e','2024-07-30 12:55:55','e0003','','',''),('e','2024-07-30 13:01:35','e0003','','',''),('e','2024-07-30 13:06:49','e0003','','',''),('e','2024-07-30 13:11:59','e0003','','',''),('e','2024-07-30 13:25:27','e0003','','',''),('e','2024-07-30 13:29:27','e0003','','',''),('e','2024-07-30 13:34:16','e0003','','',''),('e','2024-08-22 16:28:20','e0003','','',''),('a','2024-09-21 11:04:07','a0001','','',''),('a','2024-09-21 11:06:34','a0001','','',''),('a','2024-09-23 14:02:52','a0001','','',''),('a','2024-09-23 14:14:32','a0001','','',''),('a','2024-09-23 14:18:07','a0001','','',''),('a','2024-09-23 14:43:16','a0001','','',''),('a','2024-09-23 14:55:59','a0001','','',''),('a','2024-09-23 14:58:42','a0001','','',''),('a','2024-09-23 16:30:57','a0001','','',''),('a','2024-09-24 12:15:45','a0001','','',''),('a','2024-09-24 12:24:07','a0002','','',''),('a','2024-09-24 12:38:59','a0002','','',''),('a','2024-09-24 12:42:49','a0002','','',''),('a','2024-09-24 12:48:46','a0002','','',''),('a','2024-09-24 12:50:45','a0002','','',''),('a','2024-09-24 12:52:38','a0002','','',''),('a','2024-09-24 12:58:16','a0002','','',''),('a','2024-09-24 13:16:22','a0002','','',''),('a','2024-09-24 13:34:05','a0002','','',''),('a','2024-09-24 13:42:10','a0002','','',''),('a','2024-09-24 13:47:02','a0003','','',''),('a','2024-09-24 13:48:05','a0003','','',''),('a','2024-09-24 15:23:00','a0003','','',''),('a','2024-09-25 13:00:43','a0003','','',''),('a','2024-09-25 13:02:37','a0003','','',''),('a','2024-09-28 15:24:17','a0003','','',''),('a','2024-09-28 15:30:08','a0003','','',''),('a','2024-09-28 15:42:59','a0003','','',''),('a','2024-09-30 11:02:37','a0003','','',''),('a','2024-09-30 11:12:57','a0003','','',''),('a','2024-09-30 12:00:23','a0003','','',''),('a','2024-09-30 12:03:37','a0003','','',''),('a','2024-09-30 12:24:50','a0003','','',''),('a','2024-09-30 14:11:34','a0003','','',''),('a','2024-09-30 14:17:42','a0003','','',''),('a','2024-09-30 14:26:55','a0003','','',''),('a','2024-09-30 14:39:59','a0003','','',''),('A','2024-10-03 11:27:09','a0003','','',''),('a','2024-10-03 11:29:36','a0003','','',''),('a','2024-10-07 10:32:04','a0003','','',''),('a','2024-10-07 10:32:25','a0003','','',''),('a','2024-10-07 11:24:37','a0003','','',''),('a','2024-10-07 11:35:40','a0003','','',''),('a','2024-10-07 11:38:03','a0003','','',''),('a','2024-10-07 11:42:46','a0003','','',''),('a','2024-10-07 11:49:56','a0003','','',''),('a','2024-10-07 11:52:43','a0003','','',''),('a','2024-10-07 11:55:44','a0003','','',''),('a','2024-10-07 12:09:18','a0003','','',''),('a','2024-10-07 12:26:30','a0003','','',''),('a','2024-10-07 12:31:13','a0003','','',''),('a','2024-10-07 12:38:08','a0003','','',''),('a','2024-10-07 12:51:32','a0003','','',''),('a','2024-10-07 12:57:44','a0003','','',''),('a','2024-10-07 13:05:49','a0003','','',''),('a','2024-10-07 13:11:15','a0003','','',''),('a','2024-10-14 14:07:33','a0003','','',''),('a','2024-10-14 14:14:36','a0003','','',''),('a','2024-10-14 14:20:28','a0003','','',''),('a','2024-10-14 14:24:02','a0003','','',''),('a','2024-10-21 15:47:39','a0003','','',''),('a','2024-10-21 16:13:03','a0003','','',''),('a','2024-10-21 16:29:26','a0003','','',''),('a','2024-10-21 16:44:21','a0003','','',''),('a','2024-10-21 16:55:53','a0003','','',''),('a','2024-10-21 17:13:05','a0003','','',''),('a','2024-10-21 17:20:24','a0003','','',''),('a','2024-10-21 17:47:20','a0003','','',''),('a','2024-10-21 17:52:51','a0003','','',''),('a','2024-10-21 17:58:04','a0003','','',''),('a','2024-10-21 18:01:08','a0003','','',''),('a','2025-01-13 14:11:58','a0003','','',''),('a','2025-01-13 14:14:36','a0003','','',''),('a','2025-01-13 14:15:09','a0003','','',''),('a','2025-01-13 14:15:28','a0003','','',''),('a','2025-01-13 14:15:56','a0003','','',''),('a','2025-01-13 14:29:04','a0003','','',''),('a','2025-01-13 14:31:25','a0003','','',''),('a','2025-01-13 14:33:39','a0003','','',''),('a','2025-01-13 14:40:27','a0003','','',''),('a','2025-01-13 14:48:04','a0003','','',''),('a','2025-01-13 14:58:21','a0003','','','');


