-- Dumping data for table `wal_sales_creditmemo_item`
--


--
-- Table structure for table `wal_sales_invoice`
--

CREATE TABLE `wal_sales_invoice` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  `shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Amount',
  `tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Amount',
  `base_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Amount',
  `store_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Store To Order Rate',
  `base_shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Amount',
  `base_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Amount',
  `base_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Order Rate',
  `grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
  `shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
  `subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Incl Tax',
  `base_subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Incl Tax',
  `store_to_base_rate` decimal(20,4) DEFAULT NULL COMMENT 'Store To Base Rate',
  `base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
  `total_qty` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty',
  `base_to_global_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Global Rate',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `base_subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal',
  `discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Amount',
  `billing_address_id` int(11) DEFAULT NULL COMMENT 'Billing Address ID',
  `is_used_for_refund` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Used For Refund',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `email_sent` smallint(5) unsigned DEFAULT NULL COMMENT 'Email Sent',
  `send_email` smallint(5) unsigned DEFAULT NULL COMMENT 'Send Email',
  `can_void_flag` smallint(5) unsigned DEFAULT NULL COMMENT 'Can Void Flag',
  `state` int(11) DEFAULT NULL COMMENT 'State',
  `shipping_address_id` int(11) DEFAULT NULL COMMENT 'Shipping Address ID',
  `store_currency_code` varchar(3) DEFAULT NULL COMMENT 'Store Currency Code',
  `transaction_id` varchar(255) DEFAULT NULL COMMENT 'Transaction ID',
  `order_currency_code` varchar(3) DEFAULT NULL COMMENT 'Order Currency Code',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  `global_currency_code` varchar(3) DEFAULT NULL COMMENT 'Global Currency Code',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `shipping_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Tax Compensation Amount',
  `base_shipping_discount_tax_compensation_amnt` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Tax Compensation Amount',
  `shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Incl Tax',
  `base_shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Incl Tax',
  `base_total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Refunded',
  `discount_description` varchar(255) DEFAULT NULL COMMENT 'Discount Description',
  `customer_note` text COMMENT 'Customer Note',
  `customer_note_notify` smallint(5) unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
  `base_customer_balance_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Customer Balance Amount',
  `customer_balance_amount` decimal(20,4) DEFAULT NULL COMMENT 'Customer Balance Amount',
  `base_reward_currency_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Reward Currency Amount',
  `reward_currency_amount` decimal(20,4) DEFAULT NULL COMMENT 'Reward Currency Amount',
  `reward_points_balance` int(11) DEFAULT NULL COMMENT 'Reward Points Balance',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `WAL_SALES_INVOICE_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `WAL_SALES_INVOICE_STORE_ID` (`store_id`),
  KEY `WAL_SALES_INVOICE_GRAND_TOTAL` (`grand_total`),
  KEY `WAL_SALES_INVOICE_ORDER_ID` (`order_id`),
  KEY `WAL_SALES_INVOICE_STATE` (`state`),
  KEY `WAL_SALES_INVOICE_CREATED_AT` (`created_at`),
  KEY `WAL_SALES_INVOICE_UPDATED_AT` (`updated_at`),
  KEY `WAL_SALES_INVOICE_SEND_EMAIL` (`send_email`),
  KEY `WAL_SALES_INVOICE_EMAIL_SENT` (`email_sent`),
  CONSTRAINT `WAL_SALES_INVOICE_ORDER_ID_WAL_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALES_INVOICE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Invoice';

--
-- Dumping data for table `wal_sales_invoice`
--


--
-- Table structure for table `wal_sales_invoice_comment`
--

CREATE TABLE `wal_sales_invoice_comment` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `is_customer_notified` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Customer Notified',
  `is_visible_on_front` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible On Front',
  `comment` text COMMENT 'Comment',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  PRIMARY KEY (`entity_id`),
  KEY `WAL_SALES_INVOICE_COMMENT_CREATED_AT` (`created_at`),
  KEY `WAL_SALES_INVOICE_COMMENT_PARENT_ID` (`parent_id`),
  CONSTRAINT `WAL_SALES_INVOICE_COMMENT_PARENT_ID_WAL_SALES_INVOICE_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `wal_sales_invoice` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Invoice Comment';

--
-- Dumping data for table `wal_sales_invoice_comment`
--


--
-- Table structure for table `wal_sales_invoice_grid`
--

