求大神修改一下我的magento1.6的演示数据sql文件

羽觞醉月2013 2016-04-09 07:21:01
我下载的
http://download.csdn.net/detail/yonglailizhi/8873901
这里的magento 1.6版的演示数据,那个sql运行是报错:
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE,
KEY `FK_TAG_FIRST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`first' at line 7
[Err] insert into `sales_order_status`(`status`,`label`) values ('canceled','Canceled'),('closed','Closed'),('complete','Complete'),('fraud','Suspected Fraud'),('holded','On Hold'),('payment_review','Payment Review'),('pending','Pending'),('pending_payment','Pending Payment'),('pending_paypal','Pending PayPal'),('processing','Processing');

UNLOCK TABLES;

/*Table structure for table `sales_order_status_label` */

DROP TABLE IF EXISTS `sales_order_status_label`;

CREATE TABLE `sales_order_status_label` (
`status` varchar(32) NOT NULL COMMENT 'Status',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
`label` varchar(128) NOT NULL COMMENT 'Label',
PRIMARY KEY (`status`,`store_id`),
KEY `IDX_SALES_ORDER_STATUS_LABEL_STORE_ID` (`store_id`),
CONSTRAINT `FK_SALES_ORDER_STATUS_LABEL_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_STATUS_LABEL_STATUS_SALES_ORDER_STATUS_STATUS` FOREIGN KEY (`status`) REFERENCES `sales_order_status` (`status`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Status Label Table';

/*Data for the table `sales_order_status_label` */

LOCK TABLES `sales_order_status_label` WRITE;

UNLOCK TABLES;

/*Table structure for table `sales_order_status_state` */

DROP TABLE IF EXISTS `sales_order_status_state`;

CREATE TABLE `sales_order_status_state` (
`status` varchar(32) NOT NULL COMMENT 'Status',
`state` varchar(32) NOT NULL COMMENT 'Label',
`is_default` smallint(5) unsigned NOT NULL COMMENT 'Is Default',
PRIMARY KEY (`status`,`state`),
CONSTRAINT `FK_SALES_ORDER_STATUS_STATE_STATUS_SALES_ORDER_STATUS_STATUS` FOREIGN KEY (`status`) REFERENCES `sales_order_status` (`status`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Status Table';

/*Data for the table `sales_order_status_state` */

LOCK TABLES `sales_order_status_state` WRITE;

insert into `sales_order_status_state`(`status`,`state`,`is_default`) values ('canceled','canceled',1),('closed','closed',1),('complete','complete',1),('fraud','payment_review',0),('holded','holded',1),('payment_review','payment_review',1),('pending','new',1),('pending_payment','pending_payment',1),('processing','processing',1);

UNLOCK TABLES;

/*Table structure for table `sales_order_tax` */

DROP TABLE IF EXISTS `sales_order_tax`;

CREATE TABLE `sales_order_tax` (
`tax_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tax Id',
`order_id` int(10) unsigned NOT NULL COMMENT 'Order Id',
`code` varchar(255) DEFAULT NULL COMMENT 'Code',
`title` varchar(255) DEFAULT NULL COMMENT 'Title',
`percent` decimal(12,4) DEFAULT NULL COMMENT 'Percent',
`amount` decimal(12,4) DEFAULT NULL COMMENT 'Amount',
`priority` int(11) NOT NULL COMMENT 'Priority',
`position` int(11) NOT NULL COMMENT 'Position',
`base_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Amount',
`process` smallint(6) NOT NULL COMMENT 'Process',
`base_real_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Real Amount',
`hidden` smallint(5) unsigned NOT NULL COMMENT 'Hidden',
PRIMARY KEY (`tax_id`),
KEY `IDX_SALES_ORDER_TAX_ORDER_ID_PRIORITY_POSITION` (`order_id`,`priority`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Tax Table';

/*Data for the table `sales_order_tax` */

LOCK TABLES `sales_order_tax` WRITE;

UNLOCK TABLES;

/*Table structure for table `sales_order_tax_item` */

DROP TABLE IF EXISTS `sales_order_tax_item`;

CREATE TABLE `sales_order_tax_item` (
`tax_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tax Item Id',
`tax_id` int(10) unsigned NOT NULL COMMENT 'Tax Id',
`item_id` int(10) unsigned NOT NULL COMMENT 'Item Id',
`tax_percent` decimal(12,4) NOT NULL COMMENT 'Real Tax Percent For Item',
PRIMARY KEY (`tax_item_id`),
UNIQUE KEY `UNQ_SALES_ORDER_TAX_ITEM_TAX_ID_ITEM_ID` (`tax_id`,`item_id`),
KEY `IDX_SALES_ORDER_TAX_
[Err] 1146 - Table 'magentotest.tag_summary' doesn't exist
[Err] insert into `tag_summary`(`tag_id`,`store_id`,`customers`,`products`,`uses`,`historical_uses`,`popularity`,`base_popularity`) values (1,0,1,1,0,0,1,0),(1,1,1,1,0,0,1,0),(2,0,1,3,0,0,3,0),(2,1,1,3,0,0,3,0),(3,0,1,2,0,0,2,0),(3,1,1,2,0,0,2,0),(4,0,1,4,0,0,4,0),(4,1,1,4,0,0,4,0),(5,0,1,4,0,0,4,0),(5,1,1,4,0,0,4,0),(6,0,1,1,0,0,1,0),(7,0,1,2,0,0,2,0),(7,1,1,2,0,0,2,0),(8,0,1,2,0,0,2,0),(8,1,1,2,0,0,2,0),(9,0,1,1,0,0,1,0),(9,1,1,1,0,0,1,0),(10,0,1,1,0,0,1,0),(10,1,1,1,0,0,1,0),(11,0,1,2,0,0,3,0),(11,1,1,2,0,0,2,0),(11,2,1,1,0,0,1,0),(12,0,1,7,0,0,7,0),(12,1,1,6,0,0,6,0),(12,2,1,1,0,0,1,0),(13,0,1,1,0,0,2,0),(13,1,1,1,0,0,1,0),(13,2,1,1,0,0,1,0),(14,0,1,2,0,0,2,0),(14,1,1,2,0,0,2,0),(15,0,1,1,0,0,1,0),(15,1,1,1,0,0,1,0),(16,0,1,4,0,0,5,0),(16,1,1,4,0,0,4,0),(16,2,1,1,0,0,1,0),(17,0,1,5,0,0,5,0),(17,1,1,4,0,0,4,0),(18,0,1,1,0,0,1,0),(18,1,1,1,0,0,1,0),(19,0,1,1,0,0,1,0),(19,1,1,1,0,0,1,0),(20,0,1,3,0,0,3,0),(20,1,1,3,0,0,3,0),(21,0,1,1,0,0,1,0),(21,1,1,1,0,0,1,0),(22,0,1,1,0,0,1,0),(22,1,1,1,0,0,1,0),(23,0,1,7,0,0,7,0),(23,1,1,5,0,0,5,0),(23,2,1,1,0,0,1,0),(24,0,1,1,0,0,1,0),(24,2,1,1,0,0,1,0),(25,0,1,1,0,0,1,0),(25,2,1,1,0,0,1,0),(26,0,1,1,0,0,1,0),(26,1,1,1,0,0,1,0),(27,0,1,11,0,0,11,0),(27,1,1,9,0,0,9,0),(28,0,1,4,0,0,4,0),(28,1,1,4,0,0,4,0),(29,0,1,7,0,0,8,0),(29,1,1,6,0,0,6,0),(29,2,1,1,0,0,1,0),(29,3,1,1,0,0,1,0),(30,0,1,6,0,0,7,0),(30,1,1,5,0,0,5,0),(30,2,1,1,0,0,1,0),(31,0,1,1,0,0,1,0),(31,1,1,1,0,0,1,0),(32,0,1,2,0,0,2,0),(32,1,1,1,0,0,1,0),(32,3,1,1,0,0,1,0),(33,0,1,1,0,0,1,0),(33,1,1,1,0,0,1,0),(34,0,1,1,0,0,1,0),(34,1,1,1,0,0,1,0),(35,0,1,3,0,0,3,0),(35,1,1,2,0,0,2,0),(36,0,1,1,0,0,1,0),(36,1,1,1,0,0,1,0),(37,0,1,3,0,0,3,0),(37,1,1,2,0,0,2,0),(38,0,1,1,0,0,1,0),(38,1,1,1,0,0,1,0),(39,0,1,1,0,0,1,0),(39,1,1,1,0,0,1,0),(40,0,1,1,0,0,1,0),(40,1,1,1,0,0,1,0),(41,0,1,4,0,0,4,0),(41,1,1,4,0,0,4,0),(42,0,1,4,0,0,4,0),(42,1,1,4,0,0,4,0),(43,0,1,2,0,0,2,0),(43,1,1,2,0,0,2,0),(44,0,1,2,0,0,2,0),(44,1,1,1,0,0,1,0),(45,0,1,2,0,0,2,0),(45,2,1,1,0,0,1,0),(46,0,1,1,0,0,1,0),(46,1,1,1,0,0,1,0),(47,0,1,1,0,0,1,0),(47,1,1,1,0,0,1,0),(48,0,1,2,0,0,2,0),(48,1,1,2,0,0,2,0),(49,0,1,1,0,0,1,0),(49,1,1,1,0,0,1,0),(50,0,1,1,0,0,1,0),(50,1,1,1,0,0,1,0),(51,0,1,4,0,0,4,0),(51,1,1,3,0,0,3,0),(51,2,1,1,0,0,1,0),(52,0,1,2,0,0,2,0),(52,1,1,2,0,0,2,0),(53,0,1,1,0,0,1,0),(53,1,1,1,0,0,1,0),(54,0,1,1,0,0,1,0),(55,0,1,3,0,0,3,0),(55,1,1,2,0,0,2,0),(55,2,1,1,0,0,1,0),(56,0,1,2,0,0,3,0),(56,1,1,1,0,0,1,0),(57,0,1,1,0,0,1,0),(57,1,1,1,0,0,1,0),(58,0,1,1,0,0,1,0),(58,1,1,1,0,0,1,0),(59,0,1,2,0,0,2,0),(59,1,1,1,0,0,1,0),(59,2,1,1,0,0,1,0),(60,0,1,1,0,0,1,0),(60,1,1,1,0,0,1,0),(61,0,1,5,0,0,5,0),(61,1,1,3,0,0,3,0),(61,2,1,1,0,0,1,0),(61,3,1,1,0,0,1,0),(62,0,1,1,0,0,1,0),(62,1,1,1,0,0,1,0),(63,0,1,1,0,0,1,0),(64,0,1,2,0,0,2,0),(64,1,1,2,0,0,2,0),(65,0,1,1,0,0,1,0),(65,1,1,1,0,0,1,0),(66,0,1,1,0,0,1,0),(66,1,1,1,0,0,1,0),(67,0,1,1,0,0,1,0),(67,1,1,1,0,0,1,0),(68,0,1,1,0,0,1,0),(68,1,1,1,0,0,1,0),(69,0,1,2,0,0,2,0),(69,1,1,2,0,0,2,0),(70,0,1,5,0,0,5,0),(70,1,1,3,0,0,3,0),(70,2,1,1,0,0,1,0),(71,0,1,1,0,0,1,0),(71,1,1,1,0,0,1,0),(72,0,1,1,0,0,1,0),(72,1,1,1,0,0,1,0),(73,0,1,1,0,0,1,0),(73,1,1,1,0,0,1,0),(74,0,1,1,0,0,1,0),(74,1,1,1,0,0,1,0),(75,0,1,1,0,0,1,0),(75,1,1,1,0,0,1,0),(76,0,1,2,0,0,2,0),(76,1,1,1,0,0,1,0),(76,3,1,1,0,0,1,0),(77,0,1,3,0,0,4,0),(77,1,1,3,0,0,3,0),(77,2,1,1,0,0,1,0),(78,0,1,1,0,0,1,0),(78,1,1,1,0,0,1,0),(79,0,1,2,0,0,2,0),(79,3,1,1,0,0,1,0),(80,0,1,2,0,0,2,0),(80,1,1,2,0,0,2,0),(81,0,1,2,0,0,2,0),(81,1,1,2,0,0,2,0),(82,0,1,1,0,0,1,0),(82,1,1,1,0,0,1,0),(83,0,1,1,0,0,1,0),(83,1,1,1,0,0,1,0),(84,0,1,1,0,0,1,0),(84,1,1,1,0,0,1,0),(85,0,1,1,0,0,1,0),(85,1,1,1,0,0,1,0),(86,0,1,2,0,0,2,0),(86,1,1,1,0,0,1,0),(86,3,1,1,0,0,1,0),(87,0,1,1,0,0,1,0),(87,1,1,1,0,0,1,0),(88,0,1,1,0,0,1,0),(88,1,1,1,0,0,1,0),(89,0,1,2,0,0,2,0),(89,1,1,2,0,0,2,0),(90,0,1,1,0,0,1,0),(90,1,1,1,0,0,1,0),(91,0,1,1,0,0,1,0),(91,1,1,1,0,0,1,0),(92,0,1,1,0,0,1,0),(92,1,1,1,0,0,1,0),(93,0,1,2,0,0,2,0),(93,1,1,2,0,0,2,0),(94,0,1,1,0,0,1,0),(94,1,1,1,0,0,1,0),(95,0,1,1,0,0,1,0),(96,0,1,1,0,0,1,0),(97,0,1,1,0,0,1,0),(98,0,1,1,0,0,1,0),(98,1,1,1,0,0,1,0),(99,0,1,1,0,0,1,0),
[Msg] Finished - Unsuccessfully
--------------------------------------------------
...全文
56 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

20,359

社区成员

发帖
与我相关
我的任务
社区描述
“超文本预处理器”,是在服务器端执行的脚本语言,尤其适用于Web开发并可嵌入HTML中。PHP语法利用了C、Java和Perl,该语言的主要目标是允许web开发人员快速编写动态网页。
phpphpstorm 技术论坛(原bbs)
社区管理员
  • 开源资源社区
  • phpstory
  • xuzuning
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