--
-- Host: localhost    Database: wallaby
-- ------------------------------------------------------


--
-- Current Database: `wallaby`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `wallaby` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

USE `wallaby`;

--
-- Table structure for table `bank`
--

CREATE TABLE `bank` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bankname` varchar(50) NOT NULL,
  `createduser` varchar(50) NOT NULL,
  `createddate` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bank`
--

INSERT INTO `bank` VALUES (1,'American Express (Credit Card)','user','2021-11-23 04:47:59'),(2,'Capital One (Credit Card)','user','2021-11-23 04:48:03'),(3,'JPMC Chase','user','2021-11-23 04:48:10'),(5,'US Bank','user','2021-11-26 03:05:53'),(6,'Wings Financial','admin','2021-12-09 03:09:08'),(7,'Riverland','admin','2021-12-11 02:26:49');

--
-- Table structure for table `banktransactions`
--

CREATE TABLE `banktransactions` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `description` varchar(200) NOT NULL,
  `amount` varchar(20) NOT NULL,
  `transactiontype` varchar(10) NOT NULL,
  `filetype` varchar(20) NOT NULL,
  `userid` int(5) NOT NULL,
  `username` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `banktransactions`
--

INSERT INTO `banktransactions` VALUES (1,'2021-12-28',' ONLINE TRF TO *488','8000','Spent','Bank Statement',2,'user'),(2,'2021-12-27','Check','2733.95','Spent','Bank Statement',2,'user'),(3,'2021-12-27','CPENERGY MNGCO MGC ACH DR 006402302600','301.56','Spent','Bank Statement',2,'user'),(4,'2021-12-24','Check','23100','Spent','Bank Statement',2,'user'),(5,'2021-12-24','Check','878.75','Spent','Bank Statement',2,'user'),(6,'2021-12-24','FORD MOTOR CR FORDCREDIT XXXXX5507','824.39','Spent','Bank Statement',2,'user'),(7,'2021-12-24','AMEX EPAYMENT ACH PMT W2736','22576.55','Spent','Bank Statement',2,'user'),(8,'2021-12-24','Check','85','Spent','Bank Statement',2,'user'),(9,'2021-12-22','Check','3889.94','Spent','Bank Statement',2,'user'),(10,'2021-12-22','Check','490','Spent','Bank Statement',2,'user'),(11,'2021-12-22','Check','3957.5','Spent','Bank Statement',2,'user'),(12,'2021-12-22','TRANSFER TO Small Business ACCOUNT 7308166','1639.03','Spent','Bank Statement',2,'user'),(13,'2021-12-22','FORD MOTOR CR FORDCREDIT XXXXX4568','809.59','Spent','Bank Statement',2,'user'),(14,'2021-12-22','AMEX EPAYMENT ACH PMT W7796','154670.19','Spent','Bank Statement',2,'user'),(15,'2021-12-21','Check','1115.15','Spent','Bank Statement',2,'user'),(16,'2021-12-21','TRANSFER TO Small Business ACCOUNT 7308166','298','Spent','Bank Statement',2,'user'),(17,'2021-12-20','Check','5000','Spent','Bank Statement',2,'user'),(18,'2021-12-20','Check','5302.5','Spent','Bank Statement',2,'user'),(19,'2021-12-20','Check','200','Spent','Bank Statement',2,'user'),(20,'2021-12-20','REMOTE DEPOSIT','5700','Received','Bank Statement',2,'user'),(21,'2021-12-20','REMOTE DEPOSIT','303430','Received','Bank Statement',2,'user'),(22,'2021-12-17','TRANSFER TO Small Business ACCOUNT 7308166','4407.98','Spent','Bank Statement',2,'user'),(23,'2021-12-17','Check','900','Spent','Bank Statement',2,'user'),(24,'2021-12-16','TRANSFER TO Small Business ACCOUNT 7308166','9618.7','Spent','Bank Statement',2,'user'),(25,'2021-12-16','REMOTE DEPOSIT','49419.96','Received','Bank Statement',2,'user'),(26,'2021-12-16','REMOTE DEPOSIT','425','Received','Bank Statement',2,'user'),(27,'2021-12-15','CITI AUTOPAY PAYMENT 080616950450552','927.78','Spent','Bank Statement',2,'user'),(28,'2021-12-15','Check','120','Spent','Bank Statement',2,'user'),(29,'2021-12-14','Check','10000','Spent','Bank Statement',2,'user'),(30,'2021-12-14','Check','13242.2','Spent','Bank Statement',2,'user'),(31,'2021-12-14','Check','160','Spent','Bank Statement',2,'user'),(32,'2021-12-14','Check','3983.58','Spent','Bank Statement',2,'user'),(33,'2021-12-13','SOUTH SUBURBAN A PAYMENT XX014IYXACX322','325.59','Spent','Bank Statement',2,'user'),(34,'2021-12-10','TRANSFER TO Small Business ACCOUNT 7308166','1639.03','Spent','Bank Statement',2,'user'),(35,'2021-12-10','MEDICA EDI PAYMTS 5411242261','3475.87','Spent','Bank Statement',2,'user'),(36,'2021-12-10','Check','3096.12','Spent','Bank Statement',2,'user'),(37,'2021-12-08','Check','375','Spent','Bank Statement',2,'user'),(38,'2021-12-07','REMOTE DEPOSIT','5990','Received','Bank Statement',2,'user'),(39,'2021-12-07','Check','33737.83','Spent','Bank Statement',2,'user'),(40,'2021-12-07','Check','5162','Spent','Bank Statement',2,'user'),(41,'2021-12-07','Check','25','Spent','Bank Statement',2,'user'),(42,'2021-12-07','TRANSFER TO Small Business ACCOUNT 7308166','298','Spent','Bank Statement',2,'user'),(43,'2021-12-07','PAYMENT TO COMMERCIAL REVOLVING LOAN 8015957','16641.45','Spent','Bank Statement',2,'user'),(44,'2021-12-06','REMOTE DEPOSIT','290','Received','Bank Statement',2,'user'),(45,'2021-12-06','REMOTE DEPOSIT','2988.5','Received','Bank Statement',2,'user'),(46,'2021-12-06','Check','7511','Spent','Bank Statement',2,'user'),(47,'2021-12-06','AMEX EPAYMENT ACH PMT W1564','132668.67','Spent','Bank Statement',2,'user'),(48,'2021-12-06','Check','540.13','Spent','Bank Statement',2,'user'),(49,'2021-12-06','REMOTE DEPOSIT','192850','Received','Bank Statement',2,'user'),(50,'2021-12-06','Check','10740','Spent','Bank Statement',2,'user'),(51,'2021-12-06','Check','9125','Spent','Bank Statement',2,'user'),(52,'2021-12-06','Check','4020','Spent','Bank Statement',2,'user'),(53,'2021-12-06','ADVANCE FROM COMMERCIAL REVOLVING LOAN 8015957','16641.45','Received','Bank Statement',2,'user'),(54,'2021-12-03','Check','10000','Spent','Bank Statement',2,'user'),(55,'2021-12-03','TRANSFER TO Small Business ACCOUNT 7308166','4312.24','Spent','Bank Statement',2,'user'),(56,'2021-12-02','PLIC-SBD INSUR CLM PACT#XXXXX3849','992.88','Spent','Bank Statement',2,'user'),(57,'2021-12-02','TRANSFER TO Small Business ACCOUNT 7308166','9422.28','Spent','Bank Statement',2,'user'),(58,'2021-12-01','REMOTE DEPOSIT','2550.14','Received','Bank Statement',2,'user'),(59,'2021-12-01','REMOTE DEPOSIT','8696.28','Received','Bank Statement',2,'user'),(60,'2021-12-01','XCEL ENERGY-MN XCELENERGY 00130495741','457.21','Spent','Bank Statement',2,'user'),(61,'2021-12-01','WF DEALER SVCES ONLINE PMT CKF698784085POS','695.19','Spent','Bank Statement',2,'user'),(62,'2021-12-01','Check','2383.72','Spent','Bank Statement',2,'user'),(63,'2021-11-30','Check','3006.25','Spent','Bank Statement',2,'user'),(64,'2021-11-30','Check','117','Spent','Bank Statement',2,'user'),(65,'2021-11-30','Check','584.43','Spent','Bank Statement',2,'user'),(66,'2021-11-30','Check','28932.21','Spent','Bank Statement',2,'user'),(67,'2021-11-30','Check','9279.09','Spent','Bank Statement',2,'user'),(68,'2021-11-29','Check','382.42','Spent','Bank Statement',2,'user'),(69,'2021-11-29','TRANSFER TO Small Business ACCOUNT 7308166','3.5','Spent','Bank Statement',2,'user'),(70,'2021-11-29','Transfer to 7304488','8000','Spent','Bank Statement',2,'user'),(71,'2021-11-29','Check','646.15','Spent','Bank Statement',2,'user'),(72,'2021-11-29','CPENERGY MNGCO MGC ACH DR 006402302600','46.2','Spent','Bank Statement',2,'user');

