[encoded data, 229908 characters],'',0),(6,1610550764,'','31dfe53f7332622a0b89a484f6a8d08e','',0,'',0,'74432b10daeac1c6f06414a813ea06b5','Kimball_1.sif','SIF','application/octet-stream','',11111,0x[encoded data, 22222 characters],'',0);

--
-- Table structure for table `error_trap`
--

CREATE TABLE `error_trap` (
  `obj_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_hash` varchar(32) NOT NULL DEFAULT '',
  `timestamp` int(11) NOT NULL DEFAULT '0',
  `error_code` int(11) NOT NULL DEFAULT '0',
  `message` text NOT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `error_trap`
--


--
-- Table structure for table `finance_charges`
--

CREATE TABLE `finance_charges` (
  `obj_id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` int(10) unsigned NOT NULL,
  `last_change` varchar(32) NOT NULL,
  `charge_hash` varchar(32) NOT NULL,
  `invoice_hash` varchar(32) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `deleted_date` date DEFAULT NULL,
  `date` date NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `account_hash` varchar(32) NOT NULL,
  `comment` varchar(255) NOT NULL,
  PRIMARY KEY (`obj_id`),
  KEY `invoice_hash` (`invoice_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `finance_charges`
--


--
-- Table structure for table `income_statement`
--

CREATE TABLE `income_statement` (
  `obj_id` int(11) NOT NULL AUTO_INCREMENT,
  `position` int(11) NOT NULL,
  `category` char(1) NOT NULL,
  `group_hash` varchar(32) NOT NULL,
  `group_name` varchar(32) NOT NULL,
  `accounts` text NOT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `income_statement`
--


--
-- Table structure for table `item_hash_index`
--

CREATE TABLE `item_hash_index` (
  `item_hash` varchar(32) NOT NULL,
  PRIMARY KEY (`item_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `item_hash_index`
--

INSERT INTO `item_hash_index` VALUES ('0035b109dd9ea777f66670ad17cb26da'),('00b263cafc18cbfd070118b04fbaad11'),('02d534c819e94dff9b5c90bcaeac04d0'),('0391dbe9bb7df7062cd327953a3cf435'),('04651348213fb13dc784098425ceb172'),('046a1a2ec781da80b3ca33c80f7f22c8'),('04cdeff8c9731df4b70be4d99e5a8ee6'),('04d4711cbdc6cfc309efde2a8607afd4'),('0b01851a3f9e5c41dfdabcfaa934d82b'),('0da7179f8eed4bde4dab3994f85ccfa7'),('1280fc0e622b9330ee41bc1d8d4eb415'),('14c9c52c67786852a5e83cb9feffddb4'),('1ddf64edde17bd61a1a6106bdcc30b30'),('1e27a5710b9340c19e458c47a895dcc4'),('1e7b0b262027c565d8c15775756163f3'),('1fd2f69efa1f85c58072ef3c91fa6223'),('23eaf6bfb8433c1497bbecbd54efeaba'),('25b26e6451632441a7740f1162539ab6'),('25f4f50bc09c595fb16c1cb68c7c528c'),('27a69e8fb920fb667217049999f1a034'),('2897c03e1eadbaf6a56540cf35cd89da'),('28a83eb85c5c1b137f2a891b72284396'),('29005d62516460b6ebeb57e73db62bc3'),('29462340118ecca8aab3c03cb36c9c3c'),('2a9c48e55340940d54190978a09fc54a'),('2ac7206fab3a9d7b3c9b53fe9ed3bffb'),('2c97381ad63e6ba17e7ee2e215262af3'),('2fb907c45999323db748db4de50859e9'),('2ff8e61f23b8626fe04a0f4e6a847fe0'),('35411102d61349b8039ff4ad6a187b7f'),('3a5bb0a4d1e1579280ea3db9e9c69f3a'),('41c2b3ed14f80993b739a19c893e431b'),('4a7eb7a920f3fdf0e579c626926819c3'),('4b9ce5100aeddc158c6612c49c3257df'),('50be20c28f8552a4e1e2d42b730d9784'),('51b5e12036624ebd7400aa02cd97f727'),('5345c6c366368994da4d6bef21539441'),('54d038fad258d20738c32c485ac2f654'),('5652be2d0007cd15c27edc6543a7d1df'),('57aa6e41ed61643560b66a4d38f35110'),('5a451180f001205562bffb11ca4e3c23'),('5b7a8be7da4263b4ede8582303662a03'),('5bc8afedcbd1235a98a0b598d69c8663'),('60f46f0b152f9fd0b09f6fd15a19434c'),('62a1e1a8ab11076b714f7945a620d40c'),('63330cdb77afc6c9db88c85538a9f173'),('6525df29909a443d95ebc2f7ff8a67ea'),('66744421d11c209ddc6d3d7f6eaa25d5'),('6720a4032806df455c8caacb8e3d6676'),('67389332d72992e43b9a25de7644a9a1'),('6a59d25149388954a55ba7fa4dad3c03'),('6b5f8ce9767e51a9e95de3d68406e837'),('6c76390bf39db313dcba74117e26b507'),('6f380bd748483f0ad8441988c0ff3e56'),('6fcac32e3bca3f98a86242fc3e16a44d'),('70bdc1fee5836b2b1bcbc61fe1153626'),('7399f2a4ec9c9e9218a4d50e04608c51'),('7536febd053a9371558f82ca05e6bdc7'),('78d5a120976a91a7e90876d6af83979c'),('7a13f58978eb4a8743ce93b0b211a7e0'),('7dbc7a83239a44f6b6f700e8979b949c'),('804ac4d54820856986215a4f3001a367'),('80bf26885f3bb17710901e67a3d98827'),('826507b5343c5a0b07612c9b0b7a8eaf'),('86a0a4e8271756c1bf836472237b433e'),('87dddc59f193c81737956f40726d8270'),('88b03c4229eb9cb6733163e6efe0318b'),('88cd8031d344b78e20a27104220fc64b'),('90290539375820261243dd38c01237d0'),('9102fcf4df385188da22ea1056e681b6'),('9383d0bb5fe61eba0520f81991885297'),('93e1811e8883b3887a8052a730eef3e1'),('94e82763aaa94a97f5837d6beb845db2'),('97f7d1ced1834bc1daf4c641e60c1798'),('9b829c402f706d6da901108b7a89252e'),('9c41d097a036a37a85ff2c0042382aea'),('a143b93a787d1796787bd07d7c4bcb0f'),('a61fc99c5a28ee4374f43e69c2b39a4d'),('a68f86d27156b6fe8d7312bbd2cc095c'),('a7f9922c3db9d64576896c1e941e1a3e'),('a847558b46eef931f1d3cf4c9075bfd6'),('aa14454e97fe3fae877f525fd36b5d1f'),('ac17e9d731b3ccc7294baf72bf09bc08'),('af328fdfee8d9bb3dbb78c7023ed6775'),('af3fa752f2a90a44eb43be54ba89163c'),('b61e8938a819be2fa538b65215c0c45d'),('ba1d9776a22a29552da16dde74233b9f'),('ba7af188728db54c795cfab2f402263b'),('bf11256f32633654dc4b70733d32f6b6'),('c1b67ee31bc033f2eae8312f56e18821'),('c84771a99c6fc8151aa01743663a0c90'),('cc9796f7df4fa5d72dd5d01e033a9b76'),('d4da6d35e1198ab4bff20de18c968837'),('d712964521b5123f439cc241034bf2f0'),('d793a622a93ce423d37764cddd8ccc0b'),('d7faefae976c031b46b9306a405e034a'),('da3f64759f3edd64886382c28f1597aa'),('dbed9eea787db1fefd06525b4f9cb98f'),('df83d2dfa5e38fedfada0fa51dc5542d'),('e25e6c80a13897fe40e8cf9df94e63f2'),('e5ba732ecf66e10cfdf28ab48aba706b'),('e729a6dedac7bfcf40b37e24f8c25deb'),('e7a47fd3d0cfd6cf81df5f67e838c402'),('ea2194d6f0d370370dd858f0d09c2bdb'),('eda46bafd401d689cdb78a13edb827ca'),('ee6f4e568167996a5495b5e78eaf22b5'),('ef69f8979d9a6af2a1ab45df28c12e72'),('f14b97288c2638ea68f6cb11761c8dfe'),('f151dc973428b3d7a795afbe7f7b4464'),('f169cf4823f9246072ae500119f9fa94'),('f1748e636559b1ab8954a9d9aaab2959'),('f1a03de3b7a49a5502e3681063e64ee1'),('f32b60008dbb1d6ce01652143d9dd58d'),('f4247cd85b038bfe45c6008f8347fd28'),('f565da545c2049828bf8286803a602d0'),('f7f6a7455ba4925598416c5e12c7d6ad'),('f991791c4fd38747d67983801a6264e5'),('fcc6940c9dc69a15435e6ca65a46308e'),('fe6aab021badf3de24bb78ee31ff9d2c');

--
-- Table structure for table `item_library`
--

CREATE TABLE `item_library` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vendor_hash` varchar(32) NOT NULL,
  `item_number` varchar(16) NOT NULL,
  `item_desc` varchar(255) NOT NULL,
  `list_price` float NOT NULL,
  `sell_price` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4658 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `item_library`
--


--
-- Table structure for table `journal`
--

CREATE TABLE `journal` (
  `obj_id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL DEFAULT '0',
  `auto` tinyint(1) NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `last_change` varchar(32) NOT NULL DEFAULT '',
  `id_hash` varchar(32) NOT NULL,
  `journal_hash` varchar(32) NOT NULL DEFAULT '',
  `proposal_hash` varchar(32) DEFAULT NULL,
  `ar_invoice_hash` varchar(32) DEFAULT NULL,
  `ar_credit_hash` varchar(32) DEFAULT NULL,
  `ap_invoice_hash` varchar(32) DEFAULT NULL,
  `customer_hash` varchar(32) DEFAULT NULL,
  `vendor_hash` varchar(32) DEFAULT NULL,
  `check_no` varchar(24) DEFAULT NULL,
  `ar_payment_hash` varchar(32) DEFAULT NULL,
  `ap_payment_hash` varchar(32) DEFAULT NULL,
  `audit_id` bigint(20) NOT NULL DEFAULT '0',
  `item_hash` varchar(32) DEFAULT NULL,
  `account_hash` varchar(32) NOT NULL DEFAULT '',
  `debit` decimal(13,2) NOT NULL DEFAULT '0.00',
  `credit` decimal(13,2) NOT NULL DEFAULT '0.00',
  `trans_type` varchar(12) NOT NULL DEFAULT '',
  `memo` varchar(64) NOT NULL DEFAULT '',
  `cleared` tinyint(1) NOT NULL DEFAULT '0',
  `show_zero` char(2) DEFAULT NULL,
  `currency` char(3) DEFAULT NULL,
  `exchange_rate` decimal(10,8) DEFAULT NULL,
  PRIMARY KEY (`obj_id`),
  UNIQUE KEY `journal_hash` (`journal_hash`),
  KEY `account_hash` (`account_hash`),
  KEY `date` (`date`),
  KEY `audit_id` (`audit_id`),
  KEY `ar_invoice_hash` (`ar_invoice_hash`),
  KEY `ar_payment_hash` (`ar_payment_hash`),
  KEY `ap_invoice_hash` (`ap_invoice_hash`),
  KEY `ap_payment_hash` (`ap_payment_hash`),
  KEY `proposal_hash` (`proposal_hash`),
  KEY `customer_hash` (`customer_hash`),
  KEY `vendor_hash` (`vendor_hash`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;

--
