Installation

Databases are already installed.

CREATE TABLE `stellar_demootrack_trans` (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `invoice` VARCHAR(127),
  `custom` VARCHAR(255),
  `test_ipn` INTEGER UNSIGNED DEFAULT 0,
  `memo` VARCHAR(255),
  `business` VARCHAR(127),
  `receiver_id` VARCHAR(13),
  `receiver_email` VARCHAR(127),
  `first_name` VARCHAR(64),
  `last_name` VARCHAR(64),
  `contact_phone` VARCHAR(24),
  `address_city` VARCHAR(40),
  `address_country` VARCHAR(64),
  `address_country_code` VARCHAR(2),
  `address_name` VARCHAR(128),
  `address_state` VARCHAR(40),
  `address_status` VARCHAR(12),
  `address_street` VARCHAR(200),
  `address_zip` VARCHAR(20),
  `payer_business_name` VARCHAR(127),
  `payer_email` VARCHAR(127),
  `payer_id` VARCHAR(13),
  `payer_status` VARCHAR(12),
  `residence_country` VARCHAR(2),
  `txn_id` VARCHAR(17),
  `txn_type` VARCHAR(24),
  `transaction_entity` VARCHAR(10),
  `tax` DECIMAL(6,4),
  `auth_id` VARCHAR(64),
  `auth_exp` VARCHAR(64),
  `auth_status` VARCHAR(12),
  `auth_amount` DECIMAL(10,2),
  `num_cart_items` INTEGER,
  `mc_currency` VARCHAR(3),
  `exchange_rate` DECIMAL(10,2),
  `mc_fee` DECIMAL(10,2),
  `mc_gross` DECIMAL(10,2),
  `parent_txn_id` VARCHAR(17),
  `payment_date` VARCHAR(64),
  `payment_status` VARCHAR(24),
  `payment_type` VARCHAR(12),
  `pending_reason` VARCHAR(16),
  `reason_code` VARCHAR(16),
  `remaining_settle` DECIMAL(10,2),
  `mc_handling` DECIMAL(10,2),
  `mc_shipping` DECIMAL(10,2),
  `settle_currency` VARCHAR(3),
  `case_id` VARCHAR(64),
  `case_type` VARCHAR(12),
  `case_creation_date` VARCHAR(64),
  `handling` DECIMAL(10,2),
  `shipping` DECIMAL(10,2),
  `settle_amount` DECIMAL(10,2),
  `auction_buyer_id` VARCHAR(64),
  `auction_closing_date` VARCHAR(64),
  `auction_multi_item` INTEGER,
  `for_auction` VARCHAR(10),
  `subscr_date` VARCHAR(64),
  `subscr_effective` VARCHAR(64),
  `period1` VARCHAR(12),
  `period2` VARCHAR(12),
  `period3` VARCHAR(12),
  `amount1` DECIMAL(10,2),
  `amount2` DECIMAL(10,2),
  `amount3` DECIMAL(10,2),
  `mc_amount1` DECIMAL(10,2),
  `mc_amount2` DECIMAL(10,2),
  `mc_amount3` DECIMAL(10,2),
  `recurring` VARCHAR(1),
  `reattempt` VARCHAR(1),
  `retry_at` VARCHAR(64),
  `recur_times` INTEGER,
  `username` VARCHAR(64),
  `password` VARCHAR(64),
  `subscr_id` VARCHAR(19),
  `receipt_id` VARCHAR(24),
  `time` DATETIME,
  PRIMARY KEY(`id`)
)
TYPE = InnoDB;

CREATE TABLE `stellar_demootrack_item` (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent_id` INTEGER UNSIGNED,
  `sequence_id` INTEGER UNSIGNED,
  `test_ipn` INTEGER UNSIGNED DEFAULT 0,
  `item_name` VARCHAR(127) NOT NULL,
  `item_number` VARCHAR(127),
  `mc_gross` DECIMAL(10,2),
  `option_name1` VARCHAR(64),
  `option_selection1` VARCHAR(200),
  `option_name2` VARCHAR(64),
  `option_selection2` VARCHAR(200),
  `quantity` INTEGER,
  `mc_shipping` DECIMAL(10,2),
  `mc_handling` DECIMAL(10,2),
  `shipping` DECIMAL(10,2),
  `tax` DECIMAL(6,4),

  `time` DATETIME,
  PRIMARY KEY(`id`)
)
TYPE = InnoDB;

CREATE TABLE `stellar_demootrack_tracking` (
  `tid` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `stellar_txn_id` VARCHAR(17),
  `stellar_note` VARCHAR(255),
  `stellar_archive` VARCHAR(64),
  `stellar_job_info` VARCHAR(64),
  `stellar_job_invoice` VARCHAR(64),
  `stellar_job_label` VARCHAR(64),
  `stellar_job_shipping` VARCHAR(64),
  `stellar_job_email` VARCHAR(64),
  `stellar_shipment_date` DATETIME,
  `stellar_shipment_tracking` VARCHAR(255),
  `stellar_shipment_note` VARCHAR(255),
  PRIMARY KEY(`tid`)
)
TYPE = InnoDB;