Installation

Databases are already installed.

CREATE TABLE `stellar_shop_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_amount` 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),
  `receipt_id` VARCHAR(24),
  `time` DATETIME,
  PRIMARY KEY(`id`)
)
TYPE = InnoDB;

CREATE TABLE `stellar_shop_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_shop_download` (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `item_number` VARCHAR(127),
  `payer_email` VARCHAR(127),
  `txn_id` VARCHAR(17),
  `ip` VARCHAR(17),
  `proxy` VARCHAR(17),
  `time` DATETIME,
  PRIMARY KEY(`id`)
)
TYPE = InnoDB;