   PRIMARY KEY (`id`),
   UNIQUE KEY `number_issuers_name_index` (`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-CREATE TABLE `offline_single_event_licenses` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `event_id` int(11) DEFAULT NULL,
-  `person_id` int(11) DEFAULT NULL,
-  `created_at` datetime DEFAULT NULL,
-  `updated_at` datetime DEFAULT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-CREATE TABLE `order_people` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `person_id` int(11) DEFAULT NULL,
-  `order_id` int(11) DEFAULT NULL,
-  `owner` tinyint(1) NOT NULL DEFAULT '0',
-  `membership_card` tinyint(1) NOT NULL DEFAULT '0',
-  `date_of_birth` date DEFAULT NULL,
-  `street` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `zip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `country_code` varchar(2) COLLATE utf8_unicode_ci DEFAULT 'US',
-  `membership_address_is_billing_address` tinyint(1) NOT NULL DEFAULT '1',
-  `billing_first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `billing_last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `billing_street` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `billing_city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `billing_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `billing_zip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `billing_country_code` varchar(2) COLLATE utf8_unicode_ci DEFAULT 'US',
-  `card_expires_on` date DEFAULT NULL,
-  `card_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `ccx_category` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `dh_category` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `home_phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `gender` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `mtb_category` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `occupation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `official_interest` tinyint(1) NOT NULL DEFAULT '0',
-  `race_promotion_interest` tinyint(1) NOT NULL DEFAULT '0',
-  `team_interest` tinyint(1) NOT NULL DEFAULT '0',
-  `volunteer_interest` tinyint(1) NOT NULL DEFAULT '0',
-  `wants_mail` tinyint(1) NOT NULL DEFAULT '0',
-  `wants_email` tinyint(1) NOT NULL DEFAULT '0',
-  `road_category` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `team_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `track_category` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `emergency_contact` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `emergency_contact_phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `lock_version` int(11) NOT NULL DEFAULT '0',
-  `created_at` datetime DEFAULT NULL,
-  `updated_at` datetime DEFAULT NULL,
-  `work_phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `cell_fax` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-CREATE TABLE `order_transactions` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `order_id` int(11) DEFAULT NULL,
-  `action` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `amount` int(11) DEFAULT NULL,
-  `success` tinyint(1) DEFAULT NULL,
-  `authorization` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `params` text COLLATE utf8_unicode_ci,
-  `lock_version` int(11) NOT NULL DEFAULT '0',
-  `created_at` datetime DEFAULT NULL,
-  `updated_at` datetime DEFAULT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-CREATE TABLE `orders` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `lock_version` int(11) NOT NULL DEFAULT '0',
-  `purchase_price` decimal(10,2) DEFAULT NULL,
-  `notes` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `created_at` datetime DEFAULT NULL,
-  `updated_at` datetime DEFAULT NULL,
-  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
-  `purchase_time` datetime DEFAULT NULL,
-  `ip_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `waiver_accepted` tinyint(1) DEFAULT NULL,
-  `error_message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `previous_status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `suggest` tinyint(1) DEFAULT '1',
-  `purchase_fees` decimal(10,2) DEFAULT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 CREATE TABLE `pages` (
   `id` int(11) NOT NULL AUTO_INCREMENT,

  `body` text COLLATE utf8_unicode_ci,
  `position` int(11) DEFAULT '0',
  `article_category_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `bank_statements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `american_express_fees` decimal(10,2) DEFAULT NULL,
  `american_express_gross` decimal(10,2) DEFAULT NULL,
  `credit_card_transaction_fees` decimal(10,2) DEFAULT NULL,
  `credit_card_percentage_fees` decimal(10,2) DEFAULT NULL,
  `credit_card_gross` decimal(10,2) DEFAULT NULL,
  `items` int(11) DEFAULT NULL,
  `refunds` int(11) DEFAULT NULL,
  `gross` decimal(10,2) DEFAULT NULL,
  `refunds_gross` decimal(10,2) DEFAULT NULL,
  `other_fees` decimal(10,2) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)

  `beginner_friendly` tinyint(1) NOT NULL DEFAULT '0',
  `website` varchar(255) DEFAULT NULL,
  `registration_link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_disciplined` (`discipline`),
  KEY `parent_id` (`parent_id`),
