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

START TRANSACTION;



--
-- Database: `reportmulti`
--

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

--
-- Table structure for table `conversions`
--

CREATE TABLE `conversions` (
  `id` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `subid` varchar(20) NOT NULL,
  `offer_name` varchar(12) NOT NULL,
  `country` varchar(32) NOT NULL,
  `payout` double NOT NULL,
  `os` varchar(16) NOT NULL,
  `network` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `hitstat`
--

CREATE TABLE `hitstat` (
  `id` bigint(20) NOT NULL,
  `date` datetime NOT NULL,
  `ip` varchar(128) NOT NULL,
  `country` varchar(64) NOT NULL,
  `device` varchar(12) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `conversions`
--
ALTER TABLE `conversions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hitstat`
--
ALTER TABLE `hitstat`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;COMMIT;

