GnuCash 2.6.3 does not automatically create root account?

nvsoar nvsoar at charter.net
Sun Sep 21 23:22:22 EDT 2014


On 9/21/2014 5:11 PM, John Ralls wrote:
> On Sep 19, 2014, at 10:20 PM, nvsoar <nvsoar at charter.net> wrote:
>
>> Subject: 	Re: GnuCash 2.6.3 does not automatically create root account?
>> Date: 	Fri, 19 Sep 2014 23:19:51 -0500
>> From: 	James Nylen <jnylen+gnucash at gmail.com>
>> To: 	John Ralls <jralls at ceridwen.us>
>> CC: 	gnucash mailinglist <gnucash-user at gnucash.org>
>>
>>
>>
>> It loads just fine for me.  Here's the mysqldump of the database that
>> gnucash created:  nylen.tv/gnucash-data-dump-test.sql
>>
>> snip
>>
>> Hmmmm.  Here is a portion of the text of gnucash-data-dump-test.sql
>> --------------------------------
>> -- Table structure for table `books`--
>>
>> DROP TABLE IF EXISTS `books`;
>> /*!40101 SET @saved_cs_client     = @@character_set_client */;
>> /*!40101 SET character_set_client = utf8 */;
>> 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=latin1;
>> /*!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 ('703c87732c3c538838f984900f8f3988','a3d7e8115b4631931e93047ca9dfba13','5c93a9097531379152ba005f0cb9fea7');
>> /*!40000 ALTER TABLE `books` ENABLE KEYS */;
>> UNLOCK TABLES;
>> ———————————————————
> So everything’s there except the ROOT tables. Interesting.
>
> How exactly did you create the DB? What accounts did you select in the new file assistant?
>
> Regards,
> John Ralls
For info - the entire gnucash-data-dump-test.sql is attached as a text 
file.  Opens with good formatting in notepad++ using windows; haven't 
tested the gedit format for this file.
nvsoar
-------------- next part --------------
-- MySQL dump 10.13  Distrib 5.5.33, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: test_gnucash
-- ------------------------------------------------------
-- Server version	5.5.33-1

/*!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 utf8 */;
/*!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 */;

--
-- Current Database: `test_gnucash`
--

