popufare/server/testing/db/setup-vanilla.sqlite

insert  into drivers (id, pin, name) values (7357, 7357, 'Test driver');

insert  into groups
  (group_id, group_name)
  values
  (1, 'ORG'),
  (100, 'SUPERUSERS');

insert  into org_default_card_value
  (group_id, mag_track, rf_length, rf_site)
  values
  (1, 2, 26, 137);

insert  into rule_class
  (rulename, ruleclass)
  values
  ('NRIDE', 'NRIDE'),
  ('NDAY', 'NDAY'),
  ('REJECT', 'OTHER');

insert  into rule_mappings
  (rule, rule_text, group_id, active)
  values
  ('NRIDE', 'N-Ride Pass', 1, 1),
  ('NDAY', 'N-Day Pass', 1, 1),
  ('REJECT', 'No passes on Card', NULL, 1);


-- ;;;;;;;;;;;;;;;;;;

insert into admins
  (username, password, userid, active, group_id)
  values
  ('user', NULL, 1, 1, 1),
  ('superuser', NULL, 2, 1, 100);

insert into admin_gorups
  (userid, group_id, permissions)
  values
  (1, 1, NULL),
  (2, 1, NULL),
  (2, 100, NULL);