-- phpMyAdmin SQL Dump -- version 3.3.2deb1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 30, 2010 at 11:05 AM -- Server version: 5.1.41 -- PHP Version: 5.3.2-1ubuntu4.2 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `dev_pakkepartner_intranet` -- -- -------------------------------------------------------- -- -- Table structure for table `carrier` -- DROP TABLE IF EXISTS `carrier`; CREATE TABLE IF NOT EXISTS `carrier` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Dumping data for table `carrier` -- INSERT INTO `carrier` (`id`, `name`) VALUES(1, 'Post Danmark'); INSERT INTO `carrier` (`id`, `name`) VALUES(2, 'GLS'); INSERT INTO `carrier` (`id`, `name`) VALUES(3, 'BWS'); -- -------------------------------------------------------- -- -- Table structure for table `carrier_customer` -- DROP TABLE IF EXISTS `carrier_customer`; CREATE TABLE IF NOT EXISTS `carrier_customer` ( `carrier_id` int(11) NOT NULL DEFAULT '0', `customer_id` int(11) NOT NULL DEFAULT '0', `shop_carrier_id` varchar(100) DEFAULT NULL, PRIMARY KEY (`carrier_id`,`customer_id`), KEY `carrier_customer_customer_id_customer_id` (`customer_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `carrier_customer` -- INSERT INTO `carrier_customer` (`carrier_id`, `customer_id`, `shop_carrier_id`) VALUES(1, 1, '45'); INSERT INTO `carrier_customer` (`carrier_id`, `customer_id`, `shop_carrier_id`) VALUES(2, 1, '40'); -- -------------------------------------------------------- -- -- Table structure for table `customer` -- DROP TABLE IF EXISTS `customer`; CREATE TABLE IF NOT EXISTS `customer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shop_type_id` int(11) DEFAULT NULL, `name` varchar(250) DEFAULT NULL, `email_address` varchar(100) DEFAULT NULL, `phone_number` varchar(45) DEFAULT NULL, `fax_number` varchar(45) DEFAULT NULL, `tax_number` varchar(45) DEFAULT NULL, `address_line_1` varchar(100) DEFAULT NULL, `address_line_2` varchar(100) DEFAULT NULL, `post_code` varchar(10) DEFAULT NULL, `city` varchar(100) DEFAULT NULL, `country` varchar(20) DEFAULT NULL, `import_url` varchar(100) DEFAULT NULL, `import_username` varchar(100) DEFAULT NULL, `import_password` varchar(100) DEFAULT NULL, `import_order_status` varchar(100) DEFAULT NULL, `import_other_parameters` varchar(200) DEFAULT NULL, PRIMARY KEY (`id`), KEY `shop_type_id_idx` (`shop_type_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ; -- -- Dumping data for table `customer` -- INSERT INTO `customer` (`id`, `shop_type_id`, `name`, `email_address`, `phone_number`, `fax_number`, `tax_number`, `address_line_1`, `address_line_2`, `post_code`, `city`, `country`, `import_url`, `import_username`, `import_password`, `import_order_status`, `import_other_parameters`) VALUES(1, 2, 'Waveboarder.dk', 'ka@streetsurfing.dk', '31736000', NULL, '29777055', 'Svinøvej 129', NULL, '4750', 'Lundby', 'Denmark', 'http://waveboard.dk/admin/modules/importexport/export_v6.aspx', 'admin', 'fodbold', 'stateid=1', 'exportid=10&startid=0&endid=5000&incomplete=0&response=1'); INSERT INTO `customer` (`id`, `shop_type_id`, `name`, `email_address`, `phone_number`, `fax_number`, `tax_number`, `address_line_1`, `address_line_2`, `post_code`, `city`, `country`, `import_url`, `import_username`, `import_password`, `import_order_status`, `import_other_parameters`) VALUES(2, 2, 'Bobleby.dk', 'info@bobleby.dk', '41834535', NULL, '30509102', 'Dragsholmvej 8', NULL, '2720', 'Vanlase', 'Denmark', 'http://www.bobleby.dk/admin/modules/importexport/export_v6.aspx', 'picanto', 'fodbold', 'stateid=8', 'exportid=7&startid=0&endid=10000&incomplete=0&response=1'); INSERT INTO `customer` (`id`, `shop_type_id`, `name`, `email_address`, `phone_number`, `fax_number`, `tax_number`, `address_line_1`, `address_line_2`, `post_code`, `city`, `country`, `import_url`, `import_username`, `import_password`, `import_order_status`, `import_other_parameters`) VALUES(3, 2, 'Julie Sandlau webshop', 'lars@juliesandlau.com', '33933929', NULL, '26627435', 'Groennegade 10, 1.', NULL, '1107', 'Copenhagen K', 'Denmark', 'http://shop.juliesandlau.com/admin/modules/importexport/export_v6.aspx', 'js1', 'er53hs', 'stateid=1', 'exportid=1&startid=0&endid=10000&incomplete=0&response=1'); INSERT INTO `customer` (`id`, `shop_type_id`, `name`, `email_address`, `phone_number`, `fax_number`, `tax_number`, `address_line_1`, `address_line_2`, `post_code`, `city`, `country`, `import_url`, `import_username`, `import_password`, `import_order_status`, `import_other_parameters`) VALUES(14, 1, 'Ryan Valencia', 'menryan@gmail.com', '44777', '', '1111', 'address line ', 'address line 2', '1111', 'c', 'country', NULL, NULL, NULL, NULL, NULL); INSERT INTO `customer` (`id`, `shop_type_id`, `name`, `email_address`, `phone_number`, `fax_number`, `tax_number`, `address_line_1`, `address_line_2`, `post_code`, `city`, `country`, `import_url`, `import_username`, `import_password`, `import_order_status`, `import_other_parameters`) VALUES(16, 1, 'John Doe', 'john@gmail.com', '3232', '42412', '12121', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `customer` (`id`, `shop_type_id`, `name`, `email_address`, `phone_number`, `fax_number`, `tax_number`, `address_line_1`, `address_line_2`, `post_code`, `city`, `country`, `import_url`, `import_username`, `import_password`, `import_order_status`, `import_other_parameters`) VALUES(18, 3, 'Klaus', 'email@klaus.com', '2222', '', '11111', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `shop_order` -- DROP TABLE IF EXISTS `shop_order`; CREATE TABLE IF NOT EXISTS `shop_order` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customer_id` int(11) DEFAULT NULL, `shop_order_status_id` int(11) DEFAULT NULL, `original_order_id` varchar(50) DEFAULT NULL, `currency` varchar(10) DEFAULT NULL, `language` varchar(10) DEFAULT NULL, `total_tax` float(18,2) DEFAULT NULL, `total_weight` float(18,2) DEFAULT NULL, `total_price` float(18,2) DEFAULT NULL, `shop_customer_name` varchar(250) DEFAULT NULL, `shop_customer_company` varchar(250) DEFAULT NULL, `shop_customer_address_line_1` varchar(100) DEFAULT NULL, `shop_customer_address_line_2` varchar(100) DEFAULT NULL, `shop_customer_post_code` varchar(10) DEFAULT NULL, `shop_customer_city` varchar(100) DEFAULT NULL, `shop_customer_country` varchar(20) DEFAULT NULL, `shop_customer_email_address` varchar(100) DEFAULT NULL, `shop_customer_phone_number` varchar(50) DEFAULT NULL, `shop_delivery_name` varchar(250) DEFAULT NULL, `shop_delivery_company` varchar(250) DEFAULT NULL, `shop_delivery_address_line_1` varchar(100) DEFAULT NULL, `shop_delivery_address_line_2` varchar(100) DEFAULT NULL, `shop_delivery_post_code` varchar(10) DEFAULT NULL, `shop_delivery_city` varchar(100) DEFAULT NULL, `shop_delivery_country` varchar(20) DEFAULT NULL, `shop_delivery_email_address` varchar(100) DEFAULT NULL, `shop_delivery_phone_number` varchar(50) DEFAULT NULL, `payment_id` varchar(100) DEFAULT NULL, `payment_name` varchar(250) DEFAULT NULL, `original_carrier_id` varchar(100) DEFAULT NULL, `original_order_date` datetime DEFAULT NULL, `create_date` datetime DEFAULT NULL, `update_date` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `shop_order_status_id_idx` (`shop_order_status_id`), KEY `customer_id_idx` (`customer_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- Dumping data for table `shop_order` -- INSERT INTO `shop_order` (`id`, `customer_id`, `shop_order_status_id`, `original_order_id`, `currency`, `language`, `total_tax`, `total_weight`, `total_price`, `shop_customer_name`, `shop_customer_company`, `shop_customer_address_line_1`, `shop_customer_address_line_2`, `shop_customer_post_code`, `shop_customer_city`, `shop_customer_country`, `shop_customer_email_address`, `shop_customer_phone_number`, `shop_delivery_name`, `shop_delivery_company`, `shop_delivery_address_line_1`, `shop_delivery_address_line_2`, `shop_delivery_post_code`, `shop_delivery_city`, `shop_delivery_country`, `shop_delivery_email_address`, `shop_delivery_phone_number`, `payment_id`, `payment_name`, `original_carrier_id`, `original_order_date`, `create_date`, `update_date`) VALUES(1, 1, 1, '111', 'DKK', 'DK', 12.50, 1.50, 150.50, 'John Doe', NULL, 'Address Line 1', NULL, '1600', 'Vanlase', 'Denmark', 'info@johndoe.com', '123 456 7890', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Bank Transfer', '45', '2010-07-08 11:12:12', '2010-07-07 12:12:12', '2010-07-07 12:12:12'); INSERT INTO `shop_order` (`id`, `customer_id`, `shop_order_status_id`, `original_order_id`, `currency`, `language`, `total_tax`, `total_weight`, `total_price`, `shop_customer_name`, `shop_customer_company`, `shop_customer_address_line_1`, `shop_customer_address_line_2`, `shop_customer_post_code`, `shop_customer_city`, `shop_customer_country`, `shop_customer_email_address`, `shop_customer_phone_number`, `shop_delivery_name`, `shop_delivery_company`, `shop_delivery_address_line_1`, `shop_delivery_address_line_2`, `shop_delivery_post_code`, `shop_delivery_city`, `shop_delivery_country`, `shop_delivery_email_address`, `shop_delivery_phone_number`, `payment_id`, `payment_name`, `original_carrier_id`, `original_order_date`, `create_date`, `update_date`) VALUES(2, 1, 1, '112', 'DKK', 'DK', 15.50, 2.00, 200.00, 'Jane Doe', NULL, 'Address Line 1', NULL, '1600', 'Vanlase', 'Denmark', 'info@johndoe.com', '123 456 7890', 'Jane Doe', 'New Media Inc', 'Address Line 1', NULL, '1234', 'Manila', 'Philippines', 'info@johndoe.com', '999 888 77777', NULL, 'Credit Card', '45', '2010-07-07 12:12:12', '2010-07-07 12:12:12', '2010-07-07 12:12:12'); -- -------------------------------------------------------- -- -- Table structure for table `shop_order_item` -- DROP TABLE IF EXISTS `shop_order_item`; CREATE TABLE IF NOT EXISTS `shop_order_item` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shop_order_id` int(11) NOT NULL DEFAULT '0', `shop_product_id` varchar(100) DEFAULT NULL, `name` varchar(250) DEFAULT NULL, `variant` varchar(250) DEFAULT NULL, `quantity` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`,`shop_order_id`), KEY `shop_order_item_shop_order_id_shop_order_id` (`shop_order_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Dumping data for table `shop_order_item` -- INSERT INTO `shop_order_item` (`id`, `shop_order_id`, `shop_product_id`, `name`, `variant`, `quantity`) VALUES(1, 1, '1566', 'Waveboard 2', 'Extreme', 2); INSERT INTO `shop_order_item` (`id`, `shop_order_id`, `shop_product_id`, `name`, `variant`, `quantity`) VALUES(2, 2, '1566', 'Waveboard 2', 'Extreme', 2); INSERT INTO `shop_order_item` (`id`, `shop_order_id`, `shop_product_id`, `name`, `variant`, `quantity`) VALUES(3, 2, '1550D', 'Waveboard 1', 'Standard', 2); -- -------------------------------------------------------- -- -- Table structure for table `shop_order_parcel` -- DROP TABLE IF EXISTS `shop_order_parcel`; CREATE TABLE IF NOT EXISTS `shop_order_parcel` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shop_order_id` int(11) NOT NULL DEFAULT '0', `weight` int(11) DEFAULT NULL, PRIMARY KEY (`id`,`shop_order_id`), KEY `shop_order_parcel_shop_order_id_shop_order_id` (`shop_order_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Dumping data for table `shop_order_parcel` -- INSERT INTO `shop_order_parcel` (`id`, `shop_order_id`, `weight`) VALUES(2, 2, 10); INSERT INTO `shop_order_parcel` (`id`, `shop_order_id`, `weight`) VALUES(3, 2, 10); -- -------------------------------------------------------- -- -- Table structure for table `shop_order_status` -- DROP TABLE IF EXISTS `shop_order_status`; CREATE TABLE IF NOT EXISTS `shop_order_status` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(45) DEFAULT NULL, `is_default` tinyint(4) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; -- -- Dumping data for table `shop_order_status` -- INSERT INTO `shop_order_status` (`id`, `name`, `is_default`) VALUES(1, 'New', 1); INSERT INTO `shop_order_status` (`id`, `name`, `is_default`) VALUES(2, 'Packing', 0); INSERT INTO `shop_order_status` (`id`, `name`, `is_default`) VALUES(3, 'Backorder', 0); INSERT INTO `shop_order_status` (`id`, `name`, `is_default`) VALUES(4, 'Completed', 0); INSERT INTO `shop_order_status` (`id`, `name`, `is_default`) VALUES(5, 'Cancelled', 0); -- -------------------------------------------------------- -- -- Table structure for table `shop_type` -- DROP TABLE IF EXISTS `shop_type`; CREATE TABLE IF NOT EXISTS `shop_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Dumping data for table `shop_type` -- INSERT INTO `shop_type` (`id`, `name`) VALUES(1, 'Oscommerce'); INSERT INTO `shop_type` (`id`, `name`) VALUES(2, 'DanDomain'); INSERT INTO `shop_type` (`id`, `name`) VALUES(3, 'Magento'); -- -- Constraints for dumped tables -- -- -- Constraints for table `carrier_customer` -- ALTER TABLE `carrier_customer` ADD CONSTRAINT `carrier_customer_carrier_id_carrier_id` FOREIGN KEY (`carrier_id`) REFERENCES `carrier` (`id`), ADD CONSTRAINT `carrier_customer_customer_id_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`); -- -- Constraints for table `customer` -- ALTER TABLE `customer` ADD CONSTRAINT `customer_shop_type_id_shop_type_id` FOREIGN KEY (`shop_type_id`) REFERENCES `shop_type` (`id`); -- -- Constraints for table `shop_order` -- ALTER TABLE `shop_order` ADD CONSTRAINT `shop_order_customer_id_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`), ADD CONSTRAINT `shop_order_shop_order_status_id_shop_order_status_id` FOREIGN KEY (`shop_order_status_id`) REFERENCES `shop_order_status` (`id`); -- -- Constraints for table `shop_order_item` -- ALTER TABLE `shop_order_item` ADD CONSTRAINT `shop_order_item_shop_order_id_shop_order_id` FOREIGN KEY (`shop_order_id`) REFERENCES `shop_order` (`id`); -- -- Constraints for table `shop_order_parcel` -- ALTER TABLE `shop_order_parcel` ADD CONSTRAINT `shop_order_parcel_shop_order_id_shop_order_id` FOREIGN KEY (`shop_order_id`) REFERENCES `shop_order` (`id`);