junomedia
Total Posts: 140Joined: 2008-09-10
If anyones stuck here is the SQL:
-- phpMyAdmin SQL Dump -- version 2.11.9 -- http : //www.phpmyadmin.net -- Host : localhost -- Generation Time : Aug 24 , 2010 at 09 : 02 AM -- Server version : 4.1.20 -- PHP Version : 5.2.6 = 0 ; SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO" ; Database : ` zent_co_uk_system ` Table structure for table ` sales_order_entity ` 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 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' , 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 `) ENGINE = InnoDB DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC AUTO_INCREMENT = 3 ; Table structure for table ` sales_order_entity_datetime ` CREATE TABLE ` sales_order_entity_datetime ` ( value_id ` int ( 11 ) NOT NULL auto_increment , entity_type_id ` smallint ( 8 ) unsigned NOT NULL default '0' , attribute_id ` smallint ( 5 ) unsigned NOT NULL default '0' , store_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_store ` (` store_id `), KEY ` FK_sales_order_entity_datetime ` (` entity_id `) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1 ; Table structure for table ` sales_order_entity_decimal ` CREATE TABLE ` sales_order_entity_decimal ` ( value_id ` int ( 11 ) NOT NULL auto_increment , entity_type_id ` smallint ( 8 ) unsigned NOT NULL default '0' , attribute_id ` smallint ( 5 ) unsigned NOT NULL default '0' , store_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_store ` (` store_id `), KEY ` FK_sales_order_entity_decimal ` (` entity_id `) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1 ; Table structure for table ` sales_order_entity_int ` CREATE TABLE ` sales_order_entity_int ` ( value_id ` int ( 11 ) NOT NULL auto_increment , entity_type_id ` smallint ( 8 ) unsigned NOT NULL default '0' , attribute_id ` smallint ( 5 ) unsigned NOT NULL default '0' , store_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_store ` (` store_id `), KEY ` FK_sales_order_entity_int ` (` entity_id `) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 9 ; Table structure for table ` sales_order_entity_text ` CREATE TABLE ` sales_order_entity_text ` ( value_id ` int ( 11 ) NOT NULL auto_increment , entity_type_id ` smallint ( 8 ) unsigned NOT NULL default '0' , attribute_id ` smallint ( 5 ) unsigned NOT NULL default '0' , store_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_store ` (` store_id `), KEY ` FK_sales_order_entity_text ` (` entity_id `) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1 ; Table structure for table ` sales_order_entity_varchar ` CREATE TABLE ` sales_order_entity_varchar ` ( value_id ` int ( 11 ) NOT NULL auto_increment , entity_type_id ` smallint ( 8 ) unsigned NOT NULL default '0' , attribute_id ` smallint ( 5 ) unsigned NOT NULL default '0' , store_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_store ` (` store_id `), KEY ` FK_sales_order_entity_varchar ` (` entity_id `) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 5 ; Constraints for dumped tables -- Constraints for table ` sales_order_entity ` ALTER TABLE ` sales_order_entity ` ADD CONSTRAINT ` FK_sales_order_entity_store ` FOREIGN KEY (` store_id `) REFERENCES ` core_store ` (` store_id `) ON DELETE CASCADE ON UPDATE CASCADE , ADD CONSTRAINT ` FK_sales_order_entity_type ` FOREIGN KEY (` entity_type_id `) REFERENCES ` eav_entity_type ` (` entity_type_id `) ON DELETE CASCADE ON UPDATE CASCADE ; Constraints for table ` sales_order_entity_datetime ` ALTER TABLE ` sales_order_entity_datetime ` ADD CONSTRAINT ` FK_sales_order_entity_datetime ` FOREIGN KEY (` entity_id `) REFERENCES ` sales_order_entity ` (` entity_id `) ON DELETE CASCADE ON UPDATE CASCADE , ADD CONSTRAINT ` FK_sales_order_entity_datetime_attribute ` FOREIGN KEY (` attribute_id `) REFERENCES ` eav_attribute ` (` attribute_id `) ON DELETE CASCADE ON UPDATE CASCADE , ADD 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 , ADD CONSTRAINT ` FK_sales_order_entity_datetime_store ` FOREIGN KEY (` store_id `) REFERENCES ` core_store ` (` store_id `) ON DELETE CASCADE ON UPDATE CASCADE ; Constraints for table ` sales_order_entity_decimal ` ALTER TABLE ` sales_order_entity_decimal ` ADD CONSTRAINT ` FK_sales_order_entity_decimal ` FOREIGN KEY (` entity_id `) REFERENCES ` sales_order_entity ` (` entity_id `) ON DELETE CASCADE ON UPDATE CASCADE , ADD CONSTRAINT ` FK_sales_order_entity_decimal_attribute ` FOREIGN KEY (` attribute_id `) REFERENCES ` eav_attribute ` (` attribute_id `) ON DELETE CASCADE ON UPDATE CASCADE , ADD 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 , ADD CONSTRAINT ` FK_sales_order_entity_decimal_store ` FOREIGN KEY (` store_id `) REFERENCES ` core_store ` (` store_id `) ON DELETE CASCADE ON UPDATE CASCADE ; Constraints for table ` sales_order_entity_int ` ALTER TABLE ` sales_order_entity_int ` ADD CONSTRAINT ` FK_sales_order_entity_int ` FOREIGN KEY (` entity_id `) REFERENCES ` sales_order_entity ` (` entity_id `) ON DELETE CASCADE ON UPDATE CASCADE , ADD CONSTRAINT ` FK_sales_order_entity_int_attribute ` FOREIGN KEY (` attribute_id `) REFERENCES ` eav_attribute ` (` attribute_id `) ON DELETE CASCADE ON UPDATE CASCADE , ADD 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 , ADD CONSTRAINT ` FK_sales_order_entity_int_store ` FOREIGN KEY (` store_id `) REFERENCES ` core_store ` (` store_id `) ON DELETE CASCADE ON UPDATE CASCADE ; Constraints for table ` sales_order_entity_text ` ALTER TABLE ` sales_order_entity_text ` ADD CONSTRAINT ` FK_sales_order_entity_text ` FOREIGN KEY (` entity_id `) REFERENCES ` sales_order_entity ` (` entity_id `) ON DELETE CASCADE ON UPDATE CASCADE , ADD CONSTRAINT ` FK_sales_order_entity_text_attribute ` FOREIGN KEY (` attribute_id `) REFERENCES ` eav_attribute ` (` attribute_id `) ON DELETE CASCADE ON UPDATE CASCADE , ADD 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 , ADD CONSTRAINT ` FK_sales_order_entity_text_store ` FOREIGN KEY (` store_id `) REFERENCES ` core_store ` (` store_id `) ON DELETE CASCADE ON UPDATE CASCADE ; Constraints for table ` sales_order_entity_varchar ` ALTER TABLE ` sales_order_entity_varchar ` ADD CONSTRAINT ` FK_sales_order_entity_varchar ` FOREIGN KEY (` entity_id `) REFERENCES ` sales_order_entity ` (` entity_id `) ON DELETE CASCADE ON UPDATE CASCADE , ADD CONSTRAINT ` FK_sales_order_entity_varchar_attribute ` FOREIGN KEY (` attribute_id `) REFERENCES ` eav_attribute ` (` attribute_id `) ON DELETE CASCADE ON UPDATE CASCADE , ADD 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 , ADD CONSTRAINT ` FK_sales_order_entity_varchar_store ` FOREIGN KEY (` store_id `) REFERENCES ` core_store ` (` store_id `) ON DELETE CASCADE ON UPDATE CASCADE ; SET FOREIGN_KEY_CHECKS = 1 ;
Signature
Juno Media for Magento Development in the UK
