Возраст домена | 16 лет |
Дата окончания | Истек срок регистрации |
PR | 1 |
ИКС | |
Страниц в Google | 3150 |
Страниц в Яндексе | 45 |
Dmoz | Нет |
Яндекс Каталог | Нет |
Alexa Traffic Rank | Нет данных |
Alexa Country | Нет данных |
История изменения показателей | Авторизация |
Идет сбор информации... Обновить
n/a
n/a
n/a
UTF-8
62.07 КБ
2 500
50 739 симв.
41 894 симв.
Данные предоставлены сервисом semrush
Сайт | Общие фразы | PR | тИЦ | Alexa Rank | Alexa Country | |
---|---|---|---|---|---|---|
ebay.com | 18 | 8 |
0 | 42 | 11 | |
amazon.com | 14 | 8 |
0 | 10 | 4 | |
crystalskulls.com | 11 | 3 |
0 | 1610844 | Нет данных | |
aliexpress.com | 11 | 6 |
0 | 32 | 10 | |
skullis.com | 9 | 3 |
0 | 1642574 | 461246 | |
crystalskulls.eu | 8 | 2 |
0 | 7064064 | Нет данных | |
dhgate.com | 8 | 7 |
0 | 1042 | 796 | |
alibaba.com | 7 | 7 |
0 | 161 | 99 | |
thinkgeek.com | 7 | 6 |
0 | 11311 | 2418 | |
angelslove.net | 6 | 1 |
0 | 7806250 | Нет данных | |
Еще 40 сайтов после авторизации |
Данные предоставлены сервисом semrush
[Querying whois.verisign-grs.com]
[Redirected to whois.lcn.com]
[Querying whois.lcn.com]
[whois.lcn.com]
Domain Registration Service Provided By: LCN.com
The Data in LCN.com's WHOIS database is provided by LCN.com for information
purposes, and to assist persons in obtaining information about or related to a
domain name registration record. LCN.com does not guarantee its accuracy.
By submitting a WHOIS query, you agree that you will use the data obtained only
for lawful purposes and that, under no circumstances will you use this data to:
(a) allow, enable, or otherwise support the transmission by e-mail, telephone,
or facsimile of mass, unsolicited, commercial advertising or solicitations to
entities other than the data recipient's own existing customers; or (b) enable
high volume, automated, electronic processes that send queries or data to the
systems of LCN.com, except as reasonably necessary to register domain names or
modify existing registrations.
By submitting this query, you agree to abide by this policy.
LCN.com reserves the right to modify these terms at any time.
domain: crystalswork.com
nameserver: ns1.fuzetesting.co.uk
nameserver: ns2.fuzetesting.co.uk
owner-contact:
admin-contact:
technical-contact: AI-300624
billing-contact: AI-300624
created: 2007-10-19 12:45:21
expires: 2014-10-19 12:45:21
changed: 2012-02-08 05:42:20.83813
contact-handle:
contact: Private User
organisation: Domain Privacy Protector Ltd
address: Office 404, 4th Floor
address: Albany House, 324/326 Regent Street
address: London
address: W1B 3HH
address: GB
phone: +44.2071836619
email: 756332d18172b31b8b35a8d5bd786f1a@domainprivacyprotector.com
contact-handle: AI-300624
contact: Hostmaster
address: Units H, J, K
address: Gateway 1000
address: Whittle Way
address: Stevenage
address: England
address: SG1 2FP
address: GB
phone: +44.1438342490
fax: +44.1438300137
email: support@lcn.com
*****************************************************************************
*******************************************************************************
** **
** Domain Registration Service Provided By: LCN.com **
** ------------------------------------------------ **
** **
** **
** - For award winning domain name services visit: **
** **
** http://www.lcn.com/domain_names **
** **
** - For powerful & reliable web hosting backed by a 30 day money **
** backed guarantee visit: **
** **
** http://www.lcn.com/web_hosting **
** **
** - For support visit: **
** **
** http://www.lcn.com/contact_us **
** **
*******************************************************************************
*****************************************************************************
PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'sales_flat_quote' already exists
[string:Exception:private] =>
[code:protected] => 42S01
[file:protected] => /home/cluster-sites/7/c/crystalswork.com/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line:protected] => 230
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/cluster-sites/7/c/crystalswork.com/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 230
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `sales_flat_quote` (
`entity_id` int(10) unsigned NOT NULL auto_increment,
`store_id` smallint(5) unsigned NOT NULL default '0',
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`converted_at` datetime NOT NULL default '0000-00-00 00:00:00',
`is_active` tinyint(1) unsigned default '1',
`is_virtual` tinyint(1) unsigned default '0',
`is_multi_shipping` tinyint(1) unsigned default '0',
`items_count` int(10) unsigned default '0',
`items_qty` decimal(12,4) default '0.0000',
`orig_order_id` int(10) unsigned default '0',
`store_to_base_rate` decimal(12,4) default '0.0000',
`store_to_quote_rate` decimal(12,4) default '0.0000',
`base_currency_code` varchar(255) default NULL,
`store_currency_code` varchar(255) default NULL,
`quote_currency_code` varchar(255) default NULL,
`grand_total` decimal(12,4) default '0.0000',
`base_grand_total` decimal(12,4) default '0.0000',
`checkout_method` varchar(255) default NULL,
`customer_id` int(10) unsigned default '0',
`customer_tax_class_id` int(10) unsigned default '0',
`customer_group_id` int(10) unsigned default '0',
`customer_email` varchar(255) default NULL,
`customer_prefix` varchar(40) default NULL,
`customer_firstname` varchar(255) default NULL,
`customer_middlename` varchar(40) default NULL,
`customer_lastname` varchar(255) default NULL,
`customer_suffix` varchar(40) default NULL,
`customer_dob` datetime default NULL,
`customer_note` varchar(255) default NULL,
`customer_note_notify` tinyint(1) unsigned default '1',
`customer_is_guest` tinyint(1) unsigned default '0',
`remote_ip` varchar(32) default NULL,
`applied_rule_ids` varchar(255) default NULL,
`reserved_order_id` varchar(64) default '',
`password_hash` varchar(255) default NULL,
`coupon_code` varchar(255) default NULL,
PRIMARY KEY (`entity_id`),
KEY `FK_SALES_QUOTE_STORE` (`store_id`),
KEY `IDX_CUSTOMER` (`customer_id`,`store_id`,`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)
)
[1] => Array
(
[file] => /home/cluster-sites/7/c/crystalswork.com/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 339
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `sales_flat_quote` (
`entity_id` int(10) unsigned NOT NULL auto_increment,
`store_id` smallint(5) unsigned NOT NULL default '0',
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`converted_at` datetime NOT NULL default '0000-00-00 00:00:00',
`is_active` tinyint(1) unsigned default '1',
`is_virtual` tinyint(1) unsigned default '0',
`is_multi_shipping` tinyint(1) unsigned default '0',
`items_count` int(10) unsigned default '0',
`items_qty` decimal(12,4) default '0.0000',
`orig_order_id` int(10) unsigned default '0',
`store_to_base_rate` decimal(12,4) default '0.0000',
`store_to_quote_rate` decimal(12,4) default '0.0000',
`base_currency_code` varchar(255) default NULL,
`store_currency_code` varchar(255) default NULL,
`quote_currency_code` varchar(255) default NULL,
`grand_total` decimal(12,4) default '0.0000',
`base_grand_total` decimal(12,4) default '0.0000',
`checkout_method` varchar(255) default NULL,
`customer_id` int(10) unsigned default '0',
`customer_tax_class_id` int(10) unsigned default '0',
`customer_group_id` int(10) unsigned default '0',
`customer_email` varchar(255) default NULL,
`customer_prefix` varchar(40) default NULL,
`customer_firstname` varchar(255) default NULL,
`customer_middlename` varchar(40) default NULL,
`customer_lastname` varchar(255) default NULL,
`customer_suffix` varchar(40) default NULL,
`customer_dob` datetime default NULL,
`customer_note` varchar(255) default NULL,
`customer_note_notify` tinyint(1) unsigned default '1',
`customer_is_guest` tinyint(1) unsigned default '0',
`remote_ip` varchar(32) default NULL,
`applied_rule_ids` varchar(255) default NULL,
`reserved_order_id` varchar(64) default '',
`password_hash` varchar(255) default NULL,
`coupon_code` varchar(255) default NULL,
PRIMARY KEY (`entity_id`),
KEY `FK_SALES_QUOTE_STORE` (`store_id`),
KEY `IDX_CUSTOMER` (`customer_id`,`store_id`,`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)
)
[2] => Array
(
[file] => /home/cluster-sites/7/c/crystalswork.com/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 535
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE `sales_flat_quote` (
`entity_id` int(10) unsigned NOT NULL auto_increment,
`store_id` smallint(5) unsigned NOT NULL default '0',
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`converted_at` datetime NOT NULL default '0000-00-00 00:00:00',
`is_active` tinyint(1) unsigned default '1',
`is_virtual` tinyint(1) unsigned default '0',
`is_multi_shipping` tinyint(1) unsigned default '0',
`items_count` int(10) unsigned default '0',
`items_qty` decimal(12,4) default '0.0000',
`orig_order_id` int(10) unsigned default '0',
`store_to_base_rate` decimal(12,4) default '0.0000',
`store_to_quote_rate` decimal(12,4) default '0.0000',
`base_currency_code` varchar(255) default NULL,
`store_currency_code` varchar(255) default NULL,
`quote_currency_code` varchar(255) default NULL,
`grand_total` decimal(12,4) default '0.0000',
`base_grand_total` decimal(12,4) default '0.0000',
`checkout_method` varchar(255) default NULL,
`customer_id` int(10) unsigned default '0',
`customer_tax_class_id` int(10) unsigned default '0',
`customer_group_id` int(10) unsigned default '0',
`customer_email` varchar(255) default NULL,
`customer_prefix` varchar(40) default NULL,
`customer_firstname` varchar(255) default NULL,
`customer_middlename` varchar(40) default NULL,
`customer_lastname` varchar(255) default NULL,
`customer_suffix` varchar(40) default NULL,
`customer_dob` datetime default NULL,
`customer_note` varchar(255) default NULL,
`customer_note_notify` tinyint(1) unsigned default '1',
`customer_is_guest` tinyint(1) unsigned default '0',
`remote_ip` varchar(32) default NULL,
`applied_rule_ids` varchar(255) default NULL,
`reserved_order_id` varchar(64) default '',
`password_hash` varchar(255) default NULL,
`coupon_code` varchar(255) default NULL,
PRIMARY KEY (`entity_id`),
KEY `FK_SALES_QUOTE_STORE` (`store_id`),
KEY `IDX_CUSTOMER` (`customer_id`,`store_id`,`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_flat_quote_address` (
`address_id` int(10) unsigned NOT NULL auto_increment,
`quote_id` int(10) unsigned NOT NULL default '0',
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`customer_id` int(10) unsigned default NULL,
`save_in_address_book` tinyint(1) default '0',
`customer_address_id` int(10) unsigned default NULL,
`address_type` varchar(255) default NULL,
`email` varchar(255) default NULL,
`prefix` varchar(40) default NULL,
`firstname` varchar(255) default NULL,
`middlename` varchar(40) default NULL,
`lastname` varchar(255) default NULL,
`suffix` varchar(40) default NULL,
`company` varchar(255) default NULL,
`street` varchar(255) default NULL,
`city` varchar(255) default NULL,
`region` varchar(255) default NULL,
`region_id` int(10) unsigned default NULL,
`postcode` varchar(255) default NULL,
`country_id` varchar(255) default NULL,
`telephone` varchar(255) default NULL,
`fax` varchar(255) default NULL,
`same_as_billing` tinyint(1) unsigned NOT NULL default '0',
`free_shipping` tinyint(1) unsigned NOT NULL default '0',
`collect_shipping_rates` tinyint(1) unsigned NOT NULL default '0',
`shipping_method` varchar(255) NOT NULL default '',
`shipping_description` varchar(255) NOT NULL default '',
`weight` decimal(12,4) NOT NULL default '0.0000',
`subtotal` decimal(12,4) NOT NULL default '0.0000',
`base_subtotal` decimal(12,4) NOT NULL default '0.0000',
`subtotal_with_discount` decimal(12,4) NOT NULL default '0.0000',
`base_subtotal_with_discount` decimal(12,4) NOT NULL default '0.0000',
`tax_amount` decimal(12,4) NOT NULL default '0.0000',
`base_tax_amount` decimal(12,4) NOT NULL default '0.0000',
`shipping_amount` decimal(12,4) NOT NULL default '0.0000',
`base_shipping_amount` decimal(12,4) NOT NULL default '0.0000',
`shipping_tax_amount` decimal(12,4) default NULL,
`base_shipping_tax_amount` decimal(12,4) default NULL,
`discount_amount` decimal(12,4) NOT NULL default '0.0000',
`base_discount_amount` decimal(12,4) NOT NULL default '0.0000',
`grand_total` decimal(12,4) NOT NULL default '0.0000',
`base_grand_total` decimal(12,4) NOT NULL default '0.0000',
`customer_notes` text,
PRIMARY KEY (`address_id`),
KEY `FK_SALES_QUOTE_ADDRESS_SALES_QUOTE` (`quote_id`),
CONSTRAINT `FK_SALES_QUOTE_ADDRESS_SALES_QUOTE` FOREIGN KEY (`quote_id`) REFERENCES `sales_flat_quote` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_flat_quote_address_item` (
`address_item_id` int(10) unsigned NOT NULL auto_increment,
`quote_address_id` int(10) unsigned NOT NULL default '0',
`quote_item_id` int(10) unsigned NOT NULL default '0',
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`applied_rule_ids` text,
`additional_data` text,
`weight` decimal(12,4) default '0.0000',
`qty` decimal(12,4) NOT NULL default '0.0000',
`discount_amount` decimal(12,4) default '0.0000',
`tax_amount` decimal(12,4) default '0.0000',
`row_total` decimal(12,4) NOT NULL default '0.0000',
`base_row_total` decimal(12,4) NOT NULL default '0.0000',
`row_total_with_discount` decimal(12,4) default '0.0000',
`base_discount_amount` decimal(12,4) default '0.0000',
`base_tax_amount` decimal(12,4) default '0.0000',
`row_weight` decimal(12,4) default '0.0000',
PRIMARY KEY (`address_item_id`),
KEY `FK_QUOTE_ADDRESS_ITEM_QUOTE_ADDRESS` (`quote_address_id`),
KEY `FK_SALES_QUOTE_ADDRESS_ITEM_QUOTE_ITEM` (`quote_item_id`),
CONSTRAINT `FK_QUOTE_ADDRESS_ITEM_QUOTE_ADDRESS` FOREIGN KEY (`quote_address_id`) REFERENCES `sales_flat_quote_address` (`address_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_QUOTE_ADDRESS_ITEM_QUOTE_ITEM` FOREIGN KEY (`quote_item_id`) REFERENCES `sales_flat_quote_item` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_flat_quote_item` (
`item_id` int(10) unsigned NOT NULL auto_increment,
`quote_id` int(10) unsigned NOT NULL default '0',
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`product_id` int(10) unsigned default NULL,
`super_product_id` int(10) unsigned default NULL,
`parent_product_id` int(10) unsigned default NULL,
`is_virtual` tinyint(1) unsigned default NULL,
`sku` varchar(255) NOT NULL default '',
`name` varchar(255) default NULL,
`description` text,
`applied_rule_ids` text,
`additional_data` text,
`free_shipping` tinyint(1) unsigned NOT NULL default '0',
`is_qty_decimal` tinyint(1) unsigned default NULL,
`no_discount` tinyint(1) unsigned default '0',
`weight` decimal(12,4) default '0.0000',
`qty` decimal(12,4) NOT NULL default '0.0000',
`price` decimal(12,4) NOT NULL default '0.0000',
`base_price` decimal(12,4) NOT NULL default '0.0000',
`custom_price` decimal(12,4) default NULL,
`discount_percent` decimal(12,4) default '0.0000',
`discount_amount` decimal(12,4) default '0.0000',
`base_discount_amount` decimal(12,4) default '0.0000',
`tax_percent` decimal(12,4) default '0.0000',
`tax_amount` decimal(12,4) default '0.0000',
`base_tax_amount` decimal(12,4) default '0.0000',
`row_total` decimal(12,4) NOT NULL default '0.0000',
`base_row_total` decimal(12,4) NOT NULL default '0.0000',
`row_total_with_discount` decimal(12,4) default '0.0000',
`row_weight` decimal(12,4) default '0.0000',
PRIMARY KEY (`item_id`),
KEY `FK_SALES_QUOTE_ITEM_SALES_QUOTE` (`quote_id`),
CONSTRAINT `FK_SALES_QUOTE_ITEM_SALES_QUOTE` FOREIGN KEY (`quote_id`) REFERENCES `sales_flat_quote` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_flat_quote_item_option` (
`option_id` int(10) unsigned NOT NULL auto_increment,
`item_id` int(10) unsigned NOT NULL,
`product_id` int(10) unsigned NOT NULL,
`code` varchar(255) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`option_id`),
KEY `FK_SALES_QUOTE_ITEM_OPTION_ITEM_ID` (`item_id`),
CONSTRAINT `FK_SALES_QUOTE_ITEM_OPTION_ITEM_ID` FOREIGN KEY (`item_id`) REFERENCES `sales_flat_quote_item` (`item_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Additional options for quote item';
CREATE TABLE `sales_flat_quote_payment` (
`payment_id` int(10) unsigned NOT NULL auto_increment,
`quote_id` int(10) unsigned NOT NULL default '0',
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`method` varchar(255) default '',
`cc_type` varchar(255) default '',
`cc_number_enc` varchar(255) default '',
`cc_last4` varchar(255) default '',
`cc_cid_enc` varchar(255) default '',
`cc_owner` varchar(255) default '',
`cc_exp_month` tinyint(2) unsigned default '0',
`cc_exp_year` smallint(4) unsigned default '0',
`cc_ss_owner` varchar(255) default '',
`cc_ss_start_month` tinyint(2) unsigned default '0',
`cc_ss_start_year` smallint(4) unsigned default '0',
`cybersource_token` varchar(255) default '',
`paypal_correlation_id` varchar(255) default '',
`paypal_payer_id` varchar(255) default '',
`paypal_payer_status` varchar(255) default '',
`po_number` varchar(255) default '',
PRIMARY KEY (`payment_id`),
KEY `FK_SALES_QUOTE_PAYMENT_SALES_QUOTE` (`quote_id`),
CONSTRAINT `FK_SALES_QUOTE_PAYMENT_SALES_QUOTE` FOREIGN KEY (`quote_id`) REFERENCES `sales_flat_quote` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_flat_quote_shipping_rate` (
`rate_id` int(10) unsigned NOT NULL auto_increment,
`address_id` int(10) unsigned NOT NULL default '0',
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`carrier` varchar(255) default NULL,
`carrier_title` varchar(255) default NULL,
`code` varchar(255) default NULL,
`method` varchar(255) default NULL,
`method_description` text,
`price` decimal(12,4) NOT NULL default '0.0000',
PRIMARY KEY (`rate_id`),
KEY `FK_SALES_QUOTE_SHIPPING_RATE_ADDRESS` (`address_id`),
CONSTRAINT `FK_SALES_QUOTE_SHIPPING_RATE_ADDRESS` FOREIGN KEY (`address_id`) REFERENCES `sales_flat_quote_address` (`address_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order` (
`entity_id` int(10) unsigned NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_set_id` smallint(5) unsigned NOT NULL default '0',
`increment_id` varchar(50) NOT NULL default '',
`parent_id` int(10) unsigned NOT NULL default '0',
`store_id` smallint(5) unsigned default NULL,
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`is_active` tinyint(1) unsigned NOT NULL default '1',
`customer_id` int(11) default NULL,
`tax_amount` decimal(12,4) NOT NULL default '0.0000',
`shipping_amount` decimal(12,4) NOT NULL default '0.0000',
`discount_amount` decimal(12,4) NOT NULL default '0.0000',
`subtotal` decimal(12,4) NOT NULL default '0.0000',
`grand_total` decimal(12,4) NOT NULL default '0.0000',
`total_paid` decimal(12,4) NOT NULL default '0.0000',
`total_refunded` decimal(12,4) NOT NULL default '0.0000',
`total_qty_ordered` decimal(12,4) NOT NULL default '0.0000',
`total_canceled` decimal(12,4) NOT NULL default '0.0000',
`total_invoiced` decimal(12,4) NOT NULL default '0.0000',
`total_online_refunded` decimal(12,4) NOT NULL default '0.0000',
`total_offline_refunded` decimal(12,4) NOT NULL default '0.0000',
`base_tax_amount` decimal(12,4) NOT NULL default '0.0000',
`base_shipping_amount` decimal(12,4) NOT NULL default '0.0000',
`base_discount_amount` decimal(12,4) NOT NULL default '0.0000',
`base_subtotal` decimal(12,4) NOT NULL default '0.0000',
`base_grand_total` decimal(12,4) NOT NULL default '0.0000',
`base_total_paid` decimal(12,4) NOT NULL default '0.0000',
`base_total_refunded` decimal(12,4) NOT NULL default '0.0000',
`base_total_qty_ordered` decimal(12,4) NOT NULL default '0.0000',
`base_total_canceled` decimal(12,4) NOT NULL default '0.0000',
`base_total_invoiced` decimal(12,4) NOT NULL default '0.0000',
`base_total_online_refunded` decimal(12,4) NOT NULL default '0.0000',
`base_total_offline_refunded` decimal(12,4) NOT NULL default '0.0000',
`subtotal_refunded` decimal(12,4) default NULL,
`subtotal_canceled` decimal(12,4) default NULL,
`tax_refunded` decimal(12,4) default NULL,
`tax_canceled` decimal(12,4) default NULL,
`shipping_refunded` decimal(12,4) default NULL,
`shipping_canceled` decimal(12,4) default NULL,
`base_subtotal_refunded` decimal(12,4) default NULL,
`base_subtotal_canceled` decimal(12,4) default NULL,
`base_tax_refunded` decimal(12,4) default NULL,
`base_tax_canceled` decimal(12,4) default NULL,
`base_shipping_refunded` decimal(12,4) default NULL,
`base_shipping_canceled` decimal(12,4) default NULL,
`subtotal_invoiced` decimal(12,4) default NULL,
`tax_invoiced` decimal(12,4) default NULL,
`shipping_invoiced` decimal(12,4) default NULL,
`base_subtotal_invoiced` decimal(12,4) default NULL,
`base_tax_invoiced` decimal(12,4) default NULL,
`base_shipping_invoiced` decimal(12,4) default NULL,
`shipping_tax_amount` decimal(12,4) default NULL,
`base_shipping_tax_amount` decimal(12,4) default NULL,
PRIMARY KEY (`entity_id`),
KEY `FK_SALES_ORDER_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_STORE` (`store_id`),
KEY `IDX_CUSTOMER` (`customer_id`),
CONSTRAINT `FK_SALE_ORDER_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `FK_SALE_ORDER_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `sales_order_datetime` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_DATETIME_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_DATETIME_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_DATETIME` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_DATETIME` FOREIGN KEY (`entity_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_DATETIME_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_DATETIME_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_decimal` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` decimal(12,4) NOT NULL default '0.0000',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_DECIMAL_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_DECIMAL_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_DECIMAL` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_DECIMAL` FOREIGN KEY (`entity_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_DECIMAL_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_DECIMAL_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_int` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` int(11) NOT NULL default '0',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_INT_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_INT_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_INT` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_INT` FOREIGN KEY (`entity_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_INT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_INT_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_text` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` text NOT NULL,
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_TEXT_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_TEXT_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_TEXT` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_TEXT` FOREIGN KEY (`entity_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_TEXT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_TEXT_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_varchar` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_VARCHAR_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_VARCHAR_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_VARCHAR` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_VARCHAR` FOREIGN KEY (`entity_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_VARCHAR_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_VARCHAR_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_entity` (
`entity_id` int(10) unsigned NOT NULL auto_increment,
`entity_type_id` smallint(8) unsigned NOT NULL default '0',
`attribute_set_id` smallint(5) unsigned NOT NULL default '0',
`increment_id` varchar(50) NOT NULL default '',
`parent_id` int(10) unsigned NOT NULL default '0',
`store_id` smallint(5) unsigned default NULL,
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`is_active` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`entity_id`),
KEY `FK_SALES_ORDER_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_ENTITY_STORE` (`store_id`),
CONSTRAINT `FK_SALES_ORDER_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALE_ORDER_ENTITY_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `sales_order_entity_datetime` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_ENTITY_DATETIME_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_ENTITY_DATETIME_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_ENTITY_DATETIME` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_ENTITY_DATETIME` FOREIGN KEY (`entity_id`) REFERENCES `sales_order_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_DATETIME_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_DATETIME_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_entity_decimal` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` decimal(12,4) NOT NULL default '0.0000',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_ENTITY_DECIMAL_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_ENTITY_DECIMAL_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_ENTITY_DECIMAL` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_ENTITY_DECIMAL` FOREIGN KEY (`entity_id`) REFERENCES `sales_order_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_DECIMAL_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_DECIMAL_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_entity_int` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` int(11) NOT NULL default '0',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_ENTITY_INT_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_ENTITY_INT_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_ENTITY_INT` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_ENTITY_INT` FOREIGN KEY (`entity_id`) REFERENCES `sales_order_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_INT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_INT_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_entity_text` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` text NOT NULL,
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_ENTITY_TEXT_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_ENTITY_TEXT_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_ENTITY_TEXT` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_ENTITY_TEXT` FOREIGN KEY (`entity_id`) REFERENCES `sales_order_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_TEXT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_TEXT_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_entity_varchar` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_ENTITY_VARCHAR_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_ENTITY_VARCHAR_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_ENTITY_VARCHAR` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_ENTITY_VARCHAR` FOREIGN KEY (`entity_id`) REFERENCES `sales_order_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_VARCHAR_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_VARCHAR_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
)
)
[3] => Array
(
[file] => /home/cluster-sites/7/c/crystalswork.com/public_html/app/code/core/Mage/Sales/sql/sales_setup/mysql4-install-0.9.0.php
[line] => 487
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE `sales_flat_quote` (
`entity_id` int(10) unsigned NOT NULL auto_increment,
`store_id` smallint(5) unsigned NOT NULL default '0',
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`converted_at` datetime NOT NULL default '0000-00-00 00:00:00',
`is_active` tinyint(1) unsigned default '1',
`is_virtual` tinyint(1) unsigned default '0',
`is_multi_shipping` tinyint(1) unsigned default '0',
`items_count` int(10) unsigned default '0',
`items_qty` decimal(12,4) default '0.0000',
`orig_order_id` int(10) unsigned default '0',
`store_to_base_rate` decimal(12,4) default '0.0000',
`store_to_quote_rate` decimal(12,4) default '0.0000',
`base_currency_code` varchar(255) default NULL,
`store_currency_code` varchar(255) default NULL,
`quote_currency_code` varchar(255) default NULL,
`grand_total` decimal(12,4) default '0.0000',
`base_grand_total` decimal(12,4) default '0.0000',
`checkout_method` varchar(255) default NULL,
`customer_id` int(10) unsigned default '0',
`customer_tax_class_id` int(10) unsigned default '0',
`customer_group_id` int(10) unsigned default '0',
`customer_email` varchar(255) default NULL,
`customer_prefix` varchar(40) default NULL,
`customer_firstname` varchar(255) default NULL,
`customer_middlename` varchar(40) default NULL,
`customer_lastname` varchar(255) default NULL,
`customer_suffix` varchar(40) default NULL,
`customer_dob` datetime default NULL,
`customer_note` varchar(255) default NULL,
`customer_note_notify` tinyint(1) unsigned default '1',
`customer_is_guest` tinyint(1) unsigned default '0',
`remote_ip` varchar(32) default NULL,
`applied_rule_ids` varchar(255) default NULL,
`reserved_order_id` varchar(64) default '',
`password_hash` varchar(255) default NULL,
`coupon_code` varchar(255) default NULL,
PRIMARY KEY (`entity_id`),
KEY `FK_SALES_QUOTE_STORE` (`store_id`),
KEY `IDX_CUSTOMER` (`customer_id`,`store_id`,`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_flat_quote_address` (
`address_id` int(10) unsigned NOT NULL auto_increment,
`quote_id` int(10) unsigned NOT NULL default '0',
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`customer_id` int(10) unsigned default NULL,
`save_in_address_book` tinyint(1) default '0',
`customer_address_id` int(10) unsigned default NULL,
`address_type` varchar(255) default NULL,
`email` varchar(255) default NULL,
`prefix` varchar(40) default NULL,
`firstname` varchar(255) default NULL,
`middlename` varchar(40) default NULL,
`lastname` varchar(255) default NULL,
`suffix` varchar(40) default NULL,
`company` varchar(255) default NULL,
`street` varchar(255) default NULL,
`city` varchar(255) default NULL,
`region` varchar(255) default NULL,
`region_id` int(10) unsigned default NULL,
`postcode` varchar(255) default NULL,
`country_id` varchar(255) default NULL,
`telephone` varchar(255) default NULL,
`fax` varchar(255) default NULL,
`same_as_billing` tinyint(1) unsigned NOT NULL default '0',
`free_shipping` tinyint(1) unsigned NOT NULL default '0',
`collect_shipping_rates` tinyint(1) unsigned NOT NULL default '0',
`shipping_method` varchar(255) NOT NULL default '',
`shipping_description` varchar(255) NOT NULL default '',
`weight` decimal(12,4) NOT NULL default '0.0000',
`subtotal` decimal(12,4) NOT NULL default '0.0000',
`base_subtotal` decimal(12,4) NOT NULL default '0.0000',
`subtotal_with_discount` decimal(12,4) NOT NULL default '0.0000',
`base_subtotal_with_discount` decimal(12,4) NOT NULL default '0.0000',
`tax_amount` decimal(12,4) NOT NULL default '0.0000',
`base_tax_amount` decimal(12,4) NOT NULL default '0.0000',
`shipping_amount` decimal(12,4) NOT NULL default '0.0000',
`base_shipping_amount` decimal(12,4) NOT NULL default '0.0000',
`shipping_tax_amount` decimal(12,4) default NULL,
`base_shipping_tax_amount` decimal(12,4) default NULL,
`discount_amount` decimal(12,4) NOT NULL default '0.0000',
`base_discount_amount` decimal(12,4) NOT NULL default '0.0000',
`grand_total` decimal(12,4) NOT NULL default '0.0000',
`base_grand_total` decimal(12,4) NOT NULL default '0.0000',
`customer_notes` text,
PRIMARY KEY (`address_id`),
KEY `FK_SALES_QUOTE_ADDRESS_SALES_QUOTE` (`quote_id`),
CONSTRAINT `FK_SALES_QUOTE_ADDRESS_SALES_QUOTE` FOREIGN KEY (`quote_id`) REFERENCES `sales_flat_quote` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_flat_quote_address_item` (
`address_item_id` int(10) unsigned NOT NULL auto_increment,
`quote_address_id` int(10) unsigned NOT NULL default '0',
`quote_item_id` int(10) unsigned NOT NULL default '0',
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`applied_rule_ids` text,
`additional_data` text,
`weight` decimal(12,4) default '0.0000',
`qty` decimal(12,4) NOT NULL default '0.0000',
`discount_amount` decimal(12,4) default '0.0000',
`tax_amount` decimal(12,4) default '0.0000',
`row_total` decimal(12,4) NOT NULL default '0.0000',
`base_row_total` decimal(12,4) NOT NULL default '0.0000',
`row_total_with_discount` decimal(12,4) default '0.0000',
`base_discount_amount` decimal(12,4) default '0.0000',
`base_tax_amount` decimal(12,4) default '0.0000',
`row_weight` decimal(12,4) default '0.0000',
PRIMARY KEY (`address_item_id`),
KEY `FK_QUOTE_ADDRESS_ITEM_QUOTE_ADDRESS` (`quote_address_id`),
KEY `FK_SALES_QUOTE_ADDRESS_ITEM_QUOTE_ITEM` (`quote_item_id`),
CONSTRAINT `FK_QUOTE_ADDRESS_ITEM_QUOTE_ADDRESS` FOREIGN KEY (`quote_address_id`) REFERENCES `sales_flat_quote_address` (`address_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_QUOTE_ADDRESS_ITEM_QUOTE_ITEM` FOREIGN KEY (`quote_item_id`) REFERENCES `sales_flat_quote_item` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_flat_quote_item` (
`item_id` int(10) unsigned NOT NULL auto_increment,
`quote_id` int(10) unsigned NOT NULL default '0',
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`product_id` int(10) unsigned default NULL,
`super_product_id` int(10) unsigned default NULL,
`parent_product_id` int(10) unsigned default NULL,
`is_virtual` tinyint(1) unsigned default NULL,
`sku` varchar(255) NOT NULL default '',
`name` varchar(255) default NULL,
`description` text,
`applied_rule_ids` text,
`additional_data` text,
`free_shipping` tinyint(1) unsigned NOT NULL default '0',
`is_qty_decimal` tinyint(1) unsigned default NULL,
`no_discount` tinyint(1) unsigned default '0',
`weight` decimal(12,4) default '0.0000',
`qty` decimal(12,4) NOT NULL default '0.0000',
`price` decimal(12,4) NOT NULL default '0.0000',
`base_price` decimal(12,4) NOT NULL default '0.0000',
`custom_price` decimal(12,4) default NULL,
`discount_percent` decimal(12,4) default '0.0000',
`discount_amount` decimal(12,4) default '0.0000',
`base_discount_amount` decimal(12,4) default '0.0000',
`tax_percent` decimal(12,4) default '0.0000',
`tax_amount` decimal(12,4) default '0.0000',
`base_tax_amount` decimal(12,4) default '0.0000',
`row_total` decimal(12,4) NOT NULL default '0.0000',
`base_row_total` decimal(12,4) NOT NULL default '0.0000',
`row_total_with_discount` decimal(12,4) default '0.0000',
`row_weight` decimal(12,4) default '0.0000',
PRIMARY KEY (`item_id`),
KEY `FK_SALES_QUOTE_ITEM_SALES_QUOTE` (`quote_id`),
CONSTRAINT `FK_SALES_QUOTE_ITEM_SALES_QUOTE` FOREIGN KEY (`quote_id`) REFERENCES `sales_flat_quote` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_flat_quote_item_option` (
`option_id` int(10) unsigned NOT NULL auto_increment,
`item_id` int(10) unsigned NOT NULL,
`product_id` int(10) unsigned NOT NULL,
`code` varchar(255) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`option_id`),
KEY `FK_SALES_QUOTE_ITEM_OPTION_ITEM_ID` (`item_id`),
CONSTRAINT `FK_SALES_QUOTE_ITEM_OPTION_ITEM_ID` FOREIGN KEY (`item_id`) REFERENCES `sales_flat_quote_item` (`item_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Additional options for quote item';
CREATE TABLE `sales_flat_quote_payment` (
`payment_id` int(10) unsigned NOT NULL auto_increment,
`quote_id` int(10) unsigned NOT NULL default '0',
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`method` varchar(255) default '',
`cc_type` varchar(255) default '',
`cc_number_enc` varchar(255) default '',
`cc_last4` varchar(255) default '',
`cc_cid_enc` varchar(255) default '',
`cc_owner` varchar(255) default '',
`cc_exp_month` tinyint(2) unsigned default '0',
`cc_exp_year` smallint(4) unsigned default '0',
`cc_ss_owner` varchar(255) default '',
`cc_ss_start_month` tinyint(2) unsigned default '0',
`cc_ss_start_year` smallint(4) unsigned default '0',
`cybersource_token` varchar(255) default '',
`paypal_correlation_id` varchar(255) default '',
`paypal_payer_id` varchar(255) default '',
`paypal_payer_status` varchar(255) default '',
`po_number` varchar(255) default '',
PRIMARY KEY (`payment_id`),
KEY `FK_SALES_QUOTE_PAYMENT_SALES_QUOTE` (`quote_id`),
CONSTRAINT `FK_SALES_QUOTE_PAYMENT_SALES_QUOTE` FOREIGN KEY (`quote_id`) REFERENCES `sales_flat_quote` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_flat_quote_shipping_rate` (
`rate_id` int(10) unsigned NOT NULL auto_increment,
`address_id` int(10) unsigned NOT NULL default '0',
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`carrier` varchar(255) default NULL,
`carrier_title` varchar(255) default NULL,
`code` varchar(255) default NULL,
`method` varchar(255) default NULL,
`method_description` text,
`price` decimal(12,4) NOT NULL default '0.0000',
PRIMARY KEY (`rate_id`),
KEY `FK_SALES_QUOTE_SHIPPING_RATE_ADDRESS` (`address_id`),
CONSTRAINT `FK_SALES_QUOTE_SHIPPING_RATE_ADDRESS` FOREIGN KEY (`address_id`) REFERENCES `sales_flat_quote_address` (`address_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order` (
`entity_id` int(10) unsigned NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_set_id` smallint(5) unsigned NOT NULL default '0',
`increment_id` varchar(50) NOT NULL default '',
`parent_id` int(10) unsigned NOT NULL default '0',
`store_id` smallint(5) unsigned default NULL,
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`is_active` tinyint(1) unsigned NOT NULL default '1',
`customer_id` int(11) default NULL,
`tax_amount` decimal(12,4) NOT NULL default '0.0000',
`shipping_amount` decimal(12,4) NOT NULL default '0.0000',
`discount_amount` decimal(12,4) NOT NULL default '0.0000',
`subtotal` decimal(12,4) NOT NULL default '0.0000',
`grand_total` decimal(12,4) NOT NULL default '0.0000',
`total_paid` decimal(12,4) NOT NULL default '0.0000',
`total_refunded` decimal(12,4) NOT NULL default '0.0000',
`total_qty_ordered` decimal(12,4) NOT NULL default '0.0000',
`total_canceled` decimal(12,4) NOT NULL default '0.0000',
`total_invoiced` decimal(12,4) NOT NULL default '0.0000',
`total_online_refunded` decimal(12,4) NOT NULL default '0.0000',
`total_offline_refunded` decimal(12,4) NOT NULL default '0.0000',
`base_tax_amount` decimal(12,4) NOT NULL default '0.0000',
`base_shipping_amount` decimal(12,4) NOT NULL default '0.0000',
`base_discount_amount` decimal(12,4) NOT NULL default '0.0000',
`base_subtotal` decimal(12,4) NOT NULL default '0.0000',
`base_grand_total` decimal(12,4) NOT NULL default '0.0000',
`base_total_paid` decimal(12,4) NOT NULL default '0.0000',
`base_total_refunded` decimal(12,4) NOT NULL default '0.0000',
`base_total_qty_ordered` decimal(12,4) NOT NULL default '0.0000',
`base_total_canceled` decimal(12,4) NOT NULL default '0.0000',
`base_total_invoiced` decimal(12,4) NOT NULL default '0.0000',
`base_total_online_refunded` decimal(12,4) NOT NULL default '0.0000',
`base_total_offline_refunded` decimal(12,4) NOT NULL default '0.0000',
`subtotal_refunded` decimal(12,4) default NULL,
`subtotal_canceled` decimal(12,4) default NULL,
`tax_refunded` decimal(12,4) default NULL,
`tax_canceled` decimal(12,4) default NULL,
`shipping_refunded` decimal(12,4) default NULL,
`shipping_canceled` decimal(12,4) default NULL,
`base_subtotal_refunded` decimal(12,4) default NULL,
`base_subtotal_canceled` decimal(12,4) default NULL,
`base_tax_refunded` decimal(12,4) default NULL,
`base_tax_canceled` decimal(12,4) default NULL,
`base_shipping_refunded` decimal(12,4) default NULL,
`base_shipping_canceled` decimal(12,4) default NULL,
`subtotal_invoiced` decimal(12,4) default NULL,
`tax_invoiced` decimal(12,4) default NULL,
`shipping_invoiced` decimal(12,4) default NULL,
`base_subtotal_invoiced` decimal(12,4) default NULL,
`base_tax_invoiced` decimal(12,4) default NULL,
`base_shipping_invoiced` decimal(12,4) default NULL,
`shipping_tax_amount` decimal(12,4) default NULL,
`base_shipping_tax_amount` decimal(12,4) default NULL,
PRIMARY KEY (`entity_id`),
KEY `FK_SALES_ORDER_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_STORE` (`store_id`),
KEY `IDX_CUSTOMER` (`customer_id`),
CONSTRAINT `FK_SALE_ORDER_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `FK_SALE_ORDER_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `sales_order_datetime` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_DATETIME_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_DATETIME_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_DATETIME` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_DATETIME` FOREIGN KEY (`entity_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_DATETIME_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_DATETIME_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_decimal` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` decimal(12,4) NOT NULL default '0.0000',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_DECIMAL_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_DECIMAL_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_DECIMAL` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_DECIMAL` FOREIGN KEY (`entity_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_DECIMAL_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_DECIMAL_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_int` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` int(11) NOT NULL default '0',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_INT_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_INT_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_INT` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_INT` FOREIGN KEY (`entity_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_INT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_INT_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_text` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` text NOT NULL,
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_TEXT_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_TEXT_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_TEXT` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_TEXT` FOREIGN KEY (`entity_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_TEXT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_TEXT_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_varchar` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_VARCHAR_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_VARCHAR_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_VARCHAR` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_VARCHAR` FOREIGN KEY (`entity_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_VARCHAR_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_VARCHAR_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_entity` (
`entity_id` int(10) unsigned NOT NULL auto_increment,
`entity_type_id` smallint(8) unsigned NOT NULL default '0',
`attribute_set_id` smallint(5) unsigned NOT NULL default '0',
`increment_id` varchar(50) NOT NULL default '',
`parent_id` int(10) unsigned NOT NULL default '0',
`store_id` smallint(5) unsigned default NULL,
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`is_active` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`entity_id`),
KEY `FK_SALES_ORDER_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_ENTITY_STORE` (`store_id`),
CONSTRAINT `FK_SALES_ORDER_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALE_ORDER_ENTITY_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `sales_order_entity_datetime` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_ENTITY_DATETIME_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_ENTITY_DATETIME_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_ENTITY_DATETIME` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_ENTITY_DATETIME` FOREIGN KEY (`entity_id`) REFERENCES `sales_order_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_DATETIME_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_DATETIME_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_entity_decimal` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` decimal(12,4) NOT NULL default '0.0000',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_ENTITY_DECIMAL_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_ENTITY_DECIMAL_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_ENTITY_DECIMAL` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_ENTITY_DECIMAL` FOREIGN KEY (`entity_id`) REFERENCES `sales_order_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_DECIMAL_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_DECIMAL_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_entity_int` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` int(11) NOT NULL default '0',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_ENTITY_INT_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_ENTITY_INT_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_ENTITY_INT` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_ENTITY_INT` FOREIGN KEY (`entity_id`) REFERENCES `sales_order_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_INT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_INT_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_entity_text` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` text NOT NULL,
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_ENTITY_TEXT_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_ENTITY_TEXT_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_ENTITY_TEXT` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_ENTITY_TEXT` FOREIGN KEY (`entity_id`) REFERENCES `sales_order_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_TEXT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_TEXT_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sales_order_entity_varchar` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`value_id`),
KEY `FK_SALES_ORDER_ENTITY_VARCHAR_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_SALES_ORDER_ENTITY_VARCHAR_ATTRIBUTE` (`attribute_id`),
KEY `FK_SALES_ORDER_ENTITY_VARCHAR` (`entity_id`),
CONSTRAINT `FK_SALES_ORDER_ENTITY_VARCHAR` FOREIGN KEY (`entity_id`) REFERENCES `sales_order_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_VARCHAR_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_ORDER_ENTITY_VARCHAR_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
)
)
[4] => Array
(
[file] => /home/cluster-sites/7/c/crystalswork.com/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 274
[args] => Array
(
[0] => /home/cluster-sites/7/c/crystalswork.com/public_html/app/code/core/Mage/Sales/sql/sales_setup/mysql4-install-0.9.0.php
)
[function] => include
)
[5] => Array
(
[file] => /home/cluster-sites/7/c/crystalswork.com/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 167
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => install
[1] =>
[2] => 0.9.38
)
)
[6] => Array
(
[file] => /home/cluster-sites/7/c/crystalswork.com/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 155
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 0.9.38
)
)
[7] => Array
(
[file] => /home/cluster-sites/7/c/crystalswork.com/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 121
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[8] => Array
(
[file] => /home/cluster-sites/7/c/crystalswork.com/public_html/app/code/core/Mage/Core/Model/Config.php
[line] => 263
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[9] => Array
(
[file] => /home/cluster-sites/7/c/crystalswork.com/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 263
[function] => init
[class] => Mage_Core_Model_Config
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[10] => Array
(
[file] => /home/cluster-sites/7/c/crystalswork.com/public_html/app/Mage.php
[line] => 434
[function] => init
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] =>
[1] => store
[2] => Array
(
)
)
)
[11] => Array
(
[file] => /home/cluster-sites/7/c/crystalswork.com/public_html/app/Mage.php
[line] => 455
[function] => app
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
[2] => Array
(
)
)
)
[12] => Array
(
[file] => /home/cluster-sites/7/c/crystalswork.com/public_html/index.php
[line] => 65
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
)
)
)
[previous:Exception:private] =>
[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table 'sales_flat_quote' already exists
)
)
window.location.href = '/report/?id=1060477885642&s=default';
США - 68.178.232.56
GoDaddy.com, LLC
GoDaddy.com, LLC
HTTP/1.1 200 OK
Date: Mon, 14 Oct 2019 18:39:08 GMT
Server: Apache/2.4.39 (Unix)
X-Powered-By: PHP/7.2.19
X-Hostname: (null)
Transfer-Encoding: chunked
Content-Type: text/html; charset=UTF-8
Кнопка для анализа сайта в один клик, для установки перетащите ссылку на "Панель закладок"