--
-- Host: localhost    Database: dubentry
-- ------------------------------------------------------


--
-- Table structure for table `capital`
--

CREATE TABLE `capital` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `type` varchar(25) DEFAULT NULL,
  `amount` decimal(8,2) DEFAULT NULL,
  `comment` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `capital`
--

INSERT INTO `capital` VALUES (1,'2024-03-16',NULL,1000.00,'initial funding');

--
-- Table structure for table `checking`
--

CREATE TABLE `checking` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `amount` decimal(8,2) DEFAULT NULL,
  `comment` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `checking`
--

INSERT INTO `checking` VALUES (1,'2024-03-16',1000.00,'initial funding'),(2,'2024-03-16',-40.00,'flour purchase'),(3,'2024-03-16',-60.00,'coffee cups'),(4,'2024-03-16',-500.00,'rent');

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` int(7) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `type` varchar(25) DEFAULT NULL,
  `amount` decimal(8,2) DEFAULT NULL,
  `comment` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `expenses`
--

INSERT INTO `expenses` VALUES (1,'2024-03-16','supplies',40.00,'flour purchase'),(2,'2024-03-16','supplies',60.00,'coffee cups'),(3,'2024-03-16','rent',500.00,'rent');

--
-- Table structure for table `genledger`
--

CREATE TABLE `genledger` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `amount` decimal(8,2) DEFAULT NULL,
  `t1` varchar(15) DEFAULT NULL,
  `t2` varchar(15) DEFAULT NULL,
  `a1dc` varchar(15) DEFAULT NULL,
  `a2dc` varchar(15) DEFAULT NULL,
  `comments` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `genledger`
--

INSERT INTO `genledger` VALUES (1,'2024-03-16',1000.00,'checking','capital','debit','credit','initial funding'),(2,'2024-03-16',40.00,'expenses','checking','debit','credit','flour purchase'),(3,'2024-03-16',60.00,'expenses','checking','debit','credit','coffee cups'),(4,'2024-03-16',500.00,'expenses','checking','debit','credit','rent'),(5,'2024-03-16',147.00,'checking','revenue','debit','credit','daily sales');

--
-- Table structure for table `revenue`
--

CREATE TABLE `revenue` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `amount` decimal(6,2) DEFAULT NULL,
  `comment` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `revenue`
--

INSERT INTO `revenue` VALUES (1,'2024-03-16',147.00,'daily sales');