/*!40000 DROP DATABASE IF EXISTS `test_gnucash`*/;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test_gnucash` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `test_gnucash`;

--
-- 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` (
  `guid` varchar(32) NOT NULL,
  `name` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `account_type` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `commodity_guid` varchar(32) DEFAULT NULL,
  `commodity_scu` int(11) NOT NULL,
  `non_std_scu` int(11) NOT NULL,
  `parent_guid` varchar(32) DEFAULT NULL,
  `code` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `description` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `hidden` int(11) DEFAULT NULL,
  `placeholder` int(11) DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 ('023839ed04bdc40bf72e016e4032a15e','Regions','BANK','312777654fe2c543a7c41f30f3d38fff',100,0,'39bb1f06cc60b5a590a6bbade305b949','','',0,1);
INSERT INTO `accounts` VALUES ('17d1788f3088e0290503bee69dd842c1','Non-Cash','EXPENSE','312777654fe2c543a7c41f30f3d38fff',100,0,'9171e5a9a83f119c37ea4acccd9f375e','','Non-Cash Expenses',0,1);
INSERT INTO `accounts` VALUES ('1a6f6b91fb7ea4b856ac9d4cfec6a6c6','Income','INCOME','312777654fe2c543a7c41f30f3d38fff',100,0,'a3d7e8115b4631931e93047ca9dfba13','','',0,1);
INSERT INTO `accounts` VALUES ('22d76fff868a8e81d87812b04f87c8c8','Membership Dues','INCOME','312777654fe2c543a7c41f30f3d38fff',100,0,'1a6f6b91fb7ea4b856ac9d4cfec6a6c6','','',0,0);
INSERT INTO `accounts` VALUES ('3922d5de7121e710feb73912a6803ecc','Checking','BANK','312777654fe2c543a7c41f30f3d38fff',100,0,'023839ed04bdc40bf72e016e4032a15e','','Regions Checking',0,0);
INSERT INTO `accounts` VALUES ('39bb1f06cc60b5a590a6bbade305b949','Current Assets','BANK','312777654fe2c543a7c41f30f3d38fff',100,0,'7bf42b00438c997029a048328e084708','','',0,1);
INSERT INTO `accounts` VALUES ('3b9b4a6797bad63baecd41f8e872312d','Gift in Kind','INCOME','312777654fe2c543a7c41f30f3d38fff',100,0,'1a6f6b91fb7ea4b856ac9d4cfec6a6c6','','',0,0);
INSERT INTO `accounts` VALUES ('4058ccfd69a535f3e194ea40a91120ea','PayPal','BANK','312777654fe2c543a7c41f30f3d38fff',100,0,'39bb1f06cc60b5a590a6bbade305b949','','',0,0);
INSERT INTO `accounts` VALUES ('46a821c1c5a8e0b6dfeb8239f1f9ddb6','Direct Fees','EXPENSE','312777654fe2c543a7c41f30f3d38fff',100,0,'e2784082d3c074dd42c73968b5b582ef','','',0,0);
INSERT INTO `accounts` VALUES ('5ae9d4744bdde490f7bba4be66162fdf','Imbalance-USD','BANK','312777654fe2c543a7c41f30f3d38fff',100,0,'a3d7e8115b4631931e93047ca9dfba13','','',0,0);
INSERT INTO `accounts` VALUES ('6292f601711c1f9cf8a8d3460ef1ed56','Contract Labor','EXPENSE','312777654fe2c543a7c41f30f3d38fff',100,0,'9171e5a9a83f119c37ea4acccd9f375e','','',0,0);
INSERT INTO `accounts` VALUES ('63f32b117e700e12cdb26a1f22a98d4f','Equity','EQUITY','312777654fe2c543a7c41f30f3d38fff',100,0,'a3d7e8115b4631931e93047ca9dfba13','','',0,1);
INSERT INTO `accounts` VALUES ('6f2f5beae0f0f02811ad3bd4745e54d4','Donated','EXPENSE','312777654fe2c543a7c41f30f3d38fff',100,0,'6292f601711c1f9cf8a8d3460ef1ed56','','',0,0);
INSERT INTO `accounts` VALUES ('7bf42b00438c997029a048328e084708','Assets','BANK','312777654fe2c543a7c41f30f3d38fff',100,0,'a3d7e8115b4631931e93047ca9dfba13','','',0,1);
INSERT INTO `accounts` VALUES ('883e8eb608c9fa496474f60f6a8db742','Opening Balances','EQUITY','312777654fe2c543a7c41f30f3d38fff',100,0,'63f32b117e700e12cdb26a1f22a98d4f','','',0,0);
INSERT INTO `accounts` VALUES ('9171e5a9a83f119c37ea4acccd9f375e','Expenses','EXPENSE','312777654fe2c543a7c41f30f3d38fff',100,0,'a3d7e8115b4631931e93047ca9dfba13','','',0,0);
INSERT INTO `accounts` VALUES ('c4651d7a4bfc451d02c3140b40f6551b','Classes','INCOME','312777654fe2c543a7c41f30f3d38fff',100,0,'1a6f6b91fb7ea4b856ac9d4cfec6a6c6','','',0,0);
INSERT INTO `accounts` VALUES ('e05687471bd4e8f541a389d6c343b4ac','Cash Donations','INCOME','312777654fe2c543a7c41f30f3d38fff',100,0,'1a6f6b91fb7ea4b856ac9d4cfec6a6c6','','',0,0);
INSERT INTO `accounts` VALUES ('e2784082d3c074dd42c73968b5b582ef','Fundraising','EXPENSE','312777654fe2c543a7c41f30f3d38fff',100,0,'9171e5a9a83f119c37ea4acccd9f375e','','',0,0);
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `billterms` (
  `guid` varchar(32) NOT NULL,
  `name` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `description` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `refcount` int(11) NOT NULL,
  `invisible` int(11) NOT NULL,
  `parent` varchar(32) DEFAULT NULL,
  `type` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `duedays` int(11) DEFAULT NULL,
  `discountdays` int(11) DEFAULT NULL,
  `discount_num` bigint(20) DEFAULT NULL,
  `discount_denom` bigint(20) DEFAULT NULL,
  `cutoff` int(11) DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
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=latin1;
/*!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 ('703c87732c3c538838f984900f8f3988','a3d7e8115b4631931e93047ca9dfba13','5c93a9097531379152ba005f0cb9fea7');
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `budget_amounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `budget_guid` varchar(32) NOT NULL,
  `account_guid` varchar(32) NOT NULL,
  `period_num` int(11) NOT NULL,
  `amount_num` bigint(20) NOT NULL,
  `amount_denom` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `budgets` (
  `guid` varchar(32) NOT NULL,
  `name` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `description` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `num_periods` int(11) NOT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `commodities` (
  `guid` varchar(32) NOT NULL,
  `namespace` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `mnemonic` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `fullname` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `cusip` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `fraction` int(11) NOT NULL,
  `quote_flag` int(11) NOT NULL,
  `quote_source` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `quote_tz` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 ('312777654fe2c543a7c41f30f3d38fff','CURRENCY','USD','US Dollar','840',100,1,'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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customers` (
  `guid` varchar(32) NOT NULL,
  `name` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `id` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `notes` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `active` int(11) NOT NULL,
  `discount_num` bigint(20) NOT NULL,
  `discount_denom` bigint(20) NOT NULL,
  `credit_num` bigint(20) NOT NULL,
  `credit_denom` bigint(20) NOT NULL,
  `currency` varchar(32) NOT NULL,
  `tax_override` int(11) NOT NULL,
  `addr_name` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_addr1` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_addr2` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_addr3` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_addr4` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_phone` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `addr_fax` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `addr_email` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `shipaddr_name` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `shipaddr_addr1` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `shipaddr_addr2` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `shipaddr_addr3` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `shipaddr_addr4` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `shipaddr_phone` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `shipaddr_fax` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `shipaddr_email` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `terms` varchar(32) DEFAULT NULL,
  `tax_included` int(11) DEFAULT NULL,
  `taxtable` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employees` (
  `guid` varchar(32) NOT NULL,
  `username` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `id` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `language` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `acl` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `active` int(11) NOT NULL,
  `currency` varchar(32) NOT NULL,
  `ccard_guid` varchar(32) DEFAULT NULL,
  `workday_num` bigint(20) NOT NULL,
  `workday_denom` bigint(20) NOT NULL,
  `rate_num` bigint(20) NOT NULL,
  `rate_denom` bigint(20) NOT NULL,
  `addr_name` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_addr1` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_addr2` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_addr3` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_addr4` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_phone` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `addr_fax` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `addr_email` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entries` (
  `guid` varchar(32) NOT NULL,
  `date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_entered` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `description` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `action` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `notes` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `quantity_num` bigint(20) DEFAULT NULL,
  `quantity_denom` bigint(20) DEFAULT NULL,
  `i_acct` varchar(32) DEFAULT NULL,
  `i_price_num` bigint(20) DEFAULT NULL,
  `i_price_denom` bigint(20) DEFAULT NULL,
  `i_discount_num` bigint(20) DEFAULT NULL,
  `i_discount_denom` bigint(20) DEFAULT NULL,
  `invoice` varchar(32) DEFAULT NULL,
  `i_disc_type` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `i_disc_how` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `i_taxable` int(11) DEFAULT NULL,
  `i_taxincluded` int(11) DEFAULT NULL,
  `i_taxtable` varchar(32) DEFAULT NULL,
  `b_acct` varchar(32) DEFAULT NULL,
  `b_price_num` bigint(20) DEFAULT NULL,
  `b_price_denom` bigint(20) DEFAULT NULL,
  `bill` varchar(32) DEFAULT NULL,
  `b_taxable` int(11) DEFAULT NULL,
  `b_taxincluded` int(11) DEFAULT NULL,
  `b_taxtable` varchar(32) DEFAULT NULL,
  `b_paytype` int(11) DEFAULT NULL,
  `billable` int(11) DEFAULT NULL,
  `billto_type` int(11) DEFAULT NULL,
  `billto_guid` varchar(32) DEFAULT NULL,
  `order_guid` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gnclock` (
  `Hostname` varchar(255) DEFAULT NULL,
  `PID` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoices` (
  `guid` varchar(32) NOT NULL,
  `id` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `date_opened` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `date_posted` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `notes` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `active` int(11) NOT NULL,
  `currency` varchar(32) NOT NULL,
  `owner_type` int(11) DEFAULT NULL,
  `owner_guid` varchar(32) DEFAULT NULL,
  `terms` varchar(32) DEFAULT NULL,
  `billing_id` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `post_txn` varchar(32) DEFAULT NULL,
  `post_lot` varchar(32) DEFAULT NULL,
  `post_acc` varchar(32) DEFAULT NULL,
  `billto_type` int(11) DEFAULT NULL,
  `billto_guid` varchar(32) DEFAULT NULL,
  `charge_amt_num` bigint(20) DEFAULT NULL,
  `charge_amt_denom` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jobs` (
  `guid` varchar(32) NOT NULL,
  `id` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `name` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `reference` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `active` int(11) NOT NULL,
  `owner_type` int(11) DEFAULT NULL,
  `owner_guid` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lots` (
  `guid` varchar(32) NOT NULL,
  `account_guid` varchar(32) DEFAULT NULL,
  `is_closed` int(11) NOT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
  `guid` varchar(32) NOT NULL,
  `id` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `notes` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `reference` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `active` int(11) NOT NULL,
  `date_opened` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_closed` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `owner_type` int(11) NOT NULL,
  `owner_guid` varchar(32) NOT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `prices` (
  `guid` varchar(32) NOT NULL,
  `commodity_guid` varchar(32) NOT NULL,
  `currency_guid` varchar(32) NOT NULL,
  `date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `source` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `type` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `value_num` bigint(20) NOT NULL,
  `value_denom` bigint(20) NOT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `prices` WRITE;
/*!40000 ALTER TABLE `prices` DISABLE KEYS */;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recurrences` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `obj_guid` varchar(32) NOT NULL,
  `recurrence_mult` int(11) NOT NULL,
  `recurrence_period_type` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `recurrence_period_start` date NOT NULL,
  `recurrence_weekend_adjust` varchar(2048) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `schedxactions` (
  `guid` varchar(32) NOT NULL,
  `name` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `enabled` int(11) NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `last_occur` date DEFAULT NULL,
  `num_occur` int(11) NOT NULL,
  `rem_occur` int(11) NOT NULL,
  `auto_create` int(11) NOT NULL,
  `auto_notify` int(11) NOT NULL,
  `adv_creation` int(11) NOT NULL,
  `adv_notify` int(11) NOT NULL,
  `instance_count` int(11) NOT NULL,
  `template_act_guid` varchar(32) NOT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `slots` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `obj_guid` varchar(32) NOT NULL,
  `name` varchar(4096) CHARACTER SET utf8 NOT NULL,
  `slot_type` int(11) NOT NULL,
  `int64_val` bigint(20) DEFAULT NULL,
  `string_val` varchar(4096) CHARACTER SET utf8 DEFAULT NULL,
  `double_val` double DEFAULT NULL,
  `timespec_val` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `guid_val` varchar(32) DEFAULT NULL,
  `numeric_val_num` bigint(20) DEFAULT NULL,
  `numeric_val_denom` bigint(20) DEFAULT NULL,
  `gdate_val` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `slots_guid_index` (`obj_guid`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;
/*!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 (5,'4058ccfd69a535f3e194ea40a91120ea','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (8,'5b0da9bc167f157ded4fa0511c6c3ad4','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-09-18');
INSERT INTO `slots` VALUES (9,'3922d5de7121e710feb73912a6803ecc','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (10,'7bf42b00438c997029a048328e084708','placeholder',4,0,'true',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (11,'7bf42b00438c997029a048328e084708','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (12,'39bb1f06cc60b5a590a6bbade305b949','placeholder',4,0,'true',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (13,'39bb1f06cc60b5a590a6bbade305b949','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (14,'023839ed04bdc40bf72e016e4032a15e','placeholder',4,0,'true',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (15,'023839ed04bdc40bf72e016e4032a15e','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (18,'883e8eb608c9fa496474f60f6a8db742','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (19,'63f32b117e700e12cdb26a1f22a98d4f','placeholder',4,0,'true',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (20,'63f32b117e700e12cdb26a1f22a98d4f','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (21,'efb6159a242a43d1425351cfac675365','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-09-12');
INSERT INTO `slots` VALUES (22,'cf66bc6e3d4d5305d3f96a66d264d3a6','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-09-10');
INSERT INTO `slots` VALUES (23,'90d7dca3c21c041080c008ffd109820f','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-09-10');
INSERT INTO `slots` VALUES (24,'3dc3bae4165a6137edda73b0bbed2009','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-09-04');
INSERT INTO `slots` VALUES (25,'f07bf85a9fa1c69606a09af266ba65a8','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-08-05');
INSERT INTO `slots` VALUES (26,'d886c233ff78e3f9398bd167f554dafd','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-07-29');
INSERT INTO `slots` VALUES (27,'1a9506fe1c36fe05fe7faa55996a1649','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-07-08');
INSERT INTO `slots` VALUES (28,'3a80619813c7a1dc883d028ad4bce373','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-07-08');
INSERT INTO `slots` VALUES (29,'c7feecb2b06afeb2b288d28dd17023a4','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-06-30');
INSERT INTO `slots` VALUES (30,'092616ec69e06750228770e70c49da09','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-06-09');
INSERT INTO `slots` VALUES (31,'f0414c127fa4575005351c02eb68701c','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-06-09');
INSERT INTO `slots` VALUES (32,'fc3a70eed21a406479f1cb98fc2a7d02','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-06-05');
INSERT INTO `slots` VALUES (33,'b9f260c1c54a8489f33556e2570a9458','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-06-05');
INSERT INTO `slots` VALUES (34,'d5027fc45d50f50aa7acc78790570744','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-05-28');
INSERT INTO `slots` VALUES (35,'bdac4d9fbd5f87d6b9d8f86cb65fc464','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-05-15');
INSERT INTO `slots` VALUES (36,'7f2f16b734e2e17cd5340da93672005b','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-05-05');
INSERT INTO `slots` VALUES (37,'bf037a5b59bdfcc660c4e73aa66ef7c0','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-05-05');
INSERT INTO `slots` VALUES (38,'21fc736807c2dc781f52ec38fff788b2','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-04-21');
INSERT INTO `slots` VALUES (39,'50a9870eb7f4b65a099de3b79b7623bd','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-04-21');
INSERT INTO `slots` VALUES (40,'7440b7e58d0c339093fae9e34af88f85','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-04-21');
INSERT INTO `slots` VALUES (41,'5ce6af1e1242dc673f7600d44b570345','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-04-04');
INSERT INTO `slots` VALUES (42,'7259e07e70613222245c63fc3e2e89e2','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-04-01');
INSERT INTO `slots` VALUES (43,'4cf756a993b815972dbacf734916a058','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-03-10');
INSERT INTO `slots` VALUES (44,'145d20df050dbbd6271c41f52bc78856','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-02-25');
INSERT INTO `slots` VALUES (45,'05452287c2430a9c0372ae515d6d5013','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-02-24');
INSERT INTO `slots` VALUES (46,'5175b714b1f1128525de617147622ed3','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-02-20');
INSERT INTO `slots` VALUES (47,'c67e764bc454d4b70176d51b6ec71e3d','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-02-18');
INSERT INTO `slots` VALUES (48,'57f77dd1f23a84d4a5276992d7c8ebaf','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2014-01-15');
INSERT INTO `slots` VALUES (49,'0cc999c50660ae15cb38aa04ef446b4b','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2013-12-27');
INSERT INTO `slots` VALUES (50,'d42ecb146499dcbccdd06cddbd5d4fd1','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2013-12-27');
INSERT INTO `slots` VALUES (51,'f6d81812301b965c441d54678b5a1353','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2013-12-11');
INSERT INTO `slots` VALUES (52,'1a0bb9aded09bce19ce8034d8701aad1','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2013-10-07');
INSERT INTO `slots` VALUES (53,'9917eb39a3db1b26c2d8c97577759fbb','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2013-09-06');
INSERT INTO `slots` VALUES (54,'4b309c0fde88b9dd161ac9cd988ad0d7','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2013-09-06');
INSERT INTO `slots` VALUES (55,'0cfeb06f0b5dec1765ff85a9c748e7ea','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2013-09-06');
INSERT INTO `slots` VALUES (56,'80be85816ff3fd08dc68e87acda8ee8e','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2013-09-05');
INSERT INTO `slots` VALUES (57,'8fcae1e3c03c8959a324c332be219c08','date-posted',10,0,NULL,0,NULL,NULL,0,1,'2013-09-01');
INSERT INTO `slots` VALUES (58,'1a6f6b91fb7ea4b856ac9d4cfec6a6c6','placeholder',4,0,'true',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (59,'1a6f6b91fb7ea4b856ac9d4cfec6a6c6','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (60,'22d76fff868a8e81d87812b04f87c8c8','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (61,'c4651d7a4bfc451d02c3140b40f6551b','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (62,'9171e5a9a83f119c37ea4acccd9f375e','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (63,'6292f601711c1f9cf8a8d3460ef1ed56','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (64,'e05687471bd4e8f541a389d6c343b4ac','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (65,'3b9b4a6797bad63baecd41f8e872312d','notes',4,0,'notes for this account',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (66,'3b9b4a6797bad63baecd41f8e872312d','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (67,'17d1788f3088e0290503bee69dd842c1','placeholder',4,0,'true',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (68,'17d1788f3088e0290503bee69dd842c1','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (69,'e2784082d3c074dd42c73968b5b582ef','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (70,'46a821c1c5a8e0b6dfeb8239f1f9ddb6','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (71,'6f2f5beae0f0f02811ad3bd4745e54d4','notes',4,0,'notes for this account',0,NULL,NULL,0,1,NULL);
INSERT INTO `slots` VALUES (72,'6f2f5beae0f0f02811ad3bd4745e54d4','color',4,0,'Not Set',0,NULL,NULL,0,1,NULL);
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
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 utf8 NOT NULL,
  `action` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `reconcile_state` varchar(1) CHARACTER SET utf8 NOT NULL,
  `reconcile_date` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `value_num` bigint(20) NOT NULL,
  `value_denom` bigint(20) NOT NULL,
  `quantity_num` bigint(20) NOT NULL,
  `quantity_denom` bigint(20) 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=latin1;
/*!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 ('026fc773852a3e12d0222f204a479adf','1a0bb9aded09bce19ce8034d8701aad1','3922d5de7121e710feb73912a6803ecc','','','c',NULL,35500,100,35500,100,NULL);
INSERT INTO `splits` VALUES ('02f606be8358b10a499a1f152e1f4233','7259e07e70613222245c63fc3e2e89e2','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,-100000,100,-100000,100,NULL);
INSERT INTO `splits` VALUES ('0cd0c263ec1ea2f23ca8bc1b9f375d87','f0414c127fa4575005351c02eb68701c','3922d5de7121e710feb73912a6803ecc','','','c',NULL,100000,100,100000,100,NULL);
INSERT INTO `splits` VALUES ('0efafbdce190985cfe0af656d4accd59','d5027fc45d50f50aa7acc78790570744','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-6199,100,-6199,100,NULL);
INSERT INTO `splits` VALUES ('110f8472cfb117b245ccd97be1782683','b9f260c1c54a8489f33556e2570a9458','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,60000,100,60000,100,NULL);
INSERT INTO `splits` VALUES ('12685ad2e7843e4229d9d0b78927d85b','57f77dd1f23a84d4a5276992d7c8ebaf','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,60000,100,60000,100,NULL);
INSERT INTO `splits` VALUES ('13b3619b1951ac0062655f83dd1d393a','0cfeb06f0b5dec1765ff85a9c748e7ea','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,-16,100,-16,100,NULL);
INSERT INTO `splits` VALUES ('145f32d1ab1f9fe1ae46d73e6e38e279','0cc999c50660ae15cb38aa04ef446b4b','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-6294,100,-6294,100,NULL);
INSERT INTO `splits` VALUES ('179f2888941562376276ce0476fe3e26','c7feecb2b06afeb2b288d28dd17023a4','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,-200000,100,-200000,100,NULL);
INSERT INTO `splits` VALUES ('1814c136d7e0a1c692a9fa493b2cd2cd','f0414c127fa4575005351c02eb68701c','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,-100000,100,-100000,100,NULL);
INSERT INTO `splits` VALUES ('1d9e6268b2cfac2983b2d03cae6e9559','7440b7e58d0c339093fae9e34af88f85','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-60000,100,-60000,100,NULL);
INSERT INTO `splits` VALUES ('265d549a3671e4b54e5ed6d7086a1970','145d20df050dbbd6271c41f52bc78856','3922d5de7121e710feb73912a6803ecc','','','c',NULL,100000,100,100000,100,NULL);
INSERT INTO `splits` VALUES ('26ab00da7b8c60c6c37f67944cc51773','21fc736807c2dc781f52ec38fff788b2','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,24095,100,24095,100,NULL);
INSERT INTO `splits` VALUES ('2a3c8d5d8340ad25dc7730c2245b43f2','cf66bc6e3d4d5305d3f96a66d264d3a6','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,70000,100,70000,100,NULL);
INSERT INTO `splits` VALUES ('2b4e97683aec550f8ec6724759911311','05452287c2430a9c0372ae515d6d5013','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,3600,100,3600,100,NULL);
INSERT INTO `splits` VALUES ('2b865ea9aec8e038e6b826a952e0265e','7440b7e58d0c339093fae9e34af88f85','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,60000,100,60000,100,NULL);
INSERT INTO `splits` VALUES ('2d6d86cb6962f1f0ab408a0333c010fd','c7feecb2b06afeb2b288d28dd17023a4','3922d5de7121e710feb73912a6803ecc','','','c',NULL,200000,100,200000,100,NULL);
INSERT INTO `splits` VALUES ('3275461bca6fc38f8c7a5da27bb964c2','5175b714b1f1128525de617147622ed3','3922d5de7121e710feb73912a6803ecc','','','c',NULL,8000,100,8000,100,NULL);
INSERT INTO `splits` VALUES ('33d0cdcc869b3502cc2251aabb6be4ad','0cc999c50660ae15cb38aa04ef446b4b','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,6294,100,6294,100,NULL);
INSERT INTO `splits` VALUES ('37bf30cf2ea6e00ad45a39f01a6bde3e','4cf756a993b815972dbacf734916a058','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-60000,100,-60000,100,NULL);
INSERT INTO `splits` VALUES ('3b98f8ff7cd765e557e20afe25acb42c','9917eb39a3db1b26c2d8c97577759fbb','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,18,100,18,100,NULL);
INSERT INTO `splits` VALUES ('3c68cd22705405d64ffb37dd4e100026','1a0bb9aded09bce19ce8034d8701aad1','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,-35500,100,-35500,100,NULL);
INSERT INTO `splits` VALUES ('3ecf62acaf4bb99a0ebfdc9198cdf9fc','092616ec69e06750228770e70c49da09','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,44500,100,44500,100,NULL);
INSERT INTO `splits` VALUES ('3f6d672f603415566d1f34a86a9d900e','d886c233ff78e3f9398bd167f554dafd','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,-100000,100,-100000,100,NULL);
INSERT INTO `splits` VALUES ('44f4eec204fea2c4636304d2bbaebca7','145d20df050dbbd6271c41f52bc78856','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,-100000,100,-100000,100,NULL);
INSERT INTO `splits` VALUES ('45735469b844bd9ea0558d53059dfdf1','80be85816ff3fd08dc68e87acda8ee8e','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,-24000,100,-24000,100,NULL);
INSERT INTO `splits` VALUES ('45f561da36caa215a029e4448140f493','5ce6af1e1242dc673f7600d44b570345','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,19800,100,19800,100,NULL);
INSERT INTO `splits` VALUES ('46dd49487bd0321c42b886a8b3a70bff','3dc3bae4165a6137edda73b0bbed2009','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,-120000,100,-120000,100,NULL);
INSERT INTO `splits` VALUES ('4a5988ee492e29fb5862ae6fa26351ee','5ce6af1e1242dc673f7600d44b570345','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-19800,100,-19800,100,NULL);
INSERT INTO `splits` VALUES ('4bac40fa262560ef5fa0fce3f1023fc3','4b309c0fde88b9dd161ac9cd988ad0d7','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,-2,100,-2,100,NULL);
INSERT INTO `splits` VALUES ('5dedae2a670a43a1eaa92b6aa8fad50e','bf037a5b59bdfcc660c4e73aa66ef7c0','3922d5de7121e710feb73912a6803ecc','','','c',NULL,100000,100,100000,100,NULL);
INSERT INTO `splits` VALUES ('6aa347968c1413cd0f193a642e3ec36b','8fcae1e3c03c8959a324c332be219c08','3922d5de7121e710feb73912a6803ecc','','','n',NULL,1000,100,1000,100,NULL);
INSERT INTO `splits` VALUES ('6d952d1bc1fd2af463d5cb856fec58d9','c67e764bc454d4b70176d51b6ec71e3d','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-60000,100,-60000,100,NULL);
INSERT INTO `splits` VALUES ('761dfb6020b62c7a5f98a911bbafdc47','05452287c2430a9c0372ae515d6d5013','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-3600,100,-3600,100,NULL);
INSERT INTO `splits` VALUES ('762296f369101e2612e67a74d17263ed','50a9870eb7f4b65a099de3b79b7623bd','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-40000,100,-40000,100,NULL);
INSERT INTO `splits` VALUES ('7caf8872019ae5720145df30ed13b0f8','50a9870eb7f4b65a099de3b79b7623bd','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,40000,100,40000,100,NULL);
INSERT INTO `splits` VALUES ('82bbf90a23da8aae5b20dda4b675dc6e','0cfeb06f0b5dec1765ff85a9c748e7ea','3922d5de7121e710feb73912a6803ecc','','','c',NULL,16,100,16,100,NULL);
INSERT INTO `splits` VALUES ('8653b6cfde15e6fe5f608dea921907bf','efb6159a242a43d1425351cfac675365','3922d5de7121e710feb73912a6803ecc','','','c',NULL,101870,100,101870,100,NULL);
INSERT INTO `splits` VALUES ('87cdee6fb6d438351a9573fa1f547adc','d42ecb146499dcbccdd06cddbd5d4fd1','3922d5de7121e710feb73912a6803ecc','','','c',NULL,40500,100,40500,100,NULL);
INSERT INTO `splits` VALUES ('9438d232245733ce1ef909af6d1fb8ac','fc3a70eed21a406479f1cb98fc2a7d02','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,3600,100,3600,100,NULL);
INSERT INTO `splits` VALUES ('984a733b923aa1ef3c93f0e9a3096f84','fc3a70eed21a406479f1cb98fc2a7d02','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-3600,100,-3600,100,NULL);
INSERT INTO `splits` VALUES ('98b23438a7a5f9fc77bac8d1462f5435','90d7dca3c21c041080c008ffd109820f','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,97500,100,97500,100,NULL);
INSERT INTO `splits` VALUES ('9bcf3a2fe6ada65353857703ce30cf4c','b9f260c1c54a8489f33556e2570a9458','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-60000,100,-60000,100,NULL);
INSERT INTO `splits` VALUES ('a2277262e5c9a57c47ce6618a34412c1','3a80619813c7a1dc883d028ad4bce373','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-115646,100,-115646,100,NULL);
INSERT INTO `splits` VALUES ('a437eb22a486881ac32e7a0dd952291d','d886c233ff78e3f9398bd167f554dafd','3922d5de7121e710feb73912a6803ecc','','','c',NULL,100000,100,100000,100,NULL);
INSERT INTO `splits` VALUES ('aba6ae72250329009114bc2ecd7c9279','c67e764bc454d4b70176d51b6ec71e3d','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,60000,100,60000,100,NULL);
INSERT INTO `splits` VALUES ('b0d2f9c7fd785e25c7ac17c3523c96e5','bdac4d9fbd5f87d6b9d8f86cb65fc464','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-9394,100,-9394,100,NULL);
INSERT INTO `splits` VALUES ('b1458f47ad874e2d0cb8273205cd36c8','7259e07e70613222245c63fc3e2e89e2','3922d5de7121e710feb73912a6803ecc','','','c',NULL,100000,100,100000,100,NULL);
INSERT INTO `splits` VALUES ('b1c1957808d60eaebfc21e4d76cb8611','3a80619813c7a1dc883d028ad4bce373','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,115646,100,115646,100,NULL);
INSERT INTO `splits` VALUES ('b8a7cfefb88646ec90914aa1acdde451','21fc736807c2dc781f52ec38fff788b2','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-24095,100,-24095,100,NULL);
INSERT INTO `splits` VALUES ('ba54249876b960e2162033cf21b1a778','d42ecb146499dcbccdd06cddbd5d4fd1','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,-40500,100,-40500,100,NULL);
INSERT INTO `splits` VALUES ('bb12487d73c0d8345172943c5a8836c3','3dc3bae4165a6137edda73b0bbed2009','3922d5de7121e710feb73912a6803ecc','','','c',NULL,120000,100,120000,100,NULL);
INSERT INTO `splits` VALUES ('bddc5556fd7ca57f8a4766caf9cf9e1f','9917eb39a3db1b26c2d8c97577759fbb','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-18,100,-18,100,NULL);
INSERT INTO `splits` VALUES ('c269d4110fdd59e40410230d68e22406','7f2f16b734e2e17cd5340da93672005b','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-60000,100,-60000,100,NULL);
INSERT INTO `splits` VALUES ('c298594ba5dc48f5bfe91e00b8a2ee7b','90d7dca3c21c041080c008ffd109820f','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-97500,100,-97500,100,NULL);
INSERT INTO `splits` VALUES ('ca511a41dafb6fe4d9a249fde71c8c94','8fcae1e3c03c8959a324c332be219c08','883e8eb608c9fa496474f60f6a8db742','','','n',NULL,-1000,100,-1000,100,NULL);
INSERT INTO `splits` VALUES ('cc92d93271bc5208fc61873fbfa24b4a','5b0da9bc167f157ded4fa0511c6c3ad4','883e8eb608c9fa496474f60f6a8db742','','','n',NULL,-10000,100,-10000,100,NULL);
INSERT INTO `splits` VALUES ('cf160a374a59f45660edb5387188627f','bdac4d9fbd5f87d6b9d8f86cb65fc464','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,9394,100,9394,100,NULL);
INSERT INTO `splits` VALUES ('cf4c2f7c64a7f20f50aa268cbf491a06','1a9506fe1c36fe05fe7faa55996a1649','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-70000,100,-70000,100,NULL);
INSERT INTO `splits` VALUES ('cfc8a10738b04306a68cf05709a4ad79','f07bf85a9fa1c69606a09af266ba65a8','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,70000,100,70000,100,NULL);
INSERT INTO `splits` VALUES ('d169928a41a00b6c6ade43e69a0915a1','57f77dd1f23a84d4a5276992d7c8ebaf','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-60000,100,-60000,100,NULL);
INSERT INTO `splits` VALUES ('d1cf2e8c5953ab3a67aae1a82b84ed58','5b0da9bc167f157ded4fa0511c6c3ad4','4058ccfd69a535f3e194ea40a91120ea','','','n',NULL,10000,100,10000,100,NULL);
INSERT INTO `splits` VALUES ('d3f41cf54a0d5c94a7c5f599d29282e8','bf037a5b59bdfcc660c4e73aa66ef7c0','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,-100000,100,-100000,100,NULL);
INSERT INTO `splits` VALUES ('d40e9c7549c3c8118de2b3e0c33135bb','cf66bc6e3d4d5305d3f96a66d264d3a6','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-70000,100,-70000,100,NULL);
INSERT INTO `splits` VALUES ('d574ead36af1f201a21df31adfc2d986','5175b714b1f1128525de617147622ed3','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,-8000,100,-8000,100,NULL);
INSERT INTO `splits` VALUES ('d7a9e5756e21eb19e1dddc06ea3233c0','7f2f16b734e2e17cd5340da93672005b','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,60000,100,60000,100,NULL);
INSERT INTO `splits` VALUES ('d89fef91a52542a1f3611fb19a78589a','efb6159a242a43d1425351cfac675365','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,-101870,100,-101870,100,NULL);
INSERT INTO `splits` VALUES ('de46baa8b8c4da00c69f0cf59df65d17','80be85816ff3fd08dc68e87acda8ee8e','3922d5de7121e710feb73912a6803ecc','','','c',NULL,24000,100,24000,100,NULL);
INSERT INTO `splits` VALUES ('f1d6a4d6f3bbccccb5e74538dad77d9a','4b309c0fde88b9dd161ac9cd988ad0d7','3922d5de7121e710feb73912a6803ecc','','','c',NULL,2,100,2,100,NULL);
INSERT INTO `splits` VALUES ('f27f3c77102e8ffa8806f1051f9527b8','f07bf85a9fa1c69606a09af266ba65a8','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-70000,100,-70000,100,NULL);
INSERT INTO `splits` VALUES ('f28781a84516cae9bea2894609449010','092616ec69e06750228770e70c49da09','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-44500,100,-44500,100,NULL);
INSERT INTO `splits` VALUES ('f7c08398693e42baa595f71c29753ab9','1a9506fe1c36fe05fe7faa55996a1649','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,70000,100,70000,100,NULL);
INSERT INTO `splits` VALUES ('f843bf364ae5fbd91b55f6a660842358','d5027fc45d50f50aa7acc78790570744','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,6199,100,6199,100,NULL);
INSERT INTO `splits` VALUES ('f8e6c9fdd7ac2b0f1eccaa38a853b7ec','f6d81812301b965c441d54678b5a1353','3922d5de7121e710feb73912a6803ecc','','','c',NULL,-30000,100,-30000,100,NULL);
INSERT INTO `splits` VALUES ('fa0c9410f134df2c5041f131af201a76','4cf756a993b815972dbacf734916a058','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,60000,100,60000,100,NULL);
INSERT INTO `splits` VALUES ('ffeb9f1314b58b76a24eec9bfc502f43','f6d81812301b965c441d54678b5a1353','5ae9d4744bdde490f7bba4be66162fdf','','','n',NULL,30000,100,30000,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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taxtable_entries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `taxtable` varchar(32) NOT NULL,
  `account` varchar(32) NOT NULL,
  `amount_num` bigint(20) NOT NULL,
  `amount_denom` bigint(20) NOT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taxtables` (
  `guid` varchar(32) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `refcount` bigint(20) NOT NULL,
  `invisible` int(11) NOT NULL,
  `parent` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions` (
  `guid` varchar(32) NOT NULL,
  `currency_guid` varchar(32) NOT NULL,
  `num` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `post_date` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `enter_date` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `description` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`guid`),
  KEY `tx_post_date_index` (`post_date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 ('05452287c2430a9c0372ae515d6d5013','312777654fe2c543a7c41f30f3d38fff','','2014-02-24 12:00:00','2014-09-19 02:13:58','STOP PAY-SPECIAL PAY INST FEE');
INSERT INTO `transactions` VALUES ('092616ec69e06750228770e70c49da09','312777654fe2c543a7c41f30f3d38fff','','2014-06-09 10:00:00','2014-09-19 02:13:56','CHECK #1014');
INSERT INTO `transactions` VALUES ('0cc999c50660ae15cb38aa04ef446b4b','312777654fe2c543a7c41f30f3d38fff','','2013-12-27 12:00:00','2014-09-19 02:13:59','CHECK #1002');
INSERT INTO `transactions` VALUES ('0cfeb06f0b5dec1765ff85a9c748e7ea','312777654fe2c543a7c41f30f3d38fff','','2013-09-06 10:00:00','2014-09-19 02:14:00','PAYPAL VERIFYBANK');
INSERT INTO `transactions` VALUES ('145d20df050dbbd6271c41f52bc78856','312777654fe2c543a7c41f30f3d38fff','','2014-02-25 12:00:00','2014-09-19 02:13:58','PAYPAL TRANSFER');
INSERT INTO `transactions` VALUES ('1a0bb9aded09bce19ce8034d8701aad1','312777654fe2c543a7c41f30f3d38fff','','2013-10-07 10:00:00','2014-09-19 02:13:59','DEPOSIT');
INSERT INTO `transactions` VALUES ('1a9506fe1c36fe05fe7faa55996a1649','312777654fe2c543a7c41f30f3d38fff','','2014-07-08 10:00:00','2014-09-19 02:13:56','CHECK #1015');
INSERT INTO `transactions` VALUES ('21fc736807c2dc781f52ec38fff788b2','312777654fe2c543a7c41f30f3d38fff','','2014-04-21 10:00:00','2014-09-19 02:13:57','CHECK #1006');
INSERT INTO `transactions` VALUES ('3a80619813c7a1dc883d028ad4bce373','312777654fe2c543a7c41f30f3d38fff','','2014-07-08 10:00:00','2014-09-19 02:13:56','CHECK #1016');
INSERT INTO `transactions` VALUES ('3dc3bae4165a6137edda73b0bbed2009','312777654fe2c543a7c41f30f3d38fff','','2014-09-04 10:00:00','2014-09-19 02:13:56','PAYPAL TRANSFER');
INSERT INTO `transactions` VALUES ('4b309c0fde88b9dd161ac9cd988ad0d7','312777654fe2c543a7c41f30f3d38fff','','2013-09-06 10:00:00','2014-09-19 02:14:00','PAYPAL VERIFYBANK');
INSERT INTO `transactions` VALUES ('4cf756a993b815972dbacf734916a058','312777654fe2c543a7c41f30f3d38fff','','2014-03-10 10:00:00','2014-09-19 02:13:58','CHECK #1007');
INSERT INTO `transactions` VALUES ('50a9870eb7f4b65a099de3b79b7623bd','312777654fe2c543a7c41f30f3d38fff','','2014-04-21 10:00:00','2014-09-19 02:13:58','CHECK #1009');
INSERT INTO `transactions` VALUES ('5175b714b1f1128525de617147622ed3','312777654fe2c543a7c41f30f3d38fff','','2014-02-20 12:00:00','2014-09-19 02:13:59','DEPOSIT');
INSERT INTO `transactions` VALUES ('57f77dd1f23a84d4a5276992d7c8ebaf','312777654fe2c543a7c41f30f3d38fff','','2014-01-15 12:00:00','2014-09-19 02:13:59','CHECK #1004');
INSERT INTO `transactions` VALUES ('5b0da9bc167f157ded4fa0511c6c3ad4','312777654fe2c543a7c41f30f3d38fff','','2014-09-18 10:00:00','2014-09-19 01:47:58','');
INSERT INTO `transactions` VALUES ('5ce6af1e1242dc673f7600d44b570345','312777654fe2c543a7c41f30f3d38fff','','2014-04-04 10:00:00','2014-09-19 02:13:58','CHECK #1010');
INSERT INTO `transactions` VALUES ('7259e07e70613222245c63fc3e2e89e2','312777654fe2c543a7c41f30f3d38fff','','2014-04-01 10:00:00','2014-09-19 02:13:58','PAYPAL TRANSFER');
INSERT INTO `transactions` VALUES ('7440b7e58d0c339093fae9e34af88f85','312777654fe2c543a7c41f30f3d38fff','','2014-04-21 10:00:00','2014-09-19 02:13:58','CHECK #1008');
INSERT INTO `transactions` VALUES ('7f2f16b734e2e17cd5340da93672005b','312777654fe2c543a7c41f30f3d38fff','','2014-05-05 10:00:00','2014-09-19 02:13:57','CHECK #1011');
INSERT INTO `transactions` VALUES ('80be85816ff3fd08dc68e87acda8ee8e','312777654fe2c543a7c41f30f3d38fff','','2013-09-05 10:00:00','2014-09-19 02:14:00','DEPOSIT');
INSERT INTO `transactions` VALUES ('8fcae1e3c03c8959a324c332be219c08','312777654fe2c543a7c41f30f3d38fff','','2013-09-01 10:00:00','2014-09-19 02:16:59','Initial balance');
INSERT INTO `transactions` VALUES ('90d7dca3c21c041080c008ffd109820f','312777654fe2c543a7c41f30f3d38fff','','2014-09-10 10:00:00','2014-09-19 02:13:55','CHECK #1019');
INSERT INTO `transactions` VALUES ('9917eb39a3db1b26c2d8c97577759fbb','312777654fe2c543a7c41f30f3d38fff','','2013-09-06 10:00:00','2014-09-19 02:13:59','PAYPAL VERIFYBANK');
INSERT INTO `transactions` VALUES ('b9f260c1c54a8489f33556e2570a9458','312777654fe2c543a7c41f30f3d38fff','','2014-06-05 10:00:00','2014-09-19 02:13:57','CHECK #1013');
INSERT INTO `transactions` VALUES ('bdac4d9fbd5f87d6b9d8f86cb65fc464','312777654fe2c543a7c41f30f3d38fff','','2014-05-15 10:00:00','2014-09-19 02:13:57','CHECK #1012');
INSERT INTO `transactions` VALUES ('bf037a5b59bdfcc660c4e73aa66ef7c0','312777654fe2c543a7c41f30f3d38fff','','2014-05-05 10:00:00','2014-09-19 02:13:57','PAYPAL TRANSFER');
INSERT INTO `transactions` VALUES ('c67e764bc454d4b70176d51b6ec71e3d','312777654fe2c543a7c41f30f3d38fff','','2014-02-18 12:00:00','2014-09-19 02:13:59','CHECK #1005');
INSERT INTO `transactions` VALUES ('c7feecb2b06afeb2b288d28dd17023a4','312777654fe2c543a7c41f30f3d38fff','','2014-06-30 10:00:00','2014-09-19 02:13:56','PAYPAL TRANSFER');
INSERT INTO `transactions` VALUES ('cf66bc6e3d4d5305d3f96a66d264d3a6','312777654fe2c543a7c41f30f3d38fff','','2014-09-10 10:00:00','2014-09-19 02:13:55','CHECK #1018');
INSERT INTO `transactions` VALUES ('d42ecb146499dcbccdd06cddbd5d4fd1','312777654fe2c543a7c41f30f3d38fff','','2013-12-27 12:00:00','2014-09-19 02:13:59','DEPOSIT');
INSERT INTO `transactions` VALUES ('d5027fc45d50f50aa7acc78790570744','312777654fe2c543a7c41f30f3d38fff','','2014-05-28 10:00:00','2014-09-19 02:13:57','AT&T UVERSE ONLINE PMT');
INSERT INTO `transactions` VALUES ('d886c233ff78e3f9398bd167f554dafd','312777654fe2c543a7c41f30f3d38fff','','2014-07-29 10:00:00','2014-09-19 02:13:56','PAYPAL TRANSFER');
INSERT INTO `transactions` VALUES ('efb6159a242a43d1425351cfac675365','312777654fe2c543a7c41f30f3d38fff','','2014-09-12 10:00:00','2014-09-19 02:13:55','DEPOSIT');
INSERT INTO `transactions` VALUES ('f0414c127fa4575005351c02eb68701c','312777654fe2c543a7c41f30f3d38fff','','2014-06-09 10:00:00','2014-09-19 02:13:57','PAYPAL TRANSFER');
INSERT INTO `transactions` VALUES ('f07bf85a9fa1c69606a09af266ba65a8','312777654fe2c543a7c41f30f3d38fff','','2014-08-05 10:00:00','2014-09-19 02:13:56','CHECK #1017');
INSERT INTO `transactions` VALUES ('f6d81812301b965c441d54678b5a1353','312777654fe2c543a7c41f30f3d38fff','','2013-12-11 12:00:00','2014-09-19 02:13:59','CHECK #1003');
INSERT INTO `transactions` VALUES ('fc3a70eed21a406479f1cb98fc2a7d02','312777654fe2c543a7c41f30f3d38fff','','2014-06-05 10:00:00','2014-09-19 02:13:57','PAID OVERDRAFT ITEM FEE');
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vendors` (
  `guid` varchar(32) NOT NULL,
  `name` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `id` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `notes` varchar(2048) CHARACTER SET utf8 NOT NULL,
  `currency` varchar(32) NOT NULL,
  `active` int(11) NOT NULL,
  `tax_override` int(11) NOT NULL,
  `addr_name` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_addr1` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_addr2` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_addr3` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_addr4` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `addr_phone` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `addr_fax` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `addr_email` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `terms` varchar(32) DEFAULT NULL,
  `tax_inc` varchar(2048) CHARACTER SET utf8 DEFAULT NULL,
  `tax_table` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `versions` (
  `table_name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `table_version` int(11) NOT NULL,
  PRIMARY KEY (`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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);
INSERT INTO `versions` VALUES ('billterms',2);
INSERT INTO `versions` VALUES ('books',1);
INSERT INTO `versions` VALUES ('budgets',1);
INSERT INTO `versions` VALUES ('budget_amounts',1);
INSERT INTO `versions` VALUES ('commodities',1);
INSERT INTO `versions` VALUES ('customers',2);
INSERT INTO `versions` VALUES ('employees',2);
INSERT INTO `versions` VALUES ('entries',3);
INSERT INTO `versions` VALUES ('Gnucash',2060300);
INSERT INTO `versions` VALUES ('Gnucash-Resave',19920);
INSERT INTO `versions` VALUES ('invoices',3);
INSERT INTO `versions` VALUES ('jobs',1);
INSERT INTO `versions` VALUES ('lots',2);
INSERT INTO `versions` VALUES ('orders',1);
INSERT INTO `versions` VALUES ('prices',2);
INSERT INTO `versions` VALUES ('recurrences',2);
INSERT INTO `versions` VALUES ('schedxactions',1);
INSERT INTO `versions` VALUES ('slots',3);
INSERT INTO `versions` VALUES ('splits',4);
INSERT INTO `versions` VALUES ('taxtables',2);
INSERT INTO `versions` VALUES ('taxtable_entries',3);
INSERT INTO `versions` VALUES ('transactions',3);
INSERT INTO `versions` VALUES ('vendors',1);
/*!40000 ALTER TABLE `versions` ENABLE KEYS */;
UNLOCK TABLES;


More information about the gnucash-user mailing list