
CREATE TABLE `rv_dealid` (
  `dealid` int(11) NOT NULL,
  `agencyid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `dsp_type` mediumtext NOT NULL,
  `deal_at` int(11) NOT NULL DEFAULT '1',
  `dealid_token` varchar(255) NOT NULL DEFAULT '',
  `floor_price` decimal(10,2) NOT NULL,
  `start` date NOT NULL DEFAULT '1970-01-01',
  `end` date NOT NULL DEFAULT '1970-01-01',
  `is_pause` int(4) NOT NULL DEFAULT '0',
  `is_expire` int(4) NOT NULL DEFAULT '0',
  `is_delete` int(4) NOT NULL DEFAULT '0',
  `updated` datetime NOT NULL,
  `websites` mediumtext NOT NULL,
  `zones` mediumtext NOT NULL,
  `adsize` mediumtext NOT NULL,
  `deal_comments` varchar(100) NOT NULL DEFAULT '',
  `auction_type` int(11) NOT NULL,
  `created` varchar(50) NOT NULL DEFAULT '',
  `compiledlimitation` mediumtext NOT NULL,
  `acl_plugins` mediumtext NOT NULL,
  `block` varchar(50) NOT NULL DEFAULT '',
  `capping` varchar(50) NOT NULL DEFAULT '',
  `session_capping` varchar(255) NOT NULL DEFAULT '',
  `whitelisted_category` mediumtext NOT NULL,
  `blacklisted_category` mediumtext NOT NULL,
  `cus_width` varchar(10) NOT NULL DEFAULT '',
  `cus_height` varchar(10) NOT NULL DEFAULT '',
  `whitelist` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `rv_dealid`
--
ALTER TABLE `rv_dealid`
  ADD PRIMARY KEY (`dealid`);

--
-- AUTO_INCREMENT for dumped tables
--

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 23, 2022 at 03:45 PM
-- Server version: 5.6.16-1~exp1
-- PHP Version: 7.2.34-28+0~20211119.67+debian9~1.gbpf24e81

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

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

--
-- Table structure for table `rv_exchange_zone_assoc`
--

CREATE TABLE `rv_exchange_zone_assoc` (
  `zoneid` int(11) NOT NULL,
  `req_test` int(11) NOT NULL,
  `req_tmax` int(11) NOT NULL,
  `req_wseat` varchar(200) NOT NULL DEFAULT '',
  `req_allimps` int(11) NOT NULL,
  `req_bcat` varchar(200) NOT NULL DEFAULT '',
  `req_badv` varchar(200) NOT NULL DEFAULT '',
  `req_bapp` varchar(200) NOT NULL DEFAULT '',
  `req_regs` varchar(200) NOT NULL DEFAULT '',
  `imp_dm` varchar(200) NOT NULL DEFAULT '',
  `imp_dms` varchar(200) NOT NULL DEFAULT '',
  `imp_tagid` varchar(200) NOT NULL DEFAULT '',
  `imp_bidfloor` decimal(10,2) NOT NULL,
  `imp_bidfloorcur` char(3) NOT NULL DEFAULT '',
  `imp_cb` int(11) DEFAULT NULL,
  `imp_secure` int(11) NOT NULL,
  `imp_iframe` varchar(200) NOT NULL DEFAULT '',
  `imp_exp` int(11) NOT NULL,
  `imp_pmp` varchar(200) NOT NULL DEFAULT '',
  `ban_btype` varchar(200) NOT NULL DEFAULT '',
  `ban_battr` varchar(200) NOT NULL DEFAULT '',
  `ban_mimes` varchar(200) NOT NULL DEFAULT '',
  `vid_width` int(10) NOT NULL,
  `vid_height` int(10) NOT NULL,
  `vid_playervideo` varchar(250) NOT NULL DEFAULT '',
  `vid_mimes` varchar(100) NOT NULL DEFAULT '',
  `vid_min` int(11) NOT NULL,
  `vid_max` int(11) NOT NULL,
  `vid_protocol` varchar(100) NOT NULL DEFAULT '',
  `vid_sd` int(11) NOT NULL,
  `vid_roll_sec` int(11) NOT NULL,
  `vid_lin` int(11) DEFAULT '1',
  `vid_skip` int(11) NOT NULL,
  `vid_skipmin` int(11) NOT NULL,
  `vid_skipafter` int(11) NOT NULL,
  `vid_seq` int(11) NOT NULL,
  `vid_battr` varchar(200) NOT NULL DEFAULT '',
  `vid_maxext` int(11) NOT NULL,
  `vid_minbit` int(11) NOT NULL,
  `vid_maxbit` int(11) NOT NULL,
  `vid_box` int(1) NOT NULL DEFAULT '1',
  `vid_play` varchar(200) NOT NULL DEFAULT '',
  `vid_del` int(11) NOT NULL,
  `vid_pos` int(11) NOT NULL,
  `vid_compad` varchar(200) NOT NULL DEFAULT '',
  `vid_api` varchar(200) NOT NULL DEFAULT '',
  `vid_comptype` varchar(200) NOT NULL DEFAULT '',
  `vid_comp_width` int(11) NOT NULL,
  `vid_comp_height` int(11) NOT NULL,
  `deal_bidfloor` decimal(10,4) NOT NULL,
  `deal_bidfloorcur` char(3) NOT NULL DEFAULT '',
  `deal_wseat` varchar(50) NOT NULL DEFAULT '',
  `deal_wadomain` varchar(100) NOT NULL DEFAULT '',
  `site_cat` varchar(200) NOT NULL DEFAULT '',
  `site_section` varchar(200) NOT NULL DEFAULT '',
  `site_page` varchar(200) NOT NULL DEFAULT '',
  `site_key` varchar(200) NOT NULL DEFAULT '',
  `site_content` varchar(200) NOT NULL DEFAULT '',
  `site_privacy` int(2) NOT NULL,
  `app_id` varchar(50) NOT NULL DEFAULT '',
  `app_name` varchar(100) NOT NULL DEFAULT '',
  `app_bundle` varchar(100) NOT NULL DEFAULT '',
  `app_url` varchar(200) NOT NULL DEFAULT '',
  `app_cat` varchar(200) NOT NULL DEFAULT '',
  `app_section` varchar(200) NOT NULL DEFAULT '',
  `app_page` varchar(200) NOT NULL DEFAULT '',
  `app_privacy` varchar(200) NOT NULL DEFAULT '',
  `app_ver` varchar(100) NOT NULL DEFAULT '',
  `app_paid` int(2) NOT NULL,
  `app_key` varchar(100) NOT NULL DEFAULT '',
  `pub_cat` varchar(200) NOT NULL DEFAULT '',
  `pub_domain` varchar(250) NOT NULL DEFAULT '',
  `cont_epi` int(100) NOT NULL,
  `cont_title` varchar(100) NOT NULL DEFAULT '',
  `cont_series` varchar(100) NOT NULL DEFAULT '',
  `cont_season` varchar(50) NOT NULL DEFAULT '',
  `cont_prod` varchar(100) NOT NULL DEFAULT '',
  `cont_cat` varchar(200) NOT NULL DEFAULT '',
  `cont_prodq` int(11) NOT NULL,
  `cont_vq` int(11) NOT NULL,
  `cont_context` int(11) NOT NULL,
  `cont_cr` varchar(100) NOT NULL DEFAULT '',
  `cont_ur` varchar(100) NOT NULL DEFAULT '',
  `cont_mr` int(100) NOT NULL,
  `cont_key` varchar(200) NOT NULL DEFAULT '',
  `cont_len` int(100) NOT NULL,
  `cont_lang` varchar(100) NOT NULL DEFAULT '',
  `cont_embed` int(2) NOT NULL,
  `cont_data` varchar(50) NOT NULL DEFAULT '',
  `prod_name` varchar(100) NOT NULL DEFAULT '',
  `prod_cat` varchar(100) NOT NULL DEFAULT '',
  `prod_domain` varchar(100) NOT NULL DEFAULT '',
  `dev_dnt` int(2) NOT NULL,
  `dev_lmt` int(2) NOT NULL,
  `geo_accuracy` int(11) NOT NULL,
  `geo_lf` int(11) NOT NULL,
  `user_bid` varchar(100) NOT NULL DEFAULT '',
  `user_yob` int(11) NOT NULL,
  `user_gender` varchar(50) NOT NULL DEFAULT '',
  `user_key` varchar(200) NOT NULL DEFAULT '',
  `user_cd` varchar(100) NOT NULL DEFAULT '',
  `user_data` varchar(100) NOT NULL DEFAULT '',
  `data_name` varchar(100) NOT NULL DEFAULT '',
  `data_seg` varchar(100) NOT NULL DEFAULT '',
  `seg_name` varchar(100) NOT NULL DEFAULT '',
  `seg_value` varchar(100) NOT NULL DEFAULT '',
  `format_w` int(11) NOT NULL,
  `format_h` int(11) NOT NULL,
  `nat_lay` int(11) NOT NULL,
  `nat_adunit` int(11) NOT NULL,
  `nat_len` int(11) NOT NULL,
  `nat_type` int(11) NOT NULL,
  `nat_width` int(11) NOT NULL,
  `nat_height` int(11) NOT NULL,
  `nat_img_mimes` varchar(100) NOT NULL DEFAULT '',
  `nat_vid_width` int(11) NOT NULL,
  `nat_vid_height` int(11) NOT NULL,
  `nat_vid_playervideo` varchar(100) NOT NULL DEFAULT '',
  `nat_vid_mimes` varchar(100) NOT NULL DEFAULT '',
  `nat_min` int(11) NOT NULL,
  `nat_max` int(11) NOT NULL,
  `nat_vid_protocol` varchar(50) NOT NULL DEFAULT '',
  `nat_datatype` int(11) NOT NULL,
  `nat_datalength` int(11) NOT NULL,
  `nat_lin` int(11) NOT NULL,
  `rtb_id` varchar(20) NOT NULL DEFAULT '',
  `nat_id` varchar(10) NOT NULL DEFAULT '',
  `nat_widheight` varchar(20) NOT NULL DEFAULT '',
  `aud_mimes` varchar(100) NOT NULL DEFAULT '',
  `aud_min` int(11) NOT NULL,
  `aud_max` int(11) NOT NULL,
  `aud_protocol` varchar(50) NOT NULL DEFAULT '',
  `aud_battr` varchar(50) NOT NULL DEFAULT '',
  `aud_maxext` int(11) NOT NULL,
  `aud_minbit` int(11) NOT NULL,
  `aud_maxbit` int(11) NOT NULL,
  `aud_del` varchar(50) NOT NULL DEFAULT '',
  `aud_comptype` varchar(50) NOT NULL DEFAULT '',
  `aud_maxseq` int(11) NOT NULL,
  `aud_feed` int(11) NOT NULL,
  `aud_nvol` int(11) NOT NULL,
  `aud_dl` int(11) NOT NULL,
  `pmp` int(11) NOT NULL,
  `deal_id` varchar(200) NOT NULL DEFAULT '',
  `below_img` varchar(255) NOT NULL DEFAULT '',
  `desk_height` varchar(255) NOT NULL DEFAULT '',
  `desk_width` varchar(255) NOT NULL DEFAULT '',
  `img_height` varchar(255) NOT NULL DEFAULT '',
  `img_width` varchar(255) NOT NULL DEFAULT '',
  `coppa` int(11) NOT NULL,
  `native_objects` mediumtext NOT NULL,
  `gdpr` int(11) NOT NULL,
  `ccpa` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `rv_exchange_zone_assoc`
--
ALTER TABLE `rv_exchange_zone_assoc`
  ADD PRIMARY KEY (`zoneid`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 23, 2022 at 03:27 PM
-- Server version: 5.6.16-1~exp1
-- PHP Version: 7.2.34-28+0~20211119.67+debian9~1.gbpf24e81

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;



-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 23, 2022 at 03:26 PM
-- Server version: 5.6.16-1~exp1
-- PHP Version: 7.2.34-28+0~20211119.67+debian9~1.gbpf24e81

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;


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

--
-- Table structure for table `rv_dj_ad_exchange`
--

CREATE TABLE `rv_dj_ad_exchange` (
  `exchange_id` int(10) NOT NULL,
  `exchange_name` varchar(50) NOT NULL DEFAULT '',
  `added_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `open_rtb_version` int(2) NOT NULL,
  `status` int(2) NOT NULL,
  `ping_url` varchar(255) NOT NULL DEFAULT '',
  `auction_currency` int(15) NOT NULL,
  `auction_type` int(11) NOT NULL,
  `deal_limmit` int(11) NOT NULL,
  `prog_deal` int(10) NOT NULL,
  `open_market` int(10) NOT NULL,
  `both_val` int(10) NOT NULL,
  `gzip` int(11) NOT NULL,
  `digital_signature` varchar(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `rv_dj_ad_exchange`
--
ALTER TABLE `rv_dj_ad_exchange`
  ADD PRIMARY KEY (`exchange_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `rv_dj_ad_exchange`
--
ALTER TABLE `rv_dj_ad_exchange`
  MODIFY `exchange_id` int(10) NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

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

--
-- Table structure for table `rv_dj_ssp_advanced_reports`
--

CREATE TABLE `rv_dj_ssp_advanced_reports` (
  `id` int(11) NOT NULL,
  `banner_type` int(15) NOT NULL,
  `zone_id` int(11) NOT NULL,
  `bidderid` int(11) NOT NULL,
  `pmp_deal` varchar(25) NOT NULL DEFAULT '',
  `country` varchar(25) NOT NULL DEFAULT '',
  `country_name` varchar(25) NOT NULL DEFAULT '',
  `os` varchar(20) NOT NULL DEFAULT '',
  `domain` varchar(20) NOT NULL DEFAULT '',
  `ip` varchar(50) NOT NULL DEFAULT '',
  `user_agent` mediumtext NOT NULL,
  `language` varchar(20) NOT NULL DEFAULT '',
  `age` varchar(20) NOT NULL DEFAULT '',
  `gender` varchar(6) NOT NULL DEFAULT '',
  `browser` varchar(25) NOT NULL,
  `device_type` varchar(20) NOT NULL DEFAULT '',
  `device_make` varchar(20) NOT NULL DEFAULT '',
  `device_model` varchar(20) NOT NULL DEFAULT '',
  `page_url` varchar(75) NOT NULL DEFAULT '',
  `ref_url` varchar(50) NOT NULL DEFAULT '',
  `request_count` int(11) NOT NULL,
  `response_count` int(11) NOT NULL,
  `win_notice_count` int(11) NOT NULL,
  `test_win_notice_count` int(11) NOT NULL,
  `click_count` int(11) NOT NULL,
  `impression_count` int(11) NOT NULL,
  `currency` varchar(50) NOT NULL DEFAULT '',
  `total_amount` decimal(10,4) NOT NULL,
  `admin_share` decimal(10,4) NOT NULL,
  `date_time` datetime NOT NULL,
  `date_created` datetime NOT NULL,
  `conversion` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


ALTER TABLE `rv_affiliates` ADD `programatic_deal` INT NOT NULL AFTER `account_id`, ADD `open_market` INT NOT NULL AFTER `programatic_deal`, ADD `cpm` FLOAT(6,4) NOT NULL AFTER `open_market`, ADD `margin` INT NOT NULL AFTER `cpm`, ADD `is_seller_json` INT NOT NULL AFTER `margin`, ADD `is_confidential` INT NOT NULL AFTER `is_seller_json`, ADD `is_passthrough` INT NOT NULL AFTER `is_confidential`, ADD `seller_json_comments` VARCHAR(255) NOT NULL AFTER `is_passthrough`;


ALTER TABLE `rv_zones` ADD `app_select` INT NOT NULL AFTER `show_capped_no_cookie`, ADD `adformat_type` VARCHAR(50) NOT NULL AFTER `app_select`, ADD `inventory_type` INT(11) NOT NULL AFTER `adformat_type`, ADD `passbacktag` TEXT NOT NULL AFTER `inventory_type`, ADD `ssp_buyer` VARCHAR(255) NOT NULL AFTER `passbacktag`, ADD `vidtype` INT(11) NOT NULL AFTER `ssp_buyer`, ADD `reward` VARCHAR(255) NOT NULL AFTER `vidtype`, ADD `amount` VARCHAR(255) NOT NULL AFTER `reward`, ADD `position` VARCHAR(255) NOT NULL AFTER `amount`, ADD `layout` VARCHAR(255) NOT NULL AFTER `position`, ADD `infeedads` VARCHAR(255) NOT NULL AFTER `layout`, ADD `infeedpos` VARCHAR(255) NOT NULL AFTER `infeedads`, ADD `adposition` VARCHAR(255) NOT NULL AFTER `infeedpos`, ADD `adinterval` VARCHAR(255) NOT NULL AFTER `adposition`, ADD `inv_type` INT(11) NOT NULL AFTER `adinterval`, ADD `floor_price` FLOAT(10,4) NOT NULL AFTER `inv_type`;


-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 23, 2022 at 04:11 PM
-- Server version: 5.6.16-1~exp1
-- PHP Version: 7.2.34-28+0~20211119.67+debian9~1.gbpf24e81

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;


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

--
-- Table structure for table `rv_dealid`
--

CREATE TABLE `rv_dealid` (
  `dealid` int(11) NOT NULL,
  `agencyid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `dsp_type` mediumtext NOT NULL,
  `deal_at` int(11) NOT NULL DEFAULT '1',
  `dealid_token` varchar(255) NOT NULL DEFAULT '',
  `floor_price` decimal(10,2) NOT NULL,
  `start` date NOT NULL DEFAULT '1970-01-01',
  `end` date NOT NULL DEFAULT '1970-01-01',
  `is_pause` int(4) NOT NULL DEFAULT '0',
  `is_expire` int(4) NOT NULL DEFAULT '0',
  `is_delete` int(4) NOT NULL DEFAULT '0',
  `updated` datetime NOT NULL,
  `websites` mediumtext NOT NULL,
  `zones` mediumtext NOT NULL,
  `adsize` mediumtext NOT NULL,
  `deal_comments` varchar(100) NOT NULL DEFAULT '',
  `auction_type` int(11) NOT NULL,
  `created` varchar(50) NOT NULL DEFAULT '',
  `compiledlimitation` mediumtext NOT NULL,
  `acl_plugins` mediumtext NOT NULL,
  `block` varchar(50) NOT NULL DEFAULT '',
  `capping` varchar(50) NOT NULL DEFAULT '',
  `session_capping` varchar(255) NOT NULL DEFAULT '',
  `whitelisted_category` mediumtext NOT NULL,
  `blacklisted_category` mediumtext NOT NULL,
  `cus_width` varchar(10) NOT NULL DEFAULT '',
  `cus_height` varchar(10) NOT NULL DEFAULT '',
  `whitelist` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `rv_dealid`
--
ALTER TABLE `rv_dealid`
  ADD PRIMARY KEY (`dealid`);

--
-- AUTO_INCREMENT for dumped tables
--

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 23, 2022 at 03:45 PM
-- Server version: 5.6.16-1~exp1
-- PHP Version: 7.2.34-28+0~20211119.67+debian9~1.gbpf24e81

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;


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

--
-- Table structure for table `rv_exchange_zone_assoc`
--

CREATE TABLE `rv_exchange_zone_assoc` (
  `zoneid` int(11) NOT NULL,
  `req_test` int(11) NOT NULL,
  `req_tmax` int(11) NOT NULL,
  `req_wseat` varchar(200) NOT NULL DEFAULT '',
  `req_allimps` int(11) NOT NULL,
  `req_bcat` varchar(200) NOT NULL DEFAULT '',
  `req_badv` varchar(200) NOT NULL DEFAULT '',
  `req_bapp` varchar(200) NOT NULL DEFAULT '',
  `req_regs` varchar(200) NOT NULL DEFAULT '',
  `imp_dm` varchar(200) NOT NULL DEFAULT '',
  `imp_dms` varchar(200) NOT NULL DEFAULT '',
  `imp_tagid` varchar(200) NOT NULL DEFAULT '',
  `imp_bidfloor` decimal(10,2) NOT NULL,
  `imp_bidfloorcur` char(3) NOT NULL DEFAULT '',
  `imp_cb` int(11) DEFAULT NULL,
  `imp_secure` int(11) NOT NULL,
  `imp_iframe` varchar(200) NOT NULL DEFAULT '',
  `imp_exp` int(11) NOT NULL,
  `imp_pmp` varchar(200) NOT NULL DEFAULT '',
  `ban_btype` varchar(200) NOT NULL DEFAULT '',
  `ban_battr` varchar(200) NOT NULL DEFAULT '',
  `ban_mimes` varchar(200) NOT NULL DEFAULT '',
  `vid_width` int(10) NOT NULL,
  `vid_height` int(10) NOT NULL,
  `vid_playervideo` varchar(250) NOT NULL DEFAULT '',
  `vid_mimes` varchar(100) NOT NULL DEFAULT '',
  `vid_min` int(11) NOT NULL,
  `vid_max` int(11) NOT NULL,
  `vid_protocol` varchar(100) NOT NULL DEFAULT '',
  `vid_sd` int(11) NOT NULL,
  `vid_roll_sec` int(11) NOT NULL,
  `vid_lin` int(11) DEFAULT '1',
  `vid_skip` int(11) NOT NULL,
  `vid_skipmin` int(11) NOT NULL,
  `vid_skipafter` int(11) NOT NULL,
  `vid_seq` int(11) NOT NULL,
  `vid_battr` varchar(200) NOT NULL DEFAULT '',
  `vid_maxext` int(11) NOT NULL,
  `vid_minbit` int(11) NOT NULL,
  `vid_maxbit` int(11) NOT NULL,
  `vid_box` int(1) NOT NULL DEFAULT '1',
  `vid_play` varchar(200) NOT NULL DEFAULT '',
  `vid_del` int(11) NOT NULL,
  `vid_pos` int(11) NOT NULL,
  `vid_compad` varchar(200) NOT NULL DEFAULT '',
  `vid_api` varchar(200) NOT NULL DEFAULT '',
  `vid_comptype` varchar(200) NOT NULL DEFAULT '',
  `vid_comp_width` int(11) NOT NULL,
  `vid_comp_height` int(11) NOT NULL,
  `deal_bidfloor` decimal(10,4) NOT NULL,
  `deal_bidfloorcur` char(3) NOT NULL DEFAULT '',
  `deal_wseat` varchar(50) NOT NULL DEFAULT '',
  `deal_wadomain` varchar(100) NOT NULL DEFAULT '',
  `site_cat` varchar(200) NOT NULL DEFAULT '',
  `site_section` varchar(200) NOT NULL DEFAULT '',
  `site_page` varchar(200) NOT NULL DEFAULT '',
  `site_key` varchar(200) NOT NULL DEFAULT '',
  `site_content` varchar(200) NOT NULL DEFAULT '',
  `site_privacy` int(2) NOT NULL,
  `app_id` varchar(50) NOT NULL DEFAULT '',
  `app_name` varchar(100) NOT NULL DEFAULT '',
  `app_bundle` varchar(100) NOT NULL DEFAULT '',
  `app_url` varchar(200) NOT NULL DEFAULT '',
  `app_cat` varchar(200) NOT NULL DEFAULT '',
  `app_section` varchar(200) NOT NULL DEFAULT '',
  `app_page` varchar(200) NOT NULL DEFAULT '',
  `app_privacy` varchar(200) NOT NULL DEFAULT '',
  `app_ver` varchar(100) NOT NULL DEFAULT '',
  `app_paid` int(2) NOT NULL,
  `app_key` varchar(100) NOT NULL DEFAULT '',
  `pub_cat` varchar(200) NOT NULL DEFAULT '',
  `pub_domain` varchar(250) NOT NULL DEFAULT '',
  `cont_epi` int(100) NOT NULL,
  `cont_title` varchar(100) NOT NULL DEFAULT '',
  `cont_series` varchar(100) NOT NULL DEFAULT '',
  `cont_season` varchar(50) NOT NULL DEFAULT '',
  `cont_prod` varchar(100) NOT NULL DEFAULT '',
  `cont_cat` varchar(200) NOT NULL DEFAULT '',
  `cont_prodq` int(11) NOT NULL,
  `cont_vq` int(11) NOT NULL,
  `cont_context` int(11) NOT NULL,
  `cont_cr` varchar(100) NOT NULL DEFAULT '',
  `cont_ur` varchar(100) NOT NULL DEFAULT '',
  `cont_mr` int(100) NOT NULL,
  `cont_key` varchar(200) NOT NULL DEFAULT '',
  `cont_len` int(100) NOT NULL,
  `cont_lang` varchar(100) NOT NULL DEFAULT '',
  `cont_embed` int(2) NOT NULL,
  `cont_data` varchar(50) NOT NULL DEFAULT '',
  `prod_name` varchar(100) NOT NULL DEFAULT '',
  `prod_cat` varchar(100) NOT NULL DEFAULT '',
  `prod_domain` varchar(100) NOT NULL DEFAULT '',
  `dev_dnt` int(2) NOT NULL,
  `dev_lmt` int(2) NOT NULL,
  `geo_accuracy` int(11) NOT NULL,
  `geo_lf` int(11) NOT NULL,
  `user_bid` varchar(100) NOT NULL DEFAULT '',
  `user_yob` int(11) NOT NULL,
  `user_gender` varchar(50) NOT NULL DEFAULT '',
  `user_key` varchar(200) NOT NULL DEFAULT '',
  `user_cd` varchar(100) NOT NULL DEFAULT '',
  `user_data` varchar(100) NOT NULL DEFAULT '',
  `data_name` varchar(100) NOT NULL DEFAULT '',
  `data_seg` varchar(100) NOT NULL DEFAULT '',
  `seg_name` varchar(100) NOT NULL DEFAULT '',
  `seg_value` varchar(100) NOT NULL DEFAULT '',
  `format_w` int(11) NOT NULL,
  `format_h` int(11) NOT NULL,
  `nat_lay` int(11) NOT NULL,
  `nat_adunit` int(11) NOT NULL,
  `nat_len` int(11) NOT NULL,
  `nat_type` int(11) NOT NULL,
  `nat_width` int(11) NOT NULL,
  `nat_height` int(11) NOT NULL,
  `nat_img_mimes` varchar(100) NOT NULL DEFAULT '',
  `nat_vid_width` int(11) NOT NULL,
  `nat_vid_height` int(11) NOT NULL,
  `nat_vid_playervideo` varchar(100) NOT NULL DEFAULT '',
  `nat_vid_mimes` varchar(100) NOT NULL DEFAULT '',
  `nat_min` int(11) NOT NULL,
  `nat_max` int(11) NOT NULL,
  `nat_vid_protocol` varchar(50) NOT NULL DEFAULT '',
  `nat_datatype` int(11) NOT NULL,
  `nat_datalength` int(11) NOT NULL,
  `nat_lin` int(11) NOT NULL,
  `rtb_id` varchar(20) NOT NULL DEFAULT '',
  `nat_id` varchar(10) NOT NULL DEFAULT '',
  `nat_widheight` varchar(20) NOT NULL DEFAULT '',
  `aud_mimes` varchar(100) NOT NULL DEFAULT '',
  `aud_min` int(11) NOT NULL,
  `aud_max` int(11) NOT NULL,
  `aud_protocol` varchar(50) NOT NULL DEFAULT '',
  `aud_battr` varchar(50) NOT NULL DEFAULT '',
  `aud_maxext` int(11) NOT NULL,
  `aud_minbit` int(11) NOT NULL,
  `aud_maxbit` int(11) NOT NULL,
  `aud_del` varchar(50) NOT NULL DEFAULT '',
  `aud_comptype` varchar(50) NOT NULL DEFAULT '',
  `aud_maxseq` int(11) NOT NULL,
  `aud_feed` int(11) NOT NULL,
  `aud_nvol` int(11) NOT NULL,
  `aud_dl` int(11) NOT NULL,
  `pmp` int(11) NOT NULL,
  `deal_id` varchar(200) NOT NULL DEFAULT '',
  `below_img` varchar(255) NOT NULL DEFAULT '',
  `desk_height` varchar(255) NOT NULL DEFAULT '',
  `desk_width` varchar(255) NOT NULL DEFAULT '',
  `img_height` varchar(255) NOT NULL DEFAULT '',
  `img_width` varchar(255) NOT NULL DEFAULT '',
  `coppa` int(11) NOT NULL,
  `native_objects` mediumtext NOT NULL,
  `gdpr` int(11) NOT NULL,
  `ccpa` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `rv_exchange_zone_assoc`
--
ALTER TABLE `rv_exchange_zone_assoc`
  ADD PRIMARY KEY (`zoneid`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 23, 2022 at 03:27 PM
-- Server version: 5.6.16-1~exp1
-- PHP Version: 7.2.34-28+0~20211119.67+debian9~1.gbpf24e81

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;



-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 23, 2022 at 03:26 PM
-- Server version: 5.6.16-1~exp1
-- PHP Version: 7.2.34-28+0~20211119.67+debian9~1.gbpf24e81

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

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

--
-- Table structure for table `rv_dj_ad_exchange`
--

CREATE TABLE `rv_dj_ad_exchange` (
  `exchange_id` int(10) NOT NULL,
  `exchange_name` varchar(50) NOT NULL DEFAULT '',
  `added_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `open_rtb_version` int(2) NOT NULL,
  `status` int(2) NOT NULL,
  `ping_url` varchar(255) NOT NULL DEFAULT '',
  `auction_currency` int(15) NOT NULL,
  `auction_type` int(11) NOT NULL,
  `deal_limmit` int(11) NOT NULL,
  `prog_deal` int(10) NOT NULL,
  `open_market` int(10) NOT NULL,
  `both_val` int(10) NOT NULL,
  `gzip` int(11) NOT NULL,
  `digital_signature` varchar(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `rv_dj_ad_exchange`
--
ALTER TABLE `rv_dj_ad_exchange`
  ADD PRIMARY KEY (`exchange_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `rv_dj_ad_exchange`
--
ALTER TABLE `rv_dj_ad_exchange`
  MODIFY `exchange_id` int(10) NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;


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

--
-- Table structure for table `rv_dj_ssp_advanced_reports`
--

CREATE TABLE `rv_dj_ssp_advanced_reports` (
  `id` int(11) NOT NULL,
  `banner_type` int(15) NOT NULL,
  `zone_id` int(11) NOT NULL,
  `bidderid` int(11) NOT NULL,
  `pmp_deal` varchar(25) NOT NULL DEFAULT '',
  `country` varchar(25) NOT NULL DEFAULT '',
  `country_name` varchar(25) NOT NULL DEFAULT '',
  `os` varchar(20) NOT NULL DEFAULT '',
  `domain` varchar(20) NOT NULL DEFAULT '',
  `ip` varchar(50) NOT NULL DEFAULT '',
  `user_agent` mediumtext NOT NULL,
  `language` varchar(20) NOT NULL DEFAULT '',
  `age` varchar(20) NOT NULL DEFAULT '',
  `gender` varchar(6) NOT NULL DEFAULT '',
  `browser` varchar(25) NOT NULL,
  `device_type` varchar(20) NOT NULL DEFAULT '',
  `device_make` varchar(20) NOT NULL DEFAULT '',
  `device_model` varchar(20) NOT NULL DEFAULT '',
  `page_url` varchar(75) NOT NULL DEFAULT '',
  `ref_url` varchar(50) NOT NULL DEFAULT '',
  `request_count` int(11) NOT NULL,
  `response_count` int(11) NOT NULL,
  `win_notice_count` int(11) NOT NULL,
  `test_win_notice_count` int(11) NOT NULL,
  `click_count` int(11) NOT NULL,
  `impression_count` int(11) NOT NULL,
  `currency` varchar(50) NOT NULL DEFAULT '',
  `total_amount` decimal(10,4) NOT NULL,
  `admin_share` decimal(10,4) NOT NULL,
  `date_time` datetime NOT NULL,
  `date_created` datetime NOT NULL,
  `conversion` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


ALTER TABLE `rv_affiliates` ADD `programatic_deal` INT NOT NULL AFTER `account_id`, ADD `open_market` INT NOT NULL AFTER `programatic_deal`, ADD `cpm` FLOAT(6,4) NOT NULL AFTER `open_market`, ADD `margin` INT NOT NULL AFTER `cpm`, ADD `is_seller_json` INT NOT NULL AFTER `margin`, ADD `is_confidential` INT NOT NULL AFTER `is_seller_json`, ADD `is_passthrough` INT NOT NULL AFTER `is_confidential`, ADD `seller_json_comments` VARCHAR(255) NOT NULL AFTER `is_passthrough`;


ALTER TABLE `rv_zones` ADD `app_select` INT NOT NULL AFTER `show_capped_no_cookie`, ADD `adformat_type` VARCHAR(50) NOT NULL AFTER `app_select`, ADD `inventory_type` INT(11) NOT NULL AFTER `adformat_type`, ADD `passbacktag` TEXT NOT NULL AFTER `inventory_type`, ADD `ssp_buyer` VARCHAR(255) NOT NULL AFTER `passbacktag`, ADD `vidtype` INT(11) NOT NULL AFTER `ssp_buyer`, ADD `reward` VARCHAR(255) NOT NULL AFTER `vidtype`, ADD `amount` VARCHAR(255) NOT NULL AFTER `reward`, ADD `position` VARCHAR(255) NOT NULL AFTER `amount`, ADD `layout` VARCHAR(255) NOT NULL AFTER `position`, ADD `infeedads` VARCHAR(255) NOT NULL AFTER `layout`, ADD `infeedpos` VARCHAR(255) NOT NULL AFTER `infeedads`, ADD `adposition` VARCHAR(255) NOT NULL AFTER `infeedpos`, ADD `adinterval` VARCHAR(255) NOT NULL AFTER `adposition`, ADD `inv_type` INT(11) NOT NULL AFTER `adinterval`, ADD `floor_price` FLOAT(10,4) NOT NULL AFTER `inv_type`;
