-- phpMyAdmin SQL Dump
-- version 4.5.4.1deb2ubuntu2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 09, 2017 at 02:33 PM
-- Server version: 5.7.19-0ubuntu0.16.04.1-log
-- PHP Version: 7.0.22-0ubuntu0.16.04.1
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 */;
--
-- Database: `mctrades`
--
-- --------------------------------------------------------
--
-- Table structure for table `xf_resource`
--
CREATE TABLE `xf_resource` (
`resource_id` int(10) UNSIGNED NOT NULL,
`title` varchar(100) NOT NULL DEFAULT '',
`tag_line` varchar(100) NOT NULL DEFAULT '',
`user_id` int(10) UNSIGNED NOT NULL,
`username` varchar(100) NOT NULL DEFAULT '',
`resource_state` enum('visible','moderated','deleted') NOT NULL DEFAULT 'visible',
`resource_date` int(10) UNSIGNED NOT NULL,
`resource_category_id` int(11) NOT NULL,
`current_version_id` int(10) UNSIGNED NOT NULL,
`description_update_id` int(10) UNSIGNED NOT NULL COMMENT 'Points to the resource update that acts as the description for this resource',
`discussion_thread_id` int(10) UNSIGNED NOT NULL COMMENT 'Points to an automatically-created thread for this resource',
`external_url` varchar(500) NOT NULL DEFAULT '',
`is_fileless` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`external_purchase_url` varchar(500) NOT NULL DEFAULT '',
`price` decimal(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
`currency` varchar(3) NOT NULL DEFAULT '',
`download_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
`rating_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
`rating_sum` int(10) UNSIGNED NOT NULL DEFAULT '0',
`rating_avg` float UNSIGNED NOT NULL DEFAULT '0',
`rating_weighted` float UNSIGNED NOT NULL DEFAULT '0',
`update_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
`review_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
`last_update` int(10) UNSIGNED NOT NULL,
`alt_support_url` varchar(500) NOT NULL DEFAULT '',
`had_first_visible` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`custom_resource_fields` mediumblob NOT NULL,
`prefix_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
`icon_date` int(10) UNSIGNED NOT NULL DEFAULT '0',
`tags` mediumblob NOT NULL,
`custompg_paypal_email` varchar(500) DEFAULT NULL,
`custompg_validation` tinyint(4) NOT NULL DEFAULT '0',
`resource_cover_image` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`resource_cover_color` varchar(7) NOT NULL DEFAULT '0',
`resource_cover_date` int(10) UNSIGNED NOT NULL DEFAULT '0',
`resource_cover_width` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`resource_cover_height` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`resource_cover_crop_x` int(10) UNSIGNED NOT NULL DEFAULT '0',
`resource_cover_crop_y` int(10) UNSIGNED NOT NULL DEFAULT '0',
`resource_cover_state` enum('visible','moderated','deleted') DEFAULT 'visible',
`xfa_rmdonations_paypal` varchar(250) NOT NULL DEFAULT '',
`xfa_rmdonations_bitcoin` varchar(250) NOT NULL DEFAULT '',
`xfa_rmdonations_paypal_def` varchar(10) NOT NULL DEFAULT '',
`xfa_rmdonations_bitcoin_def` varchar(10) NOT NULL DEFAULT '',
`xfa_rmmp_type` enum('none','digital','physical','service') NOT NULL DEFAULT 'none',
`xfa_rmmp_amount` decimal(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
`xfa_rmmp_currency` varchar(3) NOT NULL DEFAULT '',
`xfa_rmmp_paypal` varchar(255) DEFAULT NULL,
`xfa_rmmp_accept_other` tinyint(1) NOT NULL DEFAULT '0',
`xfa_rmmp_purchases` int(10) UNSIGNED NOT NULL DEFAULT '0',
`xfa_rmmp_cgv` mediumtext NOT NULL,
`xfa_rmmp_img_date` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `xf_resource`
--
INSERT INTO `xf_resource` (`resource_id`, `title`, `tag_line`, `user_id`, `username`, `resource_state`, `resource_date`, `resource_category_id`, `current_version_id`, `description_update_id`, `discussion_thread_id`, `external_url`, `is_fileless`, `external_purchase_url`, `price`, `currency`, `download_count`, `rating_count`, `rating_sum`, `rating_avg`, `rating_weighted`, `update_count`, `review_count`, `last_update`, `alt_support_url`, `had_first_visible`, `custom_resource_fields`, `prefix_id`, `icon_date`, `tags`, `custompg_paypal_email`, `custompg_validation`, `resource_cover_image`, `resource_cover_color`, `resource_cover_date`, `resource_cover_width`, `resource_cover_height`, `resource_cover_crop_x`, `resource_cover_crop_y`, `resource_cover_state`, `xfa_rmdonations_paypal`, `xfa_rmdonations_bitcoin`, `xfa_rmdonations_paypal_def`, `xfa_rmdonations_bitcoin_def`, `xfa_rmmp_type`, `xfa_rmmp_amount`, `xfa_rmmp_currency`, `xfa_rmmp_paypal`, `xfa_rmmp_accept_other`, `xfa_rmmp_purchases`, `xfa_rmmp_cgv`, `xfa_rmmp_img_date`) VALUES
(90, 'Litebans HCF Messages ✔', 'Litebans HCF Messages', 1372, 'Jacob', 'visible', 1507000098, 5, 99, 100, 4777, '', 0, '', '1.00', 'usd', 3, 0, 0, 0, 3, 0, 0, 1507000098, '', 1, 0x613a313a7b733a32313a227265736f757263655f636f6e7472696275746f7273223b733a383a22466f6f7472657374223b7d, 0, 0, 0x613a303a7b7d, '', 0, 0, '0', 0, 0, 0, 0, 0, 'visible', 'admin@buildblox.net', 'admin@buildblox.net', '5', '0.1', 'digital', '1.00', 'USD', 'admin@buildblox.net', 0, 0, '', 0);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `xf_resource`
--
ALTER TABLE `xf_resource`
ADD PRIMARY KEY (`resource_id`),
ADD KEY `category_last_update` (`resource_category_id`,`last_update`),
ADD KEY `category_rating_weighted` (`resource_category_id`,`rating_weighted`),
ADD KEY `last_update` (`last_update`),
ADD KEY `rating_weighted` (`rating_weighted`),
ADD KEY `user_id_last_update` (`user_id`,`last_update`),
ADD KEY `discussion_thread_id` (`discussion_thread_id`),
ADD KEY `prefix_id` (`prefix_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `xf_resource`
--
ALTER TABLE `xf_resource`
MODIFY `resource_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=98;
/*!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 */;