Database Change Log

Database changes are disabled.
Database change logging is enabled.
A maximum of 1000 log entries are allowed. Older entries will be deleted to maintain this maximum.
id thistime username cmd error
21 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_mbreqsdeeds` (`id`, `deeds_id`, `mbreqs_id`) VALUES (1, 1, 5780), (2, 1, 5781), (3, 1, 5782), (4, 1, 5823), (5, 2, 5785), (6, 3, 5786), (7, 4, 5787), (8, 5, 5788), (9, 6, 5789), (10, 7, 5790), (11, 8, 5791), (12, 9, 5792);
20 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_ranksreqsequiv` (`id`, `scouts_id`, `from_ranksreqs_id`, `to_ranksreqs_id`) VALUES (1, 1, 790, 881), (2, 1, 796, 887);
19 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_ranksreqsdeeds` (`id`, `deeds_id`, `ranksreqs_id`) VALUES (1, 1, 870), (2, 1, 871), (3, 1, 872), (4, 1, 873), (5, 1, 874), (6, 1, 875), (7, 1, 876), (8, 1, 899), (9, 2, 878), (10, 3, 879), (11, 4, 880), (12, 5, 790), (13, 6, 882), (14, 7, 883), (15, 8, 884), (16, 9, 885), (17, 11, 886), (18, 11, 900), (19, 11, 901), (20, 11, 902), (21, 11, 903), (22, 11, 904), (23, 11, 905), (24, 11, 906), (25, 11, 907), (26, 11, 908), (27, 11, 909), (28, 11, 910), (29, 11, 911), (30,1,500), (31,1,501), (32,1,502), (33,1,503), (34,1,504), (35,1,505), (36,1,506), (37,1,507), (38,1,508), (39,1,509), (40,15,870), (41,15,871), (42,15,872), (43,15,873), (44,15,874), (45,15,875), (46,15,876), (47,15,877), (48,15,878), (49,15,879), (50,15,880), (51,15,881), (52,15,882), (53,15,883), (54,15,884), (55,15,885), (56,15,886), (57,15,887), (58,15,888), (59,16,890), (60,16,891), (61,16,892), (62,16,893), (63,16,894), (64,16,895), (65,16,896), (66,16,897), (67,16,898), (68,16,899), (69,16,900), (70,16,901), (71,16,902), (72,16,903), (73,16,904), (74,16,905), (75,16,906), (76,16,907), (77,16,908), (78,16,909), (79,16,910), (80,16,911), (81,16,912), (82,16,913), (83,16,914), (84,17,920), (85,17,921), (86,17,922), (87,17,923), (88,17,924), (89,17,925), (90,17,926), (91,17,927), (92,17,928), (93,17,929), (94,17,930), (95,17,931), (96,17,932), (97,17,933), (98,17,934), (99,17,935), (100,17,936), (101,17,937), (102,17,938), (103,17,939), (104,17,940), (105,17,941), (106,17,942), (107,17,943), (108,18,950), (109,18,951), (110,18,952), (111,18,953), (112,18,954), (113,18,955), (114,18,956), (115,19,990), (116,19,991), (117,19,992), (118,19,993), (119,19,994), (120,19,995), (121,19,996), (122,19,997), (123,19,998), (124,19,999), (125,19,1000), (126,19,1001), (127,19,1002), (128,19,1003), (129,20,980), (130,20,981), (131,20,982), (132,20,983), (133,20,984), (134,20,985), (135,20,986), (136, 5,796);
18 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_adultsdeeds` (`id`, `deeds_id`, `adults_id`) VALUES (1, 1, 1), (2, 1, 2), (3, 1, 3), (4, 2, 4), (5, 2, 5), (6, 2, 6), (7, 3, 7), (8, 3, 8), (9, 3, 9), (10, 4, 10), (11, 4, 11), (12, 4, 12), (13, 5, 13), (14, 5, 14), (15, 5, 15), (16, 6, 16), (17, 6, 17), (18, 6, 18), (19, 7, 19), (20, 7, 20), (21, 7, 21), (22, 8, 22), (23, 8, 23), (24, 8, 24), (25, 9, 25), (26, 9, 26), (27, 9, 27), (28, 10, 1), (29, 10, 2), (30, 10, 3), (31, 11, 4), (32, 11, 5), (33, 11, 6);
17 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_scoutsdeeds` (`id`, `deeds_id`, `scouts_id`) VALUES (1, 1, 1), (2, 1, 2), (3, 1, 3), (4, 1, 4), (5, 1, 5), (6, 1, 6), (7, 1, 7), (8, 1, 8), (9, 1, 9), (10, 1, 10), (11, 2, 11), (12, 3, 1), (13, 3, 2), (14, 3, 3), (15, 3, 4), (16, 3, 5), (17, 3, 6), (18, 3, 7), (19, 3, 8), (20, 4, 9), (21, 4, 10), (22, 4, 11), (23, 5, 1), (24, 5, 2), (25, 5, 3), (26, 5, 4), (27, 5, 5), (28, 5, 6), (29, 6, 4), (30, 6, 5), (31, 6, 6), (32, 6, 7), (33, 6, 8), (34, 6, 9), (35, 7, 10), (36, 7, 11), (37, 7, 12), (38, 8, 13), (39, 8, 14), (40, 8, 15), (41, 9, 16), (42, 9, 17), (43, 9, 18), (44, 10, 19), (45, 10, 20), (46, 10, 21), (47, 11, 22), (48, 11, 23), (49, 11, 24), (50, 12, 25), (51, 12, 26), (52, 12, 1), (53, 13, 2), (54, 13, 3), (55, 13, 4), (56, 13, 5), (57, 13, 6), (58, 13, 7), (59, 11, 1), (60, 11, 10), (61, 1, 11), (62, 1, 12), (63, 1, 13), (64, 1, 14), (65, 1, 15), (66, 1, 16), (67, 1, 17), (68, 1, 18), (69, 1, 22), (70, 1, 23), (71, 1, 24), (72,15,2), (73,15,3), (74,15,4), (75,15,5), (76,15,6), (77,15,7), (78,15,9), (79,15,10), (80,15,11), (81,15,12), (82,15,13), (83,15,15), (84,15,16), (85,15,17), (86,15,18), (89,15,22), (90,15,23), (91,15,24), (92,15,25), (93,15,26), (94,16,3), (95,16,4), (96,16,5), (97,16,6), (98,16,7), (99,16,10), (100,16,11), (101,16,12), (102,16,13), (103,16,16), (104,16,17), (105,16,18), (108,16,23), (109,16,24), (110,16,25), (111,16,26), (112,17,4), (113,17,5), (114,17,6), (115,17,7), (116,17,11), (117,17,12), (118,17,13), (119,17,17), (120,17,18), (123,17,24), (124,17,25), (125,17,26), (126,18,5), (127,18,6), (128,18,7), (129,18,12), (130,18,13), (131,18,18), (134,18,25), (135,18,26), (136,19,6), (137,19,7), (138,19,13), (141,19,26), (142,20,7);
16 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_scoutsawards` (`id`, `awards_id`, `ranks_id`, `meritbadges_id`, `scouts_id`, `date_earned`, `date_purchased`, `date_awarded`) VALUES (1, NULL, 100, NULL, 1, '2007-11-01', '2007-11-02', '2007-11-03'), (2, NULL, 100, NULL, 2, '2007-11-01', '2007-11-02', '2007-11-03'), (3, NULL, 100, NULL, 3, '2007-11-01', '2007-11-02', '2007-11-03'), (4, NULL, 100, NULL, 4, '2007-11-01', '2007-11-02', '2007-11-03'), (5, NULL, 100, NULL, 5, '2007-11-01', '2007-11-02', '2007-11-03'), (6, NULL, 100, NULL, 6, '2007-11-01', '2007-11-02', '2007-11-03'), (7, NULL, 100, NULL, 7, '2007-11-01', '2007-11-02', '2007-11-03'), (8, NULL, 100, NULL, 8, '2007-11-01', '2007-11-02', '2007-11-03'), (9, NULL, 100, NULL, 9, '2007-11-01', '2007-11-02', '2007-11-03'), (10, NULL, 100, NULL, 10, '2007-11-01', '2007-11-02', '2007-11-03'), (11, NULL, 100, NULL, 11, '2007-11-01', '2007-11-02', '2007-11-03'), (12, NULL, 100, NULL, 12, '2007-11-01', '2007-11-02', '2007-11-03'), (13, NULL, 100, NULL, 13, '2007-11-01', '2007-11-02', '2007-11-03'), (14, NULL, 100, NULL, 14, '2007-11-01', '2007-11-02', '2007-11-03'), (15, NULL, 100, NULL, 15, '2007-11-01', '2007-11-02', '2007-11-03'), (16, NULL, 100, NULL, 16, '2007-11-01', '2007-11-02', '2007-11-03'), (17, NULL, 100, NULL, 17, '2007-11-01', '2007-11-02', '2007-11-03'), (18, NULL, 100, NULL, 18, '2007-11-01', '2007-11-02', '2007-11-03'), (19, NULL, 100, NULL, 22, '2007-11-01', '2007-11-02', '2007-11-03'), (20, NULL, 100, NULL, 23, '2007-11-01', '2007-11-02', '2007-11-03'), (21, NULL, 100, NULL, 24, '2007-11-01', '2007-11-02', '2007-11-03'), (22, NULL, 100, NULL, 25, '2007-11-01', '2007-11-02', '2007-11-03'), (23, NULL, 100, NULL, 26, '2007-11-01', '2007-11-02', '2007-11-03'), (24, NULL, 170, NULL, 2, '2007-11-01', '2007-11-02', '2007-11-03'), (25, NULL, 170, NULL, 3, '2007-11-01', '2007-11-02', '2007-11-03'), (26, NULL, 170, NULL, 4, '2007-11-01', '2007-11-02', '2007-11-03'), (27, NULL, 170, NULL, 5, '2007-11-01', '2007-11-02', '2007-11-03'), (28, NULL, 170, NULL, 6
15 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_awards` (`id`, `name`) VALUES (1, 'Totin Chip'), (2, 'Fireman Chit'), (3, '50 Miler'), (4, 'World Conservation');
14 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_deeds` (`id`, `date`, `events_id`, `description`, `nights_camped`, `miles_hiked`, `hours_service`, `is_activity`, `verified_by`, `verified_date`) VALUES (1, '2007-01-03', 1, 'Camped two nights', 2, 0, 0, 'Y', 2, '2007-01-11'), (2, '2007-01-03', 1, 'Camped one night', 1, 0, 0, 'Y', 2, '2007-01-11'), (3, '2007-01-03', 1, 'Five mile hike', 0, 5.5, 0, 'N', 2, '2007-01-11'), (4, '2007-01-03', 1, 'Service project', 1, 0, 2, 'N', 2, '2007-01-11'), (5, '2007-02-02', 2, 'deed 1', 2, 5, 2, 'Y', 2, '2007-02-11'), (6, '2007-03-02', 3, 'deed 2', 2, 5, 2, 'Y', 2, '2007-03-11'), (7, '2007-04-02', 4, 'deed 3', 2, 5, 2, 'Y', 2, '2007-04-11'), (8, '2007-05-02', 5, 'deed 4', 2, 5, 2, 'Y', 2, '2007-05-11'), (9, '2007-06-02', 6, 'deed 5', 2, 5, 2, 'Y', 2, '2007-06-11'), (10, '2007-07-02', 7, 'deed 6', 2, 5, 2, 'Y', 2, '2007-07-11'), (11, '2007-08-02', 8, 'deed 7', 2, 5, 2, 'Y', 2, '2007-08-11'), (12, '2007-09-02', 9, 'deed 8', 2, 5, 2, 'Y', 2, '2007-09-11'), (13, '2007-10-02', 10, 'deed 9', 2, 5, 1, 'Y', NULL, NULL), (14, '2007-11-01', 11, 'advancement', 0, 0, 0, 'Y', 2, '2007-11-25'), (15, '2008-01-01', 12, 'Tenderfoot', 0, 0, 0, 'Y', 2, '2008-09-09'), (16, '2008-02-01', 13, '2nd Class', 0, 0, 0, 'Y', 2, '2008-09-09'), (17, '2008-03-01', 14, '1st Class', 0, 0, 0, 'Y', 2, '2008-09-09'), (18, '2008-04-01', 15, 'Star', 0, 0, 0, 'Y', 2, '2008-09-09'), (19, '2008-05-01', 16, 'Life', 0, 0, 0, 'Y', 2, '2008-09-09'), (20, '2008-06-01', 17, 'Eagle', 0, 0, 0, 'Y', 2, '2008-09-09');
13 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_events` (`id`, `description`, `date`, `end_date`) VALUES (1, 'campout 1', '2007-01-01', '2007-01-03'), (2, 'campout 2', '2007-02-01', '2007-02-03'), (3, 'campout 3', '2007-03-01', '2007-03-03'), (4, 'campout 4', '2007-04-01', '2007-04-03'), (5, 'campout 5', '2007-05-01', '2007-05-03'), (6, 'campout 6', '2007-06-01', '2007-06-03'), (7, 'campout 7', '2007-07-01', '2007-07-03'), (8, 'campout 8', '2007-08-01', '2007-08-03'), (9, 'campout 9', '2007-09-01', '2007-09-03'), (10, '2007 Summer Camp', '2007-10-01', '2007-10-03'), (11, 'advancement weekend', '2007-11-01', NULL), (12, 'Tenderfoot advancement', '2008-01-01', '2008-01-03'), (13, '2nd Class advancement', '2008-02-01', '2008-02-03'), (14, '1st Class advancement', '2008-03-01', '2008-03-03'), (15, 'Star advancement', '2008-04-01', '2008-04-03'), (16, 'Life advancement', '2008-05-01', '2008-05-03'), (17, 'Eagle advancement', '2008-06-01', '2008-06-03');
12 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_scoutsadults` (`id`, `scouts_id`, `adults_id`, `relation`) VALUES (1, 1, 1, 'father'), (2, 1, 2, 'mother'), (3, 2, 3, 'father'), (4, 3, 4, 'mother'), (5, 4, 5, 'father'), (6, 5, 6, 'mother'), (7, 6, 7, 'father'), (8, 7, 8, 'mother'), (9, 8, 9, 'father'), (10, 9, 10, 'mother'), (11, 10, 11, 'father'), (12, 11, 12, 'mother'), (13, 12, 13, 'father'), (14, 13, 14, 'mother'), (15, 14, 15, 'father'), (16, 15, 16, 'mother'), (17, 16, 17, 'father'), (18, 17, 18, 'mother'), (19, 18, 19, 'father'), (20, 19, 20, 'mother'), (21, 20, 21, 'father'), (22, 21, 22, 'mother'), (23, 22, 23, 'father'), (24, 23, 24, 'mother'), (25, 24, 25, 'father'), (26, 25, 26, 'mother'), (27, 26, 27, 'father');
11 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_adultstrainings` (`id`, `adults_id`, `description`, `date_valid`, `date_expired`) VALUES (1, 1, 'Youth Protection', '2006-01-01', NULL), (2, 1, 'Safety Afloat', '2006-01-02', NULL), (3, 2, 'Youth Protection', '2006-01-03', NULL), (4, 3, 'Youth Protection', '2006-01-04', NULL), (5, 4, 'Youth Protection', '2006-01-05', NULL), (6, 5, 'Youth Protection', '2006-01-06', NULL), (7, 6, 'Youth Protection', '2006-01-07', NULL), (8, 7, 'Youth Protection', '2006-01-08', NULL), (9, 8, 'Youth Protection', '2006-01-09', NULL), (10, 9, 'Youth Protection', '2006-01-10', NULL), (11, 10, 'Youth Protection', '2006-01-11', NULL), (12, 11, 'Youth Protection', '2006-01-12', NULL), (13, 12, 'Youth Protection', '2006-01-13', NULL), (14, 13, 'Youth Protection', '2006-01-14', NULL), (15, 14, 'Youth Protection', '2006-01-15', NULL), (16, 15, 'Youth Protection', '2006-01-16', NULL), (17, 16, 'Youth Protection', '2006-01-17', NULL), (18, 17, 'Youth Protection', '2006-01-18', NULL), (19, 18, 'Youth Protection', '2006-01-19', NULL), (20, 19, 'Youth Protection', '2006-01-20', NULL), (21, 20, 'Youth Protection', '2006-01-21', NULL), (22, 21, 'Youth Protection', '2006-01-22', NULL), (23, 22, 'Youth Protection', '2006-01-23', NULL), (24, 23, 'Youth Protection', '2006-01-24', NULL), (25, 24, 'Youth Protection', '2006-01-25', NULL), (26, 25, 'Youth Protection', '2006-01-26', NULL), (27, 26, 'Youth Protection', '2006-01-27', NULL), (28, 27, 'Youth Protection', '2006-01-28', NULL);
10 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_adultsphones` (`id`, `adults_id`, `number`, `description`) VALUES (1, 1, '800-555-0001', 'home'), (2, 1, '800-555-0101', 'cell'), (3, 2, '800-555-0201', 'home'), (4, 3, '800-555-0002', 'cell'), (5, 4, '800-555-0003', 'home'), (6, 5, '800-555-0004', 'cell'), (7, 6, '800-555-0005', 'home'), (8, 7, '800-555-0006', 'cell'), (9, 8, '800-555-0007', 'home'), (10, 9, '800-555-0008', 'cell'), (11, 10, '800-555-0009', 'home'), (12, 11, '800-555-0010', 'cell'), (13, 12, '800-555-0011', 'home'), (14, 13, '800-555-0012', 'cell'), (15, 14, '800-555-0013', 'home'), (16, 15, '800-555-0014', 'cell'), (17, 16, '800-555-0015', 'home'), (18, 17, '800-555-0016', 'cell'), (19, 18, '800-555-0017', 'home'), (20, 19, '800-555-0018', 'cell'), (21, 20, '800-555-0019', 'home'), (22, 21, '800-555-0020', 'cell'), (23, 22, '800-555-0021', 'home'), (24, 23, '800-555-0022', 'cell'), (25, 24, '800-555-0023', 'home'), (26, 25, '800-555-0024', 'cell'), (27, 26, '800-555-0025', 'home'), (28, 27, '800-555-0026', 'cell');
9 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_adultsaccounts` (`id`, `adults_id`, `accounts_id`, `description`, `amount`, `date`) VALUES (1, 1, 1, 'first deposit', 20.00, '2007-01-01'), (2, 1, 2, 'deposit', 50.00, '2007-01-01'), (3, 2, 1, 'deposit', 20.00, '2007-02-01'), (4, 3, 1, 'deposit', 20.00, '2007-03-01'), (5, 4, 1, 'deposit', 20.00, '2007-04-01'), (6, 5, 1, 'deposit', 20.00, '2007-05-01'), (7, 6, 1, 'deposit', 20.00, '2007-06-01'), (8, 7, 1, 'deposit', 20.00, '2007-07-01'), (9, 8, 1, 'deposit', 20.00, '2007-08-01'), (10, 9, 1, 'deposit', 20.00, '2007-09-01'), (11, 10, 1, 'deposit', 20.00, '2007-10-01');
8 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_adults` (`id`, `user_id`, `is_leader`, `name_family`, `name_given`, `name_middle`, `address1`, `address2`, `city`, `state`, `zip`, `email`, `is_oa`) VALUES (1, 1001, 'Y', 'Astute', 'Aaron', 'A', '1501 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'a1@home.com', 'N'), (2, 1002, 'Y', 'Astute', 'Abigail', 'A', '1551 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'a2@home.com', 'N'), (3, 1003, 'Y', 'Brimstone', 'Bob', 'B', '1502 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'b@home.com', 'N'), (4, 1004, 'Y', 'Caveat', 'Christine', 'C', '1503 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'c@home.com', 'N'), (5, 1005, 'Y', 'Durable', 'Doug', 'D', '1504 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'd@home.com', 'N'), (6, 1006, 'Y', 'Emulate', 'Evelyn', 'E', '1505 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'e@home.com', 'N'), (7, 1007, 'Y', 'Fulminate', 'Frank', 'F', '1506 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'f@home.com', 'N'), (8, 1008, 'Y', 'Gimbal', 'Gail', 'G', '1507 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'g@home.com', 'N'), (9, 1009, 'Y', 'Hubrus', 'Hank', 'H', '1508 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'h@home.com', 'N'), (10, 1010, 'Y', 'Indignant', 'Iris', 'I', '1509 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'i@home.com', 'N'), (11, 1011, 'N', 'Jubilant', 'Jack', 'J', '1510 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'j@home.com', 'N'), (12, 1012, 'N', 'Keystone', 'Karla', 'K', '1511 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'k@home.com', 'N'), (13, 1013, 'Y', 'Lambaste', 'Lon', 'L', '1512 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'l@home.com', 'N'), (14, 1014, 'N', 'Malcontent', 'Mary', 'M', '1513 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'm@home.com', 'N'), (15, 1015, 'N', 'Nascent', 'Nick', 'N', '1514 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', 'n@home.com', 'N'), (16, 1016, '
7 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_scoutsaccounts` (`id`, `scouts_id`, `accounts_id`, `description`, `amount`, `date`) VALUES (1, 1, 1, 'first deposit', 20.00, '2007-01-01'), (2, 1, 2, 'deposit', 50.00, '2007-01-01'), (3, 2, 1, 'deposit', 20.00, '2007-02-01'), (4, 3, 1, 'deposit', 20.00, '2007-03-01'), (5, 4, 1, 'deposit', 20.00, '2007-04-01'), (6, 5, 1, 'deposit', 20.00, '2007-05-01'), (7, 6, 1, 'deposit', 20.00, '2007-06-01'), (8, 7, 1, 'deposit', 20.00, '2007-07-01'), (9, 8, 1, 'deposit', 20.00, '2007-08-01'), (10, 9, 1, 'deposit', 20.00, '2007-09-01'), (11, 10, 1, 'deposit', 20.00, '2007-10-01'), (12, 11, 1, 'deposit', 20.00, '2007-11-01'), (13, 12, 1, 'deposit', 20.00, '2007-12-01'), (14, 13, 1, '', 20.00, '2007-01-02'), (15, 14, 1, '', 20.00, '2007-02-02'), (16, 15, 1, '', 20.00, '2007-03-02'), (17, 16, 1, '', 20.00, '2007-04-02'), (18, 17, 1, '', 20.00, '2007-05-02'), (19, 18, 1, '', 20.00, '2007-06-02'), (20, 19, 1, '', 20.00, '2007-07-02'), (21, 20, 1, '', 20.00, '2007-08-02'), (22, 21, 1, '', 20.00, '2007-09-02'), (23, 22, 1, '', 20.00, '2007-10-02'), (24, 23, 1, '', 20.00, '2007-11-02'), (25, 24, 1, '', 20.00, '2007-12-02'), (26, 25, 1, '', 20.00, '2007-01-03'), (27, 26, 1, '', 20.00, '2007-02-03');
6 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_accounts` (`id`, `events_id`, `name`) VALUES (1, NULL, 'general'), (2, 1, 'fee for campout 1'), (3, 2, 'fee for campout 2'), (4, 4, 'fee for campout 4'), (5, 6, 'fee for campout 6'), (6, 8, 'fee for campout 8'), (7, 3, 'fee for campout 3'), (8, 5, 'fee for campout 5'), (9, 7, 'fee for campout 7'), (10, 9, 'fee for campout 9'), (11, 10, 'deposit for 2007 Summer Camp'), (12, 10, 'final payment for 2007 Summer Camp');
5 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_scoutspors` (`id`, `scouts_id`, `position_name`, `start_date`, `end_date`) VALUES (1, 1, 'Troop Guide', '2006-01-01', NULL), (2, 2, 'Quartermaster', '2006-01-02', NULL), (3, 3, 'Scribe', '2006-01-03', NULL), (4, 4, 'Patrol Leader', '2006-01-04', NULL), (5, 5, 'Asst. SPL', '2006-01-05', NULL), (6, 6, 'Librarian', '2006-01-06', NULL), (7, 7, 'Troop Guide', '2006-01-07', NULL), (8, 8, 'Quartermaster', '2006-01-08', NULL), (9, 9, 'Scribe', '2006-01-09', NULL), (10, 10, 'Patrol Leader', '2006-01-10', NULL), (11, 11, 'Asst. SPL', '2006-01-11', NULL), (12, 12, 'Librarian', '2006-01-12', NULL), (13, 13, 'Troop Guide', '2006-01-13', NULL), (14, 14, 'Quartermaster', '2006-01-14', NULL), (15, 15, 'Scribe', '2006-01-15', NULL), (16, 16, 'Patrol Leader', '2006-01-16', NULL), (17, 17, 'Asst. SPL', '2006-01-17', NULL), (18, 18, 'Librarian', '2006-01-18', NULL), (19, 19, 'Troop Guide', '2006-01-19', NULL), (20, 20, 'Quartermaster', '2006-01-20', NULL), (21, 21, 'Scribe', '2006-01-21', NULL), (22, 22, 'Patrol Leader', '2006-01-22', NULL), (23, 23, 'Asst. SPL', '2006-01-23', NULL), (24, 24, 'Librarian', '2006-01-24', NULL), (25, 25, 'Troop Guide', '2006-01-25', NULL), (26, 26, 'Quartermaster', '2006-01-26', NULL);
4 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_scoutspatrols` (`id`, `scouts_id`, `patrol_name`, `start_date`, `end_date`) VALUES (1, 1, 'Fox', '2006-01-01', '2007-01-01'), (2, 1, 'Bear', '2007-01-01', NULL), (3, 2, 'Bear', '2006-01-02', NULL), (4, 3, 'Owl', '2006-01-03', NULL), (5, 4, 'Eagle', '2006-01-04', NULL), (6, 5, 'Fox', '2006-01-05', NULL), (7, 6, 'Bear', '2006-01-06', NULL), (8, 7, 'Owl', '2006-01-07', NULL), (9, 8, 'Eagle', '2006-01-08', NULL), (10, 9, 'Fox', '2006-01-09', NULL), (11, 10, 'Bear', '2006-01-10', NULL), (12, 11, 'Owl', '2006-01-11', NULL), (13, 12, 'Eagle', '2006-01-12', NULL), (14, 13, 'Fox', '2006-01-13', NULL), (15, 14, 'Bear', '2006-01-14', NULL), (16, 15, 'Owl', '2006-01-15', NULL), (17, 16, 'Eagle', '2006-01-16', NULL), (18, 17, 'Fox', '2006-01-17', NULL), (19, 18, 'Bear', '2006-01-18', NULL), (20, 19, 'Owl', '2006-01-19', NULL), (21, 20, 'Eagle', '2006-01-20', NULL), (22, 21, 'Fox', '2006-01-21', NULL), (23, 22, 'Bear', '2006-01-22', NULL), (24, 23, 'Owl', '2006-01-23', NULL), (25, 24, 'Eagle', '2006-01-24', NULL), (26, 25, 'Fox', '2006-01-25', NULL), (27, 26, 'Bear', '2006-01-26', NULL);
3 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_scoutsphones` (`id`, `scouts_id`, `number`, `description`) VALUES (1, 1, '800-555-0001', 'home'), (2, 1, '800-555-0101', 'cell'), (3, 2, '800-555-0002', 'home'), (4, 3, '800-555-0003', 'home'), (5, 4, '800-555-0004', 'home'), (6, 5, '800-555-0005', 'home'), (7, 6, '800-555-0006', 'home'), (8, 7, '800-555-0007', 'home'), (9, 8, '800-555-0008', 'home'), (10, 9, '800-555-0009', 'home'), (11, 10, '800-555-0010', 'home'), (12, 11, '800-555-0011', 'home'), (13, 12, '800-555-0012', 'home'), (14, 13, '800-555-0013', 'home'), (15, 14, '800-555-0014', 'home'), (16, 15, '800-555-0015', 'home'), (17, 16, '800-555-0016', 'home'), (18, 17, '800-555-0017', 'home'), (19, 18, '800-555-0018', 'home'), (20, 19, '800-555-0019', 'home'), (21, 20, '800-555-0020', 'home'), (22, 21, '800-555-0021', 'home'), (23, 22, '800-555-0022', 'home'), (24, 23, '800-555-0023', 'home'), (25, 24, '800-555-0024', 'home'), (26, 25, '800-555-0025', 'home'), (27, 26, '800-555-0026', 'home');
2 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_scouts` (`id`, `user_id`, `name_public`, `name_family`, `name_given`, `name_middle`, `name_legal`, `date_of_birth`, `date_joined_unit`, `address1`, `address2`, `city`, `state`, `zip`, `email`, `active`, `current_rank`, `is_oa`) VALUES (1, 1100, 'Alfa A', 'Astute', 'Alfa', 'A', 'Alfa Aaron Astute', '1995-01-01', '2006-01-01', '1501 Pennsylvania Avenue', 'Apt 300', 'Washington', 'DC', '20500', NULL, 'Y', 100, 'N'), (2, NULL, 'Bravo B', 'Brimstone', 'Bravo', 'B', 'Bravo Barny Brimstone', '1995-01-02', '2006-01-02', '1502 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', NULL, 'Y', 170, 'N'), (3, NULL, 'Charlie C', 'Caveat', 'Charlie', 'C', 'Charlie Curtis Caveat', '1995-01-03', '2006-01-03', '1503 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', NULL, 'Y', 171, 'N'), (4, NULL, 'Delta D', 'Durable', 'Delta', 'D', 'Durable Douglas Delta', '1995-01-04', '2006-01-04', '1504 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', NULL, 'Y', 172, 'N'), (5, NULL, 'Echo E', 'Emulate', 'Echo', 'E', 'Echo Erol Emulate', '1995-01-05', '2006-01-05', '1505 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', NULL, 'Y', 173, 'N'), (6, NULL, 'Foxtrot F', 'Fulminate', 'Foxtrot', 'F', 'Foxtron Ferdinand Fulminate', '1995-01-06', '2006-01-06', '1506 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', NULL, 'Y', 180, 'Y'), (7, NULL, 'Golf G', 'Gimbal', 'Golf', 'G', 'Golf Garrard Gimbal', '1995-01-07', '2006-01-07', '1507 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', NULL, 'Y', 175, 'Y'), (8, NULL, 'Hotel H', 'Hubrus', 'Hotel', 'H', 'Hotel Horatio Hubrus', '1995-01-08', '2006-01-08', '1508 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', NULL, 'Y', 100, 'N'), (9, NULL, 'India I', 'Indignant', 'India', 'I', 'India Indifferent Indignant', '1995-01-09', '2006-01-09', '1509 Pennsylvania Avenue', NULL, 'Washington', 'DC', '20500', NULL, 'Y', 170, 'N'), (10, NULL, 'Juliet J', 'Jubilant', 'Juliet', 'J', 'Juliet Justus Jubilant', '1995-01-10', '2006-01-10', '1510 Pennsylvania
1 2014-09-07 17:33:16 admin INSERT INTO `#__bsadv_checkout` (`id`, `user_id`, `item`, `reason`, `datetime`, `code`) VALUES (1, 62, 'events:deeds', 'enter campout data', '2009-06-03 12:35:20', '5555');