-- MySQL dump 10.13  Distrib 8.0.36, for Win64 (x86_64)
--
-- Host: localhost    Database: complex_sample.gnucash
-- ------------------------------------------------------
-- Server version	8.0.36

/*!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 */;
/*!50503 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 */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `accounts` (
  `guid` varchar(32) NOT NULL,
  `name` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `account_type` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `commodity_guid` varchar(32) DEFAULT NULL,
  `commodity_scu` int NOT NULL,
  `non_std_scu` int NOT NULL,
  `parent_guid` varchar(32) DEFAULT NULL,
  `code` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `description` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `hidden` int DEFAULT NULL,
  `placeholder` int DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!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 ('00622dda21937b29e494179de5013f82','Root Account','ROOT',NULL,0,0,NULL,'','',0,0),('01f6b1417935528fdc97ac2e130a150c','Broker','ASSET','5f586908098232e67edb1371408bfaa8',100,0,'fcd795021c976ba75621ec39e75f6214','','',0,1),('0ccab772d0d16a3e1eaf42cd53f891e5','FOO','TRADING','069410ffec45a41a218bba474093d466',10000,0,'f2b78b76f6093ba04204d972a7ce42d6','','',0,0),('1305127e63737f8c39afb49b5bbeca7a','Opening Balances - EUR','EQUITY','346629655191dcf59a7e2c2a85b70f69',100,0,'8056f425ecdc352cf6039e3a0d0d1e6c','','',0,0),('1c089803052e85f5c6d8e786057dbaee','Foo stock','STOCK','069410ffec45a41a218bba474093d466',10000,0,'01f6b1417935528fdc97ac2e130a150c','','',0,0),('3bc319753945b6dba3e1928abed49e35','Current','ASSET','346629655191dcf59a7e2c2a85b70f69',100,0,'fcd795021c976ba75621ec39e75f6214','','',0,1),('5b5100d58bcc030d2f7828d897fda62e','Fixed','ASSET','346629655191dcf59a7e2c2a85b70f69',100,0,'fcd795021c976ba75621ec39e75f6214','','',0,0),('6bbc8f20544452cac1637fb9a9b851bb','Income','INCOME','346629655191dcf59a7e2c2a85b70f69',100,0,'00622dda21937b29e494179de5013f82','','',0,0),('7894e9c3e955f5eaa9689d16ed775660','EUR5','TRADING','346629655191dcf59a7e2c2a85b70f69',100,0,'e97809296efb670cff4f92138bd69ec8','','',0,0),('8056f425ecdc352cf6039e3a0d0d1e6c','Equity','EQUITY','346629655191dcf59a7e2c2a85b70f69',100,0,'00622dda21937b29e494179de5013f82','','',0,0),('93fc043c3062aaa1297b30e543d2cd0d','Cash','ASSET','346629655191dcf59a7e2c2a85b70f69',100,0,'3bc319753945b6dba3e1928abed49e35','','',0,0),('96ed7a45459fb5fe570e48fcd46f05d0','Liability','LIABILITY','346629655191dcf59a7e2c2a85b70f69',100,0,'00622dda21937b29e494179de5013f82','','',0,0),('a1dd9e8118bff87db289482bceebfea9','Savings','ASSET','346629655191dcf59a7e2c2a85b70f69',100,0,'3bc319753945b6dba3e1928abed49e35','','',0,0),('a3dc764fea53b709af7fcead6470da43','House','ASSET','346629655191dcf59a7e2c2a85b70f69',100,0,'5b5100d58bcc030d2f7828d897fda62e','','',0,0),('adc619f0ac7fa27d5768bfd73ecbc01e','Checking','ASSET','346629655191dcf59a7e2c2a85b70f69',100,0,'3bc319753945b6dba3e1928abed49e35','','',0,0),('af88d386d44b14acf244362b85ccaf4c','Expense','EXPENSE','346629655191dcf59a7e2c2a85b70f69',100,0,'00622dda21937b29e494179de5013f82','','',0,0),('bb43218d7d95b1fe062a731d1aa7e9e2','Mouvements','TRADING','069410ffec45a41a218bba474093d466',10000,0,'00622dda21937b29e494179de5013f82','','',0,1),('e97809296efb670cff4f92138bd69ec8','CURRENCY','TRADING','346629655191dcf59a7e2c2a85b70f69',100,0,'bb43218d7d95b1fe062a731d1aa7e9e2','','',0,1),('f2b78b76f6093ba04204d972a7ce42d6','NASDAQ','TRADING','069410ffec45a41a218bba474093d466',10000,0,'bb43218d7d95b1fe062a731d1aa7e9e2','','',0,1),('f6c0cd00ec04169a44f170181882adab','Template Root','ROOT',NULL,0,0,NULL,'','',0,0),('fcd795021c976ba75621ec39e75f6214','Asset','ASSET','346629655191dcf59a7e2c2a85b70f69',100,0,'00622dda21937b29e494179de5013f82','','',0,1);
/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `billterms`
--

DROP TABLE IF EXISTS `billterms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `billterms` (
  `guid` varchar(32) NOT NULL,
  `name` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `description` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `refcount` int NOT NULL,
  `invisible` int NOT NULL,
  `parent` varchar(32) DEFAULT NULL,
  `type` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `duedays` int DEFAULT NULL,
  `discountdays` int DEFAULT NULL,
  `discount_num` bigint DEFAULT NULL,
  `discount_denom` bigint DEFAULT NULL,
  `cutoff` int DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `billterms`
--

LOCK TABLES `billterms` WRITE;
/*!40000 ALTER TABLE `billterms` DISABLE KEYS */;
/*!40000 ALTER TABLE `billterms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `books`
--

DROP TABLE IF EXISTS `books`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `books` (
  `guid` varchar(32) NOT NULL,
  `root_account_guid` varchar(32) NOT NULL,
  `root_template_guid` varchar(32) NOT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `books`
--

LOCK TABLES `books` WRITE;
/*!40000 ALTER TABLE `books` DISABLE KEYS */;
INSERT INTO `books` VALUES ('7d4ef4044fd30f41d08914a8174c2f5b','00622dda21937b29e494179de5013f82','f6c0cd00ec04169a44f170181882adab');
/*!40000 ALTER TABLE `books` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `budget_amounts`
--

DROP TABLE IF EXISTS `budget_amounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `budget_amounts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `budget_guid` varchar(32) NOT NULL,
  `account_guid` varchar(32) NOT NULL,
  `period_num` int NOT NULL,
  `amount_num` bigint NOT NULL,
  `amount_denom` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `budget_amounts`
--

LOCK TABLES `budget_amounts` WRITE;
/*!40000 ALTER TABLE `budget_amounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `budget_amounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `budgets`
--

DROP TABLE IF EXISTS `budgets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `budgets` (
  `guid` varchar(32) NOT NULL,
  `name` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `description` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `num_periods` int NOT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `budgets`
--

LOCK TABLES `budgets` WRITE;
/*!40000 ALTER TABLE `budgets` DISABLE KEYS */;
/*!40000 ALTER TABLE `budgets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `commodities`
--

DROP TABLE IF EXISTS `commodities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `commodities` (
  `guid` varchar(32) NOT NULL,
  `namespace` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `mnemonic` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `fullname` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `cusip` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `fraction` int NOT NULL,
  `quote_flag` int NOT NULL,
  `quote_source` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `quote_tz` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `commodities`
--

LOCK TABLES `commodities` WRITE;
/*!40000 ALTER TABLE `commodities` DISABLE KEYS */;
INSERT INTO `commodities` VALUES ('069410ffec45a41a218bba474093d466','NASDAQ','FOO','Foo Inc','',10000,0,NULL,''),('1e5d65e2726a5d4595741cb204992991','CURRENCY','USD','US Dollar','840',100,0,'currency',''),('346629655191dcf59a7e2c2a85b70f69','CURRENCY','EUR','Euro','978',100,1,'currency',''),('5f586908098232e67edb1371408bfaa8','CURRENCY','AED','UAE Dirham','784',100,1,'currency',''),('d821d6776fde9f7c2d01b67876406fd3','CURRENCY','ADF','Andorran Franc','950',100,0,'currency','');
/*!40000 ALTER TABLE `commodities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customers`
--

DROP TABLE IF EXISTS `customers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customers` (
  `guid` varchar(32) NOT NULL,
  `name` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `id` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `notes` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `active` int NOT NULL,
  `discount_num` bigint NOT NULL,
  `discount_denom` bigint NOT NULL,
  `credit_num` bigint NOT NULL,
  `credit_denom` bigint NOT NULL,
  `currency` varchar(32) NOT NULL,
  `tax_override` int NOT NULL,
  `addr_name` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_addr1` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_addr2` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_addr3` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_addr4` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_phone` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_fax` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_email` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `shipaddr_name` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `shipaddr_addr1` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `shipaddr_addr2` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `shipaddr_addr3` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `shipaddr_addr4` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `shipaddr_phone` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `shipaddr_fax` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `shipaddr_email` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `terms` varchar(32) DEFAULT NULL,
  `tax_included` int DEFAULT NULL,
  `taxtable` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customers`
--

LOCK TABLES `customers` WRITE;
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employees`
--

DROP TABLE IF EXISTS `employees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employees` (
  `guid` varchar(32) NOT NULL,
  `username` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `id` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `language` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `acl` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `active` int NOT NULL,
  `currency` varchar(32) NOT NULL,
  `ccard_guid` varchar(32) DEFAULT NULL,
  `workday_num` bigint NOT NULL,
  `workday_denom` bigint NOT NULL,
  `rate_num` bigint NOT NULL,
  `rate_denom` bigint NOT NULL,
  `addr_name` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_addr1` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_addr2` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_addr3` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_addr4` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_phone` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_fax` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_email` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employees`
--

LOCK TABLES `employees` WRITE;
/*!40000 ALTER TABLE `employees` DISABLE KEYS */;
/*!40000 ALTER TABLE `employees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `entries`
--

DROP TABLE IF EXISTS `entries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `entries` (
  `guid` varchar(32) NOT NULL,
  `date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `date_entered` datetime DEFAULT '1970-01-01 00:00:00',
  `description` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `action` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `notes` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `quantity_num` bigint DEFAULT NULL,
  `quantity_denom` bigint DEFAULT NULL,
  `i_acct` varchar(32) DEFAULT NULL,
  `i_price_num` bigint DEFAULT NULL,
  `i_price_denom` bigint DEFAULT NULL,
  `i_discount_num` bigint DEFAULT NULL,
  `i_discount_denom` bigint DEFAULT NULL,
  `invoice` varchar(32) DEFAULT NULL,
  `i_disc_type` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `i_disc_how` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `i_taxable` int DEFAULT NULL,
  `i_taxincluded` int DEFAULT NULL,
  `i_taxtable` varchar(32) DEFAULT NULL,
  `b_acct` varchar(32) DEFAULT NULL,
  `b_price_num` bigint DEFAULT NULL,
  `b_price_denom` bigint DEFAULT NULL,
  `bill` varchar(32) DEFAULT NULL,
  `b_taxable` int DEFAULT NULL,
  `b_taxincluded` int DEFAULT NULL,
  `b_taxtable` varchar(32) DEFAULT NULL,
  `b_paytype` int DEFAULT NULL,
  `billable` int DEFAULT NULL,
  `billto_type` int DEFAULT NULL,
  `billto_guid` varchar(32) DEFAULT NULL,
  `order_guid` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `entries`
--

LOCK TABLES `entries` WRITE;
/*!40000 ALTER TABLE `entries` DISABLE KEYS */;
/*!40000 ALTER TABLE `entries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gnclock`
--

DROP TABLE IF EXISTS `gnclock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `gnclock` (
  `Hostname` varchar(255) DEFAULT NULL,
  `PID` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gnclock`
--

LOCK TABLES `gnclock` WRITE;
/*!40000 ALTER TABLE `gnclock` DISABLE KEYS */;
/*!40000 ALTER TABLE `gnclock` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoices`
--

DROP TABLE IF EXISTS `invoices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoices` (
  `guid` varchar(32) NOT NULL,
  `id` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `date_opened` datetime DEFAULT '1970-01-01 00:00:00',
  `date_posted` datetime DEFAULT '1970-01-01 00:00:00',
  `notes` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `active` int NOT NULL,
  `currency` varchar(32) NOT NULL,
  `owner_type` int DEFAULT NULL,
  `owner_guid` varchar(32) DEFAULT NULL,
  `terms` varchar(32) DEFAULT NULL,
  `billing_id` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `post_txn` varchar(32) DEFAULT NULL,
  `post_lot` varchar(32) DEFAULT NULL,
  `post_acc` varchar(32) DEFAULT NULL,
  `billto_type` int DEFAULT NULL,
  `billto_guid` varchar(32) DEFAULT NULL,
  `charge_amt_num` bigint DEFAULT NULL,
  `charge_amt_denom` bigint DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoices`
--

LOCK TABLES `invoices` WRITE;
/*!40000 ALTER TABLE `invoices` DISABLE KEYS */;
/*!40000 ALTER TABLE `invoices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobs` (
  `guid` varchar(32) NOT NULL,
  `id` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `name` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `reference` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `active` int NOT NULL,
  `owner_type` int DEFAULT NULL,
  `owner_guid` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jobs`
--

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lots`
--

DROP TABLE IF EXISTS `lots`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lots` (
  `guid` varchar(32) NOT NULL,
  `account_guid` varchar(32) DEFAULT NULL,
  `is_closed` int NOT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lots`
--

LOCK TABLES `lots` WRITE;
/*!40000 ALTER TABLE `lots` DISABLE KEYS */;
/*!40000 ALTER TABLE `lots` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `orders` (
  `guid` varchar(32) NOT NULL,
  `id` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `notes` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `reference` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `active` int NOT NULL,
  `date_opened` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `date_closed` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `owner_type` int NOT NULL,
  `owner_guid` varchar(32) NOT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders`
--

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `prices`
--

DROP TABLE IF EXISTS `prices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prices` (
  `guid` varchar(32) NOT NULL,
  `commodity_guid` varchar(32) NOT NULL,
  `currency_guid` varchar(32) NOT NULL,
  `date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `source` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `type` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `value_num` bigint NOT NULL,
  `value_denom` bigint NOT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `prices`
--

LOCK TABLES `prices` WRITE;
/*!40000 ALTER TABLE `prices` DISABLE KEYS */;
INSERT INTO `prices` VALUES ('0d6684f44fb018e882de76094ed9c433','d821d6776fde9f7c2d01b67876406fd3','5f586908098232e67edb1371408bfaa8','2018-02-20 23:00:00','user:price-editor','unknown',3,2),('715ad31cb272437fc883d658f732a8eb','1e5d65e2726a5d4595741cb204992991','346629655191dcf59a7e2c2a85b70f69','2018-02-20 23:00:00','user:price-editor','unknown',7,5),('831ce95a146243a0b66895151538990a','5f586908098232e67edb1371408bfaa8','346629655191dcf59a7e2c2a85b70f69','2017-05-08 16:00:00','user:price-editor','last',1,2),('86a98448a82e9012cad82ac677eb86df','069410ffec45a41a218bba474093d466','5f586908098232e67edb1371408bfaa8','2018-02-20 23:00:00','user:price-editor','unknown',9,10),('c266e6ce9bdf8832bf88360df524669e','346629655191dcf59a7e2c2a85b70f69','5f586908098232e67edb1371408bfaa8','2018-02-20 23:00:00','user:price-editor','unknown',10,9);
/*!40000 ALTER TABLE `prices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recurrences`
--

DROP TABLE IF EXISTS `recurrences`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `recurrences` (
  `id` int NOT NULL AUTO_INCREMENT,
  `obj_guid` varchar(32) NOT NULL,
  `recurrence_mult` int NOT NULL,
  `recurrence_period_type` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `recurrence_period_start` date NOT NULL,
  `recurrence_weekend_adjust` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recurrences`
--

LOCK TABLES `recurrences` WRITE;
/*!40000 ALTER TABLE `recurrences` DISABLE KEYS */;
/*!40000 ALTER TABLE `recurrences` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `schedxactions`
--

DROP TABLE IF EXISTS `schedxactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `schedxactions` (
  `guid` varchar(32) NOT NULL,
  `name` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `enabled` int NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `last_occur` date DEFAULT NULL,
  `num_occur` int NOT NULL,
  `rem_occur` int NOT NULL,
  `auto_create` int NOT NULL,
  `auto_notify` int NOT NULL,
  `adv_creation` int NOT NULL,
  `adv_notify` int NOT NULL,
  `instance_count` int NOT NULL,
  `template_act_guid` varchar(32) NOT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `schedxactions`
--

LOCK TABLES `schedxactions` WRITE;
/*!40000 ALTER TABLE `schedxactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `schedxactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `slots`
--

DROP TABLE IF EXISTS `slots`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `slots` (
  `id` int NOT NULL AUTO_INCREMENT,
  `obj_guid` varchar(32) NOT NULL,
  `name` varchar(4096) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `slot_type` int NOT NULL,
  `int64_val` bigint DEFAULT NULL,
  `string_val` varchar(4096) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `double_val` double DEFAULT NULL,
  `timespec_val` datetime DEFAULT '1970-01-01 00:00:00',
  `guid_val` varchar(32) DEFAULT NULL,
  `numeric_val_num` bigint DEFAULT NULL,
  `numeric_val_denom` bigint DEFAULT NULL,
  `gdate_val` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `slots_guid_index` (`obj_guid`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `slots`
--

LOCK TABLES `slots` WRITE;
/*!40000 ALTER TABLE `slots` DISABLE KEYS */;
INSERT INTO `slots` VALUES (1,'7d4ef4044fd30f41d08914a8174c2f5b','features',9,0,NULL,NULL,'1970-01-01 00:00:00','28428f5b949346a4ac2e6f27fe5c4990',0,1,NULL),(2,'28428f5b949346a4ac2e6f27fe5c4990','features/ISO-8601 formatted date strings in SQLite3 databases.',4,0,'Use ISO formatted date-time strings in SQLite3 databases (requires at least GnuCash 2.6.20)',NULL,'1970-01-01 00:00:00',NULL,0,1,NULL),(3,'7d4ef4044fd30f41d08914a8174c2f5b','options',9,0,NULL,NULL,'1970-01-01 00:00:00','349a6c8eaede44f184006a7582dac8a7',0,1,NULL),(4,'349a6c8eaede44f184006a7582dac8a7','options/Accounts',9,0,NULL,NULL,'1970-01-01 00:00:00','6ba23dcc11574117b50eea3336cb3387',0,1,NULL),(5,'6ba23dcc11574117b50eea3336cb3387','options/Accounts/Use Trading Accounts',4,0,'t',NULL,'1970-01-01 00:00:00',NULL,0,1,NULL),(6,'349a6c8eaede44f184006a7582dac8a7','options/Budgeting',9,0,NULL,NULL,'1970-01-01 00:00:00','99fd48ba1ba547138b0ee7c20a356a77',0,1,NULL),(7,'7d4ef4044fd30f41d08914a8174c2f5b','remove-color-not-set-slots',4,0,'true',NULL,'1970-01-01 00:00:00',NULL,0,1,NULL),(8,'fcd795021c976ba75621ec39e75f6214','placeholder',4,0,'true',NULL,'1970-01-01 00:00:00',NULL,0,1,NULL),(9,'3bc319753945b6dba3e1928abed49e35','placeholder',4,0,'true',NULL,'1970-01-01 00:00:00',NULL,0,1,NULL),(10,'01f6b1417935528fdc97ac2e130a150c','placeholder',4,0,'true',NULL,'1970-01-01 00:00:00',NULL,0,1,NULL),(11,'bb43218d7d95b1fe062a731d1aa7e9e2','placeholder',4,0,'true',NULL,'1970-01-01 00:00:00',NULL,0,1,NULL),(12,'f2b78b76f6093ba04204d972a7ce42d6','placeholder',4,0,'true',NULL,'1970-01-01 00:00:00',NULL,0,1,NULL),(13,'e97809296efb670cff4f92138bd69ec8','placeholder',4,0,'true',NULL,'1970-01-01 00:00:00',NULL,0,1,NULL),(14,'0fac88d8412f46d5e16beb87aee0fd22','date-posted',10,0,NULL,NULL,'1970-01-01 00:00:00',NULL,0,1,'2018-02-20');
/*!40000 ALTER TABLE `slots` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `splits`
--

DROP TABLE IF EXISTS `splits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `splits` (
  `guid` varchar(32) NOT NULL,
  `tx_guid` varchar(32) NOT NULL,
  `account_guid` varchar(32) NOT NULL,
  `memo` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `action` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `reconcile_state` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `reconcile_date` datetime DEFAULT '1970-01-01 00:00:00',
  `value_num` bigint NOT NULL,
  `value_denom` bigint NOT NULL,
  `quantity_num` bigint NOT NULL,
  `quantity_denom` bigint NOT NULL,
  `lot_guid` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`guid`),
  KEY `splits_tx_guid_index` (`tx_guid`),
  KEY `splits_account_guid_index` (`account_guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `splits`
--

LOCK TABLES `splits` WRITE;
/*!40000 ALTER TABLE `splits` DISABLE KEYS */;
INSERT INTO `splits` VALUES ('1e612f650eb598d9e803902b6aca73e3','6c8876003c4a6026e38e3afb67d6f2b1','6bbc8f20544452cac1637fb9a9b851bb','','','n','1970-01-01 00:00:00',-15000,100,-15000,100,NULL),('3142f6ebed4469f9a692dfa69a0080f5','325537f4f0fadfd9ffb6aad3cd18e360','af88d386d44b14acf244362b85ccaf4c','interest','','n','1970-01-01 00:00:00',3000,100,3000,100,NULL),('3a53ab1f73cb74d9882dd14b7d6a4a78','5be11c009a88b4198aa65ee878ddf99d','96ed7a45459fb5fe570e48fcd46f05d0','','','n','1970-01-01 00:00:00',-100000,100,-100000,100,NULL),('42336a5732d54b22fa080be3b50ff5b7','0fac88d8412f46d5e16beb87aee0fd22','93fc043c3062aaa1297b30e543d2cd0d','','','n','1970-01-01 00:00:00',10000,100,10000,100,NULL),('47c7fdca3bc04d6ad734eefc2794ddfe','325537f4f0fadfd9ffb6aad3cd18e360','adc619f0ac7fa27d5768bfd73ecbc01e','monthly payment','','n','1970-01-01 00:00:00',-13000,100,-13000,100,NULL),('486341b68457b037ecd75dcdcbf64bc5','0fac88d8412f46d5e16beb87aee0fd22','adc619f0ac7fa27d5768bfd73ecbc01e','','','n','1970-01-01 00:00:00',-10000,100,-10000,100,NULL),('4f78ef3650c38115abf60365f9484b45','7b3a2df3645b3e490121814c8ad7146d','a1dd9e8118bff87db289482bceebfea9','','','n','1970-01-01 00:00:00',250000,100,250000,100,NULL),('6ca852f33ee5415d22dfc132f5c5ec09','325537f4f0fadfd9ffb6aad3cd18e360','96ed7a45459fb5fe570e48fcd46f05d0','capital','','n','1970-01-01 00:00:00',10000,100,10000,100,NULL),('714c69b235d450f11e4add7077b4cde7','5be11c009a88b4198aa65ee878ddf99d','adc619f0ac7fa27d5768bfd73ecbc01e','','','n','1970-01-01 00:00:00',100000,100,100000,100,NULL),('76cd1180d563db608495c710d2774c9a','59d9b60221a4615e74f8e489dceff58b','a3dc764fea53b709af7fcead6470da43','','','n','1970-01-01 00:00:00',2000000,100,2000000,100,NULL),('85d451d09db85fb97cea6fe2e876d566','a5924cd14525c307cc5862c97361b031','0ccab772d0d16a3e1eaf42cd53f891e5','','','n','1970-01-01 00:00:00',-120000,100,-1300000,10000,NULL),('afcba9bb98422e5ca64931a5efd86025','7b3a2df3645b3e490121814c8ad7146d','1305127e63737f8c39afb49b5bbeca7a','','','n','1970-01-01 00:00:00',-250000,100,-250000,100,NULL),('b3c4df045f2a19332e143cd83a7e013f','2d249b7d3fc8efe17865873b97748f50','a1dd9e8118bff87db289482bceebfea9','','','n','1970-01-01 00:00:00',250000,100,250000,100,NULL),('b8387081c3d60310465a5d316fb6745a','6294086c678a584e7ce184b523699f6c','af88d386d44b14acf244362b85ccaf4c','','','n','1970-01-01 00:00:00',20000,100,20000,100,NULL),('bae8bc3a2b29812691016e61c425fda5','e774d4b1fbd3c8c853b2c45a1d74f5f9','a1dd9e8118bff87db289482bceebfea9','','','n','1970-01-01 00:00:00',-25000,100,-25000,100,NULL),('c8eb859a307babbb2fdf66871cf4c0a8','59d9b60221a4615e74f8e489dceff58b','96ed7a45459fb5fe570e48fcd46f05d0','','','n','1970-01-01 00:00:00',-2000000,100,-2000000,100,NULL),('d240433d6812fc634c21200fb559d07f','2d249b7d3fc8efe17865873b97748f50','1305127e63737f8c39afb49b5bbeca7a','','','n','1970-01-01 00:00:00',-250000,100,-250000,100,NULL),('d96c36fed7324332bfeff80e52cd9892','6294086c678a584e7ce184b523699f6c','adc619f0ac7fa27d5768bfd73ecbc01e','','','n','1970-01-01 00:00:00',-20000,100,-20000,100,NULL),('de832fe97e37811a7fff7e28b3a43425','6c8876003c4a6026e38e3afb67d6f2b1','93fc043c3062aaa1297b30e543d2cd0d','','','n','1970-01-01 00:00:00',15000,100,15000,100,NULL),('e055799a549308621a16c715c870e29a','a5924cd14525c307cc5862c97361b031','7894e9c3e955f5eaa9689d16ed775660','','','n','1970-01-01 00:00:00',120000,100,120000,100,NULL),('e07539176a70222b16369bd246b174b9','a5924cd14525c307cc5862c97361b031','1c089803052e85f5c6d8e786057dbaee','','','n','1970-01-01 00:00:00',120000,100,1300000,10000,NULL),('ea72c01205e1f619aa278930648b060e','e774d4b1fbd3c8c853b2c45a1d74f5f9','adc619f0ac7fa27d5768bfd73ecbc01e','','','n','1970-01-01 00:00:00',25000,100,25000,100,NULL),('eb832677cb2a013fcc4140316ccb3323','a5b50b770ee5e01361c49300aedb5e0f','af88d386d44b14acf244362b85ccaf4c','','','n','1970-01-01 00:00:00',3000,100,3000,100,NULL),('f32095185808aff854fc020ee2eedb5d','a5b50b770ee5e01361c49300aedb5e0f','93fc043c3062aaa1297b30e543d2cd0d','','','n','1970-01-01 00:00:00',-3000,100,-3000,100,NULL),('f5f1b767b38439eff788bed8fca8d1c2','a5924cd14525c307cc5862c97361b031','a1dd9e8118bff87db289482bceebfea9','','','n','1970-01-01 00:00:00',-120000,100,-120000,100,NULL);
/*!40000 ALTER TABLE `splits` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `taxtable_entries`
--

DROP TABLE IF EXISTS `taxtable_entries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `taxtable_entries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `taxtable` varchar(32) NOT NULL,
  `account` varchar(32) NOT NULL,
  `amount_num` bigint NOT NULL,
  `amount_denom` bigint NOT NULL,
  `type` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `taxtable_entries`
--

LOCK TABLES `taxtable_entries` WRITE;
/*!40000 ALTER TABLE `taxtable_entries` DISABLE KEYS */;
/*!40000 ALTER TABLE `taxtable_entries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `taxtables`
--

DROP TABLE IF EXISTS `taxtables`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `taxtables` (
  `guid` varchar(32) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `refcount` bigint NOT NULL,
  `invisible` int NOT NULL,
  `parent` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `taxtables`
--

LOCK TABLES `taxtables` WRITE;
/*!40000 ALTER TABLE `taxtables` DISABLE KEYS */;
/*!40000 ALTER TABLE `taxtables` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transactions`
--

DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `transactions` (
  `guid` varchar(32) NOT NULL,
  `currency_guid` varchar(32) NOT NULL,
  `num` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `post_date` datetime DEFAULT '1970-01-01 00:00:00',
  `enter_date` datetime DEFAULT '1970-01-01 00:00:00',
  `description` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`guid`),
  KEY `tx_post_date_index` (`post_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transactions`
--

LOCK TABLES `transactions` WRITE;
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
INSERT INTO `transactions` VALUES ('0fac88d8412f46d5e16beb87aee0fd22','346629655191dcf59a7e2c2a85b70f69','','2018-02-20 10:59:00','2018-02-20 21:12:49','Transfer current'),('2d249b7d3fc8efe17865873b97748f50','346629655191dcf59a7e2c2a85b70f69','','2018-02-21 10:59:00','2018-02-21 07:25:53','Opening Balance'),('325537f4f0fadfd9ffb6aad3cd18e360','346629655191dcf59a7e2c2a85b70f69','','2014-12-24 10:59:00','2014-12-25 10:11:26','loan payment'),('59d9b60221a4615e74f8e489dceff58b','346629655191dcf59a7e2c2a85b70f69','','2018-02-20 10:59:00','2018-02-20 21:14:36','house load'),('5be11c009a88b4198aa65ee878ddf99d','346629655191dcf59a7e2c2a85b70f69','','2014-12-24 10:59:00','2014-12-25 10:07:30','initial load'),('6294086c678a584e7ce184b523699f6c','346629655191dcf59a7e2c2a85b70f69','','2014-12-24 10:59:00','2014-12-25 10:08:08','expense 1'),('6c8876003c4a6026e38e3afb67d6f2b1','346629655191dcf59a7e2c2a85b70f69','','2014-12-24 10:59:00','2014-12-25 10:08:15','income 1'),('7b3a2df3645b3e490121814c8ad7146d','346629655191dcf59a7e2c2a85b70f69','','2018-02-20 10:59:00','2018-02-20 21:13:50','Opening Balance'),('a5924cd14525c307cc5862c97361b031','346629655191dcf59a7e2c2a85b70f69','','2018-02-21 10:59:00','2018-02-21 06:58:44','buy foo'),('a5b50b770ee5e01361c49300aedb5e0f','346629655191dcf59a7e2c2a85b70f69','','2018-02-20 10:59:00','2018-02-20 21:13:01','Purchase'),('e774d4b1fbd3c8c853b2c45a1d74f5f9','346629655191dcf59a7e2c2a85b70f69','','2018-02-20 10:59:00','2018-02-20 21:13:30','transfer intra');
/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendors`
--

DROP TABLE IF EXISTS `vendors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `vendors` (
  `guid` varchar(32) NOT NULL,
  `name` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `id` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `notes` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `currency` varchar(32) NOT NULL,
  `active` int NOT NULL,
  `tax_override` int NOT NULL,
  `addr_name` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_addr1` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_addr2` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_addr3` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_addr4` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_phone` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_fax` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `addr_email` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `terms` varchar(32) DEFAULT NULL,
  `tax_inc` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `tax_table` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendors`
--

LOCK TABLES `vendors` WRITE;
/*!40000 ALTER TABLE `vendors` DISABLE KEYS */;
/*!40000 ALTER TABLE `vendors` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `versions`
--

DROP TABLE IF EXISTS `versions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `versions` (
  `table_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `table_version` int NOT NULL,
  PRIMARY KEY (`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `versions`
--

LOCK TABLES `versions` WRITE;
/*!40000 ALTER TABLE `versions` DISABLE KEYS */;
INSERT INTO `versions` VALUES ('accounts',1),('billterms',2),('books',1),('budgets',1),('budget_amounts',1),('commodities',1),('customers',2),('employees',2),('entries',4),('Gnucash',3000011),('Gnucash-Resave',19920),('invoices',4),('jobs',1),('lots',2),('orders',1),('prices',3),('recurrences',2),('schedxactions',1),('slots',4),('splits',5),('taxtables',2),('taxtable_entries',3),('transactions',4),('vendors',1);
/*!40000 ALTER TABLE `versions` 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-04-13 15:29:39