--
-- Table structure for table `categorized_csv_columns`
--

CREATE TABLE `categorized_csv_columns` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `columnname` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `categorized_csv_columns`
--

INSERT INTO `categorized_csv_columns` VALUES (1,'DATE'),(2,'DESCRIPTION'),(3,'AMOUNT'),(4,'ADDED OR MATCHED'),(5,'Rule');

--
-- Table structure for table `combine_transaction`
--

CREATE TABLE `combine_transaction` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `description` varchar(200) NOT NULL,
  `amount` varchar(20) NOT NULL,
  `transactiontype` varchar(10) NOT NULL,
  `filetype` varchar(20) NOT NULL,
  `userid` int(5) NOT NULL,
  `username` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=72 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `combine_transaction`
--

INSERT INTO `combine_transaction` VALUES (1,'2021-12-27','Check 752','2733.95','Spent','For review',2,'user'),(2,'2021-12-27','Cpenergy Mngco Mgc','301.56','Spent','For review',2,'user'),(3,'2021-12-24','Ford','824.39','Spent','For review',2,'user'),(4,'2021-12-24','American Express','22576.55','Spent','For review',2,'user'),(5,'2021-12-24','Check 748','878.75','Spent','For review',2,'user'),(6,'2021-12-24','Check 758','23100.00','Spent','For review',2,'user'),(7,'2021-12-24','Check 692','85.00','Spent','For review',2,'user'),(8,'2021-12-22','Check 751','3957.50','Spent','For review',2,'user'),(9,'2021-12-22','Transfer Small Business Account No:7308166','1639.03','Spent','For review',2,'user'),(10,'2021-12-22','Check 750','490.00','Spent','For review',2,'user'),(11,'2021-12-22','Ford','809.59','Spent','For review',2,'user'),(12,'2021-12-22','American Express','154670.19','Spent','For review',2,'user'),(13,'2021-12-22','Check 746','3889.94','Spent','For review',2,'user'),(14,'2021-12-21','Check 747','1115.15','Spent','For review',2,'user'),(15,'2021-12-21','Transfer Small Business Account No:7308166','298.00','Spent','For review',2,'user'),(16,'2021-12-20','Remote Deposit','5700.00','Received','For review',2,'user'),(17,'2021-12-20','Check 755','5000.00','Spent','For review',2,'user'),(18,'2021-12-20','Check 754','5302.50','Spent','For review',2,'user'),(19,'2021-12-20','Check 753','200.00','Spent','For review',2,'user'),(20,'2021-12-20','Remote Deposit','303430.00','Received','For review',2,'user'),(21,'2021-12-17','Transfer Small Business Account No:7308166','4407.98','Spent','For review',2,'user'),(22,'2021-12-17','Check 744','900.00','Spent','For review',2,'user'),(23,'2021-12-16','Transfer Small Business Account No:7308166','9618.70','Spent','For review',2,'user'),(24,'2021-12-16','Remote Deposit','49419.96','Received','For review',2,'user'),(25,'2021-12-16','Remote Deposit','425.00','Received','For review',2,'user'),(26,'2021-12-15','Check 740','120.00','Spent','For review',2,'user'),(27,'2021-12-14','Check 742','160.00','Spent','For review',2,'user'),(28,'2021-12-14','Check 743','3983.58','Spent','For review',2,'user'),(29,'2021-12-14','Check 741','13242.20','Spent','For review',2,'user'),(30,'2021-12-13','South Suburban Asphalt','325.59','Spent','For review',2,'user'),(31,'2021-12-10','Medica Edi Paymts','3475.87','Spent','For review',2,'user'),(32,'2021-12-07','Transfer Small Business Account No:7308166','298.00','Spent','For review',2,'user'),(33,'2021-12-15','Citi Autopay','927.78','Spent','Categorized',2,'user'),(34,'2021-12-14','Check 92','10000.00','Spent','Categorized',2,'user'),(35,'2021-12-10','Transfer Small Business Account No:7308166','1639.03','Spent','Categorized',2,'user'),(36,'2021-12-10','Check 738','3096.12','Spent','Categorized',2,'user'),(37,'2021-12-08','Check 724','375.00','Spent','Categorized',2,'user'),(38,'2021-12-07','Remote Deposit','5990.00','Received','Categorized',2,'user'),(39,'2021-12-07','Check 739','25.00','Spent','Categorized',2,'user'),(40,'2021-12-07','Commercial Revolving Loan','16641.45','Spent','Categorized',2,'user'),(41,'2021-12-07','Check 736','5162.00','Spent','Categorized',2,'user'),(42,'2021-12-07','Check 735','33737.83','Spent','Categorized',2,'user'),(43,'2021-12-06','Check 737','4020.00','Spent','Categorized',2,'user'),(44,'2021-12-06','Remote Deposit','192850.00','Received','Categorized',2,'user'),(45,'2021-12-06','Check 733','9125.00','Spent','Categorized',2,'user'),(46,'2021-12-06','Remote Deposit','290.00','Received','Categorized',2,'user'),(47,'2021-12-06','Check 731','7511.00','Spent','Categorized',2,'user'),(48,'2021-12-06','Check 732','10740.00','Spent','Categorized',2,'user'),(49,'2021-12-06','Remote Deposit','2988.50','Received','Categorized',2,'user'),(50,'2021-12-06','Check 730','540.13','Spent','Categorized',2,'user'),(51,'2021-12-06','American Express','132668.67','Spent','Categorized',2,'user'),(52,'2021-12-06','Advance Commercial Revolving','16641.45','Received','Categorized',2,'user'),(53,'2021-12-03','Check 734','10000.00','Spent','Categorized',2,'user'),(54,'2021-12-03','Transfer Small Business Account No:7308166','4312.24','Spent','Categorized',2,'user'),(55,'2021-12-02','Plic Sbd Insur','992.88','Spent','Categorized',2,'user'),(56,'2021-12-02','Transfer Small Business Account No:7308166','9422.28','Spent','Categorized',2,'user'),(57,'2021-12-01','Xcel Energy','457.21','Spent','Categorized',2,'user'),(58,'2021-12-01','Check 726','2383.72','Spent','Categorized',2,'user'),(59,'2021-12-01','Remote Deposit','2550.14','Received','Categorized',2,'user'),(60,'2021-12-01','Remote Deposit','8696.28','Received','Categorized',2,'user'),(61,'2021-12-01','Wf Dealer Svces','695.19','Spent','Categorized',2,'user'),(62,'2021-11-30','Check 723','28932.21','Spent','Categorized',2,'user'),(63,'2021-11-30','Check 727','117.00','Spent','Categorized',2,'user'),(64,'2021-11-30','Check 722','584.43','Spent','Categorized',2,'user'),(65,'2021-11-30','Check 725','9279.09','Spent','Categorized',2,'user'),(66,'2021-11-30','Check 728','3006.25','Spent','Categorized',2,'user'),(67,'2021-11-29','Transfer','8000.00','Spent','Categorized',2,'user'),(68,'2021-11-29','Check 716','646.15','Spent','Categorized',2,'user'),(69,'2021-11-29','Cpenergy Mngco Mgc','46.20','Spent','Categorized',2,'user'),(70,'2021-11-29','Transfer Small Business Account No:7308166','3.50','Spent','Categorized',2,'user'),(71,'2021-11-29','Check 729','382.42','Spent','Categorized',2,'user');