CREATE TABLE `wal_sales_invoice_grid` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `state` int(11) DEFAULT NULL COMMENT 'State',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `store_name` varchar(255) DEFAULT NULL COMMENT 'Store Name',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `order_increment_id` varchar(50) DEFAULT NULL COMMENT 'Order Increment ID',
  `order_created_at` timestamp NULL DEFAULT NULL COMMENT 'Order Created At',
  `customer_name` varchar(255) DEFAULT NULL COMMENT 'Customer Name',
  `customer_email` varchar(255) DEFAULT NULL COMMENT 'Customer Email',
  `customer_group_id` int(11) DEFAULT NULL,
  `payment_method` varchar(128) DEFAULT NULL COMMENT 'Payment Method',
  `store_currency_code` varchar(3) DEFAULT NULL COMMENT 'Store Currency Code',
  `order_currency_code` varchar(3) DEFAULT NULL COMMENT 'Order Currency Code',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  `global_currency_code` varchar(3) DEFAULT NULL COMMENT 'Global Currency Code',
  `billing_name` varchar(255) DEFAULT NULL COMMENT 'Billing Name',
  `billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
  `shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
  `shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `shipping_and_handling` decimal(20,4) DEFAULT NULL COMMENT 'Shipping and handling amount',
  `grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `WAL_SALES_INVOICE_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `WAL_SALES_INVOICE_GRID_STORE_ID` (`store_id`),
  KEY `WAL_SALES_INVOICE_GRID_GRAND_TOTAL` (`grand_total`),
  KEY `WAL_SALES_INVOICE_GRID_ORDER_ID` (`order_id`),
  KEY `WAL_SALES_INVOICE_GRID_STATE` (`state`),
  KEY `WAL_SALES_INVOICE_GRID_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `WAL_SALES_INVOICE_GRID_CREATED_AT` (`created_at`),
  KEY `WAL_SALES_INVOICE_GRID_UPDATED_AT` (`updated_at`),
  KEY `WAL_SALES_INVOICE_GRID_ORDER_CREATED_AT` (`order_created_at`),
  KEY `WAL_SALES_INVOICE_GRID_BILLING_NAME` (`billing_name`),
  KEY `WAL_SALES_INVOICE_GRID_BASE_GRAND_TOTAL` (`base_grand_total`),
  FULLTEXT KEY `FTI_C3CD071D2A8B3AEC6ED0DB6DE685001A` (`increment_id`,`order_increment_id`,`billing_name`,`billing_address`,`shipping_address`,`customer_name`,`customer_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Invoice Grid';

--
-- Dumping data for table `wal_sales_invoice_grid`
--


--
-- Table structure for table `wal_sales_invoice_item`
--

CREATE TABLE `wal_sales_invoice_item` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `base_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Price',
  `tax_amount` decimal(12,4) DEFAULT NULL COMMENT 'Tax Amount',
  `base_row_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Row Total',
  `discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Discount Amount',
  `row_total` decimal(20,4) DEFAULT NULL COMMENT 'Row Total',
  `base_discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Discount Amount',
  `price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Price Incl Tax',
  `base_tax_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Tax Amount',
  `base_price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
  `qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
  `base_cost` decimal(12,4) DEFAULT NULL COMMENT 'Base Cost',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
  `base_row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
  `row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
  `product_id` int(11) DEFAULT NULL COMMENT 'Product ID',
  `order_item_id` int(11) DEFAULT NULL COMMENT 'Order Item ID',
  `additional_data` text COMMENT 'Additional Data',
  `description` text COMMENT 'Description',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `tax_ratio` text COMMENT 'Ratio of tax invoiced over tax of the order item',
  PRIMARY KEY (`entity_id`),
  KEY `WAL_SALES_INVOICE_ITEM_PARENT_ID` (`parent_id`),
  CONSTRAINT `WAL_SALES_INVOICE_ITEM_PARENT_ID_WAL_SALES_INVOICE_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `wal_sales_invoice` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Invoice Item';

--
-- Dumping data for table `wal_sales_invoice_item`
--


--
-- Table structure for table `wal_sales_invoiced_aggregated`
--

CREATE TABLE `wal_sales_invoiced_aggregated` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `orders_invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Orders Invoiced',
  `invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced',
  `invoiced_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Captured',
  `invoiced_not_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Not Captured',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_SALES_INVOICED_AGGREGATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `WAL_SALES_INVOICED_AGGREGATED_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_SALES_INVOICED_AGGREGATED_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Invoiced Aggregated';

--
-- Dumping data for table `wal_sales_invoiced_aggregated`
--


--
-- Table structure for table `wal_sales_invoiced_aggregated_order`
--

CREATE TABLE `wal_sales_invoiced_aggregated_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `orders_invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Orders Invoiced',
  `invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced',
  `invoiced_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Captured',
  `invoiced_not_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Not Captured',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_SALES_INVOICED_AGGREGATED_ORDER_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `WAL_SALES_INVOICED_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_SALES_INVOICED_AGGREGATED_ORDER_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Invoiced Aggregated Order';

--
-- Dumping data for table `wal_sales_invoiced_aggregated_order`
--


--
-- Table structure for table `wal_sales_order`
--

CREATE TABLE `wal_sales_order` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `state` varchar(32) DEFAULT NULL COMMENT 'State',
  `status` varchar(32) DEFAULT NULL COMMENT 'Status',
  `coupon_code` varchar(255) DEFAULT NULL COMMENT 'Coupon Code',
  `protect_code` varchar(255) DEFAULT NULL COMMENT 'Protect Code',
  `shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
  `is_virtual` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Virtual',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `base_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Amount',
  `base_discount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Canceled',
  `base_discount_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Invoiced',
  `base_discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Refunded',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  `base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
  `base_shipping_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Canceled',
  `base_shipping_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Invoiced',
  `base_shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Refunded',
  `base_shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Amount',
  `base_shipping_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Refunded',
  `base_subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal',
  `base_subtotal_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Canceled',
  `base_subtotal_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Invoiced',
  `base_subtotal_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Refunded',
  `base_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Amount',
  `base_tax_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Canceled',
  `base_tax_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Invoiced',
  `base_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Refunded',
  `base_to_global_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Global Rate',
  `base_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Order Rate',
  `base_total_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Canceled',
  `base_total_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Invoiced',
  `base_total_invoiced_cost` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Invoiced Cost',
  `base_total_offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Offline Refunded',
  `base_total_online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Online Refunded',
  `base_total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Paid',
  `base_total_qty_ordered` decimal(12,4) DEFAULT NULL COMMENT 'Base Total Qty Ordered',
  `base_total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Refunded',
  `discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Amount',
  `discount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Discount Canceled',
  `discount_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Discount Invoiced',
  `discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Refunded',
  `grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
  `shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
  `shipping_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Canceled',
  `shipping_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Invoiced',
  `shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Refunded',
  `shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Amount',
  `shipping_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Refunded',
  `store_to_base_rate` decimal(12,4) DEFAULT NULL COMMENT 'Store To Base Rate',
  `store_to_order_rate` decimal(12,4) DEFAULT NULL COMMENT 'Store To Order Rate',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `subtotal_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Canceled',
  `subtotal_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Invoiced',
  `subtotal_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Refunded',
  `tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Amount',
  `tax_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Tax Canceled',
  `tax_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Tax Invoiced',
  `tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Tax Refunded',
  `total_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Total Canceled',
  `total_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Total Invoiced',
  `total_offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Offline Refunded',
  `total_online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Online Refunded',
  `total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Total Paid',
  `total_qty_ordered` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty Ordered',
  `total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Refunded',
  `can_ship_partially` smallint(5) unsigned DEFAULT NULL COMMENT 'Can Ship Partially',
  `can_ship_partially_item` smallint(5) unsigned DEFAULT NULL COMMENT 'Can Ship Partially Item',
  `customer_is_guest` smallint(5) unsigned DEFAULT NULL COMMENT 'Customer Is Guest',
  `customer_note_notify` smallint(5) unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
  `billing_address_id` int(11) DEFAULT NULL COMMENT 'Billing Address ID',
  `customer_group_id` int(11) DEFAULT NULL,
  `edit_increment` int(11) DEFAULT NULL COMMENT 'Edit Increment',
  `email_sent` smallint(5) unsigned DEFAULT NULL COMMENT 'Email Sent',
  `send_email` smallint(5) unsigned DEFAULT NULL COMMENT 'Send Email',
  `forced_shipment_with_invoice` smallint(5) unsigned DEFAULT NULL COMMENT 'Forced Do Shipment With Invoice',
  `payment_auth_expiration` int(11) DEFAULT NULL COMMENT 'Payment Authorization Expiration',
  `quote_address_id` int(11) DEFAULT NULL COMMENT 'Quote Address ID',
  `quote_id` int(11) DEFAULT NULL COMMENT 'Quote ID',
  `shipping_address_id` int(11) DEFAULT NULL COMMENT 'Shipping Address ID',
  `adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Negative',
  `adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Positive',
  `base_adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment Negative',
  `base_adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment Positive',
  `base_shipping_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Amount',
  `base_subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Incl Tax',
  `base_total_due` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Due',
  `payment_authorization_amount` decimal(20,4) DEFAULT NULL COMMENT 'Payment Authorization Amount',
  `shipping_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Amount',
  `subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Incl Tax',
  `total_due` decimal(20,4) DEFAULT NULL COMMENT 'Total Due',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
  `customer_dob` datetime DEFAULT NULL COMMENT 'Customer Dob',
  `increment_id` varchar(32) DEFAULT NULL COMMENT 'Increment ID',
  `applied_rule_ids` varchar(128) DEFAULT NULL COMMENT 'Applied Rule Ids',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  `customer_email` varchar(128) DEFAULT NULL COMMENT 'Customer Email',
  `customer_firstname` varchar(128) DEFAULT NULL COMMENT 'Customer Firstname',
  `customer_lastname` varchar(128) DEFAULT NULL COMMENT 'Customer Lastname',
  `customer_middlename` varchar(128) DEFAULT NULL COMMENT 'Customer Middlename',
  `customer_prefix` varchar(32) DEFAULT NULL COMMENT 'Customer Prefix',
  `customer_suffix` varchar(32) DEFAULT NULL COMMENT 'Customer Suffix',
  `customer_taxvat` varchar(32) DEFAULT NULL COMMENT 'Customer Taxvat',
  `discount_description` varchar(255) DEFAULT NULL COMMENT 'Discount Description',
  `ext_customer_id` varchar(32) DEFAULT NULL COMMENT 'Ext Customer ID',
  `ext_order_id` varchar(32) DEFAULT NULL COMMENT 'Ext Order ID',
  `global_currency_code` varchar(3) DEFAULT NULL COMMENT 'Global Currency Code',
  `hold_before_state` varchar(32) DEFAULT NULL COMMENT 'Hold Before State',
  `hold_before_status` varchar(32) DEFAULT NULL COMMENT 'Hold Before Status',
  `order_currency_code` varchar(3) DEFAULT NULL COMMENT 'Order Currency Code',
  `original_increment_id` varchar(32) DEFAULT NULL COMMENT 'Original Increment ID',
  `relation_child_id` varchar(32) DEFAULT NULL COMMENT 'Relation Child ID',
  `relation_child_real_id` varchar(32) DEFAULT NULL COMMENT 'Relation Child Real ID',
  `relation_parent_id` varchar(32) DEFAULT NULL COMMENT 'Relation Parent ID',
  `relation_parent_real_id` varchar(32) DEFAULT NULL COMMENT 'Relation Parent Real ID',
  `remote_ip` varchar(45) DEFAULT NULL COMMENT 'Remote Ip',
  `shipping_method` varchar(120) DEFAULT NULL,
  `store_currency_code` varchar(3) DEFAULT NULL COMMENT 'Store Currency Code',
  `store_name` varchar(255) DEFAULT NULL COMMENT 'Store Name',
  `x_forwarded_for` varchar(255) DEFAULT NULL COMMENT 'X Forwarded For',
  `customer_note` text COMMENT 'Customer Note',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `total_item_count` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Total Item Count',
  `customer_gender` int(11) DEFAULT NULL COMMENT 'Customer Gender',
  `discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `shipping_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Tax Compensation Amount',
  `base_shipping_discount_tax_compensation_amnt` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Tax Compensation Amount',
  `discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Invoiced',
  `base_discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Invoiced',
  `discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Refunded',
  `base_discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Refunded',
  `shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Incl Tax',
  `base_shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Incl Tax',
  `coupon_rule_name` varchar(255) DEFAULT NULL COMMENT 'Coupon Sales Rule Name',
  `paypal_ipn_customer_notified` int(11) DEFAULT '0' COMMENT 'Paypal Ipn Customer Notified',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
  `base_customer_balance_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Customer Balance Amount',
  `customer_balance_amount` decimal(20,4) DEFAULT NULL COMMENT 'Customer Balance Amount',
  `base_customer_balance_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Customer Balance Invoiced',
  `customer_balance_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Customer Balance Invoiced',
  `base_customer_balance_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Customer Balance Refunded',
  `customer_balance_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Customer Balance Refunded',
  `bs_customer_bal_total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Bs Customer Bal Total Refunded',
  `customer_bal_total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Customer Bal Total Refunded',
  `reward_points_balance` int(11) DEFAULT NULL COMMENT 'Reward Points Balance',
  `base_reward_currency_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Reward Currency Amount',
  `reward_currency_amount` decimal(20,4) DEFAULT NULL COMMENT 'Reward Currency Amount',
  `base_rwrd_crrncy_amt_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Rwrd Crrncy Amt Invoiced',
  `rwrd_currency_amount_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Rwrd Currency Amount Invoiced',
  `base_rwrd_crrncy_amnt_refnded` decimal(20,4) DEFAULT NULL COMMENT 'Base Rwrd Crrncy Amnt Refnded',
  `rwrd_crrncy_amnt_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Rwrd Crrncy Amnt Refunded',
  `reward_points_balance_refund` int(11) DEFAULT NULL COMMENT 'Reward Points Balance Refund',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `WAL_SALES_ORDER_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `WAL_SALES_ORDER_STATUS` (`status`),
  KEY `WAL_SALES_ORDER_STATE` (`state`),
  KEY `WAL_SALES_ORDER_STORE_ID` (`store_id`),
  KEY `WAL_SALES_ORDER_CREATED_AT` (`created_at`),
  KEY `WAL_SALES_ORDER_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_SALES_ORDER_EXT_ORDER_ID` (`ext_order_id`),
  KEY `WAL_SALES_ORDER_QUOTE_ID` (`quote_id`),
  KEY `WAL_SALES_ORDER_UPDATED_AT` (`updated_at`),
  KEY `WAL_SALES_ORDER_SEND_EMAIL` (`send_email`),
  KEY `WAL_SALES_ORDER_EMAIL_SENT` (`email_sent`),
  CONSTRAINT `WAL_SALES_ORDER_CUSTOMER_ID_WAL_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE SET NULL,
  CONSTRAINT `WAL_SALES_ORDER_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Order';

--
-- Dumping data for table `wal_sales_order`
--


--
-- Table structure for table `wal_sales_order_address`
--

CREATE TABLE `wal_sales_order_address` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent ID',
  `customer_address_id` int(11) DEFAULT NULL COMMENT 'Customer Address ID',
  `quote_address_id` int(11) DEFAULT NULL COMMENT 'Quote Address ID',
  `region_id` int(11) DEFAULT NULL COMMENT 'Region ID',
  `customer_id` int(11) DEFAULT NULL COMMENT 'Customer ID',
  `fax` varchar(255) DEFAULT NULL COMMENT 'Fax',
  `region` varchar(255) DEFAULT NULL COMMENT 'Region',
  `postcode` varchar(255) DEFAULT NULL COMMENT 'Postcode',
  `lastname` varchar(255) DEFAULT NULL COMMENT 'Lastname',
  `street` varchar(255) DEFAULT NULL COMMENT 'Street',
  `city` varchar(255) DEFAULT NULL COMMENT 'City',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `telephone` varchar(255) DEFAULT NULL COMMENT 'Phone Number',
  `country_id` varchar(2) DEFAULT NULL COMMENT 'Country ID',
  `firstname` varchar(255) DEFAULT NULL COMMENT 'Firstname',
  `address_type` varchar(255) DEFAULT NULL COMMENT 'Address Type',
  `prefix` varchar(255) DEFAULT NULL COMMENT 'Prefix',
  `middlename` varchar(255) DEFAULT NULL COMMENT 'Middlename',
  `suffix` varchar(255) DEFAULT NULL COMMENT 'Suffix',
  `company` varchar(255) DEFAULT NULL COMMENT 'Company',
  `vat_id` text COMMENT 'Vat ID',
  `vat_is_valid` smallint(6) DEFAULT NULL COMMENT 'Vat Is Valid',
  `vat_request_id` text COMMENT 'Vat Request ID',
  `vat_request_date` text COMMENT 'Vat Request Date',
  `vat_request_success` smallint(6) DEFAULT NULL COMMENT 'Vat Request Success',
  `giftregistry_item_id` int(11) DEFAULT NULL COMMENT 'Giftregistry Item Id',
  PRIMARY KEY (`entity_id`),
  KEY `WAL_SALES_ORDER_ADDRESS_PARENT_ID` (`parent_id`),
  CONSTRAINT `WAL_SALES_ORDER_ADDRESS_PARENT_ID_WAL_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Order Address';

--
-- Dumping data for table `wal_sales_order_address`
--


--
-- Table structure for table `wal_sales_order_aggregated_created`
--

CREATE TABLE `wal_sales_order_aggregated_created` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `total_qty_ordered` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Qty Ordered',
  `total_qty_invoiced` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Qty Invoiced',
  `total_income_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Income Amount',
  `total_revenue_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Revenue Amount',
  `total_profit_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Profit Amount',
  `total_invoiced_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Invoiced Amount',
  `total_canceled_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Canceled Amount',
  `total_paid_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Paid Amount',
  `total_refunded_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Refunded Amount',
  `total_tax_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Tax Amount',
  `total_tax_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Tax Amount Actual',
  `total_shipping_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Shipping Amount',
  `total_shipping_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Shipping Amount Actual',
  `total_discount_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Discount Amount',
  `total_discount_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Discount Amount Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_SALES_ORDER_AGGREGATED_CREATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `WAL_SALES_ORDER_AGGREGATED_CREATED_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_SALES_ORDER_AGGREGATED_CREATED_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Aggregated Created';

--
-- Dumping data for table `wal_sales_order_aggregated_created`
--


--
-- Table structure for table `wal_sales_order_aggregated_updated`
--

CREATE TABLE `wal_sales_order_aggregated_updated` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `total_qty_ordered` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Qty Ordered',
  `total_qty_invoiced` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Qty Invoiced',
  `total_income_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Income Amount',
  `total_revenue_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Revenue Amount',
  `total_profit_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Profit Amount',
  `total_invoiced_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Invoiced Amount',
  `total_canceled_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Canceled Amount',
  `total_paid_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Paid Amount',
  `total_refunded_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Refunded Amount',
  `total_tax_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Tax Amount',
  `total_tax_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Tax Amount Actual',
  `total_shipping_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Shipping Amount',
  `total_shipping_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Shipping Amount Actual',
  `total_discount_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Discount Amount',
  `total_discount_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Discount Amount Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `WAL_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Aggregated Updated';

--
-- Dumping data for table `wal_sales_order_aggregated_updated`
--


--
-- Table structure for table `wal_sales_order_grid`
--

CREATE TABLE `wal_sales_order_grid` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `status` varchar(32) DEFAULT NULL COMMENT 'Status',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `store_name` varchar(255) DEFAULT NULL COMMENT 'Store Name',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  `base_total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Paid',
  `grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
  `total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Total Paid',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  `order_currency_code` varchar(255) DEFAULT NULL COMMENT 'Order Currency Code',
  `shipping_name` varchar(255) DEFAULT NULL COMMENT 'Shipping Name',
  `billing_name` varchar(255) DEFAULT NULL COMMENT 'Billing Name',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
  `shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
  `shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
  `customer_email` varchar(255) DEFAULT NULL COMMENT 'Customer Email',
  `customer_group` varchar(255) DEFAULT NULL COMMENT 'Customer Group',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `shipping_and_handling` decimal(20,4) DEFAULT NULL COMMENT 'Shipping and handling amount',
  `customer_name` varchar(255) DEFAULT NULL COMMENT 'Customer Name',
  `payment_method` varchar(255) DEFAULT NULL COMMENT 'Payment Method',
  `total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Refunded',
  `pickup_location_code` varchar(255) DEFAULT NULL COMMENT 'Pickup Location Code',
  `refunded_to_store_credit` decimal(20,4) DEFAULT NULL,
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `WAL_SALES_ORDER_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `WAL_SALES_ORDER_GRID_STATUS` (`status`),
  KEY `WAL_SALES_ORDER_GRID_STORE_ID` (`store_id`),
  KEY `WAL_SALES_ORDER_GRID_BASE_GRAND_TOTAL` (`base_grand_total`),
  KEY `WAL_SALES_ORDER_GRID_BASE_TOTAL_PAID` (`base_total_paid`),
  KEY `WAL_SALES_ORDER_GRID_GRAND_TOTAL` (`grand_total`),
  KEY `WAL_SALES_ORDER_GRID_TOTAL_PAID` (`total_paid`),
  KEY `WAL_SALES_ORDER_GRID_SHIPPING_NAME` (`shipping_name`),
  KEY `WAL_SALES_ORDER_GRID_BILLING_NAME` (`billing_name`),
  KEY `WAL_SALES_ORDER_GRID_CREATED_AT` (`created_at`),
  KEY `WAL_SALES_ORDER_GRID_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_SALES_ORDER_GRID_UPDATED_AT` (`updated_at`),
  KEY `WAL_SALES_ORDER_GRID_PICKUP_LOCATION_CODE` (`pickup_location_code`),
  FULLTEXT KEY `FTI_27E1A1CD213F6CDAC085E2FC756A220C` (`increment_id`,`billing_name`,`shipping_name`,`shipping_address`,`billing_address`,`customer_name`,`customer_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Order Grid';

--
-- Dumping data for table `wal_sales_order_grid`
--


--
-- Table structure for table `wal_sales_order_item`
--

CREATE TABLE `wal_sales_order_item` (
  `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Item ID',
  `order_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Order ID',
  `parent_item_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent Item ID',
  `quote_item_id` int(10) unsigned DEFAULT NULL COMMENT 'Quote Item ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product ID',
  `product_type` varchar(255) DEFAULT NULL COMMENT 'Product Type',
  `product_options` text COMMENT 'Product Options',
  `weight` decimal(12,4) DEFAULT '0.0000' COMMENT 'Weight',
  `is_virtual` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Virtual',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `applied_rule_ids` text COMMENT 'Applied Rule Ids',
  `additional_data` text COMMENT 'Additional Data',
  `is_qty_decimal` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Qty Decimal',
  `no_discount` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'No Discount',
  `qty_backordered` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Backordered',
  `qty_canceled` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Canceled',
  `qty_invoiced` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Invoiced',
  `qty_ordered` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Ordered',
  `qty_refunded` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Refunded',
  `qty_shipped` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Shipped',
  `base_cost` decimal(12,4) DEFAULT '0.0000' COMMENT 'Base Cost',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  `base_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Price',
  `original_price` decimal(12,4) DEFAULT NULL COMMENT 'Original Price',
  `base_original_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Original Price',
  `tax_percent` decimal(12,4) DEFAULT '0.0000' COMMENT 'Tax Percent',
  `tax_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Tax Amount',
  `base_tax_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Tax Amount',
  `tax_invoiced` decimal(20,4) DEFAULT '0.0000' COMMENT 'Tax Invoiced',
  `base_tax_invoiced` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Tax Invoiced',
  `discount_percent` decimal(12,4) DEFAULT '0.0000' COMMENT 'Discount Percent',
  `discount_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Discount Amount',
  `base_discount_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Discount Amount',
  `discount_invoiced` decimal(20,4) DEFAULT '0.0000' COMMENT 'Discount Invoiced',
  `base_discount_invoiced` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Discount Invoiced',
  `amount_refunded` decimal(20,4) DEFAULT '0.0000' COMMENT 'Amount Refunded',
  `base_amount_refunded` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Amount Refunded',
  `row_total` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Row Total',
  `base_row_total` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Row Total',
  `row_invoiced` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Row Invoiced',
  `base_row_invoiced` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Row Invoiced',
  `row_weight` decimal(12,4) DEFAULT '0.0000' COMMENT 'Row Weight',
  `base_tax_before_discount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Before Discount',
  `tax_before_discount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Before Discount',
  `ext_order_item_id` varchar(255) DEFAULT NULL COMMENT 'Ext Order Item ID',
  `locked_do_invoice` smallint(5) unsigned DEFAULT NULL COMMENT 'Locked Do Invoice',
  `locked_do_ship` smallint(5) unsigned DEFAULT NULL COMMENT 'Locked Do Ship',
  `price_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Price Incl Tax',
  `base_price_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
  `row_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
  `base_row_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
  `discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Invoiced',
  `base_discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Invoiced',
  `discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Refunded',
  `base_discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Refunded',
  `tax_canceled` decimal(12,4) DEFAULT NULL COMMENT 'Tax Canceled',
  `discount_tax_compensation_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Canceled',
  `tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Tax Refunded',
  `base_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Refunded',
  `discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Refunded',
  `base_discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Refunded',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
  `gift_message_available` int(11) DEFAULT NULL COMMENT 'Gift Message Available',
  `free_shipping` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Free Shipping',
  `event_id` int(11) DEFAULT NULL COMMENT 'Event Id',
  `giftregistry_item_id` int(11) DEFAULT NULL COMMENT 'Giftregistry Item Id',
  PRIMARY KEY (`item_id`),
  KEY `WAL_SALES_ORDER_ITEM_ORDER_ID` (`order_id`),
  KEY `WAL_SALES_ORDER_ITEM_STORE_ID` (`store_id`),
  KEY `WAL_SALES_ORDER_ITEM_PRODUCT_ID` (`product_id`),
  CONSTRAINT `WAL_SALES_ORDER_ITEM_ORDER_ID_WAL_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALES_ORDER_ITEM_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Order Item';

--
-- Dumping data for table `wal_sales_order_item`
--


--
-- Table structure for table `wal_sales_order_payment`
--

CREATE TABLE `wal_sales_order_payment` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `base_shipping_captured` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Captured',
  `shipping_captured` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Captured',
  `amount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Amount Refunded',
  `base_amount_paid` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Paid',
  `amount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Amount Canceled',
  `base_amount_authorized` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Authorized',
  `base_amount_paid_online` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Paid Online',
  `base_amount_refunded_online` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Refunded Online',
  `base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
  `shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
  `amount_paid` decimal(20,4) DEFAULT NULL COMMENT 'Amount Paid',
  `amount_authorized` decimal(20,4) DEFAULT NULL COMMENT 'Amount Authorized',
  `base_amount_ordered` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Ordered',
  `base_shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Refunded',
  `shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Refunded',
  `base_amount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Refunded',
  `amount_ordered` decimal(20,4) DEFAULT NULL COMMENT 'Amount Ordered',
  `base_amount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Canceled',
  `quote_payment_id` int(11) DEFAULT NULL COMMENT 'Quote Payment ID',
  `additional_data` text COMMENT 'Additional Data',
  `cc_exp_month` varchar(12) DEFAULT NULL COMMENT 'Cc Exp Month',
  `cc_ss_start_year` varchar(12) DEFAULT NULL COMMENT 'Cc Ss Start Year',
  `echeck_bank_name` varchar(128) DEFAULT NULL COMMENT 'Echeck Bank Name',
  `method` varchar(128) DEFAULT NULL COMMENT 'Method',
  `cc_debug_request_body` varchar(32) DEFAULT NULL COMMENT 'Cc Debug Request Body',
  `cc_secure_verify` varchar(32) DEFAULT NULL COMMENT 'Cc Secure Verify',
  `protection_eligibility` varchar(32) DEFAULT NULL COMMENT 'Protection Eligibility',
  `cc_approval` varchar(32) DEFAULT NULL COMMENT 'Cc Approval',
  `cc_last_4` varchar(100) DEFAULT NULL COMMENT 'Cc Last 4',
  `cc_status_description` varchar(32) DEFAULT NULL COMMENT 'Cc Status Description',
  `echeck_type` varchar(32) DEFAULT NULL COMMENT 'Echeck Type',
  `cc_debug_response_serialized` varchar(32) DEFAULT NULL COMMENT 'Cc Debug Response Serialized',
  `cc_ss_start_month` varchar(128) DEFAULT NULL COMMENT 'Cc Ss Start Month',
  `echeck_account_type` varchar(255) DEFAULT NULL COMMENT 'Echeck Account Type',
  `last_trans_id` varchar(255) DEFAULT NULL COMMENT 'Last Trans ID',
  `cc_cid_status` varchar(32) DEFAULT NULL COMMENT 'Cc Cid Status',
  `cc_owner` varchar(128) DEFAULT NULL COMMENT 'Cc Owner',
  `cc_type` varchar(32) DEFAULT NULL COMMENT 'Cc Type',
  `po_number` varchar(32) DEFAULT NULL COMMENT 'Po Number',
  `cc_exp_year` varchar(4) DEFAULT NULL COMMENT 'Cc Exp Year',
  `cc_status` varchar(4) DEFAULT NULL COMMENT 'Cc Status',
  `echeck_routing_number` varchar(32) DEFAULT NULL COMMENT 'Echeck Routing Number',
  `account_status` varchar(32) DEFAULT NULL COMMENT 'Account Status',
  `anet_trans_method` varchar(32) DEFAULT NULL COMMENT 'Anet Trans Method',
  `cc_debug_response_body` varchar(32) DEFAULT NULL COMMENT 'Cc Debug Response Body',
  `cc_ss_issue` varchar(32) DEFAULT NULL COMMENT 'Cc Ss Issue',
  `echeck_account_name` varchar(32) DEFAULT NULL COMMENT 'Echeck Account Name',
  `cc_avs_status` varchar(32) DEFAULT NULL COMMENT 'Cc Avs Status',
  `cc_number_enc` varchar(128) DEFAULT NULL,
  `cc_trans_id` varchar(32) DEFAULT NULL COMMENT 'Cc Trans ID',
  `address_status` varchar(32) DEFAULT NULL COMMENT 'Address Status',
  `additional_information` text COMMENT 'Additional Information',
  PRIMARY KEY (`entity_id`),
  KEY `WAL_SALES_ORDER_PAYMENT_PARENT_ID` (`parent_id`),
  CONSTRAINT `WAL_SALES_ORDER_PAYMENT_PARENT_ID_WAL_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Order Payment';

--
-- Dumping data for table `wal_sales_order_payment`
--


--
-- Table structure for table `wal_sales_order_status`
--

CREATE TABLE `wal_sales_order_status` (
  `status` varchar(32) NOT NULL COMMENT 'Status',
  `label` varchar(128) NOT NULL COMMENT 'Label',
  PRIMARY KEY (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Status Table';

--
-- Dumping data for table `wal_sales_order_status`
--

INSERT INTO `wal_sales_order_status` VALUES ('canceled','Canceled'),('closed','Closed'),('complete','Complete'),('fraud','Suspected Fraud'),('holded','On Hold'),('payment_review','Payment Review'),('paypal_canceled_reversal','PayPal Canceled Reversal'),('paypal_reversed','PayPal Reversed'),('pending','Pending'),('pending_payment','Pending Payment'),('pending_paypal','Pending PayPal'),('processing','Processing');

--
-- Table structure for table `wal_sales_order_status_history`
--

CREATE TABLE `wal_sales_order_status_history` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `is_customer_notified` int(11) DEFAULT NULL COMMENT 'Is Customer Notified',
  `is_visible_on_front` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible On Front',
  `comment` text COMMENT 'Comment',
  `status` varchar(32) DEFAULT NULL COMMENT 'Status',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `entity_name` varchar(32) DEFAULT NULL COMMENT 'Shows what entity history is bind to.',
  PRIMARY KEY (`entity_id`),
  KEY `WAL_SALES_ORDER_STATUS_HISTORY_PARENT_ID` (`parent_id`),
  KEY `WAL_SALES_ORDER_STATUS_HISTORY_CREATED_AT` (`created_at`),
  CONSTRAINT `WAL_SALES_ORDER_STS_HISTORY_PARENT_ID_WAL_SALES_ORDER_ENTT_ID` FOREIGN KEY (`parent_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Order Status History';

--
-- Dumping data for table `wal_sales_order_status_history`
--


--
-- Table structure for table `wal_sales_order_status_label`
--

CREATE TABLE `wal_sales_order_status_label` (
  `status` varchar(32) NOT NULL COMMENT 'Status',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `label` varchar(128) NOT NULL COMMENT 'Label',
  PRIMARY KEY (`status`,`store_id`),
  KEY `WAL_SALES_ORDER_STATUS_LABEL_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_SALES_ORDER_STATUS_LABEL_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALES_ORDER_STS_LBL_STS_WAL_SALES_ORDER_STS_STS` FOREIGN KEY (`status`) REFERENCES `wal_sales_order_status` (`status`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Status Label Table';

--
-- Dumping data for table `wal_sales_order_status_label`
--


--
-- Table structure for table `wal_sales_order_status_state`
--

CREATE TABLE `wal_sales_order_status_state` (
  `status` varchar(32) NOT NULL COMMENT 'Status',
  `state` varchar(32) NOT NULL COMMENT 'Label',
  `is_default` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Default',
  `visible_on_front` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Visible on front',
  PRIMARY KEY (`status`,`state`),
  CONSTRAINT `WAL_SALES_ORDER_STS_STATE_STS_WAL_SALES_ORDER_STS_STS` FOREIGN KEY (`status`) REFERENCES `wal_sales_order_status` (`status`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Status Table';

--
-- Dumping data for table `wal_sales_order_status_state`
--

INSERT INTO `wal_sales_order_status_state` VALUES ('canceled','canceled',1,1),('closed','closed',1,1),('complete','complete',1,1),('fraud','payment_review',0,1),('fraud','processing',0,1),('holded','holded',1,1),('payment_review','payment_review',1,1),('pending','new',1,1),('pending_payment','pending_payment',1,0),('processing','processing',1,1);

--
-- Table structure for table `wal_sales_order_tax`
--

CREATE TABLE `wal_sales_order_tax` (
  `tax_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tax ID',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `code` varchar(255) DEFAULT NULL COMMENT 'Code',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `percent` decimal(12,4) DEFAULT NULL COMMENT 'Percent',
  `amount` decimal(20,4) DEFAULT NULL COMMENT 'Amount',
  `priority` int(11) NOT NULL COMMENT 'Priority',
  `position` int(11) NOT NULL COMMENT 'Position',
  `base_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount',
  `process` smallint(6) NOT NULL COMMENT 'Process',
  `base_real_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Real Amount',
  PRIMARY KEY (`tax_id`),
  KEY `WAL_SALES_ORDER_TAX_ORDER_ID_PRIORITY_POSITION` (`order_id`,`priority`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Tax Table';

--
-- Dumping data for table `wal_sales_order_tax`
--


--
-- Table structure for table `wal_sales_order_tax_item`
--

CREATE TABLE `wal_sales_order_tax_item` (
  `tax_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tax Item ID',
  `tax_id` int(10) unsigned NOT NULL COMMENT 'Tax ID',
  `item_id` int(10) unsigned DEFAULT NULL COMMENT 'Item ID',
  `tax_percent` decimal(12,4) NOT NULL COMMENT 'Real Tax Percent For Item',
  `amount` decimal(20,4) NOT NULL COMMENT 'Tax amount for the item and tax rate',
  `base_amount` decimal(20,4) NOT NULL COMMENT 'Base tax amount for the item and tax rate',
  `real_amount` decimal(20,4) NOT NULL COMMENT 'Real tax amount for the item and tax rate',
  `real_base_amount` decimal(20,4) NOT NULL COMMENT 'Real base tax amount for the item and tax rate',
  `associated_item_id` int(10) unsigned DEFAULT NULL COMMENT 'Id of the associated item',
  `taxable_item_type` varchar(32) NOT NULL COMMENT 'Type of the taxable item',
  PRIMARY KEY (`tax_item_id`),
  UNIQUE KEY `WAL_SALES_ORDER_TAX_ITEM_TAX_ID_ITEM_ID` (`tax_id`,`item_id`),
  KEY `FK_B76552E6B313048A8490913FFD98297F` (`associated_item_id`),
  KEY `WAL_SALES_ORDER_TAX_ITEM_ITEM_ID` (`item_id`),
  CONSTRAINT `FK_B76552E6B313048A8490913FFD98297F` FOREIGN KEY (`associated_item_id`) REFERENCES `wal_sales_order_item` (`item_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALES_ORDER_TAX_ITEM_ITEM_ID_WAL_SALES_ORDER_ITEM_ITEM_ID` FOREIGN KEY (`item_id`) REFERENCES `wal_sales_order_item` (`item_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALES_ORDER_TAX_ITEM_TAX_ID_WAL_SALES_ORDER_TAX_TAX_ID` FOREIGN KEY (`tax_id`) REFERENCES `wal_sales_order_tax` (`tax_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Tax Item';

--
-- Dumping data for table `wal_sales_order_tax_item`
--


--
-- Table structure for table `wal_sales_payment_transaction`
--

CREATE TABLE `wal_sales_payment_transaction` (
  `transaction_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Transaction ID',
  `parent_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent ID',
  `order_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Order ID',
  `payment_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Payment ID',
  `txn_id` varchar(100) DEFAULT NULL COMMENT 'Txn ID',
  `parent_txn_id` varchar(100) DEFAULT NULL COMMENT 'Parent Txn ID',
  `txn_type` varchar(15) DEFAULT NULL COMMENT 'Txn Type',
  `is_closed` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Closed',
  `additional_information` blob COMMENT 'Additional Information',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  PRIMARY KEY (`transaction_id`),
  UNIQUE KEY `WAL_SALES_PAYMENT_TRANSACTION_ORDER_ID_PAYMENT_ID_TXN_ID` (`order_id`,`payment_id`,`txn_id`),
  KEY `WAL_SALES_PAYMENT_TRANSACTION_PARENT_ID` (`parent_id`),
  KEY `WAL_SALES_PAYMENT_TRANSACTION_PAYMENT_ID` (`payment_id`),
  CONSTRAINT `FK_2089BFE241BE94F62ABAED4BDDD20763` FOREIGN KEY (`payment_id`) REFERENCES `wal_sales_order_payment` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_A6B1267A9A1E1C4C60D06A9BFEA143F8` FOREIGN KEY (`parent_id`) REFERENCES `wal_sales_payment_transaction` (`transaction_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALES_PAYMENT_TRANSACTION_ORDER_ID_WAL_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Payment Transaction';

--
-- Dumping data for table `wal_sales_payment_transaction`
--


--
-- Table structure for table `wal_sales_refunded_aggregated`
--

CREATE TABLE `wal_sales_refunded_aggregated` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `refunded` decimal(20,4) DEFAULT NULL COMMENT 'Refunded',
  `online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Online Refunded',
  `offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Offline Refunded',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_SALES_REFUNDED_AGGREGATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `WAL_SALES_REFUNDED_AGGREGATED_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_SALES_REFUNDED_AGGREGATED_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Refunded Aggregated';

--
-- Dumping data for table `wal_sales_refunded_aggregated`
--


--
-- Table structure for table `wal_sales_refunded_aggregated_order`
--

CREATE TABLE `wal_sales_refunded_aggregated_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `refunded` decimal(20,4) DEFAULT NULL COMMENT 'Refunded',
  `online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Online Refunded',
  `offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Offline Refunded',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_SALES_REFUNDED_AGGREGATED_ORDER_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `WAL_SALES_REFUNDED_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_SALES_REFUNDED_AGGREGATED_ORDER_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Refunded Aggregated Order';

--
-- Dumping data for table `wal_sales_refunded_aggregated_order`
--


--
-- Table structure for table `wal_sales_sequence_meta`
--

CREATE TABLE `wal_sales_sequence_meta` (
  `meta_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `entity_type` varchar(32) NOT NULL COMMENT 'Prefix',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `sequence_table` varchar(64) NOT NULL COMMENT 'table for sequence',
  PRIMARY KEY (`meta_id`),
  UNIQUE KEY `WAL_SALES_SEQUENCE_META_ENTITY_TYPE_STORE_ID` (`entity_type`,`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='sales_sequence_meta';

--
-- Dumping data for table `wal_sales_sequence_meta`
--

INSERT INTO `wal_sales_sequence_meta` VALUES (1,'order',0,'wal_sequence_order_0'),(2,'invoice',0,'wal_sequence_invoice_0'),(3,'creditmemo',0,'wal_sequence_creditmemo_0'),(4,'shipment',0,'wal_sequence_shipment_0'),(5,'order',1,'wal_sequence_order_1'),(6,'invoice',1,'wal_sequence_invoice_1'),(7,'creditmemo',1,'wal_sequence_creditmemo_1'),(8,'shipment',1,'wal_sequence_shipment_1');

--
-- Table structure for table `wal_sales_sequence_profile`
--

CREATE TABLE `wal_sales_sequence_profile` (
  `profile_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `meta_id` int(10) unsigned NOT NULL COMMENT 'Meta_id',
  `prefix` varchar(32) DEFAULT NULL COMMENT 'Prefix',
  `suffix` varchar(32) DEFAULT NULL COMMENT 'Suffix',
  `start_value` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'Start value for sequence',
  `step` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'Step for sequence',
  `max_value` int(10) unsigned NOT NULL COMMENT 'MaxValue for sequence',
  `warning_value` int(10) unsigned NOT NULL COMMENT 'WarningValue for sequence',
  `is_active` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'isActive flag',
  PRIMARY KEY (`profile_id`),
  UNIQUE KEY `WAL_SALES_SEQUENCE_PROFILE_META_ID_PREFIX_SUFFIX` (`meta_id`,`prefix`,`suffix`),
  CONSTRAINT `FK_971E5DDAEB7980524CFE35B1904DF8BE` FOREIGN KEY (`meta_id`) REFERENCES `wal_sales_sequence_meta` (`meta_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='sales_sequence_profile';

--
-- Dumping data for table `wal_sales_sequence_profile`
--

INSERT INTO `wal_sales_sequence_profile` VALUES (1,1,NULL,NULL,1,1,4294967295,4294966295,1),(2,2,NULL,NULL,1,1,4294967295,4294966295,1),(3,3,NULL,NULL,1,1,4294967295,4294966295,1),(4,4,NULL,NULL,1,1,4294967295,4294966295,1),(5,5,NULL,NULL,1,1,4294967295,4294966295,1),(6,6,NULL,NULL,1,1,4294967295,4294966295,1),(7,7,NULL,NULL,1,1,4294967295,4294966295,1),(8,8,NULL,NULL,1,1,4294967295,4294966295,1);

--
-- Table structure for table `wal_sales_shipment`
--

CREATE TABLE `wal_sales_shipment` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `total_weight` decimal(12,4) DEFAULT NULL COMMENT 'Total Weight',
  `total_qty` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty',
  `email_sent` smallint(5) unsigned DEFAULT NULL COMMENT 'Email Sent',
  `send_email` smallint(5) unsigned DEFAULT NULL COMMENT 'Send Email',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `customer_id` int(11) DEFAULT NULL COMMENT 'Customer ID',
  `shipping_address_id` int(11) DEFAULT NULL COMMENT 'Shipping Address ID',
  `billing_address_id` int(11) DEFAULT NULL COMMENT 'Billing Address ID',
  `shipment_status` int(11) DEFAULT NULL COMMENT 'Shipment Status',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `packages` text COMMENT 'Packed Products in Packages',
  `shipping_label` mediumblob COMMENT 'Shipping Label Content',
  `customer_note` text COMMENT 'Customer Note',
  `customer_note_notify` smallint(5) unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `WAL_SALES_SHIPMENT_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `WAL_SALES_SHIPMENT_STORE_ID` (`store_id`),
  KEY `WAL_SALES_SHIPMENT_TOTAL_QTY` (`total_qty`),
  KEY `WAL_SALES_SHIPMENT_ORDER_ID` (`order_id`),
  KEY `WAL_SALES_SHIPMENT_CREATED_AT` (`created_at`),
  KEY `WAL_SALES_SHIPMENT_UPDATED_AT` (`updated_at`),
  KEY `WAL_SALES_SHIPMENT_SEND_EMAIL` (`send_email`),
  KEY `WAL_SALES_SHIPMENT_EMAIL_SENT` (`email_sent`),
  CONSTRAINT `WAL_SALES_SHIPMENT_ORDER_ID_WAL_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALES_SHIPMENT_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Shipment';

--
-- Dumping data for table `wal_sales_shipment`
--


--
-- Table structure for table `wal_sales_shipment_comment`
--

CREATE TABLE `wal_sales_shipment_comment` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `is_customer_notified` int(11) DEFAULT NULL COMMENT 'Is Customer Notified',
  `is_visible_on_front` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible On Front',
  `comment` text COMMENT 'Comment',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  PRIMARY KEY (`entity_id`),
  KEY `WAL_SALES_SHIPMENT_COMMENT_CREATED_AT` (`created_at`),
  KEY `WAL_SALES_SHIPMENT_COMMENT_PARENT_ID` (`parent_id`),
  CONSTRAINT `WAL_SALES_SHIPMENT_COMMENT_PARENT_ID_WAL_SALES_SHIPMENT_ENTT_ID` FOREIGN KEY (`parent_id`) REFERENCES `wal_sales_shipment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Shipment Comment';

--
-- Dumping data for table `wal_sales_shipment_comment`
--


--
-- Table structure for table `wal_sales_shipment_grid`
--

CREATE TABLE `wal_sales_shipment_grid` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_increment_id` varchar(32) NOT NULL COMMENT 'Order Increment ID',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `order_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Order Increment ID',
  `customer_name` varchar(128) NOT NULL COMMENT 'Customer Name',
  `total_qty` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty',
  `shipment_status` int(11) DEFAULT NULL COMMENT 'Shipment Status',
  `order_status` varchar(32) DEFAULT NULL COMMENT 'Order',
  `billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
  `shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
  `billing_name` varchar(128) DEFAULT NULL COMMENT 'Billing Name',
  `shipping_name` varchar(128) DEFAULT NULL COMMENT 'Shipping Name',
  `customer_email` varchar(128) DEFAULT NULL COMMENT 'Customer Email',
  `customer_group_id` int(11) DEFAULT NULL,
  `payment_method` varchar(32) DEFAULT NULL COMMENT 'Payment Method',
  `shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `WAL_SALES_SHIPMENT_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `WAL_SALES_SHIPMENT_GRID_STORE_ID` (`store_id`),
  KEY `WAL_SALES_SHIPMENT_GRID_TOTAL_QTY` (`total_qty`),
  KEY `WAL_SALES_SHIPMENT_GRID_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `WAL_SALES_SHIPMENT_GRID_SHIPMENT_STATUS` (`shipment_status`),
  KEY `WAL_SALES_SHIPMENT_GRID_ORDER_STATUS` (`order_status`),
  KEY `WAL_SALES_SHIPMENT_GRID_CREATED_AT` (`created_at`),
  KEY `WAL_SALES_SHIPMENT_GRID_UPDATED_AT` (`updated_at`),
  KEY `WAL_SALES_SHIPMENT_GRID_ORDER_CREATED_AT` (`order_created_at`),
  KEY `WAL_SALES_SHIPMENT_GRID_SHIPPING_NAME` (`shipping_name`),
  KEY `WAL_SALES_SHIPMENT_GRID_BILLING_NAME` (`billing_name`),
  KEY `WAL_SALES_SHIPMENT_GRID_ORDER_ID` (`order_id`),
  FULLTEXT KEY `FTI_019CE6803E0C20D512E0E50D3905BFDE` (`increment_id`,`order_increment_id`,`shipping_name`,`customer_name`,`customer_email`,`billing_address`,`shipping_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Shipment Grid';

--
-- Dumping data for table `wal_sales_shipment_grid`
--


--
-- Table structure for table `wal_sales_shipment_item`
--

CREATE TABLE `wal_sales_shipment_item` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `row_total` decimal(20,4) DEFAULT NULL COMMENT 'Row Total',
  `price` decimal(20,4) DEFAULT NULL COMMENT 'Price',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
  `qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
  `product_id` int(11) DEFAULT NULL COMMENT 'Product ID',
  `order_item_id` int(11) DEFAULT NULL COMMENT 'Order Item ID',
  `additional_data` text COMMENT 'Additional Data',
  `description` text COMMENT 'Description',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  PRIMARY KEY (`entity_id`),
  KEY `WAL_SALES_SHIPMENT_ITEM_PARENT_ID` (`parent_id`),
  CONSTRAINT `WAL_SALES_SHIPMENT_ITEM_PARENT_ID_WAL_SALES_SHIPMENT_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `wal_sales_shipment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Shipment Item';

--
-- Dumping data for table `wal_sales_shipment_item`
--


--
-- Table structure for table `wal_sales_shipment_track`
--

CREATE TABLE `wal_sales_shipment_track` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
  `qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `track_number` text COMMENT 'Number',
  `description` text COMMENT 'Description',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `carrier_code` varchar(32) DEFAULT NULL COMMENT 'Carrier Code',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`),
  KEY `WAL_SALES_SHIPMENT_TRACK_PARENT_ID` (`parent_id`),
  KEY `WAL_SALES_SHIPMENT_TRACK_ORDER_ID` (`order_id`),
  KEY `WAL_SALES_SHIPMENT_TRACK_CREATED_AT` (`created_at`),
  CONSTRAINT `WAL_SALES_SHIPMENT_TRACK_PARENT_ID_WAL_SALES_SHIPMENT_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `wal_sales_shipment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Shipment Track';

--
-- Dumping data for table `wal_sales_shipment_track`
--


--
-- Table structure for table `wal_sales_shipping_aggregated`
--

CREATE TABLE `wal_sales_shipping_aggregated` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
  `orders_count` int(11) NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `total_shipping` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping',
  `total_shipping_actual` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_SALES_SHPP_AGGRED_PERIOD_STORE_ID_ORDER_STS_SHPP_DESCRIPTION` (`period`,`store_id`,`order_status`,`shipping_description`),
  KEY `WAL_SALES_SHIPPING_AGGREGATED_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_SALES_SHIPPING_AGGREGATED_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Shipping Aggregated';

--
-- Dumping data for table `wal_sales_shipping_aggregated`
--


--
-- Table structure for table `wal_sales_shipping_aggregated_order`
--

CREATE TABLE `wal_sales_shipping_aggregated_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
  `orders_count` int(11) NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `total_shipping` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping',
  `total_shipping_actual` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNQ_A389042216740D83FB13A93A757FEB1D` (`period`,`store_id`,`order_status`,`shipping_description`),
  KEY `WAL_SALES_SHIPPING_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_SALES_SHIPPING_AGGREGATED_ORDER_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Shipping Aggregated Order';

--
-- Dumping data for table `wal_sales_shipping_aggregated_order`
--


--
-- Table structure for table `wal_salesrule`
--

CREATE TABLE `wal_salesrule` (
  `rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `from_date` date DEFAULT NULL COMMENT 'From',
  `to_date` date DEFAULT NULL COMMENT 'To',
  `uses_per_customer` int(11) NOT NULL DEFAULT '0' COMMENT 'Uses Per Customer',
  `is_active` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `conditions_serialized` mediumtext COMMENT 'Conditions Serialized',
  `actions_serialized` mediumtext COMMENT 'Actions Serialized',
  `stop_rules_processing` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Stop Rules Processing',
  `is_advanced` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Advanced',
  `product_ids` text COMMENT 'Product Ids',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `simple_action` varchar(32) DEFAULT NULL COMMENT 'Simple Action',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Discount Amount',
  `discount_qty` decimal(12,4) DEFAULT NULL COMMENT 'Discount Qty',
  `discount_step` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Discount Step',
  `apply_to_shipping` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Apply To Shipping',
  `times_used` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Times Used',
  `is_rss` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Is Rss',
  `coupon_type` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Coupon Type',
  `use_auto_generation` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Use Auto Generation',
  `uses_per_coupon` int(11) NOT NULL DEFAULT '0' COMMENT 'User Per Coupon',
  `simple_free_shipping` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Simple Free Shipping',
  PRIMARY KEY (`rule_id`),
  KEY `WAL_SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE` (`is_active`,`sort_order`,`to_date`,`from_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule';

--
-- Dumping data for table `wal_salesrule`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`djfwalland_walland`@`localhost`*/ /*!50003 TRIGGER trg_wal_salesrule_after_insert AFTER INSERT ON wal_salesrule FOR EACH ROW
BEGIN
INSERT IGNORE INTO `wal_salesrule_rule_cl` (`entity_id`) VALUES (NEW.`rule_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`djfwalland_walland`@`localhost`*/ /*!50003 TRIGGER trg_wal_salesrule_after_update AFTER UPDATE ON wal_salesrule FOR EACH ROW
BEGIN
IF (NOT(NEW.`rule_id` <=> OLD.`rule_id`) OR NOT(NEW.`name` <=> OLD.`name`) OR NOT(NEW.`description` <=> OLD.`description`) OR NOT(NEW.`from_date` <=> OLD.`from_date`) OR NOT(NEW.`to_date` <=> OLD.`to_date`) OR NOT(NEW.`uses_per_customer` <=> OLD.`uses_per_customer`) OR NOT(NEW.`is_active` <=> OLD.`is_active`) OR NOT(NEW.`conditions_serialized` <=> OLD.`conditions_serialized`) OR NOT(NEW.`actions_serialized` <=> OLD.`actions_serialized`) OR NOT(NEW.`stop_rules_processing` <=> OLD.`stop_rules_processing`) OR NOT(NEW.`is_advanced` <=> OLD.`is_advanced`) OR NOT(NEW.`product_ids` <=> OLD.`product_ids`) OR NOT(NEW.`sort_order` <=> OLD.`sort_order`) OR NOT(NEW.`simple_action` <=> OLD.`simple_action`) OR NOT(NEW.`discount_amount` <=> OLD.`discount_amount`) OR NOT(NEW.`discount_qty` <=> OLD.`discount_qty`) OR NOT(NEW.`discount_step` <=> OLD.`discount_step`) OR NOT(NEW.`apply_to_shipping` <=> OLD.`apply_to_shipping`) OR NOT(NEW.`times_used` <=> OLD.`times_used`) OR NOT(NEW.`is_rss` <=> OLD.`is_rss`) OR NOT(NEW.`coupon_type` <=> OLD.`coupon_type`) OR NOT(NEW.`use_auto_generation` <=> OLD.`use_auto_generation`) OR NOT(NEW.`uses_per_coupon` <=> OLD.`uses_per_coupon`) OR NOT(NEW.`simple_free_shipping` <=> OLD.`simple_free_shipping`)) THEN INSERT IGNORE INTO `wal_salesrule_rule_cl` (`entity_id`) VALUES (NEW.`rule_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`djfwalland_walland`@`localhost`*/ /*!50003 TRIGGER trg_wal_salesrule_after_delete AFTER DELETE ON wal_salesrule FOR EACH ROW
BEGIN
INSERT IGNORE INTO `wal_salesrule_rule_cl` (`entity_id`) VALUES (OLD.`rule_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `wal_salesrule_coupon`
--

CREATE TABLE `wal_salesrule_coupon` (
  `coupon_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Coupon ID',
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
  `code` varchar(255) DEFAULT NULL COMMENT 'Code',
  `usage_limit` int(10) unsigned DEFAULT NULL COMMENT 'Usage Limit',
  `usage_per_customer` int(10) unsigned DEFAULT NULL COMMENT 'Usage Per Customer',
  `times_used` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Times Used',
  `expiration_date` datetime DEFAULT NULL COMMENT 'Expiration Date',
  `is_primary` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Primary',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Coupon Code Creation Date',
  `type` smallint(6) DEFAULT '0' COMMENT 'Coupon Code Type',
  `generated_by_dotmailer` smallint(6) DEFAULT NULL COMMENT '1 = Generated by dotmailer',
  PRIMARY KEY (`coupon_id`),
  UNIQUE KEY `WAL_SALESRULE_COUPON_CODE` (`code`),
  UNIQUE KEY `WAL_SALESRULE_COUPON_RULE_ID_IS_PRIMARY` (`rule_id`,`is_primary`),
  KEY `WAL_SALESRULE_COUPON_RULE_ID` (`rule_id`),
  CONSTRAINT `WAL_SALESRULE_COUPON_RULE_ID_WAL_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `wal_salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Coupon';

--
-- Dumping data for table `wal_salesrule_coupon`
--


--
-- Table structure for table `wal_salesrule_coupon_aggregated`
--

CREATE TABLE `wal_salesrule_coupon_aggregated` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `coupon_code` varchar(50) DEFAULT NULL COMMENT 'Coupon Code',
  `coupon_uses` int(11) NOT NULL DEFAULT '0' COMMENT 'Coupon Uses',
  `subtotal_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Subtotal Amount',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Discount Amount',
  `total_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Amount',
  `subtotal_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Subtotal Amount Actual',
  `discount_amount_actual` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Discount Amount Actual',
  `total_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Amount Actual',
  `rule_name` varchar(255) DEFAULT NULL COMMENT 'Rule Name',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNQ_4A0B7AA63C92950D30DE9C0A98DD1409` (`period`,`store_id`,`order_status`,`coupon_code`),
  KEY `WAL_SALESRULE_COUPON_AGGREGATED_STORE_ID` (`store_id`),
  KEY `WAL_SALESRULE_COUPON_AGGREGATED_RULE_NAME` (`rule_name`),
  CONSTRAINT `WAL_SALESRULE_COUPON_AGGREGATED_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Coupon Aggregated';

--
-- Dumping data for table `wal_salesrule_coupon_aggregated`
--


--
-- Table structure for table `wal_salesrule_coupon_aggregated_order`
--

CREATE TABLE `wal_salesrule_coupon_aggregated_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `coupon_code` varchar(50) DEFAULT NULL COMMENT 'Coupon Code',
  `coupon_uses` int(11) NOT NULL DEFAULT '0' COMMENT 'Coupon Uses',
  `subtotal_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Subtotal Amount',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Discount Amount',
  `total_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Amount',
  `rule_name` varchar(255) DEFAULT NULL COMMENT 'Rule Name',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNQ_7F8C391DF6D29BCE77020371D45B38C4` (`period`,`store_id`,`order_status`,`coupon_code`),
  KEY `WAL_SALESRULE_COUPON_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  KEY `WAL_SALESRULE_COUPON_AGGREGATED_ORDER_RULE_NAME` (`rule_name`),
  CONSTRAINT `WAL_SALESRULE_COUPON_AGGRED_ORDER_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Coupon Aggregated Order';

--
-- Dumping data for table `wal_salesrule_coupon_aggregated_order`
--


--
-- Table structure for table `wal_salesrule_coupon_aggregated_updated`
--

CREATE TABLE `wal_salesrule_coupon_aggregated_updated` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `coupon_code` varchar(50) DEFAULT NULL COMMENT 'Coupon Code',
  `coupon_uses` int(11) NOT NULL DEFAULT '0' COMMENT 'Coupon Uses',
  `subtotal_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Subtotal Amount',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Discount Amount',
  `total_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Amount',
  `subtotal_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Subtotal Amount Actual',
  `discount_amount_actual` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Discount Amount Actual',
  `total_amount_actual` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Total Amount Actual',
  `rule_name` varchar(255) DEFAULT NULL COMMENT 'Rule Name',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNQ_8FFA3DD600D690F04C328C4F8FDD5E78` (`period`,`store_id`,`order_status`,`coupon_code`),
  KEY `WAL_SALESRULE_COUPON_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
  KEY `WAL_SALESRULE_COUPON_AGGREGATED_UPDATED_RULE_NAME` (`rule_name`),
  CONSTRAINT `WAL_SALESRULE_COUPON_AGGRED_UPDATED_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Coupon Aggregated Updated';

--
-- Dumping data for table `wal_salesrule_coupon_aggregated_updated`
--


--
-- Table structure for table `wal_salesrule_coupon_usage`
--

CREATE TABLE `wal_salesrule_coupon_usage` (
  `coupon_id` int(10) unsigned NOT NULL COMMENT 'Coupon ID',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  `times_used` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Times Used',
  PRIMARY KEY (`coupon_id`,`customer_id`),
  KEY `WAL_SALESRULE_COUPON_USAGE_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `FK_5905E2B21144A6B2D1E8E02AFDAD90F4` FOREIGN KEY (`coupon_id`) REFERENCES `wal_salesrule_coupon` (`coupon_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALESRULE_COUPON_USAGE_CSTR_ID_WAL_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Coupon Usage';

--
-- Dumping data for table `wal_salesrule_coupon_usage`
--


--
-- Table structure for table `wal_salesrule_customer`
--

CREATE TABLE `wal_salesrule_customer` (
  `rule_customer_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule Customer ID',
  `rule_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Rule ID',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer ID',
  `times_used` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Times Used',
  PRIMARY KEY (`rule_customer_id`),
  KEY `WAL_SALESRULE_CUSTOMER_RULE_ID_CUSTOMER_ID` (`rule_id`,`customer_id`),
  KEY `WAL_SALESRULE_CUSTOMER_CUSTOMER_ID_RULE_ID` (`customer_id`,`rule_id`),
  CONSTRAINT `WAL_SALESRULE_CUSTOMER_CUSTOMER_ID_WAL_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALESRULE_CUSTOMER_RULE_ID_WAL_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `wal_salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Customer';

--
-- Dumping data for table `wal_salesrule_customer`
--


--
-- Table structure for table `wal_salesrule_customer_group`
--

CREATE TABLE `wal_salesrule_customer_group` (
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
  `customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
  PRIMARY KEY (`rule_id`,`customer_group_id`),
  KEY `WAL_SALESRULE_CUSTOMER_GROUP_CUSTOMER_GROUP_ID` (`customer_group_id`),
  CONSTRAINT `FK_9E1B4488E9E332B9FC485B011A828B00` FOREIGN KEY (`customer_group_id`) REFERENCES `wal_customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALESRULE_CUSTOMER_GROUP_RULE_ID_WAL_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `wal_salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Rules To Customer Groups Relations';

--
-- Dumping data for table `wal_salesrule_customer_group`
--


--
-- Table structure for table `wal_salesrule_label`
--

CREATE TABLE `wal_salesrule_label` (
  `label_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Label ID',
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `label` varchar(255) DEFAULT NULL COMMENT 'Label',
  PRIMARY KEY (`label_id`),
  UNIQUE KEY `WAL_SALESRULE_LABEL_RULE_ID_STORE_ID` (`rule_id`,`store_id`),
  KEY `WAL_SALESRULE_LABEL_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_SALESRULE_LABEL_RULE_ID_WAL_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `wal_salesrule` (`rule_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALESRULE_LABEL_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Label';

--
-- Dumping data for table `wal_salesrule_label`
--


--
-- Table structure for table `wal_salesrule_product_attribute`
--

CREATE TABLE `wal_salesrule_product_attribute` (
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  PRIMARY KEY (`rule_id`,`website_id`,`customer_group_id`,`attribute_id`),
  KEY `WAL_SALESRULE_PRODUCT_ATTRIBUTE_WEBSITE_ID` (`website_id`),
  KEY `WAL_SALESRULE_PRODUCT_ATTRIBUTE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `WAL_SALESRULE_PRODUCT_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `FK_469B9A60D03C555C10D1FEF3CBE3C706` FOREIGN KEY (`customer_group_id`) REFERENCES `wal_customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALESRULE_PRD_ATTR_ATTR_ID_WAL_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `wal_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALESRULE_PRD_ATTR_WS_ID_WAL_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALESRULE_PRODUCT_ATTRIBUTE_RULE_ID_WAL_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `wal_salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Product Attribute';

--
-- Dumping data for table `wal_salesrule_product_attribute`
--


--
-- Table structure for table `wal_salesrule_rule_cl`
--

CREATE TABLE `wal_salesrule_rule_cl` (
  `version_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Version ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  PRIMARY KEY (`version_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_salesrule_rule_cl';

--
-- Dumping data for table `wal_salesrule_rule_cl`
--


--
-- Table structure for table `wal_salesrule_website`
--

CREATE TABLE `wal_salesrule_website` (
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  PRIMARY KEY (`rule_id`,`website_id`),
  KEY `WAL_SALESRULE_WEBSITE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `WAL_SALESRULE_WEBSITE_RULE_ID_WAL_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `wal_salesrule` (`rule_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SALESRULE_WEBSITE_WEBSITE_ID_WAL_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Rules To Websites Relations';

--
-- Dumping data for table `wal_salesrule_website`
--


--
-- Table structure for table `wal_search_query`
--

CREATE TABLE `wal_search_query` (
  `query_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Query ID',
  `query_text` varchar(255) DEFAULT NULL COMMENT 'Query text',
  `num_results` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Num results',
  `popularity` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Popularity',
  `redirect` varchar(255) DEFAULT NULL COMMENT 'Redirect',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `display_in_terms` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Display in terms',
  `is_active` smallint(6) DEFAULT '1' COMMENT 'Active status',
  `is_processed` smallint(6) DEFAULT '0' COMMENT 'Processed status',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated at',
  PRIMARY KEY (`query_id`),
  UNIQUE KEY `WAL_SEARCH_QUERY_QUERY_TEXT_STORE_ID` (`query_text`,`store_id`),
  KEY `WAL_SEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY` (`query_text`,`store_id`,`popularity`),
  KEY `WAL_SEARCH_QUERY_STORE_ID` (`store_id`),
  KEY `WAL_SEARCH_QUERY_IS_PROCESSED` (`is_processed`),
  KEY `WAL_SEARCH_QUERY_STORE_ID_POPULARITY` (`store_id`,`popularity`),
  CONSTRAINT `WAL_SEARCH_QUERY_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='Search query table';

--
-- Dumping data for table `wal_search_query`
--

INSERT INTO `wal_search_query` VALUES (1,'123',0,1,NULL,1,1,1,0,'2020-06-08 09:05:42'),(2,'test',0,3,NULL,1,1,1,0,'2023-06-08 09:12:27'),(8,'demo',1,3,NULL,1,1,1,0,'2023-06-08 09:12:35');

--
-- Table structure for table `wal_search_synonyms`
--

CREATE TABLE `wal_search_synonyms` (
  `group_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Synonyms Group ID',
  `synonyms` text NOT NULL COMMENT 'list of synonyms making up this group',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID - identifies the store view these synonyms belong to',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID - identifies the website ID these synonyms belong to',
  PRIMARY KEY (`group_id`),
  KEY `WAL_SEARCH_SYNONYMS_STORE_ID` (`store_id`),
  KEY `WAL_SEARCH_SYNONYMS_WEBSITE_ID` (`website_id`),
  FULLTEXT KEY `WAL_SEARCH_SYNONYMS_SYNONYMS` (`synonyms`),
  CONSTRAINT `WAL_SEARCH_SYNONYMS_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_SEARCH_SYNONYMS_WEBSITE_ID_WAL_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='table storing various synonyms groups';

--
-- Dumping data for table `wal_search_synonyms`
--


--
-- Table structure for table `wal_sendfriend_log`
--

CREATE TABLE `wal_sendfriend_log` (
  `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `ip` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer IP address',
  `time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Log time',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  PRIMARY KEY (`log_id`),
  KEY `WAL_SENDFRIEND_LOG_IP` (`ip`),
  KEY `WAL_SENDFRIEND_LOG_TIME` (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Send to friend function log storage table';

--
-- Dumping data for table `wal_sendfriend_log`
--


--
-- Table structure for table `wal_sequence_creditmemo_0`
--

CREATE TABLE `wal_sequence_creditmemo_0` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wal_sequence_creditmemo_0`
--


--
-- Table structure for table `wal_sequence_creditmemo_1`
--

CREATE TABLE `wal_sequence_creditmemo_1` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wal_sequence_creditmemo_1`
--


--
-- Table structure for table `wal_sequence_invoice_0`
--

CREATE TABLE `wal_sequence_invoice_0` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wal_sequence_invoice_0`
--


--
-- Table structure for table `wal_sequence_invoice_1`
--

CREATE TABLE `wal_sequence_invoice_1` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wal_sequence_invoice_1`
--

INSERT INTO `wal_sequence_invoice_1` VALUES (1);

--
-- Table structure for table `wal_sequence_order_0`
--

CREATE TABLE `wal_sequence_order_0` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wal_sequence_order_0`
--


--
-- Table structure for table `wal_sequence_order_1`
--

CREATE TABLE `wal_sequence_order_1` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wal_sequence_order_1`
--

INSERT INTO `wal_sequence_order_1` VALUES (1),(2);

--
-- Table structure for table `wal_sequence_shipment_0`
--

CREATE TABLE `wal_sequence_shipment_0` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wal_sequence_shipment_0`
--


--
-- Table structure for table `wal_sequence_shipment_1`
--

CREATE TABLE `wal_sequence_shipment_1` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wal_sequence_shipment_1`
--


--
-- Table structure for table `wal_session`
--

CREATE TABLE `wal_session` (
  `session_id` varchar(255) NOT NULL COMMENT 'Session Id',
  `session_expires` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Date of Session Expiration',
  `session_data` mediumblob NOT NULL COMMENT 'Session Data',
  PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Database Sessions Storage';

--
-- Dumping data for table `wal_session`
--


--
-- Table structure for table `wal_setup_module`
--

CREATE TABLE `wal_setup_module` (
  `module` varchar(50) NOT NULL COMMENT 'Module',
  `schema_version` varchar(50) DEFAULT NULL COMMENT 'Schema Version',
  `data_version` varchar(50) DEFAULT NULL COMMENT 'Data Version',
  PRIMARY KEY (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Module versions registry';

--
-- Dumping data for table `wal_setup_module`
--

INSERT INTO `wal_setup_module` VALUES ('Afterpay_Afterpay','5.0.0','5.0.0'),('Amasty_AdvancedReview','1.14.2','1.14.2'),('Amasty_Base','1.6.3','1.6.3'),('Amasty_CronScheduleList','1.0.0','1.0.0'),('Amasty_CustomTabs','1.1.0','1.1.0'),('Amasty_FacebookPixel','1.0.0','1.0.0'),('Amasty_Feed','2.3.6','2.3.6'),('Amasty_ImageOptimizer','1.0.0','1.0.0'),('Amasty_ImageOptimizerUi','1.0.0','1.0.0'),('Amasty_InvisibleCaptcha','2.2.2','2.2.2'),('Amasty_LazyLoad','1.0.0','1.0.0'),('Amasty_LazyLoadUi','1.0.0','1.0.0'),('Amasty_Mage24Fix','1.0.0','1.0.0'),('Amasty_OpenGraphTags','0.0.1','0.0.1'),('Amasty_Paction','1.0.0','1.0.0'),('Amasty_PageSpeedOptimizer','1.9.0','1.9.0'),('Amasty_PageSpeedTools','1.0.0','1.0.0'),('Amasty_PromoBanners','1.1.0','1.1.0'),('Amasty_ReviewsImportExport','1.0.0','1.0.0'),('Amasty_Rgrid','1.0.0','1.0.0'),('Amasty_Scroll','1.0.0','1.0.0'),('Amasty_SeoRichData','1.0.0','1.0.0'),('Amasty_Shopby','2.15.4','2.15.4'),('Amasty_ShopbyBase','2.13.13','2.13.13'),('Amasty_ShopbyBrand','2.10.12','2.10.12'),('Amasty_ShopbyPage','1.0.1','1.0.1'),('Amasty_ShopbySeo','1.0.1','1.0.1'),('Amasty_Sorting','2.8.2','2.8.2'),('Amazon_Core','3.1.4','3.1.4'),('Amazon_Login','3.1.4','3.1.4'),('Amazon_Payment','3.1.4','3.1.4'),('Codazon_AjaxCartPro','1.0.0','1.0.0'),('Codazon_AjaxLayeredNav','0.0.1','0.0.1'),('Codazon_AjaxLayeredNavPro','0.1.2','0.1.2'),('Codazon_Core','0.1.0','0.1.0'),('Codazon_GoogleAmpManager','0.1.0','0.1.0'),('Codazon_ImproveBundle','1.0.0','1.0.0'),('Codazon_Lookbookpro','1.0.0','1.0.0'),('Codazon_MegaMenu','1.0.0','1.0.0'),('Codazon_OneStepCheckout','1.0.0','1.0.0'),('Codazon_PageBuilder','1.0.0','1.0.0'),('Codazon_ProductFilter','2.0.0','2.0.0'),('Codazon_ProductLabel','2.2.6','2.2.6'),('Codazon_QuickShop','0.0.2','0.0.2'),('Codazon_SalesPro','1.0.0','1.0.0'),('Codazon_ShippingCostCalculator','0.1.0','0.1.0'),('Codazon_Shopbybrandpro','1.0.0','1.0.0'),('Codazon_Slideshow','2.0.0','2.0.0'),('Codazon_ThemeOptions','2.0.1','2.0.1'),('Codazon_Utility','1.0.0','1.0.0'),('Dotdigitalgroup_Chat','1.0.1','1.0.1'),('Dotdigitalgroup_Email','4.4.0','4.4.0'),('Dotdigitalgroup_Sms','1.1.1','1.1.1'),('Facebook_BusinessExtension','1.4.6','1.4.6'),('Flurrybox_EnhancedPrivacy','1.0.2','1.0.2'),('Harrigo_EverCrumbs','1.0.1','1.0.1'),('Klarna_Core','5.1.0','5.1.0'),('Klarna_Kp','6.1.0','6.1.0'),('Klarna_KpGraphQl','0.9.3','0.9.3'),('Klarna_Onsitemessaging','1.0.5','1.0.5'),('Klarna_Ordermanagement','5.0.2','5.0.2'),('Magefan_Blog','2.8.9','2.8.9'),('Magefan_Community','2.0.4','2.0.4'),('Magefan_WysiwygAdvanced','2.0.7','2.0.7'),('Magento_AuthorizenetAcceptjs','1.0.0','1.0.0'),('Magento_ComposerRootUpdatePlugin','0.1.0','0.1.0'),('Magento_GoogleShoppingAds','4.0.1','4.0.1'),('Magento_Inventory','1.0.0','1.0.0'),('Magento_InventoryAdminUi','1.0.0','1.0.0'),('Magento_InventoryApi','1.0.0','1.0.0'),('Magento_InventoryBundleProduct','1.0.0','1.0.0'),('Magento_InventoryBundleProductAdminUi','1.0.0','1.0.0'),('Magento_InventoryCache','1.0.0','1.0.0'),('Magento_InventoryCatalog','1.0.0','1.0.0'),('Magento_InventoryCatalogAdminUi','1.0.0','1.0.0'),('Magento_InventoryCatalogApi','1.0.0','1.0.0'),('Magento_InventoryCatalogSearch','1.0.0','1.0.0'),('Magento_InventoryConfigurableProduct','1.0.0','1.0.0'),('Magento_InventoryConfigurableProductAdminUi','1.0.0','1.0.0'),('Magento_InventoryConfigurableProductIndexer','1.0.0','1.0.0'),('Magento_InventoryConfiguration','1.0.0','1.0.0'),('Magento_InventoryConfigurationApi','1.0.0','1.0.0'),('Magento_InventoryElasticsearch','1.0.0','1.0.0'),('Magento_InventoryGroupedProduct','1.0.0','1.0.0'),('Magento_InventoryGroupedProductAdminUi','1.0.0','1.0.0'),('Magento_InventoryGroupedProductIndexer','1.0.0','1.0.0'),('Magento_InventoryImportExport','1.0.0','1.0.0'),('Magento_InventoryIndexer','1.0.0','1.0.0'),('Magento_InventoryLowQuantityNotification','1.0.0','1.0.0'),('Magento_InventoryLowQuantityNotificationAdminUi','1.0.0','1.0.0'),('Magento_InventoryLowQuantityNotificationApi','1.0.0','1.0.0'),('Magento_InventoryMultiDimensionalIndexerApi','1.0.0','1.0.0'),('Magento_InventoryProductAlert','1.0.0','1.0.0'),('Magento_InventoryReservations','1.0.0','1.0.0'),('Magento_InventoryReservationsApi','1.0.0','1.0.0'),('Magento_InventorySales','1.0.0','1.0.0'),('Magento_InventorySalesAdminUi','1.0.0','1.0.0'),('Magento_InventorySalesApi','1.0.0','1.0.0'),('Magento_InventoryShipping','1.0.0','1.0.0'),('Magento_InventoryShippingAdminUi','1.0.0','1.0.0'),('Magento_InventorySourceDeductionApi','1.0.0','1.0.0'),('Magento_InventorySourceSelection','1.0.0','1.0.0'),('Magento_InventorySourceSelectionApi','1.0.0','1.0.0'),('Magento_PaypalReCaptcha','2.0.0','2.0.0'),('Magento_Securitytxt','1.0.0','1.0.0'),('Magento_TestModuleDirectoryZipCodes','0.0.1','0.0.1'),('Magento_TestModuleFakePaymentMethod','0.0.1','0.0.1'),('Magento_TestModuleSample','0.0.1','0.0.1'),('Mageplaza_Core','1.0.0','1.0.0'),('Mageplaza_SocialLogin','1.2.1','1.2.1'),('MageWorx_DynamicOptionsBase','1.0.1','1.0.1'),('MageWorx_Info','1.0.0','1.0.0'),('MageWorx_OptionAdvancedPricing','2.0.1','2.0.1'),('MageWorx_OptionBase','2.0.5','2.0.5'),('MageWorx_OptionDependency','2.0.10','2.0.10'),('MageWorx_OptionFeatures','1.0.20','1.0.20'),('MageWorx_OptionHealthChecker','1.0.0','1.0.0'),('MageWorx_OptionImportExport','2.0.0','2.0.0'),('MageWorx_OptionInventory','2.0.1','2.0.1'),('MageWorx_OptionLink','2.0.1','2.0.1'),('MageWorx_OptionSkuPolicy','2.0.0','2.0.0'),('MageWorx_OptionSwatches','2.0.1','2.0.1'),('MageWorx_OptionTemplates','2.0.6','2.0.6'),('MageWorx_OptionVisibility','2.0.1','2.0.1'),('MageWorx_SearchSuiteAutocomplete','2.0.0','2.0.0'),('Mirasvit_Affiliate','1.0.13','1.0.13'),('Mirasvit_Core','1.0.4','1.0.4'),('Mirasvit_Report','1.0.3','1.0.3'),('Mirasvit_Rewards','1.0.40','1.0.40'),('Mirasvit_RewardsAdminUi','1.0.0','1.0.0'),('Mirasvit_RewardsApi','1.0.0','1.0.0'),('Mirasvit_RewardsBehavior','1.0.0','1.0.0'),('Mirasvit_RewardsCatalog','1.0.0','1.0.0'),('Mirasvit_RewardsCheckout','1.0.0','1.0.0'),('Mirasvit_RewardsCustomerAccount','1.0.0','1.0.0'),('MSP_ReCaptcha','1.6.0','1.6.0'),('MSP_TwoFactorAuth','3.1.0','3.1.0'),('PayPal_Braintree','4.0.3','4.0.3'),('Swissup_Core','1.2.1','1.2.1'),('Swissup_SearchMysqlLegacy','0.1.0','0.1.0'),('Temando_Shipping','1.5.0','1.5.0'),('Vertex_AddressValidation','100.5.0','100.5.0'),('Vertex_Tax','100.3.0','100.3.0'),('Walland_AdvancedReview','1.0.0','1.0.0'),('Walland_Core','0.0.1','0.0.1'),('Walland_LazyLoad','1.0.0','1.0.0'),('Walland_OptionsManagement','1.0.5','1.0.5'),('Walland_ProductFilter','1.0.0','1.0.0'),('Walland_PromoBanners','0.0.1','0.0.1'),('Walland_RealWedding','0.0.1','0.0.1'),('Walland_Review','0.0.1','0.0.1'),('Walland_SalesRule','0.0.1','0.0.1'),('Walland_Slideshow','1.0.0','1.0.0'),('Walland_TableManager','1.0.0','1.0.0'),('Walland_WebElegantweddinginvites','0.0.1','0.0.1'),('Walland_WebTulleandChantilly','0.0.1','0.0.1'),('Walland_WebVipmfw','0.0.1','0.0.1'),('Yotpo_Yotpo','3.1.0','3.1.0');

--
-- Table structure for table `wal_shipping_tablerate`
--

CREATE TABLE `wal_shipping_tablerate` (
  `pk` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key',
  `website_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `dest_country_id` varchar(4) NOT NULL DEFAULT '0' COMMENT 'Destination coutry ISO/2 or ISO/3 code',
  `dest_region_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Destination Region ID',
  `dest_zip` varchar(10) NOT NULL DEFAULT '*' COMMENT 'Destination Post Code (Zip)',
  `condition_name` varchar(30) NOT NULL COMMENT 'Rate Condition name',
  `condition_value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Rate condition value',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  `cost` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Cost',
  PRIMARY KEY (`pk`),
  UNIQUE KEY `UNQ_8219981539528B3F77FD0C7419D48448` (`website_id`,`dest_country_id`,`dest_region_id`,`dest_zip`,`condition_name`,`condition_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Shipping Tablerate';

--
-- Dumping data for table `wal_shipping_tablerate`
--


--
-- Table structure for table `wal_sitemap`
--

CREATE TABLE `wal_sitemap` (
  `sitemap_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Sitemap ID',
  `sitemap_type` varchar(32) DEFAULT NULL COMMENT 'Sitemap Type',
  `sitemap_filename` varchar(32) DEFAULT NULL COMMENT 'Sitemap Filename',
  `sitemap_path` varchar(255) DEFAULT NULL COMMENT 'Sitemap Path',
  `sitemap_time` timestamp NULL DEFAULT NULL COMMENT 'Sitemap Time',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  PRIMARY KEY (`sitemap_id`),
  KEY `WAL_SITEMAP_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_SITEMAP_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='XML Sitemap';

--
-- Dumping data for table `wal_sitemap`
--


--
-- Table structure for table `wal_store`
--

CREATE TABLE `wal_store` (
  `store_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Store ID',
  `code` varchar(32) DEFAULT NULL COMMENT 'Code',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Group ID',
  `name` varchar(255) NOT NULL COMMENT 'Store Name',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Sort Order',
  `is_active` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Activity',
  PRIMARY KEY (`store_id`),
  UNIQUE KEY `WAL_STORE_CODE` (`code`),
  KEY `WAL_STORE_WEBSITE_ID` (`website_id`),
  KEY `WAL_STORE_IS_ACTIVE_SORT_ORDER` (`is_active`,`sort_order`),
  KEY `WAL_STORE_GROUP_ID` (`group_id`),
  CONSTRAINT `WAL_STORE_GROUP_ID_WAL_STORE_GROUP_GROUP_ID` FOREIGN KEY (`group_id`) REFERENCES `wal_store_group` (`group_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_STORE_WEBSITE_ID_WAL_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Stores';

--
-- Dumping data for table `wal_store`
--

INSERT INTO `wal_store` VALUES (0,'admin',0,0,'Admin',0,1),(1,'default',1,1,'Default Store View',0,1);

--
-- Table structure for table `wal_store_group`
--

CREATE TABLE `wal_store_group` (
  `group_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Group ID',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `name` varchar(255) NOT NULL COMMENT 'Store Group Name',
  `root_category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Root Category ID',
  `default_store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Default Store ID',
  `code` varchar(32) DEFAULT NULL COMMENT 'Store group unique code',
  PRIMARY KEY (`group_id`),
  UNIQUE KEY `WAL_STORE_GROUP_CODE` (`code`),
  KEY `WAL_STORE_GROUP_WEBSITE_ID` (`website_id`),
  KEY `WAL_STORE_GROUP_DEFAULT_STORE_ID` (`default_store_id`),
  CONSTRAINT `WAL_STORE_GROUP_WEBSITE_ID_WAL_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Store Groups';

--
-- Dumping data for table `wal_store_group`
--

INSERT INTO `wal_store_group` VALUES (0,0,'Default',0,0,'default'),(1,1,'Main Website Store',2,1,'main_website_store');

--
-- Table structure for table `wal_store_website`
--

CREATE TABLE `wal_store_website` (
  `website_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Website ID',
  `code` varchar(32) DEFAULT NULL COMMENT 'Code',
  `name` varchar(64) DEFAULT NULL COMMENT 'Website Name',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `default_group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Default Group ID',
  `is_default` smallint(5) unsigned DEFAULT '0' COMMENT 'Defines Is Website Default',
  PRIMARY KEY (`website_id`),
  UNIQUE KEY `WAL_STORE_WEBSITE_CODE` (`code`),
  KEY `WAL_STORE_WEBSITE_SORT_ORDER` (`sort_order`),
  KEY `WAL_STORE_WEBSITE_DEFAULT_GROUP_ID` (`default_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Websites';

--
-- Dumping data for table `wal_store_website`
--

INSERT INTO `wal_store_website` VALUES (0,'admin','Admin',0,0,0),(1,'base','Main Website',0,1,1);

--
-- Table structure for table `wal_stripe_checkout_sessions`
--

CREATE TABLE `wal_stripe_checkout_sessions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `quote_id` int(10) unsigned NOT NULL COMMENT 'Quote ID',
  `order_increment_id` varchar(255) DEFAULT NULL COMMENT 'Order increment ID',
  `checkout_session_id` varchar(255) NOT NULL COMMENT 'Checkout session ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created at date',
  PRIMARY KEY (`id`),
  KEY `WAL_STRIPE_CHECKOUT_SESSIONS_QUOTE_ID` (`quote_id`),
  KEY `WAL_STRIPE_CHECKOUT_SESSIONS_CHECKOUT_SESSION_ID` (`checkout_session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Payment Intents';

--
-- Dumping data for table `wal_stripe_checkout_sessions`
--


--
-- Table structure for table `wal_stripe_coupons`
--

CREATE TABLE `wal_stripe_coupons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `rule_id` int(11) NOT NULL COMMENT 'Sales rule ID',
  `coupon_duration` varchar(255) NOT NULL COMMENT 'Coupon duration',
  `coupon_months` int(11) NOT NULL DEFAULT '0' COMMENT 'Number of months',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Coupons';

--
-- Dumping data for table `wal_stripe_coupons`
--


--
-- Table structure for table `wal_stripe_customers`
--

CREATE TABLE `wal_stripe_customers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Magento customer ID',
  `stripe_id` varchar(255) NOT NULL COMMENT 'Stripe customer ID',
  `last_retrieved` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Timestamp of last customer object retrieval from the Stripe API',
  `customer_email` varchar(255) DEFAULT NULL COMMENT 'Magento customer email',
  `session_id` varchar(255) DEFAULT NULL COMMENT 'Last session ID for this customer',
  `pk` varchar(255) DEFAULT NULL COMMENT 'Stripe account public key',
  PRIMARY KEY (`id`),
  KEY `WAL_STRIPE_CUSTOMERS_PK` (`pk`),
  KEY `WAL_STRIPE_CUSTOMERS_STRIPE_ID` (`stripe_id`),
  KEY `WAL_STRIPE_CUSTOMERS_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_STRIPE_CUSTOMERS_CUSTOMER_EMAIL` (`customer_email`),
  KEY `WAL_STRIPE_CUSTOMERS_SESSION_ID` (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table of associations between Magento customer IDs to Stripe customer IDs';

--
-- Dumping data for table `wal_stripe_customers`
--


--
-- Table structure for table `wal_stripe_invoices`
--

CREATE TABLE `wal_stripe_invoices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `invoice_id` varchar(255) NOT NULL COMMENT 'Invoice ID',
  `order_increment_id` varchar(255) NOT NULL COMMENT 'Order increment ID',
  PRIMARY KEY (`id`),
  KEY `WAL_STRIPE_INVOICES_INVOICE_ID` (`invoice_id`),
  KEY `WAL_STRIPE_INVOICES_ORDER_INCREMENT_ID` (`order_increment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Invoices';

--
-- Dumping data for table `wal_stripe_invoices`
--


--
-- Table structure for table `wal_stripe_multishipping_orders`
--

CREATE TABLE `wal_stripe_multishipping_orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `quote_id` varchar(255) NOT NULL COMMENT 'Quote ID',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `last_error` text COMMENT 'Order placement error',
  PRIMARY KEY (`id`),
  KEY `WAL_STRIPE_MULTISHIPPING_ORDERS_QUOTE_ID` (`quote_id`),
  KEY `WAL_STRIPE_MULTISHIPPING_ORDERS_ORDER_ID` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Multishipping Orders';

--
-- Dumping data for table `wal_stripe_multishipping_orders`
--


--
-- Table structure for table `wal_stripe_multishipping_quotes`
--

CREATE TABLE `wal_stripe_multishipping_quotes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `quote_id` varchar(255) NOT NULL COMMENT 'Quote ID',
  `payment_method_id` varchar(255) NOT NULL COMMENT 'Payment method ID',
  `payment_intent_id` varchar(255) DEFAULT NULL COMMENT 'Payment intent ID',
  `manual_capture` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Payment action',
  `captured` tinyint(1) DEFAULT '0' COMMENT 'Whether the authorization has been captured',
  `warning_email_sent` tinyint(1) DEFAULT '0' COMMENT 'Email sent when the authorization is about to expire',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created at date',
  PRIMARY KEY (`id`),
  KEY `WAL_STRIPE_MULTISHIPPING_QUOTES_QUOTE_ID` (`quote_id`),
  KEY `WAL_STRIPE_MULTISHIPPING_QUOTES_PAYMENT_INTENT_ID` (`payment_intent_id`),
  KEY `WAL_STRIPE_MULTISHIPPING_QUOTES_MANUAL_CAPTURE` (`manual_capture`),
  KEY `WAL_STRIPE_MULTISHIPPING_QUOTES_CREATED_AT` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Multishipping Quotes';

--
-- Dumping data for table `wal_stripe_multishipping_quotes`
--


--
-- Table structure for table `wal_stripe_payment_elements`
--

CREATE TABLE `wal_stripe_payment_elements` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `quote_id` int(10) unsigned NOT NULL COMMENT 'Quote ID',
  `payment_intent_id` varchar(255) DEFAULT NULL COMMENT 'Payment Intent ID',
  `setup_intent_id` varchar(255) DEFAULT NULL COMMENT 'Setup Intent ID',
  `subscription_id` varchar(255) DEFAULT NULL COMMENT 'Subscription ID',
  `payment_method_id` varchar(255) DEFAULT NULL COMMENT 'Payment Method ID',
  `order_increment_id` varchar(255) DEFAULT NULL COMMENT 'Order increment ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created at date',
  PRIMARY KEY (`id`),
  KEY `WAL_STRIPE_PAYMENT_ELEMENTS_QUOTE_ID` (`quote_id`),
  KEY `WAL_STRIPE_PAYMENT_ELEMENTS_ORDER_INCREMENT_ID` (`order_increment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Payment Elements';

--
-- Dumping data for table `wal_stripe_payment_elements`
--


--
-- Table structure for table `wal_stripe_payment_intents`
--

CREATE TABLE `wal_stripe_payment_intents` (
  `pi_id` varchar(255) NOT NULL COMMENT 'Payment Intent ID',
  `quote_id` int(10) unsigned NOT NULL COMMENT 'Quote ID',
  `order_increment_id` varchar(255) NOT NULL COMMENT 'Order increment ID',
  `invoice_id` int(10) unsigned DEFAULT NULL COMMENT 'Magento invoice ID',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Magento customer ID',
  `order_id` int(10) unsigned DEFAULT NULL COMMENT 'Order ID',
  `pm_id` varchar(255) DEFAULT NULL COMMENT 'Payment method ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created at date',
  PRIMARY KEY (`pi_id`),
  KEY `WAL_STRIPE_PAYMENT_INTENTS_PI_ID` (`pi_id`),
  KEY `WAL_STRIPE_PAYMENT_INTENTS_QUOTE_ID` (`quote_id`),
  KEY `WAL_STRIPE_PAYMENT_INTENTS_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `WAL_STRIPE_PAYMENT_INTENTS_ORDER_ID` (`order_id`),
  KEY `WAL_STRIPE_PAYMENT_INTENTS_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_STRIPE_PAYMENT_INTENTS_PM_ID` (`pm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Payment Intents';

--
-- Dumping data for table `wal_stripe_payment_intents`
--


--
-- Table structure for table `wal_stripe_sources`
--

CREATE TABLE `wal_stripe_sources` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `source_id` varchar(255) NOT NULL COMMENT 'Source ID',
  `order_increment_id` varchar(255) DEFAULT NULL COMMENT 'Order increment ID',
  `stripe_customer_id` varchar(255) DEFAULT NULL COMMENT 'Stripe customer ID',
  PRIMARY KEY (`id`),
  KEY `WAL_STRIPE_SOURCES_SOURCE_ID` (`source_id`),
  KEY `WAL_STRIPE_SOURCES_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `WAL_STRIPE_SOURCES_STRIPE_CUSTOMER_ID` (`stripe_customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Source tokens';

--
-- Dumping data for table `wal_stripe_sources`
--


--
-- Table structure for table `wal_stripe_subscriptions`
--

CREATE TABLE `wal_stripe_subscriptions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created at date',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `livemode` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Stripe API mode',
  `subscription_id` varchar(255) NOT NULL COMMENT 'Stripe subscription ID',
  `order_increment_id` varchar(255) NOT NULL COMMENT 'Order increment ID',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
  `magento_customer_id` int(10) unsigned DEFAULT '0' COMMENT 'Product ID',
  `stripe_customer_id` varchar(255) DEFAULT NULL COMMENT 'Stripe customer ID',
  `payment_method_id` varchar(255) NOT NULL COMMENT 'Payment method ID',
  `name` text NOT NULL COMMENT 'Subscription name',
  `quantity` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'Subscription quantity',
  `currency` varchar(255) NOT NULL COMMENT 'Currency code',
  `grand_total` decimal(10,4) NOT NULL DEFAULT '0.0000' COMMENT 'Grand total',
  `is_new` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Subscription just created flag',
  PRIMARY KEY (`id`),
  KEY `WAL_STRIPE_SUBSCRIPTIONS_SUBSCRIPTION_ID` (`subscription_id`),
  KEY `WAL_STRIPE_SUBSCRIPTIONS_STORE_ID` (`store_id`),
  KEY `WAL_STRIPE_SUBSCRIPTIONS_LIVEMODE` (`livemode`),
  KEY `WAL_STRIPE_SUBSCRIPTIONS_STRIPE_CUSTOMER_ID` (`stripe_customer_id`),
  KEY `WAL_STRIPE_SUBSCRIPTIONS_MAGENTO_CUSTOMER_ID` (`magento_customer_id`),
  KEY `WAL_STRIPE_SUBSCRIPTIONS_PRODUCT_ID` (`product_id`),
  KEY `WAL_STRIPE_SUBSCRIPTIONS_CREATED_AT` (`created_at`),
  KEY `WAL_STRIPE_SUBSCRIPTIONS_IS_NEW` (`is_new`),
  KEY `WAL_STRIPE_SUBSCRIPTIONS_ORDER_INCREMENT_ID` (`order_increment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Subscriptions';

--
-- Dumping data for table `wal_stripe_subscriptions`
--


--
-- Table structure for table `wal_stripe_webhooks`
--

CREATE TABLE `wal_stripe_webhooks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `config_version` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Webhooks configuration version',
  `webhook_id` varchar(255) NOT NULL COMMENT 'Webhook ID',
  `publishable_key` varchar(255) NOT NULL COMMENT 'Stripe API publishable key',
  `store_code` varchar(255) NOT NULL COMMENT 'Store view code',
  `live_mode` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Stripe API mode',
  `active` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Active',
  `last_event` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Timestamp of last received event',
  `api_version` varchar(255) DEFAULT NULL COMMENT 'Stripe API Version',
  `url` text COMMENT 'Webhook URL',
  `enabled_events` text COMMENT 'Enabled webhook events',
  `secret` varchar(255) DEFAULT NULL COMMENT 'Webhook signing secret',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created at date',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Webhooks configuration for each store view';

--
-- Dumping data for table `wal_stripe_webhooks`
--


--
-- Table structure for table `wal_swissup_core_module`
--

CREATE TABLE `wal_swissup_core_module` (
  `code` varchar(50) NOT NULL COMMENT 'Code',
  `name` varchar(50) DEFAULT NULL COMMENT 'Package Name',
  `description` varchar(255) DEFAULT NULL COMMENT 'Package Description',
  `keywords` varchar(255) DEFAULT NULL COMMENT 'Keywords',
  `data_version` varchar(50) DEFAULT NULL COMMENT 'Data_version',
  `identity_key` varchar(255) DEFAULT NULL COMMENT 'Identity_key',
  `store_ids` varchar(64) DEFAULT NULL COMMENT 'Store_ids',
  `type` varchar(32) DEFAULT NULL COMMENT 'Package Type',
  `version` varchar(50) DEFAULT NULL COMMENT 'Version',
  `latest_version` varchar(50) DEFAULT NULL COMMENT 'Latest Version',
  `release_date` datetime DEFAULT NULL COMMENT 'Release Date',
  `link` varchar(255) DEFAULT NULL COMMENT 'Module Homepage',
  `download_link` varchar(255) DEFAULT NULL COMMENT 'Module Download Link',
  `identity_key_link` varchar(255) DEFAULT NULL COMMENT 'Identity Key Link',
  PRIMARY KEY (`code`),
  FULLTEXT KEY `WAL_SWISSUP_CORE_MODULE_CODE_NAME_DESCRIPTION_KEYWORDS` (`code`,`name`,`description`,`keywords`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_swissup_core_module';

--
-- Dumping data for table `wal_swissup_core_module`
--


--
-- Table structure for table `wal_tax_calculation`
--

CREATE TABLE `wal_tax_calculation` (
  `tax_calculation_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Tax Calculation ID',
  `tax_calculation_rate_id` int(11) NOT NULL COMMENT 'Tax Calculation Rate ID',
  `tax_calculation_rule_id` int(11) NOT NULL COMMENT 'Tax Calculation Rule ID',
  `customer_tax_class_id` smallint(6) NOT NULL COMMENT 'Customer Tax Class ID',
  `product_tax_class_id` smallint(6) NOT NULL COMMENT 'Product Tax Class ID',
  PRIMARY KEY (`tax_calculation_id`),
  KEY `WAL_TAX_CALCULATION_TAX_CALCULATION_RULE_ID` (`tax_calculation_rule_id`),
  KEY `WAL_TAX_CALCULATION_CUSTOMER_TAX_CLASS_ID` (`customer_tax_class_id`),
  KEY `WAL_TAX_CALCULATION_PRODUCT_TAX_CLASS_ID` (`product_tax_class_id`),
  KEY `WAL_TAX_CALC_TAX_CALC_RATE_ID_CSTR_TAX_CLASS_ID_PRD_TAX_CLASS_ID` (`tax_calculation_rate_id`,`customer_tax_class_id`,`product_tax_class_id`),
  CONSTRAINT `WAL_TAX_CALCULATION_CUSTOMER_TAX_CLASS_ID_WAL_TAX_CLASS_CLASS_ID` FOREIGN KEY (`customer_tax_class_id`) REFERENCES `wal_tax_class` (`class_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_TAX_CALCULATION_PRODUCT_TAX_CLASS_ID_WAL_TAX_CLASS_CLASS_ID` FOREIGN KEY (`product_tax_class_id`) REFERENCES `wal_tax_class` (`class_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_TAX_CALC_TAX_CALC_RATE_ID_WAL_TAX_CALC_RATE_TAX_CALC_RATE_ID` FOREIGN KEY (`tax_calculation_rate_id`) REFERENCES `wal_tax_calculation_rate` (`tax_calculation_rate_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_TAX_CALC_TAX_CALC_RULE_ID_WAL_TAX_CALC_RULE_TAX_CALC_RULE_ID` FOREIGN KEY (`tax_calculation_rule_id`) REFERENCES `wal_tax_calculation_rule` (`tax_calculation_rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tax Calculation';

--
-- Dumping data for table `wal_tax_calculation`
--


--
-- Table structure for table `wal_tax_calculation_rate`
--

CREATE TABLE `wal_tax_calculation_rate` (
  `tax_calculation_rate_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Tax Calculation Rate ID',
  `tax_country_id` varchar(2) NOT NULL COMMENT 'Tax Country ID',
  `tax_region_id` int(11) NOT NULL COMMENT 'Tax Region ID',
  `tax_postcode` varchar(21) DEFAULT NULL COMMENT 'Tax Postcode',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `rate` decimal(12,4) NOT NULL COMMENT 'Rate',
  `zip_is_range` smallint(6) DEFAULT NULL COMMENT 'Zip Is Range',
  `zip_from` int(10) unsigned DEFAULT NULL COMMENT 'Zip From',
  `zip_to` int(10) unsigned DEFAULT NULL COMMENT 'Zip To',
  PRIMARY KEY (`tax_calculation_rate_id`),
  KEY `WAL_TAX_CALC_RATE_TAX_COUNTRY_ID_TAX_REGION_ID_TAX_POSTCODE` (`tax_country_id`,`tax_region_id`,`tax_postcode`),
  KEY `WAL_TAX_CALCULATION_RATE_CODE` (`code`),
  KEY `IDX_49E243C2074ECDB3B20282387EA8D152` (`tax_calculation_rate_id`,`tax_country_id`,`tax_region_id`,`zip_is_range`,`tax_postcode`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Tax Calculation Rate';

--
-- Dumping data for table `wal_tax_calculation_rate`
--

INSERT INTO `wal_tax_calculation_rate` VALUES (1,'US',12,'*','US-CA-*-Rate 1',8.2500,NULL,NULL,NULL),(2,'US',43,'*','US-NY-*-Rate 1',8.3750,NULL,NULL,NULL);

--
-- Table structure for table `wal_tax_calculation_rate_title`
--

CREATE TABLE `wal_tax_calculation_rate_title` (
  `tax_calculation_rate_title_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Tax Calculation Rate Title ID',
  `tax_calculation_rate_id` int(11) NOT NULL COMMENT 'Tax Calculation Rate ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `value` varchar(255) NOT NULL COMMENT 'Value',
  PRIMARY KEY (`tax_calculation_rate_title_id`),
  KEY `WAL_TAX_CALCULATION_RATE_TITLE_TAX_CALCULATION_RATE_ID_STORE_ID` (`tax_calculation_rate_id`,`store_id`),
  KEY `WAL_TAX_CALCULATION_RATE_TITLE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_E03FD1EE0C81FA9B54BE9E9FEC8D65F4` FOREIGN KEY (`tax_calculation_rate_id`) REFERENCES `wal_tax_calculation_rate` (`tax_calculation_rate_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_TAX_CALCULATION_RATE_TITLE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tax Calculation Rate Title';

--
-- Dumping data for table `wal_tax_calculation_rate_title`
--


--
-- Table structure for table `wal_tax_calculation_rule`
--

CREATE TABLE `wal_tax_calculation_rule` (
  `tax_calculation_rule_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Tax Calculation Rule ID',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `priority` int(11) NOT NULL COMMENT 'Priority',
  `position` int(11) NOT NULL COMMENT 'Position',
  `calculate_subtotal` int(11) NOT NULL COMMENT 'Calculate off subtotal option',
  PRIMARY KEY (`tax_calculation_rule_id`),
  KEY `WAL_TAX_CALCULATION_RULE_PRIORITY_POSITION` (`priority`,`position`),
  KEY `WAL_TAX_CALCULATION_RULE_CODE` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tax Calculation Rule';

--
-- Dumping data for table `wal_tax_calculation_rule`
--


--
-- Table structure for table `wal_tax_class`
--

CREATE TABLE `wal_tax_class` (
  `class_id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Class ID',
  `class_name` varchar(255) NOT NULL COMMENT 'Class Name',
  `class_type` varchar(8) NOT NULL DEFAULT 'CUSTOMER' COMMENT 'Class Type',
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='Tax Class';

--
-- Dumping data for table `wal_tax_class`
--

INSERT INTO `wal_tax_class` VALUES (2,'Taxable Goods','PRODUCT'),(3,'Retail Customer','CUSTOMER'),(4,'Refund Adjustments','PRODUCT'),(5,'Gift Options','PRODUCT'),(6,'Order Gift Wrapping','PRODUCT'),(7,'Item Gift Wrapping','PRODUCT'),(8,'Printed Gift Card','PRODUCT'),(9,'Reward Points','PRODUCT');

--
-- Table structure for table `wal_tax_order_aggregated_created`
--

CREATE TABLE `wal_tax_order_aggregated_created` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `percent` float DEFAULT NULL COMMENT 'Percent',
  `orders_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `tax_base_amount_sum` float DEFAULT NULL COMMENT 'Tax Base Amount Sum',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNQ_CF643244990754888E8B5414F00B789D` (`period`,`store_id`,`code`,`percent`,`order_status`),
  KEY `WAL_TAX_ORDER_AGGREGATED_CREATED_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_TAX_ORDER_AGGREGATED_CREATED_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tax Order Aggregation';

--
-- Dumping data for table `wal_tax_order_aggregated_created`
--


--
-- Table structure for table `wal_tax_order_aggregated_updated`
--

CREATE TABLE `wal_tax_order_aggregated_updated` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `percent` float DEFAULT NULL COMMENT 'Percent',
  `orders_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Orders Count',
  `tax_base_amount_sum` float DEFAULT NULL COMMENT 'Tax Base Amount Sum',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNQ_87EBC2A56B6F8033212960B586FF6FC8` (`period`,`store_id`,`code`,`percent`,`order_status`),
  KEY `WAL_TAX_ORDER_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_TAX_ORDER_AGGREGATED_UPDATED_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tax Order Aggregated Updated';

--
-- Dumping data for table `wal_tax_order_aggregated_updated`
--


--
-- Table structure for table `wal_temando_checkout_address`
--

CREATE TABLE `wal_temando_checkout_address` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `shipping_address_id` int(10) unsigned NOT NULL COMMENT 'Magento Quote Address Id',
  `service_selection` text COMMENT 'Value Added Services',
  PRIMARY KEY (`entity_id`),
  KEY `WAL_TEMANDO_CHKT_ADDR_SHPP_ADDR_ID_QUOTE_ADDR_ADDR_ID` (`shipping_address_id`),
  CONSTRAINT `WAL_TEMANDO_CHKT_ADDR_SHPP_ADDR_ID_QUOTE_ADDR_ADDR_ID` FOREIGN KEY (`shipping_address_id`) REFERENCES `wal_quote_address` (`address_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Temando Checkout Address';

--
-- Dumping data for table `wal_temando_checkout_address`
--


--
-- Table structure for table `wal_temando_collection_point_search`
--

CREATE TABLE `wal_temando_collection_point_search` (
  `shipping_address_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `country_id` varchar(2) DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `pending` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Pending',
  PRIMARY KEY (`shipping_address_id`),
  KEY `FK_A0BA671FD50EB4EC75D4B557C093943E` (`country_id`),
  CONSTRAINT `FK_A0BA671FD50EB4EC75D4B557C093943E` FOREIGN KEY (`country_id`) REFERENCES `wal_directory_country` (`country_id`) ON DELETE NO ACTION,
  CONSTRAINT `FK_F9EE83891B52F4E53F7FB7C3BDB7164E` FOREIGN KEY (`shipping_address_id`) REFERENCES `wal_quote_address` (`address_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Collection Point Search';

--
-- Dumping data for table `wal_temando_collection_point_search`
--


--
-- Table structure for table `wal_temando_order`
--

CREATE TABLE `wal_temando_order` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Magento Order Id',
  `ext_order_id` varchar(64) NOT NULL COMMENT 'Temando Order Id',
  PRIMARY KEY (`entity_id`),
  KEY `WAL_TEMANDO_ORDER_ORDER_ID_SALES_ORDER_ENTITY_ID` (`order_id`),
  CONSTRAINT `WAL_TEMANDO_ORDER_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Temando Order';

--
-- Dumping data for table `wal_temando_order`
--


--
-- Table structure for table `wal_temando_order_collection_point`
--

CREATE TABLE `wal_temando_order_collection_point` (
  `recipient_address_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `collection_point_id` varchar(64) NOT NULL COMMENT 'Collection Point Id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `country` varchar(2) NOT NULL COMMENT 'Country Code',
  `region` varchar(255) NOT NULL COMMENT 'Region',
  `postcode` varchar(255) NOT NULL COMMENT 'Zip/Postal Code',
  `city` varchar(255) NOT NULL COMMENT 'City',
  `street` text NOT NULL COMMENT 'Street',
  PRIMARY KEY (`recipient_address_id`),
  CONSTRAINT `FK_97756DE289862AEBD1250C65A4253872` FOREIGN KEY (`recipient_address_id`) REFERENCES `wal_sales_order_address` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Order Collection Point Entity';

--
-- Dumping data for table `wal_temando_order_collection_point`
--


--
-- Table structure for table `wal_temando_order_pickup_location`
--

CREATE TABLE `wal_temando_order_pickup_location` (
  `recipient_address_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `pickup_location_id` varchar(64) NOT NULL COMMENT 'Pickup Location Id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `country` varchar(2) NOT NULL COMMENT 'Country Code',
  `region` varchar(255) NOT NULL COMMENT 'Region',
  `postcode` varchar(255) NOT NULL COMMENT 'Zip/Postal Code',
  `city` varchar(255) NOT NULL COMMENT 'City',
  `street` text NOT NULL COMMENT 'Street',
  PRIMARY KEY (`recipient_address_id`),
  CONSTRAINT `FK_18AB32392D29000CC051792417E5EAB3` FOREIGN KEY (`recipient_address_id`) REFERENCES `wal_sales_order_address` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Order Pickup Location Entity';

--
-- Dumping data for table `wal_temando_order_pickup_location`
--


--
-- Table structure for table `wal_temando_pickup_location_search`
--

CREATE TABLE `wal_temando_pickup_location_search` (
  `shipping_address_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `active` tinyint(1) NOT NULL COMMENT 'Active',
  PRIMARY KEY (`shipping_address_id`),
  CONSTRAINT `WAL_TEMANDO_PICKUP_LOCATION_SRCH_SHPP_ADDR_ID_QUOTE_ADDR_ADDR_ID` FOREIGN KEY (`shipping_address_id`) REFERENCES `wal_quote_address` (`address_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pickup Location Search';

--
-- Dumping data for table `wal_temando_pickup_location_search`
--


--
-- Table structure for table `wal_temando_quote_collection_point`
--

CREATE TABLE `wal_temando_quote_collection_point` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `recipient_address_id` int(10) unsigned NOT NULL COMMENT 'Quote Address Id',
  `collection_point_id` varchar(64) NOT NULL COMMENT 'Collection Point Id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `country` varchar(2) NOT NULL COMMENT 'Country Code',
  `region` varchar(255) NOT NULL COMMENT 'Region',
  `postcode` varchar(255) NOT NULL COMMENT 'Zip/Postal Code',
  `city` varchar(255) NOT NULL COMMENT 'City',
  `street` text NOT NULL COMMENT 'Street',
  `opening_hours` text NOT NULL COMMENT 'Opening Hours',
  `shipping_experiences` text NOT NULL COMMENT 'Shipping Experiences',
  `selected` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Selected',
  `distance` int(10) unsigned DEFAULT NULL COMMENT 'Distance in Meters',
  PRIMARY KEY (`entity_id`),
  KEY `FK_F19D806C4C6B9FAA1D4F415B61B77559` (`recipient_address_id`),
  CONSTRAINT `FK_F19D806C4C6B9FAA1D4F415B61B77559` FOREIGN KEY (`recipient_address_id`) REFERENCES `wal_temando_collection_point_search` (`shipping_address_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Quote Collection Point Entity';

--
-- Dumping data for table `wal_temando_quote_collection_point`
--


--
-- Table structure for table `wal_temando_quote_pickup_location`
--

CREATE TABLE `wal_temando_quote_pickup_location` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `recipient_address_id` int(10) unsigned NOT NULL COMMENT 'Quote Address Id',
  `pickup_location_id` varchar(64) NOT NULL COMMENT 'Pickup Location Id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `country` varchar(2) NOT NULL COMMENT 'Country Code',
  `region` varchar(255) NOT NULL COMMENT 'Region',
  `postcode` varchar(255) NOT NULL COMMENT 'Zip/Postal Code',
  `city` varchar(255) NOT NULL COMMENT 'City',
  `street` text NOT NULL COMMENT 'Street',
  `opening_hours` text NOT NULL COMMENT 'Opening Hours',
  `shipping_experiences` text NOT NULL COMMENT 'Shipping Experiences',
  `selected` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Selected',
  `distance` int(10) unsigned DEFAULT NULL COMMENT 'Distance in Meters',
  PRIMARY KEY (`entity_id`),
  KEY `FK_A8F8C0CB3378E089AAF4FD8D4256489C` (`recipient_address_id`),
  CONSTRAINT `FK_A8F8C0CB3378E089AAF4FD8D4256489C` FOREIGN KEY (`recipient_address_id`) REFERENCES `wal_temando_pickup_location_search` (`shipping_address_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Quote Pickup Location Entity';

--
-- Dumping data for table `wal_temando_quote_pickup_location`
--


--
-- Table structure for table `wal_temando_shipment`
--

CREATE TABLE `wal_temando_shipment` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `shipment_id` int(10) unsigned NOT NULL COMMENT 'Magento Shipment Id',
  `ext_shipment_id` varchar(64) NOT NULL COMMENT 'External Shipment Id',
  `ext_location_id` varchar(64) DEFAULT NULL,
  `ext_tracking_url` varchar(255) DEFAULT NULL COMMENT 'External Tracking Url',
  `ext_tracking_reference` varchar(255) DEFAULT NULL COMMENT 'External Tracking Reference',
  `ext_return_shipment_id` varchar(64) DEFAULT NULL COMMENT 'External Return Shipment Id',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `WAL_TEMANDO_SHIPMENT_SHIPMENT_ID_EXT_SHIPMENT_ID` (`shipment_id`,`ext_shipment_id`),
  CONSTRAINT `WAL_TEMANDO_SHIPMENT_SHIPMENT_ID_SALES_SHIPMENT_ENTITY_ID` FOREIGN KEY (`shipment_id`) REFERENCES `wal_sales_shipment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Temando Shipment';

--
-- Dumping data for table `wal_temando_shipment`
--


--
-- Table structure for table `wal_theme`
--

CREATE TABLE `wal_theme` (
  `theme_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Theme identifier',
  `parent_id` int(11) DEFAULT NULL COMMENT 'Parent ID',
  `theme_path` varchar(255) DEFAULT NULL COMMENT 'Theme Path',
  `theme_title` varchar(255) NOT NULL COMMENT 'Theme Title',
  `preview_image` varchar(255) DEFAULT NULL COMMENT 'Preview Image',
  `is_featured` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is Theme Featured',
  `area` varchar(255) NOT NULL COMMENT 'Theme Area',
  `type` smallint(6) NOT NULL COMMENT 'Theme type: 0:physical, 1:virtual, 2:staging',
  `code` text COMMENT 'Full theme code, including package',
  PRIMARY KEY (`theme_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='Core theme';

--
-- Dumping data for table `wal_theme`
--

INSERT INTO `wal_theme` VALUES (1,NULL,'Magento/blank','Magento Blank','preview_image_5edddcd7e2810.jpeg',0,'frontend',0,'Magento/blank'),(2,1,'Magento/luma','Magento Luma','preview_image_5edddcd7ecb90.jpeg',0,'frontend',0,'Magento/luma'),(3,NULL,'Magento/backend','Magento 2 backend',NULL,0,'adminhtml',0,'Magento/backend'),(4,1,'Codazon/fastest_fashion','Codazon Fastest - Fashion','preview_image_5edde32b26f26.jpeg',0,'frontend',0,'Codazon/fastest_fashion'),(5,4,'Codazon/fastest_baby_kid','Codazon Fastest - Baby Kids','preview_image_5edde32b37f81.jpeg',0,'frontend',0,'Codazon/fastest_baby_kid'),(6,4,'Codazon/fastest_bigmarket','Codazon Fastest - Big Market','preview_image_5edde32b627f8.jpeg',0,'frontend',0,'Codazon/fastest_bigmarket'),(7,4,'Codazon/fastest_car','Codazon Fastest - Car','preview_image_5edde32b79636.jpeg',0,'frontend',0,'Codazon/fastest_car'),(8,4,'Codazon/fastest_drug_pharmacy','Codazon Fastest - Drug Pharmacy','preview_image_5edde32b8fcdc.jpeg',0,'frontend',0,'Codazon/fastest_drug_pharmacy'),(9,4,'Codazon/fastest_ellyana','Codazon Fastest - Ellyana','preview_image_5edde32ba43fb.jpeg',0,'frontend',0,'Codazon/fastest_ellyana'),(10,4,'Codazon/fastest_food_drink','Codazon Fastest - Food Drink','preview_image_5edde32bba728.jpeg',0,'frontend',0,'Codazon/fastest_food_drink'),(11,4,'Codazon/fastest_furniture','Codazon Fastest - Furniture','preview_image_5edde32bd1446.jpeg',0,'frontend',0,'Codazon/fastest_furniture'),(12,4,'Codazon/fastest_grocery_gourmet','Codazon Fastest - Grocery Gourmet ','preview_image_5edde32bedb7b.jpeg',0,'frontend',0,'Codazon/fastest_grocery_gourmet'),(13,4,'Codazon/fastest_handbag','Codazon Fastest - Handbag','preview_image_5edde32c14571.jpeg',0,'frontend',0,'Codazon/fastest_handbag'),(14,4,'Codazon/fastest_hightech','Codazon Fastest - Hightech ','preview_image_5edde32c435ae.jpeg',0,'frontend',0,'Codazon/fastest_hightech'),(15,4,'Codazon/fastest_jewelry','Codazon Fastest - Jewelry','preview_image_5edde32c57768.jpeg',0,'frontend',0,'Codazon/fastest_jewelry'),(16,4,'Codazon/fastest_mechanic_tools','Codazon Fastest - Mechanic Tools','preview_image_5edde32c6c219.jpeg',0,'frontend',0,'Codazon/fastest_mechanic_tools'),(17,4,'Codazon/fastest_outdoor','Codazon Fastest - Outdoor','preview_image_5edde32c82519.jpeg',0,'frontend',0,'Codazon/fastest_outdoor'),(18,4,'Codazon/fastest_sportswear','Codazon Fastest - Sportswear','preview_image_5edde32c96de4.jpeg',0,'frontend',0,'Codazon/fastest_sportswear'),(19,4,'Codazon/fastest_westylefashion','Codazon Fastest - Westyle Fashion','preview_image_5edde32cacf5e.jpeg',0,'frontend',0,'Codazon/fastest_westylefashion'),(20,4,'Codazon/fastest_westylejewelry','Codazon Fastest - Westyle Jewelry','preview_image_5edde32cbb931.png',0,'frontend',0,'Codazon/fastest_westylejewelry'),(21,4,'Codazon/fastest_westylefashion_tull','Codazon Fastest - Westyle Fashion Tull','preview_image_5eddebdef2d2c.jpeg',0,'frontend',0,'Codazon/fastest_westylefashion_tull'),(22,1,'Smartwave/porto','Smartwave Porto','preview_image_5eddebdf1376d.png',0,'frontend',1,'Smartwave/porto'),(23,1,'Smartwave/porto_rtl','Smartwave Porto RTL','preview_image_5eddebdf4406c.png',0,'frontend',1,'Smartwave/porto_rtl'),(24,9,'Codazon/fastest_beauty','Codazon/fastest - beauty','preview_image_6126f2b8d3360.jpeg',0,'frontend',0,'Codazon/fastest_beauty'),(25,4,'Codazon/fastest_fishing','Codazon/fastest - fishing','preview_image_6126f2b8edd85.jpeg',0,'frontend',0,'Codazon/fastest_fishing'),(26,25,'Codazon/fastest_garden','Codazon/fastest - garden','preview_image_6126f2b912716.jpeg',0,'frontend',0,'Codazon/fastest_garden'),(27,4,'Codazon/fastest_medical','Codazon Fastest - Medical','preview_image_6126f2b92b1cf.jpeg',0,'frontend',0,'Codazon/fastest_medical');

--
-- Table structure for table `wal_theme_file`
--

CREATE TABLE `wal_theme_file` (
  `theme_files_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Theme files identifier',
  `theme_id` int(10) unsigned NOT NULL COMMENT 'Theme ID',
  `file_path` varchar(255) DEFAULT NULL COMMENT 'Relative path to file',
  `file_type` varchar(32) NOT NULL COMMENT 'File Type',
  `content` longtext NOT NULL COMMENT 'File Content',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `is_temporary` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is Temporary File',
  PRIMARY KEY (`theme_files_id`),
  KEY `WAL_THEME_FILE_THEME_ID_WAL_THEME_THEME_ID` (`theme_id`),
  CONSTRAINT `WAL_THEME_FILE_THEME_ID_WAL_THEME_THEME_ID` FOREIGN KEY (`theme_id`) REFERENCES `wal_theme` (`theme_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Core theme files';

--
-- Dumping data for table `wal_theme_file`
--


--
-- Table structure for table `wal_translation`
--

CREATE TABLE `wal_translation` (
  `key_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Key ID of Translation',
  `string` varchar(255) NOT NULL DEFAULT 'Translate String' COMMENT 'Translation String',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `translate` varchar(255) DEFAULT NULL COMMENT 'Translate',
  `locale` varchar(20) NOT NULL DEFAULT 'en_US' COMMENT 'Locale',
  `crc_string` bigint(20) NOT NULL DEFAULT '1591228201' COMMENT 'Translation String CRC32 Hash',
  PRIMARY KEY (`key_id`),
  UNIQUE KEY `WAL_TRANSLATION_STORE_ID_LOCALE_CRC_STRING_STRING` (`store_id`,`locale`,`crc_string`,`string`),
  CONSTRAINT `WAL_TRANSLATION_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Translations';

--
-- Dumping data for table `wal_translation`
--


--
-- Table structure for table `wal_ui_bookmark`
--

CREATE TABLE `wal_ui_bookmark` (
  `bookmark_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Bookmark identifier',
  `user_id` int(10) unsigned NOT NULL COMMENT 'User ID',
  `namespace` varchar(255) NOT NULL COMMENT 'Bookmark namespace',
  `identifier` varchar(255) NOT NULL COMMENT 'Bookmark Identifier',
  `current` smallint(6) NOT NULL COMMENT 'Mark current bookmark per user and identifier',
  `title` varchar(255) DEFAULT NULL COMMENT 'Bookmark title',
  `config` longtext COMMENT 'Bookmark config',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Bookmark created at',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Bookmark updated at',
  PRIMARY KEY (`bookmark_id`),
  KEY `WAL_UI_BOOKMARK_USER_ID_NAMESPACE_IDENTIFIER` (`user_id`,`namespace`,`identifier`),
  CONSTRAINT `WAL_UI_BOOKMARK_USER_ID_WAL_ADMIN_USER_USER_ID` FOREIGN KEY (`user_id`) REFERENCES `wal_admin_user` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='Bookmark';

--
-- Dumping data for table `wal_ui_bookmark`
--

INSERT INTO `wal_ui_bookmark` VALUES (1,1,'design_config_listing','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"default\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"store_website_id\":{\"visible\":true,\"sorting\":false},\"store_group_id\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"theme_theme_id\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"default\":0,\"store_website_id\":1,\"store_group_id\":2,\"store_id\":3,\"actions\":4,\"theme_theme_id\":5},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20,\"pageSize\":20,\"current\":1}}}','0000-00-00 00:00:00','2021-03-10 05:59:25'),(2,1,'design_config_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"default\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"store_website_id\":{\"visible\":true,\"sorting\":false},\"store_group_id\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"theme_theme_id\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"default\":0,\"store_website_id\":1,\"store_group_id\":2,\"store_id\":3,\"actions\":4,\"theme_theme_id\":5},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,1,'product_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"entity_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"sku\":{\"visible\":true,\"sorting\":false},\"price\":{\"visible\":true,\"sorting\":false},\"websites\":{\"visible\":true,\"sorting\":false},\"cost\":{\"visible\":true,\"sorting\":false},\"qty\":{\"visible\":true,\"sorting\":false},\"short_description\":{\"visible\":false,\"sorting\":false},\"special_price\":{\"visible\":false,\"sorting\":false},\"weight\":{\"visible\":false,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false},\"meta_keyword\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"msrp\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"salable_quantity\":{\"visible\":true,\"sorting\":false},\"type_id\":{\"visible\":true,\"sorting\":false},\"attribute_set_id\":{\"visible\":true,\"sorting\":false},\"visibility\":{\"visible\":true,\"sorting\":false},\"status\":{\"visible\":true,\"sorting\":false},\"manufacturer\":{\"visible\":false,\"sorting\":false},\"color\":{\"visible\":false,\"sorting\":false},\"custom_design\":{\"visible\":false,\"sorting\":false},\"page_layout\":{\"visible\":false,\"sorting\":false},\"country_of_manufacture\":{\"visible\":false,\"sorting\":false},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"visible\":false,\"sorting\":false},\"special_from_date\":{\"visible\":false,\"sorting\":false},\"special_to_date\":{\"visible\":false,\"sorting\":false},\"news_from_date\":{\"visible\":false,\"sorting\":false},\"news_to_date\":{\"visible\":false,\"sorting\":false},\"custom_design_from\":{\"visible\":false,\"sorting\":false},\"custom_design_to\":{\"visible\":false,\"sorting\":false},\"thumbnail\":{\"visible\":true,\"sorting\":false}},\"search\":{\"value\":\"\"},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"entity_id\":1,\"thumbnail\":2,\"name\":3,\"type_id\":4,\"attribute_set_id\":5,\"sku\":6,\"price\":7,\"qty\":8,\"salable_quantity\":9,\"visibility\":10,\"status\":11,\"websites\":12,\"short_description\":13,\"special_price\":14,\"special_from_date\":15,\"special_to_date\":16,\"weight\":17,\"manufacturer\":18,\"meta_title\":19,\"meta_keyword\":20,\"meta_description\":21,\"color\":22,\"news_from_date\":23,\"news_to_date\":24,\"custom_design\":25,\"custom_design_from\":26,\"custom_design_to\":27,\"page_layout\":28,\"country_of_manufacture\":29,\"custom_layout\":30,\"msrp\":31,\"url_key\":32,\"gift_message_available\":33,\"tax_class_id\":34,\"cost\":35,\"actions\":36},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20}},\"value\":\"Default View\"}}}','0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,1,'product_listing','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"columns\":{\"entity_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"sku\":{\"visible\":true,\"sorting\":false},\"price\":{\"visible\":true,\"sorting\":false},\"websites\":{\"visible\":true,\"sorting\":false},\"cost\":{\"visible\":true,\"sorting\":false},\"qty\":{\"visible\":true,\"sorting\":false},\"short_description\":{\"visible\":false,\"sorting\":false},\"special_price\":{\"visible\":false,\"sorting\":false},\"weight\":{\"visible\":false,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false},\"meta_keyword\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"msrp\":{\"visible\":false,\"sorting\":false},\"url_key\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"salable_quantity\":{\"visible\":true,\"sorting\":false},\"type_id\":{\"visible\":true,\"sorting\":false},\"attribute_set_id\":{\"visible\":true,\"sorting\":false},\"visibility\":{\"visible\":true,\"sorting\":false},\"status\":{\"visible\":true,\"sorting\":false},\"manufacturer\":{\"visible\":false,\"sorting\":false},\"color\":{\"visible\":false,\"sorting\":false},\"custom_design\":{\"visible\":false,\"sorting\":false},\"page_layout\":{\"visible\":false,\"sorting\":false},\"country_of_manufacture\":{\"visible\":false,\"sorting\":false},\"custom_layout\":{\"visible\":false,\"sorting\":false},\"gift_message_available\":{\"visible\":false,\"sorting\":false},\"tax_class_id\":{\"visible\":false,\"sorting\":false},\"special_from_date\":{\"visible\":false,\"sorting\":false},\"special_to_date\":{\"visible\":false,\"sorting\":false},\"news_from_date\":{\"visible\":false,\"sorting\":false},\"news_to_date\":{\"visible\":false,\"sorting\":false},\"custom_design_from\":{\"visible\":false,\"sorting\":false},\"custom_design_to\":{\"visible\":false,\"sorting\":false},\"thumbnail\":{\"visible\":true,\"sorting\":false}},\"search\":{\"value\":\"\"},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"entity_id\":1,\"thumbnail\":2,\"name\":3,\"type_id\":4,\"attribute_set_id\":5,\"sku\":6,\"price\":7,\"qty\":8,\"salable_quantity\":9,\"visibility\":10,\"status\":11,\"websites\":12,\"short_description\":13,\"special_price\":14,\"special_from_date\":15,\"special_to_date\":16,\"weight\":17,\"manufacturer\":18,\"meta_title\":19,\"meta_keyword\":20,\"meta_description\":21,\"color\":22,\"news_from_date\":23,\"news_to_date\":24,\"custom_design\":25,\"custom_design_from\":26,\"custom_design_to\":27,\"page_layout\":28,\"country_of_manufacture\":29,\"custom_layout\":30,\"msrp\":31,\"url_key\":32,\"gift_message_available\":33,\"tax_class_id\":34,\"cost\":35,\"actions\":36},\"paging\":{\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20,\"pageSize\":20,\"current\":1}}}','0000-00-00 00:00:00','2020-06-11 09:29:01'),(5,1,'cms_block_listing','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"search\":{\"value\":\"\"},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"block_id\":{\"visible\":true,\"sorting\":false},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"creation_time\":{\"visible\":true,\"sorting\":false},\"update_time\":{\"visible\":true,\"sorting\":\"desc\"},\"is_active\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"block_id\":1,\"title\":2,\"identifier\":3,\"store_id\":4,\"is_active\":5,\"creation_time\":6,\"update_time\":7,\"actions\":8}}}','2021-03-10 05:53:06','2022-03-03 06:07:02'),(6,1,'cms_block_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"search\":{\"value\":\"\"},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"block_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"creation_time\":{\"visible\":true,\"sorting\":false},\"update_time\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"block_id\":1,\"title\":2,\"identifier\":3,\"store_id\":4,\"is_active\":5,\"creation_time\":6,\"update_time\":7,\"actions\":8}},\"value\":\"Default View\"}}}','2021-03-10 05:53:20','2021-03-10 05:53:20'),(7,1,'customer_listing','current',0,NULL,'{\"current\":{\"displayMode\":\"grid\",\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"search\":{\"value\":\"\"},\"columns\":{\"entity_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"email\":{\"visible\":true,\"sorting\":false},\"billing_telephone\":{\"visible\":true,\"sorting\":false},\"billing_postcode\":{\"visible\":true,\"sorting\":false},\"billing_region\":{\"visible\":true,\"sorting\":false},\"confirmation\":{\"visible\":true,\"sorting\":false},\"created_in\":{\"visible\":true,\"sorting\":false},\"billing_full\":{\"visible\":false,\"sorting\":false},\"shipping_full\":{\"visible\":false,\"sorting\":false},\"taxvat\":{\"visible\":true,\"sorting\":false},\"billing_street\":{\"visible\":false,\"sorting\":false},\"billing_city\":{\"visible\":false,\"sorting\":false},\"billing_fax\":{\"visible\":false,\"sorting\":false},\"billing_vat_id\":{\"visible\":false,\"sorting\":false},\"billing_company\":{\"visible\":false,\"sorting\":false},\"billing_firstname\":{\"visible\":false,\"sorting\":false},\"billing_lastname\":{\"visible\":false,\"sorting\":false},\"lock_expires\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"group_id\":{\"visible\":true,\"sorting\":false},\"billing_country_id\":{\"visible\":true,\"sorting\":false},\"website_id\":{\"visible\":true,\"sorting\":false},\"gender\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"dob\":{\"visible\":true,\"sorting\":false},\"mst_rewards_tier_id\":{\"visible\":false,\"sorting\":false},\"mst_rewards_balance\":{\"visible\":true,\"sorting\":false}},\"positions\":{\"ids\":0,\"entity_id\":1,\"name\":2,\"email\":3,\"group_id\":4,\"billing_telephone\":5,\"billing_postcode\":6,\"billing_country_id\":7,\"billing_region\":8,\"created_at\":9,\"website_id\":10,\"confirmation\":11,\"created_in\":12,\"billing_full\":13,\"shipping_full\":14,\"dob\":15,\"taxvat\":16,\"gender\":17,\"billing_street\":18,\"billing_city\":19,\"billing_fax\":20,\"billing_vat_id\":21,\"billing_company\":22,\"billing_firstname\":23,\"billing_lastname\":24,\"lock_expires\":25,\"actions\":26,\"mst_rewards_tier_id\":27}}}','2021-08-25 06:01:57','2022-06-06 08:56:39'),(8,1,'customer_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"displayMode\":\"grid\",\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"search\":{\"value\":\"\"},\"columns\":{\"entity_id\":{\"visible\":true,\"sorting\":\"asc\"},\"name\":{\"visible\":true,\"sorting\":false},\"email\":{\"visible\":true,\"sorting\":false},\"billing_telephone\":{\"visible\":true,\"sorting\":false},\"billing_postcode\":{\"visible\":true,\"sorting\":false},\"billing_region\":{\"visible\":true,\"sorting\":false},\"confirmation\":{\"visible\":true,\"sorting\":false},\"created_in\":{\"visible\":true,\"sorting\":false},\"billing_full\":{\"visible\":false,\"sorting\":false},\"shipping_full\":{\"visible\":false,\"sorting\":false},\"taxvat\":{\"visible\":true,\"sorting\":false},\"billing_street\":{\"visible\":false,\"sorting\":false},\"billing_city\":{\"visible\":false,\"sorting\":false},\"billing_fax\":{\"visible\":false,\"sorting\":false},\"billing_vat_id\":{\"visible\":false,\"sorting\":false},\"billing_company\":{\"visible\":false,\"sorting\":false},\"billing_firstname\":{\"visible\":false,\"sorting\":false},\"billing_lastname\":{\"visible\":false,\"sorting\":false},\"lock_expires\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"group_id\":{\"visible\":true,\"sorting\":false},\"billing_country_id\":{\"visible\":true,\"sorting\":false},\"website_id\":{\"visible\":true,\"sorting\":false},\"gender\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"dob\":{\"visible\":true,\"sorting\":false}},\"positions\":{\"ids\":0,\"entity_id\":1,\"name\":2,\"email\":3,\"group_id\":4,\"billing_telephone\":5,\"billing_postcode\":6,\"billing_country_id\":7,\"billing_region\":8,\"created_at\":9,\"website_id\":10,\"confirmation\":11,\"created_in\":12,\"billing_full\":13,\"shipping_full\":14,\"dob\":15,\"taxvat\":16,\"gender\":17,\"billing_street\":18,\"billing_city\":19,\"billing_fax\":20,\"billing_vat_id\":21,\"billing_company\":22,\"billing_firstname\":23,\"billing_lastname\":24,\"lock_expires\":25,\"actions\":26}},\"value\":\"Default View\"}}}','2021-08-25 06:02:02','2021-08-25 06:02:02'),(9,1,'megamenu_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":\"20\"},\"30\":{\"value\":30,\"label\":\"30\"},\"50\":{\"value\":50,\"label\":\"50\"},\"100\":{\"value\":100,\"label\":\"100\"},\"200\":{\"value\":200,\"label\":\"200\"}},\"value\":20},\"columns\":{\"menu_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"type\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"menu_id\":1,\"title\":2,\"identifier\":3,\"type\":4,\"is_active\":5,\"actions\":6}},\"value\":\"Default View\"}}}','2021-08-25 06:07:21','2021-08-25 06:07:21'),(10,1,'megamenu_listing','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":\"20\"},\"30\":{\"value\":30,\"label\":\"30\"},\"50\":{\"value\":50,\"label\":\"50\"},\"100\":{\"value\":100,\"label\":\"100\"},\"200\":{\"value\":200,\"label\":\"200\"}},\"value\":20},\"columns\":{\"menu_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"type\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"menu_id\":1,\"title\":2,\"identifier\":3,\"type\":4,\"is_active\":5,\"actions\":6}}}','2021-08-25 06:07:22','2021-08-25 06:07:22'),(11,1,'slideshow_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"slideshow_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false},\"creation_time\":{\"visible\":true,\"sorting\":false},\"update_time\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"slideshow_id\":1,\"title\":2,\"identifier\":3,\"is_active\":4,\"creation_time\":5,\"update_time\":6,\"actions\":7}},\"value\":\"Default View\"}}}','2021-08-25 06:14:29','2021-08-25 06:14:29'),(12,1,'slideshow_listing','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"slideshow_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false},\"creation_time\":{\"visible\":true,\"sorting\":false},\"update_time\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"slideshow_id\":1,\"title\":2,\"identifier\":3,\"is_active\":4,\"creation_time\":5,\"update_time\":6,\"actions\":7}}}','2021-08-25 06:14:30','2021-08-25 06:14:30'),(13,1,'mageworx_optiontemplates_group_listing','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"search\":{\"value\":\"\"},\"columns\":{\"group_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"products\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"positions\":{\"ids\":0,\"group_id\":1,\"title\":2,\"products\":3,\"actions\":4}}}','2021-08-25 08:09:37','2021-08-25 08:09:39'),(14,1,'mageworx_optiontemplates_group_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"search\":{\"value\":\"\"},\"columns\":{\"group_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"products\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"positions\":{\"ids\":0,\"group_id\":1,\"title\":2,\"products\":3,\"actions\":4}},\"value\":\"Default View\"}}}','2021-08-25 08:09:40','2021-08-25 08:09:40'),(15,1,'cms_page_listing','current',0,NULL,'{\"current\":{\"columns\":{\"page_layout\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false},\"custom_theme\":{\"visible\":false,\"sorting\":false},\"custom_root_template\":{\"visible\":false,\"sorting\":false},\"creation_time\":{\"visible\":true,\"sorting\":false},\"update_time\":{\"visible\":true,\"sorting\":\"desc\"},\"custom_theme_from\":{\"visible\":false,\"sorting\":false},\"custom_theme_to\":{\"visible\":false,\"sorting\":false},\"page_id\":{\"visible\":true,\"sorting\":false},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false},\"meta_keywords\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"positions\":{\"ids\":0,\"page_id\":1,\"title\":2,\"identifier\":3,\"page_layout\":4,\"store_id\":5,\"is_active\":6,\"creation_time\":7,\"update_time\":8,\"custom_theme_from\":9,\"custom_theme_to\":10,\"custom_theme\":11,\"custom_root_template\":12,\"meta_title\":13,\"meta_keywords\":14,\"meta_description\":15,\"actions\":16},\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}}}}','2021-08-26 00:52:15','2022-03-03 04:58:41'),(16,1,'cms_page_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"columns\":{\"page_layout\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false},\"custom_theme\":{\"visible\":false,\"sorting\":false},\"custom_root_template\":{\"visible\":false,\"sorting\":false},\"creation_time\":{\"visible\":true,\"sorting\":false},\"update_time\":{\"visible\":true,\"sorting\":false},\"custom_theme_from\":{\"visible\":false,\"sorting\":false},\"custom_theme_to\":{\"visible\":false,\"sorting\":false},\"page_id\":{\"visible\":true,\"sorting\":\"asc\"},\"title\":{\"visible\":true,\"sorting\":false},\"identifier\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"meta_title\":{\"visible\":false,\"sorting\":false},\"meta_keywords\":{\"visible\":false,\"sorting\":false},\"meta_description\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"positions\":{\"ids\":0,\"page_id\":1,\"title\":2,\"identifier\":3,\"page_layout\":4,\"store_id\":5,\"is_active\":6,\"creation_time\":7,\"update_time\":8,\"custom_theme_from\":9,\"custom_theme_to\":10,\"custom_theme\":11,\"custom_root_template\":12,\"meta_title\":13,\"meta_keywords\":14,\"meta_description\":15,\"actions\":16},\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}}},\"value\":\"Default View\"}}}','2021-08-26 00:52:16','2021-08-26 00:52:16'),(17,1,'product_attributes_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"displayMode\":\"grid\",\"columns\":{\"attribute_code\":{\"visible\":true,\"sorting\":\"asc\"},\"frontend_label\":{\"visible\":true,\"sorting\":false},\"is_required\":{\"visible\":true,\"sorting\":false},\"is_user_defined\":{\"visible\":true,\"sorting\":false},\"is_visible\":{\"visible\":true,\"sorting\":false},\"is_global\":{\"visible\":true,\"sorting\":false},\"is_searchable\":{\"visible\":true,\"sorting\":false},\"is_comparable\":{\"visible\":true,\"sorting\":false},\"is_filterable\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"positions\":{\"ids\":0,\"attribute_code\":1,\"frontend_label\":2,\"is_required\":3,\"is_user_defined\":4,\"is_visible\":5,\"is_global\":6,\"is_searchable\":7,\"is_comparable\":8,\"is_filterable\":9}},\"value\":\"Default View\"}}}','2021-08-27 03:55:37','2021-08-27 03:55:37'),(18,1,'product_attributes_listing','current',0,NULL,'{\"current\":{\"displayMode\":\"grid\",\"columns\":{\"attribute_code\":{\"visible\":true,\"sorting\":\"asc\"},\"frontend_label\":{\"visible\":true,\"sorting\":false},\"is_required\":{\"visible\":true,\"sorting\":false},\"is_user_defined\":{\"visible\":true,\"sorting\":false},\"is_visible\":{\"visible\":true,\"sorting\":false},\"is_global\":{\"visible\":true,\"sorting\":false},\"is_searchable\":{\"visible\":true,\"sorting\":false},\"is_comparable\":{\"visible\":true,\"sorting\":false},\"is_filterable\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"positions\":{\"ids\":0,\"attribute_code\":1,\"frontend_label\":2,\"is_required\":3,\"is_user_defined\":4,\"is_visible\":5,\"is_global\":6,\"is_searchable\":7,\"is_comparable\":8,\"is_filterable\":9}}}','2021-08-27 03:55:38','2021-08-27 03:55:38'),(19,1,'inventory_source_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"displayMode\":\"grid\",\"columns\":{\"ids\":{\"visible\":true,\"sorting\":false},\"source_code\":{\"visible\":true,\"sorting\":false},\"name\":{\"visible\":true,\"sorting\":false},\"contact_name\":{\"visible\":false,\"sorting\":false},\"email\":{\"visible\":false,\"sorting\":false},\"enabled\":{\"visible\":true,\"sorting\":false},\"latitude\":{\"visible\":false,\"sorting\":false},\"longitude\":{\"visible\":false,\"sorting\":false},\"country_id\":{\"visible\":false,\"sorting\":false},\"region\":{\"visible\":false,\"sorting\":false},\"city\":{\"visible\":false,\"sorting\":false},\"street\":{\"visible\":false,\"sorting\":false},\"postcode\":{\"visible\":false,\"sorting\":false},\"phone\":{\"visible\":false,\"sorting\":false},\"fax\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"is_pickup_location_active\":{\"visible\":true,\"sorting\":false}},\"positions\":{\"ids\":0,\"source_code\":1,\"name\":2,\"contact_name\":3,\"enabled\":4,\"email\":5,\"is_pickup_location_active\":6,\"latitude\":7,\"longitude\":8,\"country_id\":9,\"region\":10,\"city\":11,\"street\":12,\"postcode\":13,\"phone\":14,\"fax\":15,\"actions\":16},\"search\":{\"value\":\"\"}},\"value\":\"Default View\"}}}','2021-08-27 04:02:55','2021-08-27 04:02:55'),(20,1,'inventory_source_listing','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"displayMode\":\"grid\",\"columns\":{\"ids\":{\"visible\":true,\"sorting\":false},\"source_code\":{\"visible\":true,\"sorting\":false},\"name\":{\"visible\":true,\"sorting\":false},\"contact_name\":{\"visible\":false,\"sorting\":false},\"email\":{\"visible\":false,\"sorting\":false},\"enabled\":{\"visible\":true,\"sorting\":false},\"latitude\":{\"visible\":false,\"sorting\":false},\"longitude\":{\"visible\":false,\"sorting\":false},\"country_id\":{\"visible\":false,\"sorting\":false},\"region\":{\"visible\":false,\"sorting\":false},\"city\":{\"visible\":false,\"sorting\":false},\"street\":{\"visible\":false,\"sorting\":false},\"postcode\":{\"visible\":false,\"sorting\":false},\"phone\":{\"visible\":false,\"sorting\":false},\"fax\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"is_pickup_location_active\":{\"visible\":true,\"sorting\":false}},\"positions\":{\"ids\":0,\"source_code\":1,\"name\":2,\"contact_name\":3,\"enabled\":4,\"email\":5,\"is_pickup_location_active\":6,\"latitude\":7,\"longitude\":8,\"country_id\":9,\"region\":10,\"city\":11,\"street\":12,\"postcode\":13,\"phone\":14,\"fax\":15,\"actions\":16},\"search\":{\"value\":\"\"}}}','2021-08-27 04:02:56','2021-08-27 04:02:56'),(21,1,'rewards_transaction_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"transaction_id\":{\"visible\":true,\"sorting\":\"desc\"},\"customer_name\":{\"visible\":true,\"sorting\":false},\"customer_email\":{\"visible\":true,\"sorting\":false},\"amount\":{\"visible\":true,\"sorting\":false},\"comment\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"customer_group_id\":{\"visible\":true,\"sorting\":false},\"is_activated\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\"},\"value\":\"Default View\"}}}','2021-12-24 06:29:16','2021-12-24 06:29:16'),(22,1,'rewards_transaction_listing','current',0,NULL,'{\"current\":{\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"transaction_id\":{\"visible\":true,\"sorting\":\"desc\"},\"customer_name\":{\"visible\":true,\"sorting\":false},\"customer_email\":{\"visible\":true,\"sorting\":false},\"amount\":{\"visible\":true,\"sorting\":false},\"comment\":{\"visible\":true,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"customer_group_id\":{\"visible\":true,\"sorting\":false},\"is_activated\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"expires_at\":{\"visible\":true,\"sorting\":false},\"activated_at\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"transaction_id\":1,\"customer_name\":2,\"customer_email\":3,\"customer_group_id\":4,\"amount\":5,\"comment\":6,\"created_at\":7,\"expires_at\":8,\"activated_at\":9,\"is_activated\":10,\"actions\":11}}}','2021-12-24 06:29:17','2021-12-24 06:29:20'),(23,1,'rewards_overview16a34199945dd2ac2a071fff2446c8ae','current',1,NULL,'{\"columns\":[\"mst_rewards_points_aggregated_hour|order_earn__sum\",\"mst_rewards_points_aggregated_hour|inactivity__sum\",\"mst_rewards_points_aggregated_hour|send_link__sum\",\"mst_rewards_points_aggregated_hour|order_earn_cancel__sum\",\"mst_rewards_points_aggregated_hour|order_refund__sum\",\"mst_rewards_points_aggregated_hour|order_spend__sum\",\"mst_rewards_points_aggregated_hour|order_spend_restore__sum\",\"mst_rewards_points_aggregated_hour|expired_points__sum\",\"mst_rewards_points_aggregated_hour|total_points_spent_in_money__sum\",\"mst_rewards_points_aggregated_hour|admin_transaction__sum\",\"mst_rewards_points_aggregated_hour|facebook_like__sum\",\"mst_rewards_points_aggregated_hour|pinterest_pin__sum\",\"mst_rewards_points_aggregated_hour|twitter_tweet__sum\",\"mst_rewards_points_aggregated_hour|create_rma__sum\",\"mst_rewards_points_aggregated_hour|signup__sum\"],\"dimensions\":[\"mst_rewards_points_aggregated_hour|period__day\"],\"sortOrders\":[],\"filters\":[{\"column\":\"mst_rewards_points_aggregated_hour|period\",\"conditionType\":\"gteq\",\"value\":\"2021-12-01 00:00:00\"},{\"column\":\"mst_rewards_points_aggregated_hour|period\",\"conditionType\":\"lteq\",\"value\":\"2021-12-31 23:59:59\"}],\"pageSize\":20}','2021-12-24 00:00:00','2021-12-24 00:00:00'),(24,1,'rewards_earning_rule_listing','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"}},\"value\":\"Default View\"}}}','2022-01-28 09:46:30','2022-01-28 09:46:30'),(25,1,'rewards_earning_rule_listing','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"columns\":{\"earning_rule_id\":{\"visible\":true,\"sorting\":\"desc\"},\"name\":{\"visible\":true,\"sorting\":false},\"earn_points_str\":{\"visible\":true,\"sorting\":false},\"sort_order\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":false,\"sorting\":false},\"website_ids\":{\"visible\":true,\"sorting\":false},\"is_active\":{\"visible\":true,\"sorting\":false},\"type\":{\"visible\":false,\"sorting\":false},\"is_stop_processing\":{\"visible\":false,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"active_from\":{\"visible\":false,\"sorting\":false},\"active_to\":{\"visible\":false,\"sorting\":false}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"filters\":{\"applied\":{\"placeholder\":true}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"earning_rule_id\":1,\"name\":2,\"earn_points_str\":3,\"website_ids\":4,\"is_active\":5,\"type\":6,\"active_from\":7,\"active_to\":8,\"is_stop_processing\":9,\"sort_order\":10,\"actions\":11}}}','2022-01-28 09:46:32','2022-01-28 09:46:36'),(26,1,'sales_order_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"billing_name\":{\"visible\":true,\"sorting\":false},\"shipping_name\":{\"visible\":true,\"sorting\":false},\"base_grand_total\":{\"visible\":true,\"sorting\":false},\"grand_total\":{\"visible\":true,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"subtotal\":{\"visible\":false,\"sorting\":false},\"shipping_and_handling\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"total_refunded\":{\"visible\":false,\"sorting\":false},\"refunded_to_store_credit\":{\"visible\":false,\"sorting\":false},\"pickup_location_code\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"status\":{\"visible\":true,\"sorting\":false},\"customer_group\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":\"desc\"},\"allocated_sources\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"increment_id\":1,\"store_id\":2,\"created_at\":3,\"billing_name\":4,\"shipping_name\":5,\"base_grand_total\":6,\"grand_total\":7,\"status\":8,\"billing_address\":9,\"shipping_address\":10,\"shipping_information\":11,\"customer_email\":12,\"customer_group\":13,\"subtotal\":14,\"shipping_and_handling\":15,\"customer_name\":16,\"payment_method\":17,\"total_refunded\":18,\"actions\":19,\"refunded_to_store_credit\":20,\"allocated_sources\":21,\"pickup_location_code\":22}},\"value\":\"Default View\"}}}','2022-03-24 06:05:00','2022-03-24 06:05:00'),(27,1,'sales_order_grid','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":true,\"sorting\":false},\"billing_name\":{\"visible\":true,\"sorting\":false},\"shipping_name\":{\"visible\":true,\"sorting\":false},\"base_grand_total\":{\"visible\":true,\"sorting\":false},\"grand_total\":{\"visible\":true,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"subtotal\":{\"visible\":false,\"sorting\":false},\"shipping_and_handling\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"total_refunded\":{\"visible\":false,\"sorting\":false},\"refunded_to_store_credit\":{\"visible\":false,\"sorting\":false},\"pickup_location_code\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"status\":{\"visible\":true,\"sorting\":false},\"customer_group\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":\"desc\"},\"allocated_sources\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"increment_id\":1,\"store_id\":2,\"created_at\":3,\"billing_name\":4,\"shipping_name\":5,\"base_grand_total\":6,\"grand_total\":7,\"status\":8,\"billing_address\":9,\"shipping_address\":10,\"shipping_information\":11,\"customer_email\":12,\"customer_group\":13,\"subtotal\":14,\"shipping_and_handling\":15,\"customer_name\":16,\"payment_method\":17,\"total_refunded\":18,\"actions\":19,\"refunded_to_store_credit\":20,\"allocated_sources\":21,\"pickup_location_code\":22}}}','2022-03-24 06:05:01','2022-03-24 06:05:01'),(28,1,'sales_order_view_invoice_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":\"asc\"},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"billing_name\":{\"visible\":true,\"sorting\":false},\"grand_total\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":false,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"subtotal\":{\"visible\":false,\"sorting\":false},\"shipping_and_handling\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"state\":{\"visible\":true,\"sorting\":false},\"customer_group_id\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"order_created_at\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"increment_id\":1,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"billing_name\":5,\"state\":6,\"grand_total\":7,\"store_id\":8,\"billing_address\":9,\"shipping_address\":10,\"customer_name\":11,\"customer_email\":12,\"customer_group_id\":13,\"payment_method\":14,\"shipping_information\":15,\"subtotal\":16,\"shipping_and_handling\":17,\"actions\":18}},\"value\":\"Default View\"}}}','2022-03-24 06:05:10','2022-03-24 06:05:10'),(29,1,'sales_order_view_shipment_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":\"asc\"},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"shipping_name\":{\"visible\":true,\"sorting\":false},\"total_qty\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"order_status\":{\"visible\":false,\"sorting\":false},\"customer_group_id\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"order_created_at\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"increment_id\":1,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"shipping_name\":5,\"total_qty\":6,\"order_status\":7,\"store_id\":8,\"customer_name\":9,\"customer_email\":10,\"customer_group_id\":11,\"billing_address\":12,\"shipping_address\":13,\"payment_method\":14,\"shipping_information\":15,\"actions\":16}},\"value\":\"Default View\"}}}','2022-03-24 06:05:11','2022-03-24 06:05:11'),(30,1,'sales_order_view_creditmemo_grid','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":false},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"billing_name\":{\"visible\":true,\"sorting\":false},\"base_grand_total\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":false,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"subtotal\":{\"visible\":false,\"sorting\":false},\"shipping_and_handling\":{\"visible\":false,\"sorting\":false},\"adjustment_positive\":{\"visible\":false,\"sorting\":false},\"adjustment_negative\":{\"visible\":false,\"sorting\":false},\"order_base_grand_total\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"state\":{\"visible\":true,\"sorting\":false},\"order_status\":{\"visible\":false,\"sorting\":false},\"customer_group_id\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"order_created_at\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"increment_id\":1,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"billing_name\":5,\"state\":6,\"base_grand_total\":7,\"order_status\":8,\"store_id\":9,\"billing_address\":10,\"shipping_address\":11,\"customer_name\":12,\"customer_email\":13,\"customer_group_id\":14,\"payment_method\":15,\"shipping_information\":16,\"subtotal\":17,\"shipping_and_handling\":18,\"adjustment_positive\":19,\"adjustment_negative\":20,\"order_base_grand_total\":21,\"actions\":22}}}','2022-03-24 06:05:11','2022-03-24 06:05:11'),(31,1,'sales_order_view_creditmemo_grid','default',1,'Default View','{\"views\":{\"default\":{\"label\":\"Default View\",\"index\":\"default\",\"editable\":false,\"data\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":false},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"billing_name\":{\"visible\":true,\"sorting\":false},\"base_grand_total\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":false,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"subtotal\":{\"visible\":false,\"sorting\":false},\"shipping_and_handling\":{\"visible\":false,\"sorting\":false},\"adjustment_positive\":{\"visible\":false,\"sorting\":false},\"adjustment_negative\":{\"visible\":false,\"sorting\":false},\"order_base_grand_total\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"state\":{\"visible\":true,\"sorting\":false},\"order_status\":{\"visible\":false,\"sorting\":false},\"customer_group_id\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"order_created_at\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"increment_id\":1,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"billing_name\":5,\"state\":6,\"base_grand_total\":7,\"order_status\":8,\"store_id\":9,\"billing_address\":10,\"shipping_address\":11,\"customer_name\":12,\"customer_email\":13,\"customer_group_id\":14,\"payment_method\":15,\"shipping_information\":16,\"subtotal\":17,\"shipping_and_handling\":18,\"adjustment_positive\":19,\"adjustment_negative\":20,\"order_base_grand_total\":21,\"actions\":22}},\"value\":\"Default View\"}}}','2022-03-24 06:05:12','2022-03-24 06:05:12'),(32,1,'sales_order_view_invoice_grid','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":\"asc\"},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"billing_name\":{\"visible\":true,\"sorting\":false},\"grand_total\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":false,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"subtotal\":{\"visible\":false,\"sorting\":false},\"shipping_and_handling\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"state\":{\"visible\":true,\"sorting\":false},\"customer_group_id\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"order_created_at\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"increment_id\":1,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"billing_name\":5,\"state\":6,\"grand_total\":7,\"store_id\":8,\"billing_address\":9,\"shipping_address\":10,\"customer_name\":11,\"customer_email\":12,\"customer_group_id\":13,\"payment_method\":14,\"shipping_information\":15,\"subtotal\":16,\"shipping_and_handling\":17,\"actions\":18}}}','2022-03-24 06:05:12','2022-03-24 06:05:12'),(33,1,'sales_order_view_shipment_grid','current',0,NULL,'{\"current\":{\"search\":{\"value\":\"\"},\"filters\":{\"applied\":{\"placeholder\":true}},\"paging\":{\"pageSize\":20,\"current\":1,\"options\":{\"20\":{\"value\":20,\"label\":20},\"30\":{\"value\":30,\"label\":30},\"50\":{\"value\":50,\"label\":50},\"100\":{\"value\":100,\"label\":100},\"200\":{\"value\":200,\"label\":200}},\"value\":20},\"columns\":{\"increment_id\":{\"visible\":true,\"sorting\":\"asc\"},\"order_increment_id\":{\"visible\":true,\"sorting\":false},\"shipping_name\":{\"visible\":true,\"sorting\":false},\"total_qty\":{\"visible\":true,\"sorting\":false},\"store_id\":{\"visible\":false,\"sorting\":false},\"customer_name\":{\"visible\":false,\"sorting\":false},\"customer_email\":{\"visible\":false,\"sorting\":false},\"billing_address\":{\"visible\":false,\"sorting\":false},\"shipping_address\":{\"visible\":false,\"sorting\":false},\"shipping_information\":{\"visible\":false,\"sorting\":false},\"actions\":{\"visible\":true,\"sorting\":false},\"ids\":{\"visible\":true,\"sorting\":false},\"order_status\":{\"visible\":false,\"sorting\":false},\"customer_group_id\":{\"visible\":false,\"sorting\":false},\"payment_method\":{\"visible\":false,\"sorting\":false},\"created_at\":{\"visible\":true,\"sorting\":false},\"order_created_at\":{\"visible\":true,\"sorting\":false}},\"displayMode\":\"grid\",\"positions\":{\"ids\":0,\"increment_id\":1,\"created_at\":2,\"order_increment_id\":3,\"order_created_at\":4,\"shipping_name\":5,\"total_qty\":6,\"order_status\":7,\"store_id\":8,\"customer_name\":9,\"customer_email\":10,\"customer_group_id\":11,\"billing_address\":12,\"shipping_address\":13,\"payment_method\":14,\"shipping_information\":15,\"actions\":16}}}','2022-03-24 06:05:12','2022-03-24 06:05:12');

--
-- Table structure for table `wal_url_rewrite`
--

CREATE TABLE `wal_url_rewrite` (
  `url_rewrite_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rewrite ID',
  `entity_type` varchar(32) NOT NULL COMMENT 'Entity type code',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `request_path` varchar(255) DEFAULT NULL COMMENT 'Request Path',
  `target_path` varchar(255) DEFAULT NULL COMMENT 'Target Path',
  `redirect_type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Redirect Type',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `description` varchar(255) DEFAULT NULL COMMENT 'Description',
  `is_autogenerated` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is rewrite generated automatically flag',
  `metadata` varchar(255) DEFAULT NULL COMMENT 'Meta data for url rewrite',
  PRIMARY KEY (`url_rewrite_id`),
  UNIQUE KEY `WAL_URL_REWRITE_REQUEST_PATH_STORE_ID` (`request_path`,`store_id`),
  KEY `WAL_URL_REWRITE_TARGET_PATH` (`target_path`),
  KEY `WAL_URL_REWRITE_STORE_ID_ENTITY_ID` (`store_id`,`entity_id`),
  KEY `WAL_URL_REWRITE_ENTITY_ID` (`entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='Url Rewrites';

--
-- Dumping data for table `wal_url_rewrite`
--

INSERT INTO `wal_url_rewrite` VALUES (1,'cms-page',1,'no-route','cms/page/view/page_id/1',0,1,NULL,1,NULL),(2,'cms-page',2,'home','cms/page/view/page_id/2',0,1,NULL,1,NULL),(3,'cms-page',3,'enable-cookies','cms/page/view/page_id/3',0,1,NULL,1,NULL),(4,'cms-page',4,'privacy-policy-cookie-restriction-mode','cms/page/view/page_id/4',0,1,NULL,1,NULL),(5,'cms-page',5,'about-us','cms/page/view/page_id/5',0,1,NULL,1,NULL),(6,'cms-page',6,'customer-service','cms/page/view/page_id/6',0,1,NULL,1,NULL),(7,'cms-page',7,'clothing-accessies-home-page','cms/page/view/page_id/7',0,1,NULL,1,NULL),(8,'cms-page',8,'codazon-fastest-home-two-columns','cms/page/view/page_id/8',0,1,NULL,1,NULL),(9,'cms-page',9,'webkul','cms/page/view/page_id/9',0,1,NULL,1,NULL),(10,'cms-page',10,'webkul-seller','cms/page/view/page_id/10',0,1,NULL,1,NULL),(11,'category',3,'demo-category/','catalog/category/view/id/3',0,1,NULL,1,NULL),(13,'product',1,'demo-product.html','catalog/product/view/id/1',0,1,NULL,1,NULL),(14,'product',1,'demo-category/demo-product.html','catalog/product/view/id/1/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(15,'cms-page',11,'reward-points','cms/page/view/page_id/11',0,1,NULL,1,NULL),(16,'cms-page',12,'brands','cms/page/view/page_id/12',0,1,NULL,1,NULL),(17,'cms-page',13,'review-test','cms/page/view/page_id/13',0,1,NULL,1,NULL);

--
-- Table structure for table `wal_variable`
--

CREATE TABLE `wal_variable` (
  `variable_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Variable ID',
  `code` varchar(255) DEFAULT NULL COMMENT 'Variable Code',
  `name` varchar(255) DEFAULT NULL COMMENT 'Variable Name',
  PRIMARY KEY (`variable_id`),
  UNIQUE KEY `WAL_VARIABLE_CODE` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Variables';

--
-- Dumping data for table `wal_variable`
--


--
-- Table structure for table `wal_variable_value`
--

CREATE TABLE `wal_variable_value` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Variable Value ID',
  `variable_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Variable ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `plain_value` text COMMENT 'Plain Text Value',
  `html_value` text COMMENT 'Html Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `WAL_VARIABLE_VALUE_VARIABLE_ID_STORE_ID` (`variable_id`,`store_id`),
  KEY `WAL_VARIABLE_VALUE_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_VARIABLE_VALUE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_VARIABLE_VALUE_VARIABLE_ID_WAL_VARIABLE_VARIABLE_ID` FOREIGN KEY (`variable_id`) REFERENCES `wal_variable` (`variable_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Variable Value';

--
-- Dumping data for table `wal_variable_value`
--


--
-- Table structure for table `wal_vault_payment_token`
--

CREATE TABLE `wal_vault_payment_token` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `public_hash` varchar(128) NOT NULL COMMENT 'Hash code for using on frontend',
  `payment_method_code` varchar(128) NOT NULL COMMENT 'Payment method code',
  `type` varchar(128) NOT NULL COMMENT 'Type',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `expires_at` timestamp NULL DEFAULT NULL COMMENT 'Expires At',
  `gateway_token` varchar(255) NOT NULL COMMENT 'Gateway Token',
  `details` text COMMENT 'Details',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_visible` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `WAL_VAULT_PAYMENT_TOKEN_PUBLIC_HASH` (`public_hash`),
  UNIQUE KEY `UNQ_9BBB7DAF138FF3FE626399F7A647217B` (`payment_method_code`,`customer_id`,`gateway_token`),
  KEY `WAL_VAULT_PAYMENT_TOKEN_CSTR_ID_WAL_CSTR_ENTT_ENTT_ID` (`customer_id`),
  CONSTRAINT `WAL_VAULT_PAYMENT_TOKEN_CSTR_ID_WAL_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Vault tokens of payment';

--
-- Dumping data for table `wal_vault_payment_token`
--


--
-- Table structure for table `wal_vault_payment_token_order_payment_link`
--

CREATE TABLE `wal_vault_payment_token_order_payment_link` (
  `order_payment_id` int(10) unsigned NOT NULL COMMENT 'Order payment ID',
  `payment_token_id` int(10) unsigned NOT NULL COMMENT 'Payment token ID',
  PRIMARY KEY (`order_payment_id`,`payment_token_id`),
  KEY `FK_EB9C9BB58D0B99E682915CD860E17378` (`payment_token_id`),
  CONSTRAINT `FK_EB9C9BB58D0B99E682915CD860E17378` FOREIGN KEY (`payment_token_id`) REFERENCES `wal_vault_payment_token` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_EF75D9AC7EAB9AF360B4F6798C674E3F` FOREIGN KEY (`order_payment_id`) REFERENCES `wal_sales_order_payment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Order payments to vault token';

--
-- Dumping data for table `wal_vault_payment_token_order_payment_link`
--


--
-- Table structure for table `wal_visual_merchandiser_rule`
--

CREATE TABLE `wal_visual_merchandiser_rule` (
  `rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule Id',
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `is_active` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `conditions_serialized` mediumtext COMMENT 'Conditions Serialized',
  PRIMARY KEY (`rule_id`),
  UNIQUE KEY `WAL_VISUAL_MERCHANDISER_RULE_CATEGORY_ID_STORE_ID` (`category_id`,`store_id`),
  KEY `WAL_VISUAL_MERCHANDISER_RULE_CATEGORY_ID` (`category_id`),
  KEY `WAL_VISUAL_MERCHANDISER_RULE_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_VISUAL_MERCHANDISER_RULE_CTGR_ID_WAL_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`category_id`) REFERENCES `wal_catalog_category_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_VISUAL_MERCHANDISER_RULE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='VisualMerchandiser Rules Table';

--
-- Dumping data for table `wal_visual_merchandiser_rule`
--


--
-- Table structure for table `wal_walland_optionsmanagement_template`
--

CREATE TABLE `wal_walland_optionsmanagement_template` (
  `template_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Template ID',
  `title` varchar(64) DEFAULT NULL COMMENT 'Title',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `is_replace_product_sku` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is Replace Product SKU',
  PRIMARY KEY (`template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Options Template Table';

--
-- Dumping data for table `wal_walland_optionsmanagement_template`
--


--
-- Table structure for table `wal_walland_optionsmanagement_template_option`
--

CREATE TABLE `wal_walland_optionsmanagement_template_option` (
  `option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID',
  `template_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Template ID',
  `type` varchar(50) DEFAULT NULL COMMENT 'Type',
  `is_require` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Is Required',
  `sku` varchar(64) DEFAULT NULL COMMENT 'SKU',
  `max_characters` int(10) unsigned DEFAULT NULL COMMENT 'Max Characters',
  `file_extension` varchar(50) DEFAULT NULL COMMENT 'File Extension',
  `image_size_x` smallint(5) unsigned DEFAULT NULL COMMENT 'Image Size X',
  `image_size_y` smallint(5) unsigned DEFAULT NULL COMMENT 'Image Size Y',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `class_name` varchar(64) DEFAULT NULL COMMENT 'class_name',
  PRIMARY KEY (`option_id`),
  KEY `WAL_WALLAND_OPTIONSMANAGEMENT_TEMPLATE_OPTION_TEMPLATE_ID` (`template_id`),
  CONSTRAINT `FK_CD85054AEE0A0F6BA3F27F05F9E6BE96` FOREIGN KEY (`template_id`) REFERENCES `wal_walland_optionsmanagement_template` (`template_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Template Option Table';

--
-- Dumping data for table `wal_walland_optionsmanagement_template_option`
--


--
-- Table structure for table `wal_walland_optionsmanagement_template_option_default`
--

CREATE TABLE `wal_walland_optionsmanagement_template_option_default` (
  `option_default_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Default ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `default_text` varchar(255) DEFAULT NULL COMMENT 'Default Text',
  PRIMARY KEY (`option_default_id`),
  UNIQUE KEY `WAL_WALLAND_OPTSMANAGEMENT_TEMPLATE_OPT_DEFAULT_OPT_ID_STORE_ID` (`option_id`,`store_id`),
  KEY `WAL_WALLAND_OPTIONSMANAGEMENT_TEMPLATE_OPTION_DEFAULT_STORE_ID` (`store_id`),
  CONSTRAINT `FK_4CF9DFAE4939BAF5D83F567F82B94999` FOREIGN KEY (`option_id`) REFERENCES `wal_walland_optionsmanagement_template_option` (`option_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_5498BFED37C7955723C5D3FC6F4DC3A1` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Template Option Default Table';

--
-- Dumping data for table `wal_walland_optionsmanagement_template_option_default`
--


--
-- Table structure for table `wal_walland_optionsmanagement_template_option_is_enable`
--

CREATE TABLE `wal_walland_optionsmanagement_template_option_is_enable` (
  `option_is_enable_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Is Enable ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `is_enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Is Enable',
  PRIMARY KEY (`option_is_enable_id`),
  UNIQUE KEY `UNQ_5D57C1D87D9EE6F02587AD529B6577B1` (`option_id`,`store_id`),
  KEY `WAL_WALLAND_OPTIONSMANAGEMENT_TEMPLATE_OPTION_IS_ENABLE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_27EC64C36D1AE31B1D886B03F1432372` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_D0378C78B8E7ABCFF9C5D9391C4D2302` FOREIGN KEY (`option_id`) REFERENCES `wal_walland_optionsmanagement_template_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Template Option Is Enable Table';

--
-- Dumping data for table `wal_walland_optionsmanagement_template_option_is_enable`
--


--
-- Table structure for table `wal_walland_optionsmanagement_template_option_price`
--

CREATE TABLE `wal_walland_optionsmanagement_template_option_price` (
  `option_price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Price ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  `price_type` varchar(7) NOT NULL DEFAULT 'fixed' COMMENT 'Price Type',
  PRIMARY KEY (`option_price_id`),
  UNIQUE KEY `WAL_WALLAND_OPTSMANAGEMENT_TEMPLATE_OPT_PRICE_OPT_ID_STORE_ID` (`option_id`,`store_id`),
  KEY `WAL_WALLAND_OPTIONSMANAGEMENT_TEMPLATE_OPTION_PRICE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_4C954F5C318CCFEFBED0B8E5ABFA0BFC` FOREIGN KEY (`option_id`) REFERENCES `wal_walland_optionsmanagement_template_option` (`option_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_75E0BDC67564B5598BA634B6F165E9FE` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Template Option Price Table';

--
-- Dumping data for table `wal_walland_optionsmanagement_template_option_price`
--


--
-- Table structure for table `wal_walland_optionsmanagement_template_option_title`
--

CREATE TABLE `wal_walland_optionsmanagement_template_option_title` (
  `option_title_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Title ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`option_title_id`),
  UNIQUE KEY `WAL_WALLAND_OPTSMANAGEMENT_TEMPLATE_OPT_TTL_OPT_ID_STORE_ID` (`option_id`,`store_id`),
  KEY `WAL_WALLAND_OPTIONSMANAGEMENT_TEMPLATE_OPTION_TITLE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_D6A9533DBA5FF74F66A51BAA9FA36018` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_F36452DD6FA1DC622047636C7F595BB7` FOREIGN KEY (`option_id`) REFERENCES `wal_walland_optionsmanagement_template_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Template Option Title Table';

--
-- Dumping data for table `wal_walland_optionsmanagement_template_option_title`
--


--
-- Table structure for table `wal_walland_optionsmanagement_template_option_type_price`
--

CREATE TABLE `wal_walland_optionsmanagement_template_option_type_price` (
  `option_type_price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type Price ID',
  `option_type_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option Type ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  `price_type` varchar(7) NOT NULL DEFAULT 'fixed' COMMENT 'Price Type',
  PRIMARY KEY (`option_type_price_id`),
  UNIQUE KEY `UNQ_4FA90730BF290DC10E1472B0F9379C00` (`option_type_id`,`store_id`),
  KEY `WAL_WALLAND_OPTSMANAGEMENT_TEMPLATE_OPT_TYPE_PRICE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_63580350EB291E417F3DFDEDCF8526A8` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_84E7AB504893AABB62D3512638CE9309` FOREIGN KEY (`option_type_id`) REFERENCES `wal_walland_optionsmanagement_template_option_type_value` (`option_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Template Option Type Price Table';

--
-- Dumping data for table `wal_walland_optionsmanagement_template_option_type_price`
--


--
-- Table structure for table `wal_walland_optionsmanagement_template_option_type_title`
--

CREATE TABLE `wal_walland_optionsmanagement_template_option_type_title` (
  `option_type_title_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type Title ID',
  `option_type_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option Type ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`option_type_title_id`),
  UNIQUE KEY `UNQ_FB69F633136E3FC92B7F4C45341FF28E` (`option_type_id`,`store_id`),
  KEY `WAL_WALLAND_OPTSMANAGEMENT_TEMPLATE_OPT_TYPE_TTL_STORE_ID` (`store_id`),
  CONSTRAINT `FK_31F935A77C38F17DCA10073F82848767` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_E72920F35DD69AF32377A710FFB56042` FOREIGN KEY (`option_type_id`) REFERENCES `wal_walland_optionsmanagement_template_option_type_value` (`option_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Template Option Type Title Table';

--
-- Dumping data for table `wal_walland_optionsmanagement_template_option_type_title`
--


--
-- Table structure for table `wal_walland_optionsmanagement_template_option_type_value`
--

CREATE TABLE `wal_walland_optionsmanagement_template_option_type_value` (
  `option_type_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option ID',
  `sku` varchar(64) DEFAULT NULL COMMENT 'SKU',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `default_value` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Default Value',
  `children` text COMMENT 'children',
  PRIMARY KEY (`option_type_id`),
  KEY `WAL_WALLAND_OPTSMANAGEMENT_TEMPLATE_OPT_TYPE_VAL_OPT_ID` (`option_id`),
  CONSTRAINT `FK_A2E4F13A961C37D7F8277A029BBC1AD5` FOREIGN KEY (`option_id`) REFERENCES `wal_walland_optionsmanagement_template_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Template Option Type Value Table';

--
-- Dumping data for table `wal_walland_optionsmanagement_template_option_type_value`
--


--
-- Table structure for table `wal_walland_optionsmanagement_template_product`
--

CREATE TABLE `wal_walland_optionsmanagement_template_product` (
  `template_id` int(10) unsigned NOT NULL COMMENT 'Template ID',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
  PRIMARY KEY (`template_id`,`product_id`),
  KEY `WAL_WALLAND_OPTIONSMANAGEMENT_TEMPLATE_PRODUCT_PRODUCT_ID` (`product_id`),
  CONSTRAINT `FK_0503B93E4CC84E839DD58ED3E5A9E79C` FOREIGN KEY (`template_id`) REFERENCES `wal_walland_optionsmanagement_template` (`template_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_263D00BEF7F28982310E8D5ADFA1E532` FOREIGN KEY (`product_id`) REFERENCES `wal_catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Product To Template Linkage Table';

--
-- Dumping data for table `wal_walland_optionsmanagement_template_product`
--


--
-- Table structure for table `wal_walland_optionsmanagement_template_product_option`
--

CREATE TABLE `wal_walland_optionsmanagement_template_product_option` (
  `template_option_id` int(10) unsigned NOT NULL COMMENT 'Template Option ID',
  `product_option_id` int(10) unsigned NOT NULL COMMENT 'Product Option ID',
  PRIMARY KEY (`template_option_id`,`product_option_id`),
  KEY `WAL_WALLAND_OPTSMANAGEMENT_TEMPLATE_PRD_OPT_PRD_OPT_ID` (`product_option_id`),
  CONSTRAINT `FK_0B2697385E00577BB87F3CB3DD2801C7` FOREIGN KEY (`product_option_id`) REFERENCES `wal_catalog_product_option` (`option_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_897C1C337A918935A77B428FE72491C6` FOREIGN KEY (`template_option_id`) REFERENCES `wal_walland_optionsmanagement_template_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Product Option To Template Option Linkage Table';

--
-- Dumping data for table `wal_walland_optionsmanagement_template_product_option`
--


--
-- Table structure for table `wal_walland_optionsmanagement_template_product_option_type_value`
--

CREATE TABLE `wal_walland_optionsmanagement_template_product_option_type_value` (
  `template_option_type_id` int(10) unsigned NOT NULL COMMENT 'Template Option ID',
  `product_option_type_id` int(10) unsigned NOT NULL COMMENT 'Product Option ID',
  PRIMARY KEY (`template_option_type_id`,`product_option_type_id`),
  KEY `IDX_AD24CE7EAD473A2243D339CCAAF3008C` (`product_option_type_id`),
  CONSTRAINT `FK_EE1E05A944B7ED9D3A8B23BE5AC7E50E` FOREIGN KEY (`template_option_type_id`) REFERENCES `wal_walland_optionsmanagement_template_option_type_value` (`option_type_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_F30922F54C66367698818C992A0BDF47` FOREIGN KEY (`product_option_type_id`) REFERENCES `wal_catalog_product_option_type_value` (`option_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Product Option Type Value To Template Option Type Value Linkage Table';

--
-- Dumping data for table `wal_walland_optionsmanagement_template_product_option_type_value`
--


--
-- Table structure for table `wal_walland_realwedding`
--

CREATE TABLE `wal_walland_realwedding` (
  `rw_id` int(11) NOT NULL AUTO_INCREMENT,
  `image_name` varchar(32) NOT NULL,
  `video` varchar(128) NOT NULL,
  `iframe` varchar(128) NOT NULL,
  `title` varchar(64) NOT NULL,
  `description1` text NOT NULL,
  `blog_link` varchar(128) NOT NULL,
  `description` mediumtext NOT NULL,
  `customer_name` varchar(64) CHARACTER SET utf8mb4 NOT NULL,
  `Customer_identity` varchar(128) NOT NULL,
  `product_link` varchar(128) NOT NULL,
  `sort` int(11) NOT NULL,
  PRIMARY KEY (`rw_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wal_walland_realwedding`
--

INSERT INTO `wal_walland_realwedding` VALUES (1,'Simon and Stacey','','','Simon & Stacey','Simon & Stacey’s wedding is featured on Carly Sarten Photography.','http://www.tulleandchantilly.com/blog/vintage-rustic-wedding-inspiration-the-story-of-stacey-and-her-pastel-colored-bridesmaids/','Dress Style: TBQP237<br>Dress Color: Pink, Passion, Mint, Rose','qwe123','','',13),(2,'Leslie and Ross','','','Leslie & Ross','Leslie & Ross’s wedding is featured on Christina Block Photography.\r\n','http://www.tulleandchantilly.com/blog/romantic-rose-leslie-and-rosss-outdoor-wedding-inspiration/','Dress Style: TBQP237, TBQP198<br>Dress Color: Rose','','','',7),(3,'Sarah and Jeff','','','Sarah & Jeff','Sarah & Jeff\'s wedding is featured on John Rice Photographer. ','http://www.tulleandchantilly.com/blog/lake-wedding-inspiration-the-story-of-sarah-her-orange-maids/','Dress Style: TBQF179<br>Dress Color: Orange','xxxxxx','','',3),(4,'Hannah and Travis','','','Hannah & Travis','Hannah & Travis\'s wedding is featured on Shelley Elena Photography','http://www.tulleandchantilly.com/blog/garden-wedding-inspiration-the-story-of-hannah-and-her-pretty-peach-pink-bridesmaids/','Dress Style: TBQP237<br>Dress Color: Sand Pink','','','',4),(5,'Debbie and Adam','','','Debbie & Adam','Debbie & Adam\'s wedding is featured on Limelife Photography. \r\n','http://www.tulleandchantilly.com/blog/debbie-and-adam-modern-style-beach-wedding-inspiration/','Dress Style: TBQF179<br>Dress Color: Rose, Simmon','','','',5);

--
-- Table structure for table `wal_widget`
--

CREATE TABLE `wal_widget` (
  `widget_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Widget ID',
  `widget_code` varchar(255) DEFAULT NULL COMMENT 'Widget code for template directive',
  `widget_type` varchar(255) DEFAULT NULL COMMENT 'Widget Type',
  `parameters` text COMMENT 'Parameters',
  PRIMARY KEY (`widget_id`),
  KEY `WAL_WIDGET_WIDGET_CODE` (`widget_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Preconfigured Widgets';

--
-- Dumping data for table `wal_widget`
--


--
-- Table structure for table `wal_widget_instance`
--

CREATE TABLE `wal_widget_instance` (
  `instance_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Instance ID',
  `instance_type` varchar(255) DEFAULT NULL COMMENT 'Instance Type',
  `theme_id` int(10) unsigned NOT NULL COMMENT 'Theme ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Widget Title',
  `store_ids` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Store ids',
  `widget_parameters` text COMMENT 'Widget parameters',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort order',
  PRIMARY KEY (`instance_id`),
  KEY `WAL_WIDGET_INSTANCE_THEME_ID_WAL_THEME_THEME_ID` (`theme_id`),
  CONSTRAINT `WAL_WIDGET_INSTANCE_THEME_ID_WAL_THEME_THEME_ID` FOREIGN KEY (`theme_id`) REFERENCES `wal_theme` (`theme_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='Instances of Widget for Package Theme';

--
-- Dumping data for table `wal_widget_instance`
--

INSERT INTO `wal_widget_instance` VALUES (1,'Magento\\Cms\\Block\\Widget\\Block',21,'Fastest - WeStyle Fashion - Main Menu','0','{\"block_id\":\"1\"}',1),(2,'Magento\\Cms\\Block\\Widget\\Block',21,'Fastest - WeStyle Fashion - Home Slideshow','0','{\"block_id\":\"2\"}',0),(3,'Magento\\Cms\\Block\\Widget\\Block',21,'Fastest - WeStyle Fashion - Main Area - New Product','0','{\"block_id\":\"3\"}',0),(4,'Magento\\Cms\\Block\\Widget\\Block',21,'Fastest - WeStyle Fashion - Main Area - Advertisement','0','{\"block_id\":\"4\"}',2),(5,'Magento\\Cms\\Block\\Widget\\Block',21,'Fastest - WeStyle Fashion - Main Area - Best Seller','0','{\"block_id\":\"5\"}',3),(6,'Magento\\Cms\\Block\\Widget\\Block',21,'Fastest - WeStyle Fashion - Main Area - New Blog','0','{\"block_id\":\"6\"}',4),(7,'Magento\\Cms\\Block\\Widget\\Block',21,'Fastest - WeStyle Fashion - Main Area - Instagram','0','{\"block_id\":\"7\"}',5),(8,'Magento\\Cms\\Block\\Widget\\Block',21,'Fastest - WeStyle Fashion - Footer Top - Newsletter','0','{\"block_id\":\"8\"}',0),(9,'Magento\\Cms\\Block\\Widget\\Block',21,'Fastest - WeStyle Fashion - Footer Links','0','{\"block_id\":\"9\"}',0),(10,'Magento\\Cms\\Block\\Widget\\Block',21,'Fastest - WeStyle Fashion - Footer Bottom Payment','0','{\"block_id\":\"10\"}',1);

--
-- Table structure for table `wal_widget_instance_page`
--

CREATE TABLE `wal_widget_instance_page` (
  `page_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Page ID',
  `instance_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance ID',
  `page_group` varchar(25) DEFAULT NULL COMMENT 'Block Group Type',
  `layout_handle` varchar(255) DEFAULT NULL COMMENT 'Layout Handle',
  `block_reference` varchar(255) DEFAULT NULL COMMENT 'Container',
  `page_for` varchar(25) DEFAULT NULL COMMENT 'For instance entities',
  `entities` text COMMENT 'Catalog entities (comma separated)',
  `page_template` varchar(255) DEFAULT NULL COMMENT 'Path to widget template',
  PRIMARY KEY (`page_id`),
  KEY `WAL_WIDGET_INSTANCE_PAGE_INSTANCE_ID` (`instance_id`),
  CONSTRAINT `FK_1D3C43B29EB43A61BF0DE2FCAF88EAC1` FOREIGN KEY (`instance_id`) REFERENCES `wal_widget_instance` (`instance_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='Instance of Widget on Page';

--
-- Dumping data for table `wal_widget_instance_page`
--

INSERT INTO `wal_widget_instance_page` VALUES (1,1,'all_pages','default','menu.container','all','','widget/static_block/default.phtml'),(2,2,'pages','cms_index_index','content.top.right','all','','widget/static_block/default.phtml'),(3,3,'pages','cms_index_index','content','all','','widget/static_block/default.phtml'),(4,4,'pages','cms_index_index','content','all','','widget/static_block/default.phtml'),(5,5,'pages','cms_index_index','content','all','','widget/static_block/default.phtml'),(6,6,'pages','cms_index_index','content','all','','widget/static_block/default.phtml'),(7,7,'pages','cms_index_index','content','all','','widget/static_block/default.phtml'),(8,8,'all_pages','default','footer.content.top','all','','widget/static_block/default.phtml'),(9,9,'all_pages','default','footer.container.wrapper','all','','widget/static_block/default.phtml'),(10,10,'all_pages','default','footer.custom.block','all','','widget/static_block/default.phtml');

--
-- Table structure for table `wal_widget_instance_page_layout`
--

CREATE TABLE `wal_widget_instance_page_layout` (
  `page_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Page ID',
  `layout_update_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Layout Update ID',
  PRIMARY KEY (`layout_update_id`,`page_id`),
  KEY `WAL_WIDGET_INSTANCE_PAGE_LAYOUT_PAGE_ID` (`page_id`),
  CONSTRAINT `FK_16CC4FA750A159EB0073CB28AE0D45C3` FOREIGN KEY (`layout_update_id`) REFERENCES `wal_layout_update` (`layout_update_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_4C83A2229D2221C43515046035ECB973` FOREIGN KEY (`page_id`) REFERENCES `wal_widget_instance_page` (`page_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Layout updates';

--
-- Dumping data for table `wal_widget_instance_page_layout`
--

INSERT INTO `wal_widget_instance_page_layout` VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10);

--
-- Table structure for table `wal_wishlist`
--

CREATE TABLE `wal_wishlist` (
  `wishlist_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Wishlist ID',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer ID',
  `shared` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Sharing flag (0 or 1)',
  `sharing_code` varchar(32) DEFAULT NULL COMMENT 'Sharing encrypted code',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Last updated date',
  PRIMARY KEY (`wishlist_id`),
  UNIQUE KEY `WAL_WISHLIST_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_WISHLIST_SHARED` (`shared`),
  CONSTRAINT `WAL_WISHLIST_CUSTOMER_ID_WAL_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Wishlist main Table';

--
-- Dumping data for table `wal_wishlist`
--

INSERT INTO `wal_wishlist` VALUES (1,1,0,'k0VfISaoMT2PL0DwWDyXOr89ShXOpCI2','2022-03-04 05:55:35');

--
-- Table structure for table `wal_wishlist_item`
--

CREATE TABLE `wal_wishlist_item` (
  `wishlist_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Wishlist item ID',
  `wishlist_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Wishlist ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `added_at` timestamp NULL DEFAULT NULL COMMENT 'Add date and time',
  `description` text COMMENT 'Short description of wish list item',
  `qty` decimal(12,4) NOT NULL COMMENT 'Qty',
  PRIMARY KEY (`wishlist_item_id`),
  KEY `WAL_WISHLIST_ITEM_WISHLIST_ID` (`wishlist_id`),
  KEY `WAL_WISHLIST_ITEM_PRODUCT_ID` (`product_id`),
  KEY `WAL_WISHLIST_ITEM_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_WISHLIST_ITEM_PRD_ID_WAL_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `wal_catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_WISHLIST_ITEM_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE SET NULL,
  CONSTRAINT `WAL_WISHLIST_ITEM_WISHLIST_ID_WAL_WISHLIST_WISHLIST_ID` FOREIGN KEY (`wishlist_id`) REFERENCES `wal_wishlist` (`wishlist_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Wishlist items';

--
-- Dumping data for table `wal_wishlist_item`
--


--
-- Table structure for table `wal_wishlist_item_option`
--

CREATE TABLE `wal_wishlist_item_option` (
  `option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID',
  `wishlist_item_id` int(10) unsigned NOT NULL COMMENT 'Wishlist Item ID',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `value` text COMMENT 'Value',
  PRIMARY KEY (`option_id`),
  KEY `WAL_WISHLIST_ITEM_OPT_PRD_ID_WAL_CAT_PRD_ENTT_ENTT_ID` (`product_id`),
  KEY `FK_48FAC4914DAE1B093317F8B780D1D26E` (`wishlist_item_id`),
  CONSTRAINT `FK_48FAC4914DAE1B093317F8B780D1D26E` FOREIGN KEY (`wishlist_item_id`) REFERENCES `wal_wishlist_item` (`wishlist_item_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Wishlist Item Option Table';

--
-- Dumping data for table `wal_wishlist_item_option`
--


--
-- Table structure for table `wal_yotpo_order_status_history`
--

CREATE TABLE `wal_yotpo_order_status_history` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `order_id` int(10) unsigned DEFAULT NULL COMMENT 'Order Id',
  `store_id` int(10) unsigned DEFAULT NULL COMMENT 'Store Id',
  `old_status` varchar(32) DEFAULT NULL COMMENT 'Old Status',
  `new_status` varchar(32) DEFAULT NULL COMMENT 'New Status',
  `created_at` datetime DEFAULT NULL COMMENT 'Created At',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_yotpo_order_status_history';

--
-- Dumping data for table `wal_yotpo_order_status_history`
--


--
-- Table structure for table `wal_yotpo_rich_snippets`
--

CREATE TABLE `wal_yotpo_rich_snippets` (
  `rich_snippet_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `product_id` int(11) NOT NULL COMMENT 'Product Id',
  `store_id` int(11) NOT NULL COMMENT 'Store Id',
  `average_score` decimal(10,2) NOT NULL COMMENT 'Average Score',
  `reviews_count` float(10,0) NOT NULL COMMENT 'Reviews Count',
  `expiration_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Expiry Time',
  PRIMARY KEY (`rich_snippet_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_yotpo_rich_snippets';

--
-- Dumping data for table `wal_yotpo_rich_snippets`
--


--
-- Table structure for table `wal_yotpo_sync`
--

CREATE TABLE `wal_yotpo_sync` (
  `sync_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `store_id` int(10) unsigned DEFAULT NULL COMMENT 'Store ID',
  `entity_type` varchar(50) DEFAULT NULL COMMENT 'Entity Type',
  `entity_id` int(10) unsigned DEFAULT NULL COMMENT 'Entity ID',
  `sync_flag` smallint(6) DEFAULT '0' COMMENT 'Sync Flag',
  `sync_date` datetime NOT NULL COMMENT 'Sync Date',
  PRIMARY KEY (`sync_id`),
  UNIQUE KEY `WAL_YOTPO_SYNC_STORE_ID_ENTITY_TYPE_ENTITY_ID` (`store_id`,`entity_type`,`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_yotpo_sync';

--
-- Dumping data for table `wal_yotpo_sync`
--


--
-- Final view structure for view `wal_inventory_stock_1`
--

/*!50001 DROP VIEW IF EXISTS `wal_inventory_stock_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`m2base`@`localhost` SQL SECURITY INVOKER */
/*!50001 VIEW `wal_inventory_stock_1` AS select distinct `legacy_stock_status`.`product_id` AS `product_id`,`legacy_stock_status`.`website_id` AS `website_id`,`legacy_stock_status`.`stock_id` AS `stock_id`,`legacy_stock_status`.`qty` AS `quantity`,`legacy_stock_status`.`stock_status` AS `is_salable`,`product`.`sku` AS `sku` from (`wal_cataloginventory_stock_status` `legacy_stock_status` join `wal_catalog_product_entity` `product` on((`legacy_stock_status`.`product_id` = `product`.`entity_id`))) */;


