jarvis/componentowl-rails-archive
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
componentowl-rails-archive/db-backups/20101208001125-componentowl-struct.sql

955 lines
36 KiB
MySQL
Raw Permalink Normal View History

Archive: ComponentOwl Rails app, DB backups, go redirect script
2026-03-23 16:20:05 +00:00
-- MySQL dump 10.11
--
-- Host: mysql.dextronet.com Database: componentowl
-- ------------------------------------------------------
-- Server version 5.1.39-log
/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `activations`
--
DROP TABLE IF EXISTS `activations`;
CREATE TABLE `activations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL,
`build` int(11) NOT NULL,
`computer_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`product` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `order_id` (`order_id`),
CONSTRAINT `activations_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `allowed_values`
--
DROP TABLE IF EXISTS `allowed_values`;
CREATE TABLE `allowed_values` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1024399114 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `articles`
--
DROP TABLE IF EXISTS `articles`;
CREATE TABLE `articles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`content` text COLLATE utf8_unicode_ci NOT NULL,
`date` date NOT NULL,
`status` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'draft',
`keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`custom_subtemplate` text COLLATE utf8_unicode_ci,
`screenshot_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_articles_on_slug` (`slug`),
KEY `screenshot_id` (`screenshot_id`),
CONSTRAINT `articles_ibfk_1` FOREIGN KEY (`screenshot_id`) REFERENCES `screenshots` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `autoresponders`
--
DROP TABLE IF EXISTS `autoresponders`;
CREATE TABLE `autoresponders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subscription_list_id` int(11) NOT NULL,
`subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`message` text COLLATE utf8_unicode_ci NOT NULL,
`delay` int(11) DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `subscription_list_id` (`subscription_list_id`),
CONSTRAINT `autoresponders_ibfk_1` FOREIGN KEY (`subscription_list_id`) REFERENCES `subscription_lists` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `contacts`
--
DROP TABLE IF EXISTS `contacts`;
CREATE TABLE `contacts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`active_subscriptions` int(11) DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=846119421 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `customers`
--
DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`company` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`customer_attributes` text COLLATE utf8_unicode_ci,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `customers_visitors`
--
DROP TABLE IF EXISTS `customers_visitors`;
CREATE TABLE `customers_visitors` (
`customer_id` int(11) DEFAULT NULL,
`visitor_id` int(11) DEFAULT NULL,
KEY `customer_id` (`customer_id`),
KEY `visitor_id` (`visitor_id`),
CONSTRAINT `customers_visitors_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
CONSTRAINT `customers_visitors_ibfk_2` FOREIGN KEY (`visitor_id`) REFERENCES `visitors` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `download_logs`
--
DROP TABLE IF EXISTS `download_logs`;
CREATE TABLE `download_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) DEFAULT NULL,
`request` text COLLATE utf8_unicode_ci,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`),
CONSTRAINT `download_logs_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `emails`
--
DROP TABLE IF EXISTS `emails`;
CREATE TABLE `emails` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`from` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`to` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_send_attempt` int(11) DEFAULT '0',
`mail` text COLLATE utf8_unicode_ci,
`created_on` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `faq_categories`
--
DROP TABLE IF EXISTS `faq_categories`;
CREATE TABLE `faq_categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) DEFAULT NULL,
`url_param` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`),
CONSTRAINT `faq_categories_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `faqs`
--
DROP TABLE IF EXISTS `faqs`;
CREATE TABLE `faqs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`faq_category_id` int(11) DEFAULT NULL,
`url_param` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`question` text COLLATE utf8_unicode_ci,
`answer` text COLLATE utf8_unicode_ci,
`featured` tinyint(1) DEFAULT '0',
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `faq_category_id` (`faq_category_id`),
CONSTRAINT `faqs_ibfk_1` FOREIGN KEY (`faq_category_id`) REFERENCES `faq_categories` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `latests`
--
DROP TABLE IF EXISTS `latests`;
CREATE TABLE `latests` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`body` text COLLATE utf8_unicode_ci,
`date` date DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `meta_tags`
--
DROP TABLE IF EXISTS `meta_tags`;
CREATE TABLE `meta_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`keywords` text COLLATE utf8_unicode_ci,
`description` text COLLATE utf8_unicode_ci,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=364435844 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `newsletter_allowed_values`
--
DROP TABLE IF EXISTS `newsletter_allowed_values`;
CREATE TABLE `newsletter_allowed_values` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1026203351 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `orders`
--
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`customer_id` int(11) DEFAULT NULL,
`orderable_id` int(11) DEFAULT NULL,
`orderable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`license_key` text COLLATE utf8_unicode_ci,
`order_attributes` text COLLATE utf8_unicode_ci,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `customer_id` (`customer_id`),
CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `pad_values`
--
DROP TABLE IF EXISTS `pad_values`;
CREATE TABLE `pad_values` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) DEFAULT NULL,
`key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`value` text COLLATE utf8_unicode_ci,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`),
CONSTRAINT `pad_values_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `page_includes`
--
DROP TABLE IF EXISTS `page_includes`;
CREATE TABLE `page_includes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`inklude` text COLLATE utf8_unicode_ci,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `product_categories`
--
DROP TABLE IF EXISTS `product_categories`;
CREATE TABLE `product_categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_product_categories_on_code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=207704555 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `product_descriptions`
--
DROP TABLE IF EXISTS `product_descriptions`;
CREATE TABLE `product_descriptions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_description_type_id` int(11) DEFAULT NULL,
`product_id` int(11) DEFAULT NULL,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`value` text COLLATE utf8_unicode_ci,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `product_description_type_id` (`product_description_type_id`),
KEY `product_id` (`product_id`),
CONSTRAINT `product_descriptions_ibfk_1` FOREIGN KEY (`product_description_type_id`) REFERENCES `allowed_values` (`id`),
CONSTRAINT `product_descriptions_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=534832557 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `product_discounts`
--
DROP TABLE IF EXISTS `product_discounts`;
CREATE TABLE `product_discounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) DEFAULT NULL,
`product_edition_id` int(11) DEFAULT NULL,
`discount_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`discount_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`price` decimal(10,2) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`),
KEY `product_edition_id` (`product_edition_id`),
CONSTRAINT `product_discounts_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
CONSTRAINT `product_discounts_ibfk_2` FOREIGN KEY (`product_edition_id`) REFERENCES `product_editions` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `product_editions`
--
DROP TABLE IF EXISTS `product_editions`;
CREATE TABLE `product_editions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) DEFAULT NULL,
`code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`internal_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`bmtID` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8_unicode_ci,
`price` decimal(10,2) DEFAULT NULL,
`regular_price` decimal(10,2) DEFAULT NULL,
`initial` tinyint(1) DEFAULT '0',
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_product_editions_on_internal_code` (`internal_code`),
KEY `product_id` (`product_id`),
CONSTRAINT `product_editions_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `product_icons`
--
DROP TABLE IF EXISTS `product_icons`;
CREATE TABLE `product_icons` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) DEFAULT NULL,
`icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`size` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`icon_file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`icon_content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`icon_file_size` int(11) DEFAULT NULL,
`icon_updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`),
CONSTRAINT `product_icons_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `product_images`
--
DROP TABLE IF EXISTS `product_images`;
CREATE TABLE `product_images` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) DEFAULT NULL,
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`alt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`image_file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`image_content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`image_file_size` int(11) DEFAULT NULL,
`image_updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`),
CONSTRAINT `product_images_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `product_offers`
--
DROP TABLE IF EXISTS `product_offers`;
CREATE TABLE `product_offers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) DEFAULT NULL,
`related_product_id` int(11) DEFAULT NULL,
`bmtID` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8_unicode_ci,
`price` decimal(10,2) DEFAULT NULL,
`begins_at` datetime DEFAULT NULL,
`expires_at` datetime DEFAULT NULL,
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`internal_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`),
KEY `related_product_id` (`related_product_id`),
CONSTRAINT `product_offers_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
CONSTRAINT `product_offers_ibfk_2` FOREIGN KEY (`related_product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `product_pages`
--
DROP TABLE IF EXISTS `product_pages`;
CREATE TABLE `product_pages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) DEFAULT NULL,
`product_id` int(11) DEFAULT NULL,
`tab` tinyint(1) DEFAULT '0',
`code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`html` text COLLATE utf8_unicode_ci,
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`),
KEY `product_id` (`product_id`),
CONSTRAINT `product_pages_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `product_pages` (`id`),
CONSTRAINT `product_pages_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `product_upgrades`
--
DROP TABLE IF EXISTS `product_upgrades`;
CREATE TABLE `product_upgrades` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`upgrade_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`bmtID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`price` decimal(10,2) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`upgradable_id` int(11) DEFAULT NULL,
`upgradable_to_id` int(11) DEFAULT NULL,
`upgradable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'ProductEdition',
`upgradable_to_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `product_url_params`
--
DROP TABLE IF EXISTS `product_url_params`;
CREATE TABLE `product_url_params` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) DEFAULT NULL,
`url_destination_id` int(11) DEFAULT NULL,
`url_param` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`default` tinyint(1) DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`),
KEY `url_destination_id` (`url_destination_id`),
CONSTRAINT `product_url_params_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
CONSTRAINT `product_url_params_ibfk_2` FOREIGN KEY (`url_destination_id`) REFERENCES `allowed_values` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `products`
--
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_category_id` int(11) DEFAULT NULL,
`code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`internal_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`promoted` tinyint(1) DEFAULT '0',
`homepage` tinyint(1) DEFAULT '0',
`price` decimal(10,2) DEFAULT NULL,
`regular_price` decimal(10,2) DEFAULT NULL,
`bmtID` int(11) DEFAULT NULL,
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
`setup_file_file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`setup_file_content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`setup_file_file_size` int(11) DEFAULT NULL,
`setup_file_updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_products_on_code` (`code`),
UNIQUE KEY `index_products_on_internal_code` (`internal_code`),
KEY `product_category_id` (`product_category_id`),
CONSTRAINT `products_ibfk_1` FOREIGN KEY (`product_category_id`) REFERENCES `product_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=605250274 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `products_promotions`
--
DROP TABLE IF EXISTS `products_promotions`;
CREATE TABLE `products_promotions` (
`product_id` int(11) DEFAULT NULL,
`promotion_id` int(11) DEFAULT NULL,
KEY `product_id` (`product_id`),
KEY `promotion_id` (`promotion_id`),
CONSTRAINT `products_promotions_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
CONSTRAINT `products_promotions_ibfk_2` FOREIGN KEY (`promotion_id`) REFERENCES `allowed_values` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `redirects`
--
DROP TABLE IF EXISTS `redirects`;
CREATE TABLE `redirects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`source_type_id` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`redirect_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`redirect_to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `source_type_id` (`source_type_id`),
CONSTRAINT `redirects_ibfk_1` FOREIGN KEY (`source_type_id`) REFERENCES `allowed_values` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `releases`
--
DROP TABLE IF EXISTS `releases`;
CREATE TABLE `releases` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) DEFAULT NULL,
`version` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`build` int(11) DEFAULT NULL,
`description` text COLLATE utf8_unicode_ci,
`changelog` text COLLATE utf8_unicode_ci,
`date` date DEFAULT NULL,
`postpone_till` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`announce` tinyint(1) DEFAULT '1',
`exclude_from_autoupdate` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`),
CONSTRAINT `releases_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=222479602 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `schema_migrations`
--
DROP TABLE IF EXISTS `schema_migrations`;
CREATE TABLE `schema_migrations` (
`version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
UNIQUE KEY `unique_schema_migrations` (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `screenshots`
--
DROP TABLE IF EXISTS `screenshots`;
CREATE TABLE `screenshots` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) DEFAULT NULL,
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`alt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`image_file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`image_content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`image_file_size` int(11) DEFAULT NULL,
`image_updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`),
CONSTRAINT `screenshots_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `sent_autoresponders`
--
DROP TABLE IF EXISTS `sent_autoresponders`;
CREATE TABLE `sent_autoresponders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`autoresponder_id` int(11) NOT NULL,
`contact_id` int(11) NOT NULL,
`sent_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `autoresponder_id` (`autoresponder_id`),
KEY `contact_id` (`contact_id`),
CONSTRAINT `sent_autoresponders_ibfk_1` FOREIGN KEY (`autoresponder_id`) REFERENCES `autoresponders` (`id`),
CONSTRAINT `sent_autoresponders_ibfk_2` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `site_settings`
--
DROP TABLE IF EXISTS `site_settings`;
CREATE TABLE `site_settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`settings` text COLLATE utf8_unicode_ci,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `sitemap_titles`
--
DROP TABLE IF EXISTS `sitemap_titles`;
CREATE TABLE `sitemap_titles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `static_pages`
--
DROP TABLE IF EXISTS `static_pages`;
CREATE TABLE `static_pages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`url_param` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`html` text COLLATE utf8_unicode_ci,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_static_pages_on_code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `subscription_list_types_subscription_locations`
--
DROP TABLE IF EXISTS `subscription_list_types_subscription_locations`;
CREATE TABLE `subscription_list_types_subscription_locations` (
`subscription_list_type_id` int(11) DEFAULT NULL,
`subscription_location_id` int(11) DEFAULT NULL,
KEY `subscription_list_type_id` (`subscription_list_type_id`),
KEY `subscription_location_id` (`subscription_location_id`),
CONSTRAINT `subscription_list_types_subscription_locations_ibfk_1` FOREIGN KEY (`subscription_list_type_id`) REFERENCES `newsletter_allowed_values` (`id`),
CONSTRAINT `subscription_list_types_subscription_locations_ibfk_2` FOREIGN KEY (`subscription_location_id`) REFERENCES `newsletter_allowed_values` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `subscription_lists`
--
DROP TABLE IF EXISTS `subscription_lists`;
CREATE TABLE `subscription_lists` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subscription_list_type_id` int(11) DEFAULT NULL,
`product_id` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `subscription_list_type_id` (`subscription_list_type_id`),
KEY `product_id` (`product_id`),
CONSTRAINT `subscription_lists_ibfk_1` FOREIGN KEY (`subscription_list_type_id`) REFERENCES `newsletter_allowed_values` (`id`),
CONSTRAINT `subscription_lists_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1009842130 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `subscriptions`
--
DROP TABLE IF EXISTS `subscriptions`;
CREATE TABLE `subscriptions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subscription_list_id` int(11) DEFAULT NULL,
`contact_id` int(11) DEFAULT NULL,
`started_at` datetime DEFAULT NULL,
`ended_at` datetime DEFAULT NULL,
`active` tinyint(1) DEFAULT '1',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
`subscription_location_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `subscription_list_id` (`subscription_list_id`),
KEY `contact_id` (`contact_id`),
KEY `subscription_location_id` (`subscription_location_id`),
CONSTRAINT `subscriptions_ibfk_1` FOREIGN KEY (`subscription_list_id`) REFERENCES `subscription_lists` (`id`),
CONSTRAINT `subscriptions_ibfk_2` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`),
CONSTRAINT `subscriptions_ibfk_3` FOREIGN KEY (`subscription_location_id`) REFERENCES `newsletter_allowed_values` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1041002158 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `subtemplates`
--
DROP TABLE IF EXISTS `subtemplates`;
CREATE TABLE `subtemplates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subtemplate_type_id` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`content` text COLLATE utf8_unicode_ci,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `subtemplate_type_id` (`subtemplate_type_id`),
CONSTRAINT `subtemplates_ibfk_1` FOREIGN KEY (`subtemplate_type_id`) REFERENCES `allowed_values` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `support_requests`
--
DROP TABLE IF EXISTS `support_requests`;
CREATE TABLE `support_requests` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`support_request_origin_id` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`product_id` int(11) DEFAULT NULL,
`subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`message` text COLLATE utf8_unicode_ci,
`mail_sent` tinyint(1) DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `support_request_origin_id` (`support_request_origin_id`),
KEY `product_id` (`product_id`),
CONSTRAINT `support_requests_ibfk_1` FOREIGN KEY (`support_request_origin_id`) REFERENCES `allowed_values` (`id`),
CONSTRAINT `support_requests_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `testimonial_positions`
--
DROP TABLE IF EXISTS `testimonial_positions`;
CREATE TABLE `testimonial_positions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`testimonial_id` int(11) DEFAULT NULL,
`testimonial_location_id` int(11) DEFAULT NULL,
`product_id` int(11) DEFAULT NULL,
`extract` text COLLATE utf8_unicode_ci,
`position` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `testimonial_id` (`testimonial_id`),
KEY `testimonial_location_id` (`testimonial_location_id`),
KEY `product_id` (`product_id`),
CONSTRAINT `testimonial_positions_ibfk_1` FOREIGN KEY (`testimonial_id`) REFERENCES `testimonials` (`id`),
CONSTRAINT `testimonial_positions_ibfk_2` FOREIGN KEY (`testimonial_location_id`) REFERENCES `allowed_values` (`id`),
CONSTRAINT `testimonial_positions_ibfk_3` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `testimonials`
--
DROP TABLE IF EXISTS `testimonials`;
CREATE TABLE `testimonials` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) DEFAULT NULL,
`text` text COLLATE utf8_unicode_ci,
`author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`hidden` tinyint(1) DEFAULT '0',
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`),
CONSTRAINT `testimonials_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`login` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`crypted_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`password_salt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`persistence_token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`single_access_token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`perishable_token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`login_count` int(11) NOT NULL DEFAULT '0',
`failed_login_count` int(11) NOT NULL DEFAULT '0',
`last_request_at` datetime DEFAULT NULL,
`current_login_at` datetime DEFAULT NULL,
`last_login_at` datetime DEFAULT NULL,
`current_login_ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_login_ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=679720380 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `visitor_tracks`
--
DROP TABLE IF EXISTS `visitor_tracks`;
CREATE TABLE `visitor_tracks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`visitor_id` int(11) DEFAULT NULL,
`track` text COLLATE utf8_unicode_ci,
`trackable_id` int(11) DEFAULT NULL,
`trackable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`source_type_id` int(11) DEFAULT NULL,
`source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`targetable` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`download` tinyint(1) DEFAULT '0',
`checkout` tinyint(1) DEFAULT '0',
`order` tinyint(1) DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `visitor_id` (`visitor_id`),
KEY `source_type_id` (`source_type_id`),
CONSTRAINT `visitor_tracks_ibfk_1` FOREIGN KEY (`visitor_id`) REFERENCES `visitors` (`id`),
CONSTRAINT `visitor_tracks_ibfk_2` FOREIGN KEY (`source_type_id`) REFERENCES `allowed_values` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `visitors`
--
DROP TABLE IF EXISTS `visitors`;
CREATE TABLE `visitors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`trackable_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`user_agent` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `volume_discounts`
--
DROP TABLE IF EXISTS `volume_discounts`;
CREATE TABLE `volume_discounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`from` int(11) DEFAULT NULL,
`to` int(11) DEFAULT NULL,
`discount` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2010-12-08 8:11:29
Reference in New Issue Copy Permalink