INSERT INTO `products` (`productid`, `prefix`, `name`, `packtype`) VALUES
(1, 'ao', 'AR-AP Settlements', 0),
(2, 'cw', 'CashWorks', 0);

INSERT INTO `currency` (`currid`, `currname`, `symbol`, `decimals`, `symbolpos`, `thoussep`, `decsep`, `longdesc`) VALUES
('EUR', 'EUR', '€', 2, 0, ',', '.', 'Euros'),
('USD', 'USD', '$', 2, 0, ',', '.', 'US Dollars');

INSERT INTO `identity_fixture` (`value`) VALUES
('00123'),
(' leading ');

INSERT INTO `partners` (`login`, `password`, `level`, `fname`, `lname`, `email`, `email1`, `email2`, `phone`, `company`, `caddress`, `city`, `state`, `zip`, `country`, `status`, `products`, `mailing`, `beta`, `nickname`, `joindate`, `jointime`, `cwebsite`, `terr_id`, `authtoken`, `frommobile`, `last_updated_date`, `registered_in_crm`, `crm_registration_date`, `crm_id`, `next_updated_date`, `uadownload`, `priceupdates`, `apprpriceupd`) VALUES
('dumpbp', 'plain', 1, 'Dump', 'Partner', 'dumpbp@firm.example', '', '', '1', 'Co', 'Addr', 'City', 'ST', '1', 'Canada', 'Solution Provider', ',1,', 'Yes', NULL, NULL, 20220113, 11642, NULL, NULL, 'TOKEN', NULL, NULL, 3, NULL, NULL, '0000-00-00 00:00:00', '', 0, NULL);