magento后台邮件订单,邮件不能发送

neasel 回复了问题 • 2 人关注 • 1 个回复 • 7 次浏览 • 2018-10-28 03:23 • 来自相关话题

MAGENTO1.X导入扩展出现后台访问直接跳转到前台404的解决方法

neasel 发表了文章 • 0 个评论 • 20 次浏览 • 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文件有的空间会自动删除
您可以手动创建此名称的文件,并填入以下内容


<?php
 class CapacityWebSolutions_ImportProduct_Model_Profile extends Mage_Core_Model_Abstract
{
 
 
}

 


opencart 2.3.0.2中使用domino模板时newsletter无响应的问题及修复

neasel 发表了文章 • 0 个评论 • 25 次浏览 • 2017-05-02 22:29 • 来自相关话题

此补丁包此是修复此模板中的NEWSLETTER问题,及NEWSLETTERPOP 修改位于catalog/controller/extension/module/newslettersubscribe.php<?php cla ...查看全部
此补丁包此是修复此模板中的NEWSLETTER问题,及NEWSLETTERPOP
修改位于catalog/controller/extension/module/newslettersubscribe.php
<?php  
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);
}
}
?>
修改文件 catalog/view/theme/您所使用的模板/template/extension/module/newsletterpopup/newsletterpopup.tpl
<div class="newletter-container">
<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>
修改文件 catalog/view/theme/您所使用的模板/template/extension/module/newsletterpopup/newslettersubscribe.tpl
<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>

Payplans 3.5.0 帶不出幣別

回复

jessekuotw 回复了问题 • 2 人关注 • 1 个回复 • 7 次浏览 • 2017-02-10 08:51 • 来自相关话题

MageWorkshop DetailedReview 插件安装后出现main tables onknown column等数据库表结构错误

neasel 发表了文章 • 0 个评论 • 19 次浏览 • 2016-10-02 12:05 • 来自相关话题

1.确定你安装插件的时候已经关闭了后台诉编译功能,且includes文件下没有任何其它的目录,上传完所有插件数据之后,请删除VAR下的所有目录。 2.再次刷新还无显示的话,则是服务器的配置导致PHP文件无权限向数据库中写入内容,这时需要你进入MYS ...查看全部
1.确定你安装插件的时候已经关闭了后台诉编译功能,且includes文件下没有任何其它的目录,上传完所有插件数据之后,请删除VAR下的所有目录。
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 */;