-- MariaDB dump 10.19  Distrib 10.11.6-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: acc
-- ------------------------------------------------------
-- Server version	10.11.6-MariaDB-0+deb12u1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `accounts`
--

DROP TABLE IF EXISTS `accounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `number` varchar(50) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `parent` int(11) DEFAULT NULL,
  `is_parent` varchar(100) NOT NULL DEFAULT 'false',
  `is_accountype` varchar(100) NOT NULL DEFAULT '0',
  `is_gl` varchar(100) NOT NULL DEFAULT '0',
  `is_account_classification` varchar(100) NOT NULL DEFAULT '0',
  `is_subsidiary` varchar(100) NOT NULL DEFAULT 'NO',
  `normal_balance` varchar(100) DEFAULT NULL,
  `account_type` varchar(100) DEFAULT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `number` (`number`,`name`,`parent`,`position`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `accounts`
--

LOCK TABLES `accounts` WRITE;
/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
INSERT INTO `accounts` VALUES
(1,'1','2',0,'1','0','0','0','0','Debit Balance','Nominal Account',0,'test desc',2,'2024-07-09 06:16:42'),
(2,'11','22',0,'1','0','0','0','0','Credit Balance','Real Account',0,'test desc 1111',2,'2024-07-09 06:18:53'),
(3,'1','ASSETS',0,'1','0','0','0','0','Debit Balance','Real Account',0,'Assets - account description',2,'2024-07-09 06:20:15'),
(4,'2','LIABILITIES',0,'1','YES','0','0','0','Credit Balance','Real Account',2,'Liabilities',0,'2024-07-09 09:23:27'),
(5,'000003','Cash In Bank',4,'1','0','0','0','0','Debit Balance','Nominal Account',0,'111',2,'2024-07-09 09:23:43'),
(6,'2','2',0,'1','0','0','0','0','Debit Balance','Real Account',0,'2',2,'2024-07-09 11:58:38'),
(7,'22','22',6,'1','0','0','0','0','Debit Balance','Real Account',0,'22',2,'2024-07-09 12:01:02'),
(8,'222','222',7,'0','0','0','0','0','Debit Balance','Real Account',0,'222',2,'2024-07-09 12:01:14'),
(9,'3','3',0,'1','0','0','0','0','Credit Balance','Nominal Account',0,'3',2,'2024-07-09 13:52:45'),
(10,'000004','Non-Current Assets',3,'1','0','0','0','0','Debit Balance','Real Account',0,'Non-Current Assets',2,'2024-07-09 14:55:56'),
(11,'34','4',0,'1','0','0','0','0','Debit Balance','Real Account',0,'4',2,'2024-07-10 07:27:23'),
(12,'000005','BDO',5,'1','0','0','0','0','Debit Balance','Real Account',0,'Banco De Oro',2,'2024-07-10 11:30:38'),
(13,'000005','BPI',5,'','0','0','0','0','Debit Balance','Real Account',0,'Bank of Philippine Islands',2,'2024-07-10 11:31:16'),
(14,'55','55',0,'1','0','0','0','0','Debit Balance','Real Account',0,'55',2,'2024-07-11 01:46:44'),
(15,'6','6',0,'1','0','0','0','0','Credit Balance','Real Account',0,'6',2,'2024-07-11 01:47:35'),
(16,'3','EQUITY',0,'1','YES','0','0','0','Credit Balance','Real Account',3,'',0,'2024-07-11 01:57:46'),
(17,'4','INCOME',0,'1','YES','0','0','0','Credit Balance','Nominal Account',4,'',0,'2024-07-11 01:58:41'),
(18,'5','EXPENSE',0,'1','YES','0','0','0','Debit Balance','Nominal Account',5,'',0,'2024-07-11 01:59:10'),
(19,'01','Cash',19,'1','0','0','0','0','Debit Balance','Real Account',1,'',2,'2024-07-11 01:59:52'),
(20,'22222','222',0,'1','0','0','0','0','Debit Balance','Real Account',0,'22',2,'2024-07-11 02:04:32'),
(21,'111111','',0,'','0','0','0','0','','',0,'',2,'2024-07-11 02:05:06'),
(22,'1-01','account under asset account',19,'1','0','0','0','0','Debit Balance','Real Account',1,'account under asset account',0,'2024-07-11 02:21:23'),
(23,'1-01-01','another accont under the account',22,'0','0','0','0','0','Debit Balance','Real Account',1,'another accont under the account',0,'2024-07-11 02:22:42'),
(24,'1','Cash',24,'1','0','0','0','0','Debit Balance','Real Account',1,'',0,'2024-07-11 04:27:43'),
(25,'1','ASSETS',0,'NO','YES','NO','0','0','Debit Balance','Real Account',0,'',0,'2024-07-11 04:30:05'),
(26,'11','22',0,'YES','YES','YES','0','0','Debit Balance','',3,'33',2,'2024-07-11 10:06:33'),
(27,'1','General Ledger Account',25,'NO','NO','YES','0','0','Debit Balance','Real Account',1,'1',2,'2024-07-11 10:09:12'),
(28,'1','subsidiary account',27,'YES','NO','NO','0','0','Debit Balance','Real Account',3,'test',0,'2024-07-11 11:16:17'),
(29,'2','another subsidiary account',27,'NO','NO','NO','0','0','Debit Balance','Real Account',3,'test',0,'2024-07-11 11:16:55'),
(30,'1','sub subsidary accountt',28,'YES','NO','NO','0','0','Debit Balance','Real Account',1,'test',0,'2024-07-11 11:18:17'),
(31,'1','Account Payables',4,'NO','NO','YES','0','0','Debit Balance','Real Account',1,'test',2,'2024-07-11 13:47:14'),
(32,'1','1',0,'NO','NO','NO','0','0','Debit Balance','Real Account',1,'1',2,'2024-07-11 13:47:41'),
(33,'1','Current Assets',0,'NO','YES','NO','0','0','','Real Account',1,'',2,'2024-07-12 00:36:33'),
(34,'2','Non - Current Assets',0,'NO','YES','NO','0','0','Debit Balance','Real Account',1,'',2,'2024-07-12 00:38:58'),
(35,'1','Current Liabilities',0,'NO','YES','NO','0','0','Credit Balance','Real Account',2,'',2,'2024-07-12 00:40:06'),
(36,'2','Non - Liabilities',0,'NO','YES','NO','0','0','Credit Balance','Real Account',2,'',2,'2024-07-12 00:41:42'),
(37,'1','Cash',33,'NO','NO','YES','0','0','Debit Balance','Real Account',0,'',2,'2024-07-12 00:43:02'),
(38,'2','Investments',33,'NO','NO','YES','0','0','Debit Balance','Real Account',0,'',2,'2024-07-12 00:44:08'),
(39,'3','Receivables',33,'NO','NO','YES','0','0','Debit Balance','Real Account',0,'',2,'2024-07-12 00:44:57'),
(40,'1','Current Liabilities',4,'NO','NO','NO','0','0','Debit Balance','Real Account',1,'',2,'2024-07-12 00:59:24'),
(41,'2','Non - Liabilities',4,'NO','NO','NO','0','0','Debit Balance','Real Account',1,'Non - Liabilities',2,'2024-07-12 01:00:25'),
(42,'5','****Prepayments and Deferred Charges',33,'NO','NO','YES','0','0','Debit Balance','Real Account',0,'',2,'2024-07-12 02:39:25'),
(43,'5','****Investment Property',33,'NO','NO','YES','0','0','Debit Balance','Real Account',0,'',2,'2024-07-12 02:40:43'),
(44,'1','Investment Property',34,'NO','NO','YES','0','0','','',0,'',2,'2024-07-12 02:45:12'),
(45,'2','Property, Plant and Equipment',34,'NO','NO','YES','0','0','','Real Account',0,'',2,'2024-07-12 02:46:14'),
(46,'3','****Biological Assets',34,'NO','NO','YES','0','0','Debit Balance','Real Account',0,'',2,'2024-07-12 02:47:13'),
(47,'4','**** Intangible Assets',34,'NO','NO','YES','0','0','Debit Balance','Real Account',0,'',2,'2024-07-12 02:47:50'),
(48,'4','Inventories',33,'NO','NO','YES','0','0','Debit Balance','Real Account',4,'',2,'2024-07-12 02:50:25'),
(49,'1','Current Assets',25,'NO','NO','NO','YES','0','Debit Balance','Real Account',0,'',0,'2024-07-12 04:48:01'),
(50,'1','Cash',49,'NO','NO','YES','NO','0','Debit Balance','Real Account',0,'Cash',2,'2024-07-12 04:48:27'),
(51,'77','test',0,'NO','YES','NO','NO','0','Debit Balance','',0,'11',2,'2024-07-12 05:25:23'),
(52,'777777','777',51,'NO','NO','NO','YES','0','Debit Balance','Real Account',0,'',2,'2024-07-12 05:25:50'),
(53,'77777777777','7777777777',52,'NO','NO','YES','NO','0','','',0,'',2,'2024-07-12 05:26:04'),
(54,'778','778',53,'YES','NO','NO','NO','0','','',0,'787',2,'2024-07-12 05:27:39'),
(55,'112','112',0,'NO','YES','NO','NO','0','Debit Balance','Real Account',0,'222',2,'2024-07-13 02:13:38'),
(56,'2','Non - Current Assets',25,'NO','NO','NO','YES','0','Debit Balance','Real Account',0,'Non - Current Assets',0,'2024-07-13 02:53:46'),
(57,'332','32',25,'NO','NO','NO','YES','0','Debit Balance','Real Account',0,'32',2,'2024-07-13 02:54:52'),
(58,'334','34',25,'NO','NO','NO','YES','0','Debit Balance','Real Account',0,'3',2,'2024-07-13 03:24:14'),
(59,'1','Cash',49,'NO','NO','NO','YES','0','Debit Balance','Real Account',0,'Cash',2,'2024-07-13 10:23:33'),
(60,'1','Cash',49,'NO','NO','NO','YES','0','Debit Balance','Real Account',0,'Cash',2,'2024-07-13 10:24:20'),
(61,'1','Cash',49,'NO','NO','YES','NO','0','Debit Balance','Real Account',0,'Cash',2,'2024-07-13 10:29:02'),
(62,'01','Cash',49,'NO','NO','YES','NO','0','Debit Balance','Real Account',0,'Cash',0,'2024-07-13 10:34:45'),
(63,'02','Investments',49,'NO','NO','YES','NO','0','Debit Balance','Real Account',0,'Investments',0,'2024-07-13 10:35:01'),
(64,'03','Loans and Receivable Accounts',49,'NO','NO','YES','NO','0','Debit Balance','Real Account',0,'Receivables',0,'2024-07-13 10:35:27'),
(65,'04','Inventories',49,'NO','NO','YES','NO','0','Debit Balance','Real Account',0,'Inventories',0,'2024-07-13 10:36:11'),
(66,'099','**PLEASE DELETE Advances',49,'NO','NO','YES','NO','0','Debit Balance','Real Account',0,'Advances',0,'2024-07-13 10:40:35'),
(67,'1','Current Liabilities',4,'NO','NO','NO','YES','0','Debit Balance','Real Account',0,'Current Liabilities',0,'2024-07-13 10:51:21'),
(68,'2','Non - Liabilities',4,'NO','NO','NO','YES','0','Debit Balance','Real Account',0,'Non - Liabilities',0,'2024-07-13 10:51:33'),
(69,'11112','11112',0,'false','YES','NO','NO','NO','Debit Balance','Real Account',0,'11112',2,'2024-07-13 12:11:16'),
(70,'5','hhmmm',0,'false','YES','NO','NO','NO','Debit Balance','Real Account',0,'hhmm',2,'2024-07-13 12:11:57'),
(71,'6','1111',0,'false','YES','NO','NO','NO','Debit Balance','Real Account',0,'gggg',2,'2024-07-13 12:12:13'),
(72,'33','33',25,'false','NO','NO','YES','NO','Debit Balance','Real Account',0,'33',2,'2024-07-13 12:12:51'),
(73,'88','88',49,'false','NO','YES','NO','NO','Debit Balance','Real Account',0,'88',2,'2024-07-13 12:13:21'),
(74,'1','petty cash',62,'false','NO','NO','YES','YES','Debit Balance','Real Account',0,'',2,'2024-07-13 12:23:43'),
(75,'2','revolving fund',62,'false','NO','NO','YES','YES','Debit Balance','Real Account',0,'',2,'2024-07-13 12:24:08'),
(76,'1','pc1',62,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',2,'2024-07-13 12:28:07'),
(77,'2','rf',62,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',2,'2024-07-13 12:28:19'),
(78,'1','sun pc',76,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',2,'2024-07-13 12:39:46'),
(79,'1','PC',62,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'PC',2,'2024-07-14 02:47:08'),
(80,'01','Cash on Hand',62,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-14 03:06:53'),
(81,'02','Cash in Bank - Local Currency',62,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'Cash in Bank - Local Currency',0,'2024-07-14 06:05:06'),
(82,'03','Cash in Bank - Foreign Currency',62,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'Cash in Bank - Foreign Currency',0,'2024-07-16 04:35:19'),
(83,'1','Petty Cash',80,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'Petty Cash',0,'2024-07-16 04:36:31'),
(84,'2','***Revolving Fund',80,'false','NO','NO','NO','YES','Debit Balance','',0,'',2,'2024-07-16 04:43:27'),
(85,'1','Cash in Bank - Local Currency, Current Account',81,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-16 04:48:47'),
(86,'2','Cash in Bank - Local Currency, Savings Account',81,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'Cash in Bank - Local Currency, Savings Account',0,'2024-07-16 04:59:49'),
(87,'1','Cash in Bank - Foreign Currency, Current Account',82,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'Cash in Bank - Foreign Currency, Current Account',0,'2024-07-16 05:00:26'),
(88,'2','Cash in Bank - Foreign Currency, Current Account',82,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'Cash in Bank - Foreign Currency, Current Account',0,'2024-07-16 05:00:54'),
(89,'','',0,'false','YES','NO','NO','NO','','',0,'',2,'2024-07-16 07:42:31'),
(90,'','',0,'false','YES','NO','NO','NO','','',0,'',2,'2024-07-16 07:42:52'),
(91,'','',0,'false','YES','NO','NO','NO','','',0,'',2,'2024-07-16 07:54:02'),
(92,'1','Investments in Time Deposits',63,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-17 04:24:00'),
(93,'1','Office 1',83,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-17 04:32:20'),
(94,'2','Office 2',83,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-17 04:33:26'),
(95,'1','Employee A',93,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-17 04:36:03'),
(96,'2','Employee B',93,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-17 04:37:44'),
(97,'1','Employee A',94,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-17 04:38:45'),
(98,'2','Employee B',94,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-17 04:39:06'),
(99,'1','Metropolitan Bank and Trust Company (Metrobank)',85,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-17 04:40:29'),
(100,'1','Metropolitan Bank and Trust Company (Metrobank) A',99,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-17 04:40:54'),
(101,'2','Metropolitan Bank and Trust Company (Metrobank) B',99,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-17 04:41:20'),
(102,'2','BDO Unibank, Inc.',85,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-17 04:44:00'),
(103,'1','BDO Unibank, Inc. A',102,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-17 04:44:20'),
(104,'2','BDO Unibank, Inc. B',102,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-07-17 04:44:43'),
(105,'111','111',25,'false','NO','NO','YES','NO','','',0,'',2,'2024-07-29 12:06:36'),
(106,'1112','2221',25,'false','NO','NO','YES','NO','','',0,'11',2,'2024-07-29 12:09:01'),
(107,'222','222',16,'false','NO','NO','YES','NO','Debit Balance','Real Account',0,'',2,'2024-07-31 14:47:10'),
(108,'33334','3334',62,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'333',2,'2024-08-04 16:36:01'),
(109,'4443','443',49,'false','NO','YES','NO','NO','Debit Balance','Real Account',0,'444',2,'2024-08-04 16:39:48'),
(110,'3','Office 3',83,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-08-07 11:22:05'),
(111,'04','**PLEASE DELETE Investments in Time Deposits',62,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'',0,'2024-09-05 04:41:08'),
(112,'0999','**PLEASE DELETEOther Receivables',49,'false','NO','YES','NO','NO','','',0,'',0,'2024-09-05 04:49:13'),
(113,'05','Prepayments and Deferred Charges',49,'false','NO','YES','NO','NO','','',0,'',0,'2024-09-05 04:57:13'),
(114,'06','Investment Property',56,'false','NO','YES','NO','NO','','',0,'',0,'2024-09-05 04:58:14'),
(115,'07','Property, Plant and Equipment',56,'false','NO','YES','NO','NO','','',0,'',0,'2024-09-05 05:00:16'),
(116,'099','** PLEASE DELETE Leased Assets',56,'false','NO','YES','NO','NO','','',0,'',0,'2024-09-05 05:01:35'),
(117,'08','Biological Assets',56,'false','NO','YES','NO','NO','','',0,'',0,'2024-09-05 05:02:49'),
(118,'09','Intangible Assets',56,'false','NO','YES','NO','NO','','',0,'',0,'2024-09-05 05:03:02'),
(119,'111','11',80,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'111',2,'2024-09-07 03:57:06'),
(120,'1111','11111',80,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'2222',2,'2024-09-07 04:14:02'),
(121,'111','11',62,'false','NO','NO','NO','YES','Debit Balance','Real Account',0,'12121',2,'2024-09-07 04:33:42'),
(122,'111','111',49,'false','NO','YES','NO','NO','Debit Balance','Real Account',0,'111',2,'2024-09-07 04:40:55'),
(123,'111','111',25,'false','NO','NO','YES','NO','Debit Balance','Real Account',0,'111',2,'2024-09-07 04:43:06');
/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-09-07 16:49:44
