-- MySQL dump 10.9 -- -- Host: localhost Database: test -- ------------------------------------------------------ -- Server version 4.1.14-log /*!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 */; /*!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 `split` -- DROP TABLE IF EXISTS `split`; CREATE TABLE `split` ( `transaction` varchar(31) NOT NULL default '', `amount` decimal(8,2) NOT NULL default '0.00', KEY `FK_split_transaction` (`transaction`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `split` -- /*!40000 ALTER TABLE `split` DISABLE KEYS */; LOCK TABLES `split` WRITE; INSERT INTO `split` VALUES ('98c3a0a07af42bb0b96539e8ca6d31d','107.90'),('182fedf6bf740de209da658362307d6','28.50'),('96779b5478b7b4cda07e639729ac4ff','0.03'),('d7976b8667435bdb6939d5354a38102','118.78'),('182fedf6bf740de209da658362307d6','121.85'),('a482d3416841b6870e22aeb7bc1e65b','5.00'),('3c6cb1aa8df451e0d2a234bea919edd','-4986.24'),('9c6ab1d5a822205fbba82d5e93613dd','-200.00'),('81487469bdbc9e862ddaf068086aabe','96.07'),('d8f6bf34a82b65005af11e53b69e9d0','216.84'),('a482d3416841b6870e22aeb7bc1e65b','-2104.80'),('40509d65d986eaad08b06ef59afce31','3346.83'),('74bc51a3fba5c0961fa3aac5afb7dc3','-12904.11'),('d8f6bf34a82b65005af11e53b69e9d0','107.90'),('98c3a0a07af42bb0b96539e8ca6d31d','2520.81'),('1e6f698e737158fcfb04eed030ca038','26.65'),('9c6ab1d5a822205fbba82d5e93613dd','226.88'),('d7976b8667435bdb6939d5354a38102','7.94'),('d8f6bf34a82b65005af11e53b69e9d0','-3596.50'),('a482d3416841b6870e22aeb7bc1e65b','2033.80'),('d7976b8667435bdb6939d5354a38102','27.77'),('98c3a0a07af42bb0b96539e8ca6d31d','50.71'),('98c3a0a07af42bb0b96539e8ca6d31d','446.23'),('81487469bdbc9e862ddaf068086aabe','6404.65'),('d7976b8667435bdb6939d5354a38102','79.12'),('40509d65d986eaad08b06ef59afce31','330.19'),('182fedf6bf740de209da658362307d6','157.23'),('3c6cb1aa8df451e0d2a234bea919edd','5.00'),('df6705732c57ce0979873bd566dd9ae','234.94'),('40509d65d986eaad08b06ef59afce31','234.94'),('74bc51a3fba5c0961fa3aac5afb7dc3','12.00'),('40509d65d986eaad08b06ef59afce31','-5416.68'),('40509d65d986eaad08b06ef59afce31','90.99'),('3c6cb1aa8df451e0d2a234bea919edd','4857.34'),('182fedf6bf740de209da658362307d6','1351.00'),('d8f6bf34a82b65005af11e53b69e9d0','50.72'),('96779b5478b7b4cda07e639729ac4ff','5.00'),('d8f6bf34a82b65005af11e53b69e9d0','446.23'),('e8e1fcd15fc82ae2cdc057341efe4af','-1695.31'),('40509d65d986eaad08b06ef59afce31','77.22'),('96779b5478b7b4cda07e639729ac4ff','-853.44'),('d7976b8667435bdb6939d5354a38102','1323.23'),('3c6cb1aa8df451e0d2a234bea919edd','123.74'),('a482d3416841b6870e22aeb7bc1e65b','0.07'),('de59667992e5045ff98e8f0b798bb06','-111.24'),('d7976b8667435bdb6939d5354a38102','205.68'),('98c3a0a07af42bb0b96539e8ca6d31d','99.00'),('d7976b8667435bdb6939d5354a38102','153.26'),('d7976b8667435bdb6939d5354a38102','-1915.78'),('df6705732c57ce0979873bd566dd9ae','473.02'),('96779b5478b7b4cda07e639729ac4ff','806.41'),('74bc51a3fba5c0961fa3aac5afb7dc3','12903.14'),('d8f6bf34a82b65005af11e53b69e9d0','2520.81'),('93e8e62b5da5b4366de03e6e62ade25','1151.40'),('df6705732c57ce0979873bd566dd9ae','3668.65'),('df6705732c57ce0979873bd566dd9ae','77.22'),('182fedf6bf740de209da658362307d6','-1965.35'),('de59667992e5045ff98e8f0b798bb06','47.24'),('df6705732c57ce0979873bd566dd9ae','541.67'),('40509d65d986eaad08b06ef59afce31','541.67'),('9c6ab1d5a822205fbba82d5e93613dd','-26.88'),('40509d65d986eaad08b06ef59afce31','794.84'),('e8e1fcd15fc82ae2cdc057341efe4af','1003.77'),('df6705732c57ce0979873bd566dd9ae','90.99'),('98c3a0a07af42bb0b96539e8ca6d31d','-3596.50'),('81487469bdbc9e862ddaf068086aabe','-6500.72'),('3c6cb1aa8df451e0d2a234bea919edd','0.16'),('182fedf6bf740de209da658362307d6','81.75'),('d8f6bf34a82b65005af11e53b69e9d0','155.00'),('e8e1fcd15fc82ae2cdc057341efe4af','499.72'),('182fedf6bf740de209da658362307d6','217.08'),('df6705732c57ce0979873bd566dd9ae','-5416.68'),('d8f6bf34a82b65005af11e53b69e9d0','99.00'),('df6705732c57ce0979873bd566dd9ae','330.19'),('de59667992e5045ff98e8f0b798bb06','64.00'),('e8e1fcd15fc82ae2cdc057341efe4af','191.82'),('98c3a0a07af42bb0b96539e8ca6d31d','155.00'),('98c3a0a07af42bb0b96539e8ca6d31d','216.85'),('93e8e62b5da5b4366de03e6e62ade25','-851.40'),('a482d3416841b6870e22aeb7bc1e65b','65.93'),('182fedf6bf740de209da658362307d6','7.94'),('93e8e62b5da5b4366de03e6e62ade25','-300.00'),('74bc51a3fba5c0961fa3aac5afb7dc3','-11.03'),('96779b5478b7b4cda07e639729ac4ff','42.00'); UNLOCK TABLES; /*!40000 ALTER TABLE `split` ENABLE KEYS */; -- -- Table structure for table `transaction` -- DROP TABLE IF EXISTS `transaction`; CREATE TABLE `transaction` ( `id` varchar(31) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `transaction` -- /*!40000 ALTER TABLE `transaction` DISABLE KEYS */; LOCK TABLES `transaction` WRITE; INSERT INTO `transaction` VALUES ('182fedf6bf740de209da658362307d6'),('1e6f698e737158fcfb04eed030ca038'),('3c6cb1aa8df451e0d2a234bea919edd'),('40509d65d986eaad08b06ef59afce31'),('74bc51a3fba5c0961fa3aac5afb7dc3'),('81487469bdbc9e862ddaf068086aabe'),('93e8e62b5da5b4366de03e6e62ade25'),('96779b5478b7b4cda07e639729ac4ff'),('98c3a0a07af42bb0b96539e8ca6d31d'),('9c6ab1d5a822205fbba82d5e93613dd'),('a482d3416841b6870e22aeb7bc1e65b'),('d7976b8667435bdb6939d5354a38102'),('d8f6bf34a82b65005af11e53b69e9d0'),('de59667992e5045ff98e8f0b798bb06'),('df6705732c57ce0979873bd566dd9ae'),('e8e1fcd15fc82ae2cdc057341efe4af'); UNLOCK TABLES; /*!40000 ALTER TABLE `transaction` ENABLE KEYS */; /*!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 */;