-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `azcheckout`
--

-- --------------------------------------------------------

--
-- Table structure for table `configurations`
--

CREATE TABLE `configurations` (
  `id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` text,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `migration`
--

CREATE TABLE `migration` (
  `version` varchar(180) NOT NULL,
  `apply_time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  `order_id` varchar(255) DEFAULT NULL,
  `order_name` varchar(255) DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `pin` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `sequare_payment_id` varchar(255) NOT NULL,
  `square_customer_id` varchar(255) DEFAULT NULL,
  `amount` int(11) NOT NULL,
  `currency` varchar(5) NOT NULL,
  `card_status` varchar(128) NOT NULL,
  `card_brand` varchar(128) NOT NULL,
  `last_4` int(11) NOT NULL,
  `expiry` varchar(32) NOT NULL,
  `location_id` varchar(128) NOT NULL,
  `square_order_id` varchar(128) NOT NULL,
  `payment_mode` varchar(128) NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `store_id`, `order_id`, `order_name`, `customer_name`, `email`, `pin`, `country`, `status`, `sequare_payment_id`, `square_customer_id`, `amount`, `currency`, `card_status`, `card_brand`, `last_4`, `expiry`, `location_id`, `square_order_id`, `payment_mode`, `created_at`, `updated_at`) VALUES
(1, 5, '3245686751423', '#1005', 'TB test', 'disha.goyal@brihaspatitech.com', '46958', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-18 04:00:03', '2021-02-18 04:00:03'),
(2, 5, '3245691797695', '#1006', 'TB test', 'disha.goyal@brihaspatitech.com', '46958', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-18 04:07:51', '2021-02-18 04:07:51'),
(3, 5, '3245696581823', '#1007', 'TB test', 'disha.goyal@brihaspatitech.com', '46958', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-18 04:13:17', '2021-02-18 04:13:17'),
(4, 5, '3245846757567', '#1008', 'Disha walia', 'disha.goyal@brihaspatitech.com', '46958', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-18 07:16:11', '2021-02-18 07:16:11'),
(5, 5, '3245922517183', '#1009', 'Disha walia', 'disha.goyal@brihaspatitech.com', '46958', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-18 08:25:41', '2021-02-18 08:25:41'),
(6, 5, '3245926809791', '#1010', 'Disha walia', 'disha.goyal@brihaspatitech.com', '46958', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-18 08:28:46', '2021-02-18 08:28:46'),
(7, 5, '3246978334911', '#1011', 'Disha walia', 'disha.goyal@brihaspatitech.com', '46958', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-19 00:44:25', '2021-02-19 00:44:25'),
(8, 5, '3246992392383', '#1012', 'Disha walia', 'disha.goyal@brihaspatitech.com', '46958', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-19 00:58:16', '2021-02-19 00:58:16'),
(9, 5, '3246994587839', '#1013', 'Disha walia', 'disha.goyal@brihaspatitech.com', '46958', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-19 01:02:12', '2021-02-19 01:02:12'),
(10, 5, '3246997340351', '#1014', 'Disha walia', 'disha.goyal@brihaspatitech.com', '46958', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-19 01:05:57', '2021-02-19 01:05:57'),
(11, 8, '3479434854568', '#2899', 'TB test', 'disha.goyal@brihaspatitech.com', '46958', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-19 07:10:13', '2021-02-19 07:10:13'),
(12, 8, '3479438524584', '#2900', 'TB test', 'disha.goyal@brihaspatitech.com', '46958', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-19 07:12:34', '2021-02-19 07:12:34'),
(13, 8, '3481148162216', '#2901', 'Guillermo Reyes', 'greyes@marinter.com.mx', '06450', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-20 03:41:33', '2021-02-20 03:41:33'),
(14, 8, '3644205072552', '#2943', 'Guillermo Reyes', 'greyes@marinter.com.mx', '06450', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-26 06:06:32', '2021-02-26 06:06:32'),
(15, 8, '3644249571496', '#2944', 'TB test', 'disha.goyal@brihaspatitech.com', '06450', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-26 06:32:55', '2021-02-26 06:32:55'),
(16, 8, '3644262383784', '#2945', 'TB test', 'disha.goyal@brihaspatitech.com', '06450', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-02-26 06:41:02', '2021-02-26 06:41:02'),
(17, 8, '3653636489384', '#2958', 'TB test', 'disha.goyal@brihaspatitech.com', '06450', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-03-03 01:27:31', '2021-03-03 01:27:31'),
(18, 8, '3653646549160', '#2959', 'TB test', 'disha.goyal@brihaspatitech.com', '06450', 'MX', NULL, '', NULL, 0, '', '', '', 0, '', '', '', 'Stripe', '2021-03-03 01:37:54', '2021-03-03 01:37:54');

-- --------------------------------------------------------

--
-- Table structure for table `refunds`
--

CREATE TABLE `refunds` (
  `id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  `order_id` varchar(255) DEFAULT NULL,
  `refund_id` varchar(255) DEFAULT NULL,
  `refund_status` varchar(255) DEFAULT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `square_refund_id` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `reason` text NOT NULL,
  `currency` varchar(32) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `store`
--

CREATE TABLE `store` (
  `id` int(11) NOT NULL,
  `token` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `domain` text,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `store`
--

INSERT INTO `store` (`id`, `token`, `name`, `code`, `status`, `domain`, `created_at`, `updated_at`) VALUES
(8, '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', 'antzara.myshopify.com', 'c21b750f8a6d491746f0287d542c28ab', 1, 'www.antzara.com', '2021-02-19 03:58:29', '2021-02-19 03:58:29'),
(5, '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', 'antzaraapp.myshopify.com', 'baf4c38f1edc5e43641fbb01368589c6', 1, NULL, '2021-02-16 02:20:17', '2021-02-16 02:20:17');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `auth_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password_reset_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` smallint(6) NOT NULL DEFAULT '10',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  `verification_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `configurations`
--
ALTER TABLE `configurations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migration`
--
ALTER TABLE `migration`
  ADD PRIMARY KEY (`version`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `refunds`
--
ALTER TABLE `refunds`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `store`
--
ALTER TABLE `store`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `password_reset_token` (`password_reset_token`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `configurations`
--
ALTER TABLE `configurations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `refunds`
--
ALTER TABLE `refunds`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `store`
--
ALTER TABLE `store`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

