通知设置 新通知
magento后台邮件订单，邮件不能发送
neasel 回复了问题 • 2 人关注 • 1 个回复 • 5 次浏览 • 2018-10-28 03:23
MAGENTO1.X导入扩展出现后台访问直接跳转到前台404的解决方法
neasel 发表了文章 • 0 个评论 • 17 次浏览 • 2018-06-14 19:10
1.确认文件是否正确完整地上传到空间上
2.app\code\community\CapacityWebSolutions\ImportProduct\Model下的Profile.php文件有的空间会自动删除
您可以手动创建此名称的文 ...查看全部
1.确认文件是否正确完整地上传到空间上
2.app\code\community\CapacityWebSolutions\ImportProduct\Model下的Profile.php文件有的空间会自动删除
您可以手动创建此名称的文件，并填入以下内容
2.app\code\community\CapacityWebSolutions\ImportProduct\Model下的Profile.php文件有的空间会自动删除
您可以手动创建此名称的文件，并填入以下内容
<?php
class CapacityWebSolutions_ImportProduct_Model_Profile extends Mage_Core_Model_Abstract
{
}
opencart 2.3.0.2中使用domino模板时newsletter无响应的问题及修复
neasel 发表了文章 • 0 个评论 • 22 次浏览 • 2017-05-02 22:29
此补丁包此是修复此模板中的NEWSLETTER问题，及NEWSLETTERPOP
修改位于catalog/controller/extension/module/newslettersubscribe.php<?php
cla ...查看全部
此补丁包此是修复此模板中的NEWSLETTER问题，及NEWSLETTERPOP
修改位于catalog/controller/extension/module/newslettersubscribe.php
修改位于catalog/controller/extension/module/newslettersubscribe.php
<?php修改文件 catalog/view/theme/您所使用的模板/template/extension/module/newsletterpopup/newsletterpopup.tpl
class ControllerExtensionModuleNewslettersubscribe extends Controller {
private $error = array();
public function index($setting) {
$this->language->load('extension/module/newslettersubscribe');
$this->document->addScript('catalog/view/javascript/opentheme/jquery.bpopup.min.js');
$this->document->addScript('catalog/view/javascript/opentheme/jquery.cookie.js');
$data['heading_title'] = $this->language->get('heading_title');
$data['newletter_lable'] = $this->language->get('newletter_lable');
$data['sub_newletter'] = $this->language->get('sub_newletter');
$data['entry_name'] = $this->language->get('entry_name');
$data['entry_email'] = $this->language->get('entry_email');
$data['entry_button'] = $this->language->get('entry_button');
$data['entry_unbutton'] = $this->language->get('entry_unbutton');
$data['option_unsubscribe'] = $this->config->get('option_unsubscribe');
$data['thickbox'] = $setting['newslettersubscribe_thickbox'];
$data['entry_show_again'] = $this->language->get('entry_show_again');
$data['text_subscribe'] = $this->language->get('text_subscribe');
$this->id = 'newslettersubscribe';
if(isset($setting['popup']) && $setting['popup']==1) {
return $this->load->view('extension/module/newsletterpopup', $data);
}else {
return $this->load->view('extension/module/newslettersubscribe', $data);
}
$this->load->model('account/newslettersubscribe');
//check db
$this->model_account_newslettersubscribe->check_db();
}
public function subscribe() {
$prefix_eval = "";
$this->language->load('extension/module/newslettersubscribe');
$this->load->model('account/newslettersubscribe');
if (isset($this->request->post['subscribe_email']) and filter_var($this->request->post['subscribe_email'],FILTER_VALIDATE_EMAIL)) {
$this->request->post['subscribe_email'] = $this->request->post['subscribe_email'];
$this->request->post['subscribe_name'] = $this->request->post['subscribe_name'];
if ($this->config->get('newslettersubscribe_registered') and $this->model_account_newslettersubscribe->checkRegisteredUser($this->request->post)) {
$this->model_account_newslettersubscribe->UpdateRegisterUsers($this->request->post,1);
echo('$("'.$prefix_eval.' #notification_normal").html("<div class=\"success\"> '.$this->language->get('subscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');
} else if (!$this->model_account_newslettersubscribe->checkmailid($this->request->post)) {
$this->model_account_newslettersubscribe->subscribe($this->request->post);
echo('$("'.$prefix_eval.' #notification_normal").html("<div class=\"success\"> '.$this->language->get('subscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');
if ($this->config->get('newslettersubscribe_mail_status')) {
$subject = $this->language->get('mail_subject');
$message = '<table width="60%" cellpadding="2" cellspacing="1" border="0">
<tr>
<td> Email Id </td>
<td> '.$this->request->post['subscribe_email'].' </td>
</tr>
<tr>
<td> Name </td>
<td> '.$this->request->post['subscribe_name'].' </td>
</tr>';
$message .= '</table>';
$mail = new Mail();
$mail->protocol = $this->config->get('config_mail_protocol');
$mail->parameter = $this->config->get('config_mail_parameter');
$mail->hostname = $this->config->get('config_smtp_host');
$mail->username = $this->config->get('config_smtp_username');
$mail->password = $this->config->get('config_smtp_password');
$mail->port = $this->config->get('config_smtp_port');
$mail->timeout = $this->config->get('config_smtp_timeout');
$mail->setTo($this->config->get('config_email'));
$mail->setFrom($this->config->get('config_email'));
$mail->setSender($this->config->get('config_name'));
$mail->setSubject($subject);
$mail->setHtml($message);
$mail->send();
}
} else {
echo('$("'.$prefix_eval.' #notification_normal").html("<div class=\"warning\"> '.$this->language->get('alreadyexist').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');
}
} else {
echo('$("'.$prefix_eval.' #notification_normal").html("<div class=\"warning\"> '.$this->language->get('error_invalid').'</div>")');
}
}
public function subscribepopup() {
$prefix_eval = "";
$this->language->load('extension/module/newslettersubscribe');
$this->load->model('account/newslettersubscribe');
if (isset($this->request->post['subscribe_pemail']) and filter_var($this->request->post['subscribe_pemail'],FILTER_VALIDATE_EMAIL)) {
$this->request->post['subscribe_email'] = $this->request->post['subscribe_pemail'];
$this->request->post['subscribe_name'] = $this->request->post['subscribe_pname'];
if ($this->config->get('newslettersubscribe_registered') and $this->model_account_newslettersubscribe->checkRegisteredUser($this->request->post)) {
$this->model_account_newslettersubscribe->UpdateRegisterUsers($this->request->post,1);
echo('$("'.$prefix_eval.' #notification").html("<div class=\"success\"> '.$this->language->get('subscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');
} else if (!$this->model_account_newslettersubscribe->checkmailid($this->request->post)) {
$this->model_account_newslettersubscribe->subscribe($this->request->post);
echo('$("'.$prefix_eval.' #notification").html("<div class=\"success\"> '.$this->language->get('subscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');
if ($this->config->get('newslettersubscribe_mail_status')) {
$subject = $this->language->get('mail_subject');
$message = '<table width="60%" cellpadding="2" cellspacing="1" border="0">
<tr>
<td> Email Id </td>
<td> '.$this->request->post['subscribe_pemail'].' </td>
</tr>
<tr>
<td> Name </td>
<td> '.$this->request->post['subscribe_pname'].' </td>
</tr>';
$message .= '</table>';
$mail = new Mail();
$mail->protocol = $this->config->get('config_mail_protocol');
$mail->parameter = $this->config->get('config_mail_parameter');
$mail->hostname = $this->config->get('config_smtp_host');
$mail->username = $this->config->get('config_smtp_username');
$mail->password = $this->config->get('config_smtp_password');
$mail->port = $this->config->get('config_smtp_port');
$mail->timeout = $this->config->get('config_smtp_timeout');
$mail->setTo($this->config->get('config_email'));
$mail->setFrom($this->config->get('config_email'));
$mail->setSender($this->config->get('config_name'));
$mail->setSubject($subject);
$mail->setHtml($message);
$mail->send();
}
} else {
echo('$("'.$prefix_eval.' #notification").html("<div class=\"warning\"> '.$this->language->get('alreadyexist').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');
}
} else {
echo('$("'.$prefix_eval.' #notification").html("<div class=\"warning\"> '.$this->language->get('error_invalid').'</div>")');
}
}
public function unsubscribe(){
if ($this->config->get('newslettersubscribe_thickbox')) {
$prefix_eval = "";
} else {
$prefix_eval = "";
}
$this->language->load('extension/module/newslettersubscribe');
$this->load->model('account/newslettersubscribe');
if (isset($this->request->post['subscribe_email']) and filter_var($this->request->post['subscribe_email'],FILTER_VALIDATE_EMAIL)) {
if ($this->config->get('newslettersubscribe_registered') and $this->model_account_newslettersubscribe->checkRegisteredUser($this->request->post)) {
$this->model_account_newslettersubscribe->UpdateRegisterUsers($this->request->post,0);
echo('$("'.$prefix_eval.' #notification").html("<div class=\"success\"> '.$this->language->get('unsubscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');
} else if (!$this->model_account_newslettersubscribe->checkmailid($this->request->post)) {
echo('$("'.$prefix_eval.' #notification").html("<div class=\"warning\"> '.$this->language->get('notexist').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');
} else {
if ($this->config->get('option_unsubscribe')) {
$this->model_account_newslettersubscribe->unsubscribe($this->request->post);
echo('$("'.$prefix_eval.' #notification").html("<div class=\"success\"> '.$this->language->get('unsubscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');
}
}
} else {
echo('$("'.$prefix_eval.' #notification").html("<div class=\"warning\"> '.$this->language->get('error_invalid').'</div>")');
}
}
protected function loadmodule() {
$this->language->load('extension/module/newslettersubscribe');
$data['heading_title'] = $this->language->get('heading_title');
$data['entry_name'] = $this->language->get('entry_name');
$data['entry_email'] = $this->language->get('entry_email');
$data['entry_button'] = $this->language->get('entry_button');
$data['entry_unbutton'] = $this->language->get('entry_unbutton');
$data['option_unsubscribe'] = $this->config->get('option_unsubscribe');
$data['thickbox'] = $this->config->get('newslettersubscribe_thickbox');
$data['text_subscribe'] = $this->language->get('text_subscribe');
$this->id = 'newslettersubscribe';
return $this->load->view('extension/module/newslettersubscribe.tpl', $data);
}
}
?>
<div class="newletter-container">修改文件 catalog/view/theme/您所使用的模板/template/extension/module/newsletterpopup/newslettersubscribe.tpl
<div id="boxes" class="newletter-container newsletter-popup">
<div style="" id="dialog" class="window ">
<div class="box ">
<!-- <div class="png-popup1" style="height:auto;width: 100%;">
<img src="image/catalog/demo/newsletter-1.jpg" alt="#">
</div> -->
<div id="popup2" class="btn-close-form">
<span class="button b-close"><span>X</span></span>
<div class="content"></div>
</div>
<div class="newletter-title"><h2><?php echo $heading_title; ?></h2></div>
<div class="box-content newleter-content">
<label><?php echo $newletter_lable; ?></label>
<div id="frm_subscribes">
<form name="subscribe" id="subscribe_popup">
<div>
<!-- <span class="required">*</span><span><?php //echo $entry_email; ?></span> -->
<input type="text" value="" name="subscribe_pemail" id="subscribe_pemail">
<input type="hidden" value="" name="subscribe_pname" id="subscribe_pname" />
</div>
<div class="subs-links text-center">
<a class="button" onclick="email_subscribepopup()"><span><?php echo $entry_button; ?></span></a>
</div>
<?php if($option_unsubscribe) { ?>
<a class="button" onclick="email_unsubscribepopup()"><span><?php echo $entry_unbutton; ?></span></a>
<?php } ?>
</form>
<div class="subscribe-bottom">
<input type="checkbox" id="newsletter_popup_dont_show_again">
<label for="newsletter_popup_dont_show_again"><?php echo $entry_show_again; ?></label>
</div>
</div><!-- /#frm_subscribe -->
<div id="notification"></div>
</div><!-- /.box-content -->
<!-- <div class="png-popup2" style="height:120px;width: 150px;">
<img src="image/catalog/demo/newletter_item.png" alt="#">
</div> -->
</div>
</div>
<script type="text/javascript">
function email_subscribepopup(){
$.ajax({
type: 'post',
url: 'index.php?route=extension/module/newslettersubscribe/subscribepopup',
dataType: 'html',
data:$("#subscribe_popup").serialize(),
success: function (html) {
$.cookie('shownewsletter', '1');
eval(html);
}});
}
function email_unsubscribepopup(){
$.ajax({
type: 'post',
url: 'index.php?route=extension/module/newslettersubscribe/unsubscribe',
dataType: 'html',
data:$("#subscribe_popup").serialize(),
success: function (html) {
eval(html);
}});
$('html, body').delay( 1500 ).animate({ scrollTop: 0 }, 'slow');
}
</script>
<script type="text/javascript">
$(document).ready(function() {
if($.cookie('shownewsletter')==1) $('#boxes').hide();
$('#subscribe_pemail').keypress(function(e) {
if(e.which == 13) {
e.preventDefault();
email_subscribepopup();
}
var name= $(this).val();
$('#subscribe_pname').val(name);
});
$('#subscribe_pemail').change(function() {
var name= $(this).val();
$('#subscribe_pname').val(name);
});
//transition effect
if($.cookie("shownewsletter") != 1){
$('#boxes').bPopup();
}
//if close button is clicked
$('.b-modal').click(function (e) {
$.cookie('shownewsletter', '1');
});
$('#newsletter_popup_dont_show_again').on('change', function(){
if($.cookie("shownewsletter") != 1){
$.cookie("shownewsletter",'1')
}else{
$.cookie("shownewsletter",'0')
}
});
});
</script>
</div><!-- /.box -->
</div>
<div class="newletter-subscribe">
<div class="containers">
<div id="box" class="newletter-container">
<div style="" id="dialog_nomal" class="window">
<div class="box">
<div class="newletter-title">
<h2><?php echo $newletter_lable; ?></h2>
<!-- <span class="sub-newletter"><?php echo $sub_newletter; ?></span> -->
</div>
<div class="box-content newleter-content">
<label class="hidden"><?php echo $newletter_lable; ?></label>
<div id="frm_subscribe">
<form name="subscribe" id="subscribe">
<input type="text" value="" name="subscribe_email" id="subscribe_email">
<input type="hidden" value="" name="subscribe_name" id="subscribe_name" />
<a class="button" onclick="email_subscribe()"><span><?php echo $entry_button; ?></span></a>
<?php if($option_unsubscribe) { ?>
<a class="button" onclick="email_unsubscribe()"><span><?php echo $entry_unbutton; ?></span></a>
<?php } ?>
</form>
</div><!-- /#frm_subscribe -->
<div id="notification_normal"></div>
</div><!-- /.box-content -->
</div>
</div>
<script type="text/javascript">
function email_subscribe(){
$.ajax({
type: 'post',
url: 'index.php?route=extension/module/newslettersubscribe/subscribe',
dataType: 'html',
data:$("#subscribe").serialize(),
success: function (html) {
eval(html);
}});
}
function email_unsubscribe(){
$.ajax({
type: 'post',
url: 'index.php?route=extension/module/newslettersubscribe/unsubscribe',
dataType: 'html',
data:$("#subscribe").serialize(),
success: function (html) {
eval(html);
}});
$('html, body').delay( 1500 ).animate({ scrollTop: 0 }, 'slow');
}
</script>
<script type="text/javascript">
$(document).ready(function() {
$('#subscribe_email').keypress(function(e) {
if(e.which == 13) {
e.preventDefault();
email_subscribe();
}
var name= $(this).val();
$('#subscribe_name').val(name);
});
$('#subscribe_email').change(function() {
var name= $(this).val();
$('#subscribe_name').val(name);
});
});
</script>
</div><!-- /.box -->
</div>
</div>
MageWorkshop DetailedReview 插件安装后出现main tables onknown column等数据库表结构错误
neasel 发表了文章 • 0 个评论 • 18 次浏览 • 2016-10-02 12:05
1.确定你安装插件的时候已经关闭了后台诉编译功能，且includes文件下没有任何其它的目录，上传完所有插件数据之后，请删除VAR下的所有目录。
2.再次刷新还无显示的话，则是服务器的配置导致PHP文件无权限向数据库中写入内容，这时需要你进入MYS ...查看全部
1.确定你安装插件的时候已经关闭了后台诉编译功能，且includes文件下没有任何其它的目录，上传完所有插件数据之后，请删除VAR下的所有目录。
2.再次刷新还无显示的话，则是服务器的配置导致PHP文件无权限向数据库中写入内容，这时需要你进入MYSQL管理，在相应的数据库中进行手动插入数据库表结构操作，相关SQL代码如下：
2.再次刷新还无显示的话，则是服务器的配置导致PHP文件无权限向数据库中写入内容，这时需要你进入MYSQL管理，在相应的数据库中进行手动插入数据库表结构操作，相关SQL代码如下：
CREATE TABLE IF NOT EXISTS `review` (
`review_id` bigint(20) unsigned NOT NULL COMMENT 'Review id',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Review create date',
`entity_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity id',
`entity_pk_value` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product id',
`status_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Status code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review base information';
-- --------------------------------------------------------
--
-- 表的结构 `review_author_ips`
--
CREATE TABLE IF NOT EXISTS `review_author_ips` (
`id` bigint(20) NOT NULL,
`expiration_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`remote_addr` varchar(255) DEFAULT NULL,
`customer_id` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- 表的结构 `review_detail`
--
CREATE TABLE IF NOT EXISTS `review_detail` (
`detail_id` bigint(20) unsigned NOT NULL COMMENT 'Review detail id',
`review_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Review id',
`store_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Store id',
`title` varchar(255) NOT NULL COMMENT 'Title',
`detail` text NOT NULL COMMENT 'Detail description',
`nickname` varchar(128) NOT NULL COMMENT 'User nickname',
`customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer Id',
`good_detail` text,
`no_good_detail` text,
`response` text,
`image` varchar(255) DEFAULT NULL,
`video` varchar(255) DEFAULT NULL,
`sizing` int(2) DEFAULT NULL,
`body_type` int(2) DEFAULT NULL,
`location` varchar(255) DEFAULT NULL,
`age` int(3) DEFAULT NULL,
`height` varchar(20) DEFAULT NULL,
`remote_addr` varchar(255) DEFAULT NULL,
`pros` varchar(255) DEFAULT NULL,
`cons` varchar(255) DEFAULT NULL,
`recommend_to` varchar(127) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review detail information';
-- --------------------------------------------------------
--
-- 表的结构 `review_entity`
--
CREATE TABLE IF NOT EXISTS `review_entity` (
`entity_id` smallint(5) unsigned NOT NULL COMMENT 'Review entity id',
`entity_code` varchar(32) NOT NULL COMMENT 'Review entity code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review entities';
-- --------------------------------------------------------
--
-- 表的结构 `review_entity_summary`
--
CREATE TABLE IF NOT EXISTS `review_entity_summary` (
`primary_id` bigint(20) NOT NULL COMMENT 'Summary review entity id',
`entity_pk_value` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Product id',
`entity_type` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Entity type id',
`reviews_count` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Qty of reviews',
`rating_summary` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Summarized rating',
`store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review aggregates';
-- --------------------------------------------------------
--
-- 表的结构 `review_helpful`
--
CREATE TABLE IF NOT EXISTS `review_helpful` (
`id` bigint(20) NOT NULL,
`review_id` bigint(20) NOT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`is_helpful` tinyint(1) NOT NULL,
`remote_addr` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- 表的结构 `review_proscons`
--
CREATE TABLE IF NOT EXISTS `review_proscons` (
`entity_id` smallint(5) unsigned NOT NULL,
`name` varchar(255) NOT NULL,
`status` tinyint(1) DEFAULT NULL,
`wrote_by` tinyint(1) NOT NULL DEFAULT '0',
`sort_order` smallint(5) DEFAULT NULL,
`entity_type` varchar(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- 表的结构 `review_proscons_store`
--
CREATE TABLE IF NOT EXISTS `review_proscons_store` (
`entity_id` smallint(6) unsigned NOT NULL,
`entity_type` varchar(1) NOT NULL,
`store_id` smallint(6) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- 表的结构 `review_status`
--
CREATE TABLE IF NOT EXISTS `review_status` (
`status_id` smallint(5) unsigned NOT NULL COMMENT 'Status id',
`status_code` varchar(32) NOT NULL COMMENT 'Status code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review statuses';
-- --------------------------------------------------------
--
-- 表的结构 `review_store`
--
CREATE TABLE IF NOT EXISTS `review_store` (
`review_id` bigint(20) unsigned NOT NULL COMMENT 'Review Id',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review Store';
--
-- Indexes for dumped tables
--
--
-- Indexes for table `review`
--
ALTER TABLE `review`
ADD PRIMARY KEY (`review_id`),
ADD KEY `IDX_REVIEW_ENTITY_ID` (`entity_id`),
ADD KEY `IDX_REVIEW_STATUS_ID` (`status_id`),
ADD KEY `IDX_REVIEW_ENTITY_PK_VALUE` (`entity_pk_value`);
--
-- Indexes for table `review_author_ips`
--
ALTER TABLE `review_author_ips`
ADD KEY `id` (`id`),
ADD KEY `remote_addr` (`remote_addr`),
ADD KEY `customer_id` (`customer_id`);
--
-- Indexes for table `review_detail`
--
ALTER TABLE `review_detail`
ADD PRIMARY KEY (`detail_id`),
ADD KEY `IDX_REVIEW_DETAIL_REVIEW_ID` (`review_id`),
ADD KEY `IDX_REVIEW_DETAIL_STORE_ID` (`store_id`),
ADD KEY `IDX_REVIEW_DETAIL_CUSTOMER_ID` (`customer_id`);
--
-- Indexes for table `review_entity`
--
ALTER TABLE `review_entity`
ADD PRIMARY KEY (`entity_id`);
--
-- Indexes for table `review_entity_summary`
--
ALTER TABLE `review_entity_summary`
ADD PRIMARY KEY (`primary_id`),
ADD KEY `IDX_REVIEW_ENTITY_SUMMARY_STORE_ID` (`store_id`);
--
-- Indexes for table `review_helpful`
--
ALTER TABLE `review_helpful`
ADD KEY `id` (`id`);
--
-- Indexes for table `review_proscons`
--
ALTER TABLE `review_proscons`
ADD PRIMARY KEY (`entity_id`);
--
-- Indexes for table `review_status`
--
ALTER TABLE `review_status`
ADD PRIMARY KEY (`status_id`);
--
-- Indexes for table `review_store`
--
ALTER TABLE `review_store`
ADD PRIMARY KEY (`review_id`,`store_id`),
ADD KEY `IDX_REVIEW_STORE_STORE_ID` (`store_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `review`
--
ALTER TABLE `review`
MODIFY `review_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review id';
--
-- AUTO_INCREMENT for table `review_author_ips`
--
ALTER TABLE `review_author_ips`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `review_detail`
--
ALTER TABLE `review_detail`
MODIFY `detail_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review detail id';
--
-- AUTO_INCREMENT for table `review_entity`
--
ALTER TABLE `review_entity`
MODIFY `entity_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review entity id';
--
-- AUTO_INCREMENT for table `review_entity_summary`
--
ALTER TABLE `review_entity_summary`
MODIFY `primary_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Summary review entity id';
--
-- AUTO_INCREMENT for table `review_helpful`
--
ALTER TABLE `review_helpful`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `review_proscons`
--
ALTER TABLE `review_proscons`
MODIFY `entity_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `review_status`
--
ALTER TABLE `review_status`
MODIFY `status_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Status id';
--
-- 限制导出的表
--
--
-- 限制表 `review`
--
ALTER TABLE `review`
ADD CONSTRAINT `FK_REVIEW_ENTITY_ID_REVIEW_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `review_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID` FOREIGN KEY (`status_id`) REFERENCES `review_status` (`status_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
--
-- 限制表 `review_detail`
--
ALTER TABLE `review_detail`
ADD CONSTRAINT `FK_REVIEW_DETAIL_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
ADD CONSTRAINT `FK_REVIEW_DETAIL_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_REVIEW_DETAIL_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;
--
-- 限制表 `review_entity_summary`
--
ALTER TABLE `review_entity_summary`
ADD CONSTRAINT `FK_REVIEW_ENTITY_SUMMARY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- 限制表 `review_store`
--
ALTER TABLE `review_store`
ADD CONSTRAINT `FK_REVIEW_STORE_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_REVIEW_STORE_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;
/*!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 */;