SELECT pg_catalog.setval('cashrcptmisc_cashrcptmisc_id_seq', 28, true);
---
--- TOC entry 8951 (class 0 OID 146567491)
--- Dependencies: 278 8914 9465
--- Data for Name: ccard; Type: TABLE DATA; Schema: public; Owner: admin
---
-
-ALTER TABLE ccard DISABLE TRIGGER ALL;
-
-INSERT INTO ccard (ccard_id, ccard_seq, ccard_cust_id, ccard_active, ccard_name, ccard_address1, ccard_address2, ccard_city, ccard_state, ccard_zip, ccard_country, ccard_number, ccard_debit, ccard_month_expired, ccard_year_expired, ccard_type, ccard_date_added, ccard_lastupdated, ccard_added_by_username, ccard_last_updated_by_username) VALUES (5, 10, 95, false, '\xa193fa22e7139e08744e2b086ab9bbf6', '\x4a3370cfda233487', '\x6d09a44bdb032972', '\x8e628c8e22757f48', '\x606a62a88441ccce', '\x558f7444709895a1', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, '\x5a45c679e17cc639', '\xeccde4115b93a677', 'V', '2005-12-28 12:38:34.255053', '2006-01-13 11:01:08.290173', 'jsmith', 'jsmith');
-INSERT INTO ccard (ccard_id, ccard_seq, ccard_cust_id, ccard_active, ccard_name, ccard_address1, ccard_address2, ccard_city, ccard_state, ccard_zip, ccard_country, ccard_number, ccard_debit, ccard_month_expired, ccard_year_expired, ccard_type, ccard_date_added, ccard_lastupdated, ccard_added_by_username, ccard_last_updated_by_username) VALUES (6, 20, 95, false, '\xa193fa22e7139e08744e2b086ab9bbf6', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x329e5c640fc98253', '\x51200a4f8d21e527', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, '\x5a45c679e17cc639', '\xd73802f77991ebf3', 'V', '2005-12-28 15:00:24.567592', '2008-06-12 16:33:35.455292', 'jsmith', 'jsmith');
-INSERT INTO ccard (ccard_id, ccard_seq, ccard_cust_id, ccard_active, ccard_name, ccard_address1, ccard_address2, ccard_city, ccard_state, ccard_zip, ccard_country, ccard_number, ccard_debit, ccard_month_expired, ccard_year_expired, ccard_type, ccard_date_added, ccard_lastupdated, ccard_added_by_username, ccard_last_updated_by_username) VALUES (7, 30, 95, true, '\x4e8dd44d5c61dd0636233ffe3f9e82c4', '\x9bae90ed2d4a7aadbd8fcc9801cc9c0991852a6a04744731', '\x67cea78a35d2bf07042b2bf2b936c257', '\x0c80174edff323088009d8831363b1d2', '\x329e5c640fc98253', '\xb20defeef11e27bf', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, '\x5a45c679e17cc639', '\x8f76d50339514e01', 'V', '2008-06-12 16:33:55.904522', '2008-06-12 16:33:55.904522', 'jsmith', 'jsmith');
-INSERT INTO ccard (ccard_id, ccard_seq, ccard_cust_id, ccard_active, ccard_name, ccard_address1, ccard_address2, ccard_city, ccard_state, ccard_zip, ccard_country, ccard_number, ccard_debit, ccard_month_expired, ccard_year_expired, ccard_type, ccard_date_added, ccard_lastupdated, ccard_added_by_username, ccard_last_updated_by_username) VALUES (8, 40, 95, true, '\xf7467e1ac14b6951efe53b88e40ae0b2', '\x9bae90ed2d4a7aadbd8fcc9801cc9c0991852a6a04744731', '\x67cea78a35d2bf07042b2bf2b936c257', '\x0c80174edff323088009d8831363b1d2', '\x329e5c640fc98253', '\xb20defeef11e27bf', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, '\x717c001aca9d6acb', '\xd73802f77991ebf3', 'V', '2008-10-02 09:03:48.93983', '2008-10-02 09:11:20.569342', 'jsmith', 'jsmith');
-
-
-ALTER TABLE ccard ENABLE TRIGGER ALL;
-
--
-- TOC entry 9500 (class 0 OID 0)
-- Dependencies: 481
SELECT pg_catalog.setval('ccard_ccard_id_seq', 8, true);
---
--- TOC entry 9082 (class 0 OID 146568608)
--- Dependencies: 482 9465
--- Data for Name: ccardaud; Type: TABLE DATA; Schema: public; Owner: admin
---
-
-ALTER TABLE ccardaud DISABLE TRIGGER ALL;
-
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (1, 5, NULL, 10, NULL, 95, NULL, true, NULL, '\x6cbaa91473e4d26a', NULL, '\x4a3370cfda233487', NULL, '\x6d09a44bdb032972', NULL, '\x8e628c8e22757f48', NULL, '\x606a62a88441ccce', NULL, '\x558f7444709895a1', NULL, '\xdf87001e7930c20fc49ba45b4abec021', NULL, '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', NULL, false, NULL, '\x5a45c679e17cc639', NULL, '\xeccde4115b93a677', NULL, 'V', '2005-12-28 12:38:34.255053', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (2, 5, 10, 10, 95, 95, true, true, '\x6cbaa91473e4d26a', '\xa193fa22e7139e08744e2b086ab9bbf6', '\x4a3370cfda233487', '\x4a3370cfda233487', '\x6d09a44bdb032972', '\x6d09a44bdb032972', '\x8e628c8e22757f48', '\x8e628c8e22757f48', '\x606a62a88441ccce', '\x606a62a88441ccce', '\x558f7444709895a1', '\x558f7444709895a1', '\xdf87001e7930c20fc49ba45b4abec021', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, false, '\x5a45c679e17cc639', '\x5a45c679e17cc639', '\xeccde4115b93a677', '\xeccde4115b93a677', 'V', 'V', '2005-12-28 12:40:36.077514', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (3, 5, 10, 10, 95, 95, true, true, '\xa193fa22e7139e08744e2b086ab9bbf6', '\xa193fa22e7139e08744e2b086ab9bbf6', '\x4a3370cfda233487', '\x4a3370cfda233487', '\x6d09a44bdb032972', '\x6d09a44bdb032972', '\x8e628c8e22757f48', '\x8e628c8e22757f48', '\x606a62a88441ccce', '\x606a62a88441ccce', '\x558f7444709895a1', '\x558f7444709895a1', '\xdf87001e7930c20fc49ba45b4abec021', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, false, '\x5a45c679e17cc639', '\x5a45c679e17cc639', '\xeccde4115b93a677', '\xeccde4115b93a677', 'V', 'V', '2005-12-28 12:42:20.793589', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (4, 5, 10, 10, 95, 95, true, true, '\xa193fa22e7139e08744e2b086ab9bbf6', '\xa193fa22e7139e08744e2b086ab9bbf6', '\x4a3370cfda233487', '\x4a3370cfda233487', '\x6d09a44bdb032972', '\x6d09a44bdb032972', '\x8e628c8e22757f48', '\x8e628c8e22757f48', '\x606a62a88441ccce', '\x606a62a88441ccce', '\x558f7444709895a1', '\x558f7444709895a1', '\xdf87001e7930c20fc49ba45b4abec021', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, false, '\x5a45c679e17cc639', '\x5a45c679e17cc639', '\xeccde4115b93a677', '\xeccde4115b93a677', 'V', 'V', '2005-12-28 12:45:47.388653', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (5, 5, 10, 10, 95, 95, true, true, '\xa193fa22e7139e08744e2b086ab9bbf6', '\xa193fa22e7139e08744e2b086ab9bbf6', '\x4a3370cfda233487', '\x4a3370cfda233487', '\x6d09a44bdb032972', '\x6d09a44bdb032972', '\x8e628c8e22757f48', '\x8e628c8e22757f48', '\x606a62a88441ccce', '\x606a62a88441ccce', '\x558f7444709895a1', '\x558f7444709895a1', '\xdf87001e7930c20fc49ba45b4abec021', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, false, '\x5a45c679e17cc639', '\x5a45c679e17cc639', '\xeccde4115b93a677', '\xeccde4115b93a677', 'V', 'V', '2005-12-28 12:50:46.680185', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (6, 6, NULL, 20, NULL, 95, NULL, true, NULL, '\xa193fa22e7139e08744e2b086ab9bbf6', NULL, '\x0c2c4cb15a0492bb7749eda5c22a70b7', NULL, '\x2be9b3f00610c5fd', NULL, '\x79102906ee72e12b9aeee62e181d5fb1', NULL, '\x329e5c640fc98253', NULL, '\x51200a4f8d21e527', NULL, '\xdf87001e7930c20fc49ba45b4abec021', NULL, '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', NULL, false, NULL, '\x5a45c679e17cc639', NULL, '\xeccde4115b93a677', NULL, 'V', '2005-12-28 15:00:24.567592', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (7, 6, 20, 20, 95, 95, true, true, '\xa193fa22e7139e08744e2b086ab9bbf6', '\xa193fa22e7139e08744e2b086ab9bbf6', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x2be9b3f00610c5fd', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x329e5c640fc98253', '\x329e5c640fc98253', '\x51200a4f8d21e527', '\x51200a4f8d21e527', '\xdf87001e7930c20fc49ba45b4abec021', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, false, '\x5a45c679e17cc639', '\x5a45c679e17cc639', '\xeccde4115b93a677', '\xeccde4115b93a677', 'V', 'V', '2005-12-28 15:01:17.664311', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (8, 5, 10, 10, 95, 95, true, false, '\xa193fa22e7139e08744e2b086ab9bbf6', '\xa193fa22e7139e08744e2b086ab9bbf6', '\x4a3370cfda233487', '\x4a3370cfda233487', '\x6d09a44bdb032972', '\x6d09a44bdb032972', '\x8e628c8e22757f48', '\x8e628c8e22757f48', '\x606a62a88441ccce', '\x606a62a88441ccce', '\x558f7444709895a1', '\x558f7444709895a1', '\xdf87001e7930c20fc49ba45b4abec021', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, false, '\x5a45c679e17cc639', '\x5a45c679e17cc639', '\xeccde4115b93a677', '\xeccde4115b93a677', 'V', 'V', '2006-01-13 11:01:08.290173', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (9, 6, 20, 20, 95, 95, true, true, '\xa193fa22e7139e08744e2b086ab9bbf6', '\xa193fa22e7139e08744e2b086ab9bbf6', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x329e5c640fc98253', '\x329e5c640fc98253', '\x51200a4f8d21e527', '\x51200a4f8d21e527', '\xdf87001e7930c20fc49ba45b4abec021', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, false, '\x5a45c679e17cc639', '\x5a45c679e17cc639', '\xeccde4115b93a677', '\xeccde4115b93a677', 'V', 'V', '2006-01-13 11:01:30.327048', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (10, 6, 20, 20, 95, 95, true, false, '\xa193fa22e7139e08744e2b086ab9bbf6', '\xa193fa22e7139e08744e2b086ab9bbf6', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x329e5c640fc98253', '\x329e5c640fc98253', '\x51200a4f8d21e527', '\x51200a4f8d21e527', '\xdf87001e7930c20fc49ba45b4abec021', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, false, '\x5a45c679e17cc639', '\x5a45c679e17cc639', '\xeccde4115b93a677', '\xeccde4115b93a677', 'V', 'V', '2008-03-04 13:55:01.303273', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (11, 6, 20, 20, 95, 95, false, true, '\xa193fa22e7139e08744e2b086ab9bbf6', '\xa193fa22e7139e08744e2b086ab9bbf6', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x329e5c640fc98253', '\x329e5c640fc98253', '\x51200a4f8d21e527', '\x51200a4f8d21e527', '\xdf87001e7930c20fc49ba45b4abec021', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, false, '\x5a45c679e17cc639', '\x5a45c679e17cc639', '\xeccde4115b93a677', '\xd73802f77991ebf3', 'V', 'V', '2008-06-12 15:58:13.904141', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (12, 6, 20, 20, 95, 95, true, true, '\xa193fa22e7139e08744e2b086ab9bbf6', '\xa193fa22e7139e08744e2b086ab9bbf6', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x329e5c640fc98253', '\x329e5c640fc98253', '\x51200a4f8d21e527', '\x51200a4f8d21e527', '\xdf87001e7930c20fc49ba45b4abec021', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, false, '\x5a45c679e17cc639', '\x5a45c679e17cc639', '\xd73802f77991ebf3', '\xd73802f77991ebf3', 'V', 'V', '2008-06-12 16:16:50.490189', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (13, 6, 20, 20, 95, 95, true, true, '\xa193fa22e7139e08744e2b086ab9bbf6', '\xa193fa22e7139e08744e2b086ab9bbf6', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x329e5c640fc98253', '\x329e5c640fc98253', '\x51200a4f8d21e527', '\x51200a4f8d21e527', '\xdf87001e7930c20fc49ba45b4abec021', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, false, '\x5a45c679e17cc639', '\x5a45c679e17cc639', '\xd73802f77991ebf3', '\xd73802f77991ebf3', 'V', 'V', '2008-06-12 16:16:50.590829', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (14, 6, 20, 20, 95, 95, true, false, '\xa193fa22e7139e08744e2b086ab9bbf6', '\xa193fa22e7139e08744e2b086ab9bbf6', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x0c2c4cb15a0492bb7749eda5c22a70b7', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x79102906ee72e12b9aeee62e181d5fb1', '\x329e5c640fc98253', '\x329e5c640fc98253', '\x51200a4f8d21e527', '\x51200a4f8d21e527', '\xdf87001e7930c20fc49ba45b4abec021', '\xdf87001e7930c20fc49ba45b4abec021', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, false, '\x5a45c679e17cc639', '\x5a45c679e17cc639', '\xd73802f77991ebf3', '\xd73802f77991ebf3', 'V', 'V', '2008-06-12 16:33:35.455292', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (15, 7, NULL, 30, NULL, 95, NULL, true, NULL, '\x4e8dd44d5c61dd0636233ffe3f9e82c4', NULL, '\x9bae90ed2d4a7aadbd8fcc9801cc9c0991852a6a04744731', NULL, '\x67cea78a35d2bf07042b2bf2b936c257', NULL, '\x0c80174edff323088009d8831363b1d2', NULL, '\x329e5c640fc98253', NULL, '\xb20defeef11e27bf', NULL, '\xdf87001e7930c20fc49ba45b4abec021', NULL, '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', NULL, false, NULL, '\x5a45c679e17cc639', NULL, '\x8f76d50339514e01', NULL, 'V', '2008-06-12 16:33:55.904522', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (16, 8, NULL, 40, NULL, 95, NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, NULL, NULL, NULL, NULL, NULL, 'V', '2008-10-02 09:03:48.93983', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (17, 8, 40, 40, 95, 95, true, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, false, NULL, NULL, NULL, NULL, 'V', 'V', '2008-10-02 09:06:42.921758', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (18, 8, 40, 40, 95, 95, true, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, false, NULL, NULL, NULL, NULL, 'V', 'V', '2008-10-02 09:06:42.955925', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (19, 8, 40, 40, 95, 95, true, true, NULL, '\xf7467e1ac14b6951efe53b88e40ae0b2', NULL, '\x9bae90ed2d4a7aadbd8fcc9801cc9c0991852a6a04744731', NULL, '\x67cea78a35d2bf07042b2bf2b936c257', NULL, '\x0c80174edff323088009d8831363b1d2', NULL, '\x329e5c640fc98253', NULL, '\xb20defeef11e27bf', NULL, '\xdf87001e7930c20fc49ba45b4abec021', NULL, NULL, false, false, NULL, '\x717c001aca9d6acb', NULL, '\xd73802f77991ebf3', 'V', 'V', '2008-10-02 09:11:20.508258', 'jsmith');
-INSERT INTO ccardaud (ccardaud_id, ccardaud_ccard_id, ccardaud_ccard_seq_old, ccardaud_ccard_seq_new, ccardaud_ccard_cust_id_old, ccardaud_ccard_cust_id_new, ccardaud_ccard_active_old, ccardaud_ccard_active_new, ccardaud_ccard_name_old, ccardaud_ccard_name_new, ccardaud_ccard_address1_old, ccardaud_ccard_address1_new, ccardaud_ccard_address2_old, ccardaud_ccard_address2_new, ccardaud_ccard_city_old, ccardaud_ccard_city_new, ccardaud_ccard_state_old, ccardaud_ccard_state_new, ccardaud_ccard_zip_old, ccardaud_ccard_zip_new, ccardaud_ccard_country_old, ccardaud_ccard_country_new, ccardaud_ccard_number_old, ccardaud_ccard_number_new, ccardaud_ccard_debit_old, ccardaud_ccard_debit_new, ccardaud_ccard_month_expired_old, ccardaud_ccard_month_expired_new, ccardaud_ccard_year_expired_old, ccardaud_ccard_year_expired_new, ccardaud_ccard_type_old, ccardaud_ccard_type_new, ccardaud_ccard_last_updated, ccardaud_ccard_last_updated_by_username) VALUES (20, 8, 40, 40, 95, 95, true, true, '\xf7467e1ac14b6951efe53b88e40ae0b2', '\xf7467e1ac14b6951efe53b88e40ae0b2', '\x9bae90ed2d4a7aadbd8fcc9801cc9c0991852a6a04744731', '\x9bae90ed2d4a7aadbd8fcc9801cc9c0991852a6a04744731', '\x67cea78a35d2bf07042b2bf2b936c257', '\x67cea78a35d2bf07042b2bf2b936c257', '\x0c80174edff323088009d8831363b1d2', '\x0c80174edff323088009d8831363b1d2', '\x329e5c640fc98253', '\x329e5c640fc98253', '\xb20defeef11e27bf', '\xb20defeef11e27bf', '\xdf87001e7930c20fc49ba45b4abec021', '\xdf87001e7930c20fc49ba45b4abec021', NULL, '\x976aed50e78c886079d2aeca356c267e275bc8f342505cee', false, false, '\x717c001aca9d6acb', '\x717c001aca9d6acb', '\xd73802f77991ebf3', '\xd73802f77991ebf3', 'V', 'V', '2008-10-02 09:11:20.569342', 'jsmith');
-
-
-ALTER TABLE ccardaud ENABLE TRIGGER ALL;
-
--
-- TOC entry 9501 (class 0 OID 0)
-- Dependencies: 483
SELECT pg_catalog.setval('ccbank_ccbank_id_seq', 5, true);
---
--- TOC entry 9086 (class 0 OID 146568627)
--- Dependencies: 486 9465
--- Data for Name: ccpay; Type: TABLE DATA; Schema: public; Owner: admin
---
-
-ALTER TABLE ccpay DISABLE TRIGGER ALL;
-
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (16, 6, 95, 104.90, true, 'D', 'C', 'A', '40000', 1, '', '40000-1', 'SGS-005000: The server encountered a database error.', 'DECLINED', '', '', '2005-12-28 14:10:03', '', '', NULL, NULL, 0, '2005-12-28 16:49:52.505285', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (20, 6, 95, 997.50, false, 'C', 'C', 'C', '50008', 1, 'NNN', '50008-1', '', 'APPROVED', '1234560003192121:NNN :100009309292:', 'APPROVED', '2006-01-09 07:02:01', '0003192121', '1136815015', NULL, NULL, 0, '2006-01-09 09:54:02.774859', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (17, 6, 95, 104.90, false, 'C', 'C', 'A', '40000', 2, 'NNN', '40000-2', '', 'APPROVED', '1234560003031755:NNN :100009278151:', 'APPROVED', '2005-12-28 14:16:06', '0003031755', '1135804266', NULL, NULL, 0, '2005-12-28 16:56:11.906559', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (18, 6, 95, 9.99, false, 'D', 'C', 'C', '40000', 3, '', '40000-3', 'SGS-002300: This transaction was previously approved.', 'DECLINED', '', 'DUPLICATE APPROVED', '2005-12-28 14:19:36', '', '1135804476', NULL, NULL, 0, '2005-12-28 16:59:18.283679', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (19, 6, 95, 114.89, false, 'C', 'C', 'C', '40000', 4, 'NNN', '40000-4', '', 'APPROVED', '1234560003031809:NNN :100009278170:', 'APPROVED', '2005-12-28 14:22:56', '0003031809', '1135804676', NULL, NULL, 0, '2005-12-28 17:02:37.384347', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (22, 6, 95, 104.90, false, 'D', 'C', 'C', '50009', 1, '', '50009-1', 'SGS-005003: The order already exists in the database.', 'DUPLICATE', '', '', '2006-01-09 07:54:07', '', '', NULL, NULL, 0, '2006-01-09 10:46:12.764421', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (24, 6, 95, 104.90, false, 'C', 'C', 'C', '50031', 1, 'NNN', '50031-1', '', 'APPROVED', '1234560003192673:NNN :100009309363:', 'APPROVED', '2006-01-09 08:00:54', '0003192673', '1136818549', NULL, NULL, 0, '2006-01-09 10:52:56.014269', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (23, 6, 95, 104.90, false, 'C', 'C', 'A', '50009', 2, 'NNN', '50009-2', '', 'APPROVED', '1234560003192610:NNN :100009309346:', 'APPROVED', '2006-01-09 07:54:28', '0003192610', '1136818162', NULL, NULL, 0, '2006-01-09 10:46:29.418547', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (25, 6, 95, 997.50, true, 'X', 'C', 'A', '50043', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2006-01-13 11:02:53.762333', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (26, 6, 95, 997.50, true, 'X', 'C', 'A', '50043', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2006-01-13 11:04:04.523402', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (27, 6, 95, 997.50, false, 'X', 'C', 'C', '50043', 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2006-01-13 11:05:13.422812', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (28, 6, 95, 997.50, false, 'C', 'C', 'A', '50043', 4, 'NNN', '50043-4', '', 'APPROVED', '1234560003216021:NNN :100009323145:', 'APPROVED', '2006-01-13 08:59:47', '0003216021', '1137167679', NULL, NULL, 0, '2006-01-13 11:51:43.930367', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (29, 6, 95, 103.86, false, 'C', 'C', 'A', '40005', 1, 'NNN', '40005-1', '', 'APPROVED', '1234560003216040:NNN :100009323812:', 'APPROVED', '2006-01-13 10:49:03', '0003216040', '1137174236', NULL, NULL, 0, '2006-01-13 12:48:58.008', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (30, 6, 95, 103.86, false, 'C', 'C', 'C', '50045', 1, 'NNN', '50045-1', '', 'APPROVED', '1234560003216058:NNN :100009324195:', 'APPROVED', '2006-01-13 11:36:34', '0003216058', '1137177086', NULL, NULL, 0, '2006-01-13 13:36:28.387', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (31, 6, 95, 997.50, false, 'C', 'C', 'C', '50046', 1, 'NNN', '50046-1', '', 'APPROVED', '1234560003216072:NNN :100009325017:', 'APPROVED', '2006-01-13 13:09:36', '0003216072', '1137182667', NULL, NULL, 0, '2006-01-13 15:09:30.383', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (33, 6, 95, 500.00, false, 'D', 'C', 'C', '50047', 1, '', '50047-1', 'SGS-005003: The order already exists in the database.', 'DUPLICATE', '', '', '2006-01-30 09:07:58', '', '', NULL, NULL, 0, '2006-01-30 11:59:39.538476', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (34, 6, 95, 500.00, false, 'C', 'C', 'C', '50148', 1, 'NNN', '50148-1', '', 'APPROVED', '1234560003353787:NNN :100009404491:', 'APPROVED', '2006-01-30 09:14:21', '0003353787', '1138637345', NULL, NULL, 0, '2006-01-30 12:06:01.556067', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (35, 6, 95, 500.00, false, 'X', 'C', 'C', '50149', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2006-01-30 16:36:06.281219', 'jsmith', 1, NULL);
-INSERT INTO ccpay (ccpay_id, ccpay_ccard_id, ccpay_cust_id, ccpay_amount, ccpay_auth, ccpay_status, ccpay_type, ccpay_auth_charge, ccpay_order_number, ccpay_order_number_seq, ccpay_r_avs, ccpay_r_ordernum, ccpay_r_error, ccpay_r_approved, ccpay_r_code, ccpay_r_message, ccpay_yp_r_time, ccpay_r_ref, ccpay_yp_r_tdate, ccpay_r_tax, ccpay_r_shipping, ccpay_yp_r_score, ccpay_transaction_datetime, ccpay_by_username, ccpay_curr_id, ccpay_ccpay_id) VALUES (54, 7, 95, 1000.00, false, 'C', 'C', 'C', '199', 1, 'passed', '199', NULL, 'APPROVED', '123111', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2008-10-02 09:13:21.509805', 'jsmith', 1, NULL);
-
-
-ALTER TABLE ccpay ENABLE TRIGGER ALL;
-
--
-- TOC entry 9503 (class 0 OID 0)
-- Dependencies: 487
projects / xtuple / commitdiff