--
-- Table structure for table `forreview_csv_columns`
--

CREATE TABLE `forreview_csv_columns` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `columnname` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `forreview_csv_columns`
--

INSERT INTO `forreview_csv_columns` VALUES (1,'DATE'),(2,'DESCRIPTION'),(3,'Category or Match'),(4,'SPENT'),(5,'RECEIVED');

--
-- Table structure for table `mytesttable`
--

CREATE TABLE `mytesttable` (
  `pdffileid` varchar(100) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
  `billDate` varchar(20) NOT NULL,
  `vendorName` varchar(50) NOT NULL,
  `status` varchar(20) NOT NULL,
  `id` int(4) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mytesttable`
--

INSERT INTO `mytesttable` VALUES ('1AuUdCcTd0082rrKleiQk962JIDjsXWy1','2024-05-08','New Island Group Inc','Validated',1);

--
-- Table structure for table `reconcilationsettings`
--

CREATE TABLE `reconcilationsettings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bank` varchar(100) NOT NULL,
  `colofdate` varchar(10) NOT NULL,
  `pos_colofdate` int(3) NOT NULL,
  `dateformat` varchar(100) NOT NULL,
  `colofdescription` varchar(100) NOT NULL,
  `pos_colofdescription` int(2) NOT NULL,
  `twooronecols` varchar(100) NOT NULL,
  `colofamount1` varchar(10) NOT NULL,
  `pos_colofamount1` int(2) NOT NULL,
  `colofamount2` varchar(10) NOT NULL,
  `pos_colofamount2` int(2) NOT NULL,
  `purchasepositvienegative` varchar(100) NOT NULL,
  `acdisplaynegative` varchar(100) NOT NULL,
  `userid` int(3) NOT NULL,
  `username` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `reconcilationsettings`
--

INSERT INTO `reconcilationsettings` VALUES (4,'American Express (Credit Card)','Column A',1,'Month-Day-Year with leading zeors | xx/xx/xxxx','Column C',3,'One Column | Debit and Credit','Column F',6,'N/A',0,'Positive w/o Dollar Sign | xx.xx','Negative With Minus Sign | -xx.xx or -$xx.xx',2,'user'),(7,'US Bank','Column A',1,'Month-Day-Year with leading zeors | xx/xx/xxxx','Column C',3,'One Column | Debit and Credit','Column E',5,'N/A',0,'Positive w/o Dollar Sign | xx.xx','Negative With Minus Sign | -xx.xx or -$xx.xx',2,'user'),(6,'Capital One (Credit Card)','Column A',1,'Month-Day-Year with leading zeors | xx/xx/xxxx','Column D',4,'Two Columns | Debit and Credit','Column F',6,'Column G',7,'Positive w/o Dollar Sign | xx.xx','Negative With Minus Sign | -xx.xx or -$xx.xx',2,'user'),(10,'Wings Financial','Column A',1,'Month-Day-Year with leading zeors | xx/xx/xxxx','Column B',2,'One Column | Debit and Credit','Column E',5,'N/A',0,'Positive w/o Dollar Sign | xx.xx','Negative With Minus Sign | -xx.xx or -$xx.xx',1,'admin'),(11,'Riverland','Column A',1,'Month-Day-Year with leading zeors | xx/xx/xxxx','Column C',3,'One Column | Debit and Credit','Column D',4,'N/A',0,'Positive w/o Dollar Sign | xx.xx','Negative With Minus Sign | -xx.xx or -$xx.xx',1,'admin');


